johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,024 rows where country_or_region = "China" and province_or_state = "Sichuan" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2784832 | 2784832 | 2020-11-13 | China | Sichuan | 783 | 3 | 735 | 45 | 30.6171 | 102.7103 | 2020-11-14 05:25:37 | Sichuan, China | ||
864597 | 864597 | 2020-11-12 | China | Sichuan | 783 | 3 | 733 | 47 | 30.6171 | 102.7103 | 2020-11-13 05:25:30 | Sichuan, China | ||
3440642 | 3440642 | 2020-11-11 | China | Sichuan | 782 | 3 | 731 | 48 | 30.6171 | 102.7103 | 2020-11-12 05:25:55 | Sichuan, China | ||
271982 | 271982 | 2020-11-10 | China | Sichuan | 778 | 3 | 728 | 47 | 30.6171 | 102.7103 | 2020-11-11 05:25:30 | Sichuan, China | ||
1988459 | 1988459 | 2020-11-09 | China | Sichuan | 776 | 3 | 728 | 45 | 30.6171 | 102.7103 | 2020-11-10 05:40:07 | Sichuan, China | ||
1728311 | 1728311 | 2020-11-08 | China | Sichuan | 773 | 3 | 727 | 43 | 30.6171 | 102.7103 | 2020-11-09 05:25:45 | Sichuan, China | ||
1543771 | 1543771 | 2020-11-07 | China | Sichuan | 769 | 3 | 724 | 42 | 30.6171 | 102.7103 | 2020-11-08 05:24:56 | Sichuan, China | ||
376009 | 376009 | 2020-11-06 | China | Sichuan | 767 | 3 | 722 | 42 | 30.6171 | 102.7103 | 2020-11-07 05:24:52 | Sichuan, China | ||
891947 | 891947 | 2020-11-05 | China | Sichuan | 763 | 3 | 717 | 43 | 30.6171 | 102.7103 | 2020-11-06 05:24:55 | Sichuan, China | ||
2919009 | 2919009 | 2020-11-04 | China | Sichuan | 761 | 3 | 716 | 42 | 30.6171 | 102.7103 | 2020-11-05 06:05:03 | Sichuan, China | ||
2497846 | 2497846 | 2020-11-03 | China | Sichuan | 757 | 3 | 715 | 39 | 30.6171 | 102.7103 | 2020-11-04 05:25:09 | Sichuan, China | ||
3304021 | 3304021 | 2020-11-02 | China | Sichuan | 754 | 3 | 713 | 38 | 30.6171 | 102.7103 | 2020-11-03 06:00:16 | Sichuan, China | ||
3409270 | 3409270 | 2020-11-01 | China | Sichuan | 746 | 3 | 711 | 32 | 30.6171 | 102.7103 | 2020-11-02 05:25:04 | Sichuan, China | ||
2079759 | 2079759 | 2020-10-31 | China | Sichuan | 744 | 3 | 710 | 31 | 30.6171 | 102.7103 | 2020-11-01 04:36:19 | Sichuan, China | ||
2243212 | 2243212 | 2020-10-30 | China | Sichuan | 743 | 3 | 709 | 31 | 30.6171 | 102.7103 | 2020-10-31 04:24:44 | Sichuan, China | ||
210067 | 210067 | 2020-10-29 | China | Sichuan | 739 | 3 | 708 | 28 | 30.6171 | 102.7103 | 2020-10-30 04:24:49 | Sichuan, China | ||
754129 | 754129 | 2020-10-28 | China | Sichuan | 737 | 3 | 708 | 26 | 30.6171 | 102.7103 | 2020-10-29 04:24:49 | Sichuan, China | ||
1452414 | 1452414 | 2020-10-27 | China | Sichuan | 737 | 3 | 708 | 26 | 30.6171 | 102.7103 | 2020-10-28 04:24:39 | Sichuan, China | ||
3480138 | 3480138 | 2020-10-26 | China | Sichuan | 736 | 3 | 705 | 28 | 30.6171 | 102.7103 | 2020-10-27 04:24:45 | Sichuan, China | ||
8159 | 8159 | 2020-10-25 | China | Sichuan | 734 | 3 | 702 | 29 | 30.6171 | 102.7103 | 2020-10-26 04:25:02 | Sichuan, China | ||
3651396 | 3651396 | 2020-10-24 | China | Sichuan | 733 | 3 | 702 | 28 | 30.6171 | 102.7103 | 2020-10-25 04:24:36 | Sichuan, China | ||
1053651 | 1053651 | 2020-10-23 | China | Sichuan | 733 | 3 | 701 | 29 | 30.6171 | 102.7103 | 2020-10-24 04:24:46 | Sichuan, China | ||
1177321 | 1177321 | 2020-10-22 | China | Sichuan | 733 | 3 | 701 | 29 | 30.6171 | 102.7103 | 2020-10-23 04:24:46 | Sichuan, China | ||
2191426 | 2191426 | 2020-10-21 | China | Sichuan | 733 | 3 | 696 | 34 | 30.6171 | 102.7103 | 2020-10-22 04:24:27 | Sichuan, China | ||
3990437 | 3990437 | 2020-10-20 | China | Sichuan | 731 | 3 | 694 | 34 | 30.6171 | 102.7103 | 2020-10-21 04:24:14 | Sichuan, China | ||
1794457 | 1794457 | 2020-10-19 | China | Sichuan | 728 | 3 | 690 | 35 | 30.6171 | 102.7103 | 2020-10-20 04:24:22 | Sichuan, China | ||
762141 | 762141 | 2020-10-18 | China | Sichuan | 725 | 3 | 687 | 35 | 30.6171 | 102.7103 | 2020-10-19 04:24:16 | Sichuan, China | ||
1026179 | 1026179 | 2020-10-17 | China | Sichuan | 725 | 3 | 687 | 35 | 30.6171 | 102.7103 | 2020-10-18 04:24:25 | Sichuan, China | ||
2856674 | 2856674 | 2020-10-16 | China | Sichuan | 724 | 3 | 686 | 35 | 30.6171 | 102.7103 | 2020-10-17 04:24:12 | Sichuan, China | ||
786204 | 786204 | 2020-10-15 | China | Sichuan | 723 | 3 | 685 | 35 | 30.6171 | 102.7103 | 2020-10-16 04:24:01 | Sichuan, China | ||
78915 | 78915 | 2020-10-14 | China | Sichuan | 723 | 3 | 681 | 39 | 30.6171 | 102.7103 | 2020-10-15 04:24:28 | Sichuan, China | ||
3781730 | 3781730 | 2020-10-13 | China | Sichuan | 723 | 3 | 681 | 39 | 30.6171 | 102.7103 | 2020-10-14 04:24:05 | Sichuan, China | ||
2291270 | 2291270 | 2020-10-12 | China | Sichuan | 723 | 3 | 680 | 40 | 30.6171 | 102.7103 | 2020-10-13 04:24:02 | Sichuan, China | ||
3785723 | 3785723 | 2020-10-11 | China | Sichuan | 722 | 3 | 676 | 43 | 30.6171 | 102.7103 | 2020-10-12 04:23:45 | Sichuan, China | ||
2601861 | 2601861 | 2020-10-10 | China | Sichuan | 721 | 3 | 673 | 45 | 30.6171 | 102.7103 | 2020-10-11 04:23:46 | Sichuan, China | ||
817394 | 817394 | 2020-10-09 | China | Sichuan | 718 | 3 | 670 | 45 | 30.6171 | 102.7103 | 2020-10-10 04:23:57 | Sichuan, China | ||
2689509 | 2689509 | 2020-10-08 | China | Sichuan | 713 | 3 | 668 | 42 | 30.6171 | 102.7103 | 2020-10-09 04:23:59 | Sichuan, China | ||
1041651 | 1041651 | 2020-10-07 | China | Sichuan | 713 | 3 | 665 | 45 | 30.6171 | 102.7103 | 2020-10-08 04:23:56 | Sichuan, China | ||
3117312 | 3117312 | 2020-10-06 | China | Sichuan | 710 | 3 | 665 | 42 | 30.6171 | 102.7103 | 2020-10-07 04:23:40 | Sichuan, China | ||
3801724 | 3801724 | 2020-10-05 | China | Sichuan | 707 | 3 | 664 | 40 | 30.6171 | 102.7103 | 2020-10-06 04:23:33 | Sichuan, China | ||
1822614 | 1822614 | 2020-10-04 | China | Sichuan | 704 | 3 | 663 | 38 | 30.6171 | 102.7103 | 2020-10-05 04:23:33 | Sichuan, China | ||
2513998 | 2513998 | 2020-10-03 | China | Sichuan | 701 | 3 | 663 | 35 | 30.6171 | 102.7103 | 2020-10-04 04:23:44 | Sichuan, China | ||
3389216 | 3389216 | 2020-10-02 | China | Sichuan | 698 | 3 | 663 | 32 | 30.6171 | 102.7103 | 2020-10-03 04:23:40 | Sichuan, China | ||
2379457 | 2379457 | 2020-10-01 | China | Sichuan | 696 | 3 | 663 | 30 | 30.6171 | 102.7103 | 2020-10-02 04:23:51 | Sichuan, China | ||
1045643 | 1045643 | 2020-09-30 | China | Sichuan | 693 | 3 | 663 | 27 | 30.6171 | 102.7103 | 2020-10-01 04:23:42 | Sichuan, China | ||
966724 | 966724 | 2020-09-29 | China | Sichuan | 692 | 3 | 660 | 29 | 30.6171 | 102.7103 | 2020-09-30 04:23:33 | Sichuan, China | ||
1515221 | 1515221 | 2020-09-28 | China | Sichuan | 691 | 3 | 660 | 28 | 30.6171 | 102.7103 | 2020-09-29 04:23:42 | Sichuan, China | ||
2581809 | 2581809 | 2020-09-27 | China | Sichuan | 688 | 3 | 659 | 26 | 30.6171 | 102.7103 | 2020-09-28 04:23:00 | Sichuan, China | ||
2613861 | 2613861 | 2020-09-26 | China | Sichuan | 688 | 3 | 657 | 28 | 30.6171 | 102.7103 | 2020-09-27 04:23:00 | Sichuan, China | ||
2812576 | 2812576 | 2020-09-25 | China | Sichuan | 685 | 3 | 657 | 25 | 30.6171 | 102.7103 | 2020-09-26 04:23:00 | Sichuan, China | ||
2605853 | 2605853 | 2020-09-24 | China | Sichuan | 676 | 3 | 657 | 16 | 30.6171 | 102.7103 | 2020-09-25 04:23:00 | Sichuan, China | ||
2653596 | 2653596 | 2020-09-23 | China | Sichuan | 675 | 3 | 656 | 16 | 30.6171 | 102.7103 | 2020-09-24 04:23:00 | Sichuan, China | ||
3316045 | 3316045 | 2020-09-22 | China | Sichuan | 675 | 3 | 655 | 17 | 30.6171 | 102.7103 | 2020-09-23 04:23:00 | Sichuan, China | ||
2836644 | 2836644 | 2020-09-21 | China | Sichuan | 672 | 3 | 654 | 15 | 30.6171 | 102.7103 | 2020-09-22 04:23:00 | Sichuan, China | ||
3093249 | 3093249 | 2020-09-20 | China | Sichuan | 672 | 3 | 652 | 17 | 30.6171 | 102.7103 | 2020-09-21 04:23:00 | Sichuan, China | ||
2454599 | 2454599 | 2020-09-19 | China | Sichuan | 672 | 3 | 652 | 17 | 30.6171 | 102.7103 | 2020-09-20 04:22:00 | Sichuan, China | ||
2848668 | 2848668 | 2020-09-18 | China | Sichuan | 672 | 3 | 652 | 17 | 30.6171 | 102.7103 | 2020-09-19 04:22:00 | Sichuan, China | ||
1121417 | 1121417 | 2020-09-17 | China | Sichuan | 670 | 3 | 651 | 16 | 30.6171 | 102.7103 | 2020-09-18 05:05:00 | Sichuan, China | ||
666106 | 666106 | 2020-09-16 | China | Sichuan | 670 | 3 | 650 | 17 | 30.6171 | 102.7103 | 2020-09-17 04:22:00 | Sichuan, China | ||
2728831 | 2728831 | 2020-09-15 | China | Sichuan | 670 | 3 | 650 | 17 | 30.6171 | 102.7103 | 2020-09-16 04:22:53 | Sichuan, China | ||
344103 | 344103 | 2020-09-14 | China | Sichuan | 666 | 3 | 645 | 18 | 30.6171 | 102.7103 | 2020-09-15 03:22:50 | Sichuan, China | ||
2868542 | 2868542 | 2020-09-13 | China | Sichuan | 665 | 3 | 645 | 17 | 30.6171 | 102.7103 | 2020-09-14 04:26:00 | Sichuan, China | ||
546581 | 546581 | 2020-09-12 | China | Sichuan | 665 | 3 | 645 | 17 | 30.6171 | 102.7103 | 2020-09-13 04:30:52 | Sichuan, China | ||
1444410 | 1444410 | 2020-09-11 | China | Sichuan | 665 | 3 | 645 | 17 | 30.6171 | 102.7103 | 2020-09-12 04:25:05 | Sichuan, China | ||
1173011 | 1173011 | 2020-09-10 | China | Sichuan | 665 | 3 | 644 | 18 | 30.6171 | 102.7103 | 2020-09-11 04:46:23 | Sichuan, China | ||
2171376 | 2171376 | 2020-09-09 | China | Sichuan | 664 | 3 | 642 | 19 | 30.6171 | 102.7103 | 2020-09-10 04:29:01 | Sichuan, China | ||
1243585 | 1243585 | 2020-09-08 | China | Sichuan | 664 | 3 | 642 | 19 | 30.6171 | 102.7103 | 2020-09-09 04:28:48 | Sichuan, China | ||
427164 | 427164 | 2020-09-07 | China | Sichuan | 663 | 3 | 637 | 23 | 30.6171 | 102.7103 | 2020-09-08 04:28:25 | Sichuan, China | ||
3161449 | 3161449 | 2020-09-06 | China | Sichuan | 658 | 3 | 634 | 21 | 30.6171 | 102.7103 | 2020-09-07 04:28:30 | Sichuan, China | ||
813404 | 813404 | 2020-09-05 | China | Sichuan | 656 | 3 | 634 | 19 | 30.6171 | 102.7103 | 2020-09-06 04:28:33 | Sichuan, China | ||
2661604 | 2661604 | 2020-09-04 | China | Sichuan | 656 | 3 | 634 | 19 | 30.6171 | 102.7103 | 2020-09-05 04:28:19 | Sichuan, China | ||
1354144 | 1354144 | 2020-09-03 | China | Sichuan | 656 | 3 | 632 | 21 | 30.6171 | 102.7103 | 2020-09-04 04:28:26 | Sichuan, China | ||
1105381 | 1105381 | 2020-09-02 | China | Sichuan | 655 | 3 | 630 | 22 | 30.6171 | 102.7103 | 2020-09-03 04:28:22 | Sichuan, China | ||
2059710 | 2059710 | 2020-09-01 | China | Sichuan | 653 | 3 | 626 | 24 | 30.6171 | 102.7103 | 2020-09-02 04:28:25 | Sichuan, China | ||
193895 | 193895 | 2020-08-31 | China | Sichuan | 652 | 3 | 624 | 25 | 30.6171 | 102.7103 | 2020-09-01 04:28:31 | Sichuan, China | ||
3931854 | 3931854 | 2020-08-30 | China | Sichuan | 652 | 3 | 622 | 27 | 30.6171 | 102.7103 | 2020-08-31 04:28:27 | Sichuan, China | ||
609516 | 609516 | 2020-08-29 | China | Sichuan | 652 | 3 | 622 | 27 | 30.6171 | 102.7103 | 2020-08-30 04:28:22 | Sichuan, China | ||
1523011 | 1523011 | 2020-08-28 | China | Sichuan | 650 | 3 | 622 | 25 | 30.6171 | 102.7103 | 2020-08-29 04:28:19 | Sichuan, China | ||
2510012 | 2510012 | 2020-08-27 | China | Sichuan | 648 | 3 | 620 | 25 | 30.6171 | 102.7103 | 2020-08-28 04:28:11 | Sichuan, China | ||
1996472 | 1996472 | 2020-08-26 | China | Sichuan | 644 | 3 | 619 | 22 | 30.6171 | 102.7103 | 2020-08-27 04:28:15 | Sichuan, China | ||
3562396 | 3562396 | 2020-08-25 | China | Sichuan | 640 | 3 | 617 | 20 | 30.6171 | 102.7103 | 2020-08-26 04:28:11 | Sichuan, China | ||
2991100 | 2991100 | 2020-08-24 | China | Sichuan | 635 | 3 | 615 | 17 | 30.6171 | 102.7103 | 2020-08-25 04:28:02 | Sichuan, China | ||
2215495 | 2215495 | 2020-08-23 | China | Sichuan | 631 | 3 | 611 | 17 | 30.6171 | 102.7103 | 2020-08-24 04:27:56 | Sichuan, China | ||
2299277 | 2299277 | 2020-08-22 | China | Sichuan | 628 | 3 | 611 | 14 | 30.6171 | 102.7103 | 2020-08-23 04:27:48 | Sichuan, China | ||
1479384 | 1479384 | 2020-08-21 | China | Sichuan | 628 | 3 | 611 | 14 | 30.6171 | 102.7103 | 2020-08-22 04:27:49 | Sichuan, China | ||
3484133 | 3484133 | 2020-08-20 | China | Sichuan | 628 | 3 | 610 | 15 | 30.6171 | 102.7103 | 2020-08-21 04:27:41 | Sichuan, China | ||
206082 | 206082 | 2020-08-19 | China | Sichuan | 627 | 3 | 609 | 15 | 30.6171 | 102.7103 | 2020-08-20 04:27:43 | Sichuan, China | ||
3177836 | 3177836 | 2020-08-18 | China | Sichuan | 626 | 3 | 609 | 14 | 30.6171 | 102.7103 | 2020-08-19 04:27:00 | Sichuan, China | ||
837440 | 837440 | 2020-08-17 | China | Sichuan | 626 | 3 | 608 | 15 | 30.6171 | 102.7103 | 2020-08-18 04:27:56 | Sichuan, China | ||
1555798 | 1555798 | 2020-08-16 | China | Sichuan | 626 | 3 | 606 | 17 | 30.6171 | 102.7103 | 2020-08-17 04:27:20 | Sichuan, China | ||
145800 | 145800 | 2020-08-15 | China | Sichuan | 624 | 3 | 606 | 15 | 30.6171 | 102.7103 | 2020-08-16 04:27:42 | Sichuan, China | ||
1612075 | 1612075 | 2020-08-14 | China | Sichuan | 623 | 3 | 606 | 14 | 30.6171 | 102.7103 | 2020-08-15 04:27:31 | Sichuan, China | ||
582659 | 582659 | 2020-08-13 | China | Sichuan | 619 | 3 | 605 | 11 | 30.6171 | 102.7103 | 2020-08-14 04:51:19 | Sichuan, China | ||
3531278 | 3531278 | 2020-08-12 | China | Sichuan | 618 | 3 | 602 | 13 | 30.6171 | 102.7103 | 2020-08-13 04:29:15 | Sichuan, China | ||
662127 | 662127 | 2020-08-11 | China | Sichuan | 616 | 3 | 600 | 13 | 30.6171 | 102.7103 | 2020-08-12 04:27:29 | Sichuan, China | ||
1920578 | 1920578 | 2020-08-10 | China | Sichuan | 615 | 3 | 599 | 13 | 30.6171 | 102.7103 | 2020-08-11 04:35:08 | Sichuan, China | ||
3923387 | 3923387 | 2020-08-09 | China | Sichuan | 615 | 3 | 599 | 13 | 30.6171 | 102.7103 | 2020-08-10 04:34:55 | Sichuan, China | ||
371555 | 371555 | 2020-08-08 | China | Sichuan | 611 | 3 | 599 | 9 | 30.6171 | 102.7103 | 2020-08-09 04:34:54 | Sichuan, China | ||
458739 | 458739 | 2020-08-07 | China | Sichuan | 611 | 3 | 599 | 9 | 30.6171 | 102.7103 | 2020-08-08 04:34:53 | Sichuan, China | ||
3612424 | 3612424 | 2020-08-06 | China | Sichuan | 611 | 3 | 599 | 9 | 30.6171 | 102.7103 | 2020-08-07 04:35:11 | Sichuan, China |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [johns_hopkins_csse_daily_reports] ( [day] TEXT, [country_or_region] TEXT, [province_or_state] TEXT, [admin2] TEXT, [fips] TEXT, [confirmed] INTEGER, [deaths] INTEGER, [recovered] INTEGER, [active] TEXT, [latitude] TEXT, [longitude] TEXT, [last_update] TEXT, [combined_key] TEXT ); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_day] ON [johns_hopkins_csse_daily_reports] ([day]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_province_or_state] ON [johns_hopkins_csse_daily_reports] ([province_or_state]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_country_or_region] ON [johns_hopkins_csse_daily_reports] ([country_or_region]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_combined_key] ON [johns_hopkins_csse_daily_reports] ([combined_key]);