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,766 rows sorted by hosp_lookup_url descending

View and edit SQL

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
3000 ALLIANCE HEALTHCARE SYSTEM 1430 HIGHWAY 4 EAST / P O BOX 6000 HOLLY SPRINGS MS 38635 MARSHALL (662) 252-1212 Acute Care Hospitals Physician TRUE 34.7868350 -89.4150270 0   93 28 28093 32820 Memphis-Forrest City, TN-MS-AR Outlying Marshall County https://data.medicare.gov/resource/xubh-q36u/row-zg7w-9rxd.iyxq 250012 648706 2019-06-04 2018-12-31 27           27 13             40
4123 BRONSON SOUTH HAVEN HOSPITAL 955 S BAILEY AVE SOUTH HAVEN MI 49090 VAN BUREN (269) 637-5271 Acute Care Hospitals Government - Hospital District or Authority TRUE 42.3912520 -86.2641300 0   159 26 26159 28020 Kalamazoo-Battle Creek-Portage, MI Outlying Van Buren County https://data.medicare.gov/resource/xubh-q36u/row-zfqy_5w55-vbnk 230085 649607 2019-05-31 2018-12-31 49           49               49
375 OUR LADY OF LOURDES MEMORIAL HOSPITAL, INC 169 RIVERSIDE DRIVE BINGHAMTON NY 13905 BROOME (607) 798-5111 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.0926400 -75.9355580 0   7 36 36007 13780   Central Broome County https://data.medicare.gov/resource/xubh-q36u/row-zfjd-ytfx.rrir 330011 662229 2019-12-02 2019-06-30 151 10         161               161
3450 CONEMAUGH MEYERSDALE MEDICAL CENTER 200 HOSPITAL DRIVE MEYERSDALE PA 15552 SOMERSET (814) 634-5911 Critical Access Hospitals Proprietary TRUE 39.8092810 -79.0253380 0   111 42 42111 43740 Johnstown-Somerset, PA Central Somerset County https://data.medicare.gov/resource/xubh-q36u/row-zfec_mecz_mmru 391302 660304 2019-12-03 2019-06-30 20           20               20
1624 CHARLESTON SURGICAL HOSPITAL 1306 KANAWHA BOULEVARD EAST CHARLESTON WV 25301 KANAWHA (304) 343-4371 Acute Care Hospitals Physician FALSE 38.3429910 -81.6306620 0   39 54 54039 16620 Charleston-Huntington-Ashland, WV-OH-KY Central Kanawha County https://data.medicare.gov/resource/xubh-q36u/row-zfdk.i8cn~ciui 510091 650428 2019-05-31 2018-12-31 8           8               8
3443 HEALTHALLIANCE HOSPITAL BROADWAY CAMPUS 396 BROADWAY KINGSTON NY 12401 ULSTER (914) 331-3131 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.9263500 -73.9954020 0   111 36 36111 28740 New York-Newark, NY-NJ-CT-PA Central Ulster County https://data.medicare.gov/resource/xubh-q36u/row-zf8i_c58i_mkqr 330004 649931 2019-05-30 2018-12-31 129 20         149               149
3647 MERIT HEALTH WOMEN'S HOSPITAL 1026 RIVER OAKS DRIVE FLOWOOD MS 39232 RANKIN (601) 932-1000 Acute Care Hospitals Proprietary FALSE 32.3258300 -90.1066560 0   121 28 28121 27140 Jackson-Vicksburg-Brookhaven, MS Central Rankin County https://data.medicare.gov/resource/xubh-q36u/row-zexx-5n4i.j66v 250136 648057 2019-05-16 2018-12-31 17           33               33
3008 MERCY HEALTH-ALLEN HOSPITAL 200 WEST LORAIN STREET OBERLIN OH 44074 LORAIN (440) 775-1211 Critical Access Hospitals Voluntary non-profit - Private TRUE 41.2942190 -82.2243840 0   93 39 39093 17460 Cleveland-Akron-Canton, OH Outlying Lorain County https://data.medicare.gov/resource/xubh-q36u/row-zexn~9nmw.e8zr 361306 648463 2019-05-20 2018-12-31 25           25               25
1112 SPRINGFIELD HOSPITAL PO BOX 2003 SPRINGFIELD VT 5156 WINDSOR (802) 885-2151 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.2981414 -72.4948662 1 ROOFTOP 27 50 50027 17200   Central Windsor County https://data.medicare.gov/resource/xubh-q36u/row-zewq-djn4-pp8m 471306 643749 2019-02-25 2018-09-30 25           25 10             35
3355 LEHIGH VALLEY HOSPITAL-SCHUYLKILL S. JACKSON STREE 420 SOUTH JACKSON STREET POTTSVILLE PA 17901 SCHUYLKILL (570) 621-5102 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.6837490 -76.1888580 0   107 42 42107 39060   Central Schuylkill County https://data.medicare.gov/resource/xubh-q36u/row-zepg~88ha_cuwa 390030 660010 2019-11-27 2019-06-30 108 10         118 50 18           186
474 MEMORIAL HOSPITAL OF CONVERSE COUNTY 111 SOUTH 5TH STREET DOUGLAS WY 82633 CONVERSE (307) 358-2122 Critical Access Hospitals Government - Local TRUE 42.7588050 -105.3812790 0   9 56 56009         https://data.medicare.gov/resource/xubh-q36u/row-zei4~mbih_rgkv 531302 662095 2019-12-03 2019-06-30 25           25               25
569 SCOTTSDALE SHEA MEDICAL CENTER 9003 EAST SHEA BOULEVARD SCOTTSDALE AZ 85260 MARICOPA (480) 323-3000 Acute Care Hospitals Proprietary TRUE 33.5824670 -111.8860320 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-zegy.nw3j~tfkb 30087 650231 2019-05-31 2018-12-31 378 25       24 427               427
2258 EASTERN NIAGARA HOSPITAL 521 EAST AVENUE LOCKPORT NY 14094 NIAGARA (716) 514-5700 Acute Care Hospitals Voluntary non-profit - Private TRUE 43.1763800 -78.6710750 0   63 36 36063 15380 Buffalo-Cheektowaga, NY Central Niagara County https://data.medicare.gov/resource/xubh-q36u/row-zebz.gdz9~iu6j 330163 650196 2019-05-30 2018-12-31 127 8         135               135
2051 ADVENTHEALTH TAMPA 3100 E FLETCHER AVE TAMPA FL 33613 HILLSBOROUGH (813) 615-7200 Acute Care Hospitals Voluntary non-profit - Private TRUE 28.0692260 -82.4245250 0   57 12 12057 45300   Central Hillsborough County https://data.medicare.gov/resource/xubh-q36u/row-zdje.si2f_dc2y 100173 656268 2019-10-28 2018-12-31 420 58         506   30           536
3688 MORRILL COUNTY COMMUNITY HOSPITAL 1313 S STREET BRIDGEPORT NE 69336 MORRILL (308) 262-1616 Critical Access Hospitals Government - Local TRUE 41.6618900 -103.0913740 0   123 31 31123         https://data.medicare.gov/resource/xubh-q36u/row-zd5w.8rx8_6yzu 281318 661038 2019-12-02 2019-06-30 20           20               20
861 MOUNT PLEASANT HOSPITAL 3510 HIGHWAY 17 NORTH SUITE 140 MOUNT PLEASANT SC 29466 CHARLESTON (843) 724-2954 Acute Care Hospitals Voluntary non-profit - Private TRUE 32.8780210 -79.7661990 0   19 45 45019 16700   Central Charleston County https://data.medicare.gov/resource/xubh-q36u/row-zcx7~rstm-bd4i 420104 650370 2019-05-29 2018-12-31 74 10         84               84
318 HURON REGIONAL MEDICAL CENTER 172 FOURTH STREET SE HURON SD 57350 BEADLE (605) 353-6200 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.3620350 -98.2107510 0   5 46 46005 26700   Central Beadle County https://data.medicare.gov/resource/xubh-q36u/row-zcx3~7b4g-9rji 431335 662256 2019-11-29 2019-06-30 19 6         25               25
833 PENOBSCOT VALLEY HOSPITAL 7 TRANSALPINE ROAD, PO BOX 368 LINCOLN ME 4457 PENOBSCOT (207) 794-3321 Critical Access Hospitals Voluntary non-profit - Private TRUE 45.3487330 -68.5162580 0   19 23 23019 12620   Central Penobscot County https://data.medicare.gov/resource/xubh-q36u/row-zcrj.qk59-ua67 201303 650480 2019-05-31 2018-12-31 25           25               25
2632 ASTRIA REGIONAL MEDICAL CENTER 110 SOUTH NINTH AVE YAKIMA WA 98902 YAKIMA (509) 575-5102 Acute Care Hospitals Proprietary TRUE 46.5979850 -120.5210960 0   77 53 53077 49420   Central Yakima County https://data.medicare.gov/resource/xubh-q36u/row-zbwg.834x-7vgp 500012 651302 2019-06-14 2018-12-31 113           113   15           128
2084 SOIN MEDICAL CENTER 3535 PENTAGON PARK BLVD BEAVER CREEK OH 45431 GREENE (937) 702-4000 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.7719470 -84.0627100 0   57 39 39057 19380 Dayton-Springfield-Sidney, OH Central Greene County https://data.medicare.gov/resource/xubh-q36u/row-zbwb_vkj8-m494 360360 651858 2019-07-03 2018-12-31 117 12         129               129
779 WEST CHESTER HOSPITAL, LLC 7700 UNIVERSITY DRIVE WEST CHESTER OH 45069 BUTLER (513) 298-7700 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.3582480 -84.3671700 0   17 39 39017 17140 Cincinnati-Wilmington-Maysville, OH-KY-IN Central Butler County https://data.medicare.gov/resource/xubh-q36u/row-zbwb-99pw~8xag 360354 661612 2019-12-03 2019-06-30 135 18         153               153
2564 ZUCKERBERG SAN FRANCISCO GENERAL HOSP & TRAUMA CTR 1001 POTRERO AVENUE SAN FRANCISCO CA 94110 SAN FRANCISCO (415) 206-8000 Acute Care Hospitals Government - Local TRUE 37.7561710 -122.4066080 0   75 6 6075 41860 San Jose-San Francisco-Oakland, CA Central San Francisco County https://data.medicare.gov/resource/xubh-q36u/row-zbv8_bttg_wjmw 50228 662022 2019-12-03 2019-06-30 213 58       13 284 83     30       397
2782 KAISER FOUNDATION HOSPITAL-SANTA CLARA 700 LAWRENCE EXPRESSWAY SANTA CLARA CA 95051 SANTA CLARA (408) 236-6400 Acute Care Hospitals Voluntary non-profit - Private TRUE 37.3354560 -121.9957670 0   85 6 6085 41940 San Jose-San Francisco-Oakland, CA Central Santa Clara County https://data.medicare.gov/resource/xubh-q36u/row-zbup-cmjk.by57 50071 649021 2019-06-06 2018-12-31 263 38         327               327
2030 STRONG MEMORIAL HOSPITAL 601 ELMWOOD AVE ROCHESTER NY 14642 MONROE (585) 275-2121 Acute Care Hospitals Voluntary non-profit - Private TRUE 43.1243940 -77.6236920 0   55 36 36055 40380 Rochester-Batavia-Seneca Falls, NY Central Monroe County https://data.medicare.gov/resource/xubh-q36u/row-zbcm_2wiq-86av 330285 661571 2019-12-13 2019-06-30 512 110   17   68 739 93 20           852
3148 BETHESDA HOSPITAL EAST 2815 S SEACREST BLVD BOYNTON BEACH FL 33435 PALM BEACH (561) 737-7733 Acute Care Hospitals Voluntary non-profit - Private TRUE 26.5040400 -80.0686800 0   99 12 12099 33100 Miami-Fort Lauderdale-Port St. Lucie, FL Central Palm Beach County https://data.medicare.gov/resource/xubh-q36u/row-zbar.2j9x~py5e 100002 654642 2019-09-17 2018-09-30 339 40 31       431   36           467
1920 ADVENTIST HEALTH PORTLAND 10123 SE MARKET STREET PORTLAND OR 97216 MULTNOMAH (503) 257-2500 Acute Care Hospitals Voluntary non-profit - Church TRUE 45.5115370 -122.5590930 0   51 41 41051 38900 Portland-Vancouver-Salem, OR-WA Central Multnomah County https://data.medicare.gov/resource/xubh-q36u/row-zb4z~fv5p-q8sy 380060 649341 2019-05-30 2018-12-31 156 12         168 43             211
1473 LAC+USC MEDICAL CENTER 1200 N STATE ST, ROOM C2K100 LOS ANGELES CA 90033 LOS ANGELES (323) 226-2800 Acute Care Hospitals Government - Local TRUE 34.0598720 -118.2103080 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-zb2x~3wn3~q6ug 50373 662473 2019-12-03 2019-06-30 396 128 10 20     594 76             670
661 BURNETT MEDICAL CENTER 257 W ST GEORGE AVE GRANTSBURG WI 54840 BURNETT (715) 463-5353 Critical Access Hospitals Voluntary non-profit - Private TRUE 45.7755460 -92.6871820 0   13 55 55013         https://data.medicare.gov/resource/xubh-q36u/row-zayf~pj6y.5spk 521331 641418 2019-01-24 2018-09-30 25           25       50       75
345 OROVILLE HOSPITAL 2767 OLIVE HIGHWAY OROVILLE CA 95966 BUTTE (530) 533-8500 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.5045350 -121.5421060 0   7 6 6007 17020   Central Butte County https://data.medicare.gov/resource/xubh-q36u/row-zach-cczm-89ek 50030 647860 2019-05-15 2018-11-30 123 10         133               133
4392 CHILLICOTHE HOSPITAL DISTRICT 303 AVENUE I CHILLICOTHE TX 79225 HARDEMAN (940) 852-5131 Critical Access Hospitals Government - Hospital District or Authority TRUE 34.2552390 -99.5159870 0   197 48 48197         https://data.medicare.gov/resource/xubh-q36u/row-za2j_kn4r_u56a 451326 662273 2019-12-19 2019-07-22 21           21               21
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
1618 HCA HOUSTON HEALTHCARE PEARLAND 11100 SHADOW CREEK PARKWAY PEARLAND TX 77584 BRAZORIA (713) 770-7000 Acute Care Hospitals Proprietary TRUE 29.5799940 -95.3919110 0   39 48 48039 26420 Houston-The Woodlands, TX Central Brazoria County https://data.medicare.gov/resource/xubh-q36u/row-z9yc-krd4-cpqc 670106 651121 2019-06-27 2019-01-31 41 8         49               49
3984 FREEMAN HEALTH SYSTEM - FREEMAN WEST 1102 WEST 32ND STREET JOPLIN MO 64804 JASPER (417) 347-1111 Acute Care Hospitals Voluntary non-profit - Private TRUE 37.0544080 -94.5268840 0   145 29 29145 27900 Joplin-Miami, MO-OK Outlying Newton County https://data.medicare.gov/resource/xubh-q36u/row-z9xx.uegx.4u5a 260137 654453 2019-09-05 2019-03-31 298 39       24 361 10 20           391
4752 NORTON COMMUNITY HOSPITAL 100 15TH NW STREET NORTON VA 24273 NORTON CITY (276) 439-1000 Acute Care Hospitals Voluntary non-profit - Private TRUE 36.9320310 -82.6433800 0   720 51 51720 13720   Central Norton city https://data.medicare.gov/resource/xubh-q36u/row-z9rr.uwbu~pseu 490001 643467 2019-02-22 2018-09-30 54 11         65   13           78
2799 STATEN ISLAND UNIVERSITY HOSPITAL 475 SEAVIEW AVENUE STATEN ISLAND NY 10305 RICHMOND (418) 226-9761 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.5840820 -74.0870130 0   85 36 36085 35620 New York-Newark, NY-NJ-CT-PA Central Richmond County https://data.medicare.gov/resource/xubh-q36u/row-z9rb.hyek_grbe 330160 650195 2019-06-18 2018-12-31 426 44 38 10   11 543 35 49           627
81 HALE HO'OLA HAMAKUA 45-547 PLUMERIA STREET HONOKAA HI 96727 HAWAII (808) 932-4100 Critical Access Hospitals Government - State TRUE 20.0762710 -155.4705950 0   1 15 15001 25900   Central Hawaii County https://data.medicare.gov/resource/xubh-q36u/row-z9jm-2idi-sq3z 121307 640366 2018-12-03 2018-06-30 11           11       66       77
2062 INDIANA UNIVERSITY HEALTH NORTH HOSPITAL 11700 N MERIDIAN ST CARMEL IN 46032 HAMILTON (317) 688-2000 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.9592750 -86.1623560 0   57 18 18057 26900 Indianapolis-Carmel-Muncie, IN Central Hamilton County https://data.medicare.gov/resource/xubh-q36u/row-z9gu_7wpc_cdy7 150161 649211 2019-05-31 2018-12-31 120           149               149
3412 COMMONWEALTH HEALTH CENTER 1 LOWER NAVY HILL ROAD (PO BOX 409CK) GARAPAN MP 96950 SAIPAN (670) 234-8950 Acute Care Hospitals Proprietary TRUE 15.2086299 145.7303467 1 GEOMETRIC_CENTER 110 69 69110         https://data.medicare.gov/resource/xubh-q36u/row-z8uz.de7b_sx86 660001 644688 2019-03-01 2018-09-30 70 4         74               74
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
3094 VISTA MEDICAL CENTER EAST 1324 NORTH SHERIDAN ROAD WAUKEGAN IL 60085 LAKE (847) 360-3000 Acute Care Hospitals Voluntary non-profit - Other FALSE 42.3782640 -87.8309640 0   97 17 17097 16980 Chicago-Naperville, IL-IN-WI Central Lake County https://data.medicare.gov/resource/xubh-q36u/row-z8h2_y3pv-w7sx 140084 653883 2019-08-27 2018-11-30 167 23         190               190
4324 WAYNE COUNTY HOSPITAL 417 SOUTH EAST STREET CORYDON IA 50060 WAYNE (641) 872-2260 Critical Access Hospitals Government - Local TRUE 40.7544920 -93.3123200 0   185 19 19185         https://data.medicare.gov/resource/xubh-q36u/row-z889-j4w6-dfyd 161358 660982 2019-11-27 2019-06-30 25           25               25
2815 BAYLOR SCOTT AND WHITE MEDICAL CENTER MCKINNEY 5252 WEST UNIVERSITY DRIVE MC KINNEY TX 75071 COLLIN (469) 764-2200 Acute Care Hospitals Voluntary non-profit - Private TRUE 33.2184040 -96.6810200 0   85 48 48085 19100 Dallas-Fort Worth, TX-OK Central Collin County https://data.medicare.gov/resource/xubh-q36u/row-z87n_qjyy.khsy 670082 660482 2019-11-27 2019-06-30 114 16       13 143               143
2392 SOUTH LAKE HOSPITAL 1900 DON WICKHAM DR CLERMONT FL 34711 LAKE (352) 394-4071 Acute Care Hospitals Government - Hospital District or Authority FALSE 28.5511780 -81.7234150 0   69 12 12069 36740 Orlando-Deltona-Daytona Beach, FL Outlying Lake County https://data.medicare.gov/resource/xubh-q36u/row-z7xz~yu83_5nfj 100051 661477 2019-11-25 2018-09-30 124 16         140       30       170
3259 EFFINGHAM HEALTH SYSTEM 459 GA HIGHWAY 119 SOUTH SPRINGFIELD GA 31329 EFFINGHAM (912) 754-0160 Critical Access Hospitals Government - Hospital District or Authority TRUE 32.3647340 -81.3216640 0   103 13 13103 42340 Savannah-Hinesville-Statesboro, GA Outlying Effingham County https://data.medicare.gov/resource/xubh-q36u/row-z7sk_s77h.2zrg 111306 661153 2019-12-09 2019-06-30 25           25       105       130
3222 ST CHRISTOPHER'S HOSPITAL FOR CHILDREN 160 EAST ERIE AVE PHILADELPHIA PA 19134 PHILADELPHIA (215) 427-5000 Childrens Proprietary TRUE 40.0074930 -75.1255350 0   101 42 42101 37980 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Philadelphia County https://data.medicare.gov/resource/xubh-q36u/row-z7p6.dkcr_rdax 393307 650206 2019-06-03 2018-12-31 115 44       29 188               188
3545 ST ANTHONY SUMMIT MEDICAL CENTER 340 PEAK ONE DRIVE FRISCO CO 80443 SUMMIT (970) 668-3300 Acute Care Hospitals Voluntary non-profit - Church FALSE 39.5699880 -106.0782590 0   117 8 8117 14720   Central Summit County https://data.medicare.gov/resource/xubh-q36u/row-z7ad.cmh5-5ysx 60118 654908 2019-10-10 2019-06-30 26 8         34               34
2330 WAR MEMORIAL HOSPITAL INC 1 HEALTHY WAY BERKELEY SPRINGS WV 25411 MORGAN (304) 258-1234 Critical Access Hospitals Voluntary non-profit - Private TRUE 39.6409230 -78.1998700 0   65 54 54065         https://data.medicare.gov/resource/xubh-q36u/row-z76q-7r93.w77s 511309 648370 2019-05-09 2018-12-31 25           25         16     41
394 CASTLEVIEW HOSPITAL 300 NORTH HOSPITAL DRIVE PRICE UT 84501 CARBON (435) 637-4800 Acute Care Hospitals Proprietary TRUE 39.6054020 -110.8319110 0   7 49 49007 39220   Central Carbon County https://data.medicare.gov/resource/xubh-q36u/row-z6mk.zxuw_qeet 460011 651250 2019-06-03 2018-12-31 33 6         39               39
4207 ST FRANCIS MEDICAL CENTER 2400 ST FRANCIS DRIVE BRECKENRIDGE MN 56520 WILKIN (218) 643-3000 Critical Access Hospitals Voluntary non-profit - Church TRUE 46.2913140 -96.5904330 0   167 27 27167 47420 Fargo-Wahpeton, ND-MN Outlying Wilkin County https://data.medicare.gov/resource/xubh-q36u/row-z674~sdts.8mhw 241377 661740 2019-12-03 2019-06-30 25           25       80       105
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
556 ARIZONA SPECIALTY HOSPITAL 2905 WEST WARNER ROAD, SUITE 1 CHANDLER AZ 85224 MARICOPA (480) 603-9000 Acute Care Hospitals Proprietary FALSE 33.3348400 -111.8911330 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-z5xq-7gkm.mjtq 30112 649698 2019-05-22 2018-12-31 24           24               24
2699 ST ELIZABETH GRANT 238 BARNES ROAD WILLIAMSTOWN KY 41097 GRANT (859) 824-8105 Critical Access Hospitals Voluntary non-profit - Church TRUE 38.6478620 -84.5782640 0   81 21 21081 17140 Cincinnati-Wilmington-Maysville, OH-KY-IN Outlying Grant County https://data.medicare.gov/resource/xubh-q36u/row-z5ru.drf8.yem5 181311 648696 2019-05-24 2018-12-31 15           15               15
2386 HAZEL HAWKINS MEMORIAL HOSPITAL 911 SUNSET DRIVE HOLLISTER CA 95023 SAN BENITO (831) 637-5711 Acute Care Hospitals Government - Hospital District or Authority FALSE 36.8351220 -121.3866200 0   69 6 6069 41940 San Jose-San Francisco-Oakland, CA Outlying San Benito County https://data.medicare.gov/resource/xubh-q36u/row-z5mt_ehjz~v7xh 50296 661288 2019-12-02 2019-06-30 41 8         49       119       168
3470 LINDSBORG COMMUNITY HOSPITAL 605 W LINCOLN STREET LINDSBORG KS 67456 MCPHERSON (785) 227-3308 Critical Access Hospitals Voluntary non-profit - Private TRUE 38.5734350 -97.6835900 0   113 20 20113 32700   Central McPherson County https://data.medicare.gov/resource/xubh-q36u/row-z5m8.2c5c.9xk5 171358 645086 2019-02-28 2018-09-30 23           23               23
4162 CHILDREN'S HOSPITAL OF MICHIGAN 3901 BEAUBIEN STREET DETROIT MI 48201 WAYNE (313) 745-5437 Childrens Proprietary TRUE 42.3518160 -83.0537500 0   163 26 26163 19820 Detroit-Warren-Ann Arbor, MI Central Wayne County https://data.medicare.gov/resource/xubh-q36u/row-z5kc-2ncc~crci 233300 649116 2019-05-30 2018-12-31 122 48   19   39 228               228
2434 MOUNTAINS COMMUNITY HOSPITAL 29101 HOSPITAL ROAD LAKE ARROWHEAD CA 92352 SAN BERNARDINO (909) 336-3651 Critical Access Hospitals Government - Hospital District or Authority TRUE 34.2659000 -117.1670920 0   71 6 6071 40140 Los Angeles-Long Beach, CA Central San Bernardino County https://data.medicare.gov/resource/xubh-q36u/row-z5bb_6v2j.847b 51312 659479 2019-01-07 2018-06-30 17           17       20       37
3525 REDMOND REGIONAL MEDICAL CENTER 501 REDMOND ROAD ROME GA 30165 FLOYD (706) 802-3012 Acute Care Hospitals Proprietary TRUE 34.2781910 -85.1941310 0   115 13 13115 40660 Rome-Summerville, GA Central Floyd County https://data.medicare.gov/resource/xubh-q36u/row-z5aw~bjka~vbtd 110168 659773 2019-11-25 2019-06-30 168 16 24       208   20           228
1269 ADVENTIST HEALTHCARE SHADY GROVE MEDICAL CENTER 9901 MEDICAL CENTER DRIVE ROCKVILLE MD 20850 MONTGOMERY (240) 826-6527 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.0980460 -77.2010270 0   31 24 24031 47900 Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Central Montgomery County https://data.medicare.gov/resource/xubh-q36u/row-z5ai-uwvz~ja8i 210057 649038 2019-05-31 2018-12-31 280 27         338               338
885 PHYSICIANS REGIONAL MEDICAL CENTER - PINE RIDGE 6101 PINE RIDGE ROAD NAPLES FL 34119 COLLIER (239) 348-4000 Acute Care Hospitals Proprietary TRUE 26.2117640 -81.7307070 0   21 12 12021 34940 Cape Coral-Fort Myers-Naples, FL Central Collier County https://data.medicare.gov/resource/xubh-q36u/row-z54t-v8nq.fk93 100286 643693 2019-02-28 2018-09-30 177 24         201               201
3278 HUNTINGTON HOSPITAL 270 PARK AVENUE HUNTINGTON NY 11743 SUFFOLK (631) 351-2000 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.8792010 -73.4174880 0   103 36 36103 35620 New York-Newark, NY-NJ-CT-PA Central Suffolk County https://data.medicare.gov/resource/xubh-q36u/row-z4qi-a9jr_j8pn 330045 649935 2019-05-30 2018-12-31 224 26         259 21             280
1099 NORMAN REGIONAL 901 N PORTER NORMAN OK 73070 CLEVELAND (405) 307-1050 Acute Care Hospitals Government - Hospital District or Authority TRUE 35.2302570 -97.4411170 0   27 40 40027 36420 Oklahoma City-Shawnee, OK Central Cleveland County https://data.medicare.gov/resource/xubh-q36u/row-z4m8-r75w.my3r 370008 660139 2019-12-02 2019-06-30 254 52 25       331 20 30           381
63 STAMFORD HOSPITAL ONE HOSPITAL PLAZA STAMFORD CT 6904 FAIRFIELD (203) 276-1000 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.0544448 -73.5522909 1 ROOFTOP 1 9 9001 14860 New York-Newark, NY-NJ-CT-PA Central Fairfield County https://data.medicare.gov/resource/xubh-q36u/row-z4bk-5sz6.bqpu 70006 644101 2019-03-04 2018-09-30 252 36         288   17           305
67 GREENWICH HOSPITAL ASSOCIATION - 5 PERRYRIDGE RD GREENWICH CT 6830 FAIRFIELD (203) 863-3000 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.0343950 -73.6296320 0   1 9 9001 14860 New York-Newark, NY-NJ-CT-PA Central Fairfield County https://data.medicare.gov/resource/xubh-q36u/row-z487-bxe7-a8jv 70018 644223 2019-02-27 2018-09-30 161 10       10 181               181
2989 MERCY MEDICAL CENTER MT SHASTA 914 PINE STREET MOUNT SHASTA CA 96067 SISKIYOU (530) 926-6111 Critical Access Hospitals Voluntary non-profit - Other TRUE 41.3177640 -122.3215540 0   93 6 6093         https://data.medicare.gov/resource/xubh-q36u/row-z3p6.8j4z_mz6s 51319 662174 2019-12-03 2019-06-30 21 4         25               25
707 CARNEGIE TRI-COUNTY MUNICIPAL HOSPITAL 102 NORTH BROADWAY CARNEGIE OK 73015 CADDO (580) 654-1050 Critical Access Hospitals Government - Hospital District or Authority TRUE 35.1075540 -98.6049180 0   15 40 40015         https://data.medicare.gov/resource/xubh-q36u/row-z387~mqsi.t58v 371334 654941 2019-10-02 2019-04-30 17           17               17
1533 GEORGE E WEEMS MEMORIAL HOSPITAL 135 AVE G APALACHICOLA FL 32320 FRANKLIN (850) 653-8853 Critical Access Hospitals Government - Local TRUE 29.7244840 -84.9912750 0   37 12 12037         https://data.medicare.gov/resource/xubh-q36u/row-z2w8_ts6n.p4qb 101305 644253 2019-03-04 2018-09-30 25           25               25
4290 ATRIUM HEALTH UNION 600 HOSPITAL DR MONROE NC 28112 UNION (704) 283-3100 Acute Care Hospitals Government - Hospital District or Authority TRUE 34.9751110 -80.5228530 0   179 37 37179 16740 Charlotte-Concord, NC-SC Central Union County https://data.medicare.gov/resource/xubh-q36u/row-z2m5~mpse-nkc2 340130 650345 2019-05-30 2018-12-31 164 14       4 182       70       252
2302 MERCYONE OELWEIN MEDICAL CENTER 201 EIGHTH AVENUE SE OELWEIN IA 50662 FAYETTE (319) 283-6000 Critical Access Hospitals Voluntary non-profit - Church TRUE 42.6754190 -91.9026130 0   65 19 19065         https://data.medicare.gov/resource/xubh-q36u/row-z2fd.d4q8-bgsq 161338 659570 2019-11-19 2019-06-30 25           25       39       64
518 SOUTHERN NH MEDICAL CENTER 8 PROSPECT STREET NASHUA NH 3060 HILLSBOROUGH (603) 577-2000 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.7560610 -71.4612290 0   11 33 33011 31700 Boston-Worcester-Providence, MA-RI-NH-CT Central Hillsborough County https://data.medicare.gov/resource/xubh-q36u/row-z29g.nws7.yp8q 300020 659990 2019-11-25 2019-06-30 131 11         142 18             160
2177 SUTTER AUBURN FAITH HOSPITAL 11815 EDUCATION STREET AUBURN CA 95603 PLACER (530) 888-4500 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.9443170 -121.0994230 0   61 6 6061 40900 Sacramento-Roseville, CA Central Placer County https://data.medicare.gov/resource/xubh-q36u/row-z26g.4uvw-2fvu 50498 650954 2019-06-03 2018-12-31 56 8         64               64
1441 SHRINERS HOSPITALS FOR CHILDREN - SALT LAKE CITY 1275 EAST FAIRFAX ROAD SALT LAKE CITY UT 84103 SALT LAKE (801) 536-3500 Childrens Voluntary non-profit - Private FALSE 40.7767640 -111.8511170 0   35 49 49035 41620 Salt Lake City-Provo-Orem, UT Central Salt Lake County https://data.medicare.gov/resource/xubh-q36u/row-z268_bq8t.wgx8 463302 651875 2018-05-31 2017-12-31                              
2906 OUR LADY OF BELLEFONTE HOSPITAL 1000 SAINT CHRISTOPHER DRIVE ASHLAND KY 41101 BOYD (606) 833-3600 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.5093030 -82.6930500 0   89 21 21089 26580 Charleston-Huntington-Ashland, WV-OH-KY Central Greenup County https://data.medicare.gov/resource/xubh-q36u/row-z22m~jns9.wzpj 180036 660996 2019-01-25 2018-08-31 123 12         135 16             151
1183 SOUTHWEST GENERAL HOSPITAL 7400 BARLITE BLVD SAN ANTONIO TX 78224 BEXAR (210) 921-2000 Acute Care Hospitals Physician TRUE 29.3529880 -98.5465890 0   29 48 48029 41700   Central Bexar County https://data.medicare.gov/resource/xubh-q36u/row-yzdz.2e4a_mcwd 450697 644371 2019-02-28 2018-09-30 143 18       24 185 24 16           225
2808 GROVE CITY MEDICAL CENTER 631 NORTH BROAD STREET EXT. GROVE CITY PA 16127 MERCER (724) 450-7000 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.1707090 -80.0831560 0   85 42 42085 49660 Youngstown-Warren, OH-PA Central Mercer County https://data.medicare.gov/resource/xubh-q36u/row-yz3r~nbsv~fu63 390266 661100 2019-11-27 2019-06-30 69 8         77               77
3309 JONES REGIONAL MEDICAL CENTER 1795 HIGHWAY 64 EAST ANAMOSA IA 52205 JONES (319) 462-6131 Critical Access Hospitals Voluntary non-profit - Private TRUE 42.1022310 -91.2619190 0   105 19 19105 16300 Cedar Rapids-Iowa City, IA Outlying Jones County https://data.medicare.gov/resource/xubh-q36u/row-yypi~g9ve~bgmy 161306 646554 2019-04-01 2018-12-31 22           22               22
3464 ADVOCATE BROMENN MEDICAL CENTER 1304 FRANKLIN AVENUE NORMAL IL 61761 MC LEAN (309) 454-1400 Acute Care Hospitals Voluntary non-profit - Church TRUE 40.4963320 -88.9909600 0   113 17 17113 14010 Bloomington-Pontiac, IL Central McLean County https://data.medicare.gov/resource/xubh-q36u/row-yyk7.wts2-z6re 140127 650688 2019-05-30 2018-12-31 176 30         206   15           221
643 ST CHARLES PRINEVILLE 384 SE COMBS FLAT ROAD PRINEVILLE OR 97754 CROOK (541) 447-6254 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.2980930 -120.8269680 0   13 41 41013 39260 Bend-Redmond-Prineville, OR Central Crook County https://data.medicare.gov/resource/xubh-q36u/row-yy7v_qhni~xpgc 381313 651052 2019-06-03 2018-12-31 16           16               16
3562 BAPTIST MEMORIAL HOSPITAL BOONEVILLE 100 HOSPITAL DRIVE BOONEVILLE MS 38829 PRENTISS (662) 720-5000 Acute Care Hospitals Voluntary non-profit - Church TRUE 34.6563370 -88.5657630 0   117 28 28117         https://data.medicare.gov/resource/xubh-q36u/row-yxvp-p3fk_sfj3 250044 644040 2019-02-26 2018-09-30 28   11       39 15             54
4440 HOUSTON PHYSICIANS' HOSPITAL 333 N TEXAS AVENUE WEBSTER TX 77598 HARRIS (281) 335-1700 Acute Care Hospitals Physician TRUE 29.5349020 -95.1257850 0   201 48 48201 26420 Houston-The Woodlands, TX Central Harris County https://data.medicare.gov/resource/xubh-q36u/row-yxt9~vqzu.mhqf 670008 649528 2019-05-31 2018-12-31 21           21               21
387 LANDMARK MEDICAL CENTER 115 CASS AVENUE WOONSOCKET RI 2895 PROVIDENCE (401) 769-4100 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.0053200 -71.4962100 0   7 44 44007 39300 Boston-Worcester-Providence, MA-RI-NH-CT Central Providence County https://data.medicare.gov/resource/xubh-q36u/row-ywvs_4dtp_6u43 410011 649821 2019-06-03 2018-12-31 107 16         123 18             141
1857 MOUNT CARMEL NEW ALBANY SURGICAL HOSPITAL 7333 SMITH'S MILL ROAD NEW ALBANY OH 43054 FRANKLIN (614) 775-6600 Acute Care Hospitals Proprietary FALSE 40.0863030 -82.7887930 0   49 39 39049 18140 Columbus-Marion-Zanesville, OH Central Franklin County https://data.medicare.gov/resource/xubh-q36u/row-ywvf~p2gq~kk8u 360266 660674 2019-11-26 2019-06-30 60           60               60
1508 EMANATE HEALTH INTER-COMMUNITY HOSPITAL 210 W SAN BERNARDINO ROAD COVINA CA 91723 LOS ANGELES (626) 814-2468 Acute Care Hospitals Proprietary TRUE 34.0899470 -117.8936660 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-ywn3.ebem-km5h 50382 650652 2019-05-31 2018-12-31 401 20 20     40 481   12   23   10   526
1333 UNIVERSITY OF MD LAUREL REGIONAL HOSPITAL 7300 VAN DUSEN ROAD LAUREL MD 20707 PRINCE GEORGES (301) 725-4300 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.0847420 -76.8815910 0   33 24 24033 47900 Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Central Prince George's County https://data.medicare.gov/resource/xubh-q36u/row-ywid-ffi4~zuvt 210055 654730 2019-09-23 2019-01-01 114 10         124               124
3498 CHILDRENS MEDICAL CTR OF DALLAS 1935 MEDICAL DISTRICT DRIVE DALLAS TX 75235 DALLAS (214) 456-7000 Childrens Voluntary non-profit - Private TRUE 32.8083590 -96.8368370 0   113 48 48113 19100 Dallas-Fort Worth, TX-OK Central Dallas County https://data.medicare.gov/resource/xubh-q36u/row-yvxv~v5b3.xbk2 453302 647592 2019-05-10 2018-12-31 261           398               398
2756 HARLAN COUNTY HEALTH SYSTEM P O BOX 836, 717 NORTH BROWN ST ALMA NE 68920 HARLAN (308) 928-2151 Critical Access Hospitals Government - Local TRUE 40.0981797 -99.3631677 1 ROOFTOP 83 31 31083         https://data.medicare.gov/resource/xubh-q36u/row-yvs4.45jj.87ms 281300 647189 2019-04-23 2018-12-31 19           19               19
739 SHRINERS HOSPITALS FOR CHILDREN 3100 SAMFORD AVENUE SHREVEPORT LA 71103 CADDO (318) 222-5704 Childrens Voluntary non-profit - Private FALSE 32.4812950 -93.7566370 0   17 22 22017 43340   Central Caddo Parish https://data.medicare.gov/resource/xubh-q36u/row-yvmb~28rx-rdcg 193301 647125 2018-05-31 2017-12-31                              
2953 OLATHE MEDICAL CENTER 20333 WEST 151ST STREET OLATHE KS 66061 JOHNSON (913) 791-4200 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.8545240 -94.8236730 0   91 20 20091 28140 Kansas City-Overland Park-Kansas City, MO-KS Central Johnson County https://data.medicare.gov/resource/xubh-q36u/row-yvea.ybd3_rygq 170049 649223 2019-05-31 2018-12-31 223 20 11       254           11   265
3206 MUNSON HEALTHCARE MANISTEE HOSPITAL 1465 E PARKDALE AVE MANISTEE MI 49660 MANISTEE (231) 398-1000 Acute Care Hospitals Voluntary non-profit - Other TRUE 44.2723550 -86.2734390 0   101 26 26101         https://data.medicare.gov/resource/xubh-q36u/row-yvaj-xucr.6ih7 230303 660597 2019-11-27 2019-06-30 45           45               45
803 NORTHWEST MEDICAL CENTER 6200 NORTH LA CHOLLA BOULEVARD TUCSON AZ 85741 PIMA (520) 469-8100 Acute Care Hospitals Proprietary TRUE 32.3195810 -111.0120540 0   19 4 4019 46060 Tucson-Nogales, AZ Central Pima County https://data.medicare.gov/resource/xubh-q36u/row-yv8p.eeec-pmxw 30085 646415 2019-03-28 2018-09-30 231 35         281   13           294
658 VIRGINIA HOSPITAL CENTER 1701 NORTH GEORGE MASON DRIVE ARLINGTON VA 22205 ARLINGTON (703) 558-5000 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.8890880 -77.1286540 0   13 51 51013 47900 Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Central Arlington County https://data.medicare.gov/resource/xubh-q36u/row-yv5z_yfdt_8kuh 490050 651730 2019-06-27 2018-12-31 258 32         305 40 20           365
4090 NORTHRIDGE MEDICAL CENTER 70 MEDICAL CENTER DRIVE COMMERCE GA 30529 JACKSON (706) 335-1100 Acute Care Hospitals Government - Hospital District or Authority TRUE 34.2184750 -83.4691160 0   157 13 13157 27600 Atlanta--Athens-Clarke County--Sandy Springs, GA Central Jackson County https://data.medicare.gov/resource/xubh-q36u/row-yv5y.6t83_jg9y 110040 651124 2019-05-29 2018-12-31 28           28       167       195
2275 MULTICARE DEACONESS HOSPITAL W 800 FIFTH AVENUE SPOKANE WA 99210 SPOKANE (509) 473-5800 Acute Care Hospitals Voluntary non-profit - Private TRUE 47.6520746 -117.4232235 1 ROOFTOP 63 53 53063 44060 Spokane-Spokane Valley-Coeur d'Alene, WA-ID Central Spokane County https://data.medicare.gov/resource/xubh-q36u/row-yuz3-454p_9mcv 500044 646412 2019-03-28 2018-12-31 184 35         267               267
3444 ELLENVILLE REGIONAL HOSPITAL 10 HEALTHY WAY ELLENVILLE NY 12428 ULSTER (845) 647-6400 Critical Access Hospitals Voluntary non-profit - Private TRUE 41.7323510 -74.3806240 0   111 36 36111 28740 New York-Newark, NY-NJ-CT-PA Central Ulster County https://data.medicare.gov/resource/xubh-q36u/row-yusu_wb8x.4xxv 331310 655468 2019-10-07 2018-12-31 15           15               15
2012 MUNSON MEDICAL CENTER 1105 SIXTH STREET TRAVERSE CITY MI 49684 GRAND TRAVERSE (231) 935-5000 Acute Care Hospitals Voluntary non-profit - Other TRUE 44.7616450 -85.6415880 0   55 26 26055 45900   Central Grand Traverse County https://data.medicare.gov/resource/xubh-q36u/row-ytzp_khah~df5e 230097 660589 2019-11-27 2019-06-30 377 20         409 17 16           442
1244 PRESENCE SAINT FRANCIS HOSPITAL 355 RIDGE AVE EVANSTON IL 60202 COOK (847) 316-4000 Acute Care Hospitals Voluntary non-profit - Church TRUE 42.0239510 -87.6851590 0   31 17 17031 16980 Chicago-Naperville, IL-IN-WI Central Cook County https://data.medicare.gov/resource/xubh-q36u/row-ytv8~95dy~j47j 140080 662040 2019-12-02 2019-06-30 155 16         181               181
119 SAINT ALPHONSUS MEDICAL CENTER - BAKER CITY, INC 3325 POCAHONTAS ROAD BAKER CITY OR 97814 BAKER (541) 524-7744 Critical Access Hospitals Voluntary non-profit - Church TRUE 44.7961200 -117.8462850 0   1 41 41001         https://data.medicare.gov/resource/xubh-q36u/row-yt65-wbpr_7cai 381315 661086 2019-12-02 2019-06-30 19 2         21               21
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
4402 SAINT ANTHONY MEDICAL CENTER 5666 EAST STATE STREET ROCKFORD IL 61108 WINNEBAGO (815) 226-2000 Acute Care Hospitals Voluntary non-profit - Church TRUE 42.2657780 -89.0073000 0   201 17 17201 40420 Rockford-Freeport-Rochelle, IL Central Winnebago County https://data.medicare.gov/resource/xubh-q36u/row-ysyd_rgwd_tbfu 140233 659948 2019-11-15 2018-09-30 210 38         248               248
351 SAMUEL MAHELONA MEMORIAL HOSPITAL 4800 KAWAIHAU ROAD KAPAA HI 96746 KAUAI (808) 822-4961 Critical Access Hospitals Government - State TRUE 22.0876190 -159.3142040 0   7 15 15007 28180   Central Kauai County https://data.medicare.gov/resource/xubh-q36u/row-ysve.ycbm-b3qy 121306 640504 2018-11-30 2018-06-30 5           5 9     66       80
2379 PROVIDENCE ST PETER HOSPITAL 413 LILLY ROAD NE OLYMPIA WA 98506 THURSTON (360) 491-9480 Acute Care Hospitals Voluntary non-profit - Private TRUE 47.0527910 -122.8443690 0   67 53 53067 36500 Seattle-Tacoma, WA Central Thurston County https://data.medicare.gov/resource/xubh-q36u/row-yspj-qfjt_zn5p 500024 648785 2019-05-29 2018-12-31 262 42         304 18             322

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