items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
13 rows where record_id = "2005-04-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 |
---|---|---|---|---|---|---|---|
dcf6f227f21916440affc2e469146e84801dbaef | Television programmes (as a participant) for BBC One programme "This Week", from January-May 2004. (£10,001-£15,000) | Remunerated employment, office, profession etc 1f359ece | 2005-04-11 | Diane Abbott uk.org.publicwhip/member/687 | Diane Abbott uk.org.publicwhip/person/10001 | 0 | 2005-04-11-1f359ece-10001-0 |
74f65f7ee5b8c52c0fa36db846aa57d44eb9580e | BBC "This Week" (for BBC1) weekly series, June and July 2004, and September 2004 ongoing. (£10,001-£15,000) | Remunerated employment, office, profession etc 1f359ece | 2005-04-11 | Diane Abbott uk.org.publicwhip/member/687 | Diane Abbott uk.org.publicwhip/person/10001 | 1 | 2005-04-11-1f359ece-10001-0 |
c26dc30f745a4e11b7863764484559dc72827119 | Arcadia Lectures in 2004 for School of Oriental and African Studies, London. (Up to £5,000) | Remunerated employment, office, profession etc 1f359ece | 2005-04-11 | Diane Abbott uk.org.publicwhip/member/687 | Diane Abbott uk.org.publicwhip/person/10001 | 2 | 2005-04-11-1f359ece-10001-0 |
fb3fba2ebaea642fcca4653394027ca43d54d2d7 | Television programmes, as a presenter for BBC One's weekly programme "This Week" from October, November and December 2004 ongoing. (£10,001-£15,000) | Remunerated employment, office, profession etc 1f359ece | 2005-04-11 | Diane Abbott uk.org.publicwhip/member/687 | Diane Abbott uk.org.publicwhip/person/10001 | 3 | 2005-04-11-1f359ece-10001-0 |
8c5abbf38635988777737651a520aee4a8372faa | 14 December 2004, fee for article in Evening Standard. (Up to £5,000) (Registered 10 January 2005) | Remunerated employment, office, profession etc 1f359ece | 2005-04-11 | Diane Abbott uk.org.publicwhip/member/687 | Diane Abbott uk.org.publicwhip/person/10001 | 4 | 2005-04-11-1f359ece-10001-0 |
d5864e1ca195f508f55b37d2c06ddf1e6df1d4bd | 31 December 2004, fee for article in Daily Express. (Up to £5,000) (Registered 10 January 2005) | Remunerated employment, office, profession etc 1f359ece | 2005-04-11 | Diane Abbott uk.org.publicwhip/member/687 | Diane Abbott uk.org.publicwhip/person/10001 | 5 | 2005-04-11-1f359ece-10001-0 |
e815caa5ba071224170dfff6c210c1b63e242eed | 18 January and 8 March 2005, fees for articles in Evening Standard. (Up to £5,000) (Registered 8 April 2005) | Remunerated employment, office, profession etc 1f359ece | 2005-04-11 | Diane Abbott uk.org.publicwhip/member/687 | Diane Abbott uk.org.publicwhip/person/10001 | 6 | 2005-04-11-1f359ece-10001-0 |
b44a70f69eaaf9c120482ddad85206ac7681ee0d | 25 January 2005, fee for Student Lectures. (Up to £5,000) (Registered 8 April 2005) | Remunerated employment, office, profession etc 1f359ece | 2005-04-11 | Diane Abbott uk.org.publicwhip/member/687 | Diane Abbott uk.org.publicwhip/person/10001 | 7 | 2005-04-11-1f359ece-10001-0 |
b40dd3ff88e74fcb30ae87c0938555571bdc6424 | 13 February 2005, fee for article in Sunday Times. (Up to £5,000) (Registered 8 April 2005) | Remunerated employment, office, profession etc 1f359ece | 2005-04-11 | Diane Abbott uk.org.publicwhip/member/687 | Diane Abbott uk.org.publicwhip/person/10001 | 8 | 2005-04-11-1f359ece-10001-0 |
d129cd093b91b63e6e6f917c3ae909bdfe9a0ece | Television programme, as presenter for BBC One's Question Time 17 February 2005. (Up to £5,000) (Registered 8 April 2005) | Remunerated employment, office, profession etc 1f359ece | 2005-04-11 | Diane Abbott uk.org.publicwhip/member/687 | Diane Abbott uk.org.publicwhip/person/10001 | 9 | 2005-04-11-1f359ece-10001-0 |
dfc12288398f9aef6b3164af736020e6096bd86e | 18 February 2005, fee for article in Guardian. (Up to £5,000) (Registered 8 April 2005) | Remunerated employment, office, profession etc 1f359ece | 2005-04-11 | Diane Abbott uk.org.publicwhip/member/687 | Diane Abbott uk.org.publicwhip/person/10001 | 10 | 2005-04-11-1f359ece-10001-0 |
ee6a267dbb53600597bf6c7da47868fafcf32080 | 7 March 2005, fee for article in Daily Express. (Up to £5,000) (Registered 8 April 2005) | Remunerated employment, office, profession etc 1f359ece | 2005-04-11 | Diane Abbott uk.org.publicwhip/member/687 | Diane Abbott uk.org.publicwhip/person/10001 | 11 | 2005-04-11-1f359ece-10001-0 |
794261eb0be2b337831ef5e4d054e844e714db4a | Television programmes, as a presenter for BBC One's weekly programme "This Week" from January-March 2005 ongoing. (£5,001-£10,000) | Remunerated employment, office, profession etc 1f359ece | 2005-04-11 | Diane Abbott uk.org.publicwhip/member/687 | Diane Abbott uk.org.publicwhip/person/10001 | 12 | 2005-04-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");