daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,073 rows where province_or_state = "Shandong" sorted by combined_key
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: confirmed, deaths, active, day (date), last_update (date)
country_or_region 2
- China 1,024
- Mainland China 49
province_or_state 1
- Shandong · 1,073 ✖
day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2020-03-05 | Mainland China | Shandong | 758 | 6 | 578 | 36.3427 | 118.1498 | 2020-03-05T14:53:03 | ||||
2020-03-07 | Mainland China | Shandong | 758 | 6 | 627 | 36.3427 | 118.1498 | 2020-03-07T13:03:05 | ||||
2020-03-04 | Mainland China | Shandong | 758 | 6 | 516 | 36.3427 | 118.1498 | 2020-03-04T12:53:03 | ||||
2020-02-15 | Mainland China | Shandong | 532 | 2 | 156 | 36.3427 | 118.1498 | 2020-02-15T11:23:17 | ||||
2020-01-24 | Mainland China | Shandong | 15 | 0 | 0 | 36.3427 | 118.1498 | 1/24/20 17:00 | ||||
2020-01-29 | Mainland China | Shandong | 130 | 0 | 1 | 36.3427 | 118.1498 | 1/29/20 19:30 | ||||
2020-03-03 | Mainland China | Shandong | 758 | 6 | 511 | 36.3427 | 118.1498 | 2020-03-03T07:53:03 | ||||
2020-03-21 | China | Shandong | 764 | 7 | 749 | 36.3427 | 118.1498 | 2020-03-21T00:43:02 | ||||
2020-01-26 | Mainland China | Shandong | 46 | 0 | 0 | 36.3427 | 118.1498 | 1/26/20 16:00 | ||||
2020-02-25 | Mainland China | Shandong | 756 | 6 | 355 | 36.3427 | 118.1498 | 2020-02-25T12:53:02 | ||||
2020-03-01 | Mainland China | Shandong | 758 | 6 | 443 | 36.3427 | 118.1498 | 2020-03-01T11:33:03 | ||||
2020-02-06 | Mainland China | Shandong | 347 | 0 | 27 | 36.3427 | 118.1498 | 2020-02-06T07:53:02 | ||||
2020-02-27 | Mainland China | Shandong | 756 | 6 | 387 | 36.3427 | 118.1498 | 2020-02-27T14:13:06 | ||||
2020-03-09 | Mainland China | Shandong | 758 | 6 | 700 | 36.3427 | 118.1498 | 2020-03-09T10:13:06 | ||||
2020-01-23 | Mainland China | Shandong | 6 | 0 | 0 | 36.3427 | 118.1498 | 1/23/20 17:00 | ||||
2020-02-22 | Mainland China | Shandong | 750 | 4 | 302 | 36.3427 | 118.1498 | 2020-02-22T09:43:02 | ||||
2020-03-02 | Mainland China | Shandong | 758 | 6 | 460 | 36.3427 | 118.1498 | 2020-03-02T08:03:12 | ||||
2020-03-18 | China | Shandong | 761 | 7 | 746 | 36.3427 | 118.1498 | 2020-03-17T00:33:02 | ||||
2020-02-14 | Mainland China | Shandong | 523 | 2 | 136 | 36.3427 | 118.1498 | 2020-02-14T11:13:22 | ||||
2020-02-17 | Mainland China | Shandong | 541 | 2 | 191 | 36.3427 | 118.1498 | 2020-02-17T11:03:06 | ||||
2020-01-28 | Mainland China | Shandong | 95 | 0 | 0 | 36.3427 | 118.1498 | 1/28/20 23:00 | ||||
2020-02-08 | Mainland China | Shandong | 416 | 0 | 44 | 36.3427 | 118.1498 | 2020-02-08T11:33:02 | ||||
2020-03-15 | China | Shandong | 760 | 7 | 741 | 36.3427 | 118.1498 | 2020-03-14T04:33:02 | ||||
2020-03-19 | China | Shandong | 761 | 7 | 747 | 36.3427 | 118.1498 | 2020-03-19T01:02:56 | ||||
2020-03-08 | Mainland China | Shandong | 758 | 6 | 642 | 36.3427 | 118.1498 | 2020-03-08T10:03:11 | ||||
2020-01-30 | Mainland China | Shandong | 158 | 0 | 1 | 36.3427 | 118.1498 | 1/30/20 16:00 | ||||
2020-02-13 | Mainland China | Shandong | 509 | 2 | 105 | 36.3427 | 118.1498 | 2020-02-13T13:33:01 | ||||
2020-02-19 | Mainland China | Shandong | 544 | 3 | 231 | 36.3427 | 118.1498 | 2020-02-19T12:03:07 | ||||
2020-02-18 | Mainland China | Shandong | 543 | 3 | 211 | 36.3427 | 118.1498 | 2020-02-18T12:13:08 | ||||
2020-01-22 | Mainland China | Shandong | 2 | 0 | 0 | 36.3427 | 118.1498 | 1/22/2020 17:00 | ||||
2020-02-16 | Mainland China | Shandong | 537 | 2 | 173 | 36.3427 | 118.1498 | 2020-02-16T12:03:06 | ||||
2020-02-05 | Mainland China | Shandong | 307 | 0 | 15 | 36.3427 | 118.1498 | 2020-02-05T10:13:13 | ||||
2020-03-14 | China | Shandong | 760 | 7 | 741 | 36.3427 | 118.1498 | 2020-03-14T04:33:02 | ||||
2020-03-11 | China | Shandong | 760 | 6 | 726 | 36.3427 | 118.1498 | 2020-03-11T11:33:07 | ||||
2020-02-21 | Mainland China | Shandong | 749 | 4 | 281 | 36.3427 | 118.1498 | 2020-02-21T10:23:02 | ||||
2020-03-16 | China | Shandong | 760 | 7 | 746 | 36.3427 | 118.1498 | 2020-03-16T14:38:45 | ||||
2020-02-20 | Mainland China | Shandong | 546 | 4 | 254 | 36.3427 | 118.1498 | 2020-02-20T11:13:27 | ||||
2020-03-12 | China | Shandong | 760 | 6 | 734 | 36.3427 | 118.1498 | 2020-03-12T07:53:02 | ||||
2020-02-02 | Mainland China | Shandong | 230 | 0 | 6 | 36.3427 | 118.1498 | 2020-02-02T18:03:05 | ||||
2020-02-26 | Mainland China | Shandong | 756 | 6 | 377 | 36.3427 | 118.1498 | 2020-02-26T12:43:02 | ||||
2020-02-12 | Mainland China | Shandong | 497 | 2 | 92 | 36.3427 | 118.1498 | 2020-02-12T11:13:05 | ||||
2020-02-03 | Mainland China | Shandong | 259 | 0 | 7 | 36.3427 | 118.1498 | 2020-02-03T17:11:34 | ||||
2020-02-28 | Mainland China | Shandong | 756 | 6 | 405 | 36.3427 | 118.1498 | 2020-02-28T09:23:02 | ||||
2020-01-25 | Mainland China | Shandong | 27 | 0 | 0 | 36.3427 | 118.1498 | 1/25/20 17:00 | ||||
2020-02-10 | Mainland China | Shandong | 466 | 1 | 66 | 36.3427 | 118.1498 | 2020-02-10T09:33:02 | ||||
2020-02-23 | Mainland China | Shandong | 754 | 4 | 321 | 36.3427 | 118.1498 | 2020-02-23T11:33:03 | ||||
2020-03-06 | Mainland China | Shandong | 758 | 6 | 618 | 36.3427 | 118.1498 | 2020-03-06T11:03:10 | ||||
2020-02-11 | Mainland China | Shandong | 487 | 1 | 80 | 36.3427 | 118.1498 | 2020-02-11T11:23:04 | ||||
2020-02-29 | Mainland China | Shandong | 756 | 6 | 421 | 36.3427 | 118.1498 | 2020-02-29T15:33:03 | ||||
2020-02-07 | Mainland China | Shandong | 386 | 0 | 37 | 36.3427 | 118.1498 | 2020-02-07T11:33:11 | ||||
2020-02-09 | Mainland China | Shandong | 444 | 1 | 63 | 36.3427 | 118.1498 | 2020-02-09T15:03:05 | ||||
2020-02-01 | Mainland China | Shandong | 206 | 0 | 3 | 36.3427 | 118.1498 | 2/1/2020 7:51 | ||||
2020-02-04 | Mainland China | Shandong | 275 | 0 | 11 | 36.3427 | 118.1498 | 2020-02-04T12:03:04 | ||||
2020-02-24 | Mainland China | Shandong | 755 | 5 | 343 | 36.3427 | 118.1498 | 2020-02-24T10:23:02 | ||||
2020-03-20 | China | Shandong | 762 | 7 | 748 | 36.3427 | 118.1498 | 2020-03-20T01:13:16 | ||||
2020-03-10 | Mainland China | Shandong | 758 | 6 | 719 | 36.3427 | 118.1498 | 2020-03-10T07:33:03 | ||||
2020-01-27 | Mainland China | Shandong | 75 | 0 | 0 | 36.3427 | 118.1498 | 1/27/20 23:59 | ||||
2020-01-31 | Mainland China | Shandong | 184 | 0 | 2 | 36.3427 | 118.1498 | 1/31/2020 23:59 | ||||
2020-03-13 | China | Shandong | 760 | 7 | 739 | 36.3427 | 118.1498 | 2020-03-13T11:09:03 | ||||
2020-03-17 | China | Shandong | 761 | 7 | 746 | 36.3427 | 118.1498 | 2020-03-17T00:33:02 | ||||
2021-12-02 | China | Shandong | 1021 | 7 | 0 | 36.3427 | 118.1498 | 2021-12-03 04:23:05 | Shandong, China | |||
2021-10-28 | China | Shandong | 974 | 7 | 0 | 36.3427 | 118.1498 | 2021-10-29 04:22:03 | Shandong, China | |||
2020-10-25 | China | Shandong | 845 | 7 | 828 | 10 | 36.3427 | 118.1498 | 2020-10-26 04:25:02 | Shandong, China | ||
2021-01-26 | China | Shandong | 866 | 7 | 857 | 2 | 36.3427 | 118.1498 | 2021-01-27 05:23:41 | Shandong, China | ||
2021-09-18 | China | Shandong | 929 | 7 | 0 | 36.3427 | 118.1498 | 2021-09-19 04:21:34 | Shandong, China | |||
2021-05-28 | China | Shandong | 883 | 7 | 873 | 3 | 36.3427 | 118.1498 | 2021-05-29 04:20:41 | Shandong, China | ||
2022-03-20 | China | Shandong | 2457 | 7 | 0 | 36.3427 | 118.1498 | 2022-03-21 04:20:50 | Shandong, China | |||
2021-11-11 | China | Shandong | 993 | 7 | 0 | 36.3427 | 118.1498 | 2021-11-12 04:22:01 | Shandong, China | |||
2021-08-25 | China | Shandong | 923 | 7 | 0 | 36.3427 | 118.1498 | 2021-08-26 04:21:28 | Shandong, China | |||
2021-04-12 | China | Shandong | 873 | 7 | 862 | 4 | 36.3427 | 118.1498 | 2021-04-13 04:20:37 | Shandong, China | ||
2020-04-13 | China | Shandong | 784 | 7 | 758 | 19 | 36.3427 | 118.1498 | 2020-04-13 09:36:31 | Shandong, China | ||
2021-11-02 | China | Shandong | 986 | 7 | 0 | 36.3427 | 118.1498 | 2021-11-03 06:22:09 | Shandong, China | |||
2020-04-17 | China | Shandong | 787 | 7 | 761 | 19 | 36.3427 | 118.1498 | 2020-04-17 00:37:40 | Shandong, China | ||
2021-05-29 | China | Shandong | 883 | 7 | 873 | 3 | 36.3427 | 118.1498 | 2021-05-30 04:20:55 | Shandong, China | ||
2021-03-07 | China | Shandong | 869 | 7 | 861 | 1 | 36.3427 | 118.1498 | 2021-03-08 05:24:48 | Shandong, China | ||
2020-07-23 | China | Shandong | 798 | 7 | 785 | 6 | 36.3427 | 118.1498 | 2020-07-24 05:30:40 | Shandong, China | ||
2022-11-12 | China | Shandong | 3271 | 7 | 0 | 36.3427 | 118.1498 | 2022-11-13 04:21:14 | Shandong, China | |||
2021-09-01 | China | Shandong | 925 | 7 | 0 | 36.3427 | 118.1498 | 2021-09-02 04:21:15 | Shandong, China | |||
2022-02-07 | China | Shandong | 1075 | 7 | 0 | 36.3427 | 118.1498 | 2022-02-08 04:21:15 | Shandong, China | |||
2020-12-03 | China | Shandong | 857 | 7 | 841 | 9 | 36.3427 | 118.1498 | 2020-12-04 05:27:27 | Shandong, China | ||
2020-10-14 | China | Shandong | 845 | 7 | 824 | 14 | 36.3427 | 118.1498 | 2020-10-15 04:24:28 | Shandong, China | ||
2021-05-25 | China | Shandong | 883 | 7 | 872 | 4 | 36.3427 | 118.1498 | 2021-05-26 04:20:35 | Shandong, China | ||
2021-11-09 | China | Shandong | 993 | 7 | 0 | 36.3427 | 118.1498 | 2021-11-10 04:21:38 | Shandong, China | |||
2022-07-23 | China | Shandong | 2820 | 7 | 0 | 36.3427 | 118.1498 | 2022-07-24 04:20:47 | Shandong, China | |||
2020-08-04 | China | Shandong | 804 | 7 | 786 | 11 | 36.3427 | 118.1498 | 2020-08-05 04:34:43 | Shandong, China | ||
2022-01-14 | China | Shandong | 1053 | 7 | 0 | 36.3427 | 118.1498 | 2022-01-15 04:21:07 | Shandong, China | |||
2021-08-15 | China | Shandong | 922 | 7 | 0 | 36.3427 | 118.1498 | 2021-08-16 04:21:31 | Shandong, China | |||
2021-06-19 | China | Shandong | 883 | 7 | 875 | 1 | 36.3427 | 118.1498 | 2021-06-20 04:21:48 | Shandong, China | ||
2020-05-08 | China | Shandong | 788 | 7 | 776 | 5 | 36.3427 | 118.1498 | 2020-05-09 02:32:35 | Shandong, China | ||
2022-09-06 | China | Shandong | 2979 | 7 | 0 | 36.3427 | 118.1498 | 2022-09-07 04:20:59 | Shandong, China | |||
2020-07-19 | China | Shandong | 793 | 7 | 785 | 1 | 36.3427 | 118.1498 | 2020-07-20 05:34:40 | Shandong, China | ||
2020-11-18 | China | Shandong | 849 | 7 | 841 | 1 | 36.3427 | 118.1498 | 2020-11-19 05:25:23 | Shandong, China | ||
2022-01-09 | China | Shandong | 1050 | 7 | 0 | 36.3427 | 118.1498 | 2022-01-10 04:22:07 | Shandong, China | |||
2022-10-04 | China | Shandong | 3115 | 7 | 0 | 36.3427 | 118.1498 | 2022-10-05 04:23:06 | Shandong, China | |||
2020-04-29 | China | Shandong | 787 | 7 | 772 | 8 | 36.3427 | 118.1498 | 2020-04-30 02:32:27 | Shandong, China | ||
2021-12-04 | China | Shandong | 1021 | 7 | 0 | 36.3427 | 118.1498 | 2021-12-05 04:22:25 | Shandong, China | |||
2022-07-09 | China | Shandong | 2790 | 7 | 0 | 36.3427 | 118.1498 | 2022-07-10 04:20:54 | Shandong, China | |||
2020-08-15 | China | Shandong | 821 | 7 | 790 | 24 | 36.3427 | 118.1498 | 2020-08-16 04:27:42 | Shandong, China | ||
2021-11-29 | China | Shandong | 1021 | 7 | 0 | 36.3427 | 118.1498 | 2021-11-30 04:22:53 | Shandong, China | |||
2021-01-08 | China | Shandong | 864 | 7 | 852 | 5 | 36.3427 | 118.1498 | 2021-01-09 05:22:18 | Shandong, China |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;