04-15-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,028 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
801 801   Federal Correctional Institution (FCI) Michigan US 2020-04-15 22:56:51     36 0 0 36 Federal Correctional Institution (FCI), Michigan, US
1600 1600   McIntosh Georgia US 2020-04-15 22:56:51     3 0 0 3 McIntosh, Georgia, US
1646 1646   Michigan Department of Corrections (MDOC) Michigan US 2020-04-15 22:56:51     472 12 0 460 Michigan Department of Corrections (MDOC), Michigan, US
1881 1881 80013 Out of GA Georgia US 2020-04-15 22:56:51     683 0 0 683 Out of GA, Georgia, US
1882 1882   Out of MI Michigan US 2020-04-15 22:56:51     166 2 0 164 Out of MI, Michigan, US
1883 1883 80040 Out of OK Oklahoma US 2020-04-15 22:56:51     0 0 0 0 Out of OK, Oklahoma, US
1884 1884   Out of TN Tennessee US 2020-04-15 22:56:51     260 1 0 259 Out of TN, Tennessee, US
2457 2457 90002 Unassigned Alaska US 2020-04-15 22:56:51     0 4 0 -4 Unassigned, Alaska, US
2458 2458 90004 Unassigned Arizona US 2020-04-15 22:56:51     0 27 0 -27 Unassigned, Arizona, US
2459 2459 90005 Unassigned Arkansas US 2020-04-15 22:56:51     48 0 0 48 Unassigned, Arkansas, US
2460 2460 90006 Unassigned California US 2020-04-15 22:56:51     0 0 0 0 Unassigned, California, US
2461 2461 90008 Unassigned Colorado US 2020-04-15 22:56:51     119 0 0 119 Unassigned, Colorado, US
2462 2462 90009 Unassigned Connecticut US 2020-04-15 22:56:51     537 2 0 535 Unassigned, Connecticut, US
2463 2463 90010 Unassigned Delaware US 2020-04-15 22:56:51     17 9 0 14 Unassigned, Delaware, US
2464 2464 90012 Unassigned Florida US 2020-04-15 22:56:51     5 0 0 5 Unassigned, Florida, US
2465 2465 90013 Unassigned Georgia US 2020-04-15 22:56:51     263 7 0 256 Unassigned, Georgia, US
2466 2466 90015 Unassigned Hawaii US 2020-04-15 22:56:51     1 0 0 1 Unassigned, Hawaii, US
2467 2467 90016 Unassigned Idaho US 2020-04-15 22:56:51     0 0 0 0 Unassigned, Idaho, US
2468 2468 90017 Unassigned Illinois US 2020-04-15 22:56:51     45 1 0 44 Unassigned, Illinois, US
2469 2469 90018 Unassigned Indiana US 2020-04-15 22:56:51     0 131 0 0 Unassigned, Indiana, US
2470 2470 90019 Unassigned Iowa US 2020-04-15 22:56:51     0 0 0 0 Unassigned, Iowa, US
2471 2471 90020 Unassigned Kansas US 2020-04-15 22:56:51     0 2 0 0 Unassigned, Kansas, US
2472 2472 90021 Unassigned Kentucky US 2020-04-15 22:56:51     78 9 0 69 Unassigned, Kentucky, US
2473 2473 90022 Unassigned Louisiana US 2020-04-15 22:56:51     56 1 0 55 Unassigned, Louisiana, US
2474 2474 90023 Unassigned Maine US 2020-04-15 22:56:51     2 0 0 2 Unassigned, Maine, US
2475 2475 90025 Unassigned Massachusetts US 2020-04-15 22:56:51     572 14 0 558 Unassigned, Massachusetts, US
2476 2476 90026 Unassigned Michigan US 2020-04-15 22:56:51     76 5 0 71 Unassigned, Michigan, US
2477 2477 90027 Unassigned Minnesota US 2020-04-15 22:56:51     2 0 0 2 Unassigned, Minnesota, US
2478 2478 90028 Unassigned Mississippi US 2020-04-15 22:56:51     0 0 0 0 Unassigned, Mississippi, US
2479 2479 90029 Unassigned Missouri US 2020-04-15 22:56:51     0 0 0 0 Unassigned, Missouri, US
2480 2480 90030 Unassigned Montana US 2020-04-15 22:56:51     0 0 0 0 Unassigned, Montana, US
2481 2481 90031 Unassigned Nebraska US 2020-04-15 22:56:51     19 5 0 14 Unassigned, Nebraska, US
2482 2482 90032 Unassigned Nevada US 2020-04-15 22:56:51     5 0 0 5 Unassigned, Nevada, US
2483 2483 90033 Unassigned New Hampshire US 2020-04-15 22:56:51     0 29 0 -29 Unassigned, New Hampshire, US
2484 2484 90034 Unassigned New Jersey US 2020-04-15 22:56:51     1189 2 0 1187 Unassigned, New Jersey, US
2485 2485 90035 Unassigned New Mexico US 2020-04-15 22:56:51     0 0 0 0 Unassigned, New Mexico, US
2486 2486 90036 Unassigned New York US 2020-04-15 22:56:51     0 0 0 0 Unassigned, New York, US
2487 2487 90039 Unassigned Ohio US 2020-04-15 22:56:51     0 0 0 0 Unassigned, Ohio, US
2488 2488 90040 Unassigned Oklahoma US 2020-04-15 22:56:51     0 0 0 0 Unassigned, Oklahoma, US
2489 2489 90041 Unassigned Oregon US 2020-04-15 22:56:51     0 0 0 0 Unassigned, Oregon, US
2490 2490 90042 Unassigned Pennsylvania US 2020-04-15 22:56:51     0 0 0 0 Unassigned, Pennsylvania, US
2491 2491 90044 Unassigned Rhode Island US 2020-04-15 22:56:51     756 62 0 679 Unassigned, Rhode Island, US
2492 2492 90046 Unassigned South Dakota US 2020-04-15 22:56:51     0 0 0 0 Unassigned, South Dakota, US
2493 2493 90047 Unassigned Tennessee US 2020-04-15 22:56:51     136 0 0 136 Unassigned, Tennessee, US
2494 2494 90049 Unassigned Utah US 2020-04-15 22:56:51     0 7 0 -7 Unassigned, Utah, US
2495 2495 90050 Unassigned Vermont US 2020-04-15 22:56:51     15 0 0 15 Unassigned, Vermont, US
2496 2496 90051 Unassigned Virginia US 2020-04-15 22:56:51     0 101 0 -101 Unassigned, Virginia, US
2497 2497 90053 Unassigned Washington US 2020-04-15 22:56:51     383 0 0 383 Unassigned, Washington, US
2498 2498 90054 Unassigned West Virginia US 2020-04-15 22:56:51     0 4 0 -4 Unassigned, West Virginia, US
2499 2499 90055 Unassigned Wisconsin US 2020-04-15 22:56:51     1 0 0 1 Unassigned, Wisconsin, US
2500 2500   Unassigned Wyoming US 2020-04-15 22:56:51     0 0 0 0 Unassigned, Wyoming, US
2772 2772 88888   Diamond Princess US 2020-04-15 22:56:51     49 0 0 49 Diamond Princess, US
2780 2780     Grand Princess Canada 2020-04-15 23:04:09     13 0 0 13 Grand Princess, Canada
2781 2781 99999   Grand Princess US 2020-04-15 22:56:51     103 0 0 103 Grand Princess, US
2822 2822     Recovered Canada 2020-04-15 23:04:09     0 0 8966 -8966 Recovered, Canada
2823 2823     Recovered US 2020-04-15 22:56:51     0 0 52096 -52096 Recovered, US
2892 2892       Diamond Princess 2020-04-15 22:56:32     712 12 639 61 Diamond Princess
2947 2947       MS Zaandam 2020-04-15 22:56:32     9 2 0 7 MS Zaandam
2988 2988       Samoa 2020-04-15 23:04:09 -13.759 -172.1046 0 0 0 0 Samoa
1799 1799 2180 Nome Alaska US 2020-04-15 22:56:51 64.90320724 -164.0353804 1 0 0 1 Nome, Alaska, US
175 175 2050 Bethel Alaska US 2020-04-15 22:56:51 60.90980451 -159.8561831 1 0 0 1 Bethel, Alaska, US
1263 1263 15007 Kauai Hawaii US 2020-04-15 22:56:51 22.03935037 -159.5966786 21 0 0 21 Kauai, Hawaii, US
1098 1098 15003 Honolulu Hawaii US 2020-04-15 22:56:51 21.45803166 -157.97121819999995 369 6 0 363 Honolulu, Hawaii, US
1582 1582 15009 Maui Hawaii US 2020-04-15 22:56:51 20.86399628 -156.56890969999995 92 3 0 89 Maui, Hawaii, US
1050 1050 15001 Hawaii Hawaii US 2020-04-15 22:56:51 19.60121157 -155.5210167 41 0 0 41 Hawaii, Hawaii, US
1269 1269 2122 Kenai Peninsula Alaska US 2020-04-15 22:56:51 60.24429722 -151.53888840000005 16 0 0 16 Kenai Peninsula, Alaska, US
2754 2754 2290 Yukon-Koyukuk Alaska US 2020-04-15 22:56:51 65.50815459 -151.39073869999999 1 0 0 1 Yukon-Koyukuk, Alaska, US
1580 1580 2170 Matanuska-Susitna Alaska US 2020-04-15 22:56:51 62.31305045 -149.5741743 15 0 0 15 Matanuska-Susitna, Alaska, US
2776 2776     French Polynesia France 2020-04-15 22:56:32 -17.6797 -149.4068 55 0 0 55 French Polynesia, France
51 51 2020 Anchorage Alaska US 2020-04-15 22:56:51 61.14998174 -149.14269860000005 139 4 0 135 Anchorage, Alaska, US
775 775 2090 Fairbanks North Star Alaska US 2020-04-15 22:56:51 64.80726247 -146.5692662 79 1 0 78 Fairbanks North Star, Alaska, US
2271 2271 2240 Southeast Fairbanks Alaska US 2020-04-15 22:56:51 63.87692095 -143.2127643 1 0 0 1 Southeast Fairbanks, Alaska, US
2845 2845     Yukon Canada 2020-04-15 23:04:09 64.2823 -135.0 8 0 0 8 Yukon, Canada
1251 1251 2110 Juneau Alaska US 2020-04-15 22:56:51 58.45031811 -134.200436 21 0 0 21 Juneau, Alaska, US
2029 2029 2198 Prince of Wales-Hyder Alaska US 2020-04-15 22:56:51 55.76261984 -133.0511621 2 0 0 2 Prince of Wales-Hyder, Alaska, US
1938 1938 2195 Petersburg Alaska US 2020-04-15 22:56:51 57.13978948 -132.9540995 2 0 0 2 Petersburg, Alaska, US
1283 1283 2130 Ketchikan Gateway Alaska US 2020-04-15 22:56:51 55.57445008 -130.975561 15 0 0 15 Ketchikan Gateway, Alaska, US
2766 2766     British Columbia Canada 2020-04-15 23:04:09 53.7267 -127.6476 1517 72 0 1445 British Columbia, Canada
2813 2813     Northwest Territories Canada 2020-04-15 23:04:09 64.8255 -124.8457 5 0 0 5 Northwest Territories, Canada
611 611 41015 Curry Oregon US 2020-04-15 22:56:51 42.45911325 -124.15728200000001 3 0 0 3 Curry, Oregon, US
554 554 41011 Coos Oregon US 2020-04-15 22:56:51 43.17406868 -124.0594514 1 0 0 1 Coos, Oregon, US
450 450 53009 Clallam Washington US 2020-04-15 22:56:51 48.04754642 -123.92263190000001 14 0 0 14 Clallam, Washington, US
661 661 6015 Del Norte California US 2020-04-15 22:56:51 41.74228275 -123.89740630000001 2 0 0 2 Del Norte, California, US
1122 1122 6023 Humboldt California US 2020-04-15 22:56:51 40.69923009 -123.876044 51 0 0 51 Humboldt, California, US
1436 1436 41041 Lincoln Oregon US 2020-04-15 22:56:51 44.64252874 -123.86991200000001 4 0 0 4 Lincoln, Oregon, US
948 948 53027 Grays Harbor Washington US 2020-04-15 22:56:51 47.14003705 -123.7820567 12 0 0 12 Grays Harbor, Washington, US
1892 1892 53049 Pacific Washington US 2020-04-15 22:56:51 46.55418369 -123.7285716 1 0 0 1 Pacific, Washington, US
2406 2406 41057 Tillamook Oregon US 2020-04-15 22:56:51 45.46248721 -123.712066 5 0 0 5 Tillamook, Oregon, US
469 469 41007 Clatsop Oregon US 2020-04-15 22:56:51 45.99712889 -123.660711 6 0 0 6 Clatsop, Oregon, US
1217 1217 53031 Jefferson Washington US 2020-04-15 22:56:51 47.75003077 -123.56097040000002 28 0 0 28 Jefferson, Washington, US
1250 1250 41033 Josephine Oregon US 2020-04-15 22:56:51 42.3665549 -123.5561938 19 1 0 18 Josephine, Oregon, US
162 162 41003 Benton Oregon US 2020-04-15 22:56:51 44.49167306 -123.4316987 25 3 0 22 Benton, Oregon, US
2552 2552 53069 Wahkiakum Washington US 2020-04-15 22:56:51 46.29180039999999 -123.4250831 2 0 0 2 Wahkiakum, Washington, US
1995 1995 41053 Polk Oregon US 2020-04-15 22:56:51 44.90322804 -123.4128888 30 1 0 29 Polk, Oregon, US
1626 1626 6045 Mendocino California US 2020-04-15 22:56:51 39.4381191 -123.39113130000001 4 0 0 4 Mendocino, California, US
2738 2738 41071 Yamhill Oregon US 2020-04-15 22:56:51 45.23330449 -123.3086963 32 6 0 26 Yamhill, Oregon, US
1576 1576 53045 Mason Washington US 2020-04-15 22:56:51 47.35007586 -123.1863685 19 0 0 19 Mason, Washington, US
709 709 41019 Douglas Oregon US 2020-04-15 22:56:51 43.27941273 -123.16729099999999 20 0 0 20 Douglas, Oregon, US
2611 2611 41067 Washington Oregon US 2020-04-15 22:56:51 45.55972701 -123.0955257 364 7 0 357 Washington, Oregon, US
533 533 41009 Columbia Oregon US 2020-04-15 22:56:51 45.94464254 -123.08908980000001 14 0 0 14 Columbia, Oregon, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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