items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
28 rows where record_id = "2009-07-21-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 |
---|---|---|---|---|---|---|---|
848df59fddb6faf74cc9c9f8105bde3d8611d51c | 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-07-21 | Nicholas Clegg uk.org.publicwhip/member/1812 | Nick Clegg uk.org.publicwhip/person/11812 | 0 | 2009-07-21-9e46def6-11812-0 |
e0b4ff02a17caedfe6a394aa868022f788234071 | Mr Neil Sherlock, Godalming (personal donation) | Sponsorship or financial or material support 9e46def6 | 2009-07-21 | Nicholas Clegg uk.org.publicwhip/member/1812 | Nick Clegg uk.org.publicwhip/person/11812 | 1 | 2009-07-21-9e46def6-11812-0 |
191852b77491cde388e26a64a2036ee09fda5e6a | Mr Ian Wright, Rutland (personal donation) | Sponsorship or financial or material support 9e46def6 | 2009-07-21 | Nicholas Clegg uk.org.publicwhip/member/1812 | Nick Clegg uk.org.publicwhip/person/11812 | 2 | 2009-07-21-9e46def6-11812-0 |
466081f8ba2fde24803fb4d23767a12316fadba2 | Mr Michael Young, London (personal donation) | Sponsorship or financial or material support 9e46def6 | 2009-07-21 | Nicholas Clegg uk.org.publicwhip/member/1812 | Nick Clegg uk.org.publicwhip/person/11812 | 3 | 2009-07-21-9e46def6-11812-0 |
f8be1e0ade0c5de310d90a472192dea5017ad06b | 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-07-21 | Nicholas Clegg uk.org.publicwhip/member/1812 | Nick Clegg uk.org.publicwhip/person/11812 | 4 | 2009-07-21-9e46def6-11812-0 |
e525d718abed19b2ba3561df8799f836285dd7eb | The Joseph Rowntree Reform Trust Limited, York. (Registered 1 December 2008) | Sponsorship or financial or material support 9e46def6 | 2009-07-21 | Nicholas Clegg uk.org.publicwhip/member/1812 | Nick Clegg uk.org.publicwhip/person/11812 | 5 | 2009-07-21-9e46def6-11812-0 |
a5541ee9bd99b98b8a0572d7acf0157104e8214e | Mrs Estelle Goodwin, Wilmslow (personal donation). (Registered 29 June 2009) | Sponsorship or financial or material support 9e46def6 | 2009-07-21 | Nicholas Clegg uk.org.publicwhip/member/1812 | Nick Clegg uk.org.publicwhip/person/11812 | 6 | 2009-07-21-9e46def6-11812-0 |
80b97d404ffc5623240b200de770723c25b5a433 | Mr Christopher Bones, Oxford (personal donation) (Registered 29 June 2009) | Sponsorship or financial or material support 9e46def6 | 2009-07-21 | Nicholas Clegg uk.org.publicwhip/member/1812 | Nick Clegg uk.org.publicwhip/person/11812 | 7 | 2009-07-21-9e46def6-11812-0 |
c822ba4a0240b1a28d7bba6193bcc3acc4a21663 | Name of donor: John Howson, of Oxford | Sponsorship or financial or material support 9e46def6 | 2009-07-21 | Nicholas Clegg uk.org.publicwhip/member/1812 | Nick Clegg uk.org.publicwhip/person/11812 | 8 | 2009-07-21-9e46def6-11812-0 |
1155d52540de174f1eb1b904fb40ba56d05c7533 | Address of donor: private | Sponsorship or financial or material support 9e46def6 | 2009-07-21 | Nicholas Clegg uk.org.publicwhip/member/1812 | Nick Clegg uk.org.publicwhip/person/11812 | 9 | 2009-07-21-9e46def6-11812-0 |
a444e86824534b66398d8769908950d04c3f5fae | Amount of donation or nature and value if donation in kind: £10,000 | Sponsorship or financial or material support 9e46def6 | 2009-07-21 | Nicholas Clegg uk.org.publicwhip/member/1812 | Nick Clegg uk.org.publicwhip/person/11812 | 10 | 2009-07-21-9e46def6-11812-0 |
89d2f38870955daeeae505b672a9299cd1dcc5c0 | Date of receipt: 9 July 2009 | Sponsorship or financial or material support 9e46def6 | 2009-07-21 | Nicholas Clegg uk.org.publicwhip/member/1812 | Nick Clegg uk.org.publicwhip/person/11812 | 11 | 2009-07-21-9e46def6-11812-0 |
000a334e84adb36e3822315bedadc83c03b34ccf | Date of acceptance: 15 July | Sponsorship or financial or material support 9e46def6 | 2009-07-21 | Nicholas Clegg uk.org.publicwhip/member/1812 | Nick Clegg uk.org.publicwhip/person/11812 | 12 | 2009-07-21-9e46def6-11812-0 |
4348a840bafe7226384b93b7f93cc12d01dfa13c | Donor status: individual | Sponsorship or financial or material support 9e46def6 | 2009-07-21 | Nicholas Clegg uk.org.publicwhip/member/1812 | Nick Clegg uk.org.publicwhip/person/11812 | 13 | 2009-07-21-9e46def6-11812-0 |
60bf5a829d104b1f451238cd3600cedc3891fa8e | (Registered 15 July 2009) | Sponsorship or financial or material support 9e46def6 | 2009-07-21 | Nicholas Clegg uk.org.publicwhip/member/1812 | Nick Clegg uk.org.publicwhip/person/11812 | 14 | 2009-07-21-9e46def6-11812-0 |
43ae8c25c7fecfc38021e4bc9ef34c49ee5f9ca4 | 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-07-21 | Nicholas Clegg uk.org.publicwhip/member/1812 | Nick Clegg uk.org.publicwhip/person/11812 | 15 | 2009-07-21-9e46def6-11812-0 |
0ddab9f6da6d4f7552be0481419ad6f36d8c86ac | Mr Paul Clegg, Littleton (personal donation) | Sponsorship or financial or material support 9e46def6 | 2009-07-21 | Nicholas Clegg uk.org.publicwhip/member/1812 | Nick Clegg uk.org.publicwhip/person/11812 | 16 | 2009-07-21-9e46def6-11812-0 |
3f2d6bc72333418233e2812c5847cab8c7cda6c9 | Mr Hugh Facey, a constituent (personal donation) | Sponsorship or financial or material support 9e46def6 | 2009-07-21 | Nicholas Clegg uk.org.publicwhip/member/1812 | Nick Clegg uk.org.publicwhip/person/11812 | 17 | 2009-07-21-9e46def6-11812-0 |
b08966606686a76bbec85de2c4fd59f3b04717ca | Mr Duncan Greenland, London (personal donation) | Sponsorship or financial or material support 9e46def6 | 2009-07-21 | Nicholas Clegg uk.org.publicwhip/member/1812 | Nick Clegg uk.org.publicwhip/person/11812 | 18 | 2009-07-21-9e46def6-11812-0 |
021a3bba4b2f0442744c8fa78372fcd23ae53b55 | Mr James Tugendhat, London (personal donation) | Sponsorship or financial or material support 9e46def6 | 2009-07-21 | Nicholas Clegg uk.org.publicwhip/member/1812 | Nick Clegg uk.org.publicwhip/person/11812 | 19 | 2009-07-21-9e46def6-11812-0 |
368c8f1e83b89809397bc8d8a0c38ecad8ffb69e | Mr Tony Wilkinson, Mapleback (personal donation) | Sponsorship or financial or material support 9e46def6 | 2009-07-21 | Nicholas Clegg uk.org.publicwhip/member/1812 | Nick Clegg uk.org.publicwhip/person/11812 | 20 | 2009-07-21-9e46def6-11812-0 |
8528fea86a5df0feaa44358762964a2f3a07a8d2 | Mr Michael Young, London (personal donation) | Sponsorship or financial or material support 9e46def6 | 2009-07-21 | Nicholas Clegg uk.org.publicwhip/member/1812 | Nick Clegg uk.org.publicwhip/person/11812 | 21 | 2009-07-21-9e46def6-11812-0 |
b0925bbe93c73d84f033bd6e4acddd1b6983e4ae | Mr Peter Dunphy, London (personal donation) | Sponsorship or financial or material support 9e46def6 | 2009-07-21 | Nicholas Clegg uk.org.publicwhip/member/1812 | Nick Clegg uk.org.publicwhip/person/11812 | 22 | 2009-07-21-9e46def6-11812-0 |
6a11b78bc1d1e9ca55ece7b12e666e4720d75bb3 | The Sheffield Hallam Liberal Democrat party has received other donations from: | Sponsorship or financial or material support 9e46def6 | 2009-07-21 | Nicholas Clegg uk.org.publicwhip/member/1812 | Nick Clegg uk.org.publicwhip/person/11812 | 23 | 2009-07-21-9e46def6-11812-0 |
e280cce20f4aede4b0c192e4d5787c00e4304859 | Mr Nicholas P Clegg, Chinnor (personal donation) (Registered 1 December 2008) | Sponsorship or financial or material support 9e46def6 | 2009-07-21 | Nicholas Clegg uk.org.publicwhip/member/1812 | Nick Clegg uk.org.publicwhip/person/11812 | 24 | 2009-07-21-9e46def6-11812-0 |
38d829e9f7fe70cf47f4b66e1d67abd7f6b0570f | Mr Paul Clegg, Littleton (personal donation) (Registered 1 December 2008) | Sponsorship or financial or material support 9e46def6 | 2009-07-21 | Nicholas Clegg uk.org.publicwhip/member/1812 | Nick Clegg uk.org.publicwhip/person/11812 | 25 | 2009-07-21-9e46def6-11812-0 |
98e895f466f6691c29dce98b3b84a0299ca1a9f5 | 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-07-21 | Nicholas Clegg uk.org.publicwhip/member/1812 | Nick Clegg uk.org.publicwhip/person/11812 | 26 | 2009-07-21-9e46def6-11812-0 |
92ae8be6f9079b995b46f661f58f44c022e7595f | Electric Airwaves Limited, London, provided pro bono communications consultancy in 2008. (Registered 8 January 2009) | Sponsorship or financial or material support 9e46def6 | 2009-07-21 | Nicholas Clegg uk.org.publicwhip/member/1812 | Nick Clegg uk.org.publicwhip/person/11812 | 27 | 2009-07-21-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");