04-03-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,627 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
1370 1370   McIntosh Georgia US 2020-04-03 22:46:37     2 0 0 0 McIntosh,Georgia,US
1611 1611 80008 Out of CO Colorado US 2020-04-03 22:46:37     0 1 0 0 Out of CO,Colorado,US
1612 1612 80015 Out of HI Hawaii US 2020-04-03 22:46:37     2 0 0 0 Out of HI,Hawaii,US
1613 1613   Out of MI Michigan US 2020-04-03 22:46:37     74 1 0 0 Out of MI,Michigan,US
1614 1614 80040 Out of OK Oklahoma US 2020-04-03 22:46:37     2 0 0 0 Out of OK,Oklahoma,US
1615 1615   Out of TN Tennessee US 2020-04-03 22:46:37     187 1 0 0 Out of TN,Tennessee,US
2091 2091 90002 Unassigned Alaska US 2020-04-03 22:46:37     0 2 0 0 Unassigned, Alaska, US
2092 2092 90004 Unassigned Arizona US 2020-04-03 22:46:37     0 12 0 0 Unassigned, Arizona, US
2093 2093 90005 Unassigned Arkansas US 2020-04-03 22:46:37     47 6 0 0 Unassigned, Arkansas, US
2094 2094 90006 Unassigned California US 2020-04-03 22:46:37     0 2 0 0 Unassigned, California, US
2095 2095 90008 Unassigned Colorado US 2020-04-03 22:46:37     144 0 0 0 Unassigned, Colorado, US
2096 2096 90009 Unassigned Connecticut US 2020-04-03 22:46:37     218 1 0 0 Unassigned, Connecticut, US
2097 2097 90010 Unassigned Delaware US 2020-04-03 22:46:37     0 17 0 0 Unassigned, Delaware, US
2098 2098 90012 Unassigned Florida US 2020-04-03 22:46:37     10 7 0 0 Unassigned, Florida, US
2099 2099 90013 Unassigned Georgia US 2020-04-03 22:46:37     507 4 0 0 Unassigned, Georgia, US
2100 2100 90015 Unassigned Hawaii US 2020-04-03 22:46:37     11 0 0 0 Unassigned, Hawaii, US
2101 2101 90017 Unassigned Illinois US 2020-04-03 22:46:37     415 1 0 0 Unassigned, Illinois, US
2102 2102 90019 Unassigned Iowa US 2020-04-03 22:46:37     0 1 0 0 Unassigned, Iowa, US
2103 2103 90021 Unassigned Kentucky US 2020-04-03 22:46:37     113 3 0 0 Unassigned, Kentucky, US
2104 2104   Unassigned Louisiana US 2020-04-03 22:46:37     40 4 0 0 Unassigned,Louisiana,US
2105 2105 90023 Unassigned Maine US 2020-04-03 22:46:37     11 2 0 0 Unassigned, Maine, US
2106 2106 90024 Unassigned Maryland US 2020-04-03 22:46:37     0 0 0 0 Unassigned, Maryland, US
2107 2107 90025 Unassigned Massachusetts US 2020-04-03 22:46:37     213 9 0 0 Unassigned, Massachusetts, US
2108 2108   Unassigned Michigan US 2020-04-03 22:46:37     215 1 0 0 Unassigned,Michigan,US
2109 2109 90027 Unassigned Minnesota US 2020-04-03 22:46:37     0 11 0 0 Unassigned, Minnesota, US
2110 2110 90030 Unassigned Montana US 2020-04-03 22:46:37     0 0 0 0 Unassigned, Montana, US
2111 2111 90031 Unassigned Nebraska US 2020-04-03 22:46:37     1 1 0 0 Unassigned, Nebraska, US
2112 2112 90032 Unassigned Nevada US 2020-04-03 22:46:37     16 0 0 0 Unassigned, Nevada, US
2113 2113 90033 Unassigned New Hampshire US 2020-04-03 22:46:37     0 2 0 0 Unassigned, New Hampshire, US
2114 2114 90034 Unassigned New Jersey US 2020-04-03 22:46:37     4808 4 0 0 Unassigned, New Jersey, US
2115 2115 90035 Unassigned New Mexico US 2020-04-03 22:46:37     3 0 0 0 Unassigned, New Mexico, US
2116 2116 90036 Unassigned New York US 2020-04-03 22:46:37     0 955 0 0 Unassigned, New York, US
2117 2117 90038 Unassigned North Dakota US 2020-04-03 22:46:37     0 0 0 0 Unassigned, North Dakota, US
2118 2118 90040 Unassigned Oklahoma US 2020-04-03 22:46:37     0 0 0 0 Unassigned, Oklahoma, US
2119 2119 90044 Unassigned Rhode Island US 2020-04-03 22:46:37     146 8 0 0 Unassigned, Rhode Island, US
2120 2120 90046 Unassigned South Dakota US 2020-04-03 22:46:37     0 0 0 0 Unassigned, South Dakota, US
2121 2121 90047 Unassigned Tennessee US 2020-04-03 22:46:37     54 0 0 0 Unassigned, Tennessee, US
2122 2122 90050 Unassigned Vermont US 2020-04-03 22:46:37     6 12 0 0 Unassigned, Vermont, US
2123 2123 90051 Unassigned Virginia US 2020-04-03 22:46:37     0 31 0 0 Unassigned,Virginia,US
2124 2124 90053 Unassigned Washington US 2020-04-03 22:46:37     501 0 0 0 Unassigned, Washington, US
2125 2125 90055 Unassigned Wisconsin US 2020-04-03 22:46:37     0 4 0 0 Unassigned, Wisconsin, US
2374 2374     Diamond Princess Canada 2020-04-03 22:52:30     0 1 0 0 Diamond Princess, Canada
2375 2375 88888   Diamond Princess US 2020-04-03 22:46:37     49 0 0 0 Diamond Princess, US
2382 2382     Grand Princess Canada 2020-04-03 22:52:30     13 0 0 0 Grand Princess, Canada
2383 2383 99999   Grand Princess US 2020-04-03 22:46:37     103 3 0 0 Grand Princess, US
2424 2424     Recovered Canada 2020-04-03 22:52:30     0 0 2175 0 Recovered, Canada
2425 2425     Recovered US 2020-04-03 22:46:37     0 0 9707 0 Recovered, US
2493 2493       Diamond Princess 2020-04-03 22:46:20     712 11 619 82 Diamond Princess
2548 2548       MS Zaandam 2020-04-03 22:46:20     9 2 0 7 ,,MS Zaandam
2627 2627   unassigned Wyoming US 2020-04-03 22:46:37     0 0 0 0 unassigned, Wyoming, US
2589 2589       Samoa 2020-04-03 22:52:30 -13.759 -172.1046 0 0 0 0 Samoa
1079 1079 15007 Kauai Hawaii US 2020-04-03 22:46:37 22.03935037 -159.5966786 13 0 0 0 Kauai, Hawaii, US
943 943 15003 Honolulu Hawaii US 2020-04-03 22:46:37 21.45803166 -157.97121819999995 237 3 0 0 Honolulu, Hawaii, US
1355 1355 15009 Maui Hawaii US 2020-04-03 22:46:37 20.86399628 -156.56890969999995 36 0 0 0 Maui, Hawaii, US
901 901 15001 Hawaii Hawaii US 2020-04-03 22:46:37 19.60121157 -155.5210167 20 0 0 0 Hawaii, Hawaii, US
1084 1084 2122 Kenai Peninsula Alaska US 2020-04-03 22:46:37 60.24429722 -151.53888840000005 10 0 0 0 Kenai Peninsula, Alaska, US
2357 2357 2290 Yukon-Koyukuk Alaska US 2020-04-03 22:46:37 65.50815459 -151.39073869999999 1 0 0 0 Yukon-Koyukuk, Alaska, US
1353 1353 2170 Matanuska-Susitna Alaska US 2020-04-03 22:46:37 62.31305045 -149.5741743 4 0 0 0 Matanuska-Susitna, Alaska, US
2378 2378     French Polynesia France 2020-04-03 22:46:20 -17.6797 -149.4068 39 0 0 39 French Polynesia, France
46 46 2020 Anchorage Alaska US 2020-04-03 22:46:37 61.14998174 -149.14269860000005 73 1 0 0 Anchorage, Alaska, US
674 674 2090 Fairbanks North Star Alaska US 2020-04-03 22:46:37 64.80726247 -146.5692662 42 0 0 0 Fairbanks North Star, Alaska, US
1931 1931 2240 Southeast Fairbanks Alaska US 2020-04-03 22:46:37 63.87692095 -143.2127643 1 0 0 0 Southeast Fairbanks, Alaska, US
2446 2446     Yukon Canada 2020-04-03 22:52:30 64.2823 -135.0 6 0 0 0 ,Yukon,Canada
1067 1067 2110 Juneau Alaska US 2020-04-03 22:46:37 58.45031811 -134.200436 11 0 0 0 Juneau, Alaska, US
1660 1660 2195 Petersburg Alaska US 2020-04-03 22:46:37 57.13978948 -132.9540995 1 0 0 0 Petersburg, Alaska, US
1098 1098 2130 Ketchikan Gateway Alaska US 2020-04-03 22:46:37 55.57445008 -130.975561 14 0 0 0 Ketchikan Gateway, Alaska, US
2368 2368     British Columbia Canada 2020-04-03 22:52:30 53.7267 -127.6476 1174 31 0 0 British Columbia, Canada
2415 2415     Northwest Territories Canada 2020-04-03 22:52:30 64.8255 -124.8457 2 0 0 0 ,Northwest Territories,Canada
395 395 53009 Clallam Washington US 2020-04-03 22:46:37 48.04754642 -123.92263190000001 8 0 0 0 Clallam, Washington, US
577 577 6015 Del Norte California US 2020-04-03 22:46:37 41.74228275 -123.89740630000001 1 0 0 0 Del Norte, California, US
962 962 6023 Humboldt California US 2020-04-03 22:46:37 40.69923009 -123.876044 37 0 0 0 Humboldt, California, US
1229 1229 41041 Lincoln Oregon US 2020-04-03 22:46:37 44.64252874 -123.86991200000001 4 0 0 0 Lincoln, Oregon, US
818 818 53027 Grays Harbor Washington US 2020-04-03 22:46:37 47.14003705 -123.7820567 2 0 0 0 Grays Harbor, Washington, US
2048 2048 41057 Tillamook Oregon US 2020-04-03 22:46:37 45.46248721 -123.712066 3 0 0 0 Tillamook, Oregon, US
412 412 41007 Clatsop Oregon US 2020-04-03 22:46:37 45.99712889 -123.660711 4 0 0 0 Clatsop, Oregon, US
1042 1042 53031 Jefferson Washington US 2020-04-03 22:46:37 47.75003077 -123.56097040000002 19 0 0 0 Jefferson, Washington, US
1066 1066 41033 Josephine Oregon US 2020-04-03 22:46:37 42.3665549 -123.5561938 12 0 0 0 Josephine, Oregon, US
140 140 41003 Benton Oregon US 2020-04-03 22:46:37 44.49167306 -123.4316987 17 1 0 0 Benton, Oregon, US
2170 2170 53069 Wahkiakum Washington US 2020-04-03 22:46:37 46.29180039999999 -123.4250831 1 0 0 0 Wahkiakum, Washington, US
1703 1703 41053 Polk Oregon US 2020-04-03 22:46:37 44.90322804 -123.4128888 20 1 0 0 Polk, Oregon, US
1392 1392 6045 Mendocino California US 2020-04-03 22:46:37 39.4381191 -123.39113130000001 4 0 0 0 Mendocino, California, US
2342 2342 41071 Yamhill Oregon US 2020-04-03 22:46:37 45.23330449 -123.3086963 23 3 0 0 Yamhill, Oregon, US
1349 1349 53045 Mason Washington US 2020-04-03 22:46:37 47.35007586 -123.1863685 13 0 0 0 Mason, Washington, US
616 616 41019 Douglas Oregon US 2020-04-03 22:46:37 43.27941273 -123.16729099999999 9 0 0 0 Douglas, Oregon, US
2226 2226 41067 Washington Oregon US 2020-04-03 22:46:37 45.55972701 -123.0955257 228 4 0 0 Washington, Oregon, US
469 469 41009 Columbia Oregon US 2020-04-03 22:46:37 45.94464254 -123.08908980000001 1 0 0 0 Columbia, Oregon, US
1842 1842 53055 San Juan Washington US 2020-04-03 22:46:37 48.60182783 -122.96745 6 0 0 0 San Juan, Washington, US
1929 1929 6097 Sonoma California US 2020-04-03 22:46:37 38.52746429 -122.88625060000001 95 2 0 0 Sonoma, California, US
1155 1155 41039 Lane Oregon US 2020-04-03 22:46:37 43.93727035 -122.847753 21 1 0 0 Lane, Oregon, US
2046 2046 53067 Thurston Washington US 2020-04-03 22:46:37 46.9291895 -122.82906559999999 58 1 0 0 Thurston, Washington, US
1011 1011 41029 Jackson Oregon US 2020-04-03 22:46:37 42.43201126 -122.72893090000001 27 0 0 0 Jackson, Oregon, US
1316 1316 6041 Marin California US 2020-04-03 22:46:37 38.07122463 -122.72106310000001 118 6 0 0 Marin, California, US
500 500 53015 Cowlitz Washington US 2020-04-03 22:46:37 46.19074721 -122.6782231 18 0 0 0 Cowlitz, Washington, US
1108 1108 53035 Kitsap Washington US 2020-04-03 22:46:37 47.63479026 -122.6436061 95 0 0 0 Kitsap, Washington, US
1327 1327 41047 Marion Oregon US 2020-04-03 22:46:37 44.90287942 -122.58151170000001 178 4 0 0 Marion, Oregon, US
1913 1913 6093 Siskiyou California US 2020-04-03 22:46:37 41.59198861 -122.54074340000001 3 0 0 0 Siskiyou, California, US
1236 1236 41043 Linn Oregon US 2020-04-03 22:46:37 44.48899494 -122.53731540000001 37 2 0 0 Linn, Oregon, US
993 993 53029 Island Washington US 2020-04-03 22:46:37 48.14713305 -122.5216407 119 5 0 0 Island, Washington, US
406 406 53011 Clark Washington US 2020-04-03 22:46:37 45.77568046 -122.48292040000001 137 9 0 0 Clark, Washington, US
1837 1837 6075 San Francisco California US 2020-04-03 22:46:37 37.75215114 -122.43856720000001 497 7 0 0 San Francisco, California, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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