04-13-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,003 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
794 794   Federal Correctional Institution (FCI) Michigan US 2020-04-13 23:07:54     21 0 0 21 Federal Correctional Institution (FCI), Michigan, US
1586 1586   McIntosh Georgia US 2020-04-13 23:07:54     3 0 0 3 McIntosh, Georgia, US
1632 1632   Michigan Department of Corrections (MDOC) Michigan US 2020-04-13 23:07:54     370 8 0 362 Michigan Department of Corrections (MDOC), Michigan, US
1864 1864 80015 Out of HI Hawaii US 2020-04-13 23:07:54     2 0 0 2 Out of HI, Hawaii, US
1865 1865   Out of MI Michigan US 2020-04-13 23:07:54     148 1 0 147 Out of MI, Michigan, US
1866 1866 80040 Out of OK Oklahoma US 2020-04-13 23:07:54     0 0 0 0 Out of OK, Oklahoma, US
1867 1867   Out of TN Tennessee US 2020-04-13 23:07:54     260 1 0 259 Out of TN, Tennessee, US
2434 2434 90001 Unassigned Alabama US 2020-04-13 23:07:54     0 0 0 0 Unassigned, Alabama, US
2435 2435 90002 Unassigned Alaska US 2020-04-13 23:07:54     0 3 0 -3 Unassigned, Alaska, US
2436 2436 90004 Unassigned Arizona US 2020-04-13 23:07:54     0 18 0 -18 Unassigned, Arizona, US
2437 2437 90005 Unassigned Arkansas US 2020-04-13 23:07:54     36 0 0 36 Unassigned, Arkansas, US
2438 2438 90006 Unassigned California US 2020-04-13 23:07:54     0 0 0 0 Unassigned, California, US
2439 2439 90008 Unassigned Colorado US 2020-04-13 23:07:54     145 0 0 145 Unassigned, Colorado, US
2440 2440 90009 Unassigned Connecticut US 2020-04-13 23:07:54     491 4 0 487 Unassigned, Connecticut, US
2441 2441 90010 Unassigned Delaware US 2020-04-13 23:07:54     0 7 0 0 Unassigned, Delaware, US
2442 2442 90012 Unassigned Florida US 2020-04-13 23:07:54     2 0 0 2 Unassigned, Florida, US
2443 2443 90013 Unassigned Georgia US 2020-04-13 23:07:54     1219 1 0 1218 Unassigned, Georgia, US
2444 2444 90015 Unassigned Hawaii US 2020-04-13 23:07:54     3 0 0 3 Unassigned, Hawaii, US
2445 2445 90016 Unassigned Idaho US 2020-04-13 23:07:54     0 0 0 0 Unassigned, Idaho, US
2446 2446 90017 Unassigned Illinois US 2020-04-13 23:07:54     65 1 0 64 Unassigned, Illinois, US
2447 2447 90018 Unassigned Indiana US 2020-04-13 23:07:54     0 133 0 0 Unassigned, Indiana, US
2448 2448 90019 Unassigned Iowa US 2020-04-13 23:07:54     0 3 0 -3 Unassigned, Iowa, US
2449 2449 90020 Unassigned Kansas US 2020-04-13 23:07:54     0 4 0 -5 Unassigned, Kansas, US
2450 2450 90021 Unassigned Kentucky US 2020-04-13 23:07:54     112 28 0 84 Unassigned, Kentucky, US
2451 2451 90022 Unassigned Louisiana US 2020-04-13 23:07:54     56 0 0 56 Unassigned, Louisiana, US
2452 2452 90023 Unassigned Maine US 2020-04-13 23:07:54     5 0 0 5 Unassigned, Maine, US
2453 2453 90025 Unassigned Massachusetts US 2020-04-13 23:07:54     447 100 0 347 Unassigned, Massachusetts, US
2454 2454 90026 Unassigned Michigan US 2020-04-13 23:07:54     78 4 0 74 Unassigned, Michigan, US
2455 2455 90027 Unassigned Minnesota US 2020-04-13 23:07:54     5 0 0 5 Unassigned, Minnesota, US
2456 2456 90028 Unassigned Mississippi US 2020-04-13 23:07:54     0 0 0 0 Unassigned, Mississippi, US
2457 2457 90029 Unassigned Missouri US 2020-04-13 23:07:54     0 0 0 0 Unassigned, Missouri, US
2458 2458 90030 Unassigned Montana US 2020-04-13 23:07:54     0 0 0 0 Unassigned, Montana, US
2459 2459 90031 Unassigned Nebraska US 2020-04-13 23:07:54     23 2 0 21 Unassigned, Nebraska, US
2460 2460 90032 Unassigned Nevada US 2020-04-13 23:07:54     0 0 0 0 Unassigned, Nevada, US
2461 2461 90033 Unassigned New Hampshire US 2020-04-13 23:07:54     1 20 0 -19 Unassigned, New Hampshire, US
2462 2462 90034 Unassigned New Jersey US 2020-04-13 23:07:54     1203 2 0 1201 Unassigned, New Jersey, US
2463 2463 90035 Unassigned New Mexico US 2020-04-13 23:07:54     0 0 0 0 Unassigned, New Mexico, US
2464 2464 90036 Unassigned New York US 2020-04-13 23:07:54     0 0 0 0 Unassigned, New York, US
2465 2465 90039 Unassigned Ohio US 2020-04-13 23:07:54     0 0 0 0 Unassigned, Ohio, US
2466 2466 90040 Unassigned Oklahoma US 2020-04-13 23:07:54     0 0 0 0 Unassigned, Oklahoma, US
2467 2467 90041 Unassigned Oregon US 2020-04-13 23:07:54     0 0 0 0 Unassigned, Oregon, US
2468 2468 90042 Unassigned Pennsylvania US 2020-04-13 23:07:54     0 0 0 0 Unassigned, Pennsylvania, US
2469 2469 90044 Unassigned Rhode Island US 2020-04-13 23:07:54     965 37 0 905 Unassigned, Rhode Island, US
2470 2470 90046 Unassigned South Dakota US 2020-04-13 23:07:54     0 0 0 0 Unassigned, South Dakota, US
2471 2471 90047 Unassigned Tennessee US 2020-04-13 23:07:54     46 0 0 46 Unassigned, Tennessee, US
2472 2472 90050 Unassigned Vermont US 2020-04-13 23:07:54     8 0 0 8 Unassigned, Vermont, US
2473 2473 90051 Unassigned Virginia US 2020-04-13 23:07:54     0 70 0 -70 Unassigned, Virginia, US
2474 2474 90053 Unassigned Washington US 2020-04-13 23:07:54     619 0 0 619 Unassigned, Washington, US
2475 2475 90054 Unassigned West Virginia US 2020-04-13 23:07:54     0 2 0 -2 Unassigned, West Virginia, US
2476 2476 90055 Unassigned Wisconsin US 2020-04-13 23:07:54     0 0 0 0 Unassigned, Wisconsin, US
2477 2477   Unassigned Wyoming US 2020-04-13 23:07:54     0 0 0 0 Unassigned, Wyoming, US
2747 2747 88888   Diamond Princess US 2020-04-13 23:07:54     49 0 0 49 Diamond Princess, US
2755 2755     Grand Princess Canada 2020-04-13 23:15:25     13 0 0 13 Grand Princess, Canada
2756 2756 99999   Grand Princess US 2020-04-13 23:07:54     103 0 0 103 Grand Princess, US
2797 2797     Recovered Canada 2020-04-13 23:15:25     0 0 7758 -7758 Recovered, Canada
2798 2798     Recovered US 2020-04-13 23:07:54     0 0 43482 -43482 Recovered, US
2867 2867       Diamond Princess 2020-04-13 23:07:34     712 11 619 82 Diamond Princess
2922 2922       MS Zaandam 2020-04-13 23:07:34     9 2 0 7 MS Zaandam
2748 2748     Falkland Islands (Malvinas) United Kingdom 2020-04-13 23:07:34 -51.7963 -59.5236 5 0 1 4 Falkland Islands (Malvinas), United Kingdom
2812 2812     Tasmania Australia 2020-04-13 23:15:42 -42.8821 147.3272 144 5 48 91 Tasmania, Australia
2941 2941       New Zealand 2020-04-13 23:07:34 -40.9006 174.886 1349 5 546 798 New Zealand
2829 2829       Argentina 2020-04-13 23:07:34 -38.4161 -63.6167 2208 97 515 1596 Argentina
2816 2816     Victoria Australia 2020-04-13 23:15:42 -37.8136 144.9631 1281 14 926 341 Victoria, Australia
2856 2856       Chile 2020-04-13 23:07:34 -35.6751 -71.543 7525 82 2367 5076 Chile
2737 2737     Australian Capital Territory Australia 2020-04-13 23:15:42 -35.4735 149.0124 102 2 59 41 Australian Capital Territory, Australia
2810 2810     South Australia Australia 2020-04-13 23:15:42 -34.9285 138.6007 429 4 179 246 South Australia, Australia
2783 2783     New South Wales Australia 2020-04-13 23:15:42 -33.8688 151.2093 2863 25 4 2834 New South Wales, Australia
2996 2996       Uruguay 2020-04-13 23:07:34 -32.5228 -55.7658 480 8 231 241 Uruguay
2818 2818     Western Australia Australia 2020-04-13 23:15:42 -31.9505 115.8605 517 6 216 295 Western Australia, Australia
2975 2975       South Africa 2020-04-13 23:07:34 -30.5595 22.9375 2272 27 410 1835 South Africa
2796 2796     Queensland Australia 2020-04-13 23:15:42 -27.4698 153.0251 987 5 372 610 Queensland, Australia
2877 2877       Eswatini 2020-04-13 23:07:34 -26.5225 31.4659 15 0 7 8 Eswatini
2951 2951       Paraguay 2020-04-13 23:07:34 -23.4425 -58.4438 147 6 22 119 Paraguay
2938 2938       Namibia 2020-04-13 23:07:34 -22.9576 18.4904 16 0 3 13 Namibia
2844 2844       Botswana 2020-04-13 23:07:34 -22.3285 24.6849 13 1 0 12 Botswana
2799 2799     Reunion France 2020-04-13 23:07:34 -21.1151 55.5364 391 0 40 351 Reunion, France
2782 2782     New Caledonia France 2020-04-13 23:07:34 -20.904304999999997 165.618042 18 0 1 17 New Caledonia, France
2930 2930       Mauritius 2020-04-13 23:07:34 -20.348404000000002 57.552152 324 9 42 273 Mauritius
3003 3003       Zimbabwe 2020-04-13 23:07:34 -19.015438 29.154857 17 3 0 14 Zimbabwe
2923 2923       Madagascar 2020-04-13 23:07:34 -18.766947000000002 46.869107 106 0 21 85 Madagascar
2937 2937       Mozambique 2020-04-13 23:07:34 -18.665695 35.529562 21 0 2 19 Mozambique
2879 2879       Fiji 2020-04-13 23:07:34 -17.7134 178.065 16 0 0 16 Fiji
2751 2751     French Polynesia France 2020-04-13 23:07:34 -17.6797 -149.4068 55 0 0 55 French Polynesia, France
2842 2842       Bolivia 2020-04-13 23:07:34 -16.2902 -63.5887 330 27 2 301 Bolivia
2845 2845       Brazil 2020-04-13 23:07:34 -14.235 -51.9253 23430 1328 173 21929 Brazil
2963 2963       Samoa 2020-04-13 23:15:25 -13.759 -172.1046 0 0 0 0 Samoa
2924 2924       Malawi 2020-04-13 23:07:34 -13.254307999999998 34.301525 16 2 0 14 Malawi
3002 3002       Zambia 2020-04-13 23:07:34 -13.133897 27.849332 45 2 30 13 Zambia
2779 2779     Mayotte France 2020-04-13 23:07:34 -12.8275 45.166244 207 3 59 145 Mayotte, France
2787 2787     Northern Territory Australia 2020-04-13 23:15:42 -12.4634 130.8456 28 0 2 26 Northern Territory, Australia
2827 2827       Angola 2020-04-13 23:07:34 -11.2027 17.8739 19 2 4 13 Angola
2952 2952       Peru 2020-04-13 23:07:34 -9.19 -75.0152 9784 216 2642 6926 Peru
2987 2987       Timor-Leste 2020-04-13 23:07:34 -8.874217 125.727539 4 0 1 3 Timor-Leste
2801 2801     Saint Helena, Ascension and Tristan da Cunha United Kingdom 2020-04-13 23:07:34 -7.9467 -14.3559 0 0 0 0 Saint Helena, Ascension and Tristan da Cunha, United Kingdom
2985 2985       Tanzania 2020-04-13 23:07:34 -6.369028 34.888822 49 3 7 39 Tanzania
2950 2950       Papua New Guinea 2020-04-13 23:07:34 -6.314993 143.95555 2 0 0 2 Papua New Guinea
2969 2969       Seychelles 2020-04-13 23:07:34 -4.6796 55.492 11 0 0 11 Seychelles
2859 2859       Congo (Kinshasa) 2020-04-13 23:07:34 -4.322447 15.307045 235 20 17 198 Congo (Kinshasa)
2858 2858       Congo (Brazzaville) 2020-04-13 23:07:34 -4.2634 15.2832 60 5 5 50 Congo (Brazzaville)
2850 2850       Burundi 2020-04-13 23:07:34 -3.3731 29.9189 5 1 0 4 Burundi

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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