home / regmem

items

Data source: mySociety Data

20 rows where record_id = "2011-12-13-84642823-24811-0" sorted by sort_order

View and edit SQL

hash item category_id date member_id person_id sort_order record_id
f7b3ee183a6ce04a301e95cf177d1539873dafcb Name of donor: ITV Gifts, benefits and hospitality (UK) 84642823 2011-12-13 uk.org.publicwhip/member/40048 Gloria De Piero uk.org.publicwhip/person/24811 0 2011-12-13-84642823-24811-0
bc0b9174f57c60d4509c4d070d539703042e7afa Address of donor : London Television Centre, Upper Ground, London SE1 9LT Gifts, benefits and hospitality (UK) 84642823 2011-12-13 uk.org.publicwhip/member/40048 Gloria De Piero uk.org.publicwhip/person/24811 1 2011-12-13-84642823-24811-0
1ca960d035fb1afba3c8fd42db2c15ef2b2335f0 Amount of donation or nature and value if donation in kind: ticket and hospitality at the National Television Awards; value £662.46 Gifts, benefits and hospitality (UK) 84642823 2011-12-13 uk.org.publicwhip/member/40048 Gloria De Piero uk.org.publicwhip/person/24811 2 2011-12-13-84642823-24811-0
1bcc286928adda8f0b666b294666b37647f8bae3 Date of receipt of donation: 26 January 2011 Gifts, benefits and hospitality (UK) 84642823 2011-12-13 uk.org.publicwhip/member/40048 Gloria De Piero uk.org.publicwhip/person/24811 3 2011-12-13-84642823-24811-0
1e79c344a9adf7211a536d0306cbb11e12a11591 Date of acceptance of donation: 26 January 2011 Gifts, benefits and hospitality (UK) 84642823 2011-12-13 uk.org.publicwhip/member/40048 Gloria De Piero uk.org.publicwhip/person/24811 4 2011-12-13-84642823-24811-0
8de83914fdc361642e80ebd62d2789f3953e34e8 Donor status: company, registration number 4967001 Gifts, benefits and hospitality (UK) 84642823 2011-12-13 uk.org.publicwhip/member/40048 Gloria De Piero uk.org.publicwhip/person/24811 5 2011-12-13-84642823-24811-0
506305f76911e12fd04722caceec3c5e95494a30 Name of donor: UK Music Gifts, benefits and hospitality (UK) 84642823 2011-12-13 uk.org.publicwhip/member/40048 Gloria De Piero uk.org.publicwhip/person/24811 7 2011-12-13-84642823-24811-0
182d8eb23f20b00d2083afb76c4b9e52f73613ec Address of donor : 26 Berners Street, London W1T 3LR Gifts, benefits and hospitality (UK) 84642823 2011-12-13 uk.org.publicwhip/member/40048 Gloria De Piero uk.org.publicwhip/person/24811 8 2011-12-13-84642823-24811-0
c82d7032089ff9c3eea436186a61395d34289a08 Amount of donation or nature and value if donation in kind: ticket and hospitality at the BRIT Awards; value £850 Gifts, benefits and hospitality (UK) 84642823 2011-12-13 uk.org.publicwhip/member/40048 Gloria De Piero uk.org.publicwhip/person/24811 9 2011-12-13-84642823-24811-0
3e4f77352a34b26084374c2edcebf30bad04fa17 Date of receipt of donation: 15 February 2011 Gifts, benefits and hospitality (UK) 84642823 2011-12-13 uk.org.publicwhip/member/40048 Gloria De Piero uk.org.publicwhip/person/24811 10 2011-12-13-84642823-24811-0
9325ec5dbb9302a0df48555564f490103e4d6c7d Date of acceptance of donation: 15 February 2011 Gifts, benefits and hospitality (UK) 84642823 2011-12-13 uk.org.publicwhip/member/40048 Gloria De Piero uk.org.publicwhip/person/24811 11 2011-12-13-84642823-24811-0
692bae92b325354af53dae5413004b5bb63d7369 Donor status: company, registration number 3245288 Gifts, benefits and hospitality (UK) 84642823 2011-12-13 uk.org.publicwhip/member/40048 Gloria De Piero uk.org.publicwhip/person/24811 12 2011-12-13-84642823-24811-0
6286781cff1da078d94fa2a85f27b0c6c440c3a3 (Registered 4 March 2011) Gifts, benefits and hospitality (UK) 84642823 2011-12-13 uk.org.publicwhip/member/40048 Gloria De Piero uk.org.publicwhip/person/24811 13 2011-12-13-84642823-24811-0
ba87419311daf44cb96379bf9f416e6b723fcdad Name of donor: Time Warner Ltd Gifts, benefits and hospitality (UK) 84642823 2011-12-13 uk.org.publicwhip/member/40048 Gloria De Piero uk.org.publicwhip/person/24811 14 2011-12-13-84642823-24811-0
0016bfc69a309bb258dc05c15281cb5abd3fc19f Address of donor : 44 GreatMarlborough Street, London W1F 7JL Gifts, benefits and hospitality (UK) 84642823 2011-12-13 uk.org.publicwhip/member/40048 Gloria De Piero uk.org.publicwhip/person/24811 15 2011-12-13-84642823-24811-0
261682f8dacac1abfe092dfb79af3ed646245d04 Amount of donation or nature and value if donation in kind: ticket and hospitality at the Orange British Academy Film Awards; value £700 Gifts, benefits and hospitality (UK) 84642823 2011-12-13 uk.org.publicwhip/member/40048 Gloria De Piero uk.org.publicwhip/person/24811 16 2011-12-13-84642823-24811-0
fe569932c917e89c38ef766ef5180313420ed09f Date of receipt of donation: 13 February 2011 Gifts, benefits and hospitality (UK) 84642823 2011-12-13 uk.org.publicwhip/member/40048 Gloria De Piero uk.org.publicwhip/person/24811 17 2011-12-13-84642823-24811-0
61d588b42d55c6f0b0cb5256bf4d7468d42357dc Date of acceptance of donation: 13 February 2011 Gifts, benefits and hospitality (UK) 84642823 2011-12-13 uk.org.publicwhip/member/40048 Gloria De Piero uk.org.publicwhip/person/24811 18 2011-12-13-84642823-24811-0
af9a01259e8f551235986643d9ac68044c246da9 Donor status: company, registration number 02713670 Gifts, benefits and hospitality (UK) 84642823 2011-12-13 uk.org.publicwhip/member/40048 Gloria De Piero uk.org.publicwhip/person/24811 19 2011-12-13-84642823-24811-0
646d737efc2b1174aaedaa25a1c2a1cd9a45afda (Registered 8 March 2011) Gifts, benefits and hospitality (UK) 84642823 2011-12-13 uk.org.publicwhip/member/40048 Gloria De Piero uk.org.publicwhip/person/24811 20 2011-12-13-84642823-24811-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 5.035ms · Data source: mySociety Data