items

Table actions

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

5 rows where record_id = "2004-07-16-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
c77c4a13f38700d69842631f70e4beee3fc6e963 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-07-16 Alan Duncan uk.org.publicwhip/member/867 Alan Duncan uk.org.publicwhip/person/10179 0 2004-07-16-80ef1083-10179-0
c3e82058c1d40859e0ffa69cc18761535e60c1fa 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-07-16 Alan Duncan uk.org.publicwhip/member/867 Alan Duncan uk.org.publicwhip/person/10179 1 2004-07-16-80ef1083-10179-0
e2081525536e6f9ed4d041d8623cfffb2845dc15 26-28 September 2003, to Oman as guest of the Government (Registered 29 September 2003) Overseas visits 80ef1083 2004-07-16 Alan Duncan uk.org.publicwhip/member/867 Alan Duncan uk.org.publicwhip/person/10179 2 2004-07-16-80ef1083-10179-0
f533b39c8d81cde81ba076cead32a8576fde537b 30 December 2003-4 January 2004, to Oman as a guest of the Government of Oman. (Registered 5 January 2004) Overseas visits 80ef1083 2004-07-16 Alan Duncan uk.org.publicwhip/member/867 Alan Duncan uk.org.publicwhip/person/10179 3 2004-07-16-80ef1083-10179-0
6677976ec85432c39f4b4f01d88c75b026fec1e5 27 May-2 June 2004, to Oman with the All-Party Oman Group as guest of the Oman Majlis, to establish links between Parliament and the Majlis. (Registered 7 June 2004) Overseas visits 80ef1083 2004-07-16 Alan Duncan uk.org.publicwhip/member/867 Alan Duncan uk.org.publicwhip/person/10179 4 2004-07-16-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");