items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
29 rows where person_id = "uk.org.publicwhip/person/10229" sorted by date descending
This data as json, CSV (advanced)
Suggested facets: item, category_id, date, member_id, sort_order, record_id, date (date)
hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
7322d60cb7fea8ebac7e0aa2b191dd029f6ab252 | 8-24 September 2005, to Taiwan as a member of a parliamentary delegation. Travel and accommodation paid for by the Government of Taiwan. (Registered 10 October 2005) | Overseas visits 80ef1083 | 2006-09-19 | Linda Gilroy uk.org.publicwhip/member/1761 | Linda Gilroy uk.org.publicwhip/person/10229 | 0 | 2006-09-19-80ef1083-10229-0 |
f13c689be72c8a453d07eaf4f81f3c3e144ae6ae | 8-24 September 2005, to Taiwan as a member of a parliamentary delegation. Travel and accommodation paid for by the Government of Taiwan. (Registered 10 October 2005) | Overseas visits 80ef1083 | 2006-07-25 | Linda Gilroy uk.org.publicwhip/member/1761 | Linda Gilroy uk.org.publicwhip/person/10229 | 0 | 2006-07-25-80ef1083-10229-0 |
6bc74a1127f5744c4e723f9795d82f21e770873d | 8-24 September 2005, to Taiwan as a member of a parliamentary delegation. Travel and accommodation paid for by the Government of Taiwan. (Registered 10 October 2005) | Overseas visits 80ef1083 | 2006-06-21 | Linda Gilroy uk.org.publicwhip/member/1761 | Linda Gilroy uk.org.publicwhip/person/10229 | 0 | 2006-06-21-80ef1083-10229-0 |
da36c5897efc92f67f87394c20c28219f56745ef | 8-24 September 2005, to Taiwan as a member of a parliamentary delegation. Travel and accommodation paid for by the Government of Taiwan. (Registered 10 October 2005) | Overseas visits 80ef1083 | 2006-05-12 | Linda Gilroy uk.org.publicwhip/member/1761 | Linda Gilroy uk.org.publicwhip/person/10229 | 0 | 2006-05-12-80ef1083-10229-0 |
a02aa4ddf6b65e0b6cc402a1d187de2303122982 | 8-24 September 2005, to Taiwan as a member of a parliamentary delegation. Travel and accommodation paid for by the Government of Taiwan. (Registered 10 October 2005) | Overseas visits 80ef1083 | 2006-03-24 | Linda Gilroy uk.org.publicwhip/member/1761 | Linda Gilroy uk.org.publicwhip/person/10229 | 0 | 2006-03-24-80ef1083-10229-0 |
b8a3ac09354d77acf8ba97cdb89e39f4a19fac60 | 8-24 September 2005, to Taiwan as a member of a parliamentary delegation. Travel and accommodation paid for by the Government of Taiwan. (Registered 10 October 2005) | Overseas visits 80ef1083 | 2006-02-14 | Linda Gilroy uk.org.publicwhip/member/1761 | Linda Gilroy uk.org.publicwhip/person/10229 | 0 | 2006-02-14-80ef1083-10229-0 |
e79eda710723dcb945efc3b07ddc3fa712bdcf88 | 8-24 September 2005, to Taiwan as a member of a parliamentary delegation. Travel and accommodation paid for by the Government of Taiwan. (Registered 10 October 2005) | Overseas visits 80ef1083 | 2006-02-13 | Linda Gilroy uk.org.publicwhip/member/1761 | Linda Gilroy uk.org.publicwhip/person/10229 | 0 | 2006-02-13-80ef1083-10229-0 |
5d0c1d1302186c754d86d4a144eea1f54e81a7e8 | 8-24 September 2005, to Taiwan as a member of a parliamentary delegation. Travel and accommodation paid for by the Government of Taiwan. (Registered 10 October 2005) | Overseas visits 80ef1083 | 2005-12-14 | Linda Gilroy uk.org.publicwhip/member/1761 | Linda Gilroy uk.org.publicwhip/person/10229 | 0 | 2005-12-14-80ef1083-10229-0 |
facc5d1998792e5baed6726cad8f077bb06e5eca | 30 September-5 October 2004, to Kazakhstan. Accommodation paid for by the Parliament of Kazakhstan Travel paid for by the Consolidated Construction International Company (CCC) and British Gas (BG). (Registered 16 November 2004) | Overseas visits 80ef1083 | 2005-11-01 | Linda Gilroy uk.org.publicwhip/member/1761 | Linda Gilroy uk.org.publicwhip/person/10229 | 0 | 2005-11-01-80ef1083-10229-0 |
45aef32e538112e0e3f36d9078dadbbdeee853b8 | 18-24 September 2005, to Taiwan as a member of a parliamentary delegation. Travel and accommodation paid for by the Government of Taiwan. (Registered 10 October 2005) | Overseas visits 80ef1083 | 2005-11-01 | Linda Gilroy uk.org.publicwhip/member/1761 | Linda Gilroy uk.org.publicwhip/person/10229 | 1 | 2005-11-01-80ef1083-10229-0 |
0d6bae09c2094e749455fe3cbc224db6bc7bb795 | 30 September-5 October 2004, to Kazakhstan. Accommodation paid for by the Parliament of Kazakhstan Travel paid for by the Consolidated Construction International Company (CCC) and British Gas (BG). (Registered 16 November 2004) | Overseas visits 80ef1083 | 2005-04-11 | Linda Gilroy uk.org.publicwhip/member/915 | Linda Gilroy uk.org.publicwhip/person/10229 | 0 | 2005-04-11-80ef1083-10229-0 |
db12edcd291475a65d5490ab180ee8a2f7cf3a96 | 30 September-5 October 2004, to Kazakhstan. Accommodation paid for by the Parliament of Kazakhstan Travel paid for by the Consolidated Construction International Company (CCC) and British Gas (BG). (Registered 16 November 2004) | Overseas visits 80ef1083 | 2005-01-28 | Linda Gilroy uk.org.publicwhip/member/915 | Linda Gilroy uk.org.publicwhip/person/10229 | 0 | 2005-01-28-80ef1083-10229-0 |
ee8141d3cef222cc1feaa6d1abf12a01520734d7 | 30 September-5 October 2004, to Kazakhstan. Accommodation paid for by the Parliament of Kazakhstan Travel paid for by the Consolidated Construction International Company (CCC) and British Gas (BG). (Registered 16 November 2004) | Overseas visits 80ef1083 | 2004-12-03 | Linda Gilroy uk.org.publicwhip/member/915 | Linda Gilroy uk.org.publicwhip/person/10229 | 0 | 2004-12-03-80ef1083-10229-0 |
805460fd35b7919bc89ea75147c071c7de6b0efa | 8-13 November 2002, to Kazakhstan as a member of a delegation who were guests of the Parliament of Kazakhstan. The external flights and transport to and from the airport were paid for by Consolidated Construction International (UK Ltd). Internal flights, accommodation and sundry small token gifts were paid for by the Kazakhstan Government. (Registered 24 December 2002) | Overseas visits 80ef1083 | 2004-07-16 | Linda Gilroy uk.org.publicwhip/member/915 | Linda Gilroy uk.org.publicwhip/person/10229 | 0 | 2004-07-16-80ef1083-10229-0 |
1a033e0ad07e1e0d9c07d328b6dc2ff79a5237a7 | 8-13 November 2002, to Kazakhstan as a member of a delegation who were guests of the Parliament of Kazakhstan. The external flights and transport to and from the airport were paid for by Consolidated Construction International (UK Ltd). Internal flights, accommodation and sundry small token gifts were paid for by the Kazakhstan Government. (Registered 24 December 2002) | Overseas visits 80ef1083 | 2004-05-21 | Linda Gilroy uk.org.publicwhip/member/915 | Linda Gilroy uk.org.publicwhip/person/10229 | 0 | 2004-05-21-80ef1083-10229-0 |
854d9951e8e454f316506cb6450fff9117a4cfb9 | 8-13 November 2002, to Kazakhstan as a member of a delegation who were guests of the Parliament of Kazakhstan. The external flights and transport to and from the airport were paid for by Consolidated Construction International (UK Ltd). Internal flights, accommodation and sundry small token gifts were paid for by the Kazakhstan Government. (Registered 24 December 2002) | Overseas visits 80ef1083 | 2004-01-31 | Linda Gilroy uk.org.publicwhip/member/915 | Linda Gilroy uk.org.publicwhip/person/10229 | 0 | 2004-01-31-80ef1083-10229-0 |
d7f622b26a784c5472504dfdbf604e50177a5a3c | 8-13 November 2002, to Kazakhstan as a member of a delegation who were guests of the Parliament of Kazakhstan. The external flights and transport to and from the airport were paid for by Consolidated Construction International (UK Ltd). Internal flights, accommodation and sundry small token gifts were paid for by the Kazakhstan Government. (Registered 24 December 2002) | Overseas visits 80ef1083 | 2003-12-04 | Linda Gilroy uk.org.publicwhip/member/915 | Linda Gilroy uk.org.publicwhip/person/10229 | 0 | 2003-12-04-80ef1083-10229-0 |
b6f3d788b4622df4355305b362c8987ebc1300ad | Occasional fees for journalism. | Remunerated employment, office, profession etc 1f359ece | 2001-05-14 | Linda Gilroy uk.org.publicwhip/member/229 | Linda Gilroy uk.org.publicwhip/person/10229 | 0 | 2001-05-14-1f359ece-10229-0 |
2b94763d9895126d904d1bae847436665c1bdeff | The following sponsorship was provided for my Christmas Card competition 2000: | Sponsorship or financial or material support 9e46def6 | 2001-05-14 | Linda Gilroy uk.org.publicwhip/member/229 | Linda Gilroy uk.org.publicwhip/person/10229 | 0 | 2001-05-14-9e46def6-10229-0 |
57a9a102eb0f5c5e7f0c1bd9b3a99cbcf010bf23 | Plymouth College of Further Education - £100 (general) | Sponsorship or financial or material support 9e46def6 | 2001-05-14 | Linda Gilroy uk.org.publicwhip/member/229 | Linda Gilroy uk.org.publicwhip/person/10229 | 1 | 2001-05-14-9e46def6-10229-0 |
fdb6c98937493533e49dde585f6e9d1d450f1fda | Somerfield - £320 (costs for prize presentation) | Sponsorship or financial or material support 9e46def6 | 2001-05-14 | Linda Gilroy uk.org.publicwhip/member/229 | Linda Gilroy uk.org.publicwhip/person/10229 | 2 | 2001-05-14-9e46def6-10229-0 |
a0336262e2acb5ba4ce057e55e37580189d35b64 | University of Plymouth - £700 | Sponsorship or financial or material support 9e46def6 | 2001-05-14 | Linda Gilroy uk.org.publicwhip/member/229 | Linda Gilroy uk.org.publicwhip/person/10229 | 3 | 2001-05-14-9e46def6-10229-0 |
eac58b307184935c024a97fd858e9c662a16aad3 | Indirect sponsorship for the competition was provided by: | Sponsorship or financial or material support 9e46def6 | 2001-05-14 | Linda Gilroy uk.org.publicwhip/member/229 | Linda Gilroy uk.org.publicwhip/person/10229 | 4 | 2001-05-14-9e46def6-10229-0 |
fdb452fd0726d0a229114a85272d3dd38549f809 | Lipson Community College - staff assistance in preparing and mounting the exhibition. | Sponsorship or financial or material support 9e46def6 | 2001-05-14 | Linda Gilroy uk.org.publicwhip/member/229 | Linda Gilroy uk.org.publicwhip/person/10229 | 5 | 2001-05-14-9e46def6-10229-0 |
3a219bb0b23f51a8db0701fa1bd377cdbb12da87 | National Maritime Aquarium - 700 Free Admission Vouchers for all the children who participated in the competition. | Sponsorship or financial or material support 9e46def6 | 2001-05-14 | Linda Gilroy uk.org.publicwhip/member/229 | Linda Gilroy uk.org.publicwhip/person/10229 | 6 | 2001-05-14-9e46def6-10229-0 |
d09642e205539b2e4562b5df102e0dc75e3dc50b | Plymouth College of Art and Design - staff assistance/time in judging process. | Sponsorship or financial or material support 9e46def6 | 2001-05-14 | Linda Gilroy uk.org.publicwhip/member/229 | Linda Gilroy uk.org.publicwhip/person/10229 | 7 | 2001-05-14-9e46def6-10229-0 |
006b38bbeff76a4de18b6ec6d39a52739cbe0e45 | Plymouth Theatre Royal - free exhibition space from 13 November 2000 to mid-January 2001. | Sponsorship or financial or material support 9e46def6 | 2001-05-14 | Linda Gilroy uk.org.publicwhip/member/229 | Linda Gilroy uk.org.publicwhip/person/10229 | 8 | 2001-05-14-9e46def6-10229-0 |
1468a3b9af8ec9d55a00f43890a326c85d1329f6 | Occasional fees for journalism. | Remunerated employment, office, profession etc 1f359ece | 2000-11-10 | Linda Gilroy uk.org.publicwhip/member/229 | Linda Gilroy uk.org.publicwhip/person/10229 | 0 | 2000-11-10-1f359ece-10229-0 |
08d20390e689a93d5ce6f057936b19d38ddca6df | Free loan of two VS1 Video telephone units from BT for use in my London office and the constituency during July 1999. (Registered 31 July 1999) | Gifts, benefits and hospitality (UK) 84642823 | 2000-11-10 | Linda Gilroy uk.org.publicwhip/member/229 | Linda Gilroy uk.org.publicwhip/person/10229 | 0 | 2000-11-10-84642823-10229-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");