04-17-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,047 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
803 803   Federal Correctional Institution (FCI) Michigan US 2020-04-17 23:30:52     44 0 0 44 Federal Correctional Institution (FCI), Michigan, US
1651 1651   Michigan Department of Corrections (MDOC) Michigan US 2020-04-17 23:30:52     514 15 0 499 Michigan Department of Corrections (MDOC), Michigan, US
1891 1891 80013 Out of GA Georgia US 2020-04-17 23:30:52     780 7 0 773 Out of GA, Georgia, US
1892 1892 80015 Out of HI Hawaii US 2020-04-17 23:30:52     6 0 0 6 Out of HI, Hawaii, US
1893 1893 80026 Out of MI Michigan US 2020-04-17 23:30:52     71 2 0 69 Out of MI, Michigan, US
1894 1894 80040 Out of OK Oklahoma US 2020-04-17 23:30:52     0 0 0 0 Out of OK, Oklahoma, US
1895 1895 80047 Out of TN Tennessee US 2020-04-17 23:30:52     250 1 0 249 Out of TN, Tennessee, US
2472 2472 90001 Unassigned Alabama US 2020-04-17 23:30:52     0 0 0 0 Unassigned, Alabama, US
2473 2473 90002 Unassigned Alaska US 2020-04-17 23:30:52     0 4 0 -4 Unassigned, Alaska, US
2474 2474 90004 Unassigned Arizona US 2020-04-17 23:30:52     0 42 0 -42 Unassigned, Arizona, US
2475 2475 90005 Unassigned Arkansas US 2020-04-17 23:30:52     43 0 0 43 Unassigned, Arkansas, US
2476 2476 90006 Unassigned California US 2020-04-17 23:30:52     0 0 0 0 Unassigned, California, US
2477 2477 90008 Unassigned Colorado US 2020-04-17 23:30:52     96 1 0 95 Unassigned, Colorado, US
2478 2478 90009 Unassigned Connecticut US 2020-04-17 23:30:52     495 2 0 493 Unassigned, Connecticut, US
2479 2479 90010 Unassigned Delaware US 2020-04-17 23:30:52     22 0 0 22 Unassigned, Delaware, US
2480 2480 90012 Unassigned Florida US 2020-04-17 23:30:52     4 0 0 4 Unassigned, Florida, US
2481 2481 90013 Unassigned Georgia US 2020-04-17 23:30:52     255 0 0 255 Unassigned, Georgia, US
2482 2482 90015 Unassigned Hawaii US 2020-04-17 23:30:52     5 0 0 5 Unassigned, Hawaii, US
2483 2483 90016 Unassigned Idaho US 2020-04-17 23:30:52     0 0 0 0 Unassigned, Idaho, US
2484 2484 90017 Unassigned Illinois US 2020-04-17 23:30:52     74 1 0 73 Unassigned, Illinois, US
2485 2485 90018 Unassigned Indiana US 2020-04-17 23:30:52     0 115 0 0 Unassigned, Indiana, US
2486 2486 90019 Unassigned Iowa US 2020-04-17 23:30:52     1 0 0 1 Unassigned, Iowa, US
2487 2487 90020 Unassigned Kansas US 2020-04-17 23:30:52     0 2 0 0 Unassigned, Kansas, US
2488 2488 90021 Unassigned Kentucky US 2020-04-17 23:30:52     87 1 0 86 Unassigned, Kentucky, US
2489 2489 90022 Unassigned Louisiana US 2020-04-17 23:30:52     56 1 0 55 Unassigned, Louisiana, US
2490 2490 90023 Unassigned Maine US 2020-04-17 23:30:52     1 0 0 1 Unassigned, Maine, US
2491 2491 90025 Unassigned Massachusetts US 2020-04-17 23:30:52     760 16 0 744 Unassigned, Massachusetts, US
2492 2492 90026 Unassigned Michigan US 2020-04-17 23:30:52     46 4 0 42 Unassigned, Michigan, US
2493 2493 90027 Unassigned Minnesota US 2020-04-17 23:30:52     0 0 0 0 Unassigned, Minnesota, US
2494 2494 90028 Unassigned Mississippi US 2020-04-17 23:30:52     0 0 0 0 Unassigned, Mississippi, US
2495 2495 90029 Unassigned Missouri US 2020-04-17 23:30:52     0 0 0 0 Unassigned, Missouri, US
2496 2496 90030 Unassigned Montana US 2020-04-17 23:30:52     0 0 0 0 Unassigned, Montana, US
2497 2497 90031 Unassigned Nebraska US 2020-04-17 23:30:52     92 9 0 83 Unassigned, Nebraska, US
2498 2498 90032 Unassigned Nevada US 2020-04-17 23:30:52     98 1 0 97 Unassigned, Nevada, US
2499 2499 90033 Unassigned New Hampshire US 2020-04-17 23:30:52     2 34 0 -32 Unassigned, New Hampshire, US
2500 2500 90034 Unassigned New Jersey US 2020-04-17 23:30:52     719 3 0 716 Unassigned, New Jersey, US
2501 2501 90035 Unassigned New Mexico US 2020-04-17 23:30:52     0 0 0 0 Unassigned, New Mexico, US
2502 2502 90036 Unassigned New York US 2020-04-17 23:30:52     0 574 0 -574 Unassigned, New York, US
2503 2503 90039 Unassigned Ohio US 2020-04-17 23:30:52     0 0 0 0 Unassigned, Ohio, US
2504 2504 90040 Unassigned Oklahoma US 2020-04-17 23:30:52     108 5 0 103 Unassigned, Oklahoma, US
2505 2505 90041 Unassigned Oregon US 2020-04-17 23:30:52     0 0 0 0 Unassigned, Oregon, US
2506 2506 90042 Unassigned Pennsylvania US 2020-04-17 23:30:52     0 0 0 0 Unassigned, Pennsylvania, US
2507 2507 90044 Unassigned Rhode Island US 2020-04-17 23:30:52     790 97 0 675 Unassigned, Rhode Island, US
2508 2508 90046 Unassigned South Dakota US 2020-04-17 23:30:52     0 0 0 0 Unassigned, South Dakota, US
2509 2509 90047 Unassigned Tennessee US 2020-04-17 23:30:52     209 0 0 209 Unassigned, Tennessee, US
2510 2510 90049 Unassigned Utah US 2020-04-17 23:30:52     0 0 0 0 Unassigned, Utah, US
2511 2511 90050 Unassigned Vermont US 2020-04-17 23:30:52     10 0 0 10 Unassigned, Vermont, US
2512 2512 90051 Unassigned Virginia US 2020-04-17 23:30:52     0 67 0 -67 Unassigned, Virginia, US
2513 2513 90053 Unassigned Washington US 2020-04-17 23:30:52     334 0 0 334 Unassigned, Washington, US
2514 2514 90054 Unassigned West Virginia US 2020-04-17 23:30:52     0 9 0 -9 Unassigned, West Virginia, US
2515 2515 90055 Unassigned Wisconsin US 2020-04-17 23:30:52     0 0 0 0 Unassigned, Wisconsin, US
2516 2516 90056 Unassigned Wyoming US 2020-04-17 23:30:52     0 1 0 -1 Unassigned, Wyoming, US
2791 2791 88888   Diamond Princess US 2020-04-17 23:30:52     49 0 0 49 Diamond Princess, US
2799 2799     Grand Princess Canada 2020-04-17 23:38:31     13 0 0 13 Grand Princess, Canada
2800 2800 99999   Grand Princess US 2020-04-17 23:30:52     103 0 0 103 Grand Princess, US
2841 2841     Recovered Canada 2020-04-17 23:38:31     0 0 10545 -10545 Recovered, Canada
2842 2842     Recovered US 2020-04-17 23:30:52     0 0 58545 -58545 Recovered, US
2911 2911       Diamond Princess 2020-04-17 23:30:32     712 13 644 55 Diamond Princess
2966 2966       MS Zaandam 2020-04-17 23:30:32     9 2 0 7 MS Zaandam
3007 3007       Samoa 2020-04-17 23:38:31 -13.759 -172.1046 0 0 0 0 Samoa
1809 1809 2180 Nome Alaska US 2020-04-17 23:30:52 64.90320724 -164.0353804 1 0 0 1 Nome, Alaska, US
178 178 2050 Bethel Alaska US 2020-04-17 23:30:52 60.90980451 -159.8561831 1 0 0 1 Bethel, Alaska, US
1265 1265 15007 Kauai Hawaii US 2020-04-17 23:30:52 22.03935037 -159.5966786 21 0 0 21 Kauai, Hawaii, US
1101 1101 15003 Honolulu Hawaii US 2020-04-17 23:30:52 21.45803166 -157.97121819999995 373 6 0 367 Honolulu, Hawaii, US
1587 1587 15009 Maui Hawaii US 2020-04-17 23:30:52 20.86399628 -156.56890969999995 95 3 0 92 Maui, Hawaii, US
1051 1051 15001 Hawaii Hawaii US 2020-04-17 23:30:52 19.60121157 -155.5210167 41 0 0 41 Hawaii, Hawaii, US
1311 1311 2150 Kodiak Island Alaska US 2020-04-17 23:30:52 57.65529415 -153.7493579 1 0 0 1 Kodiak Island, Alaska, US
1271 1271 2122 Kenai Peninsula Alaska US 2020-04-17 23:30:52 60.24429722 -151.53888840000005 17 0 0 17 Kenai Peninsula, Alaska, US
2772 2772 2290 Yukon-Koyukuk Alaska US 2020-04-17 23:30:52 65.50815459 -151.39073869999999 1 0 0 1 Yukon-Koyukuk, Alaska, US
1585 1585 2170 Matanuska-Susitna Alaska US 2020-04-17 23:30:52 62.31305045 -149.5741743 15 0 0 15 Matanuska-Susitna, Alaska, US
2795 2795     French Polynesia France 2020-04-17 23:30:32 -17.6797 -149.4068 55 0 0 55 French Polynesia, France
53 53 2020 Anchorage Alaska US 2020-04-17 23:30:52 61.14998174 -149.14269860000005 150 4 0 146 Anchorage, Alaska, US
777 777 2090 Fairbanks North Star Alaska US 2020-04-17 23:30:52 64.80726247 -146.5692662 79 1 0 78 Fairbanks North Star, Alaska, US
2287 2287 2240 Southeast Fairbanks Alaska US 2020-04-17 23:30:52 63.87692095 -143.2127643 1 0 0 1 Southeast Fairbanks, Alaska, US
2864 2864     Yukon Canada 2020-04-17 23:38:31 64.2823 -135.0 8 0 0 8 Yukon, Canada
1254 1254 2110 Juneau Alaska US 2020-04-17 23:30:52 58.45031811 -134.200436 24 0 0 24 Juneau, Alaska, US
2040 2040 2198 Prince of Wales-Hyder Alaska US 2020-04-17 23:30:52 55.76261984 -133.0511621 2 0 0 2 Prince of Wales-Hyder, Alaska, US
1949 1949 2195 Petersburg Alaska US 2020-04-17 23:30:52 57.13978948 -132.9540995 2 0 0 2 Petersburg, Alaska, US
1285 1285 2130 Ketchikan Gateway Alaska US 2020-04-17 23:30:52 55.57445008 -130.975561 15 0 0 15 Ketchikan Gateway, Alaska, US
2785 2785     British Columbia Canada 2020-04-17 23:38:31 53.7267 -127.6476 1575 77 0 1498 British Columbia, Canada
2832 2832     Northwest Territories Canada 2020-04-17 23:38:31 64.8255 -124.8457 5 0 0 5 Northwest Territories, Canada
614 614 41015 Curry Oregon US 2020-04-17 23:30:52 42.45911325 -124.15728200000001 3 0 0 3 Curry, Oregon, US
557 557 41011 Coos Oregon US 2020-04-17 23:30:52 43.17406868 -124.0594514 1 0 0 1 Coos, Oregon, US
453 453 53009 Clallam Washington US 2020-04-17 23:30:52 48.04754642 -123.92263190000001 15 0 0 15 Clallam, Washington, US
665 665 6015 Del Norte California US 2020-04-17 23:30:52 41.74228275 -123.89740630000001 2 0 0 2 Del Norte, California, US
1126 1126 6023 Humboldt California US 2020-04-17 23:30:52 40.69923009 -123.876044 52 0 0 52 Humboldt, California, US
1440 1440 41041 Lincoln Oregon US 2020-04-17 23:30:52 44.64252874 -123.86991200000001 4 0 0 4 Lincoln, Oregon, US
948 948 53027 Grays Harbor Washington US 2020-04-17 23:30:52 47.14003705 -123.7820567 12 0 0 12 Grays Harbor, Washington, US
1903 1903 53049 Pacific Washington US 2020-04-17 23:30:52 46.55418369 -123.7285716 1 0 0 1 Pacific, Washington, US
2422 2422 41057 Tillamook Oregon US 2020-04-17 23:30:52 45.46248721 -123.712066 6 0 0 6 Tillamook, Oregon, US
472 472 41007 Clatsop Oregon US 2020-04-17 23:30:52 45.99712889 -123.660711 6 0 0 6 Clatsop, Oregon, US
1220 1220 53031 Jefferson Washington US 2020-04-17 23:30:52 47.75003077 -123.56097040000002 28 0 0 28 Jefferson, Washington, US
1253 1253 41033 Josephine Oregon US 2020-04-17 23:30:52 42.3665549 -123.5561938 19 1 0 18 Josephine, Oregon, US
165 165 41003 Benton Oregon US 2020-04-17 23:30:52 44.49167306 -123.4316987 27 4 0 23 Benton, Oregon, US
2568 2568 53069 Wahkiakum Washington US 2020-04-17 23:30:52 46.29180039999999 -123.4250831 2 0 0 2 Wahkiakum, Washington, US
2006 2006 41053 Polk Oregon US 2020-04-17 23:30:52 44.90322804 -123.4128888 31 1 0 30 Polk, Oregon, US
1631 1631 6045 Mendocino California US 2020-04-17 23:30:52 39.4381191 -123.39113130000001 4 0 0 4 Mendocino, California, US
2756 2756 41071 Yamhill Oregon US 2020-04-17 23:30:52 45.23330449 -123.3086963 35 6 0 29 Yamhill, Oregon, US
1581 1581 53045 Mason Washington US 2020-04-17 23:30:52 47.35007586 -123.1863685 21 0 0 21 Mason, Washington, US
713 713 41019 Douglas Oregon US 2020-04-17 23:30:52 43.27941273 -123.16729099999999 22 0 0 22 Douglas, Oregon, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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