items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
33 rows where record_id = "2012-03-19-8f616a6e-24773-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 |
---|---|---|---|---|---|---|---|
95a231d86f0c612c5a4e6eaed69f6f8d3f6fb282 | Donations to my constituency party or association, which have been or will be reported by my party to the Electoral Commission: | Sponsorships 8f616a6e | 2012-03-19 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 0 | 2012-03-19-8f616a6e-24773-0 |
53ac4ee69b5c2d8dd682922899a1acf4926a2309 | Sponsorships 8f616a6e | 2012-03-19 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 1 | 2012-03-19-8f616a6e-24773-0 | |
93984920d51597aabbf58e48029d701317c39357 | Name of donor: Bill Gredley | Sponsorships 8f616a6e | 2012-03-19 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 2 | 2012-03-19-8f616a6e-24773-0 |
c136710a5a3ce98f1d7eccc3e800c810b06c9e22 | Address of donor: Unex House, Church Lane, Stetchworth, Newmarket, Suffolk CB8 9TN | Sponsorships 8f616a6e | 2012-03-19 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 3 | 2012-03-19-8f616a6e-24773-0 |
27a08cfc989bbd30300ba705a296e46f0a22aceb | Amount of donation or nature and value if donation in kind: £10,000 | Sponsorships 8f616a6e | 2012-03-19 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 4 | 2012-03-19-8f616a6e-24773-0 |
106768b00fa89ed6a65b6422a531e0bfbc36b37a | Name of donor: Kirsten Rausing | Sponsorships 8f616a6e | 2012-03-19 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 7 | 2012-03-19-8f616a6e-24773-0 |
fe3dd7110e388d7d260df3f786ff53c5293e5573 | Donor status: individual | Sponsorships 8f616a6e | 2012-03-19 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 10 | 2012-03-19-8f616a6e-24773-0 |
05de9e53c7596615cfd0b9b064ad785221715247 | Amount of donation or nature and value if donation in kind: £5,000 | Sponsorships 8f616a6e | 2012-03-19 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 14 | 2012-03-19-8f616a6e-24773-0 |
a596a741e2d5263c10f0f021730c615bcf6858b2 | (Registered 22 March 2011) | Sponsorships 8f616a6e | 2012-03-19 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 16 | 2012-03-19-8f616a6e-24773-0 |
ed1f71132e83bf8c30ecd7b4fb4ecb6f921e5cef | Name of donor: Cheveley Park Stud Ltd | Sponsorships 8f616a6e | 2012-03-19 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 17 | 2012-03-19-8f616a6e-24773-0 |
0b982a9e6b6a9936c391c765db81c644ba74ea52 | Address of donor: Duchess Drive, Newmarket, Suffolk CB8 8DP | Sponsorships 8f616a6e | 2012-03-19 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 18 | 2012-03-19-8f616a6e-24773-0 |
ffcec1a6c30370822884c9d5d4b41aa36bba484e | Amount of donation or nature and value if donation in kind: £10,000 | Sponsorships 8f616a6e | 2012-03-19 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 19 | 2012-03-19-8f616a6e-24773-0 |
ee61ec8aa39ae5aa5ab93c8e148e24cba6bbf534 | Donor status: company | Sponsorships 8f616a6e | 2012-03-19 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 20 | 2012-03-19-8f616a6e-24773-0 |
b175b4b3c359963d6030b86e1c89a96c1eff0658 | Name of donor: Tattersalls Ltd | Sponsorships 8f616a6e | 2012-03-19 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 22 | 2012-03-19-8f616a6e-24773-0 |
9c272a65ad877ba0c8be49ac0486cd59212bb05e | Address of donor: Terrace House, 125 High Street, Newmarket, Suffolk CB8 9BT | Sponsorships 8f616a6e | 2012-03-19 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 23 | 2012-03-19-8f616a6e-24773-0 |
5944a97aa94d43e03dad4404bd2e6078e2f3c276 | Amount of donation or nature and value if donation in kind: £6,000 | Sponsorships 8f616a6e | 2012-03-19 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 24 | 2012-03-19-8f616a6e-24773-0 |
87d86b8198a2953bfa66f3f12e71739948747dc3 | Donor status: company | Sponsorships 8f616a6e | 2012-03-19 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 25 | 2012-03-19-8f616a6e-24773-0 |
7deaf6ecc47eb9e02e0f41069c484ee1e09c0aed | (Registered 11 May 2011) | Sponsorships 8f616a6e | 2012-03-19 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 26 | 2012-03-19-8f616a6e-24773-0 |
7d2e55e4806aaf2d2b29715c21c1218ba7598bf6 | Support in the capacity as an MP: | Sponsorships 8f616a6e | 2012-03-19 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 27 | 2012-03-19-8f616a6e-24773-0 |
811f394524eb030d0bfecf35cf3a57e058d2a320 | Name of donor: Christofferson, Robb & Company (UK) LLP | Sponsorships 8f616a6e | 2012-03-19 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 28 | 2012-03-19-8f616a6e-24773-0 |
4d1b0f45bd02901c7879cfa73eac384990655ed5 | Address of donor: 28 Queen Anne’s Gate, London SW1H 9AB | Sponsorships 8f616a6e | 2012-03-19 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 29 | 2012-03-19-8f616a6e-24773-0 |
5ebf344ac46bb21cac763b9f184a2388ea856ac1 | Amount of donation or nature and value if donation in kind: donation of £3,000 | Sponsorships 8f616a6e | 2012-03-19 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 30 | 2012-03-19-8f616a6e-24773-0 |
ca981d8f0ce1f3839d8bf90bfd620c579a7108fc | Date of receipt: 21 September 2011 | Sponsorships 8f616a6e | 2012-03-19 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 31 | 2012-03-19-8f616a6e-24773-0 |
999ce4b7959b8c06e366cee5eeeec5233e8e8a05 | Date of acceptance: 21 September 2011 | Sponsorships 8f616a6e | 2012-03-19 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 32 | 2012-03-19-8f616a6e-24773-0 |
7a6bc6adc17a9c255657ed095f368e23f6c65aaf | Donor status: company, registration number OC303662 | Sponsorships 8f616a6e | 2012-03-19 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 33 | 2012-03-19-8f616a6e-24773-0 |
24dddb498311db3c51a9d3932e9c3c485e9f0efa | (Registered 7 October 2011) | Sponsorships 8f616a6e | 2012-03-19 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 34 | 2012-03-19-8f616a6e-24773-0 |
dfde7614686180698c33c14af66e412df0a21f8a | Name of donor: Neil Record | Sponsorships 8f616a6e | 2012-03-19 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 35 | 2012-03-19-8f616a6e-24773-0 |
403d9ed5023a26d159a7685dcdd9214923042c36 | Address of donor: private | Sponsorships 8f616a6e | 2012-03-19 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 36 | 2012-03-19-8f616a6e-24773-0 |
1cf97cafef08c2d8b237ed055c5c242e48c4e2e7 | Amount of donation or nature and value if donation in kind: £4,000 | Sponsorships 8f616a6e | 2012-03-19 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 37 | 2012-03-19-8f616a6e-24773-0 |
c7f450e167f7bb952c771e70026138228f8485f7 | Date of receipt: 15 November 2011 | Sponsorships 8f616a6e | 2012-03-19 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 38 | 2012-03-19-8f616a6e-24773-0 |
5bacd9066a0fa0a36b3cdf4e4edb20e206761361 | Date of acceptance: 21 November 2011 | Sponsorships 8f616a6e | 2012-03-19 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 39 | 2012-03-19-8f616a6e-24773-0 |
3ea9ce722851516dd27544bd7d0df0c3842218d3 | Donor status: individual | Sponsorships 8f616a6e | 2012-03-19 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 40 | 2012-03-19-8f616a6e-24773-0 |
dbfb4029723b57f2036da15e6010b417748f679b | (Registered 25 November 2011) | Sponsorships 8f616a6e | 2012-03-19 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 41 | 2012-03-19-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");