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 = "Basilicata" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
last_update (date) >30 ✖
- 2022-04-13 2
- 2022-05-26 2
- 2020-05-15 1
- 2020-05-16 1
- 2020-05-17 1
- 2020-05-18 1
- 2020-05-19 1
- 2020-05-20 1
- 2020-05-21 1
- 2020-05-22 1
- 2020-05-23 1
- 2020-05-24 1
- 2020-05-25 1
- 2020-05-26 1
- 2020-05-27 1
- 2020-05-28 1
- 2020-05-29 1
- 2020-05-30 1
- 2020-05-31 1
- 2020-06-01 1
- 2020-06-02 1
- 2020-06-03 1
- 2020-06-04 1
- 2020-06-05 1
- 2020-06-06 1
- 2020-06-07 1
- 2020-06-08 1
- 2020-06-09 1
- 2020-06-10 1
- 2020-06-11 1
- …
province_or_state 1
- Basilicata · 860 ✖
longitude 1 ✖
- 15.80514834 860
country_or_region 1
- Italy · 860 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2016687 | 2016687 | 2022-09-20 | Italy | Basilicata | 182198 | 985 | 0 | 40.63947052 | 15.80514834 | 2022-09-21 04:23:22 | Basilicata, Italy | |||
3570560 | 3570560 | 2022-09-19 | Italy | Basilicata | 181969 | 985 | 0 | 40.63947052 | 15.80514834 | 2022-09-20 04:22:48 | Basilicata, Italy | |||
419299 | 419299 | 2022-09-18 | Italy | Basilicata | 181895 | 985 | 0 | 40.63947052 | 15.80514834 | 2022-09-19 04:21:49 | Basilicata, Italy | |||
3373323 | 3373323 | 2022-09-17 | Italy | Basilicata | 181792 | 985 | 0 | 40.63947052 | 15.80514834 | 2022-09-18 04:22:50 | Basilicata, Italy | |||
2355431 | 2355431 | 2022-09-16 | Italy | Basilicata | 181639 | 985 | 0 | 40.63947052 | 15.80514834 | 2022-09-17 04:20:19 | Basilicata, Italy | |||
3986588 | 3986588 | 2022-09-15 | Italy | Basilicata | 181504 | 985 | 0 | 40.63947052 | 15.80514834 | 2022-09-16 04:21:19 | Basilicata, Italy | |||
1889105 | 1889105 | 2022-09-14 | Italy | Basilicata | 181358 | 984 | 0 | 40.63947052 | 15.80514834 | 2022-09-15 04:21:02 | Basilicata, Italy | |||
372160 | 372160 | 2022-09-13 | Italy | Basilicata | 181219 | 983 | 0 | 40.63947052 | 15.80514834 | 2022-09-14 04:20:44 | Basilicata, Italy | |||
2394765 | 2394765 | 2022-09-12 | Italy | Basilicata | 181024 | 982 | 0 | 40.63947052 | 15.80514834 | 2022-09-13 04:20:57 | Basilicata, Italy | |||
3765843 | 3765843 | 2022-09-11 | Italy | Basilicata | 180927 | 982 | 0 | 40.63947052 | 15.80514834 | 2022-09-12 04:20:58 | Basilicata, Italy | |||
3824418 | 3824418 | 2022-09-10 | Italy | Basilicata | 180806 | 981 | 0 | 40.63947052 | 15.80514834 | 2022-09-11 04:20:50 | Basilicata, Italy | |||
962875 | 962875 | 2022-09-09 | Italy | Basilicata | 180626 | 981 | 0 | 40.63947052 | 15.80514834 | 2022-09-10 04:21:10 | Basilicata, Italy | |||
253277 | 253277 | 2022-09-08 | Italy | Basilicata | 180475 | 981 | 0 | 40.63947052 | 15.80514834 | 2022-09-09 04:21:11 | Basilicata, Italy | |||
3745075 | 3745075 | 2022-09-07 | Italy | Basilicata | 180291 | 981 | 0 | 40.63947052 | 15.80514834 | 2022-09-08 04:21:02 | Basilicata, Italy | |||
114715 | 114715 | 2022-09-06 | Italy | Basilicata | 180127 | 981 | 0 | 40.63947052 | 15.80514834 | 2022-09-07 04:20:59 | Basilicata, Italy | |||
2633687 | 2633687 | 2022-09-05 | Italy | Basilicata | 179842 | 980 | 0 | 40.63947052 | 15.80514834 | 2022-09-06 04:21:02 | Basilicata, Italy | |||
2987251 | 2987251 | 2022-09-04 | Italy | Basilicata | 179734 | 980 | 0 | 40.63947052 | 15.80514834 | 2022-09-05 04:21:01 | Basilicata, Italy | |||
2712936 | 2712936 | 2022-09-03 | Italy | Basilicata | 179591 | 980 | 0 | 40.63947052 | 15.80514834 | 2022-09-04 04:21:22 | Basilicata, Italy | |||
1393641 | 1393641 | 2022-09-02 | Italy | Basilicata | 179373 | 980 | 0 | 40.63947052 | 15.80514834 | 2022-09-03 04:21:04 | Basilicata, Italy | |||
3547470 | 3547470 | 2022-09-01 | Italy | Basilicata | 179158 | 979 | 0 | 40.63947052 | 15.80514834 | 2022-09-02 04:21:07 | Basilicata, Italy | |||
2343390 | 2343390 | 2022-08-31 | Italy | Basilicata | 178905 | 979 | 0 | 40.63947052 | 15.80514834 | 2022-09-01 04:21:03 | Basilicata, Italy | |||
3773870 | 3773870 | 2022-08-30 | Italy | Basilicata | 178669 | 979 | 0 | 40.63947052 | 15.80514834 | 2022-08-31 04:20:57 | Basilicata, Italy | |||
1680466 | 1680466 | 2022-08-29 | Italy | Basilicata | 178251 | 979 | 0 | 40.63947052 | 15.80514834 | 2022-08-30 04:21:03 | Basilicata, Italy | |||
1876950 | 1876950 | 2022-08-28 | Italy | Basilicata | 178129 | 979 | 0 | 40.63947052 | 15.80514834 | 2022-08-29 04:21:06 | Basilicata, Italy | |||
2096077 | 2096077 | 2022-08-27 | Italy | Basilicata | 177938 | 979 | 0 | 40.63947052 | 15.80514834 | 2022-08-28 04:21:02 | Basilicata, Italy | |||
1531892 | 1531892 | 2022-08-26 | Italy | Basilicata | 177661 | 979 | 0 | 40.63947052 | 15.80514834 | 2022-08-27 04:20:57 | Basilicata, Italy | |||
2828779 | 2828779 | 2022-08-25 | Italy | Basilicata | 177347 | 979 | 0 | 40.63947052 | 15.80514834 | 2022-08-26 04:21:02 | Basilicata, Italy | |||
2323312 | 2323312 | 2022-08-24 | Italy | Basilicata | 177017 | 979 | 0 | 40.63947052 | 15.80514834 | 2022-08-25 04:21:13 | Basilicata, Italy | |||
1250721 | 1250721 | 2022-08-23 | Italy | Basilicata | 176703 | 979 | 0 | 40.63947052 | 15.80514834 | 2022-08-24 04:20:46 | Basilicata, Italy | |||
2852825 | 2852825 | 2022-08-22 | Italy | Basilicata | 176225 | 979 | 0 | 40.63947052 | 15.80514834 | 2022-08-23 04:20:56 | Basilicata, Italy | |||
2402797 | 2402797 | 2022-08-21 | Italy | Basilicata | 176086 | 979 | 0 | 40.63947052 | 15.80514834 | 2022-08-22 04:20:38 | Basilicata, Italy | |||
3797875 | 3797875 | 2022-08-20 | Italy | Basilicata | 175894 | 979 | 0 | 40.63947052 | 15.80514834 | 2022-08-21 04:20:44 | Basilicata, Italy | |||
2363461 | 2363461 | 2022-08-19 | Italy | Basilicata | 175542 | 979 | 0 | 40.63947052 | 15.80514834 | 2022-08-20 04:21:01 | Basilicata, Italy | |||
1161132 | 1161132 | 2022-08-18 | Italy | Basilicata | 175290 | 979 | 0 | 40.63947052 | 15.80514834 | 2022-08-19 04:20:54 | Basilicata, Italy | |||
3950456 | 3950456 | 2022-08-17 | Italy | Basilicata | 175005 | 979 | 0 | 40.63947052 | 15.80514834 | 2022-08-18 04:21:11 | Basilicata, Italy | |||
990958 | 990958 | 2022-08-16 | Italy | Basilicata | 174672 | 979 | 0 | 40.63947052 | 15.80514834 | 2022-08-17 04:20:59 | Basilicata, Italy | |||
2493997 | 2493997 | 2022-08-15 | Italy | Basilicata | 174545 | 979 | 0 | 40.63947052 | 15.80514834 | 2022-08-16 04:20:58 | Basilicata, Italy | |||
3647547 | 3647547 | 2022-08-14 | Italy | Basilicata | 174447 | 979 | 0 | 40.63947052 | 15.80514834 | 2022-08-15 04:20:59 | Basilicata, Italy | |||
1968553 | 1968553 | 2022-08-13 | Italy | Basilicata | 174282 | 978 | 0 | 40.63947052 | 15.80514834 | 2022-08-14 04:20:55 | Basilicata, Italy | |||
2888362 | 2888362 | 2022-08-12 | Italy | Basilicata | 174030 | 978 | 0 | 40.63947052 | 15.80514834 | 2022-08-13 04:20:52 | Basilicata, Italy | |||
3907967 | 3907967 | 2022-08-11 | Italy | Basilicata | 173772 | 978 | 0 | 40.63947052 | 15.80514834 | 2022-08-12 04:20:54 | Basilicata, Italy | |||
1346284 | 1346284 | 2022-08-10 | Italy | Basilicata | 173568 | 978 | 0 | 40.63947052 | 15.80514834 | 2022-08-11 04:20:49 | Basilicata, Italy | |||
1086039 | 1086039 | 2022-08-09 | Italy | Basilicata | 173337 | 978 | 0 | 40.63947052 | 15.80514834 | 2022-08-10 04:20:57 | Basilicata, Italy | |||
3543454 | 3543454 | 2022-08-08 | Italy | Basilicata | 172977 | 977 | 0 | 40.63947052 | 15.80514834 | 2022-08-09 04:20:34 | Basilicata, Italy | |||
1069857 | 1069857 | 2022-08-07 | Italy | Basilicata | 172848 | 977 | 0 | 40.63947052 | 15.80514834 | 2022-08-08 04:21:08 | Basilicata, Italy | |||
1940445 | 1940445 | 2022-08-06 | Italy | Basilicata | 172656 | 977 | 0 | 40.63947052 | 15.80514834 | 2022-08-07 04:20:54 | Basilicata, Italy | |||
880244 | 880244 | 2022-08-05 | Italy | Basilicata | 172368 | 975 | 0 | 40.63947052 | 15.80514834 | 2022-08-06 04:20:56 | Basilicata, Italy | |||
2008655 | 2008655 | 2022-08-04 | Italy | Basilicata | 172072 | 975 | 0 | 40.63947052 | 15.80514834 | 2022-08-05 04:20:52 | Basilicata, Italy | |||
1098082 | 1098082 | 2022-08-03 | Italy | Basilicata | 171714 | 974 | 0 | 40.63947052 | 15.80514834 | 2022-08-04 04:20:58 | Basilicata, Italy | |||
1405007 | 1405007 | 2022-08-02 | Italy | Basilicata | 171352 | 974 | 0 | 40.63947052 | 15.80514834 | 2022-08-03 04:20:59 | Basilicata, Italy | |||
3617045 | 3617045 | 2022-08-01 | Italy | Basilicata | 170758 | 974 | 0 | 40.63947052 | 15.80514834 | 2022-08-02 04:20:53 | Basilicata, Italy | |||
3871525 | 3871525 | 2022-07-31 | Italy | Basilicata | 170562 | 972 | 0 | 40.63947052 | 15.80514834 | 2022-08-01 04:21:03 | Basilicata, Italy | |||
674279 | 674279 | 2022-07-30 | Italy | Basilicata | 170227 | 971 | 0 | 40.63947052 | 15.80514834 | 2022-07-31 04:21:02 | Basilicata, Italy | |||
1783478 | 1783478 | 2022-07-29 | Italy | Basilicata | 169709 | 971 | 0 | 40.63947052 | 15.80514834 | 2022-07-30 04:20:42 | Basilicata, Italy | |||
1065841 | 1065841 | 2022-07-28 | Italy | Basilicata | 169177 | 970 | 0 | 40.63947052 | 15.80514834 | 2022-07-29 04:20:45 | Basilicata, Italy | |||
2335360 | 2335360 | 2022-07-27 | Italy | Basilicata | 168624 | 968 | 0 | 40.63947052 | 15.80514834 | 2022-07-28 04:20:56 | Basilicata, Italy | |||
1487550 | 1487550 | 2022-07-26 | Italy | Basilicata | 168029 | 964 | 0 | 40.63947052 | 15.80514834 | 2022-07-27 04:21:04 | Basilicata, Italy | |||
2593996 | 2593996 | 2022-07-25 | Italy | Basilicata | 167105 | 961 | 0 | 40.63947052 | 15.80514834 | 2022-07-26 04:20:58 | Basilicata, Italy | |||
896111 | 896111 | 2022-07-24 | Italy | Basilicata | 166829 | 961 | 0 | 40.63947052 | 15.80514834 | 2022-07-25 04:20:51 | Basilicata, Italy | |||
91105 | 91105 | 2022-07-23 | Italy | Basilicata | 166379 | 959 | 0 | 40.63947052 | 15.80514834 | 2022-07-24 04:20:47 | Basilicata, Italy | |||
900127 | 900127 | 2022-07-22 | Italy | Basilicata | 165688 | 956 | 0 | 40.63947052 | 15.80514834 | 2022-07-23 04:20:53 | Basilicata, Italy | |||
670263 | 670263 | 2022-07-21 | Italy | Basilicata | 165004 | 954 | 0 | 40.63947052 | 15.80514834 | 2022-07-22 04:21:15 | Basilicata, Italy | |||
1608226 | 1608226 | 2022-07-20 | Italy | Basilicata | 164157 | 954 | 0 | 40.63947052 | 15.80514834 | 2022-07-21 04:21:10 | Basilicata, Italy | |||
958859 | 958859 | 2022-07-19 | Italy | Basilicata | 163344 | 953 | 0 | 40.63947052 | 15.80514834 | 2022-07-20 04:20:59 | Basilicata, Italy | |||
3210246 | 3210246 | 2022-07-18 | Italy | Basilicata | 162024 | 952 | 0 | 40.63947052 | 15.80514834 | 2022-07-19 04:20:58 | Basilicata, Italy | |||
3405421 | 3405421 | 2022-07-17 | Italy | Basilicata | 161546 | 950 | 0 | 40.63947052 | 15.80514834 | 2022-07-18 04:20:59 | Basilicata, Italy | |||
2151621 | 2151621 | 2022-07-16 | Italy | Basilicata | 160946 | 950 | 0 | 40.63947052 | 15.80514834 | 2022-07-17 04:21:15 | Basilicata, Italy | |||
2418854 | 2418854 | 2022-07-15 | Italy | Basilicata | 160077 | 949 | 0 | 40.63947052 | 15.80514834 | 2022-07-16 04:21:05 | Basilicata, Italy | |||
3428929 | 3428929 | 2022-07-14 | Italy | Basilicata | 159088 | 948 | 0 | 40.63947052 | 15.80514834 | 2022-07-15 04:20:53 | Basilicata, Italy | |||
3109449 | 3109449 | 2022-07-13 | Italy | Basilicata | 157944 | 947 | 0 | 40.63947052 | 15.80514834 | 2022-07-14 04:20:57 | Basilicata, Italy | |||
629872 | 629872 | 2022-07-12 | Italy | Basilicata | 156905 | 946 | 0 | 40.63947052 | 15.80514834 | 2022-07-13 04:20:58 | Basilicata, Italy | |||
1211516 | 1211516 | 2022-07-11 | Italy | Basilicata | 155382 | 945 | 0 | 40.63947052 | 15.80514834 | 2022-07-12 04:20:51 | Basilicata, Italy | |||
2788998 | 2788998 | 2022-07-10 | Italy | Basilicata | 154843 | 942 | 0 | 40.63947052 | 15.80514834 | 2022-07-11 04:20:46 | Basilicata, Italy | |||
141951 | 141951 | 2022-07-09 | Italy | Basilicata | 154156 | 942 | 0 | 40.63947052 | 15.80514834 | 2022-07-10 04:20:54 | Basilicata, Italy | |||
1417051 | 1417051 | 2022-07-08 | Italy | Basilicata | 153154 | 941 | 0 | 40.63947052 | 15.80514834 | 2022-07-09 04:20:59 | Basilicata, Italy | |||
2740976 | 2740976 | 2022-07-07 | Italy | Basilicata | 152172 | 937 | 0 | 40.63947052 | 15.80514834 | 2022-07-08 04:20:56 | Basilicata, Italy | |||
1199771 | 1199771 | 2022-07-06 | Italy | Basilicata | 151110 | 937 | 0 | 40.63947052 | 15.80514834 | 2022-07-07 04:20:55 | Basilicata, Italy | |||
3966514 | 3966514 | 2022-07-05 | Italy | Basilicata | 150022 | 937 | 0 | 40.63947052 | 15.80514834 | 2022-07-06 04:20:58 | Basilicata, Italy | |||
3078025 | 3078025 | 2022-07-04 | Italy | Basilicata | 148657 | 936 | 0 | 40.63947052 | 15.80514834 | 2022-07-05 04:20:45 | Basilicata, Italy | |||
1767307 | 1767307 | 2022-07-03 | Italy | Basilicata | 148161 | 936 | 0 | 40.63947052 | 15.80514834 | 2022-07-04 04:20:54 | Basilicata, Italy | |||
3365293 | 3365293 | 2022-07-02 | Italy | Basilicata | 147595 | 936 | 0 | 40.63947052 | 15.80514834 | 2022-07-03 04:20:59 | Basilicata, Italy | |||
593622 | 593622 | 2022-07-01 | Italy | Basilicata | 146908 | 935 | 0 | 40.63947052 | 15.80514834 | 2022-07-02 04:21:16 | Basilicata, Italy | |||
3940023 | 3940023 | 2022-06-30 | Italy | Basilicata | 146224 | 934 | 0 | 40.63947052 | 15.80514834 | 2022-07-01 04:21:10 | Basilicata, Italy | |||
2489981 | 2489981 | 2022-06-29 | Italy | Basilicata | 145531 | 932 | 0 | 40.63947052 | 15.80514834 | 2022-06-30 04:21:01 | Basilicata, Italy | |||
2239363 | 2239363 | 2022-06-28 | Italy | Basilicata | 144990 | 932 | 0 | 40.63947052 | 15.80514834 | 2022-06-29 04:20:59 | Basilicata, Italy | |||
2147605 | 2147605 | 2022-06-27 | Italy | Basilicata | 144287 | 932 | 0 | 40.63947052 | 15.80514834 | 2022-06-28 04:20:58 | Basilicata, Italy | |||
475406 | 475406 | 2022-06-26 | Italy | Basilicata | 144007 | 932 | 0 | 40.63947052 | 15.80514834 | 2022-06-27 04:21:00 | Basilicata, Italy | |||
938781 | 938781 | 2022-06-25 | Italy | Basilicata | 143653 | 932 | 0 | 40.63947052 | 15.80514834 | 2022-06-26 04:21:02 | Basilicata, Italy | |||
3346601 | 3346601 | 2022-06-24 | Italy | Basilicata | 143217 | 932 | 0 | 40.63947052 | 15.80514834 | 2022-06-25 04:20:57 | Basilicata, Italy | |||
1648342 | 1648342 | 2022-06-23 | Italy | Basilicata | 142797 | 931 | 0 | 40.63947052 | 15.80514834 | 2022-06-24 04:20:58 | Basilicata, Italy | |||
2187577 | 2187577 | 2022-06-22 | Italy | Basilicata | 142381 | 930 | 0 | 40.63947052 | 15.80514834 | 2022-06-23 04:20:55 | Basilicata, Italy | |||
166008 | 166008 | 2022-06-21 | Italy | Basilicata | 141989 | 929 | 0 | 40.63947052 | 15.80514834 | 2022-06-22 04:20:54 | Basilicata, Italy | |||
1763291 | 1763291 | 2022-06-20 | Italy | Basilicata | 141463 | 929 | 0 | 40.63947052 | 15.80514834 | 2022-06-21 04:20:56 | Basilicata, Italy | |||
3269477 | 3269477 | 2022-06-19 | Italy | Basilicata | 141233 | 927 | 0 | 40.63947052 | 15.80514834 | 2022-06-20 04:21:01 | Basilicata, Italy | |||
3397389 | 3397389 | 2022-06-18 | Italy | Basilicata | 141009 | 927 | 0 | 40.63947052 | 15.80514834 | 2022-06-19 04:20:51 | Basilicata, Italy | |||
2311266 | 2311266 | 2022-06-17 | Italy | Basilicata | 140743 | 925 | 0 | 40.63947052 | 15.80514834 | 2022-06-18 04:21:10 | Basilicata, Italy | |||
558770 | 558770 | 2022-06-16 | Italy | Basilicata | 140466 | 925 | 0 | 40.63947052 | 15.80514834 | 2022-06-17 04:20:56 | Basilicata, Italy | |||
3982572 | 3982572 | 2022-06-15 | Italy | Basilicata | 140176 | 925 | 0 | 40.63947052 | 15.80514834 | 2022-06-16 04:20:55 | Basilicata, Italy | |||
946813 | 946813 | 2022-06-14 | Italy | Basilicata | 139943 | 925 | 0 | 40.63947052 | 15.80514834 | 2022-06-15 04:20:54 | Basilicata, Italy | |||
2979221 | 2979221 | 2022-06-13 | Italy | Basilicata | 139638 | 925 | 0 | 40.63947052 | 15.80514834 | 2022-06-14 04:20:52 | Basilicata, 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]);