items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
14 rows where record_id = "2007-07-17-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 |
---|---|---|---|---|---|---|---|
b92cb5de5de04f5f1629285f3fab3676818d41df | 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-07-17 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 0 | 2007-07-17-1f359ece-10001-0 |
960830b57b70a15329de12175791f18651ca9f33 | 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-07-17 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 1 | 2007-07-17-1f359ece-10001-0 |
7f129b4ebea2c6be3c8797b40d930a9e6a0c4099 | 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-07-17 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 2 | 2007-07-17-1f359ece-10001-0 |
c7f1945c485515670e81ea27c527675c59b30673 | 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-07-17 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 3 | 2007-07-17-1f359ece-10001-0 |
c1fe2eb524361f657cd6a03ae3ec37d0b003dd2b | 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-07-17 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 4 | 2007-07-17-1f359ece-10001-0 |
135c31176978cecd17272fce4f649b4f5e23fdeb | September 2006, lecture fees, Arcadia University. (Actual £800) (Up to £5,000) (Registered 8 November 2006) | Remunerated employment, office, profession etc 1f359ece | 2007-07-17 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 5 | 2007-07-17-1f359ece-10001-0 |
3af0801cf83834a99628a5eb22c51959facb5964 | 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-07-17 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 6 | 2007-07-17-1f359ece-10001-0 |
1a288585d9e52aba6e7dff396fd44f6a37efdcdd | 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-07-17 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 7 | 2007-07-17-1f359ece-10001-0 |
bbf77075463a83fb80158ea90c1a60511b7aa145 | 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-07-17 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 8 | 2007-07-17-1f359ece-10001-0 |
b2fbbd7b3ec7cc261217fa22c6345f0ef87366d4 | 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-07-17 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 9 | 2007-07-17-1f359ece-10001-0 |
85dca3be2929017434e8f34c4cdbc0c8055cd140 | 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-07-17 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 10 | 2007-07-17-1f359ece-10001-0 |
02d00512af9ecaa84b41428497f0e31e61a12ca4 | 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-07-17 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 11 | 2007-07-17-1f359ece-10001-0 |
c2e002cec38a879ec7065085aec9b6cec3d54a51 | 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-07-17 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 12 | 2007-07-17-1f359ece-10001-0 |
b2ee1b0a6098d7c97433dd9442f78a66a13f699d | January 2007, lecture fees, Arcadia University. (Actual £400) (Up to £5,000) (Registered 20 March 2007) | Remunerated employment, office, profession etc 1f359ece | 2007-07-17 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 13 | 2007-07-17-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");