home / regmem

items

Data source: mySociety Data

11 rows where record_id = "2016-02-08-10057ffd-10219-0" sorted by sort_order

View and edit SQL

hash item category_id date member_id person_id sort_order record_id
032041ecafb360bfc544a9a4ef3e61d5bab7bad6 Payments received for completion of opinion surveys for ComRes, 4 Millbank, London SW1P 3JA. Hours: 15 -20 mins each. All payments donated to Redbridge Organiser's account, unless otherwise stated. (Registered 03 June 2015) Employment and earnings 10057ffd 2016-02-08 Mike Gapes uk.org.publicwhip/person/10219 0 2016-02-08-10057ffd-10219-0
51b971c59e398f29c5ea0a4f53273c1b56e98eca June 2013, I received £75. (Registered 03 June 2015) Employment and earnings 10057ffd 2016-02-08 Mike Gapes uk.org.publicwhip/person/10219 1 2016-02-08-10057ffd-10219-0
c5916541cfed204fbb2689a612d4aa9ddf5a44dd March 2014, I received £75. (Registered 03 June 2015) Employment and earnings 10057ffd 2016-02-08 Mike Gapes uk.org.publicwhip/person/10219 2 2016-02-08-10057ffd-10219-0
0002a354f0e5b589954caef1adb599165d0675b1 April 2014, I received £75. (Registered 03 June 2015) Employment and earnings 10057ffd 2016-02-08 Mike Gapes uk.org.publicwhip/person/10219 3 2016-02-08-10057ffd-10219-0
229da6f1b532d95e405187e0000aa0fa1435ac82 June 2014, I received £75. (Registered 03 June 2015) Employment and earnings 10057ffd 2016-02-08 Mike Gapes uk.org.publicwhip/person/10219 4 2016-02-08-10057ffd-10219-0
133f5b9747c19f926992e67e375311d9f3d642de July 2014, I received £75. (Registered 03 June 2015) Employment and earnings 10057ffd 2016-02-08 Mike Gapes uk.org.publicwhip/person/10219 5 2016-02-08-10057ffd-10219-0
dc6d6ac82c61019c41f89bfd3863c6746e959dfa November 2014, I received £75. (Registered 03 June 2015) Employment and earnings 10057ffd 2016-02-08 Mike Gapes uk.org.publicwhip/person/10219 6 2016-02-08-10057ffd-10219-0
c4540b3096ad333c031806324aeb17cf20a07b58 January 2015, I received £75. Payment donated to Ilford South Labour Party. (Registered 03 June 2015) Employment and earnings 10057ffd 2016-02-08 Mike Gapes uk.org.publicwhip/person/10219 7 2016-02-08-10057ffd-10219-0
b304c5286e54914eea56d613b2cf2f77d16e2e3f February 2015, I received £75. (Registered 03 June 2015) Employment and earnings 10057ffd 2016-02-08 Mike Gapes uk.org.publicwhip/person/10219 8 2016-02-08-10057ffd-10219-0
bb411f1c02446379ab13569e705bd21b544d1669 Payments received for completion of opinion surveys for YouGov, 50 Featherstone St, London EC1Y 8RT. Hours: 15 -20 mins each. All payments donated to Ilford South Labour Party, unless otherwise stated. Employment and earnings 10057ffd 2016-02-08 Mike Gapes uk.org.publicwhip/person/10219 9 2016-02-08-10057ffd-10219-0
1dd81f91e648775f7625d0efb1bafe8a58afcbc0 November 2013, I received £80. (Registered 03 June 2015) Employment and earnings 10057ffd 2016-02-08 Mike Gapes uk.org.publicwhip/person/10219 10 2016-02-08-10057ffd-10219-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 31.419ms · Data source: mySociety Data