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

91 rows where member_id = 373

View and edit SQL

Suggested facets: date (date)

Link rowid ▼ name date_str date member_id
235 Champagne reception and Dinner - Honourable Societies of the Inner Temple and Middle Temple 14 May 2015 2015-05-14 Catherine McGuinness 373
236 Dinner hosted by the London Symphony Orchestra 9 June 2015 2015-06-09 Catherine McGuinness 373
237 Exhibition and Reception – Museum of London in Docklands 18 June 2015 2015-06-18 Catherine McGuinness 373
238 Dinner – Future First – House of Lords 22 July 2015 2015-07-22 Catherine McGuinness 373
239 Two tickets and reception, LSO season opening concert (London Symphony Orchestra) 15 September 2015 2015-09-15 Catherine McGuinness 373
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 Guest of LSO at gala dinner at Mansion House 27 June 2016 2016-06-27 Catherine McGuinness 373
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 Guest of Quiller Consultants - Lunch with Damian Green MP 14 November 2016 2016-11-14 Catherine McGuinness 373
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 Editorial Intelligence Networking Nations Lecture and Dinner 16 January 2017 2017-01-16 Catherine McGuinness 373
246 Westminster Policy Institute No.10 Breakfast on Responsible Business and Corporate Governance 17 January 2017 2017-01-17 Catherine McGuinness 373
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 Guest of EY [Lunch] 13 February 2017 2017-02-13 Catherine McGuinness 373
249 Guest of Flint Global [Lunch] 22 February 2017 2017-02-22 Catherine McGuinness 373
250 Guest of Latvian Ambassador [Dinner] 6 March 2017 2017-03-06 Catherine McGuinness 373
251 Double Invitation, Goodenough College Law Faculty Dinner 7 March 2017 2017-03-07 Catherine McGuinness 373
252 Guest of the Goldsmiths' Company [Lunch] 10 March 2017 2017-03-10 Catherine McGuinness 373
253 Guest of WIG [Lunch] 6 April 2017 2017-04-06 Catherine McGuinness 373
254 Guest of Strand Group [Drinks and Dinner] 2 May 2017 2017-05-02 Catherine McGuinness 373
255 Guest of CBI [Dinner] 17 May 2017 2017-05-17 Catherine McGuinness 373
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 Guest of Joanna Cound, Blackrock [Lunch] 23 May 2017 2017-05-23 Catherine McGuinness 373
258 Guest of New Financial [Dinner] 24 May 2017 2017-05-24 Catherine McGuinness 373
259 Guest of Mark Kleinman [Breakfast] 1 June 2017 2017-06-01 Catherine McGuinness 373
260 Guest of Laura Citron, London & Partners [Lunch] 2 June 2017 2017-06-02 Catherine McGuinness 373
261 Guest of TheCityUK for Media Dinner with Iain Dey [Dinner] 6 June 2017 2017-06-06 Catherine McGuinness 373
262 Guest of Sherard Cowper-Coles, HSBC [Breakfast] 12 June 2017 2017-06-12 Catherine McGuinness 373
263 Guest of Strand Group [Drinks] 12 June 2017 2017-06-12 Catherine McGuinness 373
264 Guest of City Women: Future Leaders Award Celebration 19 June 2017 2017-06-19 Catherine McGuinness 373
265 Guest of Clifford Chance [Lunch] 20 June 2017 2017-06-20 Catherine McGuinness 373
266 Guest of Education Policy Institute [Drinks] 20 June 2017 2017-06-20 Catherine McGuinness 373
267 Guest of Investment Association [Dinner] 22 June 2017 2017-06-22 Catherine McGuinness 373
268 Guest of Maurice Button, City and Financial [Breakfast] 22 June 2017 2017-06-22 Catherine McGuinness 373
269 Guest of the French Embassy [Dinner] 26 June 2017 2017-06-26 Catherine McGuinness 373
270 Guest of CBI [Presidents' Dinner] 3 July 2017 2017-07-03 Catherine McGuinness 373
271 Received book of photos worth approximately £50 from the Government of Malta 29 August 2017 2017-08-29 Catherine McGuinness 373
272 Guest of Canary Wharf Group Lunch 5 September 2017 2017-09-05 Catherine McGuinness 373
273 Guest of Citi Group dinner at Conservative Party Conference 1 October 2017 2017-10-01 Catherine McGuinness 373
274 Guest of the Law Society dinner 5 October 2017 2017-10-05 Catherine McGuinness 373
275 Wine and salt from the Ambassador of Slovenia to the UK 6 November 2017 2017-11-06 Catherine McGuinness 373
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 Guest of Sir David Wright, Barclays 14 November 2017 2017-11-14 Catherine McGuinness 373
278 Guest of Queen Mary's University, London for drinks reception and dinner 15 November 2017 2017-11-15 Catherine McGuinness 373
279 Guest of TheCityUK at TheCityUK Annual Dinner 5 December 2017 2017-12-05 Catherine McGuinness 373
280 Guest of the Financial Times at drinks reception 11 December 2017 2017-12-11 Catherine McGuinness 373
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 Guest of the Irish Embassy for dinner 13 December 2017 2017-12-13 Catherine McGuinness 373
283 Guest of Kings College (Tony Halmos) for lunch 19 December 2017 2017-12-19 Catherine McGuinness 373
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 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 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 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 CD and Book from Reignwood Group 13 February 2018 2018-02-13 Catherine McGuinness 373
289 Guest of the ABI at the ABI Annual Dinner 26 February 2018 2018-02-26 Catherine McGuinness 373
290 Guest of HSBC at the HSBC Chinese New Year Lunch 27 February 2018 2018-02-27 Catherine McGuinness 373
291 Gresham College Stakeholder Presentation & Dinner (Worshipful Company of Mercers) 22 February 2018 2018-02-22 Catherine McGuinness 373
292 Guest of CPA and WPA at a lunch at MIPIM 13 March 2018 2018-03-13 Catherine McGuinness 373
293 Guest of CBRE at a dinner at MIPIM 13 March 2018 2018-03-13 Catherine McGuinness 373
294 Guest of London First and CBRE at a dinner at MIPIM 14 March 2018 2018-03-14 Catherine McGuinness 373
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 Guest of London and Partners at Promotion of London Lunch 27 April 2018 2018-04-27 Catherine McGuinness 373
297 Guest of Association of Foreign Banks Lunch 22 May 2018 2018-05-22 Catherine McGuinness 373
298 Guest of Confederation of British Industry Dinner 22 May 2018 2018-05-22 Catherine McGuinness 373
299 Guest of City and Financial for Breakfast with Chief Executive 19 September 2018 2018-09-19 Catherine McGuinness 373
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
301 Guest of International Bar Association [Lunch in Rome] 11 October 2018 2018-10-11 Catherine McGuinness 373
302 Guest of TheCityUK [Dinner in Rome] 11 October 2018 2018-10-11 Catherine McGuinness 373
303 Guest of the Investment Association [Annual Dinner] 16 October 2018 2018-10-16 Catherine McGuinness 373
304 Guest of PIMFA [Lunch] 17 October 2018 2018-10-17 Catherine McGuinness 373
305 Guest of DLA Piper [Drinks Reception] 6 November 2018 2018-11-06 Catherine McGuinness 373
306 Guest of European Financial Forum [Cumberland Lodge Conference] 8-9 November 2018 2018-11-09 Catherine McGuinness 373
307 Guest of Centre for European Reform [Ditchley Park Conference] 16 November 2018 2018-11-16 Catherine McGuinness 373
308 Guest of Institute of International Finance [Lunch in New York] 27 November 2018 2018-11-27 Catherine McGuinness 373
309 Guest of Investment Association [Dinner in Washington] 28 November 2018 2018-11-28 Catherine McGuinness 373
310 Guest of Confederation of British Industry [Drinks Reception] 3 December 2018 2018-12-03 Catherine McGuinness 373
311 Guest of Financial Markets Law Committee [Drinks Reception] 5 December 2018 2018-12-05 Catherine McGuinness 373
312 Guest of Investment Association [Drinks Reception] 5 December 2018 2018-12-05 Catherine McGuinness 373
313 Guest of Labour Business [Dinner] 6 December 2018 2018-12-06 Catherine McGuinness 373
314 Guest of Law Society [Dinner] 10 December 2018 2018-12-10 Catherine McGuinness 373
315 Guest of London Stock Exchange [Lunch] 14 December 2018 2018-12-14 Catherine McGuinness 373
316 Received Bottle of Red Wine from Deputy High Commissioner of India 24 December 2018 2018-12-24 Catherine McGuinness 373
317 Received two books from High Commissioner of India 9 January 2019 2019-01-09 Catherine McGuinness 373
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 Guest of Inner City Trust with Dinner & Accommodation at the Bishopsgate Hotel, Derry/Londonderry 3 February 2019 2019-02-03 Catherine McGuinness 373
320 Guest of Andre Villeneuve, ICE Company 1 March 2019 2019-03-01 Catherine McGuinness 373
321 Flowers from Swiss Embassy 1 March 2019 2019-03-01 Catherine McGuinness 373
322 Guest of the Irish Embassy, Brunch at Bentleys for St Patrick's Day 17 March 2019 2019-03-17 Catherine McGuinness 373
323 Guest of Robinson Hambro [dinner] 25 March 2019 2019-03-25 Catherine McGuinness 373
324 Guest of KPMG [lunch] 25 March 2019 2019-03-25 Catherine McGuinness 373
325 Guest of Lord James Sassoon, Matheson & Co Lts [lunch] 8 April 2019 2019-04-08 Catherine McGuinness 373

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