03-24-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,419 rows sorted by Lat

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: Last_Update (date)

Link rowid FIPS Admin2 Province_State Country_Region Last_Update Lat ▼ Long_ Confirmed Deaths Recovered Active Combined_Key
3245 3245     Tasmania Australia 2020-03-24 23:41:50 -42.8821 147.3272 28 0 3 25 Tasmania, Australia
3363 3363       New Zealand 2020-03-24 23:37:15 -40.9006 174.886 155 0 12 143 New Zealand
3260 3260       Argentina 2020-03-24 23:37:15 -38.4161 -63.6167 387 6 52 329 Argentina
3248 3248     Victoria Australia 2020-03-24 23:41:50 -37.8136 144.9631 411 0 97 314 Victoria, Australia
3284 3284       Chile 2020-03-24 23:37:15 -35.6751 -71.543 922 2 17 903 Chile
3174 3174     Australian Capital Territory Australia 2020-03-24 23:41:50 -35.4735 149.0124 39 0 0 39 Australian Capital Territory, Australia
3243 3243     South Australia Australia 2020-03-24 23:41:50 -34.9285 138.6007 170 0 6 164 South Australia, Australia
3218 3218     New South Wales Australia 2020-03-24 23:41:50 -33.8688 151.2093 818 7 4 807 New South Wales, Australia
3414 3414       Uruguay 2020-03-24 23:37:15 -32.5228 -55.7658 162 0 0 162 Uruguay
3250 3250     Western Australia Australia 2020-03-24 23:41:50 -31.9505 115.8605 175 1 1 173 Western Australia, Australia
3394 3394       South Africa 2020-03-24 23:37:15 -30.5595 22.9375 554 0 4 550 South Africa
3230 3230     Queensland Australia 2020-03-24 23:41:50 -27.4698 153.0251 397 0 8 389 Queensland, Australia
3304 3304       Eswatini 2020-03-24 23:37:15 -26.5225 31.4659 4 0 0 4 Eswatini
3373 3373       Paraguay 2020-03-24 23:37:15 -23.4425 -58.4438 27 2 0 25 Paraguay
3360 3360       Namibia 2020-03-24 23:37:15 -22.9576 18.4904 7 0 2 5 Namibia
3233 3233     Reunion France 2020-03-24 23:37:15 -21.1151 55.5364 94 0 1 93 Reunion, France
3217 3217     New Caledonia France 2020-03-24 23:37:15 -20.904304999999997 165.618042 10 0 0 10 New Caledonia, France
3352 3352       Mauritius 2020-03-24 23:37:15 -20.348404000000002 57.552152 42 2 0 40 Mauritius
3419 3419       Zimbabwe 2020-03-24 23:37:15 -19.015438 29.154857 3 1 0 2 Zimbabwe
3347 3347       Madagascar 2020-03-24 23:37:15 -18.766947000000002 46.869107 17 0 0 17 Madagascar
3359 3359       Mozambique 2020-03-24 23:37:15 -18.665695 35.529562 3 0 0 3 Mozambique
3306 3306       Fiji 2020-03-24 23:37:15 -17.7134 178.065 4 0 0 4 Fiji
3186 3186     French Polynesia France 2020-03-24 23:37:15 -17.6797 -149.4068 25 0 0 25 French Polynesia, France
3273 3273       Bolivia 2020-03-24 23:37:15 -16.2902 -63.5887 29 0 0 29 Bolivia
3171 3171 60000   American Samoa US 2020-03-24 23:37:31 -14.270999999999999 -170.132 0 0 0 0 American Samoa, US
3275 3275       Brazil 2020-03-24 23:37:15 -14.235 -51.9253 2247 46 2 2199 Brazil
3384 3384       Samoa 2020-03-24 23:41:36 -13.759 -172.1046 0 0 0 0 Samoa
3418 3418       Zambia 2020-03-24 23:37:15 -13.133897 27.849332 3 0 0 3 Zambia
3214 3214     Mayotte France 2020-03-24 23:37:15 -12.8275 45.166244 36 0 0 36 Mayotte, France
3222 3222     Northern Territory Australia 2020-03-24 23:41:50 -12.4634 130.8456 6 0 0 6 Northern Territory, Australia
3258 3258       Angola 2020-03-24 23:37:15 -11.2027 17.8739 3 0 0 3 Angola
3374 3374       Peru 2020-03-24 23:37:15 -9.19 -75.0152 416 7 1 408 Peru
3405 3405       Timor-Leste 2020-03-24 23:37:15 -8.874217 125.727539 1 0 0 1 Timor-Leste
3235 3235     Saint Helena, Ascension and Tristan da Cunha United Kingdom 2020-03-24 23:37:15 -7.9467 -14.3559 0 0 0 0 Saint Helena, Ascension and Tristan da Cunha, United Kingdom
3403 3403       Tanzania 2020-03-24 23:37:15 -6.369028 34.888822 12 0 0 12 Tanzania
3372 3372       Papua New Guinea 2020-03-24 23:37:15 -6.314993 143.95555 1 0 0 1 Papua New Guinea
3389 3389       Seychelles 2020-03-24 23:37:15 -4.6796 55.492 7 0 0 7 Seychelles
3287 3287       Congo (Kinshasa) 2020-03-24 23:37:15 -4.322447 15.307045 45 2 0 43 Congo (Kinshasa)
3286 3286       Congo (Brazzaville) 2020-03-24 23:37:15 -4.2634 15.2832 4 0 0 4 Congo (Brazzaville)
3381 3381       Rwanda 2020-03-24 23:37:15 -1.9403 29.8739 40 0 0 40 Rwanda
3298 3298       Ecuador 2020-03-24 23:37:15 -1.8312 -78.1834 1082 27 3 1052 Ecuador
3309 3309       Gabon 2020-03-24 23:37:15 -0.8037 11.6094 6 1 0 5 Gabon
3325 3325       Indonesia 2020-03-24 23:37:15 -0.7893 113.9213 686 55 30 601 Indonesia
3335 3335       Kenya 2020-03-24 23:37:15 -0.0236 37.9062 25 0 0 25 Kenya
2179 2179   Out of MI Michigan US 2020-03-24 23:37:31 0.0 0.0 6 0 0 0 Out of MI,Michigan,US
2180 2180   Out of TN Tennessee US 2020-03-24 23:37:31 0.0 0.0 95 0 0 0 Out of TN,Tennessee,US
2181 2181   Out of UT Utah US 2020-03-24 23:37:31 0.0 0.0 13 0 0 0 Out of UT,Utah,US
2857 2857   Unassigned Arizona US 2020-03-24 23:37:31 0.0 0.0 0 2 0 0 Unassigned, Arizona, US
2858 2858   Unassigned Arkansas US 2020-03-24 23:37:31 0.0 0.0 13 1 0 0 Unassigned, Arkansas, US
2859 2859   Unassigned Colorado US 2020-03-24 23:37:31 0.0 0.0 5 0 0 0 Unassigned, Colorado, US
2860 2860   Unassigned Florida US 2020-03-24 23:37:31 0.0 0.0 0 1 0 0 Unassigned, Florida, US
2861 2861   Unassigned Georgia US 2020-03-24 23:37:31 0.0 0.0 81 17 0 0 Unassigned, Georgia, US
2862 2862   Unassigned Hawaii US 2020-03-24 23:37:31 0.0 0.0 20 0 0 0 Unassigned, Hawaii, US
2863 2863   Unassigned Illinois US 2020-03-24 23:37:31 0.0 0.0 0 4 0 0 Unassigned, Illinois, US
2864 2864   Unassigned Iowa US 2020-03-24 23:37:31 0.0 0.0 2 0 0 0 Unassigned, Iowa, US
2865 2865   Unassigned Kentucky US 2020-03-24 23:37:31 0.0 0.0 46 0 0 0 Unassigned, Kentucky, US
2866 2866   Unassigned Louisiana US 2020-03-24 23:37:31 0.0 0.0 12 1 0 0 Unassigned, Louisiana, US
2867 2867   Unassigned Massachusetts US 2020-03-24 23:37:31 0.0 0.0 85 9 0 0 Unassigned, Massachusetts, US
2868 2868   Unassigned Missouri US 2020-03-24 23:37:31 0.0 0.0 6 0 0 0 Unassigned, Missouri, US
2869 2869   Unassigned Montana US 2020-03-24 23:37:31 0.0 0.0 6 0 0 0 Unassigned, Montana, US
2870 2870   Unassigned Nevada US 2020-03-24 23:37:31 0.0 0.0 15 0 0 0 Unassigned, Nevada, US
2871 2871   Unassigned New Jersey US 2020-03-24 23:37:31 0.0 0.0 645 26 0 0 Unassigned, New Jersey, US
2872 2872   Unassigned New York US 2020-03-24 23:37:31 0.0 0.0 0 39 0 0 Unassigned, New York, US
2873 2873   Unassigned Rhode Island US 2020-03-24 23:37:31 0.0 0.0 23 0 0 0 Unassigned, Rhode Island, US
2874 2874   Unassigned Tennessee US 2020-03-24 23:37:31 0.0 0.0 38 0 0 0 Unassigned, Tennessee, US
2875 2875   Unassigned Vermont US 2020-03-24 23:37:31 0.0 0.0 0 2 0 0 Unassigned, Vermont, US
2876 2876   Unassigned Washington US 2020-03-24 23:37:31 0.0 0.0 112 0 0 0 Unassigned, Washington, US
3182 3182     Diamond Princess Canada 2020-03-24 23:41:36 0.0 0.0 0 1 0 0 Diamond Princess, Canada
3183 3183 88888   Diamond Princess US 2020-03-24 23:37:31 0.0 0.0 49 0 0 0 Diamond Princess, US
3190 3190     Grand Princess Canada 2020-03-24 23:41:36 0.0 0.0 13 0 0 0 Grand Princess, Canada
3191 3191 99999   Grand Princess US 2020-03-24 23:37:31 0.0 0.0 28 1 0 0 Grand Princess, US
3231 3231     Recovered Canada 2020-03-24 23:41:36 0.0 0.0 0 0 110 0 Recovered, Canada
3232 3232     Recovered US 2020-03-24 23:37:31 0.0 0.0 0 0 348 0 Recovered, US
3390 3390       Singapore 2020-03-24 23:37:15 1.2833 103.8333 558 2 156 400 Singapore
3410 3410       Uganda 2020-03-24 23:37:15 1.373333 32.290275 9 0 0 9 Uganda
3301 3301       Equatorial Guinea 2020-03-24 23:37:15 1.6508 10.2679 9 0 0 9 Equatorial Guinea
3349 3349       Maldives 2020-03-24 23:37:15 3.2028 73.2207 13 0 5 8 Maldives
3281 3281       Cameroon 2020-03-24 23:37:15 3.8480000000000003 11.5021 66 0 2 64 Cameroon
3398 3398       Suriname 2020-03-24 23:37:15 3.9193 -56.0278 7 0 0 7 Suriname
3185 3185     French Guiana France 2020-03-24 23:37:15 4.0 -53.0 23 0 6 17 French Guiana, France
3348 3348       Malaysia 2020-03-24 23:37:15 4.210483999999999 101.97576600000001 1624 16 183 1425 Malaysia
3276 3276       Brunei 2020-03-24 23:37:15 4.5353 114.7277 104 0 2 102 Brunei
3285 3285       Colombia 2020-03-24 23:37:15 4.5709 -74.2973 378 3 6 369 Colombia
3318 3318       Guyana 2020-03-24 23:37:15 4.860416000000002 -58.93018000000001 5 1 0 4 Guyana
3393 3393       Somalia 2020-03-24 23:37:15 5.152149 46.199616 1 0 0 1 Somalia
3416 3416       Venezuela 2020-03-24 23:37:15 6.4238 -66.5897 84 0 15 69 Venezuela
3342 3342       Liberia 2020-03-24 23:37:15 6.4280550000000005 -9.429499 3 0 0 3 Liberia
3282 3282       Central African Republic 2020-03-24 23:37:15 6.6111 20.9394 3 0 0 3 Central African Republic
3289 3289       Cote d'Ivoire 2020-03-24 23:37:15 7.54 -5.5471 73 0 2 71 Cote d'Ivoire
3396 3396       Sri Lanka 2020-03-24 23:37:15 7.873054 80.77179699999998 102 0 2 100 Sri Lanka
3313 3313       Ghana 2020-03-24 23:37:15 7.9465 -1.0232 53 2 0 51 Ghana
3371 3371       Panama 2020-03-24 23:37:15 8.538 -80.7821 345 6 1 338 Panama
3406 3406       Togo 2020-03-24 23:37:15 8.6195 0.8248 20 0 1 19 Togo
3366 3366       Nigeria 2020-03-24 23:37:15 9.082 8.6753 44 1 2 41 Nigeria
3305 3305       Ethiopia 2020-03-24 23:37:15 9.145 40.4897 12 0 0 12 Ethiopia
3271 3271       Benin 2020-03-24 23:37:15 9.3077 2.3158 6 0 0 6 Benin
3288 3288       Costa Rica 2020-03-24 23:37:15 9.7489 -83.7534 177 2 2 173 Costa Rica
3317 3317       Guinea 2020-03-24 23:37:15 9.9456 -9.6966 4 0 0 4 Guinea
3407 3407       Trinidad and Tobago 2020-03-24 23:37:15 10.6918 -61.2225 57 0 0 57 Trinidad and Tobago
3280 3280       Cambodia 2020-03-24 23:37:15 11.55 104.9167 91 0 4 87 Cambodia

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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