nh_gen_info_geocoded_final
Data source: Big Local News · About: big-local-datasette
5 rows where RN Staffing Rating = 1 and Total Number of Penalties = 6
This data as json, copyable, CSV (advanced)
Suggested facets: geocode_flag, geocode_accuracy, ownership, Special Focus Status, Overall Rating, QM Rating, Long-Stay QM Rating, Short-Stay QM Rating, Staffing Rating, Staffing Rating Footnote, RN Staffing Rating Footnote, Reported Staffing Footnote, Physical Therapist Staffing Footnote, Rating Cycle 1 Number of Complaint Health Deficiencies, Rating Cycle 2 Number of Health Revisits, Rating Cycle 3 Number of Complaint Health Deficiencies, Number of Fines, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2176 | 2176 | 11515 TROOST KANSAS CITY, MO 64131 | 38.917376 | -94.579319 | 0 | 265822 | BRIDGEWOOD HEALTH CARE CENTER | 11515 TROOST | KANSAS CITY | MO | 64131 | 8169430101 | 470 | Jackson | For profit - Individual | 166 | 161 | Medicare and Medicaid | false | BRIDGEWOOD HEALTH CARE CENTER LLC | 08/28/2008 | false | false | false | false | Resident | Yes | 2 | 1 | 5 | 5 | 5 | 1 | 1 | 1.45765 | 0.41948 | 0.17186 | 0.59134 | 2.04899 | 0 | 1.42344 | 0.55851 | 0.24128 | 2.22323 | 2.12828 | 0.56476 | 0.26809 | 2.95534 | 03/22/2019 | 13 | 13 | 2 | 131 | 1 | 0 | 131 | 05/30/2018 | 17 | 14 | 6 | 195 | 1 | 0 | 195 | 2017-03-20 | 11 | 11 | 0 | 1 | 72 | 0 | 72 | 142.5 | 5 | 11 | 3 | 701429.00 | 3 | 6 | 11515 TROOST KANSAS CITY, MO 64131 (38.917376, -94.579319) | 02/01/2020 | |||||||||||
7191 | 7191 | 2160 ZINNIA LANE LIBERAL, KS 67901 | 37.064107 | -100.924909 | 0 | 175334 | GOOD SAMARITAN SOCIETY - LIBERAL | 2160 ZINNIA LANE | LIBERAL | KS | 67901 | 6206243831 | 870 | Seward | Non profit - Corporation | 45 | 35.8 | Medicare and Medicaid | false | THE EVANGELICAL LUTHERAN GOOD SAMARITAN SOCIETY | 05/01/1995 | false | false | false | false | Resident | Yes | 1 | 1 | 2 | 2 | 2 | 1 | 12 | 1 | 12 | 2.84919 | 0.27007 | 0.44155 | 0.71161 | 3.56081 | 0.00929 | 2.05848 | 0.65543 | 0.29216 | 3.00607 | 2.87667 | 0.30983 | 0.56883 | 3.79841 | 08/08/2019 | 11 | 6 | 11 | 124 | 1 | 0 | 124 | 06/14/2018 | 7 | 0 | 7 | 186 | 0 | 0 | 186 | 2016-04-11 | 8 | 8 | 0 | 1 | 205 | 0 | 205 | 158.167 | 4 | 3 | 3 | 87380.00 | 3 | 6 | 2160 ZINNIA LANE LIBERAL, KS 67901 (37.064107, -100.924909) | 02/01/2020 | |||||||||
10124 | 10124 | Highway 64 E, Warner, OK 74469, USA | 35.4930193 | -95.29581209999999 | 1 | ROOFTOP | 375341 | COUNTRYSIDE ESTATES | HIGHWAY 64 EAST | WARNER | OK | 74469 | 9184635143 | 500 | Muskogee | For profit - Corporation | 111 | 81 | Medicare and Medicaid | false | COUNTRYSIDE HEALTH SERVICES LLC | 07/01/1998 | false | false | false | false | Resident | Yes | 1 | 1 | 1 | 3 | 1 | 2 | 1 | 2.96189 | 1.67019 | 0.18368 | 1.85387 | 4.81576 | 0.00315 | 2.24326 | 0.86379 | 1.16101 | 4.26806 | 2.74414 | 1.45392 | 0.05955 | 3.61816 | 11/29/2018 | 1 | 1 | 0 | 16 | 1 | 0 | 16 | 09/05/2017 | 16 | 3 | 16 | 394 | 1 | 0 | 394 | 2016-06-09 | 25 | 9 | 16 | 1 | 502 | 0 | 502 | 223 | 2 | 8 | 3 | 404232.00 | 3 | 6 | 02/01/2020 | |||||||||||
12607 | 12607 | 316 GENERAL CAVAZOS BLVD KINGSVILLE, TX 78363 | 27.491227 | -97.86623 | 0 | 675494 | KLEBERG COUNTY NURSING AND REHABILITATION LP | 316 GENERAL CAVAZOS BLVD | KINGSVILLE | TX | 78363 | 3615929366 | 743 | Kleberg | For profit - Partnership | 146 | 92.9 | Medicare and Medicaid | false | KLEBERG COUNTY NURSING AND REHABILITATION LP | 06/07/1995 | false | SFF Candidate | false | false | false | Resident | Yes | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1.90377 | 1.19804 | 0.24042 | 1.43846 | 3.34223 | 0.02521 | 2.01566 | 0.80625 | 0.43388 | 3.2558 | 1.96296 | 1.11734 | 0.20856 | 3.29179 | 03/29/2019 | 24 | 21 | 6 | 220 | 1 | 0 | 220 | 04/28/2018 | 29 | 21 | 8 | 327 | 1 | 0 | 327 | 2017-05-26 | 29 | 19 | 24 | 1 | 404 | 0 | 404 | 286.333 | 3 | 5 | 5 | 152522.00 | 1 | 6 | 316 GENERAL CAVAZOS BLVD KINGSVILLE, TX 78363 (27.491227, -97.86623) | 02/01/2020 | ||||||||||
13196 | 13196 | 230 EAST PRESNELL STREET ASHEBORO, NC 27203 | 35.71458 | -79.808406 | 0 | 345155 | ALPINE HEALTH AND REHABILITATION OF ASHEBORO | 230 EAST PRESNELL STREET | ASHEBORO | NC | 27203 | 3366291447 | 750 | Randolph | For profit - Corporation | 238 | 119.6 | Medicare and Medicaid | false | ALPINE HEALTH AND REHABILITATION OF ASHEBORO | 05/21/1976 | false | SFF Candidate | false | false | false | Resident | Yes | 1 | 1 | 2 | 3 | 2 | 1 | 12 | 1 | 12 | 6 | 6 | 04/05/2019 | 6 | 4 | 2 | 32 | 1 | 0 | 32 | 02/01/2018 | 30 | 18 | 13 | 364 | 1 | 0 | 364 | 2017-02-09 | 21 | 17 | 20 | 1 | 296 | 0 | 296 | 186.667 | 0 | 17 | 4 | 157249.00 | 2 | 6 | 230 EAST PRESNELL STREET ASHEBORO, NC 27203 (35.71458, -79.808406) | 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 );