items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
37 rows where record_id = "2008-10-08-9e46def6-11812-0" sorted by sort_order
This data as json, CSV (advanced)
Suggested facets: date (date)
hash | item | category_id | date | member_id | person_id | sort_order ▼ | record_id |
---|---|---|---|---|---|---|---|
017596b1403840a54b2eabdd8a441abaab2358a8 | The Liberal Democrat leader's office receives monthly contributions towards the cost of staffing, made through the Parliamentary Office of the Liberal Democrats, from: | Sponsorship or financial or material support 9e46def6 | 2008-10-08 | Nicholas Clegg uk.org.publicwhip/member/1812 | Nick Clegg uk.org.publicwhip/person/11812 | 0 | 2008-10-08-9e46def6-11812-0 |
465334f32d9748cd82e5f47752d6527732a791af | Mr Neil Sherlock, Godalming (personal donation) | Sponsorship or financial or material support 9e46def6 | 2008-10-08 | Nicholas Clegg uk.org.publicwhip/member/1812 | Nick Clegg uk.org.publicwhip/person/11812 | 1 | 2008-10-08-9e46def6-11812-0 |
185287ef0ef550e815b7cc280e711d67b451e7d7 | Mr Ian Wright, Rutland (personal donation) | Sponsorship or financial or material support 9e46def6 | 2008-10-08 | Nicholas Clegg uk.org.publicwhip/member/1812 | Nick Clegg uk.org.publicwhip/person/11812 | 2 | 2008-10-08-9e46def6-11812-0 |
32c3fc5fb0a5daf65c27b03fa45c8b00739a6d08 | Mr Michael Young, London (personal donation) | Sponsorship or financial or material support 9e46def6 | 2008-10-08 | Nicholas Clegg uk.org.publicwhip/member/1812 | Nick Clegg uk.org.publicwhip/person/11812 | 3 | 2008-10-08-9e46def6-11812-0 |
f4f11a538d6944ff4d06532604ae622a699c6bac | The Liberal Democrat Leader's office has received additional donations, made through the Parliamentary Office of the Liberal Democrats, from: | Sponsorship or financial or material support 9e46def6 | 2008-10-08 | Nicholas Clegg uk.org.publicwhip/member/1812 | Nick Clegg uk.org.publicwhip/person/11812 | 4 | 2008-10-08-9e46def6-11812-0 |
2686d06c04380e7292d84e5b5ca37fbd3b449d3f | Mr Richard Duncalf, Wilmslow (personal donation) ( (Registered 29 May 2008) | Sponsorship or financial or material support 9e46def6 | 2008-10-08 | Nicholas Clegg uk.org.publicwhip/member/1812 | Nick Clegg uk.org.publicwhip/person/11812 | 5 | 2008-10-08-9e46def6-11812-0 |
92f364317564b8044d901ab66ea0fc3effc3215f | Lord Alliance (personal donation) (Registered 3 June 2008) | Sponsorship or financial or material support 9e46def6 | 2008-10-08 | Nicholas Clegg uk.org.publicwhip/member/1812 | Nick Clegg uk.org.publicwhip/person/11812 | 6 | 2008-10-08-9e46def6-11812-0 |
f1599ac0fd869860d48bcea186c4ecf5d843794e | Mr Graham Durgan, Littlewick Green (personal donation) (Registered 16 June 2008) | Sponsorship or financial or material support 9e46def6 | 2008-10-08 | Nicholas Clegg uk.org.publicwhip/member/1812 | Nick Clegg uk.org.publicwhip/person/11812 | 7 | 2008-10-08-9e46def6-11812-0 |
1bda1831efceb2382782d3b65ec7a233fcc21671 | The Sheffield Hallam Liberal Democrat party receives donations towards the salary of a member of staff in Sheffield from: | Sponsorship or financial or material support 9e46def6 | 2008-10-08 | Nicholas Clegg uk.org.publicwhip/member/1812 | Nick Clegg uk.org.publicwhip/person/11812 | 8 | 2008-10-08-9e46def6-11812-0 |
8f378880702c1e7bf2f719eb415bdaf4064de29c | Mr Paul Clegg, Littleton (personal donation) | Sponsorship or financial or material support 9e46def6 | 2008-10-08 | Nicholas Clegg uk.org.publicwhip/member/1812 | Nick Clegg uk.org.publicwhip/person/11812 | 9 | 2008-10-08-9e46def6-11812-0 |
e932879172b5c367bf5fb9cfcd62afde1f4a73ec | Mr Hugh Facey, a constituent (personal donation) | Sponsorship or financial or material support 9e46def6 | 2008-10-08 | Nicholas Clegg uk.org.publicwhip/member/1812 | Nick Clegg uk.org.publicwhip/person/11812 | 10 | 2008-10-08-9e46def6-11812-0 |
f74f917654e49283f627e7a1db081e50fbc4d9ae | Mr Duncan Greenland, London (personal donation) | Sponsorship or financial or material support 9e46def6 | 2008-10-08 | Nicholas Clegg uk.org.publicwhip/member/1812 | Nick Clegg uk.org.publicwhip/person/11812 | 11 | 2008-10-08-9e46def6-11812-0 |
a39e34c1770ba8bf570cafedb97dc71b5603c73f | Mr James Tugendhat, London (personal donation) | Sponsorship or financial or material support 9e46def6 | 2008-10-08 | Nicholas Clegg uk.org.publicwhip/member/1812 | Nick Clegg uk.org.publicwhip/person/11812 | 12 | 2008-10-08-9e46def6-11812-0 |
2c20d2ca5ad11eb8f40b41bb49201de0f5426a79 | Mr Tony Wilkinson, Mapleback (personal donation) | Sponsorship or financial or material support 9e46def6 | 2008-10-08 | Nicholas Clegg uk.org.publicwhip/member/1812 | Nick Clegg uk.org.publicwhip/person/11812 | 13 | 2008-10-08-9e46def6-11812-0 |
eb0d78bdccb9c6de31f3f4eed18b11019657b24a | Mr Michael Young, London (personal donation) | Sponsorship or financial or material support 9e46def6 | 2008-10-08 | Nicholas Clegg uk.org.publicwhip/member/1812 | Nick Clegg uk.org.publicwhip/person/11812 | 14 | 2008-10-08-9e46def6-11812-0 |
4f3a0acbff0e8d18d1ddf453d544e239cc9a4bb6 | Mr Peter Dunphy, London (personal donation) | Sponsorship or financial or material support 9e46def6 | 2008-10-08 | Nicholas Clegg uk.org.publicwhip/member/1812 | Nick Clegg uk.org.publicwhip/person/11812 | 15 | 2008-10-08-9e46def6-11812-0 |
790fef7ffafa22acacc312123cd73b69e9c15171 | The following donors have contributed to my campaign for the leadership of the Liberal Democrat Party: | Sponsorship or financial or material support 9e46def6 | 2008-10-08 | Nicholas Clegg uk.org.publicwhip/member/1812 | Nick Clegg uk.org.publicwhip/person/11812 | 16 | 2008-10-08-9e46def6-11812-0 |
29ec9eff2b37d8aec71b8dcc1a96a0dfbb1a585b | Mr Michael Young , London (personal donation) | Sponsorship or financial or material support 9e46def6 | 2008-10-08 | Nicholas Clegg uk.org.publicwhip/member/1812 | Nick Clegg uk.org.publicwhip/person/11812 | 17 | 2008-10-08-9e46def6-11812-0 |
0a4ad470d79381e5130b7e1aa00712b50414a227 | Mr Duncan Greenland, London(personal donation) | Sponsorship or financial or material support 9e46def6 | 2008-10-08 | Nicholas Clegg uk.org.publicwhip/member/1812 | Nick Clegg uk.org.publicwhip/person/11812 | 18 | 2008-10-08-9e46def6-11812-0 |
3ecb5fdf4c0f80fb37e6a2654da3991e17ed20c6 | Mr Neil Sherlock, Godalming (personal donation) | Sponsorship or financial or material support 9e46def6 | 2008-10-08 | Nicholas Clegg uk.org.publicwhip/member/1812 | Nick Clegg uk.org.publicwhip/person/11812 | 19 | 2008-10-08-9e46def6-11812-0 |
28d46a0764038ebc5f32b5f6990e7af51c60a6d1 | Mr Ian Wright, Rutland (personal donation) | Sponsorship or financial or material support 9e46def6 | 2008-10-08 | Nicholas Clegg uk.org.publicwhip/member/1812 | Nick Clegg uk.org.publicwhip/person/11812 | 20 | 2008-10-08-9e46def6-11812-0 |
bdba3030b0c539c9b1f2d8ec2e5e3fd641f5cc1d | Mr Charles Brand, London (personal donation) | Sponsorship or financial or material support 9e46def6 | 2008-10-08 | Nicholas Clegg uk.org.publicwhip/member/1812 | Nick Clegg uk.org.publicwhip/person/11812 | 21 | 2008-10-08-9e46def6-11812-0 |
e8b022ca6a0ab46433858a4d6e68215f08e31f85 | Mr Paul Marshall, London (personal donation) | Sponsorship or financial or material support 9e46def6 | 2008-10-08 | Nicholas Clegg uk.org.publicwhip/member/1812 | Nick Clegg uk.org.publicwhip/person/11812 | 22 | 2008-10-08-9e46def6-11812-0 |
26dce9d975a6426b22d8226bb20101b3deb278ca | Lord Alliance (personal donation) | Sponsorship or financial or material support 9e46def6 | 2008-10-08 | Nicholas Clegg uk.org.publicwhip/member/1812 | Nick Clegg uk.org.publicwhip/person/11812 | 23 | 2008-10-08-9e46def6-11812-0 |
521ecba548fcd3176d5ed12cb2360a4b38989d65 | Lord Jacobs (personal donation) | Sponsorship or financial or material support 9e46def6 | 2008-10-08 | Nicholas Clegg uk.org.publicwhip/member/1812 | Nick Clegg uk.org.publicwhip/person/11812 | 24 | 2008-10-08-9e46def6-11812-0 |
44ed280e4d0db39c4cabdf037d54f3195a0f9ee3 | Mr R B and Mrs J A Clark, Rhino Rugby Ltd London | Sponsorship or financial or material support 9e46def6 | 2008-10-08 | Nicholas Clegg uk.org.publicwhip/member/1812 | Nick Clegg uk.org.publicwhip/person/11812 | 25 | 2008-10-08-9e46def6-11812-0 |
37fd26de2153194f0299a09fc562e6b0c3edf05f | Sharkey Associates Ltd, London | Sponsorship or financial or material support 9e46def6 | 2008-10-08 | Nicholas Clegg uk.org.publicwhip/member/1812 | Nick Clegg uk.org.publicwhip/person/11812 | 26 | 2008-10-08-9e46def6-11812-0 |
70af2b53b574d3e9d0090c0f74429ee853530936 | Mr P M Crystal, London (personal donation) | Sponsorship or financial or material support 9e46def6 | 2008-10-08 | Nicholas Clegg uk.org.publicwhip/member/1812 | Nick Clegg uk.org.publicwhip/person/11812 | 27 | 2008-10-08-9e46def6-11812-0 |
7cf0095061d4d0d845eedcb69ff74a0ce38cbd87 | Mr Raj Loomba, Rinku Group plc, London | Sponsorship or financial or material support 9e46def6 | 2008-10-08 | Nicholas Clegg uk.org.publicwhip/member/1812 | Nick Clegg uk.org.publicwhip/person/11812 | 28 | 2008-10-08-9e46def6-11812-0 |
09b4c8c06e3f967b3ceb8947f850186474202148 | (Registered 26 November 2007) | Sponsorship or financial or material support 9e46def6 | 2008-10-08 | Nicholas Clegg uk.org.publicwhip/member/1812 | Nick Clegg uk.org.publicwhip/person/11812 | 29 | 2008-10-08-9e46def6-11812-0 |
000506bd7cc1fc0ec10d50b21ed7379556584477 | J D Byam Shaw, Oxford (personal donation) | Sponsorship or financial or material support 9e46def6 | 2008-10-08 | Nicholas Clegg uk.org.publicwhip/member/1812 | Nick Clegg uk.org.publicwhip/person/11812 | 30 | 2008-10-08-9e46def6-11812-0 |
95fac49e1b8889c4d42be24ba86cdd155f87439e | (Registered 12 December 2007) | Sponsorship or financial or material support 9e46def6 | 2008-10-08 | Nicholas Clegg uk.org.publicwhip/member/1812 | Nick Clegg uk.org.publicwhip/person/11812 | 31 | 2008-10-08-9e46def6-11812-0 |
e513f82bc5b60a5c357e750dc0b895ff4bca3424 | Richard Duncalf, Wilmslow (personal donation) | Sponsorship or financial or material support 9e46def6 | 2008-10-08 | Nicholas Clegg uk.org.publicwhip/member/1812 | Nick Clegg uk.org.publicwhip/person/11812 | 32 | 2008-10-08-9e46def6-11812-0 |
45bd14dbba50c000a3d3c826b443393c81151670 | (Registered 20 December 2007) | Sponsorship or financial or material support 9e46def6 | 2008-10-08 | Nicholas Clegg uk.org.publicwhip/member/1812 | Nick Clegg uk.org.publicwhip/person/11812 | 33 | 2008-10-08-9e46def6-11812-0 |
50c8a1cc118984b36144185e3f2ee2933f312bd4 | Mr Robert J Chicken, London (personal donation) | Sponsorship or financial or material support 9e46def6 | 2008-10-08 | Nicholas Clegg uk.org.publicwhip/member/1812 | Nick Clegg uk.org.publicwhip/person/11812 | 34 | 2008-10-08-9e46def6-11812-0 |
9e7d0f14bcce60ee2cdf1321f652cf531e250ec9 | Marcus Evans Ltd, London (donation of telephone polling services) | Sponsorship or financial or material support 9e46def6 | 2008-10-08 | Nicholas Clegg uk.org.publicwhip/member/1812 | Nick Clegg uk.org.publicwhip/person/11812 | 35 | 2008-10-08-9e46def6-11812-0 |
a5b00bcd0e0613ca7e7e87610cb3279bb02a4bfa | (Registered 16 January 2008) | Sponsorship or financial or material support 9e46def6 | 2008-10-08 | Nicholas Clegg uk.org.publicwhip/member/1812 | Nick Clegg uk.org.publicwhip/person/11812 | 36 | 2008-10-08-9e46def6-11812-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");