items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
28 rows where record_id = "2011-02-07-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 |
---|---|---|---|---|---|---|---|
e5fc1230edbc4f697f6486f4a7ba80e605ba0a2f | Donations to my constituency party or association, which have been or will be reported by my party to the Electoral Commission: | Sponsorships 8f616a6e | 2011-02-07 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 0 | 2011-02-07-8f616a6e-24829-0 |
8c50525b99c55d2f7bc755018182f1a93e19ae79 | Name of donor: Rupert Fordham | Sponsorships 8f616a6e | 2011-02-07 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 1 | 2011-02-07-8f616a6e-24829-0 |
9f8a3a28b57a7b8dc9227f81a5acda90a294d0f6 | Amount of donation or nature and value if donation in kind: 2 donations; value £5,500 | Sponsorships 8f616a6e | 2011-02-07 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 3 | 2011-02-07-8f616a6e-24829-0 |
6c6b81d2bdf916e17a81eab2d1b8b4783c3bcc5c | Name of donor: Mr P D Warner | Sponsorships 8f616a6e | 2011-02-07 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 6 | 2011-02-07-8f616a6e-24829-0 |
c2f16d8010cb925952ea21e8413b78f156c03c0d | Amount of donation or nature and value if donation in kind: £5,000 | Sponsorships 8f616a6e | 2011-02-07 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 8 | 2011-02-07-8f616a6e-24829-0 |
f9f5390d9d011040743d4105a287f410578da9ce | Name of donor: Sainty Hird & Partners; executive search | Sponsorships 8f616a6e | 2011-02-07 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 11 | 2011-02-07-8f616a6e-24829-0 |
4698c9ee41d6dff9567b36ff5671de270ab9ad3c | Address of donor: 3 St James Square, London SW1Y 4JU | Sponsorships 8f616a6e | 2011-02-07 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 12 | 2011-02-07-8f616a6e-24829-0 |
c45c4f289a183a657d168e46d695d20479320313 | Name of donor: Ilsley Holdings Ltd | Sponsorships 8f616a6e | 2011-02-07 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 16 | 2011-02-07-8f616a6e-24829-0 |
3bd9b216be77d37440be15474f19b8bd64996edf | Address of donor: Phoenix Court, Bartholomew Street, Newbury, Berkshire RG14 5QA | Sponsorships 8f616a6e | 2011-02-07 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 17 | 2011-02-07-8f616a6e-24829-0 |
5b591d0814fcdc1a5d75fca4f3704fb098f5c212 | Amount of donation or nature and value if donation in kind: £4,800 | Sponsorships 8f616a6e | 2011-02-07 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 18 | 2011-02-07-8f616a6e-24829-0 |
5e7604354d7ef353b2d096ed11dac10b95ee6f3f | Name of donor: Trotter & Co Ltd; farming | Sponsorships 8f616a6e | 2011-02-07 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 21 | 2011-02-07-8f616a6e-24829-0 |
1d000772610fc4074054be5c27f05bc139ed4b71 | Address of donor: Field Burcote House, Duncote, Towcester, Northants NN12 8AH | Sponsorships 8f616a6e | 2011-02-07 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 22 | 2011-02-07-8f616a6e-24829-0 |
cc4a2325e32f5fb95ea23452f483a0e9b04298d5 | Donor status: company | Sponsorships 8f616a6e | 2011-02-07 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 24 | 2011-02-07-8f616a6e-24829-0 |
2f1d8bfc09fa3a28173beb6fd720e5e81868913c | Name of donor: Corran (Wakefield) Limited; family estate | Sponsorships 8f616a6e | 2011-02-07 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 26 | 2011-02-07-8f616a6e-24829-0 |
2c402984e1e8ffefdadcef924c1644fec610ca5c | Address of donor: Wakefield Lodge Estate, Potterspury, Towcester, Northants NN12 7QX | Sponsorships 8f616a6e | 2011-02-07 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 27 | 2011-02-07-8f616a6e-24829-0 |
4aba23968d9ba67c0a10b205caed26ad4512934e | Amount of donation or nature and value if donation in kind: £5,000 | Sponsorships 8f616a6e | 2011-02-07 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 28 | 2011-02-07-8f616a6e-24829-0 |
6279f2c0b66f1f84db6069bbd6028567e2fb6c2d | Name of donor: DE Putron Fund Management Ltd; fund manager | Sponsorships 8f616a6e | 2011-02-07 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 31 | 2011-02-07-8f616a6e-24829-0 |
4d0cb1fb9e30d2a8af680f98c5833373c0ec8fe9 | Name of donor: Gloucester Research Ltd; research | Sponsorships 8f616a6e | 2011-02-07 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 36 | 2011-02-07-8f616a6e-24829-0 |
ff25bca5b4619a42aacd7bda359446abddf04c2a | Address of donor: 5th Floor, Whittington House, 19-30 Alfred Place, London WC1E 7EA | Sponsorships 8f616a6e | 2011-02-07 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 37 | 2011-02-07-8f616a6e-24829-0 |
e7f9c97116de18bd47849c59ad8c2f59fa3d0217 | Amount of donation or nature and value if donation in kind: £4,999 | Sponsorships 8f616a6e | 2011-02-07 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 38 | 2011-02-07-8f616a6e-24829-0 |
b20e667b8e59a8980c980f2e3b78eaf4b6fb96b5 | Donor status: company | Sponsorships 8f616a6e | 2011-02-07 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 39 | 2011-02-07-8f616a6e-24829-0 |
b665697cc3ea2ae9df72c212fb96843df16c4068 | Name of donor: Lady Vaughan | Sponsorships 8f616a6e | 2011-02-07 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 41 | 2011-02-07-8f616a6e-24829-0 |
fdb9d60ce995dfe9209bc8b171b74bb5b0de8b0f | Amount of donation or nature and value if donation in kind: 2 donations; total £2,000 | Sponsorships 8f616a6e | 2011-02-07 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 43 | 2011-02-07-8f616a6e-24829-0 |
e5d767afdd2f9a493fd74df99e1efef1eaadc459 | Name of donor: Cllr and Mrs J Byrom | Sponsorships 8f616a6e | 2011-02-07 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 46 | 2011-02-07-8f616a6e-24829-0 |
9188013243c8f92c12a1bfab6640af5338e46388 | Address of donor: private | Sponsorships 8f616a6e | 2011-02-07 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 47 | 2011-02-07-8f616a6e-24829-0 |
83e6a69cd3d94b6e5d251f5dd2ccd79ae58d1fe4 | Amount of donation or nature and value if donation in kind: 2 donations; total £4,600 | Sponsorships 8f616a6e | 2011-02-07 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 48 | 2011-02-07-8f616a6e-24829-0 |
a3cef7191cd0aa633311f1988a01130e9d294e4a | Donor status: individual | Sponsorships 8f616a6e | 2011-02-07 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 49 | 2011-02-07-8f616a6e-24829-0 |
278c49864fc2f0e4f835c13fdd36658c6b580db2 | (Registered 3 June 2010) | Sponsorships 8f616a6e | 2011-02-07 | Andrea Leadsom uk.org.publicwhip/member/40550 | Andrea Leadsom uk.org.publicwhip/person/24829 | 50 | 2011-02-07-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");