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 zip_code descending

✎ 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, subprovider_oth_beds, filed_date (date), fy_end_date (date)

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
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
4484 4484 SITKA COMMUNITY HOSPITAL 209 MOLLER DRIVE SITKA AK 99835 SITKA BOROUGH (907) 747-3241 Critical Access Hospitals Government - Local TRUE 57.0589920 -135.3459290 0   220 2 2220         https://data.medicare.gov/resource/xubh-q36u/row-asew~ba2y_nt2p 21303 638783 2018-12-03 2018-06-30 12           12       15       27
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
4375 4375 PETERSBURG MEDICAL CENTER PO BOX 589 PETERSBURG AK 99833 PETERSBURG BOROUGH (907) 772-4291 Critical Access Hospitals Government - Local TRUE 56.8128691 -132.9554619 1 ROOFTOP 195 2 2195         https://data.medicare.gov/resource/xubh-q36u/row-ky7y_b72j_698p 21304 660160 2019-12-02 2019-06-30 12           12       15       27
3411 3411 BARTLETT REGIONAL HOSPITAL 3260 HOSPITAL DR JUNEAU AK 99801 JUNEAU (907) 796-8900 Acute Care Hospitals Government - Local TRUE 58.3286960 -134.4668290 0   110 2 2110 27940   Central Juneau City and Borough https://data.medicare.gov/resource/xubh-q36u/row-ceet-msjy~uqhq 20008 659178 2019-11-21 2019-06-30 36 9         45 12             57
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
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
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
2933 2933 Bassett ACH (FT Wainwright) 4076 Neely Road Fort Wainwright AK 99703 FAIRBANKS NORTH STAR (907) 361-4000 Acute Care - Department of Defense Department of Defense TRUE 64.8277880 -147.6647670 0   90 2 2090 21820   Central Fairbanks North Star Borough https://data.medicare.gov/resource/xubh-q36u/row-rx2u.ys9t~8f9q                                      
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
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
3668 3668 CENTRAL PENINSULA GENERAL HOSPITAL 250 HOSPITAL PLACE SOLDOTNA AK 99669 KENAI PENINSULA (907) 262-4404 Acute Care Hospitals Voluntary non-profit - Other TRUE 60.4938650 -151.0776580 0   122 2 2122         https://data.medicare.gov/resource/xubh-q36u/row-kgwk-j25h-z8m3 20024 661276 2019-12-02 2019-06-30 43 6         49       60       109
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
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
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
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
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
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
1885 1885 YUKON KUSKOKWIM DELTA REG HOSPITAL PO BOX 287 BETHEL AK 99559 BETHEL (907) 543-6300 Acute Care Hospitals Tribal TRUE 60.7922222 -161.7558334 1 GEOMETRIC_CENTER 50 2 2050         https://data.medicare.gov/resource/xubh-q36u/row-7gdx-n37w_5vx9 20018 651309 2019-07-02 2018-09-30 34           34               34
873 873 ALASKA NATIVE MEDICAL CENTER 4315 DIPLOMACY DR ANCHORAGE AK 99508 ANCHORAGE (907) 729-3971 Acute Care Hospitals Government - Federal TRUE 61.1818900 -149.8005780 0   20 2 2020 11260   Central Anchorage Municipality https://data.medicare.gov/resource/xubh-q36u/row-5h7d.5evj.yxgq 20026 651310 2019-07-01 2018-09-30 173         1 174               174
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
875 875 673rd Medical Group (Joint Base Elmendorf-Richardson) 673 MDG 5955 Zeamer Ave JBER AK 99506 ANCHORAGE (907) 384-1110 Acute Care - Department of Defense Department of Defense TRUE 61.2348208 -149.7449348 1 ROOFTOP 20 2 2020 11260   Central Anchorage Municipality https://data.medicare.gov/resource/xubh-q36u/row-pmg3~gpys_qbnx                                      
249 249 TRI-STATE MEMORIAL HOSPITAL 1221 HIGHLAND AVENUE CLARKSTON WA 99403 ASOTIN (509) 758-5511 Critical Access Hospitals Voluntary non-profit - Private TRUE 46.4036380 -117.0545070 0   3 53 53003 30300   Central Asotin County https://data.medicare.gov/resource/xubh-q36u/row-i7hs.ad2c-g7gn 501332 649847 2019-06-03 2018-12-31 25           25               25
2493 2493 PROVIDENCE ST MARY MEDICAL CENTER 401 W POPLAR ST WALLA WALLA WA 99362 WALLA WALLA (509) 522-5900 Acute Care Hospitals Voluntary non-profit - Private TRUE 46.0629400 -118.3431360 0   71 53 53071 47460   Central Walla Walla County https://data.medicare.gov/resource/xubh-q36u/row-rrzg.4k6a~mq7s 500002 648784 2019-05-29 2018-12-31 86 28       6 120   8           128
327 327 KADLEC REGIONAL MEDICAL CENTER 888 SWIFT BLVD RICHLAND WA 99352 BENTON (509) 946-4611 Acute Care Hospitals Voluntary non-profit - Private TRUE 46.2804620 -119.2811210 0   5 53 53005 28420   Central Benton County https://data.medicare.gov/resource/xubh-q36u/row-k3yx.t79z-wduq 500058 648786 2019-05-29 2018-12-31 201 30       27 258   12           270
326 326 PROSSER MEMORIAL HOSPITAL 723 MEMORIAL STREET PROSSER WA 99350 BENTON (509) 786-2222 Critical Access Hospitals Government - Hospital District or Authority TRUE 46.2076300 -119.7635020 0   5 53 53005 28420   Central Benton County https://data.medicare.gov/resource/xubh-q36u/row-jxdy-bhag~5gk3 501312 652444 2019-05-31 2018-12-31 25           25               25
984 984 GARFIELD COUNTY MEMORIAL HOSPITAL 66 NORTH SIXTH STREET POMEROY WA 99347 GARFIELD (509) 843-1591 Critical Access Hospitals Government - Hospital District or Authority TRUE 46.4751830 -117.6025510 0   23 53 53023         https://data.medicare.gov/resource/xubh-q36u/row-estz_txzt_98nt 501301 650792 2019-05-30 2018-12-31 25           25               25
128 128 OTHELLO COMMUNITY HOSPITAL 315 NORTH 14TH AVENUE OTHELLO WA 99344 ADAMS (509) 488-2636 Critical Access Hospitals Government - Hospital District or Authority TRUE 46.8303630 -119.1543630 0   1 53 53001 36830 Moses Lake-Othello, WA Central Adams County https://data.medicare.gov/resource/xubh-q36u/row-5z56.vhnt-5g9t 501318 658624 2019-11-12 2018-12-31 16           16               16
328 328 TRIOS 900 SOUTH AUBURN STREET KENNEWICK WA 99336 BENTON (509) 586-6111 Acute Care Hospitals Government - Hospital District or Authority TRUE 46.1988750 -119.1184630 0   5 53 53005 28420   Central Benton County https://data.medicare.gov/resource/xubh-q36u/row-hs4k~gp5j~yv74 500053 651430 2019-06-03 2018-12-31 87 14       10 111               111
659 659 DAYTON GENERAL HOSPITAL 1012 SOUTH 3RD STREET DAYTON WA 99328 COLUMBIA (509) 382-2531 Critical Access Hospitals Government - Hospital District or Authority FALSE 46.3125640 -117.9688720 0   13 53 53013 47460   Outlying Columbia County https://data.medicare.gov/resource/xubh-q36u/row-28j5-9jsv-a9rd 501302 648506 2019-05-23 2018-12-31 25           25         23     48
933 933 LOURDES MEDICAL CENTER 520 N FOURTH AVENUE PASCO WA 99301 FRANKLIN (509) 546-2278 Critical Access Hospitals Voluntary non-profit - Church TRUE 46.2350260 -119.0944360 0   21 53 53021 28420   Central Franklin County https://data.medicare.gov/resource/xubh-q36u/row-h47i.7rwx-7e8h 501337 642976 2019-02-04 2018-08-31 25           25   10           35
2277 2277 MULTICARE VALLEY HOSPITAL 12606 EAST MISSION AVENUE SPOKANE WA 99216 SPOKANE (509) 924-6650 Acute Care Hospitals Voluntary non-profit - Private TRUE 47.6716470 -117.2358680 0   63 53 53063 44060 Spokane-Spokane Valley-Coeur d'Alene, WA-ID Central Spokane County https://data.medicare.gov/resource/xubh-q36u/row-kh34~2725_xseq 500119 649375 2019-05-30 2018-12-31 113 10         123               123
2275 2275 MULTICARE DEACONESS HOSPITAL W 800 FIFTH AVENUE SPOKANE WA 99210 SPOKANE (509) 473-5800 Acute Care Hospitals Voluntary non-profit - Private TRUE 47.6520746 -117.4232235 1 ROOFTOP 63 53 53063 44060 Spokane-Spokane Valley-Coeur d'Alene, WA-ID Central Spokane County https://data.medicare.gov/resource/xubh-q36u/row-yuz3-454p_9mcv 500044 646412 2019-03-28 2018-12-31 184 35         267               267
2276 2276 PROVIDENCE HOLY FAMILY HOSPITAL 5633 NORTH LIDGERWOOD SPOKANE WA 99208 SPOKANE (509) 482-2450 Acute Care Hospitals Voluntary non-profit - Private TRUE 47.7097510 -117.4059040 0   63 53 53063 44060 Spokane-Spokane Valley-Coeur d'Alene, WA-ID Central Spokane County https://data.medicare.gov/resource/xubh-q36u/row-f3tf.yzjd.sw7e 500077 648661 2019-05-23 2018-12-31 170 14         184               184
2274 2274 SHRINERS HOSPITAL FOR CHILDREN 911 WEST 5TH AVENUE SPOKANE WA 99204 SPOKANE (509) 623-0422 Childrens Voluntary non-profit - Private FALSE 47.6513980 -117.4259570 0   63 53 53063 44060 Spokane-Spokane Valley-Coeur d'Alene, WA-ID Central Spokane County https://data.medicare.gov/resource/xubh-q36u/row-mctz_2czz-inqw 503302 645453 2018-05-31 2017-12-31                              
2278 2278 PROV SACRED HRT MED CTR & CHILDS HOSP. 101 WEST 8TH AVENUE SPOKANE WA 99204 SPOKANE (509) 474-3040 Acute Care Hospitals Voluntary non-profit - Church TRUE 47.6483100 -117.4121680 0   63 53 53063 44060 Spokane-Spokane Valley-Coeur d'Alene, WA-ID Central Spokane County https://data.medicare.gov/resource/xubh-q36u/row-5nf9~jrxm.scdv 500054 652282 2019-05-30 2018-12-31 478 20 34     61 612 20             632
129 129 EAST ADAMS RURAL HOSPITAL 903 SOUTH ADAMS RITZVILLE WA 99169 ADAMS (509) 659-1200 Critical Access Hospitals Government - Hospital District or Authority TRUE 47.1209590 -118.3722580 0   1 53 53001 36830 Moses Lake-Othello, WA Central Adams County https://data.medicare.gov/resource/xubh-q36u/row-37up~x54g-vsqq 501311 653086 2019-05-31 2018-12-31 12           12               12
867 867 FERRY COUNTY MEMORIAL HOSPITAL 36 KLONDIKE ROAD REPUBLIC WA 99166 FERRY (509) 775-3333 Critical Access Hospitals Government - Hospital District or Authority TRUE 48.6527450 -118.7331770 0   19 53 53019         https://data.medicare.gov/resource/xubh-q36u/row-jpw5_zjbs_mmqe 501322 659388 2019-05-29 2018-12-31 25           25               25
2586 2586 PULLMAN REGIONAL HOSPITAL 835 S BISHOP BLVD PULLMAN WA 99163 WHITMAN (509) 332-2541 Critical Access Hospitals Government - Hospital District or Authority TRUE 46.7134620 -117.1698460 0   75 53 53075 39420 Pullman-Moscow, WA-ID Central Whitman County https://data.medicare.gov/resource/xubh-q36u/row-r8f3-95u9.2qf7 501331 648169 2019-05-20 2018-12-31 19 6         25               25
1714 1714 ODESSA MEMORIAL HEALTHCARE CENTER 502 E AMENDE DRIVE ODESSA WA 99159 LINCOLN (509) 982-2611 Critical Access Hospitals Government - Hospital District or Authority TRUE 47.3315920 -118.6821000 0   43 53 53043         https://data.medicare.gov/resource/xubh-q36u/row-3g78.g9dg.38qw 501307 646279 2019-04-10 2018-12-31 25           25           12   37
1936 1936 NEWPORT COMMUNITY HOSPITAL 714 WEST PINE STREET NEWPORT WA 99156 PEND OREILLE (509) 447-2441 Critical Access Hospitals Government - Hospital District or Authority TRUE 48.1821700 -117.0484200 0   51 53 53051 44060 Spokane-Spokane Valley-Coeur d'Alene, WA-ID Outlying Pend Oreille County https://data.medicare.gov/resource/xubh-q36u/row-kwpj_pxfj.xt2b 501310 649686 2019-05-31 2018-12-31 20           20       50       70
1046 1046 COULEE MEDICAL CENTER 411 FORTUYN ROAD GRAND COULEE WA 99133 GRANT (509) 633-1753 Critical Access Hospitals Government - Hospital District or Authority TRUE 47.9423820 -119.0055550 0   25 53 53025 34180 Moses Lake-Othello, WA Central Grant County https://data.medicare.gov/resource/xubh-q36u/row-6v8e_j4a4~k6ja 501308 659386 2019-05-28 2018-12-31 25           25               25
1715 1715 LINCOLN HOSPITAL 10 NICHOLS STREET DAVENPORT WA 99122 LINCOLN (509) 725-7101 Critical Access Hospitals Government - Hospital District or Authority TRUE 47.6571949 -118.1462384 1 RANGE_INTERPOLATED 43 53 53043         https://data.medicare.gov/resource/xubh-q36u/row-3c5v_e33f-mmva 501305 647597 2019-05-13 2018-12-31 25           25               25
2329 2329 PROVIDENCE MOUNT CARMEL HOSPITAL 982 EAST COLUMBIA COLVILLE WA 99114 STEVENS (509) 684-2561 Critical Access Hospitals Voluntary non-profit - Church TRUE 48.5413030 -117.8923850 0   65 53 53065 44060 Spokane-Spokane Valley-Coeur d'Alene, WA-ID Outlying Stevens County https://data.medicare.gov/resource/xubh-q36u/row-bdxz~aq5d-z6tm 501326 652171 2019-05-30 2018-12-31 25           25               25
2585 2585 WHITMAN HOSPITAL AND MEDICAL CENTER 1200 WEST FAIRVIEW COLFAX WA 99111 WHITMAN (509) 397-3435 Critical Access Hospitals Government - Hospital District or Authority TRUE 46.8689190 -117.3750120 0   75 53 53075 39420 Pullman-Moscow, WA-ID Central Whitman County https://data.medicare.gov/resource/xubh-q36u/row-rc2f_yynj.hvxs 501327 652125 2019-05-30 2018-12-31 25           25               25
2328 2328 PROVIDENCE ST JOSEPH HOSPITAL 500 EAST WEBSTER CHEWELAH WA 99109 STEVENS (509) 935-8211 Critical Access Hospitals Voluntary non-profit - Church TRUE 48.2782130 -117.7108460 0   65 53 53065 44060 Spokane-Spokane Valley-Coeur d'Alene, WA-ID Outlying Stevens County https://data.medicare.gov/resource/xubh-q36u/row-qxaa-u42f_ceuj 501309 648507 2019-05-23 2018-12-31 23           23       40       63
2634 2634 ASTRIA TOPPENISH HOSPITAL 502 W FOURTH AVE TOPPENISH WA 98948 YAKIMA (509) 865-1520 Acute Care Hospitals Voluntary non-profit - Private TRUE 46.3713500 -120.3166820 0   77 53 53077 49420   Central Yakima County https://data.medicare.gov/resource/xubh-q36u/row-pw49~vzsk_k73d 500037 650424 2019-06-04 2018-12-31 18 7         25               25
2635 2635 ASTRIA SUNNYSIDE HOSPITAL 1016 TACOMA AVENUE SUNNYSIDE WA 98944 YAKIMA (509) 837-1500 Critical Access Hospitals Voluntary non-profit - Private TRUE 46.3222180 -120.0069660 0   77 53 53077 49420   Central Yakima County https://data.medicare.gov/resource/xubh-q36u/row-meen.vpbw_8fip 501330 652470 2019-07-22 2018-12-31 18 7         25               25
1575 1575 KITTITAS VALLEY COMMUNITY HOSPITAL 603 SOUTH CHESTNUT ELLENSBURG WA 98926 KITTITAS (509) 962-9841 Critical Access Hospitals Government - Hospital District or Authority TRUE 46.9876880 -120.5367610 0   37 53 53037 21260   Central Kittitas County https://data.medicare.gov/resource/xubh-q36u/row-c8za_geg7~y7ap 501333 651088 2019-06-03 2018-12-31 19 6         25           1   26
2632 2632 ASTRIA REGIONAL MEDICAL CENTER 110 SOUTH NINTH AVE YAKIMA WA 98902 YAKIMA (509) 575-5102 Acute Care Hospitals Proprietary TRUE 46.5979850 -120.5210960 0   77 53 53077 49420   Central Yakima County https://data.medicare.gov/resource/xubh-q36u/row-zbwg.834x-7vgp 500012 651302 2019-06-14 2018-12-31 113           113   15           128
2633 2633 YAKIMA VALLEY MEMORIAL HOSPITAL 2811 TIETON DRIVE YAKIMA WA 98902 YAKIMA (509) 575-8000 Acute Care Hospitals Voluntary non-profit - Private TRUE 46.5927270 -120.5503960 0   77 53 53077 49420   Central Yakima County https://data.medicare.gov/resource/xubh-q36u/row-ctqg~gce3-w285 500036 651084 2019-06-03 2018-12-31 170 38         208 18         20   246
13 13 NORTH VALLEY HOSPITAL 203 SOUTH WESTERN TONASKET WA 98855 OKANOGAN (509) 486-2151 Critical Access Hospitals Government - Local TRUE 48.7068190 -119.4395970 0   47 53 53047         https://data.medicare.gov/resource/xubh-q36u/row-dpfb.gqi2_r2fh 501321 648787 2019-05-29 2018-12-31 21           21               21
1048 1048 QUINCY VALLEY HOSPITAL 908 10TH AVENUE SOUTHWEST QUINCY WA 98848 GRANT (509) 787-3531 Critical Access Hospitals Government - Hospital District or Authority TRUE 47.2309540 -119.8691810 0   25 53 53025 34180 Moses Lake-Othello, WA Central Grant County https://data.medicare.gov/resource/xubh-q36u/row-5bt9-pmke.j4gh 501320 651769 2019-07-05 2018-12-31 25           25               25
1823 1823 MID VALLEY HOSPITAL 810 JASMINE STREET OMAK WA 98841 OKANOGAN (509) 826-1760 Critical Access Hospitals Government - Hospital District or Authority TRUE 48.3965270 -119.5453280 0   47 53 53047         https://data.medicare.gov/resource/xubh-q36u/row-yppn-txq5_kqvp 501328 648789 2019-05-29 2018-12-31 25           25               25
1047 1047 SAMARITAN HOSPITAL 801 EAST WHEELER ROAD MOSES LAKE WA 98837 GRANT (509) 765-5606 Acute Care Hospitals Government - Hospital District or Authority TRUE 47.1311150 -119.2647350 0   25 53 53025 34180 Moses Lake-Othello, WA Central Grant County https://data.medicare.gov/resource/xubh-q36u/row-6jdp_7427-cpfp 500033 659384 2019-06-03 2018-12-31 36 12         48               48
399 399 CASCADE MEDICAL CENTER 817 COMMERCIAL STREET LEAVENWORTH WA 98826 CHELAN (509) 548-5815 Critical Access Hospitals Government - Hospital District or Authority TRUE 47.5944570 -120.6615030 0   7 53 53007 48300   Central Chelan County https://data.medicare.gov/resource/xubh-q36u/row-y32v.qfkm-6i3p 501313 659387 2019-05-29 2018-12-31 9           9               9
1045 1045 COLUMBIA BASIN HOSPITAL 200 NAT WASHINGTON WAY EPHRATA WA 98823 GRANT (509) 754-4631 Critical Access Hospitals Government - Hospital District or Authority TRUE 47.3157420 -119.5481250 0   25 53 53025 34180 Moses Lake-Othello, WA Central Grant County https://data.medicare.gov/resource/xubh-q36u/row-xhgk~wjue-em7x 501317 652555 2019-06-14 2018-12-31 25           25         12 32   69
397 397 LAKE CHELAN COMMUNITY HOSPITAL 503 EAST HIGHLAND CHELAN WA 98816 CHELAN (509) 682-3300 Critical Access Hospitals Government - Hospital District or Authority TRUE 47.8451390 -120.0105110 0   7 53 53007 48300   Central Chelan County https://data.medicare.gov/resource/xubh-q36u/row-a77p~uq78~jh3e 501334 651089 2019-06-03 2018-12-31 25           25               25
1822 1822 THREE RIVERS HOSPITAL 507 HOSPITAL WAY BREWSTER WA 98812 OKANOGAN (509) 689-2517 Critical Access Hospitals Government - Hospital District or Authority TRUE 48.1068240 -119.7826860 0   47 53 53047         https://data.medicare.gov/resource/xubh-q36u/row-5na6-v5bw~u665 501324 648509 2019-05-23 2018-12-31 25           25               25
398 398 CENTRAL WASHINGTON HOSPITAL 1201 SOUTH MILLER STREET WENATCHEE WA 98807 CHELAN (509) 662-1511 Acute Care Hospitals Voluntary non-profit - Private TRUE 47.4079630 -120.3245930 0   7 53 53007 48300   Central Chelan County https://data.medicare.gov/resource/xubh-q36u/row-kbgh~y2am_e66j 500016 645956 2019-03-29 2018-12-31 150 20       6 176       22       198
396 396 CONFLUENCE HEALTH- WENATCHEE VALLEY HOSP & CLINICS 820 NORTH CHELAN AVENUE WENATCHEE WA 98801 CHELAN (509) 663-8711 Acute Care Hospitals Voluntary non-profit - Private FALSE 47.4335660 -120.3219830 0   7 53 53007 48300   Central Chelan County https://data.medicare.gov/resource/xubh-q36u/row-aiqi_mn7n_vecf 500148 650791 2019-05-31 2018-12-31 11           11   9           20
541 541 LEGACY SALMON CREEK MEDICAL CENTER 2211 NE 139TH STREET VANCOUVER WA 98686 CLARK (360) 487-1000 Acute Care Hospitals Voluntary non-profit - Private TRUE 45.7218230 -122.6498990 0   11 53 53011 38900 Portland-Vancouver-Salem, OR-WA Central Clark County https://data.medicare.gov/resource/xubh-q36u/row-b4a4.2925~zmi9 500150 653361 2019-08-30 2019-03-31 128 16         166               166
1623 1623 SKYLINE HOSPITAL 211 SKYLINE DRIVE WHITE SALMON WA 98672 KLICKITAT (509) 491-1101 Critical Access Hospitals Government - Hospital District or Authority TRUE 45.7224740 -121.4699210 0   39 53 53039         https://data.medicare.gov/resource/xubh-q36u/row-ff7m.q2hb.cpdx 501315 652445 2019-06-27 2018-12-31 14           14               14
542 542 PEACEHEALTH SOUTHWEST MEDICAL CENTER 400 NE MOTHER JOSEPH PLACE VANCOUVER WA 98668 CLARK (360) 256-2000 Acute Care Hospitals Voluntary non-profit - Private TRUE 45.6234860 -122.5806360 0   11 53 53011 38900 Portland-Vancouver-Salem, OR-WA Central Clark County https://data.medicare.gov/resource/xubh-q36u/row-dpuj-5ndk.kv2i 500050 662623 2019-12-02 2019-06-30 356 80         436   14           450
718 718 PEACEHEALTH ST JOHN MEDICAL CENTER 1615 DELAWARE STREET LONGVIEW WA 98632 COWLITZ (360) 414-2000 Acute Care Hospitals Voluntary non-profit - Church TRUE 46.1309920 -122.9411920 0   15 53 53015 31020 Portland-Vancouver-Salem, OR-WA Central Cowlitz County https://data.medicare.gov/resource/xubh-q36u/row-n4kt-b68h~5bhw 500041 662288 2019-11-27 2019-06-30 148 18         166               166
1881 1881 OCEAN BEACH HOSPITAL 174 FIRST AVENUE NORTH ILWACO WA 98624 PACIFIC (360) 642-3181 Critical Access Hospitals Government - State TRUE 46.3116960 -124.0433520 0   49 53 53049         https://data.medicare.gov/resource/xubh-q36u/row-6yj2-723x_f5cn 501314 649845 2019-06-03 2018-12-31 25           25               25
1622 1622 KLICKITAT VALLEY HOSPITAL 310 SOUTH ROOSEVELT GOLDENDALE WA 98620 KLICKITAT (509) 773-4022 Critical Access Hospitals Government - Hospital District or Authority TRUE 45.8202390 -120.8122990 0   39 53 53039         https://data.medicare.gov/resource/xubh-q36u/row-hemh_kxtf-bs6t 501316 649846 2019-06-03 2018-12-31 14           14               14
1882 1882 WILLAPA HARBOR HOSPITAL 800 ALDER STREET SOUTH BEND WA 98586 PACIFIC (360) 875-5526 Critical Access Hospitals Government - Hospital District or Authority TRUE 46.6621640 -123.8123170 0   49 53 53049         https://data.medicare.gov/resource/xubh-q36u/row-yp34-4iya_m78d 501303 647986 2019-05-14 2018-12-31 10           10               10
1767 1767 MASON GENERAL HOSPITAL & FAMILY OF CLINICS 901 MT VIEW DRIVE SHELTON WA 98584 MASON (360) 426-1611 Critical Access Hospitals Government - Hospital District or Authority TRUE 47.2267420 -123.1152790 0   45 53 53045 43220 Seattle-Tacoma, WA Central Mason County https://data.medicare.gov/resource/xubh-q36u/row-hitj-vpec_8dkv 501336 649687 2019-05-31 2018-12-31 19 6         25               25
1114 1114 SUMMIT PACIFIC MEDICAL CENTER-SWING BED UNIT 600 EAST MAIN STREET ELMA WA 98541 GRAYS HARBOR (360) 346-2222 Critical Access Hospitals Government - Hospital District or Authority TRUE 47.0066230 -123.3910220 0   27 53 53027 10140   Central Grays Harbor County https://data.medicare.gov/resource/xubh-q36u/row-9u5u_f83c.s8u4 501304 651087 2019-06-05 2018-12-31 10           10               10
1676 1676 PROVIDENCE CENTRALIA HOSPITAL 914 S SCHEUBER ROAD CENTRALIA WA 98531 LEWIS (360) 736-2803 Acute Care Hospitals Voluntary non-profit - Other TRUE 46.7123500 -122.9869890 0   41 53 53041 16500 Seattle-Tacoma, WA Central Lewis County https://data.medicare.gov/resource/xubh-q36u/row-rpu9~qgn5_cp2i 500019 652169 2019-05-23 2018-12-31 110 6         116               116
1115 1115 GRAYS HARBOR COMMUNITY HOSPITAL 915 ANDERSON DRIVE ABERDEEN WA 98520 GRAYS HARBOR (360) 532-8330 Acute Care Hospitals Voluntary non-profit - Private TRUE 46.9796000 -123.8463870 0   27 53 53027 10140   Central Grays Harbor County https://data.medicare.gov/resource/xubh-q36u/row-qmdm-j995~rvv5 500031 659383 2019-06-03 2018-12-31 41 8         49               49
2379 2379 PROVIDENCE ST PETER HOSPITAL 413 LILLY ROAD NE OLYMPIA WA 98506 THURSTON (360) 491-9480 Acute Care Hospitals Voluntary non-profit - Private TRUE 47.0527910 -122.8443690 0   67 53 53067 36500 Seattle-Tacoma, WA Central Thurston County https://data.medicare.gov/resource/xubh-q36u/row-yspj-qfjt_zn5p 500024 648785 2019-05-29 2018-12-31 262 42         304 18             322
2380 2380 CAPITAL MEDICAL CENTER 3900 CAPITAL MALL DR SW OLYMPIA WA 98502 THURSTON (360) 754-5858 Acute Care Hospitals Voluntary non-profit - Private TRUE 47.0416660 -122.9514460 0   67 53 53067 36500 Seattle-Tacoma, WA Central Thurston County https://data.medicare.gov/resource/xubh-q36u/row-gmh8.c3a3.g94s 500139 654948 2019-10-01 2019-04-30 77 30         107               107
1985 1985 ST CLARE HOSPITAL 11315 BRIDGEPORT WAY S W LAKEWOOD WA 98499 PIERCE (253) 588-1711 Acute Care Hospitals Voluntary non-profit - Church TRUE 47.1542130 -122.5044950 0   53 53 53053 42660 Seattle-Tacoma, WA Central Pierce County https://data.medicare.gov/resource/xubh-q36u/row-dwu9_j2ug-7e7a 500021 662622 2019-11-27 2019-06-30 75 31         106               106
1980 1980 Madigan AMC (FT Lewis) 9040 Jackson Avenue Tacoma WA 98431 PIERCE (253) 968-1110 Acute Care - Department of Defense Department of Defense TRUE 47.1079300 -122.5485280 0   53 53 53053 42660 Seattle-Tacoma, WA Central Pierce County https://data.medicare.gov/resource/xubh-q36u/row-auzt.nx8p-7ivx                                      
1979 1979 MARY BRIDGE CHILDREN'S HOSPITAL 317 MARTIN LUTHER KING JR W BOX 5299 TACOMA WA 98415 PIERCE (253) 403-1400 Childrens Voluntary non-profit - Other TRUE 47.2587434 -122.4527167 1 ROOFTOP 53 53 53053 42660 Seattle-Tacoma, WA Central Pierce County https://data.medicare.gov/resource/xubh-q36u/row-8c85~gidq~gevc 503301 645385 2018-06-05 2017-12-31                              
1981 1981 ST JOSEPH MEDICAL CENTER 1717 SOUTH J STREET TACOMA WA 98405 PIERCE (253) 627-4101 Acute Care Hospitals Voluntary non-profit - Church TRUE 47.2454690 -122.4487570 0   53 53 53053 42660 Seattle-Tacoma, WA Central Pierce County https://data.medicare.gov/resource/xubh-q36u/row-pud3~63vu~69st 500108 662624 2019-11-27 2019-06-30 292 82         374               374
1983 1983 TACOMA GENERAL ALLENMORE HOSPITAL 315 S MLK JR WAY TACOMA WA 98405 PIERCE (253) 403-1000 Acute Care Hospitals Voluntary non-profit - Private TRUE 47.2593601 -122.4529681 1 ROOFTOP 53 53 53053 42660 Seattle-Tacoma, WA Central Pierce County https://data.medicare.gov/resource/xubh-q36u/row-tg4u.2tin~uuu2 500129 650920 2019-05-30 2018-12-31 235 48       70 353     27         380
1984 1984 MULTICARE GOOD SAMARITAN HOSPITAL 401 15TH AVENUE SE PUYALLUP WA 98372 PIERCE (253) 697-2102 Acute Care Hospitals Voluntary non-profit - Private TRUE 47.1774110 -122.2894680 0   53 53 53053 42660 Seattle-Tacoma, WA Central Pierce County https://data.medicare.gov/resource/xubh-q36u/row-d55j~6ytb~rwq5 500079 649844 2019-05-31 2018-12-31 250 20         283   38           321
1306 1306 JEFFERSON HEALTHCARE 834 SHERIDAN STREET PORT TOWNSEND WA 98368 JEFFERSON (360) 385-2200 Critical Access Hospitals Government - Hospital District or Authority TRUE 48.1055390 -122.7902850 0   31 53 53031         https://data.medicare.gov/resource/xubh-q36u/row-j4ne_2zqs-7gre 501323 648788 2019-05-29 2018-12-31 19 6         25               25
468 468 OLYMPIC MEDICAL CENTER 939 CAROLINE ST PORT ANGELES WA 98362 CLALLAM (360) 417-7000 Acute Care Hospitals Government - Local TRUE 48.1146350 -123.4140840 0   9 53 53009 38820   Central Clallam County https://data.medicare.gov/resource/xubh-q36u/row-pwiq.sab8.genf 500072 652469 2019-07-23 2018-12-31 59 19         78               78
1677 1677 ARBOR HEALTH MORTON HOSPITAL 521 ADAMS STREET MORTON WA 98356 LEWIS (360) 496-5112 Critical Access Hospitals Government - Hospital District or Authority TRUE 46.5559530 -122.2798780 0   41 53 53041 16500 Seattle-Tacoma, WA Central Lewis County https://data.medicare.gov/resource/xubh-q36u/row-rfdw-ekhk~ca8x 501319 648508 2019-05-23 2018-12-31 25           25               25
1982 1982 ST ANTHONY HOSPITAL 11567 CANTERWOOD BOULEVARD NW GIG HARBOR WA 98332 PIERCE (253) 530-2050 Acute Care Hospitals Voluntary non-profit - Church TRUE 47.3650330 -122.6150630 0   53 53 53053 42660 Seattle-Tacoma, WA Central Pierce County https://data.medicare.gov/resource/xubh-q36u/row-tej2.8itp~9z5w 500151 662293 2019-11-27 2019-06-30 96 16         112               112
467 467 FORKS COMMUNITY HOSPITAL 530 BOGACHIEL WAY FORKS WA 98331 CLALLAM (360) 374-6271 Critical Access Hospitals Government - Hospital District or Authority TRUE 47.9463560 -124.3934710 0   9 53 53009 38820   Central Clallam County https://data.medicare.gov/resource/xubh-q36u/row-2fc7-ht3p_rrzf 501325 655431 2019-09-25 2018-12-31 25           25         12     37
1444 1444 NH Bremerton 1 Boone Road Bremerton Bremerton WA 98312 KITSAP (360) 475-4232 Acute Care - Department of Defense Department of Defense FALSE 47.5935710 -122.6929400 0   35 53 53035 14740 Seattle-Tacoma, WA Central Kitsap County https://data.medicare.gov/resource/xubh-q36u/row-u4p2.49ji-8aqj                                      
1445 1445 HARRISON MEMORIAL HOSPITAL 2520 CHERRY AVENUE BREMERTON WA 98310 KITSAP (360) 377-3911 Acute Care Hospitals Voluntary non-profit - Private TRUE 47.5834290 -122.6260100 0   35 53 53035 14740 Seattle-Tacoma, WA Central Kitsap County https://data.medicare.gov/resource/xubh-q36u/row-8y88_q8xr.ka8g 500039 662287 2019-11-27 2019-06-30 278 20         298               298
2093 2093 PEACEHEALTH UNITED GENERAL MEDICAL CENTER 2000 HOSPITAL DRIVE SEDRO WOOLLEY WA 98284 SKAGIT (360) 856-6021 Critical Access Hospitals Government - Hospital District or Authority TRUE 48.4955160 -122.2752870 0   57 53 53057 34580 Seattle-Tacoma, WA Central Skagit County https://data.medicare.gov/resource/xubh-q36u/row-bxir_c4z7.hk8y 501329 640561 2018-11-30 2018-06-30 25           25               25
1191 1191 NH Oak Harbor 3475 North Saratoga Street Oak Harbor WA 98277 ISLAND (360) 257-9500 Acute Care - Department of Defense Department of Defense FALSE 48.3368750 -122.6801420 0   29 53 53029 36020 Seattle-Tacoma, WA Central Island County https://data.medicare.gov/resource/xubh-q36u/row-9p9c~5ra9_8krv                                      
2092 2092 SKAGIT VALLEY HOSPITAL 1415 KINCAID STREET MOUNT VERNON WA 98274 SKAGIT (360) 424-4111 Acute Care Hospitals Government - Hospital District or Authority TRUE 48.4174220 -122.3243350 0   57 53 53057 34580 Seattle-Tacoma, WA Central Skagit County https://data.medicare.gov/resource/xubh-q36u/row-35tt.efdg~xsq2 500003 650919 2019-05-30 2018-12-31 125   12       137               137
2232 2232 EVERGREENHEALTH MONROE 14701 179TH SE MONROE WA 98272 SNOHOMISH (360) 794-7497 Acute Care Hospitals Government - Hospital District or Authority TRUE 47.8637270 -121.9906240 0   61 53 53061 42660 Seattle-Tacoma, WA Central Snohomish County https://data.medicare.gov/resource/xubh-q36u/row-usdb-25x2~srt8 500084 651085 2019-06-03 2018-12-31 23 4         27               27
2041 2041 PEACEHEALTH PEACE ISLAND MEDICAL CENTER 1117 SPRING STREET FRIDAY HARBOR WA 98250 SAN JUAN (360) 378-2141 Critical Access Hospitals Voluntary non-profit - Private TRUE 48.5298570 -123.0281710 0   55 53 53055         https://data.medicare.gov/resource/xubh-q36u/row-tq94~fpij_9q58 501340 640562 2018-11-30 2018-06-30 10           10               10
1192 1192 WHIDBEYHEALTH MEDICAL CENTER 101 NORTH MAIN STREET COUPEVILLE WA 98239 ISLAND (360) 678-5151 Critical Access Hospitals Government - Hospital District or Authority TRUE 48.2142400 -122.6861220 0   29 53 53029 36020 Seattle-Tacoma, WA Central Island County https://data.medicare.gov/resource/xubh-q36u/row-uede_fy5z~txux 501339 649688 2019-05-31 2018-12-31 19 6         25               25
2552 2552 ST JOSEPH HOSPITAL 2901 SQUALICUM PARKWAY BELLINGHAM WA 98225 WHATCOM (360) 734-5400 Acute Care Hospitals Voluntary non-profit - Other TRUE 48.7722780 -122.4748780 0   73 53 53073 13380   Central Whatcom County https://data.medicare.gov/resource/xubh-q36u/row-xf7q~fgxx.c5xi 500030 662286 2018-11-30 2018-06-30 183 24         207 20 14           241
2234 2234 CASCADE VALLEY HOSPITAL 330 S STILLAGUAMISH AVE ARLINGTON WA 98223 SNOHOMISH (360) 435-2133 Acute Care Hospitals Government - Hospital District or Authority TRUE 48.1898020 -122.1175890 0   61 53 53061 42660 Seattle-Tacoma, WA Central Snohomish County https://data.medicare.gov/resource/xubh-q36u/row-eavm.r4sq~6x6e 500060 652031 2019-07-18 2018-12-31 42 6         48               48
2094 2094 ISLAND HOSPITAL 1211 24TH STREET ANACORTES WA 98221 SKAGIT (360) 299-1300 Acute Care Hospitals Government - Hospital District or Authority TRUE 48.5028830 -122.6158250 0   57 53 53057 34580 Seattle-Tacoma, WA Central Skagit County https://data.medicare.gov/resource/xubh-q36u/row-7mqw.zfgi.xhpw 500007 651429 2019-06-03 2018-12-31 37 6         43               43
2231 2231 PROVIDENCE REGIONAL MEDICAL CENTER EVERETT 1321 COLBY AVENUE EVERETT WA 98201 SNOHOMISH (425) 261-2000 Acute Care Hospitals Voluntary non-profit - Church TRUE 48.0000860 -122.2079790 0   61 53 53061 42660 Seattle-Tacoma, WA Central Snohomish County https://data.medicare.gov/resource/xubh-q36u/row-w5ai~4jnq.yfw4 500014 659082 2019-11-19 2018-12-31 417 49       29 495   19           514
1357 1357 UNIVERSITY OF WASHINGTON MEDICAL CTR 1959 NE PACIFIC ST BOX 356151 SEATTLE WA 98195 KING (206) 598-3300 Acute Care Hospitals Government - State TRUE 47.6505060 -122.3074820 0   33 53 53033 42660 Seattle-Tacoma, WA Central King County https://data.medicare.gov/resource/xubh-q36u/row-gezf_iitw.mxe8 500008 661427 2018-11-29 2018-06-30 209 81       50 408 16 18           442

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