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

407 rows where country_or_region = "Italy" and province_or_state = "Liguria" sorted by day descending

View and edit SQL

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

province_or_state

  • Liguria · 407

country_or_region

  • Italy · 407
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
234901 2021-06-24 Italy Liguria     103382 4349 98824 209 44.41149315 8.9326992 2021-06-25 04:21:33 Liguria, Italy
471849 2021-06-23 Italy Liguria     103372 4349 98809 214 44.41149315 8.9326992 2021-06-24 04:21:55 Liguria, Italy
626907 2021-06-22 Italy Liguria     103169 4348 98596 225 44.41149315 8.9326992 2021-06-23 04:21:46 Liguria, Italy
226927 2021-06-21 Italy Liguria     103159 4347 98569 243 44.41149315 8.9326992 2021-06-22 04:21:34 Liguria, Italy
1472449 2021-06-20 Italy Liguria     103151 4346 98527 278 44.41149315 8.9326992 2021-06-21 04:21:41 Liguria, Italy
1303690 2021-06-19 Italy Liguria     103133 4345 98497 291 44.41149315 8.9326992 2021-06-20 04:21:48 Liguria, Italy
303292 2021-06-18 Italy Liguria     103119 4344 98489 286 44.41149315 8.9326992 2021-06-19 04:22:33 Liguria, Italy
886122 2021-06-17 Italy Liguria     103103 4343 98472 288 44.41149315 8.9326992 2021-06-18 04:22:16 Liguria, Italy
42019 2021-06-16 Italy Liguria     103085 4343 98425 317 44.41149315 8.9326992 2021-06-17 04:22:36 Liguria, Italy
1704841 2021-06-15 Italy Liguria     103064 4343 98337 384 44.41149315 8.9326992 2021-06-16 04:22:32 Liguria, Italy
1661112 2021-06-14 Italy Liguria     103056 4343 98295 418 44.41149315 8.9326992 2021-06-15 04:22:22 Liguria, Italy
319188 2021-06-13 Italy Liguria     103051 4342 98270 439 44.41149315 8.9326992 2021-06-14 04:22:46 Liguria, Italy
618933 2021-06-12 Italy Liguria     103041 4342 98225 474 44.41149315 8.9326992 2021-06-13 04:22:44 Liguria, Italy
591942 2021-06-11 Italy Liguria     103020 4342 98184 494 44.41149315 8.9326992 2021-06-12 04:22:22 Liguria, Italy
272820 2021-06-10 Italy Liguria     103010 4341 98141 528 44.41149315 8.9326992 2021-06-11 04:23:20 Liguria, Italy
1637878 2021-06-09 Italy Liguria     102982 4340 98074 568 44.41149315 8.9326992 2021-06-10 04:23:17 Liguria, Italy
1744491 2021-06-08 Italy Liguria     102962 4337 97982 643 44.41149315 8.9326992 2021-06-09 04:23:31 Liguria, Italy
577034 2021-06-07 Italy Liguria     102941 4334 97894 713 44.41149315 8.9326992 2021-06-08 04:22:35 Liguria, Italy
245897 2021-06-06 Italy Liguria     102934 4331 97818 785 44.41149315 8.9326992 2021-06-07 04:22:51 Liguria, Italy
673874 2021-06-05 Italy Liguria     102898 4330 97755 813 44.41149315 8.9326992 2021-06-06 04:24:03 Liguria, Italy
553137 2021-06-04 Italy Liguria     102875 4330 97688 857 44.41149315 8.9326992 2021-06-05 04:23:03 Liguria, Italy
1460534 2021-06-03 Italy Liguria     102855 4327 97602 926 44.41149315 8.9326992 2021-06-04 04:23:37 Liguria, Italy
1399527 2021-06-02 Italy Liguria     102825 4325 97507 993 44.41149315 8.9326992 2021-06-03 04:23:32 Liguria, Italy
1708874 2021-06-01 Italy Liguria     102780 4324 97416 1040 44.41149315 8.9326992 2021-06-02 04:24:34 Liguria, Italy
19104 2021-05-31 Italy Liguria     102761 4323 97285 1153 44.41149315 8.9326992 2021-06-01 04:23:09 Liguria, Italy
1497497 2021-05-30 Italy Liguria     102718 4322 97220 1176 44.41149315 8.9326992 2021-05-31 03:08:59 Liguria, Italy
622920 2021-05-29 Italy Liguria     102677 4318 97145 1214 44.41149315 8.9326992 2021-05-30 04:20:55 Liguria, Italy
80776 2021-05-28 Italy Liguria     102595 4317 97009 1269 44.41149315 8.9326992 2021-05-29 04:20:41 Liguria, Italy
1426051 2021-05-27 Italy Liguria     102528 4316 96902 1310 44.41149315 8.9326992 2021-05-28 04:20:36 Liguria, Italy
1549019 2021-05-26 Italy Liguria     102479 4314 96764 1401 44.41149315 8.9326992 2021-05-27 04:20:59 Liguria, Italy
1200595 2021-05-25 Italy Liguria     102405 4312 96535 1558 44.41149315 8.9326992 2021-05-26 04:20:35 Liguria, Italy
149588 2021-05-24 Italy Liguria     102358 4308 96243 1807 44.41149315 8.9326992 2021-05-25 04:21:08 Liguria, Italy
689741 2021-05-23 Italy Liguria     102297 4305 96065 1927 44.41149315 8.9326992 2021-05-24 04:20:53 Liguria, Italy
387355 2021-05-22 Italy Liguria     102239 4304 95887 2048 44.41149315 8.9326992 2021-05-23 04:20:51 Liguria, Italy
969670 2021-05-21 Italy Liguria     102179 4303 95715 2161 44.41149315 8.9326992 2021-05-22 04:20:45 Liguria, Italy
57632 2021-05-20 Italy Liguria     102109 4299 95483 2327 44.41149315 8.9326992 2021-05-21 04:20:43 Liguria, Italy
463894 2021-05-19 Italy Liguria     101998 4296 95037 2665 44.41149315 8.9326992 2021-05-20 04:21:05 Liguria, Italy
1275850 2021-05-18 Italy Liguria     101913 4294 94818 2801 44.41149315 8.9326992 2021-05-19 04:20:42 Liguria, Italy
230914 2021-05-17 Italy Liguria     101833 4287 94585 2961 44.41149315 8.9326992 2021-05-18 04:20:33 Liguria, Italy
1159129 2021-05-16 Italy Liguria     101782 4282 94534 2966 44.41149315 8.9326992 2021-05-17 04:20:34 Liguria, Italy
1008685 2021-05-15 Italy Liguria     101702 4278 94307 3117 44.41149315 8.9326992 2021-05-16 04:20:49 Liguria, Italy
804797 2021-05-14 Italy Liguria     101605 4273 94125 3207 44.41149315 8.9326992 2021-05-15 04:20:58 Liguria, Italy
1192625 2021-05-13 Italy Liguria     101467 4267 93953 3247 44.41149315 8.9326992 2021-05-14 04:20:41 Liguria, Italy
685754 2021-05-12 Italy Liguria     101352 4259 93669 3424 44.41149315 8.9326992 2021-05-13 04:20:51 Liguria, Italy
129154 2021-05-11 Italy Liguria     101209 4252 93314 3643 44.41149315 8.9326992 2021-05-12 04:21:29 Liguria, Italy
1257159 2021-05-10 Italy Liguria     101081 4245 92908 3928 44.41149315 8.9326992 2021-05-11 04:20:41 Liguria, Italy
121180 2021-05-09 Italy Liguria     101015 4243 92694 4078 44.41149315 8.9326992 2021-05-10 04:20:38 Liguria, Italy
88750 2021-05-08 Italy Liguria     100863 4241 92634 3988 44.41149315 8.9326992 2021-05-09 04:20:35 Liguria, Italy
522248 2021-05-07 Italy Liguria     100661 4236 92144 4281 44.41149315 8.9326992 2021-05-08 04:21:04 Liguria, Italy
1684872 2021-05-06 Italy Liguria     100528 4227 91756 4545 44.41149315 8.9326992 2021-05-07 04:20:40 Liguria, Italy
23091 2021-05-05 Italy Liguria     100327 4219 91406 4702 44.41149315 8.9326992 2021-05-06 04:20:38 Liguria, Italy
1331033 2021-05-04 Italy Liguria     100133 4210 90886 5037 44.41149315 8.9326992 2021-05-05 04:20:43 Liguria, Italy
1035620 2021-05-03 Italy Liguria     99972 4200 90405 5367 44.41149315 8.9326992 2021-05-04 04:20:34 Liguria, Italy
913810 2021-05-02 Italy Liguria     99837 4194 90046 5597 44.41149315 8.9326992 2021-05-03 04:20:39 Liguria, Italy
1756776 2021-05-01 Italy Liguria     99635 4189 89913 5533 44.41149315 8.9326992 2021-05-02 04:20:48 Liguria, Italy
1456547 2021-04-30 Italy Liguria     99416 4183 89762 5471 44.41149315 8.9326992 2021-05-01 04:20:47 Liguria, Italy
1614361 2021-04-29 Italy Liguria     99140 4172 89463 5505 44.41149315 8.9326992 2021-04-30 04:21:03 Liguria, Italy
483760 2021-04-28 Italy Liguria     98839 4163 89050 5626 44.41149315 8.9326992 2021-04-29 04:20:55 Liguria, Italy
334798 2021-04-27 Italy Liguria     98571 4154 88589 5828 44.41149315 8.9326992 2021-04-28 04:20:32 Liguria, Italy
1357843 2021-04-26 Italy Liguria     98354 4143 88143 6068 44.41149315 8.9326992 2021-04-27 04:20:52 Liguria, Italy
495799 2021-04-25 Italy Liguria     98154 4136 87893 6125 44.41149315 8.9326992 2021-04-26 04:21:04 Liguria, Italy
1112398 2021-04-24 Italy Liguria     97929 4129 87624 6176 44.41149315 8.9326992 2021-04-25 04:20:32 Liguria, Italy
487747 2021-04-23 Italy Liguria     97650 4119 87265 6266 44.41149315 8.9326992 2021-04-24 04:20:38 Liguria, Italy
1170132 2021-04-22 Italy Liguria     97280 4109 86962 6209 44.41149315 8.9326992 2021-04-23 04:20:52 Liguria, Italy
1403603 2021-04-21 Italy Liguria     96949 4103 86566 6280 44.41149315 8.9326992 2021-04-22 04:20:53 Liguria, Italy
1712861 2021-04-20 Italy Liguria     96683 4090 86110 6483 44.41149315 8.9326992 2021-04-21 04:21:14 Liguria, Italy
606990 2021-04-19 Italy Liguria     96391 4079 85613 6699 44.41149315 8.9326992 2021-04-20 04:20:41 Liguria, Italy
917797 2021-04-18 Italy Liguria     96189 4072 85189 6928 44.41149315 8.9326992 2021-04-19 04:20:57 Liguria, Italy
1319108 2021-04-17 Italy Liguria     95930 4067 84894 6969 44.41149315 8.9326992 2021-04-18 04:20:41 Liguria, Italy
988800 2021-04-16 Italy Liguria     95609 4053 84557 6999 44.41149315 8.9326992 2021-04-17 04:20:40 Liguria, Italy
379904 2021-04-15 Italy Liguria     95286 4046 84293 6947 44.41149315 8.9326992 2021-04-16 04:20:46 Liguria, Italy
905854 2021-04-14 Italy Liguria     94879 4032 83653 7194 44.41149315 8.9326992 2021-04-15 04:20:54 Liguria, Italy
1079081 2021-04-13 Italy Liguria     94469 4018 82986 7465 44.41149315 8.9326992 2021-04-14 04:20:41 Liguria, Italy
354317 2021-04-12 Italy Liguria     94238 4010 82495 7733 44.41149315 8.9326992 2021-04-13 04:20:37 Liguria, Italy
1180766 2021-04-11 Italy Liguria     93932 4003 82153 7776 44.41149315 8.9326992 2021-04-12 04:21:00 Liguria, Italy
1188638 2021-04-10 Italy Liguria     93597 3971 81824 7802 44.41149315 8.9326992 2021-04-11 04:20:56 Liguria, Italy
1692824 2021-04-09 Italy Liguria     93187 3950 81622 7615 44.41149315 8.9326992 2021-04-10 04:20:59 Liguria, Italy
569063 2021-04-08 Italy Liguria     92766 3935 81103 7728 44.41149315 8.9326992 2021-04-09 04:21:13 Liguria, Italy
1345882 2021-04-07 Italy Liguria     92379 3922 80485 7972 44.41149315 8.9326992 2021-04-08 04:21:13 Liguria, Italy
350250 2021-04-06 Italy Liguria     91954 3910 80056 7988 44.41149315 8.9326992 2021-04-07 04:20:53 Liguria, Italy
1043575 2021-04-05 Italy Liguria     91780 3905 80145 7730 44.41149315 8.9326992 2021-04-06 04:20:32 Liguria, Italy
214895 2021-04-04 Italy Liguria     91378 3904 79917 7557 44.41149315 8.9326992 2021-04-05 04:20:35 Liguria, Italy
1700854 2021-04-03 Italy Liguria     90966 3898 79456 7612 44.41149315 8.9326992 2021-04-04 04:20:49 Liguria, Italy
953543 2021-04-02 Italy Liguria     90506 3897 79216 7393 44.41149315 8.9326992 2021-04-03 04:20:44 Liguria, Italy
125167 2021-04-01 Italy Liguria     90034 3889 78867 7278 44.41149315 8.9326992 2021-04-02 04:20:36 Liguria, Italy
1516059 2021-03-31 Italy Liguria     89324 3879 78350 7095 44.41149315 8.9326992 2021-04-01 04:27:05 Liguria, Italy
1716848 2021-03-30 Italy Liguria     88941 3865 78089 6987 44.41149315 8.9326992 2021-03-31 04:26:25 Liguria, Italy
732835 2021-03-29 Italy Liguria     88452 3851 77602 6999 44.41149315 8.9326992 2021-03-30 04:26:23 Liguria, Italy
422139 2021-03-28 Italy Liguria     88115 3847 77517 6751 44.41149315 8.9326992 2021-03-29 04:28:35 Liguria, Italy
1732530 2021-03-27 Italy Liguria     87723 3841 77223 6659 44.41149315 8.9326992 2021-03-28 05:28:10 Liguria, Italy
402973 2021-03-26 Italy Liguria     87194 3833 77035 6326 44.41149315 8.9326992 2021-03-27 05:25:04 Liguria, Italy
1353856 2021-03-25 Italy Liguria     86707 3827 76725 6155 44.41149315 8.9326992 2021-03-26 05:26:55 Liguria, Italy
507546 2021-03-24 Italy Liguria     86213 3817 76603 5793 44.41149315 8.9326992 2021-03-25 05:27:00 Liguria, Italy
1590463 2021-03-23 Italy Liguria     85793 3809 76029 5955 44.41149315 8.9326992 2021-03-24 05:25:40 Liguria, Italy
839855 2021-03-22 Italy Liguria     85433 3803 75606 6024 44.41149315 8.9326992 2021-03-23 05:26:18 Liguria, Italy
721095 2021-03-21 Italy Liguria     85139 3795 75393 5951 44.41149315 8.9326992 2021-03-22 05:25:43 Liguria, Italy
442238 2021-03-20 Italy Liguria     84759 3790 75053 5916 44.41149315 8.9326992 2021-03-21 05:25:44 Liguria, Italy
545180 2021-03-19 Italy Liguria     84301 3785 74723 5793 44.41149315 8.9326992 2021-03-20 05:25:46 Liguria, Italy
1349869 2021-03-18 Italy Liguria     83874 3780 74082 6012 44.41149315 8.9326992 2021-03-19 05:26:09 Liguria, Italy
84763 2021-03-17 Italy Liguria     83550 3769 73614 6167 44.41149315 8.9326992 2021-03-18 05:26:22 Liguria, 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]);