List of 23 Database Fields
Unique Identifier
Business Name
Business Primary Category
Business 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 Info. 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 29,976 entries).
| Records | Percent | Comment |
|---|---|---|
| 29,976 | 100% | Unique Identifier |
| 29,976 | 100% | Business Name |
| 491 | 2% | Business Information and Description |
| 29,976 | 100% | Business Primary Category |
| 22,227 | 74% | Business Secondary/Sub Category |
| 29,954 | 100% | Business Phone Number |
| 28,986 | 97% | Physical Address |
| 29,973 | 100% | Physical Address City |
| 29,976 | 100% | Physical Address State / Province |
| 29,866 | 100% | Physical Address Postal Code |
| 25,853 | 86% | Zip +4 for US Physical Addresses |
| 29,976 | 100% | Physical Address Country |
| 29,852 | 100% | Physical Address County |
| 29,850 | 100% | Physical Address Area Code |
| 29,851 | 100% | Federal Information Processing Standard |
| 13,489 | 45% | Metropolitan Statistical Area |
| 9,693 | 32% | Primary Metropolitan Statistical Area |
| 29,851 | 100% | Location Time Zone |
| 29,976 | 100% | Daylight Savings Time (Yes, No, Unknown) |
| 29,850 | 95% | Latitude (Centroid Based) |
| 29,976 | 100% | Latitude (Precision Polygon Based) |
| 29,850 | 100% | Longitude (Centroid Based) |
| 29,976 | 100% | Longitude (Precision Polygon Based) |
| 13,518 | 45% | Website URL |
| 379 | 1% | Website Meta Title |
| 358 | 1% | Website Meta Description |
| 356 | 1% | Website Meta Keywords |
Geographic Breakdown
85 Alaska
541 Alabama
354 Arkansas
682 Arizona
2,677 California
784 Colorado
393 Connecticut
30 District Of Columbia
85 Delaware
1,925 Florida
899 Georgia
146 Hawaii
479 Iowa
236 Idaho
1,154 Illinois
667 Indiana
495 Kansas
549 Kentucky
452 Louisiana
611 Massachusetts
590 Maryland
223 Maine
980 Michigan
594 Minnesota
746 Missouri
340 Mississippi
257 Montana
933 North Carolina
91 North Dakota
332 Nebraska
246 New Hampshire
686 New Jersey
171 New Mexico
222 Nevada
1,221 New York
1,101 Ohio
452 Oklahoma
464 Oregon
1,082 Pennsylvania
76 Rhode Island
368 South Carolina
100 South Dakota
576 Tennessee
2,271 Texas
193 Utah
773 Virginia
95 Vermont
712 Washington
608 Wisconsin
157 West Virginia
72 Wyoming
