home / regmem

items

Data source: mySociety Data

12 rows where record_id = "2012-12-03-1f359ece-10326-0" sorted by sort_order

View and edit SQL

hash item category_id date member_id person_id sort_order record_id
fa0f3d1bef5e9cb7ecf8899cf0211d099c282547 Payments from ComRes, 4 Millbank, London, SW1P 3JA, for completing opinion surveys: Remunerated employment, office, profession etc 1f359ece 2012-12-03 uk.org.publicwhip/member/40212 Tessa Jowell uk.org.publicwhip/person/10326 0 2012-12-03-1f359ece-10326-0
089421b60531e1c84b1708801d6ef1ac177e5cc4 28 April 2011, £75 for March-April 2011 MP Panel. Hours: 20-30 mins. Payment donated to local charity. (Registered 11 July 2012) Remunerated employment, office, profession etc 1f359ece 2012-12-03 uk.org.publicwhip/member/40212 Tessa Jowell uk.org.publicwhip/person/10326 1 2012-12-03-1f359ece-10326-0
83817f033a8e1542bff28a40395f57fe3de8a793 6 January 2012, £75 for November 2011 MP Panel. Hours: 20-30 mins. Payment donated to local charity. (Registered 11 July 2012) Remunerated employment, office, profession etc 1f359ece 2012-12-03 uk.org.publicwhip/member/40212 Tessa Jowell uk.org.publicwhip/person/10326 2 2012-12-03-1f359ece-10326-0
0004c5074164f39412f71f140fa257fc694a5ed3 18 June 2012, £75 for April 2012 MP Panel. Hours: 20-30 mins. Payment donated to local charity. (Registered 11 July 2012) Remunerated employment, office, profession etc 1f359ece 2012-12-03 uk.org.publicwhip/member/40212 Tessa Jowell uk.org.publicwhip/person/10326 3 2012-12-03-1f359ece-10326-0
5297d3b516b6b5792553e8a7be0f725d0ec2ee32 £75 for May 2012 Panel. Payment donated to local charity. Hours: 20-30 mins. (Registered 11 July 2012) Remunerated employment, office, profession etc 1f359ece 2012-12-03 uk.org.publicwhip/member/40212 Tessa Jowell uk.org.publicwhip/person/10326 4 2012-12-03-1f359ece-10326-0
2caf680532aaac387f3a45325307a33685358a45 £75 for July 2012 Panel. Payment donated to local charity. Hours: 20-30 mins. (Registered 11 July 2012) Remunerated employment, office, profession etc 1f359ece 2012-12-03 uk.org.publicwhip/member/40212 Tessa Jowell uk.org.publicwhip/person/10326 5 2012-12-03-1f359ece-10326-0
654dbd2647cbd51a15ffe80a78cf81e64e6d8e5b £75 for November 2012 Panel. Payment donated to local charity. Hours: 20-30 mins. (Registered 12 November 2012) Remunerated employment, office, profession etc 1f359ece 2012-12-03 uk.org.publicwhip/member/40212 Tessa Jowell uk.org.publicwhip/person/10326 6 2012-12-03-1f359ece-10326-0
9bfe7a7511d232d67d588c292a879d66f3a4ad88 June/July 2012, payment of £200 received from BSkyB,  Grant Way, Isleworth, Middlesex TW7 5QD for press previews on 27 September and 6 December 2011; also a second payment of £200 for press previews on 21 March and 12 June 2012. Hours: 30 mins for each appearance plus 2 hours travel; 10 hrs in total. (Registered 22 July 2012) Remunerated employment, office, profession etc 1f359ece 2012-12-03 uk.org.publicwhip/member/40212 Tessa Jowell uk.org.publicwhip/person/10326 7 2012-12-03-1f359ece-10326-0
7405cad953e7e0c96bf85892bee6b7c986e07648 Payment of £300 received from BSkyB for press previews on 13 August 2012, 28 August 2012 and 24 September 2012. Hours: for each appearance, 30 mins for each appearance plus 2 hrs travel; 7.5 hrs in total. (Registered 29 October 2012) Remunerated employment, office, profession etc 1f359ece 2012-12-03 uk.org.publicwhip/member/40212 Tessa Jowell uk.org.publicwhip/person/10326 8 2012-12-03-1f359ece-10326-0
cbc696bd91bf31f97a087207f9cc4bc07fc13b81 Payment of £4,000 plus VAT received for speech at Huddersfield University, Queensgate, Huddersfield HD1 3DH. Hours: 10 hrs, including preparation, delivery and travel. Fee donated to local organisation. (Registered 29 October 2012) Remunerated employment, office, profession etc 1f359ece 2012-12-03 uk.org.publicwhip/member/40212 Tessa Jowell uk.org.publicwhip/person/10326 9 2012-12-03-1f359ece-10326-0
142e4832fe94b7c6ff5a9722f761ff68f0328ae4 Payment of £250 from BBC Contributor Payments, PO Box 480, Manchester M14 0EL, for interview on 19 October 2012. Hours: 2.5 hrs including travel. (Registered 14 November 2012) Remunerated employment, office, profession etc 1f359ece 2012-12-03 uk.org.publicwhip/member/40212 Tessa Jowell uk.org.publicwhip/person/10326 10 2012-12-03-1f359ece-10326-0
864f3f071922c85b9e0d7b8679f2b7ea5d2530d8 Payment of £500 from BBC Contributor Payments, PO Box 480, Manchester M14 0EL, for appearance on 1 November 2012. Hours: 3 hrs including travel. (Registered 19 November 2012) Remunerated employment, office, profession etc 1f359ece 2012-12-03 uk.org.publicwhip/member/40212 Tessa Jowell uk.org.publicwhip/person/10326 11 2012-12-03-1f359ece-10326-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 73.884ms · Data source: mySociety Data