items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
8 rows where record_id = "2015-08-10-10057ffd-10678-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 |
---|---|---|---|---|---|---|---|
58a2d5e2ce9dc064d38d64067b4df2c8b3a2dac9 | Fees from Ipsos MORI ,9-81 Borough Road, London SE1 1FY, for opinion surveys: | Employment and earnings 10057ffd | 2015-08-10 | David Lammy uk.org.publicwhip/person/10678 | 0 | 2015-08-10-10057ffd-10678-0 | |
6c0f5f6f65c47a7263a2936786d6dc516650f1a7 | September 2014, fee of £200. Hours 1 hr. (Registered 23 September 2014) | Employment and earnings 10057ffd | 2015-08-10 | David Lammy uk.org.publicwhip/person/10678 | 1 | 2015-08-10-10057ffd-10678-0 | |
2800966ce5dfaba29156b314cc0f2da7d57752de | Payments for articles from Guardian News and Media Limited, PO Box 68164, Kings Place, 90 York Way, London N1P 2AP: | Employment and earnings 10057ffd | 2015-08-10 | David Lammy uk.org.publicwhip/person/10678 | 2 | 2015-08-10-10057ffd-10678-0 | |
f1cadc915b7662e2f830f4b8bd4b7dc8e1b790da | June 2014, fee of £90 received. Hours 2 hrs. (Registered 22 October 2014) | Employment and earnings 10057ffd | 2015-08-10 | David Lammy uk.org.publicwhip/person/10678 | 3 | 2015-08-10-10057ffd-10678-0 | |
d208794278c4aed2f1de6e28535f91bfe2368420 | August 2014, fee of £90 received. Hours: 2 hrs. (Registered 22 October 2014) | Employment and earnings 10057ffd | 2015-08-10 | David Lammy uk.org.publicwhip/person/10678 | 4 | 2015-08-10-10057ffd-10678-0 | |
3629e39125916769d71b6ffb567c3b9ac7e56ce6 | September 2014, fee of £915 received from Delta State University, Cleveland, MS 38733, USA, for speaking at and attending a conference. The costs of travel, accommodation and hospitality, 13-18 September 2014, were met by the donor. Hours: 4 hrs. (Registered 03 October 2014) | Employment and earnings 10057ffd | 2015-08-10 | David Lammy uk.org.publicwhip/person/10678 | 5 | 2015-08-10-10057ffd-10678-0 | |
072fda8bf84623b6dc4424155d8c8142f97a2631 | Fees from BBC, PO Box 480, Manchester M14 0EL: | Employment and earnings 10057ffd | 2015-08-10 | David Lammy uk.org.publicwhip/person/10678 | 6 | 2015-08-10-10057ffd-10678-0 | |
9e2015572b4e2b893808022a975af05799effa17 | 11 May 2015, received fee of £500 for TV appearance. Hours: 2 hrs. (Registered 01 June 2015) | Employment and earnings 10057ffd | 2015-08-10 | David Lammy uk.org.publicwhip/person/10678 | 7 | 2015-08-10-10057ffd-10678-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");