home / regmem

items

Data source: mySociety Data

14 rows where record_id = "2010-01-06-80ef1083-10522-0" sorted by sort_order

View and edit SQL

hash item category_id date member_id person_id sort_order record_id
5506dfa9d626b87e3a3c8c4819a53656ba16303d Name of donor: Government of Colombia, Ministry of Foreign Affairs Overseas visits 80ef1083 2010-01-06 uk.org.publicwhip/member/1496 Christine Russell uk.org.publicwhip/person/10522 0 2010-01-06-80ef1083-10522-0
f4e32ec1670276929736ba9f3df6c84fe91a6b2b Address of donor: Bogota, Colombia Overseas visits 80ef1083 2010-01-06 uk.org.publicwhip/member/1496 Christine Russell uk.org.publicwhip/person/10522 1 2010-01-06-80ef1083-10522-0
dbcb20ab7bffb74d37b7ce969ce68a35b25fb543 Amount of donation (or estimate of the probable value): £3,000-£4,000 Overseas visits 80ef1083 2010-01-06 uk.org.publicwhip/member/1496 Christine Russell uk.org.publicwhip/person/10522 2 2010-01-06-80ef1083-10522-0
73900539b37c1a884c9433aded45b588fec3f9ec Destination of visit: Colombia Overseas visits 80ef1083 2010-01-06 uk.org.publicwhip/member/1496 Christine Russell uk.org.publicwhip/person/10522 3 2010-01-06-80ef1083-10522-0
51ff0df3527c964f18e2c57b31c9f56cbb7ec077 Date of visit: 16-21 August 2009 Overseas visits 80ef1083 2010-01-06 uk.org.publicwhip/member/1496 Christine Russell uk.org.publicwhip/person/10522 4 2010-01-06-80ef1083-10522-0
883b084f7d16ba5ad869283402e7a7bc58cea5d4 Purpose of visit: to discuss foreign and security policies, human rights issues, drug trafficking, poverty reduction programmes Overseas visits 80ef1083 2010-01-06 uk.org.publicwhip/member/1496 Christine Russell uk.org.publicwhip/person/10522 5 2010-01-06-80ef1083-10522-0
0002ec0c17a1af5b89bfefc3d015ab477df865f6 (Registered 12 October 2009) Overseas visits 80ef1083 2010-01-06 uk.org.publicwhip/member/1496 Christine Russell uk.org.publicwhip/person/10522 6 2010-01-06-80ef1083-10522-0
3af3726d02f3dbddb53d74027ea9065393494fdd Name of donor: Government of the Kingdom of Saudi Arabia Overseas visits 80ef1083 2010-01-06 uk.org.publicwhip/member/1496 Christine Russell uk.org.publicwhip/person/10522 7 2010-01-06-80ef1083-10522-0
82ce66da96d6d662b7092a507d9a5f6d1fc67831 Address of donor: Shoura Council, Riyadh, Saudi Arabia. Overseas visits 80ef1083 2010-01-06 uk.org.publicwhip/member/1496 Christine Russell uk.org.publicwhip/person/10522 8 2010-01-06-80ef1083-10522-0
5bff4f5846dbe5b56757ddeaee2c11c2c2d8071c Amount of donation (or estimate of the probable value): £5000 Overseas visits 80ef1083 2010-01-06 uk.org.publicwhip/member/1496 Christine Russell uk.org.publicwhip/person/10522 9 2010-01-06-80ef1083-10522-0
84a10e41e9891861590829ab72c5ac3b812743de Destination of visit: Saudi Arabia Overseas visits 80ef1083 2010-01-06 uk.org.publicwhip/member/1496 Christine Russell uk.org.publicwhip/person/10522 10 2010-01-06-80ef1083-10522-0
701123ea7d2606cdce97f0e4544d5c6f4be8206b Date of visit: 2 - 6 October 2009 Overseas visits 80ef1083 2010-01-06 uk.org.publicwhip/member/1496 Christine Russell uk.org.publicwhip/person/10522 11 2010-01-06-80ef1083-10522-0
1acf8a36489ebc5483dcd771be4d3539d42cca21 Purpose of visit: to discuss international relations, UK-Saudi trade/education, training and research partnerships with members of the Shoura Council and Ministers. Overseas visits 80ef1083 2010-01-06 uk.org.publicwhip/member/1496 Christine Russell uk.org.publicwhip/person/10522 12 2010-01-06-80ef1083-10522-0
9087d75bfa5de50d650503aee10e7f21f63cf467 (Registered 31 October 2009) Overseas visits 80ef1083 2010-01-06 uk.org.publicwhip/member/1496 Christine Russell uk.org.publicwhip/person/10522 13 2010-01-06-80ef1083-10522-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 103.694ms · Data source: mySociety Data