nh_gen_info_geocoded_final
Data source: Big Local News · About: big-local-datasette
31 rows where Overall Rating = 4 and "Rating Cycle 3 Standard Health Survey Date" is on date 2017-08-03
This data as json, copyable, CSV (advanced)
Suggested facets: geocode_flag, geocode_accuracy, prvdr_state, prvdr_cnty, ownership, nmbr_beds, Date First Approved to Provide Medicare and Medicaid services, Continuing Care Retirement Community, Abuse Icon, Provider Changed Ownership in Last 12 Months, With a Resident and Family Council, Health Inspection Rating, QM Rating, Long-Stay QM Rating, 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 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 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, 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, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
244 | 244 | 105 COUNTRY CLUB ROAD POCAHONTAS, AR 72455 | 36.288874 | -90.995932 | 0 | 45284 | POCAHONTAS HEALTHCARE AND REHABILITATION CENTER | 105 COUNTRY CLUB ROAD | POCAHONTAS | AR | 72455 | 8708922523 | 600 | Randolph | For profit - Corporation | 97 | 58.2 | Medicare and Medicaid | false | Legal Business Name Not Available | 07/01/1995 | false | false | false | false | Resident | Yes | 4 | 4 | 3 | 3 | 3 | 2 | 2 | 2.36071 | 0.93303 | 0.39175 | 1.32478 | 3.68549 | 0.04813 | 2.13598 | 0.69307 | 0.32162 | 3.15066 | 2.29701 | 1.01228 | 0.45846 | 3.75099 | 10/18/2019 | 9 | 8 | 1 | 68 | 1 | 0 | 68 | 10/04/2018 | 4 | 4 | 0 | 16 | 1 | 0 | 16 | 2017-08-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 39.333 | 0 | 2 | 0 | 0.00 | 0 | 0 | 105 COUNTRY CLUB ROAD POCAHONTAS, AR 72455 (36.288874, -90.995932) | 02/01/2020 | |||||||||||
324 | 324 | 314 MARION ROAD MIDDLEBOROUGH, MA 02346 | 41.82978 | -70.884259 | 0 | 225622 | NEMASKET HEALTHCARE CENTER | 314 MARION ROAD | MIDDLEBOROUGH | MA | 2346 | 5089478632 | 150 | Plymouth | For profit - Corporation | 102 | 90.6 | Medicare and Medicaid | false | MBO CORPORATION | 03/01/1994 | false | false | false | false | Resident | Yes | 4 | 4 | 4 | 5 | 3 | 2 | 2 | 2.31443 | 1.13657 | 0.41373 | 1.5503 | 3.86472 | 0.05197 | 2.19181 | 0.71633 | 0.31226 | 3.22039 | 2.19461 | 1.19308 | 0.49869 | 3.84825 | 09/25/2019 | 7 | 6 | 1 | 28 | 1 | 0 | 28 | 12/11/2018 | 7 | 6 | 1 | 32 | 1 | 0 | 32 | 2017-08-03 | 2 | 2 | 0 | 1 | 8 | 0 | 8 | 26 | 0 | 1 | 0 | 0.00 | 0 | 0 | 314 MARION ROAD MIDDLEBOROUGH, MA 02346 (41.82978, -70.884259) | 02/01/2020 | |||||||||||
515 | 515 | 16 WINDSOR AVE PLAINFIELD, CT 06374 | 41.681773 | -71.918016 | 0 | 75310 | COLONIAL HEALTH & REHAB CENTER OF PLAINFIELD LLC | 16 WINDSOR AVE | PLAINFIELD | CT | 6374 | 8605644081 | 70 | Windham | For profit - Limited Liability company | 90 | 81.6 | Medicare and Medicaid | false | COLONIAL HEALTH & REHAB CENTER OF PLAINFIELD LLC | 10/01/1986 | false | false | false | false | Resident | Yes | 4 | 4 | 4 | 4 | 4 | 3 | 3 | 2.33123 | 0.83816 | 0.64941 | 1.48757 | 3.81881 | 0.0734 | 2.19106 | 0.73651 | 0.33963 | 3.26719 | 2.2113 | 0.85573 | 0.71969 | 3.74805 | 11/08/2019 | 6 | 6 | 0 | 16 | 0 | 0 | 16 | 09/24/2018 | 5 | 5 | 1 | 20 | 1 | 0 | 20 | 2017-08-03 | 3 | 3 | 1 | 1 | 12 | 0 | 12 | 16.667 | 1 | 1 | 0 | 0.00 | 0 | 0 | 16 WINDSOR AVE PLAINFIELD, CT 06374 (41.681773, -71.918016) | 02/01/2020 | |||||||||||
977 | 977 | 3107 NORTH H STREET PENSACOLA, FL 32501 | 30.443553 | -87.23173 | 0 | 105747 | ROSEWOOD HEALTHCARE AND REHABILITATION CENTER | 3107 NORTH H STREET | PENSACOLA | FL | 32501 | 8504300500 | 160 | Escambia | For profit - Corporation | 155 | 139.4 | Medicare and Medicaid | false | FL HUD ROSEWOOD, LLC | 04/01/1991 | false | false | false | false | Both | Yes | 4 | 4 | 4 | 5 | 4 | 4 | 4 | 2.55472 | 0.90483 | 0.58921 | 1.49404 | 4.04876 | 0.03726 | 1.99561 | 0.67812 | 0.29548 | 2.96922 | 2.66062 | 1.00332 | 0.75053 | 4.37253 | 06/27/2019 | 5 | 5 | 0 | 20 | 1 | 0 | 20 | 06/21/2018 | 4 | 4 | 0 | 16 | 1 | 0 | 16 | 2017-08-03 | 5 | 5 | 0 | 1 | 20 | 0 | 20 | 18.667 | 0 | 0 | 0 | 0.00 | 0 | 0 | 3107 NORTH H STREET PENSACOLA, FL 32501 (30.443553, -87.23173) | 02/01/2020 | |||||||||||
981 | 981 | 100 WURTLAND AVENUE WURTLAND, KY 41144 | 38.551076 | -82.786848 | 0 | 185261 | WURTLAND NURSING & REHABILITATION | 100 WURTLAND AVENUE | WURTLAND | KY | 41144 | 6068360931 | 440 | Greenup | For profit - Limited Liability company | 126 | 104.9 | Medicare and Medicaid | false | WURTLAND NURSING AND REHABILITATION LLC | 03/08/1991 | false | false | false | false | Resident | Yes | 4 | 4 | 2 | 3 | 1 | 2 | 2 | 2.00883 | 0.96846 | 0.37151 | 1.33997 | 3.3488 | 0.00548 | 2.18232 | 0.73354 | 0.35782 | 3.27367 | 1.91311 | 0.99276 | 0.39079 | 3.28025 | 10/24/2019 | 5 | 3 | 2 | 24 | 1 | 0 | 24 | 09/06/2018 | 3 | 1 | 2 | 12 | 1 | 0 | 12 | 2017-08-03 | 2 | 2 | 0 | 1 | 8 | 0 | 8 | 17.333 | 0 | 1 | 0 | 0.00 | 0 | 0 | 100 WURTLAND AVENUE WURTLAND, KY 41144 (38.551076, -82.786848) | 02/01/2020 | |||||||||||
1524 | 1524 | 3000 IVY DRIVE NORTH NEWTON, KS 67117 | 38.078146 | -97.348483 | 0 | 175402 | BETHEL HEALTH CARE CENTER | 3000 IVY DRIVE | NORTH NEWTON | KS | 67117 | 3162842900 | 390 | Harvey | Non profit - Corporation | 60 | 58.8 | Medicare and Medicaid | false | KIDRON BETHEL RETIREMENT SERVICES, INC. | 01/01/1997 | true | false | false | false | Resident | Yes | 4 | 3 | 4 | 5 | 4 | 4 | 4 | 2.99812 | 0.61178 | 0.8474 | 1.45918 | 4.4573 | 0.07872 | 1.79727 | 0.66934 | 0.30567 | 2.77228 | 3.46698 | 0.68728 | 1.04342 | 5.15569 | 09/09/2019 | 6 | 6 | 0 | 24 | 1 | 0 | 24 | 11/08/2018 | 1 | 0 | 1 | 75 | 0 | 0 | 75 | 2017-08-03 | 6 | 6 | 1 | 1 | 52 | 0 | 52 | 45.667 | 2 | 0 | 2 | 13650.00 | 1 | 3 | 3000 IVY DRIVE NORTH NEWTON, KS 67117 (38.078146, -97.348483) | 02/01/2020 | |||||||||||
1653 | 1653 | 3310 W COMMERCE RD MILFORD, MI 48380 | 42.599625 | -83.661102 | 0 | 235262 | WEST HICKORY HAVEN | 3310 W COMMERCE RD | MILFORD | MI | 48380 | 2486851400 | 620 | Oakland | For profit - Corporation | 101 | 87.5 | Medicare and Medicaid | false | ARDAN, INC. | 01/01/1976 | false | true | false | false | Resident | Yes | 4 | 2 | 5 | 5 | 4 | 4 | 4 | 2.79641 | 0.30681 | 0.78645 | 1.09326 | 3.88967 | 0.02949 | 2.09338 | 0.66538 | 0.31271 | 3.07147 | 2.77631 | 0.34673 | 0.9466 | 4.06088 | 01/08/2020 | 8 | 5 | 3 | 56 | 0 | 0 | 56 | 10/17/2018 | 5 | 2 | 3 | 28 | 1 | 0 | 28 | 2017-08-03 | 9 | 9 | 0 | 1 | 56 | 0 | 56 | 46.667 | 15 | 4 | 1 | 23690.00 | 0 | 1 | 3310 W COMMERCE RD MILFORD, MI 48380 (42.599625, -83.661102) | 02/01/2020 | |||||||||||
1701 | 1701 | 310 MOSHER DRIVE PROPHETSTOWN, IL 61277 | 41.678111 | -89.939348 | 0 | 145920 | ALLURE OF PROPHETSTOWN | 310 MOSHER DRIVE | PROPHETSTOWN | IL | 61277 | 8155375175 | 988 | Whiteside | For profit - Corporation | 70 | 41.6 | Medicare and Medicaid | false | ALLURE OF PROPHETSTOWN, LLC | 03/01/1997 | false | false | false | true | Resident | Yes | 4 | 4 | 2 | 1 | 4 | 3 | 4 | 1.71947 | 0.56292 | 0.63918 | 1.2021 | 2.92158 | 0.01774 | 1.85 | 0.66648 | 0.31231 | 2.82879 | 1.93169 | 0.63511 | 0.77031 | 3.31184 | 07/25/2019 | 7 | 5 | 2 | 40 | 1 | 0 | 40 | 09/06/2018 | 2 | 1 | 1 | 20 | 1 | 0 | 20 | 2017-08-03 | 3 | 2 | 1 | 1 | 12 | 0 | 12 | 28.667 | 5 | 2 | 0 | 0.00 | 0 | 0 | 310 MOSHER DRIVE PROPHETSTOWN, IL 61277 (41.678111, -89.939348) | 02/01/2020 | |||||||||||
2357 | 2357 | 6615 Poplar Springs Dr, Meridian, MS 39305, USA | 32.4316454 | -88.69692979999999 | 1 | RANGE_INTERPOLATED | 255315 | POPLAR SPRINGS NURSING CTR, LLC | 6615 P0PLAR SPRINGS DR | MERIDIAN | MS | 39305 | 6014835256 | 370 | Lauderdale | For profit - Corporation | 91 | 88.6 | Medicare and Medicaid | false | POPLAR SPRINGS NURSING CENTER LLC | 08/10/2005 | false | false | false | false | Resident | Yes | 4 | 4 | 3 | 5 | 2 | 3 | 2 | 2.51651 | 0.92595 | 0.42768 | 1.35362 | 3.87013 | 0.01003 | 2.00218 | 0.69014 | 0.32299 | 3.01531 | 2.61223 | 1.00887 | 0.49837 | 4.11573 | 12/05/2019 | 5 | 5 | 0 | 20 | 1 | 0 | 20 | 11/29/2018 | 1 | 1 | 0 | 4 | 1 | 0 | 4 | 2017-08-03 | 2 | 2 | 0 | 1 | 8 | 0 | 8 | 12.667 | 0 | 0 | 0 | 0.00 | 0 | 0 | 02/01/2020 | |||||||||||
2424 | 2424 | 1105 3RD AVENUE SOUTHWEST SLEEPY EYE, MN 56085 | 44.287939 | -94.725699 | 0 | 245225 | SLEEPY EYE CARE CENTER | 1105 3RD AVENUE SOUTHWEST | SLEEPY EYE | MN | 56085 | 5077947995 | 70 | Brown | Non profit - Corporation | 65 | 48.1 | Medicare and Medicaid | false | VOLUNTEERS OF AMERICA CARE FACILITIES | 12/01/1978 | false | false | false | false | Both | Yes | 4 | 4 | 3 | 2 | 5 | 4 | 4 | 2.40149 | 0.6877 | 0.85314 | 1.54084 | 3.94233 | 0.06369 | 2.01862 | 0.69955 | 0.31196 | 3.03013 | 2.47254 | 0.7392 | 1.02933 | 4.172 | 07/25/2019 | 6 | 6 | 1 | 24 | 1 | 0 | 24 | 09/07/2018 | 3 | 3 | 0 | 12 | 1 | 0 | 12 | 2017-08-03 | 10 | 10 | 0 | 1 | 48 | 0 | 48 | 24 | 0 | 0 | 0 | 0.00 | 0 | 0 | 1105 3RD AVENUE SOUTHWEST SLEEPY EYE, MN 56085 (44.287939, -94.725699) | 02/01/2020 | |||||||||||
2805 | 2805 | 301 TROENDLE STREET MAPLETON, MN 56065 | 43.926272 | -93.96156 | 0 | 245362 | MAPLETON COMMUNITY HOME | 301 TROENDLE STREET | MAPLETON | MN | 56065 | 5075243315 | 60 | Blue Earth | Non profit - Corporation | 60 | 50.7 | Medicare and Medicaid | false | MAPLETON COMMUNITY HOME | 12/01/1986 | false | false | false | false | Both | Yes | 4 | 3 | 4 | 3 | 4 | 4 | 4 | 3.02323 | 0.40744 | 0.80445 | 1.21189 | 4.23513 | 0.04771 | 2.16897 | 0.68963 | 0.3179 | 3.1765 | 2.8969 | 0.44426 | 0.95243 | 4.27534 | 03/14/2019 | 5 | 5 | 0 | 24 | 1 | 0 | 24 | 04/20/2018 | 2 | 2 | 0 | 24 | 1 | 0 | 24 | 2017-08-03 | 9 | 9 | 0 | 1 | 40 | 0 | 40 | 26.667 | 0 | 0 | 0 | 0.00 | 0 | 0 | 301 TROENDLE STREET MAPLETON, MN 56065 (43.926272, -93.96156) | 02/01/2020 | |||||||||||
3997 | 3997 | 1222 NORTH DR MOUNT PLEASANT, MI 48858 | 43.600411 | -84.761808 | 0 | 235037 | ISABELLA CO MEDICAL CARE FACIL | 1222 NORTH DR | MOUNT PLEASANT | MI | 48858 | 9897722957 | 360 | Isabella | Government - County | 100 | 95.8 | Medicare and Medicaid | false | ISABELLA COUNTY MEDICAL CARE | 01/01/1967 | false | false | false | false | Resident | Yes | 4 | 3 | 4 | 4 | 3 | 5 | 5 | 3.34662 | 0.70117 | 1.06928 | 1.77045 | 5.11706 | 0.10798 | 2.02935 | 0.74667 | 0.35955 | 3.13557 | 3.42741 | 0.70612 | 1.11933 | 5.23308 | 11/01/2019 | 10 | 10 | 0 | 68 | 0 | 0 | 68 | 10/31/2018 | 11 | 11 | 1 | 80 | 1 | 0 | 80 | 2017-08-03 | 6 | 6 | 1 | 2 | 52 | 26 | 78 | 73.667 | 2 | 1 | 1 | 10400.00 | 0 | 1 | 1222 NORTH DR MOUNT PLEASANT, MI 48858 (43.600411, -84.761808) | 02/01/2020 | |||||||||||
5330 | 5330 | 205 PEACH ORCHARD ROAD BALDWIN, GA 30511 | 34.498334 | -83.53588 | 0 | 115393 | OAKS - SCENIC VIEW SKILLED NURSING, THE | 205 PEACH ORCHARD ROAD | BALDWIN | GA | 30511 | 7067788377 | 540 | Habersham | For profit - Corporation | 148 | 124.1 | Medicare and Medicaid | false | THE OAKS SCENIC VIEW SKILLED NURSING LLC | 10/12/1989 | false | false | false | false | Resident | Yes | 4 | 4 | 4 | 4 | 4 | 2 | 2 | 2.13757 | 1.04726 | 0.47842 | 1.52568 | 3.66324 | 0.14967 | 2.34138 | 0.82679 | 0.40631 | 3.57448 | 1.89742 | 0.95245 | 0.44318 | 3.28629 | 10/31/2019 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 06/28/2018 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2017-08-03 | 3 | 3 | 0 | 1 | 32 | 0 | 32 | 5.333 | 0 | 0 | 0 | 0.00 | 0 | 0 | 205 PEACH ORCHARD ROAD BALDWIN, GA 30511 (34.498334, -83.53588) | 02/01/2020 | |||||||||||
5380 | 5380 | 1780 Old 41 Hwy NW, Kennesaw, GA 30152, USA | 33.9966998 | -84.5979459 | 1 | ROOFTOP | 115515 | ROSS MEMORIAL HEALTH CARE CTR | 1780 OLD HIGHWAY 41 | KENNESAW | GA | 30152 | 7704277256 | 290 | Cobb | For profit - Corporation | 100 | 83.5 | Medicare and Medicaid | false | SHADY GROVE REST HOME INC | 10/01/1991 | false | false | false | false | Resident | Yes | 4 | 4 | 3 | 4 | 2 | 2 | 2 | 2.59282 | 0.9984 | 0.30857 | 1.30697 | 3.89979 | 0.06535 | 2.13177 | 0.7362 | 0.32958 | 3.19755 | 2.52783 | 1.01976 | 0.35239 | 3.9109 | 05/31/2019 | 2 | 2 | 2 | 8 | 1 | 0 | 8 | 04/12/2018 | 3 | 3 | 0 | 8 | 1 | 0 | 8 | 2017-08-03 | 5 | 5 | 0 | 1 | 28 | 0 | 28 | 11.333 | 0 | 2 | 0 | 0.00 | 0 | 0 | 02/01/2020 | |||||||||||
5745 | 5745 | 560 SW MCFARLANE AVE LAKE CITY, FL 32055 | 30.182271 | -82.649175 | 0 | 105769 | SOLARIS HEALTHCARE LAKE CITY | 560 SW MCFARLANE AVE | LAKE CITY | FL | 32055 | 3867584777 | 110 | Columbia | For profit - Limited Liability company | 120 | 115.3 | Medicare and Medicaid | false | SOLARIS HEALTHCARE LAKE CITY LLC | 05/26/1992 | false | false | false | false | Resident | Yes | 4 | 4 | 4 | 4 | 4 | 3 | 3 | 2.72121 | 1.10391 | 0.73624 | 1.84015 | 4.56136 | 0.14778 | 2.11429 | 0.82135 | 0.42217 | 3.35781 | 2.67493 | 1.01063 | 0.65639 | 4.35604 | 09/12/2019 | 2 | 2 | 0 | 12 | 1 | 0 | 12 | 10/22/2018 | 5 | 5 | 0 | 28 | 1 | 0 | 28 | 2017-08-03 | 2 | 2 | 0 | 1 | 8 | 0 | 8 | 16.667 | 0 | 0 | 0 | 0.00 | 0 | 0 | 560 SW MCFARLANE AVE LAKE CITY, FL 32055 (30.182271, -82.649175) | 02/01/2020 | |||||||||||
6375 | 6375 | 1321 SCENIC DRIVE PERRYVILLE, AR 72126 | 35.007919 | -92.812169 | 0 | 45246 | PERRY COUNTY NURSING AND REHABILITATION CENTER | 1321 SCENIC DRIVE | PERRYVILLE | AR | 72126 | 5018892400 | 520 | Perry | For profit - Corporation | 95 | 67.2 | Medicare and Medicaid | false | PERRY COUNTY CARE CENTER INC | 09/15/1994 | false | false | false | false | Resident | Yes | 4 | 3 | 3 | 2 | 5 | 4 | 3 | 3.20333 | 0.83035 | 0.40739 | 1.23775 | 4.44108 | 0.00864 | 2.1936 | 0.64518 | 0.29527 | 3.13405 | 3.03501 | 0.96776 | 0.51931 | 4.54398 | 08/23/2019 | 3 | 3 | 0 | 24 | 1 | 0 | 24 | 10/04/2018 | 4 | 3 | 1 | 32 | 1 | 0 | 32 | 2017-08-03 | 2 | 0 | 2 | 0 | 133 | 0 | 133 | 44.833 | 0 | 3 | 1 | 9296.00 | 1 | 2 | 1321 SCENIC DRIVE PERRYVILLE, AR 72126 (35.007919, -92.812169) | 02/01/2020 | |||||||||||
7022 | 7022 | 516 N WILLIAMS ST ANGOLA, IN 46703 | 41.640437 | -84.994588 | 0 | 155449 | NORTHERN LAKES NURSING AND REHABILITATION CENTER | 516 N WILLIAMS ST | ANGOLA | IN | 46703 | 2606659467 | 750 | Steuben | Government - Hospital district | 99 | 87.7 | Medicare and Medicaid | false | PULASKI MEMORIAL HOSPITAL | 07/01/1992 | false | false | false | false | Resident | Yes | 4 | 3 | 5 | 4 | 5 | 2 | 2 | 2.36552 | 0.761 | 0.37778 | 1.13878 | 3.5043 | 0.02337 | 2.09027 | 0.75028 | 0.35304 | 3.19359 | 2.35201 | 0.76269 | 0.40276 | 3.51864 | 09/30/2019 | 2 | 2 | 0 | 8 | 1 | 0 | 8 | 08/22/2018 | 5 | 3 | 2 | 32 | 1 | 0 | 32 | 2017-08-03 | 8 | 5 | 3 | 1 | 123 | 0 | 123 | 35.167 | 3 | 4 | 2 | 31475.00 | 0 | 2 | 516 N WILLIAMS ST ANGOLA, IN 46703 (41.640437, -84.994588) | 02/01/2020 | |||||||||||
7091 | 7091 | 445 GALTIER AVENUE SAINT PAUL, MN 55103 | 44.954644 | -93.111021 | 0 | 245340 | GALTIER A VILLA CENTER | 445 GALTIER AVENUE | SAINT PAUL | MN | 55103 | 6512241848 | 610 | Ramsey | For profit - Corporation | 107 | 89.1 | Medicare and Medicaid | false | ST. PAUL OPCO, LLC | 09/01/1986 | false | false | false | false | Resident | Yes | 4 | 2 | 5 | 4 | 5 | 4 | 4 | 1.69645 | 1.12118 | 0.69614 | 1.81732 | 3.51377 | 0.05877 | 1.91454 | 0.69129 | 0.32152 | 2.92734 | 1.84159 | 1.21956 | 0.81493 | 3.84905 | 04/05/2019 | 11 | 11 | 2 | 48 | 1 | 0 | 48 | 06/07/2018 | 9 | 9 | 0 | 84 | 1 | 0 | 84 | 2017-08-03 | 3 | 1 | 2 | 1 | 12 | 0 | 12 | 54 | 2 | 1 | 0 | 0.00 | 0 | 0 | 445 GALTIER AVENUE SAINT PAUL, MN 55103 (44.954644, -93.111021) | 02/01/2020 | |||||||||||
7383 | 7383 | 113 CENTRAL HYDE PARK, MA 02136 | 42.260963 | -71.11943 | 0 | 225375 | PARK PLACE REHABILITATION & SKILLED CARE CENTER | 113 CENTRAL AVEUNE | HYDE PARK | MA | 2136 | 6173612388 | 160 | Suffolk | For profit - Corporation | 53 | 48.5 | Medicare and Medicaid | false | GA HCR II HYDE PARK SNF TRS SUB LLC | 07/01/1990 | false | false | false | false | Resident | Yes | 4 | 4 | 4 | 5 | 2 | 4 | 4 | 2.29084 | 0.72039 | 0.65025 | 1.37064 | 3.66148 | 0.0315 | 2.14467 | 0.69265 | 0.31219 | 3.14951 | 2.21998 | 0.78206 | 0.78396 | 3.72792 | 09/26/2019 | 4 | 4 | 0 | 28 | 1 | 0 | 28 | 10/24/2018 | 4 | 4 | 0 | 28 | 1 | 0 | 28 | 2017-08-03 | 2 | 2 | 0 | 1 | 12 | 0 | 12 | 25.333 | 0 | 0 | 0 | 0.00 | 0 | 0 | 113 CENTRAL HYDE PARK, MA 02136 (42.260963, -71.11943) | 02/01/2020 | |||||||||||
7576 | 7576 | 863 CENTRAL STREET FRAMINGHAM, MA 01701 | 42.307387 | -71.428575 | 0 | 225430 | ST PATRICK'S MANOR | 863 CENTRAL STREET | FRAMINGHAM | MA | 1701 | 5088798000 | 90 | Middlesex | Non profit - Church related | 333 | 276.2 | Medicare and Medicaid | false | ST. PATRICK'S MANOR, INC | 07/01/1990 | false | false | false | false | Both | Yes | 4 | 3 | 3 | 3 | 3 | 4 | 4 | 2.14089 | 0.792 | 0.65532 | 1.44732 | 3.58821 | 0.05607 | 2.154 | 0.66419 | 0.29129 | 3.10948 | 2.06568 | 0.89664 | 0.84675 | 3.70035 | 09/20/2019 | 6 | 6 | 0 | 28 | 1 | 0 | 28 | 10/24/2018 | 16 | 16 | 0 | 64 | 1 | 0 | 64 | 2017-08-03 | 7 | 7 | 0 | 1 | 32 | 0 | 32 | 40.667 | 0 | 0 | 0 | 0.00 | 0 | 0 | 863 CENTRAL STREET FRAMINGHAM, MA 01701 (42.307387, -71.428575) | 02/01/2020 | |||||||||||
7715 | 7715 | 616 BROAD STREET GRINNELL, IA 50112 | 41.739584 | -92.724126 | 0 | 165481 | MAYFLOWER HOME | 616 BROAD STREET | GRINNELL | IA | 50112 | 6412366151 | 780 | Poweshiek | Non profit - Church related | 60 | 39.2 | Medicare and Medicaid | false | MAYFLOWER HOMES INC | 01/01/2003 | true | false | false | false | Resident | Yes | 4 | 3 | 4 | 3 | 5 | 5 | 5 | 2.7863 | 0.86594 | 1.01422 | 1.88016 | 4.66647 | 0.05968 | 2.03674 | 0.61172 | 0.26893 | 2.91739 | 2.84321 | 1.06443 | 1.41945 | 5.12916 | 11/14/2019 | 5 | 5 | 0 | 20 | 1 | 0 | 20 | 10/04/2018 | 1 | 1 | 1 | 8 | 1 | 0 | 8 | 2017-08-03 | 6 | 6 | 3 | 1 | 36 | 0 | 36 | 18.667 | 0 | 1 | 0 | 0.00 | 0 | 0 | 616 BROAD STREET GRINNELL, IA 50112 (41.739584, -92.724126) | 02/01/2020 | |||||||||||
8266 | 8266 | 2855 OWL HOOT TRL STEAMBOAT SPRINGS, CO 80487 | 40.452878 | -106.812925 | 0 | 65341 | CASEY'S POND SENIOR LIVING LTC | 2855 OWL HOOT TRL | STEAMBOAT SPRINGS | CO | 80487 | 9708798855 | 530 | Routt | Non profit - Corporation | 66 | 53.8 | Medicare and Medicaid | false | COLORADO SENIOR RESIDENCES, INC. | 07/01/1995 | true | false | false | false | Resident | Yes | 4 | 3 | 4 | 3 | 5 | 5 | 5 | 2.45152 | 0.34642 | 1.15124 | 1.49765 | 3.94917 | 0.12105 | 2.05089 | 0.67261 | 0.30536 | 3.02886 | 2.48432 | 0.38728 | 1.41902 | 4.181 | 10/31/2019 | 5 | 5 | 0 | 32 | 1 | 0 | 32 | 11/15/2018 | 11 | 11 | 0 | 72 | 1 | 0 | 72 | 2017-08-03 | 7 | 7 | 0 | 1 | 40 | 0 | 40 | 46.667 | 0 | 0 | 0 | 0.00 | 0 | 0 | 2855 OWL HOOT TRL STEAMBOAT SPRINGS, CO 80487 (40.452878, -106.812925) | 02/01/2020 | |||||||||||
8515 | 8515 | 6152 N VERDE TRAIL BOCA RATON, FL 33433 | 26.363621 | -80.139389 | 0 | 105355 | WILLOWBROOKE COURT AT ST ANDREWS | 6152 N VERDE TRAIL | BOCA RATON | FL | 33433 | 5614875200 | 490 | Palm Beach | Non profit - Corporation | 89 | 83.8 | Medicare and Medicaid | false | ACTS RETIREMENT-LIFE COMMUNITIES INC | 06/13/1979 | false | false | false | false | Resident | Yes | 4 | 4 | 4 | 3 | 5 | 4 | 4 | 2.68792 | 0.79328 | 0.68397 | 1.47724 | 4.16516 | 0.10108 | 2.20093 | 0.73147 | 0.32336 | 3.25576 | 2.5382 | 0.81548 | 0.79611 | 4.10235 | 11/21/2019 | 4 | 4 | 0 | 20 | 1 | 0 | 20 | 09/20/2018 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2017-08-03 | 1 | 1 | 0 | 1 | 16 | 0 | 16 | 12.667 | 0 | 0 | 0 | 0.00 | 0 | 0 | 6152 N VERDE TRAIL BOCA RATON, FL 33433 (26.363621, -80.139389) | 02/01/2020 | |||||||||||
8568 | 8568 | 94 STEVENS ROAD TOMS RIVER, NJ 08755 | 40.011561 | -74.220903 | 0 | 315312 | HAMPTON RIDGE HEALTHCARE AND REHABILITATION | 94 STEVENS ROAD | TOMS RIVER | NJ | 8755 | 7322865005 | 310 | Ocean | For profit - Partnership | 204 | 180.7 | Medicare and Medicaid | false | HAMPTON RIDGE HEALTHCARE & REHABILITATION LLC | 05/06/1992 | false | false | false | false | Resident | Yes | 4 | 3 | 5 | 5 | 5 | 3 | 3 | 1.88717 | 1.02742 | 0.52562 | 1.55303 | 3.44021 | 0.06702 | 2.04675 | 0.6967 | 0.32113 | 3.06458 | 1.9163 | 1.10888 | 0.61605 | 3.59971 | 10/22/2019 | 2 | 2 | 0 | 12 | 0 | 0 | 12 | 11/02/2018 | 5 | 5 | 0 | 28 | 1 | 0 | 28 | 2017-08-03 | 1 | 1 | 0 | 1 | 4 | 0 | 4 | 16 | 0 | 0 | 0 | 0.00 | 0 | 0 | 94 STEVENS ROAD TOMS RIVER, NJ 08755 (40.011561, -74.220903) | 02/01/2020 | |||||||||||
9139 | 9139 | 1200 WEST FINLEY HUGO, OK 74743 | 34.01744 | -95.525029 | 0 | 375390 | BAPTIST VILLAGE OF HUGO | 1200 WEST FINLEY | HUGO | OK | 74743 | 5803268383 | 110 | Choctaw | Non profit - Church related | 100 | 74.7 | Medicare and Medicaid | false | BAPTIST VILLAGE RETIREMENT COMMUNITIES OF OKLAHOMA, INC | 11/01/2000 | false | false | false | false | Resident | Yes | 4 | 4 | 2 | 1 | 3 | 3 | 2 | 2.6165 | 0.90602 | 0.27054 | 1.17656 | 3.79305 | 0.00804 | 1.90723 | 0.68726 | 0.31995 | 2.91444 | 2.85123 | 0.99129 | 0.31825 | 4.17337 | 10/31/2019 | 8 | 8 | 0 | 52 | 1 | 0 | 52 | 09/20/2018 | 3 | 3 | 1 | 16 | 1 | 0 | 16 | 2017-08-03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 31.333 | 0 | 0 | 0 | 0.00 | 0 | 0 | 1200 WEST FINLEY HUGO, OK 74743 (34.01744, -95.525029) | 02/01/2020 | |||||||||||
9583 | 9583 | 165 SOUTH 1000 EAST SALT LAKE CITY, UT 84102 | 40.765707 | -111.862465 | 0 | 465072 | CITY CREEK POST ACUTE | 165 SOUTH 1000 EAST | SALT LAKE CITY | UT | 84102 | 8013225521 | 170 | Salt Lake | For profit - Corporation | 108 | 57.8 | Medicare and Medicaid | false | BEAVER VALLEY HOSPITAL | 12/15/1979 | false | false | false | false | Resident | Yes | 4 | 3 | 5 | 5 | 4 | 3 | 4 | 2.03462 | 0.59093 | 0.84104 | 1.43197 | 3.46659 | 0.12054 | 2.04323 | 0.78673 | 0.40635 | 3.23631 | 2.06959 | 0.56479 | 0.77902 | 3.43484 | 11/07/2019 | 3 | 3 | 0 | 12 | 1 | 0 | 12 | 11/07/2018 | 5 | 4 | 1 | 28 | 1 | 0 | 28 | 2017-08-03 | 15 | 15 | 0 | 1 | 150 | 0 | 150 | 40.333 | 0 | 1 | 1 | 61659.00 | 0 | 1 | 165 SOUTH 1000 EAST SALT LAKE CITY, UT 84102 (40.765707, -111.862465) | 02/01/2020 | |||||||||||
12967 | 12967 | 200 E RYAN ST BOERNE, TX 78006 | 29.796437 | -98.731875 | 0 | 675678 | CARECHOICE OF BOERNE | 200 E RYAN ST | BOERNE | TX | 78006 | 8302492594 | 731 | Kendall | Government - Hospital district | 74 | 54.4 | Medicare and Medicaid | false | UVALDE COUNTY HOSPITAL AUTHORITY | 04/11/1997 | false | false | false | false | Resident | Yes | 4 | 3 | 5 | 5 | 2 | 2 | 2 | 1.30591 | 0.88615 | 0.38781 | 1.27397 | 2.57988 | 0.05198 | 2.03383 | 0.80036 | 0.43509 | 3.26929 | 1.33449 | 0.83254 | 0.33549 | 2.53046 | 09/27/2019 | 7 | 7 | 0 | 40 | 1 | 0 | 40 | 09/28/2018 | 13 | 13 | 4 | 116 | 1 | 0 | 116 | 2017-08-03 | 6 | 6 | 0 | 1 | 44 | 0 | 44 | 66 | 0 | 1 | 0 | 0.00 | 0 | 0 | 200 E RYAN ST BOERNE, TX 78006 (29.796437, -98.731875) | 02/01/2020 | |||||||||||
13385 | 13385 | 2210 HOWARD ST SAN ANGELO, TX 76901 | 31.471577 | -100.476098 | 0 | 675982 | PARK PLAZA LTC PARTNERS, INC. | 2210 HOWARD ST | SAN ANGELO | TX | 76901 | 3259440561 | 930 | Tom Green | For profit - Corporation | 90 | 74.2 | Medicare and Medicaid | false | PARK PLAZA LTC PARTNERS, INC. | 07/23/2003 | false | false | false | false | Both | Yes | 4 | 4 | 3 | 2 | 3 | 3 | 2 | 4.53584 | 1.80629 | 0.54118 | 2.34747 | 6.88331 | 0.0257 | 2.07231 | 0.82115 | 0.43069 | 3.32415 | 4.54902 | 1.65405 | 0.47294 | 6.64002 | 10/04/2019 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10/05/2018 | 3 | 3 | 0 | 24 | 1 | 0 | 24 | 2017-08-03 | 6 | 3 | 3 | 1 | 88 | 0 | 88 | 22.667 | 1 | 1 | 0 | 0.00 | 0 | 0 | 2210 HOWARD ST SAN ANGELO, TX 76901 (31.471577, -100.476098) | 02/01/2020 | |||||||||||
13453 | 13453 | 276 PENNSYLVANIA AVENUE RAINELLE, WV 25962 | 37.964856 | -80.768971 | 0 | 515121 | MEADOW GARDEN | 276 PENNSYLVANIA AVENUE | RAINELLE | WV | 25962 | 3044386127 | 120 | Greenbrier | For profit - Limited Liability company | 60 | 55 | Medicare and Medicaid | false | RAINELLE CENTER LLC | 06/01/1993 | false | false | false | false | Both | Yes | 4 | 3 | 5 | 5 | 3 | 3 | 3 | 2.28204 | 1.23109 | 0.63522 | 1.86631 | 4.14835 | 0.06224 | 2.15166 | 0.82028 | 0.43718 | 3.40913 | 2.20427 | 1.12853 | 0.54688 | 3.90198 | 08/08/2019 | 10 | 10 | 0 | 48 | 1 | 0 | 48 | 09/13/2018 | 11 | 11 | 0 | 68 | 1 | 0 | 68 | 2017-08-03 | 9 | 9 | 0 | 1 | 56 | 0 | 56 | 56 | 0 | 0 | 0 | 0.00 | 0 | 0 | 276 PENNSYLVANIA AVENUE RAINELLE, WV 25962 (37.964856, -80.768971) | 02/01/2020 | |||||||||||
13765 | 13765 | 1406 OAK HARBOR RD FREMONT, OH 43420 | 41.361761 | -83.136703 | 0 | 366081 | PARKVIEW CARE CENTER | 1406 OAK HARBOR RD | FREMONT | OH | 43420 | 4193322589 | 730 | Sandusky | For profit - Corporation | 38 | 26.4 | Medicare and Medicaid | false | PARKVIEW CARE CENTER LLC | 07/30/1996 | false | false | false | false | Resident | Yes | 4 | 3 | 5 | 5 | 5 | 2 | 2 | 1.83307 | 0.69825 | 0.66327 | 1.36152 | 3.19459 | 0.04081 | 2.16955 | 0.89916 | 0.50082 | 3.56952 | 1.75601 | 0.58393 | 0.49847 | 2.86985 | 11/14/2019 | 8 | 7 | 1 | 60 | 1 | 0 | 60 | 10/11/2018 | 3 | 2 | 1 | 12 | 1 | 0 | 12 | 2017-08-03 | 3 | 0 | 3 | 0 | 28 | 0 | 28 | 38.667 | 0 | 5 | 1 | 3248.00 | 0 | 1 | 1406 OAK HARBOR RD FREMONT, OH 43420 (41.361761, -83.136703) | 02/01/2020 | |||||||||||
15008 | 15008 | 1804 FOREST HILLS ROAD W WILSON, NC 27893 | 35.722365 | -77.952126 | 0 | 345063 | CURIS AT WILSON NURSING & REHABILITATION CENTER | 1804 FOREST HILLS ROAD W | WILSON | NC | 27893 | 2522378161 | 970 | Wilson | For profit - Corporation | 110 | 83.6 | Medicare and Medicaid | false | CURIS AT WILSON OPCO LLC | 04/01/1972 | false | false | false | false | Resident | Yes | 4 | 4 | 4 | 4 | 4 | 2 | 2 | 2.01507 | 0.89224 | 0.42919 | 1.32144 | 3.33651 | 0.06006 | 2.31071 | 0.80708 | 0.41246 | 3.53025 | 1.81243 | 0.83129 | 0.39166 | 3.03068 | 09/13/2019 | 2 | 2 | 0 | 8 | 1 | 0 | 8 | 10/04/2018 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2017-08-03 | 3 | 3 | 0 | 1 | 12 | 0 | 12 | 6 | 0 | 0 | 0 | 0.00 | 0 | 0 | 1804 FOREST HILLS ROAD W WILSON, NC 27893 (35.722365, -77.952126) | 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 );