03-22-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,420 rows sorted by rowid descending

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: Last_Update

Link rowid ▲ FIPS Admin2 Province_State Country_Region Last_Update Lat Long_ Confirmed Deaths Recovered Active Combined_Key
3420 3420 53023 Garfield County Washington US 3/22/20 23:45 46.45197502 -117.5454032 1 2 0 0 Garfield County,Washington,US
3419 3419 11001 District of Columbia District of Columbia US 3/22/20 23:45 38.90417773 -77.01655992 102 2 0 0 District of Columbia,District of Columbia,US
3418 3418       Uganda 3/22/20 23:45 1.373333 32.290275 1 0 0 1 Uganda
3417 3417       Timor-Leste 3/22/20 23:45 -8.874217 125.727539 1 0 0 1 Timor-Leste
3416 3416       Syria 3/22/20 23:45 34.802075 38.996815 1 0 0 1 Syria
3415 3415       Somalia 3/22/20 23:45 5.152149 46.199616 1 0 0 1 Somalia
3414 3414     Sint Maarten Netherlands 3/22/20 23:45 18.0425 -63.0548 1 0 0 1 Sint Maarten, Netherlands
3413 3413       Samoa 3/22/20 23:48 -13.759 -172.1046 0 0 0 0 Samoa
3412 3412       Saint Vincent and the Grenadines 3/22/20 23:45 12.9843 -61.2872 1 0 0 1 Saint Vincent and the Grenadines
3411 3411       Papua New Guinea 3/22/20 23:45 -6.314993 143.95555 1 0 0 1 Papua New Guinea
3410 3410       Mozambique 3/22/20 23:45 -18.665695 35.529562 1 0 0 1 Mozambique
3409 3409     Montserrat United Kingdom 3/22/20 23:45 16.742498 -62.187366 1 0 0 1 Montserrat, United Kingdom
3408 3408       Holy See 3/22/20 23:45 41.9029 12.4534 1 0 0 1 Holy See
3407 3407       Grenada 3/22/20 23:45 12.1165 -61.679 1 0 0 1 Grenada
3406 3406       Gambia 3/22/20 23:45 13.4432 -15.3101 1 0 0 1 Gambia
3405 3405       Eritrea 3/22/20 23:45 15.1794 39.7823 1 0 0 1 Eritrea
3404 3404       Dominica 3/22/20 23:45 15.415 -61.371 1 0 0 1 Dominica
3403 3403       Djibouti 3/22/20 23:45 11.8251 42.5903 1 0 0 1 Djibouti
3402 3402       Chad 3/22/20 23:45 15.4542 18.7322 1 0 0 1 Chad
3401 3401       Antigua and Barbuda 3/22/20 23:45 17.0608 -61.7964 1 0 0 1 Antigua and Barbuda
3400 3400       Nepal 3/22/20 23:45 28.1667 84.25 1 0 1 0 Nepal
3399 3399       Saint Lucia 3/22/20 23:45 13.9094 -60.9789 2 0 0 2 Saint Lucia
3398 3398       Niger 3/22/20 23:45 17.607789 8.081666 2 0 0 2 Niger
3397 3397       Nicaragua 3/22/20 23:45 12.865416 -85.207229 2 0 0 2 Nicaragua
3396 3396       Mauritania 3/22/20 23:45 21.0079 10.9408 2 0 0 2 Mauritania
3395 3395       Haiti 3/22/20 23:45 18.9712 -72.2852 2 0 0 2 Haiti
3394 3394       Guinea 3/22/20 23:45 9.9456 -9.6966 2 0 0 2 Guinea
3393 3393       Fiji 3/22/20 23:45 -17.7134 178.065 2 0 0 2 Fiji
3392 3392       Bhutan 3/22/20 23:45 27.5142 90.4336 2 0 0 2 Bhutan
3391 3391     Bermuda United Kingdom 3/22/20 23:45 32.3078 -64.7505 2 0 0 2 Bermuda, United Kingdom
3390 3390       Benin 3/22/20 23:45 9.3077 2.3158 2 0 0 2 Benin
3389 3389       Angola 3/22/20 23:45 -11.2027 17.8739 2 0 0 2 Angola
3388 3388       Sudan 3/22/20 23:45 12.8628 30.2176 2 1 0 1 Sudan
3387 3387       Zimbabwe 3/22/20 23:45 -19.015438 29.154857 3 0 0 3 Zimbabwe
3386 3386       Zambia 3/22/20 23:45 -13.133897 27.849332 3 0 0 3 Zambia
3385 3385     Saint Helena, Ascension and Tristan da Cunha United Kingdom 3/22/20 23:45 -7.9467 -14.3559 0 0 0 0 Saint Helena, Ascension and Tristan da Cunha, United Kingdom
3384 3384     Saint Barthelemy France 3/22/20 23:45 17.9 -62.8333 3 0 0 3 Saint Barthelemy, France
3383 3383       Namibia 3/22/20 23:45 -22.9576 18.4904 3 0 0 3 Namibia
3382 3382       Madagascar 3/22/20 23:45 -18.766947 46.869107 3 0 0 3 Madagascar
3381 3381       Liberia 3/22/20 23:45 6.428055 -9.429499 3 0 0 3 Liberia
3380 3380       El Salvador 3/22/20 23:45 13.7942 -88.8965 3 0 0 3 El Salvador
3379 3379       Congo (Brazzaville) 3/22/20 23:45 -4.2634 15.2832 3 0 0 3 Congo (Brazzaville)
3378 3378       Central African Republic 3/22/20 23:45 6.6111 20.9394 3 0 0 3 Central African Republic
3377 3377       Cabo Verde 3/22/20 23:45 16.5388 -23.0418 3 0 0 3 Cabo Verde
3376 3376     Curacao Netherlands 3/22/20 23:45 12.1696 -68.99 3 1 0 2 Curacao, Netherlands
3375 3375     Cayman Islands United Kingdom 3/22/20 23:45 19.3133 -81.2546 3 1 0 2 Cayman Islands, United Kingdom
3374 3374       Eswatini 3/22/20 23:45 -26.5225 31.4659 4 0 0 4 Eswatini
3373 3373     New Caledonia France 3/22/20 23:45 -20.904305 165.618042 4 0 0 4 New Caledonia, France
3372 3372     Greenland Denmark 3/22/20 23:45 71.7069 -42.6043 4 0 0 4 Greenland, Denmark
3371 3371       Bahamas 3/22/20 23:45 25.025885 -78.035889 4 0 0 4 Bahamas
3370 3370       Suriname 3/22/20 23:45 3.9193 -56.0278 5 0 0 5 Suriname
3369 3369     St Martin France 3/22/20 23:45 18.0708 -63.0501 5 0 0 5 St Martin, France
3368 3368     Isle of Man United Kingdom 3/22/20 23:45 54.2361 -4.5481 5 0 0 5 Isle of Man, United Kingdom
3367 3367       Gabon 3/22/20 23:45 -0.8037 11.6094 5 1 0 4 Gabon
3366 3366       Equatorial Guinea 3/22/20 23:45 1.6508 10.2679 6 0 0 6 Equatorial Guinea
3365 3365       Seychelles 3/22/20 23:45 -4.6796 55.492 7 0 0 7 Seychelles
3364 3364     Aruba Netherlands 3/22/20 23:45 12.5211 -69.9683 9 0 1 8 Aruba, Netherlands
3363 3363       Mongolia 3/22/20 23:45 46.8625 103.8467 10 0 0 10 Mongolia
3362 3362     Mayotte France 3/22/20 23:45 -12.8275 45.166244 11 0 0 11 Mayotte, France
3361 3361       Ethiopia 3/22/20 23:45 9.145 40.4897 11 0 0 11 Ethiopia
3360 3360       Tanzania 3/22/20 23:45 -6.369028 34.888822 12 0 0 12 Tanzania
3359 3359       Maldives 3/22/20 23:45 3.2028 73.2207 13 0 3 10 Maldives
3358 3358       Kyrgyzstan 3/22/20 23:45 41.20438 74.766098 14 0 0 14 Kyrgyzstan
3357 3357       Cote d'Ivoire 3/22/20 23:45 7.54 -5.5471 14 0 1 13 Cote d'Ivoire
3356 3356       Barbados 3/22/20 23:45 13.1939 -59.5432 14 0 0 14 Barbados
3355 3355       Kenya 3/22/20 23:45 -0.0236 37.9062 15 0 0 15 Kenya
3354 3354     Gibraltar United Kingdom 3/22/20 23:45 36.1408 -5.3536 15 0 2 13 Gibraltar, United Kingdom
3353 3353     French Polynesia France 3/22/20 23:45 -17.6797 149.4068 15 0 0 15 French Polynesia, France
3352 3352       Togo 3/22/20 23:45 8.6195 0.8248 16 0 0 16 Togo
3351 3351     French Guiana France 3/22/20 23:45 4.0 -53.0 18 0 0 18 French Guiana, France
3350 3350       Guyana 3/22/20 23:45 4.860416 -58.93018 18 1 0 17 Guyana
3349 3349       Rwanda 3/22/20 23:45 -1.9403 29.8739 19 0 0 19 Rwanda
3348 3348       Jamaica 3/22/20 23:45 18.1096 -77.2975 19 1 2 16 Jamaica
3347 3347       Guatemala 3/22/20 23:45 15.7835 -90.2308 19 1 0 18 Guatemala
3346 3346       Montenegro 3/22/20 23:45 42.708678 19.37439 21 0 0 21 Montenegro
3345 3345       Paraguay 3/22/20 23:45 -23.4425 -58.4438 22 1 0 21 Paraguay
3344 3344       Monaco 3/22/20 23:45 43.7333 7.4167 23 0 1 22 Monaco
3343 3343       Ghana 3/22/20 23:45 7.9465 -1.0232 23 1 0 22 Ghana
3342 3342       Bolivia 3/22/20 23:45 -16.2902 -63.5887 24 0 0 24 Bolivia
3341 3341       Honduras 3/22/20 23:45 15.2 -86.2419 26 0 0 26 Honduras
3340 3340       Bangladesh 3/22/20 23:45 23.685 90.3563 27 2 3 22 Bangladesh
3339 3339       Mauritius 3/22/20 23:45 -20.348404 57.552152 28 2 0 26 Mauritius
3338 3338       Nigeria 3/22/20 23:45 9.082 8.6753 30 0 2 28 Nigeria
3337 3337       Congo (Kinshasa) 3/22/20 23:45 -4.322447 15.307045 30 1 0 29 Congo (Kinshasa)
3336 3336     Channel Islands United Kingdom 3/22/20 23:45 49.3723 -2.3644 32 0 0 32 Channel Islands, United Kingdom
3335 3335       Cuba 3/22/20 23:45 21.521757 -77.781167 35 1 0 34 Cuba
3334 3334       Liechtenstein 3/22/20 23:45 47.14 9.55 37 0 0 37 Liechtenstein
3333 3333     Martinique France 3/22/20 23:45 14.6415 -61.0242 37 1 0 36 Martinique, France
3332 3332       Cameroon 3/22/20 23:45 3.848 11.5021 40 0 2 38 Cameroon
3331 3331       Afghanistan 3/22/20 23:45 33.93911 67.709953 34 1 1 38 Afghanistan
3330 3330       Uzbekistan 3/22/20 23:45 41.377491 64.585262 43 0 0 43 Uzbekistan
3329 3329     Reunion France 3/22/20 23:45 -21.1151 55.5364 47 0 1 46 Reunion, France
3328 3328       Trinidad and Tobago 3/22/20 23:45 10.6918 -61.2225 50 0 0 50 Trinidad and Tobago
3327 3327       Georgia 3/22/20 23:45 42.3154 43.3569 54 0 1 53 Georgia
3326 3326       Oman 3/22/20 23:45 21.512583 55.923255 55 0 17 38 Oman
3325 3325     Guadeloupe France 3/22/20 23:45 16.265 -61.551 56 1 0 55 Guadeloupe, France
3324 3324       Kazakhstan 3/22/20 23:45 48.0196 66.9237 60 0 0 59 Kazakhstan
3323 3323       Azerbaijan 3/22/20 23:45 40.1431 47.5769 65 1 11 53 Azerbaijan
3322 3322       Senegal 3/22/20 23:45 14.4974 -14.4524 67 0 5 62 Senegal
3321 3321       Venezuela 3/22/20 23:45 6.4238 -66.5897 70 0 15 55 Venezuela

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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