items

Table actions

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

3 rows where record_id = "2005-01-28-80ef1083-10010-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
4298043abbbc8fb8db95eb3456e3b176295dd555 13-19 February 2004, to Afghanistan, Georgia and Turkey. The cost of my flights and one night's hotel accommodation in Istanbul was provided by Flying Lion Ltd. Other accommodation, local transport and dinners were provided by the respective British Embassies. (Registered 23 February 2004) Overseas visits 80ef1083 2005-01-28 Michael Ancram uk.org.publicwhip/member/697 Michael Ancram uk.org.publicwhip/person/10010 0 2005-01-28-80ef1083-10010-0
dbb1a63cdc6ea928791bb1ce2ea374c1a70e800b 1-4 November 2004, to Cuba at the invitation of the Cuban Foreign Minister. En-route I visited the Turks & Caicos Islands, St Kitts &Nevis and Grand Cayman. The cost of my flights and one night's hotel accommodation in Turks & Caicos was provided by Flying Lion Ltd. (Other accommodation was provided by the UK Ambassador in Havana.) (Registered 9 December 2004) Overseas visits 80ef1083 2005-01-28 Michael Ancram uk.org.publicwhip/member/697 Michael Ancram uk.org.publicwhip/person/10010 1 2005-01-28-80ef1083-10010-0
ba6000d0388ea41e9a40056a6b23457ef6e512ea 5-8 December 2004, to Egypt and Israel. The cost of my flights and two nights' hotel accommodation in Jerusalem was provided by Flying Lion Ltd. (Other accommodation was provided by the UK Ambassador in Cairo.) (Registered 9 December 2004) Overseas visits 80ef1083 2005-01-28 Michael Ancram uk.org.publicwhip/member/697 Michael Ancram uk.org.publicwhip/person/10010 2 2005-01-28-80ef1083-10010-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");