items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
13 rows where member_id = "uk.org.publicwhip/member/1060" and sort_order = 0 sorted by date descending
This data as json, CSV (advanced)
Suggested facets: item, category_id, date, 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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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
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");