gifts
Data source: See col-scraper on GitHub
15 rows where "date" is on date 2017-11-14 sorted by name descending
This data as json, CSV (advanced)
Link | rowid | name ▲ | date_str | date | member_id |
---|---|---|---|---|---|
358 | 358 | Guest of the Worshipful Company of Clockmakers: Attended a dinner with wife Hilary, where he made a speech. | 14/11/2017 | 2017-11-14 | William Anthony Bowater Russell 1202 |
277 | 277 | Guest of Sir David Wright, Barclays | 14 November 2017 | 2017-11-14 | Catherine McGuinness 373 |
81 | 81 | Gresham Dinner, guest of the Mercers' Company | 14 November 2017 | 2017-11-14 | John Bennett 139 |
345 | 345 | Gresham Dinner, guest of the Mercers' Company | 14 November 2017 | 2017-11-14 | Christopher Michael Hayward 1218 |
35 | 35 | Gresham Dinner - guest of the Mercers' Company | 14 November 2017 | 2017-11-14 | Edward Lord 292 |
394 | 394 | Dinner guest- The Worshipful Company of Mercers - Gresham | 14 November 2017 | 2017-11-14 | Timothy Russell Hailes 1260 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE gifts ( name TEXT, date_str VARCHAR(50), date TEXT, member_id INTEGER REFERENCES members(id) ); CREATE INDEX gifts_date ON gifts("date"); CREATE INDEX gifts_member_id ON gifts("member_id");