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 2 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
385 OUR LADY OF FATIMA HOSPITAL 200 HIGH SERVICE AVENUE NORTH PROVIDENCE RI 2904 PROVIDENCE (401) 456-3000 Acute Care Hospitals Proprietary TRUE 41.8557960 -71.4584980 0   7 44 44007 39300 Boston-Worcester-Providence, MA-RI-NH-CT Central Providence County https://data.medicare.gov/resource/xubh-q36u/row-ya2z~83y5.tnki 410005 650779 2019-05-30 2018-12-31 148 15         163 124 25           312
1519 ENCINO HOSPITAL MEDICAL CENTER 16237 VENTURA BLVD ENCINO CA 91436 LOS ANGELES (818) 995-5000 Acute Care Hospitals Proprietary FALSE 34.1568260 -118.4869480 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-9gh4~7pmm-pjtp 50158 652415 2019-05-30 2018-12-31 60   22       82 13 25   28       148