items

Table actions

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

3 rows where member_id = "uk.org.publicwhip/member/100" sorted by date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: category_id, sort_order, record_id, date (date)

hash item category_id date ▲ member_id person_id sort_order record_id
41884091222f2563eb08ada7e58ddb368a64882e 31 January-2 February 2001, to Seville, Spain, with the British-Spanish All-Party Parliamentary Group, for meeting with Spanish colleagues from the Congress of Deputies. Travel paid out of Group funds provided by declared sponsors, British Gas plc and Norwich Union plc. All other expenses met by our hosts, the Spanish Congress of Deputies. (Registered 23 March 2001) Overseas visits 80ef1083 2001-05-14 David Chaytor uk.org.publicwhip/member/100 David Chaytor uk.org.publicwhip/person/10100 0 2001-05-14-80ef1083-10100-0
786ad8d250d9c1e9ed88f2128246dbf85c4b2ed9 Shared ownership of property in London. Land and Property 4f1e6359 2001-05-14 David Chaytor uk.org.publicwhip/member/100 David Chaytor uk.org.publicwhip/person/10100 0 2001-05-14-4f1e6359-10100-0
a3a83b5ac08c86e758b0aef93ad0b18043954b70 Shared ownership of property in Bury. Land and Property 4f1e6359 2001-05-14 David Chaytor uk.org.publicwhip/member/100 David Chaytor uk.org.publicwhip/person/10100 1 2001-05-14-4f1e6359-10100-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");