items

Table actions

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

3 rows where record_id = "2003-12-04-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
bf8e52a8f1afdeabf8d58644db6f6df5fc9424c9 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 2003-12-04 Quentin Davies uk.org.publicwhip/member/846 Quentin Davies uk.org.publicwhip/person/10160 0 2003-12-04-80ef1083-10160-0
ba0672e250bfe4f3630479a07ac383583498b95f 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 2003-12-04 Quentin Davies uk.org.publicwhip/member/846 Quentin Davies uk.org.publicwhip/person/10160 1 2003-12-04-80ef1083-10160-0
a8ef52a6a28980c7e6c3c8046eef19bb2897f94b 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 2003-12-04 Quentin Davies uk.org.publicwhip/member/846 Quentin Davies uk.org.publicwhip/person/10160 2 2003-12-04-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");