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

10 rows where member_id = "uk.org.publicwhip/member/103" sorted by date descending

View and edit SQL

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
ab4385a7bfed2b5a0bf077d3f2cb4fc9aeb4ce3f Carclew Limited; small private company which provides business consultancy services but excludes advice on parliamentary or public affairs. Remunerated directorships ead1ca87 2001-05-14 Christopher Chope uk.org.publicwhip/member/103 Christopher Chope uk.org.publicwhip/person/10103 0 2001-05-14-ead1ca87-10103-0
a16f274927ae114844e78eb24d7d20d0b973ce03 I am a barrister, currently non-practising. Remunerated employment, office, profession etc 1f359ece 2001-05-14 Christopher Chope uk.org.publicwhip/member/103 Christopher Chope uk.org.publicwhip/person/10103 0 2001-05-14-1f359ece-10103-0
33e861e49f97f59f51daeec4dbbc5f157fbe577c Occasional broadcasting and journalism. Remunerated employment, office, profession etc 1f359ece 2001-05-14 Christopher Chope uk.org.publicwhip/member/103 Christopher Chope uk.org.publicwhip/person/10103 1 2001-05-14-1f359ece-10103-0
58935246767f7152e7106a535a996459695a9458 Carclew Limited. Registrable shareholdings 3aff2389 2001-05-14 Christopher Chope uk.org.publicwhip/member/103 Christopher Chope uk.org.publicwhip/person/10103 0 2001-05-14-3aff2389-10103-0
a5913c2215201f18e5d87075cb5ae5efa502969f Carclew Limited; small private company which provides business consultancy services but excludes advice on parliamentary or public affairs. Remunerated directorships ead1ca87 2000-11-10 Christopher Chope uk.org.publicwhip/member/103 Christopher Chope uk.org.publicwhip/person/10103 0 2000-11-10-ead1ca87-10103-0
e5e003636cc4b605eda9365045683fdd16249b5c I am a barrister, currently non-practising. Remunerated employment, office, profession etc 1f359ece 2000-11-10 Christopher Chope uk.org.publicwhip/member/103 Christopher Chope uk.org.publicwhip/person/10103 0 2000-11-10-1f359ece-10103-0
8f236027948052b11126cef4bbed2d09be54d2b5 Occasional broadcasting and journalism. Remunerated employment, office, profession etc 1f359ece 2000-11-10 Christopher Chope uk.org.publicwhip/member/103 Christopher Chope uk.org.publicwhip/person/10103 1 2000-11-10-1f359ece-10103-0
7a6946fc863d64992e37984f21f6adf412a96f3b 24 May-1 June 1999, study visit to Japan with the Parliamentary Information Technology Committee. Travel funded by the Committee with accommodation and hospitality provided partly by PITCOM Corporate members ICL/Fujitsu and Toshiba. (Registered 25 June 1999) Overseas visits 80ef1083 2000-11-10 Christopher Chope uk.org.publicwhip/member/103 Christopher Chope uk.org.publicwhip/person/10103 0 2000-11-10-80ef1083-10103-0
92e5ad07e9c5c9fde06164f4e9245e62aa8c09f6 15-16 June 1999, Parliamentary Space Committee visit to Paris Air Show for meetings with European Space Agency and EUTELSAT. Travel and accommodation provided by UK Industrial Space Committee. (Registered 25 June 1999) Overseas visits 80ef1083 2000-11-10 Christopher Chope uk.org.publicwhip/member/103 Christopher Chope uk.org.publicwhip/person/10103 1 2000-11-10-80ef1083-10103-0
e7cdf9d3cbf5821d805850ad5b7cde9652cc6f3d Carclew Limited. Registrable shareholdings 3aff2389 2000-11-10 Christopher Chope uk.org.publicwhip/member/103 Christopher Chope uk.org.publicwhip/person/10103 0 2000-11-10-3aff2389-10103-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");