home / regmem

Menu
  • GraphQL API

items

Table actions
  • GraphQL API for items

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

6 rows where record_id = "2023-10-16-5f2cbd10-25661-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
0db821d49cc6c59b2191dfb902d537368d1600af Member (unpaid) of the Ditchley Foundation's Programme Committee. (Registered 06 July 2017) Miscellaneous 5f2cbd10 2023-10-16   Bim Afolami uk.org.publicwhip/person/25661 0 2023-10-16-5f2cbd10-25661-0
b8dfba2c601b045da0d2ce5ef824efdbf349cdfb From June 2017, Member (unpaid) of the Court of the University of Bedfordshire. (Registered 30 January 2018) Miscellaneous 5f2cbd10 2023-10-16   Bim Afolami uk.org.publicwhip/person/25661 1 2023-10-16-5f2cbd10-25661-0
35c5b037f279865309c6ca798a90dc7a922478f6 From 13 September 2018, Member (unpaid) of the Financial Inclusion Commission, a cross-party organisation which supports the principle of increased financial inclusion in the UK. (Registered 21 September 2018) Miscellaneous 5f2cbd10 2023-10-16   Bim Afolami uk.org.publicwhip/person/25661 2 2023-10-16-5f2cbd10-25661-0
86bb8a9ee443f6c0b688a09631f64cbf190695f7 From 22 October 2018, Trustee (unpaid) of the Mitsubishi UFJ Trust Oxford Foundation, which supports the Oxford Union Literary and Debating Trust and through it the charitable activities of the Oxford Union Society. (Registered 05 November 2018) Miscellaneous 5f2cbd10 2023-10-16   Bim Afolami uk.org.publicwhip/person/25661 3 2023-10-16-5f2cbd10-25661-0
ffa8911f3918b49846923a944a98414bdf1e5c05 From 20 June 2022, Member of the Advisory Board of the Nick Maughan Foundation, which works to further a range of philanthropic initiatives in education, the environment and civic support schemes for disenfranchised communities. This is an unpaid role. (Registered 20 June 2022) Miscellaneous 5f2cbd10 2023-10-16   Bim Afolami uk.org.publicwhip/person/25661 4 2023-10-16-5f2cbd10-25661-0
52d2534c9801b59695760222a1536910137c81dc From 20 June 2022, Member of the Advisory Board of the Energy and Climate Intelligence Unit, a non-profit organisation that supports informed debate on energy and climate change issues in the UK. This is an unpaid role. (Registered 20 June 2022) Miscellaneous 5f2cbd10 2023-10-16   Bim Afolami uk.org.publicwhip/person/25661 5 2023-10-16-5f2cbd10-25661-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 13.116ms · Data source: mySociety Data · About: simonw/register-of-members-interests-datasette