daily_reports (view)
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)
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-09-20 | Italy | Sardegna | 445720 | 2755 | 0 | 39.21531192 | 9.110616306 | 2022-09-21 04:23:22 | Sardegna, Italy | |||
2022-09-19 | Italy | Sardegna | 445184 | 2752 | 0 | 39.21531192 | 9.110616306 | 2022-09-20 04:22:48 | Sardegna, Italy | |||
2022-09-18 | Italy | Sardegna | 444962 | 2750 | 0 | 39.21531192 | 9.110616306 | 2022-09-19 04:21:49 | Sardegna, Italy | |||
2022-09-17 | Italy | Sardegna | 444762 | 2750 | 0 | 39.21531192 | 9.110616306 | 2022-09-18 04:22:50 | Sardegna, Italy | |||
2022-09-16 | Italy | Sardegna | 444528 | 2750 | 0 | 39.21531192 | 9.110616306 | 2022-09-17 04:20:19 | Sardegna, Italy | |||
2022-09-15 | Italy | Sardegna | 444181 | 2746 | 0 | 39.21531192 | 9.110616306 | 2022-09-16 04:21:19 | Sardegna, Italy | |||
2022-09-14 | Italy | Sardegna | 443877 | 2742 | 0 | 39.21531192 | 9.110616306 | 2022-09-15 04:21:02 | Sardegna, Italy | |||
2022-09-13 | Italy | Sardegna | 443512 | 2742 | 0 | 39.21531192 | 9.110616306 | 2022-09-14 04:20:44 | Sardegna, Italy | |||
2022-09-12 | Italy | Sardegna | 442963 | 2741 | 0 | 39.21531192 | 9.110616306 | 2022-09-13 04:20:57 | Sardegna, Italy | |||
2022-09-11 | Italy | Sardegna | 442774 | 2741 | 0 | 39.21531192 | 9.110616306 | 2022-09-12 04:20:58 | Sardegna, Italy | |||
2022-09-10 | Italy | Sardegna | 442594 | 2740 | 0 | 39.21531192 | 9.110616306 | 2022-09-11 04:20:50 | Sardegna, Italy | |||
2022-09-09 | Italy | Sardegna | 442335 | 2739 | 0 | 39.21531192 | 9.110616306 | 2022-09-10 04:21:10 | Sardegna, Italy | |||
2022-09-08 | Italy | Sardegna | 442038 | 2737 | 0 | 39.21531192 | 9.110616306 | 2022-09-09 04:21:11 | Sardegna, Italy | |||
2022-09-07 | Italy | Sardegna | 441710 | 2731 | 0 | 39.21531192 | 9.110616306 | 2022-09-08 04:21:02 | Sardegna, Italy | |||
2022-09-06 | Italy | Sardegna | 441335 | 2727 | 0 | 39.21531192 | 9.110616306 | 2022-09-07 04:20:59 | Sardegna, Italy | |||
2022-09-05 | Italy | Sardegna | 440704 | 2723 | 0 | 39.21531192 | 9.110616306 | 2022-09-06 04:21:02 | Sardegna, Italy | |||
2022-09-04 | Italy | Sardegna | 440432 | 2723 | 0 | 39.21531192 | 9.110616306 | 2022-09-05 04:21:01 | Sardegna, Italy | |||
2022-09-03 | Italy | Sardegna | 440231 | 2723 | 0 | 39.21531192 | 9.110616306 | 2022-09-04 04:21:22 | Sardegna, Italy | |||
2022-09-02 | Italy | Sardegna | 439934 | 2723 | 0 | 39.21531192 | 9.110616306 | 2022-09-03 04:21:04 | Sardegna, Italy | |||
2022-09-01 | Italy | Sardegna | 439544 | 2722 | 0 | 39.21531192 | 9.110616306 | 2022-09-02 04:21:07 | Sardegna, Italy | |||
2022-08-31 | Italy | Sardegna | 439121 | 2718 | 0 | 39.21531192 | 9.110616306 | 2022-09-01 04:21:03 | Sardegna, Italy | |||
2022-08-30 | Italy | Sardegna | 438675 | 2708 | 0 | 39.21531192 | 9.110616306 | 2022-08-31 04:20:57 | Sardegna, Italy | |||
2022-08-29 | Italy | Sardegna | 437953 | 2701 | 0 | 39.21531192 | 9.110616306 | 2022-08-30 04:21:03 | Sardegna, Italy | |||
2022-08-28 | Italy | Sardegna | 437727 | 2700 | 0 | 39.21531192 | 9.110616306 | 2022-08-29 04:21:06 | Sardegna, Italy | |||
2022-08-27 | Italy | Sardegna | 437451 | 2700 | 0 | 39.21531192 | 9.110616306 | 2022-08-28 04:21:02 | Sardegna, Italy | |||
2022-08-26 | Italy | Sardegna | 436984 | 2696 | 0 | 39.21531192 | 9.110616306 | 2022-08-27 04:20:57 | Sardegna, Italy | |||
2022-08-25 | Italy | Sardegna | 436443 | 2694 | 0 | 39.21531192 | 9.110616306 | 2022-08-26 04:21:02 | Sardegna, Italy | |||
2022-08-24 | Italy | Sardegna | 435830 | 2692 | 0 | 39.21531192 | 9.110616306 | 2022-08-25 04:21:13 | Sardegna, Italy | |||
2022-08-23 | Italy | Sardegna | 435229 | 2686 | 0 | 39.21531192 | 9.110616306 | 2022-08-24 04:20:46 | Sardegna, Italy | |||
2022-08-22 | Italy | Sardegna | 434127 | 2686 | 0 | 39.21531192 | 9.110616306 | 2022-08-23 04:20:56 | Sardegna, Italy | |||
2022-08-21 | Italy | Sardegna | 433764 | 2683 | 0 | 39.21531192 | 9.110616306 | 2022-08-22 04:20:38 | Sardegna, Italy | |||
2022-08-20 | Italy | Sardegna | 433426 | 2681 | 0 | 39.21531192 | 9.110616306 | 2022-08-21 04:20:44 | Sardegna, Italy | |||
2022-08-19 | Italy | Sardegna | 432757 | 2680 | 0 | 39.21531192 | 9.110616306 | 2022-08-20 04:21:01 | Sardegna, Italy | |||
2022-08-18 | Italy | Sardegna | 431998 | 2674 | 0 | 39.21531192 | 9.110616306 | 2022-08-19 04:20:54 | Sardegna, Italy | |||
2022-08-17 | Italy | Sardegna | 431281 | 2668 | 0 | 39.21531192 | 9.110616306 | 2022-08-18 04:21:11 | Sardegna, Italy | |||
2022-08-16 | Italy | Sardegna | 430158 | 2668 | 0 | 39.21531192 | 9.110616306 | 2022-08-17 04:20:59 | Sardegna, Italy | |||
2022-08-15 | Italy | Sardegna | 429664 | 2666 | 0 | 39.21531192 | 9.110616306 | 2022-08-16 04:20:58 | Sardegna, Italy | |||
2022-08-14 | Italy | Sardegna | 429547 | 2665 | 0 | 39.21531192 | 9.110616306 | 2022-08-15 04:20:59 | Sardegna, Italy | |||
2022-08-13 | Italy | Sardegna | 429258 | 2662 | 0 | 39.21531192 | 9.110616306 | 2022-08-14 04:20:55 | Sardegna, Italy | |||
2022-08-12 | Italy | Sardegna | 428678 | 2661 | 0 | 39.21531192 | 9.110616306 | 2022-08-13 04:20:52 | Sardegna, Italy | |||
2022-08-11 | Italy | Sardegna | 427963 | 2659 | 0 | 39.21531192 | 9.110616306 | 2022-08-12 04:20:54 | Sardegna, Italy | |||
2022-08-10 | Italy | Sardegna | 427221 | 2655 | 0 | 39.21531192 | 9.110616306 | 2022-08-11 04:20:49 | Sardegna, Italy | |||
2022-08-09 | Italy | Sardegna | 426192 | 2653 | 0 | 39.21531192 | 9.110616306 | 2022-08-10 04:20:57 | Sardegna, Italy | |||
2022-08-08 | Italy | Sardegna | 424992 | 2647 | 0 | 39.21531192 | 9.110616306 | 2022-08-09 04:20:34 | Sardegna, Italy | |||
2022-08-07 | Italy | Sardegna | 424503 | 2642 | 0 | 39.21531192 | 9.110616306 | 2022-08-08 04:21:08 | Sardegna, Italy | |||
2022-08-06 | Italy | Sardegna | 423973 | 2642 | 0 | 39.21531192 | 9.110616306 | 2022-08-07 04:20:54 | Sardegna, Italy | |||
2022-08-05 | Italy | Sardegna | 423125 | 2635 | 0 | 39.21531192 | 9.110616306 | 2022-08-06 04:20:56 | Sardegna, Italy | |||
2022-08-04 | Italy | Sardegna | 422162 | 2624 | 0 | 39.21531192 | 9.110616306 | 2022-08-05 04:20:52 | Sardegna, Italy | |||
2022-08-03 | Italy | Sardegna | 420964 | 2619 | 0 | 39.21531192 | 9.110616306 | 2022-08-04 04:20:58 | Sardegna, Italy | |||
2022-08-02 | Italy | Sardegna | 419796 | 2614 | 0 | 39.21531192 | 9.110616306 | 2022-08-03 04:20:59 | Sardegna, Italy | |||
2022-08-01 | Italy | Sardegna | 417923 | 2603 | 0 | 39.21531192 | 9.110616306 | 2022-08-02 04:20:53 | Sardegna, Italy | |||
2022-07-31 | Italy | Sardegna | 417256 | 2599 | 0 | 39.21531192 | 9.110616306 | 2022-08-01 04:21:03 | Sardegna, Italy | |||
2022-07-30 | Italy | Sardegna | 416551 | 2599 | 0 | 39.21531192 | 9.110616306 | 2022-07-31 04:21:02 | Sardegna, Italy | |||
2022-07-29 | Italy | Sardegna | 415367 | 2598 | 0 | 39.21531192 | 9.110616306 | 2022-07-30 04:20:42 | Sardegna, Italy | |||
2022-07-28 | Italy | Sardegna | 413778 | 2591 | 0 | 39.21531192 | 9.110616306 | 2022-07-29 04:20:45 | Sardegna, Italy | |||
2022-07-27 | Italy | Sardegna | 412488 | 2588 | 0 | 39.21531192 | 9.110616306 | 2022-07-28 04:20:56 | Sardegna, Italy | |||
2022-07-26 | Italy | Sardegna | 410475 | 2581 | 0 | 39.21531192 | 9.110616306 | 2022-07-27 04:21:04 | Sardegna, Italy | |||
2022-07-25 | Italy | Sardegna | 408181 | 2579 | 0 | 39.21531192 | 9.110616306 | 2022-07-26 04:20:58 | Sardegna, Italy | |||
2022-07-24 | Italy | Sardegna | 407506 | 2575 | 0 | 39.21531192 | 9.110616306 | 2022-07-25 04:20:51 | Sardegna, Italy | |||
2022-07-23 | Italy | Sardegna | 406243 | 2575 | 0 | 39.21531192 | 9.110616306 | 2022-07-24 04:20:47 | Sardegna, Italy | |||
2022-07-22 | Italy | Sardegna | 404688 | 2572 | 0 | 39.21531192 | 9.110616306 | 2022-07-23 04:20:53 | Sardegna, Italy | |||
2022-07-21 | Italy | Sardegna | 402833 | 2571 | 0 | 39.21531192 | 9.110616306 | 2022-07-22 04:21:15 | Sardegna, Italy | |||
2022-07-20 | Italy | Sardegna | 400636 | 2568 | 0 | 39.21531192 | 9.110616306 | 2022-07-21 04:21:10 | Sardegna, Italy | |||
2022-07-19 | Italy | Sardegna | 397977 | 2566 | 0 | 39.21531192 | 9.110616306 | 2022-07-20 04:20:59 | Sardegna, Italy | |||
2022-07-18 | Italy | Sardegna | 394811 | 2565 | 0 | 39.21531192 | 9.110616306 | 2022-07-19 04:20:58 | Sardegna, Italy | |||
2022-07-17 | Italy | Sardegna | 394061 | 2561 | 0 | 39.21531192 | 9.110616306 | 2022-07-18 04:20:59 | Sardegna, Italy | |||
2022-07-16 | Italy | Sardegna | 392510 | 2560 | 0 | 39.21531192 | 9.110616306 | 2022-07-17 04:21:15 | Sardegna, Italy | |||
2022-07-15 | Italy | Sardegna | 390094 | 2557 | 0 | 39.21531192 | 9.110616306 | 2022-07-16 04:21:05 | Sardegna, Italy | |||
2022-07-14 | Italy | Sardegna | 387298 | 2553 | 0 | 39.21531192 | 9.110616306 | 2022-07-15 04:20:53 | Sardegna, Italy | |||
2022-07-13 | Italy | Sardegna | 384211 | 2548 | 0 | 39.21531192 | 9.110616306 | 2022-07-14 04:20:57 | Sardegna, Italy | |||
2022-07-12 | Italy | Sardegna | 381156 | 2544 | 0 | 39.21531192 | 9.110616306 | 2022-07-13 04:20:58 | Sardegna, Italy | |||
2022-07-11 | Italy | Sardegna | 376691 | 2541 | 0 | 39.21531192 | 9.110616306 | 2022-07-12 04:20:51 | Sardegna, Italy | |||
2022-07-10 | Italy | Sardegna | 375299 | 2535 | 0 | 39.21531192 | 9.110616306 | 2022-07-11 04:20:46 | Sardegna, Italy | |||
2022-07-09 | Italy | Sardegna | 373474 | 2535 | 0 | 39.21531192 | 9.110616306 | 2022-07-10 04:20:54 | Sardegna, Italy | |||
2022-07-08 | Italy | Sardegna | 371441 | 2533 | 0 | 39.21531192 | 9.110616306 | 2022-07-09 04:20:59 | Sardegna, Italy | |||
2022-07-07 | Italy | Sardegna | 368734 | 2529 | 0 | 39.21531192 | 9.110616306 | 2022-07-08 04:20:56 | Sardegna, Italy | |||
2022-07-06 | Italy | Sardegna | 365753 | 2527 | 0 | 39.21531192 | 9.110616306 | 2022-07-07 04:20:55 | Sardegna, Italy | |||
2022-07-05 | Italy | Sardegna | 362252 | 2519 | 0 | 39.21531192 | 9.110616306 | 2022-07-06 04:20:58 | Sardegna, Italy | |||
2022-07-04 | Italy | Sardegna | 358468 | 2518 | 0 | 39.21531192 | 9.110616306 | 2022-07-05 04:20:45 | Sardegna, Italy | |||
2022-07-03 | Italy | Sardegna | 357535 | 2518 | 0 | 39.21531192 | 9.110616306 | 2022-07-04 04:20:54 | Sardegna, Italy | |||
2022-07-02 | Italy | Sardegna | 355915 | 2518 | 0 | 39.21531192 | 9.110616306 | 2022-07-03 04:20:59 | Sardegna, Italy | |||
2022-07-01 | Italy | Sardegna | 353529 | 2516 | 0 | 39.21531192 | 9.110616306 | 2022-07-02 04:21:16 | Sardegna, Italy | |||
2022-06-30 | Italy | Sardegna | 350960 | 2516 | 0 | 39.21531192 | 9.110616306 | 2022-07-01 04:21:10 | Sardegna, Italy | |||
2022-06-29 | Italy | Sardegna | 348227 | 2516 | 0 | 39.21531192 | 9.110616306 | 2022-06-30 04:21:01 | Sardegna, Italy | |||
2022-06-28 | Italy | Sardegna | 345736 | 2514 | 0 | 39.21531192 | 9.110616306 | 2022-06-29 04:20:59 | Sardegna, Italy | |||
2022-06-27 | Italy | Sardegna | 342170 | 2511 | 0 | 39.21531192 | 9.110616306 | 2022-06-28 04:20:58 | Sardegna, Italy | |||
2022-06-26 | Italy | Sardegna | 341302 | 2509 | 0 | 39.21531192 | 9.110616306 | 2022-06-27 04:21:00 | Sardegna, Italy | |||
2022-06-25 | Italy | Sardegna | 340050 | 2504 | 0 | 39.21531192 | 9.110616306 | 2022-06-26 04:21:02 | Sardegna, Italy | |||
2022-06-24 | Italy | Sardegna | 338197 | 2502 | 0 | 39.21531192 | 9.110616306 | 2022-06-25 04:20:57 | Sardegna, Italy | |||
2022-06-23 | Italy | Sardegna | 336389 | 2501 | 0 | 39.21531192 | 9.110616306 | 2022-06-24 04:20:58 | Sardegna, Italy | |||
2022-06-22 | Italy | Sardegna | 334390 | 2500 | 0 | 39.21531192 | 9.110616306 | 2022-06-23 04:20:55 | Sardegna, Italy | |||
2022-06-21 | Italy | Sardegna | 332488 | 2500 | 0 | 39.21531192 | 9.110616306 | 2022-06-22 04:20:54 | Sardegna, Italy | |||
2022-06-20 | Italy | Sardegna | 329830 | 2498 | 0 | 39.21531192 | 9.110616306 | 2022-06-21 04:20:56 | Sardegna, Italy | |||
2022-06-19 | Italy | Sardegna | 329077 | 2497 | 0 | 39.21531192 | 9.110616306 | 2022-06-20 04:21:01 | Sardegna, Italy | |||
2022-06-18 | Italy | Sardegna | 328138 | 2496 | 0 | 39.21531192 | 9.110616306 | 2022-06-19 04:20:51 | Sardegna, Italy | |||
2022-06-17 | Italy | Sardegna | 326946 | 2495 | 0 | 39.21531192 | 9.110616306 | 2022-06-18 04:21:10 | Sardegna, Italy | |||
2022-06-16 | Italy | Sardegna | 325639 | 2493 | 0 | 39.21531192 | 9.110616306 | 2022-06-17 04:20:56 | Sardegna, Italy | |||
2022-06-15 | Italy | Sardegna | 324226 | 2489 | 0 | 39.21531192 | 9.110616306 | 2022-06-16 04:20:55 | Sardegna, Italy | |||
2022-06-14 | Italy | Sardegna | 322910 | 2489 | 0 | 39.21531192 | 9.110616306 | 2022-06-15 04:20:54 | Sardegna, Italy | |||
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 VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;