nh_gen_info_geocoded_final

Table actions
Data provided via a collaboration between The Accountability Project and Big Local News. This project provides and joins datasets pertinent to the COVID-19 pandemic: hospital location and number of beds by type, county-level population estimates by age (which can be linked to hospital data) and nursing home location and capacity. See README for additional information.

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-02-09

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: prvdr_state, ownership, Special Focus Status, 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 Total Number of Health Deficiencies, Rating Cycle 1 Number of Standard Health Deficiencies, Rating Cycle 1 Number of Health Revisits, Rating Cycle 1 Health Revisit Score, Rating Cycle 2 Total Number of 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 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 Fines, Total Amount of Fines in Dollars, 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
2898 2898 3250 SW 41ST PLACE GAINESVILLE, FL 32608 29.615652 -82.370169 0   105193 PARK MEADOWS HEALTH AND REHABILITATION CENTER 3250 SW 41ST PLACE GAINESVILLE FL 32608 3523781558 0 Alachua For profit - Corporation 154 147 Medicare and Medicaid false THE OAKS NH LLC 11/20/1968 false   true false false Both Yes 2   1   3   3   3   4   3       2.53404 1.00712 0.51995 1.52707 4.06111 0.11605 1.89999 0.69336 0.33395 2.9273 2.7719 1.09221 0.58602 4.44868 03/21/2019 10 5 5 232 1 0 232 01/11/2018 9 9 0 48 1 0 48 2017-02-09 11 8 3 1 60 0 60 142 1 3 0 0.00 0 0 3250 SW 41ST PLACE GAINESVILLE, FL 32608 (29.615652, -82.370169) 02/01/2020
4751 4751 516 WEST FRECH STREET STREATOR, IL 61364 41.140037 -88.843063 0   145989 PARKER NURSING & REHAB CENTER 516 WEST FRECH STREET STREATOR IL 61364 8156722600 580 La Salle For profit - Corporation 102 52.7 Medicare and Medicaid false PARKER NURSING & REHABILITATION CENTER, LLC 05/11/1999 false SFF Candidate true false false Resident Yes 2   1   5   5   5   2   2       1.91677 0.64732 0.40888 1.05619 2.97296 0.01878 2.54776 0.83347 0.3997 3.78093 1.5636 0.584 0.38502 2.52141 01/17/2019 20 5 15 544 1 0 544 03/02/2018 9 1 8 40 1 0 40 2017-02-09 12 10 2 1 116 0 116 304.667 0 17 2 9309.00 0 2 516 WEST FRECH STREET STREATOR, IL 61364 (41.140037, -88.843063) 02/01/2020
6594 6594 725 W GENESEE FRANKENMUTH, MI 48734 43.335854 -83.748128 0   235269 WELLSPRING LUTHERAN SERVICES 725 W GENESEE FRANKENMUTH MI 48734 9896529951 720 Saginaw Non profit - Corporation 112 70.7 Medicare and Medicaid false LUTHERAN HOMES OF MICHIGAN, INC 03/01/1976 false   true false false Resident Yes 3   2   3   4   2   4   4       3.06322 1.0423 0.90747 1.94978 5.01299 0.05842 2.14135 0.70955 0.32888 3.17979 2.97308 1.10457 1.03854 5.05536 03/14/2019 10 10 2 92 1 0 92 03/15/2018 19 18 1 116 2 58 174 2017-02-09 22 12 10 1 168 0 168 132 6 8 0 0.00 0 0 725 W GENESEE FRANKENMUTH, MI 48734 (43.335854, -83.748128) 02/01/2020
8833 8833 1200 LANE LAREDO, TX 78043 29.034269 -98.565069 0   455528 RETAMA MANOR NURSING CENTER/LAREDO-WEST 1200 LANE LAREDO TX 78043 9567220031 953 Webb For profit - Corporation 198 136.8 Medicare and Medicaid false UVALDE COUNTY HOSPITAL AUTHORITY 07/03/1985 false SFF Candidate true false false Resident Yes 1   1   3   3   2   1   1       2.14726 0.79267 0.36387 1.15654 3.30379 0.03255 2.13372 0.80901 0.4495 3.39224 2.09152 0.73675 0.30468 3.12306 01/18/2019 11 7 4 136 1 0 136 02/16/2018 24 20 6 176 1 0 176 2017-02-09 35 9 26 1 899 0 899 276.5 4 12 3 238101.00 0 3 1200 LANE LAREDO, TX 78043 (29.034269, -98.565069) 02/01/2020
11746 11746 11830 NORTHPOINTE BOULEVARD TOMBALL, TX 77377 30.033071 -95.610194 0   676244 GRACE CARE CENTER AT NORTHPOINTE 11830 NORTHPOINTE BOULEVARD TOMBALL TX 77377 2812059400 610 Harris For profit - Corporation 135 100.9 Medicare and Medicaid false NORTHPOINTE LTC LTD 02/16/2010 false   true false false Resident Yes 1   1   2   2   2   2   1       2.01696 1.56291 0.3458 1.9087 3.92566 0 2.17508 0.80045 0.41769 3.39323 1.92725 1.46819 0.3116 3.70982 02/15/2019 11 5 8 108 1 0 108 02/02/2018 17 8 9 184 1 0 184 2017-02-09 10 7 3 1 96 0 96 131.333 3 13 4 44104.00 1 5 11830 NORTHPOINTE BOULEVARD TOMBALL, TX 77377 (30.033071, -95.610194) 02/01/2020
12026 12026 1600 BLAND STREET BLUEFIELD, WV 24701 37.258782 -81.219128 0   515186 MAPLES NURSING HOME 1600 BLAND STREET BLUEFIELD WV 24701 3043272485 270 Mercer For profit - Corporation 60 56 Medicare and Medicaid false Legal Business Name Not Available 05/01/2004 false SFF Candidate true false false Resident Yes 1   1   2   2   2   3   3       2.26624 1.34272 0.52893 1.87165 4.13789 0.01815 1.8901 0.74527 0.38748 3.02285 2.49194 1.35474 0.51378 4.38951 04/11/2019 24 24 0 402 2 201 603 04/05/2018 21 21 0 104 1 0 104 2017-02-09 18 18 4 2 124 62 186 367.167 0 5 1 81262.00 2 3 1600 BLAND STREET BLUEFIELD, WV 24701 (37.258782, -81.219128) 02/01/2020

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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
);