items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
12 rows where record_id = "2023-10-16-10057ffd-25843-0" sorted by date descending
This data as json, CSV (advanced)
Suggested facets: date (date)
hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
8e773ab75cac67d458275f38015cd14648f453f7 | Payments from YouGov, 50 Featherstone Street, London EC1Y 8RT, for surveys. All payments paid direct to charity. | Employment and earnings 10057ffd | 2023-10-16 | Virginia Crosbie uk.org.publicwhip/person/25843 | 0 | 2023-10-16-10057ffd-25843-0 | |
af33b27ab9beb2c60a02776f233a1c7018851533 | Payment of £100 expected for a survey completed on 14 October 2022. Hours: 30 mins. (Registered 09 November 2022) | Employment and earnings 10057ffd | 2023-10-16 | Virginia Crosbie uk.org.publicwhip/person/25843 | 1 | 2023-10-16-10057ffd-25843-0 | |
b055bb519c28140e30a7ce476be49031afd53436 | Payment of £100 expected for a survey completed on 24 November 2022. Hours: 30 mins. (Registered 15 December 2022) | Employment and earnings 10057ffd | 2023-10-16 | Virginia Crosbie uk.org.publicwhip/person/25843 | 2 | 2023-10-16-10057ffd-25843-0 | |
bc4767dc77e83cdecfb8ac1407668d0d6e4cb46d | Payment of £50 expected for a survey completed on 24 November 2022. Hours: 30 mins. (Registered 15 December 2022) | Employment and earnings 10057ffd | 2023-10-16 | Virginia Crosbie uk.org.publicwhip/person/25843 | 3 | 2023-10-16-10057ffd-25843-0 | |
4323426a143380bf058af619077787cab594ff32 | Payments from Yonder, Northburgh House, 10 Northburgh Street, London EC1V 0AT, for surveys. All payments paid direct to charity. | Employment and earnings 10057ffd | 2023-10-16 | Virginia Crosbie uk.org.publicwhip/person/25843 | 4 | 2023-10-16-10057ffd-25843-0 | |
668a1c4a9a879f314706add13a339611ad1b6a1f | 16 February 2022, payment of £75 for a survey completed on 2 February 2022. Hours: 30 mins. (Registered 10 November 2022) | Employment and earnings 10057ffd | 2023-10-16 | Virginia Crosbie uk.org.publicwhip/person/25843 | 5 | 2023-10-16-10057ffd-25843-0 | |
d5f75fd87120e2e332386474deaae1fc8457db8f | 4 April 2022, payment of £75 for a survey completed on 1 March 2022. Hours: 30 mins. (Registered 10 November 2022) | Employment and earnings 10057ffd | 2023-10-16 | Virginia Crosbie uk.org.publicwhip/person/25843 | 6 | 2023-10-16-10057ffd-25843-0 | |
695f4cc8c4b64cd71e2a63a814a8944a7b4ee4af | 4 August 2022, payment of £75 for a survey completed on 31 May 2022. Hours: 30 mins. (Registered 10 November 2022) | Employment and earnings 10057ffd | 2023-10-16 | Virginia Crosbie uk.org.publicwhip/person/25843 | 7 | 2023-10-16-10057ffd-25843-0 | |
57d95d70a2b9bc20ec60d1adff58dcf5152dd454 | 25 August 2022, payment of £75 for a survey completed on 15 July 2022. Hours: 30 mins. (Registered 10 November 2022) | Employment and earnings 10057ffd | 2023-10-16 | Virginia Crosbie uk.org.publicwhip/person/25843 | 8 | 2023-10-16-10057ffd-25843-0 | |
bd55f968b9e54226025af2070f228ad6771aafdd | Payment of £75 expected for a survey completed on 14 October 2022. Hours: 30 mins. (Registered 10 November 2022) | Employment and earnings 10057ffd | 2023-10-16 | Virginia Crosbie uk.org.publicwhip/person/25843 | 9 | 2023-10-16-10057ffd-25843-0 | |
2c6c3e6475266d0386204e466e347f1ff3d72b98 | Payment of £75 expected for a survey completed on 28 October 2022. Hours: 30 mins. (Registered 10 November 2022) | Employment and earnings 10057ffd | 2023-10-16 | Virginia Crosbie uk.org.publicwhip/person/25843 | 10 | 2023-10-16-10057ffd-25843-0 | |
abc9a301ed9845f4d71fbfb429240ef40229a3aa | Payment of £75 expected for another survey completed on 28 October 2022. Hours: 30 mins. (Registered 10 November 2022) | Employment and earnings 10057ffd | 2023-10-16 | Virginia Crosbie uk.org.publicwhip/person/25843 | 11 | 2023-10-16-10057ffd-25843-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");