items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
33 rows where record_id = "2012-07-09-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 |
---|---|---|---|---|---|---|---|
8d05396bea7fc49eebedf2523667430c347ad141 | Payments from News International Supply Co Ltd. Address: Cygnet Park, 200 Serpentine Way, Peterborough PE7 8FD: | Remunerated employment, office, profession etc 1f359ece | 2012-07-09 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 0 | 2012-07-09-1f359ece-10574-0 |
06c72636b04726d0cb9fc23c28d054e19f24330b | 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-07-09 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 1 | 2012-07-09-1f359ece-10574-0 |
85a8303e76fcc914fcfe286d67371c7d562cf253 | 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-07-09 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 2 | 2012-07-09-1f359ece-10574-0 |
5ad24e96589a3130a0aefd61a2ed3d3c7afdd1d0 | 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-07-09 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 3 | 2012-07-09-1f359ece-10574-0 |
3667f4290f56ccde9ea56be9bff527a89e711dbf | 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-07-09 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 4 | 2012-07-09-1f359ece-10574-0 |
7a385b51f57c7c31d7d61d8e7019708f5ad34e61 | 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-07-09 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 5 | 2012-07-09-1f359ece-10574-0 |
498ac85788ffd626c18ed471e1961b4e84bf612e | 16 May 2012, payment of £400 for article in The Times on 2 May. Hours: 3 hrs. (Registered 17 May 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-07-09 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 6 | 2012-07-09-1f359ece-10574-0 |
f3d5a4c0c2b63865008008d551e26fe5b8d530a7 | 18 June 2012, two payments each of £500 and one of £300 (£1,300 in total) for articles in The Times on 27 January 2012, 16 February 2012 and 20 May 2012. Hours: 4 hrs, 4 hrs and 3 hrs (11 hrs in total). (Registered 3 July 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-07-09 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 7 | 2012-07-09-1f359ece-10574-0 |
e41aed296032f38151c7c34eccb301d4bf50d7c0 | 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-07-09 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 8 | 2012-07-09-1f359ece-10574-0 |
f0665f4d050e69662883dd9d248dcb9f63ec00ad | 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-07-09 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 9 | 2012-07-09-1f359ece-10574-0 |
5f9a6d6dfa64d817cd2fc25fc011b05f6044121a | Payments from Specialist Speakers, 18 Waxwell Lane, Harrow, London, HA5 3EN, UK | Remunerated employment, office, profession etc 1f359ece | 2012-07-09 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 10 | 2012-07-09-1f359ece-10574-0 |
0e9c3f54c31728a5a8e117aa644a5d2402ef6ca2 | 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-07-09 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 11 | 2012-07-09-1f359ece-10574-0 |
09047a3621eaa23349171b73b1624ab8cb8f63d2 | 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-07-09 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 12 | 2012-07-09-1f359ece-10574-0 |
0a64c624a94831be5c3f6ccd5e64a5414e366d50 | 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-07-09 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 13 | 2012-07-09-1f359ece-10574-0 |
1bbeffcbdf2307b73305aacd21c09ed45281deef | 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-07-09 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 14 | 2012-07-09-1f359ece-10574-0 |
3c3f68bc69b65450c7bdb882648f56dbe0a8f903 | 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-07-09 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 15 | 2012-07-09-1f359ece-10574-0 |
fed2e7ef70ba9c11b984bd31d43de85267dd646b | 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-07-09 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 16 | 2012-07-09-1f359ece-10574-0 |
5661332e13d96c1bc110604a51b60d2b473678ec | 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-07-09 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 17 | 2012-07-09-1f359ece-10574-0 |
6024adddb0a0c0c87aca9517a62c464ad0b03834 | 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-07-09 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 18 | 2012-07-09-1f359ece-10574-0 |
9382b2d4c3dd6893e750c307d9d156dc1fa98f07 | 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-07-09 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 19 | 2012-07-09-1f359ece-10574-0 |
7d9cd0600a181f01299c37e6f3bc377e68fec3db | 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-07-09 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 20 | 2012-07-09-1f359ece-10574-0 |
a7a7928dcc7e68a5a6e65f93b06ac83c56c12765 | 2 May 2012, received £6,000 for speaking at Econbuild conference at Excel Centre on 21 March 2012. Payer: IBE Ltd, Ludgate House, 245 Blackfriars Rd, London SE1 9UY. Hours: 6 hrs approx. (Registered 17 May 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-07-09 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 21 | 2012-07-09-1f359ece-10574-0 |
f371f6d674ebc11596ee09cb1610f967149a653b | 2 May 2012, received £3,500 for speaking at Lyons Davidson conference at M-Shed,Princes Wharf, Bristol. Payer: Lyons Davidson, Victoria House, 51 Victoria St, Bristol, BS1 6AD. Hours: 8 hrs approx. (Registered 17 May 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-07-09 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 22 | 2012-07-09-1f359ece-10574-0 |
46898d779af3f13e4887f5ab7c1a991bd97d5101 | 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-07-09 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 23 | 2012-07-09-1f359ece-10574-0 |
2734f1c998e0377b922861a09c8f979b02dc7834 | 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-07-09 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 24 | 2012-07-09-1f359ece-10574-0 |
2f68c3eaa84a1c43cc4b0f486d90a82ae01a32d0 | 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-07-09 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 25 | 2012-07-09-1f359ece-10574-0 |
d936276d186d33b156411586d8a7ecdc3c7855ea | 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-07-09 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 26 | 2012-07-09-1f359ece-10574-0 |
cdc8630a837061963ad02b94a24efba575a9483c | 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-07-09 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 27 | 2012-07-09-1f359ece-10574-0 |
5339f06269d90d273e8049041eb9b234b14b5b07 | 18 April 2012, received £15,000 consultancy fee for quarter 1 January to 31 March 2012. Hours; approx 30 hrs. (Registered 19 April 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-07-09 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 28 | 2012-07-09-1f359ece-10574-0 |
794875f810232b89c84b83434c3290ae6b6b0f7b | 5 July 2012, received £15,000 consultancy fee for quarter 1 April to 30 June 2012. Hours; approx 30 hrs. (Registered 3 July 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-07-09 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 29 | 2012-07-09-1f359ece-10574-0 |
3884e6eb99baaa9e06ba0c312b95db0821ccc8a4 | 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-07-09 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 30 | 2012-07-09-1f359ece-10574-0 |
9e54891cbba55a84b5592b8825219852f592f84a | 22 March 2012, received £30,750 as signature advance, ie 25% of the total eventually due, for the manuscript of a book, from Macmillans Publishers, via Capel & Land Ltd, Literary Agents (and net of their commission). Address of Macmillans: 20 New Wharf Road London N1 9RR. | Remunerated employment, office, profession etc 1f359ece | 2012-07-09 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 31 | 2012-07-09-1f359ece-10574-0 |
e0519ac27b0b157e0ccc3f0e7d9b11cd1a02d6b5 | Time taken so far (since October 2011): at least 300 hours. (Registered 2 April 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-07-09 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 32 | 2012-07-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");