Hotels, Motels, and Accommodations Database

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, ...

Ready for your workflow

Flexible data delivery

Delivered files
UTF-8 CSV, JSON, SQLite, schemas, samples, statistics, documentation, and tier-specific ZIP bundles.
Updates
Current release 1.0.33 dated August 24, 2015. Update eligibility follows the selected license.
Preview sample data
Choose your licensePurchase once. Download immediately.
Secure checkout
Usage RightsRead-only internal use.
$60.00
Master RightsBroadest usage rights and available updates.Current update offer$15.00For eligible earlier Master purchases
$240.00
Records
84,253
Version
1.0.33
Release date
Aug 24, 2015
Before you choose
Explore the samples

Hotels, Motels, and Accommodations Database v.1.0.33

84,253 Hotels and Accommodations

Hotels, Motels, and Accommodations Database catalog icon Hotels, Motels, and Accommodations Database Download
Hotels, Motels, and Accommodations Database artwork
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.
84,253 Hotels and Accommodations Records
SAMPLE DATA TABLE STRUCTURE RECORD INFO
Funeral Homes Fitness Centers Beauty Salons Jewelry Stores Smoke Shops

License Database Purchase Options

PUBLICATION

Publication Rights

$120.00

Publish and build for clients

All Usage rights, plus customer-facing websites, apps, reports and client projects without bulk dataset handoff.

Unlimited downloads of this purchased version while it remains current. A newer public release needs a separate purchase or offered update.

Read the complete Oddity Software Publication License

Choose this package above

MASTER

Master Rights

$240.00

Client dataset handoff

All Publication rights, plus raw or transformed dataset handoff within a genuine client project. Standalone dataset resale requires a separate addendum.

Current Master update offer$15.00For an eligible earlier Master purchase. The fee is checked again when a new release is available.

Unlimited downloads of this purchased version while it remains current. A newer public release needs a separate purchase or offered update.

Read the complete Oddity Software Master License

Choose this package above

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

Release-defined structure
FieldRecordsPercentTypeComment
id84,253100%int(11)Unique Identifier
biz_name84,253100%varchar(150)Business Name
biz_info00%textBusiness Information and Description
cat_primary83,876100%varchar(75)Business Primary Category
cat_sub76,08890%varchar(75)Business Secondary/Sub Category
e_address83,26399%varchar(100)Physical Address
e_city84,252100%varchar(50)Physical Address City
e_state84,253100%varchar(20)Physical Address State / Province
e_postal84,253100%varchar(7)Physical Address Postal Code
e_zip_full10%varchar(10)Zip +4 for US Physical Addresses
e_country84,253100%varchar(20)Physical Address Country
loc_county83,80099%varchar(40)Physical Address County
loc_area_code83,79899%varchar(3)Physical Address Area Code
loc_FIPS83,82299%varchar(5)Federal Information Processing Standard - http://www.epa.gov/enviro/html/codes/state.html
loc_MSA32,04738%varchar(5)Metropolitan Statistical Area - http://www.census.gov/population/www/metroareas/metrodef.html
loc_PMSA21,26525%varchar(5)Primary Metropolitan Statistical Area - http://www.census.gov/epcd/www/g97geo2.htm
loc_TZ83,82299%varchar(6)Location Time Zone
loc_DST84,253100%enum('Y','N','U')Daylight Savings Time (Yes, No, Unknown)
loc_LAT_centroid83,80099%varchar(15)Latitude (Centroid Based)
loc_LAT_poly82,97998%varchar(15)Latitude (Precision Polygon Based)
loc_LONG_centroid83,80099%varchar(15)Longitude (Centroid Based)
loc_LONG_poly82,97998%varchar(15)Longitude (Precision Polygon Based)
biz_phone83,77299%varchar(20)Business Phone Number
biz_phone_ext00%varchar(8)Business Phone Number Extension
biz_fax4,9966%varchar(20)Business Fax Number
biz_email2,0662%varchar(75)Business Contact Email Address
web_url49,72959%varchar(255)Website URL
web_meta_title6,9588%varchar(255)Website Meta Title
web_meta_desc7,3159%varchar(255)Website Meta Description
web_meta_keys6,2847%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.

Need a closer fit?

Data shaped around your project.

Tell us your topic, geography, and required fields. We can help find a match or scope a custom package.
Discuss your data needs Explore the catalog

A clear path from download to project

Get more from your data

Understand the files, check the sample coverage, and choose the license that fits your use.

Database guides and examples Working with file formats Samples and record counts Licenses and permitted use Ask about this database

Oddity Support

How can we help?

Browse all Help topics

Oddity Data Updates

Know when fresh data arrives.

Receive occasional notices about new and substantially updated database releases. No third-party mailing list.

Oddity Software

Details