items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
26 rows where record_id = "2013-09-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 |
---|---|---|---|---|---|---|---|
f98858c091a1b29b809b006b26613e129122f770 | Payments from News International Supply Co Ltd. Address: Cygnet Park, 200 Serpentine Way, Peterborough PE7 8FD: | Remunerated employment, office, profession etc 1f359ece | 2013-09-09 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 0 | 2013-09-09-1f359ece-10574-0 |
a97b4216524b998914c524d4c893acb63a43461d | 10 October 2012, payment of £400 for article in The Times (18 September 2012). Hours: 5 hrs. (Registered 16 October 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-09-09 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 1 | 2013-09-09-1f359ece-10574-0 |
f994db9603398a3047e2d6867fbbb36c874b35df | 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-09-09 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 2 | 2013-09-09-1f359ece-10574-0 |
a226d6eb9b8f1698f5f4be895fd11e0253fb70c3 | 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-09-09 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 3 | 2013-09-09-1f359ece-10574-0 |
19b5b84bbb266f95b386456b72ff4d43aef8dbf1 | 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-09-09 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 4 | 2013-09-09-1f359ece-10574-0 |
7f11f967f70ed49c3cb19a718ae7bd60825c34b9 | 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-09-09 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 5 | 2013-09-09-1f359ece-10574-0 |
bf78df42d464d51c4f9d8f964f19f9d2d9286115 | Payments from Specialist Speakers, 18 Waxwell Lane, Harrow, London, HA5 3EN, UK | Remunerated employment, office, profession etc 1f359ece | 2013-09-09 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 7 | 2013-09-09-1f359ece-10574-0 |
5d9fc5847b84d499204d836d6371b5da3f3703b2 | 23 August 2012, received £7,500 for speaking at the Security Watch Asia event, QE II Centres, London SW1 on 25 June 2012, organised by Security Watch UK Ltd, 1 Queen Anne’s Gate, 2nd Floor Westminster, London, SW1H 9BT . Hours: 6 hrs. (Registered 5 September 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-09-09 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 8 | 2013-09-09-1f359ece-10574-0 |
d56f4b8398d4b8a7db1ba505bed62868dd1ef17f | 23 August 2012, received £8,000 fee and travel and accommodation with an estimated value of £7,900 for speaking at the Annual Meeting of the International Association of Defence Counsel (of 303 West Madison Avenue, Suite 925, Chicago, Il, USA 60606), held in Asheville, NC, USA, on 9 July 2012. Hours: 3 days. (Registered 9 September 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-09-09 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 9 | 2013-09-09-1f359ece-10574-0 |
6d8c6b04d86df4ed29a087623c902487c970e78d | 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-09-09 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 10 | 2013-09-09-1f359ece-10574-0 |
b8336a981228a382ebf908795c2d6af96ac160e1 | 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-09-09 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 11 | 2013-09-09-1f359ece-10574-0 |
06a967a3cdf6c4abec2f90ba930049ea4903b628 | 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-09-09 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 12 | 2013-09-09-1f359ece-10574-0 |
c48e19f5af2f7e4ca069931360cbe637db707809 | 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-09-09 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 14 | 2013-09-09-1f359ece-10574-0 |
1fc093a06dfe618265c64c94a9aaf53490290a97 | 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-09-09 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 15 | 2013-09-09-1f359ece-10574-0 |
593832b9e07c8bb16377df5c12a8d33d22dd4bf8 | 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-09-09 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 16 | 2013-09-09-1f359ece-10574-0 |
47cd8c79912f2d0cb11cd8f9d94dc03b04a68b95 | 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-09-09 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 17 | 2013-09-09-1f359ece-10574-0 |
2047b305f4a1e1d7278c5ca2a32b01fc0cb9e85d | 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-09-09 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 18 | 2013-09-09-1f359ece-10574-0 |
403ca2168ea9a36d01cf8903a366ab8c9a2cbc76 | 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-09-09 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 19 | 2013-09-09-1f359ece-10574-0 |
d8fe0b911f42e7e5c55dc157f5706bd1dd3d0c82 | 9 October 2012, received £30,750 as publication advance. Hours: at least 200 hours between 31 July and 9 October 2012. (Registered 16 October 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-09-09 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 20 | 2013-09-09-1f359ece-10574-0 |
b9bec1aa612d7720a5e016f81abe0c3602918714 | 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-09-09 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 21 | 2013-09-09-1f359ece-10574-0 |
2cfc58484bc1e07a4f928dc64c744809e5c4b8e2 | 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-09-09 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 22 | 2013-09-09-1f359ece-10574-0 |
d4f193c5b3bc55592acdaf5ee11aa6ae6b42a3e1 | Remunerated employment, office, profession etc 1f359ece | 2013-09-09 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 23 | 2013-09-09-1f359ece-10574-0 | |
be3d52572026fd09be79307377bf650e2b5d5a81 | Payments for articles from the Telegraph Media Group, 111 Buckingham Palace Road, London SW1W 0DT: | Remunerated employment, office, profession etc 1f359ece | 2013-09-09 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 24 | 2013-09-09-1f359ece-10574-0 |
4845b305a47f2b7a67997d71c1e4719d1a2d1823 | 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-09-09 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 25 | 2013-09-09-1f359ece-10574-0 |
eb39779dac199da991f57e57403e1c82878caa4b | 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-09-09 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 26 | 2013-09-09-1f359ece-10574-0 |
527ab8bb9f3f206cd52901d641a537dac8397dff | 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-09-09 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 27 | 2013-09-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");