nh_gen_info_geocoded_final
Data source: Big Local News · About: big-local-datasette
6 rows where Number of Fines = 7
This data as json, copyable, CSV (advanced)
Suggested facets: geocode_flag, geocode_accuracy, prvdr_state, prvdr_cnty, prvdr_cnty_name, ownership, Abuse Icon, With a Resident and Family Council, Overall Rating, 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, Rating Cycle 1 Number of Complaint Health Deficiencies, Rating Cycle 2 Total Number of Health Deficiencies, Rating Cycle 2 Number of Standard Health Deficiencies, Rating Cycle 3 Number of Health Revisits, Rating Cycle 3 Health Revisit Score, Number of Substantiated Complaints, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3050 | 3050 | 1069 BALLENGER HWY FLINT, MI 48504 | 43.018281 | -83.734828 | 0 | 235343 | KITH HAVEN | G 1069 BALLENGER HWY | FLINT | MI | 48504 | 8102356676 | 240 | Genesee | For profit - Corporation | 159 | 126.2 | Medicare and Medicaid | false | KITH HAVEN ACQUISITION COMPANY, LLC | 10/01/1977 | false | false | false | false | Resident | Yes | 1 | 1 | 4 | 5 | 3 | 3 | 3 | 2.52311 | 0.81613 | 0.51072 | 1.32685 | 3.84997 | 0.03016 | 2.08647 | 0.67081 | 0.2828 | 3.04008 | 2.51328 | 0.91483 | 0.67974 | 4.06093 | 10/17/2019 | 14 | 10 | 5 | 100 | 1 | 0 | 100 | 10/22/2018 | 35 | 14 | 22 | 343 | 1 | 0 | 343 | 2017-08-23 | 11 | 9 | 4 | 1 | 88 | 0 | 88 | 179 | 19 | 30 | 7 | 162552.00 | 0 | 7 | 1069 BALLENGER HWY FLINT, MI 48504 (43.018281, -83.734828) | 02/01/2020 | |||||||||||
5428 | 5428 | 6535 DRAKE ROAD WEST BLOOMFIELD, MI 48322 | 42.540603 | -83.399923 | 0 | 235663 | NOTTING HILL OF WEST BLOOMFIELD | 6535 DRAKE ROAD | WEST BLOOMFIELD | MI | 48322 | 2485922000 | 620 | Oakland | For profit - Individual | 118 | 112.1 | Medicare and Medicaid | false | MAPLE-DRAKE REAL ESTATE, LLC | 05/30/2013 | false | false | false | false | Resident | Yes | 2 | 2 | 4 | 3 | 4 | 3 | 3 | 1.88439 | 1.57753 | 0.57062 | 2.14815 | 4.03255 | 0.18071 | 2.21128 | 0.78473 | 0.37176 | 3.36776 | 1.7711 | 1.51162 | 0.57773 | 3.83965 | 07/29/2019 | 23 | 14 | 13 | 164 | 1 | 0 | 164 | 04/05/2018 | 16 | 6 | 10 | 152 | 1 | 0 | 152 | 2017-03-02 | 22 | 17 | 8 | 1 | 124 | 0 | 124 | 153.333 | 9 | 31 | 7 | 96031.00 | 0 | 7 | 6535 DRAKE ROAD WEST BLOOMFIELD, MI 48322 (42.540603, -83.399923) | 02/01/2020 | |||||||||||
6524 | 6524 | 535 N MAIN CLAWSON, MI 48017 | 42.537507 | -83.146513 | 0 | 235214 | CAMBRIDGE NORTH HEALTHCARE CENTER | 535 N MAIN | CLAWSON | MI | 48017 | 2484355200 | 620 | Oakland | For profit - Corporation | 120 | 94.8 | Medicare and Medicaid | false | SSC CLAWSON OPERATING COMPANY LLC | 10/08/1971 | false | false | false | false | Resident | Yes | 1 | 1 | 4 | 5 | 4 | 1 | 12 | 1 | 12 | 2.15528 | 1.17212 | 0.26557 | 1.43769 | 3.59297 | 0.08358 | 2.08638 | 0.73739 | 0.34536 | 3.16913 | 2.14697 | 1.19525 | 0.28943 | 3.63552 | 10/29/2018 | 27 | 18 | 12 | 400 | 1 | 0 | 400 | 08/10/2017 | 19 | 13 | 6 | 247 | 1 | 0 | 247 | 2016-07-20 | 23 | 12 | 11 | 2 | 227 | 114 | 341 | 339.167 | 10 | 30 | 7 | 295273.00 | 1 | 8 | 535 N MAIN CLAWSON, MI 48017 (42.537507, -83.146513) | 02/01/2020 | |||||||||
7288 | 7288 | 915 N RIVER RD SAGINAW, MI 48609 | 43.422068 | -84.052128 | 0 | 235249 | ST FRANCIS HOME | 915 N RIVER RD | SAGINAW | MI | 48609 | 9897813150 | 720 | Saginaw | Non profit - Church related | 94 | 74.3 | Medicare and Medicaid | false | ST. FRANCIS HOME OF SAGINAW | 09/01/1975 | false | false | false | false | Both | Yes | 2 | 1 | 5 | 4 | 5 | 4 | 3 | 3.21364 | 0.99462 | 0.65291 | 1.64753 | 4.86117 | 0.0586 | 2.2035 | 0.72612 | 0.35046 | 3.28008 | 3.0311 | 1.02999 | 0.7012 | 4.75236 | 05/03/2019 | 18 | 13 | 5 | 251 | 1 | 0 | 251 | 04/26/2018 | 16 | 11 | 5 | 156 | 1 | 0 | 156 | 2017-06-08 | 46 | 22 | 25 | 2 | 385 | 193 | 578 | 273.833 | 22 | 16 | 7 | 173591.00 | 1 | 8 | 915 N RIVER RD SAGINAW, MI 48609 (43.422068, -84.052128) | 02/01/2020 | |||||||||||
11579 | 11579 | 6021 N Lidgerwood St, Spokane, WA 99208, USA | 47.712626 | -117.4066066 | 1 | ROOFTOP | 505024 | FRANKLIN HILLS HEALTH & REHAB CENTER | 6021 NORTH LIDGERWOOD | SPOKANE | WA | 99207 | 5094893323 | 310 | Spokane | For profit - Corporation | 100 | 65.9 | Medicare and Medicaid | false | FRANKLIN HILLS HEALTH - SPOKANE, LLC | 01/01/1967 | false | false | false | false | Resident | Yes | 2 | 1 | 3 | 2 | 3 | 4 | 4 | 2.45496 | 0.3699 | 0.9357 | 1.3056 | 3.76056 | 0.1215 | 2.08737 | 0.78382 | 0.38687 | 3.25806 | 2.44433 | 0.35486 | 0.91034 | 3.70123 | 12/11/2018 | 49 | 28 | 23 | 367 | 1 | 0 | 367 | 10/17/2017 | 30 | 12 | 18 | 264 | 1 | 0 | 264 | 2016-09-21 | 41 | 23 | 18 | 1 | 295 | 0 | 295 | 320.667 | 29 | 35 | 7 | 154086.00 | 0 | 7 | 02/01/2020 | |||||||||||
15382 | 15382 | 153 JOHNS COURT SHELTON, WA 98584 | 47.233785 | -123.109373 | 0 | 505507 | SHELTON HEALTH & REHAB CENTER | 153 JOHNS COURT | SHELTON | WA | 98584 | 3604272575 | 220 | Mason | For profit - Corporation | 76 | 63.4 | Medicare and Medicaid | false | EVERGREEN AT SHELTON, L.L.C. | 02/12/1999 | false | true | false | false | Resident | Yes | 2 | 1 | 2 | 1 | 4 | 4 | 4 | 2.15906 | 0.72361 | 0.94307 | 1.66668 | 3.82574 | 0.09301 | 2.11376 | 0.78464 | 0.39686 | 3.29527 | 2.12287 | 0.69346 | 0.89441 | 3.72287 | 05/10/2019 | 54 | 30 | 28 | 432 | 1 | 0 | 432 | 05/23/2018 | 27 | 13 | 14 | 236 | 1 | 0 | 236 | 2017-06-28 | 19 | 14 | 6 | 1 | 160 | 0 | 160 | 321.333 | 27 | 17 | 7 | 126343.00 | 0 | 7 | 153 JOHNS COURT SHELTON, WA 98584 (47.233785, -123.109373) | 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 );