items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
19 rows where record_id = "2011-09-28-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 |
---|---|---|---|---|---|---|---|
90b4e82c9cc268b7e4b5702e81e0db4158bc9a4e | Payments from News International Supply Co Ltd. Address: Cygnet Park, 200 Serpentine Way, Peterborough PE7 8FD: | Remunerated employment, office, profession etc 1f359ece | 2011-09-28 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 0 | 2011-09-28-1f359ece-10574-0 |
abe689c329507f65cd104789a518bcaf3951fa97 | 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-09-28 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 1 | 2011-09-28-1f359ece-10574-0 |
ca36881f854907eda474277174e1b9720d0cecea | 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-09-28 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 2 | 2011-09-28-1f359ece-10574-0 |
d9a6069b299fd43f08156e1f248cb897e58d5244 | 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-09-28 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 3 | 2011-09-28-1f359ece-10574-0 |
520f158fbda47f1f760e0ab5059c8f1425d69cbe | 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-09-28 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 4 | 2011-09-28-1f359ece-10574-0 |
9496d1684166d7ebffec9b5c0797e2c214369a36 | 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-09-28 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 5 | 2011-09-28-1f359ece-10574-0 |
5a947d1310e3bd36e0aa496ede4ff05b1b14cc16 | 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-09-28 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 6 | 2011-09-28-1f359ece-10574-0 |
81f64704c46533614185c8cfa4bffc620ade96df | 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-09-28 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 7 | 2011-09-28-1f359ece-10574-0 |
1e7949b50c929212bd2a9e9d5745d22e92112a99 | 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-09-28 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 8 | 2011-09-28-1f359ece-10574-0 |
fa39c19bde8ae8aac4dece5fa0fed4c2b93f96f3 | 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-09-28 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 9 | 2011-09-28-1f359ece-10574-0 |
dd36ff7d13d7be73aacb1ee244b6c7a1ddc280a4 | 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-09-28 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 10 | 2011-09-28-1f359ece-10574-0 |
60561f3553d85ac4b7f68bd54e1a878ac861d04c | 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-09-28 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 11 | 2011-09-28-1f359ece-10574-0 |
917be2925227c740b6750a116bbd95265f2df3f9 | 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-09-28 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 12 | 2011-09-28-1f359ece-10574-0 |
25246132db87340336af4eeb14d28949d3db3f87 | 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-09-28 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 13 | 2011-09-28-1f359ece-10574-0 |
85f84f3c5db1fac28c001e2418caebb7cbcadb24 | 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-09-28 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 14 | 2011-09-28-1f359ece-10574-0 |
f863593cd35fcdedbc13e58021a7a71dcfcba23b | 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-09-28 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 15 | 2011-09-28-1f359ece-10574-0 |
a968d2cc332942fcc7956d64e86705faf40e2f91 | 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-09-28 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 16 | 2011-09-28-1f359ece-10574-0 |
cb05350d88c634f84d0e10dde091f67532a0a959 | 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-09-28 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 17 | 2011-09-28-1f359ece-10574-0 |
52f123a67ef17d7add378ddf68c1848cc2468013 | 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-09-28 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 18 | 2011-09-28-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");