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

37 rows where acute_beds = 14 and hospital_type = "Critical Access Hospitals"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: state, hospital_ownership, emergency_services, geocode_flag, geocode_accuracy, statefips, cbsacode, csatitle, centraloutlyingcounty, countyequivalent, filed_date, fy_end_date, skilled_nursing_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
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
136 136 COPPER QUEEN COMMUNITY HOSPITAL 101 COLE AVENUE BISBEE AZ 85603 COCHISE (520) 432-6401 Critical Access Hospitals Voluntary non-profit - Private TRUE 31.4172540 -109.8826000 0   3 4 4003 43420   Central Cochise County https://data.medicare.gov/resource/xubh-q36u/row-3x2q~x9dv.fg6n 31312 659555 2019-11-25 2019-06-30 14           14               14
392 392 BENNETT COUNTY HOSPITAL AND NURSING HOME - CAH 102 MAJOR ALLEN POST OFFICE BOX 70D MARTIN SD 57551 BENNETT (605) 685-6622 Critical Access Hospitals Voluntary non-profit - Other TRUE 43.1691630 -101.7266636 1 RANGE_INTERPOLATED 7 46 46007         https://data.medicare.gov/resource/xubh-q36u/row-q2mg~bq2u~fi2w 431314 649823 2019-06-03 2018-12-31 14           14           48   62
795 795 BATH COMMUNITY HOSPITAL 106 PARK DRIVE- PO DRAWER Z HOT SPRINGS VA 24445 BATH (540) 839-7000 Critical Access Hospitals Voluntary non-profit - Private TRUE 37.9938900 -79.8309590 0   17 51 51017         https://data.medicare.gov/resource/xubh-q36u/row-36k3~dwrj~zvyd 491300 650420 2019-05-31 2018-12-31 14           14               14
844 844 SOUTH LYON MEDICAL CENTER 213 S WHITACRE/PO BOX 940 YERINGTON NV 89447 LYON (775) 781-3761 Critical Access Hospitals Government - Hospital District or Authority TRUE 38.9840873 -119.1669050 1 ROOFTOP 19 32 32019 22280 Reno-Carson City-Fernley, NV Central Lyon County https://data.medicare.gov/resource/xubh-q36u/row-ykja.hnhj~bmpe 291314 653342 2019-08-30 2019-03-31 14           14       49       63
950 950 LOST RIVERS MEDICAL CENTER 551 HIGHLAND DRIVE ARCO ID 83213 BUTTE (208) 252-7654 Critical Access Hospitals Government - Hospital District or Authority TRUE 43.6405520 -113.2962530 0   23 16 16023 26820 Idaho Falls-Rexburg-Blackfoot, ID Outlying Butte County https://data.medicare.gov/resource/xubh-q36u/row-77px.m9qb~bsww 131324 640856 2019-01-08 2018-09-30 14           14               14
978 978 BLUE MOUNTAIN HOSPITAL 170 FORD ROAD JOHN DAY OR 97845 GRANT (541) 575-1311 Critical Access Hospitals Government - Hospital District or Authority TRUE 44.4176510 -118.9592200 0   23 41 41023         https://data.medicare.gov/resource/xubh-q36u/row-svyy.cxkf.r4qf 381305 662576 2019-11-27 2019-06-30 14           14               14
998 998 MINNEOLA DISTRICT HOSPITAL NBR 2 212 MAIN MINNEOLA KS 67865 FORD (620) 885-4264 Critical Access Hospitals Government - Hospital District or Authority TRUE 37.4415040 -100.0138120 0   25 20 20025         https://data.medicare.gov/resource/xubh-q36u/row-qfsy_k4qi-ia9b 171368 651617 2019-06-24 2018-12-31 14           14           36   50
1116 1116 HAMPSHIRE MEMORIAL HOSPITAL 363 SUNRISE BOULEVARD ROMNEY WV 26757 HAMPSHIRE (304) 822-4561 Critical Access Hospitals Voluntary non-profit - Private TRUE 39.3320570 -78.6999130 0   27 54 54027 49020 Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Outlying Hampshire County https://data.medicare.gov/resource/xubh-q36u/row-hrq8-hhfd_c47u 511311 648371 2019-05-09 2018-12-31 14           14       30       44
1161 1161 LINTON HOSPITAL - CAH 518 NORTH BROADWAY LINTON ND 58552 EMMONS (701) 254-4511 Critical Access Hospitals Voluntary non-profit - Private TRUE 46.2710630 -100.2328710 0   29 38 38029         https://data.medicare.gov/resource/xubh-q36u/row-zu7c~i74a~kiv4 351328 651912 2019-07-15 2019-03-31 14           14               14
1612 1612 PEACEHEALTH COTTAGE GROVE COMMUNITY MEDICAL CENTER 1515 VILLAGE DRIVE COTTAGE GROVE OR 97424 LANE (541) 767-5202 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.8038370 -123.0386760 0   39 41 41039 21660   Central Lane County https://data.medicare.gov/resource/xubh-q36u/row-6buq_rs3k.th8r 381301 640536 2018-11-30 2018-06-30 14           14               14
1619 1619 SWEENY COMMUNITY HOSPITAL 305 NORTH MCKINNEY SWEENY TX 77480 BRAZORIA (979) 548-3311 Critical Access Hospitals Government - Hospital District or Authority TRUE 29.0485140 -95.6913920 0   39 48 48039 26420 Houston-The Woodlands, TX Central Brazoria County https://data.medicare.gov/resource/xubh-q36u/row-argn.cnxa-jdss 451311 643974 2019-03-01 2018-09-30 14           14               14
1622 1622 KLICKITAT VALLEY HOSPITAL 310 SOUTH ROOSEVELT GOLDENDALE WA 98620 KLICKITAT (509) 773-4022 Critical Access Hospitals Government - Hospital District or Authority TRUE 45.8202390 -120.8122990 0   39 53 53039         https://data.medicare.gov/resource/xubh-q36u/row-hemh_kxtf-bs6t 501316 649846 2019-06-03 2018-12-31 14           14               14
1623 1623 SKYLINE HOSPITAL 211 SKYLINE DRIVE WHITE SALMON WA 98672 KLICKITAT (509) 491-1101 Critical Access Hospitals Government - Hospital District or Authority TRUE 45.7224740 -121.4699210 0   39 53 53039         https://data.medicare.gov/resource/xubh-q36u/row-ff7m.q2hb.cpdx 501315 652445 2019-06-27 2018-12-31 14           14               14
2077 2077 DUNDY COUNTY HOSPITAL P O BOX 626, 1313 NORTH CHEYENNE ST BENKELMAN NE 69021 DUNDY (308) 423-2204 Critical Access Hospitals Government - Local TRUE 40.0565540 -101.5374470 1 ROOFTOP 57 31 31057         https://data.medicare.gov/resource/xubh-q36u/row-pych_p5gr-xzj5 281340 652885 2019-08-05 2019-02-28 14           14               14
2197 2197 FRANKLIN COUNTY MEMORIAL HOSPITAL 1406 Q ST FRANKLIN NE 68939 FRANKLIN (308) 425-6221 Critical Access Hospitals Government - Local TRUE 40.1015520 -98.9543530 0   61 31 31061         https://data.medicare.gov/resource/xubh-q36u/row-7jps~ae6v.42rk 281311 656707 2019-11-05 2019-06-30 14           14               14
2254 2254 SANFORD JACKSON MEDICAL CENTER 1430 NORTH HIGHWAY JACKSON MN 56143 JACKSON (507) 847-2420 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.6237230 -95.0045160 0   63 27 27063         https://data.medicare.gov/resource/xubh-q36u/row-xb4e.uhr4_fqc2 241315 649271 2019-05-28 2018-12-31 14           14               14
2490 2490 BAYSIDE COMMUNITY HOSPITAL 200 HOSPITAL DRIVE ANAHUAC TX 77514 CHAMBERS (409) 267-3143 Critical Access Hospitals Government - Hospital District or Authority TRUE 29.7530120 -94.6868500 0   71 48 48071 26420 Houston-The Woodlands, TX Central Chambers County https://data.medicare.gov/resource/xubh-q36u/row-zszx-nqzy-xwd5 451320 643853 2019-02-28 2018-09-30 14           14               14
2707 2707 HARRISON COUNTY COMMUNITY HOSPITAL 2600 MILLER STREET BETHANY MO 64424 HARRISON (660) 425-0284 Critical Access Hospitals Government - Hospital District or Authority TRUE 40.2652920 -94.0261450 0   81 29 29081         https://data.medicare.gov/resource/xubh-q36u/row-myhp~ktka_u8d3 261312 653250 2019-08-20 2019-03-31 14           14               14
2709 2709 MEMORIAL HOSPITAL 1423 SEVENTH ST AURORA NE 68818 HAMILTON (402) 694-3171 Critical Access Hospitals Voluntary non-profit - Private TRUE 40.8718120 -98.0095310 0   81 31 31081 24260   Outlying Hamilton County https://data.medicare.gov/resource/xubh-q36u/row-t366-wmec-vg9c 281320 643279 2019-02-12 2018-09-30 14           14           47   61
3173 3173 UNITY MEDICAL CENTER 164 W 13TH STREET GRAFTON ND 58237 WALSH (701) 352-1620 Critical Access Hospitals Voluntary non-profit - Private TRUE 48.4114840 -97.4138290 0   99 38 38099         https://data.medicare.gov/resource/xubh-q36u/row-xvyg.2uq7_fcwn 351320 660660 2019-12-03 2019-06-30 14           14               14
3174 3174 FIRST CARE HEALTH CENTER 115 VIVIAN ST PARK RIVER ND 58270 WALSH (701) 284-7500 Critical Access Hospitals Voluntary non-profit - Private TRUE 48.3992620 -97.7436790 0   99 38 38099         https://data.medicare.gov/resource/xubh-q36u/row-yjef.zes7.d4mf 351326 647924 2019-05-16 2018-12-31 14           14               14
3406 3406 CULBERSON HOSPITAL EISENHOWER ROAD AND FM 2185 VAN HORN TX 79855 CULBERSON (432) 283-2760 Critical Access Hospitals Proprietary FALSE 31.0496690 -104.8283880 0   109 48 48109         https://data.medicare.gov/resource/xubh-q36u/row-g73p-emdj_vjx2 451338 653287 2019-08-29 2019-03-31 14           14               14
3567 3567 CLEVELAND AREA HOSPITAL 1401 WEST PAWNEE CLEVELAND OK 74020 PAWNEE (918) 358-2501 Critical Access Hospitals Government - Hospital District or Authority TRUE 36.3098820 -96.4811210 0   117 40 40117 46140 Tulsa-Muskogee-Bartlesville, OK Outlying Pawnee County https://data.medicare.gov/resource/xubh-q36u/row-mn7t-r33n-bhn9 371320 647932 2019-05-20 2018-12-31 14           14               14
3735 3735 ASCENSION EAGLE RIVER HOSPITAL 201 HOSPITAL ROAD EAGLE RIVER WI 54521 VILAS (715) 479-7411 Critical Access Hospitals Voluntary non-profit - Private TRUE 45.9275180 -89.2516780 0   125 55 55125         https://data.medicare.gov/resource/xubh-q36u/row-unpa.6ptj.b2ji 521300 661443 2019-11-27 2019-06-30 14           14               14
3877 3877 COOK HOSPITAL 10 SE FIFTH ST COOK MN 55723 ST. LOUIS (218) 666-5945 Critical Access Hospitals Government - Hospital District or Authority TRUE 47.8534680 -92.6800320 0   137 27 27137 20260   Central St. Louis County https://data.medicare.gov/resource/xubh-q36u/row-buxd.3b5c~u3h4 241312 649042 2019-05-21 2018-12-31 14           14       28       42
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
3980 3980 CENTRACARE HEALTH SYSTEM - MELROSE HOSPITAL 525 WEST MAIN STREET MELROSE MN 56352 STEARNS (320) 256-1761 Critical Access Hospitals Voluntary non-profit - Private TRUE 45.6749160 -94.8234350 0   145 27 27145 41060 Minneapolis-St. Paul, MN-WI Central Stearns County https://data.medicare.gov/resource/xubh-q36u/row-zgd7-nfj6_jc2g 241330 660610 2019-11-27 2019-06-30 14           14       75       89
4024 4024 CORDELL MEMORIAL HOSPITAL 1220 NORTH GLENN ENGLISH STREET CORDELL OK 73632 WASHITA (580) 832-3339 Critical Access Hospitals Government - Local TRUE 35.3025240 -98.9875950 0   149 40 40149         https://data.medicare.gov/resource/xubh-q36u/row-k6qa-iqdm.jnj9 371325 660005 2019-12-03 2019-06-30 14           14               14
4049 4049 FISHER COUNTY HOSPITAL DISTRICT 774 STATE HIGHWAY 70 N ROTAN TX 79546 FISHER (325) 735-2256 Critical Access Hospitals Government - Hospital District or Authority TRUE 32.8343420 -100.4354190 0   151 48 48151         https://data.medicare.gov/resource/xubh-q36u/row-zpz3-mc6s_tqpq 451313 652799 2019-08-21 2018-12-31 14           14               14
4060 4060 CENTRACARE HEALTH SYSTEM - LONG PRAIRIE 50 CENTRACARE DRIVE LONG PRAIRIE MN 56347 TODD (320) 732-2141 Critical Access Hospitals Voluntary non-profit - Private TRUE 45.9733659 -94.8429923 1 ROOFTOP 153 27 27153         https://data.medicare.gov/resource/xubh-q36u/row-auf6_7hb8_cyed 241326 660609 2019-11-26 2019-06-30 14           14       70       84
4099 4099 ST ELIZABETH MEDICAL CENTER 1200 GRANT BLVD W WABASHA MN 55981 WABASHA (651) 565-4531 Critical Access Hospitals Proprietary TRUE 44.3864160 -92.0491400 0   157 27 27157 40340 Rochester-Austin, MN Outlying Wabasha County https://data.medicare.gov/resource/xubh-q36u/row-diq7.k9ja_4m53 241335 661737 2019-12-03 2019-06-30 14           14       100       114
4384 4384 HANSFORD COUNTY HOSPITAL 707 ROLAND ST SPEARMAN TX 79081 HANSFORD (806) 659-2535 Critical Access Hospitals Government - Hospital District or Authority TRUE 36.1904750 -101.2001270 0   195 48 48195         https://data.medicare.gov/resource/xubh-q36u/row-4gxw_72vt-83ub 451344 643658 2019-02-26 2018-09-30 14           14           8   22
4566 4566 HEART OF TEXAS MEMORIAL HOSPITAL 2008 NINE ROAD BRADY TX 76825 MC CULLOCH (325) 597-2901 Critical Access Hospitals Voluntary non-profit - Private TRUE 31.1163340 -99.3466000 0   307 48 48307         https://data.medicare.gov/resource/xubh-q36u/row-kqsv.fye9_9h3c 451348 653867 2019-09-03 2019-03-31 14           14               14
4605 4605 IRAAN GENERAL HOSPITAL 600 HIGHWAY 349 NORTH IRAAN TX 79744 PECOS (432) 639-2575 Critical Access Hospitals Government - Hospital District or Authority TRUE 30.9141890 -101.9066730 0   371 48 48371         https://data.medicare.gov/resource/xubh-q36u/row-gutj.3p8m~9z3e 451307 651245 2019-06-28 2018-12-31 14           14               14
4621 4621 SCHLEICHER COUNTY MEDICAL CENTER 102 NORTH US HIGHWAY 277 ELDORADO TX 76936 SCHLEICHER (325) 853-2507 Critical Access Hospitals Proprietary TRUE 30.8698690 -100.5903930 0   413 48 48413         https://data.medicare.gov/resource/xubh-q36u/row-ukk5-7d2r~gvs8 451304 649143 2019-05-21 2018-12-31 14           14               14
4662 4662 THROCKMORTON COUNTY MEMORIAL HOSPITAL 802 N MINTER AVENUE THROCKMORTON TX 76483 THROCKMORTON (940) 849-2151 Critical Access Hospitals Government - Local TRUE 33.1896520 -99.1772780 0   447 48 48447         https://data.medicare.gov/resource/xubh-q36u/row-ckdk-2pw4-m4du 451339 649839 2019-05-31 2018-12-31 14           14               14

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