gifts
Data source: See col-scraper on GitHub
4 rows where "date" is on date 2017-06-12
This data as json, CSV (advanced)
Suggested facets: date_str
member_id 3 ✖
Link | rowid ▼ | name | date_str | date | member_id |
---|---|---|---|---|---|
142 | 142 | Lime Street & Cornhill Ward Club Civic Luncheon (with a guest) | 12 June 2017 | 2017-06-12 | Sheriff Vincent Thomas Keaveny 1395 |
262 | 262 | Guest of Sherard Cowper-Coles, HSBC [Breakfast] | 12 June 2017 | 2017-06-12 | Catherine McGuinness 373 |
263 | 263 | Guest of Strand Group [Drinks] | 12 June 2017 | 2017-06-12 | Catherine McGuinness 373 |
342 | 342 | Guest at lunch hosted by Richard Desmond (Northern & Shell plc) | 12th June 2017 | 2017-06-12 | Christopher Michael Hayward 1218 |
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");