items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
92 rows where "date" is on date 2013-10-14 and member_id = "uk.org.publicwhip/member/40581" sorted by date descending
This data as json, CSV (advanced)
Suggested facets: category_id, record_id, date (date)
hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
430c5e5ced05dd290d7e5ff70a1d5bf1a0245b05 | Salary as lecturer at Queen Mary, University of London, Mile End Road, London E1 4NS: | Remunerated employment, office, profession etc 1f359ece | 2013-10-14 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 0 | 2013-10-14-1f359ece-24850-0 |
9db57ba80e43d71e49d09daaf1989a5e459d2641 | 24 September 2012, received payment of £1,082.86 gross. Hours: 16 hrs. (Registered 19 October 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-10-14 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 1 | 2013-10-14-1f359ece-24850-0 |
be97369b075303040008372e2916ef5714075e35 | 24 October 2012, received payment of £1,082.86 gross. Hours: 16 hrs. (Registered 20 November 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-10-14 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 2 | 2013-10-14-1f359ece-24850-0 |
a178e354c54746023ed218bedf9f0a0b7374c2e3 | 22 November 2012, received payment of £1,082.86 gross. Hours: 16 hrs. (Registered 20 December 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-10-14 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 3 | 2013-10-14-1f359ece-24850-0 |
685e0cb9bd2b511100f360dc066bf2cb14daecc1 | 20 December 2012, received payment of £1,082.86 gross. Hours: 16 hrs. (Registered 20 December 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-10-14 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 4 | 2013-10-14-1f359ece-24850-0 |
518d68ea036d525a8a5cae4ff8c4c41eb412ac45 | 24 January 2013, received payment of £1,082.86 gross. Hours: 16 hrs. (Registered 31 January 2013) | Remunerated employment, office, profession etc 1f359ece | 2013-10-14 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 5 | 2013-10-14-1f359ece-24850-0 |
c276538ea424b5078c473396b50d415c519fc866 | 25 February 2013, received payment of £1,082.86 gross. Hours: 16 hrs. (Registered 25 March 2013) | Remunerated employment, office, profession etc 1f359ece | 2013-10-14 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 6 | 2013-10-14-1f359ece-24850-0 |
c65383c116da94df55331bd37104d0605a73a9d0 | 25 March 2013, received payment of £1,082.86 gross. Hours: 16 hrs. (Registered 25 March 2013) | Remunerated employment, office, profession etc 1f359ece | 2013-10-14 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 7 | 2013-10-14-1f359ece-24850-0 |
290c1f7601a360ef5e3abdbd400f5c50dfb7ff35 | 25 April 2013, received payment of £1,082.86 gross. Hours: 16 hrs. (Registered 13 May 2013) | Remunerated employment, office, profession etc 1f359ece | 2013-10-14 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 8 | 2013-10-14-1f359ece-24850-0 |
2eb6bc815473d90b7df8e2fa9b84b514a02fcecb | 23 May 2013, received payment of £1,082.86 gross. Hours: 16 hrs. (Registered 18 June 2013) | Remunerated employment, office, profession etc 1f359ece | 2013-10-14 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 9 | 2013-10-14-1f359ece-24850-0 |
d31eacd1992e75673a25b2ea0473e1b80831b80f | 26 June 2013, received payment of £1,082.86 gross. Hours: 16 hrs. (Registered 23 August 2013) | Remunerated employment, office, profession etc 1f359ece | 2013-10-14 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 10 | 2013-10-14-1f359ece-24850-0 |
2e6b7657d2d0c4822f6ace1d658c8cbe6fa3c468 | 24 July 2013, received payment of £1,082.86 gross. Hours: 16 hrs. (Registered 23 August 2013) | Remunerated employment, office, profession etc 1f359ece | 2013-10-14 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 11 | 2013-10-14-1f359ece-24850-0 |
6e71d3c4a508328a741219c9fee659dbe6ad7e2f | Payments for articles from Guardian News and Media Ltd, Kings Place, 90 York Way, London, N1P 2AP: | Remunerated employment, office, profession etc 1f359ece | 2013-10-14 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 12 | 2013-10-14-1f359ece-24850-0 |
629ca6e805cb4271784ddf00950293a6106666ca | 29 September 2012, received payment of £617. Hours: 1.5 hrs. (Registered 19 October 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-10-14 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 13 | 2013-10-14-1f359ece-24850-0 |
2e0ad1a6b02a4621b26fd6981c90df7f9d90da28 | 8 November 2012, received payment of £285. Hours: 1.5 hrs. (Registered 20 November 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-10-14 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 14 | 2013-10-14-1f359ece-24850-0 |
c60a4a9e7abcb4130722dcf76715c3133ac7ac10 | 23 January 2013, received payment of £400. Hours: 1.5 hrs. (Registered 13 February 2013) | Remunerated employment, office, profession etc 1f359ece | 2013-10-14 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 15 | 2013-10-14-1f359ece-24850-0 |
25ba9b26006e54c420e0fd16ce52c3467fd1c63e | 1 February 2013, received payment of £200. Hours: 0 hrs. (international syndication fee) (Registered 13 February 2013 ) | Remunerated employment, office, profession etc 1f359ece | 2013-10-14 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 16 | 2013-10-14-1f359ece-24850-0 |
fcea1d3a01d5222dc546ffd4b5f5f02640eaf482 | 25 February 2013, received payment of £285. Hours: 1 hr. (Registered 25 March 2013) | Remunerated employment, office, profession etc 1f359ece | 2013-10-14 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 17 | 2013-10-14-1f359ece-24850-0 |
a9b56b1a59d0064d7aea308561a30a73cc4c058c | 27 February 2013, received payment of £150. Hours: 1 hr. (Registered 25 March 2013) | Remunerated employment, office, profession etc 1f359ece | 2013-10-14 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 18 | 2013-10-14-1f359ece-24850-0 |
47e5ba3ec5da5d71867f4bae1c26aa1e11953b3f | 16 April 2013, received payment of £400. Hours: 2 hrs. (Registered 13 May 2013) | Remunerated employment, office, profession etc 1f359ece | 2013-10-14 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 19 | 2013-10-14-1f359ece-24850-0 |
0c3b43306fb2abd1525658a0182b69ac1e362572 | 23 May 2013, received payment of £500. Hours: 2 hrs. (Registered 18 June 2013) | Remunerated employment, office, profession etc 1f359ece | 2013-10-14 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 20 | 2013-10-14-1f359ece-24850-0 |
6a557db8a07533b4f2ae1ad8a585b453016fc48e | 13 June 2013, received payment of £490. Hours: 2 hrs. (Registered 18 June 2013) | Remunerated employment, office, profession etc 1f359ece | 2013-10-14 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 21 | 2013-10-14-1f359ece-24850-0 |
4e0293ca22dbd5e2b85622a6222d1c6a684d1cde | 11 July 2013, received payment of £125. No additional hours (re-publication rights). (Registered 23 August 2013) | Remunerated employment, office, profession etc 1f359ece | 2013-10-14 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 22 | 2013-10-14-1f359ece-24850-0 |
72fb6ca48c48c55d4a36518dc11dc15a78755a4d | 25 July 2013, received payment of £500. Hours: 2 hrs. (Registered 23 August 2013) | Remunerated employment, office, profession etc 1f359ece | 2013-10-14 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 23 | 2013-10-14-1f359ece-24850-0 |
45223cd8e033f49aaf1093c48a8301f5711cac71 | Payment from The Spectator, 22 Old Queen Street, London SW1H 9HP: | Remunerated employment, office, profession etc 1f359ece | 2013-10-14 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 24 | 2013-10-14-1f359ece-24850-0 |
ea7b5b24536129aaa1ea593e1092a433ce78121f | 25 March 2013, received payment of £250. Hours: 1.5 hrs. (Registered 25 March 2013) | Remunerated employment, office, profession etc 1f359ece | 2013-10-14 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 25 | 2013-10-14-1f359ece-24850-0 |
afbfcf8b86eb72fb7914ae357263933809bf7802 | 15 April 2013, received payment of £250. Hours: 1 hr. (Registered 13 May 2013) | Remunerated employment, office, profession etc 1f359ece | 2013-10-14 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 26 | 2013-10-14-1f359ece-24850-0 |
fded3172d2231448ba6cbf8ae1cc885af631c5c2 | Payments made through Capel & Land, literary agents, 29 Wardour Street, London W1D 6PS: | Remunerated employment, office, profession etc 1f359ece | 2013-10-14 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 27 | 2013-10-14-1f359ece-24850-0 |
e9ffb010a1a0786a0ad0716fbc8d04a9ff19f90e | 1 October 2012, payment of £4,499, for publishing rights. Hours: no additional hours. (Registered 19 October 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-10-14 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 28 | 2013-10-14-1f359ece-24850-0 |
52037b9f4c670e83287ead7241320ef4e6fe3f46 | 11 April 2013, payment of £484.03 for book royalties. Hours: no additional hours. (Registered 13 May 2013) | Remunerated employment, office, profession etc 1f359ece | 2013-10-14 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 29 | 2013-10-14-1f359ece-24850-0 |
b981cdc91775b496e56710e237aa553d27be17cf | 20 May 2013, payment of £8,200, on completion of book. Hours: 50 hrs. (Registered 18 June 2013) | Remunerated employment, office, profession etc 1f359ece | 2013-10-14 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 30 | 2013-10-14-1f359ece-24850-0 |
c945e841ac0c8e11d1dbbc0927cc526a91f3af96 | 20 August 2013, payment of £6,051 received for American publication rights. No additional hours. (Registered 23 August 2013) | Remunerated employment, office, profession etc 1f359ece | 2013-10-14 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 31 | 2013-10-14-1f359ece-24850-0 |
cb1cd6a538981c7de229fdb79f7ad248af4251af | Payments for articles from MGN Limited, One Canada Square, Canary Wharf, London E14 5AP: | Remunerated employment, office, profession etc 1f359ece | 2013-10-14 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 32 | 2013-10-14-1f359ece-24850-0 |
8b1fde93ad2c35ef8b11b8e2374191b0e168034e | 5 December 2012, received payment of £400. Hours: 2 hrs. (Registered 20 December 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-10-14 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 33 | 2013-10-14-1f359ece-24850-0 |
ddc1cac0e5e2a5db765a3f42bb9de5a178376911 | 5 February 2013, received payment of £500. Hours: 2 hrs. (Registered 13 February 2013) | Remunerated employment, office, profession etc 1f359ece | 2013-10-14 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 34 | 2013-10-14-1f359ece-24850-0 |
ebc217f458b14d3ee26a5a15c75c333c94da1076 | 5 June 2013, received payment of £600. Hours: 3 hrs. (Registered 18 June 2013) | Remunerated employment, office, profession etc 1f359ece | 2013-10-14 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 35 | 2013-10-14-1f359ece-24850-0 |
c23a582e36559efb079e48d45f51740ac07fcf7f | Payments for articles from the Financial Times Ltd, Number One Southwark Bridge, London SE1 9HL: | Remunerated employment, office, profession etc 1f359ece | 2013-10-14 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 36 | 2013-10-14-1f359ece-24850-0 |
8e6ea8e7f7cf6404a4097dea63a52ad338ca82e2 | 6 October 2012, received payment of £300. Hours: 1 hr. (Registered 19 October 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-10-14 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 37 | 2013-10-14-1f359ece-24850-0 |
8c45a1f9e08fa6d1d2655d364c232c720a2072f3 | 25 March 2013, received payment of £300. Hours: 2 hrs. (Registered 15 March 2013) | Remunerated employment, office, profession etc 1f359ece | 2013-10-14 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 38 | 2013-10-14-1f359ece-24850-0 |
b97faf596b4f4f5e68e740da2a45e2783bf58554 | Payment of £200 for article for the Telegraph Media Group, Buckingham Palace Road, London SW1 0DT, received on 30 October 2012. Hours: 1.5 hrs. (Registered 20 November 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-10-14 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 39 | 2013-10-14-1f359ece-24850-0 |
967814ebd50381597a2c4337ed794df3a056a2d2 | 9 November 2012, received payment of £5,000 from Civitas think-tank (Institute for the Study of Civil Society), 55 Tufton Street, London SW1P 3QL; advance publication payment for editing and chapter contributions to forthcoming book. Hours: 35 hrs. (Registered 30 November 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-10-14 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 40 | 2013-10-14-1f359ece-24850-0 |
246cd64831def2c4e0c33a123e2fc748faf750d0 | Payments from Immediate Media Company Bristol Ltd, Tower House, Fairfax Street, Bristol BS1 3BN, for articles for BBC History Magazine: | Remunerated employment, office, profession etc 1f359ece | 2013-10-14 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 41 | 2013-10-14-1f359ece-24850-0 |
a6e8abbd8c941d3149a071d7e8d2ba1ea12d0dd2 | 28 November 2012, received £200 Hours: 1.5 hrs. (Registered 20 December 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-10-14 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 42 | 2013-10-14-1f359ece-24850-0 |
8b2820e40f24d320bd5464ae9de55f8f156a973e | 24 May 2013, received £200. Hours: 1 hr. (Registered 18 June 2013) | Remunerated employment, office, profession etc 1f359ece | 2013-10-14 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 43 | 2013-10-14-1f359ece-24850-0 |
9d91754241e6129eef33b3fd5f0ea812a69bafb1 | 10 December 2012, received payment of £600 for article for Financial World Magazine, by ifs School of Finance, 5 Derby Street, London W1J 7AB. Hours: 2 hrs. (Registered 20 December 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-10-14 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 44 | 2013-10-14-1f359ece-24850-0 |
d0ab62deb3098baf7bfb01e7ab94fff8ec2dfb53 | 28 January 2013, received payment of £350 from Lancaster University, Lancaster, Lancashire LA1 4YW, for lecture. Hours: 2 hrs. (Registered 13 February 2013) | Remunerated employment, office, profession etc 1f359ece | 2013-10-14 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 45 | 2013-10-14-1f359ece-24850-0 |
76b16599528b3b6b56976249f9662611f075f210 | 8 February 2013, received payment of £200 from DoubleBand Films, 3 Crescent Gardens, Belfast, BT7 1NS, for BBC Northern Ireland documentary appearance. Hours: 1 hr. (Registered 13 February 2013) | Remunerated employment, office, profession etc 1f359ece | 2013-10-14 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 46 | 2013-10-14-1f359ece-24850-0 |
64829b1d39bf628c0939e8d2e33b4ae3b64d7273 | 1 March 2013, received payment of £1,500 from The Folio Society, 44 Eagle Street, London WC1R 4FS, for an introductory essay. Hours: 5 hrs. (Registered 26 March 2013) | Remunerated employment, office, profession etc 1f359ece | 2013-10-14 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 47 | 2013-10-14-1f359ece-24850-0 |
b4d9035d2e31518bda8295b3ca7c544069a441f1 | Payments for articles from the Times, News International Trading Ltd, PO Box 151, Peterborough: | Remunerated employment, office, profession etc 1f359ece | 2013-10-14 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 48 | 2013-10-14-1f359ece-24850-0 |
3b5b5500afc3c7368045fb215d8306b2a8938595 | 15 April 2013, received payment of £400. Hours: 2 hrs. (Registered 13 May 2019) | Remunerated employment, office, profession etc 1f359ece | 2013-10-14 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 50 | 2013-10-14-1f359ece-24850-0 |
442725549ccb9edb03f9c5bef3c3f44006d1339d | Payment for articles from Evening Standard, Northcliffe House, 2 Derry Street: | Remunerated employment, office, profession etc 1f359ece | 2013-10-14 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 51 | 2013-10-14-1f359ece-24850-0 |
e3a1b9d44ec4d760688906713b0a705b8afe49c8 | 24 April 2013, received payment of £240. Hours: 2 hrs. (Registered 13 May 2013) | Remunerated employment, office, profession etc 1f359ece | 2013-10-14 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 52 | 2013-10-14-1f359ece-24850-0 |
e5a9fa948c1c7288cd72508a1f78496d39c4111d | 13 June 2013, received fee of £1,000 for judging award from the Art Fund, Millais House, 7 Cromwell Place, London SW7 2JN. Hours: 7 hrs. (Registered 18 June 2013) | Remunerated employment, office, profession etc 1f359ece | 2013-10-14 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 53 | 2013-10-14-1f359ece-24850-0 |
8bc25bf2fad9d24cac1ea9a83f343c1d98128b39 | 10 July 2013, payment of £400 received for lecture from Martin Randall Trevel, Voysey House, Barley Mow Passage, London W4 4GF. Hours: 3 hrs. (Registered 23 August 2013) | Remunerated employment, office, profession etc 1f359ece | 2013-10-14 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 54 | 2013-10-14-1f359ece-24850-0 |
e0c29e18cba983cbf6c6add2770d1f2630e0f474 | 30 July 2013, payment of £320 received for lecture from Keele University, Keele, ST5 5BG. Hours: 3 hrs. (Registered 23 August 2013) | Remunerated employment, office, profession etc 1f359ece | 2013-10-14 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 55 | 2013-10-14-1f359ece-24850-0 |
2735bdd5bf7f65e566e7df8e2707d2ffd01d9d66 | Donations to my constituency party or association, which have been or will be reported by my party to the Electoral Commission: | Sponsorships 8f616a6e | 2013-10-14 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 0 | 2013-10-14-8f616a6e-24850-0 |
991aac5f3ad3fd81d700655c02d360b83415f557 | Sponsorships 8f616a6e | 2013-10-14 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 1 | 2013-10-14-8f616a6e-24850-0 | |
6b8c50bef685cd97ad5c6f7ae1aa08e519c7da2f | Name of donor: Lord Sainsbury | Sponsorships 8f616a6e | 2013-10-14 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 2 | 2013-10-14-8f616a6e-24850-0 |
1819052850897f0dfb1343d2c99a9d22fec8df63 | Amount of donation or nature and value if donation in kind: £3,000 | Sponsorships 8f616a6e | 2013-10-14 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 4 | 2013-10-14-8f616a6e-24850-0 |
bba7839fca48088892ffced68495dc5ecaa8544d | (Registered 20 December 2012) | Sponsorships 8f616a6e | 2013-10-14 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 6 | 2013-10-14-8f616a6e-24850-0 |
66a05ba7af61f42d8e13856727098e8d0557b7f6 | Name of donor: Peter Coates | Sponsorships 8f616a6e | 2013-10-14 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 7 | 2013-10-14-8f616a6e-24850-0 |
35d7b0b4781a3dd6eb965faee38d55bd68036254 | Address of donor: private | Sponsorships 8f616a6e | 2013-10-14 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 8 | 2013-10-14-8f616a6e-24850-0 |
282589d8c761307c23e21b7905621d56809a5c8f | Amount of donation or nature and value if donation in kind: £5,000 | Sponsorships 8f616a6e | 2013-10-14 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 9 | 2013-10-14-8f616a6e-24850-0 |
a111a4990f40cc7f0004062bd6d1693b53b4574e | Donor status: individual | Sponsorships 8f616a6e | 2013-10-14 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 10 | 2013-10-14-8f616a6e-24850-0 |
af17840e57ef0bf464ab83004dd9e586e76ce2c3 | (Registered 13 May 2013) | Sponsorships 8f616a6e | 2013-10-14 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 11 | 2013-10-14-8f616a6e-24850-0 |
390629ebdfc196853274360168d0c3c38553af88 | Name of donor: Civitas, the Institute of Civil Society | Gifts, benefits and hospitality (UK) 84642823 | 2013-10-14 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 0 | 2013-10-14-84642823-24850-0 |
d8b44c8db745ad16b95a5c06c610db53c8fdd8af | Address of donor: 55 Tufton St, London SW1P 3QL | Gifts, benefits and hospitality (UK) 84642823 | 2013-10-14 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 1 | 2013-10-14-84642823-24850-0 |
3bda3a61949c1a6705e6f007273a048c4b50dec0 | Amount of donation or nature and value if donation in kind: 840 history books for distribution to primary schools in my constituency; approx value £10,000 | Gifts, benefits and hospitality (UK) 84642823 | 2013-10-14 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 2 | 2013-10-14-84642823-24850-0 |
1155449b2b67549baa71e8ccf4a986fe6aed4710 | Date of receipt of donation: 24 July 2013 | Gifts, benefits and hospitality (UK) 84642823 | 2013-10-14 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 3 | 2013-10-14-84642823-24850-0 |
96386bfa024ea37d1812e6c05b762b9ca0d95c84 | Date of acceptance of donation: 24 July 2013 | Gifts, benefits and hospitality (UK) 84642823 | 2013-10-14 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 4 | 2013-10-14-84642823-24850-0 |
ce2c28b4194d5ac1d0120ea040e0805f7119de12 | Donor status: UK registered charity | Gifts, benefits and hospitality (UK) 84642823 | 2013-10-14 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 5 | 2013-10-14-84642823-24850-0 |
ce4b37f54bf88ec6276403dcef57132d8ad546cb | (Registered 23 August 2013 ) | Gifts, benefits and hospitality (UK) 84642823 | 2013-10-14 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 6 | 2013-10-14-84642823-24850-0 |
aea5975ce3df1d25090158e42da22c7493c5ca78 | Name of donor: Government of the United Arab Emirates | Overseas visits 80ef1083 | 2013-10-14 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 0 | 2013-10-14-80ef1083-24850-0 |
af340769bb1e486b4fc75d2d9e23799a3cb523c3 | Address of donor: PO Box 31966, Abu Dhabi, United Arab Emirates | Overseas visits 80ef1083 | 2013-10-14 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 1 | 2013-10-14-80ef1083-24850-0 |
e05fc8383f783941d789a0cabebf168342a48446 | Amount of donation (or estimate of the probable value): £3,500 | Overseas visits 80ef1083 | 2013-10-14 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 2 | 2013-10-14-80ef1083-24850-0 |
4ff9ba8d0e4fce5dd3dbe3409537ed6ab3b4b87e | Destination of visit: United Arab Emirates | Overseas visits 80ef1083 | 2013-10-14 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 3 | 2013-10-14-80ef1083-24850-0 |
3a79cfc6433cdd2044bc951b4902e18f6d96302c | Date of visit: 23-28 November 2012 | Overseas visits 80ef1083 | 2013-10-14 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 4 | 2013-10-14-80ef1083-24850-0 |
6bcdac09a6f4a3e6ec43ec1e6be00204ddfd8d0b | Purpose of visit: to meet with Government Ministers, Members of the Federal National Council and senior business figures together with British diplomats to build on the bilateral relationship and promote trade and investment ties. | Overseas visits 80ef1083 | 2013-10-14 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 5 | 2013-10-14-80ef1083-24850-0 |
c94681cf8e5c57732b8a9ed70e5a6d2b1961f591 | (Registered 20 December 2012) | Overseas visits 80ef1083 | 2013-10-14 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 6 | 2013-10-14-80ef1083-24850-0 |
9aaf95c3cf8c0e508170415f9a2efa3db9405bbe | Name of donor: | Overseas visits 80ef1083 | 2013-10-14 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 7 | 2013-10-14-80ef1083-24850-0 |
0bdfb7341104e44d1920f77234b4ab55858688a3 | 1) UK-China Forum (UKCF) Ltd, with sponsorship support from BP, Barclays and Rolls Royce. | Overseas visits 80ef1083 | 2013-10-14 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 8 | 2013-10-14-80ef1083-24850-0 |
5a4f1bdf6f08115c0aedea820efccbe504ba9a0c | 2) International Department of Central Committee of the Communist Party of China (IDCPC) | Overseas visits 80ef1083 | 2013-10-14 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 9 | 2013-10-14-80ef1083-24850-0 |
6be082b7fd543c5815f1cb5b89bcf4ae8aa8f43a | Address of donor: | Overseas visits 80ef1083 | 2013-10-14 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 10 | 2013-10-14-80ef1083-24850-0 |
0cf475ed69dcd3e62a6e66af4cf3ca1bb48396f3 | 1) UKCF, 15 Belgrave Square, London SW1X 8PS | Overseas visits 80ef1083 | 2013-10-14 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 11 | 2013-10-14-80ef1083-24850-0 |
b5a232631f7b9ba4aed1fc5c779f42bded8cf0d2 | 2) IDCPC, 4 Fuxing Lu, Beijing 100860, China | Overseas visits 80ef1083 | 2013-10-14 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 12 | 2013-10-14-80ef1083-24850-0 |
7cdce2b03ee8ee77ba241518d62439cf15b86399 | Amount of donation (or estimate of the probable value): | Overseas visits 80ef1083 | 2013-10-14 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 13 | 2013-10-14-80ef1083-24850-0 |
9c13bc0c98939eeaed44aa98ecdef6a4cdd70324 | 1) Business class flights paid by UKCF; cost £2,907 | Overseas visits 80ef1083 | 2013-10-14 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 14 | 2013-10-14-80ef1083-24850-0 |
98172fb00fc0ccc000eeccfd9256fae25201e801 | 2) Hotel and meals paid by IDCPC; estimated cost £508 | Overseas visits 80ef1083 | 2013-10-14 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 15 | 2013-10-14-80ef1083-24850-0 |
883e51aa28df7a9ce2703cb0e6bbed9731354241 | Destination of visit: Beijing, China | Overseas visits 80ef1083 | 2013-10-14 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 16 | 2013-10-14-80ef1083-24850-0 |
a19da27aa0eab35d02f4e5ee1cf9acd2f3a5cf69 | Date of visit: 12-18 January 2013 | Overseas visits 80ef1083 | 2013-10-14 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 17 | 2013-10-14-80ef1083-24850-0 |
5eaf2200e9adccdcc9edf0c883594ba6ecb942f4 | Purpose of visit: to attend the UK-China Leadership Forum in Beijing. | Overseas visits 80ef1083 | 2013-10-14 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 18 | 2013-10-14-80ef1083-24850-0 |
892f915ea910a14e9710c6d34878d585ba5f3359 | (Registered 13 February 2013) | Overseas visits 80ef1083 | 2013-10-14 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 19 | 2013-10-14-80ef1083-24850-0 |
Advanced export
JSON shape: default, array, newline-delimited, object
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");