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

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ name date_str date member_id
189 189 Hospitality at Barbican Centre - 13/05/15 - J.P Gaultier World of Fashion, Theatre ticket to RSC Henry IV part 1 - 19/1/15 and ticket x 2 to LSO concert - 16/10/14. Note: After the RSC Theatre invitation in January 2015, previously reported, I have declined all subsequent invitations from RSC.     Sylvia Doreen Moys 381
190 190 Barbican Centre - I continue to accept a number of invitations:- Breakfast gatherings and guided visits to Exhibitions in Art Gallery and Curve Occasional LSO Concerts (ticket prices generally £42) GSMD Gold Medal Final in Barbican Hall LSSO Concerts Jan, April, Sept 3 @ £25 I consider cumulatively, giving the above as examples, on a 1 year rolling total, I receive hospitality which could reach the declaration figure of £200.     Sylvia Doreen Moys 381
191 191 Barbican Centre I continue to accept a number of invitations:- Breakfast gatherings and guided visits to Exhibitions in Art Gallery and Curve Occasional LSO Concerts (ticket prices with Rattle in post now, generally £55) GSMD Gold Medal Final in Barbican Hall LSSO Concerts Jan, April, Sept 3 @ £26 Recently an evening reception in Garden Room, followed by guided tour of ‘The Japanese House’ I consider cumulatively, giving the above as examples, on a 1 year rolling total, I receive hospitality which can well reach the declaration figure of £200. Note: After the RSC Theatre invitation in January 2015, previously reported, I have declined all subsequent invitations from RSC. Above updated from April 2017, given the modest increase in LSSO tickets, ticket prices for Rattle concerts, and also the Reception and evening guided visit to Japanese House.     Sylvia Doreen Moys 381

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