04-30-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,179 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
2931 2931     Greenland Denmark 2020-05-01 02:32:28 71.7069 -42.6043 11 0 11 0 Greenland, Denmark
2964 2964     Nunavut Canada 2020-05-01 02:32:28 70.2998 -83.1076 0 0 0 0 Nunavut, Canada
2901 2901 2290 Yukon-Koyukuk Alaska US 2020-05-01 02:32:28 65.50815459 -151.39073869999999 1 0 0 1 Yukon-Koyukuk, Alaska, US
3072 3072       Iceland 2020-05-01 02:32:28 64.9631 -19.0208 1797 10 1670 117 Iceland
1892 1892 2180 Nome Alaska US 2020-05-01 02:32:28 64.90320724 -164.0353804 1 0 0 1 Nome, Alaska, US
2962 2962     Northwest Territories Canada 2020-05-01 02:32:28 64.8255 -124.8457 5 0 0 5 Northwest Territories, Canada
807 807 2090 Fairbanks North Star Alaska US 2020-05-01 02:32:28 64.80726247 -146.5692662 81 1 0 80 Fairbanks North Star, Alaska, US
2994 2994     Yukon Canada 2020-05-01 02:32:28 64.2823 -135.0 11 0 0 11 Yukon, Canada
2390 2390 2240 Southeast Fairbanks Alaska US 2020-05-01 02:32:28 63.87692095 -143.2127643 1 0 0 1 Southeast Fairbanks, Alaska, US
1657 1657 2170 Matanuska-Susitna Alaska US 2020-05-01 02:32:28 62.31305045 -149.5741743 21 0 0 21 Matanuska-Susitna, Alaska, US
3055 3055       Finland 2020-05-01 02:32:28 61.92411 25.748151 4995 211 3000 1784 Finland
2923 2923     Faroe Islands Denmark 2020-05-01 02:32:28 61.8926 -6.9118 187 0 184 3 Faroe Islands, Denmark
3133 3133       Russia 2020-05-01 02:32:28 61.52401 105.31875600000001 106498 1073 11619 93806 Russia
53 53 2020 Anchorage Alaska US 2020-05-01 02:32:28 61.14998174 -149.14269860000005 179 4 0 175 Anchorage, Alaska, US
181 181 2050 Bethel Alaska US 2020-05-01 02:32:28 60.90980451 -159.8561831 1 0 0 1 Bethel, Alaska, US
3121 3121       Norway 2020-05-01 02:32:28 60.472 8.4689 7738 210 32 7496 Norway
1333 1333 2122 Kenai Peninsula Alaska US 2020-05-01 02:32:28 60.24429722 -151.53888840000005 19 0 0 19 Kenai Peninsula, Alaska, US
3156 3156       Sweden 2020-05-01 02:32:28 60.128161 18.643501 21092 2586 1005 17501 Sweden
3051 3051       Estonia 2020-05-01 02:32:28 58.5953 25.0136 1689 52 249 1388 Estonia
1316 1316 2110 Juneau Alaska US 2020-05-01 02:32:28 58.45031811 -134.200436 27 0 0 27 Juneau, Alaska, US
1375 1375 2150 Kodiak Island Alaska US 2020-05-01 02:32:28 57.65529415 -153.7493579 1 0 0 1 Kodiak Island, Alaska, US
2371 2371 2220 Sitka Alaska US 2020-05-01 02:32:28 57.24124555 -135.3206587 1 0 0 1 Sitka, Alaska, US
2039 2039 2195 Petersburg Alaska US 2020-05-01 02:32:28 57.13978948 -132.9540995 4 0 0 4 Petersburg, Alaska, US
3090 3090       Latvia 2020-05-01 02:32:28 56.8796 24.6032 858 15 348 495 Latvia
3041 3041       Denmark 2020-05-01 02:32:28 56.2639 9.5018 9158 452 6546 2160 Denmark
2133 2133 2198 Prince of Wales-Hyder Alaska US 2020-05-01 02:32:28 55.76261984 -133.0511621 2 0 0 2 Prince of Wales-Hyder, Alaska, US
1347 1347 2130 Ketchikan Gateway Alaska US 2020-05-01 02:32:28 55.57445008 -130.975561 16 0 0 16 Ketchikan Gateway, Alaska, US
3171 3171       United Kingdom 2020-05-01 02:32:28 55.3781 -3.4360000000000004 171253 26771 0 144482 United Kingdom
3095 3095       Lithuania 2020-05-01 02:32:28 55.1694 23.8813 1375 32 577 751 Lithuania
2945 2945     Isle of Man United Kingdom 2020-05-01 02:32:28 54.2361 -4.5481 315 21 260 34 Isle of Man, United Kingdom
2906 2906     Alberta Canada 2020-05-01 02:32:28 53.9333 -116.5765 5355 90 0 5265 Alberta, Canada
2951 2951     Manitoba Canada 2020-05-01 02:32:28 53.7609 -98.8139 277 6 0 271 Manitoba, Canada
2914 2914     British Columbia Canada 2020-05-01 02:32:28 53.7267 -127.6476 2112 111 0 2001 British Columbia, Canada
3011 3011       Belarus 2020-05-01 02:32:28 53.7098 27.9534 14027 89 2386 11552 Belarus
3077 3077       Ireland 2020-05-01 02:32:28 53.1424 -7.6921 20612 1232 13386 5994 Ireland
2958 2958     Newfoundland and Labrador Canada 2020-05-01 02:32:28 53.1355 -57.6604 258 3 0 255 Newfoundland and Labrador, Canada
2969 2969     Quebec Canada 2020-05-01 02:32:28 52.9399 -73.5491 27550 2728 0 25691 Quebec, Canada
2977 2977     Saskatchewan Canada 2020-05-01 02:32:28 52.9399 -106.4509 389 7 0 382 Saskatchewan, Canada
3115 3115       Netherlands 2020-05-01 02:32:28 52.1326 5.2913 39316 4795 0 34521 Netherlands
3129 3129       Poland 2020-05-01 02:32:28 51.9194 19.1451 12877 644 3236 8997 Poland
2965 2965     Ontario Canada 2020-05-01 02:32:28 51.2538 -85.3232 17395 1205 0 16190 Ontario, Canada
3060 3060       Germany 2020-05-01 02:32:28 51.165690999999995 10.451526 163009 6623 123500 32886 Germany
3012 3012       Belgium 2020-05-01 02:32:28 50.8333 4.469936 48519 7594 11576 29349 Belgium
3040 3040       Czechia 2020-05-01 02:32:28 49.8175 15.472999999999999 7682 236 3314 4132 Czechia
3096 3096       Luxembourg 2020-05-01 02:32:28 49.8153 6.1296 3784 90 3213 481 Luxembourg
2917 2917     Channel Islands United Kingdom 2020-05-01 02:32:28 49.3723 -2.3644 537 40 386 111 Channel Islands, United Kingdom
2802 2802 53073 Whatcom Washington US 2020-05-01 02:32:28 48.82227976 -121.74900179999999 302 27 0 274 Whatcom, Washington, US
716 716 38023 Divide North Dakota US 2020-05-01 02:32:28 48.814938700000006 -103.48736109999999 1 0 0 1 Divide, North Dakota, US
280 280 38013 Burke North Dakota US 2020-05-01 02:32:28 48.79094471 -102.51821170000001 3 0 0 3 Burke, North Dakota, US
1362 1362 27069 Kittson Minnesota US 2020-05-01 02:32:28 48.77754106 -96.78317184 1 0 0 1 Kittson, Minnesota, US
2237 2237 27135 Roseau Minnesota US 2020-05-01 02:32:28 48.77501878 -95.81079919 1 0 0 1 Roseau, Minnesota, US
2232 2232 38079 Rolette North Dakota US 2020-05-01 02:32:28 48.77245354 -99.84097493 1 0 0 1 Rolette, North Dakota, US
219 219 16021 Boundary Idaho US 2020-05-01 02:32:28 48.76684761 -116.4630179 0 0 0 0 Boundary, Idaho, US
2015 2015 38067 Pembina North Dakota US 2020-05-01 02:32:28 48.76623521 -97.5523809 3 0 0 3 Pembina, North Dakota, US
945 945 30035 Glacier Montana US 2020-05-01 02:32:28 48.70513576 -112.9934235 6 0 0 6 Glacier, Montana, US
3147 3147       Slovakia 2020-05-01 02:32:28 48.669 19.699 1396 23 524 849 Slovakia
2549 2549 30101 Toole Montana US 2020-05-01 02:32:28 48.65577551 -111.69424140000001 29 6 0 23 Toole, Montana, US
1143 1143 30041 Hill Montana US 2020-05-01 02:32:28 48.62879827 -110.1129252 1 0 0 1 Hill, Montana, US
2278 2278 53055 San Juan Washington US 2020-05-01 02:32:28 48.60182783 -122.96745 14 0 0 14 San Juan, Washington, US
1486 1486 30051 Liberty Montana US 2020-05-01 02:32:28 48.56084317 -111.02430700000001 1 0 0 1 Liberty, Montana, US
1924 1924 53047 Okanogan Washington US 2020-05-01 02:32:28 48.54855019 -119.73872240000001 22 1 0 21 Okanogan, Washington, US
1501 1501 30053 Lincoln Montana US 2020-05-01 02:32:28 48.54265777 -115.4046155 7 1 0 6 Lincoln, Montana, US
2017 2017 53051 Pend Oreille Washington US 2020-05-01 02:32:28 48.53234021 -117.2741804 2 0 0 2 Pend Oreille, Washington, US
2372 2372 53057 Skagit Washington US 2020-05-01 02:32:28 48.48171488 -121.766131 329 12 0 316 Skagit, Washington, US
836 836 53019 Ferry Washington US 2020-05-01 02:32:28 48.471143100000006 -118.5154041 1 0 0 1 Ferry, Washington, US
2450 2450 53065 Stevens Washington US 2020-05-01 02:32:28 48.40035475 -117.8542701 9 1 0 8 Stevens, Washington, US
3169 3169       Ukraine 2020-05-01 02:32:28 48.3794 31.1656 10406 261 1238 8907 Ukraine
2699 2699 38099 Walsh North Dakota US 2020-05-01 02:32:28 48.36876964 -97.72574783 7 0 0 7 Walsh, North Dakota, US
1636 1636 27089 Marshall Minnesota US 2020-05-01 02:32:28 48.35825983 -96.37017407 1 0 0 1 Marshall, Minnesota, US
2829 2829 38105 Williams North Dakota US 2020-05-01 02:32:28 48.34522353 -103.4793387 10 0 0 10 Williams, North Dakota, US
206 206 16017 Bonner Idaho US 2020-05-01 02:32:28 48.29996017 -116.6017932 4 0 0 4 Bonner, Idaho, US
2234 2234 30085 Roosevelt Montana US 2020-05-01 02:32:28 48.29607488 -105.00792679999999 7 0 0 7 Roosevelt, Montana, US
841 841 30029 Flathead Montana US 2020-05-01 02:32:28 48.29575866 -114.05205690000001 37 2 0 35 Flathead, Montana, US
2163 2163 38071 Ramsey North Dakota US 2020-05-01 02:32:28 48.26886249 -98.72223879 3 0 0 3 Ramsey, North Dakota, US
2055 2055 38069 Pierce North Dakota US 2020-05-01 02:32:28 48.24977025 -99.96407787 2 0 0 2 Pierce, North Dakota, US
1376 1376 27071 Koochiching Minnesota US 2020-05-01 02:32:28 48.24539665 -93.78352843 1 0 0 1 Koochiching, Minnesota, US
1676 1676 38049 McHenry North Dakota US 2020-05-01 02:32:28 48.23104458 -100.6324822 1 1 0 0 McHenry, North Dakota, US
2103 2103 30073 Pondera Montana US 2020-05-01 02:32:28 48.22773388 -112.22527029999999 2 0 0 2 Pondera, Montana, US
2706 2706 38101 Ward North Dakota US 2020-05-01 02:32:28 48.22390169 -101.54367629999999 21 1 0 20 Ward, North Dakota, US
1831 1831 38061 Mountrail North Dakota US 2020-05-01 02:32:28 48.20197971 -102.3555315 35 0 0 35 Mountrail, North Dakota, US
1219 1219 53029 Island Washington US 2020-05-01 02:32:28 48.14713305 -122.5216407 168 8 0 159 Island, Washington, US
2021 2021 27113 Pennington Minnesota US 2020-05-01 02:32:28 48.06642577 -96.0370814 1 0 0 1 Pennington, Minnesota, US
469 469 53009 Clallam Washington US 2020-05-01 02:32:28 48.04754642 -123.92263190000001 18 0 0 18 Clallam, Washington, US
2380 2380 53061 Snohomish Washington US 2020-05-01 02:32:28 48.04615983 -121.7170703 2433 109 0 2325 Snohomish, Washington, US
3083 3083       Kazakhstan 2020-05-01 02:32:28 48.0196 66.9237 3402 25 866 2511 Kazakhstan
159 159 27007 Beltrami Minnesota US 2020-05-01 02:32:28 47.97373527 -94.93732139 6 0 0 6 Beltrami, Minnesota, US
1855 1855 38063 Nelson North Dakota US 2020-05-01 02:32:28 47.9226426 -98.19038437 1 0 0 1 Nelson, North Dakota, US
971 971 38035 Grand Forks North Dakota US 2020-05-01 02:32:28 47.92093639 -97.45450447 258 0 0 258 Grand Forks, North Dakota, US
2179 2179 27125 Red Lake Minnesota US 2020-05-01 02:32:28 47.87197525 -96.09561104 1 0 0 1 Red Lake, Minnesota, US
423 423 53007 Chelan Washington US 2020-05-01 02:32:28 47.87046092 -120.6173956 108 5 0 103 Chelan, Washington, US
2939 2939     Heilongjiang China 2020-05-01 02:32:28 47.861999999999995 127.7615 944 13 587 344 Heilongjiang, China
2195 2195 30083 Richland Montana US 2020-05-01 02:32:28 47.78668011 -104.5610786 3 0 0 3 Richland, Montana, US
2095 2095 27119 Polk Minnesota US 2020-05-01 02:32:28 47.77372465 -96.40134647 27 0 0 27 Polk, Minnesota, US
1281 1281 53031 Jefferson Washington US 2020-05-01 02:32:28 47.75003077 -123.56097040000002 28 0 0 28 Jefferson, Washington, US
1681 1681 38053 McKenzie North Dakota US 2020-05-01 02:32:28 47.74133370000001 -103.395905 13 0 0 13 McKenzie, North Dakota, US
740 740 53017 Douglas Washington US 2020-05-01 02:32:28 47.7361335 -119.69293700000001 78 2 0 77 Douglas, Washington, US
767 767 38027 Eddy North Dakota US 2020-05-01 02:32:28 47.71701474 -98.90432337 1 0 0 1 Eddy, North Dakota, US
1377 1377 16055 Kootenai Idaho US 2020-05-01 02:32:28 47.67282258 -116.7020872 61 0 0 61 Kootenai, Idaho, US
1404 1404 30047 Lake Montana US 2020-05-01 02:32:28 47.64514965 -114.0898013 5 0 0 5 Lake, Montana, US
1360 1360 53035 Kitsap Washington US 2020-05-01 02:32:28 47.63479026 -122.6436061 149 2 0 147 Kitsap, Washington, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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