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

4,766 rows sorted by PRVDR_NUM

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

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
4536 4536 SEARHC WRANGELL MEDICAL CENTER-CAH 310 BENNETT STREET PO BOX 1081 WRANGELL AK 99929 WRANGELL CITY AND BOROUGH (907) 874-7000 Critical Access Hospitals Government - Local FALSE 56.4716460 -132.3764140 0   275 2 2275         https://data.medicare.gov/resource/xubh-q36u/row-n33k~as59_upeg 21305 645317 2019-03-18 2018-10-31 8           8       14       22
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
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
4294 4294 NORTON SOUND REGIONAL HOSPITAL 1000 GREG KRUSCHEK AVENUE (P O BOX 966) NOME AK 99762 NOME (907) 443-3311 Critical Access Hospitals Tribal TRUE 64.4992304 -165.3784042 1 ROOFTOP 180 2 2180         https://data.medicare.gov/resource/xubh-q36u/row-2xs3~z9eg.fia9 21308 646669 2019-04-15 2018-09-30 18           18       18       36
2424 2424 KANAKANAK HOSPITAL P O BOX 130 DILLINGHAM AK 99576 DILLINGHAM (907) 842-5201 Critical Access Hospitals Voluntary non-profit - Private TRUE 59.0397222 -158.4575000 1 GEOMETRIC_CENTER 70 2 2070         https://data.medicare.gov/resource/xubh-q36u/row-j4d4-bz29~h79d 21309 646376 2019-03-28 2018-09-30 18           18               18
4344 4344 MANIILAQ HEALTH CENTER PO BOX 43 KOTZEBUE AK 99752 NORTHWEST ARTIC BOROUGH (907) 442-3321 Critical Access Hospitals Tribal TRUE 66.8961387 -162.5868698 1 ROOFTOP 188 2 2188         https://data.medicare.gov/resource/xubh-q36u/row-5pbr_yrqg~qkzd 21310 646530 2019-03-29 2018-09-30 17           17               17
3797 3797 KETCHIKAN MEDICAL CENTER 3100 TONGASS AVENUE KETCHIKAN AK 99901 KETCHIKAN GATEWAY (907) 225-5171 Critical Access Hospitals Voluntary non-profit - Church TRUE 55.3527170 -131.6860490 0   130 2 2130 28540   Central Ketchikan Gateway Borough https://data.medicare.gov/resource/xubh-q36u/row-qt33-ugsf~ggm9 21311 661277 2019-12-03 2019-06-30 21 4         25       29       54
4321 4321 SAMUEL SIMMONDS MEMORIAL HOSPITAL 7000 UULA ST BARROW AK 99723 NORTH SLOPE BOROUH (907) 852-4611 Critical Access Hospitals Government - Federal TRUE 71.2981350 -156.7273200 0   185 2 2185         https://data.medicare.gov/resource/xubh-q36u/row-5czr-fghi_bwfa 21312 646058 2019-03-29 2018-09-30 20           20               20
3667 3667 SOUTH PENINSULA HOSPITAL 4300 BARTLETT ST HOMER AK 99603 KENAI PENINSULA (907) 235-8101 Critical Access Hospitals Voluntary non-profit - Private TRUE 59.6521330 -151.5502960 0   122 2 2122         https://data.medicare.gov/resource/xubh-q36u/row-cng5-kv9j-dmyn 21313 659751 2019-11-25 2019-06-30 21           21       28       49
4485 4485 MT EDGECUMBE HOSPITAL 222 TONGASS DR SITKA AK 99835 SITKA BOROUGH (907) 966-2411 Critical Access Hospitals Voluntary non-profit - Private TRUE 57.0520100 -135.3563530 0   220 2 2220         https://data.medicare.gov/resource/xubh-q36u/row-rbyg_8vzk~9w5v 21314 646531 2019-03-29 2018-09-30 25           25               25
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
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
991 991 VERDE VALLEY MEDICAL CENTER 269 SOUTH CANDY LANE COTTONWOOD AZ 86326 YAVAPAI (928) 773-2357 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.7362010 -112.0317840 0   25 4 4025 39140   Central Yavapai County https://data.medicare.gov/resource/xubh-q36u/row-ijum~m4k2-ih8a 30007 661278 2019-11-27 2019-06-30 74 13         87 11             98
801 801 ST. MARY'S HOSPITAL 1601 WEST ST MARY'S ROAD TUCSON AZ 85745 PIMA (520) 872-3000 Acute Care Hospitals Voluntary non-profit - Private TRUE 32.2289230 -111.0000320 0   19 4 4019 46060 Tucson-Nogales, AZ Central Pima County https://data.medicare.gov/resource/xubh-q36u/row-8z3y-kp4a.tw3t 30010 644007 2019-02-28 2018-09-30 300 40   9     349 23 28           400
807 807 ST JOSEPH'S HOSPITAL 350 NORTH WILMOT ROAD TUCSON AZ 85711 PIMA (520) 873-3000 Acute Care Hospitals Voluntary non-profit - Other TRUE 32.2259460 -110.8578380 0   19 4 4019 46060 Tucson-Nogales, AZ Central Pima County https://data.medicare.gov/resource/xubh-q36u/row-trzm-jqcs_wpf7 30011 644090 2019-02-28 2018-09-30 377 32       30 451 15 20           486
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
1059 1059 YUMA REGIONAL MEDICAL CENTER 2400 SOUTH AVENUE A YUMA AZ 85364 YUMA (928) 336-7600 Acute Care Hospitals Voluntary non-profit - Private TRUE 32.6838990 -114.6332380 0   27 4 4027 49740   Central Yuma County https://data.medicare.gov/resource/xubh-q36u/row-vbe2.gm3a_7tw7 30013 644624 2019-02-28 2018-09-30 344 42       20 406               406
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
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
564 564 VALLEYWISE HEALTH MEDICAL CENTER 2601 EAST ROOSEVELT STREET PHOENIX AZ 85008 MARICOPA (602) 344-5011 Acute Care Hospitals Government - Local TRUE 33.4585250 -112.0264300 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-c5qr_etcr-7dch 30022 661279 2018-12-03 2018-06-30 211 20   19 13   323 241             564
255 255 FLAGSTAFF MEDICAL CENTER 1200 NORTH BEAVER STREET FLAGSTAFF AZ 86001 COCONINO (928) 779-3366 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.2095340 -111.6448350 0   5 4 4005 22380   Central Coconino County https://data.medicare.gov/resource/xubh-q36u/row-bzd3~hd4v-cg2f 30023 662010 2019-11-27 2019-06-30 183 41       18 242 22             264
568 568 ST. JOSEPH'S HOSPITAL AND MEDICAL CENTER 350 WEST THOMAS ROAD PHOENIX AZ 85013 MARICOPA (602) 406-5001 Acute Care Hospitals Voluntary non-profit - Church TRUE 33.4802940 -112.0792080 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-kyrc_3hbc_et9k 30024 658638 2019-10-10 2018-06-30 268   24   32   460   52           512
565 565 ABRAZO CENTRAL CAMPUS 2000 WEST BETHANY HOME ROAD PHOENIX AZ 85015 MARICOPA (602) 249-0212 Acute Care Hospitals Physician TRUE 33.5241160 -112.1019340 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-apke-ic6r-dws7 30030 654065 2019-08-30 2019-03-31 116 28         144   16           160
563 563 CHANDLER REGIONAL MEDICAL CENTER 1955 WEST FRYE ROAD CHANDLER AZ 85224 MARICOPA (480) 728-3000 Acute Care Hospitals Voluntary non-profit - Other TRUE 33.2986910 -111.8735080 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-zqcn.hhh2-gsee 30036 659471 2019-11-18 2019-01-31 277 49         338               338
557 557 ST LUKE'S MEDICAL CENTER 1800 EAST VAN BUREN STREET PHOENIX AZ 85006 MARICOPA (602) 251-8156 Acute Care Hospitals Proprietary TRUE 33.4514360 -112.0427670 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-uw3s~cbm4-5jyq 30037 655739 2019-10-31 2019-05-31 141 30         171 55 16           242
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
138 138 CANYON VISTA MEDICAL CENTER 5700 EAST HIGHWAY 90 SIERRA VISTA AZ 85635 COCHISE (520) 263-3001 Acute Care Hospitals Voluntary non-profit - Other TRUE 31.5546350 -110.2307260 0   3 4 4003 43420   Central Cochise County https://data.medicare.gov/resource/xubh-q36u/row-ghfv-yx8h~hkgn 30043 654824 2019-09-30 2019-04-30 63 12         75 19             94
670 670 KINGMAN REGIONAL MEDICAL CENTER 3269 STOCKTON HILL ROAD KINGMAN AZ 86409 MOHAVE (928) 757-2101 Acute Care Hospitals Government - Hospital District or Authority TRUE 35.2199070 -114.0358130 0   15 4 4015 29420 Las Vegas-Henderson, NV-AZ Central Mohave County https://data.medicare.gov/resource/xubh-q36u/row-3ksp.3iej_8pd7 30055 660485 2019-11-27 2019-06-30 176 20         196   18       12   226
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
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
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
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
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
669 669 HAVASU REGIONAL MEDICAL CENTER 101 CIVIC CENTER LANE LAKE HAVASU CITY AZ 86403 MOHAVE (928) 855-8185 Acute Care Hospitals Proprietary TRUE 34.4799800 -114.3385370 0   15 4 4015 29420 Las Vegas-Henderson, NV-AZ Central Mohave County https://data.medicare.gov/resource/xubh-q36u/row-kbv6-rmcu~b79y 30069 661849 2019-02-04 2018-08-31 128 16         144       19       163
38 38 FORT DEFIANCE INDIAN HOSPITAL PO BOX 649 FORT DEFIANCE AZ 86504 APACHE (928) 729-8000 Acute Care Hospitals Government - Federal TRUE 35.7593170 -109.0483992 1 GEOMETRIC_CENTER 1 4 4001         https://data.medicare.gov/resource/xubh-q36u/row-ss8d_atq6.7xb3 30071 651311 2019-07-02 2018-09-30 56           56               56
256 256 TUBA CITY REGIONAL HEALTH CARE CORPORATION PO BOX 600 TUBA CITY AZ 86045 COCONINO (928) 283-2501 Acute Care Hospitals Voluntary non-profit - Other FALSE 36.1279296 -111.2249984 1 ROOFTOP 5 4 4005 22380   Central Coconino County https://data.medicare.gov/resource/xubh-q36u/row-hne8.hg7p.2gfd 30073 651368 2019-07-01 2018-09-30 73           73               73
800 800 SELLS HOSPITAL HIGHWAY 86, AT TOPAWA ROAD SELLS AZ 85634 PIMA (520) 362-7003 Acute Care Hospitals Tribal TRUE 31.9183549 -111.8792747 1 GEOMETRIC_CENTER 19 4 4019 46060 Tucson-Nogales, AZ Central Pima County https://data.medicare.gov/resource/xubh-q36u/row-57e8_mqp9-5x9d 30074 651599 2019-07-10 2018-09-30 14           14               14
404 404 SAN CARLOS APACHE HEALTHCARE 103 MEDICINE WAY ROAD PERIDOT AZ 85542 GILA (928) 475-1200 Acute Care Hospitals Government - Federal FALSE 33.2956419 -110.4178011 1 ROOFTOP 9 4 4009 40940   Central Graham County https://data.medicare.gov/resource/xubh-q36u/row-9543-jpqy.dn76 30077 651688 2019-07-01 2018-09-30 8           8               8
554 554 PHOENIX INDIAN MEDICAL CENTER 4212 NORTH 16TH STREET PHOENIX AZ 85016 MARICOPA (602) 263-1200 Acute Care Hospitals Government - Federal FALSE 33.4970100 -112.0476130 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-gzm7-4h6v-chi5 30078 651313 2019-07-02 2018-09-30 133           133               133
549 549 ABRAZO SCOTTSDALE CAMPUS 3929 EAST BELL ROAD PHOENIX AZ 85032 MARICOPA (602) 923-5000 Acute Care Hospitals Proprietary TRUE 33.6406030 -111.9976920 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-3yrx.bcen.wd4a 30083 644698 2019-02-28 2018-09-30 113 14         127               127
40 40 CHINLE COMPREHENSIVE HEALTH CARE FACILITY US HWY 191, HOSPITAL ROAD CHINLE AZ 86503 APACHE (928) 674-7001 Acute Care Hospitals Government - Federal TRUE 36.1575812 -109.6076963 1 GEOMETRIC_CENTER 1 4 4001         https://data.medicare.gov/resource/xubh-q36u/row-u7kj_iqgg.38d9 30084 649393 2019-06-12 2018-09-30 60           60               60
803 803 NORTHWEST MEDICAL CENTER 6200 NORTH LA CHOLLA BOULEVARD TUCSON AZ 85741 PIMA (520) 469-8100 Acute Care Hospitals Proprietary TRUE 32.3195810 -111.0120540 0   19 4 4019 46060 Tucson-Nogales, AZ Central Pima County https://data.medicare.gov/resource/xubh-q36u/row-yv8p.eeec-pmxw 30085 646415 2019-03-28 2018-09-30 231 35         281   13           294
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
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
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
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
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
566 566 ABRAZO ARROWHEAD CAMPUS 18701 NORTH 67TH AVENUE GLENDALE AZ 85308 MARICOPA (623) 561-1000 Acute Care Hospitals Proprietary TRUE 33.6550420 -112.2028890 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-mbqg~urbx.9rm7 30094 654000 2019-08-29 2019-03-31 224 38         262               262
668 668 WESTERN ARIZONA REGIONAL MEDICAL CENTER 2735 SILVER CREEK ROAD BULLHEAD CITY AZ 86442 MOHAVE (928) 763-2273 Acute Care Hospitals Proprietary TRUE 35.1098530 -114.5551460 0   15 4 4015 29420 Las Vegas-Henderson, NV-AZ Central Mohave County https://data.medicare.gov/resource/xubh-q36u/row-95sy-y45e~48d6 30101 656846 2019-01-31 2018-08-31 107 32         139               139
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
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
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
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
577 577 ABRAZO WEST CAMPUS 13677 WEST MCDOWELL ROAD GOODYEAR AZ 85395 MARICOPA (623) 882-1970 Acute Care Hospitals Proprietary TRUE 33.4642830 -112.3540240 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-6kds~arrq.mhdd 30110 654825 2019-09-26 2019-04-30 159 20         179               179
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
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
723 723 WHITERIVER PHS INDIAN HOSPITAL 200 WEST HOSPITAL DRIVE (PO BOX 860) WHITERIVER AZ 85941 NAVAJO (928) 338-4911 Acute Care Hospitals Government - Federal FALSE 33.8759760 -109.9595280 0   17 4 4017 43320   Central Navajo County https://data.medicare.gov/resource/xubh-q36u/row-v5m3-a25g-4tei 30113 650108 2019-06-15 2018-09-30 40           40               40
802 802 ORO VALLEY HOSPITAL 1551 EAST TANGERINE ROAD ORO VALLEY AZ 85755 PIMA (520) 901-3549 Acute Care Hospitals Proprietary TRUE 32.4271830 -110.9495400 0   19 4 4019 46060 Tucson-Nogales, AZ Central Pima County https://data.medicare.gov/resource/xubh-q36u/row-mmb4.ma8p-hv7h 30114 644207 2019-02-27 2018-09-30 75 36         111 17 18           146
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
671 671 VALLEY VIEW MEDICAL CENTER 5330 SOUTH HIGHWAY 95 FORT MOHAVE AZ 86426 MOHAVE (928) 788-2273 Acute Care Hospitals Proprietary TRUE 35.0023630 -114.5979540 0   15 4 4015 29420 Las Vegas-Henderson, NV-AZ Central Mohave County https://data.medicare.gov/resource/xubh-q36u/row-8tpg-vtcr.3uy5 30117 652034 2019-05-02 2018-11-30 60 12         72   12           84
561 561 MERCY GILBERT MEDICAL CENTER 3555 SOUTH VAL VISTA DRIVE GILBERT AZ 85297 MARICOPA (480) 728-8000 Acute Care Hospitals Voluntary non-profit - Church TRUE 33.2866610 -111.7553110 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-ab5w_8jiw.5ys7 30119 662011 2019-12-03 2019-06-30 174 24         198               198
570 570 MOUNTAIN VISTA MEDICAL CENTER, LP 1301 SOUTH CRISMON ROAD MESA AZ 85209 MARICOPA (480) 358-6100 Acute Care Hospitals Proprietary TRUE 33.3911000 -111.6153290 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-aus8~8k4g-9a4c 30121 659181 2019-11-21 2019-06-30 112 30         142 20             162
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
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
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
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
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
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
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
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
137 137 BENSON HOSPITAL 450 SOUTH OCOTILLO AVENUE BENSON AZ 85602 COCHISE (520) 586-2261 Critical Access Hospitals Voluntary non-profit - Private TRUE 31.9648290 -110.3071230 0   3 4 4003 43420   Central Cochise County https://data.medicare.gov/resource/xubh-q36u/row-bbyb-3jvj_e7ef 31301 660910 2019-11-25 2019-06-30 22           22               22
139 139 NORTHERN COCHISE COMMUNITY HOSPITAL, INC. 901 WEST REX ALLEN DRIVE WILLCOX AZ 85643 COCHISE (520) 384-3541 Critical Access Hospitals Government - Hospital District or Authority TRUE 32.2642680 -109.8376130 0   3 4 4003 43420   Central Cochise County https://data.medicare.gov/resource/xubh-q36u/row-ydad~45b6.8t7t 31302 660487 2019-12-02 2019-06-30 24           24       24       48
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
724 724 HOPI HEALTH CARE CENTER HIGHWAY 264, MILEPOST 388 POLACCA AZ 86042 NAVAJO (928) 737-6000 Critical Access Hospitals Tribal FALSE 35.8022226 -110.4260281 1 GEOMETRIC_CENTER 17 4 4017 43320   Central Navajo County https://data.medicare.gov/resource/xubh-q36u/row-6zw9_3xdm~7vqp 31305 646377 2019-03-28 2018-09-30 6           6               6
546 546 PARKER INDIAN HEALTH CENTER 12033 AGENCY ROAD PARKER AZ 85344 LAPAZ (928) 669-2137 Critical Access Hospitals Government - Federal TRUE 34.1464940 -114.3013140 0   12 4 4012         https://data.medicare.gov/resource/xubh-q36u/row-942m-hgdi~yjfy 31307 645964 2019-04-01 2018-09-30 20           20               20
878 878 HUHU KAM MEMORIAL HOSPITAL 483 WEST SEED FARM ROAD SACATON AZ 85147 PINAL (520) 562-3321 Critical Access Hospitals Government - Federal TRUE 33.0741220 -111.7590800 0   21 4 4021 38060   Central Pinal County https://data.medicare.gov/resource/xubh-q36u/row-fpem.7xy6-nzbf 31308 645965 2019-03-28 2018-09-30 12           12               12
39 39 SAGE MEMORIAL HOSPITAL STATE ROUTE 264 SOUTH 191 GANADO AZ 86505 APACHE (928) 755-4541 Critical Access Hospitals Voluntary non-profit - Private FALSE 35.7108602 -109.5423597 1 ROOFTOP 1 4 4001         https://data.medicare.gov/resource/xubh-q36u/row-vmgp-erfi.puty 31309 652060 2019-05-06 2018-09-30 25           25               25
721 721 LITTLE COLORADO MEDICAL CENTER 1501 NORTH WILLIAMSON AVENUE WINSLOW AZ 86047 NAVAJO (928) 289-4691 Critical Access Hospitals Voluntary non-profit - Private TRUE 35.0354550 -110.6917420 0   17 4 4017 43320   Central Navajo County https://data.medicare.gov/resource/xubh-q36u/row-wt4g_v5ea_tink 31311 643756 2019-02-27 2018-09-30 25           25               25
136 136 COPPER QUEEN COMMUNITY HOSPITAL 101 COLE AVENUE BISBEE AZ 85603 COCHISE (520) 432-6401 Critical Access Hospitals Voluntary non-profit - Private TRUE 31.4172540 -109.8826000 0   3 4 4003 43420   Central Cochise County https://data.medicare.gov/resource/xubh-q36u/row-3x2q~x9dv.fg6n 31312 659555 2019-11-25 2019-06-30 14           14               14
941 941 HOLY CROSS HOSPITAL 1171 WEST TARGET RANGE ROAD NOGALES AZ 85621 SANTA CRUZ (520) 285-3000 Critical Access Hospitals Proprietary TRUE 31.3411180 -110.9587340 0   23 4 4023 35700 Tucson-Nogales, AZ Central Santa Cruz County https://data.medicare.gov/resource/xubh-q36u/row-datt~k3n6_g682 31313 644092 2019-02-28 2018-09-30 25           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
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
547 547 LA PAZ REGIONAL HOSPITAL 1200 WEST MOHAVE ROAD PARKER AZ 85344 LAPAZ (928) 669-9201 Critical Access Hospitals Voluntary non-profit - Private TRUE 34.1351370 -114.2855970 0   12 4 4012         https://data.medicare.gov/resource/xubh-q36u/row-sg3z_d8n6.kjbm 31317 643569 2019-02-25 2018-09-30 22 3         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
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
560 560 HACIENDA CHILDREN'S HOSPITAL, INC. 610 WEST JEROME AVENUE MESA AZ 85210 MARICOPA (602) 243-4231 Childrens Proprietary FALSE 33.3811280 -111.8448920 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-r4wv.uiyn_d6cn 33303 654954 2018-11-26 2018-07-31                              
340 340 SILOAM SPRINGS REGIONAL HOSPITAL 603 NORTH PROGRESS AVENUE SILOAM SPRINGS AR 72761 BENTON (479) 524-4141 Acute Care Hospitals Voluntary non-profit - Other TRUE 36.1903770 -94.5096580 0   7 5 5007 22220   Central Benton County https://data.medicare.gov/resource/xubh-q36u/row-6neb~fx59-g35b 40001 653533 2019-08-30 2019-03-31 38 6         44               44
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
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
3579 3579 CHI-ST VINCENT INFIRMARY TWO ST VINCENT CIRCLE LITTLE ROCK AR 72205 PULASKI (501) 552-3000 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.7502877 -92.3393435 1 ROOFTOP 119 5 5119 30780 Little Rock-North Little Rock, AR Central Pulaski County https://data.medicare.gov/resource/xubh-q36u/row-rvvz~qyi8_5qyq 40007 660911 2019-12-02 2019-06-30 330 23 20     20 393               393
341 341 MERCY HOSPITAL NORTHWEST ARKANSAS 2710 SOUTH RIFE MEDICAL LANE ROGERS AR 72758 BENTON (479) 338-8000 Acute Care Hospitals Voluntary non-profit - Church TRUE 36.3095620 -94.1847090 0   7 5 5007 22220   Central Benton County https://data.medicare.gov/resource/xubh-q36u/row-3g3b-cs9n_qbhj 40010 660742 2019-12-04 2019-06-30 174 24         206               206
4010 4010 CHAMBERS MEMORIAL HOSPITAL 719 DETROIT STREET DANVILLE AR 72833 YELL (479) 495-2241 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.0548230 -93.3885430 0   149 5 5149 40780   Outlying Yell County https://data.medicare.gov/resource/xubh-q36u/row-d59r_eigs_n4bw 40011 660743 2019-12-03 2019-06-30 30           30 12             42
3967 3967 WHITE COUNTY MEDICAL CENTER 3214 EAST RACE AVENUE SEARCY AR 72143 WHITE (501) 278-3100 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.2504460 -91.6967580 0   145 5 5145 42620 Little Rock-North Little Rock, AR Central White County https://data.medicare.gov/resource/xubh-q36u/row-b6nk.pamh_stfx 40014 644701 2019-02-28 2018-09-30 192 13         205 30 37           272
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
3577 3577 UAMS MEDICAL CENTER 4301 WEST MARKHAM STREET MAIL SLOT 612 LITTLE ROCK AR 72205 PULASKI (501) 686-5000 Acute Care Hospitals Government - State TRUE 34.7515830 -92.3209980 0   119 5 5119 30780 Little Rock-North Little Rock, AR Central Pulaski County https://data.medicare.gov/resource/xubh-q36u/row-s6x4~kv5r_9fry 40016 660912 2019-12-03 2019-06-30 389 28 24     64 505               505
405 405 NORTH ARKANSAS REGIONAL MEDICAL CENTER 620 NORTH MAIN STREET HARRISON AR 72601 BOONE (870) 414-4000 Acute Care Hospitals Voluntary non-profit - Other TRUE 36.2362810 -93.1071480 0   9 5 5009 25460   Central Boone County https://data.medicare.gov/resource/xubh-q36u/row-arky~dirt~vz74 40017 653366 2019-09-03 2019-03-31 96 24         120 14         4   138
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
3672 3672 FORREST CITY MEDICAL CENTER 1601 NEWCASTLE ROAD FORREST CITY AR 72335 ST. FRANCIS (870) 261-0000 Acute Care Hospitals Proprietary TRUE 35.0392750 -90.7718940 0   123 5 5123 22620 Memphis-Forrest City, TN-MS-AR Central St. Francis County https://data.medicare.gov/resource/xubh-q36u/row-3mpt-bp6e-mmwc 40019 654002 2019-08-28 2018-09-30 50 6         56 14             70
1199 1199 ST BERNARDS MEDICAL CENTER 225 E JACKSON JONESBORO AR 72401 CRAIGHEAD (870) 972-4100 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.8374780 -90.7021420 0   31 5 5031 27860 Jonesboro-Paragould, AR Central Craighead County https://data.medicare.gov/resource/xubh-q36u/row-tdxp_ingv-y9gs 40020 644208 2019-02-27 2018-09-30 287 30         329 24         20   373
3941 3941 NORTHWEST MEDICAL CENTER-SPRINGDALE 609 WEST MAPLE AVENUE SPRINGDALE AR 72764 WASHINGTON (479) 751-5711 Acute Care Hospitals Proprietary TRUE 36.1813940 -94.1364640 0   143 5 5143 22220   Central Washington County https://data.medicare.gov/resource/xubh-q36u/row-atff~z7gw_d5cc 40022 646013 2019-03-29 2018-10-31 254 21         275   25           300

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