home / regmem

items

Data source: mySociety Data

6 rows where record_id = "2012-03-05-8f616a6e-11362-0" sorted by sort_order

View and edit SQL

hash item category_id date member_id person_id sort_order record_id
517b201abaeb25f927245aa0da0b500dcf40c5d4 Support in the capacity as an MP: Sponsorships 8f616a6e 2012-03-05 uk.org.publicwhip/member/40302 Iain Wright uk.org.publicwhip/person/11362 0 2012-03-05-8f616a6e-11362-0
23c96304856c5bd67f37df17aaef03a5b44eb743 Name of donor: Hartlepool Constituency Labour Party Sponsorships 8f616a6e 2012-03-05 uk.org.publicwhip/member/40302 Iain Wright uk.org.publicwhip/person/11362 1 2012-03-05-8f616a6e-11362-0
84e2fc16a59cd2aaf427859f5d759c26b31fb6a0 Address of donor: 23 South Road, Hartlepool TS26 9HD Sponsorships 8f616a6e 2012-03-05 uk.org.publicwhip/member/40302 Iain Wright uk.org.publicwhip/person/11362 2 2012-03-05-8f616a6e-11362-0
aa3bb4e893f580f93cedc210fdd29d51a84d255f Amount of donation or nature and value if donation in kind: £3,200 received by my constituency party, raised through ticket sales, raffle, auction and donations at a fundraising dinner. No individual donation exceeded £1,500. Sponsorships 8f616a6e 2012-03-05 uk.org.publicwhip/member/40302 Iain Wright uk.org.publicwhip/person/11362 3 2012-03-05-8f616a6e-11362-0
0001e9913865795ea75da7238437a6394670669e Donor status: fundraising event Sponsorships 8f616a6e 2012-03-05 uk.org.publicwhip/member/40302 Iain Wright uk.org.publicwhip/person/11362 4 2012-03-05-8f616a6e-11362-0
660437a4ec45b3567d603ad2f812dce915d63749 (Registered 28 February 2012) Sponsorships 8f616a6e 2012-03-05 uk.org.publicwhip/member/40302 Iain Wright uk.org.publicwhip/person/11362 5 2012-03-05-8f616a6e-11362-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 82.304ms · Data source: mySociety Data