items

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

12 rows where member_id = "uk.org.publicwhip/member/1064" sorted by date descending

View and edit SQL

Suggested facets: item, category_id, date, sort_order, record_id, date (date)

hash item category_id date ▲ member_id person_id sort_order record_id
5b4a9ba7d79990777053b67949ac5cfabb55b1f6 14 and 15 October 2003, to Prague to attend North West European Conference. Flight and one night's accommodation paid for by the North West Regional Agency. (Registered 19 November 2003) Gifts, benefits and hospitality (UK) 84642823 2004-10-22 Ian McCartney uk.org.publicwhip/member/1064 Ian McCartney uk.org.publicwhip/person/10379 0 2004-10-22-84642823-10379-0
94da81c7a7684da239ceadd65d72d5950bafd31b 14 and 15 October 2003, to Prague to attend North West European Conference. Flight and one night's accommodation paid for by the North West Regional Agency. (Registered 19 November 2003) Gifts, benefits and hospitality (UK) 84642823 2004-09-08 Ian McCartney uk.org.publicwhip/member/1064 Ian McCartney uk.org.publicwhip/person/10379 0 2004-09-08-84642823-10379-0
67ef7c5b500bb1ebd80d37888378dd8677b8f442 14 and 15 October 2003, to Prague to attend North West European Conference. Flight and one night's accommodation paid for by the North West Regional Agency. (Registered 19 November 2003) Gifts, benefits and hospitality (UK) 84642823 2004-07-16 Ian McCartney uk.org.publicwhip/member/1064 Ian McCartney uk.org.publicwhip/person/10379 0 2004-07-16-84642823-10379-0
c45a2b153d633bc4542981fa421dcfdd3f542bb2 14 and 15 October 2003, to Prague to attend North West European Conference. Flight and one night's accommodation paid for by the North West Regional Agency. (Registered 19 November 2003) Gifts, benefits and hospitality (UK) 84642823 2004-05-21 Ian McCartney uk.org.publicwhip/member/1064 Ian McCartney uk.org.publicwhip/person/10379 0 2004-05-21-84642823-10379-0
c6baa467b6e011658eac1b201c0ebd9159c87a7c 22-25 July 2003, to Washington to meet counterparts in the Democratic Party. Cost of trip (approximately £1,100) met by Philip Gould of Philip Gould Associates. (Registered 16 July 2003) Overseas visits 80ef1083 2004-05-21 Ian McCartney uk.org.publicwhip/member/1064 Ian McCartney uk.org.publicwhip/person/10379 0 2004-05-21-80ef1083-10379-0
28e21b8fc6f9abd345e45a1a1e07db64eaeaff1e 14 and 15 October 2003, to Prague to attend North West European Conference. Flight and one night's accommodation paid for by the North West Regional Agency. (Registered 19 November 2003) Gifts, benefits and hospitality (UK) 84642823 2004-01-31 Ian McCartney uk.org.publicwhip/member/1064 Ian McCartney uk.org.publicwhip/person/10379 0 2004-01-31-84642823-10379-0
8e58377413754a934074197ed1995264c891b8fc 22-25 July 2003, to Washington to meet counterparts in the Democratic Party. Cost of trip (approximately £1,100) met by Philip Gould of Philip Gould Associates. (Registered 16 July 2003) Overseas visits 80ef1083 2004-01-31 Ian McCartney uk.org.publicwhip/member/1064 Ian McCartney uk.org.publicwhip/person/10379 0 2004-01-31-80ef1083-10379-0
6b771c27460d4c08f5e61e9039637322fa62bd48 14 and 15 October 2003, to Prague to attend North West European Conference. Flight and one night's accommodation paid for by the North West Regional Agency. (Registered 19 November 2003) Gifts, benefits and hospitality (UK) 84642823 2003-12-04 Ian McCartney uk.org.publicwhip/member/1064 Ian McCartney uk.org.publicwhip/person/10379 0 2003-12-04-84642823-10379-0
7139e0ebd8e13a20bd984af1163152ec1e327fcf 22-25 July 2003, to Washington to meet counterparts in the Democratic Party. Cost of trip (approximately £1,100) met by Philip Gould of Philip Gould Associates. (Registered 16 July 2003) Overseas visits 80ef1083 2003-12-04 Ian McCartney uk.org.publicwhip/member/1064 Ian McCartney uk.org.publicwhip/person/10379 0 2003-12-04-80ef1083-10379-0
81c74818c0b10856a43a77975ad6144c48cfff9b A contribution below the threshold for registration towards my election expenses at the 2001 General Election was received from the TGWU. (Registered 12 October 2001) Sponsorship or financial or material support 9e46def6 2002-05-14 Ian McCartney uk.org.publicwhip/member/1064 Ian McCartney uk.org.publicwhip/person/10379 0 2002-05-14-9e46def6-10379-0
6a62a8e1e4578b1467036b7eaa7609a0d15d9f98 2 December 2001, my wife and I attended the BBC North West Sports Awards in Bolton as guests of Mr. R. McLoughlin, CEO of Unique Communications Group, Manchester. (Registered 2 January 2002) Gifts, benefits and hospitality (UK) 84642823 2002-05-14 Ian McCartney uk.org.publicwhip/member/1064 Ian McCartney uk.org.publicwhip/person/10379 0 2002-05-14-84642823-10379-0
aa0440d587b60b18f8607bd1c3d6f4604e81068f 15 December 2001, my wife and I attended the British Comedy Awards in London as guests of Mr. R. McLoughlin, CEO of Unique Communications Group, Manchester. (Registered 2 January 2002) Gifts, benefits and hospitality (UK) 84642823 2002-05-14 Ian McCartney uk.org.publicwhip/member/1064 Ian McCartney uk.org.publicwhip/person/10379 1 2002-05-14-84642823-10379-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");
Powered by Datasette · Query took 21.126ms · Data source: mySociety Data · About: simonw/register-of-members-interests