04-19-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,074 rows sorted by Lat

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: Last_Update (date)

Link rowid FIPS Admin2 Province_State Country_Region Last_Update Lat ▼ Long_ Confirmed Deaths Recovered Active Combined_Key
809 809   Federal Correctional Institution (FCI) Michigan US 2020-04-19 23:41:01     51 0 0 51 Federal Correctional Institution (FCI), Michigan, US
1665 1665   Michigan Department of Corrections (MDOC) Michigan US 2020-04-19 23:41:01     556 17 0 539 Michigan Department of Corrections (MDOC), Michigan, US
1908 1908 80013 Out of GA Georgia US 2020-04-19 23:41:01     868 7 0 861 Out of GA, Georgia, US
1909 1909 80015 Out of HI Hawaii US 2020-04-19 23:41:01     6 0 0 6 Out of HI, Hawaii, US
1910 1910 80026 Out of MI Michigan US 2020-04-19 23:41:01     76 2 0 74 Out of MI, Michigan, US
1911 1911 80040 Out of OK Oklahoma US 2020-04-19 23:41:01     0 0 0 0 Out of OK, Oklahoma, US
1912 1912 80047 Out of TN Tennessee US 2020-04-19 23:41:01     274 1 0 273 Out of TN, Tennessee, US
2496 2496 90001 Unassigned Alabama US 2020-04-19 23:41:01     0 0 0 0 Unassigned, Alabama, US
2497 2497 90002 Unassigned Alaska US 2020-04-19 23:41:01     0 4 0 -4 Unassigned, Alaska, US
2498 2498 90004 Unassigned Arizona US 2020-04-19 23:41:01     0 1 0 -1 Unassigned, Arizona, US
2499 2499 90005 Unassigned Arkansas US 2020-04-19 23:41:01     46 0 0 46 Unassigned, Arkansas, US
2500 2500 90006 Unassigned California US 2020-04-19 23:41:01     0 2 0 -2 Unassigned, California, US
2501 2501 90008 Unassigned Colorado US 2020-04-19 23:41:01     114 1 0 113 Unassigned, Colorado, US
2502 2502 90009 Unassigned Connecticut US 2020-04-19 23:41:01     529 4 0 525 Unassigned, Connecticut, US
2503 2503 90010 Unassigned Delaware US 2020-04-19 23:41:01     30 0 0 30 Unassigned, Delaware, US
2504 2504 90012 Unassigned Florida US 2020-04-19 23:41:01     3 0 0 3 Unassigned, Florida, US
2505 2505 90013 Unassigned Georgia US 2020-04-19 23:41:01     254 0 0 254 Unassigned, Georgia, US
2506 2506 90015 Unassigned Hawaii US 2020-04-19 23:41:01     0 0 0 0 Unassigned, Hawaii, US
2507 2507 90016 Unassigned Idaho US 2020-04-19 23:41:01     0 0 0 0 Unassigned, Idaho, US
2508 2508 90017 Unassigned Illinois US 2020-04-19 23:41:01     115 3 0 112 Unassigned, Illinois, US
2509 2509 90018 Unassigned Indiana US 2020-04-19 23:41:01     0 140 0 0 Unassigned, Indiana, US
2510 2510 90019 Unassigned Iowa US 2020-04-19 23:41:01     7 0 0 7 Unassigned, Iowa, US
2511 2511 90020 Unassigned Kansas US 2020-04-19 23:41:01     0 0 0 0 Unassigned, Kansas, US
2512 2512 90021 Unassigned Kentucky US 2020-04-19 23:41:01     79 6 0 73 Unassigned, Kentucky, US
2513 2513 90022 Unassigned Louisiana US 2020-04-19 23:41:01     58 1 0 57 Unassigned, Louisiana, US
2514 2514 90023 Unassigned Maine US 2020-04-19 23:41:01     2 0 0 2 Unassigned, Maine, US
2515 2515 90025 Unassigned Massachusetts US 2020-04-19 23:41:01     815 20 0 795 Unassigned, Massachusetts, US
2516 2516 90026 Unassigned Michigan US 2020-04-19 23:41:01     29 4 0 25 Unassigned, Michigan, US
2517 2517 90027 Unassigned Minnesota US 2020-04-19 23:41:01     4 0 0 4 Unassigned, Minnesota, US
2518 2518 90028 Unassigned Mississippi US 2020-04-19 23:41:01     0 0 0 0 Unassigned, Mississippi, US
2519 2519 90029 Unassigned Missouri US 2020-04-19 23:41:01     0 0 0 0 Unassigned, Missouri, US
2520 2520 90030 Unassigned Montana US 2020-04-19 23:41:01     0 0 0 0 Unassigned, Montana, US
2521 2521 90031 Unassigned Nebraska US 2020-04-19 23:41:01     40 10 0 30 Unassigned, Nebraska, US
2522 2522 90032 Unassigned Nevada US 2020-04-19 23:41:01     20 0 0 20 Unassigned, Nevada, US
2523 2523 90033 Unassigned New Hampshire US 2020-04-19 23:41:01     0 35 0 -35 Unassigned, New Hampshire, US
2524 2524 90034 Unassigned New Jersey US 2020-04-19 23:41:01     585 0 0 585 Unassigned, New Jersey, US
2525 2525 90035 Unassigned New Mexico US 2020-04-19 23:41:01     0 0 0 0 Unassigned, New Mexico, US
2526 2526 90036 Unassigned New York US 2020-04-19 23:41:01     0 401 0 -401 Unassigned, New York, US
2527 2527 90037 Unassigned North Carolina US 2020-04-19 23:41:01     3 0 0 3 Unassigned, North Carolina, US
2528 2528 90039 Unassigned Ohio US 2020-04-19 23:41:01     0 0 0 0 Unassigned, Ohio, US
2529 2529 90040 Unassigned Oklahoma US 2020-04-19 23:41:01     0 0 0 0 Unassigned, Oklahoma, US
2530 2530 90041 Unassigned Oregon US 2020-04-19 23:41:01     0 0 0 0 Unassigned, Oregon, US
2531 2531 90042 Unassigned Pennsylvania US 2020-04-19 23:41:01     0 0 0 0 Unassigned, Pennsylvania, US
2532 2532 90044 Unassigned Rhode Island US 2020-04-19 23:41:01     1030 54 0 883 Unassigned, Rhode Island, US
2533 2533 90046 Unassigned South Dakota US 2020-04-19 23:41:01     0 0 0 0 Unassigned, South Dakota, US
2534 2534 90047 Unassigned Tennessee US 2020-04-19 23:41:01     88 0 0 88 Unassigned, Tennessee, US
2535 2535 90049 Unassigned Utah US 2020-04-19 23:41:01     0 0 0 0 Unassigned, Utah, US
2536 2536 90050 Unassigned Vermont US 2020-04-19 23:41:01     10 1 0 9 Unassigned, Vermont, US
2537 2537 90051 Unassigned Virginia US 2020-04-19 23:41:01     0 113 0 -113 Unassigned, Virginia, US
2538 2538 90053 Unassigned Washington US 2020-04-19 23:41:01     436 0 0 436 Unassigned, Washington, US
2539 2539 90054 Unassigned West Virginia US 2020-04-19 23:41:01     0 11 0 -11 Unassigned, West Virginia, US
2540 2540 90055 Unassigned Wisconsin US 2020-04-19 23:41:01     0 0 0 0 Unassigned, Wisconsin, US
2541 2541 90056 Unassigned Wyoming US 2020-04-19 23:41:01     0 1 0 -1 Unassigned, Wyoming, US
2818 2818 88888   Diamond Princess US 2020-04-19 23:41:01     49 0 0 49 Diamond Princess, US
2826 2826     Grand Princess Canada 2020-04-19 23:48:49     13 0 0 13 Grand Princess, Canada
2827 2827 99999   Grand Princess US 2020-04-19 23:41:01     103 0 0 103 Grand Princess, US
2868 2868     Recovered Canada 2020-04-19 23:48:49     0 0 11847 -11847 Recovered, Canada
2869 2869     Recovered US 2020-04-19 23:41:01     0 0 70337 -70337 Recovered, US
2938 2938       Diamond Princess 2020-04-19 23:40:41     712 13 644 55 Diamond Princess
2993 2993       MS Zaandam 2020-04-19 23:40:41     9 2 0 7 MS Zaandam
2819 2819     Falkland Islands (Malvinas) United Kingdom 2020-04-19 23:40:41 -51.7963 -59.5236 11 0 3 8 Falkland Islands (Malvinas), United Kingdom
2883 2883     Tasmania Australia 2020-04-19 23:49:05 -42.8821 147.3272 180 7 67 106 Tasmania, Australia
3012 3012       New Zealand 2020-04-19 23:40:41 -40.9006 174.886 1431 12 912 507 New Zealand
2900 2900       Argentina 2020-04-19 23:40:41 -38.4161 -63.6167 2839 132 709 1998 Argentina
2887 2887     Victoria Australia 2020-04-19 23:49:05 -37.8136 144.9631 1319 14 1172 133 Victoria, Australia
2927 2927       Chile 2020-04-19 23:40:41 -35.6751 -71.543 10088 133 4338 5617 Chile
2808 2808     Australian Capital Territory Australia 2020-04-19 23:49:05 -35.4735 149.0124 103 3 88 12 Australian Capital Territory, Australia
2881 2881     South Australia Australia 2020-04-19 23:49:05 -34.9285 138.6007 435 4 331 100 South Australia, Australia
2854 2854     New South Wales Australia 2020-04-19 23:49:05 -33.8688 151.2093 2926 26 1379 1521 New South Wales, Australia
3067 3067       Uruguay 2020-04-19 23:40:41 -32.5228 -55.7658 517 10 298 209 Uruguay
2889 2889     Western Australia Australia 2020-04-19 23:49:05 -31.9505 115.8605 541 7 340 194 Western Australia, Australia
3046 3046       South Africa 2020-04-19 23:40:41 -30.5595 22.9375 3158 54 903 2201 South Africa
2867 2867     Queensland Australia 2020-04-19 23:49:05 -27.4698 153.0251 1015 6 738 271 Queensland, Australia
2948 2948       Eswatini 2020-04-19 23:40:41 -26.5225 31.4659 22 1 8 13 Eswatini
3022 3022       Paraguay 2020-04-19 23:40:41 -23.4425 -58.4438 206 8 41 157 Paraguay
3009 3009       Namibia 2020-04-19 23:40:41 -22.9576 18.4904 16 0 6 10 Namibia
2915 2915       Botswana 2020-04-19 23:40:41 -22.3285 24.6849 20 1 0 19 Botswana
2870 2870     Reunion France 2020-04-19 23:40:41 -21.1151 55.5364 408 0 237 171 Reunion, France
2853 2853     New Caledonia France 2020-04-19 23:40:41 -20.904305 165.618042 18 0 15 3 New Caledonia, France
3001 3001       Mauritius 2020-04-19 23:40:41 -20.348404 57.552152 328 9 208 111 Mauritius
3074 3074       Zimbabwe 2020-04-19 23:40:41 -19.015438 29.154857 25 3 2 20 Zimbabwe
2994 2994       Madagascar 2020-04-19 23:40:41 -18.766947 46.869107 121 0 39 82 Madagascar
3008 3008       Mozambique 2020-04-19 23:40:41 -18.665695 35.529562 39 0 8 31 Mozambique
2950 2950       Fiji 2020-04-19 23:40:41 -17.7134 178.065 17 0 0 17 Fiji
2822 2822     French Polynesia France 2020-04-19 23:40:41 -17.6797 -149.4068 55 0 2 53 French Polynesia, France
2913 2913       Bolivia 2020-04-19 23:40:41 -16.2902 -63.5887 520 32 31 457 Bolivia
2916 2916       Brazil 2020-04-19 23:40:41 -14.235 -51.9253 38654 2462 22130 14062 Brazil
3034 3034       Samoa 2020-04-19 23:48:49 -13.759 -172.1046 0 0 0 0 Samoa
2995 2995       Malawi 2020-04-19 23:40:41 -13.254308 34.301525 17 2 3 12 Malawi
3073 3073       Zambia 2020-04-19 23:40:41 -13.133897 27.849332 61 3 33 25 Zambia
2850 2850     Mayotte France 2020-04-19 23:40:41 -12.8275 45.166244 271 4 117 150 Mayotte, France
2858 2858     Northern Territory Australia 2020-04-19 23:49:05 -12.4634 130.8456 28 0 9 19 Northern Territory, Australia
2898 2898       Angola 2020-04-19 23:40:41 -11.2027 17.8739 24 2 6 16 Angola
3023 3023       Peru 2020-04-19 23:40:41 -9.19 -75.0152 15628 400 6811 8417 Peru
3058 3058       Timor-Leste 2020-04-19 23:40:41 -8.874217 125.727539 19 0 1 18 Timor-Leste
2872 2872     Saint Helena, Ascension and Tristan da Cunha United Kingdom 2020-04-19 23:40:41 -7.9467 -14.3559 0 0 0 0 Saint Helena, Ascension and Tristan da Cunha, United Kingdom
3056 3056       Tanzania 2020-04-19 23:40:41 -6.369028 34.888822 170 7 11 152 Tanzania
3021 3021       Papua New Guinea 2020-04-19 23:40:41 -6.314993 143.95555 7 0 0 7 Papua New Guinea
3040 3040       Seychelles 2020-04-19 23:40:41 -4.6796 55.492 11 0 5 6 Seychelles
2930 2930       Congo (Kinshasa) 2020-04-19 23:40:41 -4.322447 15.307045 327 25 26 276 Congo (Kinshasa)

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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