items

Table actions

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

4 rows where record_id = "2000-11-10-80ef1083-10019-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
92bb899a874c0b5d38c4a0e67fb397793ff49ac8 7-10 January 1999, to the Republic of Cyprus as guest of and sponsored by the Cypriot Parliament. (Registered 12 February 1999) Overseas visits 80ef1083 2000-11-10 David Atkinson uk.org.publicwhip/member/19 David Atkinson uk.org.publicwhip/person/10019 0 2000-11-10-80ef1083-10019-0
87090a53f0280fb40502ee66ecc722dd8d7a828c 14-19 November 1999, to Iran with the British-Iranian All-Party Parliamentary Group, at the invitation of the Iranian Parliament and Government for the improvement of bilateral parliamentary relations. Travel between London and Tehran sponsored and paid for by British Airways. Accommodation in Tehran provided without charge as guests of the British Ambassador. One day and one night visit to Shiraz made as guests of the Iranian Parliament and the Governorship of Fars Province. (Registered 15 December 1999) Overseas visits 80ef1083 2000-11-10 David Atkinson uk.org.publicwhip/member/19 David Atkinson uk.org.publicwhip/person/10019 1 2000-11-10-80ef1083-10019-0
b8b0cc7e81905358704a21b16a2e2194509f832d 9-11 September, to Gibraltar, to attend National Day and to have meetings with the Prime Minister and opposition leaders, as guest of the Government of Gibraltar. (Registered 2 November 2000) Overseas visits 80ef1083 2000-11-10 David Atkinson uk.org.publicwhip/member/19 David Atkinson uk.org.publicwhip/person/10019 2 2000-11-10-80ef1083-10019-0
9388dd59d5c716e06a868cda15182979cb20afec 9-13 October, to Russia, as a member of the All-Party British-Russia Group, to visit the Priobskaye Oil Field and to meet leading members of the State Duma in Moscow, sponsored by Yukos Oil. (Registered 2 November 2000) Overseas visits 80ef1083 2000-11-10 David Atkinson uk.org.publicwhip/member/19 David Atkinson uk.org.publicwhip/person/10019 3 2000-11-10-80ef1083-10019-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");