daily_reports (view)

⚠️ This table has been renamed. Use johns_hopkins_csse_daily_reports instead.

Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette

1,826 rows where country_or_region = "Italy" sorted by confirmed descending

View and edit SQL

Suggested facets: latitude, longitude, combined_key, day (date), last_update (date)

country_or_region

  • Italy · 1,826
day country_or_region province_or_state admin2 fips confirmed ▲ deaths recovered active latitude longitude last_update combined_key
2020-05-13 Italy       222104 31106 112541 78457 41.87194 12.56738 2020-05-14 03:32:28 Italy
2020-05-12 Italy       221216 30911 109039 81266 41.87194 12.56738 2020-05-13 03:32:26 Italy
2020-05-11 Italy       219814 30739 106587 82488 41.87194 12.56738 2020-05-12 03:32:27 Italy
2020-05-10 Italy       219070 30560 105186 83324 41.87194 12.56738 2020-05-11 02:32:30 Italy
2020-05-09 Italy       218268 30395 103031 84842 41.87194 12.56738 2020-05-10 02:32:30 Italy
2020-05-08 Italy       217185 30201 99023 87961 41.87194 12.56738 2020-05-09 02:32:35 Italy
2020-05-07 Italy       215858 29958 96276 89624 41.87194 12.56738 2020-05-08 02:32:32 Italy
2020-05-06 Italy       214457 29684 93245 91528 41.87194 12.56738 2020-05-07 02:32:28 Italy
2020-05-05 Italy       213013 29315 85231 98467 41.87194 12.56738 2020-05-06 02:32:31 Italy
2020-05-04 Italy       211938 29079 82879 99980 41.87194 12.56738 2020-05-05 02:32:34 Italy
2020-05-03 Italy       210717 28884 81654 100179 41.87194 12.56738 2020-05-04 02:32:28 Italy
2020-05-02 Italy       209328 28710 79914 100704 41.87194 12.56738 2020-05-03 02:32:28 Italy
2020-05-01 Italy       207428 28236 78249 100943 41.87194 12.56738 2020-05-02 02:32:27 Italy
2020-04-30 Italy       205463 27967 75945 101551 41.87194 12.56738 2020-05-01 02:32:28 Italy
2020-04-29 Italy       203591 27682 71252 104657 41.87194 12.56738 2020-04-30 02:32:27 Italy
2020-04-28 Italy       201505 27359 68941 105205 41.87194 12.56738 2020-04-29 02:32:29 Italy
2020-04-27 Italy       199414 26977 66624 105813 41.87194 12.56738 2020-04-28 02:30:32 Italy
2020-04-26 Italy       197675 26644 64928 106103 41.87194 12.56738 2020-04-27 02:30:33 Italy
2020-04-25 Italy       195351 26384 63120 105847 41.87194 12.56738 2020-04-26 02:30:31 Italy
2020-04-24 Italy       192994 25969 60498 106527 41.87194 12.56738 2020-04-25 06:30:33 Italy
2020-04-23 Italy       189973 25549 57576 106848 41.87194 12.56738 2020-04-24 03:30:31 Italy
2020-04-22 Italy       187327 25085 54543 107699 41.87194 12.56738 2020-04-22 23:30:32 Italy
2020-04-21 Italy       183957 24648 51600 107709 41.87194 12.56738 2020-04-21 23:30:30 Italy
2020-04-20 Italy       181228 24114 48877 108237 41.87194 12.56738 2020-04-20 23:36:27 Italy
2020-04-19 Italy       178972 23660 47055 108257 41.87194 12.56738 2020-04-19 23:40:41 Italy
2020-04-18 Italy       175925 23227 44927 107771 41.87194 12.56738 2020-04-18 22:32:28 Italy
2020-04-17 Italy       172434 22745 42727 106962 41.87194 12.56738 2020-04-17 23:30:32 Italy
2020-04-16 Italy       168941 22170 40164 106607 41.87194 12.56738 2020-04-16 23:30:31 Italy
2020-04-15 Italy       165155 21645 38092 105418 41.87194 12.56738 2020-04-15 22:56:32 Italy
2020-04-14 Italy       162488 21067 37130 104291 41.87194 12.56738 2020-04-14 23:33:12 Italy
2020-04-13 Italy       159516 20465 35435 103616 41.87194 12.56738 2020-04-13 23:07:34 Italy
2020-04-12 Italy       156363 19899 34211 102253 41.87194 12.56738 2020-04-12 23:17:00 Italy
2020-04-11 Italy       152271 19468 32534 100269 41.87194 12.56738 2020-04-11 22:45:13 Italy
2020-04-10 Italy       147577 18849 30455 98273 41.87194 12.56738 2020-04-10 22:53:48 Italy
2020-04-09 Italy       143626 18279 28470 96877 41.87194 12.56738 2020-04-09 23:02:19 Italy
2020-04-08 Italy       139422 17669 26491 95262 41.87194 12.56738 2020-04-08 22:51:39 Italy
2020-04-07 Italy       135586 17127 24392 94067 41.87194 12.56738 2020-04-07 23:04:29 Italy
2020-04-06 Italy       132547 16523 22837 93187 41.87194 12.56738 4/6/20 23:21 Italy
2020-04-05 Italy       128948 15887 21815 91246 41.87194 12.56738 2020-04-05 23:06:26 Italy
2020-04-04 Italy       124632 15362 20996 88274 41.87194 12.56738 4/4/20 23:34 Italy
2020-04-03 Italy       119827 14681 19758 85388 41.87194 12.56738 2020-04-03 22:46:20 Italy
2020-04-02 Italy       115242 13915 18278 83049 41.87194 12.56738 4/2/20 23:25 Italy
2020-04-01 Italy       110574 13155 16847 80572 41.87194 12.56738 2020-04-01 21:58:34 Italy
2020-03-31 Italy       105792 12428 15729 77635 41.87194 12.56738 2020-03-31 23:43:43 Italy
2020-03-30 Italy       101739 11591 14620 75528 41.87194 12.56738 3/30/20 22:52 Italy
2020-03-29 Italy       97689 10779 13030 73880 41.87194 12.56738 3/29/20 23:08 Italy
2020-08-03 Italy Lombardia     96337 16818 73724 5795 45.46679409 9.190347404 2020-08-04 04:41:59 Lombardia, Italy
2020-08-02 Italy Lombardia     96312 16815 73676 5821 45.46679409 9.190347404 2020-08-03 04:34:35 Lombardia, Italy
2020-08-01 Italy Lombardia     96274 16807 73512 5955 45.46679409 9.190347404 2020-08-02 04:34:47 Lombardia, Italy
2020-07-31 Italy Lombardia     96219 16806 73402 6011 45.46679409 9.190347404 2020-08-01 04:36:27 Lombardia, Italy
2020-07-30 Italy Lombardia     96142 16802 73305 6035 45.46679409 9.190347404 2020-07-31 04:35:18 Lombardia, Italy
2020-07-29 Italy Lombardia     96054 16802 72689 6563 45.46679409 9.190347404 2020-07-30 04:35:05 Lombardia, Italy
2020-07-28 Italy Lombardia     96008 16802 72528 6678 45.46679409 9.190347404 2020-07-29 04:35:11 Lombardia, Italy
2020-07-27 Italy Lombardia     95955 16801 72429 6725 45.46679409 9.190347404 2020-07-28 04:58:43 Lombardia, Italy
2020-07-26 Italy Lombardia     95921 16801 72349 6771 45.46679409 9.190347404 2020-07-27 04:35:02 Lombardia, Italy
2020-07-25 Italy Lombardia     95847 16801 72271 6775 45.46679409 9.190347404 2020-07-26 04:35:00 Lombardia, Italy
2020-07-24 Italy Lombardia     95768 16801 72208 6759 45.46679409 9.190347404 2020-07-25 04:47:39 Lombardia, Italy
2020-07-23 Italy Lombardia     95715 16801 71973 6941 45.46679409 9.190347404 2020-07-24 05:30:40 Lombardia, Italy
2020-07-22 Italy Lombardia     95633 16798 71860 6975 45.46679409 9.190347404 2020-07-23 05:15:04 Lombardia, Italy
2020-07-21 Italy Lombardia     95582 16797 71775 7010 45.46679409 9.190347404 2020-07-22 04:34:42 Lombardia, Italy
2020-07-20 Italy Lombardia     95548 16796 71611 7141 45.46679409 9.190347404 2020-07-21 04:38:46 Lombardia, Italy
2020-07-19 Italy Lombardia     95492 16788 71464 7240 45.46679409 9.190347404 2020-07-20 05:34:40 Lombardia, Italy
2020-07-18 Italy Lombardia     95459 16788 71416 7255 45.46679409 9.190347404 2020-07-19 04:34:58 Lombardia, Italy
2020-07-17 Italy Lombardia     95371 16778 71172 7421 45.46679409 9.190347404 2020-07-18 04:34:45 Lombardia, Italy
2020-07-16 Italy Lombardia     95316 16775 71032 7509 45.46679409 9.190347404 2020-07-17 04:34:50 Lombardia, Italy
2020-07-15 Italy Lombardia     95236 16765 70936 7535 45.46679409 9.190347404 2020-07-16 04:44:59 Lombardia, Italy
2020-07-14 Italy Lombardia     95173 16760 70461 7952 45.46679409 9.190347404 2020-07-15 04:34:39 Lombardia, Italy
2020-07-13 Italy Lombardia     95143 16757 70375 8011 45.46679409 9.190347404 2020-07-14 04:34:46 Lombardia, Italy
2020-07-12 Italy Lombardia     95049 16748 70297 8004 45.46679409 9.190347404 2020-07-13 04:43:04 Lombardia, Italy
2020-07-11 Italy Lombardia     94972 16740 70020 8212 45.46679409 9.190347404 2020-07-12 04:34:30 Lombardia, Italy
2020-07-10 Italy Lombardia     94905 16736 69828 8341 45.46679409 9.190347404 2020-07-11 04:34:26 Lombardia, Italy
2020-07-09 Italy Lombardia     94770 16730 69683 8357 45.46679409 9.190347404 2020-07-10 04:34:24 Lombardia, Italy
2020-07-08 Italy Lombardia     94651 16725 69466 8460 45.46679409 9.190347404 2020-07-09 04:34:23 Lombardia, Italy
2020-07-07 Italy Lombardia     94580 16713 68793 9074 45.46679409 9.190347404 2020-07-08 05:33:48 Lombardia, Italy
2020-07-06 Italy Lombardia     94527 16700 68335 9492 45.46679409 9.190347404 2020-07-07 04:34:00 Lombardia, Italy
2020-07-05 Italy Lombardia     94416 16697 68274 9445 45.46679409 9.190347404 2020-07-06 04:33:57 Lombardia, Italy
2020-07-04 Italy Lombardia     94318 16691 68201 9426 45.46679409 9.190347404 2020-07-05 04:33:46 Lombardia, Italy
2020-07-03 Italy Lombardia     94223 16675 67871 9677 45.46679409 9.190347404 2020-07-04 04:33:51 Lombardia, Italy
2020-07-02 Italy Lombardia     94108 16671 67610 9827 45.46679409 9.190347404 2020-07-03 04:33:54 Lombardia, Italy
2020-07-01 Italy Lombardia     94010 16650 67422 9938 45.46679409 9.190347404 2020-07-02 04:33:46 Lombardia, Italy
2020-06-30 Italy Lombardia     93901 16644 67197 10060 45.46679409 9.190347404 2020-07-01 04:33:52 Lombardia, Italy
2020-06-29 Italy Lombardia     93839 16640 66376 10823 45.46679409 9.190347404 2020-06-30 04:33:48 Lombardia, Italy
2020-06-28 Italy Lombardia     93761 16639 66175 10947 45.46679409 9.190347404 2020-06-29 04:33:44 Lombardia, Italy
2020-06-27 Italy Lombardia     93664 16626 66046 10992 45.46679409 9.190347404 2020-06-28 04:34:04 Lombardia, Italy
2020-06-26 Italy Lombardia     93587 16624 65323 11640 45.46679409 9.190347404 2020-06-27 04:33:35 Lombardia, Italy
2020-06-25 Italy Lombardia     93431 16608 64831 11992 45.46679409 9.190347404 2020-06-26 04:33:43 Lombardia, Italy
2020-06-24 Italy Lombardia     93261 16586 64448 12227 45.46679409 9.190347404 2020-06-25 05:26:54 Lombardia, Italy
2020-06-23 Italy Lombardia     93173 16579 63691 12903 45.46679409 9.190347404 2020-06-24 04:33:28 Lombardia, Italy
2020-06-22 Italy Lombardia     93111 16573 62900 13638 45.46679409 9.190347404 2020-06-23 04:33:22 Lombardia, Italy
2020-06-21 Italy Lombardia     92968 16570 62555 13843 45.46679409 9.190347404 2020-06-22 04:33:20 Lombardia, Italy
2020-06-20 Italy Lombardia     92840 16557 62372 13911 45.46679409 9.190347404 2020-06-21 04:33:19 Lombardia, Italy
2020-06-19 Italy Lombardia     92675 16534 62096 14045 45.46679409 9.190347404 2020-06-20 04:33:19 Lombardia, Italy
2020-06-18 Italy Lombardia     92518 16516 61355 14647 45.46679409 9.190347404 2020-06-19 04:33:17 Lombardia, Italy
2020-03-28 Italy       92472 10023 12384 70065 41.87194 12.56738 3/28/20 23:05 Italy
2020-06-17 Italy Lombardia     92302 16480 60850 14972 45.46679409 9.190347404 2020-06-18 04:33:18 Lombardia, Italy
2020-06-16 Italy Lombardia     92060 16466 60361 15233 45.46679409 9.190347404 2020-06-17 04:33:21 Lombardia, Italy
2020-06-15 Italy Lombardia     91917 16457 59484 15976 45.46679409 9.190347404 2020-06-16 04:33:09 Lombardia, Italy
2020-06-14 Italy Lombardia     91658 16449 59220 15989 45.46679409 9.190347404 2020-06-15 03:33:14 Lombardia, Italy
2020-06-13 Italy Lombardia     91414 16428 58201 16785 45.46679409 9.190347404 2020-06-14 03:33:15 Lombardia, Italy
2020-06-12 Italy Lombardia     91204 16405 57775 17024 45.46679409 9.190347404 2020-06-13 03:33:14 Lombardia, Italy

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;
Powered by Datasette · Query took 308.407ms · Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette