04-09-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,912 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
2912 2912       Zimbabwe 2020-04-09 23:02:19 -19.015438 29.154857 11 3 0 8 Zimbabwe
2911 2911       Zambia 2020-04-09 23:02:19 -13.133897 27.849332 39 1 24 14 Zambia
2910 2910       West Bank and Gaza 2020-04-09 23:02:19 31.9522 35.2332 263 1 44 218 West Bank and Gaza
2909 2909       Vietnam 2020-04-09 23:02:19 14.058323999999999 108.277199 255 0 128 127 Vietnam
2908 2908       Venezuela 2020-04-09 23:02:19 6.4238 -66.5897 171 9 84 78 Venezuela
2907 2907       Uzbekistan 2020-04-09 23:02:19 41.377491 64.585262 582 3 38 541 Uzbekistan
2906 2906       Uruguay 2020-04-09 23:02:19 -32.5228 -55.7658 456 7 192 257 Uruguay
2905 2905       United Kingdom 2020-04-09 23:02:19 55.3781 -3.4360000000000004 65077 7978 135 56964 United Kingdom
2904 2904       United Arab Emirates 2020-04-09 23:02:19 23.424076 53.847818000000004 2990 14 268 2708 United Arab Emirates
2903 2903       Ukraine 2020-04-09 23:02:19 48.3794 31.1656 1892 57 45 1790 Ukraine
2902 2902       Uganda 2020-04-09 23:02:19 1.373333 32.290275 53 0 0 53 Uganda
2901 2901       Turkey 2020-04-09 23:02:19 38.9637 35.2433 42282 908 2142 39232 Turkey
2900 2900       Tunisia 2020-04-09 23:02:19 33.886917 9.537499 643 25 25 593 Tunisia
2899 2899       Trinidad and Tobago 2020-04-09 23:02:19 10.6918 -61.2225 109 8 1 100 Trinidad and Tobago
2898 2898       Togo 2020-04-09 23:02:19 8.6195 0.8248 73 3 24 46 Togo
2897 2897       Timor-Leste 2020-04-09 23:02:19 -8.874217 125.727539 1 0 0 1 Timor-Leste
2896 2896       Thailand 2020-04-09 23:02:19 15.870032 100.992541 2423 32 940 1451 Thailand
2895 2895       Tanzania 2020-04-09 23:02:19 -6.369028 34.888822 25 1 5 19 Tanzania
2894 2894       Taiwan* 2020-04-09 08:07:47 23.7 121.0 380 5 67 308 Taiwan*
2893 2893       Syria 2020-04-09 23:02:19 34.802075 38.99681500000001 19 2 4 13 Syria
2892 2892       Switzerland 2020-04-09 23:02:19 46.8182 8.2275 24051 948 10600 12503 Switzerland
2891 2891       Sweden 2020-04-09 23:02:19 60.128161 18.643501 9141 793 205 8143 Sweden
2890 2890       Suriname 2020-04-09 23:02:19 3.9193 -56.0278 10 1 4 5 Suriname
2889 2889       Sudan 2020-04-09 23:02:19 12.8628 30.2176 14 2 2 11 Sudan
2888 2888       Sri Lanka 2020-04-09 23:02:19 7.873054 80.77179699999998 190 7 49 134 Sri Lanka
2887 2887       Spain 2020-04-09 23:02:19 40.463667 -3.7492199999999998 153222 15447 52165 85610 Spain
2886 2886       South Sudan 2020-04-09 23:02:19 6.8770000000000024 31.307 3 0 0 3 South Sudan
2885 2885       South Africa 2020-04-09 23:02:19 -30.5595 22.9375 1934 18 95 1821 South Africa
2884 2884       Somalia 2020-04-09 23:02:19 5.152149 46.199616 12 1 1 10 Somalia
2883 2883       Slovenia 2020-04-09 23:02:19 46.1512 14.9955 1124 43 128 953 Slovenia
2882 2882       Slovakia 2020-04-09 23:02:19 48.669 19.699 701 2 23 676 Slovakia
2881 2881       Singapore 2020-04-09 23:02:19 1.2833 103.8333 1910 6 460 1444 Singapore
2880 2880       Sierra Leone 2020-04-09 23:02:19 8.460555000000001 -11.779889 7 0 0 7 Sierra Leone
2879 2879       Seychelles 2020-04-09 23:02:19 -4.6796 55.492 11 0 0 11 Seychelles
2878 2878       Serbia 2020-04-09 23:02:19 44.0165 21.0059 2867 66 0 2801 Serbia
2877 2877       Senegal 2020-04-09 23:02:19 14.4974 -14.4524 250 2 123 125 Senegal
2876 2876       Saudi Arabia 2020-04-09 23:02:19 23.885942 45.079162 3287 44 666 2577 Saudi Arabia
2875 2875       Sao Tome and Principe 2020-04-09 23:02:19 0.18636 6.613081 4 0 0 4 Sao Tome and Principe
2874 2874       San Marino 2020-04-09 23:02:19 43.9424 12.4578 333 34 49 250 San Marino
2873 2873       Samoa 2020-04-09 23:09:01 -13.759 -172.1046 0 0 0 0 Samoa
2872 2872       Saint Vincent and the Grenadines 2020-04-09 23:02:19 12.9843 -61.2872 12 0 1 11 Saint Vincent and the Grenadines
2871 2871       Saint Lucia 2020-04-09 23:02:19 13.9094 -60.9789 14 0 1 13 Saint Lucia
2870 2870       Saint Kitts and Nevis 2020-04-09 23:02:19 17.357822 -62.782998 11 0 0 11 Saint Kitts and Nevis
2869 2869       Rwanda 2020-04-09 23:02:19 -1.9403 29.8739 110 0 7 103 Rwanda
2868 2868       Russia 2020-04-09 23:02:19 61.52401 105.31875600000001 10131 76 698 9357 Russia
2867 2867       Romania 2020-04-09 23:02:19 45.9432 24.9668 5202 248 647 4307 Romania
2866 2866       Qatar 2020-04-09 23:02:19 25.3548 51.1839 2376 6 206 2164 Qatar
2865 2865       Portugal 2020-04-09 23:02:19 39.3999 -8.2245 13956 409 205 13342 Portugal
2864 2864       Poland 2020-04-09 23:02:19 51.9194 19.1451 5575 174 284 5117 Poland
2863 2863       Philippines 2020-04-09 23:02:19 12.879721 121.77401699999999 4076 203 124 3749 Philippines
2862 2862       Peru 2020-04-09 23:02:19 -9.19 -75.0152 5256 138 1438 3680 Peru
2861 2861       Paraguay 2020-04-09 23:02:19 -23.4425 -58.4438 124 5 18 101 Paraguay
2860 2860       Papua New Guinea 2020-04-09 23:02:19 -6.314993 143.95555 2 0 0 2 Papua New Guinea
2859 2859       Panama 2020-04-09 23:02:19 8.538 -80.7821 2528 63 16 2449 Panama
2858 2858       Pakistan 2020-04-09 23:02:19 30.3753 69.3451 4489 65 572 3852 Pakistan
2857 2857       Oman 2020-04-09 23:02:19 21.512583 55.92325500000001 457 3 109 345 Oman
2856 2856       Norway 2020-04-09 23:02:19 60.472 8.4689 6211 108 32 6071 Norway
2855 2855       North Macedonia 2020-04-09 23:02:19 41.6086 21.7453 663 30 37 596 North Macedonia
2854 2854       Nigeria 2020-04-09 23:02:19 9.082 8.6753 288 7 51 230 Nigeria
2853 2853       Niger 2020-04-09 23:02:19 17.607789 8.081666 410 11 40 359 Niger
2852 2852       Nicaragua 2020-04-09 23:02:19 12.865416 -85.207229 7 1 0 6 Nicaragua
2851 2851       New Zealand 2020-04-09 23:02:19 -40.9006 174.886 1239 1 317 921 New Zealand
2850 2850       Netherlands 2020-04-09 23:02:19 52.1326 5.2913 21762 2396 250 19116 Netherlands
2849 2849       Nepal 2020-04-09 23:02:19 28.1667 84.25 9 0 1 8 Nepal
2848 2848       Namibia 2020-04-09 23:02:19 -22.9576 18.4904 16 0 3 13 Namibia
2847 2847       Mozambique 2020-04-09 23:02:19 -18.665695 35.529562 17 0 1 16 Mozambique
2846 2846       Morocco 2020-04-09 23:02:19 31.7917 -7.0926 1374 97 109 1168 Morocco
2845 2845       Montenegro 2020-04-09 23:02:19 42.708678000000006 19.37439 252 2 4 246 Montenegro
2844 2844       Mongolia 2020-04-09 23:02:19 46.8625 103.8467 16 0 4 12 Mongolia
2843 2843       Monaco 2020-04-09 23:02:19 43.7333 7.4167 84 1 5 78 Monaco
2842 2842       Moldova 2020-04-09 23:02:19 47.4116 28.3699 1289 29 50 1210 Moldova
2841 2841       Mexico 2020-04-09 23:02:19 23.6345 -102.5528 3181 174 633 2374 Mexico
2840 2840       Mauritius 2020-04-09 23:02:19 -20.348404000000002 57.552152 314 7 23 284 Mauritius
2839 2839       Mauritania 2020-04-09 23:02:19 21.0079 -10.9408 7 1 2 4 ,,Mauritania
2838 2838       Malta 2020-04-09 23:02:19 35.9375 14.3754 337 2 16 319 Malta
2837 2837       Mali 2020-04-09 23:02:19 17.570692 -3.996166000000001 74 7 22 45 Mali
2836 2836       Maldives 2020-04-09 23:02:19 3.2028 73.2207 19 0 13 6 Maldives
2835 2835       Malaysia 2020-04-09 23:02:19 4.210483999999999 101.97576600000001 4228 67 1608 2553 Malaysia
2834 2834       Malawi 2020-04-09 23:02:19 -13.254307999999998 34.301525 8 1 0 7 Malawi
2833 2833       Madagascar 2020-04-09 23:02:19 -18.766947000000002 46.869107 93 0 11 82 Madagascar
2832 2832       MS Zaandam 2020-04-09 23:02:19     9 2 0 7 ,,MS Zaandam
2831 2831       Luxembourg 2020-04-09 23:02:19 49.8153 6.1296 3115 52 500 2563 Luxembourg
2830 2830       Lithuania 2020-04-09 23:02:19 55.1694 23.8813 858 11 2 931 Lithuania
2829 2829       Liechtenstein 2020-04-09 23:02:19 47.14 9.55 78 1 55 22 Liechtenstein
2828 2828       Libya 2020-04-09 23:02:19 26.3351 17.228331 24 1 8 15 Libya
2827 2827       Liberia 2020-04-09 23:02:19 6.4280550000000005 -9.429499 31 4 3 24 Liberia
2826 2826       Lebanon 2020-04-09 23:02:19 33.8547 35.8623 582 19 67 496 Lebanon
2825 2825       Latvia 2020-04-09 23:02:19 56.8796 24.6032 589 3 16 570 Latvia
2824 2824       Laos 2020-04-09 23:02:19 19.856270000000002 102.495496 16 0 0 16 Laos
2823 2823       Kyrgyzstan 2020-04-09 23:02:19 41.20438 74.766098 280 4 35 241 Kyrgyzstan
2822 2822       Kuwait 2020-04-09 23:02:19 29.311659999999996 47.481766 910 1 111 798 Kuwait
2821 2821       Kosovo 2020-04-09 23:02:19 42.602636 20.902977 184 5 30 149 Kosovo
2820 2820       Korea, South 2020-04-09 23:02:19 35.90775700000001 127.766922 10423 204 6973 3246 Korea, South
2819 2819       Kenya 2020-04-09 23:02:19 -0.0236 37.9062 184 7 12 165 Kenya
2818 2818       Kazakhstan 2020-04-09 23:02:19 48.0196 66.9237 781 8 60 713 Kazakhstan
2817 2817       Jordan 2020-04-09 23:02:19 31.24 36.51 372 7 161 204 Jordan
2816 2816       Japan 2020-04-09 23:02:19 36.204824 138.252924 4667 94 632 3941 Japan
2815 2815       Jamaica 2020-04-09 23:02:19 18.1096 -77.2975 63 4 12 47 Jamaica
2814 2814       Italy 2020-04-09 23:02:19 41.87194 12.56738 143626 18279 28470 96877 Italy
2813 2813       Israel 2020-04-09 23:02:19 31.046051000000002 34.851612 10249 89 1306 8871 Israel

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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