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)

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
1370 1370 HIGHLINE MEDICAL CENTER 16251 SYLVESTER ROAD SW BURIEN WA 98166 KING (206) 244-9970 Acute Care Hospitals Voluntary non-profit - Private TRUE 47.4567780 -122.3414550 0   33 53 53033 42660 Seattle-Tacoma, WA Central King County https://data.medicare.gov/resource/xubh-q36u/row-rruu~ixyd~6kv9 500011 662285 2019-11-27 2019-06-30 119 10         129               129
1372 1372 UW MEDICINE/NORTHWEST HOSPITAL 1550 NORTH 115TH STREET SEATTLE WA 98133 KING (206) 368-1700 Acute Care Hospitals Voluntary non-profit - Other TRUE 47.7122630 -122.3359360 0   33 53 53033 42660 Seattle-Tacoma, WA Central King County https://data.medicare.gov/resource/xubh-q36u/row-drv9~ptgn-5qjd 500001 660337 2019-11-25 2019-06-30 147 32         179 27             206
1359 1359 SWEDISH MEDICAL CENTER 747 BROADWAY SEATTLE WA 98122 KING (206) 386-6000 Acute Care Hospitals Voluntary non-profit - Private TRUE 47.6092400 -122.3207670 0   33 53 53033 42660 Seattle-Tacoma, WA Central King County https://data.medicare.gov/resource/xubh-q36u/row-rnd2~zqb3.hq8w 500027 653165 2019-08-13 2018-12-31 512 54       80 646 22             668
1364 1364 SWEDISH MEDICAL CENTER / CHERRY HILL 500 17TH AVENUE SEATTLE WA 98122 KING (206) 320-2000 Acute Care Hospitals Voluntary non-profit - Church TRUE 47.6062210 -122.3102490 0   33 53 53033 42660 Seattle-Tacoma, WA Central King County https://data.medicare.gov/resource/xubh-q36u/row-wtid~um6d.vshi 500025 649153 2019-05-29 2018-12-31 125 56         181   30           211
1365 1365 KAISER PERMANENTE CENTRAL HOSPITAL 201 - 16TH AVENUE EAST SEATTLE WA 98112 KING (206) 326-3000 Acute Care Hospitals Voluntary non-profit - Other TRUE 47.6197310 -122.3114130 0   33 53 53033 42660 Seattle-Tacoma, WA Central King County https://data.medicare.gov/resource/xubh-q36u/row-phdi-fixy.kk47 500052 649979 2019-06-06 2018-12-31 24           24               24
1361 1361 SEATTLE CHILDREN'S HOSPITAL 4800 SAND POINT WAY NE, PO BOX C-5371 SEATTLE WA 98105 KING (206) 987-2000 Childrens Voluntary non-profit - Private TRUE 47.6645040 -122.2831690 0   33 53 53033 42660 Seattle-Tacoma, WA Central King County https://data.medicare.gov/resource/xubh-q36u/row-7um6_3ase-art7 503300 646369 2019-04-05 2018-09-30 270 91         361               361
1366 1366 HARBORVIEW MEDICAL CENTER 325 9TH AVENUE SEATTLE WA 98104 KING (206) 731-3000 Acute Care Hospitals Government - Local TRUE 47.6040840 -122.3233720 0   33 53 53033 42660 Seattle-Tacoma, WA Central King County https://data.medicare.gov/resource/xubh-q36u/row-fu42.79v4.ss25 500064 659621 2019-11-25 2019-06-30 232 89         321 68 24           413
1367 1367 VIRGINIA MASON MEDICAL CENTER 925 SENECA ST SEATTLE WA 98101 KING (206) 223-6600 Acute Care Hospitals Voluntary non-profit - Private TRUE 47.6101790 -122.3278090 0   33 53 53033 42660 Seattle-Tacoma, WA Central King County https://data.medicare.gov/resource/xubh-q36u/row-dt6c_fkxq-9dkg 500005 653934 2019-08-22 2018-12-31 183 28         211       35       246
1373 1373 SNOQUALMIE VALLEY HOSPITAL 9801 FRONTIER AVE SE SNOQUALMIE WA 98065 KING (425) 831-2300 Critical Access Hospitals Government - Hospital District or Authority TRUE 47.5123090 -121.8859170 0   33 53 53033 42660 Seattle-Tacoma, WA Central King County https://data.medicare.gov/resource/xubh-q36u/row-6irs_wptw_7uri 501338 648790 2019-05-29 2018-12-31 25           25               25
1362 1362 VALLEY MEDICAL CENTER 400 S 43RD ST RENTON WA 98055 KING (425) 228-3450 Acute Care Hospitals Government - Hospital District or Authority TRUE 47.4410940 -122.2142510 0   33 53 53033 42660 Seattle-Tacoma, WA Central King County https://data.medicare.gov/resource/xubh-q36u/row-2q75.mwjb_9fau 500088 658621 2019-11-12 2019-06-30 311           311               311
1368 1368 MULTICARE COVINGTON MEDICAL CENTER 17700 SE 272ND ST COVINGTON WA 98042 KING (253) 372-7400 Acute Care Hospitals Voluntary non-profit - Private TRUE 47.3580630 -122.1042270 0   33 53 53033 42660 Seattle-Tacoma, WA Central King County https://data.medicare.gov/resource/xubh-q36u/row-s9xi~4syp.7a2q 500154 659385 2019-05-30 2018-12-31 58           58               58
1363 1363 EVERGREENHEALTH MEDICAL CENTER 12040 NE 128TH STREET KIRKLAND WA 98034 KING (425) 899-1000 Acute Care Hospitals Government - Hospital District or Authority TRUE 47.7148720 -122.1785060 0   33 53 53033 42660 Seattle-Tacoma, WA Central King County https://data.medicare.gov/resource/xubh-q36u/row-czqf-dh5d_37vj 500124 651252 2019-06-03 2018-12-31 241 20         304   14       15   333
1360 1360 SWEDISH ISSAQUAH 751 NE BLAKELY DR ISSAQUAH WA 98029 KING (425) 313-4000 Acute Care Hospitals Voluntary non-profit - Private TRUE 47.5365530 -122.0220500 0   33 53 53033 42660 Seattle-Tacoma, WA Central King County https://data.medicare.gov/resource/xubh-q36u/row-47ix~va3w.djfm 500152 652170 2019-05-29 2018-12-31 93 18       15 126               126
2233 2233 SWEDISH EDMONDS HOSPITAL 21601 76TH AVENUE WEST EDMONDS WA 98026 SNOHOMISH (425) 640-4000 Acute Care Hospitals Voluntary non-profit - Private TRUE 47.8028840 -122.3356900 0   61 53 53061 42660 Seattle-Tacoma, WA Central Snohomish County https://data.medicare.gov/resource/xubh-q36u/row-nyqq~53qx~dj5y 500026 649843 2019-05-28 2018-12-31 156 13       9 178               178
1371 1371 ST ELIZABETH HOSPITAL 1450 BATTERSBY AVENUE ENUMCLAW WA 98022 KING (360) 825-2505 Critical Access Hospitals Voluntary non-profit - Church TRUE 47.2084170 -121.9881570 0   33 53 53033 42660 Seattle-Tacoma, WA Central King County https://data.medicare.gov/resource/xubh-q36u/row-8kts.qr6u-cywi 501335 660477 2019-11-27 2019-06-30 25           25               25
1358 1358 OVERLAKE HOSPITAL MEDICAL CENTER 1035-116TH AVE NE BELLEVUE WA 98004 KING (425) 688-5000 Acute Care Hospitals Voluntary non-profit - Other TRUE 47.6208736 -122.1868731 1 GEOMETRIC_CENTER 33 53 53033 42660 Seattle-Tacoma, WA Central King County https://data.medicare.gov/resource/xubh-q36u/row-rzza-8dw4_494p 500051 658006 2019-01-09 2018-06-30 237 32         286 14             300
1369 1369 ST FRANCIS COMMUNITY HOSPITAL 34515 9TH AVENUE SOUTH FEDERAL WAY WA 98003 KING (253) 944-8100 Acute Care Hospitals Voluntary non-profit - Church TRUE 47.2921060 -122.3229510 0   33 53 53033 42660 Seattle-Tacoma, WA Central King County https://data.medicare.gov/resource/xubh-q36u/row-26c7~6xv9.c5tp 500141 662625 2019-11-27 2019-06-30 110 14         124               124
1356 1356 MULTICARE AUBURN MEDICAL CENTER 202 NORTH DIVISION STREET PLAZA ONE AUBURN WA 98001 KING (253) 833-7711 Acute Care Hospitals Voluntary non-profit - Private TRUE 47.3093430 -122.2298330 0   33 53 53033 42660 Seattle-Tacoma, WA Central King County https://data.medicare.gov/resource/xubh-q36u/row-fx4d.wmeg-jfy6 500015 649518 2019-05-30 2018-12-31 51 16         73 58             131
1753 1753 SAINT ALPHONSUS MEDICAL CENTER - ONTARIO, INC 351 SW 9TH STREET ONTARIO OR 97914 MALHEUR (541) 881-7000 Acute Care Hospitals Voluntary non-profit - Church TRUE 44.0254480 -116.9751330 0   45 41 41045 36620 Boise City-Mountain Home-Ontario, ID-OR Central Malheur County https://data.medicare.gov/resource/xubh-q36u/row-pp3w.967e-e52h 380052 661085 2019-12-02 2019-06-30 36 8         44               44
2224 2224 GRANDE RONDE HOSPITAL 900 SUNSET DRIVE LA GRANDE OR 97850 UNION (541) 963-8421 Critical Access Hospitals Voluntary non-profit - Private TRUE 45.3194640 -118.1048280 0   61 41 41061 29260   Central Union County https://data.medicare.gov/resource/xubh-q36u/row-k86m-d2cq~y5ce 381321 655414 2019-09-30 2019-04-30 21 4         25               25
978 978 BLUE MOUNTAIN HOSPITAL 170 FORD ROAD JOHN DAY OR 97845 GRANT (541) 575-1311 Critical Access Hospitals Government - Hospital District or Authority TRUE 44.4176510 -118.9592200 0   23 41 41023         https://data.medicare.gov/resource/xubh-q36u/row-svyy.cxkf.r4qf 381305 662576 2019-11-27 2019-06-30 14           14               14
2160 2160 GOOD SHEPHERD MEDICAL CENTER 610 NW 11TH STREET HERMISTON OR 97838 UMATILLA (541) 667-3400 Critical Access Hospitals Voluntary non-profit - Private TRUE 45.8461350 -119.3109500 0   59 41 41059 25840   Central Umatilla County https://data.medicare.gov/resource/xubh-q36u/row-2f95~scvq.xeyd 381325 662577 2019-11-27 2019-06-30 22 3         25               25
1868 1868 PIONEER MEMORIAL HOSPITAL 564 E PIONEER DRIVE HEPPNER OR 97836 MORROW (541) 676-9133 Critical Access Hospitals Government - Hospital District or Authority TRUE 45.3562680 -119.5476300 0   49 41 41049 25840   Outlying Morrow County https://data.medicare.gov/resource/xubh-q36u/row-fdy5_3qnb-6xrr 381310 659056 2019-11-19 2019-06-30 21           21               21
2269 2269 WALLOWA MEMORIAL HOSPITAL 601 MEDICAL PARKWAY ENTERPRISE OR 97828 WALLOWA (541) 426-3111 Critical Access Hospitals Government - Hospital District or Authority TRUE 45.4317550 -117.2813850 0   63 41 41063         https://data.medicare.gov/resource/xubh-q36u/row-etny.mgye.acyv 381306 654631 2019-09-23 2019-06-30 23           23               23
119 119 SAINT ALPHONSUS MEDICAL CENTER - BAKER CITY, INC 3325 POCAHONTAS ROAD BAKER CITY OR 97814 BAKER (541) 524-7744 Critical Access Hospitals Voluntary non-profit - Church TRUE 44.7961200 -117.8462850 0   1 41 41001         https://data.medicare.gov/resource/xubh-q36u/row-yt65-wbpr_7cai 381315 661086 2019-12-02 2019-06-30 19 2         21               21
2161 2161 ST ANTHONY HOSPITAL 2801 ST ANTHONY WAY PENDLETON OR 97801 UMATILLA (541) 276-5121 Critical Access Hospitals Voluntary non-profit - Church TRUE 45.6482496 -118.8124252 1 ROOFTOP 59 41 41059 25840   Central Umatilla County https://data.medicare.gov/resource/xubh-q36u/row-hwf6-ji7m-72j9 381319 660288 2019-11-27 2019-06-30 20 5         25               25
783 783 ST CHARLES REDMOND 1253 NW CANAL BLVD REDMOND OR 97756 DESCHUTES (541) 548-8131 Acute Care Hospitals Voluntary non-profit - Private TRUE 44.2887030 -121.1685580 0   17 41 41017 13460 Bend-Redmond-Prineville, OR Central Deschutes County https://data.medicare.gov/resource/xubh-q36u/row-hegt-uv48.px87 380040 651049 2019-06-03 2018-12-31 42 6         48               48
643 643 ST CHARLES PRINEVILLE 384 SE COMBS FLAT ROAD PRINEVILLE OR 97754 CROOK (541) 447-6254 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.2980930 -120.8269680 0   13 41 41013 39260 Bend-Redmond-Prineville, OR Central Crook County https://data.medicare.gov/resource/xubh-q36u/row-yy7v_qhni~xpgc 381313 651052 2019-06-03 2018-12-31 16           16               16
1300 1300 ST CHARLES MADRAS 470 NE A STREET MADRAS OR 97741 JEFFERSON (541) 475-3882 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.6373620 -121.1213580 0   31 41 41031         https://data.medicare.gov/resource/xubh-q36u/row-c49r.t2un~9r3e 381324 651053 2019-06-03 2018-12-31 25           25               25
1035 1035 HARNEY DISTRICT HOSPITAL 557 W WASHINGTON STREET BURNS OR 97720 HARNEY (541) 573-7281 Critical Access Hospitals Government - Hospital District or Authority TRUE 43.5887230 -119.0605700 0   25 41 41025         https://data.medicare.gov/resource/xubh-q36u/row-8hhx~g735.b7ph 381307 659055 2019-11-19 2019-06-30 17 2         19               19
782 782 ST CHARLES BEND 2500 NE NEFF ROAD BEND OR 97701 DESCHUTES (541) 382-4321 Acute Care Hospitals Voluntary non-profit - Private TRUE 44.0657570 -121.2666610 0   17 41 41017 13460 Bend-Redmond-Prineville, OR Central Deschutes County https://data.medicare.gov/resource/xubh-q36u/row-c338~bvm4~22pp 380047 651050 2019-06-03 2018-12-31 192 30         222 15 13           250
1560 1560 LAKE DISTRICT HOSPITAL 700 SOUTH J STREET LAKEVIEW OR 97630 LAKE (541) 947-2114 Critical Access Hospitals Government - Hospital District or Authority TRUE 42.1815830 -120.3514370 0   37 41 41037         https://data.medicare.gov/resource/xubh-q36u/row-2rpx~hmxp~n924 381309 640591 2018-12-10 2018-06-30 24           24               24
1426 1426 SKY LAKES MEDICAL CENTER 2865 DAGGETT AVENUE KLAMATH FALLS OR 97601 KLAMATH (541) 274-6150 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.2526550 -121.7873910 0   35 41 41035 28900   Central Klamath County https://data.medicare.gov/resource/xubh-q36u/row-7356-bqzn.gqpk 380050 644852 2019-03-01 2018-09-30 105           105               105
1351 1351 ASANTE THREE RIVERS MEDICAL CENTER 500 SW RAMSEY AVENUE GRANTS PASS OR 97527 JOSEPHINE (541) 472-7000 Acute Care Hospitals Voluntary non-profit - Other TRUE 42.4204370 -123.3414950 0   33 41 41033 24420 Medford-Grants Pass, OR Central Josephine County https://data.medicare.gov/resource/xubh-q36u/row-ybif~ftnq_236g 380002 642897 2019-01-29 2018-09-30 109 12         121               121
1165 1165 ASANTE ASHLAND COMMUNITY HOSPITAL 280 MAPLE STREET ASHLAND OR 97520 JACKSON (541) 201-4017 Acute Care Hospitals Government - Local TRUE 42.2064450 -122.7251290 0   29 41 41029 32780 Medford-Grants Pass, OR Central Jackson County https://data.medicare.gov/resource/xubh-q36u/row-xsnr-xsme.wejp 380005 644057 2019-02-27 2018-09-30 34 4         38               38
1166 1166 PROVIDENCE MEDFORD MEDICAL CENTER 1111 CRATER LAKE AVENUE MEDFORD OR 97504 JACKSON (541) 732-5050 Acute Care Hospitals Voluntary non-profit - Church TRUE 42.3399710 -122.8610000 0   29 41 41029 32780 Medford-Grants Pass, OR Central Jackson County https://data.medicare.gov/resource/xubh-q36u/row-wq37.tzys-wnax 380075 648649 2019-05-24 2018-12-31 111 15         126   12           138
1167 1167 ASANTE ROGUE REGIONAL MEDICAL CENTER 2825 E BARNETT ROAD MEDFORD OR 97504 JACKSON (541) 789-7000 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.3164830 -122.8304430 0   29 41 41029 32780 Medford-Grants Pass, OR Central Jackson County https://data.medicare.gov/resource/xubh-q36u/row-9ft2-cyq3.jcug 380018 642898 2019-01-29 2018-09-30 238 15 16       301 21 15           337
1609 1609 SACRED HEART MEDICAL CENTER - RIVERBEND 3333 RIVERBEND DRIVE SPRINGFIELD OR 97477 LANE (541) 222-7300 Acute Care Hospitals Voluntary non-profit - Private TRUE 44.0813120 -123.0286550 0   39 41 41039 21660   Central Lane County https://data.medicare.gov/resource/xubh-q36u/row-xqg2~c6as-x5em 380102 662575 2019-11-27 2019-06-30 301 46       36 383               383
1610 1610 MCKENZIE-WILLAMETTE MEDICAL CENTER 1460 G STREET SPRINGFIELD OR 97477 LANE (541) 726-4400 Acute Care Hospitals Voluntary non-profit - Private TRUE 44.0524000 -123.0025890 0   39 41 41039 21660   Central Lane County https://data.medicare.gov/resource/xubh-q36u/row-haa6_vujr_hynm 380020 654105 2019-08-27 2018-12-31 88 25         113               113
855 855 MERCY MEDICAL CENTER 2700 NW STEWART PARKWAY ROSEBURG OR 97471 DOUGLAS (541) 673-0611 Acute Care Hospitals Government - Hospital District or Authority TRUE 43.2368240 -123.3716040 0   19 41 41019 40700   Central Douglas County https://data.medicare.gov/resource/xubh-q36u/row-kmh5-zbwa-3mz2 380027 659601 2019-11-22 2019-06-30 108 32         140               140
854 854 LOWER UMPQUA HOSPITAL DISTRICT 600 RANCH ROAD REEDSPORT OR 97467 DOUGLAS (541) 271-2171 Critical Access Hospitals Government - Hospital District or Authority TRUE 43.6953240 -124.1355710 0   19 41 41019 40700   Central Douglas County https://data.medicare.gov/resource/xubh-q36u/row-nysc.rhhn_bb99 381311 659602 2019-11-25 2019-06-30 16           16               16
709 709 CURRY GENERAL HOSPITAL 94220 FOURTH STREET GOLD BEACH OR 97444 CURRY (541) 247-3000 Critical Access Hospitals Government - Hospital District or Authority TRUE 42.4116590 -124.4186580 0   15 41 41015 15060   Central Curry County https://data.medicare.gov/resource/xubh-q36u/row-9rud.6rf5~it7z 381322 659603 2019-11-25 2019-06-30 16           16               16
1608 1608 PEACE HARBOR MEDICAL CENTER 400 9TH STREET FLORENCE OR 97439 LANE (541) 997-8412 Critical Access Hospitals Voluntary non-profit - Church TRUE 43.9745890 -124.1174640 0   39 41 41039 21660   Central Lane County https://data.medicare.gov/resource/xubh-q36u/row-3bhj~d2nf.qxkv 381316 662244 2019-12-02 2019-06-30 21           21               21
1612 1612 PEACEHEALTH COTTAGE GROVE COMMUNITY MEDICAL CENTER 1515 VILLAGE DRIVE COTTAGE GROVE OR 97424 LANE (541) 767-5202 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.8038370 -123.0386760 0   39 41 41039 21660   Central Lane County https://data.medicare.gov/resource/xubh-q36u/row-6buq_rs3k.th8r 381301 640536 2018-11-30 2018-06-30 14           14               14
530 530 COQUILLE VALLEY HOSPITAL DISTRICT 940 EAST 5TH STREET COQUILLE OR 97423 COOS (541) 396-3101 Critical Access Hospitals Government - Hospital District or Authority TRUE 43.1789820 -124.1791430 0   11 41 41011 18300   Central Coos County https://data.medicare.gov/resource/xubh-q36u/row-qh6s~rn9z.ntit 381312 660287 2019-12-02 2019-06-30 17           17               17
529 529 BAY AREA HOSPITAL 1775 THOMPSON ROAD COOS BAY OR 97420 COOS (541) 269-8124 Acute Care Hospitals Government - Hospital District or Authority TRUE 43.3858540 -124.2324630 0   11 41 41011 18300   Central Coos County https://data.medicare.gov/resource/xubh-q36u/row-nb96_ahiz~7tng 380090 662069 2019-12-02 2019-06-30 118 12         130               130
528 528 SOUTHERN COOS HOSPITAL & HEALTH CENTER 900 11TH STREET SE BANDON OR 97411 COOS (541) 347-2426 Critical Access Hospitals Government - Hospital District or Authority TRUE 43.1132440 -124.4024260 0   11 41 41011 18300   Central Coos County https://data.medicare.gov/resource/xubh-q36u/row-gr9r_ty5i_3jqt 381304 660285 2019-11-26 2019-06-30 19           19               19
1611 1611 SACRED HEART UNIVERSITY DISTRICT 1255 HILYARD STREET EUGENE OR 97401 LANE (541) 686-7300 Acute Care Hospitals Voluntary non-profit - Private TRUE 44.0460560 -123.0821050 0   39 41 41039 21660   Central Lane County https://data.medicare.gov/resource/xubh-q36u/row-g7vk_mpaz~eeix 380033 662243 2019-11-27 2019-06-30 40           40 35 18           93
1814 1814 SANTIAM HOSPITAL 1401 N 10TH AVENUE STAYTON OR 97383 MARION (503) 769-2175 Acute Care Hospitals Voluntary non-profit - Private TRUE 44.8052400 -122.7841240 0   47 41 41047 41420 Portland-Vancouver-Salem, OR-WA Central Marion County https://data.medicare.gov/resource/xubh-q36u/row-qi97~k54k_7r7z 380056 650606 2019-05-28 2018-12-31 36 4         40               40
1816 1816 LEGACY SILVERTON MEDICAL CENTER 342 FAIRVIEW STREET SILVERTON OR 97381 MARION (503) 873-1500 Acute Care Hospitals Voluntary non-profit - Private TRUE 45.0045640 -122.7907460 0   47 41 41047 41420 Portland-Vancouver-Salem, OR-WA Central Marion County https://data.medicare.gov/resource/xubh-q36u/row-wm4f.qf22_nr3s 380029 654480 2019-08-30 2019-03-31 25 4         29               29
1662 1662 SAMARITAN NORTH LINCOLN HOSPITAL 3043 NE 28TH STREET LINCOLN CITY OR 97367 LINCOLN (541) 994-3661 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.9851790 -123.9954540 0   41 41 41041 35440   Central Lincoln County https://data.medicare.gov/resource/xubh-q36u/row-bz6m-ywcr_rqcy 381302 650766 2019-05-28 2018-12-31 25           25               25
1661 1661 SAMARITAN PACIFIC COMMUNITY HOSPITAL 930 SW ABBEY STREET NEWPORT OR 97365 LINCOLN (541) 265-2244 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.6298580 -124.0591640 0   41 41 41041 35440   Central Lincoln County https://data.medicare.gov/resource/xubh-q36u/row-2hph_npt2~vzq7 381314 650767 2019-05-28 2018-12-31 25           25               25
1704 1704 SAMARITAN LEBANON COMMUNITY HOSPITAL 525 N SANTIAM HIGHWAY LEBANON OR 97355 LINN (541) 258-2101 Critical Access Hospitals Voluntary non-profit - Church TRUE 44.5505280 -122.9084140 0   43 41 41043 10540 Portland-Vancouver-Salem, OR-WA Central Linn County https://data.medicare.gov/resource/xubh-q36u/row-93tp~y4q9_5znk 381323 650769 2019-05-28 2018-12-31 25           25               25
1971 1971 SALEM HEALTH WEST VALLEY 525 SE WASHINGTON STREET DALLAS OR 97338 POLK (503) 623-8301 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.9194040 -123.3103830 0   53 41 41053 41420 Portland-Vancouver-Salem, OR-WA Central Polk County https://data.medicare.gov/resource/xubh-q36u/row-urpw.pi4k_vkp4 381308 660286 2019-12-02 2019-06-30 15           15               15
223 223 GOOD SAMARITAN REGIONAL MEDICAL CENTER 3600 NW SAMARITAN DRIVE CORVALLIS OR 97330 BENTON (541) 768-5111 Acute Care Hospitals Voluntary non-profit - Private TRUE 44.6046240 -123.2511040 0   3 41 41003 18700 Portland-Vancouver-Salem, OR-WA Central Benton County https://data.medicare.gov/resource/xubh-q36u/row-pcfe.3dmp~9puh 380014 650902 2019-05-28 2018-12-31 157 12         169 24             193
1705 1705 SAMARITAN ALBANY GENERAL HOSPITAL 1046 6TH AVENUE SW ALBANY OR 97321 LINN (541) 812-4000 Acute Care Hospitals Voluntary non-profit - Church TRUE 44.6320670 -123.1167710 0   43 41 41043 10540 Portland-Vancouver-Salem, OR-WA Central Linn County https://data.medicare.gov/resource/xubh-q36u/row-3f45~84ie_23rn 380022 650903 2019-05-28 2018-12-31 56 11         67               67
1815 1815 SALEM HOSPITAL 890 OAK STREET, SE SALEM OR 97301 MARION (503) 561-5200 Acute Care Hospitals Voluntary non-profit - Other TRUE 44.9328870 -123.0331460 0   47 41 41047 41420 Portland-Vancouver-Salem, OR-WA Central Marion County https://data.medicare.gov/resource/xubh-q36u/row-gawf~xgxy_ivy2 380051 662068 2019-12-02 2019-06-30 334 60       27 421 25 24           470
1921 1921 SHRINERS HOSPITAL FOR CHILDREN-PORTLAND 3101 SW SAM JACKSON PARK ROAD PORTLAND OR 97239 MULTNOMAH (971) 544-3312 Childrens Voluntary non-profit - Private FALSE 45.5001050 -122.6846030 0   51 41 41051 38900 Portland-Vancouver-Salem, OR-WA Central Multnomah County https://data.medicare.gov/resource/xubh-q36u/row-3x85_ztpc_gwzg 383300 645441 2018-05-31 2017-12-31                              
1923 1923 OHSU HOSPITAL AND CLINICS 3181 SW SAM JACKSON PARK ROAD PORTLAND OR 97239 MULTNOMAH (503) 494-6245 Acute Care Hospitals Voluntary non-profit - Other TRUE 45.4992010 -122.6879740 0   51 41 41051 38900 Portland-Vancouver-Salem, OR-WA Central Multnomah County https://data.medicare.gov/resource/xubh-q36u/row-yk4c-r5a6.3wkx 380009 660008 2019-11-22 2019-06-30 417 79         562               562
1922 1922 LEGACY EMANUEL MEDICAL CENTER 2801 N GANTENBEIN AVENUE PORTLAND OR 97227 MULTNOMAH (503) 413-2200 Acute Care Hospitals Voluntary non-profit - Private TRUE 45.5440500 -122.6694450 0   51 41 41051 38900 Portland-Vancouver-Salem, OR-WA Central Multnomah County https://data.medicare.gov/resource/xubh-q36u/row-7f4v.d6m7-2kdb 380007 654861 2019-09-26 2019-03-31 263           384 101             485
2372 2372 PROVIDENCE ST VINCENT MEDICAL CENTER 9205 SW BARNES ROAD PORTLAND OR 97225 WASHINGTON (503) 216-2213 Acute Care Hospitals Voluntary non-profit - Private TRUE 45.5088200 -122.7706570 0   67 41 41067 38900 Portland-Vancouver-Salem, OR-WA Central Washington County https://data.medicare.gov/resource/xubh-q36u/row-rq29.araq~qt2q 380004 647933 2019-05-16 2018-12-31 367 20       47 462               462
314 314 PROVIDENCE MILWAUKIE HOSPITAL 10150 SE 32ND AVENUE MILWAUKIE OR 97222 CLACKAMAS (503) 513-8336 Acute Care Hospitals Voluntary non-profit - Church FALSE 45.4497140 -122.6297910 0   5 41 41005 38900 Portland-Vancouver-Salem, OR-WA Central Clackamas County https://data.medicare.gov/resource/xubh-q36u/row-enfi.92yw~y8ym 380082 647935 2019-05-16 2018-12-31 34 6         40 19             59
1920 1920 ADVENTIST HEALTH PORTLAND 10123 SE MARKET STREET PORTLAND OR 97216 MULTNOMAH (503) 257-2500 Acute Care Hospitals Voluntary non-profit - Church TRUE 45.5115370 -122.5590930 0   51 41 41051 38900 Portland-Vancouver-Salem, OR-WA Central Multnomah County https://data.medicare.gov/resource/xubh-q36u/row-zb4z~fv5p-q8sy 380060 649341 2019-05-30 2018-12-31 156 12         168 43             211
1924 1924 PROVIDENCE PORTLAND MEDICAL CENTER 4805 NE GLISAN STREET PORTLAND OR 97213 MULTNOMAH (503) 215-1111 Acute Care Hospitals Voluntary non-profit - Private TRUE 45.5265180 -122.6140580 0   51 41 41051 38900 Portland-Vancouver-Salem, OR-WA Central Multnomah County https://data.medicare.gov/resource/xubh-q36u/row-2u8n.htw2.4ypj 380061 647934 2019-05-16 2018-12-31 289 36       17 342 31 18           391
1925 1925 LEGACY GOOD SAMARITAN MEDICAL CENTER 1015 NW 22ND AVENUE, W121 PORTLAND OR 97210 MULTNOMAH (503) 413-7711 Acute Care Hospitals Voluntary non-profit - Private TRUE 45.5305510 -122.6965890 0   51 41 41051 38900 Portland-Vancouver-Salem, OR-WA Central Multnomah County https://data.medicare.gov/resource/xubh-q36u/row-6zih.h2xm.wkif 380017 653351 2019-08-30 2019-03-31 136 28         164   36           200
2065 2065 ADVENTIST HEALTH TILLAMOOK 1000 THIRD STREET TILLAMOOK OR 97141 TILLAMOOK (503) 842-4444 Critical Access Hospitals Voluntary non-profit - Church TRUE 45.4563220 -123.8549510 0   57 41 41057         https://data.medicare.gov/resource/xubh-q36u/row-hny7~x5jj.a66t 381317 648758 2019-05-28 2018-12-31 21 4         25               25
383 383 PROVIDENCE SEASIDE HOSPITAL 725 S WAHANNA ROAD SEASIDE OR 97138 CLATSOP (503) 717-7000 Critical Access Hospitals Voluntary non-profit - Church TRUE 45.9893670 -123.9148050 0   7 41 41007 11820   Central Clatsop County https://data.medicare.gov/resource/xubh-q36u/row-5sr7.sj6w~p8fw 381303 647937 2019-05-15 2018-12-31 23           23               23
2483 2483 PROVIDENCE NEWBERG MEDICAL CENTER 1001 PROVIDENCE DRIVE NEWBERG OR 97132 YAMHILL (503) 537-1555 Acute Care Hospitals Voluntary non-profit - Church TRUE 45.3085520 -122.9339130 0   71 41 41071 38900 Portland-Vancouver-Salem, OR-WA Outlying Yamhill County https://data.medicare.gov/resource/xubh-q36u/row-zttx-g4s5_qqvh 380037 648647 2019-05-22 2018-12-31 36 4         40               40
2484 2484 WILLAMETTE VALLEY MEDICAL CENTER 2700 SE STRATUS AVE. MCMINNVILLE OR 97128 YAMHILL (503) 472-6131 Acute Care Hospitals Voluntary non-profit - Private TRUE 45.2003100 -123.1652300 0   71 41 41071 38900 Portland-Vancouver-Salem, OR-WA Outlying Yamhill County https://data.medicare.gov/resource/xubh-q36u/row-uqc6-c9i9_jkxa 380071 648975 2019-05-29 2018-12-31 43 7         50 10             60
2374 2374 KAISER FOUNDATION HOSPITAL - WESTSIDE 2875 NW STUCKI AVE HILLSBORO OR 97124 WASHINGTON (971) 310-1000 Acute Care Hospitals Voluntary non-profit - Private TRUE 45.5397130 -122.8756670 0   67 41 41067 38900 Portland-Vancouver-Salem, OR-WA Central Washington County https://data.medicare.gov/resource/xubh-q36u/row-7pvy~zd9e_3y9d 380103 652265 2019-06-06 2018-12-31 102 20         122               122
2371 2371 TUALITY COMMUNITY HOSPITAL 335 SE 8TH AVENUE HILLSBORO OR 97123 WASHINGTON (503) 681-1111 Acute Care Hospitals Voluntary non-profit - Private TRUE 45.5196230 -122.9773100 0   67 41 41067 38900 Portland-Vancouver-Salem, OR-WA Central Washington County https://data.medicare.gov/resource/xubh-q36u/row-x4zr_f9jw.9qwd 380021 662242 2018-11-30 2018-06-30 165 29         194 21             215
382 382 COLUMBIA MEMORIAL HOSPITAL 2111 EXCHANGE STREET ASTORIA OR 97103 CLATSOP (503) 325-4321 Critical Access Hospitals Proprietary TRUE 46.1885030 -123.8185020 0   7 41 41007 11820   Central Clatsop County https://data.medicare.gov/resource/xubh-q36u/row-qaiq-isb9.5jkp 381320 647151 2019-04-30 2018-12-31 21 4         25               25
2373 2373 LEGACY MERIDIAN PARK MEDICAL CENTER 19300 SW 65TH AVENUE TUALATIN OR 97062 WASHINGTON (503) 692-2182 Acute Care Hospitals Voluntary non-profit - Private TRUE 45.3774810 -122.7439310 0   67 41 41067 38900 Portland-Vancouver-Salem, OR-WA Central Washington County https://data.medicare.gov/resource/xubh-q36u/row-wudw-qmsk_mszn 380089 653353 2019-08-30 2019-03-31 101 16         117               117
2321 2321 MID-COLUMBIA MEDICAL CENTER 1700 E 19TH STREET THE DALLES OR 97058 WASCO (541) 296-1111 Acute Care Hospitals Voluntary non-profit - Other TRUE 45.5879480 -121.1654700 0   65 41 41065 45520   Central Wasco County https://data.medicare.gov/resource/xubh-q36u/row-bx62.pzwr_8uvb 380001 649817 2019-05-31 2018-12-31 26 17         43   6           49
312 312 PROVIDENCE WILLAMETTE FALLS MEDICAL CENTER 1500 DIVISION STREET OREGON CITY OR 97045 CLACKAMAS (503) 657-6915 Acute Care Hospitals Voluntary non-profit - Private TRUE 45.3566470 -122.5883710 0   5 41 41005 38900 Portland-Vancouver-Salem, OR-WA Central Clackamas County https://data.medicare.gov/resource/xubh-q36u/row-4zvi_yd6d-6gyq 380038 648648 2019-05-22 2018-12-31 103 8         111               111
1100 1100 PROVIDENCE HOOD RIVER MEMORIAL HOSPITAL 810 12TH STREET HOOD RIVER OR 97031 HOOD RIVER (541) 386-3911 Critical Access Hospitals Voluntary non-profit - Church TRUE 45.7045610 -121.5232240 0   27 41 41027 26220   Central Hood River County https://data.medicare.gov/resource/xubh-q36u/row-83aq-mayj_upac 381318 650203 2019-06-12 2018-12-31 25           25               25
1926 1926 LEGACY MOUNT HOOD MEDICAL CENTER 24800 SE STARK STREET GRESHAM OR 97030 MULTNOMAH (503) 674-1122 Acute Care Hospitals Voluntary non-profit - Private TRUE 45.5190530 -122.4082790 0   51 41 41051 38900 Portland-Vancouver-Salem, OR-WA Central Multnomah County https://data.medicare.gov/resource/xubh-q36u/row-cxuh~ek4n_xkr9 380025 653352 2019-08-30 2019-03-31 83 10         93               93
313 313 KAISER SUNNYSIDE MEDICAL CENTER 10180 SE SUNNYSIDE ROAD CLACKAMAS OR 97015 CLACKAMAS (503) 652-2880 Acute Care Hospitals Voluntary non-profit - Other TRUE 45.4334620 -122.5585250 0   5 41 41005 38900 Portland-Vancouver-Salem, OR-WA Central Clackamas County https://data.medicare.gov/resource/xubh-q36u/row-akhw.kvgz.wg78 380091 649818 2019-06-06 2018-12-31 242 40         302               302
3412 3412 COMMONWEALTH HEALTH CENTER 1 LOWER NAVY HILL ROAD (PO BOX 409CK) GARAPAN MP 96950 SAIPAN (670) 234-8950 Acute Care Hospitals Proprietary TRUE 15.2086299 145.7303467 1 GEOMETRIC_CENTER 110 69 69110         https://data.medicare.gov/resource/xubh-q36u/row-z8uz.de7b_sx86 660001 644688 2019-03-01 2018-09-30 70 4         74               74
478 478 GUAM REGIONAL MEDICAL CITY 133 ROUTE 3 DEDEDO GU 96929 GUAM (671) 645-5500 Acute Care Hospitals Voluntary non-profit - Private TRUE 13.5248362 144.8232653 1 ROOFTOP 10 66 66010         https://data.medicare.gov/resource/xubh-q36u/row-ikxi.yahy_8xvd 650003 651493 2019-06-04 2018-12-31 88 17         105               105
477 477 GUAM MEMORIAL HOSPITAL AUTHORITY 85O GOV CARLOS G CAMACHO ROAD TAMUNING GU 96913 GUAM (671) 647-2552 Acute Care Hospitals Government - Local TRUE 13.5008229 144.7755910 1 GEOMETRIC_CENTER 10 66 66010         https://data.medicare.gov/resource/xubh-q36u/row-4hjs.vy3n_hawy 650001 644079 2019-02-28 2018-09-30 147 14         161       40       201
159 159 Tripler AMC (FT Shafter) 1 Jarrett White Rd Honolulu HI 96859 HONOLULU (808) 433-2778 Acute Care - Department of Defense Department of Defense TRUE 21.3588670 -157.8887690 0   3 15 15003 46520   Central Honolulu County https://data.medicare.gov/resource/xubh-q36u/row-xb5h~t6w7_qec8                                      
156 156 KAPIOLANI MEDICAL CENTER FOR WOMEN & CHILDREN 1319 PUNAHOU STREET HONOLULU HI 96826 HONOLULU (808) 983-6000 Childrens Voluntary non-profit - Private TRUE 21.3003960 -157.8342460 0   3 15 15003 46520   Central Honolulu County https://data.medicare.gov/resource/xubh-q36u/row-2vss_bgb6-b6d4 123300 659778 2019-11-26 2019-06-30 156 3         253               253
158 158 SHRINERS HOSPITAL FOR CHILDREN 1310 PUNAHOU STREET HONOLULU HI 96826 HONOLULU (808) 941-4466 Childrens Voluntary non-profit - Private FALSE 21.3002330 -157.8343650 0   3 15 15003 46520   Central Honolulu County https://data.medicare.gov/resource/xubh-q36u/row-jcn3.53aq~rski 123301 644976 2018-05-31 2017-12-31                              
157 157 KAISER FOUNDATION HOSPITAL 3288 MOANALUA RD HONOLULU HI 96819 HONOLULU (808) 432-0000 Acute Care Hospitals Voluntary non-profit - Private TRUE 21.3622920 -157.9001390 0   3 15 15003 46520   Central Honolulu County https://data.medicare.gov/resource/xubh-q36u/row-58ey-5yy7~4xmg 120011 652244 2019-06-06 2018-12-31 252 25         295               295
154 154 KUAKINI MEDICAL CENTER 347 NORTH KUAKINI STREET HONOLULU HI 96817 HONOLULU (808) 536-2236 Acute Care Hospitals Voluntary non-profit - Private TRUE 21.3222110 -157.8562110 0   3 15 15003 46520   Central Honolulu County https://data.medicare.gov/resource/xubh-q36u/row-haju_ivwx-iwr6 120007 656434 2018-12-26 2018-06-30 146 12 12       170       40 147     357
160 160 THE QUEENS MEDICAL CENTER 1301 PUNCHBOWL ST HONOLULU HI 96813 HONOLULU (808) 538-9011 Acute Care Hospitals Voluntary non-profit - Private TRUE 21.3083070 -157.8549650 0   3 15 15003 46520   Central Honolulu County https://data.medicare.gov/resource/xubh-q36u/row-miez-e8mq~vhab 120001 662517 2019-11-29 2019-06-30 592 58         650               650
162 162 STRAUB CLINIC AND HOSPITAL 888 SO KING STREET HONOLULU HI 96813 HONOLULU (808) 522-4000 Acute Care Hospitals Proprietary TRUE 21.3022680 -157.8509210 0   3 15 15003 46520   Central Honolulu County https://data.medicare.gov/resource/xubh-q36u/row-j69k-r5cq-9v28 120022 659775 2019-11-26 2019-06-30 140 16   3     159               159
476 476 LBJ TROPICAL MEDICAL CENTER FAGAALU VILLAGE PAGO PAGO AS 96799 EASTERN DISTRICT (684) 633-4590 Acute Care Hospitals Government - Hospital District or Authority TRUE -14.2900610 -170.6847054 1 APPROXIMATE 10 60 60010         https://data.medicare.gov/resource/xubh-q36u/row-6iv4.yudm-sdek                                      
350 350 KAUAI VETERANS MEMORIAL HOSPITAL 4643 WAIMEA CANYON DRIVE WAIMEA HI 96796 KAUAI (808) 338-9431 Critical Access Hospitals Government - State TRUE 21.9600790 -159.6700550 0   7 15 15007 28180   Central Kauai County https://data.medicare.gov/resource/xubh-q36u/row-ddrn-xkz9.2xji 121300 655051 2019-09-20 2018-06-30 23 2         25       20       45
425 425 MAUI MEMORIAL MEDICAL CENTER 221 MAHALANI STREET WAILUKU HI 96793 MAUI (808) 442-5101 Acute Care Hospitals Government - State FALSE 20.8844550 -156.4880870 0   9 15 15009 27980   Central Maui County https://data.medicare.gov/resource/xubh-q36u/row-66fd~zrmp.8s5u 120002 649892 2019-06-03 2018-12-31 199 20         219               219
427 427 KULA HOSPITAL 100 KEOKEA PLACE KULA HI 96790 MAUI (808) 878-1221 Critical Access Hospitals Government - State TRUE 20.7019940 -156.3570990 0   9 15 15009 27980   Central Maui County https://data.medicare.gov/resource/xubh-q36u/row-8svz_bunk-n2za 121308 648609 2019-06-03 2018-12-31 9           9       105       123
164 164 WAHIAWA GENERAL HOSPITAL 128 LEHUA STREET WAHIAWA HI 96786 HONOLULU (808) 621-8411 Acute Care Hospitals Voluntary non-profit - Private TRUE 21.4985110 -158.0272990 0   3 15 15003 46520   Central Honolulu County https://data.medicare.gov/resource/xubh-q36u/row-tmp7_2wk5_m9wr 120004 662186 2019-11-26 2019-06-30 37 6         43       107       150
84 84 KAU HOSPITAL 1 KAMANI STREET PAHALA HI 96777 HAWAII (808) 928-8331 Critical Access Hospitals Government - State TRUE 19.2005710 -155.4720970 0   1 15 15001 25900   Central Hawaii County https://data.medicare.gov/resource/xubh-q36u/row-jcnf-fhnk_q5i3 121301 662188 2019-12-02 2019-06-30 6           6               6
349 349 WILCOX MEMORIAL HOSPITAL 3-3420 KUHIO HIGHWAY LIHUE HI 96766 KAUAI (808) 245-1103 Acute Care Hospitals Government - Federal TRUE 21.9870430 -159.3661980 0   7 15 15007 28180   Central Kauai County https://data.medicare.gov/resource/xubh-q36u/row-9k2j.d4pk.dvnd 120014 662037 2019-11-26 2019-06-30 65 7         72               72
426 426 LANAI COMMUNITY HOSPITAL 628 7TH STREET LANAI CITY HI 96763 MAUI (808) 565-8450 Critical Access Hospitals Government - State TRUE 20.8267350 -156.9180020 0   9 15 15009 27980   Central Maui County https://data.medicare.gov/resource/xubh-q36u/row-keiy_dtd7_smny 121305 648608 2019-06-03 2018-12-31 4           4       10       14
83 83 KOHALA HOSPITAL 54-383 HOSPITAL ROAD KAPAAU HI 96755 HAWAII (808) 889-6211 Critical Access Hospitals Government - State TRUE 20.2317370 -155.7972530 0   1 15 15001 25900   Central Hawaii County https://data.medicare.gov/resource/xubh-q36u/row-zwx4_qya8~b57e 121302 662519 2019-11-29 2019-06-30 6           6       22       28
82 82 KONA COMMUNITY HOSPITAL 79-1019 HAUKAPILA STREET KEALAKEKUA HI 96750 HAWAII (808) 322-9311 Acute Care Hospitals Government - State TRUE 19.5192370 -155.9177190 0   1 15 15001 25900   Central Hawaii County https://data.medicare.gov/resource/xubh-q36u/row-j5zq.9y53_j6as 120019 662187 2019-12-02 2019-06-30 74 9         83 11             94
424 424 MOLOKAI GENERAL HOSPITAL 280 HOME OLU PLACE KAUNAKAKAI HI 96748 MAUI (808) 553-5331 Critical Access Hospitals Voluntary non-profit - Private TRUE 21.0937600 -157.0179820 0   9 15 15009 27980   Central Maui County https://data.medicare.gov/resource/xubh-q36u/row-vd6b-yn49_x98y 121303 659777 2019-11-26 2019-06-30 15           15               15
351 351 SAMUEL MAHELONA MEMORIAL HOSPITAL 4800 KAWAIHAU ROAD KAPAA HI 96746 KAUAI (808) 822-4961 Critical Access Hospitals Government - State TRUE 22.0876190 -159.3142040 0   7 15 15007 28180   Central Kauai County https://data.medicare.gov/resource/xubh-q36u/row-ysve.ycbm-b3qy 121306 640504 2018-11-30 2018-06-30 5           5 9     66       80

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