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 category_id
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
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");