daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
657 rows where country_or_region = "Australia" and deaths = 9 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: latitude, combined_key, day (date), last_update (date)
province_or_state 4
country_or_region 1
- Australia · 657 ✖
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-02-10 | Australia | Western Australia | 2043 | 9 | 0 | -31.9505 | 115.8605 | 2022-02-11 04:21:09 | Western Australia, Australia | |||
2022-02-09 | Australia | Western Australia | 1905 | 9 | 0 | -31.9505 | 115.8605 | 2022-02-10 04:21:14 | Western Australia, Australia | |||
2022-02-08 | Australia | Western Australia | 1813 | 9 | 0 | -31.9505 | 115.8605 | 2022-02-09 04:21:04 | Western Australia, Australia | |||
2022-02-07 | Australia | Western Australia | 1748 | 9 | 0 | -31.9505 | 115.8605 | 2022-02-08 04:21:15 | Western Australia, Australia | |||
2022-02-06 | Australia | Western Australia | 1712 | 9 | 0 | -31.9505 | 115.8605 | 2022-02-07 04:21:05 | Western Australia, Australia | |||
2022-02-05 | Australia | Western Australia | 1666 | 9 | 0 | -31.9505 | 115.8605 | 2022-02-06 04:21:00 | Western Australia, Australia | |||
2022-02-04 | Australia | Western Australia | 1666 | 9 | 0 | -31.9505 | 115.8605 | 2022-02-05 04:21:05 | Western Australia, Australia | |||
2022-02-03 | Australia | Western Australia | 1608 | 9 | 0 | -31.9505 | 115.8605 | 2022-02-04 04:21:10 | Western Australia, Australia | |||
2022-02-02 | Australia | Western Australia | 1609 | 9 | 0 | -31.9505 | 115.8605 | 2022-02-03 04:21:21 | Western Australia, Australia | |||
2022-02-01 | Australia | Western Australia | 1568 | 9 | 0 | -31.9505 | 115.8605 | 2022-02-02 04:21:09 | Western Australia, Australia | |||
2022-01-31 | Australia | Western Australia | 1551 | 9 | 0 | -31.9505 | 115.8605 | 2022-02-01 04:21:11 | Western Australia, Australia | |||
2022-01-30 | Australia | Western Australia | 1504 | 9 | 0 | -31.9505 | 115.8605 | 2022-01-31 04:21:09 | Western Australia, Australia | |||
2022-01-29 | Australia | Western Australia | 1505 | 9 | 0 | -31.9505 | 115.8605 | 2022-01-30 04:21:26 | Western Australia, Australia | |||
2022-01-28 | Australia | Western Australia | 1462 | 9 | 0 | -31.9505 | 115.8605 | 2022-01-29 04:21:10 | Western Australia, Australia | |||
2022-01-27 | Australia | Western Australia | 1454 | 9 | 0 | -31.9505 | 115.8605 | 2022-01-28 04:21:09 | Western Australia, Australia | |||
2022-01-26 | Australia | Western Australia | 1442 | 9 | 0 | -31.9505 | 115.8605 | 2022-01-27 04:21:19 | Western Australia, Australia | |||
2022-01-25 | Australia | Western Australia | 1442 | 9 | 0 | -31.9505 | 115.8605 | 2022-01-26 04:21:07 | Western Australia, Australia | |||
2022-01-24 | Australia | Western Australia | 1415 | 9 | 0 | -31.9505 | 115.8605 | 2022-01-25 04:21:05 | Western Australia, Australia | |||
2022-01-23 | Australia | Western Australia | 1386 | 9 | 0 | -31.9505 | 115.8605 | 2022-01-24 04:21:12 | Western Australia, Australia | |||
2022-01-22 | Australia | Western Australia | 1359 | 9 | 0 | -31.9505 | 115.8605 | 2022-01-23 04:21:13 | Western Australia, Australia | |||
2022-01-21 | Australia | Western Australia | 1348 | 9 | 0 | -31.9505 | 115.8605 | 2022-01-22 04:21:13 | Western Australia, Australia | |||
2022-01-20 | Australia | Western Australia | 1338 | 9 | 0 | -31.9505 | 115.8605 | 2022-01-21 04:21:09 | Western Australia, Australia | |||
2022-01-19 | Australia | Western Australia | 1328 | 9 | 0 | -31.9505 | 115.8605 | 2022-01-20 04:21:07 | Western Australia, Australia | |||
2022-01-18 | Australia | Western Australia | 1323 | 9 | 0 | -31.9505 | 115.8605 | 2022-01-19 04:21:23 | Western Australia, Australia | |||
2022-01-17 | Australia | Western Australia | 1309 | 9 | 0 | -31.9505 | 115.8605 | 2022-01-18 04:21:04 | Western Australia, Australia | |||
2022-01-16 | Australia | Western Australia | 1297 | 9 | 0 | -31.9505 | 115.8605 | 2022-01-17 04:21:08 | Western Australia, Australia | |||
2022-01-15 | Australia | Western Australia | 1294 | 9 | 0 | -31.9505 | 115.8605 | 2022-01-16 04:21:12 | Western Australia, Australia | |||
2022-01-14 | Australia | Western Australia | 1285 | 9 | 0 | -31.9505 | 115.8605 | 2022-01-15 04:21:07 | Western Australia, Australia | |||
2022-01-13 | Australia | Western Australia | 1276 | 9 | 0 | -31.9505 | 115.8605 | 2022-01-14 04:21:54 | Western Australia, Australia | |||
2022-01-12 | Australia | Western Australia | 1276 | 9 | 0 | -31.9505 | 115.8605 | 2022-01-13 08:00:09 | Western Australia, Australia | |||
2022-01-11 | Australia | Western Australia | 1254 | 9 | 0 | -31.9505 | 115.8605 | 2022-01-12 04:21:44 | Western Australia, Australia | |||
2022-01-10 | Australia | Western Australia | 1239 | 9 | 0 | -31.9505 | 115.8605 | 2022-01-11 04:22:01 | Western Australia, Australia | |||
2022-01-09 | Australia | Western Australia | 1231 | 9 | 0 | -31.9505 | 115.8605 | 2022-01-10 04:22:07 | Western Australia, Australia | |||
2022-01-08 | Australia | Western Australia | 1231 | 9 | 0 | -31.9505 | 115.8605 | 2022-01-09 04:21:46 | Western Australia, Australia | |||
2022-01-07 | Australia | Western Australia | 1221 | 9 | 0 | -31.9505 | 115.8605 | 2022-01-08 04:21:53 | Western Australia, Australia | |||
2022-01-06 | Australia | Western Australia | 1215 | 9 | 0 | -31.9505 | 115.8605 | 2022-01-07 04:22:09 | Western Australia, Australia | |||
2022-01-05 | Australia | Western Australia | 1206 | 9 | 0 | -31.9505 | 115.8605 | 2022-01-06 04:22:09 | Western Australia, Australia | |||
2022-01-04 | Australia | Western Australia | 1190 | 9 | 0 | -31.9505 | 115.8605 | 2022-01-05 04:21:59 | Western Australia, Australia | |||
2022-01-03 | Australia | Western Australia | 1176 | 9 | 0 | -31.9505 | 115.8605 | 2022-01-04 04:22:17 | Western Australia, Australia | |||
2022-01-02 | Australia | Western Australia | 1168 | 9 | 0 | -31.9505 | 115.8605 | 2022-01-03 02:22:25 | Western Australia, Australia | |||
2022-01-01 | Australia | Western Australia | 1161 | 9 | 0 | -31.9505 | 115.8605 | 2022-01-02 04:20:52 | Western Australia, Australia | |||
2021-12-31 | Australia | Western Australia | 1161 | 9 | 0 | -31.9505 | 115.8605 | 2022-01-01 04:22:14 | Western Australia, Australia | |||
2021-12-30 | Australia | Western Australia | 1153 | 9 | 0 | -31.9505 | 115.8605 | 2021-12-31 04:21:50 | Western Australia, Australia | |||
2021-12-29 | Australia | Western Australia | 1148 | 9 | 0 | -31.9505 | 115.8605 | 2021-12-30 04:21:25 | Western Australia, Australia | |||
2021-12-28 | Australia | Western Australia | 1148 | 9 | 0 | -31.9505 | 115.8605 | 2021-12-29 03:21:43 | Western Australia, Australia | |||
2021-12-27 | Australia | Western Australia | 1148 | 9 | 0 | -31.9505 | 115.8605 | 2021-12-28 04:21:47 | Western Australia, Australia | |||
2021-12-26 | Australia | Western Australia | 1143 | 9 | 0 | -31.9505 | 115.8605 | 2021-12-27 04:21:58 | Western Australia, Australia | |||
2021-12-25 | Australia | Western Australia | 1142 | 9 | 0 | -31.9505 | 115.8605 | 2021-12-26 04:21:50 | Western Australia, Australia | |||
2021-12-24 | Australia | Western Australia | 1133 | 9 | 0 | -31.9505 | 115.8605 | 2021-12-25 04:21:37 | Western Australia, Australia | |||
2021-12-23 | Australia | Western Australia | 1136 | 9 | 0 | -31.9505 | 115.8605 | 2021-12-24 04:21:34 | Western Australia, Australia | |||
2021-12-22 | Australia | Western Australia | 1130 | 9 | 0 | -31.9505 | 115.8605 | 2021-12-23 04:21:21 | Western Australia, Australia | |||
2021-12-21 | Australia | Western Australia | 1126 | 9 | 0 | -31.9505 | 115.8605 | 2021-12-22 04:21:54 | Western Australia, Australia | |||
2021-12-20 | Australia | Western Australia | 1125 | 9 | 0 | -31.9505 | 115.8605 | 2021-12-21 03:21:27 | Western Australia, Australia | |||
2021-12-19 | Australia | Western Australia | 1125 | 9 | 0 | -31.9505 | 115.8605 | 2021-12-20 04:21:43 | Western Australia, Australia | |||
2021-12-18 | Australia | Western Australia | 1125 | 9 | 0 | -31.9505 | 115.8605 | 2021-12-19 04:21:11 | Western Australia, Australia | |||
2021-12-17 | Australia | Western Australia | 1125 | 9 | 0 | -31.9505 | 115.8605 | 2021-12-18 02:22:20 | Western Australia, Australia | |||
2021-12-16 | Australia | Western Australia | 1125 | 9 | 0 | -31.9505 | 115.8605 | 2021-12-17 04:22:14 | Western Australia, Australia | |||
2021-12-15 | Australia | Western Australia | 1125 | 9 | 0 | -31.9505 | 115.8605 | 2021-12-16 04:22:11 | Western Australia, Australia | |||
2021-12-14 | Australia | Western Australia | 1125 | 9 | 0 | -31.9505 | 115.8605 | 2021-12-15 03:22:16 | Western Australia, Australia | |||
2021-12-13 | Australia | Western Australia | 1124 | 9 | 0 | -31.9505 | 115.8605 | 2021-12-14 04:22:38 | Western Australia, Australia | |||
2021-12-12 | Australia | Western Australia | 1123 | 9 | 0 | -31.9505 | 115.8605 | 2021-12-13 04:22:02 | Western Australia, Australia | |||
2021-12-11 | Australia | Western Australia | 1123 | 9 | 0 | -31.9505 | 115.8605 | 2021-12-12 04:22:12 | Western Australia, Australia | |||
2021-12-10 | Australia | Western Australia | 1123 | 9 | 0 | -31.9505 | 115.8605 | 2021-12-11 04:22:45 | Western Australia, Australia | |||
2021-12-09 | Australia | Western Australia | 1123 | 9 | 0 | -31.9505 | 115.8605 | 2021-12-10 04:22:28 | Western Australia, Australia | |||
2021-12-08 | Australia | Western Australia | 1122 | 9 | 0 | -31.9505 | 115.8605 | 2021-12-09 04:22:49 | Western Australia, Australia | |||
2021-12-07 | Australia | Western Australia | 1122 | 9 | 0 | -31.9505 | 115.8605 | 2021-12-08 04:22:46 | Western Australia, Australia | |||
2021-12-06 | Australia | Western Australia | 1122 | 9 | 0 | -31.9505 | 115.8605 | 2021-12-07 04:22:34 | Western Australia, Australia | |||
2021-12-05 | Australia | Western Australia | 1122 | 9 | 0 | -31.9505 | 115.8605 | 2021-12-06 04:22:34 | Western Australia, Australia | |||
2021-12-04 | Australia | Western Australia | 1122 | 9 | 0 | -31.9505 | 115.8605 | 2021-12-05 04:22:25 | Western Australia, Australia | |||
2021-12-03 | Australia | Western Australia | 1122 | 9 | 0 | -31.9505 | 115.8605 | 2021-12-04 04:22:18 | Western Australia, Australia | |||
2021-12-02 | Australia | Western Australia | 1121 | 9 | 0 | -31.9505 | 115.8605 | 2021-12-03 04:23:05 | Western Australia, Australia | |||
2021-12-01 | Australia | Western Australia | 1121 | 9 | 0 | -31.9505 | 115.8605 | 2021-12-02 04:22:37 | Western Australia, Australia | |||
2021-11-30 | Australia | Western Australia | 1121 | 9 | 0 | -31.9505 | 115.8605 | 2021-12-01 04:22:29 | Western Australia, Australia | |||
2021-11-29 | Australia | Western Australia | 1121 | 9 | 0 | -31.9505 | 115.8605 | 2021-11-30 04:22:53 | Western Australia, Australia | |||
2021-11-28 | Australia | Western Australia | 1121 | 9 | 0 | -31.9505 | 115.8605 | 2021-11-29 04:22:30 | Western Australia, Australia | |||
2021-11-27 | Australia | Western Australia | 1122 | 9 | 0 | -31.9505 | 115.8605 | 2021-11-28 04:22:43 | Western Australia, Australia | |||
2021-11-26 | Australia | Western Australia | 1122 | 9 | 0 | -31.9505 | 115.8605 | 2021-11-27 04:22:45 | Western Australia, Australia | |||
2021-11-25 | Australia | Western Australia | 1122 | 9 | 0 | -31.9505 | 115.8605 | 2021-11-26 04:22:33 | Western Australia, Australia | |||
2021-11-24 | Australia | Western Australia | 1121 | 9 | 0 | -31.9505 | 115.8605 | 2021-11-25 04:22:33 | Western Australia, Australia | |||
2021-11-23 | Australia | Western Australia | 1121 | 9 | 0 | -31.9505 | 115.8605 | 2021-11-24 04:22:14 | Western Australia, Australia | |||
2021-11-22 | Australia | Western Australia | 1121 | 9 | 0 | -31.9505 | 115.8605 | 2021-11-23 04:22:39 | Western Australia, Australia | |||
2021-11-21 | Australia | Western Australia | 1120 | 9 | 0 | -31.9505 | 115.8605 | 2021-11-22 04:22:20 | Western Australia, Australia | |||
2021-11-20 | Australia | Western Australia | 1119 | 9 | 0 | -31.9505 | 115.8605 | 2021-11-21 04:22:13 | Western Australia, Australia | |||
2021-11-19 | Australia | Western Australia | 1118 | 9 | 0 | -31.9505 | 115.8605 | 2021-11-20 04:22:17 | Western Australia, Australia | |||
2021-11-18 | Australia | Western Australia | 1117 | 9 | 0 | -31.9505 | 115.8605 | 2021-11-19 04:21:40 | Western Australia, Australia | |||
2021-11-17 | Australia | Western Australia | 1116 | 9 | 0 | -31.9505 | 115.8605 | 2021-11-18 04:21:33 | Western Australia, Australia | |||
2021-11-16 | Australia | Western Australia | 1116 | 9 | 0 | -31.9505 | 115.8605 | 2021-11-17 04:21:48 | Western Australia, Australia | |||
2021-11-15 | Australia | Western Australia | 1113 | 9 | 0 | -31.9505 | 115.8605 | 2021-11-16 04:21:10 | Western Australia, Australia | |||
2021-11-14 | Australia | Western Australia | 1112 | 9 | 0 | -31.9505 | 115.8605 | 2021-11-15 04:21:36 | Western Australia, Australia | |||
2021-11-13 | Australia | Western Australia | 1112 | 9 | 0 | -31.9505 | 115.8605 | 2021-11-14 04:21:31 | Western Australia, Australia | |||
2021-11-12 | Australia | Western Australia | 1112 | 9 | 0 | -31.9505 | 115.8605 | 2021-11-13 04:21:38 | Western Australia, Australia | |||
2021-11-11 | Australia | Western Australia | 1112 | 9 | 0 | -31.9505 | 115.8605 | 2021-11-12 04:22:01 | Western Australia, Australia | |||
2021-11-10 | Australia | Western Australia | 1112 | 9 | 0 | -31.9505 | 115.8605 | 2021-11-11 04:21:45 | Western Australia, Australia | |||
2021-11-09 | Australia | Western Australia | 1112 | 9 | 0 | -31.9505 | 115.8605 | 2021-11-10 04:21:38 | Western Australia, Australia | |||
2021-11-08 | Australia | Western Australia | 1112 | 9 | 0 | -31.9505 | 115.8605 | 2021-11-09 04:21:36 | Western Australia, Australia | |||
2021-11-07 | Australia | Western Australia | 1112 | 9 | 0 | -31.9505 | 115.8605 | 2021-11-08 04:21:43 | Western Australia, Australia | |||
2021-11-06 | Australia | Western Australia | 1112 | 9 | 0 | -31.9505 | 115.8605 | 2021-11-07 04:21:53 | Western Australia, Australia | |||
2021-11-05 | Australia | Western Australia | 1112 | 9 | 0 | -31.9505 | 115.8605 | 2021-11-06 04:21:51 | Western Australia, Australia | |||
2021-11-04 | Australia | Western Australia | 1112 | 9 | 0 | -31.9505 | 115.8605 | 2021-11-05 04:21:54 | Western Australia, Australia | |||
2021-11-03 | Australia | Western Australia | 1112 | 9 | 0 | -31.9505 | 115.8605 | 2021-11-04 04:22:20 | Western Australia, Australia |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;