items

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

13 rows where record_id = "2020-10-12-10057ffd-25360-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
3da638a87ea12ebbe1c236c68074fadd2d2da5a9 Payments from ComRes, 4 Millbank, London SW1P 3JA, for completing opinion surveys: Employment and earnings 10057ffd 2020-10-12   William Wragg uk.org.publicwhip/person/25360 0 2020-10-12-10057ffd-25360-0
aa56da3fbaee1e7ae161df3fb790b3cdd90a872c 29 March 2019, received £75. Hours: 30 mins. (Registered 17 December 2019) Employment and earnings 10057ffd 2020-10-12   William Wragg uk.org.publicwhip/person/25360 1 2020-10-12-10057ffd-25360-0
325492c26e0b50e88c1d21b1f80fccdf84d435c4 29 July 2019, received £75. Hours: 30 mins. (Registered 17 December 2019) Employment and earnings 10057ffd 2020-10-12   William Wragg uk.org.publicwhip/person/25360 2 2020-10-12-10057ffd-25360-0
e3921833ae2dbf410e57a4ce2223d83df132b91c 24 October 2019, received £75. Hours: 30 mins. (Registered 17 December 2019) Employment and earnings 10057ffd 2020-10-12   William Wragg uk.org.publicwhip/person/25360 3 2020-10-12-10057ffd-25360-0
f02793b7368839bfe12f138e83b9a020528fe31f 25 October 2019, received £75. Hours: 30 mins. (Registered 17 December 2019) Employment and earnings 10057ffd 2020-10-12   William Wragg uk.org.publicwhip/person/25360 4 2020-10-12-10057ffd-25360-0
19599ffbcc931279f4a2977ced65bfd83ece2ae2 15 November 2019, received £75. Hours: 30 mins. (Registered 17 December 2019) Employment and earnings 10057ffd 2020-10-12   William Wragg uk.org.publicwhip/person/25360 5 2020-10-12-10057ffd-25360-0
b8087f8a7a558bb0c102e2f16fa3ac67bf74a1f4 Payments from Ipsos MORI, 3 Thomas More Square, London E1W 1YW, for completing surveys: Employment and earnings 10057ffd 2020-10-12   William Wragg uk.org.publicwhip/person/25360 6 2020-10-12-10057ffd-25360-0
b9c789f5d719bd54db1db55264357012c4f7d97c 17 February 2020, received £200. Hours: 1 hr. (Registered 24 February 2020) Employment and earnings 10057ffd 2020-10-12   William Wragg uk.org.publicwhip/person/25360 7 2020-10-12-10057ffd-25360-0
0848eb6eca42235ce24f0eb376dc8e3b1de242d3 5 August 2020, received £250. Hours: 2 hrs. (Registered 17 August 2020) Employment and earnings 10057ffd 2020-10-12   William Wragg uk.org.publicwhip/person/25360 8 2020-10-12-10057ffd-25360-0
97947e8b15ce6a6ebd0ac5eded91ce4db2918354 Payments from YouGov, 50 Featherstone Street, London EC1Y 8RT, for completing opinion surveys: Employment and earnings 10057ffd 2020-10-12   William Wragg uk.org.publicwhip/person/25360 9 2020-10-12-10057ffd-25360-0
0afc72ed3d54b1d326e7be3f64ceb2ed4b678bb0 23 October 2019, received £60. Hours: 30 mins. (Registered 28 October 2019) Employment and earnings 10057ffd 2020-10-12   William Wragg uk.org.publicwhip/person/25360 10 2020-10-12-10057ffd-25360-0
6d7c0a6a288aaf7216b76998d5f16ac215dcd95d 9 December 2019, received £60. Hours: 30 mins. (Registered 07 January 2020) Employment and earnings 10057ffd 2020-10-12   William Wragg uk.org.publicwhip/person/25360 11 2020-10-12-10057ffd-25360-0
70ca0dbbba4980f6d96fe1b3ba0a71abffd8f284 09 December 2019, received £100. Hours: 1 hr. (Registered 07 January 2020) Employment and earnings 10057ffd 2020-10-12   William Wragg uk.org.publicwhip/person/25360 12 2020-10-12-10057ffd-25360-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 · Query took 20.217ms · Data source: mySociety Data · About: simonw/register-of-members-interests