items

Table actions

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

3 rows where record_id = "2001-05-14-84642823-10006-0" sorted by date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: 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

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