daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
20,264 rows where country_or_region = "Italy" sorted by combined_key
This data as json, yaml, Notebook, copyable, CSV (advanced)
day (date) >30 ✖
- 2020-05-14 21
- 2020-05-15 21
- 2020-05-16 21
- 2020-05-17 21
- 2020-05-18 21
- 2020-05-19 21
- 2020-05-20 21
- 2020-05-21 21
- 2020-05-22 21
- 2020-05-23 21
- 2020-05-24 21
- 2020-05-25 21
- 2020-05-26 21
- 2020-05-27 21
- 2020-05-28 21
- 2020-05-29 21
- 2020-05-30 21
- 2020-05-31 21
- 2020-06-01 21
- 2020-06-02 21
- 2020-06-03 21
- 2020-06-04 21
- 2020-06-05 21
- 2020-06-06 21
- 2020-06-07 21
- 2020-06-08 21
- 2020-06-09 21
- 2020-06-10 21
- 2020-06-11 21
- 2020-06-12 21
- …
province_or_state 21
- Abruzzo 960
- Basilicata 960
- Calabria 960
- Campania 960
- Emilia-Romagna 960
- Friuli Venezia Giulia 960
- Lazio 960
- Liguria 960
- Lombardia 960
- Marche 960
- Molise 960
- P.A. Bolzano 960
- P.A. Trento 960
- Piemonte 960
- Puglia 960
- Sardegna 960
- Sicilia 960
- Toscana 960
- Umbria 960
- Valle d'Aosta 960
- Veneto 960
country_or_region 1
- Italy · 20,264 ✖
day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2020-10-29 | Italy | Abruzzo | 9674 | 540 | 3690 | 5444 | 42.35122196 | 13.39843823 | 2020-10-30 04:24:49 | Abruzzo, Italy | ||
2020-06-08 | Italy | Abruzzo | 3265 | 418 | 2215 | 632 | 42.35122196 | 13.39843823 | 2020-06-09 03:33:03 | Abruzzo, Italy | ||
2022-12-26 | Italy | Abruzzo | 630829 | 3816 | 0 | 42.35122196 | 13.39843823 | 2022-12-27 04:21:07 | Abruzzo, Italy | |||
2022-05-09 | Italy | Abruzzo | 386656 | 3248 | 0 | 42.35122196 | 13.39843823 | 2022-05-10 04:20:50 | Abruzzo, Italy | |||
2022-05-31 | Italy | Abruzzo | 405872 | 3324 | 0 | 42.35122196 | 13.39843823 | 2022-06-01 04:20:55 | Abruzzo, Italy | |||
2022-02-11 | Italy | Abruzzo | 240673 | 2869 | 0 | 42.35122196 | 13.39843823 | 2022-02-12 04:21:06 | Abruzzo, Italy | |||
2021-01-18 | Italy | Abruzzo | 39422 | 1333 | 26707 | 11382 | 42.35122196 | 13.39843823 | 2021-01-19 05:22:15 | Abruzzo, Italy | ||
2021-04-02 | Italy | Abruzzo | 65931 | 2151 | 53440 | 10340 | 42.35122196 | 13.39843823 | 2021-04-03 04:20:44 | Abruzzo, Italy | ||
2021-08-17 | Italy | Abruzzo | 77649 | 2519 | 0 | 42.35122196 | 13.39843823 | 2021-08-18 04:21:35 | Abruzzo, Italy | |||
2021-09-04 | Italy | Abruzzo | 79490 | 2532 | 0 | 42.35122196 | 13.39843823 | 2021-09-05 04:21:33 | Abruzzo, Italy | |||
2022-09-08 | Italy | Abruzzo | 544623 | 3646 | 0 | 42.35122196 | 13.39843823 | 2022-09-09 04:21:11 | Abruzzo, Italy | |||
2022-12-10 | Italy | Abruzzo | 620055 | 3777 | 0 | 42.35122196 | 13.39843823 | 2022-12-11 04:20:50 | Abruzzo, Italy | |||
2022-03-15 | Italy | Abruzzo | 281689 | 3032 | 0 | 42.35122196 | 13.39843823 | 2022-03-16 04:20:50 | Abruzzo, Italy | |||
2020-05-21 | Italy | Abruzzo | 3212 | 391 | 1549 | 1272 | 42.35122196 | 13.39843823 | 2020-05-22 02:36:51 | Abruzzo, Italy | ||
2020-11-10 | Italy | Abruzzo | 15888 | 628 | 4832 | 10428 | 42.35122196 | 13.39843823 | 2020-11-11 05:25:30 | Abruzzo, Italy | ||
2021-11-03 | Italy | Abruzzo | 83157 | 2564 | 0 | 42.35122196 | 13.39843823 | 2021-11-04 04:22:20 | Abruzzo, Italy | |||
2021-02-24 | Italy | Abruzzo | 52299 | 1662 | 37917 | 12720 | 42.35122196 | 13.39843823 | 2021-02-25 05:24:57 | Abruzzo, Italy | ||
2020-06-15 | Italy | Abruzzo | 3279 | 456 | 2337 | 486 | 42.35122196 | 13.39843823 | 2020-06-16 04:33:09 | Abruzzo, Italy | ||
2021-10-31 | Italy | Abruzzo | 83001 | 2562 | 0 | 42.35122196 | 13.39843823 | 2021-11-01 04:22:01 | Abruzzo, Italy | |||
2022-11-15 | Italy | Abruzzo | 595025 | 3727 | 0 | 42.35122196 | 13.39843823 | 2022-11-16 04:21:09 | Abruzzo, Italy | |||
2021-07-15 | Italy | Abruzzo | 75285 | 2513 | 71844 | 928 | 42.35122196 | 13.39843823 | 2021-07-16 04:21:22 | Abruzzo, Italy | ||
2020-07-01 | Italy | Abruzzo | 3289 | 464 | 2655 | 170 | 42.35122196 | 13.39843823 | 2020-07-02 04:33:46 | Abruzzo, Italy | ||
2022-04-16 | Italy | Abruzzo | 345681 | 3160 | 0 | 42.35122196 | 13.39843823 | 2022-04-17 04:20:59 | Abruzzo, Italy | |||
2022-12-13 | Italy | Abruzzo | 620055 | 3777 | 0 | 42.35122196 | 13.39843823 | 2022-12-14 04:21:04 | Abruzzo, Italy | |||
2022-11-13 | Italy | Abruzzo | 595025 | 3727 | 0 | 42.35122196 | 13.39843823 | 2022-11-14 04:21:09 | Abruzzo, Italy | |||
2022-02-12 | Italy | Abruzzo | 242182 | 2874 | 0 | 42.35122196 | 13.39843823 | 2022-02-13 04:21:00 | Abruzzo, Italy | |||
2022-10-30 | Italy | Abruzzo | 587217 | 3708 | 0 | 42.35122196 | 13.39843823 | 2022-10-31 04:21:36 | Abruzzo, Italy | |||
2020-07-20 | Italy | Abruzzo | 3342 | 468 | 2753 | 121 | 42.35122196 | 13.39843823 | 2020-07-21 04:38:46 | Abruzzo, Italy | ||
2022-12-27 | Italy | Abruzzo | 630829 | 3816 | 0 | 42.35122196 | 13.39843823 | 2022-12-28 04:21:04 | Abruzzo, Italy | |||
2021-08-04 | Italy | Abruzzo | 76471 | 2515 | 72422 | 1534 | 42.35122196 | 13.39843823 | 2021-08-05 04:21:51 | Abruzzo, Italy | ||
2022-03-18 | Italy | Abruzzo | 287652 | 3038 | 0 | 42.35122196 | 13.39843823 | 2022-03-19 04:20:47 | Abruzzo, Italy | |||
2021-02-03 | Italy | Abruzzo | 43663 | 1482 | 32162 | 10019 | 42.35122196 | 13.39843823 | 2021-02-04 05:22:26 | Abruzzo, Italy | ||
2020-09-14 | Italy | Abruzzo | 4016 | 473 | 2966 | 577 | 42.35122196 | 13.39843823 | 2020-09-15 03:22:50 | Abruzzo, Italy | ||
2022-12-14 | Italy | Abruzzo | 620055 | 3777 | 0 | 42.35122196 | 13.39843823 | 2022-12-15 04:20:58 | Abruzzo, Italy | |||
2021-03-11 | Italy | Abruzzo | 58931 | 1872 | 44161 | 12898 | 42.35122196 | 13.39843823 | 2021-03-12 05:26:50 | Abruzzo, Italy | ||
2022-03-11 | Italy | Abruzzo | 275867 | 3019 | 0 | 42.35122196 | 13.39843823 | 2022-03-12 04:20:50 | Abruzzo, Italy | |||
2022-05-07 | Italy | Abruzzo | 384863 | 3246 | 0 | 42.35122196 | 13.39843823 | 2022-05-08 04:20:49 | Abruzzo, Italy | |||
2020-07-16 | Italy | Abruzzo | 3333 | 468 | 2745 | 120 | 42.35122196 | 13.39843823 | 2020-07-17 04:34:50 | Abruzzo, Italy | ||
2020-08-08 | Italy | Abruzzo | 3486 | 472 | 2817 | 197 | 42.35122196 | 13.39843823 | 2020-08-09 04:34:54 | Abruzzo, Italy | ||
2022-09-13 | Italy | Abruzzo | 547199 | 3651 | 0 | 42.35122196 | 13.39843823 | 2022-09-14 04:20:44 | Abruzzo, Italy | |||
2020-11-06 | Italy | Abruzzo | 13505 | 584 | 4340 | 8581 | 42.35122196 | 13.39843823 | 2020-11-07 05:24:52 | Abruzzo, Italy | ||
2021-04-30 | Italy | Abruzzo | 71218 | 2403 | 60432 | 8383 | 42.35122196 | 13.39843823 | 2021-05-01 04:20:47 | Abruzzo, Italy | ||
2022-09-23 | Italy | Abruzzo | 553180 | 3663 | 0 | 42.35122196 | 13.39843823 | 2022-09-24 04:21:40 | Abruzzo, Italy | |||
2021-04-04 | Italy | Abruzzo | 66594 | 2169 | 53697 | 10728 | 42.35122196 | 13.39843823 | 2021-04-05 04:20:35 | Abruzzo, Italy | ||
2020-11-27 | Italy | Abruzzo | 26525 | 868 | 8097 | 17560 | 42.35122196 | 13.39843823 | 2020-11-28 05:25:50 | Abruzzo, Italy | ||
2022-10-07 | Italy | Abruzzo | 567179 | 3677 | 0 | 42.35122196 | 13.39843823 | 2022-10-08 04:22:56 | Abruzzo, Italy | |||
2021-06-29 | Italy | Abruzzo | 74792 | 2512 | 71380 | 900 | 42.35122196 | 13.39843823 | 2021-06-30 04:21:41 | Abruzzo, Italy | ||
2021-12-07 | Italy | Abruzzo | 89384 | 2602 | 0 | 42.35122196 | 13.39843823 | 2021-12-08 04:22:46 | Abruzzo, Italy | |||
2021-07-28 | Italy | Abruzzo | 75946 | 2514 | 72133 | 1299 | 42.35122196 | 13.39843823 | 2021-07-29 04:21:33 | Abruzzo, Italy | ||
2020-07-05 | Italy | Abruzzo | 3309 | 464 | 2682 | 163 | 42.35122196 | 13.39843823 | 2020-07-06 04:33:57 | Abruzzo, Italy | ||
2022-09-18 | Italy | Abruzzo | 550017 | 3656 | 0 | 42.35122196 | 13.39843823 | 2022-09-19 04:21:49 | Abruzzo, Italy | |||
2021-10-10 | Italy | Abruzzo | 81624 | 2549 | 0 | 42.35122196 | 13.39843823 | 2021-10-11 04:21:31 | Abruzzo, Italy | |||
2020-09-07 | Italy | Abruzzo | 3906 | 472 | 2914 | 520 | 42.35122196 | 13.39843823 | 2020-09-08 04:28:25 | Abruzzo, Italy | ||
2022-11-03 | Italy | Abruzzo | 587217 | 3708 | 0 | 42.35122196 | 13.39843823 | 2022-11-04 04:22:11 | Abruzzo, Italy | |||
2021-01-21 | Italy | Abruzzo | 40025 | 1358 | 28007 | 10660 | 42.35122196 | 13.39843823 | 2021-01-22 05:22:10 | Abruzzo, Italy | ||
2020-07-26 | Italy | Abruzzo | 3359 | 470 | 2777 | 112 | 42.35122196 | 13.39843823 | 2020-07-27 04:35:02 | Abruzzo, Italy | ||
2021-10-20 | Italy | Abruzzo | 81994 | 2557 | 0 | 42.35122196 | 13.39843823 | 2021-10-21 04:21:18 | Abruzzo, Italy | |||
2021-11-17 | Italy | Abruzzo | 85127 | 2571 | 0 | 42.35122196 | 13.39843823 | 2021-11-18 04:21:33 | Abruzzo, Italy | |||
2022-12-21 | Italy | Abruzzo | 626122 | 3799 | 0 | 42.35122196 | 13.39843823 | 2022-12-22 04:20:56 | Abruzzo, Italy | |||
2020-08-07 | Italy | Abruzzo | 3474 | 472 | 2812 | 190 | 42.35122196 | 13.39843823 | 2020-08-08 04:34:53 | Abruzzo, Italy | ||
2022-02-02 | Italy | Abruzzo | 221638 | 2821 | 0 | 42.35122196 | 13.39843823 | 2022-02-03 04:21:21 | Abruzzo, Italy | |||
2022-05-02 | Italy | Abruzzo | 376218 | 3222 | 0 | 42.35122196 | 13.39843823 | 2022-05-03 04:21:00 | Abruzzo, Italy | |||
2021-10-07 | Italy | Abruzzo | 81530 | 2547 | 0 | 42.35122196 | 13.39843823 | 2021-10-08 04:21:25 | Abruzzo, Italy | |||
2021-02-19 | Italy | Abruzzo | 50204 | 1608 | 36219 | 12377 | 42.35122196 | 13.39843823 | 2021-02-20 05:22:51 | Abruzzo, Italy | ||
2022-06-26 | Italy | Abruzzo | 424610 | 3373 | 0 | 42.35122196 | 13.39843823 | 2022-06-27 04:21:00 | Abruzzo, Italy | |||
2022-11-08 | Italy | Abruzzo | 590221 | 3720 | 0 | 42.35122196 | 13.39843823 | 2022-11-09 04:21:22 | Abruzzo, Italy | |||
2021-07-19 | Italy | Abruzzo | 75407 | 2513 | 71904 | 990 | 42.35122196 | 13.39843823 | 2021-07-20 04:21:48 | Abruzzo, Italy | ||
2022-11-25 | Italy | Abruzzo | 606454 | 3756 | 0 | 42.35122196 | 13.39843823 | 2022-11-26 04:21:11 | Abruzzo, Italy | |||
2021-10-14 | Italy | Abruzzo | 81786 | 2550 | 0 | 42.35122196 | 13.39843823 | 2021-10-15 04:21:26 | Abruzzo, Italy | |||
2021-11-06 | Italy | Abruzzo | 83573 | 2565 | 0 | 42.35122196 | 13.39843823 | 2021-11-07 04:21:53 | Abruzzo, Italy | |||
2022-04-02 | Italy | Abruzzo | 319158 | 3098 | 0 | 42.35122196 | 13.39843823 | 2022-04-03 04:20:48 | Abruzzo, Italy | |||
2022-12-17 | Italy | Abruzzo | 626122 | 3799 | 0 | 42.35122196 | 13.39843823 | 2022-12-18 04:21:03 | Abruzzo, Italy | |||
2021-08-14 | Italy | Abruzzo | 77460 | 2518 | 0 | 42.35122196 | 13.39843823 | 2021-08-15 04:21:41 | Abruzzo, Italy | |||
2021-08-19 | Italy | Abruzzo | 77944 | 2519 | 0 | 42.35122196 | 13.39843823 | 2021-08-20 04:21:33 | Abruzzo, Italy | |||
2022-10-15 | Italy | Abruzzo | 575643 | 3687 | 0 | 42.35122196 | 13.39843823 | 2022-10-16 04:22:39 | Abruzzo, Italy | |||
2021-06-09 | Italy | Abruzzo | 74362 | 2498 | 70029 | 1835 | 42.35122196 | 13.39843823 | 2021-06-10 04:23:17 | Abruzzo, Italy | ||
2020-07-04 | Italy | Abruzzo | 3305 | 464 | 2682 | 159 | 42.35122196 | 13.39843823 | 2020-07-05 04:33:46 | Abruzzo, Italy | ||
2021-02-22 | Italy | Abruzzo | 51442 | 1628 | 36841 | 12973 | 42.35122196 | 13.39843823 | 2021-02-23 05:23:41 | Abruzzo, Italy | ||
2021-10-27 | Italy | Abruzzo | 82548 | 2559 | 0 | 42.35122196 | 13.39843823 | 2021-10-28 04:22:08 | Abruzzo, Italy | |||
2022-10-26 | Italy | Abruzzo | 584928 | 3704 | 0 | 42.35122196 | 13.39843823 | 2022-10-27 04:22:01 | Abruzzo, Italy | |||
2022-12-15 | Italy | Abruzzo | 620055 | 3777 | 0 | 42.35122196 | 13.39843823 | 2022-12-16 04:21:01 | Abruzzo, Italy | |||
2020-09-12 | Italy | Abruzzo | 3978 | 472 | 2962 | 544 | 42.35122196 | 13.39843823 | 2020-09-13 04:30:52 | Abruzzo, Italy | ||
2021-12-08 | Italy | Abruzzo | 89722 | 2605 | 0 | 42.35122196 | 13.39843823 | 2021-12-09 04:22:49 | Abruzzo, Italy | |||
2022-01-16 | Italy | Abruzzo | 166438 | 2699 | 0 | 42.35122196 | 13.39843823 | 2022-01-17 04:21:08 | Abruzzo, Italy | |||
2022-06-16 | Italy | Abruzzo | 414046 | 3356 | 0 | 42.35122196 | 13.39843823 | 2022-06-17 04:20:56 | Abruzzo, Italy | |||
2021-06-22 | Italy | Abruzzo | 74635 | 2509 | 70990 | 1136 | 42.35122196 | 13.39843823 | 2021-06-23 04:21:46 | Abruzzo, Italy | ||
2021-10-29 | Italy | Abruzzo | 82813 | 2559 | 0 | 42.35122196 | 13.39843823 | 2021-10-30 04:22:03 | Abruzzo, Italy | |||
2020-06-06 | Italy | Abruzzo | 3258 | 418 | 2187 | 653 | 42.35122196 | 13.39843823 | 2020-06-07 03:53:30 | Abruzzo, Italy | ||
2022-02-25 | Italy | Abruzzo | 260997 | 2947 | 0 | 42.35122196 | 13.39843823 | 2022-02-26 04:21:12 | Abruzzo, Italy | |||
2021-07-13 | Italy | Abruzzo | 75195 | 2512 | 71751 | 932 | 42.35122196 | 13.39843823 | 2021-07-14 04:21:35 | Abruzzo, Italy | ||
2020-08-13 | Italy | Abruzzo | 3532 | 472 | 2826 | 234 | 42.35122196 | 13.39843823 | 2020-08-14 04:51:19 | Abruzzo, Italy | ||
2021-08-08 | Italy | Abruzzo | 76881 | 2515 | 0 | 42.35122196 | 13.39843823 | 2021-08-09 04:21:24 | Abruzzo, Italy | |||
2022-07-01 | Italy | Abruzzo | 434219 | 3378 | 0 | 42.35122196 | 13.39843823 | 2022-07-02 04:21:16 | Abruzzo, Italy | |||
2021-10-19 | Italy | Abruzzo | 81940 | 2555 | 0 | 42.35122196 | 13.39843823 | 2021-10-20 04:21:00 | Abruzzo, Italy | |||
2021-09-23 | Italy | Abruzzo | 80863 | 2540 | 0 | 42.35122196 | 13.39843823 | 2021-09-24 04:21:44 | Abruzzo, Italy | |||
2021-04-09 | Italy | Abruzzo | 67506 | 2227 | 55076 | 10203 | 42.35122196 | 13.39843823 | 2021-04-10 04:20:59 | Abruzzo, Italy | ||
2020-08-29 | Italy | Abruzzo | 3739 | 472 | 2872 | 395 | 42.35122196 | 13.39843823 | 2020-08-30 04:28:22 | Abruzzo, Italy | ||
2021-02-08 | Italy | Abruzzo | 45592 | 1518 | 33120 | 10954 | 42.35122196 | 13.39843823 | 2021-02-09 05:23:30 | Abruzzo, Italy | ||
2022-11-05 | Italy | Abruzzo | 590221 | 3720 | 0 | 42.35122196 | 13.39843823 | 2022-11-06 04:21:24 | Abruzzo, Italy | |||
2022-05-22 | Italy | Abruzzo | 403010 | 3311 | 0 | 42.35122196 | 13.39843823 | 2022-05-26 04:20:50 | Abruzzo, Italy |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;