04-06-2020

Table actions
Big Local News snapshots this data once a day from The Johns Hopkins University Center for Systems Science and Engineering. These are daily reports which provide cases, deaths and recovered for all global locations as wells as United States counties. There is one CSV file for each day's report. The entire set of CSV files are refreshed daily. The zipped archives contain previous daily reports and are date stamped when they were uplaoded by Big Local News. Please cite Johns Hopkins University as described in the README.

Data source: Big Local News · About: README

2,810 rows sorted by Province_State descending

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: Last_Update

Link rowid FIPS Admin2 Province_State ▲ Country_Region Last_Update Lat Long_ Confirmed Deaths Recovered Active Combined_Key
2629 2629     Zhejiang China 4/6/20 2:17 29.1832 120.0934 1264 1 1230 33 Zhejiang, China
2628 2628     Yunnan China 4/2/20 23:33 24.974 101.487 184 2 172 10 Yunnan, China
2627 2627     Yukon Canada 4/6/20 23:28 64.2823 -135.0 6 0 0 0 ,Yukon,Canada
2626 2626     Xinjiang China 3/8/20 5:31 41.1129 85.2401 76 3 73 0 Xinjiang, China
26 26 56001 Albany Wyoming US 4/6/20 23:22 41.65498705 -105.7235415 4 0 0 0 Albany, Wyoming, US
300 300 56005 Campbell Wyoming US 4/6/20 23:22 44.24886082 -105.5474404 9 0 0 0 Campbell, Wyoming, US
310 310 56007 Carbon Wyoming US 4/6/20 23:22 41.69357844 -106.9326084 4 0 0 0 Carbon, Wyoming, US
511 511 56009 Converse Wyoming US 4/6/20 23:22 42.97272268 -105.5081848 4 0 0 0 Converse, Wyoming, US
553 553 56011 Crook Wyoming US 4/6/20 23:22 44.58855102 -104.5697705 1 0 0 0 Crook, Wyoming, US
798 798 56013 Fremont Wyoming US 4/6/20 23:22 43.04183996 -108.6296893 38 0 0 0 Fremont, Wyoming, US
851 851 56015 Goshen Wyoming US 4/6/20 23:22 42.08798185 -104.3534743 3 0 0 0 Goshen, Wyoming, US
1142 1142 56019 Johnson Wyoming US 4/6/20 23:22 44.04057166 -106.5845174 8 0 0 0 Johnson, Wyoming, US
1244 1244 56021 Laramie Wyoming US 4/6/20 23:22 41.3070252 -104.6887497 44 0 0 0 Laramie, Wyoming, US
1324 1324 56023 Lincoln Wyoming US 4/6/20 23:22 42.26376367 -110.6563997 4 0 0 0 Lincoln, Wyoming, US
1621 1621 56025 Natrona Wyoming US 4/6/20 23:22 42.96180148 -106.797885 25 0 0 0 Natrona, Wyoming, US
1751 1751 56029 Park Wyoming US 4/6/20 23:22 44.52157546 -109.5852825 1 0 0 0 Park, Wyoming, US
2056 2056 56033 Sheridan Wyoming US 4/6/20 23:22 44.79048913 -106.8862389 12 0 0 0 Sheridan, Wyoming, US
2145 2145 56035 Sublette Wyoming US 4/6/20 23:22 42.76558279 -109.9130922 1 0 0 0 Sublette, Wyoming, US
2173 2173 56037 Sweetwater Wyoming US 4/6/20 23:22 41.65943896 -108.8827882 5 0 0 0 Sweetwater, Wyoming, US
2202 2202 56039 Teton Wyoming US 4/6/20 23:22 43.93522482 -110.5890801 40 0 0 0 Teton, Wyoming, US
2249 2249 56041 Uinta Wyoming US 4/6/20 23:22 41.2878183 -110.5475782 3 0 0 0 Uinta, Wyoming, US
2377 2377 56043 Washakie Wyoming US 4/6/20 23:22 43.90451606 -107.680187 4 0 0 0 Washakie, Wyoming, US
2810 2810   unassigned Wyoming US 4/6/20 23:22     0 0 0 0 unassigned, Wyoming, US
18 18 55001 Adams Wisconsin US 4/6/20 23:22 43.96974651 -89.76782777 2 0 0 0 Adams, Wisconsin, US
77 77 55003 Ashland Wisconsin US 4/6/20 23:22 46.31956891 -90.67837132 1 0 0 0 Ashland, Wisconsin, US
113 113 55005 Barron Wisconsin US 4/6/20 23:22 45.42372701 -91.84833627 4 0 0 0 Barron, Wisconsin, US
127 127 55007 Bayfield Wisconsin US 4/6/20 23:22 46.52868768 -91.19716729 3 0 0 0 Bayfield, Wisconsin, US
229 229 55009 Brown Wisconsin US 4/6/20 23:22 44.4526553 -88.00411844 39 0 0 0 Brown, Wisconsin, US
241 241 55011 Buffalo Wisconsin US 4/6/20 23:22 44.37835084 -91.75332578 2 1 0 0 Buffalo, Wisconsin, US
287 287 55015 Calumet Wisconsin US 4/6/20 23:22 44.0816316 -88.21780273 4 0 0 0 Calumet, Wisconsin, US
404 404 55017 Chippewa Wisconsin US 4/6/20 23:22 45.06939744 -91.28068855 16 0 0 0 Chippewa, Wisconsin, US
433 433 55019 Clark Wisconsin US 4/6/20 23:22 44.73483377 -90.61207486 7 0 0 0 Clark, Wisconsin, US
501 501 55021 Columbia Wisconsin US 4/6/20 23:22 43.46492199 -89.33589004 21 0 0 0 Columbia, Wisconsin, US
545 545 55023 Crawford Wisconsin US 4/6/20 23:22 43.23870316 -90.93073686 2 0 0 0 Crawford, Wisconsin, US
585 585 55025 Dane Wisconsin US 4/6/20 23:22 43.06601594 -89.41733797 287 9 0 0 Dane, Wisconsin, US
646 646 55027 Dodge Wisconsin US 4/6/20 23:22 43.41576662 -88.70928178 15 0 0 0 Dodge, Wisconsin, US
651 651 55029 Door Wisconsin US 4/6/20 23:22 44.95856458 -87.30002707 4 0 0 0 Door, Wisconsin, US
664 664 55031 Douglas Wisconsin US 4/6/20 23:22 46.43222285 -91.91595768 7 0 0 0 Douglas, Wisconsin, US
673 673 55033 Dunn Wisconsin US 4/6/20 23:22 44.94562799 -91.8962481 5 0 0 0 Dunn, Wisconsin, US
686 686 55035 Eau Claire Wisconsin US 4/6/20 23:22 44.726614 -91.28609183 21 0 0 0 Eau Claire, Wisconsin, US
754 754 55037 Florence Wisconsin US 4/6/20 23:22 45.84963535 -88.39804137 2 0 0 0 Florence, Wisconsin, US
759 759 55039 Fond du Lac Wisconsin US 4/6/20 23:22 43.75354908 -88.48885325 43 2 0 0 Fond du Lac, Wisconsin, US
872 872 55043 Grant Wisconsin US 4/6/20 23:22 42.8671731 -90.7063218 3 0 0 0 Grant, Wisconsin, US
881 881 55045 Green Wisconsin US 4/6/20 23:22 42.6794956 -89.60243287 9 0 0 0 Green, Wisconsin, US
1059 1059 55049 Iowa Wisconsin US 4/6/20 23:22 43.00050278 -90.13469017 3 0 0 0 Iowa, Wisconsin, US
1062 1062 55051 Iron Wisconsin US 4/6/20 23:22 46.26302338 -90.24295041 1 1 0 0 Iron, Wisconsin, US
1089 1089 55053 Jackson Wisconsin US 4/6/20 23:22 44.31864893 -90.80566792 4 0 0 0 Jackson, Wisconsin, US
1123 1123 55055 Jefferson Wisconsin US 4/6/20 23:22 43.02054068 -88.77529134 14 0 0 0 Jefferson, Wisconsin, US
1149 1149 55057 Juneau Wisconsin US 4/6/20 23:22 43.92456975 -90.11120239 5 0 0 0 Juneau, Wisconsin, US
1169 1169 55059 Kenosha Wisconsin US 4/6/20 23:22 42.57639354 -88.04051686 104 1 0 0 Kenosha, Wisconsin, US
1180 1180 55061 Kewaunee Wisconsin US 4/6/20 23:22 44.51727459 -87.61468386 1 0 0 0 Kewaunee, Wisconsin, US
1206 1206 55063 La Crosse Wisconsin US 4/6/20 23:22 43.90632465 -91.11451093 22 0 0 0 La Crosse, Wisconsin, US
1408 1408 55071 Manitowoc Wisconsin US 4/6/20 23:22 44.11946801 -87.80928853 3 0 0 0 Manitowoc, Wisconsin, US
1409 1409 55073 Marathon Wisconsin US 4/6/20 23:22 44.89792533 -89.75863384 12 0 0 0 Marathon, Wisconsin, US
1414 1414 55075 Marinette Wisconsin US 4/6/20 23:22 45.38553432 -88.033246 3 0 0 0 Marinette, Wisconsin, US
1431 1431 55077 Marquette Wisconsin US 4/6/20 23:22 43.81911946 -89.40073763 2 0 0 0 Marquette, Wisconsin, US
1499 1499 55078 Menominee Wisconsin US 4/6/20 23:22 45.00422544 -88.70950714 1 0 0 0 Menominee, Wisconsin, US
1527 1527 55079 Milwaukee Wisconsin US 4/6/20 23:22 43.00486062 -87.96733172 1256 40 0 0 Milwaukee, Wisconsin, US
1559 1559 55081 Monroe Wisconsin US 4/6/20 23:22 43.94641218 -90.618819 7 0 0 0 Monroe, Wisconsin, US
1675 1675 55083 Oconto Wisconsin US 4/6/20 23:22 45.02715345 -88.26807503 1 0 0 0 Oconto, Wisconsin, US
1693 1693 55085 Oneida Wisconsin US 4/6/20 23:22 45.70677897 -89.51944105 3 0 0 0 Oneida, Wisconsin, US
1736 1736 55087 Outagamie Wisconsin US 4/6/20 23:22 44.41578887 -88.46565023 22 1 0 0 Outagamie, Wisconsin, US
1741 1741 55089 Ozaukee Wisconsin US 4/6/20 23:22 43.38352225 -87.94625009 62 6 0 0 Ozaukee, Wisconsin, US
1774 1774 55091 Pepin Wisconsin US 4/6/20 23:22 44.58307413 -91.99949611 0 0 0 0 Pepin, Wisconsin, US
1802 1802 55093 Pierce Wisconsin US 4/6/20 23:22 44.71850291 -92.4224416 7 0 0 0 Pierce, Wisconsin, US
1844 1844 55097 Portage Wisconsin US 4/6/20 23:22 44.47558711 -89.50152965 3 0 0 0 Portage, Wisconsin, US
1884 1884 55101 Racine Wisconsin US 4/6/20 23:22 42.74753117 -88.05941254 57 2 0 0 Racine, Wisconsin, US
1917 1917 55103 Richland Wisconsin US 4/6/20 23:22 43.3762778 -90.43012729 3 0 0 0 Richland, Wisconsin, US
1937 1937 55105 Rock Wisconsin US 4/6/20 23:22 42.67151616 -89.071479 34 2 0 0 Rock, Wisconsin, US
1957 1957 55107 Rusk Wisconsin US 4/6/20 23:22 45.47498854 -91.1333012 3 0 0 0 Rusk, Wisconsin, US
2006 2006 55111 Sauk Wisconsin US 4/6/20 23:22 43.42574087 -89.94966132 18 2 0 0 Sauk, Wisconsin, US
2043 2043 55115 Shawano Wisconsin US 4/6/20 23:22 44.78902246 -88.76443896 2 0 0 0 Shawano, Wisconsin, US
2045 2045 55117 Sheboygan Wisconsin US 4/6/20 23:22 43.72099677 -87.94579284 21 2 0 0 Sheboygan, Wisconsin, US
2097 2097 55109 St. Croix Wisconsin US 4/6/20 23:22 45.03437474 -92.45000068 7 0 0 0 St. Croix, Wisconsin, US
2230 2230 55121 Trempealeau Wisconsin US 4/6/20 23:22 44.30360275 -91.35893614 1 0 0 0 Trempealeau, Wisconsin, US
2293 2293 90055 Unassigned Wisconsin US 4/6/20 23:22     0 0 0 0 Unassigned, Wisconsin, US
2334 2334 55125 Vilas Wisconsin US 4/6/20 23:22 46.05467334 -89.51719204 4 0 0 0 Vilas, Wisconsin, US
2356 2356 55127 Walworth Wisconsin US 4/6/20 23:22 42.66858202 -88.54163073 20 0 0 0 Walworth, Wisconsin, US
2406 2406 55131 Washington Wisconsin US 4/6/20 23:22 43.36863664 -88.22974712 57 3 0 0 Washington, Wisconsin, US
2413 2413 55133 Waukesha Wisconsin US 4/6/20 23:22 43.01833055 -88.30431188 160 4 0 0 Waukesha, Wisconsin, US
2414 2414 55135 Waupaca Wisconsin US 4/6/20 23:22 44.47068056 -88.96534501 2 1 0 0 Waupaca, Wisconsin, US
2415 2415 55137 Waushara Wisconsin US 4/6/20 23:22 44.11324419 -89.24317107 1 0 0 0 Waushara, Wisconsin, US
2486 2486 55139 Winnebago Wisconsin US 4/6/20 23:22 44.06886922 -88.64477096 24 1 0 0 Winnebago, Wisconsin, US
2497 2497 55141 Wood Wisconsin US 4/6/20 23:22 44.45537896 -90.04158336 2 0 0 0 Wood, Wisconsin, US
2625 2625     Western Australia Australia 4/6/20 23:28 -31.9505 115.8605 460 4 162 294 Western Australia, Australia
108 108 54001 Barbour West Virginia US 4/6/20 23:22 39.1307219 -80.00350858 2 0 0 0 Barbour, West Virginia, US
156 156 54003 Berkeley West Virginia US 4/6/20 23:22 39.46704621 -78.02414609 54 0 0 0 Berkeley, West Virginia, US
265 265 54011 Cabell West Virginia US 4/6/20 23:22 38.42424062 -82.23855912 7 0 0 0 Cabell, West Virginia, US
882 882 54025 Greenbrier West Virginia US 4/6/20 23:22 37.9463652 -80.45335881 3 0 0 0 Greenbrier, West Virginia, US
942 942 54029 Hancock West Virginia US 4/6/20 23:22 40.51943859 -80.57461608 6 0 0 0 Hancock, West Virginia, US
953 953 54031 Hardy West Virginia US 4/6/20 23:22 39.00683177 -78.85855301 2 0 0 0 Hardy, West Virginia, US
964 964 54033 Harrison West Virginia US 4/6/20 23:22 39.2853852 -80.37919577 25 1 0 0 Harrison, West Virginia, US
1088 1088 54035 Jackson West Virginia US 4/6/20 23:22 38.84263974 -81.68148753 16 1 0 0 Jackson, West Virginia, US
1122 1122 54037 Jefferson West Virginia US 4/6/20 23:22 39.30776166 -77.86014147 22 0 0 0 Jefferson, West Virginia, US
1153 1153 54039 Kanawha West Virginia US 4/6/20 23:22 38.33860077 -81.52857054 56 0 0 0 Kanawha, West Virginia, US
1296 1296 54041 Lewis West Virginia US 4/6/20 23:22 38.9947249 -80.49988181 1 0 0 0 Lewis, West Virginia, US
1343 1343 54045 Logan West Virginia US 4/6/20 23:22 37.8299889 -81.93528571 6 0 0 0 Logan, West Virginia, US
1428 1428 54049 Marion West Virginia US 4/6/20 23:22 39.50984542 -80.24244659 17 1 0 0 Marion, West Virginia, US
1440 1440 54051 Marshall West Virginia US 4/6/20 23:22 39.86064362 -80.66591062 5 0 0 0 Marshall, West Virginia, US
1452 1452 54053 Mason West Virginia US 4/6/20 23:22 38.77071799 -82.02524219 4 0 0 0 Mason, West Virginia, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [04-06-2020] (
   [FIPS] INTEGER,
   [Admin2] TEXT,
   [Province_State] TEXT,
   [Country_Region] TEXT,
   [Last_Update] TEXT,
   [Lat] FLOAT,
   [Long_] FLOAT,
   [Confirmed] INTEGER,
   [Deaths] INTEGER,
   [Recovered] INTEGER,
   [Active] INTEGER,
   [Combined_Key] TEXT
);