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

1,832 rows where "fy_end_date" is on date 2018-12-31 sorted by county_name

View and edit SQL

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

fy_end_date (date)

  • 2018-12-31 · 1,832
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
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
85 TREASURE VALLEY HOSPITAL 8800 WEST EMERALD STREET BOISE ID 83704 ADA (208) 373-5000 Acute Care Hospitals Proprietary FALSE 43.6112890 -116.2903320 0   1 16 16001 14260 Boise City-Mountain Home-Ontario, ID-OR Central Ada County https://data.medicare.gov/resource/xubh-q36u/row-egh2.u29a~s2jf 130063 650684 2019-05-31 2018-12-31 9           9               9
58 PLATTE VALLEY MEDICAL CENTER 1600 PRAIRIE CENTER PKWY BRIGHTON CO 80601 ADAMS (303) 498-1601 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.9654410 -104.7709240 0   1 8 8001 19740 Denver-Aurora, CO Central Adams County https://data.medicare.gov/resource/xubh-q36u/row-nf6e_r5cw.zmhy 60004 648669 2019-05-31 2018-12-31 65 8         89               89
59 CHILDREN'S HOSPITAL COLORADO 13123 E 16TH AVE AURORA CO 80045 ADAMS (720) 777-1234 Childrens Voluntary non-profit - Private TRUE 39.7416350 -104.8350180 0   1 8 8001 19740 Denver-Aurora, CO Central Adams County https://data.medicare.gov/resource/xubh-q36u/row-sqwg_95h7-bntj 63301 649405 2019-05-28 2018-12-31 276 36 40     82 434               434
61 NORTH SUBURBAN MEDICAL CENTER 9191 GRANT ST THORNTON CO 80229 ADAMS (303) 451-7800 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.8643800 -104.9847830 0   1 8 8001 19740 Denver-Aurora, CO Central Adams County https://data.medicare.gov/resource/xubh-q36u/row-tvxk_43rk.h2qn 60065 649402 2019-05-31 2018-12-31 111 16         127               127
88 ADAMS MEMORIAL HOSPITAL 1100 MERCER AVE DECATUR IN 46733 ADAMS (260) 724-2145 Critical Access Hospitals Government - Local TRUE 40.8179660 -84.9125350 0   1 18 18001 19540 Fort Wayne-Huntington-Auburn, IN Central Adams County https://data.medicare.gov/resource/xubh-q36u/row-vdys.bcxa-gdh7 151330 649100 2019-05-30 2018-12-31 21 4         25               25
102 MARY LANNING HEALTHCARE 715 N ST JOSEPH AVE HASTINGS NE 68901 ADAMS (402) 461-5108 Acute Care Hospitals Voluntary non-profit - Other TRUE 40.5924160 -98.3874740 0   1 31 31001 25580   Central Adams County https://data.medicare.gov/resource/xubh-q36u/row-6nbf.h76f_85sy 280032 648632 2019-05-24 2018-12-31 87 10         97 26 9   11       143
117 ADAMS COUNTY REGIONAL MEDICAL CENTER 230 MEDICAL CENTER DRIVE SEAMAN OH 45679 ADAMS (937) 386-3400 Critical Access Hospitals Government - Local TRUE 38.9338480 -83.5856120 0   1 39 39001         https://data.medicare.gov/resource/xubh-q36u/row-wb9j-jzwz-2xmu 361326 649329 2019-05-30 2018-12-31 25           25               25
128 OTHELLO COMMUNITY HOSPITAL 315 NORTH 14TH AVENUE OTHELLO WA 99344 ADAMS (509) 488-2636 Critical Access Hospitals Government - Hospital District or Authority TRUE 46.8303630 -119.1543630 0   1 53 53001 36830 Moses Lake-Othello, WA Central Adams County https://data.medicare.gov/resource/xubh-q36u/row-5z56.vhnt-5g9t 501318 658624 2019-11-12 2018-12-31 16           16               16
129 EAST ADAMS RURAL HOSPITAL 903 SOUTH ADAMS RITZVILLE WA 99169 ADAMS (509) 659-1200 Critical Access Hospitals Government - Hospital District or Authority TRUE 47.1209590 -118.3722580 0   1 53 53001 36830 Moses Lake-Othello, WA Central Adams County https://data.medicare.gov/resource/xubh-q36u/row-37up~x54g-vsqq 501311 653086 2019-05-31 2018-12-31 12           12               12
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
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
242 AIKEN REGIONAL MEDICAL CENTER 302 UNIVERSITY PARKWAY AIKEN SC 29801 AIKEN (803) 641-5900 Acute Care Hospitals Proprietary TRUE 33.5698900 -81.7650710 0   3 45 45003 12260   Central Aiken County https://data.medicare.gov/resource/xubh-q36u/row-2jsk_ph6i-gvkj 420082 648759 2019-05-29 2018-12-31 169 35         204 48 14           266
45 ALTA BATES SUMMIT MEDICAL CENTER 350 HAWTHORNE AVENUE OAKLAND CA 94609 ALAMEDA (510) 655-4000 Acute Care Hospitals Voluntary non-profit - Private TRUE 37.8207840 -122.2632800 0   1 6 6001 41860 San Jose-San Francisco-Oakland, CA Central Alameda County https://data.medicare.gov/resource/xubh-q36u/row-8jij.khwv.ypce 50043 650562 2019-06-03 2018-12-31 260 36         296   58           354
46 EDEN MEDICAL CENTER 20103 LAKE CHABOT ROAD CASTRO VALLEY CA 94546 ALAMEDA (510) 537-1234 Acute Care Hospitals Voluntary non-profit - Other TRUE 37.6982685 -122.0903131 1 ROOFTOP 1 6 6001 41860 San Jose-San Francisco-Oakland, CA Central Alameda County https://data.medicare.gov/resource/xubh-q36u/row-qpf5_ajfv~drq5 50488 650953 2019-06-03 2018-12-31 106 24         130               130
50 KAISER FOUNDATION HOSPITAL - SAN LEANDRO 2500 MERCED STREET SAN LEANDRO CA 94577 ALAMEDA (510) 454-1000 Acute Care Hospitals Voluntary non-profit - Private TRUE 37.7065240 -122.1694470 0   1 6 6001 41860 San Jose-San Francisco-Oakland, CA Central Alameda County https://data.medicare.gov/resource/xubh-q36u/row-tv6k~4ts3.26zc 50777 652239 2019-06-06 2018-12-31 166 20         206               206
53 KAISER FOUNDATION HOSPITAL - OAKLAND/RICHMOND 275 WEST MACARTHUR BOULEVARD OAKLAND CA 94611 ALAMEDA (510) 752-1000 Acute Care Hospitals Voluntary non-profit - Private TRUE 37.8238570 -122.2575890 0   1 6 6001 41860 San Jose-San Francisco-Oakland, CA Central Alameda County https://data.medicare.gov/resource/xubh-q36u/row-s8y7~merd_qtct 50075 649024 2019-06-06 2018-12-31 291 50         365               365
54 KAISER FOUNDATION HOSPITAL - FREMONT 39400 PASEO PADRE PKWY FREMONT CA 94538 ALAMEDA (510) 784-4000 Acute Care Hospitals Voluntary non-profit - Private TRUE 37.5509130 -121.9757690 0   1 6 6001 41860 San Jose-San Francisco-Oakland, CA Central Alameda County https://data.medicare.gov/resource/xubh-q36u/row-niun-nmuu_4jxw 50512 652223 2019-06-06 2018-12-31 96 10         106               106
56 ALTA BATES SUMMIT MEDICAL CENTER - ALTA BATES CAMP 2450 ASHBY AVENUE BERKELEY CA 94705 ALAMEDA (510) 204-4444 Acute Care Hospitals Voluntary non-profit - Private TRUE 37.8564880 -122.2573290 0   1 6 6001 41860 San Jose-San Francisco-Oakland, CA Central Alameda County https://data.medicare.gov/resource/xubh-q36u/row-x8am.fvn9.9rvh 50305 650649 2019-06-03 2018-12-31 252 30       55 337 64             401
114 ALBANY MEDICAL CENTER HOSPITAL 43 NEW SCOTLAND AVENUE, MAIL CODE 34 ALBANY NY 12208 ALBANY (518) 262-2400 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.6532540 -73.7738600 0   1 36 36001 10580 Albany-Schenectady, NY Central Albany County https://data.medicare.gov/resource/xubh-q36u/row-sggw.e236~c5a3 330013 649473 2019-05-29 2018-12-31 585 65 17     60 747 26 20           793
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
4732 INOVA ALEXANDRIA HOSPITAL 4320 SEMINARY RD ALEXANDRIA VA 22304 ALEXANDRIA CITY (703) 504-3167 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.8241280 -77.1044370 0   510 51 51510 47900 Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Central Alexandria city https://data.medicare.gov/resource/xubh-q36u/row-fzej-vy8h-2bar 490040 650394 2019-06-12 2018-12-31 278 40         334               334
290 ALLEGAN GENERAL HOSPITAL 555 LINN STREET ALLEGAN MI 49010 ALLEGAN (269) 686-4101 Critical Access Hospitals Voluntary non-profit - Other TRUE 42.5202590 -85.8569390 0   5 26 26005 26090 Grand Rapids-Wyoming-Muskegon, MI Central Allegan County https://data.medicare.gov/resource/xubh-q36u/row-9kac~4r3i~rk7m 231328 649266 2019-05-30 2018-12-31 25           25               25
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
89 ALLEN COUNTY REGIONAL HOSPITAL 3066 NORTH KENTUCKY STREET IOLA KS 66749 ALLEN (620) 365-1021 Critical Access Hospitals Government - State TRUE 37.9503420 -95.3906740 0   1 20 20001         https://data.medicare.gov/resource/xubh-q36u/row-gt8h_8a7x~t4kr 171373 648832 2019-05-29 2018-12-31 25           25               25
168 THE ORTHOPAEDIC HOSPITAL OF LUTHERAN HEALTH NETWOR 7952 W JEFFERSON BLVD FORT WAYNE IN 46804 ALLEN (260) 435-2999 Acute Care Hospitals Proprietary FALSE 41.0373520 -85.2459180 0   3 18 18003 23060 Fort Wayne-Huntington-Auburn, IN Central Allen County https://data.medicare.gov/resource/xubh-q36u/row-65sn_hsdz_dbbf 150168 649728 2019-06-03 2018-12-31 39           39               39
169 PARKVIEW REGIONAL MEDICAL CENTER 11109 PARKVIEW PLAZA DRIVE FORT WAYNE IN 46845 ALLEN (260) 266-1000 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.1870630 -85.0994600 0   3 18 18003 23060 Fort Wayne-Huntington-Auburn, IN Central Allen County https://data.medicare.gov/resource/xubh-q36u/row-exxr.2nie.5hvd 150021 649561 2019-05-30 2018-12-31 404 124         566 74 31   41       712
170 ORTHOPAEDIC HOSPITAL AT PARKVIEW NORTH LLC 11130 PARKVIEW CIRCLE DR FORT WAYNE IN 46845 ALLEN (260) 672-4050 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.1886620 -85.1032920 0   3 18 18003 23060 Fort Wayne-Huntington-Auburn, IN Central Allen County https://data.medicare.gov/resource/xubh-q36u/row-eyta.fsu8.cmma 150167 654435 2019-05-29 2018-12-31 37           37               37
219 LIMA MEMORIAL HEALTH SYSTEM 1001 BELLEFONTAINE AVENUE LIMA OH 45804 ALLEN (419) 226-3335 Acute Care Hospitals Voluntary non-profit - Other FALSE 40.7356020 -84.0877130 0   3 39 39003 30620 Lima-Van Wert-Celina, OH Central Allen County https://data.medicare.gov/resource/xubh-q36u/row-p8qs-v8mw~whtd 360009 648963 2019-05-30 2018-12-31 123 16 16       155   17           172
220 MERCY HEALTH-ST RITA'S MEDICAL CENTER 730 WEST MARKET STREET LIMA OH 45801 ALLEN (419) 227-3361 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.7399980 -84.1174500 0   3 39 39003 30620 Lima-Van Wert-Celina, OH Central Allen County https://data.medicare.gov/resource/xubh-q36u/row-ewvf-fmc3-mgzs 360066 648298 2019-05-20 2018-12-31 281 18 12       311   18   18   10   357
221 INSTITUTE FOR ORTHOPAEDIC SURGERY 801 MEDICAL DRIVE, SUITE B LIMA OH 45804 ALLEN (419) 224-7586 Acute Care Hospitals Proprietary FALSE 40.6985860 -84.0864770 0   3 39 39003 30620 Lima-Van Wert-Celina, OH Central Allen County https://data.medicare.gov/resource/xubh-q36u/row-kbua_iifb.k5nj 360263 649649 2019-06-03 2018-12-31 12           12               12
222 BLUFFTON HOSPITAL 139 GARAU STREET BLUFFTON OH 45817 ALLEN (419) 358-9010 Critical Access Hospitals Voluntary non-profit - Private TRUE 40.8875780 -83.8981490 0   3 39 39003 30620 Lima-Van Wert-Celina, OH Central Allen County https://data.medicare.gov/resource/xubh-q36u/row-manx~srzz-7qqn 361322 650898 2019-06-04 2018-12-31 25           25               25
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
874 ALASKA REGIONAL HOSPITAL 2801 DEBARR ROAD ANCHORAGE AK 99508 ANCHORAGE (907) 276-1131 Acute Care Hospitals Proprietary TRUE 61.2097900 -149.8273790 0   20 2 2020 11260   Central Anchorage Municipality https://data.medicare.gov/resource/xubh-q36u/row-727e.rn52.9kni 20017 662304 2019-12-09 2018-12-31 127 14 13       164   10           174
876 PROVIDENCE ALASKA MEDICAL CENTER 3200 PROVIDENCE DRIVE ANCHORAGE AK 99508 ANCHORAGE (907) 562-2211 Acute Care Hospitals Voluntary non-profit - Church TRUE 61.1897980 -149.8176220 0   20 2 2020 11260   Central Anchorage Municipality https://data.medicare.gov/resource/xubh-q36u/row-xgeq_psk8.kgkc 20001 650797 2019-05-30 2018-12-31 279 46       66 391   10           401
122 METHODIST MEDICAL CENTER OF OAK RIDGE 990 OAK RIDGE TURNPIKE BOX 529 OAK RIDGE TN 37830 ANDERSON (865) 835-1000 Acute Care Hospitals Voluntary non-profit - Private TRUE 36.0233970 -84.2439000 0   1 47 47001 28940 Knoxville-Morristown-Sevierville, TN Central Anderson County https://data.medicare.gov/resource/xubh-q36u/row-9qg8-3nhv.xeq4 440034 648762 2019-05-28 2018-12-31 179 25         204               204
123 PALESTINE REGIONAL MEDICAL CENTER 2900 S LOOP 256 PALESTINE TX 75801 ANDERSON (903) 731-1000 Acute Care Hospitals Proprietary TRUE 31.7333740 -95.6253070 0   1 48 48001 37300   Central Anderson County https://data.medicare.gov/resource/xubh-q36u/row-ymbb~yh2p_i5c8 450747 649500 2019-06-04 2018-12-31 106 10         116 19 17           152
172 ANDERSON COUNTY HOSPITAL 421 S MAPLE GARNETT KS 66032 ANDERSON (785) 204-4000 Critical Access Hospitals Voluntary non-profit - Private TRUE 38.2801200 -95.2493000 0   3 20 20003         https://data.medicare.gov/resource/xubh-q36u/row-3ktx.x5ze~zgrj 171316 648620 2019-05-24 2018-12-31 12           12           36   48
391 ANMED HEALTH 800 N FANT ST ANDERSON SC 29621 ANDERSON (864) 512-2830 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.5110710 -82.6473550 0   7 45 45007 24860 Greenville-Spartanburg-Anderson, SC Outlying Anderson County https://data.medicare.gov/resource/xubh-q36u/row-7pgs~6cv2_uh8s 420027 650366 2019-05-31 2018-12-31 327 25 15       367 29             396
93 ST MARY'S REGIONAL MEDICAL CENTER 93 CAMPUS AVENUE - PO BOX 291 LEWISTON ME 4243 ANDROSCOGGIN (207) 777-8100 Acute Care Hospitals Voluntary non-profit - Private TRUE 44.1014140 -70.1982160 0   1 23 23001 30340 Portland-Lewiston-South Portland, ME Central Androscoggin County https://data.medicare.gov/resource/xubh-q36u/row-9zvb_vyvi_ykdt 200034 650704 2019-06-03 2018-12-31 126 14         140 31     210       381
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
185 MERCY HOSPITAL 4050 COON RAPIDS BLVD COON RAPIDS MN 55433 ANOKA (762) 236-8100 Acute Care Hospitals Voluntary non-profit - Private TRUE 45.1838420 -93.3682210 0   3 27 27003 33460 Minneapolis-St. Paul, MN-WI Central Anoka County https://data.medicare.gov/resource/xubh-q36u/row-5tcm_8mvh-id9x 240115 651903 2019-07-09 2018-12-31 431 35         466 15             481
376 ATRIUM HEALTH ANSON 2301 US HIGHWAY 74 WEST WADESBORO NC 28170 ANSON (704) 694-5131 Acute Care Hospitals Government - Hospital District or Authority TRUE 34.9785320 -80.1096790 0   7 37 37007         https://data.medicare.gov/resource/xubh-q36u/row-mv5j_iuia_xbie 340084 650339 2019-05-30 2018-12-31 15           15               15
41 WHITE MOUNTAIN REGIONAL MEDICAL CENTER 118 SOUTH MOUNTAIN AVENUE SPRINGERVILLE AZ 85938 APACHE (928) 333-4368 Critical Access Hospitals Voluntary non-profit - Private TRUE 34.1321360 -109.2865450 0   1 4 4001         https://data.medicare.gov/resource/xubh-q36u/row-dkxh~vpbb.s52c 31315 652061 2019-05-30 2018-12-31 21           21               21
260 MEDICAL CENTER OF AURORA, THE 1501 S POTOMAC ST AURORA CO 80012 ARAPAHOE (303) 873-5511 Acute Care Hospitals Proprietary TRUE 39.6893460 -104.8311500 0   5 8 8005 19740 Denver-Aurora, CO Central Arapahoe County https://data.medicare.gov/resource/xubh-q36u/row-b8kj.p6xy-3gvh 60100 648892 2019-05-31 2018-12-31 250 45       14 309 20             329
262 CENTURA HEALTH-LITTLETON ADVENTIST HOSPITAL 7700 S BROADWAY LITTLETON CO 80122 ARAPAHOE (303) 730-8900 Acute Care Hospitals Voluntary non-profit - Church TRUE 39.5765540 -104.9884890 0   5 8 8005 19740 Denver-Aurora, CO Central Arapahoe County https://data.medicare.gov/resource/xubh-q36u/row-xab7~spdz_mmxf 60113 649074 2019-06-03 2018-12-31 121 24         159   17           176
346 PAGOSA SPRINGS MEDICAL CENTER 95 SOUTH PAGOSA BOULEVARD PAGOSA SPRINGS CO 81147 ARCHULETA (970) 731-3700 Critical Access Hospitals Government - Hospital District or Authority TRUE 37.2527760 -107.0772190 0   7 8 8007         https://data.medicare.gov/resource/xubh-q36u/row-j5fe.jwy4~ejt9 61328 654714 2019-09-26 2018-12-31 11           11               11
663 HOSPITAL DR SUSONI INC 55 PALM ST ARECIBO PR 614 ARECIBO (787) 650-1031 Acute Care Hospitals Voluntary non-profit - Private TRUE 18.4726154 -66.7164601 1 APPROXIMATE 13 72 72013 11640 San Juan-Carolina, PR Central Arecibo Municipio https://data.medicare.gov/resource/xubh-q36u/row-sxrh-3iek~wydv 400117 648863 2019-05-31 2018-12-31 114 6         120               120
664 HOSPITAL DR CAYETANO COLL Y TOSTE CARRETERA 129 KM.1 AVENIDA SAN LUIS ARECIBO PR 613 ARECIBO (787) 650-7272 Acute Care Hospitals Proprietary TRUE 18.4672197 -66.7313808 1 ROOFTOP 13 72 72013 11640 San Juan-Carolina, PR Central Arecibo Municipio https://data.medicare.gov/resource/xubh-q36u/row-7vbx.kyy9.acup 400087 650361 2019-05-28 2018-12-31 148 8       16 172               172
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
656 HALQUIST MEMORIAL INPATIENT CENTER 4715 NORTH 15 STREET ARLINGTON VA 22205 ARLINGTON (703) 525-7070 Acute Care Hospitals Voluntary non-profit - Private FALSE 38.8879410 -77.1216690 0   13 51 51013 47900 Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Central Arlington County https://data.medicare.gov/resource/xubh-q36u/row-vmzf.p4zi.8e5f 490129 651083 2019-06-03 2018-12-31                         36   36
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
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
457 ASHE MEMORIAL HOSPITAL 200 HOSPITAL AVE JEFFERSON NC 28640 ASHE (336) 246-7101 Critical Access Hospitals Voluntary non-profit - Private TRUE 36.4230270 -81.4597270 0   9 37 37009         https://data.medicare.gov/resource/xubh-q36u/row-adyt~iqxi_gv2a 341325 650353 2019-05-30 2018-12-31 25           25               25
310 UNIVERSITY HOSPITALS SAMARITAN MEDICAL CENTER 1025 CENTER ST ASHLAND OH 44805 ASHLAND (419) 289-0491 Acute Care Hospitals Voluntary non-profit - Other FALSE 40.8587020 -82.3104130 0   5 39 39005 11740 Mansfield-Ashland-Bucyrus, OH Central Ashland County https://data.medicare.gov/resource/xubh-q36u/row-suim.pydj-jawn 360002 649303 2019-06-03 2018-12-31 33 6         39               39
377 GLENBEIGH HEALTH SOURCES 2863 STATE ROUTE 45 ROCK CREEK OH 44084 ASHTABULA (440) 563-3400 Acute Care Hospitals Voluntary non-profit - Private FALSE 41.6724460 -80.8567230 0   7 39 39007 11780 Cleveland-Akron-Canton, OH Central Ashtabula County https://data.medicare.gov/resource/xubh-q36u/row-sbjb.gyph-ssjq 360245 648742 2019-05-29 2018-12-31 114           114               114
378 UNIVERSITY HOSPITALS CONNEAUT MEDICAL CENTER 158 WEST MAIN ROAD CONNEAUT OH 44030 ASHTABULA (440) 593-1131 Critical Access Hospitals Voluntary non-profit - Other TRUE 41.9369200 -80.5864590 0   7 39 39007 11780 Cleveland-Akron-Canton, OH Central Ashtabula County https://data.medicare.gov/resource/xubh-q36u/row-j92a_zjx7-y5bm 361308 649653 2019-06-03 2018-12-31 20 5         25               25
379 UHHS MEMORIAL HOSPITAL OF GENEVA 870 WEST MAIN STREET GENEVA OH 44041 ASHTABULA (440) 466-1141 Critical Access Hospitals Voluntary non-profit - Private TRUE 41.8002330 -80.9622770 0   7 39 39007 11780 Cleveland-Akron-Canton, OH Central Ashtabula County https://data.medicare.gov/resource/xubh-q36u/row-f7rd~3d3q.5pjc 361307 649652 2019-06-03 2018-12-31 20 5         25               25
380 ASHTABULA COUNTY MEDICAL CENTER 2420 LAKE AVENUE ASHTABULA OH 44004 ASHTABULA (440) 997-2262 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.8801480 -80.7956740 0   7 39 39007 11780 Cleveland-Akron-Canton, OH Central Ashtabula County https://data.medicare.gov/resource/xubh-q36u/row-8yrr-xpbs~arq8 360125 648739 2019-05-29 2018-12-31 95 9         104 17     16       137
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
106 SHORE MEDICAL CENTER 100 MEDICAL CENTER WAY SOMERS POINT NJ 8244 ATLANTIC (609) 653-3545 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.3146730 -74.5927720 0   1 34 34001 12100 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Atlantic County https://data.medicare.gov/resource/xubh-q36u/row-yjds-updz~uqtp 310047 650505 2019-05-31 2018-12-31 183 16         199               199
311 ATOKA COUNTY MEDICAL CENTER 1590 WEST LIBERTY ROAD ATOKA OK 74525 ATOKA (580) 889-3333 Critical Access Hospitals Government - Hospital District or Authority TRUE 34.3952620 -96.1594880 0   5 40 40005         https://data.medicare.gov/resource/xubh-q36u/row-qvh3-hh93~canr 371300 649482 2019-05-22 2018-12-31 25           25               25
364 SSM HEALTH ST. MARY'S HOSPITAL-AUDRAIN 620 E MONROE MEXICO MO 65265 AUDRAIN (573) 582-5000 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.1729210 -91.8772380 0   7 29 29007 33020 Columbia-Moberly-Mexico, MO Central Audrain County https://data.medicare.gov/resource/xubh-q36u/row-xq3u-xwqr-wnnb 260064 652149 2019-07-30 2018-12-31 40           40 20             60
525 GRAND LAKE HEALTH SYSTEM 200 SAINT CLAIR STREET SAINT MARYS OH 45885 AUGLAIZE (419) 394-3335 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.5451390 -84.3698360 0   11 39 39011 47540 Lima-Van Wert-Celina, OH Central Auglaize County https://data.medicare.gov/resource/xubh-q36u/row-98z6_ymvq~u2mi 360032 649307 2019-05-31 2018-12-31 30 6         36 12 4   15       67
717 AUGUSTA HEALTH 78 MEDICAL CENTER DRIVE FISHERSVILLE VA 22939 AUGUSTA (540) 932-4000 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.0923320 -78.9884610 0   15 51 51015 44420 Harrisonburg-Staunton-Waynesboro, VA Central Augusta County https://data.medicare.gov/resource/xubh-q36u/row-depk.64ku-i36r 490018 650388 2019-06-12 2018-12-31 197 8 4       209 8 8   17       242
407 SOUTHEAST COLORADO HOSPITAL 373 E TENTH AVE SPRINGFIELD CO 81073 BACA (719) 523-4501 Critical Access Hospitals Government - Hospital District or Authority TRUE 37.4041650 -102.6124230 0   9 8 8009         https://data.medicare.gov/resource/xubh-q36u/row-ph53-yjae~upmw 61311 649711 2019-06-13 2018-12-31 15           15         56     71
271 PORTNEUF MEDICAL CENTER 777 HOSPITAL WAY POCATELLO ID 83201 BANNOCK (208) 239-1000 Acute Care Hospitals Proprietary TRUE 42.8726210 -112.4189000 0   5 16 16005 38540   Central Bannock County https://data.medicare.gov/resource/xubh-q36u/row-seur~dy2g.gabs 130028 653172 2019-08-07 2018-12-31 101 20         137 19 9           165
354 MEDICINE LODGE MEMORIAL HOSPITAL 710 N WALNUT STREET MEDICINE LODGE KS 67104 BARBER (620) 886-3771 Critical Access Hospitals Government - Hospital District or Authority TRUE 37.2898770 -98.5776590 0   7 20 20007         https://data.medicare.gov/resource/xubh-q36u/row-bqaw~6v8h_uftw 171334 648921 2019-05-28 2018-12-31 22           22               22
355 KIOWA DISTRICT HOSPITAL 1002 SOUTH 4TH STREET KIOWA KS 67070 BARBER (620) 825-4131 Critical Access Hospitals Government - Hospital District or Authority TRUE 37.0085470 -98.4897950 0   7 20 20007         https://data.medicare.gov/resource/xubh-q36u/row-cbxd_2s68-tihe 171331 648918 2019-05-29 2018-12-31 10           10               10
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
254 MEDICAL CENTER BARBOUR 820 W WASHINGTON ST EUFAULA AL 36027 BARBOUR (334) 688-7271 Acute Care Hospitals Government - Hospital District or Authority TRUE 31.8879800 -85.1566130 0   5 1 1005         https://data.medicare.gov/resource/xubh-q36u/row-b9cj~n2ap_7hxj 10069 651152 2019-05-30 2018-12-31 25 5         30 17             47
331 MAYO CLINIC HEALTH SYSTEM-NORTHLAND 1222 E WOODLAND AVE BARRON WI 54812 BARRON (715) 537-3186 Critical Access Hospitals Voluntary non-profit - Private TRUE 45.3983690 -91.8406680 0   5 55 55005         https://data.medicare.gov/resource/xubh-q36u/row-y236_phpe.9nrq 521315 649524 2019-05-28 2018-12-31 25           25               25
273 COLUMBUS REGIONAL HOSPITAL 2400 E 17TH ST COLUMBUS IN 47201 BARTHOLOMEW (812) 379-4441 Acute Care Hospitals Government - Local TRUE 39.2158720 -85.8968540 0   5 18 18005 18020 Indianapolis-Carmel-Muncie, IN Central Bartholomew County https://data.medicare.gov/resource/xubh-q36u/row-u4i5.cqhh_8kd8 150112 649209 2019-05-31 2018-12-31 194 17         211   18           229
432 CLARA BARTON HOSPITAL 250 W 9TH STREET HOISINGTON KS 67544 BARTON (620) 653-2114 Critical Access Hospitals Voluntary non-profit - Private TRUE 38.5215490 -98.7794100 0   9 20 20009 24460   Central Barton County https://data.medicare.gov/resource/xubh-q36u/row-fy4c.k945-z7ft 171333 648920 2019-05-28 2018-12-31 18           18               18
619 BATES COUNTY MEMORIAL HOSPITAL 615 W NURSERY ST BUTLER MO 64730 BATES (660) 200-7000 Acute Care Hospitals Government - Local TRUE 38.2496110 -94.3433910 0   13 29 29013 28140 Kansas City-Overland Park-Kansas City, MO-KS Outlying Bates County https://data.medicare.gov/resource/xubh-q36u/row-y4pe~pb6c-52i8 260034 648060 2019-05-16 2018-12-31 44           44               44
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
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 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
937 HOSPITAL HERMANOS MELENDEZ INC CARRETERA #2 KM 11 7 BAYAMON PR 960 BAYAMON (787) 620-8181 Acute Care Hospitals Proprietary TRUE 18.3967595 -66.1625647 1 ROOFTOP 21 72 72021 41980 San Juan-Carolina, PR Central Bayamón Municipio https://data.medicare.gov/resource/xubh-q36u/row-qeay~e2ib.ig5b 400032 649346 2019-05-29 2018-12-31 232 21         253               253
938 HIMA SAN PABLO BAYAMON 70 CALLE SANTA CRUZ BAYAMON PR 961 BAYAMON (787) 620-4747 Acute Care Hospitals Proprietary TRUE 18.3976640 -66.1496740 0   21 72 72021 41980 San Juan-Carolina, PR Central Bayamón Municipio https://data.medicare.gov/resource/xubh-q36u/row-gt9f-5hpz-5v3k 400109 650772 2019-05-31 2018-12-31 290 39 7       336               336
352 BEAR LAKE MEMORIAL HOSPITAL 164 SOUTH FIFTH STREET MONTPELIER ID 83254 BEAR LAKE (208) 847-1630 Critical Access Hospitals Government - Local TRUE 42.3162420 -111.3008470 0   7 16 16007         https://data.medicare.gov/resource/xubh-q36u/row-mggi-9epd.588z 131316 647888 2019-05-16 2018-12-31 21           21       36   32   89
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
125 MILFORD VALLEY MEMORIAL HOSPITAL 850 NORTH MAIN STREET MILFORD UT 84751 BEAVER (435) 387-2411 Critical Access Hospitals Government - Hospital District or Authority FALSE 38.4073080 -113.0095430 0   1 49 49001         https://data.medicare.gov/resource/xubh-q36u/row-iet4.f5zs.batz 461305 648782 2019-05-29 2018-12-31 5           5           18   23
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
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
641 BARNESVILLE HOSPITAL ASSOCIATION, INC 639 WEST MAIN STREET BARNESVILLE OH 43713 BELMONT (740) 425-5101 Critical Access Hospitals Voluntary non-profit - Private TRUE 39.9920690 -81.1883940 0   13 39 39013 48540   Central Belmont County https://data.medicare.gov/resource/xubh-q36u/row-h85t.br3v-763v 361321 647575 2019-04-30 2018-12-31 20   5       25               25
360 SANFORD BEMIDJI MEDICAL CENTER 1300 ANNE ST NW BEMIDJI MN 56601 BELTRAMI (218) 751-5430 Acute Care Hospitals Voluntary non-profit - Private TRUE 47.5050090 -94.8981250 0   7 27 27007 13420   Central Beltrami County https://data.medicare.gov/resource/xubh-q36u/row-uwkp_7ty3-835f 240100 649770 2019-05-23 2018-12-31 84 10         94 12 12   78       196
428 BENEWAH COMMUNITY HOSPITAL 229 SOUTH 7TH STREET ST MARIES ID 83861 BENEWAH (208) 245-5551 Critical Access Hospitals Government - Local TRUE 47.3146130 -116.5666780 0   9 16 16009         https://data.medicare.gov/resource/xubh-q36u/row-3wfv~5stn~5t7d 131317 652074 2019-05-24 2018-12-31 19           19               19
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
223 GOOD SAMARITAN REGIONAL MEDICAL CENTER 3600 NW SAMARITAN DRIVE CORVALLIS OR 97330 BENTON (541) 768-5111 Acute Care Hospitals Voluntary non-profit - Private TRUE 44.6046240 -123.2511040 0   3 41 41003 18700 Portland-Vancouver-Salem, OR-WA Central Benton County https://data.medicare.gov/resource/xubh-q36u/row-pcfe.3dmp~9puh 380014 650902 2019-05-28 2018-12-31 157 12         169 24             193
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
327 KADLEC REGIONAL MEDICAL CENTER 888 SWIFT BLVD RICHLAND WA 99352 BENTON (509) 946-4611 Acute Care Hospitals Voluntary non-profit - Private TRUE 46.2804620 -119.2811210 0   5 53 53005 28420   Central Benton County https://data.medicare.gov/resource/xubh-q36u/row-k3yx.t79z-wduq 500058 648786 2019-05-29 2018-12-31 201 30       27 258   12           270
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
339 OZARKS COMMUNITY HOSPITAL OF GRAVETTE 1101 JACKSON STREET SW GRAVETTE AR 72736 BENTON (479) 787-5291 Critical Access Hospitals Proprietary TRUE 36.4085630 -94.4598700 0   7 5 5007 22220   Central Benton County https://data.medicare.gov/resource/xubh-q36u/row-snva.mem9_cs94 41331 651314 2019-05-30 2018-12-31 25           25               25
210 HACKENSACK UNIVERSITY MEDICAL CENTER 30 PROSPECT AVE HACKENSACK NJ 7601 BERGEN (551) 996-2000 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.8840320 -74.0579540 0   3 34 34003 35620 New York-Newark, NY-NJ-CT-PA Central Bergen County https://data.medicare.gov/resource/xubh-q36u/row-3r63~g2k2_j8zj 310001 656108 2019-10-30 2018-12-31 599 35 13     40 687 24             711
211 HOLY NAME MEDICAL CENTER 718 TEANECK RD TEANECK NJ 7666 BERGEN (201) 833-3000 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.8823770 -74.0086290 0   3 34 34003 35620 New York-Newark, NY-NJ-CT-PA Central Bergen County https://data.medicare.gov/resource/xubh-q36u/row-xnww.m9j5.svuu 310008 649047 2019-05-30 2018-12-31 265 19         284 23             307
212 BERGEN NEW BRIDGE MEDICAL CENTER 230 EAST RIDGEWOOD AVE PARAMUS NJ 7652 BERGEN (201) 967-4000 Acute Care Hospitals Government - Local TRUE 40.9586020 -74.0621510 0   3 34 34003 35620 New York-Newark, NY-NJ-CT-PA Central Bergen County https://data.medicare.gov/resource/xubh-q36u/row-uajf_w5ak.e5wh 310058 651020 2019-06-03 2018-12-31 118 9         127 319     574       1020
213 ENGLEWOOD HOSPITAL AND MEDICAL CENTER 350 ENGLE ST ENGLEWOOD NJ 7631 BERGEN (201) 894-3000 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.9028550 -73.9679930 0   3 34 34003 35620 New York-Newark, NY-NJ-CT-PA Central Bergen County https://data.medicare.gov/resource/xubh-q36u/row-veb2-ksdy_macn 310045 650180 2019-05-31 2018-12-31 238 26       11 275 14             289
214 VALLEY HOSPITAL 223 N VAN DIEN AVENUE RIDGEWOOD NJ 7450 BERGEN (201) 447-8000 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.9832040 -74.1017610 0   3 34 34003 35620 New York-Newark, NY-NJ-CT-PA Central Bergen County https://data.medicare.gov/resource/xubh-q36u/row-dcmv-g3rd.mciv 310012 648551 2019-05-23 2018-12-31 327 14 22       363               363
250 BERKELEY MEDICAL CENTER 2500 HOSPITAL DRIVE MARTINSBURG WV 25401 BERKELEY (304) 264-1000 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.4772540 -77.9806190 0   3 54 54003 25180 Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Central Berkeley County https://data.medicare.gov/resource/xubh-q36u/row-faju-yvek_2eqd 510008 648871 2019-05-21 2018-12-31 122 20         146 23             169

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