home / regmem

items

Data source: mySociety Data

3 rows where record_id = "2014-03-21-1f359ece-13814-0" sorted by sort_order

View and edit SQL

hash item category_id date member_id person_id sort_order record_id
0002ecd593ead37650aa92f93054d2e4ae9db992 5 September 2013, received £150 plus travel expenses of £35.20 from John Hewitt Society, c/o Market Place Theatre, Armagh Theatre and Arts Centre, Market Street, Armagh City, Co Armagh, BT61 7BW for participating as political panellist at John Hewitt International Summer School at the Market Place Theatre, Armagh, on 26 July 2013. Hours: 2 hrs, plus 1.5 hrs travel. (Registered 7 October 2013) Remunerated employment, office, profession etc 1f359ece 2014-03-21 uk.org.publicwhip/member/40068 Naomi Long uk.org.publicwhip/person/13814 0 2014-03-21-1f359ece-13814-0
2d0329a23f4b452cf0506526c03f14fe1d965eff 28 August 2013, received £163.59 plus travel and accommodation expenses of £173.84 from Cumann Merriman, 30 An tArdán Theas, Cathair Chorcaí, Éire (Ireland), for participating as political speaker and panellist at Merriman Summer School in Lisdoonvarna, Co Clare, Ireland, on 18 August 2013. Hours: 4 hrs, plus 10 hrs travel. (Registered 7 October 2013) Remunerated employment, office, profession etc 1f359ece 2014-03-21 uk.org.publicwhip/member/40068 Naomi Long uk.org.publicwhip/person/13814 1 2014-03-21-1f359ece-13814-0
ff34192043d350f150cbc6f1caf5a21205e644ed £200 was donated to charity by the Hillsborough Presbyterian Men’s Group, Hillsborough Presbyterian Church, 2 Lisburn Road, BT26 6AA , following a speech I gave on 25 January 2014. Hours: 1 hr plus 2 hrs’ preparation.   (Registered 18 March 2014) Remunerated employment, office, profession etc 1f359ece 2014-03-21 uk.org.publicwhip/member/40068 Naomi Long uk.org.publicwhip/person/13814 2 2014-03-21-1f359ece-13814-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 48.09ms · Data source: mySociety Data