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

19 rows where country_or_region = "Brazil" and province_or_state = "Unknown" sorted by day descending

✎ View and edit SQL

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

Suggested facets: last_update (date)

province_or_state 1

  • Unknown · 19 ✖

country_or_region 1

  • Brazil · 19 ✖
day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
2020-06-07 Brazil Unknown     0 0 283952 0     2020-06-08 03:33:22 Unknown, Brazil
2020-06-06 Brazil Unknown     0 0 277149 0     2020-06-07 03:53:30 Unknown, Brazil
2020-06-05 Brazil Unknown     0 0 266940 0     2020-06-06 02:33:00 Unknown, Brazil
2020-06-04 Brazil Unknown     0 0 254963 0     2020-06-05 02:33:06 Unknown, Brazil
2020-06-03 Brazil Unknown     0 0 238617 0     2020-06-04 02:33:14 Unknown, Brazil
2020-06-02 Brazil Unknown     0 0 223638 0     2020-06-03 02:33:13 Unknown, Brazil
2020-06-01 Brazil Unknown     0 0 211080 0     2020-06-02 02:33:08 Unknown, Brazil
2020-05-31 Brazil Unknown     0 0 206555 0     2020-06-01 02:32:46 Unknown, Brazil
2020-05-30 Brazil Unknown     0 0 200892 0     2020-05-31 02:32:45 Unknown, Brazil
2020-05-29 Brazil Unknown     0 0 189476 0     2020-05-30 02:32:48 Unknown, Brazil
2020-05-28 Brazil Unknown     0 0 177604 0     2020-05-29 02:32:50 Unknown, Brazil
2020-05-27 Brazil Unknown     0 0 166647 0     2020-05-28 02:32:31 Unknown, Brazil
2020-05-26 Brazil Unknown     0 0 158593 0     2020-05-27 02:32:31 Unknown, Brazil
2020-05-25 Brazil Unknown     0 0 153833 0     2020-05-26 02:32:35 Unknown, Brazil
2020-05-24 Brazil Unknown     0 0 149911 0     2020-05-25 02:32:44 Unknown, Brazil
2020-05-23 Brazil Unknown     0 0 142587 0     2020-05-24 02:32:43 Unknown, Brazil
2020-05-22 Brazil Unknown     0 0 135430 0     2020-05-23 02:32:42 Unknown, Brazil
2020-05-21 Brazil Unknown     0 0 125960 0     2020-05-22 02:36:51 Unknown, Brazil
2020-05-20 Brazil Unknown     0 0 116683 0     2020-05-21 02:32:48 Unknown, Brazil

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;