johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
18 rows where country_or_region = "Ireland" and recovered = 5 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, day (date)
country_or_region 1
- Ireland · 18 ✖
province_or_state 0
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3740632 | 3740632 | 2020-04-03 | Ireland | 4273 | 120 | 5 | 4148 | 53.1424 | -7.6921 | 2020-04-03 22:46:20 | Ireland | |||
3701662 | 3701662 | 2020-04-02 | Ireland | 3849 | 98 | 5 | 3746 | 53.1424 | -7.6921 | 4/2/20 23:25 | Ireland | |||
3364866 | 3364866 | 2020-04-01 | Ireland | 3447 | 85 | 5 | 3357 | 53.1424 | -7.6921 | 2020-04-01 21:58:34 | Ireland | |||
3815959 | 3815959 | 2020-03-31 | Ireland | 3235 | 71 | 5 | 3159 | 53.1424 | -7.6921 | 2020-03-31 23:43:43 | Ireland | |||
1872510 | 1872510 | 2020-03-30 | Ireland | 2910 | 54 | 5 | 2851 | 53.1424 | -7.6921 | 3/30/20 22:52 | Ireland | |||
2875746 | 2875746 | 2020-03-29 | Ireland | 2615 | 46 | 5 | 2564 | 53.1424 | -7.6921 | 3/29/20 23:08 | Ireland | |||
3947082 | 3947082 | 2020-03-28 | Ireland | 2415 | 36 | 5 | 2374 | 53.1424 | -7.6921 | 3/28/20 23:05 | Ireland | |||
809131 | 809131 | 2020-03-27 | Ireland | 2121 | 22 | 5 | 2094 | 53.1424 | -7.6921 | 2020-03-27 23:23:03 | Ireland | |||
919223 | 919223 | 2020-03-26 | Ireland | 1819 | 19 | 5 | 1795 | 53.1424 | -7.6921 | 2020-03-26 23:48:18 | Ireland | |||
1132624 | 1132624 | 2020-03-25 | Ireland | 1564 | 9 | 5 | 1550 | 53.1424 | -7.6921 | 2020-03-25 23:33:04 | Ireland | |||
1479130 | 1479130 | 2020-03-24 | Ireland | 1329 | 7 | 5 | 1317 | 53.1424 | -7.6921 | 2020-03-24 23:37:15 | Ireland | |||
2147186 | 2147186 | 2020-03-23 | Ireland | 1125 | 6 | 5 | 1114 | 53.1424 | -7.6921 | 2020-03-23 23:19:21 | Ireland | |||
2910657 | 2910657 | 2020-03-22 | Ireland | 906 | 4 | 5 | 897 | 53.1424 | -7.6921 | 3/22/20 23:45 | Ireland | |||
339654 | 339654 | 2020-03-21 | Ireland | 785 | 3 | 5 | 53.1424 | -7.6921 | 2020-03-21T20:43:02 | |||||
3733952 | 3733952 | 2020-03-20 | Ireland | 683 | 3 | 5 | 53.1424 | -7.6921 | 2020-03-20T20:13:16 | |||||
1526905 | 1526905 | 2020-03-19 | Ireland | 557 | 3 | 5 | 53.1424 | -7.6921 | 2020-03-19T18:43:03 | |||||
1176920 | 1176920 | 2020-03-18 | Ireland | 292 | 2 | 5 | 53.1424 | -7.6921 | 2020-03-18T03:13:12 | |||||
3891357 | 3891357 | 2020-03-17 | Ireland | 223 | 2 | 5 | 53.1424 | -7.6921 | 2020-03-17T02:53:03 |
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]);