johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
35 rows where country_or_region = "Australia" and recovered = 216 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: longitude, combined_key, last_update (date)
province_or_state 2
country_or_region 1
- Australia · 35 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
193782 | 193782 | 2020-08-31 | Australia | Tasmania | 230 | 13 | 216 | 1 | -42.8821 | 147.3272 | 2020-09-01 04:28:31 | Tasmania, Australia | ||
3931741 | 3931741 | 2020-08-30 | Australia | Tasmania | 230 | 13 | 216 | 1 | -42.8821 | 147.3272 | 2020-08-31 04:28:27 | Tasmania, Australia | ||
609403 | 609403 | 2020-08-29 | Australia | Tasmania | 230 | 13 | 216 | 1 | -42.8821 | 147.3272 | 2020-08-30 04:28:22 | Tasmania, Australia | ||
1522898 | 1522898 | 2020-08-28 | Australia | Tasmania | 230 | 13 | 216 | 1 | -42.8821 | 147.3272 | 2020-08-29 04:28:19 | Tasmania, Australia | ||
2509899 | 2509899 | 2020-08-27 | Australia | Tasmania | 230 | 13 | 216 | 1 | -42.8821 | 147.3272 | 2020-08-28 04:28:11 | Tasmania, Australia | ||
1996359 | 1996359 | 2020-08-26 | Australia | Tasmania | 230 | 13 | 216 | 1 | -42.8821 | 147.3272 | 2020-08-27 04:28:15 | Tasmania, Australia | ||
3562283 | 3562283 | 2020-08-25 | Australia | Tasmania | 230 | 13 | 216 | 1 | -42.8821 | 147.3272 | 2020-08-26 04:28:11 | Tasmania, Australia | ||
2990987 | 2990987 | 2020-08-24 | Australia | Tasmania | 230 | 13 | 216 | 1 | -42.8821 | 147.3272 | 2020-08-25 04:28:02 | Tasmania, Australia | ||
2215382 | 2215382 | 2020-08-23 | Australia | Tasmania | 230 | 13 | 216 | 1 | -42.8821 | 147.3272 | 2020-08-24 04:27:56 | Tasmania, Australia | ||
2299164 | 2299164 | 2020-08-22 | Australia | Tasmania | 230 | 13 | 216 | 1 | -42.8821 | 147.3272 | 2020-08-23 04:27:48 | Tasmania, Australia | ||
1479271 | 1479271 | 2020-08-21 | Australia | Tasmania | 230 | 13 | 216 | 1 | -42.8821 | 147.3272 | 2020-08-22 04:27:49 | Tasmania, Australia | ||
3484020 | 3484020 | 2020-08-20 | Australia | Tasmania | 230 | 13 | 216 | 1 | -42.8821 | 147.3272 | 2020-08-21 04:27:41 | Tasmania, Australia | ||
205969 | 205969 | 2020-08-19 | Australia | Tasmania | 230 | 13 | 216 | 1 | -42.8821 | 147.3272 | 2020-08-20 04:27:43 | Tasmania, Australia | ||
3177723 | 3177723 | 2020-08-18 | Australia | Tasmania | 230 | 13 | 216 | 1 | -42.8821 | 147.3272 | 2020-08-19 04:27:00 | Tasmania, Australia | ||
837327 | 837327 | 2020-08-17 | Australia | Tasmania | 230 | 13 | 216 | 1 | -42.8821 | 147.3272 | 2020-08-18 04:27:56 | Tasmania, Australia | ||
1555685 | 1555685 | 2020-08-16 | Australia | Tasmania | 230 | 13 | 216 | 1 | -42.8821 | 147.3272 | 2020-08-17 04:27:20 | Tasmania, Australia | ||
145687 | 145687 | 2020-08-15 | Australia | Tasmania | 230 | 13 | 216 | 1 | -42.8821 | 147.3272 | 2020-08-16 04:27:42 | Tasmania, Australia | ||
1611962 | 1611962 | 2020-08-14 | Australia | Tasmania | 230 | 13 | 216 | 1 | -42.8821 | 147.3272 | 2020-08-15 04:27:31 | Tasmania, Australia | ||
582546 | 582546 | 2020-08-13 | Australia | Tasmania | 230 | 13 | 216 | 1 | -42.8821 | 147.3272 | 2020-08-14 04:51:19 | Tasmania, Australia | ||
3531165 | 3531165 | 2020-08-12 | Australia | Tasmania | 230 | 13 | 216 | 1 | -42.8821 | 147.3272 | 2020-08-13 04:29:15 | Tasmania, Australia | ||
662014 | 662014 | 2020-08-11 | Australia | Tasmania | 230 | 13 | 216 | 1 | -42.8821 | 147.3272 | 2020-08-12 04:27:29 | Tasmania, Australia | ||
1920601 | 1920601 | 2020-08-10 | Australia | Tasmania | 229 | 13 | 216 | 0 | -42.8821 | 147.3272 | 2020-08-11 04:35:08 | Tasmania, Australia | ||
3923410 | 3923410 | 2020-08-09 | Australia | Tasmania | 229 | 13 | 216 | 0 | -42.8821 | 147.3272 | 2020-08-10 04:34:55 | Tasmania, Australia | ||
371578 | 371578 | 2020-08-08 | Australia | Tasmania | 229 | 13 | 216 | 0 | -42.8821 | 147.3272 | 2020-08-09 04:34:54 | Tasmania, Australia | ||
458762 | 458762 | 2020-08-07 | Australia | Tasmania | 229 | 13 | 216 | 0 | -42.8821 | 147.3272 | 2020-08-08 04:34:53 | Tasmania, Australia | ||
3612447 | 3612447 | 2020-08-06 | Australia | Tasmania | 229 | 13 | 216 | 0 | -42.8821 | 147.3272 | 2020-08-07 04:35:11 | Tasmania, Australia | ||
3793277 | 3793277 | 2020-08-05 | Australia | Tasmania | 229 | 13 | 216 | 0 | -42.8821 | 147.3272 | 2020-08-06 04:35:02 | Tasmania, Australia | ||
98513 | 98513 | 2020-08-04 | Australia | Tasmania | 229 | 13 | 216 | 0 | -42.8821 | 147.3272 | 2020-08-05 04:34:43 | Tasmania, Australia | ||
2740396 | 2740396 | 2020-08-03 | Australia | Tasmania | 229 | 13 | 216 | 0 | -42.8821 | 147.3272 | 2020-08-04 04:41:59 | Tasmania, Australia | ||
2808148 | 2808148 | 2020-08-02 | Australia | Tasmania | 229 | 13 | 216 | 0 | -42.8821 | 147.3272 | 2020-08-03 04:34:35 | Tasmania, Australia | ||
753716 | 753716 | 2020-08-01 | Australia | Tasmania | 229 | 13 | 216 | 0 | -42.8821 | 147.3272 | 2020-08-02 04:34:47 | Tasmania, Australia | ||
3264881 | 3264881 | 2020-07-31 | Australia | Tasmania | 229 | 13 | 216 | 0 | -42.8821 | 147.3272 | 2020-08-01 04:36:27 | Tasmania, Australia | ||
43157 | 43157 | 2020-04-13 | Australia | Western Australia | 517 | 6 | 216 | 295 | -31.9505 | 115.8605 | 2020-04-13 23:15:42 | Western Australia, Australia | ||
2578183 | 2578183 | 2020-04-12 | Australia | Western Australia | 514 | 6 | 216 | 292 | -31.9505 | 115.8605 | 2020-04-12 23:25:00 | Western Australia, Australia | ||
2567020 | 2567020 | 2020-04-11 | Australia | Western Australia | 514 | 6 | 216 | 292 | -31.9505 | 115.8605 | 2020-04-11 22:52:46 | Western Australia, 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]);