items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
14 rows where record_id = "2022-06-13-10057ffd-11374-0" sorted by person_id
This data as json, CSV (advanced)
Suggested facets: date (date)
hash | item | category_id | date | member_id | person_id ▼ | sort_order | record_id |
---|---|---|---|---|---|---|---|
6e245e51083d80e9f1fef024b0d9dc30fef2a75f | 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-06-13 | Sammy Wilson uk.org.publicwhip/person/11374 | 0 | 2022-06-13-10057ffd-11374-0 | |
e5820365cad7c2e8ac6742b26e837a89cc7b867f | 16 January 2021, payment of £75. Hours: approx. 15 mins. (Registered 08 February 2022) | Employment and earnings 10057ffd | 2022-06-13 | Sammy Wilson uk.org.publicwhip/person/11374 | 1 | 2022-06-13-10057ffd-11374-0 | |
92f48621538c3c0b35017f7bf0c05e59e4008739 | 14 February 2021, payment of £75. Hours: approx. 15 mins. (Registered 08 February 2022) | Employment and earnings 10057ffd | 2022-06-13 | Sammy Wilson uk.org.publicwhip/person/11374 | 2 | 2022-06-13-10057ffd-11374-0 | |
863ed63ee9f846b1b2b52083a4601d004f937773 | 10 March 2021, payment of £75. Hours: approx. 15 mins. (Registered 08 February 2022) | Employment and earnings 10057ffd | 2022-06-13 | Sammy Wilson uk.org.publicwhip/person/11374 | 3 | 2022-06-13-10057ffd-11374-0 | |
b69a26bf5434507cdc864d8c4e154bf5ee1be127 | 12 April 2021, payment of £75. Hours: approx. 15 mins. (Registered 08 February 2022) | Employment and earnings 10057ffd | 2022-06-13 | Sammy Wilson uk.org.publicwhip/person/11374 | 4 | 2022-06-13-10057ffd-11374-0 | |
8c80527632ed1249fbfce7b20cffc229a9824e19 | 26 May 2021, payment of £75. Hours: approx. 15 mins. (Registered 08 February 2022) | Employment and earnings 10057ffd | 2022-06-13 | Sammy Wilson uk.org.publicwhip/person/11374 | 5 | 2022-06-13-10057ffd-11374-0 | |
0307313383241f6bd7b8f873b883f832f091e494 | 15 July 2021, payment of £100. Hours: approx. 15 mins. (Registered 08 February 2022) | Employment and earnings 10057ffd | 2022-06-13 | Sammy Wilson uk.org.publicwhip/person/11374 | 6 | 2022-06-13-10057ffd-11374-0 | |
8ab2dfea2ece1dbb2b1a814df0c3bf8a0e285748 | 10 September 2021, payment of £75. Hours: approx. 15 mins. (Registered 08 February 2022) | Employment and earnings 10057ffd | 2022-06-13 | Sammy Wilson uk.org.publicwhip/person/11374 | 7 | 2022-06-13-10057ffd-11374-0 | |
74dfa09f163bafec25598c125edbb3d8d80fa760 | 11 November 2021, payment of £75. Hours: approx. 15 mins. (Registered 08 February 2022) | Employment and earnings 10057ffd | 2022-06-13 | Sammy Wilson uk.org.publicwhip/person/11374 | 8 | 2022-06-13-10057ffd-11374-0 | |
94eb1e7467474c5f80887760160c967657a881fc | 6 December 2021, payment of £75. Hours: approx. 15 mins. (Registered 08 February 2022) | Employment and earnings 10057ffd | 2022-06-13 | Sammy Wilson uk.org.publicwhip/person/11374 | 9 | 2022-06-13-10057ffd-11374-0 | |
e7fc41a5d19354850164f42624e061953f494ac6 | 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-06-13 | Sammy Wilson uk.org.publicwhip/person/11374 | 10 | 2022-06-13-10057ffd-11374-0 | |
79ac5f1ebdadaab6468bd31e8802f69874fddb8d | 11 November 2021, payment of £120. Hours: approx. 15 mins. (Registered 08 February 2022) | Employment and earnings 10057ffd | 2022-06-13 | Sammy Wilson uk.org.publicwhip/person/11374 | 11 | 2022-06-13-10057ffd-11374-0 | |
c96014b2098e38bcead4b2a23182dd54cf2e558e | 24 November 2021, payment of £170. Hours: approx. 15 mins. (Registered 08 February 2022) | Employment and earnings 10057ffd | 2022-06-13 | Sammy Wilson uk.org.publicwhip/person/11374 | 12 | 2022-06-13-10057ffd-11374-0 | |
937a82cc27c1153473f951474408086df5e7dad2 | 9 December 2021, payment of £100. Hours: approx. 15 mins. (Registered 08 February 2022) | Employment and earnings 10057ffd | 2022-06-13 | Sammy Wilson uk.org.publicwhip/person/11374 | 13 | 2022-06-13-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");