04-07-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,858 rows sorted by Province_State descending

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: Last_Update (date)

Link rowid FIPS Admin2 Province_State ▲ Country_Region Last_Update Lat Long_ Confirmed Deaths Recovered Active Combined_Key
2678 2678     Zhejiang China 2020-04-07 02:06:38 29.1832 120.0934 1265 1 1230 34 Zhejiang, China
2677 2677     Yunnan China 2020-04-07 00:20:57 24.974 101.48700000000001 184 2 173 9 Yunnan, China
2676 2676     Yukon Canada 2020-04-07 23:11:15 64.2823 -135.0 7 0 0 0 ,Yukon,Canada
2675 2675     Xinjiang China 2020-03-08 05:31:02 41.1129 85.2401 76 3 73 0 Xinjiang, China
26 26 56001 Albany Wyoming US 2020-04-07 23:04:49 41.65498705 -105.72354150000001 4 0 0 0 Albany, Wyoming, US
308 308 56005 Campbell Wyoming US 2020-04-07 23:04:49 44.24886082 -105.54744040000001 9 0 0 0 Campbell, Wyoming, US
318 318 56007 Carbon Wyoming US 2020-04-07 23:04:49 41.69357844 -106.9326084 4 0 0 0 Carbon, Wyoming, US
520 520 56009 Converse Wyoming US 2020-04-07 23:04:49 42.97272268 -105.5081848 4 0 0 0 Converse, Wyoming, US
563 563 56011 Crook Wyoming US 2020-04-07 23:04:49 44.58855102 -104.56977049999999 1 0 0 0 Crook, Wyoming, US
815 815 56013 Fremont Wyoming US 2020-04-07 23:04:49 43.04183996 -108.6296893 38 0 0 0 Fremont, Wyoming, US
869 869 56015 Goshen Wyoming US 2020-04-07 23:04:49 42.08798185 -104.3534743 3 0 0 0 Goshen, Wyoming, US
1166 1166 56019 Johnson Wyoming US 2020-04-07 23:04:49 44.04057166 -106.58451740000001 8 0 0 0 Johnson, Wyoming, US
1271 1271 56021 Laramie Wyoming US 2020-04-07 23:04:49 41.30702520000001 -104.6887497 47 0 0 0 Laramie, Wyoming, US
1353 1353 56023 Lincoln Wyoming US 2020-04-07 23:04:49 42.26376367 -110.6563997 4 0 0 0 Lincoln, Wyoming, US
1657 1657 56025 Natrona Wyoming US 2020-04-07 23:04:49 42.96180148 -106.79788500000001 26 0 0 0 Natrona, Wyoming, US
1789 1789 56029 Park Wyoming US 2020-04-07 23:04:49 44.52157546 -109.58528249999999 1 0 0 0 Park, Wyoming, US
1862 1862 56031 Platte Wyoming US 2020-04-07 23:04:49 42.13299116 -104.96633100000001 1 0 0 0 Platte, Wyoming, US
2100 2100 56033 Sheridan Wyoming US 2020-04-07 23:04:49 44.79048913 -106.8862389 12 0 0 0 Sheridan, Wyoming, US
2189 2189 56035 Sublette Wyoming US 2020-04-07 23:04:49 42.76558279 -109.91309220000001 1 0 0 0 Sublette, Wyoming, US
2217 2217 56037 Sweetwater Wyoming US 2020-04-07 23:04:49 41.65943896 -108.8827882 5 0 0 0 Sweetwater, Wyoming, US
2248 2248 56039 Teton Wyoming US 2020-04-07 23:04:49 43.93522482 -110.5890801 41 0 0 0 Teton, Wyoming, US
2296 2296 56041 Uinta Wyoming US 2020-04-07 23:04:49 41.2878183 -110.54757820000002 3 0 0 0 Uinta, Wyoming, US
2343 2343   Unassigned Wyoming US 2020-04-07 23:04:49     0 0 0 0 Unassigned,Wyoming,US
2427 2427 56043 Washakie Wyoming US 2020-04-07 23:04:49 43.90451606 -107.68018700000002 4 0 0 0 Washakie, Wyoming, US
18 18 55001 Adams Wisconsin US 2020-04-07 23:04:49 43.96974651 -89.76782777 2 0 0 0 Adams, Wisconsin, US
77 77 55003 Ashland Wisconsin US 2020-04-07 23:04:49 46.31956891 -90.67837132 1 0 0 0 Ashland, Wisconsin, US
115 115 55005 Barron Wisconsin US 2020-04-07 23:04:49 45.42372701 -91.84833627 4 0 0 0 Barron, Wisconsin, US
129 129 55007 Bayfield Wisconsin US 2020-04-07 23:04:49 46.52868768 -91.19716729 3 0 0 0 Bayfield, Wisconsin, US
235 235 55009 Brown Wisconsin US 2020-04-07 23:04:49 44.452655299999996 -88.00411844 41 0 0 0 Brown, Wisconsin, US
247 247 55011 Buffalo Wisconsin US 2020-04-07 23:04:49 44.37835084 -91.75332578 2 2 0 0 Buffalo, Wisconsin, US
294 294 55015 Calumet Wisconsin US 2020-04-07 23:04:49 44.0816316 -88.21780273 4 0 0 0 Calumet, Wisconsin, US
412 412 55017 Chippewa Wisconsin US 2020-04-07 23:04:49 45.06939744 -91.28068855 16 0 0 0 Chippewa, Wisconsin, US
441 441 55019 Clark Wisconsin US 2020-04-07 23:04:49 44.73483377 -90.61207486 7 0 0 0 Clark, Wisconsin, US
510 510 55021 Columbia Wisconsin US 2020-04-07 23:04:49 43.46492199 -89.33589004 23 0 0 0 Columbia, Wisconsin, US
555 555 55023 Crawford Wisconsin US 2020-04-07 23:04:49 43.23870316 -90.93073686 2 0 0 0 Crawford, Wisconsin, US
596 596 55025 Dane Wisconsin US 2020-04-07 23:04:49 43.06601594 -89.41733797 289 11 0 0 Dane, Wisconsin, US
658 658 55027 Dodge Wisconsin US 2020-04-07 23:04:49 43.41576662 -88.70928178 15 0 0 0 Dodge, Wisconsin, US
663 663 55029 Door Wisconsin US 2020-04-07 23:04:49 44.95856458 -87.30002707 7 0 0 0 Door, Wisconsin, US
676 676 55031 Douglas Wisconsin US 2020-04-07 23:04:49 46.43222285 -91.91595768 7 0 0 0 Douglas, Wisconsin, US
685 685 55033 Dunn Wisconsin US 2020-04-07 23:04:49 44.94562799 -91.8962481 5 0 0 0 Dunn, Wisconsin, US
698 698 55035 Eau Claire Wisconsin US 2020-04-07 23:04:49 44.726614 -91.28609183 21 0 0 0 Eau Claire, Wisconsin, US
769 769 55037 Florence Wisconsin US 2020-04-07 23:04:49 45.84963535 -88.39804137 2 0 0 0 Florence, Wisconsin, US
775 775 55039 Fond du Lac Wisconsin US 2020-04-07 23:04:49 43.75354908 -88.48885325 44 2 0 0 Fond du Lac, Wisconsin, US
891 891 55043 Grant Wisconsin US 2020-04-07 23:04:49 42.8671731 -90.7063218 3 0 0 0 Grant, Wisconsin, US
900 900 55045 Green Wisconsin US 2020-04-07 23:04:49 42.6794956 -89.60243287 9 0 0 0 Green, Wisconsin, US
1081 1081 55049 Iowa Wisconsin US 2020-04-07 23:04:49 43.00050278 -90.13469017 4 0 0 0 Iowa, Wisconsin, US
1084 1084 55051 Iron Wisconsin US 2020-04-07 23:04:49 46.26302338 -90.24295041 1 1 0 0 Iron, Wisconsin, US
1112 1112 55053 Jackson Wisconsin US 2020-04-07 23:04:49 44.31864893 -90.80566792 4 0 0 0 Jackson, Wisconsin, US
1147 1147 55055 Jefferson Wisconsin US 2020-04-07 23:04:49 43.02054068 -88.77529134 15 0 0 0 Jefferson, Wisconsin, US
1174 1174 55057 Juneau Wisconsin US 2020-04-07 23:04:49 43.92456975 -90.11120239 5 0 0 0 Juneau, Wisconsin, US
1194 1194 55059 Kenosha Wisconsin US 2020-04-07 23:04:49 42.57639354 -88.04051686 112 1 0 0 Kenosha, Wisconsin, US
1205 1205 55061 Kewaunee Wisconsin US 2020-04-07 23:04:49 44.51727459 -87.61468386 1 0 0 0 Kewaunee, Wisconsin, US
1232 1232 55063 La Crosse Wisconsin US 2020-04-07 23:04:49 43.90632465 -91.11451093 22 0 0 0 La Crosse, Wisconsin, US
1246 1246 55065 Lafayette Wisconsin US 2020-04-07 23:04:49 42.66005229 -90.1317729 1 0 0 0 Lafayette, Wisconsin, US
1438 1438 55071 Manitowoc Wisconsin US 2020-04-07 23:04:49 44.11946801 -87.80928853 3 0 0 0 Manitowoc, Wisconsin, US
1439 1439 55073 Marathon Wisconsin US 2020-04-07 23:04:49 44.89792533 -89.75863384 12 0 0 0 Marathon, Wisconsin, US
1444 1444 55075 Marinette Wisconsin US 2020-04-07 23:04:49 45.38553432 -88.03324599999998 3 0 0 0 Marinette, Wisconsin, US
1461 1461 55077 Marquette Wisconsin US 2020-04-07 23:04:49 43.81911946 -89.40073763 2 0 0 0 Marquette, Wisconsin, US
1534 1534 55078 Menominee Wisconsin US 2020-04-07 23:04:49 45.00422544 -88.70950714 1 0 0 0 Menominee, Wisconsin, US
1562 1562 55079 Milwaukee Wisconsin US 2020-04-07 23:04:49 43.00486062 -87.96733172 1323 49 0 0 Milwaukee, Wisconsin, US
1595 1595 55081 Monroe Wisconsin US 2020-04-07 23:04:49 43.94641218 -90.61881899999999 5 0 0 0 Monroe, Wisconsin, US
1712 1712 55083 Oconto Wisconsin US 2020-04-07 23:04:49 45.02715345 -88.26807503 1 0 0 0 Oconto, Wisconsin, US
1730 1730 55085 Oneida Wisconsin US 2020-04-07 23:04:49 45.70677897 -89.51944105 5 0 0 0 Oneida, Wisconsin, US
1774 1774 55087 Outagamie Wisconsin US 2020-04-07 23:04:49 44.41578887 -88.46565023 25 1 0 0 Outagamie, Wisconsin, US
1779 1779 55089 Ozaukee Wisconsin US 2020-04-07 23:04:49 43.38352225 -87.94625009 66 7 0 0 Ozaukee, Wisconsin, US
1812 1812 55091 Pepin Wisconsin US 2020-04-07 23:04:49 44.58307413 -91.99949611 0 0 0 0 Pepin, Wisconsin, US
1840 1840 55093 Pierce Wisconsin US 2020-04-07 23:04:49 44.71850291 -92.4224416 7 0 0 0 Pierce, Wisconsin, US
1884 1884 55097 Portage Wisconsin US 2020-04-07 23:04:49 44.47558711 -89.50152965 4 0 0 0 Portage, Wisconsin, US
1925 1925 55101 Racine Wisconsin US 2020-04-07 23:04:49 42.74753117 -88.05941254 66 2 0 0 Racine, Wisconsin, US
1958 1958 55103 Richland Wisconsin US 2020-04-07 23:04:49 43.3762778 -90.43012729 3 0 0 0 Richland, Wisconsin, US
1978 1978 55105 Rock Wisconsin US 2020-04-07 23:04:49 42.67151616 -89.07147900000002 37 2 0 0 Rock, Wisconsin, US
1998 1998 55107 Rusk Wisconsin US 2020-04-07 23:04:49 45.47498854 -91.1333012 3 0 0 0 Rusk, Wisconsin, US
2047 2047 55111 Sauk Wisconsin US 2020-04-07 23:04:49 43.42574087 -89.94966132 20 2 0 0 Sauk, Wisconsin, US
2087 2087 55115 Shawano Wisconsin US 2020-04-07 23:04:49 44.78902246 -88.76443896 3 0 0 0 Shawano, Wisconsin, US
2089 2089 55117 Sheboygan Wisconsin US 2020-04-07 23:04:49 43.72099677 -87.94579284 30 2 0 0 Sheboygan, Wisconsin, US
2141 2141 55109 St. Croix Wisconsin US 2020-04-07 23:04:49 45.03437474 -92.45000068 7 0 0 0 St. Croix, Wisconsin, US
2276 2276 55121 Trempealeau Wisconsin US 2020-04-07 23:04:49 44.30360275 -91.35893614 1 0 0 0 Trempealeau, Wisconsin, US
2342 2342 90055 Unassigned Wisconsin US 2020-04-07 23:04:49     0 0 0 0 Unassigned, Wisconsin, US
2384 2384 55125 Vilas Wisconsin US 2020-04-07 23:04:49 46.05467334 -89.51719204 4 0 0 0 Vilas, Wisconsin, US
2406 2406 55127 Walworth Wisconsin US 2020-04-07 23:04:49 42.66858202 -88.54163073 21 0 0 0 Walworth, Wisconsin, US
2456 2456 55131 Washington Wisconsin US 2020-04-07 23:04:49 43.36863664 -88.22974712 59 3 0 0 Washington, Wisconsin, US
2461 2461 55133 Waukesha Wisconsin US 2020-04-07 23:04:49 43.01833055 -88.30431188 166 5 0 0 Waukesha, Wisconsin, US
2462 2462 55135 Waupaca Wisconsin US 2020-04-07 23:04:49 44.47068056 -88.96534501 2 1 0 0 Waupaca, Wisconsin, US
2463 2463 55137 Waushara Wisconsin US 2020-04-07 23:04:49 44.11324419 -89.24317107 1 0 0 0 Waushara, Wisconsin, US
2534 2534 55139 Winnebago Wisconsin US 2020-04-07 23:04:49 44.06886922 -88.64477096 24 1 0 0 Winnebago, Wisconsin, US
2545 2545 55141 Wood Wisconsin US 2020-04-07 23:04:49 44.45537896 -90.04158336 2 0 0 0 Wood, Wisconsin, US
2674 2674     Western Australia Australia 2020-04-07 23:11:31 -31.9505 115.8605 460 4 162 294 Western Australia, Australia
110 110 54001 Barbour West Virginia US 2020-04-07 23:04:49 39.1307219 -80.00350858 3 0 0 0 Barbour, West Virginia, US
159 159 54003 Berkeley West Virginia US 2020-04-07 23:04:49 39.46704621 -78.02414609 57 0 0 0 Berkeley, West Virginia, US
224 224 54009 Brooke West Virginia US 2020-04-07 23:04:49 40.27367263 -80.57915332 1 0 0 0 Brooke, West Virginia, US
271 271 54011 Cabell West Virginia US 2020-04-07 23:04:49 38.42424062 -82.23855912 11 0 0 0 Cabell, West Virginia, US
761 761 54019 Fayette West Virginia US 2020-04-07 23:04:49 38.02974928 -81.08286634 1 0 0 0 Fayette, West Virginia, US
901 901 54025 Greenbrier West Virginia US 2020-04-07 23:04:49 37.9463652 -80.45335881 3 0 0 0 Greenbrier, West Virginia, US
963 963 54029 Hancock West Virginia US 2020-04-07 23:04:49 40.51943859 -80.57461608 7 0 0 0 Hancock, West Virginia, US
974 974 54031 Hardy West Virginia US 2020-04-07 23:04:49 39.00683177 -78.85855301 2 0 0 0 Hardy, West Virginia, US
985 985 54033 Harrison West Virginia US 2020-04-07 23:04:49 39.2853852 -80.37919577 25 1 0 0 Harrison, West Virginia, US
1111 1111 54035 Jackson West Virginia US 2020-04-07 23:04:49 38.84263974 -81.68148753 19 1 0 0 Jackson, West Virginia, US
1146 1146 54037 Jefferson West Virginia US 2020-04-07 23:04:49 39.30776166 -77.86014147 31 0 0 0 Jefferson, West Virginia, US
1178 1178 54039 Kanawha West Virginia US 2020-04-07 23:04:49 38.33860077 -81.52857054 61 0 0 0 Kanawha, West Virginia, US
1325 1325 54041 Lewis West Virginia US 2020-04-07 23:04:49 38.9947249 -80.49988181 1 0 0 0 Lewis, West Virginia, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [04-07-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
);