items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
9 rows where record_id = "2010-02-03-1f359ece-10115-0" sorted by date descending
This data as json, CSV (advanced)
Suggested facets: date (date)
| hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
|---|---|---|---|---|---|---|---|
| 3c9f875c5d0ee132e91ef014bffef4c6c8dd8e5d | Member of Advisory Board of AgCapita Partners LP (October 2008-November 2009). | Remunerated employment, office, profession etc 1f359ece | 2010-02-03 | Kenneth Clarke uk.org.publicwhip/member/1794 | Kenneth Clarke uk.org.publicwhip/person/10115 | 0 | 2010-02-03-1f359ece-10115-0 |
| 5e524d9345c1f309a0b3015c08f27c2545f58a7a | Programmes on jazz for BBC Radio 4. | Remunerated employment, office, profession etc 1f359ece | 2010-02-03 | Kenneth Clarke uk.org.publicwhip/member/1794 | Kenneth Clarke uk.org.publicwhip/person/10115 | 1 | 2010-02-03-1f359ece-10115-0 |
| 8ebbbb8dc0065dddd48e5b2dd37d8f7b26700841 | 16 June 2008, fee for speaking engagement at the International Energy Credit Association Conference at the Divani Appollon Palace, Athens. (Up to £5,000) Flight, hotel and other incidental expenses paid by IECA. (Registered 7 July 2008) | Remunerated employment, office, profession etc 1f359ece | 2010-02-03 | Kenneth Clarke uk.org.publicwhip/member/1794 | Kenneth Clarke uk.org.publicwhip/person/10115 | 2 | 2010-02-03-1f359ece-10115-0 |
| ccffa6328ecc01ff950bd952426f37fc5e322a94 | 18-19 June 2008, fee for speaking engagements for Cofunds Ltd, at Marriott Hotel, Bristol and Pendley Manor Hotel, Tring, organised by Speakers Corner. (£5,001-£10,000) Hotel and travel expenses paid by Cofunds Ltd. (Registered 7 July 2008) | Remunerated employment, office, profession etc 1f359ece | 2010-02-03 | Kenneth Clarke uk.org.publicwhip/member/1794 | Kenneth Clarke uk.org.publicwhip/person/10115 | 3 | 2010-02-03-1f359ece-10115-0 |
| c8f96c3edc1ae2689bd2026d561cb7efc3e72a72 | 9 July 2008, fee for speaking engagement at a conference held by Equiniti Limited at the British Film Institute. (Up to £5,000) (Registered 15 July 2008) | Remunerated employment, office, profession etc 1f359ece | 2010-02-03 | Kenneth Clarke uk.org.publicwhip/member/1794 | Kenneth Clarke uk.org.publicwhip/person/10115 | 4 | 2010-02-03-1f359ece-10115-0 |
| 07647b9efc883511c29405db8dc5e09d6f1dab1e | 2 October 2008, fee for speaking engagement at the UBS Annual Leisure Sector Dinner, at The Ivy Restaurant, London, organised by DBA Speakers. (£5,001-£10,000)(Registered 7 October 2008) | Remunerated employment, office, profession etc 1f359ece | 2010-02-03 | Kenneth Clarke uk.org.publicwhip/member/1794 | Kenneth Clarke uk.org.publicwhip/person/10115 | 5 | 2010-02-03-1f359ece-10115-0 |
| 756fa0a0d2470227e5b0bc28a582e2ecefc555a7 | 16 October 2008, fee for speaking engagement at a lunch held by Goldman Sachs at their London offices, arranged by Celebrity Speakers Ltd. (Up to £5,000) (Registered 27 October 2008) | Remunerated employment, office, profession etc 1f359ece | 2010-02-03 | Kenneth Clarke uk.org.publicwhip/member/1794 | Kenneth Clarke uk.org.publicwhip/person/10115 | 6 | 2010-02-03-1f359ece-10115-0 |
| 2214959a661d0973315e06c2f0e2c60e9f2c3187 | 12 November 2008, fee for speaking engagement at a seminar on Credit held by BGC International at the Bloomberg Auditorium. (Up to £5,000) (Registered 17 November 2008) | Remunerated employment, office, profession etc 1f359ece | 2010-02-03 | Kenneth Clarke uk.org.publicwhip/member/1794 | Kenneth Clarke uk.org.publicwhip/person/10115 | 7 | 2010-02-03-1f359ece-10115-0 |
| d783f51f3fbfd80c314c4d857c09041a99359488 | 20 November 2008, fee for speaking engagement at a seminar held by HG Capital at the Jumeirah Carlton Tower Hotel, London, arranged by Celebrity Speakers Ltd. (Up to £5,000) (Registered 8 December 2008) | Remunerated employment, office, profession etc 1f359ece | 2010-02-03 | Kenneth Clarke uk.org.publicwhip/member/1794 | Kenneth Clarke uk.org.publicwhip/person/10115 | 8 | 2010-02-03-1f359ece-10115-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");