home / regmem

Menu
  • GraphQL API

items

Table actions
  • GraphQL API for items

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

7 rows where record_id = "2019-09-02-5f2cbd10-10726-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
cba18c0c8780dd9b07c78ff8cb4f53c1438ad396 Non-practising barrister-at-law. Miscellaneous 5f2cbd10 2019-09-02   Henry Bellingham uk.org.publicwhip/person/10726 0 2019-09-02-5f2cbd10-10726-0
ca9d9035cf0c94f3f1577ea0ca76d28035cb280f Non-Executive Chairman of Pontus Marine Limited, a UK based company with commercial fishing interests in the Gulf of Aden and the Middle East. I carry out duties as Non-Executive Chairman and give advice on strategy and corporate governance. Since November 2015, I receive no remuneration for this role. (Registered 12 June 2013; updated 17 July 2015 and 27 November 2015) Miscellaneous 5f2cbd10 2019-09-02   Henry Bellingham uk.org.publicwhip/person/10726 1 2019-09-02-5f2cbd10-10726-0
86240baecb889000b5d859dc7de2a8471a3bab7b Unremunerated director of Global Law Summit Ltd, which was set up to run the 2015 Global Law Summit commemorating 800th anniversary of the Magna Carta and to promote UK legal services around the world. It is also looking at organising another law Summit in the future. (Registered 31 October 2013; updated 07 June 2016) Miscellaneous 5f2cbd10 2019-09-02   Henry Bellingham uk.org.publicwhip/person/10726 2 2019-09-02-5f2cbd10-10726-0
d2b84a92eefdc18ffbe91929f20af097f429ee26 From 1 October 2018, non-executive director (unpaid) of Clifton Resources, a sister company to Clifton Africa. (Registered 29 November 2018) Miscellaneous 5f2cbd10 2019-09-02   Henry Bellingham uk.org.publicwhip/person/10726 3 2019-09-02-5f2cbd10-10726-0
8e82dabbbec6b7240ae21be387b2fbd7d6839dcf From 1 October 2018, director (unpaid) of Glencara Estate company, a private company involved with managing property and agricultural assets. (Registered 29 November 2018) Miscellaneous 5f2cbd10 2019-09-02   Henry Bellingham uk.org.publicwhip/person/10726 4 2019-09-02-5f2cbd10-10726-0
d14cab27a479b83a9b510973ad8528da18f6708e From 5 April 2019, Senior Adviser (unpaid) to J. Stern & Co. LLP, 4 Carlton Gardens, London SW1Y 5AA, a fund management company. I provide legal advice, and advice on corporate governance and strategic direction. (Registered 15 May 2019) Miscellaneous 5f2cbd10 2019-09-02   Henry Bellingham uk.org.publicwhip/person/10726 5 2019-09-02-5f2cbd10-10726-0
60270610ae1674cdaba6a6ca4d31c11601519424 From 12 April 2019, unpaid director of Fresh Voice and Vision Limited, which was set up to provide support to the leadership campaign of the Rt. Hon Dominic Raab MP. The campaign was launched on 10 June 2019. (Registered 12 June 2019) Miscellaneous 5f2cbd10 2019-09-02   Henry Bellingham uk.org.publicwhip/person/10726 6 2019-09-02-5f2cbd10-10726-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");
Powered by Datasette · Queries took 18.419ms · Data source: mySociety Data · About: simonw/register-of-members-interests-datasette