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

397 rows where country_or_region = "Italy" and province_or_state = "Piemonte" sorted by day descending

View and edit SQL

Suggested facets: day (date), last_update (date)

province_or_state

  • Piemonte · 397

country_or_region

  • Italy · 397
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
222918 2021-06-14 Italy Piemonte     362233 11678 347950 2605 45.0732745 7.680687483 2021-06-15 04:22:22 Piemonte, Italy
214950 2021-06-13 Italy Piemonte     362146 11675 347802 2669 45.0732745 7.680687483 2021-06-14 04:22:46 Piemonte, Italy
281520 2021-06-12 Italy Piemonte     362087 11674 347657 2756 45.0732745 7.680687483 2021-06-13 04:22:44 Piemonte, Italy
1633619 2021-06-11 Italy Piemonte     361997 11670 347451 2876 45.0732745 7.680687483 2021-06-12 04:22:22 Piemonte, Italy
662905 2021-06-10 Italy Piemonte     361871 11666 347185 3020 45.0732745 7.680687483 2021-06-11 04:23:20 Piemonte, Italy
882009 2021-06-09 Italy Piemonte     361734 11666 346877 3191 45.0732745 7.680687483 2021-06-10 04:23:17 Piemonte, Italy
1710008 2021-06-08 Italy Piemonte     361597 11663 346489 3445 45.0732745 7.680687483 2021-06-09 04:23:31 Piemonte, Italy
1465852 2021-06-07 Italy Piemonte     361501 11660 346202 3639 45.0732745 7.680687483 2021-06-08 04:22:35 Piemonte, Italy
993619 2021-06-06 Italy Piemonte     361401 11654 345934 3813 45.0732745 7.680687483 2021-06-07 04:22:51 Piemonte, Italy
158409 2021-06-05 Italy Piemonte     361272 11654 345690 3928 45.0732745 7.680687483 2021-06-06 04:24:03 Piemonte, Italy
1516394 2021-06-04 Italy Piemonte     361083 11652 345302 4129 45.0732745 7.680687483 2021-06-05 04:23:03 Piemonte, Italy
1140705 2021-06-03 Italy Piemonte     360892 11650 344856 4386 45.0732745 7.680687483 2021-06-04 04:23:37 Piemonte, Italy
427149 2021-06-02 Italy Piemonte     360673 11647 344463 4563 45.0732745 7.680687483 2021-06-03 04:23:32 Piemonte, Italy
539656 2021-06-01 Italy Piemonte     360483 11643 344031 4809 45.0732745 7.680687483 2021-06-02 04:24:34 Piemonte, Italy
786841 2021-05-31 Italy Piemonte     360274 11631 343478 5165 45.0732745 7.680687483 2021-06-01 04:23:09 Piemonte, Italy
1330239 2021-05-30 Italy Piemonte     360148 11624 343145 5379 45.0732745 7.680687483 2021-05-31 03:08:59 Piemonte, Italy
67448 2021-05-29 Italy Piemonte     359915 11623 342707 5585 45.0732745 7.680687483 2021-05-30 04:20:55 Piemonte, Italy
195634 2021-05-28 Italy Piemonte     359766 11620 342273 5873 45.0732745 7.680687483 2021-05-29 04:20:41 Piemonte, Italy
938893 2021-05-27 Italy Piemonte     359487 11613 341541 6333 45.0732745 7.680687483 2021-05-28 04:20:36 Piemonte, Italy
1226568 2021-05-26 Italy Piemonte     359189 11605 340872 6712 45.0732745 7.680687483 2021-05-27 04:20:59 Piemonte, Italy
1338207 2021-05-25 Italy Piemonte     358839 11600 340038 7201 45.0732745 7.680687483 2021-05-26 04:20:35 Piemonte, Italy
203039 2021-05-24 Italy Piemonte     358565 11587 339316 7662 45.0732745 7.680687483 2021-05-25 04:21:08 Piemonte, Italy
99203 2021-05-23 Italy Piemonte     358459 11579 338952 7928 45.0732745 7.680687483 2021-05-24 04:20:53 Piemonte, Italy
523722 2021-05-22 Italy Piemonte     358188 11577 338402 8209 45.0732745 7.680687483 2021-05-23 04:20:51 Piemonte, Italy
859417 2021-05-21 Italy Piemonte     357788 11573 337659 8556 45.0732745 7.680687483 2021-05-22 04:20:45 Piemonte, Italy
720840 2021-05-20 Italy Piemonte     357395 11559 336799 9037 45.0732745 7.680687483 2021-05-21 04:20:43 Piemonte, Italy
407971 2021-05-19 Italy Piemonte     356969 11549 336000 9420 45.0732745 7.680687483 2021-05-20 04:21:05 Piemonte, Italy
782857 2021-05-18 Italy Piemonte     356454 11535 334963 9956 45.0732745 7.680687483 2021-05-19 04:20:42 Piemonte, Italy
1422999 2021-05-17 Italy Piemonte     356017 11514 334085 10418 45.0732745 7.680687483 2021-05-18 04:20:33 Piemonte, Italy
740185 2021-05-16 Italy Piemonte     355810 11504 333451 10855 45.0732745 7.680687483 2021-05-17 04:20:34 Piemonte, Italy
1116718 2021-05-15 Italy Piemonte     355407 11499 332802 11106 45.0732745 7.680687483 2021-05-16 04:20:49 Piemonte, Italy
1587227 2021-05-14 Italy Piemonte     354935 11484 331942 11509 45.0732745 7.680687483 2021-05-15 04:20:58 Piemonte, Italy
1675144 2021-05-13 Italy Piemonte     354340 11465 330981 11894 45.0732745 7.680687483 2021-05-14 04:20:41 Piemonte, Italy
802771 2021-05-12 Italy Piemonte     353634 11451 329898 12285 45.0732745 7.680687483 2021-05-13 04:20:51 Piemonte, Italy
1181159 2021-05-11 Italy Piemonte     352860 11433 328741 12686 45.0732745 7.680687483 2021-05-12 04:21:29 Piemonte, Italy
324949 2021-05-10 Italy Piemonte     352331 11421 327784 13126 45.0732745 7.680687483 2021-05-11 04:20:41 Piemonte, Italy
604096 2021-05-09 Italy Piemonte     351985 11404 327094 13487 45.0732745 7.680687483 2021-05-10 04:20:38 Piemonte, Italy
985843 2021-05-08 Italy Piemonte     351393 11391 326399 13603 45.0732745 7.680687483 2021-05-09 04:20:35 Piemonte, Italy
434325 2021-05-07 Italy Piemonte     350674 11384 325428 13862 45.0732745 7.680687483 2021-05-08 04:21:04 Piemonte, Italy
901106 2021-05-06 Italy Piemonte     349807 11370 324380 14057 45.0732745 7.680687483 2021-05-07 04:20:40 Piemonte, Italy
71432 2021-05-05 Italy Piemonte     348904 11352 323186 14366 45.0732745 7.680687483 2021-05-06 04:20:38 Piemonte, Italy
790825 2021-05-04 Italy Piemonte     347957 11330 321868 14759 45.0732745 7.680687483 2021-05-05 04:20:43 Piemonte, Italy
1613355 2021-05-03 Italy Piemonte     347320 11302 320847 15171 45.0732745 7.680687483 2021-05-04 04:20:34 Piemonte, Italy
885993 2021-05-02 Italy Piemonte     346977 11283 320221 15473 45.0732745 7.680687483 2021-05-03 04:20:39 Piemonte, Italy
511698 2021-05-01 Italy Piemonte     346275 11273 319531 15471 45.0732745 7.680687483 2021-05-02 04:20:48 Piemonte, Italy
14634 2021-04-30 Italy Piemonte     345393 11255 318439 15699 45.0732745 7.680687483 2021-05-01 04:20:47 Piemonte, Italy
1124738 2021-04-29 Italy Piemonte     344357 11237 316999 16121 45.0732745 7.680687483 2021-04-30 04:21:03 Piemonte, Italy
462035 2021-04-28 Italy Piemonte     343273 11219 315596 16458 45.0732745 7.680687483 2021-04-29 04:20:55 Piemonte, Italy
1314741 2021-04-27 Italy Piemonte     342086 11185 314137 16764 45.0732745 7.680687483 2021-04-28 04:20:32 Piemonte, Italy
1549168 2021-04-26 Italy Piemonte     341419 11158 313172 17089 45.0732745 7.680687483 2021-04-27 04:20:52 Piemonte, Italy
1629635 2021-04-25 Italy Piemonte     340851 11137 312241 17473 45.0732745 7.680687483 2021-04-26 04:21:04 Piemonte, Italy
353775 2021-04-24 Italy Piemonte     339873 11124 311098 17651 45.0732745 7.680687483 2021-04-25 04:20:32 Piemonte, Italy
724824 2021-04-23 Italy Piemonte     339052 11104 309503 18445 45.0732745 7.680687483 2021-04-24 04:20:38 Piemonte, Italy
1469836 2021-04-22 Italy Piemonte     337953 11085 307736 19132 45.0732745 7.680687483 2021-04-23 04:20:52 Piemonte, Italy
1222584 2021-04-21 Italy Piemonte     336489 11039 305622 19828 45.0732745 7.680687483 2021-04-22 04:20:53 Piemonte, Italy
458051 2021-04-20 Italy Piemonte     335463 10991 303708 20764 45.0732745 7.680687483 2021-04-21 04:21:14 Piemonte, Italy
1300239 2021-04-19 Italy Piemonte     334475 10960 301931 21584 45.0732745 7.680687483 2021-04-20 04:20:41 Piemonte, Italy
1069818 2021-04-18 Italy Piemonte     333788 10927 300265 22596 45.0732745 7.680687483 2021-04-19 04:20:57 Piemonte, Italy
1045700 2021-04-17 Italy Piemonte     333037 10924 299710 22403 45.0732745 7.680687483 2021-04-18 04:20:41 Piemonte, Italy
596976 2021-04-16 Italy Piemonte     332172 10899 297901 23372 45.0732745 7.680687483 2021-04-17 04:20:40 Piemonte, Italy
1621392 2021-04-15 Italy Piemonte     330972 10861 295770 24341 45.0732745 7.680687483 2021-04-16 04:20:46 Piemonte, Italy
950823 2021-04-14 Italy Piemonte     329708 10835 293615 25258 45.0732745 7.680687483 2021-04-15 04:20:54 Piemonte, Italy
592992 2021-04-13 Italy Piemonte     328269 10765 291115 26389 45.0732745 7.680687483 2021-04-14 04:20:41 Piemonte, Italy
32931 2021-04-12 Italy Piemonte     327212 10690 288861 27661 45.0732745 7.680687483 2021-04-13 04:20:37 Piemonte, Italy
1371946 2021-04-11 Italy Piemonte     326576 10660 287544 28372 45.0732745 7.680687483 2021-04-12 04:21:00 Piemonte, Italy
1667198 2021-04-10 Italy Piemonte     325204 10647 285884 28673 45.0732745 7.680687483 2021-04-11 04:20:56 Piemonte, Italy
1159814 2021-04-09 Italy Piemonte     323937 10625 283629 29683 45.0732745 7.680687483 2021-04-10 04:20:59 Piemonte, Italy
1057649 2021-04-08 Italy Piemonte     322139 10588 281158 30393 45.0732745 7.680687483 2021-04-09 04:21:13 Piemonte, Italy
1500438 2021-04-07 Italy Piemonte     320478 10560 278396 31522 45.0732745 7.680687483 2021-04-08 04:21:13 Piemonte, Italy
1207643 2021-04-06 Italy Piemonte     319014 10481 275745 32788 45.0732745 7.680687483 2021-04-07 04:20:53 Piemonte, Italy
122944 2021-04-05 Italy Piemonte     318162 10463 273946 33753 45.0732745 7.680687483 2021-04-06 04:20:32 Piemonte, Italy
1254745 2021-04-04 Italy Piemonte     317358 10450 272953 33955 45.0732745 7.680687483 2021-04-05 04:20:35 Piemonte, Italy
1128722 2021-04-03 Italy Piemonte     315933 10422 271475 34036 45.0732745 7.680687483 2021-04-04 04:20:49 Piemonte, Italy
270113 2021-04-02 Italy Piemonte     313806 10399 269038 34369 45.0732745 7.680687483 2021-04-03 04:20:44 Piemonte, Italy
1173445 2021-04-01 Italy Piemonte     311864 10336 266781 34747 45.0732745 7.680687483 2021-04-02 04:20:36 Piemonte, Italy
515756 2021-03-31 Italy Piemonte     309280 10308 263913 35059 45.0732745 7.680687483 2021-04-01 04:27:05 Piemonte, Italy
289485 2021-03-30 Italy Piemonte     306982 10269 261296 35417 45.0732745 7.680687483 2021-03-31 04:26:25 Piemonte, Italy
1575022 2021-03-29 Italy Piemonte     305121 10208 259128 35785 45.0732745 7.680687483 2021-03-30 04:26:23 Piemonte, Italy
631299 2021-03-28 Italy Piemonte     303617 10190 257852 35575 45.0732745 7.680687483 2021-03-29 04:28:35 Piemonte, Italy
608080 2021-03-27 Italy Piemonte     302074 10180 256309 35585 45.0732745 7.680687483 2021-03-28 05:28:10 Piemonte, Italy
1334223 2021-03-26 Italy Piemonte     299438 10131 254172 35135 45.0732745 7.680687483 2021-03-27 05:25:04 Piemonte, Italy
150662 2021-03-25 Italy Piemonte     297321 10093 251936 35292 45.0732745 7.680687483 2021-03-26 05:26:55 Piemonte, Italy
1598183 2021-03-24 Italy Piemonte     294739 10053 249738 34948 45.0732745 7.680687483 2021-03-25 05:27:00 Piemonte, Italy
403987 2021-03-23 Italy Piemonte     292516 10023 247610 34883 45.0732745 7.680687483 2021-03-24 05:25:40 Piemonte, Italy
1387524 2021-03-22 Italy Piemonte     290436 9948 245605 34883 45.0732745 7.680687483 2021-03-23 05:26:18 Piemonte, Italy
305011 2021-03-21 Italy Piemonte     288915 9908 244476 34531 45.0732745 7.680687483 2021-03-22 05:25:43 Piemonte, Italy
254060 2021-03-20 Italy Piemonte     287164 9896 243271 33997 45.0732745 7.680687483 2021-03-21 05:25:44 Piemonte, Italy
1230816 2021-03-19 Italy Piemonte     285023 9844 241724 33455 45.0732745 7.680687483 2021-03-20 05:25:46 Piemonte, Italy
974741 2021-03-18 Italy Piemonte     282026 9811 240055 32160 45.0732745 7.680687483 2021-03-19 05:26:09 Piemonte, Italy
1532376 2021-03-17 Italy Piemonte     279669 9766 238509 31394 45.0732745 7.680687483 2021-03-18 05:26:22 Piemonte, Italy
55570 2021-03-16 Italy Piemonte     277295 9725 236786 30784 45.0732745 7.680687483 2021-03-17 05:25:07 Piemonte, Italy
562883 2021-03-15 Italy Piemonte     275221 9682 235339 30200 45.0732745 7.680687483 2021-03-16 05:25:13 Piemonte, Italy
851452 2021-03-14 Italy Piemonte     273479 9663 234164 29652 45.0732745 7.680687483 2021-03-15 05:25:51 Piemonte, Italy
942877 2021-03-13 Italy Piemonte     271949 9660 233612 28677 45.0732745 7.680687483 2021-03-14 05:25:37 Piemonte, Italy
1310757 2021-03-12 Italy Piemonte     269790 9632 232519 27639 45.0732745 7.680687483 2021-03-13 05:25:15 Piemonte, Italy
1077595 2021-03-11 Italy Piemonte     266861 9604 231252 26005 45.0732745 7.680687483 2021-03-12 05:26:50 Piemonte, Italy
954807 2021-03-10 Italy Piemonte     264539 9562 230300 24677 45.0732745 7.680687483 2021-03-11 05:25:48 Piemonte, Italy
543640 2021-03-09 Italy Piemonte     262453 9533 229138 23782 45.0732745 7.680687483 2021-03-10 05:24:35 Piemonte, Italy
1520378 2021-03-08 Italy Piemonte     260435 9511 228042 22882 45.0732745 7.680687483 2021-03-09 05:28:19 Piemonte, Italy
866659 2021-03-07 Italy Piemonte     259221 9495 227421 22305 45.0732745 7.680687483 2021-03-08 05:24:48 Piemonte, 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
);
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]);