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

4,766 rows sorted by csatitle

View and edit SQL

Suggested facets: hospital_type, hospital_ownership, emergency_services, geocode_flag, geocode_accuracy, centraloutlyingcounty, burn_beds, subprovider_oth_beds, filed_date (date), fy_end_date (date)

Link rowid hospital_name address city state zip_code county_name phone_number hospital_type hospital_ownership emergency_services lat lng geocode_flag geocode_accuracy countyfips statefips statecountyfips cbsacode csatitle ▼ centraloutlyingcounty countyequivalent hosp_lookup_url PRVDR_NUM RPT_REC_NUM filed_date fy_end_date acute_beds icu_beds coronary_beds burn_beds surg_icu_beds oth_spec_beds subtotal_acute_beds subprovider_ipf_beds subprovider_irf_beds subprovider_oth_beds skilled_nursing_beds nursing_fac_beds oth_longterm_beds hospice_beds all_beds
1 ASHLEY COUNTY MEDICAL CENTER 1015 UNITY ROAD CROSSETT AR 71635 ASHLEY (870) 364-4111 Critical Access Hospitals Voluntary non-profit - Private TRUE 33.1372060 -91.9387800 0   3 5 5003         https://data.medicare.gov/resource/xubh-q36u/row-gq3d.ak25_8qvw 41323 642385 2019-01-15 2018-09-30 19 6         25 10             35
2 HUGGINS HOSPITAL 240 SOUTH MAIN STREET WOLFEBORO NH 3894 CARROLL (603) 569-7500 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.5809440 -71.2015750 0   3 33 33003         https://data.medicare.gov/resource/xubh-q36u/row-u6j2-zv25.9ghd 301312 659991 2019-11-25 2018-09-30 21 4         25               25
3 WEEKS MEDICAL CENTER 173 MIDDLE STREET LANCASTER NH 3584 COOS (603) 788-4911 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.4869900 -71.5541560 0   7 33 33007 13620   Central Coos County https://data.medicare.gov/resource/xubh-q36u/row-4k9b_taaw_pmup 301303 643920 2019-02-28 2018-09-30 22 3         25               25
4 SGMC BERRIEN CAMPUS 1221 E MCPHERSON AVENUE NASHVILLE GA 31639 BERRIEN (229) 543-7100 Acute Care Hospitals Government - Hospital District or Authority TRUE 31.2036290 -83.2383370 0   19 13 13019         https://data.medicare.gov/resource/xubh-q36u/row-nuhh.ufkh.cshr 110234 644717 2019-03-01 2018-09-30 51           51 12             63
5 SEYMOUR HOSPITAL 200 STADIUM DRIVE SEYMOUR TX 76380 BAYLOR (940) 889-5572 Acute Care Hospitals Government - Hospital District or Authority TRUE 33.5897880 -99.2476970 0   23 48 48023         https://data.medicare.gov/resource/xubh-q36u/row-q4ba-nup8_2wqc 450586 659539 2019-11-20 2019-06-30 27           27               27
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
7 DOWN EAST COMMUNITY HOSPITAL 11 HOSPITAL DRIVE MACHIAS ME 4654 WASHINGTON (207) 255-3356 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.7134110 -67.4772030 0   29 23 23029         https://data.medicare.gov/resource/xubh-q36u/row-tmd2.zxhs~phzc 201311 650481 2019-05-31 2018-12-31 25           25               25
9 NORTH SHORE HEALTH 515 5TH AVE WEST GRAND MARAIS MN 55604 COOK (218) 387-3040 Critical Access Hospitals Government - Hospital District or Authority TRUE 47.7567440 -90.3401790 0   31 27 27031         https://data.medicare.gov/resource/xubh-q36u/row-kcfv-qat3~9wit 241317 649272 2019-05-28 2018-12-31 16           16       37       53
10 GARFIELD COUNTY HEALTH CENTER 332 LEAVITT AVE JORDAN MT 59337 GARFIELD (406) 557-2500 Critical Access Hospitals Government - Local TRUE 47.3185240 -106.9113280 0   33 30 30033         https://data.medicare.gov/resource/xubh-q36u/row-xbp8~mipq.32d8 271310 659309 2019-11-18 2019-06-30 4           4       24       28
11 CROSSRIDGE COMMUNITY HOSPITAL 310 SOUTH FALLS BOULEVARD WYNNE AR 72396 CROSS (870) 238-3300 Critical Access Hospitals Voluntary non-profit - Private TRUE 35.2203530 -90.7874210 0   37 5 5037         https://data.medicare.gov/resource/xubh-q36u/row-9vam~w7bd~4ivg 41307 644210 2019-02-27 2018-09-30 15           15               15
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
13 NORTH VALLEY HOSPITAL 203 SOUTH WESTERN TONASKET WA 98855 OKANOGAN (509) 486-2151 Critical Access Hospitals Government - Local TRUE 48.7068190 -119.4395970 0   47 53 53047         https://data.medicare.gov/resource/xubh-q36u/row-dpfb.gqi2_r2fh 501321 648787 2019-05-29 2018-12-31 21           21               21
14 DICKENSON COMMUNITY HOSPITAL 312 HOSPITAL DRIVE CLINTWOOD VA 24228 DICKENSON (276) 926-0300 Critical Access Hospitals Voluntary non-profit - Private TRUE 37.1598600 -82.4491020 0   51 51 51051 13720   Outlying Dickenson County https://data.medicare.gov/resource/xubh-q36u/row-gdzi~hhk4-fsm8 491303 659905 2019-11-21 2018-09-30 2           2 10             12
15 GARRISON MEMORIAL HOSPITAL 407 3RD AVE SE GARRISON ND 58540 MCLEAN (701) 463-2275 Critical Access Hospitals Voluntary non-profit - Church TRUE 47.6483420 -101.4113010 0   55 38 38055         https://data.medicare.gov/resource/xubh-q36u/row-e4ej.ybr6_ritz 351303 640250 2018-12-03 2018-06-30 22           22       28       50
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
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
18 HOUSTON COUNTY COMMUNITY HOSPITAL 5001 EAST MAIN STREET ERIN TN 37061 HOUSTON (931) 289-4211 Critical Access Hospitals Government - Local TRUE 36.3195160 -87.6891930 0   83 47 47083         https://data.medicare.gov/resource/xubh-q36u/row-dt3z.s9ya.age2 441322 639931 2018-12-03 2018-06-30 25           25               25
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
20 MAYO CLINIC HEALTH SYSTEM - FAIRMONT 800 MEDICAL CENTER DRIVE, PO BOX 800 FAIRMONT MN 56031 MARTIN (507) 238-8101 Acute Care Hospitals Voluntary non-profit - Private TRUE 43.6376880 -94.4517280 0   91 27 27091         https://data.medicare.gov/resource/xubh-q36u/row-ifmr-5ze5~ircm 240166 649773 2019-05-30 2018-12-31 55           55               55
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
22 STILLWATER BILLINGS CLINIC 710 N 11TH ST COLUMBUS MT 59019 STILLWATER (406) 322-5316 Critical Access Hospitals Voluntary non-profit - Private TRUE 45.6426860 -109.2431780 0   95 30 30095         https://data.medicare.gov/resource/xubh-q36u/row-feve.dr4z_em5n 271330 662542 2019-11-29 2019-06-30 10           10               10
24 ST ALOISIUS MEDICAL CENTER 325 E BREWSTER ST HARVEY ND 58341 WELLS (701) 324-4651 Critical Access Hospitals Voluntary non-profit - Private TRUE 47.7676870 -99.9330890 0   103 38 38103         https://data.medicare.gov/resource/xubh-q36u/row-u657.4sxp.u7ix 351327 644053 2019-02-27 2018-09-30 25           25       91       116
25 ESSENTIA HEALTH ADA 201 9TH STREET WEST ADA MN 56510 NORMAN (218) 784-5000 Critical Access Hospitals Voluntary non-profit - Private TRUE 47.2960910 -96.5301900 0   107 27 27107         https://data.medicare.gov/resource/xubh-q36u/row-z63y_de5x~9s9u 241313 660607 2019-11-26 2019-06-30 14           14               14
27 NEMAHA COUNTY HOSPITAL 2022 13TH ST AUBURN NE 68305 NEMAHA (402) 274-4366 Critical Access Hospitals Government - Local TRUE 40.3920330 -95.8530200 0   127 31 31127         https://data.medicare.gov/resource/xubh-q36u/row-jgty.gwke-kfnb 281324 654855 2019-09-24 2019-04-30 16           16               16
28 MORTON COUNTY HOSPITAL 445 N HILLTOP ELKHART KS 67950 MORTON (620) 697-2141 Acute Care Hospitals Government - Local TRUE 37.0019009 -101.9053025 1 ROOFTOP 129 20 20129         https://data.medicare.gov/resource/xubh-q36u/row-uv4u~7jpi~swm6 170166 651519 2019-07-09 2018-12-31 26           26               26
29 OTTAWA COUNTY HEALTH CENTER 215 E 8TH STREET MINNEAPOLIS KS 67467 OTTAWA (785) 392-2122 Critical Access Hospitals Voluntary non-profit - Other TRUE 39.1287970 -97.7042550 0   143 20 20143 41460   Outlying Ottawa County https://data.medicare.gov/resource/xubh-q36u/row-bau7_rd4p~nxph 171328 659092 2018-12-07 2018-09-30 25           25           10   35
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
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
32 SHARE MEDICAL CENTER 800 SHARE DRIVE ALVA OK 73717 WOODS (580) 327-2800 Critical Access Hospitals Government - Hospital District or Authority TRUE 36.7869690 -98.6700230 0   151 40 40151         https://data.medicare.gov/resource/xubh-q36u/row-gzmq-89k6~9n3d 371341 659863 2019-11-25 2019-06-30 25           25         80     105
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
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
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
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
37 PRATTVILLE BAPTIST HOSPITAL 124 S MEMORIAL DR PRATTVILLE AL 36067 AUTAUGA (334) 361-4267 Acute Care Hospitals Government - Hospital District or Authority TRUE 32.4644230 -86.4509360 0   1 1 1001 33860   Central Autauga County https://data.medicare.gov/resource/xubh-q36u/row-62jx-izkm-znx2 10108 660906 2019-12-04 2019-06-30 49 6         55               55
38 FORT DEFIANCE INDIAN HOSPITAL PO BOX 649 FORT DEFIANCE AZ 86504 APACHE (928) 729-8000 Acute Care Hospitals Government - Federal TRUE 35.7593170 -109.0483992 1 GEOMETRIC_CENTER 1 4 4001         https://data.medicare.gov/resource/xubh-q36u/row-ss8d_atq6.7xb3 30071 651311 2019-07-02 2018-09-30 56           56               56
39 SAGE MEMORIAL HOSPITAL STATE ROUTE 264 SOUTH 191 GANADO AZ 86505 APACHE (928) 755-4541 Critical Access Hospitals Voluntary non-profit - Private FALSE 35.7108602 -109.5423597 1 ROOFTOP 1 4 4001         https://data.medicare.gov/resource/xubh-q36u/row-vmgp-erfi.puty 31309 652060 2019-05-06 2018-09-30 25           25               25
40 CHINLE COMPREHENSIVE HEALTH CARE FACILITY US HWY 191, HOSPITAL ROAD CHINLE AZ 86503 APACHE (928) 674-7001 Acute Care Hospitals Government - Federal TRUE 36.1575812 -109.6076963 1 GEOMETRIC_CENTER 1 4 4001         https://data.medicare.gov/resource/xubh-q36u/row-u7kj_iqgg.38d9 30084 649393 2019-06-12 2018-09-30 60           60               60
41 WHITE MOUNTAIN REGIONAL MEDICAL CENTER 118 SOUTH MOUNTAIN AVENUE SPRINGERVILLE AZ 85938 APACHE (928) 333-4368 Critical Access Hospitals Voluntary non-profit - Private TRUE 34.1321360 -109.2865450 0   1 4 4001         https://data.medicare.gov/resource/xubh-q36u/row-dkxh~vpbb.s52c 31315 652061 2019-05-30 2018-12-31 21           21               21
42 BAPTIST HEALTH MEDICAL CENTER-STUTTGART 1703 NORTH BUERKLE ST STUTTGART AR 72160 ARKANSAS (870) 673-3511 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.5177730 -91.5575720 0   1 5 5001         https://data.medicare.gov/resource/xubh-q36u/row-rh96.h2uy.6pb9 40072 649864 2019-05-31 2018-12-31 49           49               49
43 DEWITT HOSPITAL & NURSING HOME, INC 1641 WHITEHEAD DRIVE DE WITT AR 72042 ARKANSAS (870) 946-3571 Critical Access Hospitals Voluntary non-profit - Private TRUE 34.2795980 -91.3368920 0   1 5 5001         https://data.medicare.gov/resource/xubh-q36u/row-m6cy.wkj8_xepc 41314 660746 2019-12-05 2019-06-30 25           25       60       85
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
78 APPLING HOSPITAL 163 E TOLLISON STREET BAXLEY GA 31513 APPLING (912) 367-9841 Acute Care Hospitals Government - Hospital District or Authority TRUE 31.7687680 -82.3493510 0   1 13 13001         https://data.medicare.gov/resource/xubh-q36u/row-j4qq-twpw~u8jw 110071 658240 2019-03-29 2018-08-31 31 3         34 30     101       165
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
80 HILO MEDICAL CENTER 1190 WAIANUENUE AVENUE HILO HI 96720 HAWAII (808) 932-3000 Acute Care Hospitals Government - State TRUE 19.7174670 -155.1135130 0   1 15 15001 25900   Central Hawaii County https://data.medicare.gov/resource/xubh-q36u/row-szpt~f525_222j 120005 657722 2018-12-03 2018-06-30 146 11         157       119       276
81 HALE HO'OLA HAMAKUA 45-547 PLUMERIA STREET HONOKAA HI 96727 HAWAII (808) 932-4100 Critical Access Hospitals Government - State TRUE 20.0762710 -155.4705950 0   1 15 15001 25900   Central Hawaii County https://data.medicare.gov/resource/xubh-q36u/row-z9jm-2idi-sq3z 121307 640366 2018-12-03 2018-06-30 11           11       66       77
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
83 KOHALA HOSPITAL 54-383 HOSPITAL ROAD KAPAAU HI 96755 HAWAII (808) 889-6211 Critical Access Hospitals Government - State TRUE 20.2317370 -155.7972530 0   1 15 15001 25900   Central Hawaii County https://data.medicare.gov/resource/xubh-q36u/row-zwx4_qya8~b57e 121302 662519 2019-11-29 2019-06-30 6           6       22       28
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
89 ALLEN COUNTY REGIONAL HOSPITAL 3066 NORTH KENTUCKY STREET IOLA KS 66749 ALLEN (620) 365-1021 Critical Access Hospitals Government - State TRUE 37.9503420 -95.3906740 0   1 20 20001         https://data.medicare.gov/resource/xubh-q36u/row-gt8h_8a7x~t4kr 171373 648832 2019-05-29 2018-12-31 25           25               25
90 T J HEALTH COLUMBIA 901 WESTLAKE DRIVE COLUMBIA KY 42728 ADAIR (270) 384-4753 Acute Care Hospitals Government - Hospital District or Authority TRUE 37.0962890 -85.2949400 0   1 21 21001         https://data.medicare.gov/resource/xubh-q36u/row-7iis-x23i.zsak 180149 640382 2018-12-31 2018-09-30 49           49 20             69
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
98 RIVERWOOD HEALTHCARE CENTER 200 BUNKER HILL DRIVE AITKIN MN 56431 AITKIN (218) 927-5501 Critical Access Hospitals Voluntary non-profit - Private TRUE 46.5292020 -93.6968080 0   1 27 27001         https://data.medicare.gov/resource/xubh-q36u/row-ybgp~gnb5~d4ww 241305 655456 2019-10-08 2018-09-30 21 4         25               25
99 MERIT HEALTH NATCHEZ 52 SERGEANT PRENTISS DRIVE NATCHEZ MS 39120 ADAMS (601) 443-2100 Acute Care Hospitals Proprietary TRUE 31.5279831 -91.3884516 1 RANGE_INTERPOLATED 1 28 28001 35020   Central Adams County https://data.medicare.gov/resource/xubh-q36u/row-36cp~uwxv-3duz 250084 643800 2019-02-27 2018-09-30 132 15         147 12 20           179
100 NORTHEAST REGIONAL MEDICAL CENTER 315 S OSTEOPATHY KIRKSVILLE MO 63501 ADAIR (660) 785-1000 Acute Care Hospitals Proprietary TRUE 40.1925230 -92.5908490 0   1 29 29001 28860   Central Adair County https://data.medicare.gov/resource/xubh-q36u/row-75xb~p5w7-egiy 260022 656302 2019-10-31 2019-05-31 41 10         51               51
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
102 MARY LANNING HEALTHCARE 715 N ST JOSEPH AVE HASTINGS NE 68901 ADAMS (402) 461-5108 Acute Care Hospitals Voluntary non-profit - Other TRUE 40.5924160 -98.3874740 0   1 31 31001 25580   Central Adams County https://data.medicare.gov/resource/xubh-q36u/row-6nbf.h76f_85sy 280032 648632 2019-05-24 2018-12-31 87 10         97 26 9   11       143
103 BANNER CHURCHILL COMMUNITY HOSPITAL 801 EAST WILLIAMS AVENUE FALLON NV 89406 CHURCHILL (775) 423-3151 Critical Access Hospitals Voluntary non-profit - Private TRUE 39.4748760 -118.7651800 0   1 32 32001 21980   Central Churchill County https://data.medicare.gov/resource/xubh-q36u/row-2y58~2j5s~r7uz 291313 654684 2019-09-18 2018-12-31 25           25               25
116 WEST RIVER REGIONAL MEDICAL CENTER-CAH 1000 HIGHWAY 12 HETTINGER ND 58639 ADAMS (701) 567-4561 Critical Access Hospitals Voluntary non-profit - Private TRUE 46.0013230 -102.6282390 0   1 38 38001         https://data.medicare.gov/resource/xubh-q36u/row-kpck-85x6-gtvw 351330 654546 2019-08-29 2019-03-31 25           25               25
117 ADAMS COUNTY REGIONAL MEDICAL CENTER 230 MEDICAL CENTER DRIVE SEAMAN OH 45679 ADAMS (937) 386-3400 Critical Access Hospitals Government - Local TRUE 38.9338480 -83.5856120 0   1 39 39001         https://data.medicare.gov/resource/xubh-q36u/row-wb9j-jzwz-2xmu 361326 649329 2019-05-30 2018-12-31 25           25               25
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 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
123 PALESTINE REGIONAL MEDICAL CENTER 2900 S LOOP 256 PALESTINE TX 75801 ANDERSON (903) 731-1000 Acute Care Hospitals Proprietary TRUE 31.7333740 -95.6253070 0   1 48 48001 37300   Central Anderson County https://data.medicare.gov/resource/xubh-q36u/row-ymbb~yh2p_i5c8 450747 649500 2019-06-04 2018-12-31 106 10         116 19 17           152
124 BEAVER VALLEY HOSPITAL 1109 NORTH 100 WEST BEAVER UT 84713 BEAVER (435) 438-7100 Critical Access Hospitals Government - State TRUE 38.2892580 -112.6432040 0   1 49 49001         https://data.medicare.gov/resource/xubh-q36u/row-x2bw~6dhq.mh7x 461335 659078 2019-11-20 2019-06-30 25           25               25
125 MILFORD VALLEY MEMORIAL HOSPITAL 850 NORTH MAIN STREET MILFORD UT 84751 BEAVER (435) 387-2411 Critical Access Hospitals Government - Hospital District or Authority FALSE 38.4073080 -113.0095430 0   1 49 49001         https://data.medicare.gov/resource/xubh-q36u/row-iet4.f5zs.batz 461305 648782 2019-05-29 2018-12-31 5           5           18   23
126 PORTER HOSPITAL, INC 115 PORTER DRIVE MIDDLEBURY VT 5753 ADDISON (802) 388-4701 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.9994700 -73.1698030 0   1 50 50001         https://data.medicare.gov/resource/xubh-q36u/row-xcfu_sc2r.d4bu 471307 653360 2019-08-29 2018-09-30 25           25               25
127 RIVERSIDE SHORE MEMORIAL HOSPITAL 20480 MARKET STREET ONANCOCK VA 23417 ACCOMACK (757) 414-8000 Acute Care Hospitals Voluntary non-profit - Private TRUE 37.6997120 -75.7209370 0   1 51 51001         https://data.medicare.gov/resource/xubh-q36u/row-w6kr~hh5i_py3g 490037 650393 2019-05-31 2018-12-31 36 10         46               46
130 BROADDUS HOSPITAL ASSOCIATION, INC 1 HEALTHCARE DRIVE MANSFIELD HILL PHILIPPI WV 26416 BARBOUR (304) 457-1760 Critical Access Hospitals Voluntary non-profit - Private TRUE 39.1528870 -80.0440910 0   1 54 54001         https://data.medicare.gov/resource/xubh-q36u/row-njqv~ij6d.yec2 511300 650429 2019-05-31 2018-12-31 12           12       60       72
131 MOUNDVIEW MEMORIAL HOSPITAL AND CLINICS 402 W LAKE ST FRIENDSHIP WI 53934 ADAMS (608) 339-3331 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.9739950 -89.8210260 0   1 55 55001         https://data.medicare.gov/resource/xubh-q36u/row-b3gp.589m.s6jc 521309 650550 2019-05-31 2018-12-31 25           25               25
132 IVINSON MEMORIAL HOSPITAL 255 N 30TH LARAMIE WY 82072 ALBANY (307) 755-4600 Acute Care Hospitals Government - Hospital District or Authority TRUE 41.3113900 -105.5575120 0   1 56 56001 29660   Central Albany County https://data.medicare.gov/resource/xubh-q36u/row-ptq5-c827_j29e 530025 660342 2019-12-03 2019-06-30 62 4         66 10     10       86
136 COPPER QUEEN COMMUNITY HOSPITAL 101 COLE AVENUE BISBEE AZ 85603 COCHISE (520) 432-6401 Critical Access Hospitals Voluntary non-profit - Private TRUE 31.4172540 -109.8826000 0   3 4 4003 43420   Central Cochise County https://data.medicare.gov/resource/xubh-q36u/row-3x2q~x9dv.fg6n 31312 659555 2019-11-25 2019-06-30 14           14               14
137 BENSON HOSPITAL 450 SOUTH OCOTILLO AVENUE BENSON AZ 85602 COCHISE (520) 586-2261 Critical Access Hospitals Voluntary non-profit - Private TRUE 31.9648290 -110.3071230 0   3 4 4003 43420   Central Cochise County https://data.medicare.gov/resource/xubh-q36u/row-bbyb-3jvj_e7ef 31301 660910 2019-11-25 2019-06-30 22           22               22
138 CANYON VISTA MEDICAL CENTER 5700 EAST HIGHWAY 90 SIERRA VISTA AZ 85635 COCHISE (520) 263-3001 Acute Care Hospitals Voluntary non-profit - Other TRUE 31.5546350 -110.2307260 0   3 4 4003 43420   Central Cochise County https://data.medicare.gov/resource/xubh-q36u/row-ghfv-yx8h~hkgn 30043 654824 2019-09-30 2019-04-30 63 12         75 19             94
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
140 SAN LUIS VALLEY HEALTH 106 BLANCA AVE ALAMOSA CO 81101 ALAMOSA (719) 589-2511 Acute Care Hospitals Voluntary non-profit - Private TRUE 37.4723600 -105.8837120 0   3 8 8003         https://data.medicare.gov/resource/xubh-q36u/row-bztx~k7ma~ri7p 60008 661701 2019-12-03 2019-06-30 43 6         49               49
147 BIG HORN HOSPITAL 17 N MILES HARDIN MT 59034 BIG HORN (406) 665-2310 Critical Access Hospitals Government - Local TRUE 45.7288560 -107.6170100 0   3 30 30003         https://data.medicare.gov/resource/xubh-q36u/row-2cgz.f5s8-gu8f 271338 652087 2018-11-27 2018-06-30 25           25               25
154 KUAKINI MEDICAL CENTER 347 NORTH KUAKINI STREET HONOLULU HI 96817 HONOLULU (808) 536-2236 Acute Care Hospitals Voluntary non-profit - Private TRUE 21.3222110 -157.8562110 0   3 15 15003 46520   Central Honolulu County https://data.medicare.gov/resource/xubh-q36u/row-haju_ivwx-iwr6 120007 656434 2018-12-26 2018-06-30 146 12 12       170       40 147     357
155 PALI MOMI MEDICAL CENTER 98-1079 MOANALUA ROAD AIEA HI 96701 HONOLULU (808) 486-6000 Acute Care Hospitals Proprietary TRUE 21.3839880 -157.9376750 0   3 15 15003 46520   Central Honolulu County https://data.medicare.gov/resource/xubh-q36u/row-gvhj-d3a6.ypz3 120026 659776 2019-11-26 2019-06-30 110 8         118               118
156 KAPIOLANI MEDICAL CENTER FOR WOMEN & CHILDREN 1319 PUNAHOU STREET HONOLULU HI 96826 HONOLULU (808) 983-6000 Childrens Voluntary non-profit - Private TRUE 21.3003960 -157.8342460 0   3 15 15003 46520   Central Honolulu County https://data.medicare.gov/resource/xubh-q36u/row-2vss_bgb6-b6d4 123300 659778 2019-11-26 2019-06-30 156 3         253               253
157 KAISER FOUNDATION HOSPITAL 3288 MOANALUA RD HONOLULU HI 96819 HONOLULU (808) 432-0000 Acute Care Hospitals Voluntary non-profit - Private TRUE 21.3622920 -157.9001390 0   3 15 15003 46520   Central Honolulu County https://data.medicare.gov/resource/xubh-q36u/row-58ey-5yy7~4xmg 120011 652244 2019-06-06 2018-12-31 252 25         295               295
158 SHRINERS HOSPITAL FOR CHILDREN 1310 PUNAHOU STREET HONOLULU HI 96826 HONOLULU (808) 941-4466 Childrens Voluntary non-profit - Private FALSE 21.3002330 -157.8343650 0   3 15 15003 46520   Central Honolulu County https://data.medicare.gov/resource/xubh-q36u/row-jcn3.53aq~rski 123301 644976 2018-05-31 2017-12-31                              
159 Tripler AMC (FT Shafter) 1 Jarrett White Rd Honolulu HI 96859 HONOLULU (808) 433-2778 Acute Care - Department of Defense Department of Defense TRUE 21.3588670 -157.8887690 0   3 15 15003 46520   Central Honolulu County https://data.medicare.gov/resource/xubh-q36u/row-xb5h~t6w7_qec8                                      
160 THE QUEENS MEDICAL CENTER 1301 PUNCHBOWL ST HONOLULU HI 96813 HONOLULU (808) 538-9011 Acute Care Hospitals Voluntary non-profit - Private TRUE 21.3083070 -157.8549650 0   3 15 15003 46520   Central Honolulu County https://data.medicare.gov/resource/xubh-q36u/row-miez-e8mq~vhab 120001 662517 2019-11-29 2019-06-30 592 58         650               650
161 ADVENTIST HEALTH CASTLE 640 ULUKAHIKI ST KAILUA HI 96734 HONOLULU (808) 263-5500 Acute Care Hospitals Voluntary non-profit - Church TRUE 21.3815020 -157.7572290 0   3 15 15003 46520   Central Honolulu County https://data.medicare.gov/resource/xubh-q36u/row-5zcn.p8qz~eqqf 120006 655891 2019-10-07 2018-12-31 152 8         160               160
162 STRAUB CLINIC AND HOSPITAL 888 SO KING STREET HONOLULU HI 96813 HONOLULU (808) 522-4000 Acute Care Hospitals Proprietary TRUE 21.3022680 -157.8509210 0   3 15 15003 46520   Central Honolulu County https://data.medicare.gov/resource/xubh-q36u/row-j69k-r5cq-9v28 120022 659775 2019-11-26 2019-06-30 140 16   3     159               159
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
164 WAHIAWA GENERAL HOSPITAL 128 LEHUA STREET WAHIAWA HI 96786 HONOLULU (808) 621-8411 Acute Care Hospitals Voluntary non-profit - Private TRUE 21.4985110 -158.0272990 0   3 15 15003 46520   Central Honolulu County https://data.medicare.gov/resource/xubh-q36u/row-tmp7_2wk5_m9wr 120004 662186 2019-11-26 2019-06-30 37 6         43       107       150
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
172 ANDERSON COUNTY HOSPITAL 421 S MAPLE GARNETT KS 66032 ANDERSON (785) 204-4000 Critical Access Hospitals Voluntary non-profit - Private TRUE 38.2801200 -95.2493000 0   3 20 20003         https://data.medicare.gov/resource/xubh-q36u/row-3ktx.x5ze~zgrj 171316 648620 2019-05-24 2018-12-31 12           12           36   48
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
175 OAKDALE COMMUNITY HOSPITAL 130 N HOSPITAL DR OAKDALE LA 71463 ALLEN (318) 335-3700 Acute Care Hospitals Proprietary TRUE 30.8162640 -92.6445450 0   3 22 22003         https://data.medicare.gov/resource/xubh-q36u/row-7xwr-vazc_74w6 190106 654443 2019-09-09 2019-03-31 46 3         49               49
176 CARY MEDICAL CENTER 163 VAN BUREN RD, SUITE 1 CARIBOU ME 4736 AROOSTOOK (207) 498-3111 Acute Care Hospitals Government - Local TRUE 46.8782370 -68.0096390 0   3 23 23003         https://data.medicare.gov/resource/xubh-q36u/row-3dpx.x267~9y3n 200031 650153 2019-05-31 2018-12-31 43 6         49               49
177 NORTHERN MAINE MEDICAL CENTER 194 E MAIN STREET FORT KENT ME 4743 AROOSTOOK (207) 834-3195 Acute Care Hospitals Voluntary non-profit - Private TRUE 47.2650680 -68.5911770 0   3 23 23003         https://data.medicare.gov/resource/xubh-q36u/row-cr45-cm3b-wfye 200052 645099 2019-02-28 2018-09-30 43           43 6     45       94
178 NORTHERN LIGHT A R GOULD HOSPITAL PO BOX 151 PRESQUE ISLE ME 4769 AROOSTOOK (207) 768-4000 Acute Care Hospitals Voluntary non-profit - Private TRUE 46.6751494 -67.9985861 1 ROOFTOP 3 23 23003         https://data.medicare.gov/resource/xubh-q36u/row-ihck.jhth~929r 200018 650152 2019-05-29 2018-09-30 43 6         49   5   14 50     118
179 HOULTON REGIONAL HOSPITAL 20 HARTFORD STREET HOULTON ME 4730 AROOSTOOK (207) 532-2900 Critical Access Hospitals Voluntary non-profit - Private TRUE 46.1329620 -67.8426440 0   3 23 23003         https://data.medicare.gov/resource/xubh-q36u/row-tx6y-y4iu-nd9t 201308 645561 2019-03-04 2018-09-30 25           25               25
182 FAIRVIEW HOSPITAL 29 LEWIS AVENUE GREAT BARRINGTON MA 1230 BERKSHIRE (413) 528-0790 Critical Access Hospitals Voluntary non-profit - Private TRUE 42.1919820 -73.3725230 0   3 25 25003 38340   Central Berkshire County https://data.medicare.gov/resource/xubh-q36u/row-6zsa~q4z7~nrdp 221302 645425 2019-03-01 2018-09-30 20 4         24               24
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
184 MUNISING MEMORIAL HOSPITAL 1500 SAND POINT RD MUNISING MI 49862 ALGER (906) 387-4110 Critical Access Hospitals Voluntary non-profit - Private TRUE 46.4238490 -86.6257160 0   3 26 26003         https://data.medicare.gov/resource/xubh-q36u/row-7pqa.fabg.y26z 231308 654139 2019-09-04 2019-03-31 11           11               11
186 MAGNOLIA REGIONAL HEALTH CENTER 611 ALCORN DRIVE CORINTH MS 38834 ALCORN (662) 293-1000 Acute Care Hospitals Voluntary non-profit - Other TRUE 34.9358670 -88.5586480 0   3 28 28003 18420   Central Alcorn County https://data.medicare.gov/resource/xubh-q36u/row-7e2c-erdj.3exa 250009 643795 2019-02-28 2018-09-30 139 24         163 19             182
187 P H S INDIAN HOSPITAL CROW / NORTHERN CHEYENNE 1010 SOUTH 7650 EAST, POST OFFICE BOX 9 CROW AGENCY MT 59022 BIG HORN (406) 638-2626 Critical Access Hospitals Government - Federal TRUE 45.5821958 -107.4488586 1 ROOFTOP 3 30 30003         https://data.medicare.gov/resource/xubh-q36u/row-pgmt~4b42~eq7a 271339 646565 2019-03-26 2018-09-30 24           24               24
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

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