04-08-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,884 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
1521 1521   McIntosh Georgia US 2020-04-08 22:51:58     3 0 0 0 McIntosh,Georgia,US
1785 1785 80008 Out of CO Colorado US 2020-04-08 22:51:58     0 1 0 0 Out of CO,Colorado,US
1786 1786 80015 Out of HI Hawaii US 2020-04-08 22:51:58     2 0 0 0 Out of HI,Hawaii,US
1787 1787   Out of MI Michigan US 2020-04-08 22:51:58     126 1 0 0 Out of MI,Michigan,US
1788 1788 80040 Out of OK Oklahoma US 2020-04-08 22:51:58     2 0 0 0 Out of OK,Oklahoma,US
1789 1789   Out of TN Tennessee US 2020-04-08 22:51:58     282 0 0 0 Out of TN,Tennessee,US
2323 2323 90002 Unassigned Alaska US 2020-04-08 22:51:58     1 2 0 0 Unassigned, Alaska, US
2324 2324 90004 Unassigned Arizona US 2020-04-08 22:51:58     0 12 0 0 Unassigned, Arizona, US
2325 2325 90005 Unassigned Arkansas US 2020-04-08 22:51:58     44 12 0 0 Unassigned, Arkansas, US
2326 2326 90006 Unassigned California US 2020-04-08 22:51:58     167 2 0 0 Unassigned, California, US
2327 2327 90008 Unassigned Colorado US 2020-04-08 22:51:58     238 1 0 0 Unassigned, Colorado, US
2328 2328 90009 Unassigned Connecticut US 2020-04-08 22:51:58     292 52 0 0 Unassigned, Connecticut, US
2329 2329 90010 Unassigned Delaware US 2020-04-08 22:51:58     0 13 0 0 Unassigned, Delaware, US
2330 2330 90012 Unassigned Florida US 2020-04-08 22:51:58     3 0 0 0 Unassigned, Florida, US
2331 2331 90013 Unassigned Georgia US 2020-04-08 22:51:58     857 6 0 0 Unassigned,Georgia,US
2332 2332 90015 Unassigned Hawaii US 2020-04-08 22:51:58     7 0 0 0 Unassigned, Hawaii, US
2333 2333 90016 Unassigned Idaho US 2020-04-08 22:51:58     0 0 0 0 Unassigned, Idaho, US
2334 2334 90017 Unassigned Illinois US 2020-04-08 22:51:58     73 1 0 0 Unassigned, Illinois, US
2335 2335 90018 Unassigned Indiana US 2020-04-08 22:51:58     0 135 0 0 Unassigned, Indiana, US
2336 2336 90019 Unassigned Iowa US 2020-04-08 22:51:58     0 1 0 0 Unassigned, Iowa, US
2337 2337 90020 Unassigned Kansas US 2020-04-08 22:51:58     0 4 0 0 Unassigned,Kansas,US
2338 2338 90021 Unassigned Kentucky US 2020-04-08 22:51:58     152 5 0 0 Unassigned, Kentucky, US
2339 2339   Unassigned Louisiana US 2020-04-08 22:51:58     49 2 0 0 Unassigned,Louisiana,US
2340 2340 90023 Unassigned Maine US 2020-04-08 22:51:58     8 0 0 0 Unassigned, Maine, US
2341 2341 90024 Unassigned Maryland US 2020-04-08 22:51:58     0 0 0 0 Unassigned, Maryland, US
2342 2342 90025 Unassigned Massachusetts US 2020-04-08 22:51:58     223 13 0 0 Unassigned, Massachusetts, US
2343 2343 90026 Unassigned Michigan US 2020-04-08 22:51:58     364 3 0 0 Unassigned,Michigan,US
2344 2344 90027 Unassigned Minnesota US 2020-04-08 22:51:58     4 0 0 0 Unassigned, Minnesota, US
2345 2345 90028 Unassigned Mississippi US 2020-04-08 22:51:58     0 0 0 0 Unassigned, Mississippi, US
2346 2346 90029 Unassigned Missouri US 2020-04-08 22:51:58     1 3 0 0 Unassigned, Missouri, US
2347 2347 90030 Unassigned Montana US 2020-04-08 22:51:58     0 0 0 0 Unassigned, Montana, US
2348 2348 90031 Unassigned Nebraska US 2020-04-08 22:51:58     0 1 0 0 Unassigned, Nebraska, US
2349 2349 90032 Unassigned Nevada US 2020-04-08 22:51:58     0 0 0 0 Unassigned, Nevada, US
2350 2350 90033 Unassigned New Hampshire US 2020-04-08 22:51:58     1 10 0 0 Unassigned, New Hampshire, US
2351 2351 90034 Unassigned New Jersey US 2020-04-08 22:51:58     1391 4 0 0 Unassigned, New Jersey, US
2352 2352 90035 Unassigned New Mexico US 2020-04-08 22:51:58     0 0 0 0 Unassigned, New Mexico, US
2353 2353 90036 Unassigned New York US 2020-04-08 22:51:58     0 152 0 0 Unassigned, New York, US
2354 2354 90038 Unassigned North Dakota US 2020-04-08 22:51:58     0 0 0 0 Unassigned, North Dakota, US
2355 2355 90039 Unassigned Ohio US 2020-04-08 22:51:58     0 0 0 0 Unassigned, Ohio, US
2356 2356 90040 Unassigned Oklahoma US 2020-04-08 22:51:58     0 0 0 0 Unassigned, Oklahoma, US
2357 2357 90042 Unassigned Pennsylvania US 2020-04-08 22:51:58     0 0 0 0 Unassigned, Pennsylvania, US
2358 2358 90044 Unassigned Rhode Island US 2020-04-08 22:51:58     274 31 0 0 Unassigned, Rhode Island, US
2359 2359 90046 Unassigned South Dakota US 2020-04-08 22:51:58     0 0 0 0 Unassigned, South Dakota, US
2360 2360 90047 Unassigned Tennessee US 2020-04-08 22:51:58     31 0 0 0 Unassigned, Tennessee, US
2361 2361 90049 Unassigned Utah US 2020-04-08 22:51:58     0 0 0 0 Unassigned,Utah,US
2362 2362 90050 Unassigned Vermont US 2020-04-08 22:51:58     33 18 0 0 Unassigned, Vermont, US
2363 2363 90051 Unassigned Virginia US 2020-04-08 22:51:58     0 42 0 0 Unassigned, Virginia, US
2364 2364 90053 Unassigned Washington US 2020-04-08 22:51:58     915 0 0 0 Unassigned, Washington, US
2365 2365 90054 Unassigned West Virginia US 2020-04-08 22:51:58     21 0 0 0 Unassigned, West Virginia, US
2366 2366 90055 Unassigned Wisconsin US 2020-04-08 22:51:58     0 0 0 0 Unassigned, Wisconsin, US
2367 2367   Unassigned Wyoming US 2020-04-08 22:51:58     0 0 0 0 Unassigned,Wyoming,US
2628 2628     Diamond Princess Canada 2020-04-08 22:58:44     0 1 0 0 Diamond Princess, Canada
2629 2629 88888   Diamond Princess US 2020-04-08 22:51:58     49 0 0 0 Diamond Princess, US
2637 2637     Grand Princess Canada 2020-04-08 22:58:44     13 0 0 0 Grand Princess, Canada
2638 2638 99999   Grand Princess US 2020-04-08 22:51:58     103 3 0 0 Grand Princess, US
2679 2679     Recovered Canada 2020-04-08 22:58:44     0 0 4154 0 Recovered, Canada
2680 2680     Recovered US 2020-04-08 22:51:58     0 0 23559 0 Recovered, US
2749 2749       Diamond Princess 2020-04-08 22:51:39     712 11 619 82 Diamond Princess
2804 2804       MS Zaandam 2020-04-08 22:51:39     9 2 0 7 ,,MS Zaandam
2845 2845       Samoa 2020-04-08 22:58:44 -13.759 -172.1046 0 0 0 0 Samoa
167 167 2050 Bethel Alaska US 2020-04-08 22:51:58 60.90980451 -159.8561831 1 0 0 0 Bethel, Alaska, US
1200 1200 15007 Kauai Hawaii US 2020-04-08 22:51:58 22.03935037 -159.5966786 18 0 0 0 Kauai, Hawaii, US
1047 1047 15003 Honolulu Hawaii US 2020-04-08 22:51:58 21.45803166 -157.97121819999995 312 4 0 0 Honolulu, Hawaii, US
1504 1504 15009 Maui Hawaii US 2020-04-08 22:51:58 20.86399628 -156.56890969999995 48 1 0 0 Maui, Hawaii, US
1001 1001 15001 Hawaii Hawaii US 2020-04-08 22:51:58 19.60121157 -155.5210167 23 0 0 0 Hawaii, Hawaii, US
1205 1205 2122 Kenai Peninsula Alaska US 2020-04-08 22:51:58 60.24429722 -151.53888840000005 13 0 0 0 Kenai Peninsula, Alaska, US
2610 2610 2290 Yukon-Koyukuk Alaska US 2020-04-08 22:51:58 65.50815459 -151.39073869999999 1 0 0 0 Yukon-Koyukuk, Alaska, US
1502 1502 2170 Matanuska-Susitna Alaska US 2020-04-08 22:51:58 62.31305045 -149.5741743 5 0 0 0 Matanuska-Susitna, Alaska, US
2633 2633     French Polynesia France 2020-04-08 22:51:39 -17.6797 -149.4068 51 0 0 51 French Polynesia, France
48 48 2020 Anchorage Alaska US 2020-04-08 22:51:58 61.14998174 -149.14269860000005 103 4 0 0 Anchorage, Alaska, US
742 742 2090 Fairbanks North Star Alaska US 2020-04-08 22:51:58 64.80726247 -146.5692662 71 1 0 0 Fairbanks North Star, Alaska, US
2148 2148 2240 Southeast Fairbanks Alaska US 2020-04-08 22:51:58 63.87692095 -143.2127643 1 0 0 0 Southeast Fairbanks, Alaska, US
2702 2702     Yukon Canada 2020-04-08 22:58:44 64.2823 -135.0 7 0 0 0 ,Yukon,Canada
1188 1188 2110 Juneau Alaska US 2020-04-08 22:51:58 58.45031811 -134.200436 14 0 0 0 Juneau, Alaska, US
1839 1839 2195 Petersburg Alaska US 2020-04-08 22:51:58 57.13978948 -132.9540995 2 0 0 0 Petersburg, Alaska, US
1219 1219 2130 Ketchikan Gateway Alaska US 2020-04-08 22:51:58 55.57445008 -130.975561 14 0 0 0 Ketchikan Gateway, Alaska, US
2622 2622     British Columbia Canada 2020-04-08 22:58:44 53.7267 -127.6476 1291 43 0 0 British Columbia, Canada
2670 2670     Northwest Territories Canada 2020-04-08 22:58:44 64.8255 -124.8457 5 0 0 0 ,Northwest Territories,Canada
586 586 41015 Curry Oregon US 2020-04-08 22:51:58 42.45911325 -124.15728200000001 2 0 0 0 Curry, Oregon, US
432 432 53009 Clallam Washington US 2020-04-08 22:51:58 48.04754642 -123.92263190000001 9 0 0 0 Clallam, Washington, US
635 635 6015 Del Norte California US 2020-04-08 22:51:58 41.74228275 -123.89740630000001 2 0 0 0 Del Norte, California, US
1069 1069 6023 Humboldt California US 2020-04-08 22:51:58 40.69923009 -123.876044 50 0 0 0 Humboldt, California, US
1364 1364 41041 Lincoln Oregon US 2020-04-08 22:51:58 44.64252874 -123.86991200000001 4 0 0 0 Lincoln, Oregon, US
904 904 53027 Grays Harbor Washington US 2020-04-08 22:51:58 47.14003705 -123.7820567 7 0 0 0 Grays Harbor, Washington, US
2277 2277 41057 Tillamook Oregon US 2020-04-08 22:51:58 45.46248721 -123.712066 3 0 0 0 Tillamook, Oregon, US
451 451 41007 Clatsop Oregon US 2020-04-08 22:51:58 45.99712889 -123.660711 5 0 0 0 Clatsop, Oregon, US
1158 1158 53031 Jefferson Washington US 2020-04-08 22:51:58 47.75003077 -123.56097040000002 27 0 0 0 Jefferson, Washington, US
1187 1187 41033 Josephine Oregon US 2020-04-08 22:51:58 42.3665549 -123.5561938 16 0 0 0 Josephine, Oregon, US
154 154 41003 Benton Oregon US 2020-04-08 22:51:58 44.49167306 -123.4316987 21 1 0 0 Benton, Oregon, US
2416 2416 53069 Wahkiakum Washington US 2020-04-08 22:51:58 46.29180039999999 -123.4250831 2 0 0 0 Wahkiakum, Washington, US
1891 1891 41053 Polk Oregon US 2020-04-08 22:51:58 44.90322804 -123.4128888 28 1 0 0 Polk, Oregon, US
1547 1547 6045 Mendocino California US 2020-04-08 22:51:58 39.4381191 -123.39113130000001 4 0 0 0 Mendocino, California, US
2594 2594 41071 Yamhill Oregon US 2020-04-08 22:51:58 45.23330449 -123.3086963 25 3 0 0 Yamhill, Oregon, US
1498 1498 53045 Mason Washington US 2020-04-08 22:51:58 47.35007586 -123.1863685 17 0 0 0 Mason, Washington, US
680 680 41019 Douglas Oregon US 2020-04-08 22:51:58 43.27941273 -123.16729099999999 12 0 0 0 Douglas, Oregon, US
2473 2473 41067 Washington Oregon US 2020-04-08 22:51:58 45.55972701 -123.0955257 282 6 0 0 Washington, Oregon, US
512 512 41009 Columbia Oregon US 2020-04-08 22:51:58 45.94464254 -123.08908980000001 8 0 0 0 Columbia, Oregon, US
2048 2048 53055 San Juan Washington US 2020-04-08 22:51:58 48.60182783 -122.96745 12 0 0 0 San Juan, Washington, US
2146 2146 6097 Sonoma California US 2020-04-08 22:51:58 38.52746429 -122.88625060000001 120 1 0 0 Sonoma, California, US
1283 1283 41039 Lane Oregon US 2020-04-08 22:51:58 43.93727035 -122.847753 30 1 0 0 Lane, Oregon, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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