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 |
---|---|---|---|---|---|
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 |
60 | 60 | Drinks reception at the House of lords for JETCO - organised by DIT and DEIK | 11th September 2018 | 2018-09-11 | Emma Edhem 1458 |
69 | 69 | Drinks reception at the residence of the Turksih Ambassador - organised by the Turkish Embassy | 29th October 2018 | 2018-10-29 | Emma Edhem 1458 |
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 |
151 | 151 | Duke of Edinburgh's Award Trustees Dinner (guest of Patricia Teahan) | 28 November 2017 | 2017-11-28 | Sheriff Vincent Thomas Keaveny 1395 |
245 | 245 | Editorial Intelligence Networking Nations Lecture and Dinner | 16 January 2017 | 2017-01-16 | Catherine McGuinness 373 |
516 | 516 | Embassy of Argentina - frequent dinners and receptions | 2015 - current | Peter Lionel Raleigh Hewitt, JP, FCSI, FRSA 511 | |
515 | 515 | Embassy of Austria - frequent dinners and receptions | 2015 - current | Peter Lionel Raleigh Hewitt, JP, FCSI, FRSA 511 | |
513 | 513 | Embassy of Belgium - frequent dinners and receptions | 2015 - current | Peter Lionel Raleigh Hewitt, JP, FCSI, FRSA 511 | |
514 | 514 | Embassy of Germany - frequent dinners and receptions | 2015 - current | Peter Lionel Raleigh Hewitt, JP, FCSI, FRSA 511 | |
512 | 512 | Embassy of Ireland - frequent dinners and receptions | 2015 - current | Peter Lionel Raleigh Hewitt, JP, FCSI, FRSA 511 | |
521 | 521 | Embassy of Luxembourg - frequent dinners and receptions | 2015-17 | 2015-06-17 | Peter Lionel Raleigh Hewitt, JP, FCSI, FRSA 511 |
520 | 520 | Embassy of Peru - frequent dinners and receptions | 2016 - current | Peter Lionel Raleigh Hewitt, JP, FCSI, FRSA 511 | |
518 | 518 | Embassy of Slovakia - frequent dinners and receptions | 2015 - current | Peter Lionel Raleigh Hewitt, JP, FCSI, FRSA 511 | |
519 | 519 | Embassy of Slovenia - frequent dinners and receptions | 2016 - current | Peter Lionel Raleigh Hewitt, JP, FCSI, FRSA 511 | |
517 | 517 | Embassy of Uruguay - frequent dinners and receptions | 2015 - current | Peter Lionel Raleigh Hewitt, JP, FCSI, FRSA 511 | |
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 |
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 |
237 | 237 | Exhibition and Reception – Museum of London in Docklands | 18 June 2015 | 2015-06-18 | Catherine McGuinness 373 |
160 | 160 | Faculty Dinner (with a guest), Goodenough College | 21 February 2018 | 2018-02-21 | Sheriff Vincent Thomas Keaveny 1395 |
105 | 105 | Faculty Dinner Goodenough College | 22/11/17 | Roger Arthur Holden Chadwick 158 | |
556 | 556 | Fanmakers Livery Banquet at the Mansion House | 8 December 2016 | 2016-12-08 | Alison Gowman 229 |
321 | 321 | Flowers from Swiss Embassy | 1 March 2019 | 2019-03-01 | Catherine McGuinness 373 |
3 | 3 | Gala Dinner (for self plus partner) London LGBT Pride C.I.C. | 24 June 2015 | 2015-06-24 | Edward Lord 292 |
33 | 33 | Gala Dinner - guest of Albert Kennedy Trust | 19 October 2017 | 2017-10-19 | Edward Lord 292 |
15 | 15 | Gala Dinner at Mansion House (Guest of London LGBT Community Pride C.I.C) | 22 June 2016 | 2016-06-22 | Edward Lord 292 |
25 | 25 | Gala Dinner, Shakespeare’s Globe – London LGBT+ Community Pride C.I.C. | 6 July 2017 | 2017-07-06 | Edward Lord 292 |
16 | 16 | Garden Party (with guest) - Middle Temple | 5 July 2016 | 2016-07-05 | Edward Lord 292 |
24 | 24 | Garden Party (with guest) – Middle Temple | 4 July 2017 | 2017-07-04 | Edward Lord 292 |
329 | 329 | Goldsmiths’ Company lunch | 27 April 2018 | 2018-04-27 | Nicholas Michael Bensted-Smith 1472 |
366 | 366 | Goldsmiths’ Company lunch | 27 April 2018 | 2018-04-27 | Tijs Broeke 1954 |
58 | 58 | Gresham College Stakeholder Presentation & Dinner (Worshipful Company of Mercers) | 22 February 2018 | 2018-02-22 | Tom Hoffman 251 |
82 | 82 | Gresham College Stakeholder Presentation & Dinner (Worshipful Company of Mercers) | 22 February 2018 | 2018-02-22 | John Bennett 139 |
84 | 84 | Gresham College Stakeholder Presentation & Dinner (Worshipful Company of Mercers) | 22 February 2018 | 2018-02-22 | Wendy Mead 375 |
217 | 217 | Gresham College Stakeholder Presentation & Dinner (Worshipful Company of Mercers) | 22 February 2018 | 2018-02-22 | John George Stewart Scott 401 |
232 | 232 | Gresham College Stakeholder Presentation & Dinner (Worshipful Company of Mercers) | 22 February 2018 | 2018-02-22 | Sir David Hugh Wootton 397 |
291 | 291 | Gresham College Stakeholder Presentation & Dinner (Worshipful Company of Mercers) | 22 February 2018 | 2018-02-22 | Catherine McGuinness 373 |
327 | 327 | Gresham College Stakeholder Presentation & Dinner (Worshipful Company of Mercers) | 22 February 2018 | 2018-02-22 | Nicholas Michael Bensted-Smith 1472 |
333 | 333 | Gresham College Stakeholder Presentation & Dinner (Worshipful Company of Mercers) | 22 February 2018 | 2018-02-22 | Jamie Ingham Clark 1223 |
348 | 348 | Gresham College Stakeholder Presentation & Dinner (Worshipful Company of Mercers) | 22 February 2018 | 2018-02-22 | Christopher Michael Hayward 1218 |
419 | 419 | Gresham College Stakeholder Presentation & Dinner (Worshipful Company of Mercers) | 22 February 2018 | 2018-02-22 | Simon D'Olier Duckworth 151 |
434 | 434 | Gresham College Stakeholder Presentation & Dinner (Worshipful Company of Mercers) | 22 February 2018 | 2018-02-22 | Jeremy Mayhew 370 |
485 | 485 | Gresham College Stakeholder Presentation & Dinner (Worshipful Company of Mercers) | 22 February 2018 | 2018-02-22 | Sir Mark Boleat 136 |
564 | 564 | Gresham College Stakeholder Presentation & Dinner (Worshipful Company of Mercers) | 22 February 2018 | 2018-02-22 | Dr Giles Robert Evelyn Shilson 383 |
413 | 413 | Gresham College Stakeholder Presentation & Dinner (Worshipful Company of Mercers). | 22 Feb 2018 | 2018-02-22 | Ian David Luder 296 |
200 | 200 | Gresham Dinner | 10 November 2015 | 2015-11-10 | John George Stewart Scott 401 |
49 | 49 | Gresham Dinner - The Mercers' Company | 13 November 2018 | 2018-11-13 | Edward Lord 292 |
35 | 35 | Gresham Dinner - guest of the Mercers' Company | 14 November 2017 | 2017-11-14 | Edward Lord 292 |
36 | 36 | Gresham Dinner - guest of the Mercers' Company | 22 February 2018 | 2018-02-22 | Edward Lord 292 |
81 | 81 | Gresham Dinner, guest of the Mercers' Company | 14 November 2017 | 2017-11-14 | John Bennett 139 |
345 | 345 | Gresham Dinner, guest of the Mercers' Company | 14 November 2017 | 2017-11-14 | Christopher Michael Hayward 1218 |
409 | 409 | Guest (with my wife) at the Worshipful Company of Grocers' Presentation Dinner at Grocers' Hall, at which I delivered a speech. | 16 October 2017 | 2017-10-16 | Ian David Luder 296 |
379 | 379 | Guest at Business Faculty Dinner, Goodenough College | 10th February 2016 | 2016-02-10 | Timothy Russell Hailes 1260 |
378 | 378 | Guest at Glass Sellers' Company banquet | 12th October 2015 | 2015-10-12 | Timothy Russell Hailes 1260 |
570 | 570 | Guest at London Chamber of Commerce reception at the Five Seasons Hotel, Cannes | 12 March 2019 | 2019-03-12 | Alastair Michael Moss 1226 |
389 | 389 | Guest at banquet, Business Faculty Dinner, Goodenough College | 8th February 2017 | 2017-02-08 | Timothy Russell Hailes 1260 |
382 | 382 | Guest at banquet, Girdlers Company | 9th June 2016 | 2016-06-09 | Timothy Russell Hailes 1260 |
381 | 381 | Guest at banquet, Guild of Young Freemen | 27th May 2016 | 2016-05-27 | Timothy Russell Hailes 1260 |
384 | 384 | Guest at banquet, Guildable Manor of Southwark | 15th September 2016 | 2016-09-15 | Timothy Russell Hailes 1260 |
380 | 380 | Guest at banquet, Loriners Company | 13th May 2016 | 2016-05-13 | Timothy Russell Hailes 1260 |
386 | 386 | Guest at banquet, Marketors Company | 22nd October 2016 | 2016-10-22 | Timothy Russell Hailes 1260 |
385 | 385 | Guest at banquet, Plaisterers Company | 4th October 2016 | 2016-10-04 | Timothy Russell Hailes 1260 |
388 | 388 | Guest at banquet, Plaisterers Company | 10th January 2017 | 2017-01-10 | Timothy Russell Hailes 1260 |
387 | 387 | Guest at banquet, Tobacco Pipe Makers Company | 24th October 2016 | 2016-10-24 | Timothy Russell Hailes 1260 |
383 | 383 | Guest at banquet, Young Presidents Organisation | 9th September 2016 | 2016-09-09 | Timothy Russell Hailes 1260 |
342 | 342 | Guest at lunch hosted by Richard Desmond (Northern & Shell plc) | 12th June 2017 | 2017-06-12 | Christopher Michael Hayward 1218 |
390 | 390 | Guest at luncheon, Salters Company - | 2nd March 2017 | 2017-03-02 | Timothy Russell Hailes 1260 |
377 | 377 | Guest at the Broderers' Company banquet | 7th October 2015 | 2015-10-07 | 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 |
320 | 320 | Guest of Andre Villeneuve, ICE Company | 1 March 2019 | 2019-03-01 | Catherine McGuinness 373 |
552 | 552 | Guest of Arts Scholars Livery Company to company lecture and reception | 20 October 2016 | 2016-10-20 | Alison Gowman 229 |
297 | 297 | Guest of Association of Foreign Banks Lunch | 22 May 2018 | 2018-05-22 | Catherine McGuinness 373 |
255 | 255 | Guest of CBI [Dinner] | 17 May 2017 | 2017-05-17 | Catherine McGuinness 373 |
270 | 270 | Guest of CBI [Presidents' Dinner] | 3 July 2017 | 2017-07-03 | Catherine McGuinness 373 |
293 | 293 | Guest of CBRE at a dinner at MIPIM | 13 March 2018 | 2018-03-13 | Catherine McGuinness 373 |
292 | 292 | Guest of CPA and WPA at a lunch at MIPIM | 13 March 2018 | 2018-03-13 | Catherine McGuinness 373 |
272 | 272 | Guest of Canary Wharf Group Lunch | 5 September 2017 | 2017-09-05 | Catherine McGuinness 373 |
281 | 281 | Guest of Catalyst at Drinks and Dinner at Lambeth Palace "10 years since the crisis, what does 'good' banking look like?" | 12 December 2017 | 2017-12-12 | Catherine McGuinness 373 |
307 | 307 | Guest of Centre for European Reform [Ditchley Park Conference] | 16 November 2018 | 2018-11-16 | Catherine McGuinness 373 |
351 | 351 | Guest of Christopher Moran Dinner at Crosby Hall | 16 May 2018 | 2018-05-16 | Christopher Michael Hayward 1218 |
553 | 553 | Guest of Christopher Moran, Co-operation Ireland to dinner at Crosby Hall | 24 October 2016 | 2016-10-24 | Alison Gowman 229 |
273 | 273 | Guest of Citi Group dinner at Conservative Party Conference | 1 October 2017 | 2017-10-01 | Catherine McGuinness 373 |
354 | 354 | Guest of City Property Association, lunch at The Coq D'argent | 2 November 2018 | 2018-11-02 | Christopher Michael Hayward 1218 |
264 | 264 | Guest of City Women: Future Leaders Award Celebration | 19 June 2017 | 2017-06-19 | Catherine McGuinness 373 |
299 | 299 | Guest of City and Financial for Breakfast with Chief Executive | 19 September 2018 | 2018-09-19 | Catherine McGuinness 373 |
265 | 265 | Guest of Clifford Chance [Lunch] | 20 June 2017 | 2017-06-20 | Catherine McGuinness 373 |
298 | 298 | Guest of Confederation of British Industry Dinner | 22 May 2018 | 2018-05-22 | Catherine McGuinness 373 |
310 | 310 | Guest of Confederation of British Industry [Drinks Reception] | 3 December 2018 | 2018-12-03 | Catherine McGuinness 373 |
305 | 305 | Guest of DLA Piper [Drinks Reception] | 6 November 2018 | 2018-11-06 | Catherine McGuinness 373 |
248 | 248 | Guest of EY [Lunch] | 13 February 2017 | 2017-02-13 | Catherine McGuinness 373 |
266 | 266 | Guest of Education Policy Institute [Drinks] | 20 June 2017 | 2017-06-20 | Catherine McGuinness 373 |
306 | 306 | Guest of European Financial Forum [Cumberland Lodge Conference] | 8-9 November 2018 | 2018-11-09 | Catherine McGuinness 373 |
352 | 352 | Guest of Farebrother Chartered Surveyors, dinner at the RAC Club | 3 September 2018 | 2018-09-03 | Christopher Michael Hayward 1218 |
311 | 311 | Guest of Financial Markets Law Committee [Drinks Reception] | 5 December 2018 | 2018-12-05 | Catherine McGuinness 373 |
249 | 249 | Guest of Flint Global [Lunch] | 22 February 2017 | 2017-02-22 | Catherine McGuinness 373 |
290 | 290 | Guest of HSBC at the HSBC Chinese New Year Lunch | 27 February 2018 | 2018-02-27 | Catherine McGuinness 373 |
242 | 242 | Guest of Inner City Trust at Chamber of Commerce 59th Annual President’s Dinner, Derry-Londonderry (Dinner and Hotel Accommodation) | 21 October 2016 | 2016-10-21 | Catherine McGuinness 373 |
319 | 319 | Guest of Inner City Trust with Dinner & Accommodation at the Bishopsgate Hotel, Derry/Londonderry | 3 February 2019 | 2019-02-03 | Catherine McGuinness 373 |
308 | 308 | Guest of Institute of International Finance [Lunch in New York] | 27 November 2018 | 2018-11-27 | Catherine McGuinness 373 |
301 | 301 | Guest of International Bar Association [Lunch in Rome] | 11 October 2018 | 2018-10-11 | Catherine McGuinness 373 |
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");