home / regmem

items

Data source: mySociety Data

28 rows where person_id = "uk.org.publicwhip/person/10011"

View and edit SQL

Suggested facets: item, category_id, date, member_id, sort_order, record_id

hash item category_id date member_id person_id sort_order record_id
0b51085e2c6f5b11e90c4e33a7a708cadaa420a6 Broadcasting receipts, which are paid to charity. Remunerated employment, office, profession etc 1f359ece 2000-11-10 uk.org.publicwhip/member/11 Donald Anderson uk.org.publicwhip/person/10011 1 2000-11-10-1f359ece-10011-0
198e56574ba7dc2e5c030d73caf053f461b9ab0e 29 August-3 September 2004, to Norway with the British-Norwegian All-Party Parliamentary Group, which I chair, financed by the Norwegian Ministry of Foreign Affairs. (Registered 9 September 2004) Overseas visits 80ef1083 2005-04-11 uk.org.publicwhip/member/698 Donald Anderson uk.org.publicwhip/person/10011 0 2005-04-11-80ef1083-10011-0
19d6a48b3a413c1e73d3ca56f9b1271e4a593787 29 August-3 September 2004, to Norway with the British-Norwegian All-Party Parliamentary Group, which I chair, financed by the Norwegian Ministry of Foreign Affairs. (Registered 9 September 2004) Overseas visits 80ef1083 2004-12-03 uk.org.publicwhip/member/698 Donald Anderson uk.org.publicwhip/person/10011 0 2004-12-03-80ef1083-10011-0
1b323a55258092790c0f87d500ef45cb3b076059 4-9 October 2004, to Morocco, at the invitation of their Speaker for the opening of Parliament by the King. All expenses paid for by the Moroccan Parliament. (Registered 11 October 2004) Overseas visits 80ef1083 2004-10-22 uk.org.publicwhip/member/698 Donald Anderson uk.org.publicwhip/person/10011 1 2004-10-22-80ef1083-10011-0
2c1cc30309cc377cfbd602e2d092fc710b818232 Three articles for the Daily Mirror. (£1-£1,000) Remunerated employment, office, profession etc 1f359ece 2002-05-14 uk.org.publicwhip/member/698 Donald Anderson uk.org.publicwhip/person/10011 2 2002-05-14-1f359ece-10011-0
34ce0a53872026f1684a67f51bab58780bac06e3 Articles for the Daily Mirror. (Up to £5,000) Remunerated employment, office, profession etc 1f359ece 2002-11-26 uk.org.publicwhip/member/698 Donald Anderson uk.org.publicwhip/person/10011 0 2002-11-26-1f359ece-10011-0
376aeccf4f5fc381d53339b4a631b077aa59cf06 Director (unpaid) of the Anglo-Austrian Society. Miscellaneous and unremunerated interests 265f2269 2000-11-10 uk.org.publicwhip/member/11 Donald Anderson uk.org.publicwhip/person/10011 1 2000-11-10-265f2269-10011-0
39a46b3d3d539606258bb76cb39a1bde14589194 Consultant to the Royal Society of Chemistry (money paid direct to charity). Miscellaneous and unremunerated interests 265f2269 2000-11-10 uk.org.publicwhip/member/11 Donald Anderson uk.org.publicwhip/person/10011 0 2000-11-10-265f2269-10011-0
51b4f97b381598cb4c5347b24cc2a148012c60ff 29 August-3 September 2004, to Norway with the British-Norwegian All-Party Parliamentary Group, which I chair, financed by the Norwegian Ministry of Foreign Affairs. (Registered 9 September 2004) Overseas visits 80ef1083 2004-10-22 uk.org.publicwhip/member/698 Donald Anderson uk.org.publicwhip/person/10011 0 2004-10-22-80ef1083-10011-0
57063b562539b532891685efe8ef64003c9249bb 5 July 2003, attended Wimbledon Ladies Final with my wife as a guest of the BBC Overseas Service. (Registered 8 July 2003) Gifts, benefits and hospitality (UK) 84642823 2004-05-21 uk.org.publicwhip/member/698 Donald Anderson uk.org.publicwhip/person/10011 0 2004-05-21-84642823-10011-0
5a0dc222501c7b339b0bd1b965f149586a590bed Director (unpaid) of the Anglo-Austrian Society. Miscellaneous and unremunerated interests 265f2269 2001-05-14 uk.org.publicwhip/member/11 Donald Anderson uk.org.publicwhip/person/10011 1 2001-05-14-265f2269-10011-0
6af5218acf062110d6cbc461d5215fd4fd293b41 I receive rental income from a paying guest in our London home from time to time. Land and Property 4f1e6359 2002-05-14 uk.org.publicwhip/member/698 Donald Anderson uk.org.publicwhip/person/10011 0 2002-05-14-4f1e6359-10011-0
7393cf3347cd982a460abf21f2a94c81a1f95944 Member of Harris Parliamentary Panel. (£1-£1,000) . Fees are paid to charity. Remunerated employment, office, profession etc 1f359ece 2000-11-10 uk.org.publicwhip/member/11 Donald Anderson uk.org.publicwhip/person/10011 0 2000-11-10-1f359ece-10011-0
7ea28df74157b42b5fd673ae059576ac0eefb7eb 12-14 May 2000, to Malta accompanied by my wife, to deliver a lecture on British foreign policy, paid for by the Maltese Government. (Registered 15 May 2000) Overseas visits 80ef1083 2000-11-10 uk.org.publicwhip/member/11 Donald Anderson uk.org.publicwhip/person/10011 0 2000-11-10-80ef1083-10011-0
84a0b979684fde944a06fa5f37360bcac40998ab 4-9 October 2004, to Morocco, at the invitation of their Speaker for the opening of Parliament by the King. All expenses paid for by the Moroccan Parliament. (Registered 11 October 2004) Overseas visits 80ef1083 2005-01-28 uk.org.publicwhip/member/698 Donald Anderson uk.org.publicwhip/person/10011 1 2005-01-28-80ef1083-10011-0
a0dc2db2fc314c156a335cdee33220d2192de246 Consultant to the Royal Society of Chemistry (money paid direct to charity). Miscellaneous and unremunerated interests 265f2269 2001-05-14 uk.org.publicwhip/member/11 Donald Anderson uk.org.publicwhip/person/10011 0 2001-05-14-265f2269-10011-0
b1c17b0beb74d7f1c94873fe01e31d37b5b107d6 5 July 2003, attended Wimbledon Ladies Final with my wife as a guest of the BBC Overseas Service. (Registered 8 July 2003) Gifts, benefits and hospitality (UK) 84642823 2003-12-04 uk.org.publicwhip/member/698 Donald Anderson uk.org.publicwhip/person/10011 0 2003-12-04-84642823-10011-0
b1f920686adac4c975a9534a1b98420cb76f385c 12-14 May 2000, to Malta accompanied by my wife, to deliver a lecture on British foreign policy, paid for by the Maltese Government. (Registered 15 May 2000) Overseas visits 80ef1083 2001-05-14 uk.org.publicwhip/member/11 Donald Anderson uk.org.publicwhip/person/10011 0 2001-05-14-80ef1083-10011-0
b27afeb81a1825d38b52c6edbabd8222df2963c2 5 July 2003, attended Wimbledon Ladies Final with my wife as a guest of the BBC Overseas Service. (Registered 8 July 2003) Gifts, benefits and hospitality (UK) 84642823 2004-01-31 uk.org.publicwhip/member/698 Donald Anderson uk.org.publicwhip/person/10011 0 2004-01-31-84642823-10011-0
c39b5ab104b5a99c72d7a176a819a2bb26d562b4 4-9 October 2004, to Morocco, at the invitation of their Speaker for the opening of Parliament by the King. All expenses paid for by the Moroccan Parliament. (Registered 11 October 2004) Overseas visits 80ef1083 2005-04-11 uk.org.publicwhip/member/698 Donald Anderson uk.org.publicwhip/person/10011 1 2005-04-11-80ef1083-10011-0
c64f3fadbedd5e80c0d5a8f064b7427f4bab28c6 Member of Harris Parliamentary Panel. (£1-£1,000) . Fees are paid to charity. Remunerated employment, office, profession etc 1f359ece 2001-05-14 uk.org.publicwhip/member/11 Donald Anderson uk.org.publicwhip/person/10011 0 2001-05-14-1f359ece-10011-0
d0a728097b7cb95fc8a51996822092ac35c8b620 Member of the Board of Mercy Ships, an aid charity (unremunerated). Miscellaneous and unremunerated interests 265f2269 2002-05-14 uk.org.publicwhip/member/698 Donald Anderson uk.org.publicwhip/person/10011 0 2002-05-14-265f2269-10011-0
d372c7bca11f928be211d87d041a0ff427742a9a Member of Harris Parliamentary Panel. (£1-£1,000) . Fees are paid to charity. Remunerated employment, office, profession etc 1f359ece 2002-05-14 uk.org.publicwhip/member/698 Donald Anderson uk.org.publicwhip/person/10011 0 2002-05-14-1f359ece-10011-0
edb4c9b638e55341c815becba4264a8b2e8102fe 24-27 November 2000, to Israel accompanied by my wife, to meet Israeli and Palestinian leaders at the invitation of the Chairman of the Knesset Foreign Affairs Committee. (Registered 12 December 2000) Overseas visits 80ef1083 2001-05-14 uk.org.publicwhip/member/11 Donald Anderson uk.org.publicwhip/person/10011 1 2001-05-14-80ef1083-10011-0
f7726610f06e30758e23eb936d3d2823b921a74c Broadcasting receipts, which are paid to charity. Remunerated employment, office, profession etc 1f359ece 2002-05-14 uk.org.publicwhip/member/698 Donald Anderson uk.org.publicwhip/person/10011 1 2002-05-14-1f359ece-10011-0
fa2f628eae555f5fddeec7af1b480f33d42e88cd 4-9 October 2004, to Morocco, at the invitation of their Speaker for the opening of Parliament by the King. All expenses paid for by the Moroccan Parliament. (Registered 11 October 2004) Overseas visits 80ef1083 2004-12-03 uk.org.publicwhip/member/698 Donald Anderson uk.org.publicwhip/person/10011 1 2004-12-03-80ef1083-10011-0
fa973512e92366614fd4bb041b09f874f875fd58 Broadcasting receipts, which are paid to charity. Remunerated employment, office, profession etc 1f359ece 2001-05-14 uk.org.publicwhip/member/11 Donald Anderson uk.org.publicwhip/person/10011 1 2001-05-14-1f359ece-10011-0
fdff62294cf57a39f8f7e136215f4a7d3287def8 29 August-3 September 2004, to Norway with the British-Norwegian All-Party Parliamentary Group, which I chair, financed by the Norwegian Ministry of Foreign Affairs. (Registered 9 September 2004) Overseas visits 80ef1083 2005-01-28 uk.org.publicwhip/member/698 Donald Anderson uk.org.publicwhip/person/10011 0 2005-01-28-80ef1083-10011-0

Advanced export

JSON shape: default, array, object

CSV options:

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)
    )
Powered by Datasette · Query took 5.735ms · Data source: mySociety Data