04-02-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

2,572 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
1341 1341   McIntosh Georgia US 4/2/20 23:25     1 0 0 0 McIntosh,Georgia,US
1578 1578 80008 Out of CO Colorado US 4/2/20 23:25     0 1 0 0 Out of CO,Colorado,US
1579 1579   Out of MI Michigan US 4/2/20 23:25     48 1 0 0 Out of MI,Michigan,US
1580 1580   Out of OK Oklahoma US 4/2/20 23:25     2 0 0 0 Out of OK,Oklahoma,US
1581 1581   Out of TN Tennessee US 4/2/20 23:25     243 1 0 0 Out of TN,Tennessee,US
1582 1582   Out of UT Utah US 4/2/20 23:25     22 0 0 0 Out of UT,Utah,US
2043 2043 90001 Unassigned Alabama US 4/2/20 23:25     0 5 0 0 Unassigned, Alabama, US
2044 2044 90002 Unassigned Alaska US 4/2/20 23:25     0 2 0 0 Unassigned, Alaska, US
2045 2045 90004 Unassigned Arizona US 4/2/20 23:25     0 3 0 0 Unassigned, Arizona, US
2046 2046 90005 Unassigned Arkansas US 4/2/20 23:25     43 6 0 0 Unassigned, Arkansas, US
2047 2047 90006 Unassigned California US 4/2/20 23:25     0 0 0 0 Unassigned, California, US
2048 2048 90008 Unassigned Colorado US 4/2/20 23:25     128 4 0 0 Unassigned, Colorado, US
2049 2049 90009 Unassigned Connecticut US 4/2/20 23:25     174 1 0 0 Unassigned, Connecticut, US
2050 2050 90010 Unassigned Delaware US 4/2/20 23:25     0 16 0 0 Unassigned, Delaware, US
2051 2051 90012 Unassigned Florida US 4/2/20 23:25     9 20 0 0 Unassigned, Florida, US
2052 2052 90013 Unassigned Georgia US 4/2/20 23:25     778 1 0 0 Unassigned, Georgia, US
2053 2053 90015 Unassigned Hawaii US 4/2/20 23:25     18 0 0 0 Unassigned, Hawaii, US
2054 2054 90016 Unassigned Idaho US 4/2/20 23:25     9 0 0 0 Unassigned, Idaho, US
2055 2055 90017 Unassigned Illinois US 4/2/20 23:25     37 0 0 0 Unassigned, Illinois, US
2056 2056 90019 Unassigned Iowa US 4/2/20 23:25     0 1 0 0 Unassigned, Iowa, US
2057 2057 90021 Unassigned Kentucky US 4/2/20 23:25     113 14 0 0 Unassigned, Kentucky, US
2058 2058   Unassigned Louisiana US 4/2/20 23:25     38 1 0 0 Unassigned,Louisiana,US
2059 2059 90023 Unassigned Maine US 4/2/20 23:25     8 0 0 0 Unassigned, Maine, US
2060 2060 90024 Unassigned Maryland US 4/2/20 23:25     0 0 0 0 Unassigned, Maryland, US
2061 2061 90025 Unassigned Massachusetts US 4/2/20 23:25     270 9 0 0 Unassigned, Massachusetts, US
2062 2062   Unassigned Michigan US 4/2/20 23:25     178 0 0 0 Unassigned,Michigan,US
2063 2063 90027 Unassigned Minnesota US 4/2/20 23:25     0 8 0 0 Unassigned, Minnesota, US
2064 2064 90029 Unassigned Missouri US 4/2/20 23:25     0 0 0 0 Unassigned, Missouri, US
2065 2065 90030 Unassigned Montana US 4/2/20 23:25     0 0 0 0 Unassigned, Montana, US
2066 2066 90031 Unassigned Nebraska US 4/2/20 23:25     2 1 0 0 Unassigned, Nebraska, US
2067 2067 90032 Unassigned Nevada US 4/2/20 23:25     148 0 0 0 Unassigned, Nevada, US
2068 2068 90033 Unassigned New Hampshire US 4/2/20 23:25     0 2 0 0 Unassigned, New Hampshire, US
2069 2069 90034 Unassigned New Jersey US 4/2/20 23:25     4866 4 0 0 Unassigned, New Jersey, US
2070 2070 90035 Unassigned New Mexico US 4/2/20 23:25     1 0 0 0 Unassigned, New Mexico, US
2071 2071 90036 Unassigned New York US 4/2/20 23:25     0 675 0 0 Unassigned, New York, US
2072 2072 90038 Unassigned North Dakota US 4/2/20 23:25     0 0 0 0 Unassigned, North Dakota, US
2073 2073 90040 Unassigned Oklahoma US 4/2/20 23:25     0 0 0 0 Unassigned, Oklahoma, US
2074 2074 90044 Unassigned Rhode Island US 4/2/20 23:25     80 5 0 0 Unassigned, Rhode Island, US
2075 2075 90046 Unassigned South Dakota US 4/2/20 23:25     0 0 0 0 Unassigned, South Dakota, US
2076 2076 90047 Unassigned Tennessee US 4/2/20 23:25     6 0 0 0 Unassigned, Tennessee, US
2077 2077 90050 Unassigned Vermont US 4/2/20 23:25     5 12 0 0 Unassigned, Vermont, US
2078 2078 90051 Unassigned Virginia US 4/2/20 23:25     0 26 0 0 Unassigned,Virginia,US
2079 2079 90053 Unassigned Washington US 4/2/20 23:25     344 0 0 0 Unassigned, Washington, US
2080 2080 90054 Unassigned West Virginia US 4/2/20 23:25     0 1 0 0 Unassigned, West Virginia, US
2081 2081 90055 Unassigned Wisconsin US 4/2/20 23:25     0 5 0 0 Unassigned, Wisconsin, US
2319 2319     Diamond Princess Canada 4/2/20 23:31     0 1 0 0 Diamond Princess, Canada
2320 2320 88888   Diamond Princess US 4/2/20 23:25     49 0 0 0 Diamond Princess, US
2327 2327     Grand Princess Canada 4/2/20 23:31     13 0 0 0 Grand Princess, Canada
2328 2328 99999   Grand Princess US 4/2/20 23:25     103 3 0 0 Grand Princess, US
2369 2369     Recovered Canada 4/2/20 23:31     0 0 1735 0 Recovered, Canada
2370 2370     Recovered US 4/2/20 23:25     0 0 9001 0 Recovered, US
2438 2438       Diamond Princess 4/2/20 23:25     712 11 619 82 Diamond Princess
2493 2493       MS Zaandam 4/2/20 23:25     9 2 0 7 ,,MS Zaandam
2572 2572   unassigned Wyoming US 4/2/20 23:25     0 0 0 0 unassigned, Wyoming, US
2383 2383     Tasmania Australia 4/2/20 23:32 -42.8821 147.3272 72 2 5 65 Tasmania, Australia
2512 2512       New Zealand 4/2/20 23:25 -40.9006 174.886 797 1 92 704 New Zealand
2400 2400       Argentina 4/2/20 23:25 -38.4161 -63.6167 1133 36 256 841 Argentina
2387 2387     Victoria Australia 4/2/20 23:32 -37.8136 144.9631 1036 5 422 609 Victoria, Australia
2427 2427       Chile 4/2/20 23:25 -35.6751 -71.543 3404 18 335 3051 Chile
2309 2309     Australian Capital Territory Australia 4/2/20 23:32 -35.4735 149.0124 87 1 11 75 Australian Capital Territory, Australia
2381 2381     South Australia Australia 4/2/20 23:32 -34.9285 138.6007 367 0 6 361 South Australia, Australia
2355 2355     New South Wales Australia 4/2/20 23:32 -33.8688 151.2093 2298 10 4 2284 New South Wales, Australia
2565 2565       Uruguay 4/2/20 23:25 -32.5228 -55.7658 350 4 62 284 Uruguay
2389 2389     Western Australia Australia 4/2/20 23:32 -31.9505 115.8605 400 2 64 334 Western Australia, Australia
2545 2545       South Africa 4/2/20 23:25 -30.5595 22.9375 1462 5 50 1407 South Africa
2368 2368     Queensland Australia 4/2/20 23:32 -27.4698 153.0251 835 4 8 823 Queensland, Australia
2448 2448       Eswatini 4/2/20 23:25 -26.5225 31.4659 9 0 0 9 Eswatini
2522 2522       Paraguay 4/2/20 23:25 -23.4425 -58.4438 77 3 2 72 Paraguay
2509 2509       Namibia 4/2/20 23:25 -22.9576 18.4904 14 0 3 11 Namibia
2415 2415       Botswana 4/2/20 23:25 -22.3285 24.6849 4 1 0 3 Botswana
2371 2371     Reunion France 4/2/20 23:25 -21.1151 55.5364 308 0 40 268 Reunion, France
2354 2354     New Caledonia France 4/2/20 23:25 -20.904305 165.618042 18 0 1 17 New Caledonia, France
2501 2501       Mauritius 4/2/20 23:25 -20.348404 57.552152 169 7 0 162 Mauritius
2571 2571       Zimbabwe 4/2/20 23:25 -19.015438 29.154857 9 1 0 8 Zimbabwe
2494 2494       Madagascar 4/2/20 23:25 -18.766947 46.869107 59 0 0 59 Madagascar
2508 2508       Mozambique 4/2/20 23:25 -18.665695 35.529562 10 0 0 10 Mozambique
2450 2450       Fiji 4/2/20 23:25 -17.7134 178.065 7 0 0 7 Fiji
2323 2323     French Polynesia France 4/2/20 23:25 -17.6797 -149.4068 37 0 0 37 French Polynesia, France
2413 2413       Bolivia 4/2/20 23:25 -16.2902 -63.5887 123 8 1 114 Bolivia
2416 2416       Brazil 4/2/20 23:25 -14.235 -51.9253 8044 324 127 7593 Brazil
2534 2534       Samoa 4/2/20 23:31 -13.759 -172.1046 0 0 0 0 Samoa
2495 2495       Malawi 4/2/20 23:25 -13.254308 34.301525 3 0 0 3 Malawi
2570 2570       Zambia 4/2/20 23:25 -13.133897 27.849332 39 1 0 38 Zambia
2351 2351     Mayotte France 4/2/20 23:25 -12.8275 45.166244 116 1 10 105 Mayotte, France
2359 2359     Northern Territory Australia 4/2/20 23:32 -12.4634 130.8456 21 0 0 21 Northern Territory, Australia
2398 2398       Angola 4/2/20 23:25 -11.2027 17.8739 8 2 1 5 Angola
2523 2523       Peru 4/2/20 23:25 -9.19 -75.0152 1414 55 537 822 Peru
2556 2556       Timor-Leste 4/2/20 23:25 -8.874217 125.727539 1 0 0 1 Timor-Leste
2373 2373     Saint Helena, Ascension and Tristan da Cunha United Kingdom 4/2/20 23:25 -7.9467 -14.3559 0 0 0 0 Saint Helena, Ascension and Tristan da Cunha, United Kingdom
2554 2554       Tanzania 4/2/20 23:25 -6.369028 34.888822 20 1 2 17 Tanzania
2521 2521       Papua New Guinea 4/2/20 23:25 -6.314993 143.95555 1 0 0 1 Papua New Guinea
2539 2539       Seychelles 4/2/20 23:25 -4.6796 55.492 10 0 0 10 Seychelles
2430 2430       Congo (Kinshasa) 4/2/20 23:25 -4.322447 15.307045 134 13 3 118 Congo (Kinshasa)
2429 2429       Congo (Brazzaville) 4/2/20 23:25 -4.2634 15.2832 22 2 2 18 Congo (Brazzaville)
2421 2421       Burundi 4/2/20 23:25 -3.3731 29.9189 3 0 0 3 Burundi
2530 2530       Rwanda 4/2/20 23:25 -1.9403 29.8739 84 0 0 84 Rwanda
2442 2442       Ecuador 4/2/20 23:25 -1.8312 -78.1834 3163 120 65 2978 Ecuador
2453 2453       Gabon 4/2/20 23:25 -0.8037 11.6094 21 1 0 20 Gabon
2470 2470       Indonesia 4/2/20 23:25 -0.7893 113.9213 1790 170 112 1508 Indonesia
2480 2480       Kenya 4/2/20 23:25 -0.0236 37.9062 110 3 4 103 Kenya

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [04-02-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
);