items

Table actions

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

8 rows where member_id = "uk.org.publicwhip/member/1043" sorted by date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: item, category_id, date, sort_order, record_id, date (date)

hash item category_id date ▲ member_id person_id sort_order record_id
167f9bcc75c8447157743edd54004627f9a7351b 23 July-3 August 2004, to Mongolia, at the invitation of the Mongolian Parliament, to talk to MPs, civil servants and political parties about standards in public life, party organisation and the development of civil society. My hotel and hospitality was paid by the Mongolian Government; I paid for my own air fare. (Registered 11 October 2004) Overseas visits 80ef1083 2005-04-11 Tom Levitt uk.org.publicwhip/member/1043 Tom Levitt uk.org.publicwhip/person/10356 0 2005-04-11-80ef1083-10356-0
b806af7e35af97344c86a0847752d6ac43aadf8a 23 July-3 August 2004, to Mongolia, at the invitation of the Mongolian Parliament, to talk to MPs, civil servants and political parties about standards in public life, party organisation and the development of civil society. My hotel and hospitality was paid by the Mongolian Government; I paid for my own air fare. (Registered 11 October 2004) Overseas visits 80ef1083 2005-01-28 Tom Levitt uk.org.publicwhip/member/1043 Tom Levitt uk.org.publicwhip/person/10356 0 2005-01-28-80ef1083-10356-0
85c71e9c0c0d136627cbbe6355a202de3a4eeb29 23 July-3 August 2004, to Mongolia, at the invitation of the Mongolian Parliament, to talk to MPs, civil servants and political parties about standards in public life, party organisation and the development of civil society. My hotel and hospitality was paid by the Mongolian Government; I paid for my own air fare. (Registered 11 October 2004) Overseas visits 80ef1083 2004-12-03 Tom Levitt uk.org.publicwhip/member/1043 Tom Levitt uk.org.publicwhip/person/10356 0 2004-12-03-80ef1083-10356-0
2343253811cb3ad2227578957f49d14de418e96d 23 July-3 August 2004, to Mongolia, at the invitation of the Mongolian Parliament, to talk to MPs, civil servants and political parties about standards in public life, party organisation and the development of civil society. My hotel and hospitality was paid by the Mongolian Government; I paid for my own air fare. (Registered 11 October 2004) Overseas visits 80ef1083 2004-10-22 Tom Levitt uk.org.publicwhip/member/1043 Tom Levitt uk.org.publicwhip/person/10356 0 2004-10-22-80ef1083-10356-0
be8130f702e61f8f271bbb63f0371bd296580ce5 Member of Parliamentary panel for Opinion Leader Research. (£1-£1,000) Remunerated employment, office, profession etc 1f359ece 2002-05-14 Tom Levitt uk.org.publicwhip/member/1043 Tom Levitt uk.org.publicwhip/person/10356 0 2002-05-14-1f359ece-10356-0
ee81b900a2bccd5d61dbb19fbca528fa6b61ba4a Member of Harris Parliamentary Panel. (£1-£1,000) Remunerated employment, office, profession etc 1f359ece 2002-05-14 Tom Levitt uk.org.publicwhip/member/1043 Tom Levitt uk.org.publicwhip/person/10356 1 2002-05-14-1f359ece-10356-0
c0227debef38dfdd8a76a2d11a7ef425b476fa89 Free provision of a web site and computing and marketing advice from Collective Enterprises Limited, a local management services company. Sponsorship or financial or material support 9e46def6 2002-05-14 Tom Levitt uk.org.publicwhip/member/1043 Tom Levitt uk.org.publicwhip/person/10356 0 2002-05-14-9e46def6-10356-0
e3da9e454b2d6743cf6b21b0a3a03cceeca54ecc Trustee of the Royal National Institute for Deaf People (unremunerated). Miscellaneous and unremunerated interests 265f2269 2002-05-14 Tom Levitt uk.org.publicwhip/member/1043 Tom Levitt uk.org.publicwhip/person/10356 0 2002-05-14-265f2269-10356-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");