items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
28 rows where record_id = "2010-10-25-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 |
---|---|---|---|---|---|---|---|
b4a35d801ee94b799250ee588165f477b66fbc8f | Donations to my constituency party or association, which have been or will be reported by my party to the Electoral Commission: | Sponsorships 8f616a6e | 2010-10-25 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 0 | 2010-10-25-8f616a6e-24829-0 |
d2b359a4ff347326692aff708a158a6a5131a696 | Name of donor: Rupert Fordham | Sponsorships 8f616a6e | 2010-10-25 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 1 | 2010-10-25-8f616a6e-24829-0 |
48c4340a787ab060bdb745619db27667b2f511ed | Amount of donation or nature and value if donation in kind: 2 donations; value £5,500 | Sponsorships 8f616a6e | 2010-10-25 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 3 | 2010-10-25-8f616a6e-24829-0 |
69cabef31d1c75a87b5cd0eee54e022d47f0ed8c | Name of donor: Mr P D Warner | Sponsorships 8f616a6e | 2010-10-25 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 6 | 2010-10-25-8f616a6e-24829-0 |
67dbe2e9626ae47803444261b068c529bc6f8f96 | Amount of donation or nature and value if donation in kind: £5,000 | Sponsorships 8f616a6e | 2010-10-25 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 8 | 2010-10-25-8f616a6e-24829-0 |
ee6656a45f4303d4ff7547faff146c62d302ed4e | Name of donor: Sainty Hird & Partners; executive search | Sponsorships 8f616a6e | 2010-10-25 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 11 | 2010-10-25-8f616a6e-24829-0 |
19bfdc3ff0324c020c2e2b626577937f326b63ca | Address of donor: 3 St James Square, London SW1Y 4JU | Sponsorships 8f616a6e | 2010-10-25 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 12 | 2010-10-25-8f616a6e-24829-0 |
322e3a20b170d96ee68f88b614c94808dde7f5f0 | Name of donor: Ilsley Holdings Ltd | Sponsorships 8f616a6e | 2010-10-25 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 16 | 2010-10-25-8f616a6e-24829-0 |
2dd13c799d6bbf835c5a76524ac391d8ffbd2604 | Address of donor: Phoenix Court, Bartholomew Street, Newbury, Berkshire RG14 5QA | Sponsorships 8f616a6e | 2010-10-25 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 17 | 2010-10-25-8f616a6e-24829-0 |
2b1df59f5ff88ff98ca05ebd08af26deee364b49 | Amount of donation or nature and value if donation in kind: £4,800 | Sponsorships 8f616a6e | 2010-10-25 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 18 | 2010-10-25-8f616a6e-24829-0 |
973ad76cbc5d29b47eb3d4d9f25cc71a10eb600b | Name of donor: Trotter & Co Ltd; farming | Sponsorships 8f616a6e | 2010-10-25 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 21 | 2010-10-25-8f616a6e-24829-0 |
f578d6e79a3b038ad7931c11f4553bb94ae07733 | Address of donor: Field Burcote House, Duncote, Towcester, Northants NN12 8AH | Sponsorships 8f616a6e | 2010-10-25 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 22 | 2010-10-25-8f616a6e-24829-0 |
942365cd629275627c36e7272d5ccf2a8cd9ba54 | Donor status: company | Sponsorships 8f616a6e | 2010-10-25 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 24 | 2010-10-25-8f616a6e-24829-0 |
e15284ddfd94fe06f893e220e072fbca212c4749 | Name of donor: Corran (Wakefield) Limited; family estate | Sponsorships 8f616a6e | 2010-10-25 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 26 | 2010-10-25-8f616a6e-24829-0 |
2c25dabda3c4e9aedcca39f011eeb10302cacd65 | Address of donor: Wakefield Lodge Estate, Potterspury, Towcester, Northants NN12 7QX | Sponsorships 8f616a6e | 2010-10-25 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 27 | 2010-10-25-8f616a6e-24829-0 |
0638bbde59579171fb86c19f8a7bb2c0f8722c89 | Amount of donation or nature and value if donation in kind: £5,000 | Sponsorships 8f616a6e | 2010-10-25 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 28 | 2010-10-25-8f616a6e-24829-0 |
241a01820fc1c2d5c031aa43022bfee2abdb3676 | Name of donor: DE Putron Fund Management Ltd; fund manager | Sponsorships 8f616a6e | 2010-10-25 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 31 | 2010-10-25-8f616a6e-24829-0 |
208a9c4d79f0d25b7d211ad18f9e07d3ddc2220f | Name of donor: Gloucester Research Ltd; research | Sponsorships 8f616a6e | 2010-10-25 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 36 | 2010-10-25-8f616a6e-24829-0 |
eea89b15439818d549789060f512285e0dffa636 | Address of donor: 5th Floor, Whittington House, 19-30 Alfred Place, London WC1E 7EA | Sponsorships 8f616a6e | 2010-10-25 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 37 | 2010-10-25-8f616a6e-24829-0 |
8951f9c38248fc6ba76ad02f73f90275933d241c | Amount of donation or nature and value if donation in kind: £4,999 | Sponsorships 8f616a6e | 2010-10-25 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 38 | 2010-10-25-8f616a6e-24829-0 |
1f2781635eb66e8c005148d7f348fd6a68a28500 | Donor status: company | Sponsorships 8f616a6e | 2010-10-25 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 39 | 2010-10-25-8f616a6e-24829-0 |
a0071b9f8bb4d5545343e55cc93316a6dcbe75e9 | Name of donor: Lady Vaughan | Sponsorships 8f616a6e | 2010-10-25 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 41 | 2010-10-25-8f616a6e-24829-0 |
cfc7d406cade61786624b385baed2372b0fc39a7 | Amount of donation or nature and value if donation in kind: 2 donations; total £2,000 | Sponsorships 8f616a6e | 2010-10-25 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 43 | 2010-10-25-8f616a6e-24829-0 |
cdf0f628e9f7e5c18204e692b381d9c5316dbee0 | Name of donor: Cllr and Mrs J Byrom | Sponsorships 8f616a6e | 2010-10-25 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 46 | 2010-10-25-8f616a6e-24829-0 |
219c75503f66f843ec76619c01eb9dbb8d3b3b26 | Address of donor: private | Sponsorships 8f616a6e | 2010-10-25 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 47 | 2010-10-25-8f616a6e-24829-0 |
f6f777ba06e5e92cc183e4650ba41c0df02d48ac | Amount of donation or nature and value if donation in kind: 2 donations; total £4,600 | Sponsorships 8f616a6e | 2010-10-25 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 48 | 2010-10-25-8f616a6e-24829-0 |
6637f36972b02e8f3a2754f564f6bb30d9bf6a65 | Donor status: individual | Sponsorships 8f616a6e | 2010-10-25 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 49 | 2010-10-25-8f616a6e-24829-0 |
5ebf2f2de5b545b5b6bd4037cf6d19ee8a51ab8c | (Registered 3 June 2010) | Sponsorships 8f616a6e | 2010-10-25 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 50 | 2010-10-25-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");