hospital_data

Table actions
Data provided via a collaboration between The Accountability Project and Big Local News. This project provides and joins datasets pertinent to the COVID-19 pandemic: hospital location and number of beds by type, county-level population estimates by age (which can be linked to hospital data) and nursing home location and capacity. See README for additional information.

Data source: Big Local News · About: big-local-datasette

4,413 rows where emergency_services = "TRUE" sorted by all_beds

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

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

emergency_services ✖

  • TRUE · 4,413 ✖
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 ▼
2979 2979 JOHNSON COUNTY COMMUNITY HOSPITAL 1901 S SHADY ST MOUNTAIN CITY TN 37683 JOHNSON (423) 727-1110 Critical Access Hospitals Government - Hospital District or Authority TRUE 36.4537830 -81.7987220 0   91 47 47091         https://data.medicare.gov/resource/xubh-q36u/row-48iq_hv6w-z7xq 441304 660044 2019-11-22 2019-06-30 2           2               2
1593 1593 EDWARD MCCREADY MEMORIAL HOSPITAL 201 HALL HIGHWAY CRISFIELD MD 21817 SOMERSET (410) 726-9496 Acute Care Hospitals Voluntary non-profit - Private TRUE 37.9960110 -75.8523660 0   39 24 24039 41540   Outlying Somerset County https://data.medicare.gov/resource/xubh-q36u/row-cmnn-hhsq~qwjh 210045 657148 2019-11-07 2019-06-30 3           3               3
4338 4338 PARKLAND HEALTH CENTER - BONNE TERRE 7245 RAIDER ROAD BONNE TERRE MO 63628 ST. FRANCOIS (573) 358-1400 Critical Access Hospitals Voluntary non-profit - Private TRUE 37.9092860 -90.5252970 0   187 29 29187 22100 St. Louis-St. Charles-Farmington, MO-IL Central St. Francois County https://data.medicare.gov/resource/xubh-q36u/row-qfh6_b86g_9np8 261315 662397 2019-12-04 2018-12-31 3           3               3
637 637 WESTFIELD MEMORIAL HOSPITAL, INC 189 EAST MAIN STREET WESTFIELD NY 14787 CHAUTAUQUA (716) 326-4921 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.3279010 -79.5693970 0   13 36 36013 27460   Central Chautauqua County https://data.medicare.gov/resource/xubh-q36u/row-vwk8~gn4h~53q8 330166 650743 2019-05-31 2018-12-31 4           4               4
1279 1279 BIG SKY MEDICAL CENTER 334 TOWN CENTER AVE BIG SKY MT 59716 GALLATIN (406) 995-6995 Acute Care Hospitals Voluntary non-profit - Private TRUE 45.2608000 -111.3007380 0   31 30 30031 14580   Central Gallatin County https://data.medicare.gov/resource/xubh-q36u/row-ibsg~9p6y.87cb 270089 655563 2019-10-17 2019-05-16 4           4               4
1283 1283 INCLINE VILLAGE HEALTH CENTER 880 ALDER STREET INCLINE VILLAGE NV 89451 WASHOE (775) 833-4100 Critical Access Hospitals Government - Hospital District or Authority TRUE 39.2509450 -119.9538610 0   31 32 32031 39900 Reno-Carson City-Fernley, NV Central Washoe County https://data.medicare.gov/resource/xubh-q36u/row-xavt.4jau_b7jd 291301 660260 2019-12-02 2019-06-30 4           4               4
2926 2926 EUREKA COMMUNITY HEALTH SERVICES - CAH 200 J AVE POST OFFICE BOX 517 EUREKA SD 57437 MC PHERSON (605) 284-2661 Critical Access Hospitals Voluntary non-profit - Private TRUE 45.7671960 -99.6144530 0   89 46 46089         https://data.medicare.gov/resource/xubh-q36u/row-63d5-93ah~nnd5 431308 658588 2019-11-12 2019-06-30 4           4               4
3690 3690 FIRSTHEALTH MONTGOMERY MEMORIAL HOSP 520 ALLEN STREET TROY NC 27371 MONTGOMERY (910) 572-1301 Critical Access Hospitals Voluntary non-profit - Private TRUE 35.3644300 -79.8915570 0   123 37 37123         https://data.medicare.gov/resource/xubh-q36u/row-vp9e-re8p-tifk 341303 645139 2019-03-01 2018-09-30 4           4               4
4424 4424 AD HOSPITAL EAST, LLC 12950 EAST FREEWAY, SUITE 100 HOUSTON TX 77015 HARRIS (713) 330-3897 Acute Care Hospitals Proprietary TRUE 29.7711360 -95.2007820 0   201 48 48201 26420 Houston-The Woodlands, TX Central Harris County https://data.medicare.gov/resource/xubh-q36u/row-g9pj_7cms.hams 670102 649155 2019-05-30 2018-12-31 4           4               4
909 909 CASS LAKE INDIAN HEALTH SERVICES HOSPITAL 425 7TH STREET NW CASS LAKE MN 56633 CASS (218) 335-3200 Critical Access Hospitals Government - Federal TRUE 47.3840940 -94.6095150 0   21 27 27021 14660   Outlying Cass County https://data.medicare.gov/resource/xubh-q36u/row-4suk.s9dt-ycv4 241358 646101 2019-03-29 2018-09-30 5           5               5
2850 2850 FISHERMEN'S COMMUNITY HOSPITAL 3301 OVERSEAS HWY MARATHON FL 33050 MONROE (305) 743-5533 Critical Access Hospitals Voluntary non-profit - Private TRUE 24.7111300 -81.0947200 0   87 12 12087 28580   Central Monroe County https://data.medicare.gov/resource/xubh-q36u/row-3mjy.7a5u.ezdd 101312 659771 2019-11-25 2019-06-30 4 1         5               5
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
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
704 704 VIDANT BERTIE HOSPITAL 1403 SOUTH KINGS STREET WINDSOR NC 27983 BERTIE (252) 794-6600 Critical Access Hospitals Voluntary non-profit - Private TRUE 35.9893550 -76.9281830 0   15 37 37015         https://data.medicare.gov/resource/xubh-q36u/row-pwdr-dt5d-exsb 341304 644156 2019-02-28 2018-09-30 6           6               6
2471 2471 PHILLIPS COUNTY MEDICAL CENTER 311 S 8TH AVE E MALTA MT 59538 PHILLIPS (406) 654-1100 Critical Access Hospitals Voluntary non-profit - Private TRUE 48.3570980 -107.8603560 0   71 30 30071         https://data.medicare.gov/resource/xubh-q36u/row-igja_7yh6.38ai 271312 654589 2019-09-16 2019-04-30 6           6               6
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
4116 4116 SUGAR LAND SURGICAL HOSPITAL LLP 16906 SOUTHWEST FREEWAY SUGAR LAND TX 77479 FORT BEND (281) 243-1000 Acute Care Hospitals Physician TRUE 29.5906090 -95.6366960 0   157 48 48157 26420 Houston-The Woodlands, TX Central Fort Bend County https://data.medicare.gov/resource/xubh-q36u/row-9avs-knbp-aret 450860 651075 2019-06-21 2018-12-31 6           6               6
4606 4606 DHHS USPHS INDIAN HEALTH SERVICES EXIT #102 OFF I-40 1/2 MILE SOUTH SAN FIDEL NM 87049 CIBOLA (505) 552-5300 Acute Care Hospitals Government - Federal TRUE 35.1838274 -101.9279458 1 ROOFTOP 375 48 48375 11100 Amarillo-Borger, TX Central Potter County https://data.medicare.gov/resource/xubh-q36u/row-j82y-frp9~f9kp 320070 647921 2019-05-08 2018-09-30 6           6               6
962 962 BLACK RIVER COMMUNITY MEDICAL CENTER 217 PHYSICIANS PARK DRIVE POPLAR BLUFF MO 63901 BUTLER (573) 686-6001 Acute Care Hospitals Voluntary non-profit - Private TRUE 36.7708820 -90.4564450 0   23 29 29023 38740   Central Butler County https://data.medicare.gov/resource/xubh-q36u/row-unng~jvuf.99dx 260227 660121 2019-11-15 2019-08-11 7           7               7
1651 1651 GREENE COUNTY HOSPITAL CAH 1017 JACKSON STREET LEAKESVILLE MS 39451 GREENE (601) 394-4135 Critical Access Hospitals Government - Local TRUE 31.1547640 -88.5626450 0   41 28 28041         https://data.medicare.gov/resource/xubh-q36u/row-w43a~rntf~brjp 251329 643805 2019-02-28 2018-09-30 7           7               7
4610 4610 REAGAN MEMORIAL HOSPITAL 1300 N MAIN AVENUE BIG LAKE TX 76932 REAGAN (325) 844-2561 Critical Access Hospitals Government - Hospital District or Authority TRUE 31.2016510 -101.4615870 0   383 48 48383         https://data.medicare.gov/resource/xubh-q36u/row-3fmb~j2vv~wgtn 451301 651298 2019-03-05 2018-09-30 7           7               7
930 930 SETON SMITHVILLE REGIONAL HOSPITAL 1201 HILL RD SMITHVILLE TX 78957 BASTROP (512) 237-3214 Acute Care Hospitals Voluntary non-profit - Church TRUE 30.0039505 -97.1360218 1 ROOFTOP 21 48 48021 12420   Outlying Bastrop County https://data.medicare.gov/resource/xubh-q36u/row-d2dp~cvuc~gmre 450143 659733 2019-11-25 2019-06-30 8           8               8
1339 1339 SANFORD WESTBROOK MEDICAL CENTER 920 BELL AVENUE PO BOX 188 WESTBROOK MN 56183 COTTONWOOD (507) 274-1119 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.0452850 -95.4388910 0   33 27 27033         https://data.medicare.gov/resource/xubh-q36u/row-enjn~dps2_zg3d 241302 649270 2019-05-28 2018-12-31 8           8               8
1538 1538 MERCY MEDICAL CENTER-NEW HAMPTON 308 NORTH MAPLE AVENUE NEW HAMPTON IA 50659 CHICKASAW (641) 394-4121 Critical Access Hospitals Voluntary non-profit - Church TRUE 43.0626770 -92.3204250 0   37 19 19037         https://data.medicare.gov/resource/xubh-q36u/row-xkj8-v8qa.w84a 161331 660217 2019-11-26 2019-06-30 8           8               8
1669 1669 PHS INDIAN HOSPITAL AT EAGLE BUTTE 24276 166TH AIRPORT ROAD EAGLE BUTTE SD 57625 DEWEY (605) 964-3005 Acute Care Hospitals Government - Federal TRUE 44.9935681 -101.2421234 1 GEOMETRIC_CENTER 41 46 46041         https://data.medicare.gov/resource/xubh-q36u/row-5fj3.qevg-rb9t 430083 650906 2019-06-24 2018-09-30 8           8               8
2297 2297 ST VINCENT GENERAL HOSPITAL DISTRICT 822 W 4TH ST LEADVILLE CO 80461 LAKE (719) 486-0230 Critical Access Hospitals Government - Hospital District or Authority TRUE 39.2443920 -106.3033020 0   65 8 8065         https://data.medicare.gov/resource/xubh-q36u/row-zkkb~2fq8_8dib 61319 648894 2019-05-30 2018-12-31 8           8               8
2767 2767 CASCADE MEDICAL CENTER 402 LAKE CASCADE PARKWAY CASCADE ID 83611 VALLEY (208) 382-4242 Critical Access Hospitals Government - Hospital District or Authority TRUE 44.5179210 -116.0489380 0   85 16 16085         https://data.medicare.gov/resource/xubh-q36u/row-8r6g.s3au-3yid 131308 644833 2019-03-04 2018-09-30 8           8               8
3397 3397 ONECORE HEALTH 1044 SW 44TH, SUITE 350 OKLAHOMA CITY OK 73109 OKLAHOMA (405) 631-3085 Acute Care Hospitals Voluntary non-profit - Other TRUE 35.4207290 -97.5338680 0   109 40 40109 36420 Oklahoma City-Shawnee, OK Central Oklahoma County https://data.medicare.gov/resource/xubh-q36u/row-zhp9.4kgr_ytfs 370220 651480 2019-05-29 2018-12-31 8           8               8
4654 4654 USMD HOSPITAL AT FORT WORTH LP 5900 ALTAMESA BLVD FORT WORTH TX 76132 TARRANT (817) 433-9100 Acute Care Hospitals Proprietary TRUE 32.6455920 -97.4181400 0   439 48 48439 19100 Dallas-Fort Worth, TX-OK Central Tarrant County https://data.medicare.gov/resource/xubh-q36u/row-dprz_9mav_2zjv 670046 649011 2019-05-31 2018-12-31 8           8               8
4669 4669 NORTHWEST HILLS SURGICAL HOSPITAL 6818 AUSTIN CTR BLVD SUITE 100 AUSTIN TX 78731 TRAVIS (512) 346-1994 Acute Care Hospitals Proprietary TRUE 30.3503160 -97.7510260 0   453 48 48453 12420   Central Travis County https://data.medicare.gov/resource/xubh-q36u/row-ue4n.z4gb~9nnx 450808 649834 2019-05-31 2018-12-31 8           8               8
4700 4700 BAYLOR SCOTT & WHITE EMERGENCY MEDICAL CENTER AT C 900 EAST WHITESTONE BLVD CEDAR PARK TX 78613 WILLIAMSON (512) 684-4911 Acute Care Hospitals Government - Hospital District or Authority TRUE 30.5239510 -97.8201770 0   491 48 48491 12420   Central Williamson County https://data.medicare.gov/resource/xubh-q36u/row-7m75.eizi~hrs5 670087 662636 2019-12-19 2019-06-30 8           8               8
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
3386 3386 NORTHWEST SURGICAL HOSPITAL 9204 NORTH MAY AVENUE OKLAHOMA CITY OK 73120 OKLAHOMA (405) 848-1918 Acute Care Hospitals Physician TRUE 35.5641660 -97.5671590 0   109 40 40109 36420 Oklahoma City-Shawnee, OK Central Oklahoma County https://data.medicare.gov/resource/xubh-q36u/row-a9dt_8msh-9ahb 370192 650519 2019-05-30 2018-12-31 9           9               9
3394 3394 SUMMIT MEDICAL CENTER, LLC 1800 SOUTH RENAISSANCE BOULEVARD EDMOND OK 73013 OKLAHOMA (405) 359-2400 Acute Care Hospitals Physician TRUE 35.6355210 -97.4994350 0   109 40 40109 36420 Oklahoma City-Shawnee, OK Central Oklahoma County https://data.medicare.gov/resource/xubh-q36u/row-4vbg.5jhj-wsm8 370225 648353 2019-05-20 2018-12-31 9           9               9
3494 3494 TEXAS INSTITUTE FOR SURGERY AT PRESBYTERIAN HOSPIT 7115 GREENVILLE AVENUE SUITE 100 DALLAS TX 75231 DALLAS (214) 647-5300 Acute Care Hospitals Proprietary TRUE 32.8763770 -96.7617260 0   113 48 48113 19100 Dallas-Fort Worth, TX-OK Central Dallas County https://data.medicare.gov/resource/xubh-q36u/row-zpaw~2v5b-8gcc 450889 646976 2019-04-26 2018-12-31 9           9               9
3535 3535 ESSENTIA HEALTH SANDSTONE 705 LUNDORFF DRIVE SOUTH SANDSTONE MN 55072 PINE (320) 245-2212 Critical Access Hospitals Voluntary non-profit - Private TRUE 46.1184080 -92.8829670 0   115 27 27115         https://data.medicare.gov/resource/xubh-q36u/row-krja~dcyt_wwi3 241309 660606 2019-11-27 2019-06-30 9           9               9
3858 3858 TALLAHATCHIE CRITICAL ACCESS HOSPITAL 201 SOUTH MARKET ST / PO BOX 230 CHARLESTON MS 38921 TALLAHATCHIE (662) 647-5535 Critical Access Hospitals Government - Local TRUE 34.0050790 -90.0581650 0   135 28 28135         https://data.medicare.gov/resource/xubh-q36u/row-avrr~zg9m~xqab 251304 644307 2019-02-28 2018-09-30 9           9               9
3933 3933 THE HOSPITALS OF PROVIDENCE HORIZON CITY CAMPUS 13600 HORIZON STREET, SUITE 100 HORIZON CITY TX 79928 EL PASO (915) 407-7878 Acute Care Hospitals Proprietary TRUE 31.6827230 -106.2073480 0   141 48 48141 21340 El Paso-Las Cruces, TX-NM Central El Paso County https://data.medicare.gov/resource/xubh-q36u/row-m5db~xjiy~dvv3 670124 649391 2019-05-30 2018-12-31 9           9               9
4619 4619 CHI ST LUKES HEALTH MEMORIAL SAN AUGUSTINE 511 HOSPITAL ST SAN AUGUSTINE TX 75972 SAN AUGUSTINE (936) 275-3446 Critical Access Hospitals Voluntary non-profit - Private TRUE 31.5322792 -94.1031699 1 ROOFTOP 405 48 48405         https://data.medicare.gov/resource/xubh-q36u/row-d3sm_en2i-92xw 451360 660892 2019-11-27 2019-06-30 9           9               9
22 22 STILLWATER BILLINGS CLINIC 710 N 11TH ST COLUMBUS MT 59019 STILLWATER (406) 322-5316 Critical Access Hospitals Voluntary non-profit - Private TRUE 45.6426860 -109.2431780 0   95 30 30095         https://data.medicare.gov/resource/xubh-q36u/row-feve.dr4z_em5n 271330 662542 2019-11-29 2019-06-30 10           10               10
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
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
847 847 GUADALUPE COUNTY HOSPITAL 117 CAMINO DE VIDA, SUITE 100 SANTA ROSA NM 88435 GUADALUPE (575) 472-3417 Acute Care Hospitals Government - Local TRUE 34.9295040 -104.6942240 0   19 35 35019         https://data.medicare.gov/resource/xubh-q36u/row-es4t_p7gk_ag72 320067 661934 2019-12-17 2019-06-30 10           10               10
895 895 MERCY HOSPITAL COLUMBUS 220 N PENNSYLVANIA AVENUE COLUMBUS KS 66725 CHEROKEE (620) 429-2545 Critical Access Hospitals Voluntary non-profit - Church TRUE 37.1720640 -94.8438050 0   21 20 20021         https://data.medicare.gov/resource/xubh-q36u/row-sn95~jvt2.e2ep 171308 660551 2019-11-27 2019-06-30 10           10               10
1040 1040 HANCOCK COUNTY HOSPITAL 1519 MAIN STREET HWY 33 SNEEDVILLE TN 37869 HANCOCK (423) 733-5001 Critical Access Hospitals Voluntary non-profit - Private TRUE 36.4302660 -83.4627660 0   25 47 47025         https://data.medicare.gov/resource/xubh-q36u/row-vwp6~bn89_wdkx 441313 659461 2019-11-20 2019-06-30 10           10               10
1114 1114 SUMMIT PACIFIC MEDICAL CENTER-SWING BED UNIT 600 EAST MAIN STREET ELMA WA 98541 GRAYS HARBOR (360) 346-2222 Critical Access Hospitals Government - Hospital District or Authority TRUE 47.0066230 -123.3910220 0   27 53 53027 10140   Central Grays Harbor County https://data.medicare.gov/resource/xubh-q36u/row-9u5u_f83c.s8u4 501304 651087 2019-06-05 2018-12-31 10           10               10
1615 1615 SANFORD CLEAR LAKE MEDICAL CENTER 701 THIRD AVENUE SOUTH CLEAR LAKE SD 57226 DEUEL (605) 874-2141 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.7526780 -96.6825600 0   39 46 46039         https://data.medicare.gov/resource/xubh-q36u/row-tyxz_xmhj~kyxp 431307 652104 2019-05-30 2018-12-31 10           10               10
1752 1752 DILEY RIDGE MEDICAL CENTER 7911 DILEY ROAD CANAL WINCHESTER OH 43110 FRANKLIN (614) 838-7910 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.8500530 -82.7811000 0   45 39 39045 18140 Columbus-Marion-Zanesville, OH Central Fairfield County https://data.medicare.gov/resource/xubh-q36u/row-82cy_fgw2.yjpg 360358 660675 2019-11-26 2019-06-30 10           10               10
1882 1882 WILLAPA HARBOR HOSPITAL 800 ALDER STREET SOUTH BEND WA 98586 PACIFIC (360) 875-5526 Critical Access Hospitals Government - Hospital District or Authority TRUE 46.6621640 -123.8123170 0   49 53 53049         https://data.medicare.gov/resource/xubh-q36u/row-yp34-4iya_m78d 501303 647986 2019-05-14 2018-12-31 10           10               10
1908 1908 PRAIRIE RIDGE HOSPITAL AND HEALTH SERVICES 1411 HIGHWAY 793 E ELBOW LAKE MN 56531 GRANT (218) 685-7300 Critical Access Hospitals Voluntary non-profit - Private TRUE 45.9908032 -95.9578947 1 ROOFTOP 51 27 27051         https://data.medicare.gov/resource/xubh-q36u/row-is3f.7a5b~t9ju 241379 644131 2019-02-28 2018-09-30 10           10               10
2041 2041 PEACEHEALTH PEACE ISLAND MEDICAL CENTER 1117 SPRING STREET FRIDAY HARBOR WA 98250 SAN JUAN (360) 378-2141 Critical Access Hospitals Voluntary non-profit - Private TRUE 48.5298570 -123.0281710 0   55 53 53055         https://data.medicare.gov/resource/xubh-q36u/row-tq94~fpij_9q58 501340 640562 2018-11-30 2018-06-30 10           10               10
2075 2075 MADISON VALLEY MEDICAL CENTER 305 N MAIN ENNIS MT 59729 MADISON (406) 682-4222 Critical Access Hospitals Government - Hospital District or Authority TRUE 45.3514000 -111.7325670 0   57 30 30057         https://data.medicare.gov/resource/xubh-q36u/row-djeh_dspp-vwv4 271329 644643 2019-02-28 2018-09-30 10           10               10
2076 2076 RUBY VALLEY MEDICAL CENTER 321 MADISON ST SHERIDAN MT 59749 MADISON (406) 842-5453 Critical Access Hospitals Voluntary non-profit - Private TRUE 45.4525850 -112.1914530 0   57 30 30057         https://data.medicare.gov/resource/xubh-q36u/row-w73r_tdsp_m6z4 271319 647382 2019-04-29 2018-10-31 10           10               10
2773 2773 BELLIN HEALTH OCONTO HOSPITAL 820 ARBUTUS AVE OCONTO WI 54153 OCONTO (920) 835-1101 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.8968910 -87.8671870 0   83 55 55083 24580 Green Bay-Shawano, WI Outlying Oconto County https://data.medicare.gov/resource/xubh-q36u/row-txia-if9r.5nnj 521356 645518 2019-03-18 2018-09-30 10           10               10
3171 3171 KEARNEY COUNTY HEALTH SERVICES HOSPITAL 727 EAST 1ST ST MINDEN NE 68959 KEARNEY (308) 832-3400 Critical Access Hospitals Government - Local TRUE 40.4957780 -98.9432030 0   99 31 31099 28260   Outlying Kearney County https://data.medicare.gov/resource/xubh-q36u/row-aaj3.vtp7.jy9v 281306 654341 2019-09-09 2019-06-30 10           10               10
3815 3815 SYRACUSE AREA HEALTH 2731 HEALTHCARE DR SYRACUSE NE 68446 OTOE (402) 269-2011 Critical Access Hospitals Government - Hospital District or Authority TRUE 40.6770233 -96.1814653 1 ROOFTOP 131 31 31131         https://data.medicare.gov/resource/xubh-q36u/row-e4xn-76tv~ys3t 281309 658943 2019-11-11 2019-06-30 10           10               10
3989 3989 KINGS DAUGHTERS MEDICAL CENTER OHIO 1901 ARGONNE ROAD PORTSMOUTH OH 45662 SCIOTO (740) 991-4000 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.7473190 -82.9933540 0   145 39 39145 39020 Charleston-Huntington-Ashland, WV-OH-KY Central Scioto County https://data.medicare.gov/resource/xubh-q36u/row-3hvz~qivd_yj54 360361 644543 2019-02-28 2018-09-30 10           10               10
4588 4588 MEMORIAL HERMANN SURGICAL HOSPITAL KINGWOOD 300 KINGWOOD MEDICAL DRIVE KINGWOOD TX 77339 HARRIS (281) 312-4000 Acute Care Hospitals Proprietary TRUE 30.0471980 -95.2579490 0   339 48 48339 26420 Houston-The Woodlands, TX Outlying Montgomery County https://data.medicare.gov/resource/xubh-q36u/row-v6he.gqvr.a5ws 670005 648513 2019-05-21 2018-12-31 10           10               10
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
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
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
1404 1404 BLUE MOUNTAIN HOSPITAL 802 SOUTH 200 WEST BLANDING UT 84511 SAN JUAN (435) 678-3993 Critical Access Hospitals Voluntary non-profit - Private TRUE 37.6144490 -109.4815440 0   37 49 49037         https://data.medicare.gov/resource/xubh-q36u/row-fzdn.n6iq~872c 461310 644671 2019-02-27 2018-09-30 11           11               11
1710 1710 DOUGLAS COUNTY MEMORIAL HOSPITAL-CAH 708 8TH ST ARMOUR SD 57313 DOUGLAS (605) 724-2159 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.3248250 -98.3448240 0   43 46 46043         https://data.medicare.gov/resource/xubh-q36u/row-pg2t_pahj-3xcd 431305 656756 2019-11-05 2019-05-31 11           11               11
1913 1913 SIERRA VISTA HOSPITAL 800 EAST 9TH AVENUE T OR C NM 87901 SIERRA (575) 894-2111 Critical Access Hospitals Government - Local TRUE 33.1391040 -107.2419750 0   51 35 35051         https://data.medicare.gov/resource/xubh-q36u/row-4i26.fnpx~4q9x 321300 654972 2019-10-11 2019-06-30 11           11               11
1950 1950 DECATUR COUNTY HOSPITAL 1405 NW CHURCH STREET LEON IA 50144 DECATUR (641) 446-4871 Critical Access Hospitals Government - Local TRUE 40.7503080 -93.7477890 0   53 19 19053         https://data.medicare.gov/resource/xubh-q36u/row-z8pk.dm9q_4faw 161340 660972 2019-12-02 2019-06-30 11           11               11
2211 2211 MOUNTRAIL COUNTY MEDICAL CENTER INC 615 6TH ST SE STANLEY ND 58784 MOUNTRAIL (701) 628-2424 Critical Access Hospitals Voluntary non-profit - Private TRUE 48.3125040 -102.3808690 0   61 38 38061         https://data.medicare.gov/resource/xubh-q36u/row-b8p8-yzkh-reuy 351301 659831 2019-11-22 2019-06-30 11           11               11
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
2768 2768 SANFORD CANTON-INWOOD MEDICAL CENTER - CAH 440 NORTH HIAWATHA DRIVE CANTON SD 57013 LINCOLN (605) 764-1400 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.3049440 -96.5572490 0   83 46 46083 43620   Central Lincoln County https://data.medicare.gov/resource/xubh-q36u/row-drz2_z7zb-tas3 431333 648483 2019-05-23 2018-12-31 11           11               11
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
4679 4679 MCCAMEY HOSPITAL 2500 HWY 305 SOUTH MCCAMEY TX 79752 UPTON (432) 652-8626 Critical Access Hospitals Government - Hospital District or Authority TRUE 31.1145414 -102.2102683 1 ROOFTOP 461 48 48461         https://data.medicare.gov/resource/xubh-q36u/row-ezrc~bqk8~d5gy 451309 643464 2019-02-22 2018-09-30 11           11               11
14 14 DICKENSON COMMUNITY HOSPITAL 312 HOSPITAL DRIVE CLINTWOOD VA 24228 DICKENSON (276) 926-0300 Critical Access Hospitals Voluntary non-profit - Private TRUE 37.1598600 -82.4491020 0   51 51 51051 13720   Outlying Dickenson County https://data.medicare.gov/resource/xubh-q36u/row-gdzi~hhk4-fsm8 491303 659905 2019-11-21 2018-09-30 2           2 10             12
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
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
928 928 TRISTAR ASHLAND CITY MEDICAL CENTER 313 NORTH MAIN ST ASHLAND CITY TN 37015 CHEATHAM (615) 792-3030 Critical Access Hospitals Proprietary TRUE 36.2769740 -87.0659760 0   21 47 47021 34980 Nashville-Davidson--Murfreesboro, TN Outlying Cheatham County https://data.medicare.gov/resource/xubh-q36u/row-dctd_vqeq_ijzv 441311 655652 2019-10-30 2019-05-31 12           12               12
1322 1322 COMANCHE COUNTY HOSPITAL 2ND & FRISCO STREET COLDWATER KS 67029 COMANCHE (620) 582-2144 Critical Access Hospitals Government - Local TRUE 37.2679460 -99.3321152 1 GEOMETRIC_CENTER 33 20 20033         https://data.medicare.gov/resource/xubh-q36u/row-uexi-7hwn_3fpb 171312 648915 2019-05-29 2018-12-31 12           12               12
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
1654 1654 CALLAWAY DISTRICT HOSPITAL P O BOX 100, 211 E KIMBALL CALLAWAY NE 68825 CUSTER (308) 836-2228 Critical Access Hospitals Government - Hospital District or Authority TRUE 41.2909887 -99.9242095 1 ROOFTOP 41 31 31041         https://data.medicare.gov/resource/xubh-q36u/row-nfg8_ccxm-ja7t 281335 660412 2019-01-02 2018-07-31 12           12               12
1794 1794 GOTHENBURG MEMORIAL HOSPITAL 910 20TH ST GOTHENBURG NE 69138 DAWSON (308) 537-3661 Critical Access Hospitals Government - Hospital District or Authority TRUE 40.9381320 -100.1533520 0   47 31 31047 30420   Central Dawson County https://data.medicare.gov/resource/xubh-q36u/row-dgzd-a44k.k83g 281313 661037 2019-12-02 2019-06-30 12           12               12
1874 1874 FAULKTON AREA MEDICAL CENTER 1300 OAK STREET POST OFFICE BOX 100 FAULKTON SD 57438 FAULK (605) 598-6262 Critical Access Hospitals Voluntary non-profit - Private TRUE 45.0299990 -99.1315700 0   49 46 46049         https://data.medicare.gov/resource/xubh-q36u/row-9wwa-ei6u.pihr 431301 646881 2019-04-25 2018-12-31 12           12               12
2341 2341 ANIMAS SURGICAL HOSPITAL, LLC 575 RIVERGATE LN DURANGO CO 81301 LA PLATA (970) 247-3537 Acute Care Hospitals Physician TRUE 37.2488890 -107.8707740 0   67 8 8067 20420   Central La Plata County https://data.medicare.gov/resource/xubh-q36u/row-twp9-b345.bypu 60117 650115 2019-05-31 2018-12-31 12           12               12
2498 2498 UAB CALLAHAN EYE HOSPITAL AUTHORITY 1720 UNIVERSITY BLVD, SUITE 500 BIRMINGHAM AL 35233 JEFFERSON (205) 325-8100 Acute Care Hospitals Voluntary non-profit - Private TRUE 33.5031370 -86.8024010 0   73 1 1073 13820 Birmingham-Hoover-Talladega, AL Central Jefferson County https://data.medicare.gov/resource/xubh-q36u/row-txeu_r7zi.ibaa 10018 644082 2019-03-01 2018-09-30 12           12               12
2790 2790 HOLTON COMMUNITY HOSPITAL 1110 COLUMBINE DRIVE HOLTON KS 66436 JACKSON (785) 364-2116 Critical Access Hospitals Voluntary non-profit - Private TRUE 39.4794640 -95.7509080 0   85 20 20085 45820   Outlying Jackson County https://data.medicare.gov/resource/xubh-q36u/row-8a8r_8yba-yt3v 171319 653242 2019-08-21 2019-03-31 12           12               12
2802 2802 STANDING ROCK INDIAN HEALTH SERVICE HOSPITAL 10 NORTH RIVER ROAD FORT YATES ND 58538 SIOUX (701) 854-3831 Acute Care Hospitals Government - Federal TRUE 46.0952325 -100.6281136 1 ROOFTOP 85 38 38085 13900   Outlying Sioux County https://data.medicare.gov/resource/xubh-q36u/row-a84q-rj3h~6yed 350064 651228 2019-06-18 2018-09-30 12           12               12
2908 2908 NORTH VALLEY HEALTH CENTER 300 WEST GOOD SAMARITAN DRIVE WARREN MN 56762 MARSHALL (218) 745-4211 Critical Access Hospitals Voluntary non-profit - Private TRUE 48.1927360 -96.7743980 0   89 27 27089         https://data.medicare.gov/resource/xubh-q36u/row-5hr9-apeq-pgtf 241337 651012 2019-06-04 2018-12-31 12           12               12
3159 3159 OSWEGO COMMUNITY HOSPITAL 800 BARKER DRIVE OSWEGO KS 67356 LABETTE (620) 795-2921 Critical Access Hospitals Proprietary TRUE 37.1596730 -95.1107700 0   99 20 20099 37660   Central Labette County https://data.medicare.gov/resource/xubh-q36u/row-r8kw_57qd_r6fs 171302 643032 2019-01-29 2018-09-30 12           12               12
3399 3399 SURGICAL HOSPITAL OF OKLAHOMA, LLC 100 SOUTHEAST 59TH STREET OKLAHOMA CITY OK 73129 OKLAHOMA (405) 634-9300 Acute Care Hospitals Physician TRUE 35.4062250 -97.5093160 0   109 40 40109 36420 Oklahoma City-Shawnee, OK Central Oklahoma County https://data.medicare.gov/resource/xubh-q36u/row-drs8-u5z4.yfq6 370201 649812 2019-05-31 2018-12-31 12           12               12
4058 4058 SCHOOLCRAFT MEMORIAL HOSPITAL 7870W US HIGHWAY 2 MANISTIQUE MI 49854 SCHOOLCRAFT (906) 341-3200 Critical Access Hospitals Government - Local TRUE 45.9449630 -86.2757160 0   153 26 26153         https://data.medicare.gov/resource/xubh-q36u/row-i54k_s479.sfn4 231303 650833 2019-06-06 2018-12-31 12           12               12
4302 4302 BAYLOR SCOTT AND WHITE SURGICAL HOSPITAL AT SHERMA 3601 CALAIS DRIVE SHERMAN TX 75090 GRAYSON (903) 813-3728 Acute Care Hospitals Physician TRUE 33.6768600 -96.6025270 0   181 48 48181 43300 Dallas-Fort Worth, TX-OK Central Grayson County https://data.medicare.gov/resource/xubh-q36u/row-4y3f.tmsq.cez5 670076 648878 2019-05-28 2018-12-31 12           12               12
4426 4426 FIRST TEXAS HOSPITAL 9922 LOUETTA RD HOUSTON TX 77070 HARRIS (844) 264-1435 Acute Care Hospitals Proprietary TRUE 30.0008390 -95.5608680 0   201 48 48201 26420 Houston-The Woodlands, TX Central Harris County https://data.medicare.gov/resource/xubh-q36u/row-t68p~4ggy.94di 670118 649157 2019-05-30 2018-12-31 12           12               12
4631 4631 LILLIAN M HUDSPETH MEMORIAL HOSPITAL 308 HUDSPETH SONORA TX 76950 SUTTON (325) 387-2521 Critical Access Hospitals Government - Hospital District or Authority TRUE 30.5637580 -100.6348700 0   435 48 48435         https://data.medicare.gov/resource/xubh-q36u/row-i9e9_qde3.um4r 451324 652847 2019-08-21 2018-12-31 12           12               12
1731 1731 VALOR HEALTH 1202 EAST LOCUST STREET EMMETT ID 83617 GEM (208) 365-3561 Critical Access Hospitals Government - Local TRUE 43.8790780 -116.4852550 0   45 16 16045 14260 Boise City-Mountain Home-Ontario, ID-OR Outlying Gem County https://data.medicare.gov/resource/xubh-q36u/row-cch8-kmmd-nmhb 131318 644635 2019-02-28 2018-09-30 13           13               13
2081 2081 SAKAKAWEA MEDICAL CENTER - CAH 510 8TH AVENUE NE HAZEN ND 58545 MERCER (701) 748-2225 Critical Access Hospitals Voluntary non-profit - Private TRUE 47.2982860 -101.6115600 0   57 38 38057         https://data.medicare.gov/resource/xubh-q36u/row-772i_c662.4xam 351310 660272 2019-11-25 2019-06-30 13           13               13
2693 2693 TETON VALLEY HOSPITAL 120 EAST HOWARD AVE DRIGGS ID 83422 TETON (208) 354-2383 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.7272850 -111.1086080 0   81 16 16081 27220   Outlying Teton County https://data.medicare.gov/resource/xubh-q36u/row-73s3-g6zw_arid 131313 643497 2019-02-27 2018-09-30 13           13               13
4298 4298 WEBSTER COUNTY COMMUNITY HOSPITAL P O BOX 465, 621 N FRANKLIN ST RED CLOUD NE 68970 WEBSTER (402) 746-5600 Critical Access Hospitals Government - Local TRUE 40.0915582 -98.5280755 1 ROOFTOP 181 31 31181         https://data.medicare.gov/resource/xubh-q36u/row-2g3y_shvn~j8h3 281316 660132 2019-11-26 2019-06-30 13           13               13
4523 4523 ANSON GENERAL HOSPITAL 101 AVENUE J ANSON TX 79501 JONES (325) 823-3231 Acute Care Hospitals Government - Local TRUE 32.7681010 -99.8955140 0   253 48 48253 10180   Outlying Jones County https://data.medicare.gov/resource/xubh-q36u/row-yt33_gjz7-gmyy 450078 653860 2019-09-03 2019-03-31 7           7           6   13
25 25 ESSENTIA HEALTH ADA 201 9TH STREET WEST ADA MN 56510 NORMAN (218) 784-5000 Critical Access Hospitals Voluntary non-profit - Private TRUE 47.2960910 -96.5301900 0   107 27 27107         https://data.medicare.gov/resource/xubh-q36u/row-z63y_de5x~9s9u 241313 660607 2019-11-26 2019-06-30 14           14               14
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
426 426 LANAI COMMUNITY HOSPITAL 628 7TH STREET LANAI CITY HI 96763 MAUI (808) 565-8450 Critical Access Hospitals Government - State TRUE 20.8267350 -156.9180020 0   9 15 15009 27980   Central Maui County https://data.medicare.gov/resource/xubh-q36u/row-keiy_dtd7_smny 121305 648608 2019-06-03 2018-12-31 4           4       10       14
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
800 800 SELLS HOSPITAL HIGHWAY 86, AT TOPAWA ROAD SELLS AZ 85634 PIMA (520) 362-7003 Acute Care Hospitals Tribal TRUE 31.9183549 -111.8792747 1 GEOMETRIC_CENTER 19 4 4019 46060 Tucson-Nogales, AZ Central Pima County https://data.medicare.gov/resource/xubh-q36u/row-57e8_mqp9-5x9d 30074 651599 2019-07-10 2018-09-30 14           14               14

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