03-29-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,437 rows sorted by Lat descending

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link rowid FIPS Admin2 Province_State Country_Region Last_Update Lat ▲ Long_ Confirmed Deaths Recovered Active Combined_Key
3199 3199     Greenland Denmark 3/29/20 23:08 71.7069 -42.6043 10 0 2 8 Greenland, Denmark
3232 3232     Nunavut Canada 3/29/20 23:13 70.2998 -83.1076 0 0 0 0 Nunavut, Canada
2094 2094 2185 North Slope Alaska US 3/29/20 23:08 69.31479216 -153.4836093 0 0 0 0 North Slope, Alaska, US
2100 2100 2188 Northwest Arctic Alaska US 3/29/20 23:08 67.04919196 -159.7503946 0 0 0 0 Northwest Arctic, Alaska, US
3169 3169 2290 Yukon-Koyukuk Alaska US 3/29/20 23:08 65.50815459 -151.3907387 0 0 0 0 Yukon-Koyukuk, Alaska, US
3336 3336       Iceland 3/29/20 23:08 64.9631 -19.0208 1020 2 135 883 Iceland
2090 2090 2180 Nome Alaska US 3/29/20 23:08 64.90320724 -164.0353804 0 0 0 0 Nome, Alaska, US
3230 3230     Northwest Territories Canada 3/29/20 23:13 64.8255 -124.8457 1 0 0 0 ,Northwest Territories,Canada
898 898 2090 Fairbanks North Star Alaska US 3/29/20 23:08 64.80726247 -146.5692662 23 0 0 0 Fairbanks North Star,Alaska,US
3261 3261     Yukon Canada 3/29/20 23:13 64.2823 -135.0 4 0 0 0 ,Yukon,Canada
2645 2645 2240 Southeast Fairbanks Alaska US 3/29/20 23:08 63.87692095 -143.2127643 0 0 0 0 Southeast Fairbanks, Alaska, US
767 767 2068 Denali Alaska US 3/29/20 23:08 63.67264044 -150.0076108 0 0 0 0 Denali, Alaska, US
1840 1840 2170 Matanuska-Susitna Alaska US 3/29/20 23:08 62.31305045 -149.5741743 2 0 0 0 Matanuska-Susitna,Alaska,US
1541 1541 2158 Kusilvak Alaska US 3/29/20 23:08 62.1542916 -163.3967883 0 0 0 0 Kusilvak, Alaska, US
3319 3319       Finland 3/29/20 23:08 61.92411 25.748151 1240 11 10 1219 Finland
3191 3191     Faroe Islands Denmark 3/29/20 23:08 61.8926 -6.9118 159 0 70 89 Faroe Islands, Denmark
3396 3396       Russia 3/29/20 23:08 61.52401 105.318756 1534 8 64 1462 Russia
2908 2908 2261 Valdez-Cordova Alaska US 3/29/20 23:08 61.47502768 -144.7126799 0 0 0 0 Valdez-Cordova, Alaska, US
59 59 2020 Anchorage Alaska US 3/29/20 23:08 61.14998174 -149.1426986 54 1 0 0 Anchorage,Alaska,US
200 200 2050 Bethel Alaska US 3/29/20 23:08 60.90980451 -159.8561831 0 0 0 0 Bethel, Alaska, US
3384 3384       Norway 3/29/20 23:08 60.472 8.4689 4284 25 7 4252 Norway
1482 1482 2122 Kenai Peninsula Alaska US 3/29/20 23:08 60.24429722 -151.5388884 7 0 0 0 Kenai Peninsula,Alaska,US
3416 3416       Sweden 3/29/20 23:08 60.128161 18.643501 3700 110 16 3574 Sweden
3149 3149 2282 Yakutat Alaska US 3/29/20 23:08 59.8909808 -140.3601451 0 0 0 0 Yakutat, Alaska, US
785 785 2070 Dillingham Alaska US 3/29/20 23:08 59.79603738 -158.2381942 0 0 0 0 Dillingham, Alaska, US
2626 2626 2230 Skagway Alaska US 3/29/20 23:08 59.56149996 -135.3337748 0 0 0 0 Skagway, Alaska, US
1151 1151 2100 Haines Alaska US 3/29/20 23:08 59.09893571 -135.4679843 0 0 0 0 Haines, Alaska, US
275 275 2060 Bristol Bay Alaska US 3/29/20 23:08 58.74513976 -156.701064 0 0 0 0 Bristol Bay, Alaska, US
1574 1574 2164 Lake and Peninsula Alaska US 3/29/20 23:08 58.62403337 -156.2140589 0 0 0 0 Lake and Peninsula, Alaska, US
3315 3315       Estonia 3/29/20 23:08 58.5953 25.0136 679 3 20 656 Estonia
1461 1461 2110 Juneau Alaska US 3/29/20 23:08 58.45031811 -134.200436 4 0 0 0 Juneau, Alaska, US
1291 1291 2105 Hoonah-Angoon Alaska US 3/29/20 23:08 58.29307365 -135.6424424 0 0 0 0 Hoonah-Angoon, Alaska, US
1536 1536 2150 Kodiak Island Alaska US 3/29/20 23:08 57.65529415 -153.7493579 0 0 0 0 Kodiak Island, Alaska, US
2624 2624 2220 Sitka Alaska US 3/29/20 23:08 57.24124555 -135.3206587 0 0 0 0 Sitka, Alaska, US
2245 2245 2195 Petersburg Alaska US 3/29/20 23:08 57.13978948 -132.9540995 0 0 0 0 Petersburg, Alaska, US
3354 3354       Latvia 3/29/20 23:08 56.8796 24.6032 347 0 1 346 Latvia
3137 3137 2275 Wrangell Alaska US 3/29/20 23:08 56.3202004 -132.0583731 0 0 0 0 Wrangell, Alaska, US
3305 3305       Denmark 3/29/20 23:08 56.2639 9.5018 2395 72 1 2322 Denmark
2350 2350 2198 Prince of Wales-Hyder Alaska US 3/29/20 23:08 55.76261984 -133.0511621 0 0 0 0 Prince of Wales-Hyder, Alaska, US
1498 1498 2130 Ketchikan Gateway Alaska US 3/29/20 23:08 55.57445008 -130.975561 12 0 0 0 Ketchikan Gateway, Alaska, US
3430 3430       United Kingdom 3/29/20 23:08 55.3781 -3.436 19522 1228 135 18159 United Kingdom
33 33 2013 Aleutians East Alaska US 3/29/20 23:08 55.32222414 -161.9722021 0 0 0 0 Aleutians East, Alaska, US
3359 3359       Lithuania 3/29/20 23:08 55.1694 23.8813 378 4 0 452 Lithuania
3213 3213     Isle of Man United Kingdom 3/29/20 23:08 54.2361 -4.5481 42 0 0 42 Isle of Man, United Kingdom
3175 3175     Alberta Canada 3/29/20 23:13 53.9333 -116.5765 621 2 0 0 Alberta, Canada
3219 3219     Manitoba Canada 3/29/20 23:13 53.7609 -98.8139 72 1 0 0 Manitoba, Canada
3183 3183     British Columbia Canada 3/29/20 23:13 53.7267 -127.6476 884 17 0 0 British Columbia, Canada
3278 3278       Belarus 3/29/20 23:08 53.7098 27.9534 94 0 32 62 Belarus
3341 3341       Ireland 3/29/20 23:08 53.1424 -7.6921 2615 46 5 2564 Ireland
3226 3226     Newfoundland and Labrador Canada 3/29/20 23:13 53.1355 -57.6604 135 0 0 0 Newfoundland and Labrador, Canada
3237 3237     Quebec Canada 3/29/20 23:13 52.9399 -73.5491 2840 54 0 0 Quebec, Canada
3244 3244     Saskatchewan Canada 3/29/20 23:13 52.9399 -106.4509 156 0 0 0 Saskatchewan, Canada
34 34 2016 Aleutians West Alaska US 3/29/20 23:08 52.72541116 -110.4086433 0 0 0 0 Aleutians West, Alaska, US
3378 3378       Netherlands 3/29/20 23:08 52.1326 5.2913 10866 771 250 9845 Netherlands
3392 3392       Poland 3/29/20 23:08 51.9194 19.1451 1862 22 7 1833 Poland
3233 3233     Ontario Canada 3/29/20 23:13 51.2538 -85.3232 1355 21 0 0 Ontario, Canada
3324 3324       Germany 3/29/20 23:08 51.165691 10.451526 62095 533 9211 52351 Germany
3279 3279       Belgium 3/29/20 23:08 50.8333 4.469936 10836 431 1359 9046 Belgium
3304 3304       Czechia 3/29/20 23:08 49.8175 15.473 2817 16 11 2790 Czechia
3360 3360       Luxembourg 3/29/20 23:08 49.8153 6.1296 1950 21 40 1889 Luxembourg
3186 3186     Channel Islands United Kingdom 3/29/20 23:08 49.3723 -2.3644 108 2 0 106 Channel Islands, United Kingdom
3062 3062 53073 Whatcom Washington US 3/29/20 23:08 48.82227976 -121.7490018 116 7 0 0 Whatcom, Washington, US
790 790 38023 Divide North Dakota US 3/29/20 23:08 48.8149387 -103.4873611 1 0 0 0 Divide, North Dakota, US
244 244 38009 Bottineau North Dakota US 3/29/20 23:08 48.79106111 -100.8378166 0 0 0 0 Bottineau, North Dakota, US
316 316 38013 Burke North Dakota US 3/29/20 23:08 48.79094471 -102.5182117 0 0 0 0 Burke, North Dakota, US
715 715 30019 Daniels Montana US 3/29/20 23:08 48.78420029 -105.5476343 0 0 0 0 Daniels, Montana, US
1522 1522 27069 Kittson Minnesota US 3/29/20 23:08 48.77754106 -96.78317184 0 0 0 0 Kittson, Minnesota, US
2470 2470 27135 Roseau Minnesota US 3/29/20 23:08 48.77501878 -95.81079919 0 0 0 0 Roseau, Minnesota, US
435 435 38019 Cavalier North Dakota US 3/29/20 23:08 48.77286211 -98.46685243 0 0 0 0 Cavalier, North Dakota, US
2465 2465 38079 Rolette North Dakota US 3/29/20 23:08 48.77245354 -99.84097493 0 0 0 0 Rolette, North Dakota, US
1575 1575 27077 Lake of the Woods Minnesota US 3/29/20 23:08 48.77217001 -94.90274472 0 0 0 0 Lake of the Woods, Minnesota, US
246 246 16021 Boundary Idaho US 3/29/20 23:08 48.76684761 -116.4630179 0 0 0 0 Boundary, Idaho, US
2219 2219 38067 Pembina North Dakota US 3/29/20 23:08 48.76623521 -97.5523809 0 0 0 0 Pembina, North Dakota, US
2604 2604 30091 Sheridan Montana US 3/29/20 23:08 48.72085833 -104.503829 0 0 0 0 Sheridan, Montana, US
2412 2412 38075 Renville North Dakota US 3/29/20 23:08 48.71982533 -101.6603912 0 0 0 0 Renville, North Dakota, US
1047 1047 30035 Glacier Montana US 3/29/20 23:08 48.70513576 -112.9934235 0 0 0 0 Glacier, Montana, US
2819 2819 38095 Towner North Dakota US 3/29/20 23:08 48.68565745 -99.24564265 0 0 0 0 Towner, North Dakota, US
3408 3408       Slovakia 3/29/20 23:08 48.669 19.699 314 0 2 312 Slovakia
2816 2816 30101 Toole Montana US 3/29/20 23:08 48.65577551 -111.6942414 5 0 0 0 Toole, Montana, US
1270 1270 30041 Hill Montana US 3/29/20 23:08 48.62879827 -110.1129252 1 0 0 0 Hill, Montana, US
2515 2515 53055 San Juan Washington US 3/29/20 23:08 48.60182783 -122.96745 4 0 0 0 San Juan, Washington, US
1659 1659 30051 Liberty Montana US 3/29/20 23:08 48.56084317 -111.024307 0 0 0 0 Liberty, Montana, US
2126 2126 53047 Okanogan Washington US 3/29/20 23:08 48.54855019 -119.7387224 3 0 0 0 Okanogan, Washington, US
1675 1675 30053 Lincoln Montana US 3/29/20 23:08 48.54265777 -115.4046155 3 1 0 0 Lincoln, Montana, US
2221 2221 53051 Pend Oreille Washington US 3/29/20 23:08 48.53234021 -117.2741804 0 0 0 0 Pend Oreille, Washington, US
2625 2625 53057 Skagit Washington US 3/29/20 23:08 48.48171488 -121.766131 99 3 0 0 Skagit, Washington, US
927 927 53019 Ferry Washington US 3/29/20 23:08 48.4711431 -118.5154041 1 0 0 0 Ferry, Washington, US
214 214 30005 Blaine Montana US 3/29/20 23:08 48.43175214 -108.9582723 0 0 0 0 Blaine, Montana, US
2705 2705 53065 Stevens Washington US 3/29/20 23:08 48.40035475 -117.8542701 3 0 0 0 Stevens, Washington, US
3428 3428       Ukraine 3/29/20 23:08 48.3794 31.1656 475 10 6 459 Ukraine
2952 2952 38099 Walsh North Dakota US 3/29/20 23:08 48.36876964 -97.72574783 1 0 0 0 Walsh, North Dakota, US
2911 2911 30105 Valley Montana US 3/29/20 23:08 48.36435097 -106.6669635 0 0 0 0 Valley, Montana, US
1819 1819 27089 Marshall Minnesota US 3/29/20 23:08 48.35825983 -96.37017407 0 0 0 0 Marshall, Minnesota, US
3093 3093 38105 Williams North Dakota US 3/29/20 23:08 48.34522353 -103.4793387 0 0 0 0 Williams, North Dakota, US
230 230 16017 Bonner Idaho US 3/29/20 23:08 48.29996017 -116.6017932 1 0 0 0 Bonner, Idaho, US
2467 2467 30085 Roosevelt Montana US 3/29/20 23:08 48.29607488 -105.0079268 1 0 0 0 Roosevelt, Montana, US
933 933 30029 Flathead Montana US 3/29/20 23:08 48.29575866 -114.0520569 7 0 0 0 Flathead, Montana, US
2383 2383 38071 Ramsey North Dakota US 3/29/20 23:08 48.26886249 -98.72223879 3 0 0 0 Ramsey, North Dakota, US
2255 2255 30071 Phillips Montana US 3/29/20 23:08 48.25936577 -107.9128511 0 0 0 0 Phillips, Montana, US
2264 2264 38069 Pierce North Dakota US 3/29/20 23:08 48.24977025 -99.96407787 2 0 0 0 Pierce, North Dakota, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [03-29-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
);