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

6 rows where 2/28/20 = 0 and 3/13/20 = 2

View and edit SQL

Suggested facets: Province/State, 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/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/24/20, 3/25/20, 3/28/20, 4/1/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
3   Algeria 28.0339 1.6596 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 1 2 3 4 4 4 7 9 11 15 17 17 19 21 25 26 29 31 35 44 58 86 105 130 152 173 193 205 235 256 275 293 313 326 336 348 364 367 375 384 392 402 407 415 419 425 432 437 444 450 453 459 463 465 470 476 483 488 494 502 507 515 522 529 536 542 548 555 561 568 575 582 592 600 609 617 623 630 638 646 653 661 667 673 681 690 698 707 715 724 732 741 751 760 767 777 788 799 811 825 837 845 852 861 869 878 885 892 897 905 912 920 928 937 946 952 959 968 978 988 996 1004 1011 1018 1028 1040 1052 1057 1068 1078 1087 1100 1111 1124 1136 1146 1155 1163 1174 1186 1200 1210 1223 1231 1239 1248 1261 1273 1282 1293 1302 1312 1322 1333 1341 1351 1360 1370 1379 1391 1402 1411 1418 1424 1435 1446 1456 1465 1475 1483 1491 1501 1510 1518 1523 1529 1539 1549 1556 1562 1571 1581 1591 1599 1605 1612 1620 1632 1645 1654 1659 1665 1672 1679 1689 1698 1703 1707 1711
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
10 New South Wales Australia -33.8688 151.2093 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 2 2 2 2 2 2 2 2 2 4 5 5 6 6 6 6 7 7 7 7 8 8 8 8 9 10 12 12 16 18 21 21 21 22 23 24 25 25 25 25 26 26 26 26 26 26 31 33 33 34 34 39 40 41 41 42 42 43 44 44 44 44 44 44 44 45 45 45 45 45 46 46 47 47 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 48 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 49 50 50 50 50 50 50 50 50 50 50 50 50 51 51 51 52 52 52 52 52 52 52 52 52 52 52 52 52 52 52 52 52 52 52 52 52 52 52 52 52 52 52 52 52 52 52 52 52 52 52 53 53 53 53 53 53 53 53
108   Egypt 26.820553000000004 30.802498 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 4 6 6 8 10 14 19 20 21 24 30 36 40 41 46 52 58 66 71 78 85 94 103 118 135 146 159 164 178 183 196 205 224 239 250 264 276 287 294 307 317 337 359 380 392 406 415 429 436 452 469 482 503 514 525 533 544 556 571 592 612 630 645 659 680 696 707 735 764 783 797 816 845 879 913 959 1005 1052 1088 1126 1166 1198 1237 1271 1306 1342 1377 1422 1484 1575 1672 1766 1850 1938 2017 2106 2193 2278 2365 2450 2533 2620 2708 2789 2872 2953 3034 3120 3201 3280 3343 3422 3489 3564 3617 3702 3769 3858 3935 4008 4067 4120 4188 4251 4302 4352 4399 4440 4480 4518 4558 4606 4652 4691 4728 4774 4805 4834 4865 4888 4912 4930 4951 4971 4992 5009 5035 5059 5085 5107 5124 5141 5160 5173 5184 5197 5212 5231 5243 5262 5280 5298 5317 5342 5362 5376 5399 5421 5440 5461 5479 5495 5511 5530 5541 5560 5577 5590 5607 5627 5648 5661 5679 5696 5715 5733 5750 5770 5787 5806 5822 5835 5853 5869
144   India 20.593684 78.96288 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 2 2 2 2 3 3 4 5 4 7 10 10 12 20 20 24 27 32 35 58 72 72 86 99 136 150 178 226 246 288 331 358 393 405 448 486 521 559 592 645 681 721 780 825 881 939 1008 1079 1154 1223 1323 1391 1566 1693 1785 1889 1985 2101 2212 2294 2415 2551 2649 2753 2871 3025 3156 3302 3434 3584 3726 3868 4024 4172 4344 4534 4711 4980 5185 5408 5608 5829 6088 6363 6649 6946 7207 7473 7750 8102 8498 8884 9195 9520 9900 11903 12237 12573 12948 13254 13699 14011 14476 14894 15301 15685 16095 16475 16893 17400 17834 18213 18655 19268 19693 20159 20642 21129 21604 22123 22673 23174 23727 24309 24914 25602 26273 26816 27497 28082 28732 29861 30601 31358 32060 32771 33408 34193 34955 35718 36511 37364 38135 38938 39795 40699 41585 42518 43379 44386 45257 46091 47033 48040 49036 49980 50921 51797 52888 53866 54849 55794 56706 57542 58390 59357 60472 61529 62550 63498 64469 65288 66333 67376 68472 69561 70626 71642 72775 73890 75062 76271 77472 78586 79722 80776 82066 83198 84372 85619 86752 87882 88935 88935 90020 91149 92290 93379
205   Poland 51.9194 19.1451 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 1 2 3 3 4 5 5 5 5 5 7 8 10 14 16 16 18 22 31 33 43 57 71 79 94 107 129 159 174 181 208 232 245 263 286 314 332 347 360 380 401 426 454 494 524 535 562 596 624 644 651 664 678 698 716 733 755 776 785 800 811 839 861 883 907 915 925 936 948 962 972 982 993 996 1007 1024 1028 1038 1051 1061 1064 1074 1092 1115 1117 1137 1153 1157 1166 1183 1206 1215 1222 1237 1247 1256 1272 1286 1316 1334 1346 1356 1359 1375 1396 1412 1429 1435 1438 1444 1463 1477 1492 1507 1512 1517 1521 1528 1542 1551 1562 1568 1571 1576 1588 1594 1605 1612 1618 1624 1627 1636 1642 1651 1655 1664 1671 1676 1682 1694 1709 1716 1721 1731 1732 1738 1756 1774 1787 1800 1807 1809 1821 1830 1844 1858 1869 1877 1885 1896 1913 1925 1938 1951 1955 1960 1977 1994 2010 2018 2032 2033 2039 2058 2078 2092 2100 2113 2120 2124 2136 2147 2159 2169 2182 2188 2203 2227 2237 2253 2270 2282 2293 2298 2316 2344 2369 2392 2424

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