home / regmem

items

Data source: mySociety Data

13 rows where record_id = "2012-02-20-84642823-10312-0" sorted by sort_order

View and edit SQL

hash item category_id date member_id person_id sort_order record_id
3c119a8aa50f537f0e71d80fbc98276cf3336b16 Name of donor: Britt Shaw Gifts, benefits and hospitality (UK) 84642823 2012-02-20 uk.org.publicwhip/member/40303 Bernard Jenkin uk.org.publicwhip/person/10312 0 2012-02-20-84642823-10312-0
c4be0aa7efdc15240b7c932f96ab4f7044d2cc30 Address of donor : private Gifts, benefits and hospitality (UK) 84642823 2012-02-20 uk.org.publicwhip/member/40303 Bernard Jenkin uk.org.publicwhip/person/10312 1 2012-02-20-84642823-10312-0
e7ad5c744dc35245de61d50d92841887d3595669 Amount of donation or nature and value if donation in kind: one ticket to Conservative Black and White Party; value £1,000 Gifts, benefits and hospitality (UK) 84642823 2012-02-20 uk.org.publicwhip/member/40303 Bernard Jenkin uk.org.publicwhip/person/10312 2 2012-02-20-84642823-10312-0
791934734ba8ac424c7cd6b76caf500a7981aa98 Date of receipt of donation: 7 February 2011 Gifts, benefits and hospitality (UK) 84642823 2012-02-20 uk.org.publicwhip/member/40303 Bernard Jenkin uk.org.publicwhip/person/10312 3 2012-02-20-84642823-10312-0
a8b01c549e41f8e0f65e42dd8f4beb12ccc7af21 Date of acceptance of donation: 7 February 2011 Gifts, benefits and hospitality (UK) 84642823 2012-02-20 uk.org.publicwhip/member/40303 Bernard Jenkin uk.org.publicwhip/person/10312 4 2012-02-20-84642823-10312-0
9b8a78d2c188a7456e5d7518ff1883d1436f4a0f (Registered 3 March 2011) Gifts, benefits and hospitality (UK) 84642823 2012-02-20 uk.org.publicwhip/member/40303 Bernard Jenkin uk.org.publicwhip/person/10312 6 2012-02-20-84642823-10312-0
d321ad45b2145dc028bf4c99211c5228b9fad658 Name of donor: Yvelin Black Gifts, benefits and hospitality (UK) 84642823 2012-02-20 uk.org.publicwhip/member/40303 Bernard Jenkin uk.org.publicwhip/person/10312 7 2012-02-20-84642823-10312-0
965aac2924a6cef5d5c62b06de18778fedd02d56 Address of donor: private Gifts, benefits and hospitality (UK) 84642823 2012-02-20 uk.org.publicwhip/member/40303 Bernard Jenkin uk.org.publicwhip/person/10312 8 2012-02-20-84642823-10312-0
ff6b6eed2fd857d509d724af09510a44a8ffca76 Amount of donation or nature and value if donation in kind: Ticket to Conservative summer party, value £1,000 Gifts, benefits and hospitality (UK) 84642823 2012-02-20 uk.org.publicwhip/member/40303 Bernard Jenkin uk.org.publicwhip/person/10312 9 2012-02-20-84642823-10312-0
2e44650d4a350185f9b4770a548598905eba7408 Date of receipt of donation: 6 June 2011 Gifts, benefits and hospitality (UK) 84642823 2012-02-20 uk.org.publicwhip/member/40303 Bernard Jenkin uk.org.publicwhip/person/10312 10 2012-02-20-84642823-10312-0
e8517518dd7aa14b57fb826e4d6d20db8dd43630 Date of acceptance of donation: 6 June 2011 Gifts, benefits and hospitality (UK) 84642823 2012-02-20 uk.org.publicwhip/member/40303 Bernard Jenkin uk.org.publicwhip/person/10312 11 2012-02-20-84642823-10312-0
00055ae6b2212e73b7873364f51c3e351f01e194 Donor status: individual Gifts, benefits and hospitality (UK) 84642823 2012-02-20 uk.org.publicwhip/member/40303 Bernard Jenkin uk.org.publicwhip/person/10312 12 2012-02-20-84642823-10312-0
5324a9d7e270ff26d2b792a513cc4b1356d9dc23 (Registered 7 July 2011) Gifts, benefits and hospitality (UK) 84642823 2012-02-20 uk.org.publicwhip/member/40303 Bernard Jenkin uk.org.publicwhip/person/10312 13 2012-02-20-84642823-10312-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.447ms · Data source: mySociety Data