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

7 rows where Rating Cycle 2 Health Revisit Score = 62

View and edit SQL

Suggested facets: prvdr_state, ownership, nmbr_beds, Provider Resides in Hospital, 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 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 Total Number of Health Deficiencies, Rating Cycle 2 Number of Standard Health Deficiencies, Rating Cycle 2 Number of Complaint Health Deficiencies, 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 Revisit 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, 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
1831 1000 PAVILIONS CIRCLE TRAVERSE CITY, MI 49684 44.758732 -85.641584 0   235088 GRAND TRAVERSE PAVILIONS 1000 PAVILIONS CIRCLE TRAVERSE CITY MI 49684 2319323163 270 Grand Traverse Government - County 240 223.2 Medicare and Medicaid false 01/11/1967 false   false false false Both Yes 2   1   4   3   5   5   5       2.71559 0.47321 1.15831 1.63153 4.34711 0.10428 2.03391 0.65272 0.29847 2.9851 2.7749 0.54515 1.46067 4.66977 08/26/2019 9 9 0 194 1 0 194 06/06/2018 17 12 6 124 2 62 186 2017-05-18 6 6 0 1 32 0 32 164.333 8 3 0 0.00 0 0 1000 PAVILIONS CIRCLE TRAVERSE CITY, MI 49684 (44.758732, -85.641584) 02/01/2020
5859 220 SCOVILLE ROAD AVON, CT 06001 41.7759 -72.860962 0   75388 APPLE REHAB AVON 220 SCOVILLE ROAD AVON CT 6001 8606733265 10 Hartford For profit - Individual 60 51 Medicare and Medicaid false 08/09/1993 false   false false false Resident Yes 2   1   5   2   5   3   4       1.7882 0.40656 0.78489 1.19146 2.97965 0.18842 2.05942 0.7548 0.37986 3.19408 1.80462 0.40502 0.77771 2.99138 06/13/2019 3 3 0 12 1 0 12 04/18/2018 22 15 18 124 2 62 186 2017-04-21 8 6 2 1 48 0 48 76 1 3 1 9692.00 0 1 220 SCOVILLE ROAD AVON, CT 06001 (41.7759, -72.860962) 02/01/2020
7584 730 KIMOLE LN ADRIAN, MI 49221 41.915356 -84.047674 0   235182 LYNWOOD MANOR HEALTHCARE CENTER 730 KIMOLE LN ADRIAN MI 49221 5172636771 450 Lenawee For profit - Corporation 84 71.4 Medicare and Medicaid false 10/01/1974 false   false false false Both Yes 1   1   1   1   3   2   2       2.00891 0.89771 0.42589 1.32361 3.33252 0.06497 1.86878 0.72072 0.35306 2.94256 2.23419 0.93659 0.45403 3.63162 05/08/2019 21 19 8 132 2 66 198 05/03/2018 19 13 6 124 2 62 186 2017-03-02 28 24 14 2 227 114 341 217.833 7 29 1 13811.00 0 1 730 KIMOLE LN ADRIAN, MI 49221 (41.915356, -84.047674) 02/01/2020
8483 101 LEE AVENUE COLUMBUS, KS 66725 37.171814 -94.857824 0   175264 MEDICALODGES COLUMBUS 101 LEE AVENUE COLUMBUS KS 66725 6204292134 100 Cherokee For profit - Corporation 45 34.8 Medicare and Medicaid false 11/01/1993 false   false false false Resident Yes 2   2   3   3   3   3   3       2.88637 0.94214 0.62773 1.56987 4.45624 0.03073 2.20402 0.74869 0.34718 3.29989 2.72178 0.94623 0.68053 4.33034 01/23/2020 7 4 3 56 0 0 56 01/10/2019 15 15 0 124 2 62 186 2017-12-01 0 0 0 0 0 0 0 90 1 0 0 0.00 1 1 101 LEE AVENUE COLUMBUS, KS 66725 (37.171814, -94.857824) 02/01/2020
9802 3737 CATALPA AVE BUENA VISTA, VA 24416 37.750999 -79.350257 0   495168 SHENANDOAH VALLEY HEALTH AND REHAB 3737 CATALPA AVE, PO BOX 711 BUENA VISTA VA 24416 5402617444 141 Buena Vista City For profit - Corporation 93 80.9 Medicare and Medicaid false 01/27/1987 false   false false false Resident Yes 1   1   4   3   5   3   3       1.68812 0.8112 0.57129 1.38249 3.07061 0.05394 2.02098 0.77009 0.37493 3.166 1.73603 0.79208 0.5735 3.11004 03/14/2019 6 6 2 36 1 0 36 02/01/2018 15 15 0 124 2 62 186 2016-11-03 9 9 0 2 56 28 84 94 0 3 1 6438.00 0 1 3737 CATALPA AVE BUENA VISTA, VA 24416 (37.750999, -79.350257) 02/01/2020
13489 801 EAST 16TH STREET BERWICK, PA 18603 41.070526 -76.229486 0   395421 BERWICK RETIREMENT VILLAGE NRS 801 EAST 16TH STREET BERWICK PA 18603 5707595400 250 Columbia For profit - Corporation 240 132.3 Medicare and Medicaid true 10/25/1978 false   false false false Resident Yes 1   1   2   3   2   1   1       2.07411 0.86572 0.30718 1.17291 3.24702 0.03562 2.08666 0.78409 0.39781 3.26856 2.06584 0.83023 0.29064 3.18553 08/23/2019 13 11 2 56 1 0 56 09/28/2018 17 11 6 124 2 62 186 2017-08-11 18 18 1 2 124 62 186 121 1 10 0 0.00 0 0 801 EAST 16TH STREET BERWICK, PA 18603 (41.070526, -76.229486) 02/01/2020
15225 1 VANTAGE DRIVE POQUOSON, VA 23662 37.129438 -76.402828 0   495264 BAYSIDE OF POQUOSON HEALTH AND REHAB 1 VANTAGE DRIVE POQUOSON VA 23662 7578689960 712 Poquoson For profit - Partnership 60 55.4 Medicare and Medicaid false 06/01/1992 false   false false false Resident Yes 1   2   1   1   2   2   2       1.76871 0.90319 0.42745 1.33064 3.09935 0.0312 2.20176 0.78226 0.3826 3.36661 1.66957 0.86819 0.42051 2.9521 08/16/2019 12 12 3 60 1 0 60 09/21/2018 23 23 0 124 2 62 186 2017-04-13 6 6 3 1 24 0 24 96 0 6 1 57415.00 0 1 1 VANTAGE DRIVE POQUOSON, VA 23662 (37.129438, -76.402828) 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
);