04-05-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,765 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
2520 2520     Greenland Denmark 2020-04-05 23:06:26 71.7069 -42.6043 11 0 3 8 Greenland, Denmark
2553 2553     Nunavut Canada 2020-04-05 23:13:28 70.2998 -83.1076 0 0 0 0 Nunavut, Canada
2492 2492 2290 Yukon-Koyukuk Alaska US 2020-04-05 23:06:45 65.50815459 -151.39073869999999 1 0 0 0 Yukon-Koyukuk, Alaska, US
2660 2660       Iceland 2020-04-05 23:06:26 64.9631 -19.0208 1486 4 428 1054 Iceland
2551 2551     Northwest Territories Canada 2020-04-05 23:13:28 64.8255 -124.8457 4 0 0 0 ,Northwest Territories,Canada
712 712 2090 Fairbanks North Star Alaska US 2020-04-05 23:06:45 64.80726247 -146.5692662 53 0 0 0 Fairbanks North Star, Alaska, US
2583 2583     Yukon Canada 2020-04-05 23:13:28 64.2823 -135.0 6 0 0 0 ,Yukon,Canada
2049 2049 2240 Southeast Fairbanks Alaska US 2020-04-05 23:06:45 63.87692095 -143.2127643 1 0 0 0 Southeast Fairbanks, Alaska, US
1433 1433 2170 Matanuska-Susitna Alaska US 2020-04-05 23:06:45 62.31305045 -149.5741743 4 0 0 0 Matanuska-Susitna, Alaska, US
2643 2643       Finland 2020-04-05 23:06:26 61.92411 25.748151 1927 28 300 1599 Finland
2512 2512     Faroe Islands Denmark 2020-04-05 23:06:26 61.8926 -6.9118 181 0 99 82 Faroe Islands, Denmark
2721 2721       Russia 2020-04-05 23:06:26 61.52401 105.31875600000001 5389 45 355 4989 Russia
48 48 2020 Anchorage Alaska US 2020-04-05 23:06:45 61.14998174 -149.14269860000005 85 1 0 0 Anchorage, Alaska, US
2709 2709       Norway 2020-04-05 23:06:26 60.472 8.4689 5687 71 32 5584 Norway
1150 1150 2122 Kenai Peninsula Alaska US 2020-04-05 23:06:45 60.24429722 -151.53888840000005 12 0 0 0 Kenai Peninsula, Alaska, US
2743 2743       Sweden 2020-04-05 23:06:26 60.128161 18.643501 6830 401 205 6224 Sweden
2639 2639       Estonia 2020-04-05 23:06:26 58.5953 25.0136 1097 15 62 1020 Estonia
1133 1133 2110 Juneau Alaska US 2020-04-05 23:06:45 58.45031811 -134.200436 14 0 0 0 Juneau, Alaska, US
1757 1757 2195 Petersburg Alaska US 2020-04-05 23:06:45 57.13978948 -132.9540995 1 0 0 0 Petersburg, Alaska, US
2678 2678       Latvia 2020-04-05 23:06:26 56.8796 24.6032 533 1 1 531 Latvia
2629 2629       Denmark 2020-04-05 23:06:26 56.2639 9.5018 4369 179 1327 2863 Denmark
1164 1164 2130 Ketchikan Gateway Alaska US 2020-04-05 23:06:45 55.57445008 -130.975561 14 0 0 0 Ketchikan Gateway, Alaska, US
2757 2757       United Kingdom 2020-04-05 23:06:26 55.3781 -3.4360000000000004 47806 4934 135 42737 United Kingdom
2683 2683       Lithuania 2020-04-05 23:06:26 55.1694 23.8813 716 8 0 791 Lithuania
2534 2534     Isle of Man United Kingdom 2020-04-05 23:06:26 54.2361 -4.5481 127 1 0 126 Isle of Man, United Kingdom
2495 2495     Alberta Canada 2020-04-05 23:13:28 53.9333 -116.5765 1181 20 0 0 Alberta, Canada
2540 2540     Manitoba Canada 2020-04-05 23:13:28 53.7609 -98.8139 203 2 0 0 Manitoba, Canada
2503 2503     British Columbia Canada 2020-04-05 23:13:28 53.7267 -127.6476 1203 38 0 0 British Columbia, Canada
2600 2600       Belarus 2020-04-05 23:06:26 53.7098 27.9534 562 8 52 502 Belarus
2665 2665       Ireland 2020-04-05 23:06:26 53.1424 -7.6921 4994 158 25 4811 Ireland
2547 2547     Newfoundland and Labrador Canada 2020-04-05 23:13:28 53.1355 -57.6604 217 1 0 0 Newfoundland and Labrador, Canada
2558 2558     Quebec Canada 2020-04-05 23:13:28 52.9399 -73.5491 7944 251 0 0 Quebec, Canada
2566 2566     Saskatchewan Canada 2020-04-05 23:13:28 52.9399 -106.4509 249 3 0 0 Saskatchewan, Canada
2703 2703       Netherlands 2020-04-05 23:06:26 52.1326 5.2913 17851 1766 250 15835 Netherlands
2717 2717       Poland 2020-04-05 23:06:26 51.9194 19.1451 4102 94 134 3874 Poland
2554 2554     Ontario Canada 2020-04-05 23:13:28 51.2538 -85.3232 4354 119 0 0 Ontario, Canada
2648 2648       Germany 2020-04-05 23:06:26 51.165690999999995 10.451526 100123 1584 28700 69839 Germany
2601 2601       Belgium 2020-04-05 23:06:26 50.8333 4.469936 19691 1447 3751 14493 Belgium
2628 2628       Czechia 2020-04-05 23:06:26 49.8175 15.472999999999999 4587 67 96 4424 Czechia
2684 2684       Luxembourg 2020-04-05 23:06:26 49.8153 6.1296 2804 36 500 2268 Luxembourg
2506 2506     Channel Islands United Kingdom 2020-04-05 23:06:26 49.3723 -2.3644 309 6 27 276 Channel Islands, United Kingdom
2405 2405 53073 Whatcom Washington US 2020-04-05 23:06:45 48.82227976 -121.74900179999999 224 18 0 0 Whatcom, Washington, US
631 631 38023 Divide North Dakota US 2020-04-05 23:06:45 48.814938700000006 -103.48736109999999 1 0 0 0 Divide, North Dakota, US
248 248 38013 Burke North Dakota US 2020-04-05 23:06:45 48.79094471 -102.51821170000001 2 0 0 0 Burke, North Dakota, US
1915 1915 38079 Rolette North Dakota US 2020-04-05 23:06:45 48.77245354 -99.84097493 0 0 0 0 Rolette, North Dakota, US
826 826 30035 Glacier Montana US 2020-04-05 23:06:45 48.70513576 -112.9934235 1 0 0 0 Glacier, Montana, US
2734 2734       Slovakia 2020-04-05 23:06:26 48.669 19.699 485 1 10 474 Slovakia
2187 2187 30101 Toole Montana US 2020-04-05 23:06:45 48.65577551 -111.69424140000001 15 3 0 0 Toole, Montana, US
987 987 30041 Hill Montana US 2020-04-05 23:06:45 48.62879827 -110.1129252 1 0 0 0 Hill, Montana, US
1954 1954 53055 San Juan Washington US 2020-04-05 23:06:45 48.60182783 -122.96745 7 0 0 0 San Juan, Washington, US
1282 1282 30051 Liberty Montana US 2020-04-05 23:06:45 48.56084317 -111.02430700000001 1 0 0 0 Liberty, Montana, US
1657 1657 53047 Okanogan Washington US 2020-04-05 23:06:45 48.54855019 -119.73872240000001 7 0 0 0 Okanogan, Washington, US
1296 1296 30053 Lincoln Montana US 2020-04-05 23:06:45 48.54265777 -115.4046155 6 1 0 0 Lincoln, Montana, US
1739 1739 53051 Pend Oreille Washington US 2020-04-05 23:06:45 48.53234021 -117.2741804 1 0 0 0 Pend Oreille, Washington, US
2032 2032 53057 Skagit Washington US 2020-04-05 23:06:45 48.48171488 -121.766131 161 4 0 0 Skagit, Washington, US
738 738 53019 Ferry Washington US 2020-04-05 23:06:45 48.471143100000006 -118.5154041 1 0 0 0 Ferry, Washington, US
2100 2100 53065 Stevens Washington US 2020-04-05 23:06:45 48.40035475 -117.8542701 5 0 0 0 Stevens, Washington, US
2755 2755       Ukraine 2020-04-05 23:06:26 48.3794 31.1656 1308 37 28 1243 Ukraine
2312 2312 38099 Walsh North Dakota US 2020-04-05 23:06:45 48.36876964 -97.72574783 1 0 0 0 Walsh, North Dakota, US
2427 2427 38105 Williams North Dakota US 2020-04-05 23:06:45 48.34522353 -103.4793387 5 0 0 0 Williams, North Dakota, US
185 185 16017 Bonner Idaho US 2020-04-05 23:06:45 48.29996017 -116.6017932 2 0 0 0 Bonner, Idaho, US
1916 1916 30085 Roosevelt Montana US 2020-04-05 23:06:45 48.29607488 -105.00792679999999 1 0 0 0 Roosevelt, Montana, US
742 742 30029 Flathead Montana US 2020-04-05 23:06:45 48.29575866 -114.05205690000001 24 0 0 0 Flathead, Montana, US
1859 1859 38071 Ramsey North Dakota US 2020-04-05 23:06:45 48.26886249 -98.72223879 3 0 0 0 Ramsey, North Dakota, US
1771 1771 38069 Pierce North Dakota US 2020-04-05 23:06:45 48.24977025 -99.96407787 2 0 0 0 Pierce, North Dakota, US
1186 1186 27071 Koochiching Minnesota US 2020-04-05 23:06:45 48.24539665 -93.78352843 1 0 0 0 Koochiching, Minnesota, US
1449 1449 38049 McHenry North Dakota US 2020-04-05 23:06:45 48.23104458 -100.6324822 1 1 0 0 McHenry, North Dakota, US
2318 2318 38101 Ward North Dakota US 2020-04-05 23:06:45 48.22390169 -101.54367629999999 14 0 0 0 Ward, North Dakota, US
1578 1578 38061 Mountrail North Dakota US 2020-04-05 23:06:45 48.20197971 -102.3555315 19 0 0 0 Mountrail, North Dakota, US
1052 1052 53029 Island Washington US 2020-04-05 23:06:45 48.14713305 -122.5216407 130 6 0 0 Island, Washington, US
417 417 53009 Clallam Washington US 2020-04-05 23:06:45 48.04754642 -123.92263190000001 8 0 0 0 Clallam, Washington, US
2039 2039 53061 Snohomish Washington US 2020-04-05 23:06:45 48.04615983 -121.7170703 1559 61 0 0 Snohomish, Washington, US
2671 2671       Kazakhstan 2020-04-05 23:06:26 48.0196 66.9237 584 6 42 536 Kazakhstan
141 141 27007 Beltrami Minnesota US 2020-04-05 23:06:45 47.97373527 -94.93732139 6 0 0 0 Beltrami, Minnesota, US
850 850 38035 Grand Forks North Dakota US 2020-04-05 23:06:45 47.92093639 -97.45450447 11 0 0 0 Grand Forks, North Dakota, US
379 379 53007 Chelan Washington US 2020-04-05 23:06:45 47.87046092 -120.6173956 29 2 0 0 Chelan, Washington, US
2528 2528     Heilongjiang China 2020-04-05 01:08:02 47.861999999999995 127.7615 504 13 469 22 Heilongjiang, China
1805 1805 27119 Polk Minnesota US 2020-04-05 23:06:45 47.77372465 -96.40134647 1 0 0 0 Polk, Minnesota, US
1105 1105 53031 Jefferson Washington US 2020-04-05 23:06:45 47.75003077 -123.56097040000002 20 0 0 0 Jefferson, Washington, US
1454 1454 38053 McKenzie North Dakota US 2020-04-05 23:06:45 47.74133370000001 -103.395905 3 0 0 0 McKenzie, North Dakota, US
653 653 53017 Douglas Washington US 2020-04-05 23:06:45 47.7361335 -119.69293700000001 10 0 0 0 Douglas, Washington, US
679 679 38027 Eddy North Dakota US 2020-04-05 23:06:45 47.71701474 -98.90432337 1 0 0 0 Eddy, North Dakota, US
1187 1187 16055 Kootenai Idaho US 2020-04-05 23:06:45 47.67282258 -116.7020872 40 0 0 0 Kootenai, Idaho, US
1209 1209 30047 Lake Montana US 2020-04-05 23:06:45 47.64514965 -114.0898013 4 0 0 0 Lake, Montana, US
1175 1175 53035 Kitsap Washington US 2020-04-05 23:06:45 47.63479026 -122.6436061 104 0 0 0 Kitsap, Washington, US
2055 2055 53063 Spokane Washington US 2020-04-05 23:06:45 47.62113146 -117.4046494 219 12 0 0 Spokane, Washington, US
1458 1458 38055 McLean North Dakota US 2020-04-05 23:06:45 47.60766714 -101.3182418 2 0 0 0 McLean, North Dakota, US
2074 2074 27137 St. Louis Minnesota US 2020-04-05 23:06:45 47.604840700000004 -92.46879855 15 0 0 0 St. Louis, Minnesota, US
454 454 27029 Clearwater Minnesota US 2020-04-05 23:06:45 47.57992111 -95.37790562 2 0 0 0 Clearwater, Minnesota, US
1304 1304 53043 Lincoln Washington US 2020-04-05 23:06:45 47.57705241 -118.41943880000001 1 0 0 0 Lincoln, Washington, US
2594 2594       Austria 2020-04-05 23:06:26 47.5162 14.5501 12051 204 2998 8849 Austria
1054 1054 27061 Itasca Minnesota US 2020-04-05 23:06:45 47.51009045 -93.63092229 2 0 0 0 Itasca, Minnesota, US
1166 1166 53033 King Washington US 2020-04-05 23:06:45 47.49137892 -121.8346131 3167 245 0 0 King, Washington, US
757 757 38031 Foster North Dakota US 2020-04-05 23:06:45 47.457108399999996 -98.88279923 1 0 0 0 Foster, North Dakota, US
2695 2695       Moldova 2020-04-05 23:06:26 47.4116 28.3699 864 15 30 819 Moldova
662 662 38025 Dunn North Dakota US 2020-04-05 23:06:45 47.35423935 -102.61604679999999 1 0 0 0 Dunn, North Dakota, US
1429 1429 53045 Mason Washington US 2020-04-05 23:06:45 47.35007586 -123.1863685 14 0 0 0 Mason, Washington, US
1378 1378 27087 Mahnomen Minnesota US 2020-04-05 23:06:45 47.32557075 -95.80921485 1 0 0 0 Mahnomen, Minnesota, US
1482 1482 38057 Mercer North Dakota US 2020-04-05 23:06:45 47.31213126 -101.8318399 0 0 0 0 Mercer, North Dakota, US
333 333 30013 Cascade Montana US 2020-04-05 23:06:45 47.30797024 -111.3467922 11 0 0 0 Cascade, Montana, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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