home / regmem

items

Data source: mySociety Data

6 rows where record_id = "2010-09-06-8f616a6e-24916-0" sorted by sort_order

View and edit SQL

hash item category_id date member_id person_id sort_order record_id
abb91e8ea0e55e8d746ebbdef54303d9bb5b592f Donations to the constituency party or association, which have been or will be reported by the party to the Electoral Commission: Sponsorships 8f616a6e 2010-09-06 uk.org.publicwhip/member/40436 Stephen Barclay uk.org.publicwhip/person/24916 0 2010-09-06-8f616a6e-24916-0
6f2d4d6088945ae855a508413958e9f1c3e1b73b Name of donor: Knowles (Transport) Ltd Sponsorships 8f616a6e 2010-09-06 uk.org.publicwhip/member/40436 Stephen Barclay uk.org.publicwhip/person/24916 1 2010-09-06-8f616a6e-24916-0
000386d69d36f2ac1f39525532d11d54a1cd602c Address of donor: New Road, Wimblington, March, Cambridgeshire PE15 0RG. Sponsorships 8f616a6e 2010-09-06 uk.org.publicwhip/member/40436 Stephen Barclay uk.org.publicwhip/person/24916 2 2010-09-06-8f616a6e-24916-0
0adf979dda7d9f89980e6d1b09feffcb36b876e8 Amount of donation or nature and value if donation in kind: £5,000 Sponsorships 8f616a6e 2010-09-06 uk.org.publicwhip/member/40436 Stephen Barclay uk.org.publicwhip/person/24916 3 2010-09-06-8f616a6e-24916-0
df70b845fabdde98996a42a7767c2b19bc53c8cd Donor status: company Sponsorships 8f616a6e 2010-09-06 uk.org.publicwhip/member/40436 Stephen Barclay uk.org.publicwhip/person/24916 4 2010-09-06-8f616a6e-24916-0
82f4e629d2ba06aac15cd859239826086a1010ed (Registered 4 June 2010) Sponsorships 8f616a6e 2010-09-06 uk.org.publicwhip/member/40436 Stephen Barclay uk.org.publicwhip/person/24916 5 2010-09-06-8f616a6e-24916-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 38.261ms · Data source: mySociety Data