Description of database: 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.
List of 22 Database Fields
Unique Identifier
Business Name
Business Primary Category
Business Secondary/Sub Category
Physical Address
Physical Address City
Physical Address State
Physical Address Postal Code
Physical Address Country
Physical Address County
Physical Address Area Code
Federal Information Processing Standard
Metropolitan Statistical Area
Primary Metropolitan Statistical Area
Location Time Zone
Daylight Savings Time
Latitude (Centroid Based)
Latitude (Precision Polygon Based)
Longitude (Centroid Based)
Longitude (Precision Polygon Based)
Business Phone Number
Website URL
[box type=”download”]Download Sample Data – Contains 30 entries from the database. [/box]
Database Field Breakdown
Below is a breakdown of all the fields in the database. For example, the database has the “Business Name” for 100% of the database (or 241,086 entries).
| Records | Percent | Comment |
|---|---|---|
| 241,086 | 100% | Unique Identifier |
| 241,086 | 100% | Business Name |
| 239,395 | 99% | Business Primary Category |
| 217,764 | 90% | Business Secondary/Sub Category |
| 239,552 | 99% | Physical Address |
| 241,083 | 100% | Physical Address City |
| 241,086 | 100% | Physical Address State / Province |
| 241,086 | 100% | Physical Address Postal Code |
| 187,100 | 78% | Zip +4 for US Physical Addresses |
| 241,086 | 100% | Physical Address Country |
| 239,357 | 99% | Physical Address County |
| 239,341 | 99% | Physical Address Area Code |
| 239,349 | 99% | Federal Information Processing Standard |
| 95,542 | 40% | Metropolitan Statistical Area |
| 100,310 | 42% | Primary Metropolitan Statistical Area |
| 239,349 | 99% | Location Time Zone |
| 241,086 | 100% | Daylight Savings Time (Yes, No, Unknown) |
| 239,343 | 99% | Latitude (Centroid Based) |
| 240,350 | 100% | Latitude (Precision Polygon Based) |
| 239,343 | 99% | Longitude (Centroid Based) |
| 240,350 | 100% | Longitude (Precision Polygon Based) |
| 241,067 | 100% | Business Phone Number |
| 42,814 | 18% | Website URL |
Geographic Breakdown
Alabama 3985
Alaska 670
Arizona 3628
Arkansas 2844
California 20479
Colorado 5408
Connecticut 3148
Delaware 706
District Of Columbia 1263
Florida 9798
Georgia 6294
Hawaii 1338
Idaho 1455
Illinois 10243
Indiana 5839
Iowa 3805
Kansas 3485
Kentucky 3569
Louisiana 4563
Maine 957
Maryland 6798
Massachusetts 7377
Michigan 6837
Minnesota 4212
Mississippi 2777
Missouri 6283
Montana 1187
Nebraska 1994
Nevada 1484
New Hampshire 804
New Jersey 10712
New Mexico 1307
New York 14786
North Carolina 5406
North Dakota 675
Ohio 9105
Oklahoma 3440
Oregon 3579
Pennsylvania 12952
Rhode Island 778
South Carolina 3138
South Dakota 918
Tennessee 4110
Texas 15111
Utah 1555
Vermont 690
Virginia 5863
Washington 7922
West Virginia 1698
Wisconsin 3531
Wyoming 580
