Coffee and Tea Shops Database 2.0.0: 146,467 Selected U.S. and Canadian Places

A wider look at coffee and tea places

The Coffee and Tea Shops Database has been updated to version 2.0.0. This release contains 146,467 selected place records across the United States and Canada. It covers coffee shops, cafes, tea rooms, and bubble tea shops. The collection is designed for people who need a structured starting point for research, mapping, local discovery, publishing, or business systems. It is selective coverage, not a complete census of every place serving coffee or tea.

Each row represents a listed place. A chain with many locations can therefore appear many times, while one independently operated shop appears as one place. The count does not represent a count of unique companies or owners. That distinction matters when estimating market size, planning outreach, or comparing regions. Use the location fields and the sample to decide whether the release fits the question you are trying to answer.

What the new release contains

The release includes 126,617 selected U.S. places and 19,850 selected Canadian places. Names, categories, address and region fields, confidence, and operating status are organized in a consistent place table. The categories focus on four primary types: coffee shop, cafe, tea room, and bubble tea shop. A location can still have additional categories, so the primary category gives you a practical first filter without flattening all of the ways a place may describe itself.

The data includes 107,840 places that report open status. Another 38,627 have no confirmed operating status and are explicitly marked unverified. Unverified is not a synonym for open, and it is not a claim that a business has closed. If a current operating status is important to your work, check the place directly before acting on it. Place names, contact details, and hours can change after any release. Treat the directory as a documented dataset that supports verification, not as a guarantee about a shop on the day you use it.

There are also a limited number of historical supplemental contact details for places confidently matched to an earlier Oddity release. Those supplemental values carry their historical date and are marked unverified. They are included to preserve useful context for matching places, not to present an older phone number or website as a fresh observation. Current contact values take precedence where available. This distinction is visible in the documented Master fields and is especially relevant if you use the data for contact research.

One place ID across the available formats

Every place has a stable, opaque Oddity ID. It lets you join rows across exports, retain your own notes, and compare an existing local table with this release without relying on a business name as a key. Names can be duplicated or changed; an ID is a more dependable reference within the release. The identifier describes the place record and does not claim to identify a corporate parent.

The customer packages include CSV, JSON, and SQLite. CSV works well when you want to inspect rows in a spreadsheet or import them into a common data tool. JSON preserves structured category and contact groupings for application code. SQLite gives you a ready-to-query local database without setting up a server. The formats are intended to express the same tier-specific field values, so you can choose the one that suits the workflow rather than choosing a different dataset.

Before purchasing, open the public sample and schema on the product page. The sample shows representative records, while the schema explains each field, its type, and how often it is populated. A missing value is left missing rather than guessed. The page also lists distinct and missing counts for published fields, which can help you evaluate whether a particular contact or location column will be useful in your project. Those counts describe the full release, not merely the small sample.

Choose the field set that matches the job

The Usage tier, Coffee and Tea Places Directory, is $40 and includes 19 documented fields. It is the compact place and location set: names, category information, location details, confidence, and operating status fields. It fits internal research, local analysis, and workflows that do not need the broader contact and supplemental fields.

The Publication tier, Coffee and Tea Places for Publication, is $80 and includes 23 documented fields. It adds phone, email, website, and social fields to the Usage set. This is the practical choice when a customer-facing directory or publication needs those documented contact columns. Field availability varies from place to place, so review the schema counts and sample rather than assuming every row has every contact method.

The Master tier, Complete Coffee and Tea Places Data, is $120 and includes all 34 documented fields. It extends the Publication set with the dated supplemental business and contact fields. Those historical supplements are labeled so they can be evaluated separately from current values. The tiers are cumulative field sets over the same 146,467 place population. A higher tier does not add hidden extra locations; it adds documented columns.

All three tiers are delivered as protected, tier-specific ZIP packages. The product page shows the current license choices and an eligible prior-Master version update offer where applicable. Existing customer rights are governed by the terms recorded with their purchases. The availability of an update offer does not turn an earlier purchase into an automatic entitlement to this version.

How to put the directory to work

Start with a question. A publisher might map coffee and tea categories within a region, then check individual listings before displaying them. An analyst might group selected places by city or region, compare the distribution of coffee shops and tea rooms, and annotate the resulting records with independent research. A developer might import SQLite into an internal dashboard or use JSON to seed a location search interface. Each of these uses benefits from the same basic discipline: understand the row grain, decide which fields matter, and keep an explicit distinction between observed and unverified information.

If you are building a directory, do not treat a blank contact field as a broken record. It means the release does not supply that value for that place. A category can also be a starting point rather than a final editorial label. You can use the included fields to create your own display rules, but your site should not imply that the dataset is an exhaustive list of businesses. Review a sample of places in each target region before committing to a product design or coverage claim.

If you plan to combine this release with another table, keep the Oddity ID in your working data. It supports traceable updates and joins without making names or address text do double duty as identifiers. Preserve operating status and the historical-unverified flags as separate data rather than merging them into a simple yes-or-no field. That choice makes later corrections easier and prevents uncertainty from being hidden in a dashboard or export.

Review the release

The version 2.0.0 product page includes the coverage summary, tier comparison, representative sample, field schema, and full-release column statistics. You can inspect those details before selecting a license. When a project depends on live status, accurate contacts, or a precise local census, plan to verify individual places and supplement the release with current local evidence. The directory gives you a structured foundation and a clear account of its limits, so you can decide where further checking is worth your time.

Explore the Coffee and Tea Shops Database.