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 county_name

View and edit SQL

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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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 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 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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
1895 MEMORIAL HEALTH UNIVERSITY MEDICAL CENTER 4700 WATERS AVENUE SAVANNAH GA 31404 CHATHAM (912) 350-3691 Acute Care Hospitals Voluntary non-profit - Other TRUE 32.0317850 -81.0918270 0   51 13 13051 42340 Savannah-Hinesville-Statesboro, GA Central Chatham County https://data.medicare.gov/resource/xubh-q36u/row-amaq_j44a_mqc4 110036 651266 2019-06-03 2018-12-31 381 20       10 525 10             535
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
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
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
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
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 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
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
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
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
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
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
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
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
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
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
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
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
1821 NOVANT HEALTH UVA HEALTH SYSTEM CULPEPER MED CENTE 501 SUNSET LANE CULPEPER VA 22701 CULPEPER (540) 829-4100 Acute Care Hospitals Voluntary non-profit - Other TRUE 38.4548480 -78.0113050 0   47 51 51047 47900 Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Outlying Culpeper County https://data.medicare.gov/resource/xubh-q36u/row-mbvh-ne84~5vxg 490019 650389 2019-06-03 2018-12-31 64 6         70               70
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
1410 UNIVERSITY HOSPITALS AHUJA MEDICAL CENTER 3999 RICHMOND ROAD BEACHWOOD OH 44122 CUYAHOGA (216) 593-5510 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.4532710 -81.4977080 0   35 39 39035 17460 Cleveland-Akron-Canton, OH Central Cuyahoga County https://data.medicare.gov/resource/xubh-q36u/row-h29e.2x8g.g5ac 360359 649650 2019-06-03 2018-12-31 117 20         137               137
1416 UH CLEVELAND MEDICAL CENTER 11100 EUCLID AVENUE CLEVELAND OH 44106 CUYAHOGA (216) 844-1000 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.5073090 -81.6072390 0   35 39 39035 17460 Cleveland-Akron-Canton, OH Central Cuyahoga County https://data.medicare.gov/resource/xubh-q36u/row-592r~6dmu~cw94 360137 649643 2019-06-03 2018-12-31 515 30 20     19 624 41     26       691
1420 UHHS RICHMOND HEIGHTS HOSPITAL 27100 CHARDON ROAD RICHMOND HEIGHTS OH 44143 CUYAHOGA (440) 585-6170 Acute Care Hospitals Proprietary TRUE 41.5810430 -81.4902720 0   35 39 39035 17460 Cleveland-Akron-Canton, OH Central Cuyahoga County https://data.medicare.gov/resource/xubh-q36u/row-rvfd.96ei_5i7w 360075 649315 2019-06-03 2018-12-31 84 17         101               101
3496 TEXAS HEALTH PRESBYTERIAN HOSPITAL DALLAS 8200 WALNUT HILL LANE DALLAS TX 75231 DALLAS (214) 345-6789 Acute Care Hospitals Voluntary non-profit - Private TRUE 32.8831390 -96.7635740 0   113 48 48113 19100 Dallas-Fort Worth, TX-OK Central Dallas County https://data.medicare.gov/resource/xubh-q36u/row-bqmw-xz7n-5cyp 450462 650908 2019-06-03 2018-12-31 428 48         567 17 45           629
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 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
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
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
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
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 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
1381 PARKER ADVENTIST HOSPITAL 9395 CROWN CREST BLVD PARKER CO 80138 DOUGLAS (303) 269-4000 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.5500580 -104.7734330 0   35 8 8035 19740 Denver-Aurora, CO Central Douglas County https://data.medicare.gov/resource/xubh-q36u/row-5jf2-ad3k~8xxe 60114 649876 2019-06-03 2018-12-31 137 16         165               165
1382 CASTLE ROCK ADVENTIST HOSPITAL 2350 MEADOWS BLVD CASTLE ROCK CO 80109 DOUGLAS (720) 455-2500 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.4041120 -104.8861460 0   35 8 8035 19740 Denver-Aurora, CO Central Douglas County https://data.medicare.gov/resource/xubh-q36u/row-k43v-w5np~b8ck 60125 649877 2019-06-03 2018-12-31 41 8         53               53
2019 BOYS TOWN NATIONAL RESEARCH HOSPITAL 555 NORTH 30TH ST OMAHA NE 68131 DOUGLAS (531) 355-6510 Childrens Voluntary non-profit - Private FALSE 41.2645120 -95.9565140 0   55 31 31055 36540 Omaha-Council Bluffs-Fremont, NE-IA Central Douglas County https://data.medicare.gov/resource/xubh-q36u/row-i7r7~v26j~9e2t 283300 650175 2019-06-03 2018-12-31 61           61               61
1741 HAYES GREEN BEACH MEMORIAL HOSPITAL 321 E HARRIS STREET CHARLOTTE MI 48813 EATON (517) 543-1050 Critical Access Hospitals Voluntary non-profit - Other TRUE 42.5649280 -84.8318260 0   45 26 26045 29620 Lansing-East Lansing-Owosso, MI Central Eaton County https://data.medicare.gov/resource/xubh-q36u/row-ty8n~pfwz_x66j 231327 649907 2019-06-03 2018-12-31 25           25               25
1588 ELKHART GENERAL HOSPITAL 600 E BLVD ELKHART IN 46514 ELKHART (574) 294-2621 Acute Care Hospitals Government - Local TRUE 41.6787610 -85.9918330 0   39 18 18039 21140 South Bend-Elkhart-Mishawaka, IN-MI Central Elkhart County https://data.medicare.gov/resource/xubh-q36u/row-xq9p.barv.suqr 150018 649560 2019-06-03 2018-12-31 169 23         200 10 20           230
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 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
1702 FIRELANDS REGIONAL MEDICAL CENTER 1111 HAYES AVENUE SANDUSKY OH 44870 ERIE (419) 557-7400 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.4462220 -82.7087640 0   43 39 39043 41780 Cleveland-Akron-Canton, OH Central Erie County https://data.medicare.gov/resource/xubh-q36u/row-n7hv_3pgi-523a 360025 649306 2019-06-03 2018-12-31 165 18         183   34           217
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
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
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
4435 MEMORIAL HERMANN KATY HOSPITAL 23900 KATY FREEWAY KATY TX 77494 FORT BEND (281) 392-1111 Acute Care Hospitals Voluntary non-profit - Private TRUE 29.7859180 -95.7856570 0   201 48 48201 26420 Houston-The Woodlands, TX Central Harris County https://data.medicare.gov/resource/xubh-q36u/row-zzwh.pxe4.wege 450847 649966 2019-06-03 2018-12-31 152 32       24 208               208
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
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
1860 NATIONWIDE CHILDREN'S HOSPITAL 700 CHILDREN'S DRIVE COLUMBUS OH 43205 FRANKLIN (614) 722-2000 Childrens Voluntary non-profit - Private TRUE 39.9523670 -82.9791240 0   49 39 39049 18140 Columbus-Marion-Zanesville, OH Central Franklin County https://data.medicare.gov/resource/xubh-q36u/row-w2pp_yw5v_tka7 363305 649661 2019-06-03 2018-12-31 339 74       260 673               673
1863 WOODS AT PARKSIDE,THE 349 OLDE RIDENOUR ROAD COLUMBUS OH 43230 FRANKLIN (614) 471-2552 Acute Care Hospitals Proprietary FALSE 40.0268200 -82.8811560 0   49 39 39049 18140 Columbus-Marion-Zanesville, OH Central Franklin County https://data.medicare.gov/resource/xubh-q36u/row-4avu~kmf5~3quj 360247 649648 2019-06-03 2018-12-31 12         38 50               50
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
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
1919 FULTON COUNTY HEALTH CENTER 725 SOUTH SHOOP AVENUE WAUSEON OH 43567 FULTON (419) 335-2015 Critical Access Hospitals Voluntary non-profit - Private TRUE 41.5391930 -84.1342830 0   51 39 39051 45780 Toledo-Port Clinton, OH Outlying Fulton County https://data.medicare.gov/resource/xubh-q36u/row-ccff~w7es.axa7 361333 649657 2019-06-03 2018-12-31 18 7         25 10     17       123
1727 VALLEY VIEW HOSPITAL ASSOCIATION 1906 BLAKE AVE GLENWOOD SPRINGS CO 81601 GARFIELD (970) 945-6535 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.5328590 -107.3227940 0   45 8 8045 24060 Edwards-Glenwood Springs, CO Central Garfield County https://data.medicare.gov/resource/xubh-q36u/row-5apg-mrvs~tb5q 60075 650965 2019-06-03 2018-12-31 24 5         41               41
2033 UH GEAUGA MEDICAL CENTER 13207 RAVENNA RD CHARDON OH 44024 GEAUGA (440) 269-6000 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.5089250 -81.1936200 0   55 39 39055 17460 Cleveland-Akron-Canton, OH Central Geauga County https://data.medicare.gov/resource/xubh-q36u/row-xvjc~ij2i~6gqn 360192 649645 2019-06-03 2018-12-31 112 12         124 18             142
1552 UNITED MEMORIAL MEDICAL CENTER 127 NORTH STREET BATAVIA NY 14020 GENESEE (585) 343-6030 Acute Care Hospitals Voluntary non-profit - Private TRUE 43.0039970 -78.1775920 0   37 36 36037 12860 Rochester-Batavia-Seneca Falls, NY Central Genesee County https://data.medicare.gov/resource/xubh-q36u/row-zitz.a8b6_y8c2 330073 651023 2019-06-03 2018-12-31 123 10         133               133
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
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
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
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
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
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

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