home / regmem

items

Data source: mySociety Data

49 rows where record_id = "2011-07-19-1f359ece-24850-0" sorted by sort_order

View and edit SQL

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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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, 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)
    )
Powered by Datasette · Query took 13.629ms · Data source: mySociety Data