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 5 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
1178 METHODIST STONE OAK HOSPITAL 1139 E SONTERRA BLVD, STE 535 SAN ANTONIO TX 78258 BEXAR (210) 638-2100 Acute Care Hospitals Proprietary TRUE 29.6144940 -98.4754590 0   29 48 48029 41700   Central Bexar County https://data.medicare.gov/resource/xubh-q36u/row-32ag-t8fj-9ybq 670055 652855 2019-07-31 2019-02-28 175 28       24 227   15           242
2533 GLENWOOD REGIONAL MEDICAL CENTER 503 MCMILLAN ROAD WEST MONROE LA 71291 OUACHITA (318) 329-4600 Acute Care Hospitals Proprietary TRUE 32.5134620 -92.1567610 0   73 22 22073 33740 Monroe-Ruston-Bastrop, LA Central Ouachita Parish https://data.medicare.gov/resource/xubh-q36u/row-p2i2~hyuu~bqfj 190160 652655 2019-07-31 2019-02-28 164 44       6 214 40 16   14       284
3199 REGIONAL MEDICAL CENTER BAYONET POINT 14000 FIVAY RD HUDSON FL 34667 PASCO (727) 819-2929 Acute Care Hospitals Proprietary TRUE 28.3607430 -82.6901480 0   101 12 12101 45300   Central Pasco County https://data.medicare.gov/resource/xubh-q36u/row-burc_j8eh.zcc8 100256 652643 2019-07-31 2019-02-28 230 20 40       290               290
4437 WOMANS HOSPITAL OF TEXAS,THE 7600 FANNIN HOUSTON TX 77054 HARRIS (713) 790-1234 Acute Care Hospitals Proprietary TRUE 29.6929770 -95.4010900 0   201 48 48201 26420 Houston-The Woodlands, TX Central Harris County https://data.medicare.gov/resource/xubh-q36u/row-pvha_dpmv~q2t2 450674 652609 2019-07-31 2019-02-28 253 4         257               257
4703 ROUND ROCK MEDICAL CENTER 2400 ROUND ROCK AVE ROUND ROCK TX 78681 WILLIAMSON (512) 341-1000 Acute Care Hospitals Proprietary TRUE 30.5093360 -97.7123610 0   491 48 48491 12420   Central Williamson County https://data.medicare.gov/resource/xubh-q36u/row-jpx8_mm4d-nyqm 450718 652275 2019-07-31 2019-02-28 127 18       12 157   12           169