U.S. Nursing Homes Database v.1.0.1
15,673 Nursing Homes
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 |
A nursing home is a place of residence for people who require constant medical care. Usually the residents are elderly, but the term can apply to places of care for the mentally or physically ill. In America, nursing homes are required to have a licensed nurse on duty 24 hours a day, and during at least one shift each day, one of those nurses must be a Registered Nurse.
Table Schema Database Field Statistics
| Field | Records | Percent | Type | Comment |
|---|---|---|---|---|
| id | 15,673 | 100% | int(11) | Unique Identifier |
| biz_provider_id | 15,673 | 100% | varchar(20) | Provider Identification Number |
| biz_name | 15,673 | 100% | varchar(150) | Business Name |
| biz_info | 3 | 0% | text | Business Information and Description |
| e_address | 15,673 | 100% | varchar(100) | Physical Address |
| e_city | 15,673 | 100% | varchar(50) | Physical Address City |
| e_state | 15,673 | 100% | varchar(20) | Physical Address State / Province |
| e_postal | 15,673 | 100% | varchar(7) | Physical Address Postal Code |
| e_zip_full | 14,123 | 90% | varchar(10) | Zip +4 for US Physical Addresses |
| e_country | 15,673 | 100% | varchar(20) | Physical Address Country |
| loc_county | 15,669 | 100% | varchar(40) | Physical Address County |
| loc_area_code | 15,669 | 100% | varchar(3) | Physical Address Area Code |
| loc_FIPS | 15,669 | 100% | varchar(5) | Federal Information Processing Standard - http://www.epa.gov/enviro/html/codes/state.html |
| loc_MSA | 5,967 | 38% | varchar(5) | Metropolitan Statistical Area - http://www.census.gov/population/www/metroareas/metrodef.html |
| loc_PMSA | 4,324 | 28% | varchar(5) | Primary Metropolitan Statistical Area - http://www.census.gov/epcd/www/g97geo2.htm |
| loc_TZ | 15,669 | 100% | varchar(6) | Location Time Zone |
| loc_DST | 15,673 | 100% | enum('Y','N','U') | Daylight Savings Time (Yes, No, Unknown) |
| loc_LAT_centroid | 15,669 | 100% | varchar(15) | Latitude (Centroid Based) |
| loc_LAT_poly | 15,626 | 100% | varchar(15) | Latitude (Precision Polygon Based) |
| loc_LONG_centroid | 15,669 | 100% | varchar(15) | Longitude (Centroid Based) |
| loc_LONG_poly | 15,626 | 100% | varchar(15) | Longitude (Precision Polygon Based) |
| biz_phone | 15,673 | 100% | varchar(20) | Business Phone Number |
| biz_phone_ext | 0 | 0% | varchar(8) | Business Phone Number Extension |
| f_beds | 15,673 | 100% | int(11) | Bed Count |
| f_residents | 15,673 | 100% | int(11) | Number of Residents |
| biz_participation | 15,673 | 100% | varchar(75) | Medicare and Medicaid Participation |
| biz_ownership | 15,673 | 100% | varchar(75) | Ownership and Non Profit Status |
| f_hospital | 15,673 | 100% | varchar(3) | Located in Hospital Flag |
| f_continued_care | 15,673 | 100% | varchar(3) | Continuing Care Community Flag |
| f_council | 15,673 | 100% | varchar(20) | Resident and Family Council Flag |
| Nursing Homes Records Information | |||
|---|---|---|---|
| USA | Alaska | 15 | Nursing Homes |
| USA | Alabama | 228 | Nursing Homes |
| USA | Arkansas | 233 | Nursing Homes |
| USA | Arizona | 139 | Nursing Homes |
| USA | California | 1,231 | Nursing Homes |
| USA | Colorado | 213 | Nursing Homes |
| USA | Connecticut | 236 | Nursing Homes |
| USA | District Of Columbia | 19 | Nursing Homes |
| USA | Delaware | 47 | Nursing Homes |
| USA | Florida | 681 | Nursing Homes |
| USA | Georgia | 360 | Nursing Homes |
| USA | Guam | 1 | Nursing Homes |
| USA | Hawaii | 48 | Nursing Homes |
| USA | Iowa | 443 | Nursing Homes |
| USA | Idaho | 79 | Nursing Homes |
| USA | Illinois | 783 | Nursing Homes |
| USA | Indiana | 506 | Nursing Homes |
| USA | Kansas | 341 | Nursing Homes |
| USA | Kentucky | 283 | Nursing Homes |
| USA | Louisiana | 282 | Nursing Homes |
| USA | Massachusetts | 427 | Nursing Homes |
| USA | Maryland | 230 | Nursing Homes |
| USA | Maine | 109 | Nursing Homes |
| USA | Michigan | 427 | Nursing Homes |
| USA | Minnesota | 384 | Nursing Homes |
| USA | Missouri | 514 | Nursing Homes |
| USA | Mississippi | 200 | Nursing Homes |
| USA | Montana | 84 | Nursing Homes |
| USA | North Carolina | 421 | Nursing Homes |
| USA | North Dakota | 85 | Nursing Homes |
| USA | Nebraska | 221 | Nursing Homes |
| USA | New Hampshire | 78 | Nursing Homes |
| USA | New Jersey | 359 | Nursing Homes |
| USA | New Mexico | 70 | Nursing Homes |
| USA | Nevada | 50 | Nursing Homes |
| USA | New York | 632 | Nursing Homes |
| USA | Ohio | 961 | Nursing Homes |
| USA | Oklahoma | 313 | Nursing Homes |
| USA | Oregon | 138 | Nursing Homes |
| USA | Pennsylvania | 706 | Nursing Homes |
| USA | Puerto Rico | 7 | Nursing Homes |
| USA | Rhode Island | 85 | Nursing Homes |
| USA | South Carolina | 185 | Nursing Homes |
| USA | South Dakota | 111 | Nursing Homes |
| USA | Tennessee | 320 | Nursing Homes |
| USA | Texas | 1,179 | Nursing Homes |
| USA | Utah | 100 | Nursing Homes |
| USA | Virginia | 287 | Nursing Homes |
| USA | Virgin Islands | 1 | Nursing Homes |
| USA | Vermont | 40 | Nursing Homes |
| USA | Washington | 229 | Nursing Homes |
| USA | Wisconsin | 388 | Nursing Homes |
| USA | West Virginia | 126 | Nursing Homes |
| USA | Wyoming | 38 | Nursing Homes |
This is NOT an email marketing list
