items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
26 rows where record_id = "2012-01-13-9e46def6-11923-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 |
---|---|---|---|---|---|---|---|
fd97c26ccad1d293b9732c06a6468505dffb08a2 | 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 | 2012-01-13 | Tim Farron uk.org.publicwhip/member/40656 | Tim Farron uk.org.publicwhip/person/11923 | 0 | 2012-01-13-9e46def6-11923-0 |
b6008eb4b12a52f2fd6230539c1e9c6e89b4a110 | Sponsorship or financial or material support 9e46def6 | 2012-01-13 | Tim Farron uk.org.publicwhip/member/40656 | Tim Farron uk.org.publicwhip/person/11923 | 1 | 2012-01-13-9e46def6-11923-0 | |
385fc47458bacc0b3a440a6a7b967d44039d23dc | Name of donor: William M Rayner | Sponsorship or financial or material support 9e46def6 | 2012-01-13 | Tim Farron uk.org.publicwhip/member/40656 | Tim Farron uk.org.publicwhip/person/11923 | 2 | 2012-01-13-9e46def6-11923-0 |
e00524c13c83f0fa2ff7dfa74ed712a5aa5464a5 | Address of donor: private | Sponsorship or financial or material support 9e46def6 | 2012-01-13 | Tim Farron uk.org.publicwhip/member/40656 | Tim Farron uk.org.publicwhip/person/11923 | 3 | 2012-01-13-9e46def6-11923-0 |
2b2b500d754208f3f0cce773c7dcd62c9b619283 | Amount of donation or nature and value if donation in kind: £10,000 | Sponsorship or financial or material support 9e46def6 | 2012-01-13 | Tim Farron uk.org.publicwhip/member/40656 | Tim Farron uk.org.publicwhip/person/11923 | 4 | 2012-01-13-9e46def6-11923-0 |
ff768cf678872ffcf45e4f8982dc9357fb8eb365 | Donor status: individual | Sponsorship or financial or material support 9e46def6 | 2012-01-13 | Tim Farron uk.org.publicwhip/member/40656 | Tim Farron uk.org.publicwhip/person/11923 | 5 | 2012-01-13-9e46def6-11923-0 |
72fb027e4fd18150f6bd4945d28da1d06ff895bd | (Registered 2 December 2010) | Sponsorship or financial or material support 9e46def6 | 2012-01-13 | Tim Farron uk.org.publicwhip/member/40656 | Tim Farron uk.org.publicwhip/person/11923 | 6 | 2012-01-13-9e46def6-11923-0 |
adabcaf0a2c925776517ace86a5f3809f352c482 | Name of donor: James Palumbo – Ministry of Sound | Sponsorship or financial or material support 9e46def6 | 2012-01-13 | Tim Farron uk.org.publicwhip/member/40656 | Tim Farron uk.org.publicwhip/person/11923 | 7 | 2012-01-13-9e46def6-11923-0 |
54871ce8fb4a5731bf497d2559c31f3b67a39350 | Address of donor: 103 Gaunt Street , London SE1 6DP | Sponsorship or financial or material support 9e46def6 | 2012-01-13 | Tim Farron uk.org.publicwhip/member/40656 | Tim Farron uk.org.publicwhip/person/11923 | 8 | 2012-01-13-9e46def6-11923-0 |
156934a3f7ffb91e2acf015d960d5e1af0d19a27 | Amount of donation or nature and value if donation in kind:£15,000 | Sponsorship or financial or material support 9e46def6 | 2012-01-13 | Tim Farron uk.org.publicwhip/member/40656 | Tim Farron uk.org.publicwhip/person/11923 | 9 | 2012-01-13-9e46def6-11923-0 |
72dd73423b325067ed220bd15304678bdae81c17 | Donor status: company | Sponsorship or financial or material support 9e46def6 | 2012-01-13 | Tim Farron uk.org.publicwhip/member/40656 | Tim Farron uk.org.publicwhip/person/11923 | 10 | 2012-01-13-9e46def6-11923-0 |
cb43e9bc5718e6f863607b2dd48c599705a0eda8 | (Registered 20 December 2011) | Sponsorship or financial or material support 9e46def6 | 2012-01-13 | Tim Farron uk.org.publicwhip/member/40656 | Tim Farron uk.org.publicwhip/person/11923 | 11 | 2012-01-13-9e46def6-11923-0 |
3a0e349533131c3ee761799b326e84f226ab3719 | Other support in the capacity as an MP: | Sponsorship or financial or material support 9e46def6 | 2012-01-13 | Tim Farron uk.org.publicwhip/member/40656 | Tim Farron uk.org.publicwhip/person/11923 | 12 | 2012-01-13-9e46def6-11923-0 |
c21ab49c3f6d9fc399395e4cfa7a4e5e0e804b37 | Name of donor: Joseph Rowntree Reform Trust | Sponsorship or financial or material support 9e46def6 | 2012-01-13 | Tim Farron uk.org.publicwhip/member/40656 | Tim Farron uk.org.publicwhip/person/11923 | 13 | 2012-01-13-9e46def6-11923-0 |
8b1974315ef2fe689cf34ecab29fa72980f6f93d | Address of donor: Garden House, Water End, York YO30 6WQ | Sponsorship or financial or material support 9e46def6 | 2012-01-13 | Tim Farron uk.org.publicwhip/member/40656 | Tim Farron uk.org.publicwhip/person/11923 | 14 | 2012-01-13-9e46def6-11923-0 |
00704370479f08b445c66ac605698dc659174df5 | Amount of donation or nature and value if donation in kind: £3,338 for work on a community politics project | Sponsorship or financial or material support 9e46def6 | 2012-01-13 | Tim Farron uk.org.publicwhip/member/40656 | Tim Farron uk.org.publicwhip/person/11923 | 15 | 2012-01-13-9e46def6-11923-0 |
9c9ebf81cfd4f1779b17adc139379363eed3d555 | Date of receipt: 25 August 2011 | Sponsorship or financial or material support 9e46def6 | 2012-01-13 | Tim Farron uk.org.publicwhip/member/40656 | Tim Farron uk.org.publicwhip/person/11923 | 16 | 2012-01-13-9e46def6-11923-0 |
f98fc7ed2964d7e1e5b372b23840b1397747b3d0 | Date of acceptance: 08 September 2011 | Sponsorship or financial or material support 9e46def6 | 2012-01-13 | Tim Farron uk.org.publicwhip/member/40656 | Tim Farron uk.org.publicwhip/person/11923 | 17 | 2012-01-13-9e46def6-11923-0 |
7e841be53d51d27999ef852c04106234c13e6b7e | Donor status: company, registration no 357963 | Sponsorship or financial or material support 9e46def6 | 2012-01-13 | Tim Farron uk.org.publicwhip/member/40656 | Tim Farron uk.org.publicwhip/person/11923 | 18 | 2012-01-13-9e46def6-11923-0 |
1d68e04405d4dce5dbd555b35a334602e799acda | Name of donor: CARE | Sponsorship or financial or material support 9e46def6 | 2012-01-13 | Tim Farron uk.org.publicwhip/member/40656 | Tim Farron uk.org.publicwhip/person/11923 | 20 | 2012-01-13-9e46def6-11923-0 |
f896b5f0083df9dcab35d578df5780050d5ea7d0 | Address of donor: 53 Romney Street, London SW1P 3RF. | Sponsorship or financial or material support 9e46def6 | 2012-01-13 | Tim Farron uk.org.publicwhip/member/40656 | Tim Farron uk.org.publicwhip/person/11923 | 21 | 2012-01-13-9e46def6-11923-0 |
fa32458341aaac528f2a66f7f41b25a5707d7940 | Amount of donation or nature and value if donation in kind: Four days a week voluntary service from October 2011 to July 2012 from a volunteer intern who is self funding except for the receipt of a bursary as a member of the educational leadership programme at the Christian charity CARE. | Sponsorship or financial or material support 9e46def6 | 2012-01-13 | Tim Farron uk.org.publicwhip/member/40656 | Tim Farron uk.org.publicwhip/person/11923 | 22 | 2012-01-13-9e46def6-11923-0 |
a28534886fc945c3523688fe33669f2604f44740 | Date of receipt: 26 September 2011 | Sponsorship or financial or material support 9e46def6 | 2012-01-13 | Tim Farron uk.org.publicwhip/member/40656 | Tim Farron uk.org.publicwhip/person/11923 | 23 | 2012-01-13-9e46def6-11923-0 |
7a9f62026767c8bcb766007cd10288b548500d4a | Date of acceptance: 26 September 2011 | Sponsorship or financial or material support 9e46def6 | 2012-01-13 | Tim Farron uk.org.publicwhip/member/40656 | Tim Farron uk.org.publicwhip/person/11923 | 24 | 2012-01-13-9e46def6-11923-0 |
475b64c75ba9ebe174309115d673df968beed441 | Donor status: company, registration no 3481417 | Sponsorship or financial or material support 9e46def6 | 2012-01-13 | Tim Farron uk.org.publicwhip/member/40656 | Tim Farron uk.org.publicwhip/person/11923 | 25 | 2012-01-13-9e46def6-11923-0 |
db25b717c0dbcfaa79d80f20ea4d55264312b18f | (Registered 14 October 2011) | Sponsorship or financial or material support 9e46def6 | 2012-01-13 | Tim Farron uk.org.publicwhip/member/40656 | Tim Farron uk.org.publicwhip/person/11923 | 26 | 2012-01-13-9e46def6-11923-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");