daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
20 rows where deaths = 143 and province_or_state = "Valle d'Aosta" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2020-06-05 | Italy | Valle d'Aosta | 1187 | 143 | 1034 | 10 | 45.73750286 | 7.320149366 | 2020-06-06 02:33:00 | Valle d'Aosta, Italy | ||
2020-06-04 | Italy | Valle d'Aosta | 1187 | 143 | 1034 | 10 | 45.73750286 | 7.320149366 | 2020-06-05 02:33:06 | Valle d'Aosta, Italy | ||
2020-06-03 | Italy | Valle d'Aosta | 1187 | 143 | 1031 | 13 | 45.73750286 | 7.320149366 | 2020-06-04 02:33:14 | Valle d'Aosta, Italy | ||
2020-06-02 | Italy | Valle d'Aosta | 1187 | 143 | 1031 | 13 | 45.73750286 | 7.320149366 | 2020-06-03 02:33:13 | Valle d'Aosta, Italy | ||
2020-06-01 | Italy | Valle d'Aosta | 1187 | 143 | 1027 | 17 | 45.73750286 | 7.320149366 | 2020-06-02 02:33:08 | Valle d'Aosta, Italy | ||
2020-05-31 | Italy | Valle d'Aosta | 1184 | 143 | 1026 | 15 | 45.73750286 | 7.320149366 | 2020-06-01 02:32:46 | Valle d'Aosta, Italy | ||
2020-05-30 | Italy | Valle d'Aosta | 1183 | 143 | 1023 | 17 | 45.73750286 | 7.320149366 | 2020-05-31 02:32:45 | Valle d'Aosta, Italy | ||
2020-05-29 | Italy | Valle d'Aosta | 1182 | 143 | 1020 | 19 | 45.73750286 | 7.320149366 | 2020-05-30 02:32:48 | Valle d'Aosta, Italy | ||
2020-05-28 | Italy | Valle d'Aosta | 1182 | 143 | 1016 | 23 | 45.73750286 | 7.320149366 | 2020-05-29 02:32:50 | Valle d'Aosta, Italy | ||
2020-05-27 | Italy | Valle d'Aosta | 1181 | 143 | 1011 | 27 | 45.73750286 | 7.320149366 | 2020-05-28 02:32:31 | Valle d'Aosta, Italy | ||
2020-05-26 | Italy | Valle d'Aosta | 1181 | 143 | 1007 | 31 | 45.73750286 | 7.320149366 | 2020-05-27 02:32:31 | Valle d'Aosta, Italy | ||
2020-05-25 | Italy | Valle d'Aosta | 1179 | 143 | 1003 | 33 | 45.73750286 | 7.320149366 | 2020-05-26 02:32:35 | Valle d'Aosta, Italy | ||
2020-05-24 | Italy | Valle d'Aosta | 1178 | 143 | 1003 | 32 | 45.73750286 | 7.320149366 | 2020-05-25 02:32:44 | Valle d'Aosta, Italy | ||
2020-05-23 | Italy | Valle d'Aosta | 1177 | 143 | 999 | 35 | 45.73750286 | 7.320149366 | 2020-05-24 02:32:43 | Valle d'Aosta, Italy | ||
2020-05-22 | Italy | Valle d'Aosta | 1177 | 143 | 991 | 43 | 45.73750286 | 7.320149366 | 2020-05-23 02:32:42 | Valle d'Aosta, Italy | ||
2020-05-21 | Italy | Valle d'Aosta | 1176 | 143 | 990 | 43 | 45.73750286 | 7.320149366 | 2020-05-22 02:36:51 | Valle d'Aosta, Italy | ||
2020-05-20 | Italy | Valle d'Aosta | 1175 | 143 | 986 | 46 | 45.73750286 | 7.320149366 | 2020-05-21 02:32:48 | Valle d'Aosta, Italy | ||
2020-05-19 | Italy | Valle d'Aosta | 1175 | 143 | 983 | 49 | 45.73750286 | 7.320149366 | 2020-05-20 02:32:19 | Valle d'Aosta, Italy | ||
2020-05-18 | Italy | Valle d'Aosta | 1174 | 143 | 971 | 60 | 45.73750286 | 7.320149366 | 2020-05-19 02:32:18 | Valle d'Aosta, Italy | ||
2020-05-17 | Italy | Valle d'Aosta | 1173 | 143 | 962 | 68 | 45.73750286 | 7.320149366 | 2020-05-18 02:32:21 | Valle d'Aosta, Italy |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;