items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
9 rows where record_id = "2010-03-24-ead1ca87-11696-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 |
---|---|---|---|---|---|---|---|
26d99ea18907293cfc004923cea448118bb7d38b | Baronsmead VCT-4-PLC, 100 Wood Street, London EC2V 7AN. I attend board and periodic other meetings as a non-executive director of this venture capital trust. | Remunerated directorships ead1ca87 | 2010-03-24 | Philip Dunne uk.org.publicwhip/member/1696 | Philip Dunne uk.org.publicwhip/person/11696 | 0 | 2010-03-24-ead1ca87-11696-0 |
3a1bc5633b9b1adf6fce89338a525cbb2ab0705d | Payment of £1,666.66 gross (£897.30 net) for period 1-31 July 2009. Hours: 5hrs. (Registered 1 September 2009) | Remunerated directorships ead1ca87 | 2010-03-24 | Philip Dunne uk.org.publicwhip/member/1696 | Philip Dunne uk.org.publicwhip/person/11696 | 1 | 2010-03-24-ead1ca87-11696-0 |
3187621a3a450b07625b66c25089da504f384524 | Payment of £1,666.66 gross (£815.46 net) for period 1-31 August 2009. Hours: 6hrs. ( Registered 21 September 2009) | Remunerated directorships ead1ca87 | 2010-03-24 | Philip Dunne uk.org.publicwhip/member/1696 | Philip Dunne uk.org.publicwhip/person/11696 | 2 | 2010-03-24-ead1ca87-11696-0 |
6a5a22d1ed67276452ca61ffd3b44ee005f132c3 | Payment of £1,666.66 gross (£815.46 net) for period 1-30 September 2009. Hours: 3 hrs. (Registered 5 October 2009) | Remunerated directorships ead1ca87 | 2010-03-24 | Philip Dunne uk.org.publicwhip/member/1696 | Philip Dunne uk.org.publicwhip/person/11696 | 3 | 2010-03-24-ead1ca87-11696-0 |
7aab07fc6c6ee4f56340453eaf99823e2af66308 | Payment of £1666.66 gross (£815.46 net) for period 1 - 31 October 2009. Hours: 5 hrs. (Registered 4 November 2009) | Remunerated directorships ead1ca87 | 2010-03-24 | Philip Dunne uk.org.publicwhip/member/1696 | Philip Dunne uk.org.publicwhip/person/11696 | 4 | 2010-03-24-ead1ca87-11696-0 |
787e1565f1b1249e19cfd2154584c65d3ae82852 | Payment of £1666.66 gross (£820.74 net) for period 1-30 November 2009. Hours: 6 hrs. (Registered 7 December 2009) | Remunerated directorships ead1ca87 | 2010-03-24 | Philip Dunne uk.org.publicwhip/member/1696 | Philip Dunne uk.org.publicwhip/person/11696 | 5 | 2010-03-24-ead1ca87-11696-0 |
4540c28a8245d061159a4506ca282f9f3f4083b9 | Payment of £1666.66 gross (£815.46 net) for the period 1-31 December 2009. Hours: 4 hrs. (Registered 5 January 2010) | Remunerated directorships ead1ca87 | 2010-03-24 | Philip Dunne uk.org.publicwhip/member/1696 | Philip Dunne uk.org.publicwhip/person/11696 | 6 | 2010-03-24-ead1ca87-11696-0 |
7971fd0d43fe556345dd213a1d67748e5b38cfba | Payment of £1666.66 gross (£815.46 net) for the period 1-31 January 2010. Hours: 6 hrs. (Registered 4 February 2010) | Remunerated directorships ead1ca87 | 2010-03-24 | Philip Dunne uk.org.publicwhip/member/1696 | Philip Dunne uk.org.publicwhip/person/11696 | 7 | 2010-03-24-ead1ca87-11696-0 |
ff4743363c50e6c72e1580df9bffd01f0800a91c | Payment of £1,666.66 gross (£820.74 net) for the period 1-28 February 2010. Hours: 8 hrs. (Registered 3 March 2010) | Remunerated directorships ead1ca87 | 2010-03-24 | Philip Dunne uk.org.publicwhip/member/1696 | Philip Dunne uk.org.publicwhip/person/11696 | 8 | 2010-03-24-ead1ca87-11696-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");