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 Overall Rating = 3 and Rating Cycle 2 Number of Standard Health Deficiencies = 21

View and edit SQL

Suggested facets: geocode_flag, geocode_accuracy, prvdr_state, prvdr_cnty, prvdr_cnty_name, ownership, prvdr_type, Continuing Care Retirement Community, With a Resident and Family Council, Health Inspection Rating, QM Rating, Long-Stay QM Rating, Short-Stay QM Rating, 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 Standard Health Deficiencies, Rating Cycle 1 Number of Complaint Health Deficiencies, Rating Cycle 1 Health Deficiency Score, Rating Cycle 1 Total Health Score, Rating Cycle 2 Total Number of Health Deficiencies, Rating Cycle 2 Number of Complaint 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 Total Health Score, Total Weighted Health Survey Score, Number of Facility Reported Incidents, Number of Fines, Total Amount of Fines in Dollars, Number of Payment Denials, Total Number of Penalties, Location, 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
1660 10301 NORTH EAST CHRISTIE ROAD CUMBERLAND, MD 21502 39.665796 -78.721482 0   215244 DEVLIN MANOR NURSING AND REHABILITATION CENTER 10301 NORTH EAST CHRISTIE ROAD CUMBERLAND MD 21502 3017241400 0 Allegany For profit - Corporation 124 103.6 Medicare and Medicaid false 09/01/1992 false   false false false Both Yes 3   3   2   2   2   3   3       1.90196 0.58263 0.74083 1.32346 3.22542 0.01677 2.08423 0.76482 0.38995 3.239 1.89658 0.57282 0.71506 3.19322 06/15/2018 0 0 0 0 1 0 0 03/23/2017 24 21 23 140 1 0 140 2016-01-07 13 11 2 1 56 0 56 56 5 6 0 0.00 0 0 10301 NORTH EAST CHRISTIE ROAD CUMBERLAND, MD 21502 (39.665796, -78.721482) 02/01/2020
2129 5301 E Warm Springs Ave, Boise, ID 83716, USA 43.5668544 -116.1180156 1 ROOFTOP 135141 TERRACES OF BOISE, THE 5301 E WARM SPRINGS AVE BOISE ID 83716 2083365550 0 Ada Non profit - Corporation 48 19.2 Medicare false 12/21/2016 true   false false false Resident Yes 3   2   4   4   4   5   5       2.94403 0.90483 1.87485 2.77968 5.72371 0.28197 2.16696 0.68612 0.3019 3.15499 2.82363 0.99162 2.33742 5.81746 09/20/2019 6 6 0 28 1 0 28 03/23/2018 21 21 0 252 1 0 252 2016-12-21 0 0 0 0 0 0 0 98 0 0 1 6500.00 0 1   02/01/2020
3569 1500 W WARM SPRINGS RD HENDERSON, NV 89014 36.056268 -115.049942 0   295071 TLC CARE CENTER 1500 W WARM SPRINGS RD HENDERSON NV 89014 7025476700 10 Clark For profit - Individual 255 229 Medicare and Medicaid false 07/27/1999 false   false false false Resident Yes 3   3   2   3   1   3   3       2.3862 1.02575 0.73756 1.76331 4.14951 0 2.09529 0.7117 0.44063 3.24762 2.36689 1.08375 0.63002 4.09717 07/26/2019 5 4 2 20 1 0 20 07/16/2018 24 21 3 104 1 0 104 2017-07-28 21 11 15 1 100 0 100 61.333 0 9 0 0.00 0 0 1500 W WARM SPRINGS RD HENDERSON, NV 89014 (36.056268, -115.049942) 02/01/2020
9854 1601 S BALDWIN AVE ARCADIA, CA 91006 34.121026 -118.055004 0   555729 ARCADIA HEALTH CARE CENTER 1601 S BALDWIN AVE. ARCADIA CA 91006 6264452170 200 Los Angeles For profit - Corporation 117 115.2 Medicare and Medicaid false 07/29/1998 false   false false false Resident Yes 3   2   5   5   5   3   2       2.71092 1.3708 0.38079 1.75159 4.46251 0.08965 2.07545 0.73913 0.33978 3.15436 2.71469 1.39457 0.42181 4.5365 01/11/2019 23 22 1 104 1 0 104 01/18/2018 21 21 0 108 1 0 108 2017-02-28 9 9 0 1 56 0 56 97.333 0 3 1 3097.00 0 1 1601 S BALDWIN AVE ARCADIA, CA 91006 (34.121026, -118.055004) 02/01/2020
11959 730 LUNENBURG KEYSVILLE, VA 23947 37.036842 -78.47476 0   495226 WAYLAND NURSING AND REHABILITATION CENTER 730 LUNENBURG HIGHW KEYSVILLE VA 23947 4347368406 190 Charlotte For profit - Corporation 90 48.6 Medicare and Medicaid false 11/30/1990 false   false false false Resident Yes 3   2   5   5   5   2   2       1.81424 1.15243 0.55628 1.70871 3.52295 0.08214 2.02085 0.83825 0.43614 3.29524 1.86585 1.03376 0.48006 3.42825 06/07/2019 15 15 0 100 1 0 100 03/09/2018 24 21 3 120 1 0 120 2017-02-09 14 14 4 1 52 0 52 98.667 0 4 0 0.00 0 0 730 LUNENBURG KEYSVILLE, VA 23947 (37.036842, -78.47476) 02/01/2020
13118 1450 N Fair Oaks Ave, Pasadena, CA 91103, USA 34.1708097 -118.1501655 1 ROOFTOP 555096 GOLDEN CROSS HEALTH CARE 1450 N. FAIR OAKS AVENUE PASADENA CA 91103 6267911948 200 Los Angeles For profit - Limited Liability company 96 92.2 Medicare and Medicaid false 08/01/1978 false   false false false Resident Yes 3   2   5   5   2   3   2       2.45838 0.89135 0.30668 1.19803 3.65641 0 1.8083 0.69789 0.32592 2.83211 2.82549 0.9604 0.35416 4.13998 04/11/2019 17 17 0 84 1 0 84 03/31/2018 22 21 1 116 1 0 116 2017-05-12 16 14 2 1 108 0 108 98.667 3 2 1 3097.00 1 2   02/01/2020
13424 6246 SOUTH REDWOOD ROAD SALT LAKE CITY, UT 84123 40.637753 -111.938793 0   465066 AVALON WEST HEALTH & REHABILITATION 6246 SOUTH REDWOOD ROAD SALT LAKE CITY UT 84123 8019691420 170 Salt Lake Government - County 120 111.4 Medicare and Medicaid false 07/18/1977 false   false false false Resident Yes 3   2   5   5   5   3   4       2.39749 0.34296 0.97635 1.31931 3.7168 0.14535 2.25515 0.89337 0.50168 3.6502 2.20952 0.28867 0.7325 3.26517 09/12/2019 0 0 0 0 1 0 0 09/13/2018 21 21 17 144 1 0 144 2017-09-28 11 11 11 1 100 0 100 64.667 0 33 2 30039.00 0 2 6246 SOUTH REDWOOD ROAD SALT LAKE CITY, UT 84123 (40.637753, -111.938793) 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
);