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 nursing_fac_beds 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
1995 1995 SPANISH PEAKS REGIONAL HEALTH CENTER 23500 US HWY 160 WALSENBURG CO 81089 HUERFANO (719) 738-5100 Critical Access Hospitals Government - Hospital District or Authority TRUE 37.6076880 -104.8197860 0   55 8 8055         https://data.medicare.gov/resource/xubh-q36u/row-d4uh.vzxr_8sf9 61316 650807 2019-06-04 2018-12-31 16           16         9 120   145
4463 4463 SULLIVAN COUNTY MEMORIAL HOSPITAL 630 WEST THIRD STREET MILAN MO 63556 SULLIVAN (660) 265-4212 Critical Access Hospitals Government - Local TRUE 40.2021740 -93.1311360 0   211 29 29211         https://data.medicare.gov/resource/xubh-q36u/row-puyt~jfux-w58a 261306 659511 2019-02-26 2018-10-31 17           17         9     26
32 32 SHARE MEDICAL CENTER 800 SHARE DRIVE ALVA OK 73717 WOODS (580) 327-2800 Critical Access Hospitals Government - Hospital District or Authority TRUE 36.7869690 -98.6700230 0   151 40 40151         https://data.medicare.gov/resource/xubh-q36u/row-gzmq-89k6~9n3d 371341 659863 2019-11-25 2019-06-30 25           25         80     105
1071 1071 ST ANTHONY REGIONAL HOSPITAL & NURSING HOME 311 SOUTH CLARK STREET CARROLL IA 51401 CARROLL (712) 792-3581 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.0569820 -94.8679810 0   27 19 19027         https://data.medicare.gov/resource/xubh-q36u/row-mmxr_bdg2_23xf 160005 661893 2019-12-04 2019-06-30 43 6         49 14       79     142
652 652 TENNOVA HEALTHCARE-LAFOLLETT MEDICAL CENTER 923 EAST CENTRAL AVENUE LA FOLLETTE TN 37766 CAMPBELL (423) 907-1200 Acute Care Hospitals Voluntary non-profit - Church TRUE 36.3879670 -84.1113650 0   13 47 47013 28940 Knoxville-Morristown-Sevierville, TN Outlying Campbell County https://data.medicare.gov/resource/xubh-q36u/row-fetd_k94i.ub5n 440033 645499 2019-03-01 2018-09-30 41 6         47 10     21 77     155
3357 3357 STARR REGIONAL MEDICAL CENTER ATHENS 1114 W MADISON AVE ATHENS TN 37371 MC MINN (423) 745-1411 Acute Care Hospitals Proprietary TRUE 35.4407890 -84.6088230 0   107 47 47107 11940 Chattanooga-Cleveland-Dalton, TN-GA-AL Central McMinn County https://data.medicare.gov/resource/xubh-q36u/row-j9r6~ujtq-iqfx 440068 644180 2019-02-28 2018-09-30 84 4         88 18     13 75     194
838 838 CHOCTAW REGIONAL MEDICAL CENTER 8613 MS HWY 12 ACKERMAN MS 39735 CHOCTAW (662) 285-4400 Critical Access Hospitals Government - Local TRUE 33.3184650 -89.1823040 0   19 28 28019         https://data.medicare.gov/resource/xubh-q36u/row-9nt3~77et_z9mg 251334 643914 2019-03-01 2018-09-30 15           15         73     88
3360 3360 INOVA LOUDOUN HOSPITAL 44045 RIVERSIDE PARKWAY LEESBURG VA 20176 LOUDOUN (703) 858-6600 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.0746090 -77.4752270 0   107 51 51107 47900 Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Central Loudoun County https://data.medicare.gov/resource/xubh-q36u/row-mcfe~m44f_p2b9 490043 650395 2019-06-12 2018-12-31 122 23         145 22     28 72     267
4083 4083 PEMISCOT COUNTY MEMORIAL HOSPITAL 946 EAST REED HAYTI MO 63851 PEMISCOT (573) 359-1372 Acute Care Hospitals Government - Local TRUE 36.2368550 -89.7399750 0   155 29 29155         https://data.medicare.gov/resource/xubh-q36u/row-r644.jfav_m4mz 260070 650166 2019-06-03 2018-12-31 42 7         49 52       66     167
1790 1790 EXCELSIOR SPRINGS HOSPITAL 1700 RAINBOW BOULEVARD EXCELSIOR SPRINGS MO 64024 CLAY (816) 630-6081 Critical Access Hospitals Government - Local TRUE 39.3622170 -94.2365190 0   47 29 29047 28140 Kansas City-Overland Park-Kansas City, MO-KS Central Clay County https://data.medicare.gov/resource/xubh-q36u/row-7pwj-2gs7.gpk5 261322 644516 2019-02-27 2018-09-30 25           25         60     85
1824 1824 WELCH COMMUNITY HOSPITAL 454 MCDOWELL STREET WELCH WV 24801 MC DOWELL (304) 436-8461 Acute Care Hospitals Government - State TRUE 37.4388220 -81.5892950 0   47 54 54047         https://data.medicare.gov/resource/xubh-q36u/row-y7rn~73h2.fggs 510086 661439 2019-12-02 2019-06-30 42 7         49         59     108
4284 4284 HOPEDALE HOSPITAL 107 TREMONT STREET HOPEDALE IL 61747 TAZEWELL (309) 449-4296 Critical Access Hospitals Voluntary non-profit - Private TRUE 40.4183830 -89.4177290 0   179 17 17179 37900 Peoria-Canton, IL Central Tazewell County https://data.medicare.gov/resource/xubh-q36u/row-xd8s-ubf6_48ka 141330 661879 2019-12-06 2019-06-30 25           25         59 72   156
407 407 SOUTHEAST COLORADO HOSPITAL 373 E TENTH AVE SPRINGFIELD CO 81073 BACA (719) 523-4501 Critical Access Hospitals Government - Hospital District or Authority TRUE 37.4041650 -102.6124230 0   9 8 8009         https://data.medicare.gov/resource/xubh-q36u/row-ph53-yjae~upmw 61311 649711 2019-06-13 2018-12-31 15           15         56     71
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
1175 1175 TENNOVA HEALTHCARE-NEWPORT MEDICAL CENTER 435 2ND ST NEWPORT TN 37821 COCKE (423) 625-2200 Acute Care Hospitals Voluntary non-profit - Church TRUE 35.9650670 -83.1816190 0   29 47 47029 35460 Knoxville-Morristown-Sevierville, TN Central Cocke County https://data.medicare.gov/resource/xubh-q36u/row-ipf5-nfbk.t6y4 440153 644182 2019-02-26 2018-09-30 27 5         32         56     88
2399 2399 FRANKLIN GENERAL HOSPITAL 1720 CENTRAL AVENUE EAST HAMPTON IA 50441 FRANKLIN (641) 456-5000 Critical Access Hospitals Government - Local TRUE 42.7414070 -93.1867630 0   69 19 19069         https://data.medicare.gov/resource/xubh-q36u/row-acr5.brk4.hide 161308 661178 2019-11-29 2019-06-30 25           25         52     77
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
2508 2508 SHARP CHULA VISTA MEDICAL CENTER 751 MEDICAL CENTER COURT CHULA VISTA CA 91911 SAN DIEGO (619) 502-5800 Acute Care Hospitals Proprietary TRUE 32.6184480 -117.0239900 0   73 6 6073 41740   Central San Diego County https://data.medicare.gov/resource/xubh-q36u/row-75gp_4nzp_4ubq 50222 643329 2019-02-25 2018-09-30 199 35         243       50 50     343
3625 3625 COOSA VALLEY MEDICAL CENTER 315 W HICKORY ST SYLACAUGA AL 35150 TALLADEGA (256) 249-5000 Acute Care Hospitals Government - Hospital District or Authority TRUE 33.1646660 -86.2545980 0   121 1 1121 45180 Birmingham-Hoover-Talladega, AL Central Talladega County https://data.medicare.gov/resource/xubh-q36u/row-uqj6-bzwc~56ip 10164 659174 2018-12-26 2018-07-31 114 8         122 15     35 50     222
2377 2377 AVERA ST BENEDICT HEALTH CENTER - CAH 401 WEST GLYNN DRIVE PARKSTON SD 57366 HUTCHINSON (605) 928-3311 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.3989450 -97.9900610 0   67 46 46067         https://data.medicare.gov/resource/xubh-q36u/row-w4r3_dmvi-zsg5 431330 660035 2019-11-25 2019-06-30 25           25         49     74
815 815 COMMUNITY REGIONAL MEDICAL CENTER 2823 FRESNO STREET FRESNO CA 93721 FRESNO (559) 459-6000 Acute Care Hospitals Voluntary non-profit - Private TRUE 36.7425830 -119.7830230 0   19 6 6019 23420 Fresno-Madera, CA Central Fresno County https://data.medicare.gov/resource/xubh-q36u/row-xy9w-yfis_5dn2 50060 662313 2019-01-28 2018-08-31 577 78   10   84 749   32   58 48     887
209 209 MEMORIAL HOSPITAL, THE 3073 WHITE MOUNTAIN HIGHWAY NORTH CONWAY NH 3860 CARROLL (603) 356-5461 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.0605190 -71.1385100 0   3 33 33003         https://data.medicare.gov/resource/xubh-q36u/row-n7xq-6ijr_9ppy 301307 645671 2019-03-01 2018-09-30 21 4         25         45     70
713 713 SANFORD CHAMBERLAIN MEDICAL CENTER 300 S BYRON CHAMBERLAIN SD 57325 BRULE (605) 234-5511 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.7851100 -99.3261340 0   15 46 46015         https://data.medicare.gov/resource/xubh-q36u/row-cv97_2b3i.ibpd 431329 652106 2019-05-30 2018-12-31 25           25         44     69
2727 2727 SAINT THOMAS HICKMAN HOSPITAL 135 EAST SWAN STREET CENTERVILLE TN 37033 HICKMAN (931) 729-4271 Critical Access Hospitals Voluntary non-profit - Private FALSE 35.7795390 -87.4602420 0   81 47 47081 34980 Nashville-Davidson--Murfreesboro, TN Outlying Hickman County https://data.medicare.gov/resource/xubh-q36u/row-3u9v~yfau~8vwh 441300 659460 2019-11-25 2019-06-30 25           25         40     65
2994 2994 KEARNY COUNTY HOSPITAL 500 THORPE STREET LAKIN KS 67860 KEARNY (620) 355-7111 Critical Access Hospitals Government - Local TRUE 37.9459710 -101.2510360 0   93 20 20093 23780   Outlying Kearny County https://data.medicare.gov/resource/xubh-q36u/row-62du-eigp.wszj 171313 660224 2019-11-26 2019-06-30 25           25         40 35   100
4240 4240 UNICOI COUNTY HOSPITAL 2030 TEMPLE HILL ROAD ERWIN TN 37650 UNICOI (423) 743-3141 Acute Care Hospitals Voluntary non-profit - Private TRUE 36.1213650 -82.4456210 0   171 47 47171 27740 Johnson City-Kingsport-Bristol, TN-VA Outlying Unicoi County https://data.medicare.gov/resource/xubh-q36u/row-8b8j.szqj-76se 440001 649955 2019-05-28 2018-12-31 10           10       7 39     56
2856 2856 F W HUSTON MEDICAL CENTER 408 DELAWARE STREET WINCHESTER KS 66097 JEFFERSON (913) 774-4340 Critical Access Hospitals Voluntary non-profit - Private TRUE 39.3252310 -95.2704010 0   87 20 20087 45820   Outlying Jefferson County https://data.medicare.gov/resource/xubh-q36u/row-ms4u_ppxf-axv2 171314 649589 2019-06-03 2018-12-31 25           25         38 6   69
373 373 MINERS' COLFAX MEDICAL CENTER 203 HOSPITAL DRIVE RATON NM 87740 COLFAX (575) 445-3661 Critical Access Hospitals Government - State TRUE 36.8635480 -104.4431840 0   7 35 35007         https://data.medicare.gov/resource/xubh-q36u/row-52rb_2gq5.zmq9 321307 659824 2019-11-21 2019-06-30 21 4         25         37     62
726 726 BARTON MEMORIAL HOSPITAL 2170 SOUTH AVENUE SOUTH LAKE TAHOE CA 96150 EL DORADO (530) 541-3420 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.9123370 -119.9977110 0   17 6 6017 40900 Sacramento-Roseville, CA Central El Dorado County https://data.medicare.gov/resource/xubh-q36u/row-kae2-ekyj_hpjm 50352 652418 2019-05-31 2018-12-31 55 8         63       11 37     111
3520 3520 SEDGWICK COUNTY MEMORIAL HOSPITAL 900 CEDAR ST JULESBURG CO 80737 SEDGWICK (970) 474-3323 Critical Access Hospitals Government - Local FALSE 40.9937430 -102.2692320 0   115 8 8115         https://data.medicare.gov/resource/xubh-q36u/row-ptjm_bmz6~8mzz 61310 649075 2019-05-22 2018-12-31 9           9         32     41
4080 4080 MEMORIAL HEALTHCARE 826 WEST KING STREET OWOSSO MI 48867 SHIAWASSEE (989) 723-5211 Acute Care Hospitals Voluntary non-profit - Other FALSE 43.0050750 -84.1820760 0   155 26 26155 37020 Lansing-East Lansing-Owosso, MI Central Shiawassee County https://data.medicare.gov/resource/xubh-q36u/row-3gmb~kzum~86xp 230121 649608 2019-05-31 2018-12-31 104 7         111       7 32     150
1978 1978 HIRAM W DAVIS MEDICAL CENTER P O BOX 4030 PETERSBURG VA 23803 PETERSBURG CITY (804) 524-7344 Acute Care Hospitals Government - State FALSE 37.2098658 -77.4509355 1 ROOFTOP 53 51 51053 40060   Central Dinwiddie County https://data.medicare.gov/resource/xubh-q36u/row-xvn2.38q5-2xg5 490104 661117 2019-11-27 2019-06-30 4           4       50 30 277   361
2038 2038 HANS P PETERSON MEMORIAL HOSPITAL - CAH 503 W PINE POST OFFICE BOX 790 PHILIP SD 57567 HAAKON (605) 859-2511 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.0392471 -101.6628240 1 ROOFTOP 55 46 46055         https://data.medicare.gov/resource/xubh-q36u/row-5652-vpwn_wmme 431319 651668 2019-07-01 2018-12-31 18           18         30     48
4132 4132 GENESIS HEALTH SYSTEM 801 ILLINI DR SILVIS IL 61282 ROCK ISLAND (309) 281-4000 Acute Care Hospitals Government - Local TRUE 41.4930680 -90.4199970 0   161 17 17161 19340 Davenport-Moline, IA-IL Central Rock Island County https://data.medicare.gov/resource/xubh-q36u/row-wxqw_k6y5~djg4 140275 654836 2019-09-24 2019-06-30 138 7         145       92 28     265
2428 2428 HI-DESERT MEDICAL CENTER 6601 WHITE FEATHER ROAD JOSHUA TREE CA 92252 SAN BERNARDINO (760) 366-3711 Acute Care Hospitals Government - Hospital District or Authority TRUE 34.1326760 -116.2767090 0   71 6 6071 40140 Los Angeles-Long Beach, CA Central San Bernardino County https://data.medicare.gov/resource/xubh-q36u/row-3mx7_8i2i.7siq 50279 655668 2019-10-30 2019-05-31 51 4         55       95 25     175
987 987 SOUTH LINCOLN MEDICAL CENTER - CAH 711 ONYX STREET KEMMERER WY 83101 LINCOLN (307) 877-4401 Critical Access Hospitals Government - Hospital District or Authority TRUE 41.7895800 -110.5406070 0   23 56 56023         https://data.medicare.gov/resource/xubh-q36u/row-fvca.ncci~gnkk 531315 661692 2019-11-22 2019-06-30 13           13         24     37
2512 2512 RADY CHILDREN'S HOSPITAL - SAN DIEGO 3020 CHILDRENS WAY SAN DIEGO CA 92123 SAN DIEGO (858) 576-1700 Childrens Voluntary non-profit - Other FALSE 32.7982600 -117.1508210 0   73 6 6073 41740   Central San Diego County https://data.medicare.gov/resource/xubh-q36u/row-g946~ee4n.abkv 53303 660172 2019-12-02 2019-06-30 193 54       24 401         24 19   444
659 659 DAYTON GENERAL HOSPITAL 1012 SOUTH 3RD STREET DAYTON WA 99328 COLUMBIA (509) 382-2531 Critical Access Hospitals Government - Hospital District or Authority FALSE 46.3125640 -117.9688720 0   13 53 53013 47460   Outlying Columbia County https://data.medicare.gov/resource/xubh-q36u/row-28j5-9jsv-a9rd 501302 648506 2019-05-23 2018-12-31 25           25         23     48
2060 2060 GRAHAM HOSPITAL ASSOCIATION 210 WEST WALNUT STREET CANTON IL 61520 FULTON (309) 647-5240 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.5532930 -90.0381150 0   57 17 17057 15900 Peoria-Canton, IL Central Fulton County https://data.medicare.gov/resource/xubh-q36u/row-xkp5.fehw.8cwr 140001 661308 2019-12-03 2019-06-30 38 5         43       20 18     81
2330 2330 WAR MEMORIAL HOSPITAL INC 1 HEALTHY WAY BERKELEY SPRINGS WV 25411 MORGAN (304) 258-1234 Critical Access Hospitals Voluntary non-profit - Private TRUE 39.6409230 -78.1998700 0   65 54 54065         https://data.medicare.gov/resource/xubh-q36u/row-z76q-7r93.w77s 511309 648370 2019-05-09 2018-12-31 25           25         16     41
3127 3127 ST JOSEPH'S HOSPITAL 1 AMALIA DRIVE BUCKHANNON WV 26201 UPSHUR (304) 472-2000 Critical Access Hospitals Voluntary non-profit - Private TRUE 38.9912750 -80.2368240 0   97 54 54097         https://data.medicare.gov/resource/xubh-q36u/row-dwxq.ey9z_ufif 511321 649690 2019-05-24 2018-12-31 21 4         25       10 16     51
4718 4718 LEVINDALE HEBREW GERIATRIC CENTER AND HOSPITAL 2434 WEST BELVEDERE AVENUE BALTIMORE MD 21209 BALTIMORE CITY (410) 601-2400 Acute Care Hospitals Voluntary non-profit - Private FALSE 39.3532660 -76.6650240 0   510 24 24510 12580 Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Central Baltimore city https://data.medicare.gov/resource/xubh-q36u/row-jrn6_danv~wppe 210064 659970 2019-12-02 2019-06-30 120           120       60 150     330
154 154 KUAKINI MEDICAL CENTER 347 NORTH KUAKINI STREET HONOLULU HI 96817 HONOLULU (808) 536-2236 Acute Care Hospitals Voluntary non-profit - Private TRUE 21.3222110 -157.8562110 0   3 15 15003 46520   Central Honolulu County https://data.medicare.gov/resource/xubh-q36u/row-haju_ivwx-iwr6 120007 656434 2018-12-26 2018-06-30 146 12 12       170       40 147     357
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
1045 1045 COLUMBIA BASIN HOSPITAL 200 NAT WASHINGTON WAY EPHRATA WA 98823 GRANT (509) 754-4631 Critical Access Hospitals Government - Hospital District or Authority TRUE 47.3157420 -119.5481250 0   25 53 53025 34180 Moses Lake-Othello, WA Central Grant County https://data.medicare.gov/resource/xubh-q36u/row-xhgk~wjue-em7x 501317 652555 2019-06-14 2018-12-31 25           25         12 32   69
4737 4737 SOUTHAMPTON MEMORIAL HOSPITAL 100 FAIRVIEW DRIVE - PO BOX 817 FRANKLIN VA 23851 FRANKLIN CITY (757) 569-6100 Acute Care Hospitals Proprietary TRUE 36.6911710 -76.9349420 0   620 51 51620         https://data.medicare.gov/resource/xubh-q36u/row-f6hb_is78~t7qx 490092 649152 2019-05-29 2018-12-31 67 8         75       13 116     204
1599 1599 TRINITAS REGIONAL MEDICAL CENTER 225 WILLIAMSON STREET ELIZABETH NJ 7207 UNION (908) 994-5000 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.6589200 -74.2143550 0   39 34 34039 35620 New York-Newark, NY-NJ-CT-PA Central Union County https://data.medicare.gov/resource/xubh-q36u/row-bb2x~8svn-dpqg 310027 649467 2019-06-03 2018-12-31 195 25         220 71   27 21 103     442
1 1 ASHLEY COUNTY MEDICAL CENTER 1015 UNITY ROAD CROSSETT AR 71635 ASHLEY (870) 364-4111 Critical Access Hospitals Voluntary non-profit - Private TRUE 33.1372060 -91.9387800 0   3 5 5003         https://data.medicare.gov/resource/xubh-q36u/row-gq3d.ak25_8qvw 41323 642385 2019-01-15 2018-09-30 19 6         25 10             35
2 2 HUGGINS HOSPITAL 240 SOUTH MAIN STREET WOLFEBORO NH 3894 CARROLL (603) 569-7500 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.5809440 -71.2015750 0   3 33 33003         https://data.medicare.gov/resource/xubh-q36u/row-u6j2-zv25.9ghd 301312 659991 2019-11-25 2018-09-30 21 4         25               25
3 3 WEEKS MEDICAL CENTER 173 MIDDLE STREET LANCASTER NH 3584 COOS (603) 788-4911 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.4869900 -71.5541560 0   7 33 33007 13620   Central Coos County https://data.medicare.gov/resource/xubh-q36u/row-4k9b_taaw_pmup 301303 643920 2019-02-28 2018-09-30 22 3         25               25
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
5 5 SEYMOUR HOSPITAL 200 STADIUM DRIVE SEYMOUR TX 76380 BAYLOR (940) 889-5572 Acute Care Hospitals Government - Hospital District or Authority TRUE 33.5897880 -99.2476970 0   23 48 48023         https://data.medicare.gov/resource/xubh-q36u/row-q4ba-nup8_2wqc 450586 659539 2019-11-20 2019-06-30 27           27               27
6 6 CENTRAL MONTANA MEDICAL CENTER 408 WENDELL AVE LEWISTOWN MT 59457 FERGUS (406) 535-7711 Critical Access Hospitals Voluntary non-profit - Private TRUE 47.0584640 -109.4422430 0   27 30 30027         https://data.medicare.gov/resource/xubh-q36u/row-hefc~6xn5~i2c7 271345 661545 2019-12-02 2019-06-30 23           23               23
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
8 8 ADVOCATE TRINITY HOSPITAL 2320 E 93RD ST CHICAGO IL 60617 COOK (773) 967-5002 Acute Care Hospitals Voluntary non-profit - Other TRUE 41.7262110 -87.5672500 0   31 17 17031 16980 Chicago-Naperville, IL-IN-WI Central Cook County https://data.medicare.gov/resource/xubh-q36u/row-wz9w.j9tr_sabj 140048 650686 2019-05-30 2018-12-31 177 24         201               201
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
10 10 GARFIELD COUNTY HEALTH CENTER 332 LEAVITT AVE JORDAN MT 59337 GARFIELD (406) 557-2500 Critical Access Hospitals Government - Local TRUE 47.3185240 -106.9113280 0   33 30 30033         https://data.medicare.gov/resource/xubh-q36u/row-xbp8~mipq.32d8 271310 659309 2019-11-18 2019-06-30 4           4       24       28
11 11 CROSSRIDGE COMMUNITY HOSPITAL 310 SOUTH FALLS BOULEVARD WYNNE AR 72396 CROSS (870) 238-3300 Critical Access Hospitals Voluntary non-profit - Private TRUE 35.2203530 -90.7874210 0   37 5 5037         https://data.medicare.gov/resource/xubh-q36u/row-9vam~w7bd~4ivg 41307 644210 2019-02-27 2018-09-30 15           15               15
12 12 CLARKE COUNTY HOSPITAL 800 S FILLMORE ST OSCEOLA IA 50213 CLARKE (641) 342-2184 Critical Access Hospitals Voluntary non-profit - Other TRUE 41.0257100 -93.7675330 0   39 19 19039         https://data.medicare.gov/resource/xubh-q36u/row-xtat~vhgt.9ane 161348 660976 2019-11-27 2019-06-30 25           25               25
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
14 14 DICKENSON COMMUNITY HOSPITAL 312 HOSPITAL DRIVE CLINTWOOD VA 24228 DICKENSON (276) 926-0300 Critical Access Hospitals Voluntary non-profit - Private TRUE 37.1598600 -82.4491020 0   51 51 51051 13720   Outlying Dickenson County https://data.medicare.gov/resource/xubh-q36u/row-gdzi~hhk4-fsm8 491303 659905 2019-11-21 2018-09-30 2           2 10             12
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
16 16 AVERA WESKOTA MEMORIAL MEDICAL CENTER - CAH 604 1ST ST NE WESSINGTON SPRINGS SD 57382 JERAULD (605) 539-1201 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.0803940 -98.5636820 0   73 46 46073         https://data.medicare.gov/resource/xubh-q36u/row-pcwb-j3y8~f5au 431324 662583 2019-11-27 2019-06-30 16           16               16
17 17 VAN DIEST MEDICAL CENTER 2350 HOSPITAL DRIVE WEBSTER CITY IA 50595 HAMILTON (515) 832-9400 Critical Access Hospitals Government - Local TRUE 42.4529630 -93.8134850 0   79 19 19079         https://data.medicare.gov/resource/xubh-q36u/row-89tb_yu6c_zwc4 161361 660984 2019-12-02 2019-06-30 25           25               25
18 18 HOUSTON COUNTY COMMUNITY HOSPITAL 5001 EAST MAIN STREET ERIN TN 37061 HOUSTON (931) 289-4211 Critical Access Hospitals Government - Local TRUE 36.3195160 -87.6891930 0   83 47 47083         https://data.medicare.gov/resource/xubh-q36u/row-dt3z.s9ya.age2 441322 639931 2018-12-03 2018-06-30 25           25               25
19 19 ASCENSION ST MARYS HOSPITAL 2251 NORTH SHORE DR RHINELANDER WI 54501 ONEIDA (715) 361-2000 Acute Care Hospitals Voluntary non-profit - Private TRUE 45.6384820 -89.3111400 0   85 55 55085         https://data.medicare.gov/resource/xubh-q36u/row-zwaq-mmw6_zwbm 520019 661677 2019-11-27 2019-06-30 32 20         52 11             63
20 20 MAYO CLINIC HEALTH SYSTEM - FAIRMONT 800 MEDICAL CENTER DRIVE, PO BOX 800 FAIRMONT MN 56031 MARTIN (507) 238-8101 Acute Care Hospitals Voluntary non-profit - Private TRUE 43.6376880 -94.4517280 0   91 27 27091         https://data.medicare.gov/resource/xubh-q36u/row-ifmr-5ze5~ircm 240166 649773 2019-05-30 2018-12-31 55           55               55
21 21 HORN MEMORIAL HOSPITAL 701 E 2ND ST IDA GROVE IA 51445 IDA (712) 364-3311 Critical Access Hospitals Voluntary non-profit - Private TRUE 42.3393030 -95.4589100 0   93 19 19093         https://data.medicare.gov/resource/xubh-q36u/row-ct62_kkw5_7j35 161354 649735 2019-06-03 2018-12-31 25           25               25
22 22 STILLWATER BILLINGS CLINIC 710 N 11TH ST COLUMBUS MT 59019 STILLWATER (406) 322-5316 Critical Access Hospitals Voluntary non-profit - Private TRUE 45.6426860 -109.2431780 0   95 30 30095         https://data.medicare.gov/resource/xubh-q36u/row-feve.dr4z_em5n 271330 662542 2019-11-29 2019-06-30 10           10               10
23 23 ST LUKE'S HOSPITAL - ANDERSON CAMPUS 1872 ST LUKE'S BLVD EASTON PA 18045 NORTHAMPTON (484) 503-3000 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.6500610 -75.2885310 0   95 42 42095 10900 New York-Newark, NY-NJ-CT-PA Central Northampton County https://data.medicare.gov/resource/xubh-q36u/row-y5pf.9der.4yfa 390326 660448 2019-12-02 2019-06-30 96 12         108               108
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
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
26 26 CITY HOSPITAL AT WHITE ROCK 9440 POPPY DR DALLAS TX 75218 DALLAS (214) 324-6100 Acute Care Hospitals Proprietary TRUE 32.8355210 -96.7050010 0   113 48 48113 19100 Dallas-Fort Worth, TX-OK Central Dallas County https://data.medicare.gov/resource/xubh-q36u/row-5mze~mvpw.a56k 450678 655846 2019-10-31 2019-05-31 167 20         187               187
27 27 NEMAHA COUNTY HOSPITAL 2022 13TH ST AUBURN NE 68305 NEMAHA (402) 274-4366 Critical Access Hospitals Government - Local TRUE 40.3920330 -95.8530200 0   127 31 31127         https://data.medicare.gov/resource/xubh-q36u/row-jgty.gwke-kfnb 281324 654855 2019-09-24 2019-04-30 16           16               16
28 28 MORTON COUNTY HOSPITAL 445 N HILLTOP ELKHART KS 67950 MORTON (620) 697-2141 Acute Care Hospitals Government - Local TRUE 37.0019009 -101.9053025 1 ROOFTOP 129 20 20129         https://data.medicare.gov/resource/xubh-q36u/row-uv4u~7jpi~swm6 170166 651519 2019-07-09 2018-12-31 26           26               26
29 29 OTTAWA COUNTY HEALTH CENTER 215 E 8TH STREET MINNEAPOLIS KS 67467 OTTAWA (785) 392-2122 Critical Access Hospitals Voluntary non-profit - Other TRUE 39.1287970 -97.7042550 0   143 20 20143 41460   Outlying Ottawa County https://data.medicare.gov/resource/xubh-q36u/row-bau7_rd4p~nxph 171328 659092 2018-12-07 2018-09-30 25           25           10   35
30 30 SOUTHSIDE COMMUNITY HOSPITAL, INC 800 OAK STREET FARMVILLE VA 23901 PRINCE EDWARD (434) 392-8811 Acute Care Hospitals Voluntary non-profit - Other TRUE 37.3033170 -78.4030580 0   147 51 51147         https://data.medicare.gov/resource/xubh-q36u/row-5efz.zpme_8ei2 490090 650408 2019-06-03 2018-12-31 78 8         86               86
31 31 ST MARKS MEDICAL CENTER ONE ST MARK'S PLACE LA GRANGE TX 78945 FAYETTE (979) 242-2200 Acute Care Hospitals Voluntary non-profit - Private TRUE 29.9353227 -96.8763382 1 ROOFTOP 149 48 48149         https://data.medicare.gov/resource/xubh-q36u/row-sffi-gqgq~nh45 670004 660902 2019-12-02 2019-06-30 38           38               38
33 33 RED BUD REGIONAL HOSPITAL 325 SPRING STREET RED BUD IL 62278 RANDOLPH (618) 282-3831 Critical Access Hospitals Proprietary TRUE 38.2096050 -89.9964080 0   157 17 17157         https://data.medicare.gov/resource/xubh-q36u/row-p29n.6wib~fbrj 141348 660526 2019-11-27 2019-06-30 25           25               25
34 34 FRIO REGIONAL HOSPITAL 200 S IH 35 PEARSALL TX 78061 FRIO (830) 334-3617 Critical Access Hospitals Voluntary non-profit - Private TRUE 28.8970480 -99.1160130 0   163 48 48163         https://data.medicare.gov/resource/xubh-q36u/row-9gys.vgtu~2pyx 451391 650214 2019-06-03 2018-12-31 24           24               24
35 35 HAWARDEN REGIONAL HEALTHCARE 1111 11TH STREET HAWARDEN IA 51023 SIOUX (712) 551-3100 Critical Access Hospitals Government - Local TRUE 42.9980080 -96.4794270 0   167 19 19167         https://data.medicare.gov/resource/xubh-q36u/row-i52u~xknc.njpg 161311 660957 2019-12-02 2019-06-30 25           25               25
36 36 THAYER COUNTY HEALTH SERVICES 120 PARK AVE HEBRON NE 68370 THAYER (402) 768-6041 Critical Access Hospitals Government - Local TRUE 40.1601230 -97.5932670 0   169 31 31169         https://data.medicare.gov/resource/xubh-q36u/row-b26e~mfmy~67qg 281304 660643 2019-11-27 2019-06-30 19           19               19
37 37 PRATTVILLE BAPTIST HOSPITAL 124 S MEMORIAL DR PRATTVILLE AL 36067 AUTAUGA (334) 361-4267 Acute Care Hospitals Government - Hospital District or Authority TRUE 32.4644230 -86.4509360 0   1 1 1001 33860   Central Autauga County https://data.medicare.gov/resource/xubh-q36u/row-62jx-izkm-znx2 10108 660906 2019-12-04 2019-06-30 49 6         55               55
38 38 FORT DEFIANCE INDIAN HOSPITAL PO BOX 649 FORT DEFIANCE AZ 86504 APACHE (928) 729-8000 Acute Care Hospitals Government - Federal TRUE 35.7593170 -109.0483992 1 GEOMETRIC_CENTER 1 4 4001         https://data.medicare.gov/resource/xubh-q36u/row-ss8d_atq6.7xb3 30071 651311 2019-07-02 2018-09-30 56           56               56
39 39 SAGE MEMORIAL HOSPITAL STATE ROUTE 264 SOUTH 191 GANADO AZ 86505 APACHE (928) 755-4541 Critical Access Hospitals Voluntary non-profit - Private FALSE 35.7108602 -109.5423597 1 ROOFTOP 1 4 4001         https://data.medicare.gov/resource/xubh-q36u/row-vmgp-erfi.puty 31309 652060 2019-05-06 2018-09-30 25           25               25
40 40 CHINLE COMPREHENSIVE HEALTH CARE FACILITY US HWY 191, HOSPITAL ROAD CHINLE AZ 86503 APACHE (928) 674-7001 Acute Care Hospitals Government - Federal TRUE 36.1575812 -109.6076963 1 GEOMETRIC_CENTER 1 4 4001         https://data.medicare.gov/resource/xubh-q36u/row-u7kj_iqgg.38d9 30084 649393 2019-06-12 2018-09-30 60           60               60
41 41 WHITE MOUNTAIN REGIONAL MEDICAL CENTER 118 SOUTH MOUNTAIN AVENUE SPRINGERVILLE AZ 85938 APACHE (928) 333-4368 Critical Access Hospitals Voluntary non-profit - Private TRUE 34.1321360 -109.2865450 0   1 4 4001         https://data.medicare.gov/resource/xubh-q36u/row-dkxh~vpbb.s52c 31315 652061 2019-05-30 2018-12-31 21           21               21
42 42 BAPTIST HEALTH MEDICAL CENTER-STUTTGART 1703 NORTH BUERKLE ST STUTTGART AR 72160 ARKANSAS (870) 673-3511 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.5177730 -91.5575720 0   1 5 5001         https://data.medicare.gov/resource/xubh-q36u/row-rh96.h2uy.6pb9 40072 649864 2019-05-31 2018-12-31 49           49               49
43 43 DEWITT HOSPITAL & NURSING HOME, INC 1641 WHITEHEAD DRIVE DE WITT AR 72042 ARKANSAS (870) 946-3571 Critical Access Hospitals Voluntary non-profit - Private TRUE 34.2795980 -91.3368920 0   1 5 5001         https://data.medicare.gov/resource/xubh-q36u/row-m6cy.wkj8_xepc 41314 660746 2019-12-05 2019-06-30 25           25       60       85
44 44 STANFORD HEALTH CARE - VALLEYCARE 5555 WEST LAS POSITAS BOULEVARD PLEASANTON CA 94588 ALAMEDA (925) 447-7000 Acute Care Hospitals Voluntary non-profit - Private TRUE 37.6921330 -121.8800270 0   1 6 6001 41860 San Jose-San Francisco-Oakland, CA Central Alameda County https://data.medicare.gov/resource/xubh-q36u/row-i8ak.uv35.9uup 50283 656398 2019-01-31 2018-08-31 144 23         167 14     26       207
45 45 ALTA BATES SUMMIT MEDICAL CENTER 350 HAWTHORNE AVENUE OAKLAND CA 94609 ALAMEDA (510) 655-4000 Acute Care Hospitals Voluntary non-profit - Private TRUE 37.8207840 -122.2632800 0   1 6 6001 41860 San Jose-San Francisco-Oakland, CA Central Alameda County https://data.medicare.gov/resource/xubh-q36u/row-8jij.khwv.ypce 50043 650562 2019-06-03 2018-12-31 260 36         296   58           354
46 46 EDEN MEDICAL CENTER 20103 LAKE CHABOT ROAD CASTRO VALLEY CA 94546 ALAMEDA (510) 537-1234 Acute Care Hospitals Voluntary non-profit - Other TRUE 37.6982685 -122.0903131 1 ROOFTOP 1 6 6001 41860 San Jose-San Francisco-Oakland, CA Central Alameda County https://data.medicare.gov/resource/xubh-q36u/row-qpf5_ajfv~drq5 50488 650953 2019-06-03 2018-12-31 106 24         130               130
47 47 ST ROSE HOSPITAL 27200 CALAROGA AVE HAYWARD CA 94545 ALAMEDA (510) 782-6200 Acute Care Hospitals Voluntary non-profit - Church TRUE 37.6329100 -122.0897420 0   1 6 6001 41860 San Jose-San Francisco-Oakland, CA Central Alameda County https://data.medicare.gov/resource/xubh-q36u/row-mad2-q4zt.hret 50002 644971 2019-03-06 2018-09-30 180 15         195               195
48 48 WASHINGTON HOSPITAL 2000 MOWRY AVE FREMONT CA 94538 ALAMEDA (510) 797-1111 Acute Care Hospitals Government - Hospital District or Authority TRUE 37.5576530 -121.9808700 0   1 6 6001 41860 San Jose-San Francisco-Oakland, CA Central Alameda County https://data.medicare.gov/resource/xubh-q36u/row-c4xt~2fw2_qi36 50195 659475 2019-11-21 2019-06-30 268 52         320               320
49 49 ALAMEDA HOSPITAL 2070 CLINTON AVENUE ALAMEDA CA 94501 ALAMEDA (510) 522-3700 Acute Care Hospitals Government - Hospital District or Authority TRUE 37.7632300 -122.2535410 0   1 6 6001 41860 San Jose-San Francisco-Oakland, CA Central Alameda County https://data.medicare.gov/resource/xubh-q36u/row-aten_zvra_dnju 50211 662328 2018-12-03 2018-06-30 29   5       34       181       215
50 50 KAISER FOUNDATION HOSPITAL - SAN LEANDRO 2500 MERCED STREET SAN LEANDRO CA 94577 ALAMEDA (510) 454-1000 Acute Care Hospitals Voluntary non-profit - Private TRUE 37.7065240 -122.1694470 0   1 6 6001 41860 San Jose-San Francisco-Oakland, CA Central Alameda County https://data.medicare.gov/resource/xubh-q36u/row-tv6k~4ts3.26zc 50777 652239 2019-06-06 2018-12-31 166 20         206               206
51 51 SAN LEANDRO HOSPITAL 13855 E 14TH STREET SAN LEANDRO CA 94578 ALAMEDA (510) 357-6500 Acute Care Hospitals Government - Hospital District or Authority TRUE 37.7146320 -122.1419730 0   1 6 6001 41860 San Jose-San Francisco-Oakland, CA Central Alameda County https://data.medicare.gov/resource/xubh-q36u/row-whtt-wfgb.a9rb 50773 657702 2018-12-03 2018-06-30 39 6         45               45
52 52 HIGHLAND HOSPITAL 1411 EAST 31ST STREET OAKLAND CA 94602 ALAMEDA (510) 437-4800 Acute Care Hospitals Government - Hospital District or Authority TRUE 37.7992340 -122.2311990 0   1 6 6001 41860 San Jose-San Francisco-Oakland, CA Central Alameda County https://data.medicare.gov/resource/xubh-q36u/row-j4fu_u24q~7stg 50320 662161 2019-11-27 2019-06-30 137 24         169 69 25   109       372
53 53 KAISER FOUNDATION HOSPITAL - OAKLAND/RICHMOND 275 WEST MACARTHUR BOULEVARD OAKLAND CA 94611 ALAMEDA (510) 752-1000 Acute Care Hospitals Voluntary non-profit - Private TRUE 37.8238570 -122.2575890 0   1 6 6001 41860 San Jose-San Francisco-Oakland, CA Central Alameda County https://data.medicare.gov/resource/xubh-q36u/row-s8y7~merd_qtct 50075 649024 2019-06-06 2018-12-31 291 50         365               365
54 54 KAISER FOUNDATION HOSPITAL - FREMONT 39400 PASEO PADRE PKWY FREMONT CA 94538 ALAMEDA (510) 784-4000 Acute Care Hospitals Voluntary non-profit - Private TRUE 37.5509130 -121.9757690 0   1 6 6001 41860 San Jose-San Francisco-Oakland, CA Central Alameda County https://data.medicare.gov/resource/xubh-q36u/row-niun-nmuu_4jxw 50512 652223 2019-06-06 2018-12-31 96 10         106               106

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