items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
31 rows where record_id = "2017-02-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 |
---|---|---|---|---|---|---|---|
3b89ee7b33493d0bb3ede095cdd37fc269d4ff99 | 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-06 | Nick Clegg uk.org.publicwhip/person/11812 | 0 | 2017-02-06-10057ffd-11812-0 | |
126d74c460d3cad0baffb05acd58fb3e974f2430 | 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-06 | Nick Clegg uk.org.publicwhip/person/11812 | 1 | 2017-02-06-10057ffd-11812-0 | |
1534ab17d58bca514724994be12ab066b78bcaf4 | 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-06 | Nick Clegg uk.org.publicwhip/person/11812 | 2 | 2017-02-06-10057ffd-11812-0 | |
d5e0bae6f2222361c2ba065e4b9ae5ebe5e58e9e | 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-06 | Nick Clegg uk.org.publicwhip/person/11812 | 3 | 2017-02-06-10057ffd-11812-0 | |
1e61c2ea2a82b5abbfebc13c04e6fe764466b8bd | 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-06 | Nick Clegg uk.org.publicwhip/person/11812 | 4 | 2017-02-06-10057ffd-11812-0 | |
95c27bf06dc83a39f34f633bc326d9299525530e | 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-06 | Nick Clegg uk.org.publicwhip/person/11812 | 5 | 2017-02-06-10057ffd-11812-0 | |
802601af6b0c6a8801c4c96778c1f0281a1a29c0 | Payments from the Evening Standard, Northcliffe House, 2 Derry Street, London W8 5TT: | Employment and earnings 10057ffd | 2017-02-06 | Nick Clegg uk.org.publicwhip/person/11812 | 6 | 2017-02-06-10057ffd-11812-0 | |
828a44ed2c19115fc99eafa4d6b411b57b4c760b | 8 January 2016, received £500 for writing a column. Hours: 4 hrs. (Registered 08 February 2016) | Employment and earnings 10057ffd | 2017-02-06 | Nick Clegg uk.org.publicwhip/person/11812 | 7 | 2017-02-06-10057ffd-11812-0 | |
aa5b7dea820c17c925521fc919da48cb2f359f00 | 21 January 2016, received £500 for writing a column. Hours: 4 hrs. (Registered 08 February 2016) | Employment and earnings 10057ffd | 2017-02-06 | Nick Clegg uk.org.publicwhip/person/11812 | 8 | 2017-02-06-10057ffd-11812-0 | |
ccaede4afd666cd3be7b3735e780c89376862fe2 | 4 February 2016, received £500 for writing a column. Hours: 4 hrs. (Registered 08 March 2016) | Employment and earnings 10057ffd | 2017-02-06 | Nick Clegg uk.org.publicwhip/person/11812 | 9 | 2017-02-06-10057ffd-11812-0 | |
7dbfc2ff378283f6a9c57108794c6602e4ef561d | 4 March 2016, received £500 for writing a column. Hours: 4 hrs. (Registered 24 March 2016) | Employment and earnings 10057ffd | 2017-02-06 | Nick Clegg uk.org.publicwhip/person/11812 | 10 | 2017-02-06-10057ffd-11812-0 | |
16a3a3f84d2e585a59af27c62ffe13f63362cdaa | 17 March 2016, received £500 for writing a column. Hours: 4 hrs. (Registered 24 March 2016) | Employment and earnings 10057ffd | 2017-02-06 | Nick Clegg uk.org.publicwhip/person/11812 | 11 | 2017-02-06-10057ffd-11812-0 | |
45a71331af1d2bcd243f082cd4f4cb48881e6b99 | 31 March 2016, received £500 for writing a column. Hours: 4 hrs. (Registered 28 April 2016) | Employment and earnings 10057ffd | 2017-02-06 | Nick Clegg uk.org.publicwhip/person/11812 | 12 | 2017-02-06-10057ffd-11812-0 | |
21aab98ae07039f6bd5dbd692f83a8627d6f5ac7 | 29 April 2016, received £500 for writing a column. Hours: 4 hrs. (Registered 17 May 2016) | Employment and earnings 10057ffd | 2017-02-06 | Nick Clegg uk.org.publicwhip/person/11812 | 13 | 2017-02-06-10057ffd-11812-0 | |
75690ccc49693ea79e67c7e876eb63536a416700 | 26 May 2016, received £350 for writing a column. Hours: 4 hrs. (Registered 22 June 2016) | Employment and earnings 10057ffd | 2017-02-06 | Nick Clegg uk.org.publicwhip/person/11812 | 14 | 2017-02-06-10057ffd-11812-0 | |
01a340a3858e31b430a33a96c87bb843f8cb46d3 | 13 June 2016, received £700 for writing two columns. Hours: 8 hrs in total. (Registered 22 June 2016) | Employment and earnings 10057ffd | 2017-02-06 | Nick Clegg uk.org.publicwhip/person/11812 | 15 | 2017-02-06-10057ffd-11812-0 | |
59d04c25733152622747e96276abf760fb1a8d8f | 24 June 2016, received £420 for writing a column. Hours: 4 hrs. (Registered 20 July 2016) | Employment and earnings 10057ffd | 2017-02-06 | Nick Clegg uk.org.publicwhip/person/11812 | 16 | 2017-02-06-10057ffd-11812-0 | |
151a62dc46679e4561c1e7d937e1ad3e4224789b | 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-06 | Nick Clegg uk.org.publicwhip/person/11812 | 17 | 2017-02-06-10057ffd-11812-0 | |
2451a96560821e4c9df985d27377c81ed6c97cc3 | 13 October 2016, received £700 for writing two columns. Hours: 8 hrs. (Registered 27 October 2016) | Employment and earnings 10057ffd | 2017-02-06 | Nick Clegg uk.org.publicwhip/person/11812 | 18 | 2017-02-06-10057ffd-11812-0 | |
adb013898aeecc795f29e903470b39286286e0bb | 27 October 2016, received £350 for writing a column. Hours: 4 hrs. (Registered 09 December 2016) | Employment and earnings 10057ffd | 2017-02-06 | Nick Clegg uk.org.publicwhip/person/11812 | 19 | 2017-02-06-10057ffd-11812-0 | |
6fe08e84e4450c1f9e8a4d483b4c9f58f4b7dbba | 10 November 2016, received £850 for writing two columns. Hours: 8 hrs. (Registered 09 December 2016) | Employment and earnings 10057ffd | 2017-02-06 | Nick Clegg uk.org.publicwhip/person/11812 | 20 | 2017-02-06-10057ffd-11812-0 | |
5cbe8a1b51ed1c965e2705c233eeb406679b9c58 | 24 November 2016, received £500 for writing two columns. Hours: 6 hrs. (Registered 09 December 2016) | Employment and earnings 10057ffd | 2017-02-06 | Nick Clegg uk.org.publicwhip/person/11812 | 21 | 2017-02-06-10057ffd-11812-0 | |
3ce5e57f816ab55b357455e6c9549daa37806372 | 8 December 2016, received £350 for writing a column. Hours: 4 hrs. (Registered 09 December 2016) | Employment and earnings 10057ffd | 2017-02-06 | Nick Clegg uk.org.publicwhip/person/11812 | 22 | 2017-02-06-10057ffd-11812-0 | |
979ab2f5bed4244f8d74ca31725d414c7be900ba | 28 December 2016, received £350 for writing a column. Hours: 4 hrs. (Registered 30 January 2017) | Employment and earnings 10057ffd | 2017-02-06 | Nick Clegg uk.org.publicwhip/person/11812 | 23 | 2017-02-06-10057ffd-11812-0 | |
637cbe77011e20d925b40a3ff32b1a0bc117808c | 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-06 | Nick Clegg uk.org.publicwhip/person/11812 | 24 | 2017-02-06-10057ffd-11812-0 | |
2f513ff26d077ae2414d12667f9218826bcb9795 | 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-06 | Nick Clegg uk.org.publicwhip/person/11812 | 25 | 2017-02-06-10057ffd-11812-0 | |
4bef8478943a2ee5477ca40a97a60fadc525c106 | 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-06 | Nick Clegg uk.org.publicwhip/person/11812 | 26 | 2017-02-06-10057ffd-11812-0 | |
c4aac2115b0746145493c3ba548480501b44628c | 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-06 | Nick Clegg uk.org.publicwhip/person/11812 | 27 | 2017-02-06-10057ffd-11812-0 | |
8f67832094b7aa826ba9933cafdbc5ce1ff13071 | 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-06 | Nick Clegg uk.org.publicwhip/person/11812 | 28 | 2017-02-06-10057ffd-11812-0 | |
ecad121cbaaf2219fb265dcb4a0cfbf9474d4752 | 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-02-06 | Nick Clegg uk.org.publicwhip/person/11812 | 29 | 2017-02-06-10057ffd-11812-0 | |
f8902f738bd14e1f3a3e280ba4e19d4be442834e | 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-02-06 | Nick Clegg uk.org.publicwhip/person/11812 | 30 | 2017-02-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");