04-05-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,765 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
1450 1450   McIntosh Georgia US 2020-04-05 23:06:45     2 0 0 0 McIntosh,Georgia,US
1705 1705 80008 Out of CO Colorado US 2020-04-05 23:06:45     0 1 0 0 Out of CO,Colorado,US
1706 1706 80015 Out of HI Hawaii US 2020-04-05 23:06:45     2 0 0 0 Out of HI,Hawaii,US
1707 1707   Out of MI Michigan US 2020-04-05 23:06:45     83 1 0 0 Out of MI,Michigan,US
1708 1708 80040 Out of OK Oklahoma US 2020-04-05 23:06:45     2 0 0 0 Out of OK,Oklahoma,US
1709 1709   Out of TN Tennessee US 2020-04-05 23:06:45     265 1 0 0 Out of TN,Tennessee,US
2216 2216 90002 Unassigned Alaska US 2020-04-05 23:06:45     0 5 0 0 Unassigned, Alaska, US
2217 2217 90004 Unassigned Arizona US 2020-04-05 23:06:45     0 10 0 0 Unassigned, Arizona, US
2218 2218 90005 Unassigned Arkansas US 2020-04-05 23:06:45     57 10 0 0 Unassigned, Arkansas, US
2219 2219 90006 Unassigned California US 2020-04-05 23:06:45     0 0 0 0 Unassigned, California, US
2220 2220 90008 Unassigned Colorado US 2020-04-05 23:06:45     251 0 0 0 Unassigned, Colorado, US
2221 2221 90009 Unassigned Connecticut US 2020-04-05 23:06:45     222 1 0 0 Unassigned, Connecticut, US
2222 2222 90010 Unassigned Delaware US 2020-04-05 23:06:45     0 7 0 0 Unassigned, Delaware, US
2223 2223 90012 Unassigned Florida US 2020-04-05 23:06:45     4 0 0 0 Unassigned, Florida, US
2224 2224 90013 Unassigned Georgia US 2020-04-05 23:06:45     278 5 0 0 Unassigned, Georgia, US
2225 2225 90015 Unassigned Hawaii US 2020-04-05 23:06:45     7 0 0 0 Unassigned, Hawaii, US
2226 2226 90016 Unassigned Idaho US 2020-04-05 23:06:45     0 0 0 0 Unassigned, Idaho, US
2227 2227 90017 Unassigned Illinois US 2020-04-05 23:06:45     62 0 0 0 Unassigned, Illinois, US
2228 2228 90019 Unassigned Iowa US 2020-04-05 23:06:45     0 0 0 0 Unassigned, Iowa, US
2229 2229 90020 Unassigned Kansas US 2020-04-05 23:06:45     0 3 0 0 Unassigned,Kansas,US
2230 2230 90021 Unassigned Kentucky US 2020-04-05 23:06:45     34 0 0 0 Unassigned, Kentucky, US
2231 2231   Unassigned Louisiana US 2020-04-05 23:06:45     31 4 0 0 Unassigned,Louisiana,US
2232 2232 90023 Unassigned Maine US 2020-04-05 23:06:45     11 3 0 0 Unassigned, Maine, US
2233 2233 90024 Unassigned Maryland US 2020-04-05 23:06:45     0 0 0 0 Unassigned, Maryland, US
2234 2234 90025 Unassigned Massachusetts US 2020-04-05 23:06:45     215 9 0 0 Unassigned, Massachusetts, US
2235 2235   Unassigned Michigan US 2020-04-05 23:06:45     349 1 0 0 Unassigned,Michigan,US
2236 2236 90027 Unassigned Minnesota US 2020-04-05 23:06:45     7 3 0 0 Unassigned, Minnesota, US
2237 2237 90029 Unassigned Missouri US 2020-04-05 23:06:45     3 0 0 0 Unassigned,Missouri,US
2238 2238 90030 Unassigned Montana US 2020-04-05 23:06:45     0 0 0 0 Unassigned, Montana, US
2239 2239 90031 Unassigned Nebraska US 2020-04-05 23:06:45     1 1 0 0 Unassigned, Nebraska, US
2240 2240 90032 Unassigned Nevada US 2020-04-05 23:06:45     25 0 0 0 Unassigned, Nevada, US
2241 2241 90033 Unassigned New Hampshire US 2020-04-05 23:06:45     4 6 0 0 Unassigned, New Hampshire, US
2242 2242 90034 Unassigned New Jersey US 2020-04-05 23:06:45     3821 13 0 0 Unassigned, New Jersey, US
2243 2243 90035 Unassigned New Mexico US 2020-04-05 23:06:45     0 0 0 0 Unassigned, New Mexico, US
2244 2244 90036 Unassigned New York US 2020-04-05 23:06:45     0 1260 0 0 Unassigned, New York, US
2245 2245 90038 Unassigned North Dakota US 2020-04-05 23:06:45     0 0 0 0 Unassigned, North Dakota, US
2246 2246 90039 Unassigned Ohio US 2020-04-05 23:06:45     0 0 0 0 Unassigned, Ohio, US
2247 2247 90040 Unassigned Oklahoma US 2020-04-05 23:06:45     0 0 0 0 Unassigned, Oklahoma, US
2248 2248 90044 Unassigned Rhode Island US 2020-04-05 23:06:45     238 9 0 0 Unassigned, Rhode Island, US
2249 2249 90046 Unassigned South Dakota US 2020-04-05 23:06:45     0 0 0 0 Unassigned, South Dakota, US
2250 2250 90047 Unassigned Tennessee US 2020-04-05 23:06:45     86 0 0 0 Unassigned, Tennessee, US
2251 2251 90049 Unassigned Utah US 2020-04-05 23:06:45     2 0 0 0 Unassigned,Utah,US
2252 2252 90050 Unassigned Vermont US 2020-04-05 23:06:45     13 17 0 0 Unassigned, Vermont, US
2253 2253 90051 Unassigned Virginia US 2020-04-05 23:06:45     3 36 0 0 Unassigned, Virginia, US
2254 2254 90053 Unassigned Washington US 2020-04-05 23:06:45     533 0 0 0 Unassigned, Washington, US
2255 2255 90055 Unassigned Wisconsin US 2020-04-05 23:06:45     0 0 0 0 Unassigned, Wisconsin, US
2509 2509     Diamond Princess Canada 2020-04-05 23:13:28     0 1 0 0 Diamond Princess, Canada
2510 2510 88888   Diamond Princess US 2020-04-05 23:06:45     49 0 0 0 Diamond Princess, US
2518 2518     Grand Princess Canada 2020-04-05 23:13:28     13 0 0 0 Grand Princess, Canada
2519 2519 99999   Grand Princess US 2020-04-05 23:06:45     103 3 0 0 Grand Princess, US
2560 2560     Recovered Canada 2020-04-05 23:13:28     0 0 3012 0 Recovered, Canada
2561 2561     Recovered US 2020-04-05 23:06:45     0 0 17448 0 Recovered, US
2630 2630       Diamond Princess 2020-04-05 23:06:26     712 11 619 82 Diamond Princess
2685 2685       MS Zaandam 2020-04-05 23:06:26     9 2 0 7 ,,MS Zaandam
2765 2765   unassigned Wyoming US 2020-04-05 23:06:45     0 0 0 0 unassigned, Wyoming, US
2726 2726       Samoa 2020-04-05 23:13:28 -13.759 -172.1046 0 0 0 0 Samoa
1145 1145 15007 Kauai Hawaii US 2020-04-05 23:06:45 22.03935037 -159.5966786 16 0 0 0 Kauai, Hawaii, US
999 999 15003 Honolulu Hawaii US 2020-04-05 23:06:45 21.45803166 -157.97121819999995 281 4 0 0 Honolulu, Hawaii, US
1435 1435 15009 Maui Hawaii US 2020-04-05 23:06:45 20.86399628 -156.56890969999995 43 0 0 0 Maui, Hawaii, US
954 954 15001 Hawaii Hawaii US 2020-04-05 23:06:45 19.60121157 -155.5210167 22 0 0 0 Hawaii, Hawaii, US
1150 1150 2122 Kenai Peninsula Alaska US 2020-04-05 23:06:45 60.24429722 -151.53888840000005 12 0 0 0 Kenai Peninsula, Alaska, US
2492 2492 2290 Yukon-Koyukuk Alaska US 2020-04-05 23:06:45 65.50815459 -151.39073869999999 1 0 0 0 Yukon-Koyukuk, Alaska, US
1433 1433 2170 Matanuska-Susitna Alaska US 2020-04-05 23:06:45 62.31305045 -149.5741743 4 0 0 0 Matanuska-Susitna, Alaska, US
2514 2514     French Polynesia France 2020-04-05 23:06:26 -17.6797 -149.4068 41 0 0 41 French Polynesia, France
48 48 2020 Anchorage Alaska US 2020-04-05 23:06:45 61.14998174 -149.14269860000005 85 1 0 0 Anchorage, Alaska, US
712 712 2090 Fairbanks North Star Alaska US 2020-04-05 23:06:45 64.80726247 -146.5692662 53 0 0 0 Fairbanks North Star, Alaska, US
2049 2049 2240 Southeast Fairbanks Alaska US 2020-04-05 23:06:45 63.87692095 -143.2127643 1 0 0 0 Southeast Fairbanks, Alaska, US
2583 2583     Yukon Canada 2020-04-05 23:13:28 64.2823 -135.0 6 0 0 0 ,Yukon,Canada
1133 1133 2110 Juneau Alaska US 2020-04-05 23:06:45 58.45031811 -134.200436 14 0 0 0 Juneau, Alaska, US
1757 1757 2195 Petersburg Alaska US 2020-04-05 23:06:45 57.13978948 -132.9540995 1 0 0 0 Petersburg, Alaska, US
1164 1164 2130 Ketchikan Gateway Alaska US 2020-04-05 23:06:45 55.57445008 -130.975561 14 0 0 0 Ketchikan Gateway, Alaska, US
2503 2503     British Columbia Canada 2020-04-05 23:13:28 53.7267 -127.6476 1203 38 0 0 British Columbia, Canada
2551 2551     Northwest Territories Canada 2020-04-05 23:13:28 64.8255 -124.8457 4 0 0 0 ,Northwest Territories,Canada
417 417 53009 Clallam Washington US 2020-04-05 23:06:45 48.04754642 -123.92263190000001 8 0 0 0 Clallam, Washington, US
609 609 6015 Del Norte California US 2020-04-05 23:06:45 41.74228275 -123.89740630000001 2 0 0 0 Del Norte, California, US
1020 1020 6023 Humboldt California US 2020-04-05 23:06:45 40.69923009 -123.876044 44 0 0 0 Humboldt, California, US
1301 1301 41041 Lincoln Oregon US 2020-04-05 23:06:45 44.64252874 -123.86991200000001 4 0 0 0 Lincoln, Oregon, US
866 866 53027 Grays Harbor Washington US 2020-04-05 23:06:45 47.14003705 -123.7820567 6 0 0 0 Grays Harbor, Washington, US
2172 2172 41057 Tillamook Oregon US 2020-04-05 23:06:45 45.46248721 -123.712066 3 0 0 0 Tillamook, Oregon, US
436 436 41007 Clatsop Oregon US 2020-04-05 23:06:45 45.99712889 -123.660711 4 0 0 0 Clatsop, Oregon, US
1105 1105 53031 Jefferson Washington US 2020-04-05 23:06:45 47.75003077 -123.56097040000002 20 0 0 0 Jefferson, Washington, US
1132 1132 41033 Josephine Oregon US 2020-04-05 23:06:45 42.3665549 -123.5561938 13 0 0 0 Josephine, Oregon, US
150 150 41003 Benton Oregon US 2020-04-05 23:06:45 44.49167306 -123.4316987 19 1 0 0 Benton, Oregon, US
2302 2302 53069 Wahkiakum Washington US 2020-04-05 23:06:45 46.29180039999999 -123.4250831 1 0 0 0 Wahkiakum, Washington, US
1807 1807 41053 Polk Oregon US 2020-04-05 23:06:45 44.90322804 -123.4128888 24 1 0 0 Polk, Oregon, US
1475 1475 6045 Mendocino California US 2020-04-05 23:06:45 39.4381191 -123.39113130000001 4 0 0 0 Mendocino, California, US
2476 2476 41071 Yamhill Oregon US 2020-04-05 23:06:45 45.23330449 -123.3086963 26 3 0 0 Yamhill, Oregon, US
1429 1429 53045 Mason Washington US 2020-04-05 23:06:45 47.35007586 -123.1863685 14 0 0 0 Mason, Washington, US
652 652 41019 Douglas Oregon US 2020-04-05 23:06:45 43.27941273 -123.16729099999999 11 0 0 0 Douglas, Oregon, US
2358 2358 41067 Washington Oregon US 2020-04-05 23:06:45 45.55972701 -123.0955257 259 4 0 0 Washington, Oregon, US
495 495 41009 Columbia Oregon US 2020-04-05 23:06:45 45.94464254 -123.08908980000001 6 0 0 0 Columbia, Oregon, US
1954 1954 53055 San Juan Washington US 2020-04-05 23:06:45 48.60182783 -122.96745 7 0 0 0 San Juan, Washington, US
2047 2047 6097 Sonoma California US 2020-04-05 23:06:45 38.52746429 -122.88625060000001 107 2 0 0 Sonoma, California, US
1223 1223 41039 Lane Oregon US 2020-04-05 23:06:45 43.93727035 -122.847753 27 1 0 0 Lane, Oregon, US
2170 2170 53067 Thurston Washington US 2020-04-05 23:06:45 46.9291895 -122.82906559999999 67 1 0 0 Thurston, Washington, US
1070 1070 41029 Jackson Oregon US 2020-04-05 23:06:45 42.43201126 -122.72893090000001 33 0 0 0 Jackson, Oregon, US
1391 1391 6041 Marin California US 2020-04-05 23:06:45 38.07122463 -122.72106310000001 137 7 0 0 Marin, California, US
527 527 53015 Cowlitz Washington US 2020-04-05 23:06:45 46.19074721 -122.6782231 18 0 0 0 Cowlitz, Washington, US
1175 1175 53035 Kitsap Washington US 2020-04-05 23:06:45 47.63479026 -122.6436061 104 0 0 0 Kitsap, Washington, US
1403 1403 41047 Marion Oregon US 2020-04-05 23:06:45 44.90287942 -122.58151170000001 198 5 0 0 Marion, Oregon, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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