items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
11 rows where record_id = "2009-05-06-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 |
---|---|---|---|---|---|---|---|
87c9f54e6935c20fb925c0b86220897a6487d059 | April 2008, fees as a presenter on BBC One's 'This Week' programme, ongoing. (Actual £1,638) (Up to £5,000) (Registered 9 May 2008) | Remunerated employment, office, profession etc 1f359ece | 2009-05-06 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 0 | 2009-05-06-1f359ece-10001-0 |
b1bb104207ad1468e212919d94a8add6bb8b13d8 | May 2008, fees as a presenter on BBC One's 'This Week' programme, ongoing. (Actual £2,457). (Registered 25 June 2008) | Remunerated employment, office, profession etc 1f359ece | 2009-05-06 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 1 | 2009-05-06-1f359ece-10001-0 |
82fd408e06d3bd0cee2787c3399dac8c00356b9c | 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-05-06 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 2 | 2009-05-06-1f359ece-10001-0 |
e44a4a9254568529139c928d02936ebfc7015bf8 | 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-05-06 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 3 | 2009-05-06-1f359ece-10001-0 |
5590442fdbc81f5947e046c92d6f959c497e6975 | 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-05-06 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 4 | 2009-05-06-1f359ece-10001-0 |
7030b86c60a58970d93e701b1aa2eee1bff88c85 | 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-05-06 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 5 | 2009-05-06-1f359ece-10001-0 |
65e21f1749e6ca699281c6ef698d61b2495f0582 | 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-05-06 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 6 | 2009-05-06-1f359ece-10001-0 |
02a800ce9eb30ec1767b0e5369ab7d43a0970a52 | 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-05-06 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 7 | 2009-05-06-1f359ece-10001-0 |
2b83966373b97950c9406ce65a45049761a043ad | 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-05-06 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 8 | 2009-05-06-1f359ece-10001-0 |
1f1a045c809906efb66226538df7636b279f7205 | 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-05-06 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 9 | 2009-05-06-1f359ece-10001-0 |
6b2bf3d028a3fdf10343d95fea65bb6f4acd7761 | 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-05-06 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 10 | 2009-05-06-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");