home / regmem

Menu
  • GraphQL API

items

Table actions
  • GraphQL API for items

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

5 rows where record_id = "2021-11-01-5f2cbd10-25797-0" sorted by sort_order

✎ 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
96e7a8d7dc0da73daed7188e89e2ad4e4e3c72ee 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 2021-11-01   Claudia Webbe uk.org.publicwhip/person/25797 0 2021-11-01-5f2cbd10-25797-0
c20204ea047e9d6ff8a40f389a56c17d5dc74a9d 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 2021-11-01   Claudia Webbe uk.org.publicwhip/person/25797 1 2021-11-01-5f2cbd10-25797-0
8ac8f0235ebf81bf7ddcdf8efc705ca884207f22 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 2021-11-01   Claudia Webbe uk.org.publicwhip/person/25797 2 2021-11-01-5f2cbd10-25797-0
376ca3db71b4c8efb5e819afe3e580c3d2289170 Trustee of Marx Memorial Library and Workers' School. (Registered 11 January 2020) Miscellaneous 5f2cbd10 2021-11-01   Claudia Webbe uk.org.publicwhip/person/25797 3 2021-11-01-5f2cbd10-25797-0
2f2bc1aded034447c039216cc5eea731677391c7 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 2021-11-01   Claudia Webbe uk.org.publicwhip/person/25797 4 2021-11-01-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");
Powered by Datasette · Queries took 36.441ms · Data source: mySociety Data · About: simonw/register-of-members-interests-datasette