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 392
- Victoria 392
- Queensland 389
- South Australia 387
- Western Australia 359
- Tasmania 357
- Northern Territory 355
- Australian Capital Territory 346
- From Diamond Princess 30
- External territories 1
- Jervis Bay Territory 1
country_or_region 1
- Australia · 3,012 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
181735 | 181735 | 2021-02-21 | Australia | Australian Capital Territory | 118 | 3 | 115 | 0 | -35.4735 | 149.0124 | 2021-02-22 05:24:21 | Australian Capital Territory, Australia | ||
181736 | 181736 | 2021-02-21 | Australia | New South Wales | 5150 | 54 | 0 | 5096 | -33.8688 | 151.2093 | 2021-02-22 05:24:21 | New South Wales, Australia | ||
181737 | 181737 | 2021-02-21 | Australia | Northern Territory | 104 | 0 | 101 | 3 | -12.4634 | 130.8456 | 2021-02-22 05:24:21 | Northern Territory, Australia | ||
181738 | 181738 | 2021-02-21 | Australia | Queensland | 1323 | 6 | 1309 | 8 | -27.4698 | 153.0251 | 2021-02-22 05:24:21 | Queensland, Australia | ||
181739 | 181739 | 2021-02-21 | Australia | South Australia | 610 | 4 | 603 | 3 | -34.9285 | 138.6007 | 2021-02-22 05:24:21 | South Australia, Australia | ||
181740 | 181740 | 2021-02-21 | Australia | Tasmania | 234 | 13 | 221 | 0 | -42.8821 | 147.3272 | 2021-02-22 05:24:21 | Tasmania, Australia | ||
181741 | 181741 | 2021-02-21 | Australia | Victoria | 20479 | 820 | 19634 | 25 | -37.8136 | 144.9631 | 2021-02-22 05:24:21 | Victoria, Australia | ||
181742 | 181742 | 2021-02-21 | Australia | Western Australia | 912 | 9 | 899 | 4 | -31.9505 | 115.8605 | 2021-02-22 05:24:21 | Western Australia, Australia | ||
742009 | 742009 | 2021-02-20 | Australia | Australian Capital Territory | 118 | 3 | 115 | 0 | -35.4735 | 149.0124 | 2021-02-21 05:24:33 | Australian Capital Territory, Australia | ||
742010 | 742010 | 2021-02-20 | Australia | New South Wales | 5149 | 54 | 0 | 5095 | -33.8688 | 151.2093 | 2021-02-21 05:24:33 | New South Wales, Australia | ||
742011 | 742011 | 2021-02-20 | Australia | Northern Territory | 104 | 0 | 101 | 3 | -12.4634 | 130.8456 | 2021-02-21 05:24:33 | Northern Territory, Australia | ||
742012 | 742012 | 2021-02-20 | Australia | Queensland | 1321 | 6 | 1309 | 6 | -27.4698 | 153.0251 | 2021-02-21 05:24:33 | Queensland, Australia | ||
742013 | 742013 | 2021-02-20 | Australia | South Australia | 610 | 4 | 602 | 4 | -34.9285 | 138.6007 | 2021-02-21 05:24:33 | South Australia, Australia | ||
742014 | 742014 | 2021-02-20 | Australia | Tasmania | 234 | 13 | 221 | 0 | -42.8821 | 147.3272 | 2021-02-21 05:24:33 | Tasmania, Australia | ||
742015 | 742015 | 2021-02-20 | Australia | Victoria | 20479 | 820 | 19634 | 25 | -37.8136 | 144.9631 | 2021-02-21 05:24:33 | Victoria, Australia | ||
742016 | 742016 | 2021-02-20 | Australia | Western Australia | 911 | 9 | 899 | 3 | -31.9505 | 115.8605 | 2021-02-21 05:24:33 | Western Australia, Australia | ||
471107 | 471107 | 2021-02-19 | Australia | Australian Capital Territory | 118 | 3 | 115 | 0 | -35.4735 | 149.0124 | 2021-02-20 05:22:51 | Australian Capital Territory, Australia | ||
471108 | 471108 | 2021-02-19 | Australia | New South Wales | 5146 | 54 | 0 | 5092 | -33.8688 | 151.2093 | 2021-02-20 05:22:51 | New South Wales, Australia | ||
471109 | 471109 | 2021-02-19 | Australia | Northern Territory | 104 | 0 | 101 | 3 | -12.4634 | 130.8456 | 2021-02-20 05:22:51 | Northern Territory, Australia | ||
471110 | 471110 | 2021-02-19 | Australia | Queensland | 1321 | 6 | 1309 | 6 | -27.4698 | 153.0251 | 2021-02-20 05:22:51 | Queensland, Australia | ||
471111 | 471111 | 2021-02-19 | Australia | South Australia | 608 | 4 | 602 | 2 | -34.9285 | 138.6007 | 2021-02-20 05:22:51 | South Australia, Australia | ||
471112 | 471112 | 2021-02-19 | Australia | Tasmania | 234 | 13 | 221 | 0 | -42.8821 | 147.3272 | 2021-02-20 05:22:51 | Tasmania, Australia | ||
471113 | 471113 | 2021-02-19 | Australia | Victoria | 20479 | 820 | 19634 | 25 | -37.8136 | 144.9631 | 2021-02-20 05:22:51 | Victoria, Australia | ||
471114 | 471114 | 2021-02-19 | Australia | Western Australia | 910 | 9 | 897 | 4 | -31.9505 | 115.8605 | 2021-02-20 05:22:51 | Western Australia, Australia | ||
1152817 | 1152817 | 2021-02-18 | Australia | Australian Capital Territory | 118 | 3 | 115 | 0 | -35.4735 | 149.0124 | 2021-02-19 05:24:16 | Australian Capital Territory, Australia | ||
1152818 | 1152818 | 2021-02-18 | Australia | New South Wales | 5145 | 54 | 0 | 5091 | -33.8688 | 151.2093 | 2021-02-19 05:24:16 | New South Wales, Australia | ||
1152819 | 1152819 | 2021-02-18 | Australia | Northern Territory | 103 | 0 | 101 | 2 | -12.4634 | 130.8456 | 2021-02-19 05:24:16 | Northern Territory, Australia | ||
1152820 | 1152820 | 2021-02-18 | Australia | Queensland | 1321 | 6 | 1307 | 8 | -27.4698 | 153.0251 | 2021-02-19 05:24:16 | Queensland, Australia | ||
1152821 | 1152821 | 2021-02-18 | Australia | South Australia | 608 | 4 | 601 | 3 | -34.9285 | 138.6007 | 2021-02-19 05:24:16 | South Australia, Australia | ||
1152822 | 1152822 | 2021-02-18 | Australia | Tasmania | 234 | 13 | 221 | 0 | -42.8821 | 147.3272 | 2021-02-19 05:24:16 | Tasmania, Australia | ||
1152823 | 1152823 | 2021-02-18 | Australia | Victoria | 20479 | 820 | 19632 | 27 | -37.8136 | 144.9631 | 2021-02-19 05:24:16 | Victoria, Australia | ||
1152824 | 1152824 | 2021-02-18 | Australia | Western Australia | 910 | 9 | 897 | 4 | -31.9505 | 115.8605 | 2021-02-19 05:24:16 | Western Australia, Australia | ||
3600737 | 3600737 | 2021-02-17 | Australia | Australian Capital Territory | 118 | 3 | 115 | 0 | -35.4735 | 149.0124 | 2021-02-18 05:22:58 | Australian Capital Territory, Australia | ||
3600738 | 3600738 | 2021-02-17 | Australia | New South Wales | 5143 | 54 | 0 | 5089 | -33.8688 | 151.2093 | 2021-02-18 05:22:58 | New South Wales, Australia | ||
3600739 | 3600739 | 2021-02-17 | Australia | Northern Territory | 103 | 0 | 99 | 4 | -12.4634 | 130.8456 | 2021-02-18 05:22:58 | Northern Territory, Australia | ||
3600740 | 3600740 | 2021-02-17 | Australia | Queensland | 1320 | 6 | 1306 | 8 | -27.4698 | 153.0251 | 2021-02-18 05:22:58 | Queensland, Australia | ||
3600741 | 3600741 | 2021-02-17 | Australia | South Australia | 608 | 4 | 601 | 3 | -34.9285 | 138.6007 | 2021-02-18 05:22:58 | South Australia, Australia | ||
3600742 | 3600742 | 2021-02-17 | Australia | Tasmania | 234 | 13 | 221 | 0 | -42.8821 | 147.3272 | 2021-02-18 05:22:58 | Tasmania, Australia | ||
3600743 | 3600743 | 2021-02-17 | Australia | Victoria | 20476 | 820 | 19631 | 25 | -37.8136 | 144.9631 | 2021-02-18 05:22:58 | Victoria, Australia | ||
3600744 | 3600744 | 2021-02-17 | Australia | Western Australia | 910 | 9 | 898 | 3 | -31.9505 | 115.8605 | 2021-02-18 05:22:58 | Western Australia, Australia | ||
3049872 | 3049872 | 2021-02-16 | Australia | Australian Capital Territory | 118 | 3 | 115 | 0 | -35.4735 | 149.0124 | 2021-02-17 05:23:10 | Australian Capital Territory, Australia | ||
3049873 | 3049873 | 2021-02-16 | Australia | New South Wales | 5143 | 54 | 0 | 5089 | -33.8688 | 151.2093 | 2021-02-17 05:23:10 | New South Wales, Australia | ||
3049874 | 3049874 | 2021-02-16 | Australia | Northern Territory | 103 | 0 | 99 | 4 | -12.4634 | 130.8456 | 2021-02-17 05:23:10 | Northern Territory, Australia | ||
3049875 | 3049875 | 2021-02-16 | Australia | Queensland | 1320 | 6 | 1306 | 8 | -27.4698 | 153.0251 | 2021-02-17 05:23:10 | Queensland, Australia | ||
3049876 | 3049876 | 2021-02-16 | Australia | South Australia | 608 | 4 | 601 | 3 | -34.9285 | 138.6007 | 2021-02-17 05:23:10 | South Australia, Australia | ||
3049877 | 3049877 | 2021-02-16 | Australia | Tasmania | 234 | 13 | 221 | 0 | -42.8821 | 147.3272 | 2021-02-17 05:23:10 | Tasmania, Australia | ||
3049878 | 3049878 | 2021-02-16 | Australia | Victoria | 20475 | 820 | 19630 | 25 | -37.8136 | 144.9631 | 2021-02-17 05:23:10 | Victoria, Australia | ||
3049879 | 3049879 | 2021-02-16 | Australia | Western Australia | 910 | 9 | 898 | 3 | -31.9505 | 115.8605 | 2021-02-17 05:23:10 | Western Australia, Australia | ||
1337971 | 1337971 | 2021-02-15 | Australia | Australian Capital Territory | 118 | 3 | 115 | 0 | -35.4735 | 149.0124 | 2021-02-16 05:24:38 | Australian Capital Territory, Australia | ||
1337972 | 1337972 | 2021-02-15 | Australia | New South Wales | 5139 | 54 | 0 | 5085 | -33.8688 | 151.2093 | 2021-02-16 05:24:38 | New South Wales, Australia | ||
1337973 | 1337973 | 2021-02-15 | Australia | Northern Territory | 103 | 0 | 99 | 4 | -12.4634 | 130.8456 | 2021-02-16 05:24:38 | Northern Territory, Australia | ||
1337974 | 1337974 | 2021-02-15 | Australia | Queensland | 1320 | 6 | 1305 | 9 | -27.4698 | 153.0251 | 2021-02-16 05:24:38 | Queensland, Australia | ||
1337975 | 1337975 | 2021-02-15 | Australia | South Australia | 606 | 4 | 599 | 3 | -34.9285 | 138.6007 | 2021-02-16 05:24:38 | South Australia, Australia | ||
1337976 | 1337976 | 2021-02-15 | Australia | Tasmania | 234 | 13 | 221 | 0 | -42.8821 | 147.3272 | 2021-02-16 05:24:38 | Tasmania, Australia | ||
1337977 | 1337977 | 2021-02-15 | Australia | Victoria | 20475 | 820 | 19630 | 25 | -37.8136 | 144.9631 | 2021-02-16 05:24:38 | Victoria, Australia | ||
1337978 | 1337978 | 2021-02-15 | Australia | Western Australia | 910 | 9 | 897 | 4 | -31.9505 | 115.8605 | 2021-02-16 05:24:38 | Western Australia, Australia | ||
2283122 | 2283122 | 2021-02-14 | Australia | Australian Capital Territory | 118 | 3 | 115 | 0 | -35.4735 | 149.0124 | 2021-02-15 05:24:49 | Australian Capital Territory, Australia | ||
2283123 | 2283123 | 2021-02-14 | Australia | New South Wales | 5138 | 54 | 0 | 5084 | -33.8688 | 151.2093 | 2021-02-15 05:24:49 | New South Wales, Australia | ||
2283124 | 2283124 | 2021-02-14 | Australia | Northern Territory | 103 | 0 | 98 | 5 | -12.4634 | 130.8456 | 2021-02-15 05:24:49 | Northern Territory, Australia | ||
2283125 | 2283125 | 2021-02-14 | Australia | Queensland | 1320 | 6 | 1305 | 9 | -27.4698 | 153.0251 | 2021-02-15 05:24:49 | Queensland, Australia | ||
2283126 | 2283126 | 2021-02-14 | Australia | South Australia | 606 | 4 | 599 | 3 | -34.9285 | 138.6007 | 2021-02-15 05:24:49 | South Australia, Australia | ||
2283127 | 2283127 | 2021-02-14 | Australia | Tasmania | 234 | 13 | 221 | 0 | -42.8821 | 147.3272 | 2021-02-15 05:24:49 | Tasmania, Australia | ||
2283128 | 2283128 | 2021-02-14 | Australia | Victoria | 20471 | 820 | 19630 | 21 | -37.8136 | 144.9631 | 2021-02-15 05:24:49 | Victoria, Australia | ||
2283129 | 2283129 | 2021-02-14 | Australia | Western Australia | 910 | 9 | 896 | 5 | -31.9505 | 115.8605 | 2021-02-15 05:24:49 | Western Australia, Australia | ||
2677522 | 2677522 | 2021-02-13 | Australia | Australian Capital Territory | 118 | 3 | 115 | 0 | -35.4735 | 149.0124 | 2021-02-14 05:23:43 | Australian Capital Territory, Australia | ||
2677523 | 2677523 | 2021-02-13 | Australia | New South Wales | 5138 | 54 | 0 | 5084 | -33.8688 | 151.2093 | 2021-02-14 05:23:43 | New South Wales, Australia | ||
2677524 | 2677524 | 2021-02-13 | Australia | Northern Territory | 103 | 0 | 98 | 5 | -12.4634 | 130.8456 | 2021-02-14 05:23:43 | Northern Territory, Australia | ||
2677525 | 2677525 | 2021-02-13 | Australia | Queensland | 1320 | 6 | 1301 | 13 | -27.4698 | 153.0251 | 2021-02-14 05:23:43 | Queensland, Australia | ||
2677526 | 2677526 | 2021-02-13 | Australia | South Australia | 606 | 4 | 599 | 3 | -34.9285 | 138.6007 | 2021-02-14 05:23:43 | South Australia, Australia | ||
2677527 | 2677527 | 2021-02-13 | Australia | Tasmania | 234 | 13 | 221 | 0 | -42.8821 | 147.3272 | 2021-02-14 05:23:43 | Tasmania, Australia | ||
2677528 | 2677528 | 2021-02-13 | Australia | Victoria | 20469 | 820 | 19628 | 21 | -37.8136 | 144.9631 | 2021-02-14 05:23:43 | Victoria, Australia | ||
2677529 | 2677529 | 2021-02-13 | Australia | Western Australia | 910 | 9 | 896 | 5 | -31.9505 | 115.8605 | 2021-02-14 05:23:43 | Western Australia, Australia | ||
3539155 | 3539155 | 2021-02-12 | Australia | Australian Capital Territory | 118 | 3 | 115 | 0 | -35.4735 | 149.0124 | 2021-02-13 05:22:12 | Australian Capital Territory, Australia | ||
3539156 | 3539156 | 2021-02-12 | Australia | New South Wales | 5136 | 54 | 0 | 5082 | -33.8688 | 151.2093 | 2021-02-13 05:22:12 | New South Wales, Australia | ||
3539157 | 3539157 | 2021-02-12 | Australia | Northern Territory | 102 | 0 | 98 | 4 | -12.4634 | 130.8456 | 2021-02-13 05:22:12 | Northern Territory, Australia | ||
3539158 | 3539158 | 2021-02-12 | Australia | Queensland | 1320 | 6 | 1300 | 14 | -27.4698 | 153.0251 | 2021-02-13 05:22:12 | Queensland, Australia | ||
3539159 | 3539159 | 2021-02-12 | Australia | South Australia | 606 | 4 | 599 | 3 | -34.9285 | 138.6007 | 2021-02-13 05:22:12 | South Australia, Australia | ||
3539160 | 3539160 | 2021-02-12 | Australia | Tasmania | 234 | 13 | 221 | 0 | -42.8821 | 147.3272 | 2021-02-13 05:22:12 | Tasmania, Australia | ||
3539161 | 3539161 | 2021-02-12 | Australia | Victoria | 20466 | 820 | 19626 | 20 | -37.8136 | 144.9631 | 2021-02-13 05:22:12 | Victoria, Australia | ||
3539162 | 3539162 | 2021-02-12 | Australia | Western Australia | 910 | 9 | 895 | 6 | -31.9505 | 115.8605 | 2021-02-13 05:22:12 | Western Australia, Australia | ||
2637418 | 2637418 | 2021-02-11 | Australia | Australian Capital Territory | 118 | 3 | 115 | 0 | -35.4735 | 149.0124 | 2021-02-12 05:23:29 | Australian Capital Territory, Australia | ||
2637419 | 2637419 | 2021-02-11 | Australia | New South Wales | 5134 | 54 | 0 | 5080 | -33.8688 | 151.2093 | 2021-02-12 05:23:29 | New South Wales, Australia | ||
2637420 | 2637420 | 2021-02-11 | Australia | Northern Territory | 102 | 0 | 98 | 4 | -12.4634 | 130.8456 | 2021-02-12 05:23:29 | Northern Territory, Australia | ||
2637421 | 2637421 | 2021-02-11 | Australia | Queensland | 1318 | 6 | 1299 | 13 | -27.4698 | 153.0251 | 2021-02-12 05:23:29 | Queensland, Australia | ||
2637422 | 2637422 | 2021-02-11 | Australia | South Australia | 606 | 4 | 597 | 5 | -34.9285 | 138.6007 | 2021-02-12 05:23:29 | South Australia, Australia | ||
2637423 | 2637423 | 2021-02-11 | Australia | Tasmania | 234 | 13 | 221 | 0 | -42.8821 | 147.3272 | 2021-02-12 05:23:29 | Tasmania, Australia | ||
2637424 | 2637424 | 2021-02-11 | Australia | Victoria | 20465 | 820 | 19626 | 19 | -37.8136 | 144.9631 | 2021-02-12 05:23:29 | Victoria, Australia | ||
2637425 | 2637425 | 2021-02-11 | Australia | Western Australia | 910 | 9 | 894 | 7 | -31.9505 | 115.8605 | 2021-02-12 05:23:29 | Western Australia, Australia | ||
3978273 | 3978273 | 2021-02-10 | Australia | Australian Capital Territory | 118 | 3 | 115 | 0 | -35.4735 | 149.0124 | 2021-02-11 05:23:55 | Australian Capital Territory, Australia | ||
3978274 | 3978274 | 2021-02-10 | Australia | New South Wales | 5132 | 54 | 0 | 5078 | -33.8688 | 151.2093 | 2021-02-11 05:23:55 | New South Wales, Australia | ||
3978275 | 3978275 | 2021-02-10 | Australia | Northern Territory | 102 | 0 | 98 | 4 | -12.4634 | 130.8456 | 2021-02-11 05:23:55 | Northern Territory, Australia | ||
3978276 | 3978276 | 2021-02-10 | Australia | Queensland | 1317 | 6 | 1299 | 12 | -27.4698 | 153.0251 | 2021-02-11 05:23:55 | Queensland, Australia | ||
3978277 | 3978277 | 2021-02-10 | Australia | South Australia | 606 | 4 | 597 | 5 | -34.9285 | 138.6007 | 2021-02-11 05:23:55 | South Australia, Australia | ||
3978278 | 3978278 | 2021-02-10 | Australia | Tasmania | 234 | 13 | 221 | 0 | -42.8821 | 147.3272 | 2021-02-11 05:23:55 | Tasmania, Australia | ||
3978279 | 3978279 | 2021-02-10 | Australia | Victoria | 20460 | 820 | 19623 | 17 | -37.8136 | 144.9631 | 2021-02-11 05:23:55 | Victoria, Australia | ||
3978280 | 3978280 | 2021-02-10 | Australia | Western Australia | 910 | 9 | 893 | 8 | -31.9505 | 115.8605 | 2021-02-11 05:23:55 | Western Australia, Australia | ||
1527593 | 1527593 | 2021-02-09 | Australia | Australian Capital Territory | 118 | 3 | 115 | 0 | -35.4735 | 149.0124 | 2021-02-10 05:22:41 | Australian Capital Territory, Australia | ||
1527594 | 1527594 | 2021-02-09 | Australia | New South Wales | 5129 | 54 | 0 | 5075 | -33.8688 | 151.2093 | 2021-02-10 05:22:41 | New South Wales, Australia | ||
1527595 | 1527595 | 2021-02-09 | Australia | Northern Territory | 102 | 0 | 98 | 4 | -12.4634 | 130.8456 | 2021-02-10 05:22:41 | Northern Territory, Australia | ||
1527596 | 1527596 | 2021-02-09 | Australia | Queensland | 1316 | 6 | 1299 | 11 | -27.4698 | 153.0251 | 2021-02-10 05:22:41 | 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]);