daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
960 rows where country_or_region = "Italy" and province_or_state = "Marche" sorted by recovered
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date), last_update (date)
day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered ▼ | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2021-12-02 | Italy | Marche | 124773 | 3154 | 0 | 43.61675973 | 13.5188753 | 2021-12-03 04:23:05 | Marche, Italy | |||
2021-10-28 | Italy | Marche | 115864 | 3103 | 0 | 43.61675973 | 13.5188753 | 2021-10-29 04:22:03 | Marche, Italy | |||
2021-09-18 | Italy | Marche | 112959 | 3063 | 0 | 43.61675973 | 13.5188753 | 2021-09-19 04:21:34 | Marche, Italy | |||
2022-03-20 | Italy | Marche | 364967 | 3661 | 0 | 43.61675973 | 13.5188753 | 2022-03-21 04:20:50 | Marche, Italy | |||
2021-11-11 | Italy | Marche | 117941 | 3118 | 0 | 43.61675973 | 13.5188753 | 2021-11-12 04:22:01 | Marche, Italy | |||
2021-08-25 | Italy | Marche | 109494 | 3045 | 0 | 43.61675973 | 13.5188753 | 2021-08-26 04:21:28 | Marche, Italy | |||
2021-11-02 | Italy | Marche | 116319 | 3107 | 0 | 43.61675973 | 13.5188753 | 2021-11-03 06:22:09 | Marche, Italy | |||
2022-11-12 | Italy | Marche | 660388 | 4185 | 0 | 43.61675973 | 13.5188753 | 2022-11-13 04:21:14 | Marche, Italy | |||
2021-09-01 | Italy | Marche | 110686 | 3046 | 0 | 43.61675973 | 13.5188753 | 2021-09-02 04:21:15 | Marche, Italy | |||
2022-02-07 | Italy | Marche | 286561 | 3468 | 0 | 43.61675973 | 13.5188753 | 2022-02-08 04:21:15 | Marche, Italy | |||
2021-11-09 | Italy | Marche | 117410 | 3115 | 0 | 43.61675973 | 13.5188753 | 2021-11-10 04:21:38 | Marche, Italy | |||
2022-07-23 | Italy | Marche | 559272 | 3988 | 0 | 43.61675973 | 13.5188753 | 2022-07-24 04:20:47 | Marche, Italy | |||
2022-01-14 | Italy | Marche | 171633 | 3302 | 0 | 43.61675973 | 13.5188753 | 2022-01-15 04:21:07 | Marche, Italy | |||
2021-08-15 | Italy | Marche | 108004 | 3043 | 0 | 43.61675973 | 13.5188753 | 2021-08-16 04:21:31 | Marche, Italy | |||
2022-09-06 | Italy | Marche | 607911 | 4094 | 0 | 43.61675973 | 13.5188753 | 2022-09-07 04:20:59 | Marche, Italy | |||
2022-01-09 | Italy | Marche | 160404 | 3286 | 0 | 43.61675973 | 13.5188753 | 2022-01-10 04:22:07 | Marche, Italy | |||
2022-10-04 | Italy | Marche | 627236 | 4113 | 0 | 43.61675973 | 13.5188753 | 2022-10-05 04:23:06 | Marche, Italy | |||
2021-12-04 | Italy | Marche | 125693 | 3157 | 0 | 43.61675973 | 13.5188753 | 2021-12-05 04:22:25 | Marche, Italy | |||
2022-07-09 | Italy | Marche | 521792 | 3953 | 0 | 43.61675973 | 13.5188753 | 2022-07-10 04:20:54 | Marche, Italy | |||
2021-11-29 | Italy | Marche | 123443 | 3149 | 0 | 43.61675973 | 13.5188753 | 2021-11-30 04:22:53 | Marche, Italy | |||
2022-03-29 | Italy | Marche | 385722 | 3697 | 0 | 43.61675973 | 13.5188753 | 2022-03-30 04:20:45 | Marche, Italy | |||
2021-11-19 | Italy | Marche | 120020 | 3128 | 0 | 43.61675973 | 13.5188753 | 2021-11-20 04:22:17 | Marche, Italy | |||
2022-06-21 | Italy | Marche | 485498 | 3928 | 0 | 43.61675973 | 13.5188753 | 2022-06-22 04:20:54 | Marche, Italy | |||
2021-09-02 | Italy | Marche | 110910 | 3047 | 0 | 43.61675973 | 13.5188753 | 2021-09-03 04:21:20 | Marche, Italy | |||
2022-02-13 | Italy | Marche | 302979 | 3503 | 0 | 43.61675973 | 13.5188753 | 2022-02-14 04:20:51 | Marche, Italy | |||
2022-10-19 | Italy | Marche | 644884 | 4142 | 0 | 43.61675973 | 13.5188753 | 2022-10-20 04:22:59 | Marche, Italy | |||
2022-12-26 | Italy | Marche | 698559 | 4271 | 0 | 43.61675973 | 13.5188753 | 2022-12-27 04:21:07 | Marche, Italy | |||
2022-05-09 | Italy | Marche | 455853 | 3863 | 0 | 43.61675973 | 13.5188753 | 2022-05-10 04:20:50 | Marche, Italy | |||
2022-05-31 | Italy | Marche | 473436 | 3904 | 0 | 43.61675973 | 13.5188753 | 2022-06-01 04:20:55 | Marche, Italy | |||
2022-02-11 | Italy | Marche | 298417 | 3492 | 0 | 43.61675973 | 13.5188753 | 2022-02-12 04:21:06 | Marche, Italy | |||
2021-08-17 | Italy | Marche | 108174 | 3043 | 0 | 43.61675973 | 13.5188753 | 2021-08-18 04:21:35 | Marche, Italy | |||
2021-09-04 | Italy | Marche | 111253 | 3049 | 0 | 43.61675973 | 13.5188753 | 2021-09-05 04:21:33 | Marche, Italy | |||
2022-09-08 | Italy | Marche | 608989 | 4096 | 0 | 43.61675973 | 13.5188753 | 2022-09-09 04:21:11 | Marche, Italy | |||
2022-12-10 | Italy | Marche | 687506 | 4220 | 0 | 43.61675973 | 13.5188753 | 2022-12-11 04:20:50 | Marche, Italy | |||
2022-03-15 | Italy | Marche | 351836 | 3643 | 0 | 43.61675973 | 13.5188753 | 2022-03-16 04:20:50 | Marche, Italy | |||
2021-11-03 | Italy | Marche | 116459 | 3108 | 0 | 43.61675973 | 13.5188753 | 2021-11-04 04:22:20 | Marche, Italy | |||
2021-10-31 | Italy | Marche | 116232 | 3107 | 0 | 43.61675973 | 13.5188753 | 2021-11-01 04:22:01 | Marche, Italy | |||
2022-11-15 | Italy | Marche | 660388 | 4185 | 0 | 43.61675973 | 13.5188753 | 2022-11-16 04:21:09 | Marche, Italy | |||
2022-04-16 | Italy | Marche | 420642 | 3787 | 0 | 43.61675973 | 13.5188753 | 2022-04-17 04:20:59 | Marche, Italy | |||
2022-12-13 | Italy | Marche | 687506 | 4220 | 0 | 43.61675973 | 13.5188753 | 2022-12-14 04:21:04 | Marche, Italy | |||
2022-11-13 | Italy | Marche | 660388 | 4185 | 0 | 43.61675973 | 13.5188753 | 2022-11-14 04:21:09 | Marche, Italy | |||
2022-02-12 | Italy | Marche | 300826 | 3497 | 0 | 43.61675973 | 13.5188753 | 2022-02-13 04:21:00 | Marche, Italy | |||
2022-10-30 | Italy | Marche | 653197 | 4160 | 0 | 43.61675973 | 13.5188753 | 2022-10-31 04:21:36 | Marche, Italy | |||
2022-12-27 | Italy | Marche | 698559 | 4271 | 0 | 43.61675973 | 13.5188753 | 2022-12-28 04:21:04 | Marche, Italy | |||
2022-03-18 | Italy | Marche | 360011 | 3653 | 0 | 43.61675973 | 13.5188753 | 2022-03-19 04:20:47 | Marche, Italy | |||
2022-12-14 | Italy | Marche | 687506 | 4220 | 0 | 43.61675973 | 13.5188753 | 2022-12-15 04:20:58 | Marche, Italy | |||
2022-03-11 | Italy | Marche | 344048 | 3626 | 0 | 43.61675973 | 13.5188753 | 2022-03-12 04:20:50 | Marche, Italy | |||
2022-05-07 | Italy | Marche | 454146 | 3857 | 0 | 43.61675973 | 13.5188753 | 2022-05-08 04:20:49 | Marche, Italy | |||
2022-09-13 | Italy | Marche | 611183 | 4102 | 0 | 43.61675973 | 13.5188753 | 2022-09-14 04:20:44 | Marche, Italy | |||
2022-09-23 | Italy | Marche | 616264 | 4109 | 0 | 43.61675973 | 13.5188753 | 2022-09-24 04:21:40 | Marche, Italy | |||
2022-10-07 | Italy | Marche | 631161 | 4119 | 0 | 43.61675973 | 13.5188753 | 2022-10-08 04:22:56 | Marche, Italy | |||
2021-12-07 | Italy | Marche | 126727 | 3163 | 0 | 43.61675973 | 13.5188753 | 2021-12-08 04:22:46 | Marche, Italy | |||
2022-09-18 | Italy | Marche | 613580 | 4104 | 0 | 43.61675973 | 13.5188753 | 2022-09-19 04:21:49 | Marche, Italy | |||
2021-10-10 | Italy | Marche | 114532 | 3082 | 0 | 43.61675973 | 13.5188753 | 2021-10-11 04:21:31 | Marche, Italy | |||
2022-11-03 | Italy | Marche | 653197 | 4160 | 0 | 43.61675973 | 13.5188753 | 2022-11-04 04:22:11 | Marche, Italy | |||
2021-10-20 | Italy | Marche | 115108 | 3091 | 0 | 43.61675973 | 13.5188753 | 2021-10-21 04:21:18 | Marche, Italy | |||
2021-11-17 | Italy | Marche | 119340 | 3124 | 0 | 43.61675973 | 13.5188753 | 2021-11-18 04:21:33 | Marche, Italy | |||
2022-12-21 | Italy | Marche | 693888 | 4237 | 0 | 43.61675973 | 13.5188753 | 2022-12-22 04:20:56 | Marche, Italy | |||
2022-02-02 | Italy | Marche | 271899 | 3433 | 0 | 43.61675973 | 13.5188753 | 2022-02-03 04:21:21 | Marche, Italy | |||
2022-05-02 | Italy | Marche | 446355 | 3843 | 0 | 43.61675973 | 13.5188753 | 2022-05-03 04:21:00 | Marche, Italy | |||
2021-10-07 | Italy | Marche | 114321 | 3079 | 0 | 43.61675973 | 13.5188753 | 2021-10-08 04:21:25 | Marche, Italy | |||
2022-06-26 | Italy | Marche | 491804 | 3932 | 0 | 43.61675973 | 13.5188753 | 2022-06-27 04:21:00 | Marche, Italy | |||
2022-11-08 | Italy | Marche | 656096 | 4170 | 0 | 43.61675973 | 13.5188753 | 2022-11-09 04:21:22 | Marche, Italy | |||
2022-11-25 | Italy | Marche | 672388 | 4196 | 0 | 43.61675973 | 13.5188753 | 2022-11-26 04:21:11 | Marche, Italy | |||
2021-10-14 | Italy | Marche | 114714 | 3085 | 0 | 43.61675973 | 13.5188753 | 2021-10-15 04:21:26 | Marche, Italy | |||
2021-11-06 | Italy | Marche | 117042 | 3114 | 0 | 43.61675973 | 13.5188753 | 2021-11-07 04:21:53 | Marche, Italy | |||
2022-04-02 | Italy | Marche | 395052 | 3716 | 0 | 43.61675973 | 13.5188753 | 2022-04-03 04:20:48 | Marche, Italy | |||
2022-12-17 | Italy | Marche | 693888 | 4237 | 0 | 43.61675973 | 13.5188753 | 2022-12-18 04:21:03 | Marche, Italy | |||
2021-08-14 | Italy | Marche | 107844 | 3043 | 0 | 43.61675973 | 13.5188753 | 2021-08-15 04:21:41 | Marche, Italy | |||
2021-08-19 | Italy | Marche | 108587 | 3043 | 0 | 43.61675973 | 13.5188753 | 2021-08-20 04:21:33 | Marche, Italy | |||
2022-10-15 | Italy | Marche | 640840 | 4135 | 0 | 43.61675973 | 13.5188753 | 2022-10-16 04:22:39 | Marche, Italy | |||
2021-10-27 | Italy | Marche | 115773 | 3101 | 0 | 43.61675973 | 13.5188753 | 2021-10-28 04:22:08 | Marche, Italy | |||
2022-10-26 | Italy | Marche | 650927 | 4155 | 0 | 43.61675973 | 13.5188753 | 2022-10-27 04:22:01 | Marche, Italy | |||
2022-12-15 | Italy | Marche | 687506 | 4220 | 0 | 43.61675973 | 13.5188753 | 2022-12-16 04:21:01 | Marche, Italy | |||
2021-12-08 | Italy | Marche | 127191 | 3163 | 0 | 43.61675973 | 13.5188753 | 2021-12-09 04:22:49 | Marche, Italy | |||
2022-01-16 | Italy | Marche | 182322 | 3311 | 0 | 43.61675973 | 13.5188753 | 2022-01-17 04:21:08 | Marche, Italy | |||
2022-06-16 | Italy | Marche | 481423 | 3923 | 0 | 43.61675973 | 13.5188753 | 2022-06-17 04:20:56 | Marche, Italy | |||
2021-10-29 | Italy | Marche | 115986 | 3104 | 0 | 43.61675973 | 13.5188753 | 2021-10-30 04:22:03 | Marche, Italy | |||
2022-02-25 | Italy | Marche | 323957 | 3576 | 0 | 43.61675973 | 13.5188753 | 2022-02-26 04:21:12 | Marche, Italy | |||
2021-08-08 | Italy | Marche | 106875 | 3041 | 0 | 43.61675973 | 13.5188753 | 2021-08-09 04:21:24 | Marche, Italy | |||
2022-07-01 | Italy | Marche | 501221 | 3940 | 0 | 43.61675973 | 13.5188753 | 2022-07-02 04:21:16 | Marche, Italy | |||
2021-10-19 | Italy | Marche | 115004 | 3090 | 0 | 43.61675973 | 13.5188753 | 2021-10-20 04:21:00 | Marche, Italy | |||
2021-09-23 | Italy | Marche | 113403 | 3068 | 0 | 43.61675973 | 13.5188753 | 2021-09-24 04:21:44 | Marche, Italy | |||
2022-11-05 | Italy | Marche | 656096 | 4170 | 0 | 43.61675973 | 13.5188753 | 2022-11-06 04:21:24 | Marche, Italy | |||
2022-05-22 | Italy | Marche | 470721 | 3896 | 0 | 43.61675973 | 13.5188753 | 2022-05-26 04:20:50 | Marche, Italy | |||
2022-07-12 | Italy | Marche | 529685 | 3959 | 0 | 43.61675973 | 13.5188753 | 2022-07-13 04:20:58 | Marche, Italy | |||
2021-10-13 | Italy | Marche | 114674 | 3083 | 0 | 43.61675973 | 13.5188753 | 2021-10-14 04:21:29 | Marche, Italy | |||
2021-09-07 | Italy | Marche | 111551 | 3052 | 0 | 43.61675973 | 13.5188753 | 2021-09-08 04:21:31 | Marche, Italy | |||
2021-08-09 | Italy | Marche | 106921 | 3041 | 0 | 43.61675973 | 13.5188753 | 2021-08-10 04:21:27 | Marche, Italy | |||
2021-10-22 | Italy | Marche | 115324 | 3092 | 0 | 43.61675973 | 13.5188753 | 2021-10-23 04:21:32 | Marche, Italy | |||
2022-05-13 | Italy | Marche | 461431 | 3870 | 0 | 43.61675973 | 13.5188753 | 2022-05-14 04:20:48 | Marche, Italy | |||
2022-07-21 | Italy | Marche | 554711 | 3976 | 0 | 43.61675973 | 13.5188753 | 2022-07-22 04:21:15 | Marche, Italy | |||
2022-07-30 | Italy | Marche | 573768 | 4022 | 0 | 43.61675973 | 13.5188753 | 2022-07-31 04:21:02 | Marche, Italy | |||
2021-10-24 | Italy | Marche | 115520 | 3095 | 0 | 43.61675973 | 13.5188753 | 2021-10-25 04:22:31 | Marche, Italy | |||
2021-11-13 | Italy | Marche | 118404 | 3120 | 0 | 43.61675973 | 13.5188753 | 2021-11-14 04:21:31 | Marche, Italy | |||
2022-12-23 | Italy | Marche | 698559 | 4271 | 0 | 43.61675973 | 13.5188753 | 2022-12-24 04:21:02 | Marche, Italy | |||
2022-03-17 | Italy | Marche | 357149 | 3646 | 0 | 43.61675973 | 13.5188753 | 2022-03-18 04:20:55 | Marche, Italy | |||
2021-11-04 | Italy | Marche | 116618 | 3109 | 0 | 43.61675973 | 13.5188753 | 2021-11-05 04:21:54 | Marche, Italy | |||
2021-09-29 | Italy | Marche | 113775 | 3077 | 0 | 43.61675973 | 13.5188753 | 2021-09-30 04:21:20 | Marche, Italy | |||
2022-11-01 | Italy | Marche | 653197 | 4160 | 0 | 43.61675973 | 13.5188753 | 2022-11-02 04:22:09 | Marche, Italy |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;