items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
13 rows where record_id = "2006-05-12-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 |
---|---|---|---|---|---|---|---|
457c2050a2e334d858446c4159673fbbcf234eeb | Television programmes, as a presenter for BBC One's weekly programme "This Week" from April-July 2005 ongoing. (Up to £5,000) Registered 1 July 2005) | Remunerated employment, office, profession etc 1f359ece | 2006-05-12 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 0 | 2006-05-12-1f359ece-10001-0 |
eed7eead8f8d37014ab348d2f7ef85f2bc1ac681 | 7 June 2005, fee for article in Evening Standard. (Up to £5,000) (Registered 1 July 2005) | Remunerated employment, office, profession etc 1f359ece | 2006-05-12 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 1 | 2006-05-12-1f359ece-10001-0 |
0256a4e0e230351600d6c4fe5063c53dc4641d40 | 6 July 2005, fee for Student Lectures. (Up to £5,000) (Registered 1 July 2005) | Remunerated employment, office, profession etc 1f359ece | 2006-05-12 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 2 | 2006-05-12-1f359ece-10001-0 |
e8916b6208fb579191369d6c19237201387cdbad | 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-05-12 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 3 | 2006-05-12-1f359ece-10001-0 |
4f7816e2effde84a454444e877f5a0f8eec0ad30 | October 2005, BBC Celebrity Mastermind. (Actual £2,750) (Up to £5,000) (Registered 31 March 2006) | Remunerated employment, office, profession etc 1f359ece | 2006-05-12 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 4 | 2006-05-12-1f359ece-10001-0 |
30207607d81b5abb4fce7be74af72b9c9fb873a6 | October 2005, BBC University Challenge. (Up to £5,000) (Registered 31 March 2006) | Remunerated employment, office, profession etc 1f359ece | 2006-05-12 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 5 | 2006-05-12-1f359ece-10001-0 |
b9ad5eaaa7fc08e27c49f7f3de2f2f415e4e7f63 | September 2005-December 2005, weekly, fees for articles in Evening Standard, ongoing (Actual £5,600) (£5,001-£10,000) (Registered 31 March 2006) | Remunerated employment, office, profession etc 1f359ece | 2006-05-12 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 6 | 2006-05-12-1f359ece-10001-0 |
a5a438d6cc3be44839d31f40612a0db794e73d0a | 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-05-12 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 7 | 2006-05-12-1f359ece-10001-0 |
779985de7fd1f2626789b397dbd0451c1970b540 | 25 January 2006-April 2006, fees for bi-weekly article in The Voice newspaper, ongoing. (Actual £2,000) (Up to £5,000) (Registered 9 May 2006) | Remunerated employment, office, profession etc 1f359ece | 2006-05-12 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 8 | 2006-05-12-1f359ece-10001-0 |
5e96b6a17eb1255ee68002a778dc9c2a1de13a41 | 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-05-12 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 9 | 2006-05-12-1f359ece-10001-0 |
21e3b5c4e207493adda44cc8408b3b13fe5f6537 | Television programmes, as a presenter for BBC One's weekly programme "This Week" from September 2005-March 2006, ongoing. (£10,001-£15,000) (Registered 31 March 2006 | Remunerated employment, office, profession etc 1f359ece | 2006-05-12 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 10 | 2006-05-12-1f359ece-10001-0 |
2b772f7fc46071cf0eec071c87db16511373c067 | January 2006-April 2006, weekly, fees for articles in Evening Standard, ongoing (Actual £6,400) (£5,001-£10,000) (Registered 9 May 2006) | Remunerated employment, office, profession etc 1f359ece | 2006-05-12 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 11 | 2006-05-12-1f359ece-10001-0 |
97ad27c8fd3b4f31ab08faf020a6268668c68a77 | Television programmes, as a presenter for BBC One's weekly programme "This Week" from April 2006, ongoing. (Actual £1,600) (Up to £5,000) (Registered 9 May 2006) | Remunerated employment, office, profession etc 1f359ece | 2006-05-12 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 12 | 2006-05-12-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");