items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
33 rows where "date" is on date 2008-11-19 and record_id = "2008-11-19-9e46def6-10355-0" sorted by date descending
This data as json, CSV (advanced)
Suggested facets: date (date)
hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
84f70a9404806c969e7f808e887d7f7f939e60e1 | Financial support for my office provided by Dr Hans Rausing, industrialist. | Sponsorship or financial or material support 9e46def6 | 2008-11-19 | Oliver Letwin uk.org.publicwhip/member/1549 | Oliver Letwin uk.org.publicwhip/person/10355 | 0 | 2008-11-19-9e46def6-10355-0 |
5885ca9971ee8bac55f5dcb8f0e901cc6673fe1a | A member of staff is seconded by KPMG to work in the Policy Unit of the Conservative Party, working to the Director of Policy and Research; I am Chairman of the Policy Review. (Registered 20 January 2008) | Sponsorship or financial or material support 9e46def6 | 2008-11-19 | Oliver Letwin uk.org.publicwhip/member/1549 | Oliver Letwin uk.org.publicwhip/person/10355 | 1 | 2008-11-19-9e46def6-10355-0 |
55cdf0425e7ad849f0f2ee96b9b6461b94f6abbb | Donation to my constituency association solicited or encouraged by me from: | Sponsorship or financial or material support 9e46def6 | 2008-11-19 | Oliver Letwin uk.org.publicwhip/member/1549 | Oliver Letwin uk.org.publicwhip/person/10355 | 2 | 2008-11-19-9e46def6-10355-0 |
b193a2c612c38055cd3dd68a57b67bbe2c1d3b86 | Ilchester Estates (company donation) (Registered 7 February 2008) | Sponsorship or financial or material support 9e46def6 | 2008-11-19 | Oliver Letwin uk.org.publicwhip/member/1549 | Oliver Letwin uk.org.publicwhip/person/10355 | 3 | 2008-11-19-9e46def6-10355-0 |
e3f7a80f3440e9f2df21fb1318b110703a859315 | Donations to WIN, an organisation the purpose of which is to raise funds to support the election of Conservatives in West Dorset and South Dorset constituencies, solicited or encouraged by me from: | Sponsorship or financial or material support 9e46def6 | 2008-11-19 | Oliver Letwin uk.org.publicwhip/member/1549 | Oliver Letwin uk.org.publicwhip/person/10355 | 4 | 2008-11-19-9e46def6-10355-0 |
f5420a5b8ca6211d69de58a4dec85ccb1932bb30 | Knight Frank, London (company donation) | Sponsorship or financial or material support 9e46def6 | 2008-11-19 | Oliver Letwin uk.org.publicwhip/member/1549 | Oliver Letwin uk.org.publicwhip/person/10355 | 5 | 2008-11-19-9e46def6-10355-0 |
3484fb4cb5da182650a4df08517d0f993a8d24fb | Richard Fry, Yeovil (personal donation) | Sponsorship or financial or material support 9e46def6 | 2008-11-19 | Oliver Letwin uk.org.publicwhip/member/1549 | Oliver Letwin uk.org.publicwhip/person/10355 | 6 | 2008-11-19-9e46def6-10355-0 |
c28fc56481c00f9da3577741e55881bf941e1a6a | Simon and Antonia Johnson, Bath (personal donation) | Sponsorship or financial or material support 9e46def6 | 2008-11-19 | Oliver Letwin uk.org.publicwhip/member/1549 | Oliver Letwin uk.org.publicwhip/person/10355 | 7 | 2008-11-19-9e46def6-10355-0 |
3be536907243718d7ecc4a2cc18d952d2fe0dae5 | Mr and Mrs Dorien Smith, Tresco, Isles of Scilly (personal donation) | Sponsorship or financial or material support 9e46def6 | 2008-11-19 | Oliver Letwin uk.org.publicwhip/member/1549 | Oliver Letwin uk.org.publicwhip/person/10355 | 8 | 2008-11-19-9e46def6-10355-0 |
65e68d055543ed9f705e967de923a37783aea266 | Otto Hamilton, Stalbridge, Dorset (personal donation) | Sponsorship or financial or material support 9e46def6 | 2008-11-19 | Oliver Letwin uk.org.publicwhip/member/1549 | Oliver Letwin uk.org.publicwhip/person/10355 | 9 | 2008-11-19-9e46def6-10355-0 |
d2ec8ec1cbf0ce815f0e8b3be390df3f463e6e47 | Lord Cameron, Ilminster, Somerset (personal donation) | Sponsorship or financial or material support 9e46def6 | 2008-11-19 | Oliver Letwin uk.org.publicwhip/member/1549 | Oliver Letwin uk.org.publicwhip/person/10355 | 10 | 2008-11-19-9e46def6-10355-0 |
2b6b638731b2288c65313cb3e50795bd09974c00 | Sarah Wild, Dorchester, Dorset (personal donation) | Sponsorship or financial or material support 9e46def6 | 2008-11-19 | Oliver Letwin uk.org.publicwhip/member/1549 | Oliver Letwin uk.org.publicwhip/person/10355 | 11 | 2008-11-19-9e46def6-10355-0 |
c4ac878c77f535472619cb34aad3be4d7897922a | Guiseppe Ciardi, London (personal donation) | Sponsorship or financial or material support 9e46def6 | 2008-11-19 | Oliver Letwin uk.org.publicwhip/member/1549 | Oliver Letwin uk.org.publicwhip/person/10355 | 12 | 2008-11-19-9e46def6-10355-0 |
4666b390bb2ca4842586f2d271549af9f9160d25 | Mark Vaughan-Lee, Dorchester, Dorset (personal donation) | Sponsorship or financial or material support 9e46def6 | 2008-11-19 | Oliver Letwin uk.org.publicwhip/member/1549 | Oliver Letwin uk.org.publicwhip/person/10355 | 13 | 2008-11-19-9e46def6-10355-0 |
be538df85f9aa67bf66b6c1497795c93ce0a6ae5 | Clare Trenchard, Bridport, Dorset (personal donation) | Sponsorship or financial or material support 9e46def6 | 2008-11-19 | Oliver Letwin uk.org.publicwhip/member/1549 | Oliver Letwin uk.org.publicwhip/person/10355 | 14 | 2008-11-19-9e46def6-10355-0 |
f4778466ca29429f4e9a444a204333ad11745125 | Mark Bullough, Crewkerne, Somerset (personal donation) | Sponsorship or financial or material support 9e46def6 | 2008-11-19 | Oliver Letwin uk.org.publicwhip/member/1549 | Oliver Letwin uk.org.publicwhip/person/10355 | 15 | 2008-11-19-9e46def6-10355-0 |
0130458aa45b3f88bc24e2c11672b7666c703783 | Nick Fisher, Beaminster, Dorset (personal donation) | Sponsorship or financial or material support 9e46def6 | 2008-11-19 | Oliver Letwin uk.org.publicwhip/member/1549 | Oliver Letwin uk.org.publicwhip/person/10355 | 16 | 2008-11-19-9e46def6-10355-0 |
5596353b4b3a347c0ff16f411d58cc01b40f9a8a | Gavin Bacon, Dorchester, Dorset (personal donation) | Sponsorship or financial or material support 9e46def6 | 2008-11-19 | Oliver Letwin uk.org.publicwhip/member/1549 | Oliver Letwin uk.org.publicwhip/person/10355 | 17 | 2008-11-19-9e46def6-10355-0 |
108f1999c12db2ca6150b461294fd3b5b50719e5 | Viscount Fitzharris, Dorchester, Dorset (personal donation) | Sponsorship or financial or material support 9e46def6 | 2008-11-19 | Oliver Letwin uk.org.publicwhip/member/1549 | Oliver Letwin uk.org.publicwhip/person/10355 | 18 | 2008-11-19-9e46def6-10355-0 |
dc5a15494f1bb912deb8b518142b1650d0b288b8 | Emma Treichl, Beaminster, Dorset (personal donation) | Sponsorship or financial or material support 9e46def6 | 2008-11-19 | Oliver Letwin uk.org.publicwhip/member/1549 | Oliver Letwin uk.org.publicwhip/person/10355 | 19 | 2008-11-19-9e46def6-10355-0 |
eea32cc7987786e3c16145b88d6088a54d838501 | Stephen Froy, Beaminster, Dorset (personal donation) | Sponsorship or financial or material support 9e46def6 | 2008-11-19 | Oliver Letwin uk.org.publicwhip/member/1549 | Oliver Letwin uk.org.publicwhip/person/10355 | 20 | 2008-11-19-9e46def6-10355-0 |
25163d539a8cac5329effc75ca3150a0f0b2ac9d | Lucy Pinney, Rampisham, Dorchester, Dorset (personal donation) | Sponsorship or financial or material support 9e46def6 | 2008-11-19 | Oliver Letwin uk.org.publicwhip/member/1549 | Oliver Letwin uk.org.publicwhip/person/10355 | 21 | 2008-11-19-9e46def6-10355-0 |
6a46039c0b5484bbb5d028ea6721e085131b866a | Fiona Elder, Dorchester, Dorset (personal donation) | Sponsorship or financial or material support 9e46def6 | 2008-11-19 | Oliver Letwin uk.org.publicwhip/member/1549 | Oliver Letwin uk.org.publicwhip/person/10355 | 22 | 2008-11-19-9e46def6-10355-0 |
c6446b30591562565424e26d37520b34b0e1ab0f | Mr S Sacher, Dorchester, Dorset (personal donation) | Sponsorship or financial or material support 9e46def6 | 2008-11-19 | Oliver Letwin uk.org.publicwhip/member/1549 | Oliver Letwin uk.org.publicwhip/person/10355 | 23 | 2008-11-19-9e46def6-10355-0 |
8cd5f4146de35f72b86f9c8d8057ff3a288f463a | Oliver Pope, Dorchester, Dorset (personal donation) | Sponsorship or financial or material support 9e46def6 | 2008-11-19 | Oliver Letwin uk.org.publicwhip/member/1549 | Oliver Letwin uk.org.publicwhip/person/10355 | 24 | 2008-11-19-9e46def6-10355-0 |
db776cb5a2864399a1dd24da71d3973fdb297550 | Mr M Treichl, Beaminster, Dorset (personal donation) | Sponsorship or financial or material support 9e46def6 | 2008-11-19 | Oliver Letwin uk.org.publicwhip/member/1549 | Oliver Letwin uk.org.publicwhip/person/10355 | 25 | 2008-11-19-9e46def6-10355-0 |
1718abb1c1923ebd60f73749dc483dbc33f4a5c5 | Mr Sancroft-Baker, Lechlade (personal donation) | Sponsorship or financial or material support 9e46def6 | 2008-11-19 | Oliver Letwin uk.org.publicwhip/member/1549 | Oliver Letwin uk.org.publicwhip/person/10355 | 26 | 2008-11-19-9e46def6-10355-0 |
dc9b3b925973d69a3a47b3a096c653f2182da647 | Gavin Philips, London (personal donation) | Sponsorship or financial or material support 9e46def6 | 2008-11-19 | Oliver Letwin uk.org.publicwhip/member/1549 | Oliver Letwin uk.org.publicwhip/person/10355 | 27 | 2008-11-19-9e46def6-10355-0 |
e948446d08b15808839d3e7c9ae1b17e9dd1d50b | Mr and Mrs Hadden-Paton, Dorchester, Dorset (personal donation) | Sponsorship or financial or material support 9e46def6 | 2008-11-19 | Oliver Letwin uk.org.publicwhip/member/1549 | Oliver Letwin uk.org.publicwhip/person/10355 | 28 | 2008-11-19-9e46def6-10355-0 |
6513f6860d1ebba088d495c83d3bbbe13b4e0236 | Philip Von Mallinckrodt, London (personal donation) | Sponsorship or financial or material support 9e46def6 | 2008-11-19 | Oliver Letwin uk.org.publicwhip/member/1549 | Oliver Letwin uk.org.publicwhip/person/10355 | 29 | 2008-11-19-9e46def6-10355-0 |
1d48ebef0685c032a4867377150326782ae40d97 | James Hollond, London (personal donation) | Sponsorship or financial or material support 9e46def6 | 2008-11-19 | Oliver Letwin uk.org.publicwhip/member/1549 | Oliver Letwin uk.org.publicwhip/person/10355 | 30 | 2008-11-19-9e46def6-10355-0 |
802e3c37a6b4dcf07cae41482ee471aba1aa8d48 | Brewery Square Ltd, London (company donation) | Sponsorship or financial or material support 9e46def6 | 2008-11-19 | Oliver Letwin uk.org.publicwhip/member/1549 | Oliver Letwin uk.org.publicwhip/person/10355 | 31 | 2008-11-19-9e46def6-10355-0 |
233bed612d44ff965a52717484e501a97a0db99c | (Registered 13 February 2008) | Sponsorship or financial or material support 9e46def6 | 2008-11-19 | Oliver Letwin uk.org.publicwhip/member/1549 | Oliver Letwin uk.org.publicwhip/person/10355 | 32 | 2008-11-19-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");