daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
8,420 rows where country_or_region = "Australia" sorted by active descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: latitude, 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-09-18 | Australia | Victoria | 20034 | 757 | 18278 | 999 | -37.8136 | 144.9631 | 2020-09-19 04:22:00 | Victoria, Australia | ||
2021-08-04 | Australia | New South Wales | 10063 | 76 | 0 | 9987 | -33.8688 | 151.2093 | 2021-08-05 04:21:51 | New South Wales, Australia | ||
2021-08-03 | Australia | Victoria | 20955 | 820 | 20036 | 99 | -37.8136 | 144.9631 | 2021-08-04 04:21:25 | Victoria, Australia | ||
2020-09-17 | Australia | Victoria | 20012 | 750 | 18278 | 984 | -37.8136 | 144.9631 | 2020-09-18 05:05:00 | Victoria, Australia | ||
2021-03-26 | Australia | Queensland | 1443 | 6 | 1339 | 98 | -27.4698 | 153.0251 | 2021-03-27 05:25:04 | Queensland, Australia | ||
2020-04-26 | Australia | Queensland | 1030 | 6 | 926 | 98 | -27.4698 | 153.0251 | 2020-04-27 02:31:20 | Queensland, Australia | ||
2021-08-03 | Australia | New South Wales | 9795 | 71 | 0 | 9724 | -33.8688 | 151.2093 | 2021-08-04 04:21:25 | New South Wales, Australia | ||
2020-05-21 | Australia | Victoria | 1593 | 18 | 1479 | 96 | -37.8136 | 144.9631 | 2020-05-22 02:36:51 | Victoria, Australia | ||
2020-04-16 | Australia | Tasmania | 169 | 6 | 67 | 96 | -42.8821 | 147.3272 | 2020-04-16 23:38:19 | Tasmania, Australia | ||
2020-05-22 | Australia | Victoria | 1593 | 18 | 1479 | 96 | -37.8136 | 144.9631 | 2020-05-23 02:32:42 | Victoria, Australia | ||
2021-07-19 | Australia | Victoria | 20813 | 820 | 19898 | 95 | -37.8136 | 144.9631 | 2021-07-20 04:21:48 | Victoria, Australia | ||
2020-06-18 | Australia | Victoria | 1792 | 19 | 1678 | 95 | -37.8136 | 144.9631 | 2020-06-19 04:33:17 | Victoria, Australia | ||
2021-08-02 | Australia | New South Wales | 9562 | 69 | 0 | 9493 | -33.8688 | 151.2093 | 2021-08-03 04:21:39 | New South Wales, Australia | ||
2020-04-28 | Australia | Queensland | 1034 | 6 | 934 | 94 | -27.4698 | 153.0251 | 2020-04-29 02:32:29 | Queensland, Australia | ||
2020-03-22 | Australia | South Australia | 100 | 0 | 6 | 94 | -34.9285 | 138.6007 | 3/22/20 23:48 | South Australia, Australia | ||
2020-05-04 | Australia | Victoria | 1423 | 18 | 1311 | 94 | -37.8136 | 144.9631 | 2020-05-05 02:32:34 | Victoria, Australia | ||
2020-07-08 | Australia | Victoria | 3098 | 22 | 2142 | 934 | -37.8136 | 144.9631 | 2020-07-09 04:34:23 | Victoria, Australia | ||
2020-06-19 | Australia | Victoria | 1792 | 19 | 1680 | 93 | -37.8136 | 144.9631 | 2020-06-20 04:33:19 | Victoria, Australia | ||
2021-08-01 | Australia | New South Wales | 9360 | 69 | 0 | 9291 | -33.8688 | 151.2093 | 2021-08-02 04:21:36 | New South Wales, Australia | ||
2021-06-06 | Australia | Victoria | 20646 | 820 | 19734 | 92 | -37.8136 | 144.9631 | 2021-06-07 04:22:51 | Victoria, Australia | ||
2020-04-13 | Australia | Tasmania | 144 | 5 | 48 | 91 | -42.8821 | 147.3272 | 2020-04-13 23:15:42 | Tasmania, Australia | ||
2021-03-25 | Australia | Queensland | 1436 | 6 | 1339 | 91 | -27.4698 | 153.0251 | 2021-03-26 05:26:55 | Queensland, Australia | ||
2021-06-07 | Australia | Victoria | 20649 | 820 | 19738 | 91 | -37.8136 | 144.9631 | 2021-06-08 04:22:35 | Victoria, Australia | ||
2021-07-31 | Australia | New South Wales | 9153 | 68 | 0 | 9085 | -33.8688 | 151.2093 | 2021-08-01 04:21:50 | New South Wales, Australia | ||
2020-09-19 | Australia | Victoria | 20042 | 761 | 18379 | 902 | -37.8136 | 144.9631 | 2020-09-20 04:22:00 | Victoria, Australia | ||
2021-07-10 | Australia | Queensland | 1738 | 7 | 1641 | 90 | -27.4698 | 153.0251 | 2021-07-11 04:21:43 | Queensland, Australia | ||
2020-05-20 | Australia | Victoria | 1581 | 18 | 1473 | 90 | -37.8136 | 144.9631 | 2020-05-21 02:32:48 | Victoria, Australia | ||
2021-08-01 | Australia | Queensland | 1824 | 7 | 1727 | 90 | -27.4698 | 153.0251 | 2021-08-02 04:21:36 | Queensland, Australia | ||
2020-06-03 | Australia | Victoria | 1678 | 19 | 1569 | 90 | -37.8136 | 144.9631 | 2020-06-04 02:33:14 | Victoria, Australia | ||
2020-05-08 | Australia | Western Australia | 552 | 9 | 534 | 9 | -31.9505 | 115.8605 | 2020-05-09 02:32:35 | Western Australia, Australia | ||
2020-08-19 | Australia | Western Australia | 651 | 9 | 633 | 9 | -31.9505 | 115.8605 | 2020-08-20 04:27:43 | Western Australia, Australia | ||
2021-02-24 | Australia | Queensland | 1324 | 6 | 1309 | 9 | -27.4698 | 153.0251 | 2021-02-25 05:24:57 | Queensland, Australia | ||
2020-08-08 | Australia | South Australia | 459 | 4 | 446 | 9 | -34.9285 | 138.6007 | 2020-08-09 04:34:54 | South Australia, Australia | ||
2020-07-05 | Australia | Western Australia | 618 | 9 | 600 | 9 | -31.9505 | 115.8605 | 2020-07-06 04:33:57 | Western Australia, Australia | ||
2021-07-13 | Australia | Northern Territory | 189 | 0 | 180 | 9 | -12.4634 | 130.8456 | 2021-07-14 04:21:35 | Northern Territory, Australia | ||
2021-07-13 | Australia | Western Australia | 1036 | 9 | 1018 | 9 | -31.9505 | 115.8605 | 2021-07-14 04:21:35 | Western Australia, Australia | ||
2020-08-13 | Australia | Queensland | 1091 | 6 | 1076 | 9 | -27.4698 | 153.0251 | 2020-08-14 04:51:19 | Queensland, Australia | ||
2021-04-09 | Australia | Western Australia | 951 | 9 | 933 | 9 | -31.9505 | 115.8605 | 2021-04-10 04:20:59 | Western Australia, Australia | ||
2021-02-08 | Australia | Western Australia | 907 | 9 | 889 | 9 | -31.9505 | 115.8605 | 2021-02-09 05:23:30 | Western Australia, Australia | ||
2020-12-02 | Australia | South Australia | 562 | 4 | 549 | 9 | -34.9285 | 138.6007 | 2020-12-03 05:28:22 | South Australia, Australia | ||
2021-07-08 | Australia | Northern Territory | 186 | 0 | 177 | 9 | -12.4634 | 130.8456 | 2021-07-09 04:21:21 | Northern Territory, Australia | ||
2020-12-21 | Australia | Northern Territory | 71 | 0 | 62 | 9 | -12.4634 | 130.8456 | 2020-12-22 05:22:33 | Northern Territory, Australia | ||
2020-09-29 | Australia | Queensland | 1157 | 6 | 1142 | 9 | -27.4698 | 153.0251 | 2020-09-30 04:23:33 | Queensland, Australia | ||
2021-01-20 | Australia | Northern Territory | 96 | 0 | 87 | 9 | -12.4634 | 130.8456 | 2021-01-21 05:22:01 | Northern Territory, Australia | ||
2021-07-24 | Australia | Western Australia | 1048 | 9 | 1030 | 9 | -31.9505 | 115.8605 | 2021-07-25 04:22:12 | Western Australia, Australia | ||
2021-02-15 | Australia | Queensland | 1320 | 6 | 1305 | 9 | -27.4698 | 153.0251 | 2021-02-16 05:24:38 | Queensland, Australia | ||
2021-07-25 | Australia | Western Australia | 1048 | 9 | 1030 | 9 | -31.9505 | 115.8605 | 2021-07-26 04:21:28 | Western Australia, Australia | ||
2021-01-31 | Australia | Queensland | 1310 | 6 | 1295 | 9 | -27.4698 | 153.0251 | 2021-02-01 05:22:53 | Queensland, Australia | ||
2020-08-21 | Australia | Western Australia | 651 | 9 | 633 | 9 | -31.9505 | 115.8605 | 2020-08-22 04:27:49 | Western Australia, Australia | ||
2021-07-03 | Australia | Western Australia | 1029 | 9 | 1011 | 9 | -31.9505 | 115.8605 | 2021-07-04 04:21:38 | Western Australia, Australia | ||
2020-08-28 | Australia | Western Australia | 655 | 9 | 637 | 9 | -31.9505 | 115.8605 | 2020-08-29 04:28:19 | Western Australia, Australia | ||
2021-03-13 | Australia | Western Australia | 924 | 9 | 906 | 9 | -31.9505 | 115.8605 | 2021-03-14 05:25:37 | Western Australia, Australia | ||
2021-02-02 | Australia | Western Australia | 904 | 9 | 886 | 9 | -31.9505 | 115.8605 | 2021-02-03 05:22:52 | Western Australia, Australia | ||
2021-03-12 | Australia | Western Australia | 923 | 9 | 905 | 9 | -31.9505 | 115.8605 | 2021-03-13 05:25:15 | Western Australia, Australia | ||
2020-11-09 | Australia | Queensland | 1178 | 6 | 1163 | 9 | -27.4698 | 153.0251 | 2020-11-10 05:40:07 | Queensland, Australia | ||
2021-07-02 | Australia | Western Australia | 1029 | 9 | 1011 | 9 | -31.9505 | 115.8605 | 2021-07-03 04:21:37 | Western Australia, Australia | ||
2020-12-17 | Australia | Northern Territory | 68 | 0 | 59 | 9 | -12.4634 | 130.8456 | 2020-12-18 05:28:18 | Northern Territory, Australia | ||
2020-08-23 | Australia | Western Australia | 652 | 9 | 634 | 9 | -31.9505 | 115.8605 | 2020-08-24 04:27:56 | Western Australia, Australia | ||
2021-05-19 | Australia | South Australia | 746 | 4 | 733 | 9 | -34.9285 | 138.6007 | 2021-05-20 04:21:05 | South Australia, Australia | ||
2021-02-14 | Australia | Queensland | 1320 | 6 | 1305 | 9 | -27.4698 | 153.0251 | 2021-02-15 05:24:49 | Queensland, Australia | ||
2021-06-24 | Australia | South Australia | 792 | 4 | 779 | 9 | -34.9285 | 138.6007 | 2021-06-25 04:21:33 | South Australia, Australia | ||
2020-08-22 | Australia | Western Australia | 652 | 9 | 634 | 9 | -31.9505 | 115.8605 | 2020-08-23 04:27:48 | Western Australia, Australia | ||
2021-05-18 | Australia | South Australia | 746 | 4 | 733 | 9 | -34.9285 | 138.6007 | 2021-05-19 04:20:42 | South Australia, Australia | ||
2020-08-27 | Australia | Western Australia | 655 | 9 | 637 | 9 | -31.9505 | 115.8605 | 2020-08-28 04:28:11 | Western Australia, Australia | ||
2021-04-15 | Australia | South Australia | 678 | 4 | 665 | 9 | -34.9285 | 138.6007 | 2021-04-16 04:20:46 | South Australia, Australia | ||
2021-06-27 | Australia | South Australia | 794 | 4 | 781 | 9 | -34.9285 | 138.6007 | 2021-06-28 04:21:29 | South Australia, Australia | ||
2020-09-24 | Australia | Western Australia | 668 | 9 | 650 | 9 | -31.9505 | 115.8605 | 2020-09-25 04:23:00 | Western Australia, Australia | ||
2020-09-25 | Australia | Queensland | 1156 | 6 | 1141 | 9 | -27.4698 | 153.0251 | 2020-09-26 04:23:00 | Queensland, Australia | ||
2020-09-25 | Australia | Western Australia | 668 | 9 | 650 | 9 | -31.9505 | 115.8605 | 2020-09-26 04:23:00 | Western Australia, Australia | ||
2020-12-09 | Australia | Northern Territory | 61 | 0 | 52 | 9 | -12.4634 | 130.8456 | 2020-12-10 05:26:19 | Northern Territory, Australia | ||
2020-08-24 | Australia | Western Australia | 653 | 9 | 635 | 9 | -31.9505 | 115.8605 | 2020-08-25 04:28:02 | Western Australia, Australia | ||
2021-04-06 | Australia | South Australia | 662 | 4 | 649 | 9 | -34.9285 | 138.6007 | 2021-04-07 04:20:53 | South Australia, Australia | ||
2021-08-01 | Australia | Northern Territory | 200 | 0 | 191 | 9 | -12.4634 | 130.8456 | 2021-08-02 04:21:36 | Northern Territory, Australia | ||
2020-12-16 | Australia | Northern Territory | 68 | 0 | 59 | 9 | -12.4634 | 130.8456 | 2020-12-17 05:28:12 | Northern Territory, Australia | ||
2020-11-16 | Australia | Queensland | 1186 | 6 | 1171 | 9 | -27.4698 | 153.0251 | 2020-11-17 05:25:54 | Queensland, Australia | ||
2020-07-28 | Australia | Queensland | 1078 | 6 | 1063 | 9 | -27.4698 | 153.0251 | 2020-07-29 04:35:11 | Queensland, Australia | ||
2021-07-26 | Australia | Western Australia | 1048 | 9 | 1030 | 9 | -31.9505 | 115.8605 | 2021-07-27 04:21:18 | Western Australia, Australia | ||
2020-05-07 | Australia | Western Australia | 552 | 9 | 534 | 9 | -31.9505 | 115.8605 | 2020-05-08 02:32:32 | Western Australia, Australia | ||
2020-08-20 | Australia | Western Australia | 651 | 9 | 633 | 9 | -31.9505 | 115.8605 | 2020-08-21 04:27:41 | Western Australia, Australia | ||
2021-01-17 | Australia | Northern Territory | 93 | 0 | 84 | 9 | -12.4634 | 130.8456 | 2021-01-18 05:22:34 | Northern Territory, Australia | ||
2021-07-14 | Australia | Western Australia | 1036 | 9 | 1018 | 9 | -31.9505 | 115.8605 | 2021-07-15 04:21:48 | Western Australia, Australia | ||
2020-05-30 | Australia | Tasmania | 228 | 13 | 206 | 9 | -42.8821 | 147.3272 | 2020-05-31 02:32:45 | Tasmania, Australia | ||
2021-03-09 | Australia | Western Australia | 921 | 9 | 903 | 9 | -31.9505 | 115.8605 | 2021-03-10 05:24:35 | Western Australia, Australia | ||
2021-08-02 | Australia | Northern Territory | 200 | 0 | 191 | 9 | -12.4634 | 130.8456 | 2021-08-03 04:21:39 | Northern Territory, Australia | ||
2021-07-12 | Australia | Northern Territory | 189 | 0 | 180 | 9 | -12.4634 | 130.8456 | 2021-07-13 04:21:18 | Northern Territory, Australia | ||
2021-07-12 | Australia | Western Australia | 1036 | 9 | 1018 | 9 | -31.9505 | 115.8605 | 2021-07-13 04:21:18 | Western Australia, Australia | ||
2020-12-22 | Australia | Northern Territory | 71 | 0 | 62 | 9 | -12.4634 | 130.8456 | 2020-12-23 05:22:03 | Northern Territory, Australia | ||
2020-12-22 | Australia | Western Australia | 846 | 9 | 828 | 9 | -31.9505 | 115.8605 | 2020-12-23 05:22:03 | Western Australia, Australia | ||
2020-04-05 | Australia | Queensland | 907 | 4 | 8 | 895 | -27.4698 | 153.0251 | 2020-04-05 23:13:44 | Queensland, Australia | ||
2021-07-09 | Australia | Queensland | 1737 | 7 | 1641 | 89 | -27.4698 | 153.0251 | 2021-07-10 04:21:25 | Queensland, Australia | ||
2020-04-04 | Australia | Queensland | 900 | 4 | 8 | 888 | -27.4698 | 153.0251 | 4/4/20 23:41 | Queensland, Australia | ||
2021-07-30 | Australia | New South Wales | 8915 | 68 | 0 | 8847 | -33.8688 | 151.2093 | 2021-07-31 04:21:35 | New South Wales, Australia | ||
2020-05-03 | Australia | Victoria | 1406 | 18 | 1300 | 88 | -37.8136 | 144.9631 | 2020-05-04 02:32:28 | Victoria, Australia | ||
2021-07-29 | Australia | New South Wales | 8703 | 67 | 0 | 8636 | -33.8688 | 151.2093 | 2021-07-30 04:21:34 | New South Wales, Australia | ||
2020-07-07 | Australia | Victoria | 2942 | 22 | 2058 | 862 | -37.8136 | 144.9631 | 2020-07-08 05:33:48 | Victoria, Australia | ||
2020-04-03 | Australia | Queensland | 873 | 4 | 8 | 861 | -27.4698 | 153.0251 | 2020-04-03 22:52:45 | Queensland, Australia | ||
2020-05-23 | Australia | Victoria | 1603 | 19 | 1498 | 86 | -37.8136 | 144.9631 | 2020-05-24 02:32:43 | Victoria, Australia | ||
2021-03-24 | Australia | Queensland | 1429 | 6 | 1338 | 85 | -27.4698 | 153.0251 | 2021-03-25 05:27:00 | Queensland, Australia | ||
2020-08-11 | Australia | Victoria | 15646 | 267 | 6889 | 8490 | -37.8136 | 144.9631 | 2020-08-12 04:27:29 | Victoria, Australia | ||
2021-07-28 | Australia | New South Wales | 8531 | 67 | 0 | 8464 | -33.8688 | 151.2093 | 2021-07-29 04:21:33 | New South Wales, Australia |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;