hospital_data

Table actions
Data provided via a collaboration between The Accountability Project and Big Local News. This project provides and joins datasets pertinent to the COVID-19 pandemic: hospital location and number of beds by type, county-level population estimates by age (which can be linked to hospital data) and nursing home location and capacity. See README for additional information.

Data source: Big Local News · About: big-local-datasette

1,122 rows where centraloutlyingcounty = "" sorted by phone_number

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: hospital_type, hospital_ownership, emergency_services, geocode_flag, geocode_accuracy, fy_end_date, icu_beds, coronary_beds, oth_spec_beds, subprovider_ipf_beds, subprovider_irf_beds, nursing_fac_beds, filed_date (date), fy_end_date (date)

centraloutlyingcounty ✖

  • - · 1,122 ✖
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
4601 4601 UT HEALTH EAST TEXAS CARTHAGE HOSPITAL 409 COTTAGE RD CARTHAGE TX 75633 PANOLA (093) 693-3841 Acute Care Hospitals Voluntary non-profit - Private TRUE 32.1671260 -94.3460390 0   365 48 48365         https://data.medicare.gov/resource/xubh-q36u/row-tyuw-zwkq.zq2r 450210 640322 2018-12-28 2018-07-31 42           42               42
2238 2238 GREENE COUNTY HOSPITAL 509 WILSON AVENUE EUTAW AL 35462 GREENE (205) 372-3388 Acute Care Hospitals Government - Local TRUE 32.8447440 -87.8893070 0   63 1 1063         https://data.medicare.gov/resource/xubh-q36u/row-dyit.ypt9~f4e7 10051 645036 2019-03-04 2018-09-30 20           20       72       92
3574 3574 HILL HOSPITAL OF SUMTER COUNTY 751 DERBY DRIVE YORK AL 36925 SUMTER (205) 392-5263 Acute Care Hospitals Voluntary non-profit - Other TRUE 32.4918250 -88.2960810 0   119 1 1119         https://data.medicare.gov/resource/xubh-q36u/row-hxjd.ga7s.xmvj 10138 651158 2019-06-03 2018-12-31 33           33               33
940 940 CHOCTAW GENERAL HOSPITAL 401 VANITY FAIR LANE, PO BOX 618 BUTLER AL 36904 CHOCTAW (205) 459-9100 Critical Access Hospitals Voluntary non-profit - Private TRUE 32.0937419 -88.2095888 1 ROOFTOP 23 1 1023         https://data.medicare.gov/resource/xubh-q36u/row-cm2u-i8id~q257 11304 651161 2019-06-03 2018-12-31 25           25               25
3823 3823 LAKELAND COMMUNITY HOSPITAL 42024 HIGHWAY 195 E HALEYVILLE AL 35565 WINSTON (205) 485-7117 Acute Care Hospitals Voluntary non-profit - Church TRUE 34.2417180 -87.5898570 0   133 1 1133         https://data.medicare.gov/resource/xubh-q36u/row-qzez~be97-dgiz 10125 645811 2019-04-01 2018-12-31 45 4         49 9             58
2986 2986 NORTHWEST MEDICAL CENTER 1530 U S HIGHWAY 43 WINFIELD AL 35594 FAYETTE (205) 487-7736 Acute Care Hospitals Proprietary TRUE 33.9293160 -87.8245070 0   93 1 1093         https://data.medicare.gov/resource/xubh-q36u/row-r4dk-tpsz_u57n 10086 651153 2019-06-03 2018-12-31 57 4         61 10             71
2985 2985 MARION REGIONAL MEDICAL CENTER 1256 MILITARY STREET SOUTH HAMILTON AL 35570 MARION (205) 921-6200 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.1258520 -87.9898060 0   93 1 1093         https://data.medicare.gov/resource/xubh-q36u/row-ak6z-c9hr~7upb 10044 643754 2019-02-28 2018-09-30 32 4         36       79       115
2045 2045 FAYETTE MEDICAL CENTER 1653 TEMPLE AVENUE NORTH FAYETTE AL 35555 FAYETTE (205) 932-5966 Acute Care Hospitals Voluntary non-profit - Other TRUE 33.7077080 -87.8237060 0   57 1 1057         https://data.medicare.gov/resource/xubh-q36u/row-f7kw.zhbj_gfwf 10045 644692 2019-02-28 2018-09-30 37 8         45       122       167
7 7 DOWN EAST COMMUNITY HOSPITAL 11 HOSPITAL DRIVE MACHIAS ME 4654 WASHINGTON (207) 255-3356 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.7134110 -67.4772030 0   29 23 23029         https://data.medicare.gov/resource/xubh-q36u/row-tmd2.zxhs~phzc 201311 650481 2019-05-31 2018-12-31 25           25               25
437 437 MOUNT DESERT ISLAND HOSPITAL 10 WAYMAN LANE, PO BOX 8 BAR HARBOR ME 4609 HANCOCK (207) 288-5081 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.3843690 -68.2023310 0   9 23 23009         https://data.medicare.gov/resource/xubh-q36u/row-egex~7j5d.98hj 201304 654844 2019-09-30 2019-04-30 25           25               25
1075 1075 WALDO COUNTY GENERAL HOSPITAL 118 NORTHPORT AVE BELFAST ME 4915 WALDO (207) 338-2500 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.4127590 -68.9951020 0   27 23 23027         https://data.medicare.gov/resource/xubh-q36u/row-9ec9_eza5.9s9p 201312 650482 2019-05-31 2018-12-31 21 4         25               25
744 744 RUMFORD HOSPITAL 420 FRANKLIN STREET RUMFORD ME 4276 OXFORD (207) 369-1000 Critical Access Hospitals Proprietary TRUE 44.5517210 -70.5571710 0   17 23 23017         https://data.medicare.gov/resource/xubh-q36u/row-923a_kexq.nxfx 201306 662536 2019-12-02 2019-06-30 25           25               25
438 438 NORTHERN LIGHT BLUE HILL MEMORIAL HOSPITAL 57 WATER STREET BLUE HILL ME 4614 HANCOCK (207) 374-2836 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.4114200 -68.5862130 0   9 23 23009         https://data.medicare.gov/resource/xubh-q36u/row-ib5k-im2e_vk94 201300 645100 2019-02-28 2018-09-30 25           25               25
1140 1140 CALAIS REGIONAL HOSPITAL 24 HOSPITAL LANE CALAIS ME 4619 WASHINGTON (207) 454-7521 Critical Access Hospitals Voluntary non-profit - Private TRUE 45.1806390 -67.2705210 0   29 23 23029         https://data.medicare.gov/resource/xubh-q36u/row-dzvd-m85b~mjvj 201305 648833 2019-05-17 2018-12-31 25           25               25
1001 1001 REDINGTON FAIRVIEW GENERAL HOSPITAL 46 FAIRVIEW AVE PO BOX 468 SKOWHEGAN ME 4976 SOMERSET (207) 474-5121 Critical Access Hospitals Proprietary TRUE 44.7583360 -69.7134950 0   25 23 23025         https://data.medicare.gov/resource/xubh-q36u/row-g9mx~aw3n.5hnn 201314 661526 2019-12-02 2019-06-30 21 4         25               25
1002 1002 SEBASTICOOK VALLEY HEALTH 447 NORTH MAIN STREET PITTSFIELD ME 4967 SOMERSET (207) 487-5141 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.7908260 -69.3712690 0   25 23 23025         https://data.medicare.gov/resource/xubh-q36u/row-rjnr.evru~gjjd 201313 650156 2019-05-29 2018-09-30 25           25               25
176 176 CARY MEDICAL CENTER 163 VAN BUREN RD, SUITE 1 CARIBOU ME 4736 AROOSTOOK (207) 498-3111 Acute Care Hospitals Government - Local TRUE 46.8782370 -68.0096390 0   3 23 23003         https://data.medicare.gov/resource/xubh-q36u/row-3dpx.x267~9y3n 200031 650153 2019-05-31 2018-12-31 43 6         49               49
179 179 HOULTON REGIONAL HOSPITAL 20 HARTFORD STREET HOULTON ME 4730 AROOSTOOK (207) 532-2900 Critical Access Hospitals Voluntary non-profit - Private TRUE 46.1329620 -67.8426440 0   3 23 23003         https://data.medicare.gov/resource/xubh-q36u/row-tx6y-y4iu-nd9t 201308 645561 2019-03-04 2018-09-30 25           25               25
685 685 LINCOLN HEALTH 35 MILES STREET DAMARISCOTTA ME 4543 LINCOLN (207) 563-1234 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.0261990 -69.5271640 0   15 23 23015         https://data.medicare.gov/resource/xubh-q36u/row-mrex~j496-ppyw 201302 650479 2019-05-31 2018-12-31 21 4         25       42       67
901 901 MAYO REGIONAL HOSPITAL 897 WEST MAIN STREET DOVER FOXCROFT ME 4426 PISCATAQUIS (207) 564-4251 Critical Access Hospitals Government - Hospital District or Authority TRUE 45.1865560 -69.2377980 0   21 23 23021         https://data.medicare.gov/resource/xubh-q36u/row-zhbf-zz89~t9dz 201309 645562 2019-03-04 2018-09-30 25           25               25
439 439 NORTHERN LIGHT MAINE COAST HOSPITAL 50 UNION STREET ELLSWORTH ME 4605 HANCOCK (207) 667-5311 Acute Care Hospitals Voluntary non-profit - Other TRUE 44.5465740 -68.4155260 0   9 23 23009         https://data.medicare.gov/resource/xubh-q36u/row-4sb2~q3gq.pkmc 200050 651565 2019-06-26 2018-09-30 42 6         48               48
900 900 CHARLES A DEAN MEMORIAL HOSPITAL PO BOX 1129 GREENVILLE ME 4441 PISCATAQUIS (207) 695-5200 Critical Access Hospitals Voluntary non-profit - Private FALSE 45.4594923 -69.5906060 1 GEOMETRIC_CENTER 21 23 23021         https://data.medicare.gov/resource/xubh-q36u/row-e23p-cjiz~ui3t 201301 650155 2019-06-21 2018-09-30 25           25               25
743 743 STEPHENS MEMORIAL HOSPITAL 181 MAIN STREET NORWAY ME 4268 OXFORD (207) 743-5933 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.2095390 -70.5329780 0   17 23 23017         https://data.medicare.gov/resource/xubh-q36u/row-sfne.bccg~sezn 201315 650826 2019-06-28 2018-12-31 21 4         25               25
178 178 NORTHERN LIGHT A R GOULD HOSPITAL PO BOX 151 PRESQUE ISLE ME 4769 AROOSTOOK (207) 768-4000 Acute Care Hospitals Voluntary non-profit - Private TRUE 46.6751494 -67.9985861 1 ROOFTOP 3 23 23003         https://data.medicare.gov/resource/xubh-q36u/row-ihck.jhth~929r 200018 650152 2019-05-29 2018-09-30 43 6         49   5   14 50     118
357 357 FRANKLIN MEMORIAL HOSPITAL 111 FRANKLIN HEALTH COMMONS FARMINGTON ME 4938 FRANKLIN (207) 778-6031 Acute Care Hospitals Voluntary non-profit - Private TRUE 44.6251150 -70.1612440 0   7 23 23007         https://data.medicare.gov/resource/xubh-q36u/row-5fiv_edxs-8b6w 200037 650477 2019-05-31 2018-12-31 43 5         48               48
177 177 NORTHERN MAINE MEDICAL CENTER 194 E MAIN STREET FORT KENT ME 4743 AROOSTOOK (207) 834-3195 Acute Care Hospitals Voluntary non-profit - Private TRUE 47.2650680 -68.5911770 0   3 23 23003         https://data.medicare.gov/resource/xubh-q36u/row-cr45-cm3b-wfye 200052 645099 2019-02-28 2018-09-30 43           43 6     45       94
608 608 PENOBSCOT BAY MEDICAL CENTER 6 GLEN COVE DRIVE ROCKPORT ME 4856 KNOX (207) 921-8000 Acute Care Hospitals Voluntary non-profit - Private TRUE 44.1444340 -69.0865370 0   13 23 23013         https://data.medicare.gov/resource/xubh-q36u/row-ahvj_huyh~m44w 200063 650478 2019-05-31 2018-12-31 73 8         81       84       165
2602 2602 POWER COUNTY HOSPITAL DISTRICT 510 ROOSEVELT STREET AMERICAN FALLS ID 83211 POWER (208) 226-3200 Critical Access Hospitals Government - Hospital District or Authority TRUE 42.7818580 -112.8490470 0   77 16 16077         https://data.medicare.gov/resource/xubh-q36u/row-jqyn~uieu.hqrg 131304 645328 2019-03-20 2018-09-30 10           10       16       26
428 428 BENEWAH COMMUNITY HOSPITAL 229 SOUTH 7TH STREET ST MARIES ID 83861 BENEWAH (208) 245-5551 Critical Access Hospitals Government - Local TRUE 47.3146130 -116.5666780 0   9 16 16009         https://data.medicare.gov/resource/xubh-q36u/row-3wfv~5stn~5t7d 131317 652074 2019-05-24 2018-12-31 19           19               19
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
2767 2767 CASCADE MEDICAL CENTER 402 LAKE CASCADE PARKWAY CASCADE ID 83611 VALLEY (208) 382-4242 Critical Access Hospitals Government - Hospital District or Authority TRUE 44.5179210 -116.0489380 0   85 16 16085         https://data.medicare.gov/resource/xubh-q36u/row-8r6g.s3au-3yid 131308 644833 2019-03-04 2018-09-30 8           8               8
1386 1386 CLEARWATER VALLEY HOSPITAL & CLINICS 301 CEDAR STREET OROFINO ID 83544 CLEARWATER (208) 476-4555 Critical Access Hospitals Voluntary non-profit - Private TRUE 46.4873150 -116.2599160 0   35 16 16035         https://data.medicare.gov/resource/xubh-q36u/row-4jwp-mz4f-k7tn 131320 659779 2019-11-26 2019-06-30 23           23               23
1134 1134 CARIBOU MEMORIAL HOSPITAL 300 SOUTH 3RD WEST SODA SPRINGS ID 83276 CARIBOU (208) 547-3341 Critical Access Hospitals Government - Local TRUE 42.6522350 -111.6133540 0   29 16 16029         https://data.medicare.gov/resource/xubh-q36u/row-k69a-4kn6-dfne 131309 644028 2019-02-28 2018-09-30 25           25       30       55
2853 2853 WEISER MEMORIAL HOSPITAL 645 EAST 5TH STREET WEISER ID 83672 WASHINGTON (208) 549-0370 Critical Access Hospitals Government - Hospital District or Authority TRUE 44.2487610 -116.9617350 0   87 16 16087         https://data.medicare.gov/resource/xubh-q36u/row-e9wf-9jnf_cbd3 131307 655768 2019-11-01 2019-06-30 19           19               19
2163 2163 ST LUKE'S MCCALL 1000 STATE STREET BURGDORF ID 83638 VALLEY (208) 630-2395 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.9093540 -116.1097030 0   85 16 16085         https://data.medicare.gov/resource/xubh-q36u/row-au7a~xb54-snfz 131312 651560 2019-06-21 2018-09-30 15           15               15
2135 2135 STEELE MEMORIAL MEDICAL CENTER 203 SOUTH DAISY STREET SALMON ID 83467 LEMHI (208) 756-5600 Critical Access Hospitals Government - Local TRUE 45.1733110 -113.8909180 0   59 16 16059         https://data.medicare.gov/resource/xubh-q36u/row-frkw_jutq_kwk4 131305 645073 2019-03-05 2018-09-30 18           18               18
2320 2320 NELL J REDFIELD MEMORIAL HOSPITAL 150 NORTH 200 WEST MALAD ID 83252 ONEIDA (208) 766-2231 Critical Access Hospitals Government - Local TRUE 42.1896380 -112.2507590 0   71 16 16071         https://data.medicare.gov/resource/xubh-q36u/row-dtun.jgpu~2hmu 131303 662195 2019-11-26 2019-06-30 11           11       33       44
2642 2642 SHOSHONE MEDICAL CENTER 25 JACOBS GULCH ROAD KELLOGG ID 83837 SHOSHONE (208) 784-1221 Critical Access Hospitals Government - Hospital District or Authority TRUE 47.5471230 -116.1314090 0   79 16 16079         https://data.medicare.gov/resource/xubh-q36u/row-5s2d-murc_kv83 131314 647887 2019-05-02 2018-11-30 21           21               21
352 352 BEAR LAKE MEMORIAL HOSPITAL 164 SOUTH FIFTH STREET MONTPELIER ID 83254 BEAR LAKE (208) 847-1630 Critical Access Hospitals Government - Local TRUE 42.3162420 -111.3008470 0   7 16 16007         https://data.medicare.gov/resource/xubh-q36u/row-mggi-9epd.588z 131316 647888 2019-05-16 2018-12-31 21           21       36   32   89
1777 1777 NORTH CANYON MEDICAL CENTER 267 NORTH CANYON DR GOODING ID 83330 GOODING (208) 934-4433 Critical Access Hospitals Voluntary non-profit - Private FALSE 42.9218690 -114.7111280 0   47 16 16047         https://data.medicare.gov/resource/xubh-q36u/row-dagw~rfa6-2dqe 131302 642945 2019-02-06 2018-09-30 16           16               16
1833 1833 ST MARY'S HOSPITAL 701 LEWISTON ST COTTONWOOD ID 83522 IDAHO (208) 962-3251 Critical Access Hospitals Voluntary non-profit - Private TRUE 46.0503710 -116.3516450 0   49 16 16049         https://data.medicare.gov/resource/xubh-q36u/row-u7zv_7y6z_xg8a 131321 661307 2019-11-26 2019-06-30 25           25               25
1832 1832 SYRINGA GENERAL HOSPITAL 607 W MAIN STREET GRANGEVILLE ID 83530 IDAHO (208) 983-1700 Critical Access Hospitals Government - Hospital District or Authority TRUE 45.9267890 -116.1269940 0   49 16 16049         https://data.medicare.gov/resource/xubh-q36u/row-9the-4kgt.urhi 131315 642946 2019-02-08 2018-09-30 15           15               15
259 259 SUTTER AMADOR HOSPITAL 200 MISSION BLVD JACKSON CA 95642 AMADOR (209) 223-7500 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.3495610 -120.7659050 0   5 6 6005         https://data.medicare.gov/resource/xubh-q36u/row-s5bi-egin.834t 50014 650640 2019-06-03 2018-12-31 46 6         52               52
406 406 MARK TWAIN MEDICAL CENTER 768 MOUNTAIN RANCH RD SAN ANDREAS CA 95249 CALAVERAS (209) 754-2515 Critical Access Hospitals Voluntary non-profit - Other FALSE 38.1909730 -120.6706610 0   9 6 6009         https://data.medicare.gov/resource/xubh-q36u/row-vzvr.d5an~vpec 51332 660493 2019-12-03 2019-06-30 25           25               25
1682 1682 JOHN C FREMONT HEALTHCARE DISTRICT 5189 HOSPITAL ROAD MARIPOSA CA 95338 MARIPOSA (209) 966-3631 Critical Access Hospitals Government - Hospital District or Authority TRUE 37.5005310 -119.9769480 0   43 6 6043         https://data.medicare.gov/resource/xubh-q36u/row-fty8~tgqe.f5tj 51304 661465 2019-12-02 2019-06-30 18           18       16   1   35
4012 4012 ILLINI COMMUNITY HOSPITAL 640 W WASHINGTON PITTSFIELD IL 62363 PIKE (217) 285-2113 Critical Access Hospitals Voluntary non-profit - Private TRUE 39.6067930 -90.8150550 0   149 17 17149         https://data.medicare.gov/resource/xubh-q36u/row-pujp_q5tr_5y4p 141315 645075 2019-02-28 2018-09-30 25           25 10             35
4217 4217 SARAH D CULBERTSON MEMORIAL HOSPITAL 238 SOUTH CONGRESS STREET RUSHVILLE IL 62681 SCHUYLER (217) 322-4321 Critical Access Hospitals Government - Hospital District or Authority TRUE 40.1179440 -90.5635870 0   169 17 17169         https://data.medicare.gov/resource/xubh-q36u/row-bfu9.4ehe.ppey 141333 652646 2019-07-26 2019-02-28 22           22               22
3851 3851 ST FRANCIS HOSPITAL 1215 FRANCISCAN DR LITCHFIELD IL 62056 MONTGOMERY (217) 324-2191 Critical Access Hospitals Voluntary non-profit - Church TRUE 39.1808100 -89.6396360 0   135 17 17135         https://data.medicare.gov/resource/xubh-q36u/row-jacr~k2cc_qv6a 141350 660527 2019-11-27 2019-06-30 25           25               25
1732 1732 PARIS COMMUNITY HOSPITAL 721 E COURT STREET PARIS IL 61944 EDGAR (217) 465-4141 Critical Access Hospitals Voluntary non-profit - Private TRUE 39.6067120 -87.6783110 0   45 17 17045         https://data.medicare.gov/resource/xubh-q36u/row-vi85_kv7j_pcxz 141320 649726 2019-05-30 2018-12-31 25           25               25
3852 3852 HILLSBORO AREA HOSPITAL 1200 E TREMONT STREET HILLSBORO IL 62049 MONTGOMERY (217) 532-6111 Critical Access Hospitals Voluntary non-profit - Private TRUE 39.1536720 -89.4815080 0   135 17 17135         https://data.medicare.gov/resource/xubh-q36u/row-hr8s~ac96_26fy 141332 659949 2019-11-25 2019-06-30 25           25               25
4244 4244 HSHS GOOD SHEPHERD HOSPITAL INC 200 S CEDAR ST SHELBYVILLE IL 62565 SHELBY (217) 774-3961 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.4058010 -88.8071130 0   173 17 17173         https://data.medicare.gov/resource/xubh-q36u/row-rw3c-7r3v.5ma9 140019 660512 2019-11-27 2019-06-30 30           30               30
2105 2105 THOMAS H BOYD MEMORIAL HOSPITAL 800 SCHOOL ST CARROLLTON IL 62016 GREENE (217) 942-6946 Critical Access Hospitals Voluntary non-profit - Private TRUE 39.2961700 -90.4123030 0   61 17 17061         https://data.medicare.gov/resource/xubh-q36u/row-vab7-2ww3-xwdi 141300 642094 2019-01-30 2018-08-31 25           25               25
2194 2194 DEER RIVER HEALTHCARE CENTER 115 10TH AVENUE NORTHEAST DEER RIVER MN 56636 ITASCA (218) 246-2900 Critical Access Hospitals Voluntary non-profit - Private TRUE 47.3435030 -93.7912990 0   61 27 27061         https://data.medicare.gov/resource/xubh-q36u/row-run4_u2tc_i8qs 241360 660613 2019-11-26 2019-06-30 20           20       32       52
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
2193 2193 GRAND ITASCA CLINIC AND HOSPITAL 1601 GOLF COURSE ROAD GRAND RAPIDS MN 55744 ITASCA (218) 326-3401 Acute Care Hospitals Voluntary non-profit - Private TRUE 47.2210390 -93.5547160 0   61 27 27061         https://data.medicare.gov/resource/xubh-q36u/row-2qrv~rfjc~89wf 240064 650497 2019-05-31 2018-12-31 27   9       36               36
9 9 NORTH SHORE HEALTH 515 5TH AVE WEST GRAND MARAIS MN 55604 COOK (218) 387-3040 Critical Access Hospitals Government - Hospital District or Authority TRUE 47.7567440 -90.3401790 0   31 27 27031         https://data.medicare.gov/resource/xubh-q36u/row-kcfv-qat3~9wit 241317 649272 2019-05-28 2018-12-31 16           16       37       53
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
4124 4124 TRI COUNTY HOSPITAL 415 JEFFERSON STREET NORTH WADENA MN 56482 WADENA (218) 631-3510 Critical Access Hospitals Voluntary non-profit - Other TRUE 46.4465650 -95.1327480 0   159 27 27159         https://data.medicare.gov/resource/xubh-q36u/row-3n5a.vgrx-wtuu 241354 659301 2019-11-05 2018-12-31 23 2         25               25
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
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
1908 1908 PRAIRIE RIDGE HOSPITAL AND HEALTH SERVICES 1411 HIGHWAY 793 E ELBOW LAKE MN 56531 GRANT (218) 685-7300 Critical Access Hospitals Voluntary non-profit - Private TRUE 45.9908032 -95.9578947 1 ROOFTOP 51 27 27051         https://data.medicare.gov/resource/xubh-q36u/row-is3f.7a5b~t9ju 241379 644131 2019-02-28 2018-09-30 10           10               10
1143 1143 SANFORD BAGLEY MEDICAL CENTER 203 4TH STREET NORTHWEST BAGLEY MN 56621 CLEARWATER (218) 694-6501 Critical Access Hospitals Voluntary non-profit - Private TRUE 47.5258370 -95.4016760 0   29 27 27029         https://data.medicare.gov/resource/xubh-q36u/row-n7dg.2zvq~dkw4 241328 649453 2019-05-22 2018-12-31 25           25               25
2074 2074 ST JOSEPHS AREA HEALTH SERVICES 600 PLEASANT AVENUE PARK RAPIDS MN 56470 HUBBARD (218) 732-3311 Critical Access Hospitals Voluntary non-profit - Private TRUE 46.9157000 -95.0615040 0   57 27 27057         https://data.medicare.gov/resource/xubh-q36u/row-486s_44m7-qhbs 241380 662390 2019-12-09 2019-06-30 25           25               25
2192 2192 BIGFORK VALLEY HOSPITAL 258 PINE TREE DRIVE PO BOX 258 BIGFORK MN 56628 ITASCA (218) 743-3177 Critical Access Hospitals Government - Hospital District or Authority TRUE 47.7468850 -93.6468220 0   61 27 27061         https://data.medicare.gov/resource/xubh-q36u/row-356c-64uf.kf5r 241316 650718 2019-05-31 2018-12-31 20           20       47       67
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
25 25 ESSENTIA HEALTH ADA 201 9TH STREET WEST ADA MN 56510 NORMAN (218) 784-5000 Critical Access Hospitals Voluntary non-profit - Private TRUE 47.2960910 -96.5301900 0   107 27 27107         https://data.medicare.gov/resource/xubh-q36u/row-z63y_de5x~9s9u 241313 660607 2019-11-26 2019-06-30 14           14               14
2574 2574 LAKE VIEW MEMORIAL HOSPITAL 325 ELEVENTH AVE TWO HARBORS MN 55616 LAKE (218) 834-7300 Critical Access Hospitals Voluntary non-profit - Private TRUE 47.0296500 -91.6671570 0   75 27 27075         https://data.medicare.gov/resource/xubh-q36u/row-rhaa_cegt~vewc 241308 647902 2019-05-14 2018-12-31 16           16               16
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
291 291 ESSENTIA HEALTH ST MARYS - DETROIT LAKES 1027 WASHINGTON AVE DETROIT LAKES MN 56501 BECKER (218) 847-0888 Acute Care Hospitals Voluntary non-profit - Church FALSE 46.8153070 -95.8454530 0   5 27 27005         https://data.medicare.gov/resource/xubh-q36u/row-my2b~zwif~njdr 240101 660605 2019-11-26 2019-06-30 28 8         36       96       132
4059 4059 LAKEWOOD HEALTH SYSTEM 49725 COUNTY ROAD 83 STAPLES MN 56479 TODD (218) 894-1515 Critical Access Hospitals Voluntary non-profit - Other TRUE 46.3508690 -94.7483930 0   153 27 27153         https://data.medicare.gov/resource/xubh-q36u/row-vn9e~m7ke-5ysu 241329 650720 2019-05-30 2018-12-31 22 3         25 10     100       135
98 98 RIVERWOOD HEALTHCARE CENTER 200 BUNKER HILL DRIVE AITKIN MN 56431 AITKIN (218) 927-5501 Critical Access Hospitals Voluntary non-profit - Private TRUE 46.5292020 -93.6968080 0   1 27 27001         https://data.medicare.gov/resource/xubh-q36u/row-ybgp~gnb5~d4ww 241305 655456 2019-10-08 2018-09-30 21 4         25               25
2860 2860 MAHNOMEN HEALTH CENTER 414 W JEFFERSON PO BOX 396 MAHNOMEN MN 56557 MAHNOMEN (218) 935-2511 Critical Access Hospitals Government - Local TRUE 47.3117925 -95.9729278 1 ROOFTOP 87 27 27087         https://data.medicare.gov/resource/xubh-q36u/row-hmyn_2dwh_mr9t 241300 651009 2019-06-04 2018-12-31 10           10       32       42
4447 4447 MITCHELL COUNTY HOSPITAL 90 STEPHENS STREET CAMILLA GA 31730 MITCHELL (229) 336-5284 Critical Access Hospitals Government - Hospital District or Authority TRUE 31.2292770 -84.2050910 0   205 13 13205         https://data.medicare.gov/resource/xubh-q36u/row-wyam-jqj8.gyct 111331 644025 2019-02-25 2018-09-30 25           25       156       181
3803 3803 GRADY GENERAL HOSPITAL 1155 5TH STREET, SE CAIRO GA 39828 GRADY (229) 377-0251 Acute Care Hospitals Voluntary non-profit - Private TRUE 30.8633930 -84.2002610 0   131 13 13131         https://data.medicare.gov/resource/xubh-q36u/row-axxf.dqez-4s36 110121 644023 2019-02-25 2018-09-30 42 4         46               46
4074 4074 IRWIN COUNTY HOSPITAL 710 N IRWIN AVENUE OCILLA GA 31774 IRWIN (229) 468-3845 Acute Care Hospitals Government - Hospital District or Authority FALSE 31.6027970 -83.2503310 0   155 13 13155         https://data.medicare.gov/resource/xubh-q36u/row-x4wh~4hz8~nrk6 110130 647117 2019-04-30 2018-11-30 34           34       30       64
4522 4522 DONALSONVILLE HOSPITAL INC 102 HOSPITAL CIR DONALSONVILLE GA 39845 SEMINOLE (229) 524-5217 Acute Care Hospitals Voluntary non-profit - Private TRUE 31.0507070 -84.8801230 0   253 13 13253         https://data.medicare.gov/resource/xubh-q36u/row-nrim~ztp2.rnen 110194 659233 2019-11-21 2019-06-30 45           45 20     75       140
4 4 SGMC BERRIEN CAMPUS 1221 E MCPHERSON AVENUE NASHVILLE GA 31639 BERRIEN (229) 543-7100 Acute Care Hospitals Government - Hospital District or Authority TRUE 31.2036290 -83.2383370 0   19 13 13019         https://data.medicare.gov/resource/xubh-q36u/row-nuhh.ufkh.cshr 110234 644717 2019-03-01 2018-09-30 51           51 12             63
3151 3151 LIFEBRITE COMMUNITY HOSPITAL OF EARLY 11740 COLUMBIA STREET BLAKELY GA 39823 EARLY (229) 723-4241 Critical Access Hospitals Voluntary non-profit - Private TRUE 31.3743820 -84.9462450 0   99 13 13099         https://data.medicare.gov/resource/xubh-q36u/row-x8g6~hmy4~rqqp 111314 646292 2019-04-01 2018-09-30 15           15       127       142
4510 4510 SOUTHWEST GEORGIA REGIONAL MEDICAL CENTER 361 RANDOLPH STREET CUTHBERT GA 39840 RANDOLPH (229) 732-2181 Critical Access Hospitals Government - Hospital District or Authority TRUE 31.7748230 -84.7936060 0   243 13 13243         https://data.medicare.gov/resource/xubh-q36u/row-9bkz.mqd7-hbvn 111300 641801 2019-01-02 2018-07-31 25           25       80       105
4400 4400 MILLER COUNTY HOSPITAL 209 N CUTHBERT STREET COLQUITT GA 39837 MILLER (229) 758-4231 Critical Access Hospitals Government - Hospital District or Authority TRUE 31.1754800 -84.7345480 0   201 13 13201         https://data.medicare.gov/resource/xubh-q36u/row-9k3y-ss2d~tagp 111305 659030 2019-11-20 2019-06-30 25           25       131       156
2568 2568 SOUTHWELL MEDICAL, A CAMPUS OF TRMC 260 MJ TAYLOR ROAD ADEL GA 31620 COOK (229) 896-8077 Acute Care Hospitals Proprietary TRUE 31.1091810 -83.4263720 0   75 13 13075         https://data.medicare.gov/resource/xubh-q36u/row-9kgg_7cj7~n9m2 110101 660504 2019-12-03 2019-06-30 33           33 12     95       140
3206 3206 MUNSON HEALTHCARE MANISTEE HOSPITAL 1465 E PARKDALE AVE MANISTEE MI 49660 MANISTEE (231) 398-1000 Acute Care Hospitals Voluntary non-profit - Other TRUE 44.2723550 -86.2734390 0   101 26 26101         https://data.medicare.gov/resource/xubh-q36u/row-yvaj-xucr.6ih7 230303 660597 2019-11-27 2019-06-30 45           45               45
1783 1783 MCLAREN NORTHERN MICHIGAN 416 CONNABLE AVE PETOSKEY MI 49770 EMMET (231) 487-4000 Acute Care Hospitals Voluntary non-profit - Other TRUE 45.3734770 -84.9691520 0   47 26 26047         https://data.medicare.gov/resource/xubh-q36u/row-fcnu-j4f4.fztp 230105 648840 2019-05-28 2018-09-30 129 18 40       187   15           202
1142 1142 MUNSON HEALTHCARE CHARLEVOIX HOSPITAL 14700 LAKESHORE DRIVE CHARLEVOIX MI 49720 CHARLEVOIX (231) 547-4024 Critical Access Hospitals Voluntary non-profit - Other TRUE 45.3144980 -85.2748510 1 ROOFTOP 29 26 26029         https://data.medicare.gov/resource/xubh-q36u/row-cdsd.f9cx_c7j8 231322 660601 2019-11-27 2019-06-30 25           25               25
3830 3830 SPECTRUM HEALTH REED CITY HOSPITAL 300 N PATTERSON, PO BOX 75 REED CITY MI 49677 OSCEOLA (231) 832-3271 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.8782450 -85.5211907 1 ROOFTOP 133 26 26133         https://data.medicare.gov/resource/xubh-q36u/row-hhgy~8j82.d9qv 231323 660106 2019-11-25 2019-06-30 21 4         25       50       75
3751 3751 MERCY HEALTH LAKESHORE CAMPUS 72 SOUTH STATE STREET SHELBY MI 49455 OCEANA (231) 861-2156 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.6070530 -86.3651500 0   127 26 26127         https://data.medicare.gov/resource/xubh-q36u/row-4je3~28uk~h2y8 231320 661203 2019-12-03 2019-06-30 24           24               24
3679 3679 SPECTRUM HEALTH GERBER MEMORIAL 212 S SULLIVAN ST FREMONT MI 49412 NEWAYGO (231) 924-3300 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.4643830 -85.9507630 0   123 26 26123         https://data.medicare.gov/resource/xubh-q36u/row-hx3e~pnt6_cpqb 231338 659581 2019-11-22 2019-06-30 16 9         25               25
989 989 JACKSON MEDICAL CENTER 220 HOSPITAL DRIVE JACKSON AL 36545 CLARKE (251) 246-9021 Acute Care Hospitals Proprietary TRUE 31.5304820 -87.8931800 0   25 1 1025         https://data.medicare.gov/resource/xubh-q36u/row-p276~rdhi_nmej 10128 651157 2019-06-03 2018-12-31 35           35               35
990 990 GROVE HILL MEMORIAL HOSPITAL 295 JACKSON HWY S GROVE HILL AL 36451 CLARKE (251) 275-3191 Acute Care Hospitals Government - Hospital District or Authority TRUE 31.6942130 -87.7772310 0   25 1 1025         https://data.medicare.gov/resource/xubh-q36u/row-qwpn-mu4j-e76s 10091 660905 2019-12-04 2019-06-30 21           21 9             30
1939 1939 ATMORE COMMUNITY HOSPITAL 401 MEDICAL PARK DRIVE ATMORE AL 36502 ESCAMBIA (251) 368-2500 Acute Care Hospitals Government - Hospital District or Authority TRUE 31.0165700 -87.4797350 0   53 1 1053         https://data.medicare.gov/resource/xubh-q36u/row-nw85.p2jc-cva6 10169 645521 2019-02-28 2018-09-30 43 6         49               49
3132 3132 MONROE COUNTY HOSPITAL 2016 SOUTH ALABAMA AVENUE MONROEVILLE AL 36460 MONROE (251) 575-3111 Acute Care Hospitals Government - Local TRUE 31.4978390 -87.3194110 0   99 1 1099         https://data.medicare.gov/resource/xubh-q36u/row-4wyz~k8fh_i5ug 10120 645040 2019-03-13 2018-09-30 41 8         49               49
1377 1377 EVERGREEN MEDICAL CENTER 101 CRESTVIEW AVENUE EVERGREEN AL 36401 CONECUH (251) 578-2480 Acute Care Hospitals Proprietary TRUE 31.4312600 -86.9420500 0   35 1 1035         https://data.medicare.gov/resource/xubh-q36u/row-f8ut-az4v~dn63 10148 651159 2019-06-03 2018-12-31 44           44               44
3782 3782 WASHINGTON COUNTY HOSPITAL 14600 ST. STEPHENS AVENUE CHATOM AL 36518 WASHINGTON (251) 847-2223 Critical Access Hospitals Government - Hospital District or Authority TRUE 31.4602960 -88.2352910 0   129 1 1129         https://data.medicare.gov/resource/xubh-q36u/row-kzeh_fuyx-rvjh 11300 644204 2019-03-01 2018-09-30 15           15       88       103
1938 1938 D W MCMILLAN MEMORIAL HOSPITAL 1301 BELLEVILLE AVENUE BREWTON AL 36426 ESCAMBIA (251) 867-8061 Acute Care Hospitals Government - Hospital District or Authority TRUE 31.1271050 -87.0723780 0   53 1 1053         https://data.medicare.gov/resource/xubh-q36u/row-ug8v.qapr~xntq 10099 644201 2019-03-01 2018-09-30 38 8         46               46
2964 2964 VIDANT ROANOKE CHOWAN HOSPITAL 500 S ACADEMY ST AHOSKIE NC 27910 HERTFORD (252) 209-3000 Acute Care Hospitals Voluntary non-profit - Private TRUE 36.2851490 -76.9939240 0   91 37 37091         https://data.medicare.gov/resource/xubh-q36u/row-n5pq~6e8d.jjva 340099 643925 2019-02-28 2018-09-30 60 10         70 28             98
1658 1658 VIDANT CHOWAN HOSPITAL 211 VIRGINIA RD EDENTON NC 27932 CHOWAN (252) 482-8451 Critical Access Hospitals Government - Local TRUE 36.0707740 -76.6090930 0   41 37 37041         https://data.medicare.gov/resource/xubh-q36u/row-trbd~xc39_h8ri 341318 644158 2019-02-28 2018-09-30 21 4         25               25
4340 4340 WASHINGTON COUNTY HOSP INC 958 US HWY 64 EAST PLYMOUTH NC 27962 WASHINGTON (252) 793-4135 Critical Access Hospitals Proprietary TRUE 35.8479840 -76.7558380 0   187 37 37187         https://data.medicare.gov/resource/xubh-q36u/row-x8x8-fegi-en3k 341314 640726 2019-01-02 2018-09-30 25           25               25
704 704 VIDANT BERTIE HOSPITAL 1403 SOUTH KINGS STREET WINDSOR NC 27983 BERTIE (252) 794-6600 Critical Access Hospitals Voluntary non-profit - Private TRUE 35.9893550 -76.9281830 0   15 37 37015         https://data.medicare.gov/resource/xubh-q36u/row-pwdr-dt5d-exsb 341304 644156 2019-02-28 2018-09-30 6           6               6
3565 3565 MARTIN GENERAL HOSPITAL 310 S MCCASKEY RD P O BOX 1128 WILLIAMSTON NC 27892 MARTIN (252) 809-6179 Acute Care Hospitals Government - Local TRUE 35.8404770 -77.0711780 0   117 37 37117         https://data.medicare.gov/resource/xubh-q36u/row-6ty4.gevs-5eff 340133 654859 2019-09-25 2019-04-30 37 6         43               43
4374 4374 HAMILTON GENERAL HOSPITAL 400 N BROWN, BUILDING 1 HAMILTON TX 76531 HAMILTON (254) 386-3151 Critical Access Hospitals Government - Hospital District or Authority TRUE 31.7038520 -98.1134620 0   193 48 48193         https://data.medicare.gov/resource/xubh-q36u/row-u9ir-x2hd-6nbs                                      

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