Description of Database: This database contains listings for auto parts and car parts stores in the United States
List of 22 Database Fields
Unique Identifier
Business Name
Business Primary Category
Business Secondary Category
Physical Address
Physical Address City
Physical Address State / Province
Physical Address Postal Code
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)
Business Phone Number
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 94,213 entries).
| Records | Percent | Comment |
|---|---|---|
| 94,213 | 100% | Unique Identifier |
| 94,213 | 100% | Business Name |
| 94,213 | 100% | Business Primary Category |
| 90,166 | 96% | Business Secondary/Sub Category |
| 93,302 | 99% | Physical Address |
| 94,207 | 100% | Physical Address City |
| 94,212 | 100% | Physical Address State / Province |
| 94,213 | 100% | Physical Address Postal Code |
| 83,768 | 89% | Zip +4 for US Physical Addresses |
| 94,213 | 100% | Physical Address Country |
| 94,208 | 100% | Physical Address County |
| 94,201 | 100% | Physical Address Area Code |
| 94,201 | 100% | Federal Information Processing Standard |
| 43,604 | 46% | Metropolitan Statistical Area |
| 25,190 | 27% | Primary Metropolitan Statistical Area |
| 94,201 | 100% | Location Time Zone |
| 94,213 | 100% | Daylight Savings Time (Yes, No, Unknown) |
| 94,201 | 100% | Latitude (Centroid Based) |
| 93,457 | 99% | Latitude (Precision Polygon Based) |
| 94,201 | 100% | Longitude (Centroid Based) |
| 93,457 | 99% | Longitude (Precision Polygon Based) |
| 94,180 | 100% | Business Phone Number |
| 38,129 | 40% | Website URL |
Geographic Breakdown
229 Alaska
2,551 Alabama
1,797 Arkansas
2,366 Arizona
5,454 California
2,282 Colorado
1,332 Connecticut
64 District Of Columbia
283 Delaware
3,858 Florida
2,969 Georgia
445 Hawaii
1,666 Iowa
941 Idaho
3,255 Illinois
2,579 Indiana
1,745 Kansas
1,941 Kentucky
2,403 Louisiana
1,958 Massachusetts
1,591 Maryland
514 Maine
3,171 Michigan
2,309 Minnesota
2,658 Missouri
1,652 Mississippi
800 Montana
2,910 North Carolina
513 North Dakota
1,082 Nebraska
493 New Hampshire
2,227 New Jersey
1,067 New Mexico
929 Nevada
2,652 New York
3,152 Ohio
2,243 Oklahoma
1,821 Oregon
2,656 Pennsylvania
327 Rhode Island
2,050 South Carolina
504 South Dakota
2,600 Tennessee
4,815 Texas
1,212 Utah
2,099 Virginia
265 Vermont
2,400 Washington
2,501 Wisconsin
660 West Virginia
443 Wyoming
