daily_reports (view)

⚠️ This table has been renamed. Use johns_hopkins_csse_daily_reports instead.

Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette

9 rows where country_or_region = "Japan" and deaths = 593 sorted by day descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

province_or_state 7

country_or_region 1

  • Japan · 9 ✖
day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
2022-12-28 Japan Kagoshima     359642 593 0   31.009484 130.430665 2022-12-29 04:21:01 Kagoshima, Japan
2022-11-29 Japan Gunma     297267 593 0   36.504479 138.985605 2022-11-30 04:21:07 Gunma, Japan
2022-10-06 Japan Gifu     293898 593 0   35.778671 137.055925 2022-10-07 04:23:08 Gifu, Japan
2022-10-05 Japan Gifu     293361 593 0   35.778671 137.055925 2022-10-06 04:21:22 Gifu, Japan
2022-08-27 Japan Okinawa     465534 593 0   25.768923 126.668016 2022-08-28 04:21:02 Okinawa, Japan
2022-08-26 Japan Okinawa     462636 593 0   25.768923 126.668016 2022-08-27 04:20:57 Okinawa, Japan
2021-09-17 Japan Fukuoka     72791 593 0   33.526032 130.666949 2021-09-18 04:21:24 Fukuoka, Japan
2021-04-05 Japan Aichi     27900 593 26232 1075 35.035551 137.211621 2021-04-06 04:20:32 Aichi, Japan
2021-02-11 Japan Kanagawa     42896 593 40415 1888 35.415312 139.338983 2021-02-12 05:23:29 Kanagawa, Japan

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;