nh_gen_info_geocoded_final
Data source: Big Local News · About: big-local-datasette
12 rows where Health Inspection Rating = 5 and Total Number of Penalties = 2
This data as json, copyable, CSV (advanced)
Suggested facets: prvdr_state, prvdr_cnty, prvdr_cnty_name, ownership, prvdr_type, Date First Approved to Provide Medicare and Medicaid services, Continuing Care Retirement Community, With a Resident and Family Council, QM Rating, Long-Stay QM Rating, Long-Stay QM Rating Footnote, Short-Stay QM Rating, Short-Stay QM Rating Footnote, 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 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 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 Total Health Score, Total Weighted Health Survey Score, Number of Facility Reported Incidents, Number of Substantiated Complaints, Number of Fines, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1039 | 1039 | 2201 BAY AVENUE OCEAN CITY, NJ 08226 | 39.267001 | -74.59872 | 0 | 315394 | UNITED METHODIST COMMUNITIES AT THE SHORES | 2201 BAY AVENUE | OCEAN CITY | NJ | 8226 | 6093998505 | 180 | Cape May | Non profit - Church related | 60 | 52.5 | Medicare and Medicaid | false | UNITED METHODIST HOMES OF NEW JERSEY | 02/16/1998 | false | false | false | false | Resident | Yes | 5 | 5 | 4 | 5 | 3 | 5 | 5 | 2.33671 | 0.32334 | 1.41857 | 1.74191 | 4.07861 | 0.12892 | 2.11334 | 0.67478 | 0.3042 | 3.09232 | 2.298 | 0.36031 | 1.75517 | 4.22942 | 11/27/2019 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 12/20/2018 | 3 | 3 | 0 | 12 | 1 | 0 | 12 | 2017-12-05 | 2 | 2 | 0 | 1 | 12 | 0 | 12 | 6 | 0 | 0 | 2 | 10400.00 | 0 | 2 | 2201 BAY AVENUE OCEAN CITY, NJ 08226 (39.267001, -74.59872) | 02/01/2020 | |||||||||||
4038 | 4038 | 1750 SOUTH 20TH STREET LINCOLN, NE 68502 | 40.794896 | -96.691948 | 0 | 285002 | SUMNER PLACE | 1750 SOUTH 20TH STREET | LINCOLN | NE | 68502 | 4024756791 | 540 | Lancaster | Non profit - Corporation | 104 | 91.9 | Medicare and Medicaid | false | VSL LINCOLN SUMNER LLC | 01/01/1967 | false | false | false | false | Resident | Yes | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 2.94266 | 0.71742 | 0.86078 | 1.57819 | 4.52085 | 0.00976 | 2.17828 | 0.66868 | 0.29159 | 3.13855 | 2.80765 | 0.80675 | 1.11108 | 4.61896 | 02/20/2019 | 2 | 2 | 0 | 8 | 1 | 0 | 8 | 11/14/2017 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2016-09-15 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 0 | 0 | 1 | 30215.00 | 1 | 2 | 1750 SOUTH 20TH STREET LINCOLN, NE 68502 (40.794896, -96.691948) | 02/01/2020 | |||||||||||
5161 | 5161 | 1600 W WALNUT STREET JACKSONVILLE, IL 62650 | 39.745268 | -90.259912 | 0 | 145951 | PASSAVANT AREA HOSPITAL | 1600 W WALNUT STREET | JACKSONVILLE | IL | 62650 | 2172459541 | 770 | Morgan | Non profit - Corporation | 15 | 15.2 | Medicare | false | PASSAVANT MEMORIAL AREA HOSPITAL ASSOCIATION | 10/31/1997 | false | false | false | false | None | Yes | 5 | 5 | 5 | 2 | 5 | 5 | 5 | 3.12842 | 0.72019 | 2.7403 | 3.46049 | 6.5889 | 0.38676 | 2.07173 | 0.92655 | 0.53347 | 3.53175 | 3.13839 | 0.58447 | 1.93341 | 5.98241 | 02/06/2019 | 2 | 2 | 0 | 4 | 1 | 0 | 4 | 03/14/2018 | 3 | 3 | 0 | 12 | 1 | 0 | 12 | 2017-01-27 | 4 | 4 | 0 | 1 | 16 | 0 | 16 | 8.667 | 0 | 0 | 1 | 6633.00 | 1 | 2 | 1600 W WALNUT STREET JACKSONVILLE, IL 62650 (39.745268, -90.259912) | 02/01/2020 | |||||||||||
6903 | 6903 | 710 N CHRISTIAN AVENUE MOUNDRIDGE, KS 67107 | 38.209918 | -97.519081 | 0 | 175553 | MOUNDRIDGE MANOR | 710 N CHRISTIAN AVENUE | MOUNDRIDGE | KS | 67107 | 6203456364 | 560 | Mcpherson | Non profit - Church related | 78 | 74 | Medicare and Medicaid | false | MOUNDRIDGE MANOR INC | 12/23/2015 | true | false | false | false | Resident | Yes | 5 | 5 | 5 | 5 | 2 | 4 | 4 | 3.5436 | 0.55437 | 0.59189 | 1.14626 | 4.68985 | 0.00993 | 1.78598 | 0.62596 | 0.27428 | 2.68622 | 4.12367 | 0.66594 | 0.81222 | 5.59849 | 06/20/2019 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 09/27/2018 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2017-03-06 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 23862.00 | 1 | 2 | 710 N CHRISTIAN AVENUE MOUNDRIDGE, KS 67107 (38.209918, -97.519081) | 02/01/2020 | |||||||||||
7742 | 7742 | 375 SOUTH MAIN STREET ROMEO, MI 48065 | 42.795797 | -83.013441 | 0 | 235704 | WELLBRIDGE OF ROMEO, LLC | 375 SOUTH MAIN STREET | ROMEO | MI | 48065 | 5865893800 | 490 | Macomb | For profit - Partnership | 124 | 111.8 | Medicare and Medicaid | false | WELLBRIDGE OF ROMEO LLC | 02/03/2015 | false | false | false | false | Resident | Yes | 5 | 5 | 4 | 4 | 5 | 5 | 5 | 2.33281 | 0.92202 | 1.01828 | 1.9403 | 4.27312 | 0.07432 | 2.12749 | 0.76505 | 0.34592 | 3.23846 | 2.27892 | 0.90622 | 1.10794 | 4.23116 | 10/23/2019 | 4 | 3 | 1 | 32 | 1 | 0 | 32 | 11/16/2018 | 3 | 2 | 1 | 20 | 1 | 0 | 20 | 2018-01-25 | 6 | 3 | 3 | 1 | 44 | 0 | 44 | 30 | 1 | 9 | 2 | 22454.00 | 0 | 2 | 375 SOUTH MAIN STREET ROMEO, MI 48065 (42.795797, -83.013441) | 02/01/2020 | |||||||||||
9166 | 9166 | 1630 43RD AVENUE EAST SEATTLE, WA 98112 | 47.634296 | -122.277143 | 0 | 505493 | PARK SHORE | 1630 43RD AVENUE EAST | SEATTLE | WA | 98112 | 2063290770 | 160 | King | Non profit - Corporation | 28 | 22.7 | Medicare and Medicaid | false | PRESBYTERIAN RETIREMENT COMMUNITIES NORTHWEST | 08/10/1995 | true | false | false | false | Resident | Yes | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 3.52265 | 0.54135 | 1.83707 | 2.37841 | 5.90106 | 0.13511 | 2.23816 | 0.7553 | 0.34916 | 3.34262 | 3.2711 | 0.53894 | 1.98031 | 5.66104 | 04/29/2019 | 7 | 4 | 3 | 44 | 1 | 0 | 44 | 03/30/2018 | 8 | 5 | 3 | 48 | 1 | 0 | 48 | 2016-12-15 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 38 | 0 | 1 | 2 | 30085.00 | 0 | 2 | 1630 43RD AVENUE EAST SEATTLE, WA 98112 (47.634296, -122.277143) | 02/01/2020 | |||||||||||
9239 | 9239 | 901 SHUMWAY RD OMAK, WA 98841 | 48.424024 | -119.507955 | 0 | 505303 | REGENCY OMAK | 901 SHUMWAY RD | OMAK | WA | 98841 | 5098467700 | 230 | Okanogan | For profit - Corporation | 56 | 48.3 | Medicare and Medicaid | false | REGENCY OMAK LLC | 03/28/1986 | false | false | false | false | Resident | Yes | 5 | 5 | 4 | 4 | 3 | 4 | 5 | 2.50715 | 0.28307 | 1.03493 | 1.318 | 3.82515 | 0.0804 | 2.1405 | 0.686 | 0.31886 | 3.14536 | 2.43434 | 0.31028 | 1.22164 | 3.8997 | 11/15/2019 | 13 | 13 | 0 | 52 | 1 | 0 | 52 | 01/10/2019 | 3 | 2 | 1 | 28 | 1 | 0 | 28 | 2018-02-16 | 3 | 2 | 1 | 1 | 16 | 0 | 16 | 38 | 2 | 0 | 2 | 30330.00 | 0 | 2 | 901 SHUMWAY RD OMAK, WA 98841 (48.424024, -119.507955) | 02/01/2020 | |||||||||||
10258 | 10258 | 7377 RIDGE RD PARMA, OH 44129 | 41.365321 | -81.734717 | 0 | 365084 | PLEASANTVIEW CARE CENTER | 7377 RIDGE RD | PARMA | OH | 44129 | 4408450200 | 170 | Cuyahoga | For profit - Corporation | 162 | 79.3 | Medicare and Medicaid | false | RIDGE-PLEASANT VALLEY, INC. | 10/05/1970 | false | false | false | false | Resident | Yes | 5 | 5 | 5 | 5 | 4 | 4 | 4 | 3.20791 | 1.18507 | 1.06375 | 2.24882 | 5.45673 | 0.05577 | 2.29808 | 0.8514 | 0.42334 | 3.57282 | 2.90116 | 1.04663 | 0.94577 | 4.8975 | 04/04/2019 | 1 | 1 | 0 | 4 | 1 | 0 | 4 | 03/16/2018 | 1 | 0 | 1 | 4 | 0 | 0 | 4 | 2017-01-26 | 4 | 1 | 3 | 1 | 32 | 0 | 32 | 8.667 | 0 | 4 | 1 | 7389.00 | 1 | 2 | 7377 RIDGE RD PARMA, OH 44129 (41.365321, -81.734717) | 02/01/2020 | |||||||||||
10308 | 10308 | 505 NORTH 40TH AVENUE YAKIMA, WA 98908 | 46.6057 | -120.561975 | 0 | 505085 | CRESCENT HEALTH CARE, INC | 505 NORTH 40TH AVENUE | YAKIMA | WA | 98908 | 5092484446 | 380 | Yakima | For profit - Individual | 85 | 69.3 | Medicare and Medicaid | false | CRESCENT HEALTH CARE, INC. | 01/01/1967 | false | false | false | false | Resident | Yes | 5 | 5 | 4 | 5 | 4 | 3 | 4 | 2.08141 | 0.52946 | 0.75773 | 1.28719 | 3.3686 | 0.03097 | 2.26984 | 0.7372 | 0.30386 | 3.3109 | 1.9058 | 0.54005 | 0.93857 | 3.26255 | 09/12/2019 | 5 | 4 | 1 | 28 | 1 | 0 | 28 | 07/13/2018 | 3 | 2 | 1 | 28 | 1 | 0 | 28 | 2017-09-15 | 11 | 5 | 7 | 1 | 68 | 0 | 68 | 34.667 | 3 | 7 | 2 | 13650.00 | 0 | 2 | 505 NORTH 40TH AVENUE YAKIMA, WA 98908 (46.6057, -120.561975) | 02/01/2020 | |||||||||||
11943 | 11943 | 2702 SOUTH ELY KENNEWICK, WA 99337 | 46.182937 | -119.159027 | 0 | 505372 | REGENCY CANYON LAKES REHAB AND NURSING CENTER | 2702 SOUTH ELY | KENNEWICK | WA | 99337 | 5095825900 | 20 | Benton | For profit - Limited Liability company | 53 | 47 | Medicare and Medicaid | false | MBB KENNEWICK LLC | 09/01/1990 | false | false | false | false | Both | Yes | 5 | 5 | 4 | 5 | 3 | 4 | 5 | 2.7291 | 0.38472 | 1.31002 | 1.69473 | 4.42383 | 0.42208 | 2.33006 | 0.86655 | 0.44527 | 3.64188 | 2.43427 | 0.33383 | 1.10734 | 3.89517 | 12/13/2019 | 2 | 0 | 2 | 40 | 1 | 0 | 40 | 10/26/2018 | 4 | 0 | 4 | 16 | 1 | 0 | 16 | 2017-11-20 | 5 | 3 | 2 | 1 | 24 | 0 | 24 | 29.333 | 4 | 5 | 2 | 32705.00 | 0 | 2 | 2702 SOUTH ELY KENNEWICK, WA 99337 (46.182937, -119.159027) | 02/01/2020 | |||||||||||
12436 | 12436 | 802 WEST THIRD AVENUE TOPPENISH, WA 98948 | 46.373235 | -120.323314 | 0 | 505096 | TOPPENISH NURSING & REHAB CENTER | 802 WEST THIRD AVENUE | TOPPENISH | WA | 98948 | 5098653955 | 380 | Yakima | For profit - Corporation | 75 | 61.2 | Medicare and Medicaid | false | CARE CENTER TOPPENISH INC. | 01/01/1968 | false | false | false | false | Resident | Yes | 5 | 5 | 5 | 5 | 4 | 3 | 3 | 2.32451 | 0.72992 | 0.59925 | 1.32917 | 3.65368 | 0.03298 | 2.15102 | 0.70539 | 0.30937 | 3.16579 | 2.24596 | 0.77809 | 0.72905 | 3.70086 | 07/18/2019 | 5 | 5 | 0 | 20 | 1 | 0 | 20 | 08/10/2018 | 9 | 6 | 3 | 52 | 1 | 0 | 52 | 2017-06-28 | 6 | 2 | 4 | 1 | 48 | 0 | 48 | 35.333 | 3 | 3 | 2 | 22110.00 | 0 | 2 | 802 WEST THIRD AVENUE TOPPENISH, WA 98948 (46.373235, -120.323314) | 02/01/2020 | |||||||||||
13916 | 13916 | 1224 EAST WESTVIEW COURT SPOKANE, WA 99218 | 47.745663 | -117.391113 | 0 | 505369 | REGENCY AT NORTHPOINTE | 1224 EAST WESTVIEW COURT | SPOKANE | WA | 99218 | 5094658800 | 310 | Spokane | For profit - Corporation | 120 | 97 | Medicare and Medicaid | false | BD SPOKANE I LLC | 08/01/1990 | false | false | false | false | Resident | Yes | 5 | 5 | 5 | 5 | 5 | 3 | 3 | 2.6844 | 0.52991 | 0.96412 | 1.49403 | 4.17843 | 0.13463 | 2.14698 | 0.84044 | 0.64201 | 3.62943 | 2.59857 | 0.47411 | 0.56522 | 3.69171 | 11/27/2019 | 3 | 0 | 3 | 12 | 0 | 0 | 12 | 01/11/2019 | 7 | 4 | 3 | 60 | 1 | 0 | 60 | 2017-10-12 | 9 | 8 | 1 | 1 | 48 | 0 | 48 | 34 | 1 | 4 | 2 | 13796.00 | 0 | 2 | 1224 EAST WESTVIEW COURT SPOKANE, WA 99218 (47.745663, -117.391113) | 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 );