items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
18 rows where record_id = "2007-05-15-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 |
---|---|---|---|---|---|---|---|
d7f91b15aa0b207dc62efd32d2d66d63fd803f91 | 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-05-15 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 0 | 2007-05-15-1f359ece-10001-0 |
3fc0e238c080029f3a47d7dbdfb2c95a45a75ab3 | 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 | 2007-05-15 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 1 | 2007-05-15-1f359ece-10001-0 |
428eebe7a13fa3cac213902db908d46b988fcfa9 | 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 | 2007-05-15 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 2 | 2007-05-15-1f359ece-10001-0 |
c11c716820c06d4305667af3757ebeef8863fdf7 | 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 | 2007-05-15 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 3 | 2007-05-15-1f359ece-10001-0 |
b48d1cfb2ef040c355040acbd55e61de7afb7a11 | May 2006, fee for article in The Times. (Up to £5,000) (Registered 1 June 2006) | Remunerated employment, office, profession etc 1f359ece | 2007-05-15 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 4 | 2007-05-15-1f359ece-10001-0 |
e386e0f138942e34716acd4a928732d58566567b | 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-05-15 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 5 | 2007-05-15-1f359ece-10001-0 |
012a873fa1a771cc3e11b5d988fbd555710e7648 | 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-05-15 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 6 | 2007-05-15-1f359ece-10001-0 |
f28d6d4c641334133f74937c8e4ecbf703eda671 | 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-05-15 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 7 | 2007-05-15-1f359ece-10001-0 |
f07a66044d195a4e4fa088c2f0d0d1751490d868 | 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-05-15 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 8 | 2007-05-15-1f359ece-10001-0 |
14749bfd41d7148e45837ec7452c2b672e48994f | September 2006, lecture fees, Arcadia University. (Actual £800) (Up to £5,000) (Registered 8 November 2006) | Remunerated employment, office, profession etc 1f359ece | 2007-05-15 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 9 | 2007-05-15-1f359ece-10001-0 |
925905971a0e6c6bad985d5f7d56cb21c6b3873c | 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-05-15 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 10 | 2007-05-15-1f359ece-10001-0 |
1ebfe7abd9376fb70c5f5f92bb6507955102130f | 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-05-15 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 11 | 2007-05-15-1f359ece-10001-0 |
b9352d2ad84a6d136ca936d989bbe96ea7b55cca | 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-05-15 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 12 | 2007-05-15-1f359ece-10001-0 |
3e278f3ad1774897be6385c7ffc89a9b4d05f0d6 | 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-05-15 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 13 | 2007-05-15-1f359ece-10001-0 |
3751865d1e22e325359aaf7f16c9ae374ba719ce | 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-05-15 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 14 | 2007-05-15-1f359ece-10001-0 |
88be4b9b292407732755bdc59741129d1c8c2ee1 | 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-05-15 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 15 | 2007-05-15-1f359ece-10001-0 |
a798de3c2dfa10c72b53098e3671d4f5fd6758e6 | 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-05-15 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 16 | 2007-05-15-1f359ece-10001-0 |
be8d008cce5b2c5a04f9e583996d9c6967331bc9 | January 2007, lecture fees, Arcadia University. (Actual £400) (Up to £5,000) (Registered 20 March 2007) | Remunerated employment, office, profession etc 1f359ece | 2007-05-15 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 17 | 2007-05-15-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");