04-17-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,047 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
803 803   Federal Correctional Institution (FCI) Michigan US 2020-04-17 23:30:52     44 0 0 44 Federal Correctional Institution (FCI), Michigan, US
1651 1651   Michigan Department of Corrections (MDOC) Michigan US 2020-04-17 23:30:52     514 15 0 499 Michigan Department of Corrections (MDOC), Michigan, US
1891 1891 80013 Out of GA Georgia US 2020-04-17 23:30:52     780 7 0 773 Out of GA, Georgia, US
1892 1892 80015 Out of HI Hawaii US 2020-04-17 23:30:52     6 0 0 6 Out of HI, Hawaii, US
1893 1893 80026 Out of MI Michigan US 2020-04-17 23:30:52     71 2 0 69 Out of MI, Michigan, US
1894 1894 80040 Out of OK Oklahoma US 2020-04-17 23:30:52     0 0 0 0 Out of OK, Oklahoma, US
1895 1895 80047 Out of TN Tennessee US 2020-04-17 23:30:52     250 1 0 249 Out of TN, Tennessee, US
2472 2472 90001 Unassigned Alabama US 2020-04-17 23:30:52     0 0 0 0 Unassigned, Alabama, US
2473 2473 90002 Unassigned Alaska US 2020-04-17 23:30:52     0 4 0 -4 Unassigned, Alaska, US
2474 2474 90004 Unassigned Arizona US 2020-04-17 23:30:52     0 42 0 -42 Unassigned, Arizona, US
2475 2475 90005 Unassigned Arkansas US 2020-04-17 23:30:52     43 0 0 43 Unassigned, Arkansas, US
2476 2476 90006 Unassigned California US 2020-04-17 23:30:52     0 0 0 0 Unassigned, California, US
2477 2477 90008 Unassigned Colorado US 2020-04-17 23:30:52     96 1 0 95 Unassigned, Colorado, US
2478 2478 90009 Unassigned Connecticut US 2020-04-17 23:30:52     495 2 0 493 Unassigned, Connecticut, US
2479 2479 90010 Unassigned Delaware US 2020-04-17 23:30:52     22 0 0 22 Unassigned, Delaware, US
2480 2480 90012 Unassigned Florida US 2020-04-17 23:30:52     4 0 0 4 Unassigned, Florida, US
2481 2481 90013 Unassigned Georgia US 2020-04-17 23:30:52     255 0 0 255 Unassigned, Georgia, US
2482 2482 90015 Unassigned Hawaii US 2020-04-17 23:30:52     5 0 0 5 Unassigned, Hawaii, US
2483 2483 90016 Unassigned Idaho US 2020-04-17 23:30:52     0 0 0 0 Unassigned, Idaho, US
2484 2484 90017 Unassigned Illinois US 2020-04-17 23:30:52     74 1 0 73 Unassigned, Illinois, US
2485 2485 90018 Unassigned Indiana US 2020-04-17 23:30:52     0 115 0 0 Unassigned, Indiana, US
2486 2486 90019 Unassigned Iowa US 2020-04-17 23:30:52     1 0 0 1 Unassigned, Iowa, US
2487 2487 90020 Unassigned Kansas US 2020-04-17 23:30:52     0 2 0 0 Unassigned, Kansas, US
2488 2488 90021 Unassigned Kentucky US 2020-04-17 23:30:52     87 1 0 86 Unassigned, Kentucky, US
2489 2489 90022 Unassigned Louisiana US 2020-04-17 23:30:52     56 1 0 55 Unassigned, Louisiana, US
2490 2490 90023 Unassigned Maine US 2020-04-17 23:30:52     1 0 0 1 Unassigned, Maine, US
2491 2491 90025 Unassigned Massachusetts US 2020-04-17 23:30:52     760 16 0 744 Unassigned, Massachusetts, US
2492 2492 90026 Unassigned Michigan US 2020-04-17 23:30:52     46 4 0 42 Unassigned, Michigan, US
2493 2493 90027 Unassigned Minnesota US 2020-04-17 23:30:52     0 0 0 0 Unassigned, Minnesota, US
2494 2494 90028 Unassigned Mississippi US 2020-04-17 23:30:52     0 0 0 0 Unassigned, Mississippi, US
2495 2495 90029 Unassigned Missouri US 2020-04-17 23:30:52     0 0 0 0 Unassigned, Missouri, US
2496 2496 90030 Unassigned Montana US 2020-04-17 23:30:52     0 0 0 0 Unassigned, Montana, US
2497 2497 90031 Unassigned Nebraska US 2020-04-17 23:30:52     92 9 0 83 Unassigned, Nebraska, US
2498 2498 90032 Unassigned Nevada US 2020-04-17 23:30:52     98 1 0 97 Unassigned, Nevada, US
2499 2499 90033 Unassigned New Hampshire US 2020-04-17 23:30:52     2 34 0 -32 Unassigned, New Hampshire, US
2500 2500 90034 Unassigned New Jersey US 2020-04-17 23:30:52     719 3 0 716 Unassigned, New Jersey, US
2501 2501 90035 Unassigned New Mexico US 2020-04-17 23:30:52     0 0 0 0 Unassigned, New Mexico, US
2502 2502 90036 Unassigned New York US 2020-04-17 23:30:52     0 574 0 -574 Unassigned, New York, US
2503 2503 90039 Unassigned Ohio US 2020-04-17 23:30:52     0 0 0 0 Unassigned, Ohio, US
2504 2504 90040 Unassigned Oklahoma US 2020-04-17 23:30:52     108 5 0 103 Unassigned, Oklahoma, US
2505 2505 90041 Unassigned Oregon US 2020-04-17 23:30:52     0 0 0 0 Unassigned, Oregon, US
2506 2506 90042 Unassigned Pennsylvania US 2020-04-17 23:30:52     0 0 0 0 Unassigned, Pennsylvania, US
2507 2507 90044 Unassigned Rhode Island US 2020-04-17 23:30:52     790 97 0 675 Unassigned, Rhode Island, US
2508 2508 90046 Unassigned South Dakota US 2020-04-17 23:30:52     0 0 0 0 Unassigned, South Dakota, US
2509 2509 90047 Unassigned Tennessee US 2020-04-17 23:30:52     209 0 0 209 Unassigned, Tennessee, US
2510 2510 90049 Unassigned Utah US 2020-04-17 23:30:52     0 0 0 0 Unassigned, Utah, US
2511 2511 90050 Unassigned Vermont US 2020-04-17 23:30:52     10 0 0 10 Unassigned, Vermont, US
2512 2512 90051 Unassigned Virginia US 2020-04-17 23:30:52     0 67 0 -67 Unassigned, Virginia, US
2513 2513 90053 Unassigned Washington US 2020-04-17 23:30:52     334 0 0 334 Unassigned, Washington, US
2514 2514 90054 Unassigned West Virginia US 2020-04-17 23:30:52     0 9 0 -9 Unassigned, West Virginia, US
2515 2515 90055 Unassigned Wisconsin US 2020-04-17 23:30:52     0 0 0 0 Unassigned, Wisconsin, US
2516 2516 90056 Unassigned Wyoming US 2020-04-17 23:30:52     0 1 0 -1 Unassigned, Wyoming, US
2791 2791 88888   Diamond Princess US 2020-04-17 23:30:52     49 0 0 49 Diamond Princess, US
2799 2799     Grand Princess Canada 2020-04-17 23:38:31     13 0 0 13 Grand Princess, Canada
2800 2800 99999   Grand Princess US 2020-04-17 23:30:52     103 0 0 103 Grand Princess, US
2841 2841     Recovered Canada 2020-04-17 23:38:31     0 0 10545 -10545 Recovered, Canada
2842 2842     Recovered US 2020-04-17 23:30:52     0 0 58545 -58545 Recovered, US
2911 2911       Diamond Princess 2020-04-17 23:30:32     712 13 644 55 Diamond Princess
2966 2966       MS Zaandam 2020-04-17 23:30:32     9 2 0 7 MS Zaandam
2792 2792     Falkland Islands (Malvinas) United Kingdom 2020-04-17 23:30:32 -51.7963 -59.5236 11 0 1 10 Falkland Islands (Malvinas), United Kingdom
2856 2856     Tasmania Australia 2020-04-17 23:38:48 -42.8821 147.3272 180 7 67 106 Tasmania, Australia
2985 2985       New Zealand 2020-04-17 23:30:32 -40.9006 174.886 1409 11 816 582 New Zealand
2873 2873       Argentina 2020-04-17 23:30:32 -38.4161 -63.6167 2669 123 666 1880 Argentina
2860 2860     Victoria Australia 2020-04-17 23:38:48 -37.8136 144.9631 1302 14 1159 129 Victoria, Australia
2900 2900       Chile 2020-04-17 23:30:32 -35.6751 -71.543 9252 116 3621 5515 Chile
2781 2781     Australian Capital Territory Australia 2020-04-17 23:38:48 -35.4735 149.0124 103 3 81 19 Australian Capital Territory, Australia
2854 2854     South Australia Australia 2020-04-17 23:38:48 -34.9285 138.6007 435 4 331 100 South Australia, Australia
2827 2827     New South Wales Australia 2020-04-17 23:38:48 -33.8688 151.2093 2926 26 1379 1521 New South Wales, Australia
3040 3040       Uruguay 2020-04-17 23:30:32 -32.5228 -55.7658 502 9 286 207 Uruguay
2862 2862     Western Australia Australia 2020-04-17 23:38:48 -31.9505 115.8605 541 7 340 194 Western Australia, Australia
3019 3019       South Africa 2020-04-17 23:30:32 -30.5595 22.9375 2783 50 903 1830 South Africa
2840 2840     Queensland Australia 2020-04-17 23:38:48 -27.4698 153.0251 1007 5 442 560 Queensland, Australia
2921 2921       Eswatini 2020-04-17 23:30:32 -26.5225 31.4659 16 1 8 7 Eswatini
2995 2995       Paraguay 2020-04-17 23:30:32 -23.4425 -58.4438 199 8 30 161 Paraguay
2982 2982       Namibia 2020-04-17 23:30:32 -22.9576 18.4904 16 0 4 12 Namibia
2888 2888       Botswana 2020-04-17 23:30:32 -22.3285 24.6849 15 1 0 14 Botswana
2843 2843     Reunion France 2020-04-17 23:30:32 -21.1151 55.5364 402 0 237 165 Reunion, France
2826 2826     New Caledonia France 2020-04-17 23:30:32 -20.904304999999997 165.618042 18 0 14 4 New Caledonia, France
2974 2974       Mauritius 2020-04-17 23:30:32 -20.348404000000002 57.552152 324 9 108 207 Mauritius
3047 3047       Zimbabwe 2020-04-17 23:30:32 -19.015438 29.154857 24 3 2 19 Zimbabwe
2967 2967       Madagascar 2020-04-17 23:30:32 -18.766947000000002 46.869107 117 0 33 84 Madagascar
2981 2981       Mozambique 2020-04-17 23:30:32 -18.665695 35.529562 34 0 2 32 Mozambique
2923 2923       Fiji 2020-04-17 23:30:32 -17.7134 178.065 17 0 0 17 Fiji
2795 2795     French Polynesia France 2020-04-17 23:30:32 -17.6797 -149.4068 55 0 0 55 French Polynesia, France
2886 2886       Bolivia 2020-04-17 23:30:32 -16.2902 -63.5887 465 31 26 408 Bolivia
2889 2889       Brazil 2020-04-17 23:30:32 -14.235 -51.9253 33682 2141 14026 17515 Brazil
3007 3007       Samoa 2020-04-17 23:38:31 -13.759 -172.1046 0 0 0 0 Samoa
2968 2968       Malawi 2020-04-17 23:30:32 -13.254307999999998 34.301525 17 2 3 12 Malawi
3046 3046       Zambia 2020-04-17 23:30:32 -13.133897 27.849332 52 2 30 20 Zambia
2823 2823     Mayotte France 2020-04-17 23:30:32 -12.8275 45.166244 245 4 117 124 Mayotte, France
2831 2831     Northern Territory Australia 2020-04-17 23:38:48 -12.4634 130.8456 28 0 9 19 Northern Territory, Australia
2871 2871       Angola 2020-04-17 23:30:32 -11.2027 17.8739 19 2 5 12 Angola
2996 2996       Peru 2020-04-17 23:30:32 -9.19 -75.0152 13489 300 6541 6648 Peru
3031 3031       Timor-Leste 2020-04-17 23:30:32 -8.874217 125.727539 18 0 1 17 Timor-Leste
2845 2845     Saint Helena, Ascension and Tristan da Cunha United Kingdom 2020-04-17 23:30:32 -7.9467 -14.3559 0 0 0 0 Saint Helena, Ascension and Tristan da Cunha, United Kingdom
3029 3029       Tanzania 2020-04-17 23:30:32 -6.369028 34.888822 147 5 11 131 Tanzania
2994 2994       Papua New Guinea 2020-04-17 23:30:32 -6.314993 143.95555 7 0 0 7 Papua New Guinea
3013 3013       Seychelles 2020-04-17 23:30:32 -4.6796 55.492 11 0 5 6 Seychelles
2903 2903       Congo (Kinshasa) 2020-04-17 23:30:32 -4.322447 15.307045 287 23 25 239 Congo (Kinshasa)
2902 2902       Congo (Brazzaville) 2020-04-17 23:30:32 -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-17-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
);