johns_hopkins_csse_daily_reports

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette

15,581 rows where country_or_region = "Italy" sorted by day descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: latitude, longitude, combined_key, day (date), last_update (date)

province_or_state 21

country_or_region 1

  • Italy · 15,581 ✖
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
1733431 1733431 2022-05-20 Italy Abruzzo     399772 3289 0   42.35122196 13.39843823 2022-05-21 04:20:58 Abruzzo, Italy
1733432 1733432 2022-05-20 Italy Basilicata     135650 912 0   40.63947052 15.80514834 2022-05-21 04:20:58 Basilicata, Italy
1733433 1733433 2022-05-20 Italy Calabria     382495 2579 0   38.90597598 16.59440194 2022-05-21 04:20:58 Calabria, Italy
1733434 1733434 2022-05-20 Italy Campania     1687712 10446 0   40.83956555 14.25084984 2022-05-21 04:20:58 Campania, Italy
1733435 1733435 2022-05-20 Italy Emilia-Romagna     1470895 16851 0   44.49436681 11.3417208 2022-05-21 04:20:58 Emilia-Romagna, Italy
1733436 1733436 2022-05-20 Italy Friuli Venezia Giulia     375885 5081 0   45.6494354 13.76813649 2022-05-21 04:20:58 Friuli Venezia Giulia, Italy
1733437 1733437 2022-05-20 Italy Lazio     1552786 11276 0   41.89277044 12.48366722 2022-05-21 04:20:58 Lazio, Italy
1733438 1733438 2022-05-20 Italy Liguria     444588 5312 0   44.41149315 8.9326992 2022-05-21 04:20:58 Liguria, Italy
1733439 1733439 2022-05-20 Italy Lombardia     2865834 40384 0   45.46679409 9.190347404 2022-05-21 04:20:58 Lombardia, Italy
1733440 1733440 2022-05-20 Italy Marche     467682 3884 0   43.61675973 13.5188753 2022-05-21 04:20:58 Marche, Italy
1733441 1733441 2022-05-20 Italy Molise     64828 625 0   41.55774754 14.65916051 2022-05-21 04:20:58 Molise, Italy
1733442 1733442 2022-05-20 Italy P.A. Bolzano     216594 1474 0   46.49933453 11.35662422 2022-05-21 04:20:58 P.A. Bolzano, Italy
1733443 1733443 2022-05-20 Italy P.A. Trento     166310 1561 0   46.06893511 11.12123097 2022-05-21 04:20:58 P.A. Trento, Italy
1733444 1733444 2022-05-20 Italy Piemonte     1186917 13407 0   45.0732745 7.680687483 2022-05-21 04:20:58 Piemonte, Italy
1733445 1733445 2022-05-20 Italy Puglia     1118588 8439 0   41.12559576 16.86736689 2022-05-21 04:20:58 Puglia, Italy
1733446 1733446 2022-05-20 Italy Sardegna     303888 2426 0   39.21531192 9.110616306 2022-05-21 04:20:58 Sardegna, Italy
1733447 1733447 2022-05-20 Italy Sicilia     1169300 10837 0   38.11569725 13.3623567 2022-05-21 04:20:58 Sicilia, Italy
1733448 1733448 2022-05-20 Italy Toscana     1138815 10035 0   43.76923077 11.25588885 2022-05-21 04:20:58 Toscana, Italy
1733449 1733449 2022-05-20 Italy Umbria     282234 1842 0   43.10675841 12.38824698 2022-05-21 04:20:58 Umbria, Italy
1733450 1733450 2022-05-20 Italy Valle d'Aosta     36250 535 0   45.73750286 7.320149366 2022-05-21 04:20:58 Valle d'Aosta, Italy
1733451 1733451 2022-05-20 Italy Veneto     1737994 14632 0   45.43490485 12.33845213 2022-05-21 04:20:58 Veneto, Italy
2572849 2572849 2022-05-19 Italy Abruzzo     398941 3282 0   42.35122196 13.39843823 2022-05-20 04:20:57 Abruzzo, Italy
2572850 2572850 2022-05-19 Italy Basilicata     135394 912 0   40.63947052 15.80514834 2022-05-20 04:20:57 Basilicata, Italy
2572851 2572851 2022-05-19 Italy Calabria     381570 2572 0   38.90597598 16.59440194 2022-05-20 04:20:57 Calabria, Italy
2572852 2572852 2022-05-19 Italy Campania     1684893 10438 0   40.83956555 14.25084984 2022-05-20 04:20:57 Campania, Italy
2572853 2572853 2022-05-19 Italy Emilia-Romagna     1468581 16839 0   44.49436681 11.3417208 2022-05-20 04:20:57 Emilia-Romagna, Italy
2572854 2572854 2022-05-19 Italy Friuli Venezia Giulia     375450 5078 0   45.6494354 13.76813649 2022-05-20 04:20:57 Friuli Venezia Giulia, Italy
2572855 2572855 2022-05-19 Italy Lazio     1550046 11272 0   41.89277044 12.48366722 2022-05-20 04:20:57 Lazio, Italy
2572856 2572856 2022-05-19 Italy Liguria     443996 5311 0   44.41149315 8.9326992 2022-05-20 04:20:57 Liguria, Italy
2572857 2572857 2022-05-19 Italy Lombardia     2862295 40369 0   45.46679409 9.190347404 2022-05-20 04:20:57 Lombardia, Italy
2572858 2572858 2022-05-19 Italy Marche     466872 3883 0   43.61675973 13.5188753 2022-05-20 04:20:57 Marche, Italy
2572859 2572859 2022-05-19 Italy Molise     64673 625 0   41.55774754 14.65916051 2022-05-20 04:20:57 Molise, Italy
2572860 2572860 2022-05-19 Italy P.A. Bolzano     216373 1474 0   46.49933453 11.35662422 2022-05-20 04:20:57 P.A. Bolzano, Italy
2572861 2572861 2022-05-19 Italy P.A. Trento     166163 1560 0   46.06893511 11.12123097 2022-05-20 04:20:57 P.A. Trento, Italy
2572862 2572862 2022-05-19 Italy Piemonte     1185416 13405 0   45.0732745 7.680687483 2022-05-20 04:20:57 Piemonte, Italy
2572863 2572863 2022-05-19 Italy Puglia     1116827 8433 0   41.12559576 16.86736689 2022-05-20 04:20:57 Puglia, Italy
2572864 2572864 2022-05-19 Italy Sardegna     302809 2425 0   39.21531192 9.110616306 2022-05-20 04:20:57 Sardegna, Italy
2572865 2572865 2022-05-19 Italy Sicilia     1166926 10833 0   38.11569725 13.3623567 2022-05-20 04:20:57 Sicilia, Italy
2572866 2572866 2022-05-19 Italy Toscana     1137293 10027 0   43.76923077 11.25588885 2022-05-20 04:20:57 Toscana, Italy
2572867 2572867 2022-05-19 Italy Umbria     281668 1839 0   43.10675841 12.38824698 2022-05-20 04:20:57 Umbria, Italy
2572868 2572868 2022-05-19 Italy Valle d'Aosta     36210 535 0   45.73750286 7.320149366 2022-05-20 04:20:57 Valle d'Aosta, Italy
2572869 2572869 2022-05-19 Italy Veneto     1735803 14626 0   45.43490485 12.33845213 2022-05-20 04:20:57 Veneto, Italy
1432235 1432235 2022-05-18 Italy Abruzzo     397999 3275 0   42.35122196 13.39843823 2022-05-19 04:20:54 Abruzzo, Italy
1432236 1432236 2022-05-18 Italy Basilicata     135084 912 0   40.63947052 15.80514834 2022-05-19 04:20:54 Basilicata, Italy
1432237 1432237 2022-05-18 Italy Calabria     380617 2568 0   38.90597598 16.59440194 2022-05-19 04:20:54 Calabria, Italy
1432238 1432238 2022-05-18 Italy Campania     1681763 10430 0   40.83956555 14.25084984 2022-05-19 04:20:54 Campania, Italy
1432239 1432239 2022-05-18 Italy Emilia-Romagna     1465883 16833 0   44.49436681 11.3417208 2022-05-19 04:20:54 Emilia-Romagna, Italy
1432240 1432240 2022-05-18 Italy Friuli Venezia Giulia     374885 5076 0   45.6494354 13.76813649 2022-05-19 04:20:54 Friuli Venezia Giulia, Italy
1432241 1432241 2022-05-18 Italy Lazio     1547008 11268 0   41.89277044 12.48366722 2022-05-19 04:20:54 Lazio, Italy
1432242 1432242 2022-05-18 Italy Liguria     443221 5311 0   44.41149315 8.9326992 2022-05-19 04:20:54 Liguria, Italy
1432243 1432243 2022-05-18 Italy Lombardia     2858315 40342 0   45.46679409 9.190347404 2022-05-19 04:20:54 Lombardia, Italy
1432244 1432244 2022-05-18 Italy Marche     465926 3883 0   43.61675973 13.5188753 2022-05-19 04:20:54 Marche, Italy
1432245 1432245 2022-05-18 Italy Molise     64499 624 0   41.55774754 14.65916051 2022-05-19 04:20:54 Molise, Italy
1432246 1432246 2022-05-18 Italy P.A. Bolzano     216148 1473 0   46.49933453 11.35662422 2022-05-19 04:20:54 P.A. Bolzano, Italy
1432247 1432247 2022-05-18 Italy P.A. Trento     165957 1560 0   46.06893511 11.12123097 2022-05-19 04:20:54 P.A. Trento, Italy
1432248 1432248 2022-05-18 Italy Piemonte     1183596 13398 0   45.0732745 7.680687483 2022-05-19 04:20:54 Piemonte, Italy
1432249 1432249 2022-05-18 Italy Puglia     1114959 8420 0   41.12559576 16.86736689 2022-05-19 04:20:54 Puglia, Italy
1432250 1432250 2022-05-18 Italy Sardegna     301620 2420 0   39.21531192 9.110616306 2022-05-19 04:20:54 Sardegna, Italy
1432251 1432251 2022-05-18 Italy Sicilia     1164153 10824 0   38.11569725 13.3623567 2022-05-19 04:20:54 Sicilia, Italy
1432252 1432252 2022-05-18 Italy Toscana     1135444 10020 0   43.76923077 11.25588885 2022-05-19 04:20:54 Toscana, Italy
1432253 1432253 2022-05-18 Italy Umbria     281007 1839 0   43.10675841 12.38824698 2022-05-19 04:20:54 Umbria, Italy
1432254 1432254 2022-05-18 Italy Valle d'Aosta     36157 535 0   45.73750286 7.320149366 2022-05-19 04:20:54 Valle d'Aosta, Italy
1432255 1432255 2022-05-18 Italy Veneto     1733236 14619 0   45.43490485 12.33845213 2022-05-19 04:20:54 Veneto, Italy
1599511 1599511 2022-05-17 Italy Abruzzo     397046 3269 0   42.35122196 13.39843823 2022-05-18 04:20:50 Abruzzo, Italy
1599512 1599512 2022-05-17 Italy Basilicata     134796 911 0   40.63947052 15.80514834 2022-05-18 04:20:50 Basilicata, Italy
1599513 1599513 2022-05-17 Italy Calabria     379686 2566 0   38.90597598 16.59440194 2022-05-18 04:20:50 Calabria, Italy
1599514 1599514 2022-05-17 Italy Campania     1678510 10417 0   40.83956555 14.25084984 2022-05-18 04:20:50 Campania, Italy
1599515 1599515 2022-05-17 Italy Emilia-Romagna     1463050 16821 0   44.49436681 11.3417208 2022-05-18 04:20:50 Emilia-Romagna, Italy
1599516 1599516 2022-05-17 Italy Friuli Venezia Giulia     374303 5073 0   45.6494354 13.76813649 2022-05-18 04:20:50 Friuli Venezia Giulia, Italy
1599517 1599517 2022-05-17 Italy Lazio     1544125 11252 0   41.89277044 12.48366722 2022-05-18 04:20:50 Lazio, Italy
1599518 1599518 2022-05-17 Italy Liguria     442493 5307 0   44.41149315 8.9326992 2022-05-18 04:20:50 Liguria, Italy
1599519 1599519 2022-05-17 Italy Lombardia     2853990 40331 0   45.46679409 9.190347404 2022-05-18 04:20:50 Lombardia, Italy
1599520 1599520 2022-05-17 Italy Marche     465027 3883 0   43.61675973 13.5188753 2022-05-18 04:20:50 Marche, Italy
1599521 1599521 2022-05-17 Italy Molise     64276 624 0   41.55774754 14.65916051 2022-05-18 04:20:50 Molise, Italy
1599522 1599522 2022-05-17 Italy P.A. Bolzano     215871 1473 0   46.49933453 11.35662422 2022-05-18 04:20:50 P.A. Bolzano, Italy
1599523 1599523 2022-05-17 Italy P.A. Trento     165739 1560 0   46.06893511 11.12123097 2022-05-18 04:20:50 P.A. Trento, Italy
1599524 1599524 2022-05-17 Italy Piemonte     1181826 13394 0   45.0732745 7.680687483 2022-05-18 04:20:50 Piemonte, Italy
1599525 1599525 2022-05-17 Italy Puglia     1113071 8411 0   41.12559576 16.86736689 2022-05-18 04:20:50 Puglia, Italy
1599526 1599526 2022-05-17 Italy Sardegna     300521 2415 0   39.21531192 9.110616306 2022-05-18 04:20:50 Sardegna, Italy
1599527 1599527 2022-05-17 Italy Sicilia     1161423 10792 0   38.11569725 13.3623567 2022-05-18 04:20:50 Sicilia, Italy
1599528 1599528 2022-05-17 Italy Toscana     1133738 10013 0   43.76923077 11.25588885 2022-05-18 04:20:50 Toscana, Italy
1599529 1599529 2022-05-17 Italy Umbria     280331 1839 0   43.10675841 12.38824698 2022-05-18 04:20:50 Umbria, Italy
1599530 1599530 2022-05-17 Italy Valle d'Aosta     36105 535 0   45.73750286 7.320149366 2022-05-18 04:20:50 Valle d'Aosta, Italy
1599531 1599531 2022-05-17 Italy Veneto     1730623 14608 0   45.43490485 12.33845213 2022-05-18 04:20:50 Veneto, Italy
2425629 2425629 2022-05-16 Italy Abruzzo     395550 3267 0   42.35122196 13.39843823 2022-05-17 04:20:59 Abruzzo, Italy
2425630 2425630 2022-05-16 Italy Basilicata     134323 909 0   40.63947052 15.80514834 2022-05-17 04:20:59 Basilicata, Italy
2425631 2425631 2022-05-16 Italy Calabria     378062 2561 0   38.90597598 16.59440194 2022-05-17 04:20:59 Calabria, Italy
2425632 2425632 2022-05-16 Italy Campania     1673219 10409 0   40.83956555 14.25084984 2022-05-17 04:20:59 Campania, Italy
2425633 2425633 2022-05-16 Italy Emilia-Romagna     1461026 16809 0   44.49436681 11.3417208 2022-05-17 04:20:59 Emilia-Romagna, Italy
2425634 2425634 2022-05-16 Italy Friuli Venezia Giulia     373574 5067 0   45.6494354 13.76813649 2022-05-17 04:20:59 Friuli Venezia Giulia, Italy
2425635 2425635 2022-05-16 Italy Lazio     1540014 11244 0   41.89277044 12.48366722 2022-05-17 04:20:59 Lazio, Italy
2425636 2425636 2022-05-16 Italy Liguria     441398 5303 0   44.41149315 8.9326992 2022-05-17 04:20:59 Liguria, Italy
2425637 2425637 2022-05-16 Italy Lombardia     2847027 40305 0   45.46679409 9.190347404 2022-05-17 04:20:59 Lombardia, Italy
2425638 2425638 2022-05-16 Italy Marche     463651 3877 0   43.61675973 13.5188753 2022-05-17 04:20:59 Marche, Italy
2425639 2425639 2022-05-16 Italy Molise     64112 624 0   41.55774754 14.65916051 2022-05-17 04:20:59 Molise, Italy
2425640 2425640 2022-05-16 Italy P.A. Bolzano     215472 1471 0   46.49933453 11.35662422 2022-05-17 04:20:59 P.A. Bolzano, Italy
2425641 2425641 2022-05-16 Italy P.A. Trento     165455 1560 0   46.06893511 11.12123097 2022-05-17 04:20:59 P.A. Trento, Italy
2425642 2425642 2022-05-16 Italy Piemonte     1179088 13386 0   45.0732745 7.680687483 2022-05-17 04:20:59 Piemonte, Italy
2425643 2425643 2022-05-16 Italy Puglia     1109716 8397 0   41.12559576 16.86736689 2022-05-17 04:20:59 Puglia, Italy
2425644 2425644 2022-05-16 Italy Sardegna     298807 2410 0   39.21531192 9.110616306 2022-05-17 04:20:59 Sardegna, Italy

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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]);