items

Table actions

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

3 rows where record_id = "2004-01-31-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
45c5c6003035cd52ed491ecb677fcc05b0e8b9a5 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 2004-01-31 Richard Allan uk.org.publicwhip/member/694 Richard Allan uk.org.publicwhip/person/10007 0 2004-01-31-80ef1083-10007-0
b3ad24a9d895f79b2d0600235e7ae142174823eb 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 2004-01-31 Richard Allan uk.org.publicwhip/member/694 Richard Allan uk.org.publicwhip/person/10007 1 2004-01-31-80ef1083-10007-0
c205132323f1f3128a94a6f744614077be722c91 7-12 December 2003, to Stockholm, Sweden and Oslo, Norway, as a guest speaker on electronic democracy at the Cisco Public Services Summit. The event organisers, Cisco, provided travel, hotel accommodation, food and entertainment for conference speakers. (Registered 16 December 2003) Overseas visits 80ef1083 2004-01-31 Richard Allan uk.org.publicwhip/member/694 Richard Allan uk.org.publicwhip/person/10007 2 2004-01-31-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");