items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
22 rows where record_id = "2014-11-10-8f616a6e-24773-0" sorted by record_id
This data as json, CSV (advanced)
Suggested facets: date (date)
hash | item | category_id | date | member_id | person_id | sort_order | record_id ▼ |
---|---|---|---|---|---|---|---|
4cb6b6443d4a743f1ed66f392d02a7d0517a1997 | Donations to my constituency party or association, which have been or will be reported by the party to the Electoral Commission: | Sponsorships 8f616a6e | 2014-11-10 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 0 | 2014-11-10-8f616a6e-24773-0 |
697ea175572ea9bd356771a8b0d0cdd4a2f2061d | Name of donor: Kirsten Rausing | Sponsorships 8f616a6e | 2014-11-10 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 1 | 2014-11-10-8f616a6e-24773-0 |
a7831db957848efe8b025bd5bc02fece9649fabf | Amount of donation or nature and value if donation in kind: £7,250 | Sponsorships 8f616a6e | 2014-11-10 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 3 | 2014-11-10-8f616a6e-24773-0 |
4e7c7c23e9f03d1eaca64e4a815c7469133b0455 | (Registered 19 September 2014) | Sponsorships 8f616a6e | 2014-11-10 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 5 | 2014-11-10-8f616a6e-24773-0 |
e63b7b02ce0bc660c3d3fccabad136fdb878b287 | Name of donor: Tattersalls Ltd | Sponsorships 8f616a6e | 2014-11-10 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 6 | 2014-11-10-8f616a6e-24773-0 |
6602ed66ce464986169cee39fc5cb3040dd29705 | Address of donor: Terrace House, 125 High Street, Newmarket CB8 9BT | Sponsorships 8f616a6e | 2014-11-10 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 7 | 2014-11-10-8f616a6e-24773-0 |
0bbc28969e64a0e92dbdbce1c578819926ae4745 | Amount of donation or nature and value if donation in kind: £10,000 | Sponsorships 8f616a6e | 2014-11-10 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 8 | 2014-11-10-8f616a6e-24773-0 |
c32ddd1e80fe5b77cc5f40915f96324e1f16af70 | Donor status: company, registration 00791113 | Sponsorships 8f616a6e | 2014-11-10 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 9 | 2014-11-10-8f616a6e-24773-0 |
329bfaa22a1114a9c945fff0f0b68f702be6c5fe | (Registered 14 October 2014) | Sponsorships 8f616a6e | 2014-11-10 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 10 | 2014-11-10-8f616a6e-24773-0 |
59f9e37710302a6b4f008b64e8bba91a50a67f35 | Name of donor: Unex Construction Ltd | Sponsorships 8f616a6e | 2014-11-10 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 11 | 2014-11-10-8f616a6e-24773-0 |
59fa136d2188e23c97833f3813aaf53f442dd13f | Address of donor: Unex House, Church Lane, Stechworth, Newmarket CB8 9TN | Sponsorships 8f616a6e | 2014-11-10 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 12 | 2014-11-10-8f616a6e-24773-0 |
d74fe05b760848fafd205a27dbe5a149529f7ce3 | Amount of donation or nature and value if donation in kind: £40,000 | Sponsorships 8f616a6e | 2014-11-10 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 13 | 2014-11-10-8f616a6e-24773-0 |
37e4a4a27361bd45ac5032760d5b0035b59e8e8f | Donor status: company, registration 01353767 | Sponsorships 8f616a6e | 2014-11-10 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 14 | 2014-11-10-8f616a6e-24773-0 |
dc5fc02acd5809a9389ea0c238a5e1cef8396a28 | (Registered 3 November 2014) | Sponsorships 8f616a6e | 2014-11-10 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 15 | 2014-11-10-8f616a6e-24773-0 |
041b8eceb63d39b7dece6238c260c2257d98528d | Support in the capacity as an MP: | Sponsorships 8f616a6e | 2014-11-10 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 16 | 2014-11-10-8f616a6e-24773-0 |
95d87e3e794500b8382eee30b0921a57a74db6dd | Name of donor: Neil Record | Sponsorships 8f616a6e | 2014-11-10 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 17 | 2014-11-10-8f616a6e-24773-0 |
50dc96aa0eb4fa25d926b2988262821e1052d1b3 | Address of donor: private | Sponsorships 8f616a6e | 2014-11-10 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 18 | 2014-11-10-8f616a6e-24773-0 |
025a714671ccdc5fd1f8c7e15fd3a4b63cfad10c | Amount of donation or nature and value if donation in kind: £4,000 in support of my parliamentary work and travel costs in my capacity as an MP | Sponsorships 8f616a6e | 2014-11-10 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 19 | 2014-11-10-8f616a6e-24773-0 |
1664d3506f9e450c562bd5e1fb05a383d6da0910 | Date of receipt: 29 November 2013 | Sponsorships 8f616a6e | 2014-11-10 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 20 | 2014-11-10-8f616a6e-24773-0 |
ca28fa7144364d0a50fa90a7e5d89ff2d6d2a985 | Date of acceptance: 29 November 2013 | Sponsorships 8f616a6e | 2014-11-10 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 21 | 2014-11-10-8f616a6e-24773-0 |
35252df809ed0df652c0f17e2771461da3a14503 | Donor status: individual | Sponsorships 8f616a6e | 2014-11-10 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 22 | 2014-11-10-8f616a6e-24773-0 |
fc96535f849ac1b06fbac9d2380b9220dee784e8 | (Registered 5 December 2013) | Sponsorships 8f616a6e | 2014-11-10 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 23 | 2014-11-10-8f616a6e-24773-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");