home / regmem

items

Data source: mySociety Data

10 rows where record_id = "2014-04-28-8f616a6e-24762-0" sorted by sort_order

View and edit SQL

hash item category_id date member_id person_id sort_order record_id
dbc0d20e78016be05f504e5387e5de485146a06a Donations to my constituency party or association, which have been or will be reported by my party to the Electoral Commission: Sponsorships 8f616a6e 2014-04-28 uk.org.publicwhip/member/40057 Michael Dugher uk.org.publicwhip/person/24762 0 2014-04-28-8f616a6e-24762-0
7bf60d239a0acceedb63a98502cc29c33359c50b Name of donor: Barnsley East CLP Sponsorships 8f616a6e 2014-04-28 uk.org.publicwhip/member/40057 Michael Dugher uk.org.publicwhip/person/24762 1 2014-04-28-8f616a6e-24762-0
33c13bc963d70fb51c1fd2063117f55441849de3 Address of donor: 26 Newsome Road, Wombwell, Barnsley S73 8QS Sponsorships 8f616a6e 2014-04-28 uk.org.publicwhip/member/40057 Michael Dugher uk.org.publicwhip/person/24762 2 2014-04-28-8f616a6e-24762-0
0002bdab410818c5123d9cfbf548ef956c2747dc Amount of donation or nature and value if donation in kind: £10,006; money raised between 12 June 2013 and 5 August 2013 in respect of a fundraising event held on 12 June 2013 for the benefit of Barnsley East Constituency Labour Party (CLP) and the CLP of another Labour MP (£5,003 each). The money raised included one registrable donation as set out below. Part of the money will be donated to two other CLPs. Sponsorships 8f616a6e 2014-04-28 uk.org.publicwhip/member/40057 Michael Dugher uk.org.publicwhip/person/24762 3 2014-04-28-8f616a6e-24762-0
29888f604e3d668d505a0a2fd19d84451b75572e Donor status: unincorporated association Sponsorships 8f616a6e 2014-04-28 uk.org.publicwhip/member/40057 Michael Dugher uk.org.publicwhip/person/24762 4 2014-04-28-8f616a6e-24762-0
476754eb38e5d96306d1cbc368dce34f0e7c5c7a Name of donor: Mr Graham Cole Sponsorships 8f616a6e 2014-04-28 uk.org.publicwhip/member/40057 Michael Dugher uk.org.publicwhip/person/24762 6 2014-04-28-8f616a6e-24762-0
245a769998d2e930dce04fee43694d87b321ad0c Address of donor: private Sponsorships 8f616a6e 2014-04-28 uk.org.publicwhip/member/40057 Michael Dugher uk.org.publicwhip/person/24762 7 2014-04-28-8f616a6e-24762-0
86ce287788b271930fcdce0aab352f9aa638d5d6 Amount of donation or nature and value if donation in kind: £2,300 received on 5 August 2013 as the only registrable donation from a funding raising event held on 12 June 2013 for the benefit of Barnsley East CLP (£1,150) and the CLP of another Labour MP (£1,150). Sponsorships 8f616a6e 2014-04-28 uk.org.publicwhip/member/40057 Michael Dugher uk.org.publicwhip/person/24762 8 2014-04-28-8f616a6e-24762-0
c3a525e1475afd280cdd928ed5af14756667716f Donor status: individual Sponsorships 8f616a6e 2014-04-28 uk.org.publicwhip/member/40057 Michael Dugher uk.org.publicwhip/person/24762 9 2014-04-28-8f616a6e-24762-0
f4f7916f0b1603f676530b8c8353543bdf3e942f (Registered 28 August 2013) Sponsorships 8f616a6e 2014-04-28 uk.org.publicwhip/member/40057 Michael Dugher uk.org.publicwhip/person/24762 10 2014-04-28-8f616a6e-24762-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 57.767ms · Data source: mySociety Data