items

Table actions

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

4 rows where member_id = "uk.org.publicwhip/member/778" sorted by date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: category_id, date, date (date)

hash item category_id date ▲ member_id person_id sort_order record_id
22a0a8583f94d741a94e143dab4e845588533bdd 18-26 November 2004, to the Falkland Islands. Travel and accommodation paid for by the Government of the Falkland Islands. (Registered 22 March 2005) Overseas visits 80ef1083 2005-04-11 Alan Campbell uk.org.publicwhip/member/778 Alan Campbell uk.org.publicwhip/person/10086 0 2005-04-11-80ef1083-10086-0
0f8858447c18c5c41fff7350b73efc72a5c1477f Chairman of the North East Maritime and Offshore Cluster (NEMOC); a cluster of companies working in the shipbuilding, ship repair and offshore sector. (£5,001-£10,000) Remunerated employment, office, profession etc 1f359ece 2002-11-26 Alan Campbell uk.org.publicwhip/member/778 Alan Campbell uk.org.publicwhip/person/10086 0 2002-11-26-1f359ece-10086-0
3ffd83f7b4bd1b356f8565fd66b023cfbe97b369 Chairman of the North East Maritime and Offshore Cluster (NEMOC); a cluster of companies working in the shipbuilding, ship repair and offshore sector. (£5,001-£10,000) Remunerated employment, office, profession etc 1f359ece 2002-05-14 Alan Campbell uk.org.publicwhip/member/778 Alan Campbell uk.org.publicwhip/person/10086 0 2002-05-14-1f359ece-10086-0
28a581db0417ab0ece87c5484e584482db2a748f 10-13 September 2001, to Lyons, Port Bou and Barcelona, paid for by the Rail Freight Group who met costs of travel, accommodation and food. (Registered 15 October 2001) Overseas visits 80ef1083 2002-05-14 Alan Campbell uk.org.publicwhip/member/778 Alan Campbell uk.org.publicwhip/person/10086 0 2002-05-14-80ef1083-10086-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");