daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
33 rows where country_or_region = "Mainland China", deaths = 1 and province_or_state = "Jilin" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: confirmed, recovered, last_update, 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-10 | Mainland China | Jilin | 93 | 1 | 91 | 43.6661 | 126.1923 | 2020-03-09T14:33:03 | ||||
2020-03-09 | Mainland China | Jilin | 93 | 1 | 91 | 43.6661 | 126.1923 | 2020-03-09T14:33:03 | ||||
2020-03-08 | Mainland China | Jilin | 93 | 1 | 90 | 43.6661 | 126.1923 | 2020-03-06T10:23:03 | ||||
2020-03-07 | Mainland China | Jilin | 93 | 1 | 90 | 43.6661 | 126.1923 | 2020-03-06T10:23:03 | ||||
2020-03-06 | Mainland China | Jilin | 93 | 1 | 90 | 43.6661 | 126.1923 | 2020-03-06T10:23:03 | ||||
2020-03-05 | Mainland China | Jilin | 93 | 1 | 88 | 43.6661 | 126.1923 | 2020-03-05T14:53:03 | ||||
2020-03-04 | Mainland China | Jilin | 93 | 1 | 86 | 43.6661 | 126.1923 | 2020-03-04T10:03:19 | ||||
2020-03-03 | Mainland China | Jilin | 93 | 1 | 83 | 43.6661 | 126.1923 | 2020-03-02T15:03:23 | ||||
2020-03-02 | Mainland China | Jilin | 93 | 1 | 83 | 43.6661 | 126.1923 | 2020-03-02T15:03:23 | ||||
2020-03-01 | Mainland China | Jilin | 93 | 1 | 78 | 43.6661 | 126.1923 | 2020-03-01T09:43:03 | ||||
2020-02-29 | Mainland China | Jilin | 93 | 1 | 75 | 43.6661 | 126.1923 | 2020-02-29T09:13:10 | ||||
2020-02-28 | Mainland China | Jilin | 93 | 1 | 73 | 43.6661 | 126.1923 | 2020-02-28T08:53:03 | ||||
2020-02-27 | Mainland China | Jilin | 93 | 1 | 67 | 43.6661 | 126.1923 | 2020-02-27T12:43:02 | ||||
2020-02-26 | Mainland China | Jilin | 93 | 1 | 65 | 43.6661 | 126.1923 | 2020-02-26T14:13:10 | ||||
2020-02-25 | Mainland China | Jilin | 93 | 1 | 63 | 43.6661 | 126.1923 | 2020-02-25T15:23:04 | ||||
2020-02-24 | Mainland China | Jilin | 93 | 1 | 60 | 43.6661 | 126.1923 | 2020-02-24T09:43:02 | ||||
2020-02-23 | Mainland China | Jilin | 91 | 1 | 54 | 43.6661 | 126.1923 | 2020-02-23T12:43:02 | ||||
2020-02-22 | Mainland China | Jilin | 91 | 1 | 52 | 43.6661 | 126.1923 | 2020-02-22T12:33:04 | ||||
2020-02-21 | Mainland China | Jilin | 91 | 1 | 45 | 43.6661 | 126.1923 | 2020-02-21T10:13:09 | ||||
2020-02-20 | Mainland China | Jilin | 91 | 1 | 43 | 43.6661 | 126.1923 | 2020-02-20T09:43:01 | ||||
2020-02-19 | Mainland China | Jilin | 90 | 1 | 37 | 43.6661 | 126.1923 | 2020-02-19T06:03:08 | ||||
2020-02-18 | Mainland China | Jilin | 89 | 1 | 36 | 43.6661 | 126.1923 | 2020-02-18T07:43:02 | ||||
2020-02-17 | Mainland China | Jilin | 89 | 1 | 34 | 43.6661 | 126.1923 | 2020-02-17T11:03:06 | ||||
2020-02-16 | Mainland China | Jilin | 89 | 1 | 30 | 43.6661 | 126.1923 | 2020-02-16T10:03:06 | ||||
2020-02-15 | Mainland China | Jilin | 88 | 1 | 26 | 43.6661 | 126.1923 | 2020-02-15T12:13:08 | ||||
2020-02-14 | Mainland China | Jilin | 86 | 1 | 25 | 43.6661 | 126.1923 | 2020-02-14T00:43:02 | ||||
2020-02-13 | Mainland China | Jilin | 84 | 1 | 24 | 43.6661 | 126.1923 | 2020-02-13T13:33:01 | ||||
2020-02-12 | Mainland China | Jilin | 83 | 1 | 22 | 43.6661 | 126.1923 | 2020-02-12T14:13:08 | ||||
2020-02-11 | Mainland China | Jilin | 81 | 1 | 18 | 43.6661 | 126.1923 | 2020-02-11T08:03:06 | ||||
2020-02-10 | Mainland China | Jilin | 80 | 1 | 13 | 43.6661 | 126.1923 | 2020-02-10T14:03:05 | ||||
2020-02-09 | Mainland China | Jilin | 78 | 1 | 12 | 43.6661 | 126.1923 | 2020-02-09T09:03:04 | ||||
2020-02-08 | Mainland China | Jilin | 69 | 1 | 4 | 43.6661 | 126.1923 | 2020-02-08T00:13:04 | ||||
2020-02-07 | Mainland China | Jilin | 65 | 1 | 4 | 43.6661 | 126.1923 | 2020-02-07T00:43:02 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;