time_series_covid19_deaths_global

Table actions
Big Local News snapshots this data once a day from The Johns Hopkins University Center for Systems Science and Engineering. These are time series reports which provide cases, deaths and recovered for global locations as well as United States counties. Each file covers from Jan 22 to the present. For the United States there is one file for cases and one for deaths. For the global locations, there is one file for cases, one for deaths and one for recovered cases. The entire set of CSV files are refreshed daily. The zipped archives contain previous time series 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: big-local-datasette

1 row where 3/10/20 = 291

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link rowid â–¼ Province/State Country/Region Lat Long 1/22/20 1/23/20 1/24/20 1/25/20 1/26/20 1/27/20 1/28/20 1/29/20 1/30/20 1/31/20 2/1/20 2/2/20 2/3/20 2/4/20 2/5/20 2/6/20 2/7/20 2/8/20 2/9/20 2/10/20 2/11/20 2/12/20 2/13/20 2/14/20 2/15/20 2/16/20 2/17/20 2/18/20 2/19/20 2/20/20 2/21/20 2/22/20 2/23/20 2/24/20 2/25/20 2/26/20 2/27/20 2/28/20 2/29/20 3/1/20 3/2/20 3/3/20 3/4/20 3/5/20 3/6/20 3/7/20 3/8/20 3/9/20 3/10/20 3/11/20 3/12/20 3/13/20 3/14/20 3/15/20 3/16/20 3/17/20 3/18/20 3/19/20 3/20/20 3/21/20 3/22/20 3/23/20 3/24/20 3/25/20 3/26/20 3/27/20 3/28/20 3/29/20 3/30/20 3/31/20 4/1/20 4/2/20 4/3/20 4/4/20 4/5/20 4/6/20 4/7/20 4/8/20 4/9/20 4/10/20 4/11/20 4/12/20 4/13/20 4/14/20 4/15/20 4/16/20 4/17/20 4/18/20 4/19/20 4/20/20 4/21/20 4/22/20 4/23/20 4/24/20 4/25/20 4/26/20 4/27/20 4/28/20 4/29/20 4/30/20 5/1/20 5/2/20 5/3/20 5/4/20 5/5/20 5/6/20 5/7/20 5/8/20 5/9/20 5/10/20 5/11/20 5/12/20 5/13/20 5/14/20 5/15/20 5/16/20 5/17/20 5/18/20 5/19/20 5/20/20 5/21/20 5/22/20 5/23/20 5/24/20 5/25/20 5/26/20 5/27/20 5/28/20 5/29/20 5/30/20 5/31/20 6/1/20 6/2/20 6/3/20 6/4/20 6/5/20 6/6/20 6/7/20 6/8/20 6/9/20 6/10/20 6/11/20 6/12/20 6/13/20 6/14/20 6/15/20 6/16/20 6/17/20 6/18/20 6/19/20 6/20/20 6/21/20 6/22/20 6/23/20 6/24/20 6/25/20 6/26/20 6/27/20 6/28/20 6/29/20 6/30/20 7/1/20 7/2/20 7/3/20 7/4/20 7/5/20 7/6/20 7/7/20 7/8/20 7/9/20 7/10/20 7/11/20 7/12/20 7/13/20 7/14/20 7/15/20 7/16/20 7/17/20 7/18/20 7/19/20 7/20/20 7/21/20 7/22/20 7/23/20 7/24/20 7/25/20 7/26/20 7/27/20 7/28/20 7/29/20 7/30/20 7/31/20 8/1/20 8/2/20 8/3/20 8/4/20 8/5/20 8/6/20 8/7/20 8/8/20 8/9/20 8/10/20 8/11/20 8/12/20 8/13/20 8/14/20 8/15/20 8/16/20 8/17/20 8/18/20 8/19/20 8/20/20 8/21/20 8/22/20 8/23/20 8/24/20 8/25/20 8/26/20 8/27/20 8/28/20 8/29/20 8/30/20 8/31/20 9/1/20 9/2/20 9/3/20 9/4/20 9/5/20 9/6/20 9/7/20 9/8/20 9/9/20 9/10/20 9/11/20 9/12/20 9/13/20 9/14/20 9/15/20 9/16/20 9/17/20 9/18/20 9/19/20 9/20/20 9/21/20 9/22/20 9/23/20 9/24/20 9/25/20 9/26/20 9/27/20 9/28/20 9/29/20 9/30/20 10/1/20 10/2/20 10/3/20 10/4/20 10/5/20 10/6/20 10/7/20 10/8/20 10/9/20 10/10/20 10/11/20 10/12/20 10/13/20 10/14/20 10/15/20 10/16/20 10/17/20 10/18/20 10/19/20 10/20/20 10/21/20 10/22/20 10/23/20 10/24/20 10/25/20 10/26/20 10/27/20 10/28/20 10/29/20 10/30/20 10/31/20 11/1/20 11/2/20 11/3/20 11/4/20 11/5/20 11/6/20 11/7/20 11/8/20 11/9/20 11/10/20 11/11/20 11/12/20 11/13/20 11/14/20 11/15/20 11/16/20 11/17/20 11/18/20 11/19/20 11/20/20 11/21/20 11/22/20 11/23/20 11/24/20 11/25/20 11/26/20 11/27/20 11/28/20 11/29/20 11/30/20 12/1/20 12/2/20 12/3/20 12/4/20 12/5/20 12/6/20 12/7/20 12/8/20 12/9/20 12/10/20 12/11/20 12/12/20 12/13/20 12/14/20 12/15/20 12/16/20 12/17/20 12/18/20 12/19/20 12/20/20 12/21/20 12/22/20 12/23/20 12/24/20 12/25/20 12/26/20 12/27/20 12/28/20 12/29/20 12/30/20 12/31/20 1/1/21 1/2/21 1/3/21 1/4/21 1/5/21 1/6/21 1/7/21 1/8/21 1/9/21 1/10/21 1/11/21 1/12/21 1/13/21 1/14/21 1/15/21 1/16/21 1/17/21 1/18/21 1/19/21 1/20/21 1/21/21 1/22/21 1/23/21 1/24/21 1/25/21 1/26/21 1/27/21 1/28/21 1/29/21 1/30/21 1/31/21 2/1/21 2/2/21 2/3/21 2/4/21 2/5/21 2/6/21 2/7/21 2/8/21 2/9/21 2/10/21 2/11/21 2/12/21 2/13/21 2/14/21 2/15/21 2/16/21 2/17/21 2/18/21 2/19/21 2/20/21 2/21/21 2/22/21 2/23/21 2/24/21 2/25/21 2/26/21 2/27/21 2/28/21
149 149   Iran 32.427908 53.688046 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 2 4 5 8 12 16 19 26 34 43 54 66 77 92 107 124 145 194 237 291 354 429 514 611 724 853 988 1135 1284 1433 1556 1685 1812 1934 2077 2234 2378 2517 2640 2757 2898 3036 3160 3294 3452 3603 3739 3872 3993 4110 4232 4357 4474 4585 4683 4777 4869 4958 5031 5118 5209 5297 5391 5481 5574 5650 5710 5806 5877 5957 6028 6091 6156 6203 6277 6340 6418 6486 6541 6589 6640 6685 6733 6783 6854 6902 6937 6988 7057 7119 7183 7249 7300 7359 7417 7451 7508 7564 7627 7677 7734 7797 7878 7942 8012 8071 8134 8209 8281 8351 8425 8506 8584 8659 8730 8837 8950 9065 9185 9272 9392 9507 9623 9742 9863 9996 10130 10239 10364 10508 10670 10817 10958 11106 11260 11408 11571 11731 11931 12084 12305 12447 12635 12829 13032 13211 13410 13608 13791 13979 14188 14405 14634 14853 15074 15289 15484 15700 15912 16147 16343 16569 16766 16982 17190 17405 17617 17802 17976 18132 18264 18427 18616 18800 18988 19162 19331 19492 19639 19804 19972 20125 20264 20376 20502 20643 20776 20901 21020 21137 21249 21359 21462 21571 21672 21797 21926 22044 22154 22293 22410 22542 22669 22798 22913 23029 23157 23313 23453 23632 23808 23952 24118 24301 24478 24656 24840 25015 25222 25394 25589 25779 25986 26169 26380 26567 26746 26957 27192 27419 27658 27888 28098 28293 28544 28816 29070 29349 29605 29870 30123 30375 30712 31034 31346 31650 31985 32320 32616 32953 33299 33714 34113 34478 34864 35298 35738 36160 36579 36985 37409 37832 38291 38749 39202 39664 40121 40582 41034 41493 41979 42461 42941 43417 43896 44327 44802 45255 45738 46207 46689 47095 47486 47874 48246 48628 48990 49348 49695 50016 50310 50594 50917 51212 51496 51727 51949 52196 52447 52670 52883 53095 53273 53448 53625 53816 54003 54156 54308 54440 54574 54693 54814 54946 55095 55223 55337 55438 55540 55650 55748 55830 55933 56018 56100 56171 56262 56360 56457 56538 56621 56717 56803 56886 56973 57057 57150 57225 57294 57383 57481 57560 57651 57736 57807 57889 57959 58038 58110 58189 58256 58336 58412 58469 58536 58625 58686 58751 58809 58883 58945 59028 59117 59184 59264 59341 59409 59483 59572 59663 59736 59830 59899 59980 60073

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [time_series_covid19_deaths_global] (
   [Province/State] TEXT,
   [Country/Region] TEXT,
   [Lat] FLOAT,
   [Long] FLOAT,
   [1/22/20] INTEGER,
   [1/23/20] INTEGER,
   [1/24/20] INTEGER,
   [1/25/20] INTEGER,
   [1/26/20] INTEGER,
   [1/27/20] INTEGER,
   [1/28/20] INTEGER,
   [1/29/20] INTEGER,
   [1/30/20] INTEGER,
   [1/31/20] INTEGER,
   [2/1/20] INTEGER,
   [2/2/20] INTEGER,
   [2/3/20] INTEGER,
   [2/4/20] INTEGER,
   [2/5/20] INTEGER,
   [2/6/20] INTEGER,
   [2/7/20] INTEGER,
   [2/8/20] INTEGER,
   [2/9/20] INTEGER,
   [2/10/20] INTEGER,
   [2/11/20] INTEGER,
   [2/12/20] INTEGER,
   [2/13/20] INTEGER,
   [2/14/20] INTEGER,
   [2/15/20] INTEGER,
   [2/16/20] INTEGER,
   [2/17/20] INTEGER,
   [2/18/20] INTEGER,
   [2/19/20] INTEGER,
   [2/20/20] INTEGER,
   [2/21/20] INTEGER,
   [2/22/20] INTEGER,
   [2/23/20] INTEGER,
   [2/24/20] INTEGER,
   [2/25/20] INTEGER,
   [2/26/20] INTEGER,
   [2/27/20] INTEGER,
   [2/28/20] INTEGER,
   [2/29/20] INTEGER,
   [3/1/20] INTEGER,
   [3/2/20] INTEGER,
   [3/3/20] INTEGER,
   [3/4/20] INTEGER,
   [3/5/20] INTEGER,
   [3/6/20] INTEGER,
   [3/7/20] INTEGER,
   [3/8/20] INTEGER,
   [3/9/20] INTEGER,
   [3/10/20] INTEGER,
   [3/11/20] INTEGER,
   [3/12/20] INTEGER,
   [3/13/20] INTEGER,
   [3/14/20] INTEGER,
   [3/15/20] INTEGER,
   [3/16/20] INTEGER,
   [3/17/20] INTEGER,
   [3/18/20] INTEGER,
   [3/19/20] INTEGER,
   [3/20/20] INTEGER,
   [3/21/20] INTEGER,
   [3/22/20] INTEGER,
   [3/23/20] INTEGER,
   [3/24/20] INTEGER,
   [3/25/20] INTEGER,
   [3/26/20] INTEGER,
   [3/27/20] INTEGER,
   [3/28/20] INTEGER,
   [3/29/20] INTEGER,
   [3/30/20] INTEGER,
   [3/31/20] INTEGER,
   [4/1/20] INTEGER,
   [4/2/20] INTEGER,
   [4/3/20] INTEGER,
   [4/4/20] INTEGER,
   [4/5/20] INTEGER,
   [4/6/20] INTEGER,
   [4/7/20] INTEGER,
   [4/8/20] INTEGER,
   [4/9/20] INTEGER,
   [4/10/20] INTEGER,
   [4/11/20] INTEGER,
   [4/12/20] INTEGER,
   [4/13/20] INTEGER,
   [4/14/20] INTEGER,
   [4/15/20] INTEGER,
   [4/16/20] INTEGER,
   [4/17/20] INTEGER,
   [4/18/20] INTEGER,
   [4/19/20] INTEGER,
   [4/20/20] INTEGER,
   [4/21/20] INTEGER,
   [4/22/20] INTEGER,
   [4/23/20] INTEGER,
   [4/24/20] INTEGER,
   [4/25/20] INTEGER,
   [4/26/20] INTEGER,
   [4/27/20] INTEGER,
   [4/28/20] INTEGER,
   [4/29/20] INTEGER,
   [4/30/20] INTEGER,
   [5/1/20] INTEGER,
   [5/2/20] INTEGER,
   [5/3/20] INTEGER,
   [5/4/20] INTEGER,
   [5/5/20] INTEGER,
   [5/6/20] INTEGER,
   [5/7/20] INTEGER,
   [5/8/20] INTEGER,
   [5/9/20] INTEGER,
   [5/10/20] INTEGER,
   [5/11/20] INTEGER,
   [5/12/20] INTEGER,
   [5/13/20] INTEGER,
   [5/14/20] INTEGER,
   [5/15/20] INTEGER,
   [5/16/20] INTEGER,
   [5/17/20] INTEGER,
   [5/18/20] INTEGER,
   [5/19/20] INTEGER,
   [5/20/20] INTEGER,
   [5/21/20] INTEGER,
   [5/22/20] INTEGER,
   [5/23/20] INTEGER,
   [5/24/20] INTEGER,
   [5/25/20] INTEGER,
   [5/26/20] INTEGER,
   [5/27/20] INTEGER,
   [5/28/20] INTEGER,
   [5/29/20] INTEGER,
   [5/30/20] INTEGER,
   [5/31/20] INTEGER,
   [6/1/20] INTEGER,
   [6/2/20] INTEGER,
   [6/3/20] INTEGER,
   [6/4/20] INTEGER,
   [6/5/20] INTEGER,
   [6/6/20] INTEGER,
   [6/7/20] INTEGER,
   [6/8/20] INTEGER,
   [6/9/20] INTEGER,
   [6/10/20] INTEGER,
   [6/11/20] INTEGER,
   [6/12/20] INTEGER,
   [6/13/20] INTEGER,
   [6/14/20] INTEGER,
   [6/15/20] INTEGER,
   [6/16/20] INTEGER,
   [6/17/20] INTEGER,
   [6/18/20] INTEGER,
   [6/19/20] INTEGER,
   [6/20/20] INTEGER,
   [6/21/20] INTEGER,
   [6/22/20] INTEGER,
   [6/23/20] INTEGER,
   [6/24/20] INTEGER,
   [6/25/20] INTEGER,
   [6/26/20] INTEGER,
   [6/27/20] INTEGER,
   [6/28/20] INTEGER,
   [6/29/20] INTEGER,
   [6/30/20] INTEGER,
   [7/1/20] INTEGER,
   [7/2/20] INTEGER,
   [7/3/20] INTEGER,
   [7/4/20] INTEGER,
   [7/5/20] INTEGER,
   [7/6/20] INTEGER,
   [7/7/20] INTEGER,
   [7/8/20] INTEGER,
   [7/9/20] INTEGER,
   [7/10/20] INTEGER,
   [7/11/20] INTEGER,
   [7/12/20] INTEGER,
   [7/13/20] INTEGER,
   [7/14/20] INTEGER,
   [7/15/20] INTEGER,
   [7/16/20] INTEGER,
   [7/17/20] INTEGER,
   [7/18/20] INTEGER,
   [7/19/20] INTEGER,
   [7/20/20] INTEGER,
   [7/21/20] INTEGER,
   [7/22/20] INTEGER,
   [7/23/20] INTEGER,
   [7/24/20] INTEGER,
   [7/25/20] INTEGER,
   [7/26/20] INTEGER,
   [7/27/20] INTEGER,
   [7/28/20] INTEGER,
   [7/29/20] INTEGER,
   [7/30/20] INTEGER,
   [7/31/20] INTEGER,
   [8/1/20] INTEGER,
   [8/2/20] INTEGER,
   [8/3/20] INTEGER,
   [8/4/20] INTEGER,
   [8/5/20] INTEGER,
   [8/6/20] INTEGER,
   [8/7/20] INTEGER,
   [8/8/20] INTEGER,
   [8/9/20] INTEGER,
   [8/10/20] INTEGER,
   [8/11/20] INTEGER,
   [8/12/20] INTEGER,
   [8/13/20] INTEGER,
   [8/14/20] INTEGER,
   [8/15/20] INTEGER,
   [8/16/20] INTEGER,
   [8/17/20] INTEGER,
   [8/18/20] INTEGER,
   [8/19/20] INTEGER,
   [8/20/20] INTEGER,
   [8/21/20] INTEGER,
   [8/22/20] INTEGER,
   [8/23/20] INTEGER,
   [8/24/20] INTEGER,
   [8/25/20] INTEGER,
   [8/26/20] INTEGER,
   [8/27/20] INTEGER,
   [8/28/20] INTEGER,
   [8/29/20] INTEGER,
   [8/30/20] INTEGER,
   [8/31/20] INTEGER,
   [9/1/20] INTEGER,
   [9/2/20] INTEGER,
   [9/3/20] INTEGER,
   [9/4/20] INTEGER,
   [9/5/20] INTEGER,
   [9/6/20] INTEGER,
   [9/7/20] INTEGER,
   [9/8/20] INTEGER,
   [9/9/20] INTEGER,
   [9/10/20] INTEGER,
   [9/11/20] INTEGER,
   [9/12/20] INTEGER,
   [9/13/20] INTEGER,
   [9/14/20] INTEGER,
   [9/15/20] INTEGER,
   [9/16/20] INTEGER,
   [9/17/20] INTEGER,
   [9/18/20] INTEGER,
   [9/19/20] INTEGER,
   [9/20/20] INTEGER,
   [9/21/20] INTEGER,
   [9/22/20] INTEGER,
   [9/23/20] INTEGER,
   [9/24/20] INTEGER,
   [9/25/20] INTEGER,
   [9/26/20] INTEGER,
   [9/27/20] INTEGER,
   [9/28/20] INTEGER,
   [9/29/20] INTEGER,
   [9/30/20] INTEGER,
   [10/1/20] INTEGER,
   [10/2/20] INTEGER,
   [10/3/20] INTEGER,
   [10/4/20] INTEGER,
   [10/5/20] INTEGER,
   [10/6/20] INTEGER,
   [10/7/20] INTEGER,
   [10/8/20] INTEGER,
   [10/9/20] INTEGER,
   [10/10/20] INTEGER,
   [10/11/20] INTEGER,
   [10/12/20] INTEGER,
   [10/13/20] INTEGER,
   [10/14/20] INTEGER,
   [10/15/20] INTEGER,
   [10/16/20] INTEGER,
   [10/17/20] INTEGER,
   [10/18/20] INTEGER,
   [10/19/20] INTEGER,
   [10/20/20] INTEGER,
   [10/21/20] INTEGER,
   [10/22/20] INTEGER,
   [10/23/20] INTEGER,
   [10/24/20] INTEGER,
   [10/25/20] INTEGER,
   [10/26/20] INTEGER,
   [10/27/20] INTEGER,
   [10/28/20] INTEGER,
   [10/29/20] INTEGER,
   [10/30/20] INTEGER,
   [10/31/20] INTEGER,
   [11/1/20] INTEGER,
   [11/2/20] INTEGER,
   [11/3/20] INTEGER,
   [11/4/20] INTEGER,
   [11/5/20] INTEGER,
   [11/6/20] INTEGER,
   [11/7/20] INTEGER,
   [11/8/20] INTEGER,
   [11/9/20] INTEGER,
   [11/10/20] INTEGER,
   [11/11/20] INTEGER,
   [11/12/20] INTEGER,
   [11/13/20] INTEGER,
   [11/14/20] INTEGER,
   [11/15/20] INTEGER,
   [11/16/20] INTEGER,
   [11/17/20] INTEGER,
   [11/18/20] INTEGER,
   [11/19/20] INTEGER,
   [11/20/20] INTEGER,
   [11/21/20] INTEGER,
   [11/22/20] INTEGER,
   [11/23/20] INTEGER,
   [11/24/20] INTEGER,
   [11/25/20] INTEGER,
   [11/26/20] INTEGER,
   [11/27/20] INTEGER,
   [11/28/20] INTEGER,
   [11/29/20] INTEGER,
   [11/30/20] INTEGER,
   [12/1/20] INTEGER,
   [12/2/20] INTEGER,
   [12/3/20] INTEGER,
   [12/4/20] INTEGER,
   [12/5/20] INTEGER,
   [12/6/20] INTEGER,
   [12/7/20] INTEGER,
   [12/8/20] INTEGER,
   [12/9/20] INTEGER,
   [12/10/20] INTEGER,
   [12/11/20] INTEGER,
   [12/12/20] INTEGER,
   [12/13/20] INTEGER,
   [12/14/20] INTEGER,
   [12/15/20] INTEGER,
   [12/16/20] INTEGER,
   [12/17/20] INTEGER,
   [12/18/20] INTEGER,
   [12/19/20] INTEGER,
   [12/20/20] INTEGER,
   [12/21/20] INTEGER,
   [12/22/20] INTEGER,
   [12/23/20] INTEGER,
   [12/24/20] INTEGER,
   [12/25/20] INTEGER,
   [12/26/20] INTEGER,
   [12/27/20] INTEGER,
   [12/28/20] INTEGER,
   [12/29/20] INTEGER,
   [12/30/20] INTEGER,
   [12/31/20] INTEGER,
   [1/1/21] INTEGER,
   [1/2/21] INTEGER,
   [1/3/21] INTEGER,
   [1/4/21] INTEGER,
   [1/5/21] INTEGER,
   [1/6/21] INTEGER,
   [1/7/21] INTEGER,
   [1/8/21] INTEGER,
   [1/9/21] INTEGER,
   [1/10/21] INTEGER,
   [1/11/21] INTEGER,
   [1/12/21] INTEGER,
   [1/13/21] INTEGER,
   [1/14/21] INTEGER,
   [1/15/21] INTEGER,
   [1/16/21] INTEGER,
   [1/17/21] INTEGER,
   [1/18/21] INTEGER,
   [1/19/21] INTEGER,
   [1/20/21] INTEGER,
   [1/21/21] INTEGER,
   [1/22/21] INTEGER,
   [1/23/21] INTEGER,
   [1/24/21] INTEGER,
   [1/25/21] INTEGER,
   [1/26/21] INTEGER,
   [1/27/21] INTEGER,
   [1/28/21] INTEGER,
   [1/29/21] INTEGER,
   [1/30/21] INTEGER,
   [1/31/21] INTEGER,
   [2/1/21] INTEGER,
   [2/2/21] INTEGER,
   [2/3/21] INTEGER,
   [2/4/21] INTEGER,
   [2/5/21] INTEGER,
   [2/6/21] INTEGER,
   [2/7/21] INTEGER,
   [2/8/21] INTEGER,
   [2/9/21] INTEGER,
   [2/10/21] INTEGER,
   [2/11/21] INTEGER,
   [2/12/21] INTEGER,
   [2/13/21] INTEGER,
   [2/14/21] INTEGER,
   [2/15/21] INTEGER,
   [2/16/21] INTEGER,
   [2/17/21] INTEGER,
   [2/18/21] INTEGER,
   [2/19/21] INTEGER,
   [2/20/21] INTEGER,
   [2/21/21] INTEGER,
   [2/22/21] INTEGER,
   [2/23/21] INTEGER,
   [2/24/21] INTEGER,
   [2/25/21] INTEGER,
   [2/26/21] INTEGER,
   [2/27/21] INTEGER,
   [2/28/21] INTEGER
);