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 = "Sardegna" 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
- Sardegna · 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2016701 | 2016701 | 2022-09-20 | Italy | Sardegna | 445720 | 2755 | 0 | 39.21531192 | 9.110616306 | 2022-09-21 04:23:22 | Sardegna, Italy | |||
3570574 | 3570574 | 2022-09-19 | Italy | Sardegna | 445184 | 2752 | 0 | 39.21531192 | 9.110616306 | 2022-09-20 04:22:48 | Sardegna, Italy | |||
419313 | 419313 | 2022-09-18 | Italy | Sardegna | 444962 | 2750 | 0 | 39.21531192 | 9.110616306 | 2022-09-19 04:21:49 | Sardegna, Italy | |||
3373337 | 3373337 | 2022-09-17 | Italy | Sardegna | 444762 | 2750 | 0 | 39.21531192 | 9.110616306 | 2022-09-18 04:22:50 | Sardegna, Italy | |||
2355445 | 2355445 | 2022-09-16 | Italy | Sardegna | 444528 | 2750 | 0 | 39.21531192 | 9.110616306 | 2022-09-17 04:20:19 | Sardegna, Italy | |||
3986602 | 3986602 | 2022-09-15 | Italy | Sardegna | 444181 | 2746 | 0 | 39.21531192 | 9.110616306 | 2022-09-16 04:21:19 | Sardegna, Italy | |||
1889119 | 1889119 | 2022-09-14 | Italy | Sardegna | 443877 | 2742 | 0 | 39.21531192 | 9.110616306 | 2022-09-15 04:21:02 | Sardegna, Italy | |||
372174 | 372174 | 2022-09-13 | Italy | Sardegna | 443512 | 2742 | 0 | 39.21531192 | 9.110616306 | 2022-09-14 04:20:44 | Sardegna, Italy | |||
2394779 | 2394779 | 2022-09-12 | Italy | Sardegna | 442963 | 2741 | 0 | 39.21531192 | 9.110616306 | 2022-09-13 04:20:57 | Sardegna, Italy | |||
3765857 | 3765857 | 2022-09-11 | Italy | Sardegna | 442774 | 2741 | 0 | 39.21531192 | 9.110616306 | 2022-09-12 04:20:58 | Sardegna, Italy | |||
3824432 | 3824432 | 2022-09-10 | Italy | Sardegna | 442594 | 2740 | 0 | 39.21531192 | 9.110616306 | 2022-09-11 04:20:50 | Sardegna, Italy | |||
962889 | 962889 | 2022-09-09 | Italy | Sardegna | 442335 | 2739 | 0 | 39.21531192 | 9.110616306 | 2022-09-10 04:21:10 | Sardegna, Italy | |||
253291 | 253291 | 2022-09-08 | Italy | Sardegna | 442038 | 2737 | 0 | 39.21531192 | 9.110616306 | 2022-09-09 04:21:11 | Sardegna, Italy | |||
3745089 | 3745089 | 2022-09-07 | Italy | Sardegna | 441710 | 2731 | 0 | 39.21531192 | 9.110616306 | 2022-09-08 04:21:02 | Sardegna, Italy | |||
114729 | 114729 | 2022-09-06 | Italy | Sardegna | 441335 | 2727 | 0 | 39.21531192 | 9.110616306 | 2022-09-07 04:20:59 | Sardegna, Italy | |||
2633701 | 2633701 | 2022-09-05 | Italy | Sardegna | 440704 | 2723 | 0 | 39.21531192 | 9.110616306 | 2022-09-06 04:21:02 | Sardegna, Italy | |||
2987265 | 2987265 | 2022-09-04 | Italy | Sardegna | 440432 | 2723 | 0 | 39.21531192 | 9.110616306 | 2022-09-05 04:21:01 | Sardegna, Italy | |||
2712950 | 2712950 | 2022-09-03 | Italy | Sardegna | 440231 | 2723 | 0 | 39.21531192 | 9.110616306 | 2022-09-04 04:21:22 | Sardegna, Italy | |||
1393655 | 1393655 | 2022-09-02 | Italy | Sardegna | 439934 | 2723 | 0 | 39.21531192 | 9.110616306 | 2022-09-03 04:21:04 | Sardegna, Italy | |||
3547484 | 3547484 | 2022-09-01 | Italy | Sardegna | 439544 | 2722 | 0 | 39.21531192 | 9.110616306 | 2022-09-02 04:21:07 | Sardegna, Italy | |||
2343404 | 2343404 | 2022-08-31 | Italy | Sardegna | 439121 | 2718 | 0 | 39.21531192 | 9.110616306 | 2022-09-01 04:21:03 | Sardegna, Italy | |||
3773884 | 3773884 | 2022-08-30 | Italy | Sardegna | 438675 | 2708 | 0 | 39.21531192 | 9.110616306 | 2022-08-31 04:20:57 | Sardegna, Italy | |||
1680480 | 1680480 | 2022-08-29 | Italy | Sardegna | 437953 | 2701 | 0 | 39.21531192 | 9.110616306 | 2022-08-30 04:21:03 | Sardegna, Italy | |||
1876964 | 1876964 | 2022-08-28 | Italy | Sardegna | 437727 | 2700 | 0 | 39.21531192 | 9.110616306 | 2022-08-29 04:21:06 | Sardegna, Italy | |||
2096091 | 2096091 | 2022-08-27 | Italy | Sardegna | 437451 | 2700 | 0 | 39.21531192 | 9.110616306 | 2022-08-28 04:21:02 | Sardegna, Italy | |||
1531906 | 1531906 | 2022-08-26 | Italy | Sardegna | 436984 | 2696 | 0 | 39.21531192 | 9.110616306 | 2022-08-27 04:20:57 | Sardegna, Italy | |||
2828793 | 2828793 | 2022-08-25 | Italy | Sardegna | 436443 | 2694 | 0 | 39.21531192 | 9.110616306 | 2022-08-26 04:21:02 | Sardegna, Italy | |||
2323326 | 2323326 | 2022-08-24 | Italy | Sardegna | 435830 | 2692 | 0 | 39.21531192 | 9.110616306 | 2022-08-25 04:21:13 | Sardegna, Italy | |||
1250735 | 1250735 | 2022-08-23 | Italy | Sardegna | 435229 | 2686 | 0 | 39.21531192 | 9.110616306 | 2022-08-24 04:20:46 | Sardegna, Italy | |||
2852839 | 2852839 | 2022-08-22 | Italy | Sardegna | 434127 | 2686 | 0 | 39.21531192 | 9.110616306 | 2022-08-23 04:20:56 | Sardegna, Italy | |||
2402811 | 2402811 | 2022-08-21 | Italy | Sardegna | 433764 | 2683 | 0 | 39.21531192 | 9.110616306 | 2022-08-22 04:20:38 | Sardegna, Italy | |||
3797889 | 3797889 | 2022-08-20 | Italy | Sardegna | 433426 | 2681 | 0 | 39.21531192 | 9.110616306 | 2022-08-21 04:20:44 | Sardegna, Italy | |||
2363475 | 2363475 | 2022-08-19 | Italy | Sardegna | 432757 | 2680 | 0 | 39.21531192 | 9.110616306 | 2022-08-20 04:21:01 | Sardegna, Italy | |||
1161146 | 1161146 | 2022-08-18 | Italy | Sardegna | 431998 | 2674 | 0 | 39.21531192 | 9.110616306 | 2022-08-19 04:20:54 | Sardegna, Italy | |||
3950470 | 3950470 | 2022-08-17 | Italy | Sardegna | 431281 | 2668 | 0 | 39.21531192 | 9.110616306 | 2022-08-18 04:21:11 | Sardegna, Italy | |||
990972 | 990972 | 2022-08-16 | Italy | Sardegna | 430158 | 2668 | 0 | 39.21531192 | 9.110616306 | 2022-08-17 04:20:59 | Sardegna, Italy | |||
2494011 | 2494011 | 2022-08-15 | Italy | Sardegna | 429664 | 2666 | 0 | 39.21531192 | 9.110616306 | 2022-08-16 04:20:58 | Sardegna, Italy | |||
3647561 | 3647561 | 2022-08-14 | Italy | Sardegna | 429547 | 2665 | 0 | 39.21531192 | 9.110616306 | 2022-08-15 04:20:59 | Sardegna, Italy | |||
1968567 | 1968567 | 2022-08-13 | Italy | Sardegna | 429258 | 2662 | 0 | 39.21531192 | 9.110616306 | 2022-08-14 04:20:55 | Sardegna, Italy | |||
2888376 | 2888376 | 2022-08-12 | Italy | Sardegna | 428678 | 2661 | 0 | 39.21531192 | 9.110616306 | 2022-08-13 04:20:52 | Sardegna, Italy | |||
3907981 | 3907981 | 2022-08-11 | Italy | Sardegna | 427963 | 2659 | 0 | 39.21531192 | 9.110616306 | 2022-08-12 04:20:54 | Sardegna, Italy | |||
1346298 | 1346298 | 2022-08-10 | Italy | Sardegna | 427221 | 2655 | 0 | 39.21531192 | 9.110616306 | 2022-08-11 04:20:49 | Sardegna, Italy | |||
1086053 | 1086053 | 2022-08-09 | Italy | Sardegna | 426192 | 2653 | 0 | 39.21531192 | 9.110616306 | 2022-08-10 04:20:57 | Sardegna, Italy | |||
3543468 | 3543468 | 2022-08-08 | Italy | Sardegna | 424992 | 2647 | 0 | 39.21531192 | 9.110616306 | 2022-08-09 04:20:34 | Sardegna, Italy | |||
1069871 | 1069871 | 2022-08-07 | Italy | Sardegna | 424503 | 2642 | 0 | 39.21531192 | 9.110616306 | 2022-08-08 04:21:08 | Sardegna, Italy | |||
1940459 | 1940459 | 2022-08-06 | Italy | Sardegna | 423973 | 2642 | 0 | 39.21531192 | 9.110616306 | 2022-08-07 04:20:54 | Sardegna, Italy | |||
880258 | 880258 | 2022-08-05 | Italy | Sardegna | 423125 | 2635 | 0 | 39.21531192 | 9.110616306 | 2022-08-06 04:20:56 | Sardegna, Italy | |||
2008669 | 2008669 | 2022-08-04 | Italy | Sardegna | 422162 | 2624 | 0 | 39.21531192 | 9.110616306 | 2022-08-05 04:20:52 | Sardegna, Italy | |||
1098096 | 1098096 | 2022-08-03 | Italy | Sardegna | 420964 | 2619 | 0 | 39.21531192 | 9.110616306 | 2022-08-04 04:20:58 | Sardegna, Italy | |||
1405021 | 1405021 | 2022-08-02 | Italy | Sardegna | 419796 | 2614 | 0 | 39.21531192 | 9.110616306 | 2022-08-03 04:20:59 | Sardegna, Italy | |||
3617059 | 3617059 | 2022-08-01 | Italy | Sardegna | 417923 | 2603 | 0 | 39.21531192 | 9.110616306 | 2022-08-02 04:20:53 | Sardegna, Italy | |||
3871539 | 3871539 | 2022-07-31 | Italy | Sardegna | 417256 | 2599 | 0 | 39.21531192 | 9.110616306 | 2022-08-01 04:21:03 | Sardegna, Italy | |||
674293 | 674293 | 2022-07-30 | Italy | Sardegna | 416551 | 2599 | 0 | 39.21531192 | 9.110616306 | 2022-07-31 04:21:02 | Sardegna, Italy | |||
1783492 | 1783492 | 2022-07-29 | Italy | Sardegna | 415367 | 2598 | 0 | 39.21531192 | 9.110616306 | 2022-07-30 04:20:42 | Sardegna, Italy | |||
1065855 | 1065855 | 2022-07-28 | Italy | Sardegna | 413778 | 2591 | 0 | 39.21531192 | 9.110616306 | 2022-07-29 04:20:45 | Sardegna, Italy | |||
2335374 | 2335374 | 2022-07-27 | Italy | Sardegna | 412488 | 2588 | 0 | 39.21531192 | 9.110616306 | 2022-07-28 04:20:56 | Sardegna, Italy | |||
1487564 | 1487564 | 2022-07-26 | Italy | Sardegna | 410475 | 2581 | 0 | 39.21531192 | 9.110616306 | 2022-07-27 04:21:04 | Sardegna, Italy | |||
2594010 | 2594010 | 2022-07-25 | Italy | Sardegna | 408181 | 2579 | 0 | 39.21531192 | 9.110616306 | 2022-07-26 04:20:58 | Sardegna, Italy | |||
896125 | 896125 | 2022-07-24 | Italy | Sardegna | 407506 | 2575 | 0 | 39.21531192 | 9.110616306 | 2022-07-25 04:20:51 | Sardegna, Italy | |||
91119 | 91119 | 2022-07-23 | Italy | Sardegna | 406243 | 2575 | 0 | 39.21531192 | 9.110616306 | 2022-07-24 04:20:47 | Sardegna, Italy | |||
900141 | 900141 | 2022-07-22 | Italy | Sardegna | 404688 | 2572 | 0 | 39.21531192 | 9.110616306 | 2022-07-23 04:20:53 | Sardegna, Italy | |||
670277 | 670277 | 2022-07-21 | Italy | Sardegna | 402833 | 2571 | 0 | 39.21531192 | 9.110616306 | 2022-07-22 04:21:15 | Sardegna, Italy | |||
1608240 | 1608240 | 2022-07-20 | Italy | Sardegna | 400636 | 2568 | 0 | 39.21531192 | 9.110616306 | 2022-07-21 04:21:10 | Sardegna, Italy | |||
958873 | 958873 | 2022-07-19 | Italy | Sardegna | 397977 | 2566 | 0 | 39.21531192 | 9.110616306 | 2022-07-20 04:20:59 | Sardegna, Italy | |||
3210260 | 3210260 | 2022-07-18 | Italy | Sardegna | 394811 | 2565 | 0 | 39.21531192 | 9.110616306 | 2022-07-19 04:20:58 | Sardegna, Italy | |||
3405435 | 3405435 | 2022-07-17 | Italy | Sardegna | 394061 | 2561 | 0 | 39.21531192 | 9.110616306 | 2022-07-18 04:20:59 | Sardegna, Italy | |||
2151635 | 2151635 | 2022-07-16 | Italy | Sardegna | 392510 | 2560 | 0 | 39.21531192 | 9.110616306 | 2022-07-17 04:21:15 | Sardegna, Italy | |||
2418868 | 2418868 | 2022-07-15 | Italy | Sardegna | 390094 | 2557 | 0 | 39.21531192 | 9.110616306 | 2022-07-16 04:21:05 | Sardegna, Italy | |||
3428943 | 3428943 | 2022-07-14 | Italy | Sardegna | 387298 | 2553 | 0 | 39.21531192 | 9.110616306 | 2022-07-15 04:20:53 | Sardegna, Italy | |||
3109463 | 3109463 | 2022-07-13 | Italy | Sardegna | 384211 | 2548 | 0 | 39.21531192 | 9.110616306 | 2022-07-14 04:20:57 | Sardegna, Italy | |||
629886 | 629886 | 2022-07-12 | Italy | Sardegna | 381156 | 2544 | 0 | 39.21531192 | 9.110616306 | 2022-07-13 04:20:58 | Sardegna, Italy | |||
1211530 | 1211530 | 2022-07-11 | Italy | Sardegna | 376691 | 2541 | 0 | 39.21531192 | 9.110616306 | 2022-07-12 04:20:51 | Sardegna, Italy | |||
2789012 | 2789012 | 2022-07-10 | Italy | Sardegna | 375299 | 2535 | 0 | 39.21531192 | 9.110616306 | 2022-07-11 04:20:46 | Sardegna, Italy | |||
141965 | 141965 | 2022-07-09 | Italy | Sardegna | 373474 | 2535 | 0 | 39.21531192 | 9.110616306 | 2022-07-10 04:20:54 | Sardegna, Italy | |||
1417065 | 1417065 | 2022-07-08 | Italy | Sardegna | 371441 | 2533 | 0 | 39.21531192 | 9.110616306 | 2022-07-09 04:20:59 | Sardegna, Italy | |||
2740990 | 2740990 | 2022-07-07 | Italy | Sardegna | 368734 | 2529 | 0 | 39.21531192 | 9.110616306 | 2022-07-08 04:20:56 | Sardegna, Italy | |||
1199785 | 1199785 | 2022-07-06 | Italy | Sardegna | 365753 | 2527 | 0 | 39.21531192 | 9.110616306 | 2022-07-07 04:20:55 | Sardegna, Italy | |||
3966528 | 3966528 | 2022-07-05 | Italy | Sardegna | 362252 | 2519 | 0 | 39.21531192 | 9.110616306 | 2022-07-06 04:20:58 | Sardegna, Italy | |||
3078039 | 3078039 | 2022-07-04 | Italy | Sardegna | 358468 | 2518 | 0 | 39.21531192 | 9.110616306 | 2022-07-05 04:20:45 | Sardegna, Italy | |||
1767321 | 1767321 | 2022-07-03 | Italy | Sardegna | 357535 | 2518 | 0 | 39.21531192 | 9.110616306 | 2022-07-04 04:20:54 | Sardegna, Italy | |||
3365307 | 3365307 | 2022-07-02 | Italy | Sardegna | 355915 | 2518 | 0 | 39.21531192 | 9.110616306 | 2022-07-03 04:20:59 | Sardegna, Italy | |||
593636 | 593636 | 2022-07-01 | Italy | Sardegna | 353529 | 2516 | 0 | 39.21531192 | 9.110616306 | 2022-07-02 04:21:16 | Sardegna, Italy | |||
3940037 | 3940037 | 2022-06-30 | Italy | Sardegna | 350960 | 2516 | 0 | 39.21531192 | 9.110616306 | 2022-07-01 04:21:10 | Sardegna, Italy | |||
2489995 | 2489995 | 2022-06-29 | Italy | Sardegna | 348227 | 2516 | 0 | 39.21531192 | 9.110616306 | 2022-06-30 04:21:01 | Sardegna, Italy | |||
2239377 | 2239377 | 2022-06-28 | Italy | Sardegna | 345736 | 2514 | 0 | 39.21531192 | 9.110616306 | 2022-06-29 04:20:59 | Sardegna, Italy | |||
2147619 | 2147619 | 2022-06-27 | Italy | Sardegna | 342170 | 2511 | 0 | 39.21531192 | 9.110616306 | 2022-06-28 04:20:58 | Sardegna, Italy | |||
475420 | 475420 | 2022-06-26 | Italy | Sardegna | 341302 | 2509 | 0 | 39.21531192 | 9.110616306 | 2022-06-27 04:21:00 | Sardegna, Italy | |||
938795 | 938795 | 2022-06-25 | Italy | Sardegna | 340050 | 2504 | 0 | 39.21531192 | 9.110616306 | 2022-06-26 04:21:02 | Sardegna, Italy | |||
3346615 | 3346615 | 2022-06-24 | Italy | Sardegna | 338197 | 2502 | 0 | 39.21531192 | 9.110616306 | 2022-06-25 04:20:57 | Sardegna, Italy | |||
1648356 | 1648356 | 2022-06-23 | Italy | Sardegna | 336389 | 2501 | 0 | 39.21531192 | 9.110616306 | 2022-06-24 04:20:58 | Sardegna, Italy | |||
2187591 | 2187591 | 2022-06-22 | Italy | Sardegna | 334390 | 2500 | 0 | 39.21531192 | 9.110616306 | 2022-06-23 04:20:55 | Sardegna, Italy | |||
166022 | 166022 | 2022-06-21 | Italy | Sardegna | 332488 | 2500 | 0 | 39.21531192 | 9.110616306 | 2022-06-22 04:20:54 | Sardegna, Italy | |||
1763305 | 1763305 | 2022-06-20 | Italy | Sardegna | 329830 | 2498 | 0 | 39.21531192 | 9.110616306 | 2022-06-21 04:20:56 | Sardegna, Italy | |||
3269491 | 3269491 | 2022-06-19 | Italy | Sardegna | 329077 | 2497 | 0 | 39.21531192 | 9.110616306 | 2022-06-20 04:21:01 | Sardegna, Italy | |||
3397403 | 3397403 | 2022-06-18 | Italy | Sardegna | 328138 | 2496 | 0 | 39.21531192 | 9.110616306 | 2022-06-19 04:20:51 | Sardegna, Italy | |||
2311280 | 2311280 | 2022-06-17 | Italy | Sardegna | 326946 | 2495 | 0 | 39.21531192 | 9.110616306 | 2022-06-18 04:21:10 | Sardegna, Italy | |||
558784 | 558784 | 2022-06-16 | Italy | Sardegna | 325639 | 2493 | 0 | 39.21531192 | 9.110616306 | 2022-06-17 04:20:56 | Sardegna, Italy | |||
3982586 | 3982586 | 2022-06-15 | Italy | Sardegna | 324226 | 2489 | 0 | 39.21531192 | 9.110616306 | 2022-06-16 04:20:55 | Sardegna, Italy | |||
946827 | 946827 | 2022-06-14 | Italy | Sardegna | 322910 | 2489 | 0 | 39.21531192 | 9.110616306 | 2022-06-15 04:20:54 | Sardegna, Italy | |||
2979235 | 2979235 | 2022-06-13 | Italy | Sardegna | 321170 | 2486 | 0 | 39.21531192 | 9.110616306 | 2022-06-14 04:20:52 | Sardegna, 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]);