items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
30 rows where "date" is on date 2011-01-24 and person_id = "uk.org.publicwhip/person/24829" sorted by date descending
This data as json, CSV (advanced)
Suggested facets: category_id, sort_order, record_id, date (date)
hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
08fb9881d4e6538f9745f8c55f0142a86737e64e | Donations to my constituency party or association, which have been or will be reported by my party to the Electoral Commission: | Sponsorships 8f616a6e | 2011-01-24 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 0 | 2011-01-24-8f616a6e-24829-0 |
9f07e95c11b5f3abdacce6e427968d1987a2acd2 | Name of donor: Rupert Fordham | Sponsorships 8f616a6e | 2011-01-24 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 1 | 2011-01-24-8f616a6e-24829-0 |
6d30cbd34d6b09104b38fdc60a4c08a637ad3953 | Amount of donation or nature and value if donation in kind: 2 donations; value £5,500 | Sponsorships 8f616a6e | 2011-01-24 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 3 | 2011-01-24-8f616a6e-24829-0 |
856100bcfd6c1c654dcd5a2ed49662931cd39efc | Name of donor: Mr P D Warner | Sponsorships 8f616a6e | 2011-01-24 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 6 | 2011-01-24-8f616a6e-24829-0 |
9e3893440374d8190e7865d2a041db4d793fd8db | Amount of donation or nature and value if donation in kind: £5,000 | Sponsorships 8f616a6e | 2011-01-24 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 8 | 2011-01-24-8f616a6e-24829-0 |
511dc7d36797fea98a2c841b081a1f3dbfc04264 | Name of donor: Sainty Hird & Partners; executive search | Sponsorships 8f616a6e | 2011-01-24 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 11 | 2011-01-24-8f616a6e-24829-0 |
0f5ba4cbf9bc23c57b1606cd49fea9b372dc79aa | Address of donor: 3 St James Square, London SW1Y 4JU | Sponsorships 8f616a6e | 2011-01-24 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 12 | 2011-01-24-8f616a6e-24829-0 |
8fb0784db2c88cb31ea137bdc9e55fd0ec1364e0 | Name of donor: Ilsley Holdings Ltd | Sponsorships 8f616a6e | 2011-01-24 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 16 | 2011-01-24-8f616a6e-24829-0 |
32ed3004afa7c4d5899814dc2d22286418659742 | Address of donor: Phoenix Court, Bartholomew Street, Newbury, Berkshire RG14 5QA | Sponsorships 8f616a6e | 2011-01-24 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 17 | 2011-01-24-8f616a6e-24829-0 |
3f431e16eb41bbabdd2061f8315052a752f8d030 | Amount of donation or nature and value if donation in kind: £4,800 | Sponsorships 8f616a6e | 2011-01-24 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 18 | 2011-01-24-8f616a6e-24829-0 |
60d34267513ca018e5fdda4cff3df9baa5cf0bf4 | Name of donor: Trotter & Co Ltd; farming | Sponsorships 8f616a6e | 2011-01-24 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 21 | 2011-01-24-8f616a6e-24829-0 |
b4fb115dd89de02e7758d6ef9c9c01507dd5ec67 | Address of donor: Field Burcote House, Duncote, Towcester, Northants NN12 8AH | Sponsorships 8f616a6e | 2011-01-24 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 22 | 2011-01-24-8f616a6e-24829-0 |
4fc61e9e84e63fd16e06cb7fa7be87a776071257 | Donor status: company | Sponsorships 8f616a6e | 2011-01-24 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 24 | 2011-01-24-8f616a6e-24829-0 |
0b7ca77a46669edb275d415b086fae7bca0e641a | Name of donor: Corran (Wakefield) Limited; family estate | Sponsorships 8f616a6e | 2011-01-24 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 26 | 2011-01-24-8f616a6e-24829-0 |
d8fee823559a59864ab5c0d8a89fc92bbf8e6d5e | Address of donor: Wakefield Lodge Estate, Potterspury, Towcester, Northants NN12 7QX | Sponsorships 8f616a6e | 2011-01-24 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 27 | 2011-01-24-8f616a6e-24829-0 |
343fbee03a868153600fd94810a29cf30615f7cd | Amount of donation or nature and value if donation in kind: £5,000 | Sponsorships 8f616a6e | 2011-01-24 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 28 | 2011-01-24-8f616a6e-24829-0 |
5dafcc9258762151f4f4edc04de6fd29fa1d3004 | Name of donor: DE Putron Fund Management Ltd; fund manager | Sponsorships 8f616a6e | 2011-01-24 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 31 | 2011-01-24-8f616a6e-24829-0 |
b68eb9d7ccb8f2a47f542c15f2d2e3c853e43620 | Name of donor: Gloucester Research Ltd; research | Sponsorships 8f616a6e | 2011-01-24 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 36 | 2011-01-24-8f616a6e-24829-0 |
74afa19cc6f50b0274ccf640734f363fc298fed5 | Address of donor: 5th Floor, Whittington House, 19-30 Alfred Place, London WC1E 7EA | Sponsorships 8f616a6e | 2011-01-24 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 37 | 2011-01-24-8f616a6e-24829-0 |
33e37a6419ef899399c79f1b64fbeff0ea0e7428 | Amount of donation or nature and value if donation in kind: £4,999 | Sponsorships 8f616a6e | 2011-01-24 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 38 | 2011-01-24-8f616a6e-24829-0 |
aab60af1dc1aec07af2e78212dfe13b751ec9949 | Donor status: company | Sponsorships 8f616a6e | 2011-01-24 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 39 | 2011-01-24-8f616a6e-24829-0 |
84ddf2c0951c3ea6edf38d41d2334c7dfaee404f | Name of donor: Lady Vaughan | Sponsorships 8f616a6e | 2011-01-24 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 41 | 2011-01-24-8f616a6e-24829-0 |
941325c802f25a1885664b8c74168f22662546f0 | Amount of donation or nature and value if donation in kind: 2 donations; total £2,000 | Sponsorships 8f616a6e | 2011-01-24 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 43 | 2011-01-24-8f616a6e-24829-0 |
d1b4c4330bb433f16b9b0a9762df8cd3888f4426 | Name of donor: Cllr and Mrs J Byrom | Sponsorships 8f616a6e | 2011-01-24 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 46 | 2011-01-24-8f616a6e-24829-0 |
f0c1bbd76d2e3c5946484032778281d4e06ed60c | Address of donor: private | Sponsorships 8f616a6e | 2011-01-24 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 47 | 2011-01-24-8f616a6e-24829-0 |
df98074a992bec3ce005d212958a490f04481435 | Amount of donation or nature and value if donation in kind: 2 donations; total £4,600 | Sponsorships 8f616a6e | 2011-01-24 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 48 | 2011-01-24-8f616a6e-24829-0 |
114b14ec6f7ef1dcec013333a87e30d070703154 | Donor status: individual | Sponsorships 8f616a6e | 2011-01-24 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 49 | 2011-01-24-8f616a6e-24829-0 |
a1641c7e42770a05465b9188e61efd4b29c81837 | (Registered 3 June 2010) | Sponsorships 8f616a6e | 2011-01-24 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 50 | 2011-01-24-8f616a6e-24829-0 |
6ad0c679dd3829a855a3c0ce7628728532b456cb | Two properties in Oxford, from which I receive rental income (see Category 9 below). | Land and Property 4f1e6359 | 2011-01-24 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 0 | 2011-01-24-4f1e6359-24829-0 |
c037589024f59aeda5185d63731eefa003b8149e | Bandal Ltd; private company owned by me and my husband, which owns two buy to let properties in Oxford (see Category 8 above) | Shareholdings 5b34324e | 2011-01-24 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 0 | 2011-01-24-5b34324e-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");