home / regmem

items

Data source: mySociety Data

14 rows where record_id = "2011-12-13-84642823-10240-0" sorted by sort_order

View and edit SQL

hash item category_id date member_id person_id sort_order record_id
36aa34ea06351d9e1537b2964ed884d8e210c917 Name of donor: First Great Western Gifts, benefits and hospitality (UK) 84642823 2011-12-13 uk.org.publicwhip/member/40455 James Gray uk.org.publicwhip/person/10240 0 2011-12-13-84642823-10240-0
300967dac2695a72a56e75ae5d655891835661d8 Address of donor : c/o APCOA Parking, PO Box 1010, Uxbridge UB8 9NT Gifts, benefits and hospitality (UK) 84642823 2011-12-13 uk.org.publicwhip/member/40455 James Gray uk.org.publicwhip/person/10240 1 2011-12-13-84642823-10240-0
41783c606db6d8c28b1907cec3d21796577ce125 Amount of donation or nature and value if donation in kind: 12 month season ticket for car parking at Chippenham Station; value £860 Gifts, benefits and hospitality (UK) 84642823 2011-12-13 uk.org.publicwhip/member/40455 James Gray uk.org.publicwhip/person/10240 2 2011-12-13-84642823-10240-0
8ab9e3d41dfd1a7e4248f1af5940b8bdebd6c103 Date of receipt of donation: 12 October 2010 Gifts, benefits and hospitality (UK) 84642823 2011-12-13 uk.org.publicwhip/member/40455 James Gray uk.org.publicwhip/person/10240 3 2011-12-13-84642823-10240-0
00111e7760bab2d1680fe230f9e3a5ea571686e9 Date of acceptance of donation: 12 October 2010 Gifts, benefits and hospitality (UK) 84642823 2011-12-13 uk.org.publicwhip/member/40455 James Gray uk.org.publicwhip/person/10240 4 2011-12-13-84642823-10240-0
7825f249176efbe6d64abf8ec0e61276268d39ae Donor status: company, registration number 2572947 Gifts, benefits and hospitality (UK) 84642823 2011-12-13 uk.org.publicwhip/member/40455 James Gray uk.org.publicwhip/person/10240 5 2011-12-13-84642823-10240-0
3d18c09e969dbed846c72fd4525db06101d085dc (Registered 30 November 2010) Gifts, benefits and hospitality (UK) 84642823 2011-12-13 uk.org.publicwhip/member/40455 James Gray uk.org.publicwhip/person/10240 6 2011-12-13-84642823-10240-0
b274f72e3faff10892ffb39218aa3304db90f96b Name of donor: JTI – Japan Tobacco International Gifts, benefits and hospitality (UK) 84642823 2011-12-13 uk.org.publicwhip/member/40455 James Gray uk.org.publicwhip/person/10240 7 2011-12-13-84642823-10240-0
bbd9c24d4841e703eb96a34766b66cbc1ef8b3fd Address of donor : Members Hill, Brooklands Road, Weybridge, Surrey KT13 0QU Gifts, benefits and hospitality (UK) 84642823 2011-12-13 uk.org.publicwhip/member/40455 James Gray uk.org.publicwhip/person/10240 8 2011-12-13-84642823-10240-0
105b33659b739aa14f2e0cdda52e32f64eb07af2 Amount of donation or nature and value if donation in kind: my wife and I were guests of JTI at the Chelsea Flower Show. Total value £1,132.80 Gifts, benefits and hospitality (UK) 84642823 2011-12-13 uk.org.publicwhip/member/40455 James Gray uk.org.publicwhip/person/10240 9 2011-12-13-84642823-10240-0
4a19c3550f9b2a06d42a71732c9f6a57c1382646 Date of receipt of donation: 24 May 2011 Gifts, benefits and hospitality (UK) 84642823 2011-12-13 uk.org.publicwhip/member/40455 James Gray uk.org.publicwhip/person/10240 10 2011-12-13-84642823-10240-0
f9ff686d86656c89889972e50a6a1a64ac59bff1 Date of acceptance of donation: 24 May 2011 Gifts, benefits and hospitality (UK) 84642823 2011-12-13 uk.org.publicwhip/member/40455 James Gray uk.org.publicwhip/person/10240 11 2011-12-13-84642823-10240-0
1d8d47af24ba350aec3478fb960291a0945e6fbd Donor status: company, registration number 01501573 Gifts, benefits and hospitality (UK) 84642823 2011-12-13 uk.org.publicwhip/member/40455 James Gray uk.org.publicwhip/person/10240 12 2011-12-13-84642823-10240-0
2648460d73317e137cfe67d2637a8ad25e4b0bd1 (Registered 26 May 2011) Gifts, benefits and hospitality (UK) 84642823 2011-12-13 uk.org.publicwhip/member/40455 James Gray uk.org.publicwhip/person/10240 13 2011-12-13-84642823-10240-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.584ms · Data source: mySociety Data