daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
8,420 rows where country_or_region = "Australia" sorted by combined_key
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: longitude, combined_key, day (date), last_update (date)
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 ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2020-03-05 | Australia | New South Wales | 22 | 1 | 4 | -33.8688 | 151.2093 | 2020-03-04T20:43:03 | ||||
2020-03-05 | Australia | Queensland | 13 | 0 | 8 | -28.0167 | 153.4 | 2020-03-05T17:33:06 | ||||
2020-03-05 | Australia | Victoria | 10 | 0 | 7 | -37.8136 | 144.9631 | 2020-03-05T18:33:03 | ||||
2020-03-05 | Australia | South Australia | 5 | 0 | 2 | -34.9285 | 138.6007 | 2020-03-04T21:03:07 | ||||
2020-03-05 | Australia | Western Australia | 3 | 1 | 0 | -31.9505 | 115.8605 | 2020-03-05T17:13:35 | ||||
2020-03-05 | Australia | Northern Territory | 1 | 0 | 0 | -12.4634 | 130.8456 | 2020-03-04T19:43:02 | ||||
2020-03-05 | Australia | Tasmania | 1 | 0 | 0 | -41.4545 | 145.9707 | 2020-03-02T20:53:02 | ||||
2020-03-05 | Australia | From Diamond Princess | 0 | 0 | 0 | 35.4437 | 139.638 | 2020-02-29T02:03:10 | ||||
2020-03-07 | Australia | New South Wales | 28 | 1 | 4 | -33.8688 | 151.2093 | 2020-03-07T02:03:30 | ||||
2020-03-07 | Australia | Queensland | 13 | 0 | 8 | -28.0167 | 153.4 | 2020-03-05T17:33:06 | ||||
2020-03-07 | Australia | Victoria | 11 | 0 | 7 | -37.8136 | 144.9631 | 2020-03-07T02:03:30 | ||||
2020-03-07 | Australia | South Australia | 7 | 0 | 2 | -34.9285 | 138.6007 | 2020-03-06T04:23:08 | ||||
2020-03-07 | Australia | Western Australia | 3 | 1 | 0 | -31.9505 | 115.8605 | 2020-03-05T17:13:35 | ||||
2020-03-07 | Australia | Tasmania | 1 | 0 | 0 | -41.4545 | 145.9707 | 2020-03-02T20:53:02 | ||||
2020-03-07 | Australia | From Diamond Princess | 0 | 0 | 0 | 35.4437 | 139.638 | 2020-02-29T02:03:10 | ||||
2020-03-07 | Australia | Northern Territory | 0 | 0 | 0 | -12.4634 | 130.8456 | 2020-03-06T04:33:03 | ||||
2020-03-04 | Australia | New South Wales | 22 | 1 | 4 | -33.8688 | 151.2093 | 2020-03-04T20:43:03 | ||||
2020-03-04 | Australia | Queensland | 11 | 0 | 1 | -28.0167 | 153.4 | 2020-03-03T15:23:03 | ||||
2020-03-04 | Australia | Victoria | 10 | 0 | 4 | -37.8136 | 144.9631 | 2020-03-04T12:43:03 | ||||
2020-03-04 | Australia | South Australia | 5 | 0 | 2 | -34.9285 | 138.6007 | 2020-03-04T21:03:07 | ||||
2020-03-04 | Australia | Western Australia | 2 | 1 | 0 | -31.9505 | 115.8605 | 2020-03-01T02:43:03 | ||||
2020-03-04 | Australia | Northern Territory | 1 | 0 | 0 | -12.4634 | 130.8456 | 2020-03-04T19:43:02 | ||||
2020-03-04 | Australia | Tasmania | 1 | 0 | 0 | -41.4545 | 145.9707 | 2020-03-02T20:53:02 | ||||
2020-03-04 | Australia | From Diamond Princess | 0 | 0 | 0 | 35.4437 | 139.638 | 2020-02-29T02:03:10 | ||||
2020-02-15 | Australia | Queensland | 5 | 0 | 0 | -28.0167 | 153.4 | 2020-02-09T19:33:02 | ||||
2020-02-15 | Australia | New South Wales | 4 | 0 | 4 | -33.8688 | 151.2093 | 2020-02-13T17:53:03 | ||||
2020-02-15 | Australia | Victoria | 4 | 0 | 4 | -37.8136 | 144.9631 | 2020-02-13T17:53:03 | ||||
2020-02-15 | Australia | South Australia | 2 | 0 | 0 | -34.9285 | 138.6007 | 2020-02-02T22:33:07 | ||||
2020-01-29 | Australia | New South Wales | 4 | 0 | 0 | -33.8688 | 151.2093 | 1/29/20 19:30 | ||||
2020-01-29 | Australia | Victoria | 1 | 0 | 0 | -37.8136 | 144.9631 | 1/29/20 19:30 | ||||
2020-03-03 | Australia | New South Wales | 13 | 0 | 4 | -33.8688 | 151.2093 | 2020-03-03T15:13:26 | ||||
2020-03-03 | Australia | Queensland | 11 | 0 | 1 | -28.0167 | 153.4 | 2020-03-03T15:23:03 | ||||
2020-03-03 | Australia | Victoria | 9 | 0 | 4 | -37.8136 | 144.9631 | 2020-03-02T00:53:03 | ||||
2020-03-03 | Australia | South Australia | 3 | 0 | 2 | -34.9285 | 138.6007 | 2020-02-29T02:03:10 | ||||
2020-03-03 | Australia | Western Australia | 2 | 1 | 0 | -31.9505 | 115.8605 | 2020-03-01T02:43:03 | ||||
2020-03-03 | Australia | Tasmania | 1 | 0 | 0 | -41.4545 | 145.9707 | 2020-03-02T20:53:02 | ||||
2020-03-03 | Australia | From Diamond Princess | 0 | 0 | 0 | 35.4437 | 139.638 | 2020-02-29T02:03:10 | ||||
2020-03-21 | Australia | New South Wales | 436 | 6 | 4 | -33.8688 | 151.2093 | 2020-03-21T13:13:35 | ||||
2020-03-21 | Australia | Victoria | 229 | 0 | 8 | -37.8136 | 144.9631 | 2020-03-21T13:13:35 | ||||
2020-03-21 | Australia | Queensland | 221 | 0 | 8 | -28.0167 | 153.4 | 2020-03-21T13:13:35 | ||||
2020-03-21 | Australia | Western Australia | 90 | 1 | 0 | -31.9505 | 115.8605 | 2020-03-21T13:13:35 | ||||
2020-03-21 | Australia | South Australia | 67 | 0 | 3 | -34.9285 | 138.6007 | 2020-03-21T13:13:35 | ||||
2020-03-21 | Australia | Tasmania | 16 | 0 | 3 | -41.4545 | 145.9707 | 2020-03-21T13:13:35 | ||||
2020-03-21 | Australia | Australian Capital Territory | 9 | 0 | 0 | -35.4735 | 149.0124 | 2020-03-21T13:13:35 | ||||
2020-03-21 | Australia | Northern Territory | 3 | 0 | 0 | -12.4634 | 130.8456 | 2020-03-20T21:13:29 | ||||
2020-03-21 | Australia | From Diamond Princess | 0 | 0 | 0 | 35.4437 | 139.638 | 2020-03-14T02:33:04 | ||||
2020-01-26 | Australia | 4 | 0 | 0 | 1/26/20 16:00 | |||||||
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 | ||||
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 | Western Australia | 2 | 1 | 0 | -31.9505 | 115.8605 | 2020-03-01T02:43:03 | ||||
2020-03-01 | Australia | From Diamond Princess | 0 | 0 | 0 | 35.4437 | 139.638 | 2020-02-29T02:03:10 | ||||
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 | ||||
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 | ||||
2020-03-09 | Australia | New South Wales | 48 | 3 | 4 | -33.8688 | 151.2093 | 2020-03-09T18:53:13 | ||||
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 | Western Australia | 4 | 1 | 0 | -31.9505 | 115.8605 | 2020-03-09T18:33:03 | ||||
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-01-23 | Australia | 0 | 0 | 0 | 1/23/20 17:00 | |||||||
2020-02-22 | Australia | From Diamond Princess | 7 | 0 | 0 | 35.4437 | 139.638 | 2020-02-22T17:03:05 | ||||
2020-02-22 | Australia | Queensland | 5 | 0 | 1 | -28.0167 | 153.4 | 2020-02-21T05:43:02 | ||||
2020-02-22 | Australia | New South Wales | 4 | 0 | 4 | -33.8688 | 151.2093 | 2020-02-13T17:53:03 | ||||
2020-02-22 | Australia | Victoria | 4 | 0 | 4 | -37.8136 | 144.9631 | 2020-02-13T17:53:03 | ||||
2020-02-22 | Australia | South Australia | 2 | 0 | 2 | -34.9285 | 138.6007 | 2020-02-17T08:13:09 | ||||
2020-03-02 | Australia | Queensland | 9 | 0 | 1 | -28.0167 | 153.4 | 2020-02-29T02:03:10 | ||||
2020-03-02 | Australia | Victoria | 9 | 0 | 4 | -37.8136 | 144.9631 | 2020-03-02T00:53:03 | ||||
2020-03-02 | Australia | New South Wales | 6 | 0 | 4 | -33.8688 | 151.2093 | 2020-03-01T23:33:03 | ||||
2020-03-02 | Australia | South Australia | 3 | 0 | 2 | -34.9285 | 138.6007 | 2020-02-29T02:03:10 | ||||
2020-03-02 | Australia | Western Australia | 2 | 1 | 0 | -31.9505 | 115.8605 | 2020-03-01T02:43:03 | ||||
2020-03-02 | Australia | Tasmania | 1 | 0 | 0 | -41.4545 | 145.9707 | 2020-03-02T20:53:02 | ||||
2020-03-02 | Australia | From Diamond Princess | 0 | 0 | 0 | 35.4437 | 139.638 | 2020-02-29T02:03:10 | ||||
2020-03-18 | Australia | New South Wales | 267 | 5 | 4 | -33.8688 | 151.2093 | 2020-03-18T12:13:09 | ||||
2020-03-18 | Australia | Victoria | 121 | 0 | 8 | -37.8136 | 144.9631 | 2020-03-18T12:13:09 | ||||
2020-03-18 | Australia | Queensland | 94 | 0 | 8 | -28.0167 | 153.4 | 2020-03-18T11:53:04 | ||||
2020-03-18 | Australia | South Australia | 37 | 0 | 3 | -34.9285 | 138.6007 | 2020-03-18T11:53:04 | ||||
2020-03-18 | Australia | Western Australia | 35 | 1 | 0 | -31.9505 | 115.8605 | 2020-03-18T12:13:10 | ||||
2020-03-18 | Australia | Tasmania | 10 | 0 | 0 | -41.4545 | 145.9707 | 2020-03-18T11:53:04 | ||||
2020-03-18 | Australia | Australian Capital Territory | 3 | 0 | 0 | -35.4735 | 149.0124 | 2020-03-18T11:53:04 | ||||
2020-03-18 | Australia | Northern Territory | 1 | 0 | 0 | -12.4634 | 130.8456 | 2020-03-14T01:53:03 | ||||
2020-03-18 | Australia | From Diamond Princess | 0 | 0 | 0 | 35.4437 | 139.638 | 2020-03-14T02:33:04 | ||||
2020-02-14 | Australia | Queensland | 5 | 0 | 0 | -28.0167 | 153.4 | 2020-02-09T19:33:02 | ||||
2020-02-14 | Australia | New South Wales | 4 | 0 | 4 | -33.8688 | 151.2093 | 2020-02-13T17:53:03 | ||||
2020-02-14 | Australia | Victoria | 4 | 0 | 4 | -37.8136 | 144.9631 | 2020-02-13T17:53:03 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;