time_series_covid19_deaths_global
Data source: Big Local News · About: big-local-datasette
3 rows where 3/15/20 = 7
This data as json, copyable, CSV (advanced)
Suggested facets: Province/State, 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/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/13/20, 3/14/20, 3/16/20, 3/17/20, 3/18/20, 3/19/20, 3/20/20
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 81 | 81 | Shandong | China | 36.3427 | 118.1498 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 2 | 2 | 2 | 2 | 2 | 2 | 3 | 3 | 4 | 4 | 4 | 4 | 5 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 |
| 103 | 103 | Diamond Princess | 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 | 0 | 0 | 0 | 0 | 0 | 2 | 2 | 2 | 3 | 3 | 3 | 4 | 4 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 8 | 8 | 8 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 11 | 11 | 11 | 11 | 11 | 11 | 11 | 11 | 11 | 11 | 11 | 11 | 11 | 12 | 12 | 12 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | |
| 231 | 231 | Sweden | 60.128161 | 18.643501 | 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 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 2 | 3 | 5 | 7 | 8 | 14 | 21 | 30 | 38 | 49 | 60 | 81 | 103 | 134 | 166 | 201 | 239 | 284 | 332 | 385 | 455 | 535 | 605 | 690 | 780 | 864 | 979 | 1065 | 1155 | 1258 | 1355 | 1440 | 1531 | 1646 | 1757 | 1839 | 1925 | 2013 | 2097 | 2159 | 2236 | 2322 | 2411 | 2484 | 2559 | 2632 | 2714 | 2798 | 2876 | 2954 | 3027 | 3102 | 3186 | 3258 | 3331 | 3411 | 3471 | 3540 | 3614 | 3678 | 3739 | 3789 | 3835 | 3893 | 3942 | 3995 | 4056 | 4096 | 4150 | 4204 | 4260 | 4316 | 4360 | 4402 | 4430 | 4469 | 4509 | 4549 | 4588 | 4633 | 4673 | 4710 | 4736 | 4781 | 4819 | 4850 | 4883 | 4921 | 4954 | 4994 | 5030 | 5060 | 5093 | 5120 | 5151 | 5179 | 5212 | 5241 | 5270 | 5299 | 5320 | 5341 | 5366 | 5388 | 5412 | 5424 | 5438 | 5460 | 5478 | 5498 | 5515 | 5530 | 5538 | 5553 | 5562 | 5578 | 5590 | 5601 | 5616 | 5630 | 5641 | 5650 | 5664 | 5672 | 5678 | 5686 | 5694 | 5705 | 5715 | 5722 | 5729 | 5736 | 5742 | 5746 | 5747 | 5749 | 5755 | 5759 | 5760 | 5760 | 5763 | 5766 | 5767 | 5772 | 5774 | 5775 | 5780 | 5783 | 5785 | 5789 | 5791 | 5795 | 5798 | 5803 | 5803 | 5804 | 5804 | 5806 | 5812 | 5813 | 5814 | 5815 | 5816 | 5816 | 5816 | 5816 | 5816 | 5816 | 5820 | 5821 | 5821 | 5821 | 5808 | 5813 | 5820 | 5832 | 5835 | 5835 | 5835 | 5837 | 5838 | 5842 | 5843 | 5846 | 5846 | 5846 | 5846 | 5851 | 5860 | 5864 | 5865 | 5865 | 5865 | 5865 | 5870 | 5876 | 5878 | 5880 | 5880 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [time_series_covid19_deaths_global] ( [Province/State] TEXT, [Country/Region] TEXT, [Lat] TEXT, [Long] TEXT, [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 );