03-24-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,419 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
3192 3192     Greenland Denmark 2020-03-24 23:37:15 71.7069 -42.6043 5 0 2 3 Greenland, Denmark
3224 3224     Nunavut Canada 2020-03-24 23:41:36 70.2998 -83.1076 0 0 0 0 Nunavut, Canada
2095 2095 2185 North Slope Alaska US 2020-03-24 23:37:31 69.31479216 -153.4836093 0 0 0 0 North Slope, Alaska, US
2101 2101 2188 Northwest Arctic Alaska US 2020-03-24 23:37:31 67.04919196 -159.7503946 0 0 0 0 Northwest Arctic, Alaska, US
3164 3164 2290 Yukon-Koyukuk Alaska US 2020-03-24 23:37:31 65.50815459 -151.39073869999999 0 0 0 0 Yukon-Koyukuk, Alaska, US
3323 3323       Iceland 2020-03-24 23:37:15 64.9631 -19.0208 648 2 51 595 Iceland
2091 2091 2180 Nome Alaska US 2020-03-24 23:37:31 64.90320724 -164.0353804 0 0 0 0 Nome, Alaska, US
899 899 2090 Fairbanks North Star Alaska US 2020-03-24 23:37:31 64.80726247 -146.5692662 7 0 0 0 Fairbanks North Star, Alaska, US
2646 2646 2240 Southeast Fairbanks Alaska US 2020-03-24 23:37:31 63.87692095 -143.2127643 0 0 0 0 Southeast Fairbanks, Alaska, US
767 767 2068 Denali Alaska US 2020-03-24 23:37:31 63.67264044 -150.0076108 0 0 0 0 Denali, Alaska, US
1841 1841 2170 Matanuska-Susitna Alaska US 2020-03-24 23:37:31 62.31305045 -149.5741743 0 0 0 0 Matanuska-Susitna, Alaska, US
1542 1542 2158 Kusilvak Alaska US 2020-03-24 23:37:31 62.15429159999999 -163.39678830000003 0 0 0 0 Kusilvak, Alaska, US
3307 3307       Finland 2020-03-24 23:37:15 61.92411 25.748151 792 1 10 781 Finland
3184 3184     Faroe Islands Denmark 2020-03-24 23:37:15 61.8926 -6.9118 122 0 33 89 Faroe Islands, Denmark
3380 3380       Russia 2020-03-24 23:37:15 61.52401 105.31875600000001 495 1 22 472 Russia
2903 2903 2261 Valdez-Cordova Alaska US 2020-03-24 23:37:31 61.47502768 -144.7126799 0 0 0 0 Valdez-Cordova, Alaska, US
59 59 2020 Anchorage Alaska US 2020-03-24 23:37:31 61.14998174 -149.14269860000005 17 0 0 0 Anchorage, Alaska, US
200 200 2050 Bethel Alaska US 2020-03-24 23:37:31 60.90980451 -159.8561831 0 0 0 0 Bethel, Alaska, US
3368 3368       Norway 2020-03-24 23:37:15 60.472 8.4689 2863 12 6 2845 Norway
1483 1483 2122 Kenai Peninsula Alaska US 2020-03-24 23:37:31 60.24429722 -151.53888840000005 3 0 0 0 Kenai Peninsula,Alaska,US
3399 3399       Sweden 2020-03-24 23:37:15 60.128161 18.643501 2286 36 16 2234 Sweden
3144 3144 2282 Yakutat Alaska US 2020-03-24 23:37:31 59.890980799999994 -140.36014509999998 0 0 0 0 Yakutat, Alaska, US
785 785 2070 Dillingham Alaska US 2020-03-24 23:37:31 59.79603738 -158.23819419999995 0 0 0 0 Dillingham, Alaska, US
2627 2627 2230 Skagway Alaska US 2020-03-24 23:37:31 59.56149996 -135.33377480000001 0 0 0 0 Skagway, Alaska, US
1152 1152 2100 Haines Alaska US 2020-03-24 23:37:31 59.09893571 -135.4679843 0 0 0 0 Haines, Alaska, US
275 275 2060 Bristol Bay Alaska US 2020-03-24 23:37:31 58.74513976 -156.701064 0 0 0 0 Bristol Bay, Alaska, US
1575 1575 2164 Lake and Peninsula Alaska US 2020-03-24 23:37:31 58.62403337 -156.21405890000003 0 0 0 0 Lake and Peninsula, Alaska, US
3303 3303       Estonia 2020-03-24 23:37:15 58.5953 25.0136 369 0 7 362 Estonia
1462 1462 2110 Juneau Alaska US 2020-03-24 23:37:31 58.45031811 -134.200436 1 0 0 0 Juneau, Alaska, US
1292 1292 2105 Hoonah-Angoon Alaska US 2020-03-24 23:37:31 58.29307365 -135.64244240000002 0 0 0 0 Hoonah-Angoon, Alaska, US
1537 1537 2150 Kodiak Island Alaska US 2020-03-24 23:37:31 57.65529415 -153.7493579 0 0 0 0 Kodiak Island, Alaska, US
2625 2625 2220 Sitka Alaska US 2020-03-24 23:37:31 57.24124555 -135.3206587 0 0 0 0 Sitka, Alaska, US
2246 2246 2195 Petersburg Alaska US 2020-03-24 23:37:31 57.13978948 -132.9540995 0 0 0 0 Petersburg, Alaska, US
3340 3340       Latvia 2020-03-24 23:37:15 56.8796 24.6032 197 0 1 196 Latvia
3132 3132 2275 Wrangell Alaska US 2020-03-24 23:37:31 56.3202004 -132.05837309999998 0 0 0 0 Wrangell, Alaska, US
3294 3294       Denmark 2020-03-24 23:37:15 56.2639 9.5018 1591 32 1 1558 Denmark
2351 2351 2198 Prince of Wales-Hyder Alaska US 2020-03-24 23:37:31 55.76261984 -133.0511621 0 0 0 0 Prince of Wales-Hyder, Alaska, US
1499 1499 2130 Ketchikan Gateway Alaska US 2020-03-24 23:37:31 55.57445008 -130.975561 6 0 0 0 Ketchikan Gateway, Alaska, US
3413 3413       United Kingdom 2020-03-24 23:37:15 55.3781 -3.4360000000000004 8077 422 135 7520 United Kingdom
33 33 2013 Aleutians East Alaska US 2020-03-24 23:37:31 55.32222414 -161.9722021 0 0 0 0 Aleutians East, Alaska, US
3345 3345       Lithuania 2020-03-24 23:37:15 55.1694 23.8813 166 1 0 206 Lithuania
3206 3206     Isle of Man United Kingdom 2020-03-24 23:37:15 54.2361 -4.5481 23 0 0 23 Isle of Man, United Kingdom
3170 3170     Alberta Canada 2020-03-24 23:41:36 53.9333 -116.5765 359 1 0 0 Alberta, Canada
3212 3212     Manitoba Canada 2020-03-24 23:41:36 53.7609 -98.8139 21 0 0 0 Manitoba, Canada
3177 3177     British Columbia Canada 2020-03-24 23:41:36 53.7267 -127.6476 617 13 0 0 British Columbia, Canada
3268 3268       Belarus 2020-03-24 23:37:15 53.7098 27.9534 81 0 22 59 Belarus
3328 3328       Ireland 2020-03-24 23:37:15 53.1424 -7.6921 1329 7 5 1317 Ireland
3219 3219     Newfoundland and Labrador Canada 2020-03-24 23:41:36 53.1355 -57.6604 35 0 0 0 Newfoundland and Labrador, Canada
3229 3229     Quebec Canada 2020-03-24 23:41:36 52.9399 -73.5491 1013 11 0 0 Quebec, Canada
3236 3236     Saskatchewan Canada 2020-03-24 23:41:36 52.9399 -106.4509 72 0 0 0 Saskatchewan, Canada
34 34 2016 Aleutians West Alaska US 2020-03-24 23:37:31 52.72541116 -110.4086433 0 0 0 0 Aleutians West, Alaska, US
3362 3362       Netherlands 2020-03-24 23:37:15 52.1326 5.2913 5560 276 2 5282 Netherlands
3376 3376       Poland 2020-03-24 23:37:15 51.9194 19.1451 901 10 1 890 Poland
3225 3225     Ontario Canada 2020-03-24 23:41:36 51.2538 -85.3232 588 7 0 0 Ontario, Canada
3312 3312       Germany 2020-03-24 23:37:15 51.165690999999995 10.451526 32986 157 3243 29586 Germany
3269 3269       Belgium 2020-03-24 23:37:15 50.8333 4.469936 4269 122 461 3686 Belgium
3293 3293       Czechia 2020-03-24 23:37:15 49.8175 15.472999999999999 1394 3 10 1381 Czechia
3346 3346       Luxembourg 2020-03-24 23:37:15 49.8153 6.1296 1099 8 6 1085 Luxembourg
3179 3179     Channel Islands United Kingdom 2020-03-24 23:37:15 49.3723 -2.3644 36 0 0 36 Channel Islands, United Kingdom
3057 3057 53073 Whatcom Washington US 2020-03-24 23:37:31 48.82227976 -121.74900179999999 48 2 0 0 Whatcom, Washington, US
790 790 38023 Divide North Dakota US 2020-03-24 23:37:31 48.814938700000006 -103.48736109999999 0 0 0 0 Divide, North Dakota, US
244 244 38009 Bottineau North Dakota US 2020-03-24 23:37:31 48.79106111 -100.8378166 0 0 0 0 Bottineau, North Dakota, US
316 316 38013 Burke North Dakota US 2020-03-24 23:37:31 48.79094471 -102.51821170000001 0 0 0 0 Burke, North Dakota, US
715 715 30019 Daniels Montana US 2020-03-24 23:37:31 48.78420029 -105.54763429999998 0 0 0 0 Daniels, Montana, US
1523 1523 27069 Kittson Minnesota US 2020-03-24 23:37:31 48.77754106 -96.78317184 0 0 0 0 Kittson, Minnesota, US
2471 2471 27135 Roseau Minnesota US 2020-03-24 23:37:31 48.77501878 -95.81079919 0 0 0 0 Roseau, Minnesota, US
435 435 38019 Cavalier North Dakota US 2020-03-24 23:37:31 48.77286211 -98.46685243 0 0 0 0 Cavalier, North Dakota, US
2466 2466 38079 Rolette North Dakota US 2020-03-24 23:37:31 48.77245354 -99.84097493 0 0 0 0 Rolette, North Dakota, US
1576 1576 27077 Lake of the Woods Minnesota US 2020-03-24 23:37:31 48.77217001 -94.90274472 0 0 0 0 Lake of the Woods, Minnesota, US
246 246 16021 Boundary Idaho US 2020-03-24 23:37:31 48.76684761 -116.4630179 0 0 0 0 Boundary, Idaho, US
2220 2220 38067 Pembina North Dakota US 2020-03-24 23:37:31 48.76623521 -97.5523809 0 0 0 0 Pembina, North Dakota, US
2605 2605 30091 Sheridan Montana US 2020-03-24 23:37:31 48.72085833 -104.50382900000001 0 0 0 0 Sheridan, Montana, US
2413 2413 38075 Renville North Dakota US 2020-03-24 23:37:31 48.71982533 -101.6603912 0 0 0 0 Renville, North Dakota, US
1048 1048 30035 Glacier Montana US 2020-03-24 23:37:31 48.70513576 -112.9934235 0 0 0 0 Glacier, Montana, US
2820 2820 38095 Towner North Dakota US 2020-03-24 23:37:31 48.68565745 -99.24564265 0 0 0 0 Towner, North Dakota, US
3391 3391       Slovakia 2020-03-24 23:37:15 48.669 19.699 204 0 7 197 Slovakia
2817 2817 30101 Toole Montana US 2020-03-24 23:37:31 48.65577551 -111.69424140000001 0 0 0 0 Toole, Montana, US
1271 1271 30041 Hill Montana US 2020-03-24 23:37:31 48.62879827 -110.1129252 0 0 0 0 Hill, Montana, US
2516 2516 53055 San Juan Washington US 2020-03-24 23:37:31 48.60182783 -122.96745 1 0 0 0 San Juan, Washington, US
1660 1660 30051 Liberty Montana US 2020-03-24 23:37:31 48.56084317 -111.02430700000001 0 0 0 0 Liberty, Montana, US
2127 2127 53047 Okanogan Washington US 2020-03-24 23:37:31 48.54855019 -119.73872240000001 0 0 0 0 Okanogan, Washington, US
1676 1676 30053 Lincoln Montana US 2020-03-24 23:37:31 48.54265777 -115.4046155 0 0 0 0 Lincoln, Montana, US
2222 2222 53051 Pend Oreille Washington US 2020-03-24 23:37:31 48.53234021 -117.2741804 0 0 0 0 Pend Oreille, Washington, US
2626 2626 53057 Skagit Washington US 2020-03-24 23:37:31 48.48171488 -121.766131 45 1 0 0 Skagit, Washington, US
928 928 53019 Ferry Washington US 2020-03-24 23:37:31 48.471143100000006 -118.5154041 0 0 0 0 Ferry, Washington, US
214 214 30005 Blaine Montana US 2020-03-24 23:37:31 48.43175214 -108.9582723 0 0 0 0 Blaine, Montana, US
2706 2706 53065 Stevens Washington US 2020-03-24 23:37:31 48.40035475 -117.8542701 1 0 0 0 Stevens, Washington, US
3411 3411       Ukraine 2020-03-24 23:37:15 48.3794 31.1656 97 3 1 93 Ukraine
2947 2947 38099 Walsh North Dakota US 2020-03-24 23:37:31 48.36876964 -97.72574783 1 0 0 0 Walsh, North Dakota, US
2906 2906 30105 Valley Montana US 2020-03-24 23:37:31 48.36435097 -106.6669635 0 0 0 0 Valley, Montana, US
1820 1820 27089 Marshall Minnesota US 2020-03-24 23:37:31 48.35825983 -96.37017407 0 0 0 0 Marshall, Minnesota, US
3088 3088 38105 Williams North Dakota US 2020-03-24 23:37:31 48.34522353 -103.4793387 0 0 0 0 Williams, North Dakota, US
230 230 16017 Bonner Idaho US 2020-03-24 23:37:31 48.29996017 -116.6017932 0 0 0 0 Bonner, Idaho, US
2468 2468 30085 Roosevelt Montana US 2020-03-24 23:37:31 48.29607488 -105.00792679999999 1 0 0 0 Roosevelt, Montana, US
934 934 30029 Flathead Montana US 2020-03-24 23:37:31 48.29575866 -114.05205690000001 4 0 0 0 Flathead, Montana, US
2384 2384 38071 Ramsey North Dakota US 2020-03-24 23:37:31 48.26886249 -98.72223879 1 0 0 0 Ramsey, North Dakota, US
2256 2256 30071 Phillips Montana US 2020-03-24 23:37:31 48.25936577 -107.9128511 0 0 0 0 Phillips, Montana, US
2265 2265 38069 Pierce North Dakota US 2020-03-24 23:37:31 48.24977025 -99.96407787 2 0 0 0 Pierce, North Dakota, US
1538 1538 27071 Koochiching Minnesota US 2020-03-24 23:37:31 48.24539665 -93.78352843 0 0 0 0 Koochiching, Minnesota, US
1861 1861 38049 McHenry North Dakota US 2020-03-24 23:37:31 48.23104458 -100.6324822 0 0 0 0 McHenry, North Dakota, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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