items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
10 rows where record_id = "2016-06-06-10057ffd-10001-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 |
---|---|---|---|---|---|---|---|
31dec5d79f697ba72230f97a9344ab8b96d48fe7 | Fees received for co-presenting BBC’s ‘This Week’ TV programme. Address: BBC Broadcasting House, Portland Place, London W1A 1AA. (Registered 04 November 2013) | Employment and earnings 10057ffd | 2016-06-06 | Diane Abbott uk.org.publicwhip/person/10001 | 0 | 2016-06-06-10057ffd-10001-0 | |
0323b6f21ad03ba91c002b3c7df6f138ec589da1 | 14 May 2015, received £700. Hours: 3 hrs. (Registered 03 June 2015) | Employment and earnings 10057ffd | 2016-06-06 | Diane Abbott uk.org.publicwhip/person/10001 | 1 | 2016-06-06-10057ffd-10001-0 | |
8bc24235e8b05a0b038e219da76c64d6c0b79d6c | 4 June 2015, received £700. Hours: 3 hrs. (Registered 01 July 2015) | Employment and earnings 10057ffd | 2016-06-06 | Diane Abbott uk.org.publicwhip/person/10001 | 2 | 2016-06-06-10057ffd-10001-0 | |
8041e72f1c84c6bc835a6e88eb949f470645e048 | 18 June 2015, received £700. Hours: 3 hrs. (Registered 01 July 2015) | Employment and earnings 10057ffd | 2016-06-06 | Diane Abbott uk.org.publicwhip/person/10001 | 3 | 2016-06-06-10057ffd-10001-0 | |
55ea8d01f6ddca086a78f203731d0810cbdb6252 | 16 July 2015, received £700. Hours: 3 hrs. (Registered 07 August 2015) | Employment and earnings 10057ffd | 2016-06-06 | Diane Abbott uk.org.publicwhip/person/10001 | 4 | 2016-06-06-10057ffd-10001-0 | |
4510df70040a15adeb548687f4bade643854ef2b | 8 January 2016, received £700 for an appearance on 17 December 2015. Hours: 3 hrs. (Registered 14 January 2016) | Employment and earnings 10057ffd | 2016-06-06 | Diane Abbott uk.org.publicwhip/person/10001 | 5 | 2016-06-06-10057ffd-10001-0 | |
2897873f6fd6607c282e91fca0793a4e4306b8d2 | 28 July 2015, received £4,000 for taking part in Grant Thornton’s panel at the JLA/FD Intelligence Post-election event. Address: JLA, 14 Berners Street, London W1T 3LJ. Hours: 5 hrs. (Registered 07 August 2015) | Employment and earnings 10057ffd | 2016-06-06 | Diane Abbott uk.org.publicwhip/person/10001 | 6 | 2016-06-06-10057ffd-10001-0 | |
c4e91ae59c396b80b59c18e1baa00c7d4c784182 | 23rd October 2015, received £1,500 for co-presenting BBC’s "Have I Got News for You" TV programme. Address: Hat Trick Productions, 33 Oval Road Camden, London NW1 7EA. Hours: 5 hrs. (Registered 26 October 2015) | Employment and earnings 10057ffd | 2016-06-06 | Diane Abbott uk.org.publicwhip/person/10001 | 7 | 2016-06-06-10057ffd-10001-0 | |
0b2488ccc6290cb392943756ae04a86ee039f85f | 10 October 2015, received £1,400 for taking part in a talk at the New Wolsey Theatre in Ipswich. Address: Clive Conway Productions, 32 Grove St, Oxford OX2 7JT. Hours: 5 hrs. (Registered 26 October 2015) | Employment and earnings 10057ffd | 2016-06-06 | Diane Abbott uk.org.publicwhip/person/10001 | 8 | 2016-06-06-10057ffd-10001-0 | |
a01bb0428a5621b50f5724b00c6f674e59acf785 | 21 March 2016, received £4,000 via Speakers Corner (London) Ltd, Unit 31, Highbury Studios, 10 Hornsey Street, London N7 8EL, from Thompson Reuters, Canary Wharf, London E14 5EP, for speaking and consulting on a panel. Hours: 10 hrs. (Registered 06 April 2016) | Employment and earnings 10057ffd | 2016-06-06 | Diane Abbott uk.org.publicwhip/person/10001 | 9 | 2016-06-06-10057ffd-10001-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");