gifts
Data source: See col-scraper on GitHub
575 rows sorted by date descending
This data as json, CSV (advanced)
Link | rowid | name | date_str | date ▲ | member_id |
---|---|---|---|---|---|
296 | 296 | Guest of London and Partners at Promotion of London Lunch | 27 April 2018 | 2018-04-27 | Catherine McGuinness 373 |
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 |
169 | 169 | Dinner (with a guest), Worshipful Company of Spectacle Makers (guest of Felicity Harding) | 25 April 2018 | 2018-04-25 | Sheriff Vincent Thomas Keaveny 1395 |
328 | 328 | Saddlers’ Company lunch (with wife) | 24 April 2018 | 2018-04-24 | Nicholas Michael Bensted-Smith 1472 |
365 | 365 | Saddlers’ Company lunch (with husband) | 24 April 2018 | 2018-04-24 | Tijs Broeke 1954 |
168 | 168 | Dinner, Worshipful Company of Fletchers (guest of Clare James CC) | 17 April 2018 | 2018-04-17 | Sheriff Vincent Thomas Keaveny 1395 |
166 | 166 | Lunch, Worshipful Company of Loriners (guest of Nicholas Bensted-Smith CC) | 12 April 2018 | 2018-04-12 | Sheriff Vincent Thomas Keaveny 1395 |
167 | 167 | Dinner, Worshipful Company of Makers of Playing Cards | 12 April 2018 | 2018-04-12 | Sheriff Vincent Thomas Keaveny 1395 |
165 | 165 | Dinner, Worshipful Company of Gardeners (guest of William Fraser) | 3 April 2018 | 2018-04-03 | Sheriff Vincent Thomas Keaveny 1395 |
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 |
395 | 395 | Membership - Number Twenty client space, Grosvenor Street, London (KPMG) | 28th March 2018 | 2018-03-28 | Timothy Russell Hailes 1260 |
39 | 39 | Mounted brass plaque from the Managing Director, The Cook & Butler Event Company Ltd. | 26 March 2018 | 2018-03-26 | Edward Lord 292 |
489 | 489 | Rugby Match and lunch x2, CME Group | 24 March 2018 | 2018-03-24 | Sir Mark Boleat 136 |
41 | 41 | Dinner - guest of Inner Temple | 22 March 2018 | 2018-03-22 | Edward Lord 292 |
164 | 164 | Dinner, Worshipful Company of Drapers | 21 March 2018 | 2018-03-21 | Sheriff Vincent Thomas Keaveny 1395 |
488 | 488 | Dinner with the French Ambassador | 21 March 2018 | 2018-03-21 | Sir Mark Boleat 136 |
163 | 163 | Lunch, Worshipful Company of Masons | 20 March 2018 | 2018-03-20 | Sheriff Vincent Thomas Keaveny 1395 |
38 | 38 | Hard copy book entitled "Legal Architecture" by Linda Mulcahy [value £110] given by the Subtreasurer of Inner Temple to Deputy Lord by virtue of his position as Deputy Chairmen of Capital Buildings Committee | 16 March 2018 | 2018-03-16 | Edward Lord 292 |
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 |
350 | 350 | Guest of London Chamber of Commerce at a Presidents Lunch at MIPIM | 14 March 2018 | 2018-03-14 | Christopher Michael Hayward 1218 |
292 | 292 | Guest of CPA and WPA at a lunch at MIPIM | 13 March 2018 | 2018-03-13 | Catherine McGuinness 373 |
293 | 293 | Guest of CBRE at a dinner at MIPIM | 13 March 2018 | 2018-03-13 | Catherine McGuinness 373 |
349 | 349 | Guest of KPMG at Dinner at Plage l'Ondine at MIPIM | 13 March 2018 | 2018-03-13 | Christopher Michael Hayward 1218 |
162 | 162 | Dinner, Worshipful Company of Cordwainers (guest of Ann Holmes CC) | 9 March 2018 | 2018-03-09 | Sheriff Vincent Thomas Keaveny 1395 |
40 | 40 | Livery Dinner - Haberdasher's Company | 08 March 2018 | 2018-03-08 | Edward Lord 292 |
364 | 364 | Dinner at Worshipful Company of Haberdashers | 8 March 2018 | 2018-03-08 | Tijs Broeke 1954 |
234 | 234 | Annual Budget Banquet - Worshipful Company of Tax Advisers | 7 March 2018 | 2018-03-07 | James de Sausmarez 1658 |
487 | 487 | City Debate and dinner, Centre for the Study of Financial Innovation | 6 March 2018 | 2018-03-06 | Sir Mark Boleat 136 |
37 | 37 | Royal Box football ticket and hospitality - guest of Tottenham Hotspurs | 28 February 2018 | 2018-02-28 | Edward Lord 292 |
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 |
290 | 290 | Guest of HSBC at the HSBC Chinese New Year Lunch | 27 February 2018 | 2018-02-27 | Catherine McGuinness 373 |
486 | 486 | Livery Dinner, Worshipful Company of International Bankers | 27 February 2018 | 2018-02-27 | Sir Mark Boleat 136 |
289 | 289 | Guest of the ABI at the ABI Annual Dinner | 26 February 2018 | 2018-02-26 | Catherine McGuinness 373 |
36 | 36 | Gresham Dinner - guest of the Mercers' Company | 22 February 2018 | 2018-02-22 | Edward Lord 292 |
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 |
161 | 161 | Dinner, Worshipful Company of World Traders | 22 February 2018 | 2018-02-22 | Sheriff Vincent Thomas Keaveny 1395 |
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 |
412 | 412 | Together with my wife, I was invited to the Kuwait National Day Lunchtime Reception, which my wife attended. It was held at the Dorchester hotel W1. | 22 Feb 2018 | 2018-02-22 | Ian David Luder 296 |
413 | 413 | Gresham College Stakeholder Presentation & Dinner (Worshipful Company of Mercers). | 22 Feb 2018 | 2018-02-22 | Ian David Luder 296 |
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 |
159 | 159 | Lunch, Worshipful Company of Information Technologists | 21 February 2018 | 2018-02-21 | Sheriff Vincent Thomas Keaveny 1395 |
160 | 160 | Faculty Dinner (with a guest), Goodenough College | 21 February 2018 | 2018-02-21 | Sheriff Vincent Thomas Keaveny 1395 |
288 | 288 | CD and Book from Reignwood Group | 13 February 2018 | 2018-02-13 | Catherine McGuinness 373 |
347 | 347 | Lunch with Harrry Haddad, Harry’s Bar, Ironmonger Lane, EC2V 8EP | 13 February 2018 | 2018-02-13 | Christopher Michael Hayward 1218 |
158 | 158 | Lunch, Worshipful Company of Founders | 7 February 2018 | 2018-02-07 | Sheriff Vincent Thomas Keaveny 1395 |
346 | 346 | Lunch - Richard Desmond (Northern & Shell PLC) | 2nd February 2018 | 2018-02-02 | Christopher Michael Hayward 1218 |
157 | 157 | Dinner (with a guest), Co-operation Ireland (guest of Dr Christopher Moran) | 1 February 2018 | 2018-02-01 | Sheriff Vincent Thomas Keaveny 1395 |
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 |
156 | 156 | Dinner, Worshipful Company of Marketors | 25 January 2018 | 2018-01-25 | Sheriff Vincent Thomas Keaveny 1395 |
155 | 155 | Lunch, Worshipful Company of Plumbers (guest of Christopher Hill CC) | 24 January 2018 | 2018-01-24 | Sheriff Vincent Thomas Keaveny 1395 |
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 |
490 | 490 | Two tickets to RSC performance of Julius Caesar - Barbican Centre | 15th January 2018 | 2018-01-15 | Andrew Paul Mayer 1945 |
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 |
375 | 375 | Tickets to LSO concert and drinks reception - LSO | 21 December 2017 | 2017-12-21 | Wendy Hyde 263 |
180 | 180 | Christmas a 75cl bottle of Canti Prosecco from Spice Innovations Limited | 19th December 2017 | 2017-12-19 | Dhruv Patel 1224 |
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 |
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 |
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 |
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 |
151 | 151 | Duke of Edinburgh's Award Trustees Dinner (guest of Patricia Teahan) | 28 November 2017 | 2017-11-28 | Sheriff Vincent Thomas Keaveny 1395 |
150 | 150 | Dinner, Worshipful Company of Stationers (guest of Tom Corrigan) | 22 November 2017 | 2017-11-22 | Sheriff Vincent Thomas Keaveny 1395 |
278 | 278 | Guest of Queen Mary's University, London for drinks reception and dinner | 15 November 2017 | 2017-11-15 | Catherine McGuinness 373 |
35 | 35 | Gresham Dinner - guest of the Mercers' Company | 14 November 2017 | 2017-11-14 | Edward Lord 292 |
57 | 57 | The Worshipful Company of Mercers - Gresham Dinner | 14 November 2017 | 2017-11-14 | Tom Hoffman 251 |
81 | 81 | Gresham Dinner, guest of the Mercers' Company | 14 November 2017 | 2017-11-14 | John Bennett 139 |
216 | 216 | The Worshipful Company of Mercers - Gresham Dinner | 14 November 2017 | 2017-11-14 | John George Stewart Scott 401 |
277 | 277 | Guest of Sir David Wright, Barclays | 14 November 2017 | 2017-11-14 | Catherine McGuinness 373 |
326 | 326 | The Worshipful Company of Mercers Gresham Dinner | 14 November 2017 | 2017-11-14 | Nicholas Michael Bensted-Smith 1472 |
345 | 345 | Gresham Dinner, guest of the Mercers' Company | 14 November 2017 | 2017-11-14 | Christopher Michael Hayward 1218 |
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 |
373 | 373 | Reception - Metrobank (to mark the opening of their new branch in Bishopsgate) | 14 November 2017 | 2017-11-14 | Wendy Hyde 263 |
394 | 394 | Dinner guest- The Worshipful Company of Mercers - Gresham | 14 November 2017 | 2017-11-14 | Timothy Russell Hailes 1260 |
411 | 411 | The Worshipful Company of Mercers Gresham Dinner. | 14 November 2017 | 2017-11-14 | Ian David Luder 296 |
418 | 418 | The Worshipful Company of Mercers - Gresham Dinner | 14 November 2017 | 2017-11-14 | Simon D'Olier Duckworth 151 |
424 | 424 | The Worshipful Company of Mercers Gresham Dinner | 14 November 2017 | 2017-11-14 | Charles Edward Beck Bowman 1261 |
440 | 440 | The Worshipful Company of Mercers Gresham Dinner | 14 November 2017 | 2017-11-14 | Professor Michael Raymond Mainelli 1323 |
563 | 563 | The Worshipful Company of Mercers - Gresham Dinner | 14 November 2017 | 2017-11-14 | Dr Giles Robert Evelyn Shilson 383 |
442 | 442 | Dinner guest - Poulters Company | 9th November 2017 | 2017-11-09 | James Richard Tumbridge 394 |
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 |
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 |
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");