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 day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-09-20 | Italy | Marche | 614503 | 4107 | 0 | 43.61675973 | 13.5188753 | 2022-09-21 04:23:22 | Marche, Italy | |||
2022-09-19 | Italy | Marche | 613761 | 4107 | 0 | 43.61675973 | 13.5188753 | 2022-09-20 04:22:48 | Marche, Italy | |||
2022-09-18 | Italy | Marche | 613580 | 4104 | 0 | 43.61675973 | 13.5188753 | 2022-09-19 04:21:49 | Marche, Italy | |||
2022-09-17 | Italy | Marche | 613172 | 4103 | 0 | 43.61675973 | 13.5188753 | 2022-09-18 04:22:50 | Marche, Italy | |||
2022-09-16 | Italy | Marche | 612655 | 4103 | 0 | 43.61675973 | 13.5188753 | 2022-09-17 04:20:19 | Marche, Italy | |||
2022-09-15 | Italy | Marche | 612183 | 4103 | 0 | 43.61675973 | 13.5188753 | 2022-09-16 04:21:19 | Marche, Italy | |||
2022-09-14 | Italy | Marche | 611647 | 4102 | 0 | 43.61675973 | 13.5188753 | 2022-09-15 04:21:02 | Marche, Italy | |||
2022-09-13 | Italy | Marche | 611183 | 4102 | 0 | 43.61675973 | 13.5188753 | 2022-09-14 04:20:44 | Marche, Italy | |||
2022-09-12 | Italy | Marche | 610484 | 4068 | 0 | 43.61675973 | 13.5188753 | 2022-09-13 04:20:57 | Marche, Italy | |||
2022-09-11 | Italy | Marche | 609444 | 4096 | 0 | 43.61675973 | 13.5188753 | 2022-09-12 04:20:58 | Marche, Italy | |||
2022-09-10 | Italy | Marche | 609444 | 4096 | 0 | 43.61675973 | 13.5188753 | 2022-09-11 04:20:50 | Marche, Italy | |||
2022-09-09 | Italy | Marche | 609444 | 4096 | 0 | 43.61675973 | 13.5188753 | 2022-09-10 04:21:10 | Marche, Italy | |||
2022-09-08 | Italy | Marche | 608989 | 4096 | 0 | 43.61675973 | 13.5188753 | 2022-09-09 04:21:11 | Marche, Italy | |||
2022-09-07 | Italy | Marche | 608453 | 4095 | 0 | 43.61675973 | 13.5188753 | 2022-09-08 04:21:02 | Marche, Italy | |||
2022-09-06 | Italy | Marche | 607911 | 4094 | 0 | 43.61675973 | 13.5188753 | 2022-09-07 04:20:59 | Marche, Italy | |||
2022-09-05 | Italy | Marche | 607095 | 4094 | 0 | 43.61675973 | 13.5188753 | 2022-09-06 04:21:02 | Marche, Italy | |||
2022-09-04 | Italy | Marche | 606862 | 4094 | 0 | 43.61675973 | 13.5188753 | 2022-09-05 04:21:01 | Marche, Italy | |||
2022-09-03 | Italy | Marche | 606411 | 4094 | 0 | 43.61675973 | 13.5188753 | 2022-09-04 04:21:22 | Marche, Italy | |||
2022-09-02 | Italy | Marche | 605834 | 4094 | 0 | 43.61675973 | 13.5188753 | 2022-09-03 04:21:04 | Marche, Italy | |||
2022-09-01 | Italy | Marche | 605266 | 4092 | 0 | 43.61675973 | 13.5188753 | 2022-09-02 04:21:07 | Marche, Italy | |||
2022-08-31 | Italy | Marche | 604668 | 4092 | 0 | 43.61675973 | 13.5188753 | 2022-09-01 04:21:03 | Marche, Italy | |||
2022-08-30 | Italy | Marche | 604019 | 4091 | 0 | 43.61675973 | 13.5188753 | 2022-08-31 04:20:57 | Marche, Italy | |||
2022-08-29 | Italy | Marche | 603040 | 4091 | 0 | 43.61675973 | 13.5188753 | 2022-08-30 04:21:03 | Marche, Italy | |||
2022-08-28 | Italy | Marche | 602770 | 4091 | 0 | 43.61675973 | 13.5188753 | 2022-08-29 04:21:06 | Marche, Italy | |||
2022-08-27 | Italy | Marche | 602119 | 4090 | 0 | 43.61675973 | 13.5188753 | 2022-08-28 04:21:02 | Marche, Italy | |||
2022-08-26 | Italy | Marche | 601368 | 4090 | 0 | 43.61675973 | 13.5188753 | 2022-08-27 04:20:57 | Marche, Italy | |||
2022-08-25 | Italy | Marche | 600626 | 4087 | 0 | 43.61675973 | 13.5188753 | 2022-08-26 04:21:02 | Marche, Italy | |||
2022-08-24 | Italy | Marche | 599780 | 4086 | 0 | 43.61675973 | 13.5188753 | 2022-08-25 04:21:13 | Marche, Italy | |||
2022-08-23 | Italy | Marche | 598981 | 4085 | 0 | 43.61675973 | 13.5188753 | 2022-08-24 04:20:46 | Marche, Italy | |||
2022-08-22 | Italy | Marche | 597725 | 4084 | 0 | 43.61675973 | 13.5188753 | 2022-08-23 04:20:56 | Marche, Italy | |||
2022-08-21 | Italy | Marche | 597292 | 4084 | 0 | 43.61675973 | 13.5188753 | 2022-08-22 04:20:38 | Marche, Italy | |||
2022-08-20 | Italy | Marche | 596483 | 4082 | 0 | 43.61675973 | 13.5188753 | 2022-08-21 04:20:44 | Marche, Italy | |||
2022-08-19 | Italy | Marche | 595610 | 4080 | 0 | 43.61675973 | 13.5188753 | 2022-08-20 04:21:01 | Marche, Italy | |||
2022-08-18 | Italy | Marche | 594683 | 4078 | 0 | 43.61675973 | 13.5188753 | 2022-08-19 04:20:54 | Marche, Italy | |||
2022-08-17 | Italy | Marche | 593663 | 4072 | 0 | 43.61675973 | 13.5188753 | 2022-08-18 04:21:11 | Marche, Italy | |||
2022-08-16 | Italy | Marche | 592304 | 4072 | 0 | 43.61675973 | 13.5188753 | 2022-08-17 04:20:59 | Marche, Italy | |||
2022-08-15 | Italy | Marche | 591956 | 4070 | 0 | 43.61675973 | 13.5188753 | 2022-08-16 04:20:58 | Marche, Italy | |||
2022-08-14 | Italy | Marche | 591472 | 4070 | 0 | 43.61675973 | 13.5188753 | 2022-08-15 04:20:59 | Marche, Italy | |||
2022-08-13 | Italy | Marche | 590692 | 4067 | 0 | 43.61675973 | 13.5188753 | 2022-08-14 04:20:55 | Marche, Italy | |||
2022-08-12 | Italy | Marche | 589761 | 4065 | 0 | 43.61675973 | 13.5188753 | 2022-08-13 04:20:52 | Marche, Italy | |||
2022-08-11 | Italy | Marche | 588806 | 4062 | 0 | 43.61675973 | 13.5188753 | 2022-08-12 04:20:54 | Marche, Italy | |||
2022-08-10 | Italy | Marche | 587813 | 4059 | 0 | 43.61675973 | 13.5188753 | 2022-08-11 04:20:49 | Marche, Italy | |||
2022-08-09 | Italy | Marche | 586885 | 4055 | 0 | 43.61675973 | 13.5188753 | 2022-08-10 04:20:57 | Marche, Italy | |||
2022-08-08 | Italy | Marche | 585371 | 4051 | 0 | 43.61675973 | 13.5188753 | 2022-08-09 04:20:34 | Marche, Italy | |||
2022-08-07 | Italy | Marche | 584968 | 4048 | 0 | 43.61675973 | 13.5188753 | 2022-08-08 04:21:08 | Marche, Italy | |||
2022-08-06 | Italy | Marche | 583889 | 4046 | 0 | 43.61675973 | 13.5188753 | 2022-08-07 04:20:54 | Marche, Italy | |||
2022-08-05 | Italy | Marche | 582762 | 4044 | 0 | 43.61675973 | 13.5188753 | 2022-08-06 04:20:56 | Marche, Italy | |||
2022-08-04 | Italy | Marche | 581437 | 4042 | 0 | 43.61675973 | 13.5188753 | 2022-08-05 04:20:52 | Marche, Italy | |||
2022-08-03 | Italy | Marche | 579918 | 4039 | 0 | 43.61675973 | 13.5188753 | 2022-08-04 04:20:58 | Marche, Italy | |||
2022-08-02 | Italy | Marche | 578346 | 4032 | 0 | 43.61675973 | 13.5188753 | 2022-08-03 04:20:59 | Marche, Italy | |||
2022-08-01 | Italy | Marche | 575959 | 4031 | 0 | 43.61675973 | 13.5188753 | 2022-08-02 04:20:53 | Marche, Italy | |||
2022-07-31 | Italy | Marche | 575282 | 4026 | 0 | 43.61675973 | 13.5188753 | 2022-08-01 04:21:03 | Marche, Italy | |||
2022-07-30 | Italy | Marche | 573768 | 4022 | 0 | 43.61675973 | 13.5188753 | 2022-07-31 04:21:02 | Marche, Italy | |||
2022-07-29 | Italy | Marche | 571956 | 4016 | 0 | 43.61675973 | 13.5188753 | 2022-07-30 04:20:42 | Marche, Italy | |||
2022-07-28 | Italy | Marche | 569878 | 4010 | 0 | 43.61675973 | 13.5188753 | 2022-07-29 04:20:45 | Marche, Italy | |||
2022-07-27 | Italy | Marche | 567645 | 4006 | 0 | 43.61675973 | 13.5188753 | 2022-07-28 04:20:56 | Marche, Italy | |||
2022-07-26 | Italy | Marche | 565310 | 3999 | 0 | 43.61675973 | 13.5188753 | 2022-07-27 04:21:04 | Marche, Italy | |||
2022-07-25 | Italy | Marche | 562206 | 3992 | 0 | 43.61675973 | 13.5188753 | 2022-07-26 04:20:58 | Marche, Italy | |||
2022-07-24 | Italy | Marche | 561253 | 3988 | 0 | 43.61675973 | 13.5188753 | 2022-07-25 04:20:51 | Marche, Italy | |||
2022-07-23 | Italy | Marche | 559272 | 3988 | 0 | 43.61675973 | 13.5188753 | 2022-07-24 04:20:47 | Marche, Italy | |||
2022-07-22 | Italy | Marche | 557069 | 3985 | 0 | 43.61675973 | 13.5188753 | 2022-07-23 04:20:53 | Marche, Italy | |||
2022-07-21 | Italy | Marche | 554711 | 3976 | 0 | 43.61675973 | 13.5188753 | 2022-07-22 04:21:15 | Marche, Italy | |||
2022-07-20 | Italy | Marche | 552039 | 3971 | 0 | 43.61675973 | 13.5188753 | 2022-07-21 04:21:10 | Marche, Italy | |||
2022-07-19 | Italy | Marche | 549519 | 3971 | 0 | 43.61675973 | 13.5188753 | 2022-07-20 04:20:59 | Marche, Italy | |||
2022-07-18 | Italy | Marche | 545796 | 3968 | 0 | 43.61675973 | 13.5188753 | 2022-07-19 04:20:58 | Marche, Italy | |||
2022-07-17 | Italy | Marche | 544720 | 3967 | 0 | 43.61675973 | 13.5188753 | 2022-07-18 04:20:59 | Marche, Italy | |||
2022-07-16 | Italy | Marche | 542252 | 3966 | 0 | 43.61675973 | 13.5188753 | 2022-07-17 04:21:15 | Marche, Italy | |||
2022-07-15 | Italy | Marche | 539267 | 3963 | 0 | 43.61675973 | 13.5188753 | 2022-07-16 04:21:05 | Marche, Italy | |||
2022-07-14 | Italy | Marche | 536303 | 3962 | 0 | 43.61675973 | 13.5188753 | 2022-07-15 04:20:53 | Marche, Italy | |||
2022-07-13 | Italy | Marche | 532879 | 3960 | 0 | 43.61675973 | 13.5188753 | 2022-07-14 04:20:57 | Marche, Italy | |||
2022-07-12 | Italy | Marche | 529685 | 3959 | 0 | 43.61675973 | 13.5188753 | 2022-07-13 04:20:58 | Marche, Italy | |||
2022-07-11 | Italy | Marche | 525575 | 3958 | 0 | 43.61675973 | 13.5188753 | 2022-07-12 04:20:51 | Marche, Italy | |||
2022-07-10 | Italy | Marche | 524388 | 3957 | 0 | 43.61675973 | 13.5188753 | 2022-07-11 04:20:46 | Marche, Italy | |||
2022-07-09 | Italy | Marche | 521792 | 3953 | 0 | 43.61675973 | 13.5188753 | 2022-07-10 04:20:54 | Marche, Italy | |||
2022-07-08 | Italy | Marche | 518964 | 3950 | 0 | 43.61675973 | 13.5188753 | 2022-07-09 04:20:59 | Marche, Italy | |||
2022-07-07 | Italy | Marche | 515939 | 3948 | 0 | 43.61675973 | 13.5188753 | 2022-07-08 04:20:56 | Marche, Italy | |||
2022-07-06 | Italy | Marche | 512863 | 3946 | 0 | 43.61675973 | 13.5188753 | 2022-07-07 04:20:55 | Marche, Italy | |||
2022-07-05 | Italy | Marche | 509978 | 3942 | 0 | 43.61675973 | 13.5188753 | 2022-07-06 04:20:58 | Marche, Italy | |||
2022-07-04 | Italy | Marche | 506292 | 3942 | 0 | 43.61675973 | 13.5188753 | 2022-07-05 04:20:45 | Marche, Italy | |||
2022-07-03 | Italy | Marche | 505275 | 3941 | 0 | 43.61675973 | 13.5188753 | 2022-07-04 04:20:54 | Marche, Italy | |||
2022-07-02 | Italy | Marche | 503278 | 3940 | 0 | 43.61675973 | 13.5188753 | 2022-07-03 04:20:59 | Marche, Italy | |||
2022-07-01 | Italy | Marche | 501221 | 3940 | 0 | 43.61675973 | 13.5188753 | 2022-07-02 04:21:16 | Marche, Italy | |||
2022-06-30 | Italy | Marche | 499057 | 3939 | 0 | 43.61675973 | 13.5188753 | 2022-07-01 04:21:10 | Marche, Italy | |||
2022-06-29 | Italy | Marche | 496880 | 3937 | 0 | 43.61675973 | 13.5188753 | 2022-06-30 04:21:01 | Marche, Italy | |||
2022-06-28 | Italy | Marche | 494942 | 3935 | 0 | 43.61675973 | 13.5188753 | 2022-06-29 04:20:59 | Marche, Italy | |||
2022-06-27 | Italy | Marche | 492497 | 3935 | 0 | 43.61675973 | 13.5188753 | 2022-06-28 04:20:58 | Marche, Italy | |||
2022-06-26 | Italy | Marche | 491804 | 3932 | 0 | 43.61675973 | 13.5188753 | 2022-06-27 04:21:00 | Marche, Italy | |||
2022-06-25 | Italy | Marche | 490521 | 3932 | 0 | 43.61675973 | 13.5188753 | 2022-06-26 04:21:02 | Marche, Italy | |||
2022-06-24 | Italy | Marche | 489295 | 3932 | 0 | 43.61675973 | 13.5188753 | 2022-06-25 04:20:57 | Marche, Italy | |||
2022-06-23 | Italy | Marche | 487972 | 3932 | 0 | 43.61675973 | 13.5188753 | 2022-06-24 04:20:58 | Marche, Italy | |||
2022-06-22 | Italy | Marche | 486665 | 3931 | 0 | 43.61675973 | 13.5188753 | 2022-06-23 04:20:55 | Marche, Italy | |||
2022-06-21 | Italy | Marche | 485498 | 3928 | 0 | 43.61675973 | 13.5188753 | 2022-06-22 04:20:54 | Marche, Italy | |||
2022-06-20 | Italy | Marche | 484110 | 3926 | 0 | 43.61675973 | 13.5188753 | 2022-06-21 04:20:56 | Marche, Italy | |||
2022-06-19 | Italy | Marche | 483776 | 3924 | 0 | 43.61675973 | 13.5188753 | 2022-06-20 04:21:01 | Marche, Italy | |||
2022-06-18 | Italy | Marche | 483047 | 3924 | 0 | 43.61675973 | 13.5188753 | 2022-06-19 04:20:51 | Marche, Italy | |||
2022-06-17 | Italy | Marche | 482247 | 3923 | 0 | 43.61675973 | 13.5188753 | 2022-06-18 04:21:10 | Marche, Italy | |||
2022-06-16 | Italy | Marche | 481423 | 3923 | 0 | 43.61675973 | 13.5188753 | 2022-06-17 04:20:56 | Marche, Italy | |||
2022-06-15 | Italy | Marche | 480579 | 3923 | 0 | 43.61675973 | 13.5188753 | 2022-06-16 04:20:55 | Marche, Italy | |||
2022-06-14 | Italy | Marche | 479887 | 3922 | 0 | 43.61675973 | 13.5188753 | 2022-06-15 04:20:54 | Marche, Italy | |||
2022-06-13 | Italy | Marche | 478973 | 3922 | 0 | 43.61675973 | 13.5188753 | 2022-06-14 04:20:52 | Marche, Italy |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;