04-07-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,858 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
1506 1506   McIntosh Georgia US 2020-04-07 23:04:49     3 0 0 0 McIntosh,Georgia,US
1769 1769 80008 Out of CO Colorado US 2020-04-07 23:04:49     0 1 0 0 Out of CO,Colorado,US
1770 1770 80015 Out of HI Hawaii US 2020-04-07 23:04:49     2 0 0 0 Out of HI,Hawaii,US
1771 1771   Out of MI Michigan US 2020-04-07 23:04:49     118 1 0 0 Out of MI,Michigan,US
1772 1772 80040 Out of OK Oklahoma US 2020-04-07 23:04:49     2 0 0 0 Out of OK,Oklahoma,US
1773 1773   Out of TN Tennessee US 2020-04-07 23:04:49     290 1 0 0 Out of TN,Tennessee,US
2300 2300 90002 Unassigned Alaska US 2020-04-07 23:04:49     0 1 0 0 Unassigned, Alaska, US
2301 2301 90004 Unassigned Arizona US 2020-04-07 23:04:49     0 14 0 0 Unassigned, Arizona, US
2302 2302 90005 Unassigned Arkansas US 2020-04-07 23:04:49     44 12 0 0 Unassigned, Arkansas, US
2303 2303 90006 Unassigned California US 2020-04-07 23:04:49     42 0 0 0 Unassigned, California, US
2304 2304 90008 Unassigned Colorado US 2020-04-07 23:04:49     252 29 0 0 Unassigned, Colorado, US
2305 2305 90009 Unassigned Connecticut US 2020-04-07 23:04:49     292 3 0 0 Unassigned, Connecticut, US
2306 2306 90010 Unassigned Delaware US 2020-04-07 23:04:49     0 10 0 0 Unassigned, Delaware, US
2307 2307 90012 Unassigned Florida US 2020-04-07 23:04:49     2 29 0 0 Unassigned,Florida,US
2308 2308 90013 Unassigned Georgia US 2020-04-07 23:04:49     489 7 0 0 Unassigned,Georgia,US
2309 2309 90015 Unassigned Hawaii US 2020-04-07 23:04:49     7 0 0 0 Unassigned, Hawaii, US
2310 2310 90016 Unassigned Idaho US 2020-04-07 23:04:49     0 0 0 0 Unassigned, Idaho, US
2311 2311 90017 Unassigned Illinois US 2020-04-07 23:04:49     72 1 0 0 Unassigned, Illinois, US
2312 2312 90018 Unassigned Indiana US 2020-04-07 23:04:49     0 136 0 0 Unassigned, Indiana, US
2313 2313 90019 Unassigned Iowa US 2020-04-07 23:04:49     0 1 0 0 Unassigned, Iowa, US
2314 2314 90020 Unassigned Kansas US 2020-04-07 23:04:49     0 5 0 0 Unassigned,Kansas,US
2315 2315 90021 Unassigned Kentucky US 2020-04-07 23:04:49     152 5 0 0 Unassigned, Kentucky, US
2316 2316   Unassigned Louisiana US 2020-04-07 23:04:49     49 2 0 0 Unassigned,Louisiana,US
2317 2317 90023 Unassigned Maine US 2020-04-07 23:04:49     9 0 0 0 Unassigned, Maine, US
2318 2318 90024 Unassigned Maryland US 2020-04-07 23:04:49     0 0 0 0 Unassigned, Maryland, US
2319 2319 90025 Unassigned Massachusetts US 2020-04-07 23:04:49     229 11 0 0 Unassigned, Massachusetts, US
2320 2320 90026 Unassigned Michigan US 2020-04-07 23:04:49     409 3 0 0 Unassigned,Michigan,US
2321 2321 90027 Unassigned Minnesota US 2020-04-07 23:04:49     6 0 0 0 Unassigned, Minnesota, US
2322 2322 90029 Unassigned Missouri US 2020-04-07 23:04:49     1 1 0 0 Unassigned, Missouri, US
2323 2323 90030 Unassigned Montana US 2020-04-07 23:04:49     0 0 0 0 Unassigned, Montana, US
2324 2324 90031 Unassigned Nebraska US 2020-04-07 23:04:49     1 1 0 0 Unassigned, Nebraska, US
2325 2325 90032 Unassigned Nevada US 2020-04-07 23:04:49     33 12 0 0 Unassigned, Nevada, US
2326 2326 90033 Unassigned New Hampshire US 2020-04-07 23:04:49     1 6 0 0 Unassigned, New Hampshire, US
2327 2327 90034 Unassigned New Jersey US 2020-04-07 23:04:49     2207 5 0 0 Unassigned, New Jersey, US
2328 2328 90035 Unassigned New Mexico US 2020-04-07 23:04:49     0 0 0 0 Unassigned, New Mexico, US
2329 2329 90036 Unassigned New York US 2020-04-07 23:04:49     0 116 0 0 Unassigned, New York, US
2330 2330 90037 Unassigned North Carolina US 2020-04-07 23:04:49     0 2 0 0 Unassigned, North Carolina, US
2331 2331 90038 Unassigned North Dakota US 2020-04-07 23:04:49     0 0 0 0 Unassigned, North Dakota, US
2332 2332 90039 Unassigned Ohio US 2020-04-07 23:04:49     0 0 0 0 Unassigned, Ohio, US
2333 2333 90040 Unassigned Oklahoma US 2020-04-07 23:04:49     0 0 0 0 Unassigned, Oklahoma, US
2334 2334 90042 Unassigned Pennsylvania US 2020-04-07 23:04:49     0 0 0 0 Unassigned, Pennsylvania, US
2335 2335 90044 Unassigned Rhode Island US 2020-04-07 23:04:49     353 21 0 0 Unassigned, Rhode Island, US
2336 2336 90046 Unassigned South Dakota US 2020-04-07 23:04:49     0 0 0 0 Unassigned, South Dakota, US
2337 2337 90047 Unassigned Tennessee US 2020-04-07 23:04:49     59 0 0 0 Unassigned, Tennessee, US
2338 2338 90049 Unassigned Utah US 2020-04-07 23:04:49     0 0 0 0 Unassigned,Utah,US
2339 2339 90050 Unassigned Vermont US 2020-04-07 23:04:49     3 18 0 0 Unassigned, Vermont, US
2340 2340 90051 Unassigned Virginia US 2020-04-07 23:04:49     0 50 0 0 Unassigned, Virginia, US
2341 2341 90053 Unassigned Washington US 2020-04-07 23:04:49     677 0 0 0 Unassigned, Washington, US
2342 2342 90055 Unassigned Wisconsin US 2020-04-07 23:04:49     0 0 0 0 Unassigned, Wisconsin, US
2343 2343   Unassigned Wyoming US 2020-04-07 23:04:49     0 0 0 0 Unassigned,Wyoming,US
2602 2602     Diamond Princess Canada 2020-04-07 23:11:15     0 1 0 0 Diamond Princess, Canada
2603 2603 88888   Diamond Princess US 2020-04-07 23:04:49     49 0 0 0 Diamond Princess, US
2611 2611     Grand Princess Canada 2020-04-07 23:11:15     13 0 0 0 Grand Princess, Canada
2612 2612 99999   Grand Princess US 2020-04-07 23:04:49     103 3 0 0 Grand Princess, US
2653 2653     Recovered Canada 2020-04-07 23:11:15     0 0 3791 0 Recovered, Canada
2654 2654     Recovered US 2020-04-07 23:04:49     0 0 21763 0 Recovered, US
2723 2723       Diamond Princess 2020-04-07 23:04:29     712 11 619 82 Diamond Princess
2778 2778       MS Zaandam 2020-04-07 23:04:29     9 2 0 7 ,,MS Zaandam
2819 2819       Samoa 2020-04-07 23:11:15 -13.759 -172.1046 0 0 0 0 Samoa
166 166 2050 Bethel Alaska US 2020-04-07 23:04:49 60.90980451 -159.8561831 1 0 0 0 Bethel, Alaska, US
1185 1185 15007 Kauai Hawaii US 2020-04-07 23:04:49 22.03935037 -159.5966786 18 0 0 0 Kauai, Hawaii, US
1035 1035 15003 Honolulu Hawaii US 2020-04-07 23:04:49 21.45803166 -157.97121819999995 312 4 0 0 Honolulu, Hawaii, US
1489 1489 15009 Maui Hawaii US 2020-04-07 23:04:49 20.86399628 -156.56890969999995 48 1 0 0 Maui, Hawaii, US
990 990 15001 Hawaii Hawaii US 2020-04-07 23:04:49 19.60121157 -155.5210167 23 0 0 0 Hawaii, Hawaii, US
1190 1190 2122 Kenai Peninsula Alaska US 2020-04-07 23:04:49 60.24429722 -151.53888840000005 13 0 0 0 Kenai Peninsula, Alaska, US
2584 2584 2290 Yukon-Koyukuk Alaska US 2020-04-07 23:04:49 65.50815459 -151.39073869999999 1 0 0 0 Yukon-Koyukuk, Alaska, US
1487 1487 2170 Matanuska-Susitna Alaska US 2020-04-07 23:04:49 62.31305045 -149.5741743 4 0 0 0 Matanuska-Susitna, Alaska, US
2607 2607     French Polynesia France 2020-04-07 23:04:29 -17.6797 -149.4068 47 0 0 47 French Polynesia, France
48 48 2020 Anchorage Alaska US 2020-04-07 23:04:49 61.14998174 -149.14269860000005 98 4 0 0 Anchorage, Alaska, US
736 736 2090 Fairbanks North Star Alaska US 2020-04-07 23:04:49 64.80726247 -146.5692662 65 1 0 0 Fairbanks North Star, Alaska, US
2127 2127 2240 Southeast Fairbanks Alaska US 2020-04-07 23:04:49 63.87692095 -143.2127643 1 0 0 0 Southeast Fairbanks, Alaska, US
2676 2676     Yukon Canada 2020-04-07 23:11:15 64.2823 -135.0 7 0 0 0 ,Yukon,Canada
1173 1173 2110 Juneau Alaska US 2020-04-07 23:04:49 58.45031811 -134.200436 14 0 0 0 Juneau, Alaska, US
1823 1823 2195 Petersburg Alaska US 2020-04-07 23:04:49 57.13978948 -132.9540995 2 0 0 0 Petersburg, Alaska, US
1204 1204 2130 Ketchikan Gateway Alaska US 2020-04-07 23:04:49 55.57445008 -130.975561 14 0 0 0 Ketchikan Gateway, Alaska, US
2596 2596     British Columbia Canada 2020-04-07 23:11:15 53.7267 -127.6476 1266 39 0 0 British Columbia, Canada
2644 2644     Northwest Territories Canada 2020-04-07 23:11:15 64.8255 -124.8457 5 0 0 0 ,Northwest Territories,Canada
581 581 41015 Curry Oregon US 2020-04-07 23:04:49 42.45911325 -124.15728200000001 2 0 0 0 Curry, Oregon, US
428 428 53009 Clallam Washington US 2020-04-07 23:04:49 48.04754642 -123.92263190000001 8 0 0 0 Clallam, Washington, US
630 630 6015 Del Norte California US 2020-04-07 23:04:49 41.74228275 -123.89740630000001 2 0 0 0 Del Norte, California, US
1057 1057 6023 Humboldt California US 2020-04-07 23:04:49 40.69923009 -123.876044 49 0 0 0 Humboldt, California, US
1349 1349 41041 Lincoln Oregon US 2020-04-07 23:04:49 44.64252874 -123.86991200000001 4 0 0 0 Lincoln, Oregon, US
896 896 53027 Grays Harbor Washington US 2020-04-07 23:04:49 47.14003705 -123.7820567 6 0 0 0 Grays Harbor, Washington, US
2254 2254 41057 Tillamook Oregon US 2020-04-07 23:04:49 45.46248721 -123.712066 3 0 0 0 Tillamook, Oregon, US
447 447 41007 Clatsop Oregon US 2020-04-07 23:04:49 45.99712889 -123.660711 4 0 0 0 Clatsop, Oregon, US
1145 1145 53031 Jefferson Washington US 2020-04-07 23:04:49 47.75003077 -123.56097040000002 27 0 0 0 Jefferson, Washington, US
1172 1172 41033 Josephine Oregon US 2020-04-07 23:04:49 42.3665549 -123.5561938 16 0 0 0 Josephine, Oregon, US
153 153 41003 Benton Oregon US 2020-04-07 23:04:49 44.49167306 -123.4316987 21 1 0 0 Benton, Oregon, US
2392 2392 53069 Wahkiakum Washington US 2020-04-07 23:04:49 46.29180039999999 -123.4250831 2 0 0 0 Wahkiakum, Washington, US
1876 1876 41053 Polk Oregon US 2020-04-07 23:04:49 44.90322804 -123.4128888 26 1 0 0 Polk, Oregon, US
1532 1532 6045 Mendocino California US 2020-04-07 23:04:49 39.4381191 -123.39113130000001 4 0 0 0 Mendocino, California, US
2568 2568 41071 Yamhill Oregon US 2020-04-07 23:04:49 45.23330449 -123.3086963 25 3 0 0 Yamhill, Oregon, US
1483 1483 53045 Mason Washington US 2020-04-07 23:04:49 47.35007586 -123.1863685 16 0 0 0 Mason, Washington, US
674 674 41019 Douglas Oregon US 2020-04-07 23:04:49 43.27941273 -123.16729099999999 12 0 0 0 Douglas, Oregon, US
2448 2448 41067 Washington Oregon US 2020-04-07 23:04:49 45.55972701 -123.0955257 271 5 0 0 Washington, Oregon, US
507 507 41009 Columbia Oregon US 2020-04-07 23:04:49 45.94464254 -123.08908980000001 8 0 0 0 Columbia, Oregon, US
2028 2028 53055 San Juan Washington US 2020-04-07 23:04:49 48.60182783 -122.96745 10 0 0 0 San Juan, Washington, US
2125 2125 6097 Sonoma California US 2020-04-07 23:04:49 38.52746429 -122.88625060000001 111 2 0 0 Sonoma, California, US
1268 1268 41039 Lane Oregon US 2020-04-07 23:04:49 43.93727035 -122.847753 29 1 0 0 Lane, Oregon, US
2252 2252 53067 Thurston Washington US 2020-04-07 23:04:49 46.9291895 -122.82906559999999 74 1 0 0 Thurston, Washington, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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