johns_hopkins_csse_daily_reports

⚠️ 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

1,385 rows where country_or_region = "Italy" sorted by day descending

✎ View and edit SQL

This data as json, CSV (advanced)

country_or_region

  • Italy · 1,385 ✖
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
180809 180809 2020-07-13 Italy Abruzzo     3328 466 2719 143 42.35122196 13.39843823 2020-07-14 04:34:46 Abruzzo, Italy
180858 180858 2020-07-13 Italy Basilicata     406 27 374 5 40.63947052 15.80514834 2020-07-14 04:34:46 Basilicata, Italy
180878 180878 2020-07-13 Italy Calabria     1216 97 1062 57 38.90597598 16.59440194 2020-07-14 04:34:46 Calabria, Italy
180881 180881 2020-07-13 Italy Campania     4779 432 4094 253 40.83956555 14.25084984 2020-07-14 04:34:46 Campania, Italy
180931 180931 2020-07-13 Italy Emilia-Romagna     28958 4269 23496 1193 44.49436681 11.341720800000001 2020-07-14 04:34:46 Emilia-Romagna, Italy
180939 180939 2020-07-13 Italy Friuli Venezia Giulia     3335 345 2910 80 45.6494354 13.76813649 2020-07-14 04:34:46 Friuli Venezia Giulia, Italy
181045 181045 2020-07-13 Italy Lazio     8338 845 6601 892 41.89277044 12.48366722 2020-07-14 04:34:46 Lazio, Italy
181048 181048 2020-07-13 Italy Liguria     10032 1559 8255 218 44.41149315 8.9326992 2020-07-14 04:34:46 Liguria, Italy
181051 181051 2020-07-13 Italy Lombardia     95143 16757 70375 8011 45.46679409 9.190347404 2020-07-14 04:34:46 Lombardia, Italy
181068 181068 2020-07-13 Italy Marche     6804 987 5658 159 43.61675973 13.5188753 2020-07-14 04:34:46 Marche, Italy
181087 181087 2020-07-13 Italy Molise     446 23 410 13 41.55774754 14.65916051 2020-07-14 04:34:46 Molise, Italy
181140 181140 2020-07-13 Italy P.A. Bolzano     2673 292 2286 95 46.49933453 11.35662422 2020-07-14 04:34:46 P.A. Bolzano, Italy
181141 181141 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
181151 181151 2020-07-13 Italy Piemonte     31504 4112 26339 1053 45.0732745 7.680687483 2020-07-14 04:34:46 Piemonte, Italy
181161 181161 2020-07-13 Italy Puglia     4541 547 3926 68 41.12559576 16.86736689 2020-07-14 04:34:46 Puglia, Italy
181203 181203 2020-07-13 Italy Sardegna     1373 134 1229 10 39.21531192 9.110616306 2020-07-14 04:34:46 Sardegna, Italy
181217 181217 2020-07-13 Italy Sicilia     3100 283 2694 123 38.11569725 13.362356699999998 2020-07-14 04:34:46 Sicilia, Italy
181253 181253 2020-07-13 Italy Toscana     10326 1122 8869 335 43.76923077 11.25588885 2020-07-14 04:34:46 Toscana, Italy
181266 181266 2020-07-13 Italy Umbria     1450 80 1362 8 43.10675841 12.38824698 2020-07-14 04:34:46 Umbria, Italy
181278 181278 2020-07-13 Italy Valle d'Aosta     1196 146 1047 3 45.73750286 7.320149366 2020-07-14 04:34:46 Valle d'Aosta, Italy
181287 181287 2020-07-13 Italy Veneto     19401 2039 16950 412 45.43490485 12.33845213 2020-07-14 04:34:46 Veneto, Italy
321514 321514 2020-07-12 Italy Abruzzo     3328 465 2713 150 42.35122196 13.39843823 2020-07-13 04:43:04 Abruzzo, Italy
321563 321563 2020-07-12 Italy Basilicata     406 27 374 5 40.63947052 15.80514834 2020-07-13 04:43:04 Basilicata, Italy
321583 321583 2020-07-12 Italy Calabria     1216 97 1062 57 38.90597598 16.59440194 2020-07-13 04:43:04 Calabria, Italy
321586 321586 2020-07-12 Italy Campania     4772 432 4094 246 40.83956555 14.25084984 2020-07-13 04:43:04 Campania, Italy
321636 321636 2020-07-12 Italy Emilia-Romagna     28940 4269 23491 1180 44.49436681 11.341720800000001 2020-07-13 04:43:04 Emilia-Romagna, Italy
321644 321644 2020-07-12 Italy Friuli Venezia Giulia     3335 345 2911 79 45.6494354 13.76813649 2020-07-13 04:43:04 Friuli Venezia Giulia, Italy
321751 321751 2020-07-12 Italy Lazio     8314 844 6557 913 41.89277044 12.48366722 2020-07-13 04:43:04 Lazio, Italy
321754 321754 2020-07-12 Italy Liguria     10031 1559 8233 239 44.41149315 8.9326992 2020-07-13 04:43:04 Liguria, Italy
321757 321757 2020-07-12 Italy Lombardia     95049 16748 70297 8004 45.46679409 9.190347404 2020-07-13 04:43:04 Lombardia, Italy
321774 321774 2020-07-12 Italy Marche     6804 987 5650 167 43.61675973 13.5188753 2020-07-13 04:43:04 Marche, Italy
321793 321793 2020-07-12 Italy Molise     446 23 410 13 41.55774754 14.65916051 2020-07-13 04:43:04 Molise, Italy
321846 321846 2020-07-12 Italy P.A. Bolzano     2666 292 2286 88 46.49933453 11.35662422 2020-07-13 04:43:04 P.A. Bolzano, Italy
321847 321847 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
321857 321857 2020-07-12 Italy Piemonte     31498 4111 26329 1058 45.0732745 7.680687483 2020-07-13 04:43:04 Piemonte, Italy
321867 321867 2020-07-12 Italy Puglia     4541 546 3924 71 41.12559576 16.86736689 2020-07-13 04:43:04 Puglia, Italy
321909 321909 2020-07-12 Italy Sardegna     1372 134 1229 9 39.21531192 9.110616306 2020-07-13 04:43:04 Sardegna, Italy
321923 321923 2020-07-12 Italy Sicilia     3099 283 2693 123 38.11569725 13.362356699999998 2020-07-13 04:43:04 Sicilia, Italy
321959 321959 2020-07-12 Italy Toscana     10322 1122 8869 331 43.76923077 11.25588885 2020-07-13 04:43:04 Toscana, Italy
321972 321972 2020-07-12 Italy Umbria     1450 80 1361 9 43.10675841 12.38824698 2020-07-13 04:43:04 Umbria, Italy
321984 321984 2020-07-12 Italy Valle d'Aosta     1196 146 1047 3 45.73750286 7.320149366 2020-07-13 04:43:04 Valle d'Aosta, Italy
321993 321993 2020-07-12 Italy Veneto     19395 2039 16948 408 45.43490485 12.33845213 2020-07-13 04:43:04 Veneto, Italy
274906 274906 2020-07-11 Italy Abruzzo     3323 464 2712 147 42.35122196 13.39843823 2020-07-12 04:34:30 Abruzzo, Italy
274955 274955 2020-07-11 Italy Basilicata     406 27 374 5 40.63947052 15.80514834 2020-07-12 04:34:30 Basilicata, Italy
274975 274975 2020-07-11 Italy Calabria     1188 97 1062 29 38.90597598 16.59440194 2020-07-12 04:34:30 Calabria, Italy
274978 274978 2020-07-11 Italy Campania     4769 432 4095 242 40.83956555 14.25084984 2020-07-12 04:34:30 Campania, Italy
275028 275028 2020-07-11 Italy Emilia-Romagna     28869 4269 23481 1119 44.49436681 11.341720800000001 2020-07-12 04:34:30 Emilia-Romagna, Italy
275036 275036 2020-07-11 Italy Friuli Venezia Giulia     3335 345 2911 79 45.6494354 13.76813649 2020-07-12 04:34:30 Friuli Venezia Giulia, Italy
275143 275143 2020-07-11 Italy Lazio     8294 844 6535 915 41.89277044 12.48366722 2020-07-12 04:34:30 Lazio, Italy
275146 275146 2020-07-11 Italy Liguria     10031 1559 8219 253 44.41149315 8.9326992 2020-07-12 04:34:30 Liguria, Italy
275149 275149 2020-07-11 Italy Lombardia     94972 16740 70020 8212 45.46679409 9.190347404 2020-07-12 04:34:30 Lombardia, Italy
275166 275166 2020-07-11 Italy Marche     6803 987 5647 169 43.61675973 13.5188753 2020-07-12 04:34:30 Marche, Italy
275185 275185 2020-07-11 Italy Molise     445 23 410 12 41.55774754 14.65916051 2020-07-12 04:34:30 Molise, Italy
275238 275238 2020-07-11 Italy P.A. Bolzano     2661 292 2287 82 46.49933453 11.35662422 2020-07-12 04:34:30 P.A. Bolzano, Italy
275239 275239 2020-07-11 Italy P.A. Trento     4881 405 4448 28 46.06893511 11.12123097 2020-07-12 04:34:30 P.A. Trento, Italy
275249 275249 2020-07-11 Italy Piemonte     31494 4111 26314 1069 45.0732745 7.680687483 2020-07-12 04:34:30 Piemonte, Italy
275259 275259 2020-07-11 Italy Puglia     4541 546 3924 71 41.12559576 16.86736689 2020-07-12 04:34:30 Puglia, Italy
275301 275301 2020-07-11 Italy Sardegna     1372 134 1229 9 39.21531192 9.110616306 2020-07-12 04:34:30 Sardegna, Italy
275315 275315 2020-07-11 Italy Sicilia     3099 283 2693 123 38.11569725 13.362356699999998 2020-07-12 04:34:30 Sicilia, Italy
275351 275351 2020-07-11 Italy Toscana     10321 1122 8869 330 43.76923077 11.25588885 2020-07-12 04:34:30 Toscana, Italy
275364 275364 2020-07-11 Italy Umbria     1448 80 1360 8 43.10675841 12.38824698 2020-07-12 04:34:30 Umbria, Italy
275376 275376 2020-07-11 Italy Valle d'Aosta     1196 146 1047 3 45.73750286 7.320149366 2020-07-12 04:34:30 Valle d'Aosta, Italy
275385 275385 2020-07-11 Italy Veneto     19379 2039 16942 398 45.43490485 12.33845213 2020-07-12 04:34:30 Veneto, Italy
9878 9878 2020-07-10 Italy Abruzzo     3321 464 2709 148 42.35122196 13.39843823 2020-07-11 04:34:26 Abruzzo, Italy
9927 9927 2020-07-10 Italy Basilicata     405 27 373 5 40.63947052 15.80514834 2020-07-11 04:34:26 Basilicata, Italy
9947 9947 2020-07-10 Italy Calabria     1186 97 1062 27 38.90597598 16.59440194 2020-07-11 04:34:26 Calabria, Italy
9950 9950 2020-07-10 Italy Campania     4762 432 4093 237 40.83956555 14.25084984 2020-07-11 04:34:26 Campania, Italy
10000 10000 2020-07-10 Italy Emilia-Romagna     28822 4269 23440 1113 44.49436681 11.341720800000001 2020-07-11 04:34:26 Emilia-Romagna, Italy
10008 10008 2020-07-10 Italy Friuli Venezia Giulia     3333 345 2910 78 45.6494354 13.76813649 2020-07-11 04:34:26 Friuli Venezia Giulia, Italy
10115 10115 2020-07-10 Italy Lazio     8275 844 6530 901 41.89277044 12.48366722 2020-07-11 04:34:26 Lazio, Italy
10118 10118 2020-07-10 Italy Liguria     10025 1558 8203 264 44.41149315 8.9326992 2020-07-11 04:34:26 Liguria, Italy
10121 10121 2020-07-10 Italy Lombardia     94905 16736 69828 8341 45.46679409 9.190347404 2020-07-11 04:34:26 Lombardia, Italy
10138 10138 2020-07-10 Italy Marche     6799 987 5644 168 43.61675973 13.5188753 2020-07-11 04:34:26 Marche, Italy
10157 10157 2020-07-10 Italy Molise     445 23 407 15 41.55774754 14.65916051 2020-07-11 04:34:26 Molise, Italy
10210 10210 2020-07-10 Italy P.A. Bolzano     2658 292 2280 86 46.49933453 11.35662422 2020-07-11 04:34:26 P.A. Bolzano, Italy
10211 10211 2020-07-10 Italy P.A. Trento     4879 405 4447 27 46.06893511 11.12123097 2020-07-11 04:34:26 P.A. Trento, Italy
10221 10221 2020-07-10 Italy Piemonte     31485 4110 26300 1075 45.0732745 7.680687483 2020-07-11 04:34:26 Piemonte, Italy
10231 10231 2020-07-10 Italy Puglia     4540 546 3922 72 41.12559576 16.86736689 2020-07-11 04:34:26 Puglia, Italy
10273 10273 2020-07-10 Italy Sardegna     1372 134 1228 10 39.21531192 9.110616306 2020-07-11 04:34:26 Sardegna, Italy
10287 10287 2020-07-10 Italy Sicilia     3098 283 2691 124 38.11569725 13.362356699999998 2020-07-11 04:34:26 Sicilia, Italy
10323 10323 2020-07-10 Italy Toscana     10316 1121 8865 330 43.76923077 11.25588885 2020-07-11 04:34:26 Toscana, Italy
10336 10336 2020-07-10 Italy Umbria     1448 80 1360 8 43.10675841 12.38824698 2020-07-11 04:34:26 Umbria, Italy
10348 10348 2020-07-10 Italy Valle d'Aosta     1196 146 1045 5 45.73750286 7.320149366 2020-07-11 04:34:26 Valle d'Aosta, Italy
10357 10357 2020-07-10 Italy Veneto     19369 2039 16936 394 45.43490485 12.33845213 2020-07-11 04:34:26 Veneto, Italy
342091 342091 2020-07-09 Italy Abruzzo     3318 464 2707 147 42.35122196 13.39843823 2020-07-10 04:34:24 Abruzzo, Italy
342140 342140 2020-07-09 Italy Basilicata     405 27 373 5 40.63947052 15.80514834 2020-07-10 04:34:24 Basilicata, Italy
342160 342160 2020-07-09 Italy Calabria     1185 97 1060 28 38.90597598 16.59440194 2020-07-10 04:34:24 Calabria, Italy
342163 342163 2020-07-09 Italy Campania     4755 432 4091 232 40.83956555 14.25084984 2020-07-10 04:34:24 Campania, Italy
342213 342213 2020-07-09 Italy Emilia-Romagna     28769 4269 23434 1066 44.49436681 11.341720800000001 2020-07-10 04:34:24 Emilia-Romagna, Italy
342221 342221 2020-07-09 Italy Friuli Venezia Giulia     3332 345 2912 75 45.6494354 13.76813649 2020-07-10 04:34:24 Friuli Venezia Giulia, Italy
342328 342328 2020-07-09 Italy Lazio     8252 843 6520 889 41.89277044 12.48366722 2020-07-10 04:34:24 Lazio, Italy
342331 342331 2020-07-09 Italy Liguria     10010 1558 8174 278 44.41149315 8.9326992 2020-07-10 04:34:24 Liguria, Italy
342334 342334 2020-07-09 Italy Lombardia     94770 16730 69683 8357 45.46679409 9.190347404 2020-07-10 04:34:24 Lombardia, Italy
342351 342351 2020-07-09 Italy Marche     6798 987 5638 173 43.61675973 13.5188753 2020-07-10 04:34:24 Marche, Italy
342370 342370 2020-07-09 Italy Molise     445 23 407 15 41.55774754 14.65916051 2020-07-10 04:34:24 Molise, Italy
342423 342423 2020-07-09 Italy P.A. Bolzano     2653 292 2277 84 46.49933453 11.35662422 2020-07-10 04:34:24 P.A. Bolzano, Italy
342424 342424 2020-07-09 Italy P.A. Trento     4876 405 4438 33 46.06893511 11.12123097 2020-07-10 04:34:24 P.A. Trento, Italy
342434 342434 2020-07-09 Italy Piemonte     31475 4108 26243 1124 45.0732745 7.680687483 2020-07-10 04:34:24 Piemonte, Italy
342444 342444 2020-07-09 Italy Puglia     4536 546 3916 74 41.12559576 16.86736689 2020-07-10 04:34:24 Puglia, Italy
342486 342486 2020-07-09 Italy Sardegna     1371 134 1227 10 39.21531192 9.110616306 2020-07-10 04:34:24 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] INTEGER,
   [latitude] TEXT,
   [longitude] TEXT,
   [last_update] TEXT,
   [combined_key] TEXT
);
Powered by Datasette · Query took 2421.671ms · Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette