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
- New South Wales 718
- Victoria 718
- Queensland 715
- South Australia 713
- Western Australia 685
- Tasmania 683
- Northern Territory 681
- Australian Capital Territory 672
- From Diamond Princess 30
- External territories 1
- Jervis Bay Territory 1
country_or_region 1
- Australia · 5,620 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3687160 | 3687160 | 2022-01-13 | Australia | Australian Capital Territory | 19908 | 16 | 0 | -35.4735 | 149.0124 | 2022-01-14 04:21:54 | Australian Capital Territory, Australia | |||
3687161 | 3687161 | 2022-01-13 | Australia | New South Wales | 690758 | 826 | 0 | -33.8688 | 151.2093 | 2022-01-14 04:21:54 | New South Wales, Australia | |||
3687162 | 3687162 | 2022-01-13 | Australia | Northern Territory | 4610 | 1 | 0 | -12.4634 | 130.8456 | 2022-01-14 04:21:54 | Northern Territory, Australia | |||
3687163 | 3687163 | 2022-01-13 | Australia | Queensland | 177454 | 20 | 0 | -27.4698 | 153.0251 | 2022-01-14 04:21:54 | Queensland, Australia | |||
3687164 | 3687164 | 2022-01-13 | Australia | South Australia | 55145 | 30 | 0 | -34.9285 | 138.6007 | 2022-01-14 04:21:54 | South Australia, Australia | |||
3687165 | 3687165 | 2022-01-13 | Australia | Tasmania | 15938 | 13 | 0 | -42.8821 | 147.3272 | 2022-01-14 04:21:54 | Tasmania, Australia | |||
3687166 | 3687166 | 2022-01-13 | Australia | Victoria | 561872 | 1657 | 0 | -37.8136 | 144.9631 | 2022-01-14 04:21:54 | Victoria, Australia | |||
3687167 | 3687167 | 2022-01-13 | Australia | Western Australia | 1276 | 9 | 0 | -31.9505 | 115.8605 | 2022-01-14 04:21:54 | Western Australia, Australia | |||
3612744 | 3612744 | 2022-01-12 | Australia | Australian Capital Territory | 17378 | 16 | 0 | -35.4735 | 149.0124 | 2022-01-13 08:00:09 | Australian Capital Territory, Australia | |||
3612745 | 3612745 | 2022-01-12 | Australia | New South Wales | 628289 | 797 | 0 | -33.8688 | 151.2093 | 2022-01-13 08:00:09 | New South Wales, Australia | |||
3612746 | 3612746 | 2022-01-12 | Australia | Northern Territory | 4452 | 1 | 0 | -12.4634 | 130.8456 | 2022-01-13 08:00:09 | Northern Territory, Australia | |||
3612747 | 3612747 | 2022-01-12 | Australia | Queensland | 153837 | 17 | 0 | -27.4698 | 153.0251 | 2022-01-13 08:00:09 | Queensland, Australia | |||
3612748 | 3612748 | 2022-01-12 | Australia | South Australia | 54408 | 30 | 0 | -34.9285 | 138.6007 | 2022-01-13 08:00:09 | South Australia, Australia | |||
3612749 | 3612749 | 2022-01-12 | Australia | Tasmania | 14745 | 13 | 0 | -42.8821 | 147.3272 | 2022-01-13 08:00:09 | Tasmania, Australia | |||
3612750 | 3612750 | 2022-01-12 | Australia | Victoria | 524391 | 1639 | 0 | -37.8136 | 144.9631 | 2022-01-13 08:00:09 | Victoria, Australia | |||
3612751 | 3612751 | 2022-01-12 | Australia | Western Australia | 1276 | 9 | 0 | -31.9505 | 115.8605 | 2022-01-13 08:00:09 | Western Australia, Australia | |||
1113269 | 1113269 | 2022-01-11 | Australia | Australian Capital Territory | 15834 | 16 | 0 | -35.4735 | 149.0124 | 2022-01-12 04:21:44 | Australian Capital Territory, Australia | |||
1113270 | 1113270 | 2022-01-11 | Australia | New South Wales | 536025 | 775 | 0 | -33.8688 | 151.2093 | 2022-01-12 04:21:44 | New South Wales, Australia | |||
1113271 | 1113271 | 2022-01-11 | Australia | Northern Territory | 3429 | 1 | 0 | -12.4634 | 130.8456 | 2022-01-12 04:21:44 | Northern Territory, Australia | |||
1113272 | 1113272 | 2022-01-11 | Australia | Queensland | 116879 | 11 | 0 | -27.4698 | 153.0251 | 2022-01-12 04:21:44 | Queensland, Australia | |||
1113273 | 1113273 | 2022-01-11 | Australia | South Australia | 50905 | 26 | 0 | -34.9285 | 138.6007 | 2022-01-12 04:21:44 | South Australia, Australia | |||
1113274 | 1113274 | 2022-01-11 | Australia | Tasmania | 13649 | 13 | 0 | -42.8821 | 147.3272 | 2022-01-12 04:21:44 | Tasmania, Australia | |||
1113275 | 1113275 | 2022-01-11 | Australia | Victoria | 485530 | 1614 | 0 | -37.8136 | 144.9631 | 2022-01-12 04:21:44 | Victoria, Australia | |||
1113276 | 1113276 | 2022-01-11 | Australia | Western Australia | 1254 | 9 | 0 | -31.9505 | 115.8605 | 2022-01-12 04:21:44 | Western Australia, Australia | |||
1691997 | 1691997 | 2022-01-10 | Australia | Australian Capital Territory | 13248 | 15 | 0 | -35.4735 | 149.0124 | 2022-01-11 04:22:01 | Australian Capital Territory, Australia | |||
1691998 | 1691998 | 2022-01-10 | Australia | New South Wales | 501389 | 754 | 0 | -33.8688 | 151.2093 | 2022-01-11 04:22:01 | New South Wales, Australia | |||
1691999 | 1691999 | 2022-01-10 | Australia | Northern Territory | 2737 | 1 | 0 | -12.4634 | 130.8456 | 2022-01-11 04:22:01 | Northern Territory, Australia | |||
1692000 | 1692000 | 2022-01-10 | Australia | Queensland | 116892 | 11 | 0 | -27.4698 | 153.0251 | 2022-01-11 04:22:01 | Queensland, Australia | |||
1692001 | 1692001 | 2022-01-10 | Australia | South Australia | 47725 | 19 | 0 | -34.9285 | 138.6007 | 2022-01-11 04:22:01 | South Australia, Australia | |||
1692002 | 1692002 | 2022-01-10 | Australia | Tasmania | 12080 | 13 | 0 | -42.8821 | 147.3272 | 2022-01-11 04:22:01 | Tasmania, Australia | |||
1692003 | 1692003 | 2022-01-10 | Australia | Victoria | 443787 | 1593 | 0 | -37.8136 | 144.9631 | 2022-01-11 04:22:01 | Victoria, Australia | |||
1692004 | 1692004 | 2022-01-10 | Australia | Western Australia | 1239 | 9 | 0 | -31.9505 | 115.8605 | 2022-01-11 04:22:01 | Western Australia, Australia | |||
126412 | 126412 | 2022-01-09 | Australia | Australian Capital Territory | 13248 | 15 | 0 | -35.4735 | 149.0124 | 2022-01-10 04:22:07 | Australian Capital Territory, Australia | |||
126413 | 126413 | 2022-01-09 | Australia | New South Wales | 475731 | 743 | 0 | -33.8688 | 151.2093 | 2022-01-10 04:22:07 | New South Wales, Australia | |||
126414 | 126414 | 2022-01-09 | Australia | Northern Territory | 2642 | 1 | 0 | -12.4634 | 130.8456 | 2022-01-10 04:22:07 | Northern Territory, Australia | |||
126415 | 126415 | 2022-01-09 | Australia | Queensland | 96341 | 10 | 0 | -27.4698 | 153.0251 | 2022-01-10 04:22:07 | Queensland, Australia | |||
126416 | 126416 | 2022-01-09 | Australia | South Australia | 40627 | 16 | 0 | -34.9285 | 138.6007 | 2022-01-10 04:22:07 | South Australia, Australia | |||
126417 | 126417 | 2022-01-09 | Australia | Tasmania | 10713 | 13 | 0 | -42.8821 | 147.3272 | 2022-01-10 04:22:07 | Tasmania, Australia | |||
126418 | 126418 | 2022-01-09 | Australia | Victoria | 404758 | 1580 | 0 | -37.8136 | 144.9631 | 2022-01-10 04:22:07 | Victoria, Australia | |||
126419 | 126419 | 2022-01-09 | Australia | Western Australia | 1231 | 9 | 0 | -31.9505 | 115.8605 | 2022-01-10 04:22:07 | Western Australia, Australia | |||
1215247 | 1215247 | 2022-01-08 | Australia | Australian Capital Territory | 12300 | 15 | 0 | -35.4735 | 149.0124 | 2022-01-09 04:21:46 | Australian Capital Territory, Australia | |||
1215248 | 1215248 | 2022-01-08 | Australia | New South Wales | 455529 | 725 | 0 | -33.8688 | 151.2093 | 2022-01-09 04:21:46 | New South Wales, Australia | |||
1215249 | 1215249 | 2022-01-08 | Australia | Northern Territory | 1938 | 1 | 0 | -12.4634 | 130.8456 | 2022-01-09 04:21:46 | Northern Territory, Australia | |||
1215250 | 1215250 | 2022-01-08 | Australia | Queensland | 86783 | 10 | 0 | -27.4698 | 153.0251 | 2022-01-09 04:21:46 | Queensland, Australia | |||
1215251 | 1215251 | 2022-01-08 | Australia | South Australia | 35786 | 15 | 0 | -34.9285 | 138.6007 | 2022-01-09 04:21:46 | South Australia, Australia | |||
1215252 | 1215252 | 2022-01-08 | Australia | Tasmania | 9528 | 13 | 0 | -42.8821 | 147.3272 | 2022-01-09 04:21:46 | Tasmania, Australia | |||
1215253 | 1215253 | 2022-01-08 | Australia | Victoria | 369362 | 1578 | 0 | -37.8136 | 144.9631 | 2022-01-09 04:21:46 | Victoria, Australia | |||
1215254 | 1215254 | 2022-01-08 | Australia | Western Australia | 1231 | 9 | 0 | -31.9505 | 115.8605 | 2022-01-09 04:21:46 | Western Australia, Australia | |||
1389340 | 1389340 | 2022-01-07 | Australia | Australian Capital Territory | 9429 | 15 | 0 | -35.4735 | 149.0124 | 2022-01-08 04:21:53 | Australian Capital Territory, Australia | |||
1389341 | 1389341 | 2022-01-07 | Australia | New South Wales | 425593 | 709 | 0 | -33.8688 | 151.2093 | 2022-01-08 04:21:53 | New South Wales, Australia | |||
1389342 | 1389342 | 2022-01-07 | Australia | Northern Territory | 1505 | 1 | 0 | -12.4634 | 130.8456 | 2022-01-08 04:21:53 | Northern Territory, Australia | |||
1389343 | 1389343 | 2022-01-07 | Australia | Queensland | 57677 | 8 | 0 | -27.4698 | 153.0251 | 2022-01-08 04:21:53 | Queensland, Australia | |||
1389344 | 1389344 | 2022-01-07 | Australia | South Australia | 31513 | 8 | 0 | -34.9285 | 138.6007 | 2022-01-08 04:21:53 | South Australia, Australia | |||
1389345 | 1389345 | 2022-01-07 | Australia | Tasmania | 8133 | 13 | 0 | -42.8821 | 147.3272 | 2022-01-08 04:21:53 | Tasmania, Australia | |||
1389346 | 1389346 | 2022-01-07 | Australia | Victoria | 325479 | 1574 | 0 | -37.8136 | 144.9631 | 2022-01-08 04:21:53 | Victoria, Australia | |||
1389347 | 1389347 | 2022-01-07 | Australia | Western Australia | 1221 | 9 | 0 | -31.9505 | 115.8605 | 2022-01-08 04:21:53 | Western Australia, Australia | |||
2609727 | 2609727 | 2022-01-06 | Australia | Australian Capital Territory | 9553 | 15 | 0 | -35.4735 | 149.0124 | 2022-01-07 04:22:09 | Australian Capital Territory, Australia | |||
2609728 | 2609728 | 2022-01-06 | Australia | New South Wales | 380550 | 700 | 0 | -33.8688 | 151.2093 | 2022-01-07 04:22:09 | New South Wales, Australia | |||
2609729 | 2609729 | 2022-01-06 | Australia | Northern Territory | 1642 | 1 | 0 | -12.4634 | 130.8456 | 2022-01-07 04:22:09 | Northern Territory, Australia | |||
2609730 | 2609730 | 2022-01-06 | Australia | Queensland | 57677 | 8 | 0 | -27.4698 | 153.0251 | 2022-01-07 04:22:09 | Queensland, Australia | |||
2609731 | 2609731 | 2022-01-06 | Australia | South Australia | 31520 | 10 | 0 | -34.9285 | 138.6007 | 2022-01-07 04:22:09 | South Australia, Australia | |||
2609732 | 2609732 | 2022-01-06 | Australia | Tasmania | 5911 | 13 | 0 | -42.8821 | 147.3272 | 2022-01-07 04:22:09 | Tasmania, Australia | |||
2609733 | 2609733 | 2022-01-06 | Australia | Victoria | 274390 | 1565 | 0 | -37.8136 | 144.9631 | 2022-01-07 04:22:09 | Victoria, Australia | |||
2609734 | 2609734 | 2022-01-06 | Australia | Western Australia | 1215 | 9 | 0 | -31.9505 | 115.8605 | 2022-01-07 04:22:09 | Western Australia, Australia | |||
1281669 | 1281669 | 2022-01-05 | Australia | Australian Capital Territory | 8021 | 15 | 0 | -35.4735 | 149.0124 | 2022-01-06 04:22:09 | Australian Capital Territory, Australia | |||
1281670 | 1281670 | 2022-01-05 | Australia | New South Wales | 342133 | 689 | 0 | -33.8688 | 151.2093 | 2022-01-06 04:22:09 | New South Wales, Australia | |||
1281671 | 1281671 | 2022-01-05 | Australia | Northern Territory | 985 | 1 | 0 | -12.4634 | 130.8456 | 2022-01-06 04:22:09 | Northern Territory, Australia | |||
1281672 | 1281672 | 2022-01-05 | Australia | Queensland | 46731 | 8 | 0 | -27.4698 | 153.0251 | 2022-01-06 04:22:09 | Queensland, Australia | |||
1281673 | 1281673 | 2022-01-05 | Australia | South Australia | 27815 | 8 | 0 | -34.9285 | 138.6007 | 2022-01-06 04:22:09 | South Australia, Australia | |||
1281674 | 1281674 | 2022-01-05 | Australia | Tasmania | 4422 | 13 | 0 | -42.8821 | 147.3272 | 2022-01-06 04:22:09 | Tasmania, Australia | |||
1281675 | 1281675 | 2022-01-05 | Australia | Victoria | 252916 | 1559 | 0 | -37.8136 | 144.9631 | 2022-01-06 04:22:09 | Victoria, Australia | |||
1281676 | 1281676 | 2022-01-05 | Australia | Western Australia | 1206 | 9 | 0 | -31.9505 | 115.8605 | 2022-01-06 04:22:09 | Western Australia, Australia | |||
1285685 | 1285685 | 2022-01-04 | Australia | Australian Capital Territory | 7054 | 15 | 0 | -35.4735 | 149.0124 | 2022-01-05 04:21:59 | Australian Capital Territory, Australia | |||
1285686 | 1285686 | 2022-01-04 | Australia | New South Wales | 307214 | 684 | 0 | -33.8688 | 151.2093 | 2022-01-05 04:21:59 | New South Wales, Australia | |||
1285687 | 1285687 | 2022-01-04 | Australia | Northern Territory | 883 | 1 | 0 | -12.4634 | 130.8456 | 2022-01-05 04:21:59 | Northern Territory, Australia | |||
1285688 | 1285688 | 2022-01-04 | Australia | Queensland | 36407 | 7 | 0 | -27.4698 | 153.0251 | 2022-01-05 04:21:59 | Queensland, Australia | |||
1285689 | 1285689 | 2022-01-04 | Australia | South Australia | 21255 | 8 | 0 | -34.9285 | 138.6007 | 2022-01-05 04:21:59 | South Australia, Australia | |||
1285690 | 1285690 | 2022-01-04 | Australia | Tasmania | 3674 | 13 | 0 | -42.8821 | 147.3272 | 2022-01-05 04:21:59 | Tasmania, Australia | |||
1285691 | 1285691 | 2022-01-04 | Australia | Victoria | 231126 | 1553 | 0 | -37.8136 | 144.9631 | 2022-01-05 04:21:59 | Victoria, Australia | |||
1285692 | 1285692 | 2022-01-04 | Australia | Western Australia | 1190 | 9 | 0 | -31.9505 | 115.8605 | 2022-01-05 04:21:59 | Western Australia, Australia | |||
1700029 | 1700029 | 2022-01-03 | Australia | Australian Capital Territory | 5323 | 15 | 0 | -35.4735 | 149.0124 | 2022-01-04 04:22:17 | Australian Capital Territory, Australia | |||
1700030 | 1700030 | 2022-01-03 | Australia | New South Wales | 272160 | 675 | 0 | -33.8688 | 151.2093 | 2022-01-04 04:22:17 | New South Wales, Australia | |||
1700031 | 1700031 | 2022-01-03 | Australia | Northern Territory | 880 | 1 | 0 | -12.4634 | 130.8456 | 2022-01-04 04:22:17 | Northern Territory, Australia | |||
1700032 | 1700032 | 2022-01-03 | Australia | Queensland | 23941 | 7 | 0 | -27.4698 | 153.0251 | 2022-01-04 04:22:17 | Queensland, Australia | |||
1700033 | 1700033 | 2022-01-03 | Australia | South Australia | 18021 | 8 | 0 | -34.9285 | 138.6007 | 2022-01-04 04:22:17 | South Australia, Australia | |||
1700034 | 1700034 | 2022-01-03 | Australia | Tasmania | 2259 | 13 | 0 | -42.8821 | 147.3272 | 2022-01-04 04:22:17 | Tasmania, Australia | |||
1700035 | 1700035 | 2022-01-03 | Australia | Victoria | 213548 | 1542 | 0 | -37.8136 | 144.9631 | 2022-01-04 04:22:17 | Victoria, Australia | |||
1700036 | 1700036 | 2022-01-03 | Australia | Western Australia | 1176 | 9 | 0 | -31.9505 | 115.8605 | 2022-01-04 04:22:17 | Western Australia, Australia | |||
3519112 | 3519112 | 2022-01-02 | Australia | Australian Capital Territory | 5323 | 15 | 0 | -35.4735 | 149.0124 | 2022-01-03 02:22:25 | Australian Capital Territory, Australia | |||
3519113 | 3519113 | 2022-01-02 | Australia | New South Wales | 249064 | 673 | 0 | -33.8688 | 151.2093 | 2022-01-03 02:22:25 | New South Wales, Australia | |||
3519114 | 3519114 | 2022-01-02 | Australia | Northern Territory | 624 | 1 | 0 | -12.4634 | 130.8456 | 2022-01-03 02:22:25 | Northern Territory, Australia | |||
3519115 | 3519115 | 2022-01-02 | Australia | Queensland | 19707 | 7 | 0 | -27.4698 | 153.0251 | 2022-01-03 02:22:25 | Queensland, Australia | |||
3519116 | 3519116 | 2022-01-02 | Australia | South Australia | 15473 | 8 | 0 | -34.9285 | 138.6007 | 2022-01-03 02:22:25 | South Australia, Australia | |||
3519117 | 3519117 | 2022-01-02 | Australia | Tasmania | 1628 | 13 | 0 | -42.8821 | 147.3272 | 2022-01-03 02:22:25 | Tasmania, Australia | |||
3519118 | 3519118 | 2022-01-02 | Australia | Victoria | 199576 | 1540 | 0 | -37.8136 | 144.9631 | 2022-01-03 02:22:25 | Victoria, Australia | |||
3519119 | 3519119 | 2022-01-02 | Australia | Western Australia | 1168 | 9 | 0 | -31.9505 | 115.8605 | 2022-01-03 02:22:25 | Western Australia, Australia | |||
2167242 | 2167242 | 2022-01-01 | Australia | Australian Capital Territory | 4919 | 15 | 0 | -35.4735 | 149.0124 | 2022-01-02 04:20:52 | Australian Capital Territory, Australia | |||
2167243 | 2167243 | 2022-01-01 | Australia | New South Wales | 228307 | 669 | 0 | -33.8688 | 151.2093 | 2022-01-02 04:20:52 | New South Wales, Australia | |||
2167244 | 2167244 | 2022-01-01 | Australia | Northern Territory | 624 | 1 | 0 | -12.4634 | 130.8456 | 2022-01-02 04:20:52 | Northern Territory, Australia | |||
2167245 | 2167245 | 2022-01-01 | Australia | Queensland | 19707 | 7 | 0 | -27.4698 | 153.0251 | 2022-01-02 04:20:52 | Queensland, 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]);