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

3 rows where 3/13/20 = 2 and 3/8/20 = 1

View and edit SQL

Suggested facets: Province/State, 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/12/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
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
80 Shaanxi China 35.1917 108.8701 0 0 0 0 0 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 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 2 2 2 2 2 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3
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

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