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

4 rows where country_or_region = "Australia" and deaths = 63 sorted by day descending

✎ View and edit SQL

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

Suggested facets: latitude, combined_key, day (date)

province_or_state 3

country_or_region 1

  • Australia · 4 ✖
day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
2022-08-18 Australia Northern Territory     94532 63 0   -12.4634 130.8456 2022-08-19 04:20:54 Northern Territory, Australia
2022-05-13 Australia Tasmania     149292 63 0   -42.8821 147.3272 2022-05-14 04:20:48 Tasmania, Australia
2022-05-12 Australia Tasmania     148367 63 0   -42.8821 147.3272 2022-05-13 04:20:51 Tasmania, Australia
2022-01-18 Australia Queensland     265565 63 0   -27.4698 153.0251 2022-01-19 04:21:23 Queensland, Australia

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;