items

Table actions

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

8 rows where record_id = "2004-01-31-80ef1083-10179-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
f7e59ad19741038c6a79cc8262ddf49d33ee365d 15-19 December 2002, to Saudi Arabia and Bahrain, tickets paid for by Council for the Advancement of Arab-British Understanding. (Registered 23 December 2002) Overseas visits 80ef1083 2004-01-31 Alan Duncan uk.org.publicwhip/member/867 Alan Duncan uk.org.publicwhip/person/10179 0 2004-01-31-80ef1083-10179-0
cd550292496d531ff74ee2c51af28081322d6e1b 1-5 January 2003, to Oman as a guest of the Government of Oman. (Registered 18 January 2003) Overseas visits 80ef1083 2004-01-31 Alan Duncan uk.org.publicwhip/member/867 Alan Duncan uk.org.publicwhip/person/10179 1 2004-01-31-80ef1083-10179-0
51082aa0c12ddc1507157eb7a52f8cefb1184026 23 May-1 June 2003, to Syria as guest of the British Syrian Society with hospitality provided by the Syrian Government. (Registered 3 June 2003) Overseas visits 80ef1083 2004-01-31 Alan Duncan uk.org.publicwhip/member/867 Alan Duncan uk.org.publicwhip/person/10179 2 2004-01-31-80ef1083-10179-0
ab41d4a864b8eceb73dbe7ea43ca4312e7cfa361 30 June-2 July 2003, visit to Israel and the Palestinian Authority. Fare paid by Conservative Central Office, hotel accommodation by Government of Israel. (Registered 8 July 2003) Overseas visits 80ef1083 2004-01-31 Alan Duncan uk.org.publicwhip/member/867 Alan Duncan uk.org.publicwhip/person/10179 3 2004-01-31-80ef1083-10179-0
0e003b5a2fe21e40167b0caa62706f173da63903 7-10 August 2003, to Lebanon to meet President and Prime Minister and attend opening of Le Royal Hotel. Flights and accommodation provided by the Anglo-Arab Organisation and General Mediterranean Holding. (Registered 22 August 2003) Overseas visits 80ef1083 2004-01-31 Alan Duncan uk.org.publicwhip/member/867 Alan Duncan uk.org.publicwhip/person/10179 4 2004-01-31-80ef1083-10179-0
ae8193981fdaa0b06afcfaddcd6fb6601ddcb6d2 10-21 August 2003, government hotel room rates and car and driver provided by the Government of the Syrian Arab Republic during private visit to Syria. (Registered 22 August 2003) Overseas visits 80ef1083 2004-01-31 Alan Duncan uk.org.publicwhip/member/867 Alan Duncan uk.org.publicwhip/person/10179 5 2004-01-31-80ef1083-10179-0
cd268282562c9162b0b2c23a822d59b478373f87 26-28 September 2003, to Oman as guest of the Government (Registered 29 September 2003) Overseas visits 80ef1083 2004-01-31 Alan Duncan uk.org.publicwhip/member/867 Alan Duncan uk.org.publicwhip/person/10179 6 2004-01-31-80ef1083-10179-0
525498da074208a22d2652807c2067598c8abc52 30 December 2003-4 January 2004, to Oman as a guest of the Government of Oman. (Registered 5 January 2004) Overseas visits 80ef1083 2004-01-31 Alan Duncan uk.org.publicwhip/member/867 Alan Duncan uk.org.publicwhip/person/10179 7 2004-01-31-80ef1083-10179-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");