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 = "Liguria" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3687450 | 3687450 | 2022-01-13 | Italy | Liguria | 205639 | 4694 | 0 | 44.41149315 | 8.9326992 | 2022-01-14 04:21:54 | Liguria, Italy | |||
3613034 | 3613034 | 2022-01-12 | Italy | Liguria | 199947 | 4685 | 0 | 44.41149315 | 8.9326992 | 2022-01-13 08:00:09 | Liguria, Italy | |||
1113559 | 1113559 | 2022-01-11 | Italy | Liguria | 193963 | 4676 | 0 | 44.41149315 | 8.9326992 | 2022-01-12 04:21:44 | Liguria, Italy | |||
1692287 | 1692287 | 2022-01-10 | Italy | Liguria | 184696 | 4667 | 0 | 44.41149315 | 8.9326992 | 2022-01-11 04:22:01 | Liguria, Italy | |||
126702 | 126702 | 2022-01-09 | Italy | Liguria | 166838 | 4662 | 0 | 44.41149315 | 8.9326992 | 2022-01-10 04:22:07 | Liguria, Italy | |||
1215537 | 1215537 | 2022-01-08 | Italy | Liguria | 165306 | 4659 | 0 | 44.41149315 | 8.9326992 | 2022-01-09 04:21:46 | Liguria, Italy | |||
1389630 | 1389630 | 2022-01-07 | Italy | Liguria | 162883 | 4650 | 0 | 44.41149315 | 8.9326992 | 2022-01-08 04:21:53 | Liguria, Italy | |||
2610017 | 2610017 | 2022-01-06 | Italy | Liguria | 160937 | 4644 | 0 | 44.41149315 | 8.9326992 | 2022-01-07 04:22:09 | Liguria, Italy | |||
1281959 | 1281959 | 2022-01-05 | Italy | Liguria | 157871 | 4635 | 0 | 44.41149315 | 8.9326992 | 2022-01-06 04:22:09 | Liguria, Italy | |||
1285975 | 1285975 | 2022-01-04 | Italy | Liguria | 155640 | 4626 | 0 | 44.41149315 | 8.9326992 | 2022-01-05 04:21:59 | Liguria, Italy | |||
1700319 | 1700319 | 2022-01-03 | Italy | Liguria | 153572 | 4596 | 0 | 44.41149315 | 8.9326992 | 2022-01-04 04:22:17 | Liguria, Italy | |||
3519402 | 3519402 | 2022-01-02 | Italy | Liguria | 152757 | 4591 | 0 | 44.41149315 | 8.9326992 | 2022-01-03 02:22:25 | Liguria, Italy | |||
2167532 | 2167532 | 2022-01-01 | Italy | Liguria | 151492 | 4587 | 0 | 44.41149315 | 8.9326992 | 2022-01-02 04:20:52 | Liguria, Italy | |||
2776963 | 2776963 | 2021-12-31 | Italy | Liguria | 149060 | 4586 | 0 | 44.41149315 | 8.9326992 | 2022-01-01 04:22:14 | Liguria, Italy | |||
3998620 | 3998620 | 2021-12-30 | Italy | Liguria | 146640 | 4581 | 0 | 44.41149315 | 8.9326992 | 2021-12-31 04:21:50 | Liguria, Italy | |||
1668427 | 1668427 | 2021-12-29 | Italy | Liguria | 144859 | 4571 | 0 | 44.41149315 | 8.9326992 | 2021-12-30 04:21:25 | Liguria, Italy | |||
1432536 | 1432536 | 2021-12-28 | Italy | Liguria | 143225 | 4567 | 0 | 44.41149315 | 8.9326992 | 2021-12-29 03:21:43 | Liguria, Italy | |||
730497 | 730497 | 2021-12-27 | Italy | Liguria | 142079 | 4555 | 0 | 44.41149315 | 8.9326992 | 2021-12-28 04:21:47 | Liguria, Italy | |||
2111669 | 2111669 | 2021-12-26 | Italy | Liguria | 141610 | 4553 | 0 | 44.41149315 | 8.9326992 | 2021-12-27 04:21:58 | Liguria, Italy | |||
3605041 | 3605041 | 2021-12-25 | Italy | Liguria | 140967 | 4552 | 0 | 44.41149315 | 8.9326992 | 2021-12-26 04:21:50 | Liguria, Italy | |||
2963359 | 2963359 | 2021-12-24 | Italy | Liguria | 139516 | 4550 | 0 | 44.41149315 | 8.9326992 | 2021-12-25 04:21:37 | Liguria, Italy | |||
3816391 | 3816391 | 2021-12-23 | Italy | Liguria | 138057 | 4547 | 0 | 44.41149315 | 8.9326992 | 2021-12-24 04:21:34 | Liguria, Italy | |||
798399 | 798399 | 2021-12-22 | Italy | Liguria | 136913 | 4542 | 0 | 44.41149315 | 8.9326992 | 2021-12-23 04:21:21 | Liguria, Italy | |||
3828439 | 3828439 | 2021-12-21 | Italy | Liguria | 135784 | 4533 | 0 | 44.41149315 | 8.9326992 | 2021-12-22 04:21:54 | Liguria, Italy | |||
1254742 | 1254742 | 2021-12-20 | Italy | Liguria | 134915 | 4526 | 0 | 44.41149315 | 8.9326992 | 2021-12-21 03:21:27 | Liguria, Italy | |||
2903685 | 2903685 | 2021-12-19 | Italy | Liguria | 134305 | 4520 | 0 | 44.41149315 | 8.9326992 | 2021-12-20 04:21:43 | Liguria, Italy | |||
1258758 | 1258758 | 2021-12-18 | Italy | Liguria | 133551 | 4516 | 0 | 44.41149315 | 8.9326992 | 2021-12-19 04:21:11 | Liguria, Italy | |||
2398786 | 2398786 | 2021-12-17 | Italy | Liguria | 132544 | 4512 | 0 | 44.41149315 | 8.9326992 | 2021-12-18 02:22:20 | Liguria, Italy | |||
1716324 | 1716324 | 2021-12-16 | Italy | Liguria | 131521 | 4507 | 0 | 44.41149315 | 8.9326992 | 2021-12-17 04:22:14 | Liguria, Italy | |||
3496158 | 3496158 | 2021-12-15 | Italy | Liguria | 130510 | 4503 | 0 | 44.41149315 | 8.9326992 | 2021-12-16 04:22:11 | Liguria, Italy | |||
2087943 | 2087943 | 2021-12-14 | Italy | Liguria | 129703 | 4501 | 0 | 44.41149315 | 8.9326992 | 2021-12-15 03:22:16 | Liguria, Italy | |||
782360 | 782360 | 2021-12-13 | Italy | Liguria | 129091 | 4496 | 0 | 44.41149315 | 8.9326992 | 2021-12-14 04:22:38 | Liguria, Italy | |||
1660395 | 1660395 | 2021-12-12 | Italy | Liguria | 128604 | 4494 | 0 | 44.41149315 | 8.9326992 | 2021-12-13 04:22:02 | Liguria, Italy | |||
1664411 | 1664411 | 2021-12-11 | Italy | Liguria | 128092 | 4489 | 0 | 44.41149315 | 8.9326992 | 2021-12-12 04:22:12 | Liguria, Italy | |||
3655563 | 3655563 | 2021-12-10 | Italy | Liguria | 127392 | 4485 | 0 | 44.41149315 | 8.9326992 | 2021-12-11 04:22:45 | Liguria, Italy | |||
1077894 | 1077894 | 2021-12-09 | Italy | Liguria | 126794 | 4484 | 0 | 44.41149315 | 8.9326992 | 2021-12-10 04:22:28 | Liguria, Italy | |||
550743 | 550743 | 2021-12-08 | Italy | Liguria | 126523 | 4483 | 0 | 44.41149315 | 8.9326992 | 2021-12-09 04:22:49 | Liguria, Italy | |||
404263 | 404263 | 2021-12-07 | Italy | Liguria | 125833 | 4478 | 0 | 44.41149315 | 8.9326992 | 2021-12-08 04:22:46 | Liguria, Italy | |||
1030345 | 1030345 | 2021-12-06 | Italy | Liguria | 125350 | 4472 | 0 | 44.41149315 | 8.9326992 | 2021-12-07 04:22:34 | Liguria, Italy | |||
1740508 | 1740508 | 2021-12-05 | Italy | Liguria | 125103 | 4470 | 0 | 44.41149315 | 8.9326992 | 2021-12-06 04:22:34 | Liguria, Italy | |||
137940 | 137940 | 2021-12-04 | Italy | Liguria | 124617 | 4470 | 0 | 44.41149315 | 8.9326992 | 2021-12-05 04:22:25 | Liguria, Italy | |||
2195593 | 2195593 | 2021-12-03 | Italy | Liguria | 124127 | 4470 | 0 | 44.41149315 | 8.9326992 | 2021-12-04 04:22:18 | Liguria, Italy | |||
299 | 299 | 2021-12-02 | Italy | Liguria | 123548 | 4468 | 0 | 44.41149315 | 8.9326992 | 2021-12-03 04:23:05 | Liguria, Italy | |||
1144898 | 1144898 | 2021-12-01 | Italy | Liguria | 122948 | 4468 | 0 | 44.41149315 | 8.9326992 | 2021-12-02 04:22:37 | Liguria, Italy | |||
3401410 | 3401410 | 2021-11-30 | Italy | Liguria | 122399 | 4465 | 0 | 44.41149315 | 8.9326992 | 2021-12-01 04:22:29 | Liguria, Italy | |||
149953 | 149953 | 2021-11-29 | Italy | Liguria | 122013 | 4462 | 0 | 44.41149315 | 8.9326992 | 2021-11-30 04:22:53 | Liguria, Italy | |||
1231599 | 1231599 | 2021-11-28 | Italy | Liguria | 121878 | 4460 | 0 | 44.41149315 | 8.9326992 | 2021-11-29 04:22:30 | Liguria, Italy | |||
1358306 | 1358306 | 2021-11-27 | Italy | Liguria | 121461 | 4458 | 0 | 44.41149315 | 8.9326992 | 2021-11-28 04:22:43 | Liguria, Italy | |||
758297 | 758297 | 2021-11-26 | Italy | Liguria | 121101 | 4458 | 0 | 44.41149315 | 8.9326992 | 2021-11-27 04:22:45 | Liguria, Italy | |||
1802714 | 1802714 | 2021-11-25 | Italy | Liguria | 120641 | 4456 | 0 | 44.41149315 | 8.9326992 | 2021-11-26 04:22:33 | Liguria, Italy | |||
904148 | 904148 | 2021-11-24 | Italy | Liguria | 120181 | 4453 | 0 | 44.41149315 | 8.9326992 | 2021-11-25 04:22:33 | Liguria, Italy | |||
3069998 | 3069998 | 2021-11-23 | Italy | Liguria | 119769 | 4451 | 0 | 44.41149315 | 8.9326992 | 2021-11-24 04:22:14 | Liguria, Italy | |||
3749096 | 3749096 | 2021-11-22 | Italy | Liguria | 119419 | 4448 | 0 | 44.41149315 | 8.9326992 | 2021-11-23 04:22:39 | Liguria, Italy | |||
1014303 | 1014303 | 2021-11-21 | Italy | Liguria | 119282 | 4446 | 0 | 44.41149315 | 8.9326992 | 2021-11-22 04:22:20 | Liguria, Italy | |||
722467 | 722467 | 2021-11-20 | Italy | Liguria | 118969 | 4446 | 0 | 44.41149315 | 8.9326992 | 2021-11-21 04:22:13 | Liguria, Italy | |||
161997 | 161997 | 2021-11-19 | Italy | Liguria | 118632 | 4445 | 0 | 44.41149315 | 8.9326992 | 2021-11-20 04:22:17 | Liguria, Italy | |||
3288884 | 3288884 | 2021-11-18 | Italy | Liguria | 118281 | 4444 | 0 | 44.41149315 | 8.9326992 | 2021-11-19 04:21:40 | Liguria, Italy | |||
447340 | 447340 | 2021-11-17 | Italy | Liguria | 117966 | 4444 | 0 | 44.41149315 | 8.9326992 | 2021-11-18 04:21:33 | Liguria, Italy | |||
3342590 | 3342590 | 2021-11-16 | Italy | Liguria | 117695 | 4441 | 0 | 44.41149315 | 8.9326992 | 2021-11-17 04:21:48 | Liguria, Italy | |||
2287426 | 2287426 | 2021-11-15 | Italy | Liguria | 117476 | 4441 | 0 | 44.41149315 | 8.9326992 | 2021-11-16 04:21:10 | Liguria, Italy | |||
1322200 | 1322200 | 2021-11-14 | Italy | Liguria | 117327 | 4441 | 0 | 44.41149315 | 8.9326992 | 2021-11-15 04:21:36 | Liguria, Italy | |||
686326 | 686326 | 2021-11-13 | Italy | Liguria | 117134 | 4440 | 0 | 44.41149315 | 8.9326992 | 2021-11-14 04:21:31 | Liguria, Italy | |||
714435 | 714435 | 2021-11-12 | Italy | Liguria | 116902 | 4439 | 0 | 44.41149315 | 8.9326992 | 2021-11-13 04:21:38 | Liguria, Italy | |||
28385 | 28385 | 2021-11-11 | Italy | Liguria | 116667 | 4435 | 0 | 44.41149315 | 8.9326992 | 2021-11-12 04:22:01 | Liguria, Italy | |||
2844824 | 2844824 | 2021-11-10 | Italy | Liguria | 116309 | 4433 | 0 | 44.41149315 | 8.9326992 | 2021-11-11 04:21:45 | Liguria, Italy | |||
87094 | 87094 | 2021-11-09 | Italy | Liguria | 115878 | 4432 | 0 | 44.41149315 | 8.9326992 | 2021-11-10 04:21:38 | Liguria, Italy | |||
3639522 | 3639522 | 2021-11-08 | Italy | Liguria | 115676 | 4432 | 0 | 44.41149315 | 8.9326992 | 2021-11-09 04:21:36 | Liguria, Italy | |||
2000630 | 2000630 | 2021-11-07 | Italy | Liguria | 115623 | 4430 | 0 | 44.41149315 | 8.9326992 | 2021-11-08 04:21:43 | Liguria, Italy | |||
495621 | 495621 | 2021-11-06 | Italy | Liguria | 115555 | 4430 | 0 | 44.41149315 | 8.9326992 | 2021-11-07 04:21:53 | Liguria, Italy | |||
3121476 | 3121476 | 2021-11-05 | Italy | Liguria | 115425 | 4430 | 0 | 44.41149315 | 8.9326992 | 2021-11-06 04:21:51 | Liguria, Italy | |||
698374 | 698374 | 2021-11-04 | Italy | Liguria | 115307 | 4430 | 0 | 44.41149315 | 8.9326992 | 2021-11-05 04:21:54 | Liguria, Italy | |||
276152 | 276152 | 2021-11-03 | Italy | Liguria | 115216 | 4429 | 0 | 44.41149315 | 8.9326992 | 2021-11-04 04:22:20 | Liguria, Italy | |||
43677 | 43677 | 2021-11-02 | Italy | Liguria | 115065 | 4428 | 0 | 44.41149315 | 8.9326992 | 2021-11-03 06:22:09 | Liguria, Italy | |||
3511373 | 3511373 | 2021-11-01 | Italy | Liguria | 114981 | 4426 | 0 | 44.41149315 | 8.9326992 | 2021-11-02 04:22:03 | Liguria, Italy | |||
287965 | 287965 | 2021-10-31 | Italy | Liguria | 114916 | 4426 | 0 | 44.41149315 | 8.9326992 | 2021-11-01 04:22:01 | Liguria, Italy | |||
2720971 | 2720971 | 2021-10-30 | Italy | Liguria | 114818 | 4426 | 0 | 44.41149315 | 8.9326992 | 2021-10-31 04:22:08 | Liguria, Italy | |||
567073 | 567073 | 2021-10-29 | Italy | Liguria | 114707 | 4426 | 0 | 44.41149315 | 8.9326992 | 2021-10-30 04:22:03 | Liguria, Italy | |||
4315 | 4315 | 2021-10-28 | Italy | Liguria | 114521 | 4425 | 0 | 44.41149315 | 8.9326992 | 2021-10-29 04:22:03 | Liguria, Italy | |||
534705 | 534705 | 2021-10-27 | Italy | Liguria | 114415 | 4425 | 0 | 44.41149315 | 8.9326992 | 2021-10-28 04:22:08 | Liguria, Italy | |||
3492142 | 3492142 | 2021-10-26 | Italy | Liguria | 114352 | 4423 | 0 | 44.41149315 | 8.9326992 | 2021-10-27 04:22:32 | Liguria, Italy | |||
3793864 | 3793864 | 2021-10-25 | Italy | Liguria | 114278 | 4422 | 0 | 44.41149315 | 8.9326992 | 2021-10-26 04:22:09 | Liguria, Italy | |||
682310 | 682310 | 2021-10-24 | Italy | Liguria | 114232 | 4421 | 0 | 44.41149315 | 8.9326992 | 2021-10-25 04:22:31 | Liguria, Italy | |||
770318 | 770318 | 2021-10-23 | Italy | Liguria | 114170 | 4420 | 0 | 44.41149315 | 8.9326992 | 2021-10-24 04:21:22 | Liguria, Italy | |||
653965 | 653965 | 2021-10-22 | Italy | Liguria | 114101 | 4420 | 0 | 44.41149315 | 8.9326992 | 2021-10-23 04:21:32 | Liguria, Italy | |||
2123712 | 2123712 | 2021-10-21 | Italy | Liguria | 114015 | 4420 | 0 | 44.41149315 | 8.9326992 | 2021-10-22 04:21:14 | Liguria, Italy | |||
443324 | 443324 | 2021-10-20 | Italy | Liguria | 113921 | 4419 | 0 | 44.41149315 | 8.9326992 | 2021-10-21 04:21:18 | Liguria, Italy | |||
597643 | 597643 | 2021-10-19 | Italy | Liguria | 113863 | 4418 | 0 | 44.41149315 | 8.9326992 | 2021-10-20 04:21:00 | Liguria, Italy | |||
2043820 | 2043820 | 2021-10-18 | Italy | Liguria | 113797 | 4418 | 0 | 44.41149315 | 8.9326992 | 2021-10-19 04:20:54 | Liguria, Italy | |||
1909181 | 1909181 | 2021-10-17 | Italy | Liguria | 113762 | 4418 | 0 | 44.41149315 | 8.9326992 | 2021-10-18 04:21:10 | Liguria, Italy | |||
934770 | 934770 | 2021-10-16 | Italy | Liguria | 113707 | 4417 | 0 | 44.41149315 | 8.9326992 | 2021-10-17 04:21:29 | Liguria, Italy | |||
2943325 | 2943325 | 2021-10-15 | Italy | Liguria | 113643 | 4417 | 0 | 44.41149315 | 8.9326992 | 2021-10-16 04:21:15 | Liguria, Italy | |||
491605 | 491605 | 2021-10-14 | Italy | Liguria | 113574 | 4416 | 0 | 44.41149315 | 8.9326992 | 2021-10-15 04:21:26 | Liguria, Italy | |||
633893 | 633893 | 2021-10-13 | Italy | Liguria | 113508 | 4416 | 0 | 44.41149315 | 8.9326992 | 2021-10-14 04:21:29 | Liguria, Italy | |||
1491571 | 1491571 | 2021-10-12 | Italy | Liguria | 113430 | 4416 | 0 | 44.41149315 | 8.9326992 | 2021-10-13 04:20:51 | Liguria, Italy | |||
3007304 | 3007304 | 2021-10-11 | Italy | Liguria | 113371 | 4416 | 0 | 44.41149315 | 8.9326992 | 2021-10-12 04:21:09 | Liguria, Italy | |||
423320 | 423320 | 2021-10-10 | Italy | Liguria | 113352 | 4415 | 0 | 44.41149315 | 8.9326992 | 2021-10-11 04:21:31 | Liguria, Italy | |||
2876177 | 2876177 | 2021-10-09 | Italy | Liguria | 113282 | 4415 | 0 | 44.41149315 | 8.9326992 | 2021-10-10 04:21:38 | Liguria, Italy | |||
2959343 | 2959343 | 2021-10-08 | Italy | Liguria | 113217 | 4414 | 0 | 44.41149315 | 8.9326992 | 2021-10-09 04:21:34 | Liguria, Italy | |||
467381 | 467381 | 2021-10-07 | Italy | Liguria | 113147 | 4413 | 0 | 44.41149315 | 8.9326992 | 2021-10-08 04:21:25 | Liguria, Italy | |||
2458761 | 2458761 | 2021-10-06 | Italy | Liguria | 113078 | 4413 | 0 | 44.41149315 | 8.9326992 | 2021-10-07 04:21:36 | Liguria, 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]);