items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
28 rows where record_id = "2010-12-20-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 |
---|---|---|---|---|---|---|---|
552a3d2dab393946a3fd43792dddf9acae146760 | Donations to my constituency party or association, which have been or will be reported by my party to the Electoral Commission: | Sponsorships 8f616a6e | 2010-12-20 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 0 | 2010-12-20-8f616a6e-24829-0 |
2065d47932bbc8942f3850f4cc9ac911fda7c4f3 | Name of donor: Rupert Fordham | Sponsorships 8f616a6e | 2010-12-20 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 1 | 2010-12-20-8f616a6e-24829-0 |
bf34a8dcf6f179746391de21d097b9212e6f68c0 | Amount of donation or nature and value if donation in kind: 2 donations; value £5,500 | Sponsorships 8f616a6e | 2010-12-20 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 3 | 2010-12-20-8f616a6e-24829-0 |
b3c9791f167f69f5424f7c6181baca7d6ee4f53c | Name of donor: Mr P D Warner | Sponsorships 8f616a6e | 2010-12-20 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 6 | 2010-12-20-8f616a6e-24829-0 |
e30419c969a904863cd681822e959a0117f469e7 | Amount of donation or nature and value if donation in kind: £5,000 | Sponsorships 8f616a6e | 2010-12-20 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 8 | 2010-12-20-8f616a6e-24829-0 |
5a9069627b2fd43507999940d5d8d04c26a1b4c9 | Name of donor: Sainty Hird & Partners; executive search | Sponsorships 8f616a6e | 2010-12-20 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 11 | 2010-12-20-8f616a6e-24829-0 |
6340f18d700296728e391002bbc5a7220eb088e6 | Address of donor: 3 St James Square, London SW1Y 4JU | Sponsorships 8f616a6e | 2010-12-20 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 12 | 2010-12-20-8f616a6e-24829-0 |
f78d9331047d119da052e2cec1da60af0bc318b2 | Name of donor: Ilsley Holdings Ltd | Sponsorships 8f616a6e | 2010-12-20 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 16 | 2010-12-20-8f616a6e-24829-0 |
0a489c569847444835824940781adae892c31aa7 | Address of donor: Phoenix Court, Bartholomew Street, Newbury, Berkshire RG14 5QA | Sponsorships 8f616a6e | 2010-12-20 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 17 | 2010-12-20-8f616a6e-24829-0 |
3d99d850f262e06733a30cb3b640b4dad04e3ae1 | Amount of donation or nature and value if donation in kind: £4,800 | Sponsorships 8f616a6e | 2010-12-20 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 18 | 2010-12-20-8f616a6e-24829-0 |
511da7b82934d4a0fe36fe26263f39193996f2dc | Name of donor: Trotter & Co Ltd; farming | Sponsorships 8f616a6e | 2010-12-20 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 21 | 2010-12-20-8f616a6e-24829-0 |
d7ef981d9326def0338349d3048af6ebee97bd9a | Address of donor: Field Burcote House, Duncote, Towcester, Northants NN12 8AH | Sponsorships 8f616a6e | 2010-12-20 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 22 | 2010-12-20-8f616a6e-24829-0 |
d13c80f46886c220e29b2fe3a61781853ec579d4 | Donor status: company | Sponsorships 8f616a6e | 2010-12-20 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 24 | 2010-12-20-8f616a6e-24829-0 |
a34d5fcff6b354200e7ca80bcaccb18231681645 | Name of donor: Corran (Wakefield) Limited; family estate | Sponsorships 8f616a6e | 2010-12-20 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 26 | 2010-12-20-8f616a6e-24829-0 |
6e4442bcf64e909b0d58bb8739f8046cb6ecf82d | Address of donor: Wakefield Lodge Estate, Potterspury, Towcester, Northants NN12 7QX | Sponsorships 8f616a6e | 2010-12-20 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 27 | 2010-12-20-8f616a6e-24829-0 |
570740afc64385d8ae9315d0ccc3cdfc87a96a4e | Amount of donation or nature and value if donation in kind: £5,000 | Sponsorships 8f616a6e | 2010-12-20 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 28 | 2010-12-20-8f616a6e-24829-0 |
802e41bebe1e532d2cc0f75845b37bca866bb616 | Name of donor: DE Putron Fund Management Ltd; fund manager | Sponsorships 8f616a6e | 2010-12-20 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 31 | 2010-12-20-8f616a6e-24829-0 |
1532cc504f57ae92207970d8bde4649d2938702a | Name of donor: Gloucester Research Ltd; research | Sponsorships 8f616a6e | 2010-12-20 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 36 | 2010-12-20-8f616a6e-24829-0 |
7f0654b69f8db53c579cb077312a618764aa280c | Address of donor: 5th Floor, Whittington House, 19-30 Alfred Place, London WC1E 7EA | Sponsorships 8f616a6e | 2010-12-20 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 37 | 2010-12-20-8f616a6e-24829-0 |
5b35ec269070fbc426dd44968463172ad432ff2e | Amount of donation or nature and value if donation in kind: £4,999 | Sponsorships 8f616a6e | 2010-12-20 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 38 | 2010-12-20-8f616a6e-24829-0 |
aed58736f99a6c97a28bc928ab12eabd02f949db | Donor status: company | Sponsorships 8f616a6e | 2010-12-20 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 39 | 2010-12-20-8f616a6e-24829-0 |
316bd6fa042f22aca90902429a5a12e1acab9e1f | Name of donor: Lady Vaughan | Sponsorships 8f616a6e | 2010-12-20 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 41 | 2010-12-20-8f616a6e-24829-0 |
80945cb7a0e5e3115956ff818a1566db6ce636e3 | Amount of donation or nature and value if donation in kind: 2 donations; total £2,000 | Sponsorships 8f616a6e | 2010-12-20 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 43 | 2010-12-20-8f616a6e-24829-0 |
d18da4418d7995b1228e15aeec25626d8accdc5d | Name of donor: Cllr and Mrs J Byrom | Sponsorships 8f616a6e | 2010-12-20 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 46 | 2010-12-20-8f616a6e-24829-0 |
7edea86d4c79bb4e99149c90e670bf3ec6b6b6e1 | Address of donor: private | Sponsorships 8f616a6e | 2010-12-20 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 47 | 2010-12-20-8f616a6e-24829-0 |
36dbe6e3552c78f21c9465d264f9d935f03bdf59 | Amount of donation or nature and value if donation in kind: 2 donations; total £4,600 | Sponsorships 8f616a6e | 2010-12-20 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 48 | 2010-12-20-8f616a6e-24829-0 |
8ecbe924c04ab25371d19e9fe3959f0111da38af | Donor status: individual | Sponsorships 8f616a6e | 2010-12-20 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 49 | 2010-12-20-8f616a6e-24829-0 |
d182b3818c0a8d3bd45aa0757d6eaccd011e2329 | (Registered 3 June 2010) | Sponsorships 8f616a6e | 2010-12-20 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 50 | 2010-12-20-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");