daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
71 rows where country_or_region = "Italy" and deaths = 80 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: longitude, combined_key, day (date), last_update (date)
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2020-11-18 | Italy | Molise | 3366 | 80 | 1219 | 2067 | 41.55774754 | 14.65916051 | 2020-11-19 05:25:23 | Molise, Italy | ||
2020-09-04 | Italy | Umbria | 1874 | 80 | 1467 | 327 | 43.10675841 | 12.38824698 | 2020-09-05 04:28:19 | Umbria, Italy | ||
2020-09-03 | Italy | Umbria | 1839 | 80 | 1457 | 302 | 43.10675841 | 12.38824698 | 2020-09-04 04:28:26 | Umbria, Italy | ||
2020-09-02 | Italy | Umbria | 1830 | 80 | 1452 | 298 | 43.10675841 | 12.38824698 | 2020-09-03 04:28:22 | Umbria, Italy | ||
2020-09-01 | Italy | Umbria | 1803 | 80 | 1445 | 278 | 43.10675841 | 12.38824698 | 2020-09-02 04:28:25 | Umbria, Italy | ||
2020-08-31 | Italy | Umbria | 1793 | 80 | 1445 | 268 | 43.10675841 | 12.38824698 | 2020-09-01 04:28:31 | Umbria, Italy | ||
2020-08-30 | Italy | Umbria | 1784 | 80 | 1442 | 262 | 43.10675841 | 12.38824698 | 2020-08-31 04:28:27 | Umbria, Italy | ||
2020-08-29 | Italy | Umbria | 1753 | 80 | 1435 | 238 | 43.10675841 | 12.38824698 | 2020-08-30 04:28:22 | Umbria, Italy | ||
2020-08-28 | Italy | Umbria | 1741 | 80 | 1432 | 229 | 43.10675841 | 12.38824698 | 2020-08-29 04:28:19 | Umbria, Italy | ||
2020-08-27 | Italy | Umbria | 1719 | 80 | 1417 | 222 | 43.10675841 | 12.38824698 | 2020-08-28 04:28:11 | Umbria, Italy | ||
2020-08-26 | Italy | Umbria | 1699 | 80 | 1407 | 212 | 43.10675841 | 12.38824698 | 2020-08-27 04:28:15 | Umbria, Italy | ||
2020-08-25 | Italy | Umbria | 1679 | 80 | 1404 | 195 | 43.10675841 | 12.38824698 | 2020-08-26 04:28:11 | Umbria, Italy | ||
2020-08-24 | Italy | Umbria | 1650 | 80 | 1400 | 170 | 43.10675841 | 12.38824698 | 2020-08-25 04:28:02 | Umbria, Italy | ||
2020-08-23 | Italy | Umbria | 1639 | 80 | 1399 | 160 | 43.10675841 | 12.38824698 | 2020-08-24 04:27:56 | Umbria, Italy | ||
2020-08-22 | Italy | Umbria | 1620 | 80 | 1398 | 142 | 43.10675841 | 12.38824698 | 2020-08-23 04:27:48 | Umbria, Italy | ||
2020-08-21 | Italy | Umbria | 1602 | 80 | 1398 | 124 | 43.10675841 | 12.38824698 | 2020-08-22 04:27:49 | Umbria, Italy | ||
2020-08-20 | Italy | Umbria | 1580 | 80 | 1388 | 112 | 43.10675841 | 12.38824698 | 2020-08-21 04:27:41 | Umbria, Italy | ||
2020-08-19 | Italy | Umbria | 1563 | 80 | 1388 | 95 | 43.10675841 | 12.38824698 | 2020-08-20 04:27:43 | Umbria, Italy | ||
2020-08-18 | Italy | Umbria | 1559 | 80 | 1386 | 93 | 43.10675841 | 12.38824698 | 2020-08-19 04:27:00 | Umbria, Italy | ||
2020-08-17 | Italy | Umbria | 1549 | 80 | 1384 | 85 | 43.10675841 | 12.38824698 | 2020-08-18 04:27:56 | Umbria, Italy | ||
2020-08-16 | Italy | Umbria | 1548 | 80 | 1385 | 83 | 43.10675841 | 12.38824698 | 2020-08-17 04:27:20 | Umbria, Italy | ||
2020-08-15 | Italy | Umbria | 1545 | 80 | 1385 | 80 | 43.10675841 | 12.38824698 | 2020-08-16 04:27:42 | Umbria, Italy | ||
2020-08-14 | Italy | Umbria | 1532 | 80 | 1384 | 68 | 43.10675841 | 12.38824698 | 2020-08-15 04:27:31 | Umbria, Italy | ||
2020-08-13 | Italy | Umbria | 1524 | 80 | 1382 | 62 | 43.10675841 | 12.38824698 | 2020-08-14 04:51:19 | Umbria, Italy | ||
2020-08-12 | Italy | Umbria | 1517 | 80 | 1380 | 57 | 43.10675841 | 12.38824698 | 2020-08-13 04:29:15 | Umbria, Italy | ||
2020-08-11 | Italy | Umbria | 1511 | 80 | 1379 | 52 | 43.10675841 | 12.38824698 | 2020-08-12 04:27:29 | Umbria, Italy | ||
2020-08-10 | Italy | Umbria | 1510 | 80 | 1376 | 54 | 43.10675841 | 12.38824698 | 2020-08-11 04:35:08 | Umbria, Italy | ||
2020-08-09 | Italy | Umbria | 1505 | 80 | 1376 | 49 | 43.10675841 | 12.38824698 | 2020-08-10 04:34:55 | Umbria, Italy | ||
2020-08-08 | Italy | Umbria | 1498 | 80 | 1376 | 42 | 43.10675841 | 12.38824698 | 2020-08-09 04:34:54 | Umbria, Italy | ||
2020-08-07 | Italy | Umbria | 1488 | 80 | 1375 | 33 | 43.10675841 | 12.38824698 | 2020-08-08 04:34:53 | Umbria, Italy | ||
2020-08-06 | Italy | Umbria | 1482 | 80 | 1373 | 29 | 43.10675841 | 12.38824698 | 2020-08-07 04:35:11 | Umbria, Italy | ||
2020-08-05 | Italy | Umbria | 1479 | 80 | 1369 | 30 | 43.10675841 | 12.38824698 | 2020-08-06 04:35:02 | Umbria, Italy | ||
2020-08-04 | Italy | Umbria | 1477 | 80 | 1368 | 29 | 43.10675841 | 12.38824698 | 2020-08-05 04:34:43 | Umbria, Italy | ||
2020-08-03 | Italy | Umbria | 1475 | 80 | 1368 | 27 | 43.10675841 | 12.38824698 | 2020-08-04 04:41:59 | Umbria, Italy | ||
2020-08-02 | Italy | Umbria | 1474 | 80 | 1368 | 26 | 43.10675841 | 12.38824698 | 2020-08-03 04:34:35 | Umbria, Italy | ||
2020-08-01 | Italy | Umbria | 1472 | 80 | 1368 | 24 | 43.10675841 | 12.38824698 | 2020-08-02 04:34:47 | Umbria, Italy | ||
2020-07-31 | Italy | Umbria | 1466 | 80 | 1368 | 18 | 43.10675841 | 12.38824698 | 2020-08-01 04:36:27 | Umbria, Italy | ||
2020-07-30 | Italy | Umbria | 1465 | 80 | 1368 | 17 | 43.10675841 | 12.38824698 | 2020-07-31 04:35:18 | Umbria, Italy | ||
2020-07-29 | Italy | Umbria | 1465 | 80 | 1368 | 17 | 43.10675841 | 12.38824698 | 2020-07-30 04:35:05 | Umbria, Italy | ||
2020-07-28 | Italy | Umbria | 1465 | 80 | 1368 | 17 | 43.10675841 | 12.38824698 | 2020-07-29 04:35:11 | Umbria, Italy | ||
2020-07-27 | Italy | Umbria | 1465 | 80 | 1368 | 17 | 43.10675841 | 12.38824698 | 2020-07-28 04:58:43 | Umbria, Italy | ||
2020-07-26 | Italy | Umbria | 1465 | 80 | 1368 | 17 | 43.10675841 | 12.38824698 | 2020-07-27 04:35:02 | Umbria, Italy | ||
2020-07-25 | Italy | Umbria | 1465 | 80 | 1368 | 17 | 43.10675841 | 12.38824698 | 2020-07-26 04:35:00 | Umbria, Italy | ||
2020-07-24 | Italy | Umbria | 1465 | 80 | 1366 | 19 | 43.10675841 | 12.38824698 | 2020-07-25 04:47:39 | Umbria, Italy | ||
2020-07-23 | Italy | Umbria | 1463 | 80 | 1366 | 17 | 43.10675841 | 12.38824698 | 2020-07-24 05:30:40 | Umbria, Italy | ||
2020-07-22 | Italy | Umbria | 1461 | 80 | 1365 | 16 | 43.10675841 | 12.38824698 | 2020-07-23 05:15:04 | Umbria, Italy | ||
2020-07-21 | Italy | Umbria | 1459 | 80 | 1365 | 14 | 43.10675841 | 12.38824698 | 2020-07-22 04:34:42 | Umbria, Italy | ||
2020-07-20 | Italy | Umbria | 1456 | 80 | 1364 | 12 | 43.10675841 | 12.38824698 | 2020-07-21 04:38:46 | Umbria, Italy | ||
2020-07-19 | Italy | Umbria | 1456 | 80 | 1364 | 12 | 43.10675841 | 12.38824698 | 2020-07-20 05:34:40 | Umbria, Italy | ||
2020-07-18 | Italy | Umbria | 1456 | 80 | 1362 | 14 | 43.10675841 | 12.38824698 | 2020-07-19 04:34:58 | Umbria, Italy | ||
2020-07-17 | Italy | Umbria | 1454 | 80 | 1362 | 12 | 43.10675841 | 12.38824698 | 2020-07-18 04:34:45 | Umbria, Italy | ||
2020-07-16 | Italy | Umbria | 1452 | 80 | 1362 | 10 | 43.10675841 | 12.38824698 | 2020-07-17 04:34:50 | Umbria, Italy | ||
2020-07-15 | Italy | Umbria | 1452 | 80 | 1362 | 10 | 43.10675841 | 12.38824698 | 2020-07-16 04:44:59 | Umbria, Italy | ||
2020-07-14 | Italy | Umbria | 1450 | 80 | 1362 | 8 | 43.10675841 | 12.38824698 | 2020-07-15 04:34:39 | Umbria, Italy | ||
2020-07-13 | Italy | Umbria | 1450 | 80 | 1362 | 8 | 43.10675841 | 12.38824698 | 2020-07-14 04:34:46 | Umbria, Italy | ||
2020-07-12 | Italy | Umbria | 1450 | 80 | 1361 | 9 | 43.10675841 | 12.38824698 | 2020-07-13 04:43:04 | Umbria, Italy | ||
2020-07-11 | Italy | Umbria | 1448 | 80 | 1360 | 8 | 43.10675841 | 12.38824698 | 2020-07-12 04:34:30 | Umbria, Italy | ||
2020-07-10 | Italy | Umbria | 1448 | 80 | 1360 | 8 | 43.10675841 | 12.38824698 | 2020-07-11 04:34:26 | Umbria, Italy | ||
2020-07-09 | Italy | Umbria | 1447 | 80 | 1360 | 7 | 43.10675841 | 12.38824698 | 2020-07-10 04:34:24 | Umbria, Italy | ||
2020-07-08 | Italy | Umbria | 1447 | 80 | 1360 | 7 | 43.10675841 | 12.38824698 | 2020-07-09 04:34:23 | Umbria, Italy | ||
2020-07-07 | Italy | Umbria | 1447 | 80 | 1359 | 8 | 43.10675841 | 12.38824698 | 2020-07-08 05:33:48 | Umbria, Italy | ||
2020-07-06 | Italy | Umbria | 1447 | 80 | 1358 | 9 | 43.10675841 | 12.38824698 | 2020-07-07 04:34:00 | Umbria, Italy | ||
2020-07-05 | Italy | Umbria | 1447 | 80 | 1358 | 9 | 43.10675841 | 12.38824698 | 2020-07-06 04:33:57 | Umbria, Italy | ||
2020-07-04 | Italy | Umbria | 1447 | 80 | 1358 | 9 | 43.10675841 | 12.38824698 | 2020-07-05 04:33:46 | Umbria, Italy | ||
2020-07-03 | Italy | Umbria | 1446 | 80 | 1356 | 10 | 43.10675841 | 12.38824698 | 2020-07-04 04:33:51 | Umbria, Italy | ||
2020-07-02 | Italy | Umbria | 1444 | 80 | 1353 | 11 | 43.10675841 | 12.38824698 | 2020-07-03 04:33:54 | Umbria, Italy | ||
2020-07-01 | Italy | Umbria | 1441 | 80 | 1351 | 10 | 43.10675841 | 12.38824698 | 2020-07-02 04:33:46 | Umbria, Italy | ||
2020-06-30 | Italy | Umbria | 1441 | 80 | 1351 | 10 | 43.10675841 | 12.38824698 | 2020-07-01 04:33:52 | Umbria, Italy | ||
2020-06-29 | Italy | Umbria | 1440 | 80 | 1351 | 9 | 43.10675841 | 12.38824698 | 2020-06-30 04:33:48 | Umbria, Italy | ||
2020-06-28 | Italy | Umbria | 1440 | 80 | 1351 | 9 | 43.10675841 | 12.38824698 | 2020-06-29 04:33:44 | Umbria, Italy | ||
2020-06-27 | Italy | Umbria | 1440 | 80 | 1350 | 10 | 43.10675841 | 12.38824698 | 2020-06-28 04:34:04 | Umbria, Italy |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;