johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
20 rows where active = 8 and country_or_region = "Italy" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, latitude, combined_key, day (date), last_update (date)
province_or_state 4
- Basilicata 5
- Molise 5
- Umbria 5
- Valle d'Aosta 5
country_or_region 1
- Italy · 20 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3178005 | 3178005 | 2020-08-18 | Italy | Valle d'Aosta | 1218 | 146 | 1064 | 8 | 45.73750286 | 7.320149366 | 2020-08-19 04:27:00 | Valle d'Aosta, Italy | ||
837609 | 837609 | 2020-08-17 | Italy | Valle d'Aosta | 1218 | 146 | 1064 | 8 | 45.73750286 | 7.320149366 | 2020-08-18 04:27:56 | Valle d'Aosta, Italy | ||
1707553 | 1707553 | 2020-07-21 | Italy | Molise | 446 | 23 | 415 | 8 | 41.55774754 | 14.65916051 | 2020-07-22 04:34:42 | Molise, Italy | ||
327044 | 327044 | 2020-07-20 | Italy | Molise | 446 | 23 | 415 | 8 | 41.55774754 | 14.65916051 | 2020-07-21 04:38:46 | Molise, Italy | ||
121949 | 121949 | 2020-07-19 | Italy | Molise | 446 | 23 | 415 | 8 | 41.55774754 | 14.65916051 | 2020-07-20 05:34:40 | Molise, Italy | ||
3205338 | 3205338 | 2020-07-18 | Italy | Molise | 446 | 23 | 415 | 8 | 41.55774754 | 14.65916051 | 2020-07-19 04:34:58 | Molise, Italy | ||
2708639 | 2708639 | 2020-07-17 | Italy | Molise | 446 | 23 | 415 | 8 | 41.55774754 | 14.65916051 | 2020-07-18 04:34:45 | Molise, Italy | ||
2158945 | 2158945 | 2020-07-14 | Italy | Umbria | 1450 | 80 | 1362 | 8 | 43.10675841 | 12.38824698 | 2020-07-15 04:34:39 | Umbria, Italy | ||
3491586 | 3491586 | 2020-07-13 | Italy | Umbria | 1450 | 80 | 1362 | 8 | 43.10675841 | 12.38824698 | 2020-07-14 04:34:46 | Umbria, Italy | ||
3436244 | 3436244 | 2020-07-11 | Italy | Umbria | 1448 | 80 | 1360 | 8 | 43.10675841 | 12.38824698 | 2020-07-12 04:34:30 | Umbria, Italy | ||
3237742 | 3237742 | 2020-07-10 | Italy | Umbria | 1448 | 80 | 1360 | 8 | 43.10675841 | 12.38824698 | 2020-07-11 04:34:26 | Umbria, Italy | ||
887552 | 887552 | 2020-07-07 | Italy | Umbria | 1447 | 80 | 1359 | 8 | 43.10675841 | 12.38824698 | 2020-07-08 05:33:48 | Umbria, Italy | ||
1522220 | 1522220 | 2020-06-23 | Italy | Basilicata | 401 | 27 | 366 | 8 | 40.63947052 | 15.80514834 | 2020-06-24 04:33:28 | Basilicata, Italy | ||
1510414 | 1510414 | 2020-06-22 | Italy | Basilicata | 401 | 27 | 366 | 8 | 40.63947052 | 15.80514834 | 2020-06-23 04:33:22 | Basilicata, Italy | ||
3249153 | 3249153 | 2020-06-21 | Italy | Basilicata | 401 | 27 | 366 | 8 | 40.63947052 | 15.80514834 | 2020-06-22 04:33:20 | Basilicata, Italy | ||
2437746 | 2437746 | 2020-06-20 | Italy | Basilicata | 401 | 27 | 366 | 8 | 40.63947052 | 15.80514834 | 2020-06-21 04:33:19 | Basilicata, Italy | ||
1691324 | 1691324 | 2020-06-19 | Italy | Basilicata | 401 | 27 | 366 | 8 | 40.63947052 | 15.80514834 | 2020-06-20 04:33:19 | Basilicata, Italy | ||
1196099 | 1196099 | 2020-06-17 | Italy | Valle d'Aosta | 1191 | 144 | 1039 | 8 | 45.73750286 | 7.320149366 | 2020-06-18 04:33:18 | Valle d'Aosta, Italy | ||
1210976 | 1210976 | 2020-06-09 | Italy | Valle d'Aosta | 1191 | 144 | 1039 | 8 | 45.73750286 | 7.320149366 | 2020-06-10 04:07:00 | Valle d'Aosta, Italy | ||
217403 | 217403 | 2020-06-08 | Italy | Valle d'Aosta | 1191 | 144 | 1039 | 8 | 45.73750286 | 7.320149366 | 2020-06-09 03:33:03 | Valle d'Aosta, Italy |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [johns_hopkins_csse_daily_reports] ( [day] TEXT, [country_or_region] TEXT, [province_or_state] TEXT, [admin2] TEXT, [fips] TEXT, [confirmed] INTEGER, [deaths] INTEGER, [recovered] INTEGER, [active] TEXT, [latitude] TEXT, [longitude] TEXT, [last_update] TEXT, [combined_key] TEXT ); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_day] ON [johns_hopkins_csse_daily_reports] ([day]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_province_or_state] ON [johns_hopkins_csse_daily_reports] ([province_or_state]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_country_or_region] ON [johns_hopkins_csse_daily_reports] ([country_or_region]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_combined_key] ON [johns_hopkins_csse_daily_reports] ([combined_key]);