gifts
Data source: See col-scraper on GitHub
10 rows where member_id = 1954
This data as json, CSV (advanced)
date (date) 10 ✖
- 2017-04-28 1
- 2017-05-25 1
- 2018-03-08 1
- 2018-04-24 1
- 2018-04-27 1
- 2018-05-24 1
- 2018-07-22 1
- 2019-01-31 1
- 2019-03-25 1
- 2019-05-03 1
Link | rowid ▼ | name | date_str | date | member_id |
---|---|---|---|---|---|
362 | 362 | Luncheon at the conclusion of the Trial of the Pyx (Worshipful Company of Goldsmiths) | 28 April 2017 | 2017-04-28 | Tijs Broeke 1954 |
363 | 363 | Associated Companies Dinner (Worshipful Company of Mercers) | 25 May 2017 | 2017-05-25 | Tijs Broeke 1954 |
364 | 364 | Dinner at Worshipful Company of Haberdashers | 8 March 2018 | 2018-03-08 | Tijs Broeke 1954 |
365 | 365 | Saddlers’ Company lunch (with husband) | 24 April 2018 | 2018-04-24 | Tijs Broeke 1954 |
366 | 366 | Goldsmiths’ Company lunch | 27 April 2018 | 2018-04-27 | Tijs Broeke 1954 |
367 | 367 | Mercers’ Company dinner | 24 May 2018 | 2018-05-24 | Tijs Broeke 1954 |
368 | 368 | Ticket plus guest ticket for morning session of Hockey World Cup (City of London Corporation) | 22 July 2018 | 2018-07-22 | Tijs Broeke 1954 |
369 | 369 | London Planning Awards (guest of The Tenacity Group) | 31 January 2019 | 2019-01-31 | Tijs Broeke 1954 |
370 | 370 | Dinner at Chartered Secretaries and Administrators’ Company | 25 March 2019 | 2019-03-25 | Tijs Broeke 1954 |
371 | 371 | Lunch at Goldsmiths’ Company (Trial of the Pyx) | 3 May 2019 | 2019-05-03 | Tijs Broeke 1954 |
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");