04-12-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,990 rows sorted by Lat

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: Last_Update, Last_Update (date)

Link rowid FIPS Admin2 Province_State Country_Region Last_Update Lat ▼ Long_ Confirmed Deaths Recovered Active Combined_Key
1576 1576   McIntosh Georgia US 2020-04-12 23:18:00     3 0 0 3 McIntosh, Georgia, US
1850 1850 80015 Out of HI Hawaii US 2020-04-12 23:18:00     2 0 0 2 Out of HI, Hawaii, US
1851 1851   Out of MI Michigan US 2020-04-12 23:18:00     144 1 0 143 Out of MI, Michigan, US
1852 1852 80040 Out of OK Oklahoma US 2020-04-12 23:18:00     0 0 0 0 Out of OK, Oklahoma, US
1853 1853   Out of TN Tennessee US 2020-04-12 23:18:00     276 1 0 275 Out of TN, Tennessee, US
2420 2420 90001 Unassigned Alabama US 2020-04-12 23:18:00     0 0 0 0 Unassigned, Alabama, US
2421 2421 90002 Unassigned Alaska US 2020-04-12 23:18:00     0 3 0 -3 Unassigned, Alaska, US
2422 2422 90004 Unassigned Arizona US 2020-04-12 23:18:00     0 22 0 -22 Unassigned, Arizona, US
2423 2423 90005 Unassigned Arkansas US 2020-04-12 23:18:00     25 0 0 25 Unassigned, Arkansas, US
2424 2424 90006 Unassigned California US 2020-04-12 23:18:00     8 0 0 8 Unassigned, California, US
2425 2425 90008 Unassigned Colorado US 2020-04-12 23:18:00     156 0 0 156 Unassigned, Colorado, US
2426 2426 90009 Unassigned Connecticut US 2020-04-12 23:18:00     501 4 0 497 Unassigned, Connecticut, US
2427 2427 90010 Unassigned Delaware US 2020-04-12 23:18:00     0 5 0 -2 Unassigned, Delaware, US
2428 2428 90012 Unassigned Florida US 2020-04-12 23:18:00     2 0 0 2 Unassigned, Florida, US
2429 2429 90013 Unassigned Georgia US 2020-04-12 23:18:00     1218 4 0 1214 Unassigned, Georgia, US
2430 2430 90015 Unassigned Hawaii US 2020-04-12 23:18:00     3 0 0 3 Unassigned, Hawaii, US
2431 2431 90016 Unassigned Idaho US 2020-04-12 23:18:00     0 0 0 0 Unassigned, Idaho, US
2432 2432 90017 Unassigned Illinois US 2020-04-12 23:18:00     101 1 0 100 Unassigned, Illinois, US
2433 2433 90018 Unassigned Indiana US 2020-04-12 23:18:00     0 105 0 0 Unassigned, Indiana, US
2434 2434 90019 Unassigned Iowa US 2020-04-12 23:18:00     0 6 0 -6 Unassigned, Iowa, US
2435 2435 90020 Unassigned Kansas US 2020-04-12 23:18:00     0 11 0 -4 Unassigned, Kansas, US
2436 2436 90021 Unassigned Kentucky US 2020-04-12 23:18:00     112 28 0 84 Unassigned, Kentucky, US
2437 2437 90022 Unassigned Louisiana US 2020-04-12 23:18:00     54 3 0 51 Unassigned, Louisiana, US
2438 2438 90023 Unassigned Maine US 2020-04-12 23:18:00     3 0 0 3 Unassigned, Maine, US
2439 2439 90025 Unassigned Massachusetts US 2020-04-12 23:18:00     373 12 0 361 Unassigned, Massachusetts, US
2440 2440 90026 Unassigned Michigan US 2020-04-12 23:18:00     86 12 0 74 Unassigned, Michigan, US
2441 2441 90027 Unassigned Minnesota US 2020-04-12 23:18:00     5 0 0 5 Unassigned, Minnesota, US
2442 2442 90028 Unassigned Mississippi US 2020-04-12 23:18:00     0 0 0 0 Unassigned, Mississippi, US
2443 2443 90029 Unassigned Missouri US 2020-04-12 23:18:00     0 1 0 -1 Unassigned, Missouri, US
2444 2444 90030 Unassigned Montana US 2020-04-12 23:18:00     0 0 0 0 Unassigned, Montana, US
2445 2445 90031 Unassigned Nebraska US 2020-04-12 23:18:00     23 2 0 21 Unassigned, Nebraska, US
2446 2446 90032 Unassigned Nevada US 2020-04-12 23:18:00     23 0 0 23 Unassigned, Nevada, US
2447 2447 90033 Unassigned New Hampshire US 2020-04-12 23:18:00     1 20 0 -19 Unassigned, New Hampshire, US
2448 2448 90034 Unassigned New Jersey US 2020-04-12 23:18:00     1274 2 0 1272 Unassigned, New Jersey, US
2449 2449 90035 Unassigned New Mexico US 2020-04-12 23:18:00     0 0 0 0 Unassigned, New Mexico, US
2450 2450 90036 Unassigned New York US 2020-04-12 23:18:00     0 40 0 -40 Unassigned, New York, US
2451 2451 90039 Unassigned Ohio US 2020-04-12 23:18:00     2 0 0 2 Unassigned, Ohio, US
2452 2452 90040 Unassigned Oklahoma US 2020-04-12 23:18:00     0 0 0 0 Unassigned, Oklahoma, US
2453 2453 90041 Unassigned Oregon US 2020-04-12 23:18:00     1 0 0 1 Unassigned, Oregon, US
2454 2454 90042 Unassigned Pennsylvania US 2020-04-12 23:18:00     0 0 0 0 Unassigned, Pennsylvania, US
2455 2455 90044 Unassigned Rhode Island US 2020-04-12 23:18:00     965 28 0 905 Unassigned, Rhode Island, US
2456 2456 90046 Unassigned South Dakota US 2020-04-12 23:18:00     0 0 0 0 Unassigned, South Dakota, US
2457 2457 90047 Unassigned Tennessee US 2020-04-12 23:18:00     12 0 0 12 Unassigned, Tennessee, US
2458 2458 90050 Unassigned Vermont US 2020-04-12 23:18:00     7 0 0 7 Unassigned, Vermont, US
2459 2459 90051 Unassigned Virginia US 2020-04-12 23:18:00     0 62 0 -62 Unassigned, Virginia, US
2460 2460 90053 Unassigned Washington US 2020-04-12 23:18:00     732 0 0 732 Unassigned, Washington, US
2461 2461 90054 Unassigned West Virginia US 2020-04-12 23:18:00     0 2 0 -2 Unassigned, West Virginia, US
2462 2462 90055 Unassigned Wisconsin US 2020-04-12 23:18:00     0 0 0 0 Unassigned, Wisconsin, US
2463 2463   Unassigned Wyoming US 2020-04-12 23:18:00     0 0 0 0 Unassigned, Wyoming, US
2733 2733 88888   Diamond Princess US 2020-04-12 23:18:00     49 0 0 49 Diamond Princess, US
2741 2741     Grand Princess Canada 2020-04-12 23:24:00     13 0 0 13 Grand Princess, Canada
2742 2742 99999   Grand Princess US 2020-04-12 23:18:00     103 0 0 103 Grand Princess, US
2783 2783     Recovered Canada 2020-04-12 23:24:00     0 0 7123 -7123 Recovered, Canada
2784 2784     Recovered US 2020-04-12 23:18:00     0 0 32988 -32988 Recovered, US
2853 2853       Diamond Princess 2020-04-12 23:17:00     712 11 619 82 Diamond Princess
2908 2908       MS Zaandam 2020-04-12 23:17:00     9 2 0 7 MS Zaandam
2990 2990   unassigned Utah US 2020-04-12 23:18:00     4 5 0 -1 unassigned, Utah, US
2734 2734     Falkland Islands (Malvinas) United Kingdom 2020-04-12 23:17:00 -51.7963 -59.5236 5 0 1 4 Falkland Islands (Malvinas), United Kingdom
2798 2798     Tasmania Australia 2020-04-12 23:25:00 -42.8821 147.3272 133 5 48 80 Tasmania, Australia
2927 2927       New Zealand 2020-04-12 23:17:00 -40.9006 174.886 1330 4 471 855 New Zealand
2815 2815       Argentina 2020-04-12 23:17:00 -38.4161 -63.6167 2142 90 468 1584 Argentina
2802 2802     Victoria Australia 2020-04-12 23:25:00 -37.8136 144.9631 1268 14 926 328 Victoria, Australia
2842 2842       Chile 2020-04-12 23:17:00 -35.6751 -71.543 7213 80 2059 5074 Chile
2723 2723     Australian Capital Territory Australia 2020-04-12 23:25:00 -35.4735 149.0124 103 2 59 42 Australian Capital Territory, Australia
2796 2796     South Australia Australia 2020-04-12 23:25:00 -34.9285 138.6007 429 4 179 246 South Australia, Australia
2769 2769     New South Wales Australia 2020-04-12 23:25:00 -33.8688 151.2093 2857 24 4 2829 New South Wales, Australia
2982 2982       Uruguay 2020-04-12 23:17:00 -32.5228 -55.7658 480 7 231 242 Uruguay
2804 2804     Western Australia Australia 2020-04-12 23:25:00 -31.9505 115.8605 514 6 216 292 Western Australia, Australia
2961 2961       South Africa 2020-04-12 23:17:00 -30.5595 22.9375 2173 25 410 1738 South Africa
2782 2782     Queensland Australia 2020-04-12 23:25:00 -27.4698 153.0251 983 5 372 606 Queensland, Australia
2863 2863       Eswatini 2020-04-12 23:17:00 -26.5225 31.4659 14 0 7 7 Eswatini
2937 2937       Paraguay 2020-04-12 23:17:00 -23.4425 -58.4438 134 6 22 106 Paraguay
2924 2924       Namibia 2020-04-12 23:17:00 -22.9576 18.4904 16 0 3 13 Namibia
2830 2830       Botswana 2020-04-12 23:17:00 -22.3285 24.6849 13 1 0 12 Botswana
2785 2785     Reunion France 2020-04-12 23:17:00 -21.1151 55.5364 389 0 40 349 Reunion, France
2768 2768     New Caledonia France 2020-04-12 23:17:00 -20.904305 165.618042 18 0 1 17 New Caledonia, France
2916 2916       Mauritius 2020-04-12 23:17:00 -20.348404 57.552152 324 9 42 273 Mauritius
2989 2989       Zimbabwe 2020-04-12 23:17:00 -19.015438 29.154857 14 3 0 11 Zimbabwe
2909 2909       Madagascar 2020-04-12 23:17:00 -18.766947 46.869107 106 0 20 86 Madagascar
2923 2923       Mozambique 2020-04-12 23:17:00 -18.665695 35.529562 21 0 2 19 Mozambique
2865 2865       Fiji 2020-04-12 23:17:00 -17.7134 178.065 16 0 0 16 Fiji
2737 2737     French Polynesia France 2020-04-12 23:17:00 -17.6797 -149.4068 53 0 0 53 French Polynesia, France
2828 2828       Bolivia 2020-04-12 23:17:00 -16.2902 -63.5887 300 24 2 274 Bolivia
2831 2831       Brazil 2020-04-12 23:17:00 -14.235 -51.9253 22192 1223 173 20796 Brazil
2949 2949       Samoa 2020-04-12 23:24:00 -13.759 -172.1046 0 0 0 0 Samoa
2910 2910       Malawi 2020-04-12 23:17:00 -13.254308 34.301525 13 2 0 11 Malawi
2988 2988       Zambia 2020-04-12 23:17:00 -13.133897 27.849332 43 2 30 11 Zambia
2765 2765     Mayotte France 2020-04-12 23:17:00 -12.8275 45.166244 196 3 59 134 Mayotte, France
2773 2773     Northern Territory Australia 2020-04-12 23:25:00 -12.4634 130.8456 28 0 2 26 Northern Territory, Australia
2813 2813       Angola 2020-04-12 23:17:00 -11.2027 17.8739 19 2 4 13 Angola
2938 2938       Peru 2020-04-12 23:17:00 -9.19 -75.0152 7519 193 1798 5528 Peru
2973 2973       Timor-Leste 2020-04-12 23:17:00 -8.874217 125.727539 2 0 1 1 Timor-Leste
2787 2787     Saint Helena, Ascension and Tristan da Cunha United Kingdom 2020-04-12 23:17:00 -7.9467 -14.3559 0 0 0 0 Saint Helena, Ascension and Tristan da Cunha, United Kingdom
2971 2971       Tanzania 2020-04-12 23:17:00 -6.369028 34.888822 32 3 5 24 Tanzania
2936 2936       Papua New Guinea 2020-04-12 23:17:00 -6.314993 143.95555 2 0 0 2 Papua New Guinea
2955 2955       Seychelles 2020-04-12 23:17:00 -4.6796 55.492 11 0 0 11 Seychelles
2845 2845       Congo (Kinshasa) 2020-04-12 23:17:00 -4.322447 15.307045 234 20 16 198 Congo (Kinshasa)
2844 2844       Congo (Brazzaville) 2020-04-12 23:17:00 -4.2634 15.2832 60 5 5 50 Congo (Brazzaville)
2836 2836       Burundi 2020-04-12 23:17:00 -3.3731 29.9189 5 0 0 5 Burundi
2945 2945       Rwanda 2020-04-12 23:17:00 -1.9403 29.8739 126 0 25 101 Rwanda

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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