items

Table actions

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

2 rows where record_id = "2003-12-04-80ef1083-10007-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
7a3166183510b103afc01281236e40a431e7f404 26 November-1 December 2002, to Ottawa, Canada, to give the keynote address at an event on edemocracy organised as part of the Crossing Boundaries programme and to hold a series of meetings on edemocracy with Canadian NGOs, Parliamentarians and civil servants. Flights to Ottawa and hotel bills paid for by the Centre for Collaborative Government, a Canadian thinktank which organised the conference. (Registered 11 March 2003) Overseas visits 80ef1083 2003-12-04 Richard Allan uk.org.publicwhip/member/694 Richard Allan uk.org.publicwhip/person/10007 0 2003-12-04-80ef1083-10007-0
96edb428a36201228b9382a75be784fbe27363a4 11-13 March 2003, to Athens, Greece, as keynote speaker to a conference on the future of the Parthenon sculptures organised by Hazlis and Rivas, the organisers of the Economist Conferences for Greece. I was provided with economy class return flight to Athens and hotel accommodation by the organisers of the conference, which had a number of sponsors including Ernst and Young and the Hellenic Ministry of Culture. (Registered 16 April 2003) Overseas visits 80ef1083 2003-12-04 Richard Allan uk.org.publicwhip/member/694 Richard Allan uk.org.publicwhip/person/10007 1 2003-12-04-80ef1083-10007-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");