items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
8 rows where record_id = "2013-02-25-1aeb07b2-24747-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 |
---|---|---|---|---|---|---|---|
00a883fa45b0a1777924bd3048775cebefc078fc | Non-executive director of JT Leavesley Ltd., Ryknield House, Alrewas, Burton-On-Trent, Staffordshire, DE13 7AB. Duties include attendance at meetings of the Board and providing consultancy services (advice and analysis) to the Leavesley Group, advising senior management on a range of issues related to the company’s agriculture, property and trading operations. (£10,001–£15,000) (Registered 18 May 2011) | Directorships 1aeb07b2 | 2013-02-25 | Christopher Pincher uk.org.publicwhip/member/40598 | Christopher Pincher uk.org.publicwhip/person/24747 | 0 | 2013-02-25-1aeb07b2-24747-0 |
3bd590ba8d7192287b776f47a962926bbf8655aa | Received payment of £2,000 on 26 January 2012. Hours: 10 hrs. (Registered 3 February 2012) | Directorships 1aeb07b2 | 2013-02-25 | Christopher Pincher uk.org.publicwhip/member/40598 | Christopher Pincher uk.org.publicwhip/person/24747 | 1 | 2013-02-25-1aeb07b2-24747-0 |
216909490c498581751e99876fa82a8845a46aa6 | Received payment of £1,000 on 30 March 2012. Hours: 4 hrs. (Registered 2 April 2012) | Directorships 1aeb07b2 | 2013-02-25 | Christopher Pincher uk.org.publicwhip/member/40598 | Christopher Pincher uk.org.publicwhip/person/24747 | 2 | 2013-02-25-1aeb07b2-24747-0 |
672cea1ec2eca4dd8743f13738fa915360c59827 | Received payment of £2,000 on 29 June 2012. Hours: 8 hrs. (Registered 4 July 2012) | Directorships 1aeb07b2 | 2013-02-25 | Christopher Pincher uk.org.publicwhip/member/40598 | Christopher Pincher uk.org.publicwhip/person/24747 | 3 | 2013-02-25-1aeb07b2-24747-0 |
44049162c4dd4720b15a4b4d332fb2100ddab611 | Received payment of £1,000 on 21 August 2012. Hours: 4 hrs. ( Registered 3 September 2012) | Directorships 1aeb07b2 | 2013-02-25 | Christopher Pincher uk.org.publicwhip/member/40598 | Christopher Pincher uk.org.publicwhip/person/24747 | 4 | 2013-02-25-1aeb07b2-24747-0 |
dd9eaeef866e15e40c454e354ae90774b7c38910 | Received payment of £1,000 on 31 August 2012. Hours: 4 hrs . (Registered 17 September 2012) | Directorships 1aeb07b2 | 2013-02-25 | Christopher Pincher uk.org.publicwhip/member/40598 | Christopher Pincher uk.org.publicwhip/person/24747 | 5 | 2013-02-25-1aeb07b2-24747-0 |
b298314dfd040adcf577e7f3c73c4a2d7e34afa5 | Received payment of £1,000 on 24 September 2012. Hours: 4 hrs. (Registered 23 October 2012) | Directorships 1aeb07b2 | 2013-02-25 | Christopher Pincher uk.org.publicwhip/member/40598 | Christopher Pincher uk.org.publicwhip/person/24747 | 6 | 2013-02-25-1aeb07b2-24747-0 |
9aa002fb0db2f4936a02833b7810eedd10c1dc74 | Received payment of £2,000 on 3 January 2013. Hours: 8 hrs. (Registered 21 January 2013) | Directorships 1aeb07b2 | 2013-02-25 | Christopher Pincher uk.org.publicwhip/member/40598 | Christopher Pincher uk.org.publicwhip/person/24747 | 7 | 2013-02-25-1aeb07b2-24747-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");