04-26-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,142 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
826 826   Federal Correctional Institution (FCI) Michigan US 2020-04-27 02:30:52     81 1 0 80 Federal Correctional Institution (FCI), Michigan, US
1708 1708   Michigan Department of Corrections (MDOC) Michigan US 2020-04-27 02:30:52     1031 32 0 999 Michigan Department of Corrections (MDOC), Michigan, US
1956 1956 80008 Out of CO Colorado US 2020-04-27 02:30:52     0 2 0 -2 Out of CO, Colorado, US
1957 1957 80013 Out of GA Georgia US 2020-04-27 02:30:52     1022 9 0 1013 Out of GA, Georgia, US
1958 1958 80015 Out of HI Hawaii US 2020-04-27 02:30:52     7 0 0 7 Out of HI, Hawaii, US
1959 1959 80026 Out of MI Michigan US 2020-04-27 02:30:52     27 1 0 26 Out of MI, Michigan, US
1960 1960 80040 Out of OK Oklahoma US 2020-04-27 02:30:52     0 0 0 0 Out of OK, Oklahoma, US
1961 1961 80047 Out of TN Tennessee US 2020-04-27 02:30:52     332 2 0 330 Out of TN, Tennessee, US
2366 2366 90049 Southwest Utah US 2020-04-27 02:30:52     0 0 0 0 Southwest, Utah, US
2556 2556 90001 Unassigned Alabama US 2020-04-27 02:30:52     0 0 0 0 Unassigned, Alabama, US
2557 2557 90002 Unassigned Alaska US 2020-04-27 02:30:52     0 4 0 -4 Unassigned, Alaska, US
2558 2558 90004 Unassigned Arizona US 2020-04-27 02:30:52     0 0 0 0 Unassigned, Arizona, US
2559 2559 90005 Unassigned Arkansas US 2020-04-27 02:30:52     216 0 0 216 Unassigned, Arkansas, US
2560 2560 90006 Unassigned California US 2020-04-27 02:30:52     0 2 0 -2 Unassigned, California, US
2561 2561 90008 Unassigned Colorado US 2020-04-27 02:30:52     172 2 0 170 Unassigned, Colorado, US
2562 2562 90009 Unassigned Connecticut US 2020-04-27 02:30:52     522 0 0 522 Unassigned, Connecticut, US
2563 2563 90010 Unassigned Delaware US 2020-04-27 02:30:52     9 0 0 9 Unassigned, Delaware, US
2564 2564 90012 Unassigned Florida US 2020-04-27 02:30:52     1 0 0 1 Unassigned, Florida, US
2565 2565 90013 Unassigned Georgia US 2020-04-27 02:30:52     622 0 0 622 Unassigned, Georgia, US
2566 2566 90015 Unassigned Hawaii US 2020-04-27 02:30:52     0 0 0 0 Unassigned, Hawaii, US
2567 2567 90016 Unassigned Idaho US 2020-04-27 02:30:52     0 0 0 0 Unassigned, Idaho, US
2568 2568 90017 Unassigned Illinois US 2020-04-27 02:30:52     307 0 0 307 Unassigned, Illinois, US
2569 2569 90018 Unassigned Indiana US 2020-04-27 02:30:52     0 180 0 0 Unassigned, Indiana, US
2570 2570 90019 Unassigned Iowa US 2020-04-27 02:30:52     6 0 0 6 Unassigned, Iowa, US
2571 2571 90020 Unassigned Kansas US 2020-04-27 02:30:52     0 0 0 0 Unassigned, Kansas, US
2572 2572 90021 Unassigned Kentucky US 2020-04-27 02:30:52     58 0 0 58 Unassigned, Kentucky, US
2573 2573 90022 Unassigned Louisiana US 2020-04-27 02:30:52     64 59 0 5 Unassigned, Louisiana, US
2574 2574 90023 Unassigned Maine US 2020-04-27 02:30:52     2 0 0 2 Unassigned, Maine, US
2575 2575 90024 Unassigned Maryland US 2020-04-27 02:31:05     0 145 0 -145 Unassigned, Maryland, US
2576 2576 90025 Unassigned Massachusetts US 2020-04-27 02:30:52     807 141 0 666 Unassigned, Massachusetts, US
2577 2577 90026 Unassigned Michigan US 2020-04-27 02:30:52     3 1 0 2 Unassigned, Michigan, US
2578 2578 90027 Unassigned Minnesota US 2020-04-27 02:30:52     9 0 0 9 Unassigned, Minnesota, US
2579 2579 90028 Unassigned Mississippi US 2020-04-27 02:30:52     0 0 0 0 Unassigned, Mississippi, US
2580 2580 90029 Unassigned Missouri US 2020-04-27 02:30:52     1 0 0 1 Unassigned, Missouri, US
2581 2581 90030 Unassigned Montana US 2020-04-27 02:30:52     0 0 0 0 Unassigned, Montana, US
2582 2582 90031 Unassigned Nebraska US 2020-04-27 02:30:52     10 18 0 -8 Unassigned, Nebraska, US
2583 2583 90032 Unassigned Nevada US 2020-04-27 02:30:52     95 1 0 94 Unassigned, Nevada, US
2584 2584 90033 Unassigned New Hampshire US 2020-04-27 02:30:52     5 57 0 -52 Unassigned, New Hampshire, US
2585 2585 90034 Unassigned New Jersey US 2020-04-27 02:30:52     681 0 0 681 Unassigned, New Jersey, US
2586 2586 90035 Unassigned New Mexico US 2020-04-27 02:30:52     0 0 0 0 Unassigned, New Mexico, US
2587 2587 90036 Unassigned New York US 2020-04-27 02:30:52     0 0 0 0 Unassigned, New York, US
2588 2588 90037 Unassigned North Carolina US 2020-04-27 02:30:52     1 0 0 1 Unassigned, North Carolina, US
2589 2589 90038 Unassigned North Dakota US 2020-04-27 02:30:52     0 0 0 0 Unassigned, North Dakota, US
2590 2590 90039 Unassigned Ohio US 2020-04-27 02:30:52     0 0 0 0 Unassigned, Ohio, US
2591 2591 90040 Unassigned Oklahoma US 2020-04-27 02:30:52     0 0 0 0 Unassigned, Oklahoma, US
2592 2592 90041 Unassigned Oregon US 2020-04-27 02:30:52     0 0 0 0 Unassigned, Oregon, US
2593 2593 90042 Unassigned Pennsylvania US 2020-04-27 02:30:52     0 0 0 0 Unassigned, Pennsylvania, US
2594 2594 90044 Unassigned Rhode Island US 2020-04-27 02:30:52     1109 78 0 883 Unassigned, Rhode Island, US
2595 2595 90045 Unassigned South Carolina US 2020-04-27 02:30:52     0 0 0 0 Unassigned, South Carolina, US
2596 2596 90046 Unassigned South Dakota US 2020-04-27 02:30:52     0 0 0 0 Unassigned, South Dakota, US
2597 2597 90047 Unassigned Tennessee US 2020-04-27 02:30:52     37 0 0 37 Unassigned, Tennessee, US
2598 2598 90048 Unassigned Texas US 2020-04-27 02:30:52     0 0 0 0 Unassigned, Texas, US
2599 2599 90049 Unassigned Utah US 2020-04-27 02:30:52     0 0 0 0 Unassigned, Utah, US
2600 2600 90050 Unassigned Vermont US 2020-04-27 02:30:52     5 0 0 5 Unassigned, Vermont, US
2601 2601 90051 Unassigned Virginia US 2020-04-27 02:30:52     0 0 0 0 Unassigned, Virginia, US
2602 2602 90053 Unassigned Washington US 2020-04-26 00:00:00     123 0 0 123 Unassigned, Washington, US
2603 2603 90054 Unassigned West Virginia US 2020-04-27 02:30:52     0 0 0 0 Unassigned, West Virginia, US
2604 2604 90055 Unassigned Wisconsin US 2020-04-27 02:30:52     0 0 0 0 Unassigned, Wisconsin, US
2605 2605 90056 Unassigned Wyoming US 2020-04-27 02:30:52     0 6 0 -6 Unassigned, Wyoming, US
2888 2888     Diamond Princess Canada 2020-04-27 02:30:55     0 1 0 0 Diamond Princess, Canada
2889 2889 88888   Diamond Princess US 2020-04-27 02:30:52     49 0 0 49 Diamond Princess, US
2897 2897 99999   Grand Princess US 2020-04-27 02:30:52     103 3 0 100 Grand Princess, US
2933 2933     Recovered Canada 2020-04-27 02:30:55     0 0 16883 -16883 Recovered, Canada
2934 2934     Recovered US 2020-04-27 02:30:52     0 0 106988 -106988 Recovered, US
2998 2998       Diamond Princess 2020-04-27 02:30:33     712 13 645 54 Diamond Princess
3053 3053       MS Zaandam 2020-04-27 02:30:33     9 2 0 7 MS Zaandam
3094 3094       Samoa 2020-04-27 02:30:33 -13.759 -172.1046 0 0 0 0 Samoa
1873 1873 2180 Nome Alaska US 2020-04-27 02:30:52 64.90320724 -164.0353804 1 0 0 1 Nome, Alaska, US
181 181 2050 Bethel Alaska US 2020-04-27 02:30:52 60.90980451 -159.8561831 1 0 0 1 Bethel, Alaska, US
1312 1312 15007 Kauai Hawaii US 2020-04-27 02:30:52 22.03935037 -159.5966786 21 0 0 21 Kauai, Hawaii, US
1143 1143 15003 Honolulu Hawaii US 2020-04-27 02:30:52 21.45803166 -157.97121819999995 396 9 0 387 Honolulu, Hawaii, US
1642 1642 15009 Maui Hawaii US 2020-04-27 02:30:52 20.86399628 -156.56890969999995 112 5 0 107 Maui, Hawaii, US
1092 1092 15001 Hawaii Hawaii US 2020-04-27 02:30:52 19.60121157 -155.5210167 70 0 0 70 Hawaii, Hawaii, US
1360 1360 2150 Kodiak Island Alaska US 2020-04-27 02:30:52 57.65529415 -153.7493579 1 0 0 1 Kodiak Island, Alaska, US
1318 1318 2122 Kenai Peninsula Alaska US 2020-04-27 02:30:52 60.24429722 -151.53888840000005 19 0 0 19 Kenai Peninsula, Alaska, US
2870 2870 2290 Yukon-Koyukuk Alaska US 2020-04-27 02:30:52 65.50815459 -151.3907387 1 0 0 1 Yukon-Koyukuk, Alaska, US
1640 1640 2170 Matanuska-Susitna Alaska US 2020-04-27 02:30:52 62.31305045 -149.5741743 20 0 0 20 Matanuska-Susitna, Alaska, US
2893 2893     French Polynesia France 2020-04-27 02:30:33 -17.6797 -149.4068 57 0 41 16 French Polynesia, France
53 53 2020 Anchorage Alaska US 2020-04-27 02:30:52 61.14998174 -149.14269860000005 168 4 0 164 Anchorage, Alaska, US
800 800 2090 Fairbanks North Star Alaska US 2020-04-27 02:30:52 64.80726247 -146.5692662 80 1 0 79 Fairbanks North Star, Alaska, US
2364 2364 2240 Southeast Fairbanks Alaska US 2020-04-27 02:30:52 63.87692095 -143.2127643 1 0 0 1 Southeast Fairbanks, Alaska, US
2951 2951     Yukon Canada 2020-04-27 02:30:55 64.2823 -135.0 11 0 0 11 Yukon, Canada
1301 1301 2110 Juneau Alaska US 2020-04-27 02:30:52 58.45031811 -134.200436 27 0 0 27 Juneau, Alaska, US
2111 2111 2198 Prince of Wales-Hyder Alaska US 2020-04-27 02:30:52 55.76261984 -133.0511621 2 0 0 2 Prince of Wales-Hyder, Alaska, US
2019 2019 2195 Petersburg Alaska US 2020-04-27 02:30:52 57.13978948 -132.9540995 3 0 0 3 Petersburg, Alaska, US
1332 1332 2130 Ketchikan Gateway Alaska US 2020-04-27 02:30:52 55.57445008 -130.975561 16 0 0 16 Ketchikan Gateway, Alaska, US
2882 2882     British Columbia Canada 2020-04-27 02:30:55 53.7267 -127.6476 1948 100 0 1848 British Columbia, Canada
2927 2927     Northwest Territories Canada 2020-04-27 02:30:55 64.8255 -124.8457 5 0 0 5 Northwest Territories, Canada
631 631 41015 Curry Oregon US 2020-04-27 02:30:52 42.45911325 -124.157282 4 0 0 4 Curry, Oregon, US
574 574 41011 Coos Oregon US 2020-04-27 02:30:52 43.17406868 -124.0594514 12 0 0 12 Coos, Oregon, US
466 466 53009 Clallam Washington US 2020-04-26 00:00:00 48.04754642 -123.9226319 15 0 0 15 Clallam, Washington, US
684 684 6015 Del Norte California US 2020-04-27 02:30:52 41.74228275 -123.8974063 3 0 0 3 Del Norte, California, US
1169 1169 6023 Humboldt California US 2020-04-27 02:30:52 40.69923009 -123.876044 53 0 0 53 Humboldt, California, US
1492 1492 41041 Lincoln Oregon US 2020-04-27 02:30:52 44.64252874 -123.869912 5 0 0 5 Lincoln, Oregon, US
979 979 53027 Grays Harbor Washington US 2020-04-26 00:00:00 47.14003705 -123.7820567 12 0 0 12 Grays Harbor, Washington, US
1969 1969 53049 Pacific Washington US 2020-04-26 00:00:00 46.55418369 -123.7285716 4 0 0 4 Pacific, Washington, US
2505 2505 41057 Tillamook Oregon US 2020-04-27 02:30:52 45.46248721 -123.712066 6 0 0 6 Tillamook, Oregon, US
486 486 41007 Clatsop Oregon US 2020-04-27 02:30:52 45.99712889 -123.660711 6 0 0 6 Clatsop, Oregon, US
1266 1266 53031 Jefferson Washington US 2020-04-26 00:00:00 47.75003077 -123.56097040000002 28 0 0 28 Jefferson, Washington, US
1300 1300 41033 Josephine Oregon US 2020-04-27 02:30:52 42.3665549 -123.5561938 20 1 0 19 Josephine, Oregon, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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