nh_gen_info_geocoded_final
Data source: Big Local News · About: big-local-datasette
31 rows where Overall Rating = 3 and "Rating Cycle 3 Standard Health Survey Date" is on date 2017-07-27
This data as json, copyable, CSV (advanced)
Suggested facets: geocode_flag, geocode_accuracy, prvdr_state, prvdr_cnty, ownership, nmbr_beds, prvdr_type, Legal Business Name, Continuing Care Retirement Community, Provider Changed Ownership in Last 12 Months, With a Resident and Family Council, Automatic Sprinkler Systems in All Required Areas, Health Inspection Rating, QM Rating, Long-Stay QM Rating, Short-Stay QM Rating, 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 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 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, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
381 | 381 | 89 Weid Dr, Naugatuck, CT 06770, USA | 41.4670981 | -73.03399859999999 | 1 | ROOFTOP | 75390 | BEACON BROOK HEALTH CENTER | 89 WIED DRIVE | NAUGATUCK | CT | 6770 | 2037299889 | 40 | New Haven | For profit - Corporation | 126 | 120.5 | Medicare and Medicaid | false | NAUGATUCK HEALTH CARE LLC | 11/23/1993 | false | false | false | false | Resident | Yes | 3 | 3 | 4 | 4 | 3 | 2 | 2 | 2.12008 | 0.92579 | 0.29027 | 1.21605 | 3.33614 | 0.1121 | 2.02973 | 0.67992 | 0.31404 | 3.02369 | 2.17085 | 1.02385 | 0.34789 | 3.53801 | 08/22/2019 | 7 | 7 | 2 | 28 | 1 | 0 | 28 | 07/19/2018 | 8 | 8 | 2 | 36 | 1 | 0 | 36 | 2017-07-27 | 3 | 2 | 2 | 1 | 44 | 0 | 44 | 33.333 | 4 | 1 | 2 | 15275.00 | 0 | 2 | 02/01/2020 | |||||||||||
1156 | 1156 | 11 BELL ROAD SELMA, AL 36701 | 32.42679 | -87.046679 | 0 | 15119 | SELMA HEALTH AND REHAB, LLC | 11 BELL ROAD | SELMA | AL | 36701 | 3348747425 | 230 | Dallas | For profit - Partnership | 172 | 119 | Medicare and Medicaid | false | Legal Business Name Not Available | 03/13/1973 | false | false | false | false | Both | Yes | 3 | 3 | 4 | 5 | 3 | 2 | 2 | 1.88482 | 0.76948 | 0.25022 | 1.0197 | 2.90452 | 0.00644 | 1.94544 | 0.65224 | 0.27686 | 2.87454 | 2.01357 | 0.8871 | 0.34017 | 3.24011 | 06/06/2019 | 4 | 3 | 1 | 28 | 1 | 0 | 28 | 07/19/2018 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2017-07-27 | 2 | 2 | 1 | 1 | 8 | 0 | 8 | 15.333 | 0 | 0 | 0 | 0.00 | 0 | 0 | 11 BELL ROAD SELMA, AL 36701 (32.42679, -87.046679) | 02/01/2020 | |||||||||||
2624 | 2624 | 2415 W HILLSBORO EL DORADO, AR 71730 | 33.207792 | -92.697943 | 0 | 45182 | COURTYARD REHABILITATION AND HEALTH CENTER, LLC | 2415 W HILLSBORO | EL DORADO | AR | 71730 | 8708635034 | 690 | Union | For profit - Limited Liability company | 101 | 75.8 | Medicare and Medicaid | false | COURTYARD REHABILITATION AND HEALTH | 12/12/1991 | false | false | false | false | Resident | Yes | 3 | 2 | 5 | 5 | 5 | 3 | 3 | 2.22818 | 0.90061 | 0.51881 | 1.41942 | 3.6476 | 0.06481 | 2.10998 | 0.70733 | 0.32667 | 3.14398 | 2.19477 | 0.95741 | 0.59777 | 3.72033 | 10/11/2019 | 2 | 2 | 0 | 141 | 1 | 0 | 141 | 10/05/2018 | 7 | 7 | 0 | 44 | 1 | 0 | 44 | 2017-07-27 | 5 | 4 | 5 | 1 | 40 | 0 | 40 | 91.833 | 1 | 1 | 1 | 8297.00 | 0 | 1 | 2415 W HILLSBORO EL DORADO, AR 71730 (33.207792, -92.697943) | 02/01/2020 | |||||||||||
3197 | 3197 | 401 VATICAN DRIVE DONALDSONVILLE, LA 70346 | 30.093328 | -90.998287 | 0 | 195491 | CHATEAU D'VILLE REHAB AND RETIREMENT | 401 VATICAN DRIVE | DONALDSONVILLE | LA | 70346 | 2254738614 | 20 | Ascension | For profit - Corporation | 141 | 99.1 | Medicare and Medicaid | false | D'VILLE HOME GROUP LLC | 07/03/2000 | false | false | false | false | Resident | Yes | 3 | 2 | 5 | 5 | 3 | 2 | 1 | 2.6162 | 1.02675 | 0.22366 | 1.25041 | 3.86661 | 0.04309 | 2.13088 | 0.8006 | 0.41854 | 3.35003 | 2.55169 | 0.96434 | 0.20113 | 3.70113 | 07/26/2019 | 5 | 5 | 0 | 36 | 1 | 0 | 36 | 08/09/2018 | 8 | 8 | 0 | 36 | 1 | 0 | 36 | 2017-07-27 | 5 | 3 | 2 | 1 | 36 | 0 | 36 | 36 | 0 | 1 | 0 | 0.00 | 0 | 0 | 401 VATICAN DRIVE DONALDSONVILLE, LA 70346 (30.093328, -90.998287) | 02/01/2020 | |||||||||||
3338 | 3338 | 304 EAST VETERANS ROAD LAURENS, IA 50554 | 42.842637 | -94.845553 | 0 | 165219 | LAURENS CARE CENTER | 304 EAST VETERANS ROAD | LAURENS | IA | 50554 | 7128454915 | 750 | Pocahontas | Non profit - Corporation | 38 | 34.5 | Medicare and Medicaid | false | LAURENS SENIOR PIONEERS INC | 05/01/1994 | false | false | false | false | Resident | Yes | 3 | 2 | 4 | 3 | 4 | 5 | 5 | 2.60659 | 0.60583 | 0.84094 | 1.44677 | 4.05336 | 0.06564 | 1.98985 | 0.66441 | 0.29899 | 2.95325 | 2.7225 | 0.68564 | 1.05863 | 4.40117 | 12/19/2019 | 10 | 10 | 0 | 52 | 1 | 0 | 52 | 11/01/2018 | 6 | 6 | 0 | 24 | 1 | 0 | 24 | 2017-07-27 | 3 | 3 | 1 | 1 | 12 | 0 | 12 | 36 | 1 | 0 | 0 | 0.00 | 0 | 0 | 304 EAST VETERANS ROAD LAURENS, IA 50554 (42.842637, -94.845553) | 02/01/2020 | |||||||||||
4750 | 4750 | 505 ROBERT BLVD SLIDELL, LA 70458 | 30.299382 | -89.757606 | 0 | 195301 | GREENBRIAR COMMUNITY CARE CENTER | 505 ROBERT BLVD. | SLIDELL | LA | 70458 | 9856436900 | 510 | St. Tammany | Non profit - Corporation | 174 | 114.2 | Medicare and Medicaid | false | COMMCARE CORPORATION | 12/01/1994 | false | false | false | false | Resident | Yes | 3 | 3 | 4 | 5 | 3 | 2 | 2 | 1.98321 | 1.17509 | 0.33642 | 1.51151 | 3.49472 | 0.06763 | 2.06456 | 0.80586 | 0.39519 | 3.2656 | 1.99645 | 1.09646 | 0.32041 | 3.43164 | 07/25/2019 | 2 | 2 | 0 | 12 | 1 | 0 | 12 | 08/10/2018 | 4 | 2 | 2 | 28 | 1 | 0 | 28 | 2017-07-27 | 1 | 0 | 1 | 0 | 4 | 0 | 4 | 16 | 0 | 4 | 0 | 0.00 | 0 | 0 | 505 ROBERT BLVD SLIDELL, LA 70458 (30.299382, -89.757606) | 02/01/2020 | |||||||||||
5325 | 5325 | 555 PROSPECT AVENUE ESTES PARK, CO 80517 | 40.372259 | -105.514088 | 0 | 65185 | PROSPECT PARK LIVING CENTER | 555 PROSPECT AVENUE | ESTES PARK | CO | 80517 | 9705868103 | 340 | Larimer | Government - Hospital district | 52 | 32 | Medicare and Medicaid | false | PARK HOSPITAL DISTRICT | 01/24/1984 | false | false | false | false | Resident | Yes | 3 | 2 | 2 | 1 | 4 | 5 | 5 | 1.81085 | 0.79038 | 1.23961 | 2.02999 | 3.84084 | 0.06389 | 1.97569 | 0.63262 | 0.27742 | 2.88574 | 1.90492 | 0.93945 | 1.68181 | 4.26798 | 12/10/2019 | 9 | 6 | 5 | 76 | 1 | 0 | 76 | 12/13/2018 | 3 | 3 | 0 | 16 | 1 | 0 | 16 | 2017-07-27 | 6 | 6 | 0 | 1 | 32 | 0 | 32 | 48.667 | 0 | 9 | 0 | 0.00 | 0 | 0 | 555 PROSPECT AVENUE ESTES PARK, CO 80517 (40.372259, -105.514088) | 02/01/2020 | |||||||||||
5603 | 5603 | 815 LEGION DRIVE EASTMAN, GA 31023 | 32.187542 | -83.179118 | 0 | 115471 | HEART OF GEORGIA NURSING HOME | 815 LEGION DRIVE | EASTMAN | GA | 31023 | 4783745571 | 380 | Dodge | For profit - Corporation | 100 | 92.4 | Medicare and Medicaid | false | AZ OPERATOR LLC | 01/01/1990 | false | false | false | false | Resident | Yes | 3 | 3 | 3 | 4 | 3 | 2 | 2 | 2.09953 | 1.00424 | 0.37747 | 1.3817 | 3.48123 | 0.02329 | 2.15295 | 0.79065 | 0.39657 | 3.34017 | 2.02677 | 0.95507 | 0.35826 | 3.34209 | 12/12/2019 | 5 | 4 | 1 | 40 | 0 | 0 | 40 | 07/26/2018 | 1 | 0 | 1 | 8 | 0 | 0 | 8 | 2017-07-27 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 22.667 | 0 | 3 | 0 | 0.00 | 0 | 0 | 815 LEGION DRIVE EASTMAN, GA 31023 (32.187542, -83.179118) | 02/01/2020 | |||||||||||
5820 | 5820 | 500 TRUMAN BOULEVARD CARUTHERSVILLE, MO 63830 | 36.196117 | -89.664331 | 0 | 265771 | SOUTHGATE LIVING CENTER | 500 TRUMAN BOULEVARD | CARUTHERSVILLE | MO | 63830 | 5733335150 | 770 | Pemiscot | For profit - Individual | 94 | 70.4 | Medicare and Medicaid | false | CARUTHERSVILLE NO 1 INC | 12/18/2003 | false | false | false | false | Resident | Yes | 3 | 3 | 2 | 3 | 1 | 2 | 2 | 1.60235 | 0.78271 | 0.38973 | 1.17245 | 2.7748 | 0.01379 | 2.00691 | 0.6486 | 0.33991 | 2.99542 | 1.65937 | 0.90743 | 0.43155 | 2.97048 | 10/16/2019 | 10 | 7 | 3 | 40 | 1 | 0 | 40 | 09/28/2018 | 10 | 10 | 0 | 40 | 1 | 0 | 40 | 2017-07-27 | 10 | 6 | 4 | 1 | 52 | 0 | 52 | 42 | 0 | 9 | 0 | 0.00 | 0 | 0 | 500 TRUMAN BOULEVARD CARUTHERSVILLE, MO 63830 (36.196117, -89.664331) | 02/01/2020 | |||||||||||
6400 | 6400 | 751 NORTH OAK STREET CARLINVILLE, IL 62626 | 39.288574 | -89.885651 | 0 | 145454 | CARLINVILLE REHAB & HCC | 751 NORTH OAK STREET | CARLINVILLE | IL | 62626 | 2178542511 | 670 | Macoupin | For profit - Corporation | 98 | 76.7 | Medicare and Medicaid | false | CARLINVILLE REHABILITATION AND HEALTH CARE CENTER, LLC | 08/31/1982 | false | false | false | false | Resident | Yes | 3 | 3 | 3 | 3 | 3 | 2 | 3 | 1.75578 | 0.71102 | 0.43926 | 1.15028 | 2.90606 | 0.02128 | 2.21075 | 0.68582 | 0.31897 | 3.21554 | 1.65062 | 0.77957 | 0.51834 | 2.89804 | 06/27/2019 | 9 | 9 | 0 | 56 | 1 | 0 | 56 | 08/22/2018 | 7 | 7 | 0 | 52 | 1 | 0 | 52 | 2017-07-27 | 9 | 9 | 0 | 1 | 76 | 0 | 76 | 58 | 0 | 0 | 0 | 0.00 | 0 | 0 | 751 NORTH OAK STREET CARLINVILLE, IL 62626 (39.288574, -89.885651) | 02/01/2020 | |||||||||||
6555 | 6555 | 2660 SW 53RD LN GAINESVILLE, FL 32608 | 29.603838 | -82.360935 | 0 | 106066 | OAK HAMMOCK AT THE UNIVERSITY OF FLORIDA INC | 2660 SW 53RD LN | GAINESVILLE | FL | 32608 | 3525481142 | 0 | Alachua | Non profit - Corporation | 73 | 62.7 | Medicare | false | OAK HAMMOCK AT THE UNIVERSITY OF FLORIDA INC | 03/24/2005 | true | false | false | false | Resident | Yes | 3 | 3 | 5 | 5 | 5 | 1 | 12 | 1 | 12 | 6 | 6 | 10/10/2019 | 6 | 6 | 0 | 28 | 1 | 0 | 28 | 07/18/2018 | 3 | 3 | 0 | 24 | 1 | 0 | 24 | 2017-07-27 | 4 | 4 | 0 | 1 | 20 | 0 | 20 | 25.333 | 0 | 0 | 0 | 0.00 | 0 | 0 | 2660 SW 53RD LN GAINESVILLE, FL 32608 (29.603838, -82.360935) | 02/01/2020 | |||||||||||||||||||||
6639 | 6639 | 705 GRAND CANYON DRIVE FARMINGTON, MO 63640 | 37.793041 | -90.432186 | 0 | 265348 | CAMELOT NURSING AND REHABILITATION CENTER | 705 GRAND CANYON DRIVE | FARMINGTON | MO | 63640 | 5737568911 | 930 | St. Francois | For profit - Corporation | 97 | 70 | Medicare and Medicaid | false | OPCO FARMINGTON, MO, LLC | 01/01/1989 | false | false | false | false | Resident | Yes | 3 | 4 | 3 | 3 | 3 | 1 | 12 | 1 | 12 | 2.36387 | 0.71427 | 0.26773 | 0.982 | 3.34587 | 0.11158 | 1.87775 | 0.66288 | 0.32057 | 2.8612 | 2.61639 | 0.81023 | 0.31434 | 3.74984 | 07/12/2019 | 11 | 11 | 0 | 40 | 1 | 0 | 40 | 08/24/2018 | 8 | 8 | 0 | 28 | 1 | 0 | 28 | 2017-07-27 | 3 | 3 | 0 | 1 | 12 | 0 | 12 | 31.333 | 0 | 0 | 0 | 0.00 | 0 | 0 | 705 GRAND CANYON DRIVE FARMINGTON, MO 63640 (37.793041, -90.432186) | 02/01/2020 | |||||||||
7436 | 7436 | 3001 DEER CREEK COUNTRY CLUB DEERFIELD BEACH, FL 33442 | 26.320083 | -80.144652 | 0 | 105691 | FORUM AT DEER CREEK | 3001 DEER CREEK COUNTRY CLUB | DEERFIELD BEACH | FL | 33442 | 9546986269 | 50 | Broward | For profit - Corporation | 60 | 47.7 | Medicare and Medicaid | false | Legal Business Name Not Available | 06/04/1990 | false | false | false | false | Resident | Yes | 3 | 2 | 4 | 4 | 4 | 5 | 5 | 2.67385 | 0.36268 | 1.6886 | 2.05128 | 4.72512 | 0.16114 | 2.13499 | 0.76677 | 0.39291 | 3.29466 | 2.60289 | 0.35567 | 1.61759 | 4.59892 | 11/07/2019 | 4 | 4 | 0 | 44 | 1 | 0 | 44 | 09/07/2018 | 6 | 3 | 3 | 24 | 1 | 0 | 24 | 2017-07-27 | 4 | 3 | 1 | 1 | 32 | 0 | 32 | 35.333 | 0 | 2 | 0 | 0.00 | 0 | 0 | 3001 DEER CREEK COUNTRY CLUB DEERFIELD BEACH, FL 33442 (26.320083, -80.144652) | 02/01/2020 | |||||||||||
7527 | 7527 | 1900 CHADWICK DRIVE JACKSON, MS 39204 | 32.286943 | -90.259083 | 0 | 255125 | CHADWICK NURSING AND REHABILITATION CENTER LLC | 1900 CHADWICK DRIVE | JACKSON | MS | 39204 | 6013720231 | 240 | Hinds | For profit - Partnership | 102 | 89.2 | Medicare and Medicaid | false | CHADWICK NURSING AND REHABILITATION CENTER LLC | 10/01/1989 | false | false | false | false | Resident | Yes | 3 | 3 | 2 | 4 | 1 | 2 | 2 | 1.5265 | 0.97383 | 0.30055 | 1.27438 | 2.80088 | 0.05821 | 1.9918 | 0.70847 | 0.31445 | 3.01471 | 1.59283 | 1.03358 | 0.35975 | 2.97922 | 12/12/2019 | 5 | 5 | 0 | 24 | 1 | 0 | 24 | 11/16/2018 | 3 | 3 | 0 | 12 | 1 | 0 | 12 | 2017-07-27 | 3 | 2 | 1 | 1 | 12 | 0 | 12 | 18 | 0 | 1 | 0 | 0.00 | 0 | 0 | 1900 CHADWICK DRIVE JACKSON, MS 39204 (32.286943, -90.259083) | 02/01/2020 | |||||||||||
7614 | 7614 | 111 CHURCH STREET MIDDLETOWN, CT 06457 | 41.555227 | -72.651675 | 0 | 75381 | WATER'S EDGE CENTER FOR HEALTH & REHAB | 111 CHURCH STREET | MIDDLETOWN | CT | 6457 | 8603477286 | 30 | Middlesex | For profit - Corporation | 150 | 129.6 | Medicare and Medicaid | false | HARBOR HILL CARE CENTER, INC. | 01/29/1993 | false | false | false | false | Both | Yes | 3 | 2 | 5 | 5 | 5 | 3 | 3 | 2.11714 | 0.79218 | 0.45902 | 1.2512 | 3.36834 | 0.0624 | 2.03079 | 0.68579 | 0.32138 | 3.03796 | 2.16671 | 0.86859 | 0.53758 | 3.55538 | 08/29/2019 | 11 | 10 | 1 | 56 | 1 | 0 | 56 | 07/12/2018 | 16 | 14 | 2 | 60 | 1 | 0 | 60 | 2017-07-27 | 3 | 3 | 0 | 1 | 12 | 0 | 12 | 50 | 1 | 2 | 2 | 22225.00 | 0 | 2 | 111 CHURCH STREET MIDDLETOWN, CT 06457 (41.555227, -72.651675) | 02/01/2020 | |||||||||||
8928 | 8928 | 2906 GREER HWY MARIETTA, SC 29661 | 35.021805 | -82.5026 | 0 | 425307 | RIVER FALLS REHABILITATION AND HEALTHCARE CENTER | 2906 GREER HWY | MARIETTA | SC | 29661 | 8648366381 | 220 | Greenville | For profit - Corporation | 44 | 40.3 | Medicare and Medicaid | false | SC-GA2018 RIVER FALLS REHABILITATION AND HEALTHCARE CENTER LLC | 04/09/1991 | false | false | false | false | Both | Yes | 3 | 4 | 2 | 2 | 2 | 1 | 12 | 1 | 12 | 2.52259 | 1.03147 | 0.45226 | 1.48374 | 4.00633 | 0.03895 | 2.13008 | 0.71793 | 0.31626 | 3.16427 | 2.46132 | 1.08034 | 0.53823 | 4.06 | 07/17/2019 | 7 | 7 | 7 | 28 | 1 | 0 | 28 | 06/14/2018 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2017-07-27 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 14 | 0 | 0 | 0 | 0.00 | 0 | 0 | 2906 GREER HWY MARIETTA, SC 29661 (35.021805, -82.5026) | 02/01/2020 | |||||||||
8991 | 8991 | 24552 Paseo De Valencia, Laguna Hills, CA 92653, USA | 33.6068921 | -117.7043375 | 1 | ROOFTOP | 555462 | VILLA VALENCIA | 24552 PASEO DE VALENCIA | LAGUNA HILLS | CA | 92653 | 9494588880 | 400 | Orange | For profit - Corporation | 59 | 22.5 | Medicare | false | SNH SE TENANT TRS, INC. | 06/24/1991 | true | false | false | false | Resident | Yes | 3 | 3 | 5 | 5 | 5 | 1 | 12 | 1 | 12 | 2.82431 | 1.74223 | 0.76003 | 2.50226 | 5.32657 | 0.13599 | 2.24381 | 0.92427 | 0.48494 | 3.65302 | 2.61602 | 1.4174 | 0.5899 | 4.67572 | 08/19/2019 | 7 | 7 | 0 | 32 | 1 | 0 | 32 | 08/10/2018 | 15 | 12 | 3 | 116 | 1 | 0 | 116 | 2017-07-27 | 16 | 14 | 2 | 1 | 76 | 0 | 76 | 67.333 | 1 | 0 | 0 | 0.00 | 0 | 0 | 02/01/2020 | |||||||||
8995 | 8995 | 200 LUTHER ROAD SHREWSBURY, PA 17361 | 39.751424 | -76.679537 | 0 | 395438 | SPIRITRUST LUTHERAN THE VILLAGE AT SHREWSBURY | 200 LUTHER ROAD | SHREWSBURY | PA | 17361 | 7172356895 | 800 | York | Non profit - Corporation | 100 | 92.3 | Medicare and Medicaid | false | SPIRITRUST LUTHERAN | 10/01/1979 | true | false | false | false | Resident | Yes | 3 | 2 | 5 | 5 | 5 | 2 | 3 | 2.04954 | 0.62219 | 0.73652 | 1.35871 | 3.40825 | 0.04921 | 2.36194 | 0.82094 | 0.41567 | 3.59856 | 1.80345 | 0.56989 | 0.6669 | 3.03708 | 07/25/2019 | 9 | 8 | 9 | 111 | 1 | 0 | 111 | 08/02/2018 | 8 | 7 | 1 | 32 | 1 | 0 | 32 | 2017-07-27 | 10 | 5 | 5 | 1 | 44 | 0 | 44 | 73.5 | 4 | 3 | 0 | 0.00 | 0 | 0 | 200 LUTHER ROAD SHREWSBURY, PA 17361 (39.751424, -76.679537) | 02/01/2020 | |||||||||||
9070 | 9070 | 110 CHICKTOWN RD GATESVILLE, TX 76528 | 31.433846 | -97.781324 | 0 | 675886 | THE MEADOWS | 110 CHICKTOWN RD | GATESVILLE | TX | 76528 | 2544042500 | 341 | Coryell | Non profit - Other | 90 | 88.6 | Medicare and Medicaid | false | CORYELL COUNTY MEMORIAL HOSPITAL AUTHORITY | 09/20/2001 | false | false | false | false | Resident | Yes | 3 | 4 | 1 | 1 | 1 | 2 | 1 | 2.78957 | 0.93232 | 0.20902 | 1.14134 | 3.93091 | 0.05588 | 1.94932 | 0.68795 | 0.33084 | 2.96811 | 2.97421 | 1.01904 | 0.23779 | 4.24684 | 08/14/2019 | 3 | 3 | 0 | 20 | 1 | 0 | 20 | 08/09/2018 | 2 | 2 | 0 | 16 | 1 | 0 | 16 | 2017-07-27 | 10 | 10 | 0 | 1 | 100 | 0 | 100 | 32 | 0 | 0 | 0 | 0.00 | 0 | 0 | 110 CHICKTOWN RD GATESVILLE, TX 76528 (31.433846, -97.781324) | 02/01/2020 | |||||||||||
9135 | 9135 | 5865 PA-154, Forksville, PA 18616, USA | 41.5116003 | -76.6245276 | 1 | ROOFTOP | 395909 | DARWAY HEALTHCARE AND REHABILITATION CENTER | 5865 ROUTE 154 | FORKSVILLE | PA | 18616 | 5709243411 | 690 | Sullivan | For profit - Corporation | 67 | 57.3 | Medicare and Medicaid | false | GUARDIAN ELDER CARE AT FORKSVILLE LLC | 09/01/1993 | false | false | false | false | Resident | Yes | 3 | 3 | 3 | 3 | 4 | 2 | 3 | 1.68666 | 0.67931 | 0.65219 | 1.3315 | 3.01816 | 0.07505 | 1.97544 | 0.78932 | 0.40687 | 3.17162 | 1.77452 | 0.64714 | 0.60332 | 3.0515 | 08/08/2019 | 8 | 8 | 0 | 36 | 1 | 0 | 36 | 08/24/2018 | 9 | 9 | 0 | 40 | 1 | 0 | 40 | 2017-07-27 | 8 | 8 | 0 | 1 | 32 | 0 | 32 | 36.667 | 0 | 0 | 0 | 0.00 | 0 | 0 | 02/01/2020 | |||||||||||
9225 | 9225 | 3416 COLUMBUS AVE SANDUSKY, OH 44870 | 41.418483 | -82.689489 | 0 | 366325 | OHIO VETERANS HOME | 3416 COLUMBUS AVE | SANDUSKY | OH | 44870 | 4196252454 | 220 | Erie | Government - State | 427 | 389.7 | Medicare and Medicaid | false | Legal Business Name Not Available | 10/01/2006 | false | false | false | false | Both | Partial | 3 | 3 | 3 | 5 | 2 | 3 | 3 | 1.9396 | 1.23849 | 0.41556 | 1.65406 | 3.59366 | 0.01295 | 1.85829 | 0.6299 | 0.27008 | 2.75827 | 2.16927 | 1.47845 | 0.57913 | 4.17785 | 10/24/2019 | 5 | 5 | 0 | 52 | 1 | 0 | 52 | 09/13/2018 | 3 | 3 | 0 | 12 | 1 | 0 | 12 | 2017-07-27 | 6 | 1 | 5 | 1 | 44 | 0 | 44 | 37.333 | 2 | 2 | 1 | 6500.00 | 0 | 1 | 3416 COLUMBUS AVE SANDUSKY, OH 44870 (41.418483, -82.689489) | 02/01/2020 | |||||||||||
10322 | 10322 | 1103 SOUTH SECOND STREET MILBANK, SD 57252 | 45.21188 | -96.637314 | 0 | 435009 | AVANTARA MILBANK | 1103 SOUTH SECOND STREET | MILBANK | SD | 57252 | 6054324556 | 250 | Grant | For profit - Corporation | 60 | 56.7 | Medicare and Medicaid | false | MILBANK SD SKILLED NURSING FACILITY, LLC | 02/01/1967 | false | false | false | true | Both | Yes | 3 | 4 | 4 | 3 | 5 | 1 | 12 | 1 | 12 | 6 | 6 | 11/06/2019 | 3 | 3 | 0 | 20 | 1 | 0 | 20 | 10/03/2018 | 2 | 2 | 0 | 8 | 1 | 0 | 8 | 2017-07-27 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 12.667 | 0 | 0 | 0 | 0.00 | 0 | 0 | 1103 SOUTH SECOND STREET MILBANK, SD 57252 (45.21188, -96.637314) | 02/01/2020 | |||||||||||||||||||||
10507 | 10507 | 75 HALE STREET WILMINGTON, OH 45177 | 39.446164 | -83.842064 | 0 | 365228 | WILMINGTON NURSING & REHAB | 75 HALE STREET | WILMINGTON | OH | 45177 | 9373821621 | 130 | Clinton | For profit - Corporation | 76 | 60.4 | Medicare and Medicaid | false | WILMINGTON HEALTHCARE GROUP, INC. | 04/22/1974 | false | false | false | false | Resident | Yes | 3 | 3 | 4 | 5 | 4 | 2 | 2 | 1.73116 | 0.70985 | 0.53214 | 1.242 | 2.97316 | 0.11028 | 2.0633 | 0.80159 | 0.41459 | 3.27949 | 1.74378 | 0.66589 | 0.4831 | 2.90714 | 06/06/2019 | 4 | 4 | 0 | 28 | 1 | 0 | 28 | 06/04/2018 | 14 | 8 | 6 | 60 | 1 | 0 | 60 | 2017-07-27 | 11 | 11 | 0 | 1 | 44 | 0 | 44 | 41.333 | 1 | 1 | 0 | 0.00 | 0 | 0 | 75 HALE STREET WILMINGTON, OH 45177 (39.446164, -83.842064) | 02/01/2020 | |||||||||||
10677 | 10677 | 1990 WEST LOUCKS STREET SHERIDAN, WY 82801 | 44.789601 | -106.987926 | 0 | 535039 | WESTVIEW HEALTH CARE CENTER | 1990 WEST LOUCKS STREET | SHERIDAN | WY | 82801 | 3076729789 | 160 | Sheridan | For profit - Corporation | 102 | 63.6 | Medicare and Medicaid | false | WESTVIEW OPERATIONS LLC | 10/06/1989 | false | false | false | false | Resident | Yes | 3 | 2 | 4 | 4 | 4 | 4 | 5 | 1.92786 | 0.23642 | 0.98002 | 1.21643 | 3.1443 | 0.06979 | 1.96248 | 0.67698 | 0.31407 | 2.95353 | 2.04167 | 0.2626 | 1.17446 | 3.41377 | 08/08/2019 | 13 | 13 | 13 | 64 | 1 | 0 | 64 | 08/29/2018 | 9 | 6 | 3 | 68 | 2 | 34 | 102 | 2017-07-27 | 7 | 7 | 1 | 1 | 24 | 0 | 24 | 70 | 0 | 1 | 1 | 43186.00 | 0 | 1 | 1990 WEST LOUCKS STREET SHERIDAN, WY 82801 (44.789601, -106.987926) | 02/01/2020 | |||||||||||
11827 | 11827 | 6101 OHIO PLANO, TX 75024 | 33.057407 | -96.789573 | 0 | 676189 | THE LEGACY AT WILLOW BEND | 6101 OHIO STE 500 | PLANO | TX | 75024 | 9724686300 | 310 | Collin | Non profit - Corporation | 60 | 59.7 | Medicare and Medicaid | false | THE LEGACY AT WILLOW BEND RETIREMENT COMMUNITY INC | 07/24/2008 | true | false | false | false | Resident | Yes | 3 | 4 | 3 | 2 | 5 | 1 | 12 | 1 | 12 | 6 | 6 | 06/20/2019 | 1 | 1 | 0 | 16 | 1 | 0 | 16 | 06/29/2018 | 6 | 6 | 0 | 40 | 1 | 0 | 40 | 2017-07-27 | 5 | 1 | 4 | 1 | 84 | 0 | 84 | 35.333 | 1 | 0 | 1 | 4812.00 | 0 | 1 | 6101 OHIO PLANO, TX 75024 (33.057407, -96.789573) | 02/01/2020 | |||||||||||||||||||||
12417 | 12417 | 9320 AVALON CIRCLE CENTERVILLE, OH 45458 | 39.573125 | -84.189422 | 0 | 366368 | OTTERBEIN SPRINGBORO | 9320 AVALON CIRCLE | CENTERVILLE | OH | 45458 | 9378855426 | 840 | Warren | Non profit - Corporation | 50 | 43.3 | Medicare and Medicaid | false | OTTERBEIN CLEAR CREEK | 11/10/2008 | false | false | false | false | None | Yes | 3 | 2 | 2 | 2 | 2 | 4 | 3 | 4.13142 | 0.56105 | 0.73162 | 1.29267 | 5.42409 | 0.10995 | 2.20692 | 0.8178 | 0.41938 | 3.4441 | 3.89071 | 0.51586 | 0.65661 | 5.05014 | 11/14/2019 | 13 | 13 | 0 | 72 | 1 | 0 | 72 | 09/27/2018 | 16 | 16 | 0 | 96 | 1 | 0 | 96 | 2017-07-27 | 1 | 1 | 0 | 1 | 16 | 0 | 16 | 70.667 | 0 | 0 | 0 | 0.00 | 0 | 0 | 9320 AVALON CIRCLE CENTERVILLE, OH 45458 (39.573125, -84.189422) | 02/01/2020 | |||||||||||
12833 | 12833 | 222 NICOLETTE ROAD PARKERSBURG, WV 26104 | 39.218155 | -81.508868 | 0 | 515181 | OHIO VALLEY HEALTH CARE | 222 NICOLETTE ROAD | PARKERSBURG | WV | 26104 | 3044855137 | 530 | Wood | For profit - Corporation | 66 | 58.5 | Medicare and Medicaid | false | OHIO VALLEY NURSING HOME INC | 10/01/2002 | false | false | false | false | Resident | Yes | 3 | 2 | 2 | 1 | 3 | 4 | 5 | 1.70424 | 0.80158 | 1.02023 | 1.82181 | 3.52605 | 0.02657 | 2.05745 | 0.7238 | 0.34087 | 3.12212 | 1.72154 | 0.83275 | 1.12652 | 3.62153 | 08/28/2019 | 11 | 9 | 2 | 56 | 1 | 0 | 56 | 08/16/2018 | 16 | 14 | 2 | 116 | 1 | 0 | 116 | 2017-07-27 | 4 | 4 | 0 | 1 | 24 | 0 | 24 | 70.667 | 0 | 1 | 1 | 13000.00 | 0 | 1 | 222 NICOLETTE ROAD PARKERSBURG, WV 26104 (39.218155, -81.508868) | 02/01/2020 | |||||||||||
13351 | 13351 | 330 SOUTHWEST AVE TALLMADGE, OH 44278 | 41.094864 | -81.451581 | 0 | 366010 | THE PINNACLE REHABILITATION AND NURSING CENTER | 330 SOUTHWEST AVE | TALLMADGE | OH | 44278 | 3306330555 | 780 | Summit | For profit - Corporation | 75 | 67.4 | Medicare and Medicaid | false | SUMMIT VILLA CARE CENTER LLC | 06/07/1995 | false | false | false | false | Resident | Yes | 3 | 3 | 2 | 4 | 1 | 2 | 2 | 1.75378 | 0.8933 | 0.47989 | 1.37319 | 3.12696 | 0.03026 | 1.94838 | 0.81358 | 0.43696 | 3.19892 | 1.87076 | 0.82562 | 0.41336 | 3.13453 | 09/19/2019 | 5 | 2 | 3 | 32 | 1 | 0 | 32 | 08/16/2018 | 1 | 1 | 0 | 4 | 1 | 0 | 4 | 2017-07-27 | 15 | 9 | 6 | 1 | 100 | 0 | 100 | 34 | 0 | 5 | 1 | 6500.00 | 0 | 1 | 330 SOUTHWEST AVE TALLMADGE, OH 44278 (41.094864, -81.451581) | 02/01/2020 | |||||||||||
13399 | 13399 | 1600 GRAND LAKE DR CONROE, TX 77301 | 30.281054 | -95.465979 | 0 | 675894 | PARK MANOR OF CONROE | 1600 GRAND LAKE DR | CONROE | TX | 77301 | 9364418266 | 801 | Montgomery | For profit - Limited Liability company | 125 | 106.9 | Medicare and Medicaid | false | WINNIE-STOWELL HOSPITAL DISTRICT | 12/05/2001 | false | false | false | false | Resident | Yes | 3 | 4 | 4 | 5 | 3 | 1 | 1 | 1.81963 | 1.03869 | 0.24751 | 1.2862 | 3.10584 | 0.06228 | 2.1748 | 0.83276 | 0.46427 | 3.47184 | 1.73892 | 0.93788 | 0.20066 | 2.86862 | 06/26/2019 | 1 | 0 | 1 | 4 | 0 | 0 | 4 | 07/27/2018 | 11 | 5 | 7 | 56 | 1 | 0 | 56 | 2017-07-27 | 9 | 6 | 3 | 1 | 100 | 0 | 100 | 37.333 | 3 | 19 | 1 | 7677.00 | 0 | 1 | 1600 GRAND LAKE DR CONROE, TX 77301 (30.281054, -95.465979) | 02/01/2020 | |||||||||||
13953 | 13953 | 401 W AIRPORT HWY SWANTON, OH 43558 | 41.579911 | -83.899014 | 0 | 365745 | SWANTON VALLEY REHABILITATION AND HEALTHCARE CENTE | 401 W AIRPORT HWY | SWANTON | OH | 43558 | 4198251111 | 260 | Fulton | For profit - Corporation | 92 | 74.6 | Medicare and Medicaid | false | SWANTON VALLEY REHABILITATION AND HEALTHCARE CENTER LLC | 06/28/1989 | false | false | false | true | Both | Yes | 3 | 3 | 2 | 2 | 2 | 2 | 2 | 1.55979 | 0.98304 | 0.37975 | 1.36279 | 2.92258 | 0 | 2.08135 | 0.78372 | 0.39301 | 3.25808 | 1.55753 | 0.94319 | 0.36368 | 2.87646 | 11/14/2019 | 6 | 3 | 3 | 40 | 1 | 0 | 40 | 09/27/2018 | 5 | 3 | 2 | 32 | 1 | 0 | 32 | 2017-07-27 | 2 | 2 | 0 | 1 | 8 | 0 | 8 | 32 | 0 | 3 | 0 | 0.00 | 0 | 0 | 401 W AIRPORT HWY SWANTON, OH 43558 (41.579911, -83.899014) | 02/01/2020 | |||||||||||
13981 | 13981 | 4285 SOUTH HIGHLAND DRIVE HOLLADAY, UT 84124 | 40.677703 | -111.84254 | 0 | 465078 | HIGHLAND CARE CENTER | 4285 SOUTH HIGHLAND DRIVE | HOLLADAY | UT | 84124 | 8012782839 | 170 | Salt Lake | For profit - Corporation | 103 | 68.6 | Medicare and Medicaid | false | BEAVER VALLEY HOSPITAL | 09/01/1981 | false | false | false | false | Both | Yes | 3 | 3 | 4 | 4 | 5 | 2 | 2 | 1.97367 | 0.96518 | 0.66263 | 1.62781 | 3.60147 | 0.32045 | 2.19489 | 0.91524 | 0.50734 | 3.61747 | 1.86886 | 0.79297 | 0.49159 | 3.19248 | 11/07/2019 | 10 | 10 | 0 | 56 | 1 | 0 | 56 | 10/25/2018 | 13 | 13 | 0 | 60 | 1 | 0 | 60 | 2017-07-27 | 9 | 5 | 4 | 1 | 64 | 0 | 64 | 58.667 | 0 | 3 | 1 | 6633.00 | 0 | 1 | 4285 SOUTH HIGHLAND DRIVE HOLLADAY, UT 84124 (40.677703, -111.84254) | 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 );