home / regmem

items

Data source: mySociety Data

8 rows where record_id = "2012-04-16-1f359ece-10199-0" sorted by sort_order

View and edit SQL

hash item category_id date member_id person_id sort_order record_id
0003627f618a3908f2a64d6cc424ab070f6c9c10 Fee for survey from ComRes, 4 Millbank, London, SW1P 3JA: Remunerated employment, office, profession etc 1f359ece 2012-04-16 uk.org.publicwhip/member/40484 Jim Fitzpatrick uk.org.publicwhip/person/10199 0 2012-04-16-1f359ece-10199-0
aa19ad248f5ad70358944ed530e65f71c2788e73 March-April 2011, £75 for parliamentary panel survey. Hours: 30 mins. Payment donated to charity. (Registered 9 May 2011) Remunerated employment, office, profession etc 1f359ece 2012-04-16 uk.org.publicwhip/member/40484 Jim Fitzpatrick uk.org.publicwhip/person/10199 1 2012-04-16-1f359ece-10199-0
c8750a579b5a3cf2ecc6888fe11236c64012b36e May 2011, £75 for parliamentary panel survey. Hours: 30 mins. Payment donated to charity. (Registered 22 November 2011) Remunerated employment, office, profession etc 1f359ece 2012-04-16 uk.org.publicwhip/member/40484 Jim Fitzpatrick uk.org.publicwhip/person/10199 2 2012-04-16-1f359ece-10199-0
779f2c29fe02319bc98b2a76b6a15766d549a568 June 2011, £75 for parliamentary panel survey. Hours: 30 mins. Payment donated to charity. (Registered 22 November 2011) Remunerated employment, office, profession etc 1f359ece 2012-04-16 uk.org.publicwhip/member/40484 Jim Fitzpatrick uk.org.publicwhip/person/10199 3 2012-04-16-1f359ece-10199-0
6135cddd2a860a61e36475f98c089d7b58e53742 July 2011, £75 for parliamentary panel survey. Hours: 30 mins. Payment donated to charity. (Registered 22 November 2011) Remunerated employment, office, profession etc 1f359ece 2012-04-16 uk.org.publicwhip/member/40484 Jim Fitzpatrick uk.org.publicwhip/person/10199 4 2012-04-16-1f359ece-10199-0
197018bc0e555887a5aa055c6365b72fd83a07a0 October-November 2011, £75 for parliamentary panel survey. Hours: 30 mins. Payment donated to charity. (Registered 14 December 2011) Remunerated employment, office, profession etc 1f359ece 2012-04-16 uk.org.publicwhip/member/40484 Jim Fitzpatrick uk.org.publicwhip/person/10199 5 2012-04-16-1f359ece-10199-0
9e164f4f2a143913397a754ee3413469d0285af9 November-December 2011, £75 for parliamentary panel survey. Hours: 30 mins. Payment donated to charity. (Registered 18 January 2012) Remunerated employment, office, profession etc 1f359ece 2012-04-16 uk.org.publicwhip/member/40484 Jim Fitzpatrick uk.org.publicwhip/person/10199 6 2012-04-16-1f359ece-10199-0
c1df654dfad774b257b95279300167d2e4221e34 January 2012, fee of £150 for face-to-face survey from Ipsos Mori, 79-81 Borough Road, London SE1 1FY. Hours: 75 mins. Payment donated to charity. (Registered 1 February 2012) Remunerated employment, office, profession etc 1f359ece 2012-04-16 uk.org.publicwhip/member/40484 Jim Fitzpatrick uk.org.publicwhip/person/10199 7 2012-04-16-1f359ece-10199-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 19.495ms · Data source: mySociety Data