items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
41 rows where record_id = "2010-03-24-9e46def6-10355-0" sorted by hash
This data as json, CSV (advanced)
date (date) 1 ✖
- 2010-03-24 41
hash ▼ | item | category_id | date | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
022de313d25630bb77871a43d3c0561080d50c57 | (Registered 6 January 2010) | Sponsorship or financial or material support 9e46def6 | 2010-03-24 | Oliver Letwin uk.org.publicwhip/member/1549 | Oliver Letwin uk.org.publicwhip/person/10355 | 33 | 2010-03-24-9e46def6-10355-0 |
076d69f0a186cfe73d034927cdd42ee61dbadf29 | Donor status: limited liability partnership | Sponsorship or financial or material support 9e46def6 | 2010-03-24 | Oliver Letwin uk.org.publicwhip/member/1549 | Oliver Letwin uk.org.publicwhip/person/10355 | 27 | 2010-03-24-9e46def6-10355-0 |
0d5522386ecf3bc22d1b2eee60c8c284270d938c | Address of donor: Lion house, Red Lion Street, London WC1R 4GB | Sponsorship or financial or material support 9e46def6 | 2010-03-24 | Oliver Letwin uk.org.publicwhip/member/1549 | Oliver Letwin uk.org.publicwhip/person/10355 | 35 | 2010-03-24-9e46def6-10355-0 |
1169369ce815641893dac45325eee88d0b8eb234 | Date of acceptance: 1 December 2009 | Sponsorship or financial or material support 9e46def6 | 2010-03-24 | Oliver Letwin uk.org.publicwhip/member/1549 | Oliver Letwin uk.org.publicwhip/person/10355 | 26 | 2010-03-24-9e46def6-10355-0 |
126a39436c4b6db422f4625be1a45351d3514efc | Donor status: company | Sponsorship or financial or material support 9e46def6 | 2010-03-24 | Oliver Letwin uk.org.publicwhip/member/1549 | Oliver Letwin uk.org.publicwhip/person/10355 | 6 | 2010-03-24-9e46def6-10355-0 |
1e7da1fa828d025d0b1696e065af3c5996339848 | Name of donor: Mr Britt Shaw | Sponsorship or financial or material support 9e46def6 | 2010-03-24 | Oliver Letwin uk.org.publicwhip/member/1549 | Oliver Letwin uk.org.publicwhip/person/10355 | 29 | 2010-03-24-9e46def6-10355-0 |
24d20507917664e88ed3e29a5a64cbbb0386c52c | Amount of donation or nature and value if donation in kind: members of staff are donated by Martyn Rose Limited from 4 January-9 April 2010 to work on a report as part of ongoing policy work attached to the Conservative Party's Policy Unit; value £45,150. I am Chairman of the Policy Review. | Sponsorship or financial or material support 9e46def6 | 2010-03-24 | Oliver Letwin uk.org.publicwhip/member/1549 | Oliver Letwin uk.org.publicwhip/person/10355 | 36 | 2010-03-24-9e46def6-10355-0 |
297c86228d2eb0d06c3b4ac55c0f2fc7de587adb | Date of receipt: 6 November 2009 | Sponsorship or financial or material support 9e46def6 | 2010-03-24 | Oliver Letwin uk.org.publicwhip/member/1549 | Oliver Letwin uk.org.publicwhip/person/10355 | 25 | 2010-03-24-9e46def6-10355-0 |
2b8c0c6495a71d5f7b584f4c9d34a9b7d3164a58 | (Registered 3 December 2009) | Sponsorship or financial or material support 9e46def6 | 2010-03-24 | Oliver Letwin uk.org.publicwhip/member/1549 | Oliver Letwin uk.org.publicwhip/person/10355 | 28 | 2010-03-24-9e46def6-10355-0 |
2c4b1678124a016c10076d1512ed4c7dd1bf8fd0 | Amount of donation or nature and value if donation in kind: secondment of member of staff to work in the Policy Unit of the Conservative Party from 17 August 2009 to end of May 2010. Value of secondment, £50,000 | Sponsorship or financial or material support 9e46def6 | 2010-03-24 | Oliver Letwin uk.org.publicwhip/member/1549 | Oliver Letwin uk.org.publicwhip/person/10355 | 10 | 2010-03-24-9e46def6-10355-0 |
303ece4acc1ce5be5578680abfeaf204ef7550ca | Amount of donation or nature and value if donation in kind: £2500 (donated to constituency association) | Sponsorship or financial or material support 9e46def6 | 2010-03-24 | Oliver Letwin uk.org.publicwhip/member/1549 | Oliver Letwin uk.org.publicwhip/person/10355 | 31 | 2010-03-24-9e46def6-10355-0 |
34e4fa20b966f0eb4beea6db70dc2db56e00b731 | Address of donor: 8 Salisbury Square, London EC4Y 8BB. | Sponsorship or financial or material support 9e46def6 | 2010-03-24 | Oliver Letwin uk.org.publicwhip/member/1549 | Oliver Letwin uk.org.publicwhip/person/10355 | 23 | 2010-03-24-9e46def6-10355-0 |
37c57c75238c0b20a78b9e1285fbeb7b8e8654c2 | Date of acceptance: 4 January 2010 | Sponsorship or financial or material support 9e46def6 | 2010-03-24 | Oliver Letwin uk.org.publicwhip/member/1549 | Oliver Letwin uk.org.publicwhip/person/10355 | 38 | 2010-03-24-9e46def6-10355-0 |
4a1741bdf3d7bbddade16862f8e57c66841611a6 | Donor status: Limited liability partnership | Sponsorship or financial or material support 9e46def6 | 2010-03-24 | Oliver Letwin uk.org.publicwhip/member/1549 | Oliver Letwin uk.org.publicwhip/person/10355 | 20 | 2010-03-24-9e46def6-10355-0 |
54386293fa9c4229adc4773c8d4b1cbf5ec6c2c1 | Address of donor: The Estate Office, Melbury Sampford, Dorchester, Dorset, DT2 OLF | Sponsorship or financial or material support 9e46def6 | 2010-03-24 | Oliver Letwin uk.org.publicwhip/member/1549 | Oliver Letwin uk.org.publicwhip/person/10355 | 2 | 2010-03-24-9e46def6-10355-0 |
64ef84386bd7ec247d8bf689a65f94d64030590d | Address of donor: private | Sponsorship or financial or material support 9e46def6 | 2010-03-24 | Oliver Letwin uk.org.publicwhip/member/1549 | Oliver Letwin uk.org.publicwhip/person/10355 | 30 | 2010-03-24-9e46def6-10355-0 |
6cd856e2ee539d1903fd0f60d8c41e4df5a31e6f | Date of receipt: 28 September 2009 | Sponsorship or financial or material support 9e46def6 | 2010-03-24 | Oliver Letwin uk.org.publicwhip/member/1549 | Oliver Letwin uk.org.publicwhip/person/10355 | 18 | 2010-03-24-9e46def6-10355-0 |
6d43ac31c5ab1468e787a12369a1222ae2cdc7af | Name of donor: PricewaterhouseCoopers | Sponsorship or financial or material support 9e46def6 | 2010-03-24 | Oliver Letwin uk.org.publicwhip/member/1549 | Oliver Letwin uk.org.publicwhip/person/10355 | 15 | 2010-03-24-9e46def6-10355-0 |
739df23d4578c924ac839ac475fffaba0bcf32a1 | (Registered 26 October 2009) | Sponsorship or financial or material support 9e46def6 | 2010-03-24 | Oliver Letwin uk.org.publicwhip/member/1549 | Oliver Letwin uk.org.publicwhip/person/10355 | 21 | 2010-03-24-9e46def6-10355-0 |
78d2672aeb70a22eab38938b60baff28bc58b3a1 | Amount of donation or nature and value if donation in kind: £5,000 | Sponsorship or financial or material support 9e46def6 | 2010-03-24 | Oliver Letwin uk.org.publicwhip/member/1549 | Oliver Letwin uk.org.publicwhip/person/10355 | 3 | 2010-03-24-9e46def6-10355-0 |
7fcfe3216dbf08e465f9b157c955535dd4fb7d59 | Name of donor: Ernst & Young | Sponsorship or financial or material support 9e46def6 | 2010-03-24 | Oliver Letwin uk.org.publicwhip/member/1549 | Oliver Letwin uk.org.publicwhip/person/10355 | 8 | 2010-03-24-9e46def6-10355-0 |
813e6328d2880c97d982836c871ed3a4cfd95f9e | Donation to my constituency association solicited or encouraged by me from Ilchester Estates (company donation). | Sponsorship or financial or material support 9e46def6 | 2010-03-24 | Oliver Letwin uk.org.publicwhip/member/1549 | Oliver Letwin uk.org.publicwhip/person/10355 | 0 | 2010-03-24-9e46def6-10355-0 |
83643953dc43e9262c980fbfc743a7e1939438ff | Name of donor: Martyn Rose Limited | Sponsorship or financial or material support 9e46def6 | 2010-03-24 | Oliver Letwin uk.org.publicwhip/member/1549 | Oliver Letwin uk.org.publicwhip/person/10355 | 34 | 2010-03-24-9e46def6-10355-0 |
9236494207ed39f3937dba8c5e60d9dff4e42579 | Date of acceptance: 4 June 2009 | Sponsorship or financial or material support 9e46def6 | 2010-03-24 | Oliver Letwin uk.org.publicwhip/member/1549 | Oliver Letwin uk.org.publicwhip/person/10355 | 12 | 2010-03-24-9e46def6-10355-0 |
95708862676d9792053f04825e37249af012c16f | Name of donor: KPMG LLP | Sponsorship or financial or material support 9e46def6 | 2010-03-24 | Oliver Letwin uk.org.publicwhip/member/1549 | Oliver Letwin uk.org.publicwhip/person/10355 | 22 | 2010-03-24-9e46def6-10355-0 |
99d54f13cad5d7c5f8684ad1fb7ca210132062e2 | Date of receipt: 17 August 2009 | Sponsorship or financial or material support 9e46def6 | 2010-03-24 | Oliver Letwin uk.org.publicwhip/member/1549 | Oliver Letwin uk.org.publicwhip/person/10355 | 11 | 2010-03-24-9e46def6-10355-0 |
a2f6539b8fb911e979524e9d53342629214248de | (Registered 8 July 2009 ) | Sponsorship or financial or material support 9e46def6 | 2010-03-24 | Oliver Letwin uk.org.publicwhip/member/1549 | Oliver Letwin uk.org.publicwhip/person/10355 | 7 | 2010-03-24-9e46def6-10355-0 |
aa17ce16c5d76f0240495ab5f5a6c46bb33aa48f | Donor status: individual | Sponsorship or financial or material support 9e46def6 | 2010-03-24 | Oliver Letwin uk.org.publicwhip/member/1549 | Oliver Letwin uk.org.publicwhip/person/10355 | 32 | 2010-03-24-9e46def6-10355-0 |
b5f9392577bb4bf63d563f48cb5c7a15eb70313a | Date of acceptance: 19 October 2009 | Sponsorship or financial or material support 9e46def6 | 2010-03-24 | Oliver Letwin uk.org.publicwhip/member/1549 | Oliver Letwin uk.org.publicwhip/person/10355 | 19 | 2010-03-24-9e46def6-10355-0 |
bdca2d040ec8854d184af6a345b1f2076c470766 | Date of receipt: 23 December 2009 | Sponsorship or financial or material support 9e46def6 | 2010-03-24 | Oliver Letwin uk.org.publicwhip/member/1549 | Oliver Letwin uk.org.publicwhip/person/10355 | 37 | 2010-03-24-9e46def6-10355-0 |
c1b3140fe47e86d9602bb45b41d5f50c6045c89e | Donor status: Company, registration number 01245537 | Sponsorship or financial or material support 9e46def6 | 2010-03-24 | Oliver Letwin uk.org.publicwhip/member/1549 | Oliver Letwin uk.org.publicwhip/person/10355 | 39 | 2010-03-24-9e46def6-10355-0 |
c2f5dfeb063ab3592ce403a3405e2cf028f6fd01 | (Registered 12 July 2009 ) | Sponsorship or financial or material support 9e46def6 | 2010-03-24 | Oliver Letwin uk.org.publicwhip/member/1549 | Oliver Letwin uk.org.publicwhip/person/10355 | 14 | 2010-03-24-9e46def6-10355-0 |
c4c2681f092c991c197df92e2e095dc402309fe1 | Date of acceptance: 23 June 2009 | Sponsorship or financial or material support 9e46def6 | 2010-03-24 | Oliver Letwin uk.org.publicwhip/member/1549 | Oliver Letwin uk.org.publicwhip/person/10355 | 5 | 2010-03-24-9e46def6-10355-0 |
cc6aed8bde0942abfe3245d5151d686c281019b2 | Address of donor: 1 More London Place, London SE1 2AF | Sponsorship or financial or material support 9e46def6 | 2010-03-24 | Oliver Letwin uk.org.publicwhip/member/1549 | Oliver Letwin uk.org.publicwhip/person/10355 | 9 | 2010-03-24-9e46def6-10355-0 |
d747b703c1440ef2b7cee7c7a025bd282f53358c | Amount of donation or nature and value if donation in kind: secondment of a member of staff to work in the Policy Unit of the Conservative Party from 1 December 2009 to 23 April 2010 (value: £31,472). | Sponsorship or financial or material support 9e46def6 | 2010-03-24 | Oliver Letwin uk.org.publicwhip/member/1549 | Oliver Letwin uk.org.publicwhip/person/10355 | 24 | 2010-03-24-9e46def6-10355-0 |
da315ea9cea0aa8ea448c9dd649de9cdbe8d5442 | Address of donor: 1 Embankment Place, London WC2N 6RH | Sponsorship or financial or material support 9e46def6 | 2010-03-24 | Oliver Letwin uk.org.publicwhip/member/1549 | Oliver Letwin uk.org.publicwhip/person/10355 | 16 | 2010-03-24-9e46def6-10355-0 |
de35f775b5a393919c259fd5886f6698961f67dc | Donor status: Limited Liability Partnership, Companies House registration number OC300001 | Sponsorship or financial or material support 9e46def6 | 2010-03-24 | Oliver Letwin uk.org.publicwhip/member/1549 | Oliver Letwin uk.org.publicwhip/person/10355 | 13 | 2010-03-24-9e46def6-10355-0 |
e9492845c8063e71d26131ab491e23cb76415961 | Date of receipt: 26 May 2009 | Sponsorship or financial or material support 9e46def6 | 2010-03-24 | Oliver Letwin uk.org.publicwhip/member/1549 | Oliver Letwin uk.org.publicwhip/person/10355 | 4 | 2010-03-24-9e46def6-10355-0 |
ec560abb5029afc0841681f6335d186132cd6850 | Amount of donation or nature and value if donation in kind: secondment of member of staff to work in the Policy Unit of the Conservative Party from 19 October 2009 to 23 April 2010. Value of secondment, £28,583 | Sponsorship or financial or material support 9e46def6 | 2010-03-24 | Oliver Letwin uk.org.publicwhip/member/1549 | Oliver Letwin uk.org.publicwhip/person/10355 | 17 | 2010-03-24-9e46def6-10355-0 |
f811b1c67394ec313c5779326b1144618f319521 | Name of donor: Ilchester Estates | Sponsorship or financial or material support 9e46def6 | 2010-03-24 | Oliver Letwin uk.org.publicwhip/member/1549 | Oliver Letwin uk.org.publicwhip/person/10355 | 1 | 2010-03-24-9e46def6-10355-0 |
fabbea7ac1ad1486f636536d148786ea459fa7d8 | (Registered 17 February 2010) | Sponsorship or financial or material support 9e46def6 | 2010-03-24 | Oliver Letwin uk.org.publicwhip/member/1549 | Oliver Letwin uk.org.publicwhip/person/10355 | 40 | 2010-03-24-9e46def6-10355-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");