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

42 rows where acute_beds = 18 and hospital_type = "Critical Access Hospitals"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: state, hospital_ownership, geocode_flag, geocode_accuracy, statefips, cbsacode, csatitle, centraloutlyingcounty, countyequivalent, filed_date, fy_end_date, icu_beds, coronary_beds, subtotal_acute_beds, subprovider_ipf_beds, skilled_nursing_beds, nursing_fac_beds, oth_longterm_beds, all_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
101 101 BARRETT HOSPITAL & HEALTHCARE 600 MT HWY 91 S DILLON MT 59725 BEAVERHEAD (406) 683-3000 Critical Access Hospitals Government - Hospital District or Authority TRUE 45.2006540 -112.6460030 0   1 30 30001         https://data.medicare.gov/resource/xubh-q36u/row-2tkn_v7av-d2ep 271318 662223 2019-11-27 2019-06-30 18           18               18
432 432 CLARA BARTON HOSPITAL 250 W 9TH STREET HOISINGTON KS 67544 BARTON (620) 653-2114 Critical Access Hospitals Voluntary non-profit - Private TRUE 38.5215490 -98.7794100 0   9 20 20009 24460   Central Barton County https://data.medicare.gov/resource/xubh-q36u/row-fy4c.k945-z7ft 171333 648920 2019-05-28 2018-12-31 18           18               18
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
758 758 COMMUNITY MEMORIAL HOSPITAL 512 SKYLINE BOULEVARD CLOQUET MN 55720 CARLTON (218) 879-4641 Critical Access Hospitals Voluntary non-profit - Private TRUE 46.7318440 -92.4624590 0   17 27 27017 20260   Outlying Carlton County https://data.medicare.gov/resource/xubh-q36u/row-wydg_i87y-v2ai 241364 645271 2019-02-27 2018-09-30 18   4       22       44       66
1051 1051 STOUGHTON HOSPITAL 900 RIDGE ST STOUGHTON WI 53589 DANE (608) 873-6611 Critical Access Hospitals Voluntary non-profit - Private TRUE 42.9203170 -89.2113190 0   25 55 55025 31540 Madison-Janesville-Beloit, WI Central Dane County https://data.medicare.gov/resource/xubh-q36u/row-wna6.q6dj_5p5b 521343 645623 2019-03-27 2018-09-30 18 4         22 10             32
1109 1109 DELTA COMMUNITY HOSPITAL 126 SOUTH WHITE SAGE AVENUE DELTA UT 84624 MILLARD (435) 864-5591 Critical Access Hospitals Proprietary TRUE 39.3502940 -112.5600230 0   27 49 49027         https://data.medicare.gov/resource/xubh-q36u/row-drqc-aprc.hcpi 461300 652115 2019-05-30 2018-12-31 18           18               18
1338 1338 WINDOM AREA HEALTH 2150 HOSPITAL DRIVE, PO BOX 339 WINDOM MN 56101 COTTONWOOD (507) 831-2400 Critical Access Hospitals Government - Local TRUE 43.8785870 -95.1136590 0   33 27 27033         https://data.medicare.gov/resource/xubh-q36u/row-9bd7-ibcv.unjw 241332 654451 2019-09-27 2019-04-30 18           18               18
1602 1602 COOPERSTOWN MEDICAL CENTER 1200 ROBERTS AVE NE COOPERSTOWN ND 58425 GRIGGS (701) 797-2221 Critical Access Hospitals Voluntary non-profit - Private TRUE 47.4456240 -98.1185500 0   39 38 38039         https://data.medicare.gov/resource/xubh-q36u/row-qi2g~gwic_kc3w 351306 660659 2019-11-25 2019-06-30 18           18               18
1620 1620 SANPETE VALLEY HOSPITAL - CAH 1100 SOUTH MEDICAL DRIVE MOUNT PLEASANT UT 84647 SANPETE (435) 462-4123 Critical Access Hospitals Voluntary non-profit - Private TRUE 39.5318030 -111.4611940 0   39 49 49039         https://data.medicare.gov/resource/xubh-q36u/row-44ik~upe5.vztv 461303 649841 2019-05-31 2018-12-31 18           18               18
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
1703 1703 SEILING MUNICIPAL HOSPITAL 809 NE HIGHWAY 60 SEILING OK 73663 DEWEY (580) 922-7361 Critical Access Hospitals Government - Local TRUE 36.1574590 -98.9207150 0   43 40 40043         https://data.medicare.gov/resource/xubh-q36u/row-79bz~vfcy-sppu 371332 660432 2019-11-29 2019-06-30 18           18               18
1719 1719 WASHAKIE MEDICAL CENTER 400 SOUTH 15TH STREET WORLAND WY 82401 WASHAKIE (307) 347-3221 Critical Access Hospitals Government - Local TRUE 44.0135560 -107.9484090 0   43 56 56043         https://data.medicare.gov/resource/xubh-q36u/row-wgjq-rwdt.3x58 531306 649859 2019-06-03 2018-12-31 18           18               18
1778 1778 MARGARET MARY HEALTH 321 MITCHELL AVE BATESVILLE IN 47006 FRANKLIN (812) 934-6624 Critical Access Hospitals Voluntary non-profit - Private TRUE 39.3061410 -85.2227030 0   47 18 18047         https://data.medicare.gov/resource/xubh-q36u/row-dzet~b6y3_gi2k 151329 649577 2019-06-03 2018-12-31 18 7         25               25
1843 1843 MAYO CLINIC HEALTH SYSTEM - LAKE CITY 500 WEST GRANT STREET LAKE CITY MN 55041 WABASHA (651) 345-5955 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.4583350 -92.2883650 0   49 27 27049 39860 Minneapolis-St. Paul, MN-WI Central Goodhue County https://data.medicare.gov/resource/xubh-q36u/row-xfrx_892y-jk4u 241338 649781 2019-05-30 2018-12-31 18           18       90       108
1919 1919 FULTON COUNTY HEALTH CENTER 725 SOUTH SHOOP AVENUE WAUSEON OH 43567 FULTON (419) 335-2015 Critical Access Hospitals Voluntary non-profit - Private TRUE 41.5391930 -84.1342830 0   51 39 39051 45780 Toledo-Port Clinton, OH Outlying Fulton County https://data.medicare.gov/resource/xubh-q36u/row-ccff~w7es.axa7 361333 649657 2019-06-03 2018-12-31 18 7         25 10     17       123
1951 1951 ELLSWORTH COUNTY MEDICAL CENTER 1604 AYLWARD AVENUE ELLSWORTH KS 67439 ELLSWORTH (785) 472-3111 Critical Access Hospitals Proprietary TRUE 38.7419690 -98.2188920 0   53 20 20053         https://data.medicare.gov/resource/xubh-q36u/row-gj2d~qekt_mg63 171327 659792 2019-11-18 2019-06-30 18           18               18
2034 2034 MANGUM REGIONAL MEDICAL CENTER 1 WICKERSHAM DRIVE MANGUM OK 73554 GREER (580) 782-3353 Critical Access Hospitals Proprietary TRUE 34.8918230 -99.5023410 0   55 40 40055         https://data.medicare.gov/resource/xubh-q36u/row-irnc.n45b.ecpm 371330 649816 2019-05-31 2018-12-31 18           18               18
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
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
2347 2347 MEMORIAL HOSPITAL 1454 N COUNTY ROAD 2050 E CARTHAGE IL 62321 HANCOCK (217) 357-8500 Critical Access Hospitals Voluntary non-profit - Private TRUE 40.4093060 -91.1113190 0   67 17 17067 22800   Outlying Hancock County https://data.medicare.gov/resource/xubh-q36u/row-mn5q.b2gd-fhfa 141305 649724 2019-06-18 2018-12-31 18           18               18
2424 2424 KANAKANAK HOSPITAL P O BOX 130 DILLINGHAM AK 99576 DILLINGHAM (907) 842-5201 Critical Access Hospitals Voluntary non-profit - Private TRUE 59.0397222 -158.4575000 1 GEOMETRIC_CENTER 70 2 2070         https://data.medicare.gov/resource/xubh-q36u/row-j4d4-bz29~h79d 21309 646376 2019-03-28 2018-09-30 18           18               18
2457 2457 GREELEY COUNTY HEALTH SERVICES 506 3RD STREET TRIBUNE KS 67879 GREELEY (620) 376-4221 Critical Access Hospitals Government - Local TRUE 38.4704770 -101.7497620 0   71 20 20071         https://data.medicare.gov/resource/xubh-q36u/row-3jpb-nuq6_kq8a 171359 647618 2019-05-07 2018-12-31 18           18           32   50
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
2619 2619 MERCY HEALTH - WILLARD HOSPITAL 1100 NEAL ZICK ROAD WILLARD OH 44890 HURON (419) 964-5000 Critical Access Hospitals Voluntary non-profit - Private TRUE 41.0485890 -82.7240000 0   77 39 39077 35940 Cleveland-Akron-Canton, OH Central Huron County https://data.medicare.gov/resource/xubh-q36u/row-2gzj.rp2x-kr88 361310 648306 2019-05-20 2018-12-31 18 2         20               20
2635 2635 ASTRIA SUNNYSIDE HOSPITAL 1016 TACOMA AVENUE SUNNYSIDE WA 98944 YAKIMA (509) 837-1500 Critical Access Hospitals Voluntary non-profit - Private TRUE 46.3222180 -120.0069660 0   77 53 53077 49420   Central Yakima County https://data.medicare.gov/resource/xubh-q36u/row-meen.vpbw_8fip 501330 652470 2019-07-22 2018-12-31 18 7         25               25
2668 2668 COCHRAN MEMORIAL HOSPITAL 205 E GRANT STREET MORTON TX 79346 COCHRAN (806) 266-5565 Critical Access Hospitals Government - Hospital District or Authority TRUE 33.7192940 -102.7580750 0   79 48 48079         https://data.medicare.gov/resource/xubh-q36u/row-cdg6.bkks~3hn7 451366 643985 2019-03-01 2018-09-30 18           18               18
2904 2904 REGIONAL HEALTH SERVICES OF HOWARD COUNTY 235 8TH AVENUE WEST CRESCO IA 52136 HOWARD (563) 547-2101 Critical Access Hospitals Government - Local TRUE 43.3818910 -92.1177640 0   89 19 19089         https://data.medicare.gov/resource/xubh-q36u/row-cg3w~i3hb_y7gu 161328 660965 2019-12-02 2019-06-30 18           18           1   19
3115 3115 JOHNSON COUNTY HOSPITAL 202 HIGH ST TECUMSEH NE 68450 JOHNSON (402) 335-3361 Critical Access Hospitals Government - Local TRUE 40.3791920 -96.1973420 0   97 31 31097         https://data.medicare.gov/resource/xubh-q36u/row-zhkd~ybts_qztb 281350 659707 2019-11-18 2019-06-30 18           18               18
3126 3126 MUENSTER MEMORIAL HOSPITAL 605 N MAPLE STREET MUENSTER TX 76252 COOKE (940) 759-2271 Critical Access Hospitals Government - Hospital District or Authority TRUE 33.6538650 -97.3798350 0   97 48 48097 23620 Dallas-Fort Worth, TX-OK Central Cooke County https://data.medicare.gov/resource/xubh-q36u/row-tkmv_gjc7.fa5r 451335 660475 2019-12-02 2019-06-30 18           18               18
3211 3211 OGALLALA COMMUNITY HOSPITAL 2601 NORTH SPRUCE ST OGALLALA NE 69153 KEITH (308) 284-4011 Critical Access Hospitals Government - Hospital District or Authority TRUE 41.1501770 -101.7204470 0   101 31 31101         https://data.medicare.gov/resource/xubh-q36u/row-g68g~zk9i.gtc5 281355 650174 2019-06-03 2018-12-31 18           18               18
3239 3239 AVERA FLANDREAU HOSPITAL - CAH 214 NORTH PRAIRIE STREET FLANDREAU SD 57028 MOODY (605) 997-2433 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.0505680 -96.5909890 0   101 46 46101         https://data.medicare.gov/resource/xubh-q36u/row-2fiy.k67h.w2yb 431310 660033 2019-11-26 2019-06-30 18           18               18
3330 3330 EDGERTON HOSPITAL AND HEALTH SERVICES 11101 N SHERMAN ROAD EDGERTON WI 53534 ROCK (608) 884-3441 Critical Access Hospitals Voluntary non-profit - Private TRUE 42.8348720 -89.0430240 0   105 55 55105 27500 Madison-Janesville-Beloit, WI Central Rock County https://data.medicare.gov/resource/xubh-q36u/row-rkcx-pybj.z58v 521319 650551 2019-05-31 2018-12-31 18           18               18
3561 3561 PIPESTONE COUNTY MEDICAL CENTER 916 4TH AVENUE SOUTHWEST PIPESTONE MN 56164 PIPESTONE (507) 825-5811 Critical Access Hospitals Government - Local TRUE 43.9910820 -96.3221070 0   117 27 27117         https://data.medicare.gov/resource/xubh-q36u/row-pzdb_wxvr-4ugg 241374 659508 2019-11-25 2019-06-30 18           18               18
3665 3665 MAYO CLINIC HEALTH SYSTEM-OAKRIDGE 13025 8TH ST OSSEO WI 54758 TREMPEALEAU (715) 597-3121 Critical Access Hospitals Voluntary non-profit - Other TRUE 44.5779110 -91.2163510 0   121 55 55121         https://data.medicare.gov/resource/xubh-q36u/row-vcjc-izvc_f2he 521302 649520 2019-05-28 2018-12-31 18           18               18
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
4016 4016 WAMEGO HEALTH CENTER 711 GENN DRIVE WAMEGO KS 66547 POTTAWATOMIE (785) 456-2295 Critical Access Hospitals Voluntary non-profit - Other TRUE 39.2055110 -96.3181930 0   149 20 20149 31740 Manhattan-Junction City, KS Outlying Pottawatomie County https://data.medicare.gov/resource/xubh-q36u/row-i7fc.5e2b.jxvz 171337 644276 2019-02-25 2018-09-30 18           18               18
4039 4039 SWIFT COUNTY BENSON HOSPITAL 1815 WISCONSIN AVENUE BENSON MN 56215 SWIFT (320) 843-4232 Critical Access Hospitals Government - Hospital District or Authority TRUE 45.3147570 -95.6089520 0   151 27 27151         https://data.medicare.gov/resource/xubh-q36u/row-zvec-8b67_2ine 241365 651013 2019-06-04 2018-12-31 18           18               18
4218 4218 PARKVIEW WABASH HOSPITAL, INC 10 JOHN KISSINGER DRIVE WABASH IN 46992 WABASH (260) 563-3131 Critical Access Hospitals Voluntary non-profit - Private TRUE 40.8187700 -85.8291260 0   169 18 18169 47340   Central Wabash County https://data.medicare.gov/resource/xubh-q36u/row-dnku-8krd-rp9e 151310 652350 2019-07-10 2018-12-31 18           18               18
4287 4287 SHERIDAN COUNTY HOSPITAL 826 18TH STREET HOXIE KS 67740 SHERIDAN (785) 675-3281 Critical Access Hospitals Government - Local TRUE 39.3541880 -100.4327350 0   179 20 20179         https://data.medicare.gov/resource/xubh-q36u/row-x8uv-c85y_dgpp 171347 647617 2019-05-06 2018-12-31 18           18           32   50
4294 4294 NORTON SOUND REGIONAL HOSPITAL 1000 GREG KRUSCHEK AVENUE (P O BOX 966) NOME AK 99762 NOME (907) 443-3311 Critical Access Hospitals Tribal TRUE 64.4992304 -165.3784042 1 ROOFTOP 180 2 2180         https://data.medicare.gov/resource/xubh-q36u/row-2xs3~z9eg.fia9 21308 646669 2019-04-15 2018-09-30 18           18       18       36
4331 4331 GRIMES ST JOSEPH HEALTH CENTER 210 JUDSON ST NAVASOTA TX 77868 GRIMES (936) 825-6585 Critical Access Hospitals Voluntary non-profit - Church TRUE 30.3928950 -96.0771680 0   185 48 48185         https://data.medicare.gov/resource/xubh-q36u/row-ng26_s56i-assy 451322 661419 2019-11-29 2019-06-30 18           18               18
4572 4572 MARTIN COUNTY HOSPITAL DISTRICT 600 E INTERSTATE 20 PO BOX 640 STANTON TX 79782 MARTIN (432) 756-3345 Critical Access Hospitals Government - Hospital District or Authority TRUE 32.1397988 -101.7870627 1 ROOFTOP 317 48 48317 33260 Midland-Odessa, TX Outlying Martin County https://data.medicare.gov/resource/xubh-q36u/row-b2bs_dpvv_us2e 451333 655474 2019-10-01 2019-04-30 18           18               18

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