Description of Database: This database contains records for Hotels, Motels, and other overnight or extended stay accommodations throughout 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
Business Phone Number
Website URL
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, N/A)
Latitude (Centroid Based)
Latitude (Precision Polygon Based)
Longitude (Centroid Based)
Longitude (Precision Polygon Based)
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 82,984 entries).
| Records | Percent | Comment |
|---|---|---|
| 82,985 | 100% | Unique Identifier |
| 82,985 | 100% | Business Name |
| 82,985 | 100% | Business Primary Category |
| 75,356 | 91% | Business Secondary/Sub Category |
| 82,017 | 99% | Physical Address |
| 82,984 | 100% | Physical Address City |
| 82,985 | 100% | Physical Address State / Province |
| 82,985 | 100% | Physical Address Postal Code |
| 82,985 | 100% | Physical Address Country |
| 82,909 | 100% | Physical Address County |
| 82,907 | 100% | Physical Address Area Code |
| 82,931 | 100% | Federal Information Processing Standard |
| 31,720 | 38% | Metropolitan Statistical Area |
| 21,108 | 25% | Primary Metropolitan Statistical Area |
| 82,931 | 100% | Location Time Zone |
| 82,985 | 100% | Daylight Savings Time (Yes, No, Unknown) |
| 82,909 | 100% | Latitude (Centroid Based) |
| 81,711 | 98% | Latitude (Precision Polygon Based) |
| 82,909 | 100% | Longitude (Centroid Based) |
| 81,711 | 98% | Longitude (Precision Polygon Based) |
| 82,506 | 99% | Business Phone Number |
| 48,964 | 59% | Website URL |
| 6,958 | 8% | Website Meta Title |
| 7,315 | 9% | Website Meta Description |
| 6,284 | 8% | Website Meta Keywords |
Geographic Breakdown
936 Alaska
1,305 Alabama
1,402 Arkansas
1,520 Arizona
6,287 California
2,098 Colorado
867 Connecticut
304 District Of Columbia
267 Delaware
4,233 Florida
2,186 Georgia
580 Hawaii
1,127 Iowa
677 Idaho
2,349 Illinois
1,566 Indiana
1,033 Kansas
1,248 Kentucky
1,511 Louisiana
1,936 Massachusetts
1,289 Maryland
1,358 Maine
2,358 Michigan
1,991 Minnesota
1,823 Missouri
1,071 Mississippi
966 Montana
2,339 North Carolina
391 North Dakota
720 Nebraska
810 New Hampshire
2,593 New Jersey
1,138 New Mexico
992 Nevada
3,739 New York
2,344 Ohio
1,206 Oklahoma
1 Ontario
1,562 Oregon
3,047 Pennsylvania
316 Rhode Island
1,520 South Carolina
823 South Dakota
1,607 Tennessee
4,718 Texas
1,062 Utah
1,880 Virginia
866 Vermont
1,996 Washington
2,150 Wisconsin
657 West Virginia
632 Wyoming
