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

402 rows where country_or_region = "Italy" and province_or_state = "Toscana" sorted by day descending

View and edit SQL

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

province_or_state

  • Toscana · 402

country_or_region

  • Italy · 402
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
168455 2021-06-19 Italy Toscana     243809 6842 233679 3288 43.76923077 11.25588885 2021-06-20 04:21:48 Toscana, Italy
685980 2021-06-18 Italy Toscana     243747 6841 233436 3470 43.76923077 11.25588885 2021-06-19 04:22:33 Toscana, Italy
958037 2021-06-17 Italy Toscana     243680 6838 233201 3641 43.76923077 11.25588885 2021-06-18 04:22:16 Toscana, Italy
1281404 2021-06-16 Italy Toscana     243620 6832 232927 3861 43.76923077 11.25588885 2021-06-17 04:22:36 Toscana, Italy
681994 2021-06-15 Italy Toscana     243514 6826 232632 4056 43.76923077 11.25588885 2021-06-16 04:22:32 Toscana, Italy
372548 2021-06-14 Italy Toscana     243457 6819 232432 4206 43.76923077 11.25588885 2021-06-15 04:22:22 Toscana, Italy
1223364 2021-06-13 Italy Toscana     243375 6816 232101 4458 43.76923077 11.25588885 2021-06-14 04:22:46 Toscana, Italy
80645 2021-06-12 Italy Toscana     243252 6810 231869 4573 43.76923077 11.25588885 2021-06-13 04:22:44 Toscana, Italy
969948 2021-06-11 Italy Toscana     243106 6805 231515 4786 43.76923077 11.25588885 2021-06-12 04:22:22 Toscana, Italy
1438521 2021-06-10 Italy Toscana     242960 6796 231192 4972 43.76923077 11.25588885 2021-06-11 04:23:20 Toscana, Italy
1157020 2021-06-09 Italy Toscana     242786 6784 230765 5237 43.76923077 11.25588885 2021-06-10 04:23:17 Toscana, Italy
1231336 2021-06-08 Italy Toscana     242659 6775 230340 5544 43.76923077 11.25588885 2021-06-09 04:23:31 Toscana, Italy
360332 2021-06-07 Italy Toscana     242569 6764 229981 5824 43.76923077 11.25588885 2021-06-08 04:22:35 Toscana, Italy
1075960 2021-06-06 Italy Toscana     242409 6758 229666 5985 43.76923077 11.25588885 2021-06-07 04:22:51 Toscana, Italy
1613352 2021-06-05 Italy Toscana     242216 6749 229320 6147 43.76923077 11.25588885 2021-06-06 04:24:03 Toscana, Italy
1125638 2021-06-04 Italy Toscana     242062 6741 228895 6426 43.76923077 11.25588885 2021-06-05 04:23:03 Toscana, Italy
318094 2021-06-03 Italy Toscana     241929 6736 228399 6794 43.76923077 11.25588885 2021-06-04 04:23:37 Toscana, Italy
1133607 2021-06-02 Italy Toscana     241743 6729 227895 7119 43.76923077 11.25588885 2021-06-03 04:23:32 Toscana, Italy
291784 2021-06-01 Italy Toscana     241581 6725 227243 7613 43.76923077 11.25588885 2021-06-02 04:24:34 Toscana, Italy
1651735 2021-05-31 Italy Toscana     241422 6719 226601 8102 43.76923077 11.25588885 2021-06-01 04:23:09 Toscana, Italy
980963 2021-05-30 Italy Toscana     241275 6706 226182 8387 43.76923077 11.25588885 2021-05-31 03:08:59 Toscana, Italy
841344 2021-05-29 Italy Toscana     241012 6698 225696 8618 43.76923077 11.25588885 2021-05-30 04:20:55 Toscana, Italy
697916 2021-05-28 Italy Toscana     240812 6689 224992 9131 43.76923077 11.25588885 2021-05-29 04:20:41 Toscana, Italy
1369417 2021-05-27 Italy Toscana     240511 6673 224355 9483 43.76923077 11.25588885 2021-05-28 04:20:36 Toscana, Italy
1292502 2021-05-26 Italy Toscana     240192 6657 223632 9903 43.76923077 11.25588885 2021-05-27 04:20:59 Toscana, Italy
602873 2021-05-25 Italy Toscana     239934 6646 222862 10426 43.76923077 11.25588885 2021-05-26 04:20:35 Toscana, Italy
1365431 2021-05-24 Italy Toscana     239719 6639 222131 10949 43.76923077 11.25588885 2021-05-25 04:21:08 Toscana, Italy
419944 2021-05-23 Italy Toscana     239474 6625 221550 11299 43.76923077 11.25588885 2021-05-24 04:20:53 Toscana, Italy
54283 2021-05-22 Italy Toscana     239092 6617 220923 11552 43.76923077 11.25588885 2021-05-23 04:20:51 Toscana, Italy
368562 2021-05-21 Italy Toscana     238734 6601 219845 12288 43.76923077 11.25588885 2021-05-22 04:20:45 Toscana, Italy
1024361 2021-05-20 Italy Toscana     238342 6590 218890 12862 43.76923077 11.25588885 2021-05-21 04:20:43 Toscana, Italy
1678987 2021-05-19 Italy Toscana     237783 6575 217735 13473 43.76923077 11.25588885 2021-05-20 04:21:05 Toscana, Italy
64974 2021-05-18 Italy Toscana     237442 6559 216951 13932 43.76923077 11.25588885 2021-05-19 04:20:42 Toscana, Italy
1243046 2021-05-17 Italy Toscana     237151 6541 216579 14031 43.76923077 11.25588885 2021-05-18 04:20:33 Toscana, Italy
1067894 2021-05-16 Italy Toscana     236769 6526 215972 14271 43.76923077 11.25588885 2021-05-17 04:20:34 Toscana, Italy
505022 2021-05-15 Italy Toscana     236263 6518 215214 14531 43.76923077 11.25588885 2021-05-16 04:20:49 Toscana, Italy
892627 2021-05-14 Italy Toscana     235772 6499 214299 14974 43.76923077 11.25588885 2021-05-15 04:20:58 Toscana, Italy
531962 2021-05-13 Italy Toscana     235243 6482 213331 15430 43.76923077 11.25588885 2021-05-14 04:20:41 Toscana, Italy
1719249 2021-05-12 Italy Toscana     234592 6461 212215 15916 43.76923077 11.25588885 2021-05-13 04:20:51 Toscana, Italy
1723235 2021-05-11 Italy Toscana     234097 6423 211216 16458 43.76923077 11.25588885 2021-05-12 04:21:29 Toscana, Italy
1164992 2021-05-10 Italy Toscana     233730 6402 210180 17148 43.76923077 11.25588885 2021-05-11 04:20:41 Toscana, Italy
1168978 2021-05-09 Italy Toscana     233249 6382 209414 17453 43.76923077 11.25588885 2021-05-10 04:20:38 Toscana, Italy
1659765 2021-05-08 Italy Toscana     232536 6373 208320 17843 43.76923077 11.25588885 2021-05-09 04:20:35 Toscana, Italy
799863 2021-05-07 Italy Toscana     231860 6352 207361 18147 43.76923077 11.25588885 2021-05-08 04:21:04 Toscana, Italy
1219378 2021-05-06 Italy Toscana     231145 6341 206136 18668 43.76923077 11.25588885 2021-05-07 04:20:40 Toscana, Italy
415958 2021-05-05 Italy Toscana     230284 6308 205040 18936 43.76923077 11.25588885 2021-05-06 04:20:38 Toscana, Italy
673979 2021-05-04 Italy Toscana     229540 6273 203731 19536 43.76923077 11.25588885 2021-05-05 04:20:43 Toscana, Italy
1088003 2021-05-03 Italy Toscana     229037 6248 202799 19990 43.76923077 11.25588885 2021-05-04 04:20:34 Toscana, Italy
1727221 2021-05-02 Italy Toscana     228467 6219 201958 20290 43.76923077 11.25588885 2021-05-03 04:20:39 Toscana, Italy
1084017 2021-05-01 Italy Toscana     227737 6202 201136 20399 43.76923077 11.25588885 2021-05-02 04:20:48 Toscana, Italy
1388545 2021-04-30 Italy Toscana     226842 6184 199989 20669 43.76923077 11.25588885 2021-05-01 04:20:47 Toscana, Italy
38364 2021-04-29 Italy Toscana     225972 6155 198690 21127 43.76923077 11.25588885 2021-04-30 04:21:03 Toscana, Italy
11937 2021-04-28 Italy Toscana     224920 6128 197525 21267 43.76923077 11.25588885 2021-04-29 04:20:55 Toscana, Italy
853320 2021-04-27 Italy Toscana     224073 6096 196211 21766 43.76923077 11.25588885 2021-04-28 04:20:32 Toscana, Italy
1063908 2021-04-26 Italy Toscana     223551 6062 194818 22671 43.76923077 11.25588885 2021-04-27 04:20:52 Toscana, Italy
1476158 2021-04-25 Italy Toscana     222814 6040 193928 22846 43.76923077 11.25588885 2021-04-26 04:21:04 Toscana, Italy
743779 2021-04-24 Italy Toscana     221859 6018 192794 23047 43.76923077 11.25588885 2021-04-25 04:20:32 Toscana, Italy
1430578 2021-04-23 Italy Toscana     220973 5992 191474 23507 43.76923077 11.25588885 2021-04-24 04:20:38 Toscana, Italy
96407 2021-04-22 Italy Toscana     219970 5975 190006 23989 43.76923077 11.25588885 2021-04-23 04:20:52 Toscana, Italy
849334 2021-04-21 Italy Toscana     218929 5942 188514 24473 43.76923077 11.25588885 2021-04-22 04:20:53 Toscana, Italy
826952 2021-04-20 Italy Toscana     217993 5911 187011 25071 43.76923077 11.25588885 2021-04-21 04:21:14 Toscana, Italy
770663 2021-04-19 Italy Toscana     217349 5883 185753 25713 43.76923077 11.25588885 2021-04-20 04:20:41 Toscana, Italy
1415972 2021-04-18 Italy Toscana     216578 5852 184655 26071 43.76923077 11.25588885 2021-04-19 04:20:57 Toscana, Italy
984949 2021-04-17 Italy Toscana     215620 5824 183426 26370 43.76923077 11.25588885 2021-04-18 04:20:41 Toscana, Italy
238012 2021-04-16 Italy Toscana     214470 5804 182110 26556 43.76923077 11.25588885 2021-04-17 04:20:40 Toscana, Italy
579741 2021-04-15 Italy Toscana     213231 5784 180661 26786 43.76923077 11.25588885 2021-04-16 04:20:46 Toscana, Italy
1266369 2021-04-14 Italy Toscana     212025 5758 179190 27077 43.76923077 11.25588885 2021-04-15 04:20:54 Toscana, Italy
701902 2021-04-13 Italy Toscana     210857 5726 177717 27414 43.76923077 11.25588885 2021-04-14 04:20:41 Toscana, Italy
1671015 2021-04-12 Italy Toscana     209923 5692 176600 27631 43.76923077 11.25588885 2021-04-13 04:20:37 Toscana, Italy
784720 2021-04-11 Italy Toscana     209208 5662 175788 27758 43.76923077 11.25588885 2021-04-12 04:21:00 Toscana, Italy
1392531 2021-04-10 Italy Toscana     207986 5632 174442 27912 43.76923077 11.25588885 2021-04-11 04:20:56 Toscana, Italy
965962 2021-04-09 Italy Toscana     206809 5604 173045 28160 43.76923077 11.25588885 2021-04-10 04:20:59 Toscana, Italy
689966 2021-04-08 Italy Toscana     205500 5571 171726 28203 43.76923077 11.25588885 2021-04-09 04:21:13 Toscana, Italy
1277418 2021-04-07 Italy Toscana     204347 5551 170444 28352 43.76923077 11.25588885 2021-04-08 04:21:13 Toscana, Italy
88437 2021-04-06 Italy Toscana     203410 5510 168821 29079 43.76923077 11.25588885 2021-04-07 04:20:53 Toscana, Italy
122819 2021-04-05 Italy Toscana     202725 5478 168023 29224 43.76923077 11.25588885 2021-04-06 04:20:32 Toscana, Italy
73321 2021-04-04 Italy Toscana     201744 5454 167062 29228 43.76923077 11.25588885 2021-04-05 04:20:35 Toscana, Italy
791937 2021-04-03 Italy Toscana     200118 5428 165981 28709 43.76923077 11.25588885 2021-04-04 04:20:49 Toscana, Italy
1020375 2021-04-02 Italy Toscana     198645 5406 164563 28676 43.76923077 11.25588885 2021-04-03 04:20:44 Toscana, Italy
1350537 2021-04-01 Italy Toscana     197005 5380 163197 28428 43.76923077 11.25588885 2021-04-02 04:20:36 Toscana, Italy
1690923 2021-03-31 Italy Toscana     195374 5348 161919 28107 43.76923077 11.25588885 2021-04-01 04:27:05 Toscana, Italy
873292 2021-03-30 Italy Toscana     193836 5329 160617 27890 43.76923077 11.25588885 2021-03-31 04:26:25 Toscana, Italy
1400339 2021-03-29 Italy Toscana     192656 5297 159469 27890 43.76923077 11.25588885 2021-03-30 04:26:23 Toscana, Italy
1624742 2021-03-28 Italy Toscana     191635 5266 158808 27561 43.76923077 11.25588885 2021-03-29 04:28:35 Toscana, Italy
1472172 2021-03-27 Italy Toscana     190267 5239 157725 27303 43.76923077 11.25588885 2021-03-28 05:28:10 Toscana, Italy
720719 2021-03-26 Italy Toscana     188800 5220 156354 27226 43.76923077 11.25588885 2021-03-27 05:25:04 Toscana, Italy
1617338 2021-03-25 Italy Toscana     187273 5198 155313 26762 43.76923077 11.25588885 2021-03-26 05:26:55 Toscana, Italy
469999 2021-03-24 Italy Toscana     185755 5176 154068 26511 43.76923077 11.25588885 2021-03-25 05:27:00 Toscana, Italy
1585039 2021-03-23 Italy Toscana     184558 5149 152771 26638 43.76923077 11.25588885 2021-03-24 05:25:40 Toscana, Italy
716733 2021-03-22 Italy Toscana     183496 5118 151599 26779 43.76923077 11.25588885 2021-03-23 05:26:18 Toscana, Italy
1675001 2021-03-21 Italy Toscana     182356 5095 150913 26348 43.76923077 11.25588885 2021-03-22 05:25:43 Toscana, Italy
1746940 2021-03-20 Italy Toscana     180998 5059 149888 26051 43.76923077 11.25588885 2021-03-21 05:25:44 Toscana, Italy
230062 2021-03-19 Italy Toscana     179488 5041 148808 25639 43.76923077 11.25588885 2021-03-20 05:25:46 Toscana, Italy
477997 2021-03-18 Italy Toscana     178123 5016 147769 25338 43.76923077 11.25588885 2021-03-19 05:26:09 Toscana, Italy
1426592 2021-03-17 Italy Toscana     176610 4991 146712 24907 43.76923077 11.25588885 2021-03-18 05:26:22 Toscana, Italy
1593180 2021-03-16 Italy Toscana     175335 4970 145470 24895 43.76923077 11.25588885 2021-03-17 05:25:07 Toscana, Italy
1176179 2021-03-15 Italy Toscana     174088 4952 144570 24566 43.76923077 11.25588885 2021-03-16 05:25:13 Toscana, Italy
275864 2021-03-14 Italy Toscana     172982 4941 143776 24265 43.76923077 11.25588885 2021-03-15 05:25:51 Toscana, Italy
1161006 2021-03-13 Italy Toscana     171677 4922 143026 23729 43.76923077 11.25588885 2021-03-14 05:25:37 Toscana, Italy
22513 2021-03-12 Italy Toscana     170351 4902 142255 23194 43.76923077 11.25588885 2021-03-13 05:25:15 Toscana, 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]);