items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
8 rows where record_id = "2012-10-01-1f359ece-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 |
---|---|---|---|---|---|---|---|
eb90dae0b0427fd4952c2736d6e4e36c024e6cb0 | 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-10-01 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 0 | 2012-10-01-1f359ece-24773-0 |
9d566f14e7c40a2ad37cae90a8f1a05c1dcffbc1 | 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-10-01 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 1 | 2012-10-01-1f359ece-24773-0 |
0009894f8968f232f5577745971041560e4e1e4d | 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-10-01 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 2 | 2012-10-01-1f359ece-24773-0 |
9819c611b08c32f5f8e0e842aac4f3f27e6f48d8 | £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-10-01 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 3 | 2012-10-01-1f359ece-24773-0 |
ecf8950f5ac5d1cb4438ec3acdfd65f1997fa62f | 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-10-01 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 4 | 2012-10-01-1f359ece-24773-0 |
90ed6cf7423e931c33ca16405d3c5569b0e35dad | 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-10-01 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 5 | 2012-10-01-1f359ece-24773-0 |
3234c69cd1b5b91ba8daa11fd677bcb89d6d8c52 | 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-10-01 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 6 | 2012-10-01-1f359ece-24773-0 |
129e3879b039437ce0abdde9f8c63034d7d12621 | Payment of £2,761.39 received during the period 1 August 2011 to 28 September 2012 for sales of book (which I co authored). Publisher: Biteback Publishing, 3 Albert Embankment, London SE1 7SP . Hours: impossible to estimate accurately. (Registered 28 September 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-10-01 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 7 | 2012-10-01-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");