johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
55 rows where active = 13 and country_or_region = "Australia" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: latitude, last_update (date)
province_or_state 7
country_or_region 1
- Australia · 55 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3659296 | 3659296 | 2021-07-11 | Australia | Western Australia | 1036 | 9 | 1014 | 13 | -31.9505 | 115.8605 | 2021-07-12 04:21:34 | Western Australia, Australia | ||
399963 | 399963 | 2021-06-29 | Australia | South Australia | 801 | 4 | 784 | 13 | -34.9285 | 138.6007 | 2021-06-30 04:21:41 | South Australia, Australia | ||
1412758 | 1412758 | 2021-05-24 | Australia | Victoria | 20553 | 820 | 19720 | 13 | -37.8136 | 144.9631 | 2021-05-25 04:21:08 | Victoria, Australia | ||
2004363 | 2004363 | 2021-05-12 | Australia | Western Australia | 1015 | 9 | 993 | 13 | -31.9505 | 115.8605 | 2021-05-13 04:20:51 | Western Australia, Australia | ||
3954194 | 3954194 | 2021-05-11 | Australia | Western Australia | 1015 | 9 | 993 | 13 | -31.9505 | 115.8605 | 2021-05-12 04:21:29 | Western Australia, Australia | ||
2501726 | 2501726 | 2021-05-07 | Australia | Northern Territory | 167 | 0 | 154 | 13 | -12.4634 | 130.8456 | 2021-05-08 04:21:04 | Northern Territory, Australia | ||
3129220 | 3129220 | 2021-04-18 | Australia | South Australia | 682 | 4 | 665 | 13 | -34.9285 | 138.6007 | 2021-04-19 04:20:57 | South Australia, Australia | ||
982648 | 982648 | 2021-04-17 | Australia | South Australia | 682 | 4 | 665 | 13 | -34.9285 | 138.6007 | 2021-04-18 04:20:41 | South Australia, Australia | ||
169743 | 169743 | 2021-04-16 | Australia | South Australia | 682 | 4 | 665 | 13 | -34.9285 | 138.6007 | 2021-04-17 04:20:40 | South Australia, Australia | ||
387922 | 387922 | 2021-04-04 | Australia | South Australia | 661 | 4 | 644 | 13 | -34.9285 | 138.6007 | 2021-04-05 04:20:35 | South Australia, Australia | ||
3709838 | 3709838 | 2021-04-03 | Australia | South Australia | 659 | 4 | 642 | 13 | -34.9285 | 138.6007 | 2021-04-04 04:20:49 | South Australia, Australia | ||
240954 | 240954 | 2021-04-02 | Australia | South Australia | 658 | 4 | 641 | 13 | -34.9285 | 138.6007 | 2021-04-03 04:20:44 | South Australia, Australia | ||
1301751 | 1301751 | 2021-04-01 | Australia | South Australia | 658 | 4 | 641 | 13 | -34.9285 | 138.6007 | 2021-04-02 04:20:36 | South Australia, Australia | ||
1744241 | 1744241 | 2021-03-20 | Australia | Western Australia | 930 | 9 | 908 | 13 | -31.9505 | 115.8605 | 2021-03-21 05:25:44 | Western Australia, Australia | ||
3420621 | 3420621 | 2021-03-19 | Australia | Western Australia | 930 | 9 | 908 | 13 | -31.9505 | 115.8605 | 2021-03-20 05:25:46 | Western Australia, Australia | ||
2183281 | 2183281 | 2021-02-26 | Australia | Queensland | 1329 | 6 | 1310 | 13 | -27.4698 | 153.0251 | 2021-02-27 05:22:28 | Queensland, Australia | ||
2677525 | 2677525 | 2021-02-13 | Australia | Queensland | 1320 | 6 | 1301 | 13 | -27.4698 | 153.0251 | 2021-02-14 05:23:43 | Queensland, Australia | ||
2637421 | 2637421 | 2021-02-11 | Australia | Queensland | 1318 | 6 | 1299 | 13 | -27.4698 | 153.0251 | 2021-02-12 05:23:29 | Queensland, Australia | ||
1676174 | 1676174 | 2021-02-01 | Australia | Western Australia | 903 | 9 | 881 | 13 | -31.9505 | 115.8605 | 2021-02-02 05:22:49 | Western Australia, Australia | ||
1459462 | 1459462 | 2021-01-31 | Australia | Western Australia | 903 | 9 | 881 | 13 | -31.9505 | 115.8605 | 2021-02-01 05:22:53 | Western Australia, Australia | ||
2567367 | 2567367 | 2021-01-25 | Australia | Western Australia | 895 | 9 | 873 | 13 | -31.9505 | 115.8605 | 2021-01-26 05:22:02 | Western Australia, Australia | ||
1093791 | 1093791 | 2021-01-20 | Australia | Western Australia | 888 | 9 | 866 | 13 | -31.9505 | 115.8605 | 2021-01-21 05:22:01 | Western Australia, Australia | ||
3503061 | 3503061 | 2021-01-17 | Australia | Western Australia | 887 | 9 | 865 | 13 | -31.9505 | 115.8605 | 2021-01-18 05:22:34 | Western Australia, Australia | ||
3230151 | 3230151 | 2021-01-03 | Australia | South Australia | 583 | 4 | 566 | 13 | -34.9285 | 138.6007 | 2021-01-04 05:22:02 | South Australia, Australia | ||
201960 | 201960 | 2020-12-25 | Australia | Western Australia | 854 | 9 | 832 | 13 | -31.9505 | 115.8605 | 2020-12-26 05:22:28 | Western Australia, Australia | ||
2119417 | 2119417 | 2020-12-20 | Australia | Victoria | 20357 | 820 | 19524 | 13 | -37.8136 | 144.9631 | 2020-12-21 05:27:58 | Victoria, Australia | ||
3149297 | 3149297 | 2020-12-16 | Australia | Western Australia | 843 | 9 | 821 | 13 | -31.9505 | 115.8605 | 2020-12-17 05:28:12 | Western Australia, Australia | ||
1818492 | 1818492 | 2020-12-08 | Australia | Western Australia | 832 | 9 | 810 | 13 | -31.9505 | 115.8605 | 2020-12-09 05:28:01 | Western Australia, Australia | ||
1005993 | 1005993 | 2020-12-06 | Australia | Northern Territory | 59 | 0 | 46 | 13 | -12.4634 | 130.8456 | 2020-12-07 05:26:14 | Northern Territory, Australia | ||
1005998 | 1005998 | 2020-12-06 | Australia | Western Australia | 830 | 9 | 808 | 13 | -31.9505 | 115.8605 | 2020-12-07 05:26:14 | Western Australia, Australia | ||
1632002 | 1632002 | 2020-12-05 | Australia | Northern Territory | 59 | 0 | 46 | 13 | -12.4634 | 130.8456 | 2020-12-06 05:26:18 | Northern Territory, Australia | ||
1632007 | 1632007 | 2020-12-05 | Australia | Western Australia | 830 | 9 | 808 | 13 | -31.9505 | 115.8605 | 2020-12-06 05:26:18 | Western Australia, Australia | ||
3859530 | 3859530 | 2020-12-04 | Australia | Northern Territory | 59 | 0 | 46 | 13 | -12.4634 | 130.8456 | 2020-12-05 05:27:36 | Northern Territory, Australia | ||
3859531 | 3859531 | 2020-12-04 | Australia | Queensland | 1210 | 6 | 1191 | 13 | -27.4698 | 153.0251 | 2020-12-05 05:27:36 | Queensland, Australia | ||
74788 | 74788 | 2020-12-03 | Australia | Northern Territory | 59 | 0 | 46 | 13 | -12.4634 | 130.8456 | 2020-12-04 05:27:27 | Northern Territory, Australia | ||
738000 | 738000 | 2020-12-02 | Australia | Northern Territory | 59 | 0 | 46 | 13 | -12.4634 | 130.8456 | 2020-12-03 05:28:22 | Northern Territory, Australia | ||
738001 | 738001 | 2020-12-02 | Australia | Queensland | 1206 | 6 | 1187 | 13 | -27.4698 | 153.0251 | 2020-12-03 05:28:22 | Queensland, Australia | ||
2537095 | 2537095 | 2020-12-01 | Australia | Queensland | 1205 | 6 | 1186 | 13 | -27.4698 | 153.0251 | 2020-12-02 05:27:41 | Queensland, Australia | ||
391935 | 391935 | 2020-11-27 | Australia | Queensland | 1199 | 6 | 1180 | 13 | -27.4698 | 153.0251 | 2020-11-28 05:25:50 | Queensland, Australia | ||
821271 | 821271 | 2020-11-19 | Australia | Queensland | 1190 | 6 | 1171 | 13 | -27.4698 | 153.0251 | 2020-11-20 05:26:28 | Queensland, Australia | ||
122405 | 122405 | 2020-11-18 | Australia | Queensland | 1190 | 6 | 1171 | 13 | -27.4698 | 153.0251 | 2020-11-19 05:25:23 | Queensland, Australia | ||
3440527 | 3440527 | 2020-11-11 | Australia | Queensland | 1182 | 6 | 1163 | 13 | -27.4698 | 153.0251 | 2020-11-12 05:25:55 | Queensland, Australia | ||
2497732 | 2497732 | 2020-11-03 | Australia | South Australia | 504 | 4 | 487 | 13 | -34.9285 | 138.6007 | 2020-11-04 05:25:09 | South Australia, Australia | ||
3303907 | 3303907 | 2020-11-02 | Australia | South Australia | 503 | 4 | 486 | 13 | -34.9285 | 138.6007 | 2020-11-03 06:00:16 | South Australia, 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 | ||
3793205 | 3793205 | 2020-08-05 | Australia | Queensland | 1088 | 6 | 1069 | 13 | -27.4698 | 153.0251 | 2020-08-06 04:35:02 | Queensland, Australia | ||
98441 | 98441 | 2020-08-04 | Australia | Queensland | 1088 | 6 | 1069 | 13 | -27.4698 | 153.0251 | 2020-08-05 04:34:43 | Queensland, Australia | ||
753644 | 753644 | 2020-08-01 | Australia | Queensland | 1085 | 6 | 1066 | 13 | -27.4698 | 153.0251 | 2020-08-02 04:34:47 | Queensland, Australia | ||
2222977 | 2222977 | 2020-07-08 | Australia | Western Australia | 624 | 9 | 602 | 13 | -31.9505 | 115.8605 | 2020-07-09 04:34:23 | Western Australia, Australia | ||
887586 | 887586 | 2020-07-07 | Australia | Western Australia | 624 | 9 | 602 | 13 | -31.9505 | 115.8605 | 2020-07-08 05:33:48 | Western Australia, Australia | ||
1105013 | 1105013 | 2020-05-25 | Australia | Tasmania | 228 | 13 | 202 | 13 | -42.8821 | 147.3272 | 2020-05-26 02:32:35 | Tasmania, Australia | ||
1864869 | 1864869 | 2020-05-22 | Australia | Queensland | 1060 | 6 | 1041 | 13 | -27.4698 | 153.0251 | 2020-05-23 02:32:42 | Queensland, Australia | ||
3416332 | 3416332 | 2020-05-17 | Australia | Queensland | 1057 | 6 | 1038 | 13 | -27.4698 | 153.0251 | 2020-05-18 02:32:21 | Queensland, Australia | ||
3276282 | 3276282 | 2020-05-15 | Australia | Queensland | 1055 | 6 | 1036 | 13 | -27.4698 | 153.0251 | 2020-05-16 02:32:19 | Queensland, Australia | ||
2524991 | 2524991 | 2020-04-23 | Australia | Australian Capital Territory | 104 | 3 | 88 | 13 | -35.4735 | 149.0124 | 2020-04-24 03:31:35 | Australian Capital Territory, 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]);