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
- Victoria 655
- New South Wales 654
- Queensland 651
- South Australia 650
- Western Australia 622
- Tasmania 620
- Northern Territory 617
- Australian Capital Territory 608
- From Diamond Princess 30
- External territories 1
- Jervis Bay Territory 1
country_or_region 1
- Australia · 5,112 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
28099 | 28099 | 2021-11-11 | Australia | South Australia | 918 | 4 | 0 | -34.9285 | 138.6007 | 2021-11-12 04:22:01 | South Australia, Australia | |||
28100 | 28100 | 2021-11-11 | Australia | Tasmania | 237 | 13 | 0 | -42.8821 | 147.3272 | 2021-11-12 04:22:01 | Tasmania, Australia | |||
28101 | 28101 | 2021-11-11 | Australia | Victoria | 102566 | 1218 | 0 | -37.8136 | 144.9631 | 2021-11-12 04:22:01 | Victoria, Australia | |||
28102 | 28102 | 2021-11-11 | Australia | Western Australia | 1112 | 9 | 0 | -31.9505 | 115.8605 | 2021-11-12 04:22:01 | Western Australia, Australia | |||
2844534 | 2844534 | 2021-11-10 | Australia | Australian Capital Territory | 1902 | 14 | 0 | -35.4735 | 149.0124 | 2021-11-11 04:21:45 | Australian Capital Territory, Australia | |||
2844535 | 2844535 | 2021-11-10 | Australia | New South Wales | 77671 | 606 | 0 | -33.8688 | 151.2093 | 2021-11-11 04:21:45 | New South Wales, Australia | |||
2844536 | 2844536 | 2021-11-10 | Australia | Northern Territory | 231 | 0 | 0 | -12.4634 | 130.8456 | 2021-11-11 04:21:45 | Northern Territory, Australia | |||
2844537 | 2844537 | 2021-11-10 | Australia | Queensland | 2105 | 7 | 0 | -27.4698 | 153.0251 | 2021-11-11 04:21:45 | Queensland, Australia | |||
2844538 | 2844538 | 2021-11-10 | Australia | South Australia | 918 | 4 | 0 | -34.9285 | 138.6007 | 2021-11-11 04:21:45 | South Australia, Australia | |||
2844539 | 2844539 | 2021-11-10 | Australia | Tasmania | 237 | 13 | 0 | -42.8821 | 147.3272 | 2021-11-11 04:21:45 | Tasmania, Australia | |||
2844540 | 2844540 | 2021-11-10 | Australia | Victoria | 101451 | 1209 | 0 | -37.8136 | 144.9631 | 2021-11-11 04:21:45 | Victoria, Australia | |||
2844541 | 2844541 | 2021-11-10 | Australia | Western Australia | 1112 | 9 | 0 | -31.9505 | 115.8605 | 2021-11-11 04:21:45 | Western Australia, Australia | |||
86804 | 86804 | 2021-11-09 | Australia | Australian Capital Territory | 1893 | 14 | 0 | -35.4735 | 149.0124 | 2021-11-10 04:21:38 | Australian Capital Territory, Australia | |||
86805 | 86805 | 2021-11-09 | Australia | New South Wales | 77417 | 605 | 0 | -33.8688 | 151.2093 | 2021-11-10 04:21:38 | New South Wales, Australia | |||
86806 | 86806 | 2021-11-09 | Australia | Northern Territory | 230 | 0 | 0 | -12.4634 | 130.8456 | 2021-11-10 04:21:38 | Northern Territory, Australia | |||
86807 | 86807 | 2021-11-09 | Australia | Queensland | 2102 | 7 | 0 | -27.4698 | 153.0251 | 2021-11-10 04:21:38 | Queensland, Australia | |||
86808 | 86808 | 2021-11-09 | Australia | South Australia | 918 | 4 | 0 | -34.9285 | 138.6007 | 2021-11-10 04:21:38 | South Australia, Australia | |||
86809 | 86809 | 2021-11-09 | Australia | Tasmania | 237 | 13 | 0 | -42.8821 | 147.3272 | 2021-11-10 04:21:38 | Tasmania, Australia | |||
86810 | 86810 | 2021-11-09 | Australia | Victoria | 100162 | 1206 | 0 | -37.8136 | 144.9631 | 2021-11-10 04:21:38 | Victoria, Australia | |||
86811 | 86811 | 2021-11-09 | Australia | Western Australia | 1112 | 9 | 0 | -31.9505 | 115.8605 | 2021-11-10 04:21:38 | Western Australia, Australia | |||
3639232 | 3639232 | 2021-11-08 | Australia | Australian Capital Territory | 1884 | 14 | 0 | -35.4735 | 149.0124 | 2021-11-09 04:21:36 | Australian Capital Territory, Australia | |||
3639233 | 3639233 | 2021-11-08 | Australia | New South Wales | 77207 | 602 | 0 | -33.8688 | 151.2093 | 2021-11-09 04:21:36 | New South Wales, Australia | |||
3639234 | 3639234 | 2021-11-08 | Australia | Northern Territory | 230 | 0 | 0 | -12.4634 | 130.8456 | 2021-11-09 04:21:36 | Northern Territory, Australia | |||
3639235 | 3639235 | 2021-11-08 | Australia | Queensland | 2099 | 7 | 0 | -27.4698 | 153.0251 | 2021-11-09 04:21:36 | Queensland, Australia | |||
3639236 | 3639236 | 2021-11-08 | Australia | South Australia | 918 | 4 | 0 | -34.9285 | 138.6007 | 2021-11-09 04:21:36 | South Australia, Australia | |||
3639237 | 3639237 | 2021-11-08 | Australia | Tasmania | 237 | 13 | 0 | -42.8821 | 147.3272 | 2021-11-09 04:21:36 | Tasmania, Australia | |||
3639238 | 3639238 | 2021-11-08 | Australia | Victoria | 99183 | 1192 | 0 | -37.8136 | 144.9631 | 2021-11-09 04:21:36 | Victoria, Australia | |||
3639239 | 3639239 | 2021-11-08 | Australia | Western Australia | 1112 | 9 | 0 | -31.9505 | 115.8605 | 2021-11-09 04:21:36 | Western Australia, Australia | |||
2000340 | 2000340 | 2021-11-07 | Australia | Australian Capital Territory | 1866 | 14 | 0 | -35.4735 | 149.0124 | 2021-11-08 04:21:43 | Australian Capital Territory, Australia | |||
2000341 | 2000341 | 2021-11-07 | Australia | New South Wales | 76988 | 598 | 0 | -33.8688 | 151.2093 | 2021-11-08 04:21:43 | New South Wales, Australia | |||
2000342 | 2000342 | 2021-11-07 | Australia | Northern Territory | 229 | 0 | 0 | -12.4634 | 130.8456 | 2021-11-08 04:21:43 | Northern Territory, Australia | |||
2000343 | 2000343 | 2021-11-07 | Australia | Queensland | 2098 | 7 | 0 | -27.4698 | 153.0251 | 2021-11-08 04:21:43 | Queensland, Australia | |||
2000344 | 2000344 | 2021-11-07 | Australia | South Australia | 918 | 4 | 0 | -34.9285 | 138.6007 | 2021-11-08 04:21:43 | South Australia, Australia | |||
2000345 | 2000345 | 2021-11-07 | Australia | Tasmania | 237 | 13 | 0 | -42.8821 | 147.3272 | 2021-11-08 04:21:43 | Tasmania, Australia | |||
2000346 | 2000346 | 2021-11-07 | Australia | Victoria | 98130 | 1182 | 0 | -37.8136 | 144.9631 | 2021-11-08 04:21:43 | Victoria, Australia | |||
2000347 | 2000347 | 2021-11-07 | Australia | Western Australia | 1112 | 9 | 0 | -31.9505 | 115.8605 | 2021-11-08 04:21:43 | Western Australia, Australia | |||
495331 | 495331 | 2021-11-06 | Australia | Australian Capital Territory | 1853 | 14 | 0 | -35.4735 | 149.0124 | 2021-11-07 04:21:53 | Australian Capital Territory, Australia | |||
495332 | 495332 | 2021-11-06 | Australia | New South Wales | 76824 | 591 | 0 | -33.8688 | 151.2093 | 2021-11-07 04:21:53 | New South Wales, Australia | |||
495333 | 495333 | 2021-11-06 | Australia | Northern Territory | 229 | 0 | 0 | -12.4634 | 130.8456 | 2021-11-07 04:21:53 | Northern Territory, Australia | |||
495334 | 495334 | 2021-11-06 | Australia | Queensland | 2098 | 7 | 0 | -27.4698 | 153.0251 | 2021-11-07 04:21:53 | Queensland, Australia | |||
495335 | 495335 | 2021-11-06 | Australia | South Australia | 918 | 4 | 0 | -34.9285 | 138.6007 | 2021-11-07 04:21:53 | South Australia, Australia | |||
495336 | 495336 | 2021-11-06 | Australia | Tasmania | 237 | 13 | 0 | -42.8821 | 147.3272 | 2021-11-07 04:21:53 | Tasmania, Australia | |||
495337 | 495337 | 2021-11-06 | Australia | Victoria | 97043 | 1177 | 0 | -37.8136 | 144.9631 | 2021-11-07 04:21:53 | Victoria, Australia | |||
495338 | 495338 | 2021-11-06 | Australia | Western Australia | 1112 | 9 | 0 | -31.9505 | 115.8605 | 2021-11-07 04:21:53 | Western Australia, Australia | |||
3121186 | 3121186 | 2021-11-05 | Australia | Australian Capital Territory | 1840 | 14 | 0 | -35.4735 | 149.0124 | 2021-11-06 04:21:51 | Australian Capital Territory, Australia | |||
3121187 | 3121187 | 2021-11-05 | Australia | New South Wales | 76580 | 590 | 0 | -33.8688 | 151.2093 | 2021-11-06 04:21:51 | New South Wales, Australia | |||
3121188 | 3121188 | 2021-11-05 | Australia | Northern Territory | 228 | 0 | 0 | -12.4634 | 130.8456 | 2021-11-06 04:21:51 | Northern Territory, Australia | |||
3121189 | 3121189 | 2021-11-05 | Australia | Queensland | 2095 | 7 | 0 | -27.4698 | 153.0251 | 2021-11-06 04:21:51 | Queensland, Australia | |||
3121190 | 3121190 | 2021-11-05 | Australia | South Australia | 918 | 4 | 0 | -34.9285 | 138.6007 | 2021-11-06 04:21:51 | South Australia, Australia | |||
3121191 | 3121191 | 2021-11-05 | Australia | Tasmania | 237 | 13 | 0 | -42.8821 | 147.3272 | 2021-11-06 04:21:51 | Tasmania, Australia | |||
3121192 | 3121192 | 2021-11-05 | Australia | Victoria | 95917 | 1168 | 0 | -37.8136 | 144.9631 | 2021-11-06 04:21:51 | Victoria, Australia | |||
3121193 | 3121193 | 2021-11-05 | Australia | Western Australia | 1112 | 9 | 0 | -31.9505 | 115.8605 | 2021-11-06 04:21:51 | Western Australia, Australia | |||
698084 | 698084 | 2021-11-04 | Australia | Australian Capital Territory | 1822 | 14 | 0 | -35.4735 | 149.0124 | 2021-11-05 04:21:54 | Australian Capital Territory, Australia | |||
698085 | 698085 | 2021-11-04 | Australia | New South Wales | 76314 | 587 | 0 | -33.8688 | 151.2093 | 2021-11-05 04:21:54 | New South Wales, Australia | |||
698086 | 698086 | 2021-11-04 | Australia | Northern Territory | 227 | 0 | 0 | -12.4634 | 130.8456 | 2021-11-05 04:21:54 | Northern Territory, Australia | |||
698087 | 698087 | 2021-11-04 | Australia | Queensland | 2094 | 7 | 0 | -27.4698 | 153.0251 | 2021-11-05 04:21:54 | Queensland, Australia | |||
698088 | 698088 | 2021-11-04 | Australia | South Australia | 918 | 4 | 0 | -34.9285 | 138.6007 | 2021-11-05 04:21:54 | South Australia, Australia | |||
698089 | 698089 | 2021-11-04 | Australia | Tasmania | 237 | 13 | 0 | -42.8821 | 147.3272 | 2021-11-05 04:21:54 | Tasmania, Australia | |||
698090 | 698090 | 2021-11-04 | Australia | Victoria | 94669 | 1161 | 0 | -37.8136 | 144.9631 | 2021-11-05 04:21:54 | Victoria, Australia | |||
698091 | 698091 | 2021-11-04 | Australia | Western Australia | 1112 | 9 | 0 | -31.9505 | 115.8605 | 2021-11-05 04:21:54 | Western Australia, Australia | |||
275862 | 275862 | 2021-11-03 | Australia | Australian Capital Territory | 1816 | 13 | 0 | -35.4735 | 149.0124 | 2021-11-04 04:22:20 | Australian Capital Territory, Australia | |||
275863 | 275863 | 2021-11-03 | Australia | New South Wales | 76073 | 584 | 0 | -33.8688 | 151.2093 | 2021-11-04 04:22:20 | New South Wales, Australia | |||
275864 | 275864 | 2021-11-03 | Australia | Northern Territory | 226 | 0 | 0 | -12.4634 | 130.8456 | 2021-11-04 04:22:20 | Northern Territory, Australia | |||
275865 | 275865 | 2021-11-03 | Australia | Queensland | 2092 | 7 | 0 | -27.4698 | 153.0251 | 2021-11-04 04:22:20 | Queensland, Australia | |||
275866 | 275866 | 2021-11-03 | Australia | South Australia | 918 | 4 | 0 | -34.9285 | 138.6007 | 2021-11-04 04:22:20 | South Australia, Australia | |||
275867 | 275867 | 2021-11-03 | Australia | Tasmania | 237 | 13 | 0 | -42.8821 | 147.3272 | 2021-11-04 04:22:20 | Tasmania, Australia | |||
275868 | 275868 | 2021-11-03 | Australia | Victoria | 93339 | 1151 | 0 | -37.8136 | 144.9631 | 2021-11-04 04:22:20 | Victoria, Australia | |||
275869 | 275869 | 2021-11-03 | Australia | Western Australia | 1112 | 9 | 0 | -31.9505 | 115.8605 | 2021-11-04 04:22:20 | Western Australia, Australia | |||
43387 | 43387 | 2021-11-02 | Australia | Australian Capital Territory | 1803 | 13 | 0 | -35.4735 | 149.0124 | 2021-11-03 06:22:09 | Australian Capital Territory, Australia | |||
43388 | 43388 | 2021-11-02 | Australia | New South Wales | 75766 | 580 | 0 | -33.8688 | 151.2093 | 2021-11-03 06:22:09 | New South Wales, Australia | |||
43389 | 43389 | 2021-11-02 | Australia | Northern Territory | 225 | 0 | 0 | -12.4634 | 130.8456 | 2021-11-03 06:22:09 | Northern Territory, Australia | |||
43390 | 43390 | 2021-11-02 | Australia | Queensland | 2089 | 7 | 0 | -27.4698 | 153.0251 | 2021-11-03 06:22:09 | Queensland, Australia | |||
43391 | 43391 | 2021-11-02 | Australia | South Australia | 918 | 4 | 0 | -34.9285 | 138.6007 | 2021-11-03 06:22:09 | South Australia, Australia | |||
43392 | 43392 | 2021-11-02 | Australia | Tasmania | 237 | 13 | 0 | -42.8821 | 147.3272 | 2021-11-03 06:22:09 | Tasmania, Australia | |||
43393 | 43393 | 2021-11-02 | Australia | Victoria | 92126 | 1142 | 0 | -37.8136 | 144.9631 | 2021-11-03 06:22:09 | Victoria, Australia | |||
43394 | 43394 | 2021-11-02 | Australia | Western Australia | 1112 | 9 | 0 | -31.9505 | 115.8605 | 2021-11-03 06:22:09 | Western Australia, Australia | |||
3511083 | 3511083 | 2021-11-01 | Australia | Australian Capital Territory | 1788 | 13 | 0 | -35.4735 | 149.0124 | 2021-11-02 04:22:03 | Australian Capital Territory, Australia | |||
3511084 | 3511084 | 2021-11-01 | Australia | New South Wales | 75578 | 576 | 0 | -33.8688 | 151.2093 | 2021-11-02 04:22:03 | New South Wales, Australia | |||
3511085 | 3511085 | 2021-11-01 | Australia | Northern Territory | 225 | 0 | 0 | -12.4634 | 130.8456 | 2021-11-02 04:22:03 | Northern Territory, Australia | |||
3511086 | 3511086 | 2021-11-01 | Australia | Queensland | 2090 | 7 | 0 | -27.4698 | 153.0251 | 2021-11-02 04:22:03 | Queensland, Australia | |||
3511087 | 3511087 | 2021-11-01 | Australia | South Australia | 918 | 4 | 0 | -34.9285 | 138.6007 | 2021-11-02 04:22:03 | South Australia, Australia | |||
3511088 | 3511088 | 2021-11-01 | Australia | Tasmania | 237 | 13 | 0 | -42.8821 | 147.3272 | 2021-11-02 04:22:03 | Tasmania, Australia | |||
3511089 | 3511089 | 2021-11-01 | Australia | Victoria | 91217 | 1134 | 0 | -37.8136 | 144.9631 | 2021-11-02 04:22:03 | Victoria, Australia | |||
3511090 | 3511090 | 2021-11-01 | Australia | Western Australia | 1112 | 9 | 0 | -31.9505 | 115.8605 | 2021-11-02 04:22:03 | Western Australia, Australia | |||
287675 | 287675 | 2021-10-31 | Australia | Australian Capital Territory | 1780 | 13 | 0 | -35.4735 | 149.0124 | 2021-11-01 04:22:01 | Australian Capital Territory, Australia | |||
287676 | 287676 | 2021-10-31 | Australia | New South Wales | 75407 | 572 | 0 | -33.8688 | 151.2093 | 2021-11-01 04:22:01 | New South Wales, Australia | |||
287677 | 287677 | 2021-10-31 | Australia | Northern Territory | 225 | 0 | 0 | -12.4634 | 130.8456 | 2021-11-01 04:22:01 | Northern Territory, Australia | |||
287678 | 287678 | 2021-10-31 | Australia | Queensland | 2090 | 7 | 0 | -27.4698 | 153.0251 | 2021-11-01 04:22:01 | Queensland, Australia | |||
287679 | 287679 | 2021-10-31 | Australia | South Australia | 918 | 4 | 0 | -34.9285 | 138.6007 | 2021-11-01 04:22:01 | South Australia, Australia | |||
287680 | 287680 | 2021-10-31 | Australia | Tasmania | 237 | 13 | 0 | -42.8821 | 147.3272 | 2021-11-01 04:22:01 | Tasmania, Australia | |||
287681 | 287681 | 2021-10-31 | Australia | Victoria | 90261 | 1125 | 0 | -37.8136 | 144.9631 | 2021-11-01 04:22:01 | Victoria, Australia | |||
287682 | 287682 | 2021-10-31 | Australia | Western Australia | 1112 | 9 | 0 | -31.9505 | 115.8605 | 2021-11-01 04:22:01 | Western Australia, Australia | |||
2720681 | 2720681 | 2021-10-30 | Australia | Australian Capital Territory | 1775 | 11 | 0 | -35.4735 | 149.0124 | 2021-10-31 04:22:08 | Australian Capital Territory, Australia | |||
2720682 | 2720682 | 2021-10-30 | Australia | New South Wales | 75278 | 568 | 0 | -33.8688 | 151.2093 | 2021-10-31 04:22:08 | New South Wales, Australia | |||
2720683 | 2720683 | 2021-10-30 | Australia | Northern Territory | 225 | 0 | 0 | -12.4634 | 130.8456 | 2021-10-31 04:22:08 | Northern Territory, Australia | |||
2720684 | 2720684 | 2021-10-30 | Australia | Queensland | 2089 | 7 | 0 | -27.4698 | 153.0251 | 2021-10-31 04:22:08 | Queensland, Australia | |||
2720685 | 2720685 | 2021-10-30 | Australia | South Australia | 918 | 4 | 0 | -34.9285 | 138.6007 | 2021-10-31 04:22:08 | South Australia, Australia | |||
2720686 | 2720686 | 2021-10-30 | Australia | Tasmania | 237 | 13 | 0 | -42.8821 | 147.3272 | 2021-10-31 04:22:08 | Tasmania, Australia | |||
2720687 | 2720687 | 2021-10-30 | Australia | Victoria | 88930 | 1123 | 0 | -37.8136 | 144.9631 | 2021-10-31 04:22:08 | Victoria, Australia | |||
2720688 | 2720688 | 2021-10-30 | Australia | Western Australia | 1112 | 9 | 0 | -31.9505 | 115.8605 | 2021-10-31 04:22:08 | Western Australia, 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]);