04-18-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,055 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
805 805   Federal Correctional Institution (FCI) Michigan US 2020-04-18 22:32:47     45 0 0 45 Federal Correctional Institution (FCI), Michigan, US
1657 1657   Michigan Department of Corrections (MDOC) Michigan US 2020-04-18 22:32:47     550 17 0 533 Michigan Department of Corrections (MDOC), Michigan, US
1897 1897 80013 Out of GA Georgia US 2020-04-18 22:32:47     815 7 0 808 Out of GA, Georgia, US
1898 1898 80015 Out of HI Hawaii US 2020-04-18 22:32:47     6 0 0 6 Out of HI, Hawaii, US
1899 1899 80026 Out of MI Michigan US 2020-04-18 22:32:47     74 2 0 72 Out of MI, Michigan, US
1900 1900 80040 Out of OK Oklahoma US 2020-04-18 22:32:47     0 0 0 0 Out of OK, Oklahoma, US
1901 1901 80047 Out of TN Tennessee US 2020-04-18 22:32:47     259 1 0 258 Out of TN, Tennessee, US
2479 2479 90001 Unassigned Alabama US 2020-04-18 22:32:47     0 0 0 0 Unassigned, Alabama, US
2480 2480 90002 Unassigned Alaska US 2020-04-18 22:32:47     0 4 0 -4 Unassigned, Alaska, US
2481 2481 90004 Unassigned Arizona US 2020-04-18 22:32:47     0 0 0 0 Unassigned, Arizona, US
2482 2482 90005 Unassigned Arkansas US 2020-04-18 22:32:47     42 0 0 42 Unassigned, Arkansas, US
2483 2483 90006 Unassigned California US 2020-04-18 22:32:47     0 0 0 0 Unassigned, California, US
2484 2484 90008 Unassigned Colorado US 2020-04-18 22:32:47     67 1 0 66 Unassigned, Colorado, US
2485 2485 90009 Unassigned Connecticut US 2020-04-18 22:32:47     525 3 0 522 Unassigned, Connecticut, US
2486 2486 90010 Unassigned Delaware US 2020-04-18 22:32:47     30 0 0 30 Unassigned, Delaware, US
2487 2487 90012 Unassigned Florida US 2020-04-18 22:32:47     3 0 0 3 Unassigned, Florida, US
2488 2488 90013 Unassigned Georgia US 2020-04-18 22:32:47     220 0 0 220 Unassigned, Georgia, US
2489 2489 90015 Unassigned Hawaii US 2020-04-18 22:32:47     0 0 0 0 Unassigned, Hawaii, US
2490 2490 90016 Unassigned Idaho US 2020-04-18 22:32:47     0 0 0 0 Unassigned, Idaho, US
2491 2491 90017 Unassigned Illinois US 2020-04-18 22:32:47     84 3 0 81 Unassigned, Illinois, US
2492 2492 90018 Unassigned Indiana US 2020-04-18 22:32:47     0 120 0 0 Unassigned, Indiana, US
2493 2493 90019 Unassigned Iowa US 2020-04-18 22:32:47     1 0 0 1 Unassigned, Iowa, US
2494 2494 90020 Unassigned Kansas US 2020-04-18 22:32:47     0 1 0 0 Unassigned, Kansas, US
2495 2495 90021 Unassigned Kentucky US 2020-04-18 22:32:47     73 6 0 67 Unassigned, Kentucky, US
2496 2496 90022 Unassigned Louisiana US 2020-04-18 22:32:47     57 1 0 56 Unassigned, Louisiana, US
2497 2497 90023 Unassigned Maine US 2020-04-18 22:32:47     1 0 0 1 Unassigned, Maine, US
2498 2498 90025 Unassigned Massachusetts US 2020-04-18 22:32:47     733 19 0 714 Unassigned, Massachusetts, US
2499 2499 90026 Unassigned Michigan US 2020-04-18 22:32:47     48 3 0 45 Unassigned, Michigan, US
2500 2500 90027 Unassigned Minnesota US 2020-04-18 22:32:47     0 0 0 0 Unassigned, Minnesota, US
2501 2501 90028 Unassigned Mississippi US 2020-04-18 22:32:47     0 0 0 0 Unassigned, Mississippi, US
2502 2502 90029 Unassigned Missouri US 2020-04-18 22:32:47     0 0 0 0 Unassigned, Missouri, US
2503 2503 90030 Unassigned Montana US 2020-04-18 22:32:47     0 0 0 0 Unassigned, Montana, US
2504 2504 90031 Unassigned Nebraska US 2020-04-18 22:32:47     60 9 0 51 Unassigned, Nebraska, US
2505 2505 90032 Unassigned Nevada US 2020-04-18 22:32:47     34 0 0 34 Unassigned, Nevada, US
2506 2506 90033 Unassigned New Hampshire US 2020-04-18 22:32:47     0 35 0 -35 Unassigned, New Hampshire, US
2507 2507 90034 Unassigned New Jersey US 2020-04-18 22:32:47     748 2 0 746 Unassigned, New Jersey, US
2508 2508 90035 Unassigned New Mexico US 2020-04-18 22:32:47     0 0 0 0 Unassigned, New Mexico, US
2509 2509 90036 Unassigned New York US 2020-04-18 22:32:47     0 1059 0 -1059 Unassigned, New York, US
2510 2510 90039 Unassigned Ohio US 2020-04-18 22:32:47     0 0 0 0 Unassigned, Ohio, US
2511 2511 90040 Unassigned Oklahoma US 2020-04-18 22:32:47     108 5 0 103 Unassigned, Oklahoma, US
2512 2512 90041 Unassigned Oregon US 2020-04-18 22:32:47     0 0 0 0 Unassigned, Oregon, US
2513 2513 90042 Unassigned Pennsylvania US 2020-04-18 22:32:47     0 0 0 0 Unassigned, Pennsylvania, US
2514 2514 90044 Unassigned Rhode Island US 2020-04-18 22:32:47     1146 43 0 1012 Unassigned, Rhode Island, US
2515 2515 90046 Unassigned South Dakota US 2020-04-18 22:32:47     0 0 0 0 Unassigned, South Dakota, US
2516 2516 90047 Unassigned Tennessee US 2020-04-18 22:32:47     37 0 0 37 Unassigned, Tennessee, US
2517 2517 90049 Unassigned Utah US 2020-04-18 22:32:47     0 0 0 0 Unassigned, Utah, US
2518 2518 90050 Unassigned Vermont US 2020-04-18 22:32:47     10 1 0 9 Unassigned, Vermont, US
2519 2519 90051 Unassigned Virginia US 2020-04-18 22:32:47     0 94 0 -94 Unassigned, Virginia, US
2520 2520 90053 Unassigned Washington US 2020-04-18 22:32:47     444 0 0 444 Unassigned, Washington, US
2521 2521 90054 Unassigned West Virginia US 2020-04-18 22:32:47     0 9 0 -9 Unassigned, West Virginia, US
2522 2522 90055 Unassigned Wisconsin US 2020-04-18 22:32:47     0 0 0 0 Unassigned, Wisconsin, US
2523 2523 90056 Unassigned Wyoming US 2020-04-18 22:32:47     0 1 0 -1 Unassigned, Wyoming, US
2799 2799 88888   Diamond Princess US 2020-04-18 22:32:47     49 0 0 49 Diamond Princess, US
2807 2807     Grand Princess Canada 2020-04-18 22:40:03     13 0 0 13 Grand Princess, Canada
2808 2808 99999   Grand Princess US 2020-04-18 22:32:47     103 0 0 103 Grand Princess, US
2849 2849     Recovered Canada 2020-04-18 22:40:03     0 0 10964 -10964 Recovered, Canada
2850 2850     Recovered US 2020-04-18 22:32:47     0 0 64840 -64840 Recovered, US
2919 2919       Diamond Princess 2020-04-18 22:32:28     712 13 644 55 Diamond Princess
2974 2974       MS Zaandam 2020-04-18 22:32:28     9 2 0 7 MS Zaandam
2800 2800     Falkland Islands (Malvinas) United Kingdom 2020-04-18 22:32:28 -51.7963 -59.5236 11 0 3 8 Falkland Islands (Malvinas), United Kingdom
2864 2864     Tasmania Australia 2020-04-18 22:40:18 -42.8821 147.3272 180 7 67 106 Tasmania, Australia
2993 2993       New Zealand 2020-04-18 22:32:28 -40.9006 174.886 1422 11 867 544 New Zealand
2881 2881       Argentina 2020-04-18 22:32:28 -38.4161 -63.6167 2758 129 685 1944 Argentina
2868 2868     Victoria Australia 2020-04-18 22:40:18 -37.8136 144.9631 1319 14 1172 133 Victoria, Australia
2908 2908       Chile 2020-04-18 22:32:28 -35.6751 -71.543 9730 126 4035 5569 Chile
2789 2789     Australian Capital Territory Australia 2020-04-18 22:40:18 -35.4735 149.0124 103 3 88 12 Australian Capital Territory, Australia
2862 2862     South Australia Australia 2020-04-18 22:40:18 -34.9285 138.6007 435 4 331 100 South Australia, Australia
2835 2835     New South Wales Australia 2020-04-18 22:40:18 -33.8688 151.2093 2926 26 1379 1521 New South Wales, Australia
3048 3048       Uruguay 2020-04-18 22:32:28 -32.5228 -55.7658 508 9 294 205 Uruguay
2870 2870     Western Australia Australia 2020-04-18 22:40:18 -31.9505 115.8605 541 7 340 194 Western Australia, Australia
3027 3027       South Africa 2020-04-18 22:32:28 -30.5595 22.9375 3034 52 903 2079 South Africa
2848 2848     Queensland Australia 2020-04-18 22:40:18 -27.4698 153.0251 1015 6 738 271 Queensland, Australia
2929 2929       Eswatini 2020-04-18 22:32:28 -26.5225 31.4659 22 1 8 13 Eswatini
3003 3003       Paraguay 2020-04-18 22:32:28 -23.4425 -58.4438 202 8 35 159 Paraguay
2990 2990       Namibia 2020-04-18 22:32:28 -22.9576 18.4904 16 0 6 10 Namibia
2896 2896       Botswana 2020-04-18 22:32:28 -22.3285 24.6849 15 1 0 14 Botswana
2851 2851     Reunion France 2020-04-18 22:32:28 -21.1151 55.5364 407 0 237 170 Reunion, France
2834 2834     New Caledonia France 2020-04-18 22:32:28 -20.904305 165.618042 18 0 14 4 New Caledonia, France
2982 2982       Mauritius 2020-04-18 22:32:28 -20.348404 57.552152 325 9 180 136 Mauritius
3055 3055       Zimbabwe 2020-04-18 22:32:28 -19.015438 29.154857 25 3 2 20 Zimbabwe
2975 2975       Madagascar 2020-04-18 22:32:28 -18.766947 46.869107 120 0 35 85 Madagascar
2989 2989       Mozambique 2020-04-18 22:32:28 -18.665695 35.529562 35 0 4 31 Mozambique
2931 2931       Fiji 2020-04-18 22:32:28 -17.7134 178.065 17 0 0 17 Fiji
2803 2803     French Polynesia France 2020-04-18 22:32:28 -17.6797 -149.4068 55 0 2 53 French Polynesia, France
2894 2894       Bolivia 2020-04-18 22:32:28 -16.2902 -63.5887 493 31 31 431 Bolivia
2897 2897       Brazil 2020-04-18 22:32:28 -14.235 -51.9253 36658 2354 14026 20278 Brazil
3015 3015       Samoa 2020-04-18 22:40:03 -13.759 -172.1046 0 0 0 0 Samoa
2976 2976       Malawi 2020-04-18 22:32:28 -13.254308 34.301525 17 2 3 12 Malawi
3054 3054       Zambia 2020-04-18 22:32:28 -13.133897 27.849332 57 2 33 22 Zambia
2831 2831     Mayotte France 2020-04-18 22:32:28 -12.8275 45.166244 254 4 117 133 Mayotte, France
2839 2839     Northern Territory Australia 2020-04-18 22:40:18 -12.4634 130.8456 28 0 9 19 Northern Territory, Australia
2879 2879       Angola 2020-04-18 22:32:28 -11.2027 17.8739 24 2 6 16 Angola
3004 3004       Peru 2020-04-18 22:32:28 -9.19 -75.0152 14420 348 6684 7388 Peru
3039 3039       Timor-Leste 2020-04-18 22:32:28 -8.874217 125.727539 18 0 1 17 Timor-Leste
2853 2853     Saint Helena, Ascension and Tristan da Cunha United Kingdom 2020-04-18 22:32:28 -7.9467 -14.3559 0 0 0 0 Saint Helena, Ascension and Tristan da Cunha, United Kingdom
3037 3037       Tanzania 2020-04-18 22:32:28 -6.369028 34.888822 147 5 11 131 Tanzania
3002 3002       Papua New Guinea 2020-04-18 22:32:28 -6.314993 143.95555 7 0 0 7 Papua New Guinea
3021 3021       Seychelles 2020-04-18 22:32:28 -4.6796 55.492 11 0 5 6 Seychelles
2911 2911       Congo (Kinshasa) 2020-04-18 22:32:28 -4.322447 15.307045 307 25 26 256 Congo (Kinshasa)
2910 2910       Congo (Brazzaville) 2020-04-18 22:32:28 -4.2634 15.2832 143 6 11 126 Congo (Brazzaville)

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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