Hotels, Motels, and Accommodations Database v.1.0.9

73,488 Hotels and Accommodations

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.

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

Table Schema Database Field Statistics

Field	Records	Percent	Type	Comment
id	73,488	100%	int(11)	Unique Identifier
biz_name	73,488	100%	varchar(150)	Business Name
biz_info	0	0%	text	Business Information and Description
cat_primary	73,488	100%	varchar(75)	Business Primary Category
cat_sub	67,217	91%	varchar(75)	Business Secondary/Sub Category
e_address	72,756	99%	varchar(100)	Physical Address
e_city	73,481	100%	varchar(50)	Physical Address City
e_state	73,488	100%	varchar(20)	Physical Address State / Province
e_postal	73,488	100%	varchar(7)	Physical Address Postal Code
e_zip_full	1	0%	varchar(10)	Zip +4 for US Physical Addresses
e_country	73,488	100%	varchar(20)	Physical Address Country
loc_county	73,310	100%	varchar(40)	Physical Address County
loc_area_code	73,308	100%	varchar(3)	Physical Address Area Code
loc_FIPS	73,336	100%	varchar(5)	Federal Information Processing Standard - http://www.epa.gov/enviro/html/codes/state.html
loc_MSA	28,356	39%	varchar(5)	Metropolitan Statistical Area - http://www.census.gov/population/www/metroareas/metrodef.html
loc_PMSA	18,115	25%	varchar(5)	Primary Metropolitan Statistical Area - http://www.census.gov/epcd/www/g97geo2.htm
loc_TZ	73,336	100%	varchar(6)	Location Time Zone
loc_DST	73,488	100%	enum('Y','N','U')	Daylight Savings Time (Yes, No, Unknown)
loc_LAT_centroid	73,310	100%	varchar(15)	Latitude (Centroid Based)
loc_LAT_poly	72,214	98%	varchar(15)	Latitude (Precision Polygon Based)
loc_LONG_centroid	73,310	100%	varchar(15)	Longitude (Centroid Based)
loc_LONG_poly	72,214	98%	varchar(15)	Longitude (Precision Polygon Based)
biz_phone	72,992	99%	varchar(20)	Business Phone Number
biz_phone_ext	0	0%	varchar(8)	Business Phone Number Extension
biz_fax	4,996	7%	varchar(20)	Business Fax Number
biz_email	2,066	3%	varchar(75)	Business Contact Email Address
web_url	43,560	59%	varchar(255)	Website URL
web_meta_title	6,958	9%	varchar(255)	Website Meta Title
web_meta_desc	7,315	10%	varchar(255)	Website Meta Description
web_meta_keys	6,284	9%	varchar(255)	Website Meta Keywords

Hotels and Accommodations Records Information

United States Hotels and Accommodations

704 Alaska Hotels and Accommodations
1,277 Alabama Hotels and Accommodations
1,277 Arkansas Hotels and Accommodations
1,304 Arizona Hotels and Accommodations
4,567 California Hotels and Accommodations
1,830 Colorado Hotels and Accommodations
849 Connecticut Hotels and Accommodations
298 District Of Columbia Hotels and Accommodations
182 Delaware Hotels and Accommodations
3,688 Florida Hotels and Accommodations
1,987 Georgia Hotels and Accommodations
582 Hawaii Hotels and Accommodations
1,078 Iowa Hotels and Accommodations
672 Idaho Hotels and Accommodations
1,960 Illinois Hotels and Accommodations
1,454 Indiana Hotels and Accommodations
947 Kansas Hotels and Accommodations
1,165 Kentucky Hotels and Accommodations
1,546 Louisiana Hotels and Accommodations
1,821 Massachusetts Hotels and Accommodations
1,115 Maryland Hotels and Accommodations
1,114 Maine Hotels and Accommodations
2,023 Michigan Hotels and Accommodations
1,752 Minnesota Hotels and Accommodations
1,609 Missouri Hotels and Accommodations
1,017 Mississippi Hotels and Accommodations
796 Montana Hotels and Accommodations
2,047 North Carolina Hotels and Accommodations
369 North Dakota Hotels and Accommodations
648 Nebraska Hotels and Accommodations
630 New Hampshire Hotels and Accommodations
2,340 New Jersey Hotels and Accommodations
1,075 New Mexico Hotels and Accommodations
910 Nevada Hotels and Accommodations
3,412 New York Hotels and Accommodations
2,029 Ohio Hotels and Accommodations
1,054 Oklahoma Hotels and Accommodations
1 Ontario Hotels and Accommodations
1,387 Oregon Hotels and Accommodations
2,634 Pennsylvania Hotels and Accommodations
312 Rhode Island Hotels and Accommodations
1,492 South Carolina Hotels and Accommodations
841 South Dakota Hotels and Accommodations
1,406 Tennessee Hotels and Accommodations
3,961 Texas Hotels and Accommodations
806 Utah Hotels and Accommodations
1,724 Virginia Hotels and Accommodations
757 Vermont Hotels and Accommodations
1,882 Washington Hotels and Accommodations
1,951 Wisconsin Hotels and Accommodations
596 West Virginia Hotels and Accommodations
610 Wyoming Hotels and Accommodations