items

Table actions

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

3 rows where member_id = "uk.org.publicwhip/member/722" 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
ffe5e4345137898f9db7dc500cb90d7cd419d864 Donation to my constituency party from the GMB trade union. (Registered 22 March 2005) Sponsorship or financial or material support 9e46def6 2005-04-11 Anne Begg uk.org.publicwhip/member/722 Anne Begg uk.org.publicwhip/person/10032 0 2005-04-11-9e46def6-10032-0
d53d90bac3088284fd02ca61a3b106de21ce1d2c 27-29 August 2002, to Norway, with the All-Party Parliamentary Group for the British Offshore Oil and Gas Industry to visit the Offshore Northern Seas exhibition in Stavanger, to meet Norwegian parliamentary colleagues and to visit Statoil's gas terminals at Kaarsto. Flights, accommodation, transport and hospitality sponsored by UK Offshore Operators Association, Chevron Texaco and Statoil. (Registered 18 October 2002) Overseas visits 80ef1083 2002-11-26 Anne Begg uk.org.publicwhip/member/722 Anne Begg uk.org.publicwhip/person/10032 0 2002-11-26-80ef1083-10032-0
d0ab6aa992e454526f90c6c8f1fa1a93e28e5ca9 Occasional journalism and media appearances. Remunerated employment, office, profession etc 1f359ece 2002-05-14 Anne Begg uk.org.publicwhip/member/722 Anne Begg uk.org.publicwhip/person/10032 0 2002-05-14-1f359ece-10032-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");