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

325 rows where "filed_date" is on date 2019-06-03 sorted by cbsacode

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: hospital_type, hospital_ownership, emergency_services, geocode_flag, geocode_accuracy, centraloutlyingcounty, coronary_beds, burn_beds, surg_icu_beds, oth_spec_beds, subprovider_oth_beds, nursing_fac_beds, oth_longterm_beds, fy_end_date (date)

filed_date (date) ✖

  • 2019-06-03 · 325 ✖
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
21 21 HORN MEMORIAL HOSPITAL 701 E 2ND ST IDA GROVE IA 51445 IDA (712) 364-3311 Critical Access Hospitals Voluntary non-profit - Private TRUE 42.3393030 -95.4589100 0   93 19 19093         https://data.medicare.gov/resource/xubh-q36u/row-ct62_kkw5_7j35 161354 649735 2019-06-03 2018-12-31 25           25               25
30 30 SOUTHSIDE COMMUNITY HOSPITAL, INC 800 OAK STREET FARMVILLE VA 23901 PRINCE EDWARD (434) 392-8811 Acute Care Hospitals Voluntary non-profit - Other TRUE 37.3033170 -78.4030580 0   147 51 51147         https://data.medicare.gov/resource/xubh-q36u/row-5efz.zpme_8ei2 490090 650408 2019-06-03 2018-12-31 78 8         86               86
34 34 FRIO REGIONAL HOSPITAL 200 S IH 35 PEARSALL TX 78061 FRIO (830) 334-3617 Critical Access Hospitals Voluntary non-profit - Private TRUE 28.8970480 -99.1160130 0   163 48 48163         https://data.medicare.gov/resource/xubh-q36u/row-9gys.vgtu~2pyx 451391 650214 2019-06-03 2018-12-31 24           24               24
216 216 CUBA MEMORIAL HOSPITAL, INC 140 WEST MAIN STREET CUBA NY 14727 ALLEGANY (585) 961-2000 Critical Access Hospitals Voluntary non-profit - Private FALSE 42.2133410 -78.2881390 0   3 36 36003         https://data.medicare.gov/resource/xubh-q36u/row-2ir6~7udp_pyzv 331301 651038 2019-06-03 2018-12-31 20           20       61       81
259 259 SUTTER AMADOR HOSPITAL 200 MISSION BLVD JACKSON CA 95642 AMADOR (209) 223-7500 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.3495610 -120.7659050 0   5 6 6005         https://data.medicare.gov/resource/xubh-q36u/row-s5bi-egin.834t 50014 650640 2019-06-03 2018-12-31 46 6         52               52
392 392 BENNETT COUNTY HOSPITAL AND NURSING HOME - CAH 102 MAJOR ALLEN POST OFFICE BOX 70D MARTIN SD 57551 BENNETT (605) 685-6622 Critical Access Hospitals Voluntary non-profit - Other TRUE 43.1691630 -101.7266636 1 RANGE_INTERPOLATED 7 46 46007         https://data.medicare.gov/resource/xubh-q36u/row-q2mg~bq2u~fi2w 431314 649823 2019-06-03 2018-12-31 14           14           48   62
524 524 SOUTHWEST HEALTHCARE SERVICES 802 2ND ST NW BOWMAN ND 58623 BOWMAN (701) 523-5265 Critical Access Hospitals Voluntary non-profit - Private TRUE 46.1841910 -103.4067130 0   11 38 38011         https://data.medicare.gov/resource/xubh-q36u/row-wb88_am45~hjt8 351313 651048 2019-06-03 2018-12-31 23           23       40       63
607 607 BIENVILLE MEDICAL CENTER 1175 PINE STREET ARCADIA LA 71001 BIENVILLE (318) 263-4700 Critical Access Hospitals Proprietary TRUE 32.5530850 -92.9157770 0   13 22 22013         https://data.medicare.gov/resource/xubh-q36u/row-ui8b~9pic.2t2z 191320 650142 2019-06-03 2018-12-31 21           21               21
660 660 MINNIE HAMILTON HEALTH SYSTEM 186 HOSPITAL DRIVE GRANTSVILLE WV 26147 CALHOUN (304) 354-9244 Critical Access Hospitals Voluntary non-profit - Private TRUE 38.9237960 -81.0918910 0   13 54 54013         https://data.medicare.gov/resource/xubh-q36u/row-2x87.vdzq_mgqw 511303 651093 2019-06-03 2018-12-31 25           25       24       49
720 720 COMMUNITY HOSPITAL 2000 CAMPBELL DRIVE TORRINGTON WY 82240 GOSHEN (307) 532-4181 Critical Access Hospitals Voluntary non-profit - Private TRUE 42.0817650 -104.1915090 0   15 56 56015         https://data.medicare.gov/resource/xubh-q36u/row-cdm5.gqxc~vfiz 531307 649980 2019-06-03 2018-12-31 25           25               25
761 761 HOLY ROSARY HEALTHCARE 2600 WILSON ST MILES CITY MT 59301 CUSTER (406) 233-2600 Critical Access Hospitals Voluntary non-profit - Private TRUE 46.3973550 -105.8278370 0   17 30 30017         https://data.medicare.gov/resource/xubh-q36u/row-89tn_7hx4-8qhz 271347 649797 2019-06-03 2018-12-31 21 4         25       84       109
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
940 940 CHOCTAW GENERAL HOSPITAL 401 VANITY FAIR LANE, PO BOX 618 BUTLER AL 36904 CHOCTAW (205) 459-9100 Critical Access Hospitals Voluntary non-profit - Private TRUE 32.0937419 -88.2095888 1 ROOFTOP 23 1 1023         https://data.medicare.gov/resource/xubh-q36u/row-cm2u-i8id~q257 11304 651161 2019-06-03 2018-12-31 25           25               25
989 989 JACKSON MEDICAL CENTER 220 HOSPITAL DRIVE JACKSON AL 36545 CLARKE (251) 246-9021 Acute Care Hospitals Proprietary TRUE 31.5304820 -87.8931800 0   25 1 1025         https://data.medicare.gov/resource/xubh-q36u/row-p276~rdhi_nmej 10128 651157 2019-06-03 2018-12-31 35           35               35
1034 1034 CIMARRON MEMORIAL HOSPITAL 100 SOUTH ELLIS BOISE CITY OK 73933 CIMARRON (580) 544-2501 Critical Access Hospitals Government - Hospital District or Authority TRUE 36.7290550 -102.5175370 0   25 40 40025         https://data.medicare.gov/resource/xubh-q36u/row-9zte.pc9m_addj 371307 650201 2019-06-03 2018-12-31 25           25               25
1042 1042 KANE COUNTY HOSPITAL 355 NORTH MAIN STREET KANAB UT 84741 KANE (435) 644-5811 Critical Access Hospitals Government - Hospital District or Authority TRUE 37.0543240 -112.5285900 0   25 49 49025         https://data.medicare.gov/resource/xubh-q36u/row-g8j5_itr8_6iiy 461309 649842 2019-06-03 2018-12-31 25           25               25
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
1300 1300 ST CHARLES MADRAS 470 NE A STREET MADRAS OR 97741 JEFFERSON (541) 475-3882 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.6373620 -121.1213580 0   31 41 41031         https://data.medicare.gov/resource/xubh-q36u/row-c49r.t2un~9r3e 381324 651053 2019-06-03 2018-12-31 25           25               25
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
1377 1377 EVERGREEN MEDICAL CENTER 101 CRESTVIEW AVENUE EVERGREEN AL 36401 CONECUH (251) 578-2480 Acute Care Hospitals Proprietary TRUE 31.4312600 -86.9420500 0   35 1 1035         https://data.medicare.gov/resource/xubh-q36u/row-f8ut-az4v~dn63 10148 651159 2019-06-03 2018-12-31 44           44               44
1591 1591 SAVOY MEDICAL CENTER 801 POINCIANA AVENUE MAMOU LA 70554 EVANGELINE (337) 468-5261 Acute Care Hospitals Voluntary non-profit - Other TRUE 30.6410320 -92.4176050 0   39 22 22039         https://data.medicare.gov/resource/xubh-q36u/row-53wc.63uu-ebuh 190025 650138 2019-06-03 2018-12-31 118 10         128 38 10           176
1622 1622 KLICKITAT VALLEY HOSPITAL 310 SOUTH ROOSEVELT GOLDENDALE WA 98620 KLICKITAT (509) 773-4022 Critical Access Hospitals Government - Hospital District or Authority TRUE 45.8202390 -120.8122990 0   39 53 53039         https://data.medicare.gov/resource/xubh-q36u/row-hemh_kxtf-bs6t 501316 649846 2019-06-03 2018-12-31 14           14               14
1646 1646 CARROLL COUNTY MEMORIAL HOSPITAL 309 ELEVENTH STREET CARROLLTON KY 41008 CARROLL (502) 732-4321 Critical Access Hospitals Voluntary non-profit - Private TRUE 38.6799040 -85.1693140 0   41 21 21041         https://data.medicare.gov/resource/xubh-q36u/row-ttr6_yqtq-pq69 181310 649240 2019-06-03 2018-12-31 25           25               25
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
1778 1778 MARGARET MARY HEALTH 321 MITCHELL AVE BATESVILLE IN 47006 FRANKLIN (812) 934-6624 Critical Access Hospitals Voluntary non-profit - Private TRUE 39.3061410 -85.2227030 0   47 18 18047         https://data.medicare.gov/resource/xubh-q36u/row-dzet~b6y3_gi2k 151329 649577 2019-06-03 2018-12-31 18 7         25               25
1825 1825 THEDACARE MEDICAL CENTER - BERLIN INC 225 MEMORIAL DRIVE BERLIN WI 54923 GREEN LAKE (920) 361-1313 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.9776160 -88.9418430 0   47 55 55047         https://data.medicare.gov/resource/xubh-q36u/row-cdp5_34wg-tnxr 521355 650930 2019-06-03 2018-12-31 20 5         25       37       62
1881 1881 OCEAN BEACH HOSPITAL 174 FIRST AVENUE NORTH ILWACO WA 98624 PACIFIC (360) 642-3181 Critical Access Hospitals Government - State TRUE 46.3116960 -124.0433520 0   49 53 53049         https://data.medicare.gov/resource/xubh-q36u/row-6yj2-723x_f5cn 501314 649845 2019-06-03 2018-12-31 25           25               25
1964 1964 COOPER COUNTY COMMUNITY HOSPITAL 17651 B HWY BOONVILLE MO 65233 COOPER (660) 882-4100 Acute Care Hospitals Voluntary non-profit - Other TRUE 38.9435330 -92.7420750 0   53 29 29053         https://data.medicare.gov/resource/xubh-q36u/row-b8m2_fqek~vure 260004 649916 2019-06-03 2018-12-31 46           46           19   65
2039 2039 SOUTHERN TENNESSEE REGIONAL HEALTH SYSTEM PULASKI 1265 E COLLEGE ST PULASKI TN 38478 GILES (931) 363-7531 Acute Care Hospitals Proprietary TRUE 35.1912900 -87.0043220 0   55 47 47055         https://data.medicare.gov/resource/xubh-q36u/row-5e7x~i85y_dgtz 440020 651233 2019-06-03 2018-12-31 75 6         81 14             95
2242 2242 KIT CARSON COUNTY MEMORIAL HOSPITAL 286 16TH ST BURLINGTON CO 80807 KIT CARSON (719) 346-5311 Critical Access Hospitals Government - Hospital District or Authority TRUE 39.3023780 -102.2707110 0   63 8 8063         https://data.medicare.gov/resource/xubh-q36u/row-xqzu-2pvu-xrfj 61313 648525 2019-06-03 2018-12-31 19           19               19
2522 2522 LINCOLN COMMUNITY HOSPITAL 111 6TH ST HUGO CO 80821 LINCOLN (719) 743-2421 Critical Access Hospitals Voluntary non-profit - Other TRUE 39.1376600 -103.4731590 0   73 8 8073         https://data.medicare.gov/resource/xubh-q36u/row-ur8w~xce7~5xe9 61306 651191 2019-06-03 2018-12-31 15           15       35       50
2986 2986 NORTHWEST MEDICAL CENTER 1530 U S HIGHWAY 43 WINFIELD AL 35594 FAYETTE (205) 487-7736 Acute Care Hospitals Proprietary TRUE 33.9293160 -87.8245070 0   93 1 1093         https://data.medicare.gov/resource/xubh-q36u/row-r4dk-tpsz_u57n 10086 651153 2019-06-03 2018-12-31 57 4         61 10             71
3044 3044 NORTH MISSISSIPPI MEDICAL CENTER-GILMORE AMORY 1105 EARL FRYE BLVD AMORY MS 38821 MONROE (662) 256-7111 Acute Care Hospitals Proprietary TRUE 33.9775510 -88.4776250 0   95 28 28095         https://data.medicare.gov/resource/xubh-q36u/row-mseb-a3c5-hfq8 250025 649915 2019-06-03 2018-12-31 80 9       6 95               95
3208 3208 LAIRD HOSPITAL INC 25117 HIGHWAY 15 UNION MS 39365 NESHOBA (601) 774-8214 Critical Access Hospitals Voluntary non-profit - Private TRUE 32.5592070 -89.1025610 0   101 28 28101         https://data.medicare.gov/resource/xubh-q36u/row-68dt.7k6k_jc9z 251322 649458 2019-06-03 2018-12-31 25           25               25
3211 3211 OGALLALA COMMUNITY HOSPITAL 2601 NORTH SPRUCE ST OGALLALA NE 69153 KEITH (308) 284-4011 Critical Access Hospitals Government - Hospital District or Authority TRUE 41.1501770 -101.7204470 0   101 31 31101         https://data.medicare.gov/resource/xubh-q36u/row-g68g~zk9i.gtc5 281355 650174 2019-06-03 2018-12-31 18           18               18
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
3574 3574 HILL HOSPITAL OF SUMTER COUNTY 751 DERBY DRIVE YORK AL 36925 SUMTER (205) 392-5263 Acute Care Hospitals Voluntary non-profit - Other TRUE 32.4918250 -88.2960810 0   119 1 1119         https://data.medicare.gov/resource/xubh-q36u/row-hxjd.ga7s.xmvj 10138 651158 2019-06-03 2018-12-31 33           33               33
3594 3594 MEADE DISTRICT HOSPITAL 510 EAST CARTHAGE MEADE KS 67864 MEADE (620) 873-2141 Critical Access Hospitals Government - Hospital District or Authority TRUE 37.2854900 -100.3342670 0   119 20 20119         https://data.medicare.gov/resource/xubh-q36u/row-9yc7~mw74.3m9f 171321 649590 2019-06-03 2018-12-31 20           20           45   65
3678 3678 WEST CARROLL MEMORIAL HOSPITAL 706 ROSS STREET OAK GROVE LA 71263 WEST CARROLL (318) 428-3237 Acute Care Hospitals Proprietary TRUE 32.8678130 -91.3831960 0   123 22 22123         https://data.medicare.gov/resource/xubh-q36u/row-nqc6-kae8-uxge 190081 649437 2019-06-03 2018-12-31 30           30               30
3686 3686 SCOTT REGIONAL HOSPITAL CAH 317 HIGHWAY 13 SOUTH MORTON MS 39117 SCOTT (601) 732-6301 Critical Access Hospitals Voluntary non-profit - Private TRUE 32.3446250 -89.6712950 0   123 28 28123         https://data.medicare.gov/resource/xubh-q36u/row-irvg-pnep~z7t3 251323 649459 2019-06-03 2018-12-31 25           25               25
3703 3703 WRAY COMMUNITY DISTRICT HOSPITAL 1017 WEST 7TH ST WRAY CO 80758 YUMA (970) 332-4811 Critical Access Hospitals Government - Hospital District or Authority TRUE 40.0754050 -102.2346600 0   125 8 8125         https://data.medicare.gov/resource/xubh-q36u/row-jpdk~yrgm-qq54 61309 649710 2019-06-03 2018-12-31 16           16               16
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
3786 3786 PATIENTS CHOICE MEDICAL CENTER 347 MAGNOLIA DRIVE RALEIGH MS 39153 SMITH (601) 782-9997 Acute Care Hospitals Proprietary FALSE 32.0009980 -89.5206670 0   129 28 28129         https://data.medicare.gov/resource/xubh-q36u/row-xqvg.aa4c-5mrs 250163 650165 2019-06-03 2018-12-31 19           19 10             29
3866 3866 THEDACARE MEDICAL CENTER - WAUPACA INC 800 RIVERSIDE DRIVE WAUPACA WI 54981 WAUPACA (715) 258-1000 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.3453330 -89.0758250 0   135 55 55135         https://data.medicare.gov/resource/xubh-q36u/row-yqc8_g9mu.8fdk 521334 650928 2019-06-03 2018-12-31 21 4         25               25
3885 3885 THEDACARE MEDICAL CENTER - WILD ROSE INC 601 GROVE AVE WILD ROSE WI 54984 WAUSHARA (920) 622-3257 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.1831430 -89.2457040 0   137 55 55137         https://data.medicare.gov/resource/xubh-q36u/row-8xiv-23ba.frav 521303 650926 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
4013 4013 STARKE HOSPITAL 102 E CULVER RD KNOX IN 46534 STARKE (574) 772-1102 Acute Care Hospitals Proprietary TRUE 41.2880640 -86.6219370 0   149 18 18149         https://data.medicare.gov/resource/xubh-q36u/row-4bwp-v7bt.62f6 150102 649569 2019-06-03 2018-12-31 14 1         15               15
4043 4043 CRETE AREA MEDICAL CENTER P O BOX 220, 2910 BETTEN DR CRETE NE 68333 SALINE (402) 826-2101 Critical Access Hospitals Voluntary non-profit - Private TRUE 40.6407290 -96.9377207 1 ROOFTOP 151 31 31151         https://data.medicare.gov/resource/xubh-q36u/row-r9d7_ysji.sjzi 281354 649921 2019-06-03 2018-12-31 24           24               24
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
4182 4182 JENKINS COUNTY HOSPITAL 931 EAST WINTHROPE AVENUE MILLEN GA 30442 JENKINS (478) 982-4221 Critical Access Hospitals Proprietary TRUE 32.8036780 -81.9340740 0   165 13 13165         https://data.medicare.gov/resource/xubh-q36u/row-wabu-mgcf_ujg3 111311 651201 2019-06-03 2018-12-31 15           15               15
4270 4270 WYANDOT MEMORIAL HOSPITAL 885 NORTH SANDUSKY AVENUE UPPER SANDUSKY OH 43351 WYANDOT (419) 294-4991 Critical Access Hospitals Government - Hospital District or Authority TRUE 40.8418840 -83.2807200 0   175 39 39175         https://data.medicare.gov/resource/xubh-q36u/row-7m8m~3eqa_t4vr 361329 649655 2019-06-03 2018-12-31 19   5       24               24
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
4472 4472 TEXAS COUNTY MEMORIAL HOSPITAL 1333 SAM HOUSTON BOULEVARD HOUSTON MO 65483 TEXAS (417) 967-3311 Acute Care Hospitals Voluntary non-profit - Other TRUE 37.3157560 -91.9595590 0   215 29 29215         https://data.medicare.gov/resource/xubh-q36u/row-f27e-vv7h.kacf 260024 649919 2019-06-03 2018-12-31 43 4         47               47
1115 1115 GRAYS HARBOR COMMUNITY HOSPITAL 915 ANDERSON DRIVE ABERDEEN WA 98520 GRAYS HARBOR (360) 532-8330 Acute Care Hospitals Voluntary non-profit - Private TRUE 46.9796000 -123.8463870 0   27 53 53027 10140   Central Grays Harbor County https://data.medicare.gov/resource/xubh-q36u/row-qmdm-j995~rvv5 500031 659383 2019-06-03 2018-12-31 41 8         49               49
334 334 HOSP COMUNITARIO BUEN SAMARITANO CARR.2 KM.1.4 AVE. SEVERIANO CUEVAS #18 AGUADILLA PR 603 AGUADILLA (787) 658-0000 Acute Care Hospitals Voluntary non-profit - Other TRUE 18.4257212 -67.1508997 1 GEOMETRIC_CENTER 5 72 72005 10380   Central Aguadilla Municipio https://data.medicare.gov/resource/xubh-q36u/row-8tsm_vegi.8z9v 400079 649495 2019-06-03 2018-12-31 116 8         124               124
3837 3837 UNIVERSITY HOSPITALS PORTAGE MEDICAL CENTER 6847 N CHESTNUT RAVENNA OH 44266 PORTAGE (330) 297-2300 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.1767230 -81.2458870 0   133 39 39133 10420 Cleveland-Akron-Canton, OH Central Portage County https://data.medicare.gov/resource/xubh-q36u/row-8acw.46jj_2an4 360078 649317 2019-06-03 2018-12-31 175 16         191               191
2624 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 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
2875 2875 THEDACARE MEDICAL CENTER NEW LONDON 1405 MILL ST NEW LONDON WI 54961 WAUPACA (920) 531-2000 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.3816680 -88.7331240 0   87 55 55087 11540 Appleton-Oshkosh-Neenah, WI Central Outagamie County https://data.medicare.gov/resource/xubh-q36u/row-3ckm-rirg.mkfx 521326 650927 2019-06-03 2018-12-31 25           25               25
2876 2876 THEDACARE REGIONAL MEDICAL CENTER - APPLETON INC 1818 N MEADE ST APPLETON WI 54911 OUTAGAMIE (920) 731-4101 Acute Care Hospitals Voluntary non-profit - Private TRUE 44.2787720 -88.3956120 0   87 55 55087 11540 Appleton-Oshkosh-Neenah, WI Central Outagamie County https://data.medicare.gov/resource/xubh-q36u/row-9ued_raig_as93 520160 650925 2019-06-03 2018-12-31 125 22         147               147
310 310 UNIVERSITY HOSPITALS SAMARITAN MEDICAL CENTER 1025 CENTER ST ASHLAND OH 44805 ASHLAND (419) 289-0491 Acute Care Hospitals Voluntary non-profit - Other FALSE 40.8587020 -82.3104130 0   5 39 39005 11740 Mansfield-Ashland-Bucyrus, OH Central Ashland County https://data.medicare.gov/resource/xubh-q36u/row-suim.pydj-jawn 360002 649303 2019-06-03 2018-12-31 33 6         39               39
378 378 UNIVERSITY HOSPITALS CONNEAUT MEDICAL CENTER 158 WEST MAIN ROAD CONNEAUT OH 44030 ASHTABULA (440) 593-1131 Critical Access Hospitals Voluntary non-profit - Other TRUE 41.9369200 -80.5864590 0   7 39 39007 11780 Cleveland-Akron-Canton, OH Central Ashtabula County https://data.medicare.gov/resource/xubh-q36u/row-j92a_zjx7-y5bm 361308 649653 2019-06-03 2018-12-31 20 5         25               25
379 379 UHHS MEMORIAL HOSPITAL OF GENEVA 870 WEST MAIN STREET GENEVA OH 44041 ASHTABULA (440) 466-1141 Critical Access Hospitals Voluntary non-profit - Private TRUE 41.8002330 -80.9622770 0   7 39 39007 11780 Cleveland-Akron-Canton, OH Central Ashtabula County https://data.medicare.gov/resource/xubh-q36u/row-f7rd~3d3q.5pjc 361307 649652 2019-06-03 2018-12-31 20 5         25               25
4394 4394 WARM SPRINGS MEDICAL CENTER 5995 SPRING STREET WARM SPRINGS GA 31830 MERIWETHER (706) 655-9351 Critical Access Hospitals Voluntary non-profit - Other TRUE 32.8906520 -84.6829110 0   199 13 13199 12060 Atlanta--Athens-Clarke County--Sandy Springs, GA Outlying Meriwether County https://data.medicare.gov/resource/xubh-q36u/row-zkjq-ab6q-8vh9 111316 651203 2019-06-03 2018-12-31 25           25       79       104
1130 1130 BAKERSFIELD HEART HOSPITAL 3001 SILLECT AVENUE BAKERSFIELD CA 93308 KERN (661) 316-6000 Acute Care Hospitals Proprietary TRUE 35.3861060 -119.0408470 0   29 6 6029 12540   Central Kern County https://data.medicare.gov/resource/xubh-q36u/row-e89i~sm2j_vijv 50724 651182 2019-06-03 2018-12-31 47           47               47
834 834 ST JOSEPH HOSPITAL 360 BROADWAY BANGOR ME 4401 PENOBSCOT (207) 262-1000 Acute Care Hospitals Voluntary non-profit - Church TRUE 44.8145300 -68.7712600 0   19 23 23019 12620   Central Penobscot County https://data.medicare.gov/resource/xubh-q36u/row-ad3u-g4s7-xxty 200001 650700 2019-06-03 2018-12-31 92 7         99               99
3454 3454 SAUK PRAIRIE HOSPITAL 260 26TH STREET PRAIRIE DU SAC WI 53578 SAUK (608) 643-3311 Acute Care Hospitals Voluntary non-profit - Private TRUE 43.2877180 -89.7560720 0   111 55 55111 12660 Madison-Janesville-Beloit, WI Central Sauk County https://data.medicare.gov/resource/xubh-q36u/row-egsq~kcsf.jwct 520095 650924 2019-06-03 2018-12-31 36           36               36
1552 1552 UNITED MEMORIAL MEDICAL CENTER 127 NORTH STREET BATAVIA NY 14020 GENESEE (585) 343-6030 Acute Care Hospitals Voluntary non-profit - Private TRUE 43.0039970 -78.1775920 0   37 36 36037 12860 Rochester-Batavia-Seneca Falls, NY Central Genesee County https://data.medicare.gov/resource/xubh-q36u/row-zitz.a8b6_y8c2 330073 651023 2019-06-03 2018-12-31 123 10         133               133
4574 4574 PALACIOS COMMUNITY MEDICAL CENTER 311 GREEN AVENUE PALACIOS TX 77465 MATAGORDA (361) 972-2511 Critical Access Hospitals Voluntary non-profit - Private TRUE 28.7174570 -96.2127670 0   321 48 48321 13060 Houston-The Woodlands, TX Central Matagorda County https://data.medicare.gov/resource/xubh-q36u/row-e88j_uxba~jujd 451332 650379 2019-06-03 2018-12-31 17           17               17
868 868 MONTGOMERY GENERAL HOSPITAL, INC 401 SIXTH AVENUE MONTGOMERY WV 25136 FAYETTE (304) 442-5151 Critical Access Hospitals Voluntary non-profit - Private TRUE 38.1828780 -81.3247080 0   19 54 54019 13220   Central Fayette County https://data.medicare.gov/resource/xubh-q36u/row-3eev_ya4k~dm4q 511318 651094 2019-06-03 2018-12-31 25           25       44       69
2965 2965 MARY RUTAN HOSPITAL 205 PALMER AVENUE BELLEFONTAINE OH 43311 LOGAN (937) 599-7002 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.3689540 -83.7567030 0   91 39 39091 13340 Columbus-Marion-Zanesville, OH Central Logan County https://data.medicare.gov/resource/xubh-q36u/row-u8by-si54-g6yd 360197 649646 2019-06-03 2018-12-31 33   6       39               39
782 782 ST CHARLES BEND 2500 NE NEFF ROAD BEND OR 97701 DESCHUTES (541) 382-4321 Acute Care Hospitals Voluntary non-profit - Private TRUE 44.0657570 -121.2666610 0   17 41 41017 13460 Bend-Redmond-Prineville, OR Central Deschutes County https://data.medicare.gov/resource/xubh-q36u/row-c338~bvm4~22pp 380047 651050 2019-06-03 2018-12-31 192 30         222 15 13           250
783 783 ST CHARLES REDMOND 1253 NW CANAL BLVD REDMOND OR 97756 DESCHUTES (541) 548-8131 Acute Care Hospitals Voluntary non-profit - Private TRUE 44.2887030 -121.1685580 0   17 41 41017 13460 Bend-Redmond-Prineville, OR Central Deschutes County https://data.medicare.gov/resource/xubh-q36u/row-hegt-uv48.px87 380040 651049 2019-06-03 2018-12-31 42 6         48               48
2503 2503 CHILDREN'S HOSPITAL OF ALABAMA 1600 SEVENTH AVENUE SOUTH BIRMINGHAM AL 35233 JEFFERSON (205) 939-9100 Childrens Voluntary non-profit - Private TRUE 33.5032220 -86.8053810 0   73 1 1073 13820 Birmingham-Hoover-Talladega, AL Central Jefferson County https://data.medicare.gov/resource/xubh-q36u/row-nh6w~rxvd~itst 13300 651162 2019-06-03 2018-12-31 193     6     341               341
3555 3555 RIVERSIDE MEDICAL CENTER 1900 SOUTH MAIN ST FRANKLINTON LA 70438 WASHINGTON (985) 795-4431 Critical Access Hospitals Government - Hospital District or Authority TRUE 30.8351320 -90.1519790 0   117 22 22117 14220 New Orleans-Metairie-Hammond, LA-MS Central Washington Parish https://data.medicare.gov/resource/xubh-q36u/row-biqu.ctdj-naqx 191313 649031 2019-06-03 2018-12-31 20 5         25               25
591 591 LONGMONT UNITED HOSPITAL 1950 MOUNTAIN VIEW AVE LONGMONT CO 80501 BOULDER (303) 651-5111 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.1813240 -105.1263820 0   13 8 8013 14500 Denver-Aurora, CO Central Boulder County https://data.medicare.gov/resource/xubh-q36u/row-46cx.u9fm~wqwb 60003 649707 2019-06-03 2018-12-31 109 16         131               131
592 592 CENTURA HEALTH-AVISTA ADVENTIST HOSPITAL 100 HEALTH PARK DR LOUISVILLE CO 80027 BOULDER (303) 673-1280 Acute Care Hospitals Voluntary non-profit - Church TRUE 39.9508470 -105.1491540 0   13 8 8013 14500 Denver-Aurora, CO Central Boulder County https://data.medicare.gov/resource/xubh-q36u/row-mqpm_6h4w_if8p 60103 649709 2019-06-03 2018-12-31 74 8         108               108
595 595 GOOD SAMARITAN MEDICAL CENTER 200 EXEMPLA CIRCLE LAFAYETTE CO 80026 BOULDER (303) 689-4000 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.9697530 -105.0830650 0   13 8 8013 14500 Denver-Aurora, CO Central Boulder County https://data.medicare.gov/resource/xubh-q36u/row-rxs8-5fmc-dv4k 60116 650243 2019-06-03 2018-12-31 147 24         183               183
1155 1155 BERTRAND CHAFFEE HOSPITAL 224 EAST MAIN STREET SPRINGVILLE NY 14141 ERIE (716) 592-2871 Acute Care Hospitals Voluntary non-profit - Church TRUE 42.5084840 -78.6592350 0   29 36 36029 15380 Buffalo-Cheektowaga, NY Central Erie County https://data.medicare.gov/resource/xubh-q36u/row-kh2y-a8h3~k7jx 330111 650864 2019-06-03 2018-12-31 21   2       23       80       103
1157 1157 SISTERS OF CHARITY HOSPITAL 2157 MAIN STREET BUFFALO NY 14214 ERIE (716) 862-1000 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.9291700 -78.8499160 0   29 36 36029 15380 Buffalo-Cheektowaga, NY Central Erie County https://data.medicare.gov/resource/xubh-q36u/row-tkhh.t5uq_u2r8 330078 650858 2019-06-03 2018-12-31 316 30       40 386       80       466
2158 2158 SOUTHEASTERN OHIO REGIONAL MEDICAL CENTER 1341 NORTH CLARK STREET CAMBRIDGE OH 43725 GUERNSEY (740) 439-8000 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.0402720 -81.5767340 0   59 39 39059 15740 Columbus-Marion-Zanesville, OH Central Guernsey County https://data.medicare.gov/resource/xubh-q36u/row-nxt8.i9qt-fkcc 360203 649647 2019-06-03 2018-12-31 79 11         90               90
4045 4045 AULTMAN HOSPITAL 2600 SIXTH STREET SW CANTON OH 44710 STARK (330) 363-6352 Acute Care Hospitals Voluntary non-profit - Other TRUE 40.7968520 -81.4035750 0   151 39 39151 15940 Cleveland-Akron-Canton, OH Central Stark County https://data.medicare.gov/resource/xubh-q36u/row-skwz~ncuf-62nj 360084 649319 2019-06-03 2018-12-31 333 20 26   18   422   30   60       512
4047 4047 ALLIANCE COMMUNITY HOSPITAL 200 EAST STATE STREET ALLIANCE OH 44601 STARK (330) 596-7018 Acute Care Hospitals Voluntary non-profit - Other TRUE 40.9016790 -81.1027360 0   151 39 39151 15940 Cleveland-Akron-Canton, OH Central Stark County https://data.medicare.gov/resource/xubh-q36u/row-9pb7.6hrh_xxpz 360131 649642 2019-06-03 2018-12-31 43 12         55 12     78       145
1278 1278 SOUTHEASTHEALTH 1701 LACEY ST CAPE GIRARDEAU MO 63701 CAPE GIRARDEAU (573) 334-4822 Acute Care Hospitals Voluntary non-profit - Private TRUE 37.3112730 -89.5409360 0   31 29 29031 16020 Cape Girardeau-Sikeston, MO-IL Central Cape Girardeau County https://data.medicare.gov/resource/xubh-q36u/row-3xtx.vgkn~wt2v 260110 650168 2019-06-03 2018-12-31 155           181   13           194
1261 1261 SOUTH SHORE HOSPITAL 8012 SOUTH CRANDON AVENUE CHICAGO IL 60617 COOK (773) 356-5000 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.7494960 -87.5686230 0   31 17 17031 16980 Chicago-Naperville, IL-IN-WI Central Cook County https://data.medicare.gov/resource/xubh-q36u/row-9q83~u6ff_gcv4 140181 650991 2019-06-03 2018-12-31 114 8         122 15             137
2245 2245 MORRIS HOSPITAL & HEALTHCARE CENTERS 150 W HIGH ST MORRIS IL 60450 GRUNDY (815) 942-2932 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.3689070 -88.4260160 0   63 17 17063 16980 Chicago-Naperville, IL-IN-WI Outlying Grundy County https://data.medicare.gov/resource/xubh-q36u/row-ppby~a88z-i4tu 140101 650988 2019-06-03 2018-12-31 81 8         89               89
2527 2527 FRANCISCAN HEALTH RENSSELAER, INC 1104 E GRACE ST RENSSELAER IN 47978 JASPER (219) 866-5141 Critical Access Hospitals Voluntary non-profit - Private TRUE 40.9336000 -87.1383570 0   73 18 18073 16980 Chicago-Naperville, IL-IN-WI Outlying Jasper County https://data.medicare.gov/resource/xubh-q36u/row-agmh.b8j2-sp7x 151324 649574 2019-06-03 2018-12-31 21 4         25               25
2895 2895 FRANCISCAN HEALTH DYER 24 JOLIET ST DYER IN 46311 LAKE (219) 865-2141 Acute Care Hospitals Voluntary non-profit - Church TRUE 41.4943650 -87.5241660 0   89 18 18089 16980 Chicago-Naperville, IL-IN-WI Central Lake County https://data.medicare.gov/resource/xubh-q36u/row-ptgy-v6qn-79qv 150090 649568 2019-06-03 2018-12-31 119 14 7       140   30           170
2897 2897 FRANCISCAN HEALTH MUNSTER 701 SUPERIOR AVE MUNSTER IN 46321 LAKE (219) 922-4200 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.5372580 -87.5123280 0   89 18 18089 16980 Chicago-Naperville, IL-IN-WI Central Lake County https://data.medicare.gov/resource/xubh-q36u/row-4w5v-bey2.ne8p 150165 649898 2019-06-03 2018-12-31 54 9         63               63
2898 2898 METHODIST HOSPITALS INC 600 GRANT ST GARY IN 46402 LAKE (219) 886-4000 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.5994360 -87.3570230 0   89 18 18089 16980 Chicago-Naperville, IL-IN-WI Central Lake County https://data.medicare.gov/resource/xubh-q36u/row-gwec.rzge~fuke 150002 649559 2019-06-03 2018-12-31 382 39         456 14 39           509
2899 2899 FRANCISCAN HEALTH CROWN POINT 1201 S MAIN ST CROWN POINT IN 46307 LAKE (219) 757-6100 Acute Care Hospitals Voluntary non-profit - Church TRUE 41.3964970 -87.3644360 0   89 18 18089 16980 Chicago-Naperville, IL-IN-WI Central Lake County https://data.medicare.gov/resource/xubh-q36u/row-bu7y_i7m5~izb5 150126 649896 2019-06-03 2018-12-31 172 22       20 214               214
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
1313 1313 SUTTER LAKESIDE HOSPITAL 5176 HILL ROAD EAST LAKEPORT CA 95453 LAKE (707) 262-5000 Critical Access Hospitals Voluntary non-profit - Private TRUE 39.1051750 -122.9082380 0   33 6 6033 17340   Central Lake County https://data.medicare.gov/resource/xubh-q36u/row-eiws_bxxs~n9dn 51329 650960 2019-06-03 2018-12-31 21 4         25               25
1410 1410 UNIVERSITY HOSPITALS AHUJA MEDICAL CENTER 3999 RICHMOND ROAD BEACHWOOD OH 44122 CUYAHOGA (216) 593-5510 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.4532710 -81.4977080 0   35 39 39035 17460 Cleveland-Akron-Canton, OH Central Cuyahoga County https://data.medicare.gov/resource/xubh-q36u/row-h29e.2x8g.g5ac 360359 649650 2019-06-03 2018-12-31 117 20         137               137

Next page

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