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

4 rows where 2/1/20 = 3

View and edit SQL

Suggested facets: 1/30/20, 1/31/20, 2/5/20, 2/10/20, 2/12/20, 6/23/20

2/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
46 Chongqing China 30.0572 107.874 0 0 0 0 0 0 0 1 1 1 3 7 9 9 15 24 31 39 51 66 79 102 128 152 184 207 225 254 274 299 316 328 335 349 372 384 401 422 438 450 469 490 502 512 513 526 527 542 547 554 564 566 569 570 570 570 570 570 570 570 570 570 570 570 570 570 570 570 570 570 570 570 570 570 570 570 570 570 570 570 570 570 570 570 570 570 570 570 570 570 570 570 573 573 573 573 573 573 573 573 573 573 573 573 573 573 573 573 573 573 573 573 573 573 573 573 573 573 573 573 573 573 573 573 573 573 573 573 573 573 573 573 573 573 573 573 573 573 573 573 573 573 573 573 573 573 573 573 573 573 573 573 573 573 573 573 573 573 573 573 573 573 574 574 574 574 574 574 575 575 575 575 575 575 576 576 576 576 576 576 576 576 576 576 576 576 576 576 577 577 577 577 577 577 577 577 577 577 577 577 577 577 577 577 577 577 577 577 577 577 577 577 577 577 577 577 577 577 577 577 577 577 577 577 577 577 577 577 577 577 577 577 577 577 577 577 577 577 577 577 577 577 577 578 578 578 578 578 578
55 Henan China 33.882 113.61399999999999 0 0 0 0 0 0 0 1 2 3 3 10 16 27 47 56 86 116 153 191 218 246 296 357 391 440 509 522 573 637 736 830 868 943 1002 1033 1068 1112 1170 1198 1205 1231 1234 1239 1244 1244 1247 1247 1247 1249 1249 1249 1250 1250 1250 1250 1250 1250 1250 1250 1250 1250 1250 1250 1250 1250 1251 1251 1251 1251 1251 1251 1251 1251 1251 1252 1252 1252 1252 1252 1252 1253 1253 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254 1254
68 Shandong China 36.3427 118.1498 0 0 0 0 0 0 0 1 1 2 3 6 7 11 15 27 37 44 63 66 80 92 105 136 156 173 191 211 231 254 281 302 321 343 355 377 387 405 421 443 460 511 516 578 618 627 642 700 719 726 734 739 741 741 746 746 746 747 748 749 750 751 752 752 752 752 752 752 753 753 753 753 754 755 755 755 755 755 756 756 757 757 758 759 761 761 761 765 765 765 765 766 766 767 767 768 768 771 772 772 772 772 773 773 775 775 776 776 776 777 777 777 777 778 780 780 780 780 780 780 780 780 780 780 780 780 780 780 780 780 780 780 780 780 780 780 780 781 781 781 781 781 781 782 782 783 783 783 783 783 785 785 785 785 785 785 785 785 785 785 785 785 785 785 785 785 785 785 785 785 785 785 785 785 785 785 785 785 785 785 785 785 785 785 785 785 785 785 785 785 785 785 786 786 786 786 786 787 788 788 788 788 788 789 789 790 790 790 793 793 793 794 795 797 798 798 801 801 802 806 807 807 808 809 809 809 809 810 811 811 811 811 812 813 813 813 813 813 813 813 814 815 816 816 816 816 816 821 821
71 Sichuan China 30.6171 102.7103 0 0 0 0 0 0 0 1 1 1 3 11 14 14 24 31 42 60 71 80 85 92 104 114 119 131 156 169 188 217 231 250 261 276 289 307 321 338 351 365 386 394 406 425 442 454 464 466 478 488 498 503 511 516 516 520 525 536 536 536 536 536 536 536 536 536 536 536 536 536 537 537 537 538 539 540 541 541 541 546 547 547 548 548 550 552 552 553 554 554 554 556 558 558 558 558 558 558 558 558 558 558 558 558 558 558 558 558 558 558 558 558 558 558 558 558 558 558 558 558 558 558 558 558 558 558 558 558 558 558 558 558 558 558 558 558 558 558 558 558 560 561 562 563 563 564 565 567 569 569 570 570 572 573 575 575 575 575 577 578 580 580 581 581 581 581 581 581 582 582 582 587 587 587 589 590 591 592 592 592 593 593 594 594 594 594 594 595 596 596 597 597 597 597 597 598 598 599 599 599 599 599 600 602 605 606 606 606 608 609 609 610 611 611 611 615 617 619 620 622 622 622 624 626 630 632 634 634 634 637 642 642 644 645 645 645 645 650 650 651 652 652 652 654 655 656 657 657 657

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