items

Table actions

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

4 rows where member_id = "uk.org.publicwhip/member/1119" sorted by date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: item, category_id, date (date)

hash item category_id date ▲ member_id person_id sort_order record_id
68f032a625a261875b44815c8e5d2097a8249927 12-17 February 2003, to Kamakura, Japan to attend a conference, funded by the UK-Japan 21st Century Group. The Group provided accommodation in business hotels, a business class return flight to Tokyo and daily subsistence. (Registered 7 March 2003) Overseas visits 80ef1083 2004-01-31 Michael Moore uk.org.publicwhip/member/1119 Michael Moore uk.org.publicwhip/person/10439 0 2004-01-31-80ef1083-10439-0
041c8ca66765ddd495e22ad232f1929bb745cdea 12-17 February 2003, to Kamakura, Japan to attend a conference, funded by the UK-Japan 21st Century Group. The Group provided accommodation in business hotels, a business class return flight to Tokyo and daily subsistence. (Registered 7 March 2003) Overseas visits 80ef1083 2003-12-04 Michael Moore uk.org.publicwhip/member/1119 Michael Moore uk.org.publicwhip/person/10439 0 2003-12-04-80ef1083-10439-0
76aefcc00d7f0e88aff8ab3649a0a67938802ca0 4 August-1 September 2002, to Buenos Aires, Detroit and Shanghai, funded by the Norfolk Charitable Trust. The Trust provided accommodation and subsistence at a briefing weekend in Norfolk (13-14 July 2002), economy class flights to the cities, accommodation in business hotels in each city and a daily subsistence allowance. (Registered 2 September 2002) Overseas visits 80ef1083 2002-11-26 Michael Moore uk.org.publicwhip/member/1119 Michael Moore uk.org.publicwhip/person/10439 0 2002-11-26-80ef1083-10439-0
13f83e25196fd547006c620c2fab4e5a5c98c324 Governor of the Westminister Foundation for Democracy for three year term beginning 31 January 2002 (unremunerated) Miscellaneous and unremunerated interests 265f2269 2002-05-14 Michael Moore uk.org.publicwhip/member/1119 Michael Moore uk.org.publicwhip/person/10439 0 2002-05-14-265f2269-10439-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");