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-09-18-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
0646be2186b1e34f6b02c200fb08c8d3a6ac4e99 Member (unpaid) of the Ditchley Foundation's Programme Committee. (Registered 06 July 2017) Miscellaneous 5f2cbd10 2023-09-18   Bim Afolami uk.org.publicwhip/person/25661 0 2023-09-18-5f2cbd10-25661-0
1842580da855c75eb87a444d65b83b758c85e1ef From June 2017, Member (unpaid) of the Court of the University of Bedfordshire. (Registered 30 January 2018) Miscellaneous 5f2cbd10 2023-09-18   Bim Afolami uk.org.publicwhip/person/25661 1 2023-09-18-5f2cbd10-25661-0
894e84550d15afc47bdb814a6310d70318783e10 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-09-18   Bim Afolami uk.org.publicwhip/person/25661 2 2023-09-18-5f2cbd10-25661-0
8fe8d5ad41eb395c355bd7e0cc486c2f5abac5c9 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-09-18   Bim Afolami uk.org.publicwhip/person/25661 3 2023-09-18-5f2cbd10-25661-0
638b1dbf2fd5cf0ebefddf7c638804c2818a9e07 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-09-18   Bim Afolami uk.org.publicwhip/person/25661 4 2023-09-18-5f2cbd10-25661-0
9d8f48d227cc0089e4cd0a2867fa3fd0a2a72ac5 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-09-18   Bim Afolami uk.org.publicwhip/person/25661 5 2023-09-18-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 22.024ms · Data source: mySociety Data · About: simonw/register-of-members-interests-datasette