05-09-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,234 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
3051 3051     Zhejiang China 2020-05-10 02:32:30 29.1832 120.0934 1268 1 1267 0 Zhejiang, China
3050 3050     Yunnan China 2020-05-10 02:32:30 24.974 101.48700000000001 185 2 183 0 Yunnan, China
3049 3049     Yukon Canada 2020-05-10 02:32:30 64.2823 -135.0 11 0 0 11 Yukon, Canada
3048 3048     Xinjiang China 2020-05-10 02:32:30 41.1129 85.2401 76 3 73 0 Xinjiang, China
27 27 56001 Albany Wyoming US 2020-05-10 02:32:30 41.65498705 -105.7235415 8 0 0 8 Albany, Wyoming, US
190 190 56003 Big Horn Wyoming US 2020-05-10 02:32:30 44.52405055 -107.9960365 3 0 0 3 Big Horn, Wyoming, US
345 345 56005 Campbell Wyoming US 2020-05-10 02:32:30 44.24886082 -105.5474404 29 0 0 29 Campbell, Wyoming, US
354 354 56007 Carbon Wyoming US 2020-05-10 02:32:30 41.69357844 -106.9326084 5 0 0 5 Carbon, Wyoming, US
585 585 56009 Converse Wyoming US 2020-05-10 02:32:30 42.97272268 -105.5081848 23 0 0 23 Converse, Wyoming, US
632 632 56011 Crook Wyoming US 2020-05-10 02:32:30 44.58855102 -104.5697705 5 0 0 5 Crook, Wyoming, US
915 915 56013 Fremont Wyoming US 2020-05-10 02:32:30 43.04183996 -108.6296893 180 0 0 180 Fremont, Wyoming, US
984 984 56015 Goshen Wyoming US 2020-05-10 02:32:30 42.08798185 -104.3534743 5 0 0 5 Goshen, Wyoming, US
1194 1194 56017 Hot Springs Wyoming US 2020-05-10 02:32:30 43.71930657 -108.4423174 3 0 0 3 Hot Springs, Wyoming, US
1335 1335 56019 Johnson Wyoming US 2020-05-10 02:32:30 44.04057166 -106.5845174 15 1 0 14 Johnson, Wyoming, US
1456 1456 56021 Laramie Wyoming US 2020-05-10 02:32:30 41.30702520000001 -104.6887497 163 0 0 163 Laramie, Wyoming, US
1547 1547 56023 Lincoln Wyoming US 2020-05-10 02:32:30 42.26376367 -110.6563997 10 0 0 10 Lincoln, Wyoming, US
1888 1888 56025 Natrona Wyoming US 2020-05-10 02:32:30 42.96180148 -106.797885 48 0 0 48 Natrona, Wyoming, US
1922 1922 56027 Niobrara Wyoming US 2020-05-10 02:32:30 43.05607708 -104.4758896 2 0 0 2 Niobrara, Wyoming, US
2039 2039 56029 Park Wyoming US 2020-05-10 02:32:30 44.52157546 -109.5852825 1 0 0 1 Park, Wyoming, US
2122 2122 56031 Platte Wyoming US 2020-05-10 02:32:30 42.13299116 -104.966331 0 0 0 0 Platte, Wyoming, US
2404 2404 56033 Sheridan Wyoming US 2020-05-10 02:32:30 44.79048913 -106.8862389 16 0 0 16 Sheridan, Wyoming, US
2510 2510 56035 Sublette Wyoming US 2020-05-10 02:32:30 42.76558279 -109.9130922 3 0 0 3 Sublette, Wyoming, US
2541 2541 56037 Sweetwater Wyoming US 2020-05-10 02:32:30 41.65943896 -108.8827882 19 0 0 19 Sweetwater, Wyoming, US
2574 2574 56039 Teton Wyoming US 2020-05-10 02:32:30 43.93522482 -110.5890801 98 0 0 98 Teton, Wyoming, US
2632 2632 56041 Uinta Wyoming US 2020-05-10 02:32:30 41.2878183 -110.54757820000002 9 0 0 9 Uinta, Wyoming, US
2684 2684 90056 Unassigned Wyoming US 2020-05-10 02:32:30     0 6 0 -6 Unassigned, Wyoming, US
2778 2778 56043 Washakie Wyoming US 2020-05-10 02:32:30 43.90451606 -107.68018700000002 8 0 0 8 Washakie, Wyoming, US
18 18 55001 Adams Wisconsin US 2020-05-10 02:32:30 43.96974651 -89.76782777 4 1 0 3 Adams, Wisconsin, US
85 85 55003 Ashland Wisconsin US 2020-05-10 02:32:30 46.31956891 -90.67837132 2 0 0 2 Ashland, Wisconsin, US
129 129 55005 Barron Wisconsin US 2020-05-10 02:32:30 45.42372701 -91.84833627 10 0 0 10 Barron, Wisconsin, US
143 143 55007 Bayfield Wisconsin US 2020-05-10 02:32:30 46.52868768 -91.19716729 3 1 0 2 Bayfield, Wisconsin, US
266 266 55009 Brown Wisconsin US 2020-05-10 02:32:30 44.4526553 -88.00411844 1834 18 0 1816 Brown, Wisconsin, US
281 281 55011 Buffalo Wisconsin US 2020-05-10 02:32:30 44.37835084 -91.75332578 5 1 0 4 Buffalo, Wisconsin, US
330 330 55015 Calumet Wisconsin US 2020-05-10 02:32:30 44.0816316 -88.21780273 35 0 0 35 Calumet, Wisconsin, US
462 462 55017 Chippewa Wisconsin US 2020-05-10 02:32:30 45.06939744 -91.28068855 29 0 0 29 Chippewa, Wisconsin, US
494 494 55019 Clark Wisconsin US 2020-05-10 02:32:30 44.73483377 -90.61207486 24 4 0 20 Clark, Wisconsin, US
573 573 55021 Columbia Wisconsin US 2020-05-10 02:32:30 43.46492199 -89.33589004 32 1 0 31 Columbia, Wisconsin, US
624 624 55023 Crawford Wisconsin US 2020-05-10 02:32:30 43.23870316 -90.93073686 17 0 0 17 Crawford, Wisconsin, US
666 666 55025 Dane Wisconsin US 2020-05-10 02:32:30 43.06601594 -89.41733797 465 22 0 443 Dane, Wisconsin, US
740 740 55027 Dodge Wisconsin US 2020-05-10 02:32:30 43.41576662 -88.70928178 55 1 0 54 Dodge, Wisconsin, US
745 745 55029 Door Wisconsin US 2020-05-10 02:32:30 44.95856458 -87.30002707 20 3 0 17 Door, Wisconsin, US
759 759 55031 Douglas Wisconsin US 2020-05-10 02:32:30 46.43222285 -91.91595768 11 0 0 11 Douglas, Wisconsin, US
767 767 55033 Dunn Wisconsin US 2020-05-10 02:32:30 44.94562799 -91.8962481 14 0 0 14 Dunn, Wisconsin, US
781 781 55035 Eau Claire Wisconsin US 2020-05-10 02:32:30 44.726614 -91.28609183 54 0 0 54 Eau Claire, Wisconsin, US
863 863 55037 Florence Wisconsin US 2020-05-10 02:32:30 45.84963535 -88.39804137 2 0 0 2 Florence, Wisconsin, US
871 871 55039 Fond du Lac Wisconsin US 2020-05-10 02:32:30 43.75354908 -88.48885325 86 3 0 83 Fond du Lac, Wisconsin, US
875 875 55041 Forest Wisconsin US 2020-05-10 02:32:30 45.66678019 -88.77084892 1 0 0 1 Forest, Wisconsin, US
1010 1010 55043 Grant Wisconsin US 2020-05-10 02:32:30 42.8671731 -90.7063218 67 7 0 60 Grant, Wisconsin, US
1022 1022 55045 Green Wisconsin US 2020-05-10 02:32:30 42.6794956 -89.60243287 33 0 0 33 Green, Wisconsin, US
1023 1023 55047 Green Lake Wisconsin US 2020-05-10 02:32:30 43.80025981 -89.04679553 7 0 0 7 Green Lake, Wisconsin, US
1239 1239 55049 Iowa Wisconsin US 2020-05-10 02:32:30 43.00050278 -90.13469017 10 0 0 10 Iowa, Wisconsin, US
1242 1242 55051 Iron Wisconsin US 2020-05-10 02:32:30 46.26302338 -90.24295041 2 1 0 1 Iron, Wisconsin, US
1274 1274 55053 Jackson Wisconsin US 2020-05-10 02:32:30 44.31864893 -90.80566792 12 1 0 11 Jackson, Wisconsin, US
1311 1311 55055 Jefferson Wisconsin US 2020-05-10 02:32:30 43.02054068 -88.77529134 50 2 0 48 Jefferson, Wisconsin, US
1345 1345 55057 Juneau Wisconsin US 2020-05-10 02:32:30 43.92456975 -90.11120239 21 1 0 20 Juneau, Wisconsin, US
1367 1367 55059 Kenosha Wisconsin US 2020-05-10 02:32:30 42.57639354 -88.04051686 651 15 0 636 Kenosha, Wisconsin, US
1378 1378 55061 Kewaunee Wisconsin US 2020-05-10 02:32:30 44.51727459 -87.61468386 28 1 0 27 Kewaunee, Wisconsin, US
1411 1411 55063 La Crosse Wisconsin US 2020-05-10 02:32:30 43.90632465 -91.11451093 32 0 0 32 La Crosse, Wisconsin, US
1428 1428 55065 Lafayette Wisconsin US 2020-05-10 02:32:30 42.66005229 -90.1317729 13 0 0 13 Lafayette, Wisconsin, US
1546 1546 55069 Lincoln Wisconsin US 2020-05-10 02:32:30 45.33737523 -89.73411273 1 0 0 1 Lincoln, Wisconsin, US
1638 1638 55071 Manitowoc Wisconsin US 2020-05-10 02:32:30 44.11946801 -87.80928853 19 1 0 18 Manitowoc, Wisconsin, US
1639 1639 55073 Marathon Wisconsin US 2020-05-10 02:32:30 44.89792533 -89.75863384 24 1 0 23 Marathon, Wisconsin, US
1644 1644 55075 Marinette Wisconsin US 2020-05-10 02:32:30 45.38553432 -88.03324599999998 16 1 0 15 Marinette, Wisconsin, US
1665 1665 55077 Marquette Wisconsin US 2020-05-10 02:32:30 43.81911946 -89.40073763 3 1 0 2 Marquette, Wisconsin, US
1744 1744 55078 Menominee Wisconsin US 2020-05-10 02:32:30 45.00422544 -88.70950714 2 0 0 2 Menominee, Wisconsin, US
1776 1776 55079 Milwaukee Wisconsin US 2020-05-10 02:32:30 43.00486062 -87.96733172 3854 224 0 3630 Milwaukee, Wisconsin, US
1816 1816 55081 Monroe Wisconsin US 2020-05-10 02:32:30 43.94641218 -90.618819 14 1 0 13 Monroe, Wisconsin, US
1953 1953 55083 Oconto Wisconsin US 2020-05-10 02:32:30 45.02715345 -88.26807503 28 0 0 28 Oconto, Wisconsin, US
1973 1973 55085 Oneida Wisconsin US 2020-05-10 02:32:30 45.70677897 -89.51944105 7 0 0 7 Oneida, Wisconsin, US
2020 2020 55087 Outagamie Wisconsin US 2020-05-10 02:32:30 44.41578887 -88.46565023 111 2 0 109 Outagamie, Wisconsin, US
2027 2027 55089 Ozaukee Wisconsin US 2020-05-10 02:32:30 43.38352225 -87.94625009 104 9 0 95 Ozaukee, Wisconsin, US
2065 2065 55091 Pepin Wisconsin US 2020-05-10 02:32:30 44.58307413 -91.99949611 0 0 0 0 Pepin, Wisconsin, US
2097 2097 55093 Pierce Wisconsin US 2020-05-10 02:32:30 44.71850291 -92.4224416 12 0 0 12 Pierce, Wisconsin, US
2142 2142 55095 Polk Wisconsin US 2020-05-10 02:32:30 45.46130348 -92.44182875 5 0 0 5 Polk, Wisconsin, US
2151 2151 55097 Portage Wisconsin US 2020-05-10 02:32:30 44.47558711 -89.50152965 7 0 0 7 Portage, Wisconsin, US
2170 2170 55099 Price Wisconsin US 2020-05-10 02:32:30 45.68051754 -90.3609888 1 0 0 1 Price, Wisconsin, US
2199 2199 55101 Racine Wisconsin US 2020-05-10 02:32:30 42.74753117 -88.05941254 680 16 0 664 Racine, Wisconsin, US
2243 2243 55103 Richland Wisconsin US 2020-05-10 02:32:30 43.3762778 -90.43012729 13 2 0 11 Richland, Wisconsin, US
2266 2266 55105 Rock Wisconsin US 2020-05-10 02:32:30 42.67151616 -89.07147900000002 347 13 0 334 Rock, Wisconsin, US
2290 2290 55107 Rusk Wisconsin US 2020-05-10 02:32:30 45.47498854 -91.1333012 4 0 0 4 Rusk, Wisconsin, US
2345 2345 55111 Sauk Wisconsin US 2020-05-10 02:32:30 43.42574087 -89.94966132 71 3 0 68 Sauk, Wisconsin, US
2347 2347 55113 Sawyer Wisconsin US 2020-05-10 02:32:30 45.87931905 -91.14504927 4 0 0 4 Sawyer, Wisconsin, US
2389 2389 55115 Shawano Wisconsin US 2020-05-10 02:32:30 44.78902246 -88.76443896 20 0 0 20 Shawano, Wisconsin, US
2391 2391 55117 Sheboygan Wisconsin US 2020-05-10 02:32:30 43.72099677 -87.94579284 65 2 0 63 Sheboygan, Wisconsin, US
2454 2454 55109 St. Croix Wisconsin US 2020-05-10 02:32:30 45.03437474 -92.45000068 27 0 0 27 St. Croix, Wisconsin, US
2607 2607 55121 Trempealeau Wisconsin US 2020-05-10 02:32:30 44.30360275 -91.35893614 5 0 0 5 Trempealeau, Wisconsin, US
2683 2683 90055 Unassigned Wisconsin US 2020-05-10 02:32:30     0 0 0 0 Unassigned, Wisconsin, US
2728 2728 55123 Vernon Wisconsin US 2020-05-10 02:32:30 43.59422667 -90.8324691 3 0 0 3 Vernon, Wisconsin, US
2731 2731 55125 Vilas Wisconsin US 2020-05-10 02:32:30 46.05467334 -89.51719204 4 0 0 4 Vilas, Wisconsin, US
2756 2756 55127 Walworth Wisconsin US 2020-05-10 02:32:30 42.66858202 -88.54163073 229 10 0 219 Walworth, Wisconsin, US
2779 2779 55129 Washburn Wisconsin US 2020-05-10 02:32:30 45.89838588 -91.79050449 1 0 0 1 Washburn, Wisconsin, US
2809 2809 55131 Washington Wisconsin US 2020-05-10 02:32:30 43.36863664 -88.22974712 116 4 0 112 Washington, Wisconsin, US
2815 2815 55133 Waukesha Wisconsin US 2020-05-10 02:32:30 43.01833055 -88.30431188 396 23 0 373 Waukesha, Wisconsin, US
2816 2816 55135 Waupaca Wisconsin US 2020-05-10 02:32:30 44.47068056 -88.96534501 13 1 0 12 Waupaca, Wisconsin, US
2817 2817 55137 Waushara Wisconsin US 2020-05-10 02:32:30 44.11324419 -89.24317107 4 0 0 4 Waushara, Wisconsin, US
2901 2901 55139 Winnebago Wisconsin US 2020-05-10 02:32:30 44.06886922 -88.64477096 98 1 0 97 Winnebago, Wisconsin, US
2912 2912 55141 Wood Wisconsin US 2020-05-10 02:32:30 44.45537896 -90.04158336 2 0 0 2 Wood, Wisconsin, US
3047 3047     Western Australia Australia 2020-05-10 02:32:30 -31.9505 115.8605 552 9 536 7 Western Australia, Australia
124 124 54001 Barbour West Virginia US 2020-05-10 02:32:30 39.1307219 -80.00350858 7 1 0 6 Barbour, West Virginia, US
177 177 54003 Berkeley West Virginia US 2020-05-10 02:32:30 39.46704621 -78.02414609 184 4 0 180 Berkeley, West Virginia, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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