items

Data source: mySociety Data · About: simonw/register-of-members-interests

35 rows where member_id = "uk.org.publicwhip/member/1060" sorted by date descending

View and edit SQL

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
1b07e292dcc94c761c2ebed5be33bf0d495eeed9 31 March-2 April 2005, I visited the Wright Group in Ballymena, Northern Ireland, as a guest of First Group. All fares and accommodation were provided by First Group. (Registered 8 April 2005) Gifts, benefits and hospitality (UK) 84642823 2005-04-11 John Lyons uk.org.publicwhip/member/1060 John Lyons uk.org.publicwhip/person/11060 0 2005-04-11-84642823-11060-0
2a49bae8cbf480d91c0585bb6cf33741742fcf8f 11-14 June 2004, to Portugal as a member of the All-Party Parliamentary Football Team, with travel, accommodation and hospitality provided by McDonalds, and football facilities and hospitality by the Portuguese Parliament. (Registered 15 July 2004) Overseas visits 80ef1083 2005-04-11 John Lyons uk.org.publicwhip/member/1060 John Lyons uk.org.publicwhip/person/11060 0 2005-04-11-80ef1083-11060-0
cc167a9185c1a573b177e03c8efa717981925b48 7-11 May 2004, to Kuwait as a member of the All-Party Parliamentary Kuwait Group. Air fare and hospitality was provided by Ministry of Information in Kuwait. (Registered 12 October 2004) Overseas visits 80ef1083 2005-04-11 John Lyons uk.org.publicwhip/member/1060 John Lyons uk.org.publicwhip/person/11060 1 2005-04-11-80ef1083-11060-0
cff3301d363a0bd8f6afe2e38009d2c7002ff436 17-22 February 2005, to Saudi Arabia as a member of the All-Party Parliamentary Saudi Group. Air fares and all accommodation were provided by the Saudi Government. (Registered 8 April 2005) Overseas visits 80ef1083 2005-04-11 John Lyons uk.org.publicwhip/member/1060 John Lyons uk.org.publicwhip/person/11060 2 2005-04-11-80ef1083-11060-0
206cf14e37a544da48f0bbea18df3a8ce4e7b482 As a member of the All-Party Parliamentary Kuwait Group, on my visit to Kuwait City in May 2004 I received a gift of an Omega watch from the Ministry of Information in Kuwait. (Registered 9 December 2004) Overseas benefits and gifts a41b9847 2005-04-11 John Lyons uk.org.publicwhip/member/1060 John Lyons uk.org.publicwhip/person/11060 0 2005-04-11-a41b9847-11060-0
ced17e56e36caf1e5a2992428988fe3aedf5d23f 11-14 June 2004, to Portugal as a member of the All-Party Parliamentary Football Team, with travel, accommodation and hospitality provided by McDonalds, and football facilities and hospitality by the Portuguese Parliament. (Registered 15 July 2004) Overseas visits 80ef1083 2005-01-28 John Lyons uk.org.publicwhip/member/1060 John Lyons uk.org.publicwhip/person/11060 0 2005-01-28-80ef1083-11060-0
4070387b30b5bdb884cb2191dbbc33d08b4258cf 7-11 May 2004, to Kuwait as a member of the All-Party Parliamentary Kuwait Group. Air fare and hospitality was provided by Ministry of Information in Kuwait. (Registered 12 October 2004) Overseas visits 80ef1083 2005-01-28 John Lyons uk.org.publicwhip/member/1060 John Lyons uk.org.publicwhip/person/11060 1 2005-01-28-80ef1083-11060-0
1579d8de88c2b6851b92697ca97e30582f780de7 As a member of the All-Party Parliamentary Kuwait Group, on my visit to Kuwait City in May 2004 I received a gift of an Omega watch from the Ministry of Information in Kuwait. (Registered 9 December 2004) Overseas benefits and gifts a41b9847 2005-01-28 John Lyons uk.org.publicwhip/member/1060 John Lyons uk.org.publicwhip/person/11060 0 2005-01-28-a41b9847-11060-0
fec25033a2654852bd0e37ab59a0347da8df25e2 10-13 October 2003, to Cyprus to attend the Annual Morphou Rally. Travel and accommodation paid for by the Municipality of Morphou. (Registered 7 January 2004) Overseas visits 80ef1083 2004-12-03 John Lyons uk.org.publicwhip/member/1060 John Lyons uk.org.publicwhip/person/11060 0 2004-12-03-80ef1083-11060-0
06d8b9223c3065e41c12ee18692c641e278de45e 25-28 October 2003, to Jerusalem to attend Medbridge Strategy Centre's Peace Conference in Middle East. Return flights from Zurich-Amman, Jordan and accommodation paid for by Medbridge. (Registered 7 January 2004) Overseas visits 80ef1083 2004-12-03 John Lyons uk.org.publicwhip/member/1060 John Lyons uk.org.publicwhip/person/11060 1 2004-12-03-80ef1083-11060-0
1bb6b3164642b6f0db28caea9930cf4dec676e49 24-30 November 2003, to USA as a guest of First Group to examine Yellow Bus School transport. Return flights and accommodation paid for by First Group. (Registered 7 January 2004) Overseas visits 80ef1083 2004-12-03 John Lyons uk.org.publicwhip/member/1060 John Lyons uk.org.publicwhip/person/11060 2 2004-12-03-80ef1083-11060-0
ec627dcf36a4d907bfd9df8277d45cca261ef82f 11-14 June 2004, to Portugal as a member of the All-Party Parliamentary Football Team, with travel, accommodation and hospitality provided by McDonalds, and football facilities and hospitality by the Portuguese Parliament. (Registered 15 July 2004) Overseas visits 80ef1083 2004-12-03 John Lyons uk.org.publicwhip/member/1060 John Lyons uk.org.publicwhip/person/11060 3 2004-12-03-80ef1083-11060-0
0bfcdd8d2493d77c11d03cfe4adc10d6451d274d 7-11 May 2004, to Kuwait as a member of the All-Party Parliamentary Kuwait Group. Air fare and hospitality was provided by Ministry of Information in Kuwait. (Registered 12 October 2004) Overseas visits 80ef1083 2004-12-03 John Lyons uk.org.publicwhip/member/1060 John Lyons uk.org.publicwhip/person/11060 4 2004-12-03-80ef1083-11060-0
d7be9a93464cad24a8919b2910e71605a9cff3d7 10-13 October 2003, to Cyprus to attend the Annual Morphou Rally. Travel and accommodation paid for by the Municipality of Morphou. (Registered 7 January 2004) Overseas visits 80ef1083 2004-10-22 John Lyons uk.org.publicwhip/member/1060 John Lyons uk.org.publicwhip/person/11060 0 2004-10-22-80ef1083-11060-0
1005bc1ecc139bfff8774576f45771d73abe9b84 25-28 October 2003, to Jerusalem to attend Medbridge Strategy Centre's Peace Conference in Middle East. Return flights from Zurich-Amman, Jordan and accommodation paid for by Medbridge. (Registered 7 January 2004) Overseas visits 80ef1083 2004-10-22 John Lyons uk.org.publicwhip/member/1060 John Lyons uk.org.publicwhip/person/11060 1 2004-10-22-80ef1083-11060-0
1f5ed3b58fb9d185add90e13a110bf0e784ce7aa 24-30 November 2003, to USA as a guest of First Group to examine Yellow Bus School transport. Return flights and accommodation paid for by First Group. (Registered 7 January 2004) Overseas visits 80ef1083 2004-10-22 John Lyons uk.org.publicwhip/member/1060 John Lyons uk.org.publicwhip/person/11060 2 2004-10-22-80ef1083-11060-0
dd4c2befa2693bdd47c0d11a88b7609b44df95e6 11-14 June 2004, to Portugal as a member of the All-Party Parliamentary Football Team, with travel, accommodation and hospitality provided by McDonalds, and football facilities and hospitality by the Portuguese Parliament. (Registered 15 July 2004) Overseas visits 80ef1083 2004-10-22 John Lyons uk.org.publicwhip/member/1060 John Lyons uk.org.publicwhip/person/11060 3 2004-10-22-80ef1083-11060-0
7ab6d0b722bd852881f1c32b87f67a214504a6bb 7-11 May 2004, to Kuwait as a member of the All-Party Parliamentary Kuwait Group. Air fare and hospitality was provided by Ministry of Information in Kuwait. (Registered 12 October 2004) Overseas visits 80ef1083 2004-10-22 John Lyons uk.org.publicwhip/member/1060 John Lyons uk.org.publicwhip/person/11060 4 2004-10-22-80ef1083-11060-0
a9caee75de736ddc008c15f382835c402481ab8a 10-13 October 2003, to Cyprus to attend the Annual Morphou Rally. Travel and accommodation paid for by the Municipality of Morphou. (Registered 7 January 2004) Overseas visits 80ef1083 2004-09-08 John Lyons uk.org.publicwhip/member/1060 John Lyons uk.org.publicwhip/person/11060 0 2004-09-08-80ef1083-11060-0
d52a765a08ba9ffa46ab0b036ed79c131244956c 25-28 October 2003, to Jerusalem to attend Medbridge Strategy Centre's Peace Conference in Middle East. Return flights from Zurich-Amman, Jordan and accommodation paid for by Medbridge. (Registered 7 January 2004) Overseas visits 80ef1083 2004-09-08 John Lyons uk.org.publicwhip/member/1060 John Lyons uk.org.publicwhip/person/11060 1 2004-09-08-80ef1083-11060-0
ebabf49438e2b83b432925357bb05a8a1764ba60 24-30 November 2003, to USA as a guest of First Group to examine Yellow Bus School transport. Return flights and accommodation paid for by First Group. (Registered 7 January 2004) Overseas visits 80ef1083 2004-09-08 John Lyons uk.org.publicwhip/member/1060 John Lyons uk.org.publicwhip/person/11060 2 2004-09-08-80ef1083-11060-0
17e0e8ece8349cbc95ce3d3a33b56f7057321b96 11-14 June 2004, to Portugal as a member of the All-Party Parliamentary Football Team, with travel, accommodation and hospitality provided by McDonalds, and football facilities and hospitality by the Portuguese Parliament. (Registered 15 July 2004) Overseas visits 80ef1083 2004-09-08 John Lyons uk.org.publicwhip/member/1060 John Lyons uk.org.publicwhip/person/11060 3 2004-09-08-80ef1083-11060-0
093037411dafb70d8f43e70a0e9abd87f7434eba 10-13 October 2003, to Cyprus to attend the Annual Morphou Rally. Travel and accommodation paid for by the Municipality of Morphou. (Registered 7 January 2004) Overseas visits 80ef1083 2004-07-16 John Lyons uk.org.publicwhip/member/1060 John Lyons uk.org.publicwhip/person/11060 0 2004-07-16-80ef1083-11060-0
f848fb55711c75662646643e952be8f11787bbe9 25-28 October 2003, to Jerusalem to attend Medbridge Strategy Centre's Peace Conference in Middle East. Return flights from Zurich-Amman, Jordan and accommodation paid for by Medbridge. (Registered 7 January 2004) Overseas visits 80ef1083 2004-07-16 John Lyons uk.org.publicwhip/member/1060 John Lyons uk.org.publicwhip/person/11060 1 2004-07-16-80ef1083-11060-0
a394b35f6d77f9cceddc52479c9b209b1d6c5a8e 24-30 November 2003, to USA as a guest of First Group to examine Yellow Bus School transport. Return flights and accommodation paid for by First Group. (Registered 7 January 2004) Overseas visits 80ef1083 2004-07-16 John Lyons uk.org.publicwhip/member/1060 John Lyons uk.org.publicwhip/person/11060 2 2004-07-16-80ef1083-11060-0
ac9f5cfbb989e48d68a72a0e786889f21eacf0d5 11-14 June 2004, to Portugal as a member of the All-Party Parliamentary Football Team, with travel, accommodation and hospitality provided by McDonalds, and football facilities and hospitality by the Portuguese Parliament. (Registered 15 July 2004) Overseas visits 80ef1083 2004-07-16 John Lyons uk.org.publicwhip/member/1060 John Lyons uk.org.publicwhip/person/11060 3 2004-07-16-80ef1083-11060-0
9908232c6486cedd48ed6878e34c0aec865028b3 10-13 October 2003, to Cyprus to attend the Annual Morphou Rally. Travel and accommodation paid for by the Municipality of Morphou. (Registered 7 January 2004) Overseas visits 80ef1083 2004-05-21 John Lyons uk.org.publicwhip/member/1060 John Lyons uk.org.publicwhip/person/11060 0 2004-05-21-80ef1083-11060-0
103c9d3f712cf6fd8b07608b3c639e6d30a5bbaf 25-28 October 2003, to Jerusalem to attend Medbridge Strategy Centre's Peace Conference in Middle East. Return flights from Zurich-Amman, Jordan and accommodation paid for by Medbridge. (Registered 7 January 2004) Overseas visits 80ef1083 2004-05-21 John Lyons uk.org.publicwhip/member/1060 John Lyons uk.org.publicwhip/person/11060 1 2004-05-21-80ef1083-11060-0
791a8f36cde3b7023443394154174723e08299f7 24-30 November 2003, to USA as a guest of First Group to examine Yellow Bus School transport. Return flights and accommodation paid for by First Group. (Registered 7 January 2004) Overseas visits 80ef1083 2004-05-21 John Lyons uk.org.publicwhip/member/1060 John Lyons uk.org.publicwhip/person/11060 2 2004-05-21-80ef1083-11060-0
825afcf94dca8c141a1d5fc26684d390fcdfb8b2 10-13 October 2003, to Cyprus to attend the Annual Morphou Rally. Travel and accommodation paid for by the Municipality of Morphou. (Registered 7 January 2004) Overseas visits 80ef1083 2004-01-31 John Lyons uk.org.publicwhip/member/1060 John Lyons uk.org.publicwhip/person/11060 0 2004-01-31-80ef1083-11060-0
3783ca6136fd820bd144fbf080d0b80ed9bf3222 25-28 October 2003, to Jerusalem to attend Medbridge Strategy Centre's Peace Conference in Middle East. Return flights from Zurich-Amman, Jordan and accommodation paid for by Medbridge. (Registered 7 January 2004) Overseas visits 80ef1083 2004-01-31 John Lyons uk.org.publicwhip/member/1060 John Lyons uk.org.publicwhip/person/11060 1 2004-01-31-80ef1083-11060-0
6cd08fe1501d502fb9d85a49deebad23d85f63f1 24-30 November 2003, to USA as a guest of First Group to examine Yellow Bus School transport. Return flights and accommodation paid for by First Group. (Registered 7 January 2004) Overseas visits 80ef1083 2004-01-31 John Lyons uk.org.publicwhip/member/1060 John Lyons uk.org.publicwhip/person/11060 2 2004-01-31-80ef1083-11060-0
6bc80fab4948fe523606860c04bd01469e57c1c4 18-21 October 2002, to Cyprus, at invitation of Friends of Barnet Morphou in Cyprus. Return flights and accommodation paid for by Friends of Barnet Morphou. (Registered 17 October 2002) Overseas visits 80ef1083 2002-11-26 John Lyons uk.org.publicwhip/member/1060 John Lyons uk.org.publicwhip/person/11060 0 2002-11-26-80ef1083-11060-0
07bcff20dd4ab8d2f65b8603255f251124bdccee 3-9 November 2002, to Hong Kong, as part of Hong Kong committee of the All-Party Parliamentary China Group UK. Flights, accommodation and meals paid for by the Hong Kong Special Administrative Regional Government. (Registered 17 October 2002) Overseas visits 80ef1083 2002-11-26 John Lyons uk.org.publicwhip/member/1060 John Lyons uk.org.publicwhip/person/11060 1 2002-11-26-80ef1083-11060-0
676ad8e4cda9b3fc706444b4aeaa152b55691427 A contribution of more than 25% of my election expenses at the 2001 General Election was made by UNISON. (I was previously employed by UNISON and remain a member.) (Registered 1 September 2001) Sponsorship or financial or material support 9e46def6 2002-05-14 John Lyons uk.org.publicwhip/member/1060 John Lyons uk.org.publicwhip/person/11060 0 2002-05-14-9e46def6-11060-0

Advanced export

JSON shape: default, array, newline-delimited, 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)
    );
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");
Powered by Datasette · Query took 18.202ms · Data source: mySociety Data · About: simonw/register-of-members-interests