items

Table actions

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

2 rows where record_id = "2013-09-30-1aeb07b2-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
0bfacb614c9d9e3477178ecea39729db88988979 Social Investment Business, 5th Floor, 6 St Andrew Street, London EC4A 3AE; investing in charities and social enterprises. Three days per month chairing Investment Committee for Futurebuilders Fund and as Vice Chair of the Board. Directorship relinquished in September 2012. Directorships 1aeb07b2 2013-09-30 Harriett Baldwin uk.org.publicwhip/member/40654 Harriett Baldwin uk.org.publicwhip/person/24785 0 2013-09-30-1aeb07b2-24785-0
8a798801ef465de7bddb06c6aa7b9556b4e35feb Payment of £584 on 30 September 2012. Hours: 13 hrs. (Registered 15 October 2012) Directorships 1aeb07b2 2013-09-30 Harriett Baldwin uk.org.publicwhip/member/40654 Harriett Baldwin uk.org.publicwhip/person/24785 1 2013-09-30-1aeb07b2-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");