items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
28 rows where record_id = "2012-09-03-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 |
---|---|---|---|---|---|---|---|
4900b0823d5d8dbbffb948dd77cd15a1e6d135e4 | 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-09-03 | Tim Farron uk.org.publicwhip/member/40656 | Tim Farron uk.org.publicwhip/person/11923 | 0 | 2012-09-03-9e46def6-11923-0 |
93f93e8d60d036c4acc63547902f920e518096f4 | Sponsorship or financial or material support 9e46def6 | 2012-09-03 | Tim Farron uk.org.publicwhip/member/40656 | Tim Farron uk.org.publicwhip/person/11923 | 1 | 2012-09-03-9e46def6-11923-0 | |
f3e3c03270936ceeaef8386fe9c556462d459c4c | Name of donor: James Palumbo – Ministry of Sound | Sponsorship or financial or material support 9e46def6 | 2012-09-03 | Tim Farron uk.org.publicwhip/member/40656 | Tim Farron uk.org.publicwhip/person/11923 | 2 | 2012-09-03-9e46def6-11923-0 |
a250a99ed5220ae582077ec7bd269e6e90123c54 | Amount of donation or nature and value if donation in kind:£15,000 | Sponsorship or financial or material support 9e46def6 | 2012-09-03 | Tim Farron uk.org.publicwhip/member/40656 | Tim Farron uk.org.publicwhip/person/11923 | 4 | 2012-09-03-9e46def6-11923-0 |
3ec72230a361c2cec292c161f8023d6222e9211c | (Registered 20 December 2011) | Sponsorship or financial or material support 9e46def6 | 2012-09-03 | Tim Farron uk.org.publicwhip/member/40656 | Tim Farron uk.org.publicwhip/person/11923 | 6 | 2012-09-03-9e46def6-11923-0 |
7c8133d576b598696f7a975367d0a5a13cf1f177 | Name of donor: Ministry of Sound | Sponsorship or financial or material support 9e46def6 | 2012-09-03 | Tim Farron uk.org.publicwhip/member/40656 | Tim Farron uk.org.publicwhip/person/11923 | 7 | 2012-09-03-9e46def6-11923-0 |
6af3edccc30d56c6faec987c21f84d68816f797a | Address of donor: 103 Gaunt Street , London SE1 6DP | Sponsorship or financial or material support 9e46def6 | 2012-09-03 | Tim Farron uk.org.publicwhip/member/40656 | Tim Farron uk.org.publicwhip/person/11923 | 8 | 2012-09-03-9e46def6-11923-0 |
51bc8ead226f02fd3a163af02c6032da0d290339 | Amount of donation or nature and value if donation in kind: £20,000 | Sponsorship or financial or material support 9e46def6 | 2012-09-03 | Tim Farron uk.org.publicwhip/member/40656 | Tim Farron uk.org.publicwhip/person/11923 | 9 | 2012-09-03-9e46def6-11923-0 |
e77b04ef813dcd52ae1d96620708896aedec1a00 | Donor status: company | Sponsorship or financial or material support 9e46def6 | 2012-09-03 | Tim Farron uk.org.publicwhip/member/40656 | Tim Farron uk.org.publicwhip/person/11923 | 10 | 2012-09-03-9e46def6-11923-0 |
36e2152891855ec0115ebbf76616606f4531ac33 | Name of donor: Peter Dunphy | Sponsorship or financial or material support 9e46def6 | 2012-09-03 | Tim Farron uk.org.publicwhip/member/40656 | Tim Farron uk.org.publicwhip/person/11923 | 12 | 2012-09-03-9e46def6-11923-0 |
6fbc4570b128b2fab8503a031a2ef7b3d12561d0 | Address of donor: individual | Sponsorship or financial or material support 9e46def6 | 2012-09-03 | Tim Farron uk.org.publicwhip/member/40656 | Tim Farron uk.org.publicwhip/person/11923 | 13 | 2012-09-03-9e46def6-11923-0 |
7169d022ead85fed973b992eb9c06e67b403b5e5 | Amount of donation or nature and value if donation in kind: £5,000 | Sponsorship or financial or material support 9e46def6 | 2012-09-03 | Tim Farron uk.org.publicwhip/member/40656 | Tim Farron uk.org.publicwhip/person/11923 | 14 | 2012-09-03-9e46def6-11923-0 |
2b1f85b6951abe309497d2d4bbe171c00c0d4add | Donor status: individual | Sponsorship or financial or material support 9e46def6 | 2012-09-03 | Tim Farron uk.org.publicwhip/member/40656 | Tim Farron uk.org.publicwhip/person/11923 | 15 | 2012-09-03-9e46def6-11923-0 |
0a2236c29c49f5da4817eaecb6570d453784db28 | (Registered 10 July 2012) | Sponsorship or financial or material support 9e46def6 | 2012-09-03 | Tim Farron uk.org.publicwhip/member/40656 | Tim Farron uk.org.publicwhip/person/11923 | 16 | 2012-09-03-9e46def6-11923-0 |
002096c8a6f154de47b98994f9a86101d0abc8b4 | Other support in the capacity as an MP: | Sponsorship or financial or material support 9e46def6 | 2012-09-03 | Tim Farron uk.org.publicwhip/member/40656 | Tim Farron uk.org.publicwhip/person/11923 | 17 | 2012-09-03-9e46def6-11923-0 |
d9e56729c333df7c8a7819516d96cdbb60f0f72a | Name of donor: Joseph Rowntree Reform Trust | Sponsorship or financial or material support 9e46def6 | 2012-09-03 | Tim Farron uk.org.publicwhip/member/40656 | Tim Farron uk.org.publicwhip/person/11923 | 18 | 2012-09-03-9e46def6-11923-0 |
51bad04746d8cb0d56a3d654522418907fdbc16f | Address of donor: Garden House, Water End, York YO30 6WQ | Sponsorship or financial or material support 9e46def6 | 2012-09-03 | Tim Farron uk.org.publicwhip/member/40656 | Tim Farron uk.org.publicwhip/person/11923 | 19 | 2012-09-03-9e46def6-11923-0 |
2b8c8dc4ecb33911c5ecb407efaa00dc0757beed | 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-09-03 | Tim Farron uk.org.publicwhip/member/40656 | Tim Farron uk.org.publicwhip/person/11923 | 20 | 2012-09-03-9e46def6-11923-0 |
4016018cfe5a14dc151e9b52b4cca70f251b000e | Date of receipt: 25 August 2011 | Sponsorship or financial or material support 9e46def6 | 2012-09-03 | Tim Farron uk.org.publicwhip/member/40656 | Tim Farron uk.org.publicwhip/person/11923 | 21 | 2012-09-03-9e46def6-11923-0 |
282004bb64ff454a16be11d6d3c84a31c1f95f7d | Date of acceptance: 08 September 2011 | Sponsorship or financial or material support 9e46def6 | 2012-09-03 | Tim Farron uk.org.publicwhip/member/40656 | Tim Farron uk.org.publicwhip/person/11923 | 22 | 2012-09-03-9e46def6-11923-0 |
87decc80d71551107429586bd72b4f97c20f595b | Donor status: company, registration no 357963 | Sponsorship or financial or material support 9e46def6 | 2012-09-03 | Tim Farron uk.org.publicwhip/member/40656 | Tim Farron uk.org.publicwhip/person/11923 | 23 | 2012-09-03-9e46def6-11923-0 |
bf7ec2606f4fbd44b85e24b8283ff8ed2585767c | Name of donor: CARE | Sponsorship or financial or material support 9e46def6 | 2012-09-03 | Tim Farron uk.org.publicwhip/member/40656 | Tim Farron uk.org.publicwhip/person/11923 | 25 | 2012-09-03-9e46def6-11923-0 |
b68e5b0237fa2fa9b47f14ba035a7f3df15d2b7b | Address of donor: 53 Romney Street, London SW1P 3RF. | Sponsorship or financial or material support 9e46def6 | 2012-09-03 | Tim Farron uk.org.publicwhip/member/40656 | Tim Farron uk.org.publicwhip/person/11923 | 26 | 2012-09-03-9e46def6-11923-0 |
ed0a24f792226de5e363306613d0ad32c2f2f763 | 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-09-03 | Tim Farron uk.org.publicwhip/member/40656 | Tim Farron uk.org.publicwhip/person/11923 | 27 | 2012-09-03-9e46def6-11923-0 |
9f6bcdb8aae821a4061a5c65c51531a24aa2f442 | Date of receipt: 26 September 2011 | Sponsorship or financial or material support 9e46def6 | 2012-09-03 | Tim Farron uk.org.publicwhip/member/40656 | Tim Farron uk.org.publicwhip/person/11923 | 28 | 2012-09-03-9e46def6-11923-0 |
9d14de96bac87cff9986c1ad248b716f0c42c174 | Date of acceptance: 26 September 2011 | Sponsorship or financial or material support 9e46def6 | 2012-09-03 | Tim Farron uk.org.publicwhip/member/40656 | Tim Farron uk.org.publicwhip/person/11923 | 29 | 2012-09-03-9e46def6-11923-0 |
030348a1e3df602df0049c51e321077b74282cd8 | Donor status: company, registration no 3481417 | Sponsorship or financial or material support 9e46def6 | 2012-09-03 | Tim Farron uk.org.publicwhip/member/40656 | Tim Farron uk.org.publicwhip/person/11923 | 30 | 2012-09-03-9e46def6-11923-0 |
314dc4837758568339bcd88e8314eb62883193d8 | (Registered 14 October 2011) | Sponsorship or financial or material support 9e46def6 | 2012-09-03 | Tim Farron uk.org.publicwhip/member/40656 | Tim Farron uk.org.publicwhip/person/11923 | 31 | 2012-09-03-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");