04-09-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

2,912 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
1539 1539   McIntosh Georgia US 2020-04-09 23:02:37     3 0 0 0 McIntosh,Georgia,US
1805 1805 80008 Out of CO Colorado US 2020-04-09 23:02:37     0 1 0 0 Out of CO,Colorado,US
1806 1806 80015 Out of HI Hawaii US 2020-04-09 23:02:37     2 0 0 0 Out of HI,Hawaii,US
1807 1807   Out of MI Michigan US 2020-04-09 23:02:37     131 1 0 0 Out of MI,Michigan,US
1808 1808 80040 Out of OK Oklahoma US 2020-04-09 23:02:37     2 0 0 0 Out of OK,Oklahoma,US
1809 1809   Out of TN Tennessee US 2020-04-09 23:02:37     275 1 0 0 Out of TN,Tennessee,US
2349 2349 90002 Unassigned Alaska US 2020-04-09 23:02:37     0 2 0 0 Unassigned, Alaska, US
2350 2350 90004 Unassigned Arizona US 2020-04-09 23:02:37     0 18 0 0 Unassigned, Arizona, US
2351 2351 90005 Unassigned Arkansas US 2020-04-09 23:02:37     13 0 0 0 Unassigned, Arkansas, US
2352 2352 90006 Unassigned California US 2020-04-09 23:02:37     4 2 0 0 Unassigned, California, US
2353 2353 90008 Unassigned Colorado US 2020-04-09 23:02:37     238 1 0 0 Unassigned, Colorado, US
2354 2354 90009 Unassigned Connecticut US 2020-04-09 23:02:37     392 2 0 0 Unassigned, Connecticut, US
2355 2355 90010 Unassigned Delaware US 2020-04-09 23:02:37     0 3 0 0 Unassigned, Delaware, US
2356 2356 90012 Unassigned Florida US 2020-04-09 23:02:37     2 0 0 0 Unassigned, Florida, US
2357 2357 90013 Unassigned Georgia US 2020-04-09 23:02:37     1020 8 0 0 Unassigned,Georgia,US
2358 2358 90015 Unassigned Hawaii US 2020-04-09 23:02:37     3 1 0 0 Unassigned, Hawaii, US
2359 2359 90016 Unassigned Idaho US 2020-04-09 23:02:37     0 0 0 0 Unassigned, Idaho, US
2360 2360 90017 Unassigned Illinois US 2020-04-09 23:02:37     73 1 0 0 Unassigned, Illinois, US
2361 2361 90018 Unassigned Indiana US 2020-04-09 23:02:37     0 129 0 0 Unassigned, Indiana, US
2362 2362 90019 Unassigned Iowa US 2020-04-09 23:02:37     0 3 0 0 Unassigned, Iowa, US
2363 2363 90020 Unassigned Kansas US 2020-04-09 23:02:37     0 0 0 0 Unassigned, Kansas, US
2364 2364 90021 Unassigned Kentucky US 2020-04-09 23:02:37     76 5 0 0 Unassigned, Kentucky, US
2365 2365   Unassigned Louisiana US 2020-04-09 23:02:37     51 2 0 0 Unassigned,Louisiana,US
2366 2366 90023 Unassigned Maine US 2020-04-09 23:02:37     4 0 0 0 Unassigned, Maine, US
2367 2367 90024 Unassigned Maryland US 2020-04-09 23:02:37     0 0 0 0 Unassigned, Maryland, US
2368 2368 90025 Unassigned Massachusetts US 2020-04-09 23:02:37     203 83 0 0 Unassigned, Massachusetts, US
2369 2369 90026 Unassigned Michigan US 2020-04-09 23:02:37     368 5 0 0 Unassigned,Michigan,US
2370 2370 90027 Unassigned Minnesota US 2020-04-09 23:02:37     2 0 0 0 Unassigned, Minnesota, US
2371 2371 90028 Unassigned Mississippi US 2020-04-09 23:02:37     0 0 0 0 Unassigned, Mississippi, US
2372 2372 90029 Unassigned Missouri US 2020-04-09 23:02:37     0 1 0 0 Unassigned, Missouri, US
2373 2373 90030 Unassigned Montana US 2020-04-09 23:02:37     0 0 0 0 Unassigned, Montana, US
2374 2374 90031 Unassigned Nebraska US 2020-04-09 23:02:37     0 2 0 0 Unassigned, Nebraska, US
2375 2375 90032 Unassigned Nevada US 2020-04-09 23:02:37     57 1 0 0 Unassigned, Nevada, US
2376 2376 90033 Unassigned New Hampshire US 2020-04-09 23:02:37     32 18 0 0 Unassigned, New Hampshire, US
2377 2377 90034 Unassigned New Jersey US 2020-04-09 23:02:37     996 4 0 0 Unassigned, New Jersey, US
2378 2378 90035 Unassigned New Mexico US 2020-04-09 23:02:37     0 0 0 0 Unassigned, New Mexico, US
2379 2379 90036 Unassigned New York US 2020-04-09 23:02:37     0 73 0 0 Unassigned, New York, US
2380 2380 90038 Unassigned North Dakota US 2020-04-09 23:02:37     0 0 0 0 Unassigned, North Dakota, US
2381 2381 90039 Unassigned Ohio US 2020-04-09 23:02:37     0 0 0 0 Unassigned, Ohio, US
2382 2382 90040 Unassigned Oklahoma US 2020-04-09 23:02:37     0 0 0 0 Unassigned, Oklahoma, US
2383 2383 90041 Unassigned Oregon US 2020-04-09 23:02:37     0 1 0 0 Unassigned, Oregon, US
2384 2384 90042 Unassigned Pennsylvania US 2020-04-09 23:02:37     0 0 0 0 Unassigned, Pennsylvania, US
2385 2385 90044 Unassigned Rhode Island US 2020-04-09 23:02:37     551 38 0 0 Unassigned, Rhode Island, US
2386 2386 90046 Unassigned South Dakota US 2020-04-09 23:02:37     0 0 0 0 Unassigned, South Dakota, US
2387 2387 90047 Unassigned Tennessee US 2020-04-09 23:02:37     38 0 0 0 Unassigned, Tennessee, US
2388 2388 90049 Unassigned Utah US 2020-04-09 23:02:37     0 0 0 0 Unassigned,Utah,US
2389 2389 90050 Unassigned Vermont US 2020-04-09 23:02:37     8 0 0 0 Unassigned, Vermont, US
2390 2390 90051 Unassigned Virginia US 2020-04-09 23:02:37     0 78 0 0 Unassigned, Virginia, US
2391 2391 90053 Unassigned Washington US 2020-04-09 23:02:37     838 0 0 0 Unassigned, Washington, US
2392 2392 90054 Unassigned West Virginia US 2020-04-09 23:02:37     0 1 0 0 Unassigned, West Virginia, US
2393 2393 90055 Unassigned Wisconsin US 2020-04-09 23:02:37     0 0 0 0 Unassigned, Wisconsin, US
2394 2394   Unassigned Wyoming US 2020-04-09 23:02:37     0 0 0 0 Unassigned,Wyoming,US
2656 2656     Diamond Princess Canada 2020-04-09 23:09:01     0 1 0 0 Diamond Princess, Canada
2657 2657 88888   Diamond Princess US 2020-04-09 23:02:37     49 0 0 0 Diamond Princess, US
2665 2665     Grand Princess Canada 2020-04-09 23:09:01     13 0 0 0 Grand Princess, Canada
2666 2666 99999   Grand Princess US 2020-04-09 23:02:37     103 3 0 0 Grand Princess, US
2707 2707     Recovered Canada 2020-04-09 23:09:01     0 0 5162 0 Recovered, Canada
2708 2708     Recovered US 2020-04-09 23:02:37     0 0 25410 0 Recovered, US
2777 2777       Diamond Princess 2020-04-09 23:02:19     712 11 619 82 Diamond Princess
2832 2832       MS Zaandam 2020-04-09 23:02:19     9 2 0 7 ,,MS Zaandam
2658 2658     Falkland Islands (Malvinas) United Kingdom 2020-04-09 23:02:19 -51.7963 -59.5236 5 0 1 4 Falkland Islands (Malvinas), United Kingdom
2722 2722     Tasmania Australia 2020-04-09 23:09:19 -42.8821 147.3272 111 3 48 60 Tasmania, Australia
2851 2851       New Zealand 2020-04-09 23:02:19 -40.9006 174.886 1239 1 317 921 New Zealand
2739 2739       Argentina 2020-04-09 23:02:19 -38.4161 -63.6167 1795 72 365 1358 Argentina
2726 2726     Victoria Australia 2020-04-09 23:09:19 -37.8136 144.9631 1228 12 736 480 Victoria, Australia
2766 2766       Chile 2020-04-09 23:02:19 -35.6751 -71.543 5972 57 1274 4641 Chile
2646 2646     Australian Capital Territory Australia 2020-04-09 23:09:19 -35.4735 149.0124 100 2 47 51 Australian Capital Territory, Australia
2720 2720     South Australia Australia 2020-04-09 23:09:19 -34.9285 138.6007 420 3 120 297 South Australia, Australia
2693 2693     New South Wales Australia 2020-04-09 23:09:19 -33.8688 151.2093 2773 21 4 2748 New South Wales, Australia
2906 2906       Uruguay 2020-04-09 23:02:19 -32.5228 -55.7658 456 7 192 257 Uruguay
2728 2728     Western Australia Australia 2020-04-09 23:09:19 -31.9505 115.8605 495 6 170 319 Western Australia, Australia
2885 2885       South Africa 2020-04-09 23:02:19 -30.5595 22.9375 1934 18 95 1821 South Africa
2706 2706     Queensland Australia 2020-04-09 23:09:19 -27.4698 153.0251 953 4 345 604 Queensland, Australia
2787 2787       Eswatini 2020-04-09 23:02:19 -26.5225 31.4659 12 0 7 5 Eswatini
2861 2861       Paraguay 2020-04-09 23:02:19 -23.4425 -58.4438 124 5 18 101 Paraguay
2848 2848       Namibia 2020-04-09 23:02:19 -22.9576 18.4904 16 0 3 13 Namibia
2754 2754       Botswana 2020-04-09 23:02:19 -22.3285 24.6849 13 1 0 12 Botswana
2709 2709     Reunion France 2020-04-09 23:02:19 -21.1151 55.5364 362 0 40 322 Reunion, France
2692 2692     New Caledonia France 2020-04-09 23:02:19 -20.904304999999997 165.618042 18 0 1 17 New Caledonia, France
2840 2840       Mauritius 2020-04-09 23:02:19 -20.348404000000002 57.552152 314 7 23 284 Mauritius
2912 2912       Zimbabwe 2020-04-09 23:02:19 -19.015438 29.154857 11 3 0 8 Zimbabwe
2833 2833       Madagascar 2020-04-09 23:02:19 -18.766947000000002 46.869107 93 0 11 82 Madagascar
2847 2847       Mozambique 2020-04-09 23:02:19 -18.665695 35.529562 17 0 1 16 Mozambique
2789 2789       Fiji 2020-04-09 23:02:19 -17.7134 178.065 15 0 0 15 Fiji
2661 2661     French Polynesia France 2020-04-09 23:02:19 -17.6797 -149.4068 51 0 0 51 French Polynesia, France
2752 2752       Bolivia 2020-04-09 23:02:19 -16.2902 -63.5887 264 18 2 244 Bolivia
2755 2755       Brazil 2020-04-09 23:02:19 -14.235 -51.9253 18092 950 173 16969 Brazil
2873 2873       Samoa 2020-04-09 23:09:01 -13.759 -172.1046 0 0 0 0 Samoa
2834 2834       Malawi 2020-04-09 23:02:19 -13.254307999999998 34.301525 8 1 0 7 Malawi
2911 2911       Zambia 2020-04-09 23:02:19 -13.133897 27.849332 39 1 24 14 Zambia
2689 2689     Mayotte France 2020-04-09 23:02:19 -12.8275 45.166244 184 2 22 160 Mayotte, France
2697 2697     Northern Territory Australia 2020-04-09 23:09:19 -12.4634 130.8456 28 0 2 26 Northern Territory, Australia
2737 2737       Angola 2020-04-09 23:02:19 -11.2027 17.8739 19 2 2 15 Angola
2862 2862       Peru 2020-04-09 23:02:19 -9.19 -75.0152 5256 138 1438 3680 Peru
2897 2897       Timor-Leste 2020-04-09 23:02:19 -8.874217 125.727539 1 0 0 1 Timor-Leste
2711 2711     Saint Helena, Ascension and Tristan da Cunha United Kingdom 2020-04-09 23:02:19 -7.9467 -14.3559 0 0 0 0 Saint Helena, Ascension and Tristan da Cunha, United Kingdom
2895 2895       Tanzania 2020-04-09 23:02:19 -6.369028 34.888822 25 1 5 19 Tanzania
2860 2860       Papua New Guinea 2020-04-09 23:02:19 -6.314993 143.95555 2 0 0 2 Papua New Guinea
2879 2879       Seychelles 2020-04-09 23:02:19 -4.6796 55.492 11 0 0 11 Seychelles
2769 2769       Congo (Kinshasa) 2020-04-09 23:02:19 -4.322447 15.307045 180 18 9 153 Congo (Kinshasa)

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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