03-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,442 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
3203 3203     Greenland Denmark 3/30/20 22:52 71.7069 -42.6043 10 0 2 8 Greenland, Denmark
3236 3236     Nunavut Canada 3/30/20 22:58 70.2998 -83.1076 0 0 0 0 Nunavut, Canada
2094 2094 2185 North Slope Alaska US 3/30/20 22:52 69.31479216 -153.4836093 0 0 0 0 North Slope, Alaska, US
2100 2100 2188 Northwest Arctic Alaska US 3/30/20 22:52 67.04919196 -159.7503946 0 0 0 0 Northwest Arctic, Alaska, US
3173 3173 2290 Yukon-Koyukuk Alaska US 3/30/20 22:52 65.50815459 -151.3907387 0 0 0 0 Yukon-Koyukuk, Alaska, US
3341 3341       Iceland 3/30/20 22:52 64.9631 -19.0208 1086 2 157 927 Iceland
2090 2090 2180 Nome Alaska US 3/30/20 22:52 64.90320724 -164.0353804 0 0 0 0 Nome, Alaska, US
3234 3234     Northwest Territories Canada 3/30/20 22:58 64.8255 -124.8457 1 0 0 0 ,Northwest Territories,Canada
898 898 2090 Fairbanks North Star Alaska US 3/30/20 22:52 64.80726247 -146.5692662 28 0 0 0 Fairbanks North Star,Alaska,US
3265 3265     Yukon Canada 3/30/20 22:58 64.2823 -135.0 4 0 0 0 ,Yukon,Canada
2645 2645 2240 Southeast Fairbanks Alaska US 3/30/20 22:52 63.87692095 -143.2127643 0 0 0 0 Southeast Fairbanks, Alaska, US
767 767 2068 Denali Alaska US 3/30/20 22:52 63.67264044 -150.0076108 0 0 0 0 Denali, Alaska, US
1840 1840 2170 Matanuska-Susitna Alaska US 3/30/20 22:52 62.31305045 -149.5741743 2 0 0 0 Matanuska-Susitna,Alaska,US
1541 1541 2158 Kusilvak Alaska US 3/30/20 22:52 62.1542916 -163.3967883 0 0 0 0 Kusilvak, Alaska, US
3324 3324       Finland 3/30/20 22:52 61.92411 25.748151 1352 13 10 1329 Finland
3195 3195     Faroe Islands Denmark 3/30/20 22:52 61.8926 -6.9118 168 0 70 98 Faroe Islands, Denmark
3401 3401       Russia 3/30/20 22:52 61.52401 105.318756 1836 9 66 1761 Russia
2912 2912 2261 Valdez-Cordova Alaska US 3/30/20 22:52 61.47502768 -144.7126799 0 0 0 0 Valdez-Cordova, Alaska, US
59 59 2020 Anchorage Alaska US 3/30/20 22:52 61.14998174 -149.1426986 59 1 0 0 Anchorage,Alaska,US
200 200 2050 Bethel Alaska US 3/30/20 22:52 60.90980451 -159.8561831 0 0 0 0 Bethel, Alaska, US
3389 3389       Norway 3/30/20 22:52 60.472 8.4689 4445 32 12 4401 Norway
1482 1482 2122 Kenai Peninsula Alaska US 3/30/20 22:52 60.24429722 -151.5388884 7 0 0 0 Kenai Peninsula,Alaska,US
3421 3421       Sweden 3/30/20 22:52 60.128161 18.643501 4028 146 16 3866 Sweden
3153 3153 2282 Yakutat Alaska US 3/30/20 22:52 59.8909808 -140.3601451 0 0 0 0 Yakutat, Alaska, US
785 785 2070 Dillingham Alaska US 3/30/20 22:52 59.79603738 -158.2381942 0 0 0 0 Dillingham, Alaska, US
2626 2626 2230 Skagway Alaska US 3/30/20 22:52 59.56149996 -135.3337748 0 0 0 0 Skagway, Alaska, US
1151 1151 2100 Haines Alaska US 3/30/20 22:52 59.09893571 -135.4679843 0 0 0 0 Haines, Alaska, US
275 275 2060 Bristol Bay Alaska US 3/30/20 22:52 58.74513976 -156.701064 0 0 0 0 Bristol Bay, Alaska, US
1574 1574 2164 Lake and Peninsula Alaska US 3/30/20 22:52 58.62403337 -156.2140589 0 0 0 0 Lake and Peninsula, Alaska, US
3320 3320       Estonia 3/30/20 22:52 58.5953 25.0136 715 3 20 692 Estonia
1461 1461 2110 Juneau Alaska US 3/30/20 22:52 58.45031811 -134.200436 5 0 0 0 Juneau, Alaska, US
1291 1291 2105 Hoonah-Angoon Alaska US 3/30/20 22:52 58.29307365 -135.6424424 0 0 0 0 Hoonah-Angoon, Alaska, US
1536 1536 2150 Kodiak Island Alaska US 3/30/20 22:52 57.65529415 -153.7493579 0 0 0 0 Kodiak Island, Alaska, US
2624 2624 2220 Sitka Alaska US 3/30/20 22:52 57.24124555 -135.3206587 0 0 0 0 Sitka, Alaska, US
2245 2245 2195 Petersburg Alaska US 3/30/20 22:52 57.13978948 -132.9540995 0 0 0 0 Petersburg, Alaska, US
3359 3359       Latvia 3/30/20 22:52 56.8796 24.6032 376 0 1 375 Latvia
3141 3141 2275 Wrangell Alaska US 3/30/20 22:52 56.3202004 -132.0583731 0 0 0 0 Wrangell, Alaska, US
3310 3310       Denmark 3/30/20 22:52 56.2639 9.5018 2577 77 1 2499 Denmark
2350 2350 2198 Prince of Wales-Hyder Alaska US 3/30/20 22:52 55.76261984 -133.0511621 0 0 0 0 Prince of Wales-Hyder, Alaska, US
1498 1498 2130 Ketchikan Gateway Alaska US 3/30/20 22:52 55.57445008 -130.975561 13 0 0 0 Ketchikan Gateway, Alaska, US
3435 3435       United Kingdom 3/30/20 22:52 55.3781 -3.436 22141 1408 135 20598 United Kingdom
33 33 2013 Aleutians East Alaska US 3/30/20 22:52 55.32222414 -161.9722021 0 0 0 0 Aleutians East, Alaska, US
3364 3364       Lithuania 3/30/20 22:52 55.1694 23.8813 424 4 0 477 Lithuania
3217 3217     Isle of Man United Kingdom 3/30/20 22:52 54.2361 -4.5481 49 0 0 49 Isle of Man, United Kingdom
3179 3179     Alberta Canada 3/30/20 22:58 53.9333 -116.5765 661 3 0 0 Alberta, Canada
3223 3223     Manitoba Canada 3/30/20 22:58 53.7609 -98.8139 96 1 0 0 Manitoba, Canada
3187 3187     British Columbia Canada 3/30/20 22:58 53.7267 -127.6476 970 19 0 0 British Columbia, Canada
3282 3282       Belarus 3/30/20 22:52 53.7098 27.9534 152 0 32 120 Belarus
3346 3346       Ireland 3/30/20 22:52 53.1424 -7.6921 2910 54 5 2851 Ireland
3230 3230     Newfoundland and Labrador Canada 3/30/20 22:58 53.1355 -57.6604 148 1 0 0 Newfoundland and Labrador, Canada
3241 3241     Quebec Canada 3/30/20 22:58 52.9399 -73.5491 3430 67 0 0 Quebec, Canada
3248 3248     Saskatchewan Canada 3/30/20 22:58 52.9399 -106.4509 156 2 0 0 Saskatchewan, Canada
34 34 2016 Aleutians West Alaska US 3/30/20 22:52 52.72541116 -110.4086433 0 0 0 0 Aleutians West, Alaska, US
3383 3383       Netherlands 3/30/20 22:52 52.1326 5.2913 11750 864 250 10636 Netherlands
3397 3397       Poland 3/30/20 22:52 51.9194 19.1451 2055 31 7 2017 Poland
3237 3237     Ontario Canada 3/30/20 22:58 51.2538 -85.3232 1706 31 0 0 Ontario, Canada
3329 3329       Germany 3/30/20 22:52 51.165691 10.451526 66885 645 13500 52740 Germany
3283 3283       Belgium 3/30/20 22:52 50.8333 4.469936 11899 513 1527 9859 Belgium
3309 3309       Czechia 3/30/20 22:52 49.8175 15.473 3001 23 25 2953 Czechia
3365 3365       Luxembourg 3/30/20 22:52 49.8153 6.1296 1988 22 40 1926 Luxembourg
3190 3190     Channel Islands United Kingdom 3/30/20 22:52 49.3723 -2.3644 141 2 0 139 Channel Islands, United Kingdom
3066 3066 53073 Whatcom Washington US 3/30/20 22:52 48.82227976 -121.7490018 116 7 0 0 Whatcom, Washington, US
790 790 38023 Divide North Dakota US 3/30/20 22:52 48.8149387 -103.4873611 1 0 0 0 Divide, North Dakota, US
244 244 38009 Bottineau North Dakota US 3/30/20 22:52 48.79106111 -100.8378166 0 0 0 0 Bottineau, North Dakota, US
316 316 38013 Burke North Dakota US 3/30/20 22:52 48.79094471 -102.5182117 0 0 0 0 Burke, North Dakota, US
715 715 30019 Daniels Montana US 3/30/20 22:52 48.78420029 -105.5476343 0 0 0 0 Daniels, Montana, US
1522 1522 27069 Kittson Minnesota US 3/30/20 22:52 48.77754106 -96.78317184 0 0 0 0 Kittson, Minnesota, US
2470 2470 27135 Roseau Minnesota US 3/30/20 22:52 48.77501878 -95.81079919 0 0 0 0 Roseau, Minnesota, US
435 435 38019 Cavalier North Dakota US 3/30/20 22:52 48.77286211 -98.46685243 0 0 0 0 Cavalier, North Dakota, US
2465 2465 38079 Rolette North Dakota US 3/30/20 22:52 48.77245354 -99.84097493 0 0 0 0 Rolette, North Dakota, US
1575 1575 27077 Lake of the Woods Minnesota US 3/30/20 22:52 48.77217001 -94.90274472 0 0 0 0 Lake of the Woods, Minnesota, US
246 246 16021 Boundary Idaho US 3/30/20 22:52 48.76684761 -116.4630179 0 0 0 0 Boundary, Idaho, US
2219 2219 38067 Pembina North Dakota US 3/30/20 22:52 48.76623521 -97.5523809 0 0 0 0 Pembina, North Dakota, US
2604 2604 30091 Sheridan Montana US 3/30/20 22:52 48.72085833 -104.503829 0 0 0 0 Sheridan, Montana, US
2412 2412 38075 Renville North Dakota US 3/30/20 22:52 48.71982533 -101.6603912 0 0 0 0 Renville, North Dakota, US
1047 1047 30035 Glacier Montana US 3/30/20 22:52 48.70513576 -112.9934235 0 0 0 0 Glacier, Montana, US
2819 2819 38095 Towner North Dakota US 3/30/20 22:52 48.68565745 -99.24564265 0 0 0 0 Towner, North Dakota, US
3413 3413       Slovakia 3/30/20 22:52 48.669 19.699 336 0 7 329 Slovakia
2816 2816 30101 Toole Montana US 3/30/20 22:52 48.65577551 -111.6942414 6 2 0 0 Toole, Montana, US
1270 1270 30041 Hill Montana US 3/30/20 22:52 48.62879827 -110.1129252 1 0 0 0 Hill, Montana, US
2515 2515 53055 San Juan Washington US 3/30/20 22:52 48.60182783 -122.96745 4 0 0 0 San Juan, Washington, US
1659 1659 30051 Liberty Montana US 3/30/20 22:52 48.56084317 -111.024307 0 0 0 0 Liberty, Montana, US
2126 2126 53047 Okanogan Washington US 3/30/20 22:52 48.54855019 -119.7387224 3 0 0 0 Okanogan, Washington, US
1675 1675 30053 Lincoln Montana US 3/30/20 22:52 48.54265777 -115.4046155 4 1 0 0 Lincoln, Montana, US
2221 2221 53051 Pend Oreille Washington US 3/30/20 22:52 48.53234021 -117.2741804 0 0 0 0 Pend Oreille, Washington, US
2625 2625 53057 Skagit Washington US 3/30/20 22:52 48.48171488 -121.766131 101 3 0 0 Skagit, Washington, US
927 927 53019 Ferry Washington US 3/30/20 22:52 48.4711431 -118.5154041 1 0 0 0 Ferry, Washington, US
214 214 30005 Blaine Montana US 3/30/20 22:52 48.43175214 -108.9582723 0 0 0 0 Blaine, Montana, US
2705 2705 53065 Stevens Washington US 3/30/20 22:52 48.40035475 -117.8542701 3 0 0 0 Stevens, Washington, US
3433 3433       Ukraine 3/30/20 22:52 48.3794 31.1656 548 13 8 527 Ukraine
2956 2956 38099 Walsh North Dakota US 3/30/20 22:52 48.36876964 -97.72574783 1 0 0 0 Walsh, North Dakota, US
2915 2915 30105 Valley Montana US 3/30/20 22:52 48.36435097 -106.6669635 0 0 0 0 Valley, Montana, US
1819 1819 27089 Marshall Minnesota US 3/30/20 22:52 48.35825983 -96.37017407 0 0 0 0 Marshall, Minnesota, US
3097 3097 38105 Williams North Dakota US 3/30/20 22:52 48.34522353 -103.4793387 0 0 0 0 Williams, North Dakota, US
230 230 16017 Bonner Idaho US 3/30/20 22:52 48.29996017 -116.6017932 1 0 0 0 Bonner, Idaho, US
2467 2467 30085 Roosevelt Montana US 3/30/20 22:52 48.29607488 -105.0079268 1 0 0 0 Roosevelt, Montana, US
933 933 30029 Flathead Montana US 3/30/20 22:52 48.29575866 -114.0520569 9 0 0 0 Flathead, Montana, US
2383 2383 38071 Ramsey North Dakota US 3/30/20 22:52 48.26886249 -98.72223879 3 0 0 0 Ramsey, North Dakota, US
2255 2255 30071 Phillips Montana US 3/30/20 22:52 48.25936577 -107.9128511 0 0 0 0 Phillips, Montana, US
2264 2264 38069 Pierce North Dakota US 3/30/20 22:52 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-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
);