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

47 rows where acute_beds = 24 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, fy_end_date, icu_beds, subtotal_acute_beds, subprovider_ipf_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
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
139 139 NORTHERN COCHISE COMMUNITY HOSPITAL, INC. 901 WEST REX ALLEN DRIVE WILLCOX AZ 85643 COCHISE (520) 384-3541 Critical Access Hospitals Government - Hospital District or Authority TRUE 32.2642680 -109.8376130 0   3 4 4003 43420   Central Cochise County https://data.medicare.gov/resource/xubh-q36u/row-ydad~45b6.8t7t 31302 660487 2019-12-02 2019-06-30 24           24       24       48
187 187 P H S INDIAN HOSPITAL CROW / NORTHERN CHEYENNE 1010 SOUTH 7650 EAST, POST OFFICE BOX 9 CROW AGENCY MT 59022 BIG HORN (406) 638-2626 Critical Access Hospitals Government - Federal TRUE 45.5821958 -107.4488586 1 ROOFTOP 3 30 30003         https://data.medicare.gov/resource/xubh-q36u/row-pgmt~4b42~eq7a 271339 646565 2019-03-26 2018-09-30 24           24               24
344 344 ORCHARD HOSPITAL 240 SPRUCE STREET GRIDLEY CA 95948 BUTTE (530) 846-5671 Critical Access Hospitals Voluntary non-profit - Private TRUE 39.3669740 -121.6897170 0   7 6 6007 17020   Central Butte County https://data.medicare.gov/resource/xubh-q36u/row-kvk2_zuau.b3ab 51311 640345 2018-12-03 2018-06-30 24           24       52       76
381 381 BEAVER COUNTY MEMORIAL HOSPITAL 212 EAST 8TH STREET BEAVER OK 73932 BEAVER (580) 625-4551 Critical Access Hospitals Government - Hospital District or Authority TRUE 36.8101950 -100.5164240 0   7 40 40007         https://data.medicare.gov/resource/xubh-q36u/row-97xz.ezcx-saem 371322 659862 2019-11-22 2019-06-30 24           24               24
451 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
616 616 BARAGA COUNTY MEMORIAL HOSPITAL 18341 US HIGHWAY 41 L' ANSE MI 49946 BARAGA (906) 524-3300 Critical Access Hospitals Government - Local TRUE 46.7344600 -88.4280420 0   13 26 26013         https://data.medicare.gov/resource/xubh-q36u/row-kzgx-j54h-paej 231307 645568 2019-03-05 2018-09-30 24           24               24
689 689 MAYO CLINIC HEALTH SYSTEM-SPRINGFIELD 625 JACKSON AVENUE NORTH SPRINGFIELD MN 56087 BROWN (507) 723-6201 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.2457470 -94.9716490 0   15 27 27015 35580 Mankato-New Ulm-North Mankato, MN Central Brown County https://data.medicare.gov/resource/xubh-q36u/row-fczk.ip7t_6vg8 241352 649910 2019-05-30 2018-12-31 24           24               24
690 690 NEW ULM MEDICAL CENTER 1324 FIFTH NORTH STREET NEW ULM MN 56073 BROWN (507) 217-5000 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.3125040 -94.4751740 0   15 27 27015 35580 Mankato-New Ulm-North Mankato, MN Central Brown County https://data.medicare.gov/resource/xubh-q36u/row-ebnr~hsq4-36pd 241378 649788 2019-05-23 2018-12-31 24           24 10             34
870 870 ASCENSION OUR LADY OF VICTORY HOSPITAL 1120 PINE ST STANLEY WI 54768 CHIPPEWA (715) 644-5571 Critical Access Hospitals Voluntary non-profit - Other TRUE 44.9553110 -90.9205640 0   19 55 55019         https://data.medicare.gov/resource/xubh-q36u/row-xzzk-sbky-rj53 521311 661445 2019-11-27 2019-06-30 24           24               24
986 986 CROSSING RIVERS HEALTH MEDICAL CENTER 37868 US HWY 18 PRAIRIE DU CHIEN WI 53821 CRAWFORD (608) 357-2000 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.0139990 -91.0945020 0   23 55 55023         https://data.medicare.gov/resource/xubh-q36u/row-43cp~si3w~xt56 521330 649381 2019-05-24 2018-12-31 24           24           1   25
1120 1120 NIOBRARA HEALTH & LIFE CENTER 921 SOUTH BALLANCEE AVENUE LUSK WY 82225 NIOBRARA (307) 334-4000 Critical Access Hospitals Government - Hospital District or Authority TRUE 42.7532780 -104.4460830 0   27 56 56027         https://data.medicare.gov/resource/xubh-q36u/row-ee9k~358g.gwyk 531314 640304 2018-12-03 2018-06-30 24           24               24
1131 1131 KERN VALLEY HEALTHCARE DISTRICT 6412 LAUREL AVE LAKE ISABELLA CA 93240 KERN (760) 379-2681 Critical Access Hospitals Government - Hospital District or Authority TRUE 35.6353510 -118.4063000 0   29 6 6029 12540   Central Kern County https://data.medicare.gov/resource/xubh-q36u/row-vmmb-dmgx.ncbv 51314 652738 2018-12-04 2018-06-30 24           24       74       98
1546 1546 FRANKLIN COUNTY MEMORIAL HOSPITAL 40 UNION CHURCH RD MEADVILLE MS 39653 FRANKLIN (601) 384-5801 Critical Access Hospitals Government - Local TRUE 31.4732480 -90.8849240 0   37 28 28037         https://data.medicare.gov/resource/xubh-q36u/row-bz6b_zt43.ihwe 251330 655016 2019-10-02 2019-04-30 24           24               24
1560 1560 LAKE DISTRICT HOSPITAL 700 SOUTH J STREET LAKEVIEW OR 97630 LAKE (541) 947-2114 Critical Access Hospitals Government - Hospital District or Authority TRUE 42.1815830 -120.3514370 0   37 41 41037         https://data.medicare.gov/resource/xubh-q36u/row-2rpx~hmxp~n924 381309 640591 2018-12-10 2018-06-30 24           24               24
1733 1733 SOCORRO GENERAL HOSPITAL 1202 HIGHWAY 60 WEST SOCORRO NM 87801 SOCORRO (575) 835-1140 Critical Access Hospitals Proprietary TRUE 34.0387210 -106.9120140 0   53 35 35053         https://data.medicare.gov/resource/xubh-q36u/row-93zp~dbrk.vq66 321301 651646 2019-06-27 2018-12-31 24           24               24
1737 1737 CASEY COUNTY HOSPITAL 187 WOLFORD AVENUE LIBERTY KY 42539 CASEY (606) 787-6275 Critical Access Hospitals Government - Hospital District or Authority TRUE 37.3178090 -84.9317170 0   45 21 21045         https://data.medicare.gov/resource/xubh-q36u/row-aju2-kjdy-yhzq 181309 662532 2019-11-27 2019-06-30 24           24               24
1746 1746 RIVER HOSPITAL CLINICS 4 FULLER STREET ALEXANDRIA BAY NY 13607 JEFFERSON (315) 482-2511 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.3372170 -75.9200220 0   45 36 36045 48060   Central Jefferson County https://data.medicare.gov/resource/xubh-q36u/row-7zvs~rszm-n4ux 331309 650324 2019-05-31 2018-12-31 24           24               24
1918 1918 WISHEK COMMUNITY HOSPITAL 1007 4TH AVE S WISHEK ND 58495 MCINTOSH (701) 452-2326 Critical Access Hospitals Government - Local TRUE 46.2551230 -99.5515380 0   51 38 38051         https://data.medicare.gov/resource/xubh-q36u/row-zinj~5aa6.fhse 351321 648453 2019-05-20 2018-12-31 24           24               24
1969 1969 MCKENZIE COUNTY HEALTHCARE SYSTEMS INC 709 4TH AVE NE WATFORD CITY ND 58854 MCKENZIE (701) 842-3000 Critical Access Hospitals Voluntary non-profit - Private TRUE 47.8046820 -103.2713580 0   53 38 38053         https://data.medicare.gov/resource/xubh-q36u/row-ph32.gcyn.yevx 351302 652530 2018-12-03 2018-06-30 24           24       47       71
2196 2196 MINERAL COMMUNITY HOSPITAL 1208 6TH AVE E SUPERIOR MT 59872 MINERAL (406) 822-4841 Critical Access Hospitals Voluntary non-profit - Private TRUE 47.1847260 -114.8765790 0   61 30 30061         https://data.medicare.gov/resource/xubh-q36u/row-j5f4.vdmh-uusx 271331 660639 2019-11-22 2019-06-30 24           24               24
2539 2539 HERMANN AREA DISTRICT HOSPITAL 509 W 18TH ST HERMANN MO 65041 GASCONADE (573) 486-2191 Critical Access Hospitals Government - Hospital District or Authority TRUE 38.6923090 -91.4486150 0   73 29 29073         https://data.medicare.gov/resource/xubh-q36u/row-68da_4zxk~68nb 261314 650845 2019-06-26 2018-12-31 24           24               24
2657 2657 HOLZER MEDICAL CENTER JACKSON 500 BURLINGTON ROAD JACKSON OH 45640 JACKSON (740) 395-8500 Critical Access Hospitals Voluntary non-profit - Private TRUE 39.0326610 -82.6381800 0   79 39 39079 27160   Central Jackson County https://data.medicare.gov/resource/xubh-q36u/row-uzg6.66qw~z7aa 361320 660677 2019-11-26 2019-06-30 24           24               24
2704 2704 HENDRICKS COMMUNITY HOSPITAL 503 E LINCOLN STREET HENDRICKS MN 56136 LINCOLN (507) 275-3134 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.5062990 -96.4187680 0   81 27 27081         https://data.medicare.gov/resource/xubh-q36u/row-e659-7utf~w5s6 241339 658677 2019-11-08 2019-06-30 24           24       48       72
2733 2733 MERCY HOSPITAL BOONEVILLE 880 WEST MAIN BOONEVILLE AR 72927 LOGAN (479) 675-2800 Critical Access Hospitals Voluntary non-profit - Private TRUE 35.1409790 -93.9347030 0   83 5 5083         https://data.medicare.gov/resource/xubh-q36u/row-jff3_g33y~pc8b 41318 662152 2019-12-04 2019-06-30 24           24               24
2862 2862 ROSEBUD HEALTH CARE CENTER 383 N 17TH AV FORSYTH MT 59327 ROSEBUD (406) 346-2161 Critical Access Hospitals Voluntary non-profit - Private TRUE 46.2713040 -106.6707520 0   87 30 30087         https://data.medicare.gov/resource/xubh-q36u/row-engw~zm59_xqxg 271327 659043 2019-11-19 2019-06-30 24 1         25       31       56
2905 2905 JEWELL COUNTY HOSPITAL 100 CRESTVUE AVE MANKATO KS 66956 JEWELL (785) 378-3137 Critical Access Hospitals Government - Local TRUE 39.7870540 -98.2012980 0   89 20 20089         https://data.medicare.gov/resource/xubh-q36u/row-gu6a_d9d9-pvcm 171309 648112 2019-05-23 2018-12-31 24           24               24
3156 3156 COMMUNITY HOSPITAL OF BREMEN INC 1020 HIGH RD BREMEN IN 46506 MARSHALL (574) 546-2211 Critical Access Hospitals Voluntary non-profit - Private TRUE 41.4569400 -86.1579220 0   99 18 18099 38500 South Bend-Elkhart-Mishawaka, IN-MI Central Marshall County https://data.medicare.gov/resource/xubh-q36u/row-q5gf_v2gt_2uuk 151300 649572 2019-06-03 2018-12-31 24           24               24
3369 3369 KOSSUTH REGIONAL HEALTH CENTER 1515 SOUTH PHILLIPS STREET ALGONA IA 50511 KOSSUTH (515) 295-2451 Critical Access Hospitals Government - Local TRUE 43.0568220 -94.2271240 0   109 19 19109         https://data.medicare.gov/resource/xubh-q36u/row-xb5y.qfar-cu3w 161353 660979 2019-11-29 2019-06-30 24           24           1   25
3376 3376 PEARL RIVER COUNTY HOSPITAL & NURSING HOME 305 WEST MOODY STREET POPLARVILLE MS 39470 PEARL RIVER (601) 795-4543 Critical Access Hospitals Government - Local TRUE 30.8570980 -89.5414790 0   109 28 28109 38100 New Orleans-Metairie-Hammond, LA-MS Central Pearl River County https://data.medicare.gov/resource/xubh-q36u/row-sbq8~9npp-fvb5 251333 651568 2019-07-09 2018-09-30 24           24           120   144
3478 3478 HIGHLANDS CASHIERS HOSPITAL 190 HOSPITAL DRIVE HIGHLANDS NC 28741 MACON (828) 526-1200 Critical Access Hospitals Voluntary non-profit - Private TRUE 35.0856520 -83.1861100 0   113 37 37113         https://data.medicare.gov/resource/xubh-q36u/row-sjsc-r5is_zgk4 341316 661372 2019-12-16 2019-01-31 24           24               24
3551 3551 INDIANA UNIVERSITY HEALTH PAOLI HOSPITAL 642 W HOSPITAL RD PAOLI IN 47454 ORANGE (812) 723-2811 Critical Access Hospitals Voluntary non-profit - Private TRUE 38.5676980 -86.4751880 0   117 18 18117         https://data.medicare.gov/resource/xubh-q36u/row-waw9_h8cj-dg82 151306 648818 2019-05-29 2018-12-31 24           24               24
3597 3597 ESSENTIA HEALTH FOSSTON 900 HILLIGOSS BOULEVARD SE FOSSTON MN 56542 POLK (218) 435-1133 Critical Access Hospitals Voluntary non-profit - Private TRUE 47.5721490 -95.7406070 0   119 27 27119 24220   Central Polk County https://data.medicare.gov/resource/xubh-q36u/row-93pp~c6zp.yfzi 241357 660612 2019-11-26 2019-06-30 24           24       50       74
3601 3601 MERCY HOSPITAL WALDRON 1341 WEST SIXTH STREET WALDRON AR 72958 SCOTT (479) 637-4135 Critical Access Hospitals Voluntary non-profit - Private TRUE 34.8967850 -94.1060780 0   127 5 5127         https://data.medicare.gov/resource/xubh-q36u/row-hh5p.qtqy-xetd 41305 662149 2019-12-04 2019-06-30 24           24               24
3751 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
3808 3808 NEMAHA VALLEY COMMUNITY HOSPITAL 1600 COMMUNITY DR SENECA KS 66538 NEMAHA (785) 336-6181 Critical Access Hospitals Voluntary non-profit - Private TRUE 39.8378490 -96.0778900 0   131 20 20131         https://data.medicare.gov/resource/xubh-q36u/row-nnw7~3p7y-3e9a 171315 660552 2019-11-27 2019-06-30 24           24               24
3917 3917 OSBORNE COUNTY MEMORIAL HOSPITAL 424 W NEW HAMPSHIRE STREET OSBORNE KS 67473 OSBORNE (785) 346-2121 Critical Access Hospitals Government - Local TRUE 39.4366820 -98.7011590 0   141 20 20141         https://data.medicare.gov/resource/xubh-q36u/row-fbsc.wavi.k36j 171364 648924 2019-05-30 2018-12-31 24           24               24
3979 3979 CENTRACARE HEALTH SYSTEM - SAUK CENTRE 425 NORTH ELM STREET SAUK CENTRE MN 56378 STEARNS (320) 352-2221 Critical Access Hospitals Voluntary non-profit - Private TRUE 45.7458900 -94.9545670 0   145 27 27145 41060 Minneapolis-St. Paul, MN-WI Central Stearns County https://data.medicare.gov/resource/xubh-q36u/row-u3rf_ytjj_n5bm 241368 660615 2019-11-26 2019-06-30 24           24       60       84
3996 3996 PALO ALTO COUNTY HOSPITAL 3201 1ST STREET EMMETSBURG IA 50536 PALO ALTO (712) 852-5500 Critical Access Hospitals Government - Local TRUE 43.1191910 -94.6913430 0   147 19 19147         https://data.medicare.gov/resource/xubh-q36u/row-u98n.v74q-n83i 161357 660981 2019-11-27 2019-06-30 24           24           1   47
4004 4004 COMMUNITY MEDICAL CENTER, INC P O BOX 399, 3307 BARADA ST FALLS CITY NE 68355 RICHARDSON (402) 245-2428 Critical Access Hospitals Voluntary non-profit - Private TRUE 40.0778770 -95.6075970 1 ROOFTOP 147 31 31147         https://data.medicare.gov/resource/xubh-q36u/row-xcna_pb8z-kjhc 281352 640654 2018-12-28 2018-07-31 24           24               24
4021 4021 ROCK COUNTY HOSPITAL 102 EAST SOUTH STREET BASSETT NE 68714 HOLT (402) 684-3366 Critical Access Hospitals Government - Local TRUE 42.5758120 -99.5378910 0   149 31 31149         https://data.medicare.gov/resource/xubh-q36u/row-288b-nrv4_cahh 281333 659705 2019-11-18 2019-06-30 24           24       30       54
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
4043 4043 CRETE AREA MEDICAL CENTER P O BOX 220, 2910 BETTEN DR CRETE NE 68333 SALINE (402) 826-2101 Critical Access Hospitals Voluntary non-profit - Private TRUE 40.6407290 -96.9377207 1 ROOFTOP 151 31 31151         https://data.medicare.gov/resource/xubh-q36u/row-r9d7_ysji.sjzi 281354 649921 2019-06-03 2018-12-31 24           24               24
4127 4127 MEMORIAL HEALTH CARE SYSTEMS 300 NORTH COLUMBIA AVE SEWARD NE 68434 SEWARD (402) 643-2971 Critical Access Hospitals Voluntary non-profit - Private TRUE 40.9092170 -97.0919160 0   159 31 31159 30700 Lincoln-Beatrice, NE Outlying Seward County https://data.medicare.gov/resource/xubh-q36u/row-3sqr.3kpq_q356 281339 643280 2019-02-19 2018-09-30 24           24               24
4257 4257 SWAIN COUNTY HOSPITAL 45 PLATEAU STREET BRYSON CITY NC 28713 SWAIN (828) 488-2155 Critical Access Hospitals Voluntary non-profit - Private TRUE 35.4351230 -83.4446880 0   173 37 37173         https://data.medicare.gov/resource/xubh-q36u/row-xctq~5kw9.id78 341305 640115 2018-12-27 2018-07-31 24           24               24
4391 4391 HARDEMAN COUNTY MEMORIAL HOSPITAL 402 MERCER ST QUANAH TX 79252 HARDEMAN (940) 663-2795 Critical Access Hospitals Government - Hospital District or Authority TRUE 34.2965660 -99.7410560 0   197 48 48197         https://data.medicare.gov/resource/xubh-q36u/row-u2zf.mvvx_urz7 451352 648770 2019-05-24 2018-12-31 24           24               24
4431 4431 YOAKUM COUNTY HOSPITAL 412 MUSTANG AVENUE DENVER CITY TX 79323 YOAKUM (806) 592-2121 Critical Access Hospitals Government - Local TRUE 32.9683780 -102.8363910 0   501 48 48501         https://data.medicare.gov/resource/xubh-q36u/row-f6vr_y9ce-af6k 451308 659741 2019-11-25 2018-12-31 24           24               24

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