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 12 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_ownership" = :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	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	subtotal_acute_beds	subprovider_ipf_beds	subprovider_irf_beds	skilled_nursing_beds	all_beds
576	CORE INSTITUTE SPECIALTY HOSPITAL, THE	6501 NORTH 19TH AVENUE	PHOENIX	AZ	85015	MARICOPA	(602) 795-6020	Acute Care Hospitals	Physician	FALSE	33.5318370	-112.0996140	0		13	4	4013	38060		Central	Maricopa County	https://data.medicare.gov/resource/xubh-q36u/row-ymwb.kuwb~xe6j	30108	659179	2019-06-03	2018-12-31	32		32				32
740	SPECIALISTS HOSPITAL SHREVEPORT	1500 LINE AVENUE	SHREVEPORT	LA	71101	CADDO	(318) 213-3800	Acute Care Hospitals	Physician	FALSE	32.4969260	-93.7460460	0		17	22	22017	43340		Central	Caddo Parish	https://data.medicare.gov/resource/xubh-q36u/row-kr9t-dd8q-wfhi	190278	649901	2019-06-03	2018-12-31	15		15				15
1305	UNITY MEDICAL CENTER	481 INTERSTATE DRIVE	MANCHESTER	TN	37355	COFFEE	(931) 728-6354	Acute Care Hospitals	Physician	TRUE	35.4979320	-86.0781410	0		31	47	47031	46100		Central	Coffee County	https://data.medicare.gov/resource/xubh-q36u/row-7ihq-cddj~pgik	440007	651231	2019-06-03	2018-12-31	49		49				49
2282	MENIFEE GLOBAL MEDICAL CENTER	28400 MCCALL B0ULEVARD	SUN CITY	CA	92585	RIVERSIDE	(951) 679-8888	Acute Care Hospitals	Physician	FALSE	33.7189772	-117.1681518	1	ROOFTOP	65	6	6065	40140	Los Angeles-Long Beach, CA	Central	Riverside County	https://data.medicare.gov/resource/xubh-q36u/row-rqjx-c4v4.2ewv	50684	651179	2019-06-03	2018-12-31	74	10	84				84
2285	HEMET VALLEY MEDICAL CENTER	1117 EAST DEVONSHIRE	HEMET	CA	92543	RIVERSIDE	(951) 652-2811	Acute Care Hospitals	Physician	TRUE	33.7512200	-116.9598590	0		65	6	6065	40140	Los Angeles-Long Beach, CA	Central	Riverside County	https://data.medicare.gov/resource/xubh-q36u/row-nd99_qqgq_fexi	50390	650949	2019-06-03	2018-12-31	286	18	304			113	417
2532	MONROE SURGICAL HOSPITAL	2408 BROADMOOR BLVD	MONROE	LA	71201	OUACHITA	(318) 410-0002	Acute Care Hospitals	Physician	FALSE	32.5367710	-92.1022040	0		73	22	22073	33740	Monroe-Ruston-Bastrop, LA	Central	Ouachita Parish	https://data.medicare.gov/resource/xubh-q36u/row-2viy_tht4-abuk	190245	650140	2019-06-03	2018-12-31	10		10				10
2624	SURGICAL SPECIALTY CENTER AT COORDINATED HEALTH	1503 CEDAR CREST BOULEVARD	ALLENTOWN	PA	18104	LEHIGH	(610) 871-9110	Acute Care Hospitals	Physician	FALSE	40.6121900	-75.5327500	0		77	42	42077	10900	New York-Newark, NY-NJ-CT-PA	Central	Lehigh County	https://data.medicare.gov/resource/xubh-q36u/row-ecs5-8dzv.54i7	390321	650522	2019-06-03	2018-12-31	20		20			12	32
3066	COORDINATED HEALTH ORTHOPEDIC HOSPITAL	2310 HIGHLAND AVENUE	BETHLEHEM	PA	18017	NORTHAMPTON	(610) 691-4300	Acute Care Hospitals	Physician	FALSE	40.6737620	-75.3654010	0		95	42	42095	10900	New York-Newark, NY-NJ-CT-PA	Central	Northampton County	https://data.medicare.gov/resource/xubh-q36u/row-sc4k-g4c8.mwqt	390314	651057	2019-06-03	2018-12-31	20		20				20
3191	SUTTER SURGICAL HOSPITAL - NORTH VALLEY	455 PLUMAS BLVD	YUBA CITY	CA	95991	SUTTER	(530) 749-5700	Acute Care Hospitals	Physician	FALSE	39.1321670	-121.6136030	0		101	6	6101	49700	Sacramento-Roseville, CA	Central	Sutter County	https://data.medicare.gov/resource/xubh-q36u/row-rm5f.jnvd.d3k4	50766	651185	2019-06-03	2018-12-31	14		14				14
3401	OKLAHOMA SPINE HOSPITAL	14101 PARKWAY COMMONS DRIVE	OKLAHOMA CITY	OK	73134	OKLAHOMA	(405) 749-2700	Acute Care Hospitals	Physician	TRUE	35.6141370	-97.5821240	0		109	40	40109	36420	Oklahoma City-Shawnee, OK	Central	Oklahoma County	https://data.medicare.gov/resource/xubh-q36u/row-g6tz_y8sg_qryk	370206	648756	2019-06-03	2018-12-31	23		23				23
4475	DOCTORS HOSPITAL AT RENAISSANCE	5501 SOUTH MCCOLL	EDINBURG	TX	78539	HIDALGO	(956) 362-8677	Acute Care Hospitals	Physician	TRUE	26.2524240	-98.2041090	0		215	48	48215	32580	McAllen-Edinburg, TX	Central	Hidalgo County	https://data.medicare.gov/resource/xubh-q36u/row-ie54-gr3x-shm2	450869	649837	2019-06-03	2018-12-31	287	58	394	87	38		519
4625	BAYLOR SCOTT & WHITE TEXAS SPINE & JOINT HOSPITAL	1814 ROSELAND BOULEVARD	TYLER	TX	75701	SMITH	(903) 525-3300	Acute Care Hospitals	Physician	TRUE	32.3292480	-95.2994670	0		423	48	48423	46340	Tyler-Jacksonville, TX	Central	Smith County	https://data.medicare.gov/resource/xubh-q36u/row-id2a~8wab-iya8	450864	649358	2019-06-03	2018-12-31	20		20				20