items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
12 rows where record_id = "2014-03-10-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 |
---|---|---|---|---|---|---|---|
3523d67c884f652c08adde46d04ced5ca6e3a2fb | 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-03-10 | Jonathan Djanogly uk.org.publicwhip/member/40326 | Jonathan Djanogly uk.org.publicwhip/person/10854 | 0 | 2014-03-10-28e22fe3-10854-0 |
4e7a19f95a1b9810d7e1b8ee10c67b9a0887096c | Received on 1 August 2013, £12,500 for consultancy services during the six month period ending 30 November 2013. Hours: 16 hours. (Registered 20 August 2013) | Clients 28e22fe3 | 2014-03-10 | Jonathan Djanogly uk.org.publicwhip/member/40326 | Jonathan Djanogly uk.org.publicwhip/person/10854 | 1 | 2014-03-10-28e22fe3-10854-0 |
73c48c49cecacf9e822374e3d771287d530a4865 | 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) | Clients 28e22fe3 | 2014-03-10 | Jonathan Djanogly uk.org.publicwhip/member/40326 | Jonathan Djanogly uk.org.publicwhip/person/10854 | 2 | 2014-03-10-28e22fe3-10854-0 |
0043664b2dcf6599f4b77fc7cbf6751962979fe5 | 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-03-10 | Jonathan Djanogly uk.org.publicwhip/member/40326 | Jonathan Djanogly uk.org.publicwhip/person/10854 | 3 | 2014-03-10-28e22fe3-10854-0 |
ec05c2c180b20cd0033f1a183ef574af35b3d51a | Received on 28 June 2013, £5,000 for consultancy services provided during the month of May 2013. Hours: 8 hrs. (Registered 1 July 2013) | Clients 28e22fe3 | 2014-03-10 | Jonathan Djanogly uk.org.publicwhip/member/40326 | Jonathan Djanogly uk.org.publicwhip/person/10854 | 4 | 2014-03-10-28e22fe3-10854-0 |
a4d1ca24924893431ff9e75c5a14ddbc09348c84 | Received on 26 July 2013, £5,000 for consultancy services provided during the month of June 2013. Hours: 7 hrs. (Registered 29 July 2013) | Clients 28e22fe3 | 2014-03-10 | Jonathan Djanogly uk.org.publicwhip/member/40326 | Jonathan Djanogly uk.org.publicwhip/person/10854 | 5 | 2014-03-10-28e22fe3-10854-0 |
c3235ce524f0972063532d80ee728ea7f5696791 | Received on 28 August 2013, £5,000 for consultancy services provided during the month of July 2013. Hours: 8 hrs. (Registered 24 September 2013) | Clients 28e22fe3 | 2014-03-10 | Jonathan Djanogly uk.org.publicwhip/member/40326 | Jonathan Djanogly uk.org.publicwhip/person/10854 | 6 | 2014-03-10-28e22fe3-10854-0 |
18a5affad34e122af8b3c97642cae75d7b9f24a0 | 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-03-10 | Jonathan Djanogly uk.org.publicwhip/member/40326 | Jonathan Djanogly uk.org.publicwhip/person/10854 | 7 | 2014-03-10-28e22fe3-10854-0 |
dab9d337bb22b3c07f3c18b9cba6fb5654f0bf38 | 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-03-10 | Jonathan Djanogly uk.org.publicwhip/member/40326 | Jonathan Djanogly uk.org.publicwhip/person/10854 | 8 | 2014-03-10-28e22fe3-10854-0 |
93ecfddfbe7b2f9598295ae430a30a64e3029b00 | 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-03-10 | Jonathan Djanogly uk.org.publicwhip/member/40326 | Jonathan Djanogly uk.org.publicwhip/person/10854 | 9 | 2014-03-10-28e22fe3-10854-0 |
920416c2d6927dfd288210863e7784953e0a844d | 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-03-10 | Jonathan Djanogly uk.org.publicwhip/member/40326 | Jonathan Djanogly uk.org.publicwhip/person/10854 | 10 | 2014-03-10-28e22fe3-10854-0 |
35df5cf614863b34f3deae208d72929f185b8f2a | 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-03-10 | Jonathan Djanogly uk.org.publicwhip/member/40326 | Jonathan Djanogly uk.org.publicwhip/person/10854 | 11 | 2014-03-10-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");