daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
20 rows where deaths = 62 and province_or_state = "Ishikawa" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: confirmed, recovered, active, day (date), last_update (date)
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2021-03-16 | Japan | Ishikawa | 1887 | 62 | 1800 | 25 | 36.769464 | 136.771027 | 2021-03-17 05:25:07 | Ishikawa, Japan | ||
2021-03-15 | Japan | Ishikawa | 1886 | 62 | 1796 | 28 | 36.769464 | 136.771027 | 2021-03-16 05:25:13 | Ishikawa, Japan | ||
2021-03-14 | Japan | Ishikawa | 1886 | 62 | 1796 | 28 | 36.769464 | 136.771027 | 2021-03-15 05:25:51 | Ishikawa, Japan | ||
2021-03-13 | Japan | Ishikawa | 1883 | 62 | 1792 | 29 | 36.769464 | 136.771027 | 2021-03-14 05:25:37 | Ishikawa, Japan | ||
2021-03-12 | Japan | Ishikawa | 1879 | 62 | 1784 | 33 | 36.769464 | 136.771027 | 2021-03-13 05:25:15 | Ishikawa, Japan | ||
2021-03-11 | Japan | Ishikawa | 1879 | 62 | 1776 | 41 | 36.769464 | 136.771027 | 2021-03-12 05:26:50 | Ishikawa, Japan | ||
2021-03-10 | Japan | Ishikawa | 1879 | 62 | 1769 | 48 | 36.769464 | 136.771027 | 2021-03-11 05:25:48 | Ishikawa, Japan | ||
2021-03-09 | Japan | Ishikawa | 1879 | 62 | 1759 | 58 | 36.769464 | 136.771027 | 2021-03-10 05:24:35 | Ishikawa, Japan | ||
2021-03-08 | Japan | Ishikawa | 1877 | 62 | 1742 | 73 | 36.769464 | 136.771027 | 2021-03-09 05:28:19 | Ishikawa, Japan | ||
2021-03-07 | Japan | Ishikawa | 1877 | 62 | 1742 | 73 | 36.769464 | 136.771027 | 2021-03-08 05:24:48 | Ishikawa, Japan | ||
2021-03-06 | Japan | Ishikawa | 1877 | 62 | 1730 | 85 | 36.769464 | 136.771027 | 2021-03-07 05:21:54 | Ishikawa, Japan | ||
2021-03-05 | Japan | Ishikawa | 1876 | 62 | 1722 | 92 | 36.769464 | 136.771027 | 2021-03-06 04:23:41 | Ishikawa, Japan | ||
2021-03-04 | Japan | Ishikawa | 1873 | 62 | 1700 | 111 | 36.769464 | 136.771027 | 2021-03-05 05:26:29 | Ishikawa, Japan | ||
2021-03-03 | Japan | Ishikawa | 1870 | 62 | 1700 | 108 | 36.769464 | 136.771027 | 2021-03-04 05:24:24 | Ishikawa, Japan | ||
2021-03-02 | Japan | Ishikawa | 1862 | 62 | 1686 | 114 | 36.769464 | 136.771027 | 2021-03-03 05:23:28 | Ishikawa, Japan | ||
2021-03-01 | Japan | Ishikawa | 1857 | 62 | 1673 | 122 | 36.769464 | 136.771027 | 2021-03-02 05:23:30 | Ishikawa, Japan | ||
2021-02-28 | Japan | Ishikawa | 1851 | 62 | 1663 | 126 | 36.769464 | 136.771027 | 2021-03-01 05:23:01 | Ishikawa, Japan | ||
2021-02-27 | Japan | Ishikawa | 1845 | 62 | 1649 | 134 | 36.769464 | 136.771027 | 2021-02-28 05:22:20 | Ishikawa, Japan | ||
2021-02-26 | Japan | Ishikawa | 1841 | 62 | 1631 | 148 | 36.769464 | 136.771027 | 2021-02-27 05:22:28 | Ishikawa, Japan | ||
2021-02-25 | Japan | Ishikawa | 1830 | 62 | 1616 | 152 | 36.769464 | 136.771027 | 2021-02-26 05:22:40 | Ishikawa, Japan |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;