items

Table actions

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

2 rows where record_id = "2004-12-03-1f359ece-10226-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
a3dd6c3c03e5e674f6ad6eaea1ce66fcd6ad400e Regular articles on science policy in the British Association for Advancement of Science Journal. (Up to £5,000) Remunerated employment, office, profession etc 1f359ece 2004-12-03 Ian Gibson uk.org.publicwhip/member/911 Ian Gibson uk.org.publicwhip/person/10226 0 2004-12-03-1f359ece-10226-0
c50607384b9806fd074102ae4ea7879b23e95873 16-21 February 2004, five day visit to Cuba with All-Party Parliamentary Group on Cuba, to visit hospitals, schools and scientific establishments. Cost of airfare met by IPU and cost of accommodation met by the Cuban National Assembly. (Registered 16 March 2004) Remunerated employment, office, profession etc 1f359ece 2004-12-03 Ian Gibson uk.org.publicwhip/member/911 Ian Gibson uk.org.publicwhip/person/10226 1 2004-12-03-1f359ece-10226-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");