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 statefips

✎ 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
402 402 ST VINCENTS BLOUNT 150 GILBREATH DRIVE ONEONTA AL 35121 BLOUNT (205) 274-3000 Critical Access Hospitals Voluntary non-profit - Private FALSE 33.9325370 -86.4930590 0   9 1 1009 13820 Birmingham-Hoover-Talladega, AL Outlying Blount County https://data.medicare.gov/resource/xubh-q36u/row-nhvc-v4py.tnm6 11305 659402 2019-11-22 2019-06-30 19 6         25               25
940 940 CHOCTAW GENERAL HOSPITAL 401 VANITY FAIR LANE, PO BOX 618 BUTLER AL 36904 CHOCTAW (205) 459-9100 Critical Access Hospitals Voluntary non-profit - Private TRUE 32.0937419 -88.2095888 1 ROOFTOP 23 1 1023         https://data.medicare.gov/resource/xubh-q36u/row-cm2u-i8id~q257 11304 651161 2019-06-03 2018-12-31 25           25               25
2098 2098 RED BAY HOSPITAL 211 HOSPITAL ROAD RED BAY AL 35582 FRANKLIN (256) 356-9532 Critical Access Hospitals Government - Hospital District or Authority TRUE 34.4574250 -88.1469340 0   59 1 1059         https://data.medicare.gov/resource/xubh-q36u/row-4dsc.86rj~64k4 11302 644088 2019-02-25 2018-09-30 25           25               25
3413 3413 TANNER MEDICAL CENTER-EAST ALABAMA 1032 MAIN STREET SOUTH WEDOWEE AL 36278 RANDOLPH (256) 357-2111 Critical Access Hospitals Government - Hospital District or Authority TRUE 33.2966660 -85.4800280 0   111 1 1111         https://data.medicare.gov/resource/xubh-q36u/row-beeg-xgp7.fjvj 11306 659914 2019-11-27 2019-06-30 15           15               15
3782 3782 WASHINGTON COUNTY HOSPITAL 14600 ST. STEPHENS AVENUE CHATOM AL 36518 WASHINGTON (251) 847-2223 Critical Access Hospitals Government - Hospital District or Authority TRUE 31.4602960 -88.2352910 0   129 1 1129         https://data.medicare.gov/resource/xubh-q36u/row-kzeh_fuyx-rvjh 11300 644204 2019-03-01 2018-09-30 15           15       88       103
2424 2424 KANAKANAK HOSPITAL P O BOX 130 DILLINGHAM AK 99576 DILLINGHAM (907) 842-5201 Critical Access Hospitals Voluntary non-profit - Private TRUE 59.0397222 -158.4575000 1 GEOMETRIC_CENTER 70 2 2070         https://data.medicare.gov/resource/xubh-q36u/row-j4d4-bz29~h79d 21309 646376 2019-03-28 2018-09-30 18           18               18
3667 3667 SOUTH PENINSULA HOSPITAL 4300 BARTLETT ST HOMER AK 99603 KENAI PENINSULA (907) 235-8101 Critical Access Hospitals Voluntary non-profit - Private TRUE 59.6521330 -151.5502960 0   122 2 2122         https://data.medicare.gov/resource/xubh-q36u/row-cng5-kv9j-dmyn 21313 659751 2019-11-25 2019-06-30 21           21       28       49
3669 3669 PROVIDENCE SEWARD HOSPITAL 417 FIRST AVENUE, PO BOX 365 SEWARD AK 99664 KENAI PENINSULA (907) 224-5205 Critical Access Hospitals Government - Local TRUE 60.1050460 -149.4453830 0   122 2 2122         https://data.medicare.gov/resource/xubh-q36u/row-bjag~4kwr.8ihd 21302 652058 2019-05-30 2018-12-31 6           6       40       46
3797 3797 KETCHIKAN MEDICAL CENTER 3100 TONGASS AVENUE KETCHIKAN AK 99901 KETCHIKAN GATEWAY (907) 225-5171 Critical Access Hospitals Voluntary non-profit - Church TRUE 55.3527170 -131.6860490 0   130 2 2130 28540   Central Ketchikan Gateway Borough https://data.medicare.gov/resource/xubh-q36u/row-qt33-ugsf~ggm9 21311 661277 2019-12-03 2019-06-30 21 4         25       29       54
4028 4028 PROVIDENCE KODIAK ISLAND MEDICAL CTR 1915 EAST REZANOF DRIVE KODIAK AK 99615 KODIAK ISLAND BOROUGH (907) 486-9592 Critical Access Hospitals Voluntary non-profit - Church TRUE 57.8008350 -152.3739430 0   150 2 2150         https://data.medicare.gov/resource/xubh-q36u/row-3uhe-ufvn.rmdi 21306 652059 2019-05-30 2018-12-31 24           24       22       46
4294 4294 NORTON SOUND REGIONAL HOSPITAL 1000 GREG KRUSCHEK AVENUE (P O BOX 966) NOME AK 99762 NOME (907) 443-3311 Critical Access Hospitals Tribal TRUE 64.4992304 -165.3784042 1 ROOFTOP 180 2 2180         https://data.medicare.gov/resource/xubh-q36u/row-2xs3~z9eg.fia9 21308 646669 2019-04-15 2018-09-30 18           18       18       36
4321 4321 SAMUEL SIMMONDS MEMORIAL HOSPITAL 7000 UULA ST BARROW AK 99723 NORTH SLOPE BOROUH (907) 852-4611 Critical Access Hospitals Government - Federal TRUE 71.2981350 -156.7273200 0   185 2 2185         https://data.medicare.gov/resource/xubh-q36u/row-5czr-fghi_bwfa 21312 646058 2019-03-29 2018-09-30 20           20               20
4344 4344 MANIILAQ HEALTH CENTER PO BOX 43 KOTZEBUE AK 99752 NORTHWEST ARTIC BOROUGH (907) 442-3321 Critical Access Hospitals Tribal TRUE 66.8961387 -162.5868698 1 ROOFTOP 188 2 2188         https://data.medicare.gov/resource/xubh-q36u/row-5pbr_yrqg~qkzd 21310 646530 2019-03-29 2018-09-30 17           17               17
4375 4375 PETERSBURG MEDICAL CENTER PO BOX 589 PETERSBURG AK 99833 PETERSBURG BOROUGH (907) 772-4291 Critical Access Hospitals Government - Local TRUE 56.8128691 -132.9554619 1 ROOFTOP 195 2 2195         https://data.medicare.gov/resource/xubh-q36u/row-ky7y_b72j_698p 21304 660160 2019-12-02 2019-06-30 12           12       15       27
4484 4484 SITKA COMMUNITY HOSPITAL 209 MOLLER DRIVE SITKA AK 99835 SITKA BOROUGH (907) 747-3241 Critical Access Hospitals Government - Local TRUE 57.0589920 -135.3459290 0   220 2 2220         https://data.medicare.gov/resource/xubh-q36u/row-asew~ba2y_nt2p 21303 638783 2018-12-03 2018-06-30 12           12       15       27
4485 4485 MT EDGECUMBE HOSPITAL 222 TONGASS DR SITKA AK 99835 SITKA BOROUGH (907) 966-2411 Critical Access Hospitals Voluntary non-profit - Private TRUE 57.0520100 -135.3563530 0   220 2 2220         https://data.medicare.gov/resource/xubh-q36u/row-rbyg_8vzk~9w5v 21314 646531 2019-03-29 2018-09-30 25           25               25
4529 4529 PROVIDENCE VALDEZ MEDICAL CENTER PO BOX 550 VALDEZ AK 99686 VALDEZ-CORDOVA (907) 835-2249 Critical Access Hospitals Government - Local TRUE 61.1364781 -146.3458866 1 ROOFTOP 261 2 2261         https://data.medicare.gov/resource/xubh-q36u/row-2ygw.872k~d2en 21301 652057 2019-05-30 2018-12-31 11           11       10       21
4530 4530 CORDOVA COMMUNITY MEDICAL CENTER PO BOX 160 - 602 CHASE AVENUE CORDOVA AK 99574 VALDEZ-CORDOVA (907) 424-8000 Critical Access Hospitals Government - Local TRUE 60.5413354 -145.7505310 1 ROOFTOP 261 2 2261         https://data.medicare.gov/resource/xubh-q36u/row-kscp_6dza~rvey 21307 650633 2019-05-30 2018-12-31 13           13       10       23
4536 4536 SEARHC WRANGELL MEDICAL CENTER-CAH 310 BENNETT STREET PO BOX 1081 WRANGELL AK 99929 WRANGELL CITY AND BOROUGH (907) 874-7000 Critical Access Hospitals Government - Local FALSE 56.4716460 -132.3764140 0   275 2 2275         https://data.medicare.gov/resource/xubh-q36u/row-n33k~as59_upeg 21305 645317 2019-03-18 2018-10-31 8           8       14       22
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
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
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
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
546 546 PARKER INDIAN HEALTH CENTER 12033 AGENCY ROAD PARKER AZ 85344 LAPAZ (928) 669-2137 Critical Access Hospitals Government - Federal TRUE 34.1464940 -114.3013140 0   12 4 4012         https://data.medicare.gov/resource/xubh-q36u/row-942m-hgdi~yjfy 31307 645964 2019-04-01 2018-09-30 20           20               20
547 547 LA PAZ REGIONAL HOSPITAL 1200 WEST MOHAVE ROAD PARKER AZ 85344 LAPAZ (928) 669-9201 Critical Access Hospitals Voluntary non-profit - Private TRUE 34.1351370 -114.2855970 0   12 4 4012         https://data.medicare.gov/resource/xubh-q36u/row-sg3z_d8n6.kjbm 31317 643569 2019-02-25 2018-09-30 22 3         25               25
573 573 WICKENBURG COMMUNITY HOSPITAL 520 ROSE LANE WICKENBURG AZ 85390 MARICOPA (928) 684-5421 Critical Access Hospitals Voluntary non-profit - Private TRUE 33.9780560 -112.7388250 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-mqi4.ug34.a4ib 31300 649069 2019-06-03 2018-12-31 19           19               19
721 721 LITTLE COLORADO MEDICAL CENTER 1501 NORTH WILLIAMSON AVENUE WINSLOW AZ 86047 NAVAJO (928) 289-4691 Critical Access Hospitals Voluntary non-profit - Private TRUE 35.0354550 -110.6917420 0   17 4 4017 43320   Central Navajo County https://data.medicare.gov/resource/xubh-q36u/row-wt4g_v5ea_tink 31311 643756 2019-02-27 2018-09-30 25           25               25
724 724 HOPI HEALTH CARE CENTER HIGHWAY 264, MILEPOST 388 POLACCA AZ 86042 NAVAJO (928) 737-6000 Critical Access Hospitals Tribal FALSE 35.8022226 -110.4260281 1 GEOMETRIC_CENTER 17 4 4017 43320   Central Navajo County https://data.medicare.gov/resource/xubh-q36u/row-6zw9_3xdm~7vqp 31305 646377 2019-03-28 2018-09-30 6           6               6
878 878 HUHU KAM MEMORIAL HOSPITAL 483 WEST SEED FARM ROAD SACATON AZ 85147 PINAL (520) 562-3321 Critical Access Hospitals Government - Federal TRUE 33.0741220 -111.7590800 0   21 4 4021 38060   Central Pinal County https://data.medicare.gov/resource/xubh-q36u/row-fpem.7xy6-nzbf 31308 645965 2019-03-28 2018-09-30 12           12               12
941 941 HOLY CROSS HOSPITAL 1171 WEST TARGET RANGE ROAD NOGALES AZ 85621 SANTA CRUZ (520) 285-3000 Critical Access Hospitals Proprietary TRUE 31.3411180 -110.9587340 0   23 4 4023 35700 Tucson-Nogales, AZ Central Santa Cruz County https://data.medicare.gov/resource/xubh-q36u/row-datt~k3n6_g682 31313 644092 2019-02-28 2018-09-30 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
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
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
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
481 481 BRADLEY COUNTY MEDICAL CENTER 404 SOUTH BRADLEY STREET WARREN AR 71671 BRADLEY (870) 226-3731 Critical Access Hospitals Voluntary non-profit - Private TRUE 33.6105380 -92.0586650 0   11 5 5011         https://data.medicare.gov/resource/xubh-q36u/row-ga7d-t3u8~gykp 41327 644212 2019-03-04 2018-09-30 25           25 10             35
672 672 MERCY HOSPITAL BERRYVILLE 214 CARTER STREET BERRYVILLE AR 72616 CARROLL (870) 423-3355 Critical Access Hospitals Voluntary non-profit - Church TRUE 36.3582250 -93.5519930 0   15 5 5015         https://data.medicare.gov/resource/xubh-q36u/row-dj6g_rn37~rqpp 41329 659917 2019-12-04 2019-06-30 25           25               25
673 673 EUREKA SPRINGS HOSPITAL, LLC 24 NORRIS STREET EUREKA SPRINGS AR 72632 CARROLL (479) 253-7400 Critical Access Hospitals Proprietary TRUE 36.4004330 -93.7446990 0   15 5 5015         https://data.medicare.gov/resource/xubh-q36u/row-fpuw-vbap-fsdb 41304 647643 2019-05-14 2018-12-31 15           15               15
725 725 CHICOT MEMORIAL MEDICAL CENTER 2729 SOUTH HIGHWAY 65 & 82 LAKE VILLAGE AR 71653 CHICOT (870) 265-5351 Critical Access Hospitals Voluntary non-profit - Private TRUE 33.3056420 -91.2903530 0   17 5 5017         https://data.medicare.gov/resource/xubh-q36u/row-n4n3~4tmq_i4ky 41328 660163 2019-11-22 2019-03-31 25           25               25
809 809 BAPTIST HEALTH MEDICAL CENTER-ARKADELPHIA 3050 TWIN RIVERS DRIVE ARKADELPHIA AR 71923 CLARK (870) 245-2622 Critical Access Hospitals Voluntary non-profit - Private TRUE 34.1228020 -93.0879700 0   19 5 5019 11660   Central Clark County https://data.medicare.gov/resource/xubh-q36u/row-f8ss.59v5_rxma 41321 649536 2019-05-31 2018-12-31 25           25               25
882 882 PIGGOTT COMMUNITY HOSPITAL 216 EAST MAIN STREET PIGGOTT AR 72454 CLAY (870) 598-3881 Critical Access Hospitals Government - Local TRUE 36.3820190 -90.1884430 0   21 5 5021         https://data.medicare.gov/resource/xubh-q36u/row-73yu_ywme-uu8m 41330 649163 2019-06-03 2018-12-31 25           25               25
942 942 BAPTIST HEALTH MEDICAL CENTER HEBER SPINGS 1800 BYPASS ROAD HEBER SPRINGS AR 72543 CLEBURNE (501) 887-3000 Critical Access Hospitals Voluntary non-profit - Private TRUE 35.5065780 -92.0013190 0   23 5 5023         https://data.medicare.gov/resource/xubh-q36u/row-d26c_x5yu_6fn3 41312 651551 2019-05-31 2018-12-31 25           25               25
1122 1122 CHI ST VINCENT MORRILTON #4 HOSPITAL DRIVE MORRILTON AR 72110 CONWAY (501) 977-2300 Critical Access Hospitals Voluntary non-profit - Church TRUE 35.1699700 -92.7217020 0   29 5 5029         https://data.medicare.gov/resource/xubh-q36u/row-jajp~f47n.nife 41324 660162 2019-12-02 2019-06-30 25           25               25
1581 1581 DALLAS COUNTY MEDICAL CENTER 201 CLIFTON STREET FORDYCE AR 71742 DALLAS (870) 352-6300 Critical Access Hospitals Government - Local TRUE 33.8111580 -92.4250580 0   39 5 5039         https://data.medicare.gov/resource/xubh-q36u/row-vfqi-mtmw~p9xt 41317 646016 2019-04-01 2018-12-31 22           22               22
1632 1632 DELTA MEMORIAL HOSPITAL 811 HIGHWAY 65 SOUTH DUMAS AR 71639 DESHA (870) 382-4303 Critical Access Hospitals Voluntary non-profit - Private TRUE 33.8732940 -91.4815000 0   41 5 5041         https://data.medicare.gov/resource/xubh-q36u/row-65hi_7cx4-4bx3 41326 659558 2019-11-22 2019-06-30 25           25               25
1633 1633 MCGEHEE HOSPITAL 900 SOUTH THIRD STREET MCGEHEE AR 71654 DESHA (870) 222-5600 Critical Access Hospitals Voluntary non-profit - Private TRUE 33.6182850 -91.3930660 0   41 5 5041         https://data.medicare.gov/resource/xubh-q36u/row-nhnf~w2ph~7zeh 41308 662151 2019-12-12 2019-06-30 25           25               25
1773 1773 MERCY HOSPITAL TURNER MEMORIAL 801 WEST RIVER STREET OZARK AR 72949 FRANKLIN (479) 667-4138 Critical Access Hospitals Voluntary non-profit - Private TRUE 35.4861180 -93.8338050 0   47 5 5047         https://data.medicare.gov/resource/xubh-q36u/row-ztbc-aceq_xeqj 41303 660745 2019-12-04 2019-06-30 25           25               25
1827 1827 FULTON COUNTY HOSPITAL 679 NORTH MAIN STREET SALEM AR 72576 FULTON (870) 895-2691 Critical Access Hospitals Voluntary non-profit - Other TRUE 36.3833590 -91.8112030 0   49 5 5049         https://data.medicare.gov/resource/xubh-q36u/row-9b6n-wd2m.b7tm 41322 660913 2019-12-02 2019-06-30 25           25               25
2176 2176 HOWARD MEMORIAL HOSPITAL 130 MEDICAL CIRCLE NASHVILLE AR 71852 HOWARD (870) 845-4400 Critical Access Hospitals Voluntary non-profit - Private TRUE 33.9509260 -93.8807720 0   61 5 5061         https://data.medicare.gov/resource/xubh-q36u/row-943b-exqy.j5es 41311 643866 2019-03-01 2018-09-30 25           25               25
2261 2261 IZARD COUNTY MEDICAL CENTER, LLC 61 GRASSE STREET CALICO ROCK AR 72519 BAXTER (870) 297-2400 Critical Access Hospitals Proprietary TRUE 36.1263360 -92.1285870 0   65 5 5065         https://data.medicare.gov/resource/xubh-q36u/row-nm2c~hstr_uanu 41306 662150 2019-12-06 2019-06-30 25           25               25
2555 2555 LAWRENCE MEMORIAL HOSPITAL 1309 WEST MAIN STREET WALNUT RIDGE AR 72476 LAWRENCE (870) 886-1200 Critical Access Hospitals Government - Local TRUE 36.0747010 -90.9669820 0   75 5 5075         https://data.medicare.gov/resource/xubh-q36u/row-jpmn_3ec8~urk8 41309 661136 2019-12-03 2019-06-30 25           25               25
2680 2680 LITTLE RIVER MEMORIAL HOSPITAL 451 WEST LOCKE STREET ASHDOWN AR 71822 LITTLE RIVER (870) 898-5011 Critical Access Hospitals Voluntary non-profit - Private TRUE 33.6695720 -94.1350250 0   81 5 5081 45500   Outlying Little River County https://data.medicare.gov/resource/xubh-q36u/row-r8e3~m3nn~24fp 41320 658650 2019-11-12 2019-06-30 25           25               25
2733 2733 MERCY HOSPITAL BOONEVILLE 880 WEST MAIN BOONEVILLE AR 72927 LOGAN (479) 675-2800 Critical Access Hospitals Voluntary non-profit - Private TRUE 35.1409790 -93.9347030 0   83 5 5083         https://data.medicare.gov/resource/xubh-q36u/row-jff3_g33y~pc8b 41318 662152 2019-12-04 2019-06-30 24           24               24
2734 2734 NORTH LOGAN MERCY HOSPITAL 500 EAST ACADEMY PARIS AR 72855 LOGAN (479) 963-6101 Critical Access Hospitals Voluntary non-profit - Church TRUE 35.2899880 -93.7254190 0   83 5 5083         https://data.medicare.gov/resource/xubh-q36u/row-6tgs-f8yk-urcu 41300 660744 2019-12-04 2019-06-30 16           16               16
2988 2988 SOUTH MISSISSISSPI COUNTY REGIONAL MEDICAL CENTER 611 WEST LEE AVENUE OSCEOLA AR 72370 MISSISSIPPI (870) 563-7000 Critical Access Hospitals Government - Local TRUE 35.7002490 -89.9749300 0   93 5 5093 14180   Central Mississippi County https://data.medicare.gov/resource/xubh-q36u/row-q7uu-6ehf~4s6v 41316 650798 2019-06-05 2018-12-31 25           25               25
3601 3601 MERCY HOSPITAL WALDRON 1341 WEST SIXTH STREET WALDRON AR 72958 SCOTT (479) 637-4135 Critical Access Hospitals Voluntary non-profit - Private TRUE 34.8967850 -94.1060780 0   127 5 5127         https://data.medicare.gov/resource/xubh-q36u/row-hh5p.qtqy-xetd 41305 662149 2019-12-04 2019-06-30 24           24               24
3867 3867 STONE COUNTY MEDICAL CENTER 2106 EAST MAIN STREET MOUNTAIN VIEW AR 72560 STONE (870) 269-4361 Critical Access Hospitals Voluntary non-profit - Private TRUE 35.8555980 -92.0827270 0   137 5 5137         https://data.medicare.gov/resource/xubh-q36u/row-si2m~smq2~k85s 41310 654085 2019-08-30 2018-09-30 25           25               25
3910 3910 OZARK HEALTH 2500 HIGHWAY 65 SOUTH CLINTON AR 72031 VAN BUREN (501) 745-7000 Critical Access Hospitals Voluntary non-profit - Private TRUE 35.5593750 -92.4499130 0   141 5 5141         https://data.medicare.gov/resource/xubh-q36u/row-3ppd-9bg7~xqjh 41313 661137 2019-12-02 2019-06-30 25           25       118       143
4011 4011 DARDANELLE HOSPITAL 200 NORTH THIRD STREET DARDANELLE AR 72834 YELL (479) 229-4677 Critical Access Hospitals Proprietary TRUE 35.2209170 -93.1569870 0   149 5 5149 40780   Outlying Yell County https://data.medicare.gov/resource/xubh-q36u/row-u9x6_diim.h7v6 41302 639835 2018-12-26 2018-06-30 25           25 10             35
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
406 406 MARK TWAIN MEDICAL CENTER 768 MOUNTAIN RANCH RD SAN ANDREAS CA 95249 CALAVERAS (209) 754-2515 Critical Access Hospitals Voluntary non-profit - Other FALSE 38.1909730 -120.6706610 0   9 6 6009         https://data.medicare.gov/resource/xubh-q36u/row-vzvr.d5an~vpec 51332 660493 2019-12-03 2019-06-30 25           25               25
883 883 GLENN MEDICAL CENTER 1133 W SYCAMORE ST WILLOWS CA 95988 GLENN (530) 934-1818 Critical Access Hospitals Government - Federal TRUE 39.5204670 -122.2081200 0   21 6 6021         https://data.medicare.gov/resource/xubh-q36u/row-7nst_26uq.zcvx 51306 662484 2019-12-03 2019-06-30 15           15               15
945 945 REDWOOD MEMORIAL HOSPITAL 3300 RENNER DRIVE FORTUNA CA 95540 HUMBOLDT (707) 445-8121 Critical Access Hospitals Voluntary non-profit - Private TRUE 40.5830710 -124.1359420 0   23 6 6023 21700   Central Humboldt County https://data.medicare.gov/resource/xubh-q36u/row-npjr_8pdg.y2ky 51318 662486 2019-11-27 2019-06-30 21 4         25               25
946 946 JEROLD PHELPS COMMUNITY HOSPITAL 733 CEDAR ST GARBERVILLE CA 95542 HUMBOLDT (707) 923-3921 Critical Access Hospitals Government - Hospital District or Authority TRUE 40.1014910 -123.7927560 0   23 6 6023 21700   Central Humboldt County https://data.medicare.gov/resource/xubh-q36u/row-xasy~ndp2-8fte 51309 662173 2019-11-29 2019-06-30 9           9       8       17
1061 1061 NORTHERN INYO HOSPITAL 150 PIONEER LANE BISHOP CA 93514 INYO (760) 873-5811 Critical Access Hospitals Government - Hospital District or Authority TRUE 37.3621080 -118.4073620 0   27 6 6027         https://data.medicare.gov/resource/xubh-q36u/row-mi4n-bdvc~nrpd 51324 661291 2019-12-02 2019-06-30 21 4         25               25
1062 1062 SOUTHERN INYO HOSPITAL 501 EAST LOCUST STREET LONE PINE CA 93545 INYO (760) 876-5501 Critical Access Hospitals Government - Hospital District or Authority TRUE 36.6083740 -118.0581590 0   27 6 6027         https://data.medicare.gov/resource/xubh-q36u/row-wcp4_jkw5.du53 51302 659919 2019-12-02 2019-06-30 4           4       33       37
1126 1126 ADVENTIST HEALTH TEHACHAPI VALLEY 1100 MAGELLAN TEHACHAPI CA 93561 KERN (661) 823-3000 Critical Access Hospitals Government - Hospital District or Authority TRUE 35.1474419 -118.4504364 1 ROOFTOP 29 6 6029 12540   Central Kern County https://data.medicare.gov/resource/xubh-q36u/row-xx6n.a25c~74jx 51301 648598 2019-05-31 2018-12-31 16 4         20               20
1131 1131 KERN VALLEY HEALTHCARE DISTRICT 6412 LAUREL AVE LAKE ISABELLA CA 93240 KERN (760) 379-2681 Critical Access Hospitals Government - Hospital District or Authority TRUE 35.6353510 -118.4063000 0   29 6 6029 12540   Central Kern County https://data.medicare.gov/resource/xubh-q36u/row-vmmb-dmgx.ncbv 51314 652738 2018-12-04 2018-06-30 24           24       74       98
1132 1132 RIDGECREST REGIONAL HOSPITAL 1081 NORTH CHINA LAKE BLVD RIDGECREST CA 93555 KERN (760) 446-3551 Critical Access Hospitals Voluntary non-profit - Private TRUE 35.6408020 -117.6698520 0   29 6 6029 12540   Central Kern County https://data.medicare.gov/resource/xubh-q36u/row-mt9h~9st4_p9qd 51333 651187 2019-06-07 2018-12-31 21 4         25       125       150
1313 1313 SUTTER LAKESIDE HOSPITAL 5176 HILL ROAD EAST LAKEPORT CA 95453 LAKE (707) 262-5000 Critical Access Hospitals Voluntary non-profit - Private TRUE 39.1051750 -122.9082380 0   33 6 6033 17340   Central Lake County https://data.medicare.gov/resource/xubh-q36u/row-eiws_bxxs~n9dn 51329 650960 2019-06-03 2018-12-31 21 4         25               25
1314 1314 ADVENTIST HEALTH CLEARLAKE 15630 18TH AVE - HWY 53 CLEARLAKE CA 95422 LAKE (707) 994-6486 Critical Access Hospitals Voluntary non-profit - Church TRUE 38.9353458 -122.6200816 1 ROOFTOP 33 6 6033 17340   Central Lake County https://data.medicare.gov/resource/xubh-q36u/row-hud3~fp2e-cmcb 51317 648600 2019-05-31 2018-12-31 21 4         25               25
1379 1379 BANNER LASSEN MEDICAL CENTER 1800 SPRING RIDGE DRIVE SUSANVILLE CA 96130 LASSEN (530) 252-2000 Critical Access Hospitals Voluntary non-profit - Private TRUE 40.4381970 -120.6274290 0   35 6 6035 45000   Central Lassen County https://data.medicare.gov/resource/xubh-q36u/row-9588_vk9p.tkgv 51320 654664 2019-09-18 2018-12-31 25           25               25
1468 1468 CATALINA ISLAND MEDICAL CENTER 100 FALLS CANYON ROAD AVALON CA 90704 LOS ANGELES (310) 510-0700 Critical Access Hospitals Voluntary non-profit - Private TRUE 33.3390790 -118.3304770 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-8vi9~ashp_y9rx 51307 638364 2018-11-29 2018-06-30 8           8       4       12
1682 1682 JOHN C FREMONT HEALTHCARE DISTRICT 5189 HOSPITAL ROAD MARIPOSA CA 95338 MARIPOSA (209) 966-3631 Critical Access Hospitals Government - Hospital District or Authority TRUE 37.5005310 -119.9769480 0   43 6 6043         https://data.medicare.gov/resource/xubh-q36u/row-fty8~tgqe.f5tj 51304 661465 2019-12-02 2019-06-30 18           18       16   1   35
1723 1723 ADVENTIST HEALTH HOWARD MEMORIAL 1 MARCELA DR WILLITS CA 95490 MENDOCINO (707) 456-3031 Critical Access Hospitals Voluntary non-profit - Church TRUE 39.3897770 -123.3399710 0   45 6 6045 46380   Central Mendocino County https://data.medicare.gov/resource/xubh-q36u/row-ecr7.pfkq_ummb 51310 648599 2019-05-29 2018-12-31 21 4         25               25
1725 1725 MENDOCINO COAST DISTRICT HOSPITAL 700 RIVER DR FORT BRAGG CA 95437 MENDOCINO (707) 961-1234 Critical Access Hospitals Government - Hospital District or Authority TRUE 39.4326130 -123.8007970 0   45 6 6045 46380   Central Mendocino County https://data.medicare.gov/resource/xubh-q36u/row-rw6t.w3x2~jyq9 51325 661292 2019-12-02 2019-06-30 21 4         25               25
1828 1828 MODOC MEDICAL CENTER 228 W MCDOWELL AVE ALTURAS CA 96101 MODOC (530) 233-5131 Critical Access Hospitals Government - Hospital District or Authority TRUE 41.4799490 -120.5455030 0   49 6 6049         https://data.medicare.gov/resource/xubh-q36u/row-kyq6~7b5b.wgww 51330 662175 2019-11-27 2019-06-30 16           16       71       87
1829 1829 SURPRISE VALLEY COMMUNITY HOSPITAL 741 NORTH MAIN STREET CEDARVILLE CA 96104 MODOC (530) 279-6111 Critical Access Hospitals Government - Local TRUE 41.5319310 -120.1718990 0   49 6 6049         https://data.medicare.gov/resource/xubh-q36u/row-cdww_rq6r_6v4q 51308 662485 2019-12-23 2019-06-30 4           4       22       26
1891 1891 MAMMOTH HOSPITAL 85 SIERRA PARK ROAD PO BOX 660 MAMMOTH LAKES CA 93546 MONO (760) 934-3311 Critical Access Hospitals Government - Hospital District or Authority TRUE 37.6450710 -118.9639110 0   51 6 6051         https://data.medicare.gov/resource/xubh-q36u/row-rfxr_qrfx~jtdt 51303 659023 2019-11-19 2019-06-30 15 2         17               17
2048 2048 TAHOE FOREST HOSPITAL 10121 PINE AVE TRUCKEE CA 96161 NEVADA (530) 587-6011 Critical Access Hospitals Government - Hospital District or Authority TRUE 39.3251630 -120.2013440 0   57 6 6057 46020 Sacramento-Roseville, CA Central Nevada County https://data.medicare.gov/resource/xubh-q36u/row-n6zm-373j_a9uq 51328 661144 2019-11-27 2019-06-30 19 6         25       37       62
2221 2221 EASTERN PLUMAS HOSPITAL - PORTOLA CAMPUS 500 FIRST AVENUE PORTOLA CA 96122 PLUMAS (530) 832-4277 Critical Access Hospitals Government - Hospital District or Authority TRUE 39.8061440 -120.4631290 0   63 6 6063         https://data.medicare.gov/resource/xubh-q36u/row-4uid-vtd8_6vsi 51300 662171 2019-11-27 2019-06-30 9           9       66       75
2240 2240 SENECA DISTRICT HOSPITAL 130 BRENTWOOD DRIVE CHESTER CA 96020 PLUMAS (530) 258-2121 Critical Access Hospitals Voluntary non-profit - Other TRUE 40.3053020 -121.2340180 0   63 6 6063         https://data.medicare.gov/resource/xubh-q36u/row-6rw5.c6e6.9puv 51327 661143 2019-12-02 2019-06-30 10           10       16       26
2241 2241 PLUMAS DISTRICT HOSPITAL 1065 BUCKS LAKE ROAD QUINCY CA 95971 PLUMAS (530) 283-2121 Critical Access Hospitals Government - Hospital District or Authority TRUE 39.9347670 -120.9192510 0   63 6 6063         https://data.medicare.gov/resource/xubh-q36u/row-k6tt~sk6g~887z 51326 640492 2018-12-13 2018-06-30 23           23               23
2430 2430 BEAR VALLEY COMMUNITY HOSPITAL 41870 GARSTIN DR BIG BEAR LAKE CA 92315 SAN BERNARDINO (909) 866-6501 Critical Access Hospitals Government - Hospital District or Authority FALSE 34.2460230 -116.8883430 0   71 6 6071 40140 Los Angeles-Long Beach, CA Central San Bernardino County https://data.medicare.gov/resource/xubh-q36u/row-4ruv_6zyd-x27y 51335 662176 2019-11-27 2019-06-30 9           9       21       30
2434 2434 MOUNTAINS COMMUNITY HOSPITAL 29101 HOSPITAL ROAD LAKE ARROWHEAD CA 92352 SAN BERNARDINO (909) 336-3651 Critical Access Hospitals Government - Hospital District or Authority TRUE 34.2659000 -117.1670920 0   71 6 6071 40140 Los Angeles-Long Beach, CA Central San Bernardino County https://data.medicare.gov/resource/xubh-q36u/row-z5bb_6v2j.847b 51312 659479 2019-01-07 2018-06-30 17           17       20       37
2438 2438 COLORADO RIVER MEDICAL CENTER 1401 BAILEY AVE NEEDLES CA 92363 SAN BERNARDINO (760) 326-4531 Critical Access Hospitals Voluntary non-profit - Private TRUE 34.8328360 -114.6183170 0   71 6 6071 40140 Los Angeles-Long Beach, CA Central San Bernardino County https://data.medicare.gov/resource/xubh-q36u/row-zxst-kiy5_rq6g 51323 646252 2019-04-08 2018-12-31 25           25               25
2736 2736 SANTA YNEZ VALLEY COTTAGE HOSPITAL 2050 VIBORG RD SOLVANG CA 93463 SANTA BARBARA (805) 688-6431 Critical Access Hospitals Voluntary non-profit - Private TRUE 34.6024650 -120.1266430 0   83 6 6083 42200   Central Santa Barbara County https://data.medicare.gov/resource/xubh-q36u/row-crjd-giis~8ixz 51331 648601 2019-05-31 2018-12-31 11           11               11
2881 2881 MAYERS MEMORIAL HOSPITAL 43563 HWY 299 EAST FALL RIVER MILLS CA 96028 SHASTA (530) 336-5511 Critical Access Hospitals Voluntary non-profit - Other TRUE 41.0239680 -121.4246510 0   89 6 6089 39820 Redding-Red Bluff, CA Central Shasta County https://data.medicare.gov/resource/xubh-q36u/row-fpxd_qi9h_6mni 51305 662172 2019-11-29 2019-06-30 22           22       99       121
2989 2989 MERCY MEDICAL CENTER MT SHASTA 914 PINE STREET MOUNT SHASTA CA 96067 SISKIYOU (530) 926-6111 Critical Access Hospitals Voluntary non-profit - Other TRUE 41.3177640 -122.3215540 0   93 6 6093         https://data.medicare.gov/resource/xubh-q36u/row-z3p6.8j4z_mz6s 51319 662174 2019-12-03 2019-06-30 21 4         25               25
2990 2990 FAIRCHILD MEDICAL CENTER 444 BRUCE STREET YREKA CA 96097 SISKIYOU (530) 842-4121 Critical Access Hospitals Voluntary non-profit - Other TRUE 41.7185790 -122.6454570 0   93 6 6093         https://data.medicare.gov/resource/xubh-q36u/row-wj65.hzqw~ibav 51316 659220 2019-05-28 2018-12-31 21 4         25               25
3084 3084 HEALDSBURG DISTRICT HOSPITAL 1375 UNIVERSITY AVENUE HEALDSBURG CA 95448 SONOMA (707) 431-6500 Critical Access Hospitals Government - Hospital District or Authority TRUE 38.6265830 -122.8637410 0   97 6 6097 42220 San Jose-San Francisco-Oakland, CA Central Sonoma County https://data.medicare.gov/resource/xubh-q36u/row-4sdp_xbwc~jgwt 51321 650239 2019-05-29 2018-12-31 21 4         25       17       42
3297 3297 TRINITY HOSPITAL 60 EASTER AVENUE WEAVERVILLE CA 96093 TRINITY (530) 623-5541 Critical Access Hospitals Government - Hospital District or Authority TRUE 40.7375790 -122.9394440 0   105 6 6105         https://data.medicare.gov/resource/xubh-q36u/row-yq5n_hvzx.n2t3 51315 650664 2019-05-31 2018-12-31 25           25       23       48
3419 3419 OJAI VALLEY COMMUNITY HOSPITAL 1306 MARICOPA HWY OJAI CA 93023 VENTURA (805) 640-2280 Critical Access Hospitals Voluntary non-profit - Private TRUE 34.4422510 -119.2645180 0   111 6 6111 37100 Los Angeles-Long Beach, CA Central Ventura County https://data.medicare.gov/resource/xubh-q36u/row-a8a7~36ic~zamx 51334 658898 2019-11-07 2018-12-31 21 4         25       66       91
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
407 407 SOUTHEAST COLORADO HOSPITAL 373 E TENTH AVE SPRINGFIELD CO 81073 BACA (719) 523-4501 Critical Access Hospitals Government - Hospital District or Authority TRUE 37.4041650 -102.6124230 0   9 8 8009         https://data.medicare.gov/resource/xubh-q36u/row-ph53-yjae~upmw 61311 649711 2019-06-13 2018-12-31 15           15         56     71
675 675 HEART OF THE ROCKIES REGIONAL MEDICAL CENTER 1000 RUSH DR SALIDA CO 81201 CHAFFEE (719) 530-2200 Critical Access Hospitals Government - Hospital District or Authority TRUE 38.5431020 -106.0072910 0   15 8 8015         https://data.medicare.gov/resource/xubh-q36u/row-yr8v-xwgi_arj7 61322 649549 2019-05-29 2018-12-31 23 2         25               25
728 728 KEEFE MEMORIAL HOSPITAL 602 N 6TH W ST CHEYENNE WELLS CO 80810 CHEYENNE (719) 767-5661 Critical Access Hospitals Government - Hospital District or Authority TRUE 38.8258870 -102.3555830 0   17 8 8017         https://data.medicare.gov/resource/xubh-q36u/row-tagv~57dn~4tm7 61343 649879 2019-05-29 2018-12-31 11           11               11

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