items

Table actions

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

3 rows where record_id = "2002-05-14-80ef1083-10462-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
12e165aebccc25d2fced9ca597bc63163690292a 2-5 August 2001, to Cyprus, to support events related to the occupation of Famagusta. Flights and three nights' accommodation paid for by the Municipality of Famagusta. (Registered 29 October 2001) Overseas visits 80ef1083 2002-05-14 Edward O'Hara uk.org.publicwhip/member/1140 Edward O'Hara uk.org.publicwhip/person/10462 0 2002-05-14-80ef1083-10462-0
82be4561923336b0df958f3a7cba56e0a11f3008 5-12 August 2001, to Greece, to receive an award, to participate in and make several public addresses to a programme of public events. Flights and seven nights' accommodation paid for by the Municipality of Salamis. (Registered 29 October 2001) Overseas visits 80ef1083 2002-05-14 Edward O'Hara uk.org.publicwhip/member/1140 Edward O'Hara uk.org.publicwhip/person/10462 1 2002-05-14-80ef1083-10462-0
dd8a4f7c78f05752133a48ff249bc612dc14e328 13-14 October 2001, to Cyprus, to address a meeting commemorating the occupation of Morphou. Flight and one night's accommodation paid for by the Municipality of Morphou. (Registered 29 October 2001) Overseas visits 80ef1083 2002-05-14 Edward O'Hara uk.org.publicwhip/member/1140 Edward O'Hara uk.org.publicwhip/person/10462 2 2002-05-14-80ef1083-10462-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");