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

325 rows where "filed_date" is on date 2019-06-03 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, oth_spec_beds, subprovider_oth_beds, nursing_fac_beds, oth_longterm_beds, fy_end_date (date)

filed_date (date) ✖

  • 2019-06-03 · 325 ✖
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
21 21 HORN MEMORIAL HOSPITAL 701 E 2ND ST IDA GROVE IA 51445 IDA (712) 364-3311 Critical Access Hospitals Voluntary non-profit - Private TRUE 42.3393030 -95.4589100 0   93 19 19093         https://data.medicare.gov/resource/xubh-q36u/row-ct62_kkw5_7j35 161354 649735 2019-06-03 2018-12-31 25           25               25
30 30 SOUTHSIDE COMMUNITY HOSPITAL, INC 800 OAK STREET FARMVILLE VA 23901 PRINCE EDWARD (434) 392-8811 Acute Care Hospitals Voluntary non-profit - Other TRUE 37.3033170 -78.4030580 0   147 51 51147         https://data.medicare.gov/resource/xubh-q36u/row-5efz.zpme_8ei2 490090 650408 2019-06-03 2018-12-31 78 8         86               86
34 34 FRIO REGIONAL HOSPITAL 200 S IH 35 PEARSALL TX 78061 FRIO (830) 334-3617 Critical Access Hospitals Voluntary non-profit - Private TRUE 28.8970480 -99.1160130 0   163 48 48163         https://data.medicare.gov/resource/xubh-q36u/row-9gys.vgtu~2pyx 451391 650214 2019-06-03 2018-12-31 24           24               24
216 216 CUBA MEMORIAL HOSPITAL, INC 140 WEST MAIN STREET CUBA NY 14727 ALLEGANY (585) 961-2000 Critical Access Hospitals Voluntary non-profit - Private FALSE 42.2133410 -78.2881390 0   3 36 36003         https://data.medicare.gov/resource/xubh-q36u/row-2ir6~7udp_pyzv 331301 651038 2019-06-03 2018-12-31 20           20       61       81
249 249 TRI-STATE MEMORIAL HOSPITAL 1221 HIGHLAND AVENUE CLARKSTON WA 99403 ASOTIN (509) 758-5511 Critical Access Hospitals Voluntary non-profit - Private TRUE 46.4036380 -117.0545070 0   3 53 53003 30300   Central Asotin County https://data.medicare.gov/resource/xubh-q36u/row-i7hs.ad2c-g7gn 501332 649847 2019-06-03 2018-12-31 25           25               25
257 257 PAGE HOSPITAL 501 NORTH NAVAJO DRIVE PAGE AZ 86040 COCONINO (928) 645-2424 Critical Access Hospitals Government - Hospital District or Authority TRUE 36.9169600 -111.4631860 0   5 4 4005 22380   Central Coconino County https://data.medicare.gov/resource/xubh-q36u/row-pwtm.vez8_t2h2 31304 649070 2019-06-03 2018-12-31 25           25               25
259 259 SUTTER AMADOR HOSPITAL 200 MISSION BLVD JACKSON CA 95642 AMADOR (209) 223-7500 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.3495610 -120.7659050 0   5 6 6005         https://data.medicare.gov/resource/xubh-q36u/row-s5bi-egin.834t 50014 650640 2019-06-03 2018-12-31 46 6         52               52
328 328 TRIOS 900 SOUTH AUBURN STREET KENNEWICK WA 99336 BENTON (509) 586-6111 Acute Care Hospitals Government - Hospital District or Authority TRUE 46.1988750 -119.1184630 0   5 53 53005 28420   Central Benton County https://data.medicare.gov/resource/xubh-q36u/row-hs4k~gp5j~yv74 500053 651430 2019-06-03 2018-12-31 87 14       10 111               111
334 334 HOSP COMUNITARIO BUEN SAMARITANO CARR.2 KM.1.4 AVE. SEVERIANO CUEVAS #18 AGUADILLA PR 603 AGUADILLA (787) 658-0000 Acute Care Hospitals Voluntary non-profit - Other TRUE 18.4257212 -67.1508997 1 GEOMETRIC_CENTER 5 72 72005 10380   Central Aguadilla Municipio https://data.medicare.gov/resource/xubh-q36u/row-8tsm_vegi.8z9v 400079 649495 2019-06-03 2018-12-31 116 8         124               124
337 337 BANNER PAYSON MEDICAL CENTER 807 SOUTH PONDEROSA DRIVE PAYSON AZ 85541 GILA (928) 474-3222 Critical Access Hospitals Voluntary non-profit - Other FALSE 34.2313510 -111.3213610 0   7 4 4007 37740   Central Gila County https://data.medicare.gov/resource/xubh-q36u/row-2gy2.vxfy~pkyq 31318 649532 2019-06-03 2018-12-31 21 4         25               25
392 392 BENNETT COUNTY HOSPITAL AND NURSING HOME - CAH 102 MAJOR ALLEN POST OFFICE BOX 70D MARTIN SD 57551 BENNETT (605) 685-6622 Critical Access Hospitals Voluntary non-profit - Other TRUE 43.1691630 -101.7266636 1 RANGE_INTERPOLATED 7 46 46007         https://data.medicare.gov/resource/xubh-q36u/row-q2mg~bq2u~fi2w 431314 649823 2019-06-03 2018-12-31 14           14           48   62
394 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
397 397 LAKE CHELAN COMMUNITY HOSPITAL 503 EAST HIGHLAND CHELAN WA 98816 CHELAN (509) 682-3300 Critical Access Hospitals Government - Hospital District or Authority TRUE 47.8451390 -120.0105110 0   7 53 53007 48300   Central Chelan County https://data.medicare.gov/resource/xubh-q36u/row-a77p~uq78~jh3e 501334 651089 2019-06-03 2018-12-31 25           25               25
425 425 MAUI MEMORIAL MEDICAL CENTER 221 MAHALANI STREET WAILUKU HI 96793 MAUI (808) 442-5101 Acute Care Hospitals Government - State FALSE 20.8844550 -156.4880870 0   9 15 15009 27980   Central Maui County https://data.medicare.gov/resource/xubh-q36u/row-66fd~zrmp.8s5u 120002 649892 2019-06-03 2018-12-31 199 20         219               219
426 426 LANAI COMMUNITY HOSPITAL 628 7TH STREET LANAI CITY HI 96763 MAUI (808) 565-8450 Critical Access Hospitals Government - State TRUE 20.8267350 -156.9180020 0   9 15 15009 27980   Central Maui County https://data.medicare.gov/resource/xubh-q36u/row-keiy_dtd7_smny 121305 648608 2019-06-03 2018-12-31 4           4       10       14
427 427 KULA HOSPITAL 100 KEOKEA PLACE KULA HI 96790 MAUI (808) 878-1221 Critical Access Hospitals Government - State TRUE 20.7019940 -156.3570990 0   9 15 15009 27980   Central Maui County https://data.medicare.gov/resource/xubh-q36u/row-8svz_bunk-n2za 121308 648609 2019-06-03 2018-12-31 9           9       105       123
524 524 SOUTHWEST HEALTHCARE SERVICES 802 2ND ST NW BOWMAN ND 58623 BOWMAN (701) 523-5265 Critical Access Hospitals Voluntary non-profit - Private TRUE 46.1841910 -103.4067130 0   11 38 38011         https://data.medicare.gov/resource/xubh-q36u/row-wb88_am45~hjt8 351313 651048 2019-06-03 2018-12-31 23           23       40       63
552 552 BANNER THUNDERBIRD MEDICAL CENTER 5555 WEST THUNDERBIRD ROAD GLENDALE AZ 85306 MARICOPA (602) 865-4470 Acute Care Hospitals Government - Hospital District or Authority TRUE 33.6107310 -112.1786980 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-fmq8_nzm3.7bhy 30089 649065 2019-06-03 2018-12-31 407 40 18       499 56             555
553 553 BANNER - UNIVERSITY MEDICAL CENTER PHOENIX 1111 EAST MCDOWELL ROAD PHOENIX AZ 85006 MARICOPA (602) 239-2000 Acute Care Hospitals Voluntary non-profit - Other TRUE 33.4657240 -112.0581270 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-f67j.fyep_c3zs 30002 648882 2019-06-03 2018-12-31 455 46 28       622 22 68           712
559 559 BANNER DESERT MEDICAL CENTER 1400 SOUTH DOBSON ROAD MESA AZ 85202 MARICOPA (480) 412-3000 Acute Care Hospitals Voluntary non-profit - Private TRUE 33.3909100 -111.8746240 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-m5b5-4dvf~smre 30065 649063 2019-06-03 2018-12-31 447 51 31       615               615
571 571 BANNER GATEWAY MEDICAL CENTER 1900 NORTH HIGLEY ROAD GILBERT AZ 85234 MARICOPA (480) 543-2000 Acute Care Hospitals Voluntary non-profit - Other TRUE 33.3842250 -111.7196340 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-wvqy.pesc-7dbf 30122 649068 2019-06-03 2018-12-31 141 24         165               165
572 572 BANNER HEART HOSPITAL 6750 EAST BAYWOOD AVENUE MESA AZ 85206 MARICOPA (480) 854-5050 Acute Care Hospitals Voluntary non-profit - Private FALSE 33.4103780 -111.6852730 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-tx6q_94yb.s344 30105 651582 2019-06-03 2018-12-31 67   44       111               111
573 573 WICKENBURG COMMUNITY HOSPITAL 520 ROSE LANE WICKENBURG AZ 85390 MARICOPA (928) 684-5421 Critical Access Hospitals Voluntary non-profit - Private TRUE 33.9780560 -112.7388250 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-mqi4.ug34.a4ib 31300 649069 2019-06-03 2018-12-31 19           19               19
575 575 DIGNITY HEALTH - ARIZONA GENERAL HOSPITAL 7171 SOUTH 51ST AVENUE LAVEEN AZ 85339 MARICOPA (623) 584-5100 Acute Care Hospitals Proprietary FALSE 33.3806770 -112.1682330 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-6h9g-s46a~aiyi 30136 651169 2019-06-03 2018-12-31 16           16               16
576 576 CORE INSTITUTE SPECIALTY HOSPITAL, THE 6501 NORTH 19TH AVENUE PHOENIX AZ 85015 MARICOPA (602) 795-6020 Acute Care Hospitals Physician FALSE 33.5318370 -112.0996140 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-ymwb.kuwb~xe6j 30108 659179 2019-06-03 2018-12-31 32           32               32
580 580 BANNER DEL E. WEBB MEDICAL CENTER 14502 WEST MEEKER BOULEVARD SUN CITY WEST AZ 85375 MARICOPA (623) 524-4000 Acute Care Hospitals Voluntary non-profit - Private TRUE 33.6583070 -112.3719390 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-7gp7~thfz~y68d 30093 650940 2019-06-03 2018-12-31 280 34         314 54 26           394
582 582 BANNER BAYWOOD MEDICAL CENTER 6644 EAST BAYWOOD AVENUE MESA AZ 85206 MARICOPA (480) 321-2000 Acute Care Hospitals Voluntary non-profit - Private FALSE 33.4104650 -111.6880450 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-xp3v_96ea.bqwa 30088 649064 2019-06-03 2018-12-31 292 26         318   22           340
583 583 BANNER ESTRELLA MEDICAL CENTER 9201 WEST THOMAS ROAD PHOENIX AZ 85037 MARICOPA (623) 327-4000 Acute Care Hospitals Voluntary non-profit - Private TRUE 33.4795580 -112.2579360 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-i5b8~ggf8_jyy9 30115 649067 2019-06-03 2018-12-31 273 24         317               317
607 607 BIENVILLE MEDICAL CENTER 1175 PINE STREET ARCADIA LA 71001 BIENVILLE (318) 263-4700 Critical Access Hospitals Proprietary TRUE 32.5530850 -92.9157770 0   13 22 22013         https://data.medicare.gov/resource/xubh-q36u/row-ui8b~9pic.2t2z 191320 650142 2019-06-03 2018-12-31 21           21               21
620 620 GREAT FALLS CLINIC HOSPITAL 3010 15TH AVENUE SOUTH GREAT FALLS MT 59405 CASCADE (406) 216-8000 Acute Care Hospitals Proprietary TRUE 47.4877370 -111.2545610 0   13 30 30013 24500   Central Cascade County https://data.medicare.gov/resource/xubh-q36u/row-zzvw_fvcf~g44t 270086 651217 2019-06-03 2018-12-31 20           20               20
640 640 EAST OHIO REGIONAL HOSPITAL 90 NORTH FOURTH STREET MARTINS FERRY OH 43935 BELMONT (740) 633-4205 Acute Care Hospitals Voluntary non-profit - Other TRUE 40.0986440 -80.7208890 0   13 39 39013 48540   Central Belmont County https://data.medicare.gov/resource/xubh-q36u/row-h333-qu75_kcna 360080 649318 2019-06-03 2018-12-31 74 10         84       50       134
660 660 MINNIE HAMILTON HEALTH SYSTEM 186 HOSPITAL DRIVE GRANTSVILLE WV 26147 CALHOUN (304) 354-9244 Critical Access Hospitals Voluntary non-profit - Private TRUE 38.9237960 -81.0918910 0   13 54 54013         https://data.medicare.gov/resource/xubh-q36u/row-2x87.vdzq_mgqw 511303 651093 2019-06-03 2018-12-31 25           25       24       49
662 662 SAGEWEST HEALTH CARE 2100 W SUNSET DR RIVERTON WY 82501 FREMONT (307) 856-4161 Acute Care Hospitals Proprietary TRUE 43.0336670 -108.4186540 0   13 56 56013 40180   Central Fremont County https://data.medicare.gov/resource/xubh-q36u/row-8cgp~ktku_un2q 530008 652129 2019-06-03 2018-12-31 121 12         133 13 8           154
674 674 SUTTER COAST HOSPITAL 800 E WASHINGTON BLVD CRESCENT CITY CA 95531 DEL NORTE (707) 464-8880 Acute Care Hospitals Government - Hospital District or Authority TRUE 41.7726980 -124.1941440 0   15 6 6015 18860   Central Del Norte County https://data.medicare.gov/resource/xubh-q36u/row-m7v2.npcd-rkyf 50417 650951 2019-06-03 2018-12-31 33 6         39   10           49
720 720 COMMUNITY HOSPITAL 2000 CAMPBELL DRIVE TORRINGTON WY 82240 GOSHEN (307) 532-4181 Critical Access Hospitals Voluntary non-profit - Private TRUE 42.0817650 -104.1915090 0   15 56 56015         https://data.medicare.gov/resource/xubh-q36u/row-cdm5.gqxc~vfiz 531307 649980 2019-06-03 2018-12-31 25           25               25
722 722 SUMMIT HEALTHCARE REGIONAL MEDICAL CENTER 2200 EAST SHOW LOW LAKE ROAD SHOW LOW AZ 85901 NAVAJO (928) 537-6399 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.2019670 -110.0183900 0   17 4 4017 43320   Central Navajo County https://data.medicare.gov/resource/xubh-q36u/row-2xk7_cqaa~gdmz 30062 651168 2019-06-03 2018-12-31 77 12         89               89
740 740 SPECIALISTS HOSPITAL SHREVEPORT 1500 LINE AVENUE SHREVEPORT LA 71101 CADDO (318) 213-3800 Acute Care Hospitals Physician FALSE 32.4969260 -93.7460460 0   17 22 22017 43340   Central Caddo Parish https://data.medicare.gov/resource/xubh-q36u/row-kr9t-dd8q-wfhi 190278 649901 2019-06-03 2018-12-31 15           15               15
761 761 HOLY ROSARY HEALTHCARE 2600 WILSON ST MILES CITY MT 59301 CUSTER (406) 233-2600 Critical Access Hospitals Voluntary non-profit - Private TRUE 46.3973550 -105.8278370 0   17 30 30017         https://data.medicare.gov/resource/xubh-q36u/row-89tn_7hx4-8qhz 271347 649797 2019-06-03 2018-12-31 21 4         25       84       109
828 828 WEST CALCASIEU CAMERON HOSPITAL 701 EAST CYPRESS STREET SULPHUR LA 70663 CALCASIEU (337) 527-7034 Acute Care Hospitals Government - Hospital District or Authority TRUE 30.2310740 -93.3692900 0   19 22 22019 29340   Central Calcasieu Parish https://data.medicare.gov/resource/xubh-q36u/row-swji~irkf_eud2 190013 650585 2019-06-03 2018-12-31 95 12         107               107
834 834 ST JOSEPH HOSPITAL 360 BROADWAY BANGOR ME 4401 PENOBSCOT (207) 262-1000 Acute Care Hospitals Voluntary non-profit - Church TRUE 44.8145300 -68.7712600 0   19 23 23019 12620   Central Penobscot County https://data.medicare.gov/resource/xubh-q36u/row-ad3u-g4s7-xxty 200001 650700 2019-06-03 2018-12-31 92 7         99               99
866 866 BEDFORD MEMORIAL HOSPITAL 1613 OAKWOOD STREET BEDFORD VA 24523 BEDFORD (434) 200-6366 Acute Care Hospitals Voluntary non-profit - Private TRUE 37.3515630 -79.5164150 0   19 51 51019 31340   Central Bedford County https://data.medicare.gov/resource/xubh-q36u/row-efrt-99vt~8tan 490088 650619 2019-06-03 2018-12-31 28 6         34       111       145
868 868 MONTGOMERY GENERAL HOSPITAL, INC 401 SIXTH AVENUE MONTGOMERY WV 25136 FAYETTE (304) 442-5151 Critical Access Hospitals Voluntary non-profit - Private TRUE 38.1828780 -81.3247080 0   19 54 54019 13220   Central Fayette County https://data.medicare.gov/resource/xubh-q36u/row-3eev_ya4k~dm4q 511318 651094 2019-06-03 2018-12-31 25           25       44       69
881 881 BANNER CASA GRANDE MEDICAL CENTER 1800 EAST FLORENCE BOULEVARD CASA GRANDE AZ 85122 PINAL (520) 381-6300 Acute Care Hospitals Voluntary non-profit - Other TRUE 32.8796080 -111.7092530 0   21 4 4021 38060   Central Pinal County https://data.medicare.gov/resource/xubh-q36u/row-iqqv.u75b-cmsi 30016 651166 2019-06-03 2018-12-31 119 22         141               141
882 882 PIGGOTT COMMUNITY HOSPITAL 216 EAST MAIN STREET PIGGOTT AR 72454 CLAY (870) 598-3881 Critical Access Hospitals Government - Local TRUE 36.3820190 -90.1884430 0   21 5 5021         https://data.medicare.gov/resource/xubh-q36u/row-73yu_ywme-uu8m 41330 649163 2019-06-03 2018-12-31 25           25               25
940 940 CHOCTAW GENERAL HOSPITAL 401 VANITY FAIR LANE, PO BOX 618 BUTLER AL 36904 CHOCTAW (205) 459-9100 Critical Access Hospitals Voluntary non-profit - Private TRUE 32.0937419 -88.2095888 1 ROOFTOP 23 1 1023         https://data.medicare.gov/resource/xubh-q36u/row-cm2u-i8id~q257 11304 651161 2019-06-03 2018-12-31 25           25               25
960 960 H C WATKINS MEMORIAL HOSPITAL INC 605 SOUTH ARCHUSA AVENUE QUITMAN MS 39355 CLARKE (601) 776-6925 Critical Access Hospitals Voluntary non-profit - Other TRUE 32.0312590 -88.7279550 0   23 28 28023 32940   Outlying Clarke County https://data.medicare.gov/resource/xubh-q36u/row-7ipq~zmm9-gyn8 251316 650283 2019-06-03 2018-12-31 25           25               25
989 989 JACKSON MEDICAL CENTER 220 HOSPITAL DRIVE JACKSON AL 36545 CLARKE (251) 246-9021 Acute Care Hospitals Proprietary TRUE 31.5304820 -87.8931800 0   25 1 1025         https://data.medicare.gov/resource/xubh-q36u/row-p276~rdhi_nmej 10128 651157 2019-06-03 2018-12-31 35           35               35
1034 1034 CIMARRON MEMORIAL HOSPITAL 100 SOUTH ELLIS BOISE CITY OK 73933 CIMARRON (580) 544-2501 Critical Access Hospitals Government - Hospital District or Authority TRUE 36.7290550 -102.5175370 0   25 40 40025         https://data.medicare.gov/resource/xubh-q36u/row-9zte.pc9m_addj 371307 650201 2019-06-03 2018-12-31 25           25               25
1042 1042 KANE COUNTY HOSPITAL 355 NORTH MAIN STREET KANAB UT 84741 KANE (435) 644-5811 Critical Access Hospitals Government - Hospital District or Authority TRUE 37.0543240 -112.5285900 0   25 49 49025         https://data.medicare.gov/resource/xubh-q36u/row-g8j5_itr8_6iiy 461309 649842 2019-06-03 2018-12-31 25           25               25
1069 1069 DAVIESS COMMUNITY HOSPITAL 1314 E WALNUT ST WASHINGTON IN 47501 DAVIESS (812) 254-2760 Acute Care Hospitals Government - Local TRUE 38.6586950 -87.1603190 0   27 18 18027 47780   Central Daviess County https://data.medicare.gov/resource/xubh-q36u/row-khjv_h54z-usqa 150061 649895 2019-06-03 2018-12-31 37 5         42 20 12           74
1072 1072 CLAY COUNTY MEDICAL CENTER 617 LIBERTY CLAY CENTER KS 67432 CLAY (785) 632-2144 Critical Access Hospitals Government - Local TRUE 39.3916810 -97.1241960 0   27 20 20027         https://data.medicare.gov/resource/xubh-q36u/row-5isq.mc8m-iybh 171371 650581 2019-06-03 2018-12-31 17           17               17
1087 1087 FULTON MEDICAL CENTER LLC 10 SOUTH HOSPITAL DRIVE FULTON MO 65251 CALLAWAY (573) 642-3376 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.8422470 -91.9662020 0   27 29 29027 27620   Outlying Callaway County https://data.medicare.gov/resource/xubh-q36u/row-t6sk_pcec-yuyb 260209 650171 2019-06-03 2018-12-31 18           18 19             37
1115 1115 GRAYS HARBOR COMMUNITY HOSPITAL 915 ANDERSON DRIVE ABERDEEN WA 98520 GRAYS HARBOR (360) 532-8330 Acute Care Hospitals Voluntary non-profit - Private TRUE 46.9796000 -123.8463870 0   27 53 53027 10140   Central Grays Harbor County https://data.medicare.gov/resource/xubh-q36u/row-qmdm-j995~rvv5 500031 659383 2019-06-03 2018-12-31 41 8         49               49
1130 1130 BAKERSFIELD HEART HOSPITAL 3001 SILLECT AVENUE BAKERSFIELD CA 93308 KERN (661) 316-6000 Acute Care Hospitals Proprietary TRUE 35.3861060 -119.0408470 0   29 6 6029 12540   Central Kern County https://data.medicare.gov/resource/xubh-q36u/row-e89i~sm2j_vijv 50724 651182 2019-06-03 2018-12-31 47           47               47
1190 1190 FOUNDATION SURGICAL HOSPITAL OF SAN ANTONIO 9522 HUEBNER ROAD SAN ANTONIO TX 78240 BEXAR (210) 478-5400 Acute Care Hospitals Proprietary TRUE 29.5310350 -98.5925540 0   29 48 48029 41700   Central Bexar County https://data.medicare.gov/resource/xubh-q36u/row-pvs4~yydr-y7qv 670054 649387 2019-06-03 2018-12-31 20           20               20
1289 1289 REHOBOTH MCKINLEY CHRISTIAN HEALTH CARE SERVICES 1901 RED ROCK DRIVE GALLUP NM 87301 MCKINLEY (505) 863-7000 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.5075000 -108.7272480 0   31 35 35031 23700   Central McKinley County https://data.medicare.gov/resource/xubh-q36u/row-6hnr~wbbc-hgrg 320038 649809 2019-06-03 2018-12-31 23 5         28           1   29
1300 1300 ST CHARLES MADRAS 470 NE A STREET MADRAS OR 97741 JEFFERSON (541) 475-3882 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.6373620 -121.1213580 0   31 41 41031         https://data.medicare.gov/resource/xubh-q36u/row-c49r.t2un~9r3e 381324 651053 2019-06-03 2018-12-31 25           25               25
1305 1305 UNITY MEDICAL CENTER 481 INTERSTATE DRIVE MANCHESTER TN 37355 COFFEE (931) 728-6354 Acute Care Hospitals Physician TRUE 35.4979320 -86.0781410 0   31 47 47031 46100   Central Coffee County https://data.medicare.gov/resource/xubh-q36u/row-7ihq-cddj~pgik 440007 651231 2019-06-03 2018-12-31 49           49               49
1308 1308 PLATTE COUNTY MEMORIAL HOSPITAL 201 14TH STREET WHEATLAND WY 82201 PLATTE (307) 322-3636 Critical Access Hospitals Government - Local TRUE 42.0498100 -104.9602210 0   31 56 56031         https://data.medicare.gov/resource/xubh-q36u/row-xwas~nr7a-7yiz 531305 649858 2019-06-03 2018-12-31 25           25               25
1313 1313 SUTTER LAKESIDE HOSPITAL 5176 HILL ROAD EAST LAKEPORT CA 95453 LAKE (707) 262-5000 Critical Access Hospitals Voluntary non-profit - Private TRUE 39.1051750 -122.9082380 0   33 6 6033 17340   Central Lake County https://data.medicare.gov/resource/xubh-q36u/row-eiws_bxxs~n9dn 51329 650960 2019-06-03 2018-12-31 21 4         25               25
1347 1347 ADIRONDACK MEDICAL CENTER - SARANAC LAKE 2233 STATE ROUTE 86, PO BOX 471 SARANAC LAKE NY 12983 FRANKLIN (518) 891-4141 Acute Care Hospitals Voluntary non-profit - Other TRUE 44.3445480 -74.1445970 0   33 36 36033 31660   Central Franklin County https://data.medicare.gov/resource/xubh-q36u/row-7ubk-sp7w.3hyq 330079 651024 2019-06-03 2018-12-31 75 8         83 12     60       155
1377 1377 EVERGREEN MEDICAL CENTER 101 CRESTVIEW AVENUE EVERGREEN AL 36401 CONECUH (251) 578-2480 Acute Care Hospitals Proprietary TRUE 31.4312600 -86.9420500 0   35 1 1035         https://data.medicare.gov/resource/xubh-q36u/row-f8ut-az4v~dn63 10148 651159 2019-06-03 2018-12-31 44           44               44
1406 1406 ALTRU HOSPITAL 1200 S COLUMBIA RD GRAND FORKS ND 58201 GRAND FORKS (701) 780-5000 Acute Care Hospitals Government - Local TRUE 47.9105352 -97.0681107 1 ROOFTOP 35 38 38035 24220   Central Grand Forks County https://data.medicare.gov/resource/xubh-q36u/row-tfgh.9uft~bxhm 350019 650883 2019-06-03 2018-12-31 245 16     10   271   23           294
1575 1575 KITTITAS VALLEY COMMUNITY HOSPITAL 603 SOUTH CHESTNUT ELLENSBURG WA 98926 KITTITAS (509) 962-9841 Critical Access Hospitals Government - Hospital District or Authority TRUE 46.9876880 -120.5367610 0   37 53 53037 21260   Central Kittitas County https://data.medicare.gov/resource/xubh-q36u/row-c8za_geg7~y7ap 501333 651088 2019-06-03 2018-12-31 19 6         25           1   26
1591 1591 SAVOY MEDICAL CENTER 801 POINCIANA AVENUE MAMOU LA 70554 EVANGELINE (337) 468-5261 Acute Care Hospitals Voluntary non-profit - Other TRUE 30.6410320 -92.4176050 0   39 22 22039         https://data.medicare.gov/resource/xubh-q36u/row-53wc.63uu-ebuh 190025 650138 2019-06-03 2018-12-31 118 10         128 38 10           176
1622 1622 KLICKITAT VALLEY HOSPITAL 310 SOUTH ROOSEVELT GOLDENDALE WA 98620 KLICKITAT (509) 773-4022 Critical Access Hospitals Government - Hospital District or Authority TRUE 45.8202390 -120.8122990 0   39 53 53039         https://data.medicare.gov/resource/xubh-q36u/row-hemh_kxtf-bs6t 501316 649846 2019-06-03 2018-12-31 14           14               14
1646 1646 CARROLL COUNTY MEMORIAL HOSPITAL 309 ELEVENTH STREET CARROLLTON KY 41008 CARROLL (502) 732-4321 Critical Access Hospitals Voluntary non-profit - Private TRUE 38.6799040 -85.1693140 0   41 21 21041         https://data.medicare.gov/resource/xubh-q36u/row-ttr6_yqtq-pq69 181310 649240 2019-06-03 2018-12-31 25           25               25
1719 1719 WASHAKIE MEDICAL CENTER 400 SOUTH 15TH STREET WORLAND WY 82401 WASHAKIE (307) 347-3221 Critical Access Hospitals Government - Local TRUE 44.0135560 -107.9484090 0   43 56 56043         https://data.medicare.gov/resource/xubh-q36u/row-wgjq-rwdt.3x58 531306 649859 2019-06-03 2018-12-31 18           18               18
1747 1747 SAMARITAN MEDICAL CENTER 830 WASHINGTON STREET WATERTOWN NY 13601 JEFFERSON (315) 785-4121 Acute Care Hospitals Voluntary non-profit - Private TRUE 43.9648900 -75.9127610 0   45 36 36045 48060   Central Jefferson County https://data.medicare.gov/resource/xubh-q36u/row-n2mk-4yxr_74kr 330157 650868 2019-06-03 2018-12-31 216 10       12 238 32 16           286
1778 1778 MARGARET MARY HEALTH 321 MITCHELL AVE BATESVILLE IN 47006 FRANKLIN (812) 934-6624 Critical Access Hospitals Voluntary non-profit - Private TRUE 39.3061410 -85.2227030 0   47 18 18047         https://data.medicare.gov/resource/xubh-q36u/row-dzet~b6y3_gi2k 151329 649577 2019-06-03 2018-12-31 18 7         25               25
1825 1825 THEDACARE MEDICAL CENTER - BERLIN INC 225 MEMORIAL DRIVE BERLIN WI 54923 GREEN LAKE (920) 361-1313 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.9776160 -88.9418430 0   47 55 55047         https://data.medicare.gov/resource/xubh-q36u/row-cdp5_34wg-tnxr 521355 650930 2019-06-03 2018-12-31 20 5         25       37       62
1881 1881 OCEAN BEACH HOSPITAL 174 FIRST AVENUE NORTH ILWACO WA 98624 PACIFIC (360) 642-3181 Critical Access Hospitals Government - State TRUE 46.3116960 -124.0433520 0   49 53 53049         https://data.medicare.gov/resource/xubh-q36u/row-6yj2-723x_f5cn 501314 649845 2019-06-03 2018-12-31 25           25               25
1910 1910 SSM HEALTH ST. MARY'S HOSPITAL - JEFFERSON CITY 2505 MISSION DRIVE JEFFERSON CITY MO 65109 COLE (573) 681-3000 Acute Care Hospitals Proprietary TRUE 38.5601420 -92.2202850 0   51 29 29051 27620   Central Cole County https://data.medicare.gov/resource/xubh-q36u/row-gt2e.ahrn_f7q9 260011 649917 2019-06-03 2018-12-31 154 13         167               167
1964 1964 COOPER COUNTY COMMUNITY HOSPITAL 17651 B HWY BOONVILLE MO 65233 COOPER (660) 882-4100 Acute Care Hospitals Voluntary non-profit - Other TRUE 38.9435330 -92.7420750 0   53 29 29053         https://data.medicare.gov/resource/xubh-q36u/row-b8m2_fqek~vure 260004 649916 2019-06-03 2018-12-31 46           46           19   65
2039 2039 SOUTHERN TENNESSEE REGIONAL HEALTH SYSTEM PULASKI 1265 E COLLEGE ST PULASKI TN 38478 GILES (931) 363-7531 Acute Care Hospitals Proprietary TRUE 35.1912900 -87.0043220 0   55 47 47055         https://data.medicare.gov/resource/xubh-q36u/row-5e7x~i85y_dgtz 440020 651233 2019-06-03 2018-12-31 75 6         81 14             95
2242 2242 KIT CARSON COUNTY MEMORIAL HOSPITAL 286 16TH ST BURLINGTON CO 80807 KIT CARSON (719) 346-5311 Critical Access Hospitals Government - Hospital District or Authority TRUE 39.3023780 -102.2707110 0   63 8 8063         https://data.medicare.gov/resource/xubh-q36u/row-xqzu-2pvu-xrfj 61313 648525 2019-06-03 2018-12-31 19           19               19
2314 2314 FAXTON-ST LUKE'S HEALTHCARE 1656 CHAMPLIN AVENUE UTICA NY 13503 ONEIDA (315) 798-6000 Acute Care Hospitals Voluntary non-profit - Private TRUE 43.0965919 -75.2761607 1 ROOFTOP 65 36 36065 46540   Central Oneida County https://data.medicare.gov/resource/xubh-q36u/row-r3tm-7qpb~9uvh 330044 650856 2019-06-03 2018-12-31 203   16     12 231   24           255
2387 2387 BANNER FORT COLLINS MEDICAL CENTER 4700 LADY MOON DRIVE FORT COLLINS CO 80528 LARIMER (970) 821-4000 Acute Care Hospitals Voluntary non-profit - Other TRUE 40.5211170 -105.0108850 0   69 8 8069 22660   Central Larimer County https://data.medicare.gov/resource/xubh-q36u/row-t2c3_t3mg_dfjd 60126 652186 2019-06-03 2018-12-31 23           23               23
2388 2388 ESTES PARK MEDICAL CENTER 555 PROSPECT AVE ESTES PARK CO 80517 LARIMER (970) 577-4470 Critical Access Hospitals Government - Hospital District or Authority TRUE 40.3722590 -105.5140880 0   69 8 8069 22660   Central Larimer County https://data.medicare.gov/resource/xubh-q36u/row-3yeq~tw3h-6ggv 61312 649878 2019-06-03 2018-12-31 25           25       60   6   91
2390 2390 MCKEE MEDICAL CENTER 2000 BOISE AVE LOVELAND CO 80538 LARIMER (970) 669-4640 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.4136790 -105.0535990 0   69 8 8069 22660   Central Larimer County https://data.medicare.gov/resource/xubh-q36u/row-33js.ddiw.t8wg 60030 649547 2019-06-03 2018-12-31 104 11         115               115
2395 2395 COFFEE REGIONAL MEDICAL CENTER, INC 1101 OCILLA ROAD DOUGLAS GA 31533 COFFEE (912) 383-5620 Acute Care Hospitals Government - Hospital District or Authority TRUE 31.5095890 -82.8634600 0   69 13 13069 20060   Central Coffee County https://data.medicare.gov/resource/xubh-q36u/row-d473_ue4x.74tq 110089 652866 2019-06-03 2018-12-31 76 10         86               86
2404 2404 JOHN C STENNIS MEMORIAL HOSPITAL 14365 HIGHWAY 16 WEST DE KALB MS 39328 KEMPER (769) 486-1000 Critical Access Hospitals Voluntary non-profit - Private TRUE 32.7768190 -88.6791220 0   69 28 28069 32940   Outlying Kemper County https://data.medicare.gov/resource/xubh-q36u/row-rjr3_kmd7~yci5 251335 650500 2019-06-03 2018-12-31 25           25               25
2418 2418 OHIO VALLEY MEDICAL CENTER 2000 EOFF STREET WHEELING WV 26003 OHIO (304) 234-0123 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.0594340 -80.7217320 0   69 54 54069 48540   Central Ohio County https://data.medicare.gov/resource/xubh-q36u/row-4mti_7ck5~rivb 510039 651092 2019-06-03 2018-12-31 104 15         119 84             203
2522 2522 LINCOLN COMMUNITY HOSPITAL 111 6TH ST HUGO CO 80821 LINCOLN (719) 743-2421 Critical Access Hospitals Voluntary non-profit - Other TRUE 39.1376600 -103.4731590 0   73 8 8073         https://data.medicare.gov/resource/xubh-q36u/row-ur8w~xce7~5xe9 61306 651191 2019-06-03 2018-12-31 15           15       35       50
2566 2566 STERLING REGIONAL MEDCENTER 615 FAIRHURST ST STERLING CO 80751 LOGAN (970) 522-0122 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.6136840 -103.2205240 0   75 8 8075 44540   Central Logan County https://data.medicare.gov/resource/xubh-q36u/row-9a6c-t2v5_2d88 60076 652859 2019-06-03 2018-12-31 21 4         25               25
2573 2573 HENRY FORD ALLEGIANCE HEALTH 205 N EAST AVE JACKSON MI 49201 JACKSON (517) 788-4800 Acute Care Hospitals Voluntary non-profit - Other TRUE 42.2503560 -84.3936030 0   75 26 26075 27100   Central Jackson County https://data.medicare.gov/resource/xubh-q36u/row-3qhp-255z.2v6t 230092 650158 2019-06-03 2018-12-31 262 34 17       313 40             353
2577 2577 RUSH FOUNDATION HOSPITAL 1314 19TH AVE MERIDIAN MS 39301 LAUDERDALE (601) 483-0011 Acute Care Hospitals Voluntary non-profit - Private TRUE 32.3706640 -88.6977790 0   75 28 28075 32940   Central Lauderdale County https://data.medicare.gov/resource/xubh-q36u/row-hxem.ceph_8ujn 250069 650164 2019-06-03 2018-12-31 154 22         182               182
2616 2616 MARY IMOGENE BASSETT HOSPITAL ONE ATWELL ROAD COOPERSTOWN NY 13326 OTSEGO (607) 547-3456 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.6956943 -74.9235838 1 ROOFTOP 77 36 36077 36580   Central Otsego County https://data.medicare.gov/resource/xubh-q36u/row-vzh5_h8bm~y3mk 330136 650866 2019-06-03 2018-12-31 126 14         160 20             180
2617 2617 AURELIA OSBORN FOX MEMORIAL HOSPITAL ONE NORTON AVENUE ONEONTA NY 13820 OTSEGO (607) 432-2000 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.4578897 -75.0522916 1 ROOFTOP 77 36 36077 36580   Central Otsego County https://data.medicare.gov/resource/xubh-q36u/row-euch_fijk.5j49 330085 650859 2019-06-03 2018-12-31 60           60       131       191
2633 2633 YAKIMA VALLEY MEMORIAL HOSPITAL 2811 TIETON DRIVE YAKIMA WA 98902 YAKIMA (509) 575-8000 Acute Care Hospitals Voluntary non-profit - Private TRUE 46.5927270 -120.5503960 0   77 53 53077 49420   Central Yakima County https://data.medicare.gov/resource/xubh-q36u/row-ctqg~gce3-w285 500036 651084 2019-06-03 2018-12-31 170 38         208 18         20   246
2772 2772 DAVIS MEDICAL CENTER 812 GORMAN AVENUE ELKINS WV 26241 RANDOLPH (304) 636-3300 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.9281590 -79.8531540 0   83 54 54083 21180   Central Randolph County https://data.medicare.gov/resource/xubh-q36u/row-642f_ssk9_qpnt 510030 651091 2019-06-03 2018-12-31 90           90               90
2848 2848 EAST MORGAN COUNTY HOSPITAL 2400 WEST EDISON STREET BRUSH CO 80723 MORGAN (970) 842-6222 Critical Access Hospitals Government - Hospital District or Authority TRUE 40.2547380 -103.6491780 0   87 8 8087 22820   Central Morgan County https://data.medicare.gov/resource/xubh-q36u/row-33cv-duhz_he5u 61303 649171 2019-06-03 2018-12-31 25           25               25
2856 2856 F W HUSTON MEDICAL CENTER 408 DELAWARE STREET WINCHESTER KS 66097 JEFFERSON (913) 774-4340 Critical Access Hospitals Voluntary non-profit - Private TRUE 39.3252310 -95.2704010 0   87 20 20087 45820   Outlying Jefferson County https://data.medicare.gov/resource/xubh-q36u/row-ms4u_ppxf-axv2 171314 649589 2019-06-03 2018-12-31 25           25         38 6   69
2916 2916 CLIFTON FINE HOSPITAL 1014 OSWEGATCHIE TRAIL STAR LAKE NY 13690 ST. LAWRENCE (315) 848-3351 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.1629530 -75.0559640 0   89 36 36089 36300   Central St. Lawrence County https://data.medicare.gov/resource/xubh-q36u/row-4e7w~nndx-wvba 331307 650877 2019-06-03 2018-12-31 20           20               20
2986 2986 NORTHWEST MEDICAL CENTER 1530 U S HIGHWAY 43 WINFIELD AL 35594 FAYETTE (205) 487-7736 Acute Care Hospitals Proprietary TRUE 33.9293160 -87.8245070 0   93 1 1093         https://data.medicare.gov/resource/xubh-q36u/row-r4dk-tpsz_u57n 10086 651153 2019-06-03 2018-12-31 57 4         61 10             71
3044 3044 NORTH MISSISSIPPI MEDICAL CENTER-GILMORE AMORY 1105 EARL FRYE BLVD AMORY MS 38821 MONROE (662) 256-7111 Acute Care Hospitals Proprietary TRUE 33.9775510 -88.4776250 0   95 28 28095         https://data.medicare.gov/resource/xubh-q36u/row-mseb-a3c5-hfq8 250025 649915 2019-06-03 2018-12-31 80 9       6 95               95
3208 3208 LAIRD HOSPITAL INC 25117 HIGHWAY 15 UNION MS 39365 NESHOBA (601) 774-8214 Critical Access Hospitals Voluntary non-profit - Private TRUE 32.5592070 -89.1025610 0   101 28 28101         https://data.medicare.gov/resource/xubh-q36u/row-68dt.7k6k_jc9z 251322 649458 2019-06-03 2018-12-31 25           25               25
3211 3211 OGALLALA COMMUNITY HOSPITAL 2601 NORTH SPRUCE ST OGALLALA NE 69153 KEITH (308) 284-4011 Critical Access Hospitals Government - Hospital District or Authority TRUE 41.1501770 -101.7204470 0   101 31 31101         https://data.medicare.gov/resource/xubh-q36u/row-g68g~zk9i.gtc5 281355 650174 2019-06-03 2018-12-31 18           18               18
3303 3303 ADVENTHEALTH LAKE WALES 410 S 11TH ST LAKE WALES FL 33853 POLK (863) 676-1433 Acute Care Hospitals Proprietary TRUE 27.8965330 -81.5646660 0   105 12 12105 29460   Central Polk County https://data.medicare.gov/resource/xubh-q36u/row-qtf7.zzcz~qpg5 100099 649186 2019-06-03 2018-12-31 85 8         93 38             131
3349 3349 WHEATLAND MEMORIAL HOSPITAL 530 3RD ST NW HARLOWTON MT 59036 WHEATLAND (406) 632-4351 Critical Access Hospitals Government - Local TRUE 46.4370010 -109.8405050 0   107 30 30107         https://data.medicare.gov/resource/xubh-q36u/row-ttwx.8piz~nq2c 271321 651017 2019-06-03 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
);