03-29-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,437 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
3305 3305       Denmark 3/29/20 23:08 56.2639 9.5018 2395 72 1 2322 Denmark
3306 3306       Diamond Princess 3/29/20 23:08 0.0 0.0 712 10 603 99 Diamond Princess
3307 3307       Djibouti 3/29/20 23:08 11.8251 42.5903 18 0 0 18 Djibouti
3308 3308       Dominica 3/29/20 23:08 15.415 -61.371 11 0 0 11 Dominica
3309 3309       Dominican Republic 3/29/20 23:08 18.7357 -70.1627 859 39 3 817 Dominican Republic
3310 3310       Ecuador 3/29/20 23:08 -1.8312 -78.1834 1924 58 3 1863 Ecuador
3311 3311       Egypt 3/29/20 23:08 26.820553 30.802498 609 40 132 437 Egypt
3312 3312       El Salvador 3/29/20 23:08 13.7942 -88.8965 24 0 0 24 El Salvador
3313 3313       Equatorial Guinea 3/29/20 23:08 1.6508 10.2679 12 0 0 12 Equatorial Guinea
3314 3314       Eritrea 3/29/20 23:08 15.1794 39.7823 12 0 0 12 Eritrea
3315 3315       Estonia 3/29/20 23:08 58.5953 25.0136 679 3 20 656 Estonia
3316 3316       Eswatini 3/29/20 23:08 -26.5225 31.4659 9 0 0 9 Eswatini
3317 3317       Ethiopia 3/29/20 23:08 9.145 40.4897 21 0 1 20 Ethiopia
3318 3318       Fiji 3/29/20 23:08 -17.7134 178.065 5 0 0 5 Fiji
3319 3319       Finland 3/29/20 23:08 61.92411 25.748151 1240 11 10 1219 Finland
3192 3192     French Guiana France 3/29/20 23:08 4.0 -53.0 28 0 6 22 French Guiana, France
3193 3193     French Polynesia France 3/29/20 23:08 -17.6797 149.4068 30 0 0 30 French Polynesia, France
3200 3200     Guadeloupe France 3/29/20 23:08 16.265 -61.551 106 4 17 85 Guadeloupe, France
3220 3220     Martinique France 3/29/20 23:08 14.6415 -61.0242 93 1 0 92 Martinique, France
3221 3221     Mayotte France 3/29/20 23:08 -12.8275 45.166244 63 0 0 63 Mayotte, France
3224 3224     New Caledonia France 3/29/20 23:08 -20.904305 165.618042 15 0 0 15 New Caledonia, France
3241 3241     Reunion France 3/29/20 23:08 -21.1151 55.5364 183 0 1 182 Reunion, France
3242 3242     Saint Barthelemy France 3/29/20 23:08 17.9 -62.8333 5 0 0 5 Saint Barthelemy, France
3252 3252     St Martin France 3/29/20 23:08 18.0708 -63.0501 11 0 0 11 St Martin, France
3320 3320       France 3/29/20 23:08 46.2276 2.2137 39761 2603 7202 30366 France
3321 3321       Gabon 3/29/20 23:08 -0.8037 11.6094 7 1 0 6 Gabon
3322 3322       Gambia 3/29/20 23:08 13.4432 -15.3101 4 1 0 3 Gambia
3323 3323       Georgia 3/29/20 23:08 42.3154 43.3569 91 0 18 73 Georgia
3324 3324       Germany 3/29/20 23:08 51.165691 10.451526 62095 533 9211 52351 Germany
3325 3325       Ghana 3/29/20 23:08 7.9465 -1.0232 152 5 2 145 Ghana
3326 3326       Greece 3/29/20 23:08 39.0742 21.8243 1156 38 52 1066 Greece
3327 3327       Grenada 3/29/20 23:08 12.1165 -61.679 9 0 0 9 Grenada
3328 3328       Guatemala 3/29/20 23:08 15.7835 -90.2308 34 1 10 23 Guatemala
3329 3329       Guinea 3/29/20 23:08 9.9456 -9.6966 16 0 0 16 Guinea
3330 3330       Guinea-Bissau 3/29/20 23:08 11.8037 -15.1804 2 0 0 2 Guinea-Bissau
3331 3331       Guyana 3/29/20 23:08 4.860416 -58.93018 8 1 0 7 Guyana
3332 3332       Haiti 3/29/20 23:08 18.9712 -72.2852 8 0 1 14 Haiti
3333 3333       Holy See 3/29/20 23:08 41.9029 12.4534 6 0 0 6 Holy See
3334 3334       Honduras 3/29/20 23:08 15.2 -86.2419 110 3 3 104 Honduras
3335 3335       Hungary 3/29/20 23:08 47.1625 19.5033 408 13 34 361 Hungary
3336 3336       Iceland 3/29/20 23:08 64.9631 -19.0208 1020 2 135 883 Iceland
3337 3337       India 3/29/20 23:08 20.593684 78.96288 1024 27 95 902 India
3338 3338       Indonesia 3/29/20 23:08 -0.7893 113.9213 1285 114 64 1107 Indonesia
3339 3339       Iran 3/29/20 23:08 32.427908 53.688046 38309 2640 12391 23278 Iran
3340 3340       Iraq 3/29/20 23:08 33.223191 43.679291 547 42 143 362 Iraq
3341 3341       Ireland 3/29/20 23:08 53.1424 -7.6921 2615 46 5 2564 Ireland
3342 3342       Israel 3/29/20 23:08 31.046051 34.851612 4433 16 105 4100 Israel
3343 3343       Italy 3/29/20 23:08 41.87194 12.56738 97689 10779 13030 73880 Italy
3344 3344       Jamaica 3/29/20 23:08 18.1096 -77.2975 32 1 2 29 Jamaica
3345 3345       Japan 3/29/20 23:08 36.204824 138.252924 1866 54 424 1388 Japan
3346 3346       Jordan 3/29/20 23:08 31.24 36.51 259 3 18 238 Jordan
3347 3347       Kazakhstan 3/29/20 23:08 48.0196 66.9237 284 1 20 263 Kazakhstan
3348 3348       Kenya 3/29/20 23:08 -0.0236 37.9062 42 1 1 40 Kenya
3349 3349       Korea, South 3/29/20 23:08 35.907757 127.766922 9583 152 5033 4398 Korea, South
3350 3350       Kosovo 3/29/20 23:08 42.602636 20.902977 94 1 1 92 Kosovo
3351 3351       Kuwait 3/29/20 23:08 29.31166 47.481766 255 0 67 188 Kuwait
3352 3352       Kyrgyzstan 3/29/20 23:08 41.20438 74.766098 84 0 0 84 Kyrgyzstan
3353 3353       Laos 3/29/20 23:08 19.85627 102.495496 8 0 0 8 Laos
3354 3354       Latvia 3/29/20 23:08 56.8796 24.6032 347 0 1 346 Latvia
3355 3355       Lebanon 3/29/20 23:08 33.8547 35.8623 438 10 30 398 Lebanon
3356 3356       Liberia 3/29/20 23:08 6.428055 -9.429499 3 0 0 3 Liberia
3357 3357       Libya 3/29/20 23:08 26.3351 17.228331 8 0 0 8 Libya
3358 3358       Liechtenstein 3/29/20 23:08 47.14 9.55 56 0 0 56 Liechtenstein
3359 3359       Lithuania 3/29/20 23:08 55.1694 23.8813 378 4 0 452 Lithuania
3360 3360       Luxembourg 3/29/20 23:08 49.8153 6.1296 1950 21 40 1889 Luxembourg
3361 3361       MS Zaandam 3/29/20 23:08 0.0 0.0 2 0 0 2 ,,MS Zaandam
3362 3362       Madagascar 3/29/20 23:08 -18.766947 46.869107 39 0 0 39 Madagascar
3363 3363       Malaysia 3/29/20 23:08 4.210484 101.975766 2470 35 388 2047 Malaysia
3364 3364       Maldives 3/29/20 23:08 3.2028 73.2207 17 0 13 4 Maldives
3365 3365       Mali 3/29/20 23:08 17.570692 -3.996166 18 1 0 17 Mali
3366 3366       Malta 3/29/20 23:08 35.9375 14.3754 151 0 2 149 Malta
3367 3367       Mauritania 3/29/20 23:08 21.0079 -10.9408 5 0 2 3 ,,Mauritania
3368 3368       Mauritius 3/29/20 23:08 -20.348404 57.552152 107 3 0 104 Mauritius
3369 3369       Mexico 3/29/20 23:08 23.6345 -102.5528 848 16 4 828 Mexico
3370 3370       Moldova 3/29/20 23:08 47.4116 28.3699 263 2 2 259 Moldova
3371 3371       Monaco 3/29/20 23:08 43.7333 7.4167 46 1 1 44 Monaco
3372 3372       Mongolia 3/29/20 23:08 46.8625 103.8467 12 0 0 12 Mongolia
3373 3373       Montenegro 3/29/20 23:08 42.708678 19.37439 85 1 0 84 Montenegro
3374 3374       Morocco 3/29/20 23:08 31.7917 -7.0926 479 26 13 440 Morocco
3375 3375       Mozambique 3/29/20 23:08 -18.665695 35.529562 8 0 0 8 Mozambique
3376 3376       Namibia 3/29/20 23:08 -22.9576 18.4904 11 0 2 9 Namibia
3377 3377       Nepal 3/29/20 23:08 28.1667 84.25 5 0 1 4 Nepal
3179 3179     Aruba Netherlands 3/29/20 23:08 12.5211 -69.9683 50 0 1 49 Aruba, Netherlands
3188 3188     Curacao Netherlands 3/29/20 23:08 12.1696 -68.99 8 1 2 5 Curacao, Netherlands
3250 3250     Sint Maarten Netherlands 3/29/20 23:08 18.0425 -63.0548 6 0 0 6 Sint Maarten, Netherlands
3378 3378       Netherlands 3/29/20 23:08 52.1326 5.2913 10866 771 250 9845 Netherlands
3379 3379       New Zealand 3/29/20 23:08 -40.9006 174.886 514 1 56 457 New Zealand
3380 3380       Nicaragua 3/29/20 23:08 12.865416 -85.207229 4 1 0 3 Nicaragua
3381 3381       Niger 3/29/20 23:08 17.607789 8.081666 18 1 0 17 Niger
3382 3382       Nigeria 3/29/20 23:08 9.082 8.6753 111 1 3 107 Nigeria
3383 3383       North Macedonia 3/29/20 23:08 41.6086 21.7453 259 6 3 250 North Macedonia
3384 3384       Norway 3/29/20 23:08 60.472 8.4689 4284 25 7 4252 Norway
3385 3385       Oman 3/29/20 23:08 21.512583 55.923255 167 0 23 144 Oman
3386 3386       Pakistan 3/29/20 23:08 30.3753 69.3451 1597 14 29 1554 Pakistan
3387 3387       Panama 3/29/20 23:08 8.538 -80.7821 901 17 4 880 Panama
3388 3388       Papua New Guinea 3/29/20 23:08 -6.314993 143.95555 1 0 0 1 Papua New Guinea
3389 3389       Paraguay 3/29/20 23:08 -23.4425 -58.4438 59 3 1 55 Paraguay
3390 3390       Peru 3/29/20 23:08 -9.19 -75.0152 852 18 16 818 Peru
3391 3391       Philippines 3/29/20 23:08 12.879721 121.774017 1418 71 42 1305 Philippines
3392 3392       Poland 3/29/20 23:08 51.9194 19.1451 1862 22 7 1833 Poland

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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