home / regmem

items

Data source: mySociety Data

14 rows where record_id = "2011-10-31-84642823-24784-0" sorted by sort_order

View and edit SQL

hash item category_id date member_id person_id sort_order record_id
467bae79583fde18e15c1de5ec6de35d78baf15a Name of donor: Martin Darlington Gifts, benefits and hospitality (UK) 84642823 2011-10-31 uk.org.publicwhip/member/40298 Robert Halfon uk.org.publicwhip/person/24784 0 2011-10-31-84642823-24784-0
f75839ccac0cd1e1a0a8c3ba22702830756e5c64 Address of donor : private Gifts, benefits and hospitality (UK) 84642823 2011-10-31 uk.org.publicwhip/member/40298 Robert Halfon uk.org.publicwhip/person/24784 1 2011-10-31-84642823-24784-0
2b8291ffa88f3f3c7628d8271f46da50259c21f3 Amount of donation or nature and value if donation in kind: visit to France in private plane owned by Mr Darlington; value in excess of £660 Gifts, benefits and hospitality (UK) 84642823 2011-10-31 uk.org.publicwhip/member/40298 Robert Halfon uk.org.publicwhip/person/24784 2 2011-10-31-84642823-24784-0
0cf257f9e500bc35a0efb7063010e920e11efef2 Date of receipt of donation: 9 April 2011 Gifts, benefits and hospitality (UK) 84642823 2011-10-31 uk.org.publicwhip/member/40298 Robert Halfon uk.org.publicwhip/person/24784 3 2011-10-31-84642823-24784-0
7ed49796033df060c040cf76482f675dcbf19740 Date of acceptance of donation: 9 April 2011 Gifts, benefits and hospitality (UK) 84642823 2011-10-31 uk.org.publicwhip/member/40298 Robert Halfon uk.org.publicwhip/person/24784 4 2011-10-31-84642823-24784-0
95fea4f0350258a85abe9c455efec9469762d5c6 Donor status: individual Gifts, benefits and hospitality (UK) 84642823 2011-10-31 uk.org.publicwhip/member/40298 Robert Halfon uk.org.publicwhip/person/24784 5 2011-10-31-84642823-24784-0
1d6be7738e1d1a1e7934f9e5465ebfe290c63de2 (Registered 20 May 2011) Gifts, benefits and hospitality (UK) 84642823 2011-10-31 uk.org.publicwhip/member/40298 Robert Halfon uk.org.publicwhip/person/24784 6 2011-10-31-84642823-24784-0
1a39ec3461151741942084041ca8e8007aac8bb1 Name of donor: Conservative Friends of Israel Gifts, benefits and hospitality (UK) 84642823 2011-10-31 uk.org.publicwhip/member/40298 Robert Halfon uk.org.publicwhip/person/24784 7 2011-10-31-84642823-24784-0
1ef006e54829cbec8357ec451255c59b765cd9e4 Address of donor : 45B Westbourne Terrace, London W2 3UR Gifts, benefits and hospitality (UK) 84642823 2011-10-31 uk.org.publicwhip/member/40298 Robert Halfon uk.org.publicwhip/person/24784 8 2011-10-31-84642823-24784-0
00337cff2f6552009690ac0d1f518e0cfd6e4b5f Amount of donation or nature and value if donation in kind: 4 nights hotel accommodation in Manchester during the Conservative Party Conference; value £1,100 Gifts, benefits and hospitality (UK) 84642823 2011-10-31 uk.org.publicwhip/member/40298 Robert Halfon uk.org.publicwhip/person/24784 9 2011-10-31-84642823-24784-0
c67fab2c642e253858153c206dd8af532a883189 Date of receipt of donation: 1 October 2011 Gifts, benefits and hospitality (UK) 84642823 2011-10-31 uk.org.publicwhip/member/40298 Robert Halfon uk.org.publicwhip/person/24784 10 2011-10-31-84642823-24784-0
150e58dff746d6026b4f0c67764e7a8bc6e0e220 Date of acceptance of donation: 1 October 2011 Gifts, benefits and hospitality (UK) 84642823 2011-10-31 uk.org.publicwhip/member/40298 Robert Halfon uk.org.publicwhip/person/24784 11 2011-10-31-84642823-24784-0
40b6c859d74e1029d72cdc6e29b026c1251b1a4c Donor status: Gifts, benefits and hospitality (UK) 84642823 2011-10-31 uk.org.publicwhip/member/40298 Robert Halfon uk.org.publicwhip/person/24784 12 2011-10-31-84642823-24784-0
049b999814ff27051764da2f9d16c9e6aa001ee5 (Registered 31 October 2011) Gifts, benefits and hospitality (UK) 84642823 2011-10-31 uk.org.publicwhip/member/40298 Robert Halfon uk.org.publicwhip/person/24784 13 2011-10-31-84642823-24784-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 4.916ms · Data source: mySociety Data