04-02-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,572 rows sorted by rowid 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
2572 2572   unassigned Wyoming US 4/2/20 23:25     0 0 0 0 unassigned, Wyoming, US
2571 2571       Zimbabwe 4/2/20 23:25 -19.015438 29.154857 9 1 0 8 Zimbabwe
2570 2570       Zambia 4/2/20 23:25 -13.133897 27.849332 39 1 0 38 Zambia
2569 2569       West Bank and Gaza 4/2/20 23:25 31.9522 35.2332 161 1 18 142 West Bank and Gaza
2568 2568       Vietnam 4/2/20 23:25 14.058324 108.277199 233 0 75 158 Vietnam
2567 2567       Venezuela 4/2/20 23:25 6.4238 -66.5897 146 5 43 98 Venezuela
2566 2566       Uzbekistan 4/2/20 23:25 41.377491 64.585262 205 2 25 178 Uzbekistan
2565 2565       Uruguay 4/2/20 23:25 -32.5228 -55.7658 350 4 62 284 Uruguay
2564 2564       United Kingdom 4/2/20 23:25 55.3781 -3.436 33718 2921 135 30662 United Kingdom
2563 2563       United Arab Emirates 4/2/20 23:25 23.424076 53.847818 1024 8 96 920 United Arab Emirates
2562 2562       Ukraine 4/2/20 23:25 48.3794 31.1656 897 22 19 856 Ukraine
2561 2561       Uganda 4/2/20 23:25 1.373333 32.290275 45 0 0 45 Uganda
2560 2560       Turkey 4/2/20 23:25 38.9637 35.2433 18135 356 415 17364 Turkey
2559 2559       Tunisia 4/2/20 23:25 33.886917 9.537499 455 14 5 436 Tunisia
2558 2558       Trinidad and Tobago 4/2/20 23:25 10.6918 -61.2225 94 5 1 88 Trinidad and Tobago
2557 2557       Togo 4/2/20 23:25 8.6195 0.8248 39 2 17 20 Togo
2556 2556       Timor-Leste 4/2/20 23:25 -8.874217 125.727539 1 0 0 1 Timor-Leste
2555 2555       Thailand 4/2/20 23:25 15.870032 100.992541 1875 15 505 1355 Thailand
2554 2554       Tanzania 4/2/20 23:25 -6.369028 34.888822 20 1 2 17 Tanzania
2553 2553       Taiwan* 4/2/20 11:09 23.7 121.0 339 5 45 289 Taiwan*
2552 2552       Syria 4/2/20 23:25 34.802075 38.996815 16 2 0 14 Syria
2551 2551       Switzerland 4/2/20 23:25 46.8182 8.2275 18827 536 4013 14278 Switzerland
2550 2550       Sweden 4/2/20 23:25 60.128161 18.643501 5568 308 103 5157 Sweden
2549 2549       Suriname 4/2/20 23:25 3.9193 -56.0278 10 0 0 10 Suriname
2548 2548       Sudan 4/2/20 23:25 12.8628 30.2176 7 2 2 4 Sudan
2547 2547       Sri Lanka 4/2/20 23:25 7.873054 80.771797 151 4 21 126 Sri Lanka
2546 2546       Spain 4/2/20 23:25 40.463667 -3.74922 112065 10348 26743 74974 Spain
2545 2545       South Africa 4/2/20 23:25 -30.5595 22.9375 1462 5 50 1407 South Africa
2544 2544       Somalia 4/2/20 23:25 5.152149 46.199616 5 0 1 4 Somalia
2543 2543       Slovenia 4/2/20 23:25 46.1512 14.9955 897 17 70 810 Slovenia
2542 2542       Slovakia 4/2/20 23:25 48.669 19.699 426 1 5 420 Slovakia
2541 2541       Singapore 4/2/20 23:25 1.2833 103.8333 1049 4 266 779 Singapore
2540 2540       Sierra Leone 4/2/20 23:25 8.460555 -11.779889 2 0 0 2 Sierra Leone
2539 2539       Seychelles 4/2/20 23:25 -4.6796 55.492 10 0 0 10 Seychelles
2538 2538       Serbia 4/2/20 23:25 44.0165 21.0059 1171 31 0 1140 Serbia
2537 2537       Senegal 4/2/20 23:25 14.4974 -14.4524 195 1 55 139 Senegal
2536 2536       Saudi Arabia 4/2/20 23:25 23.885942 45.079162 1885 21 328 1536 Saudi Arabia
2535 2535       San Marino 4/2/20 23:25 43.9424 12.4578 245 30 21 194 San Marino
2534 2534       Samoa 4/2/20 23:31 -13.759 -172.1046 0 0 0 0 Samoa
2533 2533       Saint Vincent and the Grenadines 4/2/20 23:25 12.9843 -61.2872 2 0 1 1 Saint Vincent and the Grenadines
2532 2532       Saint Lucia 4/2/20 23:25 13.9094 -60.9789 13 0 1 12 Saint Lucia
2531 2531       Saint Kitts and Nevis 4/2/20 23:25 17.357822 -62.782998 9 0 0 9 Saint Kitts and Nevis
2530 2530       Rwanda 4/2/20 23:25 -1.9403 29.8739 84 0 0 84 Rwanda
2529 2529       Russia 4/2/20 23:25 61.52401 105.318756 3548 30 235 3283 Russia
2528 2528       Romania 4/2/20 23:25 45.9432 24.9668 2738 115 267 2356 Romania
2527 2527       Qatar 4/2/20 23:25 25.3548 51.1839 949 3 72 874 Qatar
2526 2526       Portugal 4/2/20 23:25 39.3999 -8.2245 9034 209 68 8757 Portugal
2525 2525       Poland 4/2/20 23:25 51.9194 19.1451 2946 57 56 2833 Poland
2524 2524       Philippines 4/2/20 23:25 12.879721 121.774017 2633 107 51 2475 Philippines
2523 2523       Peru 4/2/20 23:25 -9.19 -75.0152 1414 55 537 822 Peru
2522 2522       Paraguay 4/2/20 23:25 -23.4425 -58.4438 77 3 2 72 Paraguay
2521 2521       Papua New Guinea 4/2/20 23:25 -6.314993 143.95555 1 0 0 1 Papua New Guinea
2520 2520       Panama 4/2/20 23:25 8.538 -80.7821 1317 32 9 1276 Panama
2519 2519       Pakistan 4/2/20 23:25 30.3753 69.3451 2421 34 125 2262 Pakistan
2518 2518       Oman 4/2/20 23:25 21.512583 55.923255 231 1 57 173 Oman
2517 2517       Norway 4/2/20 23:25 60.472 8.4689 5147 50 32 5065 Norway
2516 2516       North Macedonia 4/2/20 23:25 41.6086 21.7453 384 11 17 356 North Macedonia
2515 2515       Nigeria 4/2/20 23:25 9.082 8.6753 184 2 20 162 Nigeria
2514 2514       Niger 4/2/20 23:25 17.607789 8.081666 98 5 0 93 Niger
2513 2513       Nicaragua 4/2/20 23:25 12.865416 -85.207229 5 1 0 4 Nicaragua
2512 2512       New Zealand 4/2/20 23:25 -40.9006 174.886 797 1 92 704 New Zealand
2511 2511       Netherlands 4/2/20 23:25 52.1326 5.2913 14697 1339 250 13108 Netherlands
2510 2510       Nepal 4/2/20 23:25 28.1667 84.25 6 0 1 5 Nepal
2509 2509       Namibia 4/2/20 23:25 -22.9576 18.4904 14 0 3 11 Namibia
2508 2508       Mozambique 4/2/20 23:25 -18.665695 35.529562 10 0 0 10 Mozambique
2507 2507       Morocco 4/2/20 23:25 31.7917 -7.0926 708 44 31 633 Morocco
2506 2506       Montenegro 4/2/20 23:25 42.708678 19.37439 144 2 0 142 Montenegro
2505 2505       Mongolia 4/2/20 23:25 46.8625 103.8467 14 0 2 12 Mongolia
2504 2504       Monaco 4/2/20 23:25 43.7333 7.4167 60 1 2 57 Monaco
2503 2503       Moldova 4/2/20 23:25 47.4116 28.3699 505 6 23 476 Moldova
2502 2502       Mexico 4/2/20 23:25 23.6345 -102.5528 1378 37 35 1306 Mexico
2501 2501       Mauritius 4/2/20 23:25 -20.348404 57.552152 169 7 0 162 Mauritius
2500 2500       Mauritania 4/2/20 23:25 21.0079 -10.9408 6 1 2 3 ,,Mauritania
2499 2499       Malta 4/2/20 23:25 35.9375 14.3754 196 0 2 194 Malta
2498 2498       Mali 4/2/20 23:25 17.570692 -3.996166 36 3 0 33 Mali
2497 2497       Maldives 4/2/20 23:25 3.2028 73.2207 19 0 13 6 Maldives
2496 2496       Malaysia 4/2/20 23:25 4.210484 101.975766 3116 50 767 2299 Malaysia
2495 2495       Malawi 4/2/20 23:25 -13.254308 34.301525 3 0 0 3 Malawi
2494 2494       Madagascar 4/2/20 23:25 -18.766947 46.869107 59 0 0 59 Madagascar
2493 2493       MS Zaandam 4/2/20 23:25     9 2 0 7 ,,MS Zaandam
2492 2492       Luxembourg 4/2/20 23:25 49.8153 6.1296 2487 30 80 2377 Luxembourg
2491 2491       Lithuania 4/2/20 23:25 55.1694 23.8813 579 6 0 633 Lithuania
2490 2490       Liechtenstein 4/2/20 23:25 47.14 9.55 75 0 0 75 Liechtenstein
2489 2489       Libya 4/2/20 23:25 26.3351 17.228331 11 1 0 10 Libya
2488 2488       Liberia 4/2/20 23:25 6.428055 -9.429499 6 0 0 6 Liberia
2487 2487       Lebanon 4/2/20 23:25 33.8547 35.8623 494 16 46 432 Lebanon
2486 2486       Latvia 4/2/20 23:25 56.8796 24.6032 458 0 31 427 Latvia
2485 2485       Laos 4/2/20 23:25 19.85627 102.495496 10 0 0 10 Laos
2484 2484       Kyrgyzstan 4/2/20 23:25 41.20438 74.766098 116 0 5 111 Kyrgyzstan
2483 2483       Kuwait 4/2/20 23:25 29.31166 47.481766 342 0 81 261 Kuwait
2482 2482       Kosovo 4/2/20 23:25 42.602636 20.902977 125 1 10 114 Kosovo
2481 2481       Korea, South 4/2/20 23:25 35.907757 127.766922 9976 169 5828 3979 Korea, South
2480 2480       Kenya 4/2/20 23:25 -0.0236 37.9062 110 3 4 103 Kenya
2479 2479       Kazakhstan 4/2/20 23:25 48.0196 66.9237 435 3 27 405 Kazakhstan
2478 2478       Jordan 4/2/20 23:25 31.24 36.51 299 5 45 249 Jordan
2477 2477       Japan 4/2/20 23:25 36.204824 138.252924 2495 62 472 1961 Japan
2476 2476       Jamaica 4/2/20 23:25 18.1096 -77.2975 47 3 2 42 Jamaica
2475 2475       Italy 4/2/20 23:25 41.87194 12.56738 115242 13915 18278 83049 Italy
2474 2474       Israel 4/2/20 23:25 31.046051 34.851612 7132 38 597 6483 Israel
2473 2473       Ireland 4/2/20 23:25 53.1424 -7.6921 3849 98 5 3746 Ireland

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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