items

Table actions

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

2 rows where record_id = "2004-09-08-a41b9847-10047-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
55ebd3e64b0c4c836df84738789ddb27b8e9882f July/August 2004, accompanied by my family I spent 18 nights as a guest at a private villa in Barbados. I have made a charitable donation to a charity chosen by Sir Cliff Richard, the owner of the villa, in lieu of the cost for this accommodation. I paid for all other expenses, including flights. (Registered 17 August 2004) Overseas benefits and gifts a41b9847 2004-09-08 Tony Blair uk.org.publicwhip/member/736 Tony Blair uk.org.publicwhip/person/10047 0 2004-09-08-a41b9847-10047-0
8eaab4f627b3da95aa0fe040430803223372812f 16 August 2004, while on holiday in Tuscany, I visited Prime Minister Berlusconi in Sardinia for talks. The Italian Government provided the travel arrangements for the visit and accommodation for an overnight stay which included my wife who accompanied me. (Registered 17 August 2004) Overseas benefits and gifts a41b9847 2004-09-08 Tony Blair uk.org.publicwhip/member/736 Tony Blair uk.org.publicwhip/person/10047 1 2004-09-08-a41b9847-10047-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");