home / regmem

items

Data source: mySociety Data

7 rows where record_id = "2011-06-20-80ef1083-24913-0" sorted by sort_order

View and edit SQL

hash item category_id date member_id person_id sort_order record_id
d5f8b8e19cc83209e83e22044ccb8d65ae0d7154 Name of donor: Great Britain China Centre Overseas visits 80ef1083 2011-06-20 uk.org.publicwhip/member/40115 Mary Macleod uk.org.publicwhip/person/24913 0 2011-06-20-80ef1083-24913-0
bd84df54c6b79ee571079c2c08e33d2118be2d64 Address of donor: 15 Belgrave Square, London SW1X 8PS Overseas visits 80ef1083 2011-06-20 uk.org.publicwhip/member/40115 Mary Macleod uk.org.publicwhip/person/24913 1 2011-06-20-80ef1083-24913-0
eb602c93dbe7b2726e724e876f8ed795e8518da6 Amount of donation (or estimate of the probable value): £4,623 Overseas visits 80ef1083 2011-06-20 uk.org.publicwhip/member/40115 Mary Macleod uk.org.publicwhip/person/24913 2 2011-06-20-80ef1083-24913-0
f225839121060698c7c5d807c415b9643363a31a Destination of visit: Beijing, China Overseas visits 80ef1083 2011-06-20 uk.org.publicwhip/member/40115 Mary Macleod uk.org.publicwhip/person/24913 3 2011-06-20-80ef1083-24913-0
5e8b0691fb268164ea6b1cc54f4b3752fb9dbf28 Date of visit: 13-17 September 2010 Overseas visits 80ef1083 2011-06-20 uk.org.publicwhip/member/40115 Mary Macleod uk.org.publicwhip/person/24913 4 2011-06-20-80ef1083-24913-0
a5bd4f0f849107cb085108fcb7003af2ca995d5c Purpose of visit: to attend annual Leadership Forum with the Chinese Communist Party for political leaders in China and UK and associated activities Overseas visits 80ef1083 2011-06-20 uk.org.publicwhip/member/40115 Mary Macleod uk.org.publicwhip/person/24913 5 2011-06-20-80ef1083-24913-0
0002a19ddcbb799cb21c58b9f3abd2bfe977cf3c (Registered 1 November 2010) Overseas visits 80ef1083 2011-06-20 uk.org.publicwhip/member/40115 Mary Macleod uk.org.publicwhip/person/24913 6 2011-06-20-80ef1083-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 99.588ms · Data source: mySociety Data