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

403 rows where hospital_ownership = "Government - Local" sorted by countyequivalent

View and edit SQL

Suggested facets: hospital_type, emergency_services, geocode_flag, geocode_accuracy, centraloutlyingcounty, fy_end_date, coronary_beds, burn_beds, surg_icu_beds, oth_spec_beds, subprovider_irf_beds, nursing_fac_beds, oth_longterm_beds, filed_date (date), fy_end_date (date)

hospital_ownership

  • Government - Local · 403
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
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
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
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 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
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 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
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 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
69 ADAIR COUNTY MEMORIAL HOSPITAL 609 SE KENT GREENFIELD IA 50849 ADAIR (641) 743-2123 Critical Access Hospitals Government - Local TRUE 41.3031030 -94.4519270 0   1 19 19001         https://data.medicare.gov/resource/xubh-q36u/row-3dt7_nstz~yhhy 161310 660956 2019-12-02 2019-06-30 25           25               25
117 ADAMS COUNTY REGIONAL MEDICAL CENTER 230 MEDICAL CENTER DRIVE SEAMAN OH 45679 ADAMS (937) 386-3400 Critical Access Hospitals Government - Local TRUE 38.9338480 -83.5856120 0   1 39 39001         https://data.medicare.gov/resource/xubh-q36u/row-wb9j-jzwz-2xmu 361326 649329 2019-05-30 2018-12-31 25           25               25
147 BIG HORN HOSPITAL 17 N MILES HARDIN MT 59034 BIG HORN (406) 665-2310 Critical Access Hospitals Government - Local TRUE 45.7288560 -107.6170100 0   3 30 30003         https://data.medicare.gov/resource/xubh-q36u/row-2cgz.f5s8-gu8f 271338 652087 2018-11-27 2018-06-30 25           25               25
176 CARY MEDICAL CENTER 163 VAN BUREN RD, SUITE 1 CARIBOU ME 4736 AROOSTOOK (207) 498-3111 Acute Care Hospitals Government - Local TRUE 46.8782370 -68.0096390 0   3 23 23003         https://data.medicare.gov/resource/xubh-q36u/row-3dpx.x267~9y3n 200031 650153 2019-05-31 2018-12-31 43 6         49               49
274 VETERANS MEMORIAL HOSPITAL 40 1ST STREET SE WAUKON IA 52172 ALLAMAKEE (563) 568-3411 Critical Access Hospitals Government - Local TRUE 43.2680920 -91.4744460 0   5 19 19005         https://data.medicare.gov/resource/xubh-q36u/row-kmrq-g36y.pe5i 161318 660959 2019-12-02 2019-06-30 25           25               25
317 ALLENDALE COUNTY HOSPITAL 1787 ALLENDALE FAIRFAX RD FAIRFAX SC 29827 ALLENDALE (803) 632-3311 Critical Access Hospitals Government - Local TRUE 32.9662250 -81.2477270 0   5 45 45005         https://data.medicare.gov/resource/xubh-q36u/row-bjdu~dq8g.u82d 421300 645444 2019-03-04 2018-09-30 25           25       44       69
352 BEAR LAKE MEMORIAL HOSPITAL 164 SOUTH FIFTH STREET MONTPELIER ID 83254 BEAR LAKE (208) 847-1630 Critical Access Hospitals Government - Local TRUE 42.3162420 -111.3008470 0   7 16 16007         https://data.medicare.gov/resource/xubh-q36u/row-mggi-9epd.588z 131316 647888 2019-05-16 2018-12-31 21           21       36   32   89
401 MEMORIAL HOSPITAL OF CARBON COUNTY 2221 WEST ELM STREET RAWLINS WY 82301 CARBON (307) 324-2221 Critical Access Hospitals Government - Local TRUE 41.7867630 -107.2606730 0   7 56 56007         https://data.medicare.gov/resource/xubh-q36u/row-5zmg.wks7_27ym 531316 656814 2019-11-08 2019-06-30 19 6         25               25
428 BENEWAH COMMUNITY HOSPITAL 229 SOUTH 7TH STREET ST MARIES ID 83861 BENEWAH (208) 245-5551 Critical Access Hospitals Government - Local TRUE 47.3146130 -116.5666780 0   9 16 16009         https://data.medicare.gov/resource/xubh-q36u/row-3wfv~5stn~5t7d 131317 652074 2019-05-24 2018-12-31 19           19               19
430 AUDUBON COUNTY MEMORIAL HOSPITAL 515 PACIFIC AVENUE AUDUBON IA 50025 AUDUBON (712) 563-2611 Critical Access Hospitals Government - Local TRUE 41.7154230 -94.9370440 0   9 19 19009         https://data.medicare.gov/resource/xubh-q36u/row-7tp4_zwyw_2d9j 161330 659788 2019-11-25 2019-06-30 25           25               25
464 ST MICHAEL'S HOSPITAL - CAH 410 W 16TH AVE TYNDALL SD 57066 BON HOMME (605) 589-2100 Critical Access Hospitals Government - Local TRUE 42.9912530 -97.8678960 0   9 46 46009         https://data.medicare.gov/resource/xubh-q36u/row-sqz9_y3kz.mu4d 431327 659612 2019-11-25 2019-06-30 25           25               25
465 LANDMANN-JUNGMAN MEMORIAL HOSPITAL - CAH 600 BILLARS ST SCOTLAND SD 57059 BON HOMME (605) 583-2226 Critical Access Hospitals Government - Local TRUE 43.1494940 -97.7281040 0   9 46 46009         https://data.medicare.gov/resource/xubh-q36u/row-h5nm-t8q8-ubs6 431317 662141 2019-11-26 2019-06-30 25           25               25
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
477 GUAM MEMORIAL HOSPITAL AUTHORITY 85O GOV CARLOS G CAMACHO ROAD TAMUNING GU 96913 GUAM (671) 647-2552 Acute Care Hospitals Government - Local TRUE 13.5008229 144.7755910 1 GEOMETRIC_CENTER 10 66 66010         https://data.medicare.gov/resource/xubh-q36u/row-4hjs.vy3n_hawy 650001 644079 2019-02-28 2018-09-30 147 14         161       40       201
510 ORTONVILLE AREA HEALTH SERVICES 450 EASTVOLD AVE ORTONVILLE MN 56278 BIG STONE (320) 839-2505 Critical Access Hospitals Government - Local TRUE 45.3147690 -96.4465630 0   11 27 27011         https://data.medicare.gov/resource/xubh-q36u/row-jt8y~id78.iwpi 241342 645770 2019-03-28 2018-09-30 25           25       51       76
513 COX BARTON COUNTY HOSPITAL 29 NW 1ST LANE LAMAR MO 64759 BARTON (417) 682-6081 Critical Access Hospitals Government - Local TRUE 37.5052820 -94.2994820 0   11 29 29011         https://data.medicare.gov/resource/xubh-q36u/row-8cv5-t4zj_7sig 261325 645577 2019-03-04 2018-09-30 21 4         25               25
515 BOONE COUNTY HEALTH CENTER P O BOX 151, 723 WEST FAIRVIEW ST ALBION NE 68620 BOONE (402) 395-2191 Critical Access Hospitals Government - Local TRUE 41.6921113 -98.0002224 1 ROOFTOP 11 31 31011         https://data.medicare.gov/resource/xubh-q36u/row-3j5p_6aw6-77k2 281334 645125 2019-02-28 2018-09-30 25           25               25
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
622 BOX BUTTE GENERAL HOSPITAL P O BOX 810, 2101 BOX BUTTE AVE ALLIANCE NE 69301 BOX BUTTE (308) 762-6660 Critical Access Hospitals Government - Local TRUE 42.0984344 -102.8703880 1 ROOFTOP 13 31 31013         https://data.medicare.gov/resource/xubh-q36u/row-gsu6_furw.wta3 281360 661047 2019-12-02 2019-06-30 25           25               25
762 BROWN COUNTY HOSPITAL 945 EAST ZERO ST AINSWORTH NE 69210 BROWN (402) 387-2800 Critical Access Hospitals Government - Local TRUE 42.5449340 -99.8500450 0   17 31 31017         https://data.medicare.gov/resource/xubh-q36u/row-7ya9_7bjz.6vjk 281325 659704 2019-11-18 2019-06-30 23           23               23
793 GARFIELD MEMORIAL HOSPITAL 200 NORTH 400 EAST PANGUITCH UT 84759 GARFIELD (435) 676-8811 Critical Access Hospitals Government - Local TRUE 37.8287720 -112.4354760 0   17 49 49017         https://data.medicare.gov/resource/xubh-q36u/row-76zy~3pmz.9dc6 461333 658918 2019-11-13 2018-12-31 15           15           21   36
798 HOT SPRINGS COUNTY MEMORIAL HOSPITAL 150 EAST ARAPAHOE THERMOPOLIS WY 82443 HOT SPRINGS (307) 864-3121 Critical Access Hospitals Government - Local TRUE 43.6474320 -108.1995900 0   17 56 56017         https://data.medicare.gov/resource/xubh-q36u/row-ktb5~jtkf~b2ae 531304 640300 2018-11-30 2018-06-30 25           25               25
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
847 GUADALUPE COUNTY HOSPITAL 117 CAMINO DE VIDA, SUITE 100 SANTA ROSA NM 88435 GUADALUPE (575) 472-3417 Acute Care Hospitals Government - Local TRUE 34.9295040 -104.6942240 0   19 35 35019         https://data.medicare.gov/resource/xubh-q36u/row-es4t_p7gk_ag72 320067 661934 2019-12-17 2019-06-30 10           10               10
882 PIGGOTT COMMUNITY HOSPITAL 216 EAST MAIN STREET PIGGOTT AR 72454 CLAY (870) 598-3881 Critical Access Hospitals Government - Local TRUE 36.3820190 -90.1884430 0   21 5 5021         https://data.medicare.gov/resource/xubh-q36u/row-73yu_ywme-uu8m 41330 649163 2019-06-03 2018-12-31 25           25               25
896 PREMIER SURGICAL INSTITUTE 1619 K 66 GALENA KS 66739 CHEROKEE (620) 783-1732 Acute Care Hospitals Government - Local FALSE 37.0766240 -94.6218020 0   21 20 20021         https://data.medicare.gov/resource/xubh-q36u/row-rere_4r4a~kxmn 170203 648913 2019-05-28 2018-12-31 36           36               36
959 CHIPPEWA COUNTY HOSPITAL 824 NORTH 11TH STREET MONTEVIDEO MN 56265 CHIPPEWA (320) 269-8877 Critical Access Hospitals Government - Local TRUE 44.9539890 -95.7135860 0   23 27 27023         https://data.medicare.gov/resource/xubh-q36u/row-jiz7.bbr2-urg8 241325 650591 2019-06-11 2018-12-31 25           25               25
964 BUTLER COUNTY HEALTH CARE CENTER 372 SOUTH 9TH ST DAVID CITY NE 68632 BUTLER (402) 367-1200 Critical Access Hospitals Government - Local TRUE 41.2464710 -97.1230380 0   23 31 31023         https://data.medicare.gov/resource/xubh-q36u/row-u7xr~dyr4.b4xb 281332 661041 2019-12-02 2019-06-30 20           20               20
996 CLAY COUNTY HOSPITAL 911 STACY BURK DRIVE FLORA IL 62839 CLAY (618) 662-2131 Critical Access Hospitals Government - Local TRUE 38.6809170 -88.4703370 0   25 17 17025         https://data.medicare.gov/resource/xubh-q36u/row-waac_79mj~znty 141351 653013 2019-08-02 2019-02-28 20           20               20
1039 CLAIBORNE MEDICAL CENTER 1850 OLD KNOXVILLE HIGHWAY TAZEWELL TN 37879 CLAIBORNE (423) 626-4211 Acute Care Hospitals Government - Local TRUE 36.4533410 -83.5719720 0   25 47 47025         https://data.medicare.gov/resource/xubh-q36u/row-vk5j.mjgd~i76d 440057 658958 2019-11-18 2019-06-30 28 5         33       95       128
1072 CLAY COUNTY MEDICAL CENTER 617 LIBERTY CLAY CENTER KS 67432 CLAY (785) 632-2144 Critical Access Hospitals Government - Local TRUE 39.3916810 -97.1241960 0   27 20 20027         https://data.medicare.gov/resource/xubh-q36u/row-5isq.mc8m-iybh 171371 650581 2019-06-03 2018-12-31 17           17               17
1073 BRECKINRIDGE MEMORIAL HOSPITAL 1011 OLD HIGHWAY 60 HARDINSBURG KY 40143 BRECKINRIDGE (270) 756-7000 Critical Access Hospitals Government - Local TRUE 37.7666150 -86.4416430 0   27 21 21027         https://data.medicare.gov/resource/xubh-q36u/row-x9zn_pcg8_7qr2 181319 648926 2019-05-30 2018-12-31 25           25       18       43
1133 DELTA COUNTY MEMORIAL HOSPITAL 1501 E 3RD ST DELTA CO 81416 DELTA (970) 874-7681 Acute Care Hospitals Government - Local TRUE 38.7431660 -108.0475150 0   29 8 8029         https://data.medicare.gov/resource/xubh-q36u/row-wsed.7ysa~nwhq 60071 649875 2019-05-31 2018-12-31 43 6         49               49
1134 CARIBOU MEMORIAL HOSPITAL 300 SOUTH 3RD WEST SODA SPRINGS ID 83276 CARIBOU (208) 547-3341 Critical Access Hospitals Government - Local TRUE 42.6522350 -111.6133540 0   29 16 16029         https://data.medicare.gov/resource/xubh-q36u/row-k69a-4kn6-dfne 131309 644028 2019-02-28 2018-09-30 25           25       30       55
1137 CASS COUNTY MEMORIAL HOSPITAL 1501 EAST TENTH STREET ATLANTIC IA 50022 CASS (712) 243-3250 Critical Access Hospitals Government - Local TRUE 41.4017120 -94.9926080 0   29 19 19029         https://data.medicare.gov/resource/xubh-q36u/row-6rhm-rv5z-pr85 161376 656671 2019-11-05 2019-06-30 21 4         25 4             29
1149 CHASE COUNTY COMMUNITY HOSPITAL P O BOX 819, 600 W 12TH ST IMPERIAL NE 69033 CHASE (308) 882-7111 Critical Access Hospitals Government - Local TRUE 40.5163553 -101.6419049 1 ROOFTOP 29 31 31029         https://data.medicare.gov/resource/xubh-q36u/row-nwms~eext-vthe 281351 655132 2019-10-04 2019-06-30 20           20               20
1196 ROY LESTER SCHNEIDER HOSPITAL,THE 9048 SUGAR ESTATE ST THOMAS VI 801 SAINT THOMAS ISLAND (809) 776-8311 Acute Care Hospitals Government - Local TRUE 18.3403280 -64.9146707 1 ROOFTOP 30 78 78030         https://data.medicare.gov/resource/xubh-q36u/row-smqm-6qpj_ky9s 480001 644382 2019-03-01 2018-09-30 99 8         107               107
1276 COVINGTON COUNTY HOSPITAL CAH 701 SOUTH HOLLY AVENUE COLLINS MS 39428 COVINGTON (601) 765-6711 Critical Access Hospitals Government - Local TRUE 31.6382360 -89.5544240 0   31 28 28031         https://data.medicare.gov/resource/xubh-q36u/row-6qgj_6i6m-qfrk 251325 643804 2019-02-27 2018-09-30 25           25               25
1281 CHERRY COUNTY HOSPITAL P O BOX 410, 510 NORTH GREEN ST VALENTINE NE 69201 CHERRY (402) 376-2525 Critical Access Hospitals Government - Local TRUE 42.8790786 -100.5384010 1 ROOFTOP 31 31 31031         https://data.medicare.gov/resource/xubh-q36u/row-fpwc_rzae.e38t 281344 652757 2019-07-23 2019-03-31 25           25               25
1308 PLATTE COUNTY MEMORIAL HOSPITAL 201 14TH STREET WHEATLAND WY 82201 PLATTE (307) 322-3636 Critical Access Hospitals Government - Local TRUE 42.0498100 -104.9602210 0   31 56 56031         https://data.medicare.gov/resource/xubh-q36u/row-xwas~nr7a-7yiz 531305 649858 2019-06-03 2018-12-31 25           25               25
1322 COMANCHE COUNTY HOSPITAL 2ND & FRISCO STREET COLDWATER KS 67029 COMANCHE (620) 582-2144 Critical Access Hospitals Government - Local TRUE 37.2679460 -99.3321152 1 GEOMETRIC_CENTER 33 20 20033         https://data.medicare.gov/resource/xubh-q36u/row-uexi-7hwn_3fpb 171312 648915 2019-05-29 2018-12-31 12           12               12
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
1480 SAN JUAN HOSPITAL 380 WEST 100 NORTH MONTICELLO UT 84535 SAN JUAN (435) 587-2116 Critical Access Hospitals Government - Local TRUE 37.8738750 -109.3500620 0   37 49 49037         https://data.medicare.gov/resource/xubh-q36u/row-bwvs.75rh_updn 461308 650788 2019-05-31 2018-12-31 20 1         21               21
1533 GEORGE E WEEMS MEMORIAL HOSPITAL 135 AVE G APALACHICOLA FL 32320 FRANKLIN (850) 653-8853 Critical Access Hospitals Government - Local TRUE 29.7244840 -84.9912750 0   37 12 12037         https://data.medicare.gov/resource/xubh-q36u/row-z2w8_ts6n.p4qb 101305 644253 2019-03-04 2018-09-30 25           25               25
1535 GEORGE REGIONAL HEALTH SYSTEM 859 WINTER STREET LUCEDALE MS 39452 GEORGE (601) 947-3161 Acute Care Hospitals Government - Local TRUE 30.9222350 -88.5928530 0   39 28 28039         https://data.medicare.gov/resource/xubh-q36u/row-f75f~mexp.zvtb 250036 643798 2019-02-28 2018-09-30 36 6         42               42
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
1555 CEDAR COUNTY MEMORIAL HOSPITAL 1401 SOUTH PARK STREET EL DORADO SPRINGS MO 64744 CEDAR (417) 876-2511 Critical Access Hospitals Government - Local TRUE 37.8606740 -94.0185050 0   39 29 29039         https://data.medicare.gov/resource/xubh-q36u/row-6kgc-85en.jtc2 261323 651640 2019-06-27 2019-01-31 25           25               25
1581 DALLAS COUNTY MEDICAL CENTER 201 CLIFTON STREET FORDYCE AR 71742 DALLAS (870) 352-6300 Critical Access Hospitals Government - Local TRUE 33.8111580 -92.4250580 0   39 5 5039         https://data.medicare.gov/resource/xubh-q36u/row-vfqi-mtmw~p9xt 41317 646016 2019-04-01 2018-12-31 22           22               22
1616 DECATUR COUNTY GENERAL HOSPITAL 969 TENNESSEE AVE S PARSONS TN 38363 DECATUR (731) 847-3031 Acute Care Hospitals Government - Local TRUE 35.6357130 -88.1231700 0   39 47 47039         https://data.medicare.gov/resource/xubh-q36u/row-x2m3-qfn9_55w9 440070 661811 2019-12-17 2019-06-30 40           40               40
1651 GREENE COUNTY HOSPITAL CAH 1017 JACKSON STREET LEAKESVILLE MS 39451 GREENE (601) 394-4135 Critical Access Hospitals Government - Local TRUE 31.1547640 -88.5626450 0   41 28 28041         https://data.medicare.gov/resource/xubh-q36u/row-w43a~rntf~brjp 251329 643805 2019-02-28 2018-09-30 7           7               7
1658 VIDANT CHOWAN HOSPITAL 211 VIRGINIA RD EDENTON NC 27932 CHOWAN (252) 482-8451 Critical Access Hospitals Government - Local TRUE 36.0707740 -76.6090930 0   41 37 37041         https://data.medicare.gov/resource/xubh-q36u/row-trbd~xc39_h8ri 341318 644158 2019-02-28 2018-09-30 21 4         25               25
1693 GUTTENBERG MUNICIPAL HOSPITAL 200 MAIN STREET GUTTENBERG IA 52052 CLAYTON (563) 252-1121 Critical Access Hospitals Government - Local TRUE 42.7855480 -91.0999540 0   43 19 19043         https://data.medicare.gov/resource/xubh-q36u/row-9vtm.kuer.r3a9 161312 660958 2019-12-02 2019-06-30 25           25               25
1694 NEWMAN MEMORIAL HOSPITAL 905 SOUTH MAIN STREET SHATTUCK OK 73858 ELLIS (580) 938-2551 Critical Access Hospitals Government - Local TRUE 36.2681320 -99.8815380 0   45 40 40045         https://data.medicare.gov/resource/xubh-q36u/row-7tme~3s76_iax8 371336 649132 2019-05-30 2018-12-31 25           25               25
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 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
1780 EDWARDS COUNTY HOSPITAL 620 WEST EIGHTH STREET KINSLEY KS 67547 EDWARDS (620) 659-3621 Critical Access Hospitals Government - Local TRUE 37.9207150 -99.4194310 0   47 20 20047         https://data.medicare.gov/resource/xubh-q36u/row-g83e~5vmg-b2c4 171317 648916 2019-05-28 2018-12-31 12           12 10             22
1819 FALL RIVER HOSPITAL - CAH 1201 HIGHWAY 71 SOUTH HOT SPRINGS SD 57747 FALL RIVER (605) 745-8910 Critical Access Hospitals Government - Local TRUE 43.4183120 -103.4807830 0   47 46 46047         https://data.medicare.gov/resource/xubh-q36u/row-85xb~ejm9_5eec 431322 650784 2019-05-31 2018-12-31 25           25       48       73
1829 SURPRISE VALLEY COMMUNITY HOSPITAL 741 NORTH MAIN STREET CEDARVILLE CA 96104 MODOC (530) 279-6111 Critical Access Hospitals Government - Local TRUE 41.5319310 -120.1718990 0   49 6 6049         https://data.medicare.gov/resource/xubh-q36u/row-cdww_rq6r_6v4q 51308 662485 2019-12-23 2019-06-30 4           4       22       26
1835 WOODLAWN HOSPITAL 1400 E 9TH ST ROCHESTER IN 46975 FULTON (574) 223-3141 Critical Access Hospitals Government - Local TRUE 41.0617280 -86.1969730 0   49 18 18049         https://data.medicare.gov/resource/xubh-q36u/row-2dgz-xb34_49d2 151313 649096 2019-05-31 2018-12-31 21 4         25               25
1892 GUNNISON VALLEY HOSPITAL 711 NORTH TAYLOR STREET GUNNISON CO 81230 GUNNISON (970) 641-1456 Critical Access Hospitals Government - Local TRUE 38.5510890 -106.9243210 0   51 8 8051         https://data.medicare.gov/resource/xubh-q36u/row-e9p4-pdcf.rn62 61320 650438 2019-05-31 2018-12-31 20           20               20
1913 SIERRA VISTA HOSPITAL 800 EAST 9TH AVENUE T OR C NM 87901 SIERRA (575) 894-2111 Critical Access Hospitals Government - Local TRUE 33.1391040 -107.2419750 0   51 35 35051         https://data.medicare.gov/resource/xubh-q36u/row-4i26.fnpx~4q9x 321300 654972 2019-10-11 2019-06-30 11           11               11
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
1950 DECATUR COUNTY HOSPITAL 1405 NW CHURCH STREET LEON IA 50144 DECATUR (641) 446-4871 Critical Access Hospitals Government - Local TRUE 40.7503080 -93.7477890 0   53 19 19053         https://data.medicare.gov/resource/xubh-q36u/row-z8pk.dm9q_4faw 161340 660972 2019-12-02 2019-06-30 11           11               11
1975 MILAN GENERAL HOSPITAL 4039 HIGHLAND ST MILAN TN 38358 GIBSON (731) 686-1591 Acute Care Hospitals Government - Local TRUE 35.9133110 -88.7534950 0   53 47 47053         https://data.medicare.gov/resource/xubh-q36u/row-b2mu-x63s-nuvr 440060 660042 2019-12-03 2019-06-30 44 3         47               47
2001 GREENE COUNTY GENERAL HOSPITAL 1185 N 1000 W LINTON IN 47441 GREENE (812) 847-2281 Critical Access Hospitals Government - Local TRUE 39.0404960 -87.1291760 0   55 18 18055         https://data.medicare.gov/resource/xubh-q36u/row-9x2i_4s3n~qf9x 151317 652137 2019-07-08 2018-12-31 20 5         25               25
2004 CRITTENDEN COMMUNITY HOSPITAL 520 WEST GUM STREET MARION KY 42064 CRITTENDEN (270) 965-1001 Acute Care Hospitals Government - Local TRUE 37.3296160 -88.0919450 0   55 21 21055         https://data.medicare.gov/resource/xubh-q36u/row-29y5_rw8y-4sga 180095 643771 2019-03-01 2018-09-30 48           48               48
2069 CUMBERLAND COUNTY HOSPITAL 299 GLASGOW ROAD BURKESVILLE KY 42717 CUMBERLAND (270) 864-2511 Critical Access Hospitals Government - Local TRUE 36.7968680 -85.3724400 0   57 21 21057         https://data.medicare.gov/resource/xubh-q36u/row-ptk2_m6d2-xzym 181317 661512 2019-12-02 2019-06-30 25           25               25
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
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
2146 FILLMORE COUNTY HOSPITAL P O BOX 193, 1900 F STREET GENEVA NE 68361 FILLMORE (402) 759-3167 Critical Access Hospitals Government - Local TRUE 40.5243546 -97.5877126 1 ROOFTOP 59 31 31059         https://data.medicare.gov/resource/xubh-q36u/row-h8d4~72pk-88se 281301 659702 2019-11-18 2019-06-30 20           20 10             30
2159 HARPER COUNTY COMMUNITY HOSPITAL 1003 US HIGHWAY 64 NORTH BUFFALO OK 73834 HARPER (580) 735-2555 Critical Access Hospitals Government - Local TRUE 36.8449660 -99.6293020 0   59 40 40059         https://data.medicare.gov/resource/xubh-q36u/row-ubpf.zpwz~4xju 371324 643003 2019-02-11 2018-09-30 15           15               15
2180 WEISBROD MEMORIAL COUNTY HOSPITAL 1208 LUTHER STREET EADS CO 81036 KIOWA (719) 438-5401 Critical Access Hospitals Government - Local TRUE 38.4801980 -102.7844680 0   61 8 8061         https://data.medicare.gov/resource/xubh-q36u/row-7uhk-bw28_6b9m 61300 647281 2019-05-08 2018-12-31 25           25               25
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
2210 VIDANT DUPLIN HOSPITAL 401 N MAIN ST KENANSVILLE NC 28349 DUPLIN (910) 296-0941 Acute Care Hospitals Government - Local TRUE 34.9647690 -77.9604790 0   61 37 37061         https://data.medicare.gov/resource/xubh-q36u/row-3z8q-ur44-gq7x 340120 643929 2019-02-28 2018-09-30 40 9         49 25             74
2238 GREENE COUNTY HOSPITAL 509 WILSON AVENUE EUTAW AL 35462 GREENE (205) 372-3388 Acute Care Hospitals Government - Local TRUE 32.8447440 -87.8893070 0   63 1 1063         https://data.medicare.gov/resource/xubh-q36u/row-dyit.ypt9~f4e7 10051 645036 2019-03-04 2018-09-30 20           20       72       92
2255 JEFFERSON COUNTY HOSPITAL 870 S MAIN FAYETTE MS 39069 JEFFERSON (601) 786-3401 Acute Care Hospitals Government - Local TRUE 31.7048425 -91.0685345 1 ROOFTOP 63 28 28063         https://data.medicare.gov/resource/xubh-q36u/row-6ixf.trx6_t5pg 250060 644298 2019-03-04 2018-09-30 12           12 18             30
2298 CLINCH MEMORIAL HOSPITAL 1050 VALDOSTA HIGHWAY HOMERVILLE GA 31634 CLINCH (912) 487-5211 Critical Access Hospitals Government - Local TRUE 31.0326510 -82.7638580 0   65 13 13065         https://data.medicare.gov/resource/xubh-q36u/row-6x28-ujdc_jsi5 111308 659942 2019-11-27 2019-06-30 15           15               15
2304 GRAHAM COUNTY HOSPITAL 304 WEST PROUT STREET HILL CITY KS 67642 GRAHAM (785) 421-2121 Critical Access Hospitals Government - Local TRUE 39.3717760 -99.8450750 0   65 20 20065         https://data.medicare.gov/resource/xubh-q36u/row-6pnf-hu89-upev 171325 648831 2019-05-28 2018-12-31 20           20               20
2309 FIRSTLIGHT HEALTH SYSTEM 301 SOUTH HIGHWAY 65 MORA MN 55051 KANABEC (320) 679-1212 Critical Access Hospitals Government - Local TRUE 45.8733900 -93.2899550 0   65 27 27065         https://data.medicare.gov/resource/xubh-q36u/row-v75d-m8y9-db5g 241367 653975 2019-09-06 2018-12-31 21 4         25               25
2310 JEFFERSON DAVIS COMMUNITY HOSPITAL CAH 1102 ROSE STREET PRENTISS MS 39474 JEFFERSON DAVIS (601) 792-4276 Critical Access Hospitals Government - Local TRUE 31.5939910 -89.8723810 0   65 28 28065         https://data.medicare.gov/resource/xubh-q36u/row-n4vm-retm~2x2d 251326 652938 2019-07-29 2018-09-30 25           25       60       85
2320 NELL J REDFIELD MEMORIAL HOSPITAL 150 NORTH 200 WEST MALAD ID 83252 ONEIDA (208) 766-2231 Critical Access Hospitals Government - Local TRUE 42.1896380 -112.2507590 0   71 16 16071         https://data.medicare.gov/resource/xubh-q36u/row-dtun.jgpu~2hmu 131303 662195 2019-11-26 2019-06-30 11           11       33       44
2331 MEMORIAL HOSPITAL OF LAFAYETTE COUNTY 800 CLAY ST DARLINGTON WI 53530 LAFAYETTE (608) 776-4466 Critical Access Hospitals Government - Local TRUE 42.6839700 -90.1104190 0   65 55 55065         https://data.medicare.gov/resource/xubh-q36u/row-9ib5-tfyn~k464 521312 649522 2019-05-22 2018-12-31 25           25               25
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
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
2426 JOHNSON REGIONAL MEDICAL CENTER 1100 EAST POPLAR STREET CLARKSVILLE AR 72830 JOHNSON (479) 754-5454 Acute Care Hospitals Government - Local TRUE 35.4643840 -93.4457970 0   71 5 5071         https://data.medicare.gov/resource/xubh-q36u/row-uar5.h8rs.rsi2 40002 648883 2019-05-30 2018-12-31 49 8         57 20 12           89
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
2489 HARDIN MEDICAL CENTER 935 WAYNE ROAD SAVANNAH TN 38372 HARDIN (731) 926-8121 Acute Care Hospitals Government - Local TRUE 35.2271300 -88.2303620 0   71 47 47071         https://data.medicare.gov/resource/xubh-q36u/row-2dfc~89p6~kqtc 440109 660709 2019-12-02 2019-06-30 49           49       73       122
2528 GREENE COUNTY MEDICAL CENTER 1000 WEST LINCOLNWAY JEFFERSON IA 50129 GREENE (515) 386-2114 Critical Access Hospitals Government - Local TRUE 42.0152170 -94.3890600 0   73 19 19073         https://data.medicare.gov/resource/xubh-q36u/row-ekvn-6v3z_68bn 161325 660962 2019-12-02 2019-06-30 21   4       25               25
2529 GREENWOOD COUNTY HOSPITAL 100 W 16TH STREET EUREKA KS 67045 GREENWOOD (620) 583-7451 Critical Access Hospitals Government - Local TRUE 37.8353150 -96.2941800 0   73 20 20073         https://data.medicare.gov/resource/xubh-q36u/row-g9zc.t83r_s62e 171339 645085 2019-02-28 2018-09-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
2570 IU HEALTH JAY 500 W VOTAW ST PORTLAND IN 47371 JAY (260) 726-7131 Critical Access Hospitals Government - Local TRUE 40.4393660 -84.9841050 0   75 18 18075         https://data.medicare.gov/resource/xubh-q36u/row-krfy-myt9_8mki 151320 648822 2019-05-28 2018-12-31 25           25 10             35
2572 HAMILTON COUNTY HOSPITAL 700 NORTH HUSER SYRACUSE KS 67878 HAMILTON (620) 384-7461 Critical Access Hospitals Government - Local TRUE 37.9846055 -101.7426286 1 ROOFTOP 75 20 20075         https://data.medicare.gov/resource/xubh-q36u/row-aubk-tw4u-vx2j 171322 649228 2019-05-31 2018-12-31 25           25               25

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