johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
19 rows where active = 26 and country_or_region = "Italy" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: confirmed, combined_key, last_update (date)
province_or_state 5
- Calabria 6
- Molise 5
- P.A. Trento 3
- Valle d'Aosta 3
- Umbria 2
country_or_region 1
- Italy · 19 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3331527 | 3331527 | 2021-07-21 | Italy | Valle d'Aosta | 11716 | 473 | 11217 | 26 | 45.73750286 | 7.320149366 | 2021-07-22 04:21:19 | Valle d'Aosta, Italy | ||
483587 | 483587 | 2021-07-19 | Italy | Valle d'Aosta | 11712 | 473 | 11213 | 26 | 45.73750286 | 7.320149366 | 2021-07-20 04:21:48 | Valle d'Aosta, Italy | ||
2673810 | 2673810 | 2021-07-18 | Italy | Valle d'Aosta | 11712 | 473 | 11213 | 26 | 45.73750286 | 7.320149366 | 2021-07-19 04:21:24 | Valle d'Aosta, Italy | ||
2808175 | 2808175 | 2020-08-02 | Italy | Umbria | 1474 | 80 | 1368 | 26 | 43.10675841 | 12.38824698 | 2020-08-03 04:34:35 | Umbria, Italy | ||
1928432 | 1928432 | 2020-07-30 | Italy | Molise | 470 | 23 | 421 | 26 | 41.55774754 | 14.65916051 | 2020-07-31 04:35:18 | Molise, Italy | ||
2958600 | 2958600 | 2020-07-29 | Italy | Molise | 470 | 23 | 421 | 26 | 41.55774754 | 14.65916051 | 2020-07-30 04:35:05 | Molise, Italy | ||
2158819 | 2158819 | 2020-07-14 | Italy | P.A. Trento | 4881 | 405 | 4450 | 26 | 46.06893511 | 11.12123097 | 2020-07-15 04:34:39 | P.A. Trento, Italy | ||
3491460 | 3491460 | 2020-07-13 | Italy | P.A. Trento | 4881 | 405 | 4450 | 26 | 46.06893511 | 11.12123097 | 2020-07-14 04:34:46 | P.A. Trento, Italy | ||
3737723 | 3737723 | 2020-07-12 | Italy | P.A. Trento | 4881 | 405 | 4450 | 26 | 46.06893511 | 11.12123097 | 2020-07-13 04:43:04 | P.A. Trento, Italy | ||
2684721 | 2684721 | 2020-07-06 | Italy | Calabria | 1183 | 97 | 1060 | 26 | 38.90597598 | 16.59440194 | 2020-07-07 04:34:00 | Calabria, Italy | ||
415186 | 415186 | 2020-07-05 | Italy | Calabria | 1183 | 97 | 1060 | 26 | 38.90597598 | 16.59440194 | 2020-07-06 04:33:57 | Calabria, Italy | ||
529748 | 529748 | 2020-07-04 | Italy | Calabria | 1183 | 97 | 1060 | 26 | 38.90597598 | 16.59440194 | 2020-07-05 04:33:46 | Calabria, Italy | ||
302894 | 302894 | 2020-07-01 | Italy | Calabria | 1181 | 97 | 1058 | 26 | 38.90597598 | 16.59440194 | 2020-07-02 04:33:46 | Calabria, Italy | ||
2632749 | 2632749 | 2020-06-29 | Italy | Calabria | 1180 | 97 | 1057 | 26 | 38.90597598 | 16.59440194 | 2020-06-30 04:33:48 | Calabria, Italy | ||
2632959 | 2632959 | 2020-06-29 | Italy | Molise | 445 | 23 | 396 | 26 | 41.55774754 | 14.65916051 | 2020-06-30 04:33:48 | Molise, Italy | ||
2306312 | 2306312 | 2020-06-28 | Italy | Calabria | 1180 | 97 | 1057 | 26 | 38.90597598 | 16.59440194 | 2020-06-29 04:33:44 | Calabria, Italy | ||
2306522 | 2306522 | 2020-06-28 | Italy | Molise | 445 | 23 | 396 | 26 | 41.55774754 | 14.65916051 | 2020-06-29 04:33:44 | Molise, Italy | ||
2039857 | 2039857 | 2020-06-27 | Italy | Molise | 445 | 23 | 396 | 26 | 41.55774754 | 14.65916051 | 2020-06-28 04:34:04 | Molise, Italy | ||
1273706 | 1273706 | 2020-06-11 | Italy | Umbria | 1436 | 76 | 1334 | 26 | 43.10675841 | 12.38824698 | 2020-06-12 05:09:52 | Umbria, 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]);