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

View and edit SQL

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

province_or_state

  • Umbria · 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
168456 2021-06-19 Italy Umbria     56744 1418 54432 894 43.10675841 12.38824698 2021-06-20 04:21:48 Umbria, Italy
685981 2021-06-18 Italy Umbria     56736 1418 54392 926 43.10675841 12.38824698 2021-06-19 04:22:33 Umbria, Italy
958038 2021-06-17 Italy Umbria     56723 1418 54352 953 43.10675841 12.38824698 2021-06-18 04:22:16 Umbria, Italy
1281405 2021-06-16 Italy Umbria     56704 1418 54323 963 43.10675841 12.38824698 2021-06-17 04:22:36 Umbria, Italy
681995 2021-06-15 Italy Umbria     56692 1417 54251 1024 43.10675841 12.38824698 2021-06-16 04:22:32 Umbria, Italy
372549 2021-06-14 Italy Umbria     56671 1417 54241 1013 43.10675841 12.38824698 2021-06-15 04:22:22 Umbria, Italy
1223365 2021-06-13 Italy Umbria     56667 1417 54213 1037 43.10675841 12.38824698 2021-06-14 04:22:46 Umbria, Italy
80646 2021-06-12 Italy Umbria     56656 1417 54181 1058 43.10675841 12.38824698 2021-06-13 04:22:44 Umbria, Italy
969949 2021-06-11 Italy Umbria     56635 1415 54118 1102 43.10675841 12.38824698 2021-06-12 04:22:22 Umbria, Italy
1438522 2021-06-10 Italy Umbria     56619 1414 54080 1125 43.10675841 12.38824698 2021-06-11 04:23:20 Umbria, Italy
1157021 2021-06-09 Italy Umbria     56589 1406 54032 1151 43.10675841 12.38824698 2021-06-10 04:23:17 Umbria, Italy
1231337 2021-06-08 Italy Umbria     56568 1405 53966 1197 43.10675841 12.38824698 2021-06-09 04:23:31 Umbria, Italy
360333 2021-06-07 Italy Umbria     56536 1403 53919 1214 43.10675841 12.38824698 2021-06-08 04:22:35 Umbria, Italy
1075961 2021-06-06 Italy Umbria     56530 1403 53894 1233 43.10675841 12.38824698 2021-06-07 04:22:51 Umbria, Italy
1613353 2021-06-05 Italy Umbria     56506 1403 53794 1309 43.10675841 12.38824698 2021-06-06 04:24:03 Umbria, Italy
1125639 2021-06-04 Italy Umbria     56468 1403 53710 1355 43.10675841 12.38824698 2021-06-05 04:23:03 Umbria, Italy
318095 2021-06-03 Italy Umbria     56439 1402 53655 1382 43.10675841 12.38824698 2021-06-04 04:23:37 Umbria, Italy
1133608 2021-06-02 Italy Umbria     56433 1402 53634 1397 43.10675841 12.38824698 2021-06-03 04:23:32 Umbria, Italy
291785 2021-06-01 Italy Umbria     56400 1402 53505 1493 43.10675841 12.38824698 2021-06-02 04:24:34 Umbria, Italy
1651736 2021-05-31 Italy Umbria     56383 1401 53459 1523 43.10675841 12.38824698 2021-06-01 04:23:09 Umbria, Italy
980964 2021-05-30 Italy Umbria     56377 1401 53418 1558 43.10675841 12.38824698 2021-05-31 03:08:59 Umbria, Italy
841345 2021-05-29 Italy Umbria     56314 1400 53323 1591 43.10675841 12.38824698 2021-05-30 04:20:55 Umbria, Italy
697917 2021-05-28 Italy Umbria     56288 1397 53228 1663 43.10675841 12.38824698 2021-05-29 04:20:41 Umbria, Italy
1369418 2021-05-27 Italy Umbria     56225 1393 53137 1695 43.10675841 12.38824698 2021-05-28 04:20:36 Umbria, Italy
1292503 2021-05-26 Italy Umbria     56201 1392 53035 1774 43.10675841 12.38824698 2021-05-27 04:20:59 Umbria, Italy
602874 2021-05-25 Italy Umbria     56166 1391 52859 1916 43.10675841 12.38824698 2021-05-26 04:20:35 Umbria, Italy
1365432 2021-05-24 Italy Umbria     56111 1391 52774 1946 43.10675841 12.38824698 2021-05-25 04:21:08 Umbria, Italy
419945 2021-05-23 Italy Umbria     56101 1389 52745 1967 43.10675841 12.38824698 2021-05-24 04:20:53 Umbria, Italy
54284 2021-05-22 Italy Umbria     56061 1388 52643 2030 43.10675841 12.38824698 2021-05-23 04:20:51 Umbria, Italy
368563 2021-05-21 Italy Umbria     56025 1386 52542 2097 43.10675841 12.38824698 2021-05-22 04:20:45 Umbria, Italy
1024362 2021-05-20 Italy Umbria     55980 1383 52403 2194 43.10675841 12.38824698 2021-05-21 04:20:43 Umbria, Italy
1678988 2021-05-19 Italy Umbria     55935 1381 52306 2248 43.10675841 12.38824698 2021-05-20 04:21:05 Umbria, Italy
64975 2021-05-18 Italy Umbria     55888 1379 52166 2343 43.10675841 12.38824698 2021-05-19 04:20:42 Umbria, Italy
1243047 2021-05-17 Italy Umbria     55819 1378 52114 2327 43.10675841 12.38824698 2021-05-18 04:20:33 Umbria, Italy
1067895 2021-05-16 Italy Umbria     55804 1377 52044 2383 43.10675841 12.38824698 2021-05-17 04:20:34 Umbria, Italy
505023 2021-05-15 Italy Umbria     55745 1377 51962 2406 43.10675841 12.38824698 2021-05-16 04:20:49 Umbria, Italy
892628 2021-05-14 Italy Umbria     55691 1374 51836 2481 43.10675841 12.38824698 2021-05-15 04:20:58 Umbria, Italy
531963 2021-05-13 Italy Umbria     55618 1372 51704 2542 43.10675841 12.38824698 2021-05-14 04:20:41 Umbria, Italy
1719250 2021-05-12 Italy Umbria     55479 1371 51586 2522 43.10675841 12.38824698 2021-05-13 04:20:51 Umbria, Italy
1723236 2021-05-11 Italy Umbria     55402 1370 51378 2654 43.10675841 12.38824698 2021-05-12 04:21:29 Umbria, Italy
1164993 2021-05-10 Italy Umbria     55288 1370 51362 2556 43.10675841 12.38824698 2021-05-11 04:20:41 Umbria, Italy
1168979 2021-05-09 Italy Umbria     55270 1370 51317 2583 43.10675841 12.38824698 2021-05-10 04:20:38 Umbria, Italy
1659766 2021-05-08 Italy Umbria     55162 1367 51159 2636 43.10675841 12.38824698 2021-05-09 04:20:35 Umbria, Italy
799864 2021-05-07 Italy Umbria     55065 1366 51054 2645 43.10675841 12.38824698 2021-05-08 04:21:04 Umbria, Italy
1219379 2021-05-06 Italy Umbria     54966 1365 50917 2684 43.10675841 12.38824698 2021-05-07 04:20:40 Umbria, Italy
415959 2021-05-05 Italy Umbria     54867 1364 50776 2727 43.10675841 12.38824698 2021-05-06 04:20:38 Umbria, Italy
673980 2021-05-04 Italy Umbria     54736 1361 50561 2814 43.10675841 12.38824698 2021-05-05 04:20:43 Umbria, Italy
1088004 2021-05-03 Italy Umbria     54638 1361 50490 2787 43.10675841 12.38824698 2021-05-04 04:20:34 Umbria, Italy
1727222 2021-05-02 Italy Umbria     54603 1357 50395 2851 43.10675841 12.38824698 2021-05-03 04:20:39 Umbria, Italy
1084018 2021-05-01 Italy Umbria     54538 1357 50300 2881 43.10675841 12.38824698 2021-05-02 04:20:48 Umbria, Italy
1388546 2021-04-30 Italy Umbria     54442 1352 50157 2933 43.10675841 12.38824698 2021-05-01 04:20:47 Umbria, Italy
38365 2021-04-29 Italy Umbria     54322 1350 50017 2955 43.10675841 12.38824698 2021-04-30 04:21:03 Umbria, Italy
11938 2021-04-28 Italy Umbria     54134 1349 49877 2908 43.10675841 12.38824698 2021-04-29 04:20:55 Umbria, Italy
853321 2021-04-27 Italy Umbria     54036 1348 49690 2998 43.10675841 12.38824698 2021-04-28 04:20:32 Umbria, Italy
1063909 2021-04-26 Italy Umbria     53940 1347 49608 2985 43.10675841 12.38824698 2021-04-27 04:20:52 Umbria, Italy
1476159 2021-04-25 Italy Umbria     53915 1344 49546 3025 43.10675841 12.38824698 2021-04-26 04:21:04 Umbria, Italy
743780 2021-04-24 Italy Umbria     53810 1339 49405 3066 43.10675841 12.38824698 2021-04-25 04:20:32 Umbria, Italy
1430579 2021-04-23 Italy Umbria     53705 1336 49246 3123 43.10675841 12.38824698 2021-04-24 04:20:38 Umbria, Italy
96408 2021-04-22 Italy Umbria     53571 1334 49100 3137 43.10675841 12.38824698 2021-04-23 04:20:52 Umbria, Italy
849335 2021-04-21 Italy Umbria     53430 1331 48947 3152 43.10675841 12.38824698 2021-04-22 04:20:53 Umbria, Italy
826953 2021-04-20 Italy Umbria     53322 1331 48687 3304 43.10675841 12.38824698 2021-04-21 04:21:14 Umbria, Italy
770664 2021-04-19 Italy Umbria     53220 1324 48600 3296 43.10675841 12.38824698 2021-04-20 04:20:41 Umbria, Italy
1415973 2021-04-18 Italy Umbria     53206 1322 48462 3422 43.10675841 12.38824698 2021-04-19 04:20:57 Umbria, Italy
984950 2021-04-17 Italy Umbria     53093 1319 48313 3461 43.10675841 12.38824698 2021-04-18 04:20:41 Umbria, Italy
238013 2021-04-16 Italy Umbria     52979 1315 48089 3575 43.10675841 12.38824698 2021-04-17 04:20:40 Umbria, Italy
579742 2021-04-15 Italy Umbria     52846 1310 47889 3647 43.10675841 12.38824698 2021-04-16 04:20:46 Umbria, Italy
1266370 2021-04-14 Italy Umbria     52730 1306 47636 3788 43.10675841 12.38824698 2021-04-15 04:20:54 Umbria, Italy
701903 2021-04-13 Italy Umbria     52593 1301 47436 3856 43.10675841 12.38824698 2021-04-14 04:20:41 Umbria, Italy
1671016 2021-04-12 Italy Umbria     52484 1298 47284 3902 43.10675841 12.38824698 2021-04-13 04:20:37 Umbria, Italy
784721 2021-04-11 Italy Umbria     52444 1296 47118 4030 43.10675841 12.38824698 2021-04-12 04:21:00 Umbria, Italy
1392532 2021-04-10 Italy Umbria     52309 1294 46908 4107 43.10675841 12.38824698 2021-04-11 04:20:56 Umbria, Italy
965963 2021-04-09 Italy Umbria     52157 1290 46597 4270 43.10675841 12.38824698 2021-04-10 04:20:59 Umbria, Italy
689967 2021-04-08 Italy Umbria     51956 1286 46336 4334 43.10675841 12.38824698 2021-04-09 04:21:13 Umbria, Italy
1277419 2021-04-07 Italy Umbria     51784 1279 46046 4459 43.10675841 12.38824698 2021-04-08 04:21:13 Umbria, Italy
88438 2021-04-06 Italy Umbria     51652 1273 45901 4478 43.10675841 12.38824698 2021-04-07 04:20:53 Umbria, Italy
122820 2021-04-05 Italy Umbria     51582 1270 45866 4446 43.10675841 12.38824698 2021-04-06 04:20:32 Umbria, Italy
73322 2021-04-04 Italy Umbria     51529 1266 45722 4541 43.10675841 12.38824698 2021-04-05 04:20:35 Umbria, Italy
791938 2021-04-03 Italy Umbria     51377 1261 45489 4627 43.10675841 12.38824698 2021-04-04 04:20:49 Umbria, Italy
1020376 2021-04-02 Italy Umbria     51271 1260 45257 4754 43.10675841 12.38824698 2021-04-03 04:20:44 Umbria, Italy
1350538 2021-04-01 Italy Umbria     51082 1259 45011 4812 43.10675841 12.38824698 2021-04-02 04:20:36 Umbria, Italy
1690924 2021-03-31 Italy Umbria     50908 1256 44846 4806 43.10675841 12.38824698 2021-04-01 04:27:05 Umbria, Italy
873293 2021-03-30 Italy Umbria     50746 1252 44449 5045 43.10675841 12.38824698 2021-03-31 04:26:25 Umbria, Italy
1400340 2021-03-29 Italy Umbria     50560 1247 44333 4980 43.10675841 12.38824698 2021-03-30 04:26:23 Umbria, Italy
1624743 2021-03-28 Italy Umbria     50511 1247 44201 5063 43.10675841 12.38824698 2021-03-29 04:28:35 Umbria, Italy
1472173 2021-03-27 Italy Umbria     50349 1243 43919 5187 43.10675841 12.38824698 2021-03-28 05:28:10 Umbria, Italy
720720 2021-03-26 Italy Umbria     50127 1237 43640 5250 43.10675841 12.38824698 2021-03-27 05:25:04 Umbria, Italy
1617339 2021-03-25 Italy Umbria     49807 1232 43408 5167 43.10675841 12.38824698 2021-03-26 05:26:55 Umbria, Italy
470000 2021-03-24 Italy Umbria     49694 1229 43221 5244 43.10675841 12.38824698 2021-03-25 05:27:00 Umbria, Italy
1585040 2021-03-23 Italy Umbria     49469 1227 42859 5383 43.10675841 12.38824698 2021-03-24 05:25:40 Umbria, Italy
716734 2021-03-22 Italy Umbria     49295 1213 42679 5403 43.10675841 12.38824698 2021-03-23 05:26:18 Umbria, Italy
1675002 2021-03-21 Italy Umbria     49224 1209 42499 5516 43.10675841 12.38824698 2021-03-22 05:25:43 Umbria, Italy
1746941 2021-03-20 Italy Umbria     49082 1205 42298 5579 43.10675841 12.38824698 2021-03-21 05:25:44 Umbria, Italy
230063 2021-03-19 Italy Umbria     48876 1193 42002 5681 43.10675841 12.38824698 2021-03-20 05:25:46 Umbria, Italy
477998 2021-03-18 Italy Umbria     48694 1187 41696 5811 43.10675841 12.38824698 2021-03-19 05:26:09 Umbria, Italy
1426593 2021-03-17 Italy Umbria     48526 1181 41441 5904 43.10675841 12.38824698 2021-03-18 05:26:22 Umbria, Italy
1593181 2021-03-16 Italy Umbria     48202 1171 41126 5905 43.10675841 12.38824698 2021-03-17 05:25:07 Umbria, Italy
1176180 2021-03-15 Italy Umbria     48043 1161 40895 5987 43.10675841 12.38824698 2021-03-16 05:25:13 Umbria, Italy
275865 2021-03-14 Italy Umbria     47977 1152 40726 6099 43.10675841 12.38824698 2021-03-15 05:25:51 Umbria, Italy
1161007 2021-03-13 Italy Umbria     47707 1147 40408 6152 43.10675841 12.38824698 2021-03-14 05:25:37 Umbria, Italy
22514 2021-03-12 Italy Umbria     47511 1137 40013 6361 43.10675841 12.38824698 2021-03-13 05:25:15 Umbria, 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]);