items

Table actions

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

2 rows where record_id = "2004-10-22-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
6fc99747ea46d7de47ff27c80d76f7160108c010 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-10-22 Tony Blair uk.org.publicwhip/member/736 Tony Blair uk.org.publicwhip/person/10047 0 2004-10-22-a41b9847-10047-0
6c1b9e9a3a4700c2fc98a16392ae73333635eb59 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-10-22 Tony Blair uk.org.publicwhip/member/736 Tony Blair uk.org.publicwhip/person/10047 1 2004-10-22-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");