items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
10 rows where record_id = "2009-10-14-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 |
---|---|---|---|---|---|---|---|
a7004bb8afb9a27bf16b5d4e508838be4ac26e1e | May 2008, fees as a presenter on BBC One's 'This Week' programme, ongoing. (Actual £2,457). (gaered 25 June 2008) | Remunerated employment, office, profession etc 1f359ece | 2009-10-14 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 0 | 2009-10-14-1f359ece-10001-0 |
1cd11496a84502e96305dec7c018f846badadbc2 | October 2008, fees for three Arcadia Lectures for the School of Oriental and Asian Studies, London. (Actual £900) (Up to £5,000) (Registered 4 November 2008) | Remunerated employment, office, profession etc 1f359ece | 2009-10-14 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 1 | 2009-10-14-1f359ece-10001-0 |
bb96a02f4842c4bc1c19ea725dab735dcd951ca7 | October 2008, fees as a presenter on BBC One's 'This Week' programme, ongoing. (Actual £5,733) (£5,001-£10,000) (Registered 4 November 2008) | Remunerated employment, office, profession etc 1f359ece | 2009-10-14 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 2 | 2009-10-14-1f359ece-10001-0 |
c60203d20d4db11374b32f1d165054014190f6cb | October 2008, fees for articles for Sugar Media. (Actual £800) (Up to £5,000) (Registered 4 November 2008) | Remunerated employment, office, profession etc 1f359ece | 2009-10-14 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 3 | 2009-10-14-1f359ece-10001-0 |
13b8a90abf1b2b0f7659f247ebdfc9e2c93bd643 | October 2008, fees for articles in the Guardian and the Observer, ongoing. (Actual £1,510) (Up to £5,000) (Registered 4 November 2008) | Remunerated employment, office, profession etc 1f359ece | 2009-10-14 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 4 | 2009-10-14-1f359ece-10001-0 |
ce4ecbcda805764e47b3581dfd291196101ca151 | November 2008, fees as a presenter on BBC One's 'This Week' programme, ongoing. (Actual £4,457) (Up to £5,000) (Registered 12 January 2009) | Remunerated employment, office, profession etc 1f359ece | 2009-10-14 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 5 | 2009-10-14-1f359ece-10001-0 |
de2cc54f5ddd77acdf802024ce1ea33b18b157bb | December 2008, fees as a presenter on BBC One's 'This Week' programme, ongoing. (Actual £4,095) (Up to £5,000) (Registered 12 January 2009) | Remunerated employment, office, profession etc 1f359ece | 2009-10-14 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 6 | 2009-10-14-1f359ece-10001-0 |
88433e9f581b0aeba8a5259879168fd56332fc9c | January 2009, fees as a presenter for BBC One's 'This Week' programme, ongoing. (Actual £2,517) (Up to £5,000) (Registered 16 February 2009) | Remunerated employment, office, profession etc 1f359ece | 2009-10-14 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 7 | 2009-10-14-1f359ece-10001-0 |
d4f1b94c4f3888cfc76fb2d6114909a10560a983 | February 2009, fees as a presenter for BBC One's 'This Week' programme, ongoing. (Actual £3,356) (Up to £5,000) (Registered 23 March 2009) | Remunerated employment, office, profession etc 1f359ece | 2009-10-14 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 8 | 2009-10-14-1f359ece-10001-0 |
01483c940c55312d9ed5be95824c9b9e2ff857af | March 2009, fees for articles in the Guardian and the Observer, ongoing. (Actual £1,250) (Up to £5,000) (Registered 24 March 2009) | Remunerated employment, office, profession etc 1f359ece | 2009-10-14 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 9 | 2009-10-14-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");