items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
49 rows where "date" is on date 2015-03-30 and person_id = "uk.org.publicwhip/person/24829" sorted by hash
This data as json, CSV (advanced)
Suggested facets: item, category_id, sort_order, record_id
hash ▼ | item | category_id | date | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
001436af38ad9ccd6fed25b687c84d04a05c8874 | (Registered 2 March 2015) | Sponsorships 8f616a6e | 2015-03-30 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 4 | 2015-03-30-8f616a6e-24829-9 |
03bda4a491dc64e29caa229eb1914037207e0a3f | Name of donor: Mr Ben Leadsom | Sponsorships 8f616a6e | 2015-03-30 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 0 | 2015-03-30-8f616a6e-24829-8 |
06d21389556a61cc7ebb45f21340dc3b5e1bf005 | Address of donor: private | Sponsorships 8f616a6e | 2015-03-30 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 1 | 2015-03-30-8f616a6e-24829-7 |
07b55863391f5a11d0dfa9d48720c7d6fc544f16 | (Registered 22 October 2014) | Sponsorships 8f616a6e | 2015-03-30 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 4 | 2015-03-30-8f616a6e-24829-5 |
0970631ca6041a542e53a8edfcc7488e90b73307 | Amount of donation or nature and value if donation in kind: £5,000 | Sponsorships 8f616a6e | 2015-03-30 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 2 | 2015-03-30-8f616a6e-24829-6 |
0fdfb636590d017e1b5506fec09190bf8d285399 | (Registered 22 October 2014) | Sponsorships 8f616a6e | 2015-03-30 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 4 | 2015-03-30-8f616a6e-24829-2 |
17962ea085104183899ae3c7d77a910c044f6e6f | Donor status: individual | Sponsorships 8f616a6e | 2015-03-30 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 3 | 2015-03-30-8f616a6e-24829-2 |
1fbcfc5893bea1d7b206d96001f848644af0b036 | Donations to my constituency party or association, which have been or will be reported by the party to the Electoral Commission: | Sponsorships 8f616a6e | 2015-03-30 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 0 | 2015-03-30-8f616a6e-24829-0 |
291d09b8ed9c5b74f6d56db8c1c493ce1d840cf8 | Donor status: company, registration 01611077 | Sponsorships 8f616a6e | 2015-03-30 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 3 | 2015-03-30-8f616a6e-24829-6 |
2c940b0bd33d852dadc5b29c2e21281411a89c4a | Amount of donation or nature and value if donation in kind: £2,000 | Sponsorships 8f616a6e | 2015-03-30 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 2 | 2015-03-30-8f616a6e-24829-9 |
40eb2dcfab6548f0317210bae4a9a0d0cdd92b60 | Donor status: company, registration 03595033 | Sponsorships 8f616a6e | 2015-03-30 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 3 | 2015-03-30-8f616a6e-24829-9 |
45402f28cefa0e4c598a1637191ff919fdfd19a8 | Name of donor: Trotter and Co Ltd | Sponsorships 8f616a6e | 2015-03-30 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 0 | 2015-03-30-8f616a6e-24829-9 |
4c9ef9b6d13a7e4a6c829938cae4eedff721e565 | (Registered 22 October 2014; updated 4 December 2014) | Sponsorships 8f616a6e | 2015-03-30 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 4 | 2015-03-30-8f616a6e-24829-1 |
544722153440c0d21bcf19d9a7aa864ebba203fb | Amount of donation or nature and value if donation in kind: £5,000 | Sponsorships 8f616a6e | 2015-03-30 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 2 | 2015-03-30-8f616a6e-24829-5 |
56d371e57afb0761d88c25f8be9ff670b92e2b68 | (Registered 12 February 2015) | Sponsorships 8f616a6e | 2015-03-30 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 4 | 2015-03-30-8f616a6e-24829-7 |
573091e507938abbd44c6cef8842e9e03868f614 | Until 1 July 2014, two properties in Oxford and a third in Surrey, owned by Bandal Ltd (see below) which receives rental and/or leasehold income (see Category 9 below). (Updated 3 July 2014) | Land and Property 4f1e6359 | 2015-03-30 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 0 | 2015-03-30-4f1e6359-24829-0 |
5b0db06ab5dac0b5320ff863fcbdf0ba521344ae | Address of donor: Willow Road, Brackley NN13 7EX | Sponsorships 8f616a6e | 2015-03-30 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 1 | 2015-03-30-8f616a6e-24829-6 |
5b9ed748e075caac9f3394ff3038dcfa251a826c | Amount of donation or nature and value if donation in kind: £1,638 in sponsoring a fundraising dinner for my re-election campaign, at which £2,500 was raised (including the registrable donation listed below). | Sponsorships 8f616a6e | 2015-03-30 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 2 | 2015-03-30-8f616a6e-24829-8 |
69cd5d371355acd9a40d50a4f9f6af4691f40f19 | Address of donor: private | Sponsorships 8f616a6e | 2015-03-30 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 1 | 2015-03-30-8f616a6e-24829-8 |
6c7844a63d76ffbcb31d9936c8120a689687ea61 | Name of donor: Mr and Mrs Byrom | Sponsorships 8f616a6e | 2015-03-30 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 0 | 2015-03-30-8f616a6e-24829-3 |
72dbfae645c14c2d532fe60c67354771f38eef1c | Donor status: individual | Sponsorships 8f616a6e | 2015-03-30 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 3 | 2015-03-30-8f616a6e-24829-3 |
73fe0ea3f20f758817ec3ccaed081edb12020f5a | (Registered 4 December 2014) | Sponsorships 8f616a6e | 2015-03-30 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 4 | 2015-03-30-8f616a6e-24829-6 |
7be269e1f2707d5b630cee9336e4cf211ec372ed | Name of donor: Rupert Fordham | Sponsorships 8f616a6e | 2015-03-30 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 0 | 2015-03-30-8f616a6e-24829-5 |
7e48f6caa47377814aafa6f24f9ca9076b2e311f | Donor status: individual | Sponsorships 8f616a6e | 2015-03-30 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 3 | 2015-03-30-8f616a6e-24829-8 |
7e4e34fa7257a5e5fef630e13e8d3b1c3de944cc | Address of donor: private | Sponsorships 8f616a6e | 2015-03-30 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 1 | 2015-03-30-8f616a6e-24829-1 |
8078b5e00b6f7aad53f7502c2f4a5640e4177a5e | Amount of donation or nature and value if donation in kind: £2,843 | Sponsorships 8f616a6e | 2015-03-30 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 2 | 2015-03-30-8f616a6e-24829-2 |
82e4b4c127475dfe59fbbafe878c469394756605 | Amount of donation or nature and value if donation in kind: £2,000 | Sponsorships 8f616a6e | 2015-03-30 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 2 | 2015-03-30-8f616a6e-24829-3 |
8c5399b920e340ca9841ff92a2fe1ebe878f8914 | Address of donor: private | Sponsorships 8f616a6e | 2015-03-30 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 1 | 2015-03-30-8f616a6e-24829-4 |
9c41a4afd2a1973ed7b3c281f38ec4f2bd575e6a | Donor status: private | Sponsorships 8f616a6e | 2015-03-30 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 3 | 2015-03-30-8f616a6e-24829-7 |
9fef9837eb18d5a272f5e100ada3d8159c0f24bd | Unremunerated Trustee of two charities, NorPIP (until September 2014) and PIPUK, both involved in promoting and delivering parent-infant psychotherapy . (Registered 16 October 2012; updated 8 July 2014 and 29 October 2014) | Miscellaneous 5f2cbd10 | 2015-03-30 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 0 | 2015-03-30-5f2cbd10-24829-0 |
a0658d201dfad9599477c872aab0e834cd30f4b8 | Address of donor: private | Sponsorships 8f616a6e | 2015-03-30 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 1 | 2015-03-30-8f616a6e-24829-3 |
a437b8f5b9ea773e877bcd90d27d2647928e4cbf | Amount of donation or nature and value if donation in kind: £5,000 | Sponsorships 8f616a6e | 2015-03-30 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 2 | 2015-03-30-8f616a6e-24829-4 |
a64a7ec95a5b95fb52444d485652ff2826ec1642 | (Registered 22 October 2014) | Sponsorships 8f616a6e | 2015-03-30 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 4 | 2015-03-30-8f616a6e-24829-4 |
b0d91687f2faf358434257fba43c666ebdfbdbbe | Address of donor: private | Sponsorships 8f616a6e | 2015-03-30 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 1 | 2015-03-30-8f616a6e-24829-2 |
b5ab086e8ea3758c7fbda2d50ca3d1e43e5c2f21 | Name of donor: Peter Warner | Sponsorships 8f616a6e | 2015-03-30 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 0 | 2015-03-30-8f616a6e-24829-2 |
b925c4718453826069a67b82a0c1807a2d21ab7d | Name of donor: David Adams | Sponsorships 8f616a6e | 2015-03-30 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 0 | 2015-03-30-8f616a6e-24829-7 |
c29b469fd7ad407810e73e1e9912f83a11ad9508 | Amount of donation or nature and value if donation in kind: £2,157 in hosting a fundraising dinner for my re-election campaign, at which £24,843 was raised (including the donations registered on 22 October and 4 December 2014 as listed below). | Sponsorships 8f616a6e | 2015-03-30 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 2 | 2015-03-30-8f616a6e-24829-1 |
c630c2cd9bd8568d4423a006d732ff4c60c53645 | Name of donor: Ben Leadsom | Sponsorships 8f616a6e | 2015-03-30 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 0 | 2015-03-30-8f616a6e-24829-4 |
c6a6cdf65bb789362146ada8644bf48ac565c88b | (Registered 27 February 2015; 2 March 2015) | Sponsorships 8f616a6e | 2015-03-30 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 4 | 2015-03-30-8f616a6e-24829-8 |
c8cd6a1666c9d3285caf36abb59c5fba4c817977 | Name of donor: Faccenda Foods Ltd | Sponsorships 8f616a6e | 2015-03-30 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 0 | 2015-03-30-8f616a6e-24829-6 |
d360e05524ad7bcb32486dd977f99bdb49c5d37b | Address of donor: private | Sponsorships 8f616a6e | 2015-03-30 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 1 | 2015-03-30-8f616a6e-24829-5 |
d916731f60cf2881990042a7e074e49c30da0843 | Donor status: individual | Sponsorships 8f616a6e | 2015-03-30 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 3 | 2015-03-30-8f616a6e-24829-1 |
d9591780796a44b075e570e962943bb9412ae169 | Name of donor: Peter Warner | Sponsorships 8f616a6e | 2015-03-30 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 0 | 2015-03-30-8f616a6e-24829-1 |
dae4c8e755a2b6a6434d261621e6c147d1aa61bc | (Registered 22 October 2014) | Sponsorships 8f616a6e | 2015-03-30 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 4 | 2015-03-30-8f616a6e-24829-3 |
e3b04c62bf5614900f1a1accf03689f6bec1bfbd | Address of donor: Field Burcote House, Duncote, Towcester NN12 8AH | Sponsorships 8f616a6e | 2015-03-30 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 1 | 2015-03-30-8f616a6e-24829-9 |
e85e773ac8b1e9caf432723ba08a406cabbe1ffe | Amount of donation or nature and value if donation in kind: £2,000 | Sponsorships 8f616a6e | 2015-03-30 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 2 | 2015-03-30-8f616a6e-24829-7 |
ed2f35848a93be3f73a8671aa1b0d1ade8b85efe | Donor status: individual | Sponsorships 8f616a6e | 2015-03-30 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 3 | 2015-03-30-8f616a6e-24829-5 |
f91e6c0fe77502c41d78b716788bb497a8e5ad75 | Until 1 July 2014, Bandal Ltd; company owned by me, my husband and a UK family trust, which owns three properties (see Category 8 above) (Updated 11 April 2014 and 3 July 2014) | Shareholdings 5b34324e | 2015-03-30 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 0 | 2015-03-30-5b34324e-24829-0 |
fafdd7e111b9b16b5776862a98074bdfefd9a2b5 | Donor status: individual | Sponsorships 8f616a6e | 2015-03-30 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 3 | 2015-03-30-8f616a6e-24829-4 |
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");