04-19-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,074 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
2828 2828     Greenland Denmark 2020-04-19 23:40:41 71.7069 -42.6043 11 0 11 0 Greenland, Denmark
2861 2861     Nunavut Canada 2020-04-19 23:48:49 70.2998 -83.1076 0 0 0 0 Nunavut, Canada
2799 2799 2290 Yukon-Koyukuk Alaska US 2020-04-19 23:41:01 65.50815459 -151.3907387 1 0 0 1 Yukon-Koyukuk, Alaska, US
2968 2968       Iceland 2020-04-19 23:40:41 64.9631 -19.0208 1771 9 1291 471 Iceland
1826 1826 2180 Nome Alaska US 2020-04-19 23:41:01 64.90320724 -164.0353804 1 0 0 1 Nome, Alaska, US
2859 2859     Northwest Territories Canada 2020-04-19 23:48:49 64.8255 -124.8457 5 0 0 5 Northwest Territories, Canada
783 783 2090 Fairbanks North Star Alaska US 2020-04-19 23:41:01 64.80726247 -146.5692662 79 1 0 78 Fairbanks North Star, Alaska, US
2891 2891     Yukon Canada 2020-04-19 23:48:49 64.2823 -135.0 9 0 0 9 Yukon, Canada
2307 2307 2240 Southeast Fairbanks Alaska US 2020-04-19 23:41:01 63.87692095 -143.2127643 1 0 0 1 Southeast Fairbanks, Alaska, US
1602 1602 2170 Matanuska-Susitna Alaska US 2020-04-19 23:41:01 62.31305045 -149.5741743 18 0 0 18 Matanuska-Susitna, Alaska, US
2951 2951       Finland 2020-04-19 23:40:41 61.92411 25.748151 3783 94 1700 1989 Finland
2820 2820     Faroe Islands Denmark 2020-04-19 23:40:41 61.8926 -6.9118 185 0 176 9 Faroe Islands, Denmark
3029 3029       Russia 2020-04-19 23:40:41 61.52401 105.318756 42853 361 3291 39201 Russia
53 53 2020 Anchorage Alaska US 2020-04-19 23:41:01 61.14998174 -149.1426986 154 4 0 150 Anchorage, Alaska, US
179 179 2050 Bethel Alaska US 2020-04-19 23:41:01 60.90980451 -159.8561831 1 0 0 1 Bethel, Alaska, US
3017 3017       Norway 2020-04-19 23:40:41 60.472 8.4689 7078 165 32 6881 Norway
1286 1286 2122 Kenai Peninsula Alaska US 2020-04-19 23:41:01 60.24429722 -151.5388884 19 0 0 19 Kenai Peninsula, Alaska, US
3052 3052       Sweden 2020-04-19 23:40:41 60.128161 18.643501 14385 1540 550 12295 Sweden
2947 2947       Estonia 2020-04-19 23:40:41 58.5953 25.0136 1528 40 164 1324 Estonia
1269 1269 2110 Juneau Alaska US 2020-04-19 23:41:01 58.45031811 -134.200436 24 0 0 24 Juneau, Alaska, US
1327 1327 2150 Kodiak Island Alaska US 2020-04-19 23:41:01 57.65529415 -153.7493579 1 0 0 1 Kodiak Island, Alaska, US
1967 1967 2195 Petersburg Alaska US 2020-04-19 23:41:01 57.13978948 -132.9540995 3 0 0 3 Petersburg, Alaska, US
2986 2986       Latvia 2020-04-19 23:40:41 56.8796 24.6032 727 5 88 634 Latvia
2937 2937       Denmark 2020-04-19 23:40:41 56.2639 9.5018 7384 355 4141 2888 Denmark
2059 2059 2198 Prince of Wales-Hyder Alaska US 2020-04-19 23:41:01 55.76261984 -133.0511621 2 0 0 2 Prince of Wales-Hyder, Alaska, US
1300 1300 2130 Ketchikan Gateway Alaska US 2020-04-19 23:41:01 55.57445008 -130.975561 15 0 0 15 Ketchikan Gateway, Alaska, US
3066 3066       United Kingdom 2020-04-19 23:40:41 55.3781 -3.436 120067 16060 0 104007 United Kingdom
2991 2991       Lithuania 2020-04-19 23:40:41 55.1694 23.8813 1153 23 98 1021 Lithuania
2842 2842     Isle of Man United Kingdom 2020-04-19 23:40:41 54.2361 -4.5481 298 6 193 99 Isle of Man, United Kingdom
2804 2804     Alberta Canada 2020-04-19 23:48:49 53.9333 -116.5765 2803 51 0 2752 Alberta, Canada
2848 2848     Manitoba Canada 2020-04-19 23:48:49 53.7609 -98.8139 254 5 0 249 Manitoba, Canada
2812 2812     British Columbia Canada 2020-04-19 23:48:49 53.7267 -127.6476 1647 81 0 1566 British Columbia, Canada
2908 2908       Belarus 2020-04-19 23:40:41 53.7098 27.9534 4779 47 494 4238 Belarus
2973 2973       Ireland 2020-04-19 23:40:41 53.1424 -7.6921 15251 610 77 14564 Ireland
2855 2855     Newfoundland and Labrador Canada 2020-04-19 23:48:49 53.1355 -57.6604 257 3 0 254 Newfoundland and Labrador, Canada
2866 2866     Quebec Canada 2020-04-19 23:48:49 52.9399 -73.5491 17950 1400 0 17130 Quebec, Canada
2874 2874     Saskatchewan Canada 2020-04-19 23:48:49 52.9399 -106.4509 315 4 0 311 Saskatchewan, Canada
3011 3011       Netherlands 2020-04-19 23:40:41 52.1326 5.2913 32655 3684 250 28721 Netherlands
3025 3025       Poland 2020-04-19 23:40:41 51.9194 19.1451 9287 360 1040 7887 Poland
2862 2862     Ontario Canada 2020-04-19 23:48:49 51.2538 -85.3232 11561 591 0 10970 Ontario, Canada
2956 2956       Germany 2020-04-19 23:40:41 51.165691 10.451526 145184 4586 88000 52598 Germany
2909 2909       Belgium 2020-04-19 23:40:41 50.8333 4.469936 38496 5683 8757 24056 Belgium
2936 2936       Czechia 2020-04-19 23:40:41 49.8175 15.473 6746 186 1298 5262 Czechia
2992 2992       Luxembourg 2020-04-19 23:40:41 49.8153 6.1296 3550 73 627 2850 Luxembourg
2815 2815     Channel Islands United Kingdom 2020-04-19 23:40:41 49.3723 -2.3644 488 21 73 394 Channel Islands, United Kingdom
2703 2703 53073 Whatcom Washington US 2020-04-19 23:41:01 48.82227976 -121.7490018 277 26 0 251 Whatcom, Washington, US
698 698 38023 Divide North Dakota US 2020-04-19 23:41:01 48.8149387 -103.4873611 1 0 0 1 Divide, North Dakota, US
276 276 38013 Burke North Dakota US 2020-04-19 23:41:01 48.79094471 -102.5182117 2 0 0 2 Burke, North Dakota, US
1314 1314 27069 Kittson Minnesota US 2020-04-19 23:41:01 48.77754106 -96.78317184 1 0 0 1 Kittson, Minnesota, US
2160 2160 27135 Roseau Minnesota US 2020-04-19 23:41:01 48.77501878 -95.81079919 1 0 0 1 Roseau, Minnesota, US
2155 2155 38079 Rolette North Dakota US 2020-04-19 23:41:01 48.77245354 -99.84097493 1 0 0 1 Rolette, North Dakota, US
217 217 16021 Boundary Idaho US 2020-04-19 23:41:01 48.76684761 -116.4630179 0 0 0 0 Boundary, Idaho, US
914 914 30035 Glacier Montana US 2020-04-19 23:41:01 48.70513576 -112.9934235 4 0 0 4 Glacier, Montana, US
3043 3043       Slovakia 2020-04-19 23:40:41 48.669 19.699 1161 12 229 920 Slovakia
2462 2462 30101 Toole Montana US 2020-04-19 23:41:01 48.65577551 -111.6942414 29 4 0 25 Toole, Montana, US
1101 1101 30041 Hill Montana US 2020-04-19 23:41:01 48.62879827 -110.1129252 1 0 0 1 Hill, Montana, US
2199 2199 53055 San Juan Washington US 2020-04-19 23:41:01 48.60182783 -122.96745 15 0 0 15 San Juan, Washington, US
1435 1435 30051 Liberty Montana US 2020-04-19 23:41:01 48.56084317 -111.024307 1 0 0 1 Liberty, Montana, US
1857 1857 53047 Okanogan Washington US 2020-04-19 23:41:01 48.54855019 -119.7387224 15 1 0 15 Okanogan, Washington, US
1450 1450 30053 Lincoln Montana US 2020-04-19 23:41:01 48.54265777 -115.4046155 7 1 0 6 Lincoln, Montana, US
1947 1947 53051 Pend Oreille Washington US 2020-04-19 23:41:01 48.53234021 -117.2741804 2 0 0 2 Pend Oreille, Washington, US
2289 2289 53057 Skagit Washington US 2020-04-19 23:41:01 48.48171488 -121.766131 240 9 0 233 Skagit, Washington, US
811 811 53019 Ferry Washington US 2020-04-19 23:41:01 48.4711431 -118.5154041 1 0 0 1 Ferry, Washington, US
2365 2365 53065 Stevens Washington US 2020-04-19 23:41:01 48.40035475 -117.8542701 8 1 0 7 Stevens, Washington, US
3064 3064       Ukraine 2020-04-19 23:40:41 48.3794 31.1656 5449 141 347 4961 Ukraine
2603 2603 38099 Walsh North Dakota US 2020-04-19 23:41:01 48.36876964 -97.72574783 3 0 0 3 Walsh, North Dakota, US
1581 1581 27089 Marshall Minnesota US 2020-04-19 23:41:01 48.35825983 -96.37017407 1 0 0 1 Marshall, Minnesota, US
2727 2727 38105 Williams North Dakota US 2020-04-19 23:41:01 48.34522353 -103.4793387 9 0 0 9 Williams, North Dakota, US
204 204 16017 Bonner Idaho US 2020-04-19 23:41:01 48.29996017 -116.6017932 4 0 0 4 Bonner, Idaho, US
2157 2157 30085 Roosevelt Montana US 2020-04-19 23:41:01 48.29607488 -105.0079268 6 0 0 6 Roosevelt, Montana, US
815 815 30029 Flathead Montana US 2020-04-19 23:41:01 48.29575866 -114.0520569 37 1 0 36 Flathead, Montana, US
2088 2088 38071 Ramsey North Dakota US 2020-04-19 23:41:01 48.26886249 -98.72223879 3 0 0 3 Ramsey, North Dakota, US
1983 1983 38069 Pierce North Dakota US 2020-04-19 23:41:01 48.24977025 -99.96407787 2 0 0 2 Pierce, North Dakota, US
1328 1328 27071 Koochiching Minnesota US 2020-04-19 23:41:01 48.24539665 -93.78352843 1 0 0 1 Koochiching, Minnesota, US
1619 1619 38049 McHenry North Dakota US 2020-04-19 23:41:01 48.23104458 -100.6324822 1 1 0 0 McHenry, North Dakota, US
2029 2029 30073 Pondera Montana US 2020-04-19 23:41:01 48.22773388 -112.2252703 2 0 0 2 Pondera, Montana, US
2610 2610 38101 Ward North Dakota US 2020-04-19 23:41:01 48.22390169 -101.5436763 20 1 0 19 Ward, North Dakota, US
1767 1767 38061 Mountrail North Dakota US 2020-04-19 23:41:01 48.20197971 -102.3555315 30 0 0 30 Mountrail, North Dakota, US
1174 1174 53029 Island Washington US 2020-04-19 23:41:01 48.14713305 -122.5216407 166 8 0 158 Island, Washington, US
457 457 53009 Clallam Washington US 2020-04-19 23:41:01 48.04754642 -123.9226319 15 0 0 15 Clallam, Washington, US
2297 2297 53061 Snohomish Washington US 2020-04-19 23:41:01 48.04615983 -121.7170703 2143 99 0 2050 Snohomish, Washington, US
2979 2979       Kazakhstan 2020-04-19 23:40:41 48.0196 66.9237 1676 17 400 1259 Kazakhstan
157 157 27007 Beltrami Minnesota US 2020-04-19 23:41:01 47.97373527 -94.93732139 5 0 0 5 Beltrami, Minnesota, US
1791 1791 38063 Nelson North Dakota US 2020-04-19 23:41:01 47.9226426 -98.19038437 1 0 0 1 Nelson, North Dakota, US
938 938 38035 Grand Forks North Dakota US 2020-04-19 23:41:01 47.92093639 -97.45450447 133 0 0 133 Grand Forks, North Dakota, US
2103 2103 27125 Red Lake Minnesota US 2020-04-19 23:41:01 47.87197525 -96.09561104 1 0 0 1 Red Lake, Minnesota, US
415 415 53007 Chelan Washington US 2020-04-19 23:41:01 47.87046092 -120.6173956 73 5 0 67 Chelan, Washington, US
2836 2836     Heilongjiang China 2020-04-19 00:33:50 47.862 127.7615 898 13 472 413 Heilongjiang, China
2118 2118 30083 Richland Montana US 2020-04-19 23:41:01 47.78668011 -104.5610786 3 0 0 3 Richland, Montana, US
2021 2021 27119 Polk Minnesota US 2020-04-19 23:41:01 47.77372465 -96.40134647 3 0 0 3 Polk, Minnesota, US
1235 1235 53031 Jefferson Washington US 2020-04-19 23:41:01 47.75003077 -123.5609704 29 0 0 29 Jefferson, Washington, US
1623 1623 38053 McKenzie North Dakota US 2020-04-19 23:41:01 47.7413337 -103.395905 10 0 0 10 McKenzie, North Dakota, US
720 720 53017 Douglas Washington US 2020-04-19 23:41:01 47.7361335 -119.692937 34 1 0 33 Douglas, Washington, US
747 747 38027 Eddy North Dakota US 2020-04-19 23:41:01 47.71701474 -98.90432337 1 0 0 1 Eddy, North Dakota, US
1329 1329 16055 Kootenai Idaho US 2020-04-19 23:41:01 47.67282258 -116.7020872 50 0 0 50 Kootenai, Idaho, US
1356 1356 30047 Lake Montana US 2020-04-19 23:41:01 47.64514965 -114.0898013 5 0 0 5 Lake, Montana, US
1312 1312 53035 Kitsap Washington US 2020-04-19 23:41:01 47.63479026 -122.6436061 138 1 0 137 Kitsap, Washington, US
2315 2315 53063 Spokane Washington US 2020-04-19 23:41:01 47.62113146 -117.4046494 307 17 0 290 Spokane, Washington, US
1627 1627 38055 McLean North Dakota US 2020-04-19 23:41:01 47.60766714 -101.3182418 3 0 0 3 McLean, North Dakota, US
2335 2335 27137 St. Louis Minnesota US 2020-04-19 23:41:01 47.6048407 -92.46879855 48 9 0 39 St. Louis, Minnesota, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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