items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
11 rows where record_id = "2006-03-24-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 |
---|---|---|---|---|---|---|---|
af8200d878874829989a758ddd31fc1992dcf583 | Arcadia Lectures in 2004 for School of Oriental and African Studies, London. (Up to £5,000) | Remunerated employment, office, profession etc 1f359ece | 2006-03-24 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 0 | 2006-03-24-1f359ece-10001-0 |
5cdc9ee841ddc8a043fb264fb7b0d09b61e2e827 | 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 | 2006-03-24 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 1 | 2006-03-24-1f359ece-10001-0 |
57e820141935215bff7b36ce03f9626660dc73a0 | 25 January 2005, fee for Student Lectures. (Up to £5,000) (Registered 8 April 2005) | Remunerated employment, office, profession etc 1f359ece | 2006-03-24 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 2 | 2006-03-24-1f359ece-10001-0 |
b3b9437b920e5de50b78f9d6987cce77a8c85506 | 13 February 2005, fee for article in Sunday Times. (Up to £5,000) (Registered 8 April 2005) | Remunerated employment, office, profession etc 1f359ece | 2006-03-24 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 3 | 2006-03-24-1f359ece-10001-0 |
002ae2b5c74426dd1e57b2fc1b99fcb8cb6848a5 | 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 | 2006-03-24 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 4 | 2006-03-24-1f359ece-10001-0 |
1d86da8aa8f8e1ed14153df6cadb3a164f73c1c7 | 18 February 2005, fee for article in Guardian. (Up to £5,000) (Registered 8 April 2005) | Remunerated employment, office, profession etc 1f359ece | 2006-03-24 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 5 | 2006-03-24-1f359ece-10001-0 |
02302de3beac20fe096fb0271bbd9547563ad15a | 7 March 2005, fee for article in Daily Express. (Up to £5,000) (Registered 8 April 2005) | Remunerated employment, office, profession etc 1f359ece | 2006-03-24 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 6 | 2006-03-24-1f359ece-10001-0 |
049066cd1b2c6f5f6caae838cf15bb2f542acd84 | 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 | 2006-03-24 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 7 | 2006-03-24-1f359ece-10001-0 |
c8a3774cf9da033d391455533ee1efc88882582f | 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-03-24 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 8 | 2006-03-24-1f359ece-10001-0 |
ea5a3bb5eb1114ab9b698408df26628f9f8acf89 | 7 June 2005, fee for article in Evening Standard. (Up to £5,000) (Registered 1 July 2005) | Remunerated employment, office, profession etc 1f359ece | 2006-03-24 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 9 | 2006-03-24-1f359ece-10001-0 |
ff810bef14bc37fe07012a47132209b061758306 | 6 July 2005, fee for Student Lectures. (Up to £5,000) (Registered 1 July 2005) | Remunerated employment, office, profession etc 1f359ece | 2006-03-24 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 10 | 2006-03-24-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");