items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
27 rows where "date" is on date 2015-02-09 and member_id = "uk.org.publicwhip/member/40665" sorted by date descending
This data as json, CSV (advanced)
Suggested facets: item, category_id, sort_order, record_id, date (date)
hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
2f3b74000b584cab4e88d2e5f5000cc6a344e77d | Donations to my constituency party or association, which have been or will be reported by the party to the Electoral Commission: | Sponsorships 8f616a6e | 2015-02-09 | David Cameron uk.org.publicwhip/member/40665 | David Cameron uk.org.publicwhip/person/10777 | 0 | 2015-02-09-8f616a6e-10777-0 |
b08fde1f06508e93936b9fb1ca3634a0b86eed66 | Name of donor: Mrs Marjorie Glasgow | Sponsorships 8f616a6e | 2015-02-09 | David Cameron uk.org.publicwhip/member/40665 | David Cameron uk.org.publicwhip/person/10777 | 0 | 2015-02-09-8f616a6e-10777-1 |
d18679231722ec99a3d744033f8b39e46f19eaae | Address of donor: private | Sponsorships 8f616a6e | 2015-02-09 | David Cameron uk.org.publicwhip/member/40665 | David Cameron uk.org.publicwhip/person/10777 | 1 | 2015-02-09-8f616a6e-10777-1 |
d0e89cc921ec0125114125be2ea2020c2dac1624 | Amount of donation or nature and value if donation in kind: £5,000 | Sponsorships 8f616a6e | 2015-02-09 | David Cameron uk.org.publicwhip/member/40665 | David Cameron uk.org.publicwhip/person/10777 | 2 | 2015-02-09-8f616a6e-10777-1 |
94353eba2b5f5c1d1539db9025361a8fa5a73f71 | Donor status: individual | Sponsorships 8f616a6e | 2015-02-09 | David Cameron uk.org.publicwhip/member/40665 | David Cameron uk.org.publicwhip/person/10777 | 3 | 2015-02-09-8f616a6e-10777-1 |
b27d068af44c3453d93cebeab2d4ff414abc9a32 | (Registered 23 December 2014) | Sponsorships 8f616a6e | 2015-02-09 | David Cameron uk.org.publicwhip/member/40665 | David Cameron uk.org.publicwhip/person/10777 | 4 | 2015-02-09-8f616a6e-10777-1 |
dc121daf17bf15492a950207212693db7cfb2dbf | Name of donor: Original BTC Ltd | Sponsorships 8f616a6e | 2015-02-09 | David Cameron uk.org.publicwhip/member/40665 | David Cameron uk.org.publicwhip/person/10777 | 0 | 2015-02-09-8f616a6e-10777-2 |
4c320fe16f62312a81ba1e9cfc2a031c6f425e15 | Address of donor: Units 21/22, Avenue One, Station Lane, Witney OX28 4XZ | Sponsorships 8f616a6e | 2015-02-09 | David Cameron uk.org.publicwhip/member/40665 | David Cameron uk.org.publicwhip/person/10777 | 1 | 2015-02-09-8f616a6e-10777-2 |
c38c6e959c8661ee5333e00779b7da991ea024ed | Amount of donation or nature and value if donation in kind: £2,500 | Sponsorships 8f616a6e | 2015-02-09 | David Cameron uk.org.publicwhip/member/40665 | David Cameron uk.org.publicwhip/person/10777 | 2 | 2015-02-09-8f616a6e-10777-2 |
283edea4fcbcc02ca798b7a8fa8b2e0da538531c | Donor status: company, registration 03650223 | Sponsorships 8f616a6e | 2015-02-09 | David Cameron uk.org.publicwhip/member/40665 | David Cameron uk.org.publicwhip/person/10777 | 3 | 2015-02-09-8f616a6e-10777-2 |
dcae384a907b22f23208257b4f35781d1af06ff6 | (Registered 23 December 2014) | Sponsorships 8f616a6e | 2015-02-09 | David Cameron uk.org.publicwhip/member/40665 | David Cameron uk.org.publicwhip/person/10777 | 4 | 2015-02-09-8f616a6e-10777-2 |
49e6939c4722c4cfe6f81dddfb968b94cc228b2c | In my capacity as Leader of the Conservative Party, I have accepted Honorary Membership for life of the Carlton Club. | Gifts, benefits and hospitality (UK) 84642823 | 2015-02-09 | David Cameron uk.org.publicwhip/member/40665 | David Cameron uk.org.publicwhip/person/10777 | 0 | 2015-02-09-84642823-10777-0 |
970f8bb14fdb1f1e114bf6ef8cb12035df00c638 | Name of donor: Ellesborough Golf Club | Gifts, benefits and hospitality (UK) 84642823 | 2015-02-09 | David Cameron uk.org.publicwhip/member/40665 | David Cameron uk.org.publicwhip/person/10777 | 0 | 2015-02-09-84642823-10777-1 |
b55f16e930fee4a33986ff5f7cd4e30f1e6c7216 | Address of donor: Butlers Cross, Aylesbury, Buckinghamshire HP17 OTZ | Gifts, benefits and hospitality (UK) 84642823 | 2015-02-09 | David Cameron uk.org.publicwhip/member/40665 | David Cameron uk.org.publicwhip/person/10777 | 1 | 2015-02-09-84642823-10777-1 |
b1cc6709de21bb78ff1e69da7ae923adc174b439 | Amount of donation or nature and value if donation in kind: honorary membership of Ellesborough Golf Club; value £1,142 p. a. | Gifts, benefits and hospitality (UK) 84642823 | 2015-02-09 | David Cameron uk.org.publicwhip/member/40665 | David Cameron uk.org.publicwhip/person/10777 | 2 | 2015-02-09-84642823-10777-1 |
e0ab728e57715396f03c2bdcb4c8e0cd74b0b468 | Date of receipt of donation: June 2011; renewed annually | Gifts, benefits and hospitality (UK) 84642823 | 2015-02-09 | David Cameron uk.org.publicwhip/member/40665 | David Cameron uk.org.publicwhip/person/10777 | 3 | 2015-02-09-84642823-10777-1 |
1611966a20d45f4141211e431ec50f1b43ed693d | Date of acceptance of donation: 9 June 2011 | Gifts, benefits and hospitality (UK) 84642823 | 2015-02-09 | David Cameron uk.org.publicwhip/member/40665 | David Cameron uk.org.publicwhip/person/10777 | 4 | 2015-02-09-84642823-10777-1 |
abe2987d0dc4c39b52cacaf42bc1230daaea309b | Donor status: unincorporated association | Gifts, benefits and hospitality (UK) 84642823 | 2015-02-09 | David Cameron uk.org.publicwhip/member/40665 | David Cameron uk.org.publicwhip/person/10777 | 5 | 2015-02-09-84642823-10777-1 |
8932a1aa594ed47c06425aeba28d12a390d03a62 | (Registered 15 February 2012; updated 4 February 2013 and 21 November 2014) | Gifts, benefits and hospitality (UK) 84642823 | 2015-02-09 | David Cameron uk.org.publicwhip/member/40665 | David Cameron uk.org.publicwhip/person/10777 | 6 | 2015-02-09-84642823-10777-1 |
19bb56985d148ccdd3d71d2318fe9d9ee44176c4 | Name of donor: Original BTC Ltd | Gifts, benefits and hospitality (UK) 84642823 | 2015-02-09 | David Cameron uk.org.publicwhip/member/40665 | David Cameron uk.org.publicwhip/person/10777 | 0 | 2015-02-09-84642823-10777-2 |
ed816edbd4e74a6417d1e31604a48c5b3d57921b | Address of donor: Units 21/22, Avenue One, Station Lane, Witney OX28 4XZ | Gifts, benefits and hospitality (UK) 84642823 | 2015-02-09 | David Cameron uk.org.publicwhip/member/40665 | David Cameron uk.org.publicwhip/person/10777 | 1 | 2015-02-09-84642823-10777-2 |
26e4cd842e2d67e539cfda5a5f98ac88446abed4 | Amount of donation or nature and value if donation in kind: two lamps, total value £749 | Gifts, benefits and hospitality (UK) 84642823 | 2015-02-09 | David Cameron uk.org.publicwhip/member/40665 | David Cameron uk.org.publicwhip/person/10777 | 2 | 2015-02-09-84642823-10777-2 |
f25771a0f039e2f5beed59aa76d0154ac6edb807 | Date of receipt of donation: 10 October 2014 | Gifts, benefits and hospitality (UK) 84642823 | 2015-02-09 | David Cameron uk.org.publicwhip/member/40665 | David Cameron uk.org.publicwhip/person/10777 | 3 | 2015-02-09-84642823-10777-2 |
56b40b2b0f920d61897594aba6046db61eba286a | Date of acceptance of donation: 10 October 2014 | Gifts, benefits and hospitality (UK) 84642823 | 2015-02-09 | David Cameron uk.org.publicwhip/member/40665 | David Cameron uk.org.publicwhip/person/10777 | 4 | 2015-02-09-84642823-10777-2 |
b2df14b8d77b38c7498272fecc9db7a4344e2af0 | Donor status: company, registration 3650223 | Gifts, benefits and hospitality (UK) 84642823 | 2015-02-09 | David Cameron uk.org.publicwhip/member/40665 | David Cameron uk.org.publicwhip/person/10777 | 5 | 2015-02-09-84642823-10777-2 |
83ac344ba2200dbbc52c0426032f08d70546916d | (Registered 6 November 2014) | Gifts, benefits and hospitality (UK) 84642823 | 2015-02-09 | David Cameron uk.org.publicwhip/member/40665 | David Cameron uk.org.publicwhip/person/10777 | 6 | 2015-02-09-84642823-10777-2 |
e786a879bd69de05d2653c3a969beb53c58ff462 | Residential property in London, from which rental income is received. | Land and Property 4f1e6359 | 2015-02-09 | David Cameron uk.org.publicwhip/member/40665 | David Cameron uk.org.publicwhip/person/10777 | 0 | 2015-02-09-4f1e6359-10777-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");