nh_gen_info_geocoded_final
Data source: Big Local News · About: big-local-datasette
13 rows where Number of Fines = 1 and ownership = "Government - City/county"
This data as json, copyable, CSV (advanced)
Suggested facets: geocode_flag, prvdr_state, prvdr_cnty, nmbr_beds, Provider Resides in Hospital, Overall Rating, Health Inspection Rating, Long-Stay QM Rating, Short-Stay QM Rating Footnote, Staffing Rating, RN Staffing Rating, 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 1 Health Revisit Score, Rating Cycle 2 Standard Health Survey Date, Rating Cycle 2 Total Number of Health Deficiencies, Rating Cycle 2 Number of Complaint Health Deficiencies, Rating Cycle 2 Health Deficiency Score, Rating Cycle 2 Health Revisit 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 Health Deficiency Score, Rating Cycle 3 Health Revisit Score, Number of Facility Reported Incidents, Total Amount of Fines in Dollars, Total Number of Penalties, Location, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
242 | 242 | 729 W 35TH ST MARION, IN 46953 | 40.527779 | -85.669531 | 0 | 155455 | WESLEYAN HEALTH CARE CENTER | 729 W 35TH ST | MARION | IN | 46953 | 7656743371 | 260 | Grant | Government - City/county | 169 | 129.1 | Medicare and Medicaid | false | RIVERVIEW HOSPITAL | 06/01/1992 | false | false | false | false | Resident | Yes | 2 | 1 | 5 | 5 | 5 | 2 | 2 | 1.99103 | 0.80798 | 0.40572 | 1.2137 | 3.20473 | 0.0849 | 2.05859 | 0.79057 | 0.37826 | 3.22743 | 2.01013 | 0.7685 | 0.4037 | 3.18411 | 06/18/2019 | 14 | 11 | 3 | 135 | 1 | 0 | 135 | 07/26/2018 | 9 | 6 | 3 | 40 | 1 | 0 | 40 | 2017-08-07 | 11 | 10 | 1 | 1 | 48 | 0 | 48 | 88.833 | 5 | 6 | 1 | 8297.00 | 0 | 1 | 729 W 35TH ST MARION, IN 46953 (40.527779, -85.669531) | 02/01/2020 | |||||||||||
1059 | 1059 | 723 E RAMSEY RD VINCENNES, IN 47591 | 38.646535 | -87.526323 | 0 | 155632 | LODGE OF THE WABASH | 723 E RAMSEY RD | VINCENNES | IN | 47591 | 8128828787 | 410 | Knox | Government - City/county | 70 | 52.2 | Medicare and Medicaid | false | RUSH MEMORIAL HOSPITAL | 08/01/1997 | false | false | false | false | Resident | Yes | 2 | 2 | 3 | 4 | 1 | 3 | 3 | 1.89628 | 0.95027 | 0.57242 | 1.52269 | 3.41897 | 0.01165 | 1.95109 | 0.75939 | 0.37346 | 3.08394 | 2.01995 | 0.94095 | 0.5769 | 3.55502 | 07/24/2019 | 9 | 5 | 4 | 36 | 1 | 0 | 36 | 06/21/2018 | 12 | 12 | 0 | 52 | 1 | 0 | 52 | 2017-05-09 | 18 | 14 | 4 | 2 | 96 | 48 | 144 | 59.333 | 0 | 8 | 1 | 8125.00 | 0 | 1 | 723 E RAMSEY RD VINCENNES, IN 47591 (38.646535, -87.526323) | 02/01/2020 | |||||||||||
1199 | 1199 | E Creek Rd, Nantucket, MA 02554, USA | 41.274316 | -70.090683 | 1 | GEOMETRIC_CENTER | 225772 | OUR ISLAND HOME | EAST CREEK ROAD | NANTUCKET | MA | 2554 | 5082280462 | 120 | Nantucket | Government - City/county | 45 | 39.4 | Medicare and Medicaid | false | TOWN OF NANTUCKET | 08/01/2007 | false | false | false | false | Both | Yes | 3 | 3 | 1 | 3 | 1 | 4 | 4 | 2.46416 | 0.79923 | 0.79774 | 1.59696 | 4.06112 | 0.03251 | 1.96195 | 0.66605 | 0.29099 | 2.91899 | 2.61034 | 0.90229 | 1.03183 | 4.46135 | 02/27/2019 | 5 | 5 | 0 | 20 | 1 | 0 | 20 | 11/09/2017 | 5 | 5 | 0 | 40 | 1 | 0 | 40 | 2016-09-27 | 6 | 6 | 0 | 1 | 36 | 0 | 36 | 29.333 | 0 | 0 | 1 | 8778.00 | 0 | 1 | 02/01/2020 | |||||||||||
2064 | 2064 | 1401 SOUTH 16TH STREET MURRAY, KY 42071 | 36.589473 | -88.324385 | 0 | 185005 | SPRING CREEK HEALTH CARE | 1401 SOUTH 16TH STREET | MURRAY | KY | 42071 | 2707522900 | 170 | Calloway | Government - City/county | 226 | 127 | Medicare and Medicaid | true | MURRAY CALLOWAY COUNTY PUBLIC HOSPITAL CORPORATION | 01/01/1967 | false | false | false | false | Both | Yes | 2 | 2 | 2 | 2 | 2 | 3 | 3 | 1.91874 | 1.30723 | 0.60855 | 1.91578 | 3.83451 | 0.0679 | 2.32961 | 0.78887 | 0.36815 | 3.48663 | 1.71178 | 1.24603 | 0.62216 | 3.52661 | 02/07/2019 | 8 | 5 | 3 | 48 | 1 | 0 | 48 | 01/26/2018 | 7 | 5 | 2 | 153 | 1 | 0 | 153 | 2017-01-20 | 8 | 3 | 5 | 1 | 36 | 0 | 36 | 81 | 0 | 6 | 1 | 64231.00 | 0 | 1 | 1401 SOUTH 16TH STREET MURRAY, KY 42071 (36.589473, -88.324385) | 02/01/2020 | |||||||||||
2081 | 2081 | 1500 BROAD AVENUE GULFPORT, MS 39501 | 30.369971 | -89.119459 | 0 | 255290 | DRIFTWOOD NURSING CENTER | 1500 BROAD AVENUE | GULFPORT | MS | 39501 | 2288681314 | 230 | Harrison | Government - City/county | 151 | 118.1 | Medicare and Medicaid | false | MEMORIAL HOSPITAL AT GULFPORT | 09/01/2002 | false | false | false | false | Resident | Yes | 2 | 3 | 1 | 2 | 1 | 2 | 2 | 2.27373 | 1.09481 | 0.44103 | 1.53584 | 3.80957 | 0.04166 | 2.00314 | 0.72219 | 0.34011 | 3.06545 | 2.35909 | 1.13991 | 0.48806 | 3.98507 | 11/21/2019 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 01/16/2019 | 6 | 6 | 0 | 36 | 2 | 18 | 54 | 2017-09-22 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 18 | 0 | 0 | 1 | 16994.00 | 0 | 1 | 1500 BROAD AVENUE GULFPORT, MS 39501 (30.369971, -89.119459) | 02/01/2020 | |||||||||||
2358 | 2358 | 1920 ROSEMONT AVENUE FREDERICK, MD 21702 | 39.435222 | -77.436234 | 0 | 215105 | CITIZENS CARE AND REHABILITATION CENTER OF FREDERI | 1920 ROSEMONT AVENUE | FREDERICK | MD | 21702 | 2407729200 | 100 | Frederick | Government - City/county | 170 | 158.9 | Medicare and Medicaid | false | FREDERICK COUNTY MARYLAND | 12/01/1976 | false | false | false | false | Resident | Yes | 2 | 1 | 5 | 3 | 5 | 3 | 3 | 2.36513 | 1.00723 | 0.75843 | 1.76567 | 4.1308 | 0.09033 | 2.22903 | 0.85464 | 0.55157 | 3.63523 | 2.20524 | 0.8862 | 0.51754 | 3.6438 | 06/18/2019 | 18 | 15 | 10 | 104 | 2 | 52 | 156 | 01/12/2018 | 17 | 16 | 1 | 76 | 1 | 0 | 76 | 2016-10-14 | 7 | 7 | 0 | 1 | 32 | 0 | 32 | 108.667 | 6 | 1 | 1 | 9692.00 | 0 | 1 | 1920 ROSEMONT AVENUE FREDERICK, MD 21702 (39.435222, -77.436234) | 02/01/2020 | |||||||||||
2946 | 2946 | PO Box 728, Browning, MT 59417, USA | 48.5606889 | -113.0144936 | 1 | GEOMETRIC_CENTER | 275133 | BLACKFEET CARE CENTER | 728 S GOVERNMENT SQ | BROWNING | MT | 59417 | 4063382686 | 170 | Glacier | Government - City/county | 47 | 22.2 | Medicare and Medicaid | false | BLACKFEET TRIBE | 07/20/1989 | false | true | false | false | Resident | Yes | 4 | 2 | 5 | 5 | 2 | 5 | 5 | 2.99829 | 0.62183 | 0.82726 | 1.44909 | 4.44738 | 0.04004 | 1.91226 | 0.63574 | 0.27834 | 2.82634 | 3.25869 | 0.73549 | 1.11865 | 5.04583 | 10/31/2019 | 10 | 6 | 5 | 116 | 0 | 0 | 116 | 10/04/2018 | 5 | 5 | 0 | 20 | 1 | 0 | 20 | 2017-07-13 | 19 | 19 | 0 | 1 | 112 | 0 | 112 | 83.333 | 1 | 3 | 1 | 22032.00 | 0 | 1 | 02/01/2020 | |||||||||||
6001 | 6001 | 7150 MANOR ROAD COLUMBUS, GA 31906 | 32.49348 | -84.867984 | 0 | 115351 | MUSCOGEE MANOR & REHABILITATION CTR | 7150 MANOR ROAD | COLUMBUS | GA | 31906 | 7065613218 | 780 | Muscogee | Government - City/county | 170 | 114.7 | Medicare and Medicaid | false | HOSPITAL AUTHORITY OF COLUMBUS GA | 02/01/1989 | false | false | false | false | Both | Yes | 1 | 1 | 2 | 3 | 2 | 3 | 2 | 2.38647 | 1.24801 | 0.37811 | 1.62612 | 4.01259 | 0.03019 | 2.15831 | 0.71435 | 0.31177 | 3.18443 | 2.29804 | 1.31368 | 0.45647 | 4.0406 | 08/23/2018 | 9 | 7 | 2 | 68 | 1 | 0 | 68 | 08/17/2017 | 2 | 2 | 0 | 8 | 1 | 0 | 8 | 2016-05-26 | 6 | 4 | 2 | 1 | 28 | 0 | 28 | 41.333 | 0 | 2 | 1 | 8099.00 | 0 | 1 | 7150 MANOR ROAD COLUMBUS, GA 31906 (32.49348, -84.867984) | 02/01/2020 | |||||||||||
6957 | 6957 | 1236 LINCOLN AVE EVANSVILLE, IN 47714 | 37.969996 | -87.541783 | 0 | 155820 | UNIVERSITY NURSING AND REHABILITATION CENTER | 1236 LINCOLN AVE | EVANSVILLE | IN | 47714 | 8124643607 | 810 | Vanderburgh | Government - City/county | 47 | 45.3 | Medicare and Medicaid | false | DAVIESS COUNTY HOSPITAL | 05/28/2014 | false | false | false | false | Resident | Yes | 1 | 1 | 2 | 3 | 2 | 3 | 3 | 2.18187 | 0.88971 | 0.5943 | 1.48401 | 3.66589 | 0.10152 | 1.91227 | 0.79474 | 0.40521 | 3.11222 | 2.37135 | 0.8418 | 0.55203 | 3.77713 | 09/16/2019 | 18 | 17 | 8 | 104 | 1 | 0 | 104 | 07/26/2018 | 16 | 13 | 5 | 96 | 2 | 48 | 144 | 2017-06-15 | 15 | 12 | 3 | 2 | 92 | 46 | 138 | 123 | 0 | 9 | 1 | 8125.00 | 1 | 2 | 1236 LINCOLN AVE EVANSVILLE, IN 47714 (37.969996, -87.541783) | 02/01/2020 | |||||||||||
9871 | 9871 | 815 NORTH COUNTRY CLUB ROAD ADA, OK 74820 | 34.783195 | -96.652413 | 0 | 375243 | JAN FRANCES CARE CENTER | 815 NORTH COUNTRY CLUB ROAD | ADA | OK | 74820 | 5803325328 | 610 | Pontotoc | Government - City/county | 132 | 47.5 | Medicare and Medicaid | false | CITY OF HUGO | 09/25/1995 | false | false | false | false | Resident | Yes | 2 | 4 | 1 | 1 | 1 | 1 | 1 | 1.58816 | 1.17428 | 0.1722 | 1.34648 | 2.93464 | 0.02886 | 2.05312 | 0.68979 | 0.33305 | 3.07597 | 1.60767 | 1.28008 | 0.19461 | 3.05933 | 12/04/2019 | 2 | 2 | 0 | 16 | 0 | 0 | 16 | 11/07/2018 | 3 | 3 | 0 | 24 | 1 | 0 | 24 | 2017-12-05 | 6 | 6 | 0 | 1 | 52 | 0 | 52 | 24.667 | 0 | 0 | 1 | 6500.00 | 0 | 1 | 815 NORTH COUNTRY CLUB ROAD ADA, OK 74820 (34.783195, -96.652413) | 02/01/2020 | |||||||||||
11015 | 11015 | 594 ALBANY AVENUE BROOKLYN, NY 11203 | 40.659714 | -73.939693 | 0 | 335805 | DR SUSAN SMITH MCKINNEY NURSING AND REHAB CENTER | 594 ALBANY AVENUE | BROOKLYN | NY | 11203 | 7182457000 | 331 | Kings | Government - City/county | 320 | 313.8 | Medicare and Medicaid | false | NEW YORK CITY HEALTH AND HOSPITALS CORPORATION | 12/08/1997 | false | true | false | false | Both | Yes | 1 | 1 | 4 | 5 | 3 | 3 | 3 | 2.30257 | 0.57064 | 0.60272 | 1.17336 | 3.47593 | 0.05753 | 2.12074 | 0.72686 | 0.33537 | 3.18297 | 2.25654 | 0.59033 | 0.67642 | 3.5018 | 02/11/2019 | 9 | 9 | 0 | 84 | 1 | 0 | 84 | 04/06/2017 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2016-02-22 | 5 | 5 | 0 | 1 | 20 | 0 | 20 | 45.333 | 0 | 0 | 1 | 52390.00 | 0 | 1 | 594 ALBANY AVENUE BROOKLYN, NY 11203 (40.659714, -73.939693) | 02/01/2020 | |||||||||||
12742 | 12742 | 2200 EAST 3300 SOUTH SALT LAKE CITY, UT 84109 | 40.699837 | -111.827709 | 0 | 465006 | MT OLYMPUS REHABILITATION CENTER | 2200 EAST 3300 SOUTH | SALT LAKE CITY | UT | 84109 | 8014862096 | 170 | Salt Lake | Government - City/county | 107 | 83.9 | Medicare and Medicaid | false | BEAVER VALLEY HOSPITAL | 10/01/1977 | false | false | false | false | Resident | Yes | 2 | 2 | 4 | 4 | 5 | 3 | 3 | 2.16963 | 0.59149 | 0.79034 | 1.38183 | 3.55145 | 0.0801 | 2.07278 | 0.83418 | 0.41903 | 3.32599 | 2.17544 | 0.53317 | 0.70991 | 3.42403 | 05/23/2019 | 12 | 12 | 2 | 52 | 1 | 0 | 52 | 04/30/2018 | 15 | 15 | 8 | 108 | 1 | 0 | 108 | 2016-11-30 | 3 | 3 | 0 | 1 | 16 | 0 | 16 | 64.667 | 0 | 5 | 1 | 144651.00 | 0 | 1 | 2200 EAST 3300 SOUTH SALT LAKE CITY, UT 84109 (40.699837, -111.827709) | 02/01/2020 | |||||||||||
14542 | 14542 | 220 SCHOLL CT AMERY, WI 54001 | 45.302956 | -92.365762 | 0 | 525507 | GOLDEN AGE MANOR | 220 SCHOLL CT | AMERY | WI | 54001 | 7152687107 | 470 | Polk | Government - City/county | 109 | 78.2 | Medicare and Medicaid | false | POLK COUNTY-DEPT OF ADMINISTRATION | 05/01/1993 | false | false | false | false | Both | Yes | 3 | 2 | 4 | 2 | 5 | 4 | 4 | 2.28592 | 0.46672 | 0.80229 | 1.269 | 3.55493 | 0.01223 | 1.94725 | 0.64085 | 0.28815 | 2.87625 | 2.43981 | 0.54763 | 1.04795 | 3.9633 | 12/13/2018 | 6 | 6 | 0 | 32 | 1 | 0 | 32 | 10/05/2017 | 8 | 8 | 0 | 52 | 1 | 0 | 52 | 2016-10-27 | 17 | 17 | 0 | 1 | 92 | 0 | 92 | 48.667 | 0 | 0 | 1 | 20352.00 | 0 | 1 | 220 SCHOLL CT AMERY, WI 54001 (45.302956, -92.365762) | 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 );