04-06-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,810 rows sorted by Long_

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: Last_Update

Link rowid FIPS Admin2 Province_State Country_Region Last_Update Lat Long_ ▼ Confirmed Deaths Recovered Active Combined_Key
1472 1472   McIntosh Georgia US 4/6/20 23:22     2 0 0 0 McIntosh,Georgia,US
1731 1731 80008 Out of CO Colorado US 4/6/20 23:22     0 1 0 0 Out of CO,Colorado,US
1732 1732 80015 Out of HI Hawaii US 4/6/20 23:22     2 0 0 0 Out of HI,Hawaii,US
1733 1733   Out of MI Michigan US 4/6/20 23:22     91 1 0 0 Out of MI,Michigan,US
1734 1734 80040 Out of OK Oklahoma US 4/6/20 23:22     2 0 0 0 Out of OK,Oklahoma,US
1735 1735   Out of TN Tennessee US 4/6/20 23:22     290 1 0 0 Out of TN,Tennessee,US
2253 2253 90002 Unassigned Alaska US 4/6/20 23:22     0 5 0 0 Unassigned, Alaska, US
2254 2254 90004 Unassigned Arizona US 4/6/20 23:22     0 10 0 0 Unassigned, Arizona, US
2255 2255 90005 Unassigned Arkansas US 4/6/20 23:22     67 10 0 0 Unassigned, Arkansas, US
2256 2256 90006 Unassigned California US 4/6/20 23:22     43 0 0 0 Unassigned, California, US
2257 2257 90008 Unassigned Colorado US 4/6/20 23:22     276 0 0 0 Unassigned, Colorado, US
2258 2258 90009 Unassigned Connecticut US 4/6/20 23:22     264 0 0 0 Unassigned, Connecticut, US
2259 2259 90010 Unassigned Delaware US 4/6/20 23:22     0 9 0 0 Unassigned, Delaware, US
2260 2260 90012 Unassigned Florida US 4/6/20 23:22     7 1 0 0 Unassigned,Florida,US
2261 2261 90013 Unassigned Georgia US 4/6/20 23:22     320 5 0 0 Unassigned,Georgia,US
2262 2262 90015 Unassigned Hawaii US 4/6/20 23:22     9 0 0 0 Unassigned, Hawaii, US
2263 2263 90016 Unassigned Idaho US 4/6/20 23:22     0 0 0 0 Unassigned, Idaho, US
2264 2264 90017 Unassigned Illinois US 4/6/20 23:22     72 1 0 0 Unassigned, Illinois, US
2265 2265 90018 Unassigned Indiana US 4/6/20 23:22     20 141 0 0 Unassigned, Indiana, US
2266 2266 90019 Unassigned Iowa US 4/6/20 23:22     0 0 0 0 Unassigned, Iowa, US
2267 2267 90020 Unassigned Kansas US 4/6/20 23:22     0 4 0 0 Unassigned,Kansas,US
2268 2268 90021 Unassigned Kentucky US 4/6/20 23:22     34 0 0 0 Unassigned, Kentucky, US
2269 2269   Unassigned Louisiana US 4/6/20 23:22     48 3 0 0 Unassigned,Louisiana,US
2270 2270 90023 Unassigned Maine US 4/6/20 23:22     11 3 0 0 Unassigned, Maine, US
2271 2271 90024 Unassigned Maryland US 4/6/20 23:22     0 0 0 0 Unassigned, Maryland, US
2272 2272 90025 Unassigned Massachusetts US 4/6/20 23:22     246 10 0 0 Unassigned, Massachusetts, US
2273 2273   Unassigned Michigan US 4/6/20 23:22     371 1 0 0 Unassigned,Michigan,US
2274 2274 90027 Unassigned Minnesota US 4/6/20 23:22     6 0 0 0 Unassigned, Minnesota, US
2275 2275 90029 Unassigned Missouri US 4/6/20 23:22     1 1 0 0 Unassigned, Missouri, US
2276 2276 90030 Unassigned Montana US 4/6/20 23:22     0 0 0 0 Unassigned, Montana, US
2277 2277 90031 Unassigned Nebraska US 4/6/20 23:22     1 0 0 0 Unassigned, Nebraska, US
2278 2278 90032 Unassigned Nevada US 4/6/20 23:22     33 0 0 0 Unassigned, Nevada, US
2279 2279 90033 Unassigned New Hampshire US 4/6/20 23:22     1 6 0 0 Unassigned, New Hampshire, US
2280 2280 90034 Unassigned New Jersey US 4/6/20 23:22     3521 14 0 0 Unassigned, New Jersey, US
2281 2281 90035 Unassigned New Mexico US 4/6/20 23:22     0 0 0 0 Unassigned, New Mexico, US
2282 2282 90036 Unassigned New York US 4/6/20 23:22     0 309 0 0 Unassigned, New York, US
2283 2283 90038 Unassigned North Dakota US 4/6/20 23:22     0 0 0 0 Unassigned, North Dakota, US
2284 2284 90039 Unassigned Ohio US 4/6/20 23:22     0 0 0 0 Unassigned, Ohio, US
2285 2285 90040 Unassigned Oklahoma US 4/6/20 23:22     0 0 0 0 Unassigned, Oklahoma, US
2286 2286 90044 Unassigned Rhode Island US 4/6/20 23:22     332 16 0 0 Unassigned, Rhode Island, US
2287 2287 90046 Unassigned South Dakota US 4/6/20 23:22     0 0 0 0 Unassigned, South Dakota, US
2288 2288 90047 Unassigned Tennessee US 4/6/20 23:22     69 0 0 0 Unassigned, Tennessee, US
2289 2289 90049 Unassigned Utah US 4/6/20 23:22     0 0 0 0 Unassigned,Utah,US
2290 2290 90050 Unassigned Vermont US 4/6/20 23:22     21 18 0 0 Unassigned, Vermont, US
2291 2291 90051 Unassigned Virginia US 4/6/20 23:22     0 50 0 0 Unassigned, Virginia, US
2292 2292 90053 Unassigned Washington US 4/6/20 23:22     648 0 0 0 Unassigned, Washington, US
2293 2293 90055 Unassigned Wisconsin US 4/6/20 23:22     0 0 0 0 Unassigned, Wisconsin, US
2553 2553     Diamond Princess Canada 4/6/20 23:28     0 1 0 0 Diamond Princess, Canada
2554 2554 88888   Diamond Princess US 4/6/20 23:22     49 0 0 0 Diamond Princess, US
2562 2562     Grand Princess Canada 4/6/20 23:28     13 0 0 0 Grand Princess, Canada
2563 2563 99999   Grand Princess US 4/6/20 23:22     103 3 0 0 Grand Princess, US
2604 2604     Recovered Canada 4/6/20 23:28     0 0 3256 0 Recovered, Canada
2605 2605     Recovered US 4/6/20 23:22     0 0 19581 0 Recovered, US
2674 2674       Diamond Princess 4/6/20 23:21     712 11 619 82 Diamond Princess
2729 2729       MS Zaandam 4/6/20 23:21     9 2 0 7 ,,MS Zaandam
2810 2810   unassigned Wyoming US 4/6/20 23:22     0 0 0 0 unassigned, Wyoming, US
2770 2770       Samoa 4/6/20 23:28 -13.759 -172.1046 0 0 0 0 Samoa
1160 1160 15007 Kauai Hawaii US 4/6/20 23:22 22.03935037 -159.5966786 17 0 0 0 Kauai, Hawaii, US
1014 1014 15003 Honolulu Hawaii US 4/6/20 23:22 21.45803166 -157.9712182 292 4 0 0 Honolulu, Hawaii, US
1457 1457 15009 Maui Hawaii US 4/6/20 23:22 20.86399628 -156.5689097 44 1 0 0 Maui, Hawaii, US
969 969 15001 Hawaii Hawaii US 4/6/20 23:22 19.60121157 -155.5210167 23 0 0 0 Hawaii, Hawaii, US
1165 1165 2122 Kenai Peninsula Alaska US 4/6/20 23:22 60.24429722 -151.5388884 13 0 0 0 Kenai Peninsula, Alaska, US
2535 2535 2290 Yukon-Koyukuk Alaska US 4/6/20 23:22 65.50815459 -151.3907387 1 0 0 0 Yukon-Koyukuk, Alaska, US
1455 1455 2170 Matanuska-Susitna Alaska US 4/6/20 23:22 62.31305045 -149.5741743 4 0 0 0 Matanuska-Susitna, Alaska, US
2558 2558     French Polynesia France 4/6/20 23:21 -17.6797 -149.4068 42 0 0 42 French Polynesia, France
48 48 2020 Anchorage Alaska US 4/6/20 23:22 61.14998174 -149.1426986 88 1 0 0 Anchorage, Alaska, US
722 722 2090 Fairbanks North Star Alaska US 4/6/20 23:22 64.80726247 -146.5692662 53 0 0 0 Fairbanks North Star, Alaska, US
2083 2083 2240 Southeast Fairbanks Alaska US 4/6/20 23:22 63.87692095 -143.2127643 1 0 0 0 Southeast Fairbanks, Alaska, US
2627 2627     Yukon Canada 4/6/20 23:28 64.2823 -135.0 6 0 0 0 ,Yukon,Canada
1148 1148 2110 Juneau Alaska US 4/6/20 23:22 58.45031811 -134.200436 14 0 0 0 Juneau, Alaska, US
1785 1785 2195 Petersburg Alaska US 4/6/20 23:22 57.13978948 -132.9540995 2 0 0 0 Petersburg, Alaska, US
1179 1179 2130 Ketchikan Gateway Alaska US 4/6/20 23:22 55.57445008 -130.975561 14 0 0 0 Ketchikan Gateway, Alaska, US
2547 2547     British Columbia Canada 4/6/20 23:28 53.7267 -127.6476 1266 38 0 0 British Columbia, Canada
2595 2595     Northwest Territories Canada 4/6/20 23:28 64.8255 -124.8457 5 0 0 0 ,Northwest Territories,Canada
420 420 53009 Clallam Washington US 4/6/20 23:22 48.04754642 -123.9226319 8 0 0 0 Clallam, Washington, US
619 619 6015 Del Norte California US 4/6/20 23:22 41.74228275 -123.8974063 2 0 0 0 Del Norte, California, US
1035 1035 6023 Humboldt California US 4/6/20 23:22 40.69923009 -123.876044 44 0 0 0 Humboldt, California, US
1320 1320 41041 Lincoln Oregon US 4/6/20 23:22 44.64252874 -123.869912 4 0 0 0 Lincoln, Oregon, US
877 877 53027 Grays Harbor Washington US 4/6/20 23:22 47.14003705 -123.7820567 6 0 0 0 Grays Harbor, Washington, US
2208 2208 41057 Tillamook Oregon US 4/6/20 23:22 45.46248721 -123.712066 3 0 0 0 Tillamook, Oregon, US
439 439 41007 Clatsop Oregon US 4/6/20 23:22 45.99712889 -123.660711 4 0 0 0 Clatsop, Oregon, US
1121 1121 53031 Jefferson Washington US 4/6/20 23:22 47.75003077 -123.5609704 22 0 0 0 Jefferson, Washington, US
1147 1147 41033 Josephine Oregon US 4/6/20 23:22 42.3665549 -123.5561938 13 0 0 0 Josephine, Oregon, US
150 150 41003 Benton Oregon US 4/6/20 23:22 44.49167306 -123.4316987 19 1 0 0 Benton, Oregon, US
2342 2342 53069 Wahkiakum Washington US 4/6/20 23:22 46.2918004 -123.4250831 2 0 0 0 Wahkiakum, Washington, US
1836 1836 41053 Polk Oregon US 4/6/20 23:22 44.90322804 -123.4128888 24 1 0 0 Polk, Oregon, US
1497 1497 6045 Mendocino California US 4/6/20 23:22 39.4381191 -123.3911313 4 0 0 0 Mendocino, California, US
2519 2519 41071 Yamhill Oregon US 4/6/20 23:22 45.23330449 -123.3086963 26 3 0 0 Yamhill, Oregon, US
1451 1451 53045 Mason Washington US 4/6/20 23:22 47.35007586 -123.1863685 15 0 0 0 Mason, Washington, US
662 662 41019 Douglas Oregon US 4/6/20 23:22 43.27941273 -123.167291 11 0 0 0 Douglas, Oregon, US
2398 2398 41067 Washington Oregon US 4/6/20 23:22 45.55972701 -123.0955257 259 4 0 0 Washington, Oregon, US
498 498 41009 Columbia Oregon US 4/6/20 23:22 45.94464254 -123.0890898 6 0 0 0 Columbia, Oregon, US
1987 1987 53055 San Juan Washington US 4/6/20 23:22 48.60182783 -122.96745 9 0 0 0 San Juan, Washington, US
2081 2081 6097 Sonoma California US 4/6/20 23:22 38.52746429 -122.8862506 111 2 0 0 Sonoma, California, US
1241 1241 41039 Lane Oregon US 4/6/20 23:22 43.93727035 -122.847753 27 1 0 0 Lane, Oregon, US
2206 2206 53067 Thurston Washington US 4/6/20 23:22 46.9291895 -122.8290656 67 1 0 0 Thurston, Washington, US
1221 1221 6033 Lake California US 4/6/20 23:22 39.10124298 -122.7536244 1 0 0 0 Lake, California, US
1085 1085 41029 Jackson Oregon US 4/6/20 23:22 42.43201126 -122.7289309 33 0 0 0 Jackson, Oregon, US
1413 1413 6041 Marin California US 4/6/20 23:22 38.07122463 -122.7210631 141 7 0 0 Marin, California, US
530 530 53015 Cowlitz Washington US 4/6/20 23:22 46.19074721 -122.6782231 18 0 0 0 Cowlitz, Washington, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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