⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

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

402 rows where country_or_region = "Italy" and province_or_state = "Lazio" sorted by day descending

View and edit SQL

Suggested facets: day (date), last_update (date)

province_or_state

  • Lazio · 402

country_or_region

  • Italy · 402
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
168444 2021-06-19 Italy Lazio     345146 8304 332483 4359 41.89277044 12.48366722 2021-06-20 04:21:48 Lazio, Italy
685969 2021-06-18 Italy Lazio     345045 8303 332268 4474 41.89277044 12.48366722 2021-06-19 04:22:33 Lazio, Italy
958026 2021-06-17 Italy Lazio     344898 8300 331704 4894 41.89277044 12.48366722 2021-06-18 04:22:16 Lazio, Italy
1281393 2021-06-16 Italy Lazio     344779 8292 331243 5244 41.89277044 12.48366722 2021-06-17 04:22:36 Lazio, Italy
681983 2021-06-15 Italy Lazio     344636 8281 330853 5502 41.89277044 12.48366722 2021-06-16 04:22:32 Lazio, Italy
372537 2021-06-14 Italy Lazio     344518 8268 330404 5846 41.89277044 12.48366722 2021-06-15 04:22:22 Lazio, Italy
1223353 2021-06-13 Italy Lazio     344407 8262 329976 6169 41.89277044 12.48366722 2021-06-14 04:22:46 Lazio, Italy
80634 2021-06-12 Italy Lazio     344280 8262 329451 6567 41.89277044 12.48366722 2021-06-13 04:22:44 Lazio, Italy
969937 2021-06-11 Italy Lazio     344116 8254 328498 7364 41.89277044 12.48366722 2021-06-12 04:22:22 Lazio, Italy
1438510 2021-06-10 Italy Lazio     343947 8242 327563 8142 41.89277044 12.48366722 2021-06-11 04:23:20 Lazio, Italy
1157009 2021-06-09 Italy Lazio     343753 8236 326627 8890 41.89277044 12.48366722 2021-06-10 04:23:17 Lazio, Italy
1231325 2021-06-08 Italy Lazio     343574 8229 325390 9955 41.89277044 12.48366722 2021-06-09 04:23:31 Lazio, Italy
360321 2021-06-07 Italy Lazio     343435 8223 324185 11027 41.89277044 12.48366722 2021-06-08 04:22:35 Lazio, Italy
1075949 2021-06-06 Italy Lazio     343265 8218 323055 11992 41.89277044 12.48366722 2021-06-07 04:22:51 Lazio, Italy
1613341 2021-06-05 Italy Lazio     343032 8213 321930 12889 41.89277044 12.48366722 2021-06-06 04:24:03 Lazio, Italy
1125627 2021-06-04 Italy Lazio     342822 8204 320838 13780 41.89277044 12.48366722 2021-06-05 04:23:03 Lazio, Italy
318083 2021-06-03 Italy Lazio     342625 8195 319732 14698 41.89277044 12.48366722 2021-06-04 04:23:37 Lazio, Italy
1133596 2021-06-02 Italy Lazio     342429 8189 318646 15594 41.89277044 12.48366722 2021-06-03 04:23:32 Lazio, Italy
291773 2021-06-01 Italy Lazio     342218 8185 317114 16919 41.89277044 12.48366722 2021-06-02 04:24:34 Lazio, Italy
1651724 2021-05-31 Italy Lazio     342023 8175 315078 18770 41.89277044 12.48366722 2021-06-01 04:23:09 Lazio, Italy
980952 2021-05-30 Italy Lazio     341772 8171 313786 19815 41.89277044 12.48366722 2021-05-31 03:08:59 Lazio, Italy
841333 2021-05-29 Italy Lazio     341494 8165 312533 20796 41.89277044 12.48366722 2021-05-30 04:20:55 Lazio, Italy
697905 2021-05-28 Italy Lazio     341187 8155 311273 21759 41.89277044 12.48366722 2021-05-29 04:20:41 Lazio, Italy
1369406 2021-05-27 Italy Lazio     340891 8144 310001 22746 41.89277044 12.48366722 2021-05-28 04:20:36 Lazio, Italy
1292491 2021-05-26 Italy Lazio     340530 8135 308677 23718 41.89277044 12.48366722 2021-05-27 04:20:59 Lazio, Italy
602862 2021-05-25 Italy Lazio     340212 8117 306944 25151 41.89277044 12.48366722 2021-05-26 04:20:35 Lazio, Italy
1365420 2021-05-24 Italy Lazio     339904 8101 305156 26647 41.89277044 12.48366722 2021-05-25 04:21:08 Lazio, Italy
419933 2021-05-23 Italy Lazio     339612 8090 303893 27629 41.89277044 12.48366722 2021-05-24 04:20:53 Lazio, Italy
54272 2021-05-22 Italy Lazio     339199 8081 302784 28334 41.89277044 12.48366722 2021-05-23 04:20:51 Lazio, Italy
368551 2021-05-21 Italy Lazio     338705 8074 301704 28927 41.89277044 12.48366722 2021-05-22 04:20:45 Lazio, Italy
1024350 2021-05-20 Italy Lazio     338234 8063 300033 30138 41.89277044 12.48366722 2021-05-21 04:20:43 Lazio, Italy
1678976 2021-05-19 Italy Lazio     337676 8053 298998 30625 41.89277044 12.48366722 2021-05-20 04:21:05 Lazio, Italy
64963 2021-05-18 Italy Lazio     337210 8037 297118 32055 41.89277044 12.48366722 2021-05-19 04:20:42 Lazio, Italy
1243035 2021-05-17 Italy Lazio     336862 8023 296095 32744 41.89277044 12.48366722 2021-05-18 04:20:33 Lazio, Italy
1067883 2021-05-16 Italy Lazio     336474 8006 295041 33427 41.89277044 12.48366722 2021-05-17 04:20:34 Lazio, Italy
505011 2021-05-15 Italy Lazio     335897 7992 294038 33867 41.89277044 12.48366722 2021-05-16 04:20:49 Lazio, Italy
892616 2021-05-14 Italy Lazio     335276 7987 292548 34741 41.89277044 12.48366722 2021-05-15 04:20:58 Lazio, Italy
531951 2021-05-13 Italy Lazio     334570 7977 291448 35145 41.89277044 12.48366722 2021-05-14 04:20:41 Lazio, Italy
1719238 2021-05-12 Italy Lazio     333916 7956 290385 35575 41.89277044 12.48366722 2021-05-13 04:20:51 Lazio, Italy
1723224 2021-05-11 Italy Lazio     333283 7934 289116 36233 41.89277044 12.48366722 2021-05-12 04:21:29 Lazio, Italy
1164981 2021-05-10 Italy Lazio     332648 7894 287886 36868 41.89277044 12.48366722 2021-05-11 04:20:41 Lazio, Italy
1168967 2021-05-09 Italy Lazio     331968 7877 286423 37668 41.89277044 12.48366722 2021-05-10 04:20:38 Lazio, Italy
1659754 2021-05-08 Italy Lazio     331180 7867 285123 38190 41.89277044 12.48366722 2021-05-09 04:20:35 Lazio, Italy
799852 2021-05-07 Italy Lazio     330181 7852 283769 38560 41.89277044 12.48366722 2021-05-08 04:21:04 Lazio, Italy
1219367 2021-05-06 Italy Lazio     329118 7835 282492 38791 41.89277044 12.48366722 2021-05-07 04:20:40 Lazio, Italy
415947 2021-05-05 Italy Lazio     328111 7796 280117 40198 41.89277044 12.48366722 2021-05-06 04:20:38 Lazio, Italy
673968 2021-05-04 Italy Lazio     327273 7757 278237 41279 41.89277044 12.48366722 2021-05-05 04:20:43 Lazio, Italy
1087992 2021-05-03 Italy Lazio     326470 7721 275992 42757 41.89277044 12.48366722 2021-05-04 04:20:34 Lazio, Italy
1727210 2021-05-02 Italy Lazio     325809 7699 274897 43213 41.89277044 12.48366722 2021-05-03 04:20:39 Lazio, Italy
1084006 2021-05-01 Italy Lazio     324823 7686 273842 43295 41.89277044 12.48366722 2021-05-02 04:20:48 Lazio, Italy
1388534 2021-04-30 Italy Lazio     323754 7673 271385 44696 41.89277044 12.48366722 2021-05-01 04:20:47 Lazio, Italy
38353 2021-04-29 Italy Lazio     322603 7647 269594 45362 41.89277044 12.48366722 2021-04-30 04:21:03 Lazio, Italy
11926 2021-04-28 Italy Lazio     321479 7620 268214 45645 41.89277044 12.48366722 2021-04-29 04:20:55 Lazio, Italy
853309 2021-04-27 Italy Lazio     320401 7588 266635 46178 41.89277044 12.48366722 2021-04-28 04:20:32 Lazio, Italy
1063897 2021-04-26 Italy Lazio     319462 7554 265285 46623 41.89277044 12.48366722 2021-04-27 04:20:52 Lazio, Italy
1476147 2021-04-25 Italy Lazio     318498 7510 264151 46837 41.89277044 12.48366722 2021-04-26 04:21:04 Lazio, Italy
743768 2021-04-24 Italy Lazio     317313 7491 262992 46830 41.89277044 12.48366722 2021-04-25 04:20:32 Lazio, Italy
1430567 2021-04-23 Italy Lazio     316047 7468 261777 46802 41.89277044 12.48366722 2021-04-24 04:20:38 Lazio, Italy
96396 2021-04-22 Italy Lazio     314826 7445 259518 47863 41.89277044 12.48366722 2021-04-23 04:20:52 Lazio, Italy
849323 2021-04-21 Italy Lazio     313515 7414 258355 47746 41.89277044 12.48366722 2021-04-22 04:20:53 Lazio, Italy
826941 2021-04-20 Italy Lazio     312354 7362 255816 49176 41.89277044 12.48366722 2021-04-21 04:21:14 Lazio, Italy
770652 2021-04-19 Italy Lazio     311428 7328 253642 50458 41.89277044 12.48366722 2021-04-20 04:20:41 Lazio, Italy
1415961 2021-04-18 Italy Lazio     310478 7290 252398 50790 41.89277044 12.48366722 2021-04-19 04:20:57 Lazio, Italy
984938 2021-04-17 Italy Lazio     309351 7265 251258 50828 41.89277044 12.48366722 2021-04-18 04:20:41 Lazio, Italy
238001 2021-04-16 Italy Lazio     307973 7240 249720 51013 41.89277044 12.48366722 2021-04-17 04:20:40 Lazio, Italy
579730 2021-04-15 Italy Lazio     306499 7201 248667 50631 41.89277044 12.48366722 2021-04-16 04:20:46 Lazio, Italy
1266358 2021-04-14 Italy Lazio     305169 7155 246782 51232 41.89277044 12.48366722 2021-04-15 04:20:54 Lazio, Italy
701891 2021-04-13 Italy Lazio     303939 7106 244661 52172 41.89277044 12.48366722 2021-04-14 04:20:41 Lazio, Italy
1671004 2021-04-12 Italy Lazio     302775 7070 243637 52068 41.89277044 12.48366722 2021-04-13 04:20:37 Lazio, Italy
784709 2021-04-11 Italy Lazio     301718 7033 242625 52060 41.89277044 12.48366722 2021-04-12 04:21:00 Lazio, Italy
1392520 2021-04-10 Italy Lazio     300043 7014 240640 52389 41.89277044 12.48366722 2021-04-11 04:20:56 Lazio, Italy
965951 2021-04-09 Italy Lazio     298580 6979 239660 51941 41.89277044 12.48366722 2021-04-10 04:20:59 Lazio, Italy
689955 2021-04-08 Italy Lazio     297217 6932 238105 52180 41.89277044 12.48366722 2021-04-09 04:21:13 Lazio, Italy
1277407 2021-04-07 Italy Lazio     295977 6895 236271 52811 41.89277044 12.48366722 2021-04-08 04:21:13 Lazio, Italy
88426 2021-04-06 Italy Lazio     294896 6848 234470 53578 41.89277044 12.48366722 2021-04-07 04:20:53 Lazio, Italy
122808 2021-04-05 Italy Lazio     293776 6805 233743 53228 41.89277044 12.48366722 2021-04-06 04:20:32 Lazio, Italy
73310 2021-04-04 Italy Lazio     292357 6773 232937 52647 41.89277044 12.48366722 2021-04-05 04:20:35 Lazio, Italy
791926 2021-04-03 Italy Lazio     290834 6747 232135 51952 41.89277044 12.48366722 2021-04-04 04:20:49 Lazio, Italy
1020364 2021-04-02 Italy Lazio     289203 6720 231342 51141 41.89277044 12.48366722 2021-04-03 04:20:44 Lazio, Italy
1350526 2021-04-01 Italy Lazio     287285 6677 229560 51048 41.89277044 12.48366722 2021-04-02 04:20:36 Lazio, Italy
1690912 2021-03-31 Italy Lazio     285447 6644 227752 51051 41.89277044 12.48366722 2021-04-01 04:27:05 Lazio, Italy
873281 2021-03-30 Italy Lazio     283647 6606 225943 51098 41.89277044 12.48366722 2021-03-31 04:26:25 Lazio, Italy
1400328 2021-03-29 Italy Lazio     282054 6574 224247 51233 41.89277044 12.48366722 2021-03-30 04:26:23 Lazio, Italy
1624731 2021-03-28 Italy Lazio     280651 6529 222686 51436 41.89277044 12.48366722 2021-03-29 04:28:35 Lazio, Italy
1472161 2021-03-27 Italy Lazio     278815 6515 222009 50291 41.89277044 12.48366722 2021-03-28 05:28:10 Lazio, Italy
720708 2021-03-26 Italy Lazio     276990 6500 221271 49219 41.89277044 12.48366722 2021-03-27 05:25:04 Lazio, Italy
1617327 2021-03-25 Italy Lazio     274984 6463 219460 49061 41.89277044 12.48366722 2021-03-26 05:26:55 Lazio, Italy
469988 2021-03-24 Italy Lazio     272929 6430 217708 48791 41.89277044 12.48366722 2021-03-25 05:27:00 Lazio, Italy
1585028 2021-03-23 Italy Lazio     271220 6400 215994 48826 41.89277044 12.48366722 2021-03-24 05:25:40 Lazio, Italy
716722 2021-03-22 Italy Lazio     269729 6374 214853 48502 41.89277044 12.48366722 2021-03-23 05:26:18 Lazio, Italy
1674990 2021-03-21 Italy Lazio     268322 6355 214277 47690 41.89277044 12.48366722 2021-03-22 05:25:43 Lazio, Italy
1746929 2021-03-20 Italy Lazio     266529 6340 213135 47054 41.89277044 12.48366722 2021-03-21 05:25:44 Lazio, Italy
230051 2021-03-19 Italy Lazio     264708 6316 212397 45995 41.89277044 12.48366722 2021-03-20 05:25:46 Lazio, Italy
477986 2021-03-18 Italy Lazio     262520 6278 211323 44919 41.89277044 12.48366722 2021-03-19 05:26:09 Lazio, Italy
1426581 2021-03-17 Italy Lazio     260557 6255 210023 44279 41.89277044 12.48366722 2021-03-18 05:26:22 Lazio, Italy
1593169 2021-03-16 Italy Lazio     258829 6235 208300 44294 41.89277044 12.48366722 2021-03-17 05:25:07 Lazio, Italy
1176168 2021-03-15 Italy Lazio     257332 6203 207690 43439 41.89277044 12.48366722 2021-03-16 05:25:13 Lazio, Italy
275853 2021-03-14 Italy Lazio     255796 6183 207026 42587 41.89277044 12.48366722 2021-03-15 05:25:51 Lazio, Italy
1160995 2021-03-13 Italy Lazio     253984 6173 206306 41505 41.89277044 12.48366722 2021-03-14 05:25:37 Lazio, Italy
22502 2021-03-12 Italy Lazio     251986 6154 205518 40314 41.89277044 12.48366722 2021-03-13 05:25:15 Lazio, Italy

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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] INTEGER,
   [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]);