home / regmem

items

Data source: mySociety Data

9 rows where record_id = "2010-04-12-84642823-10243-0" sorted by sort_order

View and edit SQL

hash item category_id date member_id person_id sort_order record_id
9f03ba158bdb4e365873c4ac7997cb6eabe37354 My wife and I received tickets for the Conservative Party's 'Black and White Party' on 4 February 2009, paid for by Rainham Steel Co Ltd. (Registered 3 March 2009) Gifts, benefits and hospitality (UK) 84642823 2010-04-12 uk.org.publicwhip/member/1394 Dominic Grieve uk.org.publicwhip/person/10243 0 2010-04-12-84642823-10243-0
b140d1f5ed8b08b6feae441c1aa83e6a9a924fb7 I received a case of wine from Francis Taylor Building (barristers' chambers) as thanks for delivering the Boydell lecture in May 2009. (Registered 20 May 2009) Gifts, benefits and hospitality (UK) 84642823 2010-04-12 uk.org.publicwhip/member/1394 Dominic Grieve uk.org.publicwhip/person/10243 1 2010-04-12-84642823-10243-0
9bd29c8403035d80c66f1354fd6f0ac6ef2b9a04 Name of donor: Mr John Lewis Gifts, benefits and hospitality (UK) 84642823 2010-04-12 uk.org.publicwhip/member/1394 Dominic Grieve uk.org.publicwhip/person/10243 2 2010-04-12-84642823-10243-0
28d114d318624f1561ff116a6d139fa58b10b783 Address of donor : private Gifts, benefits and hospitality (UK) 84642823 2010-04-12 uk.org.publicwhip/member/1394 Dominic Grieve uk.org.publicwhip/person/10243 3 2010-04-12-84642823-10243-0
9a64674877531b811550c65cc371673764e38ad8 Amount of donation or nature and value if donation in kind: tickets for my wife and me to attend the Conservative Party's Summer Party on 17 June 2009. Payment for tickets, to value of £1,600, made directly to the Conservative Party. Gifts, benefits and hospitality (UK) 84642823 2010-04-12 uk.org.publicwhip/member/1394 Dominic Grieve uk.org.publicwhip/person/10243 4 2010-04-12-84642823-10243-0
2936553b2ad5acc36f301546a8bdaffd637384e2 Date of receipt of donation: 17 June 2009 Gifts, benefits and hospitality (UK) 84642823 2010-04-12 uk.org.publicwhip/member/1394 Dominic Grieve uk.org.publicwhip/person/10243 5 2010-04-12-84642823-10243-0
000023653aa7c57c1dbf45ae31530786e4187f6d Date of acceptance of donation: 17 June 2009 Gifts, benefits and hospitality (UK) 84642823 2010-04-12 uk.org.publicwhip/member/1394 Dominic Grieve uk.org.publicwhip/person/10243 6 2010-04-12-84642823-10243-0
c84680a7a228f6b9e19291801d2e5e44b91c18a7 Donor status: individual Gifts, benefits and hospitality (UK) 84642823 2010-04-12 uk.org.publicwhip/member/1394 Dominic Grieve uk.org.publicwhip/person/10243 7 2010-04-12-84642823-10243-0
95974698bb8f89432fc1ca254904167a3092af63 (Registered 14 July 2009 ) Gifts, benefits and hospitality (UK) 84642823 2010-04-12 uk.org.publicwhip/member/1394 Dominic Grieve uk.org.publicwhip/person/10243 8 2010-04-12-84642823-10243-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 89.043ms · Data source: mySociety Data