items

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

16 rows where person_id = "uk.org.publicwhip/person/11059" 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
898d6b8eb63f5171f521f5d9988e6cb6097298da 24-26 August 2004, to Stavanger, Norway to visit Offshore Northern (ONS) conference and exhibition, with the British Offshore Oil and Gas All-Party Parliamentary Group. Flights, accommodation, transport and hospitality sponsored by UK Offshore Operators Association (UKOOA), Statoil and Chevron Texaco. (Registered 22 November 2004) Gifts, benefits and hospitality (UK) 84642823 2005-04-11 Iain Luke uk.org.publicwhip/member/1059 Iain Luke uk.org.publicwhip/person/11059 0 2005-04-11-84642823-11059-0
06226e718040554b31539897e6101ce60030b9da 24-26 August 2004, to Stavanger, Norway to visit Offshore Northern (ONS) conference and exhibition, with the British Offshore Oil and Gas All-Party Parliamentary Group. Flights, accommodation, transport and hospitality sponsored by UK Offshore Operators Association (UKOOA), Statoil and Chevron Texaco. (Registered 22 November 2004) Gifts, benefits and hospitality (UK) 84642823 2005-01-28 Iain Luke uk.org.publicwhip/member/1059 Iain Luke uk.org.publicwhip/person/11059 0 2005-01-28-84642823-11059-0
bef3230a53a1525f242646d6737c2f20ff994523 24-26 August 2004, to Stavanger, Norway to visit Offshore Northern (ONS) conference and exhibition, with the British Offshore Oil and Gas All-Party Parliamentary Group. Flights, accommodation, transport and hospitality sponsored by UK Offshore Operators Association (UKOOA), Statoil and Chevron Texaco. (Registered 22 November 2004) Gifts, benefits and hospitality (UK) 84642823 2004-12-03 Iain Luke uk.org.publicwhip/member/1059 Iain Luke uk.org.publicwhip/person/11059 0 2004-12-03-84642823-11059-0
0eda5c15f7ddf706056dae84a7dff186e3f2a3b4 10 August 2003, as a member of the All-Party Parliamentary Football Group I took part in a Four Nations Football tournament in Cardiff. The tournament was sponsored by McDonalds Restaurant, who provided accommodation, hospitality and tickets to the Community Shield Football game. (Registered 22 September 2003) Gifts, benefits and hospitality (UK) 84642823 2004-10-22 Iain Luke uk.org.publicwhip/member/1059 Iain Luke uk.org.publicwhip/person/11059 0 2004-10-22-84642823-11059-0
d1548b401060b9bb7f20233c1eb3012cfe75afee 2-3 September 2003, as a member of the All-Party Rail Group I was accompained by my wife on the group's visit to Doncaster, Immingham, York, and Whitby, sponsored by EWS Railways, GNER, Jarvis plc, Arriva and the North Yorkshire Moors Railway, who provided transport, accommodation and hospitality. (Registered 22 September 2003) Gifts, benefits and hospitality (UK) 84642823 2004-10-22 Iain Luke uk.org.publicwhip/member/1059 Iain Luke uk.org.publicwhip/person/11059 1 2004-10-22-84642823-11059-0
8bad37455f06f9dbc641f02d31f1d2e5e8ebc80e 10 August 2003, as a member of the All-Party Parliamentary Football Group I took part in a Four Nations Football tournament in Cardiff. The tournament was sponsored by McDonalds Restaurant, who provided accommodation, hospitality and tickets to the Community Shield Football game. (Registered 22 September 2003) Gifts, benefits and hospitality (UK) 84642823 2004-09-08 Iain Luke uk.org.publicwhip/member/1059 Iain Luke uk.org.publicwhip/person/11059 0 2004-09-08-84642823-11059-0
a1cac81519293f0a863b8697028fa8337132d5e3 2-3 September 2003, as a member of the All-Party Rail Group I was accompained by my wife on the group's visit to Doncaster, Immingham, York, and Whitby, sponsored by EWS Railways, GNER, Jarvis plc, Arriva and the North Yorkshire Moors Railway, who provided transport, accommodation and hospitality. (Registered 22 September 2003) Gifts, benefits and hospitality (UK) 84642823 2004-09-08 Iain Luke uk.org.publicwhip/member/1059 Iain Luke uk.org.publicwhip/person/11059 1 2004-09-08-84642823-11059-0
5a2c2be5ac642716fc60d09ce1459d4fc6100394 10 August 2003, as a member of the All-Party Parliamentary Football Group I took part in a Four Nations Football tournament in Cardiff. The tournament was sponsored by McDonalds Restaurant, who provided accommodation, hospitality and tickets to the Community Shield Football game. (Registered 22 September 2003) Gifts, benefits and hospitality (UK) 84642823 2004-07-16 Iain Luke uk.org.publicwhip/member/1059 Iain Luke uk.org.publicwhip/person/11059 0 2004-07-16-84642823-11059-0
6e7e3f904e1412f0c12929759388e01413dd97d9 2-3 September 2003, as a member of the All-Party Rail Group I was accompained by my wife on the group's visit to Doncaster, Immingham, York, and Whitby, sponsored by EWS Railways, GNER, Jarvis plc, Arriva and the North Yorkshire Moors Railway, who provided transport, accommodation and hospitality. (Registered 22 September 2003) Gifts, benefits and hospitality (UK) 84642823 2004-07-16 Iain Luke uk.org.publicwhip/member/1059 Iain Luke uk.org.publicwhip/person/11059 1 2004-07-16-84642823-11059-0
c3656718480e79830ee2b3c047c7aed48939a85e 10 August 2003, as a member of the All-Party Parliamentary Football Group I took part in a Four Nations Football tournament in Cardiff. The tournament was sponsored by McDonalds Restaurant, who provided accommodation, hospitality and tickets to the Community Shield Football game. (Registered 22 September 2003) Gifts, benefits and hospitality (UK) 84642823 2004-05-21 Iain Luke uk.org.publicwhip/member/1059 Iain Luke uk.org.publicwhip/person/11059 0 2004-05-21-84642823-11059-0
a408e617c5f44e714fcfc46b21ae8dcb06e147fb 2-3 September 2003, as a member of the All-Party Rail Group I was accompained by my wife on the group's visit to Doncaster, Immingham, York, and Whitby, sponsored by EWS Railways, GNER, Jarvis plc, Arriva and the North Yorkshire Moors Railway, who provided transport, accommodation and hospitality. (Registered 22 September 2003) Gifts, benefits and hospitality (UK) 84642823 2004-05-21 Iain Luke uk.org.publicwhip/member/1059 Iain Luke uk.org.publicwhip/person/11059 1 2004-05-21-84642823-11059-0
f8837c11bda661c612ec261ea38f60f425e9c6a9 10 August 2003, as a member of the All-Party Parliamentary Football Group I took part in a Four Nations Football tournament in Cardiff. The tournament was sponsored by McDonalds Restaurant, who provided accommodation, hospitality and tickets to the Community Shield Football game. (Registered 22 September 2003) Gifts, benefits and hospitality (UK) 84642823 2004-01-31 Iain Luke uk.org.publicwhip/member/1059 Iain Luke uk.org.publicwhip/person/11059 0 2004-01-31-84642823-11059-0
fc33894f681f9421a7edfcf9f8660fe5b616cd9c 2-3 September 2003, as a member of the All-Party Rail Group I was accompained by my wife on the group's visit to Doncaster, Immingham, York, and Whitby, sponsored by EWS Railways, GNER, Jarvis plc, Arriva and the North Yorkshire Moors Railway, who provided transport, accommodation and hospitality. (Registered 22 September 2003) Gifts, benefits and hospitality (UK) 84642823 2004-01-31 Iain Luke uk.org.publicwhip/member/1059 Iain Luke uk.org.publicwhip/person/11059 1 2004-01-31-84642823-11059-0
dc84d317be6212c018ea2822dea9bc55f5e16e32 10 August 2003, as a member of the All-Party Parliamentary Football Group I took part in a Four Nations Football tournament in Cardiff. The tournament was sponsored by McDonalds Restaurant, who provided accommodation, hospitality and tickets to the Community Shield Football game. (Registered 22 September 2003) Gifts, benefits and hospitality (UK) 84642823 2003-12-04 Iain Luke uk.org.publicwhip/member/1059 Iain Luke uk.org.publicwhip/person/11059 0 2003-12-04-84642823-11059-0
72cfec29e0d4e4b6874fa64f7044e2b149cea276 2-3 September 2003, as a member of the All-Party Rail Group I was accompained by my wife on the group's visit to Doncaster, Immingham, York, and Whitby, sponsored by EWS Railways, GNER, Jarvis plc, Arriva and the North Yorkshire Moors Railway, who provided transport, accommodation and hospitality. (Registered 22 September 2003) Gifts, benefits and hospitality (UK) 84642823 2003-12-04 Iain Luke uk.org.publicwhip/member/1059 Iain Luke uk.org.publicwhip/person/11059 1 2003-12-04-84642823-11059-0
be4394a7174f4539b3ae24a37d3d8a9890614a53 Part-owner of a residential property in Dundee. Land and Property 4f1e6359 2002-05-14 Iain Luke uk.org.publicwhip/member/1059 Iain Luke uk.org.publicwhip/person/11059 0 2002-05-14-4f1e6359-11059-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 26.036ms · Data source: mySociety Data · About: simonw/register-of-members-interests