items

Table actions

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

3 rows where record_id = "2001-05-14-80ef1083-10033-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
833c2599032efd5778103db1be9f51537035416d 23-24 March 2000, to Bruges, as a member of the West Coast Main Line All-Party delegation, to receive briefing on high speed tilting diesel trains for cross country services, as guests of Bombardier Ltd and Virgin Trains. (Registered 7 April 2000) Overseas visits 80ef1083 2001-05-14 Roy Beggs uk.org.publicwhip/member/33 Roy Beggs uk.org.publicwhip/person/10033 0 2001-05-14-80ef1083-10033-0
cb113c57c9d8139c4823aae88a8a50f22b66599c 16-17 October 2000, to Denmark with the Parliamentary Renewable and Sustainable Energy Group (PRASEG) to witness the Danish Wind Farm sector and meet with senior members of the Danish Government Energy Agency and the Danish Wind Industry. Flight and accommodation was paid for by National Wind Power UK. (Registered 6 December 2000) Overseas visits 80ef1083 2001-05-14 Roy Beggs uk.org.publicwhip/member/33 Roy Beggs uk.org.publicwhip/person/10033 1 2001-05-14-80ef1083-10033-0
5d8dd9ae0d612cedc4a53d28e1ba0456ab08855d 8-11 March 2001, to Norfolk, Virginia, USA, to attend commissioning ceremony for USS Winston S Churchill. Transport to and from London provided by Department of the Navy, USA. Accommodation etc., travel London to Belfast provided by Larne Borough Council. (Registered 9 April 2001) Overseas visits 80ef1083 2001-05-14 Roy Beggs uk.org.publicwhip/member/33 Roy Beggs uk.org.publicwhip/person/10033 2 2001-05-14-80ef1083-10033-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");