04-12-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,990 rows sorted by Long_

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: Last_Update, Last_Update (date)

Link rowid FIPS Admin2 Province_State Country_Region Last_Update Lat Long_ ▼ Confirmed Deaths Recovered Active Combined_Key
1576 1576   McIntosh Georgia US 2020-04-12 23:18:00     3 0 0 3 McIntosh, Georgia, US
1850 1850 80015 Out of HI Hawaii US 2020-04-12 23:18:00     2 0 0 2 Out of HI, Hawaii, US
1851 1851   Out of MI Michigan US 2020-04-12 23:18:00     144 1 0 143 Out of MI, Michigan, US
1852 1852 80040 Out of OK Oklahoma US 2020-04-12 23:18:00     0 0 0 0 Out of OK, Oklahoma, US
1853 1853   Out of TN Tennessee US 2020-04-12 23:18:00     276 1 0 275 Out of TN, Tennessee, US
2420 2420 90001 Unassigned Alabama US 2020-04-12 23:18:00     0 0 0 0 Unassigned, Alabama, US
2421 2421 90002 Unassigned Alaska US 2020-04-12 23:18:00     0 3 0 -3 Unassigned, Alaska, US
2422 2422 90004 Unassigned Arizona US 2020-04-12 23:18:00     0 22 0 -22 Unassigned, Arizona, US
2423 2423 90005 Unassigned Arkansas US 2020-04-12 23:18:00     25 0 0 25 Unassigned, Arkansas, US
2424 2424 90006 Unassigned California US 2020-04-12 23:18:00     8 0 0 8 Unassigned, California, US
2425 2425 90008 Unassigned Colorado US 2020-04-12 23:18:00     156 0 0 156 Unassigned, Colorado, US
2426 2426 90009 Unassigned Connecticut US 2020-04-12 23:18:00     501 4 0 497 Unassigned, Connecticut, US
2427 2427 90010 Unassigned Delaware US 2020-04-12 23:18:00     0 5 0 -2 Unassigned, Delaware, US
2428 2428 90012 Unassigned Florida US 2020-04-12 23:18:00     2 0 0 2 Unassigned, Florida, US
2429 2429 90013 Unassigned Georgia US 2020-04-12 23:18:00     1218 4 0 1214 Unassigned, Georgia, US
2430 2430 90015 Unassigned Hawaii US 2020-04-12 23:18:00     3 0 0 3 Unassigned, Hawaii, US
2431 2431 90016 Unassigned Idaho US 2020-04-12 23:18:00     0 0 0 0 Unassigned, Idaho, US
2432 2432 90017 Unassigned Illinois US 2020-04-12 23:18:00     101 1 0 100 Unassigned, Illinois, US
2433 2433 90018 Unassigned Indiana US 2020-04-12 23:18:00     0 105 0 0 Unassigned, Indiana, US
2434 2434 90019 Unassigned Iowa US 2020-04-12 23:18:00     0 6 0 -6 Unassigned, Iowa, US
2435 2435 90020 Unassigned Kansas US 2020-04-12 23:18:00     0 11 0 -4 Unassigned, Kansas, US
2436 2436 90021 Unassigned Kentucky US 2020-04-12 23:18:00     112 28 0 84 Unassigned, Kentucky, US
2437 2437 90022 Unassigned Louisiana US 2020-04-12 23:18:00     54 3 0 51 Unassigned, Louisiana, US
2438 2438 90023 Unassigned Maine US 2020-04-12 23:18:00     3 0 0 3 Unassigned, Maine, US
2439 2439 90025 Unassigned Massachusetts US 2020-04-12 23:18:00     373 12 0 361 Unassigned, Massachusetts, US
2440 2440 90026 Unassigned Michigan US 2020-04-12 23:18:00     86 12 0 74 Unassigned, Michigan, US
2441 2441 90027 Unassigned Minnesota US 2020-04-12 23:18:00     5 0 0 5 Unassigned, Minnesota, US
2442 2442 90028 Unassigned Mississippi US 2020-04-12 23:18:00     0 0 0 0 Unassigned, Mississippi, US
2443 2443 90029 Unassigned Missouri US 2020-04-12 23:18:00     0 1 0 -1 Unassigned, Missouri, US
2444 2444 90030 Unassigned Montana US 2020-04-12 23:18:00     0 0 0 0 Unassigned, Montana, US
2445 2445 90031 Unassigned Nebraska US 2020-04-12 23:18:00     23 2 0 21 Unassigned, Nebraska, US
2446 2446 90032 Unassigned Nevada US 2020-04-12 23:18:00     23 0 0 23 Unassigned, Nevada, US
2447 2447 90033 Unassigned New Hampshire US 2020-04-12 23:18:00     1 20 0 -19 Unassigned, New Hampshire, US
2448 2448 90034 Unassigned New Jersey US 2020-04-12 23:18:00     1274 2 0 1272 Unassigned, New Jersey, US
2449 2449 90035 Unassigned New Mexico US 2020-04-12 23:18:00     0 0 0 0 Unassigned, New Mexico, US
2450 2450 90036 Unassigned New York US 2020-04-12 23:18:00     0 40 0 -40 Unassigned, New York, US
2451 2451 90039 Unassigned Ohio US 2020-04-12 23:18:00     2 0 0 2 Unassigned, Ohio, US
2452 2452 90040 Unassigned Oklahoma US 2020-04-12 23:18:00     0 0 0 0 Unassigned, Oklahoma, US
2453 2453 90041 Unassigned Oregon US 2020-04-12 23:18:00     1 0 0 1 Unassigned, Oregon, US
2454 2454 90042 Unassigned Pennsylvania US 2020-04-12 23:18:00     0 0 0 0 Unassigned, Pennsylvania, US
2455 2455 90044 Unassigned Rhode Island US 2020-04-12 23:18:00     965 28 0 905 Unassigned, Rhode Island, US
2456 2456 90046 Unassigned South Dakota US 2020-04-12 23:18:00     0 0 0 0 Unassigned, South Dakota, US
2457 2457 90047 Unassigned Tennessee US 2020-04-12 23:18:00     12 0 0 12 Unassigned, Tennessee, US
2458 2458 90050 Unassigned Vermont US 2020-04-12 23:18:00     7 0 0 7 Unassigned, Vermont, US
2459 2459 90051 Unassigned Virginia US 2020-04-12 23:18:00     0 62 0 -62 Unassigned, Virginia, US
2460 2460 90053 Unassigned Washington US 2020-04-12 23:18:00     732 0 0 732 Unassigned, Washington, US
2461 2461 90054 Unassigned West Virginia US 2020-04-12 23:18:00     0 2 0 -2 Unassigned, West Virginia, US
2462 2462 90055 Unassigned Wisconsin US 2020-04-12 23:18:00     0 0 0 0 Unassigned, Wisconsin, US
2463 2463   Unassigned Wyoming US 2020-04-12 23:18:00     0 0 0 0 Unassigned, Wyoming, US
2733 2733 88888   Diamond Princess US 2020-04-12 23:18:00     49 0 0 49 Diamond Princess, US
2741 2741     Grand Princess Canada 2020-04-12 23:24:00     13 0 0 13 Grand Princess, Canada
2742 2742 99999   Grand Princess US 2020-04-12 23:18:00     103 0 0 103 Grand Princess, US
2783 2783     Recovered Canada 2020-04-12 23:24:00     0 0 7123 -7123 Recovered, Canada
2784 2784     Recovered US 2020-04-12 23:18:00     0 0 32988 -32988 Recovered, US
2853 2853       Diamond Princess 2020-04-12 23:17:00     712 11 619 82 Diamond Princess
2908 2908       MS Zaandam 2020-04-12 23:17:00     9 2 0 7 MS Zaandam
2990 2990   unassigned Utah US 2020-04-12 23:18:00     4 5 0 -1 unassigned, Utah, US
2949 2949       Samoa 2020-04-12 23:24:00 -13.759 -172.1046 0 0 0 0 Samoa
172 172 2050 Bethel Alaska US 2020-04-12 23:18:00 60.90980451 -159.8561831 1 0 0 1 Bethel, Alaska, US
1241 1241 15007 Kauai Hawaii US 2020-04-12 23:18:00 22.03935037 -159.5966786 21 0 0 21 Kauai, Hawaii, US
1081 1081 15003 Honolulu Hawaii US 2020-04-12 23:18:00 21.45803166 -157.9712182 350 6 0 344 Honolulu, Hawaii, US
1558 1558 15009 Maui Hawaii US 2020-04-12 23:18:00 20.86399628 -156.5689097 84 3 0 81 Maui, Hawaii, US
1033 1033 15001 Hawaii Hawaii US 2020-04-12 23:18:00 19.60121157 -155.5210167 39 0 0 39 Hawaii, Hawaii, US
1247 1247 2122 Kenai Peninsula Alaska US 2020-04-12 23:18:00 60.24429722 -151.5388884 15 0 0 15 Kenai Peninsula, Alaska, US
2715 2715 2290 Yukon-Koyukuk Alaska US 2020-04-12 23:18:00 65.50815459 -151.3907387 1 0 0 1 Yukon-Koyukuk, Alaska, US
1556 1556 2170 Matanuska-Susitna Alaska US 2020-04-12 23:18:00 62.31305045 -149.5741743 14 0 0 14 Matanuska-Susitna, Alaska, US
2737 2737     French Polynesia France 2020-04-12 23:17:00 -17.6797 -149.4068 53 0 0 53 French Polynesia, France
49 49 2020 Anchorage Alaska US 2020-04-12 23:18:00 61.14998174 -149.1426986 127 4 0 123 Anchorage, Alaska, US
763 763 2090 Fairbanks North Star Alaska US 2020-04-12 23:18:00 64.80726247 -146.5692662 79 1 0 78 Fairbanks North Star, Alaska, US
2236 2236 2240 Southeast Fairbanks Alaska US 2020-04-12 23:18:00 63.87692095 -143.2127643 1 0 0 1 Southeast Fairbanks, Alaska, US
2806 2806     Yukon Canada 2020-04-12 23:24:00 64.2823 -135.0 8 0 0 8 Yukon, Canada
1229 1229 2110 Juneau Alaska US 2020-04-12 23:18:00 58.45031811 -134.200436 16 0 0 16 Juneau, Alaska, US
1996 1996 2198 Prince of Wales-Hyder Alaska US 2020-04-12 23:18:00 55.76261984 -133.0511621 1 0 0 1 Prince of Wales-Hyder, Alaska, US
1906 1906 2195 Petersburg Alaska US 2020-04-12 23:18:00 57.13978948 -132.9540995 2 0 0 2 Petersburg, Alaska, US
1261 1261 2130 Ketchikan Gateway Alaska US 2020-04-12 23:18:00 55.57445008 -130.975561 15 0 0 15 Ketchikan Gateway, Alaska, US
2727 2727     British Columbia Canada 2020-04-12 23:24:00 53.7267 -127.6476 1445 58 0 1387 British Columbia, Canada
2774 2774     Northwest Territories Canada 2020-04-12 23:24:00 64.8255 -124.8457 5 0 0 5 Northwest Territories, Canada
602 602 41015 Curry Oregon US 2020-04-12 23:18:00 42.45911325 -124.157282 3 0 0 3 Curry, Oregon, US
443 443 53009 Clallam Washington US 2020-04-12 23:18:00 48.04754642 -123.9226319 12 0 0 12 Clallam, Washington, US
652 652 6015 Del Norte California US 2020-04-12 23:18:00 41.74228275 -123.8974063 2 0 0 2 Del Norte, California, US
1105 1105 6023 Humboldt California US 2020-04-12 23:18:00 40.69923009 -123.876044 50 0 0 50 Humboldt, California, US
1414 1414 41041 Lincoln Oregon US 2020-04-12 23:18:00 44.64252874 -123.869912 4 0 0 4 Lincoln, Oregon, US
932 932 53027 Grays Harbor Washington US 2020-04-12 23:18:00 47.14003705 -123.7820567 11 0 0 11 Grays Harbor, Washington, US
1860 1860 53049 Pacific Washington US 2020-04-12 23:18:00 46.55418369 -123.7285716 1 0 0 1 Pacific, Washington, US
2371 2371 41057 Tillamook Oregon US 2020-04-12 23:18:00 45.46248721 -123.712066 4 0 0 4 Tillamook, Oregon, US
462 462 41007 Clatsop Oregon US 2020-04-12 23:18:00 45.99712889 -123.660711 6 0 0 6 Clatsop, Oregon, US
1197 1197 53031 Jefferson Washington US 2020-04-12 23:18:00 47.75003077 -123.5609704 28 0 0 28 Jefferson, Washington, US
1228 1228 41033 Josephine Oregon US 2020-04-12 23:18:00 42.3665549 -123.5561938 18 1 0 17 Josephine, Oregon, US
159 159 41003 Benton Oregon US 2020-04-12 23:18:00 44.49167306 -123.4316987 23 2 0 21 Benton, Oregon, US
2514 2514 53069 Wahkiakum Washington US 2020-04-12 23:18:00 46.2918004 -123.4250831 2 0 0 2 Wahkiakum, Washington, US
1963 1963 41053 Polk Oregon US 2020-04-12 23:18:00 44.90322804 -123.4128888 30 1 0 29 Polk, Oregon, US
1602 1602 6045 Mendocino California US 2020-04-12 23:18:00 39.4381191 -123.3911313 4 0 0 4 Mendocino, California, US
2699 2699 41071 Yamhill Oregon US 2020-04-12 23:18:00 45.23330449 -123.3086963 30 6 0 24 Yamhill, Oregon, US
1552 1552 53045 Mason Washington US 2020-04-12 23:18:00 47.35007586 -123.1863685 19 0 0 19 Mason, Washington, US
699 699 41019 Douglas Oregon US 2020-04-12 23:18:00 43.27941273 -123.167291 14 0 0 14 Douglas, Oregon, US
2573 2573 41067 Washington Oregon US 2020-04-12 23:18:00 45.55972701 -123.0955257 348 6 0 342 Washington, Oregon, US
525 525 41009 Columbia Oregon US 2020-04-12 23:18:00 45.94464254 -123.0890898 10 0 0 10 Columbia, Oregon, US
2131 2131 53055 San Juan Washington US 2020-04-12 23:18:00 48.60182783 -122.96745 13 0 0 13 San Juan, Washington, US
2234 2234 6097 Sonoma California US 2020-04-12 23:18:00 38.52746429 -122.8862506 145 2 0 143 Sonoma, California, US
1329 1329 41039 Lane Oregon US 2020-04-12 23:18:00 43.93727035 -122.847753 37 1 0 36 Lane, Oregon, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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