nh_gen_info_geocoded_final
Data source: Big Local News · About: big-local-datasette
8 rows where Abuse Icon = "true" and "Rating Cycle 3 Standard Health Survey Date" is on date 2017-09-14
This data as json, copyable, CSV (advanced)
Suggested facets: geocode_flag, geocode_accuracy, prvdr_state, ownership, Continuing Care Retirement Community, Special Focus Status, Overall Rating, 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 Number of Standard Health Deficiencies, Rating Cycle 1 Number of Complaint Health Deficiencies, Rating Cycle 1 Number of Health Revisits, Rating Cycle 2 Total Number of Health Deficiencies, Rating Cycle 2 Number of Complaint Health Deficiencies, Rating Cycle 2 Number of Health Revisits, Rating Cycle 2 Health Revisit Score, 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, Number of Facility Reported Incidents, Number of Fines, Total Amount of Fines in Dollars, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
214 | 214 | 1100 TEXAS AVE DEER LODGE, MT 59722 | 46.391232 | -112.720933 | 0 | 275134 | DEER LODGE | 1100 TEXAS AVE | DEER LODGE | MT | 59722 | 4068461655 | 380 | Powell | For profit - Corporation | 60 | 47.8 | Medicare and Medicaid | false | 1100 TEXAS AVENUE OPERATIONS LLC | 10/01/1989 | false | true | false | false | Resident | Yes | 1 | 1 | 3 | 3 | 2 | 3 | 3 | 1.78565 | 0.84876 | 0.41694 | 1.2657 | 3.05135 | 0.02 | 1.80882 | 0.64923 | 0.29513 | 2.75318 | 2.05172 | 0.98304 | 0.53172 | 3.55395 | 10/17/2019 | 7 | 7 | 1 | 64 | 1 | 0 | 64 | 09/20/2018 | 5 | 5 | 0 | 44 | 1 | 0 | 44 | 2017-09-14 | 19 | 4 | 16 | 1 | 854 | 0 | 854 | 189 | 2 | 31 | 3 | 721513.00 | 0 | 3 | 1100 TEXAS AVE DEER LODGE, MT 59722 (46.391232, -112.720933) | 02/01/2020 | |||||||||||
1416 | 1416 | 1601 PETERSEN AVENUE SAN JOSE, CA 95129 | 37.294157 | -121.998841 | 0 | 55750 | AMBERWOOD GARDENS | 1601 PETERSEN AVENUE | SAN JOSE | CA | 95129 | 4082537502 | 530 | Santa Clara | For profit - Corporation | 258 | 237.7 | Medicare and Medicaid | false | WESTGATE PREMIER HEALTHCARE SERVICES, INC. | 07/01/1978 | false | true | false | false | Resident | Yes | 1 | 1 | 4 | 5 | 3 | 3 | 3 | 2.79717 | 1.23179 | 0.76219 | 1.99398 | 4.79115 | 0.02805 | 2.26435 | 0.7416 | 0.53734 | 3.54329 | 2.56738 | 1.24897 | 0.53389 | 4.33597 | 09/13/2019 | 21 | 12 | 9 | 96 | 1 | 0 | 96 | 09/14/2018 | 31 | 21 | 10 | 188 | 1 | 0 | 188 | 2017-09-14 | 21 | 17 | 6 | 1 | 112 | 0 | 112 | 129.333 | 12 | 18 | 3 | 26068.00 | 0 | 3 | 1601 PETERSEN AVENUE SAN JOSE, CA 95129 (37.294157, -121.998841) | 02/01/2020 | |||||||||||
1689 | 1689 | 5888 N Ridge Ave, Chicago, IL 60660, USA | 41.9888142 | -87.6689396 | 1 | ROOFTOP | 145765 | PARK VIEW REHAB CENTER | 5888 NORTH RIDGE | CHICAGO | IL | 60660 | 7737692626 | 141 | Cook | For profit - Partnership | 128 | 120.7 | Medicare and Medicaid | false | PARK VIEW REHAB CENTER, LLC | 12/01/1993 | false | true | false | false | Resident | Yes | 1 | 2 | 1 | 3 | 1 | 2 | 2 | 1.2933 | 0.48066 | 0.36202 | 0.84268 | 2.13598 | 0.04343 | 1.85392 | 0.79482 | 0.41339 | 3.06213 | 1.44986 | 0.45473 | 0.32961 | 2.23679 | 08/22/2019 | 12 | 8 | 4 | 68 | 1 | 0 | 68 | 10/03/2018 | 14 | 9 | 5 | 108 | 1 | 0 | 108 | 2017-09-14 | 13 | 11 | 2 | 1 | 112 | 0 | 112 | 88.667 | 0 | 16 | 0 | 0.00 | 0 | 0 | 02/01/2020 | |||||||||||
2692 | 2692 | 1925 SOUTH MAIN STREET BLOOMINGTON, IL 61701 | 40.455941 | -88.99273 | 0 | 145610 | BLOOMINGTON REHABILITATION & HCC | 1925 SOUTH MAIN STREET | BLOOMINGTON | IL | 61701 | 3098294348 | 650 | Mc Lean | For profit - Corporation | 78 | 47.3 | Medicare and Medicaid | false | PETERSEN HEALTH OPERATIONS LLC | 03/22/1989 | false | SFF Candidate | true | false | false | Resident | Yes | 1 | 1 | 3 | 3 | 2 | 2 | 3 | 1.88046 | 0.38587 | 0.563 | 0.94887 | 2.82934 | 0.01934 | 2.11825 | 0.7605 | 0.34248 | 3.22123 | 1.84503 | 0.38153 | 0.61874 | 2.81654 | 08/08/2019 | 33 | 4 | 29 | 184 | 1 | 0 | 184 | 10/26/2018 | 35 | 8 | 27 | 176 | 1 | 0 | 176 | 2017-09-14 | 24 | 11 | 13 | 2 | 188 | 94 | 282 | 197.667 | 2 | 32 | 2 | 14047.00 | 0 | 2 | 1925 SOUTH MAIN STREET BLOOMINGTON, IL 61701 (40.455941, -88.99273) | 02/01/2020 | ||||||||||
4879 | 4879 | 2121 RAYBROOK SE GRAND RAPIDS, MI 49546 | 42.922833 | -85.58813 | 0 | 235440 | HOLLAND HOME - RAYBROOK MANOR | 2121 RAYBROOK SE | GRAND RAPIDS | MI | 49546 | 6162355702 | 400 | Kent | Non profit - Corporation | 101 | 93.5 | Medicare and Medicaid | false | HOLLAND HOME | 09/01/1985 | true | true | false | false | Resident | Yes | 4 | 2 | 5 | 5 | 5 | 4 | 4 | 2.69611 | 0.88565 | 0.7385 | 1.62414 | 4.32025 | 0.02041 | 2.16388 | 0.67301 | 0.28858 | 3.12546 | 2.58952 | 0.98952 | 0.96321 | 4.43249 | 11/06/2019 | 5 | 3 | 2 | 103 | 1 | 0 | 103 | 08/23/2018 | 7 | 6 | 1 | 60 | 1 | 0 | 60 | 2017-09-14 | 14 | 14 | 0 | 1 | 100 | 0 | 100 | 88.167 | 5 | 3 | 1 | 9100.00 | 1 | 2 | 2121 RAYBROOK SE GRAND RAPIDS, MI 49546 (42.922833, -85.58813) | 02/01/2020 | |||||||||||
5906 | 5906 | 2850 RUBY VISTA DRIVE ELKO, NV 89801 | 40.858758 | -115.745547 | 0 | 295078 | HIGHLAND MANOR OF ELKO | 2850 RUBY VISTA DRIVE | ELKO | NV | 89801 | 7757535500 | 30 | Elko | Non profit - Corporation | 112 | 103.3 | Medicare and Medicaid | false | DESERT HEALTH CARE FACILITIES INC | 02/16/2001 | false | true | false | false | Resident | Yes | 3 | 2 | 4 | 5 | 3 | 4 | 4 | 2.24774 | 0.53938 | 0.69742 | 1.2368 | 3.48453 | 0.03633 | 2.08251 | 0.71907 | 0.31183 | 3.11341 | 2.24324 | 0.56403 | 0.8418 | 3.5889 | 06/24/2019 | 16 | 16 | 0 | 72 | 1 | 0 | 72 | 06/21/2018 | 12 | 11 | 2 | 68 | 1 | 0 | 68 | 2017-09-14 | 10 | 10 | 0 | 1 | 84 | 0 | 84 | 72.667 | 0 | 2 | 0 | 0.00 | 0 | 0 | 2850 RUBY VISTA DRIVE ELKO, NV 89801 (40.858758, -115.745547) | 02/01/2020 | |||||||||||
6598 | 6598 | 16391 ROTUNDA DR DEARBORN, MI 48120 | 42.302155 | -83.196574 | 0 | 235502 | BEAUMONT REHABILITATION & CONTINUING CARE DEARBORN | 16391 ROTUNDA DR | DEARBORN | MI | 48120 | 3132539700 | 810 | Wayne | Non profit - Corporation | 196 | 129.1 | Medicare and Medicaid | false | OAKWOOD HEALTH PROMOTIONS, INC. | 04/12/1991 | true | true | false | false | Resident | Yes | 3 | 2 | 5 | 5 | 5 | 3 | 3 | 2.08886 | 1.67552 | 0.65135 | 2.32687 | 4.41573 | 0.10153 | 2.106 | 0.79684 | 0.39412 | 3.29697 | 2.06142 | 1.5811 | 0.62203 | 4.29478 | 09/19/2019 | 1 | 0 | 1 | 20 | 0 | 0 | 20 | 10/17/2018 | 7 | 7 | 1 | 190 | 1 | 0 | 190 | 2017-09-14 | 16 | 14 | 2 | 1 | 108 | 0 | 108 | 91.333 | 3 | 8 | 2 | 32847.00 | 0 | 2 | 16391 ROTUNDA DR DEARBORN, MI 48120 (42.302155, -83.196574) | 02/01/2020 | |||||||||||
6967 | 6967 | 2490 COURT STREET REDDING, CA 96001 | 40.573276 | -122.392223 | 0 | 56258 | WINDSOR REDDING CARE CENTER | 2490 COURT STREET | REDDING | CA | 96001 | 5302460600 | 550 | Shasta | For profit - Limited Liability company | 113 | 94.5 | Medicare and Medicaid | false | Legal Business Name Not Available | 01/02/1973 | false | true | false | false | Resident | Yes | 2 | 1 | 5 | 5 | 5 | 3 | 2 | 2.4941 | 1.09599 | 0.40705 | 1.50304 | 3.99714 | 0.07745 | 2.04377 | 0.69904 | 0.3346 | 3.07742 | 2.53628 | 1.17892 | 0.45787 | 4.165 | 10/30/2019 | 31 | 4 | 31 | 168 | 1 | 0 | 168 | 09/13/2018 | 36 | 27 | 11 | 204 | 2 | 102 | 306 | 2017-09-14 | 30 | 20 | 11 | 1 | 184 | 0 | 184 | 216.667 | 38 | 27 | 1 | 10400.00 | 1 | 2 | 2490 COURT STREET REDDING, CA 96001 (40.573276, -122.392223) | 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 );