items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
34 rows where member_id = "uk.org.publicwhip/member/1103" 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 |
---|---|---|---|---|---|---|---|
cd1b32772f0b5c31d487fec1736f30370da0105c | Chairman, Haylandale Ltd. (no parliamentary involvement); property development in the W. Indies. | Remunerated directorships ead1ca87 | 2005-04-11 | Michael Mates uk.org.publicwhip/member/1103 | Michael Mates uk.org.publicwhip/person/10422 | 0 | 2005-04-11-ead1ca87-10422-0 |
26ffce0b3d805725a9d37bef7e72878be191398a | Adviser on defence matters (no parliamentary involvement) to ABS Aircraft AG; a Swiss company manufacturing hovercraft. | Remunerated employment, office, profession etc 1f359ece | 2005-04-11 | Michael Mates uk.org.publicwhip/member/1103 | Michael Mates uk.org.publicwhip/person/10422 | 0 | 2005-04-11-1f359ece-10422-0 |
94a84f9e4c3c7d027dcef45047d72a028b32b382 | Parliamentary adviser to Siebel Systems UK Ltd; provider of customer relationship management solutions. (Up to £5,000) | Remunerated employment, office, profession etc 1f359ece | 2005-04-11 | Michael Mates uk.org.publicwhip/member/1103 | Michael Mates uk.org.publicwhip/person/10422 | 1 | 2005-04-11-1f359ece-10422-0 |
a9ccef4d4d55dc936eb93b797691070346fe53a8 | Honorary adviser to the Royal British Legion (unremunerated). | Miscellaneous and unremunerated interests 265f2269 | 2005-04-11 | Michael Mates uk.org.publicwhip/member/1103 | Michael Mates uk.org.publicwhip/person/10422 | 0 | 2005-04-11-265f2269-10422-0 |
d4386150152c43b41db19081fdfbe23f66245b10 | Chairman, Haylandale Ltd. (no parliamentary involvement); property development in the W. Indies. | Remunerated directorships ead1ca87 | 2005-01-28 | Michael Mates uk.org.publicwhip/member/1103 | Michael Mates uk.org.publicwhip/person/10422 | 0 | 2005-01-28-ead1ca87-10422-0 |
a516af03181200c915ed023d7009bff528c2e352 | Adviser on defence matters (no parliamentary involvement) to ABS Aircraft AG; a Swiss company manufacturing hovercraft. | Remunerated employment, office, profession etc.. 12405e8c | 2005-01-28 | Michael Mates uk.org.publicwhip/member/1103 | Michael Mates uk.org.publicwhip/person/10422 | 0 | 2005-01-28-12405e8c-10422-0 |
f8fcf312b68aeace36b93c8bdd1ae31feaed2825 | Parliamentary adviser to Siebel Systems UK Ltd; provider of customer relationship management solutions. (Up to £5,000) | Remunerated employment, office, profession etc.. 12405e8c | 2005-01-28 | Michael Mates uk.org.publicwhip/member/1103 | Michael Mates uk.org.publicwhip/person/10422 | 1 | 2005-01-28-12405e8c-10422-0 |
b331b128f9030c04321abadd720b19740a835d5c | Honorary adviser to the Royal British Legion (unremunerated). | Miscellaneous and unremunerated interests 265f2269 | 2005-01-28 | Michael Mates uk.org.publicwhip/member/1103 | Michael Mates uk.org.publicwhip/person/10422 | 0 | 2005-01-28-265f2269-10422-0 |
02be130bd1deb103fda3cf87ec31141236a20caa | Adviser on defence matters (no parliamentary involvement) to ABS Aircraft AG; a Swiss company manufacturing hovercraft. | Remunerated employment, office, profession etc 1f359ece | 2004-12-03 | Michael Mates uk.org.publicwhip/member/1103 | Michael Mates uk.org.publicwhip/person/10422 | 0 | 2004-12-03-1f359ece-10422-0 |
c547d4338b8b7010790fff9d37939d754d14a4ba | Parliamentary adviser to Siebel Systems UK Ltd; provider of customer relationship management solutions. (Up to £5,000) | Remunerated employment, office, profession etc 1f359ece | 2004-12-03 | Michael Mates uk.org.publicwhip/member/1103 | Michael Mates uk.org.publicwhip/person/10422 | 1 | 2004-12-03-1f359ece-10422-0 |
1cd0b352d43dab4e4565bafb2aa98578dcb497fd | Honorary adviser to the Royal British Legion (unremunerated). | Miscellaneous and unremunerated interests 265f2269 | 2004-12-03 | Michael Mates uk.org.publicwhip/member/1103 | Michael Mates uk.org.publicwhip/person/10422 | 0 | 2004-12-03-265f2269-10422-0 |
f7a17806def21ff19b8a8815745913eaf603b024 | Adviser on defence matters (no parliamentary involvement) to ABS Aircraft AG; a Swiss company manufacturing hovercraft. | Remunerated employment, office, profession etc 1f359ece | 2004-10-22 | Michael Mates uk.org.publicwhip/member/1103 | Michael Mates uk.org.publicwhip/person/10422 | 0 | 2004-10-22-1f359ece-10422-0 |
648072563f24377a47e96664a647208aefaa52a6 | Parliamentary adviser to Siebel Systems UK Ltd; provider of customer relationship management solutions. (Up to £5,000) | Remunerated employment, office, profession etc 1f359ece | 2004-10-22 | Michael Mates uk.org.publicwhip/member/1103 | Michael Mates uk.org.publicwhip/person/10422 | 1 | 2004-10-22-1f359ece-10422-0 |
05c902c9935f0cb064cee289d00cb1dbaf621175 | Honorary adviser to the Royal British Legion (unremunerated). | Miscellaneous and unremunerated interests 265f2269 | 2004-10-22 | Michael Mates uk.org.publicwhip/member/1103 | Michael Mates uk.org.publicwhip/person/10422 | 0 | 2004-10-22-265f2269-10422-0 |
7476d43277e3ff6afee6a92668fcbf924b4bd97b | Adviser on defence matters (no parliamentary involvement) to ABS Aircraft AG; a Swiss company manufacturing hovercraft. | Remunerated employment, office, profession etc 1f359ece | 2004-09-08 | Michael Mates uk.org.publicwhip/member/1103 | Michael Mates uk.org.publicwhip/person/10422 | 0 | 2004-09-08-1f359ece-10422-0 |
b789d977225045d5d4b996eeb3e97e4e94b6a5d1 | Parliamentary adviser to Siebel Systems UK Ltd; provider of customer relationship management solutions. (Up to £5,000) | Remunerated employment, office, profession etc 1f359ece | 2004-09-08 | Michael Mates uk.org.publicwhip/member/1103 | Michael Mates uk.org.publicwhip/person/10422 | 1 | 2004-09-08-1f359ece-10422-0 |
87c2a0fe6fa3a495b8bd8417d67809ae26d94008 | Honorary adviser to the Royal British Legion (unremunerated). | Miscellaneous and unremunerated interests 265f2269 | 2004-09-08 | Michael Mates uk.org.publicwhip/member/1103 | Michael Mates uk.org.publicwhip/person/10422 | 0 | 2004-09-08-265f2269-10422-0 |
28a97c5c853507a7bb3d5745ce03801fe97b1520 | Adviser on defence matters (no parliamentary involvement) to ABS Aircraft AG; a Swiss company manufacturing hovercraft. | Remunerated employment, office, profession etc 1f359ece | 2004-07-16 | Michael Mates uk.org.publicwhip/member/1103 | Michael Mates uk.org.publicwhip/person/10422 | 0 | 2004-07-16-1f359ece-10422-0 |
fe0d9668c649d40661fdd74f3eb24b29c7ec384a | Parliamentary adviser to Siebel Systems UK Ltd; provider of customer relationship management solutions. (Up to £5,000) | Remunerated employment, office, profession etc 1f359ece | 2004-07-16 | Michael Mates uk.org.publicwhip/member/1103 | Michael Mates uk.org.publicwhip/person/10422 | 1 | 2004-07-16-1f359ece-10422-0 |
e1a8b329303d8b34eb29817548903879752c2a94 | Honorary adviser to the Royal British Legion (unremunerated). | Miscellaneous and unremunerated interests 265f2269 | 2004-07-16 | Michael Mates uk.org.publicwhip/member/1103 | Michael Mates uk.org.publicwhip/person/10422 | 0 | 2004-07-16-265f2269-10422-0 |
84a5442c5abe5e6ce1e7f7083a06957619923cb9 | Adviser on defence matters (no parliamentary involvement) to ABS Aircraft AG; a Swiss company manufacturing hovercraft. | Remunerated employment, office, profession etc 1f359ece | 2004-05-21 | Michael Mates uk.org.publicwhip/member/1103 | Michael Mates uk.org.publicwhip/person/10422 | 0 | 2004-05-21-1f359ece-10422-0 |
fda0df33a9674b38ce1705057ee28d879a6f3d05 | Honorary adviser to the Royal British Legion (unremunerated). | Miscellaneous and unremunerated interests 265f2269 | 2004-05-21 | Michael Mates uk.org.publicwhip/member/1103 | Michael Mates uk.org.publicwhip/person/10422 | 0 | 2004-05-21-265f2269-10422-0 |
1c0085e54fd1af0cae67dbcbfec415d455ecffc5 | Adviser on defence matters (no parliamentary involvement) to ABS Aircraft AG; a Swiss company manufacturing hovercraft. | Remunerated employment, office, profession etc 1f359ece | 2004-01-31 | Michael Mates uk.org.publicwhip/member/1103 | Michael Mates uk.org.publicwhip/person/10422 | 0 | 2004-01-31-1f359ece-10422-0 |
b6746d667113a72570a3ec1e8d258abb6b46ed19 | Honorary adviser to the Royal British Legion (unremunerated). | Miscellaneous and unremunerated interests 265f2269 | 2004-01-31 | Michael Mates uk.org.publicwhip/member/1103 | Michael Mates uk.org.publicwhip/person/10422 | 0 | 2004-01-31-265f2269-10422-0 |
94d5c11f5bcf8f69bf6d3cfd065ea99c7ab5a094 | Adviser on defence matters (no parliamentary involvement) to ABS Aircraft AG; a Swiss company manufacturing hovercraft. | Remunerated employment, office, profession etc 1f359ece | 2003-12-04 | Michael Mates uk.org.publicwhip/member/1103 | Michael Mates uk.org.publicwhip/person/10422 | 0 | 2003-12-04-1f359ece-10422-0 |
179bec353a93b4cd9abe68e5efa563036433fb61 | Honorary adviser to the Royal British Legion (unremunerated). | Miscellaneous and unremunerated interests 265f2269 | 2003-12-04 | Michael Mates uk.org.publicwhip/member/1103 | Michael Mates uk.org.publicwhip/person/10422 | 0 | 2003-12-04-265f2269-10422-0 |
17f9823f92c7cbee27d6039d14c355088505d3b1 | Parliamentary consultant to Smartlogik; a computer software company. (Up to £5,000) | Remunerated employment, office, profession etc 1f359ece | 2002-11-26 | Michael Mates uk.org.publicwhip/member/1103 | Michael Mates uk.org.publicwhip/person/10422 | 0 | 2002-11-26-1f359ece-10422-0 |
13ad892308b1cfcfbc4a3911d45f084565ba9488 | Adviser on defence matters (no parliamentary involvement) to ABS Aircraft AG; a Swiss company manufacturing hovercraft. | Remunerated employment, office, profession etc 1f359ece | 2002-11-26 | Michael Mates uk.org.publicwhip/member/1103 | Michael Mates uk.org.publicwhip/person/10422 | 1 | 2002-11-26-1f359ece-10422-0 |
3c104e406de825983e8c58adc5e76eb04f388968 | Honorary adviser to the Royal British Legion (unremunerated). | Miscellaneous and unremunerated interests 265f2269 | 2002-11-26 | Michael Mates uk.org.publicwhip/member/1103 | Michael Mates uk.org.publicwhip/person/10422 | 0 | 2002-11-26-265f2269-10422-0 |
0fdc8b76879bfed0c9069598b4f58b45fcc82ee1 | Parliamentary consultant to Smartlogik; a computer software company. (£1-£1,000) | Remunerated employment, office, profession etc 1f359ece | 2002-05-14 | Michael Mates uk.org.publicwhip/member/1103 | Michael Mates uk.org.publicwhip/person/10422 | 0 | 2002-05-14-1f359ece-10422-0 |
1e7ce6de1a9678c340d4f19fd6027eb6f2937697 | Adviser on defence matters (no parliamentary involvement) to ABS Aircraft AG; a Swiss company manufacturing hovercraft. | Remunerated employment, office, profession etc 1f359ece | 2002-05-14 | Michael Mates uk.org.publicwhip/member/1103 | Michael Mates uk.org.publicwhip/person/10422 | 1 | 2002-05-14-1f359ece-10422-0 |
5c6e6b8ff8644d0a508f69e529e122a5b3e4d790 | Member of Political Opinion Panel of BPRI (Business Planning and Research International). (£1-£1,000). The fees are donated directly to the Wessex Children's Hospice. | Remunerated employment, office, profession etc 1f359ece | 2002-05-14 | Michael Mates uk.org.publicwhip/member/1103 | Michael Mates uk.org.publicwhip/person/10422 | 2 | 2002-05-14-1f359ece-10422-0 |
c3f0a6a719bb2b4325af663a75037d080be83392 | Occasional broadcasting, journalism and lecturing. | Remunerated employment, office, profession etc 1f359ece | 2002-05-14 | Michael Mates uk.org.publicwhip/member/1103 | Michael Mates uk.org.publicwhip/person/10422 | 3 | 2002-05-14-1f359ece-10422-0 |
81a586f6429212731dfaf1f11953ff9095be192f | Honorary adviser to the Royal British Legion (unremunerated). | Miscellaneous and unremunerated interests 265f2269 | 2002-05-14 | Michael Mates uk.org.publicwhip/member/1103 | Michael Mates uk.org.publicwhip/person/10422 | 0 | 2002-05-14-265f2269-10422-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");