hospital_data

Table actions
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

29 rows where "filed_date" is on date 2019-05-22

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

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

filed_date (date) ✖

  • 2019-05-22 · 29 ✖
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 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
311 311 ATOKA COUNTY MEDICAL CENTER 1590 WEST LIBERTY ROAD ATOKA OK 74525 ATOKA (580) 889-3333 Critical Access Hospitals Government - Hospital District or Authority TRUE 34.3952620 -96.1594880 0   5 40 40005         https://data.medicare.gov/resource/xubh-q36u/row-qvh3-hh93~canr 371300 649482 2019-05-22 2018-12-31 25           25               25
312 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 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 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
1110 1110 FILLMORE COMMUNITY HOSPITAL 674 SOUTH HIGHWAY 99 FILLMORE UT 84631 MILLARD (435) 743-5591 Critical Access Hospitals Voluntary non-profit - Private FALSE 38.9541610 -112.3394550 0   27 49 49027         https://data.medicare.gov/resource/xubh-q36u/row-qrf9_kxm9-tj3a 461301 648497 2019-05-22 2018-12-31 19           19               19
1143 1143 SANFORD BAGLEY MEDICAL CENTER 203 4TH STREET NORTHWEST BAGLEY MN 56621 CLEARWATER (218) 694-6501 Critical Access Hospitals Voluntary non-profit - Private TRUE 47.5258370 -95.4016760 0   29 27 27029         https://data.medicare.gov/resource/xubh-q36u/row-n7dg.2zvq~dkw4 241328 649453 2019-05-22 2018-12-31 25           25               25
1207 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 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 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 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 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
1576 1576 JEFFERSON MEDICAL CENTER 300 SOUTH PRESTON STREET RANSON WV 25438 JEFFERSON (304) 728-1600 Critical Access Hospitals Voluntary non-profit - Private TRUE 39.2959710 -77.8582650 0   37 54 54037 47900 Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Outlying Jefferson County https://data.medicare.gov/resource/xubh-q36u/row-ix2t~enbf.ekjg 511319 649005 2019-05-22 2018-12-31 20 5         25               25
1879 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 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
2306 2306 MADISON PARISH HOSPITAL 900 JOHNSON STREET TALLULAH LA 71282 MADISON (318) 574-2374 Critical Access Hospitals Government - Hospital District or Authority TRUE 32.4037340 -91.1855030 0   65 22 22065         https://data.medicare.gov/resource/xubh-q36u/row-5rgc_wpty_n97z 191314 648538 2019-05-22 2018-12-31 25           25               25
2331 2331 MEMORIAL HOSPITAL OF LAFAYETTE COUNTY 800 CLAY ST DARLINGTON WI 53530 LAFAYETTE (608) 776-4466 Critical Access Hospitals Government - Local TRUE 42.6839700 -90.1104190 0   65 55 55065         https://data.medicare.gov/resource/xubh-q36u/row-9ib5-tfyn~k464 521312 649522 2019-05-22 2018-12-31 25           25               25
2480 2480 HIGHLAND DISTRICT HOSPITAL 1275 NORTH HIGH STREET HILLSBORO OH 45133 HIGHLAND (937) 393-6100 Critical Access Hospitals Government - Hospital District or Authority TRUE 39.2215760 -83.6087710 0   71 39 39071         https://data.medicare.gov/resource/xubh-q36u/row-8tax-6wz7_d86d 361332 648465 2019-05-22 2018-12-31 25           25 10             35
2483 2483 PROVIDENCE NEWBERG MEDICAL CENTER 1001 PROVIDENCE DRIVE NEWBERG OR 97132 YAMHILL (503) 537-1555 Acute Care Hospitals Voluntary non-profit - Church TRUE 45.3085520 -122.9339130 0   71 41 41071 38900 Portland-Vancouver-Salem, OR-WA Outlying Yamhill County https://data.medicare.gov/resource/xubh-q36u/row-zttx-g4s5_qqvh 380037 648647 2019-05-22 2018-12-31 36 4         40               40
3030 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 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
3267 3267 AVALA 67252 INDUSTRY LANE COVINGTON LA 70433 ST. TAMMANY (985) 801-3010 Acute Care Hospitals Physician FALSE 30.4087130 -90.0829430 0   103 22 22103 35380 New Orleans-Metairie-Hammond, LA-MS Outlying St. Tammany Parish https://data.medicare.gov/resource/xubh-q36u/row-rabs-2sar-uqwy 190267 648930 2019-05-22 2018-12-31 21           21               21
3328 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
3456 3456 MENA REGIONAL HEALTH SYSTEM 311 NORTH MORROW STREET MENA AR 71953 POLK (479) 394-6100 Acute Care Hospitals Government - Local TRUE 34.5883860 -94.2213830 0   113 5 5113         https://data.medicare.gov/resource/xubh-q36u/row-wwwj_a4gs~ixth 40015 648521 2019-05-22 2018-12-31 35 6         41 12 12           65
3520 3520 SEDGWICK COUNTY MEMORIAL HOSPITAL 900 CEDAR ST JULESBURG CO 80737 SEDGWICK (970) 474-3323 Critical Access Hospitals Government - Local FALSE 40.9937430 -102.2692320 0   115 8 8115         https://data.medicare.gov/resource/xubh-q36u/row-ptjm_bmz6~8mzz 61310 649075 2019-05-22 2018-12-31 9           9         32     41
3746 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 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 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 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
);