items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
8 rows where record_id = "2008-06-16-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 |
---|---|---|---|---|---|---|---|
ba2214102309ab795b3767240d9ff0217cf0f0ee | April-July 2007, bi-weekly fees for article in The Voice newspaper, ongoing. (Actual £600) (Up to £5,000) (Registered 27 July 2007) | Remunerated employment, office, profession etc 1f359ece | 2008-06-16 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 0 | 2008-06-16-1f359ece-10001-0 |
a977b923ae2b6a2b768fa22f6d11b249f43c16b8 | April 2007 to date, fees for presenting BBC One's programme "This Week", ongoing. (Actual £20,800) (£20,001-£25,000) (Registered 14 January 2008) | Remunerated employment, office, profession etc 1f359ece | 2008-06-16 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 1 | 2008-06-16-1f359ece-10001-0 |
3f2170bc921a166912edbbb4956015e9e514c212 | January 2008, fees as a presenter for BBC One's 'This Week' weekly programme, ongoing. (Actual £1,676) (Up to £5,000) (Registered 30 January 2008) | Remunerated employment, office, profession etc 1f359ece | 2008-06-16 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 2 | 2008-06-16-1f359ece-10001-0 |
b4e36c6b118fbeeb5d2c57edefad7fc3b70338b2 | January 2008, fee for speaking to employees of Accenture as part of diversity week. (Actual £4,000) (Up to £5,000) (Registered 22 February 2008) | Remunerated employment, office, profession etc 1f359ece | 2008-06-16 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 3 | 2008-06-16-1f359ece-10001-0 |
e9ce7e924700902e8898c20d2d8a1034b6b861f8 | February 2008, fees as a presenter for BBC One's 'This Week' programme, ongoing. (Actual £2,457) (Up to £5,000) (Registered 7 March 2008) | Remunerated employment, office, profession etc 1f359ece | 2008-06-16 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 4 | 2008-06-16-1f359ece-10001-0 |
d85df91a564c2bc15365a8779059802ff12ac9b4 | March 2008, fee for speaking at the Association of Guernsey Banks Annual Dinner. (Up to £5,000) (Registered 11 March 2008) | Remunerated employment, office, profession etc 1f359ece | 2008-06-16 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 5 | 2008-06-16-1f359ece-10001-0 |
b306e3337d278d95ba908ad4e7574a6588f627c5 | March 2008, fees as a presenter for BBC One's 'This Week' programme, ongoing. (Actual £3,276) (Up to £5,000) (Registered 9 April 2008) | Remunerated employment, office, profession etc 1f359ece | 2008-06-16 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 6 | 2008-06-16-1f359ece-10001-0 |
01b2acc30c53f7fed9ae8f97553c40d7149d725b | 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 | 2008-06-16 | Diane Abbott uk.org.publicwhip/member/1604 | Diane Abbott uk.org.publicwhip/person/10001 | 7 | 2008-06-16-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");