johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
960 rows where country_or_region = "Italy", latitude = "43.61675973" and province_or_state = "Marche" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2016695 | 2016695 | 2022-09-20 | Italy | Marche | 614503 | 4107 | 0 | 43.61675973 | 13.5188753 | 2022-09-21 04:23:22 | Marche, Italy | |||
3570568 | 3570568 | 2022-09-19 | Italy | Marche | 613761 | 4107 | 0 | 43.61675973 | 13.5188753 | 2022-09-20 04:22:48 | Marche, Italy | |||
419307 | 419307 | 2022-09-18 | Italy | Marche | 613580 | 4104 | 0 | 43.61675973 | 13.5188753 | 2022-09-19 04:21:49 | Marche, Italy | |||
3373331 | 3373331 | 2022-09-17 | Italy | Marche | 613172 | 4103 | 0 | 43.61675973 | 13.5188753 | 2022-09-18 04:22:50 | Marche, Italy | |||
2355439 | 2355439 | 2022-09-16 | Italy | Marche | 612655 | 4103 | 0 | 43.61675973 | 13.5188753 | 2022-09-17 04:20:19 | Marche, Italy | |||
3986596 | 3986596 | 2022-09-15 | Italy | Marche | 612183 | 4103 | 0 | 43.61675973 | 13.5188753 | 2022-09-16 04:21:19 | Marche, Italy | |||
1889113 | 1889113 | 2022-09-14 | Italy | Marche | 611647 | 4102 | 0 | 43.61675973 | 13.5188753 | 2022-09-15 04:21:02 | Marche, Italy | |||
372168 | 372168 | 2022-09-13 | Italy | Marche | 611183 | 4102 | 0 | 43.61675973 | 13.5188753 | 2022-09-14 04:20:44 | Marche, Italy | |||
2394773 | 2394773 | 2022-09-12 | Italy | Marche | 610484 | 4068 | 0 | 43.61675973 | 13.5188753 | 2022-09-13 04:20:57 | Marche, Italy | |||
3765851 | 3765851 | 2022-09-11 | Italy | Marche | 609444 | 4096 | 0 | 43.61675973 | 13.5188753 | 2022-09-12 04:20:58 | Marche, Italy | |||
3824426 | 3824426 | 2022-09-10 | Italy | Marche | 609444 | 4096 | 0 | 43.61675973 | 13.5188753 | 2022-09-11 04:20:50 | Marche, Italy | |||
962883 | 962883 | 2022-09-09 | Italy | Marche | 609444 | 4096 | 0 | 43.61675973 | 13.5188753 | 2022-09-10 04:21:10 | Marche, Italy | |||
253285 | 253285 | 2022-09-08 | Italy | Marche | 608989 | 4096 | 0 | 43.61675973 | 13.5188753 | 2022-09-09 04:21:11 | Marche, Italy | |||
3745083 | 3745083 | 2022-09-07 | Italy | Marche | 608453 | 4095 | 0 | 43.61675973 | 13.5188753 | 2022-09-08 04:21:02 | Marche, Italy | |||
114723 | 114723 | 2022-09-06 | Italy | Marche | 607911 | 4094 | 0 | 43.61675973 | 13.5188753 | 2022-09-07 04:20:59 | Marche, Italy | |||
2633695 | 2633695 | 2022-09-05 | Italy | Marche | 607095 | 4094 | 0 | 43.61675973 | 13.5188753 | 2022-09-06 04:21:02 | Marche, Italy | |||
2987259 | 2987259 | 2022-09-04 | Italy | Marche | 606862 | 4094 | 0 | 43.61675973 | 13.5188753 | 2022-09-05 04:21:01 | Marche, Italy | |||
2712944 | 2712944 | 2022-09-03 | Italy | Marche | 606411 | 4094 | 0 | 43.61675973 | 13.5188753 | 2022-09-04 04:21:22 | Marche, Italy | |||
1393649 | 1393649 | 2022-09-02 | Italy | Marche | 605834 | 4094 | 0 | 43.61675973 | 13.5188753 | 2022-09-03 04:21:04 | Marche, Italy | |||
3547478 | 3547478 | 2022-09-01 | Italy | Marche | 605266 | 4092 | 0 | 43.61675973 | 13.5188753 | 2022-09-02 04:21:07 | Marche, Italy | |||
2343398 | 2343398 | 2022-08-31 | Italy | Marche | 604668 | 4092 | 0 | 43.61675973 | 13.5188753 | 2022-09-01 04:21:03 | Marche, Italy | |||
3773878 | 3773878 | 2022-08-30 | Italy | Marche | 604019 | 4091 | 0 | 43.61675973 | 13.5188753 | 2022-08-31 04:20:57 | Marche, Italy | |||
1680474 | 1680474 | 2022-08-29 | Italy | Marche | 603040 | 4091 | 0 | 43.61675973 | 13.5188753 | 2022-08-30 04:21:03 | Marche, Italy | |||
1876958 | 1876958 | 2022-08-28 | Italy | Marche | 602770 | 4091 | 0 | 43.61675973 | 13.5188753 | 2022-08-29 04:21:06 | Marche, Italy | |||
2096085 | 2096085 | 2022-08-27 | Italy | Marche | 602119 | 4090 | 0 | 43.61675973 | 13.5188753 | 2022-08-28 04:21:02 | Marche, Italy | |||
1531900 | 1531900 | 2022-08-26 | Italy | Marche | 601368 | 4090 | 0 | 43.61675973 | 13.5188753 | 2022-08-27 04:20:57 | Marche, Italy | |||
2828787 | 2828787 | 2022-08-25 | Italy | Marche | 600626 | 4087 | 0 | 43.61675973 | 13.5188753 | 2022-08-26 04:21:02 | Marche, Italy | |||
2323320 | 2323320 | 2022-08-24 | Italy | Marche | 599780 | 4086 | 0 | 43.61675973 | 13.5188753 | 2022-08-25 04:21:13 | Marche, Italy | |||
1250729 | 1250729 | 2022-08-23 | Italy | Marche | 598981 | 4085 | 0 | 43.61675973 | 13.5188753 | 2022-08-24 04:20:46 | Marche, Italy | |||
2852833 | 2852833 | 2022-08-22 | Italy | Marche | 597725 | 4084 | 0 | 43.61675973 | 13.5188753 | 2022-08-23 04:20:56 | Marche, Italy | |||
2402805 | 2402805 | 2022-08-21 | Italy | Marche | 597292 | 4084 | 0 | 43.61675973 | 13.5188753 | 2022-08-22 04:20:38 | Marche, Italy | |||
3797883 | 3797883 | 2022-08-20 | Italy | Marche | 596483 | 4082 | 0 | 43.61675973 | 13.5188753 | 2022-08-21 04:20:44 | Marche, Italy | |||
2363469 | 2363469 | 2022-08-19 | Italy | Marche | 595610 | 4080 | 0 | 43.61675973 | 13.5188753 | 2022-08-20 04:21:01 | Marche, Italy | |||
1161140 | 1161140 | 2022-08-18 | Italy | Marche | 594683 | 4078 | 0 | 43.61675973 | 13.5188753 | 2022-08-19 04:20:54 | Marche, Italy | |||
3950464 | 3950464 | 2022-08-17 | Italy | Marche | 593663 | 4072 | 0 | 43.61675973 | 13.5188753 | 2022-08-18 04:21:11 | Marche, Italy | |||
990966 | 990966 | 2022-08-16 | Italy | Marche | 592304 | 4072 | 0 | 43.61675973 | 13.5188753 | 2022-08-17 04:20:59 | Marche, Italy | |||
2494005 | 2494005 | 2022-08-15 | Italy | Marche | 591956 | 4070 | 0 | 43.61675973 | 13.5188753 | 2022-08-16 04:20:58 | Marche, Italy | |||
3647555 | 3647555 | 2022-08-14 | Italy | Marche | 591472 | 4070 | 0 | 43.61675973 | 13.5188753 | 2022-08-15 04:20:59 | Marche, Italy | |||
1968561 | 1968561 | 2022-08-13 | Italy | Marche | 590692 | 4067 | 0 | 43.61675973 | 13.5188753 | 2022-08-14 04:20:55 | Marche, Italy | |||
2888370 | 2888370 | 2022-08-12 | Italy | Marche | 589761 | 4065 | 0 | 43.61675973 | 13.5188753 | 2022-08-13 04:20:52 | Marche, Italy | |||
3907975 | 3907975 | 2022-08-11 | Italy | Marche | 588806 | 4062 | 0 | 43.61675973 | 13.5188753 | 2022-08-12 04:20:54 | Marche, Italy | |||
1346292 | 1346292 | 2022-08-10 | Italy | Marche | 587813 | 4059 | 0 | 43.61675973 | 13.5188753 | 2022-08-11 04:20:49 | Marche, Italy | |||
1086047 | 1086047 | 2022-08-09 | Italy | Marche | 586885 | 4055 | 0 | 43.61675973 | 13.5188753 | 2022-08-10 04:20:57 | Marche, Italy | |||
3543462 | 3543462 | 2022-08-08 | Italy | Marche | 585371 | 4051 | 0 | 43.61675973 | 13.5188753 | 2022-08-09 04:20:34 | Marche, Italy | |||
1069865 | 1069865 | 2022-08-07 | Italy | Marche | 584968 | 4048 | 0 | 43.61675973 | 13.5188753 | 2022-08-08 04:21:08 | Marche, Italy | |||
1940453 | 1940453 | 2022-08-06 | Italy | Marche | 583889 | 4046 | 0 | 43.61675973 | 13.5188753 | 2022-08-07 04:20:54 | Marche, Italy | |||
880252 | 880252 | 2022-08-05 | Italy | Marche | 582762 | 4044 | 0 | 43.61675973 | 13.5188753 | 2022-08-06 04:20:56 | Marche, Italy | |||
2008663 | 2008663 | 2022-08-04 | Italy | Marche | 581437 | 4042 | 0 | 43.61675973 | 13.5188753 | 2022-08-05 04:20:52 | Marche, Italy | |||
1098090 | 1098090 | 2022-08-03 | Italy | Marche | 579918 | 4039 | 0 | 43.61675973 | 13.5188753 | 2022-08-04 04:20:58 | Marche, Italy | |||
1405015 | 1405015 | 2022-08-02 | Italy | Marche | 578346 | 4032 | 0 | 43.61675973 | 13.5188753 | 2022-08-03 04:20:59 | Marche, Italy | |||
3617053 | 3617053 | 2022-08-01 | Italy | Marche | 575959 | 4031 | 0 | 43.61675973 | 13.5188753 | 2022-08-02 04:20:53 | Marche, Italy | |||
3871533 | 3871533 | 2022-07-31 | Italy | Marche | 575282 | 4026 | 0 | 43.61675973 | 13.5188753 | 2022-08-01 04:21:03 | Marche, Italy | |||
674287 | 674287 | 2022-07-30 | Italy | Marche | 573768 | 4022 | 0 | 43.61675973 | 13.5188753 | 2022-07-31 04:21:02 | Marche, Italy | |||
1783486 | 1783486 | 2022-07-29 | Italy | Marche | 571956 | 4016 | 0 | 43.61675973 | 13.5188753 | 2022-07-30 04:20:42 | Marche, Italy | |||
1065849 | 1065849 | 2022-07-28 | Italy | Marche | 569878 | 4010 | 0 | 43.61675973 | 13.5188753 | 2022-07-29 04:20:45 | Marche, Italy | |||
2335368 | 2335368 | 2022-07-27 | Italy | Marche | 567645 | 4006 | 0 | 43.61675973 | 13.5188753 | 2022-07-28 04:20:56 | Marche, Italy | |||
1487558 | 1487558 | 2022-07-26 | Italy | Marche | 565310 | 3999 | 0 | 43.61675973 | 13.5188753 | 2022-07-27 04:21:04 | Marche, Italy | |||
2594004 | 2594004 | 2022-07-25 | Italy | Marche | 562206 | 3992 | 0 | 43.61675973 | 13.5188753 | 2022-07-26 04:20:58 | Marche, Italy | |||
896119 | 896119 | 2022-07-24 | Italy | Marche | 561253 | 3988 | 0 | 43.61675973 | 13.5188753 | 2022-07-25 04:20:51 | Marche, Italy | |||
91113 | 91113 | 2022-07-23 | Italy | Marche | 559272 | 3988 | 0 | 43.61675973 | 13.5188753 | 2022-07-24 04:20:47 | Marche, Italy | |||
900135 | 900135 | 2022-07-22 | Italy | Marche | 557069 | 3985 | 0 | 43.61675973 | 13.5188753 | 2022-07-23 04:20:53 | Marche, Italy | |||
670271 | 670271 | 2022-07-21 | Italy | Marche | 554711 | 3976 | 0 | 43.61675973 | 13.5188753 | 2022-07-22 04:21:15 | Marche, Italy | |||
1608234 | 1608234 | 2022-07-20 | Italy | Marche | 552039 | 3971 | 0 | 43.61675973 | 13.5188753 | 2022-07-21 04:21:10 | Marche, Italy | |||
958867 | 958867 | 2022-07-19 | Italy | Marche | 549519 | 3971 | 0 | 43.61675973 | 13.5188753 | 2022-07-20 04:20:59 | Marche, Italy | |||
3210254 | 3210254 | 2022-07-18 | Italy | Marche | 545796 | 3968 | 0 | 43.61675973 | 13.5188753 | 2022-07-19 04:20:58 | Marche, Italy | |||
3405429 | 3405429 | 2022-07-17 | Italy | Marche | 544720 | 3967 | 0 | 43.61675973 | 13.5188753 | 2022-07-18 04:20:59 | Marche, Italy | |||
2151629 | 2151629 | 2022-07-16 | Italy | Marche | 542252 | 3966 | 0 | 43.61675973 | 13.5188753 | 2022-07-17 04:21:15 | Marche, Italy | |||
2418862 | 2418862 | 2022-07-15 | Italy | Marche | 539267 | 3963 | 0 | 43.61675973 | 13.5188753 | 2022-07-16 04:21:05 | Marche, Italy | |||
3428937 | 3428937 | 2022-07-14 | Italy | Marche | 536303 | 3962 | 0 | 43.61675973 | 13.5188753 | 2022-07-15 04:20:53 | Marche, Italy | |||
3109457 | 3109457 | 2022-07-13 | Italy | Marche | 532879 | 3960 | 0 | 43.61675973 | 13.5188753 | 2022-07-14 04:20:57 | Marche, Italy | |||
629880 | 629880 | 2022-07-12 | Italy | Marche | 529685 | 3959 | 0 | 43.61675973 | 13.5188753 | 2022-07-13 04:20:58 | Marche, Italy | |||
1211524 | 1211524 | 2022-07-11 | Italy | Marche | 525575 | 3958 | 0 | 43.61675973 | 13.5188753 | 2022-07-12 04:20:51 | Marche, Italy | |||
2789006 | 2789006 | 2022-07-10 | Italy | Marche | 524388 | 3957 | 0 | 43.61675973 | 13.5188753 | 2022-07-11 04:20:46 | Marche, Italy | |||
141959 | 141959 | 2022-07-09 | Italy | Marche | 521792 | 3953 | 0 | 43.61675973 | 13.5188753 | 2022-07-10 04:20:54 | Marche, Italy | |||
1417059 | 1417059 | 2022-07-08 | Italy | Marche | 518964 | 3950 | 0 | 43.61675973 | 13.5188753 | 2022-07-09 04:20:59 | Marche, Italy | |||
2740984 | 2740984 | 2022-07-07 | Italy | Marche | 515939 | 3948 | 0 | 43.61675973 | 13.5188753 | 2022-07-08 04:20:56 | Marche, Italy | |||
1199779 | 1199779 | 2022-07-06 | Italy | Marche | 512863 | 3946 | 0 | 43.61675973 | 13.5188753 | 2022-07-07 04:20:55 | Marche, Italy | |||
3966522 | 3966522 | 2022-07-05 | Italy | Marche | 509978 | 3942 | 0 | 43.61675973 | 13.5188753 | 2022-07-06 04:20:58 | Marche, Italy | |||
3078033 | 3078033 | 2022-07-04 | Italy | Marche | 506292 | 3942 | 0 | 43.61675973 | 13.5188753 | 2022-07-05 04:20:45 | Marche, Italy | |||
1767315 | 1767315 | 2022-07-03 | Italy | Marche | 505275 | 3941 | 0 | 43.61675973 | 13.5188753 | 2022-07-04 04:20:54 | Marche, Italy | |||
3365301 | 3365301 | 2022-07-02 | Italy | Marche | 503278 | 3940 | 0 | 43.61675973 | 13.5188753 | 2022-07-03 04:20:59 | Marche, Italy | |||
593630 | 593630 | 2022-07-01 | Italy | Marche | 501221 | 3940 | 0 | 43.61675973 | 13.5188753 | 2022-07-02 04:21:16 | Marche, Italy | |||
3940031 | 3940031 | 2022-06-30 | Italy | Marche | 499057 | 3939 | 0 | 43.61675973 | 13.5188753 | 2022-07-01 04:21:10 | Marche, Italy | |||
2489989 | 2489989 | 2022-06-29 | Italy | Marche | 496880 | 3937 | 0 | 43.61675973 | 13.5188753 | 2022-06-30 04:21:01 | Marche, Italy | |||
2239371 | 2239371 | 2022-06-28 | Italy | Marche | 494942 | 3935 | 0 | 43.61675973 | 13.5188753 | 2022-06-29 04:20:59 | Marche, Italy | |||
2147613 | 2147613 | 2022-06-27 | Italy | Marche | 492497 | 3935 | 0 | 43.61675973 | 13.5188753 | 2022-06-28 04:20:58 | Marche, Italy | |||
475414 | 475414 | 2022-06-26 | Italy | Marche | 491804 | 3932 | 0 | 43.61675973 | 13.5188753 | 2022-06-27 04:21:00 | Marche, Italy | |||
938789 | 938789 | 2022-06-25 | Italy | Marche | 490521 | 3932 | 0 | 43.61675973 | 13.5188753 | 2022-06-26 04:21:02 | Marche, Italy | |||
3346609 | 3346609 | 2022-06-24 | Italy | Marche | 489295 | 3932 | 0 | 43.61675973 | 13.5188753 | 2022-06-25 04:20:57 | Marche, Italy | |||
1648350 | 1648350 | 2022-06-23 | Italy | Marche | 487972 | 3932 | 0 | 43.61675973 | 13.5188753 | 2022-06-24 04:20:58 | Marche, Italy | |||
2187585 | 2187585 | 2022-06-22 | Italy | Marche | 486665 | 3931 | 0 | 43.61675973 | 13.5188753 | 2022-06-23 04:20:55 | Marche, Italy | |||
166016 | 166016 | 2022-06-21 | Italy | Marche | 485498 | 3928 | 0 | 43.61675973 | 13.5188753 | 2022-06-22 04:20:54 | Marche, Italy | |||
1763299 | 1763299 | 2022-06-20 | Italy | Marche | 484110 | 3926 | 0 | 43.61675973 | 13.5188753 | 2022-06-21 04:20:56 | Marche, Italy | |||
3269485 | 3269485 | 2022-06-19 | Italy | Marche | 483776 | 3924 | 0 | 43.61675973 | 13.5188753 | 2022-06-20 04:21:01 | Marche, Italy | |||
3397397 | 3397397 | 2022-06-18 | Italy | Marche | 483047 | 3924 | 0 | 43.61675973 | 13.5188753 | 2022-06-19 04:20:51 | Marche, Italy | |||
2311274 | 2311274 | 2022-06-17 | Italy | Marche | 482247 | 3923 | 0 | 43.61675973 | 13.5188753 | 2022-06-18 04:21:10 | Marche, Italy | |||
558778 | 558778 | 2022-06-16 | Italy | Marche | 481423 | 3923 | 0 | 43.61675973 | 13.5188753 | 2022-06-17 04:20:56 | Marche, Italy | |||
3982580 | 3982580 | 2022-06-15 | Italy | Marche | 480579 | 3923 | 0 | 43.61675973 | 13.5188753 | 2022-06-16 04:20:55 | Marche, Italy | |||
946821 | 946821 | 2022-06-14 | Italy | Marche | 479887 | 3922 | 0 | 43.61675973 | 13.5188753 | 2022-06-15 04:20:54 | Marche, Italy | |||
2979229 | 2979229 | 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 TABLE [johns_hopkins_csse_daily_reports] ( [day] TEXT, [country_or_region] TEXT, [province_or_state] TEXT, [admin2] TEXT, [fips] TEXT, [confirmed] INTEGER, [deaths] INTEGER, [recovered] INTEGER, [active] TEXT, [latitude] TEXT, [longitude] TEXT, [last_update] TEXT, [combined_key] TEXT ); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_day] ON [johns_hopkins_csse_daily_reports] ([day]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_province_or_state] ON [johns_hopkins_csse_daily_reports] ([province_or_state]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_country_or_region] ON [johns_hopkins_csse_daily_reports] ([country_or_region]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_combined_key] ON [johns_hopkins_csse_daily_reports] ([combined_key]);