⚠️ 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 = "Sicilia" sorted by day descending

View and edit SQL

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

province_or_state

  • Sicilia · 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
168454 2021-06-19 Italy Sicilia     230452 5936 218901 5615 38.11569725 13.362356699999998 2021-06-20 04:21:48 Sicilia, Italy
685979 2021-06-18 Italy Sicilia     230269 5931 218636 5702 38.11569725 13.362356699999998 2021-06-19 04:22:33 Sicilia, Italy
958036 2021-06-17 Italy Sicilia     230099 5928 218270 5901 38.11569725 13.362356699999998 2021-06-18 04:22:16 Sicilia, Italy
1281403 2021-06-16 Italy Sicilia     229871 5928 217940 6003 38.11569725 13.362356699999998 2021-06-17 04:22:36 Sicilia, Italy
681993 2021-06-15 Italy Sicilia     229703 5920 217416 6367 38.11569725 13.362356699999998 2021-06-16 04:22:32 Sicilia, Italy
372547 2021-06-14 Italy Sicilia     229503 5912 216960 6631 38.11569725 13.362356699999998 2021-06-15 04:22:22 Sicilia, Italy
1223363 2021-06-13 Italy Sicilia     229340 5905 216713 6722 38.11569725 13.362356699999998 2021-06-14 04:22:46 Sicilia, Italy
80644 2021-06-12 Italy Sicilia     229157 5900 216559 6698 38.11569725 13.362356699999998 2021-06-13 04:22:44 Sicilia, Italy
969947 2021-06-11 Italy Sicilia     228894 5897 216133 6864 38.11569725 13.362356699999998 2021-06-12 04:22:22 Sicilia, Italy
1438520 2021-06-10 Italy Sicilia     228621 5893 215367 7361 38.11569725 13.362356699999998 2021-06-11 04:23:20 Sicilia, Italy
1157019 2021-06-09 Italy Sicilia     228337 5890 215125 7322 38.11569725 13.362356699999998 2021-06-10 04:23:17 Sicilia, Italy
1231335 2021-06-08 Italy Sicilia     228017 5888 214423 7706 38.11569725 13.362356699999998 2021-06-09 04:23:31 Sicilia, Italy
360331 2021-06-07 Italy Sicilia     227680 5876 213921 7883 38.11569725 13.362356699999998 2021-06-08 04:22:35 Sicilia, Italy
1075959 2021-06-06 Italy Sicilia     227524 5873 213680 7971 38.11569725 13.362356699999998 2021-06-07 04:22:51 Sicilia, Italy
1613351 2021-06-05 Italy Sicilia     227249 5871 213483 7895 38.11569725 13.362356699999998 2021-06-06 04:24:03 Sicilia, Italy
1125637 2021-06-04 Italy Sicilia     227015 5863 212834 8318 38.11569725 13.362356699999998 2021-06-05 04:23:03 Sicilia, Italy
318093 2021-06-03 Italy Sicilia     226678 5858 212057 8763 38.11569725 13.362356699999998 2021-06-04 04:23:37 Sicilia, Italy
1133606 2021-06-02 Italy Sicilia     226424 5855 211871 8698 38.11569725 13.362356699999998 2021-06-03 04:23:32 Sicilia, Italy
291783 2021-06-01 Italy Sicilia     226135 5839 210808 9488 38.11569725 13.362356699999998 2021-06-02 04:24:34 Sicilia, Italy
1651734 2021-05-31 Italy Sicilia     225809 5827 210050 9932 38.11569725 13.362356699999998 2021-06-01 04:23:09 Sicilia, Italy
980962 2021-05-30 Italy Sicilia     225551 5819 209849 9883 38.11569725 13.362356699999998 2021-05-31 03:08:59 Sicilia, Italy
841343 2021-05-29 Italy Sicilia     225203 5814 209401 9988 38.11569725 13.362356699999998 2021-05-30 04:20:55 Sicilia, Italy
697915 2021-05-28 Italy Sicilia     224818 5807 208396 10615 38.11569725 13.362356699999998 2021-05-29 04:20:41 Sicilia, Italy
1369416 2021-05-27 Italy Sicilia     224400 5798 207262 11340 38.11569725 13.362356699999998 2021-05-28 04:20:36 Sicilia, Italy
1292501 2021-05-26 Italy Sicilia     224017 5778 206524 11715 38.11569725 13.362356699999998 2021-05-27 04:20:59 Sicilia, Italy
602872 2021-05-25 Italy Sicilia     223642 5758 205280 12604 38.11569725 13.362356699999998 2021-05-26 04:20:35 Sicilia, Italy
1365430 2021-05-24 Italy Sicilia     223270 5747 204507 13016 38.11569725 13.362356699999998 2021-05-25 04:21:08 Sicilia, Italy
419943 2021-05-23 Italy Sicilia     222892 5739 204225 12928 38.11569725 13.362356699999998 2021-05-24 04:20:53 Sicilia, Italy
54282 2021-05-22 Italy Sicilia     222654 5737 203650 13267 38.11569725 13.362356699999998 2021-05-23 04:20:51 Sicilia, Italy
368561 2021-05-21 Italy Sicilia     222304 5720 202569 14015 38.11569725 13.362356699999998 2021-05-22 04:20:45 Sicilia, Italy
1024360 2021-05-20 Italy Sicilia     221811 5709 201089 15013 38.11569725 13.362356699999998 2021-05-21 04:20:43 Sicilia, Italy
1678986 2021-05-19 Italy Sicilia     221368 5699 200401 15268 38.11569725 13.362356699999998 2021-05-20 04:21:05 Sicilia, Italy
64973 2021-05-18 Italy Sicilia     220765 5689 198783 16293 38.11569725 13.362356699999998 2021-05-19 04:20:42 Sicilia, Italy
1243045 2021-05-17 Italy Sicilia     220354 5667 197991 16696 38.11569725 13.362356699999998 2021-05-18 04:20:33 Sicilia, Italy
1067893 2021-05-16 Italy Sicilia     220055 5663 197233 17159 38.11569725 13.362356699999998 2021-05-17 04:20:34 Sicilia, Italy
505021 2021-05-15 Italy Sicilia     219650 5660 196477 17513 38.11569725 13.362356699999998 2021-05-16 04:20:49 Sicilia, Italy
892626 2021-05-14 Italy Sicilia     219093 5650 195434 18009 38.11569725 13.362356699999998 2021-05-15 04:20:58 Sicilia, Italy
531961 2021-05-13 Italy Sicilia     218520 5633 193722 19165 38.11569725 13.362356699999998 2021-05-14 04:20:41 Sicilia, Italy
1719248 2021-05-12 Italy Sicilia     217917 5614 192268 20035 38.11569725 13.362356699999998 2021-05-13 04:20:51 Sicilia, Italy
1723234 2021-05-11 Italy Sicilia     217310 5592 189556 22162 38.11569725 13.362356699999998 2021-05-12 04:21:29 Sicilia, Italy
1164991 2021-05-10 Italy Sicilia     216416 5566 188620 22230 38.11569725 13.362356699999998 2021-05-11 04:20:41 Sicilia, Italy
1168977 2021-05-09 Italy Sicilia     215827 5560 188122 22145 38.11569725 13.362356699999998 2021-05-10 04:20:38 Sicilia, Italy
1659764 2021-05-08 Italy Sicilia     215333 5546 187157 22630 38.11569725 13.362356699999998 2021-05-09 04:20:35 Sicilia, Italy
799862 2021-05-07 Italy Sicilia     214482 5527 185625 23330 38.11569725 13.362356699999998 2021-05-08 04:21:04 Sicilia, Italy
1219377 2021-05-06 Italy Sicilia     213879 5516 184485 23878 38.11569725 13.362356699999998 2021-05-07 04:20:40 Sicilia, Italy
415957 2021-05-05 Italy Sicilia     212677 5492 182656 24529 38.11569725 13.362356699999998 2021-05-06 04:20:38 Sicilia, Italy
673978 2021-05-04 Italy Sicilia     211895 5468 181604 24823 38.11569725 13.362356699999998 2021-05-05 04:20:43 Sicilia, Italy
1088002 2021-05-03 Italy Sicilia     210993 5443 180595 24955 38.11569725 13.362356699999998 2021-05-04 04:20:34 Sicilia, Italy
1727220 2021-05-02 Italy Sicilia     210259 5423 180055 24781 38.11569725 13.362356699999998 2021-05-03 04:20:39 Sicilia, Italy
1084016 2021-05-01 Italy Sicilia     209487 5420 179294 24773 38.11569725 13.362356699999998 2021-05-02 04:20:48 Sicilia, Italy
1388544 2021-04-30 Italy Sicilia     208487 5410 178181 24896 38.11569725 13.362356699999998 2021-05-01 04:20:47 Sicilia, Italy
38363 2021-04-29 Italy Sicilia     207626 5391 176991 25244 38.11569725 13.362356699999998 2021-04-30 04:21:03 Sicilia, Italy
11936 2021-04-28 Italy Sicilia     206565 5368 175825 25372 38.11569725 13.362356699999998 2021-04-29 04:20:55 Sicilia, Italy
853319 2021-04-27 Italy Sicilia     205585 5338 174162 26085 38.11569725 13.362356699999998 2021-04-28 04:20:32 Sicilia, Italy
1063907 2021-04-26 Italy Sicilia     204645 5305 173249 26091 38.11569725 13.362356699999998 2021-04-27 04:20:52 Sicilia, Italy
1476157 2021-04-25 Italy Sicilia     203576 5292 172774 25510 38.11569725 13.362356699999998 2021-04-26 04:21:04 Sicilia, Italy
743778 2021-04-24 Italy Sicilia     202515 5286 172018 25211 38.11569725 13.362356699999998 2021-04-25 04:20:32 Sicilia, Italy
1430577 2021-04-23 Italy Sicilia     201420 5265 170871 25284 38.11569725 13.362356699999998 2021-04-24 04:20:38 Sicilia, Italy
96406 2021-04-22 Italy Sicilia     200490 5241 169621 25628 38.11569725 13.362356699999998 2021-04-23 04:20:52 Sicilia, Italy
849333 2021-04-21 Italy Sicilia     199078 5218 168672 25188 38.11569725 13.362356699999998 2021-04-22 04:20:53 Sicilia, Italy
826951 2021-04-20 Italy Sicilia     197790 5208 167683 24899 38.11569725 13.362356699999998 2021-04-21 04:21:14 Sicilia, Italy
770662 2021-04-19 Italy Sicilia     196642 5172 165148 26322 38.11569725 13.362356699999998 2021-04-20 04:20:41 Sicilia, Italy
1415971 2021-04-18 Italy Sicilia     195519 5162 164599 25758 38.11569725 13.362356699999998 2021-04-19 04:20:57 Sicilia, Italy
984948 2021-04-17 Italy Sicilia     194644 5152 164015 25477 38.11569725 13.362356699999998 2021-04-18 04:20:41 Sicilia, Italy
238011 2021-04-16 Italy Sicilia     193343 5128 163340 24875 38.11569725 13.362356699999998 2021-04-17 04:20:40 Sicilia, Italy
579740 2021-04-15 Italy Sicilia     191973 5107 162092 24774 38.11569725 13.362356699999998 2021-04-16 04:20:46 Sicilia, Italy
1266368 2021-04-14 Italy Sicilia     190523 5101 161290 24132 38.11569725 13.362356699999998 2021-04-15 04:20:54 Sicilia, Italy
701901 2021-04-13 Italy Sicilia     188981 5068 159242 24671 38.11569725 13.362356699999998 2021-04-14 04:20:41 Sicilia, Italy
1671014 2021-04-12 Italy Sicilia     187597 5058 158830 23709 38.11569725 13.362356699999998 2021-04-13 04:20:37 Sicilia, Italy
784719 2021-04-11 Italy Sicilia     186487 5038 158478 22971 38.11569725 13.362356699999998 2021-04-12 04:21:00 Sicilia, Italy
1392530 2021-04-10 Italy Sicilia     185367 5029 158147 22191 38.11569725 13.362356699999998 2021-04-11 04:20:56 Sicilia, Italy
965961 2021-04-09 Italy Sicilia     184138 5015 157371 21752 38.11569725 13.362356699999998 2021-04-10 04:20:59 Sicilia, Italy
689965 2021-04-08 Italy Sicilia     182633 4757 151349 26527 38.11569725 13.362356699999998 2021-04-09 04:21:13 Sicilia, Italy
1277417 2021-04-07 Italy Sicilia     181346 4746 151254 25346 38.11569725 13.362356699999998 2021-04-08 04:21:13 Sicilia, Italy
88436 2021-04-06 Italy Sicilia     180348 4730 151166 24452 38.11569725 13.362356699999998 2021-04-07 04:20:53 Sicilia, Italy
122818 2021-04-05 Italy Sicilia     179565 4717 151143 23705 38.11569725 13.362356699999998 2021-04-06 04:20:32 Sicilia, Italy
73320 2021-04-04 Italy Sicilia     178656 4697 151107 22852 38.11569725 13.362356699999998 2021-04-05 04:20:35 Sicilia, Italy
791936 2021-04-03 Italy Sicilia     177641 4676 151040 21925 38.11569725 13.362356699999998 2021-04-04 04:20:49 Sicilia, Italy
1020374 2021-04-02 Italy Sicilia     176627 4662 150954 21011 38.11569725 13.362356699999998 2021-04-03 04:20:44 Sicilia, Italy
1350536 2021-04-01 Italy Sicilia     175405 4647 150888 19870 38.11569725 13.362356699999998 2021-04-02 04:20:36 Sicilia, Italy
1690922 2021-03-31 Italy Sicilia     175354 4628 150806 19920 38.11569725 13.362356699999998 2021-04-01 04:27:05 Sicilia, Italy
873291 2021-03-30 Italy Sicilia     172450 4607 150426 17417 38.11569725 13.362356699999998 2021-03-31 04:26:25 Sicilia, Italy
1400338 2021-03-29 Italy Sicilia     172450 4607 150426 17417 38.11569725 13.362356699999998 2021-03-30 04:26:23 Sicilia, Italy
1624741 2021-03-28 Italy Sicilia     171651 4583 150068 17000 38.11569725 13.362356699999998 2021-03-29 04:28:35 Sicilia, Italy
1472171 2021-03-27 Italy Sicilia     170698 4558 149728 16412 38.11569725 13.362356699999998 2021-03-28 05:28:10 Sicilia, Italy
720718 2021-03-26 Italy Sicilia     169808 4535 148870 16403 38.11569725 13.362356699999998 2021-03-27 05:25:04 Sicilia, Italy
1617337 2021-03-25 Italy Sicilia     168916 4513 148409 15994 38.11569725 13.362356699999998 2021-03-26 05:26:55 Sicilia, Italy
469998 2021-03-24 Italy Sicilia     168021 4493 147141 16387 38.11569725 13.362356699999998 2021-03-25 05:27:00 Sicilia, Italy
1585038 2021-03-23 Italy Sicilia     167256 4471 146296 16489 38.11569725 13.362356699999998 2021-03-24 05:25:40 Sicilia, Italy
716732 2021-03-22 Italy Sicilia     166505 4451 145436 16618 38.11569725 13.362356699999998 2021-03-23 05:26:18 Sicilia, Italy
1675000 2021-03-21 Italy Sicilia     165839 4430 145217 16192 38.11569725 13.362356699999998 2021-03-22 05:25:43 Sicilia, Italy
1746939 2021-03-20 Italy Sicilia     165140 4422 144985 15733 38.11569725 13.362356699999998 2021-03-21 05:25:44 Sicilia, Italy
230061 2021-03-19 Italy Sicilia     164358 4412 144162 15784 38.11569725 13.362356699999998 2021-03-20 05:25:46 Sicilia, Italy
477996 2021-03-18 Italy Sicilia     163499 4397 143641 15461 38.11569725 13.362356699999998 2021-03-19 05:26:09 Sicilia, Italy
1426591 2021-03-17 Italy Sicilia     162710 4383 143362 14965 38.11569725 13.362356699999998 2021-03-18 05:26:22 Sicilia, Italy
1593179 2021-03-16 Italy Sicilia     161928 4371 142781 14776 38.11569725 13.362356699999998 2021-03-17 05:25:07 Sicilia, Italy
1176178 2021-03-15 Italy Sicilia     161330 4358 142216 14756 38.11569725 13.362356699999998 2021-03-16 05:25:13 Sicilia, Italy
275863 2021-03-14 Italy Sicilia     160807 4344 142140 14323 38.11569725 13.362356699999998 2021-03-15 05:25:51 Sicilia, Italy
1161005 2021-03-13 Italy Sicilia     160194 4331 141993 13870 38.11569725 13.362356699999998 2021-03-14 05:25:37 Sicilia, Italy
22512 2021-03-12 Italy Sicilia     159544 4318 141430 13796 38.11569725 13.362356699999998 2021-03-13 05:25:15 Sicilia, 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]);