items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
14 rows where record_id = "2022-07-11-10057ffd-11374-0" sorted by sort_order
This data as json, CSV (advanced)
Suggested facets: date (date)
hash | item | category_id | date | member_id | person_id | sort_order ▼ | record_id |
---|---|---|---|---|---|---|---|
65efc8688d480c7aa8af0d2f94620848518162e2 | 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-07-11 | Sammy Wilson uk.org.publicwhip/person/11374 | 0 | 2022-07-11-10057ffd-11374-0 | |
68c3f6e5da0ed0e6d2c6863ea253710a76421733 | 16 January 2021, payment of £75. Hours: approx. 15 mins. (Registered 08 February 2022) | Employment and earnings 10057ffd | 2022-07-11 | Sammy Wilson uk.org.publicwhip/person/11374 | 1 | 2022-07-11-10057ffd-11374-0 | |
604da307cc8853d125ff169e5fa607eb54b2ae90 | 14 February 2021, payment of £75. Hours: approx. 15 mins. (Registered 08 February 2022) | Employment and earnings 10057ffd | 2022-07-11 | Sammy Wilson uk.org.publicwhip/person/11374 | 2 | 2022-07-11-10057ffd-11374-0 | |
8d7cde1e35c26d2e049275d4d9fdc8c683e235de | 10 March 2021, payment of £75. Hours: approx. 15 mins. (Registered 08 February 2022) | Employment and earnings 10057ffd | 2022-07-11 | Sammy Wilson uk.org.publicwhip/person/11374 | 3 | 2022-07-11-10057ffd-11374-0 | |
125042d6ed109218e31c773b40f4a972245f1505 | 12 April 2021, payment of £75. Hours: approx. 15 mins. (Registered 08 February 2022) | Employment and earnings 10057ffd | 2022-07-11 | Sammy Wilson uk.org.publicwhip/person/11374 | 4 | 2022-07-11-10057ffd-11374-0 | |
550b752f26294d4629f3ae85d5f01ab500deea1d | 26 May 2021, payment of £75. Hours: approx. 15 mins. (Registered 08 February 2022) | Employment and earnings 10057ffd | 2022-07-11 | Sammy Wilson uk.org.publicwhip/person/11374 | 5 | 2022-07-11-10057ffd-11374-0 | |
bbde74cfcececd132ff478f6ecc1f1311004b08f | 15 July 2021, payment of £100. Hours: approx. 15 mins. (Registered 08 February 2022) | Employment and earnings 10057ffd | 2022-07-11 | Sammy Wilson uk.org.publicwhip/person/11374 | 6 | 2022-07-11-10057ffd-11374-0 | |
423880090b108ad4547d2d5ff4c25cbc837809ad | 10 September 2021, payment of £75. Hours: approx. 15 mins. (Registered 08 February 2022) | Employment and earnings 10057ffd | 2022-07-11 | Sammy Wilson uk.org.publicwhip/person/11374 | 7 | 2022-07-11-10057ffd-11374-0 | |
c1e0d7114429660f3667e11445314143819bb810 | 11 November 2021, payment of £75. Hours: approx. 15 mins. (Registered 08 February 2022) | Employment and earnings 10057ffd | 2022-07-11 | Sammy Wilson uk.org.publicwhip/person/11374 | 8 | 2022-07-11-10057ffd-11374-0 | |
b0d2e771d916e2842662a665ef79c5b69a4ec5cd | 6 December 2021, payment of £75. Hours: approx. 15 mins. (Registered 08 February 2022) | Employment and earnings 10057ffd | 2022-07-11 | Sammy Wilson uk.org.publicwhip/person/11374 | 9 | 2022-07-11-10057ffd-11374-0 | |
bef11a2231519e739bb70eba26bcecd1c1e5fbd1 | 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-07-11 | Sammy Wilson uk.org.publicwhip/person/11374 | 10 | 2022-07-11-10057ffd-11374-0 | |
4e5a2a8b99d451788c06e0a57aa84ede8603318f | 11 November 2021, payment of £120. Hours: approx. 15 mins. (Registered 08 February 2022) | Employment and earnings 10057ffd | 2022-07-11 | Sammy Wilson uk.org.publicwhip/person/11374 | 11 | 2022-07-11-10057ffd-11374-0 | |
3d19ba91dbba9d347a5922c3455557a303e15acc | 24 November 2021, payment of £170. Hours: approx. 15 mins. (Registered 08 February 2022) | Employment and earnings 10057ffd | 2022-07-11 | Sammy Wilson uk.org.publicwhip/person/11374 | 12 | 2022-07-11-10057ffd-11374-0 | |
2761980754eef0da36469dfb7b061938f3164404 | 9 December 2021, payment of £100. Hours: approx. 15 mins. (Registered 08 February 2022) | Employment and earnings 10057ffd | 2022-07-11 | Sammy Wilson uk.org.publicwhip/person/11374 | 13 | 2022-07-11-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");