items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
61 rows where "date" is on date 2013-06-10 and person_id = "uk.org.publicwhip/person/10632" sorted by date descending
This data as json, CSV (advanced)
Suggested facets: category_id, sort_order, record_id
hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
b2c02e044a7246f3739c516d09ad6ce50394e1fc | 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-10 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 0 | 2013-06-10-1aeb07b2-10632-0 |
ecbf7107a0b08d56388a82011e6c2599b1603a42 | 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-10 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 1 | 2013-06-10-1aeb07b2-10632-0 |
6baf1698a0100b9a51ff30edd33a86041bf13977 | 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-10 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 2 | 2013-06-10-1aeb07b2-10632-0 |
e9200402c65a09753e1994ed2e0e19585aa1f122 | 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-10 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 3 | 2013-06-10-1aeb07b2-10632-0 |
4687d3ae2eee0c872de42c6b5f65359644ca6b9d | 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-10 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 4 | 2013-06-10-1aeb07b2-10632-0 |
6a097c00f207a18ae7918b5eab37be62ec27b0ae | 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-10 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 5 | 2013-06-10-1aeb07b2-10632-0 |
37f52ea6f4475a7123863676aac96930d88de35e | Payments from ComRes, Four Millbank, London SW1P 3JA, for participation in surveys: | Remunerated employment, office, profession etc 1f359ece | 2013-06-10 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 0 | 2013-06-10-1f359ece-10632-0 |
e8432f3e29419223b19cb1ba44b5ec1199d78059 | 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-10 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 1 | 2013-06-10-1f359ece-10632-0 |
ee9452c500d55e127aee22976e74a2ac6cf6aab9 | 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-10 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 2 | 2013-06-10-1f359ece-10632-0 |
c128aecf5da5bc0f714b6fec1b69c5ad0ff342ee | 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-10 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 3 | 2013-06-10-1f359ece-10632-0 |
186aada8cda982ad5a209fccd53b16cf75b98ef8 | 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-10 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 4 | 2013-06-10-1f359ece-10632-0 |
0b0cdb66d049300cc945e18c08632ab17aedd0be | 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-10 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 5 | 2013-06-10-1f359ece-10632-0 |
309f6773dc8139195156fea7f72f77cde12fbdbc | 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-10 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 6 | 2013-06-10-1f359ece-10632-0 |
3755f147e8495e260fb4db57e5335f5713be0ce0 | 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-10 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 7 | 2013-06-10-1f359ece-10632-0 |
b6fa05cfc94f73b5009c24fcf1c0e74f14cb0336 | 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-10 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 8 | 2013-06-10-1f359ece-10632-0 |
cd9ff2feeaa84fad63bcd3dbc88d8d5fcf555bb3 | 5 October 2012, payment of £150 received. Hours: 2 hrs. (Registered 8 October 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-06-10 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 9 | 2013-06-10-1f359ece-10632-0 |
2beaa5a979e05efd1968d00157c36e11926052ea | 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-10 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 10 | 2013-06-10-1f359ece-10632-0 |
e98dcc713f018c80736d80599808b1f101f04723 | 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-10 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 11 | 2013-06-10-1f359ece-10632-0 |
6da27066231752b6c11cef2405a849e0a6b20b07 | 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-10 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 12 | 2013-06-10-1f359ece-10632-0 |
5656ee69c6472389f263f0064ece04dbf9399973 | 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-10 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 13 | 2013-06-10-1f359ece-10632-0 |
e115f28821e8adfff1dc311c3ffd016535f86e89 | 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-10 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 0 | 2013-06-10-84642823-10632-0 |
c925ff968e61acec0fb46e20aabea9b7c0f9dcc8 | 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-10 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 1 | 2013-06-10-84642823-10632-0 |
5f60b5847c1e42c8ca1eeabe07dea3716af17798 | Date of receipt of donation: 27 July 2012 | Gifts, benefits and hospitality (UK) 84642823 | 2013-06-10 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 2 | 2013-06-10-84642823-10632-0 |
978847555a614e0ce783d3053265cf8e2df38430 | Date of acceptance of donation: 27 July 2012 | Gifts, benefits and hospitality (UK) 84642823 | 2013-06-10 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 3 | 2013-06-10-84642823-10632-0 |
f11f247eb60a75fd8f55b705b54b908cccbf122b | Donor status: company, registration number 05267819 | Gifts, benefits and hospitality (UK) 84642823 | 2013-06-10 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 4 | 2013-06-10-84642823-10632-0 |
a59abe07ab43182df2971caa8696e22415e745f8 | Name of Donor: Camelot UK Lotteries Ltd | Gifts, benefits and hospitality (UK) 84642823 | 2013-06-10 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 6 | 2013-06-10-84642823-10632-0 |
a67a7690789bcc69119a2598569bf6f3af1183b4 | Address of Donor: Brettenham House, Lancaster Place, London WC2E 7EN | Gifts, benefits and hospitality (UK) 84642823 | 2013-06-10 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 7 | 2013-06-10-84642823-10632-0 |
f95e4d4689a672b26fea27fc6a6460e2d25534b2 | 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-10 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 8 | 2013-06-10-84642823-10632-0 |
a5f01ef9978f02c24c93c44d287f13e713765496 | Date of receipt of donation: 2 August 2012 | Gifts, benefits and hospitality (UK) 84642823 | 2013-06-10 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 9 | 2013-06-10-84642823-10632-0 |
7aac7e6b8d4899a0365eb9353a524d62cf7616de | Date of acceptance of donation: 2 August 2012 | Gifts, benefits and hospitality (UK) 84642823 | 2013-06-10 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 10 | 2013-06-10-84642823-10632-0 |
fbc0493b528e986fca934eae302e8981d93423a9 | Donor status: company, registration number 2822203 | Gifts, benefits and hospitality (UK) 84642823 | 2013-06-10 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 11 | 2013-06-10-84642823-10632-0 |
9f8277316002e63e9104948fdf66e80c3923c7cf | (Registered 15 August 2012) | Gifts, benefits and hospitality (UK) 84642823 | 2013-06-10 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 12 | 2013-06-10-84642823-10632-0 |
1586148c875656bf560e47c2507b29b7fde77bed | Name of donor: British Ukrainian Society | Overseas visits 80ef1083 | 2013-06-10 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 0 | 2013-06-10-80ef1083-10632-0 |
c59174aae9db29cf358c5946a7780d1b1ee4fa74 | Address of donor: 1st Floor, 25 Knightsbridge, London SW1X 7RZ | Overseas visits 80ef1083 | 2013-06-10 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 1 | 2013-06-10-80ef1083-10632-0 |
3f55010a8ac37f5e4c9a82f32cfd7a7c70a70a39 | Amount of donation (or estimate of the probable value): Flights £1,700; accommodation £820 | Overseas visits 80ef1083 | 2013-06-10 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 2 | 2013-06-10-80ef1083-10632-0 |
3df2812266495d784eab9cc03823a23cbc6b585c | Destination of visit: Yalta, Ukraine | Overseas visits 80ef1083 | 2013-06-10 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 3 | 2013-06-10-80ef1083-10632-0 |
8e5e5d0301ff63c924926a9a036c87d2a8080624 | Date of visit: 13-16 September 2012 | Overseas visits 80ef1083 | 2013-06-10 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 4 | 2013-06-10-80ef1083-10632-0 |
404852b726831d3914da240b7707087e558f5633 | 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-10 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 5 | 2013-06-10-80ef1083-10632-0 |
1341c9248e5a544de2c834a9d7f155823c65d7bd | (Registered 30 September 2012) | Overseas visits 80ef1083 | 2013-06-10 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 6 | 2013-06-10-80ef1083-10632-0 |
0c8220401628e91fc0af28ca22e0564cb09a2ef1 | Name of donor: Government of Republic of China (Taiwan) | Overseas visits 80ef1083 | 2013-06-10 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 7 | 2013-06-10-80ef1083-10632-0 |
a3a03bdc20de5079c86baab829a210235ea816af | Address of donor: Taipei Representative Office in the UK, 50 Grosvenor Gardens, London SW1 | Overseas visits 80ef1083 | 2013-06-10 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 8 | 2013-06-10-80ef1083-10632-0 |
23dabeac413b03ffcab086ea1089f0c223ca0c62 | 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-10 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 9 | 2013-06-10-80ef1083-10632-0 |
573c7aad98b4cfaf9e700c8fc050bc26cf67ade9 | Destination of visit: Taiwan | Overseas visits 80ef1083 | 2013-06-10 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 10 | 2013-06-10-80ef1083-10632-0 |
e37d84926a58cc888996b52ba58f028d06eb6d2f | Date of visit: 23-29 September 2012 | Overseas visits 80ef1083 | 2013-06-10 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 11 | 2013-06-10-80ef1083-10632-0 |
3a2a119d395ad89e14be0564265981cc4e71296f | 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-10 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 12 | 2013-06-10-80ef1083-10632-0 |
d1a24bd3dab3e6abf060aa4fbd0ad7008cd8cea9 | (Registered 24 October 2012) | Overseas visits 80ef1083 | 2013-06-10 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 13 | 2013-06-10-80ef1083-10632-0 |
c93bc332c2836e85f90d57a4a5b5ef998aafaa42 | Name of donor: European Friends of Armenia | Overseas visits 80ef1083 | 2013-06-10 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 14 | 2013-06-10-80ef1083-10632-0 |
6b016a51788cb8d1a4773598e9295ed8d6767061 | Address of donor: Rue de Treves 49, 1040 Brussels-Etterbeck | Overseas visits 80ef1083 | 2013-06-10 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 15 | 2013-06-10-80ef1083-10632-0 |
a99620e5fae4d5d7ec804e254d1e8a003f146b66 | Amount of donation (or estimate of the probable value): Flights: £425; Accommodation: £380; | Overseas visits 80ef1083 | 2013-06-10 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 16 | 2013-06-10-80ef1083-10632-0 |
176c18d37a58ce044e29354af3af6790f75aae0f | Destination of visit: Yerevan, Armenia | Overseas visits 80ef1083 | 2013-06-10 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 17 | 2013-06-10-80ef1083-10632-0 |
c813e4d29c86567f49fa5ec822d5f77068a98955 | Date of visit: 16-20 February 2013 | Overseas visits 80ef1083 | 2013-06-10 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 18 | 2013-06-10-80ef1083-10632-0 |
f7093936b2db36c4e12532718de74a4c553399eb | Purpose of visit: to attend meeting of Europe-Armenia Advisory Council and to observe Armenian Presidential elections | Overseas visits 80ef1083 | 2013-06-10 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 19 | 2013-06-10-80ef1083-10632-0 |
5a534ec8179f3b8aef534fb99fcf04c7b00c5fcb | (Registered 14 March 2013) | Overseas visits 80ef1083 | 2013-06-10 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 20 | 2013-06-10-80ef1083-10632-0 |
36691fdd247df442902e0c2a6febfaad1b6db694 | Name of donor: PACT (Producers Alliance for Cinema and Television) | Overseas visits 80ef1083 | 2013-06-10 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 21 | 2013-06-10-80ef1083-10632-0 |
78abe6fd688aa223056dfedf60b389ffcb5bc25b | Address of donor: 3rd Floor, Fitzrovia House, 153-157 Cleveland Street, London W1T 6QW | Overseas visits 80ef1083 | 2013-06-10 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 22 | 2013-06-10-80ef1083-10632-0 |
4dd2fde345aa572ec82e619a70aaf385fc2655e6 | Amount of donation (or estimate of the probable value): flights: £108; accommodation: £700 | Overseas visits 80ef1083 | 2013-06-10 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 23 | 2013-06-10-80ef1083-10632-0 |
e3933b8e9b3188eb6092a275f8c53a7d2bdde878 | Destination of visit: Cannes, France | Overseas visits 80ef1083 | 2013-06-10 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 24 | 2013-06-10-80ef1083-10632-0 |
dca24e662ca5e7cc83e1058d05bee61da48b60dd | Date of visit: 7-9 April 2013 | Overseas visits 80ef1083 | 2013-06-10 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 25 | 2013-06-10-80ef1083-10632-0 |
928b93691424fd6c00bec140284bc6e9fbcaeece | 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-10 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 26 | 2013-06-10-80ef1083-10632-0 |
a0b0c69ffe4ca550b80926f0695274e50d74f63a | (Registered 2 June 2013) | Overseas visits 80ef1083 | 2013-06-10 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 27 | 2013-06-10-80ef1083-10632-0 |
ff88b53dd7ac52d61b4ce12679205ae00b0f7203 | Flat in London, from which rental income is received .(Registered 8 October 2012) | Land and Property 4f1e6359 | 2013-06-10 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 0 | 2013-06-10-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");