items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
21 rows where record_id = "2011-07-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 |
---|---|---|---|---|---|---|---|
6dcfbb73c1adb9cee26e67b7f8905b9b952982d5 | Payments from News International Supply Co Ltd. Address: Cygnet Park, 200 Serpentine Way, Peterborough PE7 8FD: | Remunerated employment, office, profession etc 1f359ece | 2011-07-19 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 0 | 2011-07-19-1f359ece-10574-0 |
36d91b08a6143b055904aed2bc022f934009cbff | Payment of £500 for article in The Times 13 May 2010. Hours: 4 hrs approx, plus unquantifiable thinking time. (Registered 6 July 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-07-19 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 1 | 2011-07-19-1f359ece-10574-0 |
d58a1d0668b4d48d4688c793e10360727c7fcb09 | Payment of £500 for article in The Times 7 June 2010. Hours: 4 hrs approx, plus unquantifiable thinking time. (Registered 12 August 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-07-19 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 2 | 2011-07-19-1f359ece-10574-0 |
d6de655ee6ab611de45d0f430830edd31fa70d9d | Payment of £500 for article in The Times 30 July 2010. Hours: 4 hrs approx, plus unquantifiable thinking time. (Registered 18 October 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-07-19 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 3 | 2011-07-19-1f359ece-10574-0 |
43eef42df6f6ea14bf075ce76d7f5f693bd488a4 | 8 November 2010, payment of £500 for article in The Times. Hours: 12 hrs, plus indeterminate amount of time researching the article. (Registered 7 December 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-07-19 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 4 | 2011-07-19-1f359ece-10574-0 |
8750448388151d8b302c4c8aa07832c8775fb271 | 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 | 2011-07-19 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 5 | 2011-07-19-1f359ece-10574-0 |
d953b65b899d6ccaeddc41219e97f06f474f6b21 | 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 | 2011-07-19 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 6 | 2011-07-19-1f359ece-10574-0 |
3c2df2b731b70655c8b035929058ae2d0e07279f | 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 | 2011-07-19 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 7 | 2011-07-19-1f359ece-10574-0 |
51322463209c08ded464f7617a20754e4ee9d5aa | 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 | 2011-07-19 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 8 | 2011-07-19-1f359ece-10574-0 |
f823813f02ebdff16147400d6e5c64af333943e1 | 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 | 2011-07-19 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 9 | 2011-07-19-1f359ece-10574-0 |
711cecd3fa77bb66d9e1dfd63d845e653e7c2347 | 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 | 2011-07-19 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 10 | 2011-07-19-1f359ece-10574-0 |
89c0416c340af2eb5c6fc62454f471b988f3cf55 | 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 | 2011-07-19 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 11 | 2011-07-19-1f359ece-10574-0 |
484a19b797376b69b524a6d72ae30640248015fb | 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 | 2011-07-19 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 12 | 2011-07-19-1f359ece-10574-0 |
16435224f757dbe8da77b20d5110f263f0c7aa86 | 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 | 2011-07-19 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 13 | 2011-07-19-1f359ece-10574-0 |
0d5f1f60a44fcd1d842c3e68b4ae37d3e8521d86 | 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 | 2011-07-19 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 14 | 2011-07-19-1f359ece-10574-0 |
57827b4ed867ec7d48a84577178f898574fbaa58 | 19 October 2010, presentation on foreign policy for the Centre for Foreign Policy Studies, Paris. Fee received £8,000, plus travel provided for me and my wife who accompanied me. Hours: 36 hrs (including travel). (Registered 7 December 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-07-19 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 15 | 2011-07-19-1f359ece-10574-0 |
5241ea98131b3a7c3ffbd1453d2fb4f8a3d3eaa7 | 21 October 2010, launching the Nexis Lexis Middle East Law project in Dubai. Fee paid £5,525, plus travel and accommodation provided. Hours: 36 hrs. (Registered 7 December 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-07-19 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 16 | 2011-07-19-1f359ece-10574-0 |
4e146777ae9f9a94d705901a62c0d6f1f285f250 | 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 | 2011-07-19 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 17 | 2011-07-19-1f359ece-10574-0 |
2b83e24f594c5d78abdc9f1bc162d38a9b152b04 | 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 | 2011-07-19 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 18 | 2011-07-19-1f359ece-10574-0 |
45a60fcc1e740035e5257232942e0c589cffe909 | 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 | 2011-07-19 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 19 | 2011-07-19-1f359ece-10574-0 |
13bd9e652d6ad381ab306833c7eb3501a14c5377 | 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 (£25,001-£30,000) Payment received on a quarterly basis. | Remunerated employment, office, profession etc 1f359ece | 2011-07-19 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 20 | 2011-07-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");