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 Long_

✎ 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
2873 2873       Samoa 2020-04-09 23:09:01 -13.759 -172.1046 0 0 0 0 Samoa
169 169 2050 Bethel Alaska US 2020-04-09 23:02:37 60.90980451 -159.8561831 1 0 0 0 Bethel, Alaska, US
1213 1213 15007 Kauai Hawaii US 2020-04-09 23:02:37 22.03935037 -159.5966786 18 0 0 0 Kauai, Hawaii, US
1055 1055 15003 Honolulu Hawaii US 2020-04-09 23:02:37 21.45803166 -157.97121819999995 334 4 0 0 Honolulu, Hawaii, US
1522 1522 15009 Maui Hawaii US 2020-04-09 23:02:37 20.86399628 -156.56890969999995 57 1 0 0 Maui, Hawaii, US
1009 1009 15001 Hawaii Hawaii US 2020-04-09 23:02:37 19.60121157 -155.5210167 28 0 0 0 Hawaii, Hawaii, US
1218 1218 2122 Kenai Peninsula Alaska US 2020-04-09 23:02:37 60.24429722 -151.53888840000005 14 0 0 0 Kenai Peninsula, Alaska, US
2638 2638 2290 Yukon-Koyukuk Alaska US 2020-04-09 23:02:37 65.50815459 -151.39073869999999 1 0 0 0 Yukon-Koyukuk, Alaska, US
1520 1520 2170 Matanuska-Susitna Alaska US 2020-04-09 23:02:37 62.31305045 -149.5741743 6 0 0 0 Matanuska-Susitna, Alaska, US
2661 2661     French Polynesia France 2020-04-09 23:02:19 -17.6797 -149.4068 51 0 0 51 French Polynesia, France
48 48 2020 Anchorage Alaska US 2020-04-09 23:02:37 61.14998174 -149.14269860000005 109 4 0 0 Anchorage, Alaska, US
748 748 2090 Fairbanks North Star Alaska US 2020-04-09 23:02:37 64.80726247 -146.5692662 73 1 0 0 Fairbanks North Star, Alaska, US
2172 2172 2240 Southeast Fairbanks Alaska US 2020-04-09 23:02:37 63.87692095 -143.2127643 1 0 0 0 Southeast Fairbanks, Alaska, US
2730 2730     Yukon Canada 2020-04-09 23:09:01 64.2823 -135.0 7 0 0 0 ,Yukon,Canada
1201 1201 2110 Juneau Alaska US 2020-04-09 23:02:37 58.45031811 -134.200436 14 0 0 0 Juneau, Alaska, US
1859 1859 2195 Petersburg Alaska US 2020-04-09 23:02:37 57.13978948 -132.9540995 2 0 0 0 Petersburg, Alaska, US
1232 1232 2130 Ketchikan Gateway Alaska US 2020-04-09 23:02:37 55.57445008 -130.975561 14 0 0 0 Ketchikan Gateway, Alaska, US
2650 2650     British Columbia Canada 2020-04-09 23:09:01 53.7267 -127.6476 1336 48 0 0 British Columbia, Canada
2698 2698     Northwest Territories Canada 2020-04-09 23:09:01 64.8255 -124.8457 5 0 0 0 ,Northwest Territories,Canada
590 590 41015 Curry Oregon US 2020-04-09 23:02:37 42.45911325 -124.15728200000001 3 0 0 0 Curry, Oregon, US
435 435 53009 Clallam Washington US 2020-04-09 23:02:37 48.04754642 -123.92263190000001 10 0 0 0 Clallam, Washington, US
639 639 6015 Del Norte California US 2020-04-09 23:02:37 41.74228275 -123.89740630000001 2 0 0 0 Del Norte, California, US
1078 1078 6023 Humboldt California US 2020-04-09 23:02:37 40.69923009 -123.876044 50 0 0 0 Humboldt, California, US
1380 1380 41041 Lincoln Oregon US 2020-04-09 23:02:37 44.64252874 -123.86991200000001 4 0 0 0 Lincoln, Oregon, US
910 910 53027 Grays Harbor Washington US 2020-04-09 23:02:37 47.14003705 -123.7820567 7 0 0 0 Grays Harbor, Washington, US
2302 2302 41057 Tillamook Oregon US 2020-04-09 23:02:37 45.46248721 -123.712066 4 0 0 0 Tillamook, Oregon, US
454 454 41007 Clatsop Oregon US 2020-04-09 23:02:37 45.99712889 -123.660711 5 0 0 0 Clatsop, Oregon, US
1169 1169 53031 Jefferson Washington US 2020-04-09 23:02:37 47.75003077 -123.56097040000002 27 0 0 0 Jefferson, Washington, US
1200 1200 41033 Josephine Oregon US 2020-04-09 23:02:37 42.3665549 -123.5561938 16 0 0 0 Josephine, Oregon, US
156 156 41003 Benton Oregon US 2020-04-09 23:02:37 44.49167306 -123.4316987 21 1 0 0 Benton, Oregon, US
2443 2443 53069 Wahkiakum Washington US 2020-04-09 23:02:37 46.29180039999999 -123.4250831 2 0 0 0 Wahkiakum, Washington, US
1912 1912 41053 Polk Oregon US 2020-04-09 23:02:37 44.90322804 -123.4128888 29 1 0 0 Polk, Oregon, US
1565 1565 6045 Mendocino California US 2020-04-09 23:02:37 39.4381191 -123.39113130000001 4 0 0 0 Mendocino, California, US
2622 2622 41071 Yamhill Oregon US 2020-04-09 23:02:37 45.23330449 -123.3086963 29 5 0 0 Yamhill, Oregon, US
1516 1516 53045 Mason Washington US 2020-04-09 23:02:37 47.35007586 -123.1863685 17 0 0 0 Mason, Washington, US
685 685 41019 Douglas Oregon US 2020-04-09 23:02:37 43.27941273 -123.16729099999999 12 0 0 0 Douglas, Oregon, US
2500 2500 41067 Washington Oregon US 2020-04-09 23:02:37 45.55972701 -123.0955257 311 6 0 0 Washington, Oregon, US
515 515 41009 Columbia Oregon US 2020-04-09 23:02:37 45.94464254 -123.08908980000001 10 0 0 0 Columbia, Oregon, US
2071 2071 53055 San Juan Washington US 2020-04-09 23:02:37 48.60182783 -122.96745 12 0 0 0 San Juan, Washington, US
2170 2170 6097 Sonoma California US 2020-04-09 23:02:37 38.52746429 -122.88625060000001 136 1 0 0 Sonoma, California, US

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
);