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

7,664 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

country_or_region

  • Italy · 7,664 ✖
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
1020206 1020206 2021-05-08 Italy Abruzzo     72371 2434 62115 7822 42.35122196 13.39843823 2021-05-09 04:20:35 Abruzzo, Italy
1020207 1020207 2021-05-08 Italy Basilicata     24882 548 18307 6027 40.63947052 15.80514834 2021-05-09 04:20:35 Basilicata, Italy
1020208 1020208 2021-05-08 Italy Calabria     62638 1071 47900 13667 38.90597598 16.59440194 2021-05-09 04:20:35 Calabria, Italy
1020209 1020209 2021-05-08 Italy Campania     403131 6626 310521 85984 40.83956555 14.25084984 2021-05-09 04:20:35 Campania, Italy
1020210 1020210 2021-05-08 Italy Emilia-Romagna     375371 13007 324679 37685 44.49436681 11.3417208 2021-05-09 04:20:35 Emilia-Romagna, Italy
1020211 1020211 2021-05-08 Italy Friuli Venezia Giulia     106017 3740 95790 6487 45.6494354 13.76813649 2021-05-09 04:20:35 Friuli Venezia Giulia, Italy
1020212 1020212 2021-05-08 Italy Lazio     331180 7867 285123 38190 41.89277044 12.48366722 2021-05-09 04:20:35 Lazio, Italy
1020213 1020213 2021-05-08 Italy Liguria     100863 4241 92634 3988 44.41149315 8.9326992 2021-05-09 04:20:35 Liguria, Italy
1020214 1020214 2021-05-08 Italy Lombardia     817088 33149 738385 45554 45.46679409 9.190347404 2021-05-09 04:20:35 Lombardia, Italy
1020215 1020215 2021-05-08 Italy Marche     99487 2965 90934 5588 43.61675973 13.5188753 2021-05-09 04:20:35 Marche, Italy
1020216 1020216 2021-05-08 Italy Molise     13414 482 12459 473 41.55774754 14.65916051 2021-05-09 04:20:35 Molise, Italy
1020217 1020217 2021-05-08 Italy P.A. Bolzano     71720 1167 69393 1160 46.49933453 11.35662422 2021-05-09 04:20:35 P.A. Bolzano, Italy
1020218 1020218 2021-05-08 Italy P.A. Trento     44500 1346 42220 934 46.06893511 11.12123097 2021-05-09 04:20:35 P.A. Trento, Italy
1020219 1020219 2021-05-08 Italy Piemonte     351393 11391 326399 13603 45.0732745 7.680687483 2021-05-09 04:20:35 Piemonte, Italy
1020220 1020220 2021-05-08 Italy Puglia     242041 6078 191583 44380 41.12559576 16.86736689 2021-05-09 04:20:35 Puglia, Italy
1020221 1020221 2021-05-08 Italy Sardegna     55597 1414 38447 15736 39.21531192 9.110616306 2021-05-09 04:20:35 Sardegna, Italy
1020222 1020222 2021-05-08 Italy Sicilia     215333 5546 187157 22630 38.11569725 13.362356699999998 2021-05-09 04:20:35 Sicilia, Italy
1020223 1020223 2021-05-08 Italy Toscana     232536 6373 208320 17843 43.76923077 11.25588885 2021-05-09 04:20:35 Toscana, Italy
1020224 1020224 2021-05-08 Italy Umbria     55162 1367 51159 2636 43.10675841 12.38824698 2021-05-09 04:20:35 Umbria, Italy
1020225 1020225 2021-05-08 Italy Valle d'Aosta     11209 462 10142 605 45.73750286 7.320149366 2021-05-09 04:20:35 Valle d'Aosta, Italy
1020226 1020226 2021-05-08 Italy Veneto     416988 11420 386440 19128 45.43490485 12.33845213 2021-05-09 04:20:35 Veneto, Italy
928379 928379 2021-05-07 Italy Abruzzo     72286 2428 61947 7911 42.35122196 13.39843823 2021-05-08 04:21:04 Abruzzo, Italy
928380 928380 2021-05-07 Italy Basilicata     24765 546 18036 6183 40.63947052 15.80514834 2021-05-08 04:21:04 Basilicata, Italy
928381 928381 2021-05-07 Italy Calabria     62304 1064 47408 13832 38.90597598 16.59440194 2021-05-08 04:21:04 Calabria, Italy
928382 928382 2021-05-07 Italy Campania     401716 6591 308632 86493 40.83956555 14.25084984 2021-05-08 04:21:04 Campania, Italy
928383 928383 2021-05-07 Italy Emilia-Romagna     374498 12992 321870 39636 44.49436681 11.3417208 2021-05-08 04:21:04 Emilia-Romagna, Italy
928384 928384 2021-05-07 Italy Friuli Venezia Giulia     105927 3732 95588 6607 45.6494354 13.76813649 2021-05-08 04:21:04 Friuli Venezia Giulia, Italy
928385 928385 2021-05-07 Italy Lazio     330181 7852 283769 38560 41.89277044 12.48366722 2021-05-08 04:21:04 Lazio, Italy
928386 928386 2021-05-07 Italy Liguria     100661 4236 92144 4281 44.41149315 8.9326992 2021-05-08 04:21:04 Liguria, Italy
928387 928387 2021-05-07 Italy Lombardia     815504 33106 735292 47106 45.46679409 9.190347404 2021-05-08 04:21:04 Lombardia, Italy
928388 928388 2021-05-07 Italy Marche     99233 2960 90607 5666 43.61675973 13.5188753 2021-05-08 04:21:04 Marche, Italy
928389 928389 2021-05-07 Italy Molise     13385 480 12388 517 41.55774754 14.65916051 2021-05-08 04:21:04 Molise, Italy
928390 928390 2021-05-07 Italy P.A. Bolzano     71645 1167 69304 1174 46.49933453 11.35662422 2021-05-08 04:21:04 P.A. Bolzano, Italy
928391 928391 2021-05-07 Italy P.A. Trento     44441 1346 42142 953 46.06893511 11.12123097 2021-05-08 04:21:04 P.A. Trento, Italy
928392 928392 2021-05-07 Italy Piemonte     350674 11384 325428 13862 45.0732745 7.680687483 2021-05-08 04:21:04 Piemonte, Italy
928393 928393 2021-05-07 Italy Puglia     241062 6057 190368 44637 41.12559576 16.86736689 2021-05-08 04:21:04 Puglia, Italy
928394 928394 2021-05-07 Italy Sardegna     55438 1409 38264 15765 39.21531192 9.110616306 2021-05-08 04:21:04 Sardegna, Italy
928395 928395 2021-05-07 Italy Sicilia     214482 5527 185625 23330 38.11569725 13.362356699999998 2021-05-08 04:21:04 Sicilia, Italy
928396 928396 2021-05-07 Italy Toscana     231860 6352 207361 18147 43.76923077 11.25588885 2021-05-08 04:21:04 Toscana, Italy
928397 928397 2021-05-07 Italy Umbria     55065 1366 51054 2645 43.10675841 12.38824698 2021-05-08 04:21:04 Umbria, Italy
928398 928398 2021-05-07 Italy Valle d'Aosta     11169 461 10078 630 45.73750286 7.320149366 2021-05-08 04:21:04 Valle d'Aosta, Italy
928399 928399 2021-05-07 Italy Veneto     416451 11414 385408 19629 45.43490485 12.33845213 2021-05-08 04:21:04 Veneto, Italy
622449 622449 2021-05-06 Italy Abruzzo     72090 2422 61506 8162 42.35122196 13.39843823 2021-05-07 04:20:40 Abruzzo, Italy
622450 622450 2021-05-06 Italy Basilicata     24645 544 17919 6182 40.63947052 15.80514834 2021-05-07 04:20:40 Basilicata, Italy
622451 622451 2021-05-06 Italy Calabria     61854 1056 47146 13652 38.90597598 16.59440194 2021-05-07 04:20:40 Calabria, Italy
622452 622452 2021-05-06 Italy Campania     400334 6548 306455 87331 40.83956555 14.25084984 2021-05-07 04:20:40 Campania, Italy
622453 622453 2021-05-06 Italy Emilia-Romagna     373632 12976 321141 39515 44.49436681 11.3417208 2021-05-07 04:20:40 Emilia-Romagna, Italy
622454 622454 2021-05-06 Italy Friuli Venezia Giulia     105841 3726 95383 6732 45.6494354 13.76813649 2021-05-07 04:20:40 Friuli Venezia Giulia, Italy
622455 622455 2021-05-06 Italy Lazio     329118 7835 282492 38791 41.89277044 12.48366722 2021-05-07 04:20:40 Lazio, Italy
622456 622456 2021-05-06 Italy Liguria     100528 4227 91756 4545 44.41149315 8.9326992 2021-05-07 04:20:40 Liguria, Italy
622457 622457 2021-05-06 Italy Lombardia     813745 33081 732612 48052 45.46679409 9.190347404 2021-05-07 04:20:40 Lombardia, Italy
622458 622458 2021-05-06 Italy Marche     98919 2957 90207 5755 43.61675973 13.5188753 2021-05-07 04:20:40 Marche, Italy
622459 622459 2021-05-06 Italy Molise     13355 479 12361 515 41.55774754 14.65916051 2021-05-07 04:20:40 Molise, Italy
622460 622460 2021-05-06 Italy P.A. Bolzano     71583 1167 69216 1200 46.49933453 11.35662422 2021-05-07 04:20:40 P.A. Bolzano, Italy
622461 622461 2021-05-06 Italy P.A. Trento     44351 1346 42038 967 46.06893511 11.12123097 2021-05-07 04:20:40 P.A. Trento, Italy
622462 622462 2021-05-06 Italy Piemonte     349807 11370 324380 14057 45.0732745 7.680687483 2021-05-07 04:20:40 Piemonte, Italy
622463 622463 2021-05-06 Italy Puglia     240192 6037 188680 45475 41.12559576 16.86736689 2021-05-07 04:20:40 Puglia, Italy
622464 622464 2021-05-06 Italy Sardegna     55274 1405 37873 15996 39.21531192 9.110616306 2021-05-07 04:20:40 Sardegna, Italy
622465 622465 2021-05-06 Italy Sicilia     213879 5516 184485 23878 38.11569725 13.362356699999998 2021-05-07 04:20:40 Sicilia, Italy
622466 622466 2021-05-06 Italy Toscana     231145 6341 206136 18668 43.76923077 11.25588885 2021-05-07 04:20:40 Toscana, Italy
622467 622467 2021-05-06 Italy Umbria     54966 1365 50917 2684 43.10675841 12.38824698 2021-05-07 04:20:40 Umbria, Italy
622468 622468 2021-05-06 Italy Valle d'Aosta     11118 461 10047 610 45.73750286 7.320149366 2021-05-07 04:20:40 Valle d'Aosta, Italy
622469 622469 2021-05-06 Italy Veneto     415822 11404 384383 20035 45.43490485 12.33845213 2021-05-07 04:20:40 Veneto, Italy
452962 452962 2021-05-05 Italy Abruzzo     71916 2422 61333 8161 42.35122196 13.39843823 2021-05-06 04:20:38 Abruzzo, Italy
452963 452963 2021-05-05 Italy Basilicata     24505 543 17687 6275 40.63947052 15.80514834 2021-05-06 04:20:38 Basilicata, Italy
452964 452964 2021-05-05 Italy Calabria     61511 1046 46590 13875 38.90597598 16.59440194 2021-05-06 04:20:38 Calabria, Italy
452965 452965 2021-05-05 Italy Campania     398831 6522 304273 88036 40.83956555 14.25084984 2021-05-06 04:20:38 Campania, Italy
452966 452966 2021-05-05 Italy Emilia-Romagna     372817 12957 320778 39082 44.49436681 11.3417208 2021-05-06 04:20:38 Emilia-Romagna, Italy
452967 452967 2021-05-05 Italy Friuli Venezia Giulia     105761 3723 95172 6866 45.6494354 13.76813649 2021-05-06 04:20:38 Friuli Venezia Giulia, Italy
452968 452968 2021-05-05 Italy Lazio     328111 7796 280117 40198 41.89277044 12.48366722 2021-05-06 04:20:38 Lazio, Italy
452969 452969 2021-05-05 Italy Liguria     100327 4219 91406 4702 44.41149315 8.9326992 2021-05-06 04:20:38 Liguria, Italy
452970 452970 2021-05-05 Italy Lombardia     811594 33046 731260 47288 45.46679409 9.190347404 2021-05-06 04:20:38 Lombardia, Italy
452971 452971 2021-05-05 Italy Marche     98637 2953 89811 5873 43.61675973 13.5188753 2021-05-06 04:20:38 Marche, Italy
452972 452972 2021-05-05 Italy Molise     13344 479 12316 549 41.55774754 14.65916051 2021-05-06 04:20:38 Molise, Italy
452973 452973 2021-05-05 Italy P.A. Bolzano     71521 1167 69163 1191 46.49933453 11.35662422 2021-05-06 04:20:38 P.A. Bolzano, Italy
452974 452974 2021-05-05 Italy P.A. Trento     44282 1346 42000 936 46.06893511 11.12123097 2021-05-06 04:20:38 P.A. Trento, Italy
452975 452975 2021-05-05 Italy Piemonte     348904 11352 323186 14366 45.0732745 7.680687483 2021-05-06 04:20:38 Piemonte, Italy
452976 452976 2021-05-05 Italy Puglia     239315 6010 186819 46486 41.12559576 16.86736689 2021-05-06 04:20:38 Puglia, Italy
452977 452977 2021-05-05 Italy Sardegna     55146 1403 37496 16247 39.21531192 9.110616306 2021-05-06 04:20:38 Sardegna, Italy
452978 452978 2021-05-05 Italy Sicilia     212677 5492 182656 24529 38.11569725 13.362356699999998 2021-05-06 04:20:38 Sicilia, Italy
452979 452979 2021-05-05 Italy Toscana     230284 6308 205040 18936 43.76923077 11.25588885 2021-05-06 04:20:38 Toscana, Italy
452980 452980 2021-05-05 Italy Umbria     54867 1364 50776 2727 43.10675841 12.38824698 2021-05-06 04:20:38 Umbria, Italy
452981 452981 2021-05-05 Italy Valle d'Aosta     11078 460 9988 630 45.73750286 7.320149366 2021-05-06 04:20:38 Valle d'Aosta, Italy
452982 452982 2021-05-05 Italy Veneto     414972 11397 383399 20176 45.43490485 12.33845213 2021-05-06 04:20:38 Veneto, Italy
764666 764666 2021-05-04 Italy Abruzzo     71724 2420 60938 8366 42.35122196 13.39843823 2021-05-05 04:20:43 Abruzzo, Italy
764667 764667 2021-05-04 Italy Basilicata     24330 542 17565 6223 40.63947052 15.80514834 2021-05-05 04:20:43 Basilicata, Italy
764668 764668 2021-05-04 Italy Calabria     61227 1040 46040 14147 38.90597598 16.59440194 2021-05-05 04:20:43 Calabria, Italy
764669 764669 2021-05-04 Italy Campania     397384 6484 301880 89020 40.83956555 14.25084984 2021-05-05 04:20:43 Campania, Italy
764670 764670 2021-05-04 Italy Emilia-Romagna     372262 12940 320194 39128 44.49436681 11.3417208 2021-05-05 04:20:43 Emilia-Romagna, Italy
764671 764671 2021-05-04 Italy Friuli Venezia Giulia     105587 3720 94813 7054 45.6494354 13.76813649 2021-05-05 04:20:43 Friuli Venezia Giulia, Italy
764672 764672 2021-05-04 Italy Lazio     327273 7757 278237 41279 41.89277044 12.48366722 2021-05-05 04:20:43 Lazio, Italy
764673 764673 2021-05-04 Italy Liguria     100133 4210 90886 5037 44.41149315 8.9326992 2021-05-05 04:20:43 Liguria, Italy
764674 764674 2021-05-04 Italy Lombardia     810037 33014 728840 48183 45.46679409 9.190347404 2021-05-05 04:20:43 Lombardia, Italy
764675 764675 2021-05-04 Italy Marche     98359 2951 89398 6010 43.61675973 13.5188753 2021-05-05 04:20:43 Marche, Italy
764676 764676 2021-05-04 Italy Molise     13314 478 12269 567 41.55774754 14.65916051 2021-05-05 04:20:43 Molise, Italy
764677 764677 2021-05-04 Italy P.A. Bolzano     71427 1164 69094 1169 46.49933453 11.35662422 2021-05-05 04:20:43 P.A. Bolzano, Italy
764678 764678 2021-05-04 Italy P.A. Trento     44219 1346 41861 1012 46.06893511 11.12123097 2021-05-05 04:20:43 P.A. Trento, Italy
764679 764679 2021-05-04 Italy Piemonte     347957 11330 321868 14759 45.0732745 7.680687483 2021-05-05 04:20:43 Piemonte, Italy
764680 764680 2021-05-04 Italy Puglia     238144 5998 185526 46620 41.12559576 16.86736689 2021-05-05 04:20:43 Puglia, Italy
764681 764681 2021-05-04 Italy Sardegna     54980 1398 37139 16443 39.21531192 9.110616306 2021-05-05 04:20:43 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]);