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

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

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: hospital_type, hospital_ownership, emergency_services, geocode_flag, geocode_accuracy, centraloutlyingcounty, burn_beds, surg_icu_beds, subprovider_oth_beds, nursing_fac_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
254 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
480 480 BULLOCK COUNTY HOSPITAL 102 WEST CONECUH AVENUE UNION SPRINGS AL 36089 BULLOCK (334) 738-2140 Acute Care Hospitals Proprietary TRUE 32.1461820 -85.7163800 0   11 1 1011         https://data.medicare.gov/resource/xubh-q36u/row-te44-k6fz_rhpp 10110 648174 2019-05-15 2018-12-31 30           30 24             54
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
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
1197 1197 MEDICAL CENTER ENTERPRISE 400 N EDWARDS STREET ENTERPRISE AL 36330 COFFEE (334) 347-0584 Acute Care Hospitals Proprietary TRUE 31.3181910 -85.8553080 0   31 1 1031 21460 Dothan-Enterprise-Ozark, AL Central Coffee County https://data.medicare.gov/resource/xubh-q36u/row-m58x_64pa.z9zi 10049 648587 2019-05-24 2018-12-31 92 7         99               99
1377 1377 EVERGREEN MEDICAL CENTER 101 CRESTVIEW AVENUE EVERGREEN AL 36401 CONECUH (251) 578-2480 Acute Care Hospitals Proprietary TRUE 31.4312600 -86.9420500 0   35 1 1035         https://data.medicare.gov/resource/xubh-q36u/row-f8ut-az4v~dn63 10148 651159 2019-06-03 2018-12-31 44           44               44
1631 1631 CRENSHAW COMMUNITY HOSPITAL 101 HOSPITAL CIRCLE LUVERNE AL 36049 CRENSHAW (334) 335-3374 Acute Care Hospitals Proprietary TRUE 31.6925950 -86.2661560 0   41 1 1041         https://data.medicare.gov/resource/xubh-q36u/row-7kz6.2gr2.w3cp 10008 647847 2019-05-15 2018-12-31 29           29 20             49
1887 1887 ELMORE COMMUNITY HOSPITAL 500 HOSPITAL DRIVE WETUMPKA AL 36092 ELMORE (334) 567-4311 Acute Care Hospitals Government - State TRUE 32.5519570 -86.1856430 0   51 1 1051 33860   Central Elmore County https://data.medicare.gov/resource/xubh-q36u/row-yfvr~ksbv.udvy 10097 651259 2019-05-29 2018-12-31 33           33               33
1991 1991 RIVERVIEW REGIONAL MEDICAL CENTER 600 SOUTH THIRD STREET GADSDEN AL 35901 ETOWAH (256) 543-5200 Acute Care Hospitals Proprietary TRUE 34.0038110 -86.0040860 0   55 1 1055 23460   Central Etowah County https://data.medicare.gov/resource/xubh-q36u/row-82ed.hku7_uzsa 10046 653738 2019-08-23 2018-12-31 240   16       256 25             281
2099 2099 RUSSELLVILLE HOSPITAL 15155 HIGHWAY 43 RUSSELLVILLE AL 35653 FRANKLIN (256) 332-1611 Acute Care Hospitals Proprietary TRUE 34.5111650 -87.7175850 0   59 1 1059         https://data.medicare.gov/resource/xubh-q36u/row-gwv9.74md~fuic 10158 645962 2019-04-01 2018-12-31 42 7         49               49
2496 2496 PRINCETON BAPTIST MEDICAL CENTER 701 PRINCETON AVENUE SOUTHWEST BIRMINGHAM AL 35211 JEFFERSON (205) 783-3800 Acute Care Hospitals Voluntary non-profit - Church TRUE 33.4991330 -86.8460160 0   73 1 1073 13820 Birmingham-Hoover-Talladega, AL Central Jefferson County https://data.medicare.gov/resource/xubh-q36u/row-hrc7-segv_vve4 10103 651156 2019-05-31 2018-12-31 222 12 12   21 12 279 30             309
2501 2501 BROOKWOOD BAPTIST MEDICAL CENTER 2010 BROOKWOOD MEDICAL CENTER DRIVE BIRMINGHAM AL 35209 JEFFERSON (205) 877-1000 Acute Care Hospitals Proprietary TRUE 33.4629100 -86.7768500 0   73 1 1073 13820 Birmingham-Hoover-Talladega, AL Central Jefferson County https://data.medicare.gov/resource/xubh-q36u/row-6yzq-z9kd_9ua7 10139 650228 2019-05-31 2018-12-31 340 26 27     32 425 140 30           595
2503 2503 CHILDREN'S HOSPITAL OF ALABAMA 1600 SEVENTH AVENUE SOUTH BIRMINGHAM AL 35233 JEFFERSON (205) 939-9100 Childrens Voluntary non-profit - Private TRUE 33.5032220 -86.8053810 0   73 1 1073 13820 Birmingham-Hoover-Talladega, AL Central Jefferson County https://data.medicare.gov/resource/xubh-q36u/row-nh6w~rxvd~itst 13300 651162 2019-06-03 2018-12-31 193     6     341               341
2986 2986 NORTHWEST MEDICAL CENTER 1530 U S HIGHWAY 43 WINFIELD AL 35594 FAYETTE (205) 487-7736 Acute Care Hospitals Proprietary TRUE 33.9293160 -87.8245070 0   93 1 1093         https://data.medicare.gov/resource/xubh-q36u/row-r4dk-tpsz_u57n 10086 651153 2019-06-03 2018-12-31 57 4         61 10             71
3075 3075 SPRINGHILL MEMORIAL HOSPITAL 3719 DAUPHIN STREET MOBILE AL 36608 MOBILE (251) 344-9630 Acute Care Hospitals Proprietary TRUE 30.6859460 -88.1317190 0   97 1 1097 33660 Mobile-Daphne-Fairhope, AL Central Mobile County https://data.medicare.gov/resource/xubh-q36u/row-qtdz-mr4h-ggd9 10144 648881 2019-05-29 2018-12-31 178 20         198   11           209
3188 3188 JACKSON HOSPITAL & CLINIC INC 1725 PINE STREET MONTGOMERY AL 36106 MONTGOMERY (334) 293-8000 Acute Care Hospitals Voluntary non-profit - Private TRUE 32.3666060 -86.2851550 0   101 1 1101 33860   Central Montgomery County https://data.medicare.gov/resource/xubh-q36u/row-q2hf.yb6r~vnhh 10024 648173 2019-05-17 2018-12-31 236 34         270               270
3455 3455 JACK HUGHSTON MEMORIAL HOSPITAL 4401 RIVER CHASE DRIVE PHENIX CITY AL 36867 RUSSELL (334) 732-3000 Acute Care Hospitals Government - State TRUE 32.5090450 -85.0056960 0   113 1 1113 17980 Columbus-Auburn-Opelika, GA-AL Central Russell County https://data.medicare.gov/resource/xubh-q36u/row-6v2c.qrez~vn8e 10168 651160 2019-05-31 2018-12-31 39 8         47               47
3544 3544 SHELBY BAPTIST MEDICAL CENTER 1000 FIRST STREET NORTH ALABASTER AL 35007 SHELBY (205) 620-8100 Acute Care Hospitals Voluntary non-profit - Private TRUE 33.2536790 -86.8142610 0   117 1 1117 13820 Birmingham-Hoover-Talladega, AL Central Shelby County https://data.medicare.gov/resource/xubh-q36u/row-j68e.5ee5_e79h 10016 651149 2019-05-31 2018-12-31 180 32         212 40             252
3574 3574 HILL HOSPITAL OF SUMTER COUNTY 751 DERBY DRIVE YORK AL 36925 SUMTER (205) 392-5263 Acute Care Hospitals Voluntary non-profit - Other TRUE 32.4918250 -88.2960810 0   119 1 1119         https://data.medicare.gov/resource/xubh-q36u/row-hxjd.ga7s.xmvj 10138 651158 2019-06-03 2018-12-31 33           33               33
3626 3626 CITIZENS BAPTIST MEDICAL CENTER 604 STONE AVENUE TALLADEGA AL 35161 TALLADEGA (256) 761-4542 Acute Care Hospitals Voluntary non-profit - Private TRUE 33.4398010 -86.0906410 0   121 1 1121 45180 Birmingham-Hoover-Talladega, AL Central Talladega County https://data.medicare.gov/resource/xubh-q36u/row-wfgi.6wxf-zx48 10101 651155 2019-05-30 2018-12-31 79 6         85 13             98
3670 3670 LAKE MARTIN COMMUNITY HOSPITAL 201 MARIARDEN ROAD DADEVILLE AL 36853 TALLAPOOSA (256) 825-7821 Acute Care Hospitals Proprietary TRUE 32.8187000 -85.7417580 0   123 1 1123         https://data.medicare.gov/resource/xubh-q36u/row-7irr_xm4w_yyg3 10052 649861 2019-05-29 2018-12-31 46           46               46
3671 3671 RUSSELL MEDICAL CENTER 3316 HIGHWAY 280 ALEXANDER CITY AL 35010 TALLAPOOSA (256) 329-7100 Acute Care Hospitals Voluntary non-profit - Private TRUE 32.9310300 -85.9683940 0   123 1 1123         https://data.medicare.gov/resource/xubh-q36u/row-7ugw.v846~xcyn 10065 651308 2019-05-30 2018-12-31 28 6         34               34
3738 3738 WALKER BAPTIST MEDICAL CENTER 3400 HIGHWAY 78 EAST JASPER AL 35502 WALKER (205) 387-4000 Acute Care Hospitals Voluntary non-profit - Private TRUE 33.8411420 -87.2368790 0   127 1 1127 13820 Birmingham-Hoover-Talladega, AL Outlying Walker County https://data.medicare.gov/resource/xubh-q36u/row-kq57-46fi_25ps 10089 651154 2019-05-31 2018-12-31 195 12         207 52             259
3823 3823 LAKELAND COMMUNITY HOSPITAL 42024 HIGHWAY 195 E HALEYVILLE AL 35565 WINSTON (205) 485-7117 Acute Care Hospitals Voluntary non-profit - Church TRUE 34.2417180 -87.5898570 0   133 1 1133         https://data.medicare.gov/resource/xubh-q36u/row-qzez~be97-dgiz 10125 645811 2019-04-01 2018-12-31 45 4         49 9             58
874 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 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
2934 2934 FAIRBANKS MEMORIAL HOSPITAL 1650 COWLES STREET FAIRBANKS AK 99701 FAIRBANKS NORTH STAR (907) 452-8181 Acute Care Hospitals Voluntary non-profit - Private TRUE 64.8314070 -147.7362540 0   90 2 2090 21820   Central Fairbanks North Star Borough https://data.medicare.gov/resource/xubh-q36u/row-e5th.n9ja~cin9 20012 648324 2019-05-28 2018-12-31 109 13         122       90       212
3669 3669 PROVIDENCE SEWARD HOSPITAL 417 FIRST AVENUE, PO BOX 365 SEWARD AK 99664 KENAI PENINSULA (907) 224-5205 Critical Access Hospitals Government - Local TRUE 60.1050460 -149.4453830 0   122 2 2122         https://data.medicare.gov/resource/xubh-q36u/row-bjag~4kwr.8ihd 21302 652058 2019-05-30 2018-12-31 6           6       40       46
4028 4028 PROVIDENCE KODIAK ISLAND MEDICAL CTR 1915 EAST REZANOF DRIVE KODIAK AK 99615 KODIAK ISLAND BOROUGH (907) 486-9592 Critical Access Hospitals Voluntary non-profit - Church TRUE 57.8008350 -152.3739430 0   150 2 2150         https://data.medicare.gov/resource/xubh-q36u/row-3uhe-ufvn.rmdi 21306 652059 2019-05-30 2018-12-31 24           24       22       46
4229 4229 MAT-SU REGIONAL MEDICAL CENTER 2500 SOUTH WOODWORTH LOOP PALMER AK 99645 MATANUSKA-SUSITNA (907) 861-6000 Acute Care Hospitals Voluntary non-profit - Other TRUE 61.5612170 -149.2587180 0   170 2 2170 11260   Outlying Matanuska-Susitna Borough https://data.medicare.gov/resource/xubh-q36u/row-ehb8-yifz_k9ea 20006 648225 2019-05-23 2018-12-31 60 14         74               74
4529 4529 PROVIDENCE VALDEZ MEDICAL CENTER PO BOX 550 VALDEZ AK 99686 VALDEZ-CORDOVA (907) 835-2249 Critical Access Hospitals Government - Local TRUE 61.1364781 -146.3458866 1 ROOFTOP 261 2 2261         https://data.medicare.gov/resource/xubh-q36u/row-2ygw.872k~d2en 21301 652057 2019-05-30 2018-12-31 11           11       10       21
4530 4530 CORDOVA COMMUNITY MEDICAL CENTER PO BOX 160 - 602 CHASE AVENUE CORDOVA AK 99574 VALDEZ-CORDOVA (907) 424-8000 Critical Access Hospitals Government - Local TRUE 60.5413354 -145.7505310 1 ROOFTOP 261 2 2261         https://data.medicare.gov/resource/xubh-q36u/row-kscp_6dza~rvey 21307 650633 2019-05-30 2018-12-31 13           13       10       23
41 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
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
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
338 338 COBRE VALLEY REGIONAL MEDICAL CENTER 5880 SOUTH HOSPITAL DRIVE GLOBE AZ 85501 GILA (928) 402-1122 Critical Access Hospitals Voluntary non-profit - Private TRUE 33.4072060 -110.8262240 0   7 4 4007 37740   Central Gila County https://data.medicare.gov/resource/xubh-q36u/row-n6a8-y7ga.5i9e 31314 651879 2019-07-08 2018-12-31 21 4         25               25
403 403 MT. GRAHAM REGIONAL MEDICAL CENTER 1600 SOUTH 20TH AVENUE SAFFORD AZ 85546 GRAHAM (928) 348-4000 Acute Care Hospitals Government - Hospital District or Authority TRUE 32.8218830 -109.7329940 0   9 4 4009 40940   Central Graham County https://data.medicare.gov/resource/xubh-q36u/row-gesk_r9yi_tbu4 30068 648588 2019-05-21 2018-12-31 49           49               49
539 539 PHOENIX CHILDREN'S HOSPITAL 1919 EAST THOMAS ROAD PHOENIX AZ 85016 MARICOPA (602) 933-1000 Childrens Voluntary non-profit - Private FALSE 33.4802160 -112.0411930 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-feed_vt9a~9ie7 33302 650636 2019-05-31 2018-12-31 352           433               433
550 550 HONORHEALTH DEER VALLEY MEDICAL CENTER 19829 NORTH 27TH AVENUE PHOENIX AZ 85027 MARICOPA (623) 879-6100 Acute Care Hospitals Voluntary non-profit - Private TRUE 33.6664250 -112.1171880 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-npyt_2wmd.v5z4 30092 650232 2019-05-31 2018-12-31 172   32       204               204
551 551 SCOTTSDALE THOMPSON PEAK MEDICAL CENTER 7400 EAST THOMPSON PEAK PARKWAY SCOTTSDALE AZ 85255 MARICOPA (480) 324-7001 Acute Care Hospitals Proprietary TRUE 33.6697770 -111.9218030 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-y7bn~8g49_tr6b 30123 650235 2019-05-31 2018-12-31 112 8         120               120
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
555 555 SCOTTSDALE OSBORN MEDICAL CENTER 7400 EAST OSBORN ROAD SCOTTSDALE AZ 85251 MARICOPA (480) 882-4004 Acute Care Hospitals Proprietary TRUE 33.4876390 -111.9227250 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-xncf.ukg7_66e2 30038 650230 2019-05-31 2018-12-31 268 59         327   14           341
556 556 ARIZONA SPECIALTY HOSPITAL 2905 WEST WARNER ROAD, SUITE 1 CHANDLER AZ 85224 MARICOPA (480) 603-9000 Acute Care Hospitals Proprietary FALSE 33.3348400 -111.8911330 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-z5xq-7gkm.mjtq 30112 649698 2019-05-22 2018-12-31 24           24               24
558 558 JOHN C. LINCOLN NORTH MOUNTAIN HOSPITAL 250 EAST DUNLAP AVENUE PHOENIX AZ 85020 MARICOPA (602) 331-5862 Acute Care Hospitals Voluntary non-profit - Private TRUE 33.5677540 -112.0706300 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-9bpm.fdh7~5snu 30014 650229 2019-05-31 2018-12-31 218 20 24       262               262
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
567 567 MAYO CLINIC HOSPITAL 5777 EAST MAYO BOULEVARD PHOENIX AZ 85054 MARICOPA (480) 342-4201 Acute Care Hospitals Voluntary non-profit - Private TRUE 33.6633120 -111.9556590 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-k7ht.yb86_iied 30103 652131 2019-05-29 2018-12-31 236 30         266   7           273
569 569 SCOTTSDALE SHEA MEDICAL CENTER 9003 EAST SHEA BOULEVARD SCOTTSDALE AZ 85260 MARICOPA (480) 323-3000 Acute Care Hospitals Proprietary TRUE 33.5824670 -111.8860320 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-zegy.nw3j~tfkb 30087 650231 2019-05-31 2018-12-31 378 25       24 427               427
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
574 574 BANNER BOSWELL MEDICAL CENTER 10401 WEST THUNDERBIRD BOULEVARD SUN CITY AZ 85351 MARICOPA (623) 832-4000 Acute Care Hospitals Voluntary non-profit - Other TRUE 33.6047980 -112.2825380 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-jqxq_rtvy~eb3s 30061 654709 2019-09-18 2018-12-31 325 85         410   24   91       525
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
579 579 O.A.S.I.S. HOSPITAL 750 NORTH 40TH STREET PHOENIX AZ 85008 MARICOPA (602) 797-7700 Acute Care Hospitals Voluntary non-profit - Private FALSE 33.4567200 -111.9952100 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-ca9p~mgu7-kv2v 30131 650634 2019-05-29 2018-12-31 60 4         64               64
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
581 581 ARIZONA SPINE AND JOINT HOSPITAL 4620 EAST BASELINE ROAD MESA AZ 85206 MARICOPA (480) 832-4770 Acute Care Hospitals Physician FALSE 33.3792060 -111.7346950 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-ijxi~2kwd~swq9 30107 650233 2019-05-29 2018-12-31 23           23               23
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
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
804 804 SANTA CRUZ VALLEY REGIONAL HOSPITAL 4455 SOUTH I-19 FRONTAGE ROAD GREEN VALLEY AZ 85614 PIMA (520) 393-4700 Acute Care Hospitals Proprietary TRUE 31.8079430 -111.0109660 0   19 4 4019 46060 Tucson-Nogales, AZ Central Pima County https://data.medicare.gov/resource/xubh-q36u/row-td2s-wa4r_529q 30137 650635 2019-05-28 2018-12-31 43 6         49               49
805 805 TUCSON MEDICAL CENTER 5301 EAST GRANT ROAD TUCSON AZ 85712 PIMA (520) 327-5461 Acute Care Hospitals Voluntary non-profit - Private TRUE 32.2507490 -110.8801690 0   19 4 4019 46060 Tucson-Nogales, AZ Central Pima County https://data.medicare.gov/resource/xubh-q36u/row-5nrs.x5vc.rfrt 30006 652130 2019-05-24 2018-12-31 351 36       42 441 16         16   473
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
879 879 BANNER IRONWOOD MEDICAL CENTER 37000 NORTH GANTZEL ROAD QUEEN CREEK AZ 85140 PINAL (480) 394-4030 Acute Care Hospitals Voluntary non-profit - Private TRUE 33.2148390 -111.5634470 0   21 4 4021 38060   Central Pinal County https://data.medicare.gov/resource/xubh-q36u/row-fe4r-4dm6.g4np 30130 651969 2019-07-10 2018-12-31 53           53               53
880 880 BANNER GOLDFIELD MEDICAL CENTER 2050 WEST SOUTHERN AVENUE APACHE JUNCTION AZ 85120 PINAL (480) 733-3300 Acute Care Hospitals Voluntary non-profit - Other TRUE 33.3933430 -111.5667960 0   21 4 4021 38060   Central Pinal County https://data.medicare.gov/resource/xubh-q36u/row-kbdi-vrc2_5ngf 30134 652991 2019-07-29 2018-12-31 20           20               20
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
993 993 YAVAPAI REGIONAL MEDICAL CENTER 1003 WILLOW CREEK ROAD PRESCOTT AZ 86301 YAVAPAI (928) 445-2700 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.5593800 -112.4820650 0   25 4 4025 39140   Central Yavapai County https://data.medicare.gov/resource/xubh-q36u/row-rugm_x4ib~bga9 30012 647851 2019-05-15 2018-12-31 180 26         206               206
42 42 BAPTIST HEALTH MEDICAL CENTER-STUTTGART 1703 NORTH BUERKLE ST STUTTGART AR 72160 ARKANSAS (870) 673-3511 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.5177730 -91.5575720 0   1 5 5001         https://data.medicare.gov/resource/xubh-q36u/row-rh96.h2uy.6pb9 40072 649864 2019-05-31 2018-12-31 49           49               49
258 258 BAXTER REGIONAL MEDICAL CENTER 624 HOSPITAL DRIVE MOUNTAIN HOME AR 72653 BAXTER (870) 508-1000 Acute Care Hospitals Voluntary non-profit - Private TRUE 36.3430670 -92.3959050 0   5 5 5005 34260   Central Baxter County https://data.medicare.gov/resource/xubh-q36u/row-pjhy~i9v2.r6ud 40027 650559 2019-05-31 2018-12-31 153 17         170 19 23       12   224
339 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
673 673 EUREKA SPRINGS HOSPITAL, LLC 24 NORRIS STREET EUREKA SPRINGS AR 72632 CARROLL (479) 253-7400 Critical Access Hospitals Proprietary TRUE 36.4004330 -93.7446990 0   15 5 5015         https://data.medicare.gov/resource/xubh-q36u/row-fpuw-vbap-fsdb 41304 647643 2019-05-14 2018-12-31 15           15               15
809 809 BAPTIST HEALTH MEDICAL CENTER-ARKADELPHIA 3050 TWIN RIVERS DRIVE ARKADELPHIA AR 71923 CLARK (870) 245-2622 Critical Access Hospitals Voluntary non-profit - Private TRUE 34.1228020 -93.0879700 0   19 5 5019 11660   Central Clark County https://data.medicare.gov/resource/xubh-q36u/row-f8ss.59v5_rxma 41321 649536 2019-05-31 2018-12-31 25           25               25
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
942 942 BAPTIST HEALTH MEDICAL CENTER HEBER SPINGS 1800 BYPASS ROAD HEBER SPRINGS AR 72543 CLEBURNE (501) 887-3000 Critical Access Hospitals Voluntary non-profit - Private TRUE 35.5065780 -92.0013190 0   23 5 5023         https://data.medicare.gov/resource/xubh-q36u/row-d26c_x5yu_6fn3 41312 651551 2019-05-31 2018-12-31 25           25               25
1312 1312 SPARKS MEDICAL CENTER - VAN BUREN 211 CRAWFORD MEMORIAL DRIVE VAN BUREN AR 72956 CRAWFORD (479) 474-3401 Acute Care Hospitals Proprietary TRUE 35.4341750 -94.3394510 0   33 5 5033 22900   Central Crawford County https://data.medicare.gov/resource/xubh-q36u/row-w5xt~zwtc_2chf 40018 649071 2019-05-31 2018-12-31 31 8         39               39
1581 1581 DALLAS COUNTY MEDICAL CENTER 201 CLIFTON STREET FORDYCE AR 71742 DALLAS (870) 352-6300 Critical Access Hospitals Government - Local TRUE 33.8111580 -92.4250580 0   39 5 5039         https://data.medicare.gov/resource/xubh-q36u/row-vfqi-mtmw~p9xt 41317 646016 2019-04-01 2018-12-31 22           22               22
1721 1721 BAPTIST HEALTH MEDICAL CENTER-CONWAY 1555 EXCHANGE AVENUE CONWAY AR 72032 FAULKNER (501) 585-2000 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.0564394 -92.4192706 1 ROOFTOP 45 5 5045 30780 Little Rock-North Little Rock, AR Outlying Faulkner County https://data.medicare.gov/resource/xubh-q36u/row-begn.7uvq~4sez 40154 650111 2019-05-31 2018-12-31 102 8         110               110
1722 1722 CONWAY REGIONAL HEALTH SYSTEM 2302 COLLEGE AVENUE CONWAY AR 72034 FAULKNER (501) 329-3831 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.0848260 -92.4571030 0   45 5 5045 30780 Little Rock-North Little Rock, AR Outlying Faulkner County https://data.medicare.gov/resource/xubh-q36u/row-ycii~pfah-qxh7 40029 649018 2019-05-28 2018-12-31 122 17         139 11             150
1888 1888 LEVI HOSPITAL 300 PROSPECT AVE HOT SPRINGS AR 71901 GARLAND (501) 624-1281 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.5099450 -93.0566490 0   51 5 5051 26300 Hot Springs-Malvern, AR Central Garland County https://data.medicare.gov/resource/xubh-q36u/row-assk.a57a-njvy 40132 649865 2019-05-24 2018-12-31 1           1 52             53
2100 2100 BAPTIST HEALTH MEDICAL CENTER-HOT SPRINGS COUNTY 1001 SCHNEIDER DRIVE MALVERN AR 72104 HOT SPRING (501) 332-1000 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.3589130 -92.7864180 0   59 5 5059 31680 Hot Springs-Malvern, AR Central Hot Spring County https://data.medicare.gov/resource/xubh-q36u/row-ua4e~kvad.yq4u 40076 648522 2019-05-31 2018-12-31 58 6         64               64
2426 2426 JOHNSON REGIONAL MEDICAL CENTER 1100 EAST POPLAR STREET CLARKSVILLE AR 72830 JOHNSON (479) 754-5454 Acute Care Hospitals Government - Local TRUE 35.4643840 -93.4457970 0   71 5 5071         https://data.medicare.gov/resource/xubh-q36u/row-uar5.h8rs.rsi2 40002 648883 2019-05-30 2018-12-31 49 8         57 20 12           89
2987 2987 GREAT RIVER MEDICAL CENTER 1520 N DIVISION STREET BLYTHEVILLE AR 72315 MISSISSIPPI (870) 838-7300 Acute Care Hospitals Government - Local TRUE 35.9430110 -89.9189290 0   93 5 5093 14180   Central Mississippi County https://data.medicare.gov/resource/xubh-q36u/row-hp5p.n74y_egzs 40069 650436 2019-06-05 2018-12-31 28 5         33               33
2988 2988 SOUTH MISSISSISSPI COUNTY REGIONAL MEDICAL CENTER 611 WEST LEE AVENUE OSCEOLA AR 72370 MISSISSIPPI (870) 563-7000 Critical Access Hospitals Government - Local TRUE 35.7002490 -89.9749300 0   93 5 5093 14180   Central Mississippi County https://data.medicare.gov/resource/xubh-q36u/row-q7uu-6ehf~4s6v 41316 650798 2019-06-05 2018-12-31 25           25               25
3334 3334 HELENA REGIONAL MEDICAL CENTER 1801 MARTIN LUTHER KING JR DRIVE HELENA AR 72342 PHILLIPS (870) 338-5800 Acute Care Hospitals Proprietary TRUE 34.5083570 -90.6273300 0   107 5 5107 25760   Central Phillips County https://data.medicare.gov/resource/xubh-q36u/row-wchu_rtin.sqck 40085 654083 2019-08-27 2018-12-31 121 6         127               127
3456 3456 MENA REGIONAL HEALTH SYSTEM 311 NORTH MORROW STREET MENA AR 71953 POLK (479) 394-6100 Acute Care Hospitals Government - Local TRUE 34.5883860 -94.2213830 0   113 5 5113         https://data.medicare.gov/resource/xubh-q36u/row-wwwj_a4gs~ixth 40015 648521 2019-05-22 2018-12-31 35 6         41 12 12           65
3576 3576 ARKANSAS SURGICAL HOSPITAL 5201 NORTH SHORE DRIVE NO LITTLE ROCK AR 72118 PULASKI (501) 748-8000 Acute Care Hospitals Proprietary TRUE 34.8014580 -92.3476870 0   119 5 5119 30780 Little Rock-North Little Rock, AR Central Pulaski County https://data.medicare.gov/resource/xubh-q36u/row-y6hc~2xha_rqkj 40147 649072 2019-05-31 2018-12-31 49           49               49
3580 3580 BAPTIST HEALTH MEDICAL CENTER-LITTLE ROCK 9601 INTERSTATE LITTLE ROCK AR 72205 PULASKI (501) 202-2000 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.7443211 -92.3806640 1 ROOFTOP 119 5 5119 30780 Little Rock-North Little Rock, AR Central Pulaski County https://data.medicare.gov/resource/xubh-q36u/row-bf2h_7zv8-2ay2 40114 651550 2019-05-31 2018-12-31 513 36 18   18   683 24     27       734
3584 3584 BAPTIST HEALTH MEDICAL CENTER NORTH LITTLE ROCK 3333 SPRINGHILL DRIVE NORTH LITTLE ROCK AR 72117 PULASKI (501) 202-3000 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.7840750 -92.2186330 0   119 5 5119 30780 Little Rock-North Little Rock, AR Central Pulaski County https://data.medicare.gov/resource/xubh-q36u/row-kf3z.y9gr-2kzx 40036 649019 2019-05-31 2018-12-31 143 17 17       177   16   12       205
3627 3627 FIVE RIVERS MEDICAL CENTER 2801 MEDICAL CENTER DRIVE POCAHONTAS AR 72455 RANDOLPH (870) 892-6000 Acute Care Hospitals Government - Local TRUE 36.2899110 -90.9963340 0   121 5 5121         https://data.medicare.gov/resource/xubh-q36u/row-ts7c.8t6h-nknu 40047 649534 2019-06-07 2018-12-31 30 2         32 12             44
3799 3799 BAPTIST HEALTH - FORT SMITH 1001 TOWSON AVENUE FORT SMITH AR 72901 SEBASTIAN (479) 441-4000 Acute Care Hospitals Proprietary TRUE 35.3745270 -94.4213110 0   131 5 5131 22900   Central Sebastian County https://data.medicare.gov/resource/xubh-q36u/row-4ynv.ndxe~fmn4 40055 650435 2019-05-31 2018-12-31 289 31         320 23             343
3939 3939 NORTHWEST HEALTH PHYSICIANS SPECIALTY HOSPITAL 3873 NORTH PARKVIEW DRIVE FAYETTEVILLE AR 72703 WASHINGTON (479) 571-7002 Acute Care Hospitals Proprietary TRUE 36.1213300 -94.1337300 0   143 5 5143 22220   Central Washington County https://data.medicare.gov/resource/xubh-q36u/row-dtfa_7iaz.thv8 40152 650236 2019-06-03 2018-12-31 20           20               20
3942 3942 WASHINGTON REGIONAL MEDICAL CENTER 3215 N NORTH HILLS BOULEVARD FAYETTEVILLE AR 72703 WASHINGTON (479) 463-5113 Acute Care Hospitals Voluntary non-profit - Private TRUE 36.1109840 -94.1578620 0   143 5 5143 22220   Central Washington County https://data.medicare.gov/resource/xubh-q36u/row-2bs7.twrk_htcb 40004 649161 2019-06-03 2018-12-31 226 40         320           12   332
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
50 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 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 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 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
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

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