gifts
Data source: See col-scraper on GitHub
575 rows sorted by date
This data as json, CSV (advanced)
Link | rowid | name | date_str | date ▼ | member_id |
---|---|---|---|---|---|
527 | 527 | Magna Carta celebrations - morning of entertainment, picnic lunch at Runnymede Surrey County Council. | 15 June 2015 | 2015-06-15 | Alison Gowman 229 |
528 | 528 | Innholders' Livery 500th anniversary banquet in Guildhall for 2 people | 16 June 2015 | 2015-06-16 | Alison Gowman 229 |
521 | 521 | Embassy of Luxembourg - frequent dinners and receptions | 2015-17 | 2015-06-17 | Peter Lionel Raleigh Hewitt, JP, FCSI, FRSA 511 |
522 | 522 | Apostolic Nunciature - Receptions and lunches | 2015-17 | 2015-06-17 | Peter Lionel Raleigh Hewitt, JP, FCSI, FRSA 511 |
198 | 198 | Guests of the Latvian Ambassador at a reception and concert. | 18 June 2015 | 2015-06-18 | John George Stewart Scott 401 |
237 | 237 | Exhibition and Reception – Museum of London in Docklands | 18 June 2015 | 2015-06-18 | Catherine McGuinness 373 |
449 | 449 | Dinner, Institute of Economic Affairs. | 19 June 2015 | 2015-06-19 | Sir Mark Boleat 136 |
529 | 529 | City of London Police Gala Awards dinner at Grange Hotel | 19 June 2015 | 2015-06-19 | Alison Gowman 229 |
122 | 122 | Two concert tickets provided by the City of London Festival | 22 June 2015 | 2015-06-22 | Sheriff Vincent Thomas Keaveny 1395 |
3 | 3 | Gala Dinner (for self plus partner) London LGBT Pride C.I.C. | 24 June 2015 | 2015-06-24 | Edward Lord 292 |
218 | 218 | Dinner, University of Greenwich | 14 July 2015 | 2015-07-14 | Sir David Hugh Wootton 397 |
491 | 491 | Cart Marking lunch (Worshipful Company of Carmen) | 15 July 2015 | 2015-07-15 | Vivienne Littlechild 287 |
199 | 199 | Court Dinner, Carpenters’ Company | 21 July 2015 | 2015-07-21 | John George Stewart Scott 401 |
238 | 238 | Dinner – Future First – House of Lords | 22 July 2015 | 2015-07-22 | Catherine McGuinness 373 |
123 | 123 | Dinner, Worshipful Company of Founders | 27 July 2015 | 2015-07-27 | Sheriff Vincent Thomas Keaveny 1395 |
124 | 124 | Dinner, Society of Young Freemen | 30 July 2015 | 2015-07-30 | Sheriff Vincent Thomas Keaveny 1395 |
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 |
450 | 450 | Dinner and Tickets for England vs. Switzerland provided by the Swiss Ambassador. | 8 September 2015 | 2015-09-08 | Sir Mark Boleat 136 |
126 | 126 | Dinner (with a guest), Guildable Manor of Southwark | 10 September 2015 | 2015-09-10 | Sheriff Vincent Thomas Keaveny 1395 |
240 | 240 | Guest of the BBC at the Proms and of Askonas Holt at a private dinner | 11 September 2015 | 2015-09-11 | Catherine McGuinness 373 |
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 |
239 | 239 | Two tickets and reception, LSO season opening concert (London Symphony Orchestra) | 15 September 2015 | 2015-09-15 | Catherine McGuinness 373 |
219 | 219 | Dinner, Institute of Directors | 16 September 2015 | 2015-09-16 | Sir David Hugh Wootton 397 |
532 | 532 | Attended Prince's Trust afternoon tea at the Ritz (as Deputy Chairman of City Bridge Trust) | 17 September 2015 | 2015-09-17 | Alison Gowman 229 |
533 | 533 | Invited by and attended London Symphony Orchestra concert at the Barbican with interval reception for 2 people | 21 September 2015 | 2015-09-21 | Alison Gowman 229 |
5 | 5 | Banquet - Young Presidents' Organisation London Mayfair Chapter (Chair: Deputy Alistair King) | 25 September 2015 | 2015-09-25 | Edward Lord 292 |
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 |
428 | 428 | Banquet - Young Presidents' Organisation London Mayfair Chapter (Chair: Deputising Alistair King) | 25 September 2015 | 2015-09-25 | Jeremy Mayhew 370 |
534 | 534 | Invited by Sheriffs Alderman Charles Bowman and Christine Rigden to Sheriffs' breakfast at Drapers' Hall | 28 September 2015 | 2015-09-28 | Alison Gowman 229 |
452 | 452 | Dinner, PwC, 'Building Public Trust'. | 1 October 2015 | 2015-10-01 | 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 |
377 | 377 | Guest at the Broderers' Company banquet | 7th October 2015 | 2015-10-07 | Timothy Russell Hailes 1260 |
421 | 421 | Lunch with the Indian High Commissioner | 8th October 2015 | 2015-10-08 | Sir Michael Snyder 385 |
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 |
378 | 378 | Guest at Glass Sellers' Company banquet | 12th October 2015 | 2015-10-12 | Timothy Russell Hailes 1260 |
400 | 400 | Wife attended Gibraltar Day at Guildhall. Hosted by HM government of Gibraltar. A reception. | 12 October 2015 | 2015-10-12 | Ian David Luder 296 |
401 | 401 | Acted as LMLT at the British Exporters Association Lunch at Mansion House. Hospitality provided by the Association. | 13 October 2015 | 2015-10-13 | Ian David Luder 296 |
535 | 535 | Guest of the Hamburg Chamber of Commerce at dinner, lunch and dinner to celebrate historic links between City and Hamburg. This includes two nights' accommodation at Atlantic Kempinski Hotel. | 14/15 October 2015 | 2015-10-14 | Alison Gowman 229 |
125 | 125 | Dinner, Worshipful Company of Marketors | 15 October 2015 | 2015-10-15 | Sheriff Vincent Thomas Keaveny 1395 |
221 | 221 | Dinner, Association of Financial Markets in Europe | 15 October 2015 | 2015-10-15 | Sir David Hugh Wootton 397 |
453 | 453 | Dinner, Association of Financial Markets in Europe. | 15 October 2015 | 2015-10-15 | Sir Mark Boleat 136 |
402 | 402 | Attended the Presentation Dinner with wife, hosted by the Worshipful company of Shipwrights and the Worshipful company of Goldsmiths | 19 October 2015 | 2015-10-19 | Ian David Luder 296 |
454 | 454 | Dinner, China Construction Bank. | 19 October 2015 | 2015-10-19 | Sir Mark Boleat 136 |
403 | 403 | Acted as LMLT at the Upholders Annual Banquet at Mansion House, Hospitality provided by the Company. | 20 October 2015 | 2015-10-20 | Ian David Luder 296 |
404 | 404 | Presented with a cushion by the Worshipful company of Holders, embroidered with their Coat of Arms, and the details of their current Master. | 20 October 2015 | 2015-10-20 | Ian David Luder 296 |
536 | 536 | Invited by and attended lunch with London Youth at Buckingham Palace (as Deputy Chairman of City Bridge Trust). | 22 October 2015 | 2015-10-22 | Alison Gowman 229 |
444 | 444 | Ticket for Rugby World Cup Final and Hospitality provided by EY | 31 October 2015 | 2015-10-31 | Sir Alan Colin Drake Yarrow 399 |
455 | 455 | Ticket for Rugby World Cup Final and Hospitality provided by EY. | 31 October 2015 | 2015-10-31 | Sir Mark Boleat 136 |
201 | 201 | Poulters Company Dinner | 4 November 2015 | 2015-11-04 | John George Stewart Scott 401 |
200 | 200 | Gresham Dinner | 10 November 2015 | 2015-11-10 | John George Stewart Scott 401 |
131 | 131 | Dinner, Chairmen's Forum | 11 November 2015 | 2015-11-11 | Sheriff Vincent Thomas Keaveny 1395 |
537 | 537 | Dinner at Wax Chandlers' Hall hosted by Worshipful Company of Wheelwrights (speaking engagement) | 13 November 2015 | 2015-11-13 | Alison Gowman 229 |
538 | 538 | Lunch at Two Temple Place hosted by Morgan Stanley | 16 November 2015 | 2015-11-16 | Alison Gowman 229 |
130 | 130 | Dinner, Worshipful Company of Distillers | 19 November 2015 | 2015-11-19 | Sheriff Vincent Thomas Keaveny 1395 |
173 | 173 | bottle of fine vintage port (Jim Robinson) | 20th November 2015 | 2015-11-20 | Mark Raymond Peter Henry Delano Wheatley 1229 |
405 | 405 | LMLT at The Stationers' Company Civic Dinner, at Stationers' Hall, and was accompanied by my wife | 24 November 2015 | 2015-11-24 | Ian David Luder 296 |
202 | 202 | Royal Shakespeare Company - two tickets to Henry V and a Reception for my wife and myself | 30 November 2015 | 2015-11-30 | John George Stewart Scott 401 |
441 | 441 | Two tickets from the RSC for the performance of Henry V at the Barbican Theatre | 30th November 2015 | 2015-11-30 | Joyce Carruthers Nash 382 |
539 | 539 | Prince's Trust Celebrate Success celebration at Milton Court | 2 December 2015 | 2015-12-02 | Alison Gowman 229 |
406 | 406 | LMLT at The Rifles Awards Dinner at Guildhall | 3 December 2015 | 2015-12-03 | Ian David Luder 296 |
540 | 540 | Barbican Centre two tickets to see Henry V at Barbican Theatre | 4 December 2015 | 2015-12-04 | Alison Gowman 229 |
128 | 128 | Lunch, Worshipful Company of Spectacle Makers | 8 December 2015 | 2015-12-08 | Sheriff Vincent Thomas Keaveny 1395 |
174 | 174 | Champagne and Canapé reception at Claridge's, hosted by Land Securities. | 9 December 2015 | 2015-12-09 | Stephen Douglas Quilter 362 |
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 |
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 |
541 | 541 | Dinner with Turners' Livery Company | 16 December 2015 | 2015-12-16 | Alison Gowman 229 |
177 | 177 | Christmas a 75cl bottle of Sainsbury's Blanc De Blancs Brut Champagne from Spice Innovations Limited | 17th December 2015 | 2015-12-17 | Dhruv Patel 1224 |
456 | 456 | European rugby cup match and hospitality at Saracens, double invitation from CME Group. | 16 January 2016 | 2016-01-16 | Sir Mark Boleat 136 |
132 | 132 | Dinner, Worshipful Company of Information Technologists, | 20 January 2016 | 2016-01-20 | Sheriff Vincent Thomas Keaveny 1395 |
542 | 542 | Dinner with the Management Consultants' Livery Company | 20 January 2016 | 2016-01-20 | Alison Gowman 229 |
407 | 407 | LMLT at the Annual Dinner of the Worshipful Company of Pattenmakers at Mansion House. Presented with a China Plate with a brief history of the company painted thereon. | 22 January 2016 | 2016-01-22 | Ian David Luder 296 |
457 | 457 | Dinner, CLS Group. | 25 January 2016 | 2016-01-25 | Sir Mark Boleat 136 |
7 | 7 | Dinner - Young Presidents' Organisation London Mayfair Chapter | 4 February 2016 | 2016-02-04 | Edward Lord 292 |
133 | 133 | Lunch, Worshipful Company of Distillers | 4 February 2016 | 2016-02-04 | Sheriff Vincent Thomas Keaveny 1395 |
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 |
8 | 8 | Court Dinner - Grocers' Company (Guest of Henry Colthurst CC) | 10 February 2016 | 2016-02-10 | Edward Lord 292 |
379 | 379 | Guest at Business Faculty Dinner, Goodenough College | 10th February 2016 | 2016-02-10 | Timothy Russell Hailes 1260 |
458 | 458 | Livery Banquet - Worshipful Company of Chartered Architects | 16 February 2016 | 2016-02-16 | Sir Mark Boleat 136 |
9 | 9 | Kuwait National Day Reception | 25 February 2016 | 2016-02-25 | Edward Lord 292 |
543 | 543 | Tacitus Lecture and reception as guest of the World Traders' Livery company | 25 February 2016 | 2016-02-25 | Alison Gowman 229 |
544 | 544 | Dinner with Haberdashers at invite of Past Master Haberdasher | 3 March 2016 | 2016-03-03 | Alison Gowman 229 |
545 | 545 | Presentation ceremony at London Palladium at invite of Prince's Trust | 7 March 2016 | 2016-03-07 | Alison Gowman 229 |
546 | 546 | Dinner with Apothecaries at invite of Past Master Apothecary | 17 March 2016 | 2016-03-17 | Alison Gowman 229 |
10 | 10 | Bread Street Ward Club Dinner (Guest of Deputy Giles Shilson) | 18 March 2016 | 2016-03-18 | Edward Lord 292 |
459 | 459 | Dinner, French Ambassador | 22 March 2016 | 2016-03-22 | Sir Mark Boleat 136 |
460 | 460 | CD collection from London Symphony Orchestra | 22 March 2016 | 2016-03-22 | Sir Mark Boleat 136 |
11 | 11 | Club Level Ticket & Hospitality - England Vs Netherlands (Guest of NHBC) | 29 March 2016 | 2016-03-29 | Edward Lord 292 |
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 |
461 | 461 | Philharmonie de Paris - Concert and Dinner | 12 April 2016 | 2016-04-12 | Sir Mark Boleat 136 |
462 | 462 | City Debate and Dinner - HSBC | 19 April 2016 | 2016-04-19 | Sir Mark Boleat 136 |
422 | 422 | Lunch with Gerald Ronson at his office | 22nd April 2016 | 2016-04-22 | Sir Michael Snyder 385 |
134 | 134 | Lunch (invitation to Mrs Keaveny), Worshipful Company of Founders | 25 April 2016 | 2016-04-25 | Sheriff Vincent Thomas Keaveny 1395 |
463 | 463 | Association of Foreign Banks - Annual Lunch | 26 April 2016 | 2016-04-26 | Sir Mark Boleat 136 |
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 |
464 | 464 | St Gallen Symposium - Hotel Accommodation and Airport Transit | 12-13 May 2016 | 2016-05-12 | Sir Mark Boleat 136 |
380 | 380 | Guest at banquet, Loriners Company | 13th May 2016 | 2016-05-13 | Timothy Russell Hailes 1260 |
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");