nh_gen_info_geocoded_final
Data source: Big Local News · About: big-local-datasette
12 rows where "Rating Cycle 3 Standard Health Survey Date" is on date 2017-04-27 and Total Number of Penalties = 2
This data as json, copyable, CSV (advanced)
Suggested facets: prvdr_state, ownership, Continuing Care Retirement Community, Special Focus Status, 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, 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 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 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, 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 Fines, Number of Payment Denials
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
665 | 665 | 30 PARK LANE EAST NEW MILFORD, CT 06776 | 41.597485 | -73.401891 | 0 | 75416 | CANDLEWOOD VALLEY HEALTH & REHABILITATION CENTER | 30 PARK LANE EAST | NEW MILFORD | CT | 6776 | 8603550971 | 20 | Litchfield | For profit - Limited Liability company | 148 | 135.8 | Medicare and Medicaid | false | NEW MILFORD REHABILITATION LLC | 06/16/1998 | false | false | false | false | Both | Yes | 5 | 4 | 5 | 5 | 5 | 3 | 3 | 2.27929 | 0.96442 | 0.60543 | 1.56985 | 3.84915 | 0.08757 | 2.1414 | 0.70547 | 0.33673 | 3.18359 | 2.21217 | 1.02796 | 0.67673 | 3.87704 | 05/23/2019 | 3 | 3 | 0 | 12 | 1 | 0 | 12 | 04/09/2018 | 2 | 2 | 0 | 24 | 1 | 0 | 24 | 2017-04-27 | 11 | 8 | 9 | 1 | 64 | 0 | 64 | 24.667 | 2 | 3 | 2 | 10466.00 | 0 | 2 | 30 PARK LANE EAST NEW MILFORD, CT 06776 (41.597485, -73.401891) | 02/01/2020 | |||||||||||
1209 | 1209 | 991 PONDELLA RD FORT MYERS, FL 33903 | 26.667357 | -81.92076 | 0 | 105507 | CONSULATE HEALTH CARE OF NORTH FORT MYERS | 991 PONDELLA RD | FORT MYERS | FL | 33903 | 2399958809 | 350 | Lee | For profit - Corporation | 120 | 113.4 | Medicare and Medicaid | false | NORTH FORT MYERS FACILITY OPERATIONS LLC | 06/13/1985 | false | false | false | false | Resident | Yes | 2 | 1 | 4 | 5 | 2 | 4 | 4 | 2.50658 | 0.52107 | 0.73298 | 1.25405 | 3.76063 | 0.0527 | 1.94926 | 0.7116 | 0.35369 | 3.01455 | 2.67256 | 0.55061 | 0.78002 | 4.0003 | 05/16/2019 | 11 | 9 | 2 | 68 | 1 | 0 | 68 | 04/26/2018 | 8 | 6 | 2 | 68 | 1 | 0 | 68 | 2017-04-27 | 12 | 6 | 6 | 2 | 80 | 40 | 120 | 76.667 | 0 | 9 | 2 | 55916.00 | 0 | 2 | 991 PONDELLA RD FORT MYERS, FL 33903 (26.667357, -81.92076) | 02/01/2020 | |||||||||||
2601 | 2601 | 1221 EAST UNION STREET GREENVILLE, MS 38703 | 33.409939 | -91.032864 | 0 | 255252 | MS CARE CENTER OF GREENVILLE | 1221 EAST UNION STREET | GREENVILLE | MS | 38703 | 6623355811 | 750 | Washington | For profit - Corporation | 116 | 101.5 | Medicare and Medicaid | false | WASHINGTON COUNTY LTC, INC. | 11/01/1997 | false | SFF | false | false | false | Resident | Yes | 18 | 18 | 18 | 18 | 18 | 18 | 18 | 2.3143 | 0.91958 | 0.51236 | 1.43195 | 3.74625 | 0.03427 | 2.00535 | 0.6684 | 0.28992 | 2.96367 | 2.39853 | 1.03452 | 0.66518 | 4.0534 | 09/26/2019 | 9 | 5 | 4 | 72 | 1 | 0 | 72 | 08/27/2018 | 10 | 10 | 0 | 545 | 1 | 0 | 545 | 2017-04-27 | 9 | 7 | 2 | 1 | 40 | 0 | 40 | 224.333 | 0 | 7 | 1 | 31225.00 | 1 | 2 | 1221 EAST UNION STREET GREENVILLE, MS 38703 (33.409939, -91.032864) | 02/01/2020 | ||||||||||
2654 | 2654 | 3661 ROCHESTER AVENUE IOWA CITY, IA 52245 | 41.669486 | -91.479774 | 0 | 165198 | IOWA CITY REHAB & HEALTH CARE | 3661 ROCHESTER AVENUE | IOWA CITY | IA | 52245 | 3193517460 | 510 | Johnson | For profit - Corporation | 89 | 65.6 | Medicare and Medicaid | false | PREMIER ESTATES 506, LLC | 01/01/1994 | false | false | false | false | Resident | Yes | 1 | 1 | 2 | 1 | 5 | 2 | 3 | 1.653 | 0.427 | 0.57352 | 1.00052 | 2.65352 | 0.0769 | 1.77928 | 0.73498 | 0.37477 | 2.88903 | 1.93083 | 0.43685 | 0.57599 | 2.94526 | 10/10/2019 | 9 | 9 | 5 | 36 | 1 | 0 | 36 | 07/26/2018 | 21 | 15 | 6 | 299 | 1 | 0 | 299 | 2017-04-27 | 14 | 6 | 9 | 1 | 108 | 0 | 108 | 135.667 | 1 | 13 | 1 | 87439.00 | 1 | 2 | 3661 ROCHESTER AVENUE IOWA CITY, IA 52245 (41.669486, -91.479774) | 02/01/2020 | |||||||||||
5451 | 5451 | 1061 W HACKLEY AVE MUSKEGON, MI 49441 | 43.212683 | -86.26956 | 0 | 235004 | SKLD MUSKEGON | 1061 W HACKLEY AVE | MUSKEGON | MI | 49441 | 2317552255 | 600 | Muskegon | For profit - Corporation | 107 | 80.3 | Medicare and Medicaid | false | KNOLLVIEW SNF LLC | 01/01/1967 | false | false | false | false | Resident | Yes | 2 | 1 | 5 | 5 | 4 | 4 | 5 | 2.10456 | 0.55465 | 0.95365 | 1.5083 | 3.61287 | 0.01598 | 2.09508 | 0.71673 | 0.31794 | 3.12976 | 2.08774 | 0.58189 | 1.12895 | 3.70164 | 05/03/2019 | 21 | 20 | 2 | 156 | 2 | 78 | 234 | 06/21/2018 | 22 | 21 | 1 | 136 | 1 | 0 | 136 | 2017-04-27 | 18 | 14 | 8 | 1 | 203 | 0 | 203 | 196.167 | 16 | 18 | 1 | 353140.00 | 1 | 2 | 1061 W HACKLEY AVE MUSKEGON, MI 49441 (43.212683, -86.26956) | 02/01/2020 | |||||||||||
6294 | 6294 | 2480 S CLERMONT ST DENVER, CO 80222 | 39.670949 | -104.935326 | 0 | 65344 | SUITES AT CLERMONT PARK CARE CENTER | 2480 S CLERMONT ST | DENVER | CO | 80222 | 7209743901 | 150 | Denver | Non profit - Corporation | 63 | 61.7 | Medicare and Medicaid | false | CHRISTIAN LIVING COMMUNITIES | 03/01/1996 | true | false | false | false | Resident | Yes | 2 | 2 | 5 | 5 | 5 | 1 | 12 | 1 | 12 | 6 | 6 | 11/12/2019 | 6 | 6 | 0 | 24 | 1 | 0 | 24 | 11/01/2018 | 5 | 5 | 0 | 36 | 1 | 0 | 36 | 2017-04-27 | 3 | 3 | 0 | 1 | 149 | 0 | 149 | 48.833 | 0 | 0 | 2 | 50523.00 | 0 | 2 | 2480 S CLERMONT ST DENVER, CO 80222 (39.670949, -104.935326) | 02/01/2020 | |||||||||||||||||||||
6413 | 6413 | 112 DOVER DRIVE GEORGETOWN, KY 40324 | 38.215451 | -84.529762 | 0 | 185295 | HARBORVIEW DOVER, LLC | 112 DOVER DRIVE | GEORGETOWN | KY | 40324 | 5028639529 | 977 | Scott | For profit - Corporation | 85 | 78.5 | Medicare and Medicaid | false | Legal Business Name Not Available | 07/14/1991 | false | false | false | false | Resident | Yes | 3 | 3 | 1 | 1 | 1 | 4 | 3 | 2.94771 | 1.49599 | 0.47512 | 1.97111 | 4.91882 | 0 | 2.20485 | 0.73016 | 0.33944 | 3.27446 | 2.77857 | 1.54061 | 0.52683 | 4.81698 | 07/03/2019 | 2 | 0 | 2 | 12 | 0 | 0 | 12 | 05/31/2018 | 6 | 6 | 0 | 56 | 1 | 0 | 56 | 2017-04-27 | 7 | 7 | 0 | 1 | 48 | 0 | 48 | 32.667 | 0 | 0 | 1 | 6500.00 | 1 | 2 | 112 DOVER DRIVE GEORGETOWN, KY 40324 (38.215451, -84.529762) | 02/01/2020 | |||||||||||
6638 | 6638 | 6840 WEST TOUHY AVENUE NILES, IL 60714 | 42.012453 | -87.797062 | 0 | 145630 | AVANTI WELLNESS & REHAB | 6840 WEST TOUHY AVENUE | NILES | IL | 60714 | 8476476400 | 141 | Cook | For profit - Corporation | 212 | 135.7 | Medicare and Medicaid | false | FOREST VILLA NURSING AND REHABILITATION CENTER, LLC | 08/01/1989 | false | false | false | false | Both | Yes | 2 | 2 | 4 | 4 | 3 | 2 | 3 | 1.63692 | 0.73077 | 0.73087 | 1.46164 | 3.09856 | 0.14643 | 2.36747 | 0.84382 | 0.4289 | 3.64019 | 1.43701 | 0.6512 | 0.64138 | 2.72954 | 04/18/2019 | 12 | 8 | 4 | 72 | 1 | 0 | 72 | 03/16/2018 | 17 | 7 | 10 | 116 | 1 | 0 | 116 | 2017-04-27 | 18 | 8 | 10 | 1 | 108 | 0 | 108 | 92.667 | 0 | 21 | 2 | 13097.00 | 0 | 2 | 6840 WEST TOUHY AVENUE NILES, IL 60714 (42.012453, -87.797062) | 02/01/2020 | |||||||||||
7202 | 7202 | 307 FOSTER STREET RAYVILLE, LA 71269 | 32.46958 | -91.750856 | 0 | 195394 | COLONIAL MANOR NURSING & REHABILITATION HOME | 307 FOSTER STREET | RAYVILLE | LA | 71269 | 3187283252 | 410 | Richland | For profit - Partnership | 105 | 63 | Medicare and Medicaid | false | COLONIAL MANOR NURSING AND REHABILITATION HOME INC | 01/01/1997 | false | false | false | false | Resident | Yes | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1.72695 | 1.30578 | 0.22794 | 1.53372 | 3.26066 | 0 | 1.96829 | 0.72883 | 0.34646 | 3.04359 | 1.8235 | 1.34717 | 0.24763 | 3.43537 | 03/21/2019 | 10 | 10 | 0 | 72 | 1 | 0 | 72 | 03/02/2018 | 17 | 13 | 4 | 132 | 1 | 0 | 132 | 2017-04-27 | 8 | 7 | 1 | 1 | 64 | 0 | 64 | 90.667 | 0 | 4 | 2 | 16643.00 | 0 | 2 | 307 FOSTER STREET RAYVILLE, LA 71269 (32.46958, -91.750856) | 02/01/2020 | |||||||||||
9090 | 9090 | 1505 SOUTHEAST CARPENTER ROAD LACEY, WA 98503 | 47.032835 | -122.791466 | 0 | 505254 | ROO-LAN HEALTHCARE CENTER | 1505 SOUTHEAST CARPENTER ROAD | LACEY | WA | 98503 | 3604911765 | 330 | Thurston | For profit - Corporation | 96 | 78.3 | Medicare and Medicaid | false | LACEY NURSING CENTER, INC. | 04/01/1980 | true | false | false | false | Resident | Yes | 4 | 4 | 4 | 3 | 5 | 3 | 3 | 2.34371 | 0.87257 | 0.44201 | 1.31458 | 3.65829 | 0.0079 | 2.22748 | 0.67212 | 0.2879 | 3.1875 | 2.18678 | 0.9762 | 0.57786 | 3.68028 | 02/13/2019 | 17 | 16 | 1 | 100 | 1 | 0 | 100 | 03/23/2018 | 6 | 6 | 1 | 36 | 1 | 0 | 36 | 2017-04-27 | 8 | 5 | 3 | 1 | 56 | 0 | 56 | 71.333 | 2 | 2 | 2 | 8937.00 | 0 | 2 | 1505 SOUTHEAST CARPENTER ROAD LACEY, WA 98503 (47.032835, -122.791466) | 02/01/2020 | |||||||||||
13268 | 13268 | 4718 HALLMARK DR HOUSTON, TX 77056 | 29.750299 | -95.458765 | 0 | 676423 | THE HALLMARK | 4718 HALLMARK DR | HOUSTON | TX | 77056 | 7136226633 | 610 | Harris | Non profit - Corporation | 32 | 22.3 | Medicare and Medicaid | false | BRAZOS PRESBYTERIAN HOMES INC | 05/26/2017 | false | false | false | false | Resident | Yes | 2 | 2 | 3 | 4 | 2 | 2 | 2 | 6 | 6 | 02/15/2019 | 9 | 9 | 8 | 76 | 2 | 38 | 114 | 02/08/2018 | 5 | 5 | 0 | 32 | 1 | 0 | 32 | 2017-04-27 | 5 | 5 | 0 | 1 | 56 | 0 | 56 | 77 | 0 | 0 | 1 | 24830.00 | 1 | 2 | 4718 HALLMARK DR HOUSTON, TX 77056 (29.750299, -95.458765) | 02/01/2020 | |||||||||||||||||||||||
14940 | 14940 | 11020 DESSAU RD AUSTIN, TX 78754 | 30.36935 | -97.667987 | 0 | 676238 | LEGEND OAKS HEALTHCARE AND REHABILITATION - NORTH | 11020 DESSAU RD | AUSTIN | TX | 78754 | 5128732244 | 940 | Travis | Government - Hospital district | 124 | 93.3 | Medicare and Medicaid | false | GUADALUPE COUNTY HOSPITAL BOARD | 10/20/2009 | false | false | false | false | Resident | Yes | 3 | 3 | 5 | 5 | 5 | 1 | 1 | 2.05467 | 0.81898 | 0.31168 | 1.13066 | 3.18533 | 0.11212 | 2.22713 | 0.89039 | 0.48371 | 3.60124 | 1.91739 | 0.69164 | 0.24252 | 2.83632 | 04/25/2019 | 5 | 5 | 0 | 40 | 1 | 0 | 40 | 03/07/2018 | 9 | 8 | 1 | 60 | 1 | 0 | 60 | 2017-04-27 | 8 | 2 | 7 | 1 | 132 | 0 | 132 | 62 | 2 | 3 | 1 | 135616.00 | 1 | 2 | 11020 DESSAU RD AUSTIN, TX 78754 (30.36935, -97.667987) | 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 );