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 recovered = 383 sorted by day descending

✎ View and edit SQL

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

province_or_state 5

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
2020-11-14 Japan Fukushima     431 6 383 42 37.378867 140.223295 2020-11-15 05:26:53 Fukushima, Japan
2020-10-03 Japan Tochigi     434 1 383 50 36.689912 139.819213 2020-10-04 04:23:44 Tochigi, Japan
2020-10-03 Japan Toyama     422 26 383 13 36.637464 137.26934599999998 2020-10-04 04:23:44 Toyama, Japan
2020-10-02 Japan Tochigi     432 1 383 48 36.689912 139.819213 2020-10-03 04:23:40 Tochigi, Japan
2020-10-02 Japan Toyama     422 26 383 13 36.637464 137.26934599999998 2020-10-03 04:23:40 Toyama, Japan
2020-10-01 Japan Toyama     421 26 383 12 36.637464 137.26934599999998 2020-10-02 04:23:51 Toyama, Japan
2020-09-30 Japan Toyama     419 26 383 10 36.637464 137.26934599999998 2020-10-01 04:23:42 Toyama, Japan
2020-09-18 Japan Mie     469 5 383 81 34.508018 136.376013 2020-09-19 04:22:00 Mie, Japan
2020-08-25 Japan Ishikawa     585 31 383 171 36.769464 136.771027 2020-08-26 04:28:11 Ishikawa, Japan

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;