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-05-18
This data as json, copyable, CSV (advanced)
Suggested facets: prvdr_state, ownership, Continuing Care Retirement Community, Provider Changed Ownership in Last 12 Months, With a Resident and Family Council, Overall Rating, Health Inspection Rating, QM Rating, Long-Stay QM Rating, Short-Stay QM Rating, Staffing Rating, RN Staffing Rating, Rating Cycle 1 Number of Standard Health Deficiencies, 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 2 Number of Complaint Health Deficiencies, Rating Cycle 2 Health Deficiency Score, Rating Cycle 2 Total Health 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, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1726 | 1726 | 4921 MEDICAL DRIVE BOSSIER CITY, LA 71112 | 32.46018 | -93.667644 | 0 | 195604 | COLONIAL OAKS SKILLED NURSING AND REHABILITATION | 4921 MEDICAL DRIVE | BOSSIER CITY | LA | 71112 | 3187425420 | 70 | Bossier | For profit - Corporation | 120 | 105.9 | Medicare and Medicaid | false | PMG OPCO-COLONIAL LLC | 09/24/2004 | false | true | false | true | Resident | Yes | 1 | 1 | 2 | 3 | 1 | 1 | 1 | 2.3008 | 1.05814 | 0.11733 | 1.17546 | 3.47626 | 0.09787 | 2.07163 | 0.90331 | 0.50031 | 3.47525 | 2.30825 | 0.88083 | 0.08826 | 3.2076 | 06/28/2019 | 12 | 9 | 3 | 193 | 1 | 0 | 193 | 06/21/2018 | 8 | 5 | 3 | 48 | 1 | 0 | 48 | 2017-05-18 | 1 | 1 | 0 | 1 | 4 | 0 | 4 | 113.167 | 1 | 4 | 1 | 37047.00 | 1 | 2 | 4921 MEDICAL DRIVE BOSSIER CITY, LA 71112 (32.46018, -93.667644) | 02/01/2020 | |||||||||||
2500 | 2500 | 38410 CHERRY HILL RD WESTLAND, MI 48185 | 42.309281 | -83.418083 | 0 | 235228 | CHERRY HILL FOR NURSING AND REHABILITATION | 38410 CHERRY HILL RD | WESTLAND | MI | 48185 | 7343261200 | 810 | Wayne | For profit - Corporation | 127 | 87.4 | Medicare and Medicaid | false | CHERRY HILL OPCO LLC | 06/01/1978 | false | true | false | true | Resident | Yes | 1 | 1 | 3 | 5 | 2 | 2 | 2 | 2.05291 | 0.85859 | 0.43571 | 1.2943 | 3.34721 | 0.1692 | 2.02776 | 0.71821 | 0.34792 | 3.09389 | 2.10411 | 0.89891 | 0.47136 | 3.46921 | 06/05/2019 | 15 | 10 | 5 | 234 | 1 | 0 | 234 | 03/22/2018 | 21 | 11 | 10 | 116 | 1 | 0 | 116 | 2017-05-18 | 30 | 6 | 26 | 1 | 244 | 0 | 244 | 196.333 | 8 | 78 | 3 | 254530.00 | 1 | 4 | 38410 CHERRY HILL RD WESTLAND, MI 48185 (42.309281, -83.418083) | 02/01/2020 | |||||||||||
2769 | 2769 | 701 HOMESTEAD ST MARQUETTE, MI 49855 | 46.541158 | -87.409126 | 0 | 235367 | NORLITE NURSING CENTER | 701 HOMESTEAD ST | MARQUETTE | MI | 49855 | 9062289252 | 510 | Marquette | For profit - Corporation | 99 | 78.6 | Medicare and Medicaid | false | NORLITE NURSING CENTERS OF MARQUETTE INC | 09/01/1978 | false | true | false | false | Resident | Yes | 3 | 2 | 4 | 2 | 5 | 4 | 3 | 2.58432 | 1.35558 | 0.60997 | 1.96555 | 4.54987 | 0.05203 | 2.16519 | 0.67827 | 0.32062 | 3.16409 | 2.48065 | 1.50281 | 0.71606 | 4.61109 | 09/12/2019 | 14 | 10 | 5 | 201 | 1 | 0 | 201 | 07/20/2018 | 15 | 10 | 5 | 96 | 1 | 0 | 96 | 2017-05-18 | 8 | 5 | 3 | 2 | 40 | 20 | 60 | 142.5 | 7 | 3 | 1 | 11941.00 | 0 | 1 | 701 HOMESTEAD ST MARQUETTE, MI 49855 (46.541158, -87.409126) | 02/01/2020 | |||||||||||
3428 | 3428 | 2320 E BELTLINE SE GRAND RAPIDS, MI 49546 | 42.921573 | -85.584051 | 0 | 235103 | SKLD BELTLINE | 2320 E BELTLINE SE | GRAND RAPIDS | MI | 49546 | 6169493000 | 400 | Kent | For profit - Corporation | 182 | 108.1 | Medicare and Medicaid | false | GRAND RAPIDS SNF LLC | 01/01/1967 | false | true | false | false | Resident | Yes | 3 | 2 | 3 | 3 | 3 | 4 | 4 | 2.59034 | 0.81557 | 0.84365 | 1.65921 | 4.24956 | 0.04363 | 2.12422 | 0.70517 | 0.31354 | 3.14293 | 2.53439 | 0.86966 | 1.01274 | 4.33573 | 09/11/2019 | 27 | 11 | 16 | 184 | 1 | 0 | 184 | 06/29/2018 | 14 | 4 | 10 | 112 | 1 | 0 | 112 | 2017-05-18 | 19 | 16 | 3 | 1 | 124 | 0 | 124 | 150 | 14 | 31 | 1 | 2121.00 | 1 | 2 | 2320 E BELTLINE SE GRAND RAPIDS, MI 49546 (42.921573, -85.584051) | 02/01/2020 | |||||||||||
7336 | 7336 | 4747 ALBEN BARKLEY DRIVE PADUCAH, KY 42001 | 37.056282 | -88.659253 | 0 | 185312 | STONECREEK HEALTH AND REHABILITATION | 4747 ALBEN BARKLEY DRIVE | PADUCAH | KY | 42001 | 2704449661 | 720 | Mc Cracken | For profit - Corporation | 86 | 77.4 | Medicare and Medicaid | false | PADUCAH CENTER FOR HEALTH AND REHABILITATION, LLC | 12/01/1991 | false | true | false | false | Resident | Yes | 2 | 2 | 3 | 2 | 3 | 2 | 2 | 2.14362 | 0.84804 | 0.43388 | 1.28192 | 3.42554 | 0.05391 | 2.05357 | 0.82136 | 0.4227 | 3.29763 | 2.16947 | 0.77637 | 0.38633 | 3.33104 | 10/04/2019 | 17 | 4 | 13 | 112 | 1 | 0 | 112 | 07/12/2018 | 8 | 5 | 3 | 56 | 1 | 0 | 56 | 2017-05-18 | 4 | 0 | 4 | 0 | 16 | 0 | 16 | 77.333 | 1 | 10 | 2 | 18190.00 | 0 | 2 | 4747 ALBEN BARKLEY DRIVE PADUCAH, KY 42001 (37.056282, -88.659253) | 02/01/2020 | |||||||||||
10002 | 10002 | 429 SOUTH MARKET STREET MARTINSBURG, PA 16662 | 40.305177 | -78.328452 | 0 | 395563 | MORRISONS COVE HOME | 429 SOUTH MARKET STREET | MARTINSBURG | PA | 16662 | 8147932104 | 120 | Blair | Non profit - Corporation | 124 | 119 | Medicare and Medicaid | false | THE VILLAGE AT MORRISONS COVE | 01/01/1983 | true | true | false | false | Both | Yes | 3 | 2 | 4 | 5 | 3 | 4 | 4 | 2.41836 | 0.79597 | 0.70322 | 1.4992 | 3.91756 | 0.02671 | 2.14301 | 0.72151 | 0.33948 | 3.204 | 2.34538 | 0.82954 | 0.77966 | 3.92081 | 06/20/2019 | 9 | 6 | 3 | 92 | 1 | 0 | 92 | 05/17/2018 | 9 | 9 | 0 | 48 | 1 | 0 | 48 | 2017-05-18 | 6 | 6 | 0 | 1 | 40 | 0 | 40 | 68.667 | 2 | 0 | 1 | 118141.00 | 0 | 1 | 429 SOUTH MARKET STREET MARTINSBURG, PA 16662 (40.305177, -78.328452) | 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 );