home / regmem

items

Data source: mySociety Data

6 rows where record_id = "2012-01-13-8f616a6e-11032-0" sorted by sort_order

View and edit SQL

hash item category_id date member_id person_id sort_order record_id
0001cf91a0d6ec9f8aaa530dcbb1befb5cd6d45e Donations to my constituency party or association, which have been or will be reported by my party to the Electoral Commission: Sponsorships 8f616a6e 2012-01-13 uk.org.publicwhip/member/40443 Norman Lamb uk.org.publicwhip/person/11032 0 2012-01-13-8f616a6e-11032-0
c5c96aec4f484f6e1b3bc97e710f55ccc8696365 Name of donor: Ardeshir Naghshineh Sponsorships 8f616a6e 2012-01-13 uk.org.publicwhip/member/40443 Norman Lamb uk.org.publicwhip/person/11032 1 2012-01-13-8f616a6e-11032-0
db3ededed4ef552dc453134d6c7c19299f2cdff4 Address of donor: private Sponsorships 8f616a6e 2012-01-13 uk.org.publicwhip/member/40443 Norman Lamb uk.org.publicwhip/person/11032 2 2012-01-13-8f616a6e-11032-0
4077ca9461e7b0f019e537b4d549633ebfba179b Amount of donation or nature and value if donation in kind: £10,000 Sponsorships 8f616a6e 2012-01-13 uk.org.publicwhip/member/40443 Norman Lamb uk.org.publicwhip/person/11032 3 2012-01-13-8f616a6e-11032-0
114fc982b7bc72fb98dbd166935f82a0c86ebb7c Donor status: individual Sponsorships 8f616a6e 2012-01-13 uk.org.publicwhip/member/40443 Norman Lamb uk.org.publicwhip/person/11032 4 2012-01-13-8f616a6e-11032-0
f3ef003ce73f610f391c4393b10540b176bf86e7 (Registered 10 October 2011) Sponsorships 8f616a6e 2012-01-13 uk.org.publicwhip/member/40443 Norman Lamb uk.org.publicwhip/person/11032 5 2012-01-13-8f616a6e-11032-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 23.055ms · Data source: mySociety Data