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 8 rows (hide)

Query parameters

rowidhospital_nameaddresscitystatezip_codecounty_namephone_numberhospital_typehospital_ownershipemergency_serviceslatlnggeocode_flaggeocode_accuracycountyfipsstatefipsstatecountyfipscbsacodecsatitlecentraloutlyingcountycountyequivalenthosp_lookup_urlPRVDR_NUMRPT_REC_NUMfiled_datefy_end_dateacute_bedsicu_bedscoronary_bedsburn_bedssurg_icu_bedsoth_spec_bedssubtotal_acute_bedssubprovider_ipf_bedssubprovider_irf_bedssubprovider_oth_bedsskilled_nursing_bedsnursing_fac_bedsoth_longterm_bedshospice_bedsall_beds
215 HACKENSACK MERIDIAN HEALTH PASCACK VALLEY MEDICAL 250 OLD HOOK ROAD WESTWOOD NJ 7675 BERGEN (201) 383-1035 Acute Care Hospitals Proprietary TRUE 40.9836580 -74.0141950 0   3 34 34003 35620 New York-Newark, NY-NJ-CT-PA Central Bergen County https://data.medicare.gov/resource/xubh-q36u/row-kwcd-72qg_ygd9 310130 660416 2019-11-25 2019-06-30 64 9         78               78
359 MIDMICHIGAN MEDICAL CENTER - ALPENA 1501 W CHISHOLM ST ALPENA MI 49707 ALPENA (989) 356-7390 Acute Care Hospitals Proprietary TRUE 45.0768570 -83.4506720 0   7 26 26007 10980   Central Alpena County https://data.medicare.gov/resource/xubh-q36u/row-3cst~3hfe~ssf7 230036 660579 2019-11-25 2019-06-30 119 9         128   11           139
714 SAINT THOMAS STONES RIVER HOSPITAL 324 DOOLITTLE ROAD WOODBURY TN 37190 CANNON (615) 563-4001 Acute Care Hospitals Proprietary TRUE 35.8328650 -86.0729430 0   15 47 47015 34980 Nashville-Davidson--Murfreesboro, TN Outlying Cannon County https://data.medicare.gov/resource/xubh-q36u/row-cff9_8h9t.y7xa 440200 659459 2019-11-25 2019-06-30 30           30 22             52
2002 REGIONAL MEDICAL CENTER 709 W MAIN STREET MANCHESTER IA 52057 DELAWARE (563) 927-3232 Critical Access Hospitals Proprietary TRUE 42.4839030 -91.4666440 0   55 19 19055         https://data.medicare.gov/resource/xubh-q36u/row-znx9.yjf2.jpru 161343 660219 2019-11-25 2019-06-30 25           25           1   26
2504 GRANDVIEW MEDICAL CENTER 3690 GRANDVIEW PARKWAY BIRMINGHAM AL 35243 JEFFERSON (205) 971-1000 Acute Care Hospitals Proprietary TRUE 33.4343630 -86.7204830 0   73 1 1073 13820 Birmingham-Hoover-Talladega, AL Central Jefferson County https://data.medicare.gov/resource/xubh-q36u/row-pwut_di96_m4tu 10104 660349 2019-11-25 2019-06-30 289 72         373 12 17           402
3525 REDMOND REGIONAL MEDICAL CENTER 501 REDMOND ROAD ROME GA 30165 FLOYD (706) 802-3012 Acute Care Hospitals Proprietary TRUE 34.2781910 -85.1941310 0   115 13 13115 40660 Rome-Summerville, GA Central Floyd County https://data.medicare.gov/resource/xubh-q36u/row-z5aw~bjka~vbtd 110168 659773 2019-11-25 2019-06-30 168 16 24       208   20           228
4330 SAINT THOMAS HIGHLANDS HOSPITAL 401 SEWELL DR SPARTA TN 38583 WHITE (931) 738-9211 Acute Care Hospitals Proprietary TRUE 35.9481200 -85.4770740 0   185 47 47185         https://data.medicare.gov/resource/xubh-q36u/row-kw75.zwj7_gsiz 440192 660314 2019-11-25 2019-06-30 28 4         32 14             46
4417 HCA HOUSTON HEALTHCARE TOMBALL 605 HOLDERRIETH TOMBALL TX 77375 HARRIS (281) 351-1623 Acute Care Hospitals Proprietary TRUE 30.0887030 -95.6239850 0   201 48 48201 26420 Houston-The Woodlands, TX Central Harris County https://data.medicare.gov/resource/xubh-q36u/row-qwg3~p4ci.ubu8 450670 659543 2019-11-25 2019-06-30 167 20       7 194 21 26           241