04-14-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,015 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
2769 2769     Greenland Denmark 2020-04-14 23:33:12 71.7069 -42.6043 11 0 11 0 Greenland, Denmark
2802 2802     Nunavut Canada 2020-04-14 23:40:54 70.2998 -83.1076 0 0 0 0 Nunavut, Canada
2741 2741 2290 Yukon-Koyukuk Alaska US 2020-04-14 23:33:31 65.50815459 -151.39073869999999 1 0 0 1 Yukon-Koyukuk, Alaska, US
2909 2909       Iceland 2020-04-14 23:33:12 64.9631 -19.0208 1720 8 989 723 Iceland
2800 2800     Northwest Territories Canada 2020-04-14 23:40:54 64.8255 -124.8457 5 0 0 5 Northwest Territories, Canada
771 771 2090 Fairbanks North Star Alaska US 2020-04-14 23:33:31 64.80726247 -146.5692662 79 1 0 78 Fairbanks North Star, Alaska, US
2832 2832     Yukon Canada 2020-04-14 23:40:54 64.2823 -135.0 8 0 0 8 Yukon, Canada
2259 2259 2240 Southeast Fairbanks Alaska US 2020-04-14 23:33:31 63.87692095 -143.2127643 1 0 0 1 Southeast Fairbanks, Alaska, US
1572 1572 2170 Matanuska-Susitna Alaska US 2020-04-14 23:33:31 62.31305045 -149.5741743 15 0 0 15 Matanuska-Susitna, Alaska, US
2892 2892       Finland 2020-04-14 23:33:12 61.92411 25.748151 3161 64 300 2797 Finland
2761 2761     Faroe Islands Denmark 2020-04-14 23:33:12 61.8926 -6.9118 184 0 163 21 Faroe Islands, Denmark
2970 2970       Russia 2020-04-14 23:33:12 61.52401 105.31875600000001 21102 170 1694 19238 Russia
50 50 2020 Anchorage Alaska US 2020-04-14 23:33:31 61.14998174 -149.14269860000005 136 4 0 132 Anchorage, Alaska, US
174 174 2050 Bethel Alaska US 2020-04-14 23:33:31 60.90980451 -159.8561831 1 0 0 1 Bethel, Alaska, US
2958 2958       Norway 2020-04-14 23:33:12 60.472 8.4689 6623 139 32 6452 Norway
1263 1263 2122 Kenai Peninsula Alaska US 2020-04-14 23:33:31 60.24429722 -151.53888840000005 15 0 0 15 Kenai Peninsula, Alaska, US
2993 2993       Sweden 2020-04-14 23:33:12 60.128161 18.643501 11445 1033 381 10031 Sweden
2888 2888       Estonia 2020-04-14 23:33:12 58.5953 25.0136 1373 31 115 1227 Estonia
1245 1245 2110 Juneau Alaska US 2020-04-14 23:33:31 58.45031811 -134.200436 18 0 0 18 Juneau, Alaska, US
1928 1928 2195 Petersburg Alaska US 2020-04-14 23:33:31 57.13978948 -132.9540995 2 0 0 2 Petersburg, Alaska, US
2927 2927       Latvia 2020-04-14 23:33:12 56.8796 24.6032 657 5 16 636 Latvia
2878 2878       Denmark 2020-04-14 23:33:12 56.2639 9.5018 6511 299 2515 3697 Denmark
2018 2018 2198 Prince of Wales-Hyder Alaska US 2020-04-14 23:33:31 55.76261984 -133.0511621 2 0 0 2 Prince of Wales-Hyder, Alaska, US
1277 1277 2130 Ketchikan Gateway Alaska US 2020-04-14 23:33:31 55.57445008 -130.975561 15 0 0 15 Ketchikan Gateway, Alaska, US
3007 3007       United Kingdom 2020-04-14 23:33:12 55.3781 -3.4360000000000004 93873 12107 0 81766 United Kingdom
2932 2932       Lithuania 2020-04-14 23:33:12 55.1694 23.8813 977 16 7 940 Lithuania
2783 2783     Isle of Man United Kingdom 2020-04-14 23:33:12 54.2361 -4.5481 254 2 141 111 Isle of Man, United Kingdom
2745 2745     Alberta Canada 2020-04-14 23:40:54 53.9333 -116.5765 1870 48 0 1822 Alberta, Canada
2789 2789     Manitoba Canada 2020-04-14 23:40:54 53.7609 -98.8139 246 4 0 242 Manitoba, Canada
2753 2753     British Columbia Canada 2020-04-14 23:40:54 53.7267 -127.6476 1490 69 0 1421 British Columbia, Canada
2849 2849       Belarus 2020-04-14 23:33:12 53.7098 27.9534 3281 33 203 3045 Belarus
2914 2914       Ireland 2020-04-14 23:33:12 53.1424 -7.6921 11479 406 25 11048 Ireland
2796 2796     Newfoundland and Labrador Canada 2020-04-14 23:40:54 53.1355 -57.6604 244 3 0 241 Newfoundland and Labrador, Canada
2807 2807     Quebec Canada 2020-04-14 23:40:54 52.9399 -73.5491 14248 895 0 13813 Quebec, Canada
2815 2815     Saskatchewan Canada 2020-04-14 23:40:54 52.9399 -106.4509 300 4 0 296 Saskatchewan, Canada
2952 2952       Netherlands 2020-04-14 23:33:12 52.1326 5.2913 27419 2945 250 24224 Netherlands
2966 2966       Poland 2020-04-14 23:33:12 51.9194 19.1451 7202 263 618 6321 Poland
2803 2803     Ontario Canada 2020-04-14 23:40:54 51.2538 -85.3232 7953 334 0 7619 Ontario, Canada
2897 2897       Germany 2020-04-14 23:33:12 51.165690999999995 10.451526 131359 3294 68200 59865 Germany
2850 2850       Belgium 2020-04-14 23:33:12 50.8333 4.469936 31119 4157 6868 20094 Belgium
2877 2877       Czechia 2020-04-14 23:33:12 49.8175 15.472999999999999 6111 161 642 5308 Czechia
2933 2933       Luxembourg 2020-04-14 23:33:12 49.8153 6.1296 3307 67 500 2740 Luxembourg
2756 2756     Channel Islands United Kingdom 2020-04-14 23:33:12 49.3723 -2.3644 440 13 48 379 Channel Islands, United Kingdom
2648 2648 53073 Whatcom Washington US 2020-04-14 23:33:31 48.82227976 -121.74900179999999 264 24 0 241 Whatcom, Washington, US
684 684 38023 Divide North Dakota US 2020-04-14 23:33:31 48.814938700000006 -103.48736109999999 1 0 0 1 Divide, North Dakota, US
271 271 38013 Burke North Dakota US 2020-04-14 23:33:31 48.79094471 -102.51821170000001 2 0 0 2 Burke, North Dakota, US
2116 2116 27135 Roseau Minnesota US 2020-04-14 23:33:31 48.77501878 -95.81079919 1 0 0 1 Roseau, Minnesota, US
2111 2111 38079 Rolette North Dakota US 2020-04-14 23:33:31 48.77245354 -99.84097493 1 0 0 1 Rolette, North Dakota, US
211 211 16021 Boundary Idaho US 2020-04-14 23:33:31 48.76684761 -116.4630179 1 0 0 1 Boundary, Idaho, US
899 899 30035 Glacier Montana US 2020-04-14 23:33:31 48.70513576 -112.9934235 4 0 0 4 Glacier, Montana, US
2984 2984       Slovakia 2020-04-14 23:33:12 48.669 19.699 835 2 113 720 Slovakia
2411 2411 30101 Toole Montana US 2020-04-14 23:33:31 48.65577551 -111.69424140000001 26 3 0 23 Toole, Montana, US
1079 1079 30041 Hill Montana US 2020-04-14 23:33:31 48.62879827 -110.1129252 1 0 0 1 Hill, Montana, US
2153 2153 53055 San Juan Washington US 2020-04-14 23:33:31 48.60182783 -122.96745 13 0 0 13 San Juan, Washington, US
1409 1409 30051 Liberty Montana US 2020-04-14 23:33:31 48.56084317 -111.02430700000001 1 0 0 1 Liberty, Montana, US
1820 1820 53047 Okanogan Washington US 2020-04-14 23:33:31 48.54855019 -119.73872240000001 15 0 0 15 Okanogan, Washington, US
1424 1424 30053 Lincoln Montana US 2020-04-14 23:33:31 48.54265777 -115.4046155 7 1 0 6 Lincoln, Montana, US
1908 1908 53051 Pend Oreille Washington US 2020-04-14 23:33:31 48.53234021 -117.2741804 1 0 0 1 Pend Oreille, Washington, US
2241 2241 53057 Skagit Washington US 2020-04-14 23:33:31 48.48171488 -121.766131 195 7 0 189 Skagit, Washington, US
799 799 53019 Ferry Washington US 2020-04-14 23:33:31 48.471143100000006 -118.5154041 1 0 0 1 Ferry, Washington, US
2315 2315 53065 Stevens Washington US 2020-04-14 23:33:31 48.40035475 -117.8542701 7 1 0 6 Stevens, Washington, US
3005 3005       Ukraine 2020-04-14 23:33:12 48.3794 31.1656 3372 98 119 3155 Ukraine
2549 2549 38099 Walsh North Dakota US 2020-04-14 23:33:31 48.36876964 -97.72574783 3 0 0 3 Walsh, North Dakota, US
2672 2672 38105 Williams North Dakota US 2020-04-14 23:33:31 48.34522353 -103.4793387 8 0 0 8 Williams, North Dakota, US
199 199 16017 Bonner Idaho US 2020-04-14 23:33:31 48.29996017 -116.6017932 4 0 0 4 Bonner, Idaho, US
2113 2113 30085 Roosevelt Montana US 2020-04-14 23:33:31 48.29607488 -105.00792679999999 3 0 0 3 Roosevelt, Montana, US
803 803 30029 Flathead Montana US 2020-04-14 23:33:31 48.29575866 -114.05205690000001 36 1 0 35 Flathead, Montana, US
2047 2047 38071 Ramsey North Dakota US 2020-04-14 23:33:31 48.26886249 -98.72223879 3 0 0 3 Ramsey, North Dakota, US
1944 1944 38069 Pierce North Dakota US 2020-04-14 23:33:31 48.24977025 -99.96407787 2 0 0 2 Pierce, North Dakota, US
1303 1303 27071 Koochiching Minnesota US 2020-04-14 23:33:31 48.24539665 -93.78352843 1 0 0 1 Koochiching, Minnesota, US
1591 1591 38049 McHenry North Dakota US 2020-04-14 23:33:31 48.23104458 -100.6324822 1 1 0 0 McHenry, North Dakota, US
2556 2556 38101 Ward North Dakota US 2020-04-14 23:33:31 48.22390169 -101.54367629999999 20 1 0 19 Ward, North Dakota, US
1735 1735 38061 Mountrail North Dakota US 2020-04-14 23:33:31 48.20197971 -102.3555315 27 0 0 27 Mountrail, North Dakota, US
1150 1150 53029 Island Washington US 2020-04-14 23:33:31 48.14713305 -122.5216407 162 7 0 154 Island, Washington, US
447 447 53009 Clallam Washington US 2020-04-14 23:33:31 48.04754642 -123.92263190000001 12 0 0 12 Clallam, Washington, US
2249 2249 53061 Snohomish Washington US 2020-04-14 23:33:31 48.04615983 -121.7170703 1950 83 0 1873 Snohomish, Washington, US
2920 2920       Kazakhstan 2020-04-14 23:33:12 48.0196 66.9237 1232 14 203 1015 Kazakhstan
152 152 27007 Beltrami Minnesota US 2020-04-14 23:33:31 47.97373527 -94.93732139 5 0 0 5 Beltrami, Minnesota, US
924 924 38035 Grand Forks North Dakota US 2020-04-14 23:33:31 47.92093639 -97.45450447 12 0 0 12 Grand Forks, North Dakota, US
2062 2062 27125 Red Lake Minnesota US 2020-04-14 23:33:31 47.87197525 -96.09561104 1 0 0 1 Red Lake, Minnesota, US
407 407 53007 Chelan Washington US 2020-04-14 23:33:31 47.87046092 -120.6173956 61 5 0 56 Chelan, Washington, US
2777 2777     Heilongjiang China 2020-04-14 00:52:07 47.862 127.7615 819 13 470 336 Heilongjiang, China
2075 2075 30083 Richland Montana US 2020-04-14 23:33:31 47.78668011 -104.5610786 3 0 0 3 Richland, Montana, US
1981 1981 27119 Polk Minnesota US 2020-04-14 23:33:31 47.77372465 -96.40134647 1 0 0 1 Polk, Minnesota, US
1211 1211 53031 Jefferson Washington US 2020-04-14 23:33:31 47.75003077 -123.56097040000002 28 0 0 28 Jefferson, Washington, US
1596 1596 38053 McKenzie North Dakota US 2020-04-14 23:33:31 47.74133370000001 -103.395905 8 0 0 8 McKenzie, North Dakota, US
706 706 53017 Douglas Washington US 2020-04-14 23:33:31 47.7361335 -119.69293700000001 26 1 0 25 Douglas, Washington, US
734 734 38027 Eddy North Dakota US 2020-04-14 23:33:31 47.71701474 -98.90432337 1 0 0 1 Eddy, North Dakota, US
1304 1304 16055 Kootenai Idaho US 2020-04-14 23:33:31 47.67282258 -116.7020872 45 0 0 45 Kootenai, Idaho, US
1330 1330 30047 Lake Montana US 2020-04-14 23:33:31 47.64514965 -114.0898013 5 0 0 5 Lake, Montana, US
1289 1289 53035 Kitsap Washington US 2020-04-14 23:33:31 47.63479026 -122.6436061 132 1 0 131 Kitsap, Washington, US
2265 2265 53063 Spokane Washington US 2020-04-14 23:33:31 47.62113146 -117.4046494 276 17 0 261 Spokane, Washington, US
1600 1600 38055 McLean North Dakota US 2020-04-14 23:33:31 47.60766714 -101.3182418 2 0 0 2 McLean, North Dakota, US
2285 2285 27137 St. Louis Minnesota US 2020-04-14 23:33:31 47.604840700000004 -92.46879855 42 5 0 37 St. Louis, Minnesota, US
487 487 27029 Clearwater Minnesota US 2020-04-14 23:33:31 47.57992111 -95.37790562 3 0 0 3 Clearwater, Minnesota, US
1433 1433 53043 Lincoln Washington US 2020-04-14 23:33:31 47.57705241 -118.41943880000001 2 0 0 2 Lincoln, Washington, US
2843 2843       Austria 2020-04-14 23:33:12 47.5162 14.5501 14226 384 7633 6209 Austria
1152 1152 27061 Itasca Minnesota US 2020-04-14 23:33:31 47.51009045 -93.63092229 2 0 0 2 Itasca, Minnesota, US
1280 1280 53033 King Washington US 2020-04-14 23:33:31 47.49137892 -121.8346131 4549 331 0 4253 King, Washington, US
821 821 38031 Foster North Dakota US 2020-04-14 23:33:31 47.457108399999996 -98.88279923 1 0 0 1 Foster, North Dakota, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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