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 lat 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
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
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
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
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                                      
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
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
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                                      
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
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
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
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
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
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
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
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
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
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
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
974 974 ST LUKE'S HOSPITAL 702 1ST ST SW CROSBY ND 58730 DIVIDE (701) 965-6384 Critical Access Hospitals Voluntary non-profit - Private TRUE 48.9067080 -103.2982300 0   23 38 38023         https://data.medicare.gov/resource/xubh-q36u/row-pn67~uvq9.k3y8 351325 638546 2018-11-26 2018-06-30 15           15       40       55
2656 2656 PRESENTATION MEDICAL CENTER 213 SECOND AVE NE ROLLA ND 58367 ROLETTE (701) 477-3161 Critical Access Hospitals Voluntary non-profit - Private TRUE 48.8615620 -99.6155150 0   79 38 38079         https://data.medicare.gov/resource/xubh-q36u/row-e43c~yjqv.3ca8 351316 643363 2019-02-22 2018-09-30 25           25               25
2655 2655 P H S INDIAN HOSP AT BELCOURT-QUENTIN N BURDICK PO BOX 160 BELCOURT ND 58316 ROLETTE (701) 477-6111 Acute Care Hospitals Government - Federal TRUE 48.8434415 -99.7483567 1 ROOFTOP 79 38 38079         https://data.medicare.gov/resource/xubh-q36u/row-tdmb_245b_qx4d 350063 650356 2019-06-18 2018-09-30 27           27               27
3857 3857 LIFECARE MEDICAL CENTER 715 DELMORE DRIVE ROSEAU MN 56751 ROSEAU (218) 463-2500 Critical Access Hospitals Voluntary non-profit - Private TRUE 48.8398220 -95.7599470 0   135 27 27135         https://data.medicare.gov/resource/xubh-q36u/row-k2tw.t9zs_excc 241344 645269 2019-02-27 2018-09-30 25           25       50       75
458 458 ST ANDREWS HEALTH CENTER - CAH 316 OHMER STREET BOTTINEAU ND 58318 BOTTINEAU (701) 228-9300 Critical Access Hospitals Voluntary non-profit - Church TRUE 48.8291900 -100.4490790 0   9 38 38009         https://data.medicare.gov/resource/xubh-q36u/row-srt8.v5j2-m5pz 351307 645009 2019-03-05 2018-09-30 25           25               25
2368 2368 PEMBINA COUNTY MEMORIAL HOSPITAL BOX 380 CAVALIER ND 58220 PEMBINA (701) 265-8461 Critical Access Hospitals Voluntary non-profit - Private TRUE 48.7938813 -97.6223098 1 APPROXIMATE 67 38 38067         https://data.medicare.gov/resource/xubh-q36u/row-nr5r_iafj-hv8d 351319 645788 2019-03-27 2018-12-31 20           20       50       70
841 841 DANIELS MEMORIAL HOSPITAL 105 5TH AVE E SCOBEY MT 59263 DANIELS (406) 487-2296 Critical Access Hospitals Voluntary non-profit - Private TRUE 48.7886240 -105.4185870 0   19 30 30019         https://data.medicare.gov/resource/xubh-q36u/row-xufw-inrb~p3dx 271342 662053 2019-12-04 2019-06-30 25           25               25
2962 2962 SHERIDAN MEMORIAL HOSPTIAL 440 W LAUREL AVE PLENTYWOOD MT 59254 SHERIDAN (406) 765-3700 Critical Access Hospitals Voluntary non-profit - Private TRUE 48.7786770 -104.5629980 0   91 30 30091         https://data.medicare.gov/resource/xubh-q36u/row-sdy5~7jt6~e9wj 271322 660411 2019-11-26 2019-06-30 19           19       45       64
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
2403 2403 KITTSON MEMORIAL HOSPITAL 1010 SOUTH BIRCH HALLOCK MN 56728 KITTSON (218) 843-3612 Critical Access Hospitals Voluntary non-profit - Private TRUE 48.7670580 -96.9404920 0   69 27 27069         https://data.medicare.gov/resource/xubh-q36u/row-6ca3.ddbe~k6m7 241336 651470 2019-06-24 2018-09-30 15           15       60       75
851 851 CAVALIER COUNTY MEMORIAL HOSPITAL ASSOCIATION 909 2ND ST LANGDON ND 58249 CAVALIER (701) 256-6100 Critical Access Hospitals Voluntary non-profit - Private TRUE 48.7612430 -98.3666610 0   19 38 38019         https://data.medicare.gov/resource/xubh-q36u/row-m8nv.tvsx-unkm 351323 638003 2018-11-28 2018-06-30 20           20               20
2611 2611 LAKEWOOD HEALTH CENTER 600 MAIN AVE S BAUDETTE MN 56623 LAKE OF WOODS (218) 634-2120 Critical Access Hospitals Voluntary non-profit - Church TRUE 48.7074270 -94.6011720 0   77 27 27077         https://data.medicare.gov/resource/xubh-q36u/row-x2n8-qsfh.99ps 241301 661915 2019-12-04 2019-06-30 15           15       44       59
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
890 890 BOUNDARY COMMUNITY HOSPITAL 6640 KANIKSU STREET BONNERS FERRY ID 83805 BOUNDARY (208) 267-4850 Critical Access Hospitals Voluntary non-profit - Other TRUE 48.7025700 -116.3220840 0   21 16 16021         https://data.medicare.gov/resource/xubh-q36u/row-7r4n.ssgi~ypas 131301 645892 2019-04-01 2018-12-31 20           20       28       48
3217 3217 KENMARE COMMUNITY HOSPITAL PO BOX 697 KENMARE ND 58746 WARD (701) 385-4296 Critical Access Hospitals Voluntary non-profit - Private TRUE 48.6742881 -102.0844703 1 ROOFTOP 101 38 38101 33500   Central Ward County https://data.medicare.gov/resource/xubh-q36u/row-tfzi_r3ee-4azt 351305 660271 2019-11-25 2019-06-30 25           25               25
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
1397 1397 NORTHERN ROCKIES MEDICAL CENTER 802 2ND ST SE CUT BANK MT 59427 GLACIER (406) 873-2251 Critical Access Hospitals Voluntary non-profit - Private TRUE 48.6287800 -112.3263450 0   35 30 30035         https://data.medicare.gov/resource/xubh-q36u/row-mzwj.8j2h.fdnu 271337 643521 2019-02-26 2018-09-30 20           20               20
2468 2468 RAINY LAKE MEDICAL CENTER 1400 HIGHWAY 71 INTERNATIONAL FALLS MN 56649 KOOCHICHING (218) 283-4481 Critical Access Hospitals Voluntary non-profit - Private TRUE 48.5939840 -93.4307740 0   71 27 27071         https://data.medicare.gov/resource/xubh-q36u/row-vxub~598y~nqxs 241322 650163 2019-06-10 2018-12-31 18           18               18
1398 1398 P H S INDIAN HOSPITAL AT BROWNING - BLACKFEET 760 HOSPITAL CIRCLE, POST OFFICE BOX 760 BROWNING MT 59417 GLACIER (406) 338-6157 Acute Care Hospitals Government - Federal TRUE 48.5657292 -113.0197530 1 ROOFTOP 35 30 30035         https://data.medicare.gov/resource/xubh-q36u/row-6bdm_qidd_w2p9 270074 651216 2019-06-24 2018-09-30 26           26               26
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
1652 1652 NORTHERN MONTANA HOSPITAL 30 13TH ST HAVRE MT 59501 HILL (406) 265-2211 Acute Care Hospitals Voluntary non-profit - Private TRUE 48.5393260 -109.6863630 0   41 30 30041         https://data.medicare.gov/resource/xubh-q36u/row-8qcs_chz3.vw49 270032 659042 2019-11-19 2019-06-30 43 6         49       135       184
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
1912 1912 LIBERTY MEDICAL CENTER 315 W MADISON AVE CHESTER MT 59522 LIBERTY (406) 759-5181 Critical Access Hospitals Voluntary non-profit - Private TRUE 48.5104970 -110.9718340 0   51 30 30051         https://data.medicare.gov/resource/xubh-q36u/row-jg4d_ys9s~wecb 271334 662543 2019-11-27 2019-06-30 25           25               25
3210 3210 MARIAS MEDICAL CENTER 640 PARK AVE SHELBY MT 59474 TOOLE (406) 434-3200 Critical Access Hospitals Government - Local TRUE 48.5096040 -111.8504930 0   101 30 30101         https://data.medicare.gov/resource/xubh-q36u/row-xx4t-djb3.f4q7 271328 659312 2019-11-20 2019-06-30 21           21               21
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
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
3058 3058 TOWNER COUNTY MEDICAL CENTER HWY 281 N CANDO ND 58324 TOWNER (701) 968-4411 Critical Access Hospitals Voluntary non-profit - Private TRUE 48.4931522 -99.2110430 1 ROOFTOP 95 38 38095         https://data.medicare.gov/resource/xubh-q36u/row-8pd6_eppf-kx3r 351331 638004 2018-11-28 2018-06-30 20           20       30   5   55
294 294 P H S INDIAN HOSPITAL-FT BELKNAP AT HARLEM - CAH 456 GROS VENTRE AVE, RR 1 HARLEM MT 59526 BLAINE (406) 353-3100 Critical Access Hospitals Government - Federal TRUE 48.4851890 -108.7670010 0   5 30 30005         https://data.medicare.gov/resource/xubh-q36u/row-sifm_y3g6.gq5p 271315 646038 2019-03-29 2018-09-30 6           6               6
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
3173 3173 UNITY MEDICAL CENTER 164 W 13TH STREET GRAFTON ND 58237 WALSH (701) 352-1620 Critical Access Hospitals Voluntary non-profit - Private TRUE 48.4114840 -97.4138290 0   99 38 38099         https://data.medicare.gov/resource/xubh-q36u/row-xvyg.2uq7_fcwn 351320 660660 2019-12-03 2019-06-30 14           14               14
3325 3325 TIOGA MEDICAL CENTER 810 N WELO ST TIOGA ND 58852 WILLIAMS (701) 664-3305 Critical Access Hospitals Voluntary non-profit - Private TRUE 48.4017000 -102.9346490 0   105 38 38105 48780   Central Williams County https://data.medicare.gov/resource/xubh-q36u/row-t847~ir4c-zxs2 351300 655692 2019-10-30 2019-06-30 25           25       30       55
3174 3174 FIRST CARE HEALTH CENTER 115 VIVIAN ST PARK RIVER ND 58270 WALSH (701) 284-7500 Critical Access Hospitals Voluntary non-profit - Private TRUE 48.3992620 -97.7436790 0   99 38 38099         https://data.medicare.gov/resource/xubh-q36u/row-yjef.zes7.d4mf 351326 647924 2019-05-16 2018-12-31 14           14               14
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
1965 1965 CABINET PEAKS MEDICAL CENTER 209 HEALTH PARK DR LIBBY MT 59923 LINCOLN (406) 293-0100 Critical Access Hospitals Voluntary non-profit - Private TRUE 48.3926210 -115.5462710 0   53 30 30053         https://data.medicare.gov/resource/xubh-q36u/row-rev2~xaru.cjba 271320 654457 2019-08-28 2019-03-31 25           25               25
1148 1148 NORTH VALLEY HOSPITAL 1600 HOSPITAL WAY WHITEFISH MT 59937 FLATHEAD (406) 863-3550 Critical Access Hospitals Voluntary non-profit - Private TRUE 48.3810320 -114.3313260 0   29 30 30029 28060   Central Flathead County https://data.medicare.gov/resource/xubh-q36u/row-29tt-ysrs_pnbv 271336 654458 2019-08-28 2019-03-31 21 4         25               25
2409 2409 HEART OF AMERICA MEDICAL CENTER 800 S MAIN AVE RUGBY ND 58368 PIERCE (701) 776-5261 Critical Access Hospitals Voluntary non-profit - Private TRUE 48.3635110 -99.9961110 0   69 38 38069         https://data.medicare.gov/resource/xubh-q36u/row-qi8i~9ssv.ufv2 351332 654478 2019-08-30 2019-03-31 25           25       55       80
2471 2471 PHILLIPS COUNTY MEDICAL CENTER 311 S 8TH AVE E MALTA MT 59538 PHILLIPS (406) 654-1100 Critical Access Hospitals Voluntary non-profit - Private TRUE 48.3570980 -107.8603560 0   71 30 30071         https://data.medicare.gov/resource/xubh-q36u/row-igja_7yh6.38ai 271312 654589 2019-09-16 2019-04-30 6           6               6
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                                      
2211 2211 MOUNTRAIL COUNTY MEDICAL CENTER INC 615 6TH ST SE STANLEY ND 58784 MOUNTRAIL (701) 628-2424 Critical Access Hospitals Voluntary non-profit - Private TRUE 48.3125040 -102.3808690 0   61 38 38061         https://data.medicare.gov/resource/xubh-q36u/row-b8p8-yzkh-reuy 351301 659831 2019-11-22 2019-06-30 11           11               11
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
732 732 BONNER GENERAL HOSPITAL 520 NORTH THIRD AVENUE SANDPOINT ID 83864 BONNER (208) 263-1441 Critical Access Hospitals Voluntary non-profit - Private TRUE 48.2774850 -116.5503140 0   17 16 16017 41760   Central Bonner County https://data.medicare.gov/resource/xubh-q36u/row-j4p7~5f43_p5pc 131328 649722 2019-06-11 2018-12-31 21 4         25               25
3218 3218 TRINITY HOSPITALS 407 3RD ST SE MINOT ND 58701 WARD (701) 857-5000 Acute Care Hospitals Voluntary non-profit - Private TRUE 48.2324790 -101.2884520 0   101 38 38101 33500   Central Ward County https://data.medicare.gov/resource/xubh-q36u/row-7zuw.yviv_94dm 350006 661068 2019-11-25 2019-06-30 117 19         152 26 20   230   2   430
1146 1146 THE HEALTHCENTER 320 SUNNYVIEW LANE KALISPELL MT 59901 FLATHEAD (406) 756-4720 Acute Care Hospitals Proprietary FALSE 48.2162080 -114.3240470 0   29 30 30029 28060   Central Flathead County https://data.medicare.gov/resource/xubh-q36u/row-q8tk.6pjn~75zu 270087 653252 2019-08-26 2019-03-31 17           17   10           27
1147 1147 KALISPELL REGIONAL MEDICAL CENTER 310 SUNNYVIEW LANE KALISPELL MT 59901 FLATHEAD (406) 752-5111 Acute Care Hospitals Voluntary non-profit - Private TRUE 48.2156850 -114.3247530 0   29 30 30029 28060   Central Flathead County https://data.medicare.gov/resource/xubh-q36u/row-n6nd-i5ym.67yu 270051 653251 2019-08-26 2019-03-31 151 18         178       110       288
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
2908 2908 NORTH VALLEY HEALTH CENTER 300 WEST GOOD SAMARITAN DRIVE WARREN MN 56762 MARSHALL (218) 745-4211 Critical Access Hospitals Voluntary non-profit - Private TRUE 48.1927360 -96.7743980 0   89 27 27089         https://data.medicare.gov/resource/xubh-q36u/row-5hr9-apeq-pgtf 241337 651012 2019-06-04 2018-12-31 12           12               12
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
3319 3319 FRANCES MAHON DEACONESS HOSPITAL 621 3RD ST S GLASGOW MT 59230 VALLEY (406) 228-3500 Critical Access Hospitals Voluntary non-profit - Private TRUE 48.1895710 -106.6363790 0   105 30 30105         https://data.medicare.gov/resource/xubh-q36u/row-h3fb.ey2c_fvhr 271316 661033 2019-12-06 2019-06-30 25           25               25
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
693 693 BIG SANDY MEDICAL CENTER 166 MONTANA AVE E BIG SANDY MT 59520 CHOUTEAU (406) 378-2188 Critical Access Hospitals Voluntary non-profit - Private TRUE 48.1790800 -110.1082170 0   15 30 30015         https://data.medicare.gov/resource/xubh-q36u/row-9nm3.ugyv-geii 271311 661032 2019-12-09 2019-06-30 8           8       22       30
2540 2540 PONDERA MEDICAL CENTER 805 SUNSET BLVD CONRAD MT 59425 PONDERA (406) 271-3211 Critical Access Hospitals Voluntary non-profit - Private TRUE 48.1739170 -111.9586770 0   73 30 30073         https://data.medicare.gov/resource/xubh-q36u/row-23g5-69uu.yhw9 271324 652085 2019-05-30 2018-12-31 20           20       59       79
3324 3324 CHI ST ALEXIUS HEALTH WILLISTON 1301 15TH AVE W WILLISTON ND 58801 WILLIAMS (701) 774-7400 Critical Access Hospitals Voluntary non-profit - Church TRUE 48.1543320 -103.6454370 0   105 38 38105 48780   Central Williams County https://data.medicare.gov/resource/xubh-q36u/row-2m99~vhsx_qu32 351334 662569 2019-12-02 2019-06-30 25           25               25
2798 2798 ROOSEVELT MEDICAL CENTER 818 2ND AVE E CULBERTSON MT 59218 ROOSEVELT (406) 787-6401 Critical Access Hospitals Voluntary non-profit - Private TRUE 48.1513360 -104.5153960 0   85 30 30085         https://data.medicare.gov/resource/xubh-q36u/row-gk89.j8w2.ytb6 271308 655564 2019-10-03 2019-04-30 33           33               33
2796 2796 POPLAR COMMUNITY HOSPITAL 211 H ST E POPLAR MT 59255 ROOSEVELT (406) 768-6100 Critical Access Hospitals Voluntary non-profit - Private TRUE 48.1149570 -105.1921240 0   85 30 30085         https://data.medicare.gov/resource/xubh-q36u/row-ivpb.zvpr-3zj8 271300 660638 2019-11-25 2019-06-30 20           20               20
2478 2478 CHI ST ALEXIUS HEALTH DEVILS LAKE 1031 7TH ST NE DEVILS LAKE ND 58301 RAMSEY (701) 662-2131 Critical Access Hospitals Voluntary non-profit - Private TRUE 48.1147740 -98.8503450 0   71 38 38071         https://data.medicare.gov/resource/xubh-q36u/row-i8ea.ub9b_eqnm 351333 662067 2019-12-02 2019-06-30 25           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
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
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
2797 2797 TRINITY HOSPITAL 315 KNAPP ST WOLF POINT MT 59201 ROOSEVELT (406) 653-6500 Critical Access Hospitals Voluntary non-profit - Private TRUE 48.1008930 -105.6411380 0   85 30 30085         https://data.medicare.gov/resource/xubh-q36u/row-8zsu~ksjh-u24d 271341 659988 2019-11-25 2019-06-30 22           22       60       82
3473 3473 SANFORD MEDICAL CENTER THIEF RIVER FALLS 3001 SANFORD PARKWAY THIEF RIVER FALLS MN 56701 PENNINGTON (218) 681-4240 Critical Access Hospitals Voluntary non-profit - Private TRUE 48.0886540 -96.1977880 0   113 27 27113         https://data.medicare.gov/resource/xubh-q36u/row-gzeq-cd5a~puya 241381 647753 2019-05-13 2018-12-31 25           25               25
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
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
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
1406 1406 ALTRU HOSPITAL 1200 S COLUMBIA RD GRAND FORKS ND 58201 GRAND FORKS (701) 780-5000 Acute Care Hospitals Government - Local TRUE 47.9105352 -97.0681107 1 ROOFTOP 35 38 38035 24220   Central Grand Forks County https://data.medicare.gov/resource/xubh-q36u/row-tfgh.9uft~bxhm 350019 650883 2019-06-03 2018-12-31 245 16     10   271   23           294
3876 3876 ELY BLOOMENSON COMMUNITY HOSPITAL 328 WEST CONAN STREET ELY MN 55731 ST. LOUIS (218) 365-3271 Critical Access Hospitals Voluntary non-profit - Private TRUE 47.9007010 -91.8719710 0   137 27 27137 20260   Central St. Louis County https://data.medicare.gov/resource/xubh-q36u/row-tia7_tsch.3esn 241318 645476 2019-03-01 2018-09-30 16           16               16
362 362 RED LAKE HOSPITAL A PO BOX 497 REDLAKE MN 56671 BELTRAMI (218) 679-3912 Acute Care Hospitals Government - Federal FALSE 47.8763460 -95.0169401 1 GEOMETRIC_CENTER 7 27 27007 13420   Central Beltrami County https://data.medicare.gov/resource/xubh-q36u/row-jefe.tmy8.7dit 240206 649909 2019-06-18 2018-09-30 23           23               23
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
3877 3877 COOK HOSPITAL 10 SE FIFTH ST COOK MN 55723 ST. LOUIS (218) 666-5945 Critical Access Hospitals Government - Hospital District or Authority TRUE 47.8534680 -92.6800320 0   137 27 27137 20260   Central St. Louis County https://data.medicare.gov/resource/xubh-q36u/row-buxd.3b5c~u3h4 241312 649042 2019-05-21 2018-12-31 14           14       28       42
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
692 692 MISSOURI RIVER MEDICAL CENTER 1501 ST CHARLES ST FORT BENTON MT 59442 CHOUTEAU (406) 622-3331 Critical Access Hospitals Government - Hospital District or Authority TRUE 47.8203555 -110.6722100 1 ROOFTOP 15 30 30015         https://data.medicare.gov/resource/xubh-q36u/row-ibbr.ff9i-ncwz 271304 656304 2019-11-04 2019-06-30 25           25               25
3170 3170 BENEFIS TETON MEDICAL CENTER 915 4TH ST NW CHOTEAU MT 59422 TETON (406) 466-5763 Critical Access Hospitals Voluntary non-profit - Private TRUE 47.8134200 -112.1924570 0   99 30 30099         https://data.medicare.gov/resource/xubh-q36u/row-f2z3-5ua9~t2zq 271307 650727 2019-05-31 2018-12-31 25           25               25
1969 1969 MCKENZIE COUNTY HEALTHCARE SYSTEMS INC 709 4TH AVE NE WATFORD CITY ND 58854 MCKENZIE (701) 842-3000 Critical Access Hospitals Voluntary non-profit - Private TRUE 47.8046820 -103.2713580 0   53 38 38053         https://data.medicare.gov/resource/xubh-q36u/row-ph32.gcyn.yevx 351302 652530 2018-12-03 2018-06-30 24           24       47       71
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
3598 3598 RIVERVIEW HOSPITAL 323 SOUTH MINNESOTA CROOKSTON MN 56716 POLK (218) 281-9200 Critical Access Hospitals Voluntary non-profit - Private TRUE 47.7720830 -96.6181060 0   119 27 27119 24220   Central Polk County https://data.medicare.gov/resource/xubh-q36u/row-9ugf.smjx.yquq 241320 644130 2019-02-28 2018-09-30 25 5         30       24       54
24 24 ST ALOISIUS MEDICAL CENTER 325 E BREWSTER ST HARVEY ND 58341 WELLS (701) 324-4651 Critical Access Hospitals Voluntary non-profit - Private TRUE 47.7676870 -99.9330890 0   103 38 38103         https://data.medicare.gov/resource/xubh-q36u/row-u657.4sxp.u7ix 351327 644053 2019-02-27 2018-09-30 25           25       91       116
2265 2265 NELSON COUNTY HEALTH SYSTEM 200 N MAIN ST MCVILLE ND 58254 NELSON (701) 322-4328 Critical Access Hospitals Voluntary non-profit - Private TRUE 47.7656260 -98.1773140 0   63 38 38063         https://data.medicare.gov/resource/xubh-q36u/row-mxe5_p48x_qufq 351308 640252 2018-11-29 2018-06-30 19           19       39       58

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