items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
38 rows where record_id = "2012-03-19-1f359ece-10574-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 |
---|---|---|---|---|---|---|---|
fe06383fe5dfe8c120d28073529fd57c00ddd183 | Payments from News International Supply Co Ltd. Address: Cygnet Park, 200 Serpentine Way, Peterborough PE7 8FD: | Remunerated employment, office, profession etc 1f359ece | 2012-03-19 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 0 | 2012-03-19-1f359ece-10574-0 |
05a0b3bddb9aa4bb0fd2934c5b8ab787bc54ba65 | 6 December 2010, payment of £300 for article in The Times, 13 November 2010. Hours: 2 hrs, plus indeterminate amount of time researching the article. (Registered 29 March 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-03-19 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 1 | 2012-03-19-1f359ece-10574-0 |
eb95c5e56f5ce669c746719daa7a01b31c103951 | 7 March 2011, payment of £500 for article in The Times, 10 February 2011. Hours: 4 hrs, plus indeterminate amount of time researching the article. (Registered 29 March 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-03-19 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 2 | 2012-03-19-1f359ece-10574-0 |
457a7dd70b50d67222e35d8428b49908f3fdf9da | 28 March 2011, payment of £700 for book review for The Times, 12 November 2010. Hours: approx 12-15 hrs. (Registered 29 March 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-03-19 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 3 | 2012-03-19-1f359ece-10574-0 |
50d4b1fa0ffedb6d7d739d64034eae646c4d20fb | 28 March 2011, payment of £650 for book review for The Times, 26 February 2010. Hours: approx 10-12 hrs. (Registered 29 March 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-03-19 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 4 | 2012-03-19-1f359ece-10574-0 |
a6842dc902bf6e78a9d9ce196e17cedf30dcbe21 | 28 March 2011, payment of £500 for article in The Times, 5 March 2011. Hours: 4-5 hrs, plus indeterminate amount of time researching the article. (Registered 29 March 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-03-19 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 5 | 2012-03-19-1f359ece-10574-0 |
52f3ed9d03bc3c1b081409ae7f58d49e84b0d5fc | 26 April 2011, payment of £500 for column in The Times, 28 March 2011. Hours: approx 4 hrs, plus an indeterminate time preparing and thinking about the article. (Registered 14 June 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-03-19 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 6 | 2012-03-19-1f359ece-10574-0 |
89ab8675da7688ba3fdd09ddee8fff7b25fdd9cf | 15 May 2011, payment of £500 for column in The Times, 26 April 2011. Hours: approx 4 hrs, plus an indeterminate time preparing and thinking about the article. (Registered 14 June 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-03-19 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 7 | 2012-03-19-1f359ece-10574-0 |
644249e9fedabc8e49dee82ac2800be085007c2b | 23 May 2011, payment of £500 for column in The Times, 4 May 2011. Hours: approx 4 hrs, plus an indeterminate time preparing and thinking about the article. (Registered 14 June 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-03-19 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 8 | 2012-03-19-1f359ece-10574-0 |
b09473e6bf7b22be1258528a51cf903814aeb517 | 6 June 2011, payment of £500 for column in The Sun, 19 May 2011. Hours: 3 hrs. (Registered 14 June 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-03-19 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 9 | 2012-03-19-1f359ece-10574-0 |
f4cb66a1f58a38f65dbcac4b7ee751829c137269 | 13 June 2011, payment of £500 for book review for The Times, May 2011. Hours: 12 hrs. (Registered 14 June 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-03-19 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 10 | 2012-03-19-1f359ece-10574-0 |
616864e562af0ad077cdc712a36577ffff03d84b | 4 July 2011, payment of £500 for article for The Sun on car insurance. ours: 3 hrs. Hours: 3 hrs. (Registered 3 October 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-03-19 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 11 | 2012-03-19-1f359ece-10574-0 |
5f80f45cc0ee7d0591efea69d99ad0f2237d90d9 | 11 July 2011, payment of £500 for article for The Times on Turkey. Hours: 4 hrs. (Registered 3 October 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-03-19 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 12 | 2012-03-19-1f359ece-10574-0 |
db3fab318db69dc3bd7f44310f27d1307cf8f7f0 | 11 July 2011, payment of £500 for article for The Times on car insurance. Hours: 12 hrs. (Registered 3 October 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-03-19 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 13 | 2012-03-19-1f359ece-10574-0 |
baa50f53b63ad123b1c5714ebd60b3f4ada7dd9d | 1 August 2011, payment of £500 for article for The Times on press regulation Hours: 5 hrs. (Registered 3 October 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-03-19 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 14 | 2012-03-19-1f359ece-10574-0 |
85ca271bed4d81de85ec038bded1afc114063d29 | 16 January 2012, payment of £500 for article in The Times on 4 January 2012. Hours: 3 hrs. (Registered 17 January 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-03-19 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 15 | 2012-03-19-1f359ece-10574-0 |
16eb7c8c9ec651f227e738eeab9df2f99347861d | 22 December 2011, received payment of £360 from the Daily Telegraph for article of 7 December 2011. Address: 111 Buckingham Palace Road, London SW1W 0DT. Hours: 2 hrs. (Registered 4 January 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-03-19 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 16 | 2012-03-19-1f359ece-10574-0 |
f79a2956d254db38926d367871cda197a6290b43 | 4 April 2011, payment of £500 for book review for Prospect Magazine, 2 Bloomsbury Place, London WC1A 2QA. Hours: approx 10-12 hrs. (Registered 4 April 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-03-19 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 17 | 2012-03-19-1f359ece-10574-0 |
dec1585e94e08dd3cb4173efa9824c48c22fd011 | 15 April 2011, received fee of £2,000 for participating in a Government of Turkey conference on foreign policy in Istanbul on 24 March 2011. I was accompanied by my wife. Our travel to Ankara and Istanbul and accommodation and meals from 23-28 March 2011 were paid by the Government of Turkey; total cost £2,910. Time taken, including travel and preparation, three days. (Registered 3 May 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-03-19 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 18 | 2012-03-19-1f359ece-10574-0 |
70f2052a738df0f36ae0e0e42ae2779a0e57f338 | 15 April 2011, received fee of £6,000 for speaking at the ECOBuild Exhibition, London, on 3 March 2011. Address of payer: IBE Limited/Ecobuild, 1 Great Winchester Street, London EC2N 2DB. Hours: 10 hrs. (Registered 3 May 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-03-19 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 19 | 2012-03-19-1f359ece-10574-0 |
b66978949e1b8c83020c97b44ff9cf4d82b4f123 | 2 August 2011, received payment of £750 from The Guardian, Kings Place, 90 York Way, London N1 9GU for book review of Alistair Campbell diaries. Hours: 8 hrs. (Registered 3 October 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-03-19 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 20 | 2012-03-19-1f359ece-10574-0 |
46d24934370d652e527a70fac8a6f24c329dde3e | Payments from Specialist Speakers, 18 Waxwell Lane, Harrow, London, HA5 3EN, UK | Remunerated employment, office, profession etc 1f359ece | 2012-03-19 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 21 | 2012-03-19-1f359ece-10574-0 |
c55188cc8d49d9e717682fa35131cb71c834d6ea | May 2011, received £7,000 for speaking to conference organised by Permira, a private equity firm, on 12 May 2011. Hours: 12 hrs. (Registered 3 October 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-03-19 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 22 | 2012-03-19-1f359ece-10574-0 |
4e10d312ee254f1be71184b41d3061e34263bfa1 | 2 November 2011, fee of £4,000 for speaking engagement on 28 September 2011 for Crashworth Ltd (of Glebe View, Wolvey Lodge Farm, Cloudesley Bush Road, Wolvey, Leics, LE10 3 HB), The Commonwealth Club, London WC2N. Hours: 4 hrs. (Registered 16 November 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-03-19 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 23 | 2012-03-19-1f359ece-10574-0 |
e485b44aa81d0784c7614cbf1ae5540ad748587f | 2 November 2011,fee of £4,500 in respect of speaking engagement on 12 October 2011for Inclusive Media Ltd (of 32-34 Broadwick St W1A 2HG) , publishers of Post Magazine at Victoria Plaza Hotel, London, SW1V 1EQ. Hours: 4 hrs. (Registered 16 November 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-03-19 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 24 | 2012-03-19-1f359ece-10574-0 |
3406bb791c92d4edfdc55f51186a30b918c38241 | Flights costing £4,480 and sundries of £76.36 received in respect of speaking engagements for International Stability Operations Association, 1634 I Street NW, Washington DC 2006, USA, "Annual Summit", the Ronald Reagan Centre, Washington DC, USA from 24 to 26 October 2011. Hours: 3 days. (Registered 17 November 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-03-19 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 25 | 2012-03-19-1f359ece-10574-0 |
1170e9e511970cfab53dfbc2e750ca54210b79fd | 7 December 2011, received fee of £9,000 in respect of speaking engagement for International Stability Operations (see above). (Registered 11 December 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-03-19 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 26 | 2012-03-19-1f359ece-10574-0 |
4f918b5225a5ca9114a99b899890862e9bb99f1e | 25 November 2011, received fee of £4,000 in respect of speaking engagement on 10 November 2011 for Mobile Doctors Ltd (of 4 Bourne Court, Southend Road, Woodford Green, Essex IG8 8HD) at the Abode Hotel, 107 Piccadilly Manchester M1 2DB. Hours: 12 hrs (Registered 30 November 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-03-19 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 27 | 2012-03-19-1f359ece-10574-0 |
a37c1daf2c90f09a3d461abf2622d6b4807ed282 | 25 November 2011, received fee of £4,000 in respect of speaking engagement on 1 November 2011 for a conference organised by ABP [AutoBodiesProfessional] Club Ltd (PO Box 8338, Kirby Muxloe, Leicestershire, LE9 2WW) in Warwickshire. Hours: 7 hrs (Registered 30 November 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-03-19 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 28 | 2012-03-19-1f359ece-10574-0 |
279f1b4988064a3aebf27b28fdd268bdf6724d4f | 7 December 2011, received fee of £5,750 in respect of speaking engagement on 9 November 2011 for MSL Capital (of 81 Whitfield St, London W1T 4HG) at 10 Gresham St, London EC2V 7JD. Hours: 4 hrs. (Registered 11 December 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-03-19 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 29 | 2012-03-19-1f359ece-10574-0 |
2fb4c2b2dd983c3ef8e8bf3585a7b6ea64576c67 | 24 February 2012, received fee of £4,000 in respect of speaking engagement on 22 November 2011 for Brokerbility of AGM House, 3 Barton Close, Grove Park, Enderby, Leicester LE19 1SJ at Leicester Marriott Hotel. Hours: 7 hrs. (Registered 7 March 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-03-19 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 30 | 2012-03-19-1f359ece-10574-0 |
3bb88a09cd0bfeb3ec421f12353682343c4a58b1 | 24 February 2012, received fee of £3,000 in respect of speaking engagement on 24 November 2011 for Keoghs, Solicitors, of the Parklands, Bolton, BL6 4SE, at 1 Great George St, London SW1P 3AE. Hours: 3 hrs. (Registered 7 March 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-03-19 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 31 | 2012-03-19-1f359ece-10574-0 |
69e2480914acf7eb2ed4f3048a300a24ebe2b10f | 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 | 2012-03-19 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 32 | 2012-03-19-1f359ece-10574-0 |
e88b603b97e54e338812414bc5e5139da0f9b200 | 9 June 2011, received £7,500 consultancy fee for quarter 1 April to 30 June 2011. Hours: approx 30 hrs. (Registered 17 October 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-03-19 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 33 | 2012-03-19-1f359ece-10574-0 |
3ee8554345e299d9f0b867334776a59b4826a81e | 2 August 2011, received £7,500 consultancy fee for quarter 1 July to 30 September 2011. Hours: approx 60 hrs. (Registered 3 October 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-03-19 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 34 | 2012-03-19-1f359ece-10574-0 |
0295807e3031a1c5c82e8684979efb745c367af8 | On 22 and 23 September 2011 I travelled to Kiev on behalf of E D & F MAN for meeting with Prime Minister of Ukraine and others. Business class return fare: £1010; cars £200, hotel £400 approx. (Registered 17 October 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-03-19 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 35 | 2012-03-19-1f359ece-10574-0 |
a9b962ba91dcdb78c93b3a3f8f757896a57cf33e | 30 December 2011, received £15,000 consultancy fee for quarter 1 October to 31 December 2011. Hours: 45 hrs. (Registered 4 January 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-03-19 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 36 | 2012-03-19-1f359ece-10574-0 |
1197faefcedee537e869eded36138cd48c766a0a | 25 November 2011, received from Forbes and Partners, Solicitors, six bottles of wine, approx value £75.00, in respect of a speech by me to a conference organised by Forbes in Manchester Town Hall on 4 November 2011. Address: Forbes and Partners, Solicitors, 4 Wellington Street, St John's, Blackburn BB1 8AF (Registered 30 November 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-03-19 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 37 | 2012-03-19-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");