Hotels, Motels, and Accommodations Database v.1.0.33
84,253 Hotels and Accommodations
License Database Purchase Options
 |
USAGE RIGHTS USAGE LICENSE $60.00 |
PUBLICATION RIGHTS PUBLICATION LICENSE $120.00 |
MASTER RIGHTS MASTER LICENSE $240.00 |
| Data Tracking Seeds |  |
|
 |
| Data Modification | |
|
|
| Importing | |
|
|
| Exporting | |
|
|
| Merge | |
|
|
| Web Usage | |
|
|
| Multiple PC's or Websites | |
|
|
| Mobile Development | |
|
|
| Updates Available | |
|
|
| All Data File Formats | |
|
|
| Custom File Formats | |
|
|
| Distribution | |
|
|
| Copyright Endorsement | |
|
|
| BUY NOW | BUY NOW | BUY NOW |
This database containd stail records for Hotels, Motels, and other overnight or extended stay accommodations throughout the United States. These are defined as a place of temporary housing, a hotel may indicate the need for a new state of mind or a condition that requires a short move away from home and familiar surroundings.
Table Schema Database Field Statistics
Release structure
Hotels, Motels, and Accommodations Database
Review the published tables, record coverage, and field names included with release 1.0.33.
- Database
- #80
- Version
- 1.0.33
- Format
- XML schema
Data dictionary
Tables and fields
| Field | Records | Percent | Type | Comment |
|---|---|---|---|---|
| id | 84,253 | 100% | int(11) | Unique Identifier |
| biz_name | 84,253 | 100% | varchar(150) | Business Name |
| biz_info | 0 | 0% | text | Business Information and Description |
| cat_primary | 83,876 | 100% | varchar(75) | Business Primary Category |
| cat_sub | 76,088 | 90% | varchar(75) | Business Secondary/Sub Category |
| e_address | 83,263 | 99% | varchar(100) | Physical Address |
| e_city | 84,252 | 100% | varchar(50) | Physical Address City |
| e_state | 84,253 | 100% | varchar(20) | Physical Address State / Province |
| e_postal | 84,253 | 100% | varchar(7) | Physical Address Postal Code |
| e_zip_full | 1 | 0% | varchar(10) | Zip +4 for US Physical Addresses |
| e_country | 84,253 | 100% | varchar(20) | Physical Address Country |
| loc_county | 83,800 | 99% | varchar(40) | Physical Address County |
| loc_area_code | 83,798 | 99% | varchar(3) | Physical Address Area Code |
| loc_FIPS | 83,822 | 99% | varchar(5) | Federal Information Processing Standard - http://www.epa.gov/enviro/html/codes/state.html |
| loc_MSA | 32,047 | 38% | varchar(5) | Metropolitan Statistical Area - http://www.census.gov/population/www/metroareas/metrodef.html |
| loc_PMSA | 21,265 | 25% | varchar(5) | Primary Metropolitan Statistical Area - http://www.census.gov/epcd/www/g97geo2.htm |
| loc_TZ | 83,822 | 99% | varchar(6) | Location Time Zone |
| loc_DST | 84,253 | 100% | enum('Y','N','U') | Daylight Savings Time (Yes, No, Unknown) |
| loc_LAT_centroid | 83,800 | 99% | varchar(15) | Latitude (Centroid Based) |
| loc_LAT_poly | 82,979 | 98% | varchar(15) | Latitude (Precision Polygon Based) |
| loc_LONG_centroid | 83,800 | 99% | varchar(15) | Longitude (Centroid Based) |
| loc_LONG_poly | 82,979 | 98% | varchar(15) | Longitude (Precision Polygon Based) |
| biz_phone | 83,772 | 99% | varchar(20) | Business Phone Number |
| biz_phone_ext | 0 | 0% | varchar(8) | Business Phone Number Extension |
| biz_fax | 4,996 | 6% | varchar(20) | Business Fax Number |
| biz_email | 2,066 | 2% | varchar(75) | Business Contact Email Address |
| web_url | 49,729 | 59% | varchar(255) | Website URL |
| web_meta_title | 6,958 | 8% | varchar(255) | Website Meta Title |
| web_meta_desc | 7,315 | 9% | varchar(255) | Website Meta Description |
| web_meta_keys | 6,284 | 7% | varchar(255) | Website Meta Keywords |
| Hotels and Accommodations Records Information | |||
|---|---|---|---|
| USA | Alaska | 936 | Hotels and Accommodations |
| USA | Alabama | 1,305 | Hotels and Accommodations |
| USA | Arkansas | 1,413 | Hotels and Accommodations |
| USA | Arizona | 1,519 | Hotels and Accommodations |
| USA | California | 6,364 | Hotels and Accommodations |
| USA | Colorado | 2,101 | Hotels and Accommodations |
| USA | Connecticut | 867 | Hotels and Accommodations |
| USA | District Of Columbia | 304 | Hotels and Accommodations |
| USA | Delaware | 269 | Hotels and Accommodations |
| USA | Florida | 4,233 | Hotels and Accommodations |
| USA | Georgia | 2,257 | Hotels and Accommodations |
| USA | Hawaii | 580 | Hotels and Accommodations |
| USA | Iowa | 1,154 | Hotels and Accommodations |
| USA | Idaho | 678 | Hotels and Accommodations |
| USA | Illinois | 2,372 | Hotels and Accommodations |
| USA | Indiana | 1,575 | Hotels and Accommodations |
| USA | Kansas | 1,034 | Hotels and Accommodations |
| USA | Kentucky | 1,254 | Hotels and Accommodations |
| USA | Louisiana | 1,514 | Hotels and Accommodations |
| USA | Massachusetts | 1,937 | Hotels and Accommodations |
| USA | Maryland | 1,289 | Hotels and Accommodations |
| USA | Maine | 1,358 | Hotels and Accommodations |
| USA | Michigan | 2,399 | Hotels and Accommodations |
| USA | Minnesota | 2,017 | Hotels and Accommodations |
| USA | Missouri | 1,827 | Hotels and Accommodations |
| USA | Mississippi | 1,072 | Hotels and Accommodations |
| USA | Montana | 969 | Hotels and Accommodations |
| USA | North Carolina | 2,347 | Hotels and Accommodations |
| USA | North Dakota | 394 | Hotels and Accommodations |
| USA | Nebraska | 722 | Hotels and Accommodations |
| USA | New Hampshire | 818 | Hotels and Accommodations |
| USA | New Jersey | 2,602 | Hotels and Accommodations |
| USA | New Mexico | 1,138 | Hotels and Accommodations |
| USA | Nevada | 992 | Hotels and Accommodations |
| USA | New York | 3,861 | Hotels and Accommodations |
| USA | Ohio | 2,384 | Hotels and Accommodations |
| USA | Oklahoma | 1,231 | Hotels and Accommodations |
| USA | Oregon | 1,562 | Hotels and Accommodations |
| USA | Pennsylvania | 3,083 | Hotels and Accommodations |
| USA | Rhode Island | 361 | Hotels and Accommodations |
| USA | South Carolina | 1,537 | Hotels and Accommodations |
| USA | South Dakota | 823 | Hotels and Accommodations |
| USA | Tennessee | 1,634 | Hotels and Accommodations |
| USA | Texas | 4,779 | Hotels and Accommodations |
| USA | Utah | 1,076 | Hotels and Accommodations |
| USA | Virginia | 1,902 | Hotels and Accommodations |
| USA | Vermont | 868 | Hotels and Accommodations |
| USA | Washington | 2,081 | Hotels and Accommodations |
| USA | Wisconsin | 2,172 | Hotels and Accommodations |
| USA | West Virginia | 657 | Hotels and Accommodations |
| USA | Wyoming | 632 | Hotels and Accommodations |
Designed for business research, directory applications, mapping, and market analysis. Review permitted uses.
RECENT DATA UPDATES
U.S. and Canada Trucking, Freight and Warehousing Directory
30,695 Freight locations
v. 2.0.0
Updated Today
v. 2.0.0
Updated Today
U.S. Health Clubs, Gyms and Fitness Studios Directory
128,373 Fitness locations
v. 2.0.0
Updated Today
v. 2.0.0
Updated Today
U.S. Automobile Salvage and Wrecking Locations Database
4,179 Automotive salvage locations
v. 2.0.0
Updated Today
v. 2.0.0
Updated Today
U.S. Auto Repair, Body and Replacement Parts Locations Database
303,332 Automotive locations
v. 2.0.0
Updated Today
v. 2.0.0
Updated Today
U.S. Jewelers and Jewelry Store Locations Database
38,557 Jewelry retail locations
v. 2.0.0
Updated Yesterday
v. 2.0.0
Updated Yesterday
Custom Data Solutions
Tell us the industry, geography, fields, and format you need. We can help assemble a practical dataset for your project.
Discuss your data needs