johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
20,264 rows where country_or_region = "Italy" sorted by active
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date), last_update (date)
combined_key 22 ✖
- Abruzzo, Italy 960
- Basilicata, Italy 960
- Calabria, Italy 960
- Campania, Italy 960
- Emilia-Romagna, Italy 960
- Friuli Venezia Giulia, Italy 960
- Lazio, Italy 960
- Liguria, Italy 960
- Lombardia, Italy 960
- Marche, Italy 960
- Molise, Italy 960
- P.A. Bolzano, Italy 960
- P.A. Trento, Italy 960
- Piemonte, Italy 960
- Puglia, Italy 960
- Sardegna, Italy 960
- Sicilia, Italy 960
- Toscana, Italy 960
- Umbria, Italy 960
- Valle d'Aosta, Italy 960
- Veneto, Italy 960
- Italy 53
province_or_state 21
- Abruzzo 960
- Basilicata 960
- Calabria 960
- Campania 960
- Emilia-Romagna 960
- Friuli Venezia Giulia 960
- Lazio 960
- Liguria 960
- Lombardia 960
- Marche 960
- Molise 960
- P.A. Bolzano 960
- P.A. Trento 960
- Piemonte 960
- Puglia 960
- Sardegna 960
- Sicilia 960
- Toscana 960
- Umbria 960
- Valle d'Aosta 960
- Veneto 960
country_or_region 1
- Italy · 20,264 ✖
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active ▼ | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
292 | 292 | 2021-12-02 | Italy | Abruzzo | 88379 | 2595 | 0 | 42.35122196 | 13.39843823 | 2021-12-03 04:23:05 | Abruzzo, Italy | |||
293 | 293 | 2021-12-02 | Italy | Basilicata | 31656 | 627 | 0 | 40.63947052 | 15.80514834 | 2021-12-03 04:23:05 | Basilicata, Italy | |||
294 | 294 | 2021-12-02 | Italy | Calabria | 93591 | 1503 | 0 | 38.90597598 | 16.59440194 | 2021-12-03 04:23:05 | Calabria, Italy | |||
295 | 295 | 2021-12-02 | Italy | Campania | 493017 | 8238 | 0 | 40.83956555 | 14.25084984 | 2021-12-03 04:23:05 | Campania, Italy | |||
296 | 296 | 2021-12-02 | Italy | Emilia-Romagna | 458504 | 13803 | 0 | 44.49436681 | 11.341720800000001 | 2021-12-03 04:23:05 | Emilia-Romagna, Italy | |||
297 | 297 | 2021-12-02 | Italy | Friuli Venezia Giulia | 132539 | 3997 | 0 | 45.6494354 | 13.76813649 | 2021-12-03 04:23:05 | Friuli Venezia Giulia, Italy | |||
298 | 298 | 2021-12-02 | Italy | Lazio | 427019 | 8996 | 0 | 41.89277044 | 12.48366722 | 2021-12-03 04:23:05 | Lazio, Italy | |||
299 | 299 | 2021-12-02 | Italy | Liguria | 123548 | 4468 | 0 | 44.41149315 | 8.9326992 | 2021-12-03 04:23:05 | Liguria, Italy | |||
300 | 300 | 2021-12-02 | Italy | Lombardia | 937667 | 34413 | 0 | 45.46679409 | 9.190347404 | 2021-12-03 04:23:05 | Lombardia, Italy | |||
301 | 301 | 2021-12-02 | Italy | Marche | 124773 | 3154 | 0 | 43.61675973 | 13.5188753 | 2021-12-03 04:23:05 | Marche, Italy | |||
302 | 302 | 2021-12-02 | Italy | Molise | 15255 | 504 | 0 | 41.55774754 | 14.65916051 | 2021-12-03 04:23:05 | Molise, Italy | |||
303 | 303 | 2021-12-02 | Italy | P.A. Bolzano | 89347 | 1245 | 0 | 46.49933453 | 11.35662422 | 2021-12-03 04:23:05 | P.A. Bolzano, Italy | |||
304 | 304 | 2021-12-02 | Italy | P.A. Trento | 52489 | 1392 | 0 | 46.06893511 | 11.12123097 | 2021-12-03 04:23:05 | P.A. Trento, Italy | |||
305 | 305 | 2021-12-02 | Italy | Piemonte | 401394 | 11895 | 0 | 45.0732745 | 7.680687483 | 2021-12-03 04:23:05 | Piemonte, Italy | |||
306 | 306 | 2021-12-02 | Italy | Puglia | 280056 | 6889 | 0 | 41.12559576 | 16.86736689 | 2021-12-03 04:23:05 | Puglia, Italy | |||
307 | 307 | 2021-12-02 | Italy | Sardegna | 79160 | 1697 | 0 | 39.21531192 | 9.110616306 | 2021-12-03 04:23:05 | Sardegna, Italy | |||
308 | 308 | 2021-12-02 | Italy | Sicilia | 325626 | 7218 | 0 | 38.11569725 | 13.362356699999998 | 2021-12-03 04:23:05 | Sicilia, Italy | |||
309 | 309 | 2021-12-02 | Italy | Toscana | 302670 | 7415 | 0 | 43.76923077 | 11.25588885 | 2021-12-03 04:23:05 | Toscana, Italy | |||
310 | 310 | 2021-12-02 | Italy | Umbria | 67732 | 1492 | 0 | 43.10675841 | 12.38824698 | 2021-12-03 04:23:05 | Umbria, Italy | |||
311 | 311 | 2021-12-02 | Italy | Valle d'Aosta | 13321 | 479 | 0 | 45.73750286 | 7.320149366 | 2021-12-03 04:23:05 | Valle d'Aosta, Italy | |||
312 | 312 | 2021-12-02 | Italy | Veneto | 522687 | 11983 | 0 | 45.43490485 | 12.33845213 | 2021-12-03 04:23:05 | Veneto, Italy | |||
4308 | 4308 | 2021-10-28 | Italy | Abruzzo | 82646 | 2559 | 0 | 42.35122196 | 13.39843823 | 2021-10-29 04:22:03 | Abruzzo, Italy | |||
4309 | 4309 | 2021-10-28 | Italy | Basilicata | 30710 | 624 | 0 | 40.63947052 | 15.80514834 | 2021-10-29 04:22:03 | Basilicata, Italy | |||
4310 | 4310 | 2021-10-28 | Italy | Calabria | 87008 | 1446 | 0 | 38.90597598 | 16.59440194 | 2021-10-29 04:22:03 | Calabria, Italy | |||
4311 | 4311 | 2021-10-28 | Italy | Campania | 465299 | 8053 | 0 | 40.83956555 | 14.25084984 | 2021-10-29 04:22:03 | Campania, Italy | |||
4312 | 4312 | 2021-10-28 | Italy | Emilia-Romagna | 431067 | 13583 | 0 | 44.49436681 | 11.341720800000001 | 2021-10-29 04:22:03 | Emilia-Romagna, Italy | |||
4313 | 4313 | 2021-10-28 | Italy | Friuli Venezia Giulia | 116421 | 3852 | 0 | 45.6494354 | 13.76813649 | 2021-10-29 04:22:03 | Friuli Venezia Giulia, Italy | |||
4314 | 4314 | 2021-10-28 | Italy | Lazio | 393497 | 8780 | 0 | 41.89277044 | 12.48366722 | 2021-10-29 04:22:03 | Lazio, Italy | |||
4315 | 4315 | 2021-10-28 | Italy | Liguria | 114521 | 4425 | 0 | 44.41149315 | 8.9326992 | 2021-10-29 04:22:03 | Liguria, Italy | |||
4316 | 4316 | 2021-10-28 | Italy | Lombardia | 893025 | 34148 | 0 | 45.46679409 | 9.190347404 | 2021-10-29 04:22:03 | Lombardia, Italy | |||
4317 | 4317 | 2021-10-28 | Italy | Marche | 115864 | 3103 | 0 | 43.61675973 | 13.5188753 | 2021-10-29 04:22:03 | Marche, Italy | |||
4318 | 4318 | 2021-10-28 | Italy | Molise | 14654 | 498 | 0 | 41.55774754 | 14.65916051 | 2021-10-29 04:22:03 | Molise, Italy | |||
4319 | 4319 | 2021-10-28 | Italy | P.A. Bolzano | 78588 | 1200 | 0 | 46.49933453 | 11.35662422 | 2021-10-29 04:22:03 | P.A. Bolzano, Italy | |||
4320 | 4320 | 2021-10-28 | Italy | P.A. Trento | 49233 | 1377 | 0 | 46.06893511 | 11.12123097 | 2021-10-29 04:22:03 | P.A. Trento, Italy | |||
4321 | 4321 | 2021-10-28 | Italy | Piemonte | 384229 | 11811 | 0 | 45.0732745 | 7.680687483 | 2021-10-29 04:22:03 | Piemonte, Italy | |||
4322 | 4322 | 2021-10-28 | Italy | Puglia | 272296 | 6832 | 0 | 41.12559576 | 16.86736689 | 2021-10-29 04:22:03 | Puglia, Italy | |||
4323 | 4323 | 2021-10-28 | Italy | Sardegna | 76097 | 1673 | 0 | 39.21531192 | 9.110616306 | 2021-10-29 04:22:03 | Sardegna, Italy | |||
4324 | 4324 | 2021-10-28 | Italy | Sicilia | 307175 | 7009 | 0 | 38.11569725 | 13.362356699999998 | 2021-10-29 04:22:03 | Sicilia, Italy | |||
4325 | 4325 | 2021-10-28 | Italy | Toscana | 288589 | 7272 | 0 | 43.76923077 | 11.25588885 | 2021-10-29 04:22:03 | Toscana, Italy | |||
4326 | 4326 | 2021-10-28 | Italy | Umbria | 65003 | 1464 | 0 | 43.10675841 | 12.38824698 | 2021-10-29 04:22:03 | Umbria, Italy | |||
4327 | 4327 | 2021-10-28 | Italy | Valle d'Aosta | 12292 | 474 | 0 | 45.73750286 | 7.320149366 | 2021-10-29 04:22:03 | Valle d'Aosta, Italy | |||
4328 | 4328 | 2021-10-28 | Italy | Veneto | 479017 | 11821 | 0 | 45.43490485 | 12.33845213 | 2021-10-29 04:22:03 | Veneto, Italy | |||
16333 | 16333 | 2021-09-18 | Italy | Abruzzo | 80616 | 2535 | 0 | 42.35122196 | 13.39843823 | 2021-09-19 04:21:34 | Abruzzo, Italy | |||
16334 | 16334 | 2021-09-18 | Italy | Basilicata | 29736 | 608 | 0 | 40.63947052 | 15.80514834 | 2021-09-19 04:21:34 | Basilicata, Italy | |||
16335 | 16335 | 2021-09-18 | Italy | Calabria | 82058 | 1371 | 0 | 38.90597598 | 16.59440194 | 2021-09-19 04:21:34 | Calabria, Italy | |||
16336 | 16336 | 2021-09-18 | Italy | Campania | 452808 | 7858 | 0 | 40.83956555 | 14.25084984 | 2021-09-19 04:21:34 | Campania, Italy | |||
16337 | 16337 | 2021-09-18 | Italy | Emilia-Romagna | 420118 | 13432 | 0 | 44.49436681 | 11.341720800000001 | 2021-09-19 04:21:34 | Emilia-Romagna, Italy | |||
16338 | 16338 | 2021-09-18 | Italy | Friuli Venezia Giulia | 112914 | 3814 | 0 | 45.6494354 | 13.76813649 | 2021-09-19 04:21:34 | Friuli Venezia Giulia, Italy | |||
16339 | 16339 | 2021-09-18 | Italy | Lazio | 381046 | 8595 | 0 | 41.89277044 | 12.48366722 | 2021-09-19 04:21:34 | Lazio, Italy | |||
16340 | 16340 | 2021-09-18 | Italy | Liguria | 111850 | 4396 | 0 | 44.41149315 | 8.9326992 | 2021-09-19 04:21:34 | Liguria, Italy | |||
16341 | 16341 | 2021-09-18 | Italy | Lombardia | 879291 | 33981 | 0 | 45.46679409 | 9.190347404 | 2021-09-19 04:21:34 | Lombardia, Italy | |||
16342 | 16342 | 2021-09-18 | Italy | Marche | 112959 | 3063 | 0 | 43.61675973 | 13.5188753 | 2021-09-19 04:21:34 | Marche, Italy | |||
16343 | 16343 | 2021-09-18 | Italy | Molise | 14441 | 496 | 0 | 41.55774754 | 14.65916051 | 2021-09-19 04:21:34 | Molise, Italy | |||
16344 | 16344 | 2021-09-18 | Italy | P.A. Bolzano | 76285 | 1190 | 0 | 46.49933453 | 11.35662422 | 2021-09-19 04:21:34 | P.A. Bolzano, Italy | |||
16345 | 16345 | 2021-09-18 | Italy | P.A. Trento | 48088 | 1368 | 0 | 46.06893511 | 11.12123097 | 2021-09-19 04:21:34 | P.A. Trento, Italy | |||
16346 | 16346 | 2021-09-18 | Italy | Piemonte | 376712 | 11746 | 0 | 45.0732745 | 7.680687483 | 2021-09-19 04:21:34 | Piemonte, Italy | |||
16347 | 16347 | 2021-09-18 | Italy | Puglia | 267037 | 6764 | 0 | 41.12559576 | 16.86736689 | 2021-09-19 04:21:34 | Puglia, Italy | |||
16348 | 16348 | 2021-09-18 | Italy | Sardegna | 74674 | 1624 | 0 | 39.21531192 | 9.110616306 | 2021-09-19 04:21:34 | Sardegna, Italy | |||
16349 | 16349 | 2021-09-18 | Italy | Sicilia | 292607 | 6691 | 0 | 38.11569725 | 13.362356699999998 | 2021-09-19 04:21:34 | Sicilia, Italy | |||
16350 | 16350 | 2021-09-18 | Italy | Toscana | 278907 | 7100 | 0 | 43.76923077 | 11.25588885 | 2021-09-19 04:21:34 | Toscana, Italy | |||
16351 | 16351 | 2021-09-18 | Italy | Umbria | 63235 | 1441 | 0 | 43.10675841 | 12.38824698 | 2021-09-19 04:21:34 | Umbria, Italy | |||
16352 | 16352 | 2021-09-18 | Italy | Valle d'Aosta | 12074 | 473 | 0 | 45.73750286 | 7.320149366 | 2021-09-19 04:21:34 | Valle d'Aosta, Italy | |||
16353 | 16353 | 2021-09-18 | Italy | Veneto | 464819 | 11738 | 0 | 45.43490485 | 12.33845213 | 2021-09-19 04:21:34 | Veneto, Italy | |||
24363 | 24363 | 2022-03-20 | Italy | Abruzzo | 291512 | 3040 | 0 | 42.35122196 | 13.39843823 | 2022-03-21 04:20:50 | Abruzzo, Italy | |||
24364 | 24364 | 2022-03-20 | Italy | Basilicata | 96397 | 809 | 0 | 40.63947052 | 15.80514834 | 2022-03-21 04:20:50 | Basilicata, Italy | |||
24365 | 24365 | 2022-03-20 | Italy | Calabria | 264203 | 2221 | 0 | 38.90597598 | 16.59440194 | 2022-03-21 04:20:50 | Calabria, Italy | |||
24366 | 24366 | 2022-03-20 | Italy | Campania | 1312523 | 9928 | 0 | 40.83956555 | 14.25084984 | 2022-03-21 04:20:50 | Campania, Italy | |||
24367 | 24367 | 2022-03-20 | Italy | Emilia-Romagna | 1239281 | 16150 | 0 | 44.49436681 | 11.341720800000001 | 2022-03-21 04:20:50 | Emilia-Romagna, Italy | |||
24368 | 24368 | 2022-03-20 | Italy | Friuli Venezia Giulia | 322977 | 4864 | 0 | 45.6494354 | 13.76813649 | 2022-03-21 04:20:50 | Friuli Venezia Giulia, Italy | |||
24369 | 24369 | 2022-03-20 | Italy | Lazio | 1195072 | 10643 | 0 | 41.89277044 | 12.48366722 | 2022-03-21 04:20:50 | Lazio, Italy | |||
24370 | 24370 | 2022-03-20 | Italy | Liguria | 369189 | 5175 | 0 | 44.41149315 | 8.9326992 | 2022-03-21 04:20:50 | Liguria, Italy | |||
24371 | 24371 | 2022-03-20 | Italy | Lombardia | 2446991 | 39060 | 0 | 45.46679409 | 9.190347404 | 2022-03-21 04:20:50 | Lombardia, Italy | |||
24372 | 24372 | 2022-03-20 | Italy | Marche | 364967 | 3661 | 0 | 43.61675973 | 13.5188753 | 2022-03-21 04:20:50 | Marche, Italy | |||
24373 | 24373 | 2022-03-20 | Italy | Molise | 45012 | 583 | 0 | 41.55774754 | 14.65916051 | 2022-03-21 04:20:50 | Molise, Italy | |||
24374 | 24374 | 2022-03-20 | Italy | P.A. Bolzano | 199319 | 1433 | 0 | 46.49933453 | 11.35662422 | 2022-03-21 04:20:50 | P.A. Bolzano, Italy | |||
24375 | 24375 | 2022-03-20 | Italy | P.A. Trento | 145156 | 1534 | 0 | 46.06893511 | 11.12123097 | 2022-03-21 04:20:50 | P.A. Trento, Italy | |||
24376 | 24376 | 2022-03-20 | Italy | Piemonte | 1019390 | 13154 | 0 | 45.0732745 | 7.680687483 | 2022-03-21 04:20:50 | Piemonte, Italy | |||
24377 | 24377 | 2022-03-20 | Italy | Puglia | 836805 | 7858 | 0 | 41.12559576 | 16.86736689 | 2022-03-21 04:20:50 | Puglia, Italy | |||
24378 | 24378 | 2022-03-20 | Italy | Sardegna | 208594 | 2153 | 0 | 39.21531192 | 9.110616306 | 2022-03-21 04:20:50 | Sardegna, Italy | |||
24379 | 24379 | 2022-03-20 | Italy | Sicilia | 905770 | 9860 | 0 | 38.11569725 | 13.362356699999998 | 2022-03-21 04:20:50 | Sicilia, Italy | |||
24380 | 24380 | 2022-03-20 | Italy | Toscana | 931471 | 9324 | 0 | 43.76923077 | 11.25588885 | 2022-03-21 04:20:50 | Toscana, Italy | |||
24381 | 24381 | 2022-03-20 | Italy | Umbria | 215512 | 1774 | 0 | 43.10675841 | 12.38824698 | 2022-03-21 04:20:50 | Umbria, Italy | |||
24382 | 24382 | 2022-03-20 | Italy | Valle d'Aosta | 31957 | 522 | 0 | 45.73750286 | 7.320149366 | 2022-03-21 04:20:50 | Valle d'Aosta, Italy | |||
24383 | 24383 | 2022-03-20 | Italy | Veneto | 1419645 | 14039 | 0 | 45.43490485 | 12.33845213 | 2022-03-21 04:20:50 | Veneto, Italy | |||
28378 | 28378 | 2021-11-11 | Italy | Abruzzo | 84246 | 2566 | 0 | 42.35122196 | 13.39843823 | 2021-11-12 04:22:01 | Abruzzo, Italy | |||
28379 | 28379 | 2021-11-11 | Italy | Basilicata | 31019 | 624 | 0 | 40.63947052 | 15.80514834 | 2021-11-12 04:22:01 | Basilicata, Italy | |||
28380 | 28380 | 2021-11-11 | Italy | Calabria | 89210 | 1462 | 0 | 38.90597598 | 16.59440194 | 2021-11-12 04:22:01 | Calabria, Italy | |||
28381 | 28381 | 2021-11-11 | Italy | Campania | 473989 | 8117 | 0 | 40.83956555 | 14.25084984 | 2021-11-12 04:22:01 | Campania, Italy | |||
28382 | 28382 | 2021-11-11 | Italy | Emilia-Romagna | 437457 | 13644 | 0 | 44.49436681 | 11.341720800000001 | 2021-11-12 04:22:01 | Emilia-Romagna, Italy | |||
28383 | 28383 | 2021-11-11 | Italy | Friuli Venezia Giulia | 120887 | 3891 | 0 | 45.6494354 | 13.76813649 | 2021-11-12 04:22:01 | Friuli Venezia Giulia, Italy | |||
28384 | 28384 | 2021-11-11 | Italy | Lazio | 402231 | 8864 | 0 | 41.89277044 | 12.48366722 | 2021-11-12 04:22:01 | Lazio, Italy | |||
28385 | 28385 | 2021-11-11 | Italy | Liguria | 116667 | 4435 | 0 | 44.41149315 | 8.9326992 | 2021-11-12 04:22:01 | Liguria, Italy | |||
28386 | 28386 | 2021-11-11 | Italy | Lombardia | 902069 | 34216 | 0 | 45.46679409 | 9.190347404 | 2021-11-12 04:22:01 | Lombardia, Italy | |||
28387 | 28387 | 2021-11-11 | Italy | Marche | 117941 | 3118 | 0 | 43.61675973 | 13.5188753 | 2021-11-12 04:22:01 | Marche, Italy | |||
28388 | 28388 | 2021-11-11 | Italy | Molise | 14775 | 501 | 0 | 41.55774754 | 14.65916051 | 2021-11-12 04:22:01 | Molise, Italy | |||
28389 | 28389 | 2021-11-11 | Italy | P.A. Bolzano | 81285 | 1211 | 0 | 46.49933453 | 11.35662422 | 2021-11-12 04:22:01 | P.A. Bolzano, Italy | |||
28390 | 28390 | 2021-11-11 | Italy | P.A. Trento | 49990 | 1384 | 0 | 46.06893511 | 11.12123097 | 2021-11-12 04:22:01 | P.A. Trento, Italy | |||
28391 | 28391 | 2021-11-11 | Italy | Piemonte | 388370 | 11843 | 0 | 45.0732745 | 7.680687483 | 2021-11-12 04:22:01 | Piemonte, Italy | |||
28392 | 28392 | 2021-11-11 | Italy | Puglia | 275150 | 6858 | 0 | 41.12559576 | 16.86736689 | 2021-11-12 04:22:01 | Puglia, Italy | |||
28393 | 28393 | 2021-11-11 | Italy | Sardegna | 76849 | 1678 | 0 | 39.21531192 | 9.110616306 | 2021-11-12 04:22:01 | Sardegna, 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]);