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

16 rows where person_id = "uk.org.publicwhip/person/10093" sorted by date descending

View and edit SQL

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

hash item category_id date ▲ member_id person_id sort_order record_id
345c0c1dd13e1f50c515a88f8f2b0a7ac7db3d6b Leasehold property for the purpose of hairdressing business. Land and Property 4f1e6359 2002-05-14 Ivor Caplin uk.org.publicwhip/member/784 Ivor Caplin uk.org.publicwhip/person/10093 0 2002-05-14-4f1e6359-10093-0
17ee3a3eca3993ce82975856a4fe7931d7d2f495 Trustee, Old Market Trust, Brunswick, Hove. Miscellaneous and unremunerated interests 265f2269 2002-05-14 Ivor Caplin uk.org.publicwhip/member/784 Ivor Caplin uk.org.publicwhip/person/10093 0 2002-05-14-265f2269-10093-0
13ada0ac2c7f2647f445a538f280afed032060c6 Member of Political Opinion Panel of BPRI (Business Planning and Research International). Remunerated employment, office, profession etc 1f359ece 2001-05-14 Ivor Caplin uk.org.publicwhip/member/93 Ivor Caplin uk.org.publicwhip/person/10093 0 2001-05-14-1f359ece-10093-0
102bc6b4dca7fa8f65b627cd957bd63b20dac28a Harris Parliamentary Panel. Remunerated employment, office, profession etc 1f359ece 2001-05-14 Ivor Caplin uk.org.publicwhip/member/93 Ivor Caplin uk.org.publicwhip/person/10093 1 2001-05-14-1f359ece-10093-0
1442fdd7d268ed2eab09088a23983bf66a1583e8 MORI Pariamentary Panel. Remunerated employment, office, profession etc 1f359ece 2001-05-14 Ivor Caplin uk.org.publicwhip/member/93 Ivor Caplin uk.org.publicwhip/person/10093 2 2001-05-14-1f359ece-10093-0
4b94159094a1092dfd205f920fc8bf454a0e0cc5 All fees received from the above are donated to Hove Constituency Labour Party. Remunerated employment, office, profession etc 1f359ece 2001-05-14 Ivor Caplin uk.org.publicwhip/member/93 Ivor Caplin uk.org.publicwhip/person/10093 3 2001-05-14-1f359ece-10093-0
21d1493486efccf9857f324b53074d6d40e3207d Leasehold property for the purpose of hairdressing business. Land and Property 4f1e6359 2001-05-14 Ivor Caplin uk.org.publicwhip/member/93 Ivor Caplin uk.org.publicwhip/person/10093 0 2001-05-14-4f1e6359-10093-0
0d48a697285ec51e1e663b7523265205ffe4daf6 Trustee, Old Market Trust, Brunswick, Hove. Miscellaneous and unremunerated interests 265f2269 2001-05-14 Ivor Caplin uk.org.publicwhip/member/93 Ivor Caplin uk.org.publicwhip/person/10093 0 2001-05-14-265f2269-10093-0
e852883715f209b82e32f22fc261f502e4082489 Member of Political Opinion Panel of BPRI (Business Planning and Research International). Remunerated employment, office, profession etc 1f359ece 2000-11-10 Ivor Caplin uk.org.publicwhip/member/93 Ivor Caplin uk.org.publicwhip/person/10093 0 2000-11-10-1f359ece-10093-0
0a400ca9c13fe76df6ac041de98ea77af1acd33a Harris Parliamentary Panel. Remunerated employment, office, profession etc 1f359ece 2000-11-10 Ivor Caplin uk.org.publicwhip/member/93 Ivor Caplin uk.org.publicwhip/person/10093 1 2000-11-10-1f359ece-10093-0
cbb413fd82018801d356f6ff9059d552af8b25eb MORI Pariamentary Panel. Remunerated employment, office, profession etc 1f359ece 2000-11-10 Ivor Caplin uk.org.publicwhip/member/93 Ivor Caplin uk.org.publicwhip/person/10093 2 2000-11-10-1f359ece-10093-0
e5189a136e0a3b3878e48818049dc36808b9e66e All fees received from the above are donated to Hove Constituency Labour Party. Remunerated employment, office, profession etc 1f359ece 2000-11-10 Ivor Caplin uk.org.publicwhip/member/93 Ivor Caplin uk.org.publicwhip/person/10093 3 2000-11-10-1f359ece-10093-0
9ead43fe825fe85a085487e7fb4e72fa14fef437 10-13 September 1999, to Lisbon, Portugal, representing the Parliamentary Football Club in a European Parliament football tournament funded by the Government of Portugal and National Express UK. (Registered 3 December 1999) Overseas visits 80ef1083 2000-11-10 Ivor Caplin uk.org.publicwhip/member/93 Ivor Caplin uk.org.publicwhip/person/10093 0 2000-11-10-80ef1083-10093-0
28158e20033ed49b1bad1570cc6013e766cb896e 3-8 October 1999, to Israel and the Palestinian Authority with the Labour Friends of Israel to meet senior Israeli and Palestinian leaders in the Middle East peace process. Flight and accommodation paid for by Labour Friends of Israel. (Registered 3 December 1999) Overseas visits 80ef1083 2000-11-10 Ivor Caplin uk.org.publicwhip/member/93 Ivor Caplin uk.org.publicwhip/person/10093 1 2000-11-10-80ef1083-10093-0
f517e616f325120aebb19c2932a076565a7fb552 Leasehold property for the purpose of hairdressing business. Land and Property 4f1e6359 2000-11-10 Ivor Caplin uk.org.publicwhip/member/93 Ivor Caplin uk.org.publicwhip/person/10093 0 2000-11-10-4f1e6359-10093-0
14426f2566a9b6cb86d317c74418ba02aaa35980 Trustee, Old Market Trust, Brunswick, Hove. Miscellaneous and unremunerated interests 265f2269 2000-11-10 Ivor Caplin uk.org.publicwhip/member/93 Ivor Caplin uk.org.publicwhip/person/10093 0 2000-11-10-265f2269-10093-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");