items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
25 rows where record_id = "2011-01-10-9e46def6-11812-0" sorted by hash
This data as json, CSV (advanced)
Suggested facets: date (date)
hash ▼ | item | category_id | date | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
0061312a2002d014a01695b05480ec9d7888cc5c | Amount of donation or nature and value if donation in kind: £1,000 per quarter as support for constituency office | Sponsorship or financial or material support 9e46def6 | 2011-01-10 | Nicholas Clegg uk.org.publicwhip/member/40528 | Nick Clegg uk.org.publicwhip/person/11812 | 8 | 2011-01-10-9e46def6-11812-0 |
0a9cde9ed09e271afc941f0175cb1249f251bad7 | Amount of donation or nature and value if donation in kind: £10,000 | Sponsorship or financial or material support 9e46def6 | 2011-01-10 | Nicholas Clegg uk.org.publicwhip/member/40528 | Nick Clegg uk.org.publicwhip/person/11812 | 36 | 2011-01-10-9e46def6-11812-0 |
151b0f6d1ae46a58a7c4b8414678796b9a25f0b8 | Amount of donation or nature and value if donation in kind: £2,500 | Sponsorship or financial or material support 9e46def6 | 2011-01-10 | Nicholas Clegg uk.org.publicwhip/member/40528 | Nick Clegg uk.org.publicwhip/person/11812 | 29 | 2011-01-10-9e46def6-11812-0 |
30036efa80db30549ab4fe27db6fe6d19367a59d | Date of acceptance: 29 March 2010 | Sponsorship or financial or material support 9e46def6 | 2011-01-10 | Nicholas Clegg uk.org.publicwhip/member/40528 | Nick Clegg uk.org.publicwhip/person/11812 | 24 | 2011-01-10-9e46def6-11812-0 |
4734b1bf8700361be2f3cc62d6d0982098d0f4f5 | Address of donor: 47 Spring Gardens, King Street, Manchester M2 2BG. | Sponsorship or financial or material support 9e46def6 | 2011-01-10 | Nicholas Clegg uk.org.publicwhip/member/40528 | Nick Clegg uk.org.publicwhip/person/11812 | 35 | 2011-01-10-9e46def6-11812-0 |
5f0c16d286a45b9c7cd17f2022e9cca8f0d22cf1 | Name of donor: Mr Duncan Greenland | Sponsorship or financial or material support 9e46def6 | 2011-01-10 | Nicholas Clegg uk.org.publicwhip/member/40528 | Nick Clegg uk.org.publicwhip/person/11812 | 6 | 2011-01-10-9e46def6-11812-0 |
671a07e4a950827c87abedc6071a169daffabb85 | (Registered 10 June 2010) | Sponsorship or financial or material support 9e46def6 | 2011-01-10 | Nicholas Clegg uk.org.publicwhip/member/40528 | Nick Clegg uk.org.publicwhip/person/11812 | 10 | 2011-01-10-9e46def6-11812-0 |
68e49aefb371ac03126a9d05a99b1426fc216708 | Donor status: company, registration number 02874245 | Sponsorship or financial or material support 9e46def6 | 2011-01-10 | Nicholas Clegg uk.org.publicwhip/member/40528 | Nick Clegg uk.org.publicwhip/person/11812 | 39 | 2011-01-10-9e46def6-11812-0 |
7b0bafa5a10150453fc8d9aa1b911adb6c32582e | Donor status: individual | Sponsorship or financial or material support 9e46def6 | 2011-01-10 | Nicholas Clegg uk.org.publicwhip/member/40528 | Nick Clegg uk.org.publicwhip/person/11812 | 4 | 2011-01-10-9e46def6-11812-0 |
7f5dbfd73c35e8bcebc0142bd2af13bf79ddc357 | Date of receipt: 26 March 2010 | Sponsorship or financial or material support 9e46def6 | 2011-01-10 | Nicholas Clegg uk.org.publicwhip/member/40528 | Nick Clegg uk.org.publicwhip/person/11812 | 23 | 2011-01-10-9e46def6-11812-0 |
bfa22cc6efbecc31ed3e03582d6ece0d72ecfe18 | Date of receipt: 10 March 2010 | Sponsorship or financial or material support 9e46def6 | 2011-01-10 | Nicholas Clegg uk.org.publicwhip/member/40528 | Nick Clegg uk.org.publicwhip/person/11812 | 37 | 2011-01-10-9e46def6-11812-0 |
c0d5154bd5702dc8bc5e55989dd6f067865119fd | Donor status: individual | Sponsorship or financial or material support 9e46def6 | 2011-01-10 | Nicholas Clegg uk.org.publicwhip/member/40528 | Nick Clegg uk.org.publicwhip/person/11812 | 32 | 2011-01-10-9e46def6-11812-0 |
c11750392c584f2130352fc5a192f943e7edfd18 | Address of donor: private | Sponsorship or financial or material support 9e46def6 | 2011-01-10 | Nicholas Clegg uk.org.publicwhip/member/40528 | Nick Clegg uk.org.publicwhip/person/11812 | 28 | 2011-01-10-9e46def6-11812-0 |
c1ed630619f8af744608c2121e384b10e8958a1b | Name of donor: Hervia Limited | Sponsorship or financial or material support 9e46def6 | 2011-01-10 | Nicholas Clegg uk.org.publicwhip/member/40528 | Nick Clegg uk.org.publicwhip/person/11812 | 34 | 2011-01-10-9e46def6-11812-0 |
d145b79a8c0281c8a514099022c85921736545d0 | Name of donor: Mr Hugh Facey | Sponsorship or financial or material support 9e46def6 | 2011-01-10 | Nicholas Clegg uk.org.publicwhip/member/40528 | Nick Clegg uk.org.publicwhip/person/11812 | 1 | 2011-01-10-9e46def6-11812-0 |
d9fae9cb19f9b11804d26bd7d91081709aa455f2 | (b) Support in the capacity as an MP: | Sponsorship or financial or material support 9e46def6 | 2011-01-10 | Nicholas Clegg uk.org.publicwhip/member/40528 | Nick Clegg uk.org.publicwhip/person/11812 | 11 | 2011-01-10-9e46def6-11812-0 |
dd91f2f80ff755343d45fed2e400151adeddc864 | Amount of donation or nature and value if donation in kind: £2,263.50 (donation in kind; election tour goods). | Sponsorship or financial or material support 9e46def6 | 2011-01-10 | Nicholas Clegg uk.org.publicwhip/member/40528 | Nick Clegg uk.org.publicwhip/person/11812 | 22 | 2011-01-10-9e46def6-11812-0 |
e4ead2047869cb6c643be025da6360a8ea07da57 | (Registered 8 April 2010) | Sponsorship or financial or material support 9e46def6 | 2011-01-10 | Nicholas Clegg uk.org.publicwhip/member/40528 | Nick Clegg uk.org.publicwhip/person/11812 | 40 | 2011-01-10-9e46def6-11812-0 |
e5624ebaa0336879b41b58bf30f6fda38ab74852 | Donations to my constituency party or association, which have been or will be reported by my party to the Electoral Commission: | Sponsorship or financial or material support 9e46def6 | 2011-01-10 | Nicholas Clegg uk.org.publicwhip/member/40528 | Nick Clegg uk.org.publicwhip/person/11812 | 0 | 2011-01-10-9e46def6-11812-0 |
ec1d84d34bf174a4e6d331033ece0d21be1251eb | 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 | 2011-01-10 | Nicholas Clegg uk.org.publicwhip/member/40528 | Nick Clegg uk.org.publicwhip/person/11812 | 12 | 2011-01-10-9e46def6-11812-0 |
ec83afe64ad0778407bbbcdd2d284b2b0863e921 | Name of donor: Mr Oscar Pinto-Hervia | Sponsorship or financial or material support 9e46def6 | 2011-01-10 | Nicholas Clegg uk.org.publicwhip/member/40528 | Nick Clegg uk.org.publicwhip/person/11812 | 27 | 2011-01-10-9e46def6-11812-0 |
ed265f10ad1a12a23f614dca298d40d5451c9d2f | Name of donor: Mr Richard Duncalf | Sponsorship or financial or material support 9e46def6 | 2011-01-10 | Nicholas Clegg uk.org.publicwhip/member/40528 | Nick Clegg uk.org.publicwhip/person/11812 | 20 | 2011-01-10-9e46def6-11812-0 |
f636fabb0f6a66e7f033c92c71f94a02d26f3cd9 | Amount of donation or nature and value if donation in kind: £2,500, plus £100 per month as support for constituency office. | Sponsorship or financial or material support 9e46def6 | 2011-01-10 | Nicholas Clegg uk.org.publicwhip/member/40528 | Nick Clegg uk.org.publicwhip/person/11812 | 3 | 2011-01-10-9e46def6-11812-0 |
f8ba1e040d254dc05f5da1a4e6ba0d726757a41a | Address of donor: private | Sponsorship or financial or material support 9e46def6 | 2011-01-10 | Nicholas Clegg uk.org.publicwhip/member/40528 | Nick Clegg uk.org.publicwhip/person/11812 | 2 | 2011-01-10-9e46def6-11812-0 |
ffb41577a64da8471c7067c3fd809e0145a9cc07 | Date of acceptance: 11 March 2010 | Sponsorship or financial or material support 9e46def6 | 2011-01-10 | Nicholas Clegg uk.org.publicwhip/member/40528 | Nick Clegg uk.org.publicwhip/person/11812 | 38 | 2011-01-10-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");