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-08-30
This data as json, copyable, CSV (advanced)
Suggested facets: prvdr_state, prvdr_cnty, ownership, prvdr_type, Date First Approved to Provide Medicare and Medicaid services, 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, Staffing Rating Footnote, RN Staffing Rating, RN Staffing Rating Footnote, Reported Staffing Footnote, Physical Therapist Staffing Footnote, 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 Number of Health Revisits, Rating Cycle 1 Health Revisit Score, Rating Cycle 2 Number of Health Revisits, Rating Cycle 3 Number of Complaint Health Deficiencies, Rating Cycle 3 Number of Health Revisits, Rating Cycle 3 Health Revisit Score, Number of Facility Reported Incidents, Number of Substantiated Complaints, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
347 | 347 | 3860 DOBIE RD OKEMOS, MI 48864 | 42.692251 | -84.410335 | 0 | 235015 | INGHAM COUNTY MEDICAL CARE FAC | 3860 DOBIE RD | OKEMOS | MI | 48864 | 5173816100 | 320 | Ingham | Government - County | 236 | 215.7 | Medicare and Medicaid | false | INGHAM COUNTY MEDICAL CARE FACILITY | 01/01/1967 | false | true | false | false | Resident | Yes | 4 | 2 | 5 | 5 | 4 | 5 | 5 | 3.27177 | 0.856 | 0.87704 | 1.73303 | 5.0048 | 0.05442 | 2.03655 | 0.65483 | 0.28873 | 2.98011 | 3.3389 | 0.98293 | 1.1433 | 5.38527 | 11/13/2019 | 10 | 7 | 3 | 68 | 1 | 0 | 68 | 12/18/2018 | 11 | 9 | 5 | 68 | 1 | 0 | 68 | 2017-08-30 | 9 | 9 | 2 | 2 | 100 | 50 | 150 | 81.667 | 11 | 12 | 3 | 63642.00 | 1 | 4 | 3860 DOBIE RD OKEMOS, MI 48864 (42.692251, -84.410335) | 02/01/2020 | |||||||||||
699 | 699 | 21630 HESSEL DETROIT, MI 48219 | 42.441622 | -83.257194 | 0 | 235475 | BEACONSHIRE NURSING CENTRE | 21630 HESSEL | DETROIT | MI | 48219 | 3135348400 | 810 | Wayne | For profit - Corporation | 99 | 79.7 | Medicare and Medicaid | false | NORTHWEST PARTNERS, LLC | 08/10/1988 | false | true | false | false | Resident | Yes | 1 | 2 | 1 | 1 | 1 | 1 | 12 | 1 | 12 | 1.39446 | 1.10609 | 0.17509 | 1.28118 | 2.67564 | 0.0126 | 1.9008 | 0.61795 | 0.26369 | 2.78245 | 1.5247 | 1.34591 | 0.24992 | 3.08357 | 06/04/2019 | 13 | 9 | 4 | 119 | 1 | 0 | 119 | 09/12/2018 | 16 | 11 | 6 | 238 | 1 | 0 | 238 | 2017-08-30 | 8 | 7 | 1 | 1 | 96 | 0 | 96 | 154.833 | 6 | 11 | 1 | 11161.00 | 1 | 2 | 21630 HESSEL DETROIT, MI 48219 (42.441622, -83.257194) | 02/01/2020 | |||||||||
6772 | 6772 | 2400 PORTAGE ST KALAMAZOO, MI 49001 | 42.266639 | -85.56998 | 0 | 235050 | HAROLD AND GRACE UPJOHN COMMUNITY CARE CENTER | 2400 PORTAGE ST | KALAMAZOO | MI | 49001 | 2693814290 | 380 | Kalamazoo | Non profit - Corporation | 90 | 81.6 | Medicare and Medicaid | false | HAROLD AND GRACE UPJOHN COMMUNITY CARE CENTER | 01/01/1967 | true | true | false | false | Resident | Yes | 3 | 2 | 4 | 4 | 5 | 5 | 5 | 2.44436 | 0.82994 | 1.14888 | 1.97882 | 4.42318 | 0.10394 | 2.1954 | 0.71993 | 0.36918 | 3.28451 | 2.31402 | 0.86684 | 1.17131 | 4.31835 | 12/19/2019 | 15 | 12 | 3 | 100 | 0 | 0 | 100 | 09/28/2018 | 20 | 6 | 14 | 206 | 1 | 0 | 206 | 2017-08-30 | 18 | 12 | 6 | 1 | 116 | 0 | 116 | 138 | 26 | 35 | 1 | 75036.00 | 0 | 1 | 2400 PORTAGE ST KALAMAZOO, MI 49001 (42.266639, -85.56998) | 02/01/2020 | |||||||||||
8411 | 8411 | 1330 GRAND POINTE COURT GRAND BLANC, MI 48439 | 42.941165 | -83.679015 | 0 | 235666 | REGENCY AT GRAND BLANC | 1330 GRAND POINTE COURT | GRAND BLANC | MI | 48439 | 8106958920 | 240 | Genesee | For profit - Corporation | 138 | 130.4 | Medicare and Medicaid | false | GRAND BLANC CARE CENTER LLC | 07/26/2013 | false | true | false | false | Resident | Yes | 4 | 2 | 5 | 5 | 5 | 4 | 4 | 2.3323 | 1.08805 | 1.0795 | 2.16755 | 4.49985 | 0.13774 | 2.26563 | 0.88076 | 0.42849 | 3.57488 | 2.1395 | 0.92891 | 0.94824 | 4.03636 | 10/11/2019 | 13 | 12 | 2 | 72 | 1 | 0 | 72 | 10/11/2018 | 8 | 8 | 1 | 40 | 1 | 0 | 40 | 2017-08-30 | 6 | 6 | 0 | 1 | 84 | 0 | 84 | 63.333 | 5 | 0 | 1 | 24375.00 | 0 | 1 | 1330 GRAND POINTE COURT GRAND BLANC, MI 48439 (42.941165, -83.679015) | 02/01/2020 | |||||||||||
12415 | 12415 | 515 E 8TH STREET WHITE RIVER, SD 57579 | 43.573185 | -100.743577 | 0 | 43A089 | WHITE RIVER HEALTH CARE CENTER | 515 E 8TH STREET POST OFFICE BOX 310 | WHITE RIVER | SD | 57579 | 6052593161 | 470 | Mellette | Non profit - Corporation | 52 | 35.8 | Medicaid | false | Legal Business Name Not Available | 05/17/1990 | false | true | false | false | Resident | Yes | 2 | 1 | 5 | 5 | 2 | 1 | 12 | 1 | 12 | 6 | 6 | 12/12/2019 | 10 | 10 | 0 | 217 | 0 | 0 | 217 | 11/07/2018 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2017-08-30 | 3 | 3 | 0 | 1 | 24 | 0 | 24 | 112.5 | 0 | 0 | 0 | 0.00 | 0 | 0 | 515 E 8TH STREET WHITE RIVER, SD 57579 (43.573185, -100.743577) | 02/01/2020 | |||||||||||||||||||||
12898 | 12898 | 300 ARLINGTON AVENUE LOGAN, OH 43138 | 39.536159 | -82.395098 | 0 | 365435 | LOGAN CARE AND REHABILITATION | 300 ARLINGTON AVENUE | LOGAN | OH | 43138 | 7403852155 | 380 | Hocking | For profit - Corporation | 144 | 123.7 | Medicare and Medicaid | false | LOGAN HEALTHCARE LEASING LLC | 01/09/1980 | false | SFF Candidate | true | false | false | Resident | Yes | 1 | 1 | 3 | 4 | 3 | 1 | 12 | 1 | 12 | 1.72996 | 0.95592 | 0.16763 | 1.12355 | 2.85351 | 0.02047 | 2.06495 | 0.80149 | 0.41768 | 3.28412 | 1.74117 | 0.89682 | 0.15106 | 2.78621 | 10/10/2019 | 26 | 26 | 0 | 219 | 2 | 110 | 329 | 09/14/2018 | 23 | 14 | 9 | 195 | 1 | 0 | 195 | 2017-08-30 | 53 | 27 | 26 | 2 | 499 | 250 | 749 | 354.333 | 0 | 29 | 1 | 11427.00 | 0 | 1 | 300 ARLINGTON AVENUE LOGAN, OH 43138 (39.536159, -82.395098) | 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 );