items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
25 rows where record_id = "2013-12-09-1f359ece-10574-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 |
---|---|---|---|---|---|---|---|
98cb9cdd99be4bda2ae59b1dba1b2a03cbe995c0 | Payments from News International Supply Co Ltd. Address: Cygnet Park, 200 Serpentine Way, Peterborough PE7 8FD: | Remunerated employment, office, profession etc 1f359ece | 2013-12-09 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 0 | 2013-12-09-1f359ece-10574-0 |
a7870f3b4fc260b6a168c727a8f3fba0aaf09128 | 24 December 2012, payment of £500 for article in The Times (5 December 2012). Hours: approx 4 hrs. (Registered 3 January 2013) | Remunerated employment, office, profession etc 1f359ece | 2013-12-09 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 1 | 2013-12-09-1f359ece-10574-0 |
103c60618d8c44887359d7fba6cec18086ec219c | 2 April 2013, received £360 for article in The Times on 20 March 2013. Hours: 2 hrs. (Registered 5 April 2013) | Remunerated employment, office, profession etc 1f359ece | 2013-12-09 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 2 | 2013-12-09-1f359ece-10574-0 |
f92ae0048cc25efae1cc97f3b2ec8c8d5e796e1c | 24 June 2013, received £500 for article in The Times on 10 June 2013. Hours: 4 hrs. (Registered 25 June 2013). | Remunerated employment, office, profession etc 1f359ece | 2013-12-09 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 3 | 2013-12-09-1f359ece-10574-0 |
5cacd9ee614d531b9157afb0d709b1978d420537 | 11 October 2012, received payment of £75 from The Guardian, Kings Place, 90 York Way, London N1 9GU for blog article on 25 September 2012. Hours: 3 hrs. (Registered 16 October 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-12-09 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 4 | 2013-12-09-1f359ece-10574-0 |
2efab8730d71d7504784722b50b8bc74352d6372 | Payments from Specialist Speakers, 18 Waxwell Lane, Harrow, London, HA5 3EN, UK | Remunerated employment, office, profession etc 1f359ece | 2013-12-09 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 6 | 2013-12-09-1f359ece-10574-0 |
d8d58ea5d2ce3600479d240844c2420691cd1bd8 | 23 November 2012, received £20,000 for speech at the University of Southern California "Global Conversation", Grosvenor Square, London, W1 on Tuesday 9 October 2012. Hours: 20 hrs. (Registered 17 December 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-12-09 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 7 | 2013-12-09-1f359ece-10574-0 |
2d7e0a3e2bdd0e58a3b0f2d3f40241227040f8d6 | 30 April 2013, received £3,000 for speaking on 5 December 2012 to the Performance and Reward Centre (PARC) at the Ivy Restaurant, Ivy St, London WC1. Hours: 5 hrs. (Registered 1 May 2013) | Remunerated employment, office, profession etc 1f359ece | 2013-12-09 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 8 | 2013-12-09-1f359ece-10574-0 |
0c6c9bbc9b0f5821e3b596e8630a9ac75758a622 | 5 July 2013, received £3,000 for speech to to Annual Conference of the Information and Records Management Society (of Chester House, 68 Chestergate, Macclesfield, Cheshire, SK11 6DY) held at the Metropole Hotel, Brighton, on 20 May 2013. Hours: 10 hrs. (Registered 19 July 2013) | Remunerated employment, office, profession etc 1f359ece | 2013-12-09 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 9 | 2013-12-09-1f359ece-10574-0 |
5843198055b1fda0fd5179cc8200bfb3c440f687 | Consultant to ED & F MAN Holdings Ltd; commodity traders, advising the group and its senior executives on the international and national environment in which it operates and on other specific matters. Address: Cottons Centre, Hays Lane, London SE1 2QE (£55,001-£60,000) Payment received on a quarterly basis. | Remunerated employment, office, profession etc 1f359ece | 2013-12-09 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 10 | 2013-12-09-1f359ece-10574-0 |
8c70c281af7126a88925d69672117517caf8e1b2 | 26 November 2012, received £15,000 consultancy fee for quarter 1 July to 30 September 2012. Hours: approx 30 hrs .(Registered 17 December 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-12-09 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 11 | 2013-12-09-1f359ece-10574-0 |
9dfd862e3a7ffe193a6c332d08e9d9c668c79151 | 8 January 2013, Received £15,000 consultancy fee for quarter 1 October to 31 December 2012. Hours: approx 35 hrs. (Registered 19 February 2013) | Remunerated employment, office, profession etc 1f359ece | 2013-12-09 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 12 | 2013-12-09-1f359ece-10574-0 |
c61ade8e54c72d4683db1a9e0597fd12166182cf | 8 April 2013, received £15,000 consultancy fee for quarter 1 January to 31 March 2013. Hours: approx 45 hrs. (Registered 15 April 2013) | Remunerated employment, office, profession etc 1f359ece | 2013-12-09 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 13 | 2013-12-09-1f359ece-10574-0 |
e52376411e3871b612be78f7333e7726a305df98 | 2 July 2013, received £15,000 consultancy fee for the quarter 1 April to 30 June 2013. Hours: 7 days. (Registered 4 July 2013) | Remunerated employment, office, profession etc 1f359ece | 2013-12-09 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 14 | 2013-12-09-1f359ece-10574-0 |
d9fb175f5d69f58a259e0576a1b4485c1847c25e | 8 October 2013, received £15,000 consultancy fee for the quarter 1 July 2013 to 30 September 2013. Hours: 80 hrs. (Registered 8 October 2013) | Remunerated employment, office, profession etc 1f359ece | 2013-12-09 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 15 | 2013-12-09-1f359ece-10574-0 |
b23cb411f43e253d252f0aab487470bf60cd5247 | Advances for the manuscript of a book from Macmillans Publishers, via Capel & Land Ltd, Literary Agents. Address of Macmillans: 20 New Wharf Road London N1 9RR: | Remunerated employment, office, profession etc 1f359ece | 2013-12-09 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 16 | 2013-12-09-1f359ece-10574-0 |
25b4ba4b366bcb0c061397c90a81ff1c0f7ff522 | 30 April 2013, received £1,230 net of agent’s commission, in respect of the audio recording of my book. Hours: 60 hrs. (Registered 1 May 2013) | Remunerated employment, office, profession etc 1f359ece | 2013-12-09 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 17 | 2013-12-09-1f359ece-10574-0 |
66d3b5e852f1d22089556bef236f2eb11b137915 | 4 June 2013, received £29,473.80, net of agent’s commission, as final payment of advance on book. Hours between 10 October 2012 and 4 July 2013: at least 100 hrs (mainly at literary festivals). (Registered 4 July 2013) | Remunerated employment, office, profession etc 1f359ece | 2013-12-09 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 18 | 2013-12-09-1f359ece-10574-0 |
9a9c1f1506c95d9f46af7d084f7529de3fc27465 | Remunerated employment, office, profession etc 1f359ece | 2013-12-09 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 19 | 2013-12-09-1f359ece-10574-0 | |
ab0889fdf840fe572d57b55db4373a78d175e403 | Payments for articles from the Telegraph Media Group, 111 Buckingham Palace Road, London SW1W 0DT: | Remunerated employment, office, profession etc 1f359ece | 2013-12-09 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 20 | 2013-12-09-1f359ece-10574-0 |
8b8d299eebd530d4398d57125e21debb1334784b | 8 March 2013, received £480 for Daily Telegraph article on 26 February 2013. Hours: 6 hrs. (Registered 5 April 2013) | Remunerated employment, office, profession etc 1f359ece | 2013-12-09 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 21 | 2013-12-09-1f359ece-10574-0 |
9b5b81da6dd2527d8575c677cd049358377b927a | 28 June 2013, received £320 for Daily Telegraph article on 17 June 2013. Hours: 5 hrs. (Registered 4 July 2013) | Remunerated employment, office, profession etc 1f359ece | 2013-12-09 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 22 | 2013-12-09-1f359ece-10574-0 |
ca7b874b3751427b2ed6a96c708deea64a21e712 | 12 July 2013, received £330 for article on 2 July 2013. Hours: 3 hrs. (Registered 19 July 2013) | Remunerated employment, office, profession etc 1f359ece | 2013-12-09 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 23 | 2013-12-09-1f359ece-10574-0 |
bb5a03247ac307114430e7b3e66c6639864b739c | 30 September 2013, received £800 from Associated Newspapers Ltd of 2 Derry Street, London W8 5TT for article in the Daily Mail on 17 September 2013. Hours: 5 hrs. (Registered 8 October 2013) | Remunerated employment, office, profession etc 1f359ece | 2013-12-09 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 24 | 2013-12-09-1f359ece-10574-0 |
938bc5d7be5dfb910045848531fb469e07657df4 | 28 October 2013, received £150 from the Edinburgh International Book Festival, 5A Charlotte Square, Edinburgh EH2 4DR, for speaking at a Festival event on 14 August 2013, in Charlotte Square, Edinburgh. Hours: 4 hrs. (Registered 18 November 2013) | Remunerated employment, office, profession etc 1f359ece | 2013-12-09 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 25 | 2013-12-09-1f359ece-10574-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");