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 221
- New South Wales 220
- Queensland 217
- South Australia 216
- Western Australia 188
- Tasmania 186
- Northern Territory 183
- Australian Capital Territory 174
- From Diamond Princess 30
- External territories 1
- Jervis Bay Territory 1
country_or_region 1
- Australia · 1,640 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1354030 | 1354030 | 2020-09-03 | Australia | South Australia | 463 | 4 | 459 | 0 | -34.9285 | 138.6007 | 2020-09-04 04:28:26 | South Australia, Australia | ||
1354031 | 1354031 | 2020-09-03 | Australia | Tasmania | 230 | 13 | 217 | 0 | -42.8821 | 147.3272 | 2020-09-04 04:28:26 | Tasmania, Australia | ||
1354032 | 1354032 | 2020-09-03 | Australia | Victoria | 19415 | 650 | 16370 | 2395 | -37.8136 | 144.9631 | 2020-09-04 04:28:26 | Victoria, Australia | ||
1354033 | 1354033 | 2020-09-03 | Australia | Western Australia | 655 | 9 | 643 | 3 | -31.9505 | 115.8605 | 2020-09-04 04:28:26 | Western Australia, Australia | ||
1105263 | 1105263 | 2020-09-02 | Australia | Australian Capital Territory | 113 | 3 | 110 | 0 | -35.4735 | 149.0124 | 2020-09-03 04:28:22 | Australian Capital Territory, Australia | ||
1105264 | 1105264 | 2020-09-02 | Australia | New South Wales | 4091 | 52 | 0 | 4039 | -33.8688 | 151.2093 | 2020-09-03 04:28:22 | New South Wales, Australia | ||
1105265 | 1105265 | 2020-09-02 | Australia | Northern Territory | 33 | 0 | 33 | 0 | -12.4634 | 130.8456 | 2020-09-03 04:28:22 | Northern Territory, Australia | ||
1105266 | 1105266 | 2020-09-02 | Australia | Queensland | 1128 | 6 | 1086 | 36 | -27.4698 | 153.0251 | 2020-09-03 04:28:22 | Queensland, Australia | ||
1105267 | 1105267 | 2020-09-02 | Australia | South Australia | 463 | 4 | 459 | 0 | -34.9285 | 138.6007 | 2020-09-03 04:28:22 | South Australia, Australia | ||
1105268 | 1105268 | 2020-09-02 | Australia | Tasmania | 230 | 13 | 217 | 0 | -42.8821 | 147.3272 | 2020-09-03 04:28:22 | Tasmania, Australia | ||
1105269 | 1105269 | 2020-09-02 | Australia | Victoria | 19336 | 591 | 16152 | 2593 | -37.8136 | 144.9631 | 2020-09-03 04:28:22 | Victoria, Australia | ||
1105270 | 1105270 | 2020-09-02 | Australia | Western Australia | 655 | 9 | 641 | 5 | -31.9505 | 115.8605 | 2020-09-03 04:28:22 | Western Australia, Australia | ||
2059592 | 2059592 | 2020-09-01 | Australia | Australian Capital Territory | 113 | 3 | 110 | 0 | -35.4735 | 149.0124 | 2020-09-02 04:28:25 | Australian Capital Territory, Australia | ||
2059593 | 2059593 | 2020-09-01 | Australia | New South Wales | 4079 | 52 | 0 | 4027 | -33.8688 | 151.2093 | 2020-09-02 04:28:25 | New South Wales, Australia | ||
2059594 | 2059594 | 2020-09-01 | Australia | Northern Territory | 33 | 0 | 33 | 0 | -12.4634 | 130.8456 | 2020-09-02 04:28:25 | Northern Territory, Australia | ||
2059595 | 2059595 | 2020-09-01 | Australia | Queensland | 1126 | 6 | 1084 | 36 | -27.4698 | 153.0251 | 2020-09-02 04:28:25 | Queensland, Australia | ||
2059596 | 2059596 | 2020-09-01 | Australia | South Australia | 463 | 4 | 458 | 1 | -34.9285 | 138.6007 | 2020-09-02 04:28:25 | South Australia, Australia | ||
2059597 | 2059597 | 2020-09-01 | Australia | Tasmania | 230 | 13 | 217 | 0 | -42.8821 | 147.3272 | 2020-09-02 04:28:25 | Tasmania, Australia | ||
2059598 | 2059598 | 2020-09-01 | Australia | Victoria | 19224 | 576 | 16152 | 2496 | -37.8136 | 144.9631 | 2020-09-02 04:28:25 | Victoria, Australia | ||
2059599 | 2059599 | 2020-09-01 | Australia | Western Australia | 655 | 9 | 641 | 5 | -31.9505 | 115.8605 | 2020-09-02 04:28:25 | Western Australia, Australia | ||
193777 | 193777 | 2020-08-31 | Australia | Australian Capital Territory | 113 | 3 | 110 | 0 | -35.4735 | 149.0124 | 2020-09-01 04:28:31 | Australian Capital Territory, Australia | ||
193778 | 193778 | 2020-08-31 | Australia | New South Wales | 4063 | 52 | 0 | 4011 | -33.8688 | 151.2093 | 2020-09-01 04:28:31 | New South Wales, Australia | ||
193779 | 193779 | 2020-08-31 | Australia | Northern Territory | 33 | 0 | 33 | 0 | -12.4634 | 130.8456 | 2020-09-01 04:28:31 | Northern Territory, Australia | ||
193780 | 193780 | 2020-08-31 | Australia | Queensland | 1124 | 6 | 1084 | 34 | -27.4698 | 153.0251 | 2020-09-01 04:28:31 | Queensland, Australia | ||
193781 | 193781 | 2020-08-31 | Australia | South Australia | 463 | 4 | 458 | 1 | -34.9285 | 138.6007 | 2020-09-01 04:28:31 | South Australia, Australia | ||
193782 | 193782 | 2020-08-31 | Australia | Tasmania | 230 | 13 | 216 | 1 | -42.8821 | 147.3272 | 2020-09-01 04:28:31 | Tasmania, Australia | ||
193783 | 193783 | 2020-08-31 | Australia | Victoria | 19138 | 570 | 15814 | 2754 | -37.8136 | 144.9631 | 2020-09-01 04:28:31 | Victoria, Australia | ||
193784 | 193784 | 2020-08-31 | Australia | Western Australia | 655 | 9 | 641 | 5 | -31.9505 | 115.8605 | 2020-09-01 04:28:31 | Western Australia, Australia | ||
3931736 | 3931736 | 2020-08-30 | Australia | Australian Capital Territory | 113 | 3 | 110 | 0 | -35.4735 | 149.0124 | 2020-08-31 04:28:27 | Australian Capital Territory, Australia | ||
3931737 | 3931737 | 2020-08-30 | Australia | New South Wales | 4050 | 52 | 0 | 3998 | -33.8688 | 151.2093 | 2020-08-31 04:28:27 | New South Wales, Australia | ||
3931738 | 3931738 | 2020-08-30 | Australia | Northern Territory | 33 | 0 | 33 | 0 | -12.4634 | 130.8456 | 2020-08-31 04:28:27 | Northern Territory, Australia | ||
3931739 | 3931739 | 2020-08-30 | Australia | Queensland | 1122 | 6 | 1084 | 32 | -27.4698 | 153.0251 | 2020-08-31 04:28:27 | Queensland, Australia | ||
3931740 | 3931740 | 2020-08-30 | Australia | South Australia | 463 | 4 | 458 | 1 | -34.9285 | 138.6007 | 2020-08-31 04:28:27 | South Australia, Australia | ||
3931741 | 3931741 | 2020-08-30 | Australia | Tasmania | 230 | 13 | 216 | 1 | -42.8821 | 147.3272 | 2020-08-31 04:28:27 | Tasmania, Australia | ||
3931742 | 3931742 | 2020-08-30 | Australia | Victoria | 19080 | 565 | 15580 | 2935 | -37.8136 | 144.9631 | 2020-08-31 04:28:27 | Victoria, Australia | ||
3931743 | 3931743 | 2020-08-30 | Australia | Western Australia | 655 | 9 | 641 | 5 | -31.9505 | 115.8605 | 2020-08-31 04:28:27 | Western Australia, Australia | ||
609398 | 609398 | 2020-08-29 | Australia | Australian Capital Territory | 113 | 3 | 110 | 0 | -35.4735 | 149.0124 | 2020-08-30 04:28:22 | Australian Capital Territory, Australia | ||
609399 | 609399 | 2020-08-29 | Australia | New South Wales | 4040 | 52 | 0 | 3988 | -33.8688 | 151.2093 | 2020-08-30 04:28:22 | New South Wales, Australia | ||
609400 | 609400 | 2020-08-29 | Australia | Northern Territory | 33 | 0 | 33 | 0 | -12.4634 | 130.8456 | 2020-08-30 04:28:22 | Northern Territory, Australia | ||
609401 | 609401 | 2020-08-29 | Australia | Queensland | 1121 | 6 | 1084 | 31 | -27.4698 | 153.0251 | 2020-08-30 04:28:22 | Queensland, Australia | ||
609402 | 609402 | 2020-08-29 | Australia | South Australia | 463 | 4 | 458 | 1 | -34.9285 | 138.6007 | 2020-08-30 04:28:22 | South Australia, Australia | ||
609403 | 609403 | 2020-08-29 | Australia | Tasmania | 230 | 13 | 216 | 1 | -42.8821 | 147.3272 | 2020-08-30 04:28:22 | Tasmania, Australia | ||
609404 | 609404 | 2020-08-29 | Australia | Victoria | 19015 | 524 | 15324 | 3167 | -37.8136 | 144.9631 | 2020-08-30 04:28:22 | Victoria, Australia | ||
609405 | 609405 | 2020-08-29 | Australia | Western Australia | 655 | 9 | 641 | 5 | -31.9505 | 115.8605 | 2020-08-30 04:28:22 | Western Australia, Australia | ||
1522893 | 1522893 | 2020-08-28 | Australia | Australian Capital Territory | 113 | 3 | 110 | 0 | -35.4735 | 149.0124 | 2020-08-29 04:28:19 | Australian Capital Territory, Australia | ||
1522894 | 1522894 | 2020-08-28 | Australia | New South Wales | 4033 | 52 | 0 | 3981 | -33.8688 | 151.2093 | 2020-08-29 04:28:19 | New South Wales, Australia | ||
1522895 | 1522895 | 2020-08-28 | Australia | Northern Territory | 33 | 0 | 33 | 0 | -12.4634 | 130.8456 | 2020-08-29 04:28:19 | Northern Territory, Australia | ||
1522896 | 1522896 | 2020-08-28 | Australia | Queensland | 1117 | 6 | 1084 | 27 | -27.4698 | 153.0251 | 2020-08-29 04:28:19 | Queensland, Australia | ||
1522897 | 1522897 | 2020-08-28 | Australia | South Australia | 463 | 4 | 458 | 1 | -34.9285 | 138.6007 | 2020-08-29 04:28:19 | South Australia, Australia | ||
1522898 | 1522898 | 2020-08-28 | Australia | Tasmania | 230 | 13 | 216 | 1 | -42.8821 | 147.3272 | 2020-08-29 04:28:19 | Tasmania, Australia | ||
1522899 | 1522899 | 2020-08-28 | Australia | Victoria | 18903 | 513 | 15101 | 3289 | -37.8136 | 144.9631 | 2020-08-29 04:28:19 | Victoria, Australia | ||
1522900 | 1522900 | 2020-08-28 | Australia | Western Australia | 655 | 9 | 637 | 9 | -31.9505 | 115.8605 | 2020-08-29 04:28:19 | Western Australia, Australia | ||
2509894 | 2509894 | 2020-08-27 | Australia | Australian Capital Territory | 113 | 3 | 110 | 0 | -35.4735 | 149.0124 | 2020-08-28 04:28:11 | Australian Capital Territory, Australia | ||
2509895 | 2509895 | 2020-08-27 | Australia | New South Wales | 4019 | 52 | 0 | 3967 | -33.8688 | 151.2093 | 2020-08-28 04:28:11 | New South Wales, Australia | ||
2509896 | 2509896 | 2020-08-27 | Australia | Northern Territory | 33 | 0 | 33 | 0 | -12.4634 | 130.8456 | 2020-08-28 04:28:11 | Northern Territory, Australia | ||
2509897 | 2509897 | 2020-08-27 | Australia | Queensland | 1113 | 6 | 1084 | 23 | -27.4698 | 153.0251 | 2020-08-28 04:28:11 | Queensland, Australia | ||
2509898 | 2509898 | 2020-08-27 | Australia | South Australia | 463 | 4 | 456 | 3 | -34.9285 | 138.6007 | 2020-08-28 04:28:11 | South Australia, Australia | ||
2509899 | 2509899 | 2020-08-27 | Australia | Tasmania | 230 | 13 | 216 | 1 | -42.8821 | 147.3272 | 2020-08-28 04:28:11 | Tasmania, Australia | ||
2509900 | 2509900 | 2020-08-27 | Australia | Victoria | 18822 | 496 | 14837 | 3489 | -37.8136 | 144.9631 | 2020-08-28 04:28:11 | Victoria, Australia | ||
2509901 | 2509901 | 2020-08-27 | Australia | Western Australia | 655 | 9 | 637 | 9 | -31.9505 | 115.8605 | 2020-08-28 04:28:11 | Western Australia, Australia | ||
1996354 | 1996354 | 2020-08-26 | Australia | Australian Capital Territory | 113 | 3 | 110 | 0 | -35.4735 | 149.0124 | 2020-08-27 04:28:15 | Australian Capital Territory, Australia | ||
1996355 | 1996355 | 2020-08-26 | Australia | New South Wales | 4006 | 52 | 0 | 3954 | -33.8688 | 151.2093 | 2020-08-27 04:28:15 | New South Wales, Australia | ||
1996356 | 1996356 | 2020-08-26 | Australia | Northern Territory | 33 | 0 | 33 | 0 | -12.4634 | 130.8456 | 2020-08-27 04:28:15 | Northern Territory, Australia | ||
1996357 | 1996357 | 2020-08-26 | Australia | Queensland | 1110 | 6 | 1083 | 21 | -27.4698 | 153.0251 | 2020-08-27 04:28:15 | Queensland, Australia | ||
1996358 | 1996358 | 2020-08-26 | Australia | South Australia | 463 | 4 | 456 | 3 | -34.9285 | 138.6007 | 2020-08-27 04:28:15 | South Australia, Australia | ||
1996359 | 1996359 | 2020-08-26 | Australia | Tasmania | 230 | 13 | 216 | 1 | -42.8821 | 147.3272 | 2020-08-27 04:28:15 | Tasmania, Australia | ||
1996360 | 1996360 | 2020-08-26 | Australia | Victoria | 18714 | 485 | 14572 | 3657 | -37.8136 | 144.9631 | 2020-08-27 04:28:15 | Victoria, Australia | ||
1996361 | 1996361 | 2020-08-26 | Australia | Western Australia | 653 | 9 | 637 | 7 | -31.9505 | 115.8605 | 2020-08-27 04:28:15 | Western Australia, Australia | ||
3562278 | 3562278 | 2020-08-25 | Australia | Australian Capital Territory | 113 | 3 | 110 | 0 | -35.4735 | 149.0124 | 2020-08-26 04:28:11 | Australian Capital Territory, Australia | ||
3562279 | 3562279 | 2020-08-25 | Australia | New South Wales | 3997 | 52 | 0 | 3945 | -33.8688 | 151.2093 | 2020-08-26 04:28:11 | New South Wales, Australia | ||
3562280 | 3562280 | 2020-08-25 | Australia | Northern Territory | 33 | 0 | 33 | 0 | -12.4634 | 130.8456 | 2020-08-26 04:28:11 | Northern Territory, Australia | ||
3562281 | 3562281 | 2020-08-25 | Australia | Queensland | 1107 | 6 | 1083 | 18 | -27.4698 | 153.0251 | 2020-08-26 04:28:11 | Queensland, Australia | ||
3562282 | 3562282 | 2020-08-25 | Australia | South Australia | 463 | 4 | 456 | 3 | -34.9285 | 138.6007 | 2020-08-26 04:28:11 | South Australia, Australia | ||
3562283 | 3562283 | 2020-08-25 | Australia | Tasmania | 230 | 13 | 216 | 1 | -42.8821 | 147.3272 | 2020-08-26 04:28:11 | Tasmania, Australia | ||
3562284 | 3562284 | 2020-08-25 | Australia | Victoria | 18608 | 462 | 14572 | 3574 | -37.8136 | 144.9631 | 2020-08-26 04:28:11 | Victoria, Australia | ||
3562285 | 3562285 | 2020-08-25 | Australia | Western Australia | 653 | 9 | 636 | 8 | -31.9505 | 115.8605 | 2020-08-26 04:28:11 | Western Australia, Australia | ||
2990982 | 2990982 | 2020-08-24 | Australia | Australian Capital Territory | 113 | 3 | 110 | 0 | -35.4735 | 149.0124 | 2020-08-25 04:28:02 | Australian Capital Territory, Australia | ||
2990983 | 2990983 | 2020-08-24 | Australia | New South Wales | 3991 | 52 | 0 | 3939 | -33.8688 | 151.2093 | 2020-08-25 04:28:02 | New South Wales, Australia | ||
2990984 | 2990984 | 2020-08-24 | Australia | Northern Territory | 33 | 0 | 33 | 0 | -12.4634 | 130.8456 | 2020-08-25 04:28:02 | Northern Territory, Australia | ||
2990985 | 2990985 | 2020-08-24 | Australia | Queensland | 1106 | 6 | 1082 | 18 | -27.4698 | 153.0251 | 2020-08-25 04:28:02 | Queensland, Australia | ||
2990986 | 2990986 | 2020-08-24 | Australia | South Australia | 463 | 4 | 456 | 3 | -34.9285 | 138.6007 | 2020-08-25 04:28:02 | South Australia, Australia | ||
2990987 | 2990987 | 2020-08-24 | Australia | Tasmania | 230 | 13 | 216 | 1 | -42.8821 | 147.3272 | 2020-08-25 04:28:02 | Tasmania, Australia | ||
2990988 | 2990988 | 2020-08-24 | Australia | Victoria | 18464 | 438 | 14077 | 3949 | -37.8136 | 144.9631 | 2020-08-25 04:28:02 | Victoria, Australia | ||
2990989 | 2990989 | 2020-08-24 | Australia | Western Australia | 653 | 9 | 635 | 9 | -31.9505 | 115.8605 | 2020-08-25 04:28:02 | Western Australia, Australia | ||
2215377 | 2215377 | 2020-08-23 | Australia | Australian Capital Territory | 113 | 3 | 110 | 0 | -35.4735 | 149.0124 | 2020-08-24 04:27:56 | Australian Capital Territory, Australia | ||
2215378 | 2215378 | 2020-08-23 | Australia | New South Wales | 3988 | 52 | 0 | 3936 | -33.8688 | 151.2093 | 2020-08-24 04:27:56 | New South Wales, Australia | ||
2215379 | 2215379 | 2020-08-23 | Australia | Northern Territory | 33 | 0 | 33 | 0 | -12.4634 | 130.8456 | 2020-08-24 04:27:56 | Northern Territory, Australia | ||
2215380 | 2215380 | 2020-08-23 | Australia | Queensland | 1106 | 6 | 1082 | 18 | -27.4698 | 153.0251 | 2020-08-24 04:27:56 | Queensland, Australia | ||
2215381 | 2215381 | 2020-08-23 | Australia | South Australia | 463 | 4 | 456 | 3 | -34.9285 | 138.6007 | 2020-08-24 04:27:56 | South Australia, Australia | ||
2215382 | 2215382 | 2020-08-23 | Australia | Tasmania | 230 | 13 | 216 | 1 | -42.8821 | 147.3272 | 2020-08-24 04:27:56 | Tasmania, Australia | ||
2215383 | 2215383 | 2020-08-23 | Australia | Victoria | 18330 | 430 | 13708 | 4192 | -37.8136 | 144.9631 | 2020-08-24 04:27:56 | Victoria, Australia | ||
2215384 | 2215384 | 2020-08-23 | Australia | Western Australia | 652 | 9 | 634 | 9 | -31.9505 | 115.8605 | 2020-08-24 04:27:56 | Western Australia, Australia | ||
2299159 | 2299159 | 2020-08-22 | Australia | Australian Capital Territory | 113 | 3 | 110 | 0 | -35.4735 | 149.0124 | 2020-08-23 04:27:48 | Australian Capital Territory, Australia | ||
2299160 | 2299160 | 2020-08-22 | Australia | New South Wales | 3985 | 52 | 0 | 3933 | -33.8688 | 151.2093 | 2020-08-23 04:27:48 | New South Wales, Australia | ||
2299161 | 2299161 | 2020-08-22 | Australia | Northern Territory | 33 | 0 | 33 | 0 | -12.4634 | 130.8456 | 2020-08-23 04:27:48 | Northern Territory, Australia | ||
2299162 | 2299162 | 2020-08-22 | Australia | Queensland | 1105 | 6 | 1082 | 17 | -27.4698 | 153.0251 | 2020-08-23 04:27:48 | Queensland, Australia | ||
2299163 | 2299163 | 2020-08-22 | Australia | South Australia | 462 | 4 | 452 | 6 | -34.9285 | 138.6007 | 2020-08-23 04:27:48 | South Australia, Australia | ||
2299164 | 2299164 | 2020-08-22 | Australia | Tasmania | 230 | 13 | 216 | 1 | -42.8821 | 147.3272 | 2020-08-23 04:27:48 | Tasmania, Australia | ||
2299165 | 2299165 | 2020-08-22 | Australia | Victoria | 18231 | 415 | 13239 | 4577 | -37.8136 | 144.9631 | 2020-08-23 04:27:48 | Victoria, Australia | ||
2299166 | 2299166 | 2020-08-22 | Australia | Western Australia | 652 | 9 | 634 | 9 | -31.9505 | 115.8605 | 2020-08-23 04:27:48 | 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]);