gifts
Data source: See col-scraper on GitHub
4 rows where "date" is on date 2015-09-14
This data as json, CSV (advanced)
Suggested facets: date_str
member_id 4 ✖
Link | rowid ▼ | name | date_str | date | member_id |
---|---|---|---|---|---|
4 | 4 | Director's Box ticket for West Ham United v Newcastle United - Greg Lawrence CC | 14 September 2015 | 2015-09-14 | Edward Lord 292 |
127 | 127 | Dinner (with a guest), Onassis Foundation/Cass Business School | 14 September 2015 | 2015-09-14 | Sheriff Vincent Thomas Keaveny 1395 |
420 | 420 | Lunch with David Landsman | 14th September 2015 | 2015-09-14 | Sir Michael Snyder 385 |
531 | 531 | Attended a Medieval Mumming followed by drinks reception - Skinners' Livery Company | 14 September 2015 | 2015-09-14 | Alison Gowman 229 |
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");