daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
31 rows where country_or_region = "Australia" and deaths = 18 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: recovered, latitude, longitude, combined_key, day (date), last_update (date)
province_or_state 4
country_or_region 1
- Australia · 31 ✖
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-02-01 | Australia | Tasmania | 31311 | 18 | 0 | -42.8821 | 147.3272 | 2022-02-02 04:21:09 | Tasmania, Australia | |||
2022-01-31 | Australia | Tasmania | 30645 | 18 | 0 | -42.8821 | 147.3272 | 2022-02-01 04:21:11 | Tasmania, Australia | |||
2022-01-30 | Australia | Tasmania | 29946 | 18 | 0 | -42.8821 | 147.3272 | 2022-01-31 04:21:09 | Tasmania, Australia | |||
2022-01-29 | Australia | Tasmania | 29319 | 18 | 0 | -42.8821 | 147.3272 | 2022-01-30 04:21:26 | Tasmania, Australia | |||
2022-01-15 | Australia | Australian Capital Territory | 22396 | 18 | 0 | -35.4735 | 149.0124 | 2022-01-16 04:21:12 | Australian Capital Territory, Australia | |||
2020-05-22 | Australia | Victoria | 1593 | 18 | 1479 | 96 | -37.8136 | 144.9631 | 2020-05-23 02:32:42 | Victoria, Australia | ||
2020-05-21 | Australia | Victoria | 1593 | 18 | 1479 | 96 | -37.8136 | 144.9631 | 2020-05-22 02:36:51 | Victoria, Australia | ||
2020-05-20 | Australia | Victoria | 1581 | 18 | 1473 | 90 | -37.8136 | 144.9631 | 2020-05-21 02:32:48 | Victoria, Australia | ||
2020-05-19 | Australia | Victoria | 1573 | 18 | 1454 | 101 | -37.8136 | 144.9631 | 2020-05-20 02:32:19 | Victoria, Australia | ||
2020-05-18 | Australia | Victoria | 1573 | 18 | 1454 | 101 | -37.8136 | 144.9631 | 2020-05-19 02:32:18 | Victoria, Australia | ||
2020-05-17 | Australia | Victoria | 1564 | 18 | 1439 | 107 | -37.8136 | 144.9631 | 2020-05-18 02:32:21 | Victoria, Australia | ||
2020-05-16 | Australia | Victoria | 1558 | 18 | 1417 | 123 | -37.8136 | 144.9631 | 2020-05-17 02:32:32 | Victoria, Australia | ||
2020-05-15 | Australia | Victoria | 1551 | 18 | 1417 | 116 | -37.8136 | 144.9631 | 2020-05-16 02:32:19 | Victoria, Australia | ||
2020-05-14 | Australia | Victoria | 1540 | 18 | 1407 | 115 | -37.8136 | 144.9631 | 2020-05-15 02:33:02 | Victoria, Australia | ||
2020-05-13 | Australia | Victoria | 1521 | 18 | 1385 | 118 | -37.8136 | 144.9631 | 2020-05-14 03:32:28 | Victoria, Australia | ||
2020-05-12 | Australia | Victoria | 1514 | 18 | 1385 | 111 | -37.8136 | 144.9631 | 2020-05-13 03:32:26 | Victoria, Australia | ||
2020-05-11 | Australia | Victoria | 1511 | 18 | 1360 | 133 | -37.8136 | 144.9631 | 2020-05-12 03:32:27 | Victoria, Australia | ||
2020-05-10 | Australia | Victoria | 1496 | 18 | 1346 | 132 | -37.8136 | 144.9631 | 2020-05-11 02:32:30 | Victoria, Australia | ||
2020-05-09 | Australia | Victoria | 1487 | 18 | 1336 | 133 | -37.8136 | 144.9631 | 2020-05-10 02:32:30 | Victoria, Australia | ||
2020-05-08 | Australia | Victoria | 1468 | 18 | 1327 | 123 | -37.8136 | 144.9631 | 2020-05-09 02:32:35 | Victoria, Australia | ||
2020-05-07 | Australia | Victoria | 1467 | 18 | 1327 | 122 | -37.8136 | 144.9631 | 2020-05-08 02:32:32 | Victoria, Australia | ||
2020-05-06 | Australia | Victoria | 1454 | 18 | 1322 | 114 | -37.8136 | 144.9631 | 2020-05-07 02:32:28 | Victoria, Australia | ||
2020-05-05 | Australia | Victoria | 1440 | 18 | 1321 | 101 | -37.8136 | 144.9631 | 2020-05-06 02:32:31 | Victoria, Australia | ||
2020-05-04 | Australia | Victoria | 1423 | 18 | 1311 | 94 | -37.8136 | 144.9631 | 2020-05-05 02:32:34 | Victoria, Australia | ||
2020-05-03 | Australia | Victoria | 1406 | 18 | 1300 | 88 | -37.8136 | 144.9631 | 2020-05-04 02:32:28 | Victoria, Australia | ||
2020-05-02 | Australia | Victoria | 1384 | 18 | 1300 | 66 | -37.8136 | 144.9631 | 2020-05-03 02:32:28 | Victoria, Australia | ||
2020-05-01 | Australia | Victoria | 1371 | 18 | 1300 | 53 | -37.8136 | 144.9631 | 2020-05-02 02:32:27 | Victoria, Australia | ||
2020-04-30 | Australia | Victoria | 1364 | 18 | 1293 | 53 | -37.8136 | 144.9631 | 2020-05-01 02:32:28 | Victoria, Australia | ||
2020-04-29 | Australia | Victoria | 1361 | 18 | 1291 | 52 | -37.8136 | 144.9631 | 2020-04-30 02:32:27 | Victoria, Australia | ||
2020-04-28 | Australia | Victoria | 1354 | 18 | 1287 | 49 | -37.8136 | 144.9631 | 2020-04-29 02:32:29 | Victoria, Australia | ||
2020-04-06 | Australia | New South Wales | 2637 | 18 | 4 | 2615 | -33.8688 | 151.2093 | 4/6/20 23:28 | New South Wales, Australia |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;