items

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

13 rows where record_id = "2020-09-01-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
9d0a712a60ba94a803c4bda2c3b45970b2f6ebd9 Payments from ComRes, 4 Millbank, London SW1P 3JA, for completing opinion surveys: Employment and earnings 10057ffd 2020-09-01   William Wragg uk.org.publicwhip/person/25360 0 2020-09-01-10057ffd-25360-0
888d5e9b9b578a47726a7eaeb40890ff27ed95d3 29 March 2019, received £75. Hours: 30 mins. (Registered 17 December 2019) Employment and earnings 10057ffd 2020-09-01   William Wragg uk.org.publicwhip/person/25360 1 2020-09-01-10057ffd-25360-0
6c44a831a71f1ed364eb04f25a8ca5db89f022b1 29 July 2019, received £75. Hours: 30 mins. (Registered 17 December 2019) Employment and earnings 10057ffd 2020-09-01   William Wragg uk.org.publicwhip/person/25360 2 2020-09-01-10057ffd-25360-0
496e13bc8ea261c5284a6b78096efd07c02dade6 24 October 2019, received £75. Hours: 30 mins. (Registered 17 December 2019) Employment and earnings 10057ffd 2020-09-01   William Wragg uk.org.publicwhip/person/25360 3 2020-09-01-10057ffd-25360-0
c603c729dcf8f3cc4cb08052ffbabbf5f4ab6c76 25 October 2019, received £75. Hours: 30 mins. (Registered 17 December 2019) Employment and earnings 10057ffd 2020-09-01   William Wragg uk.org.publicwhip/person/25360 4 2020-09-01-10057ffd-25360-0
6f97d922a1048303c4ee9ea027bcb7759f8a9a9b 15 November 2019, received £75. Hours: 30 mins. (Registered 17 December 2019) Employment and earnings 10057ffd 2020-09-01   William Wragg uk.org.publicwhip/person/25360 5 2020-09-01-10057ffd-25360-0
e3bb6c3a2df100bdf8267169fb278edfc3f4bcfd Payments from Ipsos MORI, 3 Thomas More Square, London E1W 1YW, for completing surveys: Employment and earnings 10057ffd 2020-09-01   William Wragg uk.org.publicwhip/person/25360 6 2020-09-01-10057ffd-25360-0
b434d99749e37f32572ecd3c5e6dcf474b7c9619 17 February 2020, received £200. Hours: 1 hr. (Registered 24 February 2020) Employment and earnings 10057ffd 2020-09-01   William Wragg uk.org.publicwhip/person/25360 7 2020-09-01-10057ffd-25360-0
060a9a52de03c61e814f7b9f167e4eb5a3a6c492 5 August 2020, received £250. Hours: 2 hrs. (Registered 17 August 2020) Employment and earnings 10057ffd 2020-09-01   William Wragg uk.org.publicwhip/person/25360 8 2020-09-01-10057ffd-25360-0
d1b43ec72ef3800d95c753ba0651cc31fc22d768 Payments from YouGov, 50 Featherstone Street, London EC1Y 8RT, for completing opinion surveys: Employment and earnings 10057ffd 2020-09-01   William Wragg uk.org.publicwhip/person/25360 9 2020-09-01-10057ffd-25360-0
95d0fe2b329056ed6696b96acf8e05ce166240d1 23 October 2019, received £60. Hours: 30 mins. (Registered 28 October 2019) Employment and earnings 10057ffd 2020-09-01   William Wragg uk.org.publicwhip/person/25360 10 2020-09-01-10057ffd-25360-0
57c41732691e170901d9374d1ce36e333c35b5be 9 December 2019, received £60. Hours: 30 mins. (Registered 07 January 2020) Employment and earnings 10057ffd 2020-09-01   William Wragg uk.org.publicwhip/person/25360 11 2020-09-01-10057ffd-25360-0
519dc6a6a02f62d39f3d83110b808fb17b7c50c0 09 December 2019, received £100. Hours: 1 hr. (Registered 07 January 2020) Employment and earnings 10057ffd 2020-09-01   William Wragg uk.org.publicwhip/person/25360 12 2020-09-01-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 16.228ms · Data source: mySociety Data · About: simonw/register-of-members-interests