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

18 rows where country_or_region = "Lithuania" and deaths = 63 sorted by day descending

✎ View and edit SQL

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

Suggested facets: recovered, active, day (date), last_update (date)

country_or_region 1

  • Lithuania · 18 ✖

province_or_state 0

day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
2020-08-04 Lithuania       2071 63 1672 396 55.1694 23.8813 2020-08-05 04:34:43 Lithuania
2020-08-03 Lithuania       2057 63 1668 383 55.1694 23.8813 2020-08-04 04:41:59 Lithuania
2020-08-02 Lithuania       2050 63 1667 374 55.1694 23.8813 2020-08-03 04:34:35 Lithuania
2020-08-01 Lithuania       2032 63 1659 365 55.1694 23.8813 2020-08-02 04:34:47 Lithuania
2020-07-31 Lithuania       2016 63 1655 351 55.1694 23.8813 2020-08-01 04:36:27 Lithuania
2020-07-30 Lithuania       2008 63 1652 341 55.1694 23.8813 2020-07-31 04:35:18 Lithuania
2020-07-29 Lithuania       1933 63 1647 327 55.1694 23.8813 2020-07-30 04:35:05 Lithuania
2020-07-28 Lithuania       1912 63 1643 316 55.1694 23.8813 2020-07-29 04:35:11 Lithuania
2020-07-27 Lithuania       1908 63 1640 311 55.1694 23.8813 2020-07-28 04:58:43 Lithuania
2020-07-26 Lithuania       1904 63 1634 306 55.1694 23.8813 2020-07-27 04:35:02 Lithuania
2020-07-25 Lithuania       1900 63 1633 300 55.1694 23.8813 2020-07-26 04:35:00 Lithuania
2020-07-24 Lithuania       1896 63 1632 287 55.1694 23.8813 2020-07-25 04:47:39 Lithuania
2020-07-23 Lithuania       1892 63 1632 261 55.1694 23.8813 2020-07-24 05:30:40 Lithuania
2020-07-22 Lithuania       1889 63 1626 257 55.1694 23.8813 2020-07-23 05:15:04 Lithuania
2020-07-21 Lithuania       1886 63 1623 258 55.1694 23.8813 2020-07-22 04:34:42 Lithuania
2020-07-20 Lithuania       1881 63 1621 258 55.1694 23.8813 2020-07-21 04:38:46 Lithuania
2020-07-19 Lithuania       1874 63 1620 245 55.1694 23.8813 2020-07-20 05:34:40 Lithuania
2020-07-18 Lithuania       1858 63 1619 228 55.1694 23.8813 2020-07-19 04:34:58 Lithuania

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;