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 day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state 11
- New South Wales 625
- Victoria 625
- Queensland 622
- South Australia 620
- Western Australia 592
- Tasmania 590
- Northern Territory 588
- Australian Capital Territory 579
- From Diamond Princess 30
- External territories 1
- Jervis Bay Territory 1
country_or_region 1
- Australia · 4,876 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1491281 | 1491281 | 2021-10-12 | Australia | Australian Capital Territory | 1437 | 9 | 0 | -35.4735 | 149.0124 | 2021-10-13 04:20:51 | Australian Capital Territory, Australia | |||
1491282 | 1491282 | 2021-10-12 | Australia | New South Wales | 69993 | 502 | 0 | -33.8688 | 151.2093 | 2021-10-13 04:20:51 | New South Wales, Australia | |||
1491283 | 1491283 | 2021-10-12 | Australia | Northern Territory | 216 | 0 | 0 | -12.4634 | 130.8456 | 2021-10-13 04:20:51 | Northern Territory, Australia | |||
1491284 | 1491284 | 2021-10-12 | Australia | Queensland | 2067 | 7 | 0 | -27.4698 | 153.0251 | 2021-10-13 04:20:51 | Queensland, Australia | |||
1491285 | 1491285 | 2021-10-12 | Australia | South Australia | 914 | 4 | 0 | -34.9285 | 138.6007 | 2021-10-13 04:20:51 | South Australia, Australia | |||
1491286 | 1491286 | 2021-10-12 | Australia | Tasmania | 236 | 13 | 0 | -42.8821 | 147.3272 | 2021-10-13 04:20:51 | Tasmania, Australia | |||
1491287 | 1491287 | 2021-10-12 | Australia | Victoria | 57470 | 934 | 0 | -37.8136 | 144.9631 | 2021-10-13 04:20:51 | Victoria, Australia | |||
1491288 | 1491288 | 2021-10-12 | Australia | Western Australia | 1111 | 9 | 0 | -31.9505 | 115.8605 | 2021-10-13 04:20:51 | Western Australia, Australia | |||
3007014 | 3007014 | 2021-10-11 | Australia | Australian Capital Territory | 1386 | 9 | 0 | -35.4735 | 149.0124 | 2021-10-12 04:21:09 | Australian Capital Territory, Australia | |||
3007015 | 3007015 | 2021-10-11 | Australia | New South Wales | 69552 | 498 | 0 | -33.8688 | 151.2093 | 2021-10-12 04:21:09 | New South Wales, Australia | |||
3007016 | 3007016 | 2021-10-11 | Australia | Northern Territory | 215 | 0 | 0 | -12.4634 | 130.8456 | 2021-10-12 04:21:09 | Northern Territory, Australia | |||
3007017 | 3007017 | 2021-10-11 | Australia | Queensland | 2067 | 7 | 0 | -27.4698 | 153.0251 | 2021-10-12 04:21:09 | Queensland, Australia | |||
3007018 | 3007018 | 2021-10-11 | Australia | South Australia | 913 | 4 | 0 | -34.9285 | 138.6007 | 2021-10-12 04:21:09 | South Australia, Australia | |||
3007019 | 3007019 | 2021-10-11 | Australia | Tasmania | 236 | 13 | 0 | -42.8821 | 147.3272 | 2021-10-12 04:21:09 | Tasmania, Australia | |||
3007020 | 3007020 | 2021-10-11 | Australia | Victoria | 55936 | 921 | 0 | -37.8136 | 144.9631 | 2021-10-12 04:21:09 | Victoria, Australia | |||
3007021 | 3007021 | 2021-10-11 | Australia | Western Australia | 1110 | 9 | 0 | -31.9505 | 115.8605 | 2021-10-12 04:21:09 | Western Australia, Australia | |||
423030 | 423030 | 2021-10-10 | Australia | Australian Capital Territory | 1358 | 9 | 0 | -35.4735 | 149.0124 | 2021-10-11 04:21:31 | Australian Capital Territory, Australia | |||
423031 | 423031 | 2021-10-10 | Australia | New South Wales | 69205 | 493 | 0 | -33.8688 | 151.2093 | 2021-10-11 04:21:31 | New South Wales, Australia | |||
423032 | 423032 | 2021-10-10 | Australia | Northern Territory | 215 | 0 | 0 | -12.4634 | 130.8456 | 2021-10-11 04:21:31 | Northern Territory, Australia | |||
423033 | 423033 | 2021-10-10 | Australia | Queensland | 2063 | 7 | 0 | -27.4698 | 153.0251 | 2021-10-11 04:21:31 | Queensland, Australia | |||
423034 | 423034 | 2021-10-10 | Australia | South Australia | 910 | 4 | 0 | -34.9285 | 138.6007 | 2021-10-11 04:21:31 | South Australia, Australia | |||
423035 | 423035 | 2021-10-10 | Australia | Tasmania | 236 | 13 | 0 | -42.8821 | 147.3272 | 2021-10-11 04:21:31 | Tasmania, Australia | |||
423036 | 423036 | 2021-10-10 | Australia | Victoria | 54470 | 913 | 0 | -37.8136 | 144.9631 | 2021-10-11 04:21:31 | Victoria, Australia | |||
423037 | 423037 | 2021-10-10 | Australia | Western Australia | 1110 | 9 | 0 | -31.9505 | 115.8605 | 2021-10-11 04:21:31 | Western Australia, Australia | |||
2875887 | 2875887 | 2021-10-09 | Australia | Australian Capital Territory | 1326 | 9 | 0 | -35.4735 | 149.0124 | 2021-10-10 04:21:38 | Australian Capital Territory, Australia | |||
2875888 | 2875888 | 2021-10-09 | Australia | New South Wales | 68712 | 485 | 0 | -33.8688 | 151.2093 | 2021-10-10 04:21:38 | New South Wales, Australia | |||
2875889 | 2875889 | 2021-10-09 | Australia | Northern Territory | 214 | 0 | 0 | -12.4634 | 130.8456 | 2021-10-10 04:21:38 | Northern Territory, Australia | |||
2875890 | 2875890 | 2021-10-09 | Australia | Queensland | 2062 | 7 | 0 | -27.4698 | 153.0251 | 2021-10-10 04:21:38 | Queensland, Australia | |||
2875891 | 2875891 | 2021-10-09 | Australia | South Australia | 909 | 4 | 0 | -34.9285 | 138.6007 | 2021-10-10 04:21:38 | South Australia, Australia | |||
2875892 | 2875892 | 2021-10-09 | Australia | Tasmania | 236 | 13 | 0 | -42.8821 | 147.3272 | 2021-10-10 04:21:38 | Tasmania, Australia | |||
2875893 | 2875893 | 2021-10-09 | Australia | Victoria | 52902 | 905 | 0 | -37.8136 | 144.9631 | 2021-10-10 04:21:38 | Victoria, Australia | |||
2875894 | 2875894 | 2021-10-09 | Australia | Western Australia | 1110 | 9 | 0 | -31.9505 | 115.8605 | 2021-10-10 04:21:38 | Western Australia, Australia | |||
2959053 | 2959053 | 2021-10-08 | Australia | Australian Capital Territory | 1296 | 9 | 0 | -35.4735 | 149.0124 | 2021-10-09 04:21:34 | Australian Capital Territory, Australia | |||
2959054 | 2959054 | 2021-10-08 | Australia | New South Wales | 68246 | 479 | 0 | -33.8688 | 151.2093 | 2021-10-09 04:21:34 | New South Wales, Australia | |||
2959055 | 2959055 | 2021-10-08 | Australia | Northern Territory | 214 | 0 | 0 | -12.4634 | 130.8456 | 2021-10-09 04:21:34 | Northern Territory, Australia | |||
2959056 | 2959056 | 2021-10-08 | Australia | Queensland | 2059 | 7 | 0 | -27.4698 | 153.0251 | 2021-10-09 04:21:34 | Queensland, Australia | |||
2959057 | 2959057 | 2021-10-08 | Australia | South Australia | 908 | 4 | 0 | -34.9285 | 138.6007 | 2021-10-09 04:21:34 | South Australia, Australia | |||
2959058 | 2959058 | 2021-10-08 | Australia | Tasmania | 236 | 13 | 0 | -42.8821 | 147.3272 | 2021-10-09 04:21:34 | Tasmania, Australia | |||
2959059 | 2959059 | 2021-10-08 | Australia | Victoria | 51012 | 900 | 0 | -37.8136 | 144.9631 | 2021-10-09 04:21:34 | Victoria, Australia | |||
2959060 | 2959060 | 2021-10-08 | Australia | Western Australia | 1110 | 9 | 0 | -31.9505 | 115.8605 | 2021-10-09 04:21:34 | Western Australia, Australia | |||
467091 | 467091 | 2021-10-07 | Australia | Australian Capital Territory | 1271 | 9 | 0 | -35.4735 | 149.0124 | 2021-10-08 04:21:25 | Australian Capital Territory, Australia | |||
467092 | 467092 | 2021-10-07 | Australia | New South Wales | 67669 | 468 | 0 | -33.8688 | 151.2093 | 2021-10-08 04:21:25 | New South Wales, Australia | |||
467093 | 467093 | 2021-10-07 | Australia | Northern Territory | 213 | 0 | 0 | -12.4634 | 130.8456 | 2021-10-08 04:21:25 | Northern Territory, Australia | |||
467094 | 467094 | 2021-10-07 | Australia | Queensland | 2056 | 7 | 0 | -27.4698 | 153.0251 | 2021-10-08 04:21:25 | Queensland, Australia | |||
467095 | 467095 | 2021-10-07 | Australia | South Australia | 907 | 4 | 0 | -34.9285 | 138.6007 | 2021-10-08 04:21:25 | South Australia, Australia | |||
467096 | 467096 | 2021-10-07 | Australia | Tasmania | 236 | 13 | 0 | -42.8821 | 147.3272 | 2021-10-08 04:21:25 | Tasmania, Australia | |||
467097 | 467097 | 2021-10-07 | Australia | Victoria | 49104 | 895 | 0 | -37.8136 | 144.9631 | 2021-10-08 04:21:25 | Victoria, Australia | |||
467098 | 467098 | 2021-10-07 | Australia | Western Australia | 1110 | 9 | 0 | -31.9505 | 115.8605 | 2021-10-08 04:21:25 | Western Australia, Australia | |||
2458471 | 2458471 | 2021-10-06 | Australia | Australian Capital Territory | 1231 | 9 | 0 | -35.4735 | 149.0124 | 2021-10-07 04:21:36 | Australian Capital Territory, Australia | |||
2458472 | 2458472 | 2021-10-06 | Australia | New South Wales | 67024 | 457 | 0 | -33.8688 | 151.2093 | 2021-10-07 04:21:36 | New South Wales, Australia | |||
2458473 | 2458473 | 2021-10-06 | Australia | Northern Territory | 212 | 0 | 0 | -12.4634 | 130.8456 | 2021-10-07 04:21:36 | Northern Territory, Australia | |||
2458474 | 2458474 | 2021-10-06 | Australia | Queensland | 2056 | 7 | 0 | -27.4698 | 153.0251 | 2021-10-07 04:21:36 | Queensland, Australia | |||
2458475 | 2458475 | 2021-10-06 | Australia | South Australia | 907 | 4 | 0 | -34.9285 | 138.6007 | 2021-10-07 04:21:36 | South Australia, Australia | |||
2458476 | 2458476 | 2021-10-06 | Australia | Tasmania | 236 | 13 | 0 | -42.8821 | 147.3272 | 2021-10-07 04:21:36 | Tasmania, Australia | |||
2458477 | 2458477 | 2021-10-06 | Australia | Victoria | 47266 | 890 | 0 | -37.8136 | 144.9631 | 2021-10-07 04:21:36 | Victoria, Australia | |||
2458478 | 2458478 | 2021-10-06 | Australia | Western Australia | 1110 | 9 | 0 | -31.9505 | 115.8605 | 2021-10-07 04:21:36 | Western Australia, Australia | |||
3832165 | 3832165 | 2021-10-05 | Australia | Australian Capital Territory | 1190 | 9 | 0 | -35.4735 | 149.0124 | 2021-10-06 04:21:33 | Australian Capital Territory, Australia | |||
3832166 | 3832166 | 2021-10-05 | Australia | New South Wales | 66456 | 449 | 0 | -33.8688 | 151.2093 | 2021-10-06 04:21:33 | New South Wales, Australia | |||
3832167 | 3832167 | 2021-10-05 | Australia | Northern Territory | 212 | 0 | 0 | -12.4634 | 130.8456 | 2021-10-06 04:21:33 | Northern Territory, Australia | |||
3832168 | 3832168 | 2021-10-05 | Australia | Queensland | 2051 | 7 | 0 | -27.4698 | 153.0251 | 2021-10-06 04:21:33 | Queensland, Australia | |||
3832169 | 3832169 | 2021-10-05 | Australia | South Australia | 907 | 4 | 0 | -34.9285 | 138.6007 | 2021-10-06 04:21:33 | South Australia, Australia | |||
3832170 | 3832170 | 2021-10-05 | Australia | Tasmania | 236 | 13 | 0 | -42.8821 | 147.3272 | 2021-10-06 04:21:33 | Tasmania, Australia | |||
3832171 | 3832171 | 2021-10-05 | Australia | Victoria | 45664 | 888 | 0 | -37.8136 | 144.9631 | 2021-10-06 04:21:33 | Victoria, Australia | |||
3832172 | 3832172 | 2021-10-05 | Australia | Western Australia | 1110 | 9 | 0 | -31.9505 | 115.8605 | 2021-10-06 04:21:33 | Western Australia, Australia | |||
986658 | 986658 | 2021-10-04 | Australia | Australian Capital Territory | 1162 | 8 | 0 | -35.4735 | 149.0124 | 2021-10-05 04:21:27 | Australian Capital Territory, Australia | |||
986659 | 986659 | 2021-10-04 | Australia | New South Wales | 65876 | 439 | 0 | -33.8688 | 151.2093 | 2021-10-05 04:21:27 | New South Wales, Australia | |||
986660 | 986660 | 2021-10-04 | Australia | Northern Territory | 212 | 0 | 0 | -12.4634 | 130.8456 | 2021-10-05 04:21:27 | Northern Territory, Australia | |||
986661 | 986661 | 2021-10-04 | Australia | Queensland | 2048 | 7 | 0 | -27.4698 | 153.0251 | 2021-10-05 04:21:27 | Queensland, Australia | |||
986662 | 986662 | 2021-10-04 | Australia | South Australia | 906 | 4 | 0 | -34.9285 | 138.6007 | 2021-10-05 04:21:27 | South Australia, Australia | |||
986663 | 986663 | 2021-10-04 | Australia | Tasmania | 236 | 13 | 0 | -42.8821 | 147.3272 | 2021-10-05 04:21:27 | Tasmania, Australia | |||
986664 | 986664 | 2021-10-04 | Australia | Victoria | 44251 | 877 | 0 | -37.8136 | 144.9631 | 2021-10-05 04:21:27 | Victoria, Australia | |||
986665 | 986665 | 2021-10-04 | Australia | Western Australia | 1109 | 9 | 0 | -31.9505 | 115.8605 | 2021-10-05 04:21:27 | Western Australia, Australia | |||
1273968 | 1273968 | 2021-10-03 | Australia | Australian Capital Territory | 1129 | 8 | 0 | -35.4735 | 149.0124 | 2021-10-04 04:21:31 | Australian Capital Territory, Australia | |||
1273969 | 1273969 | 2021-10-03 | Australia | New South Wales | 65279 | 432 | 0 | -33.8688 | 151.2093 | 2021-10-04 04:21:31 | New South Wales, Australia | |||
1273970 | 1273970 | 2021-10-03 | Australia | Northern Territory | 212 | 0 | 0 | -12.4634 | 130.8456 | 2021-10-04 04:21:31 | Northern Territory, Australia | |||
1273971 | 1273971 | 2021-10-03 | Australia | Queensland | 2046 | 7 | 0 | -27.4698 | 153.0251 | 2021-10-04 04:21:31 | Queensland, Australia | |||
1273972 | 1273972 | 2021-10-03 | Australia | South Australia | 905 | 4 | 0 | -34.9285 | 138.6007 | 2021-10-04 04:21:31 | South Australia, Australia | |||
1273973 | 1273973 | 2021-10-03 | Australia | Tasmania | 236 | 13 | 0 | -42.8821 | 147.3272 | 2021-10-04 04:21:31 | Tasmania, Australia | |||
1273974 | 1273974 | 2021-10-03 | Australia | Victoria | 42505 | 873 | 0 | -37.8136 | 144.9631 | 2021-10-04 04:21:31 | Victoria, Australia | |||
1273975 | 1273975 | 2021-10-03 | Australia | Western Australia | 1099 | 9 | 0 | -31.9505 | 115.8605 | 2021-10-04 04:21:31 | Western Australia, Australia | |||
3927721 | 3927721 | 2021-10-02 | Australia | Australian Capital Territory | 1101 | 6 | 0 | -35.4735 | 149.0124 | 2021-10-03 04:21:24 | Australian Capital Territory, Australia | |||
3927722 | 3927722 | 2021-10-02 | Australia | New South Wales | 64668 | 426 | 0 | -33.8688 | 151.2093 | 2021-10-03 04:21:24 | New South Wales, Australia | |||
3927723 | 3927723 | 2021-10-02 | Australia | Northern Territory | 212 | 0 | 0 | -12.4634 | 130.8456 | 2021-10-03 04:21:24 | Northern Territory, Australia | |||
3927724 | 3927724 | 2021-10-02 | Australia | Queensland | 2043 | 7 | 0 | -27.4698 | 153.0251 | 2021-10-03 04:21:24 | Queensland, Australia | |||
3927725 | 3927725 | 2021-10-02 | Australia | South Australia | 904 | 4 | 0 | -34.9285 | 138.6007 | 2021-10-03 04:21:24 | South Australia, Australia | |||
3927726 | 3927726 | 2021-10-02 | Australia | Tasmania | 236 | 13 | 0 | -42.8821 | 147.3272 | 2021-10-03 04:21:24 | Tasmania, Australia | |||
3927727 | 3927727 | 2021-10-02 | Australia | Victoria | 41128 | 869 | 0 | -37.8136 | 144.9631 | 2021-10-03 04:21:24 | Victoria, Australia | |||
3927728 | 3927728 | 2021-10-02 | Australia | Western Australia | 1096 | 9 | 0 | -31.9505 | 115.8605 | 2021-10-03 04:21:24 | Western Australia, Australia | |||
2131701 | 2131701 | 2021-10-01 | Australia | Australian Capital Territory | 1063 | 6 | 0 | -35.4735 | 149.0124 | 2021-10-02 04:21:25 | Australian Capital Territory, Australia | |||
2131702 | 2131702 | 2021-10-01 | Australia | New South Wales | 64014 | 416 | 0 | -33.8688 | 151.2093 | 2021-10-02 04:21:25 | New South Wales, Australia | |||
2131703 | 2131703 | 2021-10-01 | Australia | Northern Territory | 212 | 0 | 0 | -12.4634 | 130.8456 | 2021-10-02 04:21:25 | Northern Territory, Australia | |||
2131704 | 2131704 | 2021-10-01 | Australia | Queensland | 2042 | 7 | 0 | -27.4698 | 153.0251 | 2021-10-02 04:21:25 | Queensland, Australia | |||
2131705 | 2131705 | 2021-10-01 | Australia | South Australia | 902 | 4 | 0 | -34.9285 | 138.6007 | 2021-10-02 04:21:25 | South Australia, Australia | |||
2131706 | 2131706 | 2021-10-01 | Australia | Tasmania | 235 | 13 | 0 | -42.8821 | 147.3272 | 2021-10-02 04:21:25 | Tasmania, Australia | |||
2131707 | 2131707 | 2021-10-01 | Australia | Victoria | 39952 | 866 | 0 | -37.8136 | 144.9631 | 2021-10-02 04:21:25 | Victoria, Australia | |||
2131708 | 2131708 | 2021-10-01 | Australia | Western Australia | 1096 | 9 | 0 | -31.9505 | 115.8605 | 2021-10-02 04:21:25 | Western Australia, Australia | |||
2772658 | 2772658 | 2021-09-30 | Australia | Australian Capital Territory | 1011 | 8 | 0 | -35.4735 | 149.0124 | 2021-10-01 04:21:35 | Australian Capital Territory, Australia | |||
2772659 | 2772659 | 2021-09-30 | Australia | New South Wales | 63212 | 406 | 0 | -33.8688 | 151.2093 | 2021-10-01 04:21:35 | New South Wales, Australia | |||
2772660 | 2772660 | 2021-09-30 | Australia | Northern Territory | 211 | 0 | 0 | -12.4634 | 130.8456 | 2021-10-01 04:21:35 | Northern Territory, Australia | |||
2772661 | 2772661 | 2021-09-30 | Australia | Queensland | 2039 | 7 | 0 | -27.4698 | 153.0251 | 2021-10-01 04:21:35 | Queensland, Australia |
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]);