daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
14 rows where country_or_region = "Malta" and deaths = 6 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: recovered, active, day (date)
country_or_region 1
- Malta · 14 ✖
province_or_state 0
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2020-05-26 | Malta | 611 | 6 | 485 | 120 | 35.9375 | 14.3754 | 2020-05-27 02:32:31 | Malta | |||
2020-05-25 | Malta | 611 | 6 | 485 | 120 | 35.9375 | 14.3754 | 2020-05-26 02:32:35 | Malta | |||
2020-05-24 | Malta | 610 | 6 | 476 | 128 | 35.9375 | 14.3754 | 2020-05-25 02:32:44 | Malta | |||
2020-05-23 | Malta | 609 | 6 | 473 | 130 | 35.9375 | 14.3754 | 2020-05-24 02:32:43 | Malta | |||
2020-05-22 | Malta | 600 | 6 | 469 | 125 | 35.9375 | 14.3754 | 2020-05-23 02:32:42 | Malta | |||
2020-05-21 | Malta | 599 | 6 | 468 | 125 | 35.9375 | 14.3754 | 2020-05-22 02:36:51 | Malta | |||
2020-05-20 | Malta | 584 | 6 | 465 | 113 | 35.9375 | 14.3754 | 2020-05-21 02:32:48 | Malta | |||
2020-05-19 | Malta | 569 | 6 | 460 | 103 | 35.9375 | 14.3754 | 2020-05-20 02:32:19 | Malta | |||
2020-05-18 | Malta | 558 | 6 | 456 | 96 | 35.9375 | 14.3754 | 2020-05-19 02:32:18 | Malta | |||
2020-05-17 | Malta | 553 | 6 | 454 | 93 | 35.9375 | 14.3754 | 2020-05-18 02:32:21 | Malta | |||
2020-05-16 | Malta | 546 | 6 | 450 | 90 | 35.9375 | 14.3754 | 2020-05-17 02:32:32 | Malta | |||
2020-05-15 | Malta | 532 | 6 | 458 | 68 | 35.9375 | 14.3754 | 2020-05-16 02:32:19 | Malta | |||
2020-05-14 | Malta | 522 | 6 | 443 | 73 | 35.9375 | 14.3754 | 2020-05-15 02:33:02 | Malta | |||
2020-05-13 | Malta | 508 | 6 | 436 | 66 | 35.9375 | 14.3754 | 2020-05-14 03:32:28 | Malta |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;