johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
960 rows where country_or_region = "Italy" and province_or_state = "Lazio" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2016692 | 2016692 | 2022-09-20 | Italy | Lazio | 2048181 | 12061 | 0 | 41.89277044 | 12.48366722 | 2022-09-21 04:23:22 | Lazio, Italy | |||
3570565 | 3570565 | 2022-09-19 | Italy | Lazio | 2045661 | 12058 | 0 | 41.89277044 | 12.48366722 | 2022-09-20 04:22:48 | Lazio, Italy | |||
419304 | 419304 | 2022-09-18 | Italy | Lazio | 2044846 | 12057 | 0 | 41.89277044 | 12.48366722 | 2022-09-19 04:21:49 | Lazio, Italy | |||
3373328 | 3373328 | 2022-09-17 | Italy | Lazio | 2043354 | 12056 | 0 | 41.89277044 | 12.48366722 | 2022-09-18 04:22:50 | Lazio, Italy | |||
2355436 | 2355436 | 2022-09-16 | Italy | Lazio | 2041826 | 12053 | 0 | 41.89277044 | 12.48366722 | 2022-09-17 04:20:19 | Lazio, Italy | |||
3986593 | 3986593 | 2022-09-15 | Italy | Lazio | 2040339 | 12049 | 0 | 41.89277044 | 12.48366722 | 2022-09-16 04:21:19 | Lazio, Italy | |||
1889110 | 1889110 | 2022-09-14 | Italy | Lazio | 2038728 | 12046 | 0 | 41.89277044 | 12.48366722 | 2022-09-15 04:21:02 | Lazio, Italy | |||
372165 | 372165 | 2022-09-13 | Italy | Lazio | 2037175 | 12042 | 0 | 41.89277044 | 12.48366722 | 2022-09-14 04:20:44 | Lazio, Italy | |||
2394770 | 2394770 | 2022-09-12 | Italy | Lazio | 2035062 | 12039 | 0 | 41.89277044 | 12.48366722 | 2022-09-13 04:20:57 | Lazio, Italy | |||
3765848 | 3765848 | 2022-09-11 | Italy | Lazio | 2034321 | 12037 | 0 | 41.89277044 | 12.48366722 | 2022-09-12 04:20:58 | Lazio, Italy | |||
3824423 | 3824423 | 2022-09-10 | Italy | Lazio | 2033065 | 12036 | 0 | 41.89277044 | 12.48366722 | 2022-09-11 04:20:50 | Lazio, Italy | |||
962880 | 962880 | 2022-09-09 | Italy | Lazio | 2031686 | 12034 | 0 | 41.89277044 | 12.48366722 | 2022-09-10 04:21:10 | Lazio, Italy | |||
253282 | 253282 | 2022-09-08 | Italy | Lazio | 2030301 | 12028 | 0 | 41.89277044 | 12.48366722 | 2022-09-09 04:21:11 | Lazio, Italy | |||
3745080 | 3745080 | 2022-09-07 | Italy | Lazio | 2028924 | 12026 | 0 | 41.89277044 | 12.48366722 | 2022-09-08 04:21:02 | Lazio, Italy | |||
114720 | 114720 | 2022-09-06 | Italy | Lazio | 2027412 | 12023 | 0 | 41.89277044 | 12.48366722 | 2022-09-07 04:20:59 | Lazio, Italy | |||
2633692 | 2633692 | 2022-09-05 | Italy | Lazio | 2025281 | 12013 | 0 | 41.89277044 | 12.48366722 | 2022-09-06 04:21:02 | Lazio, Italy | |||
2987256 | 2987256 | 2022-09-04 | Italy | Lazio | 2024505 | 12006 | 0 | 41.89277044 | 12.48366722 | 2022-09-05 04:21:01 | Lazio, Italy | |||
2712941 | 2712941 | 2022-09-03 | Italy | Lazio | 2023324 | 12003 | 0 | 41.89277044 | 12.48366722 | 2022-09-04 04:21:22 | Lazio, Italy | |||
1393646 | 1393646 | 2022-09-02 | Italy | Lazio | 2021881 | 12002 | 0 | 41.89277044 | 12.48366722 | 2022-09-03 04:21:04 | Lazio, Italy | |||
3547475 | 3547475 | 2022-09-01 | Italy | Lazio | 2020463 | 11999 | 0 | 41.89277044 | 12.48366722 | 2022-09-02 04:21:07 | Lazio, Italy | |||
2343395 | 2343395 | 2022-08-31 | Italy | Lazio | 2018765 | 11992 | 0 | 41.89277044 | 12.48366722 | 2022-09-01 04:21:03 | Lazio, Italy | |||
3773875 | 3773875 | 2022-08-30 | Italy | Lazio | 2017126 | 11986 | 0 | 41.89277044 | 12.48366722 | 2022-08-31 04:20:57 | Lazio, Italy | |||
1680471 | 1680471 | 2022-08-29 | Italy | Lazio | 2014764 | 11980 | 0 | 41.89277044 | 12.48366722 | 2022-08-30 04:21:03 | Lazio, Italy | |||
1876955 | 1876955 | 2022-08-28 | Italy | Lazio | 2013945 | 11973 | 0 | 41.89277044 | 12.48366722 | 2022-08-29 04:21:06 | Lazio, Italy | |||
2096082 | 2096082 | 2022-08-27 | Italy | Lazio | 2012400 | 11972 | 0 | 41.89277044 | 12.48366722 | 2022-08-28 04:21:02 | Lazio, Italy | |||
1531897 | 1531897 | 2022-08-26 | Italy | Lazio | 2010737 | 11967 | 0 | 41.89277044 | 12.48366722 | 2022-08-27 04:20:57 | Lazio, Italy | |||
2828784 | 2828784 | 2022-08-25 | Italy | Lazio | 2009161 | 11959 | 0 | 41.89277044 | 12.48366722 | 2022-08-26 04:21:02 | Lazio, Italy | |||
2323317 | 2323317 | 2022-08-24 | Italy | Lazio | 2007462 | 11955 | 0 | 41.89277044 | 12.48366722 | 2022-08-25 04:21:13 | Lazio, Italy | |||
1250726 | 1250726 | 2022-08-23 | Italy | Lazio | 2005638 | 11952 | 0 | 41.89277044 | 12.48366722 | 2022-08-24 04:20:46 | Lazio, Italy | |||
2852830 | 2852830 | 2022-08-22 | Italy | Lazio | 2003083 | 11944 | 0 | 41.89277044 | 12.48366722 | 2022-08-23 04:20:56 | Lazio, Italy | |||
2402802 | 2402802 | 2022-08-21 | Italy | Lazio | 2002201 | 11938 | 0 | 41.89277044 | 12.48366722 | 2022-08-22 04:20:38 | Lazio, Italy | |||
3797880 | 3797880 | 2022-08-20 | Italy | Lazio | 2000637 | 11938 | 0 | 41.89277044 | 12.48366722 | 2022-08-21 04:20:44 | Lazio, Italy | |||
2363466 | 2363466 | 2022-08-19 | Italy | Lazio | 1998880 | 11934 | 0 | 41.89277044 | 12.48366722 | 2022-08-20 04:21:01 | Lazio, Italy | |||
1161137 | 1161137 | 2022-08-18 | Italy | Lazio | 1997078 | 11924 | 0 | 41.89277044 | 12.48366722 | 2022-08-19 04:20:54 | Lazio, Italy | |||
3950461 | 3950461 | 2022-08-17 | Italy | Lazio | 1995126 | 11918 | 0 | 41.89277044 | 12.48366722 | 2022-08-18 04:21:11 | Lazio, Italy | |||
990963 | 990963 | 2022-08-16 | Italy | Lazio | 1992345 | 11897 | 0 | 41.89277044 | 12.48366722 | 2022-08-17 04:20:59 | Lazio, Italy | |||
2494002 | 2494002 | 2022-08-15 | Italy | Lazio | 1991731 | 11892 | 0 | 41.89277044 | 12.48366722 | 2022-08-16 04:20:58 | Lazio, Italy | |||
3647552 | 3647552 | 2022-08-14 | Italy | Lazio | 1990714 | 11888 | 0 | 41.89277044 | 12.48366722 | 2022-08-15 04:20:59 | Lazio, Italy | |||
1968558 | 1968558 | 2022-08-13 | Italy | Lazio | 1988856 | 11881 | 0 | 41.89277044 | 12.48366722 | 2022-08-14 04:20:55 | Lazio, Italy | |||
2888367 | 2888367 | 2022-08-12 | Italy | Lazio | 1986995 | 11878 | 0 | 41.89277044 | 12.48366722 | 2022-08-13 04:20:52 | Lazio, Italy | |||
3907972 | 3907972 | 2022-08-11 | Italy | Lazio | 1984889 | 11873 | 0 | 41.89277044 | 12.48366722 | 2022-08-12 04:20:54 | Lazio, Italy | |||
1346289 | 1346289 | 2022-08-10 | Italy | Lazio | 1982528 | 11859 | 0 | 41.89277044 | 12.48366722 | 2022-08-11 04:20:49 | Lazio, Italy | |||
1086044 | 1086044 | 2022-08-09 | Italy | Lazio | 1980113 | 11849 | 0 | 41.89277044 | 12.48366722 | 2022-08-10 04:20:57 | Lazio, Italy | |||
3543459 | 3543459 | 2022-08-08 | Italy | Lazio | 1976780 | 11839 | 0 | 41.89277044 | 12.48366722 | 2022-08-09 04:20:34 | Lazio, Italy | |||
1069862 | 1069862 | 2022-08-07 | Italy | Lazio | 1975446 | 11831 | 0 | 41.89277044 | 12.48366722 | 2022-08-08 04:21:08 | Lazio, Italy | |||
1940450 | 1940450 | 2022-08-06 | Italy | Lazio | 1972985 | 11827 | 0 | 41.89277044 | 12.48366722 | 2022-08-07 04:20:54 | Lazio, Italy | |||
880249 | 880249 | 2022-08-05 | Italy | Lazio | 1970186 | 11820 | 0 | 41.89277044 | 12.48366722 | 2022-08-06 04:20:56 | Lazio, Italy | |||
2008660 | 2008660 | 2022-08-04 | Italy | Lazio | 1966965 | 11813 | 0 | 41.89277044 | 12.48366722 | 2022-08-05 04:20:52 | Lazio, Italy | |||
1098087 | 1098087 | 2022-08-03 | Italy | Lazio | 1963404 | 11806 | 0 | 41.89277044 | 12.48366722 | 2022-08-04 04:20:58 | Lazio, Italy | |||
1405012 | 1405012 | 2022-08-02 | Italy | Lazio | 1959357 | 11784 | 0 | 41.89277044 | 12.48366722 | 2022-08-03 04:20:59 | Lazio, Italy | |||
3617050 | 3617050 | 2022-08-01 | Italy | Lazio | 1954349 | 11766 | 0 | 41.89277044 | 12.48366722 | 2022-08-02 04:20:53 | Lazio, Italy | |||
3871530 | 3871530 | 2022-07-31 | Italy | Lazio | 1952496 | 11751 | 0 | 41.89277044 | 12.48366722 | 2022-08-01 04:21:03 | Lazio, Italy | |||
674284 | 674284 | 2022-07-30 | Italy | Lazio | 1949201 | 11743 | 0 | 41.89277044 | 12.48366722 | 2022-07-31 04:21:02 | Lazio, Italy | |||
1783483 | 1783483 | 2022-07-29 | Italy | Lazio | 1945359 | 11735 | 0 | 41.89277044 | 12.48366722 | 2022-07-30 04:20:42 | Lazio, Italy | |||
1065846 | 1065846 | 2022-07-28 | Italy | Lazio | 1941401 | 11719 | 0 | 41.89277044 | 12.48366722 | 2022-07-29 04:20:45 | Lazio, Italy | |||
2335365 | 2335365 | 2022-07-27 | Italy | Lazio | 1936792 | 11703 | 0 | 41.89277044 | 12.48366722 | 2022-07-28 04:20:56 | Lazio, Italy | |||
1487555 | 1487555 | 2022-07-26 | Italy | Lazio | 1931868 | 11690 | 0 | 41.89277044 | 12.48366722 | 2022-07-27 04:21:04 | Lazio, Italy | |||
2594001 | 2594001 | 2022-07-25 | Italy | Lazio | 1924976 | 11680 | 0 | 41.89277044 | 12.48366722 | 2022-07-26 04:20:58 | Lazio, Italy | |||
896116 | 896116 | 2022-07-24 | Italy | Lazio | 1922660 | 11664 | 0 | 41.89277044 | 12.48366722 | 2022-07-25 04:20:51 | Lazio, Italy | |||
91110 | 91110 | 2022-07-23 | Italy | Lazio | 1917883 | 11661 | 0 | 41.89277044 | 12.48366722 | 2022-07-24 04:20:47 | Lazio, Italy | |||
900132 | 900132 | 2022-07-22 | Italy | Lazio | 1911518 | 11654 | 0 | 41.89277044 | 12.48366722 | 2022-07-23 04:20:53 | Lazio, Italy | |||
670268 | 670268 | 2022-07-21 | Italy | Lazio | 1905410 | 11643 | 0 | 41.89277044 | 12.48366722 | 2022-07-22 04:21:15 | Lazio, Italy | |||
1608231 | 1608231 | 2022-07-20 | Italy | Lazio | 1898577 | 11634 | 0 | 41.89277044 | 12.48366722 | 2022-07-21 04:21:10 | Lazio, Italy | |||
958864 | 958864 | 2022-07-19 | Italy | Lazio | 1891425 | 11629 | 0 | 41.89277044 | 12.48366722 | 2022-07-20 04:20:59 | Lazio, Italy | |||
3210251 | 3210251 | 2022-07-18 | Italy | Lazio | 1881206 | 11620 | 0 | 41.89277044 | 12.48366722 | 2022-07-19 04:20:58 | Lazio, Italy | |||
3405426 | 3405426 | 2022-07-17 | Italy | Lazio | 1877498 | 11606 | 0 | 41.89277044 | 12.48366722 | 2022-07-18 04:20:59 | Lazio, Italy | |||
2151626 | 2151626 | 2022-07-16 | Italy | Lazio | 1870621 | 11598 | 0 | 41.89277044 | 12.48366722 | 2022-07-17 04:21:15 | Lazio, Italy | |||
2418859 | 2418859 | 2022-07-15 | Italy | Lazio | 1861538 | 11591 | 0 | 41.89277044 | 12.48366722 | 2022-07-16 04:21:05 | Lazio, Italy | |||
3428934 | 3428934 | 2022-07-14 | Italy | Lazio | 1853026 | 11583 | 0 | 41.89277044 | 12.48366722 | 2022-07-15 04:20:53 | Lazio, Italy | |||
3109454 | 3109454 | 2022-07-13 | Italy | Lazio | 1843278 | 11574 | 0 | 41.89277044 | 12.48366722 | 2022-07-14 04:20:57 | Lazio, Italy | |||
629877 | 629877 | 2022-07-12 | Italy | Lazio | 1833216 | 11559 | 0 | 41.89277044 | 12.48366722 | 2022-07-13 04:20:58 | Lazio, Italy | |||
1211521 | 1211521 | 2022-07-11 | Italy | Lazio | 1819830 | 11548 | 0 | 41.89277044 | 12.48366722 | 2022-07-12 04:20:51 | Lazio, Italy | |||
2789003 | 2789003 | 2022-07-10 | Italy | Lazio | 1815393 | 11541 | 0 | 41.89277044 | 12.48366722 | 2022-07-11 04:20:46 | Lazio, Italy | |||
141956 | 141956 | 2022-07-09 | Italy | Lazio | 1805846 | 11536 | 0 | 41.89277044 | 12.48366722 | 2022-07-10 04:20:54 | Lazio, Italy | |||
1417056 | 1417056 | 2022-07-08 | Italy | Lazio | 1796038 | 11528 | 0 | 41.89277044 | 12.48366722 | 2022-07-09 04:20:59 | Lazio, Italy | |||
2740981 | 2740981 | 2022-07-07 | Italy | Lazio | 1785930 | 11514 | 0 | 41.89277044 | 12.48366722 | 2022-07-08 04:20:56 | Lazio, Italy | |||
1199776 | 1199776 | 2022-07-06 | Italy | Lazio | 1774597 | 11509 | 0 | 41.89277044 | 12.48366722 | 2022-07-07 04:20:55 | Lazio, Italy | |||
3966519 | 3966519 | 2022-07-05 | Italy | Lazio | 1763340 | 11502 | 0 | 41.89277044 | 12.48366722 | 2022-07-06 04:20:58 | Lazio, Italy | |||
3078030 | 3078030 | 2022-07-04 | Italy | Lazio | 1749785 | 11490 | 0 | 41.89277044 | 12.48366722 | 2022-07-05 04:20:45 | Lazio, Italy | |||
1767312 | 1767312 | 2022-07-03 | Italy | Lazio | 1745008 | 11483 | 0 | 41.89277044 | 12.48366722 | 2022-07-04 04:20:54 | Lazio, Italy | |||
3365298 | 3365298 | 2022-07-02 | Italy | Lazio | 1736335 | 11481 | 0 | 41.89277044 | 12.48366722 | 2022-07-03 04:20:59 | Lazio, Italy | |||
593627 | 593627 | 2022-07-01 | Italy | Lazio | 1725968 | 11475 | 0 | 41.89277044 | 12.48366722 | 2022-07-02 04:21:16 | Lazio, Italy | |||
3940028 | 3940028 | 2022-06-30 | Italy | Lazio | 1714439 | 11466 | 0 | 41.89277044 | 12.48366722 | 2022-07-01 04:21:10 | Lazio, Italy | |||
2489986 | 2489986 | 2022-06-29 | Italy | Lazio | 1706683 | 11461 | 0 | 41.89277044 | 12.48366722 | 2022-06-30 04:21:01 | Lazio, Italy | |||
2239368 | 2239368 | 2022-06-28 | Italy | Lazio | 1696834 | 11456 | 0 | 41.89277044 | 12.48366722 | 2022-06-29 04:20:59 | Lazio, Italy | |||
2147610 | 2147610 | 2022-06-27 | Italy | Lazio | 1685663 | 11451 | 0 | 41.89277044 | 12.48366722 | 2022-06-28 04:20:58 | Lazio, Italy | |||
475411 | 475411 | 2022-06-26 | Italy | Lazio | 1682040 | 11446 | 0 | 41.89277044 | 12.48366722 | 2022-06-27 04:21:00 | Lazio, Italy | |||
938786 | 938786 | 2022-06-25 | Italy | Lazio | 1675347 | 11444 | 0 | 41.89277044 | 12.48366722 | 2022-06-26 04:21:02 | Lazio, Italy | |||
3346606 | 3346606 | 2022-06-24 | Italy | Lazio | 1668355 | 11439 | 0 | 41.89277044 | 12.48366722 | 2022-06-25 04:20:57 | Lazio, Italy | |||
1648347 | 1648347 | 2022-06-23 | Italy | Lazio | 1661313 | 11436 | 0 | 41.89277044 | 12.48366722 | 2022-06-24 04:20:58 | Lazio, Italy | |||
2187582 | 2187582 | 2022-06-22 | Italy | Lazio | 1654434 | 11427 | 0 | 41.89277044 | 12.48366722 | 2022-06-23 04:20:55 | Lazio, Italy | |||
166013 | 166013 | 2022-06-21 | Italy | Lazio | 1647841 | 11421 | 0 | 41.89277044 | 12.48366722 | 2022-06-22 04:20:54 | Lazio, Italy | |||
1763296 | 1763296 | 2022-06-20 | Italy | Lazio | 1640292 | 11418 | 0 | 41.89277044 | 12.48366722 | 2022-06-21 04:20:56 | Lazio, Italy | |||
3269482 | 3269482 | 2022-06-19 | Italy | Lazio | 1637658 | 11412 | 0 | 41.89277044 | 12.48366722 | 2022-06-20 04:21:01 | Lazio, Italy | |||
3397394 | 3397394 | 2022-06-18 | Italy | Lazio | 1632851 | 11411 | 0 | 41.89277044 | 12.48366722 | 2022-06-19 04:20:51 | Lazio, Italy | |||
2311271 | 2311271 | 2022-06-17 | Italy | Lazio | 1627694 | 11406 | 0 | 41.89277044 | 12.48366722 | 2022-06-18 04:21:10 | Lazio, Italy | |||
558775 | 558775 | 2022-06-16 | Italy | Lazio | 1622868 | 11401 | 0 | 41.89277044 | 12.48366722 | 2022-06-17 04:20:56 | Lazio, Italy | |||
3982577 | 3982577 | 2022-06-15 | Italy | Lazio | 1618232 | 11398 | 0 | 41.89277044 | 12.48366722 | 2022-06-16 04:20:55 | Lazio, Italy | |||
946818 | 946818 | 2022-06-14 | Italy | Lazio | 1614702 | 11392 | 0 | 41.89277044 | 12.48366722 | 2022-06-15 04:20:54 | Lazio, Italy | |||
2979226 | 2979226 | 2022-06-13 | Italy | Lazio | 1609763 | 11386 | 0 | 41.89277044 | 12.48366722 | 2022-06-14 04:20:52 | Lazio, Italy |
Advanced export
JSON shape: default, array, newline-delimited
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] TEXT, [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]);