03-25-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,423 rows sorted by Lat

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: Last_Update, 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-25 23:37:49 -42.8821 147.3272 36 0 3 33 Tasmania, Australia
3366 3366       New Zealand 2020-03-25 23:33:04 -40.9006 174.886 205 0 22 183 New Zealand
3260 3260       Argentina 2020-03-25 23:33:04 -38.4161 -63.6167 387 8 52 327 Argentina
3248 3248     Victoria Australia 2020-03-25 23:37:49 -37.8136 144.9631 466 0 97 369 Victoria, Australia
3284 3284       Chile 2020-03-25 23:33:04 -35.6751 -71.543 1142 3 22 1117 Chile
3174 3174     Australian Capital Territory Australia 2020-03-25 23:37:49 -35.4735 149.0124 39 0 0 39 Australian Capital Territory, Australia
3243 3243     South Australia Australia 2020-03-25 23:37:49 -34.9285 138.6007 170 0 6 164 South Australia, Australia
3218 3218     New South Wales Australia 2020-03-25 23:37:49 -33.8688 151.2093 1029 7 4 1018 New South Wales, Australia
3418 3418       Uruguay 2020-03-25 23:33:04 -32.5228 -55.7658 189 0 0 189 Uruguay
3250 3250     Western Australia Australia 2020-03-25 23:37:49 -31.9505 115.8605 175 1 1 173 Western Australia, Australia
3398 3398       South Africa 2020-03-25 23:33:04 -30.5595 22.9375 709 0 12 697 South Africa
3230 3230     Queensland Australia 2020-03-25 23:37:49 -27.4698 153.0251 443 0 8 435 Queensland, Australia
3305 3305       Eswatini 2020-03-25 23:33:04 -26.5225 31.4659 4 0 0 4 Eswatini
3376 3376       Paraguay 2020-03-25 23:33:04 -23.4425 -58.4438 37 3 0 34 Paraguay
3363 3363       Namibia 2020-03-25 23:33:04 -22.9576 18.4904 7 0 2 5 Namibia
3233 3233     Reunion France 2020-03-25 23:33:04 -21.1151 55.5364 111 0 1 110 Reunion, France
3217 3217     New Caledonia France 2020-03-25 23:33:04 -20.904304999999997 165.618042 14 0 0 14 New Caledonia, France
3355 3355       Mauritius 2020-03-25 23:33:04 -20.348404000000002 57.552152 48 2 0 46 Mauritius
3423 3423       Zimbabwe 2020-03-25 23:33:04 -19.015438 29.154857 3 1 0 2 Zimbabwe
3349 3349       Madagascar 2020-03-25 23:33:04 -18.766947000000002 46.869107 19 0 0 19 Madagascar
3362 3362       Mozambique 2020-03-25 23:33:04 -18.665695 35.529562 5 0 0 5 Mozambique
3307 3307       Fiji 2020-03-25 23:33:04 -17.7134 178.065 5 0 0 5 Fiji
3186 3186     French Polynesia France 2020-03-25 23:33:04 -17.6797 -149.4068 25 0 0 25 French Polynesia, France
3273 3273       Bolivia 2020-03-25 23:33:04 -16.2902 -63.5887 32 0 0 32 Bolivia
3171 3171 60000   American Samoa US 2020-03-25 23:33:19 -14.270999999999999 -170.132 0 0 0 0 American Samoa, US
3275 3275       Brazil 2020-03-25 23:33:04 -14.235 -51.9253 2554 59 2 2493 Brazil
3388 3388       Samoa 2020-03-25 23:37:36 -13.759 -172.1046 0 0 0 0 Samoa
3422 3422       Zambia 2020-03-25 23:33:04 -13.133897 27.849332 12 0 0 12 Zambia
3214 3214     Mayotte France 2020-03-25 23:33:04 -12.8275 45.166244 36 0 0 36 Mayotte, France
3222 3222     Northern Territory Australia 2020-03-25 23:37:49 -12.4634 130.8456 6 0 0 6 Northern Territory, Australia
3258 3258       Angola 2020-03-25 23:33:04 -11.2027 17.8739 3 0 0 3 Angola
3377 3377       Peru 2020-03-25 23:33:04 -9.19 -75.0152 480 9 1 470 Peru
3409 3409       Timor-Leste 2020-03-25 23:33:04 -8.874217 125.727539 1 0 0 1 Timor-Leste
3235 3235     Saint Helena, Ascension and Tristan da Cunha United Kingdom 2020-03-25 23:33:04 -7.9467 -14.3559 0 0 0 0 Saint Helena, Ascension and Tristan da Cunha, United Kingdom
3407 3407       Tanzania 2020-03-25 23:33:04 -6.369028 34.888822 12 0 0 12 Tanzania
3375 3375       Papua New Guinea 2020-03-25 23:33:04 -6.314993 143.95555 1 0 0 1 Papua New Guinea
3393 3393       Seychelles 2020-03-25 23:33:04 -4.6796 55.492 7 0 0 7 Seychelles
3287 3287       Congo (Kinshasa) 2020-03-25 23:33:04 -4.322447 15.307045 48 2 0 46 Congo (Kinshasa)
3286 3286       Congo (Brazzaville) 2020-03-25 23:33:04 -4.2634 15.2832 4 0 0 4 Congo (Brazzaville)
3384 3384       Rwanda 2020-03-25 23:33:04 -1.9403 29.8739 41 0 0 41 Rwanda
3299 3299       Ecuador 2020-03-25 23:33:04 -1.8312 -78.1834 1173 28 3 1142 Ecuador
3310 3310       Gabon 2020-03-25 23:33:04 -0.8037 11.6094 6 1 0 5 Gabon
3327 3327       Indonesia 2020-03-25 23:33:04 -0.7893 113.9213 790 58 31 701 Indonesia
3337 3337       Kenya 2020-03-25 23:33:04 -0.0236 37.9062 28 0 1 27 Kenya
2179 2179   Out of MI Michigan US 2020-03-25 23:33:19 0.0 0.0 7 0 0 0 Out of MI,Michigan,US
2180 2180   Out of TN Tennessee US 2020-03-25 23:33:19 0.0 0.0 100 0 0 0 Out of TN,Tennessee,US
2181 2181   Out of UT Utah US 2020-03-25 23:33:19 0.0 0.0 14 0 0 0 Out of UT,Utah,US
2857 2857   Unassigned Alaska US 2020-03-25 23:33:19 0.0 0.0 0 1 0 0 Unassigned, Alaska, US
2858 2858   Unassigned Arizona US 2020-03-25 23:33:19 0.0 0.0 0 2 0 0 Unassigned, Arizona, US
2859 2859   Unassigned Arkansas US 2020-03-25 23:33:19 0.0 0.0 20 1 0 0 Unassigned, Arkansas, US
2860 2860   Unassigned Colorado US 2020-03-25 23:33:19 0.0 0.0 18 0 0 0 Unassigned, Colorado, US
2861 2861   Unassigned Georgia US 2020-03-25 23:33:19 0.0 0.0 146 24 0 0 Unassigned, Georgia, US
2862 2862   Unassigned Hawaii US 2020-03-25 23:33:19 0.0 0.0 21 0 0 0 Unassigned, Hawaii, US
2863 2863   Unassigned Illinois US 2020-03-25 23:33:19 0.0 0.0 2 0 0 0 Unassigned, Illinois, US
2864 2864   Unassigned Kentucky US 2020-03-25 23:33:19 0.0 0.0 54 0 0 0 Unassigned, Kentucky, US
2865 2865   Unassigned Louisiana US 2020-03-25 23:33:19 0.0 0.0 11 1 0 0 Unassigned, Louisiana, US
2866 2866   Unassigned Maine US 2020-03-25 23:33:19 0.0 0.0 2 0 0 0 Unassigned, Maine, US
2867 2867   Unassigned Massachusetts US 2020-03-25 23:33:19 0.0 0.0 159 9 0 0 Unassigned, Massachusetts, US
2868 2868   Unassigned Missouri US 2020-03-25 23:33:19 0.0 0.0 0 0 0 0 Unassigned, Missouri, US
2869 2869   Unassigned Nevada US 2020-03-25 23:33:19 0.0 0.0 15 0 0 0 Unassigned, Nevada, US
2870 2870   Unassigned New Jersey US 2020-03-25 23:33:19 0.0 0.0 930 44 0 0 Unassigned, New Jersey, US
2871 2871   Unassigned New York US 2020-03-25 23:33:19 0.0 0.0 0 31 0 0 Unassigned, New York, US
2872 2872   Unassigned North Carolina US 2020-03-25 23:33:19 0.0 0.0 0 1 0 0 Unassigned, North Carolina, US
2873 2873   Unassigned Rhode Island US 2020-03-25 23:33:19 0.0 0.0 31 0 0 0 Unassigned, Rhode Island, US
2874 2874   Unassigned Tennessee US 2020-03-25 23:33:19 0.0 0.0 81 0 0 0 Unassigned, Tennessee, US
2875 2875   Unassigned Vermont US 2020-03-25 23:33:19 0.0 0.0 2 3 0 0 Unassigned, Vermont, US
2876 2876   Unassigned Washington US 2020-03-25 23:33:19 0.0 0.0 51 0 0 0 Unassigned, Washington, US
3182 3182     Diamond Princess Canada 2020-03-25 23:37:36 0.0 0.0 0 1 0 0 Diamond Princess, Canada
3183 3183 88888   Diamond Princess US 2020-03-25 23:33:19 0.0 0.0 49 0 0 0 Diamond Princess, US
3190 3190     Grand Princess Canada 2020-03-25 23:37:36 0.0 0.0 13 0 0 0 Grand Princess, Canada
3191 3191 99999   Grand Princess US 2020-03-25 23:33:19 0.0 0.0 28 1 0 0 Grand Princess, US
3231 3231     Recovered Canada 2020-03-25 23:37:36 0.0 0.0 0 0 183 0 Recovered, Canada
3232 3232     Recovered US 2020-03-25 23:33:19 0.0 0.0 0 0 361 0 Recovered, US
3295 3295       Diamond Princess 2020-03-25 23:33:04 0.0 0.0 712 10 587 115 Diamond Princess
3394 3394       Singapore 2020-03-25 23:33:04 1.2833 103.8333 631 2 160 469 Singapore
3414 3414       Uganda 2020-03-25 23:33:04 1.373333 32.290275 14 0 0 14 Uganda
3302 3302       Equatorial Guinea 2020-03-25 23:33:04 1.6508 10.2679 9 0 0 9 Equatorial Guinea
3351 3351       Maldives 2020-03-25 23:33:04 3.2028 73.2207 13 0 8 5 Maldives
3281 3281       Cameroon 2020-03-25 23:33:04 3.8480000000000003 11.5021 75 1 2 72 Cameroon
3402 3402       Suriname 2020-03-25 23:33:04 3.9193 -56.0278 8 0 0 8 Suriname
3185 3185     French Guiana France 2020-03-25 23:33:04 4.0 -53.0 28 0 6 22 French Guiana, France
3350 3350       Malaysia 2020-03-25 23:33:04 4.210483999999999 101.97576600000001 1796 20 199 1577 Malaysia
3276 3276       Brunei 2020-03-25 23:33:04 4.5353 114.7277 109 0 2 107 Brunei
3285 3285       Colombia 2020-03-25 23:33:04 4.5709 -74.2973 470 4 8 458 Colombia
3320 3320       Guyana 2020-03-25 23:33:04 4.860416000000002 -58.93018000000001 5 1 0 4 Guyana
3397 3397       Somalia 2020-03-25 23:33:04 5.152149 46.199616 1 0 0 1 Somalia
3420 3420       Venezuela 2020-03-25 23:33:04 6.4238 -66.5897 91 0 15 76 Venezuela
3344 3344       Liberia 2020-03-25 23:33:04 6.4280550000000005 -9.429499 3 0 0 3 Liberia
3282 3282       Central African Republic 2020-03-25 23:33:04 6.6111 20.9394 3 0 0 3 Central African Republic
3289 3289       Cote d'Ivoire 2020-03-25 23:33:04 7.54 -5.5471 80 0 3 77 Cote d'Ivoire
3400 3400       Sri Lanka 2020-03-25 23:33:04 7.873054 80.77179699999998 102 0 3 99 Sri Lanka
3314 3314       Ghana 2020-03-25 23:33:04 7.9465 -1.0232 93 4 0 89 Ghana
3374 3374       Panama 2020-03-25 23:33:04 8.538 -80.7821 443 8 1 434 Panama
3410 3410       Togo 2020-03-25 23:33:04 8.6195 0.8248 23 0 1 22 Togo
3369 3369       Nigeria 2020-03-25 23:33:04 9.082 8.6753 51 1 2 48 Nigeria
3306 3306       Ethiopia 2020-03-25 23:33:04 9.145 40.4897 12 0 0 12 Ethiopia
3271 3271       Benin 2020-03-25 23:33:04 9.3077 2.3158 6 0 0 6 Benin
3288 3288       Costa Rica 2020-03-25 23:33:04 9.7489 -83.7534 201 2 2 197 Costa Rica
3318 3318       Guinea 2020-03-25 23:33:04 9.9456 -9.6966 4 0 0 4 Guinea
3411 3411       Trinidad and Tobago 2020-03-25 23:33:04 10.6918 -61.2225 60 1 0 59 Trinidad and Tobago

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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