items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
14 rows where record_id = "2022-06-27-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 |
---|---|---|---|---|---|---|---|
545bdda1fe28d0ebe4d7cc45fbfd522b33ffadf9 | 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-27 | Sammy Wilson uk.org.publicwhip/person/11374 | 0 | 2022-06-27-10057ffd-11374-0 | |
7d0a5e3add8b931bcaf2d22aba0678ecc0591bb0 | 16 January 2021, payment of £75. Hours: approx. 15 mins. (Registered 08 February 2022) | Employment and earnings 10057ffd | 2022-06-27 | Sammy Wilson uk.org.publicwhip/person/11374 | 1 | 2022-06-27-10057ffd-11374-0 | |
eddfedc0beb90e8ff398c5ced145b926c3ca92c0 | 14 February 2021, payment of £75. Hours: approx. 15 mins. (Registered 08 February 2022) | Employment and earnings 10057ffd | 2022-06-27 | Sammy Wilson uk.org.publicwhip/person/11374 | 2 | 2022-06-27-10057ffd-11374-0 | |
d46ebb7ea83191a2f8fb0b947ce417f0e9c4082f | 10 March 2021, payment of £75. Hours: approx. 15 mins. (Registered 08 February 2022) | Employment and earnings 10057ffd | 2022-06-27 | Sammy Wilson uk.org.publicwhip/person/11374 | 3 | 2022-06-27-10057ffd-11374-0 | |
e27d24d918855538375f3609e12d6583cf35b013 | 12 April 2021, payment of £75. Hours: approx. 15 mins. (Registered 08 February 2022) | Employment and earnings 10057ffd | 2022-06-27 | Sammy Wilson uk.org.publicwhip/person/11374 | 4 | 2022-06-27-10057ffd-11374-0 | |
39c53b977d97b8cc13de4f2c8deb6032bc11141c | 26 May 2021, payment of £75. Hours: approx. 15 mins. (Registered 08 February 2022) | Employment and earnings 10057ffd | 2022-06-27 | Sammy Wilson uk.org.publicwhip/person/11374 | 5 | 2022-06-27-10057ffd-11374-0 | |
7e45939b077942ea018346cb48ac04826e277999 | 15 July 2021, payment of £100. Hours: approx. 15 mins. (Registered 08 February 2022) | Employment and earnings 10057ffd | 2022-06-27 | Sammy Wilson uk.org.publicwhip/person/11374 | 6 | 2022-06-27-10057ffd-11374-0 | |
97949bf01adf20cb57843e0558a4b663e67c72db | 10 September 2021, payment of £75. Hours: approx. 15 mins. (Registered 08 February 2022) | Employment and earnings 10057ffd | 2022-06-27 | Sammy Wilson uk.org.publicwhip/person/11374 | 7 | 2022-06-27-10057ffd-11374-0 | |
ff5ce869bb2e8cf84a46af3d369fc498c34a2601 | 11 November 2021, payment of £75. Hours: approx. 15 mins. (Registered 08 February 2022) | Employment and earnings 10057ffd | 2022-06-27 | Sammy Wilson uk.org.publicwhip/person/11374 | 8 | 2022-06-27-10057ffd-11374-0 | |
6d0db69c383730770012daff510dc6ad713b1a26 | 6 December 2021, payment of £75. Hours: approx. 15 mins. (Registered 08 February 2022) | Employment and earnings 10057ffd | 2022-06-27 | Sammy Wilson uk.org.publicwhip/person/11374 | 9 | 2022-06-27-10057ffd-11374-0 | |
d049c97b6e185bbc7ac6c57bbd4a09c9113169a3 | 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-27 | Sammy Wilson uk.org.publicwhip/person/11374 | 10 | 2022-06-27-10057ffd-11374-0 | |
27dc281ad55328a06673dc3d79ae40a7cbcb024c | 11 November 2021, payment of £120. Hours: approx. 15 mins. (Registered 08 February 2022) | Employment and earnings 10057ffd | 2022-06-27 | Sammy Wilson uk.org.publicwhip/person/11374 | 11 | 2022-06-27-10057ffd-11374-0 | |
2bdb256464e3d4885910c55d9a217107a45d5f8a | 24 November 2021, payment of £170. Hours: approx. 15 mins. (Registered 08 February 2022) | Employment and earnings 10057ffd | 2022-06-27 | Sammy Wilson uk.org.publicwhip/person/11374 | 12 | 2022-06-27-10057ffd-11374-0 | |
400e191cf5a3e8194a52d84e86d5887a6c88f7b4 | 9 December 2021, payment of £100. Hours: approx. 15 mins. (Registered 08 February 2022) | Employment and earnings 10057ffd | 2022-06-27 | Sammy Wilson uk.org.publicwhip/person/11374 | 13 | 2022-06-27-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");