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

View and edit SQL

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

province_or_state

  • Sardegna · 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
168453 2021-06-19 Italy Sardegna     57109 1485 44027 11597 39.21531192 9.110616306 2021-06-20 04:21:48 Sardegna, Italy
685978 2021-06-18 Italy Sardegna     57096 1485 44005 11606 39.21531192 9.110616306 2021-06-19 04:22:33 Sardegna, Italy
958035 2021-06-17 Italy Sardegna     57088 1485 43960 11643 39.21531192 9.110616306 2021-06-18 04:22:16 Sardegna, Italy
1281402 2021-06-16 Italy Sardegna     57085 1485 43836 11764 39.21531192 9.110616306 2021-06-17 04:22:36 Sardegna, Italy
681992 2021-06-15 Italy Sardegna     57061 1484 43710 11867 39.21531192 9.110616306 2021-06-16 04:22:32 Sardegna, Italy
372546 2021-06-14 Italy Sardegna     57039 1484 43583 11972 39.21531192 9.110616306 2021-06-15 04:22:22 Sardegna, Italy
1223362 2021-06-13 Italy Sardegna     57008 1484 43473 12051 39.21531192 9.110616306 2021-06-14 04:22:46 Sardegna, Italy
80643 2021-06-12 Italy Sardegna     56997 1483 43443 12071 39.21531192 9.110616306 2021-06-13 04:22:44 Sardegna, Italy
969946 2021-06-11 Italy Sardegna     56977 1483 43421 12073 39.21531192 9.110616306 2021-06-12 04:22:22 Sardegna, Italy
1438519 2021-06-10 Italy Sardegna     56956 1481 43342 12133 39.21531192 9.110616306 2021-06-11 04:23:20 Sardegna, Italy
1157018 2021-06-09 Italy Sardegna     56937 1481 43252 12204 39.21531192 9.110616306 2021-06-10 04:23:17 Sardegna, Italy
1231334 2021-06-08 Italy Sardegna     56900 1479 43148 12273 39.21531192 9.110616306 2021-06-09 04:23:31 Sardegna, Italy
360330 2021-06-07 Italy Sardegna     56886 1476 42986 12424 39.21531192 9.110616306 2021-06-08 04:22:35 Sardegna, Italy
1075958 2021-06-06 Italy Sardegna     56877 1473 42927 12477 39.21531192 9.110616306 2021-06-07 04:22:51 Sardegna, Italy
1613350 2021-06-05 Italy Sardegna     56846 1472 42891 12483 39.21531192 9.110616306 2021-06-06 04:24:03 Sardegna, Italy
1125636 2021-06-04 Italy Sardegna     56816 1471 42823 12522 39.21531192 9.110616306 2021-06-05 04:23:03 Sardegna, Italy
318092 2021-06-03 Italy Sardegna     56768 1468 42746 12554 39.21531192 9.110616306 2021-06-04 04:23:37 Sardegna, Italy
1133605 2021-06-02 Italy Sardegna     56735 1465 42646 12624 39.21531192 9.110616306 2021-06-03 04:23:32 Sardegna, Italy
291782 2021-06-01 Italy Sardegna     56695 1465 42570 12660 39.21531192 9.110616306 2021-06-02 04:24:34 Sardegna, Italy
1651733 2021-05-31 Italy Sardegna     56659 1464 42468 12727 39.21531192 9.110616306 2021-06-01 04:23:09 Sardegna, Italy
980961 2021-05-30 Italy Sardegna     56643 1461 42398 12784 39.21531192 9.110616306 2021-05-31 03:08:59 Sardegna, Italy
841342 2021-05-29 Italy Sardegna     56613 1460 42350 12803 39.21531192 9.110616306 2021-05-30 04:20:55 Sardegna, Italy
697914 2021-05-28 Italy Sardegna     56591 1459 42269 12863 39.21531192 9.110616306 2021-05-29 04:20:41 Sardegna, Italy
1369415 2021-05-27 Italy Sardegna     56539 1456 42134 12949 39.21531192 9.110616306 2021-05-28 04:20:36 Sardegna, Italy
1292500 2021-05-26 Italy Sardegna     56511 1453 41985 13073 39.21531192 9.110616306 2021-05-27 04:20:59 Sardegna, Italy
602871 2021-05-25 Italy Sardegna     56477 1449 41847 13181 39.21531192 9.110616306 2021-05-26 04:20:35 Sardegna, Italy
1365429 2021-05-24 Italy Sardegna     56449 1448 41678 13323 39.21531192 9.110616306 2021-05-25 04:21:08 Sardegna, Italy
419942 2021-05-23 Italy Sardegna     56429 1446 41559 13424 39.21531192 9.110616306 2021-05-24 04:20:53 Sardegna, Italy
54281 2021-05-22 Italy Sardegna     56409 1446 41479 13484 39.21531192 9.110616306 2021-05-23 04:20:51 Sardegna, Italy
368560 2021-05-21 Italy Sardegna     56374 1445 41389 13540 39.21531192 9.110616306 2021-05-22 04:20:45 Sardegna, Italy
1024359 2021-05-20 Italy Sardegna     56332 1442 41221 13669 39.21531192 9.110616306 2021-05-21 04:20:43 Sardegna, Italy
1678985 2021-05-19 Italy Sardegna     56285 1442 41074 13769 39.21531192 9.110616306 2021-05-20 04:21:05 Sardegna, Italy
64972 2021-05-18 Italy Sardegna     56216 1438 40784 13994 39.21531192 9.110616306 2021-05-19 04:20:42 Sardegna, Italy
1243044 2021-05-17 Italy Sardegna     56155 1437 40477 14241 39.21531192 9.110616306 2021-05-18 04:20:33 Sardegna, Italy
1067892 2021-05-16 Italy Sardegna     56132 1433 40298 14401 39.21531192 9.110616306 2021-05-17 04:20:34 Sardegna, Italy
505020 2021-05-15 Italy Sardegna     56099 1433 40207 14459 39.21531192 9.110616306 2021-05-16 04:20:49 Sardegna, Italy
892625 2021-05-14 Italy Sardegna     56032 1430 40052 14550 39.21531192 9.110616306 2021-05-15 04:20:58 Sardegna, Italy
531960 2021-05-13 Italy Sardegna     55933 1428 39751 14754 39.21531192 9.110616306 2021-05-14 04:20:41 Sardegna, Italy
1719247 2021-05-12 Italy Sardegna     55861 1427 39482 14952 39.21531192 9.110616306 2021-05-13 04:20:51 Sardegna, Italy
1723233 2021-05-11 Italy Sardegna     55765 1422 39113 15230 39.21531192 9.110616306 2021-05-12 04:21:29 Sardegna, Italy
1164990 2021-05-10 Italy Sardegna     55682 1418 38789 15475 39.21531192 9.110616306 2021-05-11 04:20:41 Sardegna, Italy
1168976 2021-05-09 Italy Sardegna     55651 1416 38575 15660 39.21531192 9.110616306 2021-05-10 04:20:38 Sardegna, Italy
1659763 2021-05-08 Italy Sardegna     55597 1414 38447 15736 39.21531192 9.110616306 2021-05-09 04:20:35 Sardegna, Italy
799861 2021-05-07 Italy Sardegna     55438 1409 38264 15765 39.21531192 9.110616306 2021-05-08 04:21:04 Sardegna, Italy
1219376 2021-05-06 Italy Sardegna     55274 1405 37873 15996 39.21531192 9.110616306 2021-05-07 04:20:40 Sardegna, Italy
415956 2021-05-05 Italy Sardegna     55146 1403 37496 16247 39.21531192 9.110616306 2021-05-06 04:20:38 Sardegna, Italy
673977 2021-05-04 Italy Sardegna     54980 1398 37139 16443 39.21531192 9.110616306 2021-05-05 04:20:43 Sardegna, Italy
1088001 2021-05-03 Italy Sardegna     54876 1393 36718 16765 39.21531192 9.110616306 2021-05-04 04:20:34 Sardegna, Italy
1727219 2021-05-02 Italy Sardegna     54815 1389 36534 16892 39.21531192 9.110616306 2021-05-03 04:20:39 Sardegna, Italy
1084015 2021-05-01 Italy Sardegna     54691 1387 36328 16976 39.21531192 9.110616306 2021-05-02 04:20:48 Sardegna, Italy
1388543 2021-04-30 Italy Sardegna     54507 1384 36030 17093 39.21531192 9.110616306 2021-05-01 04:20:47 Sardegna, Italy
38362 2021-04-29 Italy Sardegna     54260 1381 35644 17235 39.21531192 9.110616306 2021-04-30 04:21:03 Sardegna, Italy
11935 2021-04-28 Italy Sardegna     54053 1374 35224 17455 39.21531192 9.110616306 2021-04-29 04:20:55 Sardegna, Italy
853318 2021-04-27 Italy Sardegna     53789 1372 34869 17548 39.21531192 9.110616306 2021-04-28 04:20:32 Sardegna, Italy
1063906 2021-04-26 Italy Sardegna     53590 1363 34467 17760 39.21531192 9.110616306 2021-04-27 04:20:52 Sardegna, Italy
1476156 2021-04-25 Italy Sardegna     53455 1352 34220 17883 39.21531192 9.110616306 2021-04-26 04:21:04 Sardegna, Italy
743777 2021-04-24 Italy Sardegna     53165 1347 34055 17763 39.21531192 9.110616306 2021-04-25 04:20:32 Sardegna, Italy
1430576 2021-04-23 Italy Sardegna     52911 1343 33776 17792 39.21531192 9.110616306 2021-04-24 04:20:38 Sardegna, Italy
96405 2021-04-22 Italy Sardegna     52644 1337 33432 17875 39.21531192 9.110616306 2021-04-23 04:20:52 Sardegna, Italy
849332 2021-04-21 Italy Sardegna     52316 1330 33042 17944 39.21531192 9.110616306 2021-04-22 04:20:53 Sardegna, Italy
826950 2021-04-20 Italy Sardegna     52013 1321 32713 17979 39.21531192 9.110616306 2021-04-21 04:21:14 Sardegna, Italy
770661 2021-04-19 Italy Sardegna     51742 1318 32417 18007 39.21531192 9.110616306 2021-04-20 04:20:41 Sardegna, Italy
1415970 2021-04-18 Italy Sardegna     51543 1315 32162 18066 39.21531192 9.110616306 2021-04-19 04:20:57 Sardegna, Italy
984947 2021-04-17 Italy Sardegna     51192 1313 32035 17844 39.21531192 9.110616306 2021-04-18 04:20:41 Sardegna, Italy
238010 2021-04-16 Italy Sardegna     50872 1307 31824 17741 39.21531192 9.110616306 2021-04-17 04:20:40 Sardegna, Italy
579739 2021-04-15 Italy Sardegna     50524 1302 31580 17642 39.21531192 9.110616306 2021-04-16 04:20:46 Sardegna, Italy
1266367 2021-04-14 Italy Sardegna     50245 1293 31272 17680 39.21531192 9.110616306 2021-04-15 04:20:54 Sardegna, Italy
701900 2021-04-13 Italy Sardegna     49743 1285 31092 17366 39.21531192 9.110616306 2021-04-14 04:20:41 Sardegna, Italy
1671013 2021-04-12 Italy Sardegna     49416 1277 30901 17238 39.21531192 9.110616306 2021-04-13 04:20:37 Sardegna, Italy
784718 2021-04-11 Italy Sardegna     49109 1265 30763 17081 39.21531192 9.110616306 2021-04-12 04:21:00 Sardegna, Italy
1392529 2021-04-10 Italy Sardegna     48740 1261 30685 16794 39.21531192 9.110616306 2021-04-11 04:20:56 Sardegna, Italy
965960 2021-04-09 Italy Sardegna     48315 1259 30607 16449 39.21531192 9.110616306 2021-04-10 04:20:59 Sardegna, Italy
689964 2021-04-08 Italy Sardegna     47935 1255 30481 16199 39.21531192 9.110616306 2021-04-09 04:21:13 Sardegna, Italy
1277416 2021-04-07 Italy Sardegna     47630 1250 30390 15990 39.21531192 9.110616306 2021-04-08 04:21:13 Sardegna, Italy
88435 2021-04-06 Italy Sardegna     47367 1245 30285 15837 39.21531192 9.110616306 2021-04-07 04:20:53 Sardegna, Italy
122817 2021-04-05 Italy Sardegna     47239 1244 30227 15768 39.21531192 9.110616306 2021-04-06 04:20:32 Sardegna, Italy
73319 2021-04-04 Italy Sardegna     46978 1242 30180 15556 39.21531192 9.110616306 2021-04-05 04:20:35 Sardegna, Italy
791935 2021-04-03 Italy Sardegna     46655 1241 30125 15289 39.21531192 9.110616306 2021-04-04 04:20:49 Sardegna, Italy
1020373 2021-04-02 Italy Sardegna     46327 1240 30056 15031 39.21531192 9.110616306 2021-04-03 04:20:44 Sardegna, Italy
1350535 2021-04-01 Italy Sardegna     45854 1238 29962 14654 39.21531192 9.110616306 2021-04-02 04:20:36 Sardegna, Italy
1690921 2021-03-31 Italy Sardegna     45503 1234 29872 14397 39.21531192 9.110616306 2021-04-01 04:27:05 Sardegna, Italy
873290 2021-03-30 Italy Sardegna     45059 1233 29795 14031 39.21531192 9.110616306 2021-03-31 04:26:25 Sardegna, Italy
1400337 2021-03-29 Italy Sardegna     44854 1229 29647 13978 39.21531192 9.110616306 2021-03-30 04:26:23 Sardegna, Italy
1624740 2021-03-28 Italy Sardegna     44690 1226 29559 13905 39.21531192 9.110616306 2021-03-29 04:28:35 Sardegna, Italy
1472170 2021-03-27 Italy Sardegna     44406 1223 29511 13672 39.21531192 9.110616306 2021-03-28 05:28:10 Sardegna, Italy
720717 2021-03-26 Italy Sardegna     44119 1221 29426 13472 39.21531192 9.110616306 2021-03-27 05:25:04 Sardegna, Italy
1617336 2021-03-25 Italy Sardegna     43941 1219 29362 13360 39.21531192 9.110616306 2021-03-26 05:26:55 Sardegna, Italy
469997 2021-03-24 Italy Sardegna     43730 1218 29283 13229 39.21531192 9.110616306 2021-03-25 05:27:00 Sardegna, Italy
1585037 2021-03-23 Italy Sardegna     43577 1216 29194 13167 39.21531192 9.110616306 2021-03-24 05:25:40 Sardegna, Italy
716731 2021-03-22 Italy Sardegna     43418 1214 29120 13084 39.21531192 9.110616306 2021-03-23 05:26:18 Sardegna, Italy
1674999 2021-03-21 Italy Sardegna     43257 1209 29032 13016 39.21531192 9.110616306 2021-03-22 05:25:43 Sardegna, Italy
1746938 2021-03-20 Italy Sardegna     43081 1205 28978 12898 39.21531192 9.110616306 2021-03-21 05:25:44 Sardegna, Italy
230060 2021-03-19 Italy Sardegna     42979 1203 28909 12867 39.21531192 9.110616306 2021-03-20 05:25:46 Sardegna, Italy
477995 2021-03-18 Italy Sardegna     42845 1201 28831 12813 39.21531192 9.110616306 2021-03-19 05:26:09 Sardegna, Italy
1426590 2021-03-17 Italy Sardegna     42724 1200 28705 12819 39.21531192 9.110616306 2021-03-18 05:26:22 Sardegna, Italy
1593178 2021-03-16 Italy Sardegna     42632 1198 28618 12816 39.21531192 9.110616306 2021-03-17 05:25:07 Sardegna, Italy
1176177 2021-03-15 Italy Sardegna     42553 1197 28521 12835 39.21531192 9.110616306 2021-03-16 05:25:13 Sardegna, Italy
275862 2021-03-14 Italy Sardegna     42479 1195 28404 12880 39.21531192 9.110616306 2021-03-15 05:25:51 Sardegna, Italy
1161004 2021-03-13 Italy Sardegna     42361 1195 28377 12789 39.21531192 9.110616306 2021-03-14 05:25:37 Sardegna, Italy
22511 2021-03-12 Italy Sardegna     42258 1192 28306 12760 39.21531192 9.110616306 2021-03-13 05:25:15 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
);
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]);