home / regmem

items

Data source: mySociety Data

9 rows where record_id = "2011-02-07-8f616a6e-24745-0" sorted by sort_order

View and edit SQL

hash item category_id date member_id person_id sort_order record_id
a15c9fa41b465faacbc17fa75f124461e39f4eda Name of donor: Carlton Club Sponsorships 8f616a6e 2011-02-07 uk.org.publicwhip/member/40463 Marcus Jones uk.org.publicwhip/person/24745 0 2011-02-07-8f616a6e-24745-0
dedc8fd14c42ea1b4d04dd60531fd7915593f178 Address of donor: 69 St James’s Street, London SW1A 1PJ. Sponsorships 8f616a6e 2011-02-07 uk.org.publicwhip/member/40463 Marcus Jones uk.org.publicwhip/person/24745 1 2011-02-07-8f616a6e-24745-0
d9c8e26e1889d5aaa4c95b06d440549acdf89a03 Amount of donation or nature and value if donation in kind: £11,000. Sponsorships 8f616a6e 2011-02-07 uk.org.publicwhip/member/40463 Marcus Jones uk.org.publicwhip/person/24745 2 2011-02-07-8f616a6e-24745-0
c3f881893e927bc30aab6674729d92d45bbbbc3e Donor status: members’ club Sponsorships 8f616a6e 2011-02-07 uk.org.publicwhip/member/40463 Marcus Jones uk.org.publicwhip/person/24745 3 2011-02-07-8f616a6e-24745-0
c1cfc6990d405f6823ab7a9d0b4d0c085fa57dc7 Name of donor: Stalbury Trustees Sponsorships 8f616a6e 2011-02-07 uk.org.publicwhip/member/40463 Marcus Jones uk.org.publicwhip/person/24745 5 2011-02-07-8f616a6e-24745-0
4c1ee8e3c102c9f8f482b98835f219face398056 Address of donor: 31 Hill Street, London W1J 5LS. Sponsorships 8f616a6e 2011-02-07 uk.org.publicwhip/member/40463 Marcus Jones uk.org.publicwhip/person/24745 6 2011-02-07-8f616a6e-24745-0
1f18d33e5504d5979fbbf3ec3dde181d3fcf13c9 Amount of donation or nature and value if donation in kind: £3,000. This cash donation was made to the constituency association, which will report it to the Electoral Commission. Sponsorships 8f616a6e 2011-02-07 uk.org.publicwhip/member/40463 Marcus Jones uk.org.publicwhip/person/24745 7 2011-02-07-8f616a6e-24745-0
00026ba4dcb03693a68712e557924095f78b47d5 Donor status: trust, registration number 01430799 Sponsorships 8f616a6e 2011-02-07 uk.org.publicwhip/member/40463 Marcus Jones uk.org.publicwhip/person/24745 8 2011-02-07-8f616a6e-24745-0
f9cd5dc2cd41f0e69e777bb621136f3da67dc5a0 (Registered 20 May 2010) Sponsorships 8f616a6e 2011-02-07 uk.org.publicwhip/member/40463 Marcus Jones uk.org.publicwhip/person/24745 9 2011-02-07-8f616a6e-24745-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 64.322ms · Data source: mySociety Data