items

Table actions

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

3 rows where record_id = "2004-01-31-80ef1083-10160-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
a40f1947e685b06e5cf26c9c5ef32ec2ec63491f 12-14 March 2003, to Madrid, Spain, with the Spanish All-Party Parliamentary Group. Travel expenses to Madrid paid for from Group funds provided by the Group's declared sponsor TUI UK Ltd. (Thomson Holidays). Expenses whilst in Madrid paid for by the Congreso de los Diputados, whose guests we were. (Registered 9 April 2003) Overseas visits 80ef1083 2004-01-31 Quentin Davies uk.org.publicwhip/member/846 Quentin Davies uk.org.publicwhip/person/10160 0 2004-01-31-80ef1083-10160-0
442665d09975870a7dbc80f64a315738846fd49c 15-17 May 2003, to Berlin to attend the Königswinter Conference. Transport and accommodation provided by the organisers. (Registered 19 May 2003) Overseas visits 80ef1083 2004-01-31 Quentin Davies uk.org.publicwhip/member/846 Quentin Davies uk.org.publicwhip/person/10160 1 2004-01-31-80ef1083-10160-0
57aae72243e5a4fde0f31726c730aa2e9399c463 29-30 June 2003, to Apeldoorn Conference, Amsterdam. Expenses met by conference sponsors (ABN AMRO Rothschild, Lloyds TSB Group plc, Reed Elsevier NV, Shell and Unilever. (Registered on 2 July 2003) Overseas visits 80ef1083 2004-01-31 Quentin Davies uk.org.publicwhip/member/846 Quentin Davies uk.org.publicwhip/person/10160 2 2004-01-31-80ef1083-10160-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");