items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
40 rows where record_id = "2011-05-16-8f616a6e-24829-0" sorted by date descending
This data as json, CSV (advanced)
Suggested facets: date (date)
hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
ea3bd1886c7acf349b8049571a55f79a10af6bcf | Donations to my constituency party or association, which have been or will be reported by my party to the Electoral Commission: | Sponsorships 8f616a6e | 2011-05-16 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 0 | 2011-05-16-8f616a6e-24829-0 |
6f6b752d32c8aee590bec88832e1c0f5b7471d85 | Name of donor: Rupert Fordham | Sponsorships 8f616a6e | 2011-05-16 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 1 | 2011-05-16-8f616a6e-24829-0 |
8ba669627d7206550b65c5dc2f3cfab4544e33b3 | Amount of donation or nature and value if donation in kind: 2 donations; value £5,500 | Sponsorships 8f616a6e | 2011-05-16 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 3 | 2011-05-16-8f616a6e-24829-0 |
24d4b8287a22c9eb95e3a8e999169fa4f78d52b8 | Name of donor: Mr P D Warner | Sponsorships 8f616a6e | 2011-05-16 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 6 | 2011-05-16-8f616a6e-24829-0 |
b86603c3643912ea064424ed911697dba0193551 | Amount of donation or nature and value if donation in kind: £5,000 | Sponsorships 8f616a6e | 2011-05-16 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 8 | 2011-05-16-8f616a6e-24829-0 |
4a66a25ddc4c5b31e7e8cee5d5b5447b1714759e | Name of donor: Sainty Hird & Partners; executive search | Sponsorships 8f616a6e | 2011-05-16 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 11 | 2011-05-16-8f616a6e-24829-0 |
04566c946d2a45ba787aa2a813e37fac894497b6 | Address of donor: 3 St James Square, London SW1Y 4JU | Sponsorships 8f616a6e | 2011-05-16 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 12 | 2011-05-16-8f616a6e-24829-0 |
09429fe6126156ef223b7058348b5866d1f71fa2 | Name of donor: Ilsley Holdings Ltd | Sponsorships 8f616a6e | 2011-05-16 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 16 | 2011-05-16-8f616a6e-24829-0 |
5318d04fbf6c91b3d55c188e26eaa21a613c35c9 | Address of donor: Phoenix Court, Bartholomew Street, Newbury, Berkshire RG14 5QA | Sponsorships 8f616a6e | 2011-05-16 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 17 | 2011-05-16-8f616a6e-24829-0 |
9af346f921b65223aa9ab2ff12605fffe4824768 | Amount of donation or nature and value if donation in kind: £4,800 | Sponsorships 8f616a6e | 2011-05-16 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 18 | 2011-05-16-8f616a6e-24829-0 |
3dc1f828abbd8834d0ff37fd21825b13bc615b0c | Name of donor: Trotter & Co Ltd; farming | Sponsorships 8f616a6e | 2011-05-16 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 21 | 2011-05-16-8f616a6e-24829-0 |
f89f66c933156e3b8c390e2480612cbc46bd81fd | Address of donor: Field Burcote House, Duncote, Towcester, Northants NN12 8AH | Sponsorships 8f616a6e | 2011-05-16 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 22 | 2011-05-16-8f616a6e-24829-0 |
8bbfd8ab07f3c4b28297d759951ec5c921e6461f | Donor status: company | Sponsorships 8f616a6e | 2011-05-16 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 24 | 2011-05-16-8f616a6e-24829-0 |
a43964678350adeb8de66aadaff47dad0cffcd18 | Name of donor: Corran (Wakefield) Limited; family estate | Sponsorships 8f616a6e | 2011-05-16 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 26 | 2011-05-16-8f616a6e-24829-0 |
7e39d62d29adb1758b2ea183564bd49db5dad30b | Address of donor: Wakefield Lodge Estate, Potterspury, Towcester, Northants NN12 7QX | Sponsorships 8f616a6e | 2011-05-16 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 27 | 2011-05-16-8f616a6e-24829-0 |
0aad69fcc911ebf8eef9063046e357d97b3637d3 | Amount of donation or nature and value if donation in kind: £5,000 | Sponsorships 8f616a6e | 2011-05-16 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 28 | 2011-05-16-8f616a6e-24829-0 |
e69801250f83c6fddf2925eb058b54ede88bf76f | Name of donor: DE Putron Fund Management Ltd; fund manager | Sponsorships 8f616a6e | 2011-05-16 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 31 | 2011-05-16-8f616a6e-24829-0 |
62b9f38a32e325d686668d2aeb464ba2c7bd2a22 | Name of donor: Gloucester Research Ltd; research | Sponsorships 8f616a6e | 2011-05-16 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 36 | 2011-05-16-8f616a6e-24829-0 |
da90b86af376b16bcac83011d60d84a833b3cb2a | Address of donor: 5th Floor, Whittington House, 19-30 Alfred Place, London WC1E 7EA | Sponsorships 8f616a6e | 2011-05-16 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 37 | 2011-05-16-8f616a6e-24829-0 |
83b9c21850421d2b8fa8b1e659256f276793ad5f | Amount of donation or nature and value if donation in kind: £4,999 | Sponsorships 8f616a6e | 2011-05-16 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 38 | 2011-05-16-8f616a6e-24829-0 |
fd36bba14da2b59c49c947c6b2b027f815ed473b | Donor status: company | Sponsorships 8f616a6e | 2011-05-16 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 39 | 2011-05-16-8f616a6e-24829-0 |
2182050575225b59c65543dd41766f539d8b69f4 | Name of donor: Lady Vaughan | Sponsorships 8f616a6e | 2011-05-16 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 41 | 2011-05-16-8f616a6e-24829-0 |
657298843684d0d1eacc5f36c08acb5e3c4bc493 | Amount of donation or nature and value if donation in kind: 2 donations; total £2,000 | Sponsorships 8f616a6e | 2011-05-16 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 43 | 2011-05-16-8f616a6e-24829-0 |
c3ea84a6c2fe27b7d7acd9c875ad6256c5d51a9e | Name of donor: Cllr and Mrs J Byrom | Sponsorships 8f616a6e | 2011-05-16 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 46 | 2011-05-16-8f616a6e-24829-0 |
468ba8c30dd23014e20b727e57e295ea7a11911e | Address of donor: private | Sponsorships 8f616a6e | 2011-05-16 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 47 | 2011-05-16-8f616a6e-24829-0 |
d44fbf8e8f9dfafe4cf2b6e9e4c849024fda6fac | Amount of donation or nature and value if donation in kind: 2 donations; total £4,600 | Sponsorships 8f616a6e | 2011-05-16 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 48 | 2011-05-16-8f616a6e-24829-0 |
4c2401759cc9820a8f431e6cc6f55a12cd3b92c8 | Donor status: individual | Sponsorships 8f616a6e | 2011-05-16 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 49 | 2011-05-16-8f616a6e-24829-0 |
2e225417ffffcb21a71259151ad624f2060fbd6d | (Registered 3 June 2010) | Sponsorships 8f616a6e | 2011-05-16 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 50 | 2011-05-16-8f616a6e-24829-0 |
026756139afab4bcdbc77a044e45141529d6ef65 | (b) Support in the capacity as an MP: | Sponsorships 8f616a6e | 2011-05-16 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 51 | 2011-05-16-8f616a6e-24829-0 |
f6e9dd2cdce99294d0c411bbd8ee5e02e2ad5034 | 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-05-16 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 54 | 2011-05-16-8f616a6e-24829-0 |
f1e35d4ba0c8689d451df238ffbc000f20717672 | Date of receipt: 3 February 2011 | Sponsorships 8f616a6e | 2011-05-16 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 55 | 2011-05-16-8f616a6e-24829-0 |
22100a5cf9dd9c6fef8ca91eef3e93e5ac075112 | Date of acceptance: 3 February 2011 | Sponsorships 8f616a6e | 2011-05-16 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 56 | 2011-05-16-8f616a6e-24829-0 |
f50202df0f1b622990c7232350013a4600e0a572 | (Registered 9 February 2011) | Sponsorships 8f616a6e | 2011-05-16 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 58 | 2011-05-16-8f616a6e-24829-0 |
aaf4b147d724eeac519a6ce6c7f1210d3b8a4ade | Name of donor: Gloucester Research Ltd | Sponsorships 8f616a6e | 2011-05-16 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 59 | 2011-05-16-8f616a6e-24829-0 |
16c11da2dd8485a3447c6c2e032409ef20df84a4 | Address of donor: Whittington House, 19-30 Alfred Place, London WC1E 7EA | Sponsorships 8f616a6e | 2011-05-16 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 60 | 2011-05-16-8f616a6e-24829-0 |
d56d52db2df88b80ad44f79c5e76d71f73f8021a | Amount of donation or nature and value if donation in kind: donation of £18,500 to employ a member of staff in my Westminster office | Sponsorships 8f616a6e | 2011-05-16 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 61 | 2011-05-16-8f616a6e-24829-0 |
0d0fdd48eefaec5df8119e5600418226efddf76b | Date of receipt: 14 April 2011 | Sponsorships 8f616a6e | 2011-05-16 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 62 | 2011-05-16-8f616a6e-24829-0 |
d55007970407aab8110487d19df077ea45fb0290 | Date of acceptance: 14 April 2011 | Sponsorships 8f616a6e | 2011-05-16 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 63 | 2011-05-16-8f616a6e-24829-0 |
7ff3eaffcb242d434248d6fb93d7c9ebab72eefe | Donor status: company, registration 04267560 | Sponsorships 8f616a6e | 2011-05-16 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 64 | 2011-05-16-8f616a6e-24829-0 |
37b2209c0490b8c5dae487c3eeb7ac2cf0b11dee | (Registered 5 May 2011) | Sponsorships 8f616a6e | 2011-05-16 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 65 | 2011-05-16-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");