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 157
- Victoria 157
- Queensland 154
- South Australia 152
- Western Australia 124
- Tasmania 122
- Northern Territory 120
- Australian Capital Territory 111
- From Diamond Princess 30
- External territories 1
- Jervis Bay Territory 1
country_or_region 1
- Australia · 1,132 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
302863 | 302863 | 2020-07-01 | Australia | Australian Capital Territory | 108 | 3 | 105 | 0 | -35.4735 | 149.0124 | 2020-07-02 04:33:46 | Australian Capital Territory, Australia | ||
303124 | 303124 | 2020-07-01 | Australia | New South Wales | 3211 | 49 | 2787 | 375 | -33.8688 | 151.2093 | 2020-07-02 04:33:46 | New South Wales, Australia | ||
303136 | 303136 | 2020-07-01 | Australia | Northern Territory | 30 | 0 | 29 | 1 | -12.4634 | 130.8456 | 2020-07-02 04:33:46 | Northern Territory, Australia | ||
303186 | 303186 | 2020-07-01 | Australia | Queensland | 1067 | 6 | 1054 | 7 | -27.4698 | 153.0251 | 2020-07-02 04:33:46 | Queensland, Australia | ||
303245 | 303245 | 2020-07-01 | Australia | South Australia | 443 | 4 | 436 | 3 | -34.9285 | 138.6007 | 2020-07-02 04:33:46 | South Australia, Australia | ||
303258 | 303258 | 2020-07-01 | Australia | Tasmania | 228 | 13 | 215 | 0 | -42.8821 | 147.3272 | 2020-07-02 04:33:46 | Tasmania, Australia | ||
303309 | 303309 | 2020-07-01 | Australia | Victoria | 2303 | 20 | 1866 | 417 | -37.8136 | 144.9631 | 2020-07-02 04:33:46 | Victoria, Australia | ||
303320 | 303320 | 2020-07-01 | Australia | Western Australia | 611 | 9 | 598 | 4 | -31.9505 | 115.8605 | 2020-07-02 04:33:46 | Western Australia, Australia | ||
2974241 | 2974241 | 2020-06-30 | Australia | Australian Capital Territory | 108 | 3 | 105 | 0 | -35.4735 | 149.0124 | 2020-07-01 04:33:52 | Australian Capital Territory, Australia | ||
2974502 | 2974502 | 2020-06-30 | Australia | New South Wales | 3203 | 49 | 2787 | 367 | -33.8688 | 151.2093 | 2020-07-01 04:33:52 | New South Wales, Australia | ||
2974514 | 2974514 | 2020-06-30 | Australia | Northern Territory | 29 | 0 | 29 | 0 | -12.4634 | 130.8456 | 2020-07-01 04:33:52 | Northern Territory, Australia | ||
2974564 | 2974564 | 2020-06-30 | Australia | Queensland | 1067 | 6 | 1054 | 7 | -27.4698 | 153.0251 | 2020-07-01 04:33:52 | Queensland, Australia | ||
2974623 | 2974623 | 2020-06-30 | Australia | South Australia | 443 | 4 | 436 | 3 | -34.9285 | 138.6007 | 2020-07-01 04:33:52 | South Australia, Australia | ||
2974636 | 2974636 | 2020-06-30 | Australia | Tasmania | 228 | 13 | 215 | 0 | -42.8821 | 147.3272 | 2020-07-01 04:33:52 | Tasmania, Australia | ||
2974687 | 2974687 | 2020-06-30 | Australia | Victoria | 2231 | 20 | 1816 | 395 | -37.8136 | 144.9631 | 2020-07-01 04:33:52 | Victoria, Australia | ||
2974698 | 2974698 | 2020-06-30 | Australia | Western Australia | 611 | 9 | 598 | 4 | -31.9505 | 115.8605 | 2020-07-01 04:33:52 | Western Australia, Australia | ||
2632718 | 2632718 | 2020-06-29 | Australia | Australian Capital Territory | 108 | 3 | 105 | 0 | -35.4735 | 149.0124 | 2020-06-30 04:33:48 | Australian Capital Territory, Australia | ||
2632979 | 2632979 | 2020-06-29 | Australia | New South Wales | 3189 | 49 | 2784 | 356 | -33.8688 | 151.2093 | 2020-06-30 04:33:48 | New South Wales, Australia | ||
2632991 | 2632991 | 2020-06-29 | Australia | Northern Territory | 29 | 0 | 29 | 0 | -12.4634 | 130.8456 | 2020-06-30 04:33:48 | Northern Territory, Australia | ||
2633041 | 2633041 | 2020-06-29 | Australia | Queensland | 1067 | 6 | 1054 | 7 | -27.4698 | 153.0251 | 2020-06-30 04:33:48 | Queensland, Australia | ||
2633100 | 2633100 | 2020-06-29 | Australia | South Australia | 443 | 4 | 436 | 3 | -34.9285 | 138.6007 | 2020-06-30 04:33:48 | South Australia, Australia | ||
2633113 | 2633113 | 2020-06-29 | Australia | Tasmania | 228 | 13 | 215 | 0 | -42.8821 | 147.3272 | 2020-06-30 04:33:48 | Tasmania, Australia | ||
2633164 | 2633164 | 2020-06-29 | Australia | Victoria | 2159 | 20 | 1816 | 323 | -37.8136 | 144.9631 | 2020-06-30 04:33:48 | Victoria, Australia | ||
2633175 | 2633175 | 2020-06-29 | Australia | Western Australia | 611 | 9 | 598 | 4 | -31.9505 | 115.8605 | 2020-06-30 04:33:48 | Western Australia, Australia | ||
2306281 | 2306281 | 2020-06-28 | Australia | Australian Capital Territory | 108 | 3 | 105 | 0 | -35.4735 | 149.0124 | 2020-06-29 04:33:44 | Australian Capital Territory, Australia | ||
2306542 | 2306542 | 2020-06-28 | Australia | New South Wales | 3184 | 49 | 2784 | 351 | -33.8688 | 151.2093 | 2020-06-29 04:33:44 | New South Wales, Australia | ||
2306554 | 2306554 | 2020-06-28 | Australia | Northern Territory | 29 | 0 | 29 | 0 | -12.4634 | 130.8456 | 2020-06-29 04:33:44 | Northern Territory, Australia | ||
2306604 | 2306604 | 2020-06-28 | Australia | Queensland | 1067 | 6 | 1054 | 7 | -27.4698 | 153.0251 | 2020-06-29 04:33:44 | Queensland, Australia | ||
2306663 | 2306663 | 2020-06-28 | Australia | South Australia | 440 | 4 | 436 | 0 | -34.9285 | 138.6007 | 2020-06-29 04:33:44 | South Australia, Australia | ||
2306676 | 2306676 | 2020-06-28 | Australia | Tasmania | 228 | 13 | 215 | 0 | -42.8821 | 147.3272 | 2020-06-29 04:33:44 | Tasmania, Australia | ||
2306727 | 2306727 | 2020-06-28 | Australia | Victoria | 2099 | 20 | 1789 | 290 | -37.8136 | 144.9631 | 2020-06-29 04:33:44 | Victoria, Australia | ||
2306738 | 2306738 | 2020-06-28 | Australia | Western Australia | 609 | 9 | 595 | 5 | -31.9505 | 115.8605 | 2020-06-29 04:33:44 | Western Australia, Australia | ||
2039616 | 2039616 | 2020-06-27 | Australia | Australian Capital Territory | 108 | 3 | 105 | 0 | -35.4735 | 149.0124 | 2020-06-28 04:34:04 | Australian Capital Territory, Australia | ||
2039877 | 2039877 | 2020-06-27 | Australia | New South Wales | 3177 | 49 | 2784 | 344 | -33.8688 | 151.2093 | 2020-06-28 04:34:04 | New South Wales, Australia | ||
2039889 | 2039889 | 2020-06-27 | Australia | Northern Territory | 29 | 0 | 29 | 0 | -12.4634 | 130.8456 | 2020-06-28 04:34:04 | Northern Territory, Australia | ||
2039939 | 2039939 | 2020-06-27 | Australia | Queensland | 1067 | 6 | 1054 | 7 | -27.4698 | 153.0251 | 2020-06-28 04:34:04 | Queensland, Australia | ||
2039998 | 2039998 | 2020-06-27 | Australia | South Australia | 440 | 4 | 436 | 0 | -34.9285 | 138.6007 | 2020-06-28 04:34:04 | South Australia, Australia | ||
2040011 | 2040011 | 2020-06-27 | Australia | Tasmania | 228 | 13 | 215 | 0 | -42.8821 | 147.3272 | 2020-06-28 04:34:04 | Tasmania, Australia | ||
2040062 | 2040062 | 2020-06-27 | Australia | Victoria | 2028 | 20 | 1775 | 233 | -37.8136 | 144.9631 | 2020-06-28 04:34:04 | Victoria, Australia | ||
2040073 | 2040073 | 2020-06-27 | Australia | Western Australia | 609 | 9 | 595 | 5 | -31.9505 | 115.8605 | 2020-06-28 04:34:04 | Western Australia, Australia | ||
1135897 | 1135897 | 2020-06-26 | Australia | Australian Capital Territory | 108 | 3 | 105 | 0 | -35.4735 | 149.0124 | 2020-06-27 04:33:35 | Australian Capital Territory, Australia | ||
1136158 | 1136158 | 2020-06-26 | Australia | New South Wales | 3174 | 49 | 2784 | 341 | -33.8688 | 151.2093 | 2020-06-27 04:33:35 | New South Wales, Australia | ||
1136170 | 1136170 | 2020-06-26 | Australia | Northern Territory | 29 | 0 | 29 | 0 | -12.4634 | 130.8456 | 2020-06-27 04:33:35 | Northern Territory, Australia | ||
1136220 | 1136220 | 2020-06-26 | Australia | Queensland | 1067 | 6 | 1054 | 7 | -27.4698 | 153.0251 | 2020-06-27 04:33:35 | Queensland, Australia | ||
1136279 | 1136279 | 2020-06-26 | Australia | South Australia | 440 | 4 | 436 | 0 | -34.9285 | 138.6007 | 2020-06-27 04:33:35 | South Australia, Australia | ||
1136292 | 1136292 | 2020-06-26 | Australia | Tasmania | 228 | 13 | 215 | 0 | -42.8821 | 147.3272 | 2020-06-27 04:33:35 | Tasmania, Australia | ||
1136343 | 1136343 | 2020-06-26 | Australia | Victoria | 1947 | 20 | 1742 | 185 | -37.8136 | 144.9631 | 2020-06-27 04:33:35 | Victoria, Australia | ||
1136354 | 1136354 | 2020-06-26 | Australia | Western Australia | 608 | 9 | 595 | 4 | -31.9505 | 115.8605 | 2020-06-27 04:33:35 | Western Australia, Australia | ||
2624884 | 2624884 | 2020-06-25 | Australia | Australian Capital Territory | 108 | 3 | 105 | 0 | -35.4735 | 149.0124 | 2020-06-26 04:33:43 | Australian Capital Territory, Australia | ||
2625145 | 2625145 | 2020-06-25 | Australia | New South Wales | 3168 | 49 | 2782 | 337 | -33.8688 | 151.2093 | 2020-06-26 04:33:43 | New South Wales, Australia | ||
2625157 | 2625157 | 2020-06-25 | Australia | Northern Territory | 29 | 0 | 29 | 0 | -12.4634 | 130.8456 | 2020-06-26 04:33:43 | Northern Territory, Australia | ||
2625207 | 2625207 | 2020-06-25 | Australia | Queensland | 1067 | 6 | 1054 | 7 | -27.4698 | 153.0251 | 2020-06-26 04:33:43 | Queensland, Australia | ||
2625266 | 2625266 | 2020-06-25 | Australia | South Australia | 440 | 4 | 436 | 0 | -34.9285 | 138.6007 | 2020-06-26 04:33:43 | South Australia, Australia | ||
2625279 | 2625279 | 2020-06-25 | Australia | Tasmania | 228 | 13 | 215 | 0 | -42.8821 | 147.3272 | 2020-06-26 04:33:43 | Tasmania, Australia | ||
2625330 | 2625330 | 2020-06-25 | Australia | Victoria | 1947 | 20 | 1742 | 185 | -37.8136 | 144.9631 | 2020-06-26 04:33:43 | Victoria, Australia | ||
2625341 | 2625341 | 2020-06-25 | Australia | Western Australia | 608 | 9 | 595 | 4 | -31.9505 | 115.8605 | 2020-06-26 04:33:43 | Western Australia, Australia | ||
2700524 | 2700524 | 2020-06-24 | Australia | Australian Capital Territory | 108 | 3 | 105 | 0 | -35.4735 | 149.0124 | 2020-06-25 05:26:54 | Australian Capital Territory, Australia | ||
2700785 | 2700785 | 2020-06-24 | Australia | New South Wales | 3162 | 49 | 2776 | 337 | -33.8688 | 151.2093 | 2020-06-25 05:26:54 | New South Wales, Australia | ||
2700797 | 2700797 | 2020-06-24 | Australia | Northern Territory | 29 | 0 | 29 | 0 | -12.4634 | 130.8456 | 2020-06-25 05:26:54 | Northern Territory, Australia | ||
2700847 | 2700847 | 2020-06-24 | Australia | Queensland | 1066 | 6 | 1054 | 6 | -27.4698 | 153.0251 | 2020-06-25 05:26:54 | Queensland, Australia | ||
2700906 | 2700906 | 2020-06-24 | Australia | South Australia | 440 | 4 | 436 | 0 | -34.9285 | 138.6007 | 2020-06-25 05:26:54 | South Australia, Australia | ||
2700919 | 2700919 | 2020-06-24 | Australia | Tasmania | 228 | 13 | 215 | 0 | -42.8821 | 147.3272 | 2020-06-25 05:26:54 | Tasmania, Australia | ||
2700970 | 2700970 | 2020-06-24 | Australia | Victoria | 1917 | 20 | 1721 | 176 | -37.8136 | 144.9631 | 2020-06-25 05:26:54 | Victoria, Australia | ||
2700981 | 2700981 | 2020-06-24 | Australia | Western Australia | 608 | 9 | 595 | 4 | -31.9505 | 115.8605 | 2020-06-25 05:26:54 | Western Australia, Australia | ||
1522209 | 1522209 | 2020-06-23 | Australia | Australian Capital Territory | 108 | 3 | 105 | 0 | -35.4735 | 149.0124 | 2020-06-24 04:33:28 | Australian Capital Territory, Australia | ||
1522470 | 1522470 | 2020-06-23 | Australia | New South Wales | 3159 | 48 | 2771 | 340 | -33.8688 | 151.2093 | 2020-06-24 04:33:28 | New South Wales, Australia | ||
1522482 | 1522482 | 2020-06-23 | Australia | Northern Territory | 29 | 0 | 29 | 0 | -12.4634 | 130.8456 | 2020-06-24 04:33:28 | Northern Territory, Australia | ||
1522532 | 1522532 | 2020-06-23 | Australia | Queensland | 1066 | 6 | 1053 | 7 | -27.4698 | 153.0251 | 2020-06-24 04:33:28 | Queensland, Australia | ||
1522591 | 1522591 | 2020-06-23 | Australia | South Australia | 440 | 4 | 436 | 0 | -34.9285 | 138.6007 | 2020-06-24 04:33:28 | South Australia, Australia | ||
1522604 | 1522604 | 2020-06-23 | Australia | Tasmania | 228 | 13 | 215 | 0 | -42.8821 | 147.3272 | 2020-06-24 04:33:28 | Tasmania, Australia | ||
1522655 | 1522655 | 2020-06-23 | Australia | Victoria | 1884 | 20 | 1721 | 143 | -37.8136 | 144.9631 | 2020-06-24 04:33:28 | Victoria, Australia | ||
1522666 | 1522666 | 2020-06-23 | Australia | Western Australia | 607 | 9 | 594 | 4 | -31.9505 | 115.8605 | 2020-06-24 04:33:28 | Western Australia, Australia | ||
1510403 | 1510403 | 2020-06-22 | Australia | Australian Capital Territory | 108 | 3 | 105 | 0 | -35.4735 | 149.0124 | 2020-06-23 04:33:22 | Australian Capital Territory, Australia | ||
1510664 | 1510664 | 2020-06-22 | Australia | New South Wales | 3150 | 48 | 2771 | 331 | -33.8688 | 151.2093 | 2020-06-23 04:33:22 | New South Wales, Australia | ||
1510676 | 1510676 | 2020-06-22 | Australia | Northern Territory | 29 | 0 | 29 | 0 | -12.4634 | 130.8456 | 2020-06-23 04:33:22 | Northern Territory, Australia | ||
1510726 | 1510726 | 2020-06-22 | Australia | Queensland | 1066 | 6 | 1053 | 7 | -27.4698 | 153.0251 | 2020-06-23 04:33:22 | Queensland, Australia | ||
1510785 | 1510785 | 2020-06-22 | Australia | South Australia | 440 | 4 | 436 | 0 | -34.9285 | 138.6007 | 2020-06-23 04:33:22 | South Australia, Australia | ||
1510798 | 1510798 | 2020-06-22 | Australia | Tasmania | 228 | 13 | 215 | 0 | -42.8821 | 147.3272 | 2020-06-23 04:33:22 | Tasmania, Australia | ||
1510849 | 1510849 | 2020-06-22 | Australia | Victoria | 1864 | 19 | 1712 | 133 | -37.8136 | 144.9631 | 2020-06-23 04:33:22 | Victoria, Australia | ||
1510860 | 1510860 | 2020-06-22 | Australia | Western Australia | 607 | 9 | 594 | 4 | -31.9505 | 115.8605 | 2020-06-23 04:33:22 | Western Australia, Australia | ||
3249142 | 3249142 | 2020-06-21 | Australia | Australian Capital Territory | 108 | 3 | 105 | 0 | -35.4735 | 149.0124 | 2020-06-22 04:33:20 | Australian Capital Territory, Australia | ||
3249403 | 3249403 | 2020-06-21 | Australia | New South Wales | 3151 | 48 | 2771 | 332 | -33.8688 | 151.2093 | 2020-06-22 04:33:20 | New South Wales, Australia | ||
3249415 | 3249415 | 2020-06-21 | Australia | Northern Territory | 29 | 0 | 29 | 0 | -12.4634 | 130.8456 | 2020-06-22 04:33:20 | Northern Territory, Australia | ||
3249465 | 3249465 | 2020-06-21 | Australia | Queensland | 1066 | 6 | 1053 | 7 | -27.4698 | 153.0251 | 2020-06-22 04:33:20 | Queensland, Australia | ||
3249524 | 3249524 | 2020-06-21 | Australia | South Australia | 440 | 4 | 436 | 0 | -34.9285 | 138.6007 | 2020-06-22 04:33:20 | South Australia, Australia | ||
3249537 | 3249537 | 2020-06-21 | Australia | Tasmania | 228 | 13 | 215 | 0 | -42.8821 | 147.3272 | 2020-06-22 04:33:20 | Tasmania, Australia | ||
3249588 | 3249588 | 2020-06-21 | Australia | Victoria | 1847 | 19 | 1701 | 127 | -37.8136 | 144.9631 | 2020-06-22 04:33:20 | Victoria, Australia | ||
3249599 | 3249599 | 2020-06-21 | Australia | Western Australia | 605 | 9 | 593 | 3 | -31.9505 | 115.8605 | 2020-06-22 04:33:20 | Western Australia, Australia | ||
2437735 | 2437735 | 2020-06-20 | Australia | Australian Capital Territory | 108 | 3 | 105 | 0 | -35.4735 | 149.0124 | 2020-06-21 04:33:19 | Australian Capital Territory, Australia | ||
2437996 | 2437996 | 2020-06-20 | Australia | New South Wales | 3149 | 48 | 2771 | 330 | -33.8688 | 151.2093 | 2020-06-21 04:33:19 | New South Wales, Australia | ||
2438008 | 2438008 | 2020-06-20 | Australia | Northern Territory | 29 | 0 | 29 | 0 | -12.4634 | 130.8456 | 2020-06-21 04:33:19 | Northern Territory, Australia | ||
2438058 | 2438058 | 2020-06-20 | Australia | Queensland | 1066 | 6 | 1053 | 7 | -27.4698 | 153.0251 | 2020-06-21 04:33:19 | Queensland, Australia | ||
2438117 | 2438117 | 2020-06-20 | Australia | South Australia | 440 | 4 | 436 | 0 | -34.9285 | 138.6007 | 2020-06-21 04:33:19 | South Australia, Australia | ||
2438130 | 2438130 | 2020-06-20 | Australia | Tasmania | 228 | 13 | 215 | 0 | -42.8821 | 147.3272 | 2020-06-21 04:33:19 | Tasmania, Australia | ||
2438181 | 2438181 | 2020-06-20 | Australia | Victoria | 1836 | 19 | 1694 | 123 | -37.8136 | 144.9631 | 2020-06-21 04:33:19 | Victoria, Australia | ||
2438192 | 2438192 | 2020-06-20 | Australia | Western Australia | 605 | 9 | 593 | 3 | -31.9505 | 115.8605 | 2020-06-21 04:33:19 | Western Australia, Australia | ||
1691313 | 1691313 | 2020-06-19 | Australia | Australian Capital Territory | 108 | 3 | 105 | 0 | -35.4735 | 149.0124 | 2020-06-20 04:33:19 | Australian Capital Territory, Australia | ||
1691574 | 1691574 | 2020-06-19 | Australia | New South Wales | 3144 | 48 | 2771 | 325 | -33.8688 | 151.2093 | 2020-06-20 04:33:19 | New South Wales, Australia | ||
1691586 | 1691586 | 2020-06-19 | Australia | Northern Territory | 29 | 0 | 29 | 0 | -12.4634 | 130.8456 | 2020-06-20 04:33:19 | Northern Territory, Australia | ||
1691636 | 1691636 | 2020-06-19 | Australia | Queensland | 1066 | 6 | 1053 | 7 | -27.4698 | 153.0251 | 2020-06-20 04:33:19 | 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]);