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 rowid 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
2486 2486       Zimbabwe 2020-04-01 21:58:34 -19.015438 29.154857 8 1 0 7 Zimbabwe
2485 2485       Zambia 2020-04-01 21:58:34 -13.133897 27.849332 36 0 0 36 Zambia
2484 2484       West Bank and Gaza 2020-04-01 21:58:34 31.9522 35.2332 134 1 18 115 West Bank and Gaza
2483 2483       Vietnam 2020-04-01 21:58:34 14.058323999999999 108.277199 218 0 63 155 Vietnam
2482 2482       Venezuela 2020-04-01 21:58:34 6.4238 -66.5897 143 3 41 99 Venezuela
2481 2481       Uzbekistan 2020-04-01 21:58:34 41.377491 64.585262 181 2 12 167 Uzbekistan
2480 2480       Uruguay 2020-04-01 21:58:34 -32.5228 -55.7658 338 2 41 295 Uruguay
2479 2479       United Kingdom 2020-04-01 21:58:34 55.3781 -3.4360000000000004 29474 2352 135 26987 United Kingdom
2478 2478       United Arab Emirates 2020-04-01 21:58:34 23.424076 53.847818000000004 814 8 61 745 United Arab Emirates
2477 2477       Ukraine 2020-04-01 21:58:34 48.3794 31.1656 794 20 13 761 Ukraine
2476 2476       Uganda 2020-04-01 21:58:34 1.373333 32.290275 44 0 0 44 Uganda
2475 2475       Turkey 2020-04-01 21:58:34 38.9637 35.2433 15679 277 333 15069 Turkey
2474 2474       Tunisia 2020-04-01 21:58:34 33.886917 9.537499 423 12 5 406 Tunisia
2473 2473       Trinidad and Tobago 2020-04-01 21:58:34 10.6918 -61.2225 90 5 1 84 Trinidad and Tobago
2472 2472       Togo 2020-04-01 21:58:34 8.6195 0.8248 36 2 10 24 Togo
2471 2471       Timor-Leste 2020-04-01 21:58:34 -8.874217 125.727539 1 0 0 1 Timor-Leste
2470 2470       Thailand 2020-04-01 21:58:34 15.870032 100.992541 1771 12 416 1254 Thailand
2469 2469       Tanzania 2020-04-01 21:58:34 -6.369028 34.888822 20 1 1 18 Tanzania
2468 2468       Taiwan* 2020-04-01 10:56:33 23.7 121.0 329 5 39 285 Taiwan*
2467 2467       Syria 2020-04-01 21:58:34 34.802075 38.99681500000001 10 2 0 8 Syria
2466 2466       Switzerland 2020-04-01 21:58:34 46.8182 8.2275 17768 488 2967 14313 Switzerland
2465 2465       Sweden 2020-04-01 21:58:34 60.128161 18.643501 4947 239 103 4605 Sweden
2464 2464       Suriname 2020-04-01 21:58:34 3.9193 -56.0278 10 0 0 10 Suriname
2463 2463       Sudan 2020-04-01 21:58:34 12.8628 30.2176 7 2 2 3 Sudan
2462 2462       Sri Lanka 2020-04-01 21:58:34 7.873054 80.77179699999998 146 3 21 122 Sri Lanka
2461 2461       Spain 2020-04-01 21:58:34 40.463667 -3.7492199999999998 104118 9387 22647 72084 Spain
2460 2460       South Africa 2020-04-01 21:58:34 -30.5595 22.9375 1380 5 50 1325 South Africa
2459 2459       Somalia 2020-04-01 21:58:34 5.152149 46.199616 5 0 1 4 Somalia
2458 2458       Slovenia 2020-04-01 21:58:34 46.1512 14.9955 841 15 10 816 Slovenia
2457 2457       Slovakia 2020-04-01 21:58:34 48.669 19.699 400 1 3 396 Slovakia
2456 2456       Singapore 2020-04-01 21:58:34 1.2833 103.8333 1000 3 245 752 Singapore
2455 2455       Sierra Leone 2020-04-01 21:58:34 8.460555000000001 -11.779889 2 0 0 2 Sierra Leone
2454 2454       Seychelles 2020-04-01 21:58:34 -4.6796 55.492 10 0 0 10 Seychelles
2453 2453       Serbia 2020-04-01 21:58:34 44.0165 21.0059 1060 28 0 1032 Serbia
2452 2452       Senegal 2020-04-01 21:58:34 14.4974 -14.4524 190 1 45 144 Senegal
2451 2451       Saudi Arabia 2020-04-01 21:58:34 23.885942 45.079162 1720 16 264 1440 Saudi Arabia
2450 2450       San Marino 2020-04-01 21:58:34 43.9424 12.4578 236 26 13 197 San Marino
2449 2449       Samoa 2020-04-01 22:04:44 -13.759 -172.1046 0 0 0 0 Samoa
2448 2448       Saint Vincent and the Grenadines 2020-04-01 21:58:34 12.9843 -61.2872 1 0 1 0 Saint Vincent and the Grenadines
2447 2447       Saint Lucia 2020-04-01 21:58:34 13.9094 -60.9789 13 0 1 12 Saint Lucia
2446 2446       Saint Kitts and Nevis 2020-04-01 21:58:34 17.357822 -62.782998 8 0 0 8 Saint Kitts and Nevis
2445 2445       Rwanda 2020-04-01 21:58:34 -1.9403 29.8739 82 0 0 82 Rwanda
2444 2444       Russia 2020-04-01 21:58:34 61.52401 105.31875600000001 2777 24 190 2563 Russia
2443 2443       Romania 2020-04-01 21:58:34 45.9432 24.9668 2460 92 252 2116 Romania
2442 2442       Qatar 2020-04-01 21:58:34 25.3548 51.1839 835 2 71 762 Qatar
2441 2441       Portugal 2020-04-01 21:58:34 39.3999 -8.2245 8251 187 43 8021 Portugal
2440 2440       Poland 2020-04-01 21:58:34 51.9194 19.1451 2554 43 47 2464 Poland
2439 2439       Philippines 2020-04-01 21:58:34 12.879721 121.77401699999999 2311 96 50 2165 Philippines
2438 2438       Peru 2020-04-01 21:58:34 -9.19 -75.0152 1323 38 394 891 Peru
2437 2437       Paraguay 2020-04-01 21:58:34 -23.4425 -58.4438 69 3 1 65 Paraguay
2436 2436       Papua New Guinea 2020-04-01 21:58:34 -6.314993 143.95555 1 0 0 1 Papua New Guinea
2435 2435       Panama 2020-04-01 21:58:34 8.538 -80.7821 1181 30 9 1142 Panama
2434 2434       Pakistan 2020-04-01 21:58:34 30.3753 69.3451 2118 27 94 1997 Pakistan
2433 2433       Oman 2020-04-01 21:58:34 21.512583 55.92325500000001 210 1 34 175 Oman
2432 2432       Norway 2020-04-01 21:58:34 60.472 8.4689 4863 44 13 4806 Norway
2431 2431       North Macedonia 2020-04-01 21:58:34 41.6086 21.7453 354 11 17 326 North Macedonia
2430 2430       Nigeria 2020-04-01 21:58:34 9.082 8.6753 174 2 9 163 Nigeria
2429 2429       Niger 2020-04-01 21:58:34 17.607789 8.081666 74 5 0 69 Niger
2428 2428       Nicaragua 2020-04-01 21:58:34 12.865416 -85.207229 5 1 0 4 Nicaragua
2427 2427       New Zealand 2020-04-01 21:58:34 -40.9006 174.886 708 1 83 624 New Zealand
2426 2426       Netherlands 2020-04-01 21:58:34 52.1326 5.2913 13614 1173 250 12191 Netherlands
2425 2425       Nepal 2020-04-01 21:58:34 28.1667 84.25 5 0 1 4 Nepal
2424 2424       Namibia 2020-04-01 21:58:34 -22.9576 18.4904 14 0 2 12 Namibia
2423 2423       Mozambique 2020-04-01 21:58:34 -18.665695 35.529562 10 0 0 10 Mozambique
2422 2422       Morocco 2020-04-01 21:58:34 31.7917 -7.0926 654 39 29 586 Morocco
2421 2421       Montenegro 2020-04-01 21:58:34 42.708678000000006 19.37439 123 2 0 121 Montenegro
2420 2420       Mongolia 2020-04-01 21:58:34 46.8625 103.8467 14 0 2 12 Mongolia
2419 2419       Monaco 2020-04-01 21:58:34 43.7333 7.4167 55 1 2 52 Monaco
2418 2418       Moldova 2020-04-01 21:58:34 47.4116 28.3699 423 5 23 395 Moldova
2417 2417       Mexico 2020-04-01 21:58:34 23.6345 -102.5528 1215 29 35 1151 Mexico
2416 2416       Mauritius 2020-04-01 21:58:34 -20.348404000000002 57.552152 161 6 0 155 Mauritius
2415 2415       Mauritania 2020-04-01 21:58:34 21.0079 -10.9408 6 1 2 3 ,,Mauritania
2414 2414       Malta 2020-04-01 21:58:34 35.9375 14.3754 188 0 2 186 Malta
2413 2413       Mali 2020-04-01 21:58:34 17.570692 -3.996166000000001 31 3 0 28 Mali
2412 2412       Maldives 2020-04-01 21:58:34 3.2028 73.2207 19 0 13 6 Maldives
2411 2411       Malaysia 2020-04-01 21:58:34 4.210483999999999 101.97576600000001 2908 45 645 2218 Malaysia
2410 2410       Madagascar 2020-04-01 21:58:34 -18.766947000000002 46.869107 57 0 0 57 Madagascar
2409 2409       MS Zaandam 2020-04-01 21:58:34 0.0 0.0 9 2 0 7 ,,MS Zaandam
2408 2408       Luxembourg 2020-04-01 21:58:34 49.8153 6.1296 2319 29 80 2210 Luxembourg
2407 2407       Lithuania 2020-04-01 21:58:34 55.1694 23.8813 512 6 0 566 Lithuania
2406 2406       Liechtenstein 2020-04-01 21:58:34 47.14 9.55 68 0 0 68 Liechtenstein
2405 2405       Libya 2020-04-01 21:58:34 26.3351 17.228331 10 0 0 10 Libya
2404 2404       Liberia 2020-04-01 21:58:34 6.4280550000000005 -9.429499 6 0 0 6 Liberia
2403 2403       Lebanon 2020-04-01 21:58:34 33.8547 35.8623 479 14 43 422 Lebanon
2402 2402       Latvia 2020-04-01 21:58:34 56.8796 24.6032 446 0 1 445 Latvia
2401 2401       Laos 2020-04-01 21:58:34 19.856270000000002 102.495496 10 0 0 10 Laos
2400 2400       Kyrgyzstan 2020-04-01 21:58:34 41.20438 74.766098 111 0 3 108 Kyrgyzstan
2399 2399       Kuwait 2020-04-01 21:58:34 29.311659999999996 47.481766 317 0 80 237 Kuwait
2398 2398       Kosovo 2020-04-01 21:58:34 42.602636 20.902977 125 1 10 114 Kosovo
2397 2397       Korea, South 2020-04-01 21:58:34 35.90775700000001 127.766922 9887 165 5567 4155 Korea, South
2396 2396       Kenya 2020-04-01 21:58:34 -0.0236 37.9062 81 1 3 77 Kenya
2395 2395       Kazakhstan 2020-04-01 21:58:34 48.0196 66.9237 380 3 26 351 Kazakhstan
2394 2394       Jordan 2020-04-01 21:58:34 31.24 36.51 278 5 36 237 Jordan
2393 2393       Japan 2020-04-01 21:58:34 36.204824 138.252924 2178 57 472 1649 Japan
2392 2392       Jamaica 2020-04-01 21:58:34 18.1096 -77.2975 44 3 2 39 Jamaica
2391 2391       Italy 2020-04-01 21:58:34 41.87194 12.56738 110574 13155 16847 80572 Italy
2390 2390       Israel 2020-04-01 21:58:34 31.046051000000002 34.851612 6413 29 495 5825 Israel
2389 2389       Ireland 2020-04-01 21:58:34 53.1424 -7.6921 3447 85 5 3357 Ireland
2388 2388       Iraq 2020-04-01 21:58:34 33.223191 43.679291 728 52 182 494 Iraq
2387 2387       Iran 2020-04-01 21:58:34 32.427908 53.68804599999999 47593 3036 15473 29084 Iran

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
);