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 = 1666

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: date (date)

Link rowid ▼ name date_str date member_id
425 425 Dinner and gift of a leather travel wallet at the Guildhall for the C & C Alpha Group Limited 23 September 2017 2017-09-23 Keith David Forbes Bottomley 1666
426 426 Private dinner given by the Lord Mayor of Westminster at the In & Out Club 12 May 2018 2018-05-12 Keith David Forbes Bottomley 1666
427 427 Ticket and hospitality, Vitality Hockey Women’s World Cup at Lee Valley Hockey and Tennis Centre, Queen Elizabeth Olympic Park, London from the City of London Corporation 31 July 2018 2018-07-31 Keith David Forbes Bottomley 1666

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