items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
26 rows where record_id = "2010-03-10-1f359ece-10465-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 |
---|---|---|---|---|---|---|---|
3ae1095a082a780e60829d95e77c74f92fd9cdb9 | Parliamentary adviser to the Caravan Club of Great Britain. (£5,001-£10,000) | Remunerated employment, office, profession etc 1f359ece | 2010-03-10 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 0 | 2010-03-10-1f359ece-10465-0 |
05212ca99253a6f02b7da2b28e3235df50f7e227 | 16 January 2010, payment of £6000. Hours: 100 hrs. (Registered 2 February 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-03-10 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 1 | 2010-03-10-1f359ece-10465-0 |
28850f7fad315df8595beed93570621a979b0e35 | Training for the National School of Government. (Up to £5,000) | Remunerated employment, office, profession etc 1f359ece | 2010-03-10 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 2 | 2010-03-10-1f359ece-10465-0 |
12c53cd73d3d02bff7b59f106d38f785f3bcfa54 | Broadcasting fees from the BBC. (Up to £5,000) | Remunerated employment, office, profession etc 1f359ece | 2010-03-10 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 3 | 2010-03-10-1f359ece-10465-0 |
5940247cd18c7bdfd6fec727545f214e4818a120 | Fees from ITV for television appearances. (£5,001-£10,000) | Remunerated employment, office, profession etc 1f359ece | 2010-03-10 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 4 | 2010-03-10-1f359ece-10465-0 |
f0cbcab90233c096590c69b9a86fb93434233c8d | Fees for training work for Luther Pendragon. | Remunerated employment, office, profession etc 1f359ece | 2010-03-10 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 5 | 2010-03-10-1f359ece-10465-0 |
1e340ff7dd7dea65d4c483d58c857fb629ba11fe | Journalism for the Daily Sport. (Up to £5,000) | Remunerated employment, office, profession etc 1f359ece | 2010-03-10 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 6 | 2010-03-10-1f359ece-10465-0 |
b7812fdba96f26037d3488f10a9b278e289447ab | July 2009, received payment of £1600. Hours: 8 hrs. (Registered 2 February 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-03-10 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 7 | 2010-03-10-1f359ece-10465-0 |
72ebcec9098e1ec4f9398882f0ba866f8f036d75 | August 2009, received payment of £1600. Hours: 8 hrs. (Registered 2 February 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-03-10 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 8 | 2010-03-10-1f359ece-10465-0 |
ca4548490ab94a3c7b87515808dc05eb78b137a1 | September 2009, received payment of £1600. Hours: 8 hrs. (Registered 2 February 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-03-10 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 9 | 2010-03-10-1f359ece-10465-0 |
36e33fb1d365020ad2c76e75e843e829167a71b6 | October 2009, received payment of £1600. Hours: 8 hrs. (Registered 2 February 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-03-10 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 10 | 2010-03-10-1f359ece-10465-0 |
f3b12b22b7dcbbde253da520467fe3ff88bd74ad | November 2009, received payment of £1600. Hours: 8 hrs. (Registered 2 February 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-03-10 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 11 | 2010-03-10-1f359ece-10465-0 |
5580c02fb6a30cdff28cd3ff4d0c8e441afa72f2 | December 2009, received payment of £1600. Hours: 8 hrs. (Registered 2 February 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-03-10 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 12 | 2010-03-10-1f359ece-10465-0 |
e7c918b1a8c8262eed0f6b3b5f37df337755cb0e | January 2010, received payment of £1600. Hours: 8 hrs. (Registered 2 February 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-03-10 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 13 | 2010-03-10-1f359ece-10465-0 |
24fe82247c563c7a8f415758adbc2b3974401a2f | Payments for articles for Mail on Sunday newspaper, Associated Newspapers Ltd, 2 Derry Street, London W8 5TT: | Remunerated employment, office, profession etc 1f359ece | 2010-03-10 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 14 | 2010-03-10-1f359ece-10465-0 |
39719c81061945fb93038526678a15febf76a4e7 | £1000, 13 August 2009. Hours: 6 hrs. (Registered 2 February 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-03-10 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 15 | 2010-03-10-1f359ece-10465-0 |
eac0aebed1243cfa38670e57bd04f42164e17434 | £1000, 2 September 2009. Hours: 6 hrs. (Registered 2 February 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-03-10 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 16 | 2010-03-10-1f359ece-10465-0 |
2ab63d3501b780ca72b98b76ed1f46c38f560ce6 | £20,000 received 9 March 2009. Hours: 40 hrs. (Registered 4 March 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-03-10 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 17 | 2010-03-10-1f359ece-10465-0 |
d850e19082d18a54886b5dbc988d88073854e043 | Television appearances arranged via Personal Appearances, 20 North Mount, 1147-1161 High Road, Whetstone, London N20 OPH: | Remunerated employment, office, profession etc 1f359ece | 2010-03-10 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 18 | 2010-03-10-1f359ece-10465-0 |
acb5ec4f46001aec43d7e60081148127cd0f75b8 | £1000, 'Cash in the Attic', 9 June 2009. Hours: 8 hrs. (Registered 2 February 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-03-10 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 19 | 2010-03-10-1f359ece-10465-0 |
5446110a6709129773a5501134b469a83f772965 | £984, 'The King is Dead', 31 July 2009. Hours: 3 hrs. (Registered 2 February 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-03-10 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 20 | 2010-03-10-1f359ece-10465-0 |
e4a327b8784eca0a26456553d52979e9a6e90eca | £400, 'Big Brothers Little Brother', 11 August 2009. Hours: 1 hr. (Registered 2 February 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-03-10 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 21 | 2010-03-10-1f359ece-10465-0 |
af69ede2d7097fb03baf5972b0db24bca1d70390 | £191.25, 'The End of the Year Show', 30 October 2009. Hours: 2 hrs. (Registered 9 February 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-03-10 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 22 | 2010-03-10-1f359ece-10465-0 |
8749d733a99b5ae88e19a3bb91318f6c3562835b | Payment of £150 for political seminar for GovNet Communications, 3 rd Floor, St James Buildings, 79 Oxford Street, Manchester M1 6PP, 23 July 2009. Hours: 1 hr. (Registered 2 February 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-03-10 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 23 | 2010-03-10-1f359ece-10465-0 |
5d684ca82699dec6fd4986abe2660aa2587c6d1e | Payment of £2000 (plus £390 food and accommodation) for after dinner speech and informal seminar for Avery Healthcare Ltd, 1b Basset Court, Loake Close, Grange Park, Northampton NN4 5EZ, 24 November 2009. Hours: 4 hrs. (Registered 2 February 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-03-10 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 24 | 2010-03-10-1f359ece-10465-0 |
76635fb4f411d08411b905a490e3beef65c7aa10 | Speaking engagement for (Cunard) Carnival plc, 5 Gainsford Street, London SE1 2NE, 29 November-4 December 2009. Hospitality, accommodation and travel to the value of £5752. Hours: 10 hrs. (Registered 2 February 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-03-10 | Lembit Öpik uk.org.publicwhip/member/1720 | Lembit Öpik uk.org.publicwhip/person/10465 | 25 | 2010-03-10-1f359ece-10465-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");