daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
960 rows where country_or_region = "Italy" and province_or_state = "Lombardia" sorted by confirmed descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
day (date) >30 ✖
- 2020-05-14 1
- 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
- 2020-06-12 1
- …
province_or_state 1
- Lombardia · 960 ✖
country_or_region 1
- Italy · 960 ✖
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-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-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-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-04-01 | Italy | Lombardia | 2546320 | 39268 | 0 | 45.46679409 | 9.190347404 | 2022-04-02 04:20:47 | Lombardia, Italy | |||
2022-03-31 | Italy | Lombardia | 2537267 | 39261 | 0 | 45.46679409 | 9.190347404 | 2022-04-01 04:20:28 | Lombardia, Italy | |||
2022-03-30 | Italy | Lombardia | 2528126 | 39241 | 0 | 45.46679409 | 9.190347404 | 2022-03-31 04:20:56 | Lombardia, Italy | |||
2022-03-29 | Italy | Lombardia | 2518647 | 39218 | 0 | 45.46679409 | 9.190347404 | 2022-03-30 04:20:45 | Lombardia, Italy | |||
2022-03-28 | Italy | Lombardia | 2506129 | 39197 | 0 | 45.46679409 | 9.190347404 | 2022-03-29 04:20:46 | Lombardia, Italy | |||
2022-03-27 | Italy | Lombardia | 2503411 | 39189 | 0 | 45.46679409 | 9.190347404 | 2022-03-28 04:20:33 | Lombardia, Italy | |||
2022-03-26 | Italy | Lombardia | 2496628 | 39175 | 0 | 45.46679409 | 9.190347404 | 2022-03-27 04:20:47 | Lombardia, Italy | |||
2022-03-25 | Italy | Lombardia | 2488096 | 39162 | 0 | 45.46679409 | 9.190347404 | 2022-03-26 04:20:23 | Lombardia, Italy | |||
2022-03-24 | Italy | Lombardia | 2479419 | 39141 | 0 | 45.46679409 | 9.190347404 | 2022-03-25 04:20:46 | Lombardia, Italy | |||
2022-03-23 | Italy | Lombardia | 2470119 | 39107 | 0 | 45.46679409 | 9.190347404 | 2022-03-24 04:20:43 | Lombardia, Italy | |||
2022-03-22 | Italy | Lombardia | 2460913 | 39092 | 0 | 45.46679409 | 9.190347404 | 2022-03-23 04:20:48 | Lombardia, Italy | |||
2022-03-21 | Italy | Lombardia | 2449535 | 39075 | 0 | 45.46679409 | 9.190347404 | 2022-03-22 04:20:54 | Lombardia, Italy | |||
2022-03-20 | Italy | Lombardia | 2446991 | 39060 | 0 | 45.46679409 | 9.190347404 | 2022-03-21 04:20:50 | Lombardia, Italy | |||
2022-03-19 | Italy | Lombardia | 2440620 | 39043 | 0 | 45.46679409 | 9.190347404 | 2022-03-20 04:20:45 | Lombardia, Italy | |||
2022-03-18 | Italy | Lombardia | 2432568 | 39026 | 0 | 45.46679409 | 9.190347404 | 2022-03-19 04:20:47 | Lombardia, Italy | |||
2022-03-17 | Italy | Lombardia | 2424013 | 39000 | 0 | 45.46679409 | 9.190347404 | 2022-03-18 04:20:55 | Lombardia, Italy | |||
2022-03-16 | Italy | Lombardia | 2415343 | 38977 | 0 | 45.46679409 | 9.190347404 | 2022-03-17 04:20:56 | Lombardia, Italy | |||
2022-03-15 | Italy | Lombardia | 2407160 | 38966 | 0 | 45.46679409 | 9.190347404 | 2022-03-16 04:20:50 | Lombardia, Italy | |||
2022-03-14 | Italy | Lombardia | 2397620 | 38952 | 0 | 45.46679409 | 9.190347404 | 2022-03-15 04:20:47 | Lombardia, Italy | |||
2022-03-13 | Italy | Lombardia | 2395284 | 38939 | 0 | 45.46679409 | 9.190347404 | 2022-03-14 04:20:46 | Lombardia, Italy | |||
2022-03-12 | Italy | Lombardia | 2390493 | 38921 | 0 | 45.46679409 | 9.190347404 | 2022-03-13 04:20:49 | Lombardia, Italy | |||
2022-03-11 | Italy | Lombardia | 2384992 | 38889 | 0 | 45.46679409 | 9.190347404 | 2022-03-12 04:20:50 | Lombardia, Italy | |||
2022-03-10 | Italy | Lombardia | 2379131 | 38870 | 0 | 45.46679409 | 9.190347404 | 2022-03-11 04:20:50 | Lombardia, Italy | |||
2022-03-09 | Italy | Lombardia | 2373318 | 38845 | 0 | 45.46679409 | 9.190347404 | 2022-03-10 04:20:48 | Lombardia, Italy | |||
2022-03-08 | Italy | Lombardia | 2367735 | 38831 | 0 | 45.46679409 | 9.190347404 | 2022-03-09 04:20:59 | Lombardia, Italy | |||
2022-03-07 | Italy | Lombardia | 2361238 | 38822 | 0 | 45.46679409 | 9.190347404 | 2022-03-08 04:20:54 | Lombardia, Italy | |||
2022-03-06 | Italy | Lombardia | 2359624 | 38792 | 0 | 45.46679409 | 9.190347404 | 2022-03-07 04:20:47 | Lombardia, Italy | |||
2022-03-05 | Italy | Lombardia | 2355997 | 38758 | 0 | 45.46679409 | 9.190347404 | 2022-03-06 04:20:49 | Lombardia, Italy |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;