home / regmem

Menu
  • GraphQL API

items

Table actions
  • GraphQL API for items

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

14 rows where record_id = "2022-09-05-10057ffd-11374-0" sorted by record_id

✎ 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 ▼
31c381e0145b252b2856fdf74e7e81e31008ec87 Payments from Savanta ComRes, 3 Melville Street, Edinburgh EH3 7PE, for surveys. All fees paid direct to charity or good causes. Employment and earnings 10057ffd 2022-09-05   Sammy Wilson uk.org.publicwhip/person/11374 0 2022-09-05-10057ffd-11374-0
4732dfac88eca39316b216052272c45ee9cc07fc 16 January 2021, payment of £75. Hours: approx. 15 mins. (Registered 08 February 2022) Employment and earnings 10057ffd 2022-09-05   Sammy Wilson uk.org.publicwhip/person/11374 1 2022-09-05-10057ffd-11374-0
65147ae0867afac28d5fb967c8c5d9865725eeff 14 February 2021, payment of £75. Hours: approx. 15 mins. (Registered 08 February 2022) Employment and earnings 10057ffd 2022-09-05   Sammy Wilson uk.org.publicwhip/person/11374 2 2022-09-05-10057ffd-11374-0
1730559f69f53a3fc665122210320a9d15040882 10 March 2021, payment of £75. Hours: approx. 15 mins. (Registered 08 February 2022) Employment and earnings 10057ffd 2022-09-05   Sammy Wilson uk.org.publicwhip/person/11374 3 2022-09-05-10057ffd-11374-0
e666f62eb1027508cb3f0aa9fc0e0b54aeb87c8d 12 April 2021, payment of £75. Hours: approx. 15 mins. (Registered 08 February 2022) Employment and earnings 10057ffd 2022-09-05   Sammy Wilson uk.org.publicwhip/person/11374 4 2022-09-05-10057ffd-11374-0
d5946182f1192f2f9ef41694ca8f23ccab674461 26 May 2021, payment of £75. Hours: approx. 15 mins. (Registered 08 February 2022) Employment and earnings 10057ffd 2022-09-05   Sammy Wilson uk.org.publicwhip/person/11374 5 2022-09-05-10057ffd-11374-0
13401b47826daf29d8dd4e60779f0e4edde5c5a8 15 July 2021, payment of £100. Hours: approx. 15 mins. (Registered 08 February 2022) Employment and earnings 10057ffd 2022-09-05   Sammy Wilson uk.org.publicwhip/person/11374 6 2022-09-05-10057ffd-11374-0
7bbc0dfff26f05e52eee62a31b15784d57290c2f 10 September 2021, payment of £75. Hours: approx. 15 mins. (Registered 08 February 2022) Employment and earnings 10057ffd 2022-09-05   Sammy Wilson uk.org.publicwhip/person/11374 7 2022-09-05-10057ffd-11374-0
f1c41a7a704a36a5b4ae49286f8e685e1a08dc5a 11 November 2021, payment of £75. Hours: approx. 15 mins. (Registered 08 February 2022) Employment and earnings 10057ffd 2022-09-05   Sammy Wilson uk.org.publicwhip/person/11374 8 2022-09-05-10057ffd-11374-0
8ba7f2e2aade8264930b408f85c71658ded24e89 6 December 2021, payment of £75. Hours: approx. 15 mins. (Registered 08 February 2022) Employment and earnings 10057ffd 2022-09-05   Sammy Wilson uk.org.publicwhip/person/11374 9 2022-09-05-10057ffd-11374-0
c26da4d6e088518adfbae6f28a232e4a572beeb3 Payments from YouGov, 50 Featherstone Street, London EC1Y 8RT, for surveys. All fees paid direct to charity or good causes. Employment and earnings 10057ffd 2022-09-05   Sammy Wilson uk.org.publicwhip/person/11374 10 2022-09-05-10057ffd-11374-0
3d8c34442461dc8fc16702835ec2e19747cfe132 11 November 2021, payment of £120. Hours: approx. 15 mins. (Registered 08 February 2022) Employment and earnings 10057ffd 2022-09-05   Sammy Wilson uk.org.publicwhip/person/11374 11 2022-09-05-10057ffd-11374-0
8996fd561f7e0e5c43489451dce4abe66ce77ed4 24 November 2021, payment of £170. Hours: approx. 15 mins. (Registered 08 February 2022) Employment and earnings 10057ffd 2022-09-05   Sammy Wilson uk.org.publicwhip/person/11374 12 2022-09-05-10057ffd-11374-0
2558505f40f62355a6ab183382da78f6694ffc47 9 December 2021, payment of £100. Hours: approx. 15 mins. (Registered 08 February 2022) Employment and earnings 10057ffd 2022-09-05   Sammy Wilson uk.org.publicwhip/person/11374 13 2022-09-05-10057ffd-11374-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 70.609ms · Data source: mySociety Data · About: simonw/register-of-members-interests-datasette