home / regmem

Menu
  • GraphQL API

items

Table actions
  • GraphQL API for items

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

13 rows where record_id = "2023-07-10-10057ffd-10715-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
0628bfc5b8cbacd85bcdde3d2b9fa1f28ff12126 From 1 July 2018 until further notice, £800 (previously £600) a month for a monthly investment column in the FT’s Investors' Chronicle magazine. Address: Number One Southwark Bridge, London SE1 9HL. All fees are waived in lieu of FT donations to charities of my choice. Hours: 1 hr a month (1 column). (Updated 22 June 2015, 11 August 2016 and 02 July 2018) Employment and earnings 10057ffd 2023-07-10   John Baron uk.org.publicwhip/person/10715 0 2023-07-10-10057ffd-10715-0
fdb175249e004d7a15d34cca83d2c2ef6ef14440 From 1 January 2021, Chair of the Investment Committee of Baron and Grant Investment Management Limited, 66 Lincoln’s Inn Fields, London WC2A 3LH; a fund management company. Between 3 July 2020 and 1 January 2021, I was a person with significant control. (Registered 08 November 2020; updated 07 June 2021) Employment and earnings 10057ffd 2023-07-10   John Baron uk.org.publicwhip/person/10715 1 2023-07-10-10057ffd-10715-0
3a6e7974a26a4857e0f8ca7a6244536ff7671077 From 30 April 2021 until further notice, I receive £500 a month. Hours: 5 hrs month. First payment received on 17 May 2021. (Registered 07 June 2021) Employment and earnings 10057ffd 2023-07-10   John Baron uk.org.publicwhip/person/10715 2 2023-07-10-10057ffd-10715-0
e7f79e00dd824f9774e7a77d4f830be95721bfdd Royalty payments received from Pearson Education, Harlow CM17 9NA, for writing two editions of a book. The first edition was published in 2013, the second in 2021. Employment and earnings 10057ffd 2023-07-10   John Baron uk.org.publicwhip/person/10715 3 2023-07-10-10057ffd-10715-0
dd92809e0eea88352c5541728f68453a9499bc14 30 September 2016, received £258.91. Hours: no additional hours. (Registered 16 December 2022) Employment and earnings 10057ffd 2023-07-10   John Baron uk.org.publicwhip/person/10715 4 2023-07-10-10057ffd-10715-0
3140eaeab88e4bd04918c22fa27df53749104bb1 31 March 2017, received £386.59. Hours: no additional hours. (Registered 16 December 2022) Employment and earnings 10057ffd 2023-07-10   John Baron uk.org.publicwhip/person/10715 5 2023-07-10-10057ffd-10715-0
d438ddd6d6bca1a8e3dba5ec58fed1eb2c0966af 29 September 2017, received £227.04. Hours: no additional hours. (Registered 16 December 2022) Employment and earnings 10057ffd 2023-07-10   John Baron uk.org.publicwhip/person/10715 6 2023-07-10-10057ffd-10715-0
c998229413ca1445ef778d375cc25bfe3b82e02d 29 March 2019, received £77.17. Hours: no additional hours. (Registered 16 December 2022) Employment and earnings 10057ffd 2023-07-10   John Baron uk.org.publicwhip/person/10715 7 2023-07-10-10057ffd-10715-0
7fc760f4056240ef842042474ecce0f4cb141a85 30 September 2019, received £34.56. Hours: no additional hours. (Registered 16 December 2022) Employment and earnings 10057ffd 2023-07-10   John Baron uk.org.publicwhip/person/10715 8 2023-07-10-10057ffd-10715-0
8554f6a8ea72682a36ac193bc1e71ae8ecf591fb 30 March 2021, received £147.03. Hours: no additional hours. (Registered 16 December 2022) Employment and earnings 10057ffd 2023-07-10   John Baron uk.org.publicwhip/person/10715 9 2023-07-10-10057ffd-10715-0
0b8241e7aed8376178a11f576f48640b4cfce31e 30 September 2021, received £663.68. Hours: no additional hours. (Registered 16 December 2022) Employment and earnings 10057ffd 2023-07-10   John Baron uk.org.publicwhip/person/10715 10 2023-07-10-10057ffd-10715-0
6d76dbdf7935355d2d9b2c43221fa94a8762cb81 31 March 2022, received £472.62. Hours: no additional hours. (Registered 16 December 2022) Employment and earnings 10057ffd 2023-07-10   John Baron uk.org.publicwhip/person/10715 11 2023-07-10-10057ffd-10715-0
00c12957790120047a310951df25b6348cd86f4c 30 September 2022, received £299. Hours: no additional hours. (Registered 16 December 2022) Employment and earnings 10057ffd 2023-07-10   John Baron uk.org.publicwhip/person/10715 12 2023-07-10-10057ffd-10715-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.227ms · Data source: mySociety Data · About: simonw/register-of-members-interests-datasette