items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
15 rows where record_id = "2007-10-23-1f359ece-10001-0" sorted by date descending
This data as json, CSV (advanced)
Suggested facets: date (date)
hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
8b50e1ed89989719a11a920a1c57a3877604c04f | 2005/6 Arcadia Lectures for School of Oriental and African Studies, London. (Actual £1,200) (Up to £5,000) | Remunerated employment, office, profession etc 1f359ece | 2007-10-23 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 0 | 2007-10-23-1f359ece-10001-0 |
bf3afd8922927fe2b0a32bd4a47d69f1c006b57f | June-October 2006, weekly, fees for articles in Evening Standard, ongoing. (Actual £6,950) (£5,001-£10,000) (Registered 8 November 2006) | Remunerated employment, office, profession etc 1f359ece | 2007-10-23 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 1 | 2007-10-23-1f359ece-10001-0 |
7b4a363129fcdd1c586da22029f7f8cf861313b1 | June and October 2006, fees for bi-weekly article in The Voice newspaper, ongoing. (Actual £1,200) (Up to £5,000) (Registered 8 November 2006) | Remunerated employment, office, profession etc 1f359ece | 2007-10-23 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 2 | 2007-10-23-1f359ece-10001-0 |
6faeefa894538dd2c0db78ab887092b3f75c9fe2 | August 2006, fee for article in The Times. (Actual £900) (Up to £5,000) (Registered 8 November 2006) | Remunerated employment, office, profession etc 1f359ece | 2007-10-23 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 3 | 2007-10-23-1f359ece-10001-0 |
9df92bbab65f5ec9964de3f07b01e3ca28bee200 | Television programmes, as a presenter for BBC One's weekly programme "This Week" from June ongoing. (Actual £8,800) (£5,001-£10,000) (Registered 8 November 2006) | Remunerated employment, office, profession etc 1f359ece | 2007-10-23 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 4 | 2007-10-23-1f359ece-10001-0 |
f4f46c6e3ac954b70b5f4c8d919656be3d45544d | September 2006, lecture fees, Arcadia University. (Actual £800) (Up to £5,000) (Registered 8 November 2006) | Remunerated employment, office, profession etc 1f359ece | 2007-10-23 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 5 | 2007-10-23-1f359ece-10001-0 |
13097f1755ee7b7bd2929db96cfb11e4bcd58b48 | November-December 2006, weekly, fees for articles in Evening Standard, ongoing. (Actual £3,200) (Up to £5,000) (Registered 22 January 2007) | Remunerated employment, office, profession etc 1f359ece | 2007-10-23 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 6 | 2007-10-23-1f359ece-10001-0 |
2e16c7e16c2efdd08ec9d24eebc64e5c94add6a1 | November-December 2006, bi-weekly fees for article in The Voice newspaper, ongoing. (Actual £600) (Up to £5,000) (Registered 22 January 2007) | Remunerated employment, office, profession etc 1f359ece | 2007-10-23 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 7 | 2007-10-23-1f359ece-10001-0 |
aab0e1de4d8fe19448bd6a9b15c219b37b16f50d | Television programmes, as a presenter for BBC One's weekly programme "This Week" from November 2006, ongoing. (Actual £5,600) (£5,001-£10,000) (Registered 22 January 2007) | Remunerated employment, office, profession etc 1f359ece | 2007-10-23 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 8 | 2007-10-23-1f359ece-10001-0 |
cbfe9f75b7a4d50837ec7dfc05dc6686e04bd511 | January 2007, weekly, fees for articles in Evening Standard, final. (Actual £1,600) (Up to £5,000) (Registered 20 March 2007) | Remunerated employment, office, profession etc 1f359ece | 2007-10-23 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 9 | 2007-10-23-1f359ece-10001-0 |
96a554a3f57507ded55f26bd4faf30a0b85f0b71 | January-March 2007, bi-weekly fees for article in The Voice newspaper, ongoing. (Actual £600) (Up to £5,000) (Registered 20 March 2007) | Remunerated employment, office, profession etc 1f359ece | 2007-10-23 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 10 | 2007-10-23-1f359ece-10001-0 |
18f6d098d9c55308c94eaff1714d71abcc656398 | Television programmes, as a presenter for BBC One's weekly programme "This Week", from January 2007, ongoing. (Actual £8,800) (£5,001-£10,000) (Registered 20 March 2007) | Remunerated employment, office, profession etc 1f359ece | 2007-10-23 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 11 | 2007-10-23-1f359ece-10001-0 |
95d3cb560111031e92c7459a7ab04606eeb22805 | Pre-production fee for BBC's "Play It Again". (Actual £14,326) (£10,001-£15,000) (Registered 20 March 2007) | Remunerated employment, office, profession etc 1f359ece | 2007-10-23 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 12 | 2007-10-23-1f359ece-10001-0 |
b5e38608822ced13c48596a3d332747188316827 | January 2007, lecture fees, Arcadia University. (Actual £400) (Up to £5,000) (Registered 20 March 2007) | Remunerated employment, office, profession etc 1f359ece | 2007-10-23 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 13 | 2007-10-23-1f359ece-10001-0 |
05e3081520e9e4143cd7be110ee690d441d85077 | April-July 2007, bi-weekly fees for article in The Voice newspaper, ongoing. (Actual £600) (Up to £5,000) (Registered 27 July 2007) | Remunerated employment, office, profession etc 1f359ece | 2007-10-23 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 14 | 2007-10-23-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");