time_series_covid19_recovered_global
Data source: Big Local News · About: big-local-datasette
3 rows where 1/28/20 = 4
This data as json, copyable, CSV (advanced)
Suggested facets: 1/23/20, 1/24/20, 1/25/20, 1/26/20, 1/29/20, 3/9/20, 9/23/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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 45 | 45 | Beijing | China | 40.1824 | 116.4142 | 0 | 0 | 1 | 2 | 2 | 2 | 4 | 4 | 4 | 5 | 9 | 9 | 12 | 23 | 24 | 31 | 33 | 34 | 37 | 44 | 48 | 56 | 69 | 80 | 98 | 108 | 114 | 122 | 145 | 153 | 169 | 178 | 189 | 198 | 215 | 235 | 248 | 257 | 271 | 276 | 282 | 288 | 297 | 297 | 299 | 303 | 308 | 315 | 320 | 326 | 334 | 342 | 349 | 353 | 360 | 369 | 378 | 380 | 390 | 396 | 400 | 400 | 401 | 403 | 406 | 408 | 410 | 412 | 415 | 418 | 418 | 424 | 434 | 438 | 441 | 443 | 448 | 455 | 464 | 469 | 474 | 479 | 484 | 491 | 495 | 503 | 509 | 509 | 510 | 514 | 516 | 518 | 524 | 525 | 525 | 525 | 536 | 538 | 542 | 547 | 547 | 547 | 553 | 554 | 555 | 557 | 560 | 560 | 565 | 568 | 571 | 573 | 574 | 574 | 576 | 577 | 578 | 578 | 578 | 578 | 578 | 579 | 581 | 581 | 581 | 581 | 581 | 581 | 581 | 581 | 581 | 581 | 581 | 583 | 583 | 583 | 583 | 583 | 584 | 584 | 584 | 584 | 584 | 584 | 584 | 584 | 584 | 584 | 584 | 584 | 584 | 584 | 584 | 584 | 584 | 585 | 585 | 585 | 585 | 586 | 587 | 589 | 592 | 594 | 595 | 596 | 596 | 613 | 645 | 645 | 645 | 680 | 694 | 694 | 729 | 752 | 762 | 775 | 788 | 804 | 816 | 833 | 841 | 855 | 867 | 878 | 881 | 895 | 896 | 901 | 911 | 915 | 917 | 917 | 918 | 919 | 919 | 920 | 920 | 920 | 920 | 920 | 920 | 920 | 922 | 923 | 923 | 923 | 924 | 924 | 924 | 924 | 924 | 924 | 924 | 924 | 926 | 926 | 926 | 926 | 926 | 926 | 926 | 926 | 926 | 926 | 926 | 926 | 926 | 926 | 926 | 926 | 926 | 926 | 926 | 926 | 926 | 926 | 926 | 926 | 926 | 926 | 926 | 926 | 926 | 926 | 926 | 926 | 926 |
| 49 | 49 | Guangdong | China | 23.3417 | 113.4244 | 0 | 2 | 2 | 2 | 2 | 4 | 4 | 5 | 10 | 11 | 14 | 15 | 21 | 30 | 49 | 69 | 88 | 112 | 141 | 167 | 212 | 275 | 314 | 362 | 410 | 465 | 524 | 565 | 606 | 642 | 690 | 728 | 755 | 786 | 822 | 851 | 890 | 935 | 983 | 1016 | 1059 | 1101 | 1133 | 1181 | 1216 | 1237 | 1256 | 1260 | 1274 | 1282 | 1289 | 1296 | 1299 | 1304 | 1306 | 1307 | 1313 | 1318 | 1323 | 1325 | 1329 | 1332 | 1333 | 1336 | 1336 | 1337 | 1341 | 1349 | 1351 | 1356 | 1357 | 1365 | 1368 | 1378 | 1387 | 1395 | 1401 | 1411 | 1423 | 1434 | 1437 | 1443 | 1454 | 1458 | 1462 | 1471 | 1475 | 1482 | 1490 | 1494 | 1501 | 1511 | 1528 | 1534 | 1542 | 1542 | 1547 | 1554 | 1557 | 1565 | 1565 | 1567 | 1569 | 1571 | 1575 | 1575 | 1575 | 1575 | 1576 | 1577 | 1578 | 1578 | 1579 | 1579 | 1579 | 1579 | 1579 | 1579 | 1579 | 1579 | 1579 | 1580 | 1580 | 1581 | 1581 | 1581 | 1582 | 1582 | 1583 | 1583 | 1583 | 1583 | 1583 | 1583 | 1584 | 1584 | 1584 | 1585 | 1586 | 1587 | 1588 | 1589 | 1590 | 1590 | 1590 | 1592 | 1593 | 1603 | 1604 | 1604 | 1614 | 1614 | 1619 | 1620 | 1621 | 1621 | 1622 | 1622 | 1625 | 1627 | 1627 | 1627 | 1629 | 1629 | 1631 | 1631 | 1631 | 1631 | 1631 | 1631 | 1631 | 1634 | 1634 | 1634 | 1636 | 1636 | 1636 | 1636 | 1636 | 1637 | 1637 | 1637 | 1637 | 1639 | 1641 | 1642 | 1645 | 1645 | 1648 | 1651 | 1653 | 1653 | 1654 | 1657 | 1659 | 1661 | 1661 | 1663 | 1664 | 1669 | 1671 | 1672 | 1676 | 1678 | 1681 | 1683 | 1684 | 1684 | 1687 | 1689 | 1691 | 1695 | 1696 | 1701 | 1701 | 1702 | 1704 | 1706 | 1715 | 1716 | 1718 | 1720 | 1721 | 1721 | 1722 | 1722 | 1723 | 1727 | 1733 | 1735 | 1737 | 1743 | 1745 | 1745 | 1749 | 1751 | 1755 | 1757 | 1760 | 1764 | 1767 | 1767 | 1771 | 1774 | 1777 | 1780 | 1782 | 1785 | 1785 |
| 69 | 69 | Shanghai | China | 31.201999999999998 | 121.4491 | 0 | 0 | 1 | 1 | 1 | 3 | 4 | 5 | 5 | 9 | 10 | 10 | 10 | 12 | 15 | 25 | 30 | 41 | 44 | 48 | 52 | 57 | 62 | 90 | 124 | 140 | 161 | 177 | 186 | 199 | 211 | 227 | 249 | 261 | 268 | 272 | 276 | 279 | 287 | 290 | 292 | 294 | 298 | 303 | 306 | 313 | 314 | 315 | 319 | 320 | 321 | 324 | 324 | 324 | 325 | 325 | 326 | 326 | 326 | 327 | 328 | 329 | 330 | 330 | 331 | 334 | 334 | 334 | 338 | 341 | 341 | 343 | 348 | 356 | 383 | 389 | 406 | 418 | 422 | 435 | 438 | 446 | 446 | 468 | 485 | 489 | 512 | 512 | 521 | 530 | 530 | 534 | 533 | 558 | 558 | 568 | 581 | 584 | 597 | 599 | 612 | 612 | 615 | 619 | 620 | 620 | 623 | 623 | 626 | 627 | 627 | 631 | 633 | 638 | 640 | 641 | 641 | 641 | 641 | 641 | 641 | 647 | 647 | 648 | 652 | 653 | 655 | 655 | 657 | 657 | 657 | 660 | 661 | 661 | 662 | 663 | 664 | 664 | 664 | 665 | 665 | 666 | 666 | 666 | 667 | 667 | 667 | 668 | 668 | 668 | 668 | 668 | 669 | 669 | 670 | 672 | 674 | 675 | 675 | 675 | 675 | 677 | 678 | 681 | 681 | 681 | 685 | 688 | 689 | 689 | 689 | 689 | 689 | 689 | 690 | 691 | 699 | 699 | 701 | 707 | 708 | 709 | 711 | 712 | 712 | 716 | 717 | 718 | 720 | 720 | 720 | 724 | 725 | 725 | 727 | 727 | 727 | 728 | 729 | 730 | 731 | 734 | 737 | 737 | 739 | 740 | 745 | 752 | 752 | 754 | 769 | 777 | 783 | 796 | 796 | 799 | 805 | 807 | 819 | 826 | 829 | 841 | 840 | 842 | 849 | 854 | 860 | 866 | 869 | 872 | 875 | 877 | 887 | 887 | 890 | 897 | 900 | 904 | 909 | 909 | 910 | 916 | 919 | 923 | 923 | 926 | 928 | 932 | 934 |
Advanced export
JSON shape: default, array, newline-delimited
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 );