nh_gen_info_geocoded_final
Data source: Big Local News · About: big-local-datasette
34 rows where Health Inspection Rating = 4 and "Rating Cycle 3 Standard Health Survey Date" is on date 2017-03-16
This data as json, copyable, CSV (advanced)
Suggested facets: geocode_flag, prvdr_state, prvdr_cnty, ownership, nmbr_beds, With a Resident and Family Council, QM Rating, Long-Stay QM Rating, Long-Stay QM Rating Footnote, Short-Stay QM Rating, Short-Stay QM Rating Footnote, Staffing Rating, Staffing Rating Footnote, RN Staffing Rating, RN Staffing Rating Footnote, Reported Staffing Footnote, Physical Therapist Staffing Footnote, Rating Cycle 1 Standard Survey Health Date, Rating Cycle 1 Total Number of Health Deficiencies, Rating Cycle 1 Number of Standard Health Deficiencies, Rating Cycle 1 Number of Complaint Health Deficiencies, Rating Cycle 1 Health Deficiency Score, Rating Cycle 1 Number of Health Revisits, Rating Cycle 1 Total Health Score, Rating Cycle 2 Standard Health Survey Date, Rating Cycle 2 Total Number of Health Deficiencies, Rating Cycle 2 Number of Standard Health Deficiencies, Rating Cycle 2 Number of Complaint Health Deficiencies, Rating Cycle 2 Health Deficiency Score, Rating Cycle 2 Number of Health Revisits, Rating Cycle 2 Health Revisit Score, Rating Cycle 2 Total Health Score, Rating Cycle 3 Total Number of Health Deficiencies, Rating Cycle 3 Number of Standard Health Deficiencies, Rating Cycle 3 Number of Complaint Health Deficiencies, Rating Cycle 3 Number of Health Revisits, Rating Cycle 3 Health Deficiency Score, Rating Cycle 3 Total Health Score, Total Weighted Health Survey Score, Number of Facility Reported Incidents, Number of Substantiated Complaints, Number of Fines, Total Amount of Fines in Dollars, Total Number of Penalties, Location, Rating Cycle 3 Standard Health Survey Date (date)
Link | rowid ▼ | address | lat | lng | geocode_flag | geocode_accuracy | prvdr_nmbr | prvdr_nm | prvdr_add | prvdr_city | prvdr_state | prvdr_zip | prvdr_phn | prvdr_cnty | prvdr_cnty_name | ownership | nmbr_beds | avg_residents | prvdr_type | Provider Resides in Hospital | Legal Business Name | Date First Approved to Provide Medicare and Medicaid services | Continuing Care Retirement Community | Special Focus Status | Abuse Icon | Most Recent Health Inspection More Than 2 Years Ago | Provider Changed Ownership in Last 12 Months | With a Resident and Family Council | Automatic Sprinkler Systems in All Required Areas | Overall Rating | Overall Rating Footnote | Health Inspection Rating | Health Inspection Rating Footnote | QM Rating | QM Rating Footnote | Long-Stay QM Rating | Long-Stay QM Rating Footnote | Short-Stay QM Rating | Short-Stay QM Rating Footnote | Staffing Rating | Staffing Rating Footnote | RN Staffing Rating | RN Staffing Rating Footnote | Reported Staffing Footnote | Physical Therapist Staffing Footnote | Reported Nurse Aide Staffing Hours per Resident per Day | Reported LPN Staffing Hours per Resident per Day | Reported RN Staffing Hours per Resident per Day | Reported Licensed Staffing Hours per Resident per Day | Reported Total Nurse Staffing Hours per Resident per Day | Reported Physical Therapist Staffing Hours per Resident Per Day | Case-Mix Nurse Aide Staffing Hours per Resident per Day | Case-Mix LPN Staffing Hours per Resident per Day | Case-Mix RN Staffing Hours per Resident per Day | Case-Mix Total Nurse Staffing Hours per Resident per Day | Adjusted Nurse Aide Staffing Hours per Resident per Day | Adjusted LPN Staffing Hours per Resident per Day | Adjusted RN Staffing Hours per Resident per Day | Adjusted Total Nurse Staffing Hours per Resident per Day | Rating Cycle 1 Standard Survey Health Date | Rating Cycle 1 Total Number of Health Deficiencies | Rating Cycle 1 Number of Standard Health Deficiencies | Rating Cycle 1 Number of Complaint Health Deficiencies | Rating Cycle 1 Health Deficiency Score | Rating Cycle 1 Number of Health Revisits | Rating Cycle 1 Health Revisit Score | Rating Cycle 1 Total Health Score | Rating Cycle 2 Standard Health Survey Date | Rating Cycle 2 Total Number of Health Deficiencies | Rating Cycle 2 Number of Standard Health Deficiencies | Rating Cycle 2 Number of Complaint Health Deficiencies | Rating Cycle 2 Health Deficiency Score | Rating Cycle 2 Number of Health Revisits | Rating Cycle 2 Health Revisit Score | Rating Cycle 2 Total Health Score | Rating Cycle 3 Standard Health Survey Date | Rating Cycle 3 Total Number of Health Deficiencies | Rating Cycle 3 Number of Standard Health Deficiencies | Rating Cycle 3 Number of Complaint Health Deficiencies | Rating Cycle 3 Number of Health Revisits | Rating Cycle 3 Health Deficiency Score | Rating Cycle 3 Health Revisit Score | Rating Cycle 3 Total Health Score | Total Weighted Health Survey Score | Number of Facility Reported Incidents | Number of Substantiated Complaints | Number of Fines | Total Amount of Fines in Dollars | Number of Payment Denials | Total Number of Penalties | Location | Processing Date |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1326 | 1326 | 201 HALL STREET WEST UNION, IA 52175 | 42.971311 | -91.809398 | 0 | 165187 | GOOD SAMARITAN SOCIETY - WEST UNION | 201 HALL STREET | WEST UNION | IA | 52175 | 5634223814 | 320 | Fayette | Non profit - Corporation | 71 | 39.7 | Medicare and Medicaid | false | THE EVANGELICAL LUTHERAN GOOD SAMARITAN SOCIETY | 10/01/1993 | false | false | false | false | Resident | Yes | 4 | 4 | 4 | 4 | 2 | 4 | 4 | 2.12065 | 0.31782 | 0.76629 | 1.08411 | 3.20476 | 0.01692 | 1.9145 | 0.64752 | 0.27833 | 2.84035 | 2.30214 | 0.36907 | 1.03626 | 3.61808 | 08/15/2019 | 1 | 1 | 0 | 4 | 1 | 0 | 4 | 05/10/2018 | 3 | 3 | 2 | 24 | 1 | 0 | 24 | 2017-03-16 | 1 | 1 | 0 | 1 | 4 | 0 | 4 | 10.667 | 1 | 0 | 0 | 0.00 | 0 | 0 | 201 HALL STREET WEST UNION, IA 52175 (42.971311, -91.809398) | 02/01/2020 | |||||||||||
2235 | 2235 | 5430 LINTON BLVD DELRAY BEACH, FL 33484 | 26.439227 | -80.129315 | 0 | 105475 | LAKE VIEW CARE CENTER AT DELRAY | 5430 LINTON BLVD | DELRAY BEACH | FL | 33484 | 5614953188 | 490 | Palm Beach | For profit - Corporation | 120 | 104.4 | Medicare and Medicaid | false | DELRAY GROUP, LLC | 09/06/1984 | false | false | false | false | Both | Yes | 5 | 4 | 5 | 4 | 5 | 4 | 4 | 3.02089 | 0.69933 | 0.96635 | 1.66568 | 4.68657 | 0.18257 | 2.23587 | 0.80986 | 0.39632 | 3.44205 | 2.80804 | 0.64932 | 0.91774 | 4.36607 | 06/06/2019 | 3 | 3 | 0 | 12 | 1 | 0 | 12 | 04/12/2018 | 5 | 5 | 0 | 24 | 1 | 0 | 24 | 2017-03-16 | 3 | 3 | 0 | 1 | 12 | 0 | 12 | 16 | 0 | 0 | 0 | 0.00 | 0 | 0 | 5430 LINTON BLVD DELRAY BEACH, FL 33484 (26.439227, -80.129315) | 02/01/2020 | |||||||||||
2659 | 2659 | 30 BOSTON RD MIDDLETOWN, CT 06457 | 41.554164 | -72.676519 | 0 | 75312 | WADSWORTH GLEN HEALTH CARE CEN | 30 BOSTON RD | MIDDLETOWN | CT | 6457 | 8603469299 | 30 | Middlesex | For profit - Corporation | 102 | 96.4 | Medicare and Medicaid | false | WADSWORTH GLEN INC | 06/29/1987 | false | false | false | false | Both | Yes | 4 | 4 | 2 | 3 | 2 | 2 | 2 | 2.0037 | 0.88557 | 0.41722 | 1.30279 | 3.30649 | 0.10467 | 2.04317 | 0.67677 | 0.31031 | 3.03026 | 2.03818 | 0.98393 | 0.50605 | 3.49897 | 03/21/2019 | 8 | 8 | 5 | 40 | 1 | 0 | 40 | 02/06/2018 | 3 | 3 | 0 | 16 | 1 | 0 | 16 | 2017-03-16 | 3 | 3 | 0 | 1 | 16 | 0 | 16 | 28 | 0 | 1 | 0 | 0.00 | 0 | 0 | 30 BOSTON RD MIDDLETOWN, CT 06457 (41.554164, -72.676519) | 02/01/2020 | |||||||||||
3033 | 3033 | 804 BURNETT DRIVE MOUNTAIN HOME, AR 72653 | 36.340127 | -92.399249 | 0 | 45351 | CARE MANOR NURSING AND REHAB | 804 BURNETT DRIVE | MOUNTAIN HOME | AR | 72653 | 8704245030 | 20 | Baxter | For profit - Corporation | 104 | 92.6 | Medicare and Medicaid | false | MHCNC, INC. | 08/25/1999 | false | false | false | false | Resident | Yes | 4 | 4 | 5 | 5 | 4 | 1 | 1 | 2.10508 | 1.18434 | 0.216 | 1.40034 | 3.50542 | 0.05412 | 2.16635 | 0.71647 | 0.33147 | 3.2143 | 2.01955 | 1.24296 | 0.24527 | 3.49709 | 04/18/2019 | 5 | 5 | 0 | 40 | 1 | 0 | 40 | 07/13/2018 | 5 | 4 | 2 | 36 | 1 | 0 | 36 | 2017-03-16 | 3 | 1 | 2 | 1 | 24 | 0 | 24 | 36 | 0 | 6 | 0 | 0.00 | 0 | 0 | 804 BURNETT DRIVE MOUNTAIN HOME, AR 72653 (36.340127, -92.399249) | 02/01/2020 | |||||||||||
3144 | 3144 | 9150 ALLEN RD ALLEN PARK, MI 48101 | 42.242587 | -83.221865 | 0 | 235439 | HEARTLAND HEALTH CARE CENTER-ALLEN PARK | 9150 ALLEN RD | ALLEN PARK | MI | 48101 | 3133862150 | 810 | Wayne | Non profit - Corporation | 163 | 122.1 | Medicare and Medicaid | false | HEARTLAND OF ALLEN PARK MI LLC | 10/01/1985 | false | false | false | false | Resident | Yes | 4 | 4 | 3 | 3 | 4 | 4 | 4 | 1.89898 | 0.92093 | 0.92553 | 1.84645 | 3.74543 | 0.1679 | 2.1463 | 0.79087 | 0.36752 | 3.3047 | 1.83884 | 0.87559 | 0.94784 | 3.63432 | 03/21/2019 | 7 | 6 | 2 | 44 | 1 | 0 | 44 | 04/18/2018 | 11 | 10 | 1 | 56 | 1 | 0 | 56 | 2017-03-16 | 11 | 10 | 1 | 1 | 64 | 0 | 64 | 51.333 | 5 | 3 | 1 | 10000.00 | 0 | 1 | 9150 ALLEN RD ALLEN PARK, MI 48101 (42.242587, -83.221865) | 02/01/2020 | |||||||||||
3188 | 3188 | 2205 W 29TH AVE DENVER, CO 80211 | 39.758418 | -105.013511 | 0 | 65327 | JUNIPER VILLAGE - THE SPEARLY CENTER | 2205 W 29TH AVE | DENVER | CO | 80211 | 3034581112 | 150 | Denver | For profit - Partnership | 135 | 123.3 | Medicare and Medicaid | false | JUNIPER PARK, LP | 04/11/1994 | false | false | false | false | Resident | Yes | 3 | 4 | 3 | 3 | 2 | 1 | 12 | 1 | 12 | 1.16642 | 0.48425 | 0.38306 | 0.86732 | 2.03374 | 0 | 1.76155 | 0.58545 | 0.26245 | 2.60944 | 1.37618 | 0.62197 | 0.54936 | 2.4992 | 10/31/2019 | 6 | 6 | 2 | 28 | 1 | 0 | 28 | 10/04/2018 | 3 | 2 | 1 | 12 | 1 | 0 | 12 | 2017-03-16 | 7 | 7 | 0 | 1 | 44 | 0 | 44 | 25.333 | 0 | 4 | 0 | 0.00 | 0 | 0 | 2205 W 29TH AVE DENVER, CO 80211 (39.758418, -105.013511) | 02/01/2020 | |||||||||
3515 | 3515 | 39022 PRESIDIO WAY FREMONT, CA 94538 | 37.544119 | -121.990975 | 0 | 56422 | FREMONT HEALTHCARE CENTER | 39022 PRESIDIO WAY | FREMONT | CA | 94538 | 5107923743 | 0 | Alameda | For profit - Limited Liability company | 115 | 105 | Medicare and Medicaid | false | FREMONT HEALTHCARE OPERATING COMPANY LP | 02/01/1974 | false | false | false | false | Resident | Yes | 5 | 4 | 5 | 5 | 5 | 4 | 4 | 2.45495 | 0.58819 | 0.68111 | 1.26931 | 3.72426 | 0.05338 | 2.12792 | 0.74248 | 0.32434 | 3.19474 | 2.39775 | 0.59569 | 0.7904 | 3.73816 | 02/28/2019 | 9 | 5 | 6 | 36 | 1 | 0 | 36 | 03/22/2018 | 11 | 7 | 4 | 28 | 1 | 0 | 28 | 2017-03-16 | 9 | 5 | 4 | 1 | 40 | 0 | 40 | 34 | 4 | 11 | 0 | 0.00 | 0 | 0 | 39022 PRESIDIO WAY FREMONT, CA 94538 (37.544119, -121.990975) | 02/01/2020 | |||||||||||
3570 | 3570 | 12000 TURNMEYER DRIVE HUNTSVILLE, AL 35803 | 34.607304 | -86.559341 | 0 | 15454 | FAIRVIEW AT REDSTONE VILLAGE | 12000 TURNMEYER DRIVE | HUNTSVILLE | AL | 35803 | 2568816717 | 440 | Madison | Non profit - Corporation | 56 | 51.1 | Medicare | false | REDSTONE MILITARY RETIREMENT RESIDENCE ASSOCIATION INC | 07/15/2005 | true | false | false | false | Resident | Yes | 4 | 4 | 2 | 2 | 2 | 4 | 3 | 2.87275 | 1.11036 | 0.56013 | 1.67049 | 4.54323 | 0.10482 | 2.21178 | 0.72272 | 0.34514 | 3.27964 | 2.69943 | 1.15524 | 0.61084 | 4.44214 | 06/06/2019 | 5 | 1 | 4 | 20 | 1 | 0 | 20 | 05/10/2018 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2017-03-16 | 3 | 3 | 1 | 1 | 24 | 0 | 24 | 14 | 0 | 2 | 0 | 0.00 | 0 | 0 | 12000 TURNMEYER DRIVE HUNTSVILLE, AL 35803 (34.607304, -86.559341) | 02/01/2020 | |||||||||||
5076 | 5076 | 298 CAHAL STREET HATTIESBURG, MS 39401 | 31.342818 | -89.324698 | 0 | 25A416 | BEDFORD ALZHEIMER'S CARE CENTER | 298 CAHAL STREET | HATTIESBURG | MS | 39401 | 6015445300 | 170 | Forrest | For profit - Corporation | 60 | 59 | Medicaid | false | Legal Business Name Not Available | 07/09/2007 | false | false | false | false | None | Yes | 4 | 4 | 3 | 3 | 2 | 3 | 2 | 3.22307 | 1.35261 | 0.31091 | 1.66352 | 4.88659 | 0 | 1.75266 | 0.63476 | 0.30603 | 2.69345 | 3.82198 | 1.60231 | 0.38239 | 5.81769 | 10/03/2019 | 3 | 3 | 0 | 16 | 1 | 0 | 16 | 11/02/2018 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2017-03-16 | 2 | 2 | 0 | 1 | 8 | 0 | 8 | 9.333 | 0 | 0 | 0 | 0.00 | 0 | 0 | 298 CAHAL STREET HATTIESBURG, MS 39401 (31.342818, -89.324698) | 02/01/2020 | |||||||||||
5781 | 5781 | 500 SOUTH BROAD STREET MIDDLETOWN, DE 19709 | 39.44464 | -75.715425 | 0 | 85050 | CADIA REHABILITATION BROADMEADOW | 500 SOUTH BROAD STREET | MIDDLETOWN | DE | 19709 | 3024493400 | 10 | New Castle | For profit - Corporation | 120 | 110.9 | Medicare and Medicaid | false | BROADMEADOW INVESTMENT LLC | 12/21/2005 | false | false | false | false | Resident | Yes | 5 | 4 | 5 | 5 | 5 | 5 | 5 | 2.11879 | 0.82479 | 0.98291 | 1.8077 | 3.92649 | 0.11064 | 2.07265 | 0.70622 | 0.32862 | 3.1075 | 2.1246 | 0.87819 | 1.12575 | 4.05179 | 06/05/2019 | 16 | 14 | 2 | 64 | 1 | 0 | 64 | 06/05/2018 | 10 | 10 | 0 | 44 | 1 | 0 | 44 | 2017-03-16 | 5 | 5 | 0 | 1 | 28 | 0 | 28 | 51.333 | 0 | 2 | 0 | 0.00 | 0 | 0 | 500 SOUTH BROAD STREET MIDDLETOWN, DE 19709 (39.44464, -75.715425) | 02/01/2020 | |||||||||||
5903 | 5903 | 321 13TH AVE N SAINT PETERSBURG, FL 33701 | 27.784843 | -82.637978 | 0 | 105714 | CONCORDIA MANOR | 321 13TH AVE N | SAINT PETERSBURG | FL | 33701 | 7278223030 | 510 | Pinellas | Non profit - Corporation | 39 | 35.6 | Medicare and Medicaid | false | SENIOR HEALTH-CONCORDIA, LLC | 03/01/1991 | false | false | false | false | Resident | Yes | 4 | 4 | 3 | 2 | 3 | 4 | 4 | 2.38251 | 0.74245 | 0.70545 | 1.44789 | 3.83041 | 0.0467 | 2.09712 | 0.67087 | 0.33277 | 3.10077 | 2.36118 | 0.83216 | 0.7979 | 3.96122 | 06/12/2019 | 4 | 3 | 1 | 16 | 1 | 0 | 16 | 03/22/2018 | 1 | 1 | 0 | 4 | 1 | 0 | 4 | 2017-03-16 | 4 | 3 | 1 | 1 | 24 | 0 | 24 | 13.333 | 0 | 2 | 0 | 0.00 | 0 | 0 | 321 13TH AVE N SAINT PETERSBURG, FL 33701 (27.784843, -82.637978) | 02/01/2020 | |||||||||||
6016 | 6016 | 2810 RULEME ST EUSTIS, FL 32726 | 28.826457 | -81.689505 | 0 | 105855 | RULEME CENTER | 2810 RULEME ST | EUSTIS | FL | 32726 | 3523571990 | 340 | Lake | For profit - Individual | 138 | 110.5 | Medicare and Medicaid | false | RULEME CENTER LLC | 08/01/1994 | false | false | false | false | Resident | Yes | 5 | 4 | 5 | 5 | 5 | 4 | 4 | 2.62435 | 0.72509 | 0.63327 | 1.35836 | 3.98271 | 0.09325 | 2.04572 | 0.68299 | 0.29991 | 3.02862 | 2.66619 | 0.79829 | 0.79476 | 4.21684 | 04/18/2019 | 3 | 3 | 0 | 20 | 1 | 0 | 20 | 02/08/2018 | 4 | 3 | 1 | 16 | 1 | 0 | 16 | 2017-03-16 | 5 | 4 | 1 | 1 | 24 | 0 | 24 | 19.333 | 0 | 2 | 0 | 0.00 | 0 | 0 | 2810 RULEME ST EUSTIS, FL 32726 (28.826457, -81.689505) | 02/01/2020 | |||||||||||
6307 | 6307 | 2650 GA-138, Jonesboro, GA 30236, USA | 33.5358328 | -84.30369879999999 | 1 | ROOFTOP | 115545 | JONESBORO NURSING AND REHABILITATION CENTER | 2650 HIGHWAY 138 SE | JONESBORO | GA | 30236 | 7704734436 | 280 | Clayton | For profit - Partnership | 129 | 119.3 | Medicare and Medicaid | false | JONESBORO NURSING AND REHABILITATION CENTER, LLC | 05/04/1993 | false | false | false | false | Resident | Yes | 3 | 4 | 4 | 5 | 3 | 1 | 1 | 2.02787 | 1.3487 | 0.29694 | 1.64563 | 3.6735 | 0.08586 | 2.18146 | 0.79744 | 0.40994 | 3.38883 | 1.932 | 1.27175 | 0.27263 | 3.47603 | 11/16/2018 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 01/19/2018 | 2 | 0 | 2 | 8 | 0 | 0 | 8 | 2017-03-16 | 4 | 4 | 4 | 1 | 28 | 0 | 28 | 7.333 | 0 | 3 | 0 | 0.00 | 0 | 0 | 02/01/2020 | |||||||||||
6801 | 6801 | 601 WEST MORGAN STREET TIPTON, MO 65081 | 38.656536 | -92.795296 | 0 | 265748 | TIPTON OAK MANOR | 601 WEST MORGAN STREET | TIPTON | MO | 65081 | 6604335574 | 670 | Moniteau | For profit - Corporation | 66 | 59.1 | Medicare and Medicaid | false | N & R OF TIPTON, LLC | 10/22/2002 | false | false | false | false | Resident | Yes | 4 | 4 | 3 | 4 | 2 | 3 | 3 | 1.94877 | 0.31786 | 0.48931 | 0.80717 | 2.75595 | 0.01385 | 1.85772 | 0.63715 | 0.2853 | 2.78018 | 2.1802 | 0.37513 | 0.64552 | 3.17871 | 02/08/2019 | 4 | 4 | 0 | 32 | 1 | 0 | 32 | 02/23/2018 | 1 | 1 | 0 | 4 | 1 | 0 | 4 | 2017-03-16 | 5 | 5 | 0 | 1 | 24 | 0 | 24 | 21.333 | 0 | 0 | 0 | 0.00 | 0 | 0 | 601 WEST MORGAN STREET TIPTON, MO 65081 (38.656536, -92.795296) | 02/01/2020 | |||||||||||
6822 | 6822 | 2200 EDISON STREET BRUSH, CO 80723 | 40.254769 | -103.646943 | 0 | 65170 | SUNSET MANOR | 2200 EDISON STREET | BRUSH | CO | 80723 | 9708422825 | 430 | Morgan | For profit - Corporation | 78 | 67.9 | Medicare and Medicaid | false | SSC BRUSH SUNSET MANOR OPERATING COMPANY LLC | 10/14/1982 | false | false | false | false | Resident | Yes | 3 | 4 | 2 | 2 | 3 | 1 | 12 | 1 | 12 | 2.11809 | 0.79538 | 0.26896 | 1.06434 | 3.18243 | 0.08956 | 2.07228 | 0.69724 | 0.32886 | 3.09838 | 2.12428 | 0.85778 | 0.30783 | 3.29366 | 09/26/2019 | 4 | 3 | 1 | 20 | 1 | 0 | 20 | 09/24/2018 | 7 | 6 | 1 | 28 | 1 | 0 | 28 | 2017-03-16 | 6 | 6 | 0 | 1 | 48 | 0 | 48 | 27.333 | 0 | 1 | 0 | 0.00 | 0 | 0 | 2200 EDISON STREET BRUSH, CO 80723 (40.254769, -103.646943) | 02/01/2020 | |||||||||
6927 | 6927 | 505 WEST EVERGREEN STRAFFORD, MO 65757 | 37.271211 | -93.126281 | 0 | 265656 | STRAFFORD CARE CENTER | 505 WEST EVERGREEN | STRAFFORD | MO | 65757 | 4177369332 | 380 | Greene | For profit - Corporation | 78 | 69.4 | Medicare and Medicaid | false | N & R OF STRAFFORD, INC. | 08/21/1996 | false | false | false | false | Resident | Yes | 5 | 4 | 5 | 4 | 5 | 3 | 4 | 1.91558 | 0.36408 | 0.54742 | 0.9115 | 2.82708 | 0.01286 | 2.04968 | 0.61204 | 0.28044 | 2.94216 | 1.94236 | 0.4473 | 0.7347 | 3.08124 | 03/07/2019 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 01/26/2018 | 4 | 3 | 1 | 28 | 2 | 14 | 42 | 2017-03-16 | 1 | 1 | 0 | 1 | 8 | 0 | 8 | 15.333 | 0 | 1 | 0 | 0.00 | 0 | 0 | 505 WEST EVERGREEN STRAFFORD, MO 65757 (37.271211, -93.126281) | 02/01/2020 | |||||||||||
7085 | 7085 | 100 Pioneers Medical Center Dr, Meeker, CO 81641, USA | 40.0470026 | -107.8822968 | 1 | ROOFTOP | 65264 | WALBRIDGE MEMORIAL CONVALESCENT WING | 100 PIONEERS MEDICAL CENTER DR | MEEKER | CO | 81641 | 9708785047 | 510 | Rio Blanco | Government - Hospital district | 30 | 27.5 | Medicare and Medicaid | false | EASTERN RIO BLANCO COUNTY HEALTH SERVICE DISTRICT | 12/01/1989 | false | false | false | false | Resident | Yes | 3 | 4 | 3 | 3 | 2 | 1 | 12 | 1 | 12 | 6 | 6 | 07/11/2019 | 1 | 1 | 0 | 8 | 1 | 0 | 8 | 05/03/2018 | 6 | 6 | 0 | 36 | 1 | 0 | 36 | 2017-03-16 | 6 | 6 | 0 | 1 | 52 | 0 | 52 | 24.667 | 0 | 0 | 0 | 0.00 | 0 | 0 | 02/01/2020 | |||||||||||||||||||||
7351 | 7351 | 605 HILLTOP AVENUE FRANKLINTON, LA 70438 | 30.855304 | -90.142389 | 0 | 195612 | GOOD SAMARITAN LIVING CENTER | 605 HILLTOP AVENUE | FRANKLINTON | LA | 70438 | 9858396706 | 580 | Washington | Non profit - Corporation | 84 | 61.7 | Medicare and Medicaid | false | HOME AWAY FROM HOME, INC. | 09/24/2004 | false | false | false | false | Resident | Yes | 4 | 4 | 2 | 2 | 1 | 2 | 1 | 2.61438 | 1.16351 | 0.2103 | 1.37381 | 3.98819 | 0.03146 | 2.11298 | 0.67152 | 0.31185 | 3.09635 | 2.57152 | 1.30285 | 0.25382 | 4.13029 | 02/20/2019 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 03/09/2018 | 3 | 3 | 0 | 24 | 1 | 0 | 24 | 2017-03-16 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 0 | 0 | 0 | 0.00 | 0 | 0 | 605 HILLTOP AVENUE FRANKLINTON, LA 70438 (30.855304, -90.142389) | 02/01/2020 | |||||||||||
7483 | 7483 | 509 EAST JOPPA ROAD TOWSON, MD 21286 | 39.401256 | -76.593571 | 0 | 215054 | MANOR CARE HEALTH SERVICES -TOWSON | 509 EAST JOPPA ROAD | TOWSON | MD | 21286 | 4108289494 | 20 | Baltimore | Non profit - Other | 132 | 114.2 | Medicare and Medicaid | false | MANOR CARE OF TOWSON LLC | 12/14/1967 | false | false | false | false | Resident | Yes | 5 | 4 | 5 | 5 | 5 | 4 | 4 | 1.98781 | 0.79778 | 0.72075 | 1.51853 | 3.50634 | 0.22198 | 2.01151 | 0.70963 | 0.3284 | 3.04954 | 2.05385 | 0.84534 | 0.82607 | 3.687 | 08/02/2019 | 9 | 9 | 0 | 36 | 1 | 0 | 36 | 04/18/2018 | 12 | 12 | 0 | 56 | 1 | 0 | 56 | 2017-03-16 | 3 | 3 | 2 | 1 | 12 | 0 | 12 | 38.667 | 0 | 0 | 0 | 0.00 | 0 | 0 | 509 EAST JOPPA ROAD TOWSON, MD 21286 (39.401256, -76.593571) | 02/01/2020 | |||||||||||
8518 | 8518 | 1006 33RD ST VERO BEACH, FL 32960 | 27.652939 | -80.392647 | 0 | 106097 | FLORIDA BAPTIST RETIREMENT CENTER | 1006 33RD ST | VERO BEACH | FL | 32960 | 7725675248 | 300 | Indian River | Non profit - Church related | 24 | 22.9 | Medicare and Medicaid | false | FLORIDA BAPTIST RETIREMENT CENTERS INC. | 03/19/2013 | false | false | false | false | Resident | Yes | 5 | 4 | 3 | 3 | 2 | 5 | 5 | 3.11179 | 0.002 | 1.54546 | 1.54746 | 4.65925 | 0.01246 | 2.09751 | 0.62755 | 0.26766 | 2.99272 | 3.08335 | 0.0024 | 2.1732 | 4.99233 | 05/31/2019 | 1 | 1 | 0 | 4 | 1 | 0 | 4 | 04/19/2018 | 7 | 7 | 0 | 20 | 1 | 0 | 20 | 2017-03-16 | 5 | 5 | 0 | 1 | 36 | 0 | 36 | 14.667 | 0 | 0 | 0 | 0.00 | 0 | 0 | 1006 33RD ST VERO BEACH, FL 32960 (27.652939, -80.392647) | 02/01/2020 | |||||||||||
8812 | 8812 | 900 COLLEGE AVE W LADYSMITH, WI 54848 | 45.455605 | -91.11113 | 0 | 525416 | LADYSMITH CARE & REHAB | 900 COLLEGE AVE W | LADYSMITH | WI | 54848 | 7155325015 | 530 | Rusk | For profit - Corporation | 50 | 33.6 | Medicare and Medicaid | false | SENIOR MANAGEMENT INC | 06/29/1988 | false | false | false | false | Resident | Yes | 5 | 4 | 3 | 2 | 3 | 5 | 5 | 2.80139 | 0.17016 | 1.01607 | 1.18624 | 3.98763 | 0.01877 | 2.11034 | 0.69509 | 0.31572 | 3.12115 | 2.75891 | 0.18408 | 1.21131 | 4.09688 | 06/05/2019 | 1 | 1 | 0 | 4 | 1 | 0 | 4 | 04/25/2018 | 3 | 3 | 0 | 12 | 1 | 0 | 12 | 2017-03-16 | 5 | 5 | 0 | 1 | 20 | 0 | 20 | 9.333 | 0 | 0 | 0 | 0.00 | 0 | 0 | 900 COLLEGE AVE W LADYSMITH, WI 54848 (45.455605, -91.11113) | 02/01/2020 | |||||||||||
9286 | 9286 | 603 EAST MAIN STREET CRIDERSVILLE, OH 45806 | 40.654398 | -84.136169 | 0 | 366171 | CRIDERSVILLE HEALTHCARE CENTER | 603 EAST MAIN STREET | CRIDERSVILLE | OH | 45806 | 4196454468 | 50 | Auglaize | For profit - Corporation | 50 | 31 | Medicare and Medicaid | false | HEALTHCARE VENTURES OF OHIO LLC | 01/22/1999 | false | false | false | false | Resident | Yes | 5 | 4 | 5 | 5 | 2 | 2 | 2 | 2.10739 | 0.71724 | 0.5367 | 1.25394 | 3.36133 | 0.02826 | 2.14758 | 0.85263 | 0.47573 | 3.47594 | 2.03944 | 0.63254 | 0.42463 | 3.10093 | 06/06/2019 | 2 | 2 | 0 | 8 | 1 | 0 | 8 | 05/17/2018 | 3 | 3 | 0 | 12 | 1 | 0 | 12 | 2017-03-16 | 4 | 4 | 0 | 1 | 24 | 0 | 24 | 12 | 0 | 0 | 0 | 0.00 | 0 | 0 | 603 EAST MAIN STREET CRIDERSVILLE, OH 45806 (40.654398, -84.136169) | 02/01/2020 | |||||||||||
10727 | 10727 | 4315 HOPKINS AVE DALLAS, TX 75209 | 32.847906 | -96.837289 | 0 | 675754 | TRAYMORE NURSING CENTER | 4315 HOPKINS AVE | DALLAS | TX | 75209 | 2143583131 | 390 | Dallas | For profit - Corporation | 150 | 100.6 | Medicare and Medicaid | false | NOCONA HOSPITAL DISTRICT | 06/24/1998 | false | false | false | false | Resident | Yes | 4 | 4 | 2 | 2 | 2 | 2 | 2 | 2.00481 | 0.96857 | 0.38079 | 1.34936 | 3.35417 | 0.04519 | 2.31871 | 0.83091 | 0.38328 | 3.53289 | 1.79698 | 0.87652 | 0.37394 | 3.04444 | 04/17/2019 | 6 | 6 | 0 | 52 | 1 | 0 | 52 | 05/04/2018 | 2 | 2 | 0 | 0 | 1 | 0 | 0 | 2017-03-16 | 7 | 7 | 0 | 1 | 88 | 0 | 88 | 40.667 | 0 | 0 | 0 | 0.00 | 0 | 0 | 4315 HOPKINS AVE DALLAS, TX 75209 (32.847906, -96.837289) | 02/01/2020 | |||||||||||
10968 | 10968 | 400 SOUTHWEST O STREET ANTLERS, OK 74523 | 34.229328 | -95.640394 | 0 | 375372 | CHOCTAW NATION NURSING HOME | 400 SOUTHWEST O STREET | ANTLERS | OK | 74523 | 5802985528 | 630 | Pushmataha | For profit - Corporation | 72 | 31.5 | Medicare and Medicaid | false | CITY OF HUGO | 09/20/1999 | false | false | false | false | Resident | Yes | 4 | 4 | 3 | 2 | 3 | 2 | 2 | 1.51921 | 0.64219 | 0.52167 | 1.16386 | 2.68307 | 0.02884 | 2.08174 | 0.76483 | 0.42042 | 3.26698 | 1.51673 | 0.63137 | 0.46703 | 2.63353 | 05/30/2019 | 2 | 2 | 0 | 12 | 1 | 0 | 12 | 04/12/2018 | 1 | 1 | 0 | 16 | 1 | 0 | 16 | 2017-03-16 | 9 | 9 | 0 | 1 | 60 | 0 | 60 | 21.333 | 0 | 0 | 0 | 0.00 | 0 | 0 | 400 SOUTHWEST O STREET ANTLERS, OK 74523 (34.229328, -95.640394) | 02/01/2020 | |||||||||||
11041 | 11041 | 2671 PLUMMER AVENUE SAN JOSE, CA 95125 | 37.276935 | -121.895141 | 0 | 555363 | LINCOLN GLEN SKILLED NURSING | 2671 PLUMMER AVENUE | SAN JOSE | CA | 95125 | 4082653222 | 530 | Santa Clara | Non profit - Church related | 59 | 57.1 | Medicare and Medicaid | false | LINCOLN GLEN SKILLED NURSING FACILITY | 07/01/1989 | true | false | false | false | Both | Yes | 5 | 4 | 5 | 5 | 4 | 5 | 5 | 2.68598 | 0.75754 | 0.82552 | 1.58306 | 4.26904 | 0.07705 | 2.2259 | 0.65547 | 0.26576 | 3.14713 | 2.50792 | 0.86903 | 1.16914 | 4.3498 | 04/24/2019 | 11 | 6 | 5 | 52 | 1 | 0 | 52 | 03/22/2018 | 4 | 4 | 0 | 16 | 1 | 0 | 16 | 2017-03-16 | 7 | 7 | 1 | 1 | 40 | 0 | 40 | 38 | 3 | 0 | 0 | 0.00 | 0 | 0 | 2671 PLUMMER AVENUE SAN JOSE, CA 95125 (37.276935, -121.895141) | 02/01/2020 | |||||||||||
12067 | 12067 | 325 KEMPTON ST SPRING VALLEY, CA 91977 | 32.703068 | -117.001996 | 0 | 555134 | MOUNT MIGUEL COVENANT VILLAGE | 325 KEMPTON ST. | SPRING VALLEY | CA | 91977 | 6194794790 | 470 | San Diego | Non profit - Corporation | 90 | 76.4 | Medicare and Medicaid | false | COVENANT LIVING WEST | 06/01/1981 | true | false | false | false | Resident | Yes | 5 | 4 | 5 | 5 | 5 | 2 | 2 | 2.52897 | 1.06568 | 0.39181 | 1.45749 | 3.98646 | 0.05273 | 2.14419 | 0.71555 | 0.32932 | 3.18906 | 2.4513 | 1.11988 | 0.44781 | 4.00847 | 06/13/2019 | 7 | 6 | 1 | 28 | 1 | 0 | 28 | 05/18/2018 | 7 | 5 | 3 | 28 | 1 | 0 | 28 | 2017-03-16 | 5 | 5 | 0 | 1 | 20 | 0 | 20 | 26.667 | 2 | 4 | 0 | 0.00 | 0 | 0 | 325 KEMPTON ST SPRING VALLEY, CA 91977 (32.703068, -117.001996) | 02/01/2020 | |||||||||||
12265 | 12265 | 4416 SOUTH BRANDON STREET SEATTLE, WA 98118 | 47.553396 | -122.278727 | 0 | 505453 | KIN ON HEALTH CARE CENTER | 4416 SOUTH BRANDON STREET | SEATTLE | WA | 98118 | 2067213630 | 160 | King | Non profit - Corporation | 100 | 96.2 | Medicare and Medicaid | false | KIN ON HEALTH CARE CENTER | 01/01/1992 | false | false | false | false | Both | Yes | 5 | 4 | 5 | 5 | 4 | 4 | 5 | 2.12713 | 0.45941 | 0.99821 | 1.45762 | 3.58475 | 0.01754 | 2.45863 | 0.77182 | 0.28898 | 3.51942 | 1.79811 | 0.44758 | 1.30014 | 3.26618 | 06/26/2019 | 2 | 2 | 0 | 12 | 1 | 0 | 12 | 05/04/2018 | 13 | 6 | 7 | 108 | 1 | 0 | 108 | 2017-03-16 | 21 | 16 | 5 | 1 | 180 | 0 | 180 | 72 | 2 | 7 | 2 | 108938.00 | 0 | 2 | 4416 SOUTH BRANDON STREET SEATTLE, WA 98118 (47.553396, -122.278727) | 02/01/2020 | |||||||||||
12679 | 12679 | Hickory St, Greenville, NC 27858, USA | 35.6090089 | -77.34817799999999 | 1 | GEOMETRIC_CENTER | 345512 | CYPRESS GLEN RETIREMENT COMMUNITY | 1000 HICKORY STREET | GREENVILLE | NC | 27858 | 2528300036 | 730 | Pitt | Non profit - Corporation | 6 | 2.8 | Medicare | false | THE UNITED METHODIST RETIREMENT HOMES, INCORPORATED | 01/10/2002 | true | false | false | false | Both | Yes | 5 | 4 | 4 | 2 | 4 | 5 | 5 | 3.3278 | 0.35448 | 2.3729 | 2.72737 | 6.05517 | 0.73166 | 2.09569 | 0.9621 | 0.55962 | 3.61742 | 3.30024 | 0.27705 | 1.59593 | 5.36761 | 06/04/2019 | 3 | 3 | 0 | 16 | 1 | 0 | 16 | 05/01/2018 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2017-03-16 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 0 | 0 | 0 | 0.00 | 0 | 0 | 02/01/2020 | |||||||||||
12847 | 12847 | 212 NORTH ANTES HENRYETTA, OK 74437 | 35.451425 | -95.97282 | 0 | 375569 | HENRYETTA COMMUNITY SKILLED HEALTHCARE & REHAB | 212 NORTH ANTES | HENRYETTA | OK | 74437 | 9186528797 | 550 | Okmulgee | For profit - Corporation | 53 | 31 | Medicare and Medicaid | false | HENRYETTA COMMUNITY SKILLED HEALTHCARE AND REHAB LLC | 11/28/2016 | false | false | false | false | Resident | Yes | 4 | 4 | 2 | 1 | 4 | 3 | 2 | 2.77637 | 0.83979 | 0.31027 | 1.15006 | 3.92642 | 0.00808 | 1.79467 | 0.66218 | 0.29924 | 2.75609 | 3.21521 | 0.95362 | 0.39026 | 4.56832 | 04/04/2019 | 1 | 1 | 0 | 8 | 1 | 0 | 8 | 02/05/2018 | 6 | 6 | 0 | 48 | 1 | 0 | 48 | 2017-03-16 | 2 | 2 | 0 | 1 | 12 | 0 | 12 | 22 | 0 | 0 | 0 | 0.00 | 0 | 0 | 212 NORTH ANTES HENRYETTA, OK 74437 (35.451425, -95.97282) | 02/01/2020 | |||||||||||
13432 | 13432 | 30 PORTER DRIVE MIDDLEBURY, VT 05753 | 43.999277 | -73.169206 | 0 | 475017 | HELEN PORTER HEALTHCARE & REHAB | 30 PORTER DRIVE | MIDDLEBURY | VT | 5753 | 8023884001 | 0 | Addison | Non profit - Corporation | 105 | 87.5 | Medicare and Medicaid | false | HELEN PORTER NURSING HOME, INC. | 06/26/1970 | false | false | false | false | Resident | Yes | 5 | 4 | 4 | 4 | 4 | 5 | 5 | 2.51891 | 0.91377 | 0.95995 | 1.87373 | 4.39263 | 0.19834 | 2.22405 | 0.69562 | 0.31774 | 3.2374 | 2.35388 | 0.98775 | 1.13714 | 4.35092 | 03/13/2019 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 02/28/2018 | 4 | 4 | 0 | 8 | 1 | 0 | 8 | 2017-03-16 | 9 | 5 | 7 | 1 | 40 | 0 | 40 | 9.333 | 5 | 0 | 0 | 0.00 | 0 | 0 | 30 PORTER DRIVE MIDDLEBURY, VT 05753 (43.999277, -73.169206) | 02/01/2020 | |||||||||||
13556 | 13556 | 5648 Adams Ave, Ogden, UT 84403, USA | 41.1706418 | -111.9685604 | 1 | RANGE_INTERPOLATED | 465182 | STONEHENGE OF OGDEN | 5648 SOUTH ADAMS AVE | WASHINGTON TERRACE | UT | 84405 | 8014750500 | 280 | Weber | For profit - Corporation | 52 | 41.4 | Medicare and Medicaid | false | KANE COUNTY HUMAN RESOURCE SPECIAL SERVICE DISTRICT | 01/21/2015 | false | false | false | false | Resident | Yes | 5 | 4 | 5 | 5 | 5 | 3 | 3 | 2.60047 | 1.25916 | 0.86301 | 2.12217 | 4.72264 | 0.32413 | 2.15412 | 0.91478 | 0.48098 | 3.54988 | 2.50898 | 1.03502 | 0.67534 | 4.26604 | 07/31/2019 | 2 | 2 | 0 | 8 | 1 | 0 | 8 | 06/21/2018 | 8 | 8 | 1 | 64 | 1 | 0 | 64 | 2017-03-16 | 9 | 9 | 0 | 1 | 64 | 0 | 64 | 36 | 0 | 0 | 1 | 3316.00 | 0 | 1 | 02/01/2020 | |||||||||||
13650 | 13650 | 409 WARDS CORNER ROAD LOVELAND, OH 45140 | 39.220442 | -84.289764 | 0 | 366421 | FLORENTINE GARDENS | 409 WARDS CORNER ROAD | LOVELAND | OH | 45140 | 5136301140 | 120 | Clermont | For profit - Corporation | 80 | 75.8 | Medicare and Medicaid | false | CLERMONT HEALTH CARE | 10/03/2014 | false | false | false | false | Both | Yes | 4 | 4 | 4 | 2 | 5 | 2 | 2 | 1.71099 | 0.86978 | 0.53794 | 1.40773 | 3.11872 | 0.10145 | 2.06472 | 0.80188 | 0.42434 | 3.29094 | 1.72227 | 0.81562 | 0.47714 | 3.03885 | 07/11/2019 | 4 | 4 | 0 | 16 | 1 | 0 | 16 | 05/31/2018 | 8 | 3 | 5 | 40 | 1 | 0 | 40 | 2017-03-16 | 3 | 2 | 2 | 1 | 8 | 0 | 8 | 22.667 | 0 | 3 | 0 | 0.00 | 0 | 0 | 409 WARDS CORNER ROAD LOVELAND, OH 45140 (39.220442, -84.289764) | 02/01/2020 | |||||||||||
13960 | 13960 | 300 Yant St, Bolivar, OH 44612, USA | 40.6531429 | -81.4552782 | 1 | ROOFTOP | 366200 | HENNIS CARE CENTRE OF BOLIVAR | 300 YANT STREET, NW | BOLIVAR | OH | 44612 | 3308749999 | 800 | Tuscarawas | For profit - Individual | 115 | 108 | Medicare and Medicaid | false | MEGCO MANAGEMENT INCORPORATED | 08/01/2000 | false | false | false | false | Resident | Yes | 5 | 4 | 5 | 5 | 5 | 3 | 3 | 2.84227 | 0.65536 | 0.91517 | 1.57053 | 4.41281 | 0.05798 | 2.4704 | 0.92293 | 0.49787 | 3.89121 | 2.39119 | 0.53395 | 0.69185 | 3.6365 | 06/20/2019 | 3 | 2 | 1 | 36 | 1 | 0 | 36 | 05/10/2018 | 1 | 1 | 0 | 4 | 1 | 0 | 4 | 2017-03-16 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 19.333 | 0 | 1 | 0 | 0.00 | 0 | 0 | 02/01/2020 | |||||||||||
15068 | 15068 | 83 THOMSON CIRCLE ABBEVILLE, SC 29620 | 34.159253 | -82.381346 | 0 | 425057 | ABBEVILLE NURSING HOME, INC. | 83 THOMSON CIRCLE | ABBEVILLE | SC | 29620 | 8643665122 | 0 | Abbeville | For profit - Corporation | 94 | 81.9 | Medicare and Medicaid | false | ABBEVILLE NURSING HOME, INC. | 07/15/1968 | false | false | false | false | Both | Yes | 5 | 4 | 5 | 5 | 2 | 4 | 4 | 2.33348 | 0.94261 | 0.67421 | 1.61683 | 3.95031 | 0.00849 | 2.06198 | 0.61865 | 0.26931 | 2.94994 | 2.35199 | 1.14571 | 0.94228 | 4.29408 | 01/16/2019 | 3 | 3 | 0 | 16 | 1 | 0 | 16 | 12/07/2017 | 3 | 3 | 0 | 8 | 1 | 0 | 8 | 2017-03-16 | 5 | 5 | 0 | 1 | 24 | 0 | 24 | 14.667 | 0 | 0 | 0 | 0.00 | 0 | 0 | 83 THOMSON CIRCLE ABBEVILLE, SC 29620 (34.159253, -82.381346) | 02/01/2020 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [nh_gen_info_geocoded_final] ( [address] TEXT, [lat] TEXT, [lng] TEXT, [geocode_flag] INTEGER, [geocode_accuracy] TEXT, [prvdr_nmbr] INTEGER, [prvdr_nm] TEXT, [prvdr_add] TEXT, [prvdr_city] TEXT, [prvdr_state] TEXT, [prvdr_zip] INTEGER, [prvdr_phn] INTEGER, [prvdr_cnty] INTEGER, [prvdr_cnty_name] TEXT, [ownership] TEXT, [nmbr_beds] INTEGER, [avg_residents] TEXT, [prvdr_type] TEXT, [Provider Resides in Hospital] TEXT, [Legal Business Name] TEXT, [Date First Approved to Provide Medicare and Medicaid services] TEXT, [Continuing Care Retirement Community] TEXT, [Special Focus Status] TEXT, [Abuse Icon] TEXT, [Most Recent Health Inspection More Than 2 Years Ago] TEXT, [Provider Changed Ownership in Last 12 Months] TEXT, [With a Resident and Family Council] TEXT, [Automatic Sprinkler Systems in All Required Areas] TEXT, [Overall Rating] INTEGER, [Overall Rating Footnote] TEXT, [Health Inspection Rating] INTEGER, [Health Inspection Rating Footnote] TEXT, [QM Rating] INTEGER, [QM Rating Footnote] TEXT, [Long-Stay QM Rating] TEXT, [Long-Stay QM Rating Footnote] TEXT, [Short-Stay QM Rating] TEXT, [Short-Stay QM Rating Footnote] TEXT, [Staffing Rating] TEXT, [Staffing Rating Footnote] TEXT, [RN Staffing Rating] TEXT, [RN Staffing Rating Footnote] TEXT, [Reported Staffing Footnote] TEXT, [Physical Therapist Staffing Footnote] TEXT, [Reported Nurse Aide Staffing Hours per Resident per Day] TEXT, [Reported LPN Staffing Hours per Resident per Day] TEXT, [Reported RN Staffing Hours per Resident per Day] TEXT, [Reported Licensed Staffing Hours per Resident per Day] TEXT, [Reported Total Nurse Staffing Hours per Resident per Day] TEXT, [Reported Physical Therapist Staffing Hours per Resident Per Day] TEXT, [Case-Mix Nurse Aide Staffing Hours per Resident per Day] TEXT, [Case-Mix LPN Staffing Hours per Resident per Day] TEXT, [Case-Mix RN Staffing Hours per Resident per Day] TEXT, [Case-Mix Total Nurse Staffing Hours per Resident per Day] TEXT, [Adjusted Nurse Aide Staffing Hours per Resident per Day] TEXT, [Adjusted LPN Staffing Hours per Resident per Day] TEXT, [Adjusted RN Staffing Hours per Resident per Day] TEXT, [Adjusted Total Nurse Staffing Hours per Resident per Day] TEXT, [Rating Cycle 1 Standard Survey Health Date] TEXT, [Rating Cycle 1 Total Number of Health Deficiencies] INTEGER, [Rating Cycle 1 Number of Standard Health Deficiencies] INTEGER, [Rating Cycle 1 Number of Complaint Health Deficiencies] INTEGER, [Rating Cycle 1 Health Deficiency Score] INTEGER, [Rating Cycle 1 Number of Health Revisits] INTEGER, [Rating Cycle 1 Health Revisit Score] INTEGER, [Rating Cycle 1 Total Health Score] INTEGER, [Rating Cycle 2 Standard Health Survey Date] TEXT, [Rating Cycle 2 Total Number of Health Deficiencies] INTEGER, [Rating Cycle 2 Number of Standard Health Deficiencies] INTEGER, [Rating Cycle 2 Number of Complaint Health Deficiencies] INTEGER, [Rating Cycle 2 Health Deficiency Score] INTEGER, [Rating Cycle 2 Number of Health Revisits] INTEGER, [Rating Cycle 2 Health Revisit Score] INTEGER, [Rating Cycle 2 Total Health Score] INTEGER, [Rating Cycle 3 Standard Health Survey Date] TEXT, [Rating Cycle 3 Total Number of Health Deficiencies] INTEGER, [Rating Cycle 3 Number of Standard Health Deficiencies] INTEGER, [Rating Cycle 3 Number of Complaint Health Deficiencies] INTEGER, [Rating Cycle 3 Number of Health Revisits] INTEGER, [Rating Cycle 3 Health Deficiency Score] INTEGER, [Rating Cycle 3 Health Revisit Score] INTEGER, [Rating Cycle 3 Total Health Score] INTEGER, [Total Weighted Health Survey Score] TEXT, [Number of Facility Reported Incidents] INTEGER, [Number of Substantiated Complaints] INTEGER, [Number of Fines] INTEGER, [Total Amount of Fines in Dollars] TEXT, [Number of Payment Denials] INTEGER, [Total Number of Penalties] INTEGER, [Location] TEXT, [Processing Date] TEXT );