03-28-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,433 rows sorted by Lat

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link rowid FIPS Admin2 Province_State Country_Region Last_Update Lat ▼ Long_ Confirmed Deaths Recovered Active Combined_Key
3249 3249     Tasmania Australia 3/28/20 23:11 -42.8821 147.3272 62 0 5 57 Tasmania, Australia
3375 3375       New Zealand 3/28/20 23:05 -40.9006 174.886 451 0 50 401 New Zealand
3266 3266       Argentina 3/28/20 23:05 -38.4161 -63.6167 690 18 72 600 Argentina
3253 3253     Victoria Australia 3/28/20 23:11 -37.8136 144.9631 685 3 191 491 Victoria, Australia
3291 3291       Chile 3/28/20 23:05 -35.6751 -71.543 1909 6 61 1842 Chile
3176 3176     Australian Capital Territory Australia 3/28/20 23:11 -35.4735 149.0124 71 0 2 69 Australian Capital Territory, Australia
3247 3247     South Australia Australia 3/28/20 23:11 -34.9285 138.6007 287 0 6 281 South Australia, Australia
3221 3221     New South Wales Australia 3/28/20 23:11 -33.8688 151.2093 1617 8 4 1605 New South Wales, Australia
3427 3427       Uruguay 3/28/20 23:05 -32.5228 -55.7658 274 0 0 274 Uruguay
3255 3255     Western Australia Australia 3/28/20 23:11 -31.9505 115.8605 278 2 28 248 Western Australia, Australia
3407 3407       South Africa 3/28/20 23:05 -30.5595 22.9375 1187 1 31 1155 South Africa
3234 3234     Queensland Australia 3/28/20 23:11 -27.4698 153.0251 625 1 8 616 Queensland, Australia
3312 3312       Eswatini 3/28/20 23:05 -26.5225 31.4659 9 0 0 9 Eswatini
3385 3385       Paraguay 3/28/20 23:05 -23.4425 -58.4438 56 3 1 52 Paraguay
3372 3372       Namibia 3/28/20 23:05 -22.9576 18.4904 8 0 2 6 Namibia
3237 3237     Reunion France 3/28/20 23:05 -21.1151 55.5364 183 0 1 182 Reunion, France
3220 3220     New Caledonia France 3/28/20 23:05 -20.904305 165.618042 15 0 0 15 New Caledonia, France
3364 3364       Mauritius 3/28/20 23:05 -20.348404 57.552152 102 2 0 100 Mauritius
3433 3433       Zimbabwe 3/28/20 23:05 -19.015438 29.154857 7 1 0 6 Zimbabwe
3358 3358       Madagascar 3/28/20 23:05 -18.766947 46.869107 26 0 0 26 Madagascar
3371 3371       Mozambique 3/28/20 23:05 -18.665695 35.529562 8 0 0 8 Mozambique
3314 3314       Fiji 3/28/20 23:05 -17.7134 178.065 5 0 0 5 Fiji
3189 3189     French Polynesia France 3/28/20 23:05 -17.6797 149.4068 30 0 0 30 French Polynesia, France
3279 3279       Bolivia 3/28/20 23:05 -16.2902 -63.5887 74 0 0 74 Bolivia
3172 3172 60000   American Samoa US 3/28/20 23:05 -14.271 -170.132 0 0 0 0 American Samoa, US
3281 3281       Brazil 3/28/20 23:05 -14.235 -51.9253 3904 111 6 3787 Brazil
3397 3397       Samoa 3/28/20 23:10 -13.759 -172.1046 0 0 0 0 Samoa
3432 3432       Zambia 3/28/20 23:05 -13.133897 27.849332 28 0 0 28 Zambia
3217 3217     Mayotte France 3/28/20 23:05 -12.8275 45.166244 63 0 0 63 Mayotte, France
3225 3225     Northern Territory Australia 3/28/20 23:11 -12.4634 130.8456 15 0 0 15 Northern Territory, Australia
3264 3264       Angola 3/28/20 23:05 -11.2027 17.8739 5 0 0 5 Angola
3386 3386       Peru 3/28/20 23:05 -9.19 -75.0152 671 16 16 639 Peru
3418 3418       Timor-Leste 3/28/20 23:05 -8.874217 125.727539 1 0 0 1 Timor-Leste
3239 3239     Saint Helena, Ascension and Tristan da Cunha United Kingdom 3/28/20 23:05 -7.9467 -14.3559 0 0 0 0 Saint Helena, Ascension and Tristan da Cunha, United Kingdom
3416 3416       Tanzania 3/28/20 23:05 -6.369028 34.888822 14 0 1 13 Tanzania
3384 3384       Papua New Guinea 3/28/20 23:05 -6.314993 143.95555 1 0 0 1 Papua New Guinea
3402 3402       Seychelles 3/28/20 23:05 -4.6796 55.492 8 0 0 8 Seychelles
3294 3294       Congo (Kinshasa) 3/28/20 23:05 -4.322447 15.307045 65 6 2 57 Congo (Kinshasa)
3293 3293       Congo (Brazzaville) 3/28/20 23:05 -4.2634 15.2832 4 0 0 4 Congo (Brazzaville)
3393 3393       Rwanda 3/28/20 23:05 -1.9403 29.8739 60 0 0 60 Rwanda
3306 3306       Ecuador 3/28/20 23:05 -1.8312 -78.1834 1823 48 3 1772 Ecuador
3317 3317       Gabon 3/28/20 23:05 -0.8037 11.6094 7 1 0 6 Gabon
3334 3334       Indonesia 3/28/20 23:05 -0.7893 113.9213 1155 102 59 994 Indonesia
3344 3344       Kenya 3/28/20 23:05 -0.0236 37.9062 38 1 1 36 Kenya
2178 2178   Out of MI Michigan US 3/28/20 23:05 0.0 0.0 15 0 0 0 Out of MI,Michigan,US
2179 2179   Out of TN Tennessee US 3/28/20 23:05 0.0 0.0 148 0 0 0 Out of TN,Tennessee,US
2180 2180   Out of UT Utah US 3/28/20 23:05 0.0 0.0 14 0 0 0 Out of UT,Utah,US
2856 2856   Unassigned Alaska US 3/28/20 23:05 0.0 0.0 0 1 0 0 Unassigned, Alaska, US
2857 2857   Unassigned Arizona US 3/28/20 23:05 0.0 0.0 0 4 0 0 Unassigned, Arizona, US
2858 2858   Unassigned Arkansas US 3/28/20 23:05 0.0 0.0 32 4 0 0 Unassigned, Arkansas, US
2859 2859   Unassigned Colorado US 3/28/20 23:05 0.0 0.0 136 1 0 0 Unassigned, Colorado, US
2860 2860   Unassigned Florida US 3/28/20 23:05 0.0 0.0 0 8 0 0 Unassigned, Florida, US
2861 2861   Unassigned Georgia US 3/28/20 23:05 0.0 0.0 230 2 0 0 Unassigned, Georgia, US
2862 2862   Unassigned Hawaii US 3/28/20 23:05 0.0 0.0 4 0 0 0 Unassigned, Hawaii, US
2863 2863   Unassigned Illinois US 3/28/20 23:05 0.0 0.0 8 0 0 0 Unassigned, Illinois, US
2864 2864   Unassigned Kentucky US 3/28/20 23:05 0.0 0.0 150 0 0 0 Unassigned, Kentucky, US
2865 2865   Unassigned Louisiana US 3/28/20 23:05 0.0 0.0 9 1 0 0 Unassigned, Louisiana, US
2866 2866   Unassigned Maine US 3/28/20 23:05 0.0 0.0 3 0 0 0 Unassigned, Maine, US
2867 2867   Unassigned Maryland US 3/28/20 23:05 0.0 0.0 0 1 0 0 Unassigned, Maryland, US
2868 2868   Unassigned Massachusetts US 3/28/20 23:05 0.0 0.0 356 9 0 0 Unassigned, Massachusetts, US
2869 2869   Unassigned Michigan US 3/28/20 23:05 0.0 0.0 47 0 0 0 Unassigned,Michigan,US
2870 2870   Unassigned Nevada US 3/28/20 23:05 0.0 0.0 93 0 0 0 Unassigned, Nevada, US
2871 2871   Unassigned New Jersey US 3/28/20 23:05 0.0 0.0 2478 86 0 0 Unassigned, New Jersey, US
2872 2872   Unassigned New York US 3/28/20 23:05 0.0 0.0 0 109 0 0 Unassigned, New York, US
2873 2873   Unassigned Rhode Island US 3/28/20 23:05 0.0 0.0 107 2 0 0 Unassigned, Rhode Island, US
2874 2874   Unassigned Tennessee US 3/28/20 23:05 0.0 0.0 161 4 0 0 Unassigned, Tennessee, US
2875 2875   Unassigned Vermont US 3/28/20 23:05 0.0 0.0 7 7 0 0 Unassigned, Vermont, US
2876 2876   Unassigned Washington US 3/28/20 23:05 0.0 0.0 0 0 0 0 Unassigned, Washington, US
2877 2877   Unassigned Wisconsin US 3/28/20 23:05 0.0 0.0 0 0 0 0 Unassigned, Wisconsin, US
3185 3185     Diamond Princess Canada 3/28/20 23:10 0.0 0.0 0 1 0 0 Diamond Princess, Canada
3186 3186 88888   Diamond Princess US 3/28/20 23:05 0.0 0.0 49 0 0 0 Diamond Princess, US
3193 3193     Grand Princess Canada 3/28/20 23:10 0.0 0.0 13 0 0 0 Grand Princess, Canada
3194 3194 99999   Grand Princess US 3/28/20 23:05 0.0 0.0 103 3 0 0 Grand Princess, US
3235 3235     Recovered Canada 3/28/20 23:10 0.0 0.0 0 0 466 0 Recovered, Canada
3236 3236     Recovered US 3/28/20 23:05 0.0 0.0 0 0 1072 0 Recovered, US
3302 3302       Diamond Princess 3/28/20 23:05 0.0 0.0 712 10 597 105 Diamond Princess
3357 3357       MS Zaandam 3/28/20 23:05 0.0 0.0 2 0 0 2 ,,MS Zaandam
3403 3403       Singapore 3/28/20 23:05 1.2833 103.8333 802 2 198 602 Singapore
3423 3423       Uganda 3/28/20 23:05 1.373333 32.290275 30 0 0 30 Uganda
3309 3309       Equatorial Guinea 3/28/20 23:05 1.6508 10.2679 12 0 0 12 Equatorial Guinea
3360 3360       Maldives 3/28/20 23:05 3.2028 73.2207 16 0 9 7 Maldives
3288 3288       Cameroon 3/28/20 23:05 3.848 11.5021 91 2 2 87 Cameroon
3411 3411       Suriname 3/28/20 23:05 3.9193 -56.0278 8 0 0 8 Suriname
3188 3188     French Guiana France 3/28/20 23:05 4.0 -53.0 28 0 6 22 French Guiana, France
3359 3359       Malaysia 3/28/20 23:05 4.210484 101.975766 2320 27 320 1973 Malaysia
3282 3282       Brunei 3/28/20 23:05 4.5353 114.7277 120 1 25 94 Brunei
3292 3292       Colombia 3/28/20 23:05 4.5709 -74.2973 608 6 10 592 Colombia
3327 3327       Guyana 3/28/20 23:05 4.860416 -58.93018 8 1 0 7 Guyana
3406 3406       Somalia 3/28/20 23:05 5.152149 46.199616 3 0 0 3 Somalia
3429 3429       Venezuela 3/28/20 23:05 6.4238 -66.5897 119 2 39 78 Venezuela
3352 3352       Liberia 3/28/20 23:05 6.428055 -9.429499 3 0 0 3 Liberia
3289 3289       Central African Republic 3/28/20 23:05 6.6111 20.9394 3 0 0 3 Central African Republic
3296 3296       Cote d'Ivoire 3/28/20 23:05 7.54 -5.5471 101 0 3 98 Cote d'Ivoire
3409 3409       Sri Lanka 3/28/20 23:05 7.873054 80.771797 113 1 9 103 Sri Lanka
3321 3321       Ghana 3/28/20 23:05 7.9465 -1.0232 141 5 2 134 Ghana
3383 3383       Panama 3/28/20 23:05 8.538 -80.7821 786 14 2 770 Panama
3419 3419       Togo 3/28/20 23:05 8.6195 0.8248 25 1 1 23 Togo
3378 3378       Nigeria 3/28/20 23:05 9.082 8.6753 89 1 3 85 Nigeria
3313 3313       Ethiopia 3/28/20 23:05 9.145 40.4897 16 0 1 15 Ethiopia
3277 3277       Benin 3/28/20 23:05 9.3077 2.3158 6 0 0 6 Benin

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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