items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
35 rows where member_id = "uk.org.publicwhip/member/771" 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 |
---|---|---|---|---|---|---|---|
e91c165e7caa096717f51f846237a3c69184fceb | Partner, Butterfill Associates (financial, corporate and real estate consultants). | Remunerated employment, office, profession etc 1f359ece | 2005-04-11 | John Butterfill uk.org.publicwhip/member/771 | John Butterfill uk.org.publicwhip/person/10082 | 0 | 2005-04-11-1f359ece-10082-0 |
6c577064472c429b77d08317b4fd3ae8a12f24e7 | Consultant to Curchod and Co. (Chartered Surveyors) (non-parliamentary). | Remunerated employment, office, profession etc 1f359ece | 2005-04-11 | John Butterfill uk.org.publicwhip/member/771 | John Butterfill uk.org.publicwhip/person/10082 | 1 | 2005-04-11-1f359ece-10082-0 |
83024f59b3774f3ac0557de05cf9053a232c1270 | I am a member of the Tyr Consortium which holds minerals exploration licences in Iceland (currently unremunerated). | Miscellaneous and unremunerated interests 265f2269 | 2005-04-11 | John Butterfill uk.org.publicwhip/member/771 | John Butterfill uk.org.publicwhip/person/10082 | 0 | 2005-04-11-265f2269-10082-0 |
2686f2808a55b5044b2c3665fe376faff135cddd | Partner, Butterfill Associates (financial, corporate and real estate consultants). | Remunerated employment, office, profession etc... 5177ae6a | 2005-01-28 | John Butterfill uk.org.publicwhip/member/771 | John Butterfill uk.org.publicwhip/person/10082 | 0 | 2005-01-28-5177ae6a-10082-0 |
89ae6a18c46da5512e7cdb60e66749d24db6e9ab | Consultant to Curchod and Co. (Chartered Surveyors) (non-parliamentary). | Remunerated employment, office, profession etc... 5177ae6a | 2005-01-28 | John Butterfill uk.org.publicwhip/member/771 | John Butterfill uk.org.publicwhip/person/10082 | 1 | 2005-01-28-5177ae6a-10082-0 |
0057b6fba4da305872a59e78c361b6bd331e0163 | I am a member of the Tyr Consortium which holds minerals exploration licences in Iceland (currently unremunerated). | Miscellaneous and unremunerated interests 265f2269 | 2005-01-28 | John Butterfill uk.org.publicwhip/member/771 | John Butterfill uk.org.publicwhip/person/10082 | 0 | 2005-01-28-265f2269-10082-0 |
bd9cc91f01aa78f074ccae2026ae05258ce14437 | Partner, Butterfill Associates (financial, corporate and real estate consultants). | Remunerated employment, office, profession etc 1f359ece | 2004-12-03 | John Butterfill uk.org.publicwhip/member/771 | John Butterfill uk.org.publicwhip/person/10082 | 0 | 2004-12-03-1f359ece-10082-0 |
04b5b3baba079dc39888a8a69d93a1407286cd33 | Consultant to Curchod and Co. (Chartered Surveyors) (non-parliamentary). | Remunerated employment, office, profession etc 1f359ece | 2004-12-03 | John Butterfill uk.org.publicwhip/member/771 | John Butterfill uk.org.publicwhip/person/10082 | 1 | 2004-12-03-1f359ece-10082-0 |
29538aa227c28075e73d8a553421bc04205697cb | I am a member of the Tyr Consortium which holds minerals exploration licences in Iceland (currently unremunerated). | Miscellaneous and unremunerated interests 265f2269 | 2004-12-03 | John Butterfill uk.org.publicwhip/member/771 | John Butterfill uk.org.publicwhip/person/10082 | 0 | 2004-12-03-265f2269-10082-0 |
3b94e2d584c84c2b14236b159689f6b227110fc0 | Partner, Butterfill Associates (financial, corporate and real estate consultants). | Remunerated employment, office, profession etc 1f359ece | 2004-10-22 | John Butterfill uk.org.publicwhip/member/771 | John Butterfill uk.org.publicwhip/person/10082 | 0 | 2004-10-22-1f359ece-10082-0 |
7cc8140c6751f76c8c3d08020d43732cfe710827 | Consultant to Curchod and Co. (Chartered Surveyors) (non-parliamentary). | Remunerated employment, office, profession etc 1f359ece | 2004-10-22 | John Butterfill uk.org.publicwhip/member/771 | John Butterfill uk.org.publicwhip/person/10082 | 1 | 2004-10-22-1f359ece-10082-0 |
8f190537c1c318659f3ce7cb17663f4b16a04d3c | I am a member of the Tyr Consortium which holds minerals exploration licences in Iceland (currently unremunerated). | Miscellaneous and unremunerated interests 265f2269 | 2004-10-22 | John Butterfill uk.org.publicwhip/member/771 | John Butterfill uk.org.publicwhip/person/10082 | 0 | 2004-10-22-265f2269-10082-0 |
6c4e6617ac630ecc1d05cfbc858b2c319de5a202 | Partner, Butterfill Associates (financial, corporate and real estate consultants). | Remunerated employment, office, profession etc 1f359ece | 2004-09-08 | John Butterfill uk.org.publicwhip/member/771 | John Butterfill uk.org.publicwhip/person/10082 | 0 | 2004-09-08-1f359ece-10082-0 |
8be5a2ed0709391e9a2aa20ff5eda0a850a5c605 | Consultant to Curchod and Co. (Chartered Surveyors) (non-parliamentary). | Remunerated employment, office, profession etc 1f359ece | 2004-09-08 | John Butterfill uk.org.publicwhip/member/771 | John Butterfill uk.org.publicwhip/person/10082 | 1 | 2004-09-08-1f359ece-10082-0 |
4359e035312f68ce90fcd9a0c41e658da79cef17 | I am a member of the Tyr Consortium which holds minerals exploration licences in Iceland (currently unremunerated). | Miscellaneous and unremunerated interests 265f2269 | 2004-09-08 | John Butterfill uk.org.publicwhip/member/771 | John Butterfill uk.org.publicwhip/person/10082 | 0 | 2004-09-08-265f2269-10082-0 |
9500afa7a4cafc19d5eaa46fadeb2e6e01c492ad | Partner, Butterfill Associates (financial, corporate and real estate consultants). | Remunerated employment, office, profession etc 1f359ece | 2004-07-16 | John Butterfill uk.org.publicwhip/member/771 | John Butterfill uk.org.publicwhip/person/10082 | 0 | 2004-07-16-1f359ece-10082-0 |
b50c8559610f4e502fe57763786cafa68b2376c5 | Consultant to Curchod and Co. (Chartered Surveyors) (non-parliamentary). | Remunerated employment, office, profession etc 1f359ece | 2004-07-16 | John Butterfill uk.org.publicwhip/member/771 | John Butterfill uk.org.publicwhip/person/10082 | 1 | 2004-07-16-1f359ece-10082-0 |
9b26e9cda909ef44a133f936e6bd04b20277699a | Partner, Butterfill Associates (financial, corporate and real estate consultants). | Remunerated employment, office, profession etc 1f359ece | 2004-05-21 | John Butterfill uk.org.publicwhip/member/771 | John Butterfill uk.org.publicwhip/person/10082 | 0 | 2004-05-21-1f359ece-10082-0 |
06c06c8665d922ae599dcbfdf7870b92c22250d1 | Consultant to Curchod and Co. (Chartered Surveyors) (non-parliamentary). | Remunerated employment, office, profession etc 1f359ece | 2004-05-21 | John Butterfill uk.org.publicwhip/member/771 | John Butterfill uk.org.publicwhip/person/10082 | 1 | 2004-05-21-1f359ece-10082-0 |
f8e7d2a9073e4f927814d0c9891575b9835d3c4f | Partner, Butterfill Associates (financial, corporate and real estate consultants). | Remunerated employment, office, profession etc 1f359ece | 2004-01-31 | John Butterfill uk.org.publicwhip/member/771 | John Butterfill uk.org.publicwhip/person/10082 | 0 | 2004-01-31-1f359ece-10082-0 |
097920afb3774db0cb12ea020baeb5aa3e012579 | Consultant to Curchod and Co. (Chartered Surveyors) (non-parliamentary). | Remunerated employment, office, profession etc 1f359ece | 2004-01-31 | John Butterfill uk.org.publicwhip/member/771 | John Butterfill uk.org.publicwhip/person/10082 | 1 | 2004-01-31-1f359ece-10082-0 |
ed018c9dcf93fdc5e787b12a61ee4b17838ed42c | Partner, Butterfill Associates (financial, corporate and real estate consultants). | Remunerated employment, office, profession etc 1f359ece | 2003-12-04 | John Butterfill uk.org.publicwhip/member/771 | John Butterfill uk.org.publicwhip/person/10082 | 0 | 2003-12-04-1f359ece-10082-0 |
94d35b5e058aa38bed632c81f29e90141ea70ae3 | Consultant to Curchod and Co. (Chartered Surveyors) (non-parliamentary). | Remunerated employment, office, profession etc 1f359ece | 2003-12-04 | John Butterfill uk.org.publicwhip/member/771 | John Butterfill uk.org.publicwhip/person/10082 | 1 | 2003-12-04-1f359ece-10082-0 |
b5431f478275754c4221628653b7d1c4e2159b55 | Partner, Butterfill Associates (financial, corporate and real estate consultants). | Remunerated employment, office, profession etc 1f359ece | 2002-11-26 | John Butterfill uk.org.publicwhip/member/771 | John Butterfill uk.org.publicwhip/person/10082 | 0 | 2002-11-26-1f359ece-10082-0 |
a30600e74741d30c26b7c0d946e713bfc079f2e6 | Consultant to Curchod and Co. (Chartered Surveyors) (non-parliamentary). | Remunerated employment, office, profession etc 1f359ece | 2002-11-26 | John Butterfill uk.org.publicwhip/member/771 | John Butterfill uk.org.publicwhip/person/10082 | 1 | 2002-11-26-1f359ece-10082-0 |
9a78aa109b8c50d0536110c9bce1d2fbea4dd5e4 | 31 January 2002, day trip to Zurich with members of the British-Swiss All-Party Parliamentary Group as the guest of the British-Swiss Chamber of Commerce. (Registered 7 February 2002) | Overseas visits 80ef1083 | 2002-11-26 | John Butterfill uk.org.publicwhip/member/771 | John Butterfill uk.org.publicwhip/person/10082 | 0 | 2002-11-26-80ef1083-10082-0 |
f16944c013b0552b60ae04164dd087dd3aaa569e | Partner, Butterfill Associates (financial, corporate and real estate consultants). | Remunerated employment, office, profession etc 1f359ece | 2002-05-14 | John Butterfill uk.org.publicwhip/member/771 | John Butterfill uk.org.publicwhip/person/10082 | 0 | 2002-05-14-1f359ece-10082-0 |
f5488a18d6ff5575f2184af940ba10c786052e40 | Consultant to Curchod and Co. (Chartered Surveyors) (non-parliamentary). | Remunerated employment, office, profession etc 1f359ece | 2002-05-14 | John Butterfill uk.org.publicwhip/member/771 | John Butterfill uk.org.publicwhip/person/10082 | 1 | 2002-05-14-1f359ece-10082-0 |
d5297f2dc9fc14525b5302351b8898092af2da2f | Occasional fees for radio, television, lectures and journalism. | Remunerated employment, office, profession etc 1f359ece | 2002-05-14 | John Butterfill uk.org.publicwhip/member/771 | John Butterfill uk.org.publicwhip/person/10082 | 2 | 2002-05-14-1f359ece-10082-0 |
43f419467027be8fd411aaee7fc95ab52c254a3c | Member of Harris Parliamentary Panel. (£1-£1,000). | Remunerated employment, office, profession etc 1f359ece | 2002-05-14 | John Butterfill uk.org.publicwhip/member/771 | John Butterfill uk.org.publicwhip/person/10082 | 3 | 2002-05-14-1f359ece-10082-0 |
e0ce671b8e800e5ee6aa5be4065e564895901b3f | Member of Political Opinion Panel of BPRI (Business Planning and Research International). (£1-£1,000) | Remunerated employment, office, profession etc 1f359ece | 2002-05-14 | John Butterfill uk.org.publicwhip/member/771 | John Butterfill uk.org.publicwhip/person/10082 | 4 | 2002-05-14-1f359ece-10082-0 |
e041de4ce5174d2aa2ca1504d914a87efbb8076d | March 2002, entertainment at Sadlers Wells Ballet with hospitality for self and wife by HBOS PLC. (Registered 10 April 2002) | Gifts, benefits and hospitality (UK) 84642823 | 2002-05-14 | John Butterfill uk.org.publicwhip/member/771 | John Butterfill uk.org.publicwhip/person/10082 | 0 | 2002-05-14-84642823-10082-0 |
f160083fc20678929e07a087b96093c5add41845 | 31 January 2002, day trip to Zurich with members of the British-Swiss All-Party Parliamentary Group as the guest of the British-Swiss Chamber of Commerce. (Registered 7 February 2002) | Overseas visits 80ef1083 | 2002-05-14 | John Butterfill uk.org.publicwhip/member/771 | John Butterfill uk.org.publicwhip/person/10082 | 0 | 2002-05-14-80ef1083-10082-0 |
e4d2d3e6ecf65d1c690598b8b273a8a2609e6203 | Honorary President, European Property Associates (international property consultancy grouping). | Miscellaneous and unremunerated interests 265f2269 | 2002-05-14 | John Butterfill uk.org.publicwhip/member/771 | John Butterfill uk.org.publicwhip/person/10082 | 0 | 2002-05-14-265f2269-10082-0 |
c23593535772991927aabc8babeea9aa185513bc | Member of the Council of Management of the People's Dispensary for Sick Animals. | Miscellaneous and unremunerated interests 265f2269 | 2002-05-14 | John Butterfill uk.org.publicwhip/member/771 | John Butterfill uk.org.publicwhip/person/10082 | 1 | 2002-05-14-265f2269-10082-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");