home / regmem

Menu
  • GraphQL API

items

Table actions
  • GraphQL API for items

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

25 rows where member_id = "uk.org.publicwhip/member/1086" sorted by date descending

✎ View and edit SQL

This data as json, CSV (advanced)

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
04e20d1391b9f6ea862f34c45b8a3a5bc31916c0 9-12 March 2005, to Cape Canaveral to attend launch of Inmarsat 4F1 satellite in my capacity as Chairman of the Parliamentary Space Committee, sponsored by EADS Astrium. (Registered 23 March 2005) Overseas visits 80ef1083 2005-04-11 John McWilliam uk.org.publicwhip/member/1086 John McWilliam uk.org.publicwhip/person/10404 0 2005-04-11-80ef1083-10404-0
686fcc3ae6b1dfa0785218263db2ff6edbb007bc 9-12 March 2005, to Cape Canaveral in my capacity as Chairman of the Parliamentary Space Committee for launch of Inmarsat 4F1 satellite. Travel and three nights's accommodation sponsored by EADS Astrium. (Registered 23 March 2005) Overseas visits 80ef1083 2005-04-11 John McWilliam uk.org.publicwhip/member/1086 John McWilliam uk.org.publicwhip/person/10404 1 2005-04-11-80ef1083-10404-0
de92729edc77cddba90b921d31946839d67e615b 9-13 February 2004, to Azerbajan to look at security and refugee problems. Transport to Baku and four nights' accommodation provided by the Azerbajan Government. (Registered 24 March 2004) Overseas visits 80ef1083 2005-01-28 John McWilliam uk.org.publicwhip/member/1086 John McWilliam uk.org.publicwhip/person/10404 0 2005-01-28-80ef1083-10404-0
f12fa80980d03f68ed5ce4fbb018dbe2c55ac818 23-24 February 2004, to French Guiana on the occasion of the Rosetta Satellite launch, in my capacity as Chairman of the UK Parliamentary Space Committee. Transport to Cayenne and three nights' accommodation provided by Arianespace. (Registered 24 March 2004) Overseas visits 80ef1083 2005-01-28 John McWilliam uk.org.publicwhip/member/1086 John McWilliam uk.org.publicwhip/person/10404 1 2005-01-28-80ef1083-10404-0
bcc5f8547f7aef63ce228ddec1f628e1bc73951c 9-13 February 2004, to Azerbajan to look at security and refugee problems. Transport to Baku and four nights' accommodation provided by the Azerbajan Government. (Registered 24 March 2004) Overseas visits 80ef1083 2004-12-03 John McWilliam uk.org.publicwhip/member/1086 John McWilliam uk.org.publicwhip/person/10404 0 2004-12-03-80ef1083-10404-0
f15537b7ac43e5ff862c4bd93c60013c1509db17 23-24 February 2004, to French Guiana on the occasion of the Rosetta Satellite launch, in my capacity as Chairman of the UK Parliamentary Space Committee. Transport to Cayenne and three nights' accommodation provided by Arianespace. (Registered 24 March 2004) Overseas visits 80ef1083 2004-12-03 John McWilliam uk.org.publicwhip/member/1086 John McWilliam uk.org.publicwhip/person/10404 1 2004-12-03-80ef1083-10404-0
d42e087ac212b47bc599b38385c8f90264c6935c 9-13 February 2004, to Azerbajan to look at security and refugee problems. Transport to Baku and four nights' accommodation provided by the Azerbajan Government. (Registered 24 March 2004) Overseas visits 80ef1083 2004-10-22 John McWilliam uk.org.publicwhip/member/1086 John McWilliam uk.org.publicwhip/person/10404 0 2004-10-22-80ef1083-10404-0
212f654d6fe90d21a54da650a4be01da39655fd2 23-24 February 2004, to French Guiana on the occasion of the Rosetta Satellite launch, in my capacity as Chairman of the UK Parliamentary Space Committee. Transport to Cayenne and three nights' accommodation provided by Arianespace. (Registered 24 March 2004) Overseas visits 80ef1083 2004-10-22 John McWilliam uk.org.publicwhip/member/1086 John McWilliam uk.org.publicwhip/person/10404 1 2004-10-22-80ef1083-10404-0
43cc58fd9c564ab0d5701688cbe1d837505e2abe 9-13 February 2004, to Azerbajan to look at security and refugee problems. Transport to Baku and four nights' accommodation provided by the Azerbajan Government. (Registered 24 March 2004) Overseas visits 80ef1083 2004-09-08 John McWilliam uk.org.publicwhip/member/1086 John McWilliam uk.org.publicwhip/person/10404 0 2004-09-08-80ef1083-10404-0
6786e7c73695dea82d86f65fdf8bcab6a4be3417 23-24 February 2004, to French Guiana on the occasion of the Rosetta Satellite launch, in my capacity as Chairman of the UK Parliamentary Space Committee. Transport to Cayenne and three nights' accommodation provided by Arianespace. (Registered 24 March 2004) Overseas visits 80ef1083 2004-09-08 John McWilliam uk.org.publicwhip/member/1086 John McWilliam uk.org.publicwhip/person/10404 1 2004-09-08-80ef1083-10404-0
00f06d8479fd1200655d1416f51dac7c09802d27 17-18 June 2003, to Paris Air Show at Le Bourget with the Parliamentary Space Committee (an Associate Parliamentary Group). Travel and one night's accommodation provided by UK Industrial Space Committee, hospitality provided by EADS/Astrium. (Registered 19 July 2003) Overseas visits 80ef1083 2004-07-16 John McWilliam uk.org.publicwhip/member/1086 John McWilliam uk.org.publicwhip/person/10404 0 2004-07-16-80ef1083-10404-0
b0d81328bfed724461514c2845b39006a2fd6402 9-13 February 2004, to Azerbajan to look at security and refugee problems. Transport to Baku and four nights' accommodation provided by the Azerbajan Government. (Registered 24 March 2004) Overseas visits 80ef1083 2004-07-16 John McWilliam uk.org.publicwhip/member/1086 John McWilliam uk.org.publicwhip/person/10404 1 2004-07-16-80ef1083-10404-0
3f60e15a6292bd01e37670339874037de4055215 23-24 February 2004, to French Guiana on the occasion of the Rosetta Satellite launch, in my capacity as Chairman of the UK Parliamentary Space Committee. Transport to Cayenne and three nights' accommodation provided by Arianespace. (Registered 24 March 2004) Overseas visits 80ef1083 2004-07-16 John McWilliam uk.org.publicwhip/member/1086 John McWilliam uk.org.publicwhip/person/10404 2 2004-07-16-80ef1083-10404-0
029b628ff57dab84fa33122446fbcb92b5ee5fb6 17-18 June 2003, to Paris Air Show at Le Bourget with the Parliamentary Space Committee (an Associate Parliamentary Group). Travel and one night's accommodation provided by UK Industrial Space Committee, hospitality provided by EADS/Astrium. (Registered 19 July 2003) Overseas visits 80ef1083 2004-05-21 John McWilliam uk.org.publicwhip/member/1086 John McWilliam uk.org.publicwhip/person/10404 0 2004-05-21-80ef1083-10404-0
e2fb288f4d1c0d4ca03812541893aae11e47c32e 9-13 February 2004, to Azerbajan to look at security and refugee problems. Transport to Baku and four nights' accommodation provided by the Azerbajan Government. (Registered 24 March 2004) Overseas visits 80ef1083 2004-05-21 John McWilliam uk.org.publicwhip/member/1086 John McWilliam uk.org.publicwhip/person/10404 1 2004-05-21-80ef1083-10404-0
58fa3456d3b4103db3eec0a93e7926792365052a 23-24 February 2004, to French Guiana on the occasion of the Rosetta Satellite launch, in my capacity as Chairman of the UK Parliamentary Space Committee. Transport to Cayenne and three nights' accommodation provided by Arianespace. (Registered 24 March 2004) Overseas visits 80ef1083 2004-05-21 John McWilliam uk.org.publicwhip/member/1086 John McWilliam uk.org.publicwhip/person/10404 2 2004-05-21-80ef1083-10404-0
eceb2094feb51ff250a540d68da62de028d4ca80 17-18 June 2003, to Paris Air Show at Le Bourget with the Parliamentary Space Committee (an Associate Parliamentary Group). Travel and one night's accommodation provided by UK Industrial Space Committee, hospitality provided by EADS/Astrium. (Registered 19 July 2003) Overseas visits 80ef1083 2004-01-31 John McWilliam uk.org.publicwhip/member/1086 John McWilliam uk.org.publicwhip/person/10404 0 2004-01-31-80ef1083-10404-0
28e01a544e61174c69247229dc4503fa6f547813 October 2002, to Azerbaijan. Travel and three nights' accommodation paid for by the Azerbaijan Government. (Registered 22 November 2002) Overseas visits 80ef1083 2003-12-04 John McWilliam uk.org.publicwhip/member/1086 John McWilliam uk.org.publicwhip/person/10404 0 2003-12-04-80ef1083-10404-0
652d3c870957b005b169ba9ee860531808f91183 17-18 June 2003, to Paris Air Show at Le Bourget with the Parliamentary Space Committee (an Associate Parliamentary Group). Travel and one night's accommodation provided by UK Industrial Space Committee, hospitality provided by EADS/Astrium. (Registered 19 July 2003) Overseas visits 80ef1083 2003-12-04 John McWilliam uk.org.publicwhip/member/1086 John McWilliam uk.org.publicwhip/person/10404 1 2003-12-04-80ef1083-10404-0
8a4e8846bdd22d666bea39e5e47181e38764c03d October 2002, to Azerbaijan. Travel and three nights' accommodation paid for by the Azerbaijan Government. (Registered 22 November 2002) Overseas visits 80ef1083 2002-11-26 John McWilliam uk.org.publicwhip/member/1086 John McWilliam uk.org.publicwhip/person/10404 0 2002-11-26-80ef1083-10404-0
e9ff76e4c58cf00b614481be023d4926aca620c2 Member of Political Opinion Panel of BPRI (Business Planning and Research International). (£1-£1,000) Remunerated employment, office, profession etc 1f359ece 2002-05-14 John McWilliam uk.org.publicwhip/member/1086 John McWilliam uk.org.publicwhip/person/10404 0 2002-05-14-1f359ece-10404-0
744e68a4a0edaf1785e033d7c0ed61a27d70e11b Member of Harris Parliamentary Panel. (£1-£1,000) Remunerated employment, office, profession etc 1f359ece 2002-05-14 John McWilliam uk.org.publicwhip/member/1086 John McWilliam uk.org.publicwhip/person/10404 1 2002-05-14-1f359ece-10404-0
24a1e664820f49456ea127a93c1ffcf3ce62eeb5 5-9 May 2000, to Italy, to attend European Parliamentary Space Committee Conference. Travel and accommodation paid for by United Kingdom Industrial Space Committee. (Registered 25 October 2001) Overseas visits 80ef1083 2002-05-14 John McWilliam uk.org.publicwhip/member/1086 John McWilliam uk.org.publicwhip/person/10404 0 2002-05-14-80ef1083-10404-0
3901bee6bcbe771728bd1d3e625faf13d448a3de 14-18 September 2001, to Belgium, to attend European Parliamentary Space Committee Conference. Travel and accommodation paid for by Astrium PLC. (Registered 25 October 2001) Overseas visits 80ef1083 2002-05-14 John McWilliam uk.org.publicwhip/member/1086 John McWilliam uk.org.publicwhip/person/10404 1 2002-05-14-80ef1083-10404-0
ce02f51b7604328dd8e10cbe407a9aa991acfcb2 Director (unpaid) of EURIM; non-profit making company concerned with information technology in Europe for MPs. Miscellaneous and unremunerated interests 265f2269 2002-05-14 John McWilliam uk.org.publicwhip/member/1086 John McWilliam uk.org.publicwhip/person/10404 0 2002-05-14-265f2269-10404-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 · Queries took 58.282ms · Data source: mySociety Data · About: simonw/register-of-members-interests-datasette