home / regmem

items

Data source: mySociety Data

5 rows where record_id = "2018-04-30-10057ffd-24765-0" sorted by sort_order

View and edit SQL

hash item category_id date member_id person_id sort_order record_id
b4c5546bfd1d7b6c9773765f8432de5fe677d708 Payments received in my capacity as a freelance GP from Farnham Road Surgery, 301 Farnham Road, Slough SL2 1HD: Employment and earnings 10057ffd 2018-04-30 Phillip Lee uk.org.publicwhip/person/24765 0 2018-04-30-10057ffd-24765-0
197440e4a292fda63953623793237b941820c983 28 July 2017, received £4,720. Hours: 59 hrs between 3 and 13 April 2017 inclusive. (Registered 07 September 2017) Employment and earnings 10057ffd 2018-04-30 Phillip Lee uk.org.publicwhip/person/24765 1 2018-04-30-10057ffd-24765-0
0000fc42d42956ffbf92c3758bb6ce2b60b867d1 10 August 2017, received £5,400. Hours: 71 hrs between 24 July and 4 August 2017 inclusive. (Registered 07 September 2017) Employment and earnings 10057ffd 2018-04-30 Phillip Lee uk.org.publicwhip/person/24765 2 2018-04-30-10057ffd-24765-0
90cde3da1a3898c71e26fe7bdac62df650b24f7a Payments received in my capacity as a freelance GP from Chequers Surgery 1-3 Chequers Drive, Prestwood, Great Missenden HP16 9DU: Employment and earnings 10057ffd 2018-04-30 Phillip Lee uk.org.publicwhip/person/24765 3 2018-04-30-10057ffd-24765-0
a9d373d6d7cc72ac8e4e7f7a1072147088efd233 28 July 2017, received £385.77. Hours: 3.5 hrs on 13 April 2017. (Registered 07 September 2017) Employment and earnings 10057ffd 2018-04-30 Phillip Lee uk.org.publicwhip/person/24765 4 2018-04-30-10057ffd-24765-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 5.431ms · Data source: mySociety Data