home / regmem

Menu
  • GraphQL API

items

Table actions
  • GraphQL API for items

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

22 rows where record_id = "2023-09-18-10057ffd-10505-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
6f60df472124e4d85c81bc05ef9a3bcc4bc727c1 Payments from Savanta ComRes, 54 Bermondsey St, Bermondsey, London SE1 3UD, for completing surveys: Employment and earnings 10057ffd 2023-09-18   Laurence Robertson uk.org.publicwhip/person/10505 0 2023-09-18-10057ffd-10505-0
a8e29b27398ec7ce5699ed8f856566215973fbde 22 August 2022, received £75. Hours: 30 mins. (Registered 06 September 2022) Employment and earnings 10057ffd 2023-09-18   Laurence Robertson uk.org.publicwhip/person/10505 1 2023-09-18-10057ffd-10505-0
032176887d321ed3f248ffc78cf5fe474a8375d2 30 September 2022, received £75. Hours: 20 mins. (Registered 25 October 2022) Employment and earnings 10057ffd 2023-09-18   Laurence Robertson uk.org.publicwhip/person/10505 2 2023-09-18-10057ffd-10505-0
3a6297502c2308e0271f4ac7f701613dbf3d9f5c Payments from YouGov, 50 Featherstone Street, London EC1Y 8RT, for completing surveys: Employment and earnings 10057ffd 2023-09-18   Laurence Robertson uk.org.publicwhip/person/10505 3 2023-09-18-10057ffd-10505-0
c7bd57ac4f5d7314eae5a9092e78325f08a1c633 24 August 2022, received £100. Hours: 30 mins. (Registered 06 September 2022) Employment and earnings 10057ffd 2023-09-18   Laurence Robertson uk.org.publicwhip/person/10505 4 2023-09-18-10057ffd-10505-0
3031922424c0f5c6213dcb796be629dd46efee42 24 August 2022, received £70. Hours: 20 mins. (Registered 06 September 2022) Employment and earnings 10057ffd 2023-09-18   Laurence Robertson uk.org.publicwhip/person/10505 5 2023-09-18-10057ffd-10505-0
068c2c41d9f7b43266a4ccd08b08e64d417ab8ff 30 August 2022, received £90. Hours: 30 mins. (Registered 06 September 2022) Employment and earnings 10057ffd 2023-09-18   Laurence Robertson uk.org.publicwhip/person/10505 6 2023-09-18-10057ffd-10505-0
489eaf6968a88648109e54258f06c3dfe3e81f8a 30 August 2022, received £100. Hours: 30 mins. (Registered 06 September 2022) Employment and earnings 10057ffd 2023-09-18   Laurence Robertson uk.org.publicwhip/person/10505 7 2023-09-18-10057ffd-10505-0
b221ece6a303cfa05c9637cc305a277cf75520e1 13 October 2022, received £80. Hours: 20 mins. (Registered 25 October 2022) Employment and earnings 10057ffd 2023-09-18   Laurence Robertson uk.org.publicwhip/person/10505 8 2023-09-18-10057ffd-10505-0
2904a830f6f44ef605c57cc7197b0027c035ddf9 25 November 2022, received £100. Hours: 30 mins. (Registered 06 December 2022) Employment and earnings 10057ffd 2023-09-18   Laurence Robertson uk.org.publicwhip/person/10505 9 2023-09-18-10057ffd-10505-0
3d06278817684ef11988e17594f1635c12712f92 25 November 2022, received another £100. Hours: 30 mins. (Registered 06 December 2022) Employment and earnings 10057ffd 2023-09-18   Laurence Robertson uk.org.publicwhip/person/10505 10 2023-09-18-10057ffd-10505-0
a4d91d4829931efa0b74618327f5bf9dc4e4a4af 13 February 2023, received £110. Hours: 30 mins. (Registered 07 March 2023) Employment and earnings 10057ffd 2023-09-18   Laurence Robertson uk.org.publicwhip/person/10505 11 2023-09-18-10057ffd-10505-0
3133e7ae777fd46b5049b37a03da894f955f4d69 From 1 October 2020 until 30 June 2023, Adviser on Safer Gambling and Sport to the Betting and Gaming Council, 1 Bedford Row, London WC1R 4BU. I received £2,000 per month. Hours: 10 hrs per month. (Registered 26 October 2020; updated 06 October 2021, 25 October 2022, 04 April 2023 and 14 June 2023) Employment and earnings 10057ffd 2023-09-18   Laurence Robertson uk.org.publicwhip/person/10505 12 2023-09-18-10057ffd-10505-0
6349d619df1dc4cd573e2edf7a83a91ad6a4a3df Payments from Yonder, Northburgh House, 10 Northburgh Street, London EC1V 0AT, for completing surveys: Employment and earnings 10057ffd 2023-09-18   Laurence Robertson uk.org.publicwhip/person/10505 13 2023-09-18-10057ffd-10505-0
1d835681eddd66770a48cc2502f187650156da41 28 January 2022, received £65. Hours: 20 mins. (Registered 08 September 2022) Employment and earnings 10057ffd 2023-09-18   Laurence Robertson uk.org.publicwhip/person/10505 14 2023-09-18-10057ffd-10505-0
fbf9d5ca211cc1f64e24bc51552d8ac733a2c6e1 4 April, received £75. Hours: 30 mins. (Registered 08 September 2022) Employment and earnings 10057ffd 2023-09-18   Laurence Robertson uk.org.publicwhip/person/10505 15 2023-09-18-10057ffd-10505-0
87fb0be8e27e1fe9eed8b4f07543cbc035e2913d 25 July 2022, received £75. Hours: 30 mins. (Registered 08 September 2022) Employment and earnings 10057ffd 2023-09-18   Laurence Robertson uk.org.publicwhip/person/10505 16 2023-09-18-10057ffd-10505-0
732dfb91fab809941908a1b97ca65f2d906e971b 4 August 2022, received £75. Hours: 30 mins. (Registered 08 September 2022) Employment and earnings 10057ffd 2023-09-18   Laurence Robertson uk.org.publicwhip/person/10505 17 2023-09-18-10057ffd-10505-0
51fa1363a963f51e55772da8fee37e83fd849d95 24 August 2022, received £75. Hours: 30 mins. (Registered 08 September 2022) Employment and earnings 10057ffd 2023-09-18   Laurence Robertson uk.org.publicwhip/person/10505 18 2023-09-18-10057ffd-10505-0
ef7227c3ae7f365afbeb59d7560b4fff367f11ff 2 December 2022, received £75. Hours: 25 mins. (Registered 06 December 2022) Employment and earnings 10057ffd 2023-09-18   Laurence Robertson uk.org.publicwhip/person/10505 19 2023-09-18-10057ffd-10505-0
d07624c4d9301203403d4cf52c02674064f5b414 Payment from Ipsos MORI UK Ltd, 79-81 Borough Road, London SE1 1FY, for completing surveys: Employment and earnings 10057ffd 2023-09-18   Laurence Robertson uk.org.publicwhip/person/10505 20 2023-09-18-10057ffd-10505-0
faaea81b9508ef1426735949177f5aebe60306fc 15 August 2022, received £225. Hours: 40 mins. (Registered 06 September 2022) Employment and earnings 10057ffd 2023-09-18   Laurence Robertson uk.org.publicwhip/person/10505 21 2023-09-18-10057ffd-10505-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 18.261ms · Data source: mySociety Data · About: simonw/register-of-members-interests-datasette