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

318 rows where hospital_ownership = "Voluntary non-profit - Church" sorted by csatitle

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: hospital_type, emergency_services, geocode_flag, geocode_accuracy, centraloutlyingcounty, fy_end_date, coronary_beds, burn_beds, surg_icu_beds, oth_spec_beds, subprovider_oth_beds, nursing_fac_beds, oth_longterm_beds, filed_date (date), fy_end_date (date)

hospital_ownership ✖

  • Voluntary non-profit - Church · 318 ✖
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
15 15 GARRISON MEMORIAL HOSPITAL 407 3RD AVE SE GARRISON ND 58540 MCLEAN (701) 463-2275 Critical Access Hospitals Voluntary non-profit - Church TRUE 47.6483420 -101.4113010 0   55 38 38055         https://data.medicare.gov/resource/xubh-q36u/row-e4ej.ybr6_ritz 351303 640250 2018-12-03 2018-06-30 22           22       28       50
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
161 161 ADVENTIST HEALTH CASTLE 640 ULUKAHIKI ST KAILUA HI 96734 HONOLULU (808) 263-5500 Acute Care Hospitals Voluntary non-profit - Church TRUE 21.3815020 -157.7572290 0   3 15 15003 46520   Central Honolulu County https://data.medicare.gov/resource/xubh-q36u/row-5zcn.p8qz~eqqf 120006 655891 2019-10-07 2018-12-31 152 8         160               160
218 218 CHI MERCY HEALTH 570 CHAUTAUQUA BLVD VALLEY CITY ND 58072 BARNES (701) 845-6400 Critical Access Hospitals Voluntary non-profit - Church TRUE 46.9284920 -97.9949080 0   3 38 38003         https://data.medicare.gov/resource/xubh-q36u/row-pmhy~szku-z7nc 351324 662240 2019-11-26 2019-06-30 25           25               25
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
341 341 MERCY HOSPITAL NORTHWEST ARKANSAS 2710 SOUTH RIFE MEDICAL LANE ROGERS AR 72758 BENTON (479) 338-8000 Acute Care Hospitals Voluntary non-profit - Church TRUE 36.3095620 -94.1847090 0   7 5 5007 22220   Central Benton County https://data.medicare.gov/resource/xubh-q36u/row-3g3b-cs9n_qbhj 40010 660742 2019-12-04 2019-06-30 174 24         206               206
342 342 ADVENTIST HEALTH FEATHER RIVER 5974 PENTZ ROAD PARADISE CA 95969 BUTTE (530) 877-9361 Acute Care Hospitals Voluntary non-profit - Church TRUE 39.7561610 -121.5723050 0   7 6 6007 17020   Central Butte County https://data.medicare.gov/resource/xubh-q36u/row-dx3c~3bgg.9vjq 50225 659201 2019-05-31 2018-12-31                              
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
447 447 MERCY HOSPITAL CASSVILLE 94 MAIN STREET CASSVILLE MO 65625 BARRY (417) 847-6065 Critical Access Hospitals Voluntary non-profit - Church TRUE 36.6740770 -93.8718860 0   9 29 29009         https://data.medicare.gov/resource/xubh-q36u/row-wswc_mpwv.fwbj 261317 660251 2019-11-26 2019-06-30 18           18               18
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
509 509 ASCENSION STANDISH HOSPITAL 805 W CEDAR ST STANDISH MI 48658 ARENAC (517) 846-4521 Critical Access Hospitals Voluntary non-profit - Church TRUE 43.9828300 -83.9693520 0   11 26 26011         https://data.medicare.gov/resource/xubh-q36u/row-3a56-bznt.bz29 231305 639965 2018-12-12 2018-06-30 20 5         25       29       54
561 561 MERCY GILBERT MEDICAL CENTER 3555 SOUTH VAL VISTA DRIVE GILBERT AZ 85297 MARICOPA (480) 728-8000 Acute Care Hospitals Voluntary non-profit - Church TRUE 33.2866610 -111.7553110 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-ab5w_8jiw.5ys7 30119 662011 2019-12-03 2019-06-30 174 24         198               198
568 568 ST. JOSEPH'S HOSPITAL AND MEDICAL CENTER 350 WEST THOMAS ROAD PHOENIX AZ 85013 MARICOPA (602) 406-5001 Acute Care Hospitals Voluntary non-profit - Church TRUE 33.4802940 -112.0792080 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-kyrc_3hbc_et9k 30024 658638 2019-10-10 2018-06-30 268   24   32   460   52           512
602 602 MERCYONE WATERLOO MEDICAL CENTER 3421 WEST NINTH STREET WATERLOO IA 50702 BLACK HAWK (319) 272-8000 Acute Care Hospitals Voluntary non-profit - Church TRUE 42.4638670 -92.3457870 0   13 19 19013 47940   Central Black Hawk County https://data.medicare.gov/resource/xubh-q36u/row-9tqu-dd6x-rvxf 160067 659672 2019-11-21 2019-06-30 150 12         162   25           187
603 603 MERCYONE CEDAR FALLS MEDICAL CENTER 515 COLLEGE STREET CEDAR FALLS IA 50613 BLACK HAWK (319) 268-3000 Acute Care Hospitals Voluntary non-profit - Church TRUE 42.5339220 -92.4559690 0   13 19 19013 47940   Central Black Hawk County https://data.medicare.gov/resource/xubh-q36u/row-i7k6_5bd5-4g6c 160040 659566 2019-11-14 2019-06-30 30 5         35 15             50
650 650 AVERA ST LUKES 305 S STATE ST POST OFFICE BOX 4450 ABERDEEN SD 57401 BROWN (605) 622-5000 Acute Care Hospitals Voluntary non-profit - Church TRUE 45.4617950 -98.4793500 0   13 46 46013 10100   Central Brown County https://data.medicare.gov/resource/xubh-q36u/row-pruy~fuxf-c6av 430014 662254 2019-11-27 2019-06-30 43 6         49 10     81 56     196
672 672 MERCY HOSPITAL BERRYVILLE 214 CARTER STREET BERRYVILLE AR 72616 CARROLL (870) 423-3355 Critical Access Hospitals Voluntary non-profit - Church TRUE 36.3582250 -93.5519930 0   15 5 5015         https://data.medicare.gov/resource/xubh-q36u/row-dj6g_rn37~rqpp 41329 659917 2019-12-04 2019-06-30 25           25               25
705 705 CHI ST ALEXIUS HEALTH 900 E BROADWAY BISMARCK ND 58501 BURLEIGH (701) 530-7000 Acute Care Hospitals Voluntary non-profit - Church TRUE 46.8063690 -100.7770750 0   15 38 38015 13900   Central Burleigh County https://data.medicare.gov/resource/xubh-q36u/row-i4ue-xmjd.qmkx 350002 662065 2019-12-03 2019-06-30 142 39         181 25     19       225
822 822 OSF HEART OF MARY MEDICAL CENTER 1400 WEST PARK AVENUE URBANA IL 61801 CHAMPAIGN (217) 337-2000 Acute Care Hospitals Voluntary non-profit - Church TRUE 40.1173910 -88.2271230 0   19 17 17019 16580   Central Champaign County https://data.medicare.gov/resource/xubh-q36u/row-mvbr_gjxz-rw36 140113 645247 2019-03-01 2018-09-30 156 13         169   25           194
834 834 ST JOSEPH HOSPITAL 360 BROADWAY BANGOR ME 4401 PENOBSCOT (207) 262-1000 Acute Care Hospitals Voluntary non-profit - Church TRUE 44.8145300 -68.7712600 0   19 23 23019 12620   Central Penobscot County https://data.medicare.gov/resource/xubh-q36u/row-ad3u-g4s7-xxty 200001 650700 2019-06-03 2018-12-31 92 7         99               99
843 843 CHI HEALTH GOOD SAMARITAN P O BOX 1990, 10 EAST 31ST ST KEARNEY NE 68848 BUFFALO (308) 865-7100 Acute Care Hospitals Voluntary non-profit - Church TRUE 40.7076254 -99.0818136 1 ROOFTOP 19 31 31019 28260   Central Buffalo County https://data.medicare.gov/resource/xubh-q36u/row-k4e3_xakc.p7ct 280009 661546 2019-12-02 2019-06-30 201 16       10 227   12           239
871 871 MARSHFIELD MEDICAL CENTER - NEILLSVILLE 216 SUNSET PLACE NEILLSVILLE WI 54456 CLARK (715) 743-3101 Critical Access Hospitals Voluntary non-profit - Church TRUE 44.5570460 -90.6069090 0   19 55 55019         https://data.medicare.gov/resource/xubh-q36u/row-cc3y~6r3u.7b3a 521323 649525 2019-05-28 2018-12-31 25           25               25
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
895 895 MERCY HOSPITAL COLUMBUS 220 N PENNSYLVANIA AVENUE COLUMBUS KS 66725 CHEROKEE (620) 429-2545 Critical Access Hospitals Voluntary non-profit - Church TRUE 37.1720640 -94.8438050 0   21 20 20021         https://data.medicare.gov/resource/xubh-q36u/row-sn95~jvt2.e2ep 171308 660551 2019-11-27 2019-06-30 10           10               10
930 930 SETON SMITHVILLE REGIONAL HOSPITAL 1201 HILL RD SMITHVILLE TX 78957 BASTROP (512) 237-3214 Acute Care Hospitals Voluntary non-profit - Church TRUE 30.0039505 -97.1360218 1 ROOFTOP 21 48 48021 12420   Outlying Bastrop County https://data.medicare.gov/resource/xubh-q36u/row-d2dp~cvuc~gmre 450143 659733 2019-11-25 2019-06-30 8           8               8
933 933 LOURDES MEDICAL CENTER 520 N FOURTH AVENUE PASCO WA 99301 FRANKLIN (509) 546-2278 Critical Access Hospitals Voluntary non-profit - Church TRUE 46.2350260 -119.0944360 0   21 53 53021 28420   Central Franklin County https://data.medicare.gov/resource/xubh-q36u/row-h47i.7rwx-7e8h 501337 642976 2019-02-04 2018-08-31 25           25   10           35
1041 1041 CHRISTUS SPOHN HOSPITAL BEEVILLE 1500 E HOUSTON HWY BEEVILLE TX 78102 BEE (361) 354-2000 Acute Care Hospitals Voluntary non-profit - Church TRUE 28.4083530 -97.7319250 0   25 48 48025 13300   Central Bee County https://data.medicare.gov/resource/xubh-q36u/row-i8xs~bawd_cyy5 450082 659895 2019-11-26 2019-06-30 32 8         40               40
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
1107 1107 ADVENTHEALTH CENTRAL TEXAS 2201 S CLEAR CREEK ROAD KILLEEN TX 76542 BELL (254) 526-7523 Acute Care Hospitals Voluntary non-profit - Church TRUE 31.1133500 -97.7995190 0   27 48 48027 28660   Central Bell County https://data.medicare.gov/resource/xubh-q36u/row-d3a2-awra.pykq 450152 656365 2019-10-17 2018-09-30 194 10       4 208               208
1122 1122 CHI ST VINCENT MORRILTON #4 HOSPITAL DRIVE MORRILTON AR 72110 CONWAY (501) 977-2300 Critical Access Hospitals Voluntary non-profit - Church TRUE 35.1699700 -92.7217020 0   29 5 5029         https://data.medicare.gov/resource/xubh-q36u/row-jajp~f47n.nife 41324 660162 2019-12-02 2019-06-30 25           25               25
1187 1187 CHRISTUS SANTA ROSA MEDICAL CENTER 2827 BABCOCK ROAD SAN ANTONIO TX 78229 BEXAR (210) 704-3342 Acute Care Hospitals Voluntary non-profit - Church TRUE 29.5129090 -98.5915570 0   29 48 48029 41700   Central Bexar County https://data.medicare.gov/resource/xubh-q36u/row-332s~bezr_i5q2 450237 660052 2019-11-26 2019-06-30 323 49       5 377               377
1193 1193 DOOR COUNTY MEDICAL CENTER 323 SOUTH 18TH AVENUE STURGEON BAY WI 54235 DOOR (920) 743-5566 Critical Access Hospitals Voluntary non-profit - Church TRUE 44.8327630 -87.3514180 0   29 55 55029         https://data.medicare.gov/resource/xubh-q36u/row-xy7a~agib-pkn6 521358 660156 2019-11-21 2019-06-30 21 4         25       30       55
1314 1314 ADVENTIST HEALTH CLEARLAKE 15630 18TH AVE - HWY 53 CLEARLAKE CA 95422 LAKE (707) 994-6486 Critical Access Hospitals Voluntary non-profit - Church TRUE 38.9353458 -122.6200816 1 ROOFTOP 33 6 6033 17340   Central Lake County https://data.medicare.gov/resource/xubh-q36u/row-hud3~fp2e-cmcb 51317 648600 2019-05-31 2018-12-31 21 4         25               25
1324 1324 OUR LADY OF THE LAKE REGIONAL MEDICAL CENTER 5000 HENNESSY BLVD BATON ROUGE LA 70808 E. BATON ROUGE (225) 765-6565 Acute Care Hospitals Voluntary non-profit - Church TRUE 30.4013180 -91.1115280 0   33 22 22033 12940   Central East Baton Rouge Parish https://data.medicare.gov/resource/xubh-q36u/row-fxjt_dffw~6nnz 190064 661187 2019-12-02 2019-06-30 660 43     24   773 70 33           876
1407 1407 NORTHWOOD DEACONESS HEALTH CENTER PO BOX 190 NORTHWOOD ND 58267 GRAND FORKS (701) 587-6060 Critical Access Hospitals Voluntary non-profit - Church TRUE 47.7343845 -97.5683593 1 ROOFTOP 35 38 38035 24220   Central Grand Forks County https://data.medicare.gov/resource/xubh-q36u/row-r4gy_k4h8~nujf 351312 646643 2019-04-15 2018-12-31 12           12       45       57
1537 1537 MEMORIAL HOSPITAL AND HEALTH CARE CENTER 800 W 9TH ST JASPER IN 47546 DUBOIS (812) 996-2345 Acute Care Hospitals Voluntary non-profit - Church TRUE 38.3937430 -86.9412810 0   37 18 18037 27540   Central Dubois County https://data.medicare.gov/resource/xubh-q36u/row-znqj_58gv~pyf2 150115 660942 2019-12-02 2019-06-30 85 26         111 19 8   14       152
1538 1538 MERCY MEDICAL CENTER-NEW HAMPTON 308 NORTH MAPLE AVENUE NEW HAMPTON IA 50659 CHICKASAW (641) 394-4121 Critical Access Hospitals Voluntary non-profit - Church TRUE 43.0626770 -92.3204250 0   37 19 19037         https://data.medicare.gov/resource/xubh-q36u/row-xkj8-v8qa.w84a 161331 660217 2019-11-26 2019-06-30 8           8               8
1574 1574 CHRISTUS ST MICHAEL HEALTH SYSTEM 2600 ST MICHAEL DR TEXARKANA TX 75504 BOWIE (903) 614-1000 Acute Care Hospitals Voluntary non-profit - Church TRUE 33.4624900 -94.0744480 0   37 48 48037 45500   Central Bowie County https://data.medicare.gov/resource/xubh-q36u/row-ewkv~jnzh~w9wk 450801 659740 2019-11-26 2019-06-30 290 32 16   8 8 354               354
1594 1594 MUNSON HEALTHCARE GRAYLING HOSPITAL 1100 E MICHIGAN AVE GRAYLING MI 49738 CRAWFORD (989) 348-5461 Acute Care Hospitals Voluntary non-profit - Church TRUE 44.6672510 -84.7079390 0   39 26 26039         https://data.medicare.gov/resource/xubh-q36u/row-unnq.cpq3.chrb 230058 660583 2019-11-27 2019-06-30 43 6         49       39       88
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
1649 1649 ST FRANCIS HOSPITAL 3401 LUDINGTON ST ESCANABA MI 49829 DELTA (906) 786-3311 Critical Access Hospitals Voluntary non-profit - Church TRUE 45.7457600 -87.0948530 0   41 26 26041 21540   Central Delta County https://data.medicare.gov/resource/xubh-q36u/row-iqyh_xi8k_igyu 231337 645115 2019-02-28 2018-09-30 16 9         25               25
1670 1670 SAINT THOMAS DEKALB HOSPITAL 520 W MAIN ST SMITHVILLE TN 37166 DE KALB (615) 215-5000 Acute Care Hospitals Voluntary non-profit - Church TRUE 35.9594030 -85.8298410 0   41 47 47041         https://data.medicare.gov/resource/xubh-q36u/row-vj84-zvtf.4wg9 440148 659457 2019-11-25 2019-06-30 48 4         52               52
1675 1675 BON SECOURS ST FRANCIS MEDICAL CENTER 13710 ST FRANCIS BOULEVARD MIDLOTHIAN VA 23114 CHESTERFIELD (804) 594-7400 Acute Care Hospitals Voluntary non-profit - Church TRUE 37.4663980 -77.6590560 0   41 51 51041 40060   Central Chesterfield County https://data.medicare.gov/resource/xubh-q36u/row-tzv7~rut2-ttw4 490136 661426 2019-02-01 2018-08-31 114 16         130               130
1723 1723 ADVENTIST HEALTH HOWARD MEMORIAL 1 MARCELA DR WILLITS CA 95490 MENDOCINO (707) 456-3031 Critical Access Hospitals Voluntary non-profit - Church TRUE 39.3897770 -123.3399710 0   45 6 6045 46380   Central Mendocino County https://data.medicare.gov/resource/xubh-q36u/row-ecr7.pfkq_ummb 51310 648599 2019-05-29 2018-12-31 21 4         25               25
1724 1724 ADVENTIST HEALTH UKIAH VALLEY 275 HOSPITAL DRIVE UKIAH CA 95482 MENDOCINO (707) 462-3111 Acute Care Hospitals Voluntary non-profit - Church TRUE 39.1530190 -123.2038000 0   45 6 6045 46380   Central Mendocino County https://data.medicare.gov/resource/xubh-q36u/row-5xip-9esx.8u6b 50301 649538 2019-05-31 2018-12-31 42 6       2 50               50
1834 1834 ST ANTHONYS MEMORIAL HOSPITAL 503 N MAPLE STREET EFFINGHAM IL 62401 EFFINGHAM (217) 342-2121 Acute Care Hospitals Voluntary non-profit - Church TRUE 39.1244960 -88.5492740 0   49 17 17049 20820   Central Effingham County https://data.medicare.gov/resource/xubh-q36u/row-se8h.a4r7-s6mp 140032 661718 2019-12-02 2019-06-30 123 10         133               133
1901 1901 ADVENTHEALTH MANCHESTER 210 MARIE LANGDON DRIVE MANCHESTER KY 40962 CLAY (606) 598-5104 Acute Care Hospitals Voluntary non-profit - Church TRUE 37.1621540 -83.7613560 0   51 21 21051         https://data.medicare.gov/resource/xubh-q36u/row-vicy-u46v-q8em 180043 644277 2019-03-01 2018-09-30 43 6         49               49
1934 1934 BURLESON ST JOSEPH HEALTH CENTER 1101 WOODSON DRIVE CALDWELL TX 77836 BURLESON (979) 567-3245 Critical Access Hospitals Voluntary non-profit - Church FALSE 30.5203070 -96.7177140 0   51 48 48051 17780   Outlying Burleson County https://data.medicare.gov/resource/xubh-q36u/row-gq4y-tvhz_2h55 451305 660890 2019-11-29 2019-06-30 15           15               15
1944 1944 BAYFRONT HEALTH BROOKSVILLE 17240 CORTEZ BLVD BROOKSVILLE FL 34601 HERNANDO (352) 796-5111 Acute Care Hospitals Voluntary non-profit - Church TRUE 28.5411150 -82.4433860 0   53 12 12053 45300   Outlying Hernando County https://data.medicare.gov/resource/xubh-q36u/row-kghc_774k-8m6c 100071 645397 2019-03-01 2018-09-30 214 20         244               244
1996 1996 ADVENTHEALTH SEBRING 4200 SUN N LAKE BLVD SEBRING FL 33871 HIGHLANDS (863) 314-4466 Acute Care Hospitals Voluntary non-profit - Church FALSE 27.5384550 -81.5068810 0   55 12 12055 42700   Central Highlands County https://data.medicare.gov/resource/xubh-q36u/row-kk9t~8fs5~ksmj 100109 661479 2019-11-26 2018-12-31 158 22         180 17             197
2032 2032 CHI ST ALEXIUS HEALTH TURTLE LAKE 220 5TH AVE W TURTLE LAKE ND 58575 MCLEAN (701) 448-2331 Critical Access Hospitals Voluntary non-profit - Church TRUE 47.5179250 -100.8944420 0   55 38 38055         https://data.medicare.gov/resource/xubh-q36u/row-w8fb-47fy-9nzg 351304 640251 2018-12-03 2018-06-30 25           25               25
2053 2053 ADVENTHEALTH CARROLLWOOD 7171 N DALE MABRY HWY TAMPA FL 33614 HILLSBOROUGH (813) 932-2222 Acute Care Hospitals Voluntary non-profit - Church TRUE 28.0131020 -82.5049540 0   57 12 12057 45300   Central Hillsborough County https://data.medicare.gov/resource/xubh-q36u/row-22he-y9u8_3jua 100069 649181 2019-05-31 2018-12-31 95 8         103               103
2057 2057 ST JOSEPHS HOSPITAL 3001 W MARTIN LUTHER KING JR BLVD TAMPA FL 33677 HILLSBOROUGH (813) 870-4398 Acute Care Hospitals Voluntary non-profit - Church TRUE 27.9822844 -82.4911306 1 ROOFTOP 57 12 12057 45300   Central Hillsborough County https://data.medicare.gov/resource/xubh-q36u/row-w8gx-3zfk-n7gh 100075 650969 2019-05-31 2018-12-31 866 106 26     64 1062               1062
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
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
2186 2186 MERCYONE DUBUQUE MEDICAL CENTER 250 MERCY DRIVE DUBUQUE IA 52001 DUBUQUE (563) 589-8000 Acute Care Hospitals Voluntary non-profit - Church TRUE 42.4931450 -90.6743500 0   61 19 19061 20220   Central Dubuque County https://data.medicare.gov/resource/xubh-q36u/row-852u.y47f-95x9 160069 660083 2019-11-26 2019-06-30 142 8         150   9   20       179
2249 2249 AVERA HOLY FAMILY HOSPITAL 826 NORTH 8TH STREET ESTHERVILLE IA 51334 EMMET (712) 362-2631 Critical Access Hospitals Voluntary non-profit - Church TRUE 43.4105960 -94.8339560 0   63 19 19063         https://data.medicare.gov/resource/xubh-q36u/row-gfry-34vq-dsa9 161351 660978 2019-11-27 2019-06-30 22           22               22
2257 2257 ST PATRICK HOSPITAL 500 W BROADWAY MISSOULA MT 59806 MISSOULA (406) 543-7271 Acute Care Hospitals Voluntary non-profit - Church TRUE 46.8739050 -113.9998910 0   63 30 30063 33540   Central Missoula County https://data.medicare.gov/resource/xubh-q36u/row-44i5~53xu-fjn4 270014 650294 2019-05-31 2018-12-31 134 24         158 30             188
2302 2302 MERCYONE OELWEIN MEDICAL CENTER 201 EIGHTH AVENUE SE OELWEIN IA 50662 FAYETTE (319) 283-6000 Critical Access Hospitals Voluntary non-profit - Church TRUE 42.6754190 -91.9026130 0   65 19 19065         https://data.medicare.gov/resource/xubh-q36u/row-z2fd.d4q8-bgsq 161338 659570 2019-11-19 2019-06-30 25           25       39       64
2342 2342 MERCY REGIONAL MEDICAL CENTER 1010 THREE SPRINGS BLVD DURANGO CO 81301 LA PLATA (970) 247-4311 Acute Care Hospitals Voluntary non-profit - Church TRUE 37.2350540 -107.8248410 0   67 8 8067 20420   Central La Plata County https://data.medicare.gov/resource/xubh-q36u/row-6bgp-cgig-rde4 60013 654771 2019-10-07 2019-06-30 71 11         82               82
2382 2382 ASPIRUS LANGLADE HOSPITAL 112 E FIFTH AVE ANTIGO WI 54409 LANGLADE (715) 623-2331 Critical Access Hospitals Voluntary non-profit - Church TRUE 45.1403190 -89.1402920 0   67 55 55067         https://data.medicare.gov/resource/xubh-q36u/row-fn2s~3kqd.84yg 521350 661688 2019-11-27 2019-06-30 21 4         25               25
2411 2411 MERCY HOSPITAL TISHOMINGO 1000 SOUTH BYRD TISHOMINGO OK 73460 JOHNSTON (580) 371-2327 Critical Access Hospitals Voluntary non-profit - Church TRUE 34.2224450 -96.6752940 0   69 40 40069         https://data.medicare.gov/resource/xubh-q36u/row-d4ji~yfmc.9fmx 371304 659716 2019-11-25 2019-06-30 25           25               25
2417 2417 WHEELING HOSPITAL 1 MEDICAL PARK WHEELING WV 26003 OHIO (304) 243-3000 Acute Care Hospitals Voluntary non-profit - Church TRUE 40.0600740 -80.6840220 0   69 54 54069 48540   Central Ohio County https://data.medicare.gov/resource/xubh-q36u/row-s497_dubq_q36x 510050 645204 2019-02-28 2018-09-30 201 22         223       125       348
2544 2544 MERCY HOSPITAL KINGFISHER, INC 1000 KINGFISHER HOSPITAL DRIVE KINGFISHER OK 73750 KINGFISHER (405) 375-3141 Critical Access Hospitals Voluntary non-profit - Church TRUE 35.8100746 -97.9449387 1 ROOFTOP 73 40 40073         https://data.medicare.gov/resource/xubh-q36u/row-h8q6~j6ue-y5ca 371313 660141 2019-11-25 2019-06-30 25           25               25
2597 2597 ST MARYS MEDICAL CENTER 2635 N 7TH ST GRAND JUNCTION CO 81502 MESA (970) 298-1950 Acute Care Hospitals Voluntary non-profit - Church TRUE 39.0906040 -108.5614390 0   77 8 8077 24300   Central Mesa County https://data.medicare.gov/resource/xubh-q36u/row-qity~ffvk.qimr 60023 649708 2019-05-31 2018-12-31 195 18 14       257   24           281
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
2631 2631 HOWARD YOUNG MEDICAL CTR 240 MAPLE ST WOODRUFF WI 54568 VILAS (715) 356-8000 Acute Care Hospitals Voluntary non-profit - Church TRUE 45.8943700 -89.7018370 0   85 55 55085         https://data.medicare.gov/resource/xubh-q36u/row-9mxb-vzak_pksq 520091 661681 2019-11-27 2019-06-30 40 10         50               50
2653 2653 CHI HEALTH ST FRANCIS 2620 WEST FAIDLEY AVE GRAND ISLAND NE 68803 HALL (308) 384-4600 Acute Care Hospitals Voluntary non-profit - Church TRUE 40.9242670 -98.3708870 0   79 31 31079 24260   Central Hall County https://data.medicare.gov/resource/xubh-q36u/row-rgs4_gs84~mfkz 280023 661547 2019-12-02 2019-06-30 115 16       9 140   12   34       186
2729 2729 MAYO CLINIC HLTH SYSTM FRANCISCAN HLTHCARE SPARTA 310 W MAIN ST SPARTA WI 54656 MONROE (608) 269-2132 Critical Access Hospitals Voluntary non-profit - Church TRUE 43.9443950 -90.8151600 0   81 55 55081         https://data.medicare.gov/resource/xubh-q36u/row-un6d~bwq3_48jh 521305 649521 2019-05-28 2018-12-31 25           25               25
2734 2734 NORTH LOGAN MERCY HOSPITAL 500 EAST ACADEMY PARIS AR 72855 LOGAN (479) 963-6101 Critical Access Hospitals Voluntary non-profit - Church TRUE 35.2899880 -93.7254190 0   83 5 5083         https://data.medicare.gov/resource/xubh-q36u/row-6tgs-f8yk-urcu 41300 660744 2019-12-04 2019-06-30 16           16               16
2739 2739 MARIAN REGIONAL MEDICAL CENTER 1400 E CHURCH ST SANTA MARIA CA 93454 SANTA BARBARA (805) 739-3100 Acute Care Hospitals Voluntary non-profit - Church FALSE 34.9521170 -120.4124940 0   83 6 6083 42200   Central Santa Barbara County https://data.medicare.gov/resource/xubh-q36u/row-fcqm_qb6a~xqvi 50107 655525 2019-10-11 2019-06-30 224 28         273   20   95       388
2825 2825 BON SECOURS MEMORIAL REGIONAL MEDICAL CENTER 8260 ATLEE ROAD MECHANICSVILLE VA 23116 HANOVER (804) 764-6000 Acute Care Hospitals Voluntary non-profit - Church TRUE 37.6293520 -77.3881020 0   85 51 51085 40060   Central Hanover County https://data.medicare.gov/resource/xubh-q36u/row-h5ac-vvhg_ak78 490069 660059 2019-05-14 2018-08-31 200 24         224               224
2873 2873 BON SECOURS ST MARYS HOSPITAL 5801 BREMO RD RICHMOND VA 23226 RICHMOND CITY (804) 285-2011 Acute Care Hospitals Voluntary non-profit - Church TRUE 37.5844050 -77.5132620 0   87 51 51087 40060   Central Henrico County https://data.medicare.gov/resource/xubh-q36u/row-w7z5~9vmx.i87w 490059 659904 2019-01-30 2018-08-31 285 64 8     21 378 32             410
2911 2911 AVERA ST ANTHONY'S HOSPITAL 300 NORTH 2ND ST O' NEILL NE 68763 HOLT (402) 336-5131 Critical Access Hospitals Voluntary non-profit - Church TRUE 42.4603380 -98.6511180 0   89 31 31089         https://data.medicare.gov/resource/xubh-q36u/row-z9z2~5zkd.wkgh 281329 660645 2019-11-26 2019-06-30 25           25               25
2920 2920 CHI ST ALEXIUS HEALTH DICKINSON 2500 FAIRWAY STREET DICKINSON ND 58601 STARK (701) 456-4000 Critical Access Hospitals Voluntary non-profit - Church TRUE 46.8872670 -102.8205980 0   89 38 38089 19860   Central Stark County https://data.medicare.gov/resource/xubh-q36u/row-e333-s9qr~xa2s 351336 659599 2019-11-27 2019-06-30 21 4         25               25
2982 2982 ADVENTHEALTH DURAND 1220 3RD AVE W DURAND WI 54736 PEPIN (715) 672-4211 Critical Access Hospitals Voluntary non-profit - Church TRUE 44.6203090 -91.9635000 0   91 55 55091         https://data.medicare.gov/resource/xubh-q36u/row-qzeb.agub~nfph 521307 650794 2019-05-30 2018-12-31 25           25               25
3034 3034 ST MARY MEDICAL CENTER 3333 NORTH SEMINARY GALESBURG IL 61401 KNOX (309) 344-3161 Acute Care Hospitals Voluntary non-profit - Church TRUE 40.9870200 -90.3636090 0   95 17 17095 23660   Central Knox County https://data.medicare.gov/resource/xubh-q36u/row-qvep_yzhb-cn4g 140064 644980 2019-02-28 2018-09-30 75 6         81               81
3194 3194 ADVENTHEALTH ZEPHYRHILLS 7050 GALL BLVD ZEPHYRHILLS FL 33541 PASCO (813) 788-0411 Acute Care Hospitals Voluntary non-profit - Church TRUE 28.2609370 -82.1880410 0   101 12 12101 45300   Central Pasco County https://data.medicare.gov/resource/xubh-q36u/row-5w9q_uu4q-aya6 100046 649408 2019-05-31 2018-12-31 135 14         149               149
3203 3203 METHODIST HOSPITAL 1305 N ELM ST HENDERSON KY 42420 HENDERSON (270) 827-7700 Acute Care Hospitals Voluntary non-profit - Church TRUE 37.8538580 -87.5812570 0   101 21 21101 21780   Central Henderson County https://data.medicare.gov/resource/xubh-q36u/row-ind5_jj7i~ryuv 180056 660560 2019-11-27 2019-06-30 91 12         118               118
3252 3252 ST ANTHONYS HOSPITAL 1200 SEVENTH AVE N SAINT PETERSBURG FL 33705 PINELLAS (727) 825-1100 Acute Care Hospitals Voluntary non-profit - Church TRUE 27.7793430 -82.6512240 0   103 12 12103 45300   Central Pinellas County https://data.medicare.gov/resource/xubh-q36u/row-w2f7.3x2c.vdae 100067 650677 2019-05-31 2018-12-31 280 18 10       308 50             358
3318 3318 MERCY HOSPITAL LEBANON 100 HOSPITAL DRIVE LEBANON MO 65536 LACLEDE (417) 533-6100 Acute Care Hospitals Voluntary non-profit - Church TRUE 37.6814370 -92.6358750 0   105 29 29105 30060   Central Laclede County https://data.medicare.gov/resource/xubh-q36u/row-rqaa-p66y~a4xf 260059 661028 2019-11-27 2019-06-30 39 4         43               43
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
3356 3356 AVERA GETTYSBURG HOSPITAL 606 EAST GARFIELD GETTYSBURG SD 57442 POTTER (605) 765-2480 Critical Access Hospitals Voluntary non-profit - Church TRUE 45.0135510 -99.9481280 0   107 46 46107         https://data.medicare.gov/resource/xubh-q36u/row-5ptc-f9a4-vq7p 431302 660878 2019-12-02 2019-06-30 10           10           50   60
3364 3364 ADVENTIST HEALTH SONORA 1000 GREENLEY ROAD SONORA CA 95370 TUOLUMNE (209) 536-5000 Acute Care Hospitals Voluntary non-profit - Church FALSE 37.9767280 -120.3694420 0   109 6 6109 43760   Central Tuolumne County https://data.medicare.gov/resource/xubh-q36u/row-7tcs_nvgu-e2ik 50335 652417 2019-05-31 2018-12-31 78 6         84       68       152
3378 3378 MERCY HOSPITAL AURORA 500 PORTER AVENUE AURORA MO 65605 LAWRENCE (417) 678-2122 Critical Access Hospitals Voluntary non-profit - Church TRUE 36.9705100 -93.7109620 0   109 29 29109         https://data.medicare.gov/resource/xubh-q36u/row-pmej_ahzh-su6w 261316 660250 2019-11-26 2019-06-30 25           25               25
3439 3439 ST VINCENT HEALTHCARE 1233 N 30TH ST BILLINGS MT 59101 YELLOWSTONE (406) 657-7000 Acute Care Hospitals Voluntary non-profit - Church TRUE 45.7931660 -108.5202810 0   111 30 30111 13740   Central Yellowstone County https://data.medicare.gov/resource/xubh-q36u/row-pej5.abty.c4tn 270049 646627 2019-04-11 2018-12-31 191 17         236   20           256
3468 3468 MERCY HOSPITAL, INC 218 E PACK STREET MOUNDRIDGE KS 67107 MCPHERSON (620) 345-6391 Acute Care Hospitals Voluntary non-profit - Church TRUE 38.2050720 -97.5169960 0   113 20 20113 32700   Central McPherson County https://data.medicare.gov/resource/xubh-q36u/row-7sai~qa9i.bde5 170075 643207 2019-02-11 2018-09-30 21           21               21
3545 3545 ST ANTHONY SUMMIT MEDICAL CENTER 340 PEAK ONE DRIVE FRISCO CO 80443 SUMMIT (970) 668-3300 Acute Care Hospitals Voluntary non-profit - Church FALSE 39.5699880 -106.0782590 0   117 8 8117 14720   Central Summit County https://data.medicare.gov/resource/xubh-q36u/row-z7ad.cmh5-5ysx 60118 654908 2019-10-10 2019-06-30 26 8         34               34
3562 3562 BAPTIST MEMORIAL HOSPITAL BOONEVILLE 100 HOSPITAL DRIVE BOONEVILLE MS 38829 PRENTISS (662) 720-5000 Acute Care Hospitals Voluntary non-profit - Church TRUE 34.6563370 -88.5657630 0   117 28 28117         https://data.medicare.gov/resource/xubh-q36u/row-yxvp-p3fk_sfj3 250044 644040 2019-02-26 2018-09-30 28   11       39 15             54
3600 3600 FAITH REGIONAL HEALTH SERVICES 2700 WEST NORFOLK AVE NORFOLK NE 68701 MADISON (402) 371-4880 Acute Care Hospitals Voluntary non-profit - Church TRUE 42.0325260 -97.4509420 0   119 31 31119 35740   Central Madison County https://data.medicare.gov/resource/xubh-q36u/row-xkuw_ar84~23n7 280125 650296 2019-06-04 2018-12-31 98 24         122   7           129
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
3814 3814 CHI HEALTH ST MARY'S 1301 GRUNDMAN BLVD NEBRASKA CITY NE 68410 OTOE (402) 873-3321 Critical Access Hospitals Voluntary non-profit - Church TRUE 40.6581520 -95.8621090 0   131 31 31131         https://data.medicare.gov/resource/xubh-q36u/row-6z57~cf6y.zams 281342 661042 2019-12-02 2019-06-30 18           18               18
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
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
3897 3897 CHI HEALTH PLAINVIEW P O BOX 489, 704 NORTH THIRD ST PLAINVIEW NE 68769 PIERCE (402) 582-4245 Critical Access Hospitals Voluntary non-profit - Church TRUE 42.3587128 -97.7857721 1 ROOFTOP 139 31 31139 35740   Outlying Pierce County https://data.medicare.gov/resource/xubh-q36u/row-dyfy-rvq7~3hjd 281346 661043 2019-12-02 2019-06-30 15           15               15
3915 3915 BAUM HARMON MERCY HOSPITAL 255 N WELCH AVENUE PRIMGHAR IA 51245 OBRIEN (712) 957-2300 Critical Access Hospitals Voluntary non-profit - Church TRUE 43.0885970 -95.6227960 0   141 19 19141         https://data.medicare.gov/resource/xubh-q36u/row-jur3.m7q6_c9mz 161300 660546 2019-11-27 2019-06-30 14           14               14
4003 4003 MOSAIC MEDICAL CENTER - MARYVILLE 2016 SOUTH MAIN ST MARYVILLE MO 64468 NODAWAY (660) 562-2600 Acute Care Hospitals Voluntary non-profit - Church TRUE 40.3260530 -94.8740380 0   147 29 29147 32340   Central Nodaway County https://data.medicare.gov/resource/xubh-q36u/row-kehc_eqeq_s8gt 260050 661922 2019-12-04 2019-06-30 38           38 14             52
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
4188 4188 MUNSON HEALTHCARE CADILLAC HOSPITAL 400 HOBART ST CADILLAC MI 49601 WEXFORD (231) 876-7200 Acute Care Hospitals Voluntary non-profit - Church TRUE 44.2461480 -85.3904560 0   165 26 26165 15620   Central Wexford County https://data.medicare.gov/resource/xubh-q36u/row-3n4e~wz2j_4rnr 230081 660587 2019-11-27 2019-06-30 29 20         49               49
4230 4230 ST VINCENT WILLIAMSPORT HOSPITAL INC 412 N MONROE ST WILLIAMSPORT IN 47993 WARREN (765) 762-4000 Critical Access Hospitals Voluntary non-profit - Church TRUE 40.2904700 -87.2958190 0   171 18 18171         https://data.medicare.gov/resource/xubh-q36u/row-hngk~n78p-82t8 151307 660948 2019-12-02 2019-06-30 16           16               16

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