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 |
---|---|---|---|---|---|
231 | 231 | Dinner, Remenham Club | 21 April 2017 | 2017-04-21 | Sir David Hugh Wootton 397 |
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 |
254 | 254 | Guest of Strand Group [Drinks and Dinner] | 2 May 2017 | 2017-05-02 | Catherine McGuinness 373 |
139 | 139 | Worshipful Company of Information Technologists' 25th Anniversary Banquet, | 4 May 2017 | 2017-05-04 | Sheriff Vincent Thomas Keaveny 1395 |
479 | 479 | Livery Banquet (double invitation) Worshipful Company of Information Technologists | 4 May 2017 | 2017-05-04 | Sir Mark Boleat 136 |
480 | 480 | Dinner: Ten Trinity Square Private Club | 5 May 2017 | 2017-05-05 | Sir Mark Boleat 136 |
83 | 83 | Travel and accommodation costs to attend the Chengdu Innovation and Entrepreneurship Fair - Mayor of Chengdu | 7th - 15th May 2017 | 2017-05-07 | Wendy Mead 375 |
140 | 140 | Dinner, Worshipful Company of Cooks (guest of Mark Grove), | 10 May 2017 | 2017-05-10 | Sheriff Vincent Thomas Keaveny 1395 |
212 | 212 | Dinner at The Worshipful Company of Cooks, Wednesday 10th May 2017. | 10 May 2017 | 2017-05-10 | John George Stewart Scott 401 |
481 | 481 | Dinner: Reignwood | 10 May 2017 | 2017-05-10 | Sir Mark Boleat 136 |
213 | 213 | Reception at the House of Lords, University of Stirling, | 11 May 2017 | 2017-05-11 | John George Stewart Scott 401 |
22 | 22 | VIP courtside ticket and hospitality - British Basketball League and Women’s British Basketball League Finals, O2 Arena – British Basketball Federation | 14 May 2017 | 2017-05-14 | Edward Lord 292 |
141 | 141 | Dinner, Worshipful Society of Apothecaries | 16 May 2017 | 2017-05-16 | Sheriff Vincent Thomas Keaveny 1395 |
255 | 255 | Guest of CBI [Dinner] | 17 May 2017 | 2017-05-17 | Catherine McGuinness 373 |
256 | 256 | Guest of Sebastian Groth, deputy head of policy planning of the Federal Foreign Office and Frank Neumann Deputy Head of Economic Section/German Embassy [Lunch] | 18 May 2017 | 2017-05-18 | Catherine McGuinness 373 |
179 | 179 | Two tickets to the Asian Voice Charity Awards and Dinner at the London Hilton Park Lane from Pratik Dattani (Charity Clarity). | 19th May 2017 | 2017-05-19 | Dhruv Patel 1224 |
257 | 257 | Guest of Joanna Cound, Blackrock [Lunch] | 23 May 2017 | 2017-05-23 | Catherine McGuinness 373 |
258 | 258 | Guest of New Financial [Dinner] | 24 May 2017 | 2017-05-24 | Catherine McGuinness 373 |
363 | 363 | Associated Companies Dinner (Worshipful Company of Mercers) | 25 May 2017 | 2017-05-25 | Tijs Broeke 1954 |
437 | 437 | Concert and charity dinner at the Four Seasons Hotel London, 10 Trinity Square, London (Reignwood and Four Seasons) | 25th May 2017 | 2017-05-25 | Marianne Bernadette Fredericks 223 |
482 | 482 | Concert and Dinner with Reignwood | 25 May 2017 | 2017-05-25 | Sir Mark Boleat 136 |
483 | 483 | Hospitality at BMW Golf Championship with Reignwood | 28 May 2017 | 2017-05-28 | Sir Mark Boleat 136 |
259 | 259 | Guest of Mark Kleinman [Breakfast] | 1 June 2017 | 2017-06-01 | Catherine McGuinness 373 |
260 | 260 | Guest of Laura Citron, London & Partners [Lunch] | 2 June 2017 | 2017-06-02 | Catherine McGuinness 373 |
261 | 261 | Guest of TheCityUK for Media Dinner with Iain Dey [Dinner] | 6 June 2017 | 2017-06-06 | Catherine McGuinness 373 |
423 | 423 | Wooden bowl - received from the Governor of Western Australia | 6th June 2017 | 2017-06-06 | Charles Edward Beck Bowman 1261 |
23 | 23 | 2 x Box tickets for Take That concert, O2 Arena – Grange Hotels Limited | 11 June 2017 | 2017-06-11 | Edward Lord 292 |
142 | 142 | Lime Street & Cornhill Ward Club Civic Luncheon (with a guest) | 12 June 2017 | 2017-06-12 | Sheriff Vincent Thomas Keaveny 1395 |
262 | 262 | Guest of Sherard Cowper-Coles, HSBC [Breakfast] | 12 June 2017 | 2017-06-12 | Catherine McGuinness 373 |
263 | 263 | Guest of Strand Group [Drinks] | 12 June 2017 | 2017-06-12 | Catherine McGuinness 373 |
342 | 342 | Guest at lunch hosted by Richard Desmond (Northern & Shell plc) | 12th June 2017 | 2017-06-12 | Christopher Michael Hayward 1218 |
214 | 214 | Reception at the residence of the Ambassador of the Russian Federation for my wife and myself. | 13 June 2017 | 2017-06-13 | John George Stewart Scott 401 |
484 | 484 | Royal Academy Summer Exhibition and reception (double invitation), BNY Mellon. | 13 June 2017 | 2017-06-13 | Sir Mark Boleat 136 |
264 | 264 | Guest of City Women: Future Leaders Award Celebration | 19 June 2017 | 2017-06-19 | Catherine McGuinness 373 |
265 | 265 | Guest of Clifford Chance [Lunch] | 20 June 2017 | 2017-06-20 | Catherine McGuinness 373 |
266 | 266 | Guest of Education Policy Institute [Drinks] | 20 June 2017 | 2017-06-20 | Catherine McGuinness 373 |
267 | 267 | Guest of Investment Association [Dinner] | 22 June 2017 | 2017-06-22 | Catherine McGuinness 373 |
268 | 268 | Guest of Maurice Button, City and Financial [Breakfast] | 22 June 2017 | 2017-06-22 | Catherine McGuinness 373 |
269 | 269 | Guest of the French Embassy [Dinner] | 26 June 2017 | 2017-06-26 | Catherine McGuinness 373 |
215 | 215 | Reception at The Postal Museum for my wife and myself | 28 June 2017 | 2017-06-28 | John George Stewart Scott 401 |
270 | 270 | Guest of CBI [Presidents' Dinner] | 3 July 2017 | 2017-07-03 | Catherine McGuinness 373 |
24 | 24 | Garden Party (with guest) – Middle Temple | 4 July 2017 | 2017-07-04 | 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 |
143 | 143 | Summer Party, Crosby Hall (guest of Dr Christopher Moran) | 6 July 2017 | 2017-07-06 | Sheriff Vincent Thomas Keaveny 1395 |
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 |
565 | 565 | Dinner guest - Disappearing Dining Club, 24-26 Newbury Street London EC1A 7HU | 20th July 2017 | 2017-07-20 | Ann Holmes 1230 |
26 | 26 | VIP tickets and hospitality – IPC World Para Athletics World Championships, London Stadium – London 2017 Limited | 21 July 2017 | 2017-07-21 | Edward Lord 292 |
27 | 27 | VIP hospitality – Great City Race – London Marathon Limited | 24 July 2017 | 2017-07-24 | Edward Lord 292 |
28 | 28 | Reception and Tour, Westminster Abbey – London & Partners | 28 July 2017 | 2017-07-28 | Edward Lord 292 |
29 | 29 | VIP hospitality (not taken) – Ride London, Mall – London Marathon Limited | 29/30 July 2017 | 2017-07-29 | Edward Lord 292 |
30 | 30 | VIP ticket and hospitality – IAAF World Athletics Championships, London Stadium – London 2017 Limited | 6 August 2017 | 2017-08-06 | Edward Lord 292 |
31 | 31 | VIP ticket and hospitality – IAAF World Athletics Championships, London Stadium – London 2017 Limited | 11 August 2017 | 2017-08-11 | Edward Lord 292 |
32 | 32 | VIP tickets and hospitality – Great Britain v Greece, Copper Box – British Basketball Federation | 19 August 2017 | 2017-08-19 | Edward Lord 292 |
271 | 271 | Received book of photos worth approximately £50 from the Government of Malta | 29 August 2017 | 2017-08-29 | Catherine McGuinness 373 |
272 | 272 | Guest of Canary Wharf Group Lunch | 5 September 2017 | 2017-09-05 | Catherine McGuinness 373 |
374 | 374 | Tickets to LSO concert and drinks reception - LSO | 19 September 2017 | 2017-09-19 | Wendy Hyde 263 |
233 | 233 | Installation dinner of the Master of the Worshipful Company of Tax Advisers | Thursday 21 September 2017 | 2017-09-21 | James de Sausmarez 1658 |
392 | 392 | Dinner guest - Worshipful Company of Security Professionals | 21st September 2017 | 2017-09-21 | Timothy Russell Hailes 1260 |
144 | 144 | Dinner, Worshipful Company of Educators (guest of David O'Reilly) | 22 September 2017 | 2017-09-22 | Sheriff Vincent Thomas Keaveny 1395 |
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 |
391 | 391 | Dinner guest - C&C Alpha Group | 23rd September 2017 | 2017-09-23 | Timothy Russell Hailes 1260 |
425 | 425 | Dinner and gift of a leather travel wallet at the Guildhall for the C & C Alpha Group Limited | 23 September 2017 | 2017-09-23 | Keith David Forbes Bottomley 1666 |
398 | 398 | LSO - Concert Ticket & Drinks | 24 September 2017 | 2017-09-24 | Jeremy Lewis Simons 384 |
393 | 393 | Dinner guest -The Honourable Society of the Middle and Inner Temple | 25th September 2017 | 2017-09-25 | Timothy Russell Hailes 1260 |
273 | 273 | Guest of Citi Group dinner at Conservative Party Conference | 1 October 2017 | 2017-10-01 | Catherine McGuinness 373 |
145 | 145 | Dinner, Worshipful Company of Plaisterers (guest of Bryan Lincoln) | 3 October 2017 | 2017-10-03 | Sheriff Vincent Thomas Keaveny 1395 |
274 | 274 | Guest of the Law Society dinner | 5 October 2017 | 2017-10-05 | Catherine McGuinness 373 |
146 | 146 | Dinner, Worshipful Company of Wheelwrights (guest of Alan Culverhouse) | 12 October 2017 | 2017-10-12 | Sheriff Vincent Thomas Keaveny 1395 |
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 |
33 | 33 | Gala Dinner - guest of Albert Kennedy Trust | 19 October 2017 | 2017-10-19 | Edward Lord 292 |
147 | 147 | Dinner (with a guest), Worshipful Company of Upholders (guest of Judy Tayler-Smith) | 26 October 2017 | 2017-10-26 | Sheriff Vincent Thomas Keaveny 1395 |
148 | 148 | British And Irish Trading Alliance lunch | 27 October 2017 | 2017-10-27 | Sheriff Vincent Thomas Keaveny 1395 |
410 | 410 | Attended, together with my wife, an early evening reception at the Turkish Embassy, to celebrate anniversary of the foundation of the Republic. | 30 October 2017 | 2017-10-30 | Ian David Luder 296 |
34 | 34 | Walbrook Club Port Dinner - guest of Colin Hart JP | 2 November 2017 | 2017-11-02 | Edward Lord 292 |
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 |
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 |
442 | 442 | Dinner guest - Poulters Company | 9th November 2017 | 2017-11-09 | James Richard Tumbridge 394 |
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 |
278 | 278 | Guest of Queen Mary's University, London for drinks reception and dinner | 15 November 2017 | 2017-11-15 | Catherine McGuinness 373 |
150 | 150 | Dinner, Worshipful Company of Stationers (guest of Tom Corrigan) | 22 November 2017 | 2017-11-22 | Sheriff Vincent Thomas Keaveny 1395 |
151 | 151 | Duke of Edinburgh's Award Trustees Dinner (guest of Patricia Teahan) | 28 November 2017 | 2017-11-28 | Sheriff Vincent Thomas Keaveny 1395 |
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 |
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 |
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 |
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");