items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
61 rows where "date" is on date 2013-06-24 and person_id = "uk.org.publicwhip/person/10632" sorted by date descending
This data as json, CSV (advanced)
Suggested facets: sort_order, record_id
hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
6b5c0079fccff3e6f9921aa68ede1301636b0180 | Audio Network plc (non-executive); an online music catalogue. Address: School Farm Studios, Little Maplestead, Halstead, Essex CO9 2SN. As a non-executive director I review monthly board papers and attend quarterly board meetings as well as occasional ad hoc meetings with the managers of the company. This consists of an estimated 8 hours work over the quarter. | Directorships 1aeb07b2 | 2013-06-24 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 0 | 2013-06-24-1aeb07b2-10632-0 |
f25bbceb122cdc749ee89fc00dce2621459f729f | 28 March 2012, quarterly payment of £2,000 gross to me in my capacity as non-executive director. Hours: 8 hrs. (Registered 14 July 2012) | Directorships 1aeb07b2 | 2013-06-24 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 1 | 2013-06-24-1aeb07b2-10632-0 |
047c95cd6c47f4a8968fe1285bfdd82deb53e841 | 26 June 2012, quarterly payment of £2,000 gross to me in my capacity as non-executive director. Hours: 8 hrs. (Registered 7 July 2012) | Directorships 1aeb07b2 | 2013-06-24 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 2 | 2013-06-24-1aeb07b2-10632-0 |
4f9116e7b252c7f2b3621ea02a18ee79f975acce | 27 September 2012, quarterly payment of £2,000 gross to me in my capacity as non-executive director. Hours: 8 hrs. (Registered 8 October 2012) | Directorships 1aeb07b2 | 2013-06-24 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 3 | 2013-06-24-1aeb07b2-10632-0 |
71d4146700a99a01025206b3fcca390b798007bf | 21 December 2012, quarterly payment of £2,000 gross to me in my capacity as non-executive director. Hours: 8 hrs. (Registered 27 December 2012) | Directorships 1aeb07b2 | 2013-06-24 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 4 | 2013-06-24-1aeb07b2-10632-0 |
4f7357042d8071edd88bb5e164a6be8d06d59c88 | 28 March 2013, quarterly payment of £2,000 gross to me in my capacity as non-executive director. Hours: 8 hrs (estimated). (Registered 11 May 2013) | Directorships 1aeb07b2 | 2013-06-24 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 5 | 2013-06-24-1aeb07b2-10632-0 |
73e1ebbcaa4e27151e41f0ed528c83f890c3e290 | Payments from ComRes, Four Millbank, London SW1P 3JA, for participation in surveys: | Remunerated employment, office, profession etc 1f359ece | 2013-06-24 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 0 | 2013-06-24-1f359ece-10632-0 |
aab2748eb6e5eb6dbf870dd63137b776eb75bde3 | 15 June 2012, payment of £75 for participation in April-May 2012 Parliamentary Panel survey. Hours: 45 mins. (Registered 7 July 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-06-24 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 1 | 2013-06-24-1f359ece-10632-0 |
84a5ee9ec76d4a1ca2c2673cdc50ecaddff82e54 | 5 July 2012, payment of £75 for participation in May-June 2012 Parliamentary Panel survey. Hours: approx 45 mins. (Registered 15 August 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-06-24 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 2 | 2013-06-24-1f359ece-10632-0 |
fb8494ec48c98857a4b6bff7ffbc0df27d830b6a | 23 August 2012, payment of £75 for participation in July 2012 Parliamentary Panel survey. Hours: approx 45 mins. (Registered 8 October 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-06-24 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 3 | 2013-06-24-1f359ece-10632-0 |
1100344943dec17203a0ef92a0ff8ca013b0b64a | 27 November 2012, payment of £75 for participation in October-November 2012 Parliamentary Panel survey. Hours: approx 45 mins. (Registered 27 December 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-06-24 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 4 | 2013-06-24-1f359ece-10632-0 |
b727a88a5c769773ccc147f8fffb150e2ec6cc8f | 26 February 2013, payment of £75 for participation in January Parliamentary Panel survey. Hours: approx 45 mins. (Registered 14 March 2013) | Remunerated employment, office, profession etc 1f359ece | 2013-06-24 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 5 | 2013-06-24-1f359ece-10632-0 |
8f1968eb99dcb127acfed743b43c40188ac98827 | 22 March 2013, payment of £75 for participation in February-March Parliamentary Panel survey. Hours: approx 45 mins. (Registered 11 May 2013) | Remunerated employment, office, profession etc 1f359ece | 2013-06-24 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 6 | 2013-06-24-1f359ece-10632-0 |
92046877b610ae281298a65dcdd9d79be6cd065e | 16 May 2013, payment of £75 for participation in April 2013 Parliamentary Panel survey. Hours: approx 45 mins. (Registered 2 June 2013) | Remunerated employment, office, profession etc 1f359ece | 2013-06-24 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 7 | 2013-06-24-1f359ece-10632-0 |
4c4b84f7efd484da908513ac6f2f0aa2a8a38182 | Payments from Ipsos MORI, 79-81 Borough Road, London SE1 1FY for participating in opinion research interviews: | Remunerated employment, office, profession etc 1f359ece | 2013-06-24 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 8 | 2013-06-24-1f359ece-10632-0 |
e19510ef03e868c4b9a10b697b9aff5f21a166e2 | 5 October 2012, payment of £150 received. Hours: 2 hrs. (Registered 8 October 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-06-24 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 9 | 2013-06-24-1f359ece-10632-0 |
0dbba101d7bb5114c2e01c8ec8400b255a8bb8d8 | 22 June 2012, payment of £150 from BBC, PO Box 480, Manchester M14 0EL, for participation in Radio 4 ‘Any Questions’ on 18 June 2012. Hours: 90 mins. (Registered 7 July 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-06-24 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 10 | 2013-06-24-1f359ece-10632-0 |
2949d656df10265fbbeedb47cb6f1564f6163f0f | 25 July 2012, Payment of £70 from YouGov, 50 Featherstone Street, London EC1Y 8RT for participating in an opinion survey. Hours: 30 mins. (Registered 15 August 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-06-24 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 11 | 2013-06-24-1f359ece-10632-0 |
01c7ac378f1440a7c1cceb7c1f9fdc7c45e6a792 | 18 September 2012, payment of £100 from Leftfield, 51 Clink Street Studios, Clink Street, London SE1 9DG, for participation in an opinion survey. Hours: approx 40 mins. (Registered 8 October 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-06-24 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 12 | 2013-06-24-1f359ece-10632-0 |
27f7098a658b33825eed840142c388a6c65b13e2 | Payment of £150 from Dods Training, 21 Dartmouth St, London SW1H 9BP, for participation in Westminster Explained training event at the British Academy on 12 March 2013. Hours: 90 mins. (Registered 11 May 2013) | Remunerated employment, office, profession etc 1f359ece | 2013-06-24 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 13 | 2013-06-24-1f359ece-10632-0 |
a5cf3faaf161f96a3d4b3fc9421703f0aca6e822 | Name of donor: London Organising Committee of the Olympic Games and Paralympic Games Address of donor: 1 Churchill Place, Canary Wharf, London E14 | Gifts, benefits and hospitality (UK) 84642823 | 2013-06-24 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 0 | 2013-06-24-84642823-10632-0 |
f540c152f4aabaf782b83d168d7ea567b0f75e62 | Amount of donation or nature and value if donation in kind: two tickets for myself and guest to attend the Opening Ceremony of the London Olympic Games; value: £4,024 | Gifts, benefits and hospitality (UK) 84642823 | 2013-06-24 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 1 | 2013-06-24-84642823-10632-0 |
487ac08044212563489ef50d7415c3798f7e7cf7 | Date of receipt of donation: 27 July 2012 | Gifts, benefits and hospitality (UK) 84642823 | 2013-06-24 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 2 | 2013-06-24-84642823-10632-0 |
cf6baa8a6b7de25249a916e1ad1b9908c14ff94b | Date of acceptance of donation: 27 July 2012 | Gifts, benefits and hospitality (UK) 84642823 | 2013-06-24 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 3 | 2013-06-24-84642823-10632-0 |
dfa96815db1de87c24625b6e5eb3c67e2fcd7eef | Donor status: company, registration number 05267819 | Gifts, benefits and hospitality (UK) 84642823 | 2013-06-24 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 4 | 2013-06-24-84642823-10632-0 |
57ad6bc0ada1da0692425b11d26964727c8f8551 | Name of Donor: Camelot UK Lotteries Ltd | Gifts, benefits and hospitality (UK) 84642823 | 2013-06-24 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 6 | 2013-06-24-84642823-10632-0 |
2ba94f3e406f56b3d975a640c5eadfca2b7ff199 | Address of Donor: Brettenham House, Lancaster Place, London WC2E 7EN | Gifts, benefits and hospitality (UK) 84642823 | 2013-06-24 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 7 | 2013-06-24-84642823-10632-0 |
c60844d2c16c25ae51338931087458f4d8ad0ad4 | Amount of donation: two tickets for myself and guest to attend the Olympic Rowing at Eton Dorney and a night’s stay at Runnymede on Thames Hotel; value: £1,700 | Gifts, benefits and hospitality (UK) 84642823 | 2013-06-24 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 8 | 2013-06-24-84642823-10632-0 |
e7f3f9e68210efc61ea0deb56c354c76b7324946 | Date of receipt of donation: 2 August 2012 | Gifts, benefits and hospitality (UK) 84642823 | 2013-06-24 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 9 | 2013-06-24-84642823-10632-0 |
49b086f06d3c94e2129f7facd356fcee5c7c73ec | Date of acceptance of donation: 2 August 2012 | Gifts, benefits and hospitality (UK) 84642823 | 2013-06-24 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 10 | 2013-06-24-84642823-10632-0 |
3736ae130d5163d630198459e260c34216afb860 | Donor status: company, registration number 2822203 | Gifts, benefits and hospitality (UK) 84642823 | 2013-06-24 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 11 | 2013-06-24-84642823-10632-0 |
97a187116d222ef08454778f48a23dfa2942c92d | (Registered 15 August 2012) | Gifts, benefits and hospitality (UK) 84642823 | 2013-06-24 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 12 | 2013-06-24-84642823-10632-0 |
1cda7e522c56c714083a058233aa8ed7a843c821 | Name of donor: British Ukrainian Society | Overseas visits 80ef1083 | 2013-06-24 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 0 | 2013-06-24-80ef1083-10632-0 |
715e267a34c7dd80f5a8297c60424b0e88471757 | Address of donor: 1st Floor, 25 Knightsbridge, London SW1X 7RZ | Overseas visits 80ef1083 | 2013-06-24 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 1 | 2013-06-24-80ef1083-10632-0 |
baebdf246e3be910217ca9587c55d7972b6874ff | Amount of donation (or estimate of the probable value): Flights £1,700; accommodation £820 | Overseas visits 80ef1083 | 2013-06-24 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 2 | 2013-06-24-80ef1083-10632-0 |
73ea360ac150612d2941a3cde67be90e11dc41d0 | Destination of visit: Yalta, Ukraine | Overseas visits 80ef1083 | 2013-06-24 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 3 | 2013-06-24-80ef1083-10632-0 |
97ce0e24bb51a4ef8fe21cdeff3af51b48a3ae8f | Date of visit: 13-16 September 2012 | Overseas visits 80ef1083 | 2013-06-24 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 4 | 2013-06-24-80ef1083-10632-0 |
bc083b8f8471cbc72be50f13c064ef23ed9a5f0c | Purpose of visit: to attend the Yalta European Strategy Conference in my capacity as Chairman of the British Ukraine All-Party Parliamentary Group | Overseas visits 80ef1083 | 2013-06-24 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 5 | 2013-06-24-80ef1083-10632-0 |
6d07aa854254a86f82fadc1d4e9cce95f910f67c | (Registered 30 September 2012) | Overseas visits 80ef1083 | 2013-06-24 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 6 | 2013-06-24-80ef1083-10632-0 |
bf3e37456be73d6c23fb13b6feb58417e7b40380 | Name of donor: Government of Republic of China (Taiwan) | Overseas visits 80ef1083 | 2013-06-24 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 7 | 2013-06-24-80ef1083-10632-0 |
ab0959161f95ad31871529870eabc787f5ede193 | Address of donor: Taipei Representative Office in the UK, 50 Grosvenor Gardens, London SW1 | Overseas visits 80ef1083 | 2013-06-24 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 8 | 2013-06-24-80ef1083-10632-0 |
7b7602746982a58bb8d4cae6648cd47b45205841 | Amount of donation (or estimate of the probable value): flights, £2,295; food and accommodation £1,020; total £3,315 | Overseas visits 80ef1083 | 2013-06-24 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 9 | 2013-06-24-80ef1083-10632-0 |
e91b51895fc1d89d1e6fbecfed4e4668c995d011 | Destination of visit: Taiwan | Overseas visits 80ef1083 | 2013-06-24 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 10 | 2013-06-24-80ef1083-10632-0 |
eb4952ed2e68085890b59aae033ae1bf26f1e58a | Date of visit: 23-29 September 2012 | Overseas visits 80ef1083 | 2013-06-24 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 11 | 2013-06-24-80ef1083-10632-0 |
5cb522c25dc8cc2c4c34790014402a8e7aa5f4d6 | Purpose of visit: to meet the President and senior Members of the Government and Opposition to discuss issues affecting Taiwan and the UK | Overseas visits 80ef1083 | 2013-06-24 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 12 | 2013-06-24-80ef1083-10632-0 |
ff81b5b9d06401d24d76f276561f4432b43390b6 | (Registered 24 October 2012) | Overseas visits 80ef1083 | 2013-06-24 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 13 | 2013-06-24-80ef1083-10632-0 |
b265eb191ba442d8dd84720dce67d38e2693cd07 | Name of donor: European Friends of Armenia | Overseas visits 80ef1083 | 2013-06-24 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 14 | 2013-06-24-80ef1083-10632-0 |
8ce4805d5dabbfabf6f70abc81f0d4763801242d | Address of donor: Rue de Treves 49, 1040 Brussels-Etterbeck | Overseas visits 80ef1083 | 2013-06-24 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 15 | 2013-06-24-80ef1083-10632-0 |
af19dc39da19bc7e3287708ce062d784e7918804 | Amount of donation (or estimate of the probable value): Flights: £425; Accommodation: £380; | Overseas visits 80ef1083 | 2013-06-24 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 16 | 2013-06-24-80ef1083-10632-0 |
0669b83006ed819f7ce801a68df8b02465a2908b | Destination of visit: Yerevan, Armenia | Overseas visits 80ef1083 | 2013-06-24 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 17 | 2013-06-24-80ef1083-10632-0 |
cf1d28992ba2d2f3ac524cb6200a1f65c9120f6c | Date of visit: 16-20 February 2013 | Overseas visits 80ef1083 | 2013-06-24 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 18 | 2013-06-24-80ef1083-10632-0 |
f8a056839a0ed0c2646370daf35e8d49c223fae9 | Purpose of visit: to attend meeting of Europe-Armenia Advisory Council and to observe Armenian Presidential elections | Overseas visits 80ef1083 | 2013-06-24 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 19 | 2013-06-24-80ef1083-10632-0 |
65896e927d8b6d058c531737fbb2d75bb393a0b4 | (Registered 14 March 2013) | Overseas visits 80ef1083 | 2013-06-24 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 20 | 2013-06-24-80ef1083-10632-0 |
278ad19b60c1a2642fcd514973ddfcbb2400edb5 | Name of donor: PACT (Producers Alliance for Cinema and Television) | Overseas visits 80ef1083 | 2013-06-24 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 21 | 2013-06-24-80ef1083-10632-0 |
4c5f94907fc2dd8d805d76beb673d73f88c27724 | Address of donor: 3rd Floor, Fitzrovia House, 153-157 Cleveland Street, London W1T 6QW | Overseas visits 80ef1083 | 2013-06-24 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 22 | 2013-06-24-80ef1083-10632-0 |
2053325ec971d04d0be84a0fb0224369ed56ab84 | Amount of donation (or estimate of the probable value): flights: £108; accommodation: £700 | Overseas visits 80ef1083 | 2013-06-24 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 23 | 2013-06-24-80ef1083-10632-0 |
30696119154a931a8fd2623dd2cab87de77bbc39 | Destination of visit: Cannes, France | Overseas visits 80ef1083 | 2013-06-24 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 24 | 2013-06-24-80ef1083-10632-0 |
f98c848d21b374f92bbac721fb95c7f004ae5596 | Date of visit: 7-9 April 2013 | Overseas visits 80ef1083 | 2013-06-24 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 25 | 2013-06-24-80ef1083-10632-0 |
c763293410103ca87a461dd65079b6f74fc2a10c | Purpose of visit: to attend the MIP TV international television market and to meet British TV production firms represented there. | Overseas visits 80ef1083 | 2013-06-24 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 26 | 2013-06-24-80ef1083-10632-0 |
84af44d0a293e45680a701acc5eb6e5ec71f64ca | (Registered 2 June 2013) | Overseas visits 80ef1083 | 2013-06-24 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 27 | 2013-06-24-80ef1083-10632-0 |
f4d8e973a2eab7f4d2e9d991099bedcfdf420950 | Flat in London, from which rental income is received .(Registered 8 October 2012) | Land and Property 4f1e6359 | 2013-06-24 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 0 | 2013-06-24-4f1e6359-10632-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");