home / regmem

items

Data source: mySociety Data

7 rows where record_id = "2018-06-18-10057ffd-11506-0" sorted by sort_order

View and edit SQL

hash item category_id date member_id person_id sort_order record_id
0607218f8e0bd206b7e9c66e8ecfec030ea9a525 Payments from ANMFS Ltd, Northcliffe House, 2 Derry Street, Kensington, London W8 5TT: Employment and earnings 10057ffd 2018-06-18 David Jones uk.org.publicwhip/person/11506 0 2018-06-18-10057ffd-11506-0
0002260c66624e6b9c63f8cccd831179a17340bc 10 August 2017, received £600 for article published in Mail on Sunday. Hours: 2 hrs. (Registered 14 August 2017) Employment and earnings 10057ffd 2018-06-18 David Jones uk.org.publicwhip/person/11506 1 2018-06-18-10057ffd-11506-0
fc00b699d60347d70b437fdea723440f98182935 25 October 2017, received £200 for article published in Mail on Sunday. Hours: 2 hrs. (Registered 25 October 2017) Employment and earnings 10057ffd 2018-06-18 David Jones uk.org.publicwhip/person/11506 2 2018-06-18-10057ffd-11506-0
98e23a6b9481db10dfa47e02ec2e009059bad876 15 November 2017, received £300 for article published in Mail on Sunday. Hours: 2 hrs. (Registered 16 November 2017) Employment and earnings 10057ffd 2018-06-18 David Jones uk.org.publicwhip/person/11506 3 2018-06-18-10057ffd-11506-0
5105748eb6c7c28253dd9dc9292e4964f0f7bbd2 8 January 2018, received £600 for article published in Mail on Sunday. Hours: 3 hrs. (Registered 08 January 2018) Employment and earnings 10057ffd 2018-06-18 David Jones uk.org.publicwhip/person/11506 4 2018-06-18-10057ffd-11506-0
e254bb56346fc8f20b2b5056aa6a13ce67f5b095 22 May 2018, received £600 for article published in Mail on Sunday. Hours: 3 hrs. (Registered 22 May 2018) Employment and earnings 10057ffd 2018-06-18 David Jones uk.org.publicwhip/person/11506 5 2018-06-18-10057ffd-11506-0
e036d6050c89a0e50aaef253548082943ae7bff6 3 November 2017, received payment of £192 from Telegraph Media Group, 111 Buckingham Palace Road, London SW1W 0DT, for article published in Sunday Telegraph. Hours: 2 hrs. (Registered 06 November 2017) Employment and earnings 10057ffd 2018-06-18 David Jones uk.org.publicwhip/person/11506 6 2018-06-18-10057ffd-11506-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 3.887ms · Data source: mySociety Data