home / regmem

items

Data source: mySociety Data

46 rows where person_id = "uk.org.publicwhip/person/10043"

View and edit SQL

Suggested facets: item, category_id, member_id, sort_order

hash item category_id date member_id person_id sort_order record_id
00ac48c5bde96364fdb4ad4dc6fe8593af9f3320 Member of Harris Parliamentary Panel. (£1-£1,000) Remunerated employment, office, profession etc 1f359ece 2001-05-14 uk.org.publicwhip/member/43 Roger Berry uk.org.publicwhip/person/10043 0 2001-05-14-1f359ece-10043-0
00ce80666a3d5922272912f07b69b544f381a5aa 26-30 November 2005, to Ghana, as a member of a cross-party group investigating trade related issues, financed by Christian Aid. (Registered 20 January 2006) Overseas visits 80ef1083 2006-11-06 uk.org.publicwhip/member/1663 Roger Berry uk.org.publicwhip/person/10043 0 2006-11-06-80ef1083-10043-0
04e3ef7e733843293cbec625dc8cbd92cb3a4757 26-30 November 2005, to Ghana, as a member of a cross-party group investigating trade related issues, financed by Christian Aid. (Registered 20 January 2006) Overseas visits 80ef1083 2006-02-13 uk.org.publicwhip/member/1663 Roger Berry uk.org.publicwhip/person/10043 0 2006-02-13-80ef1083-10043-0
0f799fa6a665afccab160d6c45ac7c44d5603af7 27 May-2 June 2007, to Syria as a member of a UK parliamentary delegation to meet government ministers, parliamentarians and business leaders. Flights, hospitality and accommodation paid by British Syrian Society. (Registered 12 June 2007) Overseas visits 80ef1083 2007-07-30 uk.org.publicwhip/member/1663 Roger Berry uk.org.publicwhip/person/10043 0 2007-07-30-80ef1083-10043-0
15c2b7994a57204b0d8553233d422676ca35e3b8 27 May-2 June 2007, to Syria as a member of a UK parliamentary delegation to meet government ministers, parliamentarians and business leaders. Flights, hospitality and accommodation paid by British Syrian Society. (Registered 12 June 2007) Overseas visits 80ef1083 2007-08-28 uk.org.publicwhip/member/1663 Roger Berry uk.org.publicwhip/person/10043 0 2007-08-28-80ef1083-10043-0
19ffa66d1335b41b378fe86eda0fa4804aa62713 27 May-2 June 2007, to Syria as a member of a UK parliamentary delegation to meet government ministers, parliamentarians and business leaders. Flights, hospitality and accommodation paid by British Syrian Society. (Registered 12 June 2007) Overseas visits 80ef1083 2007-12-04 uk.org.publicwhip/member/1663 Roger Berry uk.org.publicwhip/person/10043 0 2007-12-04-80ef1083-10043-0
2334278bc5676d912187e3366ca1b88386a52728 27 May-2 June 2007, to Syria as a member of a UK parliamentary delegation to meet government ministers, parliamentarians and business leaders. Flights, hospitality and accommodation paid by British Syrian Society. (Registered 12 June 2007) Overseas visits 80ef1083 2008-04-23 uk.org.publicwhip/member/1663 Roger Berry uk.org.publicwhip/person/10043 0 2008-04-23-80ef1083-10043-0
25c2bf29713ecf34a0e5e792dfad5a18224733b3 27 May-2 June 2007, to Syria as a member of a UK parliamentary delegation to meet government ministers, parliamentarians and business leaders. Flights, hospitality and accommodation paid by British Syrian Society. (Registered 12 June 2007) Overseas visits 80ef1083 2007-06-19 uk.org.publicwhip/member/1663 Roger Berry uk.org.publicwhip/person/10043 0 2007-06-19-80ef1083-10043-0
2613c96cdd12620b92a1d444bae29e504e465304 Member of Political Opinion Panel of BPRI (Business Planning and Research International). (£1-£1,000) Remunerated employment, office, profession etc 1f359ece 2002-05-14 uk.org.publicwhip/member/732 Roger Berry uk.org.publicwhip/person/10043 1 2002-05-14-1f359ece-10043-0
2bee7d4f92ef0d036634ba4d0de2db3f651bdafb 27 May-2 June 2007, to Syria as a member of a UK parliamentary delegation to meet government ministers, parliamentarians and business leaders. Flights, hospitality and accommodation paid by British Syrian Society. (Registered 12 June 2007) Overseas visits 80ef1083 2007-12-18 uk.org.publicwhip/member/1663 Roger Berry uk.org.publicwhip/person/10043 0 2007-12-18-80ef1083-10043-0
2d68da9bd72d8a3edaf03716fcb519e733816c9b Occasional journalism, broadcasting and lecturing. Remunerated employment, office, profession etc 1f359ece 2001-05-14 uk.org.publicwhip/member/43 Roger Berry uk.org.publicwhip/person/10043 2 2001-05-14-1f359ece-10043-0
3fdd5f9345ad29d2ed2b6b5fabfb602ef06d76ea 27 May-2 June 2007, to Syria as a member of a UK parliamentary delegation to meet government ministers, parliamentarians and business leaders. Flights, hospitality and accommodation paid by British Syrian Society. (Registered 12 June 2007) Overseas visits 80ef1083 2008-06-16 uk.org.publicwhip/member/1663 Roger Berry uk.org.publicwhip/person/10043 0 2008-06-16-80ef1083-10043-0
473c3e2fdb369a5eddfcc141231dc1b3ea2fe34d Member of Harris Parliamentary Panel. (£1-£1,000) Remunerated employment, office, profession etc 1f359ece 2000-11-10 uk.org.publicwhip/member/43 Roger Berry uk.org.publicwhip/person/10043 0 2000-11-10-1f359ece-10043-0
4a3c0ffa97a9330776ee4eb6bcc04f3b05254f15 26-30 November 2005, to Ghana, as a member of a cross-party group investigating trade related issues, financed by Christian Aid. (Registered 20 January 2006) Overseas visits 80ef1083 2006-02-14 uk.org.publicwhip/member/1663 Roger Berry uk.org.publicwhip/person/10043 0 2006-02-14-80ef1083-10043-0
4c38b66ea61f4ea8ea3d52eb58cce71627e7a4ca 27 May-2 June 2007, to Syria as a member of a UK parliamentary delegation to meet government ministers, parliamentarians and business leaders. Flights, hospitality and accommodation paid by British Syrian Society. (Registered 12 June 2007) Overseas visits 80ef1083 2007-07-03 uk.org.publicwhip/member/1663 Roger Berry uk.org.publicwhip/person/10043 0 2007-07-03-80ef1083-10043-0
4c7f2b5a62c84685864c5d239da7a98905b13ef0 26-30 November 2005, to Ghana, as a member of a cross-party group investigating trade related issues, financed by Christian Aid. (Registered 20 January 2006) Overseas visits 80ef1083 2006-06-21 uk.org.publicwhip/member/1663 Roger Berry uk.org.publicwhip/person/10043 0 2006-06-21-80ef1083-10043-0
5280c8183bdfe4b20bdb5bb57d8696f6ac59349e 26-30 November 2005, to Ghana, as a member of a cross-party group investigating trade related issues, financed by Christian Aid. (Registered 20 January 2006) Overseas visits 80ef1083 2007-02-27 uk.org.publicwhip/member/1663 Roger Berry uk.org.publicwhip/person/10043 0 2007-02-27-80ef1083-10043-0
53058fea4fc53de9ed966f904dd3ad7cc3a8c013 18-25 September 2004, to Vietnam as a member of the All-Party Parliamentary Vietnam Group. The in-country costs were met by the National Assembly of Vietnam. (Air fares were met by IPU with a contribution from the British Council.) (Registered 26 October 2004) Overseas visits 80ef1083 2005-01-28 uk.org.publicwhip/member/732 Roger Berry uk.org.publicwhip/person/10043 0 2005-01-28-80ef1083-10043-0
5af0a424e14ddeef179d8a095950d1bd042644b0 26-30 November 2005, to Ghana, as a member of a cross-party group investigating trade related issues, financed by Christian Aid. (Registered 20 January 2006) Overseas visits 80ef1083 2007-01-23 uk.org.publicwhip/member/1663 Roger Berry uk.org.publicwhip/person/10043 0 2007-01-23-80ef1083-10043-0
5c7a069c03e88b546806c044fd3235f141618820 27 May-2 June 2007, to Syria as a member of a UK parliamentary delegation to meet government ministers, parliamentarians and business leaders. Flights, hospitality and accommodation paid by British Syrian Society. (Registered 12 June 2007) Overseas visits 80ef1083 2008-03-25 uk.org.publicwhip/member/1663 Roger Berry uk.org.publicwhip/person/10043 0 2008-03-25-80ef1083-10043-0
61ce1c4338b43535322790db58709527721b1a6e Occasional journalism, broadcasting and lecturing. Remunerated employment, office, profession etc 1f359ece 2000-11-10 uk.org.publicwhip/member/43 Roger Berry uk.org.publicwhip/person/10043 2 2000-11-10-1f359ece-10043-0
6303eee528525418a1d4f24f1eb898c3c40c035f 27 May-2 June 2007, to Syria as a member of a UK parliamentary delegation to meet government ministers, parliamentarians and business leaders. Flights, hospitality and accommodation paid by British Syrian Society. (Registered 12 June 2007) Overseas visits 80ef1083 2007-11-06 uk.org.publicwhip/member/1663 Roger Berry uk.org.publicwhip/person/10043 0 2007-11-06-80ef1083-10043-0
67ab63bff3f3989a0b646f20668f00d5a5e88dea Member of Political Opinion Panel of BPRI (Business Planning and Research International). (£1-£1,000) Remunerated employment, office, profession etc 1f359ece 2000-11-10 uk.org.publicwhip/member/43 Roger Berry uk.org.publicwhip/person/10043 1 2000-11-10-1f359ece-10043-0
6b459197e0feaf7e80d6b183c074cca163a35973 26-30 November 2005, to Ghana, as a member of a cross-party group investigating trade related issues, financed by Christian Aid. (Registered 20 January 2006) Overseas visits 80ef1083 2006-09-19 uk.org.publicwhip/member/1663 Roger Berry uk.org.publicwhip/person/10043 0 2006-09-19-80ef1083-10043-0
6fa03f5be300f2d368ffdeb41539bcb96744e5da 27 May-2 June 2007, to Syria as a member of a UK parliamentary delegation to meet government ministers, parliamentarians and business leaders. Flights, hospitality and accommodation paid by British Syrian Society. (Registered 12 June 2007) Overseas visits 80ef1083 2008-01-09 uk.org.publicwhip/member/1663 Roger Berry uk.org.publicwhip/person/10043 0 2008-01-09-80ef1083-10043-0
7bd949ebf51881619f8cdecbe62b053deeb524ec 26-30 November 2005, to Ghana, as a member of a cross-party group investigating trade related issues, financed by Christian Aid. (Registered 20 January 2006) Overseas visits 80ef1083 2007-03-26 uk.org.publicwhip/member/1663 Roger Berry uk.org.publicwhip/person/10043 0 2007-03-26-80ef1083-10043-0
8d5a89e376d78ff4b297dac8fa8dc79f3b720ada 27 May-2 June 2007, to Syria as a member of a UK parliamentary delegation to meet government ministers, parliamentarians and business leaders. Flights, hospitality and accommodation paid by British Syrian Society. (Registered 12 June 2007) Overseas visits 80ef1083 2007-10-23 uk.org.publicwhip/member/1663 Roger Berry uk.org.publicwhip/person/10043 0 2007-10-23-80ef1083-10043-0
8fb3f83c9de1943ecd13fded092663dc2c9bc7cb 26-30 November 2005, to Ghana, as a member of a cross-party group investigating trade related issues, financed by Christian Aid. (Registered 20 January 2006) Overseas visits 80ef1083 2006-07-25 uk.org.publicwhip/member/1663 Roger Berry uk.org.publicwhip/person/10043 0 2006-07-25-80ef1083-10043-0
942b314df90c791fc17b8a09a89ec95a534bac39 18-25 September 2004, to Vietnam as a member of the All-Party Parliamentary Vietnam Group. The in-country costs were met by the National Assembly of Vietnam. (Air fares were met by IPU with a contribution from the British Council.) (Registered 26 October 2004) Overseas visits 80ef1083 2005-04-11 uk.org.publicwhip/member/732 Roger Berry uk.org.publicwhip/person/10043 0 2005-04-11-80ef1083-10043-0
9440268065cda933bd73939166039445137fcaf8 27 May-2 June 2007, to Syria as a member of a UK parliamentary delegation to meet government ministers, parliamentarians and business leaders. Flights, hospitality and accommodation paid by British Syrian Society. (Registered 12 June 2007) Overseas visits 80ef1083 2007-07-17 uk.org.publicwhip/member/1663 Roger Berry uk.org.publicwhip/person/10043 0 2007-07-17-80ef1083-10043-0
a1ba25f4724c408ddabc404649837567771e28fb 27 May-2 June 2007, to Syria as a member of a UK parliamentary delegation to meet government ministers, parliamentarians and business leaders. Flights, hospitality and accommodation paid by British Syrian Society. (Registered 12 June 2007) Overseas visits 80ef1083 2008-02-05 uk.org.publicwhip/member/1663 Roger Berry uk.org.publicwhip/person/10043 0 2008-02-05-80ef1083-10043-0
a83955f92761b1317103bd02b2b966f40c8c3918 27 May-2 June 2007, to Syria as a member of a UK parliamentary delegation to meet government ministers, parliamentarians and business leaders. Flights, hospitality and accommodation paid by British Syrian Society. (Registered 12 June 2007) Overseas visits 80ef1083 2008-02-26 uk.org.publicwhip/member/1663 Roger Berry uk.org.publicwhip/person/10043 0 2008-02-26-80ef1083-10043-0
a961b376534129209a1b974ad46f42ef6c1d3cb4 26-30 November 2005, to Ghana, as a member of a cross-party group investigating trade related issues, financed by Christian Aid. (Registered 20 January 2006) Overseas visits 80ef1083 2007-01-09 uk.org.publicwhip/member/1663 Roger Berry uk.org.publicwhip/person/10043 0 2007-01-09-80ef1083-10043-0
b2a31fca2c083292dd3445d1cc67fa1475bf86dd 27 May-2 June 2007, to Syria as a member of a UK parliamentary delegation to meet government ministers, parliamentarians and business leaders. Flights, hospitality and accommodation paid by British Syrian Society. (Registered 12 June 2007) Overseas visits 80ef1083 2007-10-09 uk.org.publicwhip/member/1663 Roger Berry uk.org.publicwhip/person/10043 0 2007-10-09-80ef1083-10043-0
b43535b33e8130e3ca5bea308c5ee3f64297e053 Member of Harris Parliamentary Panel. (£1-£1,000) Remunerated employment, office, profession etc 1f359ece 2002-05-14 uk.org.publicwhip/member/732 Roger Berry uk.org.publicwhip/person/10043 0 2002-05-14-1f359ece-10043-0
b9266c2a7888e4cd0b0521f0734b0596a7afa968 26-30 November 2005, to Ghana, as a member of a cross-party group investigating trade related issues, financed by Christian Aid. (Registered 20 January 2006) Overseas visits 80ef1083 2007-03-13 uk.org.publicwhip/member/1663 Roger Berry uk.org.publicwhip/person/10043 0 2007-03-13-80ef1083-10043-0
befb8a276fd0480374b7400663b341fd97ac2763 26-30 November 2005, to Ghana, as a member of a cross-party group investigating trade related issues, financed by Christian Aid. (Registered 20 January 2006) Overseas visits 80ef1083 2006-11-27 uk.org.publicwhip/member/1663 Roger Berry uk.org.publicwhip/person/10043 0 2006-11-27-80ef1083-10043-0
ca18b7b85261db2deb72f00024f1efebae19f195 27 May-2 June 2007, to Syria as a member of a UK parliamentary delegation to meet government ministers, parliamentarians and business leaders. Flights, hospitality and accommodation paid by British Syrian Society. (Registered 12 June 2007) Overseas visits 80ef1083 2008-03-11 uk.org.publicwhip/member/1663 Roger Berry uk.org.publicwhip/person/10043 0 2008-03-11-80ef1083-10043-0
ccc5369f8a72515e2cc777c4fb65f2c5fb988efd 26-30 November 2005, to Ghana, as a member of a cross-party group investigating trade related issues, financed by Christian Aid. (Registered 20 January 2006) Overseas visits 80ef1083 2007-02-06 uk.org.publicwhip/member/1663 Roger Berry uk.org.publicwhip/person/10043 0 2007-02-06-80ef1083-10043-0
d1ad945699d5f891c37b07161f6890d250bf5a86 Member of Political Opinion Panel of BPRI (Business Planning and Research International). (£1-£1,000) Remunerated employment, office, profession etc 1f359ece 2001-05-14 uk.org.publicwhip/member/43 Roger Berry uk.org.publicwhip/person/10043 1 2001-05-14-1f359ece-10043-0
da636cdad8dad6e1c4d2877a73d96cce32392e8e 26-30 November 2005, to Ghana, as a member of a cross-party group investigating trade related issues, financed by Christian Aid. (Registered 20 January 2006) Overseas visits 80ef1083 2006-05-12 uk.org.publicwhip/member/1663 Roger Berry uk.org.publicwhip/person/10043 0 2006-05-12-80ef1083-10043-0
dc5614f5381c8003ad9f632a8409ba81bd1b118a 27 May-2 June 2007, to Syria as a member of a UK parliamentary delegation to meet government ministers, parliamentarians and business leaders. Flights, hospitality and accommodation paid by British Syrian Society. (Registered 12 June 2007) Overseas visits 80ef1083 2007-11-20 uk.org.publicwhip/member/1663 Roger Berry uk.org.publicwhip/person/10043 0 2007-11-20-80ef1083-10043-0
f261de4959d10ea149cd5eb1d4cdd7631c1ef095 26-30 November 2005, to Ghana, as a member of a cross-party group investigating trade related issues, financed by Christian Aid. (Registered 20 January 2006) Overseas visits 80ef1083 2006-12-11 uk.org.publicwhip/member/1663 Roger Berry uk.org.publicwhip/person/10043 0 2006-12-11-80ef1083-10043-0
f349a5da976f7e45c2fc9fcbdf5f2ab825026382 27 May-2 June 2007, to Syria as a member of a UK parliamentary delegation to meet government ministers, parliamentarians and business leaders. Flights, hospitality and accommodation paid by British Syrian Society. (Registered 12 June 2007) Overseas visits 80ef1083 2008-01-22 uk.org.publicwhip/member/1663 Roger Berry uk.org.publicwhip/person/10043 0 2008-01-22-80ef1083-10043-0
fd06f7087e8109c85c2e8434bb2573bbd8d01052 18-25 September 2004, to Vietnam as a member of the All-Party Parliamentary Vietnam Group. The in-country costs were met by the National Assembly of Vietnam. (Air fares were met by IPU with a contribution from the British Council.) (Registered 26 October 2004) Overseas visits 80ef1083 2004-12-03 uk.org.publicwhip/member/732 Roger Berry uk.org.publicwhip/person/10043 0 2004-12-03-80ef1083-10043-0
fe45825295148167bbf9c779e7765a531c8af7a3 26-30 November 2005, to Ghana, as a member of a cross-party group investigating trade related issues, financed by Christian Aid. (Registered 20 January 2006) Overseas visits 80ef1083 2006-03-24 uk.org.publicwhip/member/1663 Roger Berry uk.org.publicwhip/person/10043 0 2006-03-24-80ef1083-10043-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 7.368ms · Data source: mySociety Data