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

305 rows where "filed_date" is on date 2019-12-02 sorted by centraloutlyingcounty

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

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

filed_date (date) ✖

  • 2019-12-02 · 305 ✖
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
6 6 CENTRAL MONTANA MEDICAL CENTER 408 WENDELL AVE LEWISTOWN MT 59457 FERGUS (406) 535-7711 Critical Access Hospitals Voluntary non-profit - Private TRUE 47.0584640 -109.4422430 0   27 30 30027         https://data.medicare.gov/resource/xubh-q36u/row-hefc~6xn5~i2c7 271345 661545 2019-12-02 2019-06-30 23           23               23
17 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
31 31 ST MARKS MEDICAL CENTER ONE ST MARK'S PLACE LA GRANGE TX 78945 FAYETTE (979) 242-2200 Acute Care Hospitals Voluntary non-profit - Private TRUE 29.9353227 -96.8763382 1 ROOFTOP 149 48 48149         https://data.medicare.gov/resource/xubh-q36u/row-sffi-gqgq~nh45 670004 660902 2019-12-02 2019-06-30 38           38               38
35 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 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
118 118 MEMORIAL HOSPITAL 1401 WEST LOCUST STILWELL OK 74960 ADAIR (918) 696-3101 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.8085290 -94.6430100 0   1 40 40001         https://data.medicare.gov/resource/xubh-q36u/row-7atr.sncy~icbf 370178 660001 2019-12-02 2019-06-30 30           30 10             40
119 119 SAINT ALPHONSUS MEDICAL CENTER - BAKER CITY, INC 3325 POCAHONTAS ROAD BAKER CITY OR 97814 BAKER (541) 524-7744 Critical Access Hospitals Voluntary non-profit - Church TRUE 44.7961200 -117.8462850 0   1 41 41001         https://data.medicare.gov/resource/xubh-q36u/row-yt65-wbpr_7cai 381315 661086 2019-12-02 2019-06-30 19 2         21               21
171 171 CHI HEALTH - MERCY CORNING 603 ROSARY DRIVE CORNING IA 50841 ADAMS (641) 322-3121 Critical Access Hospitals Voluntary non-profit - Private TRUE 40.9883750 -94.7479140 0   3 19 19003         https://data.medicare.gov/resource/xubh-q36u/row-bgwm_q3kt_uw3g 161304 661177 2019-12-02 2019-06-30 22           22               22
174 174 ALLEN PARISH HOSPITAL 108 6TH AVENUE KINDER LA 70648 ALLEN (337) 738-2527 Acute Care Hospitals Government - Hospital District or Authority TRUE 30.4914530 -92.8556480 0   3 22 22003         https://data.medicare.gov/resource/xubh-q36u/row-572u~e5cv~bbuy 190133 659958 2019-12-02 2019-06-30 25           25 24             49
188 188 ANTELOPE MEMORIAL HOSPITAL P O BOX 229, 102 WEST 9TH ST NELIGH NE 68756 ANTELOPE (402) 887-4151 Critical Access Hospitals Voluntary non-profit - Private TRUE 42.1336539 -98.0299847 1 ROOFTOP 3 31 31003         https://data.medicare.gov/resource/xubh-q36u/row-uv86-cr3r-pfws 281326 661040 2019-12-02 2019-06-30 23           23               23
217 217 JONES MEMORIAL HOSPITAL 191 NORTH MAIN STREET WELLSVILLE NY 14895 ALLEGANY (585) 593-1100 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.1228780 -77.9497840 0   3 36 36003         https://data.medicare.gov/resource/xubh-q36u/row-nxxz~ksxe.5xk3 330096 662230 2019-12-02 2019-06-30 43 6         49               49
274 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
348 348 SHANDS STARKE REGIONAL MEDICAL CENTER 922 E CALL ST STARKE FL 32091 BRADFORD (904) 368-2300 Critical Access Hospitals Proprietary TRUE 29.9419070 -82.1016500 0   7 12 12007         https://data.medicare.gov/resource/xubh-q36u/row-463i.u2z5-p3cq 101310 660199 2019-12-02 2019-06-30 25           25               25
353 353 MERCYONE CENTERVILLE MEDICAL CENTER ONE ST JOSEPH'S DRIVE CENTERVILLE IA 52544 APPANOOSE (641) 437-4111 Critical Access Hospitals Voluntary non-profit - Private TRUE 40.7555228 -92.8568047 1 ROOFTOP 7 19 19007         https://data.medicare.gov/resource/xubh-q36u/row-quyx-h8pq.iqb9 161377 660989 2019-12-02 2019-06-30 22 3         25           19   44
622 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
744 744 RUMFORD HOSPITAL 420 FRANKLIN STREET RUMFORD ME 4276 OXFORD (207) 369-1000 Critical Access Hospitals Proprietary TRUE 44.5517210 -70.5571710 0   17 23 23017         https://data.medicare.gov/resource/xubh-q36u/row-923a_kexq.nxfx 201306 662536 2019-12-02 2019-06-30 25           25               25
954 954 GARRETT COUNTY MEMORIAL HOSPITAL 251 NORTH FOURTH STREET OAKLAND MD 21550 GARRETT (301) 533-4173 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.4133250 -79.4027300 0   23 24 24023         https://data.medicare.gov/resource/xubh-q36u/row-t8h3.7jnz_zwmx 210017 660818 2019-12-02 2019-06-30 25 2         27       10       37
964 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
1001 1001 REDINGTON FAIRVIEW GENERAL HOSPITAL 46 FAIRVIEW AVE PO BOX 468 SKOWHEGAN ME 4976 SOMERSET (207) 474-5121 Critical Access Hospitals Proprietary TRUE 44.7583360 -69.7134950 0   25 23 23025         https://data.medicare.gov/resource/xubh-q36u/row-g9mx~aw3n.5hnn 201314 661526 2019-12-02 2019-06-30 21 4         25               25
1061 1061 NORTHERN INYO HOSPITAL 150 PIONEER LANE BISHOP CA 93514 INYO (760) 873-5811 Critical Access Hospitals Government - Hospital District or Authority TRUE 37.3621080 -118.4073620 0   27 6 6027         https://data.medicare.gov/resource/xubh-q36u/row-mi4n-bdvc~nrpd 51324 661291 2019-12-02 2019-06-30 21 4         25               25
1062 1062 SOUTHERN INYO HOSPITAL 501 EAST LOCUST STREET LONE PINE CA 93545 INYO (760) 876-5501 Critical Access Hospitals Government - Hospital District or Authority TRUE 36.6083740 -118.0581590 0   27 6 6027         https://data.medicare.gov/resource/xubh-q36u/row-wcp4_jkw5.du53 51302 659919 2019-12-02 2019-06-30 4           4       33       37
1070 1070 MANNING REGIONAL HEALTHCARE CENTER 1550 SIXTH STREET MANNING IA 51455 CARROLL (712) 655-2072 Critical Access Hospitals Voluntary non-profit - Private TRUE 41.9066500 -95.0750130 0   27 19 19027         https://data.medicare.gov/resource/xubh-q36u/row-guzz_e3r6~bpt6 161332 660967 2019-12-02 2019-06-30 17           17           46   63
1122 1122 CHI ST VINCENT MORRILTON #4 HOSPITAL DRIVE MORRILTON AR 72110 CONWAY (501) 977-2300 Critical Access Hospitals Voluntary non-profit - Church TRUE 35.1699700 -92.7217020 0   29 5 5029         https://data.medicare.gov/resource/xubh-q36u/row-jajp~f47n.nife 41324 660162 2019-12-02 2019-06-30 25           25               25
1141 1141 UMD SHORE MEDICAL CTR AT CHESTERTOWN 100 BROWN STREET CHESTERTOWN MD 21620 KENT (410) 778-7668 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.2168450 -76.0644920 0   29 24 24029         https://data.medicare.gov/resource/xubh-q36u/row-9gun.f2aw-guni 210030 660229 2019-12-02 2019-06-30 15 6         21               21
1549 1549 CHI HEALTH SCHUYLER 104 WEST 17TH ST SCHUYLER NE 68661 COLFAX (402) 352-2441 Critical Access Hospitals Voluntary non-profit - Private TRUE 41.4545790 -97.0597250 0   37 31 31037         https://data.medicare.gov/resource/xubh-q36u/row-jpni~j9gv~awkb 281323 661039 2019-12-02 2019-06-30 25           25               25
1660 1660 INTEGRIS GROVE HOSPITAL 1001 EAST 18TH STREET GROVE OK 74344 DELAWARE (918) 786-2243 Acute Care Hospitals Voluntary non-profit - Private TRUE 36.5800860 -94.7572590 0   41 40 40041         https://data.medicare.gov/resource/xubh-q36u/row-sxxq.2snt_q3gw 370113 660140 2019-12-02 2019-06-30 52 6         58               58
1682 1682 JOHN C FREMONT HEALTHCARE DISTRICT 5189 HOSPITAL ROAD MARIPOSA CA 95338 MARIPOSA (209) 966-3631 Critical Access Hospitals Government - Hospital District or Authority TRUE 37.5005310 -119.9769480 0   43 6 6043         https://data.medicare.gov/resource/xubh-q36u/row-fty8~tgqe.f5tj 51304 661465 2019-12-02 2019-06-30 18           18       16   1   35
1693 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
1779 1779 CRAWFORD COUNTY MEMORIAL HOSPITAL 100 MEDICAL PARKWAY DENISON IA 51442 CRAWFORD (712) 265-2500 Critical Access Hospitals Voluntary non-profit - Other TRUE 42.0232570 -95.3770860 0   47 19 19047         https://data.medicare.gov/resource/xubh-q36u/row-9ydn-ts52-gjkc 161369 660986 2019-12-02 2019-06-30 25           25               25
1824 1824 WELCH COMMUNITY HOSPITAL 454 MCDOWELL STREET WELCH WV 24801 MC DOWELL (304) 436-8461 Acute Care Hospitals Government - State TRUE 37.4388220 -81.5892950 0   47 54 54047         https://data.medicare.gov/resource/xubh-q36u/row-y7rn~73h2.fggs 510086 661439 2019-12-02 2019-06-30 42 7         49         59     108
1827 1827 FULTON COUNTY HOSPITAL 679 NORTH MAIN STREET SALEM AR 72576 FULTON (870) 895-2691 Critical Access Hospitals Voluntary non-profit - Other TRUE 36.3833590 -91.8112030 0   49 5 5049         https://data.medicare.gov/resource/xubh-q36u/row-9b6n-wd2m.b7tm 41322 660913 2019-12-02 2019-06-30 25           25               25
1907 1907 MIDMICHIGAN MEDICAL CENTER-GLADWIN 515 QUARTER STREET GLADWIN MI 48624 GLADWIN (989) 426-9286 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.9757310 -84.4953540 0   51 26 26051         https://data.medicare.gov/resource/xubh-q36u/row-mi7y.a5rw~xqzh 231325 661022 2019-12-02 2019-06-30 25           25               25
1917 1917 ASHLEY MEDICAL CENTER 612 CENTER AVENUE N ASHLEY ND 58413 MCINTOSH (701) 288-3433 Critical Access Hospitals Voluntary non-profit - Private TRUE 46.0401880 -99.3717150 0   51 38 38051         https://data.medicare.gov/resource/xubh-q36u/row-ecd4.9q4x_twgv 351322 661581 2019-12-02 2019-06-30 20           20       40       60
1950 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 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
2085 2085 HARMON MEMORIAL HOSPITAL 400 EAST CHESTNUT STREET HOLLIS OK 73550 HARMON (580) 688-3363 Critical Access Hospitals Government - Hospital District or Authority TRUE 34.6915370 -99.9143660 0   57 40 40057         https://data.medicare.gov/resource/xubh-q36u/row-uie3-brwx.iwxd 371338 661083 2019-12-02 2019-06-30 22           22               22
2162 2162 WASHINGTON HEALTH SYSTEM GREENE 350 BONAR AVENUE WAYNESBURG PA 15370 GREENE (724) 627-2602 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.9006050 -80.1739290 0   59 42 42059         https://data.medicare.gov/resource/xubh-q36u/row-an6b-ia9u-kxvy 390150 662137 2019-12-02 2019-06-30 23           23               23
2240 2240 SENECA DISTRICT HOSPITAL 130 BRENTWOOD DRIVE CHESTER CA 96020 PLUMAS (530) 258-2121 Critical Access Hospitals Voluntary non-profit - Other TRUE 40.3053020 -121.2340180 0   63 6 6063         https://data.medicare.gov/resource/xubh-q36u/row-6rw5.c6e6.9puv 51327 661143 2019-12-02 2019-06-30 10           10       16       26
2312 2312 ROUNDUP MEMORIAL HEALTHCARE 1202 3RD ST W ROUNDUP MT 59072 MUSSELSHELL (406) 323-2301 Critical Access Hospitals Government - Hospital District or Authority TRUE 46.4533500 -108.5463330 0   65 30 30065         https://data.medicare.gov/resource/xubh-q36u/row-4hiv-3ibs~jee7 271346 661357 2019-12-02 2019-06-30 25           25               25
2323 2323 PUNXSUTAWNEY AREA HOSPITAL 81 HILLCREST DRIVE PUNXSUTAWNEY PA 15767 JEFFERSON (814) 938-1800 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.9601530 -79.0003590 0   65 42 42065         https://data.medicare.gov/resource/xubh-q36u/row-6q8y-is36.pc3n 390199 661098 2019-12-02 2019-06-30 39 5         44               44
2370 2370 JEFFERSON COUNTY HOSPITAL INTERSECTION HYWS 81 & 70 WAURIKA OK 73573 JEFFERSON (580) 228-2344 Critical Access Hospitals Voluntary non-profit - Private TRUE 34.1572807 -97.9795416 1 GEOMETRIC_CENTER 67 40 40067         https://data.medicare.gov/resource/xubh-q36u/row-ph4g-iebq.bzzs 371311 662416 2019-12-02 2019-06-30 25           25               25
2459 2459 HIGHLANDS REGIONAL MEDICAL CENTER 5000 KENTUCKY ROUTE 321 PRESTONSBURG KY 41653 FLOYD (606) 886-8511 Acute Care Hospitals Proprietary TRUE 37.7105400 -82.7702500 0   71 21 21071         https://data.medicare.gov/resource/xubh-q36u/row-iny2.6yju.g3qs 180005 662526 2019-12-02 2019-06-30 115 12         127 23             150
2478 2478 CHI ST ALEXIUS HEALTH DEVILS LAKE 1031 7TH ST NE DEVILS LAKE ND 58301 RAMSEY (701) 662-2131 Critical Access Hospitals Voluntary non-profit - Private TRUE 48.1147740 -98.8503450 0   71 38 38071         https://data.medicare.gov/resource/xubh-q36u/row-i8ea.ub9b_eqnm 351333 662067 2019-12-02 2019-06-30 25           25               25
2489 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 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
2652 2652 PRAIRIE COMMUNITY HOSPITAL 312 S ADAMS TERRY MT 59349 PRAIRIE (406) 635-5511 Critical Access Hospitals Government - Hospital District or Authority TRUE 46.7915060 -105.3159970 0   79 30 30079         https://data.medicare.gov/resource/xubh-q36u/row-cwxm-q75h-madz 271309 660253 2019-12-02 2019-06-30 22           22               22
2904 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 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
3111 3111 ST GABRIELS HOSPITAL 815 SOUTHEAST SECOND STREET LITTLE FALLS MN 56345 MORRISON (320) 632-5441 Critical Access Hospitals Voluntary non-profit - Private TRUE 45.9677110 -94.3626510 0   97 27 27097         https://data.medicare.gov/resource/xubh-q36u/row-u3qn-h44f-9as3 241370 661542 2019-12-02 2019-06-30 19   6       25               25
3186 3186 FLAMBEAU HOSPITAL 98 SHERRY AVE PARK FALLS WI 54552 PRICE (715) 762-7500 Critical Access Hospitals Voluntary non-profit - Private TRUE 45.9310980 -90.4419720 0   99 55 55099         https://data.medicare.gov/resource/xubh-q36u/row-mtm9~rxnu.g2qc 521325 662628 2019-12-02 2019-06-30 20 4         24           1   25
3200 3200 LAWRENCE COUNTY MEMORIAL HOSPITAL 2200 STATE ST LAWRENCEVILLE IL 62439 LAWRENCE (618) 943-1000 Critical Access Hospitals Voluntary non-profit - Private TRUE 38.7295180 -87.6941500 0   101 17 17101         https://data.medicare.gov/resource/xubh-q36u/row-i6xv_c446~uej5 141344 660930 2019-12-02 2019-06-30 25           25               25
3240 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 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
3327 3327 UPMC COLE 1001 EAST SECOND STREET COUDERSPORT PA 16915 POTTER (814) 274-9301 Critical Access Hospitals Voluntary non-profit - Other TRUE 41.7706670 -77.9797410 0   105 42 42105         https://data.medicare.gov/resource/xubh-q36u/row-addx-8ax4.us6v 391313 662251 2019-12-02 2019-06-30 21 4         25       44       69
3356 3356 AVERA GETTYSBURG HOSPITAL 606 EAST GARFIELD GETTYSBURG SD 57442 POTTER (605) 765-2480 Critical Access Hospitals Voluntary non-profit - Church TRUE 45.0135510 -99.9481280 0   107 46 46107         https://data.medicare.gov/resource/xubh-q36u/row-5ptc-f9a4-vq7p 431302 660878 2019-12-02 2019-06-30 10           10           50   60
3552 3552 LUCAS COUNTY HEALTH CENTER 1200 NORTH 7TH STREET CHARITON IA 50049 LUCAS (641) 774-3000 Critical Access Hospitals Voluntary non-profit - Other TRUE 41.0276930 -93.3034210 0   117 19 19117         https://data.medicare.gov/resource/xubh-q36u/row-6kae-djtk-d35x 161341 660973 2019-12-02 2019-06-30 25           25               25
3628 3628 SHANDS LIVE OAK REGIONAL MEDICAL CENTER 1100 SW 11TH ST LIVE OAK FL 32060 SUWANNEE (904) 362-1413 Critical Access Hospitals Proprietary TRUE 30.2917367 -83.0028124 1 ROOFTOP 121 12 12121         https://data.medicare.gov/resource/xubh-q36u/row-keij_wts9-t8jc 101301 660198 2019-12-02 2019-06-30 25           25               25
3668 3668 CENTRAL PENINSULA GENERAL HOSPITAL 250 HOSPITAL PLACE SOLDOTNA AK 99669 KENAI PENINSULA (907) 262-4404 Acute Care Hospitals Voluntary non-profit - Other TRUE 60.4938650 -151.0776580 0   122 2 2122         https://data.medicare.gov/resource/xubh-q36u/row-kgwk-j25h-z8m3 20024 661276 2019-12-02 2019-06-30 43 6         49       60       109
3688 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
3706 3706 KNOXVILLE HOSPITAL & CLINICS 1002 SOUTH LINCOLN STREET KNOXVILLE IA 50138 MARION (641) 842-2151 Critical Access Hospitals Voluntary non-profit - Private TRUE 41.3109860 -93.1095110 0   125 19 19125         https://data.medicare.gov/resource/xubh-q36u/row-6isd~id7e-3xdw 161355 660980 2019-12-02 2019-06-30 25           25               25
3758 3758 WAYNE MEMORIAL HOSPITAL 601 PARK STREET HONESDALE PA 18431 WAYNE (570) 253-8100 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.5762840 -75.2597960 0   127 42 42127         https://data.medicare.gov/resource/xubh-q36u/row-dwrj-acy3.k8c3 390125 661251 2019-12-02 2019-06-30 68 8         76   14           90
3784 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
3814 3814 CHI HEALTH ST MARY'S 1301 GRUNDMAN BLVD NEBRASKA CITY NE 68410 OTOE (402) 873-3321 Critical Access Hospitals Voluntary non-profit - Church TRUE 40.6581520 -95.8621090 0   131 31 31131         https://data.medicare.gov/resource/xubh-q36u/row-6z57~cf6y.zams 281342 661042 2019-12-02 2019-06-30 18           18               18
3827 3827 BURGESS HEALTH CENTER 1600 DIAMOND STREET ONAWA IA 51040 MONONA (712) 423-2311 Critical Access Hospitals Voluntary non-profit - Private TRUE 42.0257390 -96.1055860 0   133 19 19133         https://data.medicare.gov/resource/xubh-q36u/row-hw7j.7dfu.cqug 161359 660983 2019-12-02 2019-06-30 25           25               25
3834 3834 PAWNEE COUNTY MEMORIAL HOSPITAL P O BOX 433, 600 I ST PAWNEE CITY NE 68420 PAWNEE (402) 852-2231 Critical Access Hospitals Proprietary TRUE 40.1098396 -96.1532422 1 ROOFTOP 133 31 31133         https://data.medicare.gov/resource/xubh-q36u/row-2ahw-y3eh_6phq 281302 661036 2019-12-02 2019-06-30 17           17               17
3844 3844 EASTLAND MEMORIAL HOSPITAL 304 S DAUGHERTY EASTLAND TX 76448 EASTLAND (254) 629-2601 Acute Care Hospitals Government - Hospital District or Authority TRUE 32.4004390 -98.8216360 0   133 48 48133         https://data.medicare.gov/resource/xubh-q36u/row-uts8~dkzz-h488 450411 660325 2019-12-02 2019-06-30 36           36               36
3853 3853 ST VINCENT RANDOLPH HOSPITAL INC 473 E GREENVILLE AVE WINCHESTER IN 47394 RANDOLPH (765) 584-0004 Critical Access Hospitals Voluntary non-profit - Private TRUE 40.1678770 -84.9703940 0   135 18 18135         https://data.medicare.gov/resource/xubh-q36u/row-ziei~9dqq.tkpr 151301 660946 2019-12-02 2019-06-30 25           25               25
3854 3854 MONROE COUNTY HOSPITAL 6580 165TH STREET ALBIA IA 52531 MONROE (641) 932-2134 Critical Access Hospitals Voluntary non-profit - Other TRUE 41.0448380 -92.7964750 0   135 19 19135         https://data.medicare.gov/resource/xubh-q36u/row-wtqj-qihw~wgcb 161342 660974 2019-12-02 2019-06-30 25           25               25
3859 3859 PERKINS COUNTY HEALTH SERVICES 900 LINCOLN AVE GRANT NE 69140 PERKINS (308) 352-7200 Critical Access Hospitals Government - Hospital District or Authority TRUE 40.8482680 -101.7271820 0   135 31 31135         https://data.medicare.gov/resource/xubh-q36u/row-g4pp~ymgi-thrv 281356 661045 2019-12-02 2019-06-30 20           20           50   70
3910 3910 OZARK HEALTH 2500 HIGHWAY 65 SOUTH CLINTON AR 72031 VAN BUREN (501) 745-7000 Critical Access Hospitals Voluntary non-profit - Private TRUE 35.5593750 -92.4499130 0   141 5 5141         https://data.medicare.gov/resource/xubh-q36u/row-3ppd-9bg7~xqjh 41313 661137 2019-12-02 2019-06-30 25           25       118       143
3972 3972 CLARINDA REGIONAL HEALTH CENTER 220 ESSIE DAVISON DRIVE CLARINDA IA 51632 PAGE (712) 542-2176 Critical Access Hospitals Voluntary non-profit - Other TRUE 40.7231160 -95.0414060 0   145 19 19145         https://data.medicare.gov/resource/xubh-q36u/row-e24e-jv8q.avua 161352 661182 2019-12-02 2019-06-30 25           25               25
3987 3987 COMMUNITY HOSPITAL P O BOX 1328, 1301 EAST H ST MCCOOK NE 69001 RED WILLOW (308) 344-2650 Critical Access Hospitals Voluntary non-profit - Other TRUE 40.2004042 -100.6317977 1 ROOFTOP 145 31 31145         https://data.medicare.gov/resource/xubh-q36u/row-b3ww-n6dr.gmwh 281363 661048 2019-12-02 2019-06-30 25           25               25
4186 4186 MYRTUE MEDICAL CENTER 1213 GARFIELD AVENUE HARLAN IA 51537 SHELBY (712) 755-5161 Critical Access Hospitals Voluntary non-profit - Other TRUE 41.6474730 -95.3262020 0   165 19 19165         https://data.medicare.gov/resource/xubh-q36u/row-cvsd.wj8m_w54b 161374 660988 2019-12-02 2019-06-30 25           25               25
4230 4230 ST VINCENT WILLIAMSPORT HOSPITAL INC 412 N MONROE ST WILLIAMSPORT IN 47993 WARREN (765) 762-4000 Critical Access Hospitals Voluntary non-profit - Church TRUE 40.2904700 -87.2958190 0   171 18 18171         https://data.medicare.gov/resource/xubh-q36u/row-hngk~n78p-82t8 151307 660948 2019-12-02 2019-06-30 16           16               16
4235 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
4256 4256 PENDER COMMUNITY HOSPITAL P O BOX 100, 100 HOSPITAL DRIVE PENDER NE 68047 THURSTON (402) 385-3083 Critical Access Hospitals Government - Hospital District or Authority TRUE 42.1055877 -96.7110334 1 ROOFTOP 173 31 31173         https://data.medicare.gov/resource/xubh-q36u/row-iane_yp36_h5j2 281349 661213 2019-12-02 2019-06-30 21           21               21
4268 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
4375 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 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
4570 4570 MADISON ST JOSEPH HEALTH CENTER 100 WEST CROSS STREET MADISONVILLE TX 77864 MADISON (936) 348-2631 Critical Access Hospitals Voluntary non-profit - Church TRUE 30.9420460 -95.9099560 0   313 48 48313         https://data.medicare.gov/resource/xubh-q36u/row-nns8-bhuk_vxd6 451316 660055 2019-12-02 2019-06-30 15           15               15
23 23 ST LUKE'S HOSPITAL - ANDERSON CAMPUS 1872 ST LUKE'S BLVD EASTON PA 18045 NORTHAMPTON (484) 503-3000 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.6500610 -75.2885310 0   95 42 42095 10900 New York-Newark, NY-NJ-CT-PA Central Northampton County https://data.medicare.gov/resource/xubh-q36u/row-y5pf.9der.4yfa 390326 660448 2019-12-02 2019-06-30 96 12         108               108
55 55 CHILDREN'S HOSPITAL & RESEARCH CENTER OAKLAND 747 52ND STREET OAKLAND CA 94609 ALAMEDA (510) 428-3000 Childrens Voluntary non-profit - Private TRUE 37.8373260 -122.2677410 0   1 6 6001 41860 San Jose-San Francisco-Oakland, CA Central Alameda County https://data.medicare.gov/resource/xubh-q36u/row-n7ad_497y.9ize 53301 661145 2019-12-02 2019-06-30 123 23       44 190               190
71 71 HOWARD UNIVERSITY HOSPITAL 2041 GEORGIA AVE NW WASHINGTON DC 20060 THE DISTRICT (202) 745-6100 Acute Care Hospitals Voluntary non-profit - Other TRUE 38.9170110 -77.0218960 0   1 11 11001 47900 Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Central District of Columbia https://data.medicare.gov/resource/xubh-q36u/row-8v26.mgb3_zc6i 90003 660921 2019-12-02 2019-06-30 164 36         200               200
79 79 NORTH HAWAII COMMUNITY HOSPITAL 67 1125 MAMALAHOA HIGHWAY KAMUELA HI 96743 HAWAII (808) 885-4444 Acute Care Hospitals Voluntary non-profit - Private TRUE 20.0232419 -155.6653736 1 RANGE_INTERPOLATED 1 15 15001 25900   Central Hawaii County https://data.medicare.gov/resource/xubh-q36u/row-ntxy-3z5d.j57p 120028 662518 2019-12-02 2019-06-30 29 4         33               33
82 82 KONA COMMUNITY HOSPITAL 79-1019 HAUKAPILA STREET KEALAKEKUA HI 96750 HAWAII (808) 322-9311 Acute Care Hospitals Government - State TRUE 19.5192370 -155.9177190 0   1 15 15001 25900   Central Hawaii County https://data.medicare.gov/resource/xubh-q36u/row-j5zq.9y53_j6as 120019 662187 2019-12-02 2019-06-30 74 9         83 11             94
84 84 KAU HOSPITAL 1 KAMANI STREET PAHALA HI 96777 HAWAII (808) 928-8331 Critical Access Hospitals Government - State TRUE 19.2005710 -155.4720970 0   1 15 15001 25900   Central Hawaii County https://data.medicare.gov/resource/xubh-q36u/row-jcnf-fhnk_q5i3 121301 662188 2019-12-02 2019-06-30 6           6               6
95 95 WESTERN MARYLAND REGIONAL MEDICAL CENTER 12500 WILLOWBROOK ROAD CUMBERLAND MD 21502 ALLEGANY (240) 964-8001 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.6500910 -78.7327770 0   1 24 24001 19060   Central Allegany County https://data.medicare.gov/resource/xubh-q36u/row-x4yg.qijv.37uc 210027 661004 2019-12-02 2019-06-30 186 14         200   13           213
139 139 NORTHERN COCHISE COMMUNITY HOSPITAL, INC. 901 WEST REX ALLEN DRIVE WILLCOX AZ 85643 COCHISE (520) 384-3541 Critical Access Hospitals Government - Hospital District or Authority TRUE 32.2642680 -109.8376130 0   3 4 4003 43420   Central Cochise County https://data.medicare.gov/resource/xubh-q36u/row-ydad~45b6.8t7t 31302 660487 2019-12-02 2019-06-30 24           24       24       48
163 163 KAHUKU MEDICAL CENTER 56-117 PUALALEA STREET KAHUKU HI 96731 HONOLULU (808) 293-9221 Critical Access Hospitals Voluntary non-profit - Other TRUE 21.6764400 -157.9522110 0   3 15 15003 46520   Central Honolulu County https://data.medicare.gov/resource/xubh-q36u/row-gwji.69dv_68xy 121304 661306 2019-12-02 2019-06-30 15           15       6       21
180 180 UMD BALTIMORE WASHINGTON MEDICAL CENTER 301 HOSPITAL DRIVE GLEN BURNIE MD 21061 ANNE ARUNDEL (410) 595-1967 Acute Care Hospitals Voluntary non-profit - Other TRUE 39.1387840 -76.6222470 0   3 24 24003 12580 Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Central Anne Arundel County https://data.medicare.gov/resource/xubh-q36u/row-ny53_dgkn_gitj 210043 659804 2019-12-02 2019-06-30 242 30         272               272
183 183 BERKSHIRE MEDICAL CENTER INC - 1 725 NORTH STREET PITTSFIELD MA 1201 BERKSHIRE (413) 447-2000 Acute Care Hospitals Voluntary non-profit - Other TRUE 42.4587480 -73.2490040 0   3 25 25003 38340   Central Berkshire County https://data.medicare.gov/resource/xubh-q36u/row-58b2-r4te.ddyn 220046 661336 2019-12-02 2018-09-30 201 20         221 40 14           275
224 224 ALLEGHENY VALLEY HOSPITAL 1301 CARLISLE ST NATRONA PA 15065 ALLEGHENY (412) 224-5100 Acute Care Hospitals Voluntary non-profit - Other TRUE 40.6173780 -79.7371060 0   3 42 42003 38300 Pittsburgh-New Castle-Weirton, PA-OH-WV Central Allegheny County https://data.medicare.gov/resource/xubh-q36u/row-4dpd~v2eh.sr63 390032 660011 2019-12-02 2019-06-30 127 16         143 40 17           200
226 226 HERITAGE VALLEY SEWICKLEY 720 BLACKBURN ROAD SEWICKLEY PA 15143 ALLEGHENY (412) 741-7000 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.5435230 -80.1787560 0   3 42 42003 38300 Pittsburgh-New Castle-Weirton, PA-OH-WV Central Allegheny County https://data.medicare.gov/resource/xubh-q36u/row-b5j5.fw3x_aya4 390037 659866 2019-12-02 2019-06-30 104 12         116 14             130
228 228 JEFFERSON HOSPITAL 565 COAL VALLEY ROAD JEFFERSON HILLS PA 15025 ALLEGHENY (412) 469-5000 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.3199630 -79.9334680 0   3 42 42003 38300 Pittsburgh-New Castle-Weirton, PA-OH-WV Central Allegheny County https://data.medicare.gov/resource/xubh-q36u/row-mnnt_xhnb-r635 390265 660302 2019-12-02 2019-06-30 259 20 10       289 24 20           333
229 229 WEST PENN HOSPITAL 4800 FRIENDSHIP AVENUE PITTSBURGH PA 15224 ALLEGHENY (412) 578-5000 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.4624190 -79.9464350 0   3 42 42003 38300 Pittsburgh-New Castle-Weirton, PA-OH-WV Central Allegheny County https://data.medicare.gov/resource/xubh-q36u/row-yf26.8cka~e7ru 390090 661633 2019-12-02 2019-06-30 124 34   14   20 260   33           293
230 230 FORBES HOSPITAL 2570 HAYMAKER ROAD MONROEVILLE PA 15146 ALLEGHENY (412) 858-2000 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.4284250 -79.7512540 0   3 42 42003 38300 Pittsburgh-New Castle-Weirton, PA-OH-WV Central Allegheny County https://data.medicare.gov/resource/xubh-q36u/row-f279_i43n~yjz2 390267 659882 2019-12-02 2019-06-30 166 56         234 37 20           291
235 235 ALLEGHENY GENERAL HOSPITAL 320 EAST NORTH AVENUE PITTSBURGH PA 15212 ALLEGHENY (412) 359-3131 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.4561490 -80.0032490 0   3 42 42003 38300 Pittsburgh-New Castle-Weirton, PA-OH-WV Central Allegheny County https://data.medicare.gov/resource/xubh-q36u/row-8eek-ck8y_3ey7 390050 661092 2019-12-02 2019-06-30 430 28 24   24 24 552               552
240 240 UPMC MERCY 1400 LOCUST STREET PITTSBURGH PA 15219 ALLEGHENY (412) 232-8111 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.4368310 -79.9856230 0   3 42 42003 38300 Pittsburgh-New Castle-Weirton, PA-OH-WV Central Allegheny County https://data.medicare.gov/resource/xubh-q36u/row-csxe~5v2n_c3hc 390028 660436 2019-12-02 2019-06-30 307 20       24 369   76           445
265 265 BEEBE MEDICAL CENTER 424 SAVANNAH RD LEWES DE 19958 SUSSEX (302) 645-3300 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.7774130 -75.1358600 0   5 10 10005 41540   Central Sussex County https://data.medicare.gov/resource/xubh-q36u/row-h6ng.bwzj-5t95 80007 659769 2019-12-02 2019-06-30 175   20       195               195
266 266 NANTICOKE MEMORIAL HOSPITAL 801 MIDDLEFORD RD SEAFORD DE 19973 SUSSEX (302) 629-6611 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.6423320 -75.6053250 0   5 10 10005 41540   Central Sussex County https://data.medicare.gov/resource/xubh-q36u/row-daqn-dq9w~qe8k 80006 659920 2019-12-02 2019-06-30 85 9         94               94

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