nh_gen_info_geocoded_final
Data source: Big Local News · About: big-local-datasette
6 rows where Abuse Icon = "true" and "Rating Cycle 3 Standard Health Survey Date" is on date 2017-07-20
This data as json, copyable, CSV (advanced)
Suggested facets: prvdr_state, ownership, Provider Resides in Hospital, Continuing Care Retirement Community, Special Focus Status, Overall Rating, Health Inspection Rating, QM Rating, Long-Stay QM Rating, Long-Stay QM Rating Footnote, Short-Stay QM Rating, Staffing Rating, RN Staffing Rating, Rating Cycle 1 Number of Standard Health Deficiencies, Rating Cycle 1 Number of Health Revisits, Rating Cycle 1 Health Revisit Score, Rating Cycle 2 Number of Standard Health Deficiencies, Rating Cycle 2 Number of Complaint 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 Total Health Score, Number of Facility Reported Incidents, Number of Fines, Number of Payment Denials, Total Number of Penalties, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2067 | 2067 | 3520 KENNETH DRIVE MACON, GA 31206 | 32.795431 | -83.695568 | 0 | 115652 | CHERRY BLOSSOM HEALTH AND REHABILITATION | 3520 KENNETH DRIVE | MACON | GA | 31206 | 4787817553 | 90 | Bibb | Non profit - Other | 82 | 72 | Medicare and Medicaid | false | CHERRY BLOSSOM HEALTH CARE CENTER LLC | 02/01/1998 | false | true | false | false | Resident | Yes | 1 | 1 | 2 | 3 | 2 | 2 | 2 | 1.88059 | 1.04064 | 0.35181 | 1.39246 | 3.27305 | 0.06936 | 2.15176 | 0.78166 | 0.37672 | 3.31014 | 1.81642 | 1.00108 | 0.35149 | 3.17073 | 12/05/2019 | 9 | 2 | 7 | 199 | 1 | 0 | 199 | 07/26/2018 | 3 | 3 | 0 | 16 | 1 | 0 | 16 | 2017-07-20 | 2 | 2 | 0 | 1 | 32 | 0 | 32 | 110.167 | 0 | 4 | 1 | 13905.00 | 0 | 1 | 3520 KENNETH DRIVE MACON, GA 31206 (32.795431, -83.695568) | 02/01/2020 | |||||||||||
6382 | 6382 | 14900 MIDDLEBELT RD LIVONIA, MI 48154 | 42.394064 | -83.334268 | 0 | 235479 | REGENCY AT LIVONIA | 14900 MIDDLEBELT RD | LIVONIA | MI | 48154 | 7344254200 | 810 | Wayne | For profit - Corporation | 142 | 123.6 | Medicare and Medicaid | false | MIDDLEBELT HOPE ACQUISTION COMPANY INC | 01/06/1989 | false | true | false | false | Resident | Yes | 3 | 2 | 5 | 5 | 5 | 2 | 2 | 1.84955 | 0.87591 | 0.4075 | 1.28341 | 3.13296 | 0.07253 | 2.12861 | 0.70427 | 0.31301 | 3.14589 | 1.80586 | 0.93521 | 0.49 | 3.19348 | 08/28/2019 | 16 | 10 | 6 | 124 | 1 | 0 | 124 | 09/27/2018 | 12 | 10 | 5 | 112 | 1 | 0 | 112 | 2017-07-20 | 19 | 13 | 9 | 1 | 128 | 0 | 128 | 120.667 | 8 | 19 | 4 | 85444.00 | 0 | 4 | 14900 MIDDLEBELT RD LIVONIA, MI 48154 (42.394064, -83.334268) | 02/01/2020 | |||||||||||
7210 | 7210 | 415 COOK SPRINGS PELL CITY, AL 35125 | 33.593208 | -86.398024 | 0 | 15195 | VILLAGE AT COOK SPRINGS SKILLED NURSING FACILITY | 415 COOK SPRINGS | PELL CITY | AL | 35125 | 2053382221 | 570 | St. Clair | Non profit - Corporation | 168 | 147.1 | Medicare and Medicaid | false | VILLAGE AT COOK SPRINGS, LLC | 12/01/1977 | true | SFF Candidate | true | false | false | Resident | Yes | 2 | 1 | 4 | 4 | 5 | 4 | 4 | 2.33117 | 0.81728 | 0.66763 | 1.4849 | 3.81608 | 0.01572 | 2.00682 | 0.67553 | 0.31048 | 2.99283 | 2.41425 | 0.90972 | 0.80935 | 4.08873 | 07/28/2019 | 5 | 5 | 4 | 208 | 2 | 104 | 312 | 08/16/2018 | 10 | 5 | 5 | 132 | 1 | 0 | 132 | 2017-07-20 | 8 | 8 | 0 | 1 | 44 | 0 | 44 | 207.333 | 0 | 5 | 2 | 619290.00 | 1 | 3 | 415 COOK SPRINGS PELL CITY, AL 35125 (33.593208, -86.398024) | 02/01/2020 | ||||||||||
7529 | 7529 | 2990 EAST RAMON ROAD PALM SPRINGS, CA 92264 | 33.815896 | -116.513422 | 0 | 56328 | PREMIER CARE CENTER FOR PALM SPRINGS | 2990 EAST RAMON ROAD | PALM SPRINGS | CA | 92264 | 7603232638 | 430 | Riverside | For profit - Individual | 99 | 87.7 | Medicare and Medicaid | false | ENSIGN PALM I LLC | 12/26/1973 | false | true | false | false | Resident | Yes | 2 | 2 | 4 | 5 | 4 | 2 | 2 | 2.25399 | 1.36159 | 0.32269 | 1.68428 | 3.93827 | 0.0734 | 2.12703 | 0.76457 | 0.35473 | 3.24633 | 2.20239 | 1.3391 | 0.34238 | 3.89015 | 05/16/2019 | 25 | 16 | 9 | 128 | 1 | 0 | 128 | 06/29/2018 | 19 | 9 | 10 | 92 | 1 | 0 | 92 | 2017-07-20 | 20 | 8 | 12 | 1 | 88 | 0 | 88 | 109.333 | 19 | 17 | 0 | 0.00 | 0 | 0 | 2990 EAST RAMON ROAD PALM SPRINGS, CA 92264 (33.815896, -116.513422) | 02/01/2020 | |||||||||||
11834 | 11834 | 9969 OLD HWY 70 RD MINOCQUA, WI 54548 | 45.883372 | -89.733789 | 0 | 525678 | AVANTI HEALTH AND REHABILITATION CENTER, LLC | 9969 OLD HWY 70 RD | MINOCQUA | WI | 54548 | 7153566016 | 420 | Oneida | For profit - Partnership | 72 | 55.6 | Medicare and Medicaid | false | AVANTI HEALTH AND REHABILITATION CENTER LLC | 07/09/2004 | false | true | false | false | Resident | Yes | 3 | 2 | 3 | 3 | 3 | 4 | 5 | 2.17848 | 0.38561 | 1.09205 | 1.47766 | 3.65614 | 0.11507 | 2.1485 | 0.78372 | 0.36773 | 3.29996 | 2.10734 | 0.36997 | 1.11774 | 3.55278 | 10/09/2019 | 6 | 5 | 1 | 56 | 1 | 0 | 56 | 08/27/2018 | 5 | 5 | 0 | 99 | 1 | 0 | 99 | 2017-07-20 | 5 | 5 | 5 | 1 | 36 | 0 | 36 | 67 | 1 | 2 | 1 | 11050.00 | 0 | 1 | 9969 OLD HWY 70 RD MINOCQUA, WI 54548 (45.883372, -89.733789) | 02/01/2020 | |||||||||||
13024 | 13024 | 2801 EUREKA WAY REDDING, CA 96001 | 40.585677 | -122.414102 | 0 | 555588 | VIBRA HOSPITAL OF NORTHERN CALIFORNIA D/P SNF | 2801 EUREKA WAY | REDDING | CA | 96001 | 5302454112 | 550 | Shasta | For profit - Corporation | 32 | 29.1 | Medicare and Medicaid | true | NORTHERN CALIFORNIA REHABILITATION HOSPITAL LLC | 02/03/1994 | false | true | false | false | Resident | Yes | 3 | 2 | 4 | 2 | 4 | 4 | 4 | 2.66225 | 2.40935 | 1.32552 | 3.73488 | 6.39712 | 0.41625 | 1.97484 | 0.96198 | 0.54767 | 3.48448 | 2.80177 | 1.8833 | 0.91097 | 5.88708 | 07/12/2019 | 11 | 9 | 2 | 68 | 1 | 0 | 68 | 07/12/2018 | 17 | 11 | 6 | 84 | 1 | 0 | 84 | 2017-07-20 | 6 | 6 | 0 | 1 | 36 | 0 | 36 | 68 | 5 | 3 | 1 | 10000.00 | 1 | 2 | 2801 EUREKA WAY REDDING, CA 96001 (40.585677, -122.414102) | 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 );