Hotels, Motels, and Accommodations Database v.1.0.33
84,253 Hotels and Accommodations
License Database Purchase Options
 |
USAGE RIGHTS $60.00 |
PUBLICATION RIGHTS $120.00 |
MASTER RIGHTS $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
| 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 |
This is NOT an email marketing list
