items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
49 rows where record_id = "2011-07-19-1f359ece-24850-0" sorted by sort_order
This data as json, CSV (advanced)
Suggested facets: date (date)
hash | item | category_id | date | member_id | person_id | sort_order ▼ | record_id |
---|---|---|---|---|---|---|---|
86fcb1fabce056b1aaceba06aa5d218575cfffc9 | Salary as lecturer at Queen Mary, University of London, Mile End Road, London E1 4NS: | Remunerated employment, office, profession etc 1f359ece | 2011-07-19 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 0 | 2011-07-19-1f359ece-24850-0 |
0bab4f7e07d3c54cfb665e3f6485c285d1ecb3ab | July 2010, received payment of £1,947 gross. Hours: 16 Hrs. (Registered 1 October 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-07-19 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 1 | 2011-07-19-1f359ece-24850-0 |
74c27bb8e1e8767d3408820cdb9d3532651f2225 | August 2010, received payment of £1,947 gross. Hours: 16 hrs. (Registered 1 October 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-07-19 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 2 | 2011-07-19-1f359ece-24850-0 |
c85577428d622f2ac03cf8c85addf333adb889d7 | September 2010, received payment of £1,116.78 gross. Hours: 16 hrs. (Registered 1 October 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-07-19 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 3 | 2011-07-19-1f359ece-24850-0 |
d21d5b09b31fa4a2470d4ae65d3a71ca05cd4b57 | 22 October 2010, received payment of £1,094.56 gross. Hours: 16 hrs. 9Registered 11 November 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-07-19 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 4 | 2011-07-19-1f359ece-24850-0 |
e5718ec74664cd89a7472a4d18e08caf02d54246 | 24 November 2010, received payment of £1,219.57 gross. Hours: 16 hrs. (Registered 19 January 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-07-19 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 5 | 2011-07-19-1f359ece-24850-0 |
db534c3aa8ea13f60e3a25570ab903c070936201 | 22 December 2010, received payment of £1,219.57 gross. Hours: 16 hrs. (Registered 19 January 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-07-19 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 6 | 2011-07-19-1f359ece-24850-0 |
b4ed2079794c0df7956a6ab0ce4545e6605662d4 | 24 January 2011, received payment of £1,219.57 gross. Hours: 16 hrs (Registered 14 March 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-07-19 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 7 | 2011-07-19-1f359ece-24850-0 |
aa5157241e75d56265d61ad32f77a85166418b8c | 24 February 2011, received payment of £1,219.57 gross. Hours: 16 hrs (Registered 14 March 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-07-19 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 8 | 2011-07-19-1f359ece-24850-0 |
f65963eed49f1f056ed0d9da8f98da15c8b7b9c4 | 24 March 2011, received payment of £1,051.94 gross. Hours: 16 hours (Registered 15 June 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-07-19 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 9 | 2011-07-19-1f359ece-24850-0 |
fcc0eb3d49ebdf2e4d5eed89f218626e82e205ab | 24 April 2011, received payment of £1,051.94 gross. Hours: 16 hours (Registered 15 June 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-07-19 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 10 | 2011-07-19-1f359ece-24850-0 |
45a6a5c081d8dea29e0f1fcaccf9eb2b9789a7a4 | 24 May 2011, received payment of £1,051.94 gross. Hours: 16 hours (Registered 15 June 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-07-19 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 11 | 2011-07-19-1f359ece-24850-0 |
00015d0b2fba2ff7dd222dd8454b892fa58f28ed | Payments for articles from Financial Times Ltd, Number One, Southwark Bridge, London SE1 9HL: | Remunerated employment, office, profession etc 1f359ece | 2011-07-19 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 12 | 2011-07-19-1f359ece-24850-0 |
1833cc3540d8c62e26f17b62facb6d320baba421 | 13 August 2010, payment of £300 for article. Hours: 1 hr. (Registered 1 October 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-07-19 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 13 | 2011-07-19-1f359ece-24850-0 |
75ac61ec11006b6a7166563f656ca27e347be3d5 | 21 October 2010, payment of £300 for article. Hours: 1 hr. (Registered 11 November 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-07-19 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 14 | 2011-07-19-1f359ece-24850-0 |
a82ef819d817c2c34c43fd7c87e403a3d18d36c1 | Payments for articles from Guardian News and Media Ltd, 1 Scott Place, Manchester M3 3GG: | Remunerated employment, office, profession etc 1f359ece | 2011-07-19 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 15 | 2011-07-19-1f359ece-24850-0 |
c0cf59e7336c3c1cb13863fd18a2a749f250f6fe | August 2010, received payment of £352.50. Hours: 1 hr. (Registered 1 October 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-07-19 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 16 | 2011-07-19-1f359ece-24850-0 |
33d6b9091cee7a974d4402aac0c7213196e04bec | 2 December 2010, received payment of £587.50. Hours: 1.5 hrs. (Registered 19 January 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-07-19 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 17 | 2011-07-19-1f359ece-24850-0 |
bf1bf43e761d11c3d98964e05fac44ea9343a3f2 | 27 January 2011, received payment of £900. Hours: 2 hrs. (Registered 14 March 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-07-19 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 18 | 2011-07-19-1f359ece-24850-0 |
c28f2789bfde26ff202e81fbb53b078d64950591 | 10 February 2011, received payment of £342. Hours: 1 hr. (Registered 14 March 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-07-19 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 19 | 2011-07-19-1f359ece-24850-0 |
b43cd632f36d6ef6f5d55f5d1a95f3b9bd24b859 | 25 February 2011, received payment of £935.25. Hours: 2 hrs. (Registered 14 March 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-07-19 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 20 | 2011-07-19-1f359ece-24850-0 |
1b18685e7de5dc88fcb19d0c09eb068958d6717f | 7 June 2011, received payment of £400. Hours: 2 hrs. (Registered 15 June 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-07-19 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 21 | 2011-07-19-1f359ece-24850-0 |
a80e2107750cdd8147aeed131a5c0ccd3c833e3b | ou | Remunerated employment, office, profession etc 1f359ece | 2011-07-19 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 22 | 2011-07-19-1f359ece-24850-0 |
7470962edd96b711ddc6bc488b0ffb54486f6cf3 | Payments for articles from Telegraph Media Group Ltd, 111 Buckingham Palace Road, London SW1W ODT: | Remunerated employment, office, profession etc 1f359ece | 2011-07-19 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 23 | 2011-07-19-1f359ece-24850-0 |
73ace366015fd7170cb44761ece0229bbba48767 | 21 July 2010, received payment of £470 for book review. Hours: 2 hrs. (Registered 1 October 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-07-19 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 24 | 2011-07-19-1f359ece-24850-0 |
7bfa0e93de67015bf97b1f985c93b20fc8fe840b | 18 February 2011, received payment of £360 for book review. Hours: 1.5 hrs. (Registered 14 March 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-07-19 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 25 | 2011-07-19-1f359ece-24850-0 |
cabdf6000b562968805bf7ee8fb158c9751b259e | Payment for article from The Spectator, 22 Old Queen Street, London SW1H 9HP: | Remunerated employment, office, profession etc 1f359ece | 2011-07-19 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 26 | 2011-07-19-1f359ece-24850-0 |
61812f8a189c3b465f902ea2cc01dbceab395dbd | 14 May 2010, received payment of £250. Hours: 1hr. (Registered 1 October 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-07-19 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 27 | 2011-07-19-1f359ece-24850-0 |
d2903cd3defdc61aeab045710a79a97fd7b66df4 | 19 January 2011, received payment of £200. Hours: 1 hr. (Registered 14 March 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-07-19 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 28 | 2011-07-19-1f359ece-24850-0 |
56555a54f6f04758620f9cd637e432ce15238d4d | Payments from BBC: | Remunerated employment, office, profession etc 1f359ece | 2011-07-19 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 29 | 2011-07-19-1f359ece-24850-0 |
e6657da28129c462d032b65814fcb2f3cb9d9f69 | 5 August 2010, received payment of £800 from BBC Radio Three, BBC Broadcasting House, Portland Place, London W1A 1AA, for taking part in the Saturday Feature on BBC Radio 3. Hours: 4 hrs. (Registered 1 October 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-07-19 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 30 | 2011-07-19-1f359ece-24850-0 |
45188222128dca1f6652059228fb926d5ed4bc70 | 11 January 2011, received payment of £50. Address: BBC, PO Box 480, Manchester M14 0EL. Hours: 1.5 hrs. (Registered 19 January 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-07-19 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 31 | 2011-07-19-1f359ece-24850-0 |
9ab1e1e5313e4caafa4c9fa11509f68f1eb1d8ce | 22 February 2011, received payment of £184, from BBC Radio Four, BBC Broadcasting House, Portland Place, London W1A 1AA, for appearing on Any Questions. (Registered 14 March 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-07-19 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 32 | 2011-07-19-1f359ece-24850-0 |
9f2f3a028dfd6c086c2ff75bb396b3ad95968161 | 21 April 2011, received payment of £880 from BBC, Broadcasting House, Portland Place, London W1A 1AA, for presenting Radio 4 programme ’A Tale of Two Cities’. Hours: 6 hrs. (Registered 15 June 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-07-19 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 33 | 2011-07-19-1f359ece-24850-0 |
65d9896d4b201a6954a2aea42f27ac88e3ef4d6b | 11 August 2010, received payment from Preston City Council, Town Hall, Preston PR1 2RL, for speaking at the Harris Museum. Fee included travel and accommodation costs. Hours: 2 hrs. (Registered 1 October 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-07-19 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 34 | 2011-07-19-1f359ece-24850-0 |
27cbf2c2bd9e4eefe16332a157405ddd22e80cb7 | 26 October 2010, received payment for speech given on 9 October 2010 at Wells Festival of Literature, Bishop’s Palace, Wells. Hours: 1 hr. (Registered 11 October 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-07-19 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 35 | 2011-07-19-1f359ece-24850-0 |
b708efbfacef9bbc58416b0a812e6514313459ac | Payments made through Capel & Land, literary agents, 29 Wardour Street, London W1D 6PS: | Remunerated employment, office, profession etc 1f359ece | 2011-07-19 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 36 | 2011-07-19-1f359ece-24850-0 |
b95b64cde492a261ffc5b513408a8bfab725c96d | 3 December 2010, fee of £1,521.26 from BBC for ‘Ideas- the British version’. Hours: 4 hrs. (Registered 19 January 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-07-19 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 37 | 2011-07-19-1f359ece-24850-0 |
2cce2380a5982dd08950a9382a1c6c7b0edd9e2c | 23 December 2010, payment of £2,229.54 from Swiat Ksiazki SP Zoo as signature advance for book. (Registered 19 January 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-07-19 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 38 | 2011-07-19-1f359ece-24850-0 |
2f4a6f72550b27eac47e479934ebf55e0a1c865c | 6 January 2011, payment of £621.61 from China Social Sciences Press as signature advance for book. (Registered 19 January 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-07-19 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 39 | 2011-07-19-1f359ece-24850-0 |
dd2958ac73e9b6bdf0acc2d7cc0660608face60a | 8 February 2011, payment of £510 from Penguin Books Ltd. Final payment for book. (Registered 14 March 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-07-19 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 40 | 2011-07-19-1f359ece-24850-0 |
1879de938901eb40504b380aceccb9582a40f6f0 | 15 February 2011, received payment of £3,033.89 from BBC Radio Three, BBC Broadcasting House, Portland Place, London W1A 1AA, for presenting Radio 3 series Great British Ideas. Hours: 12 hrs. (Registered 14 March 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-07-19 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 41 | 2011-07-19-1f359ece-24850-0 |
cc574594acb18c91c451306789c80271e4a11ba1 | Payments for articles from MGN Limited, One Canada Square, Canary Wharf, London E14 5AP: | Remunerated employment, office, profession etc 1f359ece | 2011-07-19 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 42 | 2011-07-19-1f359ece-24850-0 |
a7c40093a75aeae8891d41fbb2d6c9ad3581f760 | 14 December 2010, £822.50. Hours: 1.5 hrs. (Registered 19 January 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-07-19 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 43 | 2011-07-19-1f359ece-24850-0 |
db2e8cbc2b68eced40096432ef878f0059191140 | 5 January 2011, £352.50 gross. Hours: 1.5 hrs. (Registered 19 January 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-07-19 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 44 | 2011-07-19-1f359ece-24850-0 |
32dfbbb9278ed0a6c4772fe20b7a2f240f7cb725 | 3 March 2011, received payment of £1,100 for 2 articles. Hours: 2 hrs. (Registered 14 March 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-07-19 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 45 | 2011-07-19-1f359ece-24850-0 |
76e0da74cf19998ec1984f91030e656abd34897e | 11 April 2011, received payment of £100. Hours: 1 hr. (Registered 15 June 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-07-19 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 46 | 2011-07-19-1f359ece-24850-0 |
95abe6f1347351d7681fb57a32d07c7225effc68 | Payments for articles from the Financial Times Ltd, Number One Southwark Bridge, London SE1 9HL | Remunerated employment, office, profession etc 1f359ece | 2011-07-19 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 47 | 2011-07-19-1f359ece-24850-0 |
bfb1bd0b4dd7e7264e1fd331800c935850b1c497 | 28 April 2011, £500. Hours: 1.5 hours. ( Registered 15 June 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-07-19 | Tristram Hunt uk.org.publicwhip/member/40581 | Tristram Hunt uk.org.publicwhip/person/24850 | 48 | 2011-07-19-1f359ece-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");