daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
8,420 rows where country_or_region = "Australia" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state 11
- New South Wales 1,068
- Victoria 1,068
- Queensland 1,065
- South Australia 1,063
- Western Australia 1,035
- Tasmania 1,033
- Northern Territory 1,031
- Australian Capital Territory 1,022
- From Diamond Princess 30
- External territories 1
- Jervis Bay Territory 1
country_or_region 1
- Australia · 8,420 ✖
day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths ▼ | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2021-04-04 | Australia | Northern Territory | 112 | 0 | 106 | 6 | -12.4634 | 130.8456 | 2021-04-05 04:20:35 | Northern Territory, Australia | ||
2020-11-27 | Australia | Northern Territory | 52 | 0 | 46 | 6 | -12.4634 | 130.8456 | 2020-11-28 05:25:50 | Northern Territory, Australia | ||
2021-06-29 | Australia | Northern Territory | 184 | 0 | 174 | 10 | -12.4634 | 130.8456 | 2021-06-30 04:21:41 | Northern Territory, Australia | ||
2021-07-28 | Australia | Northern Territory | 197 | 0 | 190 | 7 | -12.4634 | 130.8456 | 2021-07-29 04:21:33 | Northern Territory, Australia | ||
2020-07-05 | Australia | Northern Territory | 30 | 0 | 29 | 1 | -12.4634 | 130.8456 | 2020-07-06 04:33:57 | Northern Territory, Australia | ||
2020-01-26 | Australia | 4 | 0 | 0 | 1/26/20 16:00 | |||||||
2020-04-18 | Australia | Northern Territory | 28 | 0 | 9 | 19 | -12.4634 | 130.8456 | 2020-04-18 22:40:18 | Northern Territory, Australia | ||
2021-10-10 | Australia | Northern Territory | 215 | 0 | 0 | -12.4634 | 130.8456 | 2021-10-11 04:21:31 | Northern Territory, Australia | |||
2020-09-07 | Australia | Northern Territory | 33 | 0 | 33 | 0 | -12.4634 | 130.8456 | 2020-09-08 04:28:25 | Northern Territory, Australia | ||
2021-01-21 | Australia | Northern Territory | 97 | 0 | 89 | 8 | -12.4634 | 130.8456 | 2021-01-22 05:22:10 | Northern Territory, Australia | ||
2020-07-26 | Australia | Northern Territory | 31 | 0 | 30 | 1 | -12.4634 | 130.8456 | 2020-07-27 04:35:02 | Northern Territory, Australia | ||
2021-10-20 | Australia | Northern Territory | 225 | 0 | 0 | -12.4634 | 130.8456 | 2021-10-21 04:21:18 | Northern Territory, Australia | |||
2021-11-17 | Australia | Northern Territory | 245 | 0 | 0 | -12.4634 | 130.8456 | 2021-11-18 04:21:33 | Northern Territory, Australia | |||
2020-08-07 | Australia | Northern Territory | 33 | 0 | 30 | 3 | -12.4634 | 130.8456 | 2020-08-08 04:34:53 | Northern Territory, Australia | ||
2021-10-07 | Australia | Northern Territory | 213 | 0 | 0 | -12.4634 | 130.8456 | 2021-10-08 04:21:25 | Northern Territory, Australia | |||
2021-02-19 | Australia | Northern Territory | 104 | 0 | 101 | 3 | -12.4634 | 130.8456 | 2021-02-20 05:22:51 | Northern Territory, Australia | ||
2020-02-25 | Australia | From Diamond Princess | 7 | 0 | 0 | 35.4437 | 139.638 | 2020-02-22T17:03:05 | ||||
2020-02-25 | Australia | Queensland | 5 | 0 | 1 | -28.0167 | 153.4 | 2020-02-21T05:43:02 | ||||
2020-02-25 | Australia | New South Wales | 4 | 0 | 4 | -33.8688 | 151.2093 | 2020-02-13T17:53:03 | ||||
2020-02-25 | Australia | Victoria | 4 | 0 | 4 | -37.8136 | 144.9631 | 2020-02-13T17:53:03 | ||||
2020-02-25 | Australia | South Australia | 2 | 0 | 2 | -34.9285 | 138.6007 | 2020-02-17T08:13:09 | ||||
2021-07-19 | Australia | Northern Territory | 191 | 0 | 185 | 6 | -12.4634 | 130.8456 | 2021-07-20 04:21:48 | Northern Territory, Australia | ||
2021-10-14 | Australia | Northern Territory | 222 | 0 | 0 | -12.4634 | 130.8456 | 2021-10-15 04:21:26 | Northern Territory, Australia | |||
2021-11-06 | Australia | Northern Territory | 229 | 0 | 0 | -12.4634 | 130.8456 | 2021-11-07 04:21:53 | Northern Territory, Australia | |||
2021-08-14 | Australia | Northern Territory | 199 | 0 | 0 | -12.4634 | 130.8456 | 2021-08-15 04:21:41 | Northern Territory, Australia | |||
2021-08-19 | Australia | Northern Territory | 200 | 0 | 0 | -12.4634 | 130.8456 | 2021-08-20 04:21:33 | Northern Territory, Australia | |||
2020-04-21 | Australia | Northern Territory | 28 | 0 | 9 | 19 | -12.4634 | 130.8456 | 2020-04-21 23:39:09 | Northern Territory, Australia | ||
2021-06-09 | Australia | Northern Territory | 174 | 0 | 171 | 3 | -12.4634 | 130.8456 | 2021-06-10 04:23:17 | Northern Territory, Australia | ||
2020-07-04 | Australia | Northern Territory | 30 | 0 | 29 | 1 | -12.4634 | 130.8456 | 2020-07-05 04:33:46 | Northern Territory, Australia | ||
2021-02-22 | Australia | Northern Territory | 104 | 0 | 101 | 3 | -12.4634 | 130.8456 | 2021-02-23 05:23:41 | Northern Territory, Australia | ||
2021-10-27 | Australia | Northern Territory | 225 | 0 | 0 | -12.4634 | 130.8456 | 2021-10-28 04:22:08 | Northern Territory, Australia | |||
2020-09-12 | Australia | Northern Territory | 33 | 0 | 33 | 0 | -12.4634 | 130.8456 | 2020-09-13 04:30:52 | Northern Territory, Australia | ||
2020-03-01 | Australia | Queensland | 9 | 0 | 1 | -28.0167 | 153.4 | 2020-02-29T02:03:10 | ||||
2020-03-01 | Australia | Victoria | 7 | 0 | 4 | -37.8136 | 144.9631 | 2020-02-29T02:03:10 | ||||
2020-03-01 | Australia | New South Wales | 6 | 0 | 4 | -33.8688 | 151.2093 | 2020-03-01T23:33:03 | ||||
2020-03-01 | Australia | South Australia | 3 | 0 | 2 | -34.9285 | 138.6007 | 2020-02-29T02:03:10 | ||||
2020-03-01 | Australia | From Diamond Princess | 0 | 0 | 0 | 35.4437 | 139.638 | 2020-02-29T02:03:10 | ||||
2021-06-22 | Australia | Northern Territory | 177 | 0 | 174 | 3 | -12.4634 | 130.8456 | 2021-06-23 04:21:46 | Northern Territory, Australia | ||
2020-02-06 | Australia | New South Wales | 4 | 0 | 2 | -33.8688 | 151.2093 | 2020-02-06T03:13:22 | ||||
2020-02-06 | Australia | Queensland | 4 | 0 | 0 | -28.0167 | 153.4 | 2020-02-06T02:53:03 | ||||
2020-02-06 | Australia | Victoria | 4 | 0 | 0 | -37.8136 | 144.9631 | 2020-02-01T18:12:49 | ||||
2020-02-06 | Australia | South Australia | 2 | 0 | 0 | -34.9285 | 138.6007 | 2020-02-02T22:33:07 | ||||
2021-10-29 | Australia | Northern Territory | 225 | 0 | 0 | -12.4634 | 130.8456 | 2021-10-30 04:22:03 | Northern Territory, Australia | |||
2020-06-06 | Australia | Northern Territory | 29 | 0 | 29 | 0 | -12.4634 | 130.8456 | 2020-06-07 03:53:30 | Northern Territory, Australia | ||
2021-07-13 | Australia | Northern Territory | 189 | 0 | 180 | 9 | -12.4634 | 130.8456 | 2021-07-14 04:21:35 | Northern Territory, Australia | ||
2020-08-13 | Australia | Northern Territory | 33 | 0 | 31 | 2 | -12.4634 | 130.8456 | 2020-08-14 04:51:19 | Northern Territory, Australia | ||
2020-04-05 | Australia | Northern Territory | 27 | 0 | 1 | 26 | -12.4634 | 130.8456 | 2020-04-05 23:13:44 | Northern Territory, Australia | ||
2020-04-05 | Australia | South Australia | 407 | 0 | 46 | 361 | -34.9285 | 138.6007 | 2020-04-05 23:13:44 | South Australia, Australia | ||
2021-08-08 | Australia | Northern Territory | 199 | 0 | 0 | -12.4634 | 130.8456 | 2021-08-09 04:21:24 | Northern Territory, Australia | |||
2021-10-19 | Australia | Northern Territory | 225 | 0 | 0 | -12.4634 | 130.8456 | 2021-10-20 04:21:00 | Northern Territory, Australia | |||
2021-09-23 | Australia | Northern Territory | 208 | 0 | 0 | -12.4634 | 130.8456 | 2021-09-24 04:21:44 | Northern Territory, Australia | |||
2021-04-09 | Australia | Northern Territory | 112 | 0 | 107 | 5 | -12.4634 | 130.8456 | 2021-04-10 04:20:59 | Northern Territory, Australia | ||
2020-08-29 | Australia | Northern Territory | 33 | 0 | 33 | 0 | -12.4634 | 130.8456 | 2020-08-30 04:28:22 | Northern Territory, Australia | ||
2021-02-08 | Australia | Northern Territory | 102 | 0 | 98 | 4 | -12.4634 | 130.8456 | 2021-02-09 05:23:30 | Northern Territory, Australia | ||
2020-02-27 | Australia | From Diamond Princess | 8 | 0 | 0 | 35.4437 | 139.638 | 2020-02-27T03:33:06 | ||||
2020-02-27 | Australia | Queensland | 5 | 0 | 1 | -28.0167 | 153.4 | 2020-02-21T05:43:02 | ||||
2020-02-27 | Australia | New South Wales | 4 | 0 | 4 | -33.8688 | 151.2093 | 2020-02-13T17:53:03 | ||||
2020-02-27 | Australia | Victoria | 4 | 0 | 4 | -37.8136 | 144.9631 | 2020-02-13T17:53:03 | ||||
2020-02-27 | Australia | South Australia | 2 | 0 | 2 | -34.9285 | 138.6007 | 2020-02-17T08:13:09 | ||||
2021-07-10 | Australia | Northern Territory | 188 | 0 | 178 | 10 | -12.4634 | 130.8456 | 2021-07-11 04:21:43 | Northern Territory, Australia | ||
2021-10-13 | Australia | Northern Territory | 222 | 0 | 0 | -12.4634 | 130.8456 | 2021-10-14 04:21:29 | Northern Territory, Australia | |||
2021-03-31 | Australia | Northern Territory | 108 | 0 | 106 | 2 | -12.4634 | 130.8456 | 2021-04-01 04:27:05 | Northern Territory, Australia | ||
2021-09-07 | Australia | Northern Territory | 203 | 0 | 0 | -12.4634 | 130.8456 | 2021-09-08 04:21:31 | Northern Territory, Australia | |||
2021-05-05 | Australia | Northern Territory | 167 | 0 | 137 | 30 | -12.4634 | 130.8456 | 2021-05-06 04:20:38 | Northern Territory, Australia | ||
2021-08-09 | Australia | Northern Territory | 199 | 0 | 0 | -12.4634 | 130.8456 | 2021-08-10 04:21:27 | Northern Territory, Australia | |||
2021-10-22 | Australia | Northern Territory | 225 | 0 | 0 | -12.4634 | 130.8456 | 2021-10-23 04:21:32 | Northern Territory, Australia | |||
2020-03-09 | Australia | Queensland | 15 | 0 | 8 | -28.0167 | 153.4 | 2020-03-08T05:43:04 | ||||
2020-03-09 | Australia | Victoria | 15 | 0 | 7 | -37.8136 | 144.9631 | 2020-03-09T18:33:03 | ||||
2020-03-09 | Australia | South Australia | 7 | 0 | 2 | -34.9285 | 138.6007 | 2020-03-06T04:23:08 | ||||
2020-03-09 | Australia | Tasmania | 2 | 0 | 0 | -41.4545 | 145.9707 | 2020-03-08T05:43:04 | ||||
2020-03-09 | Australia | From Diamond Princess | 0 | 0 | 0 | 35.4437 | 139.638 | 2020-02-29T02:03:10 | ||||
2020-03-09 | Australia | Northern Territory | 0 | 0 | 0 | -12.4634 | 130.8456 | 2020-03-06T04:33:03 | ||||
2020-08-11 | Australia | Northern Territory | 33 | 0 | 31 | 2 | -12.4634 | 130.8456 | 2020-08-12 04:27:29 | Northern Territory, Australia | ||
2020-09-16 | Australia | Northern Territory | 33 | 0 | 33 | 0 | -12.4634 | 130.8456 | 2020-09-17 04:22:00 | Northern Territory, Australia | ||
2020-11-23 | Australia | Northern Territory | 47 | 0 | 40 | 7 | -12.4634 | 130.8456 | 2020-11-24 05:27:31 | Northern Territory, Australia | ||
2021-10-24 | Australia | Northern Territory | 225 | 0 | 0 | -12.4634 | 130.8456 | 2021-10-25 04:22:31 | Northern Territory, Australia | |||
2021-11-13 | Australia | Northern Territory | 232 | 0 | 0 | -12.4634 | 130.8456 | 2021-11-14 04:21:31 | Northern Territory, Australia | |||
2021-11-04 | Australia | Northern Territory | 227 | 0 | 0 | -12.4634 | 130.8456 | 2021-11-05 04:21:54 | Northern Territory, Australia | |||
2021-03-16 | Australia | Northern Territory | 106 | 0 | 105 | 1 | -12.4634 | 130.8456 | 2021-03-17 05:25:07 | Northern Territory, Australia | ||
2021-09-29 | Australia | Northern Territory | 211 | 0 | 0 | -12.4634 | 130.8456 | 2021-09-30 04:21:20 | Northern Territory, Australia | |||
2021-11-12 | Australia | Northern Territory | 231 | 0 | 0 | -12.4634 | 130.8456 | 2021-11-13 04:21:38 | Northern Territory, Australia | |||
2021-11-20 | Australia | Northern Territory | 262 | 0 | 0 | -12.4634 | 130.8456 | 2021-11-21 04:22:13 | Northern Territory, Australia | |||
2021-05-22 | Australia | Northern Territory | 171 | 0 | 165 | 6 | -12.4634 | 130.8456 | 2021-05-23 04:20:51 | Northern Territory, Australia | ||
2020-06-12 | Australia | Northern Territory | 29 | 0 | 29 | 0 | -12.4634 | 130.8456 | 2020-06-13 03:33:14 | Northern Territory, Australia | ||
2020-12-02 | Australia | Northern Territory | 59 | 0 | 46 | 13 | -12.4634 | 130.8456 | 2020-12-03 05:28:22 | Northern Territory, Australia | ||
2021-02-20 | Australia | Northern Territory | 104 | 0 | 101 | 3 | -12.4634 | 130.8456 | 2021-02-21 05:24:33 | Northern Territory, Australia | ||
2020-08-01 | Australia | Northern Territory | 33 | 0 | 30 | 3 | -12.4634 | 130.8456 | 2020-08-02 04:34:47 | Northern Territory, Australia | ||
2020-10-28 | Australia | Northern Territory | 37 | 0 | 33 | 4 | -12.4634 | 130.8456 | 2020-10-29 04:24:49 | Northern Territory, Australia | ||
2021-11-26 | Australia | Northern Territory | 283 | 0 | 0 | -12.4634 | 130.8456 | 2021-11-27 04:22:45 | Northern Territory, Australia | |||
2020-10-18 | Australia | Northern Territory | 33 | 0 | 33 | 0 | -12.4634 | 130.8456 | 2020-10-19 04:24:16 | Northern Territory, Australia | ||
2020-12-29 | Australia | Northern Territory | 74 | 0 | 67 | 7 | -12.4634 | 130.8456 | 2020-12-30 05:22:34 | Northern Territory, Australia | ||
2021-10-23 | Australia | Northern Territory | 225 | 0 | 0 | -12.4634 | 130.8456 | 2021-10-24 04:21:22 | Northern Territory, Australia | |||
2021-01-12 | Australia | Northern Territory | 91 | 0 | 74 | 17 | -12.4634 | 130.8456 | 2021-01-13 05:22:15 | Northern Territory, Australia | ||
2021-07-08 | Australia | Northern Territory | 186 | 0 | 177 | 9 | -12.4634 | 130.8456 | 2021-07-09 04:21:21 | Northern Territory, Australia | ||
2020-10-15 | Australia | Northern Territory | 33 | 0 | 33 | 0 | -12.4634 | 130.8456 | 2020-10-16 04:24:01 | Northern Territory, Australia | ||
2021-02-04 | Australia | Northern Territory | 99 | 0 | 98 | 1 | -12.4634 | 130.8456 | 2021-02-05 05:22:38 | Northern Territory, Australia | ||
2020-06-01 | Australia | Northern Territory | 29 | 0 | 29 | 0 | -12.4634 | 130.8456 | 2020-06-02 02:33:08 | Northern Territory, Australia | ||
2020-03-27 | Australia | Australian Capital Territory | 62 | 0 | 1 | 61 | -35.4735 | 149.0124 | 2020-03-27 23:27:48 | Australian Capital Territory, Australia | ||
2020-03-27 | Australia | Northern Territory | 12 | 0 | 0 | 12 | -12.4634 | 130.8456 | 2020-03-27 23:27:48 | Northern Territory, Australia | ||
2020-03-27 | Australia | South Australia | 257 | 0 | 6 | 251 | -34.9285 | 138.6007 | 2020-03-27 23:27:48 | South Australia, Australia |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;