items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
16 rows where record_id = "2014-06-02-1aeb07b2-10051-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 |
---|---|---|---|---|---|---|---|
a648abb18b15cc4f88c6c906dd4e6a7c7ef93e76 | On 30 January 2013 I was appointed as a non-executive director of the Social Investment Business Group. Address: 1st Floor, Derbyshire House, St Chad's Street, London WC1H 8AG. | Directorships 1aeb07b2 | 2014-06-02 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 0 | 2014-06-02-1aeb07b2-10051-0 |
e2db2a1e6192fdeb466474078001ebe3b2f95c24 | 27 March 2013, received £333.34. Hours: 12 hours (estimated). (Registered 3 June 2013) | Directorships 1aeb07b2 | 2014-06-02 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 1 | 2014-06-02-1aeb07b2-10051-0 |
e8206dbc5cfb9f1a81aecd5eea04228c60be6117 | 26 April 2013 received £333.34. Hours: 12 hours (estimated). (Registered 3 June 2013) | Directorships 1aeb07b2 | 2014-06-02 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 2 | 2014-06-02-1aeb07b2-10051-0 |
91b8bb51e61df5560f6b842d729b1ee62107391b | 24 May 2013, received £333.34. Hours: 12 hours (estimated). (Registered 3 June 2013) | Directorships 1aeb07b2 | 2014-06-02 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 3 | 2014-06-02-1aeb07b2-10051-0 |
b868432bb422d17932777f1db95fb12677fc2217 | 27 June 2013, received £333.34. Hours: 8 hrs (estimated). (Registered 27 June 2013) | Directorships 1aeb07b2 | 2014-06-02 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 4 | 2014-06-02-1aeb07b2-10051-0 |
4912bfda6f3f3a02d29b78273a620379a4874019 | 26 July 2013, received £333.34. Hours: 8 hrs (estimated). (Registered 2 August 2013) | Directorships 1aeb07b2 | 2014-06-02 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 5 | 2014-06-02-1aeb07b2-10051-0 |
7d1912c0cb122f453859db1ac7a8294885fe2a30 | 27 August 2013, received £333.34. Hours: 8 hrs (estimated). (Registered 11 September 2013) | Directorships 1aeb07b2 | 2014-06-02 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 6 | 2014-06-02-1aeb07b2-10051-0 |
30d7989742378af162366d6d6224990d813bc1b3 | 27 September 2013, received £333.34. Hours: 4 hrs (estimated). (Registered 7 October 2013) | Directorships 1aeb07b2 | 2014-06-02 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 7 | 2014-06-02-1aeb07b2-10051-0 |
51a316f6d24e77192fd9c878a36ade7660d07426 | 27 October 2 013, received £333.34. Hours: 8 hrs (estimated). (Registered 4 November 2013) | Directorships 1aeb07b2 | 2014-06-02 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 8 | 2014-06-02-1aeb07b2-10051-0 |
6a5046f76239417a2e866f13edca4748ceaf3cb0 | 27 November 2013, received £333.34. Hours: 12 hrs (estimated). (Registered 4 December 2013) | Directorships 1aeb07b2 | 2014-06-02 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 9 | 2014-06-02-1aeb07b2-10051-0 |
2f5ec9a68f61ba358652a771c8da116c4c9eb583 | 27 December 2013, received £333.34. Hours: 12 hrs (estimated). (Registered 17 February 2014) | Directorships 1aeb07b2 | 2014-06-02 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 10 | 2014-06-02-1aeb07b2-10051-0 |
d5a32ec7134c859395addd3ac65732abeb46eae5 | 27 January 2014, received £333.34. Hours: 12 hrs (estimated). (Registered 17 February 2014) | Directorships 1aeb07b2 | 2014-06-02 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 11 | 2014-06-02-1aeb07b2-10051-0 |
ea30373e2d85461621c6e51adfa0be69815a32ef | 27 February 2014, received £333.34. Hours: 24 hrs (estimated). (Registered 10 April 2014) | Directorships 1aeb07b2 | 2014-06-02 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 12 | 2014-06-02-1aeb07b2-10051-0 |
386dd80797c4a205c26e8e05d7c449f8133c7940 | 27 March 2014, received £333.34. Hours: 16 hours (estimated). (Registered 10 April 2014) | Directorships 1aeb07b2 | 2014-06-02 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 13 | 2014-06-02-1aeb07b2-10051-0 |
4e2077b9bea09607db9372b8e75cc2f08183af35 | 27 April 2014, received £333.34. Hours: 12 hrs (estimated). (Registered 7 May 2014) | Directorships 1aeb07b2 | 2014-06-02 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 14 | 2014-06-02-1aeb07b2-10051-0 |
0a36f8c49fc8f5f1e5094c8a7ff0a610226249ac | 27 May 2014, received £333.34. Hours: 8 hrs (estimated). (Registered 28 May 2014) | Directorships 1aeb07b2 | 2014-06-02 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 15 | 2014-06-02-1aeb07b2-10051-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");