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 837
- Victoria 837
- Queensland 834
- South Australia 832
- Western Australia 804
- Tasmania 802
- Northern Territory 800
- Australian Capital Territory 791
- From Diamond Princess 30
- External territories 1
- Jervis Bay Territory 1
country_or_region 1
- Australia · 6,572 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2533077 | 2533077 | 2022-05-12 | Australia | Australian Capital Territory | 116905 | 58 | 0 | -35.4735 | 149.0124 | 2022-05-13 04:20:51 | Australian Capital Territory, Australia | |||
2533078 | 2533078 | 2022-05-12 | Australia | New South Wales | 2419692 | 2943 | 0 | -33.8688 | 151.2093 | 2022-05-13 04:20:51 | New South Wales, Australia | |||
2533079 | 2533079 | 2022-05-12 | Australia | Northern Territory | 67094 | 46 | 0 | -12.4634 | 130.8456 | 2022-05-13 04:20:51 | Northern Territory, Australia | |||
2533080 | 2533080 | 2022-05-12 | Australia | Queensland | 1071750 | 933 | 0 | -27.4698 | 153.0251 | 2022-05-13 04:20:51 | Queensland, Australia | |||
2533081 | 2533081 | 2022-05-12 | Australia | South Australia | 449227 | 393 | 0 | -34.9285 | 138.6007 | 2022-05-13 04:20:51 | South Australia, Australia | |||
2533082 | 2533082 | 2022-05-12 | Australia | Tasmania | 148367 | 63 | 0 | -42.8821 | 147.3272 | 2022-05-13 04:20:51 | Tasmania, Australia | |||
2533083 | 2533083 | 2022-05-12 | Australia | Victoria | 1700795 | 3101 | 0 | -37.8136 | 144.9631 | 2022-05-13 04:20:51 | Victoria, Australia | |||
2533084 | 2533084 | 2022-05-12 | Australia | Western Australia | 523052 | 181 | 0 | -31.9505 | 115.8605 | 2022-05-13 04:20:51 | Western Australia, Australia | |||
3444523 | 3444523 | 2022-05-11 | Australia | Australian Capital Territory | 115688 | 58 | 0 | -35.4735 | 149.0124 | 2022-05-12 04:20:54 | Australian Capital Territory, Australia | |||
3444524 | 3444524 | 2022-05-11 | Australia | New South Wales | 2407720 | 2930 | 0 | -33.8688 | 151.2093 | 2022-05-12 04:20:54 | New South Wales, Australia | |||
3444525 | 3444525 | 2022-05-11 | Australia | Northern Territory | 66771 | 46 | 0 | -12.4634 | 130.8456 | 2022-05-12 04:20:54 | Northern Territory, Australia | |||
3444526 | 3444526 | 2022-05-11 | Australia | Queensland | 1067417 | 921 | 0 | -27.4698 | 153.0251 | 2022-05-12 04:20:54 | Queensland, Australia | |||
3444527 | 3444527 | 2022-05-11 | Australia | South Australia | 449227 | 393 | 0 | -34.9285 | 138.6007 | 2022-05-12 04:20:54 | South Australia, Australia | |||
3444528 | 3444528 | 2022-05-11 | Australia | Tasmania | 147252 | 61 | 0 | -42.8821 | 147.3272 | 2022-05-12 04:20:54 | Tasmania, Australia | |||
3444529 | 3444529 | 2022-05-11 | Australia | Victoria | 1687747 | 3083 | 0 | -37.8136 | 144.9631 | 2022-05-12 04:20:54 | Victoria, Australia | |||
3444530 | 3444530 | 2022-05-11 | Australia | Western Australia | 507544 | 176 | 0 | -31.9505 | 115.8605 | 2022-05-12 04:20:54 | Western Australia, Australia | |||
3535140 | 3535140 | 2022-05-10 | Australia | Australian Capital Territory | 114564 | 58 | 0 | -35.4735 | 149.0124 | 2022-05-11 04:20:48 | Australian Capital Territory, Australia | |||
3535141 | 3535141 | 2022-05-10 | Australia | New South Wales | 2395359 | 2907 | 0 | -33.8688 | 151.2093 | 2022-05-11 04:20:48 | New South Wales, Australia | |||
3535142 | 3535142 | 2022-05-10 | Australia | Northern Territory | 66760 | 45 | 0 | -12.4634 | 130.8456 | 2022-05-11 04:20:48 | Northern Territory, Australia | |||
3535143 | 3535143 | 2022-05-10 | Australia | Queensland | 1060169 | 918 | 0 | -27.4698 | 153.0251 | 2022-05-11 04:20:48 | Queensland, Australia | |||
3535144 | 3535144 | 2022-05-10 | Australia | South Australia | 444522 | 386 | 0 | -34.9285 | 138.6007 | 2022-05-11 04:20:48 | South Australia, Australia | |||
3535145 | 3535145 | 2022-05-10 | Australia | Tasmania | 146212 | 60 | 0 | -42.8821 | 147.3272 | 2022-05-11 04:20:48 | Tasmania, Australia | |||
3535146 | 3535146 | 2022-05-10 | Australia | Victoria | 1673533 | 3069 | 0 | -37.8136 | 144.9631 | 2022-05-11 04:20:48 | Victoria, Australia | |||
3535147 | 3535147 | 2022-05-10 | Australia | Western Australia | 490899 | 173 | 0 | -31.9505 | 115.8605 | 2022-05-11 04:20:48 | Western Australia, Australia | |||
221675 | 221675 | 2022-05-09 | Australia | Australian Capital Territory | 113368 | 56 | 0 | -35.4735 | 149.0124 | 2022-05-10 04:20:50 | Australian Capital Territory, Australia | |||
221676 | 221676 | 2022-05-09 | Australia | New South Wales | 2383412 | 2896 | 0 | -33.8688 | 151.2093 | 2022-05-10 04:20:50 | New South Wales, Australia | |||
221677 | 221677 | 2022-05-09 | Australia | Northern Territory | 66427 | 45 | 0 | -12.4634 | 130.8456 | 2022-05-10 04:20:50 | Northern Territory, Australia | |||
221678 | 221678 | 2022-05-09 | Australia | Queensland | 1052748 | 908 | 0 | -27.4698 | 153.0251 | 2022-05-10 04:20:50 | Queensland, Australia | |||
221679 | 221679 | 2022-05-09 | Australia | South Australia | 440223 | 378 | 0 | -34.9285 | 138.6007 | 2022-05-10 04:20:50 | South Australia, Australia | |||
221680 | 221680 | 2022-05-09 | Australia | Tasmania | 145182 | 60 | 0 | -42.8821 | 147.3272 | 2022-05-10 04:20:50 | Tasmania, Australia | |||
221681 | 221681 | 2022-05-09 | Australia | Victoria | 1659695 | 3052 | 0 | -37.8136 | 144.9631 | 2022-05-10 04:20:50 | Victoria, Australia | |||
221682 | 221682 | 2022-05-09 | Australia | Western Australia | 473909 | 164 | 0 | -31.9505 | 115.8605 | 2022-05-10 04:20:50 | Western Australia, Australia | |||
2331060 | 2331060 | 2022-05-08 | Australia | Australian Capital Territory | 112407 | 55 | 0 | -35.4735 | 149.0124 | 2022-05-09 04:20:54 | Australian Capital Territory, Australia | |||
2331061 | 2331061 | 2022-05-08 | Australia | New South Wales | 2373235 | 2879 | 0 | -33.8688 | 151.2093 | 2022-05-09 04:20:54 | New South Wales, Australia | |||
2331062 | 2331062 | 2022-05-08 | Australia | Northern Territory | 66083 | 45 | 0 | -12.4634 | 130.8456 | 2022-05-09 04:20:54 | Northern Territory, Australia | |||
2331063 | 2331063 | 2022-05-08 | Australia | Queensland | 1046200 | 905 | 0 | -27.4698 | 153.0251 | 2022-05-09 04:20:54 | Queensland, Australia | |||
2331064 | 2331064 | 2022-05-08 | Australia | South Australia | 436318 | 375 | 0 | -34.9285 | 138.6007 | 2022-05-09 04:20:54 | South Australia, Australia | |||
2331065 | 2331065 | 2022-05-08 | Australia | Tasmania | 144107 | 59 | 0 | -42.8821 | 147.3272 | 2022-05-09 04:20:54 | Tasmania, Australia | |||
2331066 | 2331066 | 2022-05-08 | Australia | Victoria | 1647028 | 3034 | 0 | -37.8136 | 144.9631 | 2022-05-09 04:20:54 | Victoria, Australia | |||
2331067 | 2331067 | 2022-05-08 | Australia | Western Australia | 461553 | 164 | 0 | -31.9505 | 115.8605 | 2022-05-09 04:20:54 | Western Australia, Australia | |||
360022 | 360022 | 2022-05-07 | Australia | Australian Capital Territory | 111599 | 55 | 0 | -35.4735 | 149.0124 | 2022-05-08 04:20:49 | Australian Capital Territory, Australia | |||
360023 | 360023 | 2022-05-07 | Australia | New South Wales | 2365484 | 2876 | 0 | -33.8688 | 151.2093 | 2022-05-08 04:20:49 | New South Wales, Australia | |||
360024 | 360024 | 2022-05-07 | Australia | Northern Territory | 65881 | 45 | 0 | -12.4634 | 130.8456 | 2022-05-08 04:20:49 | Northern Territory, Australia | |||
360025 | 360025 | 2022-05-07 | Australia | Queensland | 1041450 | 905 | 0 | -27.4698 | 153.0251 | 2022-05-08 04:20:49 | Queensland, Australia | |||
360026 | 360026 | 2022-05-07 | Australia | South Australia | 430466 | 371 | 0 | -34.9285 | 138.6007 | 2022-05-08 04:20:49 | South Australia, Australia | |||
360027 | 360027 | 2022-05-07 | Australia | Tasmania | 143267 | 59 | 0 | -42.8821 | 147.3272 | 2022-05-08 04:20:49 | Tasmania, Australia | |||
360028 | 360028 | 2022-05-07 | Australia | Victoria | 1637135 | 3034 | 0 | -37.8136 | 144.9631 | 2022-05-08 04:20:49 | Victoria, Australia | |||
360029 | 360029 | 2022-05-07 | Australia | Western Australia | 451192 | 164 | 0 | -31.9505 | 115.8605 | 2022-05-08 04:20:49 | Western Australia, Australia | |||
1397373 | 1397373 | 2022-05-06 | Australia | Australian Capital Territory | 110846 | 55 | 0 | -35.4735 | 149.0124 | 2022-05-07 04:21:09 | Australian Capital Territory, Australia | |||
1397374 | 1397374 | 2022-05-06 | Australia | New South Wales | 2356642 | 2870 | 0 | -33.8688 | 151.2093 | 2022-05-07 04:21:09 | New South Wales, Australia | |||
1397375 | 1397375 | 2022-05-06 | Australia | Northern Territory | 65659 | 45 | 0 | -12.4634 | 130.8456 | 2022-05-07 04:21:09 | Northern Territory, Australia | |||
1397376 | 1397376 | 2022-05-06 | Australia | Queensland | 1036786 | 903 | 0 | -27.4698 | 153.0251 | 2022-05-07 04:21:09 | Queensland, Australia | |||
1397377 | 1397377 | 2022-05-06 | Australia | South Australia | 424182 | 371 | 0 | -34.9285 | 138.6007 | 2022-05-07 04:21:09 | South Australia, Australia | |||
1397378 | 1397378 | 2022-05-06 | Australia | Tasmania | 142541 | 58 | 0 | -42.8821 | 147.3272 | 2022-05-07 04:21:09 | Tasmania, Australia | |||
1397379 | 1397379 | 2022-05-06 | Australia | Victoria | 1628531 | 3030 | 0 | -37.8136 | 144.9631 | 2022-05-07 04:21:09 | Victoria, Australia | |||
1397380 | 1397380 | 2022-05-06 | Australia | Western Australia | 442481 | 163 | 0 | -31.9505 | 115.8605 | 2022-05-07 04:21:09 | Western Australia, Australia | |||
2597728 | 2597728 | 2022-05-05 | Australia | Australian Capital Territory | 109879 | 55 | 0 | -35.4735 | 149.0124 | 2022-05-06 04:21:00 | Australian Capital Territory, Australia | |||
2597729 | 2597729 | 2022-05-05 | Australia | New South Wales | 2345156 | 2851 | 0 | -33.8688 | 151.2093 | 2022-05-06 04:21:00 | New South Wales, Australia | |||
2597730 | 2597730 | 2022-05-05 | Australia | Northern Territory | 64983 | 44 | 0 | -12.4634 | 130.8456 | 2022-05-06 04:21:00 | Northern Territory, Australia | |||
2597731 | 2597731 | 2022-05-05 | Australia | Queensland | 1030172 | 898 | 0 | -27.4698 | 153.0251 | 2022-05-06 04:21:00 | Queensland, Australia | |||
2597732 | 2597732 | 2022-05-05 | Australia | South Australia | 427205 | 371 | 0 | -34.9285 | 138.6007 | 2022-05-06 04:21:00 | South Australia, Australia | |||
2597733 | 2597733 | 2022-05-05 | Australia | Tasmania | 141647 | 56 | 0 | -42.8821 | 147.3272 | 2022-05-06 04:21:00 | Tasmania, Australia | |||
2597734 | 2597734 | 2022-05-05 | Australia | Victoria | 1619296 | 3021 | 0 | -37.8136 | 144.9631 | 2022-05-06 04:21:00 | Victoria, Australia | |||
2597735 | 2597735 | 2022-05-05 | Australia | Western Australia | 433295 | 157 | 0 | -31.9505 | 115.8605 | 2022-05-06 04:21:00 | Western Australia, Australia | |||
3265177 | 3265177 | 2022-05-04 | Australia | Australian Capital Territory | 108830 | 54 | 0 | -35.4735 | 149.0124 | 2022-05-05 04:20:55 | Australian Capital Territory, Australia | |||
3265178 | 3265178 | 2022-05-04 | Australia | New South Wales | 2334360 | 2844 | 0 | -33.8688 | 151.2093 | 2022-05-05 04:20:55 | New South Wales, Australia | |||
3265179 | 3265179 | 2022-05-04 | Australia | Northern Territory | 64983 | 43 | 0 | -12.4634 | 130.8456 | 2022-05-05 04:20:55 | Northern Territory, Australia | |||
3265180 | 3265180 | 2022-05-04 | Australia | Queensland | 1023149 | 887 | 0 | -27.4698 | 153.0251 | 2022-05-05 04:20:55 | Queensland, Australia | |||
3265181 | 3265181 | 2022-05-04 | Australia | South Australia | 424182 | 370 | 0 | -34.9285 | 138.6007 | 2022-05-05 04:20:55 | South Australia, Australia | |||
3265182 | 3265182 | 2022-05-04 | Australia | Tasmania | 140554 | 56 | 0 | -42.8821 | 147.3272 | 2022-05-05 04:20:55 | Tasmania, Australia | |||
3265183 | 3265183 | 2022-05-04 | Australia | Victoria | 1609060 | 3012 | 0 | -37.8136 | 144.9631 | 2022-05-05 04:20:55 | Victoria, Australia | |||
3265184 | 3265184 | 2022-05-04 | Australia | Western Australia | 425704 | 157 | 0 | -31.9505 | 115.8605 | 2022-05-05 04:20:55 | Western Australia, Australia | |||
1571816 | 1571816 | 2022-05-03 | Australia | Australian Capital Territory | 107769 | 54 | 0 | -35.4735 | 149.0124 | 2022-05-04 04:20:59 | Australian Capital Territory, Australia | |||
1571817 | 1571817 | 2022-05-03 | Australia | New South Wales | 2316269 | 2823 | 0 | -33.8688 | 151.2093 | 2022-05-04 04:20:59 | New South Wales, Australia | |||
1571818 | 1571818 | 2022-05-03 | Australia | Northern Territory | 64540 | 43 | 0 | -12.4634 | 130.8456 | 2022-05-04 04:20:59 | Northern Territory, Australia | |||
1571819 | 1571819 | 2022-05-03 | Australia | Queensland | 1015120 | 876 | 0 | -27.4698 | 153.0251 | 2022-05-04 04:20:59 | Queensland, Australia | |||
1571820 | 1571820 | 2022-05-03 | Australia | South Australia | 416371 | 354 | 0 | -34.9285 | 138.6007 | 2022-05-04 04:20:59 | South Australia, Australia | |||
1571821 | 1571821 | 2022-05-03 | Australia | Tasmania | 139468 | 56 | 0 | -42.8821 | 147.3272 | 2022-05-04 04:20:59 | Tasmania, Australia | |||
1571822 | 1571822 | 2022-05-03 | Australia | Victoria | 1597464 | 2998 | 0 | -37.8136 | 144.9631 | 2022-05-04 04:20:59 | Victoria, Australia | |||
1571823 | 1571823 | 2022-05-03 | Australia | Western Australia | 415563 | 151 | 0 | -31.9505 | 115.8605 | 2022-05-04 04:20:59 | Western Australia, Australia | |||
463076 | 463076 | 2022-05-02 | Australia | Australian Capital Territory | 106705 | 53 | 0 | -35.4735 | 149.0124 | 2022-05-03 04:21:00 | Australian Capital Territory, Australia | |||
463077 | 463077 | 2022-05-02 | Australia | New South Wales | 2304435 | 2802 | 0 | -33.8688 | 151.2093 | 2022-05-03 04:21:00 | New South Wales, Australia | |||
463078 | 463078 | 2022-05-02 | Australia | Northern Territory | 64151 | 43 | 0 | -12.4634 | 130.8456 | 2022-05-03 04:21:00 | Northern Territory, Australia | |||
463079 | 463079 | 2022-05-02 | Australia | Queensland | 1007459 | 868 | 0 | -27.4698 | 153.0251 | 2022-05-03 04:21:00 | Queensland, Australia | |||
463080 | 463080 | 2022-05-02 | Australia | South Australia | 416371 | 354 | 0 | -34.9285 | 138.6007 | 2022-05-03 04:21:00 | South Australia, Australia | |||
463081 | 463081 | 2022-05-02 | Australia | Tasmania | 138395 | 55 | 0 | -42.8821 | 147.3272 | 2022-05-03 04:21:00 | Tasmania, Australia | |||
463082 | 463082 | 2022-05-02 | Australia | Victoria | 1586876 | 2987 | 0 | -37.8136 | 144.9631 | 2022-05-03 04:21:00 | Victoria, Australia | |||
463083 | 463083 | 2022-05-02 | Australia | Western Australia | 405848 | 148 | 0 | -31.9505 | 115.8605 | 2022-05-03 04:21:00 | Western Australia, Australia | |||
3915715 | 3915715 | 2022-05-01 | Australia | Australian Capital Territory | 105739 | 52 | 0 | -35.4735 | 149.0124 | 2022-05-02 04:21:10 | Australian Capital Territory, Australia | |||
3915716 | 3915716 | 2022-05-01 | Australia | New South Wales | 2294900 | 2779 | 0 | -33.8688 | 151.2093 | 2022-05-02 04:21:10 | New South Wales, Australia | |||
3915717 | 3915717 | 2022-05-01 | Australia | Northern Territory | 63568 | 43 | 0 | -12.4634 | 130.8456 | 2022-05-02 04:21:10 | Northern Territory, Australia | |||
3915718 | 3915718 | 2022-05-01 | Australia | Queensland | 1002257 | 868 | 0 | -27.4698 | 153.0251 | 2022-05-02 04:21:10 | Queensland, Australia | |||
3915719 | 3915719 | 2022-05-01 | Australia | South Australia | 413321 | 351 | 0 | -34.9285 | 138.6007 | 2022-05-02 04:21:10 | South Australia, Australia | |||
3915720 | 3915720 | 2022-05-01 | Australia | Tasmania | 137359 | 54 | 0 | -42.8821 | 147.3272 | 2022-05-02 04:21:10 | Tasmania, Australia | |||
3915721 | 3915721 | 2022-05-01 | Australia | Victoria | 1576945 | 2949 | 0 | -37.8136 | 144.9631 | 2022-05-02 04:21:10 | Victoria, Australia | |||
3915722 | 3915722 | 2022-05-01 | Australia | Western Australia | 398270 | 148 | 0 | -31.9505 | 115.8605 | 2022-05-02 04:21:10 | Western Australia, Australia | |||
2840519 | 2840519 | 2022-04-30 | Australia | Australian Capital Territory | 104941 | 51 | 0 | -35.4735 | 149.0124 | 2022-05-01 04:20:57 | Australian Capital Territory, Australia | |||
2840520 | 2840520 | 2022-04-30 | Australia | New South Wales | 2287281 | 2774 | 0 | -33.8688 | 151.2093 | 2022-05-01 04:20:57 | New South Wales, Australia | |||
2840521 | 2840521 | 2022-04-30 | Australia | Northern Territory | 63289 | 43 | 0 | -12.4634 | 130.8456 | 2022-05-01 04:20:57 | Northern Territory, Australia | |||
2840522 | 2840522 | 2022-04-30 | Australia | Queensland | 997619 | 868 | 0 | -27.4698 | 153.0251 | 2022-05-01 04:20:57 | 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]);