03-23-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,416 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-23 23:23:20 -42.8821 147.3272 28 0 3 25 Tasmania, Australia
3360 3360       New Zealand 2020-03-23 23:19:21 -40.9006 174.886 102 0 0 102 New Zealand
3260 3260       Argentina 2020-03-23 23:19:21 -38.4161 -63.6167 266 4 27 235 Argentina
3248 3248     Victoria Australia 2020-03-23 23:23:20 -37.8136 144.9631 355 0 97 258 Victoria, Australia
3284 3284       Chile 2020-03-23 23:19:21 -35.6751 -71.543 746 2 11 733 Chile
3175 3175     Australian Capital Territory Australia 2020-03-23 23:23:20 -35.4735 149.0124 32 0 0 32 Australian Capital Territory, Australia
3243 3243     South Australia Australia 2020-03-23 23:23:20 -34.9285 138.6007 134 0 6 128 South Australia, Australia
3220 3220     New South Wales Australia 2020-03-23 23:23:20 -33.8688 151.2093 669 6 4 659 New South Wales, Australia
3411 3411       Uruguay 2020-03-23 23:19:21 -32.5228 -55.7658 158 0 0 158 Uruguay
3250 3250     Western Australia Australia 2020-03-23 23:23:20 -31.9505 115.8605 140 1 1 138 Western Australia, Australia
3391 3391       South Africa 2020-03-23 23:19:21 -30.5595 22.9375 402 0 4 398 South Africa
3232 3232     Queensland Australia 2020-03-23 23:23:20 -27.4698 153.0251 319 0 8 311 Queensland, Australia
3304 3304       Eswatini 2020-03-23 23:19:21 -26.5225 31.4659 4 0 0 4 Eswatini
3370 3370       Paraguay 2020-03-23 23:19:21 -23.4425 -58.4438 22 1 0 21 Paraguay
3357 3357       Namibia 2020-03-23 23:19:21 -22.9576 18.4904 4 0 0 4 Namibia
3233 3233     Reunion France 2020-03-23 23:19:21 -21.1151 55.5364 71 0 1 70 Reunion, France
3219 3219     New Caledonia France 2020-03-23 23:19:21 -20.904304999999997 165.618042 8 0 0 8 New Caledonia, France
3349 3349       Mauritius 2020-03-23 23:19:21 -20.348404000000002 57.552152 36 2 0 34 Mauritius
3416 3416       Zimbabwe 2020-03-23 23:19:21 -19.015438 29.154857 3 1 0 2 Zimbabwe
3344 3344       Madagascar 2020-03-23 23:19:21 -18.766947000000002 46.869107 12 0 0 12 Madagascar
3356 3356       Mozambique 2020-03-23 23:19:21 -18.665695 35.529562 1 0 0 1 Mozambique
3306 3306       Fiji 2020-03-23 23:19:21 -17.7134 178.065 3 0 0 3 Fiji
3188 3188     French Polynesia France 2020-03-23 23:19:21 -17.6797 -149.4068 19874 860 2200 16814 French Polynesia, France
3273 3273       Bolivia 2020-03-23 23:19:21 -16.2902 -63.5887 27 0 0 27 Bolivia
3172 3172 60000   American Samoa US 2020-03-23 23:19:34 -14.270999999999999 -170.132 0 0 0 0 American Samoa, US
3275 3275       Brazil 2020-03-23 23:19:21 -14.235 -51.9253 1924 34 2 1888 Brazil
3381 3381       Samoa 2020-03-23 23:23:10 -13.759 -172.1046 0 0 0 0 Samoa
3415 3415       Zambia 2020-03-23 23:19:21 -13.133897 27.849332 3 0 0 3 Zambia
3216 3216     Mayotte France 2020-03-23 23:19:21 -12.8275 45.166244 24 0 0 24 Mayotte, France
3224 3224     Northern Territory Australia 2020-03-23 23:23:20 -12.4634 130.8456 5 0 0 5 Northern Territory, Australia
3258 3258       Angola 2020-03-23 23:19:21 -11.2027 17.8739 3 0 0 3 Angola
3371 3371       Peru 2020-03-23 23:19:21 -9.19 -75.0152 395 5 1 389 Peru
3402 3402       Timor-Leste 2020-03-23 23:19:21 -8.874217 125.727539 1 0 0 1 Timor-Leste
3235 3235     Saint Helena, Ascension and Tristan da Cunha United Kingdom 2020-03-23 23:19:21 -7.9467 -14.3559 0 0 0 0 Saint Helena, Ascension and Tristan da Cunha, United Kingdom
3400 3400       Tanzania 2020-03-23 23:19:21 -6.369028 34.888822 12 0 0 12 Tanzania
3369 3369       Papua New Guinea 2020-03-23 23:19:21 -6.314993 143.95555 1 0 0 1 Papua New Guinea
3386 3386       Seychelles 2020-03-23 23:19:21 -4.6796 55.492 7 0 0 7 Seychelles
3287 3287       Congo (Kinshasa) 2020-03-23 23:19:21 -4.322447 15.307045 36 1 0 35 Congo (Kinshasa)
3286 3286       Congo (Brazzaville) 2020-03-23 23:19:21 -4.2634 15.2832 4 0 0 4 Congo (Brazzaville)
3378 3378       Rwanda 2020-03-23 23:19:21 -1.9403 29.8739 36 0 0 36 Rwanda
3298 3298       Ecuador 2020-03-23 23:19:21 -1.8312 -78.1834 981 18 3 960 Ecuador
3308 3308       Gabon 2020-03-23 23:19:21 -0.8037 11.6094 5 1 0 4 Gabon
3324 3324       Indonesia 2020-03-23 23:19:21 -0.7893 113.9213 579 49 30 500 Indonesia
3334 3334       Kenya 2020-03-23 23:19:21 -0.0236 37.9062 16 0 0 16 Kenya
2179 2179   Out of MI Michigan US 2020-03-23 23:19:34 0.0 0.0 4 0 0 0 Out of MI,Michigan,US
2180 2180   Out of TN Tennessee US 2020-03-23 23:19:34 0.0 0.0 89 0 0 0 Out of TN,Tennessee,US
2181 2181   Out of UT Utah US 2020-03-23 23:19:34 0.0 0.0 13 0 0 0 Out of UT,Utah,US
2857 2857   Unassigned Arkansas US 2020-03-23 23:19:34 0.0 0.0 3 0 0 0 Unassigned, Arkansas, US
2858 2858   Unassigned Colorado US 2020-03-23 23:19:34 0.0 0.0 1 0 0 0 Unassigned, Colorado, US
2859 2859   Unassigned Florida US 2020-03-23 23:19:34 0.0 0.0 0 1 0 0 Unassigned, Florida, US
2860 2860   Unassigned Georgia US 2020-03-23 23:19:34 0.0 0.0 45 10 0 0 Unassigned, Georgia, US
2861 2861   Unassigned Illinois US 2020-03-23 23:19:34 0.0 0.0 63 0 0 0 Unassigned, Illinois, US
2862 2862   Unassigned Indiana US 2020-03-23 23:19:34 0.0 0.0 56 16 0 0 Unassigned, Indiana, US
2863 2863   Unassigned Kentucky US 2020-03-23 23:19:34 0.0 0.0 15 0 0 0 Unassigned, Kentucky, US
2864 2864   Unassigned Louisiana US 2020-03-23 23:19:34 0.0 0.0 11 0 0 0 Unassigned, Louisiana, US
2865 2865   Unassigned Maine US 2020-03-23 23:19:34 0.0 0.0 5 0 0 0 Unassigned, Maine, US
2866 2866   Unassigned Massachusetts US 2020-03-23 23:19:34 0.0 0.0 53 7 0 0 Unassigned, Massachusetts, US
2867 2867   Unassigned Minnesota US 2020-03-23 23:19:34 0.0 0.0 1 0 0 0 Unassigned, Minnesota, US
2868 2868   Unassigned Missouri US 2020-03-23 23:19:34 0.0 0.0 4 0 0 0 Unassigned, Missouri, US
2869 2869   Unassigned Montana US 2020-03-23 23:19:34 0.0 0.0 1 0 0 0 Unassigned, Montana, US
2870 2870   Unassigned Nevada US 2020-03-23 23:19:34 0.0 0.0 89 0 0 0 Unassigned, Nevada, US
2871 2871   Unassigned New Hampshire US 2020-03-23 23:19:34 0.0 0.0 23 0 0 0 Unassigned, New Hampshire, US
2872 2872   Unassigned New Jersey US 2020-03-23 23:19:34 0.0 0.0 419 9 0 0 Unassigned, New Jersey, US
2873 2873   Unassigned New York US 2020-03-23 23:19:34 0.0 0.0 107 36 0 0 Unassigned, New York, US
2874 2874   Unassigned Rhode Island US 2020-03-23 23:19:34 0.0 0.0 5 0 0 0 Unassigned, Rhode Island, US
2875 2875   Unassigned Tennessee US 2020-03-23 23:19:34 0.0 0.0 54 0 0 0 Unassigned, Tennessee, US
2876 2876   Unassigned Vermont US 2020-03-23 23:19:34 0.0 0.0 0 3 0 0 Unassigned, Vermont, US
2877 2877   Unassigned Washington US 2020-03-23 23:19:34 0.0 0.0 145 0 0 0 Unassigned, Washington, US
3183 3183     Diamond Princess Canada 2020-03-23 23:23:10 0.0 0.0 0 1 0 0 Diamond Princess, Canada
3184 3184     Diamond Princess Cruise Ship 2020-03-23 23:19:21 0.0 0.0 712 8 567 137 Diamond Princess, Cruise Ship
3185 3185 88888   Diamond Princess US 2020-03-23 23:19:34 0.0 0.0 49 0 0 0 Diamond Princess, US
3192 3192     Grand Princess Canada 2020-03-23 23:23:10 0.0 0.0 13 0 0 0 Grand Princess, Canada
3193 3193 99999   Grand Princess US 2020-03-23 23:19:34 0.0 0.0 28 1 0 0 Grand Princess, US
3387 3387       Singapore 2020-03-23 23:19:21 1.2833 103.8333 509 2 152 355 Singapore
3407 3407       Uganda 2020-03-23 23:19:21 1.373333 32.290275 9 0 0 9 Uganda
3301 3301       Equatorial Guinea 2020-03-23 23:19:21 1.6508 10.2679 9 0 0 9 Equatorial Guinea
3346 3346       Maldives 2020-03-23 23:19:21 3.2028 73.2207 13 0 5 8 Maldives
3281 3281       Cameroon 2020-03-23 23:19:21 3.8480000000000003 11.5021 56 0 2 54 Cameroon
3395 3395       Suriname 2020-03-23 23:19:21 3.9193 -56.0278 5 0 0 5 Suriname
3187 3187     French Guiana France 2020-03-23 23:19:21 4.0 -53.0 20 0 6 14 French Guiana, France
3345 3345       Malaysia 2020-03-23 23:19:21 4.210483999999999 101.97576600000001 1518 14 159 1345 Malaysia
3276 3276       Brunei 2020-03-23 23:19:21 4.5353 114.7277 91 0 2 89 Brunei
3285 3285       Colombia 2020-03-23 23:19:21 4.5709 -74.2973 277 3 3 271 Colombia
3317 3317       Guyana 2020-03-23 23:19:21 4.860416000000002 -58.93018000000001 20 1 0 19 Guyana
3390 3390       Somalia 2020-03-23 23:19:21 5.152149 46.199616 1 0 0 1 Somalia
3413 3413       Venezuela 2020-03-23 23:19:21 6.4238 -66.5897 77 0 15 62 Venezuela
3340 3340       Liberia 2020-03-23 23:19:21 6.4280550000000005 -9.429499 3 0 0 3 Liberia
3282 3282       Central African Republic 2020-03-23 23:19:21 6.6111 20.9394 3 0 0 3 Central African Republic
3289 3289       Cote d'Ivoire 2020-03-23 23:19:21 7.54 -5.5471 25 0 2 23 Cote d'Ivoire
3393 3393       Sri Lanka 2020-03-23 23:19:21 7.873054 80.77179699999998 97 0 2 95 Sri Lanka
3312 3312       Ghana 2020-03-23 23:19:21 7.9465 -1.0232 27 2 0 25 Ghana
3368 3368       Panama 2020-03-23 23:19:21 8.538 -80.7821 313 3 1 309 Panama
3403 3403       Togo 2020-03-23 23:19:21 8.6195 0.8248 18 0 0 18 Togo
3363 3363       Nigeria 2020-03-23 23:19:21 9.082 8.6753 40 1 2 37 Nigeria
3305 3305       Ethiopia 2020-03-23 23:19:21 9.145 40.4897 11 0 0 11 Ethiopia
3271 3271       Benin 2020-03-23 23:19:21 9.3077 2.3158 5 0 0 5 Benin
3288 3288       Costa Rica 2020-03-23 23:19:21 9.7489 -83.7534 158 2 2 154 Costa Rica
3316 3316       Guinea 2020-03-23 23:19:21 9.9456 -9.6966 4 0 0 4 Guinea
3404 3404       Trinidad and Tobago 2020-03-23 23:19:21 10.6918 -61.2225 51 0 0 51 Trinidad and Tobago
3280 3280       Cambodia 2020-03-23 23:19:21 11.55 104.9167 87 0 2 85 Cambodia

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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