items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
22 rows where member_id = "uk.org.publicwhip/member/1268" 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 |
---|---|---|---|---|---|---|---|
c83915652c6bfa7bc2d686fb6f445cb596b3b3ba | International adviser to Mitsubishi Trust and Banking Corporation; a Japanese Trust Bank in both Japan and overseas. | Remunerated employment, office, profession, etc. f3967f4d | 2005-04-11 | Peter Tapsell uk.org.publicwhip/member/1268 | Peter Tapsell uk.org.publicwhip/person/10583 | 0 | 2005-04-11-f3967f4d-10583-0 |
5777bbc1eabfc60205e0b8c9ac9f845dd83feff6 | Member of the Business Advisory Council for United Nations Operations. | Remunerated employment, office, profession, etc. f3967f4d | 2005-04-11 | Peter Tapsell uk.org.publicwhip/member/1268 | Peter Tapsell uk.org.publicwhip/person/10583 | 1 | 2005-04-11-f3967f4d-10583-0 |
2713de2d3527060206f6f9bebf13692d1ad974bb | International adviser to Mitsubishi Trust and Banking Corporation; a Japanese Trust Bank in both Japan and overseas. | Remunerated employment, office, profession, etc.. dc69d097 | 2005-01-28 | Peter Tapsell uk.org.publicwhip/member/1268 | Peter Tapsell uk.org.publicwhip/person/10583 | 0 | 2005-01-28-dc69d097-10583-0 |
30d97a41bd73133280f280a5f28850a52ccebaea | Member of the Business Advisory Council for United Nations Operations. | Remunerated employment, office, profession, etc.. dc69d097 | 2005-01-28 | Peter Tapsell uk.org.publicwhip/member/1268 | Peter Tapsell uk.org.publicwhip/person/10583 | 1 | 2005-01-28-dc69d097-10583-0 |
a6a7dcbf1c1c13d5e348f2d60cc532e6942c7874 | International adviser to Mitsubishi Trust and Banking Corporation; a Japanese Trust Bank in both Japan and overseas. | Remunerated employment, office, profession, etc. f3967f4d | 2004-12-03 | Peter Tapsell uk.org.publicwhip/member/1268 | Peter Tapsell uk.org.publicwhip/person/10583 | 0 | 2004-12-03-f3967f4d-10583-0 |
ab24056cdead9bdb970c2de8af5c3fc9da249151 | Member of the Business Advisory Council for United Nations Operations. | Remunerated employment, office, profession, etc. f3967f4d | 2004-12-03 | Peter Tapsell uk.org.publicwhip/member/1268 | Peter Tapsell uk.org.publicwhip/person/10583 | 1 | 2004-12-03-f3967f4d-10583-0 |
78387068c4d37ad5303efa7c182f8b5443f2edb5 | International adviser to Mitsubishi Trust and Banking Corporation; a Japanese Trust Bank in both Japan and overseas. | Remunerated employment, office, profession, etc. f3967f4d | 2004-10-22 | Peter Tapsell uk.org.publicwhip/member/1268 | Peter Tapsell uk.org.publicwhip/person/10583 | 0 | 2004-10-22-f3967f4d-10583-0 |
4e83f8cbfdabb2ac337a096f5c227a5e36661d27 | Member of the Business Advisory Council for United Nations Operations. | Remunerated employment, office, profession, etc. f3967f4d | 2004-10-22 | Peter Tapsell uk.org.publicwhip/member/1268 | Peter Tapsell uk.org.publicwhip/person/10583 | 1 | 2004-10-22-f3967f4d-10583-0 |
3800950ac4c1c3e941cd6c3d0aa75c0a36c974a6 | International adviser to Mitsubishi Trust and Banking Corporation; a Japanese Trust Bank in both Japan and overseas. | Remunerated employment, office, profession, etc. f3967f4d | 2004-09-08 | Peter Tapsell uk.org.publicwhip/member/1268 | Peter Tapsell uk.org.publicwhip/person/10583 | 0 | 2004-09-08-f3967f4d-10583-0 |
b4c4dbce9eb8807e032f30a0531a21ecd53c7706 | Member of the Business Advisory Council for United Nations Operations. | Remunerated employment, office, profession, etc. f3967f4d | 2004-09-08 | Peter Tapsell uk.org.publicwhip/member/1268 | Peter Tapsell uk.org.publicwhip/person/10583 | 1 | 2004-09-08-f3967f4d-10583-0 |
cdaf34c19022e83f5e65c86808db6c9544243908 | International adviser to Mitsubishi Trust and Banking Corporation; a Japanese Trust Bank in both Japan and overseas. | Remunerated employment, office, profession, etc. f3967f4d | 2004-07-16 | Peter Tapsell uk.org.publicwhip/member/1268 | Peter Tapsell uk.org.publicwhip/person/10583 | 0 | 2004-07-16-f3967f4d-10583-0 |
39c1d0e3c8094a2a7e5ec10bed0b2df1753639bc | Member of the Business Advisory Council for United Nations Operations. | Remunerated employment, office, profession, etc. f3967f4d | 2004-07-16 | Peter Tapsell uk.org.publicwhip/member/1268 | Peter Tapsell uk.org.publicwhip/person/10583 | 1 | 2004-07-16-f3967f4d-10583-0 |
616c8e6230d09dd528e991587becd10ab2b2a9ec | International adviser to Mitsubishi Trust and Banking Corporation; a Japanese Trust Bank in both Japan and overseas. | Remunerated employment, office, profession, etc. f3967f4d | 2004-05-21 | Peter Tapsell uk.org.publicwhip/member/1268 | Peter Tapsell uk.org.publicwhip/person/10583 | 0 | 2004-05-21-f3967f4d-10583-0 |
ca84f4c1fec4853a5f05eb30017af10d740a060c | Member of the Business Advisory Council for United Nations Operations. | Remunerated employment, office, profession, etc. f3967f4d | 2004-05-21 | Peter Tapsell uk.org.publicwhip/member/1268 | Peter Tapsell uk.org.publicwhip/person/10583 | 1 | 2004-05-21-f3967f4d-10583-0 |
20eea15d6ea4fa9139a9719ba286cd17c5a54199 | International adviser to Mitsubishi Trust and Banking Corporation; a Japanese Trust Bank in both Japan and overseas. | Remunerated employment, office, profession, etc. f3967f4d | 2004-01-31 | Peter Tapsell uk.org.publicwhip/member/1268 | Peter Tapsell uk.org.publicwhip/person/10583 | 0 | 2004-01-31-f3967f4d-10583-0 |
9bc0a225766247259708dd77b2544969d4c8c0b7 | Member of the Business Advisory Council for United Nations Operations. | Remunerated employment, office, profession, etc. f3967f4d | 2004-01-31 | Peter Tapsell uk.org.publicwhip/member/1268 | Peter Tapsell uk.org.publicwhip/person/10583 | 1 | 2004-01-31-f3967f4d-10583-0 |
6b8cef8bac23a5ffe9e81512fffc67daa88d818d | International adviser to Mitsubishi Trust and Banking Corporation; a Japanese Trust Bank in both Japan and overseas. | Remunerated employment, office, profession, etc. f3967f4d | 2003-12-04 | Peter Tapsell uk.org.publicwhip/member/1268 | Peter Tapsell uk.org.publicwhip/person/10583 | 0 | 2003-12-04-f3967f4d-10583-0 |
e48994e721f1cc21bcaa964fd6fdca07aac00223 | Member of the Business Advisory Council for United Nations Operations. | Remunerated employment, office, profession, etc. f3967f4d | 2003-12-04 | Peter Tapsell uk.org.publicwhip/member/1268 | Peter Tapsell uk.org.publicwhip/person/10583 | 1 | 2003-12-04-f3967f4d-10583-0 |
8e027cea1fd60d4af60f2a8ed2934fc2b5c20a3f | International adviser to Mitsubishi Trust and Banking Corporation; a Japanese Trust Bank in both Japan and overseas. | Remunerated employment, office, profession etc 1f359ece | 2002-11-26 | Peter Tapsell uk.org.publicwhip/member/1268 | Peter Tapsell uk.org.publicwhip/person/10583 | 0 | 2002-11-26-1f359ece-10583-0 |
8a6d08aecd7b9518f3b6b085b2bcd1e2641f9b77 | Member of the Business Advisory Council for United Nations Operations. | Remunerated employment, office, profession etc 1f359ece | 2002-11-26 | Peter Tapsell uk.org.publicwhip/member/1268 | Peter Tapsell uk.org.publicwhip/person/10583 | 1 | 2002-11-26-1f359ece-10583-0 |
28d9dc081fa90f9a7949bfe13425a6f12bdb995b | International adviser to Mitsubishi Trust and Banking Corporation; a Japanese Trust Bank in both Japan and overseas. | Remunerated employment, office, profession, etc. f3967f4d | 2002-05-14 | Peter Tapsell uk.org.publicwhip/member/1268 | Peter Tapsell uk.org.publicwhip/person/10583 | 0 | 2002-05-14-f3967f4d-10583-0 |
60ea501dcabc4fdd9cecb7170aab69a7b47478ab | Member of the Business Advisory Council for United Nations Operations. | Remunerated employment, office, profession, etc. f3967f4d | 2002-05-14 | Peter Tapsell uk.org.publicwhip/member/1268 | Peter Tapsell uk.org.publicwhip/person/10583 | 1 | 2002-05-14-f3967f4d-10583-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");