gifts

Gifts of Hospitality in the Register of Interests.

date_str is the date as supplied in the Register, and date is an attempt to create a year-month-day date from that string.

Data source: See col-scraper on GitHub

575 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ name date_str date member_id
201 201 Poulters Company Dinner 4 November 2015 2015-11-04 John George Stewart Scott 401
202 202 Royal Shakespeare Company - two tickets to Henry V and a Reception for my wife and myself 30 November 2015 2015-11-30 John George Stewart Scott 401
203 203 Reception, Dinner and accommodation at Leeds Castle from The Royal Navy & Royal Marines Children's Fund 20th - 21st May 2016 2016-05-20 John George Stewart Scott 401
204 204 The Patron’s Lunch, The Mall from The Royal Navy & Royal Marines Children's Fund 12th June 2016 2016-06-12 John George Stewart Scott 401
205 205 Reception - Royal Mail Group 6th September 2016 2016-09-06 John George Stewart Scott 401
206 206 Reception and Concert - LSO 20th September 2016 2016-09-20 John George Stewart Scott 401
207 207 Invitation to attend a Reception at the residence of His Excellency the Ambassador of the Russian Federation, for my wife and myself. 8th November 2016 2016-11-08 John George Stewart Scott 401
208 208 The Worshipful Company of Poulters Court Dinner at the House of Lords 25th November 2016 2016-11-25 John George Stewart Scott 401
209 209 Dinner at the Caledonian Club given by Scotscare 30th November 2016 2016-11-30 John George Stewart Scott 401
210 210 London Schools Symphony Orchestra concert at the Barbican 5 January 2017 2017-01-05 John George Stewart Scott 401
211 211 Dinner at the Worshipful Company of Fishmongers 1 March 2017 2017-03-01 John George Stewart Scott 401
212 212 Dinner at The Worshipful Company of Cooks, Wednesday 10th May 2017. 10 May 2017 2017-05-10 John George Stewart Scott 401
213 213 Reception at the House of Lords, University of Stirling, 11 May 2017 2017-05-11 John George Stewart Scott 401
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
215 215 Reception at The Postal Museum for my wife and myself 28 June 2017 2017-06-28 John George Stewart Scott 401
216 216 The Worshipful Company of Mercers - Gresham Dinner 14 November 2017 2017-11-14 John George Stewart Scott 401
217 217 Gresham College Stakeholder Presentation & Dinner (Worshipful Company of Mercers) 22 February 2018 2018-02-22 John George Stewart Scott 401
218 218 Dinner, University of Greenwich 14 July 2015 2015-07-14 Sir David Hugh Wootton 397
219 219 Dinner, Institute of Directors 16 September 2015 2015-09-16 Sir David Hugh Wootton 397
220 220 Dinner, Young Presidents’ Organisation 25 September 2015 2015-09-25 Sir David Hugh Wootton 397
221 221 Dinner, Association of Financial Markets in Europe 15 October 2015 2015-10-15 Sir David Hugh Wootton 397
222 222 Dinner, the Worshipful Company of Tin Plate Workers alias Wire Workers 5 July 2016 2016-07-05 Sir David Hugh Wootton 397
223 223 Dinner, Institute of Directors 14 July 2016 2016-07-14 Sir David Hugh Wootton 397
224 224 Dinner, Royal Military Academy, Sandhurst 2 August 2016 2016-08-02 Sir David Hugh Wootton 397
225 225 Dinner, Chartered Bankers Institute 1 September 2016 2016-09-01 Sir David Hugh Wootton 397
226 226 Dinner, Association of Financial Markets in Europe 3 November 2016 2016-11-03 Sir David Hugh Wootton 397
227 227 Reception and Dinner, Co-operation Ireland 8 November 2016 2016-11-08 Sir David Hugh Wootton 397
228 228 Dinner, The Worshipful Company of Wheelwrights 8 December 2016 2016-12-08 Sir David Hugh Wootton 397
229 229 Dinner, Classics for All 26 January 2017 2017-01-26 Sir David Hugh Wootton 397
230 230 Dinner, The Worshipful Company of Clothworkers 7 March 2017 2017-03-07 Sir David Hugh Wootton 397
231 231 Dinner, Remenham Club 21 April 2017 2017-04-21 Sir David Hugh Wootton 397
232 232 Gresham College Stakeholder Presentation & Dinner (Worshipful Company of Mercers) 22 February 2018 2018-02-22 Sir David Hugh Wootton 397
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
234 234 Annual Budget Banquet - Worshipful Company of Tax Advisers 7 March 2018 2018-03-07 James de Sausmarez 1658
235 235 Champagne reception and Dinner - Honourable Societies of the Inner Temple and Middle Temple 14 May 2015 2015-05-14 Catherine McGuinness 373
236 236 Dinner hosted by the London Symphony Orchestra 9 June 2015 2015-06-09 Catherine McGuinness 373
237 237 Exhibition and Reception – Museum of London in Docklands 18 June 2015 2015-06-18 Catherine McGuinness 373
238 238 Dinner – Future First – House of Lords 22 July 2015 2015-07-22 Catherine McGuinness 373
239 239 Two tickets and reception, LSO season opening concert (London Symphony Orchestra) 15 September 2015 2015-09-15 Catherine McGuinness 373
240 240 Guest of the BBC at the Proms and of Askonas Holt at a private dinner 11 September 2015 2015-09-11 Catherine McGuinness 373
241 241 Guest of LSO at gala dinner at Mansion House 27 June 2016 2016-06-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
243 243 Guest of Quiller Consultants - Lunch with Damian Green MP 14 November 2016 2016-11-14 Catherine McGuinness 373
244 244 Reception and Tickets (x3) to Royal Shakespeare Company performance of King Lear at the Barbican Centre 6 December 2016 2016-12-06 Catherine McGuinness 373
245 245 Editorial Intelligence Networking Nations Lecture and Dinner 16 January 2017 2017-01-16 Catherine McGuinness 373
246 246 Westminster Policy Institute No.10 Breakfast on Responsible Business and Corporate Governance 17 January 2017 2017-01-17 Catherine McGuinness 373
247 247 Dinner and Hotel Accommodation for self and husband provided by Derry-Londonderry Inner City Trust 3-5 February 2017 2017-02-05 Catherine McGuinness 373
248 248 Guest of EY [Lunch] 13 February 2017 2017-02-13 Catherine McGuinness 373
249 249 Guest of Flint Global [Lunch] 22 February 2017 2017-02-22 Catherine McGuinness 373
250 250 Guest of Latvian Ambassador [Dinner] 6 March 2017 2017-03-06 Catherine McGuinness 373
251 251 Double Invitation, Goodenough College Law Faculty Dinner 7 March 2017 2017-03-07 Catherine McGuinness 373
252 252 Guest of the Goldsmiths' Company [Lunch] 10 March 2017 2017-03-10 Catherine McGuinness 373
253 253 Guest of WIG [Lunch] 6 April 2017 2017-04-06 Catherine McGuinness 373
254 254 Guest of Strand Group [Drinks and Dinner] 2 May 2017 2017-05-02 Catherine McGuinness 373
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
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
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
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
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
270 270 Guest of CBI [Presidents' Dinner] 3 July 2017 2017-07-03 Catherine McGuinness 373
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
273 273 Guest of Citi Group dinner at Conservative Party Conference 1 October 2017 2017-10-01 Catherine McGuinness 373
274 274 Guest of the Law Society dinner 5 October 2017 2017-10-05 Catherine McGuinness 373
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
277 277 Guest of Sir David Wright, Barclays 14 November 2017 2017-11-14 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
279 279 Guest of TheCityUK at TheCityUK Annual Dinner 5 December 2017 2017-12-05 Catherine McGuinness 373
280 280 Guest of the Financial Times at drinks reception 11 December 2017 2017-12-11 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
282 282 Guest of the Irish Embassy for dinner 13 December 2017 2017-12-13 Catherine McGuinness 373
283 283 Guest of Kings College (Tony Halmos) for lunch 19 December 2017 2017-12-19 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
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
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
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
288 288 CD and Book from Reignwood Group 13 February 2018 2018-02-13 Catherine McGuinness 373
289 289 Guest of the ABI at the ABI Annual Dinner 26 February 2018 2018-02-26 Catherine McGuinness 373
290 290 Guest of HSBC at the HSBC Chinese New Year Lunch 27 February 2018 2018-02-27 Catherine McGuinness 373
291 291 Gresham College Stakeholder Presentation & Dinner (Worshipful Company of Mercers) 22 February 2018 2018-02-22 Catherine McGuinness 373
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
294 294 Guest of London First and CBRE at a dinner at MIPIM 14 March 2018 2018-03-14 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
296 296 Guest of London and Partners at Promotion of London Lunch 27 April 2018 2018-04-27 Catherine McGuinness 373
297 297 Guest of Association of Foreign Banks Lunch 22 May 2018 2018-05-22 Catherine McGuinness 373
298 298 Guest of Confederation of British Industry Dinner 22 May 2018 2018-05-22 Catherine McGuinness 373
299 299 Guest of City and Financial for Breakfast with Chief Executive 19 September 2018 2018-09-19 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

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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");