items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
7 rows where record_id = "2012-09-03-1f359ece-24773-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 |
---|---|---|---|---|---|---|---|
af0b452073a497f4f0a4f46546df716d03243033 | Payment of £2,081.70, including travel expenses,from JLA, 80 Great Portland Street, London W1W 7NW, for speech to ACCA UK in Norwich. Hours: 10 hrs. (Registered 3 November 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-09-03 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 0 | 2012-09-03-1f359ece-24773-0 |
a8158ebaa16d5d63f3a0c5dd0a01318679f4b27b | Payment of £3,000 from UBS AG, 100 Liverpool Street, London EC2M 2BH, for speech to senior investors. Hours: 8 hrs. (Registered 25 November 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-09-03 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 1 | 2012-09-03-1f359ece-24773-0 |
c4a6be3037ea7ebefc055692acee2d1f18e770f9 | Payment of £199.95 (fee and expenses) from BBC, Broadcasting House, Portland Place, London W1A 1AA, for taking part in BBC Radio 4 ‘Any Questions?’ panel. Hours: 4 hrs. (Registered 8 December 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-09-03 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 2 | 2012-09-03-1f359ece-24773-0 |
84f96fedd4a96e0912e5d3f7f0bb8086c26f5233 | £500 from Ipsos MORI, 79-81 Borough Road, London SE1 1FY, for article. Hours: 4 hrs. Payment made direct to local organisation. (Registered 19 January 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-09-03 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 3 | 2012-09-03-1f359ece-24773-0 |
8602ff19e8694144d3acc1eeb41e1acf44df6f36 | Payment of £160 from Institute of Arts and Ideas for expenses incurred for making a speech at Hay HowTheLightGetsIn Festival on 9 June 2012. Hours: 3 hrs. Address: 375 City Road, London EC1V 1NB. (Registered 11 July 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-09-03 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 4 | 2012-09-03-1f359ece-24773-0 |
cff45750279fa4fc259a42391f1d780f64b20b77 | Payment of £2,000 from Redburn Partners LLP, 75 King William Street, London EC4N 7BE, for speaking at the Redburn Banking Recovery Conference. Hours: 2 hrs. (Registered 20 August 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-09-03 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 5 | 2012-09-03-1f359ece-24773-0 |
8f5122450c23fc3659336ef893e69c073a52e14f | Payment of £250 from Daily Mail, Northcliffe House, 2 Derry Street, London W8 5TT, for an article. Address of payer: A&N Media Finance Service, PO Box 6795, St George Street, Leicester LE1 1ZP. Hours: 2 hrs. (Registered 21 August 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-09-03 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 6 | 2012-09-03-1f359ece-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");