04-13-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

3,003 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
794 794   Federal Correctional Institution (FCI) Michigan US 2020-04-13 23:07:54     21 0 0 21 Federal Correctional Institution (FCI), Michigan, US
1586 1586   McIntosh Georgia US 2020-04-13 23:07:54     3 0 0 3 McIntosh, Georgia, US
1632 1632   Michigan Department of Corrections (MDOC) Michigan US 2020-04-13 23:07:54     370 8 0 362 Michigan Department of Corrections (MDOC), Michigan, US
1864 1864 80015 Out of HI Hawaii US 2020-04-13 23:07:54     2 0 0 2 Out of HI, Hawaii, US
1865 1865   Out of MI Michigan US 2020-04-13 23:07:54     148 1 0 147 Out of MI, Michigan, US
1866 1866 80040 Out of OK Oklahoma US 2020-04-13 23:07:54     0 0 0 0 Out of OK, Oklahoma, US
1867 1867   Out of TN Tennessee US 2020-04-13 23:07:54     260 1 0 259 Out of TN, Tennessee, US
2434 2434 90001 Unassigned Alabama US 2020-04-13 23:07:54     0 0 0 0 Unassigned, Alabama, US
2435 2435 90002 Unassigned Alaska US 2020-04-13 23:07:54     0 3 0 -3 Unassigned, Alaska, US
2436 2436 90004 Unassigned Arizona US 2020-04-13 23:07:54     0 18 0 -18 Unassigned, Arizona, US
2437 2437 90005 Unassigned Arkansas US 2020-04-13 23:07:54     36 0 0 36 Unassigned, Arkansas, US
2438 2438 90006 Unassigned California US 2020-04-13 23:07:54     0 0 0 0 Unassigned, California, US
2439 2439 90008 Unassigned Colorado US 2020-04-13 23:07:54     145 0 0 145 Unassigned, Colorado, US
2440 2440 90009 Unassigned Connecticut US 2020-04-13 23:07:54     491 4 0 487 Unassigned, Connecticut, US
2441 2441 90010 Unassigned Delaware US 2020-04-13 23:07:54     0 7 0 0 Unassigned, Delaware, US
2442 2442 90012 Unassigned Florida US 2020-04-13 23:07:54     2 0 0 2 Unassigned, Florida, US
2443 2443 90013 Unassigned Georgia US 2020-04-13 23:07:54     1219 1 0 1218 Unassigned, Georgia, US
2444 2444 90015 Unassigned Hawaii US 2020-04-13 23:07:54     3 0 0 3 Unassigned, Hawaii, US
2445 2445 90016 Unassigned Idaho US 2020-04-13 23:07:54     0 0 0 0 Unassigned, Idaho, US
2446 2446 90017 Unassigned Illinois US 2020-04-13 23:07:54     65 1 0 64 Unassigned, Illinois, US
2447 2447 90018 Unassigned Indiana US 2020-04-13 23:07:54     0 133 0 0 Unassigned, Indiana, US
2448 2448 90019 Unassigned Iowa US 2020-04-13 23:07:54     0 3 0 -3 Unassigned, Iowa, US
2449 2449 90020 Unassigned Kansas US 2020-04-13 23:07:54     0 4 0 -5 Unassigned, Kansas, US
2450 2450 90021 Unassigned Kentucky US 2020-04-13 23:07:54     112 28 0 84 Unassigned, Kentucky, US
2451 2451 90022 Unassigned Louisiana US 2020-04-13 23:07:54     56 0 0 56 Unassigned, Louisiana, US
2452 2452 90023 Unassigned Maine US 2020-04-13 23:07:54     5 0 0 5 Unassigned, Maine, US
2453 2453 90025 Unassigned Massachusetts US 2020-04-13 23:07:54     447 100 0 347 Unassigned, Massachusetts, US
2454 2454 90026 Unassigned Michigan US 2020-04-13 23:07:54     78 4 0 74 Unassigned, Michigan, US
2455 2455 90027 Unassigned Minnesota US 2020-04-13 23:07:54     5 0 0 5 Unassigned, Minnesota, US
2456 2456 90028 Unassigned Mississippi US 2020-04-13 23:07:54     0 0 0 0 Unassigned, Mississippi, US
2457 2457 90029 Unassigned Missouri US 2020-04-13 23:07:54     0 0 0 0 Unassigned, Missouri, US
2458 2458 90030 Unassigned Montana US 2020-04-13 23:07:54     0 0 0 0 Unassigned, Montana, US
2459 2459 90031 Unassigned Nebraska US 2020-04-13 23:07:54     23 2 0 21 Unassigned, Nebraska, US
2460 2460 90032 Unassigned Nevada US 2020-04-13 23:07:54     0 0 0 0 Unassigned, Nevada, US
2461 2461 90033 Unassigned New Hampshire US 2020-04-13 23:07:54     1 20 0 -19 Unassigned, New Hampshire, US
2462 2462 90034 Unassigned New Jersey US 2020-04-13 23:07:54     1203 2 0 1201 Unassigned, New Jersey, US
2463 2463 90035 Unassigned New Mexico US 2020-04-13 23:07:54     0 0 0 0 Unassigned, New Mexico, US
2464 2464 90036 Unassigned New York US 2020-04-13 23:07:54     0 0 0 0 Unassigned, New York, US
2465 2465 90039 Unassigned Ohio US 2020-04-13 23:07:54     0 0 0 0 Unassigned, Ohio, US
2466 2466 90040 Unassigned Oklahoma US 2020-04-13 23:07:54     0 0 0 0 Unassigned, Oklahoma, US
2467 2467 90041 Unassigned Oregon US 2020-04-13 23:07:54     0 0 0 0 Unassigned, Oregon, US
2468 2468 90042 Unassigned Pennsylvania US 2020-04-13 23:07:54     0 0 0 0 Unassigned, Pennsylvania, US
2469 2469 90044 Unassigned Rhode Island US 2020-04-13 23:07:54     965 37 0 905 Unassigned, Rhode Island, US
2470 2470 90046 Unassigned South Dakota US 2020-04-13 23:07:54     0 0 0 0 Unassigned, South Dakota, US
2471 2471 90047 Unassigned Tennessee US 2020-04-13 23:07:54     46 0 0 46 Unassigned, Tennessee, US
2472 2472 90050 Unassigned Vermont US 2020-04-13 23:07:54     8 0 0 8 Unassigned, Vermont, US
2473 2473 90051 Unassigned Virginia US 2020-04-13 23:07:54     0 70 0 -70 Unassigned, Virginia, US
2474 2474 90053 Unassigned Washington US 2020-04-13 23:07:54     619 0 0 619 Unassigned, Washington, US
2475 2475 90054 Unassigned West Virginia US 2020-04-13 23:07:54     0 2 0 -2 Unassigned, West Virginia, US
2476 2476 90055 Unassigned Wisconsin US 2020-04-13 23:07:54     0 0 0 0 Unassigned, Wisconsin, US
2477 2477   Unassigned Wyoming US 2020-04-13 23:07:54     0 0 0 0 Unassigned, Wyoming, US
2747 2747 88888   Diamond Princess US 2020-04-13 23:07:54     49 0 0 49 Diamond Princess, US
2755 2755     Grand Princess Canada 2020-04-13 23:15:25     13 0 0 13 Grand Princess, Canada
2756 2756 99999   Grand Princess US 2020-04-13 23:07:54     103 0 0 103 Grand Princess, US
2797 2797     Recovered Canada 2020-04-13 23:15:25     0 0 7758 -7758 Recovered, Canada
2798 2798     Recovered US 2020-04-13 23:07:54     0 0 43482 -43482 Recovered, US
2867 2867       Diamond Princess 2020-04-13 23:07:34     712 11 619 82 Diamond Princess
2922 2922       MS Zaandam 2020-04-13 23:07:34     9 2 0 7 MS Zaandam
2963 2963       Samoa 2020-04-13 23:15:25 -13.759 -172.1046 0 0 0 0 Samoa
173 173 2050 Bethel Alaska US 2020-04-13 23:07:54 60.90980451 -159.8561831 1 0 0 1 Bethel, Alaska, US
1251 1251 15007 Kauai Hawaii US 2020-04-13 23:07:54 22.03935037 -159.5966786 21 0 0 21 Kauai, Hawaii, US
1089 1089 15003 Honolulu Hawaii US 2020-04-13 23:07:54 21.45803166 -157.97121819999995 352 6 0 346 Honolulu, Hawaii, US
1568 1568 15009 Maui Hawaii US 2020-04-13 23:07:54 20.86399628 -156.56890969999995 86 3 0 83 Maui, Hawaii, US
1041 1041 15001 Hawaii Hawaii US 2020-04-13 23:07:54 19.60121157 -155.5210167 40 0 0 40 Hawaii, Hawaii, US
1257 1257 2122 Kenai Peninsula Alaska US 2020-04-13 23:07:54 60.24429722 -151.53888840000005 15 0 0 15 Kenai Peninsula, Alaska, US
2729 2729 2290 Yukon-Koyukuk Alaska US 2020-04-13 23:07:54 65.50815459 -151.39073869999999 1 0 0 1 Yukon-Koyukuk, Alaska, US
1566 1566 2170 Matanuska-Susitna Alaska US 2020-04-13 23:07:54 62.31305045 -149.5741743 14 0 0 14 Matanuska-Susitna, Alaska, US
2751 2751     French Polynesia France 2020-04-13 23:07:34 -17.6797 -149.4068 55 0 0 55 French Polynesia, France
50 50 2020 Anchorage Alaska US 2020-04-13 23:07:54 61.14998174 -149.14269860000005 131 4 0 127 Anchorage, Alaska, US
768 768 2090 Fairbanks North Star Alaska US 2020-04-13 23:07:54 64.80726247 -146.5692662 79 1 0 78 Fairbanks North Star, Alaska, US
2250 2250 2240 Southeast Fairbanks Alaska US 2020-04-13 23:07:54 63.87692095 -143.2127643 1 0 0 1 Southeast Fairbanks, Alaska, US
2820 2820     Yukon Canada 2020-04-13 23:15:25 64.2823 -135.0 8 0 0 8 Yukon, Canada
1239 1239 2110 Juneau Alaska US 2020-04-13 23:07:54 58.45031811 -134.200436 17 0 0 17 Juneau, Alaska, US
2010 2010 2198 Prince of Wales-Hyder Alaska US 2020-04-13 23:07:54 55.76261984 -133.0511621 1 0 0 1 Prince of Wales-Hyder, Alaska, US
1920 1920 2195 Petersburg Alaska US 2020-04-13 23:07:54 57.13978948 -132.9540995 2 0 0 2 Petersburg, Alaska, US
1271 1271 2130 Ketchikan Gateway Alaska US 2020-04-13 23:07:54 55.57445008 -130.975561 15 0 0 15 Ketchikan Gateway, Alaska, US
2741 2741     British Columbia Canada 2020-04-13 23:15:25 53.7267 -127.6476 1490 69 0 1421 British Columbia, Canada
2788 2788     Northwest Territories Canada 2020-04-13 23:15:25 64.8255 -124.8457 5 0 0 5 Northwest Territories, Canada
606 606 41015 Curry Oregon US 2020-04-13 23:07:54 42.45911325 -124.15728200000001 3 0 0 3 Curry, Oregon, US
549 549 41011 Coos Oregon US 2020-04-13 23:07:54 43.17406868 -124.0594514 1 0 0 1 Coos, Oregon, US
446 446 53009 Clallam Washington US 2020-04-13 23:07:54 48.04754642 -123.92263190000001 12 0 0 12 Clallam, Washington, US
656 656 6015 Del Norte California US 2020-04-13 23:07:54 41.74228275 -123.89740630000001 2 0 0 2 Del Norte, California, US
1113 1113 6023 Humboldt California US 2020-04-13 23:07:54 40.69923009 -123.876044 50 0 0 50 Humboldt, California, US
1424 1424 41041 Lincoln Oregon US 2020-04-13 23:07:54 44.64252874 -123.86991200000001 4 0 0 4 Lincoln, Oregon, US
939 939 53027 Grays Harbor Washington US 2020-04-13 23:07:54 47.14003705 -123.7820567 11 0 0 11 Grays Harbor, Washington, US
1874 1874 53049 Pacific Washington US 2020-04-13 23:07:54 46.55418369 -123.7285716 1 0 0 1 Pacific, Washington, US
2385 2385 41057 Tillamook Oregon US 2020-04-13 23:07:54 45.46248721 -123.712066 4 0 0 4 Tillamook, Oregon, US
465 465 41007 Clatsop Oregon US 2020-04-13 23:07:54 45.99712889 -123.660711 6 0 0 6 Clatsop, Oregon, US
1206 1206 53031 Jefferson Washington US 2020-04-13 23:07:54 47.75003077 -123.56097040000002 28 0 0 28 Jefferson, Washington, US
1238 1238 41033 Josephine Oregon US 2020-04-13 23:07:54 42.3665549 -123.5561938 19 1 0 18 Josephine, Oregon, US
160 160 41003 Benton Oregon US 2020-04-13 23:07:54 44.49167306 -123.4316987 23 2 0 21 Benton, Oregon, US
2528 2528 53069 Wahkiakum Washington US 2020-04-13 23:07:54 46.29180039999999 -123.4250831 2 0 0 2 Wahkiakum, Washington, US
1977 1977 41053 Polk Oregon US 2020-04-13 23:07:54 44.90322804 -123.4128888 30 1 0 29 Polk, Oregon, US
1612 1612 6045 Mendocino California US 2020-04-13 23:07:54 39.4381191 -123.39113130000001 4 0 0 4 Mendocino, California, US
2713 2713 41071 Yamhill Oregon US 2020-04-13 23:07:54 45.23330449 -123.3086963 30 6 0 24 Yamhill, Oregon, US
1562 1562 53045 Mason Washington US 2020-04-13 23:07:54 47.35007586 -123.1863685 19 0 0 19 Mason, Washington, US
703 703 41019 Douglas Oregon US 2020-04-13 23:07:54 43.27941273 -123.16729099999999 16 0 0 16 Douglas, Oregon, US
2587 2587 41067 Washington Oregon US 2020-04-13 23:07:54 45.55972701 -123.0955257 360 7 0 353 Washington, Oregon, US
528 528 41009 Columbia Oregon US 2020-04-13 23:07:54 45.94464254 -123.08908980000001 12 0 0 12 Columbia, Oregon, US
2145 2145 53055 San Juan Washington US 2020-04-13 23:07:54 48.60182783 -122.96745 13 0 0 13 San Juan, Washington, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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