johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
8,420 rows where country_or_region = "Australia" sorted by confirmed
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: 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 ✖
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed ▼ | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
40299 | 40299 | 2020-03-05 | Australia | From Diamond Princess | 0 | 0 | 0 | 35.4437 | 139.638 | 2020-02-29T02:03:10 | ||||
62689 | 62689 | 2020-03-07 | Australia | From Diamond Princess | 0 | 0 | 0 | 35.4437 | 139.638 | 2020-02-29T02:03:10 | ||||
62690 | 62690 | 2020-03-07 | Australia | Northern Territory | 0 | 0 | 0 | -12.4634 | 130.8456 | 2020-03-06T04:33:03 | ||||
98956 | 98956 | 2020-03-04 | Australia | From Diamond Princess | 0 | 0 | 0 | 35.4437 | 139.638 | 2020-02-29T02:03:10 | ||||
261162 | 261162 | 2020-03-03 | Australia | From Diamond Princess | 0 | 0 | 0 | 35.4437 | 139.638 | 2020-02-29T02:03:10 | ||||
339913 | 339913 | 2020-03-21 | Australia | From Diamond Princess | 0 | 0 | 0 | 35.4437 | 139.638 | 2020-03-14T02:33:04 | ||||
562613 | 562613 | 2020-03-01 | Australia | From Diamond Princess | 0 | 0 | 0 | 35.4437 | 139.638 | 2020-02-29T02:03:10 | ||||
657942 | 657942 | 2020-03-09 | Australia | From Diamond Princess | 0 | 0 | 0 | 35.4437 | 139.638 | 2020-02-29T02:03:10 | ||||
657943 | 657943 | 2020-03-09 | Australia | Northern Territory | 0 | 0 | 0 | -12.4634 | 130.8456 | 2020-03-06T04:33:03 | ||||
864418 | 864418 | 2020-01-23 | Australia | 0 | 0 | 0 | 1/23/20 17:00 | |||||||
1152768 | 1152768 | 2020-03-02 | Australia | From Diamond Princess | 0 | 0 | 0 | 35.4437 | 139.638 | 2020-02-29T02:03:10 | ||||
1177147 | 1177147 | 2020-03-18 | Australia | From Diamond Princess | 0 | 0 | 0 | 35.4437 | 139.638 | 2020-03-14T02:33:04 | ||||
1463715 | 1463715 | 2020-03-15 | Australia | From Diamond Princess | 0 | 0 | 0 | 35.4437 | 139.638 | 2020-03-14T02:33:04 | ||||
1527149 | 1527149 | 2020-03-19 | Australia | From Diamond Princess | 0 | 0 | 0 | 35.4437 | 139.638 | 2020-03-14T02:33:04 | ||||
1527447 | 1527447 | 2020-03-08 | Australia | From Diamond Princess | 0 | 0 | 0 | 35.4437 | 139.638 | 2020-02-29T02:03:10 | ||||
1527448 | 1527448 | 2020-03-08 | Australia | Northern Territory | 0 | 0 | 0 | -12.4634 | 130.8456 | 2020-03-06T04:33:03 | ||||
2111331 | 2111331 | 2020-03-14 | Australia | From Diamond Princess | 0 | 0 | 0 | 35.4437 | 139.638 | 2020-03-14T02:33:04 | ||||
2127634 | 2127634 | 2020-03-11 | Australia | From Diamond Princess | 0 | 0 | 0 | 35.4437 | 139.638 | 2020-02-29T02:03:10 | ||||
2255380 | 2255380 | 2020-03-16 | Australia | From Diamond Princess | 0 | 0 | 0 | 35.4437 | 139.638 | 2020-03-14T02:33:04 | ||||
2283069 | 2283069 | 2020-03-12 | Australia | From Diamond Princess | 0 | 0 | 0 | 35.4437 | 139.638 | 2020-02-29T02:03:10 | ||||
2910601 | 2910601 | 2020-03-22 | Australia | External territories | 0 | 0 | 0 | 0 | 3/22/20 23:48 | External territories, Australia | ||||
2910602 | 2910602 | 2020-03-22 | Australia | Jervis Bay Territory | 0 | 0 | 0 | 0 | 3/22/20 23:48 | Jervis Bay Territory, Australia | ||||
3177668 | 3177668 | 2020-03-06 | Australia | From Diamond Princess | 0 | 0 | 0 | 35.4437 | 139.638 | 2020-02-29T02:03:10 | ||||
3177669 | 3177669 | 2020-03-06 | Australia | Northern Territory | 0 | 0 | 0 | -12.4634 | 130.8456 | 2020-03-06T04:33:03 | ||||
3205896 | 3205896 | 2020-02-29 | Australia | From Diamond Princess | 0 | 0 | 0 | 35.4437 | 139.638 | 2020-02-29T02:03:10 | ||||
3734205 | 3734205 | 2020-03-20 | Australia | From Diamond Princess | 0 | 0 | 0 | 35.4437 | 139.638 | 2020-03-14T02:33:04 | ||||
3753005 | 3753005 | 2020-03-10 | Australia | From Diamond Princess | 0 | 0 | 0 | 35.4437 | 139.638 | 2020-02-29T02:03:10 | ||||
3765349 | 3765349 | 2020-03-13 | Australia | From Diamond Princess | 0 | 0 | 0 | 35.4437 | 139.638 | 2020-03-11T20:00:00 | ||||
3891575 | 3891575 | 2020-03-17 | Australia | From Diamond Princess | 0 | 0 | 0 | 35.4437 | 139.638 | 2020-03-14T02:33:04 | ||||
40258 | 40258 | 2020-03-05 | Australia | Northern Territory | 1 | 0 | 0 | -12.4634 | 130.8456 | 2020-03-04T19:43:02 | ||||
40259 | 40259 | 2020-03-05 | Australia | Tasmania | 1 | 0 | 0 | -41.4545 | 145.9707 | 2020-03-02T20:53:02 | ||||
62625 | 62625 | 2020-03-07 | Australia | Tasmania | 1 | 0 | 0 | -41.4545 | 145.9707 | 2020-03-02T20:53:02 | ||||
98917 | 98917 | 2020-03-04 | Australia | Northern Territory | 1 | 0 | 0 | -12.4634 | 130.8456 | 2020-03-04T19:43:02 | ||||
98918 | 98918 | 2020-03-04 | Australia | Tasmania | 1 | 0 | 0 | -41.4545 | 145.9707 | 2020-03-02T20:53:02 | ||||
197887 | 197887 | 2020-01-29 | Australia | Victoria | 1 | 0 | 0 | -37.8136 | 144.9631 | 1/29/20 19:30 | ||||
261124 | 261124 | 2020-03-03 | Australia | Tasmania | 1 | 0 | 0 | -41.4545 | 145.9707 | 2020-03-02T20:53:02 | ||||
1152732 | 1152732 | 2020-03-02 | Australia | Tasmania | 1 | 0 | 0 | -41.4545 | 145.9707 | 2020-03-02T20:53:02 | ||||
1177122 | 1177122 | 2020-03-18 | Australia | Northern Territory | 1 | 0 | 0 | -12.4634 | 130.8456 | 2020-03-14T01:53:03 | ||||
1305802 | 1305802 | 2020-01-28 | Australia | Victoria | 1 | 0 | 0 | -37.8136 | 144.9631 | 1/28/20 23:00 | ||||
1463678 | 1463678 | 2020-03-15 | Australia | Australian Capital Territory | 1 | 0 | 0 | -35.4735 | 149.0124 | 2020-03-14T01:53:03 | ||||
1463679 | 1463679 | 2020-03-15 | Australia | Northern Territory | 1 | 0 | 0 | -12.4634 | 130.8456 | 2020-03-14T01:53:03 | ||||
1527128 | 1527128 | 2020-03-19 | Australia | Northern Territory | 1 | 0 | 0 | -12.4634 | 130.8456 | 2020-03-14T01:53:03 | ||||
2111299 | 2111299 | 2020-03-14 | Australia | Australian Capital Territory | 1 | 0 | 0 | -35.4735 | 149.0124 | 2020-03-14T01:53:03 | ||||
2111300 | 2111300 | 2020-03-14 | Australia | Northern Territory | 1 | 0 | 0 | -12.4634 | 130.8456 | 2020-03-14T01:53:03 | ||||
2127609 | 2127609 | 2020-03-11 | Australia | Northern Territory | 1 | 0 | 0 | -12.4634 | 130.8456 | 2020-03-10T14:13:14 | ||||
2255344 | 2255344 | 2020-03-16 | Australia | Northern Territory | 1 | 0 | 0 | -12.4634 | 130.8456 | 2020-03-14T01:53:03 | ||||
2283044 | 2283044 | 2020-03-12 | Australia | Northern Territory | 1 | 0 | 0 | -12.4634 | 130.8456 | 2020-03-10T14:13:14 | ||||
3177614 | 3177614 | 2020-03-06 | Australia | Tasmania | 1 | 0 | 0 | -41.4545 | 145.9707 | 2020-03-02T20:53:02 | ||||
3413189 | 3413189 | 2020-02-01 | Australia | South Australia | 1 | 0 | 0 | -34.9285 | 138.6007 | 2/1/2020 18:12 | ||||
3752981 | 3752981 | 2020-03-10 | Australia | Northern Territory | 1 | 0 | 0 | -12.4634 | 130.8456 | 2020-03-10T14:13:14 | ||||
3753105 | 3753105 | 2020-01-27 | Australia | Victoria | 1 | 0 | 0 | -37.8136 | 144.9631 | 1/27/20 23:59 | ||||
3765336 | 3765336 | 2020-03-13 | Australia | Australian Capital Territory | 1 | 0 | 0 | -35.4735 | 149.0124 | 2020-03-11T20:00:00 | ||||
3765422 | 3765422 | 2020-03-13 | Australia | Northern Territory | 1 | 0 | 0 | -12.4634 | 130.8456 | 2020-03-11T20:00:00 | ||||
3891547 | 3891547 | 2020-03-17 | Australia | Northern Territory | 1 | 0 | 0 | -12.4634 | 130.8456 | 2020-03-14T01:53:03 | ||||
98898 | 98898 | 2020-03-04 | Australia | Western Australia | 2 | 1 | 0 | -31.9505 | 115.8605 | 2020-03-01T02:43:03 | ||||
107077 | 107077 | 2020-02-15 | Australia | South Australia | 2 | 0 | 0 | -34.9285 | 138.6007 | 2020-02-02T22:33:07 | ||||
261103 | 261103 | 2020-03-03 | Australia | Western Australia | 2 | 1 | 0 | -31.9505 | 115.8605 | 2020-03-01T02:43:03 | ||||
479187 | 479187 | 2020-02-25 | Australia | South Australia | 2 | 0 | 2 | -34.9285 | 138.6007 | 2020-02-17T08:13:09 | ||||
562575 | 562575 | 2020-03-01 | Australia | Western Australia | 2 | 1 | 0 | -31.9505 | 115.8605 | 2020-03-01T02:43:03 | ||||
566713 | 566713 | 2020-02-06 | Australia | South Australia | 2 | 0 | 0 | -34.9285 | 138.6007 | 2020-02-02T22:33:07 | ||||
617456 | 617456 | 2020-02-27 | Australia | South Australia | 2 | 0 | 2 | -34.9285 | 138.6007 | 2020-02-17T08:13:09 | ||||
657838 | 657838 | 2020-03-09 | Australia | Tasmania | 2 | 0 | 0 | -41.4545 | 145.9707 | 2020-03-08T05:43:04 | ||||
1085680 | 1085680 | 2020-02-22 | Australia | South Australia | 2 | 0 | 2 | -34.9285 | 138.6007 | 2020-02-17T08:13:09 | ||||
1152719 | 1152719 | 2020-03-02 | Australia | Western Australia | 2 | 1 | 0 | -31.9505 | 115.8605 | 2020-03-01T02:43:03 | ||||
1192496 | 1192496 | 2020-02-14 | Australia | South Australia | 2 | 0 | 0 | -34.9285 | 138.6007 | 2020-02-02T22:33:07 | ||||
1243398 | 1243398 | 2020-02-17 | Australia | South Australia | 2 | 0 | 2 | -34.9285 | 138.6007 | 2020-02-17T08:13:09 | ||||
1366090 | 1366090 | 2020-02-08 | Australia | South Australia | 2 | 0 | 0 | -34.9285 | 138.6007 | 2020-02-02T22:33:07 | ||||
1527347 | 1527347 | 2020-03-08 | Australia | Tasmania | 2 | 0 | 0 | -41.4545 | 145.9707 | 2020-03-08T05:43:04 | ||||
1527540 | 1527540 | 2020-01-30 | Australia | Victoria | 2 | 0 | 0 | -37.8136 | 144.9631 | 1/30/20 16:00 | ||||
1559703 | 1559703 | 2020-02-13 | Australia | South Australia | 2 | 0 | 0 | -34.9285 | 138.6007 | 2020-02-02T22:33:07 | ||||
1720092 | 1720092 | 2020-02-19 | Australia | South Australia | 2 | 0 | 2 | -34.9285 | 138.6007 | 2020-02-17T08:13:09 | ||||
1783124 | 1783124 | 2020-02-18 | Australia | South Australia | 2 | 0 | 2 | -34.9285 | 138.6007 | 2020-02-17T08:13:09 | ||||
1888751 | 1888751 | 2020-02-16 | Australia | South Australia | 2 | 0 | 0 | -34.9285 | 138.6007 | 2020-02-02T22:33:07 | ||||
2091706 | 2091706 | 2020-02-05 | Australia | South Australia | 2 | 0 | 0 | -34.9285 | 138.6007 | 2020-02-02T22:33:07 | ||||
2135762 | 2135762 | 2020-02-21 | Australia | South Australia | 2 | 0 | 2 | -34.9285 | 138.6007 | 2020-02-17T08:13:09 | ||||
2255333 | 2255333 | 2020-03-16 | Australia | Australian Capital Territory | 2 | 0 | 0 | -35.4735 | 149.0124 | 2020-03-16T14:38:46 | ||||
2263501 | 2263501 | 2020-02-20 | Australia | South Australia | 2 | 0 | 2 | -34.9285 | 138.6007 | 2020-02-17T08:13:09 | ||||
2379272 | 2379272 | 2020-02-02 | Australia | Queensland | 2 | 0 | 0 | -28.0167 | 153.4 | 2020-02-02T22:33:07 | ||||
2379273 | 2379273 | 2020-02-02 | Australia | South Australia | 2 | 0 | 0 | -34.9285 | 138.6007 | 2020-02-02T22:33:07 | ||||
2509807 | 2509807 | 2020-02-26 | Australia | South Australia | 2 | 0 | 2 | -34.9285 | 138.6007 | 2020-02-17T08:13:09 | ||||
2567293 | 2567293 | 2020-02-12 | Australia | South Australia | 2 | 0 | 0 | -34.9285 | 138.6007 | 2020-02-02T22:33:07 | ||||
2860587 | 2860587 | 2020-02-03 | Australia | Queensland | 2 | 0 | 0 | -28.0167 | 153.4 | 2020-02-02T22:33:07 | ||||
2860588 | 2860588 | 2020-02-03 | Australia | South Australia | 2 | 0 | 0 | -34.9285 | 138.6007 | 2020-02-02T22:33:07 | ||||
2883972 | 2883972 | 2020-02-28 | Australia | South Australia | 2 | 0 | 2 | -34.9285 | 138.6007 | 2020-02-17T08:13:09 | ||||
3089051 | 3089051 | 2020-02-10 | Australia | South Australia | 2 | 0 | 0 | -34.9285 | 138.6007 | 2020-02-02T22:33:07 | ||||
3173391 | 3173391 | 2020-02-23 | Australia | South Australia | 2 | 0 | 2 | -34.9285 | 138.6007 | 2020-02-17T08:13:09 | ||||
3197752 | 3197752 | 2020-02-11 | Australia | South Australia | 2 | 0 | 0 | -34.9285 | 138.6007 | 2020-02-02T22:33:07 | ||||
3205857 | 3205857 | 2020-02-29 | Australia | Western Australia | 2 | 0 | 0 | -31.9505 | 115.8605 | 2020-02-29T23:13:06 | ||||
3222049 | 3222049 | 2020-02-07 | Australia | South Australia | 2 | 0 | 0 | -34.9285 | 138.6007 | 2020-02-02T22:33:07 | ||||
3362420 | 3362420 | 2020-02-09 | Australia | South Australia | 2 | 0 | 0 | -34.9285 | 138.6007 | 2020-02-02T22:33:07 | ||||
3471923 | 3471923 | 2020-02-04 | Australia | South Australia | 2 | 0 | 0 | -34.9285 | 138.6007 | 2020-02-02T22:33:07 | ||||
3551247 | 3551247 | 2020-02-24 | Australia | South Australia | 2 | 0 | 2 | -34.9285 | 138.6007 | 2020-02-17T08:13:09 | ||||
3752968 | 3752968 | 2020-03-10 | Australia | Tasmania | 2 | 0 | 0 | -41.4545 | 145.9707 | 2020-03-08T05:43:04 | ||||
3761222 | 3761222 | 2020-01-31 | Australia | Queensland | 2 | 0 | 0 | -28.0167 | 153.4 | 1/31/2020 23:59 | ||||
3891538 | 3891538 | 2020-03-17 | Australia | Australian Capital Territory | 2 | 0 | 0 | -35.4735 | 149.0124 | 2020-03-16T14:38:46 | ||||
40228 | 40228 | 2020-03-05 | Australia | Western Australia | 3 | 1 | 0 | -31.9505 | 115.8605 | 2020-03-05T17:13:35 | ||||
62585 | 62585 | 2020-03-07 | Australia | Western Australia | 3 | 1 | 0 | -31.9505 | 115.8605 | 2020-03-05T17:13:35 | ||||
261097 | 261097 | 2020-03-03 | Australia | South Australia | 3 | 0 | 2 | -34.9285 | 138.6007 | 2020-02-29T02:03:10 | ||||
339865 | 339865 | 2020-03-21 | Australia | Northern Territory | 3 | 0 | 0 | -12.4634 | 130.8456 | 2020-03-20T21:13:29 | ||||
562564 | 562564 | 2020-03-01 | Australia | South Australia | 3 | 0 | 2 | -34.9285 | 138.6007 | 2020-02-29T02:03:10 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [johns_hopkins_csse_daily_reports] ( [day] TEXT, [country_or_region] TEXT, [province_or_state] TEXT, [admin2] TEXT, [fips] TEXT, [confirmed] INTEGER, [deaths] INTEGER, [recovered] INTEGER, [active] TEXT, [latitude] TEXT, [longitude] TEXT, [last_update] TEXT, [combined_key] TEXT ); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_day] ON [johns_hopkins_csse_daily_reports] ([day]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_province_or_state] ON [johns_hopkins_csse_daily_reports] ([province_or_state]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_country_or_region] ON [johns_hopkins_csse_daily_reports] ([country_or_region]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_combined_key] ON [johns_hopkins_csse_daily_reports] ([combined_key]);