items

Table actions

Data source: mySociety Data · About: simonw/register-of-members-interests-datasette

1 row where record_id = "2014-04-28-5f2cbd10-24785-0" sorted by date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: date (date)

hash item category_id date ▲ member_id person_id sort_order record_id
b1b79047c873020a9d7fb2cddbbc68eaee03a8f0 I was employed by JP Morgan Chase from 1986 to 2008 and until December 2012 I had non-registrable interests in the JPMorgan Japanese Smaller Companies Trust, the JPMorgan US Discovery Trust and the JP Morgan UK Smaller Companies Trust, in addition to my registrable interest in the JPMorgan Employee 98 Trust which was closed in September 2013. (Registered 7 February 2011; updated 29 January 2013) Miscellaneous 5f2cbd10 2014-04-28 Harriett Baldwin uk.org.publicwhip/member/40654 Harriett Baldwin uk.org.publicwhip/person/24785 0 2014-04-28-5f2cbd10-24785-0

Advanced export

JSON shape: default, array, newline-delimited, 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)
    );
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");