items

Table actions

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

3 rows where record_id = "2001-05-14-84642823-10082-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
837ba40ae5bd91879344ca7cb20a7b6f7c3c4a91 4 March 2000, ticket and hospitality at England v Wales rugby match at Twickenham, as guest of the Royal and Sun Alliance Insurance Group. (Registered 15 March 2000) Gifts, benefits and hospitality (UK) 84642823 2001-05-14 John Butterfill uk.org.publicwhip/member/82 John Butterfill uk.org.publicwhip/person/10082 0 2001-05-14-84642823-10082-0
d69763b73c47810436ede6a11ce2b5a4037fee8b 7-9 June 2000, British-Spanish All-Party Parliamentary Group meeting with Spanish counterparts in Edinburgh. Travel paid for by British Airways and other expenses met from Group funds provided by our declared sponsors, British Gas plc and the Norwich Union plc. Travel within Edinburgh and other hospitality was provided and paid for by the Scottish Executive. (Registered 27 June 2000) Gifts, benefits and hospitality (UK) 84642823 2001-05-14 John Butterfill uk.org.publicwhip/member/82 John Butterfill uk.org.publicwhip/person/10082 1 2001-05-14-84642823-10082-0
8c2e342a40ede576706c36cc3adce4b810053ec1 29 June 2000, tickets and hospitality at the All England Tennis Club, Wimbledon, for self and wife as guests of the Provident Financial Group. (Registered 6 July 2000) Gifts, benefits and hospitality (UK) 84642823 2001-05-14 John Butterfill uk.org.publicwhip/member/82 John Butterfill uk.org.publicwhip/person/10082 2 2001-05-14-84642823-10082-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");