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

807 rows where "fy_end_date" is on date 2018-09-30 sorted by acute_beds

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: hospital_type, hospital_ownership, emergency_services, geocode_flag, geocode_accuracy, centraloutlyingcounty, burn_beds, surg_icu_beds, nursing_fac_beds, oth_longterm_beds, filed_date (date)

fy_end_date (date) ✖

  • 2018-09-30 · 807 ✖
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
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
1852 1852 SANTA FE PHS INDIAN HOSPITAL 1700 CERRILLOS ROAD SANTA FE NM 87501 SANTA FE (505) 988-9821 Acute Care Hospitals Government - Federal FALSE 35.6669500 -105.9696650 0   49 35 35049 42140 Albuquerque-Santa Fe-Las Vegas, NM Central Santa Fe County https://data.medicare.gov/resource/xubh-q36u/row-9cut.x6uq_hkie 320057 647086 2019-04-27 2018-09-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
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
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
414 414 CONNECTICUT HOSPICE INC,THE 100 DOUBLE BEACH ROAD BRANFORD CT 6405 NEW HAVEN (203) 315-7500 Acute Care Hospitals Voluntary non-profit - Private FALSE 41.2563050 -72.8333670 0   9 9 9009 35300 New York-Newark, NY-NJ-CT-PA Central New Haven County https://data.medicare.gov/resource/xubh-q36u/row-9pw4-ddrr.eyyi 70038 645241 2019-03-01 2018-09-30 6           6           46   52
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
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
1401 1401 MESCALERO PHS INDIAN HOSPITAL P O BOX 210 MESCALERO NM 88340 OTERO (505) 464-4441 Acute Care Hospitals Government - Federal FALSE 33.1587939 -105.7723979 1 ROOFTOP 35 35 35035 10460   Central Otero County https://data.medicare.gov/resource/xubh-q36u/row-vqii_apfk.3xws 320058 650730 2019-06-22 2018-09-30 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
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
404 404 SAN CARLOS APACHE HEALTHCARE 103 MEDICINE WAY ROAD PERIDOT AZ 85542 GILA (928) 475-1200 Acute Care Hospitals Government - Federal FALSE 33.2956419 -110.4178011 1 ROOFTOP 9 4 4009 40940   Central Graham County https://data.medicare.gov/resource/xubh-q36u/row-9543-jpqy.dn76 30077 651688 2019-07-01 2018-09-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
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
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
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
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
2602 2602 POWER COUNTY HOSPITAL DISTRICT 510 ROOSEVELT STREET AMERICAN FALLS ID 83211 POWER (208) 226-3200 Critical Access Hospitals Government - Hospital District or Authority TRUE 42.7818580 -112.8490470 0   77 16 16077         https://data.medicare.gov/resource/xubh-q36u/row-jqyn~uieu.hqrg 131304 645328 2019-03-20 2018-09-30 10           10       16       26
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
3530 3530 ST LUKE HOSPITAL & LIVING CENTER 535 SOUTH FREEBORN MARION KS 66861 MARION (620) 382-2177 Critical Access Hospitals Government - Hospital District or Authority TRUE 38.3427080 -97.0100140 0   115 20 20115         https://data.medicare.gov/resource/xubh-q36u/row-uqvu-kkp6-ivun 171356 645551 2019-03-05 2018-09-30 10           10           32   42
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
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
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
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
2255 2255 JEFFERSON COUNTY HOSPITAL 870 S MAIN FAYETTE MS 39069 JEFFERSON (601) 786-3401 Acute Care Hospitals Government - Local TRUE 31.7048425 -91.0685345 1 ROOFTOP 63 28 28063         https://data.medicare.gov/resource/xubh-q36u/row-6ixf.trx6_t5pg 250060 644298 2019-03-04 2018-09-30 12           12 18             30
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
2537 2537 MADISON HOSPITAL 820 THIRD AVENUE MADISON MN 56256 LAC QUI PARLE (320) 598-7536 Critical Access Hospitals Voluntary non-profit - Private TRUE 45.0166350 -96.1887820 0   73 27 27073         https://data.medicare.gov/resource/xubh-q36u/row-dn7z_rt9e.ipjw 241372 645272 2019-02-27 2018-09-30 12           12       65       77
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
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
4117 4117 JASPER MEMORIAL HOSPITAL 898 COLLEGE STREET MONTICELLO GA 31064 JASPER (706) 468-6411 Critical Access Hospitals Government - Local TRUE 33.3139820 -83.6868770 0   159 13 13159 12060 Atlanta--Athens-Clarke County--Sandy Springs, GA Outlying Jasper County https://data.medicare.gov/resource/xubh-q36u/row-7m3n_3mxm~mxsc 111303 645064 2019-03-04 2018-09-30 12           12       55       67
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
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
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
950 950 LOST RIVERS MEDICAL CENTER 551 HIGHLAND DRIVE ARCO ID 83213 BUTTE (208) 252-7654 Critical Access Hospitals Government - Hospital District or Authority TRUE 43.6405520 -113.2962530 0   23 16 16023 26820 Idaho Falls-Rexburg-Blackfoot, ID Outlying Butte County https://data.medicare.gov/resource/xubh-q36u/row-77px.m9qb~bsww 131324 640856 2019-01-08 2018-09-30 14           14               14
1619 1619 SWEENY COMMUNITY HOSPITAL 305 NORTH MCKINNEY SWEENY TX 77480 BRAZORIA (979) 548-3311 Critical Access Hospitals Government - Hospital District or Authority TRUE 29.0485140 -95.6913920 0   39 48 48039 26420 Houston-The Woodlands, TX Central Brazoria County https://data.medicare.gov/resource/xubh-q36u/row-argn.cnxa-jdss 451311 643974 2019-03-01 2018-09-30 14           14               14
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
2709 2709 MEMORIAL HOSPITAL 1423 SEVENTH ST AURORA NE 68818 HAMILTON (402) 694-3171 Critical Access Hospitals Voluntary non-profit - Private TRUE 40.8718120 -98.0095310 0   81 31 31081 24260   Outlying Hamilton County https://data.medicare.gov/resource/xubh-q36u/row-t366-wmec-vg9c 281320 643279 2019-02-12 2018-09-30 14           14           47   61
4384 4384 HANSFORD COUNTY HOSPITAL 707 ROLAND ST SPEARMAN TX 79081 HANSFORD (806) 659-2535 Critical Access Hospitals Government - Hospital District or Authority TRUE 36.1904750 -101.2001270 0   195 48 48195         https://data.medicare.gov/resource/xubh-q36u/row-4gxw_72vt-83ub 451344 643658 2019-02-26 2018-09-30 14           14           8   22
4629 4629 STEPHENS MEMORIAL HOSPITAL 200 SOUTH GENEVA STREET BRECKENRIDGE TX 76424 STEPHENS (254) 559-2241 Acute Care Hospitals Government - Hospital District or Authority TRUE 32.7540560 -98.8877190 0   429 48 48429         https://data.medicare.gov/resource/xubh-q36u/row-f2c3_a9xb.afpq 450498 643739 2019-02-27 2018-09-30 14           14               14
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
838 838 CHOCTAW REGIONAL MEDICAL CENTER 8613 MS HWY 12 ACKERMAN MS 39735 CHOCTAW (662) 285-4400 Critical Access Hospitals Government - Local TRUE 33.3184650 -89.1823040 0   19 28 28019         https://data.medicare.gov/resource/xubh-q36u/row-9nt3~77et_z9mg 251334 643914 2019-03-01 2018-09-30 15           15         73     88
1557 1557 DRUMRIGHT REGIONAL HOSPITAL 610 WEST BYPASS DRUMRIGHT OK 74030 CREEK (918) 382-2300 Critical Access Hospitals Proprietary TRUE 35.9981930 -96.6059788 1 ROOFTOP 37 40 40037 46140 Tulsa-Muskogee-Bartlesville, OK Central Creek County https://data.medicare.gov/resource/xubh-q36u/row-7yzz_kwx7_bt4n 371331 641664 2019-01-08 2018-09-30 15           15               15
1832 1832 SYRINGA GENERAL HOSPITAL 607 W MAIN STREET GRANGEVILLE ID 83530 IDAHO (208) 983-1700 Critical Access Hospitals Government - Hospital District or Authority TRUE 45.9267890 -116.1269940 0   49 16 16049         https://data.medicare.gov/resource/xubh-q36u/row-9the-4kgt.urhi 131315 642946 2019-02-08 2018-09-30 15           15               15
2159 2159 HARPER COUNTY COMMUNITY HOSPITAL 1003 US HIGHWAY 64 NORTH BUFFALO OK 73834 HARPER (580) 735-2555 Critical Access Hospitals Government - Local TRUE 36.8449660 -99.6293020 0   59 40 40059         https://data.medicare.gov/resource/xubh-q36u/row-ubpf.zpwz~4xju 371324 643003 2019-02-11 2018-09-30 15           15               15
2163 2163 ST LUKE'S MCCALL 1000 STATE STREET BURGDORF ID 83638 VALLEY (208) 630-2395 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.9093540 -116.1097030 0   85 16 16085         https://data.medicare.gov/resource/xubh-q36u/row-au7a~xb54-snfz 131312 651560 2019-06-21 2018-09-30 15           15               15
2403 2403 KITTSON MEMORIAL HOSPITAL 1010 SOUTH BIRCH HALLOCK MN 56728 KITTSON (218) 843-3612 Critical Access Hospitals Voluntary non-profit - Private TRUE 48.7670580 -96.9404920 0   69 27 27069         https://data.medicare.gov/resource/xubh-q36u/row-6ca3.ddbe~k6m7 241336 651470 2019-06-24 2018-09-30 15           15       60       75
2871 2871 COLLINGSWORTH GENERAL HOSPITAL 1013 15TH ST WELLINGTON TX 79095 COLLINGSWORTH (806) 447-2521 Critical Access Hospitals Proprietary TRUE 34.8491100 -100.2120150 0   87 48 48087         https://data.medicare.gov/resource/xubh-q36u/row-iy62.m34i.p94f 451355 643660 2019-02-27 2018-09-30 15           15               15
3151 3151 LIFEBRITE COMMUNITY HOSPITAL OF EARLY 11740 COLUMBIA STREET BLAKELY GA 39823 EARLY (229) 723-4241 Critical Access Hospitals Voluntary non-profit - Private TRUE 31.3743820 -84.9462450 0   99 13 13099         https://data.medicare.gov/resource/xubh-q36u/row-x8g6~hmy4~rqqp 111314 646292 2019-04-01 2018-09-30 15           15       127       142
3486 3486 FAIRFAX COMMUNITY HOSPITAL 40 HOSPITAL ROAD FAIRFAX OK 74637 OSAGE (918) 642-3291 Critical Access Hospitals Voluntary non-profit - Other TRUE 36.5636190 -96.7052620 0   113 40 40113 46140 Tulsa-Muskogee-Bartlesville, OK Central Osage County https://data.medicare.gov/resource/xubh-q36u/row-4i8h_qx3c-d2aw 371318 648066 2019-05-20 2018-09-30 15           15               15
3529 3529 HILLSBORO COMMUNITY HOSPITAL 101 INDUSTRIAL ROAD HILLSBORO KS 67063 MARION (620) 947-3114 Critical Access Hospitals Proprietary FALSE 38.3614950 -97.1875890 0   115 20 20115         https://data.medicare.gov/resource/xubh-q36u/row-ik5a_fj2t_xvzd 171357 645552 2019-03-04 2018-09-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
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
4382 4382 I-70 COMMUNITY HOSPITAL 105 HOSPITAL DRIVE, BUILDING B SWEET SPRINGS MO 65351 SALINE (660) 335-4700 Critical Access Hospitals Proprietary TRUE 38.9782840 -93.4176350 0   195 29 29195 32180   Central Saline County https://data.medicare.gov/resource/xubh-q36u/row-4t2s.h4cc.n3vd 261334 651708 2019-06-28 2018-09-30 15           15               15
4464 4464 HEMPHILL COUNTY HOSPITAL 1020 S 4TH ST CANADIAN TX 79014 HEMPHILL (806) 323-6622 Acute Care Hospitals Government - Hospital District or Authority TRUE 35.9037920 -100.3873990 0   211 48 48211         https://data.medicare.gov/resource/xubh-q36u/row-86yy_5s2m-up8r 450578 646584 2019-04-17 2018-09-30 15           15           2   17
4534 4534 KIMBLE HOSPITAL 349 REID ROAD JUNCTION TX 76849 KIMBLE (325) 446-3321 Critical Access Hospitals Government - Hospital District or Authority TRUE 30.4991940 -99.7802540 0   267 48 48267         https://data.medicare.gov/resource/xubh-q36u/row-k7bm_txp3.mutf 451306 643379 2019-02-20 2018-09-30 15           15               15
4680 4680 RANKIN HOSPITAL MEDICAL CLINIC 1611 SPUR 576 RANKIN TX 79778 UPTON (432) 693-2443 Critical Access Hospitals Government - Hospital District or Authority FALSE 31.2335480 -101.9361780 1 ROOFTOP 461 48 48461         https://data.medicare.gov/resource/xubh-q36u/row-k6d6.95dp.xxq5 451329 643977 2019-03-04 2018-09-30 15           15               15
292 292 FIELD HEALTH SYSTEM 178 HIGHWAY 24 CENTREVILLE MS 39631 WILKINSON (601) 890-0500 Critical Access Hospitals Government - Local TRUE 31.0820299 -91.0587631 1 ROOFTOP 5 28 28005 32620   Outlying Amite County https://data.medicare.gov/resource/xubh-q36u/row-d7tp~8xnm~uwen 251309 646102 2019-02-28 2018-09-30 16           16               16
368 368 UPPER CONNECTICUT VALLEY HOSPITAL 181 CORLISS LANE COLEBROOK NH 3576 COOS (603) 237-4971 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.9044120 -71.4814890 0   7 33 33007 13620   Central Coos County https://data.medicare.gov/resource/xubh-q36u/row-5jxk.h2s8~zvc6 301300 644312 2019-02-27 2018-09-30 16           16               16
1649 1649 ST FRANCIS HOSPITAL 3401 LUDINGTON ST ESCANABA MI 49829 DELTA (906) 786-3311 Critical Access Hospitals Voluntary non-profit - Church TRUE 45.7457600 -87.0948530 0   41 26 26041 21540   Central Delta County https://data.medicare.gov/resource/xubh-q36u/row-iqyh_xi8k_igyu 231337 645115 2019-02-28 2018-09-30 16 9         25               25
1777 1777 NORTH CANYON MEDICAL CENTER 267 NORTH CANYON DR GOODING ID 83330 GOODING (208) 934-4433 Critical Access Hospitals Voluntary non-profit - Private FALSE 42.9218690 -114.7111280 0   47 16 16047         https://data.medicare.gov/resource/xubh-q36u/row-dagw~rfa6-2dqe 131302 642945 2019-02-06 2018-09-30 16           16               16
2345 2345 MINIDOKA MEMORIAL HOSPITAL 1224 8TH STREET RUPERT ID 83350 MINIDOKA (208) 436-0481 Critical Access Hospitals Government - Local TRUE 42.6196250 -113.6853620 0   67 16 16067 15420   Outlying Minidoka County https://data.medicare.gov/resource/xubh-q36u/row-m4t9~2798.xb46 131319 643405 2019-02-26 2018-09-30 16           16       46       62
3068 3068 CONCHO COUNTY HOSPITAL 614 EAKER STREET EDEN TX 76837 CONCHO (915) 869-5911 Critical Access Hospitals Government - Hospital District or Authority TRUE 31.2208850 -99.8478320 0   95 48 48095         https://data.medicare.gov/resource/xubh-q36u/row-gyb7_xqfh_6ezj 451325 643976 2019-03-04 2018-09-30 16           16               16
3876 3876 ELY BLOOMENSON COMMUNITY HOSPITAL 328 WEST CONAN STREET ELY MN 55731 ST. LOUIS (218) 365-3271 Critical Access Hospitals Voluntary non-profit - Private TRUE 47.9007010 -91.8719710 0   137 27 27137 20260   Central St. Louis County https://data.medicare.gov/resource/xubh-q36u/row-tia7_tsch.3esn 241318 645476 2019-03-01 2018-09-30 16           16               16
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
4627 4627 GLEN ROSE MEDICAL CENTER 1021 HOLDEN STREET GLEN ROSE TX 76043 SOMERVELL (254) 897-2215 Acute Care Hospitals Government - Hospital District or Authority TRUE 32.2420300 -97.7454000 0   425 48 48425 19100 Dallas-Fort Worth, TX-OK Outlying Somervell County https://data.medicare.gov/resource/xubh-q36u/row-cri5-k66p_vjbz 450451 645798 2019-03-22 2018-09-30 16           16               16
2416 2416 PLAINS MEMORIAL HOSPITAL 310 WEST HALSELL STREET DIMMITT TX 79027 CASTRO (806) 647-2191 Critical Access Hospitals Government - Hospital District or Authority TRUE 34.5555910 -102.3157640 0   69 48 48069         https://data.medicare.gov/resource/xubh-q36u/row-c55u_ceer_6r3n 451350 641531 2019-01-14 2018-09-30 17           17               17
3056 3056 JEFFERSON COMMUNITY HEALTH & LIFE P O BOX 277, 2200 H ST FAIRBURY NE 68352 JEFFERSON (402) 729-3351 Critical Access Hospitals Voluntary non-profit - Private TRUE 40.1364252 -97.1816307 1 ROOFTOP 95 31 31095         https://data.medicare.gov/resource/xubh-q36u/row-uhie_h8g7.ayhp 281319 644763 2019-02-26 2018-09-30 17           17       40       57
3158 3158 SEDAN CITY HOSPITAL 300 NORTH STREET SEDAN KS 67361 CHAUTAUQUA (620) 725-3115 Critical Access Hospitals Government - Local TRUE 37.1714400 -95.1030540 0   99 20 20099 37660   Central Labette County https://data.medicare.gov/resource/xubh-q36u/row-vdwb_dtrj-qnpi 171318 644727 2019-02-26 2018-09-30 17           17               17
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
758 758 COMMUNITY MEMORIAL HOSPITAL 512 SKYLINE BOULEVARD CLOQUET MN 55720 CARLTON (218) 879-4641 Critical Access Hospitals Voluntary non-profit - Private TRUE 46.7318440 -92.4624590 0   17 27 27017 20260   Outlying Carlton County https://data.medicare.gov/resource/xubh-q36u/row-wydg_i87y-v2ai 241364 645271 2019-02-27 2018-09-30 18   4       22       44       66
1051 1051 STOUGHTON HOSPITAL 900 RIDGE ST STOUGHTON WI 53589 DANE (608) 873-6611 Critical Access Hospitals Voluntary non-profit - Private TRUE 42.9203170 -89.2113190 0   25 55 55025 31540 Madison-Janesville-Beloit, WI Central Dane County https://data.medicare.gov/resource/xubh-q36u/row-wna6.q6dj_5p5b 521343 645623 2019-03-27 2018-09-30 18 4         22 10             32
2135 2135 STEELE MEMORIAL MEDICAL CENTER 203 SOUTH DAISY STREET SALMON ID 83467 LEMHI (208) 756-5600 Critical Access Hospitals Government - Local TRUE 45.1733110 -113.8909180 0   59 16 16059         https://data.medicare.gov/resource/xubh-q36u/row-frkw_jutq_kwk4 131305 645073 2019-03-05 2018-09-30 18           18               18
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
2668 2668 COCHRAN MEMORIAL HOSPITAL 205 E GRANT STREET MORTON TX 79346 COCHRAN (806) 266-5565 Critical Access Hospitals Government - Hospital District or Authority TRUE 33.7192940 -102.7580750 0   79 48 48079         https://data.medicare.gov/resource/xubh-q36u/row-cdg6.bkks~3hn7 451366 643985 2019-03-01 2018-09-30 18           18               18
4016 4016 WAMEGO HEALTH CENTER 711 GENN DRIVE WAMEGO KS 66547 POTTAWATOMIE (785) 456-2295 Critical Access Hospitals Voluntary non-profit - Other TRUE 39.2055110 -96.3181930 0   149 20 20149 31740 Manhattan-Junction City, KS Outlying Pottawatomie County https://data.medicare.gov/resource/xubh-q36u/row-i7fc.5e2b.jxvz 171337 644276 2019-02-25 2018-09-30 18           18               18
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
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
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
835 835 NANTUCKET COTTAGE HOSPITAL 57 PROSPECT STREET NANTUCKET MA 2554 NANTUCKET (508) 228-1200 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.2755420 -70.1002610 0   19 25 25019         https://data.medicare.gov/resource/xubh-q36u/row-txca.96ch~wc9s 220177 646153 2019-03-14 2018-09-30 19           19               19
1044 1044 GRACE COTTAGE HOSPITAL PO BOX 216 TOWNSHEND VT 5353 WINDHAM (802) 365-7920 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.0489148 -72.6682465 1 ROOFTOP 25 50 50025         https://data.medicare.gov/resource/xubh-q36u/row-u9ts~hp4k-kd62 471300 643746 2019-02-22 2018-09-30 19           19               19
1291 1291 CROWNPOINT HEALTHCARE FACILITY JUNCTION OF HWY 371 CROWNPOINT NM 87313 MCKINLEY (505) 786-5291 Acute Care Hospitals Government - Federal TRUE 35.6987639 -108.1396562 1 GEOMETRIC_CENTER 31 35 35031 23700   Central McKinley County https://data.medicare.gov/resource/xubh-q36u/row-fk7d.f3eh~sfri 320062 647264 2019-05-08 2018-09-30 19           19               19
3644 3644 GLACIAL RIDGE HOSPITAL 10 4TH AVENUE SOUTHEAST GLENWOOD MN 56334 POPE (320) 634-4521 Critical Access Hospitals Government - Hospital District or Authority TRUE 45.6467570 -95.3898700 0   121 27 27121         https://data.medicare.gov/resource/xubh-q36u/row-ip3d~zsv9-xzxg 241376 644297 2019-03-11 2018-09-30 19           19               19
3723 3723 SHARKEY ISSAQUENA COMMUNITY HOSPITAL 47 SOUTH FOURTH ST ROLLING FORK MS 39159 SHARKEY (662) 873-4395 Acute Care Hospitals Government - Local TRUE 32.9053730 -90.8849890 0   125 28 28125         https://data.medicare.gov/resource/xubh-q36u/row-xv4d_iffv-iegn 250079 643907 2019-03-04 2018-09-30 19           19 10     54       83
4022 4022 ST LUKES HOSPITAL 101 HOSPITAL DRIVE COLUMBUS NC 28722 POLK (828) 894-3311 Critical Access Hospitals Voluntary non-profit - Private TRUE 35.2418330 -82.2136460 0   149 37 37149         https://data.medicare.gov/resource/xubh-q36u/row-wtmr-3fw6_9q8w 341322 645350 2019-03-01 2018-09-30 19 6         25 10             35
4697 4697 ELECTRA MEMORIAL HOSPITAL 1207 S BAILEY STREET ELECTRA TX 76360 WICHITA (940) 495-3981 Critical Access Hospitals Government - Hospital District or Authority TRUE 34.0184550 -98.9238740 0   485 48 48485 48660   Central Wichita County https://data.medicare.gov/resource/xubh-q36u/row-cvz8.wx35~2ua3 451343 643657 2019-02-25 2018-09-30 19           19               19
4706 4706 WINKLER COUNTY MEMORIAL HOSPITAL 821 JEFFEE DRIVE KERMIT TX 79745 WINKLER (432) 586-5865 Critical Access Hospitals Government - Local TRUE 31.8497390 -103.0899160 0   495 48 48495         https://data.medicare.gov/resource/xubh-q36u/row-qbhw-92m9~uia9 451314 643975 2019-02-28 2018-09-30 19           19               19
182 182 FAIRVIEW HOSPITAL 29 LEWIS AVENUE GREAT BARRINGTON MA 1230 BERKSHIRE (413) 528-0790 Critical Access Hospitals Voluntary non-profit - Private TRUE 42.1919820 -73.3725230 0   3 25 25003 38340   Central Berkshire County https://data.medicare.gov/resource/xubh-q36u/row-6zsa~q4z7~nrdp 221302 645425 2019-03-01 2018-09-30 20 4         24               24
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
865 865 NORTH COUNTRY HOSPITAL AND HEALTH CENTER 189 PROUTY DRIVE NEWPORT VT 5855 ORLEANS (802) 334-7331 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.9546140 -72.2003390 0   19 50 50019         https://data.medicare.gov/resource/xubh-q36u/row-ipgf_5jyr.qb5v 471304 645803 2019-03-04 2018-09-30 20 5         25               25
1139 1139 RIVERLAND MEDICAL CENTER 1700 WALLACE BLVD FERRIDAY LA 71334 CONCORDIA (318) 757-6551 Critical Access Hospitals Government - Hospital District or Authority TRUE 31.6469583 -91.5548418 1 ROOFTOP 29 22 22029 35020   Central Concordia Parish https://data.medicare.gov/resource/xubh-q36u/row-v73w.iknw.vmzz 191318 644280 2019-03-01 2018-09-30 20 5         25               25
1397 1397 NORTHERN ROCKIES MEDICAL CENTER 802 2ND ST SE CUT BANK MT 59427 GLACIER (406) 873-2251 Critical Access Hospitals Voluntary non-profit - Private TRUE 48.6287800 -112.3263450 0   35 30 30035         https://data.medicare.gov/resource/xubh-q36u/row-mzwj.8j2h.fdnu 271337 643521 2019-02-26 2018-09-30 20           20               20
1641 1641 FRANKLIN COUNTY MEDICAL CENTER 44 NORTH FIRST EAST PRESTON ID 83263 FRANKLIN (208) 852-0137 Critical Access Hospitals Government - Local TRUE 42.0983790 -111.8754670 0   41 16 16041 30860   Outlying Franklin County https://data.medicare.gov/resource/xubh-q36u/row-9du2~qaxa~z8nm 131322 645243 2019-03-08 2018-09-30 20           20       35       55
1898 1898 GIBSON GENERAL HOSPITAL 1808 SHERMAN DR PRINCETON IN 47670 GIBSON (812) 385-3401 Critical Access Hospitals Voluntary non-profit - Private TRUE 38.3602310 -87.5895590 0   51 18 18051         https://data.medicare.gov/resource/xubh-q36u/row-79ak.ea49~jzf3 151319 645409 2019-03-01 2018-09-30 20 5         25               25
2132 2132 DOCTORS MEMORIAL HOSPITAL 2600 HOSPITAL DR BONIFAY FL 32425 HOLMES (850) 547-1120 Critical Access Hospitals Government - Hospital District or Authority FALSE 30.7605900 -85.6824740 0   59 12 12059         https://data.medicare.gov/resource/xubh-q36u/row-sw88.r7zg.v2gg 101307 645754 2019-03-18 2018-09-30 20           20               20
2195 2195 JASPER GENERAL HOSPITAL 15 SOUTH 6TH STREET BAY SPRINGS MS 39422 JASPER (601) 764-2101 Acute Care Hospitals Government - Local FALSE 31.9766880 -89.2905550 0   61 28 28061 29860   Outlying Jasper County https://data.medicare.gov/resource/xubh-q36u/row-y8rq~vqyv_stwk 250018 643796 2019-02-27 2018-09-30 20           20               20
2238 2238 GREENE COUNTY HOSPITAL 509 WILSON AVENUE EUTAW AL 35462 GREENE (205) 372-3388 Acute Care Hospitals Government - Local TRUE 32.8447440 -87.8893070 0   63 1 1063         https://data.medicare.gov/resource/xubh-q36u/row-dyit.ypt9~f4e7 10051 645036 2019-03-04 2018-09-30 20           20       72       92
2536 2536 JOHNSON MEMORIAL HOSPITAL 1282 WALNUT STREET DAWSON MN 56232 LAC QUI PARLE (320) 769-4323 Critical Access Hospitals Government - Hospital District or Authority TRUE 44.9309710 -96.0670630 0   73 27 27073         https://data.medicare.gov/resource/xubh-q36u/row-aiqt_9tq3~e2sg 241314 643711 2019-03-04 2018-09-30 20           20       56       76
2760 2760 OUR COMMUNITY HOSPITAL 921 JUNIOR HIGH ROAD SCOTLAND NECK NC 27874 HALIFAX (252) 826-4144 Critical Access Hospitals Voluntary non-profit - Private TRUE 36.1323341 -77.4291154 1 ROOFTOP 83 37 37083 40260 Rocky Mount-Wilson-Roanoke Rapids, NC Central Halifax County https://data.medicare.gov/resource/xubh-q36u/row-3t5i~i654~cm6e 341302 645787 2019-03-21 2018-09-30 20           20       60   20   100
3167 3167 CHOCTAW HEALTH CENTER ROUTE 7 BOX R50 PHILADELPHIA MS 39350 NESHOBA (601) 656-2211 Acute Care Hospitals Government - Federal TRUE 32.7809947 -89.1834058 1 ROOFTOP 99 28 28099         https://data.medicare.gov/resource/xubh-q36u/row-5rfv.qyga.n666 250127 652147 2019-07-02 2018-09-30 20           20               20

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