COVID_HospitalBeds_CountyDemographics_NursingHomes

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

Custom SQL query returning 4 rows (hide)

Query parameters

rowidaddresslatlnggeocode_flaggeocode_accuracyprvdr_nmbrprvdr_nmprvdr_addprvdr_cityprvdr_stateprvdr_zipprvdr_phnprvdr_cntyprvdr_cnty_nameownershipnmbr_bedsavg_residentsprvdr_typeProvider Resides in HospitalLegal Business NameDate First Approved to Provide Medicare and Medicaid servicesContinuing Care Retirement CommunitySpecial Focus StatusAbuse IconMost Recent Health Inspection More Than 2 Years AgoProvider Changed Ownership in Last 12 MonthsWith a Resident and Family CouncilAutomatic Sprinkler Systems in All Required AreasOverall RatingOverall Rating FootnoteHealth Inspection RatingHealth Inspection Rating FootnoteQM RatingQM Rating FootnoteLong-Stay QM RatingLong-Stay QM Rating FootnoteShort-Stay QM RatingShort-Stay QM Rating FootnoteStaffing RatingStaffing Rating FootnoteRN Staffing RatingRN Staffing Rating FootnoteReported Staffing FootnotePhysical Therapist Staffing FootnoteReported Nurse Aide Staffing Hours per Resident per DayReported LPN Staffing Hours per Resident per DayReported RN Staffing Hours per Resident per DayReported Licensed Staffing Hours per Resident per DayReported Total Nurse Staffing Hours per Resident per DayReported Physical Therapist Staffing Hours per Resident Per DayCase-Mix Nurse Aide Staffing Hours per Resident per DayCase-Mix LPN Staffing Hours per Resident per DayCase-Mix RN Staffing Hours per Resident per DayCase-Mix Total Nurse Staffing Hours per Resident per DayAdjusted Nurse Aide Staffing Hours per Resident per DayAdjusted LPN Staffing Hours per Resident per DayAdjusted RN Staffing Hours per Resident per DayAdjusted Total Nurse Staffing Hours per Resident per DayRating Cycle 1 Standard Survey Health DateRating Cycle 1 Total Number of Health DeficienciesRating Cycle 1 Number of Standard Health DeficienciesRating Cycle 1 Number of Complaint Health DeficienciesRating Cycle 1 Health Deficiency ScoreRating Cycle 1 Number of Health RevisitsRating Cycle 1 Health Revisit ScoreRating Cycle 1 Total Health ScoreRating Cycle 2 Standard Health Survey DateRating Cycle 2 Total Number of Health DeficienciesRating Cycle 2 Number of Standard Health DeficienciesRating Cycle 2 Number of Complaint Health DeficienciesRating Cycle 2 Health Deficiency ScoreRating Cycle 2 Number of Health RevisitsRating Cycle 2 Health Revisit ScoreRating Cycle 2 Total Health ScoreRating Cycle 3 Standard Health Survey DateRating Cycle 3 Total Number of Health DeficienciesRating Cycle 3 Number of Standard Health DeficienciesRating Cycle 3 Number of Complaint Health DeficienciesRating Cycle 3 Number of Health RevisitsRating Cycle 3 Health Deficiency ScoreRating Cycle 3 Health Revisit ScoreRating Cycle 3 Total Health ScoreTotal Weighted Health Survey ScoreNumber of Facility Reported IncidentsNumber of Substantiated ComplaintsNumber of FinesTotal Amount of Fines in DollarsNumber of Payment DenialsTotal Number of PenaltiesLocationProcessing Date
1409 7501 KEYSTONE DRIVE OMAHA, NE 68134 41.299589 -96.027754 0   285238 KEYSTONE RIDGE POST ACUTE NURSING AND REHAB 7501 KEYSTONE DRIVE OMAHA NE 68134 4025725750 270 Douglas For profit - Individual 100 40.1 Medicare and Medicaid false 05/08/2000 true SFF false false false Resident Yes   18   18   18   18   18   18   18     2.78176 0.94858 0.83189 1.78047 4.56223 0.07308 1.91189 0.73248 0.35427 2.99864 3.02395 0.97377 0.88382 4.87872 04/22/2019 23 22 12 452 2 226 678 01/02/2018 47 26 35 489 1 0 489 2016-09-06 21 13 8 2 144 72 216 538 9 44 4 272276.00 4 8 7501 KEYSTONE DRIVE OMAHA, NE 68134 (41.299589, -96.027754) 02/01/2020
3363 911 S 3RD ST NILES, MI 49120 41.819191 -86.251737 0   235361 CHALET OF NILES, LLC 911 S 3RD ST NILES MI 49120 2696844320 100 Berrien For profit - Individual 100 54.6 Medicare and Medicaid false 07/01/1978 false   false false false Resident Yes 2   2   4   5   3   2   2       1.49935 0.84183 0.33979 1.18161 2.68097 0.02973 2.03126 0.70772 0.32533 3.06431 1.5341 0.89443 0.39311 2.80551 02/21/2019 17 10 7 88 2 44 132 09/13/2018 15 9 6 80 1 0 80 2018-03-30 28 19 15 1 342 0 342 149.667 17 35 2 406151.00 4 6 911 S 3RD ST NILES, MI 49120 (41.819191, -86.251737) 02/01/2020
6828 5211 W 103RD STREET OVERLAND PARK, KS 66207 38.942109 -94.645372 0   175180 OVERLAND PARK REHABILITATION AND HEALTHCARE 5211 W 103RD STREET OVERLAND PARK KS 66207 9133832569 450 Johnson For profit - Partnership 165 82.3 Medicare and Medicaid false 02/12/1989 false SFF false false false Resident Yes   18   18   18   18   18   18   18     2.73957 1.83296 1.10081 2.93377 5.67334 0.13951 2.06924 0.77908 0.40302 3.25133 2.75162 1.76911 1.02807 5.59539 07/11/2019 30 29 30 192 1 0 192 07/05/2018 64 13 64 1272 1 0 1272 2016-08-30 41 28 13 2 703 352 1055 695.833 14 81 4 210137.00 4 8 5211 W 103RD STREET OVERLAND PARK, KS 66207 (38.942109, -94.645372) 02/01/2020
7651 1800 INDIAN HILLS DRIVE SIOUX CITY, IA 51104 42.533789 -96.388623 0   165161 TOUCHSTONE HEALTHCARE COMMUNITY 1800 INDIAN HILLS DRIVE SIOUX CITY IA 51104 7122394582 960 Woodbury For profit - Corporation 125 69.7 Medicare and Medicaid false 07/01/1991 false SFF false false true Both Yes   18   18   18   18   18   18   18     1.86563 0.79857 0.48145 1.28001 3.14565 0.04084 2.06149 0.7361 0.36409 3.16168 1.88088 0.81575 0.49771 3.1904 09/19/2019 27 21 6 140 1 0 140 03/21/2019 19 13 8 132 1 0 132 2018-09-26 51 31 41 1 670 0 670 225.667 7 49 4 138811.00 4 8 1800 INDIAN HILLS DRIVE SIOUX CITY, IA 51104 (42.533789, -96.388623) 02/01/2020