nh_gen_info_geocoded_final
Data source: Big Local News · About: big-local-datasette
5 rows where Health Inspection Rating = 2 and ownership = "Government - Federal"
This data as json, copyable, CSV (advanced)
Suggested facets: geocode_flag, geocode_accuracy, With a Resident and Family Council, Overall Rating, QM Rating, Long-Stay QM Rating, Short-Stay QM Rating, Short-Stay QM Rating Footnote, Staffing Rating, RN Staffing Rating, Reported Physical Therapist Staffing Hours per Resident Per Day, Rating Cycle 1 Total Number of Health Deficiencies, Rating Cycle 1 Number of Complaint 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, Rating Cycle 3 Health Deficiency Score, Rating Cycle 3 Total Health Score, Number of Substantiated Complaints, Number of Fines, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1330 | 1330 | 1660 SOUTH MULFORD ROCKFORD, IL 61108 | 42.251732 | -88.999665 | 0 | 145891 | ROSEWOOD CARE CENTER OF ROCKFORD | 1660 SOUTH MULFORD | ROCKFORD | IL | 61108 | 8153978700 | 991 | Winnebago | Government - Federal | 116 | 70.5 | Medicare and Medicaid | false | BRAVO CARE OF ROCKFORD INC | 05/29/1996 | false | false | false | false | Resident | Yes | 3 | 2 | 2 | 2 | 2 | 4 | 4 | 2.1437 | 0.73513 | 0.75308 | 1.48821 | 3.63192 | 0.07636 | 1.96867 | 0.76006 | 0.34511 | 3.07383 | 2.26312 | 0.72728 | 0.82134 | 3.78886 | 03/26/2019 | 9 | 8 | 1 | 48 | 1 | 0 | 48 | 02/06/2018 | 25 | 15 | 10 | 136 | 1 | 0 | 136 | 2017-02-01 | 18 | 9 | 9 | 1 | 171 | 0 | 171 | 97.833 | 3 | 10 | 1 | 68381.00 | 0 | 1 | 1660 SOUTH MULFORD ROCKFORD, IL 61108 (42.251732, -88.999665) | 02/01/2020 | |||||||||||
7839 | 7839 | 9380 NW 7TH AVENUE MIAMI, FL 33150 | 25.860709 | -80.209642 | 0 | 105449 | MIAMI SHORES NURSING AND REHAB CENTER | 9380 NW 7TH AVENUE | MIAMI | FL | 33150 | 3057598711 | 120 | Miami-Dade | Government - Federal | 99 | 96.8 | Medicare and Medicaid | false | DOS OF NORTH SHORE LTD | 03/01/1984 | false | false | false | false | Both | Yes | 4 | 2 | 5 | 5 | 5 | 4 | 4 | 3.36123 | 0.71869 | 0.68822 | 1.40691 | 4.76814 | 0.00854 | 2.1114 | 0.69934 | 0.31224 | 3.12298 | 3.3086 | 0.77275 | 0.8296 | 4.89591 | 01/18/2019 | 3 | 3 | 0 | 12 | 1 | 0 | 12 | 12/08/2017 | 10 | 10 | 0 | 72 | 1 | 0 | 72 | 2017-03-02 | 8 | 8 | 0 | 1 | 36 | 0 | 36 | 36 | 0 | 0 | 1 | 7748.00 | 0 | 1 | 9380 NW 7TH AVENUE MIAMI, FL 33150 (25.860709, -80.209642) | 02/01/2020 | |||||||||||
8994 | 8994 | 4 NORTH FORK ROAD FORT WASHAKIE, WY 82514 | 43.003538 | -108.882163 | 0 | 535050 | MORNING STAR CARE CENTER | 4 NORTH FORK ROAD | FORT WASHAKIE | WY | 82514 | 3073326902 | 60 | Fremont | Government - Federal | 45 | 32.1 | Medicare and Medicaid | false | MORNING STAR CARE CENTER | 05/15/1994 | false | false | false | false | Resident | Yes | 3 | 2 | 2 | 2 | 2 | 5 | 5 | 3.62459 | 0 | 2.37099 | 2.37099 | 5.99557 | 0 | 1.9559 | 0.67018 | 0.29966 | 2.92573 | 3.85149 | 0 | 2.97808 | 6.57127 | 10/03/2019 | 9 | 9 | 0 | 40 | 1 | 0 | 40 | 10/18/2018 | 13 | 12 | 2 | 88 | 1 | 0 | 88 | 2017-10-26 | 7 | 7 | 0 | 1 | 48 | 0 | 48 | 57.333 | 2 | 0 | 1 | 7803.00 | 0 | 1 | 4 NORTH FORK ROAD FORT WASHAKIE, WY 82514 (43.003538, -108.882163) | 02/01/2020 | |||||||||||
9955 | 9955 | Nespelem, WA 99155, USA | 48.1671004 | -118.9747476 | 1 | APPROXIMATE | 505412 | COLVILLE TRIBAL CONVALESCENT C | PO BOX 150 | NESPELEM | WA | 99155 | 5096342878 | 230 | Okanogan | Government - Federal | 44 | 32.5 | Medicare and Medicaid | false | CONFEDERATED TRIBES OF THE COLVILLE RESERVATION | 01/01/1992 | false | false | false | false | Resident | Yes | 2 | 2 | 1 | 1 | 2 | 4 | 4 | 2.69985 | 0.74331 | 0.65614 | 1.39945 | 4.0993 | 0 | 1.87295 | 0.62389 | 0.24088 | 2.73772 | 2.99592 | 0.89588 | 1.02523 | 4.80147 | 08/16/2019 | 19 | 18 | 4 | 132 | 1 | 0 | 132 | 10/10/2018 | 17 | 16 | 1 | 163 | 2 | 82 | 245 | 2017-11-08 | 8 | 5 | 3 | 1 | 48 | 0 | 48 | 155.667 | 4 | 1 | 1 | 40173.00 | 0 | 1 | 02/01/2020 | |||||||||||
12083 | 12083 | 1612 JONES BRIDGE ROAD BLACKVILLE, SC 29817 | 33.382799 | -81.262081 | 0 | 425319 | LAUREL BAYE HEALTHCARE BLACKVILLE | 1612 JONES BRIDGE ROAD | BLACKVILLE | SC | 29817 | 8032844313 | 50 | Barnwell | Government - Federal | 85 | 79.1 | Medicare and Medicaid | false | BLACKVILLE HEALTHCARE AND REHAB LLC | 11/11/1991 | false | false | false | false | Resident | Yes | 2 | 2 | 2 | 3 | 1 | 2 | 1 | 2.09732 | 1.01517 | 0.17988 | 1.19505 | 3.29237 | 0.00371 | 1.98315 | 0.64451 | 0.26999 | 2.89765 | 2.19799 | 1.18438 | 0.25076 | 3.64347 | 06/12/2019 | 4 | 4 | 0 | 36 | 1 | 0 | 36 | 04/27/2018 | 6 | 6 | 0 | 36 | 1 | 0 | 36 | 2017-02-02 | 12 | 8 | 4 | 1 | 92 | 0 | 92 | 45.333 | 1 | 0 | 2 | 20868.00 | 0 | 2 | 1612 JONES BRIDGE ROAD BLACKVILLE, SC 29817 (33.382799, -81.262081) | 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 );