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 = "Liguria" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
last_update (date) >30 ✖
- 2022-04-13 2
- 2022-05-26 2
- 2020-05-15 1
- 2020-05-16 1
- 2020-05-17 1
- 2020-05-18 1
- 2020-05-19 1
- 2020-05-20 1
- 2020-05-21 1
- 2020-05-22 1
- 2020-05-23 1
- 2020-05-24 1
- 2020-05-25 1
- 2020-05-26 1
- 2020-05-27 1
- 2020-05-28 1
- 2020-05-29 1
- 2020-05-30 1
- 2020-05-31 1
- 2020-06-01 1
- 2020-06-02 1
- 2020-06-03 1
- 2020-06-04 1
- 2020-06-05 1
- 2020-06-06 1
- 2020-06-07 1
- 2020-06-08 1
- 2020-06-09 1
- 2020-06-10 1
- 2020-06-11 1
- …
province_or_state 1
- Liguria · 860 ✖
country_or_region 1
- Italy · 860 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2016693 | 2016693 | 2022-09-20 | Italy | Liguria | 569236 | 5571 | 0 | 44.41149315 | 8.9326992 | 2022-09-21 04:23:22 | Liguria, Italy | |||
3570566 | 3570566 | 2022-09-19 | Italy | Liguria | 568456 | 5567 | 0 | 44.41149315 | 8.9326992 | 2022-09-20 04:22:48 | Liguria, Italy | |||
419305 | 419305 | 2022-09-18 | Italy | Liguria | 568302 | 5565 | 0 | 44.41149315 | 8.9326992 | 2022-09-19 04:21:49 | Liguria, Italy | |||
3373329 | 3373329 | 2022-09-17 | Italy | Liguria | 567981 | 5565 | 0 | 44.41149315 | 8.9326992 | 2022-09-18 04:22:50 | Liguria, Italy | |||
2355437 | 2355437 | 2022-09-16 | Italy | Liguria | 567534 | 5565 | 0 | 44.41149315 | 8.9326992 | 2022-09-17 04:20:19 | Liguria, Italy | |||
3986594 | 3986594 | 2022-09-15 | Italy | Liguria | 567077 | 5564 | 0 | 44.41149315 | 8.9326992 | 2022-09-16 04:21:19 | Liguria, Italy | |||
1889111 | 1889111 | 2022-09-14 | Italy | Liguria | 566609 | 5562 | 0 | 44.41149315 | 8.9326992 | 2022-09-15 04:21:02 | Liguria, Italy | |||
372166 | 372166 | 2022-09-13 | Italy | Liguria | 566130 | 5562 | 0 | 44.41149315 | 8.9326992 | 2022-09-14 04:20:44 | Liguria, Italy | |||
2394771 | 2394771 | 2022-09-12 | Italy | Liguria | 565424 | 5560 | 0 | 44.41149315 | 8.9326992 | 2022-09-13 04:20:57 | Liguria, Italy | |||
3765849 | 3765849 | 2022-09-11 | Italy | Liguria | 565268 | 5558 | 0 | 44.41149315 | 8.9326992 | 2022-09-12 04:20:58 | Liguria, Italy | |||
3824424 | 3824424 | 2022-09-10 | Italy | Liguria | 564932 | 5558 | 0 | 44.41149315 | 8.9326992 | 2022-09-11 04:20:50 | Liguria, Italy | |||
962881 | 962881 | 2022-09-09 | Italy | Liguria | 564453 | 5555 | 0 | 44.41149315 | 8.9326992 | 2022-09-10 04:21:10 | Liguria, Italy | |||
253283 | 253283 | 2022-09-08 | Italy | Liguria | 564043 | 5555 | 0 | 44.41149315 | 8.9326992 | 2022-09-09 04:21:11 | Liguria, Italy | |||
3745081 | 3745081 | 2022-09-07 | Italy | Liguria | 563603 | 5552 | 0 | 44.41149315 | 8.9326992 | 2022-09-08 04:21:02 | Liguria, Italy | |||
114721 | 114721 | 2022-09-06 | Italy | Liguria | 563111 | 5550 | 0 | 44.41149315 | 8.9326992 | 2022-09-07 04:20:59 | Liguria, Italy | |||
2633693 | 2633693 | 2022-09-05 | Italy | Liguria | 562443 | 5548 | 0 | 44.41149315 | 8.9326992 | 2022-09-06 04:21:02 | Liguria, Italy | |||
2987257 | 2987257 | 2022-09-04 | Italy | Liguria | 562298 | 5548 | 0 | 44.41149315 | 8.9326992 | 2022-09-05 04:21:01 | Liguria, Italy | |||
2712942 | 2712942 | 2022-09-03 | Italy | Liguria | 561917 | 5548 | 0 | 44.41149315 | 8.9326992 | 2022-09-04 04:21:22 | Liguria, Italy | |||
1393647 | 1393647 | 2022-09-02 | Italy | Liguria | 561421 | 5547 | 0 | 44.41149315 | 8.9326992 | 2022-09-03 04:21:04 | Liguria, Italy | |||
3547476 | 3547476 | 2022-09-01 | Italy | Liguria | 560894 | 5542 | 0 | 44.41149315 | 8.9326992 | 2022-09-02 04:21:07 | Liguria, Italy | |||
2343396 | 2343396 | 2022-08-31 | Italy | Liguria | 560332 | 5540 | 0 | 44.41149315 | 8.9326992 | 2022-09-01 04:21:03 | Liguria, Italy | |||
3773876 | 3773876 | 2022-08-30 | Italy | Liguria | 559807 | 5536 | 0 | 44.41149315 | 8.9326992 | 2022-08-31 04:20:57 | Liguria, Italy | |||
1680472 | 1680472 | 2022-08-29 | Italy | Liguria | 558871 | 5534 | 0 | 44.41149315 | 8.9326992 | 2022-08-30 04:21:03 | Liguria, Italy | |||
1876956 | 1876956 | 2022-08-28 | Italy | Liguria | 558685 | 5534 | 0 | 44.41149315 | 8.9326992 | 2022-08-29 04:21:06 | Liguria, Italy | |||
2096083 | 2096083 | 2022-08-27 | Italy | Liguria | 558195 | 5532 | 0 | 44.41149315 | 8.9326992 | 2022-08-28 04:21:02 | Liguria, Italy | |||
1531898 | 1531898 | 2022-08-26 | Italy | Liguria | 557595 | 5530 | 0 | 44.41149315 | 8.9326992 | 2022-08-27 04:20:57 | Liguria, Italy | |||
2828785 | 2828785 | 2022-08-25 | Italy | Liguria | 556971 | 5528 | 0 | 44.41149315 | 8.9326992 | 2022-08-26 04:21:02 | Liguria, Italy | |||
2323318 | 2323318 | 2022-08-24 | Italy | Liguria | 556315 | 5525 | 0 | 44.41149315 | 8.9326992 | 2022-08-25 04:21:13 | Liguria, Italy | |||
1250727 | 1250727 | 2022-08-23 | Italy | Liguria | 555622 | 5518 | 0 | 44.41149315 | 8.9326992 | 2022-08-24 04:20:46 | Liguria, Italy | |||
2852831 | 2852831 | 2022-08-22 | Italy | Liguria | 554567 | 5514 | 0 | 44.41149315 | 8.9326992 | 2022-08-23 04:20:56 | Liguria, Italy | |||
2402803 | 2402803 | 2022-08-21 | Italy | Liguria | 554320 | 5512 | 0 | 44.41149315 | 8.9326992 | 2022-08-22 04:20:38 | Liguria, Italy | |||
3797881 | 3797881 | 2022-08-20 | Italy | Liguria | 553774 | 5507 | 0 | 44.41149315 | 8.9326992 | 2022-08-21 04:20:44 | Liguria, Italy | |||
2363467 | 2363467 | 2022-08-19 | Italy | Liguria | 553025 | 5502 | 0 | 44.41149315 | 8.9326992 | 2022-08-20 04:21:01 | Liguria, Italy | |||
1161138 | 1161138 | 2022-08-18 | Italy | Liguria | 552356 | 5501 | 0 | 44.41149315 | 8.9326992 | 2022-08-19 04:20:54 | Liguria, Italy | |||
3950462 | 3950462 | 2022-08-17 | Italy | Liguria | 551513 | 5498 | 0 | 44.41149315 | 8.9326992 | 2022-08-18 04:21:11 | Liguria, Italy | |||
990964 | 990964 | 2022-08-16 | Italy | Liguria | 550355 | 5494 | 0 | 44.41149315 | 8.9326992 | 2022-08-17 04:20:59 | Liguria, Italy | |||
2494003 | 2494003 | 2022-08-15 | Italy | Liguria | 550042 | 5492 | 0 | 44.41149315 | 8.9326992 | 2022-08-16 04:20:58 | Liguria, Italy | |||
3647553 | 3647553 | 2022-08-14 | Italy | Liguria | 549775 | 5492 | 0 | 44.41149315 | 8.9326992 | 2022-08-15 04:20:59 | Liguria, Italy | |||
1968559 | 1968559 | 2022-08-13 | Italy | Liguria | 549105 | 5492 | 0 | 44.41149315 | 8.9326992 | 2022-08-14 04:20:55 | Liguria, Italy | |||
2888368 | 2888368 | 2022-08-12 | Italy | Liguria | 548256 | 5489 | 0 | 44.41149315 | 8.9326992 | 2022-08-13 04:20:52 | Liguria, Italy | |||
3907973 | 3907973 | 2022-08-11 | Italy | Liguria | 547432 | 5484 | 0 | 44.41149315 | 8.9326992 | 2022-08-12 04:20:54 | Liguria, Italy | |||
1346290 | 1346290 | 2022-08-10 | Italy | Liguria | 546489 | 5481 | 0 | 44.41149315 | 8.9326992 | 2022-08-11 04:20:49 | Liguria, Italy | |||
1086045 | 1086045 | 2022-08-09 | Italy | Liguria | 545484 | 5476 | 0 | 44.41149315 | 8.9326992 | 2022-08-10 04:20:57 | Liguria, Italy | |||
3543460 | 3543460 | 2022-08-08 | Italy | Liguria | 543938 | 5472 | 0 | 44.41149315 | 8.9326992 | 2022-08-09 04:20:34 | Liguria, Italy | |||
1069863 | 1069863 | 2022-08-07 | Italy | Liguria | 543608 | 5472 | 0 | 44.41149315 | 8.9326992 | 2022-08-08 04:21:08 | Liguria, Italy | |||
1940451 | 1940451 | 2022-08-06 | Italy | Liguria | 542769 | 5472 | 0 | 44.41149315 | 8.9326992 | 2022-08-07 04:20:54 | Liguria, Italy | |||
880250 | 880250 | 2022-08-05 | Italy | Liguria | 541615 | 5464 | 0 | 44.41149315 | 8.9326992 | 2022-08-06 04:20:56 | Liguria, Italy | |||
2008661 | 2008661 | 2022-08-04 | Italy | Liguria | 540405 | 5457 | 0 | 44.41149315 | 8.9326992 | 2022-08-05 04:20:52 | Liguria, Italy | |||
1098088 | 1098088 | 2022-08-03 | Italy | Liguria | 539095 | 5451 | 0 | 44.41149315 | 8.9326992 | 2022-08-04 04:20:58 | Liguria, Italy | |||
1405013 | 1405013 | 2022-08-02 | Italy | Liguria | 537679 | 5448 | 0 | 44.41149315 | 8.9326992 | 2022-08-03 04:20:59 | Liguria, Italy | |||
3617051 | 3617051 | 2022-08-01 | Italy | Liguria | 535561 | 5442 | 0 | 44.41149315 | 8.9326992 | 2022-08-02 04:20:53 | Liguria, Italy | |||
3871531 | 3871531 | 2022-07-31 | Italy | Liguria | 535089 | 5440 | 0 | 44.41149315 | 8.9326992 | 2022-08-01 04:21:03 | Liguria, Italy | |||
674285 | 674285 | 2022-07-30 | Italy | Liguria | 534009 | 5440 | 0 | 44.41149315 | 8.9326992 | 2022-07-31 04:21:02 | Liguria, Italy | |||
1783484 | 1783484 | 2022-07-29 | Italy | Liguria | 532322 | 5437 | 0 | 44.41149315 | 8.9326992 | 2022-07-30 04:20:42 | Liguria, Italy | |||
1065847 | 1065847 | 2022-07-28 | Italy | Liguria | 530717 | 5431 | 0 | 44.41149315 | 8.9326992 | 2022-07-29 04:20:45 | Liguria, Italy | |||
2335366 | 2335366 | 2022-07-27 | Italy | Liguria | 529226 | 5425 | 0 | 44.41149315 | 8.9326992 | 2022-07-28 04:20:56 | Liguria, Italy | |||
1487556 | 1487556 | 2022-07-26 | Italy | Liguria | 527515 | 5415 | 0 | 44.41149315 | 8.9326992 | 2022-07-27 04:21:04 | Liguria, Italy | |||
2594002 | 2594002 | 2022-07-25 | Italy | Liguria | 524936 | 5408 | 0 | 44.41149315 | 8.9326992 | 2022-07-26 04:20:58 | Liguria, Italy | |||
896117 | 896117 | 2022-07-24 | Italy | Liguria | 524253 | 5405 | 0 | 44.41149315 | 8.9326992 | 2022-07-25 04:20:51 | Liguria, Italy | |||
91111 | 91111 | 2022-07-23 | Italy | Liguria | 522939 | 5401 | 0 | 44.41149315 | 8.9326992 | 2022-07-24 04:20:47 | Liguria, Italy | |||
900133 | 900133 | 2022-07-22 | Italy | Liguria | 520999 | 5400 | 0 | 44.41149315 | 8.9326992 | 2022-07-23 04:20:53 | Liguria, Italy | |||
670269 | 670269 | 2022-07-21 | Italy | Liguria | 519165 | 5396 | 0 | 44.41149315 | 8.9326992 | 2022-07-22 04:21:15 | Liguria, Italy | |||
1608232 | 1608232 | 2022-07-20 | Italy | Liguria | 517117 | 5396 | 0 | 44.41149315 | 8.9326992 | 2022-07-21 04:21:10 | Liguria, Italy | |||
958865 | 958865 | 2022-07-19 | Italy | Liguria | 514928 | 5392 | 0 | 44.41149315 | 8.9326992 | 2022-07-20 04:20:59 | Liguria, Italy | |||
3210252 | 3210252 | 2022-07-18 | Italy | Liguria | 511701 | 5387 | 0 | 44.41149315 | 8.9326992 | 2022-07-19 04:20:58 | Liguria, Italy | |||
3405427 | 3405427 | 2022-07-17 | Italy | Liguria | 511022 | 5386 | 0 | 44.41149315 | 8.9326992 | 2022-07-18 04:20:59 | Liguria, Italy | |||
2151627 | 2151627 | 2022-07-16 | Italy | Liguria | 509264 | 5384 | 0 | 44.41149315 | 8.9326992 | 2022-07-17 04:21:15 | Liguria, Italy | |||
2418860 | 2418860 | 2022-07-15 | Italy | Liguria | 506915 | 5379 | 0 | 44.41149315 | 8.9326992 | 2022-07-16 04:21:05 | Liguria, Italy | |||
3428935 | 3428935 | 2022-07-14 | Italy | Liguria | 504735 | 5376 | 0 | 44.41149315 | 8.9326992 | 2022-07-15 04:20:53 | Liguria, Italy | |||
3109455 | 3109455 | 2022-07-13 | Italy | Liguria | 502316 | 5374 | 0 | 44.41149315 | 8.9326992 | 2022-07-14 04:20:57 | Liguria, Italy | |||
629878 | 629878 | 2022-07-12 | Italy | Liguria | 499754 | 5371 | 0 | 44.41149315 | 8.9326992 | 2022-07-13 04:20:58 | Liguria, Italy | |||
1211522 | 1211522 | 2022-07-11 | Italy | Liguria | 495935 | 5366 | 0 | 44.41149315 | 8.9326992 | 2022-07-12 04:20:51 | Liguria, Italy | |||
2789004 | 2789004 | 2022-07-10 | Italy | Liguria | 495064 | 5364 | 0 | 44.41149315 | 8.9326992 | 2022-07-11 04:20:46 | Liguria, Italy | |||
141957 | 141957 | 2022-07-09 | Italy | Liguria | 493299 | 5364 | 0 | 44.41149315 | 8.9326992 | 2022-07-10 04:20:54 | Liguria, Italy | |||
1417057 | 1417057 | 2022-07-08 | Italy | Liguria | 491027 | 5362 | 0 | 44.41149315 | 8.9326992 | 2022-07-09 04:20:59 | Liguria, Italy | |||
2740982 | 2740982 | 2022-07-07 | Italy | Liguria | 488800 | 5361 | 0 | 44.41149315 | 8.9326992 | 2022-07-08 04:20:56 | Liguria, Italy | |||
1199777 | 1199777 | 2022-07-06 | Italy | Liguria | 486430 | 5361 | 0 | 44.41149315 | 8.9326992 | 2022-07-07 04:20:55 | Liguria, Italy | |||
3966520 | 3966520 | 2022-07-05 | Italy | Liguria | 484131 | 5361 | 0 | 44.41149315 | 8.9326992 | 2022-07-06 04:20:58 | Liguria, Italy | |||
3078031 | 3078031 | 2022-07-04 | Italy | Liguria | 480897 | 5360 | 0 | 44.41149315 | 8.9326992 | 2022-07-05 04:20:45 | Liguria, Italy | |||
1767313 | 1767313 | 2022-07-03 | Italy | Liguria | 480209 | 5359 | 0 | 44.41149315 | 8.9326992 | 2022-07-04 04:20:54 | Liguria, Italy | |||
3365299 | 3365299 | 2022-07-02 | Italy | Liguria | 478693 | 5359 | 0 | 44.41149315 | 8.9326992 | 2022-07-03 04:20:59 | Liguria, Italy | |||
593628 | 593628 | 2022-07-01 | Italy | Liguria | 476820 | 5356 | 0 | 44.41149315 | 8.9326992 | 2022-07-02 04:21:16 | Liguria, Italy | |||
3940029 | 3940029 | 2022-06-30 | Italy | Liguria | 475111 | 5355 | 0 | 44.41149315 | 8.9326992 | 2022-07-01 04:21:10 | Liguria, Italy | |||
2489987 | 2489987 | 2022-06-29 | Italy | Liguria | 473251 | 5355 | 0 | 44.41149315 | 8.9326992 | 2022-06-30 04:21:01 | Liguria, Italy | |||
2239369 | 2239369 | 2022-06-28 | Italy | Liguria | 471565 | 5352 | 0 | 44.41149315 | 8.9326992 | 2022-06-29 04:20:59 | Liguria, Italy | |||
2147611 | 2147611 | 2022-06-27 | Italy | Liguria | 469067 | 5349 | 0 | 44.41149315 | 8.9326992 | 2022-06-28 04:20:58 | Liguria, Italy | |||
475412 | 475412 | 2022-06-26 | Italy | Liguria | 468574 | 5349 | 0 | 44.41149315 | 8.9326992 | 2022-06-27 04:21:00 | Liguria, Italy | |||
938787 | 938787 | 2022-06-25 | Italy | Liguria | 467471 | 5349 | 0 | 44.41149315 | 8.9326992 | 2022-06-26 04:21:02 | Liguria, Italy | |||
3346607 | 3346607 | 2022-06-24 | Italy | Liguria | 466509 | 5349 | 0 | 44.41149315 | 8.9326992 | 2022-06-25 04:20:57 | Liguria, Italy | |||
1648348 | 1648348 | 2022-06-23 | Italy | Liguria | 465232 | 5349 | 0 | 44.41149315 | 8.9326992 | 2022-06-24 04:20:58 | Liguria, Italy | |||
2187583 | 2187583 | 2022-06-22 | Italy | Liguria | 463946 | 5346 | 0 | 44.41149315 | 8.9326992 | 2022-06-23 04:20:55 | Liguria, Italy | |||
166014 | 166014 | 2022-06-21 | Italy | Liguria | 462772 | 5345 | 0 | 44.41149315 | 8.9326992 | 2022-06-22 04:20:54 | Liguria, Italy | |||
1763297 | 1763297 | 2022-06-20 | Italy | Liguria | 461063 | 5345 | 0 | 44.41149315 | 8.9326992 | 2022-06-21 04:20:56 | Liguria, Italy | |||
3269483 | 3269483 | 2022-06-19 | Italy | Liguria | 460701 | 5345 | 0 | 44.41149315 | 8.9326992 | 2022-06-20 04:21:01 | Liguria, Italy | |||
3397395 | 3397395 | 2022-06-18 | Italy | Liguria | 460011 | 5345 | 0 | 44.41149315 | 8.9326992 | 2022-06-19 04:20:51 | Liguria, Italy | |||
2311272 | 2311272 | 2022-06-17 | Italy | Liguria | 459053 | 5345 | 0 | 44.41149315 | 8.9326992 | 2022-06-18 04:21:10 | Liguria, Italy | |||
558776 | 558776 | 2022-06-16 | Italy | Liguria | 458208 | 5345 | 0 | 44.41149315 | 8.9326992 | 2022-06-17 04:20:56 | Liguria, Italy | |||
3982578 | 3982578 | 2022-06-15 | Italy | Liguria | 457332 | 5344 | 0 | 44.41149315 | 8.9326992 | 2022-06-16 04:20:55 | Liguria, Italy | |||
946819 | 946819 | 2022-06-14 | Italy | Liguria | 456469 | 5344 | 0 | 44.41149315 | 8.9326992 | 2022-06-15 04:20:54 | Liguria, Italy | |||
2979227 | 2979227 | 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 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]);