items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
9 rows where record_id = "2010-04-12-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 |
---|---|---|---|---|---|---|---|
39e65ea9b0d7c6a4b4e2f09476c377be0db7a574 | 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-04-12 | Philip Dunne uk.org.publicwhip/member/1696 | Philip Dunne uk.org.publicwhip/person/11696 | 0 | 2010-04-12-ead1ca87-11696-0 |
5ecf8672c64f9aee571a7df9cae1afc97b550efe | 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-04-12 | Philip Dunne uk.org.publicwhip/member/1696 | Philip Dunne uk.org.publicwhip/person/11696 | 1 | 2010-04-12-ead1ca87-11696-0 |
d125233abbce418cd773001f64c3d14b49b4b7b4 | 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-04-12 | Philip Dunne uk.org.publicwhip/member/1696 | Philip Dunne uk.org.publicwhip/person/11696 | 2 | 2010-04-12-ead1ca87-11696-0 |
841fbf7dbc3c476ebd68c7ba9feeaa5be2e71d15 | 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-04-12 | Philip Dunne uk.org.publicwhip/member/1696 | Philip Dunne uk.org.publicwhip/person/11696 | 3 | 2010-04-12-ead1ca87-11696-0 |
c35c733233ba942588454d25187aa67197dd21c9 | 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-04-12 | Philip Dunne uk.org.publicwhip/member/1696 | Philip Dunne uk.org.publicwhip/person/11696 | 4 | 2010-04-12-ead1ca87-11696-0 |
09b90b785a77391584bf6d8d7fb7d45b14a4040b | 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-04-12 | Philip Dunne uk.org.publicwhip/member/1696 | Philip Dunne uk.org.publicwhip/person/11696 | 5 | 2010-04-12-ead1ca87-11696-0 |
bdccdacebd16b6bda3a4364f6e00e48708599c33 | 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-04-12 | Philip Dunne uk.org.publicwhip/member/1696 | Philip Dunne uk.org.publicwhip/person/11696 | 6 | 2010-04-12-ead1ca87-11696-0 |
0a9b574bedd0e2c452d0d06691317797a72fcbd8 | 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-04-12 | Philip Dunne uk.org.publicwhip/member/1696 | Philip Dunne uk.org.publicwhip/person/11696 | 7 | 2010-04-12-ead1ca87-11696-0 |
c35314621cd404cb81ced5bbc3f29e1f7d42c59b | 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-04-12 | Philip Dunne uk.org.publicwhip/member/1696 | Philip Dunne uk.org.publicwhip/person/11696 | 8 | 2010-04-12-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");