04-28-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,165 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
2984 2984     Zhejiang China 2020-04-29 02:32:29 29.1832 120.0934 1268 1 1262 5 Zhejiang, China
2983 2983     Yunnan China 2020-04-29 02:32:29 24.974 101.48700000000001 185 2 181 2 Yunnan, China
2982 2982     Yukon Canada 2020-04-29 02:32:29 64.2823 -135.0 11 0 0 11 Yukon, Canada
2981 2981     Xinjiang China 2020-04-29 02:32:29 41.1129 85.2401 76 3 73 0 Xinjiang, China
27 27 56001 Albany Wyoming US 2020-04-29 02:32:29 41.65498705 -105.7235415 8 0 0 8 Albany, Wyoming, US
187 187 56003 Big Horn Wyoming US 2020-04-29 02:32:29 44.52405055 -107.9960365 2 0 0 2 Big Horn, Wyoming, US
335 335 56005 Campbell Wyoming US 2020-04-29 02:32:29 44.24886082 -105.5474404 23 0 0 23 Campbell, Wyoming, US
344 344 56007 Carbon Wyoming US 2020-04-29 02:32:29 41.69357844 -106.9326084 4 0 0 4 Carbon, Wyoming, US
570 570 56009 Converse Wyoming US 2020-04-29 02:32:29 42.97272268 -105.5081848 21 0 0 21 Converse, Wyoming, US
617 617 56011 Crook Wyoming US 2020-04-29 02:32:29 44.58855102 -104.5697705 5 0 0 5 Crook, Wyoming, US
890 890 56013 Fremont Wyoming US 2020-04-29 02:32:29 43.04183996 -108.6296893 109 0 0 109 Fremont, Wyoming, US
955 955 56015 Goshen Wyoming US 2020-04-29 02:32:29 42.08798185 -104.3534743 4 0 0 4 Goshen, Wyoming, US
1158 1158 56017 Hot Springs Wyoming US 2020-04-29 02:32:29 43.71930657 -108.4423174 3 0 0 3 Hot Springs, Wyoming, US
1299 1299 56019 Johnson Wyoming US 2020-04-29 02:32:29 44.04057166 -106.5845174 15 1 0 14 Johnson, Wyoming, US
1415 1415 56021 Laramie Wyoming US 2020-04-29 02:32:29 41.30702520000001 -104.6887497 134 0 0 134 Laramie, Wyoming, US
1504 1504 56023 Lincoln Wyoming US 2020-04-29 02:32:29 42.26376367 -110.6563997 9 0 0 9 Lincoln, Wyoming, US
1842 1842 56025 Natrona Wyoming US 2020-04-29 02:32:29 42.96180148 -106.797885 49 0 0 49 Natrona, Wyoming, US
1876 1876 56027 Niobrara Wyoming US 2020-04-29 02:32:29 43.05607708 -104.4758896 2 0 0 2 Niobrara, Wyoming, US
1990 1990 56029 Park Wyoming US 2020-04-29 02:32:29 44.52157546 -109.5852825 1 0 0 1 Park, Wyoming, US
2073 2073 56031 Platte Wyoming US 2020-04-29 02:32:29 42.13299116 -104.966331 0 0 0 0 Platte, Wyoming, US
2348 2348 56033 Sheridan Wyoming US 2020-04-29 02:32:29 44.79048913 -106.8862389 16 0 0 16 Sheridan, Wyoming, US
2453 2453 56035 Sublette Wyoming US 2020-04-29 02:32:29 42.76558279 -109.9130922 3 0 0 3 Sublette, Wyoming, US
2482 2482 56037 Sweetwater Wyoming US 2020-04-29 02:32:29 41.65943896 -108.8827882 16 0 0 16 Sweetwater, Wyoming, US
2514 2514 56039 Teton Wyoming US 2020-04-29 02:32:29 43.93522482 -110.5890801 96 0 0 96 Teton, Wyoming, US
2569 2569 56041 Uinta Wyoming US 2020-04-29 02:32:29 41.2878183 -110.54757820000002 8 0 0 8 Uinta, Wyoming, US
2621 2621 90056 Unassigned Wyoming US 2020-04-29 02:32:29     0 6 0 -6 Unassigned, Wyoming, US
2715 2715 56043 Washakie Wyoming US 2020-04-29 02:32:29 43.90451606 -107.68018700000002 8 0 0 8 Washakie, Wyoming, US
18 18 55001 Adams Wisconsin US 2020-04-29 02:32:29 43.96974651 -89.76782777 4 1 0 3 Adams, Wisconsin, US
85 85 55003 Ashland Wisconsin US 2020-04-29 02:32:29 46.31956891 -90.67837132 2 0 0 2 Ashland, Wisconsin, US
127 127 55005 Barron Wisconsin US 2020-04-29 02:32:29 45.42372701 -91.84833627 6 0 0 6 Barron, Wisconsin, US
141 141 55007 Bayfield Wisconsin US 2020-04-29 02:32:29 46.52868768 -91.19716729 3 1 0 2 Bayfield, Wisconsin, US
257 257 55009 Brown Wisconsin US 2020-04-29 02:32:29 44.4526553 -88.00411844 920 3 0 917 Brown, Wisconsin, US
272 272 55011 Buffalo Wisconsin US 2020-04-29 02:32:29 44.37835084 -91.75332578 4 1 0 3 Buffalo, Wisconsin, US
320 320 55015 Calumet Wisconsin US 2020-04-29 02:32:29 44.0816316 -88.21780273 10 0 0 10 Calumet, Wisconsin, US
451 451 55017 Chippewa Wisconsin US 2020-04-29 02:32:29 45.06939744 -91.28068855 21 0 0 21 Chippewa, Wisconsin, US
483 483 55019 Clark Wisconsin US 2020-04-29 02:32:29 44.73483377 -90.61207486 20 3 0 17 Clark, Wisconsin, US
559 559 55021 Columbia Wisconsin US 2020-04-29 02:32:29 43.46492199 -89.33589004 27 1 0 26 Columbia, Wisconsin, US
609 609 55023 Crawford Wisconsin US 2020-04-29 02:32:29 43.23870316 -90.93073686 3 0 0 3 Crawford, Wisconsin, US
651 651 55025 Dane Wisconsin US 2020-04-29 02:32:29 43.06601594 -89.41733797 417 22 0 395 Dane, Wisconsin, US
721 721 55027 Dodge Wisconsin US 2020-04-29 02:32:29 43.41576662 -88.70928178 32 1 0 31 Dodge, Wisconsin, US
726 726 55029 Door Wisconsin US 2020-04-29 02:32:29 44.95856458 -87.30002707 12 1 0 11 Door, Wisconsin, US
740 740 55031 Douglas Wisconsin US 2020-04-29 02:32:29 46.43222285 -91.91595768 9 0 0 9 Douglas, Wisconsin, US
748 748 55033 Dunn Wisconsin US 2020-04-29 02:32:29 44.94562799 -91.8962481 9 0 0 9 Dunn, Wisconsin, US
762 762 55035 Eau Claire Wisconsin US 2020-04-29 02:32:29 44.726614 -91.28609183 27 0 0 27 Eau Claire, Wisconsin, US
841 841 55037 Florence Wisconsin US 2020-04-29 02:32:29 45.84963535 -88.39804137 2 0 0 2 Florence, Wisconsin, US
848 848 55039 Fond du Lac Wisconsin US 2020-04-29 02:32:29 43.75354908 -88.48885325 69 3 0 66 Fond du Lac, Wisconsin, US
979 979 55043 Grant Wisconsin US 2020-04-29 02:32:29 42.8671731 -90.7063218 32 5 0 27 Grant, Wisconsin, US
991 991 55045 Green Wisconsin US 2020-04-29 02:32:29 42.6794956 -89.60243287 11 0 0 11 Green, Wisconsin, US
992 992 55047 Green Lake Wisconsin US 2020-04-29 02:32:29 43.80025981 -89.04679553 2 0 0 2 Green Lake, Wisconsin, US
1203 1203 55049 Iowa Wisconsin US 2020-04-29 02:32:29 43.00050278 -90.13469017 7 0 0 7 Iowa, Wisconsin, US
1206 1206 55051 Iron Wisconsin US 2020-04-29 02:32:29 46.26302338 -90.24295041 2 1 0 1 Iron, Wisconsin, US
1238 1238 55053 Jackson Wisconsin US 2020-04-29 02:32:29 44.31864893 -90.80566792 12 1 0 11 Jackson, Wisconsin, US
1275 1275 55055 Jefferson Wisconsin US 2020-04-29 02:32:29 43.02054068 -88.77529134 42 0 0 42 Jefferson, Wisconsin, US
1309 1309 55057 Juneau Wisconsin US 2020-04-29 02:32:29 43.92456975 -90.11120239 13 1 0 12 Juneau, Wisconsin, US
1329 1329 55059 Kenosha Wisconsin US 2020-04-29 02:32:29 42.57639354 -88.04051686 348 9 0 339 Kenosha, Wisconsin, US
1340 1340 55061 Kewaunee Wisconsin US 2020-04-29 02:32:29 44.51727459 -87.61468386 11 1 0 10 Kewaunee, Wisconsin, US
1372 1372 55063 La Crosse Wisconsin US 2020-04-29 02:32:29 43.90632465 -91.11451093 27 0 0 27 La Crosse, Wisconsin, US
1388 1388 55065 Lafayette Wisconsin US 2020-04-29 02:32:29 42.66005229 -90.1317729 4 0 0 4 Lafayette, Wisconsin, US
1594 1594 55071 Manitowoc Wisconsin US 2020-04-29 02:32:29 44.11946801 -87.80928853 11 1 0 10 Manitowoc, Wisconsin, US
1595 1595 55073 Marathon Wisconsin US 2020-04-29 02:32:29 44.89792533 -89.75863384 17 1 0 16 Marathon, Wisconsin, US
1600 1600 55075 Marinette Wisconsin US 2020-04-29 02:32:29 45.38553432 -88.03324599999998 7 1 0 6 Marinette, Wisconsin, US
1621 1621 55077 Marquette Wisconsin US 2020-04-29 02:32:29 43.81911946 -89.40073763 3 1 0 2 Marquette, Wisconsin, US
1699 1699 55078 Menominee Wisconsin US 2020-04-29 02:32:29 45.00422544 -88.70950714 1 0 0 1 Menominee, Wisconsin, US
1731 1731 55079 Milwaukee Wisconsin US 2020-04-29 02:32:29 43.00486062 -87.96733172 2722 174 0 2548 Milwaukee, Wisconsin, US
1770 1770 55081 Monroe Wisconsin US 2020-04-29 02:32:29 43.94641218 -90.618819 14 1 0 13 Monroe, Wisconsin, US
1906 1906 55083 Oconto Wisconsin US 2020-04-29 02:32:29 45.02715345 -88.26807503 8 0 0 8 Oconto, Wisconsin, US
1926 1926 55085 Oneida Wisconsin US 2020-04-29 02:32:29 45.70677897 -89.51944105 6 0 0 6 Oneida, Wisconsin, US
1972 1972 55087 Outagamie Wisconsin US 2020-04-29 02:32:29 44.41578887 -88.46565023 50 2 0 48 Outagamie, Wisconsin, US
1979 1979 55089 Ozaukee Wisconsin US 2020-04-29 02:32:29 43.38352225 -87.94625009 86 9 0 77 Ozaukee, Wisconsin, US
2016 2016 55091 Pepin Wisconsin US 2020-04-29 02:32:29 44.58307413 -91.99949611 0 0 0 0 Pepin, Wisconsin, US
2048 2048 55093 Pierce Wisconsin US 2020-04-29 02:32:29 44.71850291 -92.4224416 9 0 0 9 Pierce, Wisconsin, US
2093 2093 55095 Polk Wisconsin US 2020-04-29 02:32:29 45.46130348 -92.44182875 4 0 0 4 Polk, Wisconsin, US
2100 2100 55097 Portage Wisconsin US 2020-04-29 02:32:29 44.47558711 -89.50152965 4 0 0 4 Portage, Wisconsin, US
2119 2119 55099 Price Wisconsin US 2020-04-29 02:32:29 45.68051754 -90.3609888 1 0 0 1 Price, Wisconsin, US
2148 2148 55101 Racine Wisconsin US 2020-04-29 02:32:29 42.74753117 -88.05941254 308 12 0 296 Racine, Wisconsin, US
2190 2190 55103 Richland Wisconsin US 2020-04-29 02:32:29 43.3762778 -90.43012729 11 2 0 9 Richland, Wisconsin, US
2212 2212 55105 Rock Wisconsin US 2020-04-29 02:32:29 42.67151616 -89.07147900000002 178 6 0 172 Rock, Wisconsin, US
2236 2236 55107 Rusk Wisconsin US 2020-04-29 02:32:29 45.47498854 -91.1333012 4 0 0 4 Rusk, Wisconsin, US
2290 2290 55111 Sauk Wisconsin US 2020-04-29 02:32:29 43.42574087 -89.94966132 44 3 0 41 Sauk, Wisconsin, US
2292 2292 55113 Sawyer Wisconsin US 2020-04-29 02:32:29 45.87931905 -91.14504927 3 0 0 3 Sawyer, Wisconsin, US
2333 2333 55115 Shawano Wisconsin US 2020-04-29 02:32:29 44.78902246 -88.76443896 8 0 0 8 Shawano, Wisconsin, US
2335 2335 55117 Sheboygan Wisconsin US 2020-04-29 02:32:29 43.72099677 -87.94579284 46 2 0 44 Sheboygan, Wisconsin, US
2398 2398 55109 St. Croix Wisconsin US 2020-04-29 02:32:29 45.03437474 -92.45000068 13 0 0 13 St. Croix, Wisconsin, US
2545 2545 55121 Trempealeau Wisconsin US 2020-04-29 02:32:29 44.30360275 -91.35893614 2 0 0 2 Trempealeau, Wisconsin, US
2620 2620 90055 Unassigned Wisconsin US 2020-04-29 02:32:29     0 0 0 0 Unassigned, Wisconsin, US
2665 2665 55123 Vernon Wisconsin US 2020-04-29 02:32:29 43.59422667 -90.8324691 1 0 0 1 Vernon, Wisconsin, US
2668 2668 55125 Vilas Wisconsin US 2020-04-29 02:32:29 46.05467334 -89.51719204 4 0 0 4 Vilas, Wisconsin, US
2693 2693 55127 Walworth Wisconsin US 2020-04-29 02:32:29 42.66858202 -88.54163073 139 8 0 131 Walworth, Wisconsin, US
2716 2716 55129 Washburn Wisconsin US 2020-04-29 02:32:29 45.89838588 -91.79050449 1 0 0 1 Washburn, Wisconsin, US
2745 2745 55131 Washington Wisconsin US 2020-04-29 02:32:29 43.36863664 -88.22974712 96 4 0 92 Washington, Wisconsin, US
2751 2751 55133 Waukesha Wisconsin US 2020-04-29 02:32:29 43.01833055 -88.30431188 321 16 0 305 Waukesha, Wisconsin, US
2752 2752 55135 Waupaca Wisconsin US 2020-04-29 02:32:29 44.47068056 -88.96534501 7 1 0 6 Waupaca, Wisconsin, US
2753 2753 55137 Waushara Wisconsin US 2020-04-29 02:32:29 44.11324419 -89.24317107 2 0 0 2 Waushara, Wisconsin, US
2836 2836 55139 Winnebago Wisconsin US 2020-04-29 02:32:29 44.06886922 -88.64477096 48 1 0 47 Winnebago, Wisconsin, US
2847 2847 55141 Wood Wisconsin US 2020-04-29 02:32:29 44.45537896 -90.04158336 2 0 0 2 Wood, Wisconsin, US
2980 2980     Western Australia Australia 2020-04-29 02:32:29 -31.9505 115.8605 550 8 495 47 Western Australia, Australia
122 122 54001 Barbour West Virginia US 2020-04-29 02:32:29 39.1307219 -80.00350858 4 1 0 3 Barbour, West Virginia, US
174 174 54003 Berkeley West Virginia US 2020-04-29 02:32:29 39.46704621 -78.02414609 141 1 0 140 Berkeley, West Virginia, US
214 214 54005 Boone West Virginia US 2020-04-29 02:32:29 38.01974191 -81.69888019 2 0 0 2 Boone, West Virginia, US
234 234 54007 Braxton West Virginia US 2020-04-29 02:32:29 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-28-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
);