daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
40 rows where country_or_region = "Spain" and deaths = 957 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: longitude, combined_key, last_update (date)
country_or_region 1
- Spain · 40 ✖
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-12-08 | Spain | La Rioja | 110327 | 957 | 0 | 42.2871 | -2.5396 | 2022-12-09 04:21:05 | La Rioja, Spain | |||
2022-12-07 | Spain | La Rioja | 110327 | 957 | 0 | 42.2871 | -2.5396 | 2022-12-08 04:21:07 | La Rioja, Spain | |||
2022-12-06 | Spain | La Rioja | 110327 | 957 | 0 | 42.2871 | -2.5396 | 2022-12-07 04:20:58 | La Rioja, Spain | |||
2022-12-05 | Spain | La Rioja | 110327 | 957 | 0 | 42.2871 | -2.5396 | 2022-12-06 04:21:03 | La Rioja, Spain | |||
2022-12-04 | Spain | La Rioja | 110327 | 957 | 0 | 42.2871 | -2.5396 | 2022-12-05 04:20:58 | La Rioja, Spain | |||
2022-12-03 | Spain | La Rioja | 110327 | 957 | 0 | 42.2871 | -2.5396 | 2022-12-04 04:20:56 | La Rioja, Spain | |||
2022-12-02 | Spain | La Rioja | 110327 | 957 | 0 | 42.2871 | -2.5396 | 2022-12-03 04:21:02 | La Rioja, Spain | |||
2022-12-01 | Spain | La Rioja | 110193 | 957 | 0 | 42.2871 | -2.5396 | 2022-12-02 04:21:07 | La Rioja, Spain | |||
2022-11-30 | Spain | La Rioja | 110193 | 957 | 0 | 42.2871 | -2.5396 | 2022-12-01 04:21:03 | La Rioja, Spain | |||
2022-11-29 | Spain | La Rioja | 110193 | 957 | 0 | 42.2871 | -2.5396 | 2022-11-30 04:21:07 | La Rioja, Spain | |||
2022-11-28 | Spain | La Rioja | 110193 | 957 | 0 | 42.2871 | -2.5396 | 2022-11-29 04:21:05 | La Rioja, Spain | |||
2022-11-27 | Spain | La Rioja | 110193 | 957 | 0 | 42.2871 | -2.5396 | 2022-11-28 04:21:02 | La Rioja, Spain | |||
2022-11-26 | Spain | La Rioja | 110193 | 957 | 0 | 42.2871 | -2.5396 | 2022-11-27 04:21:05 | La Rioja, Spain | |||
2022-11-25 | Spain | La Rioja | 110193 | 957 | 0 | 42.2871 | -2.5396 | 2022-11-26 04:21:11 | La Rioja, Spain | |||
2022-11-24 | Spain | La Rioja | 110042 | 957 | 0 | 42.2871 | -2.5396 | 2022-11-25 04:21:06 | La Rioja, Spain | |||
2022-11-23 | Spain | La Rioja | 110042 | 957 | 0 | 42.2871 | -2.5396 | 2022-11-24 04:21:09 | La Rioja, Spain | |||
2022-11-22 | Spain | La Rioja | 110042 | 957 | 0 | 42.2871 | -2.5396 | 2022-11-23 04:21:06 | La Rioja, Spain | |||
2022-11-21 | Spain | La Rioja | 110042 | 957 | 0 | 42.2871 | -2.5396 | 2022-11-22 04:20:47 | La Rioja, Spain | |||
2022-11-20 | Spain | La Rioja | 110042 | 957 | 0 | 42.2871 | -2.5396 | 2022-11-21 04:21:05 | La Rioja, Spain | |||
2022-11-19 | Spain | La Rioja | 110042 | 957 | 0 | 42.2871 | -2.5396 | 2022-11-20 04:21:08 | La Rioja, Spain | |||
2022-11-18 | Spain | La Rioja | 110042 | 957 | 0 | 42.2871 | -2.5396 | 2022-11-19 04:21:14 | La Rioja, Spain | |||
2022-09-22 | Spain | Cantabria | 158174 | 957 | 0 | 43.1828 | -3.9878 | 2022-09-23 04:23:13 | Cantabria, Spain | |||
2022-09-21 | Spain | Cantabria | 158174 | 957 | 0 | 43.1828 | -3.9878 | 2022-09-22 04:22:56 | Cantabria, Spain | |||
2022-09-20 | Spain | Cantabria | 158174 | 957 | 0 | 43.1828 | -3.9878 | 2022-09-21 04:23:22 | Cantabria, Spain | |||
2022-09-19 | Spain | Cantabria | 158107 | 957 | 0 | 43.1828 | -3.9878 | 2022-09-20 04:22:48 | Cantabria, Spain | |||
2022-09-18 | Spain | Cantabria | 158107 | 957 | 0 | 43.1828 | -3.9878 | 2022-09-19 04:21:49 | Cantabria, Spain | |||
2022-09-17 | Spain | Cantabria | 158107 | 957 | 0 | 43.1828 | -3.9878 | 2022-09-18 04:22:50 | Cantabria, Spain | |||
2022-09-16 | Spain | Cantabria | 158107 | 957 | 0 | 43.1828 | -3.9878 | 2022-09-17 04:20:19 | Cantabria, Spain | |||
2022-09-15 | Spain | Cantabria | 158017 | 957 | 0 | 43.1828 | -3.9878 | 2022-09-16 04:21:19 | Cantabria, Spain | |||
2022-09-14 | Spain | Cantabria | 158017 | 957 | 0 | 43.1828 | -3.9878 | 2022-09-15 04:21:02 | Cantabria, Spain | |||
2022-09-13 | Spain | Cantabria | 158017 | 957 | 0 | 43.1828 | -3.9878 | 2022-09-14 04:20:44 | Cantabria, Spain | |||
2022-09-12 | Spain | Cantabria | 157939 | 957 | 0 | 43.1828 | -3.9878 | 2022-09-13 04:20:57 | Cantabria, Spain | |||
2022-09-11 | Spain | Cantabria | 157939 | 957 | 0 | 43.1828 | -3.9878 | 2022-09-12 04:20:58 | Cantabria, Spain | |||
2022-09-10 | Spain | Cantabria | 157939 | 957 | 0 | 43.1828 | -3.9878 | 2022-09-11 04:20:50 | Cantabria, Spain | |||
2022-09-09 | Spain | Cantabria | 157939 | 957 | 0 | 43.1828 | -3.9878 | 2022-09-10 04:21:10 | Cantabria, Spain | |||
2021-09-26 | Spain | Baleares | 98856 | 957 | 0 | 39.710358 | 2.995148 | 2021-09-27 04:21:16 | Baleares, Spain | |||
2021-09-25 | Spain | Baleares | 98856 | 957 | 0 | 39.710358 | 2.995148 | 2021-09-26 04:21:29 | Baleares, Spain | |||
2021-09-24 | Spain | Baleares | 98856 | 957 | 0 | 39.710358 | 2.995148 | 2021-09-25 04:21:31 | Baleares, Spain | |||
2020-12-29 | Spain | Navarra | 42210 | 957 | 3905 | 37348 | 42.6954 | -1.6761 | 2020-12-30 05:22:34 | Navarra, Spain | ||
2020-11-04 | Spain | Galicia | 36577 | 957 | 9204 | 26416 | 42.5751 | -8.1339 | 2020-11-05 06:05:03 | Galicia, Spain |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;