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

19 rows where record_id = "2021-01-18-10057ffd-25386-0" sorted by sort_order

View and edit SQL

Suggested facets: date (date)

hash item category_id date member_id person_id sort_order ▼ record_id
b27433a0897502b2c1d165143317ee40008e151c Payments from Savanta ComRes, 4 Millbank, Westminster, London SW1P 3JA, for completing parliamentary panel surveys: Employment and earnings 10057ffd 2021-01-18   Daniel Zeichner uk.org.publicwhip/person/25386 0 2021-01-18-10057ffd-25386-0
c9559f8756ec444d2d55ad7681f49be4340594df 9 December 2019, payment of £75 for a survey. Hours: 30 mins. (Registered 02 January 2020) Employment and earnings 10057ffd 2021-01-18   Daniel Zeichner uk.org.publicwhip/person/25386 1 2021-01-18-10057ffd-25386-0
0289f7532122c8131d4945b257fba3f20118535a 27 March 2020, received £75 for February 2020 Parliamentary Panel Survey. Hours: 30 mins. (Registered 03 December 2020) Employment and earnings 10057ffd 2021-01-18   Daniel Zeichner uk.org.publicwhip/person/25386 2 2021-01-18-10057ffd-25386-0
ae6136ea783a329e19792f7956be20707b2c813f 15 June 2020, received £75 for April 2020 Parliamentary Panel Survey. Hours: 30 mins. (Registered 03 December 2020) Employment and earnings 10057ffd 2021-01-18   Daniel Zeichner uk.org.publicwhip/person/25386 3 2021-01-18-10057ffd-25386-0
aa85c766571a745d6dd0b2aeb0aa8af6d5f1941c 17 August 2020, received £75 for July 2020 Parliamentary Panel Survey. Hours: 30 mins. (Registered 03 December 2020) Employment and earnings 10057ffd 2021-01-18   Daniel Zeichner uk.org.publicwhip/person/25386 4 2021-01-18-10057ffd-25386-0
48e707d436690638b6bef345ee7dba35576996c1 29 September 2020, received £75 for August 2020 Parliamentary Panel Survey. Hours: 30 mins. (Registered 03 December 2020) Employment and earnings 10057ffd 2021-01-18   Daniel Zeichner uk.org.publicwhip/person/25386 5 2021-01-18-10057ffd-25386-0
d133695d6b4b32bddae725d5aed2f700fd842e3d 08 November 2020, received £75 for September 2020 Parliamentary Panel Survey. Hours: 30 mins. (Registered 03 December 2020) Employment and earnings 10057ffd 2021-01-18   Daniel Zeichner uk.org.publicwhip/person/25386 6 2021-01-18-10057ffd-25386-0
b2a0781729fdd75577b575cd67c586b31c424dbc 22 December 2020, received £75 for October 2020 Parliamentary Panel Survey. Hours: 30 mins. (Registered 07 January 2021) Employment and earnings 10057ffd 2021-01-18   Daniel Zeichner uk.org.publicwhip/person/25386 7 2021-01-18-10057ffd-25386-0
2ba05ad1972d1b2beedabc42013ae52e40e15d8f Payments from Ipsos MORI, 3 Thomas More Square, London, E1W 1YW, for completing opinion surveys: Employment and earnings 10057ffd 2021-01-18   Daniel Zeichner uk.org.publicwhip/person/25386 8 2021-01-18-10057ffd-25386-0
ab42a30f4742bff25c141abb01e2d697c7aa4ac7 16 March 2020, received £200. Hours: 1 hr. (Registered 14 April 2020) Employment and earnings 10057ffd 2021-01-18   Daniel Zeichner uk.org.publicwhip/person/25386 9 2021-01-18-10057ffd-25386-0
cdcdf472e45f63f003fa90a0597ad05330e18703 Payments from YouGov, 50 Featherstone Street, London EC1Y 8RT, for completing surveys: Employment and earnings 10057ffd 2021-01-18   Daniel Zeichner uk.org.publicwhip/person/25386 10 2021-01-18-10057ffd-25386-0
45c658b5251c67058310d3bf3861c9247c9144f3 15 January 2019, received £70 for December online survey. Hours: 30 mins. (Registered 03 January 2020) Employment and earnings 10057ffd 2021-01-18   Daniel Zeichner uk.org.publicwhip/person/25386 11 2021-01-18-10057ffd-25386-0
cbeed76854f82d34bc22c0e7f4a5c4c7e08ba33b 6 February 2019, received £30 for January online survey. Hours: 15 mins. (Registered 03 January 2020) Employment and earnings 10057ffd 2021-01-18   Daniel Zeichner uk.org.publicwhip/person/25386 12 2021-01-18-10057ffd-25386-0
38c11596a51d8768e04057b67a088988c2a0283c 27 March 2019, received £50 for March online survey. Hours: 15 mins. (Registered 03 January 2020) Employment and earnings 10057ffd 2021-01-18   Daniel Zeichner uk.org.publicwhip/person/25386 13 2021-01-18-10057ffd-25386-0
733de92e300d53373107c348573a184f1db5be71 19 June 2019, received £80 for May online survey. Hours: 30 mins. (Registered 03 January 2020) Employment and earnings 10057ffd 2021-01-18   Daniel Zeichner uk.org.publicwhip/person/25386 14 2021-01-18-10057ffd-25386-0
9a58de0c422df891b44dac1bf3c1b9390405dcc6 16 August 2019, received £40 for July online survey. Hours: 15 mins. (Registered 03 January 2020) Employment and earnings 10057ffd 2021-01-18   Daniel Zeichner uk.org.publicwhip/person/25386 15 2021-01-18-10057ffd-25386-0
cf18498100c781a3633e552e47ef0930aab06abd 9 December 2019, received £60 for October online survey. Hours: 30 mins. (Registered 03 January 2020) Employment and earnings 10057ffd 2021-01-18   Daniel Zeichner uk.org.publicwhip/person/25386 16 2021-01-18-10057ffd-25386-0
5310f8ee3f9150316384d5afcd81c7df57e62151 9 December 2019, received £100 for October online survey. Hours: 30 mins. (Registered 03 January 2020) Employment and earnings 10057ffd 2021-01-18   Daniel Zeichner uk.org.publicwhip/person/25386 17 2021-01-18-10057ffd-25386-0
dc879a5ad7e8480d31caa91e33e74d0955ecccd6 12 February 2020, received £110 for January online survey. Hours: 1 hr. (Registered 11 March 2020) Employment and earnings 10057ffd 2021-01-18   Daniel Zeichner uk.org.publicwhip/person/25386 18 2021-01-18-10057ffd-25386-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");