04-03-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,627 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
1370 1370   McIntosh Georgia US 2020-04-03 22:46:37     2 0 0 0 McIntosh,Georgia,US
1611 1611 80008 Out of CO Colorado US 2020-04-03 22:46:37     0 1 0 0 Out of CO,Colorado,US
1612 1612 80015 Out of HI Hawaii US 2020-04-03 22:46:37     2 0 0 0 Out of HI,Hawaii,US
1613 1613   Out of MI Michigan US 2020-04-03 22:46:37     74 1 0 0 Out of MI,Michigan,US
1614 1614 80040 Out of OK Oklahoma US 2020-04-03 22:46:37     2 0 0 0 Out of OK,Oklahoma,US
1615 1615   Out of TN Tennessee US 2020-04-03 22:46:37     187 1 0 0 Out of TN,Tennessee,US
2091 2091 90002 Unassigned Alaska US 2020-04-03 22:46:37     0 2 0 0 Unassigned, Alaska, US
2092 2092 90004 Unassigned Arizona US 2020-04-03 22:46:37     0 12 0 0 Unassigned, Arizona, US
2093 2093 90005 Unassigned Arkansas US 2020-04-03 22:46:37     47 6 0 0 Unassigned, Arkansas, US
2094 2094 90006 Unassigned California US 2020-04-03 22:46:37     0 2 0 0 Unassigned, California, US
2095 2095 90008 Unassigned Colorado US 2020-04-03 22:46:37     144 0 0 0 Unassigned, Colorado, US
2096 2096 90009 Unassigned Connecticut US 2020-04-03 22:46:37     218 1 0 0 Unassigned, Connecticut, US
2097 2097 90010 Unassigned Delaware US 2020-04-03 22:46:37     0 17 0 0 Unassigned, Delaware, US
2098 2098 90012 Unassigned Florida US 2020-04-03 22:46:37     10 7 0 0 Unassigned, Florida, US
2099 2099 90013 Unassigned Georgia US 2020-04-03 22:46:37     507 4 0 0 Unassigned, Georgia, US
2100 2100 90015 Unassigned Hawaii US 2020-04-03 22:46:37     11 0 0 0 Unassigned, Hawaii, US
2101 2101 90017 Unassigned Illinois US 2020-04-03 22:46:37     415 1 0 0 Unassigned, Illinois, US
2102 2102 90019 Unassigned Iowa US 2020-04-03 22:46:37     0 1 0 0 Unassigned, Iowa, US
2103 2103 90021 Unassigned Kentucky US 2020-04-03 22:46:37     113 3 0 0 Unassigned, Kentucky, US
2104 2104   Unassigned Louisiana US 2020-04-03 22:46:37     40 4 0 0 Unassigned,Louisiana,US
2105 2105 90023 Unassigned Maine US 2020-04-03 22:46:37     11 2 0 0 Unassigned, Maine, US
2106 2106 90024 Unassigned Maryland US 2020-04-03 22:46:37     0 0 0 0 Unassigned, Maryland, US
2107 2107 90025 Unassigned Massachusetts US 2020-04-03 22:46:37     213 9 0 0 Unassigned, Massachusetts, US
2108 2108   Unassigned Michigan US 2020-04-03 22:46:37     215 1 0 0 Unassigned,Michigan,US
2109 2109 90027 Unassigned Minnesota US 2020-04-03 22:46:37     0 11 0 0 Unassigned, Minnesota, US
2110 2110 90030 Unassigned Montana US 2020-04-03 22:46:37     0 0 0 0 Unassigned, Montana, US
2111 2111 90031 Unassigned Nebraska US 2020-04-03 22:46:37     1 1 0 0 Unassigned, Nebraska, US
2112 2112 90032 Unassigned Nevada US 2020-04-03 22:46:37     16 0 0 0 Unassigned, Nevada, US
2113 2113 90033 Unassigned New Hampshire US 2020-04-03 22:46:37     0 2 0 0 Unassigned, New Hampshire, US
2114 2114 90034 Unassigned New Jersey US 2020-04-03 22:46:37     4808 4 0 0 Unassigned, New Jersey, US
2115 2115 90035 Unassigned New Mexico US 2020-04-03 22:46:37     3 0 0 0 Unassigned, New Mexico, US
2116 2116 90036 Unassigned New York US 2020-04-03 22:46:37     0 955 0 0 Unassigned, New York, US
2117 2117 90038 Unassigned North Dakota US 2020-04-03 22:46:37     0 0 0 0 Unassigned, North Dakota, US
2118 2118 90040 Unassigned Oklahoma US 2020-04-03 22:46:37     0 0 0 0 Unassigned, Oklahoma, US
2119 2119 90044 Unassigned Rhode Island US 2020-04-03 22:46:37     146 8 0 0 Unassigned, Rhode Island, US
2120 2120 90046 Unassigned South Dakota US 2020-04-03 22:46:37     0 0 0 0 Unassigned, South Dakota, US
2121 2121 90047 Unassigned Tennessee US 2020-04-03 22:46:37     54 0 0 0 Unassigned, Tennessee, US
2122 2122 90050 Unassigned Vermont US 2020-04-03 22:46:37     6 12 0 0 Unassigned, Vermont, US
2123 2123 90051 Unassigned Virginia US 2020-04-03 22:46:37     0 31 0 0 Unassigned,Virginia,US
2124 2124 90053 Unassigned Washington US 2020-04-03 22:46:37     501 0 0 0 Unassigned, Washington, US
2125 2125 90055 Unassigned Wisconsin US 2020-04-03 22:46:37     0 4 0 0 Unassigned, Wisconsin, US
2374 2374     Diamond Princess Canada 2020-04-03 22:52:30     0 1 0 0 Diamond Princess, Canada
2375 2375 88888   Diamond Princess US 2020-04-03 22:46:37     49 0 0 0 Diamond Princess, US
2382 2382     Grand Princess Canada 2020-04-03 22:52:30     13 0 0 0 Grand Princess, Canada
2383 2383 99999   Grand Princess US 2020-04-03 22:46:37     103 3 0 0 Grand Princess, US
2424 2424     Recovered Canada 2020-04-03 22:52:30     0 0 2175 0 Recovered, Canada
2425 2425     Recovered US 2020-04-03 22:46:37     0 0 9707 0 Recovered, US
2493 2493       Diamond Princess 2020-04-03 22:46:20     712 11 619 82 Diamond Princess
2548 2548       MS Zaandam 2020-04-03 22:46:20     9 2 0 7 ,,MS Zaandam
2627 2627   unassigned Wyoming US 2020-04-03 22:46:37     0 0 0 0 unassigned, Wyoming, US
2438 2438     Tasmania Australia 2020-04-03 22:52:45 -42.8821 147.3272 74 2 5 67 Tasmania, Australia
2567 2567       New Zealand 2020-04-03 22:46:20 -40.9006 174.886 868 1 103 764 New Zealand
2455 2455       Argentina 2020-04-03 22:46:20 -38.4161 -63.6167 1265 39 266 960 Argentina
2442 2442     Victoria Australia 2020-04-03 22:52:45 -37.8136 144.9631 1085 7 476 602 Victoria, Australia
2482 2482       Chile 2020-04-03 22:46:20 -35.6751 -71.543 3737 22 427 3288 Chile
2364 2364     Australian Capital Territory Australia 2020-04-03 22:52:45 -35.4735 149.0124 91 1 18 72 Australian Capital Territory, Australia
2436 2436     South Australia Australia 2020-04-03 22:52:45 -34.9285 138.6007 396 0 46 350 South Australia, Australia
2410 2410     New South Wales Australia 2020-04-03 22:52:45 -33.8688 151.2093 2389 12 4 2373 New South Wales, Australia
2620 2620       Uruguay 2020-04-03 22:46:20 -32.5228 -55.7658 369 4 68 297 Uruguay
2444 2444     Western Australia Australia 2020-04-03 22:52:45 -31.9505 115.8605 400 2 92 306 Western Australia, Australia
2600 2600       South Africa 2020-04-03 22:46:20 -30.5595 22.9375 1505 9 95 1401 South Africa
2423 2423     Queensland Australia 2020-04-03 22:52:45 -27.4698 153.0251 873 4 8 861 Queensland, Australia
2503 2503       Eswatini 2020-04-03 22:46:20 -26.5225 31.4659 9 0 0 9 Eswatini
2577 2577       Paraguay 2020-04-03 22:46:20 -23.4425 -58.4438 92 3 6 83 Paraguay
2564 2564       Namibia 2020-04-03 22:46:20 -22.9576 18.4904 14 0 3 11 Namibia
2470 2470       Botswana 2020-04-03 22:46:20 -22.3285 24.6849 4 1 0 3 Botswana
2426 2426     Reunion France 2020-04-03 22:46:20 -21.1151 55.5364 321 0 40 281 Reunion, France
2409 2409     New Caledonia France 2020-04-03 22:46:20 -20.904304999999997 165.618042 18 0 1 17 New Caledonia, France
2556 2556       Mauritius 2020-04-03 22:46:20 -20.348404000000002 57.552152 186 7 0 179 Mauritius
2626 2626       Zimbabwe 2020-04-03 22:46:20 -19.015438 29.154857 9 1 0 8 Zimbabwe
2549 2549       Madagascar 2020-04-03 22:46:20 -18.766947000000002 46.869107 70 0 0 70 Madagascar
2563 2563       Mozambique 2020-04-03 22:46:20 -18.665695 35.529562 10 0 0 10 Mozambique
2505 2505       Fiji 2020-04-03 22:46:20 -17.7134 178.065 7 0 0 7 Fiji
2378 2378     French Polynesia France 2020-04-03 22:46:20 -17.6797 -149.4068 39 0 0 39 French Polynesia, France
2468 2468       Bolivia 2020-04-03 22:46:20 -16.2902 -63.5887 132 9 1 122 Bolivia
2471 2471       Brazil 2020-04-03 22:46:20 -14.235 -51.9253 9056 359 127 8570 Brazil
2589 2589       Samoa 2020-04-03 22:52:30 -13.759 -172.1046 0 0 0 0 Samoa
2550 2550       Malawi 2020-04-03 22:46:20 -13.254307999999998 34.301525 3 0 0 3 Malawi
2625 2625       Zambia 2020-04-03 22:46:20 -13.133897 27.849332 39 1 2 36 Zambia
2406 2406     Mayotte France 2020-04-03 22:46:20 -12.8275 45.166244 128 2 10 116 Mayotte, France
2414 2414     Northern Territory Australia 2020-04-03 22:52:45 -12.4634 130.8456 22 0 0 22 Northern Territory, Australia
2453 2453       Angola 2020-04-03 22:46:20 -11.2027 17.8739 8 2 1 5 Angola
2578 2578       Peru 2020-04-03 22:46:20 -9.19 -75.0152 1595 61 537 997 Peru
2611 2611       Timor-Leste 2020-04-03 22:46:20 -8.874217 125.727539 1 0 0 1 Timor-Leste
2428 2428     Saint Helena, Ascension and Tristan da Cunha United Kingdom 2020-04-03 22:46:20 -7.9467 -14.3559 0 0 0 0 Saint Helena, Ascension and Tristan da Cunha, United Kingdom
2609 2609       Tanzania 2020-04-03 22:46:20 -6.369028 34.888822 20 1 3 16 Tanzania
2576 2576       Papua New Guinea 2020-04-03 22:46:20 -6.314993 143.95555 1 0 0 1 Papua New Guinea
2594 2594       Seychelles 2020-04-03 22:46:20 -4.6796 55.492 10 0 0 10 Seychelles
2485 2485       Congo (Kinshasa) 2020-04-03 22:46:20 -4.322447 15.307045 134 13 3 118 Congo (Kinshasa)
2484 2484       Congo (Brazzaville) 2020-04-03 22:46:20 -4.2634 15.2832 22 2 2 18 Congo (Brazzaville)
2476 2476       Burundi 2020-04-03 22:46:20 -3.3731 29.9189 3 0 0 3 Burundi
2585 2585       Rwanda 2020-04-03 22:46:20 -1.9403 29.8739 89 0 0 89 Rwanda
2497 2497       Ecuador 2020-04-03 22:46:20 -1.8312 -78.1834 3368 145 65 3158 Ecuador
2508 2508       Gabon 2020-04-03 22:46:20 -0.8037 11.6094 21 1 1 19 Gabon
2525 2525       Indonesia 2020-04-03 22:46:20 -0.7893 113.9213 1986 181 134 1671 Indonesia
2535 2535       Kenya 2020-04-03 22:46:20 -0.0236 37.9062 122 4 4 114 Kenya
2596 2596       Singapore 2020-04-03 22:46:20 1.2833 103.8333 1114 5 282 827 Singapore
2616 2616       Uganda 2020-04-03 22:46:20 1.373333 32.290275 48 0 0 48 Uganda
2500 2500       Equatorial Guinea 2020-04-03 22:46:20 1.6508 10.2679 16 0 1 15 Equatorial Guinea
2552 2552       Maldives 2020-04-03 22:46:20 3.2028 73.2207 19 0 13 6 Maldives

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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