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

4,766 rows sorted by icu_beds

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

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
4 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 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 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 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 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 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 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 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 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 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 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 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 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 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
20 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 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 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 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 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 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 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 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
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
32 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 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 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 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 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
38 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 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 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 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 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 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
49 49 ALAMEDA HOSPITAL 2070 CLINTON AVENUE ALAMEDA CA 94501 ALAMEDA (510) 522-3700 Acute Care Hospitals Government - Hospital District or Authority TRUE 37.7632300 -122.2535410 0   1 6 6001 41860 San Jose-San Francisco-Oakland, CA Central Alameda County https://data.medicare.gov/resource/xubh-q36u/row-aten_zvra_dnju 50211 662328 2018-12-03 2018-06-30 29   5       34       181       215
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
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
77 77 NORTH FLORIDA REGIONAL MEDICAL CENTER 6500 NEWBERRY RD GAINESVILLE FL 32605 ALACHUA (352) 333-4100 Acute Care Hospitals Proprietary TRUE 29.6596990 -82.4115970 0   1 12 12001 23540 Gainesville-Lake City, FL Central Alachua County https://data.medicare.gov/resource/xubh-q36u/row-cu2v_edeq-29tz 100204 652641 2019-08-01 2019-02-28 321   48     12 381 33             414
81 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
83 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 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
85 85 TREASURE VALLEY HOSPITAL 8800 WEST EMERALD STREET BOISE ID 83704 ADA (208) 373-5000 Acute Care Hospitals Proprietary FALSE 43.6112890 -116.2903320 0   1 16 16001 14260 Boise City-Mountain Home-Ontario, ID-OR Central Ada County https://data.medicare.gov/resource/xubh-q36u/row-egh2.u29a~s2jf 130063 650684 2019-05-31 2018-12-31 9           9               9
89 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 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
91 91 ACADIA ST LANDRY 810 SOUTH BROADWAY STREET CHURCH POINT LA 70525 ACADIA (337) 684-5435 Critical Access Hospitals Government - Hospital District or Authority TRUE 30.3950170 -92.2118330 0   1 22 22001 29180 Lafayette-Opelousas-Morgan City, LA Outlying Acadia Parish https://data.medicare.gov/resource/xubh-q36u/row-mqb2~y9xg-useh 191319 661189 2019-12-05 2019-06-30 15           15 10             25
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
103 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
110 110 UNM HOSPITAL 2211 LOMAS BOULEVARD NE ALBUQUERQUE NM 87106 BERNALILLO (505) 272-2111 Acute Care Hospitals Voluntary non-profit - Other TRUE 35.0874830 -106.6181480 0   1 35 35001 10740 Albuquerque-Santa Fe-Las Vegas, NM Central Bernalillo County https://data.medicare.gov/resource/xubh-q36u/row-ntcm.qi4a~h9yr 320001 661059 2019-11-26 2019-06-30 345           473 82             555
113 113 ST PETER'S HOSPITAL 315 SOUTH MANNING BOULEVARD ALBANY NY 12208 ALBANY (518) 525-1550 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.6601760 -73.8023820 0   1 36 36001 10580 Albany-Schenectady, NY Central Albany County https://data.medicare.gov/resource/xubh-q36u/row-sq59.k3z9-zynf 330057 662055 2019-12-18 2019-06-30 445   22     15 482               482
116 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 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 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
124 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 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 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
128 128 OTHELLO COMMUNITY HOSPITAL 315 NORTH 14TH AVENUE OTHELLO WA 99344 ADAMS (509) 488-2636 Critical Access Hospitals Government - Hospital District or Authority TRUE 46.8303630 -119.1543630 0   1 53 53001 36830 Moses Lake-Othello, WA Central Adams County https://data.medicare.gov/resource/xubh-q36u/row-5z56.vhnt-5g9t 501318 658624 2019-11-12 2018-12-31 16           16               16
129 129 EAST ADAMS RURAL HOSPITAL 903 SOUTH ADAMS RITZVILLE WA 99169 ADAMS (509) 659-1200 Critical Access Hospitals Government - Hospital District or Authority TRUE 47.1209590 -118.3722580 0   1 53 53001 36830 Moses Lake-Othello, WA Central Adams County https://data.medicare.gov/resource/xubh-q36u/row-37up~x54g-vsqq 501311 653086 2019-05-31 2018-12-31 12           12               12
130 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 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
136 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 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
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
143 143 CONNECTICUT CHILDRENS MEDICAL CENTER 282 WASHINGTON STREET HARTFORD CT 6106 HARTFORD (860) 545-9000 Childrens Voluntary non-profit - Private TRUE 41.7534820 -72.6828120 0   3 9 9003 25540 Hartford-West Hartford, CT Central Hartford County https://data.medicare.gov/resource/xubh-q36u/row-ew6z.c4u9~qxnc 73300 645529 2019-03-25 2018-09-30 97           187               187
147 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
148 148 HEBREW HOME AND HOSPITAL INC 1 ABRAHMS BOULEVARD WEST HARTFORD CT 6117 HARTFORD (860) 523-3800 Acute Care Hospitals Voluntary non-profit - Private FALSE 41.8027740 -72.7289310 0   3 9 9003 25540 Hartford-West Hartford, CT Central Hartford County https://data.medicare.gov/resource/xubh-q36u/row-eqjh_iqnh-wsnp 70040 645324 2019-02-28 2018-09-30 23           23 22             45
151 151 ALFRED I DUPONT HOSPITAL FOR CHILDREN 1600 ROCKLAND RD PO BOX 269 WILMINGTON DE 19899 NEW CASTLE (302) 651-4000 Childrens Voluntary non-profit - Private TRUE 39.7823370 -75.5552390 0   3 10 10003 37980 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central New Castle County https://data.medicare.gov/resource/xubh-q36u/row-b9cf-cftg-3kpg 83300 659028 2019-11-13 2018-12-31 114         24 208               208
153 153 ED FRASER MEMORIAL HOSPITAL 159 N 3RD ST MACCLENNY FL 32063 BAKER (904) 259-3151 Acute Care Hospitals Voluntary non-profit - Church TRUE 30.2855500 -82.1195500 0   3 12 12003 27260 Jacksonville-St. Marys-Palatka, FL-GA Outlying Baker County https://data.medicare.gov/resource/xubh-q36u/row-bder~g3nx~udyj 100134 644243 2019-03-01 2018-09-30 21           21       68       89
158 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 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                                      
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
165 165 LUTHERAN HOSPITAL OF INDIANA 7950 W JEFFERSON BLVD FORT WAYNE IN 46804 ALLEN (260) 435-7001 Acute Care Hospitals Proprietary TRUE 41.0373740 -85.2458850 0   3 18 18003 23060 Fort Wayne-Huntington-Auburn, IN Central Allen County https://data.medicare.gov/resource/xubh-q36u/row-22sz~6zvg.fbpc 150017 661886 2019-12-03 2019-06-30 254   24       396               396
167 167 ST JOSEPH HOSPITAL 700 BROADWAY FORT WAYNE IN 46802 ALLEN (260) 425-3000 Acute Care Hospitals Proprietary TRUE 41.0788910 -85.1488730 0   3 18 18003 23060 Fort Wayne-Huntington-Auburn, IN Central Allen County https://data.medicare.gov/resource/xubh-q36u/row-kr9f_9zxq-kk6p 150047 655893 2019-10-31 2019-05-31 76     12     88 19     20       127
168 168 THE ORTHOPAEDIC HOSPITAL OF LUTHERAN HEALTH NETWOR 7952 W JEFFERSON BLVD FORT WAYNE IN 46804 ALLEN (260) 435-2999 Acute Care Hospitals Proprietary FALSE 41.0373520 -85.2459180 0   3 18 18003 23060 Fort Wayne-Huntington-Auburn, IN Central Allen County https://data.medicare.gov/resource/xubh-q36u/row-65sn_hsdz_dbbf 150168 649728 2019-06-03 2018-12-31 39           39               39
170 170 ORTHOPAEDIC HOSPITAL AT PARKVIEW NORTH LLC 11130 PARKVIEW CIRCLE DR FORT WAYNE IN 46845 ALLEN (260) 672-4050 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.1886620 -85.1032920 0   3 18 18003 23060 Fort Wayne-Huntington-Auburn, IN Central Allen County https://data.medicare.gov/resource/xubh-q36u/row-eyta.fsu8.cmma 150167 654435 2019-05-29 2018-12-31 37           37               37
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
172 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
173 173 THE MEDICAL CENTER AT SCOTTSVILLE 456 BURNLEY ROAD SCOTTSVILLE KY 42164 ALLEN (270) 622-2800 Critical Access Hospitals Voluntary non-profit - Private TRUE 36.7597650 -86.2162120 0   3 21 21003 14540 Bowling Green-Glasgow, KY Outlying Allen County https://data.medicare.gov/resource/xubh-q36u/row-v9hf~phby-c7vz 181324 654252 2019-09-03 2019-03-31 25           25       110       135
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
177 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
179 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
184 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
187 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 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
190 190 99th Medical Group (Nellis AFB) 99 MDG 4700 Las Vegas Blvd Nellis AFB NV 89191 CLARK (702) 653-2273 Acute Care - Department of Defense Department of Defense TRUE 36.2457836 -115.0497641 1 ROOFTOP 3 32 32003 29820 Las Vegas-Henderson, NV-AZ Central Clark County https://data.medicare.gov/resource/xubh-q36u/row-dmy4.2nr3_wdjy                                      
191 191 HARMON HOSPITAL 2170 EAST HARMON AVENUE LAS VEGAS NV 89119 CLARK (702) 794-0100 Acute Care Hospitals Voluntary non-profit - Private FALSE 36.1073690 -115.1219920 0   3 32 32003 29820 Las Vegas-Henderson, NV-AZ Central Clark County https://data.medicare.gov/resource/xubh-q36u/row-qtzp-aczd_sysf 290042 629833 2018-05-31 2017-12-31                              
198 198 BOULDER CITY HOSPITAL 901 ADAMS BLVD BOULDER CITY NV 89005 CLARK (702) 293-4111 Critical Access Hospitals Voluntary non-profit - Private TRUE 35.9683590 -114.8434860 0   3 32 32003 29820 Las Vegas-Henderson, NV-AZ Central Clark County https://data.medicare.gov/resource/xubh-q36u/row-m2cb.9j9h-qmdd 291309 651018 2019-06-03 2018-12-31 25           25 10     47       82
200 200 DIGNITY HEALTH ST ROSE DOMINICAN N L V CAMPUS 1550 W CRAIG RANCH NORTH LAS VEGAS NV 89031 CLARK (702) 777-3615 Acute Care Hospitals Proprietary TRUE 36.2434428 -115.1500008 1 ROOFTOP 3 32 32003 29820 Las Vegas-Henderson, NV-AZ Central Clark County https://data.medicare.gov/resource/xubh-q36u/row-u3b3_a37u-466v 290058 652436 2019-05-30 2018-12-31 32           32               32
205 205 ORTHOPEDIC SPECIALTY HOSPITAL OF NEVADA 8656 WEST PATRICK LANE LAS VEGAS NV 89148 CLARK (702) 777-7100 Acute Care Hospitals Voluntary non-profit - Private FALSE 36.0778110 -115.2810360 0   3 32 32003 29820 Las Vegas-Henderson, NV-AZ Central Clark County https://data.medicare.gov/resource/xubh-q36u/row-zknv_98at.vvbk 290056 645924 2019-03-28 2018-10-31 130           130               130
216 216 CUBA MEMORIAL HOSPITAL, INC 140 WEST MAIN STREET CUBA NY 14727 ALLEGANY (585) 961-2000 Critical Access Hospitals Voluntary non-profit - Private FALSE 42.2133410 -78.2881390 0   3 36 36003         https://data.medicare.gov/resource/xubh-q36u/row-2ir6~7udp_pyzv 331301 651038 2019-06-03 2018-12-31 20           20       61       81
218 218 CHI MERCY HEALTH 570 CHAUTAUQUA BLVD VALLEY CITY ND 58072 BARNES (701) 845-6400 Critical Access Hospitals Voluntary non-profit - Church TRUE 46.9284920 -97.9949080 0   3 38 38003         https://data.medicare.gov/resource/xubh-q36u/row-pmhy~szku-z7nc 351324 662240 2019-11-26 2019-06-30 25           25               25
221 221 INSTITUTE FOR ORTHOPAEDIC SURGERY 801 MEDICAL DRIVE, SUITE B LIMA OH 45804 ALLEN (419) 224-7586 Acute Care Hospitals Proprietary FALSE 40.6985860 -84.0864770 0   3 39 39003 30620 Lima-Van Wert-Celina, OH Central Allen County https://data.medicare.gov/resource/xubh-q36u/row-kbua_iifb.k5nj 360263 649649 2019-06-03 2018-12-31 12           12               12
222 222 BLUFFTON HOSPITAL 139 GARAU STREET BLUFFTON OH 45817 ALLEN (419) 358-9010 Critical Access Hospitals Voluntary non-profit - Private TRUE 40.8875780 -83.8981490 0   3 39 39003 30620 Lima-Van Wert-Celina, OH Central Allen County https://data.medicare.gov/resource/xubh-q36u/row-manx~srzz-7qqn 361322 650898 2019-06-04 2018-12-31 25           25               25
225 225 UPMC MCKEESPORT 1500 FIFTH AVENUE MC KEESPORT PA 15132 ALLEGHENY (412) 664-2000 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.3523000 -79.8492180 0   3 42 42003 38300 Pittsburgh-New Castle-Weirton, PA-OH-WV Central Allegheny County https://data.medicare.gov/resource/xubh-q36u/row-vm5i_92bf_4vwi 390002 659604 2019-11-21 2019-06-30 174   12       186   9   18       213
234 234 CHILDREN'S HOME OF PITTSBURGH 5324 PENN AVENUE PITTSBURGH PA 15224 ALLEGHENY (412) 441-4884 Childrens Voluntary non-profit - Private FALSE 40.4646370 -79.9376420 0   3 42 42003 38300 Pittsburgh-New Castle-Weirton, PA-OH-WV Central Allegheny County https://data.medicare.gov/resource/xubh-q36u/row-7vky_uvyh~58pt 393304 659723 2019-10-01 2019-06-30                              
244 244 PERMIAN REGIONAL MEDICAL CENTER ANDREWS COUNTY HO 720 HOSPITAL DRIVE ANDREWS TX 79714 ANDREWS (432) 523-2200 Acute Care Hospitals Government - Hospital District or Authority TRUE 32.3374240 -102.5468660 0   3 48 48003 11380   Central Andrews County https://data.medicare.gov/resource/xubh-q36u/row-juik.55wn.c6fd 450144 643151 2019-02-12 2018-09-30 30           30               30
245 245 BRIGHAM CITY COMMUNITY HOSPITAL 950 SOUTH MEDICAL DRIVE BRIGHAM CITY UT 84302 BOX ELDER (435) 734-9471 Acute Care Hospitals Proprietary TRUE 41.4910700 -112.0244410 0   3 49 49003 36260 Salt Lake City-Provo-Orem, UT Central Box Elder County https://data.medicare.gov/resource/xubh-q36u/row-nuu9~e5qc.3jxf 460017 657558 2019-01-17 2018-08-31 40           40               40
246 246 BEAR RIVER VALLEY HOSPITAL 905 NORTH 1000 WEST TREMONTON UT 84337 BOX ELDER (435) 207-4500 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.7237680 -112.1819790 0   3 49 49003 36260 Salt Lake City-Provo-Orem, UT Central Box Elder County https://data.medicare.gov/resource/xubh-q36u/row-dbs5_2pqd_mjjc 460039 647593 2019-05-10 2018-12-31 16           16               16
249 249 TRI-STATE MEMORIAL HOSPITAL 1221 HIGHLAND AVENUE CLARKSTON WA 99403 ASOTIN (509) 758-5511 Critical Access Hospitals Voluntary non-profit - Private TRUE 46.4036380 -117.0545070 0   3 53 53003 30300   Central Asotin County https://data.medicare.gov/resource/xubh-q36u/row-i7hs.ad2c-g7gn 501332 649847 2019-06-03 2018-12-31 25           25               25
251 251 MEMORIAL MEDICAL CENTER 1615 MAPLE LANE ASHLAND WI 54806 ASHLAND (715) 685-5500 Critical Access Hospitals Voluntary non-profit - Private TRUE 46.5668870 -90.8879780 0   3 55 55003         https://data.medicare.gov/resource/xubh-q36u/row-d5tf.6nqz~nbsb 521359 645519 2019-03-01 2018-09-30 25           25 10             35
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

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