items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
15 rows where record_id = "2011-07-19-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 |
---|---|---|---|---|---|---|---|
3ec4cf5699ecaf11178b0209c76739195c1feee7 | 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-07-19 | Tim Farron uk.org.publicwhip/member/40656 | Tim Farron uk.org.publicwhip/person/11923 | 0 | 2011-07-19-9e46def6-11923-0 |
4fb5cfc62066db03ba5b45ebe3dfd329e531c0a7 | Sponsorship or financial or material support 9e46def6 | 2011-07-19 | Tim Farron uk.org.publicwhip/member/40656 | Tim Farron uk.org.publicwhip/person/11923 | 1 | 2011-07-19-9e46def6-11923-0 | |
529ee7e318daa080c4f6222dc63577a7e09db315 | Name of donor: William M Rayner | Sponsorship or financial or material support 9e46def6 | 2011-07-19 | Tim Farron uk.org.publicwhip/member/40656 | Tim Farron uk.org.publicwhip/person/11923 | 2 | 2011-07-19-9e46def6-11923-0 |
eb929034fce05393d2cbb1d7fe606bbcfeeba37c | Address of donor: private | Sponsorship or financial or material support 9e46def6 | 2011-07-19 | Tim Farron uk.org.publicwhip/member/40656 | Tim Farron uk.org.publicwhip/person/11923 | 3 | 2011-07-19-9e46def6-11923-0 |
9b5db8ecd4943fc5237d7ff60a49929a1c9cea3c | Amount of donation or nature and value if donation in kind: £10,000 | Sponsorship or financial or material support 9e46def6 | 2011-07-19 | Tim Farron uk.org.publicwhip/member/40656 | Tim Farron uk.org.publicwhip/person/11923 | 4 | 2011-07-19-9e46def6-11923-0 |
6a9fa12f3ccbadafbfef260f88e384c6a42f8ad0 | Donor status: individual | Sponsorship or financial or material support 9e46def6 | 2011-07-19 | Tim Farron uk.org.publicwhip/member/40656 | Tim Farron uk.org.publicwhip/person/11923 | 5 | 2011-07-19-9e46def6-11923-0 |
c94bd8e736ff6cec642deafd844b162070fc4404 | (Registered 2 December 2010) | Sponsorship or financial or material support 9e46def6 | 2011-07-19 | Tim Farron uk.org.publicwhip/member/40656 | Tim Farron uk.org.publicwhip/person/11923 | 6 | 2011-07-19-9e46def6-11923-0 |
75a544494b9cf1d4645910a12e155e38588ed24c | Support in the capacity as an MP: | Sponsorship or financial or material support 9e46def6 | 2011-07-19 | Tim Farron uk.org.publicwhip/member/40656 | Tim Farron uk.org.publicwhip/person/11923 | 7 | 2011-07-19-9e46def6-11923-0 |
cd4f31f374355a4b02e95d2c02f640bc26b6de75 | Name of donor: CARE (Christian Action, Research and Education) | Sponsorship or financial or material support 9e46def6 | 2011-07-19 | Tim Farron uk.org.publicwhip/member/40656 | Tim Farron uk.org.publicwhip/person/11923 | 8 | 2011-07-19-9e46def6-11923-0 |
002d3b246ed58ebead61a076ee4e931603fff723 | Address of donor: 53 Romney Street, London. | Sponsorship or financial or material support 9e46def6 | 2011-07-19 | Tim Farron uk.org.publicwhip/member/40656 | Tim Farron uk.org.publicwhip/person/11923 | 9 | 2011-07-19-9e46def6-11923-0 |
4f8166871180dfe719df6ba34cc8fe99fbbe6626 | Amount of donation or nature and value if donation in kind: £5,000. I had the services for four days a week of an intern sponsored by CARE. The intern left on 1 August 2010. | Sponsorship or financial or material support 9e46def6 | 2011-07-19 | Tim Farron uk.org.publicwhip/member/40656 | Tim Farron uk.org.publicwhip/person/11923 | 10 | 2011-07-19-9e46def6-11923-0 |
39c5b18cc400dd5ef9a9a41f848067a2516e8582 | Date of receipt: 24 August 2009 | Sponsorship or financial or material support 9e46def6 | 2011-07-19 | Tim Farron uk.org.publicwhip/member/40656 | Tim Farron uk.org.publicwhip/person/11923 | 11 | 2011-07-19-9e46def6-11923-0 |
ccdd9c43a72e261fbac1020c15dde7911dfecfca | Date of acceptance: 24 August 2009 | Sponsorship or financial or material support 9e46def6 | 2011-07-19 | Tim Farron uk.org.publicwhip/member/40656 | Tim Farron uk.org.publicwhip/person/11923 | 12 | 2011-07-19-9e46def6-11923-0 |
ee5bf678bdfc407958986918c685a64b8ba0f80a | Donor status: unincorporated association | Sponsorship or financial or material support 9e46def6 | 2011-07-19 | Tim Farron uk.org.publicwhip/member/40656 | Tim Farron uk.org.publicwhip/person/11923 | 13 | 2011-07-19-9e46def6-11923-0 |
facb2a761504b9282f90c0f265dab5279cd90aca | (Registered 28 July 2010) | Sponsorship or financial or material support 9e46def6 | 2011-07-19 | Tim Farron uk.org.publicwhip/member/40656 | Tim Farron uk.org.publicwhip/person/11923 | 14 | 2011-07-19-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");