items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
29 rows where record_id = "2017-02-20-10057ffd-11812-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 |
---|---|---|---|---|---|---|---|
576e6c7cc12b51131b39b1d54a8044529961c0e5 | Payments from News Presenters Ltd, 17 Wheeler Avenue, Oxted RH8 9LF. I have consulted ACoBA about these appointments. (Registered 29 September 2015) | Employment and earnings 10057ffd | 2017-02-20 | Nick Clegg uk.org.publicwhip/person/11812 | 0 | 2017-02-20-10057ffd-11812-0 | |
c593fded0fee39e432443bc3120b84474d8d17c3 | 11 February 2016, received £10,560 for delivering a key note speech with Q & A for King and Wood Mallesons (law firm), 10 Queen St Pl, London EC4R 1BE. Hours: 30 mins. (Registered 08 March 2016) | Employment and earnings 10057ffd | 2017-02-20 | Nick Clegg uk.org.publicwhip/person/11812 | 1 | 2017-02-20-10057ffd-11812-0 | |
b48845620b9d33b76467d468bd56082c0edac334 | 23 February 2016, received £36,660 for addressing Barclays, 1 Churchill Place, Canary Wharf, London E14 5RB, as part of their 'Referendum Speaker Series'. Hours: 5.25 hrs. (Registered 08 March 2016) | Employment and earnings 10057ffd | 2017-02-20 | Nick Clegg uk.org.publicwhip/person/11812 | 2 | 2017-02-20-10057ffd-11812-0 | |
9f9e1f34956681e0fe8ddf531424f774735a6b40 | 26 September 2016, received £30,800 for delivering a speech and participating in a discussion forum for MCI Amsterdam, Schipluidenlaan 4, 1062 HE, Amsterdam, the Netherlands. Hours: 14 hrs (including travel and preparation time). (Registered 27 October 2016) | Employment and earnings 10057ffd | 2017-02-20 | Nick Clegg uk.org.publicwhip/person/11812 | 3 | 2017-02-20-10057ffd-11812-0 | |
357ea6525e72eaa2247c2c3aad1a10668811387f | 9 December 2016, received £18,000 for delivering a speech and Q&A for PriceWaterhouse Coopers LLP, 1 Hays Lane, London SE1 2RD. Hours: 2 hrs. (Registered 12 January 2017) | Employment and earnings 10057ffd | 2017-02-20 | Nick Clegg uk.org.publicwhip/person/11812 | 4 | 2017-02-20-10057ffd-11812-0 | |
a7fec5b4d055ee9e0fc7420e422480ddc33f0ea4 | 15 December 2016, received £22,500 for delivering a speech and Q&A for SCOR (Financial Services), 5 Avenue Kleber, 75795, Paris, Cedex 16. Hours: 2 hrs. (Registered 12 January 2017) | Employment and earnings 10057ffd | 2017-02-20 | Nick Clegg uk.org.publicwhip/person/11812 | 5 | 2017-02-20-10057ffd-11812-0 | |
8083ed91ce6f04bfc758521a4317de1e045a4d78 | Payments from the Evening Standard, Northcliffe House, 2 Derry Street, London W8 5TT: | Employment and earnings 10057ffd | 2017-02-20 | Nick Clegg uk.org.publicwhip/person/11812 | 6 | 2017-02-20-10057ffd-11812-0 | |
4e9ed2f953c5bf23321848973acdc295be75a66d | 8 January 2016, received £500 for writing a column. Hours: 4 hrs. (Registered 08 February 2016) | Employment and earnings 10057ffd | 2017-02-20 | Nick Clegg uk.org.publicwhip/person/11812 | 7 | 2017-02-20-10057ffd-11812-0 | |
bd038739be6c3a32c3e8d4d0d5d9854373941d92 | 21 January 2016, received £500 for writing a column. Hours: 4 hrs. (Registered 08 February 2016) | Employment and earnings 10057ffd | 2017-02-20 | Nick Clegg uk.org.publicwhip/person/11812 | 8 | 2017-02-20-10057ffd-11812-0 | |
b00252cdb9f73d25b273d66e25a8313c7a9e62b0 | 4 February 2016, received £500 for writing a column. Hours: 4 hrs. (Registered 08 March 2016) | Employment and earnings 10057ffd | 2017-02-20 | Nick Clegg uk.org.publicwhip/person/11812 | 9 | 2017-02-20-10057ffd-11812-0 | |
00e63ba3a9ebb2ad0f920def9e8952b963e2f81f | 4 March 2016, received £500 for writing a column. Hours: 4 hrs. (Registered 24 March 2016) | Employment and earnings 10057ffd | 2017-02-20 | Nick Clegg uk.org.publicwhip/person/11812 | 10 | 2017-02-20-10057ffd-11812-0 | |
e335a7057a8cd3c2100891356829ccc07a9f2c8a | 17 March 2016, received £500 for writing a column. Hours: 4 hrs. (Registered 24 March 2016) | Employment and earnings 10057ffd | 2017-02-20 | Nick Clegg uk.org.publicwhip/person/11812 | 11 | 2017-02-20-10057ffd-11812-0 | |
06560e468ff3ad46927d2607a6d9b02168248507 | 31 March 2016, received £500 for writing a column. Hours: 4 hrs. (Registered 28 April 2016) | Employment and earnings 10057ffd | 2017-02-20 | Nick Clegg uk.org.publicwhip/person/11812 | 12 | 2017-02-20-10057ffd-11812-0 | |
d4b2fded542796eb3da22306f6ccbb839ccd6a17 | 29 April 2016, received £500 for writing a column. Hours: 4 hrs. (Registered 17 May 2016) | Employment and earnings 10057ffd | 2017-02-20 | Nick Clegg uk.org.publicwhip/person/11812 | 13 | 2017-02-20-10057ffd-11812-0 | |
32c2795e85e1b871819951057365147e1d59299c | 26 May 2016, received £350 for writing a column. Hours: 4 hrs. (Registered 22 June 2016) | Employment and earnings 10057ffd | 2017-02-20 | Nick Clegg uk.org.publicwhip/person/11812 | 14 | 2017-02-20-10057ffd-11812-0 | |
51b280c14ecfca7d3b565e4bd81cfff921aa2812 | 13 June 2016, received £700 for writing two columns. Hours: 8 hrs in total. (Registered 22 June 2016) | Employment and earnings 10057ffd | 2017-02-20 | Nick Clegg uk.org.publicwhip/person/11812 | 15 | 2017-02-20-10057ffd-11812-0 | |
68e15bfa17135359aff4aa3e4d75e91a063fbd5d | 24 June 2016, received £420 for writing a column. Hours: 4 hrs. (Registered 20 July 2016) | Employment and earnings 10057ffd | 2017-02-20 | Nick Clegg uk.org.publicwhip/person/11812 | 16 | 2017-02-20-10057ffd-11812-0 | |
459d212a2f2677a90b5f0f31b27b9060dde31666 | 29 September 2016, received £350 for writing a column. Hours: 4 hrs. (Registered 05 October 2016; updated 27 October 2016) | Employment and earnings 10057ffd | 2017-02-20 | Nick Clegg uk.org.publicwhip/person/11812 | 17 | 2017-02-20-10057ffd-11812-0 | |
feb21a4b2ede729683b8559a55ee3504c5024395 | 13 October 2016, received £700 for writing two columns. Hours: 8 hrs. (Registered 27 October 2016) | Employment and earnings 10057ffd | 2017-02-20 | Nick Clegg uk.org.publicwhip/person/11812 | 18 | 2017-02-20-10057ffd-11812-0 | |
192dd565dbbfb2d4a3999f205151455772d139fe | 27 October 2016, received £350 for writing a column. Hours: 4 hrs. (Registered 09 December 2016) | Employment and earnings 10057ffd | 2017-02-20 | Nick Clegg uk.org.publicwhip/person/11812 | 19 | 2017-02-20-10057ffd-11812-0 | |
b46c05811c92a985fd04201e0185162e8bd49b57 | 10 November 2016, received £850 for writing two columns. Hours: 8 hrs. (Registered 09 December 2016) | Employment and earnings 10057ffd | 2017-02-20 | Nick Clegg uk.org.publicwhip/person/11812 | 20 | 2017-02-20-10057ffd-11812-0 | |
3ee39ff27acd8750d58d088b30df3206ad6ae3a7 | 24 November 2016, received £500 for writing two columns. Hours: 6 hrs. (Registered 09 December 2016) | Employment and earnings 10057ffd | 2017-02-20 | Nick Clegg uk.org.publicwhip/person/11812 | 21 | 2017-02-20-10057ffd-11812-0 | |
9a7939b22d1864d3772d669ccd2e710bfbc12234 | 8 December 2016, received £350 for writing a column. Hours: 4 hrs. (Registered 09 December 2016) | Employment and earnings 10057ffd | 2017-02-20 | Nick Clegg uk.org.publicwhip/person/11812 | 22 | 2017-02-20-10057ffd-11812-0 | |
9f066ae39c43090bde6fa0e4d7fe7969be6768af | 28 December 2016, received £350 for writing a column. Hours: 4 hrs. (Registered 30 January 2017) | Employment and earnings 10057ffd | 2017-02-20 | Nick Clegg uk.org.publicwhip/person/11812 | 23 | 2017-02-20-10057ffd-11812-0 | |
8fb4628d1f64fa968f6588ad8627de77004072f9 | 21 April 2016, received £30,000 from Frederik Paulsen [private address], for delivering a speech and participating in a roundtable debate in Geneva. Hours: 6 hrs. Frederik Paulsen also paid for my flights and accommodation. (Registered 17 May 2016) | Employment and earnings 10057ffd | 2017-02-20 | Nick Clegg uk.org.publicwhip/person/11812 | 24 | 2017-02-20-10057ffd-11812-0 | |
fe3639883e889a2022a8601408572eed29e1d8dd | Payments from Penguin Random House, 20 Vauxhall Bridge Road, London SW1V 2SA, via Georgina Capel Associates Ltd (entertainment agency), 29 Wardour Street, London W1D 6PS: | Employment and earnings 10057ffd | 2017-02-20 | Nick Clegg uk.org.publicwhip/person/11812 | 25 | 2017-02-20-10057ffd-11812-0 | |
379ec8f246187bf01bdaca29ef1da4c648429517 | 19 July 2016, £41,000 advance instalment for book. £16,400 of this amount was paid to Open Reason. Hours: approx. 480 hrs to date. (Registered 18 August 2016; updated 31 August 2016) | Employment and earnings 10057ffd | 2017-02-20 | Nick Clegg uk.org.publicwhip/person/11812 | 26 | 2017-02-20-10057ffd-11812-0 | |
0324a1b8cf40706b316dc5a665b52069f109ce33 | 26 September 2016, £20,500 second advance instalment for book. £8,200 of this amount was paid to Open Reason. Hours: no additional hours. (Registered 27 October 2016) | Employment and earnings 10057ffd | 2017-02-20 | Nick Clegg uk.org.publicwhip/person/11812 | 27 | 2017-02-20-10057ffd-11812-0 | |
0ab3ea034dea11cd94a9347a12c477c7a1a94fc9 | 21 October 2016, received £15,000 from Hat Trick Productions Ltd, 33 Oval Road, London SW1 7EA, for guest presenting Have I Got News for You. Hours: 12 hrs. (Registered 27 October 2016) | Employment and earnings 10057ffd | 2017-02-20 | Nick Clegg uk.org.publicwhip/person/11812 | 28 | 2017-02-20-10057ffd-11812-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");