Coffee and Tea Shops Database

Download our Coffee and Tea Shops Database List. This database contains 26,331 records of Coffee Shops locations and Coffee Shops detail records. This content tea shop database can be downloaded in CSV, MySQL and many other formats.

download database
Formats
Microsoft Access, MySQL, CSV, DBF, SQL Server & Custom

Updates
This Database is updated every 120 Days. Master License holders can purchse updates for this database for $15.00.
PUBLICATION RIGHTS
$150.00
Coffee and Tea Shops Database Content
USAGE RIGHTS (read only)
$60.00
Coffee and Tea Shops Database Content
MASTER RIGHTS
$300.00
Coffee and Tea Shops Database Content

Coffee and Tea Shops Database v.1.0.6

Download Coffee and Tea Shops Database

26,331 Coffee Shops

This database contains listing s for coffee shops in the Unites States and some in Canada. It is a nice database to pair with the Starbucks Locations Database. A coffeehouse, coffee shop, or cafe shares some of the characteristics of a bar, and some of the characteristics of a restaurant. As the name suggests, coffeehouses focus on providing coffee and tea as well as light snacks. Other food may range from baked goods to soups and sandwiches, other casual meals, and light desserts. In some countries, cafes may more closely resemble restaurants, offering a range of hot meals, and possibly being licensed to serve alcohol.

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

License Database Purchase Options

Pick the right license USAGE
RIGHTS
$60.00
 PUBLICATION
RIGHTS
$150.00
 MASTER
RIGHTS
$300.00
Data Tracking Seeds
Data Modification
Importing
Exporting
Merge
Web Usage
Multiple PC's or Websites
Mobile Development
Updates Available
All Data File Formats
Custom File Formats
Distribution
Copyright Endorsement
  BUY NOW BUY NOW BUY NOW

Table Schema Database Field Statistics

FieldRecordsPercentTypeComment
id26,331100%int(11)Unique Identifier
biz_name26,331100%varchar(150)Business Name
biz_info00%textBusiness Information and Description
cat_primary26,331100%varchar(75)Business Primary Category
cat_sub26,331100%varchar(75)Business Secondary/Sub Category
e_address26,321100%varchar(100)Physical Address
e_city26,331100%varchar(50)Physical Address City
e_state26,331100%varchar(20)Physical Address State / Province
e_postal26,303100%varchar(7)Physical Address Postal Code
e_zip_full1,1905%varchar(10)Zip +4 for US Physical Addresses
e_country26,331100%varchar(20)Physical Address Country
loc_county25,27596%varchar(40)Physical Address County
loc_area_code26,258100%varchar(3)Physical Address Area Code
loc_FIPS25,27696%varchar(5)Federal Information Processing Standard - http://www.epa.gov/enviro/html/codes/state.html
loc_MSA10,28639%varchar(5)Metropolitan Statistical Area - http://www.census.gov/population/www/metroareas/metrodef.html
loc_PMSA11,92945%varchar(5)Primary Metropolitan Statistical Area - http://www.census.gov/epcd/www/g97geo2.htm
loc_TZ26,259100%varchar(6)Location Time Zone
loc_DST26,331100%enum('Y','N','U')Daylight Savings Time (Yes, No, Unknown)
loc_LAT_centroid26,258100%varchar(15)Latitude (Centroid Based)
loc_LAT_poly26,19499%varchar(15)Latitude (Precision Polygon Based)
loc_LONG_centroid26,258100%varchar(15)Longitude (Centroid Based)
loc_LONG_poly26,19499%varchar(15)Longitude (Precision Polygon Based)
biz_phone25,52297%varchar(20)Business Phone Number
biz_phone_ext00%varchar(8)Business Phone Number Extension
biz_fax2311%varchar(20)Business Fax Number
biz_email2061%varchar(75)Business Contact Email Address
web_url20,07476%varchar(175)Website URL
web_meta_title13,67552%varchar(255)Website Meta Title
web_meta_desc13,66752%varchar(255)Website Meta Description
web_meta_keys13,66852%varchar(255)Website Meta Keywords

Coffee Shops Records Information

CANADA Coffee Shops

208 Alberta Coffee Shops
362 British Columbia Coffee Shops
46 Manitoba Coffee Shops
8 New Brunswick Coffee Shops
3 Newfoundland And Labrador Coffee Shops
9 Nova Scotia Coffee Shops
319 Ontario Coffee Shops
1 Prince Edward Island Coffee Shops
44 Quebec Coffee Shops
15 Saskatchewan Coffee Shops

United States Coffee Shops

183 Alaska Coffee Shops
216 Alabama Coffee Shops
174 Arkansas Coffee Shops
627 Arizona Coffee Shops
4,136 California Coffee Shops
772 Colorado Coffee Shops
414 Connecticut Coffee Shops
192 District Of Columbia Coffee Shops
81 Delaware Coffee Shops
1,059 Florida Coffee Shops
576 Georgia Coffee Shops
220 Hawaii Coffee Shops
225 Iowa Coffee Shops
210 Idaho Coffee Shops
1,087 Illinois Coffee Shops
429 Indiana Coffee Shops
231 Kansas Coffee Shops
214 Kentucky Coffee Shops
291 Louisiana Coffee Shops
688 Massachusetts Coffee Shops
515 Maryland Coffee Shops
186 Maine Coffee Shops
541 Michigan Coffee Shops
373 Minnesota Coffee Shops
352 Missouri Coffee Shops
121 Mississippi Coffee Shops
157 Montana Coffee Shops
532 North Carolina Coffee Shops
83 North Dakota Coffee Shops
196 Nebraska Coffee Shops
157 New Hampshire Coffee Shops
704 New Jersey Coffee Shops
204 New Mexico Coffee Shops
397 Nevada Coffee Shops
1,332 New York Coffee Shops
670 Ohio Coffee Shops
221 Oklahoma Coffee Shops
654 Oregon Coffee Shops
807 Pennsylvania Coffee Shops
129 Rhode Island Coffee Shops
233 South Carolina Coffee Shops
105 South Dakota Coffee Shops
326 Tennessee Coffee Shops
1,475 Texas Coffee Shops
213 Utah Coffee Shops
686 Virginia Coffee Shops
72 Vermont Coffee Shops
1,267 Washington Coffee Shops
365 Wisconsin Coffee Shops
138 West Virginia Coffee Shops
80 Wyoming Coffee Shops
Auto Lamp Replacement Part List