04-01-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

2,486 rows sorted by Province_State

✎ 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
2310 2310       Afghanistan 2020-04-01 21:58:34 33.93911 67.709953 197 4 5 228 Afghanistan
2311 2311       Albania 2020-04-01 21:58:34 41.1533 20.1683 259 15 67 177 Albania
2312 2312       Algeria 2020-04-01 21:58:34 28.0339 1.6596 847 58 61 728 Algeria
2313 2313       Andorra 2020-04-01 21:58:34 42.5063 1.5218 390 14 10 366 Andorra
2314 2314       Angola 2020-04-01 21:58:34 -11.2027 17.8739 8 2 1 5 Angola
2315 2315       Antigua and Barbuda 2020-04-01 21:58:34 17.0608 -61.7964 7 0 0 7 Antigua and Barbuda
2316 2316       Argentina 2020-04-01 21:58:34 -38.4161 -63.6167 1054 28 248 778 Argentina
2317 2317       Armenia 2020-04-01 21:58:34 40.0691 45.0382 571 4 31 536 Armenia
2318 2318       Austria 2020-04-01 21:58:34 47.5162 14.5501 10711 146 1436 9129 Austria
2319 2319       Azerbaijan 2020-04-01 21:58:34 40.1431 47.5769 359 5 26 328 Azerbaijan
2320 2320       Bahamas 2020-04-01 21:58:34 25.025885 -78.035889 21 1 1 19 Bahamas
2321 2321       Bahrain 2020-04-01 21:58:34 26.0275 50.55 569 4 337 228 Bahrain
2322 2322       Bangladesh 2020-04-01 21:58:34 23.685 90.3563 54 6 25 23 Bangladesh
2323 2323       Barbados 2020-04-01 21:58:34 13.1939 -59.5432 34 0 0 34 Barbados
2324 2324       Belarus 2020-04-01 21:58:34 53.7098 27.9534 163 2 53 108 Belarus
2325 2325       Belgium 2020-04-01 21:58:34 50.8333 4.469936 13964 828 2132 11004 Belgium
2326 2326       Belize 2020-04-01 21:58:34 17.1899 -88.4976 3 0 0 3 ,,Belize
2327 2327       Benin 2020-04-01 21:58:34 9.3077 2.3158 13 0 1 12 Benin
2328 2328       Bhutan 2020-04-01 21:58:34 27.5142 90.4336 4 0 0 4 Bhutan
2329 2329       Bolivia 2020-04-01 21:58:34 -16.2902 -63.5887 115 7 1 107 Bolivia
2330 2330       Bosnia and Herzegovina 2020-04-01 21:58:34 43.9159 17.6791 459 13 19 427 Bosnia and Herzegovina
2331 2331       Botswana 2020-04-01 21:58:34 -22.3285 24.6849 4 1 0 3 Botswana
2332 2332       Brazil 2020-04-01 21:58:34 -14.235 -51.9253 6836 240 127 6469 Brazil
2333 2333       Brunei 2020-04-01 21:58:34 4.5353 114.7277 131 1 52 78 Brunei
2334 2334       Bulgaria 2020-04-01 21:58:34 42.7339 25.4858 422 10 20 392 Bulgaria
2335 2335       Burkina Faso 2020-04-01 21:58:34 12.2383 -1.5616 282 16 46 220 Burkina Faso
2336 2336       Burma 2020-04-01 21:58:34 21.9162 95.956 15 1 0 14 Burma
2337 2337       Burundi 2020-04-01 21:58:34 -3.3731 29.9189 2 0 0 2 Burundi
2338 2338       Cabo Verde 2020-04-01 21:58:34 16.5388 -23.0418 6 1 0 5 Cabo Verde
2339 2339       Cambodia 2020-04-01 21:58:34 11.55 104.9167 109 0 25 84 Cambodia
2340 2340       Cameroon 2020-04-01 21:58:34 3.8480000000000003 11.5021 233 6 10 217 Cameroon
2341 2341       Central African Republic 2020-04-01 21:58:34 6.6111 20.9394 3 0 0 3 Central African Republic
2342 2342       Chad 2020-04-01 21:58:34 15.4542 18.7322 7 0 0 7 Chad
2343 2343       Chile 2020-04-01 21:58:34 -35.6751 -71.543 3031 16 234 2781 Chile
2344 2344       Colombia 2020-04-01 21:58:34 4.5709 -74.2973 1065 17 39 1009 Colombia
2345 2345       Congo (Brazzaville) 2020-04-01 21:58:34 -4.2634 15.2832 19 0 0 19 Congo (Brazzaville)
2346 2346       Congo (Kinshasa) 2020-04-01 21:58:34 -4.322447 15.307045 109 9 3 97 Congo (Kinshasa)
2347 2347       Costa Rica 2020-04-01 21:58:34 9.7489 -83.7534 375 2 4 369 Costa Rica
2348 2348       Cote d'Ivoire 2020-04-01 21:58:34 7.54 -5.5471 190 1 9 180 Cote d'Ivoire
2349 2349       Croatia 2020-04-01 21:58:34 45.1 15.2 963 6 73 884 Croatia
2350 2350       Cuba 2020-04-01 21:58:34 21.521757 -77.78116700000002 212 6 12 194 Cuba
2351 2351       Cyprus 2020-04-01 21:58:34 35.1264 33.4299 320 9 28 283 Cyprus
2352 2352       Czechia 2020-04-01 21:58:34 49.8175 15.472999999999999 3508 39 61 3408 Czechia
2353 2353       Denmark 2020-04-01 21:58:34 56.2639 9.5018 3107 104 894 2109 Denmark
2354 2354       Diamond Princess 2020-04-01 21:58:34 0.0 0.0 712 11 603 98 Diamond Princess
2355 2355       Djibouti 2020-04-01 21:58:34 11.8251 42.5903 33 0 0 33 Djibouti
2356 2356       Dominica 2020-04-01 21:58:34 15.415 -61.371 12 0 0 12 Dominica
2357 2357       Dominican Republic 2020-04-01 21:58:34 18.7357 -70.1627 1284 57 9 1218 Dominican Republic
2358 2358       Ecuador 2020-04-01 21:58:34 -1.8312 -78.1834 2748 93 58 2597 Ecuador
2359 2359       Egypt 2020-04-01 21:58:34 26.820553000000004 30.802497999999996 779 52 179 548 Egypt
2360 2360       El Salvador 2020-04-01 21:58:34 13.7942 -88.8965 32 1 0 31 El Salvador
2361 2361       Equatorial Guinea 2020-04-01 21:58:34 1.6508 10.2679 15 0 1 14 Equatorial Guinea
2362 2362       Eritrea 2020-04-01 21:58:34 15.1794 39.7823 15 0 0 15 Eritrea
2363 2363       Estonia 2020-04-01 21:58:34 58.5953 25.0136 779 5 33 741 Estonia
2364 2364       Eswatini 2020-04-01 21:58:34 -26.5225 31.4659 9 0 0 9 Eswatini
2365 2365       Ethiopia 2020-04-01 21:58:34 9.145 40.4897 29 0 2 27 Ethiopia
2366 2366       Fiji 2020-04-01 21:58:34 -17.7134 178.065 5 0 0 5 Fiji
2367 2367       Finland 2020-04-01 21:58:34 61.92411 25.748151 1446 17 10 1419 Finland
2368 2368       France 2020-04-01 21:58:34 46.2276 2.2137 56362 4396 10934 42023 France
2369 2369       Gabon 2020-04-01 21:58:34 -0.8037 11.6094 18 1 0 17 Gabon
2370 2370       Gambia 2020-04-01 21:58:34 13.4432 -15.3101 4 1 2 1 Gambia
2371 2371       Georgia 2020-04-01 21:58:34 42.3154 43.3569 117 0 23 94 Georgia
2372 2372       Germany 2020-04-01 21:58:34 51.165690999999995 10.451526 77872 920 18700 58252 Germany
2373 2373       Ghana 2020-04-01 21:58:34 7.9465 -1.0232 195 5 31 159 Ghana
2374 2374       Greece 2020-04-01 21:58:34 39.0742 21.8243 1415 50 52 1313 Greece
2375 2375       Grenada 2020-04-01 21:58:34 12.1165 -61.678999999999995 9 0 0 9 Grenada
2376 2376       Guatemala 2020-04-01 21:58:34 15.7835 -90.2308 39 1 12 26 Guatemala
2377 2377       Guinea 2020-04-01 21:58:34 9.9456 -9.6966 30 0 0 30 Guinea
2378 2378       Guinea-Bissau 2020-04-01 21:58:34 11.8037 -15.1804 9 0 0 9 Guinea-Bissau
2379 2379       Guyana 2020-04-01 21:58:34 4.860416000000002 -58.93018000000001 19 2 0 17 Guyana
2380 2380       Haiti 2020-04-01 21:58:34 18.9712 -72.2852 15 0 1 15 Haiti
2381 2381       Holy See 2020-04-01 21:58:34 41.9029 12.4534 6 0 0 6 Holy See
2382 2382       Honduras 2020-04-01 21:58:34 15.2 -86.2419 172 10 3 159 Honduras
2383 2383       Hungary 2020-04-01 21:58:34 47.1625 19.5033 525 20 40 465 Hungary
2384 2384       Iceland 2020-04-01 21:58:34 64.9631 -19.0208 1220 2 225 993 Iceland
2385 2385       India 2020-04-01 21:58:34 20.593684 78.96288 1998 58 148 1792 India
2386 2386       Indonesia 2020-04-01 21:58:34 -0.7893 113.9213 1677 157 103 1417 Indonesia
2387 2387       Iran 2020-04-01 21:58:34 32.427908 53.68804599999999 47593 3036 15473 29084 Iran
2388 2388       Iraq 2020-04-01 21:58:34 33.223191 43.679291 728 52 182 494 Iraq
2389 2389       Ireland 2020-04-01 21:58:34 53.1424 -7.6921 3447 85 5 3357 Ireland
2390 2390       Israel 2020-04-01 21:58:34 31.046051000000002 34.851612 6413 29 495 5825 Israel
2391 2391       Italy 2020-04-01 21:58:34 41.87194 12.56738 110574 13155 16847 80572 Italy
2392 2392       Jamaica 2020-04-01 21:58:34 18.1096 -77.2975 44 3 2 39 Jamaica
2393 2393       Japan 2020-04-01 21:58:34 36.204824 138.252924 2178 57 472 1649 Japan
2394 2394       Jordan 2020-04-01 21:58:34 31.24 36.51 278 5 36 237 Jordan
2395 2395       Kazakhstan 2020-04-01 21:58:34 48.0196 66.9237 380 3 26 351 Kazakhstan
2396 2396       Kenya 2020-04-01 21:58:34 -0.0236 37.9062 81 1 3 77 Kenya
2397 2397       Korea, South 2020-04-01 21:58:34 35.90775700000001 127.766922 9887 165 5567 4155 Korea, South
2398 2398       Kosovo 2020-04-01 21:58:34 42.602636 20.902977 125 1 10 114 Kosovo
2399 2399       Kuwait 2020-04-01 21:58:34 29.311659999999996 47.481766 317 0 80 237 Kuwait
2400 2400       Kyrgyzstan 2020-04-01 21:58:34 41.20438 74.766098 111 0 3 108 Kyrgyzstan
2401 2401       Laos 2020-04-01 21:58:34 19.856270000000002 102.495496 10 0 0 10 Laos
2402 2402       Latvia 2020-04-01 21:58:34 56.8796 24.6032 446 0 1 445 Latvia
2403 2403       Lebanon 2020-04-01 21:58:34 33.8547 35.8623 479 14 43 422 Lebanon
2404 2404       Liberia 2020-04-01 21:58:34 6.4280550000000005 -9.429499 6 0 0 6 Liberia
2405 2405       Libya 2020-04-01 21:58:34 26.3351 17.228331 10 0 0 10 Libya
2406 2406       Liechtenstein 2020-04-01 21:58:34 47.14 9.55 68 0 0 68 Liechtenstein
2407 2407       Lithuania 2020-04-01 21:58:34 55.1694 23.8813 512 6 0 566 Lithuania
2408 2408       Luxembourg 2020-04-01 21:58:34 49.8153 6.1296 2319 29 80 2210 Luxembourg
2409 2409       MS Zaandam 2020-04-01 21:58:34 0.0 0.0 9 2 0 7 ,,MS Zaandam

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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