daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
960 rows where country_or_region = "Italy" and province_or_state = "Liguria" 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 | Liguria | 569236 | 5571 | 0 | 44.41149315 | 8.9326992 | 2022-09-21 04:23:22 | Liguria, Italy | |||
2022-09-19 | Italy | Liguria | 568456 | 5567 | 0 | 44.41149315 | 8.9326992 | 2022-09-20 04:22:48 | Liguria, Italy | |||
2022-09-18 | Italy | Liguria | 568302 | 5565 | 0 | 44.41149315 | 8.9326992 | 2022-09-19 04:21:49 | Liguria, Italy | |||
2022-09-17 | Italy | Liguria | 567981 | 5565 | 0 | 44.41149315 | 8.9326992 | 2022-09-18 04:22:50 | Liguria, Italy | |||
2022-09-16 | Italy | Liguria | 567534 | 5565 | 0 | 44.41149315 | 8.9326992 | 2022-09-17 04:20:19 | Liguria, Italy | |||
2022-09-15 | Italy | Liguria | 567077 | 5564 | 0 | 44.41149315 | 8.9326992 | 2022-09-16 04:21:19 | Liguria, Italy | |||
2022-09-14 | Italy | Liguria | 566609 | 5562 | 0 | 44.41149315 | 8.9326992 | 2022-09-15 04:21:02 | Liguria, Italy | |||
2022-09-13 | Italy | Liguria | 566130 | 5562 | 0 | 44.41149315 | 8.9326992 | 2022-09-14 04:20:44 | Liguria, Italy | |||
2022-09-12 | Italy | Liguria | 565424 | 5560 | 0 | 44.41149315 | 8.9326992 | 2022-09-13 04:20:57 | Liguria, Italy | |||
2022-09-11 | Italy | Liguria | 565268 | 5558 | 0 | 44.41149315 | 8.9326992 | 2022-09-12 04:20:58 | Liguria, Italy | |||
2022-09-10 | Italy | Liguria | 564932 | 5558 | 0 | 44.41149315 | 8.9326992 | 2022-09-11 04:20:50 | Liguria, Italy | |||
2022-09-09 | Italy | Liguria | 564453 | 5555 | 0 | 44.41149315 | 8.9326992 | 2022-09-10 04:21:10 | Liguria, Italy | |||
2022-09-08 | Italy | Liguria | 564043 | 5555 | 0 | 44.41149315 | 8.9326992 | 2022-09-09 04:21:11 | Liguria, Italy | |||
2022-09-07 | Italy | Liguria | 563603 | 5552 | 0 | 44.41149315 | 8.9326992 | 2022-09-08 04:21:02 | Liguria, Italy | |||
2022-09-06 | Italy | Liguria | 563111 | 5550 | 0 | 44.41149315 | 8.9326992 | 2022-09-07 04:20:59 | Liguria, Italy | |||
2022-09-05 | Italy | Liguria | 562443 | 5548 | 0 | 44.41149315 | 8.9326992 | 2022-09-06 04:21:02 | Liguria, Italy | |||
2022-09-04 | Italy | Liguria | 562298 | 5548 | 0 | 44.41149315 | 8.9326992 | 2022-09-05 04:21:01 | Liguria, Italy | |||
2022-09-03 | Italy | Liguria | 561917 | 5548 | 0 | 44.41149315 | 8.9326992 | 2022-09-04 04:21:22 | Liguria, Italy | |||
2022-09-02 | Italy | Liguria | 561421 | 5547 | 0 | 44.41149315 | 8.9326992 | 2022-09-03 04:21:04 | Liguria, Italy | |||
2022-09-01 | Italy | Liguria | 560894 | 5542 | 0 | 44.41149315 | 8.9326992 | 2022-09-02 04:21:07 | Liguria, Italy | |||
2022-08-31 | Italy | Liguria | 560332 | 5540 | 0 | 44.41149315 | 8.9326992 | 2022-09-01 04:21:03 | Liguria, Italy | |||
2022-08-30 | Italy | Liguria | 559807 | 5536 | 0 | 44.41149315 | 8.9326992 | 2022-08-31 04:20:57 | Liguria, Italy | |||
2022-08-29 | Italy | Liguria | 558871 | 5534 | 0 | 44.41149315 | 8.9326992 | 2022-08-30 04:21:03 | Liguria, Italy | |||
2022-08-28 | Italy | Liguria | 558685 | 5534 | 0 | 44.41149315 | 8.9326992 | 2022-08-29 04:21:06 | Liguria, Italy | |||
2022-08-27 | Italy | Liguria | 558195 | 5532 | 0 | 44.41149315 | 8.9326992 | 2022-08-28 04:21:02 | Liguria, Italy | |||
2022-08-26 | Italy | Liguria | 557595 | 5530 | 0 | 44.41149315 | 8.9326992 | 2022-08-27 04:20:57 | Liguria, Italy | |||
2022-08-25 | Italy | Liguria | 556971 | 5528 | 0 | 44.41149315 | 8.9326992 | 2022-08-26 04:21:02 | Liguria, Italy | |||
2022-08-24 | Italy | Liguria | 556315 | 5525 | 0 | 44.41149315 | 8.9326992 | 2022-08-25 04:21:13 | Liguria, Italy | |||
2022-08-23 | Italy | Liguria | 555622 | 5518 | 0 | 44.41149315 | 8.9326992 | 2022-08-24 04:20:46 | Liguria, Italy | |||
2022-08-22 | Italy | Liguria | 554567 | 5514 | 0 | 44.41149315 | 8.9326992 | 2022-08-23 04:20:56 | Liguria, Italy | |||
2022-08-21 | Italy | Liguria | 554320 | 5512 | 0 | 44.41149315 | 8.9326992 | 2022-08-22 04:20:38 | Liguria, Italy | |||
2022-08-20 | Italy | Liguria | 553774 | 5507 | 0 | 44.41149315 | 8.9326992 | 2022-08-21 04:20:44 | Liguria, Italy | |||
2022-08-19 | Italy | Liguria | 553025 | 5502 | 0 | 44.41149315 | 8.9326992 | 2022-08-20 04:21:01 | Liguria, Italy | |||
2022-08-18 | Italy | Liguria | 552356 | 5501 | 0 | 44.41149315 | 8.9326992 | 2022-08-19 04:20:54 | Liguria, Italy | |||
2022-08-17 | Italy | Liguria | 551513 | 5498 | 0 | 44.41149315 | 8.9326992 | 2022-08-18 04:21:11 | Liguria, Italy | |||
2022-08-16 | Italy | Liguria | 550355 | 5494 | 0 | 44.41149315 | 8.9326992 | 2022-08-17 04:20:59 | Liguria, Italy | |||
2022-08-15 | Italy | Liguria | 550042 | 5492 | 0 | 44.41149315 | 8.9326992 | 2022-08-16 04:20:58 | Liguria, Italy | |||
2022-08-14 | Italy | Liguria | 549775 | 5492 | 0 | 44.41149315 | 8.9326992 | 2022-08-15 04:20:59 | Liguria, Italy | |||
2022-08-13 | Italy | Liguria | 549105 | 5492 | 0 | 44.41149315 | 8.9326992 | 2022-08-14 04:20:55 | Liguria, Italy | |||
2022-08-12 | Italy | Liguria | 548256 | 5489 | 0 | 44.41149315 | 8.9326992 | 2022-08-13 04:20:52 | Liguria, Italy | |||
2022-08-11 | Italy | Liguria | 547432 | 5484 | 0 | 44.41149315 | 8.9326992 | 2022-08-12 04:20:54 | Liguria, Italy | |||
2022-08-10 | Italy | Liguria | 546489 | 5481 | 0 | 44.41149315 | 8.9326992 | 2022-08-11 04:20:49 | Liguria, Italy | |||
2022-08-09 | Italy | Liguria | 545484 | 5476 | 0 | 44.41149315 | 8.9326992 | 2022-08-10 04:20:57 | Liguria, Italy | |||
2022-08-08 | Italy | Liguria | 543938 | 5472 | 0 | 44.41149315 | 8.9326992 | 2022-08-09 04:20:34 | Liguria, Italy | |||
2022-08-07 | Italy | Liguria | 543608 | 5472 | 0 | 44.41149315 | 8.9326992 | 2022-08-08 04:21:08 | Liguria, Italy | |||
2022-08-06 | Italy | Liguria | 542769 | 5472 | 0 | 44.41149315 | 8.9326992 | 2022-08-07 04:20:54 | Liguria, Italy | |||
2022-08-05 | Italy | Liguria | 541615 | 5464 | 0 | 44.41149315 | 8.9326992 | 2022-08-06 04:20:56 | Liguria, Italy | |||
2022-08-04 | Italy | Liguria | 540405 | 5457 | 0 | 44.41149315 | 8.9326992 | 2022-08-05 04:20:52 | Liguria, Italy | |||
2022-08-03 | Italy | Liguria | 539095 | 5451 | 0 | 44.41149315 | 8.9326992 | 2022-08-04 04:20:58 | Liguria, Italy | |||
2022-08-02 | Italy | Liguria | 537679 | 5448 | 0 | 44.41149315 | 8.9326992 | 2022-08-03 04:20:59 | Liguria, Italy | |||
2022-08-01 | Italy | Liguria | 535561 | 5442 | 0 | 44.41149315 | 8.9326992 | 2022-08-02 04:20:53 | Liguria, Italy | |||
2022-07-31 | Italy | Liguria | 535089 | 5440 | 0 | 44.41149315 | 8.9326992 | 2022-08-01 04:21:03 | Liguria, Italy | |||
2022-07-30 | Italy | Liguria | 534009 | 5440 | 0 | 44.41149315 | 8.9326992 | 2022-07-31 04:21:02 | Liguria, Italy | |||
2022-07-29 | Italy | Liguria | 532322 | 5437 | 0 | 44.41149315 | 8.9326992 | 2022-07-30 04:20:42 | Liguria, Italy | |||
2022-07-28 | Italy | Liguria | 530717 | 5431 | 0 | 44.41149315 | 8.9326992 | 2022-07-29 04:20:45 | Liguria, Italy | |||
2022-07-27 | Italy | Liguria | 529226 | 5425 | 0 | 44.41149315 | 8.9326992 | 2022-07-28 04:20:56 | Liguria, Italy | |||
2022-07-26 | Italy | Liguria | 527515 | 5415 | 0 | 44.41149315 | 8.9326992 | 2022-07-27 04:21:04 | Liguria, Italy | |||
2022-07-25 | Italy | Liguria | 524936 | 5408 | 0 | 44.41149315 | 8.9326992 | 2022-07-26 04:20:58 | Liguria, Italy | |||
2022-07-24 | Italy | Liguria | 524253 | 5405 | 0 | 44.41149315 | 8.9326992 | 2022-07-25 04:20:51 | Liguria, Italy | |||
2022-07-23 | Italy | Liguria | 522939 | 5401 | 0 | 44.41149315 | 8.9326992 | 2022-07-24 04:20:47 | Liguria, Italy | |||
2022-07-22 | Italy | Liguria | 520999 | 5400 | 0 | 44.41149315 | 8.9326992 | 2022-07-23 04:20:53 | Liguria, Italy | |||
2022-07-21 | Italy | Liguria | 519165 | 5396 | 0 | 44.41149315 | 8.9326992 | 2022-07-22 04:21:15 | Liguria, Italy | |||
2022-07-20 | Italy | Liguria | 517117 | 5396 | 0 | 44.41149315 | 8.9326992 | 2022-07-21 04:21:10 | Liguria, Italy | |||
2022-07-19 | Italy | Liguria | 514928 | 5392 | 0 | 44.41149315 | 8.9326992 | 2022-07-20 04:20:59 | Liguria, Italy | |||
2022-07-18 | Italy | Liguria | 511701 | 5387 | 0 | 44.41149315 | 8.9326992 | 2022-07-19 04:20:58 | Liguria, Italy | |||
2022-07-17 | Italy | Liguria | 511022 | 5386 | 0 | 44.41149315 | 8.9326992 | 2022-07-18 04:20:59 | Liguria, Italy | |||
2022-07-16 | Italy | Liguria | 509264 | 5384 | 0 | 44.41149315 | 8.9326992 | 2022-07-17 04:21:15 | Liguria, Italy | |||
2022-07-15 | Italy | Liguria | 506915 | 5379 | 0 | 44.41149315 | 8.9326992 | 2022-07-16 04:21:05 | Liguria, Italy | |||
2022-07-14 | Italy | Liguria | 504735 | 5376 | 0 | 44.41149315 | 8.9326992 | 2022-07-15 04:20:53 | Liguria, Italy | |||
2022-07-13 | Italy | Liguria | 502316 | 5374 | 0 | 44.41149315 | 8.9326992 | 2022-07-14 04:20:57 | Liguria, Italy | |||
2022-07-12 | Italy | Liguria | 499754 | 5371 | 0 | 44.41149315 | 8.9326992 | 2022-07-13 04:20:58 | Liguria, Italy | |||
2022-07-11 | Italy | Liguria | 495935 | 5366 | 0 | 44.41149315 | 8.9326992 | 2022-07-12 04:20:51 | Liguria, Italy | |||
2022-07-10 | Italy | Liguria | 495064 | 5364 | 0 | 44.41149315 | 8.9326992 | 2022-07-11 04:20:46 | Liguria, Italy | |||
2022-07-09 | Italy | Liguria | 493299 | 5364 | 0 | 44.41149315 | 8.9326992 | 2022-07-10 04:20:54 | Liguria, Italy | |||
2022-07-08 | Italy | Liguria | 491027 | 5362 | 0 | 44.41149315 | 8.9326992 | 2022-07-09 04:20:59 | Liguria, Italy | |||
2022-07-07 | Italy | Liguria | 488800 | 5361 | 0 | 44.41149315 | 8.9326992 | 2022-07-08 04:20:56 | Liguria, Italy | |||
2022-07-06 | Italy | Liguria | 486430 | 5361 | 0 | 44.41149315 | 8.9326992 | 2022-07-07 04:20:55 | Liguria, Italy | |||
2022-07-05 | Italy | Liguria | 484131 | 5361 | 0 | 44.41149315 | 8.9326992 | 2022-07-06 04:20:58 | Liguria, Italy | |||
2022-07-04 | Italy | Liguria | 480897 | 5360 | 0 | 44.41149315 | 8.9326992 | 2022-07-05 04:20:45 | Liguria, Italy | |||
2022-07-03 | Italy | Liguria | 480209 | 5359 | 0 | 44.41149315 | 8.9326992 | 2022-07-04 04:20:54 | Liguria, Italy | |||
2022-07-02 | Italy | Liguria | 478693 | 5359 | 0 | 44.41149315 | 8.9326992 | 2022-07-03 04:20:59 | Liguria, Italy | |||
2022-07-01 | Italy | Liguria | 476820 | 5356 | 0 | 44.41149315 | 8.9326992 | 2022-07-02 04:21:16 | Liguria, Italy | |||
2022-06-30 | Italy | Liguria | 475111 | 5355 | 0 | 44.41149315 | 8.9326992 | 2022-07-01 04:21:10 | Liguria, Italy | |||
2022-06-29 | Italy | Liguria | 473251 | 5355 | 0 | 44.41149315 | 8.9326992 | 2022-06-30 04:21:01 | Liguria, Italy | |||
2022-06-28 | Italy | Liguria | 471565 | 5352 | 0 | 44.41149315 | 8.9326992 | 2022-06-29 04:20:59 | Liguria, Italy | |||
2022-06-27 | Italy | Liguria | 469067 | 5349 | 0 | 44.41149315 | 8.9326992 | 2022-06-28 04:20:58 | Liguria, Italy | |||
2022-06-26 | Italy | Liguria | 468574 | 5349 | 0 | 44.41149315 | 8.9326992 | 2022-06-27 04:21:00 | Liguria, Italy | |||
2022-06-25 | Italy | Liguria | 467471 | 5349 | 0 | 44.41149315 | 8.9326992 | 2022-06-26 04:21:02 | Liguria, Italy | |||
2022-06-24 | Italy | Liguria | 466509 | 5349 | 0 | 44.41149315 | 8.9326992 | 2022-06-25 04:20:57 | Liguria, Italy | |||
2022-06-23 | Italy | Liguria | 465232 | 5349 | 0 | 44.41149315 | 8.9326992 | 2022-06-24 04:20:58 | Liguria, Italy | |||
2022-06-22 | Italy | Liguria | 463946 | 5346 | 0 | 44.41149315 | 8.9326992 | 2022-06-23 04:20:55 | Liguria, Italy | |||
2022-06-21 | Italy | Liguria | 462772 | 5345 | 0 | 44.41149315 | 8.9326992 | 2022-06-22 04:20:54 | Liguria, Italy | |||
2022-06-20 | Italy | Liguria | 461063 | 5345 | 0 | 44.41149315 | 8.9326992 | 2022-06-21 04:20:56 | Liguria, Italy | |||
2022-06-19 | Italy | Liguria | 460701 | 5345 | 0 | 44.41149315 | 8.9326992 | 2022-06-20 04:21:01 | Liguria, Italy | |||
2022-06-18 | Italy | Liguria | 460011 | 5345 | 0 | 44.41149315 | 8.9326992 | 2022-06-19 04:20:51 | Liguria, Italy | |||
2022-06-17 | Italy | Liguria | 459053 | 5345 | 0 | 44.41149315 | 8.9326992 | 2022-06-18 04:21:10 | Liguria, Italy | |||
2022-06-16 | Italy | Liguria | 458208 | 5345 | 0 | 44.41149315 | 8.9326992 | 2022-06-17 04:20:56 | Liguria, Italy | |||
2022-06-15 | Italy | Liguria | 457332 | 5344 | 0 | 44.41149315 | 8.9326992 | 2022-06-16 04:20:55 | Liguria, Italy | |||
2022-06-14 | Italy | Liguria | 456469 | 5344 | 0 | 44.41149315 | 8.9326992 | 2022-06-15 04:20:54 | Liguria, Italy | |||
2022-06-13 | Italy | Liguria | 455461 | 5341 | 0 | 44.41149315 | 8.9326992 | 2022-06-14 04:20:52 | Liguria, Italy |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;