Description of Database: Download a database of restaurants throughout the USA. If you are looking to market to restaurants or create an app or website dedicated to food, this is a great place to start.
List of 27 Database Fields
Unique Identifier
Business Primary Category
Business Secondary/Sub Category
Physical Address
Physical Address City
Physical Address State / Province
Physical Address Postal Code
Zip +4 for US Physical Addresses
Physical Address Country
Physical Address County
Physical Address Area Code
Federal Information Processing Standard
Metropolitan Statistical Area/
Primary Metropolitan Statistical Area
Location Time Zone
Daylight Savings Time (Yes, No, Unknown)
Latitude (Centroid Based)
Latitude (Precision Polygon Based)
Longitude (Centroid Based)
Longitude (Precision Polygon Based)
Business Name
Business Phone Number
Business Fax Number
Website URL
Website Meta Title
Website Meta Description
Website Meta Keywords
Database Field Breakdown
Below is a breakdown of all the fields in the database. For example, the database has the “Business Primary Category” for 100% of the database or 451,784 entries).
Records | Percent | Comment |
---|---|---|
451,784 | 100% | Unique Identifier |
451,784 | 100% | Business Primary Category |
416,333 | 92% | Business Secondary/Sub Category |
451,393 | 100% | Physical Address |
451,775 | 100% | Physical Address City |
451,783 | 100% | Physical Address State / Province |
451,089 | 100% | Physical Address Postal Code |
359,729 | 80% | Zip +4 for US Physical Addresses |
451,784 | 100% | Physical Address Country |
421,752 | 93% | Physical Address County |
450,852 | 100% | Physical Address Area Code |
421,707 | 93% | Federal Information Processing Standard |
176,889 | 39% | Metropolitan Statistical Area |
157,108 | 35% | Primary Metropolitan Statistical Area |
450,872 | 100% | Location Time Zone |
451,784 | 100% | Daylight Savings Time (Yes, No, Unknown) |
450,856 | 100% | Latitude (Centroid Based) |
428,181 | 95% | Latitude (Precision Polygon Based) |
450,856 | 100% | Longitude (Centroid Based) |
428,181 | 95% | Longitude (Precision Polygon Based) |
451,784 | 100% | Business Name |
444,644 | 98% | Business Phone Number |
14,859 | 3% | Business Fax Number |
192,206 | 43% | Website URL |
Geographic Breakdown
978 Alaska
8,035 Alabama
5,100 Arkansas
8,652 Arizona
30,629 California
9,151 Colorado
6,852 Connecticut
1,738 District Of Columbia
1,743 Delaware
17,410 Florida
12,340 Georgia
2,259 Hawaii
6,562 Iowa
2,841 Idaho
15,276 Illinois
10,118 Indiana
5,354 Kansas
6,744 Kentucky
8,166 Louisiana
10,807 Massachusetts
9,020 Maryland
2,678 Maine
13,085 Michigan
8,395 Minnesota
9,682 Missouri
4,860 Mississippi
2,312 Montana
11,845 North Carolina
1,541 North Dakota
3,781 Nebraska
1 New Jersey
2,408 New Hampshire
13,523 New Jersey
3,383 New Mexico
4,092 Nevada
36,211 New York
14,408 Ohio
6,552 Oklahoma
7,846 Oregon
16,005 Pennsylvania
8 Puerto Rico
2,196 Rhode Island
8,007 South Carolina
1,816 South Dakota
9,354 Tennessee
19,568 Texas
3,688 Utah
10,743 Virginia
1,310 Vermont
10,140 Washington
9,603 Wisconsin
2,967 West Virginia
1,274 Wyoming
Canada
3,088 Alberta
4,242 British Columbia
1,518 Manitoba
922 New Brunswick
400 Newfoundland And Labrador
1,034 Nova Scotia
27 Northwest Territories
6 Nunavut
6,326 Ontario
169 Prince Edward Island
10,666 Quebec
1,492 Saskatchewan
44 Yukon