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

1,355 rows where hospital_type = "Critical Access Hospitals" sorted by countyfips

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: hospital_ownership, emergency_services, geocode_flag, geocode_accuracy, centraloutlyingcounty, fy_end_date, acute_beds, icu_beds, coronary_beds, surg_icu_beds, subprovider_ipf_beds, subprovider_irf_beds, nursing_fac_beds, filed_date (date), fy_end_date (date)

hospital_type ✖

  • Critical Access Hospitals · 1,355 ✖
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
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
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
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
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
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
88 88 ADAMS MEMORIAL HOSPITAL 1100 MERCER AVE DECATUR IN 46733 ADAMS (260) 724-2145 Critical Access Hospitals Government - Local TRUE 40.8179660 -84.9125350 0   1 18 18001 19540 Fort Wayne-Huntington-Auburn, IN Central Adams County https://data.medicare.gov/resource/xubh-q36u/row-vdys.bcxa-gdh7 151330 649100 2019-05-30 2018-12-31 21 4         25               25
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
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
98 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
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
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
119 119 SAINT ALPHONSUS MEDICAL CENTER - BAKER CITY, INC 3325 POCAHONTAS ROAD BAKER CITY OR 97814 BAKER (541) 524-7744 Critical Access Hospitals Voluntary non-profit - Church TRUE 44.7961200 -117.8462850 0   1 41 41001         https://data.medicare.gov/resource/xubh-q36u/row-yt65-wbpr_7cai 381315 661086 2019-12-02 2019-06-30 19 2         21               21
121 121 ABBEVILLE AREA MEDICAL CENTER 420 THOMSON CIRCLE ABBEVILLE SC 29620 ABBEVILLE (864) 366-5011 Critical Access Hospitals Government - Local TRUE 34.1561250 -82.3801740 0   1 45 45001 24940 Greenville-Spartanburg-Anderson, SC Outlying Abbeville County https://data.medicare.gov/resource/xubh-q36u/row-v8xu.2huz_ubxe 421301 645182 2019-02-25 2018-09-30 19 6         25               25
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
1 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 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
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
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
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
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
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
182 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
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
197 197 MESA VIEW REGIONAL HOSPITAL 1299 BERTHA HOWE AVENUE MESQUITE NV 89027 CLARK (702) 346-8040 Critical Access Hospitals Proprietary TRUE 36.8088590 -114.1144560 0   3 32 32003 29820 Las Vegas-Henderson, NV-AZ Central Clark County https://data.medicare.gov/resource/xubh-q36u/row-8rk4-cq3s_fa8n 291307 640239 2018-12-18 2018-07-31 21 4         25               25
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
209 209 MEMORIAL HOSPITAL, THE 3073 WHITE MOUNTAIN HIGHWAY NORTH CONWAY NH 3860 CARROLL (603) 356-5461 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.0605190 -71.1385100 0   3 33 33003         https://data.medicare.gov/resource/xubh-q36u/row-n7xq-6ijr_9ppy 301307 645671 2019-03-01 2018-09-30 21 4         25         45     70
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
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
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
253 253 SOUTH BIG HORN COUNTY CRITICAL ACCESS HOSPITAL 388 US HIGHWAY 20 SOUTH BASIN WY 82410 BIG HORN (307) 568-1500 Critical Access Hospitals Government - Hospital District or Authority TRUE 44.4344490 -108.0490070 0   3 56 56003         https://data.medicare.gov/resource/xubh-q36u/row-vp99_bama.8nds 531301 661691 2019-11-29 2019-06-30 10           10       37       47
257 257 PAGE HOSPITAL 501 NORTH NAVAJO DRIVE PAGE AZ 86040 COCONINO (928) 645-2424 Critical Access Hospitals Government - Hospital District or Authority TRUE 36.9169600 -111.4631860 0   5 4 4005 22380   Central Coconino County https://data.medicare.gov/resource/xubh-q36u/row-pwtm.vez8_t2h2 31304 649070 2019-06-03 2018-12-31 25           25               25
270 270 BACON COUNTY HOSPITAL 302 SOUTH WAYNE STREET ALMA GA 31510 BACON (912) 632-8961 Critical Access Hospitals Voluntary non-profit - Other TRUE 31.5391100 -82.4596870 0   5 13 13005         https://data.medicare.gov/resource/xubh-q36u/row-fsgt~f6fy~f5qx 111327 659492 2019-11-26 2019-06-30 21 4         25       88       113
274 274 VETERANS MEMORIAL HOSPITAL 40 1ST STREET SE WAUKON IA 52172 ALLAMAKEE (563) 568-3411 Critical Access Hospitals Government - Local TRUE 43.2680920 -91.4744460 0   5 19 19005         https://data.medicare.gov/resource/xubh-q36u/row-kmrq-g36y.pe5i 161318 660959 2019-12-02 2019-06-30 25           25               25
275 275 ATCHISON HOSPITAL 800 RAVIN HILL DRIVE ATCHISON KS 66002 ATCHISON (913) 360-5581 Critical Access Hospitals Voluntary non-profit - Private TRUE 39.5366253 -95.1282386 1 ROOFTOP 5 20 20005 11860 Kansas City-Overland Park-Kansas City, MO-KS Central Atchison County https://data.medicare.gov/resource/xubh-q36u/row-fwt4-3qfd~33ue 171382 645412 2019-03-01 2018-09-30 21 4         25               25
276 276 PREVOST MEMORIAL HOSPITAL 301 MEMORIAL DR DONALDSONVILLE LA 70346 ASCENSION (225) 474-2133 Critical Access Hospitals Government - Hospital District or Authority TRUE 30.0879510 -91.0029040 0   5 22 22005 12940   Central Ascension Parish https://data.medicare.gov/resource/xubh-q36u/row-e567~vwui.ed3h 191308 642472 2019-02-01 2018-08-31 25           25               25
279 279 BRIDGTON HOSPITAL 10 HOSPITAL DRIVE BRIDGTON ME 4009 CUMBERLAND (207) 647-6000 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.0472490 -70.7127770 0   5 23 23005 38860 Portland-Lewiston-South Portland, ME Central Cumberland County https://data.medicare.gov/resource/xubh-q36u/row-xeqw-dspw~ebr9 201310 662214 2019-12-02 2019-06-30 25           25               25
290 290 ALLEGAN GENERAL HOSPITAL 555 LINN STREET ALLEGAN MI 49010 ALLEGAN (269) 686-4101 Critical Access Hospitals Voluntary non-profit - Other TRUE 42.5202590 -85.8569390 0   5 26 26005 26090 Grand Rapids-Wyoming-Muskegon, MI Central Allegan County https://data.medicare.gov/resource/xubh-q36u/row-9kac~4r3i~rk7m 231328 649266 2019-05-30 2018-12-31 25           25               25
292 292 FIELD HEALTH SYSTEM 178 HIGHWAY 24 CENTREVILLE MS 39631 WILKINSON (601) 890-0500 Critical Access Hospitals Government - Local TRUE 31.0820299 -91.0587631 1 ROOFTOP 5 28 28005 32620   Outlying Amite County https://data.medicare.gov/resource/xubh-q36u/row-d7tp~8xnm~uwen 251309 646102 2019-02-28 2018-09-30 16           16               16
293 293 COMMUNITY HOSPITAL ASSOCIATION 26136 US HIGHWAY 59, PO BOX 107 FAIRFAX MO 64446 ATCHISON (660) 686-2211 Critical Access Hospitals Voluntary non-profit - Private TRUE 40.3482150 -95.3973230 0   5 29 29005         https://data.medicare.gov/resource/xubh-q36u/row-kkzi.c85k.9msb 261303 660249 2019-11-26 2019-06-30 16           16               16
294 294 P H S INDIAN HOSPITAL-FT BELKNAP AT HARLEM - CAH 456 GROS VENTRE AVE, RR 1 HARLEM MT 59526 BLAINE (406) 353-3100 Critical Access Hospitals Government - Federal TRUE 48.4851890 -108.7670010 0   5 30 30005         https://data.medicare.gov/resource/xubh-q36u/row-sifm_y3g6.gq5p 271315 646038 2019-03-29 2018-09-30 6           6               6
295 295 CARSON VALLEY MEDICAL CENTER 1107 HIGHWAY 395 GARDNERVILLE NV 89410 DOUGLAS (775) 782-1500 Critical Access Hospitals Voluntary non-profit - Private TRUE 38.9195628 -119.7189852 1 ROOFTOP 5 32 32005 23820 Reno-Carson City-Fernley, NV Central Douglas County https://data.medicare.gov/resource/xubh-q36u/row-zs3t-b2ik_qdz7 291306 650728 2019-05-31 2018-12-31 23           23               23
309 309 ALLEGHANY COUNTY MEMORIAL HOSPITAL 617 DOCTORS STREET SPARTA NC 28675 ALLEGHANY (336) 372-5511 Critical Access Hospitals Voluntary non-profit - Private TRUE 36.5095115 -81.1150447 1 RANGE_INTERPOLATED 5 37 37005         https://data.medicare.gov/resource/xubh-q36u/row-zjv8.p46n-e733 341320 645140 2019-03-04 2018-09-30 25           25               25
311 311 ATOKA COUNTY MEDICAL CENTER 1590 WEST LIBERTY ROAD ATOKA OK 74525 ATOKA (580) 889-3333 Critical Access Hospitals Government - Hospital District or Authority TRUE 34.3952620 -96.1594880 0   5 40 40005         https://data.medicare.gov/resource/xubh-q36u/row-qvh3-hh93~canr 371300 649482 2019-05-22 2018-12-31 25           25               25
317 317 ALLENDALE COUNTY HOSPITAL 1787 ALLENDALE FAIRFAX RD FAIRFAX SC 29827 ALLENDALE (803) 632-3311 Critical Access Hospitals Government - Local TRUE 32.9662250 -81.2477270 0   5 45 45005         https://data.medicare.gov/resource/xubh-q36u/row-bjdu~dq8g.u82d 421300 645444 2019-03-04 2018-09-30 25           25       44       69
318 318 HURON REGIONAL MEDICAL CENTER 172 FOURTH STREET SE HURON SD 57350 BEADLE (605) 353-6200 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.3620350 -98.2107510 0   5 46 46005 26700   Central Beadle County https://data.medicare.gov/resource/xubh-q36u/row-zcx3~7b4g-9rji 431335 662256 2019-11-29 2019-06-30 19 6         25               25
319 319 CAMDEN GENERAL HOSPITAL 175 HOSPITAL DRIVE CAMDEN TN 38320 BENTON (731) 584-0109 Critical Access Hospitals Government - Hospital District or Authority TRUE 36.0557800 -88.1075170 0   5 47 47005         https://data.medicare.gov/resource/xubh-q36u/row-rp5g~twzk~kf69 441316 660045 2019-12-03 2019-06-30 25           25               25
324 324 NORTHEASTERN VERMONT REGIONAL HOSPITAL 1315 HOSPITAL DRIVE SAINT JOHNSBURY VT 5819 CALEDONIA (802) 748-7400 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.4452620 -72.0095160 0   5 50 50005         https://data.medicare.gov/resource/xubh-q36u/row-868v.jqmt-84z2 471303 649002 2019-05-21 2018-09-30 21 4         25               25
326 326 PROSSER MEMORIAL HOSPITAL 723 MEMORIAL STREET PROSSER WA 99350 BENTON (509) 786-2222 Critical Access Hospitals Government - Hospital District or Authority TRUE 46.2076300 -119.7635020 0   5 53 53005 28420   Central Benton County https://data.medicare.gov/resource/xubh-q36u/row-jxdy-bhag~5gk3 501312 652444 2019-05-31 2018-12-31 25           25               25
329 329 BOONE MEMORIAL HOSPITAL 701 MADISON AVENUE MADISON WV 25130 BOONE (304) 369-1230 Critical Access Hospitals Government - Local TRUE 38.0486360 -81.8065320 0   5 54 54005 16620 Charleston-Huntington-Ashland, WV-OH-KY Outlying Boone County https://data.medicare.gov/resource/xubh-q36u/row-r4j3~ibqd.28ff 511313 661267 2019-12-02 2019-06-30 25           25               25
331 331 MAYO CLINIC HEALTH SYSTEM-NORTHLAND 1222 E WOODLAND AVE BARRON WI 54812 BARRON (715) 537-3186 Critical Access Hospitals Voluntary non-profit - Private TRUE 45.3983690 -91.8406680 0   5 55 55005         https://data.medicare.gov/resource/xubh-q36u/row-y236_phpe.9nrq 521315 649524 2019-05-28 2018-12-31 25           25               25
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
335 335 CIBOLA GENERAL HOSPITAL 1016 E ROOSEVELT AVENUE GRANTS NM 87020 CIBOLA (505) 287-5300 Critical Access Hospitals Government - Local TRUE 35.1611680 -107.8265740 0   6 35 35006 24380 Albuquerque-Santa Fe-Las Vegas, NM Central Cibola County https://data.medicare.gov/resource/xubh-q36u/row-ap2g_auck_pm67 321308 662228 2019-12-18 2019-06-30 21 4         25               25
3 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
337 337 BANNER PAYSON MEDICAL CENTER 807 SOUTH PONDEROSA DRIVE PAYSON AZ 85541 GILA (928) 474-3222 Critical Access Hospitals Voluntary non-profit - Other FALSE 34.2313510 -111.3213610 0   7 4 4007 37740   Central Gila County https://data.medicare.gov/resource/xubh-q36u/row-2gy2.vxfy~pkyq 31318 649532 2019-06-03 2018-12-31 21 4         25               25
338 338 COBRE VALLEY REGIONAL MEDICAL CENTER 5880 SOUTH HOSPITAL DRIVE GLOBE AZ 85501 GILA (928) 402-1122 Critical Access Hospitals Voluntary non-profit - Private TRUE 33.4072060 -110.8262240 0   7 4 4007 37740   Central Gila County https://data.medicare.gov/resource/xubh-q36u/row-n6a8-y7ga.5i9e 31314 651879 2019-07-08 2018-12-31 21 4         25               25
339 339 OZARKS COMMUNITY HOSPITAL OF GRAVETTE 1101 JACKSON STREET SW GRAVETTE AR 72736 BENTON (479) 787-5291 Critical Access Hospitals Proprietary TRUE 36.4085630 -94.4598700 0   7 5 5007 22220   Central Benton County https://data.medicare.gov/resource/xubh-q36u/row-snva.mem9_cs94 41331 651314 2019-05-30 2018-12-31 25           25               25
344 344 ORCHARD HOSPITAL 240 SPRUCE STREET GRIDLEY CA 95948 BUTTE (530) 846-5671 Critical Access Hospitals Voluntary non-profit - Private TRUE 39.3669740 -121.6897170 0   7 6 6007 17020   Central Butte County https://data.medicare.gov/resource/xubh-q36u/row-kvk2_zuau.b3ab 51311 640345 2018-12-03 2018-06-30 24           24       52       76
346 346 PAGOSA SPRINGS MEDICAL CENTER 95 SOUTH PAGOSA BOULEVARD PAGOSA SPRINGS CO 81147 ARCHULETA (970) 731-3700 Critical Access Hospitals Government - Hospital District or Authority TRUE 37.2527760 -107.0772190 0   7 8 8007         https://data.medicare.gov/resource/xubh-q36u/row-j5fe.jwy4~ejt9 61328 654714 2019-09-26 2018-12-31 11           11               11
348 348 SHANDS STARKE REGIONAL MEDICAL CENTER 922 E CALL ST STARKE FL 32091 BRADFORD (904) 368-2300 Critical Access Hospitals Proprietary TRUE 29.9419070 -82.1016500 0   7 12 12007         https://data.medicare.gov/resource/xubh-q36u/row-463i.u2z5-p3cq 101310 660199 2019-12-02 2019-06-30 25           25               25
350 350 KAUAI VETERANS MEMORIAL HOSPITAL 4643 WAIMEA CANYON DRIVE WAIMEA HI 96796 KAUAI (808) 338-9431 Critical Access Hospitals Government - State TRUE 21.9600790 -159.6700550 0   7 15 15007 28180   Central Kauai County https://data.medicare.gov/resource/xubh-q36u/row-ddrn-xkz9.2xji 121300 655051 2019-09-20 2018-06-30 23 2         25       20       45
351 351 SAMUEL MAHELONA MEMORIAL HOSPITAL 4800 KAWAIHAU ROAD KAPAA HI 96746 KAUAI (808) 822-4961 Critical Access Hospitals Government - State TRUE 22.0876190 -159.3142040 0   7 15 15007 28180   Central Kauai County https://data.medicare.gov/resource/xubh-q36u/row-ysve.ycbm-b3qy 121306 640504 2018-11-30 2018-06-30 5           5 9     66       80
352 352 BEAR LAKE MEMORIAL HOSPITAL 164 SOUTH FIFTH STREET MONTPELIER ID 83254 BEAR LAKE (208) 847-1630 Critical Access Hospitals Government - Local TRUE 42.3162420 -111.3008470 0   7 16 16007         https://data.medicare.gov/resource/xubh-q36u/row-mggi-9epd.588z 131316 647888 2019-05-16 2018-12-31 21           21       36   32   89
353 353 MERCYONE CENTERVILLE MEDICAL CENTER ONE ST JOSEPH'S DRIVE CENTERVILLE IA 52544 APPANOOSE (641) 437-4111 Critical Access Hospitals Voluntary non-profit - Private TRUE 40.7555228 -92.8568047 1 ROOFTOP 7 19 19007         https://data.medicare.gov/resource/xubh-q36u/row-quyx-h8pq.iqb9 161377 660989 2019-12-02 2019-06-30 22 3         25           19   44
354 354 MEDICINE LODGE MEMORIAL HOSPITAL 710 N WALNUT STREET MEDICINE LODGE KS 67104 BARBER (620) 886-3771 Critical Access Hospitals Government - Hospital District or Authority TRUE 37.2898770 -98.5776590 0   7 20 20007         https://data.medicare.gov/resource/xubh-q36u/row-bqaw~6v8h_uftw 171334 648921 2019-05-28 2018-12-31 22           22               22
355 355 KIOWA DISTRICT HOSPITAL 1002 SOUTH 4TH STREET KIOWA KS 67070 BARBER (620) 825-4131 Critical Access Hospitals Government - Hospital District or Authority TRUE 37.0085470 -98.4897950 0   7 20 20007         https://data.medicare.gov/resource/xubh-q36u/row-cbxd_2s68-tihe 171331 648918 2019-05-29 2018-12-31 10           10               10
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
358 358 MARTHA'S VINEYARD HOSPITAL INC ONE HOSPITAL ROAD, FIRST FL, WING 5, PO BOX 1477 OAK BLUFFS MA 2557 DUKES (508) 693-0410 Critical Access Hospitals Voluntary non-profit - Private TRUE 41.4570063 -70.5517789 1 APPROXIMATE 7 25 25007 47240   Central Dukes County https://data.medicare.gov/resource/xubh-q36u/row-ym84.mbv4~ifss 221300 644287 2019-02-28 2018-09-30 25           25               25
363 363 BAPTIST MEDICAL CENTER-ATTALA 220 HWY 12 WEST KOSCIUSKO MS 39090 ATTALA (662) 289-4311 Critical Access Hospitals Voluntary non-profit - Other TRUE 33.0655920 -89.5967210 0   7 28 28007         https://data.medicare.gov/resource/xubh-q36u/row-24jy_6div~59c7 251336 644042 2019-03-01 2018-09-30 25           25               25
365 365 BROADWATER HEALTH CENTER 110 N OAK ST TOWNSEND MT 59644 BROADWATER (406) 266-3186 Critical Access Hospitals Voluntary non-profit - Private TRUE 46.3213540 -111.5164280 0   7 30 30007         https://data.medicare.gov/resource/xubh-q36u/row-3bqc_c9ze~3cij 271333 662052 2019-12-03 2019-06-30 25           25               25
367 367 ANDROSCOGGIN VALLEY HOSPITAL 59 PAGE HILL ROAD BERLIN NH 3570 COOS (603) 752-2200 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.4870990 -71.1565480 0   7 33 33007 13620   Central Coos County https://data.medicare.gov/resource/xubh-q36u/row-fdui.znjf.jm5w 301310 643921 2019-02-26 2018-09-30 25           25               25
368 368 UPPER CONNECTICUT VALLEY HOSPITAL 181 CORLISS LANE COLEBROOK NH 3576 COOS (603) 237-4971 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.9044120 -71.4814890 0   7 33 33007 13620   Central Coos County https://data.medicare.gov/resource/xubh-q36u/row-5jxk.h2s8~zvc6 301300 644312 2019-02-27 2018-09-30 16           16               16
373 373 MINERS' COLFAX MEDICAL CENTER 203 HOSPITAL DRIVE RATON NM 87740 COLFAX (575) 445-3661 Critical Access Hospitals Government - State TRUE 36.8635480 -104.4431840 0   7 35 35007         https://data.medicare.gov/resource/xubh-q36u/row-52rb_2gq5.zmq9 321307 659824 2019-11-21 2019-06-30 21 4         25         37     62
378 378 UNIVERSITY HOSPITALS CONNEAUT MEDICAL CENTER 158 WEST MAIN ROAD CONNEAUT OH 44030 ASHTABULA (440) 593-1131 Critical Access Hospitals Voluntary non-profit - Other TRUE 41.9369200 -80.5864590 0   7 39 39007 11780 Cleveland-Akron-Canton, OH Central Ashtabula County https://data.medicare.gov/resource/xubh-q36u/row-j92a_zjx7-y5bm 361308 649653 2019-06-03 2018-12-31 20 5         25               25
379 379 UHHS MEMORIAL HOSPITAL OF GENEVA 870 WEST MAIN STREET GENEVA OH 44041 ASHTABULA (440) 466-1141 Critical Access Hospitals Voluntary non-profit - Private TRUE 41.8002330 -80.9622770 0   7 39 39007 11780 Cleveland-Akron-Canton, OH Central Ashtabula County https://data.medicare.gov/resource/xubh-q36u/row-f7rd~3d3q.5pjc 361307 649652 2019-06-03 2018-12-31 20 5         25               25
381 381 BEAVER COUNTY MEMORIAL HOSPITAL 212 EAST 8TH STREET BEAVER OK 73932 BEAVER (580) 625-4551 Critical Access Hospitals Government - Hospital District or Authority TRUE 36.8101950 -100.5164240 0   7 40 40007         https://data.medicare.gov/resource/xubh-q36u/row-97xz.ezcx-saem 371322 659862 2019-11-22 2019-06-30 24           24               24
382 382 COLUMBIA MEMORIAL HOSPITAL 2111 EXCHANGE STREET ASTORIA OR 97103 CLATSOP (503) 325-4321 Critical Access Hospitals Proprietary TRUE 46.1885030 -123.8185020 0   7 41 41007 11820   Central Clatsop County https://data.medicare.gov/resource/xubh-q36u/row-qaiq-isb9.5jkp 381320 647151 2019-04-30 2018-12-31 21 4         25               25
383 383 PROVIDENCE SEASIDE HOSPITAL 725 S WAHANNA ROAD SEASIDE OR 97138 CLATSOP (503) 717-7000 Critical Access Hospitals Voluntary non-profit - Church TRUE 45.9893670 -123.9148050 0   7 41 41007 11820   Central Clatsop County https://data.medicare.gov/resource/xubh-q36u/row-5sr7.sj6w~p8fw 381303 647937 2019-05-15 2018-12-31 23           23               23
392 392 BENNETT COUNTY HOSPITAL AND NURSING HOME - CAH 102 MAJOR ALLEN POST OFFICE BOX 70D MARTIN SD 57551 BENNETT (605) 685-6622 Critical Access Hospitals Voluntary non-profit - Other TRUE 43.1691630 -101.7266636 1 RANGE_INTERPOLATED 7 46 46007         https://data.medicare.gov/resource/xubh-q36u/row-q2mg~bq2u~fi2w 431314 649823 2019-06-03 2018-12-31 14           14           48   62
393 393 ERLANGER BLEDSOE HOSPITAL 71 WHEELERTOWN AVENUE PIKEVILLE TN 37367 BLEDSOE (423) 447-2112 Critical Access Hospitals Government - Hospital District or Authority TRUE 35.6218300 -85.1883040 0   7 47 47007         https://data.medicare.gov/resource/xubh-q36u/row-86fw~zcvu.6xu7 441306 659536 2019-11-25 2019-06-30 25           25               25
397 397 LAKE CHELAN COMMUNITY HOSPITAL 503 EAST HIGHLAND CHELAN WA 98816 CHELAN (509) 682-3300 Critical Access Hospitals Government - Hospital District or Authority TRUE 47.8451390 -120.0105110 0   7 53 53007 48300   Central Chelan County https://data.medicare.gov/resource/xubh-q36u/row-a77p~uq78~jh3e 501334 651089 2019-06-03 2018-12-31 25           25               25
399 399 CASCADE MEDICAL CENTER 817 COMMERCIAL STREET LEAVENWORTH WA 98826 CHELAN (509) 548-5815 Critical Access Hospitals Government - Hospital District or Authority TRUE 47.5944570 -120.6615030 0   7 53 53007 48300   Central Chelan County https://data.medicare.gov/resource/xubh-q36u/row-y32v.qfkm-6i3p 501313 659387 2019-05-29 2018-12-31 9           9               9

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