items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
18 rows where "date" is on date 2014-06-02 and person_id = "uk.org.publicwhip/person/10106" sorted by date
This data as json, CSV (advanced)
Suggested facets: category_id, sort_order, record_id
hash | item | category_id | date ▼ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
d0e55c37ba0f2464a2474b8f2e16f41ce4de3a77 | Member of Lloyd's. (Resigned 31 December 1994.) | Remunerated employment, office, profession etc. 0a4a155f | 2014-06-02 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 0 | 2014-06-02-0a4a155f-10106-0 |
a0cbd4e8c19bae903e51571e844dca86bfaf7ac9 | Categories of business underwritten for open years: All. | Remunerated employment, office, profession etc. 0a4a155f | 2014-06-02 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 1 | 2014-06-02-0a4a155f-10106-0 |
f710b3bf27d4e824d73d3fcc57c54fc1c0c127f1 | Amount of donation (or estimate of the probable value): flights, accommodation etc; total value £1,200 | Overseas visits 80ef1083 | 2014-06-02 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 3 | 2014-06-02-80ef1083-10106-0 |
87bcd1dd9ddb1a89f8c265fece8d85008419272a | Destination of visit: Israel | Overseas visits 80ef1083 | 2014-06-02 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 4 | 2014-06-02-80ef1083-10106-0 |
a639b7b7bb3944a899ef4a01f21138cee232dde2 | Date of visit: 10-13 March 2014 | Overseas visits 80ef1083 | 2014-06-02 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 5 | 2014-06-02-80ef1083-10106-0 |
228a8ff0941b4929d35061600cdbaab9b2eca921 | Purpose of visit: political delegation to Israel | Overseas visits 80ef1083 | 2014-06-02 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 6 | 2014-06-02-80ef1083-10106-0 |
9d89abe08468b57f01f0c26a4d6104b89cbe0b6a | (Registered 19 March 2014) | Overseas visits 80ef1083 | 2014-06-02 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 7 | 2014-06-02-80ef1083-10106-0 |
ee43e435dbc7c84bbde0fe1d3708070642735752 | Name of donor: Conservative Friends of Israel | Overseas visits 80ef1083 | 2014-06-02 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 8 | 2014-06-02-80ef1083-10106-0 |
c42233b1b1739095f7b3f5268ac56841010e66b9 | Address of donor: c/o Shelley Stock Hunter LLP, 7-10 Chandos St, London | Overseas visits 80ef1083 | 2014-06-02 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 9 | 2014-06-02-80ef1083-10106-0 |
ef7be3256829ecb18e6e8225dd7fb87e7be072de | W1G 9DG | Overseas visits 80ef1083 | 2014-06-02 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 10 | 2014-06-02-80ef1083-10106-0 |
67dccfd3628d1ce7aa7e5a50084624d4c60bff2a | Amount of donation (or estimate of the probable value): £2,000 | Overseas visits 80ef1083 | 2014-06-02 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 11 | 2014-06-02-80ef1083-10106-0 |
717e4b2ca27a6471a7a7f543f9805e17524bb753 | Destination of visit: Israel and the West Bank | Overseas visits 80ef1083 | 2014-06-02 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 12 | 2014-06-02-80ef1083-10106-0 |
40e2ee868e73771cd735f05f105197880add8678 | Date of visit: 16-21 February 2014 | Overseas visits 80ef1083 | 2014-06-02 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 13 | 2014-06-02-80ef1083-10106-0 |
fbac0998de8888b8f1371f5f3cf2d91dc1726ba5 | Purpose of visit: fact finding political delegation | Overseas visits 80ef1083 | 2014-06-02 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 14 | 2014-06-02-80ef1083-10106-0 |
65b6ac52a50a2939f903d0ba09e7fed1aff39013 | (Registered 21 March 2014) | Overseas visits 80ef1083 | 2014-06-02 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 15 | 2014-06-02-80ef1083-10106-0 |
880844d47d2ffa3d98b5cd41e840f8b3c00d5bf1 | 27 acres of farmland, and a cricket pitch let out on a peppercorn rent, in Patrington, East Yorkshire, from which rental income is received. | Land and Property 4f1e6359 | 2014-06-02 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 0 | 2014-06-02-4f1e6359-10106-0 |
068f220f7917062c344a1528a32aea983c3ae748 | 29 rented houses in East Yorkshire, five of which are registered in joint names with my wife. (Updated 29 August 2013; updated 27 November 2013 and 21 March 2014) | Land and Property 4f1e6359 | 2014-06-02 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 1 | 2014-06-02-4f1e6359-10106-0 |
af5832521e3bdd40dd6cce7d01cf012d02bd9605 | Barrister, not undertaking work. | Miscellaneous 5f2cbd10 | 2014-06-02 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 0 | 2014-06-02-5f2cbd10-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");