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)

select rowid, hospital_name, address, city, state, zip_code, county_name, phone_number, hospital_type, hospital_ownership, emergency_services, lat, lng, geocode_flag, geocode_accuracy, countyfips, statefips, statecountyfips, cbsacode, csatitle, centraloutlyingcounty, countyequivalent, hosp_lookup_url, PRVDR_NUM, RPT_REC_NUM, filed_date, fy_end_date, acute_beds, icu_beds, coronary_beds, burn_beds, surg_icu_beds, oth_spec_beds, subtotal_acute_beds, subprovider_ipf_beds, subprovider_irf_beds, subprovider_oth_beds, skilled_nursing_beds, nursing_fac_beds, oth_longterm_beds, hospice_beds, all_beds from hospital_data where date("filed_date") = :p0 and "hospital_type" = :p1 order by rowid limit 101

Query parameters

This data as json, copyable, CSV

rowid	hospital_name	address	city	state	zip_code	county_name	phone_number	hospital_type	hospital_ownership	emergency_services	lat	lng	countyfips	statefips	statecountyfips	cbsacode	csatitle	centraloutlyingcounty	countyequivalent	hosp_lookup_url	PRVDR_NUM	RPT_REC_NUM	filed_date	fy_end_date	acute_beds	icu_beds	coronary_beds	burn_beds	oth_spec_beds	subtotal_acute_beds	all_beds
3254	JOHNS HOPKINS ALL CHILDREN'S HOSPITAL	501 SIXTH AVENUE SOUTH	SAINT PETERSBURG	FL	33701	PINELLAS	(813) 898-7451	Childrens	Voluntary non-profit - Other	TRUE	27.7642490	-82.6410120	103	12	12103	45300		Central	Pinellas County	https://data.medicare.gov/resource/xubh-q36u/row-rxaq~253f.593c	103300	661485	2019-12-03	2019-06-30	112	28	22		97	259	259
3583	ARKANSAS CHILDREN'S HOSPITAL	1 CHILDREN'S WAY, SLOT 301	LITTLE ROCK	AR	72202	PULASKI	(501) 364-1100	Childrens	Voluntary non-profit - Private	TRUE	34.7428220	-92.2920060	119	5	5119	30780	Little Rock-North Little Rock, AR	Central	Pulaski County	https://data.medicare.gov/resource/xubh-q36u/row-p66z~xhi7.pxk4	43300	660352	2019-12-03	2019-06-30	153	26	30	10	104	336	336
3940	ARKANSAS CHILDREN'S NORTHWEST, INC	2601 GENE GEORGE BOULEVARD	SPRINGDALE	AR	72762	WASHINGTON	(479) 725-6800	Childrens	Voluntary non-profit - Private	TRUE	36.1633250	-94.1926020	143	5	5143	22220		Central	Washington County	https://data.medicare.gov/resource/xubh-q36u/row-ancy_ajta_8yhj	43301	660747	2019-12-03	2019-06-30	24					24	24
4561	COVENANT CHILDRENS HOSPITAL	4015 22ND PLACE	LUBBOCK	TX	79410	LUBBOCK	(806) 725-7975	Childrens	Voluntary non-profit - Private	TRUE	33.5741410	-101.9004260	303	48	48303	31180	Lubbock-Levelland, TX	Central	Lubbock County	https://data.medicare.gov/resource/xubh-q36u/row-a699~c7jg~uc7g	453306	660895	2019-12-03	2019-06-30	138	20			46	204	204