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 = 66

View and edit SQL

Suggested facets: ownership, nmbr_beds, Abuse Icon, With a Resident and Family Council, Overall Rating, Health Inspection Rating, QM Rating, Long-Stay QM Rating, Short-Stay QM Rating, Staffing Rating, Staffing Rating Footnote, RN Staffing Rating, RN Staffing Rating Footnote, Rating Cycle 1 Standard Survey Health Date, Rating Cycle 1 Number of Standard Health Deficiencies, Rating Cycle 1 Number of Complaint Health Deficiencies, Rating Cycle 2 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, 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
387 611 S 13TH ST FORT PIERCE, FL 34950 27.441933 -80.337175 0   105257 FORT PIERCE HEALTH CARE 611 S 13TH ST FORT PIERCE FL 34950 7724645262 550 St. Lucie For profit - Corporation 171 140.8 Medicare and Medicaid false 09/09/1972 false   false false false Both Yes 2   1   2   3   1   5   5       2.57066 0.44008 0.94458 1.38467 3.95533 0.01366 1.99301 0.69064 0.31502 2.99867 2.68071 0.47915 1.12859 4.22968 09/20/2019 26 16 11 152 1 0 152 07/27/2018 18 14 4 132 2 66 198 2017-06-02 19 13 6 1 112 0 112 160.667 1 15 3 11069.00 0 3 611 S 13TH ST FORT PIERCE, FL 34950 (27.441933, -80.337175) 02/01/2020
1948 410 WEST 1ST NORTH REXBURG, ID 83440 43.828209 -111.796039 0   135140 MADISON CARRIAGE COVE SHORT STAY REHABILITATION 410 WEST 1ST NORTH REXBURG ID 83440 2083597676 320 Madison For profit - Corporation 35 35.8 Medicare and Medicaid false 04/23/2015 false   false false false Resident Yes 3   2   4   4   5   4   5       2.2014 0.42049 1.43382 1.85431 4.05571 0 1.98142 0.87637 0.45859 3.31638 2.30907 0.36079 1.1768 3.92153 10/12/2018 2 2 0 8 1 0 8 04/21/2017 17 17 15 132 2 66 198 2016-10-05 16 3 13 1 92 0 92 85.333 0 12 0 0.00 0 0 410 WEST 1ST NORTH REXBURG, ID 83440 (43.828209, -111.796039) 02/01/2020
2881 8411 SOUTH 28TH STREET FORT SMITH, AR 72908 35.303899 -94.405288 0   45354 FIANNA HILLS NURSING AND REHABILITATION CENTER 8411 SOUTH 28TH STREET FORT SMITH AR 72908 4796489600 650 Sebastian For profit - Limited Liability company 102 91.1 Medicare and Medicaid false 01/25/2000 false   false false false Resident Yes 1   1   1   1   1   2   1       2.64373 1.10063 0.15696 1.25758 3.90131 0.02302 2.18295 0.73478 0.33549 3.25322 2.51703 1.12634 0.17609 3.84548 01/29/2019 9 8 1 80 1 0 80 03/23/2018 16 16 0 132 2 66 198 2017-02-16 9 8 1 1 185 0 185 136.833 2 0 3 36096.00 1 4 8411 SOUTH 28TH STREET FORT SMITH, AR 72908 (35.303899, -94.405288) 02/01/2020
5184 48 TARN TERRACE FROSTBURG, MD 21532 39.660536 -78.927868 0   215277 WEST MD HEALTH SYST FROSTBURG NRSG AND REHAB CTR 48 TARN TERRACE FROSTBURG MD 21532 3016891391 0 Allegany Non profit - Corporation 88 66.1 Medicare and Medicaid false 08/17/1995 false   true false false Resident Yes 2   2   2   1   4   2   2       2.68638 0.6879 0.30799 0.99589 3.68227 0.04141 2.19178 0.70476 0.34318 3.23972 2.54734 0.73395 0.33778 3.6447 09/20/2019 6 6 1 24 1 0 24 03/09/2018 22 19 3 132 2 66 198 2016-12-15 13 12 1 1 92 0 92 93.333 6 4 1 10273.00 0 1 48 TARN TERRACE FROSTBURG, MD 21532 (39.660536, -78.927868) 02/01/2020
6527 128 NORTH HARDESTY KANSAS CITY, MO 64123 39.113991 -94.51859 0   265463 PARKVIEW HEALTHCARE 128 NORTH HARDESTY KANSAS CITY MO 64123 8162412020 470 Jackson For profit - Corporation 120 73.1 Medicare and Medicaid false 09/01/1991 false   false false false Resident Yes 1   1   4   4   4   1 12 1 12     1.56858 0.53652 0.2693 0.80582 2.3744 0.00673 1.57748 0.59969 0.2645 2.44167 2.06661 0.67274 0.38322 3.11832 06/03/2019 18 18 2 128 1 0 128 04/13/2018 15 13 2 132 2 66 198 2017-05-16 22 22 0 1 156 0 156 156 2 5 0 0.00 1 1 128 NORTH HARDESTY KANSAS CITY, MO 64123 (39.113991, -94.51859) 02/01/2020
7117 2300 GREAT LAKES DR DYER, IN 46311 41.490745 -87.501955 0   155218 GREAT LAKES HEALTHCARE CENTER 2300 GREAT LAKES DR DYER IN 46311 2193223555 440 Lake For profit - Corporation 134 124.1 Medicare and Medicaid false 08/10/1983 false   false false false Resident Yes 1   1   4   4   4   2   3       2.03618 0.79056 0.70407 1.49463 3.53081 0.04525 2.34146 0.87781 0.48648 3.70575 1.80736 0.6772 0.54474 3.05529 04/29/2019 33 18 15 148 1 0 148 03/08/2018 26 19 9 132 2 66 198 2017-01-24 37 21 16 1 176 0 176 169.333 0 68 0 0.00 0 0 2300 GREAT LAKES DR DYER, IN 46311 (41.490745, -87.501955) 02/01/2020
13801 200 WEAVER AVENUE EMPORIA, VA 23847 36.698976 -77.538298 0   495375 ACCORDIUS HEALTH AT EMPORIA 200 WEAVER AVENUE EMPORIA VA 23847 4346346581 270 Emporia City For profit - Corporation 120 96.9 Medicare and Medicaid false 03/30/2004 false   false false false Resident Yes 1   1   1   3   1   2   2       1.92373 0.97806 0.34086 1.31892 3.24265 0.03683 2.06756 0.74799 0.36099 3.17654 1.93376 0.98322 0.3554 3.2734 04/18/2019 19 19 0 84 1 0 84 01/29/2018 25 19 6 132 2 66 198 2016-12-08 25 25 0 2 132 66 198 141 0 2 1 50635.00 0 1 200 WEAVER AVENUE EMPORIA, VA 23847 (36.698976, -77.538298) 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
);