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,437 rows sorted by Lat

View and edit SQL

Link rowid FIPS Admin2 Province_State Country_Region Last_Update Lat ▼ Long_ Confirmed Deaths Recovered Active Combined_Key
3253     Tasmania Australia 3/29/20 23:14 -42.8821 147.3272 66 0 5 61 Tasmania, Australia
3379       New Zealand 3/29/20 23:08 -40.9006 174.886 514 1 56 457 New Zealand
3270       Argentina 3/29/20 23:08 -38.4161 -63.6167 745 19 72 654 Argentina
3257     Victoria Australia 3/29/20 23:14 -37.8136 144.9631 769 4 191 574 Victoria, Australia
3295       Chile 3/29/20 23:08 -35.6751 -71.543 2139 7 75 2057 Chile
3180     Australian Capital Territory Australia 3/29/20 23:14 -35.4735 149.0124 77 0 2 75 Australian Capital Territory, Australia
3251     South Australia Australia 3/29/20 23:14 -34.9285 138.6007 299 0 6 293 South Australia, Australia
3225     New South Wales Australia 3/29/20 23:14 -33.8688 151.2093 1791 8 4 1779 New South Wales, Australia
3431       Uruguay 3/29/20 23:08 -32.5228 -55.7658 304 1 0 303 Uruguay
3259     Western Australia Australia 3/29/20 23:14 -31.9505 115.8605 311 2 28 281 Western Australia, Australia
3411       South Africa 3/29/20 23:08 -30.5595 22.9375 1280 2 31 1247 South Africa
3238     Queensland Australia 3/29/20 23:14 -27.4698 153.0251 656 2 8 646 Queensland, Australia
3316       Eswatini 3/29/20 23:08 -26.5225 31.4659 9 0 0 9 Eswatini
3389       Paraguay 3/29/20 23:08 -23.4425 -58.4438 59 3 1 55 Paraguay
3376       Namibia 3/29/20 23:08 -22.9576 18.4904 11 0 2 9 Namibia
3241     Reunion France 3/29/20 23:08 -21.1151 55.5364 183 0 1 182 Reunion, France
3224     New Caledonia France 3/29/20 23:08 -20.904305 165.618042 15 0 0 15 New Caledonia, France
3368       Mauritius 3/29/20 23:08 -20.348404 57.552152 107 3 0 104 Mauritius
3437       Zimbabwe 3/29/20 23:08 -19.015438 29.154857 7 1 0 6 Zimbabwe
3362       Madagascar 3/29/20 23:08 -18.766947 46.869107 39 0 0 39 Madagascar
3375       Mozambique 3/29/20 23:08 -18.665695 35.529562 8 0 0 8 Mozambique
3318       Fiji 3/29/20 23:08 -17.7134 178.065 5 0 0 5 Fiji
3193     French Polynesia France 3/29/20 23:08 -17.6797 149.4068 30 0 0 30 French Polynesia, France
3283       Bolivia 3/29/20 23:08 -16.2902 -63.5887 81 1 0 80 Bolivia
3176 60000   American Samoa US 3/29/20 23:08 -14.271 -170.132 0 0 0 0 American Samoa, US
3285       Brazil 3/29/20 23:08 -14.235 -51.9253 4256 136 6 4114 Brazil
3401       Samoa 3/29/20 23:13 -13.759 -172.1046 0 0 0 0 Samoa
3436       Zambia 3/29/20 23:08 -13.133897 27.849332 29 0 0 29 Zambia
3221     Mayotte France 3/29/20 23:08 -12.8275 45.166244 63 0 0 63 Mayotte, France
3229     Northern Territory Australia 3/29/20 23:14 -12.4634 130.8456 15 0 0 15 Northern Territory, Australia
3268       Angola 3/29/20 23:08 -11.2027 17.8739 7 2 0 5 Angola
3390       Peru 3/29/20 23:08 -9.19 -75.0152 852 18 16 818 Peru
3422       Timor-Leste 3/29/20 23:08 -8.874217 125.727539 1 0 0 1 Timor-Leste
3243     Saint Helena, Ascension and Tristan da Cunha United Kingdom 3/29/20 23:08 -7.9467 -14.3559 0 0 0 0 Saint Helena, Ascension and Tristan da Cunha, United Kingdom
3420       Tanzania 3/29/20 23:08 -6.369028 34.888822 14 0 1 13 Tanzania
3388       Papua New Guinea 3/29/20 23:08 -6.314993 143.95555 1 0 0 1 Papua New Guinea
3406       Seychelles 3/29/20 23:08 -4.6796 55.492 8 0 0 8 Seychelles
3298       Congo (Kinshasa) 3/29/20 23:08 -4.322447 15.307045 65 6 2 57 Congo (Kinshasa)
3297       Congo (Brazzaville) 3/29/20 23:08 -4.2634 15.2832 19 0 0 19 Congo (Brazzaville)
3397       Rwanda 3/29/20 23:08 -1.9403 29.8739 70 0 0 70 Rwanda
3310       Ecuador 3/29/20 23:08 -1.8312 -78.1834 1924 58 3 1863 Ecuador
3321       Gabon 3/29/20 23:08 -0.8037 11.6094 7 1 0 6 Gabon
3338       Indonesia 3/29/20 23:08 -0.7893 113.9213 1285 114 64 1107 Indonesia
3348       Kenya 3/29/20 23:08 -0.0236 37.9062 42 1 1 40 Kenya
2178   Out of MI Michigan US 3/29/20 23:08 0.0 0.0 18 0 0 0 Out of MI,Michigan,US
2179   Out of TN Tennessee US 3/29/20 23:08 0.0 0.0 150 0 0 0 Out of TN,Tennessee,US
2180   Out of UT Utah US 3/29/20 23:08 0.0 0.0 14 0 0 0 Out of UT,Utah,US
2856   Unassigned Alaska US 3/29/20 23:08 0.0 0.0 0 1 0 0 Unassigned, Alaska, US
2857   Unassigned Arizona US 3/29/20 23:08 0.0 0.0 0 6 0 0 Unassigned, Arizona, US
2858   Unassigned Arkansas US 3/29/20 23:08 0.0 0.0 31 5 0 0 Unassigned, Arkansas, US
2859   Unassigned California US 3/29/20 23:08 0.0 0.0 0 1 0 0 Unassigned, California, US
2860   Unassigned Colorado US 3/29/20 23:08 0.0 0.0 186 1 0 0 Unassigned, Colorado, US
2861   Unassigned Florida US 3/29/20 23:08 0.0 0.0 0 2 0 0 Unassigned, Florida, US
2862   Unassigned Georgia US 3/29/20 23:08 0.0 0.0 262 2 0 0 Unassigned, Georgia, US
2863   Unassigned Hawaii US 3/29/20 23:08 0.0 0.0 4 0 0 0 Unassigned, Hawaii, US
2864   Unassigned Illinois US 3/29/20 23:08 0.0 0.0 8 0 0 0 Unassigned, Illinois, US
2865   Unassigned Kentucky US 3/29/20 23:08 0.0 0.0 69 0 0 0 Unassigned, Kentucky, US
2866   Unassigned Louisiana US 3/29/20 23:08 0.0 0.0 8 0 0 0 Unassigned, Louisiana, US
2867   Unassigned Maine US 3/29/20 23:08 0.0 0.0 5 0 0 0 Unassigned, Maine, US
2868   Unassigned Maryland US 3/29/20 23:08 0.0 0.0 0 1 0 0 Unassigned, Maryland, US
2869   Unassigned Massachusetts US 3/29/20 23:08 0.0 0.0 460 9 0 0 Unassigned, Massachusetts, US
2870   Unassigned Michigan US 3/29/20 23:08 0.0 0.0 77 0 0 0 Unassigned,Michigan,US
2871   Unassigned Minnesota US 3/29/20 23:08 0.0 0.0 0 4 0 0 Unassigned, Minnesota, US
2872   Unassigned Nebraska US 3/29/20 23:08 0.0 0.0 4 0 0 0 Unassigned, Nebraska, US
2873   Unassigned Nevada US 3/29/20 23:08 0.0 0.0 269 0 0 0 Unassigned, Nevada, US
2874   Unassigned New Jersey US 3/29/20 23:08 0.0 0.0 3020 56 0 0 Unassigned, New Jersey, US
2875   Unassigned New York US 3/29/20 23:08 0.0 0.0 0 159 0 0 Unassigned, New York, US
2876   Unassigned Rhode Island US 3/29/20 23:08 0.0 0.0 57 4 0 0 Unassigned, Rhode Island, US
2877   Unassigned Tennessee US 3/29/20 23:08 0.0 0.0 190 4 0 0 Unassigned, Tennessee, US
2878   Unassigned Vermont US 3/29/20 23:08 0.0 0.0 7 7 0 0 Unassigned, Vermont, US
2879   Unassigned Virginia US 3/29/20 23:08 0.0 0.0 0 5 0 0 Unassigned, Virginia, US
2880   Unassigned Washington US 3/29/20 23:08 0.0 0.0 125 0 0 0 Unassigned, Washington, US
2881   Unassigned Wisconsin US 3/29/20 23:08 0.0 0.0 0 0 0 0 Unassigned, Wisconsin, US
3189     Diamond Princess Canada 3/29/20 23:13 0.0 0.0 0 1 0 0 Diamond Princess, Canada
3190 88888   Diamond Princess US 3/29/20 23:08 0.0 0.0 49 0 0 0 Diamond Princess, US
3197     Grand Princess Canada 3/29/20 23:13 0.0 0.0 13 0 0 0 Grand Princess, Canada
3198 99999   Grand Princess US 3/29/20 23:08 0.0 0.0 103 3 0 0 Grand Princess, US
3239     Recovered Canada 3/29/20 23:13 0.0 0.0 0 0 466 0 Recovered, Canada
3240     Recovered US 3/29/20 23:08 0.0 0.0 0 0 2665 0 Recovered, US
3306       Diamond Princess 3/29/20 23:08 0.0 0.0 712 10 603 99 Diamond Princess
3361       MS Zaandam 3/29/20 23:08 0.0 0.0 2 0 0 2 ,,MS Zaandam
3407       Singapore 3/29/20 23:08 1.2833 103.8333 844 3 212 629 Singapore
3427       Uganda 3/29/20 23:08 1.373333 32.290275 33 0 0 33 Uganda
3313       Equatorial Guinea 3/29/20 23:08 1.6508 10.2679 12 0 0 12 Equatorial Guinea
3364       Maldives 3/29/20 23:08 3.2028 73.2207 17 0 13 4 Maldives
3292       Cameroon 3/29/20 23:08 3.848 11.5021 139 6 5 128 Cameroon
3415       Suriname 3/29/20 23:08 3.9193 -56.0278 8 0 0 8 Suriname
3192     French Guiana France 3/29/20 23:08 4.0 -53.0 28 0 6 22 French Guiana, France
3363       Malaysia 3/29/20 23:08 4.210484 101.975766 2470 35 388 2047 Malaysia
3286       Brunei 3/29/20 23:08 4.5353 114.7277 126 1 34 91 Brunei
3296       Colombia 3/29/20 23:08 4.5709 -74.2973 702 10 10 682 Colombia
3331       Guyana 3/29/20 23:08 4.860416 -58.93018 8 1 0 7 Guyana
3410       Somalia 3/29/20 23:08 5.152149 46.199616 3 0 0 3 Somalia
3433       Venezuela 3/29/20 23:08 6.4238 -66.5897 119 2 39 78 Venezuela
3356       Liberia 3/29/20 23:08 6.428055 -9.429499 3 0 0 3 Liberia
3293       Central African Republic 3/29/20 23:08 6.6111 20.9394 3 0 0 3 Central African Republic
3300       Cote d'Ivoire 3/29/20 23:08 7.54 -5.5471 165 1 4 160 Cote d'Ivoire
3413       Sri Lanka 3/29/20 23:08 7.873054 80.771797 117 1 11 105 Sri Lanka
3325       Ghana 3/29/20 23:08 7.9465 -1.0232 152 5 2 145 Ghana
3387       Panama 3/29/20 23:08 8.538 -80.7821 901 17 4 880 Panama

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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