gifts
Data source: See col-scraper on GitHub
575 rows sorted by name
This data as json, CSV (advanced)
Link | rowid | name ▼ | date_str | date | member_id |
---|---|---|---|---|---|
393 | 393 | Dinner guest -The Honourable Society of the Middle and Inner Temple | 25th September 2017 | 2017-09-25 | Timothy Russell Hailes 1260 |
394 | 394 | Dinner guest- The Worshipful Company of Mercers - Gresham | 14 November 2017 | 2017-11-14 | Timothy Russell Hailes 1260 |
236 | 236 | Dinner hosted by the London Symphony Orchestra | 9 June 2015 | 2015-06-09 | Catherine McGuinness 373 |
530 | 530 | Dinner in celebration of Eid. Invited by the Association of Muslim Police and the City of London Corporation. | 31 July 2015 | 2015-07-31 | Alison Gowman 229 |
446 | 446 | Dinner paid for by AIG Group. | 14 April 2015 | 2015-04-14 | Sir Mark Boleat 136 |
548 | 548 | Dinner to celebrate Eid in the City invite by Muslim Police Association | 20 July 2016 | 2016-07-20 | Alison Gowman 229 |
43 | 43 | Dinner with Alderman & Sheriff Tim Hailes | 10 May 2018 | 2018-05-10 | Edward Lord 292 |
546 | 546 | Dinner with Apothecaries at invite of Past Master Apothecary | 17 March 2016 | 2016-03-17 | Alison Gowman 229 |
561 | 561 | Dinner with Cordwainers Livery Company at Clothworkers' Hall | 10 March 2017 | 2017-03-10 | Alison Gowman 229 |
558 | 558 | Dinner with Dyers' Livery Company | 5 January 2017 | 2017-01-05 | Alison Gowman 229 |
187 | 187 | Dinner with Engineers Company in Stationers’ Hall | 28th April | The Lord Mountevans, Jeffrey Evans 207 | |
544 | 544 | Dinner with Haberdashers at invite of Past Master Haberdasher | 3 March 2016 | 2016-03-03 | Alison Gowman 229 |
501 | 501 | Dinner with Lord Green at German Embassy | Peter Lionel Raleigh Hewitt, JP, FCSI, FRSA 511 | ||
44 | 44 | Dinner with Lord Mayor of Westminster | 12 May 2018 | 2018-05-12 | Edward Lord 292 |
46 | 46 | Dinner with Sir Brian Leveson/Liverpool John Moores University | 16 May 2018 | 2018-05-16 | Edward Lord 292 |
541 | 541 | Dinner with Turners' Livery Company | 16 December 2015 | 2015-12-16 | Alison Gowman 229 |
488 | 488 | Dinner with the French Ambassador | 21 March 2018 | 2018-03-21 | Sir Mark Boleat 136 |
549 | 549 | Dinner with the Hackney Carriage Drivers Livery Company | 7 September 2016 | 2016-09-07 | Alison Gowman 229 |
559 | 559 | Dinner with the Information Technology Livery Company | 18 January 2017 | 2017-01-18 | Alison Gowman 229 |
542 | 542 | Dinner with the Management Consultants' Livery Company | 20 January 2016 | 2016-01-20 | Alison Gowman 229 |
238 | 238 | Dinner – Future First – House of Lords | 22 July 2015 | 2015-07-22 | Catherine McGuinness 373 |
221 | 221 | Dinner, Association of Financial Markets in Europe | 15 October 2015 | 2015-10-15 | Sir David Hugh Wootton 397 |
226 | 226 | Dinner, Association of Financial Markets in Europe | 3 November 2016 | 2016-11-03 | Sir David Hugh Wootton 397 |
453 | 453 | Dinner, Association of Financial Markets in Europe. | 15 October 2015 | 2015-10-15 | Sir Mark Boleat 136 |
457 | 457 | Dinner, CLS Group. | 25 January 2016 | 2016-01-25 | Sir Mark Boleat 136 |
430 | 430 | Dinner, Celebrating 120 years of JLGB in the State Rooms of the Speaker's House. | 15 December 2015 | 2015-12-15 | Jeremy Mayhew 370 |
131 | 131 | Dinner, Chairmen's Forum | 11 November 2015 | 2015-11-11 | Sheriff Vincent Thomas Keaveny 1395 |
225 | 225 | Dinner, Chartered Bankers Institute | 1 September 2016 | 2016-09-01 | Sir David Hugh Wootton 397 |
454 | 454 | Dinner, China Construction Bank. | 19 October 2015 | 2015-10-19 | Sir Mark Boleat 136 |
229 | 229 | Dinner, Classics for All | 26 January 2017 | 2017-01-26 | Sir David Hugh Wootton 397 |
89 | 89 | Dinner, Clothworkers Company | 08/03/16 | Roger Arthur Holden Chadwick 158 | |
100 | 100 | Dinner, Clothworks Company | 07/03/17 | Roger Arthur Holden Chadwick 158 | |
470 | 470 | Dinner, Commonwealth Bank of Australia - Double Invitation | 7 September 2016 | 2016-09-07 | Sir Mark Boleat 136 |
334 | 334 | Dinner, District Attorney of New York - 16 November 2016 | Douglas Barrow 128 | ||
93 | 93 | Dinner, Drapers Company | 16/06/16 | Roger Arthur Holden Chadwick 158 | |
459 | 459 | Dinner, French Ambassador | 22 March 2016 | 2016-03-22 | Sir Mark Boleat 136 |
219 | 219 | Dinner, Institute of Directors | 16 September 2015 | 2015-09-16 | Sir David Hugh Wootton 397 |
223 | 223 | Dinner, Institute of Directors | 14 July 2016 | 2016-07-14 | Sir David Hugh Wootton 397 |
449 | 449 | Dinner, Institute of Economic Affairs. | 19 June 2015 | 2015-06-19 | Sir Mark Boleat 136 |
88 | 88 | Dinner, Ironmongers Company | 02/02/16 | Roger Arthur Holden Chadwick 158 | |
91 | 91 | Dinner, Leathersellers Company | 05/05/16 | Roger Arthur Holden Chadwick 158 | |
452 | 452 | Dinner, PwC, 'Building Public Trust'. | 1 October 2015 | 2015-10-01 | Sir Mark Boleat 136 |
466 | 466 | Dinner, Reignwood Investments UK | 14 June 2016 | 2016-06-14 | Sir Mark Boleat 136 |
231 | 231 | Dinner, Remenham Club | 21 April 2017 | 2017-04-21 | Sir David Hugh Wootton 397 |
224 | 224 | Dinner, Royal Military Academy, Sandhurst | 2 August 2016 | 2016-08-02 | Sir David Hugh Wootton 397 |
124 | 124 | Dinner, Society of Young Freemen | 30 July 2015 | 2015-07-30 | Sheriff Vincent Thomas Keaveny 1395 |
448 | 448 | Dinner, The Fishmongers' Company. | 13 May 2015 | 2015-05-13 | Sir Mark Boleat 136 |
230 | 230 | Dinner, The Worshipful Company of Clothworkers | 7 March 2017 | 2017-03-07 | Sir David Hugh Wootton 397 |
228 | 228 | Dinner, The Worshipful Company of Wheelwrights | 8 December 2016 | 2016-12-08 | Sir David Hugh Wootton 397 |
218 | 218 | Dinner, University of Greenwich | 14 July 2015 | 2015-07-14 | Sir David Hugh Wootton 397 |
170 | 170 | Dinner, Worshipful Company of Actuaries (guest of Clare James CC) | 2 May 2018 | 2018-05-02 | Sheriff Vincent Thomas Keaveny 1395 |
95 | 95 | Dinner, Worshipful Company of Chartered Accountants | 12/07/16 | Roger Arthur Holden Chadwick 158 | |
140 | 140 | Dinner, Worshipful Company of Cooks (guest of Mark Grove), | 10 May 2017 | 2017-05-10 | Sheriff Vincent Thomas Keaveny 1395 |
162 | 162 | Dinner, Worshipful Company of Cordwainers (guest of Ann Holmes CC) | 9 March 2018 | 2018-03-09 | Sheriff Vincent Thomas Keaveny 1395 |
149 | 149 | Dinner, Worshipful Company of Cutlers (guest of Richard Regan CC) 8 November 2017 | 8 November 2017 | 2017-11-08 | Sheriff Vincent Thomas Keaveny 1395 |
130 | 130 | Dinner, Worshipful Company of Distillers | 19 November 2015 | 2015-11-19 | Sheriff Vincent Thomas Keaveny 1395 |
164 | 164 | Dinner, Worshipful Company of Drapers | 21 March 2018 | 2018-03-21 | Sheriff Vincent Thomas Keaveny 1395 |
144 | 144 | Dinner, Worshipful Company of Educators (guest of David O'Reilly) | 22 September 2017 | 2017-09-22 | Sheriff Vincent Thomas Keaveny 1395 |
168 | 168 | Dinner, Worshipful Company of Fletchers (guest of Clare James CC) | 17 April 2018 | 2018-04-17 | Sheriff Vincent Thomas Keaveny 1395 |
123 | 123 | Dinner, Worshipful Company of Founders | 27 July 2015 | 2015-07-27 | Sheriff Vincent Thomas Keaveny 1395 |
165 | 165 | Dinner, Worshipful Company of Gardeners (guest of William Fraser) | 3 April 2018 | 2018-04-03 | Sheriff Vincent Thomas Keaveny 1395 |
132 | 132 | Dinner, Worshipful Company of Information Technologists, | 20 January 2016 | 2016-01-20 | Sheriff Vincent Thomas Keaveny 1395 |
167 | 167 | Dinner, Worshipful Company of Makers of Playing Cards | 12 April 2018 | 2018-04-12 | Sheriff Vincent Thomas Keaveny 1395 |
153 | 153 | Dinner, Worshipful Company of Makers of Playing Cards (guest of Tom Corrigan) | 7 December 2017 | 2017-12-07 | Sheriff Vincent Thomas Keaveny 1395 |
125 | 125 | Dinner, Worshipful Company of Marketors | 15 October 2015 | 2015-10-15 | Sheriff Vincent Thomas Keaveny 1395 |
156 | 156 | Dinner, Worshipful Company of Marketors | 25 January 2018 | 2018-01-25 | Sheriff Vincent Thomas Keaveny 1395 |
154 | 154 | Dinner, Worshipful Company of Plaisterers | 9 January 2018 | 2018-01-09 | Sheriff Vincent Thomas Keaveny 1395 |
145 | 145 | Dinner, Worshipful Company of Plaisterers (guest of Bryan Lincoln) | 3 October 2017 | 2017-10-03 | Sheriff Vincent Thomas Keaveny 1395 |
150 | 150 | Dinner, Worshipful Company of Stationers (guest of Tom Corrigan) | 22 November 2017 | 2017-11-22 | Sheriff Vincent Thomas Keaveny 1395 |
146 | 146 | Dinner, Worshipful Company of Wheelwrights (guest of Alan Culverhouse) | 12 October 2017 | 2017-10-12 | Sheriff Vincent Thomas Keaveny 1395 |
161 | 161 | Dinner, Worshipful Company of World Traders | 22 February 2018 | 2018-02-22 | Sheriff Vincent Thomas Keaveny 1395 |
121 | 121 | Dinner, Worshipful Society of Apothecaries | 12 May 2015 | 2015-05-12 | Sheriff Vincent Thomas Keaveny 1395 |
135 | 135 | Dinner, Worshipful Society of Apothecaries | 19 May 2016 | 2016-05-19 | Sheriff Vincent Thomas Keaveny 1395 |
141 | 141 | Dinner, Worshipful Society of Apothecaries | 16 May 2017 | 2017-05-16 | Sheriff Vincent Thomas Keaveny 1395 |
129 | 129 | Dinner, Young Presidents' Organisation | 25 September 2015 | 2015-09-25 | Sheriff Vincent Thomas Keaveny 1395 |
220 | 220 | Dinner, Young Presidents’ Organisation | 25 September 2015 | 2015-09-25 | Sir David Hugh Wootton 397 |
222 | 222 | Dinner, the Worshipful Company of Tin Plate Workers alias Wire Workers | 5 July 2016 | 2016-07-05 | Sir David Hugh Wootton 397 |
117 | 117 | Dinner: Guest at Cordwainer Livery Company | Tom Sleigh 1213 | ||
118 | 118 | Dinner: Guest of Patternmakers Livery Company | Tom Sleigh 1213 | ||
481 | 481 | Dinner: Reignwood | 10 May 2017 | 2017-05-10 | Sir Mark Boleat 136 |
480 | 480 | Dinner: Ten Trinity Square Private Club | 5 May 2017 | 2017-05-05 | Sir Mark Boleat 136 |
6 | 6 | Director's Box ticket and hospitality x2 for Manchester City Vs Newcastle United - City Football Group Limited | 3 October 2015 | 2015-10-03 | Edward Lord 292 |
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 |
18 | 18 | Directors' Box Ticket and Hospitality: Huddersfield Town v Birmingham City - Jason McCartney MP (Colne Valley) | 5 November 2016 | 2016-11-05 | Edward Lord 292 |
55 | 55 | Directors’ Box Tickets and hospitality: Celtic FC v Aberdeen FC | 9 March 2019 | 2019-03-09 | Edward Lord 292 |
70 | 70 | Diwali dinner at Drapers Hall hosted by Baroness Verma - organised by The Hinduja Foundation | 30th October 2018 | 2018-10-30 | Emma Edhem 1458 |
251 | 251 | Double Invitation, Goodenough College Law Faculty Dinner | 7 March 2017 | 2017-03-07 | Catherine McGuinness 373 |
87 | 87 | Double invitation to LSO concert at the Barbican | 09/01/16 | Roger Arthur Holden Chadwick 158 | |
94 | 94 | Double invitation to LSO concert at the Barbican | 30/06/16 | Roger Arthur Holden Chadwick 158 | |
96 | 96 | Double invitation to LSO concert at the Barbican | 20/09/16 | Roger Arthur Holden Chadwick 158 | |
103 | 103 | Double invitation to LSO concert at the Barbican | 24/09/17 | Roger Arthur Holden Chadwick 158 | |
471 | 471 | Double invitation to Royal Shakespeare Company performance of 'King Lear' - Barbican Centre | 7 December 2016 | 2016-12-07 | Sir Mark Boleat 136 |
107 | 107 | Double invitation to Royal Shakespeare Company performance of Julius Caeser at the Barbican Centre | 15/01/18 | Roger Arthur Holden Chadwick 158 | |
99 | 99 | Double invitation to Royal Shakespeare Company performance of King Lear at the Barbican Centre | 16/12/16 | Roger Arthur Holden Chadwick 158 | |
97 | 97 | Double invitation to UK/Irish Economic Relations dinner | 22/09/16 | Roger Arthur Holden Chadwick 158 | |
472 | 472 | Double invitation to concert - Barbican Centre | 22 December 2016 | 2016-12-22 | Sir Mark Boleat 136 |
193 | 193 | Double invitation to the Savoy for the Fresh Produce Consortium Dinner from Spitalfields Market Tenants' Association. £200. | John George Stewart Scott 401 | ||
493 | 493 | Drinks at Claridges (Land Securities) | 9th December | Vivienne Littlechild 287 | |
71 | 71 | Drinks reception and debate at the residence of the Dutch Ambassador - organised by IBDE and hosted by the Dutch Ambassador | 31st October 2018 | 2018-10-31 | Emma Edhem 1458 |
64 | 64 | Drinks reception and fair at Goldsmith's Hall - organised by the Goldsmiths | 27th September 2018 | 2018-09-27 | Emma Edhem 1458 |
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");