daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
8 rows where country_or_region = "Japan" and deaths = 478 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
country_or_region 1
- Japan · 8 ✖
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-11-22 | Japan | Miyagi | 333922 | 478 | 0 | 38.446859 | 140.927086 | 2022-11-23 04:21:06 | Miyagi, Japan | |||
2022-10-11 | Japan | Gunma | 241839 | 478 | 0 | 36.504479 | 138.985605 | 2022-10-12 04:22:51 | Gunma, Japan | |||
2022-08-20 | Japan | Kumamoto | 260017 | 478 | 0 | 32.608154 | 130.745231 | 2022-08-21 04:20:44 | Kumamoto, Japan | |||
2022-05-17 | Japan | Hiroshima | 143926 | 478 | 0 | 34.605309 | 132.788719 | 2022-05-18 04:20:50 | Hiroshima, Japan | |||
2021-06-05 | Japan | Fukuoka | 34556 | 478 | 30830 | 3248 | 33.526032 | 130.666949 | 2021-06-06 04:24:03 | Fukuoka, Japan | ||
2021-02-14 | Japan | Aichi | 25231 | 478 | 23242 | 1511 | 35.035551 | 137.211621 | 2021-02-15 05:24:49 | Aichi, Japan | ||
2021-02-13 | Japan | Hyogo | 17469 | 478 | 15933 | 1058 | 35.039913 | 134.828057 | 2021-02-14 05:23:43 | Hyogo, Japan | ||
2020-11-21 | Japan | Tokyo | 37304 | 478 | 32954 | 3872 | 35.711343 | 139.446921 | 2020-11-22 05:25:45 | Tokyo, Japan |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;