items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
36 rows where record_id = "2012-06-25-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 |
---|---|---|---|---|---|---|---|
982e1789e168f8c6178c67b1c3484a155545aa35 | Payments from News International Supply Co Ltd. Address: Cygnet Park, 200 Serpentine Way, Peterborough PE7 8FD: | Remunerated employment, office, profession etc 1f359ece | 2012-06-25 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 0 | 2012-06-25-1f359ece-10574-0 |
696332ed6e7b17d99eaab834e1d53181e2fcbf84 | 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-06-25 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 1 | 2012-06-25-1f359ece-10574-0 |
16a4f3f99b93204b27f49ce73cc52d29762738b1 | 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-06-25 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 2 | 2012-06-25-1f359ece-10574-0 |
a5756eea3ac3c44fdf41345fd241d897d4ce1683 | 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-06-25 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 3 | 2012-06-25-1f359ece-10574-0 |
b8fd2807394207ddb2cd9e08a42df0b77747b3e6 | 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-06-25 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 4 | 2012-06-25-1f359ece-10574-0 |
4f169e411935fc821192e7760230c9082312467e | 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-06-25 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 5 | 2012-06-25-1f359ece-10574-0 |
2f78f579550e6722c4cf22de4d3e009504173550 | 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-06-25 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 6 | 2012-06-25-1f359ece-10574-0 |
1b76b34595c042beba44871e182f2aba10a5014d | 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-06-25 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 7 | 2012-06-25-1f359ece-10574-0 |
506df89d2beeb590dbec74ec7611ef1b58a96eb8 | 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-06-25 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 8 | 2012-06-25-1f359ece-10574-0 |
9b60b01ce6a00b8273161e63928803f026a6f969 | 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-06-25 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 9 | 2012-06-25-1f359ece-10574-0 |
63f005ed59c9fe623f44748286c7e531b421eaf9 | 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-06-25 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 10 | 2012-06-25-1f359ece-10574-0 |
89f117153c1645524740ae3b7d2278655e08f8d2 | 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-06-25 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 11 | 2012-06-25-1f359ece-10574-0 |
eee7d2aef44245bbb08bacad7f2a8043930c0045 | 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-06-25 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 12 | 2012-06-25-1f359ece-10574-0 |
60e911cd6778dcc9f2e924fdc5f87bedd9856227 | 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-06-25 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 13 | 2012-06-25-1f359ece-10574-0 |
cd9b6ed18f792aad690dff9c35119e8f3c54eb93 | Payments from Specialist Speakers, 18 Waxwell Lane, Harrow, London, HA5 3EN, UK | Remunerated employment, office, profession etc 1f359ece | 2012-06-25 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 14 | 2012-06-25-1f359ece-10574-0 |
37ab523304e33be462c7fcfcefeead020d5b7fa0 | 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-06-25 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 15 | 2012-06-25-1f359ece-10574-0 |
95ade4cf947b850748acbd272de7f0eac95f18d8 | 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-06-25 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 16 | 2012-06-25-1f359ece-10574-0 |
c5d77a5400a4a45852ed2536f283cda945a5c821 | 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-06-25 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 17 | 2012-06-25-1f359ece-10574-0 |
5ce490d8e87087eac6bb5500b2e0f176e8d4eb3b | 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-06-25 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 18 | 2012-06-25-1f359ece-10574-0 |
721c0c6b6ef45b5efd0b1d31bf63c08deae77bf8 | 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-06-25 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 19 | 2012-06-25-1f359ece-10574-0 |
8be988d3644673326bf051f45985fb7217ac51c8 | 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-06-25 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 20 | 2012-06-25-1f359ece-10574-0 |
891882a3763d6a30374e95a863ab8f948c9fcf81 | 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-06-25 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 21 | 2012-06-25-1f359ece-10574-0 |
c2caedad27d93b59be79d7e3592068f60e693f08 | 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-06-25 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 22 | 2012-06-25-1f359ece-10574-0 |
edf4d345f77b343f81a0f20d71a8a7dd62379e58 | 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-06-25 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 23 | 2012-06-25-1f359ece-10574-0 |
4a396237c8e604047c335cc59eeeeabec6d0a74d | 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-06-25 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 24 | 2012-06-25-1f359ece-10574-0 |
bcd01e6c040b185b53e88956dfb2e63a7229f46b | 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-06-25 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 25 | 2012-06-25-1f359ece-10574-0 |
489aeb775e9941e78433561d3066cafeeaf1a83d | 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-06-25 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 26 | 2012-06-25-1f359ece-10574-0 |
9178fb3bdf0dd63ad3bd1275823ef3a14f5f8897 | 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-06-25 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 27 | 2012-06-25-1f359ece-10574-0 |
ce2a9a7a6c0e09f173b28fc7ae51f08dde39e744 | 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-06-25 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 28 | 2012-06-25-1f359ece-10574-0 |
f19bdd76fb96450c23e85167c5fed75cc44c2404 | 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-06-25 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 29 | 2012-06-25-1f359ece-10574-0 |
7d423fed415ff926529872640f668c1f0e998da5 | 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-06-25 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 30 | 2012-06-25-1f359ece-10574-0 |
e9b9c73c7c9958f2e3393a3d9049da226084aff7 | 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-06-25 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 31 | 2012-06-25-1f359ece-10574-0 |
83d4338645c1e95ae3fe188e7d3be520b1d3007c | 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-06-25 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 32 | 2012-06-25-1f359ece-10574-0 |
f25a9daf707f759d786248ca44a2bf244f11f779 | 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-06-25 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 33 | 2012-06-25-1f359ece-10574-0 |
5a3e0fe7c0bd0aaffb3bf82f350b9c9837de7043 | 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-06-25 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 34 | 2012-06-25-1f359ece-10574-0 |
aa83a7a51aa68b4740728393181d9195b52f104f | Time taken so far (since October 2011): at least 300 hours. (Registered 2 April 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-06-25 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 35 | 2012-06-25-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");