items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
36 rows where record_id = "2011-03-14-8f616a6e-24829-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 |
---|---|---|---|---|---|---|---|
8e98f091516672eb21fce3971bddb0887a803a57 | Donations to my constituency party or association, which have been or will be reported by my party to the Electoral Commission: | Sponsorships 8f616a6e | 2011-03-14 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 0 | 2011-03-14-8f616a6e-24829-0 |
9d8842295879255683c42f06f61a9aaa4c395c82 | Name of donor: Rupert Fordham | Sponsorships 8f616a6e | 2011-03-14 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 1 | 2011-03-14-8f616a6e-24829-0 |
13e9591999cf22060cbac97ce6abcd0afd082104 | Amount of donation or nature and value if donation in kind: 2 donations; value £5,500 | Sponsorships 8f616a6e | 2011-03-14 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 3 | 2011-03-14-8f616a6e-24829-0 |
3b739485beca2b7dc2c82eb2974ae64105d0f1d9 | Name of donor: Mr P D Warner | Sponsorships 8f616a6e | 2011-03-14 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 6 | 2011-03-14-8f616a6e-24829-0 |
564b30f778cc3fef20f6088b90fa44f3812441b2 | Amount of donation or nature and value if donation in kind: £5,000 | Sponsorships 8f616a6e | 2011-03-14 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 8 | 2011-03-14-8f616a6e-24829-0 |
4991f881539c6bfbc360de39ae67d0b42c083026 | Name of donor: Sainty Hird & Partners; executive search | Sponsorships 8f616a6e | 2011-03-14 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 11 | 2011-03-14-8f616a6e-24829-0 |
212e426c4e9c36b2cbcc30de292fae40b5aac726 | Address of donor: 3 St James Square, London SW1Y 4JU | Sponsorships 8f616a6e | 2011-03-14 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 12 | 2011-03-14-8f616a6e-24829-0 |
d291c46f9b6cdaa69d4996b75f7d40acf61a3314 | Name of donor: Ilsley Holdings Ltd | Sponsorships 8f616a6e | 2011-03-14 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 16 | 2011-03-14-8f616a6e-24829-0 |
90904f596e229c62fe1f557764036b5783659aee | Address of donor: Phoenix Court, Bartholomew Street, Newbury, Berkshire RG14 5QA | Sponsorships 8f616a6e | 2011-03-14 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 17 | 2011-03-14-8f616a6e-24829-0 |
1371ffe01fa61fe3daabc4a9f7bcee5142875cf2 | Amount of donation or nature and value if donation in kind: £4,800 | Sponsorships 8f616a6e | 2011-03-14 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 18 | 2011-03-14-8f616a6e-24829-0 |
749e97ce99130d4ee32dc8002eafc53aa9bedcb3 | Name of donor: Trotter & Co Ltd; farming | Sponsorships 8f616a6e | 2011-03-14 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 21 | 2011-03-14-8f616a6e-24829-0 |
7f51ecd3ad38a2565ccc1ec8932e0e657dd6fed2 | Address of donor: Field Burcote House, Duncote, Towcester, Northants NN12 8AH | Sponsorships 8f616a6e | 2011-03-14 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 22 | 2011-03-14-8f616a6e-24829-0 |
7dafc2b9fdbf49dc72793468a01670eaac626213 | Donor status: company | Sponsorships 8f616a6e | 2011-03-14 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 24 | 2011-03-14-8f616a6e-24829-0 |
f65f3a13fd5381a23c9ad5248f08f6e683df2e46 | Name of donor: Corran (Wakefield) Limited; family estate | Sponsorships 8f616a6e | 2011-03-14 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 26 | 2011-03-14-8f616a6e-24829-0 |
16594ad5d31a369da10354bab56c1d4ecd2694a5 | Address of donor: Wakefield Lodge Estate, Potterspury, Towcester, Northants NN12 7QX | Sponsorships 8f616a6e | 2011-03-14 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 27 | 2011-03-14-8f616a6e-24829-0 |
51abc74def960f5219a610044f0228a8d03cd22d | Amount of donation or nature and value if donation in kind: £5,000 | Sponsorships 8f616a6e | 2011-03-14 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 28 | 2011-03-14-8f616a6e-24829-0 |
b601b565d5dad27f02703067a530f1863d4a4902 | Name of donor: DE Putron Fund Management Ltd; fund manager | Sponsorships 8f616a6e | 2011-03-14 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 31 | 2011-03-14-8f616a6e-24829-0 |
5d1da891d3cdb8f16f90041b70b3fae498da4443 | Name of donor: Gloucester Research Ltd; research | Sponsorships 8f616a6e | 2011-03-14 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 36 | 2011-03-14-8f616a6e-24829-0 |
9de5110e5853ef9fa64edc9454e44d23655e2244 | Address of donor: 5th Floor, Whittington House, 19-30 Alfred Place, London WC1E 7EA | Sponsorships 8f616a6e | 2011-03-14 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 37 | 2011-03-14-8f616a6e-24829-0 |
f817e454df01f9cf237212528e74ca9a2936a1b5 | Amount of donation or nature and value if donation in kind: £4,999 | Sponsorships 8f616a6e | 2011-03-14 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 38 | 2011-03-14-8f616a6e-24829-0 |
3bed0b6b5236172ff0f2af26959c097de60a4f45 | Donor status: company | Sponsorships 8f616a6e | 2011-03-14 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 39 | 2011-03-14-8f616a6e-24829-0 |
a4bef498c2c8871513b8612cd861f4a3afc709eb | Name of donor: Lady Vaughan | Sponsorships 8f616a6e | 2011-03-14 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 41 | 2011-03-14-8f616a6e-24829-0 |
203cf03161ce98e09405da3cf0816a4ca63b288b | Amount of donation or nature and value if donation in kind: 2 donations; total £2,000 | Sponsorships 8f616a6e | 2011-03-14 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 43 | 2011-03-14-8f616a6e-24829-0 |
f35f4bcfdd6cc207078770e0e6021c4e88c0eae7 | Name of donor: Cllr and Mrs J Byrom | Sponsorships 8f616a6e | 2011-03-14 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 46 | 2011-03-14-8f616a6e-24829-0 |
a9cb2d296f30c616694287d18e05fd46173b208c | Address of donor: private | Sponsorships 8f616a6e | 2011-03-14 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 47 | 2011-03-14-8f616a6e-24829-0 |
32a60092a6792f347d66b75ac00f8f62930adb21 | Amount of donation or nature and value if donation in kind: 2 donations; total £4,600 | Sponsorships 8f616a6e | 2011-03-14 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 48 | 2011-03-14-8f616a6e-24829-0 |
36e9f52c2ce8170b7e3c4e7cc08337480104a810 | Donor status: individual | Sponsorships 8f616a6e | 2011-03-14 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 49 | 2011-03-14-8f616a6e-24829-0 |
0f2c7e69dfdd32835a3f60fc61efaa4a79f91062 | (Registered 3 June 2010) | Sponsorships 8f616a6e | 2011-03-14 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 50 | 2011-03-14-8f616a6e-24829-0 |
b5ff6d0712bb121219051d453b87a21bba3a2336 | (b) Support in the capacity as an MP: | Sponsorships 8f616a6e | 2011-03-14 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 51 | 2011-03-14-8f616a6e-24829-0 |
561b20e78fc6df7b60335d6f9b18e285ed306413 | Name of donor: Gloucester Research Ltd | Sponsorships 8f616a6e | 2011-03-14 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 52 | 2011-03-14-8f616a6e-24829-0 |
e1578962416827865b36a72aa56abb18d523faf6 | Address of donor: Whittington House, 19-30 Alfred Place, London WC1E 7EA | Sponsorships 8f616a6e | 2011-03-14 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 53 | 2011-03-14-8f616a6e-24829-0 |
99841babc121bef50c9bd593700f544b1719bbce | Amount of donation or nature and value if donation in kind: donation of £6,500 to employ a member of staff in my Westminster office | Sponsorships 8f616a6e | 2011-03-14 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 54 | 2011-03-14-8f616a6e-24829-0 |
844085ae34d3d6f6b3cc7d8fadd04472e53aca52 | Date of receipt: 3 February 2011 | Sponsorships 8f616a6e | 2011-03-14 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 55 | 2011-03-14-8f616a6e-24829-0 |
69bccdb1ccc9f238a0104521b86ec30376c55117 | Date of acceptance: 3 February 2011 | Sponsorships 8f616a6e | 2011-03-14 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 56 | 2011-03-14-8f616a6e-24829-0 |
9ed6bc1a6f3eac49808ad8b1884e887a219478f8 | Donor status: company, registration 04267560 | Sponsorships 8f616a6e | 2011-03-14 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 57 | 2011-03-14-8f616a6e-24829-0 |
b3c7fc6407233fa573b21daa181f4698b03fca0b | (Registered 9 February 2011) | Sponsorships 8f616a6e | 2011-03-14 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 58 | 2011-03-14-8f616a6e-24829-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");