nh_gen_info_geocoded_final
Data source: Big Local News · About: big-local-datasette
15 rows where Total Number of Penalties = 7
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
188 | 188 | 3200 STATE ST SAGINAW, MI 48602 | 43.436632 | -83.985897 | 0 | 235250 | SAMARITAS SENIOR LIVING SAGINAW | 3200 STATE ST | SAGINAW | MI | 48602 | 9897991902 | 720 | Saginaw | Non profit - Church related | 98 | 58.8 | Medicare and Medicaid | false | SAMARITAS - LUTHERAN SOCIAL SERVICES OF MICHIGAN | 12/01/1975 | false | SFF Candidate | true | false | false | Resident | Yes | 1 | 1 | 2 | 1 | 4 | 3 | 2 | 2.56619 | 1.3568 | 0.44244 | 1.79924 | 4.36543 | 0.09823 | 2.135 | 0.79244 | 0.39171 | 3.31915 | 2.49808 | 1.28745 | 0.42513 | 4.21748 | 04/25/2019 | 30 | 17 | 14 | 307 | 1 | 0 | 307 | 06/06/2018 | 24 | 10 | 14 | 359 | 2 | 180 | 539 | 2017-03-23 | 25 | 15 | 11 | 1 | 188 | 0 | 188 | 364.5 | 28 | 39 | 5 | 191846.00 | 2 | 7 | 3200 STATE ST SAGINAW, MI 48602 (43.436632, -83.985897) | 02/01/2020 | ||||||||||
3050 | 3050 | 1069 BALLENGER HWY FLINT, MI 48504 | 43.018281 | -83.734828 | 0 | 235343 | KITH HAVEN | G 1069 BALLENGER HWY | FLINT | MI | 48504 | 8102356676 | 240 | Genesee | For profit - Corporation | 159 | 126.2 | Medicare and Medicaid | false | KITH HAVEN ACQUISITION COMPANY, LLC | 10/01/1977 | false | false | false | false | Resident | Yes | 1 | 1 | 4 | 5 | 3 | 3 | 3 | 2.52311 | 0.81613 | 0.51072 | 1.32685 | 3.84997 | 0.03016 | 2.08647 | 0.67081 | 0.2828 | 3.04008 | 2.51328 | 0.91483 | 0.67974 | 4.06093 | 10/17/2019 | 14 | 10 | 5 | 100 | 1 | 0 | 100 | 10/22/2018 | 35 | 14 | 22 | 343 | 1 | 0 | 343 | 2017-08-23 | 11 | 9 | 4 | 1 | 88 | 0 | 88 | 179 | 19 | 30 | 7 | 162552.00 | 0 | 7 | 1069 BALLENGER HWY FLINT, MI 48504 (43.018281, -83.734828) | 02/01/2020 | |||||||||||
5112 | 5112 | 9317 W Vienna Rd, Montrose, MI 48457, USA | 43.17581209999999 | -83.8653861 | 1 | RANGE_INTERPOLATED | 235600 | MEDILODGE OF MONTROSE INC | 9317 W VIENNA RD | MONTROSE | MI | 48457 | 8106396171 | 240 | Genesee | For profit - Corporation | 121 | 93.6 | Medicare and Medicaid | false | MEDILODGE OF MONTROSE, INC. | 07/01/2002 | false | SFF Candidate | true | false | false | Resident | Yes | 2 | 1 | 4 | 4 | 5 | 4 | 5 | 2.18974 | 0.50013 | 1.04566 | 1.54579 | 3.73553 | 0.05433 | 2.06243 | 0.71088 | 0.32336 | 3.09667 | 2.20663 | 0.52901 | 1.21712 | 3.86821 | 08/20/2019 | 34 | 21 | 13 | 348 | 2 | 174 | 522 | 09/13/2018 | 40 | 24 | 17 | 288 | 1 | 0 | 288 | 2017-07-12 | 11 | 8 | 8 | 1 | 80 | 0 | 80 | 370.333 | 12 | 71 | 4 | 106158.00 | 3 | 7 | 02/01/2020 | ||||||||||
5428 | 5428 | 6535 DRAKE ROAD WEST BLOOMFIELD, MI 48322 | 42.540603 | -83.399923 | 0 | 235663 | NOTTING HILL OF WEST BLOOMFIELD | 6535 DRAKE ROAD | WEST BLOOMFIELD | MI | 48322 | 2485922000 | 620 | Oakland | For profit - Individual | 118 | 112.1 | Medicare and Medicaid | false | MAPLE-DRAKE REAL ESTATE, LLC | 05/30/2013 | false | false | false | false | Resident | Yes | 2 | 2 | 4 | 3 | 4 | 3 | 3 | 1.88439 | 1.57753 | 0.57062 | 2.14815 | 4.03255 | 0.18071 | 2.21128 | 0.78473 | 0.37176 | 3.36776 | 1.7711 | 1.51162 | 0.57773 | 3.83965 | 07/29/2019 | 23 | 14 | 13 | 164 | 1 | 0 | 164 | 04/05/2018 | 16 | 6 | 10 | 152 | 1 | 0 | 152 | 2017-03-02 | 22 | 17 | 8 | 1 | 124 | 0 | 124 | 153.333 | 9 | 31 | 7 | 96031.00 | 0 | 7 | 6535 DRAKE ROAD WEST BLOOMFIELD, MI 48322 (42.540603, -83.399923) | 02/01/2020 | |||||||||||
6849 | 6849 | 309 RAILROAD STREET HULL, IA 51239 | 43.186844 | -96.143408 | 0 | 165248 | PLEASANT ACRES CARE CENTER | 309 RAILROAD STREET | HULL | IA | 51239 | 7124392758 | 830 | Sioux | For profit - Corporation | 60 | 42.5 | Medicare and Medicaid | false | PREMIER ESTATES 505, LLC | 01/01/1995 | false | SFF Candidate | false | false | false | Both | Yes | 1 | 1 | 3 | 3 | 4 | 3 | 4 | 1.89848 | 0.23222 | 0.67873 | 0.91096 | 2.80944 | 0.01788 | 1.88515 | 0.65432 | 0.31708 | 2.85655 | 2.09303 | 0.26687 | 0.80568 | 3.15378 | 10/24/2019 | 22 | 18 | 6 | 187 | 1 | 0 | 187 | 08/16/2018 | 27 | 8 | 19 | 140 | 1 | 0 | 140 | 2017-05-11 | 16 | 2 | 14 | 1 | 175 | 0 | 175 | 169.333 | 8 | 34 | 5 | 140200.00 | 2 | 7 | 309 RAILROAD STREET HULL, IA 51239 (43.186844, -96.143408) | 02/01/2020 | ||||||||||
7359 | 7359 | 2001 CEDAR STREET CAIRO, IL 62914 | 37.002806 | -89.178966 | 0 | 146002 | APERION CARE CAIRO | 2001 CEDAR STREET | CAIRO | IL | 62914 | 6187341700 | 10 | Alexander | For profit - Corporation | 83 | 65 | Medicare and Medicaid | false | APERION CARE CAIRO LLC | 06/01/2001 | false | SFF | true | false | false | Resident | Yes | 18 | 18 | 18 | 18 | 18 | 18 | 18 | 1.98908 | 0.72348 | 0.2131 | 0.93658 | 2.92566 | 0.00794 | 2.04274 | 0.72759 | 0.36544 | 3.13577 | 2.02374 | 0.74769 | 0.21948 | 2.9918 | 10/03/2019 | 32 | 19 | 13 | 395 | 2 | 198 | 593 | 04/12/2019 | 16 | 10 | 6 | 167 | 2 | 84 | 251 | 2018-05-25 | 22 | 8 | 16 | 1 | 310 | 0 | 310 | 431.833 | 4 | 13 | 4 | 440516.00 | 3 | 7 | 2001 CEDAR STREET CAIRO, IL 62914 (37.002806, -89.178966) | 02/01/2020 | ||||||||||
7575 | 7575 | 1401 CHERRY LANE GREAT BEND, KS 67530 | 38.36527 | -98.815221 | 0 | 175522 | MEDICALODGES GREAT BEND | 1401 CHERRY LANE | GREAT BEND | KS | 67530 | 6207922165 | 40 | Barton | For profit - Corporation | 62 | 46.5 | Medicare and Medicaid | false | MEDICALODGES INC | 10/01/2011 | false | SFF Candidate | false | false | false | Resident | Yes | 2 | 1 | 3 | 3 | 3 | 5 | 5 | 2.9576 | 0.5191 | 0.96721 | 1.48631 | 4.44392 | 0.05968 | 1.83083 | 0.63987 | 0.29261 | 2.7633 | 3.35744 | 0.61002 | 1.24414 | 5.15692 | 06/03/2019 | 17 | 17 | 16 | 223 | 1 | 0 | 223 | 08/15/2018 | 18 | 14 | 4 | 398 | 1 | 0 | 398 | 2017-01-19 | 17 | 8 | 9 | 1 | 199 | 0 | 199 | 277.333 | 2 | 3 | 4 | 94783.00 | 3 | 7 | 1401 CHERRY LANE GREAT BEND, KS 67530 (38.36527, -98.815221) | 02/01/2020 | ||||||||||
7847 | 7847 | 3001 N HURSTBOURNE PARKWAY LOUISVILLE, KY 40241 | 38.292995 | -85.575383 | 0 | 185305 | SPRINGHURST HEALTH AND REHAB | 3001 N. HURSTBOURNE PARKWAY | LOUISVILLE | KY | 40241 | 5024265531 | 550 | Jefferson | Non profit - Church related | 90 | 56.7 | Medicare and Medicaid | false | BAPTIST HOMES, INC. | 12/01/1991 | false | SFF Candidate | true | false | false | Resident | Yes | 1 | 1 | 1 | 1 | 2 | 4 | 4 | 2.14569 | 1.15285 | 0.883 | 2.03584 | 4.18153 | 0 | 2.25319 | 0.74021 | 0.39509 | 3.38849 | 1.97918 | 1.17112 | 0.84118 | 3.95714 | 01/18/2019 | 20 | 10 | 10 | 839 | 1 | 0 | 839 | 11/09/2017 | 16 | 3 | 13 | 764 | 1 | 0 | 764 | 2016-09-22 | 17 | 6 | 11 | 1 | 128 | 0 | 128 | 695.5 | 3 | 3 | 4 | 358693.00 | 3 | 7 | 3001 N HURSTBOURNE PARKWAY LOUISVILLE, KY 40241 (38.292995, -85.575383) | 02/01/2020 | ||||||||||
8098 | 8098 | 43533 ELIZABETH RD MOUNT CLEMENS, MI 48043 | 42.617368 | -82.887711 | 0 | 235155 | MARTHA T BERRY MCF | 43533 ELIZABETH RD | MOUNT CLEMENS | MI | 48043 | 5864695265 | 490 | Macomb | Government - County | 217 | 206.4 | Medicare and Medicaid | false | COUNTY OF MACOMB | 04/22/1968 | false | false | false | false | Both | Yes | 2 | 1 | 2 | 4 | 1 | 4 | 3 | 3.13098 | 1.3947 | 0.45013 | 1.84483 | 4.97581 | 0.01989 | 2.13055 | 0.7132 | 0.32412 | 3.16787 | 3.05424 | 1.47047 | 0.52271 | 5.03674 | 04/04/2019 | 15 | 14 | 2 | 104 | 1 | 0 | 104 | 02/09/2018 | 25 | 20 | 5 | 235 | 1 | 0 | 235 | 2017-05-17 | 24 | 16 | 8 | 1 | 346 | 0 | 346 | 188 | 13 | 16 | 5 | 146483.00 | 2 | 7 | 43533 ELIZABETH RD MOUNT CLEMENS, MI 48043 (42.617368, -82.887711) | 02/01/2020 | |||||||||||
8355 | 8355 | 750 FULLER AVE NE GRAND RAPIDS, MI 49503 | 42.976109 | -85.639838 | 0 | 235075 | SPECTRUM HEALTH REHAB & NURSING CENTER-FULLER AVE | 750 FULLER AVE NE | GRAND RAPIDS | MI | 49503 | 6164863001 | 400 | Kent | Non profit - Corporation | 250 | 195.6 | Medicare and Medicaid | true | SPECTRUM HEALTH HOSPITALS | 01/03/1967 | false | false | false | false | Resident | Yes | 3 | 2 | 3 | 2 | 4 | 5 | 5 | 2.80919 | 1.00551 | 1.18789 | 2.19339 | 5.00258 | 0.2847 | 2.05067 | 0.70146 | 0.32525 | 3.07738 | 2.84709 | 1.07787 | 1.37464 | 5.21274 | 10/30/2019 | 18 | 8 | 10 | 116 | 0 | 0 | 116 | 08/30/2018 | 20 | 17 | 4 | 136 | 1 | 0 | 136 | 2017-10-12 | 29 | 11 | 19 | 1 | 260 | 0 | 260 | 146.667 | 40 | 47 | 5 | 166739.00 | 2 | 7 | 750 FULLER AVE NE GRAND RAPIDS, MI 49503 (42.976109, -85.639838) | 02/01/2020 | |||||||||||
9078 | 9078 | 5201 ROMA AVENUE NE ALBUQUERQUE, NM 87108 | 35.085538 | -106.587399 | 0 | 325074 | GOOD SAMARITAN SOCIETY - MANZANO DEL SOL | 5201 ROMA AVENUE NE | ALBUQUERQUE | NM | 87108 | 5052622311 | 0 | Bernalillo | Non profit - Corporation | 117 | 87.7 | Medicare and Medicaid | false | THE EVANGELICAL LUTHERAN GOOD SAMARITAN SOCIETY | 10/01/1992 | false | false | false | false | Resident | Yes | 1 | 1 | 3 | 3 | 3 | 2 | 2 | 2.10594 | 0.72642 | 0.437 | 1.16341 | 3.26936 | 0.0527 | 2.01934 | 0.72503 | 0.33231 | 3.07668 | 2.16747 | 0.75338 | 0.49495 | 3.40748 | 06/11/2019 | 8 | 8 | 0 | 223 | 1 | 0 | 223 | 04/30/2018 | 20 | 20 | 0 | 311 | 1 | 0 | 311 | 2017-05-11 | 21 | 18 | 16 | 1 | 342 | 0 | 342 | 272.167 | 0 | 3 | 4 | 510852.00 | 3 | 7 | 5201 ROMA AVENUE NE ALBUQUERQUE, NM 87108 (35.085538, -106.587399) | 02/01/2020 | |||||||||||
11409 | 11409 | 5970 KENWOOD ROAD CINCINNATI, OH 45243 | 39.175029 | -84.384315 | 0 | 365186 | MADEIRA HEALTHCARE | 5970 KENWOOD ROAD | CINCINNATI | OH | 45243 | 5135614111 | 310 | Hamilton | For profit - Corporation | 131 | 100.6 | Medicare and Medicaid | false | MADEIRA HEALTHCARE LLC | 11/01/1967 | false | false | false | false | Resident | Yes | 1 | 1 | 3 | 2 | 4 | 2 | 2 | 1.47952 | 0.6472 | 0.45989 | 1.10709 | 2.5866 | 0.02021 | 2.02711 | 0.7627 | 0.36995 | 3.15976 | 1.51691 | 0.63807 | 0.46789 | 2.625 | 03/28/2019 | 20 | 5 | 15 | 92 | 1 | 0 | 92 | 02/14/2018 | 20 | 7 | 13 | 195 | 1 | 0 | 195 | 2016-12-15 | 16 | 5 | 11 | 1 | 139 | 0 | 139 | 134.167 | 4 | 18 | 4 | 49982.00 | 3 | 7 | 5970 KENWOOD ROAD CINCINNATI, OH 45243 (39.175029, -84.384315) | 02/01/2020 | |||||||||||
11422 | 11422 | 2702 FARRELL ROAD SANFORD, NC 27330 | 35.568944 | -79.125356 | 0 | 345534 | SANFORD HEALTH & REHABILITATION CO | 2702 FARRELL ROAD | SANFORD | NC | 27330 | 9197769602 | 520 | Lee | For profit - Corporation | 131 | 117.4 | Medicare and Medicaid | false | SANFORD HEALTH AND REHABILITATION CO LLC | 06/08/2005 | false | SFF Candidate | true | false | false | Resident | Yes | 1 | 1 | 2 | 2 | 2 | 1 | 1 | 2.21078 | 0.98156 | 0.29411 | 1.27567 | 3.48645 | 0 | 2.21756 | 0.84837 | 0.46482 | 3.53075 | 2.07198 | 0.86999 | 0.23816 | 3.16643 | 08/08/2019 | 10 | 6 | 4 | 92 | 1 | 0 | 92 | 08/09/2018 | 25 | 14 | 15 | 508 | 1 | 0 | 508 | 2017-08-17 | 9 | 3 | 6 | 1 | 60 | 0 | 60 | 225.333 | 4 | 17 | 5 | 444928.00 | 2 | 7 | 2702 FARRELL ROAD SANFORD, NC 27330 (35.568944, -79.125356) | 02/01/2020 | ||||||||||
11579 | 11579 | 6021 N Lidgerwood St, Spokane, WA 99208, USA | 47.712626 | -117.4066066 | 1 | ROOFTOP | 505024 | FRANKLIN HILLS HEALTH & REHAB CENTER | 6021 NORTH LIDGERWOOD | SPOKANE | WA | 99207 | 5094893323 | 310 | Spokane | For profit - Corporation | 100 | 65.9 | Medicare and Medicaid | false | FRANKLIN HILLS HEALTH - SPOKANE, LLC | 01/01/1967 | false | false | false | false | Resident | Yes | 2 | 1 | 3 | 2 | 3 | 4 | 4 | 2.45496 | 0.3699 | 0.9357 | 1.3056 | 3.76056 | 0.1215 | 2.08737 | 0.78382 | 0.38687 | 3.25806 | 2.44433 | 0.35486 | 0.91034 | 3.70123 | 12/11/2018 | 49 | 28 | 23 | 367 | 1 | 0 | 367 | 10/17/2017 | 30 | 12 | 18 | 264 | 1 | 0 | 264 | 2016-09-21 | 41 | 23 | 18 | 1 | 295 | 0 | 295 | 320.667 | 29 | 35 | 7 | 154086.00 | 0 | 7 | 02/01/2020 | |||||||||||
15382 | 15382 | 153 JOHNS COURT SHELTON, WA 98584 | 47.233785 | -123.109373 | 0 | 505507 | SHELTON HEALTH & REHAB CENTER | 153 JOHNS COURT | SHELTON | WA | 98584 | 3604272575 | 220 | Mason | For profit - Corporation | 76 | 63.4 | Medicare and Medicaid | false | EVERGREEN AT SHELTON, L.L.C. | 02/12/1999 | false | true | false | false | Resident | Yes | 2 | 1 | 2 | 1 | 4 | 4 | 4 | 2.15906 | 0.72361 | 0.94307 | 1.66668 | 3.82574 | 0.09301 | 2.11376 | 0.78464 | 0.39686 | 3.29527 | 2.12287 | 0.69346 | 0.89441 | 3.72287 | 05/10/2019 | 54 | 30 | 28 | 432 | 1 | 0 | 432 | 05/23/2018 | 27 | 13 | 14 | 236 | 1 | 0 | 236 | 2017-06-28 | 19 | 14 | 6 | 1 | 160 | 0 | 160 | 321.333 | 27 | 17 | 7 | 126343.00 | 0 | 7 | 153 JOHNS COURT SHELTON, WA 98584 (47.233785, -123.109373) | 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 );