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

5 rows where 2/3/20 = 0 and 3/3/20 = 2

View and edit SQL

Suggested facets: Province/State, 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/4/20, 3/5/20, 3/6/20, 3/7/20, 3/8/20, 3/9/20, 3/10/20, 3/13/20, 3/21/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
13 South Australia Australia -34.9285 138.6007 0 0 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 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 3 3 3 3 3 3 3 3 3 3 3 3 6 6 6 6 6 6 6 6 6 46 46 46 53 53 53 120 179 179 179 179 240 240 279 331 331 331 369 376 388 394 401 402 411 414 420 420 420 422 427 427 427 429 432 433 433 433 434 434 434 434 434 435 435 435 435 435 435 435 435 435 435 435 435 435 435 435 435 435 435 435 435 436 436 436 436 436 436 436 436 436 436 436 436 436 436 436 436 436 436 436 436 436 436 436 436 436 436 436 436 436 436 436 436 436 436 437 439 439 439 439 439 439 439 440 440 440 440 440 440 441 441 441 441 441 441 441 441 441 443 443 443 443 443 444 445 445 446 447 447 447 449 449 449 449 450 450 451 452 452 452 452 456 456 456 456 456 458 458 458 458 458 459 459 459 459 459 460 461 461 461 462 462 462 462 462 462 462 462 462 462 462 462 462 462 462 462
185   Oman 21.512583 55.92325500000001 0 0 0 0 0 0 0 0 0 0 0 0 0 0 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 2 2 9 9 9 9 9 9 9 9 12 12 12 12 17 17 17 17 23 23 23 23 29 34 34 57 57 61 61 61 67 72 109 109 109 109 124 130 131 176 176 176 233 238 238 238 307 325 329 333 364 364 364 495 495 750 750 816 858 888 980 1025 1068 1117 1250 1250 1289 1303 1350 1436 1465 1496 1574 1661 1821 1821 1848 1933 1933 2067 2177 2177 2396 2396 2682 2682 2812 2845 3451 3451 3451 3451 3793 4152 5640 6623 7489 7530 8454 9533 11089 11797 13264 13974 14780 15552 16408 17279 17972 18520 19482 20363 21200 22422 23425 24162 25318 26169 26968 27917 29146 31000 32005 33021 34225 35255 36098 37257 37987 39038 40090 41450 42772 44004 45150 46608 47922 51349 53007 54061 55299 57028 58587 60240 61421 61421 61421 61421 61421 61421 69803 70910 72263 73481 74691 76124 76720 77072 77278 77427 77550 77680 77812 77977 78188 78386 78386 78386 78386 78912 79147 79409 79608 79608 79608 80459 80810 81024 81024 81828 81828 81828 82406 82805 82973 83115 83325 83325 83325 83771 83928 84113 84363 84648 84648 84648 85418 85781 86195 86482 86765 86765 86765
196   Russia 61.52401 105.31875600000001 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 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 3 3 3 3 3 3 8 8 8 8 8 9 9 12 16 16 22 29 38 45 49 64 66 121 190 235 281 333 355 406 494 580 698 795 1045 1291 1470 1694 1986 2304 2590 3057 3291 3446 3873 4420 4891 5568 6250 6767 7346 8456 10286 11619 13220 15013 16639 18095 19865 21327 23803 26608 31916 34306 39801 43512 48003 53530 58226 63166 67373 70209 76130 85392 92681 99825 107936 113299 118798 131129 142208 150993 159257 167469 171883 175514 186602 195559 204197 212237 220935 226272 230226 241917 252295 260649 268862 274128 279536 284021 293780 303800 313409 323851 334024 339142 343847 355847 368222 374557 383524 392703 398436 402778 411973 422235 428276 437155 446127 449995 453570 463103 471718 480494 488234 496594 500208 503168 511958 522375 530801 538467 545909 549387 552644 561397 571049 579295 587728 596064 599172 602249 611109 619204 628482 637217 645316 648961 652372 660235 667769 675069 682278 688856 692059 695317 701796 708900 714934 721473 727895 731444 734573 741045 747802 753868 759639 765754 768906 771357 777960 784277 790629 796498 802365 804941 807339 813603 819043 824783 830532 835884 838680 840997 847746 854069 859961 865646 871000 873684 876152 881693 887457 893145 898420 903545 906431 909026 914923 920602 926663 930955 936881
214   Spain 40.463667 -3.7492199999999998 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 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 30 30 32 32 183 183 193 517 517 530 1028 1081 1107 1588 2125 2575 2575 3794 5367 7015 9357 12285 14709 16780 19259 22647 26743 30513 34219 38080 40437 43208 48021 52165 55668 59109 62391 64727 67504 70853 74797 74797 74797 77357 80587 82514 85915 89250 92355 95708 98372 100875 102548 108947 112050 112050 117248 118902 121343 123486 126002 128511 131148 133952 136166 137139 138980 140823 143374 144783 146446 146446 150376 150376 150376 150376 150376 150376 150376 150376 150376 150376 150376 150376 150376 150376 150376 150376 150376 150376 150376 150376 150376 150376 150376 150376 150376 150376 150376 150376 150376 150376 150376 150376 150376 150376 150376 150376 150376 150376 150376 150376 150376 150376 150376 150376 150376 150376 150376 150376 150376 150376 150376 150376 150376 150376 150376 150376 150376 150376 150376 150376 150376 150376 150376 150376 150376 150376 150376 150376 150376 150376 150376 150376 150376 150376 150376 150376 150376 150376 150376 150376 150376 150376 150376 150376 150376 150376 150376 150376 150376 150376 150376 150376 150376 150376 150376 150376 150376 150376 150376 150376 150376 150376 150376 150376 150376 150376 150376 150376 150376 150376 150376 150376 150376 150376 150376 150376 150376 150376 150376 150376 150376 150376 150376 150376 150376 150376 150376 150376 150376 150376 150376 150376
219   Switzerland 46.8182 8.2275 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 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 3 3 3 3 3 3 3 4 4 4 4 4 4 4 15 15 15 15 131 131 131 131 131 1530 1530 1595 1823 1823 2967 4013 4846 6415 6415 8056 8704 9800 10600 11100 12100 12700 13700 13700 15400 15900 16400 17100 17800 18600 19400 19900 20600 21000 21300 21800 22200 22600 22600 23400 23900 24200 24500 25200 25400 25700 25900 26100 26400 26600 26800 26800 27100 27100 27100 27400 27500 27600 27700 27800 27900 27900 28000 28100 28200 28200 28300 28300 28300 28400 28500 28500 28500 28600 28600 28600 28700 28700 28700 28700 28700 28800 28800 28800 28800 28900 28900 28900 28900 28900 28900 29000 29000 29000 29000 29000 29000 29100 29100 29100 29200 29200 29200 29200 29200 29300 29300 29300 29400 29400 29400 29500 29600 29600 29800 29800 29900 29900 29900 30300 30300 30300 30500 30500 30500 30500 30700 30900 31000 31100 31100 31100 31300 31500 31500 31600 31600 31600 31600 31900 32300 32400 32400 32700 32700 32900 33200 33300 33300 33500 33500 33900 33900 34100 34400 34400 34400 34800 34800 34800 35200 35800 36100 36300 36500 36500 36500 37100 37100 37700 37700 38100 38100 38100 38500 38900 39600 39900 39900 39900 40500 40500 40500 40500 42100 42100 42600 42600 42600

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [time_series_covid19_recovered_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
);