home / regmem

items

Data source: mySociety Data

6 rows where record_id = "2014-02-24-8f616a6e-24831-0" sorted by sort_order

View and edit SQL

hash item category_id date member_id person_id sort_order record_id
00004f49bc050268f2171ccaad782ecfdc9c02e2 Donations to my constituency party or association, which have been or will be reported by my party to the Electoral Commission: Sponsorships 8f616a6e 2014-02-24 uk.org.publicwhip/member/40658 Lisa Nandy uk.org.publicwhip/person/24831 0 2014-02-24-8f616a6e-24831-0
38122611adae2456a8e5a420ba07c7b7c4d1f316 Name of donor: Communication Workers Union Sponsorships 8f616a6e 2014-02-24 uk.org.publicwhip/member/40658 Lisa Nandy uk.org.publicwhip/person/24831 1 2014-02-24-8f616a6e-24831-0
e1e0fd8c23e3a40ce3b3886233661f482cc98d00 Address of donor: 150 The Broadway, Wimbledon, London SW19 1RX Sponsorships 8f616a6e 2014-02-24 uk.org.publicwhip/member/40658 Lisa Nandy uk.org.publicwhip/person/24831 2 2014-02-24-8f616a6e-24831-0
68b2ab9c2585327ad333ee003a26ed5414816cc4 Amount of donation or nature and value if donation in kind: £2,000 per year for 2 years, paid in monthly instalments of £166.67, to Wigan Constituency Labour Party, from 2 April 2012 to 2 April 2014 Sponsorships 8f616a6e 2014-02-24 uk.org.publicwhip/member/40658 Lisa Nandy uk.org.publicwhip/person/24831 3 2014-02-24-8f616a6e-24831-0
39acc30345a20311cdfd843193a5ce040e2574a6 Donor status: trade union Sponsorships 8f616a6e 2014-02-24 uk.org.publicwhip/member/40658 Lisa Nandy uk.org.publicwhip/person/24831 4 2014-02-24-8f616a6e-24831-0
c11682cff7508c9a1bff9e75b5803c453cbf5525 (Registered 23 January 2014) Sponsorships 8f616a6e 2014-02-24 uk.org.publicwhip/member/40658 Lisa Nandy uk.org.publicwhip/person/24831 5 2014-02-24-8f616a6e-24831-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 12.743ms · Data source: mySociety Data