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-24786-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
420cc20e82359f8e2593b814d95d92c98897c22a From 20 October 2020 until 9 September 2022, Chair of the Advisory Board of Conservatives Against Racism For Equality (CARFE), an organisation building a new narrative on race relations, working with Conservative MPs and individuals across the Conservative Party and wider society. (Registered 18 December 2020; updated 26 June 2023) Miscellaneous 5f2cbd10 2023-09-18   Steven Baker uk.org.publicwhip/person/24786 0 2023-09-18-5f2cbd10-24786-0
4cb724a70f174c639a71dab7753428a621689d4c From 15 December 2020 until 9 September 2022, Member of the Air League Council. The Air League aims to change lives through aviation, promoting an interest in aviation by inspiring young people, awarding scholarships and work opportunities. I returned to the Air League Council after a lapse of several years. (Registered 18 December 2020; updated 26 June 2023) Miscellaneous 5f2cbd10 2023-09-18   Steven Baker uk.org.publicwhip/person/24786 1 2023-09-18-5f2cbd10-24786-0
0916bb9e493cb548b78ceb3774ee003793b7f7d9 From 5 November 2020 until 8 September 2022, Deputy Chairman of the Covid Recovery Group, a group of Conservative MPs and peers which co-ordinates parliamentary work to facilitate the country’s recovery from Covid 19. This was an unpaid role. (Registered 26 January 2021; updated 26 June 2023) Miscellaneous 5f2cbd10 2023-09-18   Steven Baker uk.org.publicwhip/person/24786 2 2023-09-18-5f2cbd10-24786-0
15bd182aa8ac24ed8f8c079e45be84d179036cd4 From 17 May 2021 until 9 September 2022, Member of the Global Warming Policy Foundation's Board of Trustees. This was an unpaid role. (Registered 21 May 2021; updated 26 June 2023) Miscellaneous 5f2cbd10 2023-09-18   Steven Baker uk.org.publicwhip/person/24786 3 2023-09-18-5f2cbd10-24786-0
625e9ac57ea26d1b1a7c24b625db9e2983b086cc From 29 April 2022 until 9 September 2022, a director and Chairman of Conservative Way Forward Ltd. This was an unpaid role. (Registered 23 May 2022; updated 26 June 2023) Miscellaneous 5f2cbd10 2023-09-18   Steven Baker uk.org.publicwhip/person/24786 4 2023-09-18-5f2cbd10-24786-0
de2558789b6db89513082f04970095ed133fd037 18 January 2023, my local association accepted a donation of £1,500 from First Corporate which is below the registrable threshold. (Registered 02 March 2023) Miscellaneous 5f2cbd10 2023-09-18   Steven Baker uk.org.publicwhip/person/24786 5 2023-09-18-5f2cbd10-24786-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 15.694ms · Data source: mySociety Data · About: simonw/register-of-members-interests-datasette