daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,063 rows where country_or_region = "Australia" and province_or_state = "South Australia" 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 | Australia | South Australia | 762643 | 907 | 0 | -34.9285 | 138.6007 | 2022-09-21 04:23:22 | South Australia, Australia | |||
2022-09-19 | Australia | South Australia | 762643 | 907 | 0 | -34.9285 | 138.6007 | 2022-09-20 04:22:48 | South Australia, Australia | |||
2022-09-18 | Australia | South Australia | 762643 | 907 | 0 | -34.9285 | 138.6007 | 2022-09-19 04:21:49 | South Australia, Australia | |||
2022-09-17 | Australia | South Australia | 762643 | 907 | 0 | -34.9285 | 138.6007 | 2022-09-18 04:22:50 | South Australia, Australia | |||
2022-09-16 | Australia | South Australia | 762643 | 907 | 0 | -34.9285 | 138.6007 | 2022-09-17 04:20:19 | South Australia, Australia | |||
2022-09-15 | Australia | South Australia | 758840 | 860 | 0 | -34.9285 | 138.6007 | 2022-09-16 04:21:19 | South Australia, Australia | |||
2022-09-14 | Australia | South Australia | 758840 | 860 | 0 | -34.9285 | 138.6007 | 2022-09-15 04:21:02 | South Australia, Australia | |||
2022-09-13 | Australia | South Australia | 758840 | 860 | 0 | -34.9285 | 138.6007 | 2022-09-14 04:20:44 | South Australia, Australia | |||
2022-09-12 | Australia | South Australia | 758840 | 860 | 0 | -34.9285 | 138.6007 | 2022-09-13 04:20:57 | South Australia, Australia | |||
2022-09-11 | Australia | South Australia | 758840 | 860 | 0 | -34.9285 | 138.6007 | 2022-09-12 04:20:58 | South Australia, Australia | |||
2022-09-10 | Australia | South Australia | 758840 | 860 | 0 | -34.9285 | 138.6007 | 2022-09-11 04:20:50 | South Australia, Australia | |||
2022-09-09 | Australia | South Australia | 758840 | 860 | 0 | -34.9285 | 138.6007 | 2022-09-10 04:21:10 | South Australia, Australia | |||
2022-09-08 | Australia | South Australia | 758216 | 798 | 0 | -34.9285 | 138.6007 | 2022-09-09 04:21:11 | South Australia, Australia | |||
2022-09-07 | Australia | South Australia | 757540 | 796 | 0 | -34.9285 | 138.6007 | 2022-09-08 04:21:02 | South Australia, Australia | |||
2022-09-06 | Australia | South Australia | 757540 | 796 | 0 | -34.9285 | 138.6007 | 2022-09-07 04:20:59 | South Australia, Australia | |||
2022-09-05 | Australia | South Australia | 756189 | 788 | 0 | -34.9285 | 138.6007 | 2022-09-06 04:21:02 | South Australia, Australia | |||
2022-09-04 | Australia | South Australia | 755748 | 787 | 0 | -34.9285 | 138.6007 | 2022-09-05 04:21:01 | South Australia, Australia | |||
2022-09-03 | Australia | South Australia | 755748 | 787 | 0 | -34.9285 | 138.6007 | 2022-09-04 04:21:22 | South Australia, Australia | |||
2022-09-02 | Australia | South Australia | 755363 | 787 | 0 | -34.9285 | 138.6007 | 2022-09-03 04:21:04 | South Australia, Australia | |||
2022-09-01 | Australia | South Australia | 754249 | 778 | 0 | -34.9285 | 138.6007 | 2022-09-02 04:21:07 | South Australia, Australia | |||
2022-08-31 | Australia | South Australia | 753585 | 782 | 0 | -34.9285 | 138.6007 | 2022-09-01 04:21:03 | South Australia, Australia | |||
2022-08-30 | Australia | South Australia | 752904 | 779 | 0 | -34.9285 | 138.6007 | 2022-08-31 04:20:57 | South Australia, Australia | |||
2022-08-29 | Australia | South Australia | 752904 | 779 | 0 | -34.9285 | 138.6007 | 2022-08-30 04:21:03 | South Australia, Australia | |||
2022-08-28 | Australia | South Australia | 752136 | 778 | 0 | -34.9285 | 138.6007 | 2022-08-29 04:21:06 | South Australia, Australia | |||
2022-08-27 | Australia | South Australia | 751530 | 777 | 0 | -34.9285 | 138.6007 | 2022-08-28 04:21:02 | South Australia, Australia | |||
2022-08-26 | Australia | South Australia | 751084 | 777 | 0 | -34.9285 | 138.6007 | 2022-08-27 04:20:57 | South Australia, Australia | |||
2022-08-25 | Australia | South Australia | 750458 | 774 | 0 | -34.9285 | 138.6007 | 2022-08-26 04:21:02 | South Australia, Australia | |||
2022-08-24 | Australia | South Australia | 749665 | 776 | 0 | -34.9285 | 138.6007 | 2022-08-25 04:21:13 | South Australia, Australia | |||
2022-08-23 | Australia | South Australia | 747842 | 786 | 0 | -34.9285 | 138.6007 | 2022-08-24 04:20:46 | South Australia, Australia | |||
2022-08-22 | Australia | South Australia | 747842 | 786 | 0 | -34.9285 | 138.6007 | 2022-08-23 04:20:56 | South Australia, Australia | |||
2022-08-21 | Australia | South Australia | 746910 | 777 | 0 | -34.9285 | 138.6007 | 2022-08-22 04:20:38 | South Australia, Australia | |||
2022-08-20 | Australia | South Australia | 746080 | 779 | 0 | -34.9285 | 138.6007 | 2022-08-21 04:20:44 | South Australia, Australia | |||
2022-08-19 | Australia | South Australia | 745386 | 778 | 0 | -34.9285 | 138.6007 | 2022-08-20 04:21:01 | South Australia, Australia | |||
2022-08-18 | Australia | South Australia | 744489 | 773 | 0 | -34.9285 | 138.6007 | 2022-08-19 04:20:54 | South Australia, Australia | |||
2022-08-17 | Australia | South Australia | 743393 | 771 | 0 | -34.9285 | 138.6007 | 2022-08-18 04:21:11 | South Australia, Australia | |||
2022-08-16 | Australia | South Australia | 740679 | 759 | 0 | -34.9285 | 138.6007 | 2022-08-17 04:20:59 | South Australia, Australia | |||
2022-08-15 | Australia | South Australia | 739234 | 754 | 0 | -34.9285 | 138.6007 | 2022-08-16 04:20:58 | South Australia, Australia | |||
2022-08-14 | Australia | South Australia | 739189 | 754 | 0 | -34.9285 | 138.6007 | 2022-08-15 04:20:59 | South Australia, Australia | |||
2022-08-13 | Australia | South Australia | 736959 | 753 | 0 | -34.9285 | 138.6007 | 2022-08-14 04:20:55 | South Australia, Australia | |||
2022-08-12 | Australia | South Australia | 735513 | 745 | 0 | -34.9285 | 138.6007 | 2022-08-13 04:20:52 | South Australia, Australia | |||
2022-08-11 | Australia | South Australia | 735513 | 745 | 0 | -34.9285 | 138.6007 | 2022-08-12 04:20:54 | South Australia, Australia | |||
2022-08-10 | Australia | South Australia | 732008 | 732 | 0 | -34.9285 | 138.6007 | 2022-08-11 04:20:49 | South Australia, Australia | |||
2022-08-09 | Australia | South Australia | 729945 | 723 | 0 | -34.9285 | 138.6007 | 2022-08-10 04:20:57 | South Australia, Australia | |||
2022-08-08 | Australia | South Australia | 729945 | 723 | 0 | -34.9285 | 138.6007 | 2022-08-09 04:20:34 | South Australia, Australia | |||
2022-08-07 | Australia | South Australia | 727990 | 719 | 0 | -34.9285 | 138.6007 | 2022-08-08 04:21:08 | South Australia, Australia | |||
2022-08-06 | Australia | South Australia | 726276 | 712 | 0 | -34.9285 | 138.6007 | 2022-08-07 04:20:54 | South Australia, Australia | |||
2022-08-05 | Australia | South Australia | 724647 | 712 | 0 | -34.9285 | 138.6007 | 2022-08-06 04:20:56 | South Australia, Australia | |||
2022-08-04 | Australia | South Australia | 722731 | 699 | 0 | -34.9285 | 138.6007 | 2022-08-05 04:20:52 | South Australia, Australia | |||
2022-08-03 | Australia | South Australia | 720268 | 691 | 0 | -34.9285 | 138.6007 | 2022-08-04 04:20:58 | South Australia, Australia | |||
2022-08-02 | Australia | South Australia | 717162 | 688 | 0 | -34.9285 | 138.6007 | 2022-08-03 04:20:59 | South Australia, Australia | |||
2022-08-01 | Australia | South Australia | 711189 | 679 | 0 | -34.9285 | 138.6007 | 2022-08-02 04:20:53 | South Australia, Australia | |||
2022-07-31 | Australia | South Australia | 711189 | 679 | 0 | -34.9285 | 138.6007 | 2022-08-01 04:21:03 | South Australia, Australia | |||
2022-07-30 | Australia | South Australia | 708689 | 674 | 0 | -34.9285 | 138.6007 | 2022-07-31 04:21:02 | South Australia, Australia | |||
2022-07-29 | Australia | South Australia | 706353 | 665 | 0 | -34.9285 | 138.6007 | 2022-07-30 04:20:42 | South Australia, Australia | |||
2022-07-28 | Australia | South Australia | 703395 | 661 | 0 | -34.9285 | 138.6007 | 2022-07-29 04:20:45 | South Australia, Australia | |||
2022-07-27 | Australia | South Australia | 700121 | 653 | 0 | -34.9285 | 138.6007 | 2022-07-28 04:20:56 | South Australia, Australia | |||
2022-07-26 | Australia | South Australia | 696028 | 636 | 0 | -34.9285 | 138.6007 | 2022-07-27 04:21:04 | South Australia, Australia | |||
2022-07-25 | Australia | South Australia | 691671 | 632 | 0 | -34.9285 | 138.6007 | 2022-07-26 04:20:58 | South Australia, Australia | |||
2022-07-24 | Australia | South Australia | 684152 | 614 | 0 | -34.9285 | 138.6007 | 2022-07-25 04:20:51 | South Australia, Australia | |||
2022-07-23 | Australia | South Australia | 684152 | 614 | 0 | -34.9285 | 138.6007 | 2022-07-24 04:20:47 | South Australia, Australia | |||
2022-07-22 | Australia | South Australia | 680702 | 613 | 0 | -34.9285 | 138.6007 | 2022-07-23 04:20:53 | South Australia, Australia | |||
2022-07-21 | Australia | South Australia | 676777 | 610 | 0 | -34.9285 | 138.6007 | 2022-07-22 04:21:15 | South Australia, Australia | |||
2022-07-20 | Australia | South Australia | 672144 | 603 | 0 | -34.9285 | 138.6007 | 2022-07-21 04:21:10 | South Australia, Australia | |||
2022-07-19 | Australia | South Australia | 666858 | 596 | 0 | -34.9285 | 138.6007 | 2022-07-20 04:20:59 | South Australia, Australia | |||
2022-07-18 | Australia | South Australia | 661967 | 574 | 0 | -34.9285 | 138.6007 | 2022-07-19 04:20:58 | South Australia, Australia | |||
2022-07-17 | Australia | South Australia | 657528 | 571 | 0 | -34.9285 | 138.6007 | 2022-07-18 04:20:59 | South Australia, Australia | |||
2022-07-16 | Australia | South Australia | 653247 | 569 | 0 | -34.9285 | 138.6007 | 2022-07-17 04:21:15 | South Australia, Australia | |||
2022-07-15 | Australia | South Australia | 649889 | 568 | 0 | -34.9285 | 138.6007 | 2022-07-16 04:21:05 | South Australia, Australia | |||
2022-07-14 | Australia | South Australia | 641312 | 559 | 0 | -34.9285 | 138.6007 | 2022-07-15 04:20:53 | South Australia, Australia | |||
2022-07-13 | Australia | South Australia | 641312 | 559 | 0 | -34.9285 | 138.6007 | 2022-07-14 04:20:57 | South Australia, Australia | |||
2022-07-12 | Australia | South Australia | 636573 | 558 | 0 | -34.9285 | 138.6007 | 2022-07-13 04:20:58 | South Australia, Australia | |||
2022-07-11 | Australia | South Australia | 631935 | 556 | 0 | -34.9285 | 138.6007 | 2022-07-12 04:20:51 | South Australia, Australia | |||
2022-07-10 | Australia | South Australia | 624799 | 552 | 0 | -34.9285 | 138.6007 | 2022-07-11 04:20:46 | South Australia, Australia | |||
2022-07-09 | Australia | South Australia | 624844 | 552 | 0 | -34.9285 | 138.6007 | 2022-07-10 04:20:54 | South Australia, Australia | |||
2022-07-08 | Australia | South Australia | 618429 | 546 | 0 | -34.9285 | 138.6007 | 2022-07-09 04:20:59 | South Australia, Australia | |||
2022-07-07 | Australia | South Australia | 618429 | 546 | 0 | -34.9285 | 138.6007 | 2022-07-08 04:20:56 | South Australia, Australia | |||
2022-07-06 | Australia | South Australia | 614675 | 546 | 0 | -34.9285 | 138.6007 | 2022-07-07 04:20:55 | South Australia, Australia | |||
2022-07-05 | Australia | South Australia | 610745 | 545 | 0 | -34.9285 | 138.6007 | 2022-07-06 04:20:58 | South Australia, Australia | |||
2022-07-04 | Australia | South Australia | 606638 | 540 | 0 | -34.9285 | 138.6007 | 2022-07-05 04:20:45 | South Australia, Australia | |||
2022-07-03 | Australia | South Australia | 603257 | 540 | 0 | -34.9285 | 138.6007 | 2022-07-04 04:20:54 | South Australia, Australia | |||
2022-07-02 | Australia | South Australia | 600593 | 539 | 0 | -34.9285 | 138.6007 | 2022-07-03 04:20:59 | South Australia, Australia | |||
2022-07-01 | Australia | South Australia | 598168 | 533 | 0 | -34.9285 | 138.6007 | 2022-07-02 04:21:16 | South Australia, Australia | |||
2022-06-30 | Australia | South Australia | 595398 | 533 | 0 | -34.9285 | 138.6007 | 2022-07-01 04:21:10 | South Australia, Australia | |||
2022-06-29 | Australia | South Australia | 592558 | 530 | 0 | -34.9285 | 138.6007 | 2022-06-30 04:21:01 | South Australia, Australia | |||
2022-06-28 | Australia | South Australia | 589324 | 530 | 0 | -34.9285 | 138.6007 | 2022-06-29 04:20:59 | South Australia, Australia | |||
2022-06-27 | Australia | South Australia | 586389 | 530 | 0 | -34.9285 | 138.6007 | 2022-06-28 04:20:58 | South Australia, Australia | |||
2022-06-26 | Australia | South Australia | 583665 | 531 | 0 | -34.9285 | 138.6007 | 2022-06-27 04:21:00 | South Australia, Australia | |||
2022-06-25 | Australia | South Australia | 579405 | 525 | 0 | -34.9285 | 138.6007 | 2022-06-26 04:21:02 | South Australia, Australia | |||
2022-06-24 | Australia | South Australia | 579405 | 525 | 0 | -34.9285 | 138.6007 | 2022-06-25 04:20:57 | South Australia, Australia | |||
2022-06-23 | Australia | South Australia | 577073 | 524 | 0 | -34.9285 | 138.6007 | 2022-06-24 04:20:58 | South Australia, Australia | |||
2022-06-22 | Australia | South Australia | 574433 | 520 | 0 | -34.9285 | 138.6007 | 2022-06-23 04:20:55 | South Australia, Australia | |||
2022-06-21 | Australia | South Australia | 571654 | 518 | 0 | -34.9285 | 138.6007 | 2022-06-22 04:20:54 | South Australia, Australia | |||
2022-06-20 | Australia | South Australia | 568884 | 514 | 0 | -34.9285 | 138.6007 | 2022-06-21 04:20:56 | South Australia, Australia | |||
2022-06-19 | Australia | South Australia | 566507 | 503 | 0 | -34.9285 | 138.6007 | 2022-06-20 04:21:01 | South Australia, Australia | |||
2022-06-18 | Australia | South Australia | 562327 | 496 | 0 | -34.9285 | 138.6007 | 2022-06-19 04:20:51 | South Australia, Australia | |||
2022-06-17 | Australia | South Australia | 559972 | 496 | 0 | -34.9285 | 138.6007 | 2022-06-18 04:21:10 | South Australia, Australia | |||
2022-06-16 | Australia | South Australia | 559972 | 496 | 0 | -34.9285 | 138.6007 | 2022-06-17 04:20:56 | South Australia, Australia | |||
2022-06-15 | Australia | South Australia | 557199 | 490 | 0 | -34.9285 | 138.6007 | 2022-06-16 04:20:55 | South Australia, Australia | |||
2022-06-14 | Australia | South Australia | 554174 | 485 | 0 | -34.9285 | 138.6007 | 2022-06-15 04:20:54 | South Australia, Australia | |||
2022-06-13 | Australia | South Australia | 551400 | 476 | 0 | -34.9285 | 138.6007 | 2022-06-14 04:20:52 | South Australia, Australia |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;