items

Table actions

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

4 rows where record_id = "2018-06-04-10057ffd-10884-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
c4fb892cef959703e6c895e41c7ce1b7f2f7a8f7 Until 13 June 2017, member of Advisory Committee of the London School of Commerce, Chaucer House, White Hart Yard, London SE1 1NX; an independent further and higher education organisation. I receive £30,000 a year in monthly instalments of £2,500, in return for an expected annual commitment of 100 hours. As a member of the Advisory Committee I advise on the maintenance of the highest standards of quality and service for the school. My role covers advising about mid and long-term strategy; acting as an ambassador with the school’s educational partners; speaking at conferences as representative of the school on a range of political issues; furthering relationships with British Council and High Commissions overseas; travelling abroad roughly once every eighteen months to partner schools abroad. (Registered 31 May 2010; updated 22 June 2015 and 4 July 2017) Employment and earnings 10057ffd 2018-06-04   Mark Field uk.org.publicwhip/person/10884 0 2018-06-04-10057ffd-10884-0
f0e05dae3d7ef23845097523a9931f625226920f 13 June 2017, received £30,000 from The London School of Commerce, as part of a redundancy package. Hours: no additional hours. (Registered 04 July 2017) Employment and earnings 10057ffd 2018-06-04   Mark Field uk.org.publicwhip/person/10884 1 2018-06-04-10057ffd-10884-0
5678b8cdfed3afdab1b9145a7e71c2e200559a92 Until 13 June 2017, adviser to Cains Advocates Limited; international law firm. I receive £40,000 a year in quarterly payments of £10,000, in return for an expected annual commitment of 120 hrs. The role includes assisting the firm with its international strategy, ambassadorial work and advising on government and parliamentary aspects of financial services. Address: One Love Lane, London EC2V 7JN. (Registered 7 July 2014; updated 7 July 2015 and 4 July 2017) Employment and earnings 10057ffd 2018-06-04   Mark Field uk.org.publicwhip/person/10884 2 2018-06-04-10057ffd-10884-0
630b2f263f3e191b542a951c2676e4d3ed9d1a9e 6 July 2017, received £40,000 from Cains Advocates Limited, as part of a severance package. Hours: no additional hours. (Registered 04 July 2017) Employment and earnings 10057ffd 2018-06-04   Mark Field uk.org.publicwhip/person/10884 3 2018-06-04-10057ffd-10884-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");