items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
12 rows where record_id = "2016-05-16-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 |
---|---|---|---|---|---|---|---|
0d9a5cf74b17d5bd7e4ca2dacc522a94b6ba92d8 | 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-05-16 | Diane Abbott uk.org.publicwhip/person/10001 | 0 | 2016-05-16-10057ffd-10001-0 | |
19e4e00e2d9f2d22fc2070d2a7ac781ac454da9c | 9 April 2015, received £700. Hours: 3 hrs. (Registered 26 May 2015) | Employment and earnings 10057ffd | 2016-05-16 | Diane Abbott uk.org.publicwhip/person/10001 | 1 | 2016-05-16-10057ffd-10001-0 | |
d150e0f3a72ef6720c06c194eef102cd1737c291 | 23 April 2015, received £700. Hours: 3 hrs. (Registered 26 May 2015) | Employment and earnings 10057ffd | 2016-05-16 | Diane Abbott uk.org.publicwhip/person/10001 | 2 | 2016-05-16-10057ffd-10001-0 | |
d8949d776d3018d10dc14b15ca307b4a1591bc3d | 14 May 2015, received £700. Hours: 3 hrs. (Registered 03 June 2015) | Employment and earnings 10057ffd | 2016-05-16 | Diane Abbott uk.org.publicwhip/person/10001 | 3 | 2016-05-16-10057ffd-10001-0 | |
b969d5c86caff581642ff3ec7d7bc407d4aa6d56 | 4 June 2015, received £700. Hours: 3 hrs. (Registered 01 July 2015) | Employment and earnings 10057ffd | 2016-05-16 | Diane Abbott uk.org.publicwhip/person/10001 | 4 | 2016-05-16-10057ffd-10001-0 | |
87de3928befb6f8e0aa68c0cec730b495e9102fd | 18 June 2015, received £700. Hours: 3 hrs. (Registered 01 July 2015) | Employment and earnings 10057ffd | 2016-05-16 | Diane Abbott uk.org.publicwhip/person/10001 | 5 | 2016-05-16-10057ffd-10001-0 | |
02c2a746ddeb4f76382d3f751d008dfcfaaed965 | 16 July 2015, received £700. Hours: 3 hrs. (Registered 07 August 2015) | Employment and earnings 10057ffd | 2016-05-16 | Diane Abbott uk.org.publicwhip/person/10001 | 6 | 2016-05-16-10057ffd-10001-0 | |
9335c86906d5491a0de496f1689ab7862b17d73f | 8 January 2016, received £700 for an appearance on 17 December 2015. Hours: 3 hrs. (Registered 14 January 2016) | Employment and earnings 10057ffd | 2016-05-16 | Diane Abbott uk.org.publicwhip/person/10001 | 7 | 2016-05-16-10057ffd-10001-0 | |
534c63c2f6344b5a8951b6549b3a940b90ecca7f | 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-05-16 | Diane Abbott uk.org.publicwhip/person/10001 | 8 | 2016-05-16-10057ffd-10001-0 | |
7aec97f71314a6e599ffa8fe9938733f7ed4864d | 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-05-16 | Diane Abbott uk.org.publicwhip/person/10001 | 9 | 2016-05-16-10057ffd-10001-0 | |
42584e051d7a9600a3e95ae8121054befcad2955 | 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-05-16 | Diane Abbott uk.org.publicwhip/person/10001 | 10 | 2016-05-16-10057ffd-10001-0 | |
aa87aadaa617daf402227baeffd02df9b11e6908 | 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-05-16 | Diane Abbott uk.org.publicwhip/person/10001 | 11 | 2016-05-16-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");