04-15-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

3,028 rows sorted by Active

✎ 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
2823 2823     Recovered US 2020-04-15 22:56:51     0 0 52096 -52096 Recovered, US
2822 2822     Recovered Canada 2020-04-15 23:04:09     0 0 8966 -8966 Recovered, Canada
2496 2496 90051 Unassigned Virginia US 2020-04-15 22:56:51     0 101 0 -101 Unassigned, Virginia, US
2483 2483 90033 Unassigned New Hampshire US 2020-04-15 22:56:51     0 29 0 -29 Unassigned, New Hampshire, US
2458 2458 90004 Unassigned Arizona US 2020-04-15 22:56:51     0 27 0 -27 Unassigned, Arizona, US
2494 2494 90049 Unassigned Utah US 2020-04-15 22:56:51     0 7 0 -7 Unassigned, Utah, US
2457 2457 90002 Unassigned Alaska US 2020-04-15 22:56:51     0 4 0 -4 Unassigned, Alaska, US
2498 2498 90054 Unassigned West Virginia US 2020-04-15 22:56:51     0 4 0 -4 Unassigned, West Virginia, US
52 52 20003 Anderson Kansas US 2020-04-15 22:56:51 38.21413251 -95.29272815 0 0 0 0 Anderson, Kansas, US
67 67 19007 Appanoose Iowa US 2020-04-15 22:56:51 40.74324454 -92.86865906 1 1 0 0 Appanoose, Iowa, US
132 132 51017 Bath Virginia US 2020-04-15 22:56:51 38.05852573 -79.73912095 0 0 0 0 Bath, Virginia, US
165 165 26019 Benzie Michigan US 2020-04-15 22:56:51 44.63899297 -86.01608482 0 0 0 0 Benzie, Michigan, US
190 190 51021 Bland Virginia US 2020-04-15 22:56:51 37.13128068 -81.13599391 0 0 0 0 Bland, Virginia, US
213 213 16021 Boundary Idaho US 2020-04-15 22:56:51 48.76684761 -116.4630179 0 0 0 0 Boundary, Idaho, US
252 252 46015 Brule South Dakota US 2020-04-15 22:56:51 43.71756379 -99.08118954 0 0 0 0 Brule, South Dakota, US
287 287 46019 Butte South Dakota US 2020-04-15 22:56:51 44.90608745 -103.5079318 0 0 0 0 Butte, South Dakota, US
383 383 31027 Cedar Nebraska US 2020-04-15 22:56:51 42.598885100000004 -97.25311951 0 0 0 0 Cedar, Nebraska, US
433 433 26033 Chippewa Michigan US 2020-04-15 22:56:51 46.29552653 -84.54353449 0 0 0 0 Chippewa, Michigan, US
568 568 20035 Cowley Kansas US 2020-04-15 22:56:51 37.23781842 -96.83776647 1 1 0 0 Cowley, Kansas, US
591 591 47033 Crockett Tennessee US 2020-04-15 22:56:51 35.81830662 -89.14916269 0 0 0 0 Crockett, Tennessee, US
594 594 48107 Crosby Texas US 2020-04-15 22:56:51 33.61431553 -101.30003640000001 1 1 0 0 Crosby, Texas, US
679 679 51051 Dickenson Virginia US 2020-04-15 22:56:51 37.12560977 -82.35124171 0 0 0 0 Dickenson, Virginia, US
759 759 38029 Emmons North Dakota US 2020-04-15 22:56:51 46.28398398 -100.2389766 1 1 0 0 Emmons, North Dakota, US
771 771 51057 Essex Virginia US 2020-04-15 22:56:51 37.93357639 -76.94230311 0 0 0 0 Essex, Virginia, US
777 777 51600 Fairfax City Virginia US 2020-04-15 22:56:51 38.85157547 -77.29779640000002 0 0 0 0 Fairfax City, Virginia, US
783 783 51610 Falls Church Virginia US 2020-04-15 22:56:51 38.88485255 -77.17560759 0 0 0 0 Falls Church, Virginia, US
813 813 21071 Floyd Kentucky US 2020-04-15 22:56:51 37.56213922 -82.74750924 0 0 0 0 Floyd, Kentucky, US
951 951 51077 Grayson Virginia US 2020-04-15 22:56:51 36.65677234 -81.23215889 0 0 0 0 Grayson, Virginia, US
1021 1021 47067 Hancock Tennessee US 2020-04-15 22:56:51 36.52692871 -83.22375847 0 0 0 0 Hancock, Tennessee, US
1080 1080 35023 Hidalgo New Mexico US 2020-04-15 22:56:51 31.91383467 -108.7151824 0 0 0 0 Hidalgo, New Mexico, US
1083 1083 51091 Highland Virginia US 2020-04-15 22:56:51 38.35799465 -79.56124594 0 0 0 0 Highland, Virginia, US
1117 1117 48227 Howard Texas US 2020-04-15 22:56:51 32.30621324 -101.4356444 1 1 0 0 Howard, Texas, US
1267 1267 20093 Kearny Kansas US 2020-04-15 22:56:51 38.00017981 -101.32168100000001 0 0 0 0 Kearny, Kansas, US
1292 1292 46077 Kingsbury South Dakota US 2020-04-15 22:56:51 44.36956169 -97.4913945 0 0 0 0 Kingsbury, South Dakota, US
1404 1404 16061 Lewis Idaho US 2020-04-15 22:56:51 46.23315327 -116.434146 0 0 0 0 Lewis, Idaho, US
1459 1459 31113 Logan Nebraska US 2020-04-15 22:56:51 41.56650314 -100.4817851 0 0 0 0 Logan, Nebraska, US
1571 1571 51690 Martinsville Virginia US 2020-04-15 22:56:51 36.68212094 -79.86352771 0 0 0 0 Martinsville, Virginia, US
1599 1599 38049 McHenry North Dakota US 2020-04-15 22:56:51 48.23104458 -100.6324822 1 1 0 0 McHenry, North Dakota, US
1634 1634 38057 Mercer North Dakota US 2020-04-15 22:56:51 47.31213126 -101.8318399 0 0 0 0 Mercer, North Dakota, US
1721 1721 47127 Moore Tennessee US 2020-04-15 22:56:51 35.27724699 -86.36230578 0 0 0 0 Moore, Tennessee, US
1808 1808 51720 Norton Virginia US 2020-04-15 22:56:51 36.93357076 -82.62750411 0 0 0 0 Norton, Virginia, US
1845 1845 26131 Ontonagon Michigan US 2020-04-15 22:56:51 46.665226200000006 -89.31390481 0 0 0 0 Ontonagon, Michigan, US
1883 1883 80040 Out of OK Oklahoma US 2020-04-15 22:56:51     0 0 0 0 Out of OK, Oklahoma, US
1908 1908 51141 Patrick Virginia US 2020-04-15 22:56:51 36.680163799999995 -80.2865648 0 0 0 0 Patrick, Virginia, US
1925 1925 55091 Pepin Wisconsin US 2020-04-15 22:56:51 44.58307413 -91.99949611 0 0 0 0 Pepin, Wisconsin, US
1980 1980 56031 Platte Wyoming US 2020-04-15 22:56:51 42.13299116 -104.96633100000001 0 0 0 0 Platte, Wyoming, US
2082 2082 47143 Rhea Tennessee US 2020-04-15 22:56:51 35.60536161 -84.93076643 0 0 0 0 Rhea, Tennessee, US
2392 2392 6103 Tehama California US 2020-04-15 22:56:51 40.12570935 -122.23701709999999 1 1 0 0 Tehama, California, US
2401 2401 29215 Texas Missouri US 2020-04-15 22:56:51 37.31728859 -91.96564727 0 0 0 0 Texas, Missouri, US
2460 2460 90006 Unassigned California US 2020-04-15 22:56:51     0 0 0 0 Unassigned, California, US
2467 2467 90016 Unassigned Idaho US 2020-04-15 22:56:51     0 0 0 0 Unassigned, Idaho, US
2469 2469 90018 Unassigned Indiana US 2020-04-15 22:56:51     0 131 0 0 Unassigned, Indiana, US
2470 2470 90019 Unassigned Iowa US 2020-04-15 22:56:51     0 0 0 0 Unassigned, Iowa, US
2471 2471 90020 Unassigned Kansas US 2020-04-15 22:56:51     0 2 0 0 Unassigned, Kansas, US
2478 2478 90028 Unassigned Mississippi US 2020-04-15 22:56:51     0 0 0 0 Unassigned, Mississippi, US
2479 2479 90029 Unassigned Missouri US 2020-04-15 22:56:51     0 0 0 0 Unassigned, Missouri, US
2480 2480 90030 Unassigned Montana US 2020-04-15 22:56:51     0 0 0 0 Unassigned, Montana, US
2485 2485 90035 Unassigned New Mexico US 2020-04-15 22:56:51     0 0 0 0 Unassigned, New Mexico, US
2486 2486 90036 Unassigned New York US 2020-04-15 22:56:51     0 0 0 0 Unassigned, New York, US
2487 2487 90039 Unassigned Ohio US 2020-04-15 22:56:51     0 0 0 0 Unassigned, Ohio, US
2488 2488 90040 Unassigned Oklahoma US 2020-04-15 22:56:51     0 0 0 0 Unassigned, Oklahoma, US
2489 2489 90041 Unassigned Oregon US 2020-04-15 22:56:51     0 0 0 0 Unassigned, Oregon, US
2490 2490 90042 Unassigned Pennsylvania US 2020-04-15 22:56:51     0 0 0 0 Unassigned, Pennsylvania, US
2492 2492 90046 Unassigned South Dakota US 2020-04-15 22:56:51     0 0 0 0 Unassigned, South Dakota, US
2500 2500   Unassigned Wyoming US 2020-04-15 22:56:51     0 0 0 0 Unassigned, Wyoming, US
2782 2782     Greenland Denmark 2020-04-15 22:56:32 71.7069 -42.6043 11 0 11 0 Greenland, Denmark
2786 2786     Guangxi China 2020-04-02 00:16:02 23.8298 108.7881 254 2 252 0 Guangxi, China
2787 2787     Guizhou China 2020-03-18 01:37:43 26.8154 106.8748 146 2 144 0 Guizhou, China
2788 2788     Hainan China 2020-03-24 04:19:14 19.1959 109.7453 168 6 162 0 Hainan, China
2791 2791     Henan China 2020-04-14 00:43:57 33.882 113.61399999999999 1276 22 1254 0 Henan, China
2798 2798     Jiangxi China 2020-04-10 01:22:42 27.614 115.7221 937 1 936 0 Jiangxi, China
2810 2810     Ningxia China 2020-03-16 08:47:05 37.2692 106.1655 75 0 75 0 Ningxia, China
2815 2815     Nunavut Canada 2020-04-15 23:04:09 70.2998 -83.1076 0 0 0 0 Nunavut, Canada
2819 2819     Qinghai China 2020-02-23 11:19:02 35.7452 95.9956 18 0 18 0 Qinghai, China
2826 2826     Saint Helena, Ascension and Tristan da Cunha United Kingdom 2020-04-15 22:56:32 -7.9467 -14.3559 0 0 0 0 Saint Helena, Ascension and Tristan da Cunha, United Kingdom
2839 2839     Tibet China 2020-02-23 11:19:02 31.6927 88.0924 1 0 1 0 Tibet, China
2844 2844     Xinjiang China 2020-03-08 05:31:02 41.1129 85.2401 76 3 73 0 Xinjiang, China
2988 2988       Samoa 2020-04-15 23:04:09 -13.759 -172.1046 0 0 0 0 Samoa
5 5 19001 Adair Iowa US 2020-04-15 22:56:51 41.33075609 -94.47105874 1 0 0 1 Adair, Iowa, US
10 10 16003 Adams Idaho US 2020-04-15 22:56:51 44.89333571 -116.4545247 1 0 0 1 Adams, Idaho, US
28 28 26001 Alcona Michigan US 2020-04-15 22:56:51 44.6846864 -83.59507875 1 0 0 1 Alcona, Michigan, US
32 32 40003 Alfalfa Oklahoma US 2020-04-15 22:56:51 36.73090616 -98.32408495 1 0 0 1 Alfalfa, Oklahoma, US
45 45 26007 Alpena Michigan US 2020-04-15 22:56:51 45.03477666 -83.62212411 1 0 0 1 Alpena, Michigan, US
57 57 29003 Andrew Missouri US 2020-04-15 22:56:51 39.98492163 -94.80163024 1 0 0 1 Andrew, Missouri, US
64 64 31003 Antelope Nebraska US 2020-04-15 22:56:51 42.17695516 -98.06662829999999 1 0 0 1 Antelope, Nebraska, US
77 77 48011 Armstrong Texas US 2020-04-15 22:56:51 34.96507426 -101.35748740000001 1 0 0 1 Armstrong, Texas, US
93 93 40005 Atoka Oklahoma US 2020-04-15 22:56:51 34.37366573 -96.03802487 1 0 0 1 Atoka, Oklahoma, US
95 95 19009 Audubon Iowa US 2020-04-15 22:56:51 41.6844628 -94.90581859 1 0 0 1 Audubon, Iowa, US
98 98 46003 Aurora South Dakota US 2020-04-15 22:56:51 43.71757685 -98.56050467 1 0 0 1 Aurora, South Dakota, US
115 115 20007 Barber Kansas US 2020-04-15 22:56:51 37.2288586 -98.68460053 1 0 0 1 Barber, Kansas, US
141 141 40007 Beaver Oklahoma US 2020-04-15 22:56:51 36.7496847 -100.4758872 1 0 0 1 Beaver, Oklahoma, US
143 143 30001 Beaverhead Montana US 2020-04-15 22:56:51 45.13434354 -112.89846940000001 1 0 0 1 Beaverhead, Montana, US
144 144 27005 Becker Minnesota US 2020-04-15 22:56:51 46.93479392 -95.67158144 1 0 0 1 Becker, Minnesota, US
159 159 27009 Benton Minnesota US 2020-04-15 22:56:51 45.69804958 -93.99514135 1 0 0 1 Benton, Minnesota, US
175 175 2050 Bethel Alaska US 2020-04-15 22:56:51 60.90980451 -159.8561831 1 0 0 1 Bethel, Alaska, US
181 181 56003 Big Horn Wyoming US 2020-04-15 22:56:51 44.52405055 -107.9960365 1 0 0 1 Big Horn, Wyoming, US
182 182 27011 Big Stone Minnesota US 2020-04-15 22:56:51 45.42712824 -96.41403739 1 0 0 1 Big Stone, Minnesota, US
208 208 54005 Boone West Virginia US 2020-04-15 22:56:51 38.01974191 -81.69888019 1 0 0 1 Boone, West Virginia, US
209 209 48035 Bosque Texas US 2020-04-15 22:56:51 31.89978581 -97.63613524 1 0 0 1 Bosque, Texas, US
217 217 38011 Bowman North Dakota US 2020-04-15 22:56:51 46.11285362 -103.5203343 1 0 0 1 Bowman, North Dakota, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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