items

Table actions

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

3 rows where record_id = "2002-11-26-80ef1083-10045-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
daeaa83e796dd10b5b12707051616d774d501ab7 2-10 February 2002, to Japan for a conference with Japanese Parliamentarians. Half of the cost was met by the Japanese Government and half by the British Government. (Registered 8 March 2002) Overseas visits 80ef1083 2002-11-26 Clive Betts uk.org.publicwhip/member/734 Clive Betts uk.org.publicwhip/person/10045 0 2002-11-26-80ef1083-10045-0
032e48b24e7ea3a57231275dcba0f99ac3005b29 4-6 May 2002, to Qatar, on behalf of the Council for the Advancement of Arab British Understanding, to meet Prime Minister and other Government representatives. Return flight and accommodation paid for by the State of Qatar. (Registered 20 October 2002) Overseas visits 80ef1083 2002-11-26 Clive Betts uk.org.publicwhip/member/734 Clive Betts uk.org.publicwhip/person/10045 1 2002-11-26-80ef1083-10045-0
c7ea9741249f5e11865d30890439b943a91a7f6a 28 May-8 June 2002, to Japan as a member of the Parliamentary Football Club, with a contribution towards the cost of the trip from Nomura Bank, First Group, T-Mobile and Waterfront Properties; hospitality and transport provided by Nomura Bank, transport by First Group; sports kit by Nike; and suits and accessories at discounted price by Burtons. (Registered 20 October 2002) Overseas visits 80ef1083 2002-11-26 Clive Betts uk.org.publicwhip/member/734 Clive Betts uk.org.publicwhip/person/10045 2 2002-11-26-80ef1083-10045-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");