items

Table actions

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

4 rows where record_id = "2001-05-14-84642823-10389-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
78ac001856841ff0c5b6cf01e7930247fc3dd9b8 In my position as a member of the Public Policy Advisory Committee of the RAC I receive complimentary membership of the RAC Club at Pall Mall for me, and membership of their breakdown services for me and my husband. (Registered 29 January 1999) Gifts, benefits and hospitality (UK) 84642823 2001-05-14 Anne McIntosh uk.org.publicwhip/member/389 Anne McIntosh uk.org.publicwhip/person/10389 0 2001-05-14-84642823-10389-0
68e12dbd7598a5edcfd5cdb3ad57c286e4844326 9 June 2000, I was the guest of Transco at the Yorkshire International Business Convention at Harewood House, Leeds. (Registered 7 June 2000) Gifts, benefits and hospitality (UK) 84642823 2001-05-14 Anne McIntosh uk.org.publicwhip/member/389 Anne McIntosh uk.org.publicwhip/person/10389 1 2001-05-14-84642823-10389-0
02bfc22a1943c407c5f0cd42a44f0fda5114eaa9 14 July 2000, visit to the York Races as a guest of the All-Party Racing and Bloodstock Industries Group. (Registered 26 July 2000) Gifts, benefits and hospitality (UK) 84642823 2001-05-14 Anne McIntosh uk.org.publicwhip/member/389 Anne McIntosh uk.org.publicwhip/person/10389 2 2001-05-14-84642823-10389-0
43d2b6d2dd781de8d1968a9663b15cea48c41180 17 February 2001, my husband and I attended the Lord Mayor of York's Valentine's Ball at York Races as guests of BT plc. (Registered 19 February 2001) Gifts, benefits and hospitality (UK) 84642823 2001-05-14 Anne McIntosh uk.org.publicwhip/member/389 Anne McIntosh uk.org.publicwhip/person/10389 3 2001-05-14-84642823-10389-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");