items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
28 rows where record_id = "2010-11-08-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 |
---|---|---|---|---|---|---|---|
57db8a61e6bd6a63b7294ee7add018c0b6f3db7b | Donations to my constituency party or association, which have been or will be reported by my party to the Electoral Commission: | Sponsorships 8f616a6e | 2010-11-08 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 0 | 2010-11-08-8f616a6e-24829-0 |
47411517e9d79c8daf4bcce6f5a39594a2afc143 | Name of donor: Rupert Fordham | Sponsorships 8f616a6e | 2010-11-08 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 1 | 2010-11-08-8f616a6e-24829-0 |
88661ba382294468842a3577c23b1fd2db380f82 | Amount of donation or nature and value if donation in kind: 2 donations; value £5,500 | Sponsorships 8f616a6e | 2010-11-08 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 3 | 2010-11-08-8f616a6e-24829-0 |
769fff7147f82f7bcf8537a5aa87595c064bf3d1 | Name of donor: Mr P D Warner | Sponsorships 8f616a6e | 2010-11-08 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 6 | 2010-11-08-8f616a6e-24829-0 |
51f1c5d8553d0bc55ce6526679c8a1f3dc9b77c1 | Amount of donation or nature and value if donation in kind: £5,000 | Sponsorships 8f616a6e | 2010-11-08 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 8 | 2010-11-08-8f616a6e-24829-0 |
cbdde67605f763153ae5ab8e6332f08fe290ddec | Name of donor: Sainty Hird & Partners; executive search | Sponsorships 8f616a6e | 2010-11-08 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 11 | 2010-11-08-8f616a6e-24829-0 |
0bb3e339981747ea75c1507e9e0a4a16e273ef59 | Address of donor: 3 St James Square, London SW1Y 4JU | Sponsorships 8f616a6e | 2010-11-08 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 12 | 2010-11-08-8f616a6e-24829-0 |
4957a603ce79861efd294cd4f9b8663c688bc16f | Name of donor: Ilsley Holdings Ltd | Sponsorships 8f616a6e | 2010-11-08 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 16 | 2010-11-08-8f616a6e-24829-0 |
5adcdae99fda8fe39e013d0d96ada5e0f9047732 | Address of donor: Phoenix Court, Bartholomew Street, Newbury, Berkshire RG14 5QA | Sponsorships 8f616a6e | 2010-11-08 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 17 | 2010-11-08-8f616a6e-24829-0 |
4d8d2dda2d3e929e41658c3f61896be75b5dab15 | Amount of donation or nature and value if donation in kind: £4,800 | Sponsorships 8f616a6e | 2010-11-08 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 18 | 2010-11-08-8f616a6e-24829-0 |
c0a0a8cd9b470afca73d4bd96925b4237784050f | Name of donor: Trotter & Co Ltd; farming | Sponsorships 8f616a6e | 2010-11-08 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 21 | 2010-11-08-8f616a6e-24829-0 |
c601541d3298f723e8f58638d75ca0f1d748ac91 | Address of donor: Field Burcote House, Duncote, Towcester, Northants NN12 8AH | Sponsorships 8f616a6e | 2010-11-08 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 22 | 2010-11-08-8f616a6e-24829-0 |
e1bbaa1125c1e4eaa6738568a1103046103db165 | Donor status: company | Sponsorships 8f616a6e | 2010-11-08 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 24 | 2010-11-08-8f616a6e-24829-0 |
f0af6cb891da262030947804c144da75f11960f7 | Name of donor: Corran (Wakefield) Limited; family estate | Sponsorships 8f616a6e | 2010-11-08 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 26 | 2010-11-08-8f616a6e-24829-0 |
de8f7bad01b1dd020168ea516939c280ae17e8fb | Address of donor: Wakefield Lodge Estate, Potterspury, Towcester, Northants NN12 7QX | Sponsorships 8f616a6e | 2010-11-08 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 27 | 2010-11-08-8f616a6e-24829-0 |
4e4a9a5f3dfa86fd9df3bac39655839aa9036a9e | Amount of donation or nature and value if donation in kind: £5,000 | Sponsorships 8f616a6e | 2010-11-08 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 28 | 2010-11-08-8f616a6e-24829-0 |
5d61eb9020b49bac2685cac37a8d9a6bde786335 | Name of donor: DE Putron Fund Management Ltd; fund manager | Sponsorships 8f616a6e | 2010-11-08 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 31 | 2010-11-08-8f616a6e-24829-0 |
fe039c371c9eef343b45f3b65dfe5fce667ae2bd | Name of donor: Gloucester Research Ltd; research | Sponsorships 8f616a6e | 2010-11-08 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 36 | 2010-11-08-8f616a6e-24829-0 |
bab148cf490fa44fcfe7b3be9793e43dfdf7a94c | Address of donor: 5th Floor, Whittington House, 19-30 Alfred Place, London WC1E 7EA | Sponsorships 8f616a6e | 2010-11-08 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 37 | 2010-11-08-8f616a6e-24829-0 |
6f4826980c149920fda88ee37cbfb4a044e09a11 | Amount of donation or nature and value if donation in kind: £4,999 | Sponsorships 8f616a6e | 2010-11-08 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 38 | 2010-11-08-8f616a6e-24829-0 |
344e715059bc7f41758a8014d0f850d8e66f3707 | Donor status: company | Sponsorships 8f616a6e | 2010-11-08 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 39 | 2010-11-08-8f616a6e-24829-0 |
1e51fc8c449d93321095105496209cff9e9322a7 | Name of donor: Lady Vaughan | Sponsorships 8f616a6e | 2010-11-08 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 41 | 2010-11-08-8f616a6e-24829-0 |
ca624e24bbbb6bdd55876430ca59da9091060bdc | Amount of donation or nature and value if donation in kind: 2 donations; total £2,000 | Sponsorships 8f616a6e | 2010-11-08 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 43 | 2010-11-08-8f616a6e-24829-0 |
37bcebdb0753e2455aaa5ca154da2c9986cbf523 | Name of donor: Cllr and Mrs J Byrom | Sponsorships 8f616a6e | 2010-11-08 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 46 | 2010-11-08-8f616a6e-24829-0 |
c6de91f93958b1b12bf3f3bc92773577280500bd | Address of donor: private | Sponsorships 8f616a6e | 2010-11-08 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 47 | 2010-11-08-8f616a6e-24829-0 |
79fe3cad548f0dc67ac690834fdde0593ff51b0a | Amount of donation or nature and value if donation in kind: 2 donations; total £4,600 | Sponsorships 8f616a6e | 2010-11-08 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 48 | 2010-11-08-8f616a6e-24829-0 |
f2c16508d5b11cca3f88a5d20204d00a733af966 | Donor status: individual | Sponsorships 8f616a6e | 2010-11-08 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 49 | 2010-11-08-8f616a6e-24829-0 |
c40eb08ca095c55a568c56afaac2c41f23d0a554 | (Registered 3 June 2010) | Sponsorships 8f616a6e | 2010-11-08 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 50 | 2010-11-08-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");