items

Table actions

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

4 rows where record_id = "2009-10-14-80ef1083-10014-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
6a41d679e140ba571aaa9922910d90de16dc53a6 3-4 July 2008, to Sweden, to take part in a study tour with SITA UK, visiting various waste collection and recycling and waste management facilities. Flights and an overnight stay in Helsingborg were paid for by SITA UK. (Registered 8 July 2008) Overseas visits 80ef1083 2009-10-14 Hilary Armstrong uk.org.publicwhip/member/1557 Hilary Armstrong uk.org.publicwhip/person/10014 0 2009-10-14-80ef1083-10014-0
b995c08b3520bc205003837fe1e21a77edd6e9e0 4-20 September 2008, to Tanzania, on a placement for VSO (Voluntary Service Overseas), working with an educational network, TENMET. My standard class flights and accommodation in Dar es Salaam were paid for by VSO. (Registered 17 November 2008) Overseas visits 80ef1083 2009-10-14 Hilary Armstrong uk.org.publicwhip/member/1557 Hilary Armstrong uk.org.publicwhip/person/10014 1 2009-10-14-80ef1083-10014-0
a17c545b6c5783a016778ecc9aab5abf546213f0 1-5 October 2008, to Chicago, USA, to give a lecture on Social Exclusion at the Adler School of Professional Psychology. My club class flights and accommodation in Chicago were paid for by the Adler School. (Registered 17 November 2008) Overseas visits 80ef1083 2009-10-14 Hilary Armstrong uk.org.publicwhip/member/1557 Hilary Armstrong uk.org.publicwhip/person/10014 2 2009-10-14-80ef1083-10014-0
505607fb8d26b79187719579fb5dd02344f75a5d 10-14 November 2008, to Nairobi for a board meeting for VSO. My standard class flights and accommodation in Nairobi were paid for by VSO. (Registered 17 November 2008) Overseas visits 80ef1083 2009-10-14 Hilary Armstrong uk.org.publicwhip/member/1557 Hilary Armstrong uk.org.publicwhip/person/10014 3 2009-10-14-80ef1083-10014-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");