johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
2,764 rows where country_or_region = "Australia" sorted by day descending
This data as json, yaml, copyable, CSV (advanced)
Suggested facets: latitude, longitude, combined_key, day (date), last_update (date)
province_or_state
- New South Wales 361
- Victoria 361
- Queensland 358
- South Australia 356
- Western Australia 328
- Tasmania 326
- Northern Territory 324
- Australian Capital Territory 315
- From Diamond Princess 30
- External territories 1
- Jervis Bay Territory 1
country_or_region
- Australia · 2,764 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
298303 | 298303 | 2021-01-21 | Australia | Australian Capital Territory | 118 | 3 | 115 | 0 | -35.4735 | 149.0124 | 2021-01-22 05:22:10 | Australian Capital Territory, Australia | ||
298304 | 298304 | 2021-01-21 | Australia | New South Wales | 5083 | 54 | 3236 | 1793 | -33.8688 | 151.2093 | 2021-01-22 05:22:10 | New South Wales, Australia | ||
298305 | 298305 | 2021-01-21 | Australia | Northern Territory | 97 | 0 | 89 | 8 | -12.4634 | 130.8456 | 2021-01-22 05:22:10 | Northern Territory, Australia | ||
298306 | 298306 | 2021-01-21 | Australia | Queensland | 1303 | 6 | 1261 | 36 | -27.4698 | 153.0251 | 2021-01-22 05:22:10 | Queensland, Australia | ||
298307 | 298307 | 2021-01-21 | Australia | South Australia | 596 | 4 | 587 | 5 | -34.9285 | 138.6007 | 2021-01-22 05:22:10 | South Australia, Australia | ||
298308 | 298308 | 2021-01-21 | Australia | Tasmania | 234 | 13 | 221 | 0 | -42.8821 | 147.3272 | 2021-01-22 05:22:10 | Tasmania, Australia | ||
298309 | 298309 | 2021-01-21 | Australia | Victoria | 20434 | 820 | 19583 | 31 | -37.8136 | 144.9631 | 2021-01-22 05:22:10 | Victoria, Australia | ||
298310 | 298310 | 2021-01-21 | Australia | Western Australia | 890 | 9 | 869 | 12 | -31.9505 | 115.8605 | 2021-01-22 05:22:10 | Western Australia, Australia | ||
889355 | 889355 | 2021-01-20 | Australia | Australian Capital Territory | 118 | 3 | 115 | 0 | -35.4735 | 149.0124 | 2021-01-21 05:22:01 | Australian Capital Territory, Australia | ||
889356 | 889356 | 2021-01-20 | Australia | New South Wales | 5084 | 54 | 3236 | 1794 | -33.8688 | 151.2093 | 2021-01-21 05:22:01 | New South Wales, Australia | ||
889357 | 889357 | 2021-01-20 | Australia | Northern Territory | 96 | 0 | 87 | 9 | -12.4634 | 130.8456 | 2021-01-21 05:22:01 | Northern Territory, Australia | ||
889358 | 889358 | 2021-01-20 | Australia | Queensland | 1300 | 6 | 1261 | 33 | -27.4698 | 153.0251 | 2021-01-21 05:22:01 | Queensland, Australia | ||
889359 | 889359 | 2021-01-20 | Australia | South Australia | 596 | 4 | 587 | 5 | -34.9285 | 138.6007 | 2021-01-21 05:22:01 | South Australia, Australia | ||
889360 | 889360 | 2021-01-20 | Australia | Tasmania | 234 | 13 | 221 | 0 | -42.8821 | 147.3272 | 2021-01-21 05:22:01 | Tasmania, Australia | ||
889361 | 889361 | 2021-01-20 | Australia | Victoria | 20433 | 820 | 19579 | 34 | -37.8136 | 144.9631 | 2021-01-21 05:22:01 | Victoria, Australia | ||
889362 | 889362 | 2021-01-20 | Australia | Western Australia | 888 | 9 | 866 | 13 | -31.9505 | 115.8605 | 2021-01-21 05:22:01 | Western Australia, Australia | ||
317922 | 317922 | 2021-01-19 | Australia | Australian Capital Territory | 118 | 3 | 115 | 0 | -35.4735 | 149.0124 | 2021-01-20 05:21:54 | Australian Capital Territory, Australia | ||
317923 | 317923 | 2021-01-19 | Australia | New South Wales | 5079 | 54 | 3234 | 1791 | -33.8688 | 151.2093 | 2021-01-20 05:21:54 | New South Wales, Australia | ||
317924 | 317924 | 2021-01-19 | Australia | Northern Territory | 95 | 0 | 87 | 8 | -12.4634 | 130.8456 | 2021-01-20 05:21:54 | Northern Territory, Australia | ||
317925 | 317925 | 2021-01-19 | Australia | Queensland | 1299 | 6 | 1258 | 35 | -27.4698 | 153.0251 | 2021-01-20 05:21:54 | Queensland, Australia | ||
317926 | 317926 | 2021-01-19 | Australia | South Australia | 594 | 4 | 584 | 6 | -34.9285 | 138.6007 | 2021-01-20 05:21:54 | South Australia, Australia | ||
317927 | 317927 | 2021-01-19 | Australia | Tasmania | 234 | 13 | 221 | 0 | -42.8821 | 147.3272 | 2021-01-20 05:21:54 | Tasmania, Australia | ||
317928 | 317928 | 2021-01-19 | Australia | Victoria | 20433 | 820 | 19579 | 34 | -37.8136 | 144.9631 | 2021-01-20 05:21:54 | Victoria, Australia | ||
317929 | 317929 | 2021-01-19 | Australia | Western Australia | 888 | 9 | 865 | 14 | -31.9505 | 115.8605 | 2021-01-20 05:21:54 | Western Australia, Australia | ||
569908 | 569908 | 2021-01-18 | Australia | Australian Capital Territory | 118 | 3 | 115 | 0 | -35.4735 | 149.0124 | 2021-01-19 05:22:15 | Australian Capital Territory, Australia | ||
569909 | 569909 | 2021-01-18 | Australia | New South Wales | 5076 | 54 | 3233 | 1789 | -33.8688 | 151.2093 | 2021-01-19 05:22:15 | New South Wales, Australia | ||
569910 | 569910 | 2021-01-18 | Australia | Northern Territory | 93 | 0 | 86 | 7 | -12.4634 | 130.8456 | 2021-01-19 05:22:15 | Northern Territory, Australia | ||
569911 | 569911 | 2021-01-18 | Australia | Queensland | 1297 | 6 | 1255 | 36 | -27.4698 | 153.0251 | 2021-01-19 05:22:15 | Queensland, Australia | ||
569912 | 569912 | 2021-01-18 | Australia | South Australia | 593 | 4 | 578 | 11 | -34.9285 | 138.6007 | 2021-01-19 05:22:15 | South Australia, Australia | ||
569913 | 569913 | 2021-01-18 | Australia | Tasmania | 234 | 13 | 221 | 0 | -42.8821 | 147.3272 | 2021-01-19 05:22:15 | Tasmania, Australia | ||
569914 | 569914 | 2021-01-18 | Australia | Victoria | 20432 | 820 | 19578 | 34 | -37.8136 | 144.9631 | 2021-01-19 05:22:15 | Victoria, Australia | ||
569915 | 569915 | 2021-01-18 | Australia | Western Australia | 888 | 9 | 865 | 14 | -31.9505 | 115.8605 | 2021-01-19 05:22:15 | Western Australia, Australia | ||
534471 | 534471 | 2021-01-17 | Australia | Australian Capital Territory | 118 | 3 | 115 | 0 | -35.4735 | 149.0124 | 2021-01-18 05:22:34 | Australian Capital Territory, Australia | ||
534472 | 534472 | 2021-01-17 | Australia | New South Wales | 5074 | 54 | 3229 | 1791 | -33.8688 | 151.2093 | 2021-01-18 05:22:34 | New South Wales, Australia | ||
534473 | 534473 | 2021-01-17 | Australia | Northern Territory | 93 | 0 | 84 | 9 | -12.4634 | 130.8456 | 2021-01-18 05:22:34 | Northern Territory, Australia | ||
534474 | 534474 | 2021-01-17 | Australia | Queensland | 1294 | 6 | 1254 | 34 | -27.4698 | 153.0251 | 2021-01-18 05:22:34 | Queensland, Australia | ||
534475 | 534475 | 2021-01-17 | Australia | South Australia | 593 | 4 | 578 | 11 | -34.9285 | 138.6007 | 2021-01-18 05:22:34 | South Australia, Australia | ||
534476 | 534476 | 2021-01-17 | Australia | Tasmania | 234 | 13 | 221 | 0 | -42.8821 | 147.3272 | 2021-01-18 05:22:34 | Tasmania, Australia | ||
534477 | 534477 | 2021-01-17 | Australia | Victoria | 20428 | 820 | 19575 | 33 | -37.8136 | 144.9631 | 2021-01-18 05:22:34 | Victoria, Australia | ||
534478 | 534478 | 2021-01-17 | Australia | Western Australia | 887 | 9 | 865 | 13 | -31.9505 | 115.8605 | 2021-01-18 05:22:34 | Western Australia, Australia | ||
615259 | 615259 | 2021-01-16 | Australia | Australian Capital Territory | 118 | 3 | 115 | 0 | -35.4735 | 149.0124 | 2021-01-17 05:22:17 | Australian Capital Territory, Australia | ||
615260 | 615260 | 2021-01-16 | Australia | New South Wales | 5066 | 54 | 3229 | 1783 | -33.8688 | 151.2093 | 2021-01-17 05:22:17 | New South Wales, Australia | ||
615261 | 615261 | 2021-01-16 | Australia | Northern Territory | 93 | 0 | 79 | 14 | -12.4634 | 130.8456 | 2021-01-17 05:22:17 | Northern Territory, Australia | ||
615262 | 615262 | 2021-01-16 | Australia | Queensland | 1293 | 6 | 1253 | 34 | -27.4698 | 153.0251 | 2021-01-17 05:22:17 | Queensland, Australia | ||
615263 | 615263 | 2021-01-16 | Australia | South Australia | 593 | 4 | 578 | 11 | -34.9285 | 138.6007 | 2021-01-17 05:22:17 | South Australia, Australia | ||
615264 | 615264 | 2021-01-16 | Australia | Tasmania | 234 | 13 | 221 | 0 | -42.8821 | 147.3272 | 2021-01-17 05:22:17 | Tasmania, Australia | ||
615265 | 615265 | 2021-01-16 | Australia | Victoria | 20424 | 820 | 19574 | 30 | -37.8136 | 144.9631 | 2021-01-17 05:22:17 | Victoria, Australia | ||
615266 | 615266 | 2021-01-16 | Australia | Western Australia | 887 | 9 | 864 | 14 | -31.9505 | 115.8605 | 2021-01-17 05:22:17 | Western Australia, Australia | ||
180400 | 180400 | 2021-01-15 | Australia | Australian Capital Territory | 118 | 3 | 115 | 0 | -35.4735 | 149.0124 | 2021-01-16 05:22:40 | Australian Capital Territory, Australia | ||
180401 | 180401 | 2021-01-15 | Australia | New South Wales | 5057 | 54 | 3229 | 1774 | -33.8688 | 151.2093 | 2021-01-16 05:22:40 | New South Wales, Australia | ||
180402 | 180402 | 2021-01-15 | Australia | Northern Territory | 93 | 0 | 74 | 19 | -12.4634 | 130.8456 | 2021-01-16 05:22:40 | Northern Territory, Australia | ||
180403 | 180403 | 2021-01-15 | Australia | Queensland | 1291 | 6 | 1248 | 37 | -27.4698 | 153.0251 | 2021-01-16 05:22:40 | Queensland, Australia | ||
180404 | 180404 | 2021-01-15 | Australia | South Australia | 593 | 4 | 577 | 12 | -34.9285 | 138.6007 | 2021-01-16 05:22:40 | South Australia, Australia | ||
180405 | 180405 | 2021-01-15 | Australia | Tasmania | 234 | 13 | 221 | 0 | -42.8821 | 147.3272 | 2021-01-16 05:22:40 | Tasmania, Australia | ||
180406 | 180406 | 2021-01-15 | Australia | Victoria | 20417 | 820 | 19571 | 26 | -37.8136 | 144.9631 | 2021-01-16 05:22:40 | Victoria, Australia | ||
180407 | 180407 | 2021-01-15 | Australia | Western Australia | 886 | 9 | 862 | 15 | -31.9505 | 115.8605 | 2021-01-16 05:22:40 | Western Australia, Australia | ||
593092 | 593092 | 2021-01-14 | Australia | Australian Capital Territory | 118 | 3 | 115 | 0 | -35.4735 | 149.0124 | 2021-01-15 05:22:24 | Australian Capital Territory, Australia | ||
593093 | 593093 | 2021-01-14 | Australia | New South Wales | 5045 | 54 | 3227 | 1764 | -33.8688 | 151.2093 | 2021-01-15 05:22:24 | New South Wales, Australia | ||
593094 | 593094 | 2021-01-14 | Australia | Northern Territory | 93 | 0 | 74 | 19 | -12.4634 | 130.8456 | 2021-01-15 05:22:24 | Northern Territory, Australia | ||
593095 | 593095 | 2021-01-14 | Australia | Queensland | 1290 | 6 | 1247 | 37 | -27.4698 | 153.0251 | 2021-01-15 05:22:24 | Queensland, Australia | ||
593096 | 593096 | 2021-01-14 | Australia | South Australia | 591 | 4 | 577 | 10 | -34.9285 | 138.6007 | 2021-01-15 05:22:24 | South Australia, Australia | ||
593097 | 593097 | 2021-01-14 | Australia | Tasmania | 234 | 13 | 221 | 0 | -42.8821 | 147.3272 | 2021-01-15 05:22:24 | Tasmania, Australia | ||
593098 | 593098 | 2021-01-14 | Australia | Victoria | 20414 | 820 | 19566 | 28 | -37.8136 | 144.9631 | 2021-01-15 05:22:24 | Victoria, Australia | ||
593099 | 593099 | 2021-01-14 | Australia | Western Australia | 884 | 9 | 857 | 18 | -31.9505 | 115.8605 | 2021-01-15 05:22:24 | Western Australia, Australia | ||
724463 | 724463 | 2021-01-13 | Australia | Australian Capital Territory | 118 | 3 | 115 | 0 | -35.4735 | 149.0124 | 2021-01-14 05:22:32 | Australian Capital Territory, Australia | ||
724464 | 724464 | 2021-01-13 | Australia | New South Wales | 5043 | 54 | 3225 | 1764 | -33.8688 | 151.2093 | 2021-01-14 05:22:32 | New South Wales, Australia | ||
724465 | 724465 | 2021-01-13 | Australia | Northern Territory | 93 | 0 | 74 | 19 | -12.4634 | 130.8456 | 2021-01-14 05:22:32 | Northern Territory, Australia | ||
724466 | 724466 | 2021-01-13 | Australia | Queensland | 1287 | 6 | 1245 | 36 | -27.4698 | 153.0251 | 2021-01-14 05:22:32 | Queensland, Australia | ||
724467 | 724467 | 2021-01-13 | Australia | South Australia | 590 | 4 | 575 | 11 | -34.9285 | 138.6007 | 2021-01-14 05:22:32 | South Australia, Australia | ||
724468 | 724468 | 2021-01-13 | Australia | Tasmania | 234 | 13 | 221 | 0 | -42.8821 | 147.3272 | 2021-01-14 05:22:32 | Tasmania, Australia | ||
724469 | 724469 | 2021-01-13 | Australia | Victoria | 20414 | 820 | 19565 | 29 | -37.8136 | 144.9631 | 2021-01-14 05:22:32 | Victoria, Australia | ||
724470 | 724470 | 2021-01-13 | Australia | Western Australia | 881 | 9 | 855 | 17 | -31.9505 | 115.8605 | 2021-01-14 05:22:32 | Western Australia, Australia | ||
56798 | 56798 | 2021-01-12 | Australia | Australian Capital Territory | 118 | 3 | 115 | 0 | -35.4735 | 149.0124 | 2021-01-13 05:22:15 | Australian Capital Territory, Australia | ||
56799 | 56799 | 2021-01-12 | Australia | New South Wales | 5041 | 54 | 3222 | 1765 | -33.8688 | 151.2093 | 2021-01-13 05:22:15 | New South Wales, Australia | ||
56800 | 56800 | 2021-01-12 | Australia | Northern Territory | 91 | 0 | 74 | 17 | -12.4634 | 130.8456 | 2021-01-13 05:22:15 | Northern Territory, Australia | ||
56801 | 56801 | 2021-01-12 | Australia | Queensland | 1283 | 6 | 1245 | 32 | -27.4698 | 153.0251 | 2021-01-13 05:22:15 | Queensland, Australia | ||
56802 | 56802 | 2021-01-12 | Australia | South Australia | 590 | 4 | 574 | 12 | -34.9285 | 138.6007 | 2021-01-13 05:22:15 | South Australia, Australia | ||
56803 | 56803 | 2021-01-12 | Australia | Tasmania | 234 | 13 | 221 | 0 | -42.8821 | 147.3272 | 2021-01-13 05:22:15 | Tasmania, Australia | ||
56804 | 56804 | 2021-01-12 | Australia | Victoria | 20414 | 820 | 19559 | 35 | -37.8136 | 144.9631 | 2021-01-13 05:22:15 | Victoria, Australia | ||
56805 | 56805 | 2021-01-12 | Australia | Western Australia | 879 | 9 | 855 | 15 | -31.9505 | 115.8605 | 2021-01-13 05:22:15 | Western Australia, Australia | ||
264999 | 264999 | 2021-01-11 | Australia | Australian Capital Territory | 118 | 3 | 115 | 0 | -35.4735 | 149.0124 | 2021-01-12 05:22:15 | Australian Capital Territory, Australia | ||
265000 | 265000 | 2021-01-11 | Australia | New South Wales | 5034 | 54 | 3216 | 1764 | -33.8688 | 151.2093 | 2021-01-12 05:22:15 | New South Wales, Australia | ||
265001 | 265001 | 2021-01-11 | Australia | Northern Territory | 90 | 0 | 71 | 19 | -12.4634 | 130.8456 | 2021-01-12 05:22:15 | Northern Territory, Australia | ||
265002 | 265002 | 2021-01-11 | Australia | Queensland | 1281 | 6 | 1243 | 32 | -27.4698 | 153.0251 | 2021-01-12 05:22:15 | Queensland, Australia | ||
265003 | 265003 | 2021-01-11 | Australia | South Australia | 588 | 4 | 569 | 15 | -34.9285 | 138.6007 | 2021-01-12 05:22:15 | South Australia, Australia | ||
265004 | 265004 | 2021-01-11 | Australia | Tasmania | 234 | 13 | 221 | 0 | -42.8821 | 147.3272 | 2021-01-12 05:22:15 | Tasmania, Australia | ||
265005 | 265005 | 2021-01-11 | Australia | Victoria | 20411 | 820 | 19553 | 38 | -37.8136 | 144.9631 | 2021-01-12 05:22:15 | Victoria, Australia | ||
265006 | 265006 | 2021-01-11 | Australia | Western Australia | 878 | 9 | 855 | 14 | -31.9505 | 115.8605 | 2021-01-12 05:22:15 | Western Australia, Australia | ||
780970 | 780970 | 2021-01-10 | Australia | Australian Capital Territory | 118 | 3 | 115 | 0 | -35.4735 | 149.0124 | 2021-01-11 05:21:50 | Australian Capital Territory, Australia | ||
780971 | 780971 | 2021-01-10 | Australia | New South Wales | 5018 | 54 | 3216 | 1748 | -33.8688 | 151.2093 | 2021-01-11 05:21:50 | New South Wales, Australia | ||
780972 | 780972 | 2021-01-10 | Australia | Northern Territory | 90 | 0 | 71 | 19 | -12.4634 | 130.8456 | 2021-01-11 05:21:50 | Northern Territory, Australia | ||
780973 | 780973 | 2021-01-10 | Australia | Queensland | 1278 | 6 | 1243 | 29 | -27.4698 | 153.0251 | 2021-01-11 05:21:50 | Queensland, Australia | ||
780974 | 780974 | 2021-01-10 | Australia | South Australia | 588 | 4 | 569 | 15 | -34.9285 | 138.6007 | 2021-01-11 05:21:50 | South Australia, Australia | ||
780975 | 780975 | 2021-01-10 | Australia | Tasmania | 234 | 13 | 221 | 0 | -42.8821 | 147.3272 | 2021-01-11 05:21:50 | Tasmania, Australia | ||
780976 | 780976 | 2021-01-10 | Australia | Victoria | 20411 | 820 | 19551 | 40 | -37.8136 | 144.9631 | 2021-01-11 05:21:50 | Victoria, Australia | ||
780977 | 780977 | 2021-01-10 | Australia | Western Australia | 877 | 9 | 851 | 17 | -31.9505 | 115.8605 | 2021-01-11 05:21:50 | Western Australia, Australia | ||
134414 | 134414 | 2021-01-09 | Australia | Australian Capital Territory | 118 | 3 | 115 | 0 | -35.4735 | 149.0124 | 2021-01-10 05:22:12 | Australian Capital Territory, Australia | ||
134415 | 134415 | 2021-01-09 | Australia | New South Wales | 5007 | 54 | 3215 | 1738 | -33.8688 | 151.2093 | 2021-01-10 05:22:12 | New South Wales, Australia | ||
134416 | 134416 | 2021-01-09 | Australia | Northern Territory | 90 | 0 | 71 | 19 | -12.4634 | 130.8456 | 2021-01-10 05:22:12 | Northern Territory, Australia | ||
134417 | 134417 | 2021-01-09 | Australia | Queensland | 1274 | 6 | 1241 | 27 | -27.4698 | 153.0251 | 2021-01-10 05:22:12 | 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] INTEGER, [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]);