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

19 rows where member_id = 296

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: date_str, date, date (date)

Link rowid ▼ name date_str date member_id
399 399 Acted as LMLT at the UN 70th anniversary commemoration at Guildhall, lecture , reception and dinner. Accompanied by my wife to the lecture and reception. Hospitality provided by the UNA 9 October 2015 2015-10-09 Ian David Luder 296
400 400 Wife attended Gibraltar Day at Guildhall. Hosted by HM government of Gibraltar. A reception. 12 October 2015 2015-10-12 Ian David Luder 296
401 401 Acted as LMLT at the British Exporters Association Lunch at Mansion House. Hospitality provided by the Association. 13 October 2015 2015-10-13 Ian David Luder 296
402 402 Attended the Presentation Dinner with wife, hosted by the Worshipful company of Shipwrights and the Worshipful company of Goldsmiths 19 October 2015 2015-10-19 Ian David Luder 296
403 403 Acted as LMLT at the Upholders Annual Banquet at Mansion House, Hospitality provided by the Company. 20 October 2015 2015-10-20 Ian David Luder 296
404 404 Presented with a cushion by the Worshipful company of Holders, embroidered with their Coat of Arms, and the details of their current Master. 20 October 2015 2015-10-20 Ian David Luder 296
405 405 LMLT at The Stationers' Company Civic Dinner, at Stationers' Hall, and was accompanied by my wife 24 November 2015 2015-11-24 Ian David Luder 296
406 406 LMLT at The Rifles Awards Dinner at Guildhall 3 December 2015 2015-12-03 Ian David Luder 296
407 407 LMLT at the Annual Dinner of the Worshipful Company of Pattenmakers at Mansion House. Presented with a China Plate with a brief history of the company painted thereon. 22 January 2016 2016-01-22 Ian David Luder 296
408 408 Guest of the Worshipful Company of Plaisterers at their Spring Dinner in role as Chairman of the Open Spaces and City Gardens Committee, to receive on behalf of the City, the payment of a silver crown as symbolic rent for the garden adjoining the Hall 5 April 2016 2016-04-05 Ian David Luder 296
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
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
411 411 The Worshipful Company of Mercers Gresham Dinner. 14 November 2017 2017-11-14 Ian David Luder 296
412 412 Together with my wife, I was invited to the Kuwait National Day Lunchtime Reception, which my wife attended. It was held at the Dorchester hotel W1. 22 Feb 2018 2018-02-22 Ian David Luder 296
413 413 Gresham College Stakeholder Presentation & Dinner (Worshipful Company of Mercers). 22 Feb 2018 2018-02-22 Ian David Luder 296
414 414 Presentation Dinner at Ironmongers Hall, together with wife. Hosted by the Worshipful Company of International Bankers and the Worshipful Company of Ironmongers. 22 Oct 2018 2018-10-22 Ian David Luder 296
415 415 Attended, together with wife, an early evening reception at the Turkish embassy which celebrated their National Day. 29 Oct 2018 2018-10-29 Ian David Luder 296
416 416 Mercer’s Company Gresham Dinner at Mercer’s Hall. 13 November 2018 2018-11-13 Ian David Luder 296
417 417 Worshipful Company of Carmen, signed hard-back copy of "Carrs and Carmen" (second edition) 13 March 2019 2019-03-13 Ian David Luder 296

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