daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
10 rows where country_or_region = "Italy" and deaths = 543 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: confirmed, latitude, day (date), last_update (date)
province_or_state 5
- Puglia 6
- Basilicata 1
- Calabria 1
- Sardegna 1
- Valle d'Aosta 1
country_or_region 1
- Italy · 10 ✖
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-07-25 | Italy | Valle d'Aosta | 41273 | 543 | 0 | 45.73750286 | 7.320149366 | 2022-07-26 04:20:58 | Valle d'Aosta, Italy | |||
2021-05-05 | Italy | Basilicata | 24505 | 543 | 17687 | 6275 | 40.63947052 | 15.80514834 | 2021-05-06 04:20:38 | Basilicata, Italy | ||
2021-01-20 | Italy | Calabria | 29833 | 543 | 19185 | 10105 | 38.90597598 | 16.59440194 | 2021-01-21 05:22:01 | Calabria, Italy | ||
2020-12-08 | Italy | Sardegna | 24778 | 543 | 9075 | 15160 | 39.21531192 | 9.110616306 | 2020-12-09 05:28:01 | Sardegna, Italy | ||
2020-06-29 | Italy | Puglia | 4531 | 543 | 3843 | 145 | 41.12559576 | 16.86736689 | 2020-06-30 04:33:48 | Puglia, Italy | ||
2020-06-28 | Italy | Puglia | 4531 | 543 | 3842 | 146 | 41.12559576 | 16.86736689 | 2020-06-29 04:33:44 | Puglia, Italy | ||
2020-06-27 | Italy | Puglia | 4531 | 543 | 3841 | 147 | 41.12559576 | 16.86736689 | 2020-06-28 04:34:04 | Puglia, Italy | ||
2020-06-26 | Italy | Puglia | 4531 | 543 | 3835 | 153 | 41.12559576 | 16.86736689 | 2020-06-27 04:33:35 | Puglia, Italy | ||
2020-06-25 | Italy | Puglia | 4530 | 543 | 3814 | 173 | 41.12559576 | 16.86736689 | 2020-06-26 04:33:43 | Puglia, Italy | ||
2020-06-24 | Italy | Puglia | 4529 | 543 | 3809 | 177 | 41.12559576 | 16.86736689 | 2020-06-25 05:26:54 | Puglia, Italy |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;