daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
14 rows where country_or_region = "Japan" and deaths = 401 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state 8
country_or_region 1
- Japan · 14 ✖
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-12-26 | Japan | Nagasaki | 270017 | 401 | 0 | 33.235712 | 129.608033 | 2022-12-27 04:21:07 | Nagasaki, Japan | |||
2022-12-02 | Japan | Aomori | 210163 | 401 | 0 | 40.781541 | 140.828896 | 2022-12-03 04:21:02 | Aomori, Japan | |||
2022-11-27 | Japan | Miyazaki | 214150 | 401 | 0 | 32.193204 | 131.299374 | 2022-11-28 04:21:02 | Miyazaki, Japan | |||
2022-11-26 | Japan | Miyazaki | 213746 | 401 | 0 | 32.193204 | 131.299374 | 2022-11-27 04:21:05 | Miyazaki, Japan | |||
2022-11-04 | Japan | Yamaguchi | 177861 | 401 | 0 | 34.20119 | 131.573293 | 2022-11-05 04:21:52 | Yamaguchi, Japan | |||
2022-11-01 | Japan | Oita | 184295 | 401 | 0 | 33.200697 | 131.43324 | 2022-11-02 04:22:09 | Oita, Japan | |||
2022-10-31 | Japan | Oita | 183922 | 401 | 0 | 33.200697 | 131.43324 | 2022-11-01 04:22:36 | Oita, Japan | |||
2022-10-30 | Japan | Oita | 183751 | 401 | 0 | 33.200697 | 131.43324 | 2022-10-31 04:21:36 | Oita, Japan | |||
2022-10-29 | Japan | Oita | 183483 | 401 | 0 | 33.200697 | 131.43324 | 2022-10-30 04:22:14 | Oita, Japan | |||
2022-10-28 | Japan | Oita | 183168 | 401 | 0 | 33.200697 | 131.43324 | 2022-10-29 04:21:13 | Oita, Japan | |||
2022-09-23 | Japan | Okayama | 269567 | 401 | 0 | 34.89246 | 133.826252 | 2022-09-24 04:21:40 | Okayama, Japan | |||
2022-04-28 | Japan | Shizuoka | 145658 | 401 | 0 | 34.916975 | 138.407784 | 2022-04-29 04:20:59 | Shizuoka, Japan | |||
2022-04-27 | Japan | Shizuoka | 144921 | 401 | 0 | 34.916975 | 138.407784 | 2022-04-28 04:20:47 | Shizuoka, Japan | |||
2020-12-22 | Japan | Hokkaido | 12377 | 401 | 10065 | 1911 | 43.385711 | 142.552318 | 2020-12-23 05:22:03 | Hokkaido, Japan |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;