05-04-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,203 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
2955 2955     Greenland Denmark 2020-05-05 02:32:34 71.7069 -42.6043 11 0 11 0 Greenland, Denmark
2988 2988     Nunavut Canada 2020-05-05 02:32:34 70.2998 -83.1076 0 0 0 0 Nunavut, Canada
2925 2925 2290 Yukon-Koyukuk Alaska US 2020-05-05 02:32:34 65.50815459 -151.39073869999999 1 0 0 1 Yukon-Koyukuk, Alaska, US
3096 3096       Iceland 2020-05-05 02:32:34 64.9631 -19.0208 1799 10 1723 66 Iceland
1909 1909 2180 Nome Alaska US 2020-05-05 02:32:34 64.90320724 -164.0353804 1 0 0 1 Nome, Alaska, US
2986 2986     Northwest Territories Canada 2020-05-05 02:32:34 64.8255 -124.8457 5 0 0 5 Northwest Territories, Canada
816 816 2090 Fairbanks North Star Alaska US 2020-05-05 02:32:34 64.80726247 -146.5692662 83 2 0 81 Fairbanks North Star, Alaska, US
3018 3018     Yukon Canada 2020-05-05 02:32:34 64.2823 -135.0 11 0 0 11 Yukon, Canada
2412 2412 2240 Southeast Fairbanks Alaska US 2020-05-05 02:32:34 63.87692095 -143.2127643 1 0 0 1 Southeast Fairbanks, Alaska, US
1673 1673 2170 Matanuska-Susitna Alaska US 2020-05-05 02:32:34 62.31305045 -149.5741743 21 1 0 20 Matanuska-Susitna, Alaska, US
3079 3079       Finland 2020-05-05 02:32:34 61.92411 25.748151 5327 240 3500 1587 Finland
2947 2947     Faroe Islands Denmark 2020-05-05 02:32:34 61.8926 -6.9118 187 0 185 2 Faroe Islands, Denmark
3157 3157       Russia 2020-05-05 02:32:34 61.52401 105.31875600000001 145268 1356 18095 125817 Russia
53 53 2020 Anchorage Alaska US 2020-05-05 02:32:34 61.14998174 -149.14269860000005 189 4 0 185 Anchorage, Alaska, US
181 181 2050 Bethel Alaska US 2020-05-05 02:32:34 60.90980451 -159.8561831 1 0 0 1 Bethel, Alaska, US
3145 3145       Norway 2020-05-05 02:32:34 60.472 8.4689 7904 214 32 7658 Norway
1348 1348 2122 Kenai Peninsula Alaska US 2020-05-05 02:32:34 60.24429722 -151.53888840000005 22 1 0 21 Kenai Peninsula, Alaska, US
3180 3180       Sweden 2020-05-05 02:32:34 60.128161 18.643501 22721 2769 4074 15878 Sweden
3075 3075       Estonia 2020-05-05 02:32:34 58.5953 25.0136 1703 55 259 1389 Estonia
1329 1329 2110 Juneau Alaska US 2020-05-05 02:32:34 58.45031811 -134.200436 27 0 0 27 Juneau, Alaska, US
1390 1390 2150 Kodiak Island Alaska US 2020-05-05 02:32:34 57.65529415 -153.7493579 1 0 0 1 Kodiak Island, Alaska, US
2393 2393 2220 Sitka Alaska US 2020-05-05 02:32:34 57.24124555 -135.3206587 1 0 0 1 Sitka, Alaska, US
2057 2057 2195 Petersburg Alaska US 2020-05-05 02:32:34 57.13978948 -132.9540995 4 1 0 3 Petersburg, Alaska, US
3114 3114       Latvia 2020-05-05 02:32:34 56.8796 24.6032 896 16 348 532 Latvia
3065 3065       Denmark 2020-05-05 02:32:34 56.2639 9.5018 9670 493 7088 2089 Denmark
2151 2151 2198 Prince of Wales-Hyder Alaska US 2020-05-05 02:32:34 55.76261984 -133.0511621 2 0 0 2 Prince of Wales-Hyder, Alaska, US
1362 1362 2130 Ketchikan Gateway Alaska US 2020-05-05 02:32:34 55.57445008 -130.975561 16 0 0 16 Ketchikan Gateway, Alaska, US
3195 3195       United Kingdom 2020-05-05 02:32:34 55.3781 -3.4360000000000004 190584 28734 0 161850 United Kingdom
3119 3119       Lithuania 2020-05-05 02:32:34 55.1694 23.8813 1407 33 715 735 Lithuania
2969 2969     Isle of Man United Kingdom 2020-05-05 02:32:34 54.2361 -4.5481 325 23 271 31 Isle of Man, United Kingdom
2930 2930     Alberta Canada 2020-05-05 02:32:34 53.9333 -116.5765 5836 104 0 5732 Alberta, Canada
2975 2975     Manitoba Canada 2020-05-05 02:32:34 53.7609 -98.8139 283 6 0 277 Manitoba, Canada
2938 2938     British Columbia Canada 2020-05-05 02:32:34 53.7267 -127.6476 2224 117 0 2107 British Columbia, Canada
3035 3035       Belarus 2020-05-05 02:32:34 53.7098 27.9534 17489 103 3259 14127 Belarus
3101 3101       Ireland 2020-05-05 02:32:34 53.1424 -7.6921 21772 1319 13386 7067 Ireland
2982 2982     Newfoundland and Labrador Canada 2020-05-05 02:32:34 53.1355 -57.6604 259 3 0 256 Newfoundland and Labrador, Canada
2993 2993     Quebec Canada 2020-05-05 02:32:34 52.9399 -73.5491 32631 3189 0 30350 Quebec, Canada
3001 3001     Saskatchewan Canada 2020-05-05 02:32:34 52.9399 -106.4509 467 7 0 460 Saskatchewan, Canada
3139 3139       Netherlands 2020-05-05 02:32:34 52.1326 5.2913 40770 5082 0 35688 Netherlands
3153 3153       Poland 2020-05-05 02:32:34 51.9194 19.1451 14006 698 4095 9213 Poland
2989 2989     Ontario Canada 2020-05-05 02:32:34 51.2538 -85.3232 19097 1446 0 17651 Ontario, Canada
3084 3084       Germany 2020-05-05 02:32:34 51.165690999999995 10.451526 166152 6993 132700 26459 Germany
3036 3036       Belgium 2020-05-05 02:32:34 50.8333 4.469936 50267 7924 12378 29965 Belgium
3064 3064       Czechia 2020-05-05 02:32:34 49.8175 15.472999999999999 7819 252 3807 3760 Czechia
3120 3120       Luxembourg 2020-05-05 02:32:34 49.8153 6.1296 3828 96 3405 327 Luxembourg
2941 2941     Channel Islands United Kingdom 2020-05-05 02:32:34 49.3723 -2.3644 544 41 406 97 Channel Islands, United Kingdom
2825 2825 53073 Whatcom Washington US 2020-05-05 02:32:34 48.82227976 -121.74900179999999 317 28 0 289 Whatcom, Washington, US
725 725 38023 Divide North Dakota US 2020-05-05 02:32:34 48.814938700000006 -103.48736109999999 1 0 0 1 Divide, North Dakota, US
285 285 38013 Burke North Dakota US 2020-05-05 02:32:34 48.79094471 -102.51821170000001 3 0 0 3 Burke, North Dakota, US
1377 1377 27069 Kittson Minnesota US 2020-05-05 02:32:34 48.77754106 -96.78317184 1 0 0 1 Kittson, Minnesota, US
2258 2258 27135 Roseau Minnesota US 2020-05-05 02:32:34 48.77501878 -95.81079919 1 0 0 1 Roseau, Minnesota, US
2253 2253 38079 Rolette North Dakota US 2020-05-05 02:32:34 48.77245354 -99.84097493 1 0 0 1 Rolette, North Dakota, US
220 220 16021 Boundary Idaho US 2020-05-05 02:32:34 48.76684761 -116.4630179 0 0 0 0 Boundary, Idaho, US
2033 2033 38067 Pembina North Dakota US 2020-05-05 02:32:34 48.76623521 -97.5523809 3 0 0 3 Pembina, North Dakota, US
2207 2207 38075 Renville North Dakota US 2020-05-05 02:32:34 48.71982533 -101.6603912 1 0 0 1 Renville, North Dakota, US
955 955 30035 Glacier Montana US 2020-05-05 02:32:34 48.70513576 -112.9934235 6 0 0 6 Glacier, Montana, US
3171 3171       Slovakia 2020-05-05 02:32:34 48.669 19.699 1413 25 643 745 Slovakia
2571 2571 30101 Toole Montana US 2020-05-05 02:32:34 48.65577551 -111.69424140000001 29 6 0 23 Toole, Montana, US
1154 1154 30041 Hill Montana US 2020-05-05 02:32:34 48.62879827 -110.1129252 1 0 0 1 Hill, Montana, US
2300 2300 53055 San Juan Washington US 2020-05-05 02:32:34 48.60182783 -122.96745 14 0 0 14 San Juan, Washington, US
1501 1501 30051 Liberty Montana US 2020-05-05 02:32:34 48.56084317 -111.02430700000001 1 0 0 1 Liberty, Montana, US
1942 1942 53047 Okanogan Washington US 2020-05-05 02:32:34 48.54855019 -119.73872240000001 21 2 0 20 Okanogan, Washington, US
1516 1516 30053 Lincoln Montana US 2020-05-05 02:32:34 48.54265777 -115.4046155 7 1 0 6 Lincoln, Montana, US
2035 2035 53051 Pend Oreille Washington US 2020-05-05 02:32:34 48.53234021 -117.2741804 2 0 0 2 Pend Oreille, Washington, US
2394 2394 53057 Skagit Washington US 2020-05-05 02:32:34 48.48171488 -121.766131 357 12 0 344 Skagit, Washington, US
845 845 53019 Ferry Washington US 2020-05-05 02:32:34 48.471143100000006 -118.5154041 1 0 0 1 Ferry, Washington, US
2471 2471 53065 Stevens Washington US 2020-05-05 02:32:34 48.40035475 -117.8542701 9 1 0 8 Stevens, Washington, US
3193 3193       Ukraine 2020-05-05 02:32:34 48.3794 31.1656 12331 303 1619 10409 Ukraine
2721 2721 38099 Walsh North Dakota US 2020-05-05 02:32:34 48.36876964 -97.72574783 7 0 0 7 Walsh, North Dakota, US
1652 1652 27089 Marshall Minnesota US 2020-05-05 02:32:34 48.35825983 -96.37017407 7 0 0 7 Marshall, Minnesota, US
2852 2852 38105 Williams North Dakota US 2020-05-05 02:32:34 48.34522353 -103.4793387 11 0 0 11 Williams, North Dakota, US
207 207 16017 Bonner Idaho US 2020-05-05 02:32:34 48.29996017 -116.6017932 4 0 0 4 Bonner, Idaho, US
2255 2255 30085 Roosevelt Montana US 2020-05-05 02:32:34 48.29607488 -105.00792679999999 7 0 0 7 Roosevelt, Montana, US
850 850 30029 Flathead Montana US 2020-05-05 02:32:34 48.29575866 -114.05205690000001 37 2 0 35 Flathead, Montana, US
2181 2181 38071 Ramsey North Dakota US 2020-05-05 02:32:34 48.26886249 -98.72223879 3 0 0 3 Ramsey, North Dakota, US
2073 2073 38069 Pierce North Dakota US 2020-05-05 02:32:34 48.24977025 -99.96407787 2 0 0 2 Pierce, North Dakota, US
1391 1391 27071 Koochiching Minnesota US 2020-05-05 02:32:34 48.24539665 -93.78352843 1 0 0 1 Koochiching, Minnesota, US
1692 1692 38049 McHenry North Dakota US 2020-05-05 02:32:34 48.23104458 -100.6324822 1 1 0 0 McHenry, North Dakota, US
2121 2121 30073 Pondera Montana US 2020-05-05 02:32:34 48.22773388 -112.22527029999999 2 0 0 2 Pondera, Montana, US
2728 2728 38101 Ward North Dakota US 2020-05-05 02:32:34 48.22390169 -101.54367629999999 25 1 0 24 Ward, North Dakota, US
1848 1848 38061 Mountrail North Dakota US 2020-05-05 02:32:34 48.20197971 -102.3555315 35 0 0 35 Mountrail, North Dakota, US
1232 1232 53029 Island Washington US 2020-05-05 02:32:34 48.14713305 -122.5216407 169 8 0 160 Island, Washington, US
2039 2039 27113 Pennington Minnesota US 2020-05-05 02:32:34 48.06642577 -96.0370814 1 0 0 1 Pennington, Minnesota, US
475 475 53009 Clallam Washington US 2020-05-05 02:32:34 48.04754642 -123.92263190000001 18 0 0 18 Clallam, Washington, US
2402 2402 53061 Snohomish Washington US 2020-05-05 02:32:34 48.04615983 -121.7170703 2537 111 0 2426 Snohomish, Washington, US
3107 3107       Kazakhstan 2020-05-05 02:32:34 48.0196 66.9237 4049 29 1173 2847 Kazakhstan
159 159 27007 Beltrami Minnesota US 2020-05-05 02:32:34 47.97373527 -94.93732139 6 0 0 6 Beltrami, Minnesota, US
1872 1872 38063 Nelson North Dakota US 2020-05-05 02:32:34 47.9226426 -98.19038437 1 0 0 1 Nelson, North Dakota, US
981 981 38035 Grand Forks North Dakota US 2020-05-05 02:32:34 47.92093639 -97.45450447 269 0 0 269 Grand Forks, North Dakota, US
2197 2197 27125 Red Lake Minnesota US 2020-05-05 02:32:34 47.87197525 -96.09561104 1 0 0 1 Red Lake, Minnesota, US
429 429 53007 Chelan Washington US 2020-05-05 02:32:34 47.87046092 -120.6173956 120 5 0 115 Chelan, Washington, US
2963 2963     Heilongjiang China 2020-05-05 02:32:34 47.861999999999995 127.7615 944 13 719 212 Heilongjiang, China
2215 2215 30083 Richland Montana US 2020-05-05 02:32:34 47.78668011 -104.5610786 3 0 0 3 Richland, Montana, US
2113 2113 27119 Polk Minnesota US 2020-05-05 02:32:34 47.77372465 -96.40134647 42 0 0 42 Polk, Minnesota, US
1294 1294 53031 Jefferson Washington US 2020-05-05 02:32:34 47.75003077 -123.56097040000002 28 0 0 28 Jefferson, Washington, US
1697 1697 38053 McKenzie North Dakota US 2020-05-05 02:32:34 47.74133370000001 -103.395905 13 0 0 13 McKenzie, North Dakota, US
749 749 53017 Douglas Washington US 2020-05-05 02:32:34 47.7361335 -119.69293700000001 84 2 0 83 Douglas, Washington, US
776 776 38027 Eddy North Dakota US 2020-05-05 02:32:34 47.71701474 -98.90432337 1 0 0 1 Eddy, North Dakota, US
1392 1392 16055 Kootenai Idaho US 2020-05-05 02:32:34 47.67282258 -116.7020872 62 0 0 62 Kootenai, Idaho, US
1419 1419 30047 Lake Montana US 2020-05-05 02:32:34 47.64514965 -114.0898013 5 0 0 5 Lake, Montana, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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