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

383 rows where "filed_date" is on date 2019-05-31 sorted by csatitle

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: hospital_type, hospital_ownership, emergency_services, geocode_flag, geocode_accuracy, centraloutlyingcounty, coronary_beds, burn_beds, surg_icu_beds, subprovider_irf_beds, subprovider_oth_beds, nursing_fac_beds, oth_longterm_beds, fy_end_date (date)

filed_date (date) ✖

  • 2019-05-31 · 383 ✖
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
7 7 DOWN EAST COMMUNITY HOSPITAL 11 HOSPITAL DRIVE MACHIAS ME 4654 WASHINGTON (207) 255-3356 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.7134110 -67.4772030 0   29 23 23029         https://data.medicare.gov/resource/xubh-q36u/row-tmd2.zxhs~phzc 201311 650481 2019-05-31 2018-12-31 25           25               25
42 42 BAPTIST HEALTH MEDICAL CENTER-STUTTGART 1703 NORTH BUERKLE ST STUTTGART AR 72160 ARKANSAS (870) 673-3511 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.5177730 -91.5575720 0   1 5 5001         https://data.medicare.gov/resource/xubh-q36u/row-rh96.h2uy.6pb9 40072 649864 2019-05-31 2018-12-31 49           49               49
127 127 RIVERSIDE SHORE MEMORIAL HOSPITAL 20480 MARKET STREET ONANCOCK VA 23417 ACCOMACK (757) 414-8000 Acute Care Hospitals Voluntary non-profit - Private TRUE 37.6997120 -75.7209370 0   1 51 51001         https://data.medicare.gov/resource/xubh-q36u/row-w6kr~hh5i_py3g 490037 650393 2019-05-31 2018-12-31 36 10         46               46
130 130 BROADDUS HOSPITAL ASSOCIATION, INC 1 HEALTHCARE DRIVE MANSFIELD HILL PHILIPPI WV 26416 BARBOUR (304) 457-1760 Critical Access Hospitals Voluntary non-profit - Private TRUE 39.1528870 -80.0440910 0   1 54 54001         https://data.medicare.gov/resource/xubh-q36u/row-njqv~ij6d.yec2 511300 650429 2019-05-31 2018-12-31 12           12       60       72
131 131 MOUNDVIEW MEMORIAL HOSPITAL AND CLINICS 402 W LAKE ST FRIENDSHIP WI 53934 ADAMS (608) 339-3331 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.9739950 -89.8210260 0   1 55 55001         https://data.medicare.gov/resource/xubh-q36u/row-b3gp.589m.s6jc 521309 650550 2019-05-31 2018-12-31 25           25               25
176 176 CARY MEDICAL CENTER 163 VAN BUREN RD, SUITE 1 CARIBOU ME 4736 AROOSTOOK (207) 498-3111 Acute Care Hospitals Government - Local TRUE 46.8782370 -68.0096390 0   3 23 23003         https://data.medicare.gov/resource/xubh-q36u/row-3dpx.x267~9y3n 200031 650153 2019-05-31 2018-12-31 43 6         49               49
248 248 MARTHA JEFFERSON HOSPITAL 500 MARTHA JEFFERSON DRIVE CHARLOTTESVILLE VA 22911 ALBEMARLE (434) 654-7000 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.0251060 -78.4448550 0   3 51 51003 16820   Central Albemarle County https://data.medicare.gov/resource/xubh-q36u/row-wyg5~56zu_3ctd 490077 650406 2019-05-31 2018-12-31 138 12         150               150
258 258 BAXTER REGIONAL MEDICAL CENTER 624 HOSPITAL DRIVE MOUNTAIN HOME AR 72653 BAXTER (870) 508-1000 Acute Care Hospitals Voluntary non-profit - Private TRUE 36.3430670 -92.3959050 0   5 5 5005 34260   Central Baxter County https://data.medicare.gov/resource/xubh-q36u/row-pjhy~i9v2.r6ud 40027 650559 2019-05-31 2018-12-31 153 17         170 19 23       12   224
268 268 ASCENSION SACRED HEART BAY 615 N BONITA AVE PANAMA CITY FL 32401 BAY (850) 769-1511 Acute Care Hospitals Government - Hospital District or Authority TRUE 30.1596810 -85.6470670 0   5 12 12005 37460   Central Bay County https://data.medicare.gov/resource/xubh-q36u/row-sfb2_87vw-qbr7 100026 650248 2019-05-31 2018-12-31 236 57         293               293
320 320 WOODLAND HEIGHTS MEDICAL CENTER 505 SOUTH JOHN REDDITT DRIVE LUFKIN TX 75904 ANGELINA (936) 634-8311 Acute Care Hospitals Proprietary TRUE 31.3277370 -94.7561390 0   5 48 48005 31260   Central Angelina County https://data.medicare.gov/resource/xubh-q36u/row-2twc-7b9d-f8nh 450484 649671 2019-05-31 2018-12-31 115 15         145               145
322 322 LOGAN REGIONAL HOSPITAL 500 EAST 1400 NORTH LOGAN UT 84341 CACHE (435) 716-1000 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.7574610 -111.8228770 0   5 49 49005 30860   Central Cache County https://data.medicare.gov/resource/xubh-q36u/row-248k.jdp3-ibnu 460015 649977 2019-05-31 2018-12-31 83 14       33 130 7     14       151
326 326 PROSSER MEMORIAL HOSPITAL 723 MEMORIAL STREET PROSSER WA 99350 BENTON (509) 786-2222 Critical Access Hospitals Government - Hospital District or Authority TRUE 46.2076300 -119.7635020 0   5 53 53005 28420   Central Benton County https://data.medicare.gov/resource/xubh-q36u/row-jxdy-bhag~5gk3 501312 652444 2019-05-31 2018-12-31 25           25               25
342 342 ADVENTIST HEALTH FEATHER RIVER 5974 PENTZ ROAD PARADISE CA 95969 BUTTE (530) 877-9361 Acute Care Hospitals Voluntary non-profit - Church TRUE 39.7561610 -121.5723050 0   7 6 6007 17020   Central Butte County https://data.medicare.gov/resource/xubh-q36u/row-dx3c~3bgg.9vjq 50225 659201 2019-05-31 2018-12-31                              
357 357 FRANKLIN MEMORIAL HOSPITAL 111 FRANKLIN HEALTH COMMONS FARMINGTON ME 4938 FRANKLIN (207) 778-6031 Acute Care Hospitals Voluntary non-profit - Private TRUE 44.6251150 -70.1612440 0   7 23 23007         https://data.medicare.gov/resource/xubh-q36u/row-5fiv_edxs-8b6w 200037 650477 2019-05-31 2018-12-31 43 5         48               48
396 396 CONFLUENCE HEALTH- WENATCHEE VALLEY HOSP & CLINICS 820 NORTH CHELAN AVENUE WENATCHEE WA 98801 CHELAN (509) 663-8711 Acute Care Hospitals Voluntary non-profit - Private FALSE 47.4335660 -120.3219830 0   7 53 53007 48300   Central Chelan County https://data.medicare.gov/resource/xubh-q36u/row-aiqi_mn7n_vecf 500148 650791 2019-05-31 2018-12-31 11           11   9           20
416 416 STEWARD ROCKLEDGE HOSPITAL 110 LONGWOOD AVE ROCKLEDGE FL 32955 BREVARD (321) 637-2603 Acute Care Hospitals Proprietary TRUE 28.3345400 -80.7231330 0   9 12 12009 37340   Central Brevard County https://data.medicare.gov/resource/xubh-q36u/row-tbme~t6bb.jqha 100092 649413 2019-05-31 2018-12-31 243 31         274 24             298
417 417 STEWARD MELBOURNE HOSPITAL 250 NORTH WICKHAM ROAD MELBOURNE FL 32935 BREVARD (321) 752-1200 Acute Care Hospitals Proprietary TRUE 28.1098040 -80.6726100 0   9 12 12009 37340   Central Brevard County https://data.medicare.gov/resource/xubh-q36u/row-fnh8.cjxx_ncpd 100291 649425 2019-05-31 2018-12-31 101 12         113               113
539 539 PHOENIX CHILDREN'S HOSPITAL 1919 EAST THOMAS ROAD PHOENIX AZ 85016 MARICOPA (602) 933-1000 Childrens Voluntary non-profit - Private FALSE 33.4802160 -112.0411930 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-feed_vt9a~9ie7 33302 650636 2019-05-31 2018-12-31 352           433               433
550 550 HONORHEALTH DEER VALLEY MEDICAL CENTER 19829 NORTH 27TH AVENUE PHOENIX AZ 85027 MARICOPA (623) 879-6100 Acute Care Hospitals Voluntary non-profit - Private TRUE 33.6664250 -112.1171880 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-npyt_2wmd.v5z4 30092 650232 2019-05-31 2018-12-31 172   32       204               204
551 551 SCOTTSDALE THOMPSON PEAK MEDICAL CENTER 7400 EAST THOMPSON PEAK PARKWAY SCOTTSDALE AZ 85255 MARICOPA (480) 324-7001 Acute Care Hospitals Proprietary TRUE 33.6697770 -111.9218030 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-y7bn~8g49_tr6b 30123 650235 2019-05-31 2018-12-31 112 8         120               120
555 555 SCOTTSDALE OSBORN MEDICAL CENTER 7400 EAST OSBORN ROAD SCOTTSDALE AZ 85251 MARICOPA (480) 882-4004 Acute Care Hospitals Proprietary TRUE 33.4876390 -111.9227250 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-xncf.ukg7_66e2 30038 650230 2019-05-31 2018-12-31 268 59         327   14           341
558 558 JOHN C. LINCOLN NORTH MOUNTAIN HOSPITAL 250 EAST DUNLAP AVENUE PHOENIX AZ 85020 MARICOPA (602) 331-5862 Acute Care Hospitals Voluntary non-profit - Private TRUE 33.5677540 -112.0706300 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-9bpm.fdh7~5snu 30014 650229 2019-05-31 2018-12-31 218 20 24       262               262
569 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
608 608 PENOBSCOT BAY MEDICAL CENTER 6 GLEN COVE DRIVE ROCKPORT ME 4856 KNOX (207) 921-8000 Acute Care Hospitals Voluntary non-profit - Private TRUE 44.1444340 -69.0865370 0   13 23 23013         https://data.medicare.gov/resource/xubh-q36u/row-ahvj_huyh~m44w 200063 650478 2019-05-31 2018-12-31 73 8         81       84       165
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
648 648 HILTON HEAD REGIONAL MEDICAL CENTER 25 HOSPITAL CENTER BLVD HILTON HEAD ISLAND SC 29925 BEAUFORT (843) 681-6122 Acute Care Hospitals Proprietary TRUE 32.2193200 -80.7125000 0   13 45 45013 25940   Central Beaufort County https://data.medicare.gov/resource/xubh-q36u/row-twij.hnjd-wm9w 420080 651483 2019-05-31 2018-12-31 81 12         93               93
685 685 LINCOLN HEALTH 35 MILES STREET DAMARISCOTTA ME 4543 LINCOLN (207) 563-1234 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.0261990 -69.5271640 0   15 23 23015         https://data.medicare.gov/resource/xubh-q36u/row-mrex~j496-ppyw 201302 650479 2019-05-31 2018-12-31 21 4         25       42       67
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
809 809 BAPTIST HEALTH MEDICAL CENTER-ARKADELPHIA 3050 TWIN RIVERS DRIVE ARKADELPHIA AR 71923 CLARK (870) 245-2622 Critical Access Hospitals Voluntary non-profit - Private TRUE 34.1228020 -93.0879700 0   19 5 5019 11660   Central Clark County https://data.medicare.gov/resource/xubh-q36u/row-f8ss.59v5_rxma 41321 649536 2019-05-31 2018-12-31 25           25               25
821 821 THE CARLE FOUNDATION HOSPITAL 611 WEST PARK STREET URBANA IL 61801 CHAMPAIGN (217) 383-3311 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.1174230 -88.2138880 0   19 17 17019 16580   Central Champaign County https://data.medicare.gov/resource/xubh-q36u/row-irc8~hqw6~45fp 140091 650122 2019-05-31 2018-12-31 328   12   26   391   20           411
833 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
862 862 EAST COOPER MEDICAL CENTER 2000 HOSPITAL DR MOUNT PLEASANT SC 29464 CHARLESTON (843) 881-0100 Acute Care Hospitals Proprietary TRUE 32.8209970 -79.8496130 0   19 45 45019 16700   Central Charleston County https://data.medicare.gov/resource/xubh-q36u/row-a8up_sjrm.scy3 420089 648981 2019-05-31 2018-12-31 118 12         130               130
931 931 CEDAR CITY HOSPITAL 1303 NORTH MAIN STREET CEDAR CITY UT 84721 IRON (435) 868-5800 Acute Care Hospitals Voluntary non-profit - Private TRUE 37.7005910 -113.0639850 0   21 49 49021 16260   Central Iron County https://data.medicare.gov/resource/xubh-q36u/row-v2cb~88mw~jehb 460007 649976 2019-05-31 2018-12-31 42 6         48               48
942 942 BAPTIST HEALTH MEDICAL CENTER HEBER SPINGS 1800 BYPASS ROAD HEBER SPRINGS AR 72543 CLEBURNE (501) 887-3000 Critical Access Hospitals Voluntary non-profit - Private TRUE 35.5065780 -92.0013190 0   23 5 5023         https://data.medicare.gov/resource/xubh-q36u/row-d26c_x5yu_6fn3 41312 651551 2019-05-31 2018-12-31 25           25               25
992 992 O'CONNOR HOSPITAL 460 ANDES ROAD DELHI NY 13753 DELAWARE (607) 746-0300 Critical Access Hospitals Voluntary non-profit - Private TRUE 42.2668700 -74.9168500 0   25 36 36025         https://data.medicare.gov/resource/xubh-q36u/row-we9d-4xh5_rhbv 331305 650323 2019-05-31 2018-12-31 16           16               16
1075 1075 WALDO COUNTY GENERAL HOSPITAL 118 NORTHPORT AVE BELFAST ME 4915 WALDO (207) 338-2500 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.4127590 -68.9951020 0   27 23 23027         https://data.medicare.gov/resource/xubh-q36u/row-9ec9_eza5.9s9p 201312 650482 2019-05-31 2018-12-31 21 4         25               25
1124 1124 ADVENTIST HEALTH BAKERSFIELD 2615 CHESTER AVENUE BAKERSFIELD CA 93301 KERN (661) 395-3000 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.3830560 -119.0188570 0   29 6 6029 12540   Central Kern County https://data.medicare.gov/resource/xubh-q36u/row-siqs~heps~67ia 50455 649164 2019-05-31 2018-12-31 211 34         254               254
1125 1125 DELANO REGIONAL MEDICAL CENTER 1401 GARCES HIGHWAY DELANO CA 93215 KERN (661) 725-4800 Acute Care Hospitals Proprietary TRUE 35.7614180 -119.2388780 0   29 6 6029 12540   Central Kern County https://data.medicare.gov/resource/xubh-q36u/row-6xns.bkw3_m9qr 50608 650656 2019-05-31 2018-12-31 95 10         105       2   49   156
1126 1126 ADVENTIST HEALTH TEHACHAPI VALLEY 1100 MAGELLAN TEHACHAPI CA 93561 KERN (661) 823-3000 Critical Access Hospitals Government - Hospital District or Authority TRUE 35.1474419 -118.4504364 1 ROOFTOP 29 6 6029 12540   Central Kern County https://data.medicare.gov/resource/xubh-q36u/row-xx6n.a25c~74jx 51301 648598 2019-05-31 2018-12-31 16 4         20               20
1133 1133 DELTA COUNTY MEMORIAL HOSPITAL 1501 E 3RD ST DELTA CO 81416 DELTA (970) 874-7681 Acute Care Hospitals Government - Local TRUE 38.7431660 -108.0475150 0   29 8 8029         https://data.medicare.gov/resource/xubh-q36u/row-wsed.7ysa~nwhq 60071 649875 2019-05-31 2018-12-31 43 6         49               49
1180 1180 UNIVERSITY HEALTH SYSTEM 4502 MEDICAL DR SAN ANTONIO TX 78229 BEXAR (210) 358-2637 Acute Care Hospitals Government - Hospital District or Authority TRUE 29.5094880 -98.5770620 0   29 48 48029 41700   Central Bexar County https://data.medicare.gov/resource/xubh-q36u/row-a5b3.8n6m-4vq3 450213 651423 2019-05-31 2018-12-31 460 20     44   606   27           633
1184 1184 METHODIST AMBULATORY SURGERY HOSPITAL NW 9150 HUEBNER RD SUITE 100 SAN ANTONIO TX 78240 BEXAR (210) 575-5000 Acute Care Hospitals Proprietary TRUE 29.5276050 -98.5959950 0   29 48 48029 41700   Central Bexar County https://data.medicare.gov/resource/xubh-q36u/row-f26r~6776-r3st 450780 650209 2019-05-31 2018-12-31 22           22               22
1280 1280 BOZEMAN HEALTH DEACONESS HOSPITAL 915 HIGHLAND BLVD BOZEMAN MT 59715 GALLATIN (406) 585-5000 Acute Care Hospitals Voluntary non-profit - Private TRUE 45.6702780 -111.0172390 0   31 30 30031 14580   Central Gallatin County https://data.medicare.gov/resource/xubh-q36u/row-avzt.zzb8~xv3b 270057 650725 2019-05-31 2018-12-31 75 8         83               83
1296 1296 COSHOCTON REGIONAL MEDICAL CENTER 1460 ORANGE STREET COSHOCTON OH 43812 COSHOCTON (740) 623-4144 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.2704420 -81.8475770 0   31 39 39031 18740   Central Coshocton County https://data.medicare.gov/resource/xubh-q36u/row-kfzq~stzn~vtav 360109 649322 2019-05-31 2018-12-31 49 7         56               56
1312 1312 SPARKS MEDICAL CENTER - VAN BUREN 211 CRAWFORD MEMORIAL DRIVE VAN BUREN AR 72956 CRAWFORD (479) 474-3401 Acute Care Hospitals Proprietary TRUE 35.4341750 -94.3394510 0   33 5 5033 22900   Central Crawford County https://data.medicare.gov/resource/xubh-q36u/row-w5xt~zwtc_2chf 40018 649071 2019-05-31 2018-12-31 31 8         39               39
1314 1314 ADVENTIST HEALTH CLEARLAKE 15630 18TH AVE - HWY 53 CLEARLAKE CA 95422 LAKE (707) 994-6486 Critical Access Hospitals Voluntary non-profit - Church TRUE 38.9353458 -122.6200816 1 ROOFTOP 33 6 6033 17340   Central Lake County https://data.medicare.gov/resource/xubh-q36u/row-hud3~fp2e-cmcb 51317 648600 2019-05-31 2018-12-31 21 4         25               25
1326 1326 SURGICAL SPECIALTY CENTER OF BATON ROUGE 8080 BLUEBONNET BLVD BATON ROUGE LA 70810 E. BATON ROUGE (225) 408-8080 Acute Care Hospitals Physician FALSE 30.3765650 -91.0993330 0   33 22 22033 12940   Central East Baton Rouge Parish https://data.medicare.gov/resource/xubh-q36u/row-vta2_xzya~pwww 190251 648928 2019-05-31 2018-12-31 16           16               16
1337 1337 CHIPPEWA COUNTY WAR MEMORIAL HOSPITAL 500 OSBORN BLVD SAULT SAINTE MARIE MI 49783 CHIPPEWA (906) 635-4460 Acute Care Hospitals Voluntary non-profit - Private TRUE 46.4980990 -84.3495130 0   33 26 26033 42300   Central Chippewa County https://data.medicare.gov/resource/xubh-q36u/row-eftg-z8w4.heur 230239 649610 2019-05-31 2018-12-31 43 6         49 20     51       120
1480 1480 SAN JUAN HOSPITAL 380 WEST 100 NORTH MONTICELLO UT 84535 SAN JUAN (435) 587-2116 Critical Access Hospitals Government - Local TRUE 37.8738750 -109.3500620 0   37 49 49037         https://data.medicare.gov/resource/xubh-q36u/row-bwvs.75rh_updn 461308 650788 2019-05-31 2018-12-31 20 1         21               21
1604 1604 DEFIANCE REGIONAL MEDICAL CENTER 1200 RALSTON AVENUE DEFIANCE OH 43512 DEFIANCE (419) 783-6955 Critical Access Hospitals Voluntary non-profit - Private TRUE 41.2993920 -84.3734690 0   39 39 39039 19580   Central Defiance County https://data.medicare.gov/resource/xubh-q36u/row-29rw.zsfv.ixin 361328 649330 2019-05-31 2018-12-31 17 8         25 10             35
1620 1620 SANPETE VALLEY HOSPITAL - CAH 1100 SOUTH MEDICAL DRIVE MOUNT PLEASANT UT 84647 SANPETE (435) 462-4123 Critical Access Hospitals Voluntary non-profit - Private TRUE 39.5318030 -111.4611940 0   39 49 49039         https://data.medicare.gov/resource/xubh-q36u/row-44ik~upe5.vztv 461303 649841 2019-05-31 2018-12-31 18           18               18
1628 1628 RIPON MEDICAL CENTER 845 PARKSIDE ST RIPON WI 54971 FOND DU LAC (920) 748-3101 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.8354510 -88.8176920 0   39 55 55039 22540   Central Fond du Lac County https://data.medicare.gov/resource/xubh-q36u/row-677e~kc7g-58mt 521321 650552 2019-05-31 2018-12-31 15 3         18               18
1629 1629 ST AGNES HOSPITAL 430 E DIVISION ST FOND DU LAC WI 54935 FOND DU LAC (920) 929-2300 Acute Care Hospitals Voluntary non-profit - Private TRUE 43.7786910 -88.4311790 0   39 55 55039 22540   Central Fond du Lac County https://data.medicare.gov/resource/xubh-q36u/row-86tc.e78h.8kd6 520088 650432 2019-05-31 2018-12-31 103 12         115 16 5           136
1673 1673 PHYSICIANS CENTRE,THE 3131 UNIVERSITY DRIVE EAST BRYAN TX 77802 BRAZOS (979) 731-3100 Acute Care Hospitals Proprietary TRUE 30.6495850 -96.2965150 0   41 48 48041 17780   Central Brazos County https://data.medicare.gov/resource/xubh-q36u/row-hv3y_nxcx-fin2 450834 649964 2019-05-31 2018-12-31 16           16               16
1684 1684 CANDLER COUNTY HOSPITAL 400 CEDAR STREET METTER GA 30439 CANDLER (912) 685-5741 Critical Access Hospitals Government - Hospital District or Authority TRUE 32.4070810 -82.0666080 0   43 13 13043         https://data.medicare.gov/resource/xubh-q36u/row-i22u~jvuf~casx 111334 651205 2019-05-31 2018-12-31 19 6         25               25
1697 1697 DICKINSON COUNTY MEMORIAL HOSPITAL 1721 S STEPHENSON AVE IRON MOUNTAIN MI 49801 DICKINSON (906) 774-1313 Acute Care Hospitals Government - Local TRUE 45.8085720 -88.0442680 0   43 26 26043 27020   Central Dickinson County https://data.medicare.gov/resource/xubh-q36u/row-ss3t.epsm-biyy 230055 649262 2019-05-31 2018-12-31 33 6         39               39
1724 1724 ADVENTIST HEALTH UKIAH VALLEY 275 HOSPITAL DRIVE UKIAH CA 95482 MENDOCINO (707) 462-3111 Acute Care Hospitals Voluntary non-profit - Church TRUE 39.1530190 -123.2038000 0   45 6 6045 46380   Central Mendocino County https://data.medicare.gov/resource/xubh-q36u/row-5xip-9esx.8u6b 50301 649538 2019-05-31 2018-12-31 42 6       2 50               50
1746 1746 RIVER HOSPITAL CLINICS 4 FULLER STREET ALEXANDRIA BAY NY 13607 JEFFERSON (315) 482-2511 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.3372170 -75.9200220 0   45 36 36045 48060   Central Jefferson County https://data.medicare.gov/resource/xubh-q36u/row-7zvs~rszm-n4ux 331309 650324 2019-05-31 2018-12-31 24           24               24
1781 1781 JENNIE STUART MEDICAL CENTER 320 WEST 18TH STREET HOPKINSVILLE KY 42240 CHRISTIAN (270) 887-0100 Acute Care Hospitals Voluntary non-profit - Private TRUE 36.8604430 -87.4956680 0   47 21 21047 17300   Outlying Christian County https://data.medicare.gov/resource/xubh-q36u/row-ej5h.uz4s.tihd 180051 649237 2019-05-31 2018-12-31 111 18         133               133
1819 1819 FALL RIVER HOSPITAL - CAH 1201 HIGHWAY 71 SOUTH HOT SPRINGS SD 57747 FALL RIVER (605) 745-8910 Critical Access Hospitals Government - Local TRUE 43.4183120 -103.4807830 0   47 46 46047         https://data.medicare.gov/resource/xubh-q36u/row-85xb~ejm9_5eec 431322 650784 2019-05-31 2018-12-31 25           25       48       73
1835 1835 WOODLAWN HOSPITAL 1400 E 9TH ST ROCHESTER IN 46975 FULTON (574) 223-3141 Critical Access Hospitals Government - Local TRUE 41.0617280 -86.1969730 0   49 18 18049         https://data.medicare.gov/resource/xubh-q36u/row-2dgz-xb34_49d2 151313 649096 2019-05-31 2018-12-31 21 4         25               25
1892 1892 GUNNISON VALLEY HOSPITAL 711 NORTH TAYLOR STREET GUNNISON CO 81230 GUNNISON (970) 641-1456 Critical Access Hospitals Government - Local TRUE 38.5510890 -106.9243210 0   51 8 8051         https://data.medicare.gov/resource/xubh-q36u/row-e9p4-pdcf.rn62 61320 650438 2019-05-31 2018-12-31 20           20               20
1972 1972 COASTAL CAROLINA HOSPITAL 1000 MEDICAL CENTER DRIVE HARDEEVILLE SC 29927 JASPER (843) 784-8182 Acute Care Hospitals Proprietary TRUE 32.3148170 -81.0554290 0   53 45 45053 25940   Outlying Jasper County https://data.medicare.gov/resource/xubh-q36u/row-vyiy.4j6d.s8ih 420101 650369 2019-05-31 2018-12-31 37 4         41               41
2034 2034 MANGUM REGIONAL MEDICAL CENTER 1 WICKERSHAM DRIVE MANGUM OK 73554 GREER (580) 782-3353 Critical Access Hospitals Proprietary TRUE 34.8918230 -99.5023410 0   55 40 40055         https://data.medicare.gov/resource/xubh-q36u/row-irnc.n45b.ecpm 371330 649816 2019-05-31 2018-12-31 18           18               18
2052 2052 SOUTH FLORIDA BAPTIST HOSPITAL 301 N ALEXANDER ST PLANT CITY FL 33563 HILLSBOROUGH (813) 757-1200 Acute Care Hospitals Voluntary non-profit - Private TRUE 28.0161630 -82.1380020 0   57 12 12057 45300   Central Hillsborough County https://data.medicare.gov/resource/xubh-q36u/row-nbkb_uux7.wk3s 100132 649885 2019-05-31 2018-12-31 122 25         147               147
2053 2053 ADVENTHEALTH CARROLLWOOD 7171 N DALE MABRY HWY TAMPA FL 33614 HILLSBOROUGH (813) 932-2222 Acute Care Hospitals Voluntary non-profit - Church TRUE 28.0131020 -82.5049540 0   57 12 12057 45300   Central Hillsborough County https://data.medicare.gov/resource/xubh-q36u/row-22he-y9u8_3jua 100069 649181 2019-05-31 2018-12-31 95 8         103               103
2055 2055 BRANDON REGIONAL HOSPITAL 119 OAKFIELD DR BRANDON FL 33511 HILLSBOROUGH (813) 681-5551 Acute Care Hospitals Proprietary TRUE 27.9340020 -82.2883030 0   57 12 12057 45300   Central Hillsborough County https://data.medicare.gov/resource/xubh-q36u/row-utgt-8wzg.stgk 100243 649081 2019-05-31 2018-12-31 317 54       22 393 25             418
2057 2057 ST JOSEPHS HOSPITAL 3001 W MARTIN LUTHER KING JR BLVD TAMPA FL 33677 HILLSBOROUGH (813) 870-4398 Acute Care Hospitals Voluntary non-profit - Church TRUE 27.9822844 -82.4911306 1 ROOFTOP 57 12 12057 45300   Central Hillsborough County https://data.medicare.gov/resource/xubh-q36u/row-w8gx-3zfk-n7gh 100075 650969 2019-05-31 2018-12-31 866 106 26     64 1062               1062
2071 2071 OCHSNER ST ANNE GENERAL HOSPITAL 4608 HIGHWAY 1 RACELAND LA 70394 LAFOURCHE (985) 537-8377 Critical Access Hospitals Voluntary non-profit - Private TRUE 29.7034470 -90.5641330 0   57 22 22057 26380   Central Lafourche Parish https://data.medicare.gov/resource/xubh-q36u/row-nye5~c7n8.m9ck 191324 650474 2019-05-31 2018-12-31 22 3         25 10             35
2091 2091 RIVERSIDE TAPPAHANNOCK HOSPITAL 618 HOSPITAL ROAD TAPPAHANNOCK VA 22560 ESSEX (804) 443-6189 Acute Care Hospitals Voluntary non-profit - Private TRUE 37.9006680 -76.8776140 0   57 51 51057         https://data.medicare.gov/resource/xubh-q36u/row-hr4y.gpmz.tmm2 490084 650407 2019-05-31 2018-12-31 60 7         67               67
2192 2192 BIGFORK VALLEY HOSPITAL 258 PINE TREE DRIVE PO BOX 258 BIGFORK MN 56628 ITASCA (218) 743-3177 Critical Access Hospitals Government - Hospital District or Authority TRUE 47.7468850 -93.6468220 0   61 27 27061         https://data.medicare.gov/resource/xubh-q36u/row-356c-64uf.kf5r 241316 650718 2019-05-31 2018-12-31 20           20       47       67
2193 2193 GRAND ITASCA CLINIC AND HOSPITAL 1601 GOLF COURSE ROAD GRAND RAPIDS MN 55744 ITASCA (218) 326-3401 Acute Care Hospitals Voluntary non-profit - Private TRUE 47.2210390 -93.5547160 0   61 27 27061         https://data.medicare.gov/resource/xubh-q36u/row-2qrv~rfjc~89wf 240064 650497 2019-05-31 2018-12-31 27   9       36               36
2257 2257 ST PATRICK HOSPITAL 500 W BROADWAY MISSOULA MT 59806 MISSOULA (406) 543-7271 Acute Care Hospitals Voluntary non-profit - Church TRUE 46.8739050 -113.9998910 0   63 30 30063 33540   Central Missoula County https://data.medicare.gov/resource/xubh-q36u/row-44i5~53xu-fjn4 270014 650294 2019-05-31 2018-12-31 134 24         158 30             188
2279 2279 MAYO CLINIC HLTH SYSTEM FRANCISCAN MED CTR 700 WEST AVENUE SOUTH LA CROSSE WI 54601 LA CROSSE (608) 785-0940 Acute Care Hospitals Voluntary non-profit - Private TRUE 43.8040380 -91.2395570 0   63 55 55063 29100   Central La Crosse County https://data.medicare.gov/resource/xubh-q36u/row-xath.nvpn-sxup 520004 650430 2019-05-31 2018-12-31 114 28         142               142
2280 2280 GUNDERSEN LUTHERAN MEDICAL CENTER 1910 SOUTH AVE LA CROSSE WI 54601 LA CROSSE (608) 782-7300 Acute Care Hospitals Voluntary non-profit - Private TRUE 43.7947480 -91.2462190 0   63 55 55063 29100   Central La Crosse County https://data.medicare.gov/resource/xubh-q36u/row-wmmy-ymuh_228f 520087 650431 2019-05-31 2018-12-31 211 24         253   16           269
2303 2303 GUNDERSEN PALMER LUTHERAN HOSPITAL AND CLINICS 112 JEFFERSON STREET WEST UNION IA 52175 FAYETTE (563) 422-3811 Critical Access Hospitals Voluntary non-profit - Private TRUE 42.9676800 -91.8094770 0   65 19 19065         https://data.medicare.gov/resource/xubh-q36u/row-ybws.vtki-rsbf 161316 649581 2019-05-31 2018-12-31 25           25               25
2315 2315 ST ELIZABETH MEDICAL CENTER 2209 GENESEE STREET UTICA NY 13501 ONEIDA (315) 798-8100 Acute Care Hospitals Voluntary non-profit - Private TRUE 43.0836460 -75.2671580 0   65 36 36065 46540   Central Oneida County https://data.medicare.gov/resource/xubh-q36u/row-cdeb~tcz3.24k5 330245 650321 2019-05-31 2018-12-31 119 16 9       177 24             201
2316 2316 ROME MEMORIAL HOSPITAL, INC 1500 NORTH JAMES STREET ROME NY 13440 ONEIDA (315) 338-7000 Acute Care Hospitals Voluntary non-profit - Private TRUE 43.2289540 -75.4442480 0   65 36 36065 46540   Central Oneida County https://data.medicare.gov/resource/xubh-q36u/row-y3h4.7wi3_6xz9 330215 650314 2019-05-31 2018-12-31 69 10         79 12     80       171
2321 2321 MID-COLUMBIA MEDICAL CENTER 1700 E 19TH STREET THE DALLES OR 97058 WASCO (541) 296-1111 Acute Care Hospitals Voluntary non-profit - Other TRUE 45.5879480 -121.1654700 0   65 41 41065 45520   Central Wasco County https://data.medicare.gov/resource/xubh-q36u/row-bx62.pzwr_8uvb 380001 649817 2019-05-31 2018-12-31 26 17         43   6           49
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
2369 2369 HARRISON COMMUNITY HOSPITAL 951 EAST MARKET STREET CADIZ OH 43907 HARRISON (740) 942-4631 Critical Access Hospitals Voluntary non-profit - Private TRUE 40.2572950 -80.9786400 0   67 39 39067         https://data.medicare.gov/resource/xubh-q36u/row-mhu5~ezn4.9tdn 361311 649326 2019-05-31 2018-12-31 25           25               25
2448 2448 MT SAN RAFAEL HOSPITAL 410 BENEDICTA AVE TRINIDAD CO 81082 LAS ANIMAS (719) 846-9213 Critical Access Hospitals Voluntary non-profit - Private TRUE 37.1733800 -104.4887960 0   71 8 8071         https://data.medicare.gov/resource/xubh-q36u/row-wzww_3ykk~yfx8 61321 650245 2019-05-31 2018-12-31 25           25               25
2479 2479 GREENFIELD AREA MEDICAL CENTER 550 MIRABEAU STREET GREENFIELD OH 45123 HIGHLAND (937) 981-9400 Critical Access Hospitals Voluntary non-profit - Private TRUE 39.3493150 -83.3880080 0   71 39 39071         https://data.medicare.gov/resource/xubh-q36u/row-nrr2~cens-ua4p 361304 649325 2019-05-31 2018-12-31 25           25               25
2572 2572 HAMILTON COUNTY HOSPITAL 700 NORTH HUSER SYRACUSE KS 67878 HAMILTON (620) 384-7461 Critical Access Hospitals Government - Local TRUE 37.9846055 -101.7426286 1 ROOFTOP 75 20 20075         https://data.medicare.gov/resource/xubh-q36u/row-aubk-tw4u-vx2j 171322 649228 2019-05-31 2018-12-31 25           25               25
2597 2597 ST MARYS MEDICAL CENTER 2635 N 7TH ST GRAND JUNCTION CO 81502 MESA (970) 298-1950 Acute Care Hospitals Voluntary non-profit - Church TRUE 39.0906040 -108.5614390 0   77 8 8077 24300   Central Mesa County https://data.medicare.gov/resource/xubh-q36u/row-qity~ffvk.qimr 60023 649708 2019-05-31 2018-12-31 195 18 14       257   24           281
2598 2598 COMMUNITY HOSPITAL 2351 'G' ROAD GRAND JUNCTION CO 81505 MESA (970) 256-6201 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.1062970 -108.6153120 0   77 8 8077 24300   Central Mesa County https://data.medicare.gov/resource/xubh-q36u/row-wkps-5qwm~bkr5 60054 649873 2019-05-31 2018-12-31 41 12         53               53
2645 2645 RAPIDES REGIONAL MEDICAL CENTER 211 4TH STREET ALEXANDRIA LA 71301 RAPIDES (318) 769-3000 Acute Care Hospitals Proprietary TRUE 31.3150210 -92.4504810 0   79 22 22079 10780   Central Rapides Parish https://data.medicare.gov/resource/xubh-q36u/row-73ux~awri.sd3h 190026 649243 2019-05-31 2018-12-31 322         29 357               357
2651 2651 WRIGHT MEMORIAL HOSPITAL 191 IOWA BOULEVARD TRENTON MO 64683 GRUNDY (660) 359-5621 Critical Access Hospitals Voluntary non-profit - Private TRUE 40.0682750 -93.5799360 0   79 29 29079         https://data.medicare.gov/resource/xubh-q36u/row-ewb5-qskq-99ee 261309 650289 2019-05-31 2018-12-31 21           21               21
2735 2735 SANTA BARBARA COTTAGE HOSPITAL 400 WEST PUEBLO SANTA BARBARA CA 93102 SANTA BARBARA (805) 682-7111 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.4294830 -119.7230770 0   83 6 6083 42200   Central Santa Barbara County https://data.medicare.gov/resource/xubh-q36u/row-tvaw.4z7e-2im9 50396 652419 2019-05-31 2018-12-31 255 20     20 8 325   38           363
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
2737 2737 GOLETA VALLEY COTTAGE HOSPITAL 351 S PATTERSON AVE SANTA BARBARA CA 93111 SANTA BARBARA (805) 681-6446 Acute Care Hospitals Voluntary non-profit - Other TRUE 34.4336990 -119.8093220 0   83 6 6083 42200   Central Santa Barbara County https://data.medicare.gov/resource/xubh-q36u/row-rh7j_i3k3-gwyy 50357 652391 2019-05-31 2018-12-31 20 8         28               28
2745 2745 GOOD SAMARITAN HOSPITAL 520 S 7TH ST VINCENNES IN 47591 KNOX (812) 882-5220 Acute Care Hospitals Voluntary non-profit - Other TRUE 38.6729200 -87.5342130 0   83 18 18083 47180   Central Knox County https://data.medicare.gov/resource/xubh-q36u/row-f56v.t8ru-iadr 150042 649206 2019-05-31 2018-12-31 69 30         99 20 25           144
2810 2810 THREE RIVERS HOSPITAL 451 HIGHWAY 13 SOUTH WAVERLY TN 37185 HUMPHREYS (931) 296-4203 Critical Access Hospitals Voluntary non-profit - Private TRUE 36.0750570 -87.7927410 0   85 47 47085         https://data.medicare.gov/resource/xubh-q36u/row-8juw_5v9k.hvwi 441303 651236 2019-05-31 2018-12-31 25           25               25
2915 2915 CLAXTON-HEPBURN MEDICAL CENTER 214 KING STREET OGDENSBURG NY 13669 ST. LAWRENCE (315) 393-3600 Acute Care Hospitals Voluntary non-profit - Private TRUE 44.6920910 -75.4999340 0   89 36 36089 36300   Central St. Lawrence County https://data.medicare.gov/resource/xubh-q36u/row-776r-puvg.z7ya 330211 650313 2019-05-31 2018-12-31 77 10         87 28 15           130
3002 3002 ST JAMES HEALTHCARE 400 S CLARK ST BUTTE MT 59701 SILVER BOW (406) 723-2500 Acute Care Hospitals Voluntary non-profit - Private TRUE 46.0092800 -112.5460680 0   93 30 30093 15580   Central Silver Bow County https://data.medicare.gov/resource/xubh-q36u/row-spzg~vydz~yvmh 270017 650295 2019-05-31 2018-12-31 60 11         71               71
3027 3027 MELISSA MEMORIAL HOSPITAL 1001 E JOHNSON ST HOLYOKE CO 80734 PHILLIPS (970) 854-2241 Critical Access Hospitals Government - Hospital District or Authority TRUE 40.5784280 -102.2902490 0   95 8 8095         https://data.medicare.gov/resource/xubh-q36u/row-6wcd-peh6-fsnb 61305 650244 2019-05-31 2018-12-31 15           15               15
3028 3028 HAXTUN HOSPITAL DISTRICT 235 W FLETCHER ST HAXTUN CO 80731 PHILLIPS (970) 774-6123 Critical Access Hospitals Government - Hospital District or Authority TRUE 40.6413860 -102.6308660 0   95 8 8095         https://data.medicare.gov/resource/xubh-q36u/row-amj6-3hms~eqap 61304 649172 2019-05-31 2018-12-31 25           25               25
3138 3138 PROWERS MEDICAL CENTER 401 KENDALL DR LAMAR CO 81052 PROWERS (719) 336-4343 Critical Access Hospitals Government - Hospital District or Authority TRUE 38.0709150 -102.6090680 0   99 8 8099         https://data.medicare.gov/resource/xubh-q36u/row-g7ky~tb82~a5bh 61323 650118 2019-05-31 2018-12-31 25           25               25
3170 3170 BENEFIS TETON MEDICAL CENTER 915 4TH ST NW CHOTEAU MT 59422 TETON (406) 466-5763 Critical Access Hospitals Voluntary non-profit - Private TRUE 47.8134200 -112.1924570 0   99 30 30099         https://data.medicare.gov/resource/xubh-q36u/row-f2z3-5ua9~t2zq 271307 650727 2019-05-31 2018-12-31 25           25               25
3178 3178 ARBUCKLE MEMORIAL HOSPITAL AUTHORITY 2011 WEST BROADWAY SULPHUR OK 73086 MURRAY (580) 622-2161 Critical Access Hospitals Government - Local TRUE 34.5063330 -96.9960050 0   99 40 40099         https://data.medicare.gov/resource/xubh-q36u/row-k94n_jt84~krmu 371328 648757 2019-05-31 2018-12-31 25           25               25

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