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

286 rows where "filed_date" is on date 2019-11-27 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, coronary_beds, burn_beds, surg_icu_beds, oth_spec_beds, subprovider_irf_beds, nursing_fac_beds, oth_longterm_beds, fy_end_date (date)

filed_date (date) ✖

  • 2019-11-27 · 286 ✖
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
12 12 CLARKE COUNTY HOSPITAL 800 S FILLMORE ST OSCEOLA IA 50213 CLARKE (641) 342-2184 Critical Access Hospitals Voluntary non-profit - Other TRUE 41.0257100 -93.7675330 0   39 19 19039         https://data.medicare.gov/resource/xubh-q36u/row-xtat~vhgt.9ane 161348 660976 2019-11-27 2019-06-30 25           25               25
16 16 AVERA WESKOTA MEMORIAL MEDICAL CENTER - CAH 604 1ST ST NE WESSINGTON SPRINGS SD 57382 JERAULD (605) 539-1201 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.0803940 -98.5636820 0   73 46 46073         https://data.medicare.gov/resource/xubh-q36u/row-pcwb-j3y8~f5au 431324 662583 2019-11-27 2019-06-30 16           16               16
19 19 ASCENSION ST MARYS HOSPITAL 2251 NORTH SHORE DR RHINELANDER WI 54501 ONEIDA (715) 361-2000 Acute Care Hospitals Voluntary non-profit - Private TRUE 45.6384820 -89.3111400 0   85 55 55085         https://data.medicare.gov/resource/xubh-q36u/row-zwaq-mmw6_zwbm 520019 661677 2019-11-27 2019-06-30 32 20         52 11             63
33 33 RED BUD REGIONAL HOSPITAL 325 SPRING STREET RED BUD IL 62278 RANDOLPH (618) 282-3831 Critical Access Hospitals Proprietary TRUE 38.2096050 -89.9964080 0   157 17 17157         https://data.medicare.gov/resource/xubh-q36u/row-p29n.6wib~fbrj 141348 660526 2019-11-27 2019-06-30 25           25               25
36 36 THAYER COUNTY HEALTH SERVICES 120 PARK AVE HEBRON NE 68370 THAYER (402) 768-6041 Critical Access Hospitals Government - Local TRUE 40.1601230 -97.5932670 0   169 31 31169         https://data.medicare.gov/resource/xubh-q36u/row-b26e~mfmy~67qg 281304 660643 2019-11-27 2019-06-30 19           19               19
101 101 BARRETT HOSPITAL & HEALTHCARE 600 MT HWY 91 S DILLON MT 59725 BEAVERHEAD (406) 683-3000 Critical Access Hospitals Government - Hospital District or Authority TRUE 45.2006540 -112.6460030 0   1 30 30001         https://data.medicare.gov/resource/xubh-q36u/row-2tkn_v7av-d2ep 271318 662223 2019-11-27 2019-06-30 18           18               18
252 252 NORTH BIG HORN HOSPITAL DISTRICT 1115 LANE 12 LOVELL WY 82431 BIG HORN (307) 548-5200 Critical Access Hospitals Government - Hospital District or Authority TRUE 44.8257990 -108.3906880 0   3 56 56003         https://data.medicare.gov/resource/xubh-q36u/row-s9vd~bscy-xn2k 531309 662633 2019-11-27 2019-06-30 12           12       85       97
332 332 CUMBERLAND MEMORIAL HOSPITAL 1110 7TH AVENUE CUMBERLAND WI 54829 BARRON (715) 822-7500 Critical Access Hospitals Voluntary non-profit - Other TRUE 45.5309390 -92.0295920 0   5 55 55005         https://data.medicare.gov/resource/xubh-q36u/row-r4fu_4cy5~ir4d 521353 661689 2019-11-27 2019-06-30 25           25               25
356 356 ASSUMPTION COMMUNITY HOSPITAL 135 HIGHWAY 402 NAPOLEONVILLE LA 70390 ASSUMPTION (985) 369-3600 Critical Access Hospitals Voluntary non-profit - Private TRUE 29.9575850 -91.0338750 0   7 22 22007         https://data.medicare.gov/resource/xubh-q36u/row-smss_wf6g.wmww 191303 659796 2019-11-27 2019-06-30 15           15               15
511 511 ESSENTIA HEALTH HOLY TRINITY HOSPITAL 115 SECOND STREET WEST, BOX 157 GRACEVILLE MN 56240 BIG STONE (320) 748-8200 Critical Access Hospitals Voluntary non-profit - Private TRUE 45.5624100 -96.4334520 0   11 27 27011         https://data.medicare.gov/resource/xubh-q36u/row-crzd_579y.ukdv 241321 660608 2019-11-27 2019-06-30 15           15       40       55
799 799 FLOYD CHEROKEE MEDICAL CENTER 400 NORTHWOOD DR CENTRE AL 35960 CHEROKEE (256) 927-5531 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.1627610 -85.6514200 0   19 1 1019         https://data.medicare.gov/resource/xubh-q36u/row-wy8i.rrc6.c8zi 10022 660348 2019-11-27 2019-06-30 45           45               45
824 824 BUCHANAN COUNTY HEALTH CENTER 1600 FIRST ST EAST INDEPENDENCE IA 50644 BUCHANAN (319) 332-0999 Critical Access Hospitals Voluntary non-profit - Other TRUE 42.4687870 -91.8750150 0   19 19 19019         https://data.medicare.gov/resource/xubh-q36u/row-cq2e.inyq-2gxf 161335 660969 2019-11-27 2019-06-30 25           25           39   64
870 870 ASCENSION OUR LADY OF VICTORY HOSPITAL 1120 PINE ST STANLEY WI 54768 CHIPPEWA (715) 644-5571 Critical Access Hospitals Voluntary non-profit - Other TRUE 44.9553110 -90.9205640 0   19 55 55019         https://data.medicare.gov/resource/xubh-q36u/row-xzzk-sbky-rj53 521311 661445 2019-11-27 2019-06-30 24           24               24
895 895 MERCY HOSPITAL COLUMBUS 220 N PENNSYLVANIA AVENUE COLUMBUS KS 66725 CHEROKEE (620) 429-2545 Critical Access Hospitals Voluntary non-profit - Church TRUE 37.1720640 -94.8438050 0   21 20 20021         https://data.medicare.gov/resource/xubh-q36u/row-sn95~jvt2.e2ep 171308 660551 2019-11-27 2019-06-30 10           10               10
913 913 MERCYONE OAKLAND MEDICAL CENTER 601 EAST SECOND ST OAKLAND NE 68045 BURT (402) 685-5601 Critical Access Hospitals Voluntary non-profit - Private TRUE 41.8345710 -96.4591970 0   21 31 31021         https://data.medicare.gov/resource/xubh-q36u/row-bi44_haku_5d9v 281321 660644 2019-11-27 2019-06-30 16           16               16
978 978 BLUE MOUNTAIN HOSPITAL 170 FORD ROAD JOHN DAY OR 97845 GRANT (541) 575-1311 Critical Access Hospitals Government - Hospital District or Authority TRUE 44.4176510 -118.9592200 0   23 41 41023         https://data.medicare.gov/resource/xubh-q36u/row-svyy.cxkf.r4qf 381305 662576 2019-11-27 2019-06-30 14           14               14
1074 1074 CLAIBORNE MEMORIAL MEDICAL CENTER 620 EAST COLLEGE STREET HOMER LA 71040 CLAIBORNE (318) 927-2024 Acute Care Hospitals Government - Hospital District or Authority TRUE 32.7943270 -93.0624690 0   27 22 22027         https://data.medicare.gov/resource/xubh-q36u/row-ncph.ugan.rj3n 190114 661188 2019-11-27 2019-06-30 33 4         37 10             47
1088 1088 PERSHING GENERAL HOSPITAL 855 6TH STREET/PO BOX 661 LOVELOCK NV 89419 PERSHING (775) 273-2621 Critical Access Hospitals Government - Hospital District or Authority TRUE 40.1766240 -118.4820870 0   27 32 32027         https://data.medicare.gov/resource/xubh-q36u/row-9yyu.vv2v~izhm 291304 662550 2019-11-27 2019-06-30 13           13       25       38
1113 1113 BUCHANAN GENERAL HOSPITAL 1535 SLATE CREEK ROAD GRUNDY VA 24614 BUCHANAN (276) 935-1000 Acute Care Hospitals Voluntary non-profit - Private TRUE 37.2855060 -82.0678170 0   27 51 51027         https://data.medicare.gov/resource/xubh-q36u/row-fxtx.a9g4-8ec6 490127 660724 2019-11-27 2019-06-30 37 12         49               49
1142 1142 MUNSON HEALTHCARE CHARLEVOIX HOSPITAL 14700 LAKESHORE DRIVE CHARLEVOIX MI 49720 CHARLEVOIX (231) 547-4024 Critical Access Hospitals Voluntary non-profit - Other TRUE 45.3144980 -85.2748510 1 ROOFTOP 29 26 26029         https://data.medicare.gov/resource/xubh-q36u/row-cdsd.f9cx_c7j8 231322 660601 2019-11-27 2019-06-30 25           25               25
1164 1164 MARY HURLEY HOSPITAL 6 NORTH COVINGTON COALGATE OK 74538 COAL (580) 927-2327 Critical Access Hospitals Proprietary TRUE 34.5392220 -96.2242870 0   29 40 40029         https://data.medicare.gov/resource/xubh-q36u/row-vgqy-nnxi.ph5t 371319 661388 2019-11-27 2019-06-30 20           20               20
1194 1194 POWELL VALLEY HOSPITAL 777 AVENUE H POWELL WY 82435 PARK (307) 754-2267 Critical Access Hospitals Government - Hospital District or Authority TRUE 44.7566220 -108.7705470 0   29 56 56029         https://data.medicare.gov/resource/xubh-q36u/row-gs73_h7cj.ibeh 531310 662634 2019-11-27 2019-06-30 25           25       100       125
1344 1344 WILLIAM BEE RIRIE HOSPITAL 1500 AVENUE H ELY NV 89301 WHITE PINE (775) 289-3001 Critical Access Hospitals Government - Hospital District or Authority TRUE 39.2560650 -114.8600860 0   33 32 32033         https://data.medicare.gov/resource/xubh-q36u/row-xg87~7vrt.qaws 291302 662548 2019-11-27 2019-06-30 25           25               25
1393 1393 MIDMICHIGAN MEDICAL CENTER-CLARE 703 N MCEWAN ST CLARE MI 48617 CLARE (989) 802-5000 Acute Care Hospitals Voluntary non-profit - Other FALSE 43.8207240 -84.7683490 0   35 26 26035         https://data.medicare.gov/resource/xubh-q36u/row-x95c-xq2z-tjc4 230180 661013 2019-11-27 2019-06-30 49           49               49
1425 1425 SAINT FRANCIS HOSPITAL VINITA, INC 735 NORTH FOREMAN STREET VINITA OK 74301 CRAIG (918) 256-7551 Acute Care Hospitals Voluntary non-profit - Private TRUE 36.6533720 -95.1556420 0   35 40 40035         https://data.medicare.gov/resource/xubh-q36u/row-bg5g~s52b_99xj 370237 659861 2019-11-27 2019-06-30 35           35 20             55
1431 1431 GOODALL WITCHER HOSPITAL 101 POSEY AVENUE CLIFTON TX 76634 BOSQUE (254) 675-8322 Critical Access Hospitals Government - Hospital District or Authority TRUE 31.7771530 -97.5884310 0   35 48 48035         https://data.medicare.gov/resource/xubh-q36u/row-xqqi.9yb9.h6f2 451385 660476 2019-11-27 2019-06-30 25           25               25
1594 1594 MUNSON HEALTHCARE GRAYLING HOSPITAL 1100 E MICHIGAN AVE GRAYLING MI 49738 CRAWFORD (989) 348-5461 Acute Care Hospitals Voluntary non-profit - Church TRUE 44.6672510 -84.7079390 0   39 26 26039         https://data.medicare.gov/resource/xubh-q36u/row-unnq.cpq3.chrb 230058 660583 2019-11-27 2019-06-30 43 6         49       39       88
1601 1601 MURPHY MEDICAL CENTER INC 3990 EAST US HIGHWAY 64 ALT MURPHY NC 28906 CHEROKEE (828) 837-8161 Critical Access Hospitals Voluntary non-profit - Private TRUE 35.0731600 -83.9654240 0   39 37 37039         https://data.medicare.gov/resource/xubh-q36u/row-6u4n.7ur8_z37n 341328 660656 2019-11-27 2019-06-30 25           25               25
1737 1737 CASEY COUNTY HOSPITAL 187 WOLFORD AVENUE LIBERTY KY 42539 CASEY (606) 787-6275 Critical Access Hospitals Government - Hospital District or Authority TRUE 37.3178090 -84.9317170 0   45 21 21045         https://data.medicare.gov/resource/xubh-q36u/row-aju2-kjdy-yhzq 181309 662532 2019-11-27 2019-06-30 24           24               24
1828 1828 MODOC MEDICAL CENTER 228 W MCDOWELL AVE ALTURAS CA 96101 MODOC (530) 233-5131 Critical Access Hospitals Government - Hospital District or Authority TRUE 41.4799490 -120.5455030 0   49 6 6049         https://data.medicare.gov/resource/xubh-q36u/row-kyq6~7b5b.wgww 51330 662175 2019-11-27 2019-06-30 16           16       71       87
1909 1909 HOLMES COUNTY HOSPITAL AND CLINICS 239 BOWLING GREEN ROAD LEXINGTON MS 39095 HOLMES (662) 834-1321 Critical Access Hospitals Government - State TRUE 33.1110770 -90.0297410 0   51 28 28051         https://data.medicare.gov/resource/xubh-q36u/row-bbwk_bsmz-qfyj 251319 660403 2019-11-27 2019-06-30 25           25               25
1912 1912 LIBERTY MEDICAL CENTER 315 W MADISON AVE CHESTER MT 59522 LIBERTY (406) 759-5181 Critical Access Hospitals Voluntary non-profit - Private TRUE 48.5104970 -110.9718340 0   51 30 30051         https://data.medicare.gov/resource/xubh-q36u/row-jg4d_ys9s~wecb 271334 662543 2019-11-27 2019-06-30 25           25               25
2147 2147 UNION COUNTY GENERAL HOSPITAL 300 WILSON STREET CLAYTON NM 88415 UNION (575) 374-7001 Critical Access Hospitals Voluntary non-profit - Other TRUE 36.4551690 -103.1932600 0   59 35 35059         https://data.medicare.gov/resource/xubh-q36u/row-ai6a~bn84~9pvi 321304 660831 2019-11-27 2019-06-30 25           25               25
2165 2165 AVERA HAND COUNTY MEMORIAL HOSPITAL AND CLINIC 300 W 5TH ST MILLER SD 57362 HAND (605) 853-2421 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.5206230 -98.9920440 0   59 46 46059         https://data.medicare.gov/resource/xubh-q36u/row-cen8-s23k_ktis 431337 662584 2019-11-27 2019-06-30 25           25               25
2221 2221 EASTERN PLUMAS HOSPITAL - PORTOLA CAMPUS 500 FIRST AVENUE PORTOLA CA 96122 PLUMAS (530) 832-4277 Critical Access Hospitals Government - Hospital District or Authority TRUE 39.8061440 -120.4631290 0   63 6 6063         https://data.medicare.gov/resource/xubh-q36u/row-4uid-vtd8_6vsi 51300 662171 2019-11-27 2019-06-30 9           9       66       75
2249 2249 AVERA HOLY FAMILY HOSPITAL 826 NORTH 8TH STREET ESTHERVILLE IA 51334 EMMET (712) 362-2631 Critical Access Hospitals Voluntary non-profit - Church TRUE 43.4105960 -94.8339560 0   63 19 19063         https://data.medicare.gov/resource/xubh-q36u/row-gfry-34vq-dsa9 161351 660978 2019-11-27 2019-06-30 22           22               22
2298 2298 CLINCH MEMORIAL HOSPITAL 1050 VALDOSTA HIGHWAY HOMERVILLE GA 31634 CLINCH (912) 487-5211 Critical Access Hospitals Government - Local TRUE 31.0326510 -82.7638580 0   65 13 13065         https://data.medicare.gov/resource/xubh-q36u/row-6x28-ujdc_jsi5 111308 659942 2019-11-27 2019-06-30 15           15               15
2350 2350 FLOYD COUNTY MEDICAL CENTER 800 11TH ST CHARLES CITY IA 50616 FLOYD (641) 228-6830 Critical Access Hospitals Voluntary non-profit - Other TRUE 43.0526670 -92.6825050 0   67 19 19067         https://data.medicare.gov/resource/xubh-q36u/row-wh9h~5vd4_p9gh 161347 660975 2019-11-27 2019-06-30 25           25               25
2382 2382 ASPIRUS LANGLADE HOSPITAL 112 E FIFTH AVE ANTIGO WI 54409 LANGLADE (715) 623-2331 Critical Access Hospitals Voluntary non-profit - Church TRUE 45.1403190 -89.1402920 0   67 55 55067         https://data.medicare.gov/resource/xubh-q36u/row-fn2s~3kqd.84yg 521350 661688 2019-11-27 2019-06-30 21 4         25               25
2402 2402 ASCENSION ST JOSEPH HOSPITAL 200 HEMLOCK TAWAS CITY MI 48764 IOSCO (989) 362-9301 Acute Care Hospitals Government - Hospital District or Authority TRUE 44.2749110 -83.5110020 0   69 26 26069         https://data.medicare.gov/resource/xubh-q36u/row-8tzd-yjbe.qpjd 230100 661009 2019-11-27 2019-06-30 43 4         47               47
2458 2458 ARH OUR LADY OF THE WAY 11203 MAIN STREET MARTIN KY 41649 FLOYD (606) 285-6400 Critical Access Hospitals Voluntary non-profit - Private TRUE 37.5791050 -82.7503510 0   71 21 21071         https://data.medicare.gov/resource/xubh-q36u/row-y85x_rrhk~w2dk 181305 660806 2019-11-27 2019-06-30 25           25               25
2460 2460 MCDOWELL ARH HOSPITAL 9879 KENTUCKY ROUTE 122 MC DOWELL KY 41647 FLOYD (606) 377-3400 Critical Access Hospitals Voluntary non-profit - Private TRUE 37.4571740 -82.7472640 0   71 21 21071         https://data.medicare.gov/resource/xubh-q36u/row-igz6~ps78.wjtc 181331 661515 2019-11-27 2019-06-30 21 4         25               25
2628 2628 AVERA DE SMET MEMORIAL HOSPITAL - CAH 306 PRAIRIE AVENUE SW POST OFFICE BOX 160 DE SMET SD 57231 KINGSBURY (605) 854-3329 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.3860427 -97.5611172 1 GEOMETRIC_CENTER 77 46 46077         https://data.medicare.gov/resource/xubh-q36u/row-q65a~ny3z~nsyr 431332 662255 2019-11-27 2019-06-30 6           6               6
2631 2631 HOWARD YOUNG MEDICAL CTR 240 MAPLE ST WOODRUFF WI 54568 VILAS (715) 356-8000 Acute Care Hospitals Voluntary non-profit - Church TRUE 45.8943700 -89.7018370 0   85 55 55085         https://data.medicare.gov/resource/xubh-q36u/row-9mxb-vzak_pksq 520091 661681 2019-11-27 2019-06-30 40 10         50               50
2791 2791 TWIN LAKES REGIONAL MEDICAL CENTER 910 WALLACE AVENUE LEITCHFIELD KY 42754 GRAYSON (270) 259-9400 Acute Care Hospitals Voluntary non-profit - Other TRUE 37.4719470 -86.2870380 0   85 21 21085         https://data.medicare.gov/resource/xubh-q36u/row-me6k_7rgh~hwhf 180070 660561 2019-11-27 2019-06-30 69 6         75               75
2857 2857 JANE TODD CRAWFORD HOSPITAL 202-206 MILBY STREET GREENSBURG KY 42743 GREEN (270) 932-4211 Critical Access Hospitals Voluntary non-profit - Private TRUE 37.2421240 -85.4963020 0   87 21 21087         https://data.medicare.gov/resource/xubh-q36u/row-yq9p-j8q9-m4wf 181325 661514 2019-11-27 2019-06-30 25           25               25
2930 2930 SUMMERS COUNTY ARH HOSPITAL 115 SUMMERS HOSPITAL ROAD HINTON WV 25951 SUMMERS (304) 466-1000 Critical Access Hospitals Voluntary non-profit - Private TRUE 37.6747140 -80.8914500 0   89 54 54089         https://data.medicare.gov/resource/xubh-q36u/row-9aij.jkuz.8rh8 511310 660729 2019-11-27 2019-06-30 25           25               25
3001 3001 IRON COUNTY MEDICAL CENTER 301 NORTH HIGHWAY 21 PILOT KNOB MO 63663 IRON (573) 546-1260 Critical Access Hospitals Government - Hospital District or Authority TRUE 37.6087570 -90.6291900 0   93 29 29093         https://data.medicare.gov/resource/xubh-q36u/row-gcg8.69nm~t5ha 261336 660408 2019-11-27 2019-06-30 15           15               15
3041 3041 HARLAN ARH HOSPITAL 81 BALL PARK ROAD HARLAN KY 40831 HARLAN (606) 573-8100 Acute Care Hospitals Voluntary non-profit - Other TRUE 36.8101830 -83.3131050 0   95 21 21095         https://data.medicare.gov/resource/xubh-q36u/row-yegj_y2j5.e33p 180050 660559 2019-11-27 2019-06-30 74 7         81 30             111
3206 3206 MUNSON HEALTHCARE MANISTEE HOSPITAL 1465 E PARKDALE AVE MANISTEE MI 49660 MANISTEE (231) 398-1000 Acute Care Hospitals Voluntary non-profit - Other TRUE 44.2723550 -86.2734390 0   101 26 26101         https://data.medicare.gov/resource/xubh-q36u/row-yvaj-xucr.6ih7 230303 660597 2019-11-27 2019-06-30 45           45               45
3413 3413 TANNER MEDICAL CENTER-EAST ALABAMA 1032 MAIN STREET SOUTH WEDOWEE AL 36278 RANDOLPH (256) 357-2111 Critical Access Hospitals Government - Hospital District or Authority TRUE 33.2966660 -85.4800280 0   111 1 1111         https://data.medicare.gov/resource/xubh-q36u/row-beeg-xgp7.fjvj 11306 659914 2019-11-27 2019-06-30 15           15               15
3535 3535 ESSENTIA HEALTH SANDSTONE 705 LUNDORFF DRIVE SOUTH SANDSTONE MN 55072 PINE (320) 245-2212 Critical Access Hospitals Voluntary non-profit - Private TRUE 46.1184080 -92.8829670 0   115 27 27115         https://data.medicare.gov/resource/xubh-q36u/row-krja~dcyt_wwi3 241309 660606 2019-11-27 2019-06-30 9           9               9
3593 3593 AVERA MERRILL PIONEER HOSPITAL 1100 S 10TH AVE ROCK RAPIDS IA 51246 LYON (712) 472-2591 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.4213815 -96.1757132 1 RANGE_INTERPOLATED 119 19 19119         https://data.medicare.gov/resource/xubh-q36u/row-m3f9-4aqb~x9sv 161321 660960 2019-11-27 2019-06-30 11           11               11
3696 3696 SWEETWATER HOSPITAL ASSOCIATION 304 WRIGHT ST SWEETWATER TN 37874 MONROE (865) 213-8200 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.6002500 -84.4642230 0   123 47 47123         https://data.medicare.gov/resource/xubh-q36u/row-5ifh~9uar~z3bc 440084 660313 2019-11-27 2019-06-30 59           59               59
3735 3735 ASCENSION EAGLE RIVER HOSPITAL 201 HOSPITAL ROAD EAGLE RIVER WI 54521 VILAS (715) 479-7411 Critical Access Hospitals Voluntary non-profit - Private TRUE 45.9275180 -89.2516780 0   125 55 55125         https://data.medicare.gov/resource/xubh-q36u/row-unpa.6ptj.b2ji 521300 661443 2019-11-27 2019-06-30 14           14               14
3752 3752 CARRIS HEALTH - REDWOOD, LLC 100 FALLWOOD ROAD REDWOOD FALLS MN 56283 REDWOOD (507) 637-4500 Critical Access Hospitals Government - Local TRUE 44.5370300 -95.1072680 0   127 27 27127         https://data.medicare.gov/resource/xubh-q36u/row-nr7s_ak8r_x54m 241351 661207 2019-11-27 2019-06-30 25           25           4   29
3808 3808 NEMAHA VALLEY COMMUNITY HOSPITAL 1600 COMMUNITY DR SENECA KS 66538 NEMAHA (785) 336-6181 Critical Access Hospitals Voluntary non-profit - Private TRUE 39.8378490 -96.0778900 0   131 20 20131         https://data.medicare.gov/resource/xubh-q36u/row-nnw7~3p7y-3e9a 171315 660552 2019-11-27 2019-06-30 24           24               24
3851 3851 ST FRANCIS HOSPITAL 1215 FRANCISCAN DR LITCHFIELD IL 62056 MONTGOMERY (217) 324-2191 Critical Access Hospitals Voluntary non-profit - Church TRUE 39.1808100 -89.6396360 0   135 17 17135         https://data.medicare.gov/resource/xubh-q36u/row-jacr~k2cc_qv6a 141350 660527 2019-11-27 2019-06-30 25           25               25
3873 3873 MUNSON HEALTHCARE OTSEGO MEMORIAL HOSPITAL 825 N CENTER AVE GAYLORD MI 49735 OTSEGO (989) 731-2100 Acute Care Hospitals Voluntary non-profit - Private FALSE 45.0353320 -84.6738870 0   137 26 26137         https://data.medicare.gov/resource/xubh-q36u/row-zxhp~mryj~sttn 230133 661011 2019-11-27 2019-06-30 42 4         46       34       80
3915 3915 BAUM HARMON MERCY HOSPITAL 255 N WELCH AVENUE PRIMGHAR IA 51245 OBRIEN (712) 957-2300 Critical Access Hospitals Voluntary non-profit - Church TRUE 43.0885970 -95.6227960 0   141 19 19141         https://data.medicare.gov/resource/xubh-q36u/row-jur3.m7q6_c9mz 161300 660546 2019-11-27 2019-06-30 14           14               14
3968 3968 MARSHALL BROWNING HOSPITAL 900 NORTH WASHINGTON STREET DU QUOIN IL 62832 PERRY (618) 542-2146 Critical Access Hospitals Voluntary non-profit - Private TRUE 38.0244410 -89.2368000 0   145 17 17145         https://data.medicare.gov/resource/xubh-q36u/row-dkrg~s9bc~qdkt 141331 660524 2019-11-27 2019-06-30 25           25               25
3996 3996 PALO ALTO COUNTY HOSPITAL 3201 1ST STREET EMMETSBURG IA 50536 PALO ALTO (712) 852-5500 Critical Access Hospitals Government - Local TRUE 43.1191910 -94.6913430 0   147 19 19147         https://data.medicare.gov/resource/xubh-q36u/row-u98n.v74q-n83i 161357 660981 2019-11-27 2019-06-30 24           24           1   47
4184 4184 HARRISBURG MEDICAL CENTER 100 DOCTOR WARREN TUTTLE DR HARRISBURG IL 62946 SALINE (618) 253-7671 Acute Care Hospitals Voluntary non-profit - Other TRUE 37.7310271 -88.5248600 1 ROOFTOP 165 17 17165         https://data.medicare.gov/resource/xubh-q36u/row-8u5r_n3xt~tnqf 140210 660516 2019-11-27 2019-06-30 40           40 30             70
4212 4212 VAN BUREN COUNTY HOSPITAL 304 FRANKLIN STREET KEOSAUQUA IA 52565 VAN BUREN (319) 293-3171 Critical Access Hospitals Government - Local TRUE 40.7358620 -91.9590430 0   177 19 19177         https://data.medicare.gov/resource/xubh-q36u/row-e8fj_uhg7-i98m 161337 660970 2019-11-27 2019-06-30 25           25               25
4244 4244 HSHS GOOD SHEPHERD HOSPITAL INC 200 S CEDAR ST SHELBYVILLE IL 62565 SHELBY (217) 774-3961 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.4058010 -88.8071130 0   173 17 17173         https://data.medicare.gov/resource/xubh-q36u/row-rw3c-7r3v.5ma9 140019 660512 2019-11-27 2019-06-30 30           30               30
4300 4300 WAYNE MEDICAL CENTER 103 J V MANGUBAT DR WAYNESBORO TN 38485 WAYNE (931) 722-5411 Acute Care Hospitals Voluntary non-profit - Other TRUE 35.3253550 -87.7575330 0   181 47 47181         https://data.medicare.gov/resource/xubh-q36u/row-283m~szqb.wyui 440010 660038 2019-11-27 2019-06-30 30           30               30
4324 4324 WAYNE COUNTY HOSPITAL 417 SOUTH EAST STREET CORYDON IA 50060 WAYNE (641) 872-2260 Critical Access Hospitals Government - Local TRUE 40.7544920 -93.3123200 0   185 19 19185         https://data.medicare.gov/resource/xubh-q36u/row-z889-j4w6-dfyd 161358 660982 2019-11-27 2019-06-30 25           25               25
4372 4372 HAZARD ARH REGIONAL MEDICAL CENTER 100 MEDICAL CENTER DRIVE HAZARD KY 41701 PERRY (606) 439-6600 Acute Care Hospitals Voluntary non-profit - Private TRUE 37.2790270 -83.2274130 0   193 21 21193         https://data.medicare.gov/resource/xubh-q36u/row-n5fx-7yrz~ezx5 180029 660558 2019-11-27 2019-06-30 197 32         229 100 20           349
4379 4379 TUG VALLEY ARH REGIONAL MEDICAL CENTER 260 HOSPITAL DRIVE SOUTH WILLIAMSON KY 41503 PIKE (606) 237-1700 Acute Care Hospitals Proprietary TRUE 37.6763730 -82.2965810 0   195 21 21195         https://data.medicare.gov/resource/xubh-q36u/row-nrkm~8dtb_x2ee 180069 662529 2019-11-27 2019-06-30 82 6         88       35       123
4398 4398 SCOTLAND COUNTY HOSPITAL 450 E SIGLER AVENUE MEMPHIS MO 63555 SCOTLAND (660) 465-8511 Critical Access Hospitals Government - Hospital District or Authority TRUE 40.4660230 -92.1681710 0   199 29 29199         https://data.medicare.gov/resource/xubh-q36u/row-gdbv.rfmr-j5dc 261310 660633 2019-11-27 2019-06-30 25           25               25
4492 4492 METHODIST HOSPITAL UNION COUNTY 4604 US HIGHWAY 60 WEST MORGANFIELD KY 42437 UNION (270) 389-5000 Critical Access Hospitals Voluntary non-profit - Church TRUE 37.6261140 -87.9439180 0   225 21 21225         https://data.medicare.gov/resource/xubh-q36u/row-nfzy.mkzz.8itz 181306 660568 2019-11-27 2019-06-30 25           25               25
4619 4619 CHI ST LUKES HEALTH MEMORIAL SAN AUGUSTINE 511 HOSPITAL ST SAN AUGUSTINE TX 75972 SAN AUGUSTINE (936) 275-3446 Critical Access Hospitals Voluntary non-profit - Private TRUE 31.5322792 -94.1031699 1 ROOFTOP 405 48 48405         https://data.medicare.gov/resource/xubh-q36u/row-d3sm_en2i-92xw 451360 660892 2019-11-27 2019-06-30 9           9               9
52 52 HIGHLAND HOSPITAL 1411 EAST 31ST STREET OAKLAND CA 94602 ALAMEDA (510) 437-4800 Acute Care Hospitals Government - Hospital District or Authority TRUE 37.7992340 -122.2311990 0   1 6 6001 41860 San Jose-San Francisco-Oakland, CA Central Alameda County https://data.medicare.gov/resource/xubh-q36u/row-j4fu_u24q~7stg 50320 662161 2019-11-27 2019-06-30 137 24         169 69 25   109       372
70 70 MEDSTAR GEORGETOWN UNIVERSITY HOSPITAL 3800 RESERVOIR RD WASHINGTON DC 20007 THE DISTRICT (202) 784-3000 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.9125990 -77.0743880 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-5vf4.uxtf-sv5z 90004 661474 2019-11-27 2019-06-30 289 19     38   393               393
72 72 MEDSTAR WASHINGTON HOSPITAL CENTER 110 IRVING ST NW WASHINGTON DC 20010 THE DISTRICT (202) 877-7000 Acute Care Hospitals Voluntary non-profit - Other TRUE 38.9291570 -77.0122680 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-he3p~gtzx-x7j5 90011 660787 2019-11-27 2019-06-30 569 37 16   55   701 46             747
73 73 SIBLEY MEMORIAL HOSPITAL 5255 LOUGHBORO RD NW WASHINGTON DC 20016 THE DISTRICT (202) 537-4680 Acute Care Hospitals Voluntary non-profit - Other TRUE 38.9357470 -77.1098890 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-yqpq-7pu8-v5vj 90005 660786 2019-11-27 2019-06-30 150   25   14   189 21     45       255
74 74 CHILDREN'S HOSPITAL NMC 111 MICHIGAN AVE, NW WASHINGTON DC 20010 THE DISTRICT (202) 476-5000 Childrens Voluntary non-profit - Private TRUE 38.9262730 -77.0138780 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-9kra.5epj-ue89 93300 661151 2019-11-27 2019-06-30 184 73         323               323
76 76 UF HEALTH SHANDS HOSPITAL 1600 SW ARCHER RD GAINESVILLE FL 32610 ALACHUA (352) 265-8000 Acute Care Hospitals Voluntary non-profit - Private TRUE 29.6392230 -82.3433250 0   1 12 12001 23540 Gainesville-Lake City, FL Central Alachua County https://data.medicare.gov/resource/xubh-q36u/row-6avt~6iq6-eksg 100113 661480 2019-11-27 2019-06-30 519 66 48 8 96   921 90 39           1050
112 112 ALBANY MEMORIAL HOSPITAL 600 NORTHERN BOULEVARD ALBANY NY 12204 ALBANY (518) 471-3490 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.6746850 -73.7488610 0   1 36 36001 10580 Albany-Schenectady, NY Central Albany County https://data.medicare.gov/resource/xubh-q36u/row-fbeu-trch-uemx 330003 661359 2019-11-27 2019-06-30 57 16         73               73
145 145 JOHN DEMPSEY HOSPITAL 263 FARMINGTON AVE FARMINGTON CT 6032 HARTFORD (860) 679-1145 Acute Care Hospitals Government - Local TRUE 41.7350900 -72.7958200 0   3 9 9003 25540 Hartford-West Hartford, CT Central Hartford County https://data.medicare.gov/resource/xubh-q36u/row-dhzf~ccfg~faa5 70036 661473 2019-11-27 2019-06-30 118 20         138 18             156
152 152 CHRISTIANA CARE HEALTH SERVICES, INC. 4755 OGLETOWN-STANTON ROAD NEWARK DE 19718 NEW CASTLE (302) 733-1000 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.6899090 -75.6732280 0   3 10 10003 37980 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central New Castle County https://data.medicare.gov/resource/xubh-q36u/row-4npa_3h9a~qmvr 80001 659768 2019-11-27 2019-06-30 920 73 35       1097 30 39           1166
227 227 MAGEE WOMENS HOSPITAL OF UPMC HEALTH SYSTEM 300 HALKET STREET PITTSBURGH PA 15213 ALLEGHENY (412) 641-4010 Acute Care Hospitals Voluntary non-profit - Other TRUE 40.4370770 -79.9595460 0   3 42 42003 38300 Pittsburgh-New Castle-Weirton, PA-OH-WV Central Allegheny County https://data.medicare.gov/resource/xubh-q36u/row-tusn~f4sz~kzrq 390114 660858 2019-11-27 2019-06-30 220 18         315       20       335
231 231 OHIO VALLEY GENERAL HOSPITAL 25 HECKEL ROAD MCKEES ROCKS PA 15136 ALLEGHENY (412) 777-6161 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.4724220 -80.0928730 0   3 42 42003 38300 Pittsburgh-New Castle-Weirton, PA-OH-WV Central Allegheny County https://data.medicare.gov/resource/xubh-q36u/row-fzb2.pi34_kuyu 390157 659873 2019-11-27 2019-06-30 60 27         87 21 16           124
232 232 ST CLAIR HOSPITAL 1000 BOWER HILL ROAD PITTSBURGH PA 15243 ALLEGHENY (412) 942-4000 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.3767750 -80.0669660 0   3 42 42003 38300 Pittsburgh-New Castle-Weirton, PA-OH-WV Central Allegheny County https://data.medicare.gov/resource/xubh-q36u/row-rf2f_7h7t~9hcu 390228 660445 2019-11-27 2019-06-30 264 12 16       303 26             329
255 255 FLAGSTAFF MEDICAL CENTER 1200 NORTH BEAVER STREET FLAGSTAFF AZ 86001 COCONINO (928) 779-3366 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.2095340 -111.6448350 0   5 4 4005 22380   Central Coconino County https://data.medicare.gov/resource/xubh-q36u/row-bzd3~hd4v-cg2f 30023 662010 2019-11-27 2019-06-30 183 41       18 242 22             264
321 321 CHI ST LUKES HEALTH MEMORIAL LUFKIN 1201 WEST FRANK STREET LUFKIN TX 75901 ANGELINA (936) 634-8111 Acute Care Hospitals Voluntary non-profit - Private TRUE 31.3373240 -94.7424810 0   5 48 48005 31260   Central Angelina County https://data.medicare.gov/resource/xubh-q36u/row-rdm9.4ki2~5y5k 450211 660887 2019-11-27 2019-06-30 148 24         172   12           184
366 366 NORTHEASTERN NEVADA REGIONAL HOSPITAL 2001 ERRECART BLVD ELKO NV 89801 ELKO (775) 738-5151 Acute Care Hospitals Proprietary TRUE 40.8225080 -115.7290260 0   7 32 32007 21220   Central Elko County https://data.medicare.gov/resource/xubh-q36u/row-q6r2~fn4e-z9r9 290008 662547 2019-11-27 2019-06-30 52 7         59               59
452 452 SPEARE MEMORIAL HOSPITAL 16 HOSPITAL ROAD PLYMOUTH NH 3264 GRAFTON (603) 536-1120 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.7578860 -71.6948370 0   9 33 33009 17200   Central Grafton County https://data.medicare.gov/resource/xubh-q36u/row-tpyx~4vjq_mct4 301311 661929 2019-11-27 2019-06-30 25           25               25
460 460 GREAT PLAINS REGIONAL MEDICAL CENTER 1801 WEST 3RD STREET ELK CITY OK 73644 BECKHAM (580) 225-2511 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.4117210 -99.4256540 0   9 40 40009 21120   Central Beckham County https://data.medicare.gov/resource/xubh-q36u/row-ygr6~ifvk~u3j8 370019 660278 2019-11-27 2019-06-30 28 6         34 12 8           54
532 532 READING HOSPITAL 420 S 5TH AVENUE WEST READING PA 19611 BERKS (610) 988-8000 Acute Care Hospitals Voluntary non-profit - Other TRUE 40.3298630 -75.9480590 0   11 42 42011 39740 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Berks County https://data.medicare.gov/resource/xubh-q36u/row-rf2n_5umm~j8bk 390044 659867 2019-11-27 2019-06-30 491 20     21 30 562 50 62   50       724
605 605 MIDDLESBORO APPALACHIAN REGIONAL HEALTHCARE HOSPIT 3600 WEST CUMBERLAND AVENUE MIDDLESBORO KY 40965 BELL (606) 242-1100 Acute Care Hospitals Voluntary non-profit - Private TRUE 36.6051990 -83.7400560 0   13 21 21013 33180   Central Bell County https://data.medicare.gov/resource/xubh-q36u/row-ddm7.jenh~wuwk 180020 660557 2019-11-27 2019-06-30 39 7         46               46
645 645 UPMC ALTOONA 620 HOWARD AVENUE ALTOONA PA 16601 BLAIR (814) 889-2011 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.5211420 -78.3981840 0   13 42 42013 11020   Central Blair County https://data.medicare.gov/resource/xubh-q36u/row-wkn5_wsma_rprd 390073 661248 2019-11-27 2019-06-30 303 33 8       344               344
650 650 AVERA ST LUKES 305 S STATE ST POST OFFICE BOX 4450 ABERDEEN SD 57401 BROWN (605) 622-5000 Acute Care Hospitals Voluntary non-profit - Church TRUE 45.4617950 -98.4793500 0   13 46 46013 10100   Central Brown County https://data.medicare.gov/resource/xubh-q36u/row-pruy~fuxf-c6av 430014 662254 2019-11-27 2019-06-30 43 6         49 10     81 56     196
670 670 KINGMAN REGIONAL MEDICAL CENTER 3269 STOCKTON HILL ROAD KINGMAN AZ 86409 MOHAVE (928) 757-2101 Acute Care Hospitals Government - Hospital District or Authority TRUE 35.2199070 -114.0358130 0   15 4 4015 29420 Las Vegas-Henderson, NV-AZ Central Mohave County https://data.medicare.gov/resource/xubh-q36u/row-3ksp.3iej_8pd7 30055 660485 2019-11-27 2019-06-30 176 20         196   18       12   226
718 718 PEACEHEALTH ST JOHN MEDICAL CENTER 1615 DELAWARE STREET LONGVIEW WA 98632 COWLITZ (360) 414-2000 Acute Care Hospitals Voluntary non-profit - Church TRUE 46.1309920 -122.9411920 0   15 53 53015 31020 Portland-Vancouver-Salem, OR-WA Central Cowlitz County https://data.medicare.gov/resource/xubh-q36u/row-n4kt-b68h~5bhw 500041 662288 2019-11-27 2019-06-30 148 18         166               166
719 719 ASCENSION CALUMET HOSPITAL 614 MEMORIAL DRIVE CHILTON WI 53014 CALUMET (920) 849-2386 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.0254390 -88.1543990 0   15 55 55015 11540 Appleton-Oshkosh-Neenah, WI Central Calumet County https://data.medicare.gov/resource/xubh-q36u/row-q97p-97ns_bxut 521317 661447 2019-11-27 2019-06-30 25           25               25
775 775 ESSENTIA HEALTH FARGO 3000 32ND AVE SOUTH FARGO ND 58104 CASS (701) 364-8000 Acute Care Hospitals Voluntary non-profit - Private TRUE 46.8325000 -96.8281060 0   17 38 38017 22020 Fargo-Wahpeton, ND-MN Central Cass County https://data.medicare.gov/resource/xubh-q36u/row-9tdc-2u7p-zr8f 350070 662238 2019-11-27 2019-06-30 89 44         133               133
781 781 INTEGRIS CANADIAN VALLEY HOSPITAL 1201 HEALTH CENTER PARKWAY YUKON OK 73099 CANADIAN (405) 717-6800 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.4836950 -97.7602420 0   17 40 40017 36420 Oklahoma City-Shawnee, OK Central Canadian County https://data.medicare.gov/resource/xubh-q36u/row-bfap-q9md_hknr 370211 660282 2019-11-27 2019-06-30 66 8         74               74
818 818 ORANGE PARK MEDICAL CENTER 2001 KINGSLEY AVE ORANGE PARK FL 32073 CLAY (904) 276-8500 Acute Care Hospitals Voluntary non-profit - Other TRUE 30.1648070 -81.7385980 0   19 12 12019 27260 Jacksonville-St. Marys-Palatka, FL-GA Central Clay County https://data.medicare.gov/resource/xubh-q36u/row-wsf2~ud7b_znaf 100226 660500 2019-11-27 2019-06-30 229 28         273 24 20           317
923 923 NORTHEASTERN HEALTH SYSTEM 1400 EAST DOWNING STREET TAHLEQUAH OK 74465 CHEROKEE (918) 456-0641 Acute Care Hospitals Government - Local TRUE 35.9153260 -94.9505580 0   21 40 40021 45140 Tulsa-Muskogee-Bartlesville, OK Central Cherokee County https://data.medicare.gov/resource/xubh-q36u/row-y8w6~8rs4_b8fq 370089 660430 2019-11-27 2019-06-30 40 14 16       70 10 10           90

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