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 379
- New South Wales 378
- Queensland 375
- South Australia 374
- Western Australia 346
- Tasmania 344
- Northern Territory 341
- Australian Capital Territory 332
- From Diamond Princess 30
- External territories 1
- Jervis Bay Territory 1
country_or_region 1
- Australia · 2,904 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
613388 | 613388 | 2021-02-08 | Australia | South Australia | 603 | 4 | 596 | 3 | -34.9285 | 138.6007 | 2021-02-09 05:23:30 | South Australia, Australia | ||
613389 | 613389 | 2021-02-08 | Australia | Tasmania | 234 | 13 | 221 | 0 | -42.8821 | 147.3272 | 2021-02-09 05:23:30 | Tasmania, Australia | ||
613390 | 613390 | 2021-02-08 | Australia | Victoria | 20456 | 820 | 19621 | 15 | -37.8136 | 144.9631 | 2021-02-09 05:23:30 | Victoria, Australia | ||
613391 | 613391 | 2021-02-08 | Australia | Western Australia | 907 | 9 | 889 | 9 | -31.9505 | 115.8605 | 2021-02-09 05:23:30 | Western Australia, Australia | ||
1672153 | 1672153 | 2021-02-07 | Australia | Australian Capital Territory | 118 | 3 | 115 | 0 | -35.4735 | 149.0124 | 2021-02-08 05:22:39 | Australian Capital Territory, Australia | ||
1672154 | 1672154 | 2021-02-07 | Australia | New South Wales | 5123 | 54 | 0 | 5069 | -33.8688 | 151.2093 | 2021-02-08 05:22:39 | New South Wales, Australia | ||
1672155 | 1672155 | 2021-02-07 | Australia | Northern Territory | 102 | 0 | 98 | 4 | -12.4634 | 130.8456 | 2021-02-08 05:22:39 | Northern Territory, Australia | ||
1672156 | 1672156 | 2021-02-07 | Australia | Queensland | 1314 | 6 | 1297 | 11 | -27.4698 | 153.0251 | 2021-02-08 05:22:39 | Queensland, Australia | ||
1672157 | 1672157 | 2021-02-07 | Australia | South Australia | 603 | 4 | 596 | 3 | -34.9285 | 138.6007 | 2021-02-08 05:22:39 | South Australia, Australia | ||
1672158 | 1672158 | 2021-02-07 | Australia | Tasmania | 234 | 13 | 221 | 0 | -42.8821 | 147.3272 | 2021-02-08 05:22:39 | Tasmania, Australia | ||
1672159 | 1672159 | 2021-02-07 | Australia | Victoria | 20456 | 820 | 19615 | 21 | -37.8136 | 144.9631 | 2021-02-08 05:22:39 | Victoria, Australia | ||
1672160 | 1672160 | 2021-02-07 | Australia | Western Australia | 907 | 9 | 888 | 10 | -31.9505 | 115.8605 | 2021-02-08 05:22:39 | Western Australia, Australia | ||
974614 | 974614 | 2021-02-06 | Australia | Australian Capital Territory | 118 | 3 | 115 | 0 | -35.4735 | 149.0124 | 2021-02-07 05:23:00 | Australian Capital Territory, Australia | ||
974615 | 974615 | 2021-02-06 | Australia | New South Wales | 5120 | 54 | 0 | 5066 | -33.8688 | 151.2093 | 2021-02-07 05:23:00 | New South Wales, Australia | ||
974616 | 974616 | 2021-02-06 | Australia | Northern Territory | 102 | 0 | 98 | 4 | -12.4634 | 130.8456 | 2021-02-07 05:23:00 | Northern Territory, Australia | ||
974617 | 974617 | 2021-02-06 | Australia | Queensland | 1312 | 6 | 1295 | 11 | -27.4698 | 153.0251 | 2021-02-07 05:23:00 | Queensland, Australia | ||
974618 | 974618 | 2021-02-06 | Australia | South Australia | 602 | 4 | 596 | 2 | -34.9285 | 138.6007 | 2021-02-07 05:23:00 | South Australia, Australia | ||
974619 | 974619 | 2021-02-06 | Australia | Tasmania | 234 | 13 | 221 | 0 | -42.8821 | 147.3272 | 2021-02-07 05:23:00 | Tasmania, Australia | ||
974620 | 974620 | 2021-02-06 | Australia | Victoria | 20456 | 820 | 19615 | 21 | -37.8136 | 144.9631 | 2021-02-07 05:23:00 | Victoria, Australia | ||
974621 | 974621 | 2021-02-06 | Australia | Western Australia | 907 | 9 | 887 | 11 | -31.9505 | 115.8605 | 2021-02-07 05:23:00 | Western Australia, Australia | ||
1587872 | 1587872 | 2021-02-05 | Australia | Australian Capital Territory | 118 | 3 | 115 | 0 | -35.4735 | 149.0124 | 2021-02-06 05:23:55 | Australian Capital Territory, Australia | ||
1587873 | 1587873 | 2021-02-05 | Australia | New South Wales | 5119 | 54 | 0 | 5065 | -33.8688 | 151.2093 | 2021-02-06 05:23:55 | New South Wales, Australia | ||
1587874 | 1587874 | 2021-02-05 | Australia | Northern Territory | 101 | 0 | 98 | 3 | -12.4634 | 130.8456 | 2021-02-06 05:23:55 | Northern Territory, Australia | ||
1587875 | 1587875 | 2021-02-05 | Australia | Queensland | 1311 | 6 | 1294 | 11 | -27.4698 | 153.0251 | 2021-02-06 05:23:55 | Queensland, Australia | ||
1587876 | 1587876 | 2021-02-05 | Australia | South Australia | 602 | 4 | 596 | 2 | -34.9285 | 138.6007 | 2021-02-06 05:23:55 | South Australia, Australia | ||
1587877 | 1587877 | 2021-02-05 | Australia | Tasmania | 234 | 13 | 221 | 0 | -42.8821 | 147.3272 | 2021-02-06 05:23:55 | Tasmania, Australia | ||
1587878 | 1587878 | 2021-02-05 | Australia | Victoria | 20456 | 820 | 19614 | 22 | -37.8136 | 144.9631 | 2021-02-06 05:23:55 | Victoria, Australia | ||
1587879 | 1587879 | 2021-02-05 | Australia | Western Australia | 907 | 9 | 887 | 11 | -31.9505 | 115.8605 | 2021-02-06 05:23:55 | Western Australia, Australia | ||
790079 | 790079 | 2021-02-04 | Australia | Australian Capital Territory | 118 | 3 | 115 | 0 | -35.4735 | 149.0124 | 2021-02-05 05:22:38 | Australian Capital Territory, Australia | ||
790080 | 790080 | 2021-02-04 | Australia | New South Wales | 5117 | 54 | 0 | 5063 | -33.8688 | 151.2093 | 2021-02-05 05:22:38 | New South Wales, Australia | ||
790081 | 790081 | 2021-02-04 | Australia | Northern Territory | 99 | 0 | 98 | 1 | -12.4634 | 130.8456 | 2021-02-05 05:22:38 | Northern Territory, Australia | ||
790082 | 790082 | 2021-02-04 | Australia | Queensland | 1309 | 6 | 1293 | 10 | -27.4698 | 153.0251 | 2021-02-05 05:22:38 | Queensland, Australia | ||
790083 | 790083 | 2021-02-04 | Australia | South Australia | 602 | 4 | 596 | 2 | -34.9285 | 138.6007 | 2021-02-05 05:22:38 | South Australia, Australia | ||
790084 | 790084 | 2021-02-04 | Australia | Tasmania | 234 | 13 | 221 | 0 | -42.8821 | 147.3272 | 2021-02-05 05:22:38 | Tasmania, Australia | ||
790085 | 790085 | 2021-02-04 | Australia | Victoria | 20456 | 820 | 19612 | 24 | -37.8136 | 144.9631 | 2021-02-05 05:22:38 | Victoria, Australia | ||
790086 | 790086 | 2021-02-04 | Australia | Western Australia | 907 | 9 | 887 | 11 | -31.9505 | 115.8605 | 2021-02-05 05:22:38 | Western Australia, Australia | ||
339971 | 339971 | 2021-02-03 | Australia | Australian Capital Territory | 118 | 3 | 115 | 0 | -35.4735 | 149.0124 | 2021-02-04 05:22:26 | Australian Capital Territory, Australia | ||
339972 | 339972 | 2021-02-03 | Australia | New South Wales | 5117 | 54 | 0 | 5063 | -33.8688 | 151.2093 | 2021-02-04 05:22:26 | New South Wales, Australia | ||
339973 | 339973 | 2021-02-03 | Australia | Northern Territory | 99 | 0 | 98 | 1 | -12.4634 | 130.8456 | 2021-02-04 05:22:26 | Northern Territory, Australia | ||
339974 | 339974 | 2021-02-03 | Australia | Queensland | 1311 | 6 | 1295 | 10 | -27.4698 | 153.0251 | 2021-02-04 05:22:26 | Queensland, Australia | ||
339975 | 339975 | 2021-02-03 | Australia | South Australia | 601 | 4 | 595 | 2 | -34.9285 | 138.6007 | 2021-02-04 05:22:26 | South Australia, Australia | ||
339976 | 339976 | 2021-02-03 | Australia | Tasmania | 234 | 13 | 221 | 0 | -42.8821 | 147.3272 | 2021-02-04 05:22:26 | Tasmania, Australia | ||
339977 | 339977 | 2021-02-03 | Australia | Victoria | 20452 | 820 | 19611 | 21 | -37.8136 | 144.9631 | 2021-02-04 05:22:26 | Victoria, Australia | ||
339978 | 339978 | 2021-02-03 | Australia | Western Australia | 906 | 9 | 887 | 10 | -31.9505 | 115.8605 | 2021-02-04 05:22:26 | Western Australia, Australia | ||
1684197 | 1684197 | 2021-02-02 | Australia | Australian Capital Territory | 118 | 3 | 115 | 0 | -35.4735 | 149.0124 | 2021-02-03 05:22:52 | Australian Capital Territory, Australia | ||
1684198 | 1684198 | 2021-02-02 | Australia | New South Wales | 5114 | 54 | 0 | 5060 | -33.8688 | 151.2093 | 2021-02-03 05:22:52 | New South Wales, Australia | ||
1684199 | 1684199 | 2021-02-02 | Australia | Northern Territory | 98 | 0 | 97 | 1 | -12.4634 | 130.8456 | 2021-02-03 05:22:52 | Northern Territory, Australia | ||
1684200 | 1684200 | 2021-02-02 | Australia | Queensland | 1311 | 6 | 1295 | 10 | -27.4698 | 153.0251 | 2021-02-03 05:22:52 | Queensland, Australia | ||
1684201 | 1684201 | 2021-02-02 | Australia | South Australia | 601 | 4 | 592 | 5 | -34.9285 | 138.6007 | 2021-02-03 05:22:52 | South Australia, Australia | ||
1684202 | 1684202 | 2021-02-02 | Australia | Tasmania | 234 | 13 | 221 | 0 | -42.8821 | 147.3272 | 2021-02-03 05:22:52 | Tasmania, Australia | ||
1684203 | 1684203 | 2021-02-02 | Australia | Victoria | 20449 | 820 | 19608 | 21 | -37.8136 | 144.9631 | 2021-02-03 05:22:52 | Victoria, Australia | ||
1684204 | 1684204 | 2021-02-02 | Australia | Western Australia | 904 | 9 | 886 | 9 | -31.9505 | 115.8605 | 2021-02-03 05:22:52 | Western Australia, Australia | ||
1676167 | 1676167 | 2021-02-01 | Australia | Australian Capital Territory | 118 | 3 | 115 | 0 | -35.4735 | 149.0124 | 2021-02-02 05:22:49 | Australian Capital Territory, Australia | ||
1676168 | 1676168 | 2021-02-01 | Australia | New South Wales | 5112 | 54 | 0 | 5058 | -33.8688 | 151.2093 | 2021-02-02 05:22:49 | New South Wales, Australia | ||
1676169 | 1676169 | 2021-02-01 | Australia | Northern Territory | 98 | 0 | 96 | 2 | -12.4634 | 130.8456 | 2021-02-02 05:22:49 | Northern Territory, Australia | ||
1676170 | 1676170 | 2021-02-01 | Australia | Queensland | 1311 | 6 | 1295 | 10 | -27.4698 | 153.0251 | 2021-02-02 05:22:49 | Queensland, Australia | ||
1676171 | 1676171 | 2021-02-01 | Australia | South Australia | 597 | 4 | 592 | 1 | -34.9285 | 138.6007 | 2021-02-02 05:22:49 | South Australia, Australia | ||
1676172 | 1676172 | 2021-02-01 | Australia | Tasmania | 234 | 13 | 221 | 0 | -42.8821 | 147.3272 | 2021-02-02 05:22:49 | Tasmania, Australia | ||
1676173 | 1676173 | 2021-02-01 | Australia | Victoria | 20450 | 820 | 19608 | 22 | -37.8136 | 144.9631 | 2021-02-02 05:22:49 | Victoria, Australia | ||
1676174 | 1676174 | 2021-02-01 | Australia | Western Australia | 903 | 9 | 881 | 13 | -31.9505 | 115.8605 | 2021-02-02 05:22:49 | Western Australia, Australia | ||
1459455 | 1459455 | 2021-01-31 | Australia | Australian Capital Territory | 118 | 3 | 115 | 0 | -35.4735 | 149.0124 | 2021-02-01 05:22:53 | Australian Capital Territory, Australia | ||
1459456 | 1459456 | 2021-01-31 | Australia | New South Wales | 5110 | 54 | 0 | 5056 | -33.8688 | 151.2093 | 2021-02-01 05:22:53 | New South Wales, Australia | ||
1459457 | 1459457 | 2021-01-31 | Australia | Northern Territory | 98 | 0 | 93 | 5 | -12.4634 | 130.8456 | 2021-02-01 05:22:53 | Northern Territory, Australia | ||
1459458 | 1459458 | 2021-01-31 | Australia | Queensland | 1310 | 6 | 1295 | 9 | -27.4698 | 153.0251 | 2021-02-01 05:22:53 | Queensland, Australia | ||
1459459 | 1459459 | 2021-01-31 | Australia | South Australia | 596 | 4 | 592 | 0 | -34.9285 | 138.6007 | 2021-02-01 05:22:53 | South Australia, Australia | ||
1459460 | 1459460 | 2021-01-31 | Australia | Tasmania | 234 | 13 | 221 | 0 | -42.8821 | 147.3272 | 2021-02-01 05:22:53 | Tasmania, Australia | ||
1459461 | 1459461 | 2021-01-31 | Australia | Victoria | 20449 | 820 | 19608 | 21 | -37.8136 | 144.9631 | 2021-02-01 05:22:53 | Victoria, Australia | ||
1459462 | 1459462 | 2021-01-31 | Australia | Western Australia | 903 | 9 | 881 | 13 | -31.9505 | 115.8605 | 2021-02-01 05:22:53 | Western Australia, Australia | ||
2211363 | 2211363 | 2021-01-30 | Australia | Australian Capital Territory | 118 | 3 | 115 | 0 | -35.4735 | 149.0124 | 2021-01-31 05:22:42 | Australian Capital Territory, Australia | ||
2211364 | 2211364 | 2021-01-30 | Australia | New South Wales | 5104 | 54 | 0 | 5050 | -33.8688 | 151.2093 | 2021-01-31 05:22:42 | New South Wales, Australia | ||
2211365 | 2211365 | 2021-01-30 | Australia | Northern Territory | 98 | 0 | 93 | 5 | -12.4634 | 130.8456 | 2021-01-31 05:22:42 | Northern Territory, Australia | ||
2211366 | 2211366 | 2021-01-30 | Australia | Queensland | 1309 | 6 | 1295 | 8 | -27.4698 | 153.0251 | 2021-01-31 05:22:42 | Queensland, Australia | ||
2211367 | 2211367 | 2021-01-30 | Australia | South Australia | 597 | 4 | 592 | 1 | -34.9285 | 138.6007 | 2021-01-31 05:22:42 | South Australia, Australia | ||
2211368 | 2211368 | 2021-01-30 | Australia | Tasmania | 234 | 13 | 221 | 0 | -42.8821 | 147.3272 | 2021-01-31 05:22:42 | Tasmania, Australia | ||
2211369 | 2211369 | 2021-01-30 | Australia | Victoria | 20448 | 820 | 19608 | 20 | -37.8136 | 144.9631 | 2021-01-31 05:22:42 | Victoria, Australia | ||
2211370 | 2211370 | 2021-01-30 | Australia | Western Australia | 903 | 9 | 878 | 16 | -31.9505 | 115.8605 | 2021-01-31 05:22:42 | Western Australia, Australia | ||
1896850 | 1896850 | 2021-01-29 | Australia | Australian Capital Territory | 118 | 3 | 115 | 0 | -35.4735 | 149.0124 | 2021-01-30 05:22:49 | Australian Capital Territory, Australia | ||
1896851 | 1896851 | 2021-01-29 | Australia | New South Wales | 5101 | 54 | 0 | 5047 | -33.8688 | 151.2093 | 2021-01-30 05:22:49 | New South Wales, Australia | ||
1896852 | 1896852 | 2021-01-29 | Australia | Northern Territory | 98 | 0 | 93 | 5 | -12.4634 | 130.8456 | 2021-01-30 05:22:49 | Northern Territory, Australia | ||
1896853 | 1896853 | 2021-01-29 | Australia | Queensland | 1309 | 6 | 1287 | 16 | -27.4698 | 153.0251 | 2021-01-30 05:22:49 | Queensland, Australia | ||
1896854 | 1896854 | 2021-01-29 | Australia | South Australia | 596 | 4 | 592 | 0 | -34.9285 | 138.6007 | 2021-01-30 05:22:49 | South Australia, Australia | ||
1896855 | 1896855 | 2021-01-29 | Australia | Tasmania | 234 | 13 | 221 | 0 | -42.8821 | 147.3272 | 2021-01-30 05:22:49 | Tasmania, Australia | ||
1896856 | 1896856 | 2021-01-29 | Australia | Victoria | 20448 | 820 | 19605 | 23 | -37.8136 | 144.9631 | 2021-01-30 05:22:49 | Victoria, Australia | ||
1896857 | 1896857 | 2021-01-29 | Australia | Western Australia | 902 | 9 | 878 | 15 | -31.9505 | 115.8605 | 2021-01-30 05:22:49 | Western Australia, Australia | ||
2481666 | 2481666 | 2021-01-28 | Australia | Australian Capital Territory | 118 | 3 | 115 | 0 | -35.4735 | 149.0124 | 2021-01-29 05:22:23 | Australian Capital Territory, Australia | ||
2481667 | 2481667 | 2021-01-28 | Australia | New South Wales | 5099 | 54 | 0 | 5045 | -33.8688 | 151.2093 | 2021-01-29 05:22:23 | New South Wales, Australia | ||
2481668 | 2481668 | 2021-01-28 | Australia | Northern Territory | 98 | 0 | 94 | 4 | -12.4634 | 130.8456 | 2021-01-29 05:22:23 | Northern Territory, Australia | ||
2481669 | 2481669 | 2021-01-28 | Australia | Queensland | 1308 | 6 | 1286 | 16 | -27.4698 | 153.0251 | 2021-01-29 05:22:23 | Queensland, Australia | ||
2481670 | 2481670 | 2021-01-28 | Australia | South Australia | 596 | 4 | 592 | 0 | -34.9285 | 138.6007 | 2021-01-29 05:22:23 | South Australia, Australia | ||
2481671 | 2481671 | 2021-01-28 | Australia | Tasmania | 234 | 13 | 221 | 0 | -42.8821 | 147.3272 | 2021-01-29 05:22:23 | Tasmania, Australia | ||
2481672 | 2481672 | 2021-01-28 | Australia | Victoria | 20448 | 820 | 19598 | 30 | -37.8136 | 144.9631 | 2021-01-29 05:22:23 | Victoria, Australia | ||
2481673 | 2481673 | 2021-01-28 | Australia | Western Australia | 898 | 9 | 875 | 14 | -31.9505 | 115.8605 | 2021-01-29 05:22:23 | Western Australia, Australia | ||
3153301 | 3153301 | 2021-01-27 | Australia | Australian Capital Territory | 118 | 3 | 115 | 0 | -35.4735 | 149.0124 | 2021-01-28 05:22:24 | Australian Capital Territory, Australia | ||
3153302 | 3153302 | 2021-01-27 | Australia | New South Wales | 5096 | 54 | 0 | 5042 | -33.8688 | 151.2093 | 2021-01-28 05:22:24 | New South Wales, Australia | ||
3153303 | 3153303 | 2021-01-27 | Australia | Northern Territory | 98 | 0 | 93 | 5 | -12.4634 | 130.8456 | 2021-01-28 05:22:24 | Northern Territory, Australia | ||
3153304 | 3153304 | 2021-01-27 | Australia | Queensland | 1307 | 6 | 1286 | 15 | -27.4698 | 153.0251 | 2021-01-28 05:22:24 | Queensland, Australia | ||
3153305 | 3153305 | 2021-01-27 | Australia | South Australia | 596 | 4 | 592 | 0 | -34.9285 | 138.6007 | 2021-01-28 05:22:24 | South Australia, Australia | ||
3153306 | 3153306 | 2021-01-27 | Australia | Tasmania | 234 | 13 | 221 | 0 | -42.8821 | 147.3272 | 2021-01-28 05:22:24 | Tasmania, Australia | ||
3153307 | 3153307 | 2021-01-27 | Australia | Victoria | 20447 | 820 | 19597 | 30 | -37.8136 | 144.9631 | 2021-01-28 05:22:24 | Victoria, Australia | ||
3153308 | 3153308 | 2021-01-27 | Australia | Western Australia | 898 | 9 | 875 | 14 | -31.9505 | 115.8605 | 2021-01-28 05:22:24 | 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]);