gifts
Data source: See col-scraper on GitHub
91 rows where member_id = 373
This data as json, CSV (advanced)
date (date) >30 ✖
- 2017-06-12 2
- 2017-06-20 2
- 2017-06-22 2
- 2017-11-06 2
- 2018-03-13 2
- 2018-05-22 2
- 2018-09-19 2
- 2018-10-11 2
- 2018-12-05 2
- 2019-01-09 2
- 2019-03-01 2
- 2019-03-25 2
- 2015-05-14 1
- 2015-06-09 1
- 2015-06-18 1
- 2015-07-22 1
- 2015-09-11 1
- 2015-09-15 1
- 2016-06-27 1
- 2016-10-21 1
- 2016-11-14 1
- 2016-12-06 1
- 2017-01-16 1
- 2017-01-17 1
- 2017-02-05 1
- 2017-02-13 1
- 2017-02-22 1
- 2017-03-06 1
- 2017-03-07 1
- 2017-03-10 1
- …
Link | rowid ▼ | name | date_str | date | member_id |
---|---|---|---|---|---|
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 |
301 | 301 | Guest of International Bar Association [Lunch in Rome] | 11 October 2018 | 2018-10-11 | Catherine McGuinness 373 |
302 | 302 | Guest of TheCityUK [Dinner in Rome] | 11 October 2018 | 2018-10-11 | Catherine McGuinness 373 |
303 | 303 | Guest of the Investment Association [Annual Dinner] | 16 October 2018 | 2018-10-16 | Catherine McGuinness 373 |
304 | 304 | Guest of PIMFA [Lunch] | 17 October 2018 | 2018-10-17 | Catherine McGuinness 373 |
305 | 305 | Guest of DLA Piper [Drinks Reception] | 6 November 2018 | 2018-11-06 | Catherine McGuinness 373 |
306 | 306 | Guest of European Financial Forum [Cumberland Lodge Conference] | 8-9 November 2018 | 2018-11-09 | Catherine McGuinness 373 |
307 | 307 | Guest of Centre for European Reform [Ditchley Park Conference] | 16 November 2018 | 2018-11-16 | Catherine McGuinness 373 |
308 | 308 | Guest of Institute of International Finance [Lunch in New York] | 27 November 2018 | 2018-11-27 | Catherine McGuinness 373 |
309 | 309 | Guest of Investment Association [Dinner in Washington] | 28 November 2018 | 2018-11-28 | Catherine McGuinness 373 |
310 | 310 | Guest of Confederation of British Industry [Drinks Reception] | 3 December 2018 | 2018-12-03 | Catherine McGuinness 373 |
311 | 311 | Guest of Financial Markets Law Committee [Drinks Reception] | 5 December 2018 | 2018-12-05 | Catherine McGuinness 373 |
312 | 312 | Guest of Investment Association [Drinks Reception] | 5 December 2018 | 2018-12-05 | Catherine McGuinness 373 |
313 | 313 | Guest of Labour Business [Dinner] | 6 December 2018 | 2018-12-06 | Catherine McGuinness 373 |
314 | 314 | Guest of Law Society [Dinner] | 10 December 2018 | 2018-12-10 | Catherine McGuinness 373 |
315 | 315 | Guest of London Stock Exchange [Lunch] | 14 December 2018 | 2018-12-14 | 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 |
317 | 317 | Received two books from High Commissioner of India | 9 January 2019 | 2019-01-09 | 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 |
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 |
320 | 320 | Guest of Andre Villeneuve, ICE Company | 1 March 2019 | 2019-03-01 | Catherine McGuinness 373 |
321 | 321 | Flowers from Swiss Embassy | 1 March 2019 | 2019-03-01 | 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 |
323 | 323 | Guest of Robinson Hambro [dinner] | 25 March 2019 | 2019-03-25 | Catherine McGuinness 373 |
324 | 324 | Guest of KPMG [lunch] | 25 March 2019 | 2019-03-25 | Catherine McGuinness 373 |
325 | 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
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");