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

7 rows where member_id = 207

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: date_str

Link rowid ▼ name date_str date member_id
182 182 Mountbatten Festival of Music at the Royal Albert Hall: concert and drinks in a box as guest of Royal Marine Reserves London 16th April   The Lord Mountevans, Jeffrey Evans 207
183 183 Lunch with the Great !2 Clerks at Vintners’ Hall 20th April   The Lord Mountevans, Jeffrey Evans 207
184 184 Lunch at Drapers Hall as guest of British Ports Association 21st April   The Lord Mountevans, Jeffrey Evans 207
185 185 Lunch with the Wardens of the Grocers Company 22nd April   The Lord Mountevans, Jeffrey Evans 207
186 186 Chancellors Dinner of City University at Mansion House 22nd April   The Lord Mountevans, Jeffrey Evans 207
187 187 Dinner with Engineers Company in Stationers’ Hall 28th April   The Lord Mountevans, Jeffrey Evans 207
188 188 Seatrade 2015 Awards Dinner (speech) 6th May   The Lord Mountevans, Jeffrey Evans 207

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