items

Table actions

Data source: mySociety Data · About: simonw/register-of-members-interests-datasette

6 rows where record_id = "2004-05-21-1f359ece-10412-0" sorted by date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: date (date)

hash item category_id date ▲ member_id person_id sort_order record_id
73a56ef3eff894080664f067aa758b67f882a7d6 Monthly column for GQ Magazine, occasionally related to parliamentary affairs. (£10,001-£15,000) Remunerated employment, office, profession etc 1f359ece 2004-05-21 Peter Mandelson uk.org.publicwhip/member/1092 Peter Mandelson uk.org.publicwhip/person/10412 0 2004-05-21-1f359ece-10412-0
f159f118c79ecdd9b6ad84c57ea6a603725350ce Member of International Advisory Board of Independent News and Media PLC. Remunerated employment, office, profession etc 1f359ece 2004-05-21 Peter Mandelson uk.org.publicwhip/member/1092 Peter Mandelson uk.org.publicwhip/person/10412 1 2004-05-21-1f359ece-10412-0
5f092c49e1cc6abecd8e43ae8b31b7fe4abba743 Adviser to AM Conseil; an industrial consultancy on strategic development, including internal and external communication and change management issues. Does not include parliamentary or public affairs services. Remunerated employment, office, profession etc 1f359ece 2004-05-21 Peter Mandelson uk.org.publicwhip/member/1092 Peter Mandelson uk.org.publicwhip/person/10412 2 2004-05-21-1f359ece-10412-0
6bd24c116e98ddf330ebf0a80804c69b628750af Fees for speeches: Banctec 3 June 2003, (Registered 13 August 2003) , United Financial Group (for speaking at a debate) 26 June 2003, (Registered 13 August 2003) , the Weber Shandwick Business Breakfast 9 September 2003 (Registered 24 November 2003) , the NW Business Convention 26 September 2003 (Registered 24 November 2003), the St Helen's Chamber of Commerce 7 November 2003 (Registered 24 November 2003) . Remunerated employment, office, profession etc 1f359ece 2004-05-21 Peter Mandelson uk.org.publicwhip/member/1092 Peter Mandelson uk.org.publicwhip/person/10412 3 2004-05-21-1f359ece-10412-0
32dab1b9ca21b26542663aa3a3bdd959ca2ef5eb 16 September 2003, to France to speak at KPMG EMA Partners Conference. Travel, accommodation and fee paid by organisers. (Registered 24 November 2003) Remunerated employment, office, profession etc 1f359ece 2004-05-21 Peter Mandelson uk.org.publicwhip/member/1092 Peter Mandelson uk.org.publicwhip/person/10412 4 2004-05-21-1f359ece-10412-0
6b9b144a0f61c1d156e75672856dac41d63b56bc 20 April 2004, fee for speaking in Guernsey at a public event organised by the Institute of Financial Services and Lloyds TSB. (Registered 11 May 2004) Remunerated employment, office, profession etc 1f359ece 2004-05-21 Peter Mandelson uk.org.publicwhip/member/1092 Peter Mandelson uk.org.publicwhip/person/10412 5 2004-05-21-1f359ece-10412-0

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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");