04-30-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,179 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
2996 2996     Zhejiang China 2020-05-01 02:32:28 29.1832 120.0934 1268 1 1264 3 Zhejiang, China
2995 2995     Yunnan China 2020-05-01 02:32:28 24.974 101.48700000000001 185 2 181 2 Yunnan, China
2994 2994     Yukon Canada 2020-05-01 02:32:28 64.2823 -135.0 11 0 0 11 Yukon, Canada
2993 2993     Xinjiang China 2020-05-01 02:32:28 41.1129 85.2401 76 3 73 0 Xinjiang, China
27 27 56001 Albany Wyoming US 2020-05-01 02:32:28 41.65498705 -105.72354150000001 8 0 0 8 Albany, Wyoming, US
187 187 56003 Big Horn Wyoming US 2020-05-01 02:32:28 44.52405055 -107.9960365 3 0 0 3 Big Horn, Wyoming, US
335 335 56005 Campbell Wyoming US 2020-05-01 02:32:28 44.24886082 -105.54744040000001 24 0 0 24 Campbell, Wyoming, US
344 344 56007 Carbon Wyoming US 2020-05-01 02:32:28 41.69357844 -106.9326084 4 0 0 4 Carbon, Wyoming, US
570 570 56009 Converse Wyoming US 2020-05-01 02:32:28 42.97272268 -105.5081848 22 0 0 22 Converse, Wyoming, US
617 617 56011 Crook Wyoming US 2020-05-01 02:32:28 44.58855102 -104.56977049999999 5 0 0 5 Crook, Wyoming, US
893 893 56013 Fremont Wyoming US 2020-05-01 02:32:28 43.04183996 -108.6296893 116 0 0 116 Fremont, Wyoming, US
961 961 56015 Goshen Wyoming US 2020-05-01 02:32:28 42.08798185 -104.3534743 4 0 0 4 Goshen, Wyoming, US
1166 1166 56017 Hot Springs Wyoming US 2020-05-01 02:32:28 43.71930657 -108.44231740000001 3 0 0 3 Hot Springs, Wyoming, US
1307 1307 56019 Johnson Wyoming US 2020-05-01 02:32:28 44.04057166 -106.58451740000001 15 1 0 14 Johnson, Wyoming, US
1423 1423 56021 Laramie Wyoming US 2020-05-01 02:32:28 41.30702520000001 -104.6887497 145 0 0 145 Laramie, Wyoming, US
1512 1512 56023 Lincoln Wyoming US 2020-05-01 02:32:28 42.26376367 -110.6563997 9 0 0 9 Lincoln, Wyoming, US
1851 1851 56025 Natrona Wyoming US 2020-05-01 02:32:28 42.96180148 -106.79788500000001 49 0 0 49 Natrona, Wyoming, US
1885 1885 56027 Niobrara Wyoming US 2020-05-01 02:32:28 43.05607708 -104.47588959999999 2 0 0 2 Niobrara, Wyoming, US
1999 1999 56029 Park Wyoming US 2020-05-01 02:32:28 44.52157546 -109.58528249999999 1 0 0 1 Park, Wyoming, US
2082 2082 56031 Platte Wyoming US 2020-05-01 02:32:28 42.13299116 -104.96633100000001 0 0 0 0 Platte, Wyoming, US
2357 2357 56033 Sheridan Wyoming US 2020-05-01 02:32:28 44.79048913 -106.8862389 16 0 0 16 Sheridan, Wyoming, US
2463 2463 56035 Sublette Wyoming US 2020-05-01 02:32:28 42.76558279 -109.91309220000001 3 0 0 3 Sublette, Wyoming, US
2493 2493 56037 Sweetwater Wyoming US 2020-05-01 02:32:28 41.65943896 -108.8827882 18 0 0 18 Sweetwater, Wyoming, US
2525 2525 56039 Teton Wyoming US 2020-05-01 02:32:28 43.93522482 -110.5890801 96 0 0 96 Teton, Wyoming, US
2580 2580 56041 Uinta Wyoming US 2020-05-01 02:32:28 41.2878183 -110.54757820000002 8 0 0 8 Uinta, Wyoming, US
2632 2632 90056 Unassigned Wyoming US 2020-05-01 02:32:28     0 6 0 -6 Unassigned, Wyoming, US
2726 2726 56043 Washakie Wyoming US 2020-05-01 02:32:28 43.90451606 -107.68018700000002 8 0 0 8 Washakie, Wyoming, US
18 18 55001 Adams Wisconsin US 2020-05-01 02:32:28 43.96974651 -89.76782777 4 1 0 3 Adams, Wisconsin, US
85 85 55003 Ashland Wisconsin US 2020-05-01 02:32:28 46.31956891 -90.67837132 2 0 0 2 Ashland, Wisconsin, US
127 127 55005 Barron Wisconsin US 2020-05-01 02:32:28 45.42372701 -91.84833627 6 0 0 6 Barron, Wisconsin, US
141 141 55007 Bayfield Wisconsin US 2020-05-01 02:32:28 46.52868768 -91.19716729 3 1 0 2 Bayfield, Wisconsin, US
257 257 55009 Brown Wisconsin US 2020-05-01 02:32:28 44.452655299999996 -88.00411844 1057 3 0 1054 Brown, Wisconsin, US
272 272 55011 Buffalo Wisconsin US 2020-05-01 02:32:28 44.37835084 -91.75332578 4 1 0 3 Buffalo, Wisconsin, US
320 320 55015 Calumet Wisconsin US 2020-05-01 02:32:28 44.0816316 -88.21780273 13 0 0 13 Calumet, Wisconsin, US
451 451 55017 Chippewa Wisconsin US 2020-05-01 02:32:28 45.06939744 -91.28068855 22 0 0 22 Chippewa, Wisconsin, US
483 483 55019 Clark Wisconsin US 2020-05-01 02:32:28 44.73483377 -90.61207486 20 4 0 16 Clark, Wisconsin, US
559 559 55021 Columbia Wisconsin US 2020-05-01 02:32:28 43.46492199 -89.33589004 27 1 0 26 Columbia, Wisconsin, US
609 609 55023 Crawford Wisconsin US 2020-05-01 02:32:28 43.23870316 -90.93073686 3 0 0 3 Crawford, Wisconsin, US
651 651 55025 Dane Wisconsin US 2020-05-01 02:32:28 43.06601594 -89.41733797 428 22 0 406 Dane, Wisconsin, US
722 722 55027 Dodge Wisconsin US 2020-05-01 02:32:28 43.41576662 -88.70928178 33 1 0 32 Dodge, Wisconsin, US
727 727 55029 Door Wisconsin US 2020-05-01 02:32:28 44.95856458 -87.30002707 12 2 0 10 Door, Wisconsin, US
741 741 55031 Douglas Wisconsin US 2020-05-01 02:32:28 46.43222285 -91.91595768 9 0 0 9 Douglas, Wisconsin, US
749 749 55033 Dunn Wisconsin US 2020-05-01 02:32:28 44.94562799 -91.8962481 9 0 0 9 Dunn, Wisconsin, US
763 763 55035 Eau Claire Wisconsin US 2020-05-01 02:32:28 44.726614 -91.28609183 28 0 0 28 Eau Claire, Wisconsin, US
844 844 55037 Florence Wisconsin US 2020-05-01 02:32:28 45.84963535 -88.39804137 2 0 0 2 Florence, Wisconsin, US
851 851 55039 Fond du Lac Wisconsin US 2020-05-01 02:32:28 43.75354908 -88.48885325 69 3 0 66 Fond du Lac, Wisconsin, US
985 985 55043 Grant Wisconsin US 2020-05-01 02:32:28 42.8671731 -90.7063218 37 6 0 31 Grant, Wisconsin, US
997 997 55045 Green Wisconsin US 2020-05-01 02:32:28 42.6794956 -89.60243287 12 0 0 12 Green, Wisconsin, US
998 998 55047 Green Lake Wisconsin US 2020-05-01 02:32:28 43.80025981 -89.04679553 2 0 0 2 Green Lake, Wisconsin, US
1211 1211 55049 Iowa Wisconsin US 2020-05-01 02:32:28 43.00050278 -90.13469017 7 0 0 7 Iowa, Wisconsin, US
1214 1214 55051 Iron Wisconsin US 2020-05-01 02:32:28 46.26302338 -90.24295041 2 1 0 1 Iron, Wisconsin, US
1246 1246 55053 Jackson Wisconsin US 2020-05-01 02:32:28 44.31864893 -90.80566792 12 1 0 11 Jackson, Wisconsin, US
1283 1283 55055 Jefferson Wisconsin US 2020-05-01 02:32:28 43.02054068 -88.77529134 45 0 0 45 Jefferson, Wisconsin, US
1317 1317 55057 Juneau Wisconsin US 2020-05-01 02:32:28 43.92456975 -90.11120239 17 1 0 16 Juneau, Wisconsin, US
1337 1337 55059 Kenosha Wisconsin US 2020-05-01 02:32:28 42.57639354 -88.04051686 391 12 0 379 Kenosha, Wisconsin, US
1348 1348 55061 Kewaunee Wisconsin US 2020-05-01 02:32:28 44.51727459 -87.61468386 14 1 0 13 Kewaunee, Wisconsin, US
1380 1380 55063 La Crosse Wisconsin US 2020-05-01 02:32:28 43.90632465 -91.11451093 28 0 0 28 La Crosse, Wisconsin, US
1396 1396 55065 Lafayette Wisconsin US 2020-05-01 02:32:28 42.66005229 -90.1317729 4 0 0 4 Lafayette, Wisconsin, US
1603 1603 55071 Manitowoc Wisconsin US 2020-05-01 02:32:28 44.11946801 -87.80928853 11 1 0 10 Manitowoc, Wisconsin, US
1604 1604 55073 Marathon Wisconsin US 2020-05-01 02:32:28 44.89792533 -89.75863384 18 1 0 17 Marathon, Wisconsin, US
1609 1609 55075 Marinette Wisconsin US 2020-05-01 02:32:28 45.38553432 -88.03324599999998 8 1 0 7 Marinette, Wisconsin, US
1630 1630 55077 Marquette Wisconsin US 2020-05-01 02:32:28 43.81911946 -89.40073763 3 1 0 2 Marquette, Wisconsin, US
1708 1708 55078 Menominee Wisconsin US 2020-05-01 02:32:28 45.00422544 -88.70950714 1 0 0 1 Menominee, Wisconsin, US
1740 1740 55079 Milwaukee Wisconsin US 2020-05-01 02:32:28 43.00486062 -87.96733172 2940 181 0 2759 Milwaukee, Wisconsin, US
1779 1779 55081 Monroe Wisconsin US 2020-05-01 02:32:28 43.94641218 -90.61881899999999 14 1 0 13 Monroe, Wisconsin, US
1915 1915 55083 Oconto Wisconsin US 2020-05-01 02:32:28 45.02715345 -88.26807503 10 0 0 10 Oconto, Wisconsin, US
1935 1935 55085 Oneida Wisconsin US 2020-05-01 02:32:28 45.70677897 -89.51944105 6 0 0 6 Oneida, Wisconsin, US
1981 1981 55087 Outagamie Wisconsin US 2020-05-01 02:32:28 44.41578887 -88.46565023 54 2 0 52 Outagamie, Wisconsin, US
1988 1988 55089 Ozaukee Wisconsin US 2020-05-01 02:32:28 43.38352225 -87.94625009 88 9 0 79 Ozaukee, Wisconsin, US
2025 2025 55091 Pepin Wisconsin US 2020-05-01 02:32:28 44.58307413 -91.99949611 0 0 0 0 Pepin, Wisconsin, US
2057 2057 55093 Pierce Wisconsin US 2020-05-01 02:32:28 44.71850291 -92.4224416 10 0 0 10 Pierce, Wisconsin, US
2102 2102 55095 Polk Wisconsin US 2020-05-01 02:32:28 45.46130348 -92.44182875 4 0 0 4 Polk, Wisconsin, US
2109 2109 55097 Portage Wisconsin US 2020-05-01 02:32:28 44.47558711 -89.50152965 5 0 0 5 Portage, Wisconsin, US
2128 2128 55099 Price Wisconsin US 2020-05-01 02:32:28 45.68051754 -90.36098879999999 1 0 0 1 Price, Wisconsin, US
2157 2157 55101 Racine Wisconsin US 2020-05-01 02:32:28 42.74753117 -88.05941254 355 12 0 343 Racine, Wisconsin, US
2199 2199 55103 Richland Wisconsin US 2020-05-01 02:32:28 43.3762778 -90.43012729 12 2 0 10 Richland, Wisconsin, US
2221 2221 55105 Rock Wisconsin US 2020-05-01 02:32:28 42.67151616 -89.07147900000002 198 6 0 192 Rock, Wisconsin, US
2245 2245 55107 Rusk Wisconsin US 2020-05-01 02:32:28 45.47498854 -91.1333012 4 0 0 4 Rusk, Wisconsin, US
2299 2299 55111 Sauk Wisconsin US 2020-05-01 02:32:28 43.42574087 -89.94966132 45 3 0 42 Sauk, Wisconsin, US
2301 2301 55113 Sawyer Wisconsin US 2020-05-01 02:32:28 45.87931905 -91.14504927 3 0 0 3 Sawyer, Wisconsin, US
2342 2342 55115 Shawano Wisconsin US 2020-05-01 02:32:28 44.78902246 -88.76443896 10 0 0 10 Shawano, Wisconsin, US
2344 2344 55117 Sheboygan Wisconsin US 2020-05-01 02:32:28 43.72099677 -87.94579284 47 2 0 45 Sheboygan, Wisconsin, US
2408 2408 55109 St. Croix Wisconsin US 2020-05-01 02:32:28 45.03437474 -92.45000068 16 0 0 16 St. Croix, Wisconsin, US
2556 2556 55121 Trempealeau Wisconsin US 2020-05-01 02:32:28 44.30360275 -91.35893614 3 0 0 3 Trempealeau, Wisconsin, US
2631 2631 90055 Unassigned Wisconsin US 2020-05-01 02:32:28     0 0 0 0 Unassigned, Wisconsin, US
2676 2676 55123 Vernon Wisconsin US 2020-05-01 02:32:28 43.59422667 -90.8324691 1 0 0 1 Vernon, Wisconsin, US
2679 2679 55125 Vilas Wisconsin US 2020-05-01 02:32:28 46.05467334 -89.51719204 4 0 0 4 Vilas, Wisconsin, US
2704 2704 55127 Walworth Wisconsin US 2020-05-01 02:32:28 42.66858202 -88.54163073 161 8 0 153 Walworth, Wisconsin, US
2727 2727 55129 Washburn Wisconsin US 2020-05-01 02:32:28 45.89838588 -91.79050449 1 0 0 1 Washburn, Wisconsin, US
2757 2757 55131 Washington Wisconsin US 2020-05-01 02:32:28 43.36863664 -88.22974712 98 4 0 94 Washington, Wisconsin, US
2763 2763 55133 Waukesha Wisconsin US 2020-05-01 02:32:28 43.01833055 -88.30431188 336 19 0 317 Waukesha, Wisconsin, US
2764 2764 55135 Waupaca Wisconsin US 2020-05-01 02:32:28 44.47068056 -88.96534501 8 1 0 7 Waupaca, Wisconsin, US
2765 2765 55137 Waushara Wisconsin US 2020-05-01 02:32:28 44.11324419 -89.24317107 2 0 0 2 Waushara, Wisconsin, US
2848 2848 55139 Winnebago Wisconsin US 2020-05-01 02:32:28 44.06886922 -88.64477096 53 1 0 52 Winnebago, Wisconsin, US
2859 2859 55141 Wood Wisconsin US 2020-05-01 02:32:28 44.45537896 -90.04158336 2 0 0 2 Wood, Wisconsin, US
2992 2992     Western Australia Australia 2020-05-01 02:32:28 -31.9505 115.8605 551 8 507 36 Western Australia, Australia
122 122 54001 Barbour West Virginia US 2020-05-01 02:32:28 39.1307219 -80.00350858 5 1 0 4 Barbour, West Virginia, US
174 174 54003 Berkeley West Virginia US 2020-05-01 02:32:28 39.46704621 -78.02414609 145 1 0 144 Berkeley, West Virginia, US
214 214 54005 Boone West Virginia US 2020-05-01 02:32:28 38.01974191 -81.69888019 3 0 0 3 Boone, West Virginia, US
234 234 54007 Braxton West Virginia US 2020-05-01 02:32:28 38.70036159 -80.72011184 2 0 0 2 Braxton, West Virginia, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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