johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
21 rows where active = 12 and country_or_region = "Italy" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day, deaths, longitude, last_update, combined_key, last_update (date)
province_or_state 5
- Sardegna 7
- Valle d'Aosta 7
- Umbria 4
- Basilicata 2
- Molise 1
country_or_region 1
- Italy · 21 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1996641 | 1996641 | 2020-08-26 | Italy | Valle d'Aosta | 1223 | 146 | 1065 | 12 | 45.73750286 | 7.320149366 | 2020-08-27 04:28:15 | Valle d'Aosta, Italy | ||
3793317 | 3793317 | 2020-08-05 | Italy | Valle d'Aosta | 1209 | 146 | 1051 | 12 | 45.73750286 | 7.320149366 | 2020-08-06 04:35:02 | Valle d'Aosta, Italy | ||
753756 | 753756 | 2020-08-01 | Italy | Valle d'Aosta | 1208 | 146 | 1050 | 12 | 45.73750286 | 7.320149366 | 2020-08-02 04:34:47 | Valle d'Aosta, Italy | ||
3264921 | 3264921 | 2020-07-31 | Italy | Valle d'Aosta | 1208 | 146 | 1050 | 12 | 45.73750286 | 7.320149366 | 2020-08-01 04:36:27 | Valle d'Aosta, Italy | ||
1928627 | 1928627 | 2020-07-30 | Italy | Valle d'Aosta | 1208 | 146 | 1050 | 12 | 45.73750286 | 7.320149366 | 2020-07-31 04:35:18 | Valle d'Aosta, Italy | ||
844934 | 844934 | 2020-07-22 | Italy | Sardegna | 1380 | 134 | 1234 | 12 | 39.21531192 | 9.110616306 | 2020-07-23 05:15:04 | Sardegna, Italy | ||
1707673 | 1707673 | 2020-07-21 | Italy | Sardegna | 1379 | 134 | 1233 | 12 | 39.21531192 | 9.110616306 | 2020-07-22 04:34:42 | Sardegna, Italy | ||
327164 | 327164 | 2020-07-20 | Italy | Sardegna | 1379 | 134 | 1233 | 12 | 39.21531192 | 9.110616306 | 2020-07-21 04:38:46 | Sardegna, Italy | ||
327227 | 327227 | 2020-07-20 | Italy | Umbria | 1456 | 80 | 1364 | 12 | 43.10675841 | 12.38824698 | 2020-07-21 04:38:46 | Umbria, Italy | ||
122069 | 122069 | 2020-07-19 | Italy | Sardegna | 1379 | 134 | 1233 | 12 | 39.21531192 | 9.110616306 | 2020-07-20 05:34:40 | Sardegna, Italy | ||
122132 | 122132 | 2020-07-19 | Italy | Umbria | 1456 | 80 | 1364 | 12 | 43.10675841 | 12.38824698 | 2020-07-20 05:34:40 | Umbria, Italy | ||
2708823 | 2708823 | 2020-07-17 | Italy | Umbria | 1454 | 80 | 1362 | 12 | 43.10675841 | 12.38824698 | 2020-07-18 04:34:45 | Umbria, Italy | ||
2748238 | 2748238 | 2020-07-15 | Italy | Sardegna | 1376 | 134 | 1230 | 12 | 39.21531192 | 9.110616306 | 2020-07-16 04:44:59 | Sardegna, Italy | ||
3436063 | 3436063 | 2020-07-11 | Italy | Molise | 445 | 23 | 410 | 12 | 41.55774754 | 14.65916051 | 2020-07-12 04:34:30 | Molise, Italy | ||
415514 | 415514 | 2020-07-05 | Italy | Sardegna | 1370 | 133 | 1225 | 12 | 39.21531192 | 9.110616306 | 2020-07-06 04:33:57 | Sardegna, Italy | ||
1136256 | 1136256 | 2020-06-26 | Italy | Sardegna | 1362 | 132 | 1218 | 12 | 39.21531192 | 9.110616306 | 2020-06-27 04:33:35 | Sardegna, Italy | ||
1522631 | 1522631 | 2020-06-23 | Italy | Umbria | 1438 | 78 | 1348 | 12 | 43.10675841 | 12.38824698 | 2020-06-24 04:33:28 | Umbria, Italy | ||
287425 | 287425 | 2020-06-15 | Italy | Valle d'Aosta | 1191 | 144 | 1035 | 12 | 45.73750286 | 7.320149366 | 2020-06-16 04:33:09 | Valle d'Aosta, Italy | ||
737325 | 737325 | 2020-06-12 | Italy | Basilicata | 401 | 27 | 362 | 12 | 40.63947052 | 15.80514834 | 2020-06-13 03:33:14 | Basilicata, Italy | ||
1273295 | 1273295 | 2020-06-11 | Italy | Basilicata | 401 | 27 | 362 | 12 | 40.63947052 | 15.80514834 | 2020-06-12 05:09:52 | Basilicata, Italy | ||
574256 | 574256 | 2020-06-06 | Italy | Valle d'Aosta | 1189 | 144 | 1033 | 12 | 45.73750286 | 7.320149366 | 2020-06-07 03:53:30 | 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]);