items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
22 rows where record_id = "2011-04-18-1f359ece-10001-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 |
---|---|---|---|---|---|---|---|
d9f1332c8c61bce1852be56346489d7d3936c05b | Fees received for co-presenting BBC’s "This Week" TV programme. Address: BBC Television Centre, Wood Lane, London W12 7RJ. | Remunerated employment, office, profession etc 1f359ece | 2011-04-18 | Diane Abbott uk.org.publicwhip/member/40289 | Diane Abbott uk.org.publicwhip/person/10001 | 0 | 2011-04-18-1f359ece-10001-0 |
4de5661afc21ac7219835442204871ffc8dca2ae | April 2010, received £3,356. Hours: 12 hours (Registered 3 June 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-04-18 | Diane Abbott uk.org.publicwhip/member/40289 | Diane Abbott uk.org.publicwhip/person/10001 | 1 | 2011-04-18-1f359ece-10001-0 |
c5f031f8dcb160dd2f9247bfba4fd0a6c8d2ab0d | May 2010, received £1,687 Hours: 6 hours. (Registered 3 June 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-04-18 | Diane Abbott uk.org.publicwhip/member/40289 | Diane Abbott uk.org.publicwhip/person/10001 | 2 | 2011-04-18-1f359ece-10001-0 |
a547c2ccb7d8e78d18d98db857a5c082de4987bf | June 2010, received £839. Hours: 3 hrs. (Registered 13 July 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-04-18 | Diane Abbott uk.org.publicwhip/member/40289 | Diane Abbott uk.org.publicwhip/person/10001 | 3 | 2011-04-18-1f359ece-10001-0 |
e23ab4f821109b94812740b51b040030b40b8427 | October 2010, received £839. Hours: 3 hrs. (Registered 2 November 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-04-18 | Diane Abbott uk.org.publicwhip/member/40289 | Diane Abbott uk.org.publicwhip/person/10001 | 4 | 2011-04-18-1f359ece-10001-0 |
c2b145e547cf9e6648b5adbdce5f291d0fcfecdc | November 2010, received £839. Hours: 3 hrs. (Registered 15 December 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-04-18 | Diane Abbott uk.org.publicwhip/member/40289 | Diane Abbott uk.org.publicwhip/person/10001 | 5 | 2011-04-18-1f359ece-10001-0 |
c2a8274abb6685f14a92efed5d373a15d0b11c5a | March 2011, received £869. Hours: 3 hrs. (Registered 14 March 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-04-18 | Diane Abbott uk.org.publicwhip/member/40289 | Diane Abbott uk.org.publicwhip/person/10001 | 6 | 2011-04-18-1f359ece-10001-0 |
435f484480d9d6f031693e8233ca8233cf41fe3a | Articles written for The Guardian. Address: Guardian News & Media, Kings Place , 90 York Way , London N1 9GU . | Remunerated employment, office, profession etc 1f359ece | 2011-04-18 | Diane Abbott uk.org.publicwhip/member/40289 | Diane Abbott uk.org.publicwhip/person/10001 | 7 | 2011-04-18-1f359ece-10001-0 |
635693d8efb8515c9427a9460461c5466389d102 | February 2011, payment of £85. Hours: 1 hr. (Registered 7 February 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-04-18 | Diane Abbott uk.org.publicwhip/member/40289 | Diane Abbott uk.org.publicwhip/person/10001 | 8 | 2011-04-18-1f359ece-10001-0 |
0109c0d1db17150c5ca184bf51f0b8308fab5a77 | May 2010, fee of £1,000for taking part in BBC Television programme "Cash in the Attic". Address: Leopard Films Ltd, 1-3 St Peter’s Street, London N1 8JD. (Registered 3 June 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-04-18 | Diane Abbott uk.org.publicwhip/member/40289 | Diane Abbott uk.org.publicwhip/person/10001 | 9 | 2011-04-18-1f359ece-10001-0 |
ce9cf76d4007fa13e511bfdb8985a1fbc0082eaf | June 2010, fee of £250 received for Independent Newspaper article. Address: Independent Print Ltd, 2 Derry Street, London W8 5HF. Hours: 2 hrs. (Registered 13 July 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-04-18 | Diane Abbott uk.org.publicwhip/member/40289 | Diane Abbott uk.org.publicwhip/person/10001 | 10 | 2011-04-18-1f359ece-10001-0 |
ecafb68bad4389b83ff96fe11631b8dfb56cf0d4 | June 2010, fee of £200 received for The Voice newspaper article. Address: GV Media Group, Northern & Shell Tower, 6th Floor, 4 Selsdon Way, London E14 9GL. Hours: 2 hrs. (Registered 13 July 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-04-18 | Diane Abbott uk.org.publicwhip/member/40289 | Diane Abbott uk.org.publicwhip/person/10001 | 11 | 2011-04-18-1f359ece-10001-0 |
ffef00f85bb7d946c0e9467187cd087b2bdac375 | August 2010, fee of £250 received for participation in Channel 4 "4 Thought" television series. Address: Waddell Media, 7-12 St Helen’s Business Park, Holywood, County Down BT18 9HQ. Hours: 1 hr. (Registered 20 September 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-04-18 | Diane Abbott uk.org.publicwhip/member/40289 | Diane Abbott uk.org.publicwhip/person/10001 | 12 | 2011-04-18-1f359ece-10001-0 |
ff90bdf19849dbab05f699eb8ccf1fc7a2862a4e | August 2010, fee of £400 received for article in the Sunday Express newspaper. Address: Sunday Express, 10 Lower Thames Street, London EC3R 6EN. Hours: 1 hr. (Registered 20 September 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-04-18 | Diane Abbott uk.org.publicwhip/member/40289 | Diane Abbott uk.org.publicwhip/person/10001 | 13 | 2011-04-18-1f359ece-10001-0 |
7e80c12413829c386db2a13c5c771b36e8a7d66d | October 2010, fee of £400 for writing article for the Express Newspaper. Address: Express Newspapers, The Northern & Shell Building, 10 Lower Thames Street, London EC3R 6EN. Hours: 1hr 30mins. (Registered 2 November 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-04-18 | Diane Abbott uk.org.publicwhip/member/40289 | Diane Abbott uk.org.publicwhip/person/10001 | 14 | 2011-04-18-1f359ece-10001-0 |
09f35e9bdb48fffb87477464e0de7576e2a36d50 | October 2010, fee of £250 for appearing on ITV ‘Alan Titchmarsh Show’. Address: Spun Gold TV, 2nd Floor, Tabernacle Court, 16-28 Tabernacle Street, London EC2A 4DD. Hours: 3 hrs. (Registered 2 November 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-04-18 | Diane Abbott uk.org.publicwhip/member/40289 | Diane Abbott uk.org.publicwhip/person/10001 | 15 | 2011-04-18-1f359ece-10001-0 |
2dd0ccd696f8bffcb49ead1061bd8e41696eb430 | December 2010, fee of £3,000 for participating in Channel 4’s ‘Come Dine with Me’ television programme. Address: ITV Studios Ltd, The London Television Centre, Upper Ground, London SE1 9LT. Hours: 36 hrs. (Registered 15 December 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-04-18 | Diane Abbott uk.org.publicwhip/member/40289 | Diane Abbott uk.org.publicwhip/person/10001 | 16 | 2011-04-18-1f359ece-10001-0 |
a61523872abbfebc82641dae351ff250f3c06385 | January 2011, fee of £150 for participating in Ipsos MORI survey of MPs. Address: Market & Opinion Research International, 79-81 Borough Road, London SE1 1FY. Hours: 45 mins. (Registered 7 February 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-04-18 | Diane Abbott uk.org.publicwhip/member/40289 | Diane Abbott uk.org.publicwhip/person/10001 | 17 | 2011-04-18-1f359ece-10001-0 |
a82996bb9a2d6540d9c236c14b1ca054cc510221 | January 2011, fee of £75 for participating in ComRes Parliamentary Panel Survey. Address: Communicate Research Ltd, Four Millbank, London SW1P 3JA. Hours: 30 mins. (Registered 7 February 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-04-18 | Diane Abbott uk.org.publicwhip/member/40289 | Diane Abbott uk.org.publicwhip/person/10001 | 18 | 2011-04-18-1f359ece-10001-0 |
b28bef3809ef2213e2173f6e9f6f7ce198f4dc80 | January 2011, fee of £80 for participating in YouGov online survey. Address: YouGov, 50 Featherstone St, London EC1Y 8RT. Hours: 30 mins. (Registered 7 February 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-04-18 | Diane Abbott uk.org.publicwhip/member/40289 | Diane Abbott uk.org.publicwhip/person/10001 | 19 | 2011-04-18-1f359ece-10001-0 |
d1651c2a6ccd9af85132ffdedd1fc8cc3196a2f3 | March 2011, fee of £1,000 for participating in ‘An Audience with Diane Abbott MP’ at the Lichfield Garrick Theatre on 12 March 2011. Address: Clive Conway Celebrity Productions Ltd, 32 Grove Street, Oxford OX2 7JT. (Registered 24 March 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-04-18 | Diane Abbott uk.org.publicwhip/member/40289 | Diane Abbott uk.org.publicwhip/person/10001 | 20 | 2011-04-18-1f359ece-10001-0 |
e159e34d8316dd33df4f33a5dce67e92d693b49c | March 2011, fee of £3,000 for participating/speaking at Deloitte’s National Women’s Day Celebrations 2011 on 8 March 2011. Address: Deloitte LLP, The Pinnacle, 150 Midsummer Boulevard, Milton Keynes, MK9 1FD. (Registered 28 March 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-04-18 | Diane Abbott uk.org.publicwhip/member/40289 | Diane Abbott uk.org.publicwhip/person/10001 | 21 | 2011-04-18-1f359ece-10001-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");