items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
16 rows where record_id = "2014-06-30-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 |
---|---|---|---|---|---|---|---|
021ea510379814136d1b8400558665cf4892bfec | 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-30 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 0 | 2014-06-30-1aeb07b2-10051-0 |
41bee6c43fdd794962b7a576021e41418c9dfeb4 | 27 March 2013, received £333.34. Hours: 12 hours (estimated). (Registered 3 June 2013) | Directorships 1aeb07b2 | 2014-06-30 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 1 | 2014-06-30-1aeb07b2-10051-0 |
08b55484e85780c37745d0a4872218c148a02884 | 26 April 2013 received £333.34. Hours: 12 hours (estimated). (Registered 3 June 2013) | Directorships 1aeb07b2 | 2014-06-30 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 2 | 2014-06-30-1aeb07b2-10051-0 |
af5710f097cc8ecafa4e544b0b39ee1c4207a598 | 24 May 2013, received £333.34. Hours: 12 hours (estimated). (Registered 3 June 2013) | Directorships 1aeb07b2 | 2014-06-30 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 3 | 2014-06-30-1aeb07b2-10051-0 |
b0170b47f9d1075e3b240dd684a41727d33b4956 | 27 June 2013, received £333.34. Hours: 8 hrs (estimated). (Registered 27 June 2013) | Directorships 1aeb07b2 | 2014-06-30 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 4 | 2014-06-30-1aeb07b2-10051-0 |
805653bf4b17f00a501f8d11472933bd7286555c | 26 July 2013, received £333.34. Hours: 8 hrs (estimated). (Registered 2 August 2013) | Directorships 1aeb07b2 | 2014-06-30 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 5 | 2014-06-30-1aeb07b2-10051-0 |
3e1225f7ee9f650f1df317c24ba734ccb3014570 | 27 August 2013, received £333.34. Hours: 8 hrs (estimated). (Registered 11 September 2013) | Directorships 1aeb07b2 | 2014-06-30 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 6 | 2014-06-30-1aeb07b2-10051-0 |
8a2454064b672bbad4a9f5c8d5338c13f6df0df9 | 27 September 2013, received £333.34. Hours: 4 hrs (estimated). (Registered 7 October 2013) | Directorships 1aeb07b2 | 2014-06-30 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 7 | 2014-06-30-1aeb07b2-10051-0 |
08b89e6a4c4dbabe4a0770795c6cea99ba0f7131 | 27 October 2 013, received £333.34. Hours: 8 hrs (estimated). (Registered 4 November 2013) | Directorships 1aeb07b2 | 2014-06-30 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 8 | 2014-06-30-1aeb07b2-10051-0 |
80d6be7fa1cf799d66864a710691c4b0e2f9b559 | 27 November 2013, received £333.34. Hours: 12 hrs (estimated). (Registered 4 December 2013) | Directorships 1aeb07b2 | 2014-06-30 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 9 | 2014-06-30-1aeb07b2-10051-0 |
3e0428655776787c6369aee93e6658e4f955ab27 | 27 December 2013, received £333.34. Hours: 12 hrs (estimated). (Registered 17 February 2014) | Directorships 1aeb07b2 | 2014-06-30 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 10 | 2014-06-30-1aeb07b2-10051-0 |
db6bb9ba26a0b7bcb860d950e399aad47866f4a5 | 27 January 2014, received £333.34. Hours: 12 hrs (estimated). (Registered 17 February 2014) | Directorships 1aeb07b2 | 2014-06-30 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 11 | 2014-06-30-1aeb07b2-10051-0 |
6bfa28ca6f47a8033408a336f837a7811aad427f | 27 February 2014, received £333.34. Hours: 24 hrs (estimated). (Registered 10 April 2014) | Directorships 1aeb07b2 | 2014-06-30 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 12 | 2014-06-30-1aeb07b2-10051-0 |
25dd6c96404024cbde9cfd1666eae1fc350c8ae3 | 27 March 2014, received £333.34. Hours: 16 hours (estimated). (Registered 10 April 2014) | Directorships 1aeb07b2 | 2014-06-30 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 13 | 2014-06-30-1aeb07b2-10051-0 |
6e4f97389490784bf29c9f2b32a1f82cc2801a9f | 27 April 2014, received £333.34. Hours: 12 hrs (estimated). (Registered 7 May 2014) | Directorships 1aeb07b2 | 2014-06-30 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 14 | 2014-06-30-1aeb07b2-10051-0 |
216dcc35b31a850f394158808d658d0404a5163a | 27 May 2014, received £333.34. Hours: 8 hrs (estimated). (Registered 28 May 2014) | Directorships 1aeb07b2 | 2014-06-30 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 15 | 2014-06-30-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");