gifts
Data source: See col-scraper on GitHub
575 rows sorted by rowid descending
This data as json, CSV (advanced)
Link | rowid ▲ | name | date_str | date | member_id |
---|---|---|---|---|---|
375 | 375 | Tickets to LSO concert and drinks reception - LSO | 21 December 2017 | 2017-12-21 | Wendy Hyde 263 |
374 | 374 | Tickets to LSO concert and drinks reception - LSO | 19 September 2017 | 2017-09-19 | Wendy Hyde 263 |
373 | 373 | Reception - Metrobank (to mark the opening of their new branch in Bishopsgate) | 14 November 2017 | 2017-11-14 | Wendy Hyde 263 |
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 | ||
371 | 371 | Lunch at Goldsmiths’ Company (Trial of the Pyx) | 3 May 2019 | 2019-05-03 | Tijs Broeke 1954 |
370 | 370 | Dinner at Chartered Secretaries and Administrators’ Company | 25 March 2019 | 2019-03-25 | Tijs Broeke 1954 |
369 | 369 | London Planning Awards (guest of The Tenacity Group) | 31 January 2019 | 2019-01-31 | 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 |
367 | 367 | Mercers’ Company dinner | 24 May 2018 | 2018-05-24 | Tijs Broeke 1954 |
366 | 366 | Goldsmiths’ Company lunch | 27 April 2018 | 2018-04-27 | Tijs Broeke 1954 |
365 | 365 | Saddlers’ Company lunch (with husband) | 24 April 2018 | 2018-04-24 | Tijs Broeke 1954 |
364 | 364 | Dinner at Worshipful Company of Haberdashers | 8 March 2018 | 2018-03-08 | Tijs Broeke 1954 |
363 | 363 | Associated Companies Dinner (Worshipful Company of Mercers) | 25 May 2017 | 2017-05-25 | Tijs Broeke 1954 |
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 |
361 | 361 | Dinner at the Walbrook Club as guest of Tenacity Group. | 20th November 2018 | 2018-11-20 | Christopher Hill 1942 |
360 | 360 | Liverpool v Bayern Munich - guest of Standard Chartered Bank, Anfield box | 19/02/2019 | 2019-02-19 | 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 |
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 |
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 |
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 | |
355 | 355 | Lunch with Chairman of Northern & Shell Plc | 7 January 2019 | 2019-01-07 | 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 |
353 | 353 | Guest of London and Oriental, lunch at The Ned | 4 September 2018 | 2018-09-04 | 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 |
351 | 351 | Guest of Christopher Moran Dinner at Crosby Hall | 16 May 2018 | 2018-05-16 | 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 |
349 | 349 | Guest of KPMG at Dinner at Plage l'Ondine at MIPIM | 13 March 2018 | 2018-03-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 |
347 | 347 | Lunch with Harrry Haddad, Harry’s Bar, Ironmonger Lane, EC2V 8EP | 13 February 2018 | 2018-02-13 | Christopher Michael Hayward 1218 |
346 | 346 | Lunch - Richard Desmond (Northern & Shell PLC) | 2nd February 2018 | 2018-02-02 | Christopher Michael Hayward 1218 |
345 | 345 | Gresham Dinner, guest of the Mercers' Company | 14 November 2017 | 2017-11-14 | 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 |
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 |
342 | 342 | Guest at lunch hosted by Richard Desmond (Northern & Shell plc) | 12th June 2017 | 2017-06-12 | 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 |
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 |
339 | 339 | Lunch at the Goring with Mike Hussey, Almacantar Ltd | 29 November 2016 | 2016-11-29 | 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 |
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 |
336 | 336 | 14 May 2015 – Reception and Dinner for City Magna Carta Charter | Michael Hudson 256 | ||
335 | 335 | Two tickets from British Police Symphony Orchestra for Charity Gala Concert on 11.05.19 | Douglas Barrow 128 | ||
334 | 334 | Dinner, District Attorney of New York - 16 November 2016 | Douglas Barrow 128 | ||
333 | 333 | Gresham College Stakeholder Presentation & Dinner (Worshipful Company of Mercers) | 22 February 2018 | 2018-02-22 | Jamie Ingham Clark 1223 |
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 | ||
331 | 331 | The Worshipful Company of Mercers Gresham Dinner | 13 November 2018 | 2018-11-13 | Nicholas Michael Bensted-Smith 1472 |
330 | 330 | Mercers’ Company dinner | 24 May 2018 | 2018-05-24 | Nicholas Michael Bensted-Smith 1472 |
329 | 329 | Goldsmiths’ Company lunch | 27 April 2018 | 2018-04-27 | Nicholas Michael Bensted-Smith 1472 |
328 | 328 | Saddlers’ Company lunch (with wife) | 24 April 2018 | 2018-04-24 | 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 |
326 | 326 | The Worshipful Company of Mercers Gresham Dinner | 14 November 2017 | 2017-11-14 | Nicholas Michael Bensted-Smith 1472 |
325 | 325 | Guest of Lord James Sassoon, Matheson & Co Lts [lunch] | 8 April 2019 | 2019-04-08 | Catherine McGuinness 373 |
324 | 324 | Guest of KPMG [lunch] | 25 March 2019 | 2019-03-25 | Catherine McGuinness 373 |
323 | 323 | Guest of Robinson Hambro [dinner] | 25 March 2019 | 2019-03-25 | 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 |
321 | 321 | Flowers from Swiss Embassy | 1 March 2019 | 2019-03-01 | Catherine McGuinness 373 |
320 | 320 | Guest of Andre Villeneuve, ICE Company | 1 March 2019 | 2019-03-01 | 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 |
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 |
317 | 317 | Received two books from High Commissioner of India | 9 January 2019 | 2019-01-09 | 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 |
315 | 315 | Guest of London Stock Exchange [Lunch] | 14 December 2018 | 2018-12-14 | Catherine McGuinness 373 |
314 | 314 | Guest of Law Society [Dinner] | 10 December 2018 | 2018-12-10 | Catherine McGuinness 373 |
313 | 313 | Guest of Labour Business [Dinner] | 6 December 2018 | 2018-12-06 | Catherine McGuinness 373 |
312 | 312 | Guest of Investment Association [Drinks Reception] | 5 December 2018 | 2018-12-05 | Catherine McGuinness 373 |
311 | 311 | Guest of Financial Markets Law Committee [Drinks Reception] | 5 December 2018 | 2018-12-05 | Catherine McGuinness 373 |
310 | 310 | Guest of Confederation of British Industry [Drinks Reception] | 3 December 2018 | 2018-12-03 | Catherine McGuinness 373 |
309 | 309 | Guest of Investment Association [Dinner in Washington] | 28 November 2018 | 2018-11-28 | Catherine McGuinness 373 |
308 | 308 | Guest of Institute of International Finance [Lunch in New York] | 27 November 2018 | 2018-11-27 | Catherine McGuinness 373 |
307 | 307 | Guest of Centre for European Reform [Ditchley Park Conference] | 16 November 2018 | 2018-11-16 | Catherine McGuinness 373 |
306 | 306 | Guest of European Financial Forum [Cumberland Lodge Conference] | 8-9 November 2018 | 2018-11-09 | Catherine McGuinness 373 |
305 | 305 | Guest of DLA Piper [Drinks Reception] | 6 November 2018 | 2018-11-06 | Catherine McGuinness 373 |
304 | 304 | Guest of PIMFA [Lunch] | 17 October 2018 | 2018-10-17 | Catherine McGuinness 373 |
303 | 303 | Guest of the Investment Association [Annual Dinner] | 16 October 2018 | 2018-10-16 | Catherine McGuinness 373 |
302 | 302 | Guest of TheCityUK [Dinner in Rome] | 11 October 2018 | 2018-10-11 | Catherine McGuinness 373 |
301 | 301 | Guest of International Bar Association [Lunch in Rome] | 11 October 2018 | 2018-10-11 | Catherine McGuinness 373 |
300 | 300 | Received Scotch Whisky from the Briefing Circle as a thank you for being the keynote speaker | 19 September 2018 | 2018-09-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 |
298 | 298 | Guest of Confederation of British Industry Dinner | 22 May 2018 | 2018-05-22 | Catherine McGuinness 373 |
297 | 297 | Guest of Association of Foreign Banks Lunch | 22 May 2018 | 2018-05-22 | Catherine McGuinness 373 |
296 | 296 | Guest of London and Partners at Promotion of London Lunch | 27 April 2018 | 2018-04-27 | Catherine McGuinness 373 |
295 | 295 | Guest of London Chamber of Commerce at a lunch on 'Build to Rent' at MIPIM | 15 March 2018 | 2018-03-15 | Catherine McGuinness 373 |
294 | 294 | Guest of London First and CBRE at a dinner at MIPIM | 14 March 2018 | 2018-03-14 | 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 |
291 | 291 | Gresham College Stakeholder Presentation & Dinner (Worshipful Company of Mercers) | 22 February 2018 | 2018-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 |
289 | 289 | Guest of the ABI at the ABI Annual Dinner | 26 February 2018 | 2018-02-26 | Catherine McGuinness 373 |
288 | 288 | CD and Book from Reignwood Group | 13 February 2018 | 2018-02-13 | Catherine McGuinness 373 |
287 | 287 | Guest of TheCityUK at TheCityUK Chairman's Dinner with the Rt Hon David Mundell MP (SoS for Scotland) | 31 January 2018 | 2018-01-31 | Catherine McGuinness 373 |
286 | 286 | Guest of Nicky Morgan MP when speaking at a reception and dinner at the House of Commons | 30 January 2018 | 2018-01-30 | Catherine McGuinness 373 |
285 | 285 | Guest of the Briefing Circle at a breakfast on "Planning for the future-seeking consensus and a positive relationship with Europe" | 15 January 2018 | 2018-01-15 | Catherine McGuinness 373 |
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 |
283 | 283 | Guest of Kings College (Tony Halmos) for lunch | 19 December 2017 | 2017-12-19 | Catherine McGuinness 373 |
282 | 282 | Guest of the Irish Embassy for dinner | 13 December 2017 | 2017-12-13 | 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 |
280 | 280 | Guest of the Financial Times at drinks reception | 11 December 2017 | 2017-12-11 | Catherine McGuinness 373 |
279 | 279 | Guest of TheCityUK at TheCityUK Annual Dinner | 5 December 2017 | 2017-12-05 | Catherine McGuinness 373 |
278 | 278 | Guest of Queen Mary's University, London for drinks reception and dinner | 15 November 2017 | 2017-11-15 | Catherine McGuinness 373 |
277 | 277 | Guest of Sir David Wright, Barclays | 14 November 2017 | 2017-11-14 | 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 |
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");