items

Table actions

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

6 rows where record_id = "2010-04-12-f3967f4d-10290-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
1fed95fe412d9157b19ead4d9debe71f12ace7b1 Queen's Counsel (non-practising). Remunerated employment, office, profession, etc. f3967f4d 2010-04-12 Michael Howard uk.org.publicwhip/member/1587 Michael Howard uk.org.publicwhip/person/10290 0 2010-04-12-f3967f4d-10290-0
7e53090f5c193834acb4cbd70d2e7d1050e464ab Member, Strategic Advisory Council (formerly known as the International Advisory Board), Lightbridge Corporation, Inc (formerly Novastar Resources, Inc); the company develops nuclear fuel designs to dispose effectively and safely of weapons and reactor-grade plutonium, and also offers advice on the provision of nuclear power. Remunerated employment, office, profession, etc. f3967f4d 2010-04-12 Michael Howard uk.org.publicwhip/member/1587 Michael Howard uk.org.publicwhip/person/10290 1 2010-04-12-f3967f4d-10290-0
2ecf42e8e68a6d07631299ef9c5b190203fd7f2b Quarterly payment of £3710.08. Hours: 8 hours (Registered 2 January 2010) Remunerated employment, office, profession, etc. f3967f4d 2010-04-12 Michael Howard uk.org.publicwhip/member/1587 Michael Howard uk.org.publicwhip/person/10290 2 2010-04-12-f3967f4d-10290-0
7a6c353309373e9be064594ffddccb79bcb0f542 Member of the Advisory Board of Hermitage Global Fund; investment management. Remunerated employment, office, profession, etc. f3967f4d 2010-04-12 Michael Howard uk.org.publicwhip/member/1587 Michael Howard uk.org.publicwhip/person/10290 3 2010-04-12-f3967f4d-10290-0
9908b37573c7a19af447d6421ed7bbbf19b16753 Payment of £2936.00. Hours: 2 hours (Registered 20 October 2009) Remunerated employment, office, profession, etc. f3967f4d 2010-04-12 Michael Howard uk.org.publicwhip/member/1587 Michael Howard uk.org.publicwhip/person/10290 4 2010-04-12-f3967f4d-10290-0
dc55d45752233f00c2f414e85c11aaa160d83997 Payment of £250 from The Times, 1 Virginia St, London E98 1XY, for a book review. Hours: 10 hours. (Registered 20 October 2009) Remunerated employment, office, profession, etc. f3967f4d 2010-04-12 Michael Howard uk.org.publicwhip/member/1587 Michael Howard uk.org.publicwhip/person/10290 5 2010-04-12-f3967f4d-10290-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");