items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
12 rows where record_id = "2014-07-28-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 |
---|---|---|---|---|---|---|---|
646c7926c24e3a4d4d759cf459038aab7e98d562 | 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-07-28 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 0 | 2014-07-28-1aeb07b2-10051-0 |
b76f77d7c6f319d47fb6fd5c49263e3535adcec6 | 26 July 2013, received £333.34. Hours: 8 hrs (estimated). (Registered 2 August 2013) | Directorships 1aeb07b2 | 2014-07-28 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 1 | 2014-07-28-1aeb07b2-10051-0 |
c684216bdf6bdee6eeaee3e0cd2e7b85a9829735 | 27 August 2013, received £333.34. Hours: 8 hrs (estimated). (Registered 11 September 2013) | Directorships 1aeb07b2 | 2014-07-28 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 2 | 2014-07-28-1aeb07b2-10051-0 |
a3096307716b641fb06466c9c7d62c3d910e356b | 27 September 2013, received £333.34. Hours: 4 hrs (estimated). (Registered 7 October 2013) | Directorships 1aeb07b2 | 2014-07-28 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 3 | 2014-07-28-1aeb07b2-10051-0 |
0f4cf45acf9b8c8eb0f63c50354f4f99807de2c6 | 27 October 2 013, received £333.34. Hours: 8 hrs (estimated). (Registered 4 November 2013) | Directorships 1aeb07b2 | 2014-07-28 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 4 | 2014-07-28-1aeb07b2-10051-0 |
fd1d2932077919e99b7583906f54ad74e3b3352c | 27 November 2013, received £333.34. Hours: 12 hrs (estimated). (Registered 4 December 2013) | Directorships 1aeb07b2 | 2014-07-28 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 5 | 2014-07-28-1aeb07b2-10051-0 |
654fb0887551dccb7af18753459134b58d2dc190 | 27 December 2013, received £333.34. Hours: 12 hrs (estimated). (Registered 17 February 2014) | Directorships 1aeb07b2 | 2014-07-28 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 6 | 2014-07-28-1aeb07b2-10051-0 |
c516f82daa0f275a20e31cdd7fdd2a6741da8717 | 27 January 2014, received £333.34. Hours: 12 hrs (estimated). (Registered 17 February 2014) | Directorships 1aeb07b2 | 2014-07-28 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 7 | 2014-07-28-1aeb07b2-10051-0 |
02ad79d11e4dafe201c63296b009109bac761881 | 27 February 2014, received £333.34. Hours: 24 hrs (estimated). (Registered 10 April 2014) | Directorships 1aeb07b2 | 2014-07-28 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 8 | 2014-07-28-1aeb07b2-10051-0 |
01fa17a82d530b5bfb8f3d16505af3a0f9b1f704 | 27 March 2014, received £333.34. Hours: 16 hours (estimated). (Registered 10 April 2014) | Directorships 1aeb07b2 | 2014-07-28 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 9 | 2014-07-28-1aeb07b2-10051-0 |
d3181a9d58d777e44d057e928a1201d29825a944 | 27 April 2014, received £333.34. Hours: 12 hrs (estimated). (Registered 7 May 2014) | Directorships 1aeb07b2 | 2014-07-28 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 10 | 2014-07-28-1aeb07b2-10051-0 |
c112fdd0c15f79d1a08460f11f81e605d31e333f | 27 May 2014, received £333.34. Hours: 8 hrs (estimated). (Registered 28 May 2014) | Directorships 1aeb07b2 | 2014-07-28 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 11 | 2014-07-28-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");