items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
7 rows where "date" is on date 2009-09-02 and person_id = "uk.org.publicwhip/person/10022" sorted by date descending
This data as json, CSV (advanced)
Suggested facets: category_id, sort_order, record_id, date (date)
hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
e6c0ed0b35dd5a6cc61eddb6249c6f3bf99e2dd1 | Fees from the Centre for Management and Policy Studies for lectures given to civil servants. | Remunerated employment, office, profession etc 1f359ece | 2009-09-02 | Norman Baker uk.org.publicwhip/member/1680 | Norman Baker uk.org.publicwhip/person/10022 | 0 | 2009-09-02-1f359ece-10022-0 |
1f1e66e1e86735774c6b974ff68466eba6ecb735 | Ongoing income from royalties for publication of book entitled 'The Strange Death of David Kelly'. | Remunerated employment, office, profession etc 1f359ece | 2009-09-02 | Norman Baker uk.org.publicwhip/member/1680 | Norman Baker uk.org.publicwhip/person/10022 | 1 | 2009-09-02-1f359ece-10022-0 |
8c52d953b6c641ade75b32d044c17705b493f629 | 27 July 2009, received payment of £200 for giving talk and taking questions at event organised by Glastonbury Symposium, Ivy Cottage, Stawell, Somerset, TA7 9AA. Hours: 1hr 30mins. (Registered 10 August 2009) | Remunerated employment, office, profession etc 1f359ece | 2009-09-02 | Norman Baker uk.org.publicwhip/member/1680 | Norman Baker uk.org.publicwhip/person/10022 | 2 | 2009-09-02-1f359ece-10022-0 |
cee887ea50e12d901a8d8823dc99c1e17b8f3d73 | 3 August 2009, received payment of £50 for telephone interview with FACTS International Ltd, Facts Centre, 3 Henwood, Ashford, Kent, TN24 8FL. Hours: 30mins. (Registered 7 August 2009) | Remunerated employment, office, profession etc 1f359ece | 2009-09-02 | Norman Baker uk.org.publicwhip/member/1680 | Norman Baker uk.org.publicwhip/person/10022 | 3 | 2009-09-02-1f359ece-10022-0 |
7a7fd05580fffec8d511c31bde1cd67eb04d1101 | 14 July 2009, received payment of £150 for speaking and taking questions at seminar organised by Dods Parliamentary Communications, Westminster Tower, 3 Albert Embankment, London, SE1 7SP. Hours: 1hr. (Registered 5 August 2009) | Remunerated employment, office, profession etc 1f359ece | 2009-09-02 | Norman Baker uk.org.publicwhip/member/1680 | Norman Baker uk.org.publicwhip/person/10022 | 4 | 2009-09-02-1f359ece-10022-0 |
51a3c6ca8ce9b06dd314128a42be473944909fe9 | 30 July 2009, received payment of £50 for taking part in a TV talk/debate show arranged by Press TV Ltd, Level 1, Westgate House, West Gate, Ealing, London, W5 1YY. Hours: 1.5hrs. (Registered 28 August 2009) | Remunerated employment, office, profession etc 1f359ece | 2009-09-02 | Norman Baker uk.org.publicwhip/member/1680 | Norman Baker uk.org.publicwhip/person/10022 | 5 | 2009-09-02-1f359ece-10022-0 |
df958b0dfb353bc8c1698c2b76f2c1cc04b526ea | 6-11 September 2008, to Dharamsala, India, to visit the Tibetan Government-in-exile in my capacity as the Vice-Chair of the All-Party Parliamentary Group for Tibet and as President of the Tibet Society. The costs of my travel were met by the Tibet Society and my accommodation by the Tibetan Government-in-exile. (Registered 2 October 2008) | Overseas visits 80ef1083 | 2009-09-02 | Norman Baker uk.org.publicwhip/member/1680 | Norman Baker uk.org.publicwhip/person/10022 | 0 | 2009-09-02-80ef1083-10022-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");