home / regmem

items

Data source: mySociety Data

8 rows where record_id = "2015-03-30-1f359ece-10505-1" sorted by sort_order

View and edit SQL

hash item category_id date member_id person_id sort_order record_id
dcee0cc3b9d778d4d5b3d20d4b12c284f2debc93 Payments from ComRes, Four Millbank, London SW1P 3JAL: Remunerated employment, office, profession etc 1f359ece 2015-03-30 uk.org.publicwhip/member/40602 Laurence Robertson uk.org.publicwhip/person/10505 0 2015-03-30-1f359ece-10505-1
acc1a449fec23578e2324695e662e1b283104f5c 12 March 2014,   £75 received for completing a survey. Hours: 30 mins. (Registered 11 April 2014) Remunerated employment, office, profession etc 1f359ece 2015-03-30 uk.org.publicwhip/member/40602 Laurence Robertson uk.org.publicwhip/person/10505 1 2015-03-30-1f359ece-10505-1
e75edaafb6ac85701519f5815f9ace996e96b58e 28 April 2014,   £75 received for completing a survey. Hours: 30 mins. (Registered 28 April 2014) Remunerated employment, office, profession etc 1f359ece 2015-03-30 uk.org.publicwhip/member/40602 Laurence Robertson uk.org.publicwhip/person/10505 2 2015-03-30-1f359ece-10505-1
d1e682a29e6e2d133e6b197a7a7708b523f1f90a £75 received for completing a survey. Hours: 20 mins. (Registered 12 June 2014) Remunerated employment, office, profession etc 1f359ece 2015-03-30 uk.org.publicwhip/member/40602 Laurence Robertson uk.org.publicwhip/person/10505 3 2015-03-30-1f359ece-10505-1
7ce240127a54a402bf693c50cf98a89d164bdcd1 1 August 2014,   £75 received for completing a survey. Hours: 20 mins. (Registered 14 August 2014) Remunerated employment, office, profession etc 1f359ece 2015-03-30 uk.org.publicwhip/member/40602 Laurence Robertson uk.org.publicwhip/person/10505 4 2015-03-30-1f359ece-10505-1
00000054abfae621b9dfe4991653d8400c3acb46 2 October 2014,   £75 received for completing a survey. Hours: 20 mins. (Registered 22 October 2014) Remunerated employment, office, profession etc 1f359ece 2015-03-30 uk.org.publicwhip/member/40602 Laurence Robertson uk.org.publicwhip/person/10505 5 2015-03-30-1f359ece-10505-1
2e9e47ad3bd680551717ceb1dfef00f23e58e3b5 26 November 2014, £75 received for completing a survey. Hours: 20 mins. (Registered 26 November 2014) Remunerated employment, office, profession etc 1f359ece 2015-03-30 uk.org.publicwhip/member/40602 Laurence Robertson uk.org.publicwhip/person/10505 6 2015-03-30-1f359ece-10505-1
34da5e39381d332ede6fa862bf6d32571fdde1e1 24 February 2015, £75 received for completing a survey. Hours: 25 mins. (Registered 25 February 2015) Remunerated employment, office, profession etc 1f359ece 2015-03-30 uk.org.publicwhip/member/40602 Laurence Robertson uk.org.publicwhip/person/10505 7 2015-03-30-1f359ece-10505-1

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 34.301ms · Data source: mySociety Data