daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,024 rows where country_or_region = "China" and province_or_state = "Shanghai" sorted by last_update
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date), last_update (date)
day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update ▼ | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2020-03-11 | China | Shanghai | 344 | 3 | 320 | 31.202 | 121.4491 | 2020-03-11T03:13:07 | ||||
2020-03-12 | China | Shanghai | 344 | 3 | 321 | 31.202 | 121.4491 | 2020-03-12T07:53:02 | ||||
2020-03-13 | China | Shanghai | 346 | 3 | 324 | 31.202 | 121.4491 | 2020-03-13T11:09:03 | ||||
2020-03-15 | China | Shanghai | 353 | 3 | 324 | 31.202 | 121.4491 | 2020-03-14T23:53:02 | ||||
2020-03-14 | China | Shanghai | 353 | 3 | 324 | 31.202 | 121.4491 | 2020-03-14T23:53:02 | ||||
2020-03-16 | China | Shanghai | 355 | 3 | 325 | 31.202 | 121.4491 | 2020-03-16T14:38:45 | ||||
2020-03-17 | China | Shanghai | 358 | 3 | 325 | 31.202 | 121.4491 | 2020-03-17T02:13:20 | ||||
2020-03-18 | China | Shanghai | 361 | 3 | 326 | 31.202 | 121.4491 | 2020-03-18T05:53:25 | ||||
2020-03-19 | China | Shanghai | 363 | 3 | 326 | 31.202 | 121.4491 | 2020-03-19T01:02:56 | ||||
2020-03-20 | China | Shanghai | 371 | 3 | 326 | 31.202 | 121.4491 | 2020-03-20T00:43:02 | ||||
2020-03-21 | China | Shanghai | 380 | 3 | 327 | 31.202 | 121.4491 | 2020-03-21T04:43:06 | ||||
2020-03-23 | China | Shanghai | 404 | 4 | 329 | 71 | 31.201999999999998 | 121.4491 | 2020-03-23 14:18:01 | Shanghai, China | ||
2020-03-24 | China | Shanghai | 414 | 4 | 330 | 80 | 31.202 | 121.4491 | 2020-03-24 08:05:18 | Shanghai, China | ||
2020-03-25 | China | Shanghai | 433 | 5 | 330 | 98 | 31.202 | 121.4491 | 2020-03-25 06:43:02 | Shanghai, China | ||
2020-03-26 | China | Shanghai | 451 | 5 | 331 | 115 | 31.201999999999998 | 121.4491 | 2020-03-26 07:31:30 | Shanghai, China | ||
2020-03-27 | China | Shanghai | 468 | 5 | 334 | 129 | 31.202 | 121.4491 | 2020-03-27 04:44:03 | Shanghai, China | ||
2020-03-31 | China | Shanghai | 509 | 5 | 341 | 163 | 31.202 | 121.4491 | 2020-03-31 07:43:11 | Shanghai, China | ||
2020-04-01 | China | Shanghai | 516 | 6 | 341 | 169 | 31.201999999999998 | 121.4491 | 2020-04-01 00:04:18 | Shanghai, China | ||
2020-04-03 | China | Shanghai | 526 | 6 | 348 | 172 | 31.201999999999998 | 121.4491 | 2020-04-03 06:56:51 | Shanghai, China | ||
2020-04-05 | China | Shanghai | 531 | 6 | 383 | 142 | 31.201999999999998 | 121.4491 | 2020-04-05 06:22:56 | Shanghai, China | ||
2020-04-07 | China | Shanghai | 538 | 6 | 406 | 126 | 31.201999999999998 | 121.4491 | 2020-04-07 06:21:55 | Shanghai, China | ||
2020-04-08 | China | Shanghai | 543 | 7 | 418 | 118 | 31.202 | 121.4491 | 2020-04-08 05:20:24 | Shanghai, China | ||
2020-04-09 | China | Shanghai | 552 | 7 | 422 | 123 | 31.201999999999998 | 121.4491 | 2020-04-09 07:01:54 | Shanghai, China | ||
2020-04-10 | China | Shanghai | 555 | 7 | 435 | 113 | 31.202 | 121.4491 | 2020-04-10 08:48:52 | Shanghai, China | ||
2020-04-11 | China | Shanghai | 555 | 7 | 438 | 110 | 31.201999999999998 | 121.4491 | 2020-04-11 08:35:43 | Shanghai, China | ||
2020-04-12 | China | Shanghai | 607 | 7 | 446 | 154 | 31.202 | 121.4491 | 2020-04-12 05:28:00 | Shanghai, China | ||
2020-04-13 | China | Shanghai | 618 | 7 | 446 | 165 | 31.201999999999998 | 121.4491 | 2020-04-13 09:36:31 | Shanghai, China | ||
2020-04-14 | China | Shanghai | 618 | 7 | 468 | 143 | 31.202 | 121.4491 | 2020-04-14 10:39:48 | Shanghai, China | ||
2020-04-15 | China | Shanghai | 622 | 7 | 485 | 130 | 31.201999999999998 | 121.4491 | 2020-04-15 06:12:32 | Shanghai, China | ||
2020-04-16 | China | Shanghai | 628 | 7 | 489 | 132 | 31.202 | 121.4491 | 2020-04-16 06:35:57 | Shanghai, China | ||
2020-04-17 | China | Shanghai | 628 | 7 | 512 | 109 | 31.201999999999998 | 121.4491 | 2020-04-17 06:07:47 | Shanghai, China | ||
2020-04-18 | China | Shanghai | 628 | 7 | 512 | 109 | 31.202 | 121.4491 | 2020-04-17 06:07:47 | Shanghai, China | ||
2020-04-19 | China | Shanghai | 635 | 7 | 521 | 107 | 31.202 | 121.4491 | 2020-04-19 12:30:51 | Shanghai, China | ||
2020-04-21 | China | Shanghai | 638 | 7 | 530 | 101 | 31.201999999999998 | 121.4491 | 2020-04-20 07:50:28 | Shanghai, China | ||
2020-04-20 | China | Shanghai | 638 | 7 | 530 | 101 | 31.202 | 121.4491 | 2020-04-20 07:50:28 | Shanghai, China | ||
2020-04-22 | China | Shanghai | 639 | 7 | 534 | 98 | 31.201999999999998 | 121.4491 | 2020-04-22 07:14:57 | Shanghai, China | ||
2020-04-23 | China | Shanghai | 641 | 7 | 533 | 101 | 31.202 | 121.4491 | 2020-04-24 00:43:27 | Shanghai, China | ||
2020-04-24 | China | Shanghai | 641 | 7 | 558 | 76 | 31.201999999999998 | 121.4491 | 2020-04-25 03:45:48 | Shanghai, China | ||
2020-04-25 | China | Shanghai | 642 | 7 | 558 | 77 | 31.202 | 121.4491 | 2020-04-26 00:08:58 | Shanghai, China | ||
2020-04-26 | China | Shanghai | 642 | 7 | 568 | 67 | 31.201999999999998 | 121.4491 | 2020-04-26 06:29:18 | Shanghai, China | ||
2020-04-27 | China | Shanghai | 644 | 7 | 581 | 56 | 31.202 | 121.4491 | 2020-04-28 01:32:57 | Shanghai, China | ||
2020-04-28 | China | Shanghai | 645 | 7 | 584 | 54 | 31.201999999999998 | 121.4491 | 2020-04-29 02:32:29 | Shanghai, China | ||
2020-04-29 | China | Shanghai | 647 | 7 | 597 | 43 | 31.202 | 121.4491 | 2020-04-30 02:32:27 | Shanghai, China | ||
2020-04-30 | China | Shanghai | 652 | 7 | 599 | 46 | 31.201999999999998 | 121.4491 | 2020-05-01 02:32:28 | Shanghai, China | ||
2020-05-01 | China | Shanghai | 652 | 7 | 612 | 33 | 31.202 | 121.4491 | 2020-05-02 02:32:27 | Shanghai, China | ||
2020-05-02 | China | Shanghai | 652 | 7 | 612 | 33 | 31.201999999999998 | 121.4491 | 2020-05-03 02:32:28 | Shanghai, China | ||
2020-05-03 | China | Shanghai | 655 | 7 | 615 | 33 | 31.202 | 121.4491 | 2020-05-04 02:32:28 | Shanghai, China | ||
2020-05-04 | China | Shanghai | 656 | 7 | 619 | 30 | 31.201999999999998 | 121.4491 | 2020-05-05 02:32:34 | Shanghai, China | ||
2020-05-05 | China | Shanghai | 656 | 7 | 620 | 29 | 31.202 | 121.4491 | 2020-05-06 02:32:31 | Shanghai, China | ||
2020-05-06 | China | Shanghai | 657 | 7 | 620 | 30 | 31.201999999999998 | 121.4491 | 2020-05-07 02:32:28 | Shanghai, China | ||
2020-05-07 | China | Shanghai | 657 | 7 | 623 | 27 | 31.201999999999998 | 121.4491 | 2020-05-08 02:32:32 | Shanghai, China | ||
2020-05-08 | China | Shanghai | 657 | 7 | 623 | 27 | 31.202 | 121.4491 | 2020-05-09 02:32:35 | Shanghai, China | ||
2020-05-09 | China | Shanghai | 659 | 7 | 626 | 26 | 31.201999999999998 | 121.4491 | 2020-05-10 02:32:30 | Shanghai, China | ||
2020-05-10 | China | Shanghai | 659 | 7 | 627 | 25 | 31.202 | 121.4491 | 2020-05-11 02:32:30 | Shanghai, China | ||
2020-05-11 | China | Shanghai | 659 | 7 | 627 | 25 | 31.201999999999998 | 121.4491 | 2020-05-12 03:32:27 | Shanghai, China | ||
2020-05-12 | China | Shanghai | 660 | 7 | 631 | 22 | 31.202 | 121.4491 | 2020-05-13 03:32:26 | Shanghai, China | ||
2020-05-13 | China | Shanghai | 660 | 7 | 633 | 20 | 31.201999999999998 | 121.4491 | 2020-05-14 03:32:28 | Shanghai, China | ||
2020-05-14 | China | Shanghai | 660 | 7 | 638 | 15 | 31.202 | 121.4491 | 2020-05-15 02:33:02 | Shanghai, China | ||
2020-05-15 | China | Shanghai | 665 | 7 | 640 | 18 | 31.201999999999998 | 121.4491 | 2020-05-16 02:32:19 | Shanghai, China | ||
2020-05-16 | China | Shanghai | 665 | 7 | 641 | 17 | 31.202 | 121.4491 | 2020-05-17 02:32:32 | Shanghai, China | ||
2020-05-17 | China | Shanghai | 666 | 7 | 641 | 18 | 31.201999999999998 | 121.4491 | 2020-05-18 02:32:21 | Shanghai, China | ||
2020-05-18 | China | Shanghai | 666 | 7 | 641 | 18 | 31.202 | 121.4491 | 2020-05-19 02:32:18 | Shanghai, China | ||
2020-05-19 | China | Shanghai | 666 | 7 | 641 | 18 | 31.201999999999998 | 121.4491 | 2020-05-20 02:32:19 | Shanghai, China | ||
2020-05-20 | China | Shanghai | 666 | 7 | 641 | 18 | 31.201999999999998 | 121.4491 | 2020-05-21 02:32:48 | Shanghai, China | ||
2020-05-21 | China | Shanghai | 666 | 7 | 641 | 18 | 31.202 | 121.4491 | 2020-05-22 02:36:51 | Shanghai, China | ||
2020-05-22 | China | Shanghai | 667 | 7 | 647 | 13 | 31.201999999999998 | 121.4491 | 2020-05-23 02:32:42 | Shanghai, China | ||
2020-05-23 | China | Shanghai | 668 | 7 | 647 | 14 | 31.202 | 121.4491 | 2020-05-24 02:32:43 | Shanghai, China | ||
2020-05-24 | China | Shanghai | 668 | 7 | 648 | 13 | 31.201999999999998 | 121.4491 | 2020-05-25 02:32:44 | Shanghai, China | ||
2020-05-25 | China | Shanghai | 669 | 7 | 652 | 10 | 31.202 | 121.4491 | 2020-05-26 02:32:35 | Shanghai, China | ||
2020-05-26 | China | Shanghai | 670 | 7 | 653 | 10 | 31.201999999999998 | 121.4491 | 2020-05-27 02:32:31 | Shanghai, China | ||
2020-05-27 | China | Shanghai | 671 | 7 | 655 | 9 | 31.202 | 121.4491 | 2020-05-28 02:32:31 | Shanghai, China | ||
2020-05-28 | China | Shanghai | 671 | 7 | 655 | 9 | 31.201999999999998 | 121.4491 | 2020-05-29 02:32:50 | Shanghai, China | ||
2020-05-29 | China | Shanghai | 672 | 7 | 657 | 8 | 31.202 | 121.4491 | 2020-05-30 02:32:48 | Shanghai, China | ||
2020-05-30 | China | Shanghai | 672 | 7 | 657 | 8 | 31.201999999999998 | 121.4491 | 2020-05-31 02:32:45 | Shanghai, China | ||
2020-05-31 | China | Shanghai | 672 | 7 | 657 | 8 | 31.202 | 121.4491 | 2020-06-01 02:32:46 | Shanghai, China | ||
2020-06-01 | China | Shanghai | 673 | 7 | 660 | 6 | 31.201999999999998 | 121.4491 | 2020-06-02 02:33:08 | Shanghai, China | ||
2020-06-02 | China | Shanghai | 673 | 7 | 661 | 5 | 31.202 | 121.4491 | 2020-06-03 02:33:13 | Shanghai, China | ||
2020-06-03 | China | Shanghai | 673 | 7 | 661 | 5 | 31.201999999999998 | 121.4491 | 2020-06-04 02:33:14 | Shanghai, China | ||
2020-06-04 | China | Shanghai | 677 | 7 | 662 | 8 | 31.202 | 121.4491 | 2020-06-05 02:33:06 | Shanghai, China | ||
2020-06-05 | China | Shanghai | 677 | 7 | 663 | 7 | 31.201999999999998 | 121.4491 | 2020-06-06 02:33:00 | Shanghai, China | ||
2020-06-06 | China | Shanghai | 677 | 7 | 664 | 6 | 31.202 | 121.4491 | 2020-06-07 03:53:30 | Shanghai, China | ||
2020-06-07 | China | Shanghai | 678 | 7 | 664 | 7 | 31.201999999999998 | 121.4491 | 2020-06-08 03:33:22 | Shanghai, China | ||
2020-06-08 | China | Shanghai | 678 | 7 | 664 | 7 | 31.202 | 121.4491 | 2020-06-09 03:33:03 | Shanghai, China | ||
2020-06-09 | China | Shanghai | 678 | 7 | 665 | 6 | 31.201999999999998 | 121.4491 | 2020-06-10 04:07:00 | Shanghai, China | ||
2020-06-10 | China | Shanghai | 684 | 7 | 665 | 12 | 31.202 | 121.4491 | 2020-06-11 03:33:41 | Shanghai, China | ||
2020-06-11 | China | Shanghai | 689 | 7 | 666 | 16 | 31.201999999999998 | 121.4491 | 2020-06-12 05:09:52 | Shanghai, China | ||
2020-06-12 | China | Shanghai | 690 | 7 | 666 | 17 | 31.201999999999998 | 121.4491 | 2020-06-13 03:33:14 | Shanghai, China | ||
2020-06-13 | China | Shanghai | 691 | 7 | 666 | 18 | 31.202 | 121.4491 | 2020-06-14 03:33:15 | Shanghai, China | ||
2020-06-14 | China | Shanghai | 692 | 7 | 667 | 18 | 31.201999999999998 | 121.4491 | 2020-06-15 03:33:14 | Shanghai, China | ||
2020-06-15 | China | Shanghai | 695 | 7 | 667 | 21 | 31.202 | 121.4491 | 2020-06-16 04:33:09 | Shanghai, China | ||
2020-06-16 | China | Shanghai | 695 | 7 | 667 | 21 | 31.201999999999998 | 121.4491 | 2020-06-17 04:33:21 | Shanghai, China | ||
2020-06-17 | China | Shanghai | 697 | 7 | 668 | 22 | 31.202 | 121.4491 | 2020-06-18 04:33:18 | Shanghai, China | ||
2020-06-18 | China | Shanghai | 697 | 7 | 668 | 22 | 31.201999999999998 | 121.4491 | 2020-06-19 04:33:17 | Shanghai, China | ||
2020-06-19 | China | Shanghai | 697 | 7 | 668 | 22 | 31.202 | 121.4491 | 2020-06-20 04:33:19 | Shanghai, China | ||
2020-06-20 | China | Shanghai | 698 | 7 | 668 | 23 | 31.201999999999998 | 121.4491 | 2020-06-21 04:33:19 | Shanghai, China | ||
2020-06-21 | China | Shanghai | 701 | 7 | 668 | 26 | 31.202 | 121.4491 | 2020-06-22 04:33:20 | Shanghai, China | ||
2020-06-22 | China | Shanghai | 701 | 7 | 669 | 25 | 31.201999999999998 | 121.4491 | 2020-06-23 04:33:22 | Shanghai, China | ||
2020-06-23 | China | Shanghai | 703 | 7 | 669 | 27 | 31.202 | 121.4491 | 2020-06-24 04:33:28 | Shanghai, China | ||
2020-06-24 | China | Shanghai | 703 | 7 | 670 | 26 | 31.201999999999998 | 121.4491 | 2020-06-25 05:26:54 | Shanghai, China | ||
2020-06-25 | China | Shanghai | 705 | 7 | 672 | 26 | 31.201999999999998 | 121.4491 | 2020-06-26 04:33:43 | Shanghai, China |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;