04-03-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,627 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
2627 2627   unassigned Wyoming US 2020-04-03 22:46:37     0 0 0 0 unassigned, Wyoming, US
2626 2626       Zimbabwe 2020-04-03 22:46:20 -19.015438 29.154857 9 1 0 8 Zimbabwe
2625 2625       Zambia 2020-04-03 22:46:20 -13.133897 27.849332 39 1 2 36 Zambia
2624 2624       West Bank and Gaza 2020-04-03 22:46:20 31.9522 35.2332 194 1 21 172 West Bank and Gaza
2623 2623       Vietnam 2020-04-03 22:46:20 14.058323999999999 108.277199 237 0 85 152 Vietnam
2622 2622       Venezuela 2020-04-03 22:46:20 6.4238 -66.5897 153 7 52 94 Venezuela
2621 2621       Uzbekistan 2020-04-03 22:46:20 41.377491 64.585262 227 2 25 200 Uzbekistan
2620 2620       Uruguay 2020-04-03 22:46:20 -32.5228 -55.7658 369 4 68 297 Uruguay
2619 2619       United Kingdom 2020-04-03 22:46:20 55.3781 -3.4360000000000004 38168 3605 135 34428 United Kingdom
2618 2618       United Arab Emirates 2020-04-03 22:46:20 23.424076 53.847818000000004 1264 9 108 1147 United Arab Emirates
2617 2617       Ukraine 2020-04-03 22:46:20 48.3794 31.1656 1072 27 22 1023 Ukraine
2616 2616       Uganda 2020-04-03 22:46:20 1.373333 32.290275 48 0 0 48 Uganda
2615 2615       Turkey 2020-04-03 22:46:20 38.9637 35.2433 20921 425 484 20012 Turkey
2614 2614       Tunisia 2020-04-03 22:46:20 33.886917 9.537499 495 18 5 472 Tunisia
2613 2613       Trinidad and Tobago 2020-04-03 22:46:20 10.6918 -61.2225 98 6 1 91 Trinidad and Tobago
2612 2612       Togo 2020-04-03 22:46:20 8.6195 0.8248 40 3 17 20 Togo
2611 2611       Timor-Leste 2020-04-03 22:46:20 -8.874217 125.727539 1 0 0 1 Timor-Leste
2610 2610       Thailand 2020-04-03 22:46:20 15.870032 100.992541 1978 19 581 1347 Thailand
2609 2609       Tanzania 2020-04-03 22:46:20 -6.369028 34.888822 20 1 3 16 Tanzania
2608 2608       Taiwan* 2020-04-03 08:10:40 23.7 121.0 348 5 50 293 Taiwan*
2607 2607       Syria 2020-04-03 22:46:20 34.802075 38.99681500000001 16 2 0 14 Syria
2606 2606       Switzerland 2020-04-03 22:46:20 46.8182 8.2275 19606 591 4846 14169 Switzerland
2605 2605       Sweden 2020-04-03 22:46:20 60.128161 18.643501 6131 358 205 5568 Sweden
2604 2604       Suriname 2020-04-03 22:46:20 3.9193 -56.0278 10 1 0 9 Suriname
2603 2603       Sudan 2020-04-03 22:46:20 12.8628 30.2176 10 2 2 6 Sudan
2602 2602       Sri Lanka 2020-04-03 22:46:20 7.873054 80.77179699999998 159 4 24 131 Sri Lanka
2601 2601       Spain 2020-04-03 22:46:20 40.463667 -3.7492199999999998 119199 11198 30513 77488 Spain
2600 2600       South Africa 2020-04-03 22:46:20 -30.5595 22.9375 1505 9 95 1401 South Africa
2599 2599       Somalia 2020-04-03 22:46:20 5.152149 46.199616 7 0 1 6 Somalia
2598 2598       Slovenia 2020-04-03 22:46:20 46.1512 14.9955 934 20 70 844 Slovenia
2597 2597       Slovakia 2020-04-03 22:46:20 48.669 19.699 450 1 10 439 Slovakia
2596 2596       Singapore 2020-04-03 22:46:20 1.2833 103.8333 1114 5 282 827 Singapore
2595 2595       Sierra Leone 2020-04-03 22:46:20 8.460555000000001 -11.779889 2 0 0 2 Sierra Leone
2594 2594       Seychelles 2020-04-03 22:46:20 -4.6796 55.492 10 0 0 10 Seychelles
2593 2593       Serbia 2020-04-03 22:46:20 44.0165 21.0059 1476 39 0 1437 Serbia
2592 2592       Senegal 2020-04-03 22:46:20 14.4974 -14.4524 207 1 66 140 Senegal
2591 2591       Saudi Arabia 2020-04-03 22:46:20 23.885942 45.079162 2039 25 351 1663 Saudi Arabia
2590 2590       San Marino 2020-04-03 22:46:20 43.9424 12.4578 245 30 21 194 San Marino
2589 2589       Samoa 2020-04-03 22:52:30 -13.759 -172.1046 0 0 0 0 Samoa
2588 2588       Saint Vincent and the Grenadines 2020-04-03 22:46:20 12.9843 -61.2872 3 0 1 2 Saint Vincent and the Grenadines
2587 2587       Saint Lucia 2020-04-03 22:46:20 13.9094 -60.9789 13 0 1 12 Saint Lucia
2586 2586       Saint Kitts and Nevis 2020-04-03 22:46:20 17.357822 -62.782998 9 0 0 9 Saint Kitts and Nevis
2585 2585       Rwanda 2020-04-03 22:46:20 -1.9403 29.8739 89 0 0 89 Rwanda
2584 2584       Russia 2020-04-03 22:46:20 61.52401 105.31875600000001 4149 34 281 3834 Russia
2583 2583       Romania 2020-04-03 22:46:20 45.9432 24.9668 3183 133 283 2767 Romania
2582 2582       Qatar 2020-04-03 22:46:20 25.3548 51.1839 1075 3 93 979 Qatar
2581 2581       Portugal 2020-04-03 22:46:20 39.3999 -8.2245 9886 246 68 9572 Portugal
2580 2580       Poland 2020-04-03 22:46:20 51.9194 19.1451 3383 71 56 3256 Poland
2579 2579       Philippines 2020-04-03 22:46:20 12.879721 121.77401699999999 3018 136 52 2830 Philippines
2578 2578       Peru 2020-04-03 22:46:20 -9.19 -75.0152 1595 61 537 997 Peru
2577 2577       Paraguay 2020-04-03 22:46:20 -23.4425 -58.4438 92 3 6 83 Paraguay
2576 2576       Papua New Guinea 2020-04-03 22:46:20 -6.314993 143.95555 1 0 0 1 Papua New Guinea
2575 2575       Panama 2020-04-03 22:46:20 8.538 -80.7821 1475 37 10 1428 Panama
2574 2574       Pakistan 2020-04-03 22:46:20 30.3753 69.3451 2686 40 126 2520 Pakistan
2573 2573       Oman 2020-04-03 22:46:20 21.512583 55.92325500000001 252 1 57 194 Oman
2572 2572       Norway 2020-04-03 22:46:20 60.472 8.4689 5370 59 32 5279 Norway
2571 2571       North Macedonia 2020-04-03 22:46:20 41.6086 21.7453 430 12 20 398 North Macedonia
2570 2570       Nigeria 2020-04-03 22:46:20 9.082 8.6753 210 4 25 181 Nigeria
2569 2569       Niger 2020-04-03 22:46:20 17.607789 8.081666 120 5 0 115 Niger
2568 2568       Nicaragua 2020-04-03 22:46:20 12.865416 -85.207229 5 1 0 4 Nicaragua
2567 2567       New Zealand 2020-04-03 22:46:20 -40.9006 174.886 868 1 103 764 New Zealand
2566 2566       Netherlands 2020-04-03 22:46:20 52.1326 5.2913 15723 1487 250 13986 Netherlands
2565 2565       Nepal 2020-04-03 22:46:20 28.1667 84.25 6 0 1 5 Nepal
2564 2564       Namibia 2020-04-03 22:46:20 -22.9576 18.4904 14 0 3 11 Namibia
2563 2563       Mozambique 2020-04-03 22:46:20 -18.665695 35.529562 10 0 0 10 Mozambique
2562 2562       Morocco 2020-04-03 22:46:20 31.7917 -7.0926 791 48 57 686 Morocco
2561 2561       Montenegro 2020-04-03 22:46:20 42.708678000000006 19.37439 174 2 1 171 Montenegro
2560 2560       Mongolia 2020-04-03 22:46:20 46.8625 103.8467 14 0 2 12 Mongolia
2559 2559       Monaco 2020-04-03 22:46:20 43.7333 7.4167 64 1 3 60 Monaco
2558 2558       Moldova 2020-04-03 22:46:20 47.4116 28.3699 591 8 26 557 Moldova
2557 2557       Mexico 2020-04-03 22:46:20 23.6345 -102.5528 1510 50 633 827 Mexico
2556 2556       Mauritius 2020-04-03 22:46:20 -20.348404000000002 57.552152 186 7 0 179 Mauritius
2555 2555       Mauritania 2020-04-03 22:46:20 21.0079 -10.9408 6 1 2 3 ,,Mauritania
2554 2554       Malta 2020-04-03 22:46:20 35.9375 14.3754 202 0 2 200 Malta
2553 2553       Mali 2020-04-03 22:46:20 17.570692 -3.996166000000001 39 3 0 36 Mali
2552 2552       Maldives 2020-04-03 22:46:20 3.2028 73.2207 19 0 13 6 Maldives
2551 2551       Malaysia 2020-04-03 22:46:20 4.210483999999999 101.97576600000001 3333 53 827 2453 Malaysia
2550 2550       Malawi 2020-04-03 22:46:20 -13.254307999999998 34.301525 3 0 0 3 Malawi
2549 2549       Madagascar 2020-04-03 22:46:20 -18.766947000000002 46.869107 70 0 0 70 Madagascar
2548 2548       MS Zaandam 2020-04-03 22:46:20     9 2 0 7 ,,MS Zaandam
2547 2547       Luxembourg 2020-04-03 22:46:20 49.8153 6.1296 2612 31 500 2081 Luxembourg
2546 2546       Lithuania 2020-04-03 22:46:20 55.1694 23.8813 631 6 0 680 Lithuania
2545 2545       Liechtenstein 2020-04-03 22:46:20 47.14 9.55 75 0 0 75 Liechtenstein
2544 2544       Libya 2020-04-03 22:46:20 26.3351 17.228331 11 1 0 10 Libya
2543 2543       Liberia 2020-04-03 22:46:20 6.4280550000000005 -9.429499 7 0 0 7 Liberia
2542 2542       Lebanon 2020-04-03 22:46:20 33.8547 35.8623 508 17 50 441 Lebanon
2541 2541       Latvia 2020-04-03 22:46:20 56.8796 24.6032 493 1 1 491 Latvia
2540 2540       Laos 2020-04-03 22:46:20 19.856270000000002 102.495496 10 0 0 10 Laos
2539 2539       Kyrgyzstan 2020-04-03 22:46:20 41.20438 74.766098 130 1 6 123 Kyrgyzstan
2538 2538       Kuwait 2020-04-03 22:46:20 29.311659999999996 47.481766 417 0 82 335 Kuwait
2537 2537       Kosovo 2020-04-03 22:46:20 42.602636 20.902977 126 1 10 115 Kosovo
2536 2536       Korea, South 2020-04-03 22:46:20 35.90775700000001 127.766922 10062 174 6021 3867 Korea, South
2535 2535       Kenya 2020-04-03 22:46:20 -0.0236 37.9062 122 4 4 114 Kenya
2534 2534       Kazakhstan 2020-04-03 22:46:20 48.0196 66.9237 464 6 29 429 Kazakhstan
2533 2533       Jordan 2020-04-03 22:46:20 31.24 36.51 310 5 58 247 Jordan
2532 2532       Japan 2020-04-03 22:46:20 36.204824 138.252924 2617 63 514 2040 Japan
2531 2531       Jamaica 2020-04-03 22:46:20 18.1096 -77.2975 47 3 2 42 Jamaica
2530 2530       Italy 2020-04-03 22:46:20 41.87194 12.56738 119827 14681 19758 85388 Italy
2529 2529       Israel 2020-04-03 22:46:20 31.046051000000002 34.851612 7729 43 667 6985 Israel
2528 2528       Ireland 2020-04-03 22:46:20 53.1424 -7.6921 4273 120 5 4148 Ireland

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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