gifts
Data source: See col-scraper on GitHub
575 rows
This data as json, CSV (advanced)
Link | rowid ▼ | name | date_str | date | member_id |
---|---|---|---|---|---|
301 | 301 | Guest of International Bar Association [Lunch in Rome] | 11 October 2018 | 2018-10-11 | Catherine McGuinness 373 |
302 | 302 | Guest of TheCityUK [Dinner in Rome] | 11 October 2018 | 2018-10-11 | Catherine McGuinness 373 |
303 | 303 | Guest of the Investment Association [Annual Dinner] | 16 October 2018 | 2018-10-16 | Catherine McGuinness 373 |
304 | 304 | Guest of PIMFA [Lunch] | 17 October 2018 | 2018-10-17 | Catherine McGuinness 373 |
305 | 305 | Guest of DLA Piper [Drinks Reception] | 6 November 2018 | 2018-11-06 | Catherine McGuinness 373 |
306 | 306 | Guest of European Financial Forum [Cumberland Lodge Conference] | 8-9 November 2018 | 2018-11-09 | Catherine McGuinness 373 |
307 | 307 | Guest of Centre for European Reform [Ditchley Park Conference] | 16 November 2018 | 2018-11-16 | Catherine McGuinness 373 |
308 | 308 | Guest of Institute of International Finance [Lunch in New York] | 27 November 2018 | 2018-11-27 | Catherine McGuinness 373 |
309 | 309 | Guest of Investment Association [Dinner in Washington] | 28 November 2018 | 2018-11-28 | Catherine McGuinness 373 |
310 | 310 | Guest of Confederation of British Industry [Drinks Reception] | 3 December 2018 | 2018-12-03 | Catherine McGuinness 373 |
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 |
313 | 313 | Guest of Labour Business [Dinner] | 6 December 2018 | 2018-12-06 | Catherine McGuinness 373 |
314 | 314 | Guest of Law Society [Dinner] | 10 December 2018 | 2018-12-10 | Catherine McGuinness 373 |
315 | 315 | Guest of London Stock Exchange [Lunch] | 14 December 2018 | 2018-12-14 | Catherine McGuinness 373 |
316 | 316 | Received Bottle of Red Wine from Deputy High Commissioner of India | 24 December 2018 | 2018-12-24 | 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 |
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 |
320 | 320 | Guest of Andre Villeneuve, ICE Company | 1 March 2019 | 2019-03-01 | Catherine McGuinness 373 |
321 | 321 | Flowers from Swiss Embassy | 1 March 2019 | 2019-03-01 | Catherine McGuinness 373 |
322 | 322 | Guest of the Irish Embassy, Brunch at Bentleys for St Patrick's Day | 17 March 2019 | 2019-03-17 | Catherine McGuinness 373 |
323 | 323 | Guest of Robinson Hambro [dinner] | 25 March 2019 | 2019-03-25 | Catherine McGuinness 373 |
324 | 324 | Guest of KPMG [lunch] | 25 March 2019 | 2019-03-25 | Catherine McGuinness 373 |
325 | 325 | Guest of Lord James Sassoon, Matheson & Co Lts [lunch] | 8 April 2019 | 2019-04-08 | Catherine McGuinness 373 |
326 | 326 | The Worshipful Company of Mercers Gresham Dinner | 14 November 2017 | 2017-11-14 | Nicholas Michael Bensted-Smith 1472 |
327 | 327 | Gresham College Stakeholder Presentation & Dinner (Worshipful Company of Mercers) | 22 February 2018 | 2018-02-22 | Nicholas Michael Bensted-Smith 1472 |
328 | 328 | Saddlers’ Company lunch (with wife) | 24 April 2018 | 2018-04-24 | Nicholas Michael Bensted-Smith 1472 |
329 | 329 | Goldsmiths’ Company lunch | 27 April 2018 | 2018-04-27 | Nicholas Michael Bensted-Smith 1472 |
330 | 330 | Mercers’ Company dinner | 24 May 2018 | 2018-05-24 | Nicholas Michael Bensted-Smith 1472 |
331 | 331 | The Worshipful Company of Mercers Gresham Dinner | 13 November 2018 | 2018-11-13 | Nicholas Michael Bensted-Smith 1472 |
332 | 332 | 9th September - 1 ticket and hospitality in a Private Box at Lords Cricket Ground provided by White & Case LLP | Peter Gerard Dunphy 200 | ||
333 | 333 | Gresham College Stakeholder Presentation & Dinner (Worshipful Company of Mercers) | 22 February 2018 | 2018-02-22 | Jamie Ingham Clark 1223 |
334 | 334 | Dinner, District Attorney of New York - 16 November 2016 | Douglas Barrow 128 | ||
335 | 335 | Two tickets from British Police Symphony Orchestra for Charity Gala Concert on 11.05.19 | Douglas Barrow 128 | ||
336 | 336 | 14 May 2015 – Reception and Dinner for City Magna Carta Charter | Michael Hudson 256 | ||
337 | 337 | Invitation (with guest) to Supper at National Gallery marking Sir Stuart Lipton's 50 years' involvement in property. | 13 June 2016 | 2016-06-13 | Christopher Michael Hayward 1218 |
338 | 338 | Invitation to Mischon de Reya Lunch with Sir Stuart Lipton | 7 October 2016 | 2016-10-07 | Christopher Michael Hayward 1218 |
339 | 339 | Lunch at the Goring with Mike Hussey, Almacantar Ltd | 29 November 2016 | 2016-11-29 | Christopher Michael Hayward 1218 |
340 | 340 | Hosted to dinner at 1 Lombard Street by the City Architecture Forum (Guest Speaker) | 23 November 2016 | 2016-11-23 | Christopher Michael Hayward 1218 |
341 | 341 | Hosted breakfast at Guildhall by Gerald Eve Associates (Guest Speaker) | 24th November 2016 | 2016-11-24 | Christopher Michael Hayward 1218 |
342 | 342 | Guest at lunch hosted by Richard Desmond (Northern & Shell plc) | 12th June 2017 | 2017-06-12 | Christopher Michael Hayward 1218 |
343 | 343 | Lunch with the owners of Harry’s Bar and Restaurant, 5 Abchurch Yard, EC4N 7BA | 17 July 2017 | 2017-07-17 | Christopher Michael Hayward 1218 |
344 | 344 | Dinner and gift of a leather travel wallet at the Guildhall for the C & C Alpha Group Limited (Guest Speaker) | 23rd September 2017 | 2017-09-23 | Christopher Michael Hayward 1218 |
345 | 345 | Gresham Dinner, guest of the Mercers' Company | 14 November 2017 | 2017-11-14 | Christopher Michael Hayward 1218 |
346 | 346 | Lunch - Richard Desmond (Northern & Shell PLC) | 2nd February 2018 | 2018-02-02 | Christopher Michael Hayward 1218 |
347 | 347 | Lunch with Harrry Haddad, Harry’s Bar, Ironmonger Lane, EC2V 8EP | 13 February 2018 | 2018-02-13 | Christopher Michael Hayward 1218 |
348 | 348 | Gresham College Stakeholder Presentation & Dinner (Worshipful Company of Mercers) | 22 February 2018 | 2018-02-22 | Christopher Michael Hayward 1218 |
349 | 349 | Guest of KPMG at Dinner at Plage l'Ondine at MIPIM | 13 March 2018 | 2018-03-13 | Christopher Michael Hayward 1218 |
350 | 350 | Guest of London Chamber of Commerce at a Presidents Lunch at MIPIM | 14 March 2018 | 2018-03-14 | Christopher Michael Hayward 1218 |
351 | 351 | Guest of Christopher Moran Dinner at Crosby Hall | 16 May 2018 | 2018-05-16 | Christopher Michael Hayward 1218 |
352 | 352 | Guest of Farebrother Chartered Surveyors, dinner at the RAC Club | 3 September 2018 | 2018-09-03 | Christopher Michael Hayward 1218 |
353 | 353 | Guest of London and Oriental, lunch at The Ned | 4 September 2018 | 2018-09-04 | Christopher Michael Hayward 1218 |
354 | 354 | Guest of City Property Association, lunch at The Coq D'argent | 2 November 2018 | 2018-11-02 | Christopher Michael Hayward 1218 |
355 | 355 | Lunch with Chairman of Northern & Shell Plc | 7 January 2019 | 2019-01-07 | Christopher Michael Hayward 1218 |
356 | 356 | Tickets to attend a London Symphony Orchestra concert on Tuesday 20 September at 7.30pm in the Barbican Hall. Received from London Symphony Orchestra. | 20/09/16 | Anne Helen Fairweather 1756 | |
357 | 357 | Return flights from London to Doha, Qatar; hotel expenses and meals - 2nd-3rd December 2017. Received from Qatar Financial Centre. | 2nd-3rd December 2017 | 2017-12-03 | Anne Helen Fairweather 1756 |
358 | 358 | Guest of the Worshipful Company of Clockmakers: Attended a dinner with wife Hilary, where he made a speech. | 14/11/2017 | 2017-11-14 | William Anthony Bowater Russell 1202 |
359 | 359 | Liverpool v Napoli - guest of Standard Chartered Bank, Anfield box | 11/12/2018 | 2018-12-11 | William Anthony Bowater Russell 1202 |
360 | 360 | Liverpool v Bayern Munich - guest of Standard Chartered Bank, Anfield box | 19/02/2019 | 2019-02-19 | William Anthony Bowater Russell 1202 |
361 | 361 | Dinner at the Walbrook Club as guest of Tenacity Group. | 20th November 2018 | 2018-11-20 | Christopher Hill 1942 |
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 |
372 | 372 | 14 May 2015. Evensong at Temple Church; reception at Middle Temple Hall and dinner at Inner Temple Hall as a combined invitation from the Treasurers of Inner and Middle Temple. | Richard David Regan 367 | ||
373 | 373 | Reception - Metrobank (to mark the opening of their new branch in Bishopsgate) | 14 November 2017 | 2017-11-14 | Wendy Hyde 263 |
374 | 374 | Tickets to LSO concert and drinks reception - LSO | 19 September 2017 | 2017-09-19 | Wendy Hyde 263 |
375 | 375 | Tickets to LSO concert and drinks reception - LSO | 21 December 2017 | 2017-12-21 | Wendy Hyde 263 |
376 | 376 | Dinner at the Walbrook Club as guests of Tenacity Group | 20th November 2018 | 2018-11-20 | Mark Bostock 1958 |
377 | 377 | Guest at the Broderers' Company banquet | 7th October 2015 | 2015-10-07 | Timothy Russell Hailes 1260 |
378 | 378 | Guest at Glass Sellers' Company banquet | 12th October 2015 | 2015-10-12 | Timothy Russell Hailes 1260 |
379 | 379 | Guest at Business Faculty Dinner, Goodenough College | 10th February 2016 | 2016-02-10 | Timothy Russell Hailes 1260 |
380 | 380 | Guest at banquet, Loriners Company | 13th May 2016 | 2016-05-13 | Timothy Russell Hailes 1260 |
381 | 381 | Guest at banquet, Guild of Young Freemen | 27th May 2016 | 2016-05-27 | Timothy Russell Hailes 1260 |
382 | 382 | Guest at banquet, Girdlers Company | 9th June 2016 | 2016-06-09 | Timothy Russell Hailes 1260 |
383 | 383 | Guest at banquet, Young Presidents Organisation | 9th September 2016 | 2016-09-09 | Timothy Russell Hailes 1260 |
384 | 384 | Guest at banquet, Guildable Manor of Southwark | 15th September 2016 | 2016-09-15 | Timothy Russell Hailes 1260 |
385 | 385 | Guest at banquet, Plaisterers Company | 4th October 2016 | 2016-10-04 | Timothy Russell Hailes 1260 |
386 | 386 | Guest at banquet, Marketors Company | 22nd October 2016 | 2016-10-22 | Timothy Russell Hailes 1260 |
387 | 387 | Guest at banquet, Tobacco Pipe Makers Company | 24th October 2016 | 2016-10-24 | Timothy Russell Hailes 1260 |
388 | 388 | Guest at banquet, Plaisterers Company | 10th January 2017 | 2017-01-10 | Timothy Russell Hailes 1260 |
389 | 389 | Guest at banquet, Business Faculty Dinner, Goodenough College | 8th February 2017 | 2017-02-08 | Timothy Russell Hailes 1260 |
390 | 390 | Guest at luncheon, Salters Company - | 2nd March 2017 | 2017-03-02 | Timothy Russell Hailes 1260 |
391 | 391 | Dinner guest - C&C Alpha Group | 23rd September 2017 | 2017-09-23 | Timothy Russell Hailes 1260 |
392 | 392 | Dinner guest - Worshipful Company of Security Professionals | 21st September 2017 | 2017-09-21 | Timothy Russell Hailes 1260 |
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 |
395 | 395 | Membership - Number Twenty client space, Grosvenor Street, London (KPMG) | 28th March 2018 | 2018-03-28 | Timothy Russell Hailes 1260 |
396 | 396 | Dinner guest - Dr Chanchai of Reignwood, Ten Trinity Square. Two bottles of Chateau Siaurac pomerol wine received. | 13th May 2018 | 2018-05-13 | Timothy Russell Hailes 1260 |
397 | 397 | Lunch - Senior Trade and Investment Commissioner, Austrade (Austrade) | 7th August 2018 | 2018-08-07 | Timothy Russell Hailes 1260 |
398 | 398 | LSO - Concert Ticket & Drinks | 24 September 2017 | 2017-09-24 | Jeremy Lewis Simons 384 |
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 |
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 |
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");