U.S. Clinics and Medical Facilities Database v.1.0.36
241,086 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 |
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
Table Schema Database Field Statistics
| Field | Records | Percent | Type | Comment |
|---|---|---|---|---|
| id | 241,086 | 100% | int(11) | Unique Identifier |
| biz_name | 241,086 | 100% | varchar(150) | Business Name |
| biz_info | 0 | 0% | text | Business Information and Description |
| cat_primary | 239,395 | 99% | varchar(75) | Business Primary Category |
| cat_sub | 217,764 | 90% | varchar(75) | Business Secondary/Sub Category |
| e_address | 239,552 | 99% | varchar(100) | Physical Address |
| e_city | 241,083 | 100% | varchar(50) | Physical Address City |
| e_state | 241,086 | 100% | varchar(20) | Physical Address State / Province |
| e_postal | 241,086 | 100% | varchar(7) | Physical Address Postal Code |
| e_zip_full | 187,100 | 78% | varchar(10) | Zip +4 for US Physical Addresses |
| e_country | 241,086 | 100% | varchar(20) | Physical Address Country |
| loc_county | 239,357 | 99% | varchar(40) | Physical Address County |
| loc_area_code | 239,341 | 99% | varchar(3) | Physical Address Area Code |
| loc_FIPS | 239,349 | 99% | varchar(5) | Federal Information Processing Standard - http://www.epa.gov/enviro/html/codes/state.html |
| loc_MSA | 95,542 | 40% | varchar(5) | Metropolitan Statistical Area - http://www.census.gov/population/www/metroareas/metrodef.html |
| loc_PMSA | 100,310 | 42% | varchar(5) | Primary Metropolitan Statistical Area - http://www.census.gov/epcd/www/g97geo2.htm |
| loc_TZ | 239,349 | 99% | varchar(6) | Location Time Zone |
| loc_DST | 241,086 | 100% | enum('Y','N','U') | Daylight Savings Time (Yes, No, Unknown) |
| loc_LAT_centroid | 239,343 | 99% | varchar(15) | Latitude (Centroid Based) |
| loc_LAT_poly | 240,350 | 100% | varchar(15) | Latitude (Precision Polygon Based) |
| loc_LONG_centroid | 239,343 | 99% | varchar(15) | Longitude (Centroid Based) |
| loc_LONG_poly | 240,350 | 100% | varchar(15) | Longitude (Precision Polygon Based) |
| biz_phone | 241,067 | 100% | varchar(20) | Business Phone Number |
| biz_phone_ext | 0 | 0% | varchar(8) | Business Phone Number Extension |
| biz_fax | 3,094 | 1% | varchar(20) | Business Fax Number |
| biz_email | 1,854 | 1% | varchar(75) | Business Contact Email Address |
| web_url | 42,814 | 18% | 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 | |||
|---|---|---|---|
| USA | Alaska | 670 | Clinics |
| USA | Alabama | 3,985 | Clinics |
| USA | Arkansas | 2,844 | Clinics |
| USA | Arizona | 3,628 | Clinics |
| USA | California | 20,479 | Clinics |
| USA | Colorado | 5,408 | Clinics |
| USA | Connecticut | 3,148 | Clinics |
| USA | District Of Columbia | 1,263 | Clinics |
| USA | Delaware | 706 | Clinics |
| USA | Florida | 9,798 | Clinics |
| USA | Georgia | 6,294 | Clinics |
| USA | Hawaii | 1,338 | Clinics |
| USA | Iowa | 3,805 | Clinics |
| USA | Idaho | 1,455 | Clinics |
| USA | Illinois | 10,243 | Clinics |
| USA | Indiana | 5,839 | Clinics |
| USA | Kansas | 3,485 | Clinics |
| USA | Kentucky | 3,569 | Clinics |
| USA | Louisiana | 4,563 | Clinics |
| USA | Massachusetts | 7,377 | Clinics |
| USA | Maryland | 6,798 | Clinics |
| USA | Maine | 957 | Clinics |
| USA | Michigan | 6,837 | Clinics |
| USA | Minnesota | 4,212 | Clinics |
| USA | Missouri | 6,283 | Clinics |
| USA | Mississippi | 2,777 | Clinics |
| USA | Montana | 1,187 | Clinics |
| USA | North Carolina | 5,406 | Clinics |
| USA | North Dakota | 675 | Clinics |
| USA | Nebraska | 1,994 | Clinics |
| USA | New Hampshire | 804 | Clinics |
| USA | New Jersey | 10,712 | Clinics |
| USA | New Mexico | 1,307 | Clinics |
| USA | Nevada | 1,484 | Clinics |
| USA | New York | 14,786 | Clinics |
| USA | Ohio | 9,105 | Clinics |
| USA | Oklahoma | 3,440 | Clinics |
| USA | Oregon | 3,579 | Clinics |
| USA | Pennsylvania | 12,952 | Clinics |
| USA | Rhode Island | 778 | Clinics |
| USA | South Carolina | 3,138 | Clinics |
| USA | South Dakota | 918 | Clinics |
| USA | Tennessee | 4,110 | Clinics |
| USA | Texas | 15,111 | Clinics |
| USA | Utah | 1,555 | Clinics |
| USA | Virginia | 5,863 | Clinics |
| USA | Vermont | 690 | Clinics |
| USA | Washington | 7,922 | Clinics |
| USA | Wisconsin | 3,531 | Clinics |
| USA | West Virginia | 1,698 | Clinics |
| USA | Wyoming | 580 | Clinics |
This is NOT an email marketing list
