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 admin2
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state 11
- Victoria 1,056
- New South Wales 1,055
- Queensland 1,052
- South Australia 1,051
- Western Australia 1,023
- Tasmania 1,021
- Northern Territory 1,018
- Australian Capital Territory 1,010
- From Diamond Princess 29
- External territories 1
- Jervis Bay Territory 1
country_or_region 1
- Australia · 8,320 ✖
Link | rowid | day | country_or_region | province_or_state | admin2 ▼ | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||
50175 | 50175 | 2020-04-17 | Australia | Australian Capital Territory | 103 | 3 | 81 | 19 | -35.4735 | 149.0124 | 2020-04-17 23:38:48 | Australian Capital Territory, Australia | ||
50221 | 50221 | 2020-04-17 | Australia | New South Wales | 2926 | 26 | 1379 | 1521 | -33.8688 | 151.2093 | 2020-04-17 23:38:48 | New South Wales, Australia | ||
50225 | 50225 | 2020-04-17 | Australia | Northern Territory | 28 | 0 | 9 | 19 | -12.4634 | 130.8456 | 2020-04-17 23:38:48 | Northern Territory, Australia | ||
50234 | 50234 | 2020-04-17 | Australia | Queensland | 1007 | 5 | 442 | 560 | -27.4698 | 153.0251 | 2020-04-17 23:38:48 | Queensland, Australia | ||
50248 | 50248 | 2020-04-17 | Australia | South Australia | 435 | 4 | 331 | 100 | -34.9285 | 138.6007 | 2020-04-17 23:38:48 | South Australia, Australia | ||
50250 | 50250 | 2020-04-17 | Australia | Tasmania | 180 | 7 | 67 | 106 | -42.8821 | 147.3272 | 2020-04-17 23:38:48 | Tasmania, Australia | ||
50254 | 50254 | 2020-04-17 | Australia | Victoria | 1302 | 14 | 1159 | 129 | -37.8136 | 144.9631 | 2020-04-17 23:38:48 | Victoria, Australia | ||
50256 | 50256 | 2020-04-17 | Australia | Western Australia | 541 | 7 | 340 | 194 | -31.9505 | 115.8605 | 2020-04-17 23:38:48 | Western Australia, Australia | ||
50486 | 50486 | 2021-05-29 | Australia | Australian Capital Territory | 124 | 3 | 121 | 0 | -35.4735 | 149.0124 | 2021-05-30 04:20:55 | Australian Capital Territory, Australia | ||
50487 | 50487 | 2021-05-29 | Australia | New South Wales | 5585 | 54 | 0 | 5531 | -33.8688 | 151.2093 | 2021-05-30 04:20:55 | New South Wales, Australia | ||
50488 | 50488 | 2021-05-29 | Australia | Northern Territory | 173 | 0 | 169 | 4 | -12.4634 | 130.8456 | 2021-05-30 04:20:55 | Northern Territory, Australia | ||
50489 | 50489 | 2021-05-29 | Australia | Queensland | 1618 | 7 | 1591 | 20 | -27.4698 | 153.0251 | 2021-05-30 04:20:55 | Queensland, Australia | ||
50490 | 50490 | 2021-05-29 | Australia | South Australia | 752 | 4 | 746 | 2 | -34.9285 | 138.6007 | 2021-05-30 04:20:55 | South Australia, Australia | ||
50491 | 50491 | 2021-05-29 | Australia | Tasmania | 234 | 13 | 221 | 0 | -42.8821 | 147.3272 | 2021-05-30 04:20:55 | Tasmania, Australia | ||
50492 | 50492 | 2021-05-29 | Australia | Victoria | 20593 | 820 | 19725 | 48 | -37.8136 | 144.9631 | 2021-05-30 04:20:55 | Victoria, Australia | ||
50493 | 50493 | 2021-05-29 | Australia | Western Australia | 1017 | 9 | 1006 | 2 | -31.9505 | 115.8605 | 2021-05-30 04:20:55 | Western Australia, Australia | ||
54500 | 54500 | 2021-03-07 | Australia | Australian Capital Territory | 122 | 3 | 115 | 4 | -35.4735 | 149.0124 | 2021-03-08 05:24:48 | Australian Capital Territory, Australia | ||
54501 | 54501 | 2021-03-07 | Australia | New South Wales | 5210 | 54 | 0 | 5156 | -33.8688 | 151.2093 | 2021-03-08 05:24:48 | New South Wales, Australia | ||
54502 | 54502 | 2021-03-07 | Australia | Northern Territory | 105 | 0 | 105 | 0 | -12.4634 | 130.8456 | 2021-03-08 05:24:48 | Northern Territory, Australia | ||
54503 | 54503 | 2021-03-07 | Australia | Queensland | 1356 | 6 | 1316 | 34 | -27.4698 | 153.0251 | 2021-03-08 05:24:48 | Queensland, Australia | ||
54504 | 54504 | 2021-03-07 | Australia | South Australia | 618 | 4 | 611 | 3 | -34.9285 | 138.6007 | 2021-03-08 05:24:48 | South Australia, Australia | ||
54505 | 54505 | 2021-03-07 | Australia | Tasmania | 234 | 13 | 221 | 0 | -42.8821 | 147.3272 | 2021-03-08 05:24:48 | Tasmania, Australia | ||
54506 | 54506 | 2021-03-07 | Australia | Victoria | 20482 | 820 | 19658 | 4 | -37.8136 | 144.9631 | 2021-03-08 05:24:48 | Victoria, Australia | ||
54507 | 54507 | 2021-03-07 | Australia | Western Australia | 919 | 9 | 903 | 7 | -31.9505 | 115.8605 | 2021-03-08 05:24:48 | Western Australia, Australia | ||
61778 | 61778 | 2020-07-23 | Australia | Australian Capital Territory | 113 | 3 | 109 | 1 | -35.4735 | 149.0124 | 2020-07-24 05:30:40 | Australian Capital Territory, Australia | ||
62028 | 62028 | 2020-07-23 | Australia | New South Wales | 3640 | 49 | 2988 | 603 | -33.8688 | 151.2093 | 2020-07-24 05:30:40 | New South Wales, Australia | ||
62042 | 62042 | 2020-07-23 | Australia | Northern Territory | 31 | 0 | 30 | 1 | -12.4634 | 130.8456 | 2020-07-24 05:30:40 | Northern Territory, Australia | ||
62089 | 62089 | 2020-07-23 | Australia | Queensland | 1076 | 6 | 1063 | 7 | -27.4698 | 153.0251 | 2020-07-24 05:30:40 | Queensland, Australia | ||
62143 | 62143 | 2020-07-23 | Australia | South Australia | 447 | 4 | 441 | 2 | -34.9285 | 138.6007 | 2020-07-24 05:30:40 | South Australia, Australia | ||
62154 | 62154 | 2020-07-23 | Australia | Tasmania | 229 | 13 | 215 | 1 | -42.8821 | 147.3272 | 2020-07-24 05:30:40 | Tasmania, Australia | ||
62203 | 62203 | 2020-07-23 | Australia | Victoria | 7405 | 55 | 3298 | 4052 | -37.8136 | 144.9631 | 2020-07-24 05:30:40 | Victoria, Australia | ||
62214 | 62214 | 2020-07-23 | Australia | Western Australia | 654 | 9 | 631 | 14 | -31.9505 | 115.8605 | 2020-07-24 05:30:40 | Western Australia, Australia | ||
62530 | 62530 | 2020-03-07 | Australia | New South Wales | 28 | 1 | 4 | -33.8688 | 151.2093 | 2020-03-07T02:03:30 | ||||
62550 | 62550 | 2020-03-07 | Australia | Queensland | 13 | 0 | 8 | -28.0167 | 153.4 | 2020-03-05T17:33:06 | ||||
62555 | 62555 | 2020-03-07 | Australia | Victoria | 11 | 0 | 7 | -37.8136 | 144.9631 | 2020-03-07T02:03:30 | ||||
62564 | 62564 | 2020-03-07 | Australia | South Australia | 7 | 0 | 2 | -34.9285 | 138.6007 | 2020-03-06T04:23:08 | ||||
62585 | 62585 | 2020-03-07 | Australia | Western Australia | 3 | 1 | 0 | -31.9505 | 115.8605 | 2020-03-05T17:13:35 | ||||
62625 | 62625 | 2020-03-07 | Australia | Tasmania | 1 | 0 | 0 | -41.4545 | 145.9707 | 2020-03-02T20:53:02 | ||||
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 | ||||
62741 | 62741 | 2022-11-12 | Australia | Australian Capital Territory | 210609 | 128 | 0 | -35.4735 | 149.0124 | 2022-11-13 04:21:14 | Australian Capital Territory, Australia | |||
62742 | 62742 | 2022-11-12 | Australia | New South Wales | 3581110 | 5476 | 0 | -33.8688 | 151.2093 | 2022-11-13 04:21:14 | New South Wales, Australia | |||
62743 | 62743 | 2022-11-12 | Australia | Northern Territory | 99128 | 79 | 0 | -12.4634 | 130.8456 | 2022-11-13 04:21:14 | Northern Territory, Australia | |||
62744 | 62744 | 2022-11-12 | Australia | Queensland | 1673798 | 2303 | 0 | -27.4698 | 153.0251 | 2022-11-13 04:21:14 | Queensland, Australia | |||
62745 | 62745 | 2022-11-12 | Australia | South Australia | 791713 | 1058 | 0 | -34.9285 | 138.6007 | 2022-11-13 04:21:14 | South Australia, Australia | |||
62746 | 62746 | 2022-11-12 | Australia | Tasmania | 256075 | 199 | 0 | -42.8821 | 147.3272 | 2022-11-13 04:21:14 | Tasmania, Australia | |||
62747 | 62747 | 2022-11-12 | Australia | Victoria | 2677113 | 5907 | 0 | -37.8136 | 144.9631 | 2022-11-13 04:21:14 | Victoria, Australia | |||
62748 | 62748 | 2022-11-12 | Australia | Western Australia | 1189668 | 720 | 0 | -31.9505 | 115.8605 | 2022-11-13 04:21:14 | Western Australia, Australia | |||
66756 | 66756 | 2021-09-01 | Australia | Australian Capital Territory | 433 | 3 | 0 | -35.4735 | 149.0124 | 2021-09-02 04:21:15 | Australian Capital Territory, Australia | |||
66757 | 66757 | 2021-09-01 | Australia | New South Wales | 29390 | 161 | 0 | -33.8688 | 151.2093 | 2021-09-02 04:21:15 | New South Wales, Australia | |||
66758 | 66758 | 2021-09-01 | Australia | Northern Territory | 202 | 0 | 0 | -12.4634 | 130.8456 | 2021-09-02 04:21:15 | Northern Territory, Australia | |||
66759 | 66759 | 2021-09-01 | Australia | Queensland | 1982 | 7 | 0 | -27.4698 | 153.0251 | 2021-09-02 04:21:15 | Queensland, Australia | |||
66760 | 66760 | 2021-09-01 | Australia | South Australia | 871 | 4 | 0 | -34.9285 | 138.6007 | 2021-09-02 04:21:15 | South Australia, Australia | |||
66761 | 66761 | 2021-09-01 | Australia | Tasmania | 235 | 13 | 0 | -42.8821 | 147.3272 | 2021-09-02 04:21:15 | Tasmania, Australia | |||
66762 | 66762 | 2021-09-01 | Australia | Victoria | 22361 | 822 | 0 | -37.8136 | 144.9631 | 2021-09-02 04:21:15 | Victoria, Australia | |||
66763 | 66763 | 2021-09-01 | Australia | Western Australia | 1086 | 9 | 0 | -31.9505 | 115.8605 | 2021-09-02 04:21:15 | Western Australia, Australia | |||
70770 | 70770 | 2022-02-07 | Australia | Australian Capital Territory | 38698 | 29 | 0 | -35.4735 | 149.0124 | 2022-02-08 04:21:15 | Australian Capital Territory, Australia | |||
70771 | 70771 | 2022-02-07 | Australia | New South Wales | 1154133 | 1596 | 0 | -33.8688 | 151.2093 | 2022-02-08 04:21:15 | New South Wales, Australia | |||
70772 | 70772 | 2022-02-07 | Australia | Northern Territory | 24350 | 5 | 0 | -12.4634 | 130.8456 | 2022-02-08 04:21:15 | Northern Territory, Australia | |||
70773 | 70773 | 2022-02-07 | Australia | Queensland | 462761 | 308 | 0 | -27.4698 | 153.0251 | 2022-02-08 04:21:15 | Queensland, Australia | |||
70774 | 70774 | 2022-02-07 | Australia | South Australia | 131898 | 137 | 0 | -34.9285 | 138.6007 | 2022-02-08 04:21:15 | South Australia, Australia | |||
70775 | 70775 | 2022-02-07 | Australia | Tasmania | 32303 | 20 | 0 | -42.8821 | 147.3272 | 2022-02-08 04:21:15 | Tasmania, Australia | |||
70776 | 70776 | 2022-02-07 | Australia | Victoria | 933989 | 2198 | 0 | -37.8136 | 144.9631 | 2022-02-08 04:21:15 | Victoria, Australia | |||
70777 | 70777 | 2022-02-07 | Australia | Western Australia | 1748 | 9 | 0 | -31.9505 | 115.8605 | 2022-02-08 04:21:15 | Western Australia, Australia | |||
74786 | 74786 | 2020-12-03 | Australia | Australian Capital Territory | 117 | 3 | 112 | 2 | -35.4735 | 149.0124 | 2020-12-04 05:27:27 | Australian Capital Territory, Australia | ||
74787 | 74787 | 2020-12-03 | Australia | New South Wales | 4603 | 53 | 0 | 4550 | -33.8688 | 151.2093 | 2020-12-04 05:27:27 | New South Wales, Australia | ||
74788 | 74788 | 2020-12-03 | Australia | Northern Territory | 59 | 0 | 46 | 13 | -12.4634 | 130.8456 | 2020-12-04 05:27:27 | Northern Territory, Australia | ||
74789 | 74789 | 2020-12-03 | Australia | Queensland | 1208 | 6 | 1190 | 12 | -27.4698 | 153.0251 | 2020-12-04 05:27:27 | Queensland, Australia | ||
74790 | 74790 | 2020-12-03 | Australia | South Australia | 562 | 4 | 551 | 7 | -34.9285 | 138.6007 | 2020-12-04 05:27:27 | South Australia, Australia | ||
74791 | 74791 | 2020-12-03 | Australia | Tasmania | 230 | 13 | 217 | 0 | -42.8821 | 147.3272 | 2020-12-04 05:27:27 | Tasmania, Australia | ||
74792 | 74792 | 2020-12-03 | Australia | Victoria | 20345 | 820 | 19525 | 0 | -37.8136 | 144.9631 | 2020-12-04 05:27:27 | Victoria, Australia | ||
74793 | 74793 | 2020-12-03 | Australia | Western Australia | 825 | 9 | 802 | 14 | -31.9505 | 115.8605 | 2020-12-04 05:27:27 | Western Australia, Australia | ||
78797 | 78797 | 2020-10-14 | Australia | Australian Capital Territory | 113 | 3 | 110 | 0 | -35.4735 | 149.0124 | 2020-10-15 04:24:28 | Australian Capital Territory, Australia | ||
78798 | 78798 | 2020-10-14 | Australia | New South Wales | 4321 | 53 | 0 | 4268 | -33.8688 | 151.2093 | 2020-10-15 04:24:28 | New South Wales, Australia | ||
78799 | 78799 | 2020-10-14 | Australia | Northern Territory | 33 | 0 | 33 | 0 | -12.4634 | 130.8456 | 2020-10-15 04:24:28 | Northern Territory, Australia | ||
78800 | 78800 | 2020-10-14 | Australia | Queensland | 1162 | 6 | 1154 | 2 | -27.4698 | 153.0251 | 2020-10-15 04:24:28 | Queensland, Australia | ||
78801 | 78801 | 2020-10-14 | Australia | South Australia | 479 | 4 | 469 | 6 | -34.9285 | 138.6007 | 2020-10-15 04:24:28 | South Australia, Australia | ||
78802 | 78802 | 2020-10-14 | Australia | Tasmania | 230 | 13 | 217 | 0 | -42.8821 | 147.3272 | 2020-10-15 04:24:28 | Tasmania, Australia | ||
78803 | 78803 | 2020-10-14 | Australia | Victoria | 20315 | 816 | 19248 | 251 | -37.8136 | 144.9631 | 2020-10-15 04:24:28 | Victoria, Australia | ||
78804 | 78804 | 2020-10-14 | Australia | Western Australia | 704 | 9 | 676 | 19 | -31.9505 | 115.8605 | 2020-10-15 04:24:28 | Western Australia, Australia | ||
82790 | 82790 | 2021-05-25 | Australia | Australian Capital Territory | 124 | 3 | 121 | 0 | -35.4735 | 149.0124 | 2021-05-26 04:20:35 | Australian Capital Territory, Australia | ||
82791 | 82791 | 2021-05-25 | Australia | New South Wales | 5576 | 54 | 0 | 5522 | -33.8688 | 151.2093 | 2021-05-26 04:20:35 | New South Wales, Australia | ||
82792 | 82792 | 2021-05-25 | Australia | Northern Territory | 171 | 0 | 169 | 2 | -12.4634 | 130.8456 | 2021-05-26 04:20:35 | Northern Territory, Australia | ||
82793 | 82793 | 2021-05-25 | Australia | Queensland | 1611 | 7 | 1580 | 24 | -27.4698 | 153.0251 | 2021-05-26 04:20:35 | Queensland, Australia | ||
82794 | 82794 | 2021-05-25 | Australia | South Australia | 750 | 4 | 744 | 2 | -34.9285 | 138.6007 | 2021-05-26 04:20:35 | South Australia, Australia | ||
82795 | 82795 | 2021-05-25 | Australia | Tasmania | 234 | 13 | 221 | 0 | -42.8821 | 147.3272 | 2021-05-26 04:20:35 | Tasmania, Australia | ||
82796 | 82796 | 2021-05-25 | Australia | Victoria | 20563 | 820 | 19720 | 23 | -37.8136 | 144.9631 | 2021-05-26 04:20:35 | Victoria, Australia | ||
82797 | 82797 | 2021-05-25 | Australia | Western Australia | 1017 | 9 | 1005 | 3 | -31.9505 | 115.8605 | 2021-05-26 04:20:35 | 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 |
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]);