nh_gen_info_geocoded_final
Data source: Big Local News · About: big-local-datasette
15 rows where Number of Fines = 3 and Physical Therapist Staffing Footnote = 6
This data as json, copyable, CSV (advanced)
Suggested facets: prvdr_city, prvdr_state, prvdr_cnty, prvdr_cnty_name, ownership, nmbr_beds, prvdr_type, Legal Business Name, Continuing Care Retirement Community, Special Focus Status, Abuse Icon, Provider Changed Ownership in Last 12 Months, With a Resident and Family Council, 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, 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 Number of Health Revisits, 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 Number of Health Revisits, Rating Cycle 2 Health Revisit 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 Health Revisit Score, Rating Cycle 3 Total Health Score, Number of Facility Reported Incidents, Number of Substantiated Complaints, Number of Payment Denials, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
49 | 49 | 3333 BROWN ROAD SAINT LOUIS, MO 63114 | 38.712458 | -90.349985 | 0 | 265733 | ST JOHNS PLACE | 3333 BROWN ROAD | SAINT LOUIS | MO | 63114 | 3144262211 | 940 | St. Louis | For profit - Corporation | 94 | 62.2 | Medicare and Medicaid | false | Legal Business Name Not Available | 06/01/2002 | false | SFF | false | false | false | Both | Yes | 18 | 18 | 18 | 18 | 18 | 18 | 18 | 6 | 6 | 09/13/2019 | 10 | 7 | 3 | 60 | 1 | 0 | 60 | 02/22/2019 | 9 | 7 | 2 | 115 | 1 | 0 | 115 | 2018-09-13 | 18 | 8 | 13 | 1 | 320 | 0 | 320 | 121.667 | 3 | 15 | 3 | 204231.00 | 1 | 4 | 3333 BROWN ROAD SAINT LOUIS, MO 63114 (38.712458, -90.349985) | 02/01/2020 | ||||||||||||||||||||||
78 | 78 | 7201 WADE PARK CLEVELAND, OH 44103 | 41.515754 | -81.638677 | 0 | 366101 | ELIZA BRYANT CENTER | 7201 WADE PARK | CLEVELAND | OH | 44103 | 2163616141 | 170 | Cuyahoga | Non profit - Corporation | 158 | 132 | Medicare and Medicaid | false | ELIZA BRYANT VILLAGE | 12/20/1996 | false | false | false | false | Resident | Yes | 1 | 1 | 3 | 4 | 2 | 1 | 12 | 1 | 12 | 6 | 6 | 06/13/2019 | 7 | 7 | 0 | 56 | 1 | 0 | 56 | 05/10/2018 | 15 | 8 | 7 | 293 | 1 | 0 | 293 | 2017-03-30 | 9 | 3 | 6 | 1 | 76 | 0 | 76 | 138.333 | 3 | 7 | 3 | 78970.00 | 0 | 3 | 7201 WADE PARK CLEVELAND, OH 44103 (41.515754, -81.638677) | 02/01/2020 | |||||||||||||||||||||
903 | 903 | 815 EAST IRVING PARK ROAD STREAMWOOD, IL 60107 | 42.009511 | -88.162616 | 0 | 145701 | BELLA TERRA STREAMWOOD | 815 EAST IRVING PARK ROAD | STREAMWOOD | IL | 60107 | 6308375300 | 141 | Cook | For profit - Individual | 214 | 126.8 | Medicare and Medicaid | false | STREAMWOOD SKILLED NURSING FACILITY, LLC | 08/28/1991 | false | false | false | true | Resident | Yes | 2 | 2 | 5 | 4 | 5 | 1 | 12 | 1 | 12 | 6 | 6 | 03/20/2019 | 16 | 13 | 3 | 124 | 1 | 0 | 124 | 05/29/2018 | 9 | 4 | 5 | 76 | 1 | 0 | 76 | 2017-04-28 | 8 | 5 | 3 | 1 | 64 | 0 | 64 | 98 | 4 | 15 | 3 | 44561.00 | 0 | 3 | 815 EAST IRVING PARK ROAD STREAMWOOD, IL 60107 (42.009511, -88.162616) | 02/01/2020 | |||||||||||||||||||||
1985 | 1985 | 3910 RAINBOW BLVD KANSAS CITY, KS 66103 | 39.056897 | -94.611883 | 0 | 175544 | IGNITE MEDICAL RESORT A PTR OF THE UNIV OF KANSAS | 3910 RAINBOW BLVD, SUITE 400 | KANSAS CITY | KS | 66103 | 9139018462 | 986 | Wyandotte | For profit - Corporation | 96 | 63.6 | Medicare and Medicaid | false | IGNITE MEDICAL RESORT A PTR OF THE UNIV OF KANSAS HEALTH SYSTEM LLC | 06/17/2014 | false | false | false | true | Resident | Yes | 1 | 1 | 4 | 4 | 3 | 2 | 2 | 6 | 6 | 01/07/2019 | 12 | 12 | 10 | 84 | 1 | 0 | 84 | 05/15/2017 | 9 | 4 | 8 | 80 | 1 | 0 | 80 | 2015-10-07 | 19 | 17 | 2 | 1 | 203 | 0 | 203 | 102.5 | 2 | 8 | 3 | 32675.00 | 0 | 3 | 3910 RAINBOW BLVD KANSAS CITY, KS 66103 (39.056897, -94.611883) | 02/01/2020 | |||||||||||||||||||||||
3185 | 3185 | 652 NORTH COASTAL HIGHWAY MIDWAY, GA 31320 | 31.809221 | -81.430589 | 0 | 115553 | MAGNOLIA MANOR OF MIDWAY | 652 NORTH COASTAL HIGHWAY 17 | MIDWAY | GA | 31320 | 9128843361 | 680 | Liberty | For profit - Limited Liability company | 169 | 118.8 | Medicare and Medicaid | false | WOODLANDS HEALTHCARE & REHAB LLC | 06/01/1993 | false | false | false | false | Both | Yes | 1 | 1 | 1 | 1 | 1 | 1 | 12 | 1 | 12 | 6 | 6 | 03/15/2019 | 6 | 6 | 0 | 52 | 1 | 0 | 52 | 02/02/2018 | 4 | 4 | 0 | 68 | 1 | 0 | 68 | 2017-02-09 | 18 | 11 | 17 | 1 | 327 | 0 | 327 | 103.167 | 0 | 3 | 3 | 71284.00 | 0 | 3 | 652 NORTH COASTAL HIGHWAY MIDWAY, GA 31320 (31.809221, -81.430589) | 02/01/2020 | |||||||||||||||||||||
6023 | 6023 | 8001 SOUTH WESTERN AVENUE CHICAGO, IL 60620 | 41.747748 | -87.682719 | 0 | 145864 | BRIA OF FOREST EDGE | 8001 SOUTH WESTERN AVENUE | CHICAGO | IL | 60620 | 7734366600 | 141 | Cook | For profit - Corporation | 328 | 260.5 | Medicare and Medicaid | false | FOREST EDGE HEALTHCARE & REHABILITATION CENTER LLC | 03/01/1996 | false | false | false | false | Resident | Yes | 2 | 1 | 5 | 5 | 3 | 1 | 12 | 1 | 12 | 6 | 6 | 09/18/2019 | 17 | 11 | 6 | 108 | 1 | 0 | 108 | 08/16/2018 | 29 | 18 | 11 | 192 | 1 | 0 | 192 | 2017-10-15 | 12 | 8 | 4 | 1 | 76 | 0 | 76 | 130.667 | 3 | 36 | 3 | 87301.00 | 1 | 4 | 8001 SOUTH WESTERN AVENUE CHICAGO, IL 60620 (41.747748, -87.682719) | 02/01/2020 | |||||||||||||||||||||
6264 | 6264 | 4314 SOUTH WABASH AVENUE CHICAGO, IL 60653 | 41.815926 | -87.624622 | 0 | 146164 | COMMUNITY CARE CENTER | 4314 SOUTH WABASH AVENUE | CHICAGO | IL | 60653 | 7735388300 | 141 | Cook | For profit - Corporation | 204 | 170.4 | Medicare and Medicaid | false | Legal Business Name Not Available | 11/06/2012 | false | false | false | false | Resident | Yes | 1 | 1 | 2 | 4 | 1 | 2 | 2 | 6 | 6 | 09/26/2019 | 16 | 13 | 3 | 112 | 1 | 0 | 112 | 08/17/2018 | 13 | 9 | 4 | 92 | 1 | 0 | 92 | 2017-08-24 | 30 | 15 | 20 | 1 | 216 | 0 | 216 | 122.667 | 1 | 43 | 3 | 61628.00 | 1 | 4 | 4314 SOUTH WABASH AVENUE CHICAGO, IL 60653 (41.815926, -87.624622) | 02/01/2020 | |||||||||||||||||||||||
7189 | 7189 | 5801 W BETHEL AVE MUNCIE, IN 47304 | 40.227949 | -85.458111 | 0 | 155170 | WESTMINSTER VILLAGE MUNCIE INC | 5801 W BETHEL AVE | MUNCIE | IN | 47304 | 7652882155 | 170 | Delaware | Non profit - Corporation | 76 | 56.9 | Medicare | false | Legal Business Name Not Available | 10/07/1975 | true | false | false | false | Resident | Yes | 4 | 4 | 5 | 5 | 5 | 1 | 12 | 1 | 12 | 6 | 6 | 04/30/2019 | 2 | 2 | 0 | 8 | 1 | 0 | 8 | 06/29/2018 | 7 | 6 | 1 | 44 | 1 | 0 | 44 | 2017-08-16 | 6 | 3 | 3 | 1 | 60 | 0 | 60 | 28.667 | 0 | 8 | 3 | 36943.00 | 0 | 3 | 5801 W BETHEL AVE MUNCIE, IN 47304 (40.227949, -85.458111) | 02/01/2020 | |||||||||||||||||||||
7968 | 7968 | 1600 S WOODLAWN BLVD WICHITA, KS 67218 | 37.664157 | -97.262146 | 0 | 175452 | ORCHARD GARDENS | 1600 S. WOODLAWN BLVD | WICHITA | KS | 67218 | 3166919999 | 860 | Sedgwick | For profit - Limited Liability company | 80 | 64.4 | Medicare and Medicaid | false | ORCHARD GARDENS,LLC | 03/11/2002 | true | SFF Candidate | false | false | true | Resident | Yes | 1 | 1 | 4 | 1 | 5 | 1 | 12 | 1 | 12 | 6 | 6 | 01/21/2020 | 27 | 19 | 8 | 256 | 0 | 0 | 256 | 01/10/2019 | 4 | 0 | 4 | 64 | 0 | 0 | 64 | 2018-07-03 | 55 | 5 | 50 | 1 | 754 | 0 | 754 | 275 | 4 | 13 | 3 | 47386.00 | 1 | 4 | 1600 S WOODLAWN BLVD WICHITA, KS 67218 (37.664157, -97.262146) | 02/01/2020 | ||||||||||||||||||||
10927 | 10927 | 2461 LEGION ROAD FAYETTEVILLE, NC 28306 | 35.013158 | -78.908243 | 0 | 345376 | CUMBERLAND NURSING AND REHABILITATION CENTER | 2461 LEGION ROAD | FAYETTEVILLE | NC | 28306 | 9104249417 | 250 | Cumberland | For profit - Individual | 120 | Medicare and Medicaid | false | MAPLE LTC GROUP, LLC | 06/13/1991 | false | true | false | false | Resident | Yes | 1 | 1 | 2 | 2 | 2 | 2 | 2 | 6 | 6 | 07/03/2018 | 11 | 11 | 5 | 238 | 1 | 0 | 238 | 07/21/2017 | 10 | 5 | 10 | 56 | 2 | 28 | 84 | 2016-10-06 | 18 | 1 | 17 | 1 | 96 | 0 | 96 | 163 | 0 | 45 | 3 | 221799.00 | 1 | 4 | 2461 LEGION ROAD FAYETTEVILLE, NC 28306 (35.013158, -78.908243) | 02/01/2020 | ||||||||||||||||||||||||
11296 | 11296 | 614 S ROCK AVE VIROQUA, WI 54665 | 43.550846 | -90.890511 | 0 | 525591 | BETHEL HOME AND SERVICES | 614 S ROCK AVE | VIROQUA | WI | 54665 | 6086372171 | 610 | Vernon | Non profit - Church related | 50 | 45.9 | Medicare and Medicaid | false | BETHEL HOME AND SERVICES INC | 09/01/1996 | false | SFF Candidate | true | false | false | Resident | Yes | 1 | 1 | 4 | 3 | 5 | 1 | 12 | 1 | 12 | 6 | 6 | 07/18/2019 | 5 | 2 | 3 | 349 | 1 | 0 | 349 | 05/17/2018 | 16 | 7 | 9 | 245 | 1 | 0 | 245 | 2017-02-14 | 1 | 1 | 0 | 1 | 4 | 0 | 4 | 256.833 | 0 | 4 | 3 | 232189.00 | 0 | 3 | 614 S ROCK AVE VIROQUA, WI 54665 (43.550846, -90.890511) | 02/01/2020 | ||||||||||||||||||||
11351 | 11351 | 2611 SOUTH DEARBORN SEATTLE, WA 98144 | 47.595543 | -122.298278 | 0 | 505511 | PARAMOUNT REHABILITATION AND NURSING | 2611 SOUTH DEARBORN | SEATTLE | WA | 98144 | 2063256700 | 160 | King | For profit - Limited Liability company | 165 | 92.1 | Medicare and Medicaid | false | PARAMOUNT REHABILITATION AND NURSING LLC | 06/11/2003 | false | SFF | true | false | false | Resident | Yes | 18 | 18 | 18 | 18 | 18 | 18 | 18 | 6 | 6 | 09/24/2019 | 56 | 45 | 11 | 518 | 1 | 0 | 518 | 04/05/2019 | 37 | 22 | 17 | 224 | 1 | 0 | 224 | 2018-10-18 | 40 | 29 | 17 | 1 | 220 | 0 | 220 | 370.333 | 19 | 26 | 3 | 51132.00 | 1 | 4 | 2611 SOUTH DEARBORN SEATTLE, WA 98144 (47.595543, -122.298278) | 02/01/2020 | ||||||||||||||||||||||
12272 | 12272 | 345 COUNTRY CLUB DR CALDWELL, TX 77836 | 30.543708 | -96.711581 | 0 | 676227 | COPPERAS HOLLOW NURSING & REHABILITATION CENTER | 345 COUNTRY CLUB DR | CALDWELL | TX | 77836 | 9795674300 | 221 | Burleson | For profit - Limited Liability company | 41 | 41.6 | Medicare and Medicaid | false | CORYELL COUNTY MEMORIAL HOSPITAL AUTHORITY | 06/26/2009 | false | SFF Candidate | true | false | false | Resident | Yes | 1 | 1 | 3 | 2 | 4 | 1 | 12 | 1 | 12 | 6 | 6 | 07/31/2019 | 6 | 5 | 1 | 36 | 1 | 0 | 36 | 06/07/2018 | 14 | 8 | 6 | 470 | 1 | 0 | 470 | 2017-06-01 | 11 | 7 | 4 | 1 | 739 | 0 | 739 | 297.833 | 1 | 10 | 3 | 381814.00 | 0 | 3 | 345 COUNTRY CLUB DR CALDWELL, TX 77836 (30.543708, -96.711581) | 02/01/2020 | ||||||||||||||||||||
13985 | 13985 | 535 MCFARLAND ROAD LATROBE, PA 15650 | 40.327089 | -79.394327 | 0 | 395860 | LOYALHANNA CARE CENTER | 535 MCFARLAND ROAD | LATROBE | PA | 15650 | 7245375500 | 770 | Westmoreland | For profit - Partnership | 120 | 100 | Medicare and Medicaid | false | LOYALHANNA HEALTHCARE ASSOCIATES | 09/23/1991 | true | SFF Candidate | true | false | false | Both | Yes | 1 | 1 | 1 | 1 | 1 | 1 | 12 | 1 | 12 | 6 | 6 | 09/19/2019 | 32 | 13 | 19 | 152 | 1 | 0 | 152 | 11/08/2018 | 24 | 10 | 14 | 148 | 1 | 0 | 148 | 2018-06-14 | 28 | 21 | 9 | 2 | 244 | 122 | 366 | 186.333 | 11 | 27 | 3 | 507007.00 | 2 | 5 | 535 MCFARLAND ROAD LATROBE, PA 15650 (40.327089, -79.394327) | 02/01/2020 | ||||||||||||||||||||
14002 | 14002 | 1201 CLARKS DR ABILENE, TX 79602 | 32.439629 | -99.704298 | 0 | 676416 | BRIGHTPOINTE AT LYTLE LAKE | 1201 CLARKS DR | ABILENE | TX | 79602 | 3256709293 | 911 | Taylor | For profit - Corporation | 120 | 84.2 | Medicare and Medicaid | false | MPD OPERATORS ABILENE LLC | 02/17/2017 | false | false | false | false | Resident | Yes | 1 | 1 | 1 | 1 | 1 | 1 | 12 | 1 | 12 | 6 | 6 | 09/25/2019 | 8 | 2 | 6 | 96 | 1 | 0 | 96 | 08/15/2018 | 6 | 4 | 2 | 52 | 1 | 0 | 52 | 2017-05-26 | 18 | 18 | 7 | 1 | 790 | 0 | 790 | 197 | 2 | 5 | 3 | 94171.00 | 0 | 3 | 1201 CLARKS DR ABILENE, TX 79602 (32.439629, -99.704298) | 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 );