daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
275 rows where country_or_region = "Australia" and deaths = 820 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date), last_update (date)
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2021-08-30 | Australia | Victoria | 22071 | 820 | 0 | -37.8136 | 144.9631 | 2021-08-31 04:21:46 | Victoria, Australia | |||
2021-08-29 | Australia | Victoria | 21996 | 820 | 0 | -37.8136 | 144.9631 | 2021-08-30 04:21:23 | Victoria, Australia | |||
2021-08-28 | Australia | Victoria | 21926 | 820 | 0 | -37.8136 | 144.9631 | 2021-08-29 04:21:14 | Victoria, Australia | |||
2021-08-27 | Australia | Victoria | 21835 | 820 | 0 | -37.8136 | 144.9631 | 2021-08-28 04:21:28 | Victoria, Australia | |||
2021-08-26 | Australia | Victoria | 21772 | 820 | 0 | -37.8136 | 144.9631 | 2021-08-27 04:21:37 | Victoria, Australia | |||
2021-08-25 | Australia | Victoria | 21694 | 820 | 0 | -37.8136 | 144.9631 | 2021-08-26 04:21:28 | Victoria, Australia | |||
2021-08-24 | Australia | Victoria | 21618 | 820 | 0 | -37.8136 | 144.9631 | 2021-08-25 04:21:41 | Victoria, Australia | |||
2021-08-23 | Australia | Victoria | 21577 | 820 | 0 | -37.8136 | 144.9631 | 2021-08-24 04:21:19 | Victoria, Australia | |||
2021-08-22 | Australia | Victoria | 21526 | 820 | 0 | -37.8136 | 144.9631 | 2021-08-23 04:21:27 | Victoria, Australia | |||
2021-08-21 | Australia | Victoria | 21455 | 820 | 0 | -37.8136 | 144.9631 | 2021-08-22 04:21:29 | Victoria, Australia | |||
2021-08-20 | Australia | Victoria | 21389 | 820 | 0 | -37.8136 | 144.9631 | 2021-08-21 04:21:38 | Victoria, Australia | |||
2021-08-19 | Australia | Victoria | 21328 | 820 | 0 | -37.8136 | 144.9631 | 2021-08-20 04:21:33 | Victoria, Australia | |||
2021-08-18 | Australia | Victoria | 21271 | 820 | 0 | -37.8136 | 144.9631 | 2021-08-19 04:21:15 | Victoria, Australia | |||
2021-08-17 | Australia | Victoria | 21215 | 820 | 0 | -37.8136 | 144.9631 | 2021-08-18 04:21:35 | Victoria, Australia | |||
2021-08-16 | Australia | Victoria | 21191 | 820 | 0 | -37.8136 | 144.9631 | 2021-08-17 04:21:49 | Victoria, Australia | |||
2021-08-15 | Australia | Victoria | 21166 | 820 | 0 | -37.8136 | 144.9631 | 2021-08-16 04:21:31 | Victoria, Australia | |||
2021-08-14 | Australia | Victoria | 21144 | 820 | 0 | -37.8136 | 144.9631 | 2021-08-15 04:21:41 | Victoria, Australia | |||
2021-08-13 | Australia | Victoria | 21119 | 820 | 0 | -37.8136 | 144.9631 | 2021-08-14 04:21:25 | Victoria, Australia | |||
2021-08-12 | Australia | Victoria | 21098 | 820 | 0 | -37.8136 | 144.9631 | 2021-08-13 04:21:24 | Victoria, Australia | |||
2021-08-11 | Australia | Victoria | 21079 | 820 | 0 | -37.8136 | 144.9631 | 2021-08-12 04:21:25 | Victoria, Australia | |||
2021-08-10 | Australia | Victoria | 21061 | 820 | 0 | -37.8136 | 144.9631 | 2021-08-11 04:21:58 | Victoria, Australia | |||
2021-08-09 | Australia | Victoria | 21041 | 820 | 0 | -37.8136 | 144.9631 | 2021-08-10 04:21:27 | Victoria, Australia | |||
2021-08-08 | Australia | Victoria | 21021 | 820 | 0 | -37.8136 | 144.9631 | 2021-08-09 04:21:24 | Victoria, Australia | |||
2021-08-07 | Australia | Victoria | 21010 | 820 | 0 | -37.8136 | 144.9631 | 2021-08-08 04:21:33 | Victoria, Australia | |||
2021-08-06 | Australia | Victoria | 20997 | 820 | 0 | -37.8136 | 144.9631 | 2021-08-07 04:21:30 | Victoria, Australia | |||
2021-08-05 | Australia | Victoria | 20967 | 820 | 0 | -37.8136 | 144.9631 | 2021-08-06 04:21:18 | Victoria, Australia | |||
2021-08-04 | Australia | Victoria | 20961 | 820 | 20061 | 80 | -37.8136 | 144.9631 | 2021-08-05 04:21:51 | Victoria, Australia | ||
2021-08-03 | Australia | Victoria | 20955 | 820 | 20036 | 99 | -37.8136 | 144.9631 | 2021-08-04 04:21:25 | Victoria, Australia | ||
2021-08-02 | Australia | Victoria | 20955 | 820 | 20011 | 124 | -37.8136 | 144.9631 | 2021-08-03 04:21:39 | Victoria, Australia | ||
2021-08-01 | Australia | Victoria | 20950 | 820 | 19996 | 134 | -37.8136 | 144.9631 | 2021-08-02 04:21:36 | Victoria, Australia | ||
2021-07-31 | Australia | Victoria | 20948 | 820 | 19967 | 161 | -37.8136 | 144.9631 | 2021-08-01 04:21:50 | Victoria, Australia | ||
2021-07-30 | Australia | Victoria | 20944 | 820 | 19944 | 180 | -37.8136 | 144.9631 | 2021-07-31 04:21:35 | Victoria, Australia | ||
2021-07-29 | Australia | Victoria | 20942 | 820 | 19922 | 200 | -37.8136 | 144.9631 | 2021-07-30 04:21:34 | Victoria, Australia | ||
2021-07-28 | Australia | Victoria | 20939 | 820 | 19914 | 205 | -37.8136 | 144.9631 | 2021-07-29 04:21:33 | Victoria, Australia | ||
2021-07-27 | Australia | Victoria | 20932 | 820 | 19907 | 205 | -37.8136 | 144.9631 | 2021-07-28 04:21:39 | Victoria, Australia | ||
2021-07-26 | Australia | Victoria | 20924 | 820 | 19906 | 198 | -37.8136 | 144.9631 | 2021-07-27 04:21:18 | Victoria, Australia | ||
2021-07-25 | Australia | Victoria | 20914 | 820 | 19904 | 190 | -37.8136 | 144.9631 | 2021-07-26 04:21:28 | Victoria, Australia | ||
2021-07-24 | Australia | Victoria | 20903 | 820 | 19904 | 179 | -37.8136 | 144.9631 | 2021-07-25 04:22:12 | Victoria, Australia | ||
2021-07-23 | Australia | Victoria | 20891 | 820 | 19902 | 169 | -37.8136 | 144.9631 | 2021-07-24 00:21:36 | Victoria, Australia | ||
2021-07-22 | Australia | Victoria | 20879 | 820 | 19901 | 158 | -37.8136 | 144.9631 | 2021-07-23 04:21:29 | Victoria, Australia | ||
2021-07-21 | Australia | Victoria | 20865 | 820 | 19899 | 146 | -37.8136 | 144.9631 | 2021-07-22 04:21:19 | Victoria, Australia | ||
2021-07-20 | Australia | Victoria | 20837 | 820 | 19899 | 118 | -37.8136 | 144.9631 | 2021-07-21 04:21:40 | Victoria, Australia | ||
2021-07-19 | Australia | Victoria | 20813 | 820 | 19898 | 95 | -37.8136 | 144.9631 | 2021-07-20 04:21:48 | Victoria, Australia | ||
2021-07-18 | Australia | Victoria | 20799 | 820 | 19898 | 81 | -37.8136 | 144.9631 | 2021-07-19 04:21:24 | Victoria, Australia | ||
2021-07-17 | Australia | Victoria | 20785 | 820 | 19895 | 70 | -37.8136 | 144.9631 | 2021-07-18 04:22:07 | Victoria, Australia | ||
2021-07-16 | Australia | Victoria | 20767 | 820 | 19893 | 54 | -37.8136 | 144.9631 | 2021-07-17 04:22:22 | Victoria, Australia | ||
2021-07-15 | Australia | Victoria | 20748 | 820 | 19892 | 36 | -37.8136 | 144.9631 | 2021-07-16 04:21:22 | Victoria, Australia | ||
2021-07-14 | Australia | Victoria | 20737 | 820 | 19891 | 26 | -37.8136 | 144.9631 | 2021-07-15 04:21:48 | Victoria, Australia | ||
2021-07-13 | Australia | Victoria | 20727 | 820 | 19893 | 14 | -37.8136 | 144.9631 | 2021-07-14 04:21:35 | Victoria, Australia | ||
2021-07-12 | Australia | Victoria | 20725 | 820 | 19890 | 15 | -37.8136 | 144.9631 | 2021-07-13 04:21:18 | Victoria, Australia | ||
2021-07-11 | Australia | Victoria | 20722 | 820 | 19888 | 14 | -37.8136 | 144.9631 | 2021-07-12 04:21:34 | Victoria, Australia | ||
2021-07-10 | Australia | Victoria | 20722 | 820 | 19887 | 15 | -37.8136 | 144.9631 | 2021-07-11 04:21:43 | Victoria, Australia | ||
2021-07-09 | Australia | Victoria | 20722 | 820 | 19884 | 18 | -37.8136 | 144.9631 | 2021-07-10 04:21:25 | Victoria, Australia | ||
2021-07-08 | Australia | Victoria | 20719 | 820 | 19883 | 16 | -37.8136 | 144.9631 | 2021-07-09 04:21:21 | Victoria, Australia | ||
2021-07-07 | Australia | Victoria | 20718 | 820 | 19882 | 16 | -37.8136 | 144.9631 | 2021-07-08 04:21:26 | Victoria, Australia | ||
2021-07-06 | Australia | Victoria | 20718 | 820 | 19879 | 19 | -37.8136 | 144.9631 | 2021-07-07 04:21:20 | Victoria, Australia | ||
2021-07-05 | Australia | Victoria | 20718 | 820 | 19878 | 20 | -37.8136 | 144.9631 | 2021-07-06 04:21:32 | Victoria, Australia | ||
2021-07-04 | Australia | Victoria | 20716 | 820 | 19878 | 18 | -37.8136 | 144.9631 | 2021-07-05 04:21:28 | Victoria, Australia | ||
2021-07-03 | Australia | Victoria | 20714 | 820 | 19876 | 18 | -37.8136 | 144.9631 | 2021-07-04 04:21:38 | Victoria, Australia | ||
2021-07-02 | Australia | Victoria | 20713 | 820 | 19868 | 25 | -37.8136 | 144.9631 | 2021-07-03 04:21:37 | Victoria, Australia | ||
2021-07-01 | Australia | Victoria | 20715 | 820 | 19866 | 29 | -37.8136 | 144.9631 | 2021-07-02 04:21:47 | Victoria, Australia | ||
2021-06-30 | Australia | Victoria | 20712 | 820 | 19864 | 28 | -37.8136 | 144.9631 | 2021-07-01 04:21:19 | Victoria, Australia | ||
2021-06-29 | Australia | Victoria | 20712 | 820 | 19861 | 31 | -37.8136 | 144.9631 | 2021-06-30 04:21:41 | Victoria, Australia | ||
2021-06-28 | Australia | Victoria | 20710 | 820 | 19849 | 41 | -37.8136 | 144.9631 | 2021-06-29 04:21:28 | Victoria, Australia | ||
2021-06-27 | Australia | Victoria | 20708 | 820 | 19846 | 42 | -37.8136 | 144.9631 | 2021-06-28 04:21:29 | Victoria, Australia | ||
2021-06-26 | Australia | Victoria | 20708 | 820 | 19845 | 43 | -37.8136 | 144.9631 | 2021-06-27 04:21:39 | Victoria, Australia | ||
2021-06-25 | Australia | Victoria | 20706 | 820 | 19835 | 51 | -37.8136 | 144.9631 | 2021-06-26 04:21:43 | Victoria, Australia | ||
2021-06-24 | Australia | Victoria | 20702 | 820 | 19833 | 49 | -37.8136 | 144.9631 | 2021-06-25 04:21:33 | Victoria, Australia | ||
2021-06-23 | Australia | Victoria | 20699 | 820 | 19829 | 50 | -37.8136 | 144.9631 | 2021-06-24 04:21:55 | Victoria, Australia | ||
2021-06-22 | Australia | Victoria | 20697 | 820 | 19827 | 50 | -37.8136 | 144.9631 | 2021-06-23 04:21:46 | Victoria, Australia | ||
2021-06-21 | Australia | Victoria | 20696 | 820 | 19825 | 51 | -37.8136 | 144.9631 | 2021-06-22 04:21:34 | Victoria, Australia | ||
2021-06-20 | Australia | Victoria | 20694 | 820 | 19820 | 54 | -37.8136 | 144.9631 | 2021-06-21 04:21:41 | Victoria, Australia | ||
2021-06-19 | Australia | Victoria | 20685 | 820 | 19814 | 51 | -37.8136 | 144.9631 | 2021-06-20 04:21:48 | Victoria, Australia | ||
2021-06-18 | Australia | Victoria | 20683 | 820 | 19812 | 51 | -37.8136 | 144.9631 | 2021-06-19 04:22:33 | Victoria, Australia | ||
2021-06-17 | Australia | Victoria | 20680 | 820 | 19806 | 54 | -37.8136 | 144.9631 | 2021-06-18 04:22:16 | Victoria, Australia | ||
2021-06-16 | Australia | Victoria | 20678 | 820 | 19804 | 54 | -37.8136 | 144.9631 | 2021-06-17 04:22:36 | Victoria, Australia | ||
2021-06-15 | Australia | Victoria | 20676 | 820 | 19802 | 54 | -37.8136 | 144.9631 | 2021-06-16 04:22:32 | Victoria, Australia | ||
2021-06-14 | Australia | Victoria | 20668 | 820 | 19795 | 53 | -37.8136 | 144.9631 | 2021-06-15 04:22:22 | Victoria, Australia | ||
2021-06-13 | Australia | Victoria | 20665 | 820 | 19782 | 63 | -37.8136 | 144.9631 | 2021-06-14 04:22:46 | Victoria, Australia | ||
2021-06-12 | Australia | Victoria | 20660 | 820 | 19772 | 68 | -37.8136 | 144.9631 | 2021-06-13 04:22:44 | Victoria, Australia | ||
2021-06-11 | Australia | Victoria | 20659 | 820 | 19765 | 74 | -37.8136 | 144.9631 | 2021-06-12 04:22:22 | Victoria, Australia | ||
2021-06-10 | Australia | Victoria | 20655 | 820 | 19761 | 74 | -37.8136 | 144.9631 | 2021-06-11 04:23:20 | Victoria, Australia | ||
2021-06-09 | Australia | Victoria | 20654 | 820 | 19757 | 77 | -37.8136 | 144.9631 | 2021-06-10 04:23:17 | Victoria, Australia | ||
2021-06-08 | Australia | Victoria | 20650 | 820 | 19748 | 82 | -37.8136 | 144.9631 | 2021-06-09 04:23:31 | Victoria, Australia | ||
2021-06-07 | Australia | Victoria | 20649 | 820 | 19738 | 91 | -37.8136 | 144.9631 | 2021-06-08 04:22:35 | Victoria, Australia | ||
2021-06-06 | Australia | Victoria | 20646 | 820 | 19734 | 92 | -37.8136 | 144.9631 | 2021-06-07 04:22:51 | Victoria, Australia | ||
2021-06-05 | Australia | Victoria | 20635 | 820 | 19732 | 83 | -37.8136 | 144.9631 | 2021-06-06 04:24:03 | Victoria, Australia | ||
2021-06-04 | Australia | Victoria | 20627 | 820 | 19731 | 76 | -37.8136 | 144.9631 | 2021-06-05 04:23:03 | Victoria, Australia | ||
2021-06-03 | Australia | Victoria | 20621 | 820 | 19731 | 70 | -37.8136 | 144.9631 | 2021-06-04 04:23:37 | Victoria, Australia | ||
2021-06-02 | Australia | Victoria | 20617 | 820 | 19728 | 69 | -37.8136 | 144.9631 | 2021-06-03 04:23:32 | Victoria, Australia | ||
2021-06-01 | Australia | Victoria | 20614 | 820 | 19727 | 67 | -37.8136 | 144.9631 | 2021-06-02 04:24:34 | Victoria, Australia | ||
2021-05-31 | Australia | Victoria | 20609 | 820 | 19727 | 62 | -37.8136 | 144.9631 | 2021-06-01 04:23:09 | Victoria, Australia | ||
2021-05-30 | Australia | Victoria | 20598 | 820 | 19725 | 53 | -37.8136 | 144.9631 | 2021-05-31 03:08:59 | Victoria, Australia | ||
2021-05-29 | Australia | Victoria | 20593 | 820 | 19725 | 48 | -37.8136 | 144.9631 | 2021-05-30 04:20:55 | Victoria, Australia | ||
2021-05-28 | Australia | Victoria | 20587 | 820 | 19723 | 44 | -37.8136 | 144.9631 | 2021-05-29 04:20:41 | Victoria, Australia | ||
2021-05-27 | Australia | Victoria | 20581 | 820 | 19722 | 39 | -37.8136 | 144.9631 | 2021-05-28 04:20:36 | Victoria, Australia | ||
2021-05-26 | Australia | Victoria | 20575 | 820 | 19720 | 35 | -37.8136 | 144.9631 | 2021-05-27 04:20:59 | Victoria, Australia | ||
2021-05-25 | Australia | Victoria | 20563 | 820 | 19720 | 23 | -37.8136 | 144.9631 | 2021-05-26 04:20:35 | Victoria, Australia | ||
2021-05-24 | Australia | Victoria | 20553 | 820 | 19720 | 13 | -37.8136 | 144.9631 | 2021-05-25 04:21:08 | Victoria, Australia | ||
2021-05-23 | Australia | Victoria | 20549 | 820 | 19719 | 10 | -37.8136 | 144.9631 | 2021-05-24 04:20:53 | Victoria, Australia |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;