home / regmem

items

Data source: mySociety Data

2 rows where record_id = "2014-10-13-1aeb07b2-10252-0" sorted by sort_order

View and edit SQL

hash item category_id date member_id person_id sort_order record_id
0008bf7fc98c1d74b115ded37491fc13c64c9875 Non-executive director of Amara Mining PLC, 29-30 Cornhill, London EC3V 3NF; gold producer with portfolio of assets in West Africa.  I receive £31,500 with effect from 6 March 2013 and expenses for any associated travel and accommodation costs. Expected annual time commitment of 12 days.  (Registered 19 March 2013; updated 10 July 2013) Directorships 1aeb07b2 2014-10-13 uk.org.publicwhip/member/40414 Peter Hain uk.org.publicwhip/person/10252 0 2014-10-13-1aeb07b2-10252-0
cc37784b5b40aa57648f743812caac0553e7b806 Advisory Board Member of Developing Market Associates Ltd, 1 Tooley Street, London SE1 2TU; a social enterprise promoting investment and development, especially in Africa with agencies including the World Bank.  I receive £20,000 annually with effect from 3 June 2014. Expected annual time commitment of 12 days.  (Registered 23 June 2014) Directorships 1aeb07b2 2014-10-13 uk.org.publicwhip/member/40414 Peter Hain uk.org.publicwhip/person/10252 1 2014-10-13-1aeb07b2-10252-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 4.847ms · Data source: mySociety Data