03-27-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,432 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
3250 3250     Tasmania Australia 2020-03-27 23:27:48 -42.8821 147.3272 47 0 3 44 Tasmania, Australia
3374 3374       New Zealand 2020-03-27 23:23:03 -40.9006 174.886 368 0 37 331 New Zealand
3266 3266       Argentina 2020-03-27 23:23:03 -38.4161 -63.6167 589 13 72 504 Argentina
3253 3253     Victoria Australia 2020-03-27 23:27:48 -37.8136 144.9631 574 3 171 400 Victoria, Australia
3291 3291       Chile 2020-03-27 23:23:03 -35.6751 -71.543 1610 5 43 1562 Chile
3178 3178     Australian Capital Territory Australia 2020-03-27 23:27:48 -35.4735 149.0124 62 0 1 61 Australian Capital Territory, Australia
3248 3248     South Australia Australia 2020-03-27 23:27:48 -34.9285 138.6007 257 0 6 251 South Australia, Australia
3222 3222     New South Wales Australia 2020-03-27 23:27:48 -33.8688 151.2093 1405 7 4 1394 New South Wales, Australia
3426 3426       Uruguay 2020-03-27 23:23:03 -32.5228 -55.7658 238 0 0 238 Uruguay
3255 3255     Western Australia Australia 2020-03-27 23:27:48 -31.9505 115.8605 231 2 1 228 Western Australia, Australia
3406 3406       South Africa 2020-03-27 23:23:03 -30.5595 22.9375 1170 1 31 1138 South Africa
3235 3235     Queensland Australia 2020-03-27 23:27:48 -27.4698 153.0251 555 1 8 546 Queensland, Australia
3312 3312       Eswatini 2020-03-27 23:23:03 -26.5225 31.4659 9 0 0 9 Eswatini
3384 3384       Paraguay 2020-03-27 23:23:03 -23.4425 -58.4438 52 3 1 48 Paraguay
3371 3371       Namibia 2020-03-27 23:23:03 -22.9576 18.4904 8 0 2 6 Namibia
3238 3238     Reunion France 2020-03-27 23:23:03 -21.1151 55.5364 145 0 1 144 Reunion, France
3221 3221     New Caledonia France 2020-03-27 23:23:03 -20.904304999999997 165.618042 15 0 0 15 New Caledonia, France
3363 3363       Mauritius 2020-03-27 23:23:03 -20.348404000000002 57.552152 94 2 0 92 Mauritius
3432 3432       Zimbabwe 2020-03-27 23:23:03 -19.015438 29.154857 5 1 0 4 Zimbabwe
3357 3357       Madagascar 2020-03-27 23:23:03 -18.766947000000002 46.869107 26 0 0 26 Madagascar
3370 3370       Mozambique 2020-03-27 23:23:03 -18.665695 35.529562 7 0 0 7 Mozambique
3314 3314       Fiji 2020-03-27 23:23:03 -17.7134 178.065 5 0 0 5 Fiji
3190 3190     French Polynesia France 2020-03-27 23:23:03 -17.6797 -149.4068 30 0 0 30 French Polynesia, France
3279 3279       Bolivia 2020-03-27 23:23:03 -16.2902 -63.5887 61 0 0 61 Bolivia
3175 3175 60000   American Samoa US 2020-03-27 22:14:55 -14.270999999999999 -170.132 0 0 0 0 American Samoa, US
3281 3281       Brazil 2020-03-27 23:23:03 -14.235 -51.9253 3417 92 6 3319 Brazil
3396 3396       Samoa 2020-03-27 23:27:32 -13.759 -172.1046 0 0 0 0 Samoa
3431 3431       Zambia 2020-03-27 23:23:03 -13.133897 27.849332 22 0 0 22 Zambia
3218 3218     Mayotte France 2020-03-27 23:23:03 -12.8275 45.166244 50 0 0 50 Mayotte, France
3226 3226     Northern Territory Australia 2020-03-27 23:27:48 -12.4634 130.8456 12 0 0 12 Northern Territory, Australia
3264 3264       Angola 2020-03-27 23:23:03 -11.2027 17.8739 4 0 0 4 Angola
3385 3385       Peru 2020-03-27 23:23:03 -9.19 -75.0152 635 11 16 608 Peru
3417 3417       Timor-Leste 2020-03-27 23:23:03 -8.874217 125.727539 1 0 0 1 Timor-Leste
3240 3240     Saint Helena, Ascension and Tristan da Cunha United Kingdom 2020-03-27 23:23:03 -7.9467 -14.3559 0 0 0 0 Saint Helena, Ascension and Tristan da Cunha, United Kingdom
3415 3415       Tanzania 2020-03-27 23:23:03 -6.369028 34.888822 13 0 1 12 Tanzania
3383 3383       Papua New Guinea 2020-03-27 23:23:03 -6.314993 143.95555 1 0 0 1 Papua New Guinea
3401 3401       Seychelles 2020-03-27 23:23:03 -4.6796 55.492 7 0 0 7 Seychelles
3294 3294       Congo (Kinshasa) 2020-03-27 23:23:03 -4.322447 15.307045 51 3 2 46 Congo (Kinshasa)
3293 3293       Congo (Brazzaville) 2020-03-27 23:23:03 -4.2634 15.2832 4 0 0 4 Congo (Brazzaville)
3392 3392       Rwanda 2020-03-27 23:23:03 -1.9403 29.8739 54 0 0 54 Rwanda
3306 3306       Ecuador 2020-03-27 23:23:03 -1.8312 -78.1834 1595 36 3 1556 Ecuador
3317 3317       Gabon 2020-03-27 23:23:03 -0.8037 11.6094 7 1 0 6 Gabon
3334 3334       Indonesia 2020-03-27 23:23:03 -0.7893 113.9213 1046 87 46 913 Indonesia
3344 3344       Kenya 2020-03-27 23:23:03 -0.0236 37.9062 31 1 1 29 Kenya
2178 2178   Out of MI Michigan US 2020-03-27 22:14:55 0.0 0.0 8 0 0 0 Out of MI,Michigan,US
2179 2179   Out of TN Tennessee US 2020-03-27 22:14:55 0.0 0.0 141 0 0 0 Out of TN,Tennessee,US
2180 2180   Out of UT Utah US 2020-03-27 22:14:55 0.0 0.0 14 0 0 0 Out of UT,Utah,US
2856 2856   Unassigned Alaska US 2020-03-27 22:14:55 0.0 0.0 0 1 0 0 Unassigned, Alaska, US
2857 2857   Unassigned Arizona US 2020-03-27 22:14:55 0.0 0.0 0 2 0 0 Unassigned, Arizona, US
2858 2858   Unassigned Arkansas US 2020-03-27 22:14:55 0.0 0.0 35 2 0 0 Unassigned, Arkansas, US
2859 2859   Unassigned California US 2020-03-27 22:14:55 0.0 0.0 12 0 0 0 Unassigned, California, US
2860 2860   Unassigned Colorado US 2020-03-27 22:14:55 0.0 0.0 102 8 0 0 Unassigned, Colorado, US
2861 2861   Unassigned Delaware US 2020-03-27 22:14:55 0.0 0.0 0 1 0 0 Unassigned, Delaware, US
2862 2862   Unassigned Georgia US 2020-03-27 22:14:55 0.0 0.0 217 42 0 0 Unassigned, Georgia, US
2863 2863   Unassigned Hawaii US 2020-03-27 22:14:55 0.0 0.0 6 0 0 0 Unassigned, Hawaii, US
2864 2864   Unassigned Kentucky US 2020-03-27 22:14:55 0.0 0.0 158 0 0 0 Unassigned, Kentucky, US
2865 2865   Unassigned Louisiana US 2020-03-27 22:14:55 0.0 0.0 16 1 0 0 Unassigned, Louisiana, US
2866 2866   Unassigned Maine US 2020-03-27 22:14:55 0.0 0.0 3 0 0 0 Unassigned, Maine, US
2867 2867   Unassigned Maryland US 2020-03-27 22:14:55 0.0 0.0 0 1 0 0 Unassigned, Maryland, US
2868 2868   Unassigned Massachusetts US 2020-03-27 22:14:55 0.0 0.0 303 9 0 0 Unassigned, Massachusetts, US
2869 2869   Unassigned Minnesota US 2020-03-27 22:14:55 0.0 0.0 0 2 0 0 Unassigned, Minnesota, US
2870 2870   Unassigned Montana US 2020-03-27 22:14:55 0.0 0.0 0 1 0 0 Unassigned, Montana, US
2871 2871   Unassigned Nebraska US 2020-03-27 22:14:55 0.0 0.0 2 0 0 0 Unassigned, Nebraska, US
2872 2872   Unassigned Nevada US 2020-03-27 22:14:55 0.0 0.0 16 0 0 0 Unassigned, Nevada, US
2873 2873   Unassigned New Hampshire US 2020-03-27 22:14:55 0.0 0.0 4 0 0 0 Unassigned, New Hampshire, US
2874 2874   Unassigned New Jersey US 2020-03-27 22:14:55 0.0 0.0 1984 82 0 0 Unassigned, New Jersey, US
2875 2875   Unassigned New York US 2020-03-27 22:14:55 0.0 0.0 0 87 0 0 Unassigned, New York, US
2876 2876   Unassigned Rhode Island US 2020-03-27 22:14:55 0.0 0.0 71 2 0 0 Unassigned, Rhode Island, US
2877 2877   Unassigned Tennessee US 2020-03-27 22:14:55 0.0 0.0 172 3 0 0 Unassigned, Tennessee, US
2878 2878   Unassigned Vermont US 2020-03-27 22:14:55 0.0 0.0 6 5 0 0 Unassigned, Vermont, US
2879 2879   Unassigned Washington US 2020-03-27 22:14:55 0.0 0.0 67 0 0 0 Unassigned, Washington, US
2880 2880   Unassigned Wisconsin US 2020-03-27 22:14:55 0.0 0.0 61 0 0 0 Unassigned, Wisconsin, US
3186 3186     Diamond Princess Canada 2020-03-27 23:27:32 0.0 0.0 0 1 0 0 Diamond Princess, Canada
3187 3187 88888   Diamond Princess US 2020-03-27 22:14:55 0.0 0.0 49 0 0 0 Diamond Princess, US
3194 3194     Grand Princess Canada 2020-03-27 23:27:32 0.0 0.0 13 0 0 0 Grand Princess, Canada
3195 3195 99999   Grand Princess US 2020-03-27 22:14:55 0.0 0.0 28 3 0 0 Grand Princess, US
3236 3236     Recovered Canada 2020-03-27 23:27:32 0.0 0.0 0 0 256 0 Recovered, Canada
3237 3237     Recovered US 2020-03-27 22:14:55 0.0 0.0 0 0 869 0 Recovered, US
3302 3302       Diamond Princess 2020-03-27 23:23:03 0.0 0.0 712 10 597 105 Diamond Princess
3402 3402       Singapore 2020-03-27 23:23:03 1.2833 103.8333 732 2 183 547 Singapore
3422 3422       Uganda 2020-03-27 23:23:03 1.373333 32.290275 23 0 0 23 Uganda
3309 3309       Equatorial Guinea 2020-03-27 23:23:03 1.6508 10.2679 12 0 0 12 Equatorial Guinea
3359 3359       Maldives 2020-03-27 23:23:03 3.2028 73.2207 16 0 9 7 Maldives
3288 3288       Cameroon 2020-03-27 23:23:03 3.8480000000000003 11.5021 91 2 2 87 Cameroon
3410 3410       Suriname 2020-03-27 23:23:03 3.9193 -56.0278 8 0 0 8 Suriname
3189 3189     French Guiana France 2020-03-27 23:23:03 4.0 -53.0 28 0 6 22 French Guiana, France
3358 3358       Malaysia 2020-03-27 23:23:03 4.210483999999999 101.97576600000001 2161 26 259 1876 Malaysia
3282 3282       Brunei 2020-03-27 23:23:03 4.5353 114.7277 115 0 11 104 Brunei
3292 3292       Colombia 2020-03-27 23:23:03 4.5709 -74.2973 539 6 10 523 Colombia
3327 3327       Guyana 2020-03-27 23:23:03 4.860416000000002 -58.93018000000001 5 1 0 4 Guyana
3405 3405       Somalia 2020-03-27 23:23:03 5.152149 46.199616 3 0 0 3 Somalia
3428 3428       Venezuela 2020-03-27 23:23:03 6.4238 -66.5897 107 1 31 75 Venezuela
3352 3352       Liberia 2020-03-27 23:23:03 6.4280550000000005 -9.429499 3 0 0 3 Liberia
3289 3289       Central African Republic 2020-03-27 23:23:03 6.6111 20.9394 3 0 0 3 Central African Republic
3296 3296       Cote d'Ivoire 2020-03-27 23:23:03 7.54 -5.5471 101 0 3 98 Cote d'Ivoire
3408 3408       Sri Lanka 2020-03-27 23:23:03 7.873054 80.77179699999998 106 0 7 99 Sri Lanka
3321 3321       Ghana 2020-03-27 23:23:03 7.9465 -1.0232 137 4 2 131 Ghana
3382 3382       Panama 2020-03-27 23:23:03 8.538 -80.7821 674 9 2 663 Panama
3418 3418       Togo 2020-03-27 23:23:03 8.6195 0.8248 25 1 1 23 Togo
3377 3377       Nigeria 2020-03-27 23:23:03 9.082 8.6753 70 1 3 66 Nigeria

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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