U.S. Clinics and Medical Facilities Database v.1.0.10

147,978 Clinics

A clinic or outpatient clinic is a small medical facility that provides health care for ambulatory patients - as opposed to inpatients treated in a hospital. Most clinics are run by one or more general practitioners but there are clinics operated by private corporations, government organizations or hospitals. This database contains listings for All Clinics filed under the main Clinics SIC code such as Dental Clinics, Veterinary Clinics, Free Clinics, Chiropractic Clinics, and Medical Clinics

License Database Purchase Options

	USAGE RIGHTS $150.00	PUBLICATION RIGHTS $400.00	MASTER RIGHTS $800.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	147,978	100%	int(11)	Unique Identifier
biz_name	147,978	100%	varchar(150)	Business Name
biz_info	0	0%	text	Business Information and Description
cat_primary	147,978	100%	varchar(75)	Business Primary Category
cat_sub	141,127	95%	varchar(75)	Business Secondary/Sub Category
e_address	147,530	100%	varchar(100)	Physical Address
e_city	147,976	100%	varchar(50)	Physical Address City
e_state	147,978	100%	varchar(20)	Physical Address State / Province
e_postal	147,978	100%	varchar(7)	Physical Address Postal Code
e_zip_full	132,836	90%	varchar(10)	Zip +4 for US Physical Addresses
e_country	147,978	100%	varchar(20)	Physical Address Country
loc_county	147,953	100%	varchar(40)	Physical Address County
loc_area_code	147,934	100%	varchar(3)	Physical Address Area Code
loc_FIPS	147,942	100%	varchar(5)	Federal Information Processing Standard - http://www.epa.gov/enviro/html/codes/state.html
loc_MSA	63,135	43%	varchar(5)	Metropolitan Statistical Area - http://www.census.gov/population/www/metroareas/metrodef.html
loc_PMSA	49,476	33%	varchar(5)	Primary Metropolitan Statistical Area - http://www.census.gov/epcd/www/g97geo2.htm
loc_TZ	147,942	100%	varchar(6)	Location Time Zone
loc_DST	147,978	100%	enum('Y','N','U')	Daylight Savings Time (Yes, No, Unknown)
loc_LAT_centroid	147,936	100%	varchar(15)	Latitude (Centroid Based)
loc_LAT_poly	147,242	100%	varchar(15)	Latitude (Precision Polygon Based)
loc_LONG_centroid	147,936	100%	varchar(15)	Longitude (Centroid Based)
loc_LONG_poly	147,242	100%	varchar(15)	Longitude (Precision Polygon Based)
biz_phone	147,972	100%	varchar(20)	Business Phone Number
biz_phone_ext	0	0%	varchar(8)	Business Phone Number Extension
biz_fax	3,094	2%	varchar(20)	Business Fax Number
biz_email	1,854	1%	varchar(75)	Business Contact Email Address
web_url	24,382	16%	varchar(175)	Website URL
web_meta_title	719	0%	varchar(255)	Website Meta Title
web_meta_desc	93	0%	varchar(255)	Website Meta Description
web_meta_keys	698	0%	varchar(255)	Website Meta Keywords

Clinics Records Information

Argentina Clinics

1 Arkansas Clinics

CANADA Clinics

1 Ontario Clinics

Italy Clinics

1 Michigan Clinics

Malta Clinics

1 Ohio Clinics

United States Clinics

493 Alaska Clinics
3,076 Alabama Clinics
2,678 Arkansas Clinics
2,990 Arizona Clinics
9,103 California Clinics
3,179 Colorado Clinics
2,305 Connecticut Clinics
644 District Of Columbia Clinics
580 Delaware Clinics
5,753 Florida Clinics
4,232 Georgia Clinics
538 Hawaii Clinics
3,129 Iowa Clinics
1,016 Idaho Clinics
6,226 Illinois Clinics
3,928 Indiana Clinics
3,018 Kansas Clinics
2,530 Kentucky Clinics
2,971 Louisiana Clinics
3,536 Massachusetts Clinics
4,116 Maryland Clinics
798 Maine Clinics
4,532 Michigan Clinics
3,350 Minnesota Clinics
4,413 Missouri Clinics
2,466 Mississippi Clinics
974 Montana Clinics
3,827 North Carolina Clinics
662 North Dakota Clinics
1,576 Nebraska Clinics
573 New Hampshire Clinics
4,583 New Jersey Clinics
894 New Mexico Clinics
1,132 Nevada Clinics
8,270 New York Clinics
5,229 Ohio Clinics
3,053 Oklahoma Clinics
2,204 Oregon Clinics
6,855 Pennsylvania Clinics
452 Rhode Island Clinics
2,398 South Carolina Clinics
848 South Dakota Clinics
3,257 Tennessee Clinics
6,076 Texas Clinics
1,300 Utah Clinics
3,300 Virginia Clinics
436 Vermont Clinics
3,765 Washington Clinics
2,953 Wisconsin Clinics
1,287 West Virginia Clinics
470 Wyoming Clinics