home / regmem

items

Data source: mySociety Data

7 rows where record_id = "2013-05-20-84642823-24913-0" sorted by sort_order

View and edit SQL

hash item category_id date member_id person_id sort_order record_id
0438764c26e5ac11a103c680d6928b58e7646745 Name of donor: Pernod Ricard UK Gifts, benefits and hospitality (UK) 84642823 2013-05-20 uk.org.publicwhip/member/40115 Mary Macleod uk.org.publicwhip/person/24913 0 2013-05-20-84642823-24913-0
ebee7388f7874de071476470b2f3d62e41926b4f Address of donor : Central House, 3 Lampton Road, Hounslow, Middlesex TW3 1HY Gifts, benefits and hospitality (UK) 84642823 2013-05-20 uk.org.publicwhip/member/40115 Mary Macleod uk.org.publicwhip/person/24913 1 2013-05-20-84642823-24913-0
fb3b495431ddbc4c04fa3f49cc1cf31f9eaaf4cf Amount of donation or nature and value if donation in kind: hospitality ticket to Wimbledon tennis; value £1,000 Gifts, benefits and hospitality (UK) 84642823 2013-05-20 uk.org.publicwhip/member/40115 Mary Macleod uk.org.publicwhip/person/24913 2 2013-05-20-84642823-24913-0
0004fe041a1d9ef8ea8103ed2b201e381834d417 Date of receipt of donation: 30 June 2012 Gifts, benefits and hospitality (UK) 84642823 2013-05-20 uk.org.publicwhip/member/40115 Mary Macleod uk.org.publicwhip/person/24913 3 2013-05-20-84642823-24913-0
a8de2ec74fd268d0dcad46c3a9e610d0a69b92e2 Date of acceptance of donation: 30 June 2012 Gifts, benefits and hospitality (UK) 84642823 2013-05-20 uk.org.publicwhip/member/40115 Mary Macleod uk.org.publicwhip/person/24913 4 2013-05-20-84642823-24913-0
95ba68d41382b31d3347a6bd23516a758289eefe Donor status: company, registration number 1870414 Gifts, benefits and hospitality (UK) 84642823 2013-05-20 uk.org.publicwhip/member/40115 Mary Macleod uk.org.publicwhip/person/24913 5 2013-05-20-84642823-24913-0
828a35898bb3e1f1c3863ec0ed38eb261fd07df4 (Registered 11 July 2012) Gifts, benefits and hospitality (UK) 84642823 2013-05-20 uk.org.publicwhip/member/40115 Mary Macleod uk.org.publicwhip/person/24913 6 2013-05-20-84642823-24913-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 73.994ms · Data source: mySociety Data