home / regmem

items

Data source: mySociety Data

8 rows where record_id = "2014-04-28-9e46def6-10023-0" sorted by sort_order

View and edit SQL

hash item category_id date member_id person_id sort_order record_id
63cd2ca81baebe17b946db00242431fc75bfd4f1 Support in the capacity as an MP: Sponsorship or financial or material support 9e46def6 2014-04-28 uk.org.publicwhip/member/40053 Tony Baldry uk.org.publicwhip/person/10023 0 2014-04-28-9e46def6-10023-0
452541603cb173ec9d13506922780fc301565d61 Name of donor: Lighting Industry Association Limited Sponsorship or financial or material support 9e46def6 2014-04-28 uk.org.publicwhip/member/40053 Tony Baldry uk.org.publicwhip/person/10023 1 2014-04-28-9e46def6-10023-0
952c9c83e11fb27bd460425e722cb6120b7d421e Address of donor: Ground Floor, Westminster Tower, 3 Albert Embankment, London SE1 7SL Sponsorship or financial or material support 9e46def6 2014-04-28 uk.org.publicwhip/member/40053 Tony Baldry uk.org.publicwhip/person/10023 2 2014-04-28-9e46def6-10023-0
d568dfa4926b307ad669a5801e92ef500d6f2a16 Amount of donation or nature and value if donation in kind: I employ a research assistant who receives £700 per month direct from the Lighting Industry Association Limited, solely in connection with work that she does in support of the Associate All-Party Lighting Group. Sponsorship or financial or material support 9e46def6 2014-04-28 uk.org.publicwhip/member/40053 Tony Baldry uk.org.publicwhip/person/10023 3 2014-04-28-9e46def6-10023-0
0004e155c2cca8eab79663d389f53e42d880a0bc Date of receipt: ongoing since May 2011 Sponsorship or financial or material support 9e46def6 2014-04-28 uk.org.publicwhip/member/40053 Tony Baldry uk.org.publicwhip/person/10023 4 2014-04-28-9e46def6-10023-0
5fdb2987b72a72c2e1067566ace1dcdda9a839a0 Date of acceptance: May 2011 Sponsorship or financial or material support 9e46def6 2014-04-28 uk.org.publicwhip/member/40053 Tony Baldry uk.org.publicwhip/person/10023 5 2014-04-28-9e46def6-10023-0
a068e8a46a787c6b0a3210b9ae8e0bdc1de25871 Donor status: company, registration 0604111 Sponsorship or financial or material support 9e46def6 2014-04-28 uk.org.publicwhip/member/40053 Tony Baldry uk.org.publicwhip/person/10023 6 2014-04-28-9e46def6-10023-0
9bb61e9ac70cd5c12ea8fc94272cbdb77ad785c7 (Registered 17 May 2011; updated 18 January 2013; updated 20 January 2014) Sponsorship or financial or material support 9e46def6 2014-04-28 uk.org.publicwhip/member/40053 Tony Baldry uk.org.publicwhip/person/10023 7 2014-04-28-9e46def6-10023-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 34.546ms · Data source: mySociety Data