items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
14 rows where record_id = "2014-05-12-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 |
---|---|---|---|---|---|---|---|
a9c8753cbe6ce5ee1679867ad3c77bf0e3a9df41 | 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-05-12 | Jonathan Djanogly uk.org.publicwhip/member/40326 | Jonathan Djanogly uk.org.publicwhip/person/10854 | 0 | 2014-05-12-28e22fe3-10854-0 |
061309e7146582a200944ec1ede66fd202578872 | 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-05-12 | Jonathan Djanogly uk.org.publicwhip/member/40326 | Jonathan Djanogly uk.org.publicwhip/person/10854 | 1 | 2014-05-12-28e22fe3-10854-0 |
5f8b106aec165f07198f861a3d059aa40e2d358d | 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-05-12 | Jonathan Djanogly uk.org.publicwhip/member/40326 | Jonathan Djanogly uk.org.publicwhip/person/10854 | 2 | 2014-05-12-28e22fe3-10854-0 |
eeafd3ff1fc58a14906f1973f2ec2a7ac7c3dd20 | 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-05-12 | Jonathan Djanogly uk.org.publicwhip/member/40326 | Jonathan Djanogly uk.org.publicwhip/person/10854 | 3 | 2014-05-12-28e22fe3-10854-0 |
ef44e969bf242a5dfcbb9747f2d190cae114aa02 | 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-05-12 | Jonathan Djanogly uk.org.publicwhip/member/40326 | Jonathan Djanogly uk.org.publicwhip/person/10854 | 4 | 2014-05-12-28e22fe3-10854-0 |
2f371a576cc3d533dc85a9acf8cac107058bea34 | 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-05-12 | Jonathan Djanogly uk.org.publicwhip/member/40326 | Jonathan Djanogly uk.org.publicwhip/person/10854 | 5 | 2014-05-12-28e22fe3-10854-0 |
27f409543fe2c09472b1953397024efe2ae45192 | 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-05-12 | Jonathan Djanogly uk.org.publicwhip/member/40326 | Jonathan Djanogly uk.org.publicwhip/person/10854 | 6 | 2014-05-12-28e22fe3-10854-0 |
a8d20731491c942b17bad22d91f2aaf1a5958286 | 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-05-12 | Jonathan Djanogly uk.org.publicwhip/member/40326 | Jonathan Djanogly uk.org.publicwhip/person/10854 | 7 | 2014-05-12-28e22fe3-10854-0 |
501d68ead541efdce5f31eeecb17796dd5f2896b | 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-05-12 | Jonathan Djanogly uk.org.publicwhip/member/40326 | Jonathan Djanogly uk.org.publicwhip/person/10854 | 8 | 2014-05-12-28e22fe3-10854-0 |
ae2b46ba1c0f25fba3bfc4cb304b560a9f0bde5b | 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-05-12 | Jonathan Djanogly uk.org.publicwhip/member/40326 | Jonathan Djanogly uk.org.publicwhip/person/10854 | 9 | 2014-05-12-28e22fe3-10854-0 |
905cbb5b0602de6d28651319bb3496b7d1388bd9 | 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-05-12 | Jonathan Djanogly uk.org.publicwhip/member/40326 | Jonathan Djanogly uk.org.publicwhip/person/10854 | 10 | 2014-05-12-28e22fe3-10854-0 |
ea115074d992c0d765433d2ad6000578b640cc85 | 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-05-12 | Jonathan Djanogly uk.org.publicwhip/member/40326 | Jonathan Djanogly uk.org.publicwhip/person/10854 | 11 | 2014-05-12-28e22fe3-10854-0 |
42fa90b054caab6dc3c31f7332860da52b19f491 | 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-05-12 | Jonathan Djanogly uk.org.publicwhip/member/40326 | Jonathan Djanogly uk.org.publicwhip/person/10854 | 12 | 2014-05-12-28e22fe3-10854-0 |
b9dce155b517b6aef8b3c92744762402c6e738e2 | 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-05-12 | Jonathan Djanogly uk.org.publicwhip/member/40326 | Jonathan Djanogly uk.org.publicwhip/person/10854 | 13 | 2014-05-12-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");