items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
37 rows where record_id = "2011-10-31-8f616a6e-24773-0" sorted by sort_order descending
This data as json, CSV (advanced)
Suggested facets: date (date)
hash | item | category_id | date | member_id | person_id | sort_order ▲ | record_id |
---|---|---|---|---|---|---|---|
f6263f2e39c6a6d44e914ec5040133bfa2e6b9ba | (Registered 7 October 2011) | Sponsorships 8f616a6e | 2011-10-31 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 46 | 2011-10-31-8f616a6e-24773-0 |
d15556eae80a6c8dc7c93bab3b4709507013a49f | Donor status: company, registration number OC303662 | Sponsorships 8f616a6e | 2011-10-31 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 45 | 2011-10-31-8f616a6e-24773-0 |
f76908aa9efe4d7766c9161d3262079e2d9300a7 | Date of acceptance: 21 September 2011 | Sponsorships 8f616a6e | 2011-10-31 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 44 | 2011-10-31-8f616a6e-24773-0 |
50698429f056779656ef66a31758717e4252e290 | Date of receipt: 21 September 2011 | Sponsorships 8f616a6e | 2011-10-31 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 43 | 2011-10-31-8f616a6e-24773-0 |
cb95f7a3f6af3a2109a34dd971b6e343776305cb | Amount of donation or nature and value if donation in kind: donation of £3,000 | Sponsorships 8f616a6e | 2011-10-31 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 42 | 2011-10-31-8f616a6e-24773-0 |
52d8cdd4d5f36f6aeb93391a2a8bd5ef778ad16e | Address of donor: 28 Queen Anne’s Gate, London SW1H 9AB | Sponsorships 8f616a6e | 2011-10-31 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 41 | 2011-10-31-8f616a6e-24773-0 |
2b24d70b91134f2a43473f364534b306858bcedf | Name of donor: Christofferson, Robb & Company (UK) LLP | Sponsorships 8f616a6e | 2011-10-31 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 40 | 2011-10-31-8f616a6e-24773-0 |
dd53edb862de603cc99290bc9a44f7d1a87d721a | (Registered 6 December 2010) | Sponsorships 8f616a6e | 2011-10-31 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 39 | 2011-10-31-8f616a6e-24773-0 |
530baf9449ff8181ef55b38bad2635ead4f17f12 | Donor status: individual | Sponsorships 8f616a6e | 2011-10-31 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 38 | 2011-10-31-8f616a6e-24773-0 |
de52f7193dddc52de09a2af534b46f47ddc7db9b | Date of acceptance of donation: 19 November 2010 | Sponsorships 8f616a6e | 2011-10-31 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 37 | 2011-10-31-8f616a6e-24773-0 |
335e5d63c6227bcc5f964abd5128974e81473ab3 | Date of receipt of donation: 19 November 2010 | Sponsorships 8f616a6e | 2011-10-31 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 36 | 2011-10-31-8f616a6e-24773-0 |
8ff7b2ae858e3553df6b271a03b3d0388344bfd8 | Amount of donation or nature and value if donation in kind: £2,000 in support of travel costs in my capacity as an MP. | Sponsorships 8f616a6e | 2011-10-31 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 35 | 2011-10-31-8f616a6e-24773-0 |
6180d2c669a05ac86758d45ab5407225c91da451 | Address of donor : private | Sponsorships 8f616a6e | 2011-10-31 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 34 | 2011-10-31-8f616a6e-24773-0 |
b9fac9e119a596d300f2b0d747d8277c2c586ebd | Name of donor: Neil Record | Sponsorships 8f616a6e | 2011-10-31 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 33 | 2011-10-31-8f616a6e-24773-0 |
31ba2b79cc5d55a4782c45e957ba78298f6a0fab | Support in the capacity as an MP: | Sponsorships 8f616a6e | 2011-10-31 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 32 | 2011-10-31-8f616a6e-24773-0 |
41082ccd86fbda40e050cfe9cfab93fa208f75aa | (Registered 11 May 2011) | Sponsorships 8f616a6e | 2011-10-31 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 31 | 2011-10-31-8f616a6e-24773-0 |
8623de31a108ea6cc87df5aebf4e74208d3ed22d | Donor status: company | Sponsorships 8f616a6e | 2011-10-31 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 30 | 2011-10-31-8f616a6e-24773-0 |
e0ded9762669560a9b1f25143e3c36a726aadf6e | Amount of donation or nature and value if donation in kind: £6,000 | Sponsorships 8f616a6e | 2011-10-31 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 29 | 2011-10-31-8f616a6e-24773-0 |
fdb09c368ab599335148635fd5837fb675530303 | Address of donor: Terrace House, 125 High Street, Newmarket, Suffolk CB8 9BT | Sponsorships 8f616a6e | 2011-10-31 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 28 | 2011-10-31-8f616a6e-24773-0 |
0a416752b273e4446add9b7492a6620ed46f525f | Name of donor: Tattersalls Ltd | Sponsorships 8f616a6e | 2011-10-31 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 27 | 2011-10-31-8f616a6e-24773-0 |
628a0ff39dd81e53d09d1d2602a9356733f9e523 | Donor status: company | Sponsorships 8f616a6e | 2011-10-31 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 25 | 2011-10-31-8f616a6e-24773-0 |
0002f8a174064ddfc04948b98eea7b2fcfe2f2be | Amount of donation or nature and value if donation in kind: £10,000 | Sponsorships 8f616a6e | 2011-10-31 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 24 | 2011-10-31-8f616a6e-24773-0 |
d98bf4afc67074b0b6bbcddc5948f5d555ebb9ef | Address of donor: Duchess Drive, Newmarket, Suffolk CB8 8DP | Sponsorships 8f616a6e | 2011-10-31 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 23 | 2011-10-31-8f616a6e-24773-0 |
762d02d73a6f9aa8e23fdb9fa83a6e814304d273 | Name of donor: Cheveley Park Stud Ltd | Sponsorships 8f616a6e | 2011-10-31 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 22 | 2011-10-31-8f616a6e-24773-0 |
455a174b5036fef9df1baa094d90d12e0233ae35 | (Registered 22 March 2011) | Sponsorships 8f616a6e | 2011-10-31 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 21 | 2011-10-31-8f616a6e-24773-0 |
962d3ab326bbce9314661f41f69a2690d765f2e3 | Amount of donation or nature and value if donation in kind: £5,000 | Sponsorships 8f616a6e | 2011-10-31 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 19 | 2011-10-31-8f616a6e-24773-0 |
3a6d9b9334838b9369cba6e2a0c41c8335facc8d | Donor status: individual | Sponsorships 8f616a6e | 2011-10-31 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 15 | 2011-10-31-8f616a6e-24773-0 |
3ec22417b9361e3d8879846165032e2d772c00e1 | Address of donor: private | Sponsorships 8f616a6e | 2011-10-31 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 13 | 2011-10-31-8f616a6e-24773-0 |
c31b0b981315446e380a16b1b9e23da41ff36f8b | Name of donor: Kirsten Rausing | Sponsorships 8f616a6e | 2011-10-31 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 12 | 2011-10-31-8f616a6e-24773-0 |
4f926a1dfd3f986791594edd3b0177089f9d55a5 | Amount of donation or nature and value if donation in kind: £10,000 | Sponsorships 8f616a6e | 2011-10-31 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 9 | 2011-10-31-8f616a6e-24773-0 |
716ce950e982fd3dbc180e9a24b6cd550ed7c190 | Address of donor: Unex House, Church Lane, Stetchworth, Newmarket, Suffolk CB8 9TN | Sponsorships 8f616a6e | 2011-10-31 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 8 | 2011-10-31-8f616a6e-24773-0 |
bdb09eb5fb6c806ba6050ab3ef3b678000bf7509 | Name of donor: Bill Gredley | Sponsorships 8f616a6e | 2011-10-31 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 7 | 2011-10-31-8f616a6e-24773-0 |
636c51d4da1d14ca9e3c514e1d3c330b915b10f5 | (Registered 9 February 2011) | Sponsorships 8f616a6e | 2011-10-31 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 6 | 2011-10-31-8f616a6e-24773-0 |
ac419fc4e8380ccae67a45e862710311e0fc48d6 | Address of donor: Terrace House, 125 High Street, Newmarket, Suffolk CB8 9BT. | Sponsorships 8f616a6e | 2011-10-31 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 3 | 2011-10-31-8f616a6e-24773-0 |
040c85615ed2749d85f76cf0ac8665b70849003b | Name of donor: Tattersalls Ltd | Sponsorships 8f616a6e | 2011-10-31 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 2 | 2011-10-31-8f616a6e-24773-0 |
677a81ad0b19b1b764d565623e64f9ed33f1cbba | Sponsorships 8f616a6e | 2011-10-31 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 1 | 2011-10-31-8f616a6e-24773-0 | |
9202738009d88860b7fed7c9a2d4d205602aff2a | Donations to my constituency party or association, which have been or will be reported by my party to the Electoral Commission: | Sponsorships 8f616a6e | 2011-10-31 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 0 | 2011-10-31-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");