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

40 rows where "filed_date" is on date 2019-12-03 and hospital_type = "Critical Access Hospitals"

View and edit SQL

Suggested facets: state, hospital_ownership, emergency_services, geocode_flag, geocode_accuracy, statefips, cbsacode, csatitle, centraloutlyingcounty, countyequivalent, acute_beds, icu_beds, coronary_beds, subtotal_acute_beds, subprovider_ipf_beds, subprovider_irf_beds, 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
319 CAMDEN GENERAL HOSPITAL 175 HOSPITAL DRIVE CAMDEN TN 38320 BENTON (731) 584-0109 Critical Access Hospitals Government - Hospital District or Authority TRUE 36.0557800 -88.1075170 0   5 47 47005         https://data.medicare.gov/resource/xubh-q36u/row-rp5g~twzk~kf69 441316 660045 2019-12-03 2019-06-30 25           25               25
365 BROADWATER HEALTH CENTER 110 N OAK ST TOWNSEND MT 59644 BROADWATER (406) 266-3186 Critical Access Hospitals Voluntary non-profit - Private TRUE 46.3213540 -111.5164280 0   7 30 30007         https://data.medicare.gov/resource/xubh-q36u/row-3bqc_c9ze~3cij 271333 662052 2019-12-03 2019-06-30 25           25               25
406 MARK TWAIN MEDICAL CENTER 768 MOUNTAIN RANCH RD SAN ANDREAS CA 95249 CALAVERAS (209) 754-2515 Critical Access Hospitals Voluntary non-profit - Other FALSE 38.1909730 -120.6706610 0   9 6 6009         https://data.medicare.gov/resource/xubh-q36u/row-vzvr.d5an~vpec 51332 660493 2019-12-03 2019-06-30 25           25               25
436 BUNKIE GENERAL HOSPITAL 427 EVERGREEN STREET BUNKIE LA 71322 AVOYELLES (318) 346-6681 Critical Access Hospitals Government - Hospital District or Authority TRUE 30.9524260 -92.1766470 0   9 22 22009         https://data.medicare.gov/resource/xubh-q36u/row-56d9~jh8q~59bh 191311 662210 2019-12-03 2019-06-30 25           25               25
451 ALICE PECK DAY MEMORIAL HOSPITAL 10 ALICE PECK DAY DRIVE LEBANON NH 3766 GRAFTON (603) 448-3121 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.6402930 -72.2643660 0   9 33 33009 17200   Central Grafton County https://data.medicare.gov/resource/xubh-q36u/row-t8xb_fse9~ukfj 301305 661743 2019-12-03 2019-06-30 24           24               24
474 MEMORIAL HOSPITAL OF CONVERSE COUNTY 111 SOUTH 5TH STREET DOUGLAS WY 82633 CONVERSE (307) 358-2122 Critical Access Hospitals Government - Local TRUE 42.7588050 -105.3812790 0   9 56 56009         https://data.medicare.gov/resource/xubh-q36u/row-zei4~mbih_rgkv 531302 662095 2019-12-03 2019-06-30 25           25               25
738 NORTH CADDO MEDICAL CENTER 815 SOUTH PINE STREET VIVIAN LA 71082 CADDO (318) 375-3235 Critical Access Hospitals Government - Hospital District or Authority TRUE 32.8634600 -93.9877170 0   17 22 22017 43340   Central Caddo Parish https://data.medicare.gov/resource/xubh-q36u/row-b4zm~5u3q.sne4 191304 662209 2019-12-03 2019-06-30 25           25               25
872 JOHNSON COUNTY HEALTHCARE CENTER 497 WEST LOTT BUFFALO WY 82834 JOHNSON (307) 684-5521 Critical Access Hospitals Government - Hospital District or Authority TRUE 44.3497880 -106.7072480 0   19 56 56019         https://data.medicare.gov/resource/xubh-q36u/row-jfvm_9yjt_xtnf 531308 662298 2019-12-03 2019-06-30 22           22           3   69
883 GLENN MEDICAL CENTER 1133 W SYCAMORE ST WILLOWS CA 95988 GLENN (530) 934-1818 Critical Access Hospitals Government - Federal TRUE 39.5204670 -122.2081200 0   21 6 6021         https://data.medicare.gov/resource/xubh-q36u/row-7nst_26uq.zcvx 51306 662484 2019-12-03 2019-06-30 15           15               15
884 SAN LUIS VALLEY HEALTH CONEJOS COUNTY HOSPITAL 19021 US HIGHWAY 285 LA JARA CO 81140 CONEJOS (719) 274-5121 Critical Access Hospitals Voluntary non-profit - Private TRUE 37.2637500 -105.9640950 0   21 8 8021         https://data.medicare.gov/resource/xubh-q36u/row-2ncf.isv7_93r9 61308 662179 2019-12-03 2019-06-30 17           17               17
1349 GALION COMMUNITY HOSPITAL 269 PORTLAND WAY SOUTH GALION OH 44833 CRAWFORD (419) 468-4841 Critical Access Hospitals Voluntary non-profit - Church FALSE 40.7311430 -82.8032960 0   33 39 39033 15340 Mansfield-Ashland-Bucyrus, OH Central Crawford County https://data.medicare.gov/resource/xubh-q36u/row-5krw_yxr7-22n8 361325 661619 2019-12-03 2019-06-30 22 3         25   10           35
1350 BUCYRUS COMMUNITY HOSPITAL 629 NORTH SANDUSKY AVENUE BUCYRUS OH 44820 CRAWFORD (419) 562-4677 Critical Access Hospitals Voluntary non-profit - Other TRUE 40.8156980 -82.9756040 0   33 39 39033 15340 Mansfield-Ashland-Bucyrus, OH Central Crawford County https://data.medicare.gov/resource/xubh-q36u/row-aujg-sixr-jmqg 361316 661617 2019-12-03 2019-06-30 19 6         25               25
1645 HERINGTON MUNICIPAL HOSPITAL 100 E HELEN STREET HERINGTON KS 67449 DICKINSON (785) 258-2207 Critical Access Hospitals Voluntary non-profit - Other TRUE 38.6795610 -96.9422740 0   41 20 20041         https://data.medicare.gov/resource/xubh-q36u/row-sgwx~evd5.tciy 171340 661326 2019-12-03 2019-06-30 15           15               15
2086 FULTON COUNTY MEDICAL CENTER 214 PEACH ORCHARD ROAD MCCONNELLSBURG PA 17233 FULTON (717) 485-3155 Critical Access Hospitals Voluntary non-profit - Private TRUE 39.9367160 -78.0090000 0   57 42 42057         https://data.medicare.gov/resource/xubh-q36u/row-wvyv.r4u3.6wb9 391303 660450 2019-12-03 2019-06-30 21           21       67       88
2268 HOLDENVILLE GENERAL HOSPITAL 100 MCDOUGAL DRIVE HOLDENVILLE OK 74848 HUGHES (405) 379-4200 Critical Access Hospitals Government - Hospital District or Authority TRUE 35.0882130 -96.3782650 0   63 40 40063         https://data.medicare.gov/resource/xubh-q36u/row-sj8k.rz7i~rzh6 371321 660004 2019-12-03 2019-06-30 25           25               25
2311 SALEM MEMORIAL DISTRICT HOSPITAL PO BOX 774, SALEM MO 65560 DENT (573) 729-6626 Critical Access Hospitals Government - Hospital District or Authority TRUE 37.6604402 -91.5692851 1 ROOFTOP 65 29 29065         https://data.medicare.gov/resource/xubh-q36u/row-wiw4-tpja~sz74 261318 661354 2019-12-03 2019-06-30 25           25           18   43
2381 SUMMERSVILLE REGIONAL MEDICAL CENTER 400 FAIRVIEW HEIGHTS ROAD SUMMERSVILLE WV 26651 NICHOLAS (304) 872-2891 Critical Access Hospitals Government - Local TRUE 38.2919030 -80.8311360 0   67 54 54067         https://data.medicare.gov/resource/xubh-q36u/row-a2eh.63jr_sfyc 511322 661675 2019-12-03 2019-06-30 19 6         25       52       77
2415 BOLIVAR GENERAL HOSPITAL 650 NUCKOLLS ROAD BOLIVAR TN 38008 HARDEMAN (731) 658-3100 Critical Access Hospitals Government - Hospital District or Authority TRUE 35.2679530 -89.0005770 0   69 47 47069         https://data.medicare.gov/resource/xubh-q36u/row-xpdy_i9ip-a66t 441320 660046 2019-12-03 2019-06-30 25           25               25
2555 LAWRENCE MEMORIAL HOSPITAL 1309 WEST MAIN STREET WALNUT RIDGE AR 72476 LAWRENCE (870) 886-1200 Critical Access Hospitals Government - Local TRUE 36.0747010 -90.9669820 0   75 5 5075         https://data.medicare.gov/resource/xubh-q36u/row-jpmn_3ec8~urk8 41309 661136 2019-12-03 2019-06-30 25           25               25
2636 PRESTON MEMORIAL HOSPITAL 150 MEMORIAL DRIVE KINGWOOD WV 26537 PRESTON (304) 329-1400 Critical Access Hospitals Voluntary non-profit - Private TRUE 39.4656410 -79.6763980 0   77 54 54077 34060 Morgantown-Fairmont, WV Outlying Preston County https://data.medicare.gov/resource/xubh-q36u/row-6xzk~kxqz_ca3u 511312 661674 2019-12-03 2019-06-30 25           25               25
2658 EASTERN OKLAHOMA MEDICAL CENTER 105 WALL STREET POTEAU OK 74953 LE FLORE (918) 647-8161 Critical Access Hospitals Government - Hospital District or Authority TRUE 35.0439790 -94.6128340 0   79 40 40079 22900   Outlying Le Flore County https://data.medicare.gov/resource/xubh-q36u/row-4db9~xpsx-e222 371337 662241 2019-12-03 2019-06-30 21 4         25 10             35
2989 MERCY MEDICAL CENTER MT SHASTA 914 PINE STREET MOUNT SHASTA CA 96067 SISKIYOU (530) 926-6111 Critical Access Hospitals Voluntary non-profit - Other TRUE 41.3177640 -122.3215540 0   93 6 6093         https://data.medicare.gov/resource/xubh-q36u/row-z3p6.8j4z_mz6s 51319 662174 2019-12-03 2019-06-30 21 4         25               25
2993 ST VINCENT DUNN HOSPITAL INC 1600 23RD ST BEDFORD IN 47421 LAWRENCE (812) 276-1065 Critical Access Hospitals Voluntary non-profit - Private TRUE 38.8534880 -86.4931940 0   93 18 18093 13260 Bloomington-Bedford, IN Central Lawrence County https://data.medicare.gov/resource/xubh-q36u/row-i3na-nck9_frex 151335 661320 2019-12-03 2019-06-30 25           25               25
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
3273 BELL HOSPITAL 901 LAKESHORE DRIVE ISHPEMING MI 49849 MARQUETTE (906) 486-4431 Critical Access Hospitals Proprietary TRUE 46.4986650 -87.6829930 0   103 26 26103 32100   Central Marquette County https://data.medicare.gov/resource/xubh-q36u/row-ag2p-d743~hfr4 231321 661204 2019-12-03 2019-06-30 21   4       25               25
3450 CONEMAUGH MEYERSDALE MEDICAL CENTER 200 HOSPITAL DRIVE MEYERSDALE PA 15552 SOMERSET (814) 634-5911 Critical Access Hospitals Proprietary TRUE 39.8092810 -79.0253380 0   111 42 42111 43740 Johnstown-Somerset, PA Central Somerset County https://data.medicare.gov/resource/xubh-q36u/row-zfec_mecz_mmru 391302 660304 2019-12-03 2019-06-30 20           20               20
3751 MERCY HEALTH LAKESHORE CAMPUS 72 SOUTH STATE STREET SHELBY MI 49455 OCEANA (231) 861-2156 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.6070530 -86.3651500 0   127 26 26127         https://data.medicare.gov/resource/xubh-q36u/row-4je3~28uk~h2y8 231320 661203 2019-12-03 2019-06-30 24           24               24
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
3806 MITCHELL COUNTY REGIONAL HEALTH 616 NORTH EIGHTH STREET OSAGE IA 50461 MITCHELL (641) 732-6000 Critical Access Hospitals Voluntary non-profit - Other TRUE 43.2890760 -92.8094820 0   131 19 19131         https://data.medicare.gov/resource/xubh-q36u/row-vd49.a3jn-dt4a 161323 661180 2019-12-03 2019-06-30 25           25               25
3809 MARY BRECKINRIDGE ARH HOSPITAL 130 KATE IRELAND DRIVE HYDEN KY 41749 LESLIE (606) 672-2901 Critical Access Hospitals Voluntary non-profit - Private TRUE 37.1638890 -83.3783600 0   131 21 21131         https://data.medicare.gov/resource/xubh-q36u/row-ms82.xh5f.a6zw 181316 661511 2019-12-03 2019-06-30 25           25               25
3825 ST MARY'S GOOD SAMARITAN HOSPITAL 5401 LAKE OCONEE PARKWAY GREENSBORO GA 30642 GREENE (706) 453-7331 Critical Access Hospitals Proprietary TRUE 33.4799210 -83.2416450 0   133 13 13133         https://data.medicare.gov/resource/xubh-q36u/row-bqbp~uisy-u894 111329 660372 2019-12-03 2019-06-30 25           25               25
3965 RHEA MEDICAL CENTER 9400 RHEA COUNTY HIGHWAY DAYTON TN 37321 RHEA (423) 775-1121 Critical Access Hospitals Government - Local TRUE 35.5303740 -84.9823340 0   143 47 47143 19420 Chattanooga-Cleveland-Dalton, TN-GA-AL Central Rhea County https://data.medicare.gov/resource/xubh-q36u/row-nzwz~fwja_c4gt 441310 661109 2019-12-03 2019-06-30 22 3         25               25
4014 FLOYD VALLEY HEALTHCARE 714 LINCOLN ST NE LE MARS IA 51031 PLYMOUTH (712) 546-7871 Critical Access Hospitals Proprietary TRUE 42.7972800 -96.1559900 0   149 19 19149 43580 Sioux City-Vermillion, IA-SD-NE Outlying Plymouth County https://data.medicare.gov/resource/xubh-q36u/row-dyg7.rs5y.hwrt 161368 661183 2019-12-03 2019-06-30 25           25               25
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
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
4104 TRINITY HOSPITAL TWIN CITY 819 NORTH FIRST STREET DENNISON OH 44621 TUSCARAWAS (740) 922-2800 Critical Access Hospitals Voluntary non-profit - Church TRUE 40.4014640 -81.3358740 0   157 39 39157 35420 Cleveland-Akron-Canton, OH Central Tuscarawas County https://data.medicare.gov/resource/xubh-q36u/row-yjye.hnn5~27ky 361302 661614 2019-12-03 2019-06-30 25           25               25
4207 ST FRANCIS MEDICAL CENTER 2400 ST FRANCIS DRIVE BRECKENRIDGE MN 56520 WILKIN (218) 643-3000 Critical Access Hospitals Voluntary non-profit - Church TRUE 46.2913140 -96.5904330 0   167 27 27167 47420 Fargo-Wahpeton, ND-MN Outlying Wilkin County https://data.medicare.gov/resource/xubh-q36u/row-z674~sdts.8mhw 241377 661740 2019-12-03 2019-06-30 25           25       80       105
4231 SCOTT COUNTY HOSPITAL 201 ALBERT AVENUE SCOTT CITY KS 67871 SCOTT (620) 872-5811 Critical Access Hospitals Voluntary non-profit - Private TRUE 38.4848700 -100.9035000 0   171 20 20171         https://data.medicare.gov/resource/xubh-q36u/row-3s9g-yvmr~yjua 171372 661186 2019-12-03 2019-06-30 25           25               25
4245 ST VINCENT WARRICK 1116 MILLIS AVE BOONVILLE IN 47601 WARRICK (812) 897-4800 Critical Access Hospitals Voluntary non-profit - Private TRUE 38.0413560 -87.2633740 0   173 18 18173 21780   Central Warrick County https://data.medicare.gov/resource/xubh-q36u/row-7qwf.qysm-8pah 151325 661170 2019-12-03 2019-06-30 25           25 10             35
4266 MORGAN COUNTY ARH HOSPITAL 476 LIBERTY ROAD WEST LIBERTY KY 41472 MORGAN (606) 743-3186 Critical Access Hospitals Voluntary non-profit - Private TRUE 37.9201370 -83.2662760 0   175 21 21175         https://data.medicare.gov/resource/xubh-q36u/row-aia2-xvbh~gtxt 181307 662531 2019-12-03 2019-06-30 25           25               25

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