04-02-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,572 rows sorted by Long_

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link rowid FIPS Admin2 Province_State Country_Region Last_Update Lat Long_ ▼ Confirmed Deaths Recovered Active Combined_Key
1341 1341   McIntosh Georgia US 4/2/20 23:25     1 0 0 0 McIntosh,Georgia,US
1578 1578 80008 Out of CO Colorado US 4/2/20 23:25     0 1 0 0 Out of CO,Colorado,US
1579 1579   Out of MI Michigan US 4/2/20 23:25     48 1 0 0 Out of MI,Michigan,US
1580 1580   Out of OK Oklahoma US 4/2/20 23:25     2 0 0 0 Out of OK,Oklahoma,US
1581 1581   Out of TN Tennessee US 4/2/20 23:25     243 1 0 0 Out of TN,Tennessee,US
1582 1582   Out of UT Utah US 4/2/20 23:25     22 0 0 0 Out of UT,Utah,US
2043 2043 90001 Unassigned Alabama US 4/2/20 23:25     0 5 0 0 Unassigned, Alabama, US
2044 2044 90002 Unassigned Alaska US 4/2/20 23:25     0 2 0 0 Unassigned, Alaska, US
2045 2045 90004 Unassigned Arizona US 4/2/20 23:25     0 3 0 0 Unassigned, Arizona, US
2046 2046 90005 Unassigned Arkansas US 4/2/20 23:25     43 6 0 0 Unassigned, Arkansas, US
2047 2047 90006 Unassigned California US 4/2/20 23:25     0 0 0 0 Unassigned, California, US
2048 2048 90008 Unassigned Colorado US 4/2/20 23:25     128 4 0 0 Unassigned, Colorado, US
2049 2049 90009 Unassigned Connecticut US 4/2/20 23:25     174 1 0 0 Unassigned, Connecticut, US
2050 2050 90010 Unassigned Delaware US 4/2/20 23:25     0 16 0 0 Unassigned, Delaware, US
2051 2051 90012 Unassigned Florida US 4/2/20 23:25     9 20 0 0 Unassigned, Florida, US
2052 2052 90013 Unassigned Georgia US 4/2/20 23:25     778 1 0 0 Unassigned, Georgia, US
2053 2053 90015 Unassigned Hawaii US 4/2/20 23:25     18 0 0 0 Unassigned, Hawaii, US
2054 2054 90016 Unassigned Idaho US 4/2/20 23:25     9 0 0 0 Unassigned, Idaho, US
2055 2055 90017 Unassigned Illinois US 4/2/20 23:25     37 0 0 0 Unassigned, Illinois, US
2056 2056 90019 Unassigned Iowa US 4/2/20 23:25     0 1 0 0 Unassigned, Iowa, US
2057 2057 90021 Unassigned Kentucky US 4/2/20 23:25     113 14 0 0 Unassigned, Kentucky, US
2058 2058   Unassigned Louisiana US 4/2/20 23:25     38 1 0 0 Unassigned,Louisiana,US
2059 2059 90023 Unassigned Maine US 4/2/20 23:25     8 0 0 0 Unassigned, Maine, US
2060 2060 90024 Unassigned Maryland US 4/2/20 23:25     0 0 0 0 Unassigned, Maryland, US
2061 2061 90025 Unassigned Massachusetts US 4/2/20 23:25     270 9 0 0 Unassigned, Massachusetts, US
2062 2062   Unassigned Michigan US 4/2/20 23:25     178 0 0 0 Unassigned,Michigan,US
2063 2063 90027 Unassigned Minnesota US 4/2/20 23:25     0 8 0 0 Unassigned, Minnesota, US
2064 2064 90029 Unassigned Missouri US 4/2/20 23:25     0 0 0 0 Unassigned, Missouri, US
2065 2065 90030 Unassigned Montana US 4/2/20 23:25     0 0 0 0 Unassigned, Montana, US
2066 2066 90031 Unassigned Nebraska US 4/2/20 23:25     2 1 0 0 Unassigned, Nebraska, US
2067 2067 90032 Unassigned Nevada US 4/2/20 23:25     148 0 0 0 Unassigned, Nevada, US
2068 2068 90033 Unassigned New Hampshire US 4/2/20 23:25     0 2 0 0 Unassigned, New Hampshire, US
2069 2069 90034 Unassigned New Jersey US 4/2/20 23:25     4866 4 0 0 Unassigned, New Jersey, US
2070 2070 90035 Unassigned New Mexico US 4/2/20 23:25     1 0 0 0 Unassigned, New Mexico, US
2071 2071 90036 Unassigned New York US 4/2/20 23:25     0 675 0 0 Unassigned, New York, US
2072 2072 90038 Unassigned North Dakota US 4/2/20 23:25     0 0 0 0 Unassigned, North Dakota, US
2073 2073 90040 Unassigned Oklahoma US 4/2/20 23:25     0 0 0 0 Unassigned, Oklahoma, US
2074 2074 90044 Unassigned Rhode Island US 4/2/20 23:25     80 5 0 0 Unassigned, Rhode Island, US
2075 2075 90046 Unassigned South Dakota US 4/2/20 23:25     0 0 0 0 Unassigned, South Dakota, US
2076 2076 90047 Unassigned Tennessee US 4/2/20 23:25     6 0 0 0 Unassigned, Tennessee, US
2077 2077 90050 Unassigned Vermont US 4/2/20 23:25     5 12 0 0 Unassigned, Vermont, US
2078 2078 90051 Unassigned Virginia US 4/2/20 23:25     0 26 0 0 Unassigned,Virginia,US
2079 2079 90053 Unassigned Washington US 4/2/20 23:25     344 0 0 0 Unassigned, Washington, US
2080 2080 90054 Unassigned West Virginia US 4/2/20 23:25     0 1 0 0 Unassigned, West Virginia, US
2081 2081 90055 Unassigned Wisconsin US 4/2/20 23:25     0 5 0 0 Unassigned, Wisconsin, US
2319 2319     Diamond Princess Canada 4/2/20 23:31     0 1 0 0 Diamond Princess, Canada
2320 2320 88888   Diamond Princess US 4/2/20 23:25     49 0 0 0 Diamond Princess, US
2327 2327     Grand Princess Canada 4/2/20 23:31     13 0 0 0 Grand Princess, Canada
2328 2328 99999   Grand Princess US 4/2/20 23:25     103 3 0 0 Grand Princess, US
2369 2369     Recovered Canada 4/2/20 23:31     0 0 1735 0 Recovered, Canada
2370 2370     Recovered US 4/2/20 23:25     0 0 9001 0 Recovered, US
2438 2438       Diamond Princess 4/2/20 23:25     712 11 619 82 Diamond Princess
2493 2493       MS Zaandam 4/2/20 23:25     9 2 0 7 ,,MS Zaandam
2572 2572   unassigned Wyoming US 4/2/20 23:25     0 0 0 0 unassigned, Wyoming, US
2534 2534       Samoa 4/2/20 23:31 -13.759 -172.1046 0 0 0 0 Samoa
1060 1060 15007 Kauai Hawaii US 4/2/20 23:25 22.03935037 -159.5966786 12 0 0 0 Kauai, Hawaii, US
925 925 15003 Honolulu Hawaii US 4/2/20 23:25 21.45803166 -157.9712182 182 1 0 0 Honolulu, Hawaii, US
1327 1327 15009 Maui Hawaii US 4/2/20 23:25 20.86399628 -156.5689097 26 0 0 0 Maui, Hawaii, US
886 886 15001 Hawaii Hawaii US 4/2/20 23:25 19.60121157 -155.5210167 18 0 0 0 Hawaii, Hawaii, US
1065 1065 2122 Kenai Peninsula Alaska US 4/2/20 23:25 60.24429722 -151.5388884 8 0 0 0 Kenai Peninsula,Alaska,US
1325 1325   Matanuska-Susitna Alaska US 4/2/20 23:25 62.31305045 -149.5741743 4 0 0 0 Matanuska-Susitna,Alaska,US
2323 2323     French Polynesia France 4/2/20 23:25 -17.6797 -149.4068 37 0 0 37 French Polynesia, France
46 46 2020 Anchorage Alaska US 4/2/20 23:25 61.14998174 -149.1426986 67 1 0 0 Anchorage,Alaska,US
661 661 2090 Fairbanks North Star Alaska US 4/2/20 23:25 64.80726247 -146.5692662 40 0 0 0 Fairbanks North Star,Alaska,US
2391 2391     Yukon Canada 4/2/20 23:31 64.2823 -135.0 6 0 0 0 ,Yukon,Canada
1048 1048 2110 Juneau Alaska US 4/2/20 23:25 58.45031811 -134.200436 10 0 0 0 Juneau, Alaska, US
1079 1079 2130 Ketchikan Gateway Alaska US 4/2/20 23:25 55.57445008 -130.975561 14 0 0 0 Ketchikan Gateway, Alaska, US
2313 2313     British Columbia Canada 4/2/20 23:31 53.7267 -127.6476 1121 31 0 0 British Columbia, Canada
2360 2360     Northwest Territories Canada 4/2/20 23:31 64.8255 -124.8457 2 0 0 0 ,Northwest Territories,Canada
391 391 53009 Clallam Washington US 4/2/20 23:25 48.04754642 -123.9226319 8 0 0 0 Clallam, Washington, US
944 944 6023 Humboldt California US 4/2/20 23:25 40.69923009 -123.876044 28 0 0 0 Humboldt, California, US
1208 1208 41041 Lincoln Oregon US 4/2/20 23:25 44.64252874 -123.869912 4 0 0 0 Lincoln, Oregon, US
803 803 53027 Grays Harbor Washington US 4/2/20 23:25 47.14003705 -123.7820567 2 0 0 0 Grays Harbor, Washington, US
2003 2003 41057 Tillamook Oregon US 4/2/20 23:25 45.46248721 -123.712066 3 0 0 0 Tillamook, Oregon, US
408 408 41007 Clatsop Oregon US 4/2/20 23:25 45.99712889 -123.660711 3 0 0 0 Clatsop, Oregon, US
1024 1024 53031 Jefferson Washington US 4/2/20 23:25 47.75003077 -123.5609704 19 0 0 0 Jefferson, Washington, US
1047 1047 41033 Josephine Oregon US 4/2/20 23:25 42.3665549 -123.5561938 12 0 0 0 Josephine, Oregon, US
139 139 41003 Benton Oregon US 4/2/20 23:25 44.49167306 -123.4316987 15 1 0 0 Benton, Oregon, US
1663 1663 41053 Polk Oregon US 4/2/20 23:25 44.90322804 -123.4128888 18 0 0 0 Polk, Oregon, US
1363 1363 6045 Mendocino California US 4/2/20 23:25 39.4381191 -123.3911313 4 0 0 0 Mendocino, California, US
2288 2288 41071 Yamhill Oregon US 4/2/20 23:25 45.23330449 -123.3086963 18 3 0 0 Yamhill, Oregon, US
1321 1321 53045 Mason Washington US 4/2/20 23:25 47.35007586 -123.1863685 11 0 0 0 Mason, Washington, US
608 608 41019 Douglas Oregon US 4/2/20 23:25 43.27941273 -123.167291 9 0 0 0 Douglas, Oregon, US
2177 2177 41067 Washington Oregon US 4/2/20 23:25 45.55972701 -123.0955257 211 4 0 0 Washington, Oregon, US
463 463 41009 Columbia Oregon US 4/2/20 23:25 45.94464254 -123.0890898 1 0 0 0 Columbia, Oregon, US
1798 1798 53055 San Juan Washington US 4/2/20 23:25 48.60182783 -122.96745 6 0 0 0 San Juan, Washington, US
1885 1885 6097 Sonoma California US 4/2/20 23:25 38.52746429 -122.8862506 91 2 0 0 Sonoma, California, US
1136 1136 41039 Lane Oregon US 4/2/20 23:25 43.93727035 -122.847753 21 1 0 0 Lane, Oregon, US
2001 2001 53067 Thurston Washington US 4/2/20 23:25 46.9291895 -122.8290656 51 0 0 0 Thurston, Washington, US
993 993 41029 Jackson Oregon US 4/2/20 23:25 42.43201126 -122.7289309 27 0 0 0 Jackson, Oregon, US
1290 1290 6041 Marin California US 4/2/20 23:25 38.07122463 -122.7210631 108 6 0 0 Marin, California, US
494 494 53015 Cowlitz Washington US 4/2/20 23:25 46.19074721 -122.6782231 18 0 0 0 Cowlitz, Washington, US
1090 1090 53035 Kitsap Washington US 4/2/20 23:25 47.63479026 -122.6436061 83 0 0 0 Kitsap, Washington, US
1299 1299 41047 Marion Oregon US 4/2/20 23:25 44.90287942 -122.5815117 164 4 0 0 Marion, Oregon, US
1870 1870 6093 Siskiyou California US 4/2/20 23:25 41.59198861 -122.5407434 3 0 0 0 Siskiyou, California, US
1214 1214 41043 Linn Oregon US 4/2/20 23:25 44.48899494 -122.5373154 37 2 0 0 Linn, Oregon, US
975 975 53029 Island Washington US 4/2/20 23:25 48.14713305 -122.5216407 114 5 0 0 Island, Washington, US
402 402 53011 Clark Washington US 4/2/20 23:25 45.77568046 -122.4829204 131 8 0 0 Clark, Washington, US
1793 1793 6075 San Francisco California US 4/2/20 23:25 37.75215114 -122.4385672 450 7 0 0 San Francisco, California, US
1461 1461 41051 Multnomah Oregon US 4/2/20 23:25 45.54747959 -122.4169351 160 3 0 0 Multnomah, Oregon, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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