items

Table actions

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

3 rows where record_id = "2003-12-04-80ef1083-10761-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
334e5c0d79eb7956b2d375642f22437f6c7651a1 12-24 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 31 March 2003) Overseas visits 80ef1083 2003-12-04 Chris Bryant uk.org.publicwhip/member/761 Chris Bryant uk.org.publicwhip/person/10761 0 2003-12-04-80ef1083-10761-0
ddfc7f52806606b39116a90564c8632f968ae042 30 June-4 July 2003, to Israel and Palestinian Authority to meet members of the Israeli Government and Palestinian Authority and others. Travel and accommodation paid by Labour Friends of Israel and Israeli Foreign Ministry. (Registered 14 July 2003) Overseas visits 80ef1083 2003-12-04 Chris Bryant uk.org.publicwhip/member/761 Chris Bryant uk.org.publicwhip/person/10761 1 2003-12-04-80ef1083-10761-0
818c515e63e1cfe26aaf9cb82870a7290b0929b3 4-5 September 2003, to Barcelona. Flight and one night's hotel accommodation in Barcelona paid for by the Fundacio Rafael Campalans, a Catalan think-tank at whose conference I spoke. Overseas visits 80ef1083 2003-12-04 Chris Bryant uk.org.publicwhip/member/761 Chris Bryant uk.org.publicwhip/person/10761 2 2003-12-04-80ef1083-10761-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");