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 hospital_name

✎ 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
1104 1104 (CLOSED) CUMBERLAND RIVER HOSPITAL 100 OLD JEFFERSON ST CELINA TN 38551 CLAY (931) 243-3581 Critical Access Hospitals Physician TRUE 36.5447360 -85.5011730 0   27 47 47027         https://data.medicare.gov/resource/xubh-q36u/row-ejr4.nfrj.jxid 441319 655653 2019-10-28 2019-03-01 25           25 8             33
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
3342 3342 ABRAHAM LINCOLN MEMORIAL HOSPITAL 200 STAHLHUT DRIVE LINCOLN IL 62656 LOGAN (217) 732-2161 Critical Access Hospitals Voluntary non-profit - Private TRUE 40.1523730 -89.3886980 0   107 17 17107 30660 Springfield-Jacksonville-Lincoln, IL Central Logan County https://data.medicare.gov/resource/xubh-q36u/row-m2j2_9ezc_vv3r 141322 643406 2019-02-25 2018-09-30 25           25               25
3471 3471 ABROM KAPLAN MEMORIAL HOSPITAL 1310 WEST SEVENTH STREET KAPLAN LA 70548 VERMILION (337) 643-8300 Critical Access Hospitals Voluntary non-profit - Private TRUE 30.0075910 -92.2973370 0   113 22 22113 29180 Lafayette-Opelousas-Morgan City, LA Outlying Vermilion Parish https://data.medicare.gov/resource/xubh-q36u/row-hk2u-qsne-eka8 191322 643895 2019-03-01 2018-09-30 25           25 10             35
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
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
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
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
3816 3816 ADENA PIKE MEDICAL CENTER 100 DAWN LANE WAVERLY OH 45690 PIKE (740) 947-2186 Critical Access Hospitals Voluntary non-profit - Private TRUE 39.1165050 -83.0058270 0   131 39 39131         https://data.medicare.gov/resource/xubh-q36u/row-zm47~vagh-p87t 361334 649331 2019-05-31 2018-12-31 25           25               25
2982 2982 ADVENTHEALTH DURAND 1220 3RD AVE W DURAND WI 54736 PEPIN (715) 672-4211 Critical Access Hospitals Voluntary non-profit - Church TRUE 44.6203090 -91.9635000 0   91 55 55091         https://data.medicare.gov/resource/xubh-q36u/row-qzeb.agub~nfph 521307 650794 2019-05-30 2018-12-31 25           25               25
4544 4544 ADVENTHEALTH ROLLINS BROOK 608 NORTH KEY AVENUE LAMPASAS TX 76550 LAMPASAS (512) 556-3682 Critical Access Hospitals Voluntary non-profit - Church TRUE 31.0723300 -98.1856440 0   281 48 48281 28660   Outlying Lampasas County https://data.medicare.gov/resource/xubh-q36u/row-9tad_9sfa.xgc8 451323 644374 2019-03-01 2018-09-30 25           25               25
1831 1831 ADVENTHEALTH WAUCHULA 735 S 5TH AVE WAUCHULA FL 33873 HARDEE (863) 773-0216 Critical Access Hospitals Voluntary non-profit - Private TRUE 27.5394213 -81.8072774 1 ROOFTOP 49 12 12049 48100   Central Hardee County https://data.medicare.gov/resource/xubh-q36u/row-ev8e.32dq-kwq8 101300 649888 2019-05-30 2018-12-31 25           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
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
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
2065 2065 ADVENTIST HEALTH TILLAMOOK 1000 THIRD STREET TILLAMOOK OR 97141 TILLAMOOK (503) 842-4444 Critical Access Hospitals Voluntary non-profit - Church TRUE 45.4563220 -123.8549510 0   57 41 41057         https://data.medicare.gov/resource/xubh-q36u/row-hny7~x5jj.a66t 381317 648758 2019-05-28 2018-12-31 21 4         25               25
4444 4444 ADVOCATE EUREKA HOSPITAL 101 S MAJOR ST EUREKA IL 61530 WOODFORD (309) 467-2371 Critical Access Hospitals Voluntary non-profit - Private TRUE 40.7214050 -89.2716610 0   203 17 17203 37900 Peoria-Canton, IL Central Woodford County https://data.medicare.gov/resource/xubh-q36u/row-4ygy~3sdv-kmqs 141309 649725 2019-05-30 2018-12-31 25           25               25
451 451 ALICE PECK DAY MEMORIAL HOSPITAL 10 ALICE PECK DAY DRIVE LEBANON NH 3766 GRAFTON (603) 448-3121 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.6402930 -72.2643660 0   9 33 33009 17200   Central Grafton County https://data.medicare.gov/resource/xubh-q36u/row-t8xb_fse9~ukfj 301305 661743 2019-12-03 2019-06-30 24           24               24
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
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
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
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
3065 3065 ALLIANCEHEALTH MADILL 901 S 5TH AVE MADILL OK 73446 MARSHALL (580) 795-3384 Critical Access Hospitals Proprietary TRUE 34.0817380 -96.7784500 0   95 40 40095         https://data.medicare.gov/resource/xubh-q36u/row-b6vq_dbi2_tjfb 371326 653270 2019-08-30 2019-03-31 21           21               21
3071 3071 AMERY HOSPITAL & CLINIC 265 GRIFFIN STREET EAST AMERY WI 54001 POLK (715) 268-0300 Critical Access Hospitals Voluntary non-profit - Private TRUE 45.2959460 -92.3606700 0   95 55 55095         https://data.medicare.gov/resource/xubh-q36u/row-nbii-jcut-5ka3 521308 649379 2019-05-24 2018-12-31 25           25 10             35
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
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
3479 3479 ANGEL MEDICAL CENTER 120 RIVERVIEW ST PO BOX 1209 FRANKLIN NC 28734 MACON (828) 524-8411 Critical Access Hospitals Voluntary non-profit - Private TRUE 35.1846340 -83.3776400 0   113 37 37113         https://data.medicare.gov/resource/xubh-q36u/row-7yi7_miqw_9mna 341326 645352 2019-03-01 2018-09-30 20 5         25               25
3950 3950 ANNIE JEFFREY MEMORIAL COUNTY HEALTH CENTER P O BOX 428, 531 BEEBE ST OSCEOLA NE 68651 POLK (402) 747-2031 Critical Access Hospitals Government - Local TRUE 41.1697878 -97.5490124 1 ROOFTOP 143 31 31143         https://data.medicare.gov/resource/xubh-q36u/row-tmyd~dpec-xnwq 281314 655636 2019-10-21 2019-06-30 16           16               16
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
4040 4040 APPLETON MUNICIPAL HOSPITAL 30 SOUTH BEHL STREET APPLETON MN 56208 SWIFT (320) 289-8508 Critical Access Hospitals Government - Local TRUE 45.1996580 -96.0092240 0   151 27 27151         https://data.medicare.gov/resource/xubh-q36u/row-egz5_fa7v_8upj 241341 656449 2019-10-21 2018-09-30 15           15       50       65
1677 1677 ARBOR HEALTH MORTON HOSPITAL 521 ADAMS STREET MORTON WA 98356 LEWIS (360) 496-5112 Critical Access Hospitals Government - Hospital District or Authority TRUE 46.5559530 -122.2798780 0   41 53 53041 16500 Seattle-Tacoma, WA Central Lewis County https://data.medicare.gov/resource/xubh-q36u/row-rfdw-ekhk~ca8x 501319 648508 2019-05-23 2018-12-31 25           25               25
3178 3178 ARBUCKLE MEMORIAL HOSPITAL AUTHORITY 2011 WEST BROADWAY SULPHUR OK 73086 MURRAY (580) 622-2161 Critical Access Hospitals Government - Local TRUE 34.5063330 -96.9960050 0   99 40 40099         https://data.medicare.gov/resource/xubh-q36u/row-k94n_jt84~krmu 371328 648757 2019-05-31 2018-12-31 25           25               25
2458 2458 ARH OUR LADY OF THE WAY 11203 MAIN STREET MARTIN KY 41649 FLOYD (606) 285-6400 Critical Access Hospitals Voluntary non-profit - Private TRUE 37.5791050 -82.7503510 0   71 21 21071         https://data.medicare.gov/resource/xubh-q36u/row-y85x_rrhk~w2dk 181305 660806 2019-11-27 2019-06-30 25           25               25
2884 2884 ARKANSAS VALLEY REGIONAL MEDICAL CENTER 1100 CARSON AVENUE LA JUNTA CO 81050 OTERO (719) 383-6000 Critical Access Hospitals Voluntary non-profit - Private TRUE 37.9769290 -103.5487420 0   89 8 8089         https://data.medicare.gov/resource/xubh-q36u/row-967u~ukgn_sq4q 61336 653832 2019-08-29 2019-03-31 16 506         522       30       552
1085 1085 ASCENSION BORGESS LEE HOSPITAL 420 W HIGH ST DOWAGIAC MI 49047 CASS (269) 782-8681 Critical Access Hospitals Voluntary non-profit - Church TRUE 41.9826650 -86.1154990 0   27 26 26027 43780 South Bend-Elkhart-Mishawaka, IN-MI Central Cass County https://data.medicare.gov/resource/xubh-q36u/row-vqdi~vtd4.ymdx 231315 661020 2019-11-29 2019-06-30 25           25               25
719 719 ASCENSION CALUMET HOSPITAL 614 MEMORIAL DRIVE CHILTON WI 53014 CALUMET (920) 849-2386 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.0254390 -88.1543990 0   15 55 55015 11540 Appleton-Oshkosh-Neenah, WI Central Calumet County https://data.medicare.gov/resource/xubh-q36u/row-q97p-97ns_bxut 521317 661447 2019-11-27 2019-06-30 25           25               25
3735 3735 ASCENSION EAGLE RIVER HOSPITAL 201 HOSPITAL ROAD EAGLE RIVER WI 54521 VILAS (715) 479-7411 Critical Access Hospitals Voluntary non-profit - Private TRUE 45.9275180 -89.2516780 0   125 55 55125         https://data.medicare.gov/resource/xubh-q36u/row-unpa.6ptj.b2ji 521300 661443 2019-11-27 2019-06-30 14           14               14
2419 2419 ASCENSION GOOD SAMARITAN HOSPITAL 601 S CENTER AVE MERRILL WI 54452 LINCOLN (715) 536-5511 Critical Access Hospitals Voluntary non-profit - Church TRUE 45.1758580 -89.6830310 0   69 55 55069 32980 Wausau-Stevens Point-Wisconsin Rapids, WI Central Lincoln County https://data.medicare.gov/resource/xubh-q36u/row-22bh-e9v4.hnpp 521339 661687 2019-11-27 2019-06-30 25           25               25
870 870 ASCENSION OUR LADY OF VICTORY HOSPITAL 1120 PINE ST STANLEY WI 54768 CHIPPEWA (715) 644-5571 Critical Access Hospitals Voluntary non-profit - Other TRUE 44.9553110 -90.9205640 0   19 55 55019         https://data.medicare.gov/resource/xubh-q36u/row-xzzk-sbky-rj53 521311 661445 2019-11-27 2019-06-30 24           24               24
2420 2420 ASCENSION SACRED HEART HOSPITAL 401 W MOHAWK DR SUITE 100 TOMAHAWK WI 54487 LINCOLN (715) 453-7700 Critical Access Hospitals Voluntary non-profit - Church TRUE 45.4890060 -89.7335960 0   69 55 55069 32980 Wausau-Stevens Point-Wisconsin Rapids, WI Central Lincoln County https://data.medicare.gov/resource/xubh-q36u/row-zubv-e9fv-qs3r 521313 661446 2019-11-27 2019-06-30 15           15               15
2040 2040 ASCENSION SETON EDGAR B DAVIS 130 HAYS STREET LULING TX 78648 CALDWELL (830) 875-7000 Critical Access Hospitals Voluntary non-profit - Private TRUE 29.6725300 -97.6542540 0   55 48 48055 12420   Outlying Caldwell County https://data.medicare.gov/resource/xubh-q36u/row-wn52-vdac_k6nj 451371 660154 2019-11-25 2019-06-30 23           23               23
509 509 ASCENSION STANDISH HOSPITAL 805 W CEDAR ST STANDISH MI 48658 ARENAC (517) 846-4521 Critical Access Hospitals Voluntary non-profit - Church TRUE 43.9828300 -83.9693520 0   11 26 26011         https://data.medicare.gov/resource/xubh-q36u/row-3a56-bznt.bz29 231305 639965 2018-12-12 2018-06-30 20 5         25       29       54
457 457 ASHE MEMORIAL HOSPITAL 200 HOSPITAL AVE JEFFERSON NC 28640 ASHE (336) 246-7101 Critical Access Hospitals Voluntary non-profit - Private TRUE 36.4230270 -81.4597270 0   9 37 37009         https://data.medicare.gov/resource/xubh-q36u/row-adyt~iqxi_gv2a 341325 650353 2019-05-30 2018-12-31 25           25               25
999 999 ASHLAND HEALTH CENTER 625 SOUTH KENTUCKY ASHLAND KS 67831 CLARK (620) 635-2241 Critical Access Hospitals Voluntary non-profit - Other TRUE 37.1902572 -99.7797746 1 ROOFTOP 25 20 20025         https://data.medicare.gov/resource/xubh-q36u/row-6n24_uu3q.wx9d 171304 655206 2019-10-10 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
1917 1917 ASHLEY MEDICAL CENTER 612 CENTER AVENUE N ASHLEY ND 58413 MCINTOSH (701) 288-3433 Critical Access Hospitals Voluntary non-profit - Private TRUE 46.0401880 -99.3717150 0   51 38 38051         https://data.medicare.gov/resource/xubh-q36u/row-ecd4.9q4x_twgv 351322 661581 2019-12-02 2019-06-30 20           20       40       60
3086 3086 ASPEN VALLEY HOSPITAL 401 CASTLE CREEK RD ASPEN CO 81611 PITKIN (970) 544-1261 Critical Access Hospitals Government - Hospital District or Authority TRUE 39.1900570 -106.8377840 0   97 8 8097 24060 Edwards-Glenwood Springs, CO Outlying Pitkin County https://data.medicare.gov/resource/xubh-q36u/row-w4f4-8yin.fcc5 61324 649403 2019-05-30 2018-12-31 21 4         25               25
2467 2467 ASPIRUS IRON RIVER HOSPITAL & CLINICS, INC 1400 W ICE LAKE ROAD IRON RIVER MI 49935 IRON (906) 265-6121 Critical Access Hospitals Voluntary non-profit - Other TRUE 46.0997200 -88.6202810 0   71 26 26071         https://data.medicare.gov/resource/xubh-q36u/row-5hmu-6w8t_e66h 231318 660105 2019-11-26 2019-06-30 22 3         25               25
1954 1954 ASPIRUS IRONWOOD HOSPITAL N10561 GRAND VIEW LANE IRONWOOD MI 49938 GOGEBIC (906) 932-2525 Critical Access Hospitals Voluntary non-profit - Private TRUE 46.4781930 -90.1046890 0   53 26 26053         https://data.medicare.gov/resource/xubh-q36u/row-kai4_hwh9~ugv4 231333 660107 2019-11-26 2019-06-30 20 5         25               25
2191 2191 ASPIRUS KEWEENAW HOSPITAL 205 OSCEOLA LAURIUM MI 49913 HOUGHTON (906) 337-6500 Critical Access Hospitals Voluntary non-profit - Private TRUE 47.2375380 -88.4440380 0   61 26 26061 26340   Central Houghton County https://data.medicare.gov/resource/xubh-q36u/row-p9jg_yiuy~c7z4 231319 660600 2019-11-26 2019-06-30 20 5         25               25
2382 2382 ASPIRUS LANGLADE HOSPITAL 112 E FIFTH AVE ANTIGO WI 54409 LANGLADE (715) 623-2331 Critical Access Hospitals Voluntary non-profit - Church TRUE 45.1403190 -89.1402920 0   67 55 55067         https://data.medicare.gov/resource/xubh-q36u/row-fn2s~3kqd.84yg 521350 661688 2019-11-27 2019-06-30 21 4         25               25
3624 3624 ASPIRUS MEDFORD HOSPITAL & CLINICS, INC 135 S GIBSON ST MEDFORD WI 54451 TAYLOR (715) 748-8100 Critical Access Hospitals Voluntary non-profit - Private TRUE 45.1358340 -90.3540120 0   119 55 55119         https://data.medicare.gov/resource/xubh-q36u/row-8cup-n67n_55ac 521324 662627 2019-12-23 2019-06-30 25           25       78   10   113
3810 3810 ASPIRUS ONTONAGON HOSPITAL, INC 601 S SEVENTH ST ONTONAGON MI 49953 ONTONAGON (906) 884-8000 Critical Access Hospitals Government - Local TRUE 46.8656350 -89.3029760 0   131 26 26131         https://data.medicare.gov/resource/xubh-q36u/row-zhnw-wptd-d4w4 231309 660103 2019-11-26 2019-06-30 25           25       46       71
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
2635 2635 ASTRIA SUNNYSIDE HOSPITAL 1016 TACOMA AVENUE SUNNYSIDE WA 98944 YAKIMA (509) 837-1500 Critical Access Hospitals Voluntary non-profit - Private TRUE 46.3222180 -120.0069660 0   77 53 53077 49420   Central Yakima County https://data.medicare.gov/resource/xubh-q36u/row-meen.vpbw_8fip 501330 652470 2019-07-22 2018-12-31 18 7         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
1081 1081 ATHOL MEMORIAL HOSPITAL 2033 MAIN STREET ATHOL MA 1331 WORCESTER (978) 249-3511 Critical Access Hospitals Voluntary non-profit - Private TRUE 42.5862730 -72.2087480 0   27 25 25027 49340 Boston-Worcester-Providence, MA-RI-NH-CT Central Worcester County https://data.medicare.gov/resource/xubh-q36u/row-kb7k~zmz5~v8ji 221303 644288 2019-02-28 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
430 430 AUDUBON COUNTY MEMORIAL HOSPITAL 515 PACIFIC AVENUE AUDUBON IA 50025 AUDUBON (712) 563-2611 Critical Access Hospitals Government - Local TRUE 41.7154230 -94.9370440 0   9 19 19009         https://data.medicare.gov/resource/xubh-q36u/row-7tp4_zwyw_2d9j 161330 659788 2019-11-25 2019-06-30 25           25               25
4226 4226 AULTMAN ORRVILLE HOSPITAL 832 SOUTH MAIN STREET ORRVILLE OH 44667 WAYNE (330) 682-3010 Critical Access Hospitals Voluntary non-profit - Private TRUE 40.8320810 -81.7645780 0   169 39 39169 49300   Central Wayne County https://data.medicare.gov/resource/xubh-q36u/row-9tpy-nftf.5byd 361323 649328 2019-05-31 2018-12-31 25           25               25
3214 3214 AVERA CREIGHTON HOSPITAL P O BOX 186, 1503 MAIN ST CREIGHTON NE 68729 KNOX (402) 358-5700 Critical Access Hospitals Voluntary non-profit - Private TRUE 42.4664016 -97.9072475 1 ROOFTOP 107 31 31107         https://data.medicare.gov/resource/xubh-q36u/row-7tv3_vise~cn54 281331 660258 2019-11-25 2019-06-30 23           23       47       70
2628 2628 AVERA DE SMET MEMORIAL HOSPITAL - CAH 306 PRAIRIE AVENUE SW POST OFFICE BOX 160 DE SMET SD 57231 KINGSBURY (605) 854-3329 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.3860427 -97.5611172 1 GEOMETRIC_CENTER 77 46 46077         https://data.medicare.gov/resource/xubh-q36u/row-q65a~ny3z~nsyr 431332 662255 2019-11-27 2019-06-30 6           6               6
3181 3181 AVERA DELLS AREA HOSPITAL - CAH 909 N IOWA AVE DELL RAPIDS SD 57022 MINNEHAHA (605) 428-5431 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.8285880 -96.7153440 0   99 46 46099 43620   Central Minnehaha County https://data.medicare.gov/resource/xubh-q36u/row-9ckr.kcaf_sjek 431331 660036 2019-11-26 2019-06-30 21           21               21
3239 3239 AVERA FLANDREAU HOSPITAL - CAH 214 NORTH PRAIRIE STREET FLANDREAU SD 57028 MOODY (605) 997-2433 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.0505680 -96.5909890 0   101 46 46101         https://data.medicare.gov/resource/xubh-q36u/row-2fiy.k67h.w2yb 431310 660033 2019-11-26 2019-06-30 18           18               18
3356 3356 AVERA GETTYSBURG HOSPITAL 606 EAST GARFIELD GETTYSBURG SD 57442 POTTER (605) 765-2480 Critical Access Hospitals Voluntary non-profit - Church TRUE 45.0135510 -99.9481280 0   107 46 46107         https://data.medicare.gov/resource/xubh-q36u/row-5ptc-f9a4-vq7p 431302 660878 2019-12-02 2019-06-30 10           10           50   60
1974 1974 AVERA GREGORY HOSPITAL 400 PARK STREET POST OFFICE BOX 408 GREGORY SD 57533 GREGORY (605) 835-8394 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.2319878 -99.4304377 1 ROOFTOP 53 46 46053         https://data.medicare.gov/resource/xubh-q36u/row-sxnm~ansc_ejzf 431338 662257 2019-11-26 2019-06-30 25           25       55       80
2165 2165 AVERA HAND COUNTY MEMORIAL HOSPITAL AND CLINIC 300 W 5TH ST MILLER SD 57362 HAND (605) 853-2421 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.5206230 -98.9920440 0   59 46 46059         https://data.medicare.gov/resource/xubh-q36u/row-cen8-s23k_ktis 431337 662584 2019-11-27 2019-06-30 25           25               25
2249 2249 AVERA HOLY FAMILY HOSPITAL 826 NORTH 8TH STREET ESTHERVILLE IA 51334 EMMET (712) 362-2631 Critical Access Hospitals Voluntary non-profit - Church TRUE 43.4105960 -94.8339560 0   63 19 19063         https://data.medicare.gov/resource/xubh-q36u/row-gfry-34vq-dsa9 161351 660978 2019-11-27 2019-06-30 22           22               22
2752 2752 AVERA MARSHALL REGIONAL MEDICAL CTR 300 SOUTH BRUCE STREET MARSHALL MN 56258 LYON (507) 532-9661 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.4476340 -95.7761850 0   83 27 27083 32140   Central Lyon County https://data.medicare.gov/resource/xubh-q36u/row-w278-8yip-75pa 241359 661739 2019-11-29 2019-06-30 25           25 10     76       111
3593 3593 AVERA MERRILL PIONEER HOSPITAL 1100 S 10TH AVE ROCK RAPIDS IA 51246 LYON (712) 472-2591 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.4213815 -96.1757132 1 RANGE_INTERPOLATED 119 19 19119         https://data.medicare.gov/resource/xubh-q36u/row-m3f9-4aqb~x9sv 161321 660960 2019-11-27 2019-06-30 11           11               11
2911 2911 AVERA ST ANTHONY'S HOSPITAL 300 NORTH 2ND ST O' NEILL NE 68763 HOLT (402) 336-5131 Critical Access Hospitals Voluntary non-profit - Church TRUE 42.4603380 -98.6511180 0   89 31 31089         https://data.medicare.gov/resource/xubh-q36u/row-z9z2~5zkd.wkgh 281329 660645 2019-11-26 2019-06-30 25           25               25
2377 2377 AVERA ST BENEDICT HEALTH CENTER - CAH 401 WEST GLYNN DRIVE PARKSTON SD 57366 HUTCHINSON (605) 928-3311 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.3989450 -97.9900610 0   67 46 46067         https://data.medicare.gov/resource/xubh-q36u/row-w4r3_dmvi-zsg5 431330 660035 2019-11-25 2019-06-30 25           25         49     74
2705 2705 AVERA TYLER HOSPITAL 240 WILLOW STREET TYLER MN 56178 LINCOLN (507) 247-5521 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.2722740 -96.1309430 0   81 27 27081         https://data.medicare.gov/resource/xubh-q36u/row-n4ct.diqe~2bh6 241348 661738 2019-11-29 2019-06-30 21           21       30       51
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
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
4615 4615 BALLINGER MEMORIAL HOSPITAL 608 AVENUE B BALLINGER TX 76821 RUNNELS (325) 365-2531 Critical Access Hospitals Government - Hospital District or Authority TRUE 31.7498220 -99.9623020 0   399 48 48399         https://data.medicare.gov/resource/xubh-q36u/row-nqcy_n2re.zwit 451310 643973 2019-03-04 2018-09-30 16           16               16
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
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
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
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
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
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
2650 2650 BAPTIST MEDICAL CENTER-LEAKE 1100 HIGHWAY 16 EAST CARTHAGE MS 39051 LEAKE (601) 267-1422 Critical Access Hospitals Voluntary non-profit - Private TRUE 32.7385330 -89.5164100 0   79 28 28079         https://data.medicare.gov/resource/xubh-q36u/row-mxfu-3fr5~s5kq 251315 643911 2019-03-01 2018-09-30 25           25               25
4176 4176 BAPTIST MEDICAL CENTER-YAZOO 823 GRAND AVENUE YAZOO CITY MS 39194 YAZOO (662) 746-2261 Critical Access Hospitals Voluntary non-profit - Private TRUE 32.8587300 -90.4033210 0   163 28 28163 27140 Jackson-Vicksburg-Brookhaven, MS Outlying Yazoo County https://data.medicare.gov/resource/xubh-q36u/row-i83f-pamk.mfmb 251313 643910 2019-02-28 2018-09-30 25           25               25
616 616 BARAGA COUNTY MEMORIAL HOSPITAL 18341 US HIGHWAY 41 L' ANSE MI 49946 BARAGA (906) 524-3300 Critical Access Hospitals Government - Local TRUE 46.7344600 -88.4280420 0   13 26 26013         https://data.medicare.gov/resource/xubh-q36u/row-kzgx-j54h-paej 231307 645568 2019-03-05 2018-09-30 24           24               24
3642 3642 BARBOURVILLE ARH HOSPITAL 80 HOSPITAL DRIVE BARBOURVILLE KY 40906 KNOX (606) 546-4175 Critical Access Hospitals Government - Local TRUE 36.8523100 -83.8715200 0   121 21 21121 30940   Central Knox County https://data.medicare.gov/resource/xubh-q36u/row-bv2i-ez4s_feje 181328 660569 2019-11-27 2019-06-30 19 6         25               25
3539 3539 BARNES-KASSON COUNTY HOSPITAL 2872 TURNPIKE STREET SUSQUEHANNA PA 18847 SUSQUEHANNA (570) 853-3135 Critical Access Hospitals Voluntary non-profit - Private TRUE 41.9473720 -75.5940160 0   115 42 42115         https://data.medicare.gov/resource/xubh-q36u/row-jek6.26ef-dwbb 391309 659886 2019-11-26 2019-06-30 21 4         25       58       83
641 641 BARNESVILLE HOSPITAL ASSOCIATION, INC 639 WEST MAIN STREET BARNESVILLE OH 43713 BELMONT (740) 425-5101 Critical Access Hospitals Voluntary non-profit - Private TRUE 39.9920690 -81.1883940 0   13 39 39013 48540   Central Belmont County https://data.medicare.gov/resource/xubh-q36u/row-h85t.br3v-763v 361321 647575 2019-04-30 2018-12-31 20   5       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
795 795 BATH COMMUNITY HOSPITAL 106 PARK DRIVE- PO DRAWER Z HOT SPRINGS VA 24445 BATH (540) 839-7000 Critical Access Hospitals Voluntary non-profit - Private TRUE 37.9938900 -79.8309590 0   17 51 51017         https://data.medicare.gov/resource/xubh-q36u/row-36k3~dwrj~zvyd 491300 650420 2019-05-31 2018-12-31 14           14               14
695 695 BATTLE MOUNTAIN GENERAL HOSPITAL 535 SOUTH HUMBOLDT STREET BATTE MTN NV 89820 LANDER (775) 635-2550 Critical Access Hospitals Government - Hospital District or Authority TRUE 40.6406520 -116.9388210 0   15 32 32015         https://data.medicare.gov/resource/xubh-q36u/row-w9hj-b8v2_4i43 291303 662549 2019-11-29 2019-06-30 5           5       25       30
3915 3915 BAUM HARMON MERCY HOSPITAL 255 N WELCH AVENUE PRIMGHAR IA 51245 OBRIEN (712) 957-2300 Critical Access Hospitals Voluntary non-profit - Church TRUE 43.0885970 -95.6227960 0   141 19 19141         https://data.medicare.gov/resource/xubh-q36u/row-jur3.m7q6_c9mz 161300 660546 2019-11-27 2019-06-30 14           14               14
4699 4699 BAYLOR SCOTT & WHITE MEDICAL CENTER -TAYLOR 305 MALLARD TAYLOR TX 76574 WILLIAMSON (512) 352-7611 Critical Access Hospitals Voluntary non-profit - Private TRUE 30.5919310 -97.4152650 0   491 48 48491 12420   Central Williamson County https://data.medicare.gov/resource/xubh-q36u/row-znyt.enh8-549n 451374 651595 2019-05-31 2018-12-31 25           25               25
2490 2490 BAYSIDE COMMUNITY HOSPITAL 200 HOSPITAL DRIVE ANAHUAC TX 77514 CHAMBERS (409) 267-3143 Critical Access Hospitals Government - Hospital District or Authority TRUE 29.7530120 -94.6868500 0   71 48 48071 26420 Houston-The Woodlands, TX Central Chambers County https://data.medicare.gov/resource/xubh-q36u/row-zszx-nqzy-xwd5 451320 643853 2019-02-28 2018-09-30 14           14               14
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
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
448 448 BEARTOOTH BILLINGS CLINIC 2525 N BROADWAY RED LODGE MT 59068 CARBON (406) 446-2345 Critical Access Hospitals Voluntary non-profit - Private TRUE 45.2116970 -109.2430450 0   9 30 30009 13740   Outlying Carbon County https://data.medicare.gov/resource/xubh-q36u/row-i4we~7hxf.sxbf 271326 640232 2018-12-03 2018-06-30 10           10               10
2361 2361 BEATRICE COMMUNITY HOSPITAL & HEALTH CENTER, INC P O BOX 278, 4800 HOSPITAL PARKWAY BEATRICE NE 68310 GAGE (402) 228-3344 Critical Access Hospitals Voluntary non-profit - Private TRUE 40.3161806 -96.7495665 1 ROOFTOP 67 31 31067 13100 Lincoln-Beatrice, NE Central Gage County https://data.medicare.gov/resource/xubh-q36u/row-hnr5~xngx-6v22 281364 645126 2019-02-28 2018-09-30 22 3         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
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

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