items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
20 rows where member_id = "uk.org.publicwhip/member/106" sorted by date descending
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 |
---|---|---|---|---|---|---|---|
a58fff2afa67ad5a471a9a84f73828329ce08737 | L. Clappison Limited; plant-hire, contracting and agricultural company: no longer actively trading. | Remunerated directorships ead1ca87 | 2001-05-14 | James Clappison uk.org.publicwhip/member/106 | James Clappison uk.org.publicwhip/person/10106 | 0 | 2001-05-14-ead1ca87-10106-0 |
ba563b6eac0503a92e776735782b028b9369ccc4 | Barrister. | Remunerated employment, office, profession etc. 0a4a155f | 2001-05-14 | James Clappison uk.org.publicwhip/member/106 | James Clappison uk.org.publicwhip/person/10106 | 0 | 2001-05-14-0a4a155f-10106-0 |
2850439cba12f359a34ee66e70d10230f7ad7f72 | Farmer: 90 acres. | Remunerated employment, office, profession etc. 0a4a155f | 2001-05-14 | James Clappison uk.org.publicwhip/member/106 | James Clappison uk.org.publicwhip/person/10106 | 1 | 2001-05-14-0a4a155f-10106-0 |
b93a8745f2bf5f69ceef4abd5998420fb696a969 | Member of Lloyd's. (Resigned 31 December 1994.) | Remunerated employment, office, profession etc. 0a4a155f | 2001-05-14 | James Clappison uk.org.publicwhip/member/106 | James Clappison uk.org.publicwhip/person/10106 | 2 | 2001-05-14-0a4a155f-10106-0 |
fb9fae9239f88fe10c5b5998b141e19825dbc857 | Categories of business underwritten for open years: All. | Remunerated employment, office, profession etc. 0a4a155f | 2001-05-14 | James Clappison uk.org.publicwhip/member/106 | James Clappison uk.org.publicwhip/person/10106 | 3 | 2001-05-14-0a4a155f-10106-0 |
b8e95dab928831dd87770cd2a65f44b663bb8fd7 | In connection with my front bench duties I receive assistance on tax computations from an individual employed by KPMG. | Sponsorship or financial or material support 9e46def6 | 2001-05-14 | James Clappison uk.org.publicwhip/member/106 | James Clappison uk.org.publicwhip/person/10106 | 0 | 2001-05-14-9e46def6-10106-0 |
0c90c03a09ae1cab917b0c810b21be47fcbb557a | 16-23 January 2000, to Israel and the Palestinian Authority as a guest of the Israeli Government, Conservative Friends of Israel and Isrotel. (Registered 21 March 2000) | Overseas visits 80ef1083 | 2001-05-14 | James Clappison uk.org.publicwhip/member/106 | James Clappison uk.org.publicwhip/person/10106 | 0 | 2001-05-14-80ef1083-10106-0 |
2eb0ca5d640a71cc38158988c1264b1dc1b74c05 | 25-27 November 2000, to Israel and the Palestinian Authority as a guest of United Jewish Israel Appeal (UJIA). (Registered 13 December 2000) | Overseas visits 80ef1083 | 2001-05-14 | James Clappison uk.org.publicwhip/member/106 | James Clappison uk.org.publicwhip/person/10106 | 1 | 2001-05-14-80ef1083-10106-0 |
ad6e25804cedf5fada0077e6e1582c40d7e1879a | Five rented houses in Patrington and two in Withernsea, North Humberside. | Land and Property 4f1e6359 | 2001-05-14 | James Clappison uk.org.publicwhip/member/106 | James Clappison uk.org.publicwhip/person/10106 | 0 | 2001-05-14-4f1e6359-10106-0 |
12e35c91c437e4129f1195f11e79383916ad1a27 | Rented shop (small hairdresser's) in Patrington, North Humberside. | Land and Property 4f1e6359 | 2001-05-14 | James Clappison uk.org.publicwhip/member/106 | James Clappison uk.org.publicwhip/person/10106 | 1 | 2001-05-14-4f1e6359-10106-0 |
a3183251703fd658a24ce7aa1f52321cc64e536b | L. Clappison Limited. (as from April 1992). | Registrable shareholdings 3aff2389 | 2001-05-14 | James Clappison uk.org.publicwhip/member/106 | James Clappison uk.org.publicwhip/person/10106 | 0 | 2001-05-14-3aff2389-10106-0 |
c2f9bd8a69b58ede49a8eee3350f09ef802b8265 | L. Clappison Limited; plant-hire, contracting and agricultural company: no longer actively trading. | Remunerated directorships ead1ca87 | 2000-11-10 | James Clappison uk.org.publicwhip/member/106 | James Clappison uk.org.publicwhip/person/10106 | 0 | 2000-11-10-ead1ca87-10106-0 |
656dffb4fc4145c2d514c4a720196c5ee5fb67f8 | Barrister. | Remunerated employment, office, profession etc. 0a4a155f | 2000-11-10 | James Clappison uk.org.publicwhip/member/106 | James Clappison uk.org.publicwhip/person/10106 | 0 | 2000-11-10-0a4a155f-10106-0 |
be2f6d39f4b43d2140c37c8e7fe2506d271e03e2 | Farmer: 90 acres. | Remunerated employment, office, profession etc. 0a4a155f | 2000-11-10 | James Clappison uk.org.publicwhip/member/106 | James Clappison uk.org.publicwhip/person/10106 | 1 | 2000-11-10-0a4a155f-10106-0 |
19a11612ef195d28b3717adffc649047d8f5ce30 | Member of Lloyd's. (Resigned 31 December 1994.) | Remunerated employment, office, profession etc. 0a4a155f | 2000-11-10 | James Clappison uk.org.publicwhip/member/106 | James Clappison uk.org.publicwhip/person/10106 | 2 | 2000-11-10-0a4a155f-10106-0 |
3cf63d8aec37fc46de3e3fab644d6b6ed3c3865d | Categories of business underwritten for open years: All. | Remunerated employment, office, profession etc. 0a4a155f | 2000-11-10 | James Clappison uk.org.publicwhip/member/106 | James Clappison uk.org.publicwhip/person/10106 | 3 | 2000-11-10-0a4a155f-10106-0 |
170b21fe629140d9b75079428fe50906de186108 | 16-23 January 2000, to Israel and the Palestinian Authority as a guest of the Israeli Government, Conservative Friends of Israel and Isrotel. (Registered 21 March 2000) | Overseas visits 80ef1083 | 2000-11-10 | James Clappison uk.org.publicwhip/member/106 | James Clappison uk.org.publicwhip/person/10106 | 0 | 2000-11-10-80ef1083-10106-0 |
419967cda08273c9f465e31fa02de1ccfc28c63c | Five rented houses in Patrington and one in Withernsea, North Humberside. | Land and Property 4f1e6359 | 2000-11-10 | James Clappison uk.org.publicwhip/member/106 | James Clappison uk.org.publicwhip/person/10106 | 0 | 2000-11-10-4f1e6359-10106-0 |
020f72d2209f192f8475ffd1a2c938bf0cb2728a | Rented shop (small hairdresser's) in Patrington, North Humberside. | Land and Property 4f1e6359 | 2000-11-10 | James Clappison uk.org.publicwhip/member/106 | James Clappison uk.org.publicwhip/person/10106 | 1 | 2000-11-10-4f1e6359-10106-0 |
f75e90b8e6a952e47eb257ac3478f17425e1c0b4 | L. Clappison Limited. (as from April 1992). | Registrable shareholdings 3aff2389 | 2000-11-10 | James Clappison uk.org.publicwhip/member/106 | James Clappison uk.org.publicwhip/person/10106 | 0 | 2000-11-10-3aff2389-10106-0 |
Advanced export
JSON shape: default, array, newline-delimited, object
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");