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
1173 COLLETON MEDICAL CENTER 501 ROBERTSON BOULEVARD WALTERBORO SC 29488 COLLETON (843) 782-2000 Acute Care Hospitals Proprietary TRUE 32.9218550 -80.6708800 0   29 45 45029         https://data.medicare.gov/resource/xubh-q36u/row-429y~gw6b~pgj2 420030 648315 2019-05-24 2018-12-31 94 8         102 19 14           135
1197 MEDICAL CENTER ENTERPRISE 400 N EDWARDS STREET ENTERPRISE AL 36330 COFFEE (334) 347-0584 Acute Care Hospitals Proprietary TRUE 31.3181910 -85.8553080 0   31 1 1031 21460 Dothan-Enterprise-Ozark, AL Central Coffee County https://data.medicare.gov/resource/xubh-q36u/row-m58x_64pa.z9zi 10049 648587 2019-05-24 2018-12-31 92 7         99               99
1205 ROSE MEDICAL CENTER 4567 E 9TH AVE DENVER CO 80220 DENVER (303) 320-2121 Acute Care Hospitals Proprietary TRUE 39.7310760 -104.9340110 0   31 8 8031 19740 Denver-Aurora, CO Central Denver County https://data.medicare.gov/resource/xubh-q36u/row-d89y.4k32_5asy 60032 649400 2019-05-24 2018-12-31 167 35       24 226               226
3503 PINE CREEK MEDICAL CENTER LLP 9032 HARRY HINES BLVD DALLAS TX 75235 DALLAS (214) 231-2273 Acute Care Hospitals Proprietary TRUE 32.8401610 -96.8688350 0   113 48 48113 19100 Dallas-Fort Worth, TX-OK Central Dallas County https://data.medicare.gov/resource/xubh-q36u/row-yjax~idz9_awg3 450894 648768 2019-05-24 2018-12-31 15           15               15
3521 DOCTORS HOSPITAL OF SARASOTA 5731 BEE RIDGE RD SARASOTA FL 34233 SARASOTA (941) 342-1100 Acute Care Hospitals Proprietary TRUE 27.2989750 -82.4548480 0   115 12 12115 35840 North Port-Sarasota, FL Central Sarasota County https://data.medicare.gov/resource/xubh-q36u/row-5phw~tq29_truf 100166 651508 2019-05-24 2018-12-31 123 16         139 16             155
3648 MERIT HEALTH RANKIN 350 CROSSGATES BLVD BRANDON MS 39042 RANKIN (601) 825-2811 Acute Care Hospitals Proprietary TRUE 32.2862140 -90.0359600 0   121 28 28121 27140 Jackson-Vicksburg-Brookhaven, MS Central Rankin County https://data.medicare.gov/resource/xubh-q36u/row-cu6y_iea7.rvw5 250096 648279 2019-05-24 2018-12-31 106 8         114 20             134
4246 WOMEN'S HOSPITAL THE 4199 GATEWAY BLVD NEWBURGH IN 47630 WARRICK (812) 842-4200 Acute Care Hospitals Proprietary TRUE 37.9735480 -87.4491090 0   173 18 18173 21780   Central Warrick County https://data.medicare.gov/resource/xubh-q36u/row-rn9t.t87t.eat4 150149 648611 2019-05-24 2018-12-31 50 24         74               74
4608 QUAIL CREEK SURGICAL HOSPITAL 6819 PLUM CREEK AMARILLO TX 79124 POTTER (806) 354-6100 Acute Care Hospitals Proprietary TRUE 35.2106750 -101.9135680 0   375 48 48375 11100 Amarillo-Borger, TX Central Potter County https://data.medicare.gov/resource/xubh-q36u/row-3fht_yhjz.yec5 450875 648767 2019-05-24 2018-12-31 32           32               32