items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
19 rows where record_id = "2006-12-11-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 |
---|---|---|---|---|---|---|---|
7190f98850873e1da28e163387df177b62807173 | 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 | 2006-12-11 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 0 | 2006-12-11-1f359ece-10001-0 |
fe6ed81ae8264f6dbab969f08af74bf1b1359719 | October 2005, BBC Celebrity Mastermind. (Actual £2,750) (Up to £5,000) (Registered 31 March 2006) | Remunerated employment, office, profession etc 1f359ece | 2006-12-11 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 1 | 2006-12-11-1f359ece-10001-0 |
284983d781ea7cbe67613f9396174943187749dc | October 2005, BBC University Challenge. (Up to £5,000) (Registered 31 March 2006) | Remunerated employment, office, profession etc 1f359ece | 2006-12-11 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 2 | 2006-12-11-1f359ece-10001-0 |
328bb943c090cd3d4df68e069e20bae0b430f4eb | September 2005-December 2005, weekly, fees for articles in Evening Standard (Actual £5,600) (£5,001-£10,000) (Registered 31 March 2006) | Remunerated employment, office, profession etc 1f359ece | 2006-12-11 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 3 | 2006-12-11-1f359ece-10001-0 |
b323c45a272955a2001ddb88a6afb475a25b5271 | 25 November 2005, fee for article in Daily Mail. (Actual £850) (Up to £5,000) (Registered 31 March 2006) | Remunerated employment, office, profession etc 1f359ece | 2006-12-11 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 4 | 2006-12-11-1f359ece-10001-0 |
a43edabaf84bdd20af4ebfc73d0765449e2f976d | 25 January 2006-May 2006, fees for bi-weekly article in The Voice newspaper. (Actual £2,450) (Up to £5,000) (Registered 9 May 2006) | Remunerated employment, office, profession etc 1f359ece | 2006-12-11 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 5 | 2006-12-11-1f359ece-10001-0 |
2a19a45576ceeec08d98218453da1ed8281592df | 17 March 2006, fee for article in The Times. (Actual £900) (Up to £5,000) (Registered 31 March 2006) | Remunerated employment, office, profession etc 1f359ece | 2006-12-11 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 6 | 2006-12-11-1f359ece-10001-0 |
261a2b1c14c0e1062f15b6a3c8045a461dc67a03 | Television programmes, as a presenter for BBC One's weekly programme "This Week" from September 2005-March 2006. (£10,001-£15,000) (Registered 31 March 2006 | Remunerated employment, office, profession etc 1f359ece | 2006-12-11 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 7 | 2006-12-11-1f359ece-10001-0 |
cf1ec7e1ef62eaecd9cd647b57a4333fa0245272 | January 2006-April 2006, weekly, fees for articles in Evening Standard. (Actual £6,400) (£5,001-£10,000) (Registered 9 May 2006) | Remunerated employment, office, profession etc 1f359ece | 2006-12-11 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 8 | 2006-12-11-1f359ece-10001-0 |
dc5ce376407433f4d7f9ae9414f45fe836d2e7e1 | Television programmes, as a presenter for BBC One's weekly programme "This Week" from April 2006. (Actual £1,600) (Up to £5,000) (Registered 9 May 2006) | Remunerated employment, office, profession etc 1f359ece | 2006-12-11 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 9 | 2006-12-11-1f359ece-10001-0 |
2ab4295ea0b5d07be3ab8ce3e74f6444bdea3ce1 | May 2006, weekly, fees for articles in Evening Standard. (Actual £2,100) (Up to £5,000) (Registered 1 June 2006) | Remunerated employment, office, profession etc 1f359ece | 2006-12-11 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 10 | 2006-12-11-1f359ece-10001-0 |
0b8905f32abcdbf6edd726e2b4afa1f8df67792b | Television programmes, as a presenter for BBC One's weekly programme "This Week" from May. (Actual £800) (Up to £5,000) (Registered 1 June 2006) | Remunerated employment, office, profession etc 1f359ece | 2006-12-11 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 11 | 2006-12-11-1f359ece-10001-0 |
6cb5ae0122ae1947647ef7ae7bf1cb77fd21789b | Television programme, appearance on BBC Two's "Have I Got News for You" (Actual £1,000) (Up to £5,000) (Registered 1 June 2006) | Remunerated employment, office, profession etc 1f359ece | 2006-12-11 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 12 | 2006-12-11-1f359ece-10001-0 |
b7eda45e583d6f7e390b250b2acd481a264c2f36 | May 2006, fee for article in The Times. (Up to £5,000) (Registered 1 June 2006) | Remunerated employment, office, profession etc 1f359ece | 2006-12-11 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 13 | 2006-12-11-1f359ece-10001-0 |
eb570b953f8d99d5cb3df2fd33ac19e6ecef67b6 | 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 | 2006-12-11 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 14 | 2006-12-11-1f359ece-10001-0 |
15ef0c0e705500196091d0ffa0e8450fda13e385 | 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 | 2006-12-11 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 15 | 2006-12-11-1f359ece-10001-0 |
15462e58744da53e378625ba7dfbb7615a15bda7 | August 2006, fee for article in The Times. (Actual £900) (Up to £5,000) (Registered 8 November 2006) | Remunerated employment, office, profession etc 1f359ece | 2006-12-11 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 16 | 2006-12-11-1f359ece-10001-0 |
1ed0186fec263b25a9bf86b05886bb64222c49f6 | 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 | 2006-12-11 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 17 | 2006-12-11-1f359ece-10001-0 |
034fb893a0f335838cc078a9ffe1050233dcebcd | September 2006, lecture fees, Arcadia University. (Actual £800) (Up to £5,000) (Registered 8 November 2006) | Remunerated employment, office, profession etc 1f359ece | 2006-12-11 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 18 | 2006-12-11-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");