04-16-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,043 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
802 802   Federal Correctional Institution (FCI) Michigan US 2020-04-16 23:30:51     36 0 0 36 Federal Correctional Institution (FCI), Michigan, US
1652 1652   Michigan Department of Corrections (MDOC) Michigan US 2020-04-16 23:30:51     472 12 0 460 Michigan Department of Corrections (MDOC), Michigan, US
1889 1889 80013 Out of GA Georgia US 2020-04-16 23:30:51     707 0 0 707 Out of GA, Georgia, US
1890 1890 80015 Out of HI Hawaii US 2020-04-16 23:30:51     6 0 0 6 Out of HI, Hawaii, US
1891 1891 80026 Out of MI Michigan US 2020-04-16 23:30:51     166 2 0 164 Out of MI, Michigan, US
1892 1892 80040 Out of OK Oklahoma US 2020-04-16 23:30:51     0 0 0 0 Out of OK, Oklahoma, US
1893 1893 80047 Out of TN Tennessee US 2020-04-16 23:30:51     243 1 0 242 Out of TN, Tennessee, US
2470 2470 90001 Unassigned Alabama US 2020-04-16 23:30:51     0 0 0 0 Unassigned, Alabama, US
2471 2471 90002 Unassigned Alaska US 2020-04-16 23:30:51     0 4 0 -4 Unassigned, Alaska, US
2472 2472 90004 Unassigned Arizona US 2020-04-16 23:30:51     0 28 0 -28 Unassigned, Arizona, US
2473 2473 90005 Unassigned Arkansas US 2020-04-16 23:30:51     44 0 0 44 Unassigned, Arkansas, US
2474 2474 90006 Unassigned California US 2020-04-16 23:30:51     0 0 0 0 Unassigned, California, US
2475 2475 90008 Unassigned Colorado US 2020-04-16 23:30:51     111 1 0 110 Unassigned, Colorado, US
2476 2476 90009 Unassigned Connecticut US 2020-04-16 23:30:51     534 2 0 532 Unassigned, Connecticut, US
2477 2477 90010 Unassigned Delaware US 2020-04-16 23:30:51     17 10 0 14 Unassigned, Delaware, US
2478 2478 90012 Unassigned Florida US 2020-04-16 23:30:51     6 0 0 6 Unassigned, Florida, US
2479 2479 90013 Unassigned Georgia US 2020-04-16 23:30:51     144 0 0 144 Unassigned, Georgia, US
2480 2480 90015 Unassigned Hawaii US 2020-04-16 23:30:51     1 0 0 1 Unassigned, Hawaii, US
2481 2481 90016 Unassigned Idaho US 2020-04-16 23:30:51     0 0 0 0 Unassigned, Idaho, US
2482 2482 90017 Unassigned Illinois US 2020-04-16 23:30:51     55 1 0 54 Unassigned, Illinois, US
2483 2483 90018 Unassigned Indiana US 2020-04-16 23:30:51     0 125 0 -1 Unassigned, Indiana, US
2484 2484 90019 Unassigned Iowa US 2020-04-16 23:30:51     0 0 0 0 Unassigned, Iowa, US
2485 2485 90020 Unassigned Kansas US 2020-04-16 23:30:51     0 0 0 0 Unassigned, Kansas, US
2486 2486 90021 Unassigned Kentucky US 2020-04-16 23:30:51     77 0 0 77 Unassigned, Kentucky, US
2487 2487 90022 Unassigned Louisiana US 2020-04-16 23:30:51     56 1 0 55 Unassigned, Louisiana, US
2488 2488 90023 Unassigned Maine US 2020-04-16 23:30:51     2 0 0 2 Unassigned, Maine, US
2489 2489 90025 Unassigned Massachusetts US 2020-04-16 23:30:51     638 14 0 624 Unassigned, Massachusetts, US
2490 2490 90026 Unassigned Michigan US 2020-04-16 23:30:51     76 5 0 71 Unassigned, Michigan, US
2491 2491 90027 Unassigned Minnesota US 2020-04-16 23:30:51     2 0 0 2 Unassigned, Minnesota, US
2492 2492 90028 Unassigned Mississippi US 2020-04-16 23:30:51     0 0 0 0 Unassigned, Mississippi, US
2493 2493 90029 Unassigned Missouri US 2020-04-16 23:30:51     0 0 0 0 Unassigned, Missouri, US
2494 2494 90030 Unassigned Montana US 2020-04-16 23:30:51     0 0 0 0 Unassigned, Montana, US
2495 2495 90031 Unassigned Nebraska US 2020-04-16 23:30:51     23 6 0 17 Unassigned, Nebraska, US
2496 2496 90032 Unassigned Nevada US 2020-04-16 23:30:51     2 6 0 -4 Unassigned, Nevada, US
2497 2497 90033 Unassigned New Hampshire US 2020-04-16 23:30:51     0 29 0 -29 Unassigned, New Hampshire, US
2498 2498 90034 Unassigned New Jersey US 2020-04-16 23:30:51     1048 3 0 1045 Unassigned, New Jersey, US
2499 2499 90035 Unassigned New Mexico US 2020-04-16 23:30:51     0 0 0 0 Unassigned, New Mexico, US
2500 2500 90036 Unassigned New York US 2020-04-16 23:30:51     0 0 0 0 Unassigned, New York, US
2501 2501 90039 Unassigned Ohio US 2020-04-16 23:30:51     0 16 0 -16 Unassigned, Ohio, US
2502 2502 90040 Unassigned Oklahoma US 2020-04-16 23:30:51     0 0 0 0 Unassigned, Oklahoma, US
2503 2503 90041 Unassigned Oregon US 2020-04-16 23:30:51     0 0 0 0 Unassigned, Oregon, US
2504 2504 90042 Unassigned Pennsylvania US 2020-04-16 23:30:51     0 0 0 0 Unassigned, Pennsylvania, US
2505 2505 90044 Unassigned Rhode Island US 2020-04-16 23:30:51     902 76 0 818 Unassigned, Rhode Island, US
2506 2506 90046 Unassigned South Dakota US 2020-04-16 23:30:51     0 0 0 0 Unassigned, South Dakota, US
2507 2507 90047 Unassigned Tennessee US 2020-04-16 23:30:51     197 0 0 197 Unassigned, Tennessee, US
2508 2508 90049 Unassigned Utah US 2020-04-16 23:30:51     0 7 0 -7 Unassigned, Utah, US
2509 2509 90050 Unassigned Vermont US 2020-04-16 23:30:51     15 0 0 15 Unassigned, Vermont, US
2510 2510 90051 Unassigned Virginia US 2020-04-16 23:30:51     0 77 0 -77 Unassigned, Virginia, US
2511 2511 90053 Unassigned Washington US 2020-04-16 23:30:51     272 0 0 272 Unassigned, Washington, US
2512 2512 90054 Unassigned West Virginia US 2020-04-16 23:30:51     0 6 0 -6 Unassigned, West Virginia, US
2513 2513 90055 Unassigned Wisconsin US 2020-04-16 23:30:51     0 0 0 0 Unassigned, Wisconsin, US
2514 2514 90056 Unassigned Wyoming US 2020-04-16 23:30:51     0 1 0 -1 Unassigned, Wyoming, US
2787 2787 88888   Diamond Princess US 2020-04-16 23:30:51     49 0 0 49 Diamond Princess, US
2795 2795     Grand Princess Canada 2020-04-16 23:38:03     13 0 0 13 Grand Princess, Canada
2796 2796 99999   Grand Princess US 2020-04-16 23:30:51     103 0 0 103 Grand Princess, US
2837 2837     Recovered Canada 2020-04-16 23:38:03     0 0 9698 -9698 Recovered, Canada
2838 2838     Recovered US 2020-04-16 23:30:51     0 0 54703 -54703 Recovered, US
2907 2907       Diamond Princess 2020-04-16 23:30:31     712 12 644 56 Diamond Princess
2962 2962       MS Zaandam 2020-04-16 23:30:31     9 2 0 7 MS Zaandam
2788 2788     Falkland Islands (Malvinas) United Kingdom 2020-04-16 23:30:31 -51.7963 -59.5236 11 0 1 10 Falkland Islands (Malvinas), United Kingdom
2852 2852     Tasmania Australia 2020-04-16 23:38:19 -42.8821 147.3272 169 6 67 96 Tasmania, Australia
2981 2981       New Zealand 2020-04-16 23:30:31 -40.9006 174.886 1401 9 770 622 New Zealand
2869 2869       Argentina 2020-04-16 23:30:31 -38.4161 -63.6167 2571 115 631 1825 Argentina
2856 2856     Victoria Australia 2020-04-16 23:38:19 -37.8136 144.9631 1299 14 1137 148 Victoria, Australia
2896 2896       Chile 2020-04-16 23:30:31 -35.6751 -71.543 8807 105 3299 5403 Chile
2777 2777     Australian Capital Territory Australia 2020-04-16 23:38:19 -35.4735 149.0124 103 3 82 18 Australian Capital Territory, Australia
2850 2850     South Australia Australia 2020-04-16 23:38:19 -34.9285 138.6007 433 4 279 150 South Australia, Australia
2823 2823     New South Wales Australia 2020-04-16 23:38:19 -33.8688 151.2093 2897 25 4 2868 New South Wales, Australia
3036 3036       Uruguay 2020-04-16 23:30:31 -32.5228 -55.7658 502 9 286 207 Uruguay
2858 2858     Western Australia Australia 2020-04-16 23:38:19 -31.9505 115.8605 532 6 338 188 Western Australia, Australia
3015 3015       South Africa 2020-04-16 23:30:31 -30.5595 22.9375 2605 48 903 1654 South Africa
2836 2836     Queensland Australia 2020-04-16 23:38:19 -27.4698 153.0251 1001 5 442 554 Queensland, Australia
2917 2917       Eswatini 2020-04-16 23:30:31 -26.5225 31.4659 16 1 8 7 Eswatini
2991 2991       Paraguay 2020-04-16 23:30:31 -23.4425 -58.4438 174 8 30 136 Paraguay
2978 2978       Namibia 2020-04-16 23:30:31 -22.9576 18.4904 16 0 4 12 Namibia
2884 2884       Botswana 2020-04-16 23:30:31 -22.3285 24.6849 15 1 0 14 Botswana
2839 2839     Reunion France 2020-04-16 23:30:31 -21.1151 55.5364 394 0 237 157 Reunion, France
2822 2822     New Caledonia France 2020-04-16 23:30:31 -20.904304999999997 165.618042 18 0 1 17 New Caledonia, France
2970 2970       Mauritius 2020-04-16 23:30:31 -20.348404000000002 57.552152 324 9 81 234 Mauritius
3043 3043       Zimbabwe 2020-04-16 23:30:31 -19.015438 29.154857 23 3 1 19 Zimbabwe
2963 2963       Madagascar 2020-04-16 23:30:31 -18.766947000000002 46.869107 111 0 33 78 Madagascar
2977 2977       Mozambique 2020-04-16 23:30:31 -18.665695 35.529562 31 0 2 29 Mozambique
2919 2919       Fiji 2020-04-16 23:30:31 -17.7134 178.065 17 0 0 17 Fiji
2791 2791     French Polynesia France 2020-04-16 23:30:31 -17.6797 -149.4068 55 0 0 55 French Polynesia, France
2882 2882       Bolivia 2020-04-16 23:30:31 -16.2902 -63.5887 441 29 14 398 Bolivia
2885 2885       Brazil 2020-04-16 23:30:31 -14.235 -51.9253 30425 1924 14026 14475 Brazil
3003 3003       Samoa 2020-04-16 23:38:03 -13.759 -172.1046 0 0 0 0 Samoa
2964 2964       Malawi 2020-04-16 23:30:31 -13.254307999999998 34.301525 16 2 0 14 Malawi
3042 3042       Zambia 2020-04-16 23:30:31 -13.133897 27.849332 48 2 30 16 Zambia
2819 2819     Mayotte France 2020-04-16 23:30:31 -12.8275 45.166244 233 3 69 161 Mayotte, France
2827 2827     Northern Territory Australia 2020-04-16 23:38:19 -12.4634 130.8456 28 0 6 22 Northern Territory, Australia
2867 2867       Angola 2020-04-16 23:30:31 -11.2027 17.8739 19 2 5 12 Angola
2992 2992       Peru 2020-04-16 23:30:31 -9.19 -75.0152 12491 274 6120 6097 Peru
3027 3027       Timor-Leste 2020-04-16 23:30:31 -8.874217 125.727539 18 0 1 17 Timor-Leste
2841 2841     Saint Helena, Ascension and Tristan da Cunha United Kingdom 2020-04-16 23:30:31 -7.9467 -14.3559 0 0 0 0 Saint Helena, Ascension and Tristan da Cunha, United Kingdom
3025 3025       Tanzania 2020-04-16 23:30:31 -6.369028 34.888822 94 4 11 79 Tanzania
2990 2990       Papua New Guinea 2020-04-16 23:30:31 -6.314993 143.95555 7 0 0 7 Papua New Guinea
3009 3009       Seychelles 2020-04-16 23:30:31 -4.6796 55.492 11 0 0 11 Seychelles
2899 2899       Congo (Kinshasa) 2020-04-16 23:30:31 -4.322447 15.307045 267 22 23 222 Congo (Kinshasa)
2898 2898       Congo (Brazzaville) 2020-04-16 23:30:31 -4.2634 15.2832 117 5 11 101 Congo (Brazzaville)

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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