04-12-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,990 rows sorted by rowid descending

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: Last_Update, Last_Update (date)

Link rowid ▲ FIPS Admin2 Province_State Country_Region Last_Update Lat Long_ Confirmed Deaths Recovered Active Combined_Key
2990 2990   unassigned Utah US 2020-04-12 23:18:00     4 5 0 -1 unassigned, Utah, US
2989 2989       Zimbabwe 2020-04-12 23:17:00 -19.015438 29.154857 14 3 0 11 Zimbabwe
2988 2988       Zambia 2020-04-12 23:17:00 -13.133897 27.849332 43 2 30 11 Zambia
2987 2987       Yemen 2020-04-12 23:17:00 15.552727 48.516388 1 0 0 1 Yemen
2986 2986       West Bank and Gaza 2020-04-12 23:17:00 31.9522 35.2332 290 2 58 230 West Bank and Gaza
2985 2985       Vietnam 2020-04-12 23:17:00 14.058324 108.277199 262 0 144 118 Vietnam
2984 2984       Venezuela 2020-04-12 23:17:00 6.4238 -66.5897 181 9 93 79 Venezuela
2983 2983       Uzbekistan 2020-04-12 23:17:00 41.377491 64.585262 865 4 66 795 Uzbekistan
2982 2982       Uruguay 2020-04-12 23:17:00 -32.5228 -55.7658 480 7 231 242 Uruguay
2981 2981       United Kingdom 2020-04-12 23:17:00 55.3781 -3.436 84279 10612 344 73323 United Kingdom
2980 2980       United Arab Emirates 2020-04-12 23:17:00 23.424076 53.847818 4123 22 680 3421 United Arab Emirates
2979 2979       Ukraine 2020-04-12 23:17:00 48.3794 31.1656 2777 83 89 2605 Ukraine
2978 2978       Uganda 2020-04-12 23:17:00 1.373333 32.290275 54 0 4 50 Uganda
2977 2977       Turkey 2020-04-12 23:17:00 38.9637 35.2433 56956 1198 3446 52312 Turkey
2976 2976       Tunisia 2020-04-12 23:17:00 33.886917 9.537499 707 31 43 633 Tunisia
2975 2975       Trinidad and Tobago 2020-04-12 23:17:00 10.6918 -61.2225 113 8 16 89 Trinidad and Tobago
2974 2974       Togo 2020-04-12 23:17:00 8.6195 0.8248 76 3 29 44 Togo
2973 2973       Timor-Leste 2020-04-12 23:17:00 -8.874217 125.727539 2 0 1 1 Timor-Leste
2972 2972       Thailand 2020-04-12 23:17:00 15.870032 100.992541 2551 38 1218 1295 Thailand
2971 2971       Tanzania 2020-04-12 23:17:00 -6.369028 34.888822 32 3 5 24 Tanzania
2970 2970       Taiwan* 2020-04-12 07:18:00 23.7 121.0 388 6 109 273 Taiwan*
2969 2969       Syria 2020-04-12 23:17:00 34.802075 38.996815 25 2 5 18 Syria
2968 2968       Switzerland 2020-04-12 23:17:00 46.8182 8.2275 25415 1106 12700 11609 Switzerland
2967 2967       Sweden 2020-04-12 23:17:00 60.128161 18.643501 10483 899 381 9203 Sweden
2966 2966       Suriname 2020-04-12 23:17:00 3.9193 -56.0278 10 1 4 5 Suriname
2965 2965       Sudan 2020-04-12 23:17:00 12.8628 30.2176 19 2 2 15 Sudan
2964 2964       Sri Lanka 2020-04-12 23:17:00 7.873054 80.771797 210 7 56 147 Sri Lanka
2963 2963       Spain 2020-04-12 23:17:00 40.463667 -3.74922 166831 17209 62391 87231 Spain
2962 2962       South Sudan 2020-04-12 23:17:00 6.877 31.307 4 0 0 4 South Sudan
2961 2961       South Africa 2020-04-12 23:17:00 -30.5595 22.9375 2173 25 410 1738 South Africa
2960 2960       Somalia 2020-04-12 23:17:00 5.152149 46.199616 25 1 2 22 Somalia
2959 2959       Slovenia 2020-04-12 23:17:00 46.1512 14.9955 1205 53 150 1002 Slovenia
2958 2958       Slovakia 2020-04-12 23:17:00 48.669 19.699 742 2 23 717 Slovakia
2957 2957       Singapore 2020-04-12 23:17:00 1.2833 103.8333 2532 8 560 1964 Singapore
2956 2956       Sierra Leone 2020-04-12 23:17:00 8.460555 -11.779889 10 0 0 10 Sierra Leone
2955 2955       Seychelles 2020-04-12 23:17:00 -4.6796 55.492 11 0 0 11 Seychelles
2954 2954       Serbia 2020-04-12 23:17:00 44.0165 21.0059 3630 80 0 3550 Serbia
2953 2953       Senegal 2020-04-12 23:17:00 14.4974 -14.4524 280 2 171 107 Senegal
2952 2952       Saudi Arabia 2020-04-12 23:17:00 23.885942 45.079162 4462 59 761 3642 Saudi Arabia
2951 2951       Sao Tome and Principe 2020-04-12 23:17:00 0.18636 6.613081 4 0 0 4 Sao Tome and Principe
2950 2950       San Marino 2020-04-12 23:17:00 43.9424 12.4578 356 35 53 268 San Marino
2949 2949       Samoa 2020-04-12 23:24:00 -13.759 -172.1046 0 0 0 0 Samoa
2948 2948       Saint Vincent and the Grenadines 2020-04-12 23:17:00 12.9843 -61.2872 12 0 1 11 Saint Vincent and the Grenadines
2947 2947       Saint Lucia 2020-04-12 23:17:00 13.9094 -60.9789 15 0 4 11 Saint Lucia
2946 2946       Saint Kitts and Nevis 2020-04-12 23:17:00 17.357822 -62.782998 12 0 0 12 Saint Kitts and Nevis
2945 2945       Rwanda 2020-04-12 23:17:00 -1.9403 29.8739 126 0 25 101 Rwanda
2944 2944       Russia 2020-04-12 23:17:00 61.52401 105.318756 15770 130 1291 14349 Russia
2943 2943       Romania 2020-04-12 23:17:00 45.9432 24.9668 6300 316 852 5132 Romania
2942 2942       Qatar 2020-04-12 23:17:00 25.3548 51.1839 2979 7 275 2697 Qatar
2941 2941       Portugal 2020-04-12 23:17:00 39.3999 -8.2245 16585 504 277 15804 Portugal
2940 2940       Poland 2020-04-12 23:17:00 51.9194 19.1451 6674 232 439 6003 Poland
2939 2939       Philippines 2020-04-12 23:17:00 12.879721 121.774017 4648 297 197 4154 Philippines
2938 2938       Peru 2020-04-12 23:17:00 -9.19 -75.0152 7519 193 1798 5528 Peru
2937 2937       Paraguay 2020-04-12 23:17:00 -23.4425 -58.4438 134 6 22 106 Paraguay
2936 2936       Papua New Guinea 2020-04-12 23:17:00 -6.314993 143.95555 2 0 0 2 Papua New Guinea
2935 2935       Panama 2020-04-12 23:17:00 8.538 -80.7821 3234 79 23 3132 Panama
2934 2934       Pakistan 2020-04-12 23:17:00 30.3753 69.3451 5230 91 1028 4111 Pakistan
2933 2933       Oman 2020-04-12 23:17:00 21.512583 55.923255 599 4 109 486 Oman
2932 2932       Norway 2020-04-12 23:17:00 60.472 8.4689 6525 128 32 6365 Norway
2931 2931       North Macedonia 2020-04-12 23:17:00 41.6086 21.7453 828 34 41 753 North Macedonia
2930 2930       Nigeria 2020-04-12 23:17:00 9.082 8.6753 323 10 85 228 Nigeria
2929 2929       Niger 2020-04-12 23:17:00 17.607789 8.081666 529 12 75 442 Niger
2928 2928       Nicaragua 2020-04-12 23:17:00 12.865416 -85.207229 9 1 4 4 Nicaragua
2927 2927       New Zealand 2020-04-12 23:17:00 -40.9006 174.886 1330 4 471 855 New Zealand
2926 2926       Netherlands 2020-04-12 23:17:00 52.1326 5.2913 25587 2737 250 22600 Netherlands
2925 2925       Nepal 2020-04-12 23:17:00 28.1667 84.25 12 0 1 11 Nepal
2924 2924       Namibia 2020-04-12 23:17:00 -22.9576 18.4904 16 0 3 13 Namibia
2923 2923       Mozambique 2020-04-12 23:17:00 -18.665695 35.529562 21 0 2 19 Mozambique
2922 2922       Morocco 2020-04-12 23:17:00 31.7917 -7.0926 1661 118 177 1366 Morocco
2921 2921       Montenegro 2020-04-12 23:17:00 42.708678 19.37439 272 3 5 264 Montenegro
2920 2920       Mongolia 2020-04-12 23:17:00 46.8625 103.8467 16 0 4 12 Mongolia
2919 2919       Monaco 2020-04-12 23:17:00 43.7333 7.4167 93 1 6 86 Monaco
2918 2918       Moldova 2020-04-12 23:17:00 47.4116 28.3699 1662 31 94 1537 Moldova
2917 2917       Mexico 2020-04-12 23:17:00 23.6345 -102.5528 4219 273 1772 2174 Mexico
2916 2916       Mauritius 2020-04-12 23:17:00 -20.348404 57.552152 324 9 42 273 Mauritius
2915 2915       Mauritania 2020-04-12 23:17:00 21.0079 -10.9408 7 1 2 4 Mauritania
2914 2914       Malta 2020-04-12 23:17:00 35.9375 14.3754 378 3 44 331 Malta
2913 2913       Mali 2020-04-12 23:17:00 17.570692 -3.996166 105 9 22 74 Mali
2912 2912       Maldives 2020-04-12 23:17:00 3.2028 73.2207 20 0 14 6 Maldives
2911 2911       Malaysia 2020-04-12 23:17:00 4.210484 101.975766 4683 76 2108 2499 Malaysia
2910 2910       Malawi 2020-04-12 23:17:00 -13.254308 34.301525 13 2 0 11 Malawi
2909 2909       Madagascar 2020-04-12 23:17:00 -18.766947 46.869107 106 0 20 86 Madagascar
2908 2908       MS Zaandam 2020-04-12 23:17:00     9 2 0 7 MS Zaandam
2907 2907       Luxembourg 2020-04-12 23:17:00 49.8153 6.1296 3281 66 500 2715 Luxembourg
2906 2906       Lithuania 2020-04-12 23:17:00 55.1694 23.8813 952 14 2 933 Lithuania
2905 2905       Liechtenstein 2020-04-12 23:17:00 47.14 9.55 79 1 55 23 Liechtenstein
2904 2904       Libya 2020-04-12 23:17:00 26.3351 17.228331 25 1 9 15 Libya
2903 2903       Liberia 2020-04-12 23:17:00 6.428055 -9.429499 50 5 3 42 Liberia
2902 2902       Lebanon 2020-04-12 23:17:00 33.8547 35.8623 630 20 80 530 Lebanon
2901 2901       Latvia 2020-04-12 23:17:00 56.8796 24.6032 651 5 16 630 Latvia
2900 2900       Laos 2020-04-12 23:17:00 19.85627 102.495496 19 0 0 19 Laos
2899 2899       Kyrgyzstan 2020-04-12 23:17:00 41.20438 74.766098 377 5 54 318 Kyrgyzstan
2898 2898       Kuwait 2020-04-12 23:17:00 29.31166 47.481766 1234 1 142 1091 Kuwait
2897 2897       Kosovo 2020-04-12 23:17:00 42.602636 20.902977 283 7 58 218 Kosovo
2896 2896       Korea, South 2020-04-12 23:17:00 35.907757 127.766922 10512 214 7368 2930 Korea, South
2895 2895       Kenya 2020-04-12 23:17:00 -0.0236 37.9062 197 8 25 164 Kenya
2894 2894       Kazakhstan 2020-04-12 23:17:00 48.0196 66.9237 951 10 99 842 Kazakhstan
2893 2893       Jordan 2020-04-12 23:17:00 31.24 36.51 389 7 201 181 Jordan
2892 2892       Japan 2020-04-12 23:17:00 36.204824 138.252924 6748 108 762 5878 Japan
2891 2891       Jamaica 2020-04-12 23:17:00 18.1096 -77.2975 69 4 13 52 Jamaica

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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