items

Table actions

Data source: mySociety Data · About: simonw/register-of-members-interests-datasette

6 rows where member_id = "uk.org.publicwhip/member/6" sorted by date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: item, category_id, date, sort_order, record_id, date (date)

hash item category_id date ▲ member_id person_id sort_order record_id
3b2946c0bb0ffaac64b25e403fd83fabd764b50e In my capacity as Shadow Secretary of State for Culture, Media and Sport, I receive frequent invitations to attend cultural and sporting events; the value of the hospitality I receive on some of these occasions may exceed £235. Gifts, benefits and hospitality (UK) 84642823 2001-05-14 Peter Ainsworth uk.org.publicwhip/member/6 Peter Ainsworth uk.org.publicwhip/person/10006 0 2001-05-14-84642823-10006-0
c99f2c2ce47faa49676fb3328d5739360db19f60 31 December 1999, my wife, three children and I were guests of the New Millennium Experience Company at the Millennium Dome. (Registered 17 February 2000) Gifts, benefits and hospitality (UK) 84642823 2001-05-14 Peter Ainsworth uk.org.publicwhip/member/6 Peter Ainsworth uk.org.publicwhip/person/10006 1 2001-05-14-84642823-10006-0
95d652dc04ce1e6776526a91b0966df7124b7332 I have received, unsolicited, classical CD's from the Peter Moores Foundation whose aggregate retail value may exceed the threshold for registration. (Registered 10 November 2000) Gifts, benefits and hospitality (UK) 84642823 2001-05-14 Peter Ainsworth uk.org.publicwhip/member/6 Peter Ainsworth uk.org.publicwhip/person/10006 2 2001-05-14-84642823-10006-0
d09812fcc79164f91b33097e6176ff56a5b420b2 12-13 October 2000, to Dublin, sponsored by the British Tourist Authority, who paid hotel and travel costs. (Registered 10 November 2000) Overseas visits 80ef1083 2001-05-14 Peter Ainsworth uk.org.publicwhip/member/6 Peter Ainsworth uk.org.publicwhip/person/10006 0 2001-05-14-80ef1083-10006-0
522b2b10ff99ac06c0c16560c94df6ee9f28df78 In my capacity as Shadow Secretary of State for Culture, Media and Sport, I receive frequent invitations to attend cultural and sporting events; the value of the hospitality I receive on some of these occasions may exceed £235. Gifts, benefits and hospitality (UK) 84642823 2000-11-10 Peter Ainsworth uk.org.publicwhip/member/6 Peter Ainsworth uk.org.publicwhip/person/10006 0 2000-11-10-84642823-10006-0
84f6b95530d556450c294493f0e1fa1880702bbd 31 December 1999, my wife, three children and I were guests of the New Millennium Experience Company at the Millennium Dome. (Registered 17 February 2000) Gifts, benefits and hospitality (UK) 84642823 2000-11-10 Peter Ainsworth uk.org.publicwhip/member/6 Peter Ainsworth uk.org.publicwhip/person/10006 1 2000-11-10-84642823-10006-0

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE items (
        hash VARCHAR(40) NOT NULL,
        item TEXT,
        category_id TEXT,
        date TEXT,
        member_id TEXT,
        person_id TEXT,
        sort_order INTEGER,
        record_id TEXT,
        PRIMARY KEY (hash),
        FOREIGN KEY ("category_id") REFERENCES [categories](id),
        FOREIGN KEY ("member_id") REFERENCES [members](id),
        FOREIGN KEY ("person_id") REFERENCES [people](id)
    );
CREATE INDEX items_date ON items("date");
CREATE INDEX items_category_id ON items("category_id");
CREATE INDEX items_member_id ON items("member_id");
CREATE INDEX items_person_id ON items("person_id");
CREATE INDEX items_record_id ON items("record_id");