items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
16 rows where record_id = "2014-10-27-28e22fe3-10854-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 |
---|---|---|---|---|---|---|---|
09360c4252fc3e6927cd2cc8bc9826303ecda9e6 | Payments received from Oakley Capital Limited, 3 Cadogan Gate, SW1X 0AS, for consultancy services provided through CGLV Ltd (see entry under Shareholdings below). Payments made to CGLV Ltd: | Clients 28e22fe3 | 2014-10-27 | Jonathan Djanogly uk.org.publicwhip/member/40326 | Jonathan Djanogly uk.org.publicwhip/person/10854 | 0 | 2014-10-27-28e22fe3-10854-0 |
dcdfb5f7f9ebc8384dc6d2e16ab3462e0cd3a163 | Received on 2 December 2013, £12,500 for consultancy services during the six month period ending 31 May 2014. Hours: 4.5 hrs. (Registered 13 December 2013) Received on 28 July 2014, £12,500 for consultancy services provided during the six month period commencing 1 June 2014. Hours: 10 hrs. (Registered 14 August 2014) | Clients 28e22fe3 | 2014-10-27 | Jonathan Djanogly uk.org.publicwhip/member/40326 | Jonathan Djanogly uk.org.publicwhip/person/10854 | 1 | 2014-10-27-28e22fe3-10854-0 |
5cffb0e181042d38720d0cba132f1da959396c25 | Payments received from SJ Berwin LLP, 10 Queen Street Place London EC4R 1BE, for consultancy services provided through CGLV Ltd (see entry under Shareholdings below). Payments made to CGLV Ltd: | Clients 28e22fe3 | 2014-10-27 | Jonathan Djanogly uk.org.publicwhip/member/40326 | Jonathan Djanogly uk.org.publicwhip/person/10854 | 2 | 2014-10-27-28e22fe3-10854-0 |
2ed8c2d6cd778826093d1dd7ab5220ddf8ed456a | Received on 27 September 2013, £5,000 for consultancy services provided during the month of August 2013. Hours: 6 hrs. (Registered 16 October 2013) | Clients 28e22fe3 | 2014-10-27 | Jonathan Djanogly uk.org.publicwhip/member/40326 | Jonathan Djanogly uk.org.publicwhip/person/10854 | 3 | 2014-10-27-28e22fe3-10854-0 |
7d4eec9ae5d970c6c19cd1a851aaa39db8bbdd67 | Received on 28 October 2013, £5,000 for consultancy services provided during the month of September 2013. Hours: 7 hrs. (Registered 31 October 2013) | Clients 28e22fe3 | 2014-10-27 | Jonathan Djanogly uk.org.publicwhip/member/40326 | Jonathan Djanogly uk.org.publicwhip/person/10854 | 4 | 2014-10-27-28e22fe3-10854-0 |
25ca8d74cb0dcc135c6a0b27c7d1a9b1af7fd935 | Received on 28 November 2013, £5,000 for consultancy services provided during the month of October 2013. Hours: 5 hrs. (Registered 13 December 2013) | Clients 28e22fe3 | 2014-10-27 | Jonathan Djanogly uk.org.publicwhip/member/40326 | Jonathan Djanogly uk.org.publicwhip/person/10854 | 5 | 2014-10-27-28e22fe3-10854-0 |
9f025ff16cb1cbb0d18b4043b8dcd72b0aea9797 | Received on 20 December 2013, £5,000 for consultancy services provided during the month of November 2013. Hours: 4 hrs. (Registered 8 January 2014) | Clients 28e22fe3 | 2014-10-27 | Jonathan Djanogly uk.org.publicwhip/member/40326 | Jonathan Djanogly uk.org.publicwhip/person/10854 | 6 | 2014-10-27-28e22fe3-10854-0 |
85b572326693e0a899b3245fba0420ebb43f1c04 | Received on 28 January 2014, £5,000 for consultancy services provided during the month of December 2013. Hours: 6 hrs. (Registered 3 February 2014) | Clients 28e22fe3 | 2014-10-27 | Jonathan Djanogly uk.org.publicwhip/member/40326 | Jonathan Djanogly uk.org.publicwhip/person/10854 | 7 | 2014-10-27-28e22fe3-10854-0 |
54375fbd7a5c1434ea80e8c70dcd1cf2cbf892f7 | Received on 28 February 2014, £5,000 for consultancy services provided during the month of January 2014. Hours: 12 hrs. (Registered 19 March 2014) | Clients 28e22fe3 | 2014-10-27 | Jonathan Djanogly uk.org.publicwhip/member/40326 | Jonathan Djanogly uk.org.publicwhip/person/10854 | 8 | 2014-10-27-28e22fe3-10854-0 |
6315bc3538d47481f84c4f79b6183e82abf8bd09 | Received on 28 March 2014, £5,000 for consultancy services provided during the month of February 2014. Hours: 6 hrs. (Registered 9 April 2014) | Clients 28e22fe3 | 2014-10-27 | Jonathan Djanogly uk.org.publicwhip/member/40326 | Jonathan Djanogly uk.org.publicwhip/person/10854 | 9 | 2014-10-27-28e22fe3-10854-0 |
37e48f88c5a35947109add0e3b2f009a71d434d5 | Received on 28 April 2014, £5,000 for consultancy services provided during the month of March 2014. Hours: 7 hrs. (Registered 15 May 2014) | Clients 28e22fe3 | 2014-10-27 | Jonathan Djanogly uk.org.publicwhip/member/40326 | Jonathan Djanogly uk.org.publicwhip/person/10854 | 10 | 2014-10-27-28e22fe3-10854-0 |
29005062cdb877f4e4f6e582b67437137dbbb95f | Received on 28 May 2014, £5,000 for consultancy services provided during the month of April 2014. Hours: 5 hrs. (Registered 2 July 2014) | Clients 28e22fe3 | 2014-10-27 | Jonathan Djanogly uk.org.publicwhip/member/40326 | Jonathan Djanogly uk.org.publicwhip/person/10854 | 11 | 2014-10-27-28e22fe3-10854-0 |
464ff4d4f6d6f897fd422b1588662079f4e3dc35 | Received on 27 June 2014, £5,000 for consultancy services provided during the month of May 2014. Hours: 9 hrs. (Registered 2 July 2014) | Clients 28e22fe3 | 2014-10-27 | Jonathan Djanogly uk.org.publicwhip/member/40326 | Jonathan Djanogly uk.org.publicwhip/person/10854 | 12 | 2014-10-27-28e22fe3-10854-0 |
db8b7dd829cf2519cc7808918a9f70e061fe4de6 | Received on 28 July 2014, £5,000 for consultancy services provided during the month of June 2014. Hours: 7 hrs. (Registered 14 August 2014) | Clients 28e22fe3 | 2014-10-27 | Jonathan Djanogly uk.org.publicwhip/member/40326 | Jonathan Djanogly uk.org.publicwhip/person/10854 | 13 | 2014-10-27-28e22fe3-10854-0 |
b9a7c0028d7aaa518a664f0d8dc6ae1d744b1641 | Received on 28 August 2014, £5,000 for consultancy services provided during the month of July 2014. Hours: 6 hrs. (Registered 30 September 2014) | Clients 28e22fe3 | 2014-10-27 | Jonathan Djanogly uk.org.publicwhip/member/40326 | Jonathan Djanogly uk.org.publicwhip/person/10854 | 14 | 2014-10-27-28e22fe3-10854-0 |
cbe2ac2c1213b6a358f80c07ad44067a984e0f16 | Received on 26 September 2014, £5,000 for consultancy services provided during the month of August 2014. Hours: 4 hrs. (Registered 30 September 2014) | Clients 28e22fe3 | 2014-10-27 | Jonathan Djanogly uk.org.publicwhip/member/40326 | Jonathan Djanogly uk.org.publicwhip/person/10854 | 15 | 2014-10-27-28e22fe3-10854-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");