Data source: Big Local News · About: big-local-datasette

4 rows where 3/17/20 = 2 and 3/19/20 = 3

View and edit SQL

Suggested facets: 3/8/20, 3/9/20, 3/10/20, 3/11/20, 3/12/20, 3/13/20, 3/20/20, 3/21/20, 3/22/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
7   Argentina -38.4161 -63.6167 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 1 1 1 2 2 2 2 2 2 3 3 4 4 4 6 8 9 13 18 19 23 27 28 36 39 43 44 48 56 63 72 82 83 90 97 102 111 115 123 129 132 136 147 152 165 176 185 192 197 207 214 218 225 237 246 260 264 273 282 293 300 305 314 319 329 353 356 363 373 382 393 403 416 433 445 452 467 484 500 508 520 528 539 556 569 583 608 632 648 664 693 717 735 765 785 815 833 854 878 913 948 979 992 1011 1043 1078 1116 1150 1184 1207 1232 1280 1307 1351 1385 1437 1481 1507 1582 1644 1694 1720 1774 1810 1845 1903 1968 2050 2112 2178 2220 2260 2373 2490 2588 2702 2807 2893 2939 3059 3179 3288 3441 3543 3596 3648 3813 3979 4106 4251 4411 4523 4606 4764 5004 5213 5362 5527 5637 5703 5814 6048 6330 6517 6730 6848 6985 7366 7563 7839 8050 8271 8353 8457 8660 8919 9118 9361 9623 9739 9859 10129 10405 10658 10907 11148 11263 11352 11667 11852 12116 12460 12656 12799 13053 13482 13952 14376 14766 15208 15543
33   Bulgaria 42.7339 25.4858 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 0 1 1 1 2 2 2 2 2 3 3 3 3 3 3 3 3 3 7 8 8 8 10 10 14 17 20 22 23 24 24 25 28 29 32 35 36 38 41 41 42 43 45 49 52 54 55 56 58 58 64 66 68 72 73 78 80 84 84 86 90 91 93 95 96 99 102 105 108 110 112 116 120 125 126 130 130 130 133 134 136 139 140 140 144 146 147 159 160 160 164 167 167 168 172 172 174 176 181 184 190 193 199 199 207 208 209 211 215 216 219 223 230 232 232 239 241 246 250 254 259 262 267 267 268 276 283 289 293 297 299 300 308 313 321 329 337 338 340 347 355 368 374 383 385 388 404 415 424 435 442 445 447 459 471 482 482 492 495 498 512 519 527 532 539 539 545 563 572 586 594 603 605 613 629 642 648 658 665 671 676 677 692 702 706 713 717 720 729 736 739 749 753 755 761 765 767 779 785 789 789
107   Ecuador -1.8312 -78.1834 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 0 0 0 0 2 2 2 2 2 3 5 7 14 18 27 28 34 36 48 58 60 75 93 120 145 172 180 191 191 242 272 297 315 333 355 369 388 403 421 456 474 507 520 537 560 576 576 576 663 871 883 900 1063 1371 1564 1569 1569 1618 1654 1704 1717 2127 2145 2327 2334 2338 2594 2688 2736 2799 2839 2888 2939 3056 3096 3108 3203 3203 3275 3313 3334 3334 3358 3358 3438 3486 3486 3534 3608 3621 3642 3690 3720 3720 3828 3874 3896 3929 3970 4007 4087 4156 4156 4223 4223 4274 4274 4343 4406 4424 4429 4502 4527 4576 4639 4700 4769 4781 4821 4873 4873 4900 4939 5031 5047 5063 5130 5158 5207 5250 5282 5313 5318 5366 5418 5439 5468 5507 5515 5532 5584 5623 5657 5702 5736 5736 5767 5808 5847 5877 5897 5916 5922 5932 5951 5984 6010 6030 6065 6070 6083 6105 6146 6200 6248 6277 6310 6322 6368 6410 6471 6504 6537 6555 6556 6571 6619 6648 6674 6724 6724 10576 10627 10701 10749 10836 10864 10903 10922 10963 10996 11029 11044 11084 11090 11095 11126 11171 11213 11236 11273
148   Ireland 53.1424 -7.6921 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 0 1 1 1 2 2 2 2 2 3 3 3 4 6 7 9 19 22 36 46 54 71 85 98 120 137 158 174 210 235 263 287 320 334 365 406 444 486 530 571 610 687 730 769 794 1014 1063 1087 1102 1159 1190 1232 1265 1286 1303 1319 1339 1375 1403 1429 1446 1458 1467 1488 1497 1506 1518 1533 1543 1547 1561 1571 1583 1592 1604 1608 1606 1615 1631 1639 1645 1651 1652 1650 1658 1659 1664 1670 1678 1679 1683 1691 1695 1703 1705 1705 1706 1706 1709 1710 1714 1714 1715 1715 1717 1720 1726 1727 1730 1734 1735 1735 1736 1738 1738 1740 1741 1741 1741 1742 1738 1743 1744 1746 1746 1746 1746 1748 1749 1752 1753 1753 1753 1753 1754 1763 1763 1764 1764 1764 1764 1764 1763 1763 1763 1763 1763 1763 1763 1768 1772 1772 1772 1772 1773 1774 1774 1774 1774 1774 1774 1775 1775 1776 1776 1777 1777 1777 1777 1777 1777 1777 1777 1777 1777 1777 1777 1777 1777 1777 1777 1777 1778 1781 1781 1781 1783 1784 1784 1787 1788 1789 1792 1792 1792 1792 1792 1794 1797 1797 1802

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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
);