items

Table actions

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

6 rows where record_id = "2004-05-21-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
38703761661a1dc822b536ecd04761b51d148a9b 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-05-21 Alan Duncan uk.org.publicwhip/member/867 Alan Duncan uk.org.publicwhip/person/10179 0 2004-05-21-80ef1083-10179-0
e1a74995be835033c5329fce16a2bf562dac1b71 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-05-21 Alan Duncan uk.org.publicwhip/member/867 Alan Duncan uk.org.publicwhip/person/10179 1 2004-05-21-80ef1083-10179-0
c9c7c6233ce944d7379ff50f90664c0337b68f43 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-05-21 Alan Duncan uk.org.publicwhip/member/867 Alan Duncan uk.org.publicwhip/person/10179 2 2004-05-21-80ef1083-10179-0
f89900597db918660f25e01c32d7d711d147ab13 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-05-21 Alan Duncan uk.org.publicwhip/member/867 Alan Duncan uk.org.publicwhip/person/10179 3 2004-05-21-80ef1083-10179-0
0ad1267d1c8b4a7070b336ea45b81b4ad618aa5c 26-28 September 2003, to Oman as guest of the Government (Registered 29 September 2003) Overseas visits 80ef1083 2004-05-21 Alan Duncan uk.org.publicwhip/member/867 Alan Duncan uk.org.publicwhip/person/10179 4 2004-05-21-80ef1083-10179-0
010e933d84ed40d192e9e1e5bfe4e282190483e0 30 December 2003-4 January 2004, to Oman as a guest of the Government of Oman. (Registered 5 January 2004) Overseas visits 80ef1083 2004-05-21 Alan Duncan uk.org.publicwhip/member/867 Alan Duncan uk.org.publicwhip/person/10179 5 2004-05-21-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");