time_series_covid19_confirmed_global
Data source: Big Local News · About: big-local-datasette
2 rows where 1/26/20 = 1 and 2/26/20 = 4
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15 | 15 | Victoria | Australia | -37.8136 | 144.9631 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 2 | 3 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 7 | 7 | 9 | 9 | 10 | 10 | 10 | 11 | 11 | 15 | 18 | 21 | 21 | 36 | 49 | 57 | 71 | 94 | 121 | 121 | 121 | 229 | 355 | 355 | 411 | 466 | 520 | 574 | 685 | 769 | 821 | 917 | 968 | 1036 | 1085 | 1115 | 1135 | 1158 | 1191 | 1212 | 1228 | 1241 | 1265 | 1268 | 1281 | 1291 | 1299 | 1299 | 1302 | 1319 | 1328 | 1329 | 1336 | 1336 | 1337 | 1343 | 1346 | 1349 | 1349 | 1354 | 1361 | 1364 | 1371 | 1384 | 1406 | 1423 | 1440 | 1454 | 1467 | 1468 | 1487 | 1496 | 1511 | 1514 | 1521 | 1540 | 1551 | 1558 | 1564 | 1573 | 1573 | 1581 | 1593 | 1593 | 1603 | 1605 | 1610 | 1618 | 1628 | 1634 | 1645 | 1649 | 1653 | 1663 | 1670 | 1678 | 1681 | 1681 | 1685 | 1687 | 1687 | 1691 | 1699 | 1703 | 1703 | 1720 | 1732 | 1741 | 1762 | 1780 | 1792 | 1792 | 1836 | 1847 | 1864 | 1884 | 1917 | 1947 | 1947 | 2028 | 2099 | 2159 | 2231 | 2303 | 2368 | 2368 | 2536 | 2660 | 2824 | 2942 | 3098 | 3397 | 3560 | 3799 | 3967 | 4224 | 4448 | 4750 | 5165 | 5353 | 5696 | 5942 | 6289 | 6739 | 7125 | 7405 | 7744 | 8181 | 8696 | 9049 | 9304 | 9998 | 10577 | 10931 | 11557 | 11937 | 12335 | 13035 | 13469 | 13867 | 14283 | 14659 | 14957 | 15251 | 15646 | 15863 | 16234 | 16517 | 16764 | 17027 | 17238 | 17446 | 17683 | 17852 | 18029 | 18231 | 18330 | 18464 | 18608 | 18714 | 18822 | 18903 | 19015 | 19080 | 19138 | 19224 | 19336 | 19415 | 19479 | 19538 | 19574 | 19615 | 19688 | 19739 | 19767 | 19800 | 19835 | 19872 | 19911 | 19943 | 19970 | 20012 | 20034 | 20042 | 20051 | 20076 | 20100 | 20105 | 20118 | 20130 | 20145 |
| 49 | 49 | Ontario | Canada | 51.2538 | -85.3232 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 4 | 4 | 4 | 6 | 6 | 11 | 15 | 18 | 20 | 20 | 22 | 25 | 28 | 29 | 34 | 36 | 41 | 42 | 74 | 79 | 104 | 177 | 185 | 221 | 257 | 308 | 377 | 425 | 503 | 588 | 688 | 858 | 994 | 1144 | 1355 | 1706 | 1966 | 2392 | 2793 | 3255 | 3630 | 4354 | 4347 | 4726 | 5276 | 5759 | 6237 | 6648 | 7049 | 7470 | 7953 | 8447 | 9840 | 10456 | 11013 | 11561 | 12063 | 12715 | 13718 | 14068 | 14550 | 15012 | 15568 | 15970 | 16500 | 16978 | 17395 | 17880 | 18321 | 18574 | 19097 | 19468 | 19910 | 20388 | 20826 | 21148 | 21469 | 21817 | 22158 | 22516 | 22865 | 23258 | 23645 | 23974 | 24286 | 24755 | 25197 | 25595 | 26085 | 26560 | 26897 | 27302 | 27624 | 27943 | 28320 | 28700 | 29023 | 29390 | 29845 | 30259 | 30603 | 30946 | 31359 | 31620 | 32096 | 32395 | 32678 | 32936 | 33173 | 33378 | 33625 | 33806 | 33986 | 34174 | 34382 | 34574 | 34780 | 35044 | 35217 | 35418 | 35657 | 35861 | 36046 | 36151 | 36322 | 36597 | 36823 | 36961 | 37085 | 37242 | 37407 | 37525 | 37653 | 37829 | 37917 | 38079 | 38200 | 38323 | 38398 | 38481 | 38730 | 38814 | 38918 | 39043 | 39164 | 39316 | 39434 | 39553 | 39718 | 39824 | 39936 | 40341 | 40457 | 40558 | 40673 | 40787 | 40873 | 40953 | 41178 | 41257 | 41333 | 41391 | 41495 | 41560 | 41635 | 41815 | 41894 | 41962 | 42082 | 42162 | 42233 | 42313 | 42412 | 42501 | 42563 | 42686 | 42800 | 42890 | 42983 | 43126 | 43218 | 43323 | 43454 | 43541 | 43658 | 43801 | 43919 | 44045 | 44143 | 44279 | 44418 | 44572 | 44720 | 44852 | 45019 | 45156 | 45314 | 45545 | 45724 | 45887 | 46118 | 46323 | 46485 | 46905 | 47165 | 47488 | 47688 | 48219 | 48317 | 48950 | 49442 | 49944 | 50273 | 50637 | 51166 | 51439 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [time_series_covid19_confirmed_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 );