gifts
Data source: See col-scraper on GitHub
575 rows
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 |
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");