⚠️ 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 = "P.A. Trento" sorted by day descending

View and edit SQL

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

province_or_state

  • P.A. Trento · 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
222917 2021-06-14 Italy P.A. Trento     45689 1360 44087 242 46.06893511 11.12123097 2021-06-15 04:22:22 P.A. Trento, Italy
214949 2021-06-13 Italy P.A. Trento     45687 1360 44081 246 46.06893511 11.12123097 2021-06-14 04:22:46 P.A. Trento, Italy
281519 2021-06-12 Italy P.A. Trento     45676 1360 44037 279 46.06893511 11.12123097 2021-06-13 04:22:44 P.A. Trento, Italy
1633618 2021-06-11 Italy P.A. Trento     45664 1359 43991 314 46.06893511 11.12123097 2021-06-12 04:22:22 P.A. Trento, Italy
662904 2021-06-10 Italy P.A. Trento     45640 1359 43956 325 46.06893511 11.12123097 2021-06-11 04:23:20 P.A. Trento, Italy
882008 2021-06-09 Italy P.A. Trento     45626 1359 43923 344 46.06893511 11.12123097 2021-06-10 04:23:17 P.A. Trento, Italy
1710007 2021-06-08 Italy P.A. Trento     45593 1359 43874 360 46.06893511 11.12123097 2021-06-09 04:23:31 P.A. Trento, Italy
1465851 2021-06-07 Italy P.A. Trento     45572 1359 43859 354 46.06893511 11.12123097 2021-06-08 04:22:35 P.A. Trento, Italy
993618 2021-06-06 Italy P.A. Trento     45568 1359 43853 356 46.06893511 11.12123097 2021-06-07 04:22:51 P.A. Trento, Italy
158408 2021-06-05 Italy P.A. Trento     45553 1358 43810 385 46.06893511 11.12123097 2021-06-06 04:24:03 P.A. Trento, Italy
1516393 2021-06-04 Italy P.A. Trento     45525 1358 43772 395 46.06893511 11.12123097 2021-06-05 04:23:03 P.A. Trento, Italy
1140704 2021-06-03 Italy P.A. Trento     45505 1358 43739 408 46.06893511 11.12123097 2021-06-04 04:23:37 P.A. Trento, Italy
427148 2021-06-02 Italy P.A. Trento     45486 1358 43733 395 46.06893511 11.12123097 2021-06-03 04:23:32 P.A. Trento, Italy
539655 2021-06-01 Italy P.A. Trento     45459 1358 43621 480 46.06893511 11.12123097 2021-06-02 04:24:34 P.A. Trento, Italy
786840 2021-05-31 Italy P.A. Trento     45427 1355 43599 473 46.06893511 11.12123097 2021-06-01 04:23:09 P.A. Trento, Italy
1330238 2021-05-30 Italy P.A. Trento     45417 1354 43583 480 46.06893511 11.12123097 2021-05-31 03:08:59 P.A. Trento, Italy
67447 2021-05-29 Italy P.A. Trento     45389 1354 43506 529 46.06893511 11.12123097 2021-05-30 04:20:55 P.A. Trento, Italy
195633 2021-05-28 Italy P.A. Trento     45353 1354 43481 518 46.06893511 11.12123097 2021-05-29 04:20:41 P.A. Trento, Italy
938892 2021-05-27 Italy P.A. Trento     45313 1354 43443 516 46.06893511 11.12123097 2021-05-28 04:20:36 P.A. Trento, Italy
1226567 2021-05-26 Italy P.A. Trento     45267 1354 43383 530 46.06893511 11.12123097 2021-05-27 04:20:59 P.A. Trento, Italy
1338206 2021-05-25 Italy P.A. Trento     45222 1354 43281 587 46.06893511 11.12123097 2021-05-26 04:20:35 P.A. Trento, Italy
203038 2021-05-24 Italy P.A. Trento     45198 1354 43246 598 46.06893511 11.12123097 2021-05-25 04:21:08 P.A. Trento, Italy
99202 2021-05-23 Italy P.A. Trento     45178 1354 43224 600 46.06893511 11.12123097 2021-05-24 04:20:53 P.A. Trento, Italy
523721 2021-05-22 Italy P.A. Trento     45126 1354 43161 611 46.06893511 11.12123097 2021-05-23 04:20:51 P.A. Trento, Italy
859416 2021-05-21 Italy P.A. Trento     45102 1354 43128 620 46.06893511 11.12123097 2021-05-22 04:20:45 P.A. Trento, Italy
720839 2021-05-20 Italy P.A. Trento     45067 1354 43050 663 46.06893511 11.12123097 2021-05-21 04:20:43 P.A. Trento, Italy
407970 2021-05-19 Italy P.A. Trento     45024 1354 43024 646 46.06893511 11.12123097 2021-05-20 04:21:05 P.A. Trento, Italy
782856 2021-05-18 Italy P.A. Trento     44965 1353 42933 679 46.06893511 11.12123097 2021-05-19 04:20:42 P.A. Trento, Italy
1422998 2021-05-17 Italy P.A. Trento     44929 1353 42817 759 46.06893511 11.12123097 2021-05-18 04:20:33 P.A. Trento, Italy
740184 2021-05-16 Italy P.A. Trento     44914 1351 42790 773 46.06893511 11.12123097 2021-05-17 04:20:34 P.A. Trento, Italy
1116717 2021-05-15 Italy P.A. Trento     44831 1349 42682 800 46.06893511 11.12123097 2021-05-16 04:20:49 P.A. Trento, Italy
1587226 2021-05-14 Italy P.A. Trento     44788 1349 42632 807 46.06893511 11.12123097 2021-05-15 04:20:58 P.A. Trento, Italy
1675143 2021-05-13 Italy P.A. Trento     44737 1349 42526 862 46.06893511 11.12123097 2021-05-14 04:20:41 P.A. Trento, Italy
802770 2021-05-12 Italy P.A. Trento     44684 1349 42492 843 46.06893511 11.12123097 2021-05-13 04:20:51 P.A. Trento, Italy
1181158 2021-05-11 Italy P.A. Trento     44613 1349 42430 834 46.06893511 11.12123097 2021-05-12 04:21:29 P.A. Trento, Italy
324948 2021-05-10 Italy P.A. Trento     44569 1347 42361 861 46.06893511 11.12123097 2021-05-11 04:20:41 P.A. Trento, Italy
604095 2021-05-09 Italy P.A. Trento     44557 1346 42331 880 46.06893511 11.12123097 2021-05-10 04:20:38 P.A. Trento, Italy
985842 2021-05-08 Italy P.A. Trento     44500 1346 42220 934 46.06893511 11.12123097 2021-05-09 04:20:35 P.A. Trento, Italy
434324 2021-05-07 Italy P.A. Trento     44441 1346 42142 953 46.06893511 11.12123097 2021-05-08 04:21:04 P.A. Trento, Italy
901105 2021-05-06 Italy P.A. Trento     44351 1346 42038 967 46.06893511 11.12123097 2021-05-07 04:20:40 P.A. Trento, Italy
71431 2021-05-05 Italy P.A. Trento     44282 1346 42000 936 46.06893511 11.12123097 2021-05-06 04:20:38 P.A. Trento, Italy
790824 2021-05-04 Italy P.A. Trento     44219 1346 41861 1012 46.06893511 11.12123097 2021-05-05 04:20:43 P.A. Trento, Italy
1613354 2021-05-03 Italy P.A. Trento     44132 1346 41735 1051 46.06893511 11.12123097 2021-05-04 04:20:34 P.A. Trento, Italy
885992 2021-05-02 Italy P.A. Trento     44115 1345 41720 1050 46.06893511 11.12123097 2021-05-03 04:20:39 P.A. Trento, Italy
511697 2021-05-01 Italy P.A. Trento     44077 1345 41600 1132 46.06893511 11.12123097 2021-05-02 04:20:48 P.A. Trento, Italy
14633 2021-04-30 Italy P.A. Trento     43999 1344 41579 1076 46.06893511 11.12123097 2021-05-01 04:20:47 P.A. Trento, Italy
1124737 2021-04-29 Italy P.A. Trento     43902 1343 41497 1062 46.06893511 11.12123097 2021-04-30 04:21:03 P.A. Trento, Italy
462034 2021-04-28 Italy P.A. Trento     43832 1340 41382 1110 46.06893511 11.12123097 2021-04-29 04:20:55 P.A. Trento, Italy
1314740 2021-04-27 Italy P.A. Trento     43739 1338 41341 1060 46.06893511 11.12123097 2021-04-28 04:20:32 P.A. Trento, Italy
1549167 2021-04-26 Italy P.A. Trento     43650 1335 41155 1160 46.06893511 11.12123097 2021-04-27 04:20:52 P.A. Trento, Italy
1629634 2021-04-25 Italy P.A. Trento     43634 1334 41097 1203 46.06893511 11.12123097 2021-04-26 04:21:04 P.A. Trento, Italy
353774 2021-04-24 Italy P.A. Trento     43543 1334 40987 1222 46.06893511 11.12123097 2021-04-25 04:20:32 P.A. Trento, Italy
724823 2021-04-23 Italy P.A. Trento     43468 1333 40896 1239 46.06893511 11.12123097 2021-04-24 04:20:38 P.A. Trento, Italy
1469835 2021-04-22 Italy P.A. Trento     43372 1333 40811 1228 46.06893511 11.12123097 2021-04-23 04:20:52 P.A. Trento, Italy
1222583 2021-04-21 Italy P.A. Trento     43268 1329 40705 1234 46.06893511 11.12123097 2021-04-22 04:20:53 P.A. Trento, Italy
458050 2021-04-20 Italy P.A. Trento     43148 1328 40567 1253 46.06893511 11.12123097 2021-04-21 04:21:14 P.A. Trento, Italy
1300238 2021-04-19 Italy P.A. Trento     43063 1324 40424 1315 46.06893511 11.12123097 2021-04-20 04:20:41 P.A. Trento, Italy
1069817 2021-04-18 Italy P.A. Trento     43050 1324 40390 1336 46.06893511 11.12123097 2021-04-19 04:20:57 P.A. Trento, Italy
1045699 2021-04-17 Italy P.A. Trento     42965 1323 40265 1377 46.06893511 11.12123097 2021-04-18 04:20:41 P.A. Trento, Italy
596975 2021-04-16 Italy P.A. Trento     42877 1322 40108 1447 46.06893511 11.12123097 2021-04-17 04:20:40 P.A. Trento, Italy
1621391 2021-04-15 Italy P.A. Trento     42814 1318 40045 1451 46.06893511 11.12123097 2021-04-16 04:20:46 P.A. Trento, Italy
950822 2021-04-14 Italy P.A. Trento     42697 1315 39901 1481 46.06893511 11.12123097 2021-04-15 04:20:54 P.A. Trento, Italy
592991 2021-04-13 Italy P.A. Trento     42564 1314 39737 1513 46.06893511 11.12123097 2021-04-14 04:20:41 P.A. Trento, Italy
32930 2021-04-12 Italy P.A. Trento     42445 1311 39571 1563 46.06893511 11.12123097 2021-04-13 04:20:37 P.A. Trento, Italy
1371945 2021-04-11 Italy P.A. Trento     42421 1311 39457 1653 46.06893511 11.12123097 2021-04-12 04:21:00 P.A. Trento, Italy
1667197 2021-04-10 Italy P.A. Trento     42328 1311 39277 1740 46.06893511 11.12123097 2021-04-11 04:20:56 P.A. Trento, Italy
1159813 2021-04-09 Italy P.A. Trento     42221 1309 39006 1906 46.06893511 11.12123097 2021-04-10 04:20:59 P.A. Trento, Italy
1057648 2021-04-08 Italy P.A. Trento     42114 1307 38758 2049 46.06893511 11.12123097 2021-04-09 04:21:13 P.A. Trento, Italy
1500437 2021-04-07 Italy P.A. Trento     41950 1306 38367 2277 46.06893511 11.12123097 2021-04-08 04:21:13 P.A. Trento, Italy
1207642 2021-04-06 Italy P.A. Trento     41847 1301 38135 2411 46.06893511 11.12123097 2021-04-07 04:20:53 P.A. Trento, Italy
122943 2021-04-05 Italy P.A. Trento     41821 1297 37925 2599 46.06893511 11.12123097 2021-04-06 04:20:32 P.A. Trento, Italy
1254744 2021-04-04 Italy P.A. Trento     41781 1297 37761 2723 46.06893511 11.12123097 2021-04-05 04:20:35 P.A. Trento, Italy
1128721 2021-04-03 Italy P.A. Trento     41612 1295 37677 2640 46.06893511 11.12123097 2021-04-04 04:20:49 P.A. Trento, Italy
270112 2021-04-02 Italy P.A. Trento     41485 1289 37462 2734 46.06893511 11.12123097 2021-04-03 04:20:44 P.A. Trento, Italy
1173444 2021-04-01 Italy P.A. Trento     41371 1286 37221 2864 46.06893511 11.12123097 2021-04-02 04:20:36 P.A. Trento, Italy
515755 2021-03-31 Italy P.A. Trento     41231 1282 37086 2863 46.06893511 11.12123097 2021-04-01 04:27:05 P.A. Trento, Italy
289484 2021-03-30 Italy P.A. Trento     41044 1282 36756 3006 46.06893511 11.12123097 2021-03-31 04:26:25 P.A. Trento, Italy
1575021 2021-03-29 Italy P.A. Trento     40848 1278 36477 3093 46.06893511 11.12123097 2021-03-30 04:26:23 P.A. Trento, Italy
631298 2021-03-28 Italy P.A. Trento     40764 1277 36302 3185 46.06893511 11.12123097 2021-03-29 04:28:35 P.A. Trento, Italy
608079 2021-03-27 Italy P.A. Trento     40602 1276 36018 3308 46.06893511 11.12123097 2021-03-28 05:28:10 P.A. Trento, Italy
1334222 2021-03-26 Italy P.A. Trento     40387 1273 35834 3280 46.06893511 11.12123097 2021-03-27 05:25:04 P.A. Trento, Italy
150661 2021-03-25 Italy P.A. Trento     40149 1268 35539 3342 46.06893511 11.12123097 2021-03-26 05:26:55 P.A. Trento, Italy
1598182 2021-03-24 Italy P.A. Trento     39972 1268 35328 3376 46.06893511 11.12123097 2021-03-25 05:27:00 P.A. Trento, Italy
403986 2021-03-23 Italy P.A. Trento     39664 1265 34949 3450 46.06893511 11.12123097 2021-03-24 05:25:40 P.A. Trento, Italy
1387523 2021-03-22 Italy P.A. Trento     39473 1261 34704 3508 46.06893511 11.12123097 2021-03-23 05:26:18 P.A. Trento, Italy
305010 2021-03-21 Italy P.A. Trento     39393 1255 34432 3706 46.06893511 11.12123097 2021-03-22 05:25:43 P.A. Trento, Italy
254059 2021-03-20 Italy P.A. Trento     39238 1254 34289 3695 46.06893511 11.12123097 2021-03-21 05:25:44 P.A. Trento, Italy
1230815 2021-03-19 Italy P.A. Trento     38931 1252 33862 3817 46.06893511 11.12123097 2021-03-20 05:25:46 P.A. Trento, Italy
974740 2021-03-18 Italy P.A. Trento     38625 1249 33429 3947 46.06893511 11.12123097 2021-03-19 05:26:09 P.A. Trento, Italy
1532375 2021-03-17 Italy P.A. Trento     38369 1246 33152 3971 46.06893511 11.12123097 2021-03-18 05:26:22 P.A. Trento, Italy
55569 2021-03-16 Italy P.A. Trento     38084 1243 32889 3952 46.06893511 11.12123097 2021-03-17 05:25:07 P.A. Trento, Italy
562882 2021-03-15 Italy P.A. Trento     37894 1241 32597 4056 46.06893511 11.12123097 2021-03-16 05:25:13 P.A. Trento, Italy
851451 2021-03-14 Italy P.A. Trento     37790 1237 32241 4312 46.06893511 11.12123097 2021-03-15 05:25:51 P.A. Trento, Italy
942876 2021-03-13 Italy P.A. Trento     37517 1236 32096 4185 46.06893511 11.12123097 2021-03-14 05:25:37 P.A. Trento, Italy
1310756 2021-03-12 Italy P.A. Trento     37278 1234 31905 4139 46.06893511 11.12123097 2021-03-13 05:25:15 P.A. Trento, Italy
1077594 2021-03-11 Italy P.A. Trento     36997 1233 31637 4127 46.06893511 11.12123097 2021-03-12 05:26:50 P.A. Trento, Italy
954806 2021-03-10 Italy P.A. Trento     36627 1232 31385 4010 46.06893511 11.12123097 2021-03-11 05:25:48 P.A. Trento, Italy
543639 2021-03-09 Italy P.A. Trento     36222 1227 31050 3945 46.06893511 11.12123097 2021-03-10 05:24:35 P.A. Trento, Italy
1520377 2021-03-08 Italy P.A. Trento     36009 1226 30639 4144 46.06893511 11.12123097 2021-03-09 05:28:19 P.A. Trento, Italy
866658 2021-03-07 Italy P.A. Trento     35926 1222 30536 4168 46.06893511 11.12123097 2021-03-08 05:24:48 P.A. Trento, 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]);