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

3 rows where member_id = 287

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: date (date)

Link rowid ▼ name date_str date member_id
491 491 Cart Marking lunch (Worshipful Company of Carmen) 15 July 2015 2015-07-15 Vivienne Littlechild 287
492 492 Private visit to the Tower of London Jewel House followed by dinner at Tower Bridge, accompanied by my husband (TMI conference) 23rd November   Vivienne Littlechild 287
493 493 Drinks at Claridges (Land Securities) 9th December   Vivienne Littlechild 287

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