gifts
Data source: See col-scraper on GitHub
575 rows sorted by date_str descending
This data as json, CSV (advanced)
date (date) >30 ✖
- 2018-02-22 17
- 2017-11-14 15
- 2015-09-14 4
- 2015-09-25 4
- 2017-06-12 4
- 2015-05-14 3
- 2015-10-15 3
- 2016-12-06 3
- 2017-03-10 3
- 2017-05-10 3
- 2017-05-25 3
- 2017-09-23 3
- 2018-02-28 3
- 2018-03-13 3
- 2018-04-27 3
- 2018-09-19 3
- 2018-11-13 3
- 2018-11-20 3
- 2019-01-09 3
- 2019-03-12 3
- 2019-03-25 3
- 2015-05-13 2
- 2015-06-17 2
- 2015-06-18 2
- 2015-06-19 2
- 2015-10-12 2
- 2015-10-19 2
- 2015-10-20 2
- 2015-10-31 2
- 2015-11-30 2
- …
Link | rowid | name | date_str ▲ | date | member_id |
---|---|---|---|---|---|
451 | 451 | China International Capital Corporation, three dinners and one lunch. | Various | Sir Mark Boleat 136 | |
566 | 566 | Invited to the Pensions Age Award as a guest of CBRE | Thursday 23 February 2017 | 2017-02-23 | Alastair Michael Moss 1226 |
233 | 233 | Installation dinner of the Master of the Worshipful Company of Tax Advisers | Thursday 21 September 2017 | 2017-09-21 | James de Sausmarez 1658 |
75 | 75 | Pewter tankard with coat of arms of Jesus College Cambridge, presented as a gift by the 34th Symposium on Economic Crime. | September 2016 | 2016-09-28 | The Rt. Hon. the Lord Mayor, Alderman Peter Estlin 1419 |
78 | 78 | Bottle of Howard Park 2011 wine from the Agent General of Western Australia | March 2018 | 2018-03-28 | The Rt. Hon. the Lord Mayor, Alderman Peter Estlin 1419 |
76 | 76 | Bottle of alcohol and two small guide books to Belarus, received from the Ambassador of Belarus | February 2018 | 2018-02-28 | The Rt. Hon. the Lord Mayor, Alderman Peter Estlin 1419 |
77 | 77 | Hanging mobile, received from the Chief Scientist of Israel | February 2018 | 2018-02-28 | The Rt. Hon. the Lord Mayor, Alderman Peter Estlin 1419 |
172 | 172 | Tickets x 2 to the cricket at Lords Cricket Ground (Invesco) | August 2018 | 2018-08-28 | Andrien Gereith Dominic Meyers 1946 |
383 | 383 | Guest at banquet, Young Presidents Organisation | 9th September 2016 | 2016-09-09 | Timothy Russell Hailes 1260 |
79 | 79 | Indian hand painted and stitched tapestry from Wadhawan along with two copper cups. | 9th October 2018 | 2018-10-09 | The Rt. Hon. the Lord Mayor, Alderman Peter Estlin 1419 |
442 | 442 | Dinner guest - Poulters Company | 9th November 2017 | 2017-11-09 | James Richard Tumbridge 394 |
382 | 382 | Guest at banquet, Girdlers Company | 9th June 2016 | 2016-06-09 | Timothy Russell Hailes 1260 |
443 | 443 | Guest for lunch of the Worshipful Company of Poulters | 9th January 2019 | 2019-01-09 | James Richard Tumbridge 394 |
176 | 176 | Engraved Silver Trowel presented at the Avondale Square Topping Out Ceremony by Geoffrey Osborne Limited. (Donated to Clothworkers’ Company) | 9th December 2015 | 2015-12-09 | Dhruv Patel 1224 |
493 | 493 | Drinks at Claridges (Land Securities) | 9th December | Vivienne Littlechild 287 | |
399 | 399 | Acted as LMLT at the UN 70th anniversary commemoration at Guildhall, lecture , reception and dinner. Accompanied by my wife to the lecture and reception. Hospitality provided by the UNA | 9 October 2015 | 2015-10-09 | Ian David Luder 296 |
55 | 55 | Directors’ Box Tickets and hospitality: Celtic FC v Aberdeen FC | 9 March 2019 | 2019-03-09 | Edward Lord 292 |
162 | 162 | Dinner, Worshipful Company of Cordwainers (guest of Ann Holmes CC) | 9 March 2018 | 2018-03-09 | Sheriff Vincent Thomas Keaveny 1395 |
20 | 20 | Livery Dinner - The Haberdashers' Company | 9 March 2017 | 2017-03-09 | Edward Lord 292 |
236 | 236 | Dinner hosted by the London Symphony Orchestra | 9 June 2015 | 2015-06-09 | Catherine McGuinness 373 |
317 | 317 | Received two books from High Commissioner of India | 9 January 2019 | 2019-01-09 | Catherine McGuinness 373 |
318 | 318 | Received two tickets for Romeo and Juliet at the Barbican from Royal Shakespeare Company | 9 January 2019 | 2019-01-09 | Catherine McGuinness 373 |
154 | 154 | Dinner, Worshipful Company of Plaisterers | 9 January 2018 | 2018-01-09 | Sheriff Vincent Thomas Keaveny 1395 |
284 | 284 | Guest of TheCityUK at TheCityUK Media Dinner with George Parker, Political Editor of the FT | 9 January 2018 | 2018-01-09 | Catherine McGuinness 373 |
174 | 174 | Champagne and Canapé reception at Claridge's, hosted by Land Securities. | 9 December 2015 | 2015-12-09 | Stephen Douglas Quilter 362 |
523 | 523 | Upholders' Banquet at Carpenters' Hall. | 9 April 2015 | 2015-04-09 | Alison Gowman 229 |
421 | 421 | Lunch with the Indian High Commissioner | 8th October 2015 | 2015-10-08 | Sir Michael Snyder 385 |
207 | 207 | Invitation to attend a Reception at the residence of His Excellency the Ambassador of the Russian Federation, for my wife and myself. | 8th November 2016 | 2016-11-08 | John George Stewart Scott 401 |
389 | 389 | Guest at banquet, Business Faculty Dinner, Goodenough College | 8th February 2017 | 2017-02-08 | Timothy Russell Hailes 1260 |
306 | 306 | Guest of European Financial Forum [Cumberland Lodge Conference] | 8-9 November 2018 | 2018-11-09 | Catherine McGuinness 373 |
450 | 450 | Dinner and Tickets for England vs. Switzerland provided by the Swiss Ambassador. | 8 September 2015 | 2015-09-08 | Sir Mark Boleat 136 |
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 |
227 | 227 | Reception and Dinner, Co-operation Ireland | 8 November 2016 | 2016-11-08 | Sir David Hugh Wootton 397 |
12 | 12 | Two Directors' box Tickets & Hospitality Manchester City Vs Arsenal (Guest of City Football Group Plc.) | 8 May 2016 | 2016-05-08 | Edward Lord 292 |
364 | 364 | Dinner at Worshipful Company of Haberdashers | 8 March 2018 | 2018-03-08 | Tijs Broeke 1954 |
560 | 560 | Dinner at Goodenough College | 8 March 2017 | 2017-03-08 | Alison Gowman 229 |
228 | 228 | Dinner, The Worshipful Company of Wheelwrights | 8 December 2016 | 2016-12-08 | Sir David Hugh Wootton 397 |
556 | 556 | Fanmakers Livery Banquet at the Mansion House | 8 December 2016 | 2016-12-08 | Alison Gowman 229 |
128 | 128 | Lunch, Worshipful Company of Spectacle Makers | 8 December 2015 | 2015-12-08 | Sheriff Vincent Thomas Keaveny 1395 |
325 | 325 | Guest of Lord James Sassoon, Matheson & Co Lts [lunch] | 8 April 2019 | 2019-04-08 | Catherine McGuinness 373 |
377 | 377 | Guest at the Broderers' Company banquet | 7th October 2015 | 2015-10-07 | Timothy Russell Hailes 1260 |
73 | 73 | Installation of Master City Livery - guest of Trevor Brignall | 7th November 2018 | 2018-11-07 | Emma Edhem 1458 |
397 | 397 | Lunch - Senior Trade and Investment Commissioner, Austrade (Austrade) | 7th August 2018 | 2018-08-07 | Timothy Russell Hailes 1260 |
83 | 83 | Travel and accommodation costs to attend the Chengdu Innovation and Entrepreneurship Fair - Mayor of Chengdu | 7th - 15th May 2017 | 2017-05-07 | Wendy Mead 375 |
470 | 470 | Dinner, Commonwealth Bank of Australia - Double Invitation | 7 September 2016 | 2016-09-07 | Sir Mark Boleat 136 |
549 | 549 | Dinner with the Hackney Carriage Drivers Livery Company | 7 September 2016 | 2016-09-07 | Alison Gowman 229 |
338 | 338 | Invitation to Mischon de Reya Lunch with Sir Stuart Lipton | 7 October 2016 | 2016-10-07 | Christopher Michael Hayward 1218 |
234 | 234 | Annual Budget Banquet - Worshipful Company of Tax Advisers | 7 March 2018 | 2018-03-07 | James de Sausmarez 1658 |
230 | 230 | Dinner, The Worshipful Company of Clothworkers | 7 March 2017 | 2017-03-07 | Sir David Hugh Wootton 397 |
251 | 251 | Double Invitation, Goodenough College Law Faculty Dinner | 7 March 2017 | 2017-03-07 | Catherine McGuinness 373 |
545 | 545 | Presentation ceremony at London Palladium at invite of Prince's Trust | 7 March 2016 | 2016-03-07 | Alison Gowman 229 |
355 | 355 | Lunch with Chairman of Northern & Shell Plc | 7 January 2019 | 2019-01-07 | Christopher Michael Hayward 1218 |
158 | 158 | Lunch, Worshipful Company of Founders | 7 February 2018 | 2018-02-07 | 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 |
471 | 471 | Double invitation to Royal Shakespeare Company performance of 'King Lear' - Barbican Centre | 7 December 2016 | 2016-12-07 | Sir Mark Boleat 136 |
438 | 438 | Dinner at Mansion House (Canary Wharf Group) | 6th September 2018 | 2018-09-06 | Marianne Bernadette Fredericks 223 |
575 | 575 | Dinner at Mansion House (Canary Wharf Group) | 6th September 2018 | 2018-09-06 | Munsur Ali 1949 |
205 | 205 | Reception - Royal Mail Group | 6th September 2016 | 2016-09-06 | John George Stewart Scott 401 |
188 | 188 | Seatrade 2015 Awards Dinner (speech) | 6th May | The Lord Mountevans, Jeffrey Evans 207 | |
423 | 423 | Wooden bowl - received from the Governor of Western Australia | 6th June 2017 | 2017-06-06 | Charles Edward Beck Bowman 1261 |
499 | 499 | Overnight stay at residence for The Ambassador of Luxembourg and his wife | 6-7 February 2016 | 2016-02-07 | Peter Lionel Raleigh Hewitt, JP, FCSI, FRSA 511 |
498 | 498 | Overnight stay at residence for The Ambassador of Uruguay and his wife | 6-7 August 2016 | 2016-08-07 | Peter Lionel Raleigh Hewitt, JP, FCSI, FRSA 511 |
305 | 305 | Guest of DLA Piper [Drinks Reception] | 6 November 2018 | 2018-11-06 | Catherine McGuinness 373 |
275 | 275 | Wine and salt from the Ambassador of Slovenia to the UK | 6 November 2017 | 2017-11-06 | Catherine McGuinness 373 |
276 | 276 | A silk and brocade scroll from the UK Chief Rep of China Development Bank, Ms Yan Xu | 6 November 2017 | 2017-11-06 | Catherine McGuinness 373 |
487 | 487 | City Debate and dinner, Centre for the Study of Financial Innovation | 6 March 2018 | 2018-03-06 | Sir Mark Boleat 136 |
250 | 250 | Guest of Latvian Ambassador [Dinner] | 6 March 2017 | 2017-03-06 | Catherine McGuinness 373 |
475 | 475 | Dinner (double invitation) Latvian Ambassador | 6 March 2017 | 2017-03-06 | Sir Mark Boleat 136 |
261 | 261 | Guest of TheCityUK for Media Dinner with Iain Dey [Dinner] | 6 June 2017 | 2017-06-06 | Catherine McGuinness 373 |
25 | 25 | Gala Dinner, Shakespeare’s Globe – London LGBT+ Community Pride C.I.C. | 6 July 2017 | 2017-07-06 | Edward Lord 292 |
143 | 143 | Summer Party, Crosby Hall (guest of Dr Christopher Moran) | 6 July 2017 | 2017-07-06 | Sheriff Vincent Thomas Keaveny 1395 |
473 | 473 | Chinese New Year Lunch - HSBC | 6 February 2017 | 2017-02-06 | Sir Mark Boleat 136 |
313 | 313 | Guest of Labour Business [Dinner] | 6 December 2018 | 2018-12-06 | Catherine McGuinness 373 |
137 | 137 | Lunch, Worshipful Company of Spectacle Makers | 6 December 2016 | 2016-12-06 | Sheriff Vincent Thomas Keaveny 1395 |
244 | 244 | Reception and Tickets (x3) to Royal Shakespeare Company performance of King Lear at the Barbican Centre | 6 December 2016 | 2016-12-06 | Catherine McGuinness 373 |
555 | 555 | 2 tickets to King Lear at the Barbican by the Barbican Centre | 6 December 2016 | 2016-12-06 | Alison Gowman 229 |
30 | 30 | VIP ticket and hospitality – IAAF World Athletics Championships, London Stadium – London 2017 Limited | 6 August 2017 | 2017-08-06 | Edward Lord 292 |
253 | 253 | Guest of WIG [Lunch] | 6 April 2017 | 2017-04-06 | Catherine McGuinness 373 |
59 | 59 | Drinks reception at Is Bank (hosted by CEO of Is Bank) - organsied by TBCCI | 5th September 2018 | 2018-09-05 | Emma Edhem 1458 |
72 | 72 | Lunch at the House of Lords hosted by Lord Rana - organised by UK Asian Business Council & Overseas Friends of India | 5th November 2018 | 2018-11-05 | Emma Edhem 1458 |
272 | 272 | Guest of Canary Wharf Group Lunch | 5 September 2017 | 2017-09-05 | Catherine McGuinness 373 |
469 | 469 | Lloyds City Dinner - Lloyds of London | 5 September 2016 | 2016-09-05 | Sir Mark Boleat 136 |
274 | 274 | Guest of the Law Society dinner | 5 October 2017 | 2017-10-05 | Catherine McGuinness 373 |
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 |
480 | 480 | Dinner: Ten Trinity Square Private Club | 5 May 2017 | 2017-05-05 | Sir Mark Boleat 136 |
16 | 16 | Garden Party (with guest) - Middle Temple | 5 July 2016 | 2016-07-05 | Edward Lord 292 |
222 | 222 | Dinner, the Worshipful Company of Tin Plate Workers alias Wire Workers | 5 July 2016 | 2016-07-05 | Sir David Hugh Wootton 397 |
210 | 210 | London Schools Symphony Orchestra concert at the Barbican | 5 January 2017 | 2017-01-05 | John George Stewart Scott 401 |
558 | 558 | Dinner with Dyers' Livery Company | 5 January 2017 | 2017-01-05 | Alison Gowman 229 |
311 | 311 | Guest of Financial Markets Law Committee [Drinks Reception] | 5 December 2018 | 2018-12-05 | Catherine McGuinness 373 |
312 | 312 | Guest of Investment Association [Drinks Reception] | 5 December 2018 | 2018-12-05 | Catherine McGuinness 373 |
152 | 152 | Lunch, Worshipful Company of Spectacle Makers | 5 December 2017 | 2017-12-05 | Sheriff Vincent Thomas Keaveny 1395 |
279 | 279 | Guest of TheCityUK at TheCityUK Annual Dinner | 5 December 2017 | 2017-12-05 | Catherine McGuinness 373 |
408 | 408 | Guest of the Worshipful Company of Plaisterers at their Spring Dinner in role as Chairman of the Open Spaces and City Gardens Committee, to receive on behalf of the City, the payment of a silver crown as symbolic rent for the garden adjoining the Hall | 5 April 2016 | 2016-04-05 | Ian David Luder 296 |
66 | 66 | Drinks reception for the departure of inga Beale (CEO of Lloyds) at the Lloyds Building - hosted by Inga Beale and organised by Lloyds Market Place | 4th October 2018 | 2018-10-04 | Emma Edhem 1458 |
385 | 385 | Guest at banquet, Plaisterers Company | 4th October 2016 | 2016-10-04 | Timothy Russell Hailes 1260 |
497 | 497 | Overnight stay at residence for The Ambassador of Denmark and his wife | 4-5 February 2017 | 2017-02-05 | Peter Lionel Raleigh Hewitt, JP, FCSI, FRSA 511 |
353 | 353 | Guest of London and Oriental, lunch at The Ned | 4 September 2018 | 2018-09-04 | Christopher Michael Hayward 1218 |
201 | 201 | Poulters Company Dinner | 4 November 2015 | 2015-11-04 | John George Stewart Scott 401 |
139 | 139 | Worshipful Company of Information Technologists' 25th Anniversary Banquet, | 4 May 2017 | 2017-05-04 | Sheriff Vincent Thomas Keaveny 1395 |
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");