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 Country_Region

✎ 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
3203 3203     Greenland Denmark 3/30/20 22:52 71.7069 -42.6043 10 0 2 8 Greenland, Denmark
3310 3310       Denmark 3/30/20 22:52 56.2639 9.5018 2577 77 1 2499 Denmark
3311 3311       Diamond Princess 3/30/20 22:52 0.0 0.0 712 10 603 99 Diamond Princess
3312 3312       Djibouti 3/30/20 22:52 11.8251 42.5903 18 0 0 18 Djibouti
3313 3313       Dominica 3/30/20 22:52 15.415 -61.371 11 0 0 11 Dominica
3314 3314       Dominican Republic 3/30/20 22:52 18.7357 -70.1627 901 42 4 855 Dominican Republic
3315 3315       Ecuador 3/30/20 22:52 -1.8312 -78.1834 1962 60 3 1899 Ecuador
3316 3316       Egypt 3/30/20 22:52 26.820553 30.802498 656 41 150 465 Egypt
3317 3317       El Salvador 3/30/20 22:52 13.7942 -88.8965 30 0 0 30 El Salvador
3318 3318       Equatorial Guinea 3/30/20 22:52 1.6508 10.2679 12 0 0 12 Equatorial Guinea
3319 3319       Eritrea 3/30/20 22:52 15.1794 39.7823 12 0 0 12 Eritrea
3320 3320       Estonia 3/30/20 22:52 58.5953 25.0136 715 3 20 692 Estonia
3321 3321       Eswatini 3/30/20 22:52 -26.5225 31.4659 9 0 0 9 Eswatini
3322 3322       Ethiopia 3/30/20 22:52 9.145 40.4897 23 0 4 19 Ethiopia
3323 3323       Fiji 3/30/20 22:52 -17.7134 178.065 5 0 0 5 Fiji
3324 3324       Finland 3/30/20 22:52 61.92411 25.748151 1352 13 10 1329 Finland
3196 3196     French Guiana France 3/30/20 22:52 4.0 -53.0 43 0 6 37 French Guiana, France
3197 3197     French Polynesia France 3/30/20 22:52 -17.6797 149.4068 36 0 0 36 French Polynesia, France
3204 3204     Guadeloupe France 3/30/20 22:52 16.265 -61.551 106 4 17 85 Guadeloupe, France
3224 3224     Martinique France 3/30/20 22:52 14.6415 -61.0242 93 1 0 92 Martinique, France
3225 3225     Mayotte France 3/30/20 22:52 -12.8275 45.166244 82 0 10 72 Mayotte, France
3228 3228     New Caledonia France 3/30/20 22:52 -20.904305 165.618042 15 0 0 15 New Caledonia, France
3245 3245     Reunion France 3/30/20 22:52 -21.1151 55.5364 224 0 1 223 Reunion, France
3246 3246     Saint Barthelemy France 3/30/20 22:52 17.9 -62.8333 6 0 1 5 Saint Barthelemy, France
3256 3256     St Martin France 3/30/20 22:52 18.0708 -63.0501 15 1 2 12 St Martin, France
3325 3325       France 3/30/20 22:52 46.2276 2.2137 44029 3020 7927 33599 France
3326 3326       Gabon 3/30/20 22:52 -0.8037 11.6094 7 1 0 6 Gabon
3327 3327       Gambia 3/30/20 22:52 13.4432 -15.3101 4 1 0 3 Gambia
3328 3328       Georgia 3/30/20 22:52 42.3154 43.3569 103 0 20 83 Georgia
3329 3329       Germany 3/30/20 22:52 51.165691 10.451526 66885 645 13500 52740 Germany
3330 3330       Ghana 3/30/20 22:52 7.9465 -1.0232 152 5 2 145 Ghana
3331 3331       Greece 3/30/20 22:52 39.0742 21.8243 1212 43 52 1117 Greece
3332 3332       Grenada 3/30/20 22:52 12.1165 -61.679 9 0 0 9 Grenada
3333 3333       Guatemala 3/30/20 22:52 15.7835 -90.2308 36 1 10 25 Guatemala
3334 3334       Guinea 3/30/20 22:52 9.9456 -9.6966 22 0 0 22 Guinea
3335 3335       Guinea-Bissau 3/30/20 22:52 11.8037 -15.1804 8 0 0 8 Guinea-Bissau
3336 3336       Guyana 3/30/20 22:52 4.860416 -58.93018 8 1 0 7 Guyana
3337 3337       Haiti 3/30/20 22:52 18.9712 -72.2852 15 0 1 14 Haiti
3338 3338       Holy See 3/30/20 22:52 41.9029 12.4534 6 0 0 6 Holy See
3339 3339       Honduras 3/30/20 22:52 15.2 -86.2419 139 7 3 129 Honduras
3340 3340       Hungary 3/30/20 22:52 47.1625 19.5033 447 15 34 398 Hungary
3341 3341       Iceland 3/30/20 22:52 64.9631 -19.0208 1086 2 157 927 Iceland
3342 3342       India 3/30/20 22:52 20.593684 78.96288 1251 32 102 1117 India
3343 3343       Indonesia 3/30/20 22:52 -0.7893 113.9213 1414 122 75 1217 Indonesia
3344 3344       Iran 3/30/20 22:52 32.427908 53.688046 41495 2757 13911 24827 Iran
3345 3345       Iraq 3/30/20 22:52 33.223191 43.679291 630 46 152 432 Iraq
3346 3346       Ireland 3/30/20 22:52 53.1424 -7.6921 2910 54 5 2851 Ireland
3347 3347       Israel 3/30/20 22:52 31.046051 34.851612 4979 17 147 4518 Israel
3348 3348       Italy 3/30/20 22:52 41.87194 12.56738 101739 11591 14620 75528 Italy
3349 3349       Jamaica 3/30/20 22:52 18.1096 -77.2975 36 1 2 33 Jamaica
3350 3350       Japan 3/30/20 22:52 36.204824 138.252924 1866 54 424 1388 Japan
3351 3351       Jordan 3/30/20 22:52 31.24 36.51 268 5 26 237 Jordan
3352 3352       Kazakhstan 3/30/20 22:52 48.0196 66.9237 302 1 21 280 Kazakhstan
3353 3353       Kenya 3/30/20 22:52 -0.0236 37.9062 50 1 1 48 Kenya
3354 3354       Korea, South 3/30/20 22:52 35.907757 127.766922 9661 158 5228 4275 Korea, South
3355 3355       Kosovo 3/30/20 22:52 42.602636 20.902977 94 1 1 92 Kosovo
3356 3356       Kuwait 3/30/20 22:52 29.31166 47.481766 266 0 72 194 Kuwait
3357 3357       Kyrgyzstan 3/30/20 22:52 41.20438 74.766098 94 0 3 91 Kyrgyzstan
3358 3358       Laos 3/30/20 22:52 19.85627 102.495496 8 0 0 8 Laos
3359 3359       Latvia 3/30/20 22:52 56.8796 24.6032 376 0 1 375 Latvia
3360 3360       Lebanon 3/30/20 22:52 33.8547 35.8623 446 11 35 400 Lebanon
3361 3361       Liberia 3/30/20 22:52 6.428055 -9.429499 3 0 0 3 Liberia
3362 3362       Libya 3/30/20 22:52 26.3351 17.228331 8 0 0 8 Libya
3363 3363       Liechtenstein 3/30/20 22:52 47.14 9.55 62 0 0 62 Liechtenstein
3364 3364       Lithuania 3/30/20 22:52 55.1694 23.8813 424 4 0 477 Lithuania
3365 3365       Luxembourg 3/30/20 22:52 49.8153 6.1296 1988 22 40 1926 Luxembourg
3366 3366       MS Zaandam 3/30/20 22:52 0.0 0.0 2 0 0 2 ,,MS Zaandam
3367 3367       Madagascar 3/30/20 22:52 -18.766947 46.869107 43 0 0 43 Madagascar
3368 3368       Malaysia 3/30/20 22:52 4.210484 101.975766 2626 37 479 2110 Malaysia
3369 3369       Maldives 3/30/20 22:52 3.2028 73.2207 17 0 13 4 Maldives
3370 3370       Mali 3/30/20 22:52 17.570692 -3.996166 25 2 0 23 Mali
3371 3371       Malta 3/30/20 22:52 35.9375 14.3754 156 0 2 154 Malta
3372 3372       Mauritania 3/30/20 22:52 21.0079 -10.9408 5 1 2 2 ,,Mauritania
3373 3373       Mauritius 3/30/20 22:52 -20.348404 57.552152 128 3 0 125 Mauritius
3374 3374       Mexico 3/30/20 22:52 23.6345 -102.5528 993 20 35 938 Mexico
3375 3375       Moldova 3/30/20 22:52 47.4116 28.3699 298 2 15 281 Moldova
3376 3376       Monaco 3/30/20 22:52 43.7333 7.4167 49 1 1 47 Monaco
3377 3377       Mongolia 3/30/20 22:52 46.8625 103.8467 12 0 2 10 Mongolia
3378 3378       Montenegro 3/30/20 22:52 42.708678 19.37439 91 1 0 90 Montenegro
3379 3379       Morocco 3/30/20 22:52 31.7917 -7.0926 556 33 15 508 Morocco
3380 3380       Mozambique 3/30/20 22:52 -18.665695 35.529562 8 0 0 8 Mozambique
3381 3381       Namibia 3/30/20 22:52 -22.9576 18.4904 11 0 2 9 Namibia
3382 3382       Nepal 3/30/20 22:52 28.1667 84.25 5 0 1 4 Nepal
3183 3183     Aruba Netherlands 3/30/20 22:52 12.5211 -69.9683 50 0 1 49 Aruba, Netherlands
3192 3192     Curacao Netherlands 3/30/20 22:52 12.1696 -68.99 11 1 2 8 Curacao, Netherlands
3254 3254     Sint Maarten Netherlands 3/30/20 22:52 18.0425 -63.0548 6 0 0 6 Sint Maarten, Netherlands
3383 3383       Netherlands 3/30/20 22:52 52.1326 5.2913 11750 864 250 10636 Netherlands
3384 3384       New Zealand 3/30/20 22:52 -40.9006 174.886 589 1 63 525 New Zealand
3385 3385       Nicaragua 3/30/20 22:52 12.865416 -85.207229 4 1 0 3 Nicaragua
3386 3386       Niger 3/30/20 22:52 17.607789 8.081666 27 3 0 24 Niger
3387 3387       Nigeria 3/30/20 22:52 9.082 8.6753 131 2 8 121 Nigeria
3388 3388       North Macedonia 3/30/20 22:52 41.6086 21.7453 285 7 12 266 North Macedonia
3389 3389       Norway 3/30/20 22:52 60.472 8.4689 4445 32 12 4401 Norway
3390 3390       Oman 3/30/20 22:52 21.512583 55.923255 179 0 29 150 Oman
3391 3391       Pakistan 3/30/20 22:52 30.3753 69.3451 1717 21 76 1620 Pakistan
3392 3392       Panama 3/30/20 22:52 8.538 -80.7821 989 24 4 961 Panama
3393 3393       Papua New Guinea 3/30/20 22:52 -6.314993 143.95555 1 0 0 1 Papua New Guinea
3394 3394       Paraguay 3/30/20 22:52 -23.4425 -58.4438 64 3 1 60 Paraguay
3395 3395       Peru 3/30/20 22:52 -9.19 -75.0152 950 24 53 873 Peru
3396 3396       Philippines 3/30/20 22:52 12.879721 121.774017 1546 78 42 1426 Philippines

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
);