home / regmem

items

Data source: mySociety Data

25 rows where record_id = "2013-11-25-1f359ece-10574-0" sorted by sort_order

View and edit SQL

hash item category_id date member_id person_id sort_order record_id
a5d3c22865c7a54e7f35e4a2926f0153966660f4 Payments from News International Supply Co Ltd. Address: Cygnet Park, 200 Serpentine Way, Peterborough PE7 8FD: Remunerated employment, office, profession etc 1f359ece 2013-11-25 uk.org.publicwhip/member/40090 Jack Straw uk.org.publicwhip/person/10574 0 2013-11-25-1f359ece-10574-0
0f64dc5abaaf2fd185e7dce6806021c7147fda5b 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-11-25 uk.org.publicwhip/member/40090 Jack Straw uk.org.publicwhip/person/10574 1 2013-11-25-1f359ece-10574-0
aec9e4db38963108d385e3bf452172aa6c45f31f 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-11-25 uk.org.publicwhip/member/40090 Jack Straw uk.org.publicwhip/person/10574 2 2013-11-25-1f359ece-10574-0
3807cdfa4e7d8112755be371bc3feb624e88a853 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-11-25 uk.org.publicwhip/member/40090 Jack Straw uk.org.publicwhip/person/10574 3 2013-11-25-1f359ece-10574-0
7b95079523426b7ebb5c720d2438a7150c5d1971 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-11-25 uk.org.publicwhip/member/40090 Jack Straw uk.org.publicwhip/person/10574 4 2013-11-25-1f359ece-10574-0
afce2d4ab5f850d0aeb02f2db1f073de2813d2aa Payments from Specialist Speakers, 18 Waxwell Lane, Harrow, London, HA5 3EN, UK Remunerated employment, office, profession etc 1f359ece 2013-11-25 uk.org.publicwhip/member/40090 Jack Straw uk.org.publicwhip/person/10574 6 2013-11-25-1f359ece-10574-0
526183e634759974e90366195a692686a1f891a3 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-11-25 uk.org.publicwhip/member/40090 Jack Straw uk.org.publicwhip/person/10574 7 2013-11-25-1f359ece-10574-0
523e306bf47afddabe03ed401964c43e3d258858 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-11-25 uk.org.publicwhip/member/40090 Jack Straw uk.org.publicwhip/person/10574 8 2013-11-25-1f359ece-10574-0
fe70ffb046651cfca66d5712786fbaccebd0399d 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-11-25 uk.org.publicwhip/member/40090 Jack Straw uk.org.publicwhip/person/10574 9 2013-11-25-1f359ece-10574-0
1b78a4eb7df7a17a9afe07ebda824fdaa52c64e9 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-11-25 uk.org.publicwhip/member/40090 Jack Straw uk.org.publicwhip/person/10574 10 2013-11-25-1f359ece-10574-0
18fb00e526502aa505866aa4174af919ae1d714a 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-11-25 uk.org.publicwhip/member/40090 Jack Straw uk.org.publicwhip/person/10574 11 2013-11-25-1f359ece-10574-0
7a3a4432d223486c6c8871e3409e1cb0513f51c5 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-11-25 uk.org.publicwhip/member/40090 Jack Straw uk.org.publicwhip/person/10574 12 2013-11-25-1f359ece-10574-0
1283367925de0a9ad7a1d2e30ae903b5fa5aace0 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-11-25 uk.org.publicwhip/member/40090 Jack Straw uk.org.publicwhip/person/10574 13 2013-11-25-1f359ece-10574-0
e2fa44a548111809ac55bebacc071709ee8f846c 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-11-25 uk.org.publicwhip/member/40090 Jack Straw uk.org.publicwhip/person/10574 14 2013-11-25-1f359ece-10574-0
b8f02ce370a2d5bf9fe58c6739a1d3a6e4562c12 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-11-25 uk.org.publicwhip/member/40090 Jack Straw uk.org.publicwhip/person/10574 15 2013-11-25-1f359ece-10574-0
85ab9985b401dab5c760b4109d628b6c0cd3bc88 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-11-25 uk.org.publicwhip/member/40090 Jack Straw uk.org.publicwhip/person/10574 16 2013-11-25-1f359ece-10574-0
7aacfad04fb56e9a90c2a89eff62cce4e449b115 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-11-25 uk.org.publicwhip/member/40090 Jack Straw uk.org.publicwhip/person/10574 17 2013-11-25-1f359ece-10574-0
67e0973e4b6bec3f59359f9a10228183db9af04f 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-11-25 uk.org.publicwhip/member/40090 Jack Straw uk.org.publicwhip/person/10574 18 2013-11-25-1f359ece-10574-0
95fcf1e608695cb423b957cf651779cf77483d79 Remunerated employment, office, profession etc 1f359ece 2013-11-25 uk.org.publicwhip/member/40090 Jack Straw uk.org.publicwhip/person/10574 19 2013-11-25-1f359ece-10574-0
a9dcbf5fafbc7ea5a80fb50d451d294f834dfb92 Payments for articles from the Telegraph Media Group, 111 Buckingham Palace Road, London SW1W 0DT: Remunerated employment, office, profession etc 1f359ece 2013-11-25 uk.org.publicwhip/member/40090 Jack Straw uk.org.publicwhip/person/10574 20 2013-11-25-1f359ece-10574-0
7c7cb4e6028d4ef09b1be7d99d751b8ca3917b0e 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-11-25 uk.org.publicwhip/member/40090 Jack Straw uk.org.publicwhip/person/10574 21 2013-11-25-1f359ece-10574-0
0428878df58bf1893a009581bc760e532606a51a 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-11-25 uk.org.publicwhip/member/40090 Jack Straw uk.org.publicwhip/person/10574 22 2013-11-25-1f359ece-10574-0
09eb81ef7fca208fda7b3a29345fedda056d93c5 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-11-25 uk.org.publicwhip/member/40090 Jack Straw uk.org.publicwhip/person/10574 23 2013-11-25-1f359ece-10574-0
00002a3b3e60d366330c5c303d9cfc4ba0240668 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-11-25 uk.org.publicwhip/member/40090 Jack Straw uk.org.publicwhip/person/10574 24 2013-11-25-1f359ece-10574-0
50ba538133b6b359a3bcd502b6cf5e1cb190d885 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 C harlotte Square, Edinburgh. Hours: 4 hrs. (Registered 18 November 2013) Remunerated employment, office, profession etc 1f359ece 2013-11-25 uk.org.publicwhip/member/40090 Jack Straw uk.org.publicwhip/person/10574 25 2013-11-25-1f359ece-10574-0

Advanced export

JSON shape: default, array, object

CSV options:

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)
    )
Powered by Datasette · Query took 6.095ms · Data source: mySociety Data