03-23-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,416 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
3194 3194     Greenland Denmark 2020-03-23 23:19:21 71.7069 -42.6043 4 0 0 4 Greenland, Denmark
3226 3226     Nunavut Canada 2020-03-23 23:23:10 70.2998 -83.1076 0 0 0 0 Nunavut, Canada
2095 2095 2185 North Slope Alaska US 2020-03-23 23:19:34 69.31479216 -153.4836093 0 0 0 0 North Slope, Alaska, US
2101 2101 2188 Northwest Arctic Alaska US 2020-03-23 23:19:34 67.04919196 -159.7503946 0 0 0 0 Northwest Arctic, Alaska, US
3165 3165 2290 Yukon-Koyukuk Alaska US 2020-03-23 23:19:34 65.50815459 -151.39073869999999 0 0 0 0 Yukon-Koyukuk, Alaska, US
3322 3322       Iceland 2020-03-23 23:19:21 64.9631 -19.0208 588 1 51 536 Iceland
2091 2091 2180 Nome Alaska US 2020-03-23 23:19:34 64.90320724 -164.0353804 0 0 0 0 Nome, Alaska, US
899 899 2090 Fairbanks North Star Alaska US 2020-03-23 23:19:34 64.80726247 -146.5692662 7 0 0 0 Fairbanks North Star, Alaska, US
2646 2646 2240 Southeast Fairbanks Alaska US 2020-03-23 23:19:34 63.87692095 -143.2127643 0 0 0 0 Southeast Fairbanks, Alaska, US
767 767 2068 Denali Alaska US 2020-03-23 23:19:34 63.67264044 -150.0076108 0 0 0 0 Denali, Alaska, US
1841 1841 2170 Matanuska-Susitna Alaska US 2020-03-23 23:19:34 62.31305045 -149.5741743 0 0 0 0 Matanuska-Susitna, Alaska, US
1542 1542 2158 Kusilvak Alaska US 2020-03-23 23:19:34 62.15429159999999 -163.39678830000003 0 0 0 0 Kusilvak, Alaska, US
3307 3307       Finland 2020-03-23 23:19:21 61.92411 25.748151 700 1 10 689 Finland
3186 3186     Faroe Islands Denmark 2020-03-23 23:19:21 61.8926 -6.9118 118 0 23 95 Faroe Islands, Denmark
3377 3377       Russia 2020-03-23 23:19:21 61.52401 105.31875600000001 438 1 17 420 Russia
2904 2904 2261 Valdez-Cordova Alaska US 2020-03-23 23:19:34 61.47502768 -144.7126799 0 0 0 0 Valdez-Cordova, Alaska, US
59 59 2020 Anchorage Alaska US 2020-03-23 23:19:34 61.14998174 -149.14269860000005 13 0 0 0 Anchorage, Alaska, US
200 200 2050 Bethel Alaska US 2020-03-23 23:19:34 60.90980451 -159.8561831 0 0 0 0 Bethel, Alaska, US
3365 3365       Norway 2020-03-23 23:19:21 60.472 8.4689 2621 10 6 2605 Norway
1483 1483 2122 Kenai Peninsula Alaska US 2020-03-23 23:19:34 60.24429722 -151.53888840000005 3 0 0 0 Kenai Peninsula,Alaska,US
3396 3396       Sweden 2020-03-23 23:19:21 60.128161 18.643501 2046 25 16 2005 Sweden
3145 3145 2282 Yakutat Alaska US 2020-03-23 23:19:34 59.890980799999994 -140.36014509999998 0 0 0 0 Yakutat, Alaska, US
785 785 2070 Dillingham Alaska US 2020-03-23 23:19:34 59.79603738 -158.23819419999995 0 0 0 0 Dillingham, Alaska, US
2627 2627 2230 Skagway Alaska US 2020-03-23 23:19:34 59.56149996 -135.33377480000001 0 0 0 0 Skagway, Alaska, US
1152 1152 2100 Haines Alaska US 2020-03-23 23:19:34 59.09893571 -135.4679843 0 0 0 0 Haines, Alaska, US
275 275 2060 Bristol Bay Alaska US 2020-03-23 23:19:34 58.74513976 -156.701064 0 0 0 0 Bristol Bay, Alaska, US
1575 1575 2164 Lake and Peninsula Alaska US 2020-03-23 23:19:34 58.62403337 -156.21405890000003 0 0 0 0 Lake and Peninsula, Alaska, US
3303 3303       Estonia 2020-03-23 23:19:21 58.5953 25.0136 352 0 4 348 Estonia
1462 1462 2110 Juneau Alaska US 2020-03-23 23:19:34 58.45031811 -134.200436 1 0 0 0 Juneau, Alaska, US
1292 1292 2105 Hoonah-Angoon Alaska US 2020-03-23 23:19:34 58.29307365 -135.64244240000002 0 0 0 0 Hoonah-Angoon, Alaska, US
1537 1537 2150 Kodiak Island Alaska US 2020-03-23 23:19:34 57.65529415 -153.7493579 0 0 0 0 Kodiak Island, Alaska, US
2625 2625 2220 Sitka Alaska US 2020-03-23 23:19:34 57.24124555 -135.3206587 0 0 0 0 Sitka, Alaska, US
2246 2246 2195 Petersburg Alaska US 2020-03-23 23:19:34 57.13978948 -132.9540995 0 0 0 0 Petersburg, Alaska, US
3338 3338       Latvia 2020-03-23 23:19:21 56.8796 24.6032 180 0 1 179 Latvia
3133 3133 2275 Wrangell Alaska US 2020-03-23 23:19:34 56.3202004 -132.05837309999998 0 0 0 0 Wrangell, Alaska, US
3294 3294       Denmark 2020-03-23 23:19:21 56.2639 9.5018 1450 24 1 1425 Denmark
2351 2351 2198 Prince of Wales-Hyder Alaska US 2020-03-23 23:19:34 55.76261984 -133.0511621 0 0 0 0 Prince of Wales-Hyder, Alaska, US
1499 1499 2130 Ketchikan Gateway Alaska US 2020-03-23 23:19:34 55.57445008 -130.975561 6 0 0 0 Ketchikan Gateway, Alaska, US
3410 3410       United Kingdom 2020-03-23 23:19:21 55.3781 -3.4360000000000004 6650 335 135 6180 United Kingdom
33 33 2013 Aleutians East Alaska US 2020-03-23 23:19:34 55.32222414 -161.9722021 0 0 0 0 Aleutians East, Alaska, US
3342 3342       Lithuania 2020-03-23 23:19:21 55.1694 23.8813 128 0 0 177 Lithuania
3208 3208     Isle of Man United Kingdom 2020-03-23 23:19:21 54.2361 -4.5481 13 0 0 13 Isle of Man, United Kingdom
3171 3171     Alberta Canada 2020-03-23 23:23:10 53.9333 -116.5765 301 1 0 0 Alberta, Canada
3214 3214     Manitoba Canada 2020-03-23 23:23:10 53.7609 -98.8139 20 0 0 0 Manitoba, Canada
3178 3178     British Columbia Canada 2020-03-23 23:23:10 53.7267 -127.6476 472 13 0 0 British Columbia, Canada
3268 3268       Belarus 2020-03-23 23:19:21 53.7098 27.9534 81 0 22 59 Belarus
3327 3327       Ireland 2020-03-23 23:19:21 53.1424 -7.6921 1125 6 5 1114 Ireland
3221 3221     Newfoundland and Labrador Canada 2020-03-23 23:23:10 53.1355 -57.6604 24 0 0 0 Newfoundland and Labrador, Canada
3231 3231     Quebec Canada 2020-03-23 23:23:10 52.9399 -73.5491 628 8 0 0 Quebec, Canada
3236 3236     Saskatchewan Canada 2020-03-23 23:23:10 52.9399 -106.4509 66 0 0 0 Saskatchewan, Canada
34 34 2016 Aleutians West Alaska US 2020-03-23 23:19:34 52.72541116 -110.4086433 0 0 0 0 Aleutians West, Alaska, US
3359 3359       Netherlands 2020-03-23 23:19:21 52.1326 5.2913 4749 213 2 4534 Netherlands
3373 3373       Poland 2020-03-23 23:19:21 51.9194 19.1451 749 8 13 728 Poland
3227 3227     Ontario Canada 2020-03-23 23:23:10 51.2538 -85.3232 503 6 0 0 Ontario, Canada
3311 3311       Germany 2020-03-23 23:19:21 51.165690999999995 10.451526 29056 123 453 28480 Germany
3269 3269       Belgium 2020-03-23 23:19:21 50.8333 4.469936 3743 88 401 3254 Belgium
3293 3293       Czechia 2020-03-23 23:19:21 49.8175 15.472999999999999 1236 1 7 1228 Czechia
3343 3343       Luxembourg 2020-03-23 23:19:21 49.8153 6.1296 875 8 6 861 Luxembourg
3180 3180     Channel Islands United Kingdom 2020-03-23 23:19:21 49.3723 -2.3644 36 0 0 36 Channel Islands, United Kingdom
3058 3058 53073 Whatcom Washington US 2020-03-23 23:19:34 48.82227976 -121.74900179999999 48 2 0 0 Whatcom, Washington, US
790 790 38023 Divide North Dakota US 2020-03-23 23:19:34 48.814938700000006 -103.48736109999999 0 0 0 0 Divide, North Dakota, US
244 244 38009 Bottineau North Dakota US 2020-03-23 23:19:34 48.79106111 -100.8378166 0 0 0 0 Bottineau, North Dakota, US
316 316 38013 Burke North Dakota US 2020-03-23 23:19:34 48.79094471 -102.51821170000001 0 0 0 0 Burke, North Dakota, US
715 715 30019 Daniels Montana US 2020-03-23 23:19:34 48.78420029 -105.54763429999998 0 0 0 0 Daniels, Montana, US
1523 1523 27069 Kittson Minnesota US 2020-03-23 23:19:34 48.77754106 -96.78317184 0 0 0 0 Kittson, Minnesota, US
2471 2471 27135 Roseau Minnesota US 2020-03-23 23:19:34 48.77501878 -95.81079919 0 0 0 0 Roseau, Minnesota, US
435 435 38019 Cavalier North Dakota US 2020-03-23 23:19:34 48.77286211 -98.46685243 0 0 0 0 Cavalier, North Dakota, US
2466 2466 38079 Rolette North Dakota US 2020-03-23 23:19:34 48.77245354 -99.84097493 0 0 0 0 Rolette, North Dakota, US
1576 1576 27077 Lake of the Woods Minnesota US 2020-03-23 23:19:34 48.77217001 -94.90274472 0 0 0 0 Lake of the Woods, Minnesota, US
246 246 16021 Boundary Idaho US 2020-03-23 23:19:34 48.76684761 -116.4630179 0 0 0 0 Boundary, Idaho, US
2220 2220 38067 Pembina North Dakota US 2020-03-23 23:19:34 48.76623521 -97.5523809 0 0 0 0 Pembina, North Dakota, US
2605 2605 30091 Sheridan Montana US 2020-03-23 23:19:34 48.72085833 -104.50382900000001 0 0 0 0 Sheridan, Montana, US
2413 2413 38075 Renville North Dakota US 2020-03-23 23:19:34 48.71982533 -101.6603912 0 0 0 0 Renville, North Dakota, US
1048 1048 30035 Glacier Montana US 2020-03-23 23:19:34 48.70513576 -112.9934235 0 0 0 0 Glacier, Montana, US
2820 2820 38095 Towner North Dakota US 2020-03-23 23:19:34 48.68565745 -99.24564265 0 0 0 0 Towner, North Dakota, US
3388 3388       Slovakia 2020-03-23 23:19:21 48.669 19.699 186 0 7 179 Slovakia
2817 2817 30101 Toole Montana US 2020-03-23 23:19:34 48.65577551 -111.69424140000001 0 0 0 0 Toole, Montana, US
1271 1271 30041 Hill Montana US 2020-03-23 23:19:34 48.62879827 -110.1129252 0 0 0 0 Hill, Montana, US
2516 2516 53055 San Juan Washington US 2020-03-23 23:19:34 48.60182783 -122.96745 1 0 0 0 San Juan, Washington, US
1660 1660 30051 Liberty Montana US 2020-03-23 23:19:34 48.56084317 -111.02430700000001 0 0 0 0 Liberty, Montana, US
2127 2127 53047 Okanogan Washington US 2020-03-23 23:19:34 48.54855019 -119.73872240000001 0 0 0 0 Okanogan, Washington, US
1676 1676 30053 Lincoln Montana US 2020-03-23 23:19:34 48.54265777 -115.4046155 0 0 0 0 Lincoln, Montana, US
2222 2222 53051 Pend Oreille Washington US 2020-03-23 23:19:34 48.53234021 -117.2741804 0 0 0 0 Pend Oreille, Washington, US
2626 2626 53057 Skagit Washington US 2020-03-23 23:19:34 48.48171488 -121.766131 33 0 0 0 Skagit, Washington, US
928 928 53019 Ferry Washington US 2020-03-23 23:19:34 48.471143100000006 -118.5154041 0 0 0 0 Ferry, Washington, US
214 214 30005 Blaine Montana US 2020-03-23 23:19:34 48.43175214 -108.9582723 0 0 0 0 Blaine, Montana, US
2706 2706 53065 Stevens Washington US 2020-03-23 23:19:34 48.40035475 -117.8542701 1 0 0 0 Stevens, Washington, US
3408 3408       Ukraine 2020-03-23 23:19:21 48.3794 31.1656 73 3 1 69 Ukraine
2948 2948 38099 Walsh North Dakota US 2020-03-23 23:19:34 48.36876964 -97.72574783 0 0 0 0 Walsh, North Dakota, US
2907 2907 30105 Valley Montana US 2020-03-23 23:19:34 48.36435097 -106.6669635 0 0 0 0 Valley, Montana, US
1820 1820 27089 Marshall Minnesota US 2020-03-23 23:19:34 48.35825983 -96.37017407 0 0 0 0 Marshall, Minnesota, US
3089 3089 38105 Williams North Dakota US 2020-03-23 23:19:34 48.34522353 -103.4793387 0 0 0 0 Williams, North Dakota, US
230 230 16017 Bonner Idaho US 2020-03-23 23:19:34 48.29996017 -116.6017932 0 0 0 0 Bonner, Idaho, US
2468 2468 30085 Roosevelt Montana US 2020-03-23 23:19:34 48.29607488 -105.00792679999999 1 0 0 0 Roosevelt, Montana, US
934 934 30029 Flathead Montana US 2020-03-23 23:19:34 48.29575866 -114.05205690000001 2 0 0 0 Flathead, Montana, US
2384 2384 38071 Ramsey North Dakota US 2020-03-23 23:19:34 48.26886249 -98.72223879 1 0 0 0 Ramsey, North Dakota, US
2256 2256 30071 Phillips Montana US 2020-03-23 23:19:34 48.25936577 -107.9128511 0 0 0 0 Phillips, Montana, US
2265 2265 38069 Pierce North Dakota US 2020-03-23 23:19:34 48.24977025 -99.96407787 2 0 0 0 Pierce, North Dakota, US
1538 1538 27071 Koochiching Minnesota US 2020-03-23 23:19:34 48.24539665 -93.78352843 0 0 0 0 Koochiching, Minnesota, US
1861 1861 38049 McHenry North Dakota US 2020-03-23 23:19:34 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-23-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
);