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-03-23
This data as json, copyable, CSV (advanced)
Suggested facets: prvdr_state, ownership, nmbr_beds, Date First Approved to Provide Medicare and Medicaid services, Special Focus Status, Overall Rating, Overall Rating Footnote, Health Inspection Rating, Health Inspection Rating Footnote, QM Rating, QM Rating Footnote, Long-Stay QM Rating, Short-Stay QM Rating, Short-Stay QM Rating Footnote, Staffing Rating, Staffing Rating Footnote, RN Staffing Rating, RN Staffing Rating Footnote, 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 1 Health Revisit Score, Rating Cycle 2 Number of Standard 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 Total Number of Health Deficiencies, Rating Cycle 3 Number of Standard Health Deficiencies, Rating Cycle 3 Number of Complaint Health Deficiencies, Number of Facility Reported Incidents, Number of Fines, Total Amount of Fines in Dollars, Number of Payment Denials, Rating Cycle 3 Standard Health Survey Date (date)
Link | rowid ▼ | address | lat | lng | geocode_flag | geocode_accuracy | prvdr_nmbr | prvdr_nm | prvdr_add | prvdr_city | prvdr_state | prvdr_zip | prvdr_phn | prvdr_cnty | prvdr_cnty_name | ownership | nmbr_beds | avg_residents | prvdr_type | Provider Resides in Hospital | Legal Business Name | Date First Approved to Provide Medicare and Medicaid services | Continuing Care Retirement Community | Special Focus Status | Abuse Icon | Most Recent Health Inspection More Than 2 Years Ago | Provider Changed Ownership in Last 12 Months | With a Resident and Family Council | Automatic Sprinkler Systems in All Required Areas | Overall Rating | Overall Rating Footnote | Health Inspection Rating | Health Inspection Rating Footnote | QM Rating | QM Rating Footnote | Long-Stay QM Rating | Long-Stay QM Rating Footnote | Short-Stay QM Rating | Short-Stay QM Rating Footnote | Staffing Rating | Staffing Rating Footnote | RN Staffing Rating | RN Staffing Rating Footnote | Reported Staffing Footnote | Physical Therapist Staffing Footnote | Reported Nurse Aide Staffing Hours per Resident per Day | Reported LPN Staffing Hours per Resident per Day | Reported RN Staffing Hours per Resident per Day | Reported Licensed Staffing Hours per Resident per Day | Reported Total Nurse Staffing Hours per Resident per Day | Reported Physical Therapist Staffing Hours per Resident Per Day | Case-Mix Nurse Aide Staffing Hours per Resident per Day | Case-Mix LPN Staffing Hours per Resident per Day | Case-Mix RN Staffing Hours per Resident per Day | Case-Mix Total Nurse Staffing Hours per Resident per Day | Adjusted Nurse Aide Staffing Hours per Resident per Day | Adjusted LPN Staffing Hours per Resident per Day | Adjusted RN Staffing Hours per Resident per Day | Adjusted Total Nurse Staffing Hours per Resident per Day | Rating Cycle 1 Standard Survey Health Date | Rating Cycle 1 Total Number of Health Deficiencies | Rating Cycle 1 Number of Standard Health Deficiencies | Rating Cycle 1 Number of Complaint Health Deficiencies | Rating Cycle 1 Health Deficiency Score | Rating Cycle 1 Number of Health Revisits | Rating Cycle 1 Health Revisit Score | Rating Cycle 1 Total Health Score | Rating Cycle 2 Standard Health Survey Date | Rating Cycle 2 Total Number of Health Deficiencies | Rating Cycle 2 Number of Standard Health Deficiencies | Rating Cycle 2 Number of Complaint Health Deficiencies | Rating Cycle 2 Health Deficiency Score | Rating Cycle 2 Number of Health Revisits | Rating Cycle 2 Health Revisit Score | Rating Cycle 2 Total Health Score | Rating Cycle 3 Standard Health Survey Date | Rating Cycle 3 Total Number of Health Deficiencies | Rating Cycle 3 Number of Standard Health Deficiencies | Rating Cycle 3 Number of Complaint Health Deficiencies | Rating Cycle 3 Number of Health Revisits | Rating Cycle 3 Health Deficiency Score | Rating Cycle 3 Health Revisit Score | Rating Cycle 3 Total Health Score | Total Weighted Health Survey Score | Number of Facility Reported Incidents | Number of Substantiated Complaints | Number of Fines | Total Amount of Fines in Dollars | Number of Payment Denials | Total Number of Penalties | Location | Processing Date |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
188 | 188 | 3200 STATE ST SAGINAW, MI 48602 | 43.436632 | -83.985897 | 0 | 235250 | SAMARITAS SENIOR LIVING SAGINAW | 3200 STATE ST | SAGINAW | MI | 48602 | 9897991902 | 720 | Saginaw | Non profit - Church related | 98 | 58.8 | Medicare and Medicaid | false | SAMARITAS - LUTHERAN SOCIAL SERVICES OF MICHIGAN | 12/01/1975 | false | SFF Candidate | true | false | false | Resident | Yes | 1 | 1 | 2 | 1 | 4 | 3 | 2 | 2.56619 | 1.3568 | 0.44244 | 1.79924 | 4.36543 | 0.09823 | 2.135 | 0.79244 | 0.39171 | 3.31915 | 2.49808 | 1.28745 | 0.42513 | 4.21748 | 04/25/2019 | 30 | 17 | 14 | 307 | 1 | 0 | 307 | 06/06/2018 | 24 | 10 | 14 | 359 | 2 | 180 | 539 | 2017-03-23 | 25 | 15 | 11 | 1 | 188 | 0 | 188 | 364.5 | 28 | 39 | 5 | 191846.00 | 2 | 7 | 3200 STATE ST SAGINAW, MI 48602 (43.436632, -83.985897) | 02/01/2020 | ||||||||||
4145 | 4145 | 3322 SILVERSIDE ROAD WILMINGTON, DE 19810 | 39.808573 | -75.539564 | 0 | 85056 | CADIA REHABILITATION SILVERSIDE | 3322 SILVERSIDE ROAD | WILMINGTON | DE | 19810 | 3024788889 | 10 | New Castle | For profit - Corporation | 128 | 106.3 | Medicare and Medicaid | false | ONIX SILVERSIDE LLC | 12/05/2012 | false | true | false | false | Resident | Yes | 4 | 2 | 5 | 4 | 5 | 5 | 5 | 1.93136 | 0.7205 | 1.43767 | 2.15817 | 4.08953 | 0.19562 | 2.06908 | 0.77071 | 0.36637 | 3.20617 | 1.94 | 0.70295 | 1.47695 | 4.09016 | 06/25/2019 | 14 | 9 | 5 | 80 | 1 | 0 | 80 | 05/30/2018 | 19 | 19 | 0 | 88 | 1 | 0 | 88 | 2017-03-23 | 7 | 6 | 3 | 1 | 36 | 0 | 36 | 75.333 | 2 | 5 | 0 | 0.00 | 0 | 0 | 3322 SILVERSIDE ROAD WILMINGTON, DE 19810 (39.808573, -75.539564) | 02/01/2020 | |||||||||||
7472 | 7472 | 1400 POPLAR ST HANCOCK, MI 49930 | 47.14009 | -88.596793 | 0 | 235552 | THE LIGHTHOUSE AT HANCOCK HEALTH AND REHAB | 1400 POPLAR ST | HANCOCK | MI | 49930 | 9064826644 | 300 | Houghton | For profit - Corporation | 63 | 48 | Medicare and Medicaid | false | CYPRESS HEALTHCARE, LLC | 07/01/1994 | false | true | false | false | Resident | Yes | 2 | 1 | 2 | 1 | 2 | 4 | 5 | 2.26118 | 0.43116 | 0.94938 | 1.38053 | 3.64172 | 0.01518 | 2.00313 | 0.6466 | 0.29023 | 2.93996 | 2.34608 | 0.5014 | 1.23121 | 3.97208 | 04/02/2019 | 23 | 23 | 0 | 286 | 1 | 0 | 286 | 06/12/2018 | 14 | 11 | 5 | 92 | 1 | 0 | 92 | 2017-03-23 | 11 | 6 | 5 | 1 | 44 | 0 | 44 | 181 | 6 | 8 | 0 | 0.00 | 1 | 1 | 1400 POPLAR ST HANCOCK, MI 49930 (47.14009, -88.596793) | 02/01/2020 | |||||||||||
8328 | 8328 | 414 E STATE ST BELDING, MI 48809 | 43.08898 | -85.224083 | 0 | 235357 | METRON OF BELDING | 414 E STATE ST | BELDING | MI | 48809 | 6167940460 | 330 | Ionia | For profit - Corporation | 128 | 107.9 | Medicare and Medicaid | false | BELDING CHRISTIAN NURSING HOME, INC | 07/01/1978 | false | SFF | true | false | false | Resident | Yes | 18 | 18 | 18 | 18 | 18 | 18 | 18 | 2.27042 | 0.42678 | 0.92141 | 1.34819 | 3.61861 | 0.02103 | 1.96371 | 0.62841 | 0.28855 | 2.88066 | 2.40295 | 0.51068 | 1.2019 | 4.02813 | 07/11/2019 | 17 | 9 | 9 | 171 | 1 | 0 | 171 | 06/18/2018 | 55 | 30 | 25 | 2207 | 2 | 1104 | 3311 | 2017-03-23 | 25 | 17 | 12 | 1 | 425 | 0 | 425 | 1260 | 78 | 32 | 2 | 153692.00 | 2 | 4 | 414 E STATE ST BELDING, MI 48809 (43.08898, -85.224083) | 02/01/2020 | ||||||||||
11576 | 11576 | 1000 COLLEGE STREET WILKESBORO, NC 28697 | 36.141365 | -81.166265 | 0 | 345133 | CURIS AT WILKESBORO TRANSITIONAL CARE & REHAB CNTR | 1000 COLLEGE STREET | WILKESBORO | NC | 28697 | 3368384141 | 960 | Wilkes | For profit - Limited Liability company | 120 | 87.3 | Medicare and Medicaid | false | CURIS AT WILKESBORO OPCO LLC | 12/01/1974 | false | true | false | false | Resident | Yes | 1 | 1 | 3 | 2 | 4 | 3 | 3 | 2.15934 | 0.4343 | 0.71771 | 1.15201 | 3.31135 | 0.00575 | 1.94904 | 0.74922 | 0.372 | 3.07026 | 2.30259 | 0.43587 | 0.72618 | 3.45847 | 04/11/2019 | 6 | 3 | 3 | 99 | 1 | 0 | 99 | 05/05/2018 | 12 | 12 | 5 | 84 | 1 | 0 | 84 | 2017-03-23 | 7 | 7 | 0 | 1 | 32 | 0 | 32 | 82.833 | 2 | 6 | 2 | 209684.00 | 1 | 3 | 1000 COLLEGE STREET WILKESBORO, NC 28697 (36.141365, -81.166265) | 02/01/2020 | |||||||||||
11611 | 11611 | 710 15-401 BYPASS BENNETTSVILLE, SC 29512 | 34.60693 | -79.713207 | 0 | 425118 | DUNDEE MANOR, LLC | 710 15-401 BYPASS, WEST | BENNETTSVILLE | SC | 29512 | 8434796251 | 340 | Marlboro | For profit - Corporation | 110 | 103 | Medicare and Medicaid | false | DUNDEE MANOR, LLC | 07/01/1978 | false | true | false | false | Resident | Yes | 1 | 1 | 2 | 4 | 1 | 2 | 2 | 2.185 | 1.12588 | 0.26232 | 1.3882 | 3.5732 | 0.04585 | 2.03343 | 0.66532 | 0.28846 | 2.98721 | 2.23325 | 1.27247 | 0.34228 | 3.8357 | 09/19/2019 | 5 | 5 | 0 | 64 | 2 | 32 | 96 | 07/13/2018 | 10 | 10 | 0 | 44 | 1 | 0 | 44 | 2017-03-23 | 23 | 12 | 11 | 1 | 244 | 0 | 244 | 103.333 | 0 | 1 | 4 | 38300.00 | 2 | 6 | 710 15-401 BYPASS BENNETTSVILLE, SC 29512 (34.60693, -79.713207) | 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 );