items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
22 rows where record_id = "2009-04-22-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 |
---|---|---|---|---|---|---|---|
5eac51c19389f0135f9a9332dd0fe050d8c6337a | 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 | 2009-04-22 | Nicholas Clegg uk.org.publicwhip/member/1812 | Nick Clegg uk.org.publicwhip/person/11812 | 0 | 2009-04-22-9e46def6-11812-0 |
449caa902551867b1b674b306764cd1d47da9043 | Mr Neil Sherlock, Godalming (personal donation) | Sponsorship or financial or material support 9e46def6 | 2009-04-22 | Nicholas Clegg uk.org.publicwhip/member/1812 | Nick Clegg uk.org.publicwhip/person/11812 | 1 | 2009-04-22-9e46def6-11812-0 |
c6388d10602b18edf8ac6fdd3c39b8afb6d3d021 | Mr Ian Wright, Rutland (personal donation) | Sponsorship or financial or material support 9e46def6 | 2009-04-22 | Nicholas Clegg uk.org.publicwhip/member/1812 | Nick Clegg uk.org.publicwhip/person/11812 | 2 | 2009-04-22-9e46def6-11812-0 |
6f48e27fa4d702bfb9e1d5915d4ed6dca50f19d6 | Mr Michael Young, London (personal donation) | Sponsorship or financial or material support 9e46def6 | 2009-04-22 | Nicholas Clegg uk.org.publicwhip/member/1812 | Nick Clegg uk.org.publicwhip/person/11812 | 3 | 2009-04-22-9e46def6-11812-0 |
0064ed4ce284a6e8101b0dfc02a0d2b283addc05 | 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 | 2009-04-22 | Nicholas Clegg uk.org.publicwhip/member/1812 | Nick Clegg uk.org.publicwhip/person/11812 | 4 | 2009-04-22-9e46def6-11812-0 |
0160fd84c6ff1b2dcab523be02fba587735d942b | Mr Richard Duncalf, Wilmslow (personal donation) ( (Registered 29 May 2008) | Sponsorship or financial or material support 9e46def6 | 2009-04-22 | Nicholas Clegg uk.org.publicwhip/member/1812 | Nick Clegg uk.org.publicwhip/person/11812 | 5 | 2009-04-22-9e46def6-11812-0 |
0b62c86c9a87816420a4483639b4a144ea05196b | Lord Alliance (personal donation) (Registered 3 June 2008) | Sponsorship or financial or material support 9e46def6 | 2009-04-22 | Nicholas Clegg uk.org.publicwhip/member/1812 | Nick Clegg uk.org.publicwhip/person/11812 | 6 | 2009-04-22-9e46def6-11812-0 |
842fd4bcc20fc797a28635c054d90d8ee336b8f0 | Mr Graham Durgan, Littlewick Green (personal donation) (Registered 16 June 2008) | Sponsorship or financial or material support 9e46def6 | 2009-04-22 | Nicholas Clegg uk.org.publicwhip/member/1812 | Nick Clegg uk.org.publicwhip/person/11812 | 7 | 2009-04-22-9e46def6-11812-0 |
eb832abe7e06873d4826fb36e65181699980a5c5 | The Joseph Rowntree Reform Trust Limited, York. (Registered 1 December 2008) | Sponsorship or financial or material support 9e46def6 | 2009-04-22 | Nicholas Clegg uk.org.publicwhip/member/1812 | Nick Clegg uk.org.publicwhip/person/11812 | 8 | 2009-04-22-9e46def6-11812-0 |
8729e25803cc02319b578b2c0c0cea149458fd76 | 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 | 2009-04-22 | Nicholas Clegg uk.org.publicwhip/member/1812 | Nick Clegg uk.org.publicwhip/person/11812 | 9 | 2009-04-22-9e46def6-11812-0 |
e0d8746394dec25309ec22d5a966f12232ca6bad | Mr Paul Clegg, Littleton (personal donation) | Sponsorship or financial or material support 9e46def6 | 2009-04-22 | Nicholas Clegg uk.org.publicwhip/member/1812 | Nick Clegg uk.org.publicwhip/person/11812 | 10 | 2009-04-22-9e46def6-11812-0 |
b79704d52c3a990aab65bdbf4ef634724ebe0b27 | Mr Hugh Facey, a constituent (personal donation) | Sponsorship or financial or material support 9e46def6 | 2009-04-22 | Nicholas Clegg uk.org.publicwhip/member/1812 | Nick Clegg uk.org.publicwhip/person/11812 | 11 | 2009-04-22-9e46def6-11812-0 |
044c0c7224794a3aabfb8cf474d0a0680de047b9 | Mr Duncan Greenland, London (personal donation) | Sponsorship or financial or material support 9e46def6 | 2009-04-22 | Nicholas Clegg uk.org.publicwhip/member/1812 | Nick Clegg uk.org.publicwhip/person/11812 | 12 | 2009-04-22-9e46def6-11812-0 |
321bcfcaa6d497f04239be78e87a53100cfde69a | Mr James Tugendhat, London (personal donation) | Sponsorship or financial or material support 9e46def6 | 2009-04-22 | Nicholas Clegg uk.org.publicwhip/member/1812 | Nick Clegg uk.org.publicwhip/person/11812 | 13 | 2009-04-22-9e46def6-11812-0 |
f879080dd0dfd2e59c18784d7b743ffd62ba4783 | Mr Tony Wilkinson, Mapleback (personal donation) | Sponsorship or financial or material support 9e46def6 | 2009-04-22 | Nicholas Clegg uk.org.publicwhip/member/1812 | Nick Clegg uk.org.publicwhip/person/11812 | 14 | 2009-04-22-9e46def6-11812-0 |
5507604c5cbddadae15cb9fcdba5057e42c3639b | Mr Michael Young, London (personal donation) | Sponsorship or financial or material support 9e46def6 | 2009-04-22 | Nicholas Clegg uk.org.publicwhip/member/1812 | Nick Clegg uk.org.publicwhip/person/11812 | 15 | 2009-04-22-9e46def6-11812-0 |
98cfc10233210deb731e83cb7682f5e95dba0898 | Mr Peter Dunphy, London (personal donation) | Sponsorship or financial or material support 9e46def6 | 2009-04-22 | Nicholas Clegg uk.org.publicwhip/member/1812 | Nick Clegg uk.org.publicwhip/person/11812 | 16 | 2009-04-22-9e46def6-11812-0 |
f6da1fa0846f06193e1a690c965644259b714dc8 | The Sheffield Hallam Liberal Democrat party has received other donations from: | Sponsorship or financial or material support 9e46def6 | 2009-04-22 | Nicholas Clegg uk.org.publicwhip/member/1812 | Nick Clegg uk.org.publicwhip/person/11812 | 17 | 2009-04-22-9e46def6-11812-0 |
e4f55671ab5a57e527726e71c1d75d71b41c0ef4 | Mr Nicholas P Clegg, Chinnor (personal donation) (Registered 1 December 2008) | Sponsorship or financial or material support 9e46def6 | 2009-04-22 | Nicholas Clegg uk.org.publicwhip/member/1812 | Nick Clegg uk.org.publicwhip/person/11812 | 18 | 2009-04-22-9e46def6-11812-0 |
51ffceedee1a3f8af7c17b5349cf667548217d32 | Mr Paul Clegg, Littleton (personal donation) (Registered 1 December 2008) | Sponsorship or financial or material support 9e46def6 | 2009-04-22 | Nicholas Clegg uk.org.publicwhip/member/1812 | Nick Clegg uk.org.publicwhip/person/11812 | 19 | 2009-04-22-9e46def6-11812-0 |
ba280478e94a74521d9c6beeae91b26cf82b3b79 | Mr Tim Ward, St Georges Hill, paid for communications consultancy in 2008 (personal donation). (Registered 8 January 2009) | Sponsorship or financial or material support 9e46def6 | 2009-04-22 | Nicholas Clegg uk.org.publicwhip/member/1812 | Nick Clegg uk.org.publicwhip/person/11812 | 20 | 2009-04-22-9e46def6-11812-0 |
f3a9f83216ad861b8559ff9ea9af239313100976 | Electric Airwaves Limited, London, provided pro bono communications consultancy in 2008. (Registered 8 January 2009) | Sponsorship or financial or material support 9e46def6 | 2009-04-22 | Nicholas Clegg uk.org.publicwhip/member/1812 | Nick Clegg uk.org.publicwhip/person/11812 | 21 | 2009-04-22-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");