home / regmem

items

Data source: mySociety Data

15 rows where record_id = "2014-05-12-1aeb07b2-10051-0" sorted by sort_order

View and edit SQL

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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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, object

CSV options:

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)
    )
Powered by Datasette · Query took 81.972ms · Data source: mySociety Data