daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
20,264 rows where country_or_region = "Italy" sorted by confirmed descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-06-12 | Italy | Lombardia | 2923580 | 40670 | 0 | 45.46679409 | 9.190347404 | 2022-06-13 04:21:14 | Lombardia, Italy | |||
2022-06-11 | Italy | Lombardia | 2921212 | 40658 | 0 | 45.46679409 | 9.190347404 | 2022-06-12 04:20:53 | Lombardia, Italy | |||
2022-06-10 | Italy | Lombardia | 2918124 | 40647 | 0 | 45.46679409 | 9.190347404 | 2022-06-11 04:21:01 | Lombardia, Italy | |||
2022-06-09 | Italy | Lombardia | 2914992 | 40636 | 0 | 45.46679409 | 9.190347404 | 2022-06-10 04:20:55 | Lombardia, Italy | |||
2022-06-08 | Italy | Lombardia | 2911719 | 40614 | 0 | 45.46679409 | 9.190347404 | 2022-06-09 04:20:54 | Lombardia, Italy | |||
2022-06-07 | Italy | Lombardia | 2908561 | 40609 | 0 | 45.46679409 | 9.190347404 | 2022-06-08 04:20:55 | Lombardia, Italy | |||
2022-06-06 | Italy | Lombardia | 2904070 | 40601 | 0 | 45.46679409 | 9.190347404 | 2022-06-07 04:21:08 | Lombardia, Italy | |||
2022-06-05 | Italy | Lombardia | 2903177 | 40588 | 0 | 45.46679409 | 9.190347404 | 2022-06-06 04:20:57 | Lombardia, Italy | |||
2022-06-04 | Italy | Lombardia | 2901321 | 40586 | 0 | 45.46679409 | 9.190347404 | 2022-06-05 04:20:55 | Lombardia, Italy | |||
2022-06-03 | Italy | Lombardia | 2898222 | 40575 | 0 | 45.46679409 | 9.190347404 | 2022-06-04 04:20:58 | Lombardia, Italy | |||
2022-06-02 | Italy | Lombardia | 2897532 | 40569 | 0 | 45.46679409 | 9.190347404 | 2022-06-03 04:20:58 | Lombardia, Italy | |||
2022-06-01 | Italy | Lombardia | 2895171 | 40552 | 0 | 45.46679409 | 9.190347404 | 2022-06-02 05:20:39 | Lombardia, Italy | |||
2022-05-31 | Italy | Lombardia | 2892931 | 40547 | 0 | 45.46679409 | 9.190347404 | 2022-06-01 04:20:55 | Lombardia, Italy | |||
2022-05-30 | Italy | Lombardia | 2889641 | 40541 | 0 | 45.46679409 | 9.190347404 | 2022-05-31 04:20:51 | Lombardia, Italy | |||
2022-05-29 | Italy | Lombardia | 2888891 | 40524 | 0 | 45.46679409 | 9.190347404 | 2022-05-30 04:20:50 | Lombardia, Italy | |||
2022-05-28 | Italy | Lombardia | 2887124 | 40515 | 0 | 45.46679409 | 9.190347404 | 2022-05-29 04:20:53 | Lombardia, Italy | |||
2022-05-27 | Italy | Lombardia | 2884764 | 40501 | 0 | 45.46679409 | 9.190347404 | 2022-05-28 04:21:07 | Lombardia, Italy | |||
2022-05-26 | Italy | Lombardia | 2882315 | 40480 | 0 | 45.46679409 | 9.190347404 | 2022-05-27 04:20:56 | Lombardia, Italy | |||
2022-05-22 | Italy | Lombardia | 2879573 | 40453 | 0 | 45.46679409 | 9.190347404 | 2022-05-26 04:20:50 | Lombardia, Italy | |||
2022-05-25 | Italy | Lombardia | 2879573 | 40453 | 0 | 45.46679409 | 9.190347404 | 2022-05-26 04:20:50 | Lombardia, Italy | |||
2022-05-24 | Italy | Lombardia | 2876699 | 40422 | 0 | 45.46679409 | 9.190347404 | 2022-05-25 04:20:56 | Lombardia, Italy | |||
2022-05-23 | Italy | Lombardia | 2872369 | 40416 | 0 | 45.46679409 | 9.190347404 | 2022-05-24 04:20:57 | Lombardia, Italy | |||
2022-05-21 | Italy | Lombardia | 2869121 | 40408 | 0 | 45.46679409 | 9.190347404 | 2022-05-22 04:20:52 | Lombardia, Italy | |||
2022-05-20 | Italy | Lombardia | 2865834 | 40384 | 0 | 45.46679409 | 9.190347404 | 2022-05-21 04:20:58 | Lombardia, Italy | |||
2022-05-19 | Italy | Lombardia | 2862295 | 40369 | 0 | 45.46679409 | 9.190347404 | 2022-05-20 04:20:57 | Lombardia, Italy | |||
2022-05-18 | Italy | Lombardia | 2858315 | 40342 | 0 | 45.46679409 | 9.190347404 | 2022-05-19 04:20:54 | Lombardia, Italy | |||
2022-05-17 | Italy | Lombardia | 2853990 | 40331 | 0 | 45.46679409 | 9.190347404 | 2022-05-18 04:20:50 | Lombardia, Italy | |||
2022-05-16 | Italy | Lombardia | 2847027 | 40305 | 0 | 45.46679409 | 9.190347404 | 2022-05-17 04:20:59 | Lombardia, Italy | |||
2022-05-15 | Italy | Lombardia | 2845587 | 40286 | 0 | 45.46679409 | 9.190347404 | 2022-05-16 04:20:47 | Lombardia, Italy | |||
2022-05-14 | Italy | Lombardia | 2842188 | 40263 | 0 | 45.46679409 | 9.190347404 | 2022-05-15 04:20:53 | Lombardia, Italy | |||
2022-05-13 | Italy | Lombardia | 2837206 | 40242 | 0 | 45.46679409 | 9.190347404 | 2022-05-14 04:20:48 | Lombardia, Italy | |||
2022-05-12 | Italy | Lombardia | 2831859 | 40222 | 0 | 45.46679409 | 9.190347404 | 2022-05-13 04:20:51 | Lombardia, Italy | |||
2022-05-11 | Italy | Lombardia | 2825767 | 40198 | 0 | 45.46679409 | 9.190347404 | 2022-05-12 04:20:54 | Lombardia, Italy | |||
2022-05-10 | Italy | Lombardia | 2819610 | 40186 | 0 | 45.46679409 | 9.190347404 | 2022-05-11 04:20:48 | Lombardia, Italy | |||
2022-05-09 | Italy | Lombardia | 2810129 | 40152 | 0 | 45.46679409 | 9.190347404 | 2022-05-10 04:20:50 | Lombardia, Italy | |||
2022-05-08 | Italy | Lombardia | 2807778 | 40131 | 0 | 45.46679409 | 9.190347404 | 2022-05-09 04:20:54 | Lombardia, Italy | |||
2022-05-07 | Italy | Lombardia | 2805793 | 40109 | 0 | 45.46679409 | 9.190347404 | 2022-05-08 04:20:49 | Lombardia, Italy | |||
2022-05-06 | Italy | Lombardia | 2800489 | 40094 | 0 | 45.46679409 | 9.190347404 | 2022-05-07 04:21:09 | Lombardia, Italy | |||
2022-05-05 | Italy | Lombardia | 2794742 | 40065 | 0 | 45.46679409 | 9.190347404 | 2022-05-06 04:21:00 | Lombardia, Italy | |||
2022-05-04 | Italy | Lombardia | 2788380 | 40043 | 0 | 45.46679409 | 9.190347404 | 2022-05-05 04:20:55 | Lombardia, Italy | |||
2022-05-03 | Italy | Lombardia | 2781909 | 40033 | 0 | 45.46679409 | 9.190347404 | 2022-05-04 04:20:59 | Lombardia, Italy | |||
2022-05-02 | Italy | Lombardia | 2772319 | 40011 | 0 | 45.46679409 | 9.190347404 | 2022-05-03 04:21:00 | Lombardia, Italy | |||
2022-05-01 | Italy | Lombardia | 2770646 | 39980 | 0 | 45.46679409 | 9.190347404 | 2022-05-02 04:21:10 | Lombardia, Italy | |||
2022-04-30 | Italy | Lombardia | 2765392 | 39935 | 0 | 45.46679409 | 9.190347404 | 2022-05-01 04:20:57 | Lombardia, Italy | |||
2022-04-29 | Italy | Lombardia | 2758419 | 39915 | 0 | 45.46679409 | 9.190347404 | 2022-04-30 04:21:05 | Lombardia, Italy | |||
2022-04-28 | Italy | Lombardia | 2750788 | 39889 | 0 | 45.46679409 | 9.190347404 | 2022-04-29 04:20:59 | Lombardia, Italy | |||
2022-04-27 | Italy | Lombardia | 2742154 | 39880 | 0 | 45.46679409 | 9.190347404 | 2022-04-28 04:20:47 | Lombardia, Italy | |||
2022-04-26 | Italy | Lombardia | 2729044 | 39854 | 0 | 45.46679409 | 9.190347404 | 2022-04-27 04:20:52 | Lombardia, Italy | |||
2022-04-25 | Italy | Lombardia | 2726329 | 39832 | 0 | 45.46679409 | 9.190347404 | 2022-04-26 04:20:51 | Lombardia, Italy | |||
2022-04-24 | Italy | Lombardia | 2723970 | 39814 | 0 | 45.46679409 | 9.190347404 | 2022-04-25 04:20:56 | Lombardia, Italy | |||
2022-04-23 | Italy | Lombardia | 2717998 | 39791 | 0 | 45.46679409 | 9.190347404 | 2022-04-24 04:20:56 | Lombardia, Italy | |||
2022-04-22 | Italy | Lombardia | 2709483 | 39748 | 0 | 45.46679409 | 9.190347404 | 2022-04-23 04:20:50 | Lombardia, Italy | |||
2022-04-21 | Italy | Lombardia | 2700288 | 39712 | 0 | 45.46679409 | 9.190347404 | 2022-04-22 04:20:45 | Lombardia, Italy | |||
2022-04-20 | Italy | Lombardia | 2690610 | 39682 | 0 | 45.46679409 | 9.190347404 | 2022-04-21 04:20:46 | Lombardia, Italy | |||
2022-04-19 | Italy | Lombardia | 2676545 | 39658 | 0 | 45.46679409 | 9.190347404 | 2022-04-20 04:20:45 | Lombardia, Italy | |||
2022-04-18 | Italy | Lombardia | 2674216 | 39654 | 0 | 45.46679409 | 9.190347404 | 2022-04-19 04:21:00 | Lombardia, Italy | |||
2022-04-17 | Italy | Lombardia | 2672602 | 39626 | 0 | 45.46679409 | 9.190347404 | 2022-04-18 04:21:12 | Lombardia, Italy | |||
2022-04-16 | Italy | Lombardia | 2666373 | 39597 | 0 | 45.46679409 | 9.190347404 | 2022-04-17 04:20:59 | Lombardia, Italy | |||
2022-04-15 | Italy | Lombardia | 2657775 | 39563 | 0 | 45.46679409 | 9.190347404 | 2022-04-16 04:20:48 | Lombardia, Italy | |||
2022-04-14 | Italy | Lombardia | 2649677 | 39540 | 0 | 45.46679409 | 9.190347404 | 2022-04-15 04:20:57 | Lombardia, Italy | |||
2022-04-13 | Italy | Lombardia | 2640897 | 39515 | 0 | 45.46679409 | 9.190347404 | 2022-04-13 23:21:06 | Lombardia, Italy | |||
2022-04-12 | Italy | Lombardia | 2632174 | 39500 | 0 | 45.46679409 | 9.190347404 | 2022-04-13 04:21:03 | Lombardia, Italy | |||
2022-12-26 | Italy | Veneto | 2623547 | 16226 | 0 | 45.43490485 | 12.33845213 | 2022-12-27 04:21:07 | Veneto, Italy | |||
2022-12-27 | Italy | Veneto | 2623547 | 16226 | 0 | 45.43490485 | 12.33845213 | 2022-12-28 04:21:04 | Veneto, Italy | |||
2022-12-23 | Italy | Veneto | 2623547 | 16226 | 0 | 45.43490485 | 12.33845213 | 2022-12-24 04:21:02 | Veneto, Italy | |||
2022-12-24 | Italy | Veneto | 2623547 | 16226 | 0 | 45.43490485 | 12.33845213 | 2022-12-25 04:21:04 | Veneto, Italy | |||
2022-12-28 | Italy | Veneto | 2623547 | 16226 | 0 | 45.43490485 | 12.33845213 | 2022-12-29 04:21:01 | Veneto, Italy | |||
2022-12-29 | Italy | Veneto | 2623547 | 16226 | 0 | 45.43490485 | 12.33845213 | 2022-12-30 04:21:04 | Veneto, Italy | |||
2022-12-25 | Italy | Veneto | 2623547 | 16226 | 0 | 45.43490485 | 12.33845213 | 2022-12-26 04:21:06 | Veneto, Italy | |||
2022-04-11 | Italy | Lombardia | 2620505 | 39474 | 0 | 45.46679409 | 9.190347404 | 2022-04-12 04:20:49 | Lombardia, Italy | |||
2022-04-10 | Italy | Lombardia | 2617945 | 39461 | 0 | 45.46679409 | 9.190347404 | 2022-04-11 04:21:02 | Lombardia, Italy | |||
2022-04-09 | Italy | Lombardia | 2611334 | 39440 | 0 | 45.46679409 | 9.190347404 | 2022-04-10 04:20:52 | Lombardia, Italy | |||
2022-12-21 | Italy | Veneto | 2604933 | 16156 | 0 | 45.43490485 | 12.33845213 | 2022-12-22 04:20:56 | Veneto, Italy | |||
2022-12-17 | Italy | Veneto | 2604933 | 16156 | 0 | 45.43490485 | 12.33845213 | 2022-12-18 04:21:03 | Veneto, Italy | |||
2022-12-18 | Italy | Veneto | 2604933 | 16156 | 0 | 45.43490485 | 12.33845213 | 2022-12-19 04:21:03 | Veneto, Italy | |||
2022-12-22 | Italy | Veneto | 2604933 | 16156 | 0 | 45.43490485 | 12.33845213 | 2022-12-23 04:21:04 | Veneto, Italy | |||
2022-12-20 | Italy | Veneto | 2604933 | 16156 | 0 | 45.43490485 | 12.33845213 | 2022-12-21 04:21:03 | Veneto, Italy | |||
2022-12-19 | Italy | Veneto | 2604933 | 16156 | 0 | 45.43490485 | 12.33845213 | 2022-12-20 04:21:04 | Veneto, Italy | |||
2022-12-16 | Italy | Veneto | 2604933 | 16156 | 0 | 45.43490485 | 12.33845213 | 2022-12-17 04:21:04 | Veneto, Italy | |||
2022-04-08 | Italy | Lombardia | 2602794 | 39423 | 0 | 45.46679409 | 9.190347404 | 2022-04-09 04:20:42 | Lombardia, Italy | |||
2022-04-07 | Italy | Lombardia | 2594113 | 39388 | 0 | 45.46679409 | 9.190347404 | 2022-04-08 04:20:48 | Lombardia, Italy | |||
2022-04-06 | Italy | Lombardia | 2584745 | 39359 | 0 | 45.46679409 | 9.190347404 | 2022-04-07 04:20:53 | Lombardia, Italy | |||
2022-12-10 | Italy | Veneto | 2582972 | 16052 | 0 | 45.43490485 | 12.33845213 | 2022-12-11 04:20:50 | Veneto, Italy | |||
2022-12-13 | Italy | Veneto | 2582972 | 16052 | 0 | 45.43490485 | 12.33845213 | 2022-12-14 04:21:04 | Veneto, Italy | |||
2022-12-14 | Italy | Veneto | 2582972 | 16052 | 0 | 45.43490485 | 12.33845213 | 2022-12-15 04:20:58 | Veneto, Italy | |||
2022-12-15 | Italy | Veneto | 2582972 | 16052 | 0 | 45.43490485 | 12.33845213 | 2022-12-16 04:21:01 | Veneto, Italy | |||
2022-12-11 | Italy | Veneto | 2582972 | 16052 | 0 | 45.43490485 | 12.33845213 | 2022-12-12 04:21:01 | Veneto, Italy | |||
2022-12-12 | Italy | Veneto | 2582972 | 16052 | 0 | 45.43490485 | 12.33845213 | 2022-12-13 04:21:01 | Veneto, Italy | |||
2022-12-09 | Italy | Veneto | 2582972 | 16052 | 0 | 45.43490485 | 12.33845213 | 2022-12-10 04:21:02 | Veneto, Italy | |||
2022-04-05 | Italy | Lombardia | 2575651 | 39347 | 0 | 45.46679409 | 9.190347404 | 2022-04-06 04:20:49 | Lombardia, Italy | |||
2022-04-04 | Italy | Lombardia | 2563985 | 39329 | 0 | 45.46679409 | 9.190347404 | 2022-04-05 04:20:48 | Lombardia, Italy | |||
2022-04-03 | Italy | Lombardia | 2561473 | 39315 | 0 | 45.46679409 | 9.190347404 | 2022-04-04 04:20:51 | Lombardia, Italy | |||
2022-04-02 | Italy | Lombardia | 2555102 | 39280 | 0 | 45.46679409 | 9.190347404 | 2022-04-03 04:20:48 | Lombardia, Italy | |||
2022-12-04 | Italy | Veneto | 2553072 | 15972 | 0 | 45.43490485 | 12.33845213 | 2022-12-05 04:20:58 | Veneto, Italy | |||
2022-12-02 | Italy | Veneto | 2553072 | 15972 | 0 | 45.43490485 | 12.33845213 | 2022-12-03 04:21:02 | Veneto, Italy | |||
2022-12-07 | Italy | Veneto | 2553072 | 15972 | 0 | 45.43490485 | 12.33845213 | 2022-12-08 04:21:07 | Veneto, Italy | |||
2022-12-05 | Italy | Veneto | 2553072 | 15972 | 0 | 45.43490485 | 12.33845213 | 2022-12-06 04:21:03 | Veneto, Italy | |||
2022-12-03 | Italy | Veneto | 2553072 | 15972 | 0 | 45.43490485 | 12.33845213 | 2022-12-04 04:20:56 | Veneto, Italy | |||
2022-12-08 | Italy | Veneto | 2553072 | 15972 | 0 | 45.43490485 | 12.33845213 | 2022-12-09 04:21:05 | Veneto, Italy | |||
2022-12-06 | Italy | Veneto | 2553072 | 15972 | 0 | 45.43490485 | 12.33845213 | 2022-12-07 04:20:58 | Veneto, Italy |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;