items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
14 rows where record_id = "2005-11-01-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 |
---|---|---|---|---|---|---|---|
25526b9398d64ce3f08adea3b352b9387d2b8125 | Arcadia Lectures in 2004 for School of Oriental and African Studies, London. (Up to £5,000) | Remunerated employment, office, profession etc 1f359ece | 2005-11-01 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 0 | 2005-11-01-1f359ece-10001-0 |
03eda332add031f81efb98e2dc4faed1ade6097f | Television programmes, as a presenter for BBC One's weekly programme "This Week" from October, November and December 2004 ongoing. (£10,001-£15,000) (Registered 10 January 2005) | Remunerated employment, office, profession etc 1f359ece | 2005-11-01 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 1 | 2005-11-01-1f359ece-10001-0 |
2b4667657753720abf0f817b7d9ada224a75d98b | 14 December 2004, fee for article in Evening Standard. (Up to £5,000) (Registered 10 January 2005) | Remunerated employment, office, profession etc 1f359ece | 2005-11-01 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 2 | 2005-11-01-1f359ece-10001-0 |
8005cf5fa2a5a2986a2faa7cea98ca056822ff08 | 31 December 2004, fee for article in Daily Express. (Up to £5,000) (Registered 10 January 2005) | Remunerated employment, office, profession etc 1f359ece | 2005-11-01 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 3 | 2005-11-01-1f359ece-10001-0 |
974aff90f0782df087b36bdb6d02aa97921a4b79 | 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-11-01 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 4 | 2005-11-01-1f359ece-10001-0 |
4221c57f5118454372038c058b2457fa27413091 | 25 January 2005, fee for Student Lectures. (Up to £5,000) (Registered 8 April 2005) | Remunerated employment, office, profession etc 1f359ece | 2005-11-01 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 5 | 2005-11-01-1f359ece-10001-0 |
08bbee546d1de8cd188e59dd42300bbcfcb31bfc | 13 February 2005, fee for article in Sunday Times. (Up to £5,000) (Registered 8 April 2005) | Remunerated employment, office, profession etc 1f359ece | 2005-11-01 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 6 | 2005-11-01-1f359ece-10001-0 |
d3f799c518dcc1de5f9b07162c5b6abd2954de86 | 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-11-01 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 7 | 2005-11-01-1f359ece-10001-0 |
e1b2f64beb9e5b9dc12fbcec64549c04414aead5 | 18 February 2005, fee for article in Guardian. (Up to £5,000) (Registered 8 April 2005) | Remunerated employment, office, profession etc 1f359ece | 2005-11-01 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 8 | 2005-11-01-1f359ece-10001-0 |
0760b82cb88fa195da2cc36e5974eb9b8372d91b | 7 March 2005, fee for article in Daily Express. (Up to £5,000) (Registered 8 April 2005) | Remunerated employment, office, profession etc 1f359ece | 2005-11-01 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 9 | 2005-11-01-1f359ece-10001-0 |
14614e78d3988fc5603aae8567452df4db872113 | Television programmes, as a presenter for BBC One's weekly programme "This Week" from January-March 2005 ongoing. (£5,001-£10,000) (Registered 8 April 2005) | Remunerated employment, office, profession etc 1f359ece | 2005-11-01 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 10 | 2005-11-01-1f359ece-10001-0 |
ecb3018c92d4749f592b374ab23f990cfde9017e | 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 | 2005-11-01 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 11 | 2005-11-01-1f359ece-10001-0 |
4929ef030dae4aeac1228b7ab8e7d013f368d2e8 | 7 June 2005, fee for article in Evening Standard. (Up to £5,000) (Registered 1 July 2005) | Remunerated employment, office, profession etc 1f359ece | 2005-11-01 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 12 | 2005-11-01-1f359ece-10001-0 |
c9b8caa1e75e4fcf7653a2eaf9dceed0cb801284 | 6 July 2005, fee for Student Lectures. (Up to £5,000) (Registered 1 July 2005) | Remunerated employment, office, profession etc 1f359ece | 2005-11-01 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 13 | 2005-11-01-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");