home / regmem

items

Data source: mySociety Data

12 rows where record_id = "2018-06-18-10057ffd-11455-0" sorted by sort_order

View and edit SQL

hash item category_id date member_id person_id sort_order record_id
9d47bf1804d0791c7ebc4e44964729033d71001d 29 August 2017, payment of £200 from Ipsos MORI, 3 Thomas More Square, London E1W 1YW, for an interview on 21 August 2017. Hours: 1 hr. Fee paid direct to charity. (Registered 10 October 2017) Employment and earnings 10057ffd 2018-06-18 Kerry McCarthy uk.org.publicwhip/person/11455 0 2018-06-18-10057ffd-11455-0
9c8dc2fae2c58ff0474ef3090b8c8ae3e5bdfbc6 Payments from ComRes, 4 Millbank, London SW1P 3JA, for opinion research: Employment and earnings 10057ffd 2018-06-18 Kerry McCarthy uk.org.publicwhip/person/11455 1 2018-06-18-10057ffd-11455-0
7176e2947bd84850ee0b412425a90e222d5c09ee 28 February 2017, payment of £100. Hours: approx. 40 mins. Fee paid direct to charity. (Registered 17 October 2017) Employment and earnings 10057ffd 2018-06-18 Kerry McCarthy uk.org.publicwhip/person/11455 2 2018-06-18-10057ffd-11455-0
eae736fc322c1c1acdcc43de452f0d14bc6326ab 8 June 2017, payment of £75. Hours: approx. 30 mins. Fee paid direct to charity. (Registered 17 October 2017) Employment and earnings 10057ffd 2018-06-18 Kerry McCarthy uk.org.publicwhip/person/11455 3 2018-06-18-10057ffd-11455-0
9171f9abf1b3c1ce16f3db68a196762578bbe7f4 22 September 2017, payment of £75. Hours: approx. 30 mins. Fee paid direct to charity. (Registered 17 October 2017) Employment and earnings 10057ffd 2018-06-18 Kerry McCarthy uk.org.publicwhip/person/11455 4 2018-06-18-10057ffd-11455-0
4b0105b8854b4af5cf40c5c97e8a9ed45de17d74 29 September 2017, payment of £150. Hours: approx. 1 hr. Fee donated to charity. (Registered 17 October 2017) Employment and earnings 10057ffd 2018-06-18 Kerry McCarthy uk.org.publicwhip/person/11455 5 2018-06-18-10057ffd-11455-0
2eea484c33d4f54bb9928cdac3806dabac52454c 17 November 2017, payment of £75. Hours: 30 mins. Fee paid direct to charity. (Registered 29 November 2017) Employment and earnings 10057ffd 2018-06-18 Kerry McCarthy uk.org.publicwhip/person/11455 6 2018-06-18-10057ffd-11455-0
fa06f8737acf1aedbabaac5210f40535b66e4eef Payment of £100 expected for a survey completed on 27 November 2017. Hours: 45 mins. This fee will be paid direct to charity. (Registered 14 December 2017) Employment and earnings 10057ffd 2018-06-18 Kerry McCarthy uk.org.publicwhip/person/11455 7 2018-06-18-10057ffd-11455-0
00639f2a97d391b560009422f3671361c6d787d7 15 January 2018, payment of £100. Hours: 45 mins. Fee paid direct to charity. (Registered 08 May 2018) Employment and earnings 10057ffd 2018-06-18 Kerry McCarthy uk.org.publicwhip/person/11455 8 2018-06-18-10057ffd-11455-0
0002263c706f149bf33ba78c20a2b565ef96f8db 2 February 2018, payment of £100. Hours: 45 mins. Fee paid direct to charity. (Registered 08 May 2018) Employment and earnings 10057ffd 2018-06-18 Kerry McCarthy uk.org.publicwhip/person/11455 9 2018-06-18-10057ffd-11455-0
2cbcda635633fd592829c3852f91d21e95d7618d 28 March 2018, payment of £75. Hours: 30 mins. Fee paid direct to charity. (Registered 08 May 2018) Employment and earnings 10057ffd 2018-06-18 Kerry McCarthy uk.org.publicwhip/person/11455 10 2018-06-18-10057ffd-11455-0
37ab9b9b1ef1f039bb91139f7b2c14b65c6f17b8 27 April 2018, payment of £75. Hours: 30 mins. Fee paid direct to charity. (Registered 08 May 2018) Employment and earnings 10057ffd 2018-06-18 Kerry McCarthy uk.org.publicwhip/person/11455 11 2018-06-18-10057ffd-11455-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 9.781ms · Data source: mySociety Data