items

Table actions

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

3 rows where record_id = "2002-11-26-80ef1083-10493-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
b0899d466b3b9b727dee80d504a928296687aa7b 23-24 January 2002, to Warsaw for meeting of politicans and officials in preparation for Polish membership of the EU, financed by the Polish Government. (Registered 25 February 2002) Overseas visits 80ef1083 2002-11-26 Joyce Quin uk.org.publicwhip/member/1177 Joyce Quin uk.org.publicwhip/person/10493 0 2002-11-26-80ef1083-10493-0
225bafb4b2cfaf33f8a3179079468a1f290e4d59 23-24 February 2002, to Warsaw, to participate in a conference on EU enlargement, funded by the Lucchini Fondation and the Fondation Notre Europe. (Registered 22 March 2002) Overseas visits 80ef1083 2002-11-26 Joyce Quin uk.org.publicwhip/member/1177 Joyce Quin uk.org.publicwhip/person/10493 1 2002-11-26-80ef1083-10493-0
7fd83055690d85ba1610cae97b5928fc42838266 20 March 2002, to Paris for meeting of Board of Franco-British Council, financed by the Franco-British Council. (Registered 22 March 2002) Overseas visits 80ef1083 2002-11-26 Joyce Quin uk.org.publicwhip/member/1177 Joyce Quin uk.org.publicwhip/person/10493 2 2002-11-26-80ef1083-10493-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");