items

Table actions

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

5 rows where record_id = "2022-01-31-5f2cbd10-25797-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
e554a00814ea21561549714d543f90bef94b7c63 Until 24 November 2020, unpaid director of Islington Ltd (iCO) (management and procurement services). (Registered 11 January 2020; updated 27 January 2021) This is a late register update to which the rectification procedure was applied on 4 February 2021. Paragraph 15 of Chapter 4 of the Guide to the Rules applies. Miscellaneous 5f2cbd10 2022-01-31   Claudia Webbe uk.org.publicwhip/person/25797 0 2022-01-31-5f2cbd10-25797-0
efe056a708f05debb792ee27fa2a515babf73781 Until 24 September 2020, unpaid director of St Luke's Trustee Ltd (community charity). (Registered 11 January 2020; updated 25 January 2021) This is a late register update to which the rectification procedure was applied on 4 February 2021. Paragraph 15 of Chapter 4 of the Guide to the Rules applies. Miscellaneous 5f2cbd10 2022-01-31   Claudia Webbe uk.org.publicwhip/person/25797 1 2022-01-31-5f2cbd10-25797-0
1620d803735464fd3b8c795337b1acc86d1e145c Until 24 September 2020, unpaid director of City YMCA Ltd. (Registered 11 January 2020; updated 25 January 2021) This is a late register update to which the rectification procedure was applied on 4 February 2021. Paragraph 15 of Chapter 4 of the Guide to the Rules applies. Miscellaneous 5f2cbd10 2022-01-31   Claudia Webbe uk.org.publicwhip/person/25797 2 2022-01-31-5f2cbd10-25797-0
da13992b40e9aea2c5d5c5b108b1c922e6dc9996 Trustee of Marx Memorial Library and Workers' School. (Registered 11 January 2020) Miscellaneous 5f2cbd10 2022-01-31   Claudia Webbe uk.org.publicwhip/person/25797 3 2022-01-31-5f2cbd10-25797-0
e980fe5b8349a5133bd1ab2352912a65eeb0557b Until 24 September 2020, I held the following appointments in my capacity as Islington Councillor:. Trustee of City YMCA Member of Crossrail High Level Forum Member of Groundwork, London's Local Authority Strategic Input Board Member of the General Assembly of the Local Government Association Member of the London Road Safety Council Member of North London Waste Authority Trustee of St Sepulchre United Charities (Registered 11 January 2020; updated 25 January 2021) These are late register updates to which the rectification procedure was applied on 4 February 2021. Paragraph 15 of Chapter 4 of the Guide to the Rules applies. Miscellaneous 5f2cbd10 2022-01-31   Claudia Webbe uk.org.publicwhip/person/25797 4 2022-01-31-5f2cbd10-25797-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");