04-14-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,015 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
797 797   Federal Correctional Institution (FCI) Michigan US 2020-04-14 23:33:31     23 0 0 23 Federal Correctional Institution (FCI), Michigan, US
1592 1592   McIntosh Georgia US 2020-04-14 23:33:31     3 0 0 3 McIntosh, Georgia, US
1638 1638   Michigan Department of Corrections (MDOC) Michigan US 2020-04-14 23:33:31     429 9 0 420 Michigan Department of Corrections (MDOC), Michigan, US
1871 1871 80013 Out of GA Georgia US 2020-04-14 23:33:31     665 0 0 665 Out of GA, Georgia, US
1872 1872   Out of MI Michigan US 2020-04-14 23:33:31     157 2 0 155 Out of MI, Michigan, US
1873 1873 80040 Out of OK Oklahoma US 2020-04-14 23:33:31     0 0 0 0 Out of OK, Oklahoma, US
1874 1874   Out of TN Tennessee US 2020-04-14 23:33:31     260 1 0 259 Out of TN, Tennessee, US
2445 2445 90002 Unassigned Alaska US 2020-04-14 23:33:31     0 4 0 -4 Unassigned, Alaska, US
2446 2446 90004 Unassigned Arizona US 2020-04-14 23:33:31     0 24 0 -24 Unassigned, Arizona, US
2447 2447 90005 Unassigned Arkansas US 2020-04-14 23:33:31     45 0 0 45 Unassigned, Arkansas, US
2448 2448 90006 Unassigned California US 2020-04-14 23:33:31     0 0 0 0 Unassigned, California, US
2449 2449 90008 Unassigned Colorado US 2020-04-14 23:33:31     119 0 0 119 Unassigned, Colorado, US
2450 2450 90009 Unassigned Connecticut US 2020-04-14 23:33:31     533 4 0 529 Unassigned, Connecticut, US
2451 2451 90010 Unassigned Delaware US 2020-04-14 23:33:31     11 8 0 11 Unassigned, Delaware, US
2452 2452 90012 Unassigned Florida US 2020-04-14 23:33:31     3 47 0 -44 Unassigned, Florida, US
2453 2453 90013 Unassigned Georgia US 2020-04-14 23:33:31     287 7 0 280 Unassigned, Georgia, US
2454 2454 90015 Unassigned Hawaii US 2020-04-14 23:33:31     3 0 0 3 Unassigned, Hawaii, US
2455 2455 90016 Unassigned Idaho US 2020-04-14 23:33:31     0 0 0 0 Unassigned, Idaho, US
2456 2456 90017 Unassigned Illinois US 2020-04-14 23:33:31     54 1 0 53 Unassigned, Illinois, US
2457 2457 90018 Unassigned Indiana US 2020-04-14 23:33:31     0 142 0 0 Unassigned, Indiana, US
2458 2458 90019 Unassigned Iowa US 2020-04-14 23:33:31     0 6 0 -6 Unassigned, Iowa, US
2459 2459 90020 Unassigned Kansas US 2020-04-14 23:33:31     0 10 0 -2 Unassigned, Kansas, US
2460 2460 90021 Unassigned Kentucky US 2020-04-14 23:33:31     23 0 0 23 Unassigned, Kentucky, US
2461 2461 90022 Unassigned Louisiana US 2020-04-14 23:33:31     56 0 0 56 Unassigned, Louisiana, US
2462 2462 90023 Unassigned Maine US 2020-04-14 23:33:31     2 0 0 2 Unassigned, Maine, US
2463 2463 90025 Unassigned Massachusetts US 2020-04-14 23:33:31     506 100 0 406 Unassigned, Massachusetts, US
2464 2464 90026 Unassigned Michigan US 2020-04-14 23:33:31     91 4 0 87 Unassigned, Michigan, US
2465 2465 90027 Unassigned Minnesota US 2020-04-14 23:33:31     35 0 0 35 Unassigned, Minnesota, US
2466 2466 90028 Unassigned Mississippi US 2020-04-14 23:33:31     0 0 0 0 Unassigned, Mississippi, US
2467 2467 90029 Unassigned Missouri US 2020-04-14 23:33:31     1 0 0 1 Unassigned, Missouri, US
2468 2468 90030 Unassigned Montana US 2020-04-14 23:33:31     0 0 0 0 Unassigned, Montana, US
2469 2469 90031 Unassigned Nebraska US 2020-04-14 23:33:31     18 5 0 13 Unassigned, Nebraska, US
2470 2470 90032 Unassigned Nevada US 2020-04-14 23:33:31     0 6 0 -6 Unassigned, Nevada, US
2471 2471 90033 Unassigned New Hampshire US 2020-04-14 23:33:31     1 24 0 -23 Unassigned, New Hampshire, US
2472 2472 90034 Unassigned New Jersey US 2020-04-14 23:33:31     1702 2 0 1700 Unassigned, New Jersey, US
2473 2473 90035 Unassigned New Mexico US 2020-04-14 23:33:31     0 0 0 0 Unassigned, New Mexico, US
2474 2474 90036 Unassigned New York US 2020-04-14 23:33:31     0 0 0 0 Unassigned, New York, US
2475 2475 90039 Unassigned Ohio US 2020-04-14 23:33:31     0 0 0 0 Unassigned, Ohio, US
2476 2476 90040 Unassigned Oklahoma US 2020-04-14 23:33:31     0 0 0 0 Unassigned, Oklahoma, US
2477 2477 90041 Unassigned Oregon US 2020-04-14 23:33:31     0 0 0 0 Unassigned, Oregon, US
2478 2478 90042 Unassigned Pennsylvania US 2020-04-14 23:33:31     0 0 0 0 Unassigned, Pennsylvania, US
2479 2479 90044 Unassigned Rhode Island US 2020-04-14 23:33:31     1551 45 0 1474 Unassigned, Rhode Island, US
2480 2480 90046 Unassigned South Dakota US 2020-04-14 23:33:31     0 0 0 0 Unassigned, South Dakota, US
2481 2481 90047 Unassigned Tennessee US 2020-04-14 23:33:31     136 0 0 136 Unassigned, Tennessee, US
2482 2482 90049 Unassigned Utah US 2020-04-14 23:33:31     0 5 0 -5 Unassigned, Utah, US
2483 2483 90050 Unassigned Vermont US 2020-04-14 23:33:31     39 0 0 39 Unassigned, Vermont, US
2484 2484 90051 Unassigned Virginia US 2020-04-14 23:33:31     0 75 0 -75 Unassigned, Virginia, US
2485 2485 90053 Unassigned Washington US 2020-04-14 23:33:31     484 0 0 484 Unassigned, Washington, US
2486 2486 90054 Unassigned West Virginia US 2020-04-14 23:33:31     0 3 0 -3 Unassigned, West Virginia, US
2487 2487 90055 Unassigned Wisconsin US 2020-04-14 23:33:31     1 0 0 1 Unassigned, Wisconsin, US
2488 2488   Unassigned Wyoming US 2020-04-14 23:33:31     0 0 0 0 Unassigned, Wyoming, US
2759 2759 88888   Diamond Princess US 2020-04-14 23:33:31     49 0 0 49 Diamond Princess, US
2767 2767     Grand Princess Canada 2020-04-14 23:40:54     13 0 0 13 Grand Princess, Canada
2768 2768 99999   Grand Princess US 2020-04-14 23:33:31     103 0 0 103 Grand Princess, US
2809 2809     Recovered Canada 2020-04-14 23:40:54     0 0 8210 -8210 Recovered, Canada
2810 2810     Recovered US 2020-04-14 23:33:31     0 0 47763 -47763 Recovered, US
2879 2879       Diamond Princess 2020-04-14 23:33:12     712 12 639 61 Diamond Princess
2934 2934       MS Zaandam 2020-04-14 23:33:12     9 2 0 7 MS Zaandam
2760 2760     Falkland Islands (Malvinas) United Kingdom 2020-04-14 23:33:12 -51.7963 -59.5236 11 0 1 10 Falkland Islands (Malvinas), United Kingdom
2824 2824     Tasmania Australia 2020-04-14 23:41:11 -42.8821 147.3272 165 6 53 106 Tasmania, Australia
2953 2953       New Zealand 2020-04-14 23:33:12 -40.9006 174.886 1366 9 628 729 New Zealand
2841 2841       Argentina 2020-04-14 23:33:12 -38.4161 -63.6167 2277 102 559 1616 Argentina
2828 2828     Victoria Australia 2020-04-14 23:41:11 -37.8136 144.9631 1291 14 1118 159 Victoria, Australia
2868 2868       Chile 2020-04-14 23:33:12 -35.6751 -71.543 7917 92 2646 5179 Chile
2749 2749     Australian Capital Territory Australia 2020-04-14 23:41:11 -35.4735 149.0124 103 2 72 29 Australian Capital Territory, Australia
2822 2822     South Australia Australia 2020-04-14 23:41:11 -34.9285 138.6007 433 4 240 189 South Australia, Australia
2795 2795     New South Wales Australia 2020-04-14 23:41:11 -33.8688 151.2093 2870 25 4 2841 New South Wales, Australia
3008 3008       Uruguay 2020-04-14 23:33:12 -32.5228 -55.7658 483 8 248 227 Uruguay
2830 2830     Western Australia Australia 2020-04-14 23:41:11 -31.9505 115.8605 527 6 251 270 Western Australia, Australia
2987 2987       South Africa 2020-04-14 23:33:12 -30.5595 22.9375 2415 27 410 1978 South Africa
2808 2808     Queensland Australia 2020-04-14 23:41:11 -27.4698 153.0251 998 5 442 551 Queensland, Australia
2889 2889       Eswatini 2020-04-14 23:33:12 -26.5225 31.4659 15 0 8 7 Eswatini
2963 2963       Paraguay 2020-04-14 23:33:12 -23.4425 -58.4438 159 7 22 130 Paraguay
2950 2950       Namibia 2020-04-14 23:33:12 -22.9576 18.4904 16 0 3 13 Namibia
2856 2856       Botswana 2020-04-14 23:33:12 -22.3285 24.6849 13 1 0 12 Botswana
2811 2811     Reunion France 2020-04-14 23:33:12 -21.1151 55.5364 391 0 40 351 Reunion, France
2794 2794     New Caledonia France 2020-04-14 23:33:12 -20.904304999999997 165.618042 18 0 1 17 New Caledonia, France
2942 2942       Mauritius 2020-04-14 23:33:12 -20.348404000000002 57.552152 324 9 51 264 Mauritius
3015 3015       Zimbabwe 2020-04-14 23:33:12 -19.015438 29.154857 17 3 0 14 Zimbabwe
2935 2935       Madagascar 2020-04-14 23:33:12 -18.766947000000002 46.869107 108 0 23 85 Madagascar
2949 2949       Mozambique 2020-04-14 23:33:12 -18.665695 35.529562 28 0 2 26 Mozambique
2891 2891       Fiji 2020-04-14 23:33:12 -17.7134 178.065 16 0 0 16 Fiji
2763 2763     French Polynesia France 2020-04-14 23:33:12 -17.6797 -149.4068 55 0 0 55 French Polynesia, France
2854 2854       Bolivia 2020-04-14 23:33:12 -16.2902 -63.5887 354 28 6 320 Bolivia
2857 2857       Brazil 2020-04-14 23:33:12 -14.235 -51.9253 25262 1532 3046 20684 Brazil
2975 2975       Samoa 2020-04-14 23:40:54 -13.759 -172.1046 0 0 0 0 Samoa
2936 2936       Malawi 2020-04-14 23:33:12 -13.254307999999998 34.301525 16 2 0 14 Malawi
3014 3014       Zambia 2020-04-14 23:33:12 -13.133897 27.849332 45 2 30 13 Zambia
2791 2791     Mayotte France 2020-04-14 23:33:12 -12.8275 45.166244 217 3 69 145 Mayotte, France
2799 2799     Northern Territory Australia 2020-04-14 23:41:11 -12.4634 130.8456 28 0 6 22 Northern Territory, Australia
2839 2839       Angola 2020-04-14 23:33:12 -11.2027 17.8739 19 2 5 12 Angola
2964 2964       Peru 2020-04-14 23:33:12 -9.19 -75.0152 10303 230 2869 7204 Peru
2999 2999       Timor-Leste 2020-04-14 23:33:12 -8.874217 125.727539 6 0 1 5 Timor-Leste
2813 2813     Saint Helena, Ascension and Tristan da Cunha United Kingdom 2020-04-14 23:33:12 -7.9467 -14.3559 0 0 0 0 Saint Helena, Ascension and Tristan da Cunha, United Kingdom
2997 2997       Tanzania 2020-04-14 23:33:12 -6.369028 34.888822 53 3 7 43 Tanzania
2962 2962       Papua New Guinea 2020-04-14 23:33:12 -6.314993 143.95555 2 0 0 2 Papua New Guinea
2981 2981       Seychelles 2020-04-14 23:33:12 -4.6796 55.492 11 0 0 11 Seychelles
2871 2871       Congo (Kinshasa) 2020-04-14 23:33:12 -4.322447 15.307045 241 20 20 201 Congo (Kinshasa)
2870 2870       Congo (Brazzaville) 2020-04-14 23:33:12 -4.2634 15.2832 60 5 5 50 Congo (Brazzaville)
2862 2862       Burundi 2020-04-14 23:33:12 -3.3731 29.9189 5 1 0 4 Burundi

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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