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

36 rows where "filed_date" is on date 2019-12-02 and hospital_ownership = "Government - Local"

View and edit SQL

Suggested facets: state, hospital_type, emergency_services, geocode_flag, geocode_accuracy, statefips, cbsacode, csatitle, centraloutlyingcounty, countyequivalent, acute_beds, icu_beds, coronary_beds, oth_spec_beds, subtotal_acute_beds, subprovider_ipf_beds, subprovider_irf_beds, skilled_nursing_beds, oth_longterm_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
17 VAN DIEST MEDICAL CENTER 2350 HOSPITAL DRIVE WEBSTER CITY IA 50595 HAMILTON (515) 832-9400 Critical Access Hospitals Government - Local TRUE 42.4529630 -93.8134850 0   79 19 19079         https://data.medicare.gov/resource/xubh-q36u/row-89tb_yu6c_zwc4 161361 660984 2019-12-02 2019-06-30 25           25               25
35 HAWARDEN REGIONAL HEALTHCARE 1111 11TH STREET HAWARDEN IA 51023 SIOUX (712) 551-3100 Critical Access Hospitals Government - Local TRUE 42.9980080 -96.4794270 0   167 19 19167         https://data.medicare.gov/resource/xubh-q36u/row-i52u~xknc.njpg 161311 660957 2019-12-02 2019-06-30 25           25               25
69 ADAIR COUNTY MEMORIAL HOSPITAL 609 SE KENT GREENFIELD IA 50849 ADAIR (641) 743-2123 Critical Access Hospitals Government - Local TRUE 41.3031030 -94.4519270 0   1 19 19001         https://data.medicare.gov/resource/xubh-q36u/row-3dt7_nstz~yhhy 161310 660956 2019-12-02 2019-06-30 25           25               25
274 VETERANS MEMORIAL HOSPITAL 40 1ST STREET SE WAUKON IA 52172 ALLAMAKEE (563) 568-3411 Critical Access Hospitals Government - Local TRUE 43.2680920 -91.4744460 0   5 19 19005         https://data.medicare.gov/resource/xubh-q36u/row-kmrq-g36y.pe5i 161318 660959 2019-12-02 2019-06-30 25           25               25
329 BOONE MEMORIAL HOSPITAL 701 MADISON AVENUE MADISON WV 25130 BOONE (304) 369-1230 Critical Access Hospitals Government - Local TRUE 38.0486360 -81.8065320 0   5 54 54005 16620 Charleston-Huntington-Ashland, WV-OH-KY Outlying Boone County https://data.medicare.gov/resource/xubh-q36u/row-r4j3~ibqd.28ff 511313 661267 2019-12-02 2019-06-30 25           25               25
469 WEIRTON MEDICAL CENTER 601 COLLIERS WAY WEIRTON WV 26062 HANCOCK (304) 797-6000 Acute Care Hospitals Government - Local TRUE 40.3937260 -80.5297390 0   9 54 54009 48260 Pittsburgh-New Castle-Weirton, PA-OH-WV Central Brooke County https://data.medicare.gov/resource/xubh-q36u/row-kane-jbhj.6jim 510023 661436 2019-12-02 2019-06-30 117 10         127   7   33       167
587 CONTRA COSTA REGIONAL MEDICAL CENTER 2500 ALHAMBRA AVENUE MARTINEZ CA 94553 CONTRA COSTA (925) 370-5000 Acute Care Hospitals Government - Local TRUE 38.0064670 -122.1308910 0   13 6 6013 41860 San Jose-San Francisco-Oakland, CA Outlying Contra Costa County https://data.medicare.gov/resource/xubh-q36u/row-iuri_7t24.rw23 50276 660491 2019-12-02 2019-06-30 110 8       6 124 23             147
622 BOX BUTTE GENERAL HOSPITAL P O BOX 810, 2101 BOX BUTTE AVE ALLIANCE NE 69301 BOX BUTTE (308) 762-6660 Critical Access Hospitals Government - Local TRUE 42.0984344 -102.8703880 1 ROOFTOP 13 31 31013         https://data.medicare.gov/resource/xubh-q36u/row-gsu6_furw.wta3 281360 661047 2019-12-02 2019-06-30 25           25               25
681 BOONE COUNTY HOSPITAL 1015 UNION STREET BOONE IA 50036 BOONE (515) 432-3140 Critical Access Hospitals Government - Local TRUE 42.0555830 -93.8770370 0   15 19 19015 14340 Des Moines-Ames-West Des Moines, IA Central Boone County https://data.medicare.gov/resource/xubh-q36u/row-6zpe~cgwm_xs5p 161372 660987 2019-12-02 2019-06-30 25           25               25
752 CAMBRIDGE HEALTH ALLIANCE 1493 CAMBRIDGE STREET CAMBRIDGE MA 2138 MIDDLESEX (617) 665-2300 Acute Care Hospitals Government - Local TRUE 42.3741860 -71.1044550 0   17 25 25017 14460 Boston-Worcester-Providence, MA-RI-NH-CT Central Middlesex County https://data.medicare.gov/resource/xubh-q36u/row-gyrk~893u_u5y7 220011 662215 2019-12-02 2019-06-30 182 18         200 62             262
964 BUTLER COUNTY HEALTH CARE CENTER 372 SOUTH 9TH ST DAVID CITY NE 68632 BUTLER (402) 367-1200 Critical Access Hospitals Government - Local TRUE 41.2464710 -97.1230380 0   23 31 31023         https://data.medicare.gov/resource/xubh-q36u/row-u7xr~dyr4.b4xb 281332 661041 2019-12-02 2019-06-30 20           20               20
994 EL CENTRO REGIONAL MEDICAL CENTER 1415 ROSS AVENUE EL CENTRO CA 92243 IMPERIAL (760) 339-7100 Acute Care Hospitals Government - Local TRUE 32.7814980 -115.5686200 0   25 6 6025 20940   Central Imperial County https://data.medicare.gov/resource/xubh-q36u/row-35st~i7ay-x3eh 50045 660164 2019-12-02 2019-06-30 141 20         161               161
1376 SHERIDAN MEMORIAL HOSPITAL 1401 W 5TH ST SHERIDAN WY 82801 SHERIDAN (307) 672-1044 Acute Care Hospitals Government - Local TRUE 44.8074250 -106.9755700 0   33 56 56033 43260   Central Sheridan County https://data.medicare.gov/resource/xubh-q36u/row-kh7n.rjz9.bakb 530006 661690 2019-12-02 2019-06-30 60 11         71               71
1577 MEMORIAL HOSPITAL SWEETWATER COUNTY 1200 COLLEGE DRIVE ROCK SPRINGS WY 82901 SWEETWATER (307) 362-3711 Acute Care Hospitals Government - Local TRUE 41.5840600 -109.2335780 0   37 56 56037 40540   Central Sweetwater County https://data.medicare.gov/resource/xubh-q36u/row-x7m7_kvh5~qmi2 530011 661448 2019-12-02 2019-06-30 48 10         58               58
1693 GUTTENBERG MUNICIPAL HOSPITAL 200 MAIN STREET GUTTENBERG IA 52052 CLAYTON (563) 252-1121 Critical Access Hospitals Government - Local TRUE 42.7855480 -91.0999540 0   43 19 19043         https://data.medicare.gov/resource/xubh-q36u/row-9vtm.kuer.r3a9 161312 660958 2019-12-02 2019-06-30 25           25               25
1791 NORTH KANSAS CITY HOSPITAL 2800 CLAY EDWARDS DRIVE NORTH KANSAS CITY MO 64116 CLAY (816) 691-2000 Acute Care Hospitals Government - Local TRUE 39.1508100 -94.5518520 0   47 29 29047 28140 Kansas City-Overland Park-Kansas City, MO-KS Central Clay County https://data.medicare.gov/resource/xubh-q36u/row-jpk9.5ekq~fxuy 260096 661210 2019-12-02 2019-06-30 211 14 138       363   48           411
1950 DECATUR COUNTY HOSPITAL 1405 NW CHURCH STREET LEON IA 50144 DECATUR (641) 446-4871 Critical Access Hospitals Government - Local TRUE 40.7503080 -93.7477890 0   53 19 19053         https://data.medicare.gov/resource/xubh-q36u/row-z8pk.dm9q_4faw 161340 660972 2019-12-02 2019-06-30 11           11               11
2069 CUMBERLAND COUNTY HOSPITAL 299 GLASGOW ROAD BURKESVILLE KY 42717 CUMBERLAND (270) 864-2511 Critical Access Hospitals Government - Local TRUE 36.7968680 -85.3724400 0   57 21 21057         https://data.medicare.gov/resource/xubh-q36u/row-ptk2_m6d2-xzym 181317 661512 2019-12-02 2019-06-30 25           25               25
2489 HARDIN MEDICAL CENTER 935 WAYNE ROAD SAVANNAH TN 38372 HARDIN (731) 926-8121 Acute Care Hospitals Government - Local TRUE 35.2271300 -88.2303620 0   71 47 47071         https://data.medicare.gov/resource/xubh-q36u/row-2dfc~89p6~kqtc 440109 660709 2019-12-02 2019-06-30 49           49       73       122
2528 GREENE COUNTY MEDICAL CENTER 1000 WEST LINCOLNWAY JEFFERSON IA 50129 GREENE (515) 386-2114 Critical Access Hospitals Government - Local TRUE 42.0152170 -94.3890600 0   73 19 19073         https://data.medicare.gov/resource/xubh-q36u/row-ekvn-6v3z_68bn 161325 660962 2019-12-02 2019-06-30 21   4       25               25
2557 LAGUNA HONDA HOSPITAL & REHABILITATION CENTER 375 LAGUNA HONDA BLVD SAN FRANCISCO CA 94116 SAN FRANCISCO (415) 759-2300 Acute Care Hospitals Government - Local FALSE 37.7478240 -122.4586360 0   75 6 6075 41860 San Jose-San Francisco-Oakland, CA Central San Francisco County https://data.medicare.gov/resource/xubh-q36u/row-tz44~vi64-ys8h 50668 662169 2019-12-02 2019-06-30 6           6   5   769       780
2594 SAN JOAQUIN GENERAL HOSPITAL 500 W HOSPITAL ROAD FRENCH CAMP CA 95231 SAN JOAQUIN (209) 468-6000 Acute Care Hospitals Government - Local TRUE 37.8864920 -121.2820610 0   77 6 6077 44700 San Jose-San Francisco-Oakland, CA Central San Joaquin County https://data.medicare.gov/resource/xubh-q36u/row-imza-7dfi-q9b9 50167 661140 2019-12-02 2019-06-30 155 16       25 196               196
2904 REGIONAL HEALTH SERVICES OF HOWARD COUNTY 235 8TH AVENUE WEST CRESCO IA 52136 HOWARD (563) 547-2101 Critical Access Hospitals Government - Local TRUE 43.3818910 -92.1177640 0   89 19 19089         https://data.medicare.gov/resource/xubh-q36u/row-cg3w~i3hb_y7gu 161328 660965 2019-12-02 2019-06-30 18           18           1   19
3106 JACKSON COUNTY REGIONAL HEALTH CENTER 700 W GROVE ST MAQUOKETA IA 52060 JACKSON (563) 652-2474 Critical Access Hospitals Government - Local TRUE 42.0737150 -90.6731320 0   97 19 19097         https://data.medicare.gov/resource/xubh-q36u/row-cqwp_hqw2.ikei 161329 660966 2019-12-02 2019-06-30 25           25               25
3201 JEFFERSON COUNTY HEALTH CENTER 2000 S MAIN FAIRFIELD IA 52556 JEFFERSON (641) 472-4111 Critical Access Hospitals Government - Local TRUE 40.9856350 -91.9631180 0   101 19 19101 21840   Central Jefferson County https://data.medicare.gov/resource/xubh-q36u/row-cksn~64fu_7y3h 161364 660985 2019-12-02 2019-06-30 25           25               25
3240 WEBSTER COUNTY MEMORIAL HOSPITAL 324 MILLER MOUNTAIN DRIVE WEBSTER SPRINGS WV 26288 WEBSTER (304) 847-5682 Critical Access Hospitals Government - Local TRUE 38.4818680 -80.4098110 0   101 54 54101         https://data.medicare.gov/resource/xubh-q36u/row-stvk~jdqs~5m5u 511301 661266 2019-12-02 2019-06-30 25           25               25
3295 WETZEL COUNTY HOSPITAL #3 EAST BENJAMIN DRIVE NEW MARTINSVILLE WV 26155 WETZEL (304) 455-8000 Acute Care Hospitals Government - Local TRUE 39.6810712 -80.8501977 1 ROOFTOP 103 54 54103         https://data.medicare.gov/resource/xubh-q36u/row-v7h8~v92p-92tq 510072 661438 2019-12-02 2019-06-30 43 5         48               48
3676 MAHASKA HEALTH PARTNERSHIP 1229 C AVENUE EAST OSKALOOSA IA 52577 MAHASKA (641) 672-3100 Critical Access Hospitals Government - Local TRUE 41.2985620 -92.6301310 0   123 19 19123 36820   Central Mahaska County https://data.medicare.gov/resource/xubh-q36u/row-r6q8.mtiy.cvna 161379 660990 2019-12-02 2019-06-30 25           25           1   26
3688 MORRILL COUNTY COMMUNITY HOSPITAL 1313 S STREET BRIDGEPORT NE 69336 MORRILL (308) 262-1616 Critical Access Hospitals Government - Local TRUE 41.6618900 -103.0913740 0   123 31 31123         https://data.medicare.gov/resource/xubh-q36u/row-zd5w.8rx8_6yzu 281318 661038 2019-12-02 2019-06-30 20           20               20
3784 MIDMICHIGAN MEDICAL CENTER - WEST BRANCH 2463 SOUTH M-30 WEST BRANCH MI 48661 OGEMAW (989) 345-6366 Acute Care Hospitals Government - Local TRUE 44.2628300 -84.2462300 0   129 26 26129         https://data.medicare.gov/resource/xubh-q36u/row-fszi_3g9m-qsjn 230095 661008 2019-12-02 2019-06-30 78   10       88               88
3878 ESSENTIA HEALTH VIRGINIA 901 9TH STREET NORTH VIRGINIA MN 55792 ST. LOUIS (218) 741-3340 Acute Care Hospitals Government - Local FALSE 47.5307110 -92.5487970 0   137 27 27137 20260   Central St. Louis County https://data.medicare.gov/resource/xubh-q36u/row-39c9_62zv_e3w4 240084 662217 2019-12-02 2019-06-30 40 8         48   16   77       141
4235 PUTNAM COUNTY MEMORIAL HOSPITAL 1926 OAK STREET, PO BOX 389 UNIONVILLE MO 63565 PUTNAM (660) 947-2411 Critical Access Hospitals Government - Local TRUE 40.4820250 -93.0059870 0   171 29 29171         https://data.medicare.gov/resource/xubh-q36u/row-ygkd_dijw_ng7v 261305 661212 2019-12-02 2019-06-30 15           15               15
4268 VALLEY COUNTY HEALTH SYSTEM 2707 L STREET ORD NE 68862 VALLEY (308) 728-4200 Critical Access Hospitals Government - Local TRUE 41.6032130 -98.9426760 0   175 31 31175         https://data.medicare.gov/resource/xubh-q36u/row-y2qv_7x4q_v7xu 281353 661044 2019-12-02 2019-06-30 16           16               16
4373 WILKES REGIONAL MEDICAL CENTER 1370 WEST D ST NORTH WILKESBORO NC 28659 WILKES (336) 651-8100 Acute Care Hospitals Government - Local TRUE 36.1584650 -81.1570130 0   193 37 37193 35900   Central Wilkes County https://data.medicare.gov/resource/xubh-q36u/row-mugx~rcjs~9jqq 340064 661369 2019-12-02 2019-06-30 85 8         93       10       103
4375 PETERSBURG MEDICAL CENTER PO BOX 589 PETERSBURG AK 99833 PETERSBURG BOROUGH (907) 772-4291 Critical Access Hospitals Government - Local TRUE 56.8128691 -132.9554619 1 ROOFTOP 195 2 2195         https://data.medicare.gov/resource/xubh-q36u/row-ky7y_b72j_698p 21304 660160 2019-12-02 2019-06-30 12           12       15       27
4390 IOWA SPECIALTY HOSPITAL-CLARION 1316 SOUTH MAIN STREET CLARION IA 50525 WRIGHT (515) 532-2811 Critical Access Hospitals Government - Local TRUE 42.7216250 -93.7326280 0   197 19 19197         https://data.medicare.gov/resource/xubh-q36u/row-qm5h-kjf7~8unb 161302 661176 2019-12-02 2019-06-30 25           25               25

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
);