items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
180 rows where person_id = "uk.org.publicwhip/person/10329" sorted by hash
This data as json, CSV (advanced)
Suggested facets: category_id, sort_order, date (date)
item 17 ✖
- 15-17 May 2008, to Guernsey at the invitation of the States of Guernsey, to play a football match with accommodation and hospitality provided by the States of Guernsey and a contribution to the air fare provided by our club sponsors National Grid. (Registered 12 June 2008) 20
- 16 December 2006-7 January 2007, to Australia and New Zealand with the Lords and Commons Cricket Team for inter-parliamentary matches. I was accompanied by my wife, Ann Keen MP, and our son and we paid our own travel and accommodation costs. Sponsorship was received from Diageo, Microsoft, Colliers, Vauxhall, Visa and the Australian Parliament Sports Club which was given to the following charities: the Trew Foundation (New Zealand), the Lord's Taverners (Australia) and Chance to Shine (UK), with the exception of a small proportion retained for incidental expenses. (Registered 3 April 2007) 19
- (Registered 22 June 2010) 17
- Address of donor: 60-62 Clapham Road, London SW9 0JJ. 17
- Amount of donation or nature and value if donation in kind: £5,000 17
- Donations to the constituency party or association, which have been or will be reported by the party to the Electoral Commission: 17
- Donor status: trade union 17
- Name of donor: Musicians’ Union 17
- 8-11 June 2006, to Germany as a member of the UK Parliamentary Football Club, to attend the World Cup and play football matches for charity. I received match ticket, hospitality and coach transport from McDonald's, and hospitality and coach transport from National Grid. (Registered 20 October 2006) 16
- 18 March 2011, received payment of £75 from Populus, 10 Northburgh Street, London EC1V 0AT, for opinion survey in February 2011. Hours: 15 mins. Payment donated to my constituency party. (Registered 18 April 2011) 10
- 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 14 July 2004) 5
- 16 December 2006-7 January 2007, to Australia and New Zealand with the Lords and Commons Cricket Team for inter-parliamentary matches. I was accompanied by my wife, Ann Keen MP, and our son and we paid our own travel and accommodation costs. Sponsorship was received from Diageo, Microsoft, Colliers, Vauxhall, Visa and the Australian Parliament Sports Club which was given to the following charities: the Trew Foundation (New Zealand), the Lord's Taverners (Australia) and Chance to Shine (UK), with the exception of a small proportion retained for incidental expenses. (Registered 3 April 2007) 3
- 28 May-8 June 2002, to Japan as a member of the Parliamentary Football Club, with a contribution towards the cost of the trip from Nomura Bank, First Group, T-Mobile and Waterfront Properties; hospitality and transport provided by Nomura Bank, transport by First Group; sports kit by Nike; and suits and accessories at discounted price by Burtons. (Registered 20 July 2002) 1
- 8-11 September 2001, to Gibraltar, to meet First Minister and others. Travel and hotel paid for by Government of Gibraltar. (Registered 20 July 2002) 1
- 10 September 1999, to Portugal with the Parliamentary Football Team, travel costs met by National Express Ltd., cost of football kit met by Spall Sports. (Registered 12 January 2000) 1
- 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 14 July 2004) 1
- September 1999, during the visit of the Hungarian Parliamentary Football Team to the UK, I received hospitality sponsored by Powergen Ltd., Provident Finance and West Ham FC. (Registered 12 January 2000) 1
hash ▼ | item | category_id | date | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
013ce98220838a5516137b18584d2f025a2a2771 | Donations to the constituency party or association, which have been or will be reported by the party to the Electoral Commission: | Sponsorships 8f616a6e | 2011-04-18 | Alan Keen uk.org.publicwhip/member/40258 | Alan Keen uk.org.publicwhip/person/10329 | 0 | 2011-04-18-8f616a6e-10329-0 |
01d665aa4cd84a257faa11ed8019f2019b22f6d0 | Amount of donation or nature and value if donation in kind: £5,000 | Sponsorships 8f616a6e | 2011-04-18 | Alan Keen uk.org.publicwhip/member/40258 | Alan Keen uk.org.publicwhip/person/10329 | 3 | 2011-04-18-8f616a6e-10329-0 |
021bb92111b968316c4c2ad7c749dcc6632e7874 | (Registered 22 June 2010) | Sponsorships 8f616a6e | 2011-02-07 | Alan Keen uk.org.publicwhip/member/40258 | Alan Keen uk.org.publicwhip/person/10329 | 5 | 2011-02-07-8f616a6e-10329-0 |
0437da87304f11384638f07bf93419b1ac52054f | Donor status: trade union | Sponsorships 8f616a6e | 2010-12-20 | Alan Keen uk.org.publicwhip/member/40258 | Alan Keen uk.org.publicwhip/person/10329 | 4 | 2010-12-20-8f616a6e-10329-0 |
04865bcf9c76bcdf4aaf107deda21bab3d33c546 | (Registered 22 June 2010) | Sponsorships 8f616a6e | 2011-01-24 | Alan Keen uk.org.publicwhip/member/40258 | Alan Keen uk.org.publicwhip/person/10329 | 5 | 2011-01-24-8f616a6e-10329-0 |
04f8cdf745eddbde5383a31e3d24855e2cdbcadb | Amount of donation or nature and value if donation in kind: £5,000 | Sponsorships 8f616a6e | 2010-12-20 | Alan Keen uk.org.publicwhip/member/40258 | Alan Keen uk.org.publicwhip/person/10329 | 3 | 2010-12-20-8f616a6e-10329-0 |
05c7a35dc598c5ad8ad8b33795c8c508c6beb1dd | 15-17 May 2008, to Guernsey at the invitation of the States of Guernsey, to play a football match with accommodation and hospitality provided by the States of Guernsey and a contribution to the air fare provided by our club sponsors National Grid. (Registered 12 June 2008) | Overseas visits 80ef1083 | 2008-11-19 | Alan Keen uk.org.publicwhip/member/1584 | Alan Keen uk.org.publicwhip/person/10329 | 0 | 2008-11-19-80ef1083-10329-0 |
076997b86816ef6cb8f1f9ddad302416dc3858c6 | Address of donor: 60-62 Clapham Road, London SW9 0JJ. | Sponsorships 8f616a6e | 2011-03-14 | Alan Keen uk.org.publicwhip/member/40258 | Alan Keen uk.org.publicwhip/person/10329 | 2 | 2011-03-14-8f616a6e-10329-0 |
084ea2b153e49639ebed9150b449aca80317d7fc | 16 December 2006-7 January 2007, to Australia and New Zealand with the Lords and Commons Cricket Team for inter-parliamentary matches. I was accompanied by my wife, Ann Keen MP, and our son and we paid our own travel and accommodation costs. Sponsorship was received from Diageo, Microsoft, Colliers, Vauxhall, Visa and the Australian Parliament Sports Club which was given to the following charities: the Trew Foundation (New Zealand), the Lord's Taverners (Australia) and Chance to Shine (UK), with the exception of a small proportion retained for incidental expenses. (Registered 3 April 2007) | Overseas visits 80ef1083 | 2007-12-04 | Alan Keen uk.org.publicwhip/member/1584 | Alan Keen uk.org.publicwhip/person/10329 | 0 | 2007-12-04-80ef1083-10329-0 |
0b8c3875da66fca7e6828375394dfa456397755d | Address of donor: 60-62 Clapham Road, London SW9 0JJ. | Sponsorships 8f616a6e | 2011-02-07 | Alan Keen uk.org.publicwhip/member/40258 | Alan Keen uk.org.publicwhip/person/10329 | 2 | 2011-02-07-8f616a6e-10329-0 |
0bf66d27890f0892d97c7fcb7ab87d0fe7177e68 | 15-17 May 2008, to Guernsey at the invitation of the States of Guernsey, to play a football match with accommodation and hospitality provided by the States of Guernsey and a contribution to the air fare provided by our club sponsors National Grid. (Registered 12 June 2008) | Overseas visits 80ef1083 | 2009-06-10 | Alan Keen uk.org.publicwhip/member/1584 | Alan Keen uk.org.publicwhip/person/10329 | 0 | 2009-06-10-80ef1083-10329-0 |
0d6e0e902ddf580edb657498e9ec1c5370bd6251 | Name of donor: Musicians’ Union | Sponsorships 8f616a6e | 2011-03-28 | Alan Keen uk.org.publicwhip/member/40258 | Alan Keen uk.org.publicwhip/person/10329 | 1 | 2011-03-28-8f616a6e-10329-0 |
0d76f339c62485553cda5fd43696614b66da9977 | 16 December 2006-7 January 2007, to Australia and New Zealand with the Lords and Commons Cricket Team for inter-parliamentary matches. I was accompanied by my wife, Ann Keen MP, and our son and we paid our own travel and accommodation costs. Sponsorship was received from Diageo, Microsoft, Colliers, Vauxhall, Visa and the Australian Parliament Sports Club which was given to the following charities: the Trew Foundation (New Zealand), the Lord's Taverners (Australia) and Chance to Shine (UK), with the exception of a small proportion retained for incidental expenses. (Registered 3 April 2007) | Overseas visits 80ef1083 | 2008-04-23 | Alan Keen uk.org.publicwhip/member/1584 | Alan Keen uk.org.publicwhip/person/10329 | 0 | 2008-04-23-80ef1083-10329-0 |
0d7a4137fb5771855c8d177580e3cfe1511c2e1c | Donations to the constituency party or association, which have been or will be reported by the party to the Electoral Commission: | Sponsorships 8f616a6e | 2010-11-08 | Alan Keen uk.org.publicwhip/member/40258 | Alan Keen uk.org.publicwhip/person/10329 | 0 | 2010-11-08-8f616a6e-10329-0 |
0dda95a85201890dd4640d6dc3381a665a1e386e | 15-17 May 2008, to Guernsey at the invitation of the States of Guernsey, to play a football match with accommodation and hospitality provided by the States of Guernsey and a contribution to the air fare provided by our club sponsors National Grid. (Registered 12 June 2008) | Overseas visits 80ef1083 | 2008-07-08 | Alan Keen uk.org.publicwhip/member/1584 | Alan Keen uk.org.publicwhip/person/10329 | 0 | 2008-07-08-80ef1083-10329-0 |
0ed1d81f3c27f235756c8f4f759f602866464b92 | (Registered 22 June 2010) | Sponsorships 8f616a6e | 2011-04-18 | Alan Keen uk.org.publicwhip/member/40258 | Alan Keen uk.org.publicwhip/person/10329 | 5 | 2011-04-18-8f616a6e-10329-0 |
136ee151790f8b144b81d3afb7aa223fc0115ca0 | Name of donor: Musicians’ Union | Sponsorships 8f616a6e | 2010-11-08 | Alan Keen uk.org.publicwhip/member/40258 | Alan Keen uk.org.publicwhip/person/10329 | 1 | 2010-11-08-8f616a6e-10329-0 |
147d5d096e97ae0f6c117939fdd0bc14974a327b | 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 14 July 2004) | Overseas visits 80ef1083 | 2004-09-08 | Alan Keen uk.org.publicwhip/member/1011 | Alan Keen uk.org.publicwhip/person/10329 | 0 | 2004-09-08-80ef1083-10329-0 |
1492d2d9d53313dd112bb56d85a34141ab6457c0 | 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 14 July 2004) | Overseas visits 80ef1083 | 2004-12-03 | Alan Keen uk.org.publicwhip/member/1011 | Alan Keen uk.org.publicwhip/person/10329 | 0 | 2004-12-03-80ef1083-10329-0 |
14b0b2263e637d5ae5b87ddf1348e3947b811ae5 | 16 December 2006-7 January 2007, to Australia and New Zealand with the Lords and Commons Cricket Team for inter-parliamentary matches. I was accompanied by my wife, Ann Keen MP, and our son and we paid our own travel and accommodation costs. Sponsorship was received from Diageo, Microsoft, Colliers, Vauxhall, Visa and the Australian Parliament Sports Club which was given to the following charities: the Trew Foundation (New Zealand), the Lord's Taverners (Australia) and Chance to Shine (UK), with the exception of a small proportion retained for incidental expenses. (Registered 3 April 2007) | Overseas visits 80ef1083 | 2008-02-05 | Alan Keen uk.org.publicwhip/member/1584 | Alan Keen uk.org.publicwhip/person/10329 | 0 | 2008-02-05-80ef1083-10329-0 |
1688e020c9a8d3163017618286609164bacab050 | Donor status: trade union | Sponsorships 8f616a6e | 2011-06-20 | Alan Keen uk.org.publicwhip/member/40258 | Alan Keen uk.org.publicwhip/person/10329 | 4 | 2011-06-20-8f616a6e-10329-0 |
1922572c631919b96d4c82ea438705b0d0cd03b0 | Amount of donation or nature and value if donation in kind: £5,000 | Sponsorships 8f616a6e | 2011-06-06 | Alan Keen uk.org.publicwhip/member/40258 | Alan Keen uk.org.publicwhip/person/10329 | 3 | 2011-06-06-8f616a6e-10329-0 |
19263e6c691505cf162e999ae6a3f5b5923e71f4 | Address of donor: 60-62 Clapham Road, London SW9 0JJ. | Sponsorships 8f616a6e | 2010-11-08 | Alan Keen uk.org.publicwhip/member/40258 | Alan Keen uk.org.publicwhip/person/10329 | 2 | 2010-11-08-8f616a6e-10329-0 |
1a4da168c83f96e5c9fec3af799e0cbd4fff287c | 16 December 2006-7 January 2007, to Australia and New Zealand with the Lords and Commons Cricket Team for inter-parliamentary matches. I was accompanied by my wife, Ann Keen MP, and our son and we paid our own travel and accommodation costs. Sponsorship was received from Diageo, Microsoft, Colliers, Vauxhall, Visa and the Australian Parliament Sports Club which was given to the following charities: the Trew Foundation (New Zealand), the Lord's Taverners (Australia) and Chance to Shine (UK), with the exception of a small proportion retained for incidental expenses. (Registered 3 April 2007) | Overseas visits 80ef1083 | 2007-08-28 | Alan Keen uk.org.publicwhip/member/1584 | Alan Keen uk.org.publicwhip/person/10329 | 1 | 2007-08-28-80ef1083-10329-0 |
1b1183976ab64319b12b4b85556652a00545a53d | Name of donor: Musicians’ Union | Sponsorships 8f616a6e | 2011-03-14 | Alan Keen uk.org.publicwhip/member/40258 | Alan Keen uk.org.publicwhip/person/10329 | 1 | 2011-03-14-8f616a6e-10329-0 |
1dff94c71b68126f006d6a0bb570fd76c6081888 | Address of donor: 60-62 Clapham Road, London SW9 0JJ. | Sponsorships 8f616a6e | 2010-12-20 | Alan Keen uk.org.publicwhip/member/40258 | Alan Keen uk.org.publicwhip/person/10329 | 2 | 2010-12-20-8f616a6e-10329-0 |
1fad421b8029f9eddff492038c16534ee4a11bb6 | Address of donor: 60-62 Clapham Road, London SW9 0JJ. | Sponsorships 8f616a6e | 2010-09-06 | Alan Keen uk.org.publicwhip/member/40258 | Alan Keen uk.org.publicwhip/person/10329 | 2 | 2010-09-06-8f616a6e-10329-0 |
215934c610b1886bbfddc0265e563c392d75032f | Name of donor: Musicians’ Union | Sponsorships 8f616a6e | 2011-06-06 | Alan Keen uk.org.publicwhip/member/40258 | Alan Keen uk.org.publicwhip/person/10329 | 1 | 2011-06-06-8f616a6e-10329-0 |
25a8b00783b62999de68057afccc9973464ea620 | 16 December 2006-7 January 2007, to Australia and New Zealand with the Lords and Commons Cricket Team for inter-parliamentary matches. I was accompanied by my wife, Ann Keen MP, and our son and we paid our own travel and accommodation costs. Sponsorship was received from Diageo, Microsoft, Colliers, Vauxhall, Visa and the Australian Parliament Sports Club which was given to the following charities: the Trew Foundation (New Zealand), the Lord's Taverners (Australia) and Chance to Shine (UK), with the exception of a small proportion retained for incidental expenses. (Registered 3 April 2007) | Overseas visits 80ef1083 | 2008-06-16 | Alan Keen uk.org.publicwhip/member/1584 | Alan Keen uk.org.publicwhip/person/10329 | 0 | 2008-06-16-80ef1083-10329-0 |
2790794b592da5dfa61b8c3a924b0835269f27f2 | (Registered 22 June 2010) | Sponsorships 8f616a6e | 2010-10-25 | Alan Keen uk.org.publicwhip/member/40258 | Alan Keen uk.org.publicwhip/person/10329 | 5 | 2010-10-25-8f616a6e-10329-0 |
27c5642d3eca051a53410c92c5237427289283dc | Amount of donation or nature and value if donation in kind: £5,000 | Sponsorships 8f616a6e | 2011-01-10 | Alan Keen uk.org.publicwhip/member/40258 | Alan Keen uk.org.publicwhip/person/10329 | 3 | 2011-01-10-8f616a6e-10329-0 |
290fcd6f0c23cbf2f72b7875c617bf467514f50e | Amount of donation or nature and value if donation in kind: £5,000 | Sponsorships 8f616a6e | 2011-05-03 | Alan Keen uk.org.publicwhip/member/40258 | Alan Keen uk.org.publicwhip/person/10329 | 3 | 2011-05-03-8f616a6e-10329-0 |
2ae4b9c25cfbb452f218e760782532e3e26be67b | 18 March 2011, received payment of £75 from Populus, 10 Northburgh Street, London EC1V 0AT, for opinion survey in February 2011. Hours: 15 mins. Payment donated to my constituency party. (Registered 18 April 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-10-31 | Alan Keen uk.org.publicwhip/member/40258 | Alan Keen uk.org.publicwhip/person/10329 | 0 | 2011-10-31-1f359ece-10329-0 |
2b2c0c3741f2f416604b625b49e01e93d4e5ba75 | (Registered 22 June 2010) | Sponsorships 8f616a6e | 2010-12-20 | Alan Keen uk.org.publicwhip/member/40258 | Alan Keen uk.org.publicwhip/person/10329 | 5 | 2010-12-20-8f616a6e-10329-0 |
2c194c779fa58a2d861bea8eb3dad79daeb25a4c | Donations to the constituency party or association, which have been or will be reported by the party to the Electoral Commission: | Sponsorships 8f616a6e | 2011-02-07 | Alan Keen uk.org.publicwhip/member/40258 | Alan Keen uk.org.publicwhip/person/10329 | 0 | 2011-02-07-8f616a6e-10329-0 |
30d8ae0a5fc3a324f1c3deea4d52b71868bacf0d | Address of donor: 60-62 Clapham Road, London SW9 0JJ. | Sponsorships 8f616a6e | 2010-10-25 | Alan Keen uk.org.publicwhip/member/40258 | Alan Keen uk.org.publicwhip/person/10329 | 2 | 2010-10-25-8f616a6e-10329-0 |
33df330bdd4a9a5bf520a636c573f6231ee0094a | Donations to the constituency party or association, which have been or will be reported by the party to the Electoral Commission: | Sponsorships 8f616a6e | 2010-10-25 | Alan Keen uk.org.publicwhip/member/40258 | Alan Keen uk.org.publicwhip/person/10329 | 0 | 2010-10-25-8f616a6e-10329-0 |
357f6913a7f1e113df3e0f5dc6cb9bc58e51d01f | Donations to the constituency party or association, which have been or will be reported by the party to the Electoral Commission: | Sponsorships 8f616a6e | 2011-06-06 | Alan Keen uk.org.publicwhip/member/40258 | Alan Keen uk.org.publicwhip/person/10329 | 0 | 2011-06-06-8f616a6e-10329-0 |
3628f7d2b7b0b00baaf0d6696ca77ee059db3883 | Name of donor: Musicians’ Union | Sponsorships 8f616a6e | 2010-09-06 | Alan Keen uk.org.publicwhip/member/40258 | Alan Keen uk.org.publicwhip/person/10329 | 1 | 2010-09-06-8f616a6e-10329-0 |
367eae406db44c6f730b5e2bdc9dcc5894e9c49b | Amount of donation or nature and value if donation in kind: £5,000 | Sponsorships 8f616a6e | 2011-05-16 | Alan Keen uk.org.publicwhip/member/40258 | Alan Keen uk.org.publicwhip/person/10329 | 3 | 2011-05-16-8f616a6e-10329-0 |
36e6c516e84f41536a122e492ed4cd16abf6ddf4 | Donor status: trade union | Sponsorships 8f616a6e | 2010-12-06 | Alan Keen uk.org.publicwhip/member/40258 | Alan Keen uk.org.publicwhip/person/10329 | 4 | 2010-12-06-8f616a6e-10329-0 |
37e8853251a64283231eb960a51147662ed1f5ba | Name of donor: Musicians’ Union | Sponsorships 8f616a6e | 2011-01-24 | Alan Keen uk.org.publicwhip/member/40258 | Alan Keen uk.org.publicwhip/person/10329 | 1 | 2011-01-24-8f616a6e-10329-0 |
386e76257cdec5a531d82b433d7b106b9c5c474d | 8-11 June 2006, to Germany as a member of the UK Parliamentary Football Club, to attend the World Cup and play football matches for charity. I received match ticket, hospitality and coach transport from McDonald's, and hospitality and coach transport from National Grid. (Registered 20 October 2006) | Overseas visits 80ef1083 | 2007-03-26 | Alan Keen uk.org.publicwhip/member/1584 | Alan Keen uk.org.publicwhip/person/10329 | 0 | 2007-03-26-80ef1083-10329-0 |
4114dc8970f7dc41e0e809c5a3d980a0e09668cb | 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 14 July 2004) | Overseas visits 80ef1083 | 2005-04-11 | Alan Keen uk.org.publicwhip/member/1011 | Alan Keen uk.org.publicwhip/person/10329 | 0 | 2005-04-11-80ef1083-10329-0 |
422da5559c7cb4d896887feab4c967586922b08f | Donor status: trade union | Sponsorships 8f616a6e | 2011-06-06 | Alan Keen uk.org.publicwhip/member/40258 | Alan Keen uk.org.publicwhip/person/10329 | 4 | 2011-06-06-8f616a6e-10329-0 |
433f99e571c923d37dd34e7b029c12ce72d8f0ac | Address of donor: 60-62 Clapham Road, London SW9 0JJ. | Sponsorships 8f616a6e | 2011-05-03 | Alan Keen uk.org.publicwhip/member/40258 | Alan Keen uk.org.publicwhip/person/10329 | 2 | 2011-05-03-8f616a6e-10329-0 |
43b1fe57d6c5b9ee0bd3e0a7c6997ebc3c92499a | 16 December 2006-7 January 2007, to Australia and New Zealand with the Lords and Commons Cricket Team for inter-parliamentary matches. I was accompanied by my wife, Ann Keen MP, and our son and we paid our own travel and accommodation costs. Sponsorship was received from Diageo, Microsoft, Colliers, Vauxhall, Visa and the Australian Parliament Sports Club which was given to the following charities: the Trew Foundation (New Zealand), the Lord's Taverners (Australia) and Chance to Shine (UK), with the exception of a small proportion retained for incidental expenses. (Registered 3 April 2007) | Overseas visits 80ef1083 | 2007-11-06 | Alan Keen uk.org.publicwhip/member/1584 | Alan Keen uk.org.publicwhip/person/10329 | 0 | 2007-11-06-80ef1083-10329-0 |
46188478adc73e82032730e5e0c72f8d740301a1 | 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 14 July 2004) | Overseas visits 80ef1083 | 2005-01-28 | Alan Keen uk.org.publicwhip/member/1011 | Alan Keen uk.org.publicwhip/person/10329 | 0 | 2005-01-28-80ef1083-10329-0 |
481776dbca179af9aa092a67c668c5735ca13a5c | Address of donor: 60-62 Clapham Road, London SW9 0JJ. | Sponsorships 8f616a6e | 2011-06-20 | Alan Keen uk.org.publicwhip/member/40258 | Alan Keen uk.org.publicwhip/person/10329 | 2 | 2011-06-20-8f616a6e-10329-0 |
483b50a1aecdd882b56f394733deb4e89f56693d | 16 December 2006-7 January 2007, to Australia and New Zealand with the Lords and Commons Cricket Team for inter-parliamentary matches. I was accompanied by my wife, Ann Keen MP, and our son and we paid our own travel and accommodation costs. Sponsorship was received from Diageo, Microsoft, Colliers, Vauxhall, Visa and the Australian Parliament Sports Club which was given to the following charities: the Trew Foundation (New Zealand), the Lord's Taverners (Australia) and Chance to Shine (UK), with the exception of a small proportion retained for incidental expenses. (Registered 3 April 2007) | Overseas visits 80ef1083 | 2008-03-11 | Alan Keen uk.org.publicwhip/member/1584 | Alan Keen uk.org.publicwhip/person/10329 | 0 | 2008-03-11-80ef1083-10329-0 |
49a08dab53a37925fa8fd8c27a1541137c3d9bd7 | 15-17 May 2008, to Guernsey at the invitation of the States of Guernsey, to play a football match with accommodation and hospitality provided by the States of Guernsey and a contribution to the air fare provided by our club sponsors National Grid. (Registered 12 June 2008) | Overseas visits 80ef1083 | 2009-05-20 | Alan Keen uk.org.publicwhip/member/1584 | Alan Keen uk.org.publicwhip/person/10329 | 0 | 2009-05-20-80ef1083-10329-0 |
4bc57642e13992077d87a2242748064b50875012 | Donor status: trade union | Sponsorships 8f616a6e | 2011-02-07 | Alan Keen uk.org.publicwhip/member/40258 | Alan Keen uk.org.publicwhip/person/10329 | 4 | 2011-02-07-8f616a6e-10329-0 |
4d4e3bcdede67b54f06a7c200ebc7cab35a63bb4 | 16 December 2006-7 January 2007, to Australia and New Zealand with the Lords and Commons Cricket Team for inter-parliamentary matches. I was accompanied by my wife, Ann Keen MP, and our son and we paid our own travel and accommodation costs. Sponsorship was received from Diageo, Microsoft, Colliers, Vauxhall, Visa and the Australian Parliament Sports Club which was given to the following charities: the Trew Foundation (New Zealand), the Lord's Taverners (Australia) and Chance to Shine (UK), with the exception of a small proportion retained for incidental expenses. (Registered 3 April 2007) | Overseas visits 80ef1083 | 2007-06-05 | Alan Keen uk.org.publicwhip/member/1584 | Alan Keen uk.org.publicwhip/person/10329 | 1 | 2007-06-05-80ef1083-10329-0 |
4f6c4cb763246adbe1d5431176756313f52c868f | 15-17 May 2008, to Guernsey at the invitation of the States of Guernsey, to play a football match with accommodation and hospitality provided by the States of Guernsey and a contribution to the air fare provided by our club sponsors National Grid. (Registered 12 June 2008) | Overseas visits 80ef1083 | 2008-06-16 | Alan Keen uk.org.publicwhip/member/1584 | Alan Keen uk.org.publicwhip/person/10329 | 1 | 2008-06-16-80ef1083-10329-0 |
50e7524f7b4229d5058e5aa52a3030dfb67d9cee | 8-11 June 2006, to Germany as a member of the UK Parliamentary Football Club, to attend the World Cup and play football matches for charity. I received match ticket, hospitality and coach transport from McDonald's, and hospitality and coach transport from National Grid. (Registered 20 October 2006) | Overseas visits 80ef1083 | 2007-03-13 | Alan Keen uk.org.publicwhip/member/1584 | Alan Keen uk.org.publicwhip/person/10329 | 0 | 2007-03-13-80ef1083-10329-0 |
510098cd8b51b9c95e742771d220abba86afdb53 | (Registered 22 June 2010) | Sponsorships 8f616a6e | 2011-06-20 | Alan Keen uk.org.publicwhip/member/40258 | Alan Keen uk.org.publicwhip/person/10329 | 5 | 2011-06-20-8f616a6e-10329-0 |
5409e56b10cf713929b94ff8f4ac02a465680eb0 | Address of donor: 60-62 Clapham Road, London SW9 0JJ. | Sponsorships 8f616a6e | 2011-03-28 | Alan Keen uk.org.publicwhip/member/40258 | Alan Keen uk.org.publicwhip/person/10329 | 2 | 2011-03-28-8f616a6e-10329-0 |
57bab2fc70edd631f106eac929118ba1f598b9ff | 16 December 2006-7 January 2007, to Australia and New Zealand with the Lords and Commons Cricket Team for inter-parliamentary matches. I was accompanied by my wife, Ann Keen MP, and our son and we paid our own travel and accommodation costs. Sponsorship was received from Diageo, Microsoft, Colliers, Vauxhall, Visa and the Australian Parliament Sports Club which was given to the following charities: the Trew Foundation (New Zealand), the Lord's Taverners (Australia) and Chance to Shine (UK), with the exception of a small proportion retained for incidental expenses. (Registered 3 April 2007) | Overseas visits 80ef1083 | 2008-01-22 | Alan Keen uk.org.publicwhip/member/1584 | Alan Keen uk.org.publicwhip/person/10329 | 0 | 2008-01-22-80ef1083-10329-0 |
586206a4a516c7dd0b961c80f5d156a8acf7cfac | 8-11 June 2006, to Germany as a member of the UK Parliamentary Football Club, to attend the World Cup and play football matches for charity. I received match ticket, hospitality and coach transport from McDonald's, and hospitality and coach transport from National Grid. (Registered 20 October 2006) | Overseas visits 80ef1083 | 2007-01-09 | Alan Keen uk.org.publicwhip/member/1584 | Alan Keen uk.org.publicwhip/person/10329 | 0 | 2007-01-09-80ef1083-10329-0 |
5a19a2eeb928eb82f929918eecc5d771da2b20c1 | Address of donor: 60-62 Clapham Road, London SW9 0JJ. | Sponsorships 8f616a6e | 2011-01-24 | Alan Keen uk.org.publicwhip/member/40258 | Alan Keen uk.org.publicwhip/person/10329 | 2 | 2011-01-24-8f616a6e-10329-0 |
5ad16da017979a0c4f5b3e40baba95a8e6c2f0aa | 18 March 2011, received payment of £75 from Populus, 10 Northburgh Street, London EC1V 0AT, for opinion survey in February 2011. Hours: 15 mins. Payment donated to my constituency party. (Registered 18 April 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-10-17 | Alan Keen uk.org.publicwhip/member/40258 | Alan Keen uk.org.publicwhip/person/10329 | 0 | 2011-10-17-1f359ece-10329-0 |
5bcdac39b1e4dd34054966d387b3c95634bb80f7 | Donor status: trade union | Sponsorships 8f616a6e | 2010-11-22 | Alan Keen uk.org.publicwhip/member/40258 | Alan Keen uk.org.publicwhip/person/10329 | 4 | 2010-11-22-8f616a6e-10329-0 |
5d0ced50e3fbcb5537ddfde791a56156743becce | 18 March 2011, received payment of £75 from Populus, 10 Northburgh Street, London EC1V 0AT, for opinion survey in February 2011. Hours: 15 mins. Payment donated to my constituency party. (Registered 18 April 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-08-30 | Alan Keen uk.org.publicwhip/member/40258 | Alan Keen uk.org.publicwhip/person/10329 | 0 | 2011-08-30-1f359ece-10329-0 |
60b86cc44c092e7c90a539ce02a5ef2b83119829 | 15-17 May 2008, to Guernsey at the invitation of the States of Guernsey, to play a football match with accommodation and hospitality provided by the States of Guernsey and a contribution to the air fare provided by our club sponsors National Grid. (Registered 12 June 2008) | Overseas visits 80ef1083 | 2009-01-14 | Alan Keen uk.org.publicwhip/member/1584 | Alan Keen uk.org.publicwhip/person/10329 | 0 | 2009-01-14-80ef1083-10329-0 |
61f9f022546e033c5cfaaefaef599f71e75b61cd | 16 December 2006-7 January 2007, to Australia and New Zealand with the Lords and Commons Cricket Team for inter-parliamentary matches. I was accompanied by my wife, Ann Keen MP, and our son and we paid our own travel and accommodation costs. Sponsorship was received from Diageo, Microsoft, Colliers, Vauxhall, Visa and the Australian Parliament Sports Club which was given to the following charities: the Trew Foundation (New Zealand), the Lord's Taverners (Australia) and Chance to Shine (UK), with the exception of a small proportion retained for incidental expenses. (Registered 3 April 2007) | Overseas visits 80ef1083 | 2007-07-30 | Alan Keen uk.org.publicwhip/member/1584 | Alan Keen uk.org.publicwhip/person/10329 | 1 | 2007-07-30-80ef1083-10329-0 |
6205047d0861878102af46dfa25e8cbd9a0f5679 | (Registered 22 June 2010) | Sponsorships 8f616a6e | 2011-01-10 | Alan Keen uk.org.publicwhip/member/40258 | Alan Keen uk.org.publicwhip/person/10329 | 5 | 2011-01-10-8f616a6e-10329-0 |
62b8f3f91e1a59f7e098e32748e54e6e27fbc84e | 8-11 June 2006, to Germany as a member of the UK Parliamentary Football Club, to attend the World Cup and play football matches for charity. I received match ticket, hospitality and coach transport from McDonald's, and hospitality and coach transport from National Grid. (Registered 20 October 2006) | Overseas visits 80ef1083 | 2007-06-05 | Alan Keen uk.org.publicwhip/member/1584 | Alan Keen uk.org.publicwhip/person/10329 | 0 | 2007-06-05-80ef1083-10329-0 |
6596acfb286799d2148b9b0592819467dc854704 | 10 September 1999, to Portugal with the Parliamentary Football Team, travel costs met by National Express Ltd., cost of football kit met by Spall Sports. (Registered 12 January 2000) | Gifts, benefits and hospitality (UK) 84642823 | 2000-11-10 | Alan Keen uk.org.publicwhip/member/329 | Alan Keen uk.org.publicwhip/person/10329 | 1 | 2000-11-10-84642823-10329-0 |
663f1b45c7d81eb40f9b24cdfec8cc6556a24c2a | 16 December 2006-7 January 2007, to Australia and New Zealand with the Lords and Commons Cricket Team for inter-parliamentary matches. I was accompanied by my wife, Ann Keen MP, and our son and we paid our own travel and accommodation costs. Sponsorship was received from Diageo, Microsoft, Colliers, Vauxhall, Visa and the Australian Parliament Sports Club which was given to the following charities: the Trew Foundation (New Zealand), the Lord's Taverners (Australia) and Chance to Shine (UK), with the exception of a small proportion retained for incidental expenses. (Registered 3 April 2007) | Overseas visits 80ef1083 | 2008-02-26 | Alan Keen uk.org.publicwhip/member/1584 | Alan Keen uk.org.publicwhip/person/10329 | 0 | 2008-02-26-80ef1083-10329-0 |
675c98e8b1e7dec3578e6603accfa5d6fb13ab19 | 18 March 2011, received payment of £75 from Populus, 10 Northburgh Street, London EC1V 0AT, for opinion survey in February 2011. Hours: 15 mins. Payment donated to my constituency party. (Registered 18 April 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-05-03 | Alan Keen uk.org.publicwhip/member/40258 | Alan Keen uk.org.publicwhip/person/10329 | 0 | 2011-05-03-1f359ece-10329-0 |
6773670cda2733afc4c26804cc4848186a2599b5 | Address of donor: 60-62 Clapham Road, London SW9 0JJ. | Sponsorships 8f616a6e | 2011-04-18 | Alan Keen uk.org.publicwhip/member/40258 | Alan Keen uk.org.publicwhip/person/10329 | 2 | 2011-04-18-8f616a6e-10329-0 |
695b3f6b19beab276afc27bc1f1e6ae72493de5b | Name of donor: Musicians’ Union | Sponsorships 8f616a6e | 2011-06-20 | Alan Keen uk.org.publicwhip/member/40258 | Alan Keen uk.org.publicwhip/person/10329 | 1 | 2011-06-20-8f616a6e-10329-0 |
6aecad64a4b5e224985a8c155ca00476f4d0ff0b | Donor status: trade union | Sponsorships 8f616a6e | 2011-05-03 | Alan Keen uk.org.publicwhip/member/40258 | Alan Keen uk.org.publicwhip/person/10329 | 4 | 2011-05-03-8f616a6e-10329-0 |
6b9a6da02227b8f1fed32f0c7d1e8ae52e4145b2 | Name of donor: Musicians’ Union | Sponsorships 8f616a6e | 2011-04-18 | Alan Keen uk.org.publicwhip/member/40258 | Alan Keen uk.org.publicwhip/person/10329 | 1 | 2011-04-18-8f616a6e-10329-0 |
6c6c70a3260d0a14d2d819ed8ef20d4040306068 | 15-17 May 2008, to Guernsey at the invitation of the States of Guernsey, to play a football match with accommodation and hospitality provided by the States of Guernsey and a contribution to the air fare provided by our club sponsors National Grid. (Registered 12 June 2008) | Overseas visits 80ef1083 | 2008-11-05 | Alan Keen uk.org.publicwhip/member/1584 | Alan Keen uk.org.publicwhip/person/10329 | 0 | 2008-11-05-80ef1083-10329-0 |
709a6b6fccbd46ac14fb211f5daca2569259b6a0 | 8-11 June 2006, to Germany as a member of the UK Parliamentary Football Club, to attend the World Cup and play football matches for charity. I received match ticket, hospitality and coach transport from McDonald's, and hospitality and coach transport from National Grid. (Registered 20 October 2006) | Overseas visits 80ef1083 | 2006-12-11 | Alan Keen uk.org.publicwhip/member/1584 | Alan Keen uk.org.publicwhip/person/10329 | 0 | 2006-12-11-80ef1083-10329-0 |
70b2011e9af1fe941657ea8db3c6589a874b64d7 | 8-11 June 2006, to Germany as a member of the UK Parliamentary Football Club, to attend the World Cup and play football matches for charity. I received match ticket, hospitality and coach transport from McDonald's, and hospitality and coach transport from National Grid. (Registered 20 October 2006) | Overseas visits 80ef1083 | 2007-10-09 | Alan Keen uk.org.publicwhip/member/1584 | Alan Keen uk.org.publicwhip/person/10329 | 0 | 2007-10-09-80ef1083-10329-0 |
71508f31c499de678719544f3242ad4e4e3871f7 | 18 March 2011, received payment of £75 from Populus, 10 Northburgh Street, London EC1V 0AT, for opinion survey in February 2011. Hours: 15 mins. Payment donated to my constituency party. (Registered 18 April 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-05-16 | Alan Keen uk.org.publicwhip/member/40258 | Alan Keen uk.org.publicwhip/person/10329 | 0 | 2011-05-16-1f359ece-10329-0 |
71c5a77c19a4287b0d4c83bc03a49b7a049ae478 | Name of donor: Musicians’ Union | Sponsorships 8f616a6e | 2011-01-10 | Alan Keen uk.org.publicwhip/member/40258 | Alan Keen uk.org.publicwhip/person/10329 | 1 | 2011-01-10-8f616a6e-10329-0 |
72c4fa00865a3aefbe22667a69b6d4ef9c2c4424 | (Registered 22 June 2010) | Sponsorships 8f616a6e | 2010-11-08 | Alan Keen uk.org.publicwhip/member/40258 | Alan Keen uk.org.publicwhip/person/10329 | 5 | 2010-11-08-8f616a6e-10329-0 |
738106e61545749672b0d4f5c568cc4a76ed7d05 | 8-11 June 2006, to Germany as a member of the UK Parliamentary Football Club, to attend the World Cup and play football matches for charity. I received match ticket, hospitality and coach transport from McDonald's, and hospitality and coach transport from National Grid. (Registered 20 October 2006) | Overseas visits 80ef1083 | 2007-07-30 | Alan Keen uk.org.publicwhip/member/1584 | Alan Keen uk.org.publicwhip/person/10329 | 0 | 2007-07-30-80ef1083-10329-0 |
7849247c742929d30bea41cc098666b98289f780 | 15-17 May 2008, to Guernsey at the invitation of the States of Guernsey, to play a football match with accommodation and hospitality provided by the States of Guernsey and a contribution to the air fare provided by our club sponsors National Grid. (Registered 12 June 2008) | Overseas visits 80ef1083 | 2008-10-08 | Alan Keen uk.org.publicwhip/member/1584 | Alan Keen uk.org.publicwhip/person/10329 | 0 | 2008-10-08-80ef1083-10329-0 |
790a40033f2ee18cc693947a12bf0a5e7134126a | (Registered 22 June 2010) | Sponsorships 8f616a6e | 2010-09-06 | Alan Keen uk.org.publicwhip/member/40258 | Alan Keen uk.org.publicwhip/person/10329 | 5 | 2010-09-06-8f616a6e-10329-0 |
79b353469084b091d20e9045b4760e54873b37d9 | Donations to the constituency party or association, which have been or will be reported by the party to the Electoral Commission: | Sponsorships 8f616a6e | 2010-12-20 | Alan Keen uk.org.publicwhip/member/40258 | Alan Keen uk.org.publicwhip/person/10329 | 0 | 2010-12-20-8f616a6e-10329-0 |
7b6a5f9e4f2069ee13491e2f96e9b0f6de83b103 | Name of donor: Musicians’ Union | Sponsorships 8f616a6e | 2010-12-20 | Alan Keen uk.org.publicwhip/member/40258 | Alan Keen uk.org.publicwhip/person/10329 | 1 | 2010-12-20-8f616a6e-10329-0 |
7e6193e8f2e0e5957709d19f11dd0e0f87b525e7 | Amount of donation or nature and value if donation in kind: £5,000 | Sponsorships 8f616a6e | 2010-11-22 | Alan Keen uk.org.publicwhip/member/40258 | Alan Keen uk.org.publicwhip/person/10329 | 3 | 2010-11-22-8f616a6e-10329-0 |
7e6c03cc935a9223aa1a680ca82c853fa2917331 | (Registered 22 June 2010) | Sponsorships 8f616a6e | 2010-11-22 | Alan Keen uk.org.publicwhip/member/40258 | Alan Keen uk.org.publicwhip/person/10329 | 5 | 2010-11-22-8f616a6e-10329-0 |
80261f934c8b885993355ef2cd6b648d4fd99d73 | (Registered 22 June 2010) | Sponsorships 8f616a6e | 2011-02-28 | Alan Keen uk.org.publicwhip/member/40258 | Alan Keen uk.org.publicwhip/person/10329 | 5 | 2011-02-28-8f616a6e-10329-0 |
8040266959adfe69c448853feaa8dbc6c5f0409d | 18 March 2011, received payment of £75 from Populus, 10 Northburgh Street, London EC1V 0AT, for opinion survey in February 2011. Hours: 15 mins. Payment donated to my constituency party. (Registered 18 April 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-07-19 | Alan Keen uk.org.publicwhip/member/40258 | Alan Keen uk.org.publicwhip/person/10329 | 0 | 2011-07-19-1f359ece-10329-0 |
82d3367fd33427d23b5b9ba11437e58475af42fc | Donations to the constituency party or association, which have been or will be reported by the party to the Electoral Commission: | Sponsorships 8f616a6e | 2011-01-24 | Alan Keen uk.org.publicwhip/member/40258 | Alan Keen uk.org.publicwhip/person/10329 | 0 | 2011-01-24-8f616a6e-10329-0 |
842c759faea5f8c69a64f764be1715881dfa2e35 | Donor status: trade union | Sponsorships 8f616a6e | 2010-09-06 | Alan Keen uk.org.publicwhip/member/40258 | Alan Keen uk.org.publicwhip/person/10329 | 4 | 2010-09-06-8f616a6e-10329-0 |
8584d732c555c557c6fa558819b77ed4557ede5a | 8-11 September 2001, to Gibraltar, to meet First Minister and others. Travel and hotel paid for by Government of Gibraltar. (Registered 20 July 2002) | Overseas visits 80ef1083 | 2002-11-26 | Alan Keen uk.org.publicwhip/member/1011 | Alan Keen uk.org.publicwhip/person/10329 | 0 | 2002-11-26-80ef1083-10329-0 |
86014551d9a4f254134a956713082a7a34077afc | Donations to the constituency party or association, which have been or will be reported by the party to the Electoral Commission: | Sponsorships 8f616a6e | 2011-01-10 | Alan Keen uk.org.publicwhip/member/40258 | Alan Keen uk.org.publicwhip/person/10329 | 0 | 2011-01-10-8f616a6e-10329-0 |
86839b1942745e08e7075dc9ea45a5bee64a3ff9 | Donations to the constituency party or association, which have been or will be reported by the party to the Electoral Commission: | Sponsorships 8f616a6e | 2011-05-03 | Alan Keen uk.org.publicwhip/member/40258 | Alan Keen uk.org.publicwhip/person/10329 | 0 | 2011-05-03-8f616a6e-10329-0 |
87fb746d3a78a2d4c5251b0061b466a64af26f0e | 16 December 2006-7 January 2007, to Australia and New Zealand with the Lords and Commons Cricket Team for inter-parliamentary matches. I was accompanied by my wife, Ann Keen MP, and our son and we paid our own travel and accommodation costs. Sponsorship was received from Diageo, Microsoft, Colliers, Vauxhall, Visa and the Australian Parliament Sports Club which was given to the following charities: the Trew Foundation (New Zealand), the Lord's Taverners (Australia) and Chance to Shine (UK), with the exception of a small proportion retained for incidental expenses. (Registered 3 April 2007) | Overseas visits 80ef1083 | 2007-05-01 | Alan Keen uk.org.publicwhip/member/1584 | Alan Keen uk.org.publicwhip/person/10329 | 1 | 2007-05-01-80ef1083-10329-0 |
881a62ad48b00bdafd85c45718d058fccf331452 | Amount of donation or nature and value if donation in kind: £5,000 | Sponsorships 8f616a6e | 2011-03-14 | Alan Keen uk.org.publicwhip/member/40258 | Alan Keen uk.org.publicwhip/person/10329 | 3 | 2011-03-14-8f616a6e-10329-0 |
88de844bf95922425315508523d6f5130f681d88 | 18 March 2011, received payment of £75 from Populus, 10 Northburgh Street, London EC1V 0AT, for opinion survey in February 2011. Hours: 15 mins. Payment donated to my constituency party. (Registered 18 April 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-06-06 | Alan Keen uk.org.publicwhip/member/40258 | Alan Keen uk.org.publicwhip/person/10329 | 0 | 2011-06-06-1f359ece-10329-0 |
89cd884508c43f11da7aa64370a904866ed53f8d | September 1999, during the visit of the Hungarian Parliamentary Football Team to the UK, I received hospitality sponsored by Powergen Ltd., Provident Finance and West Ham FC. (Registered 12 January 2000) | Gifts, benefits and hospitality (UK) 84642823 | 2000-11-10 | Alan Keen uk.org.publicwhip/member/329 | Alan Keen uk.org.publicwhip/person/10329 | 0 | 2000-11-10-84642823-10329-0 |
89d913cc94ae86e704dc3c2b4477d1cd8e0abfb2 | 8-11 June 2006, to Germany as a member of the UK Parliamentary Football Club, to attend the World Cup and play football matches for charity. I received match ticket, hospitality and coach transport from McDonald's, and hospitality and coach transport from National Grid. (Registered 20 October 2006) | Overseas visits 80ef1083 | 2007-07-17 | Alan Keen uk.org.publicwhip/member/1584 | Alan Keen uk.org.publicwhip/person/10329 | 0 | 2007-07-17-80ef1083-10329-0 |
8dff3f1f107f18c6ca3c9c19274f5b12806ee89e | 15-17 May 2008, to Guernsey at the invitation of the States of Guernsey, to play a football match with accommodation and hospitality provided by the States of Guernsey and a contribution to the air fare provided by our club sponsors National Grid. (Registered 12 June 2008) | Overseas visits 80ef1083 | 2009-01-28 | Alan Keen uk.org.publicwhip/member/1584 | Alan Keen uk.org.publicwhip/person/10329 | 0 | 2009-01-28-80ef1083-10329-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");