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

27 rows where "filed_date" is on date 2019-06-03 and hospital_ownership = "Government - Local"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: city, state, county_name, hospital_type, geocode_flag, geocode_accuracy, countyfips, statefips, cbsacode, csatitle, centraloutlyingcounty, countyequivalent, acute_beds, icu_beds, burn_beds, surg_icu_beds, subtotal_acute_beds, subprovider_ipf_beds, subprovider_irf_beds, skilled_nursing_beds, nursing_fac_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
212 212 BERGEN NEW BRIDGE MEDICAL CENTER 230 EAST RIDGEWOOD AVE PARAMUS NJ 7652 BERGEN (201) 967-4000 Acute Care Hospitals Government - Local TRUE 40.9586020 -74.0621510 0   3 34 34003 35620 New York-Newark, NY-NJ-CT-PA Central Bergen County https://data.medicare.gov/resource/xubh-q36u/row-uajf_w5ak.e5wh 310058 651020 2019-06-03 2018-12-31 118 9         127 319     574       1020
691 691 SLEEPY EYE MUNICIPAL HOSPITAL 400 FOURTH AVENUE NORTHWEST SLEEPY EYE MN 56085 BROWN (507) 794-3571 Critical Access Hospitals Government - Local TRUE 44.2993190 -94.7273150 0   15 27 27015 35580 Mankato-New Ulm-North Mankato, MN Central Brown County https://data.medicare.gov/resource/xubh-q36u/row-td5y_avnx_gs7p 241327 651011 2019-06-03 2018-12-31 16           16               16
882 882 PIGGOTT COMMUNITY HOSPITAL 216 EAST MAIN STREET PIGGOTT AR 72454 CLAY (870) 598-3881 Critical Access Hospitals Government - Local TRUE 36.3820190 -90.1884430 0   21 5 5021         https://data.medicare.gov/resource/xubh-q36u/row-73yu_ywme-uu8m 41330 649163 2019-06-03 2018-12-31 25           25               25
1069 1069 DAVIESS COMMUNITY HOSPITAL 1314 E WALNUT ST WASHINGTON IN 47501 DAVIESS (812) 254-2760 Acute Care Hospitals Government - Local TRUE 38.6586950 -87.1603190 0   27 18 18027 47780   Central Daviess County https://data.medicare.gov/resource/xubh-q36u/row-khjv_h54z-usqa 150061 649895 2019-06-03 2018-12-31 37 5         42 20 12           74
1072 1072 CLAY COUNTY MEDICAL CENTER 617 LIBERTY CLAY CENTER KS 67432 CLAY (785) 632-2144 Critical Access Hospitals Government - Local TRUE 39.3916810 -97.1241960 0   27 20 20027         https://data.medicare.gov/resource/xubh-q36u/row-5isq.mc8m-iybh 171371 650581 2019-06-03 2018-12-31 17           17               17
1136 1136 HIGHPOINT HEALTH 600 WILSON CREEK RD LAWRENCEBURG IN 47025 DEARBORN (812) 537-1010 Acute Care Hospitals Government - Local TRUE 39.1129220 -84.8839510 0   29 18 18029 17140 Cincinnati-Wilmington-Maysville, OH-KY-IN Outlying Dearborn County https://data.medicare.gov/resource/xubh-q36u/row-ngjg.xy9w~6uaw 150086 649567 2019-06-03 2018-12-31 78 8         86               86
1308 1308 PLATTE COUNTY MEMORIAL HOSPITAL 201 14TH STREET WHEATLAND WY 82201 PLATTE (307) 322-3636 Critical Access Hospitals Government - Local TRUE 42.0498100 -104.9602210 0   31 56 56031         https://data.medicare.gov/resource/xubh-q36u/row-xwas~nr7a-7yiz 531305 649858 2019-06-03 2018-12-31 25           25               25
1406 1406 ALTRU HOSPITAL 1200 S COLUMBIA RD GRAND FORKS ND 58201 GRAND FORKS (701) 780-5000 Acute Care Hospitals Government - Local TRUE 47.9105352 -97.0681107 1 ROOFTOP 35 38 38035 24220   Central Grand Forks County https://data.medicare.gov/resource/xubh-q36u/row-tfgh.9uft~bxhm 350019 650883 2019-06-03 2018-12-31 245 16     10   271   23           294
1588 1588 ELKHART GENERAL HOSPITAL 600 E BLVD ELKHART IN 46514 ELKHART (574) 294-2621 Acute Care Hospitals Government - Local TRUE 41.6787610 -85.9918330 0   39 18 18039 21140 South Bend-Elkhart-Mishawaka, IN-MI Central Elkhart County https://data.medicare.gov/resource/xubh-q36u/row-xq9p.barv.suqr 150018 649560 2019-06-03 2018-12-31 169 23         200 10 20           230
1719 1719 WASHAKIE MEDICAL CENTER 400 SOUTH 15TH STREET WORLAND WY 82401 WASHAKIE (307) 347-3221 Critical Access Hospitals Government - Local TRUE 44.0135560 -107.9484090 0   43 56 56043         https://data.medicare.gov/resource/xubh-q36u/row-wgjq-rwdt.3x58 531306 649859 2019-06-03 2018-12-31 18           18               18
2301 2301 HENRY COUNTY MEMORIAL HOSPITAL 1000 N 16TH ST NEW CASTLE IN 47362 HENRY (765) 521-0890 Acute Care Hospitals Government - Local TRUE 39.9424740 -85.3650100 0   65 18 18065 35220 Indianapolis-Carmel-Muncie, IN Central Henry County https://data.medicare.gov/resource/xubh-q36u/row-7hck_n6zg-4n7p 150030 649565 2019-06-03 2018-12-31 38 10         48               48
3099 3099 ESKENAZI HEALTH 720 ESKENAZI AVENUE INDIANAPOLIS IN 46202 MARION (317) 880-4818 Acute Care Hospitals Government - Local TRUE 39.7805300 -86.1734500 0   97 18 18097 26900 Indianapolis-Carmel-Muncie, IN Central Marion County https://data.medicare.gov/resource/xubh-q36u/row-fv8t.e66e-c8mj 150024 649564 2019-06-03 2018-12-31 192 72   15     316 20             336
3274 3274 RIVER'S EDGE HOSPITAL & CLINIC 1900 NORTH SUNRISE DRIVE ST PETER MN 56082 NICOLLET (507) 934-7602 Critical Access Hospitals Government - Local TRUE 44.3478460 -93.9708750 0   103 27 27103 31860 Mankato-New Ulm-North Mankato, MN Central Nicollet County https://data.medicare.gov/resource/xubh-q36u/row-83di-yjvp_x3zt 241334 649780 2019-06-03 2018-12-31 17           17               17
3349 3349 WHEATLAND MEMORIAL HOSPITAL 530 3RD ST NW HARLOWTON MT 59036 WHEATLAND (406) 632-4351 Critical Access Hospitals Government - Local TRUE 46.4370010 -109.8405050 0   107 30 30107         https://data.medicare.gov/resource/xubh-q36u/row-ttwx.8piz~nq2c 271321 651017 2019-06-03 2018-12-31 25           25               25
3370 3370 LOGAN COUNTY HOSPITAL 211 CHERRY AVENUE OAKLEY KS 67748 LOGAN (785) 672-3211 Critical Access Hospitals Government - Local TRUE 39.1269150 -100.8622790 0   109 20 20109         https://data.medicare.gov/resource/xubh-q36u/row-wi6i-q2iz.xd59 171326 649592 2019-06-03 2018-12-31 25           25           45   70
3650 3650 MERRICK MEDICAL CENTER 1715 26TH ST CENTRAL CITY NE 68826 MERRICK (308) 946-3015 Critical Access Hospitals Government - Local TRUE 41.1066100 -98.0026520 0   121 31 31121 24260   Outlying Merrick County https://data.medicare.gov/resource/xubh-q36u/row-tf8v-t66v_jxv4 281328 649920 2019-06-03 2018-12-31 20           20               20
3726 3726 PAULDING COUNTY HOSPITAL 1035 WEST WAYNE ST. PAULDING OH 45879 PAULDING (419) 399-1103 Critical Access Hospitals Government - Local TRUE 41.1352900 -84.6004940 0   125 39 39125         https://data.medicare.gov/resource/xubh-q36u/row-2ara~5qbu_gakf 361300 649651 2019-06-03 2018-12-31 25           25               25
3888 3888 RUSH MEMORIAL HOSPITAL 1300 N MAIN ST RUSHVILLE IN 46173 RUSH (765) 932-7513 Critical Access Hospitals Government - Local TRUE 39.6214420 -85.4447920 0   139 18 18139         https://data.medicare.gov/resource/xubh-q36u/row-bit2.6ykr-x2sd 151304 649573 2019-06-03 2018-12-31 25           25               25
4083 4083 PEMISCOT COUNTY MEMORIAL HOSPITAL 946 EAST REED HAYTI MO 63851 PEMISCOT (573) 359-1372 Acute Care Hospitals Government - Local TRUE 36.2368550 -89.7399750 0   155 29 29155         https://data.medicare.gov/resource/xubh-q36u/row-r644.jfav_m4mz 260070 650166 2019-06-03 2018-12-31 42 7         49 52       66     167
4144 4144 PHELPS HEALTH 1000 W 10TH ST ROLLA MO 65401 PHELPS (573) 458-8899 Acute Care Hospitals Government - Local TRUE 37.9514420 -91.7849930 0   161 29 29161 40620   Central Phelps County https://data.medicare.gov/resource/xubh-q36u/row-peg4_q7re-c685 260017 649918 2019-06-03 2018-12-31 154 18         172 20 30   20       242
4227 4227 WOOSTER COMMUNITY HOSPITAL 1761 BEALL AVENUE WOOSTER OH 44691 WAYNE (330) 263-8100 Acute Care Hospitals Government - Local TRUE 40.8207130 -81.9342470 0   169 39 39169 49300   Central Wayne County https://data.medicare.gov/resource/xubh-q36u/row-bh63_heg3-ryxh 360036 649308 2019-06-03 2018-12-31 90 14         104   10   22       136
4297 4297 GOODLAND REGIONAL MEDICAL CENTER 220 WEST SECOND STREET GOODLAND KS 67735 SHERMAN (785) 890-3625 Critical Access Hospitals Government - Local TRUE 39.3575900 -101.7132560 0   181 20 20181         https://data.medicare.gov/resource/xubh-q36u/row-5axd_6ykz-azjm 171370 650580 2019-06-03 2018-12-31 21           21               21
4325 4325 STAFFORD COUNTY HOSPITAL 502 S BUCKEYE STAFFORD KS 67578 STAFFORD (620) 234-5221 Critical Access Hospitals Government - Local TRUE 37.9568590 -98.5961510 0   185 20 20185         https://data.medicare.gov/resource/xubh-q36u/row-e2nn-qquj.hgq6 171323 649591 2019-06-03 2018-12-31 25           25               25
4337 4337 STANTON COUNTY HOSPITAL 404 N CHESTNUT JOHNSON KS 67855 STANTON (620) 492-6250 Critical Access Hospitals Government - Local TRUE 37.5741650 -101.7494100 0   187 20 20187         https://data.medicare.gov/resource/xubh-q36u/row-nbvv-b265_tdp8 171343 649594 2019-06-03 2018-12-31 16           16               16
4347 4347 STEVENS COUNTY HOSPITAL 1006 S JACKSON HUGOTON KS 67951 STEVENS (620) 544-8511 Critical Access Hospitals Government - Local TRUE 37.1708080 -101.3497550 0   189 20 20189         https://data.medicare.gov/resource/xubh-q36u/row-39kr.3u54-pmuw 171335 649737 2019-06-03 2018-12-31 17           17           83   100
4378 4378 TREGO COUNTY LEMKE MEMORIAL HOSPITAL 320 THIRTEENTH ST WA KEENEY KS 67672 TREGO (785) 743-2182 Critical Access Hospitals Government - Local TRUE 39.0272190 -99.8716200 0   195 20 20195         https://data.medicare.gov/resource/xubh-q36u/row-y4gc.24zy.c8cd 171355 649596 2019-06-03 2018-12-31 25           25           37   62
4405 4405 WASHINGTON COUNTY HOSPITAL 304 E 3RD STREET WASHINGTON KS 66968 WASHINGTON (785) 325-2211 Critical Access Hospitals Government - Local TRUE 39.8174780 -97.0455720 0   201 20 20201         https://data.medicare.gov/resource/xubh-q36u/row-hks4_sdgj_3m95 171351 649595 2019-06-03 2018-12-31 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
);