items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
12 rows where record_id = "2014-10-27-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 |
---|---|---|---|---|---|---|---|
95f234eb0d22002d32f46449af635237a73149f9 | 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-10-27 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 0 | 2014-10-27-1aeb07b2-10051-0 |
d8adf48f5738a47cd5e99d5bc7507f817aa38bdd | 27 September 2013, received £333.34. Hours: 4 hrs (estimated). (Registered 7 October 2013) | Directorships 1aeb07b2 | 2014-10-27 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 1 | 2014-10-27-1aeb07b2-10051-0 |
0f097e07789e165d1d2e72b82159f694639f5f9c | 27 October 2 013, received £333.34. Hours: 8 hrs (estimated). (Registered 4 November 2013) | Directorships 1aeb07b2 | 2014-10-27 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 2 | 2014-10-27-1aeb07b2-10051-0 |
bb8dae3fb7940fee8eb3b8e44f317d85691f0b7a | 27 November 2013, received £333.34. Hours: 12 hrs (estimated). (Registered 4 December 2013) | Directorships 1aeb07b2 | 2014-10-27 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 3 | 2014-10-27-1aeb07b2-10051-0 |
44e1c42666330e4c823b8d8fcb789bffba86c98d | 27 December 2013, received £333.34. Hours: 12 hrs (estimated). (Registered 17 February 2014) | Directorships 1aeb07b2 | 2014-10-27 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 4 | 2014-10-27-1aeb07b2-10051-0 |
d3fba16ee0b4e1043abaffed0dbeec3e4c37bbe4 | 27 January 2014, received £333.34. Hours: 12 hrs (estimated). (Registered 17 February 2014) | Directorships 1aeb07b2 | 2014-10-27 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 5 | 2014-10-27-1aeb07b2-10051-0 |
06d9277bfbbab6d46995e682c54d722ac349d6cb | 27 February 2014, received £333.34. Hours: 24 hrs (estimated). (Registered 10 April 2014) | Directorships 1aeb07b2 | 2014-10-27 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 6 | 2014-10-27-1aeb07b2-10051-0 |
eae24dc458388238be7f19c05a91c7ae3e4516ab | 27 March 2014, received £333.34. Hours: 16 hours (estimated). (Registered 10 April 2014) | Directorships 1aeb07b2 | 2014-10-27 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 7 | 2014-10-27-1aeb07b2-10051-0 |
26b4a280280d22e35afb9673fbc074f361050622 | 27 April 2014, received £333.34. Hours: 12 hrs (estimated). (Registered 7 May 2014) | Directorships 1aeb07b2 | 2014-10-27 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 8 | 2014-10-27-1aeb07b2-10051-0 |
18f3ccf11bffcc86159a8bea8771f0ed4d7a7df6 | 27 May 2014, received £333.34. Hours: 8 hrs (estimated). (Registered 28 May 2014) | Directorships 1aeb07b2 | 2014-10-27 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 9 | 2014-10-27-1aeb07b2-10051-0 |
868cc910b87531972b5d65d151ebf9b2df6c3956 | 27 June 2014, received £333.34. Hours: 14 hrs (estimated). (Registered 26 August 2014) | Directorships 1aeb07b2 | 2014-10-27 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 10 | 2014-10-27-1aeb07b2-10051-0 |
84ec581b19915d2936d4e280df67c4033f23b03a | 27 July 2014, received £333.34. Hours: 8 hrs (estimated). (Registered 26 August 2014) | Directorships 1aeb07b2 | 2014-10-27 | Crispin Blunt uk.org.publicwhip/member/40496 | Crispin Blunt uk.org.publicwhip/person/10051 | 11 | 2014-10-27-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");