home / regmem

items

Data source: mySociety Data

16 rows where record_id = "2014-12-08-1f359ece-10061-0" sorted by sort_order

View and edit SQL

hash item category_id date member_id person_id sort_order record_id
5b90f02bdb8b1f59e24e53b065567c209d496473 Payments from ComRes, 4 Millbank, London SW1P 3JA, for opinion surveys: Remunerated employment, office, profession etc 1f359ece 2014-12-08 uk.org.publicwhip/member/40254 Ben Bradshaw uk.org.publicwhip/person/10061 0 2014-12-08-1f359ece-10061-0
c547a91fddf962e16b777e543ef108474684648e 14 November 2013, payment of £75. Hours: 30 mins. (Registered 4 December 2013) Remunerated employment, office, profession etc 1f359ece 2014-12-08 uk.org.publicwhip/member/40254 Ben Bradshaw uk.org.publicwhip/person/10061 1 2014-12-08-1f359ece-10061-0
e5189a15f40f15810ad88d3d754399026061b3f9 15 January 2014, payment of £75. Hours: 30 mins. (Registered 31 January 2014) Remunerated employment, office, profession etc 1f359ece 2014-12-08 uk.org.publicwhip/member/40254 Ben Bradshaw uk.org.publicwhip/person/10061 2 2014-12-08-1f359ece-10061-0
df6e8b7f873abc9b942b9e0426ddc3d135f3082d 5 March 2014, payment of £75.  Hours: 30 mins. (Registered 12 March 2014) Remunerated employment, office, profession etc 1f359ece 2014-12-08 uk.org.publicwhip/member/40254 Ben Bradshaw uk.org.publicwhip/person/10061 3 2014-12-08-1f359ece-10061-0
bc016e294d08ecfa05d59a00cc97ba4ae9fd17cc 24 April 2014, payment of £75.  Hours: 30 mins. (Registered 2 May 2014) Remunerated employment, office, profession etc 1f359ece 2014-12-08 uk.org.publicwhip/member/40254 Ben Bradshaw uk.org.publicwhip/person/10061 4 2014-12-08-1f359ece-10061-0
96dfa346f6a3f4641fb4cbc725ac6c1bc6cd517d 6 June 2014, payment of £75.  Hours: 30 mins. (Registered 10 June 2014) Remunerated employment, office, profession etc 1f359ece 2014-12-08 uk.org.publicwhip/member/40254 Ben Bradshaw uk.org.publicwhip/person/10061 5 2014-12-08-1f359ece-10061-0
f421c0e8da619751443c8afe31c4a84fa6c44bb0 29 July 2014, payment of £75.  Hours: 30 mins. (Registered 6 August 2014) Remunerated employment, office, profession etc 1f359ece 2014-12-08 uk.org.publicwhip/member/40254 Ben Bradshaw uk.org.publicwhip/person/10061 6 2014-12-08-1f359ece-10061-0
43daa79dc8e4c872ccb05666d2b4fa54deb80a40 29 September 2014, payment of £75.  Hours: 30 mins. (21 October 2014) Remunerated employment, office, profession etc 1f359ece 2014-12-08 uk.org.publicwhip/member/40254 Ben Bradshaw uk.org.publicwhip/person/10061 7 2014-12-08-1f359ece-10061-0
0002a769c29d2e16ca68921685e82cbc22fb808a 18 November 2014, payment of £75. Hours: 30 mins (Registered 26 November 2014) Remunerated employment, office, profession etc 1f359ece 2014-12-08 uk.org.publicwhip/member/40254 Ben Bradshaw uk.org.publicwhip/person/10061 8 2014-12-08-1f359ece-10061-0
70c1c7e2f4ab349c23b64dd1cbdcf35a778562c2 Payments from Ipsos MORI, 79-81 Borough Road, London SE1 1FY, for opinion surveys: Remunerated employment, office, profession etc 1f359ece 2014-12-08 uk.org.publicwhip/member/40254 Ben Bradshaw uk.org.publicwhip/person/10061 9 2014-12-08-1f359ece-10061-0
9ae3704ce9307bd32275b38987b8745e3a3c5c72 5 September 2013, payment of £200. Hours: 30 mins. (Registered 4 December 2013) Remunerated employment, office, profession etc 1f359ece 2014-12-08 uk.org.publicwhip/member/40254 Ben Bradshaw uk.org.publicwhip/person/10061 10 2014-12-08-1f359ece-10061-0
30086e90cb0da353cebb8948d93ea5add73f3525 January 2014, payment of £200. Hours: 30 mins. (Registered 31 January 2014) Remunerated employment, office, profession etc 1f359ece 2014-12-08 uk.org.publicwhip/member/40254 Ben Bradshaw uk.org.publicwhip/person/10061 11 2014-12-08-1f359ece-10061-0
1fdc8acc44191cac6539758376a4dade63d176ad Payment from YouGov, 50 Featherstone Street, London EC1Y 8RT: Remunerated employment, office, profession etc 1f359ece 2014-12-08 uk.org.publicwhip/member/40254 Ben Bradshaw uk.org.publicwhip/person/10061 12 2014-12-08-1f359ece-10061-0
e2472b78a05446f2ae6e9ec06f887fdb5b0f993b 13 November 2013, payment of £80. Hours: 30 mins. (Registered 4 December 2013) Remunerated employment, office, profession etc 1f359ece 2014-12-08 uk.org.publicwhip/member/40254 Ben Bradshaw uk.org.publicwhip/person/10061 13 2014-12-08-1f359ece-10061-0
3c426922a1dc3a70a022c283691ce5961f174784 19 December 2013, payment of £80. Hours: 30 mins. (Registered 10 January 2014) Remunerated employment, office, profession etc 1f359ece 2014-12-08 uk.org.publicwhip/member/40254 Ben Bradshaw uk.org.publicwhip/person/10061 14 2014-12-08-1f359ece-10061-0
1653ed416e03b27468c5b880a131e4f8f6606270 4 June 2014, payment of £80.  Hours: 30 mins. (Registered 10 June 2014) Remunerated employment, office, profession etc 1f359ece 2014-12-08 uk.org.publicwhip/member/40254 Ben Bradshaw uk.org.publicwhip/person/10061 15 2014-12-08-1f359ece-10061-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 12.992ms · Data source: mySociety Data