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

47 rows where member_id = "uk.org.publicwhip/member/1009" 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
210c64f470a26c0c6f4fc62426cabc02ea002706 In 2001-2002 I received fees for journalism from the following: Remunerated employment, office, profession etc 1f359ece 2005-04-11 Gerald Kaufman uk.org.publicwhip/member/1009 Gerald Kaufman uk.org.publicwhip/person/10327 0 2005-04-11-1f359ece-10327-0
19e25beebfa8db9724f0f607019270d2686f30e6 The Scotsman, News International, Telegraph Group. Remunerated employment, office, profession etc 1f359ece 2005-04-11 Gerald Kaufman uk.org.publicwhip/member/1009 Gerald Kaufman uk.org.publicwhip/person/10327 1 2005-04-11-1f359ece-10327-0
d4ab4801ee2c9fcf9577944be76a5303a2acc7e4 BBC (Up to £5,000) , Daily Mail (Up to £5,000) , Builder Group (Up to £5,000) , Mail on Sunday (Up to £5,000) , Evening Standard (Up to £5,000) . Remunerated employment, office, profession etc 1f359ece 2005-04-11 Gerald Kaufman uk.org.publicwhip/member/1009 Gerald Kaufman uk.org.publicwhip/person/10327 2 2005-04-11-1f359ece-10327-0
fccd6d2878f79f73a3dafdfa48ae2ac4f20acaff 7-10 May 2004, to Kuwait with the All Party Kuwait Group. Transport and accommodation provided by the Kuwait Information Centre. (Registered 11 May 2004) Overseas visits 80ef1083 2005-04-11 Gerald Kaufman uk.org.publicwhip/member/1009 Gerald Kaufman uk.org.publicwhip/person/10327 0 2005-04-11-80ef1083-10327-0
2031b08d0c0000263c2fe8b4eb2a5b511caef1f7 28-30 January 2005, to Paris to take part in a seminar. Rail fare and accommodation provided by European Study Tours. (Registered 8 February 2005) Overseas visits 80ef1083 2005-04-11 Gerald Kaufman uk.org.publicwhip/member/1009 Gerald Kaufman uk.org.publicwhip/person/10327 1 2005-04-11-80ef1083-10327-0
98dda17b17f98b09a656c901bd8d4db27a973765 In 2001-2002 I received fees for journalism from the following: Remunerated employment, office, profession etc.. 12405e8c 2005-01-28 Gerald Kaufman uk.org.publicwhip/member/1009 Gerald Kaufman uk.org.publicwhip/person/10327 0 2005-01-28-12405e8c-10327-0
da5dd766e91845e5987275bcfa9256b2447b6c2b The Scotsman, News International, Telegraph Group. Remunerated employment, office, profession etc.. 12405e8c 2005-01-28 Gerald Kaufman uk.org.publicwhip/member/1009 Gerald Kaufman uk.org.publicwhip/person/10327 1 2005-01-28-12405e8c-10327-0
f59e662ad1bad97c0b900495a50bbc2cfa4ff99c BBC (Up to £5,000), Daily Mail (Up to £5,000), Builder Group (Up to £5,000), Mail on Sunday (Up to £5,000), Evening Standard (Up to £5,000). Remunerated employment, office, profession etc.. 12405e8c 2005-01-28 Gerald Kaufman uk.org.publicwhip/member/1009 Gerald Kaufman uk.org.publicwhip/person/10327 2 2005-01-28-12405e8c-10327-0
2859ac671a4c3b2ee5a0dc931ffede09a1c06607 7-10 May 2004, to Kuwait with the All Party Kuwait Group. Transport and accommodation provided by the Kuwait Information Centre. (Registered 11 May 2004) Overseas visits 80ef1083 2005-01-28 Gerald Kaufman uk.org.publicwhip/member/1009 Gerald Kaufman uk.org.publicwhip/person/10327 0 2005-01-28-80ef1083-10327-0
06f829f28c3f5c1014c5792e0a9deb7093c1100b In 2001-2002 I received fees for journalism from the following: Remunerated employment, office, profession etc 1f359ece 2004-12-03 Gerald Kaufman uk.org.publicwhip/member/1009 Gerald Kaufman uk.org.publicwhip/person/10327 0 2004-12-03-1f359ece-10327-0
feb1037fd240940387e2f676ad4b67c683f90cd9 The Scotsman, News International, Telegraph Group. Remunerated employment, office, profession etc 1f359ece 2004-12-03 Gerald Kaufman uk.org.publicwhip/member/1009 Gerald Kaufman uk.org.publicwhip/person/10327 1 2004-12-03-1f359ece-10327-0
dd07f5a08d63db69ff918190ee8fe856d55b1282 BBC (Up to £5,000), Daily Mail (Up to £5,000), Builder Group (Up to £5,000), Mail on Sunday (Up to £5,000), Evening Standard (Up to £5,000). Remunerated employment, office, profession etc 1f359ece 2004-12-03 Gerald Kaufman uk.org.publicwhip/member/1009 Gerald Kaufman uk.org.publicwhip/person/10327 2 2004-12-03-1f359ece-10327-0
d5c76c4193c6add1f621b39f39d47ee7e8e7d20b 7-10 May 2004, to Kuwait with the All Party Kuwait Group. Transport and accommodation provided by the Kuwait Information Centre. (Registered 11 May 2004) Overseas visits 80ef1083 2004-12-03 Gerald Kaufman uk.org.publicwhip/member/1009 Gerald Kaufman uk.org.publicwhip/person/10327 0 2004-12-03-80ef1083-10327-0
24f98ec3ccdfcf71b48e07401aeb02243be385b2 In 2001-2002 I received fees for journalism from the following: Remunerated employment, office, profession etc 1f359ece 2004-10-22 Gerald Kaufman uk.org.publicwhip/member/1009 Gerald Kaufman uk.org.publicwhip/person/10327 0 2004-10-22-1f359ece-10327-0
c9bdcbf4c6a21d523a66f1fa33e91b7e5c395f1a The Scotsman, News International, Telegraph Group. Remunerated employment, office, profession etc 1f359ece 2004-10-22 Gerald Kaufman uk.org.publicwhip/member/1009 Gerald Kaufman uk.org.publicwhip/person/10327 1 2004-10-22-1f359ece-10327-0
4a8ce033b59355a3f94bfb9817c5a7c698859472 BBC (Up to £5,000) , Daily Mail (Up to £5,000) , Builder Group (Up to £5,000) , Mail on Sunday (Up to £5,000) , Evening Standard (Up to £5,000) . Remunerated employment, office, profession etc 1f359ece 2004-10-22 Gerald Kaufman uk.org.publicwhip/member/1009 Gerald Kaufman uk.org.publicwhip/person/10327 2 2004-10-22-1f359ece-10327-0
e2f025893bdcbf6c418d5eadd290c6cba6577c47 7-10 May 2004, to Kuwait with the All Party Kuwait Group. Transport and accommodation provided by the Kuwait Information Centre. (Registered 11 May 2004) Overseas visits 80ef1083 2004-10-22 Gerald Kaufman uk.org.publicwhip/member/1009 Gerald Kaufman uk.org.publicwhip/person/10327 0 2004-10-22-80ef1083-10327-0
1e0ec7ca82e3b6c0c64d0c26cebf6256785cd2d7 In 2001-2002 I received fees for journalism from the following: Remunerated employment, office, profession etc 1f359ece 2004-09-08 Gerald Kaufman uk.org.publicwhip/member/1009 Gerald Kaufman uk.org.publicwhip/person/10327 0 2004-09-08-1f359ece-10327-0
31f31a22578d9537a4ae22514924de8e5f40e54b The Scotsman, News International, Telegraph Group. Remunerated employment, office, profession etc 1f359ece 2004-09-08 Gerald Kaufman uk.org.publicwhip/member/1009 Gerald Kaufman uk.org.publicwhip/person/10327 1 2004-09-08-1f359ece-10327-0
530327df550e23f3269afdb9d89a0e49dae889f3 BBC (Up to £5,000) , Daily Mail (Up to £5,000) , Builder Group (Up to £5,000) , Mail on Sunday (Up to £5,000) , Evening Standard (Up to £5,000) . Remunerated employment, office, profession etc 1f359ece 2004-09-08 Gerald Kaufman uk.org.publicwhip/member/1009 Gerald Kaufman uk.org.publicwhip/person/10327 2 2004-09-08-1f359ece-10327-0
fa1ce00903620c1ea7119891661c71497768e6e8 7-10 May 2004, to Kuwait with the All Party Kuwait Group. Transport and accommodation provided by the Kuwait Information Centre. (Registered 11 May 2004) Overseas visits 80ef1083 2004-09-08 Gerald Kaufman uk.org.publicwhip/member/1009 Gerald Kaufman uk.org.publicwhip/person/10327 0 2004-09-08-80ef1083-10327-0
3aa8716651882363507430949da460bd337b5465 In 2001-2002 I received fees for journalism from the following: Remunerated employment, office, profession etc 1f359ece 2004-07-16 Gerald Kaufman uk.org.publicwhip/member/1009 Gerald Kaufman uk.org.publicwhip/person/10327 0 2004-07-16-1f359ece-10327-0
d3a3cfb8697aff16dac6528aedde463dd20a02f1 The Scotsman, News International, Telegraph Group. Remunerated employment, office, profession etc 1f359ece 2004-07-16 Gerald Kaufman uk.org.publicwhip/member/1009 Gerald Kaufman uk.org.publicwhip/person/10327 1 2004-07-16-1f359ece-10327-0
7d5cd771b02b2554de469cddc293edea5e19e610 BBC (Up to £5,000) , Daily Mail (Up to £5,000) , Builder Group (Up to £5,000) , Mail on Sunday (Up to £5,000) , Evening Standard (Up to £5,000) . Remunerated employment, office, profession etc 1f359ece 2004-07-16 Gerald Kaufman uk.org.publicwhip/member/1009 Gerald Kaufman uk.org.publicwhip/person/10327 2 2004-07-16-1f359ece-10327-0
dac1635e1b2161a1215f5637e1645f1b6f7dada6 17-22 August 2003, to Pakistan and Kashmir. Flights provided by Justice for Jammu and Kashmir (non-profit organisation). (Registered 2 September 2003) Overseas visits 80ef1083 2004-07-16 Gerald Kaufman uk.org.publicwhip/member/1009 Gerald Kaufman uk.org.publicwhip/person/10327 0 2004-07-16-80ef1083-10327-0
6209bf67fa5a634b0c02fd42db00ae534f8bcdc4 7-10 May 2004, to Kuwait with the All Party Kuwait Group. Transport and accommodation provided by the Kuwait Information Centre. (Registered 11 May 2004) Overseas visits 80ef1083 2004-07-16 Gerald Kaufman uk.org.publicwhip/member/1009 Gerald Kaufman uk.org.publicwhip/person/10327 1 2004-07-16-80ef1083-10327-0
a791de102aa052af78b3522f75f1cc5d302e232e In 2001-2002 I received fees for journalism from the following: Remunerated employment, office, profession etc 1f359ece 2004-05-21 Gerald Kaufman uk.org.publicwhip/member/1009 Gerald Kaufman uk.org.publicwhip/person/10327 0 2004-05-21-1f359ece-10327-0
d015c352f62792546f4e237fa3bf9467cfa66c71 The Scotsman, News International, Telegraph Group. Remunerated employment, office, profession etc 1f359ece 2004-05-21 Gerald Kaufman uk.org.publicwhip/member/1009 Gerald Kaufman uk.org.publicwhip/person/10327 1 2004-05-21-1f359ece-10327-0
d3df641950fcfb604f66dc3af7341aa6be1d12dd BBC (Up to £5,000) , Daily Mail (Up to £5,000) , Builder Group (Up to £5,000) , Mail on Sunday (Up to £5,000) , Evening Standard (Up to £5,000) . Remunerated employment, office, profession etc 1f359ece 2004-05-21 Gerald Kaufman uk.org.publicwhip/member/1009 Gerald Kaufman uk.org.publicwhip/person/10327 2 2004-05-21-1f359ece-10327-0
b38d98f841756a999264d8da9365f2e167c7daca 17-22 August 2003, to Pakistan and Kashmir. Flights provided by Justice for Jammu and Kashmir (non-profit organisation). (Registered 2 September 2003) Overseas visits 80ef1083 2004-05-21 Gerald Kaufman uk.org.publicwhip/member/1009 Gerald Kaufman uk.org.publicwhip/person/10327 0 2004-05-21-80ef1083-10327-0
1edc56950a941af5f5cdd82841ebce97ef9b7a3c 7-10 May 2004, to Kuwait with the All Party Kuwait Group. Transport and accommodation provided by the Kuwait Information Centre. (Registered 11 May 2004) Overseas visits 80ef1083 2004-05-21 Gerald Kaufman uk.org.publicwhip/member/1009 Gerald Kaufman uk.org.publicwhip/person/10327 1 2004-05-21-80ef1083-10327-0
3ebc505064f1b6360a9a515b3a6928ba39e3fdde In 2001-2002 I received fees for journalism from the following: Remunerated employment, office, profession etc 1f359ece 2004-01-31 Gerald Kaufman uk.org.publicwhip/member/1009 Gerald Kaufman uk.org.publicwhip/person/10327 0 2004-01-31-1f359ece-10327-0
a24018875d089b668093dcc53ed263a3896918ef The Scotsman, News International, Telegraph Group. Remunerated employment, office, profession etc 1f359ece 2004-01-31 Gerald Kaufman uk.org.publicwhip/member/1009 Gerald Kaufman uk.org.publicwhip/person/10327 1 2004-01-31-1f359ece-10327-0
621fc3c6d654ffd5f7fb173d6fe454b4843469cc BBC (Up to £5,000), Daily Mail (Up to £5,000), Builder Group (Up to £5,000), Mail on Sunday (Up to £5,000), Evening Standard (Up to £5,000). Remunerated employment, office, profession etc 1f359ece 2004-01-31 Gerald Kaufman uk.org.publicwhip/member/1009 Gerald Kaufman uk.org.publicwhip/person/10327 2 2004-01-31-1f359ece-10327-0
c33d2de3fbfec8337dc4914aff767ebbe09d1845 17-22 August 2003, to Pakistan and Kashmir. Flights provided by Justice for Jammu and Kashmir (non-profit organisation). (Registered 2 September 2003) Overseas visits 80ef1083 2004-01-31 Gerald Kaufman uk.org.publicwhip/member/1009 Gerald Kaufman uk.org.publicwhip/person/10327 0 2004-01-31-80ef1083-10327-0
a15c03bd92df55e50f40377d2a6a40eeef08ae00 In 2001-2002 I received fees for journalism from the following: Remunerated employment, office, profession etc 1f359ece 2003-12-04 Gerald Kaufman uk.org.publicwhip/member/1009 Gerald Kaufman uk.org.publicwhip/person/10327 0 2003-12-04-1f359ece-10327-0
b7946330d397f94096b9a09e6bfebdc7e0584283 The Scotsman, News International, Telegraph Group. Remunerated employment, office, profession etc 1f359ece 2003-12-04 Gerald Kaufman uk.org.publicwhip/member/1009 Gerald Kaufman uk.org.publicwhip/person/10327 1 2003-12-04-1f359ece-10327-0
f1a2bef228fb3c29b568a818f49eedb289ca0261 BBC (Up to £5,000) , Daily Mail (Up to £5,000) , Builder Group (Up to £5,000) , Mail on Sunday (Up to £5,000) , Evening Standard (Up to £5,000) . Remunerated employment, office, profession etc 1f359ece 2003-12-04 Gerald Kaufman uk.org.publicwhip/member/1009 Gerald Kaufman uk.org.publicwhip/person/10327 2 2003-12-04-1f359ece-10327-0
956d03277a07bc56f3e628e244adbf797b217600 6-8 November 2002, to Gibraltar as Chairman of Referendum Observers. Travel and accommodation provided by Government of Gibraltar. (Registered 19 November 2002) Overseas visits 80ef1083 2003-12-04 Gerald Kaufman uk.org.publicwhip/member/1009 Gerald Kaufman uk.org.publicwhip/person/10327 0 2003-12-04-80ef1083-10327-0
4bd6b147f90150a0ad5750f3417e3ebb4c89ce28 17-22 August 2003, to Pakistan and Kashmir. Flights provided by Justice for Jammu and Kashmir (non-profit organisation). (Registered 2 September 2003) Overseas visits 80ef1083 2003-12-04 Gerald Kaufman uk.org.publicwhip/member/1009 Gerald Kaufman uk.org.publicwhip/person/10327 1 2003-12-04-80ef1083-10327-0
209907e00d5a6fb32bad111357ab01681190de95 In 2001-2002 I received fees for journalism from the following: Remunerated employment, office, profession etc 1f359ece 2002-11-26 Gerald Kaufman uk.org.publicwhip/member/1009 Gerald Kaufman uk.org.publicwhip/person/10327 0 2002-11-26-1f359ece-10327-0
dbe24b09302fd40561cb8ae2148ef06d7fb56f1a The Scotsman, News International, Telegraph Group. Remunerated employment, office, profession etc 1f359ece 2002-11-26 Gerald Kaufman uk.org.publicwhip/member/1009 Gerald Kaufman uk.org.publicwhip/person/10327 1 2002-11-26-1f359ece-10327-0
e3b11ea587199e67dffadfc682f310bcc52c3a8d BBC (Up to £5,000) , Daily Mail (Up to £5,000) , Builder Group (Up to £5,000) , Mail on Sunday (Up to £5,000) , Evening Standard (Up to £5,000) . Remunerated employment, office, profession etc 1f359ece 2002-11-26 Gerald Kaufman uk.org.publicwhip/member/1009 Gerald Kaufman uk.org.publicwhip/person/10327 2 2002-11-26-1f359ece-10327-0
457ded62c423c8b8b7ff93594a7882c0977845c3 30-31 March 2002, to Abu Dhabi to give a lecture on religion as a motivating factor in international conflict, for the Zayed Centre for Co-ordination and Follow-up (Government sponsored). The centre paid for my travel and accommodation. (Registered 2 April 2002) Overseas visits 80ef1083 2002-11-26 Gerald Kaufman uk.org.publicwhip/member/1009 Gerald Kaufman uk.org.publicwhip/person/10327 0 2002-11-26-80ef1083-10327-0
c87a1d69a46732cd18dc09466da081fdfe6fed9f 6-8 November 2002, to Gibraltar as Chairman of Referendum Observers. Travel and accommodation provided by Government of Gibraltar. (Registered 19 November 2002) Overseas visits 80ef1083 2002-11-26 Gerald Kaufman uk.org.publicwhip/member/1009 Gerald Kaufman uk.org.publicwhip/person/10327 1 2002-11-26-80ef1083-10327-0
f9e83d9686bfe1e668ccf338e15bd0cc3e84b927 Occasional articles for miscellaneous newspapers, and occasional broadcasts on radio and television. Remunerated employment, office, profession etc 1f359ece 2002-05-14 Gerald Kaufman uk.org.publicwhip/member/1009 Gerald Kaufman uk.org.publicwhip/person/10327 0 2002-05-14-1f359ece-10327-0
72cfc96b9a3f0d33bdb9ab0ee4b2d8690a0a0101 30-31 March 2002, to Abu Dhabi to give a lecture on religion as a motivating factor in international conflict, for the Zayed Centre for Co-ordination and Follow-up (Government sponsored). The centre paid for my travel and accommodation. (Registered 2 April 2002) Overseas visits 80ef1083 2002-05-14 Gerald Kaufman uk.org.publicwhip/member/1009 Gerald Kaufman uk.org.publicwhip/person/10327 0 2002-05-14-80ef1083-10327-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");