johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
960 rows where country_or_region = "Italy" and province_or_state = "Marche" sorted by active
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date), last_update (date)
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active ▼ | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
301 | 301 | 2021-12-02 | Italy | Marche | 124773 | 3154 | 0 | 43.61675973 | 13.5188753 | 2021-12-03 04:23:05 | Marche, Italy | |||
4317 | 4317 | 2021-10-28 | Italy | Marche | 115864 | 3103 | 0 | 43.61675973 | 13.5188753 | 2021-10-29 04:22:03 | Marche, Italy | |||
16342 | 16342 | 2021-09-18 | Italy | Marche | 112959 | 3063 | 0 | 43.61675973 | 13.5188753 | 2021-09-19 04:21:34 | Marche, Italy | |||
24372 | 24372 | 2022-03-20 | Italy | Marche | 364967 | 3661 | 0 | 43.61675973 | 13.5188753 | 2022-03-21 04:20:50 | Marche, Italy | |||
28387 | 28387 | 2021-11-11 | Italy | Marche | 117941 | 3118 | 0 | 43.61675973 | 13.5188753 | 2021-11-12 04:22:01 | Marche, Italy | |||
32403 | 32403 | 2021-08-25 | Italy | Marche | 109494 | 3045 | 0 | 43.61675973 | 13.5188753 | 2021-08-26 04:21:28 | Marche, Italy | |||
43679 | 43679 | 2021-11-02 | Italy | Marche | 116319 | 3107 | 0 | 43.61675973 | 13.5188753 | 2021-11-03 06:22:09 | Marche, Italy | |||
63033 | 63033 | 2022-11-12 | Italy | Marche | 660388 | 4185 | 0 | 43.61675973 | 13.5188753 | 2022-11-13 04:21:14 | Marche, Italy | |||
67048 | 67048 | 2021-09-01 | Italy | Marche | 110686 | 3046 | 0 | 43.61675973 | 13.5188753 | 2021-09-02 04:21:15 | Marche, Italy | |||
71062 | 71062 | 2022-02-07 | Italy | Marche | 286561 | 3468 | 0 | 43.61675973 | 13.5188753 | 2022-02-08 04:21:15 | Marche, Italy | |||
87096 | 87096 | 2021-11-09 | Italy | Marche | 117410 | 3115 | 0 | 43.61675973 | 13.5188753 | 2021-11-10 04:21:38 | Marche, Italy | |||
91113 | 91113 | 2022-07-23 | Italy | Marche | 559272 | 3988 | 0 | 43.61675973 | 13.5188753 | 2022-07-24 04:20:47 | Marche, Italy | |||
99297 | 99297 | 2022-01-14 | Italy | Marche | 171633 | 3302 | 0 | 43.61675973 | 13.5188753 | 2022-01-15 04:21:07 | Marche, Italy | |||
103313 | 103313 | 2021-08-15 | Italy | Marche | 108004 | 3043 | 0 | 43.61675973 | 13.5188753 | 2021-08-16 04:21:31 | Marche, Italy | |||
114723 | 114723 | 2022-09-06 | Italy | Marche | 607911 | 4094 | 0 | 43.61675973 | 13.5188753 | 2022-09-07 04:20:59 | Marche, Italy | |||
126704 | 126704 | 2022-01-09 | Italy | Marche | 160404 | 3286 | 0 | 43.61675973 | 13.5188753 | 2022-01-10 04:22:07 | Marche, Italy | |||
130721 | 130721 | 2022-10-04 | Italy | Marche | 627236 | 4113 | 0 | 43.61675973 | 13.5188753 | 2022-10-05 04:23:06 | Marche, Italy | |||
137942 | 137942 | 2021-12-04 | Italy | Marche | 125693 | 3157 | 0 | 43.61675973 | 13.5188753 | 2021-12-05 04:22:25 | Marche, Italy | |||
141959 | 141959 | 2022-07-09 | Italy | Marche | 521792 | 3953 | 0 | 43.61675973 | 13.5188753 | 2022-07-10 04:20:54 | Marche, Italy | |||
149955 | 149955 | 2021-11-29 | Italy | Marche | 123443 | 3149 | 0 | 43.61675973 | 13.5188753 | 2021-11-30 04:22:53 | Marche, Italy | |||
157984 | 157984 | 2022-03-29 | Italy | Marche | 385722 | 3697 | 0 | 43.61675973 | 13.5188753 | 2022-03-30 04:20:45 | Marche, Italy | |||
161999 | 161999 | 2021-11-19 | Italy | Marche | 120020 | 3128 | 0 | 43.61675973 | 13.5188753 | 2021-11-20 04:22:17 | Marche, Italy | |||
166016 | 166016 | 2022-06-21 | Italy | Marche | 485498 | 3928 | 0 | 43.61675973 | 13.5188753 | 2022-06-22 04:20:54 | Marche, Italy | |||
178013 | 178013 | 2021-09-02 | Italy | Marche | 110910 | 3047 | 0 | 43.61675973 | 13.5188753 | 2021-09-03 04:21:20 | Marche, Italy | |||
186042 | 186042 | 2022-02-13 | Italy | Marche | 302979 | 3503 | 0 | 43.61675973 | 13.5188753 | 2022-02-14 04:20:51 | Marche, Italy | |||
198230 | 198230 | 2022-10-19 | Italy | Marche | 644884 | 4142 | 0 | 43.61675973 | 13.5188753 | 2022-10-20 04:22:59 | Marche, Italy | |||
217951 | 217951 | 2022-12-26 | Italy | Marche | 698559 | 4271 | 0 | 43.61675973 | 13.5188753 | 2022-12-27 04:21:07 | Marche, Italy | |||
221967 | 221967 | 2022-05-09 | Italy | Marche | 455853 | 3863 | 0 | 43.61675973 | 13.5188753 | 2022-05-10 04:20:50 | Marche, Italy | |||
229198 | 229198 | 2022-05-31 | Italy | Marche | 473436 | 3904 | 0 | 43.61675973 | 13.5188753 | 2022-06-01 04:20:55 | Marche, Italy | |||
233214 | 233214 | 2022-02-11 | Italy | Marche | 298417 | 3492 | 0 | 43.61675973 | 13.5188753 | 2022-02-12 04:21:06 | Marche, Italy | |||
245256 | 245256 | 2021-08-17 | Italy | Marche | 108174 | 3043 | 0 | 43.61675973 | 13.5188753 | 2021-08-18 04:21:35 | Marche, Italy | |||
249270 | 249270 | 2021-09-04 | Italy | Marche | 111253 | 3049 | 0 | 43.61675973 | 13.5188753 | 2021-09-05 04:21:33 | Marche, Italy | |||
253285 | 253285 | 2022-09-08 | Italy | Marche | 608989 | 4096 | 0 | 43.61675973 | 13.5188753 | 2022-09-09 04:21:11 | Marche, Italy | |||
257301 | 257301 | 2022-12-10 | Italy | Marche | 687506 | 4220 | 0 | 43.61675973 | 13.5188753 | 2022-12-11 04:20:50 | Marche, Italy | |||
261504 | 261504 | 2022-03-15 | Italy | Marche | 351836 | 3643 | 0 | 43.61675973 | 13.5188753 | 2022-03-16 04:20:50 | Marche, Italy | |||
276154 | 276154 | 2021-11-03 | Italy | Marche | 116459 | 3108 | 0 | 43.61675973 | 13.5188753 | 2021-11-04 04:22:20 | Marche, Italy | |||
287967 | 287967 | 2021-10-31 | Italy | Marche | 116232 | 3107 | 0 | 43.61675973 | 13.5188753 | 2021-11-01 04:22:01 | Marche, Italy | |||
291984 | 291984 | 2022-11-15 | Italy | Marche | 660388 | 4185 | 0 | 43.61675973 | 13.5188753 | 2022-11-16 04:21:09 | Marche, Italy | |||
303840 | 303840 | 2022-04-16 | Italy | Marche | 420642 | 3787 | 0 | 43.61675973 | 13.5188753 | 2022-04-17 04:20:59 | Marche, Italy | |||
307856 | 307856 | 2022-12-13 | Italy | Marche | 687506 | 4220 | 0 | 43.61675973 | 13.5188753 | 2022-12-14 04:21:04 | Marche, Italy | |||
311872 | 311872 | 2022-11-13 | Italy | Marche | 660388 | 4185 | 0 | 43.61675973 | 13.5188753 | 2022-11-14 04:21:09 | Marche, Italy | |||
315888 | 315888 | 2022-02-12 | Italy | Marche | 300826 | 3497 | 0 | 43.61675973 | 13.5188753 | 2022-02-13 04:21:00 | Marche, Italy | |||
319904 | 319904 | 2022-10-30 | Italy | Marche | 653197 | 4160 | 0 | 43.61675973 | 13.5188753 | 2022-10-31 04:21:36 | Marche, Italy | |||
327878 | 327878 | 2022-12-27 | Italy | Marche | 698559 | 4271 | 0 | 43.61675973 | 13.5188753 | 2022-12-28 04:21:04 | Marche, Italy | |||
335908 | 335908 | 2022-03-18 | Italy | Marche | 360011 | 3653 | 0 | 43.61675973 | 13.5188753 | 2022-03-19 04:20:47 | Marche, Italy | |||
348268 | 348268 | 2022-12-14 | Italy | Marche | 687506 | 4220 | 0 | 43.61675973 | 13.5188753 | 2022-12-15 04:20:58 | Marche, Italy | |||
356298 | 356298 | 2022-03-11 | Italy | Marche | 344048 | 3626 | 0 | 43.61675973 | 13.5188753 | 2022-03-12 04:20:50 | Marche, Italy | |||
360314 | 360314 | 2022-05-07 | Italy | Marche | 454146 | 3857 | 0 | 43.61675973 | 13.5188753 | 2022-05-08 04:20:49 | Marche, Italy | |||
372168 | 372168 | 2022-09-13 | Italy | Marche | 611183 | 4102 | 0 | 43.61675973 | 13.5188753 | 2022-09-14 04:20:44 | Marche, Italy | |||
384195 | 384195 | 2022-09-23 | Italy | Marche | 616264 | 4109 | 0 | 43.61675973 | 13.5188753 | 2022-09-24 04:21:40 | Marche, Italy | |||
396236 | 396236 | 2022-10-07 | Italy | Marche | 631161 | 4119 | 0 | 43.61675973 | 13.5188753 | 2022-10-08 04:22:56 | Marche, Italy | |||
404265 | 404265 | 2021-12-07 | Italy | Marche | 126727 | 3163 | 0 | 43.61675973 | 13.5188753 | 2021-12-08 04:22:46 | Marche, Italy | |||
419307 | 419307 | 2022-09-18 | Italy | Marche | 613580 | 4104 | 0 | 43.61675973 | 13.5188753 | 2022-09-19 04:21:49 | Marche, Italy | |||
423322 | 423322 | 2021-10-10 | Italy | Marche | 114532 | 3082 | 0 | 43.61675973 | 13.5188753 | 2021-10-11 04:21:31 | Marche, Italy | |||
431329 | 431329 | 2022-11-03 | Italy | Marche | 653197 | 4160 | 0 | 43.61675973 | 13.5188753 | 2022-11-04 04:22:11 | Marche, Italy | |||
443326 | 443326 | 2021-10-20 | Italy | Marche | 115108 | 3091 | 0 | 43.61675973 | 13.5188753 | 2021-10-21 04:21:18 | Marche, Italy | |||
447342 | 447342 | 2021-11-17 | Italy | Marche | 119340 | 3124 | 0 | 43.61675973 | 13.5188753 | 2021-11-18 04:21:33 | Marche, Italy | |||
451359 | 451359 | 2022-12-21 | Italy | Marche | 693888 | 4237 | 0 | 43.61675973 | 13.5188753 | 2022-12-22 04:20:56 | Marche, Italy | |||
459351 | 459351 | 2022-02-02 | Italy | Marche | 271899 | 3433 | 0 | 43.61675973 | 13.5188753 | 2022-02-03 04:21:21 | Marche, Italy | |||
463368 | 463368 | 2022-05-02 | Italy | Marche | 446355 | 3843 | 0 | 43.61675973 | 13.5188753 | 2022-05-03 04:21:00 | Marche, Italy | |||
467383 | 467383 | 2021-10-07 | Italy | Marche | 114321 | 3079 | 0 | 43.61675973 | 13.5188753 | 2021-10-08 04:21:25 | Marche, Italy | |||
475414 | 475414 | 2022-06-26 | Italy | Marche | 491804 | 3932 | 0 | 43.61675973 | 13.5188753 | 2022-06-27 04:21:00 | Marche, Italy | |||
479562 | 479562 | 2022-11-08 | Italy | Marche | 656096 | 4170 | 0 | 43.61675973 | 13.5188753 | 2022-11-09 04:21:22 | Marche, Italy | |||
487592 | 487592 | 2022-11-25 | Italy | Marche | 672388 | 4196 | 0 | 43.61675973 | 13.5188753 | 2022-11-26 04:21:11 | Marche, Italy | |||
491607 | 491607 | 2021-10-14 | Italy | Marche | 114714 | 3085 | 0 | 43.61675973 | 13.5188753 | 2021-10-15 04:21:26 | Marche, Italy | |||
495623 | 495623 | 2021-11-06 | Italy | Marche | 117042 | 3114 | 0 | 43.61675973 | 13.5188753 | 2021-11-07 04:21:53 | Marche, Italy | |||
499640 | 499640 | 2022-04-02 | Italy | Marche | 395052 | 3716 | 0 | 43.61675973 | 13.5188753 | 2022-04-03 04:20:48 | Marche, Italy | |||
503656 | 503656 | 2022-12-17 | Italy | Marche | 693888 | 4237 | 0 | 43.61675973 | 13.5188753 | 2022-12-18 04:21:03 | Marche, Italy | |||
507671 | 507671 | 2021-08-14 | Italy | Marche | 107844 | 3043 | 0 | 43.61675973 | 13.5188753 | 2021-08-15 04:21:41 | Marche, Italy | |||
511685 | 511685 | 2021-08-19 | Italy | Marche | 108587 | 3043 | 0 | 43.61675973 | 13.5188753 | 2021-08-20 04:21:33 | Marche, Italy | |||
515700 | 515700 | 2022-10-15 | Italy | Marche | 640840 | 4135 | 0 | 43.61675973 | 13.5188753 | 2022-10-16 04:22:39 | Marche, Italy | |||
534707 | 534707 | 2021-10-27 | Italy | Marche | 115773 | 3101 | 0 | 43.61675973 | 13.5188753 | 2021-10-28 04:22:08 | Marche, Italy | |||
538724 | 538724 | 2022-10-26 | Italy | Marche | 650927 | 4155 | 0 | 43.61675973 | 13.5188753 | 2022-10-27 04:22:01 | Marche, Italy | |||
542740 | 542740 | 2022-12-15 | Italy | Marche | 687506 | 4220 | 0 | 43.61675973 | 13.5188753 | 2022-12-16 04:21:01 | Marche, Italy | |||
550745 | 550745 | 2021-12-08 | Italy | Marche | 127191 | 3163 | 0 | 43.61675973 | 13.5188753 | 2021-12-09 04:22:49 | Marche, Italy | |||
554761 | 554761 | 2022-01-16 | Italy | Marche | 182322 | 3311 | 0 | 43.61675973 | 13.5188753 | 2022-01-17 04:21:08 | Marche, Italy | |||
558778 | 558778 | 2022-06-16 | Italy | Marche | 481423 | 3923 | 0 | 43.61675973 | 13.5188753 | 2022-06-17 04:20:56 | Marche, Italy | |||
567075 | 567075 | 2021-10-29 | Italy | Marche | 115986 | 3104 | 0 | 43.61675973 | 13.5188753 | 2021-10-30 04:22:03 | Marche, Italy | |||
574804 | 574804 | 2022-02-25 | Italy | Marche | 323957 | 3576 | 0 | 43.61675973 | 13.5188753 | 2022-02-26 04:21:12 | Marche, Italy | |||
589615 | 589615 | 2021-08-08 | Italy | Marche | 106875 | 3041 | 0 | 43.61675973 | 13.5188753 | 2021-08-09 04:21:24 | Marche, Italy | |||
593630 | 593630 | 2022-07-01 | Italy | Marche | 501221 | 3940 | 0 | 43.61675973 | 13.5188753 | 2022-07-02 04:21:16 | Marche, Italy | |||
597645 | 597645 | 2021-10-19 | Italy | Marche | 115004 | 3090 | 0 | 43.61675973 | 13.5188753 | 2021-10-20 04:21:00 | Marche, Italy | |||
601661 | 601661 | 2021-09-23 | Italy | Marche | 113403 | 3068 | 0 | 43.61675973 | 13.5188753 | 2021-09-24 04:21:44 | Marche, Italy | |||
617834 | 617834 | 2022-11-05 | Italy | Marche | 656096 | 4170 | 0 | 43.61675973 | 13.5188753 | 2022-11-06 04:21:24 | Marche, Italy | |||
621850 | 621850 | 2022-05-22 | Italy | Marche | 470721 | 3896 | 0 | 43.61675973 | 13.5188753 | 2022-05-26 04:20:50 | Marche, Italy | |||
629880 | 629880 | 2022-07-12 | Italy | Marche | 529685 | 3959 | 0 | 43.61675973 | 13.5188753 | 2022-07-13 04:20:58 | Marche, Italy | |||
633895 | 633895 | 2021-10-13 | Italy | Marche | 114674 | 3083 | 0 | 43.61675973 | 13.5188753 | 2021-10-14 04:21:29 | Marche, Italy | |||
641925 | 641925 | 2021-09-07 | Italy | Marche | 111551 | 3052 | 0 | 43.61675973 | 13.5188753 | 2021-09-08 04:21:31 | Marche, Italy | |||
649953 | 649953 | 2021-08-09 | Italy | Marche | 106921 | 3041 | 0 | 43.61675973 | 13.5188753 | 2021-08-10 04:21:27 | Marche, Italy | |||
653967 | 653967 | 2021-10-22 | Italy | Marche | 115324 | 3092 | 0 | 43.61675973 | 13.5188753 | 2021-10-23 04:21:32 | Marche, Italy | |||
658286 | 658286 | 2022-05-13 | Italy | Marche | 461431 | 3870 | 0 | 43.61675973 | 13.5188753 | 2022-05-14 04:20:48 | Marche, Italy | |||
670271 | 670271 | 2022-07-21 | Italy | Marche | 554711 | 3976 | 0 | 43.61675973 | 13.5188753 | 2022-07-22 04:21:15 | Marche, Italy | |||
674287 | 674287 | 2022-07-30 | Italy | Marche | 573768 | 4022 | 0 | 43.61675973 | 13.5188753 | 2022-07-31 04:21:02 | Marche, Italy | |||
682312 | 682312 | 2021-10-24 | Italy | Marche | 115520 | 3095 | 0 | 43.61675973 | 13.5188753 | 2021-10-25 04:22:31 | Marche, Italy | |||
686328 | 686328 | 2021-11-13 | Italy | Marche | 118404 | 3120 | 0 | 43.61675973 | 13.5188753 | 2021-11-14 04:21:31 | Marche, Italy | |||
690345 | 690345 | 2022-12-23 | Italy | Marche | 698559 | 4271 | 0 | 43.61675973 | 13.5188753 | 2022-12-24 04:21:02 | Marche, Italy | |||
694361 | 694361 | 2022-03-17 | Italy | Marche | 357149 | 3646 | 0 | 43.61675973 | 13.5188753 | 2022-03-18 04:20:55 | Marche, Italy | |||
698376 | 698376 | 2021-11-04 | Italy | Marche | 116618 | 3109 | 0 | 43.61675973 | 13.5188753 | 2021-11-05 04:21:54 | Marche, Italy | |||
706406 | 706406 | 2021-09-29 | Italy | Marche | 113775 | 3077 | 0 | 43.61675973 | 13.5188753 | 2021-09-30 04:21:20 | Marche, Italy | |||
710422 | 710422 | 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 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]);