items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
32 rows where record_id = "2017-03-06-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 |
---|---|---|---|---|---|---|---|
d03dfbbdeb85f7cf911af1291b12fef680281c3f | 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-03-06 | Nick Clegg uk.org.publicwhip/person/11812 | 0 | 2017-03-06-10057ffd-11812-0 | |
9768c645f8624925a4f142a83d9ce8c4c3608eab | 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-03-06 | Nick Clegg uk.org.publicwhip/person/11812 | 1 | 2017-03-06-10057ffd-11812-0 | |
65bc1fe0a50a11c7d01955dc3a0fe41c860873fe | 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-03-06 | Nick Clegg uk.org.publicwhip/person/11812 | 2 | 2017-03-06-10057ffd-11812-0 | |
1db6edbe0562b3fd4cffc47d68a7da327fddeaf2 | 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-03-06 | Nick Clegg uk.org.publicwhip/person/11812 | 3 | 2017-03-06-10057ffd-11812-0 | |
8c0b6e6bbc2ead2a7998309f8a4901b5cf50d315 | 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-03-06 | Nick Clegg uk.org.publicwhip/person/11812 | 4 | 2017-03-06-10057ffd-11812-0 | |
6c482ae99dc05fb8b3b4ae70f2d19b562b4420f1 | 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-03-06 | Nick Clegg uk.org.publicwhip/person/11812 | 5 | 2017-03-06-10057ffd-11812-0 | |
8706223f9ebfcd21636655b1c9e2ed17872865f0 | Payments from the Evening Standard, Northcliffe House, 2 Derry Street, London W8 5TT: | Employment and earnings 10057ffd | 2017-03-06 | Nick Clegg uk.org.publicwhip/person/11812 | 6 | 2017-03-06-10057ffd-11812-0 | |
52ab413484eec4044cef984a6d3ca4314a2320d2 | 4 February 2016, received £500 for writing a column. Hours: 4 hrs. (Registered 08 March 2016) | Employment and earnings 10057ffd | 2017-03-06 | Nick Clegg uk.org.publicwhip/person/11812 | 7 | 2017-03-06-10057ffd-11812-0 | |
feaa5fbaf9238a119471f0ae8f40442d17cf9152 | 4 March 2016, received £500 for writing a column. Hours: 4 hrs. (Registered 24 March 2016) | Employment and earnings 10057ffd | 2017-03-06 | Nick Clegg uk.org.publicwhip/person/11812 | 8 | 2017-03-06-10057ffd-11812-0 | |
5976f19842b47e59d07ef3f4c1462ca864034d5a | 17 March 2016, received £500 for writing a column. Hours: 4 hrs. (Registered 24 March 2016) | Employment and earnings 10057ffd | 2017-03-06 | Nick Clegg uk.org.publicwhip/person/11812 | 9 | 2017-03-06-10057ffd-11812-0 | |
f5e24735e7b144a890950ba3c179a9bd359d7200 | 31 March 2016, received £500 for writing a column. Hours: 4 hrs. (Registered 28 April 2016) | Employment and earnings 10057ffd | 2017-03-06 | Nick Clegg uk.org.publicwhip/person/11812 | 10 | 2017-03-06-10057ffd-11812-0 | |
535abfb9db2960159e12b8a30211fde5d2cdf7f1 | 29 April 2016, received £500 for writing a column. Hours: 4 hrs. (Registered 17 May 2016) | Employment and earnings 10057ffd | 2017-03-06 | Nick Clegg uk.org.publicwhip/person/11812 | 11 | 2017-03-06-10057ffd-11812-0 | |
5761a9cdc586072367465c3ad86f76a07c1a18f7 | 26 May 2016, received £350 for writing a column. Hours: 4 hrs. (Registered 22 June 2016) | Employment and earnings 10057ffd | 2017-03-06 | Nick Clegg uk.org.publicwhip/person/11812 | 12 | 2017-03-06-10057ffd-11812-0 | |
d4f3b151a6b4f4be9dd3ea47c66a292b84cca48f | 13 June 2016, received £700 for writing two columns. Hours: 8 hrs in total. (Registered 22 June 2016) | Employment and earnings 10057ffd | 2017-03-06 | Nick Clegg uk.org.publicwhip/person/11812 | 13 | 2017-03-06-10057ffd-11812-0 | |
4b1723733346a9255cf109932a93ab7a818f2533 | 24 June 2016, received £420 for writing a column. Hours: 4 hrs. (Registered 20 July 2016) | Employment and earnings 10057ffd | 2017-03-06 | Nick Clegg uk.org.publicwhip/person/11812 | 14 | 2017-03-06-10057ffd-11812-0 | |
54ad76144af3d14d88219c36a820332306b4b0cf | 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-03-06 | Nick Clegg uk.org.publicwhip/person/11812 | 15 | 2017-03-06-10057ffd-11812-0 | |
4416cb44cf8c86d86e0331be274e873f1e9ef6de | 13 October 2016, received £700 for writing two columns. Hours: 8 hrs. (Registered 27 October 2016) | Employment and earnings 10057ffd | 2017-03-06 | Nick Clegg uk.org.publicwhip/person/11812 | 16 | 2017-03-06-10057ffd-11812-0 | |
a970b1ae2495d0bbeebae8ab1a4755077a1fadf8 | 27 October 2016, received £350 for writing a column. Hours: 4 hrs. (Registered 09 December 2016) | Employment and earnings 10057ffd | 2017-03-06 | Nick Clegg uk.org.publicwhip/person/11812 | 17 | 2017-03-06-10057ffd-11812-0 | |
a97197c9f7d6b3def4862b2c96afd628745dec10 | 10 November 2016, received £850 for writing two columns. Hours: 8 hrs. (Registered 09 December 2016) | Employment and earnings 10057ffd | 2017-03-06 | Nick Clegg uk.org.publicwhip/person/11812 | 18 | 2017-03-06-10057ffd-11812-0 | |
207b9d5b455b78eaa0f915f193da20659f6c7146 | 24 November 2016, received £500 for writing two columns. Hours: 6 hrs. (Registered 09 December 2016) | Employment and earnings 10057ffd | 2017-03-06 | Nick Clegg uk.org.publicwhip/person/11812 | 19 | 2017-03-06-10057ffd-11812-0 | |
e11498659de4daca3f765a67df45982118863f10 | 8 December 2016, received £350 for writing a column. Hours: 4 hrs. (Registered 09 December 2016) | Employment and earnings 10057ffd | 2017-03-06 | Nick Clegg uk.org.publicwhip/person/11812 | 20 | 2017-03-06-10057ffd-11812-0 | |
1e979c25be3df5ffafcd77cbfeb76b2fab276de4 | 28 December 2016, received £350 for writing a column. Hours: 4 hrs. (Registered 30 January 2017) | Employment and earnings 10057ffd | 2017-03-06 | Nick Clegg uk.org.publicwhip/person/11812 | 21 | 2017-03-06-10057ffd-11812-0 | |
e43d1cfbf59ce14b3602aa908d967b81cae8aeff | 23 January 2017, received £350 for writing a column. Hours: 4 hrs. (Registered 21 February 2017) | Employment and earnings 10057ffd | 2017-03-06 | Nick Clegg uk.org.publicwhip/person/11812 | 22 | 2017-03-06-10057ffd-11812-0 | |
5da1a6e77ecabc638254a67b75b846d507799510 | 9 February 2017, received £700 for writing two columns. Hours: 8 hrs. (Registered 21 February 2017) | Employment and earnings 10057ffd | 2017-03-06 | Nick Clegg uk.org.publicwhip/person/11812 | 23 | 2017-03-06-10057ffd-11812-0 | |
99c750b24e74c9705d5ccf15eb6d3dd3313e28d6 | 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-03-06 | Nick Clegg uk.org.publicwhip/person/11812 | 24 | 2017-03-06-10057ffd-11812-0 | |
289ce9054df217f229f39bc7c8df7bd3616fff25 | 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-03-06 | Nick Clegg uk.org.publicwhip/person/11812 | 25 | 2017-03-06-10057ffd-11812-0 | |
8cdc8af69d4e075d7cc99cd6c826fd71532219a4 | 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-03-06 | Nick Clegg uk.org.publicwhip/person/11812 | 26 | 2017-03-06-10057ffd-11812-0 | |
2b6b2d3b4f5a1d249bba89c92a7eb6b25827954c | 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-03-06 | Nick Clegg uk.org.publicwhip/person/11812 | 27 | 2017-03-06-10057ffd-11812-0 | |
adec1b6fdde2dcc09b3e19c31c562edff8e0c9b5 | 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-03-06 | Nick Clegg uk.org.publicwhip/person/11812 | 28 | 2017-03-06-10057ffd-11812-0 | |
deb13b75b80a0e7fead76dfe6c5ac4bffa8e7dfa | 1 December 2016, received £450 from Dewynters Ltd (art and live entertainment marketing specialists), Wellington House, 125 Strand, London WC2R 0AP, for writing the editorial of a theatre production. Hours: 4 hrs. (Registered 15 December 2016) | Employment and earnings 10057ffd | 2017-03-06 | Nick Clegg uk.org.publicwhip/person/11812 | 29 | 2017-03-06-10057ffd-11812-0 | |
55a9036ebd16489ae3a8dda8004d9f3987d5e17d | 12 January 2017, received £1,000 from Intelligence Squared, 6th Floor Newcombe House, 45 Notting Hill Gate, London W11 3LQ, for speaking at an event. Hours: 2 hrs. (Registered 26 January 2017) | Employment and earnings 10057ffd | 2017-03-06 | Nick Clegg uk.org.publicwhip/person/11812 | 30 | 2017-03-06-10057ffd-11812-0 | |
7548252fcd82bf2bd316bb3254d87aa64cdf9a6a | 15 February 2017, received £400 from News UK & Ireland Ltd, 1 London Bridge Street, London SE1 9GF, for an article in the Sunday Times. Hours: 4 hrs. (Registered 21 February 2017) | Employment and earnings 10057ffd | 2017-03-06 | Nick Clegg uk.org.publicwhip/person/11812 | 31 | 2017-03-06-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");