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

18 rows where centraloutlyingcounty = "Central" and "filed_date" is on date 2019-05-22

View and edit SQL

Suggested facets: city, state, county_name, hospital_type, hospital_ownership, emergency_services, geocode_flag, geocode_accuracy, countyfips, statefips, statecountyfips, cbsacode, csatitle, countyequivalent, fy_end_date, acute_beds, icu_beds, coronary_beds, oth_spec_beds, subtotal_acute_beds, subprovider_ipf_beds, subprovider_irf_beds, all_beds, filed_date (date), fy_end_date (date)

Link 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
302 LOVELACE REGIONAL HOSPITAL - ROSWELL 117 EAST 19TH STREET ROSWELL NM 88201 CHAVES (575) 625-3345 Acute Care Hospitals Voluntary non-profit - Private TRUE 33.4159760 -104.5217540 0   5 35 35005 40740   Central Chaves County https://data.medicare.gov/resource/xubh-q36u/row-y4jq.pkc3~jyui 320086 648014 2019-05-22 2018-12-31 23 4         27               27
312 PROVIDENCE WILLAMETTE FALLS MEDICAL CENTER 1500 DIVISION STREET OREGON CITY OR 97045 CLACKAMAS (503) 657-6915 Acute Care Hospitals Voluntary non-profit - Private TRUE 45.3566470 -122.5883710 0   5 41 41005 38900 Portland-Vancouver-Salem, OR-WA Central Clackamas County https://data.medicare.gov/resource/xubh-q36u/row-4zvi_yd6d-6gyq 380038 648648 2019-05-22 2018-12-31 103 8         111               111
556 ARIZONA SPECIALTY HOSPITAL 2905 WEST WARNER ROAD, SUITE 1 CHANDLER AZ 85224 MARICOPA (480) 603-9000 Acute Care Hospitals Proprietary FALSE 33.3348400 -111.8911330 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-z5xq-7gkm.mjtq 30112 649698 2019-05-22 2018-12-31 24           24               24
611 HOLYOKE MEDICAL CENTER 575 BEECH STREET HOLYOKE MA 1040 HAMPDEN (413) 534-2500 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.1996160 -72.6270870 0   13 25 25013 44140 Springfield-Greenfield Town, MA Central Hampden County https://data.medicare.gov/resource/xubh-q36u/row-qqxc_2ssq-uqu2 220024 648388 2019-05-22 2018-09-30 147 12 6       165 20             185
1207 MAYO CLINIC 4500 SAN PABLO RD JACKSONVILLE FL 32224 DUVAL (904) 953-2000 Acute Care Hospitals Voluntary non-profit - Private TRUE 30.2637020 -81.4375330 0   31 12 12031 27260 Jacksonville-St. Marys-Palatka, FL-GA Central Duval County https://data.medicare.gov/resource/xubh-q36u/row-5qpc-23s6_wtm9 100151 649417 2019-05-22 2018-12-31 223 54         277               277
1419 ST VINCENT CHARITY MEDICAL CENTER 2351 EAST 22ND STREET CLEVELAND OH 44115 CUYAHOGA (216) 861-6200 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.4956950 -81.6742750 0   35 39 39035 17460 Cleveland-Akron-Canton, OH Central Cuyahoga County https://data.medicare.gov/resource/xubh-q36u/row-gmvk-ge5g_hqfc 360037 648454 2019-05-22 2018-12-31 106 10 10       126 71             197
1433 THE ORTHOPEDIC SPECIALTY HOSPITAL 5848 SOUTH 300 EAST MURRAY UT 84107 SALT LAKE (801) 314-4100 Acute Care Hospitals Voluntary non-profit - Private FALSE 40.6441568 -111.8834631 1 ROOFTOP 35 49 49035 41620 Salt Lake City-Provo-Orem, UT Central Salt Lake County https://data.medicare.gov/resource/xubh-q36u/row-q8pf_69d4-hzq3 460049 648660 2019-05-22 2018-12-31 40           40               40
1440 LDS HOSPITAL 8TH AVENUE AND C STREET SALT LAKE CITY UT 84143 SALT LAKE (801) 408-1100 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.7785090 -111.8805760 0   35 49 49035 41620 Salt Lake City-Provo-Orem, UT Central Salt Lake County https://data.medicare.gov/resource/xubh-q36u/row-ts9q.8fzp.3p9n 460006 649001 2019-05-22 2018-12-31 188 28         216 34             250
1570 SAINT THOMAS HOSPITAL FOR SPECIALTY SURGERY 2011 MURPHY AVENUE NASHVILLE TN 37203 DAVIDSON (615) 515-8200 Acute Care Hospitals Voluntary non-profit - Other FALSE 36.1557640 -86.8038890 0   37 47 47037 34980 Nashville-Davidson--Murfreesboro, TN Central Davidson County https://data.medicare.gov/resource/xubh-q36u/row-utm3-5xwp_5vj4 440218 648763 2019-05-22 2018-12-31 23           23               23
1879 AMERICAN FORK HOSPITAL 170 NORTH 1100 EAST AMERICAN FORK UT 84003 UTAH (801) 855-3305 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.3805060 -111.7690940 0   49 49 49049 39340 Salt Lake City-Provo-Orem, UT Central Utah County https://data.medicare.gov/resource/xubh-q36u/row-s7aj~ypv9~6tcc 460023 648658 2019-05-22 2018-12-31 73 18         91               91
1935 HEBER VALLEY HOSPITAL 1485 SOUTH HIGHWAY 40 HEBER CITY UT 84032 WASATCH (435) 654-2500 Critical Access Hospitals Voluntary non-profit - Private TRUE 40.4890470 -111.4092180 0   51 49 49051 25720 Salt Lake City-Provo-Orem, UT Central Wasatch County https://data.medicare.gov/resource/xubh-q36u/row-8mif.5tu6.xu7b 461307 648498 2019-05-22 2018-12-31 19           19               19
3030 NEMOURS CHILDREN'S HOSPITAL 13535 NEMOURS PKWY ORLANDO FL 32827 ORANGE (407) 567-4000 Childrens Voluntary non-profit - Private TRUE 28.3749080 -81.2766940 0   95 12 12095 36740 Orlando-Deltona-Daytona Beach, FL Central Orange County https://data.medicare.gov/resource/xubh-q36u/row-7q2m-thri-ffzb 103304 648095 2019-05-22 2018-12-31 49 28       18 100               100
3032 ADVENTHEALTH ORLANDO 601 E ROLLINS ST ORLANDO FL 32803 ORANGE (407) 303-1976 Acute Care Hospitals Voluntary non-profit - Private TRUE 28.5734570 -81.3703280 0   95 12 12095 36740 Orlando-Deltona-Daytona Beach, FL Central Orange County https://data.medicare.gov/resource/xubh-q36u/row-4fra_j2em.99x3 100007 648798 2019-05-22 2018-12-31 2256 221 40       2753 43 30           2826
3328 FORT LOUDON MEDICAL CENTER 550 FORT LOUDON MEDICAL CENTER DR LENOIR CITY TN 37772 LOUDON (865) 271-6000 Acute Care Hospitals Voluntary non-profit - Other TRUE 35.8271080 -84.2717520 0   105 47 47105 28940 Knoxville-Morristown-Sevierville, TN Central Loudon County https://data.medicare.gov/resource/xubh-q36u/row-dzf9.pf9q_tv6s 440110 648209 2019-05-22 2018-12-31 25 5         30               30
3746 PORTER REGIONAL HOSPITAL 85 EAST US HWY 6 VALPARAISO IN 46383 PORTER (219) 983-8300 Acute Care Hospitals Proprietary TRUE 41.5500700 -87.0513160 0   127 18 18127 16980 Chicago-Naperville, IL-IN-WI Central Porter County https://data.medicare.gov/resource/xubh-q36u/row-i5mx.x2ra~mmtd 150035 648101 2019-05-22 2018-12-31 192 32         238   14           252
3951 BELLEVUE HOSPITAL 1400 WEST MAIN STREET BELLEVUE OH 44811 SANDUSKY (419) 483-4040 Acute Care Hospitals Voluntary non-profit - Other TRUE 41.2850800 -82.8825590 0   143 39 39143 23380   Central Sandusky County https://data.medicare.gov/resource/xubh-q36u/row-dxdd_2hgt.meqt 360107 648967 2019-05-22 2018-12-31 40 10         50               50
4046 MERCY MEDICAL CENTER 1320 MERCY DRIVE NW CANTON OH 44708 STARK (330) 489-1080 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.8123210 -81.3970690 0   151 39 39151 15940 Cleveland-Akron-Canton, OH Central Stark County https://data.medicare.gov/resource/xubh-q36u/row-wtxu~2u95.qas6 360070 648455 2019-05-22 2018-12-31 257 36 16       317   21           338
4646 BAYLOR SCOTT AND WHITE ORTHOPEDIC AND SPINE HOSPI 707 HIGHLANDER BLVD ARLINGTON TX 76015 TARRANT (817) 549-2364 Acute Care Hospitals Proprietary TRUE 32.6821530 -97.1172180 0   439 48 48439 19100 Dallas-Fort Worth, TX-OK Central Tarrant County https://data.medicare.gov/resource/xubh-q36u/row-4bwe.2jky-j5da 670067 648584 2019-05-22 2018-12-31 24           24               24

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [hospital_data] (
   [hospital_name] TEXT,
   [address] TEXT,
   [city] TEXT,
   [state] TEXT,
   [zip_code] INTEGER,
   [county_name] TEXT,
   [phone_number] TEXT,
   [hospital_type] TEXT,
   [hospital_ownership] TEXT,
   [emergency_services] TEXT,
   [lat] TEXT,
   [lng] TEXT,
   [geocode_flag] INTEGER,
   [geocode_accuracy] TEXT,
   [countyfips] INTEGER,
   [statefips] INTEGER,
   [statecountyfips] INTEGER,
   [cbsacode] TEXT,
   [csatitle] TEXT,
   [centraloutlyingcounty] TEXT,
   [countyequivalent] TEXT,
   [hosp_lookup_url] TEXT,
   [PRVDR_NUM] INTEGER,
   [RPT_REC_NUM] INTEGER,
   [filed_date] TEXT,
   [fy_end_date] TEXT,
   [acute_beds] INTEGER,
   [icu_beds] TEXT,
   [coronary_beds] TEXT,
   [burn_beds] TEXT,
   [surg_icu_beds] TEXT,
   [oth_spec_beds] TEXT,
   [subtotal_acute_beds] INTEGER,
   [subprovider_ipf_beds] TEXT,
   [subprovider_irf_beds] TEXT,
   [subprovider_oth_beds] TEXT,
   [skilled_nursing_beds] TEXT,
   [nursing_fac_beds] TEXT,
   [oth_longterm_beds] TEXT,
   [hospice_beds] TEXT,
   [all_beds] INTEGER
);