U.S. Hospitals Database v.1.0.2

7,161 Hospitals

A general hospital is typically the major health care facility in its region, with large numbers of beds for intensive care and long-term care; and specialized facilities for surgery, plastic surgery, childbirth, bioassay laboratories, and so forth. Larger cities may have many different hospitals of varying sizes and facilities. Very large hospitals are often called Medical Centers and usually conduct operations in virtually every field of modern medicine. Types of specialized hospitals include trauma centers, children's hospitals, seniors' hospitals, and hospitals for dealing with specific medical needs such as psychiatric problems (see psychiatric hospital), pulmonary diseases, and so forth.

License Database Purchase Options

	USAGE RIGHTS $30.00	PUBLICATION RIGHTS $60.00	MASTER RIGHTS $120.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	7,161	100%	int(11)	Unique Identifier
biz_provider_id	7,159	100%	varchar(20)	Provider Identification Number
biz_name	7,161	100%	varchar(150)	Business Name
biz_info	4,644	65%	text	Business Information and Description
e_address	7,098	99%	varchar(100)	Physical Address
e_city	7,161	100%	varchar(50)	Physical Address City
e_state	7,161	100%	varchar(20)	Physical Address State / Province
e_postal	7,124	99%	varchar(7)	Physical Address Postal Code
e_zip_full	6,169	86%	varchar(10)	Zip +4 for US Physical Addresses
e_country	7,161	100%	varchar(20)	Physical Address Country
loc_county	7,115	99%	varchar(40)	Physical Address County
loc_area_code	7,115	99%	varchar(3)	Physical Address Area Code
loc_FIPS	7,115	99%	varchar(5)	Federal Information Processing Standard - http://www.epa.gov/enviro/html/codes/state.html
loc_MSA	2,547	36%	varchar(5)	Metropolitan Statistical Area - http://www.census.gov/population/www/metroareas/metrodef.html
loc_PMSA	1,707	24%	varchar(5)	Primary Metropolitan Statistical Area - http://www.census.gov/epcd/www/g97geo2.htm
loc_TZ	7,115	99%	varchar(6)	Location Time Zone
loc_DST	7,161	100%	enum('Y','N','U')	Daylight Savings Time (Yes, No, Unknown)
loc_LAT_centroid	7,115	99%	varchar(15)	Latitude (Centroid Based)
loc_LAT_poly	6,967	97%	varchar(15)	Latitude (Precision Polygon Based)
loc_LONG_centroid	7,115	99%	varchar(15)	Longitude (Centroid Based)
loc_LONG_poly	6,967	97%	varchar(15)	Longitude (Precision Polygon Based)
biz_phone	7,158	100%	varchar(20)	Business Phone Number
web_url	3,339	47%	varchar(255)	Website URL
web_meta_title	97	1%	varchar(255)	Website Meta Title
web_meta_desc	50	1%	varchar(255)	Website Meta Description
web_meta_keys	51	1%	varchar(255)	Website Meta Keywords
biz_owner	4,644	65%	varchar(255)	Ownership Information
f_emergency	4,644	65%	varchar(20)	Emergency Services Flag
biz_bedcount	5,464	76%	int(11)	Bed Count

Hospitals Records Information

PUERTO RICO Hospitals

1 Puerto Rico Hospitals

US VIRGIN ISLANDS Hospitals

1 Virgin Islands Hospitals

USA Hospitals

32 Alaska Hospitals
132 Alabama Hospitals
110 Arkansas Hospitals
103 Arizona Hospitals
499 California Hospitals
104 Colorado Hospitals
51 Connecticut Hospitals
18 District Of Columbia Hospitals
10 Delaware Hospitals
287 Florida Hospitals
220 Georgia Hospitals
3 Guam Hospitals
33 Hawaii Hospitals
143 Iowa Hospitals
53 Idaho Hospitals
251 Illinois Hospitals
167 Indiana Hospitals
178 Kansas Hospitals
141 Kentucky Hospitals
190 Louisiana Hospitals
131 Massachusetts Hospitals
85 Maryland Hospitals
56 Maine Hospitals
180 Michigan Hospitals
176 Minnesota Hospitals
174 Missouri Hospitals
127 Mississippi Hospitals
76 Montana Hospitals
172 North Carolina Hospitals
58 North Dakota Hospitals
115 Nebraska Hospitals
38 New Hampshire Hospitals
111 New Jersey Hospitals
70 New Mexico Hospitals
48 Nevada Hospitals
299 New York Hospitals
229 Ohio Hospitals
176 Oklahoma Hospitals
72 Oregon Hospitals
296 Pennsylvania Hospitals
107 Puerto Rico Hospitals
17 Rhode Island Hospitals
107 South Carolina Hospitals
75 South Dakota Hospitals
176 Tennessee Hospitals
630 Texas Hospitals
67 Utah Hospitals
143 Virginia Hospitals
1 Virgin Islands Hospitals
22 Vermont Hospitals
114 Washington Hospitals
172 Wisconsin Hospitals
80 West Virginia Hospitals
34 Wyoming Hospitals