items

Table actions

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

7 rows where record_id = "2003-12-04-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
2965e32f67948a636ec0bf20057112932bc0a57a 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 2003-12-04 Alan Duncan uk.org.publicwhip/member/867 Alan Duncan uk.org.publicwhip/person/10179 0 2003-12-04-80ef1083-10179-0
be8e433b6462cb04767264dc56b1cf6aebad33f5 1-5 January 2003, to Oman as a guest of the Government of Oman. (Registered 18 January 2003) Overseas visits 80ef1083 2003-12-04 Alan Duncan uk.org.publicwhip/member/867 Alan Duncan uk.org.publicwhip/person/10179 1 2003-12-04-80ef1083-10179-0
e31c27e106a2d1b47416a550d1646f2b636acea4 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 2003-12-04 Alan Duncan uk.org.publicwhip/member/867 Alan Duncan uk.org.publicwhip/person/10179 2 2003-12-04-80ef1083-10179-0
1ef637682e7d96a3be2dd811f3410485dfc64548 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 2003-12-04 Alan Duncan uk.org.publicwhip/member/867 Alan Duncan uk.org.publicwhip/person/10179 3 2003-12-04-80ef1083-10179-0
6290ce1a16502eccf2b5adeda74088f8aa0d818b 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 2003-12-04 Alan Duncan uk.org.publicwhip/member/867 Alan Duncan uk.org.publicwhip/person/10179 4 2003-12-04-80ef1083-10179-0
aecba2b2b34a94d37b45175231d21544d46a1a43 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 2003-12-04 Alan Duncan uk.org.publicwhip/member/867 Alan Duncan uk.org.publicwhip/person/10179 5 2003-12-04-80ef1083-10179-0
21a6e62f8cc319a5ff4fb7f9a9c86461412db7d6 26-28 September 2003, to Oman as guest of the Government (Registered 29 September 2003) Overseas visits 80ef1083 2003-12-04 Alan Duncan uk.org.publicwhip/member/867 Alan Duncan uk.org.publicwhip/person/10179 6 2003-12-04-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");