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 145
- New South Wales 144
- Queensland 141
- South Australia 140
- Western Australia 112
- Tasmania 110
- Northern Territory 107
- Australian Capital Territory 98
- From Diamond Princess 30
- External territories 1
- Jervis Bay Territory 1
country_or_region 1
- Australia · 1,032 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1691695 | 1691695 | 2020-06-19 | Australia | South Australia | 440 | 4 | 436 | 0 | -34.9285 | 138.6007 | 2020-06-20 04:33:19 | South Australia, Australia | ||
1691708 | 1691708 | 2020-06-19 | Australia | Tasmania | 228 | 13 | 215 | 0 | -42.8821 | 147.3272 | 2020-06-20 04:33:19 | Tasmania, Australia | ||
1691759 | 1691759 | 2020-06-19 | Australia | Victoria | 1792 | 19 | 1680 | 93 | -37.8136 | 144.9631 | 2020-06-20 04:33:19 | Victoria, Australia | ||
1691770 | 1691770 | 2020-06-19 | Australia | Western Australia | 604 | 9 | 592 | 3 | -31.9505 | 115.8605 | 2020-06-20 04:33:19 | Western Australia, Australia | ||
3682462 | 3682462 | 2020-06-18 | Australia | Australian Capital Territory | 108 | 3 | 105 | 0 | -35.4735 | 149.0124 | 2020-06-19 04:33:17 | Australian Capital Territory, Australia | ||
3682723 | 3682723 | 2020-06-18 | Australia | New South Wales | 3143 | 48 | 2770 | 325 | -33.8688 | 151.2093 | 2020-06-19 04:33:17 | New South Wales, Australia | ||
3682735 | 3682735 | 2020-06-18 | Australia | Northern Territory | 29 | 0 | 29 | 0 | -12.4634 | 130.8456 | 2020-06-19 04:33:17 | Northern Territory, Australia | ||
3682785 | 3682785 | 2020-06-18 | Australia | Queensland | 1066 | 6 | 1053 | 7 | -27.4698 | 153.0251 | 2020-06-19 04:33:17 | Queensland, Australia | ||
3682844 | 3682844 | 2020-06-18 | Australia | South Australia | 440 | 4 | 436 | 0 | -34.9285 | 138.6007 | 2020-06-19 04:33:17 | South Australia, Australia | ||
3682857 | 3682857 | 2020-06-18 | Australia | Tasmania | 228 | 13 | 215 | 0 | -42.8821 | 147.3272 | 2020-06-19 04:33:17 | Tasmania, Australia | ||
3682908 | 3682908 | 2020-06-18 | Australia | Victoria | 1792 | 19 | 1678 | 95 | -37.8136 | 144.9631 | 2020-06-19 04:33:17 | Victoria, Australia | ||
3682919 | 3682919 | 2020-06-18 | Australia | Western Australia | 603 | 9 | 592 | 2 | -31.9505 | 115.8605 | 2020-06-19 04:33:17 | Western Australia, Australia | ||
1195665 | 1195665 | 2020-06-17 | Australia | Australian Capital Territory | 108 | 3 | 105 | 0 | -35.4735 | 149.0124 | 2020-06-18 04:33:18 | Australian Capital Territory, Australia | ||
1195926 | 1195926 | 2020-06-17 | Australia | New South Wales | 3137 | 48 | 2770 | 319 | -33.8688 | 151.2093 | 2020-06-18 04:33:18 | New South Wales, Australia | ||
1195938 | 1195938 | 2020-06-17 | Australia | Northern Territory | 29 | 0 | 29 | 0 | -12.4634 | 130.8456 | 2020-06-18 04:33:18 | Northern Territory, Australia | ||
1195988 | 1195988 | 2020-06-17 | Australia | Queensland | 1066 | 6 | 1052 | 8 | -27.4698 | 153.0251 | 2020-06-18 04:33:18 | Queensland, Australia | ||
1196047 | 1196047 | 2020-06-17 | Australia | South Australia | 440 | 4 | 436 | 0 | -34.9285 | 138.6007 | 2020-06-18 04:33:18 | South Australia, Australia | ||
1196060 | 1196060 | 2020-06-17 | Australia | Tasmania | 228 | 13 | 215 | 0 | -42.8821 | 147.3272 | 2020-06-18 04:33:18 | Tasmania, Australia | ||
1196111 | 1196111 | 2020-06-17 | Australia | Victoria | 1780 | 19 | 1678 | 83 | -37.8136 | 144.9631 | 2020-06-18 04:33:18 | Victoria, Australia | ||
1196122 | 1196122 | 2020-06-17 | Australia | Western Australia | 603 | 9 | 592 | 2 | -31.9505 | 115.8605 | 2020-06-18 04:33:18 | Western Australia, Australia | ||
2386428 | 2386428 | 2020-06-16 | Australia | Australian Capital Territory | 108 | 3 | 105 | 0 | -35.4735 | 149.0124 | 2020-06-17 04:33:21 | Australian Capital Territory, Australia | ||
2386689 | 2386689 | 2020-06-16 | Australia | New South Wales | 3135 | 48 | 2770 | 317 | -33.8688 | 151.2093 | 2020-06-17 04:33:21 | New South Wales, Australia | ||
2386701 | 2386701 | 2020-06-16 | Australia | Northern Territory | 29 | 0 | 29 | 0 | -12.4634 | 130.8456 | 2020-06-17 04:33:21 | Northern Territory, Australia | ||
2386751 | 2386751 | 2020-06-16 | Australia | Queensland | 1066 | 6 | 1052 | 8 | -27.4698 | 153.0251 | 2020-06-17 04:33:21 | Queensland, Australia | ||
2386810 | 2386810 | 2020-06-16 | Australia | South Australia | 440 | 4 | 436 | 0 | -34.9285 | 138.6007 | 2020-06-17 04:33:21 | South Australia, Australia | ||
2386823 | 2386823 | 2020-06-16 | Australia | Tasmania | 228 | 13 | 213 | 2 | -42.8821 | 147.3272 | 2020-06-17 04:33:21 | Tasmania, Australia | ||
2386874 | 2386874 | 2020-06-16 | Australia | Victoria | 1762 | 19 | 1664 | 79 | -37.8136 | 144.9631 | 2020-06-17 04:33:21 | Victoria, Australia | ||
2386885 | 2386885 | 2020-06-16 | Australia | Western Australia | 602 | 9 | 592 | 1 | -31.9505 | 115.8605 | 2020-06-17 04:33:21 | Western Australia, Australia | ||
286991 | 286991 | 2020-06-15 | Australia | Australian Capital Territory | 108 | 3 | 104 | 1 | -35.4735 | 149.0124 | 2020-06-16 04:33:09 | Australian Capital Territory, Australia | ||
287252 | 287252 | 2020-06-15 | Australia | New South Wales | 3134 | 48 | 2768 | 318 | -33.8688 | 151.2093 | 2020-06-16 04:33:09 | New South Wales, Australia | ||
287264 | 287264 | 2020-06-15 | Australia | Northern Territory | 29 | 0 | 29 | 0 | -12.4634 | 130.8456 | 2020-06-16 04:33:09 | Northern Territory, Australia | ||
287314 | 287314 | 2020-06-15 | Australia | Queensland | 1065 | 6 | 1051 | 8 | -27.4698 | 153.0251 | 2020-06-16 04:33:09 | Queensland, Australia | ||
287373 | 287373 | 2020-06-15 | Australia | South Australia | 440 | 4 | 436 | 0 | -34.9285 | 138.6007 | 2020-06-16 04:33:09 | South Australia, Australia | ||
287386 | 287386 | 2020-06-15 | Australia | Tasmania | 228 | 13 | 213 | 2 | -42.8821 | 147.3272 | 2020-06-16 04:33:09 | Tasmania, Australia | ||
287437 | 287437 | 2020-06-15 | Australia | Victoria | 1741 | 19 | 1664 | 58 | -37.8136 | 144.9631 | 2020-06-16 04:33:09 | Victoria, Australia | ||
287448 | 287448 | 2020-06-15 | Australia | Western Australia | 602 | 9 | 591 | 2 | -31.9505 | 115.8605 | 2020-06-16 04:33:09 | Western Australia, Australia | ||
1836942 | 1836942 | 2020-06-14 | Australia | Australian Capital Territory | 108 | 3 | 104 | 1 | -35.4735 | 149.0124 | 2020-06-15 03:33:14 | Australian Capital Territory, Australia | ||
1837203 | 1837203 | 2020-06-14 | Australia | New South Wales | 3131 | 48 | 2766 | 317 | -33.8688 | 151.2093 | 2020-06-15 03:33:14 | New South Wales, Australia | ||
1837215 | 1837215 | 2020-06-14 | Australia | Northern Territory | 29 | 0 | 29 | 0 | -12.4634 | 130.8456 | 2020-06-15 03:33:14 | Northern Territory, Australia | ||
1837265 | 1837265 | 2020-06-14 | Australia | Queensland | 1065 | 6 | 1051 | 8 | -27.4698 | 153.0251 | 2020-06-15 03:33:14 | Queensland, Australia | ||
1837324 | 1837324 | 2020-06-14 | Australia | South Australia | 440 | 4 | 436 | 0 | -34.9285 | 138.6007 | 2020-06-15 03:33:14 | South Australia, Australia | ||
1837337 | 1837337 | 2020-06-14 | Australia | Tasmania | 228 | 13 | 213 | 2 | -42.8821 | 147.3272 | 2020-06-15 03:33:14 | Tasmania, Australia | ||
1837388 | 1837388 | 2020-06-14 | Australia | Victoria | 1732 | 19 | 1661 | 52 | -37.8136 | 144.9631 | 2020-06-15 03:33:14 | Victoria, Australia | ||
1837399 | 1837399 | 2020-06-14 | Australia | Western Australia | 602 | 9 | 591 | 2 | -31.9505 | 115.8605 | 2020-06-15 03:33:14 | Western Australia, Australia | ||
3060994 | 3060994 | 2020-06-13 | Australia | Australian Capital Territory | 108 | 3 | 104 | 1 | -35.4735 | 149.0124 | 2020-06-14 03:33:15 | Australian Capital Territory, Australia | ||
3061255 | 3061255 | 2020-06-13 | Australia | New South Wales | 3128 | 48 | 2766 | 314 | -33.8688 | 151.2093 | 2020-06-14 03:33:15 | New South Wales, Australia | ||
3061267 | 3061267 | 2020-06-13 | Australia | Northern Territory | 29 | 0 | 29 | 0 | -12.4634 | 130.8456 | 2020-06-14 03:33:15 | Northern Territory, Australia | ||
3061317 | 3061317 | 2020-06-13 | Australia | Queensland | 1065 | 6 | 1051 | 8 | -27.4698 | 153.0251 | 2020-06-14 03:33:15 | Queensland, Australia | ||
3061376 | 3061376 | 2020-06-13 | Australia | South Australia | 440 | 4 | 436 | 0 | -34.9285 | 138.6007 | 2020-06-14 03:33:15 | South Australia, Australia | ||
3061389 | 3061389 | 2020-06-13 | Australia | Tasmania | 228 | 13 | 213 | 2 | -42.8821 | 147.3272 | 2020-06-14 03:33:15 | Tasmania, Australia | ||
3061440 | 3061440 | 2020-06-13 | Australia | Victoria | 1720 | 19 | 1657 | 44 | -37.8136 | 144.9631 | 2020-06-14 03:33:15 | Victoria, Australia | ||
3061451 | 3061451 | 2020-06-13 | Australia | Western Australia | 602 | 9 | 582 | 11 | -31.9505 | 115.8605 | 2020-06-14 03:33:15 | Western Australia, Australia | ||
737314 | 737314 | 2020-06-12 | Australia | Australian Capital Territory | 108 | 3 | 104 | 1 | -35.4735 | 149.0124 | 2020-06-13 03:33:14 | Australian Capital Territory, Australia | ||
737575 | 737575 | 2020-06-12 | Australia | New South Wales | 3119 | 48 | 2763 | 308 | -33.8688 | 151.2093 | 2020-06-13 03:33:14 | New South Wales, Australia | ||
737587 | 737587 | 2020-06-12 | Australia | Northern Territory | 29 | 0 | 29 | 0 | -12.4634 | 130.8456 | 2020-06-13 03:33:14 | Northern Territory, Australia | ||
737637 | 737637 | 2020-06-12 | Australia | Queensland | 1065 | 6 | 1051 | 8 | -27.4698 | 153.0251 | 2020-06-13 03:33:14 | Queensland, Australia | ||
737696 | 737696 | 2020-06-12 | Australia | South Australia | 440 | 4 | 436 | 0 | -34.9285 | 138.6007 | 2020-06-13 03:33:14 | South Australia, Australia | ||
737709 | 737709 | 2020-06-12 | Australia | Tasmania | 228 | 13 | 213 | 2 | -42.8821 | 147.3272 | 2020-06-13 03:33:14 | Tasmania, Australia | ||
737760 | 737760 | 2020-06-12 | Australia | Victoria | 1703 | 19 | 1632 | 52 | -37.8136 | 144.9631 | 2020-06-13 03:33:14 | Victoria, Australia | ||
737771 | 737771 | 2020-06-12 | Australia | Western Australia | 602 | 9 | 575 | 18 | -31.9505 | 115.8605 | 2020-06-13 03:33:14 | Western Australia, Australia | ||
1273284 | 1273284 | 2020-06-11 | Australia | Australian Capital Territory | 108 | 3 | 104 | 1 | -35.4735 | 149.0124 | 2020-06-12 05:09:52 | Australian Capital Territory, Australia | ||
1273545 | 1273545 | 2020-06-11 | Australia | New South Wales | 3115 | 48 | 2743 | 324 | -33.8688 | 151.2093 | 2020-06-12 05:09:52 | New South Wales, Australia | ||
1273557 | 1273557 | 2020-06-11 | Australia | Northern Territory | 29 | 0 | 29 | 0 | -12.4634 | 130.8456 | 2020-06-12 05:09:52 | Northern Territory, Australia | ||
1273607 | 1273607 | 2020-06-11 | Australia | Queensland | 1064 | 6 | 1051 | 7 | -27.4698 | 153.0251 | 2020-06-12 05:09:52 | Queensland, Australia | ||
1273666 | 1273666 | 2020-06-11 | Australia | South Australia | 440 | 4 | 436 | 0 | -34.9285 | 138.6007 | 2020-06-12 05:09:52 | South Australia, Australia | ||
1273679 | 1273679 | 2020-06-11 | Australia | Tasmania | 228 | 13 | 212 | 3 | -42.8821 | 147.3272 | 2020-06-12 05:09:52 | Tasmania, Australia | ||
1273730 | 1273730 | 2020-06-11 | Australia | Victoria | 1703 | 19 | 1632 | 52 | -37.8136 | 144.9631 | 2020-06-12 05:09:52 | Victoria, Australia | ||
1273741 | 1273741 | 2020-06-11 | Australia | Western Australia | 602 | 9 | 575 | 18 | -31.9505 | 115.8605 | 2020-06-12 05:09:52 | Western Australia, Australia | ||
2863728 | 2863728 | 2020-06-10 | Australia | Australian Capital Territory | 108 | 3 | 104 | 1 | -35.4735 | 149.0124 | 2020-06-11 03:33:41 | Australian Capital Territory, Australia | ||
2863988 | 2863988 | 2020-06-10 | Australia | New South Wales | 3117 | 48 | 2738 | 331 | -33.8688 | 151.2093 | 2020-06-11 03:33:41 | New South Wales, Australia | ||
2863999 | 2863999 | 2020-06-10 | Australia | Northern Territory | 29 | 0 | 29 | 0 | -12.4634 | 130.8456 | 2020-06-11 03:33:41 | Northern Territory, Australia | ||
2864049 | 2864049 | 2020-06-10 | Australia | Queensland | 1063 | 6 | 1051 | 6 | -27.4698 | 153.0251 | 2020-06-11 03:33:41 | Queensland, Australia | ||
2864107 | 2864107 | 2020-06-10 | Australia | South Australia | 440 | 4 | 436 | 0 | -34.9285 | 138.6007 | 2020-06-11 03:33:41 | South Australia, Australia | ||
2864120 | 2864120 | 2020-06-10 | Australia | Tasmania | 228 | 13 | 209 | 6 | -42.8821 | 147.3272 | 2020-06-11 03:33:41 | Tasmania, Australia | ||
2864170 | 2864170 | 2020-06-10 | Australia | Victoria | 1699 | 19 | 1621 | 59 | -37.8136 | 144.9631 | 2020-06-11 03:33:41 | Victoria, Australia | ||
2864180 | 2864180 | 2020-06-10 | Australia | Western Australia | 601 | 9 | 571 | 21 | -31.9505 | 115.8605 | 2020-06-11 03:33:41 | Western Australia, Australia | ||
1210584 | 1210584 | 2020-06-09 | Australia | Australian Capital Territory | 108 | 3 | 104 | 1 | -35.4735 | 149.0124 | 2020-06-10 04:07:00 | Australian Capital Territory, Australia | ||
1210819 | 1210819 | 2020-06-09 | Australia | New South Wales | 3117 | 48 | 2735 | 334 | -33.8688 | 151.2093 | 2020-06-10 04:07:00 | New South Wales, Australia | ||
1210830 | 1210830 | 2020-06-09 | Australia | Northern Territory | 29 | 0 | 29 | 0 | -12.4634 | 130.8456 | 2020-06-10 04:07:00 | Northern Territory, Australia | ||
1210876 | 1210876 | 2020-06-09 | Australia | Queensland | 1062 | 6 | 1051 | 5 | -27.4698 | 153.0251 | 2020-06-10 04:07:00 | Queensland, Australia | ||
1210931 | 1210931 | 2020-06-09 | Australia | South Australia | 440 | 4 | 436 | 0 | -34.9285 | 138.6007 | 2020-06-10 04:07:00 | South Australia, Australia | ||
1210943 | 1210943 | 2020-06-09 | Australia | Tasmania | 228 | 13 | 209 | 6 | -42.8821 | 147.3272 | 2020-06-10 04:07:00 | Tasmania, Australia | ||
1210988 | 1210988 | 2020-06-09 | Australia | Victoria | 1691 | 19 | 1616 | 56 | -37.8136 | 144.9631 | 2020-06-10 04:07:00 | Victoria, Australia | ||
1210997 | 1210997 | 2020-06-09 | Australia | Western Australia | 599 | 9 | 560 | 30 | -31.9505 | 115.8605 | 2020-06-10 04:07:00 | Western Australia, Australia | ||
217011 | 217011 | 2020-06-08 | Australia | Australian Capital Territory | 108 | 3 | 104 | 1 | -35.4735 | 149.0124 | 2020-06-09 03:33:03 | Australian Capital Territory, Australia | ||
217246 | 217246 | 2020-06-08 | Australia | New South Wales | 3114 | 48 | 2729 | 337 | -33.8688 | 151.2093 | 2020-06-09 03:33:03 | New South Wales, Australia | ||
217257 | 217257 | 2020-06-08 | Australia | Northern Territory | 29 | 0 | 29 | 0 | -12.4634 | 130.8456 | 2020-06-09 03:33:03 | Northern Territory, Australia | ||
217303 | 217303 | 2020-06-08 | Australia | Queensland | 1062 | 6 | 1051 | 5 | -27.4698 | 153.0251 | 2020-06-09 03:33:03 | Queensland, Australia | ||
217358 | 217358 | 2020-06-08 | Australia | South Australia | 440 | 4 | 436 | 0 | -34.9285 | 138.6007 | 2020-06-09 03:33:03 | South Australia, Australia | ||
217370 | 217370 | 2020-06-08 | Australia | Tasmania | 228 | 13 | 209 | 6 | -42.8821 | 147.3272 | 2020-06-09 03:33:03 | Tasmania, Australia | ||
217415 | 217415 | 2020-06-08 | Australia | Victoria | 1687 | 19 | 1602 | 66 | -37.8136 | 144.9631 | 2020-06-09 03:33:03 | Victoria, Australia | ||
217424 | 217424 | 2020-06-08 | Australia | Western Australia | 599 | 9 | 560 | 30 | -31.9505 | 115.8605 | 2020-06-09 03:33:03 | Western Australia, Australia | ||
2799808 | 2799808 | 2020-06-07 | Australia | Australian Capital Territory | 108 | 3 | 104 | 1 | -35.4735 | 149.0124 | 2020-06-08 03:33:22 | Australian Capital Territory, Australia | ||
2800042 | 2800042 | 2020-06-07 | Australia | New South Wales | 3112 | 48 | 2724 | 340 | -33.8688 | 151.2093 | 2020-06-08 03:33:22 | New South Wales, Australia | ||
2800053 | 2800053 | 2020-06-07 | Australia | Northern Territory | 29 | 0 | 29 | 0 | -12.4634 | 130.8456 | 2020-06-08 03:33:22 | Northern Territory, Australia | ||
2800099 | 2800099 | 2020-06-07 | Australia | Queensland | 1062 | 6 | 1050 | 6 | -27.4698 | 153.0251 | 2020-06-08 03:33:22 | Queensland, Australia | ||
2800154 | 2800154 | 2020-06-07 | Australia | South Australia | 440 | 4 | 436 | 0 | -34.9285 | 138.6007 | 2020-06-08 03:33:22 | South Australia, Australia | ||
2800166 | 2800166 | 2020-06-07 | Australia | Tasmania | 228 | 13 | 209 | 6 | -42.8821 | 147.3272 | 2020-06-08 03:33:22 | Tasmania, Australia | ||
2800212 | 2800212 | 2020-06-07 | Australia | Victoria | 1687 | 19 | 1595 | 73 | -37.8136 | 144.9631 | 2020-06-08 03:33:22 | Victoria, Australia | ||
2800221 | 2800221 | 2020-06-07 | Australia | Western Australia | 599 | 9 | 559 | 31 | -31.9505 | 115.8605 | 2020-06-08 03:33:22 | 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]);