04-11-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,967 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
1564 1564   McIntosh Georgia US 2020-04-11 22:45:33     3 0 0 0 McIntosh,Georgia,US
1837 1837 80008 Out of CO Colorado US 2020-04-11 22:45:33     0 1 0 0 Out of CO,Colorado,US
1838 1838 80015 Out of HI Hawaii US 2020-04-11 22:45:33     2 0 0 0 Out of HI,Hawaii,US
1839 1839   Out of MI Michigan US 2020-04-11 22:45:33     140 1 0 0 Out of MI,Michigan,US
1840 1840 80040 Out of OK Oklahoma US 2020-04-11 22:45:33     0 0 0 0 Out of OK,Oklahoma,US
1841 1841   Out of TN Tennessee US 2020-04-11 22:45:33     276 1 0 0 Out of TN,Tennessee,US
2398 2398 90001 Unassigned Alabama US 2020-04-11 22:45:33     0 0 0 0 Unassigned, Alabama, US
2399 2399 90002 Unassigned Alaska US 2020-04-11 22:45:33     0 3 0 0 Unassigned, Alaska, US
2400 2400 90004 Unassigned Arizona US 2020-04-11 22:45:33     0 29 0 0 Unassigned, Arizona, US
2401 2401 90005 Unassigned Arkansas US 2020-04-11 22:45:33     19 0 0 0 Unassigned, Arkansas, US
2402 2402 90006 Unassigned California US 2020-04-11 22:45:33     4 0 0 0 Unassigned, California, US
2403 2403 90008 Unassigned Colorado US 2020-04-11 22:45:33     145 1 0 0 Unassigned, Colorado, US
2404 2404 90009 Unassigned Connecticut US 2020-04-11 22:45:33     456 5 0 0 Unassigned, Connecticut, US
2405 2405 90010 Unassigned Delaware US 2020-04-11 22:45:33     13 4 0 0 Unassigned, Delaware, US
2406 2406 90012 Unassigned Florida US 2020-04-11 22:45:33     2 0 0 0 Unassigned, Florida, US
2407 2407 90013 Unassigned Georgia US 2020-04-11 22:45:33     1397 4 0 0 Unassigned,Georgia,US
2408 2408 90015 Unassigned Hawaii US 2020-04-11 22:45:33     4 0 0 0 Unassigned, Hawaii, US
2409 2409 90016 Unassigned Idaho US 2020-04-11 22:45:33     0 0 0 0 Unassigned, Idaho, US
2410 2410 90017 Unassigned Illinois US 2020-04-11 22:45:33     85 0 0 0 Unassigned, Illinois, US
2411 2411 90018 Unassigned Indiana US 2020-04-11 22:45:33     0 89 0 0 Unassigned, Indiana, US
2412 2412 90019 Unassigned Iowa US 2020-04-11 22:45:33     0 6 0 0 Unassigned, Iowa, US
2413 2413 90020 Unassigned Kansas US 2020-04-11 22:45:33     0 8 0 0 Unassigned, Kansas, US
2414 2414 90021 Unassigned Kentucky US 2020-04-11 22:45:33     385 21 0 0 Unassigned, Kentucky, US
2415 2415 90022 Unassigned Louisiana US 2020-04-11 22:45:33     54 3 0 0 Unassigned,Louisiana,US
2416 2416 90023 Unassigned Maine US 2020-04-11 22:45:33     3 0 0 0 Unassigned, Maine, US
2417 2417 90025 Unassigned Massachusetts US 2020-04-11 22:45:33     225 13 0 0 Unassigned, Massachusetts, US
2418 2418 90026 Unassigned Michigan US 2020-04-11 22:45:33     86 7 0 0 Unassigned, Michigan, US
2419 2419 90027 Unassigned Minnesota US 2020-04-11 22:45:33     4 1 0 0 Unassigned, Minnesota, US
2420 2420 90028 Unassigned Mississippi US 2020-04-11 22:45:33     0 0 0 0 Unassigned, Mississippi, US
2421 2421 90029 Unassigned Missouri US 2020-04-11 22:45:33     0 0 0 0 Unassigned, Missouri, US
2422 2422 90030 Unassigned Montana US 2020-04-11 22:45:33     0 0 0 0 Unassigned, Montana, US
2423 2423 90031 Unassigned Nebraska US 2020-04-11 22:45:33     0 2 0 0 Unassigned, Nebraska, US
2424 2424 90032 Unassigned Nevada US 2020-04-11 22:45:33     96 16 0 0 Unassigned, Nevada, US
2425 2425 90033 Unassigned New Hampshire US 2020-04-11 22:45:33     0 19 0 0 Unassigned, New Hampshire, US
2426 2426 90034 Unassigned New Jersey US 2020-04-11 22:45:33     924 2 0 0 Unassigned, New Jersey, US
2427 2427 90035 Unassigned New Mexico US 2020-04-11 22:45:33     0 0 0 0 Unassigned, New Mexico, US
2428 2428 90036 Unassigned New York US 2020-04-11 22:45:33     0 4 0 0 Unassigned, New York, US
2429 2429 90039 Unassigned Ohio US 2020-04-11 22:45:33     0 0 0 0 Unassigned, Ohio, US
2430 2430 90040 Unassigned Oklahoma US 2020-04-11 22:45:33     0 0 0 0 Unassigned, Oklahoma, US
2431 2431 90042 Unassigned Pennsylvania US 2020-04-11 22:45:33     0 0 0 0 Unassigned, Pennsylvania, US
2432 2432 90044 Unassigned Rhode Island US 2020-04-11 22:45:33     649 19 0 0 Unassigned, Rhode Island, US
2433 2433 90046 Unassigned South Dakota US 2020-04-11 22:45:33     0 0 0 0 Unassigned, South Dakota, US
2434 2434 90047 Unassigned Tennessee US 2020-04-11 22:45:33     19 0 0 0 Unassigned, Tennessee, US
2435 2435 90050 Unassigned Vermont US 2020-04-11 22:45:33     11 0 0 0 Unassigned, Vermont, US
2436 2436 90051 Unassigned Virginia US 2020-04-11 22:45:33     0 91 0 0 Unassigned, Virginia, US
2437 2437 90053 Unassigned Washington US 2020-04-11 22:45:33     848 0 0 0 Unassigned, Washington, US
2438 2438 90054 Unassigned West Virginia US 2020-04-11 22:45:33     0 1 0 0 Unassigned, West Virginia, US
2439 2439 90055 Unassigned Wisconsin US 2020-04-11 22:45:33     0 0 0 0 Unassigned, Wisconsin, US
2440 2440   Unassigned Wyoming US 2020-04-11 22:45:33     0 0 0 0 Unassigned,Wyoming,US
2709 2709     Diamond Princess Canada 2020-04-11 22:52:28     0 1 0 0 Diamond Princess, Canada
2710 2710 88888   Diamond Princess US 2020-04-11 22:45:33     49 0 0 0 Diamond Princess, US
2718 2718     Grand Princess Canada 2020-04-11 22:52:28     13 0 0 0 Grand Princess, Canada
2719 2719 99999   Grand Princess US 2020-04-11 22:45:33     103 3 0 0 Grand Princess, US
2760 2760     Recovered Canada 2020-04-11 22:52:28     0 0 6589 0 Recovered, Canada
2761 2761     Recovered US 2020-04-11 22:45:33     0 0 31270 0 Recovered, US
2830 2830       Diamond Princess 2020-04-11 22:45:13     712 11 619 82 Diamond Princess
2885 2885       MS Zaandam 2020-04-11 22:45:13     9 2 0 7 ,,MS Zaandam
2967 2967   unassigned Utah US 2020-04-11 22:45:33     0 5 0 0 unassigned, Utah, US
2926 2926       Samoa 2020-04-11 22:52:28 -13.759 -172.1046 0 0 0 0 Samoa
171 171 2050 Bethel Alaska US 2020-04-11 22:45:33 60.90980451 -159.8561831 1 0 0 0 Bethel, Alaska, US
1233 1233 15007 Kauai Hawaii US 2020-04-11 22:45:33 22.03935037 -159.5966786 19 0 0 0 Kauai, Hawaii, US
1073 1073 15003 Honolulu Hawaii US 2020-04-11 22:45:33 21.45803166 -157.97121819999995 343 5 0 0 Honolulu, Hawaii, US
1546 1546 15009 Maui Hawaii US 2020-04-11 22:45:33 20.86399628 -156.56890969999995 66 3 0 0 Maui, Hawaii, US
1025 1025 15001 Hawaii Hawaii US 2020-04-11 22:45:33 19.60121157 -155.5210167 31 0 0 0 Hawaii, Hawaii, US
1238 1238 2122 Kenai Peninsula Alaska US 2020-04-11 22:45:33 60.24429722 -151.53888840000005 15 0 0 0 Kenai Peninsula, Alaska, US
2691 2691 2290 Yukon-Koyukuk Alaska US 2020-04-11 22:45:33 65.50815459 -151.39073869999999 1 0 0 0 Yukon-Koyukuk, Alaska, US
1544 1544 2170 Matanuska-Susitna Alaska US 2020-04-11 22:45:33 62.31305045 -149.5741743 10 0 0 0 Matanuska-Susitna, Alaska, US
2714 2714     French Polynesia France 2020-04-11 22:45:13 -17.6797 -149.4068 51 0 0 51 French Polynesia, France
49 49 2020 Anchorage Alaska US 2020-04-11 22:45:33 61.14998174 -149.14269860000005 121 4 0 0 Anchorage, Alaska, US
759 759 2090 Fairbanks North Star Alaska US 2020-04-11 22:45:33 64.80726247 -146.5692662 76 1 0 0 Fairbanks North Star, Alaska, US
2219 2219 2240 Southeast Fairbanks Alaska US 2020-04-11 22:45:33 63.87692095 -143.2127643 1 0 0 0 Southeast Fairbanks, Alaska, US
2783 2783     Yukon Canada 2020-04-11 22:52:28 64.2823 -135.0 8 0 0 0 ,Yukon,Canada
1221 1221 2110 Juneau Alaska US 2020-04-11 22:45:33 58.45031811 -134.200436 15 0 0 0 Juneau, Alaska, US
1983 1983 2198 Prince of Wales-Hyder Alaska US 2020-04-11 22:45:33 55.76261984 -133.0511621 1 0 0 0 Prince of Wales-Hyder, Alaska, US
1894 1894 2195 Petersburg Alaska US 2020-04-11 22:45:33 57.13978948 -132.9540995 2 0 0 0 Petersburg, Alaska, US
1252 1252 2130 Ketchikan Gateway Alaska US 2020-04-11 22:45:33 55.57445008 -130.975561 14 0 0 0 Ketchikan Gateway, Alaska, US
2703 2703     British Columbia Canada 2020-04-11 22:52:28 53.7267 -127.6476 1445 58 0 0 British Columbia, Canada
2751 2751     Northwest Territories Canada 2020-04-11 22:52:28 64.8255 -124.8457 5 0 0 0 ,Northwest Territories,Canada
599 599 41015 Curry Oregon US 2020-04-11 22:45:33 42.45911325 -124.15728200000001 3 0 0 0 Curry, Oregon, US
440 440 53009 Clallam Washington US 2020-04-11 22:45:33 48.04754642 -123.92263190000001 11 0 0 0 Clallam, Washington, US
648 648 6015 Del Norte California US 2020-04-11 22:45:33 41.74228275 -123.89740630000001 2 0 0 0 Del Norte, California, US
1097 1097 6023 Humboldt California US 2020-04-11 22:45:33 40.69923009 -123.876044 50 0 0 0 Humboldt, California, US
1402 1402 41041 Lincoln Oregon US 2020-04-11 22:45:33 44.64252874 -123.86991200000001 4 0 0 0 Lincoln, Oregon, US
924 924 53027 Grays Harbor Washington US 2020-04-11 22:45:33 47.14003705 -123.7820567 8 0 0 0 Grays Harbor, Washington, US
1848 1848 53049 Pacific Washington US 2020-04-11 22:45:33 46.55418369 -123.7285716 1 0 0 0 Pacific, Washington, US
2351 2351 41057 Tillamook Oregon US 2020-04-11 22:45:33 45.46248721 -123.712066 4 0 0 0 Tillamook, Oregon, US
459 459 41007 Clatsop Oregon US 2020-04-11 22:45:33 45.99712889 -123.660711 6 0 0 0 Clatsop, Oregon, US
1189 1189 53031 Jefferson Washington US 2020-04-11 22:45:33 47.75003077 -123.56097040000002 28 0 0 0 Jefferson, Washington, US
1220 1220 41033 Josephine Oregon US 2020-04-11 22:45:33 42.3665549 -123.5561938 17 0 0 0 Josephine, Oregon, US
158 158 41003 Benton Oregon US 2020-04-11 22:45:33 44.49167306 -123.4316987 21 2 0 0 Benton, Oregon, US
2491 2491 53069 Wahkiakum Washington US 2020-04-11 22:45:33 46.29180039999999 -123.4250831 2 0 0 0 Wahkiakum, Washington, US
1950 1950 41053 Polk Oregon US 2020-04-11 22:45:33 44.90322804 -123.4128888 29 1 0 0 Polk, Oregon, US
1590 1590 6045 Mendocino California US 2020-04-11 22:45:33 39.4381191 -123.39113130000001 4 0 0 0 Mendocino, California, US
2675 2675 41071 Yamhill Oregon US 2020-04-11 22:45:33 45.23330449 -123.3086963 28 5 0 0 Yamhill, Oregon, US
1540 1540 53045 Mason Washington US 2020-04-11 22:45:33 47.35007586 -123.1863685 18 0 0 0 Mason, Washington, US
695 695 41019 Douglas Oregon US 2020-04-11 22:45:33 43.27941273 -123.16729099999999 12 0 0 0 Douglas, Oregon, US
2549 2549 41067 Washington Oregon US 2020-04-11 22:45:33 45.55972701 -123.0955257 320 6 0 0 Washington, Oregon, US
522 522 41009 Columbia Oregon US 2020-04-11 22:45:33 45.94464254 -123.08908980000001 10 0 0 0 Columbia, Oregon, US
2114 2114 53055 San Juan Washington US 2020-04-11 22:45:33 48.60182783 -122.96745 13 0 0 0 San Juan, Washington, US
2217 2217 6097 Sonoma California US 2020-04-11 22:45:33 38.52746429 -122.88625060000001 145 2 0 0 Sonoma, California, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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