nh_gen_info_geocoded_final

Table actions
Data provided via a collaboration between The Accountability Project and Big Local News. This project provides and joins datasets pertinent to the COVID-19 pandemic: hospital location and number of beds by type, county-level population estimates by age (which can be linked to hospital data) and nursing home location and capacity. See README for additional information.

Data source: Big Local News · About: big-local-datasette

19 rows where Health Inspection Rating = 3 and Rating Cycle 1 Number of Complaint Health Deficiencies = 8

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: prvdr_state, prvdr_cnty, prvdr_cnty_name, ownership, nmbr_beds, prvdr_type, Continuing Care Retirement Community, Provider Changed Ownership in Last 12 Months, With a Resident and Family Council, Overall Rating, QM Rating, Long-Stay QM Rating, Long-Stay QM Rating Footnote, Short-Stay QM Rating, 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 Health Deficiency Score, Rating Cycle 1 Number of Health Revisits, Rating Cycle 1 Total Health Score, 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 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, 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
580 580 715 WEST CENTRAL ROAD ARLINGTON HTS, IL 60005 42.066492 -87.99177 0   145199 MANORCARE OF ARLINGTON HEIGHTS 715 WEST CENTRAL ROAD ARLINGTON HTS IL 60005 8473922020 141 Cook Non profit - Other 151 84.3 Medicare and Medicaid false MANORCARE HEALTH SERVICES LLC 01/21/1969 false   false false false None Yes 5   3   5   5   5   4   5       1.94672 0.28899 1.57836 1.86735 3.81407 0.17021 2.05986 0.82009 0.41543 3.29538 1.96419 0.26497 1.43002 3.71139 10/09/2019 10 2 8 76 1 0 76 11/29/2018 9 8 2 44 1 0 44 2017-10-26 6 6 0 1 40 0 40 59.333 0 8 0 0.00 0 0 715 WEST CENTRAL ROAD ARLINGTON HTS, IL 60005 (42.066492, -87.99177) 02/01/2020
963 963 446 ARROWOOD DR SANTA ROSA, CA 95407 38.42147 -122.71887 0   56259 SONOMA POSTACUTE CARE 446 ARROWOOD DR SANTA ROSA CA 95407 7075282100 590 Sonoma For profit - Limited Liability company 62 56.1 Medicare and Medicaid false SANTA ROSA POSTACUTE CARE LLC 01/10/1971 false   false false false Resident Yes 3   3   5   5   5   1 12 1 12 6 6                             06/10/2019 11 5 8 80 1 0 80 06/12/2018 9 5 5 68 1 0 68 2017-03-17 2 2 0 1 12 0 12 64.667 5 11 1 6633.00 0 1 446 ARROWOOD DR SANTA ROSA, CA 95407 (38.42147, -122.71887) 02/01/2020
1487 1487 9935 RED ARROW HWY BRIDGMAN, MI 49106 41.938831 -86.566105 0   235625 WEST WOODS OF BRIDGMAN 9935 RED ARROW HWY BRIDGMAN MI 49106 2694653017 100 Berrien For profit - Corporation 92 69.5 Medicare and Medicaid false BRIDGMAN CARE OPERATING, LLC 11/28/2006 false   false false false Resident Yes 3   3   4   4   4   2   2       2.14381 0.85967 0.32968 1.18936 3.33316 0.07511 1.94361 0.69014 0.32617 2.95991 2.29241 0.93666 0.38044 3.61103 01/10/2020 17 9 8 144 0 0 144 10/11/2018 5 5 0 44 1 0 44 2017-09-13 10 9 4 1 76 0 76 99.333 11 3 2 16157.00 1 3 9935 RED ARROW HWY BRIDGMAN, MI 49106 (41.938831, -86.566105) 02/01/2020
1910 1910 22355 W EIGHT MILE RD DETROIT, MI 48219 42.443115 -83.264231 0   235374 WEST OAKS SENIOR CARE & REHAB CENTER 22355 W EIGHT MILE RD DETROIT MI 48219 3132556450 810 Wayne For profit - Corporation 102 91.7 Medicare and Medicaid false WEST OAKS SENIOR CARE AND REHAB CENTER, LLC 10/01/1978 false   false false false Resident Yes 3   3   4   4   4   2   2       2.47956 1.06977 0.46401 1.53377 4.01333 0.06469 2.13106 0.76813 0.3514 3.25059 2.41821 1.04721 0.497 3.95909 08/08/2019 16 8 8 120 1 0 120 07/25/2018 6 6 1 24 1 0 24 2017-06-28 12 9 3 1 96 0 96 84 4 15 1 13031.00 1 2 22355 W EIGHT MILE RD DETROIT, MI 48219 (42.443115, -83.264231) 02/01/2020
2495 2495 725 WEST MONTROSE AVENUE CHICAGO, IL 60613 41.96189 -87.648592 0   145679 CARLTON AT THE LAKE, THE 725 WEST MONTROSE AVENUE CHICAGO IL 60613 7739291700 141 Cook For profit - Limited Liability company 244 194.3 Medicare and Medicaid false CARLTON SKILLED NURSING FACILITY LLC 06/13/1990 false   false false false Resident Yes 3   3   2   3   1   2   3       1.36999 0.47647 0.92024 1.39672 2.7667 0.03442 2.33168 0.84851 0.50955 3.68973 1.22114 0.42225 0.67975 2.40448 03/21/2019 9 1 8 36 1 0 36 02/08/2018 8 5 3 32 1 0 32 2017-03-16 21 9 12 1 108 0 108 46.667 0 25 0 0.00 0 0 725 WEST MONTROSE AVENUE CHICAGO, IL 60613 (41.96189, -87.648592) 02/01/2020
3472 3472 13225 WESTWOOD LANE OMAHA, NE 68144 41.227554 -96.121068 0   285302 HILLCREST MILLARD 13225 WESTWOOD LANE OMAHA NE 68144 5313653000 270 Douglas For profit - Individual 76 76.9 Medicare and Medicaid false HILLCREST MILLARD, LLC 02/23/2018 false   false false false None Yes 5   3   5     2 5   4   4       2.06902 0.93663 1.0993 2.03593 4.10494 0.33591 2.05327 0.91957 0.52321 3.49605 2.09428 0.76589 0.79081 3.76515 03/11/2019 10 3 8 60 1 0 60 02/14/2018 0 0 0 0 0 0 0   . . . . . . . 36 1 5 0 0.00 0 0 13225 WESTWOOD LANE OMAHA, NE 68144 (41.227554, -96.121068) 02/01/2020
4185 4185 707 WEST RIVERSIDE BOULEVARD ROCKFORD, IL 61103 42.3158 -89.071649 0   145818 ROCK RIVER HEALTH CARE 707 WEST RIVERSIDE BOULEVARD ROCKFORD IL 61103 8158775752 991 Winnebago For profit - Limited Liability company 130 71.1 Medicare and Medicaid false ROCK RIVER HEALTH CARE LLC 01/01/1995 false   false false false Resident Yes 1   3   1   1   1   1   1       1.51526 0.61712 0.26507 0.88219 2.39745 0.04541 2.04564 0.82706 0.42338 3.29608 1.53948 0.56107 0.23564 2.3324 10/24/2019 8 0 8 32 1 0 32 12/07/2018 15 7 8 60 1 0 60 2017-11-08 17 9 8 1 80 0 80 49.333 0 23 0 0.00 0 0 707 WEST RIVERSIDE BOULEVARD ROCKFORD, IL 61103 (42.3158, -89.071649) 02/01/2020
4602 4602 3940 RIMROCK RD BILLINGS, MT 59102 45.798539 -108.615831 0   275024 ST JOHN'S LUTHERAN HOME 3940 RIMROCK RD BILLINGS MT 59102 4066555600 550 Yellowstone Non profit - Corporation 186 142.6 Medicare and Medicaid false ST JOHNS LUTHERAN MINISTRIES 01/01/1967 true   false false false Resident Yes 4   3   3   3   3   5   5       3.34855 0.41982 1.27797 1.69778 5.04633 0.07159 2.05258 0.65725 0.30443 3.01427 3.39056 0.4803 1.58001 5.36842 08/22/2019 8 8 8 56 1 0 56 03/08/2019 6 6 0 32 1 0 32 2017-11-08 7 7 1 1 44 0 44 46 0 2 1 9890.00 0 1 3940 RIMROCK RD BILLINGS, MT 59102 (45.798539, -108.615831) 02/01/2020
5957 5957 111 LAKESIDE DRIVE GRAND RAPIDS, MI 49503 42.965178 -85.617664 0   235667 MARYWOOD HEALTH CENTER 111 LAKESIDE DRIVE, NE GRAND RAPIDS MI 49503 6164561993 400 Kent Non profit - Corporation 49 41.5 Medicare and Medicaid false MARYWOOD HEALTH CORPORATION 09/12/2013 false   false false false Resident Yes 3   3   5   5   5   1 12 1 12     2.52864 1.74771 0.62343 2.37113 4.89978 0.15852 2.24452 0.93154 0.49278 3.66884 2.34143 1.41075 0.47617 4.28253 03/11/2019 16 10 8 120 1 0 120 02/22/2018 5 5 0 36 1 0 36 2016-12-14 4 4 0 1 32 0 32 77.333 1 7 0 0.00 0 0 111 LAKESIDE DRIVE GRAND RAPIDS, MI 49503 (42.965178, -85.617664) 02/01/2020
5962 5962 220 EAST 24TH STREET NATIONAL CITY, CA 91950 32.662761 -117.098873 0   55954 WINDSOR GARDENS CONV CENTER OF SAN DIEGO 220 EAST 24TH STREET NATIONAL CITY CA 91950 6194746741 470 San Diego For profit - Corporation 98 94.8 Medicare and Medicaid false WINDSOR CARE CENTER NATIONAL CITY, INC 08/01/1968 false   false false false Resident Yes 4   3   5   5   4   2   2       2.36018 0.87752 0.38127 1.25879 3.61897 0.11378 2.13659 0.78436 0.38213 3.30308 2.29583 0.84125 0.37553 3.51332 10/11/2019 17 9 8 84 1 0 84 10/04/2018 14 13 1 68 1 0 68 2017-08-31 8 7 1 1 48 0 48 72.667 5 4 0 0.00 0 0 220 EAST 24TH STREET NATIONAL CITY, CA 91950 (32.662761, -117.098873) 02/01/2020
7980 7980 252 MEADOWFIELD DRIVE ROCHESTER HILLS, MI 48307 42.661345 -83.139064 0   235716 WELLBRIDGE OF ROCHESTER HILLS 252 MEADOWFIELD DRIVE ROCHESTER HILLS MI 48307 2482184800 620 Oakland For profit - Corporation 100 89.6 Medicare and Medicaid false WELLBRIDGE OF ROCHESTER LLC 12/28/2015 false   false false false Resident Yes 5   3   5   5   5   4   4       2.25485 1.11038 1.13267 2.24306 4.49791 0.25231 2.27283 0.86828 0.41969 3.5608 2.0619 0.9616 1.0158 4.05057 01/09/2019 12 5 8 108 1 0 108 10/05/2017 5 5 2 32 1 0 32 2016-09-28 2 2 0 1 8 0 8 66 3 11 0 0.00 0 0 252 MEADOWFIELD DRIVE ROCHESTER HILLS, MI 48307 (42.661345, -83.139064) 02/01/2020
10041 10041 917 SOUTH SCHEUBER ROAD CENTRALIA, WA 98531 46.711489 -122.986981 0   505373 PRESTIGE POST-ACUTE AND REHAB CENTER - CENTRALIA 917 SOUTH SCHEUBER ROAD CENTRALIA WA 98531 3607369384 200 Lewis For profit - Corporation 128 99 Medicare and Medicaid false CARE CENTER CENTRALIA INC 04/01/1991 false   false false false Resident Yes 3   3   4   3   4   3   3       2.34629 1.02481 0.63554 1.66035 4.00665 0.10261 2.018 0.75603 0.36546 3.1395 2.41644 1.01927 0.65453 4.09236 11/12/2019 15 7 8 124 0 0 124 01/11/2019 15 15 1 116 1 0 116 2017-12-22 9 8 1 1 48 0 48 108.667 1 5 3 93792.00 0 3 917 SOUTH SCHEUBER ROAD CENTRALIA, WA 98531 (46.711489, -122.986981) 02/01/2020
11069 11069 620 SOUTH HAZEL STREET ARLINGTON, WA 98223 48.18681 -122.128915 0   505351 ARLINGTON HEALTH AND REHABILITATION 620 SOUTH HAZEL STREET ARLINGTON WA 98223 3604038247 300 Snohomish For profit - Limited Liability company 76 51.8 Medicare and Medicaid false CLAY & DAVIS DEVELOPMENT LLC 10/01/1989 false   false false false Resident Yes 3   3   4   4   4   2   2       2.61999 1.10792 0.45528 1.5632 4.18318 0 2.25378 0.73042 0.34156 3.32576 2.41604 1.14056 0.5017 4.03338 06/28/2019 15 8 8 68 1 0 68 04/20/2018 19 15 4 116 1 0 116 2017-03-14 16 10 7 1 144 0 144 96.667 10 4 1 5103.00 0 1 620 SOUTH HAZEL STREET ARLINGTON, WA 98223 (48.18681, -122.128915) 02/01/2020
11310 11310 2586 BUTHMANN AVE TRACY, CA 95376 37.755632 -121.432273 0   555245 NEW HOPE POST ACUTE CARE 2586 BUTHMANN AVE TRACY CA 95376 2098322273 490 San Joaquin For profit - Corporation 99 79.3 Medicare and Medicaid false EVERGREEN AT TRACY LLC 02/25/1987 false   false false false Resident Yes 4   3   5   4   5   3   3       2.53644 1.04438 0.5364 1.58079 4.11723 0.05286 2.15217 0.68906 0.30303 3.14425 2.44942 1.13969 0.66626 4.19895 01/25/2019 9 4 8 44 1 0 44 02/09/2018 14 12 2 68 1 0 68 2017-02-10 9 6 3 1 48 0 48 52.667 7 11 0 0.00 0 0 2586 BUTHMANN AVE TRACY, CA 95376 (37.755632, -121.432273) 02/01/2020
11996 11996 6700 COLUMBIA PIKE ANNANDALE, VA 22003 38.836653 -77.175258 0   495155 ANNANDALE HEALTHCARE CENTER 6700 COLUMBIA PIKE ANNANDALE VA 22003 7032567000 290 Fairfax For profit - Corporation 222 203.1 Medicare and Medicaid false COLUMBIA LEASING CO., LLC 04/01/1985 false   false false false Resident Yes 4   3   5   4   5   3   3       2.03451 0.73576 0.59774 1.3335 3.36801 0.05513 2.16649 0.79536 0.40272 3.36458 1.95172 0.69559 0.55865 3.20994 08/23/2018 17 11 8 88 1 0 88 03/02/2017 5 5 2 28 1 0 28 2016-02-25 8 8 0 1 36 0 36 59.333 0 23 0 0.00 0 0 6700 COLUMBIA PIKE ANNANDALE, VA 22003 (38.836653, -77.175258) 02/01/2020
12374 12374 1010 LAKE HUNTER CIRCLE MOUNT PLEASANT, SC 29464 32.814275 -79.862006 0   425404 SAVANNAH GRACE AT THE PALMS OF MT PLEASANT 1010 LAKE HUNTER CIRCLE MOUNT PLEASANT SC 29464 8433882030 90 Charleston For profit - Limited Liability company 42 32.5 Medicare false SNH SE SG TENANT LLC 09/07/2012 true   false false false Resident Yes 4   3   4   2   5   4   4       2.52515 2.04533 0.95805 3.00338 5.52853 0.24324 2.04055 0.84841 0.43598 3.32494 2.57191 1.81278 0.82708 5.33186 05/15/2019 8 8 8 48 1 0 48 05/18/2018 4 4 0 20 1 0 20 2017-01-20 7 7 0 1 24 0 24 34.667 0 0 0 0.00 0 0 1010 LAKE HUNTER CIRCLE MOUNT PLEASANT, SC 29464 (32.814275, -79.862006) 02/01/2020
13871 13871 44 GOETHALS DRIVE RICHLAND, WA 99352 46.261454 -119.281667 0   505070 LIFE CARE CENTER OF RICHLAND 44 GOETHALS DRIVE RICHLAND WA 99352 5099431117 20 Benton For profit - Limited Liability company 104 45.1 Medicare and Medicaid false RICHLAND MEDICAL INVESTORS, LLC 07/10/1979 false   false false false Resident Yes 5   3   5   5   4   4   4       2.42927 0.78134 1.06426 1.84561 4.27488 0.23764 2.20052 0.83445 0.4175 3.45247 2.29439 0.70409 0.95946 3.97052 08/29/2019 21 13 8 152 1 0 152 09/18/2018 13 6 7 80 1 0 80 2017-08-30 11 7 4 1 120 0 120 122.667 6 15 5 123232.00 1 6 44 GOETHALS DRIVE RICHLAND, WA 99352 (46.261454, -119.281667) 02/01/2020
14172 14172 149 KLATTENHOFF LANE HUTTO, TX 78634 30.511969 -97.579603 0   676382 FALCON RIDGE REHABILITATION 149 KLATTENHOFF LANE HUTTO TX 78634 5128407000 970 Williamson For profit - Corporation 83 88.6 Medicare and Medicaid false SOUTH LIMESTONE HOSPITAL DISTRICT 04/02/2015 false   false false true Resident Yes 2   3   3   2   4   1   1       2.19774 0.86082 0.25388 1.1147 3.31245 0.06103 2.25497 0.82828 0.41066 3.4939 2.0256 0.78148 0.23269 3.04012 03/21/2019 14 6 8 108 1 0 108 03/21/2018 1 1 0 4 1 0 4 2017-03-09 7 7 7 1 56 0 56 64.667 3 2 0 0.00 0 0 149 KLATTENHOFF LANE HUTTO, TX 78634 (30.511969, -97.579603) 02/01/2020
15311 15311 2219 NORTH 6TH STREET CHENEY, WA 99004 47.500879 -117.575525 0   505346 CHENEY CARE CENTER 2219 NORTH 6TH STREET CHENEY WA 99004 5092356196 310 Spokane Non profit - Corporation 54 49.9 Medicare and Medicaid false CHENEY CARE CENTER 09/01/1989 true   false false false Resident Yes 5   3   5   5   5   4   4       3.68579 0.14598 0.90086 1.04683 4.73262 0.06154 2.62285 0.85543 0.38564 3.86392 2.9206 0.12831 0.87924 3.92759 03/08/2019 20 13 8 104 1 0 104 05/10/2018 18 15 3 120 1 0 120 2017-05-25 11 4 7 1 64 0 64 102.667 6 4 2 13775.00 0 2 2219 NORTH 6TH STREET CHENEY, WA 99004 (47.500879, -117.575525) 02/01/2020

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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
);