04-03-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,627 rows sorted by Lat 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
2384 2384     Greenland Denmark 2020-04-03 22:46:20 71.7069 -42.6043 10 0 3 7 Greenland, Denmark
2417 2417     Nunavut Canada 2020-04-03 22:52:30 70.2998 -83.1076 0 0 0 0 Nunavut, Canada
2357 2357 2290 Yukon-Koyukuk Alaska US 2020-04-03 22:46:37 65.50815459 -151.39073869999999 1 0 0 0 Yukon-Koyukuk, Alaska, US
2523 2523       Iceland 2020-04-03 22:46:20 64.9631 -19.0208 1364 4 309 1051 Iceland
2415 2415     Northwest Territories Canada 2020-04-03 22:52:30 64.8255 -124.8457 2 0 0 0 ,Northwest Territories,Canada
674 674 2090 Fairbanks North Star Alaska US 2020-04-03 22:46:37 64.80726247 -146.5692662 42 0 0 0 Fairbanks North Star, Alaska, US
2446 2446     Yukon Canada 2020-04-03 22:52:30 64.2823 -135.0 6 0 0 0 ,Yukon,Canada
1931 1931 2240 Southeast Fairbanks Alaska US 2020-04-03 22:46:37 63.87692095 -143.2127643 1 0 0 0 Southeast Fairbanks, Alaska, US
1353 1353 2170 Matanuska-Susitna Alaska US 2020-04-03 22:46:37 62.31305045 -149.5741743 4 0 0 0 Matanuska-Susitna, Alaska, US
2506 2506       Finland 2020-04-03 22:46:20 61.92411 25.748151 1615 20 300 1295 Finland
2376 2376     Faroe Islands Denmark 2020-04-03 22:46:20 61.8926 -6.9118 179 0 91 88 Faroe Islands, Denmark
2584 2584       Russia 2020-04-03 22:46:20 61.52401 105.31875600000001 4149 34 281 3834 Russia
46 46 2020 Anchorage Alaska US 2020-04-03 22:46:37 61.14998174 -149.14269860000005 73 1 0 0 Anchorage, Alaska, US
2572 2572       Norway 2020-04-03 22:46:20 60.472 8.4689 5370 59 32 5279 Norway
1084 1084 2122 Kenai Peninsula Alaska US 2020-04-03 22:46:37 60.24429722 -151.53888840000005 10 0 0 0 Kenai Peninsula, Alaska, US
2605 2605       Sweden 2020-04-03 22:46:20 60.128161 18.643501 6131 358 205 5568 Sweden
2502 2502       Estonia 2020-04-03 22:46:20 58.5953 25.0136 961 12 48 901 Estonia
1067 1067 2110 Juneau Alaska US 2020-04-03 22:46:37 58.45031811 -134.200436 11 0 0 0 Juneau, Alaska, US
1660 1660 2195 Petersburg Alaska US 2020-04-03 22:46:37 57.13978948 -132.9540995 1 0 0 0 Petersburg, Alaska, US
2541 2541       Latvia 2020-04-03 22:46:20 56.8796 24.6032 493 1 1 491 Latvia
2492 2492       Denmark 2020-04-03 22:46:20 56.2639 9.5018 3757 139 1193 2425 Denmark
1098 1098 2130 Ketchikan Gateway Alaska US 2020-04-03 22:46:37 55.57445008 -130.975561 14 0 0 0 Ketchikan Gateway, Alaska, US
2619 2619       United Kingdom 2020-04-03 22:46:20 55.3781 -3.4360000000000004 38168 3605 135 34428 United Kingdom
2546 2546       Lithuania 2020-04-03 22:46:20 55.1694 23.8813 631 6 0 680 Lithuania
2398 2398     Isle of Man United Kingdom 2020-04-03 22:46:20 54.2361 -4.5481 114 1 0 113 Isle of Man, United Kingdom
2360 2360     Alberta Canada 2020-04-03 22:52:30 53.9333 -116.5765 969 13 0 0 Alberta, Canada
2404 2404     Manitoba Canada 2020-04-03 22:52:30 53.7609 -98.8139 182 2 0 0 Manitoba, Canada
2368 2368     British Columbia Canada 2020-04-03 22:52:30 53.7267 -127.6476 1174 31 0 0 British Columbia, Canada
2463 2463       Belarus 2020-04-03 22:46:20 53.7098 27.9534 351 4 53 294 Belarus
2528 2528       Ireland 2020-04-03 22:46:20 53.1424 -7.6921 4273 120 5 4148 Ireland
2411 2411     Newfoundland and Labrador Canada 2020-04-03 22:52:30 53.1355 -57.6604 195 1 0 0 Newfoundland and Labrador, Canada
2422 2422     Quebec Canada 2020-04-03 22:52:30 52.9399 -73.5491 6101 159 0 0 Quebec, Canada
2429 2429     Saskatchewan Canada 2020-04-03 22:52:30 52.9399 -106.4509 220 3 0 0 Saskatchewan, Canada
2566 2566       Netherlands 2020-04-03 22:46:20 52.1326 5.2913 15723 1487 250 13986 Netherlands
2580 2580       Poland 2020-04-03 22:46:20 51.9194 19.1451 3383 71 56 3256 Poland
2418 2418     Ontario Canada 2020-04-03 22:52:30 51.2538 -85.3232 3255 67 0 0 Ontario, Canada
2511 2511       Germany 2020-04-03 22:46:20 51.165690999999995 10.451526 91159 1275 24575 65309 Germany
2464 2464       Belgium 2020-04-03 22:46:20 50.8333 4.469936 16770 1143 2872 12755 Belgium
2491 2491       Czechia 2020-04-03 22:46:20 49.8175 15.472999999999999 4091 53 72 3966 Czechia
2547 2547       Luxembourg 2020-04-03 22:46:20 49.8153 6.1296 2612 31 500 2081 Luxembourg
2371 2371     Channel Islands United Kingdom 2020-04-03 22:46:20 49.3723 -2.3644 232 4 13 215 Channel Islands, United Kingdom
2272 2272 53073 Whatcom Washington US 2020-04-03 22:46:37 48.82227976 -121.74900179999999 182 15 0 0 Whatcom, Washington, US
596 596 38023 Divide North Dakota US 2020-04-03 22:46:37 48.814938700000006 -103.48736109999999 1 0 0 0 Divide, North Dakota, US
234 234 38013 Burke North Dakota US 2020-04-03 22:46:37 48.79094471 -102.51821170000001 2 0 0 0 Burke, North Dakota, US
779 779 30035 Glacier Montana US 2020-04-03 22:46:37 48.70513576 -112.9934235 1 0 0 0 Glacier, Montana, US
2597 2597       Slovakia 2020-04-03 22:46:20 48.669 19.699 450 1 10 439 Slovakia
2062 2062 30101 Toole Montana US 2020-04-03 22:46:37 48.65577551 -111.69424140000001 6 3 0 0 Toole, Montana, US
931 931 30041 Hill Montana US 2020-04-03 22:46:37 48.62879827 -110.1129252 1 0 0 0 Hill, Montana, US
1842 1842 53055 San Juan Washington US 2020-04-03 22:46:37 48.60182783 -122.96745 6 0 0 0 San Juan, Washington, US
1211 1211 30051 Liberty Montana US 2020-04-03 22:46:37 48.56084317 -111.02430700000001 1 0 0 0 Liberty, Montana, US
1566 1566 53047 Okanogan Washington US 2020-04-03 22:46:37 48.54855019 -119.73872240000001 4 0 0 0 Okanogan, Washington, US
1225 1225 30053 Lincoln Montana US 2020-04-03 22:46:37 48.54265777 -115.4046155 6 1 0 0 Lincoln, Montana, US
1644 1644 53051 Pend Oreille Washington US 2020-04-03 22:46:37 48.53234021 -117.2741804 1 0 0 0 Pend Oreille, Washington, US
1914 1914 53057 Skagit Washington US 2020-04-03 22:46:37 48.48171488 -121.766131 153 4 0 0 Skagit, Washington, US
698 698 53019 Ferry Washington US 2020-04-03 22:46:37 48.471143100000006 -118.5154041 1 0 0 0 Ferry, Washington, US
1981 1981 53065 Stevens Washington US 2020-04-03 22:46:37 48.40035475 -117.8542701 5 0 0 0 Stevens, Washington, US
2617 2617       Ukraine 2020-04-03 22:46:20 48.3794 31.1656 1072 27 22 1023 Ukraine
2180 2180 38099 Walsh North Dakota US 2020-04-03 22:46:37 48.36876964 -97.72574783 1 0 0 0 Walsh, North Dakota, US
2294 2294 38105 Williams North Dakota US 2020-04-03 22:46:37 48.34522353 -103.4793387 5 0 0 0 Williams, North Dakota, US
173 173 16017 Bonner Idaho US 2020-04-03 22:46:37 48.29996017 -116.6017932 1 0 0 0 Bonner, Idaho, US
1807 1807 30085 Roosevelt Montana US 2020-04-03 22:46:37 48.29607488 -105.00792679999999 1 0 0 0 Roosevelt, Montana, US
702 702 30029 Flathead Montana US 2020-04-03 22:46:37 48.29575866 -114.05205690000001 18 0 0 0 Flathead, Montana, US
1754 1754 38071 Ramsey North Dakota US 2020-04-03 22:46:37 48.26886249 -98.72223879 3 0 0 0 Ramsey, North Dakota, US
1671 1671 38069 Pierce North Dakota US 2020-04-03 22:46:37 48.24977025 -99.96407787 2 0 0 0 Pierce, North Dakota, US
1119 1119 27071 Koochiching Minnesota US 2020-04-03 22:46:37 48.24539665 -93.78352843 1 0 0 0 Koochiching, Minnesota, US
1369 1369 38049 McHenry North Dakota US 2020-04-03 22:46:37 48.23104458 -100.6324822 1 1 0 0 McHenry, North Dakota, US
2186 2186 38101 Ward North Dakota US 2020-04-03 22:46:37 48.22390169 -101.54367629999999 14 0 0 0 Ward, North Dakota, US
1489 1489 38061 Mountrail North Dakota US 2020-04-03 22:46:37 48.20197971 -102.3555315 11 0 0 0 Mountrail, North Dakota, US
993 993 53029 Island Washington US 2020-04-03 22:46:37 48.14713305 -122.5216407 119 5 0 0 Island, Washington, US
395 395 53009 Clallam Washington US 2020-04-03 22:46:37 48.04754642 -123.92263190000001 8 0 0 0 Clallam, Washington, US
1921 1921 53061 Snohomish Washington US 2020-04-03 22:46:37 48.04615983 -121.7170703 1376 54 0 0 Snohomish, Washington, US
2534 2534       Kazakhstan 2020-04-03 22:46:20 48.0196 66.9237 464 6 29 429 Kazakhstan
132 132 27007 Beltrami Minnesota US 2020-04-03 22:46:37 47.97373527 -94.93732139 4 0 0 0 Beltrami, Minnesota, US
803 803 38035 Grand Forks North Dakota US 2020-04-03 22:46:37 47.92093639 -97.45450447 6 0 0 0 Grand Forks, North Dakota, US
358 358 53007 Chelan Washington US 2020-04-03 22:46:37 47.87046092 -120.6173956 20 2 0 0 Chelan, Washington, US
2392 2392     Heilongjiang China 2020-04-03 00:10:11 47.861999999999995 127.7615 489 13 469 7 Heilongjiang, China
1042 1042 53031 Jefferson Washington US 2020-04-03 22:46:37 47.75003077 -123.56097040000002 19 0 0 0 Jefferson, Washington, US
1373 1373 38053 McKenzie North Dakota US 2020-04-03 22:46:37 47.74133370000001 -103.395905 2 0 0 0 McKenzie, North Dakota, US
617 617 53017 Douglas Washington US 2020-04-03 22:46:37 47.7361335 -119.69293700000001 6 0 0 0 Douglas, Washington, US
643 643 38027 Eddy North Dakota US 2020-04-03 22:46:37 47.71701474 -98.90432337 1 0 0 0 Eddy, North Dakota, US
1120 1120 16055 Kootenai Idaho US 2020-04-03 22:46:37 47.67282258 -116.7020872 37 0 0 0 Kootenai, Idaho, US
1141 1141 30047 Lake Montana US 2020-04-03 22:46:37 47.64514965 -114.0898013 4 0 0 0 Lake, Montana, US
1108 1108 53035 Kitsap Washington US 2020-04-03 22:46:37 47.63479026 -122.6436061 95 0 0 0 Kitsap, Washington, US
1937 1937 53063 Spokane Washington US 2020-04-03 22:46:37 47.62113146 -117.4046494 194 11 0 0 Spokane, Washington, US
1377 1377 38055 McLean North Dakota US 2020-04-03 22:46:37 47.60766714 -101.3182418 2 0 0 0 McLean, North Dakota, US
1956 1956 27137 St. Louis Minnesota US 2020-04-03 22:46:37 47.604840700000004 -92.46879855 13 0 0 0 St. Louis, Minnesota, US
430 430 27029 Clearwater Minnesota US 2020-04-03 22:46:37 47.57992111 -95.37790562 2 0 0 0 Clearwater, Minnesota, US
1232 1232 53043 Lincoln Washington US 2020-04-03 22:46:37 47.57705241 -118.41943880000001 1 0 0 0 Lincoln, Washington, US
2457 2457       Austria 2020-04-03 22:46:20 47.5162 14.5501 11524 168 2022 9334 Austria
995 995 27061 Itasca Minnesota US 2020-04-03 22:46:37 47.51009045 -93.63092229 2 0 0 0 Itasca, Minnesota, US
1100 1100 53033 King Washington US 2020-04-03 22:46:37 47.49137892 -121.8346131 2787 217 0 0 King, Washington, US
715 715 38031 Foster North Dakota US 2020-04-03 22:46:37 47.457108399999996 -98.88279923 1 0 0 0 Foster, North Dakota, US
2558 2558       Moldova 2020-04-03 22:46:20 47.4116 28.3699 591 8 26 557 Moldova
626 626 38025 Dunn North Dakota US 2020-04-03 22:46:37 47.35423935 -102.61604679999999 1 0 0 0 Dunn, North Dakota, US
1349 1349 53045 Mason Washington US 2020-04-03 22:46:37 47.35007586 -123.1863685 13 0 0 0 Mason, Washington, US
1304 1304 27087 Mahnomen Minnesota US 2020-04-03 22:46:37 47.32557075 -95.80921485 1 0 0 0 Mahnomen, Minnesota, US
314 314 30013 Cascade Montana US 2020-04-03 22:46:37 47.30797024 -111.3467922 11 0 0 0 Cascade, Montana, US
813 813 53025 Grant Washington US 2020-04-03 22:46:37 47.20753737 -119.4500749 75 2 0 0 Grant, Washington, US
2522 2522       Hungary 2020-04-03 22:46:20 47.1625 19.5033 623 26 43 554 Hungary
818 818 53027 Grays Harbor Washington US 2020-04-03 22:46:37 47.14003705 -123.7820567 2 0 0 0 Grays Harbor, Washington, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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