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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
3793254 | 3793254 | 2020-08-05 | China | Sichuan | 610 | 3 | 598 | 9 | 30.6171 | 102.7103 | 2020-08-06 04:35:02 | Sichuan, China | ||
98490 | 98490 | 2020-08-04 | China | Sichuan | 610 | 3 | 598 | 9 | 30.6171 | 102.7103 | 2020-08-05 04:34:43 | Sichuan, China | ||
2740373 | 2740373 | 2020-08-03 | China | Sichuan | 609 | 3 | 597 | 9 | 30.6171 | 102.7103 | 2020-08-04 04:41:59 | Sichuan, China | ||
2808125 | 2808125 | 2020-08-02 | China | Sichuan | 608 | 3 | 597 | 8 | 30.6171 | 102.7103 | 2020-08-03 04:34:35 | Sichuan, China | ||
753693 | 753693 | 2020-08-01 | China | Sichuan | 608 | 3 | 597 | 8 | 30.6171 | 102.7103 | 2020-08-02 04:34:47 | Sichuan, China | ||
3264858 | 3264858 | 2020-07-31 | China | Sichuan | 604 | 3 | 597 | 4 | 30.6171 | 102.7103 | 2020-08-01 04:36:27 | Sichuan, China | ||
1928565 | 1928565 | 2020-07-30 | China | Sichuan | 604 | 3 | 597 | 4 | 30.6171 | 102.7103 | 2020-07-31 04:35:18 | Sichuan, China | ||
2958733 | 2958733 | 2020-07-29 | China | Sichuan | 604 | 3 | 596 | 5 | 30.6171 | 102.7103 | 2020-07-30 04:35:05 | Sichuan, China | ||
3185349 | 3185349 | 2020-07-28 | China | Sichuan | 604 | 3 | 596 | 5 | 30.6171 | 102.7103 | 2020-07-29 04:35:11 | Sichuan, China | ||
177400 | 177400 | 2020-07-27 | China | Sichuan | 604 | 3 | 595 | 6 | 30.6171 | 102.7103 | 2020-07-28 04:58:43 | Sichuan, China | ||
442713 | 442713 | 2020-07-26 | China | Sichuan | 604 | 3 | 594 | 7 | 30.6171 | 102.7103 | 2020-07-27 04:35:02 | Sichuan, China | ||
1502957 | 1502957 | 2020-07-25 | China | Sichuan | 603 | 3 | 594 | 6 | 30.6171 | 102.7103 | 2020-07-26 04:35:00 | Sichuan, China | ||
2563927 | 2563927 | 2020-07-24 | China | Sichuan | 603 | 3 | 594 | 6 | 30.6171 | 102.7103 | 2020-07-25 04:47:39 | Sichuan, China | ||
62135 | 62135 | 2020-07-23 | China | Sichuan | 603 | 3 | 594 | 6 | 30.6171 | 102.7103 | 2020-07-24 05:30:40 | Sichuan, China | ||
844947 | 844947 | 2020-07-22 | China | Sichuan | 603 | 3 | 594 | 6 | 30.6171 | 102.7103 | 2020-07-23 05:15:04 | Sichuan, China | ||
1707686 | 1707686 | 2020-07-21 | China | Sichuan | 599 | 3 | 590 | 6 | 30.6171 | 102.7103 | 2020-07-22 04:34:42 | Sichuan, China | ||
327177 | 327177 | 2020-07-20 | China | Sichuan | 599 | 3 | 590 | 6 | 30.6171 | 102.7103 | 2020-07-21 04:38:46 | Sichuan, China | ||
122082 | 122082 | 2020-07-19 | China | Sichuan | 599 | 3 | 590 | 6 | 30.6171 | 102.7103 | 2020-07-20 05:34:40 | Sichuan, China | ||
3205471 | 3205471 | 2020-07-18 | China | Sichuan | 599 | 3 | 590 | 6 | 30.6171 | 102.7103 | 2020-07-19 04:34:58 | Sichuan, China | ||
2708773 | 2708773 | 2020-07-17 | China | Sichuan | 599 | 3 | 590 | 6 | 30.6171 | 102.7103 | 2020-07-18 04:34:45 | Sichuan, China | ||
367583 | 367583 | 2020-07-16 | China | Sichuan | 599 | 3 | 590 | 6 | 30.6171 | 102.7103 | 2020-07-17 04:34:50 | Sichuan, China | ||
2748251 | 2748251 | 2020-07-15 | China | Sichuan | 599 | 3 | 590 | 6 | 30.6171 | 102.7103 | 2020-07-16 04:44:59 | Sichuan, China | ||
2158895 | 2158895 | 2020-07-14 | China | Sichuan | 599 | 3 | 589 | 7 | 30.6171 | 102.7103 | 2020-07-15 04:34:39 | Sichuan, China | ||
3491536 | 3491536 | 2020-07-13 | China | Sichuan | 599 | 3 | 587 | 9 | 30.6171 | 102.7103 | 2020-07-14 04:34:46 | Sichuan, China | ||
3737799 | 3737799 | 2020-07-12 | China | Sichuan | 599 | 3 | 587 | 9 | 30.6171 | 102.7103 | 2020-07-13 04:43:04 | Sichuan, China | ||
3436194 | 3436194 | 2020-07-11 | China | Sichuan | 599 | 3 | 587 | 9 | 30.6171 | 102.7103 | 2020-07-12 04:34:30 | Sichuan, China | ||
3237692 | 3237692 | 2020-07-10 | China | Sichuan | 599 | 3 | 582 | 14 | 30.6171 | 102.7103 | 2020-07-11 04:34:26 | Sichuan, China | ||
1005677 | 1005677 | 2020-07-09 | China | Sichuan | 599 | 3 | 582 | 14 | 30.6171 | 102.7103 | 2020-07-10 04:34:24 | Sichuan, China | ||
2222893 | 2222893 | 2020-07-08 | China | Sichuan | 599 | 3 | 582 | 14 | 30.6171 | 102.7103 | 2020-07-09 04:34:23 | Sichuan, China | ||
887502 | 887502 | 2020-07-07 | China | Sichuan | 598 | 3 | 581 | 14 | 30.6171 | 102.7103 | 2020-07-08 05:33:48 | Sichuan, China | ||
2685062 | 2685062 | 2020-07-06 | China | Sichuan | 596 | 3 | 581 | 12 | 30.6171 | 102.7103 | 2020-07-07 04:34:00 | Sichuan, China | ||
415527 | 415527 | 2020-07-05 | China | Sichuan | 596 | 3 | 581 | 12 | 30.6171 | 102.7103 | 2020-07-06 04:33:57 | Sichuan, China | ||
530089 | 530089 | 2020-07-04 | China | Sichuan | 596 | 3 | 581 | 12 | 30.6171 | 102.7103 | 2020-07-05 04:33:46 | Sichuan, China | ||
2234750 | 2234750 | 2020-07-03 | China | Sichuan | 595 | 3 | 581 | 11 | 30.6171 | 102.7103 | 2020-07-04 04:33:51 | Sichuan, China | ||
3045544 | 3045544 | 2020-07-02 | China | Sichuan | 595 | 3 | 581 | 11 | 30.6171 | 102.7103 | 2020-07-03 04:33:54 | Sichuan, China | ||
303235 | 303235 | 2020-07-01 | China | Sichuan | 595 | 3 | 580 | 12 | 30.6171 | 102.7103 | 2020-07-02 04:33:46 | Sichuan, China | ||
2974613 | 2974613 | 2020-06-30 | China | Sichuan | 595 | 3 | 580 | 12 | 30.6171 | 102.7103 | 2020-07-01 04:33:52 | Sichuan, China | ||
2633090 | 2633090 | 2020-06-29 | China | Sichuan | 595 | 3 | 578 | 14 | 30.6171 | 102.7103 | 2020-06-30 04:33:48 | Sichuan, China | ||
2306653 | 2306653 | 2020-06-28 | China | Sichuan | 592 | 3 | 577 | 12 | 30.6171 | 102.7103 | 2020-06-29 04:33:44 | Sichuan, China | ||
2039988 | 2039988 | 2020-06-27 | China | Sichuan | 589 | 3 | 575 | 11 | 30.6171 | 102.7103 | 2020-06-28 04:34:04 | Sichuan, China | ||
1136269 | 1136269 | 2020-06-26 | China | Sichuan | 589 | 3 | 575 | 11 | 30.6171 | 102.7103 | 2020-06-27 04:33:35 | Sichuan, China | ||
2625256 | 2625256 | 2020-06-25 | China | Sichuan | 589 | 3 | 575 | 11 | 30.6171 | 102.7103 | 2020-06-26 04:33:43 | Sichuan, China | ||
2700896 | 2700896 | 2020-06-24 | China | Sichuan | 589 | 3 | 575 | 11 | 30.6171 | 102.7103 | 2020-06-25 05:26:54 | Sichuan, China | ||
1522581 | 1522581 | 2020-06-23 | China | Sichuan | 589 | 3 | 573 | 13 | 30.6171 | 102.7103 | 2020-06-24 04:33:28 | Sichuan, China | ||
1510775 | 1510775 | 2020-06-22 | China | Sichuan | 589 | 3 | 572 | 14 | 30.6171 | 102.7103 | 2020-06-23 04:33:22 | Sichuan, China | ||
3249514 | 3249514 | 2020-06-21 | China | Sichuan | 589 | 3 | 570 | 16 | 30.6171 | 102.7103 | 2020-06-22 04:33:20 | Sichuan, China | ||
2438107 | 2438107 | 2020-06-20 | China | Sichuan | 589 | 3 | 570 | 16 | 30.6171 | 102.7103 | 2020-06-21 04:33:19 | Sichuan, China | ||
1691685 | 1691685 | 2020-06-19 | China | Sichuan | 589 | 3 | 569 | 17 | 30.6171 | 102.7103 | 2020-06-20 04:33:19 | Sichuan, China | ||
3682834 | 3682834 | 2020-06-18 | China | Sichuan | 589 | 3 | 569 | 17 | 30.6171 | 102.7103 | 2020-06-19 04:33:17 | Sichuan, China | ||
1196037 | 1196037 | 2020-06-17 | China | Sichuan | 589 | 3 | 567 | 19 | 30.6171 | 102.7103 | 2020-06-18 04:33:18 | Sichuan, China | ||
2386800 | 2386800 | 2020-06-16 | China | Sichuan | 589 | 3 | 565 | 21 | 30.6171 | 102.7103 | 2020-06-17 04:33:21 | Sichuan, China | ||
287363 | 287363 | 2020-06-15 | China | Sichuan | 588 | 3 | 564 | 21 | 30.6171 | 102.7103 | 2020-06-16 04:33:09 | Sichuan, China | ||
1837314 | 1837314 | 2020-06-14 | China | Sichuan | 587 | 3 | 563 | 21 | 30.6171 | 102.7103 | 2020-06-15 03:33:14 | Sichuan, China | ||
3061366 | 3061366 | 2020-06-13 | China | Sichuan | 583 | 3 | 563 | 17 | 30.6171 | 102.7103 | 2020-06-14 03:33:15 | Sichuan, China | ||
737686 | 737686 | 2020-06-12 | China | Sichuan | 583 | 3 | 562 | 18 | 30.6171 | 102.7103 | 2020-06-13 03:33:14 | Sichuan, China | ||
1273656 | 1273656 | 2020-06-11 | China | Sichuan | 582 | 3 | 561 | 18 | 30.6171 | 102.7103 | 2020-06-12 05:09:52 | Sichuan, China | ||
2864097 | 2864097 | 2020-06-10 | China | Sichuan | 582 | 3 | 560 | 19 | 30.6171 | 102.7103 | 2020-06-11 03:33:41 | Sichuan, China | ||
1210923 | 1210923 | 2020-06-09 | China | Sichuan | 582 | 3 | 558 | 21 | 30.6171 | 102.7103 | 2020-06-10 04:07:00 | Sichuan, China | ||
217350 | 217350 | 2020-06-08 | China | Sichuan | 582 | 3 | 558 | 21 | 30.6171 | 102.7103 | 2020-06-09 03:33:03 | 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]);