nh_gen_info_geocoded_final
Data source: Big Local News · About: big-local-datasette
13 rows where Overall Rating = 1 and "Rating Cycle 3 Standard Health Survey Date" is on date 2017-02-23
This data as json, copyable, CSV (advanced)
Suggested facets: geocode_flag, geocode_accuracy, prvdr_state, prvdr_cnty, prvdr_cnty_name, ownership, Abuse Icon, With a Resident and Family Council, Health Inspection Rating, QM Rating, Long-Stay QM Rating, Short-Stay QM Rating, Staffing Rating, RN Staffing Rating, 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 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, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1859 | 1859 | 4604 LOWE ROAD LOUISVILLE, KY 40220 | 38.22367 | -85.610218 | 0 | 185301 | REGIS WOODS | 4604 LOWE ROAD | LOUISVILLE | KY | 40220 | 5024511401 | 550 | Jefferson | For profit - Corporation | 186 | 152.2 | Medicare and Medicaid | false | PINE TREE VILLA, LLC | 11/01/1991 | false | false | false | false | Resident | Yes | 1 | 1 | 1 | 2 | 1 | 3 | 3 | 1.82232 | 0.99325 | 0.58894 | 1.58219 | 3.40451 | 0.03424 | 1.85246 | 0.77468 | 0.40064 | 3.02778 | 2.04452 | 0.96409 | 0.55329 | 3.60564 | 06/25/2019 | 16 | 8 | 16 | 566 | 2 | 283 | 849 | 04/12/2018 | 18 | 14 | 4 | 120 | 1 | 0 | 120 | 2017-02-23 | 15 | 8 | 7 | 1 | 225 | 0 | 225 | 502 | 6 | 9 | 3 | 520187.00 | 1 | 4 | 4604 LOWE ROAD LOUISVILLE, KY 40220 (38.22367, -85.610218) | 02/01/2020 | |||||||||||
3017 | 3017 | 1401 US-190, Denham Springs, LA 70726, USA | 30.4721431 | -90.96451069999999 | 1 | ROOFTOP | 195297 | PONTCHARTRAIN HEALTH CARE CENTER | 1401 HIGHWAY 190 | MANDEVILLE | LA | 70448 | 9856268581 | 510 | St. Tammany | For profit - Corporation | 182 | 111.7 | Medicare and Medicaid | false | PONTCHARTRAIN GUEST HOUSE INC | 09/01/1994 | false | false | false | false | Resident | Yes | 1 | 1 | 1 | 1 | 1 | 2 | 1 | 2.33497 | 1.41096 | 0.22605 | 1.63701 | 3.97197 | 0.0814 | 2.04105 | 0.76461 | 0.38216 | 3.18782 | 2.37763 | 1.38757 | 0.22263 | 3.99545 | 01/11/2019 | 13 | 9 | 4 | 189 | 1 | 0 | 189 | 02/09/2018 | 4 | 4 | 0 | 24 | 1 | 0 | 24 | 2017-02-23 | 8 | 8 | 0 | 1 | 40 | 0 | 40 | 109.167 | 3 | 0 | 1 | 86720.00 | 1 | 2 | 02/01/2020 | |||||||||||
3218 | 3218 | 233 CARROLLTON STREET BUCHANAN, GA 30113 | 33.799015 | -85.186099 | 0 | 115592 | COUNTRYSIDE HEALTH CENTER | 233 CARROLLTON STREET | BUCHANAN | GA | 30113 | 7706463861 | 570 | Haralson | For profit - Corporation | 62 | 58.5 | Medicare and Medicaid | false | CS SNF LLC | 09/12/1995 | false | false | false | false | Resident | Yes | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1.44359 | 0.98677 | 0.28138 | 1.26815 | 2.71173 | 0.06691 | 1.88906 | 0.71972 | 0.35954 | 2.96832 | 1.58823 | 1.03095 | 0.29456 | 2.92947 | 01/10/2019 | 9 | 9 | 0 | 56 | 1 | 0 | 56 | 01/05/2018 | 8 | 8 | 0 | 52 | 1 | 0 | 52 | 2017-02-23 | 3 | 3 | 0 | 1 | 16 | 0 | 16 | 48 | 0 | 0 | 0 | 0.00 | 0 | 0 | 233 CARROLLTON STREET BUCHANAN, GA 30113 (33.799015, -85.186099) | 02/01/2020 | |||||||||||
4961 | 4961 | 1400 DAVENPORT AVENUE MER ROUGE, LA 71261 | 32.780538 | -91.806193 | 0 | 195598 | OAK WOODS HOME FOR THE ELDERLY | 1400 DAVENPORT AVENUE | MER ROUGE | LA | 71261 | 3186473691 | 330 | Morehouse | Non profit - Corporation | 119 | 77.6 | Medicare and Medicaid | false | MER ROUGE COMMUNITY SVC INC | 06/01/2004 | false | false | false | false | Both | Yes | 1 | 1 | 1 | 2 | 1 | 3 | 1 | 3.28756 | 1.4389 | 0.1765 | 1.6154 | 4.90295 | 0.06275 | 1.97527 | 0.64063 | 0.28755 | 2.90346 | 3.4591 | 1.6889 | 0.23102 | 5.41496 | 04/05/2019 | 7 | 7 | 0 | 261 | 1 | 0 | 261 | 03/15/2018 | 3 | 2 | 1 | 12 | 1 | 0 | 12 | 2017-02-23 | 13 | 11 | 2 | 1 | 92 | 0 | 92 | 149.833 | 0 | 4 | 1 | 45799.00 | 0 | 1 | 1400 DAVENPORT AVENUE MER ROUGE, LA 71261 (32.780538, -91.806193) | 02/01/2020 | |||||||||||
6022 | 6022 | 1025 EUCLID AVENUE PAINTSVILLE, KY 41240 | 37.817317 | -82.785053 | 0 | 185414 | MOUNTAIN MANOR OF PAINTSVILLE | 1025 EUCLID AVENUE | PAINTSVILLE | KY | 41240 | 6067895808 | 570 | Johnson | For profit - Corporation | 126 | 106.7 | Medicare and Medicaid | false | PAINTSVILLE INVESTORS, LLC | 09/19/1995 | false | false | false | false | Resident | Yes | 1 | 1 | 1 | 1 | 1 | 2 | 2 | 2.78065 | 0.97743 | 0.49506 | 1.47249 | 4.25313 | 0.05048 | 2.20742 | 0.81566 | 0.42519 | 3.44828 | 2.61804 | 0.90107 | 0.43823 | 3.95512 | 05/08/2019 | 7 | 7 | 0 | 24 | 1 | 0 | 24 | 03/07/2018 | 27 | 20 | 18 | 662 | 1 | 0 | 662 | 2017-02-23 | 20 | 7 | 15 | 1 | 768 | 0 | 768 | 360.667 | 1 | 11 | 1 | 430641.00 | 1 | 2 | 1025 EUCLID AVENUE PAINTSVILLE, KY 41240 (37.817317, -82.785053) | 02/01/2020 | |||||||||||
7695 | 7695 | 2319 EAST MAIN STREET NEW IBERIA, LA 70560 | 29.988333 | -91.784105 | 0 | 195618 | CONSOLATA HOME | 2319 EAST MAIN STREET | NEW IBERIA | LA | 70560 | 3373658226 | 220 | Iberia | Non profit - Church related | 114 | 71.8 | Medicare and Medicaid | false | CONSOLATA HOME | 03/21/2005 | false | false | false | false | Resident | Yes | 1 | 1 | 2 | 2 | 3 | 3 | 2 | 2.63388 | 1.0625 | 0.39732 | 1.45982 | 4.0937 | 0.04044 | 2.08362 | 0.67394 | 0.30062 | 3.05818 | 2.6272 | 1.18547 | 0.49746 | 4.29246 | 04/10/2019 | 4 | 4 | 0 | 20 | 1 | 0 | 20 | 03/15/2018 | 3 | 3 | 0 | 24 | 1 | 0 | 24 | 2017-02-23 | 19 | 13 | 6 | 1 | 315 | 0 | 315 | 70.5 | 0 | 2 | 2 | 18764.00 | 0 | 2 | 2319 EAST MAIN STREET NEW IBERIA, LA 70560 (29.988333, -91.784105) | 02/01/2020 | |||||||||||
8172 | 8172 | 235 HUNTSVILLE ROAD EUREKA SPRINGS, AR 72632 | 36.381056 | -93.741883 | 0 | 45242 | BRIGHTON RIDGE | 235 HUNTSVILLE ROAD | EUREKA SPRINGS | AR | 72632 | 4792537038 | 70 | Carroll | For profit - Corporation | 100 | 43.2 | Medicare and Medicaid | false | LTC OF EUREKA SPRINGS LLC | 08/01/1994 | false | false | false | false | Resident | Yes | 1 | 1 | 1 | 2 | 1 | 4 | 4 | 2.3142 | 0.60872 | 0.70706 | 1.31578 | 3.62997 | 0.02168 | 2.02323 | 0.68703 | 0.30028 | 3.01054 | 2.37723 | 0.66623 | 0.88625 | 3.86645 | 03/14/2019 | 9 | 7 | 2 | 76 | 1 | 0 | 76 | 05/18/2018 | 12 | 7 | 5 | 285 | 1 | 0 | 285 | 2017-02-23 | 6 | 3 | 3 | 1 | 407 | 0 | 407 | 200.833 | 0 | 4 | 2 | 36760.00 | 0 | 2 | 235 HUNTSVILLE ROAD EUREKA SPRINGS, AR 72632 (36.381056, -93.741883) | 02/01/2020 | |||||||||||
8796 | 8796 | 3905 CLEMMONS ROAD CLEMMONS, NC 27012 | 36.018655 | -80.392415 | 0 | 345131 | ACCORDIUS HEALTH AT CLEMMONS | 3905 CLEMMONS ROAD | CLEMMONS | NC | 27012 | 3367669158 | 280 | Davidson | For profit - Corporation | 120 | 82.8 | Medicare and Medicaid | false | ACCORDIUS HEALTH AT CLEMMONS, LLC | 10/01/1974 | false | true | false | false | Resident | Yes | 1 | 1 | 1 | 1 | 1 | 2 | 2 | 2.4839 | 0.68814 | 0.44774 | 1.13588 | 3.61978 | 0.05835 | 2.09976 | 0.84303 | 0.44842 | 3.39121 | 2.45855 | 0.61379 | 0.37581 | 3.42279 | 01/10/2019 | 16 | 6 | 11 | 175 | 1 | 0 | 175 | 02/28/2018 | 14 | 9 | 9 | 254 | 1 | 0 | 254 | 2017-02-23 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 172.167 | 2 | 24 | 2 | 121916.00 | 2 | 4 | 3905 CLEMMONS ROAD CLEMMONS, NC 27012 (36.018655, -80.392415) | 02/01/2020 | |||||||||||
13622 | 13622 | 1900 MEDICAL PKWY SAN MARCOS, TX 78666 | 29.854602 | -97.946132 | 0 | 455960 | ADVENTHEALTH CARE CENTER SAN MARCOS | 1900 MEDICAL PKWY | SAN MARCOS | TX | 78666 | 5123961888 | 631 | Hays | Non profit - Corporation | 116 | 72 | Medicare and Medicaid | false | SAN MARCOS NURSING & REHAB CENTER, INC | 10/01/1991 | false | false | false | false | Resident | Yes | 1 | 1 | 2 | 3 | 2 | 2 | 2 | 2.11021 | 1.17374 | 0.48942 | 1.66316 | 3.77337 | 0.06628 | 2.10758 | 0.7633 | 0.37687 | 3.24774 | 2.08093 | 1.15628 | 0.4888 | 3.72565 | 04/05/2019 | 19 | 19 | 0 | 180 | 1 | 0 | 180 | 03/09/2018 | 9 | 7 | 2 | 96 | 1 | 0 | 96 | 2017-02-23 | 6 | 5 | 1 | 1 | 44 | 0 | 44 | 129.333 | 0 | 6 | 0 | 0.00 | 0 | 0 | 1900 MEDICAL PKWY SAN MARCOS, TX 78666 (29.854602, -97.946132) | 02/01/2020 | |||||||||||
13743 | 13743 | 5020 SPACE CENTER BLVD PASADENA, TX 77505 | 29.635484 | -95.14293 | 0 | 676309 | BAYWOOD CROSSING REHABILITATION & HEALTHCARE CENTE | 5020 SPACE CENTER BLVD | PASADENA | TX | 77505 | 7135751800 | 610 | Harris | For profit - Corporation | 124 | 107.2 | Medicare and Medicaid | false | BAYWOOD CRENSHAW LLC | 03/12/2012 | false | false | false | false | Resident | Yes | 1 | 2 | 3 | 2 | 4 | 1 | 1 | 1.95577 | 0.78893 | 0.23089 | 1.01982 | 2.97559 | 0.02369 | 2.1043 | 0.85766 | 0.46823 | 3.43019 | 1.93163 | 0.69168 | 0.1856 | 2.78168 | 03/20/2019 | 11 | 8 | 3 | 64 | 1 | 0 | 64 | 03/16/2018 | 12 | 12 | 0 | 120 | 1 | 0 | 120 | 2017-02-23 | 9 | 9 | 0 | 1 | 104 | 0 | 104 | 89.333 | 1 | 1 | 0 | 0.00 | 0 | 0 | 5020 SPACE CENTER BLVD PASADENA, TX 77505 (29.635484, -95.14293) | 02/01/2020 | |||||||||||
13888 | 13888 | 701 S MARKET ST CARTHAGE, TX 75633 | 32.146169 | -94.340668 | 0 | 455963 | CARTHAGE HEALTHCARE CENTER | 701 S MARKET ST | CARTHAGE | TX | 75633 | 9036936671 | 842 | Panola | For profit - Corporation | 104 | 53.2 | Medicare and Medicaid | false | SLP CARTHAGE LLC | 12/01/1991 | false | false | false | false | Resident | Yes | 1 | 2 | 2 | 3 | 1 | 1 | 1 | 1.65062 | 0.98291 | 0.17522 | 1.15813 | 2.80875 | 0.01792 | 1.83353 | 0.79942 | 0.44863 | 3.08157 | 1.87101 | 0.92454 | 0.147 | 2.92276 | 03/27/2019 | 6 | 6 | 0 | 56 | 1 | 0 | 56 | 04/20/2018 | 17 | 13 | 4 | 136 | 1 | 0 | 136 | 2017-02-23 | 5 | 3 | 2 | 1 | 64 | 0 | 64 | 84 | 1 | 2 | 0 | 0.00 | 0 | 0 | 701 S MARKET ST CARTHAGE, TX 75633 (32.146169, -94.340668) | 02/01/2020 | |||||||||||
14287 | 14287 | 303 HOLLOW TREE LANE HOUSTON, TX 77090 | 30.025512 | -95.438313 | 0 | 676356 | THE HEIGHTS OF NORTH HOUSTON | 303 HOLLOW TREE LANE | HOUSTON | TX | 77090 | 8327058700 | 610 | Harris | Government - Hospital district | 131 | 96.1 | Medicare and Medicaid | false | LIBERTY COUNTY HOSPITAL DISTRICT NO 1 | 01/23/2014 | false | false | false | false | Resident | Yes | 1 | 2 | 3 | 5 | 1 | 1 | 1 | 1.8031 | 0.85638 | 0.32109 | 1.17747 | 2.98057 | 0.10838 | 2.03009 | 0.80098 | 0.39136 | 3.22243 | 1.84596 | 0.80394 | 0.30881 | 2.96599 | 02/28/2019 | 10 | 7 | 3 | 80 | 1 | 0 | 80 | 02/09/2018 | 12 | 6 | 7 | 76 | 1 | 0 | 76 | 2017-02-23 | 7 | 3 | 5 | 1 | 80 | 0 | 80 | 78.667 | 6 | 13 | 1 | 2533.00 | 0 | 1 | 303 HOLLOW TREE LANE HOUSTON, TX 77090 (30.025512, -95.438313) | 02/01/2020 | |||||||||||
14779 | 14779 | 1721 BALD HILL LOOP MADISON, NC 27025 | 36.36186 | -79.905258 | 0 | 345050 | JACOB'S CREEK NURSING AND REHABILITATION CENTER | 1721 BALD HILL LOOP | MADISON | NC | 27025 | 3365489658 | 780 | Rockingham | For profit - Corporation | 170 | 155.4 | Medicare and Medicaid | false | GRANITE FALLS LTC, LLC | 05/08/1968 | false | false | false | false | Resident | Yes | 1 | 2 | 3 | 3 | 2 | 1 | 1 | 2.2724 | 0.83857 | 0.21025 | 1.04882 | 3.32122 | 0.04788 | 2.09348 | 0.78202 | 0.38855 | 3.26406 | 2.25596 | 0.80631 | 0.20366 | 3.26282 | 03/28/2019 | 8 | 8 | 1 | 36 | 1 | 0 | 36 | 02/22/2018 | 6 | 2 | 4 | 103 | 1 | 0 | 103 | 2017-02-23 | 6 | 4 | 6 | 1 | 32 | 0 | 32 | 57.667 | 0 | 5 | 1 | 49740.00 | 0 | 1 | 1721 BALD HILL LOOP MADISON, NC 27025 (36.36186, -79.905258) | 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 );