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 265
- Victoria 265
- Queensland 262
- South Australia 260
- Western Australia 232
- Tasmania 230
- Northern Territory 228
- Australian Capital Territory 219
- From Diamond Princess 30
- External territories 1
- Jervis Bay Territory 1
country_or_region 1
- Australia · 1,996 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1026061 | 1026061 | 2020-10-17 | Australia | Australian Capital Territory | 113 | 3 | 110 | 0 | -35.4735 | 149.0124 | 2020-10-18 04:24:25 | Australian Capital Territory, Australia | ||
1026062 | 1026062 | 2020-10-17 | Australia | New South Wales | 4338 | 53 | 0 | 4285 | -33.8688 | 151.2093 | 2020-10-18 04:24:25 | New South Wales, Australia | ||
1026063 | 1026063 | 2020-10-17 | Australia | Northern Territory | 33 | 0 | 33 | 0 | -12.4634 | 130.8456 | 2020-10-18 04:24:25 | Northern Territory, Australia | ||
1026064 | 1026064 | 2020-10-17 | Australia | Queensland | 1164 | 6 | 1154 | 4 | -27.4698 | 153.0251 | 2020-10-18 04:24:25 | Queensland, Australia | ||
1026065 | 1026065 | 2020-10-17 | Australia | South Australia | 482 | 4 | 472 | 6 | -34.9285 | 138.6007 | 2020-10-18 04:24:25 | South Australia, Australia | ||
1026066 | 1026066 | 2020-10-17 | Australia | Tasmania | 230 | 13 | 217 | 0 | -42.8821 | 147.3272 | 2020-10-18 04:24:25 | Tasmania, Australia | ||
1026067 | 1026067 | 2020-10-17 | Australia | Victoria | 20319 | 816 | 19287 | 216 | -37.8136 | 144.9631 | 2020-10-18 04:24:25 | Victoria, Australia | ||
1026068 | 1026068 | 2020-10-17 | Australia | Western Australia | 711 | 9 | 683 | 19 | -31.9505 | 115.8605 | 2020-10-18 04:24:25 | Western Australia, Australia | ||
2856556 | 2856556 | 2020-10-16 | Australia | Australian Capital Territory | 113 | 3 | 110 | 0 | -35.4735 | 149.0124 | 2020-10-17 04:24:12 | Australian Capital Territory, Australia | ||
2856557 | 2856557 | 2020-10-16 | Australia | New South Wales | 4333 | 53 | 0 | 4280 | -33.8688 | 151.2093 | 2020-10-17 04:24:12 | New South Wales, Australia | ||
2856558 | 2856558 | 2020-10-16 | Australia | Northern Territory | 33 | 0 | 33 | 0 | -12.4634 | 130.8456 | 2020-10-17 04:24:12 | Northern Territory, Australia | ||
2856559 | 2856559 | 2020-10-16 | Australia | Queensland | 1164 | 6 | 1154 | 4 | -27.4698 | 153.0251 | 2020-10-17 04:24:12 | Queensland, Australia | ||
2856560 | 2856560 | 2020-10-16 | Australia | South Australia | 479 | 4 | 471 | 4 | -34.9285 | 138.6007 | 2020-10-17 04:24:12 | South Australia, Australia | ||
2856561 | 2856561 | 2020-10-16 | Australia | Tasmania | 230 | 13 | 217 | 0 | -42.8821 | 147.3272 | 2020-10-17 04:24:12 | Tasmania, Australia | ||
2856562 | 2856562 | 2020-10-16 | Australia | Victoria | 20317 | 816 | 19287 | 214 | -37.8136 | 144.9631 | 2020-10-17 04:24:12 | Victoria, Australia | ||
2856563 | 2856563 | 2020-10-16 | Australia | Western Australia | 709 | 9 | 683 | 17 | -31.9505 | 115.8605 | 2020-10-17 04:24:12 | Western Australia, Australia | ||
786086 | 786086 | 2020-10-15 | Australia | Australian Capital Territory | 113 | 3 | 110 | 0 | -35.4735 | 149.0124 | 2020-10-16 04:24:01 | Australian Capital Territory, Australia | ||
786087 | 786087 | 2020-10-15 | Australia | New South Wales | 4326 | 53 | 0 | 4273 | -33.8688 | 151.2093 | 2020-10-16 04:24:01 | New South Wales, Australia | ||
786088 | 786088 | 2020-10-15 | Australia | Northern Territory | 33 | 0 | 33 | 0 | -12.4634 | 130.8456 | 2020-10-16 04:24:01 | Northern Territory, Australia | ||
786089 | 786089 | 2020-10-15 | Australia | Queensland | 1164 | 6 | 1154 | 4 | -27.4698 | 153.0251 | 2020-10-16 04:24:01 | Queensland, Australia | ||
786090 | 786090 | 2020-10-15 | Australia | South Australia | 479 | 4 | 471 | 4 | -34.9285 | 138.6007 | 2020-10-16 04:24:01 | South Australia, Australia | ||
786091 | 786091 | 2020-10-15 | Australia | Tasmania | 230 | 13 | 217 | 0 | -42.8821 | 147.3272 | 2020-10-16 04:24:01 | Tasmania, Australia | ||
786092 | 786092 | 2020-10-15 | Australia | Victoria | 20317 | 816 | 19259 | 242 | -37.8136 | 144.9631 | 2020-10-16 04:24:01 | Victoria, Australia | ||
786093 | 786093 | 2020-10-15 | Australia | Western Australia | 709 | 9 | 676 | 24 | -31.9505 | 115.8605 | 2020-10-16 04:24:01 | Western Australia, Australia | ||
78797 | 78797 | 2020-10-14 | Australia | Australian Capital Territory | 113 | 3 | 110 | 0 | -35.4735 | 149.0124 | 2020-10-15 04:24:28 | Australian Capital Territory, Australia | ||
78798 | 78798 | 2020-10-14 | Australia | New South Wales | 4321 | 53 | 0 | 4268 | -33.8688 | 151.2093 | 2020-10-15 04:24:28 | New South Wales, Australia | ||
78799 | 78799 | 2020-10-14 | Australia | Northern Territory | 33 | 0 | 33 | 0 | -12.4634 | 130.8456 | 2020-10-15 04:24:28 | Northern Territory, Australia | ||
78800 | 78800 | 2020-10-14 | Australia | Queensland | 1162 | 6 | 1154 | 2 | -27.4698 | 153.0251 | 2020-10-15 04:24:28 | Queensland, Australia | ||
78801 | 78801 | 2020-10-14 | Australia | South Australia | 479 | 4 | 469 | 6 | -34.9285 | 138.6007 | 2020-10-15 04:24:28 | South Australia, Australia | ||
78802 | 78802 | 2020-10-14 | Australia | Tasmania | 230 | 13 | 217 | 0 | -42.8821 | 147.3272 | 2020-10-15 04:24:28 | Tasmania, Australia | ||
78803 | 78803 | 2020-10-14 | Australia | Victoria | 20315 | 816 | 19248 | 251 | -37.8136 | 144.9631 | 2020-10-15 04:24:28 | Victoria, Australia | ||
78804 | 78804 | 2020-10-14 | Australia | Western Australia | 704 | 9 | 676 | 19 | -31.9505 | 115.8605 | 2020-10-15 04:24:28 | Western Australia, Australia | ||
3781612 | 3781612 | 2020-10-13 | Australia | Australian Capital Territory | 113 | 3 | 110 | 0 | -35.4735 | 149.0124 | 2020-10-14 04:24:05 | Australian Capital Territory, Australia | ||
3781613 | 3781613 | 2020-10-13 | Australia | New South Wales | 4310 | 53 | 0 | 4257 | -33.8688 | 151.2093 | 2020-10-14 04:24:05 | New South Wales, Australia | ||
3781614 | 3781614 | 2020-10-13 | Australia | Northern Territory | 33 | 0 | 33 | 0 | -12.4634 | 130.8456 | 2020-10-14 04:24:05 | Northern Territory, Australia | ||
3781615 | 3781615 | 2020-10-13 | Australia | Queensland | 1161 | 6 | 1154 | 1 | -27.4698 | 153.0251 | 2020-10-14 04:24:05 | Queensland, Australia | ||
3781616 | 3781616 | 2020-10-13 | Australia | South Australia | 476 | 4 | 468 | 4 | -34.9285 | 138.6007 | 2020-10-14 04:24:05 | South Australia, Australia | ||
3781617 | 3781617 | 2020-10-13 | Australia | Tasmania | 230 | 13 | 217 | 0 | -42.8821 | 147.3272 | 2020-10-14 04:24:05 | Tasmania, Australia | ||
3781618 | 3781618 | 2020-10-13 | Australia | Victoria | 20311 | 816 | 19248 | 247 | -37.8136 | 144.9631 | 2020-10-14 04:24:05 | Victoria, Australia | ||
3781619 | 3781619 | 2020-10-13 | Australia | Western Australia | 703 | 9 | 676 | 18 | -31.9505 | 115.8605 | 2020-10-14 04:24:05 | Western Australia, Australia | ||
2291152 | 2291152 | 2020-10-12 | Australia | Australian Capital Territory | 113 | 3 | 110 | 0 | -35.4735 | 149.0124 | 2020-10-13 04:24:02 | Australian Capital Territory, Australia | ||
2291153 | 2291153 | 2020-10-12 | Australia | New South Wales | 4295 | 53 | 0 | 4242 | -33.8688 | 151.2093 | 2020-10-13 04:24:02 | New South Wales, Australia | ||
2291154 | 2291154 | 2020-10-12 | Australia | Northern Territory | 33 | 0 | 33 | 0 | -12.4634 | 130.8456 | 2020-10-13 04:24:02 | Northern Territory, Australia | ||
2291155 | 2291155 | 2020-10-12 | Australia | Queensland | 1161 | 6 | 1154 | 1 | -27.4698 | 153.0251 | 2020-10-13 04:24:02 | Queensland, Australia | ||
2291156 | 2291156 | 2020-10-12 | Australia | South Australia | 475 | 4 | 467 | 4 | -34.9285 | 138.6007 | 2020-10-13 04:24:02 | South Australia, Australia | ||
2291157 | 2291157 | 2020-10-12 | Australia | Tasmania | 230 | 13 | 217 | 0 | -42.8821 | 147.3272 | 2020-10-13 04:24:02 | Tasmania, Australia | ||
2291158 | 2291158 | 2020-10-12 | Australia | Victoria | 20307 | 811 | 19243 | 253 | -37.8136 | 144.9631 | 2020-10-13 04:24:02 | Victoria, Australia | ||
2291159 | 2291159 | 2020-10-12 | Australia | Western Australia | 696 | 9 | 671 | 16 | -31.9505 | 115.8605 | 2020-10-13 04:24:02 | Western Australia, Australia | ||
3785605 | 3785605 | 2020-10-11 | Australia | Australian Capital Territory | 113 | 3 | 110 | 0 | -35.4735 | 149.0124 | 2020-10-12 04:23:45 | Australian Capital Territory, Australia | ||
3785606 | 3785606 | 2020-10-11 | Australia | New South Wales | 4284 | 53 | 0 | 4231 | -33.8688 | 151.2093 | 2020-10-12 04:23:45 | New South Wales, Australia | ||
3785607 | 3785607 | 2020-10-11 | Australia | Northern Territory | 33 | 0 | 33 | 0 | -12.4634 | 130.8456 | 2020-10-12 04:23:45 | Northern Territory, Australia | ||
3785608 | 3785608 | 2020-10-11 | Australia | Queensland | 1161 | 6 | 1152 | 3 | -27.4698 | 153.0251 | 2020-10-12 04:23:45 | Queensland, Australia | ||
3785609 | 3785609 | 2020-10-11 | Australia | South Australia | 475 | 4 | 466 | 5 | -34.9285 | 138.6007 | 2020-10-12 04:23:45 | South Australia, Australia | ||
3785610 | 3785610 | 2020-10-11 | Australia | Tasmania | 230 | 13 | 217 | 0 | -42.8821 | 147.3272 | 2020-10-12 04:23:45 | Tasmania, Australia | ||
3785611 | 3785611 | 2020-10-11 | Australia | Victoria | 20295 | 810 | 19218 | 267 | -37.8136 | 144.9631 | 2020-10-12 04:23:45 | Victoria, Australia | ||
3785612 | 3785612 | 2020-10-11 | Australia | Western Australia | 694 | 9 | 670 | 15 | -31.9505 | 115.8605 | 2020-10-12 04:23:45 | Western Australia, Australia | ||
2601743 | 2601743 | 2020-10-10 | Australia | Australian Capital Territory | 113 | 3 | 110 | 0 | -35.4735 | 149.0124 | 2020-10-11 04:23:46 | Australian Capital Territory, Australia | ||
2601744 | 2601744 | 2020-10-10 | Australia | New South Wales | 4278 | 53 | 0 | 4225 | -33.8688 | 151.2093 | 2020-10-11 04:23:46 | New South Wales, Australia | ||
2601745 | 2601745 | 2020-10-10 | Australia | Northern Territory | 33 | 0 | 33 | 0 | -12.4634 | 130.8456 | 2020-10-11 04:23:46 | Northern Territory, Australia | ||
2601746 | 2601746 | 2020-10-10 | Australia | Queensland | 1161 | 6 | 1152 | 3 | -27.4698 | 153.0251 | 2020-10-11 04:23:46 | Queensland, Australia | ||
2601747 | 2601747 | 2020-10-10 | Australia | South Australia | 473 | 4 | 466 | 3 | -34.9285 | 138.6007 | 2020-10-11 04:23:46 | South Australia, Australia | ||
2601748 | 2601748 | 2020-10-10 | Australia | Tasmania | 230 | 13 | 217 | 0 | -42.8821 | 147.3272 | 2020-10-11 04:23:46 | Tasmania, Australia | ||
2601749 | 2601749 | 2020-10-10 | Australia | Victoria | 20281 | 810 | 19207 | 264 | -37.8136 | 144.9631 | 2020-10-11 04:23:46 | Victoria, Australia | ||
2601750 | 2601750 | 2020-10-10 | Australia | Western Australia | 694 | 9 | 670 | 15 | -31.9505 | 115.8605 | 2020-10-11 04:23:46 | Western Australia, Australia | ||
817276 | 817276 | 2020-10-09 | Australia | Australian Capital Territory | 113 | 3 | 110 | 0 | -35.4735 | 149.0124 | 2020-10-10 04:23:57 | Australian Capital Territory, Australia | ||
817277 | 817277 | 2020-10-09 | Australia | New South Wales | 4273 | 53 | 0 | 4220 | -33.8688 | 151.2093 | 2020-10-10 04:23:57 | New South Wales, Australia | ||
817278 | 817278 | 2020-10-09 | Australia | Northern Territory | 33 | 0 | 33 | 0 | -12.4634 | 130.8456 | 2020-10-10 04:23:57 | Northern Territory, Australia | ||
817279 | 817279 | 2020-10-09 | Australia | Queensland | 1161 | 6 | 1152 | 3 | -27.4698 | 153.0251 | 2020-10-10 04:23:57 | Queensland, Australia | ||
817280 | 817280 | 2020-10-09 | Australia | South Australia | 473 | 4 | 466 | 3 | -34.9285 | 138.6007 | 2020-10-10 04:23:57 | South Australia, Australia | ||
817281 | 817281 | 2020-10-09 | Australia | Tasmania | 230 | 13 | 217 | 0 | -42.8821 | 147.3272 | 2020-10-10 04:23:57 | Tasmania, Australia | ||
817282 | 817282 | 2020-10-09 | Australia | Victoria | 20269 | 809 | 19207 | 253 | -37.8136 | 144.9631 | 2020-10-10 04:23:57 | Victoria, Australia | ||
817283 | 817283 | 2020-10-09 | Australia | Western Australia | 692 | 9 | 670 | 13 | -31.9505 | 115.8605 | 2020-10-10 04:23:57 | Western Australia, Australia | ||
2689391 | 2689391 | 2020-10-08 | Australia | Australian Capital Territory | 113 | 3 | 110 | 0 | -35.4735 | 149.0124 | 2020-10-09 04:23:59 | Australian Capital Territory, Australia | ||
2689392 | 2689392 | 2020-10-08 | Australia | New South Wales | 4271 | 53 | 0 | 4218 | -33.8688 | 151.2093 | 2020-10-09 04:23:59 | New South Wales, Australia | ||
2689393 | 2689393 | 2020-10-08 | Australia | Northern Territory | 33 | 0 | 31 | 2 | -12.4634 | 130.8456 | 2020-10-09 04:23:59 | Northern Territory, Australia | ||
2689394 | 2689394 | 2020-10-08 | Australia | Queensland | 1160 | 6 | 1152 | 2 | -27.4698 | 153.0251 | 2020-10-09 04:23:59 | Queensland, Australia | ||
2689395 | 2689395 | 2020-10-08 | Australia | South Australia | 472 | 4 | 465 | 3 | -34.9285 | 138.6007 | 2020-10-09 04:23:59 | South Australia, Australia | ||
2689396 | 2689396 | 2020-10-08 | Australia | Tasmania | 230 | 13 | 217 | 0 | -42.8821 | 147.3272 | 2020-10-09 04:23:59 | Tasmania, Australia | ||
2689397 | 2689397 | 2020-10-08 | Australia | Victoria | 20257 | 809 | 19192 | 256 | -37.8136 | 144.9631 | 2020-10-09 04:23:59 | Victoria, Australia | ||
2689398 | 2689398 | 2020-10-08 | Australia | Western Australia | 690 | 9 | 670 | 11 | -31.9505 | 115.8605 | 2020-10-09 04:23:59 | Western Australia, Australia | ||
1041533 | 1041533 | 2020-10-07 | Australia | Australian Capital Territory | 113 | 3 | 110 | 0 | -35.4735 | 149.0124 | 2020-10-08 04:23:56 | Australian Capital Territory, Australia | ||
1041534 | 1041534 | 2020-10-07 | Australia | New South Wales | 4261 | 53 | 0 | 4208 | -33.8688 | 151.2093 | 2020-10-08 04:23:56 | New South Wales, Australia | ||
1041535 | 1041535 | 2020-10-07 | Australia | Northern Territory | 33 | 0 | 33 | 0 | -12.4634 | 130.8456 | 2020-10-08 04:23:56 | Northern Territory, Australia | ||
1041536 | 1041536 | 2020-10-07 | Australia | Queensland | 1160 | 6 | 1149 | 5 | -27.4698 | 153.0251 | 2020-10-08 04:23:56 | Queensland, Australia | ||
1041537 | 1041537 | 2020-10-07 | Australia | South Australia | 472 | 4 | 465 | 3 | -34.9285 | 138.6007 | 2020-10-08 04:23:56 | South Australia, Australia | ||
1041538 | 1041538 | 2020-10-07 | Australia | Tasmania | 230 | 13 | 217 | 0 | -42.8821 | 147.3272 | 2020-10-08 04:23:56 | Tasmania, Australia | ||
1041539 | 1041539 | 2020-10-07 | Australia | Victoria | 20247 | 809 | 19162 | 276 | -37.8136 | 144.9631 | 2020-10-08 04:23:56 | Victoria, Australia | ||
1041540 | 1041540 | 2020-10-07 | Australia | Western Australia | 690 | 9 | 670 | 11 | -31.9505 | 115.8605 | 2020-10-08 04:23:56 | Western Australia, Australia | ||
3117194 | 3117194 | 2020-10-06 | Australia | Australian Capital Territory | 113 | 3 | 110 | 0 | -35.4735 | 149.0124 | 2020-10-07 04:23:40 | Australian Capital Territory, Australia | ||
3117195 | 3117195 | 2020-10-06 | Australia | New South Wales | 4249 | 53 | 0 | 4196 | -33.8688 | 151.2093 | 2020-10-07 04:23:40 | New South Wales, Australia | ||
3117196 | 3117196 | 2020-10-06 | Australia | Northern Territory | 33 | 0 | 33 | 0 | -12.4634 | 130.8456 | 2020-10-07 04:23:40 | Northern Territory, Australia | ||
3117197 | 3117197 | 2020-10-06 | Australia | Queensland | 1160 | 6 | 1148 | 6 | -27.4698 | 153.0251 | 2020-10-07 04:23:40 | Queensland, Australia | ||
3117198 | 3117198 | 2020-10-06 | Australia | South Australia | 472 | 4 | 465 | 3 | -34.9285 | 138.6007 | 2020-10-07 04:23:40 | South Australia, Australia | ||
3117199 | 3117199 | 2020-10-06 | Australia | Tasmania | 230 | 13 | 217 | 0 | -42.8821 | 147.3272 | 2020-10-07 04:23:40 | Tasmania, Australia | ||
3117200 | 3117200 | 2020-10-06 | Australia | Victoria | 20237 | 809 | 19149 | 279 | -37.8136 | 144.9631 | 2020-10-07 04:23:40 | Victoria, Australia | ||
3117201 | 3117201 | 2020-10-06 | Australia | Western Australia | 687 | 9 | 664 | 14 | -31.9505 | 115.8605 | 2020-10-07 04:23:40 | Western Australia, Australia | ||
3801606 | 3801606 | 2020-10-05 | Australia | Australian Capital Territory | 113 | 3 | 110 | 0 | -35.4735 | 149.0124 | 2020-10-06 04:23:33 | Australian Capital Territory, Australia | ||
3801607 | 3801607 | 2020-10-05 | Australia | New South Wales | 4246 | 53 | 0 | 4193 | -33.8688 | 151.2093 | 2020-10-06 04:23:33 | New South Wales, Australia | ||
3801608 | 3801608 | 2020-10-05 | Australia | Northern Territory | 33 | 0 | 33 | 0 | -12.4634 | 130.8456 | 2020-10-06 04:23:33 | Northern Territory, Australia | ||
3801609 | 3801609 | 2020-10-05 | Australia | Queensland | 1160 | 6 | 1148 | 6 | -27.4698 | 153.0251 | 2020-10-06 04:23:33 | 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]);