items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
15 rows where record_id = "2014-05-12-1aeb07b2-10051-0" sorted by sort_order
This data as json, CSV (advanced)
date (date) 1 ✖
- 2014-05-12 15
hash | item | category_id | date | member_id | person_id | sort_order ▼ | record_id |
---|---|---|---|---|---|---|---|
70ad8932b5f97dae8b5dccea42939827719371e1 | 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-05-12 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 0 | 2014-05-12-1aeb07b2-10051-0 |
620edadce2e7874e683abc9614f4dc935a394bfb | 27 March 2013, received £333.34. Hours: 12 hours (estimated). (Registered 3 June 2013) | Directorships 1aeb07b2 | 2014-05-12 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 1 | 2014-05-12-1aeb07b2-10051-0 |
7fc909f9ee71c107f8f8b338df02fd1e46bb1048 | 26 April 2013 received £333.34. Hours: 12 hours (estimated). (Registered 3 June 2013) | Directorships 1aeb07b2 | 2014-05-12 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 2 | 2014-05-12-1aeb07b2-10051-0 |
0396d15dcb0ce7493e03aada2543949842871af4 | 24 May 2013, received £333.34. Hours: 12 hours (estimated). (Registered 3 June 2013) | Directorships 1aeb07b2 | 2014-05-12 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 3 | 2014-05-12-1aeb07b2-10051-0 |
a41a94bdf23fb707419fe61d7d7326b4669a0fe8 | 27 June 2013, received £333.34. Hours: 8 hrs (estimated). (Registered 27 June 2013) | Directorships 1aeb07b2 | 2014-05-12 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 4 | 2014-05-12-1aeb07b2-10051-0 |
6cd1af5a51e17eeafbf8e479243514841df7dfe3 | 26 July 2013, received £333.34. Hours: 8 hrs (estimated). (Registered 2 August 2013) | Directorships 1aeb07b2 | 2014-05-12 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 5 | 2014-05-12-1aeb07b2-10051-0 |
a76dd62f53dd5a8974a6fa4d72614aff822ca619 | 27 August 2013, received £333.34. Hours: 8 hrs (estimated). (Registered 11 September 2013) | Directorships 1aeb07b2 | 2014-05-12 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 6 | 2014-05-12-1aeb07b2-10051-0 |
102a73d7913548b962cd3d22f3eda6cac2d5768a | 27 September 2013, received £333.34. Hours: 4 hrs (estimated). (Registered 7 October 2013) | Directorships 1aeb07b2 | 2014-05-12 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 7 | 2014-05-12-1aeb07b2-10051-0 |
9e0c6b371ed1f08a76647adb33f642d3ff775288 | 27 October 2 013, r eceived £333.34. Hours: 8 hrs (estimated). (Registered 4 November 2013) | Directorships 1aeb07b2 | 2014-05-12 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 8 | 2014-05-12-1aeb07b2-10051-0 |
0000f26b8c079e1bcfc99cd72cdc5440b28b6e77 | 27 November 2013, re ceived £333.34. Hours: 12 hrs (estimated). (Registered 4 December 2013) | Directorships 1aeb07b2 | 2014-05-12 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 9 | 2014-05-12-1aeb07b2-10051-0 |
a3b65121790c7c89e0671907bec9f0b43f5d67f7 | 27 December 2013, received £333. 34. Hours: 12 hrs (estimated). (Registered 17 February 2014) | Directorships 1aeb07b2 | 2014-05-12 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 10 | 2014-05-12-1aeb07b2-10051-0 |
1b5156296a9304e0085f869008aca28d79fc221d | 27 January 2014, received £333.34. Hours: 12 hrs (estimated). (Registered 17 February 2014) | Directorships 1aeb07b2 | 2014-05-12 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 11 | 2014-05-12-1aeb07b2-10051-0 |
ca639fb3b72b8a3ed4d1f0b1e592e31dc6e9a840 | 27 February 2014, re ceived £333.34. Hours: 24 hrs (estimated) . (Registered 10 April 2014) | Directorships 1aeb07b2 | 2014-05-12 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 12 | 2014-05-12-1aeb07b2-10051-0 |
a27a2f92d3c0482460bef5f648f5268a6a4bdc9a | 27 March 2 014, received £333.34. Hours: 16 hours (estimated) . (Registered 10 April 2014) | Directorships 1aeb07b2 | 2014-05-12 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 13 | 2014-05-12-1aeb07b2-10051-0 |
25c1620f6e2a7f27f77e1877c3d40135226b62ce | 27 April 2014, received £333.34. Hours: 12 hrs (estimated) . (Registered 7 May 2014) | Directorships 1aeb07b2 | 2014-05-12 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 14 | 2014-05-12-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");