items

Table actions

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

7 rows where record_id = "2010-03-10-80ef1083-10353-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
74ddfe6a3b73a78ae7b1816601ab039d18a8d19e Name of donor: Municipality of Morphou and the Association of Cypriot Municipalities Overseas visits 80ef1083 2010-03-10 David Lepper uk.org.publicwhip/member/1454 David Lepper uk.org.publicwhip/person/10353 0 2010-03-10-80ef1083-10353-0
4331125741f83a4fe2dec96d7db5639035a3c142 Address of donor: 16, Zynonos Sozou Street, 1075 Nicosia, Cyprus. Overseas visits 80ef1083 2010-03-10 David Lepper uk.org.publicwhip/member/1454 David Lepper uk.org.publicwhip/person/10353 1 2010-03-10-80ef1083-10353-0
a82459cc333cfd547b6af68fd0a3b8b24a00cce6 Amount of donation (or estimate of the probable value): I have been unable to ascertain the exact value but, as it includes return air fare for me to Larnaca, hotel accommodation and meals for myself and my wife and travel within Cyprus I believe that it might exceed £650. My wife paid her own return air fare. Overseas visits 80ef1083 2010-03-10 David Lepper uk.org.publicwhip/member/1454 David Lepper uk.org.publicwhip/person/10353 2 2010-03-10-80ef1083-10353-0
e5b66faeece7f04c817efc2d8b644d3756eede0f Destination of visit: Nicosia Overseas visits 80ef1083 2010-03-10 David Lepper uk.org.publicwhip/member/1454 David Lepper uk.org.publicwhip/person/10353 3 2010-03-10-80ef1083-10353-0
45633ae359d8d064f955ec654a7cbdf772890315 Date of visit: 10 - 13 October 2009 Overseas visits 80ef1083 2010-03-10 David Lepper uk.org.publicwhip/member/1454 David Lepper uk.org.publicwhip/person/10353 4 2010-03-10-80ef1083-10353-0
652288c344aaf35571827b5f6ba984985db0e5eb Purpose of visit: to attend the Morphou Rally and related political meetings Overseas visits 80ef1083 2010-03-10 David Lepper uk.org.publicwhip/member/1454 David Lepper uk.org.publicwhip/person/10353 5 2010-03-10-80ef1083-10353-0
ab5cffd08b1eee2f5ee7bef63bda8438dd74a516 (Registered 6 November 2009) Overseas visits 80ef1083 2010-03-10 David Lepper uk.org.publicwhip/member/1454 David Lepper uk.org.publicwhip/person/10353 6 2010-03-10-80ef1083-10353-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");