Coffee and Tea Shops Database

Explore 146,467 selected U.S. and Canadian coffee shops, cafes, tea rooms, and bubble tea shops in CSV, JSON, and SQLite.

Ready for your workflow

Flexible data delivery

Delivered files
UTF-8 CSV, JSON, SQLite, schemas, samples, statistics, documentation, and tier-specific ZIP bundles.
Updates
Current release 2.0.0 dated October 18, 2026. Update eligibility follows the selected license.
Preview sample data
Choose your licensePurchase once. Download immediately.
Secure checkout
Coffee and Tea Places DirectoryCoffee and Tea Places Directory: 19 documented fields in matching CSV, JSON and SQLite.
$40.00
Complete Coffee and Tea Places DataComplete Coffee and Tea Places Data: 34 documented fields in matching CSV, JSON and SQLite.Current update offer$10.00For eligible earlier Master purchases
$120.00
Records
146,467
Version
2.0.0
Release date
Oct 18, 2026
Before you choose
Explore the samples

Current release story

Latest update

Version 2.0.0 October 18, 2026 Build #176

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

Version 2.0.0 brings 146,467 selected U.S. and Canadian coffee shops, cafes, tea rooms, and bubble tea shops into documented CSV, JSON, and SQLite packages. Compare three field tiers, review the sample, and see where status and contact details need verification.

Read the update announcement Release questions and guidance
Coffee and Tea Shops Database List

Coffee and Tea Shops Database v.2.0.0

146,467 Coffee Shops

Coffee and Tea Shops Database catalog icon Coffee and Tea Shops Database Download
Coffee and Tea Shops Database artwork

A selective U.S. and Canadian directory

Explore 146,467 listed places across the U.S. and Canada, including coffee shops, cafes, tea rooms, and bubble tea shops. Coverage is selective and is not a complete census. Each row describes a place, not a unique company or owner. A stable, opaque Oddity ID supports record joins.

Choose a license tier

Coffee and Tea Places Directory ($40, Usage) includes names, categories, location details, confidence, and status fields. Coffee and Tea Places for Publication ($80, Publication) adds phone, email, website, and social fields for customer-facing publications and services. Complete Coffee and Tea Places Data ($120, Master) includes all documented fields.

Understand status and historical contacts

107,840 records report open status and 38,627 have status marked unverified. Unverified does not mean open or closed. A limited number of historical supplemental contacts are dated 2015-08-22 and marked unverified. Field availability varies.

Review the sample and schema before choosing a tier. Verify contact details before operational use.

146,467 Coffee Shops Records
SAMPLE DATA TABLE STRUCTURE RECORD INFO
Restaurants Drink Recipes Bars and Pubs Recipes Restaurant Profiles Starbucks

License Database Purchase Options

USAGE

Coffee and Tea Places Directory

$40.00

Internal work

Import, modify, combine and analyze within one organization, including work by supervised contractors.

Unlimited downloads of this purchased version while it remains current. A newer public release needs a separate purchase or offered update.

Read the complete Oddity Software Usage License

Choose this package above

PUBLICATION

Coffee and Tea Places for Publication

$80.00

Publish and build for clients

All Usage rights, plus customer-facing websites, apps, reports and client projects without bulk dataset handoff.

Unlimited downloads of this purchased version while it remains current. A newer public release needs a separate purchase or offered update.

Read the complete Oddity Software Publication License

Choose this package above

MASTER

Complete Coffee and Tea Places Data

$120.00

Client dataset handoff

All Publication rights, plus raw or transformed dataset handoff within a genuine client project. Standalone dataset resale requires a separate addendum.

Current Master update offer$10.00For an eligible earlier Master purchase. The fee is checked again when a new release is available.

Unlimited downloads of this purchased version while it remains current. A newer public release needs a separate purchase or offered update.

Read the complete Oddity Software Master License

Choose this package above

Table Schema Database Field Statistics

Release structure

Coffee and Tea Shops Database

Review the published tables, record coverage, and field names included with release 2.0.0.

Database
#254
Version
2.0.0
Format
XML schema

Data dictionary

Tables and fields

Release-defined structure
TableRecordsFields
places146467oddity_id, schema_version, name, brand_name, primary_category, category_hierarchy_json, alternate_categories_json, confidence, operating_status, operating_status_missing, street_address, city, region, postal_code, country_code, bbox_west, bbox_south, bbox_east, bbox_north, phones_json, emails_json, websites_json, socials_json, supplemental_business_info, supplemental_category_detail, supplemental_phone, supplemental_fax, supplemental_email, supplemental_website, supplemental_meta_title, supplemental_meta_description, supplemental_meta_keywords, supplemental_record_vintage, supplemental_record_unverified

Release at a glance

What is inside this database

Review verified record totals, geographic coverage, classifications, and field completeness for Coffee and Tea Shops Database.

146,467Places

Table and column statistics

Select a table to review its schema, record total and fields. Distinct counts exclude nulls. Missing counts include null and blank values where measured.

places146,467 records · 34 fields
oddity_id
Distinct
146,467
Missing
0 (0.0%)
schema_version
Distinct
1
Missing
0 (0.0%)
name
Distinct
84,258
Missing
0 (0.0%)
brand_name
Distinct
2,539
Missing
105,443 (72.0%)
primary_category
Distinct
4
Missing
0 (0.0%)
category_hierarchy_json
Distinct
4
Missing
0 (0.0%)
alternate_categories_json
Distinct
3
Missing
0 (0.0%)
confidence
Distinct
42,061
Missing
0 (0.0%)
operating_status
Distinct
2
Missing
0 (0.0%)
operating_status_missing
Distinct
2
Missing
0 (0.0%)
street_address
Distinct
131,792
Missing
2,220 (1.5%)
city
Distinct
12,299
Missing
507 (0.3%)
region
Distinct
70
Missing
259 (0.2%)
postal_code
Distinct
57,203
Missing
2,432 (1.7%)
country_code
Distinct
2
Missing
0 (0.0%)
bbox_west
Distinct
141,601
Missing
0 (0.0%)
bbox_south
Distinct
142,530
Missing
0 (0.0%)
bbox_east
Distinct
141,625
Missing
0 (0.0%)
bbox_north
Distinct
142,580
Missing
0 (0.0%)
phones_json
Distinct
126,631
Missing
0 (0.0%)
emails_json
Distinct
50,869
Missing
0 (0.0%)
websites_json
Distinct
101,110
Missing
0 (0.0%)
socials_json
Distinct
103,487
Missing
0 (0.0%)
supplemental_business_info
Distinct
0
Missing
146,467 (100.0%)
supplemental_category_detail
Distinct
9
Missing
144,192 (98.4%)
supplemental_phone
Distinct
40
Missing
146,427 (100.0%)
supplemental_fax
Distinct
13
Missing
146,454 (100.0%)
supplemental_email
Distinct
6
Missing
146,461 (100.0%)
supplemental_website
Distinct
21
Missing
146,443 (100.0%)
supplemental_meta_title
Distinct
6
Missing
146,461 (100.0%)
supplemental_meta_description
Distinct
4
Missing
146,463 (100.0%)
supplemental_meta_keywords
Distinct
4
Missing
146,463 (100.0%)
supplemental_record_vintage
Distinct
1
Missing
144,192 (98.4%)
supplemental_record_unverified
Distinct
2
Missing
0 (0.0%)

Inspect the data

Representative sample data

Switch tables to review representative fields and rows from every table advertised for this release.

placesDownload this sample CSV
oddity_idschema_versionnamebrand_nameprimary_categorycategory_hierarchy_jsonalternate_categories_jsonconfidenceoperating_statusoperating_status_missingstreet_addresscityregionpostal_codecountry_codebbox_westbbox_southbbox_eastbbox_north
76a50cf7-1be5-478f-9537-1123e406914d2.0.0Branch Cafe & Marketcafe["food_and_drink","casual_eatery","cafe"][]0.9902192950248718openfalse100 E Jackson StCarbondaleIL62901US-89.2160339355468837.72860336303711-89.2160186767578137.72861099243164
72f3dc04-dbeb-4b36-b0aa-b2e3727525012.0.0Queen Bean Caffecafe["food_and_drink","casual_eatery","cafe"][]0.9333486557006836openfalse12045 5th StYucaipaCA92399US-117.0559463500976634.03476333618164-117.055931091308634.034767150878906
fa01bfdf-be65-4101-8cb7-b472464b97f62.0.0Dollop Coffee Co.Dollop Coffee Companycafe["food_and_drink","casual_eatery","cafe"][]0.9902192950248718openfalse860 N Dewitt PlChicagoIL60611-1721US-87.6204376220703141.89857864379883-87.6204223632812541.898582458496094
5e1d40d6-b838-4047-bb36-48ef0384e9d72.0.0Coffee Corralcafe["food_and_drink","casual_eatery","cafe"][]0.9199122190475464openfalse700 SW 30th StCorvallisOR97331US-123.285766601562544.560604095458984-123.2857513427734444.560611724853516
aad7c54e-6178-418f-8ca8-9002ce88e9ee2.0.0Roasting Rabbi Coffeecoffee_shop["food_and_drink","non_alcoholic_beverage_venue","coffee_shop"][]0.7152755260467529unverifiedtrue3601 Old Capitol TrlWilmingtonDE19808-6042US-75.6330413818359439.73067855834961-75.633033752441439.73068618774414
c3447aad-7eb4-4b3e-aa6e-23607351d1ba2.0.0The Flying Biscuit CafeFlying Biscuit Cafe - Midtowncafe["food_and_drink","casual_eatery","cafe"][]0.9999625207781792openfalse656 S Main St #100GreenvilleSC29601US-82.403953552246134.84470748901367-82.4039382934570334.84471130371094
c9f6c02e-c7a5-4bf4-ba67-ceebf86dc00f2.0.0CafeXXIXcafe["food_and_drink","casual_eatery","cafe"][]0.8455143052339554unverifiedtrue29 Toronto St SUxbridgeONL9P 1V9CA-79.1226959228515644.107669830322266-79.122680664062544.1076774597168
06c45fcf-1d61-45db-a135-c65903a4d3cd2.0.0The Historic Bicknell Theatercafe["food_and_drink","casual_eatery","cafe"][]0.9199122190475464openfalse11 E Main StBicknellUT84715-7750US-111.5440826416015638.340816497802734-111.544067382812538.3408203125
b591ece4-43b9-490b-a0c8-c09d5d5825d22.0.0Maple Creamery Cafe & Marketcafe["food_and_drink","casual_eatery","cafe"][]0.9199122190475464openfalse322b NH-104New HamptonNH03256US-71.6374206542968843.61770248413086-71.6374130249023443.617706298828125
20330a99-1415-4ce6-a48b-04e70cc305e42.0.0Legal Groundscafe["food_and_drink","casual_eatery","cafe"][]0.9626645445823669openfalse170 Grand StJersey CityNJ07302US-74.0415344238281240.71580505371094-74.0415191650390640.7158088684082
4d292ae3-d503-41a6-ba59-148d017a7af72.0.0Dunkin'Dunkin'coffee_shop["food_and_drink","non_alcoholic_beverage_venue","coffee_shop"][]0.789500892162323openfalse475 Union AveBridgewaterNJ08807US-74.5739669799804740.569610595703125-74.5739593505859440.56961441040039
84f90362-4a75-4cc0-ac35-8118b70eca252.0.0Corner Roastcoffee_shop["food_and_drink","non_alcoholic_beverage_venue","coffee_shop"][]0.6623184084892273unverifiedtrue1 Skytop LdgSkytopPA18357-1001US-75.2393417358398441.22792434692383-75.2393341064453141.227928161621094
42816d4d-0a0a-4953-acd0-199067b4a33f2.0.0Peet's Coffee and Teacoffee_shop["food_and_drink","non_alcoholic_beverage_venue","coffee_shop"][]0.77unverifiedtrue7401 W Lawrence AveHarwood HeightsIL60706US-87.8129348754882841.96550369262695-87.8129196166992241.965511322021484
89951ff4-b749-49ce-ba83-b02a97751a232.0.0Huntley Cafecafe["food_and_drink","casual_eatery","cafe"][]0.9756126999855042openfalse16978 315th AveHuntleyMN56047US-94.2373123168945343.73126983642578-94.2372970581054743.73127746582031
b5aa0dc2-ebb7-44ba-ba2e-b573e5eeb56e2.0.0Julep Cuptea_room["food_and_drink","non_alcoholic_beverage_venue","tea_room"][]0.9199122190475464openfalse111 Woodland AveLexingtonKY40502US-84.4900360107421938.039363861083984-84.4900207519531238.039371490478516
aed61f04-7b73-4acc-9d25-f9107d6acf682.0.0Faye's Cafecafe["food_and_drink","casual_eatery","cafe"][]0.9530794620513916openfalse415 E Lewis StLivingstonMT59047US-110.5552597045898445.662601470947266-110.5552444458007845.6626091003418
34509d4a-5a8e-444e-94a5-d8d6b61339c02.0.0StarbucksStarbuckscoffee_shop["food_and_drink","non_alcoholic_beverage_venue","coffee_shop"][]0.999023251503706openfalse3755 Spring Mountain RdLas VegasNV89102US-115.1895141601562536.126190185546875-115.1894989013671936.12619400024414
0c5fccae-3536-435c-9543-4a01128047392.0.0Riji Cafecafe["food_and_drink","casual_eatery","cafe"][]0.9380136132240295openfalse1155 Taraval StSan FranciscoCA94116US-122.4787139892578137.74275588989258-122.4786987304687537.74276351928711
71a96ea3-0812-4cf5-afab-22b1063876c12.0.0Heritage Trail Cafe And Coffee Roastercoffee_shop["food_and_drink","non_alcoholic_beverage_venue","coffee_shop"][]0.65openfalse206 N Sale StEllettsvilleIN47429-1424US-86.6238403320312539.23440933227539-86.6238250732421939.234413146972656
f40f3d71-1c02-40b9-bc28-7463d10b8b162.0.0McCaféMcCafécoffee_shop["food_and_drink","non_alcoholic_beverage_venue","coffee_shop"]["cafe","coffee_roastery"]0.954unverifiedtrue3045 Pembina Hwy SouthWinnipegMBR3T 5H5CA-97.1575317382812549.78131866455078-97.1575164794921949.78132629394531

146,467 place records across the U.S. and Canada (126,617 U.S. and 19,850 Canada). One row represents one listed place, not a unique company or owner. Coverage is selective and incomplete.

Designed for business research, directory applications, mapping, and market analysis. Review permitted uses.

Need a closer fit?

Data shaped around your project.

Tell us your topic, geography, and required fields. We can help find a match or scope a custom package.
Discuss your data needs Explore the catalog

A clear path from download to project

Get more from your data

Understand the files, check the sample coverage, and choose the license that fits your use.

Coffee and Tea Shops Database release guide Database guides and examples Working with file formats Samples and record counts Licenses and permitted use Ask about this database

Oddity Support

How can we help?

Browse all Help topics

Oddity Data Updates

Know when fresh data arrives.

Receive occasional notices about new and substantially updated database releases. No third-party mailing list.

Oddity Software

Details