List of 23 Database Fields
Unique Identifier
Business Name
Business Primary Category
Business Secondary/Sub Category
Business Phone Number
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) Website URL
Download Sample Data – Contains 30 entries from the database.
Database Field Breakdown
Below is a breakdown of all the fields in the database. For example, the database has the “Business Name” for 100% of the database (or 35,735 entries).
| Records | Percent | Comment |
|---|---|---|
| 35,735 | 100% | Unique Identifier |
| 35,735 | 100% | Business Name |
| 23,750 | 66% | Business Secondary/Sub Category |
| 35,678 | 100% | Business Phone Number |
| 35,732 | 100% | Physical Address City |
| 35,735 | 100% | Physical Address State / Province |
| 35,258 | 99% | Physical Address Postal Code |
| 29,404 | 82% | Zip +4 for US Physical Addresses |
| 35,735 | 100% | Physical Address Country |
| 35,238 | 99% | Physical Address County |
| 35,236 | 99% | Physical Address Area Code |
| 35,237 | 99% | Federal Information Processing Standard |
| 16,004 | 45% | Metropolitan Statistical Area |
| 11,240 | 31% | Primary Metropolitan Statistical Area |
| 35,237 | 99% | Location Time Zone |
| 35,735 | 100% | Daylight Savings Time (Yes, No, Unknown) |
| 35,236 | 99% | Latitude (Centroid Based) |
| 35,735 | 100% | Latitude (Precision Polygon Based) |
| 35,236 | 99% | Longitude (Centroid Based) |
| 35,735 | 100% | Longitude (Precision Polygon Based) |
| 15,666 | 44% | Website URL |
Geographic Breakdown
89 Alaska
671 Alabama
420 Arkansas
787 Arizona
2,987 California
956 Colorado
467 Connecticut
32 District Of Columbia
97 Delaware
2,158 Florida
1,085 Georgia
174 Hawaii
617 Iowa
258 Idaho
1,332 Illinois
761 Indiana
568 Kansas
633 Kentucky
520 Louisiana
752 Massachusetts
698 Maryland
244 Maine
1,093 Michigan
670 Minnesota
858 Missouri
384 Mississippi
276 Montana
1,027 North Carolina
98 North Dakota
386 Nebraska
266 New Hampshire
847 New Jersey
275 New Mexico
298 Nevada
1,553 New York
1,317 Ohio
629 Oklahoma
625 Oregon
1,376 Pennsylvania
120 Rhode Island
499 South Carolina
220 South Dakota
759 Tennessee
2,533 Texas
314 Utah
926 Virginia
165 Vermont
872 Washington
823 Wisconsin
225 West Virginia
120 Wyoming
