items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
8 rows where record_id = "2019-09-02-10057ffd-10484-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 |
|---|---|---|---|---|---|---|---|
| 14cf5c7770589f2fa0b2aa514e0ca94ae461dffc | Payments from Drew University, 99 Great Russell Street, London WC1B 3LA: | Employment and earnings 10057ffd | 2019-09-02 | Steve Pound uk.org.publicwhip/person/10484 | 0 | 2019-09-02-10057ffd-10484-0 | |
| 5251de7ea1166cfc63c21658be755f8ed707f5bd | 31 October 2018 received £870 for a series of seminars and debates, acting as a political co-ordinator for the autumn semester. Hours: 16 hrs. (Registered 01 November 2018) | Employment and earnings 10057ffd | 2019-09-02 | Steve Pound uk.org.publicwhip/person/10484 | 1 | 2019-09-02-10057ffd-10484-0 | |
| f8af138fca9e956948f873f4cd095944eaaa12f4 | Payments from DODS Group plc, Level 11, The Shard, 32 London Bridge Street, London SE1 9SG, for speaking at Westminster Explained events. All payments donated to charity. (Registered 15 May 2015; updated 16 March 2017) | Employment and earnings 10057ffd | 2019-09-02 | Steve Pound uk.org.publicwhip/person/10484 | 2 | 2019-09-02-10057ffd-10484-0 | |
| 3ce002cce81e625ebeebf0e82b274f727f442c3a | 9 October 2018, received £150 for an event on 20 September 2018. Hours: 2 hrs. (Registered 17 October 2018) | Employment and earnings 10057ffd | 2019-09-02 | Steve Pound uk.org.publicwhip/person/10484 | 3 | 2019-09-02-10057ffd-10484-0 | |
| 3666defe1ae57046d19e79927aeea150d57f1ce3 | 14 November 2018, received £150 for an event on 11 October 2018. Hours: 2 hrs. (Registered 15 November 2018) | Employment and earnings 10057ffd | 2019-09-02 | Steve Pound uk.org.publicwhip/person/10484 | 4 | 2019-09-02-10057ffd-10484-0 | |
| 4b7a20ebb54d5eb09b3162f35e146aadbe4983a7 | 14 November 2018, received £150 for an event on 30 October 2018. Hours: 2 hrs. (Registered 15 November 2018) | Employment and earnings 10057ffd | 2019-09-02 | Steve Pound uk.org.publicwhip/person/10484 | 5 | 2019-09-02-10057ffd-10484-0 | |
| f2176020be0c6d1bafb0f66bca94b80ace4aceea | 14 February 2019, received £150 for an event on 22 January 2019. Hours: 2 hrs. (Registered 26 February 2019) | Employment and earnings 10057ffd | 2019-09-02 | Steve Pound uk.org.publicwhip/person/10484 | 6 | 2019-09-02-10057ffd-10484-0 | |
| 891a8b10aa4c2a40a9f68ec18cf2ba691d34c25b | 14 February 2019, received £150 for an event on 31 January 2019. Hours: 2 hrs. (Registered 26 February 2019) | Employment and earnings 10057ffd | 2019-09-02 | Steve Pound uk.org.publicwhip/person/10484 | 7 | 2019-09-02-10057ffd-10484-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");