03-30-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

3,442 rows sorted by Active 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
3348 3348       Italy 3/30/20 22:52 41.87194 12.56738 101739 11591 14620 75528 Italy
3417 3417       Spain 3/30/20 22:52 40.463667 -3.74922 87956 7716 16780 63460 Spain
3329 3329       Germany 3/30/20 22:52 51.165691 10.451526 66885 645 13500 52740 Germany
3325 3325       France 3/30/20 22:52 46.2276 2.2137 44029 3020 7927 33599 France
3344 3344       Iran 3/30/20 22:52 32.427908 53.688046 41495 2757 13911 24827 Iran
3435 3435       United Kingdom 3/30/20 22:52 55.3781 -3.436 22141 1408 135 20598 United Kingdom
3422 3422       Switzerland 3/30/20 22:52 46.8182 8.2275 15922 359 1823 13740 Switzerland
3383 3383       Netherlands 3/30/20 22:52 52.1326 5.2913 11750 864 250 10636 Netherlands
3431 3431       Turkey 3/30/20 22:52 38.9637 35.2433 10827 168 162 10497 Turkey
3283 3283       Belgium 3/30/20 22:52 50.8333 4.469936 11899 513 1527 9859 Belgium
3276 3276       Austria 3/30/20 22:52 47.5162 14.5501 9618 108 636 8874 Austria
3398 3398       Portugal 3/30/20 22:52 39.3999 -8.2245 6408 140 43 6225 Portugal
3347 3347       Israel 3/30/20 22:52 31.046051 34.851612 4979 17 147 4518 Israel
3389 3389       Norway 3/30/20 22:52 60.472 8.4689 4445 32 12 4401 Norway
3290 3290       Brazil 3/30/20 22:52 -14.235 -51.9253 4579 159 120 4300 Brazil
3354 3354       Korea, South 3/30/20 22:52 35.907757 127.766922 9661 158 5228 4275 Korea, South
3421 3421       Sweden 3/30/20 22:52 60.128161 18.643501 4028 146 16 3866 Sweden
3309 3309       Czechia 3/30/20 22:52 49.8175 15.473 3001 23 25 2953 Czechia
3346 3346       Ireland 3/30/20 22:52 53.1424 -7.6921 2910 54 5 2851 Ireland
3310 3310       Denmark 3/30/20 22:52 56.2639 9.5018 2577 77 1 2499 Denmark
3300 3300       Chile 3/30/20 22:52 -35.6751 -71.543 2449 8 156 2285 Chile
3368 3368       Malaysia 3/30/20 22:52 4.210484 101.975766 2626 37 479 2110 Malaysia
3229 3229     New South Wales Australia 3/30/20 22:58 -33.8688 151.2093 2032 8 4 2020 New South Wales, Australia
3397 3397       Poland 3/30/20 22:52 51.9194 19.1451 2055 31 7 2017 Poland
3365 3365       Luxembourg 3/30/20 22:52 49.8153 6.1296 1988 22 40 1926 Luxembourg
3315 3315       Ecuador 3/30/20 22:52 -1.8312 -78.1834 1962 60 3 1899 Ecuador
3400 3400       Romania 3/30/20 22:52 45.9432 24.9668 2109 65 209 1835 Romania
3401 3401       Russia 3/30/20 22:52 61.52401 105.318756 1836 9 66 1761 Russia
3214 3214     Hubei China 3/30/20 12:30 30.9756 112.2707 67801 3186 62889 1726 Hubei, China
3391 3391       Pakistan 3/30/20 22:52 30.3753 69.3451 1717 21 76 1620 Pakistan
3396 3396       Philippines 3/30/20 22:52 12.879721 121.774017 1546 78 42 1426 Philippines
3350 3350       Japan 3/30/20 22:52 36.204824 138.252924 1866 54 424 1388 Japan
3408 3408       Saudi Arabia 3/30/20 22:52 23.885942 45.079162 1453 8 115 1330 Saudi Arabia
3324 3324       Finland 3/30/20 22:52 61.92411 25.748151 1352 13 10 1329 Finland
3416 3416       South Africa 3/30/20 22:52 -30.5595 22.9375 1326 3 31 1292 South Africa
3426 3426       Thailand 3/30/20 22:52 15.870032 100.992541 1524 9 127 1286 Thailand
3343 3343       Indonesia 3/30/20 22:52 -0.7893 113.9213 1414 122 75 1217 Indonesia
3331 3331       Greece 3/30/20 22:52 39.0742 21.8243 1212 43 52 1117 Greece
3342 3342       India 3/30/20 22:52 20.593684 78.96288 1251 32 102 1117 India
3392 3392       Panama 3/30/20 22:52 8.538 -80.7821 989 24 4 961 Panama
3374 3374       Mexico 3/30/20 22:52 23.6345 -102.5528 993 20 35 938 Mexico
3341 3341       Iceland 3/30/20 22:52 64.9631 -19.0208 1086 2 157 927 Iceland
3395 3395       Peru 3/30/20 22:52 -9.19 -75.0152 950 24 53 873 Peru
3314 3314       Dominican Republic 3/30/20 22:52 18.7357 -70.1627 901 42 4 855 Dominican Republic
3301 3301       Colombia 3/30/20 22:52 4.5709 -74.2973 798 12 15 771 Colombia
3410 3410       Serbia 3/30/20 22:52 44.0165 21.0059 785 16 0 769 Serbia
3414 3414       Slovenia 3/30/20 22:52 46.1512 14.9955 756 11 10 735 Slovenia
3306 3306       Croatia 3/30/20 22:52 45.1 15.2 790 6 67 717 Croatia
3320 3320       Estonia 3/30/20 22:52 58.5953 25.0136 715 3 20 692 Estonia
3242 3242     Queensland Australia 3/30/20 22:58 -27.4698 153.0251 689 2 8 679 Queensland, Australia
3412 3412       Singapore 3/30/20 22:52 1.2833 103.8333 879 3 228 648 Singapore
3399 3399       Qatar 3/30/20 22:52 25.3548 51.1839 693 1 51 641 Qatar
3261 3261     Victoria Australia 3/30/20 22:58 -37.8136 144.9631 821 4 191 626 Victoria, Australia
3274 3274       Argentina 3/30/20 22:52 -38.4161 -63.6167 820 23 228 569 Argentina
3213 3213     Hong Kong China 3/30/20 9:27 22.3 114.2 682 4 123 555 Hong Kong, China
3434 3434       United Arab Emirates 3/30/20 22:52 23.424076 53.847818 611 5 61 545 United Arab Emirates
3433 3433       Ukraine 3/30/20 22:52 48.3794 31.1656 548 13 8 527 Ukraine
3384 3384       New Zealand 3/30/20 22:52 -40.9006 174.886 589 1 63 525 New Zealand
3270 3270       Algeria 3/30/20 22:52 28.0339 1.6596 584 35 37 512 Algeria
3379 3379       Morocco 3/30/20 22:52 31.7917 -7.0926 556 33 15 508 Morocco
3364 3364       Lithuania 3/30/20 22:52 55.1694 23.8813 424 4 0 477 Lithuania
3316 3316       Egypt 3/30/20 22:52 26.820553 30.802498 656 41 150 465 Egypt
3275 3275       Armenia 3/30/20 22:52 40.0691 45.0382 482 3 30 449 Armenia
3345 3345       Iraq 3/30/20 22:52 33.223191 43.679291 630 46 152 432 Iraq
3360 3360       Lebanon 3/30/20 22:52 33.8547 35.8623 446 11 35 400 Lebanon
3340 3340       Hungary 3/30/20 22:52 47.1625 19.5033 447 15 34 398 Hungary
3359 3359       Latvia 3/30/20 22:52 56.8796 24.6032 376 0 1 375 Latvia
3271 3271       Andorra 3/30/20 22:52 42.5063 1.5218 370 8 10 352 Andorra
3288 3288       Bosnia and Herzegovina 3/30/20 22:52 43.9159 17.6791 368 10 17 341 Bosnia and Herzegovina
3292 3292       Bulgaria 3/30/20 22:52 42.7339 25.4858 359 8 17 334 Bulgaria
3413 3413       Slovakia 3/30/20 22:52 48.669 19.699 336 0 7 329 Slovakia
3304 3304       Costa Rica 3/30/20 22:52 9.7489 -83.7534 330 2 4 324 Costa Rica
3263 3263     Western Australia Australia 3/30/20 22:58 -31.9505 115.8605 355 2 41 312 Western Australia, Australia
3436 3436       Uruguay 3/30/20 22:52 -32.5228 -55.7658 310 1 0 309 Uruguay
3430 3430       Tunisia 3/30/20 22:52 33.886917 9.537499 312 8 3 301 Tunisia
3255 3255     South Australia Australia 3/30/20 22:58 -34.9285 138.6007 305 0 6 299 South Australia, Australia
3375 3375       Moldova 3/30/20 22:52 47.4116 28.3699 298 2 15 281 Moldova
3352 3352       Kazakhstan 3/30/20 22:52 48.0196 66.9237 302 1 21 280 Kazakhstan
3388 3388       North Macedonia 3/30/20 22:52 41.6086 21.7453 285 7 12 266 North Macedonia
3424 3424       Taiwan* 3/30/20 7:11 23.7 121.0 306 5 39 262 Taiwan*
3277 3277       Azerbaijan 3/30/20 22:52 40.1431 47.5769 273 4 26 243 Azerbaijan
3351 3351       Jordan 3/30/20 22:52 31.24 36.51 268 5 26 237 Jordan
3279 3279       Bahrain 3/30/20 22:52 26.0275 50.55 515 4 279 232 Bahrain
3245 3245     Reunion France 3/30/20 22:52 -21.1151 55.5364 224 0 1 223 Reunion, France
3293 3293       Burkina Faso 3/30/20 22:52 12.2383 -1.5616 246 12 31 203 Burkina Faso
3308 3308       Cyprus 3/30/20 22:52 35.1264 33.4299 230 7 22 201 Cyprus
3356 3356       Kuwait 3/30/20 22:52 29.31166 47.481766 266 0 72 194 Kuwait
3407 3407       San Marino 3/30/20 22:52 43.9424 12.4578 230 25 13 192 San Marino
3269 3269       Albania 3/30/20 22:52 41.1533 20.1683 223 11 44 168 Albania
3268 3268       Afghanistan 3/30/20 22:52 33.93911 67.709953 146 4 2 164 Afghanistan
3307 3307       Cuba 3/30/20 22:52 21.521757 -77.781167 170 4 4 162 Cuba
3305 3305       Cote d'Ivoire 3/30/20 22:52 7.54 -5.5471 168 1 6 161 Cote d'Ivoire
3251 3251     Shanghai China 3/30/20 5:05 31.202 121.4491 498 5 338 155 Shanghai, China
3185 3185     Beijing China 3/30/20 5:34 40.1824 116.4142 577 8 415 154 Beijing, China
3371 3371       Malta 3/30/20 22:52 35.9375 14.3754 156 0 2 154 Malta
3390 3390       Oman 3/30/20 22:52 21.512583 55.923255 179 0 29 150 Oman
3439 3439       Vietnam 3/30/20 22:52 14.058324 108.277199 203 0 55 148 Vietnam
3330 3330       Ghana 3/30/20 22:52 7.9465 -1.0232 152 5 2 145 Ghana
3437 3437       Uzbekistan 3/30/20 22:52 41.377491 64.585262 149 2 7 140 Uzbekistan
3190 3190     Channel Islands United Kingdom 3/30/20 22:52 49.3723 -2.3644 141 2 0 139 Channel Islands, United Kingdom

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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