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-16-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
26f7d5cec81f66cc865ca19ce48c7803df864d47 Non-practising barrister-at-law. Miscellaneous 5f2cbd10 2019-09-16   Henry Bellingham uk.org.publicwhip/person/10726 0 2019-09-16-5f2cbd10-10726-0
28cf5b85d985d20d5603d77b53cb946527006fb1 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-16   Henry Bellingham uk.org.publicwhip/person/10726 1 2019-09-16-5f2cbd10-10726-0
fd0777bdee19717ca2f65a80c402a55fca86e2b9 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-16   Henry Bellingham uk.org.publicwhip/person/10726 2 2019-09-16-5f2cbd10-10726-0
5eee66a9371947812d576c8d9634594abdf1f4aa 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-16   Henry Bellingham uk.org.publicwhip/person/10726 3 2019-09-16-5f2cbd10-10726-0
3c6fc0fdc3c4f44f1f965c48cff34dc5a58e19f5 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-16   Henry Bellingham uk.org.publicwhip/person/10726 4 2019-09-16-5f2cbd10-10726-0
8fd40f796a5dad3d1c262342091bf10ba02876da 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-16   Henry Bellingham uk.org.publicwhip/person/10726 5 2019-09-16-5f2cbd10-10726-0
93ed056399708997858ac7756257279239cfcaa9 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-16   Henry Bellingham uk.org.publicwhip/person/10726 6 2019-09-16-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 16.779ms · Data source: mySociety Data · About: simonw/register-of-members-interests-datasette