items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
7 rows where record_id = "2004-10-22-1f359ece-10001-0" sorted by sort_order descending
This data as json, CSV (advanced)
Suggested facets: date (date)
hash | item | category_id | date | member_id | person_id | sort_order ▲ | record_id |
---|---|---|---|---|---|---|---|
631d7e667f47d8522d67729af89700dd02184f0c | 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 | 2004-10-22 | Diane Abbott uk.org.publicwhip/member/687 | Diane Abbott uk.org.publicwhip/person/10001 | 6 | 2004-10-22-1f359ece-10001-0 |
5ae304d2a07d61ce46a5e052371d80b11118b5b0 | 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 | 2004-10-22 | Diane Abbott uk.org.publicwhip/member/687 | Diane Abbott uk.org.publicwhip/person/10001 | 5 | 2004-10-22-1f359ece-10001-0 |
9c21566ee31d2b5d6fb7eaaa59afafd5e4745456 | 2 November 2003, fee for article in The Mail on Sunday. (Up to £5,000) (Registered 23 December 2003) | Remunerated employment, office, profession etc 1f359ece | 2004-10-22 | Diane Abbott uk.org.publicwhip/member/687 | Diane Abbott uk.org.publicwhip/person/10001 | 4 | 2004-10-22-1f359ece-10001-0 |
c1c8f5f8741a77a6707761a71a03698ea2817eb6 | 2 November 2003, fee for article in the Sunday Times. (Up to £5,000) (Registered 23 December 2003) | Remunerated employment, office, profession etc 1f359ece | 2004-10-22 | Diane Abbott uk.org.publicwhip/member/687 | Diane Abbott uk.org.publicwhip/person/10001 | 3 | 2004-10-22-1f359ece-10001-0 |
8c29269eadd04f8e4dc85e8e668e167880923400 | Arcadia Lectures in 2003 for School of Oriental and African Studies, London (Up to £5,000) | Remunerated employment, office, profession etc 1f359ece | 2004-10-22 | Diane Abbott uk.org.publicwhip/member/687 | Diane Abbott uk.org.publicwhip/person/10001 | 2 | 2004-10-22-1f359ece-10001-0 |
a9587c9b053f3200438842eaae83394e00745cb3 | 28 July-1 August 2003, five days presentation of radio show for LBC (Up to £5,000) | Remunerated employment, office, profession etc 1f359ece | 2004-10-22 | Diane Abbott uk.org.publicwhip/member/687 | Diane Abbott uk.org.publicwhip/person/10001 | 1 | 2004-10-22-1f359ece-10001-0 |
4367772f02dd3c7dd69b891867298ec80fbafd09 | Television programmes, as a presenter for BBC One's weekly programme "This Week", from January 2003. (£15,001-£20,000) | Remunerated employment, office, profession etc 1f359ece | 2004-10-22 | Diane Abbott uk.org.publicwhip/member/687 | Diane Abbott uk.org.publicwhip/person/10001 | 0 | 2004-10-22-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");