04-07-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,858 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
2613 2613     Greenland Denmark 2020-04-07 23:04:29 71.7069 -42.6043 11 0 10 1 Greenland, Denmark
2646 2646     Nunavut Canada 2020-04-07 23:11:15 70.2998 -83.1076 0 0 0 0 Nunavut, Canada
2584 2584 2290 Yukon-Koyukuk Alaska US 2020-04-07 23:04:49 65.50815459 -151.39073869999999 1 0 0 0 Yukon-Koyukuk, Alaska, US
2753 2753       Iceland 2020-04-07 23:04:29 64.9631 -19.0208 1586 6 559 1021 Iceland
2644 2644     Northwest Territories Canada 2020-04-07 23:11:15 64.8255 -124.8457 5 0 0 0 ,Northwest Territories,Canada
736 736 2090 Fairbanks North Star Alaska US 2020-04-07 23:04:49 64.80726247 -146.5692662 65 1 0 0 Fairbanks North Star, Alaska, US
2676 2676     Yukon Canada 2020-04-07 23:11:15 64.2823 -135.0 7 0 0 0 ,Yukon,Canada
2127 2127 2240 Southeast Fairbanks Alaska US 2020-04-07 23:04:49 63.87692095 -143.2127643 1 0 0 0 Southeast Fairbanks, Alaska, US
1487 1487 2170 Matanuska-Susitna Alaska US 2020-04-07 23:04:49 62.31305045 -149.5741743 4 0 0 0 Matanuska-Susitna, Alaska, US
2736 2736       Finland 2020-04-07 23:04:29 61.92411 25.748151 2308 34 300 1974 Finland
2605 2605     Faroe Islands Denmark 2020-04-07 23:04:29 61.8926 -6.9118 184 0 120 64 Faroe Islands, Denmark
2814 2814       Russia 2020-04-07 23:04:29 61.52401 105.31875600000001 7497 58 494 6945 Russia
48 48 2020 Anchorage Alaska US 2020-04-07 23:04:49 61.14998174 -149.14269860000005 98 4 0 0 Anchorage, Alaska, US
166 166 2050 Bethel Alaska US 2020-04-07 23:04:49 60.90980451 -159.8561831 1 0 0 0 Bethel, Alaska, US
2802 2802       Norway 2020-04-07 23:04:29 60.472 8.4689 6086 89 32 5965 Norway
1190 1190 2122 Kenai Peninsula Alaska US 2020-04-07 23:04:49 60.24429722 -151.53888840000005 13 0 0 0 Kenai Peninsula, Alaska, US
2837 2837       Sweden 2020-04-07 23:04:29 60.128161 18.643501 7693 591 205 6897 Sweden
2732 2732       Estonia 2020-04-07 23:04:29 58.5953 25.0136 1149 21 69 1059 Estonia
1173 1173 2110 Juneau Alaska US 2020-04-07 23:04:49 58.45031811 -134.200436 14 0 0 0 Juneau, Alaska, US
1823 1823 2195 Petersburg Alaska US 2020-04-07 23:04:49 57.13978948 -132.9540995 2 0 0 0 Petersburg, Alaska, US
2771 2771       Latvia 2020-04-07 23:04:29 56.8796 24.6032 548 2 16 530 Latvia
2722 2722       Denmark 2020-04-07 23:04:29 56.2639 9.5018 5071 203 1491 3377 Denmark
1204 1204 2130 Ketchikan Gateway Alaska US 2020-04-07 23:04:49 55.57445008 -130.975561 14 0 0 0 Ketchikan Gateway, Alaska, US
2851 2851       United Kingdom 2020-04-07 23:04:29 55.3781 -3.4360000000000004 55242 6159 135 48948 United Kingdom
2776 2776       Lithuania 2020-04-07 23:04:29 55.1694 23.8813 783 11 0 857 Lithuania
2627 2627     Isle of Man United Kingdom 2020-04-07 23:04:29 54.2361 -4.5481 150 1 73 76 Isle of Man, United Kingdom
2588 2588     Alberta Canada 2020-04-07 23:11:15 53.9333 -116.5765 1373 24 0 0 Alberta, Canada
2633 2633     Manitoba Canada 2020-04-07 23:11:15 53.7609 -98.8139 217 3 0 0 Manitoba, Canada
2596 2596     British Columbia Canada 2020-04-07 23:11:15 53.7267 -127.6476 1266 39 0 0 British Columbia, Canada
2693 2693       Belarus 2020-04-07 23:04:29 53.7098 27.9534 861 13 54 794 Belarus
2758 2758       Ireland 2020-04-07 23:04:29 53.1424 -7.6921 5709 210 25 5474 Ireland
2640 2640     Newfoundland and Labrador Canada 2020-04-07 23:11:15 53.1355 -57.6604 228 1 0 0 Newfoundland and Labrador, Canada
2651 2651     Quebec Canada 2020-04-07 23:11:15 52.9399 -73.5491 9340 356 0 0 Quebec, Canada
2659 2659     Saskatchewan Canada 2020-04-07 23:11:15 52.9399 -106.4509 260 3 0 0 Saskatchewan, Canada
2796 2796       Netherlands 2020-04-07 23:04:29 52.1326 5.2913 19580 2101 250 17229 Netherlands
2810 2810       Poland 2020-04-07 23:04:29 51.9194 19.1451 4848 129 191 4528 Poland
2647 2647     Ontario Canada 2020-04-07 23:11:15 51.2538 -85.3232 4726 153 0 0 Ontario, Canada
2741 2741       Germany 2020-04-07 23:04:29 51.165690999999995 10.451526 107663 2016 36081 69566 Germany
2694 2694       Belgium 2020-04-07 23:04:29 50.8333 4.469936 22194 2035 4157 16002 Belgium
2721 2721       Czechia 2020-04-07 23:04:29 49.8175 15.472999999999999 5017 88 172 4757 Czechia
2777 2777       Luxembourg 2020-04-07 23:04:29 49.8153 6.1296 2970 44 500 2426 Luxembourg
2599 2599     Channel Islands United Kingdom 2020-04-07 23:04:29 49.3723 -2.3644 335 7 34 294 Channel Islands, United Kingdom
2495 2495 53073 Whatcom Washington US 2020-04-07 23:04:49 48.82227976 -121.74900179999999 238 20 0 0 Whatcom, Washington, US
653 653 38023 Divide North Dakota US 2020-04-07 23:04:49 48.814938700000006 -103.48736109999999 1 0 0 0 Divide, North Dakota, US
255 255 38013 Burke North Dakota US 2020-04-07 23:04:49 48.79094471 -102.51821170000001 2 0 0 0 Burke, North Dakota, US
1989 1989 38079 Rolette North Dakota US 2020-04-07 23:04:49 48.77245354 -99.84097493 0 0 0 0 Rolette, North Dakota, US
855 855 30035 Glacier Montana US 2020-04-07 23:04:49 48.70513576 -112.9934235 1 0 0 0 Glacier, Montana, US
2828 2828       Slovakia 2020-04-07 23:04:29 48.669 19.699 581 2 13 566 Slovakia
2269 2269 30101 Toole Montana US 2020-04-07 23:04:49 48.65577551 -111.69424140000001 15 3 0 0 Toole, Montana, US
1023 1023 30041 Hill Montana US 2020-04-07 23:04:49 48.62879827 -110.1129252 1 0 0 0 Hill, Montana, US
2028 2028 53055 San Juan Washington US 2020-04-07 23:04:49 48.60182783 -122.96745 10 0 0 0 San Juan, Washington, US
1330 1330 30051 Liberty Montana US 2020-04-07 23:04:49 48.56084317 -111.02430700000001 1 0 0 0 Liberty, Montana, US
1720 1720 53047 Okanogan Washington US 2020-04-07 23:04:49 48.54855019 -119.73872240000001 9 0 0 0 Okanogan, Washington, US
1344 1344 30053 Lincoln Montana US 2020-04-07 23:04:49 48.54265777 -115.4046155 7 1 0 0 Lincoln, Montana, US
1805 1805 53051 Pend Oreille Washington US 2020-04-07 23:04:49 48.53234021 -117.2741804 1 0 0 0 Pend Oreille, Washington, US
2110 2110 53057 Skagit Washington US 2020-04-07 23:04:49 48.48171488 -121.766131 166 5 0 0 Skagit, Washington, US
763 763 53019 Ferry Washington US 2020-04-07 23:04:49 48.471143100000006 -118.5154041 1 0 0 0 Ferry, Washington, US
2179 2179 53065 Stevens Washington US 2020-04-07 23:04:49 48.40035475 -117.8542701 5 0 0 0 Stevens, Washington, US
2849 2849       Ukraine 2020-04-07 23:04:29 48.3794 31.1656 1462 45 28 1389 Ukraine
2402 2402 38099 Walsh North Dakota US 2020-04-07 23:04:49 48.36876964 -97.72574783 3 0 0 0 Walsh, North Dakota, US
2517 2517 38105 Williams North Dakota US 2020-04-07 23:04:49 48.34522353 -103.4793387 5 0 0 0 Williams, North Dakota, US
189 189 16017 Bonner Idaho US 2020-04-07 23:04:49 48.29996017 -116.6017932 3 0 0 0 Bonner, Idaho, US
1990 1990 30085 Roosevelt Montana US 2020-04-07 23:04:49 48.29607488 -105.00792679999999 1 0 0 0 Roosevelt, Montana, US
767 767 30029 Flathead Montana US 2020-04-07 23:04:49 48.29575866 -114.05205690000001 31 0 0 0 Flathead, Montana, US
1930 1930 38071 Ramsey North Dakota US 2020-04-07 23:04:49 48.26886249 -98.72223879 3 0 0 0 Ramsey, North Dakota, US
1838 1838 38069 Pierce North Dakota US 2020-04-07 23:04:49 48.24977025 -99.96407787 2 0 0 0 Pierce, North Dakota, US
1228 1228 27071 Koochiching Minnesota US 2020-04-07 23:04:49 48.24539665 -93.78352843 1 0 0 0 Koochiching, Minnesota, US
1505 1505 38049 McHenry North Dakota US 2020-04-07 23:04:49 48.23104458 -100.6324822 1 1 0 0 McHenry, North Dakota, US
2408 2408 38101 Ward North Dakota US 2020-04-07 23:04:49 48.22390169 -101.54367629999999 16 0 0 0 Ward, North Dakota, US
1639 1639 38061 Mountrail North Dakota US 2020-04-07 23:04:49 48.20197971 -102.3555315 20 0 0 0 Mountrail, North Dakota, US
1089 1089 53029 Island Washington US 2020-04-07 23:04:49 48.14713305 -122.5216407 142 6 0 0 Island, Washington, US
428 428 53009 Clallam Washington US 2020-04-07 23:04:49 48.04754642 -123.92263190000001 8 0 0 0 Clallam, Washington, US
2117 2117 53061 Snohomish Washington US 2020-04-07 23:04:49 48.04615983 -121.7170703 1659 64 0 0 Snohomish, Washington, US
2764 2764       Kazakhstan 2020-04-07 23:04:29 48.0196 66.9237 697 6 51 640 Kazakhstan
144 144 27007 Beltrami Minnesota US 2020-04-07 23:04:49 47.97373527 -94.93732139 6 0 0 0 Beltrami, Minnesota, US
879 879 38035 Grand Forks North Dakota US 2020-04-07 23:04:49 47.92093639 -97.45450447 11 0 0 0 Grand Forks, North Dakota, US
388 388 53007 Chelan Washington US 2020-04-07 23:04:49 47.87046092 -120.6173956 34 2 0 0 Chelan, Washington, US
2621 2621     Heilongjiang China 2020-04-07 00:20:57 47.861999999999995 127.7615 544 13 469 62 Heilongjiang, China
1873 1873 27119 Polk Minnesota US 2020-04-07 23:04:49 47.77372465 -96.40134647 1 0 0 0 Polk, Minnesota, US
1145 1145 53031 Jefferson Washington US 2020-04-07 23:04:49 47.75003077 -123.56097040000002 27 0 0 0 Jefferson, Washington, US
1510 1510 38053 McKenzie North Dakota US 2020-04-07 23:04:49 47.74133370000001 -103.395905 5 0 0 0 McKenzie, North Dakota, US
675 675 53017 Douglas Washington US 2020-04-07 23:04:49 47.7361335 -119.69293700000001 10 0 0 0 Douglas, Washington, US
702 702 38027 Eddy North Dakota US 2020-04-07 23:04:49 47.71701474 -98.90432337 1 0 0 0 Eddy, North Dakota, US
1229 1229 16055 Kootenai Idaho US 2020-04-07 23:04:49 47.67282258 -116.7020872 43 0 0 0 Kootenai, Idaho, US
1253 1253 30047 Lake Montana US 2020-04-07 23:04:49 47.64514965 -114.0898013 5 0 0 0 Lake, Montana, US
1216 1216 53035 Kitsap Washington US 2020-04-07 23:04:49 47.63479026 -122.6436061 119 1 0 0 Kitsap, Washington, US
2133 2133 53063 Spokane Washington US 2020-04-07 23:04:49 47.62113146 -117.4046494 222 13 0 0 Spokane, Washington, US
1514 1514 38055 McLean North Dakota US 2020-04-07 23:04:49 47.60766714 -101.3182418 2 0 0 0 McLean, North Dakota, US
2152 2152 27137 St. Louis Minnesota US 2020-04-07 23:04:49 47.604840700000004 -92.46879855 17 0 0 0 St. Louis, Minnesota, US
466 466 27029 Clearwater Minnesota US 2020-04-07 23:04:49 47.57992111 -95.37790562 2 0 0 0 Clearwater, Minnesota, US
1352 1352 53043 Lincoln Washington US 2020-04-07 23:04:49 47.57705241 -118.41943880000001 1 0 0 0 Lincoln, Washington, US
2687 2687       Austria 2020-04-07 23:04:29 47.5162 14.5501 12639 243 4046 8350 Austria
1091 1091 27061 Itasca Minnesota US 2020-04-07 23:04:49 47.51009045 -93.63092229 2 0 0 0 Itasca, Minnesota, US
1207 1207 53033 King Washington US 2020-04-07 23:04:49 47.49137892 -121.8346131 3486 273 0 0 King, Washington, US
783 783 38031 Foster North Dakota US 2020-04-07 23:04:49 47.457108399999996 -98.88279923 1 0 0 0 Foster, North Dakota, US
2788 2788       Moldova 2020-04-07 23:04:29 47.4116 28.3699 1056 22 40 994 Moldova
684 684 38025 Dunn North Dakota US 2020-04-07 23:04:49 47.35423935 -102.61604679999999 1 0 0 0 Dunn, North Dakota, US
1483 1483 53045 Mason Washington US 2020-04-07 23:04:49 47.35007586 -123.1863685 16 0 0 0 Mason, Washington, US
1430 1430 27087 Mahnomen Minnesota US 2020-04-07 23:04:49 47.32557075 -95.80921485 1 0 0 0 Mahnomen, Minnesota, US
1539 1539 38057 Mercer North Dakota US 2020-04-07 23:04:49 47.31213126 -101.8318399 0 0 0 0 Mercer, North Dakota, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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