05-04-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

3,203 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
3020 3020     Zhejiang China 2020-05-05 02:32:34 29.1832 120.0934 1268 1 1267 0 Zhejiang, China
3019 3019     Yunnan China 2020-05-05 02:32:34 24.974 101.48700000000001 185 2 181 2 Yunnan, China
3018 3018     Yukon Canada 2020-05-05 02:32:34 64.2823 -135.0 11 0 0 11 Yukon, Canada
3017 3017     Xinjiang China 2020-05-05 02:32:34 41.1129 85.2401 76 3 73 0 Xinjiang, China
27 27 56001 Albany Wyoming US 2020-05-05 02:32:34 41.65498705 -105.72354150000001 8 0 0 8 Albany, Wyoming, US
187 187 56003 Big Horn Wyoming US 2020-05-05 02:32:34 44.52405055 -107.9960365 3 0 0 3 Big Horn, Wyoming, US
341 341 56005 Campbell Wyoming US 2020-05-05 02:32:34 44.24886082 -105.54744040000001 24 0 0 24 Campbell, Wyoming, US
350 350 56007 Carbon Wyoming US 2020-05-05 02:32:34 41.69357844 -106.9326084 5 0 0 5 Carbon, Wyoming, US
576 576 56009 Converse Wyoming US 2020-05-05 02:32:34 42.97272268 -105.5081848 23 0 0 23 Converse, Wyoming, US
623 623 56011 Crook Wyoming US 2020-05-05 02:32:34 44.58855102 -104.56977049999999 5 0 0 5 Crook, Wyoming, US
903 903 56013 Fremont Wyoming US 2020-05-05 02:32:34 43.04183996 -108.6296893 137 0 0 137 Fremont, Wyoming, US
971 971 56015 Goshen Wyoming US 2020-05-05 02:32:34 42.08798185 -104.3534743 4 0 0 4 Goshen, Wyoming, US
1179 1179 56017 Hot Springs Wyoming US 2020-05-05 02:32:34 43.71930657 -108.44231740000001 3 0 0 3 Hot Springs, Wyoming, US
1320 1320 56019 Johnson Wyoming US 2020-05-05 02:32:34 44.04057166 -106.58451740000001 15 1 0 14 Johnson, Wyoming, US
1438 1438 56021 Laramie Wyoming US 2020-05-05 02:32:34 41.30702520000001 -104.6887497 158 0 0 158 Laramie, Wyoming, US
1528 1528 56023 Lincoln Wyoming US 2020-05-05 02:32:34 42.26376367 -110.6563997 9 0 0 9 Lincoln, Wyoming, US
1868 1868 56025 Natrona Wyoming US 2020-05-05 02:32:34 42.96180148 -106.79788500000001 48 0 0 48 Natrona, Wyoming, US
1902 1902 56027 Niobrara Wyoming US 2020-05-05 02:32:34 43.05607708 -104.47588959999999 2 0 0 2 Niobrara, Wyoming, US
2017 2017 56029 Park Wyoming US 2020-05-05 02:32:34 44.52157546 -109.58528249999999 1 0 0 1 Park, Wyoming, US
2100 2100 56031 Platte Wyoming US 2020-05-05 02:32:34 42.13299116 -104.96633100000001 0 0 0 0 Platte, Wyoming, US
2379 2379 56033 Sheridan Wyoming US 2020-05-05 02:32:34 44.79048913 -106.8862389 16 0 0 16 Sheridan, Wyoming, US
2484 2484 56035 Sublette Wyoming US 2020-05-05 02:32:34 42.76558279 -109.91309220000001 3 0 0 3 Sublette, Wyoming, US
2514 2514 56037 Sweetwater Wyoming US 2020-05-05 02:32:34 41.65943896 -108.8827882 18 0 0 18 Sweetwater, Wyoming, US
2547 2547 56039 Teton Wyoming US 2020-05-05 02:32:34 43.93522482 -110.5890801 98 0 0 98 Teton, Wyoming, US
2602 2602 56041 Uinta Wyoming US 2020-05-05 02:32:34 41.2878183 -110.54757820000002 8 0 0 8 Uinta, Wyoming, US
2654 2654 90056 Unassigned Wyoming US 2020-05-05 02:32:34     0 6 0 -6 Unassigned, Wyoming, US
2748 2748 56043 Washakie Wyoming US 2020-05-05 02:32:34 43.90451606 -107.68018700000002 8 0 0 8 Washakie, Wyoming, US
18 18 55001 Adams Wisconsin US 2020-05-05 02:32:34 43.96974651 -89.76782777 4 1 0 3 Adams, Wisconsin, US
85 85 55003 Ashland Wisconsin US 2020-05-05 02:32:34 46.31956891 -90.67837132 2 0 0 2 Ashland, Wisconsin, US
127 127 55005 Barron Wisconsin US 2020-05-05 02:32:34 45.42372701 -91.84833627 7 0 0 7 Barron, Wisconsin, US
141 141 55007 Bayfield Wisconsin US 2020-05-05 02:32:34 46.52868768 -91.19716729 3 1 0 2 Bayfield, Wisconsin, US
262 262 55009 Brown Wisconsin US 2020-05-05 02:32:34 44.452655299999996 -88.00411844 1448 6 0 1442 Brown, Wisconsin, US
277 277 55011 Buffalo Wisconsin US 2020-05-05 02:32:34 44.37835084 -91.75332578 5 1 0 4 Buffalo, Wisconsin, US
326 326 55015 Calumet Wisconsin US 2020-05-05 02:32:34 44.0816316 -88.21780273 19 0 0 19 Calumet, Wisconsin, US
457 457 55017 Chippewa Wisconsin US 2020-05-05 02:32:34 45.06939744 -91.28068855 25 0 0 25 Chippewa, Wisconsin, US
489 489 55019 Clark Wisconsin US 2020-05-05 02:32:34 44.73483377 -90.61207486 21 4 0 17 Clark, Wisconsin, US
565 565 55021 Columbia Wisconsin US 2020-05-05 02:32:34 43.46492199 -89.33589004 30 1 0 29 Columbia, Wisconsin, US
615 615 55023 Crawford Wisconsin US 2020-05-05 02:32:34 43.23870316 -90.93073686 6 0 0 6 Crawford, Wisconsin, US
657 657 55025 Dane Wisconsin US 2020-05-05 02:32:34 43.06601594 -89.41733797 441 22 0 419 Dane, Wisconsin, US
731 731 55027 Dodge Wisconsin US 2020-05-05 02:32:34 43.41576662 -88.70928178 39 1 0 38 Dodge, Wisconsin, US
736 736 55029 Door Wisconsin US 2020-05-05 02:32:34 44.95856458 -87.30002707 15 3 0 12 Door, Wisconsin, US
750 750 55031 Douglas Wisconsin US 2020-05-05 02:32:34 46.43222285 -91.91595768 9 0 0 9 Douglas, Wisconsin, US
758 758 55033 Dunn Wisconsin US 2020-05-05 02:32:34 44.94562799 -91.8962481 12 0 0 12 Dunn, Wisconsin, US
772 772 55035 Eau Claire Wisconsin US 2020-05-05 02:32:34 44.726614 -91.28609183 41 0 0 41 Eau Claire, Wisconsin, US
853 853 55037 Florence Wisconsin US 2020-05-05 02:32:34 45.84963535 -88.39804137 2 0 0 2 Florence, Wisconsin, US
861 861 55039 Fond du Lac Wisconsin US 2020-05-05 02:32:34 43.75354908 -88.48885325 75 3 0 72 Fond du Lac, Wisconsin, US
996 996 55043 Grant Wisconsin US 2020-05-05 02:32:34 42.8671731 -90.7063218 48 6 0 42 Grant, Wisconsin, US
1008 1008 55045 Green Wisconsin US 2020-05-05 02:32:34 42.6794956 -89.60243287 16 0 0 16 Green, Wisconsin, US
1009 1009 55047 Green Lake Wisconsin US 2020-05-05 02:32:34 43.80025981 -89.04679553 5 0 0 5 Green Lake, Wisconsin, US
1224 1224 55049 Iowa Wisconsin US 2020-05-05 02:32:34 43.00050278 -90.13469017 7 0 0 7 Iowa, Wisconsin, US
1227 1227 55051 Iron Wisconsin US 2020-05-05 02:32:34 46.26302338 -90.24295041 2 1 0 1 Iron, Wisconsin, US
1259 1259 55053 Jackson Wisconsin US 2020-05-05 02:32:34 44.31864893 -90.80566792 12 1 0 11 Jackson, Wisconsin, US
1296 1296 55055 Jefferson Wisconsin US 2020-05-05 02:32:34 43.02054068 -88.77529134 46 0 0 46 Jefferson, Wisconsin, US
1330 1330 55057 Juneau Wisconsin US 2020-05-05 02:32:34 43.92456975 -90.11120239 18 1 0 17 Juneau, Wisconsin, US
1352 1352 55059 Kenosha Wisconsin US 2020-05-05 02:32:34 42.57639354 -88.04051686 546 14 0 532 Kenosha, Wisconsin, US
1363 1363 55061 Kewaunee Wisconsin US 2020-05-05 02:32:34 44.51727459 -87.61468386 22 1 0 21 Kewaunee, Wisconsin, US
1395 1395 55063 La Crosse Wisconsin US 2020-05-05 02:32:34 43.90632465 -91.11451093 31 0 0 31 La Crosse, Wisconsin, US
1411 1411 55065 Lafayette Wisconsin US 2020-05-05 02:32:34 42.66005229 -90.1317729 6 0 0 6 Lafayette, Wisconsin, US
1527 1527 55069 Lincoln Wisconsin US 2020-05-05 02:32:34 45.33737523 -89.73411273 1 0 0 1 Lincoln, Wisconsin, US
1619 1619 55071 Manitowoc Wisconsin US 2020-05-05 02:32:34 44.11946801 -87.80928853 14 1 0 13 Manitowoc, Wisconsin, US
1620 1620 55073 Marathon Wisconsin US 2020-05-05 02:32:34 44.89792533 -89.75863384 19 1 0 18 Marathon, Wisconsin, US
1625 1625 55075 Marinette Wisconsin US 2020-05-05 02:32:34 45.38553432 -88.03324599999998 11 1 0 10 Marinette, Wisconsin, US
1646 1646 55077 Marquette Wisconsin US 2020-05-05 02:32:34 43.81911946 -89.40073763 3 1 0 2 Marquette, Wisconsin, US
1724 1724 55078 Menominee Wisconsin US 2020-05-05 02:32:34 45.00422544 -88.70950714 1 0 0 1 Menominee, Wisconsin, US
1756 1756 55079 Milwaukee Wisconsin US 2020-05-05 02:32:34 43.00486062 -87.96733172 3296 195 0 3101 Milwaukee, Wisconsin, US
1796 1796 55081 Monroe Wisconsin US 2020-05-05 02:32:34 43.94641218 -90.61881899999999 14 1 0 13 Monroe, Wisconsin, US
1933 1933 55083 Oconto Wisconsin US 2020-05-05 02:32:34 45.02715345 -88.26807503 18 0 0 18 Oconto, Wisconsin, US
1953 1953 55085 Oneida Wisconsin US 2020-05-05 02:32:34 45.70677897 -89.51944105 6 0 0 6 Oneida, Wisconsin, US
1999 1999 55087 Outagamie Wisconsin US 2020-05-05 02:32:34 44.41578887 -88.46565023 73 2 0 71 Outagamie, Wisconsin, US
2006 2006 55089 Ozaukee Wisconsin US 2020-05-05 02:32:34 43.38352225 -87.94625009 94 9 0 85 Ozaukee, Wisconsin, US
2043 2043 55091 Pepin Wisconsin US 2020-05-05 02:32:34 44.58307413 -91.99949611 0 0 0 0 Pepin, Wisconsin, US
2075 2075 55093 Pierce Wisconsin US 2020-05-05 02:32:34 44.71850291 -92.4224416 10 0 0 10 Pierce, Wisconsin, US
2120 2120 55095 Polk Wisconsin US 2020-05-05 02:32:34 45.46130348 -92.44182875 4 0 0 4 Polk, Wisconsin, US
2127 2127 55097 Portage Wisconsin US 2020-05-05 02:32:34 44.47558711 -89.50152965 7 0 0 7 Portage, Wisconsin, US
2146 2146 55099 Price Wisconsin US 2020-05-05 02:32:34 45.68051754 -90.36098879999999 1 0 0 1 Price, Wisconsin, US
2175 2175 55101 Racine Wisconsin US 2020-05-05 02:32:34 42.74753117 -88.05941254 457 14 0 443 Racine, Wisconsin, US
2219 2219 55103 Richland Wisconsin US 2020-05-05 02:32:34 43.3762778 -90.43012729 13 2 0 11 Richland, Wisconsin, US
2242 2242 55105 Rock Wisconsin US 2020-05-05 02:32:34 42.67151616 -89.07147900000002 289 7 0 282 Rock, Wisconsin, US
2266 2266 55107 Rusk Wisconsin US 2020-05-05 02:32:34 45.47498854 -91.1333012 4 0 0 4 Rusk, Wisconsin, US
2321 2321 55111 Sauk Wisconsin US 2020-05-05 02:32:34 43.42574087 -89.94966132 66 3 0 63 Sauk, Wisconsin, US
2323 2323 55113 Sawyer Wisconsin US 2020-05-05 02:32:34 45.87931905 -91.14504927 4 0 0 4 Sawyer, Wisconsin, US
2364 2364 55115 Shawano Wisconsin US 2020-05-05 02:32:34 44.78902246 -88.76443896 16 0 0 16 Shawano, Wisconsin, US
2366 2366 55117 Sheboygan Wisconsin US 2020-05-05 02:32:34 43.72099677 -87.94579284 53 2 0 51 Sheboygan, Wisconsin, US
2429 2429 55109 St. Croix Wisconsin US 2020-05-05 02:32:34 45.03437474 -92.45000068 20 0 0 20 St. Croix, Wisconsin, US
2578 2578 55121 Trempealeau Wisconsin US 2020-05-05 02:32:34 44.30360275 -91.35893614 4 0 0 4 Trempealeau, Wisconsin, US
2653 2653 90055 Unassigned Wisconsin US 2020-05-05 02:32:34     0 0 0 0 Unassigned, Wisconsin, US
2698 2698 55123 Vernon Wisconsin US 2020-05-05 02:32:34 43.59422667 -90.8324691 2 0 0 2 Vernon, Wisconsin, US
2701 2701 55125 Vilas Wisconsin US 2020-05-05 02:32:34 46.05467334 -89.51719204 4 0 0 4 Vilas, Wisconsin, US
2726 2726 55127 Walworth Wisconsin US 2020-05-05 02:32:34 42.66858202 -88.54163073 211 8 0 203 Walworth, Wisconsin, US
2749 2749 55129 Washburn Wisconsin US 2020-05-05 02:32:34 45.89838588 -91.79050449 1 0 0 1 Washburn, Wisconsin, US
2779 2779 55131 Washington Wisconsin US 2020-05-05 02:32:34 43.36863664 -88.22974712 104 4 0 100 Washington, Wisconsin, US
2785 2785 55133 Waukesha Wisconsin US 2020-05-05 02:32:34 43.01833055 -88.30431188 367 20 0 347 Waukesha, Wisconsin, US
2786 2786 55135 Waupaca Wisconsin US 2020-05-05 02:32:34 44.47068056 -88.96534501 10 1 0 9 Waupaca, Wisconsin, US
2787 2787 55137 Waushara Wisconsin US 2020-05-05 02:32:34 44.11324419 -89.24317107 2 0 0 2 Waushara, Wisconsin, US
2871 2871 55139 Winnebago Wisconsin US 2020-05-05 02:32:34 44.06886922 -88.64477096 72 1 0 71 Winnebago, Wisconsin, US
2882 2882 55141 Wood Wisconsin US 2020-05-05 02:32:34 44.45537896 -90.04158336 2 0 0 2 Wood, Wisconsin, US
3016 3016     Western Australia Australia 2020-05-05 02:32:34 -31.9505 115.8605 551 9 528 14 Western Australia, Australia
122 122 54001 Barbour West Virginia US 2020-05-05 02:32:34 39.1307219 -80.00350858 5 1 0 4 Barbour, West Virginia, US
174 174 54003 Berkeley West Virginia US 2020-05-05 02:32:34 39.46704621 -78.02414609 166 2 0 164 Berkeley, West Virginia, US
215 215 54005 Boone West Virginia US 2020-05-05 02:32:34 38.01974191 -81.69888019 6 0 0 6 Boone, West Virginia, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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