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

✎ 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
45 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 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
56 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
93 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
168 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
198 198 BOULDER CITY HOSPITAL 901 ADAMS BLVD BOULDER CITY NV 89005 CLARK (702) 293-4111 Critical Access Hospitals Voluntary non-profit - Private TRUE 35.9683590 -114.8434860 0   3 32 32003 29820 Las Vegas-Henderson, NV-AZ Central Clark County https://data.medicare.gov/resource/xubh-q36u/row-m2cb.9j9h-qmdd 291309 651018 2019-06-03 2018-12-31 25           25 10     47       82
212 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
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
221 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
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
262 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
304 304 MONTEFIORE MEDICAL CENTER 111 EAST 210TH STREET BRONX NY 10467 BRONX (718) 920-4321 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.8797770 -73.8799750 0   5 36 36005 35620 New York-Newark, NY-NJ-CT-PA Central Bronx County https://data.medicare.gov/resource/xubh-q36u/row-68wi.jiky_xtpg 330059 650857 2019-06-03 2018-12-31 1300 54 22   16 50 1458 55 16           1529
310 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
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
378 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 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
387 387 LANDMARK MEDICAL CENTER 115 CASS AVENUE WOONSOCKET RI 2895 PROVIDENCE (401) 769-4100 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.0053200 -71.4962100 0   7 44 44007 39300 Boston-Worcester-Providence, MA-RI-NH-CT Central Providence County https://data.medicare.gov/resource/xubh-q36u/row-ywvs_4dtp_6u43 410011 649821 2019-06-03 2018-12-31 107 16         123 18             141
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
456 456 OLEAN GENERAL HOSPITAL 515 MAIN STREET OLEAN NY 14760 CATTARAUGUS (716) 373-2600 Acute Care Hospitals Proprietary TRUE 42.0894480 -78.4269770 0   9 36 36009 36460 Buffalo-Cheektowaga, NY Central Cattaraugus County https://data.medicare.gov/resource/xubh-q36u/row-hkii~eckc~6rgh 330103 650862 2019-06-03 2018-12-31 260           260 14     293       567
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
588 588 SUTTER DELTA MEDICAL CENTER 3901 LONE TREE WAY ANTIOCH CA 94509 CONTRA COSTA (925) 779-7200 Acute Care Hospitals Voluntary non-profit - Private TRUE 37.9822950 -121.8046810 0   13 6 6013 41860 San Jose-San Francisco-Oakland, CA Outlying Contra Costa County https://data.medicare.gov/resource/xubh-q36u/row-g62s-vt5f~r4p4 50523 650956 2019-06-03 2018-12-31 129 12       4 145               145
591 591 LONGMONT UNITED HOSPITAL 1950 MOUNTAIN VIEW AVE LONGMONT CO 80501 BOULDER (303) 651-5111 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.1813240 -105.1263820 0   13 8 8013 14500 Denver-Aurora, CO Central Boulder County https://data.medicare.gov/resource/xubh-q36u/row-46cx.u9fm~wqwb 60003 649707 2019-06-03 2018-12-31 109 16         131               131
592 592 CENTURA HEALTH-AVISTA ADVENTIST HOSPITAL 100 HEALTH PARK DR LOUISVILLE CO 80027 BOULDER (303) 673-1280 Acute Care Hospitals Voluntary non-profit - Church TRUE 39.9508470 -105.1491540 0   13 8 8013 14500 Denver-Aurora, CO Central Boulder County https://data.medicare.gov/resource/xubh-q36u/row-mqpm_6h4w_if8p 60103 649709 2019-06-03 2018-12-31 74 8         108               108
595 595 GOOD SAMARITAN MEDICAL CENTER 200 EXEMPLA CIRCLE LAFAYETTE CO 80026 BOULDER (303) 689-4000 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.9697530 -105.0830650 0   13 8 8013 14500 Denver-Aurora, CO Central Boulder County https://data.medicare.gov/resource/xubh-q36u/row-rxs8-5fmc-dv4k 60116 650243 2019-06-03 2018-12-31 147 24         183               183
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
643 643 ST CHARLES PRINEVILLE 384 SE COMBS FLAT ROAD PRINEVILLE OR 97754 CROOK (541) 447-6254 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.2980930 -120.8269680 0   13 41 41013 39260 Bend-Redmond-Prineville, OR Central Crook County https://data.medicare.gov/resource/xubh-q36u/row-yy7v_qhni~xpgc 381313 651052 2019-06-03 2018-12-31 16           16               16
656 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
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
679 679 BAYFRONT HEALTH PORT CHARLOTTE 2500 HARBOR BLVD PORT CHARLOTTE FL 33952 CHARLOTTE (941) 766-4122 Acute Care Hospitals Proprietary TRUE 26.9898400 -82.0966820 0   15 12 12015 39460 North Port-Sarasota, FL Central Charlotte County https://data.medicare.gov/resource/xubh-q36u/row-hxde-mw35~h46w 100077 649183 2019-06-03 2018-12-31 225 22         254               254
682 682 KANSAS MEDICAL CENTER LLC 1124 WEST 21ST STREET ANDOVER KS 67002 BUTLER (316) 300-4000 Acute Care Hospitals Proprietary TRUE 37.7232400 -97.1464800 0   15 20 20015 48620 Wichita-Arkansas City-Winfield, KS Outlying Butler County https://data.medicare.gov/resource/xubh-q36u/row-nnyh-wp4p~qnyp 170197 649587 2019-06-03 2018-12-31 45 10         55               55
691 691 SLEEPY EYE MUNICIPAL HOSPITAL 400 FOURTH AVENUE NORTHWEST SLEEPY EYE MN 56085 BROWN (507) 794-3571 Critical Access Hospitals Government - Local TRUE 44.2993190 -94.7273150 0   15 27 27015 35580 Mankato-New Ulm-North Mankato, MN Central Brown County https://data.medicare.gov/resource/xubh-q36u/row-td5y_avnx_gs7p 241327 651011 2019-06-03 2018-12-31 16           16               16
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
766 766 CAREPOINT HEALTH-HOBOKEN UNIVERSITY MEDICAL CENTER 308 WILLOW AVE HOBOKEN NJ 7030 HUDSON (201) 418-1000 Acute Care Hospitals Voluntary non-profit - Church TRUE 40.7412130 -74.0335590 0   17 34 34017 35620 New York-Newark, NY-NJ-CT-PA Central Hudson County https://data.medicare.gov/resource/xubh-q36u/row-64ry-qaxe-vxjm 310040 649624 2019-06-03 2018-12-31 102 15         117 47 11   15       190
767 767 CAREPOINT HEALTH-CHRIST HOSPITAL 176 PALISADE AVE JERSEY CITY NJ 7306 HUDSON (201) 795-8200 Acute Care Hospitals Voluntary non-profit - Church TRUE 40.7348760 -74.0501420 0   17 34 34017 35620 New York-Newark, NY-NJ-CT-PA Central Hudson County https://data.medicare.gov/resource/xubh-q36u/row-zyny.ji2k-c7cs 310016 648953 2019-06-03 2018-12-31 160 18         178               178
770 770 CAREPOINT HEALTH - BAYONNE MEDICAL CENTER 29 EAST 29TH ST BAYONNE NJ 7002 HUDSON (201) 858-5000 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.6675310 -74.1123710 0   17 34 34017 35620 New York-Newark, NY-NJ-CT-PA Central Hudson County https://data.medicare.gov/resource/xubh-q36u/row-mid8_cv5r~b776 310025 651019 2019-06-03 2018-12-31 117 14         131 15     17       163
782 782 ST CHARLES BEND 2500 NE NEFF ROAD BEND OR 97701 DESCHUTES (541) 382-4321 Acute Care Hospitals Voluntary non-profit - Private TRUE 44.0657570 -121.2666610 0   17 41 41017 13460 Bend-Redmond-Prineville, OR Central Deschutes County https://data.medicare.gov/resource/xubh-q36u/row-c338~bvm4~22pp 380047 651050 2019-06-03 2018-12-31 192 30         222 15 13           250
783 783 ST CHARLES REDMOND 1253 NW CANAL BLVD REDMOND OR 97756 DESCHUTES (541) 548-8131 Acute Care Hospitals Voluntary non-profit - Private TRUE 44.2887030 -121.1685580 0   17 41 41017 13460 Bend-Redmond-Prineville, OR Central Deschutes County https://data.medicare.gov/resource/xubh-q36u/row-hegt-uv48.px87 380040 651049 2019-06-03 2018-12-31 42 6         48               48
785 785 ROTHMAN ORTHOPAEDIC SPECIALTY HOSPITAL LLC 3300 TILLMAN DRIVE BENSALEM PA 19020 BUCKS (215) 244-7400 Acute Care Hospitals Proprietary FALSE 40.1143500 -74.9620930 0   17 42 42017 37980 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Bucks County https://data.medicare.gov/resource/xubh-q36u/row-w5gs-9pze-8zau 390322 649490 2019-06-03 2018-12-31 24           24               24
806 806 BANNER - UNIVERSITY MEDICAL CENTER TUCSON CAMPUS 1625 NORTH CAMPBELL AVENUE TUCSON AZ 85724 PIMA (520) 874-4189 Acute Care Hospitals Voluntary non-profit - Private TRUE 32.2423620 -110.9440920 0   19 4 4019 46060 Tucson-Nogales, AZ Central Pima County https://data.medicare.gov/resource/xubh-q36u/row-vwgy.bhrj~yxk9 30064 650939 2019-06-03 2018-12-31 329 90         479               479
808 808 BANNER-UNIVERSITY MEDICAL CENTER SOUTH CAMPUS 2800 EAST AJO WAY TUCSON AZ 85713 PIMA (520) 874-2000 Acute Care Hospitals Voluntary non-profit - Private TRUE 32.1778820 -110.9308910 0   19 4 4019 46060 Tucson-Nogales, AZ Central Pima County https://data.medicare.gov/resource/xubh-q36u/row-chg3-jijt~hfj8 30111 650941 2019-06-03 2018-12-31 120 12         132 18             150
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
837 837 RIDGEVIEW MEDICAL CENTER 500 SOUTH MAPLE STREET WACONIA MN 55387 CARVER (952) 442-2191 Acute Care Hospitals Voluntary non-profit - Private TRUE 44.8433060 -93.7907720 0   19 27 27019 33460 Minneapolis-St. Paul, MN-WI Central Carver County https://data.medicare.gov/resource/xubh-q36u/row-pv9b_ri9h.z92e 240056 651008 2019-06-03 2018-12-31 87 18 7       112 12             124
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
1047 1047 SAMARITAN HOSPITAL 801 EAST WHEELER ROAD MOSES LAKE WA 98837 GRANT (509) 765-5606 Acute Care Hospitals Government - Hospital District or Authority TRUE 47.1311150 -119.2647350 0   25 53 53025 34180 Moses Lake-Othello, WA Central Grant County https://data.medicare.gov/resource/xubh-q36u/row-6jdp_7427-cpfp 500033 659384 2019-06-03 2018-12-31 36 12         48               48
1053 1053 UNITYPOINT HEALTH - MERITER 202 S PARK ST MADISON WI 53715 DANE (608) 417-6000 Acute Care Hospitals Voluntary non-profit - Private TRUE 43.0653850 -89.4008960 0   25 55 55025 31540 Madison-Janesville-Beloit, WI Central Dane County https://data.medicare.gov/resource/xubh-q36u/row-9k9c_6zuc.te68 520089 649377 2019-06-03 2018-12-31 217 16         275 15             290
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
1136 1136 HIGHPOINT HEALTH 600 WILSON CREEK RD LAWRENCEBURG IN 47025 DEARBORN (812) 537-1010 Acute Care Hospitals Government - Local TRUE 39.1129220 -84.8839510 0   29 18 18029 17140 Cincinnati-Wilmington-Maysville, OH-KY-IN Outlying Dearborn County https://data.medicare.gov/resource/xubh-q36u/row-ngjg.xy9w~6uaw 150086 649567 2019-06-03 2018-12-31 78 8         86               86
1155 1155 BERTRAND CHAFFEE HOSPITAL 224 EAST MAIN STREET SPRINGVILLE NY 14141 ERIE (716) 592-2871 Acute Care Hospitals Voluntary non-profit - Church TRUE 42.5084840 -78.6592350 0   29 36 36029 15380 Buffalo-Cheektowaga, NY Central Erie County https://data.medicare.gov/resource/xubh-q36u/row-kh2y-a8h3~k7jx 330111 650864 2019-06-03 2018-12-31 21   2       23       80       103
1157 1157 SISTERS OF CHARITY HOSPITAL 2157 MAIN STREET BUFFALO NY 14214 ERIE (716) 862-1000 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.9291700 -78.8499160 0   29 36 36029 15380 Buffalo-Cheektowaga, NY Central Erie County https://data.medicare.gov/resource/xubh-q36u/row-tkhh.t5uq_u2r8 330078 650858 2019-06-03 2018-12-31 316 30       40 386       80       466
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
1201 1201 CENTURA HEALTH-PORTER ADVENTIST HOSPITAL 2525 S DOWNING ST DENVER CO 80210 DENVER (303) 778-1955 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.6706400 -104.9734820 0   31 8 8031 19740 Denver-Aurora, CO Central Denver County https://data.medicare.gov/resource/xubh-q36u/row-7qah~g3t4-w829 60064 649874 2019-06-03 2018-12-31 140 36         176 44 13           233
1261 1261 SOUTH SHORE HOSPITAL 8012 SOUTH CRANDON AVENUE CHICAGO IL 60617 COOK (773) 356-5000 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.7494960 -87.5686230 0   31 17 17031 16980 Chicago-Naperville, IL-IN-WI Central Cook County https://data.medicare.gov/resource/xubh-q36u/row-9q83~u6ff_gcv4 140181 650991 2019-06-03 2018-12-31 114 8         122 15             137
1267 1267 YORK HOSPITAL 15 HOSPITAL DRIVE YORK ME 3909 YORK (207) 363-4321 Acute Care Hospitals Voluntary non-profit - Private TRUE 43.1427990 -70.6510940 0   31 23 23031 38860 Portland-Lewiston-South Portland, ME Central York County https://data.medicare.gov/resource/xubh-q36u/row-d4r3_kkiu_3jv2 200020 651001 2019-06-03 2018-12-31 61 5         66               66
1278 1278 SOUTHEASTHEALTH 1701 LACEY ST CAPE GIRARDEAU MO 63701 CAPE GIRARDEAU (573) 334-4822 Acute Care Hospitals Voluntary non-profit - Private TRUE 37.3112730 -89.5409360 0   31 29 29031 16020 Cape Girardeau-Sikeston, MO-IL Central Cape Girardeau County https://data.medicare.gov/resource/xubh-q36u/row-3xtx.vgkn~wt2v 260110 650168 2019-06-03 2018-12-31 155           181   13           194
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

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