What is in version 2.0.0?

The Coffee and Tea Shops Database 2.0.0 contains 146,467 selected place records in the United States and Canada. It covers coffee shops, cafes, tea rooms, and bubble tea shops. Coverage is selective, so the total is not a census of every business that serves coffee or tea. Each row describes a place rather than a unique company or owner.

How should I read the files?

The release has one places table. Its stable, opaque Oddity ID supports joins across the tier-specific CSV, JSON, and SQLite formats. Usage contains 19 documented fields, Publication contains 23, and Master contains 34. The tiers use the same 146,467-place population and add columns, not extra locations. Review the public schema and sample to choose the field set you need.

What does unverified status mean?

Of the selected places, 107,840 report open status and 38,627 have no confirmed operating status. Unverified does not mean open or closed. A limited number of older supplemental contact details are separately dated and marked unverified. If current status or contact accuracy matters, check the place directly before acting on a record.

For the current tier prices, sample, full-release field completeness, and license choices, see the Coffee and Tea Shops Database product page.

For the release overview and practical guidance, read Coffee and Tea Shops Database 2.0.0: 146,467 Selected U.S. and Canadian Places.