home / regmem

items

Data source: mySociety Data

11 rows where record_id = "2013-06-10-8f616a6e-24886-0" sorted by sort_order

View and edit SQL

hash item category_id date member_id person_id sort_order record_id
1712a0602b1b97be98dea13b86b4f91277264f48 Donations to my constituency party or association, which have been or will be reported by my party to the Electoral Commission: Sponsorships 8f616a6e 2013-06-10 uk.org.publicwhip/member/40670 Paul Uppal uk.org.publicwhip/person/24886 0 2013-06-10-8f616a6e-24886-0
da7ad46510a16280dcfbf7590b5fe93f7f0d3542 Name of donor: Sun Mark Ltd Sponsorships 8f616a6e 2013-06-10 uk.org.publicwhip/member/40670 Paul Uppal uk.org.publicwhip/person/24886 1 2013-06-10-8f616a6e-24886-0
5d87154fa362a054d8bd7ba80103fcab78b0533b Address of donor: 428 Long Drive, Greenford, Middlesex UB6 8UH Sponsorships 8f616a6e 2013-06-10 uk.org.publicwhip/member/40670 Paul Uppal uk.org.publicwhip/person/24886 2 2013-06-10-8f616a6e-24886-0
551f9b5b222f1a8d65c0a707d6d943e160789a01 Amount of donation or nature and value if donation in kind: £15,000 Sponsorships 8f616a6e 2013-06-10 uk.org.publicwhip/member/40670 Paul Uppal uk.org.publicwhip/person/24886 3 2013-06-10-8f616a6e-24886-0
049d8d10db5b139f61feb0c424a3286b2e36c402 Donor status: company Sponsorships 8f616a6e 2013-06-10 uk.org.publicwhip/member/40670 Paul Uppal uk.org.publicwhip/person/24886 4 2013-06-10-8f616a6e-24886-0
32f3c401eaee4aa8f4762dee6ad90012d936630f (Registered 28 February 2013) Sponsorships 8f616a6e 2013-06-10 uk.org.publicwhip/member/40670 Paul Uppal uk.org.publicwhip/person/24886 5 2013-06-10-8f616a6e-24886-0
2547155a3d638935d574cd0fab251703bfd42a34 Name of donor: Mr Paul Brett Sponsorships 8f616a6e 2013-06-10 uk.org.publicwhip/member/40670 Paul Uppal uk.org.publicwhip/person/24886 6 2013-06-10-8f616a6e-24886-0
64f072ce9cc1a123e5cf2074570b5867ed48b83b Address of donor: private Sponsorships 8f616a6e 2013-06-10 uk.org.publicwhip/member/40670 Paul Uppal uk.org.publicwhip/person/24886 7 2013-06-10-8f616a6e-24886-0
00031aee39a8ce739eeb57393ace1f0d43126981 Amount of donation or nature and value if donation in kind: £12,000 Sponsorships 8f616a6e 2013-06-10 uk.org.publicwhip/member/40670 Paul Uppal uk.org.publicwhip/person/24886 8 2013-06-10-8f616a6e-24886-0
19fa967c8141722e5f6679a5acc485f5b86604db Donor status: individual Sponsorships 8f616a6e 2013-06-10 uk.org.publicwhip/member/40670 Paul Uppal uk.org.publicwhip/person/24886 9 2013-06-10-8f616a6e-24886-0
c9fdaca1e702a2b3d4ff9f2df2759abacdf1b1f0 (Registered 30 May 2013) Sponsorships 8f616a6e 2013-06-10 uk.org.publicwhip/member/40670 Paul Uppal uk.org.publicwhip/person/24886 10 2013-06-10-8f616a6e-24886-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 47.679ms · Data source: mySociety Data