home / regmem

items

Data source: mySociety Data

11 rows where record_id = "2009-12-10-80ef1083-10371-0" sorted by sort_order

View and edit SQL

hash item category_id date member_id person_id sort_order record_id
e00bc68f9389f91a5ca361ed84918120303a491b 6-11 September 2008, to Dharamsala, India, to visit the Tibetan Government-in-exile in my capacity as a member of the All-Party Parliamentary Group for Tibet. The costs of my travel were met jointly by the Tibet Society and myself and accommodation by the Tibetan Government-in-exile. (Registered 28 October 2008) Overseas visits 80ef1083 2009-12-10 uk.org.publicwhip/member/1944 Tim Loughton uk.org.publicwhip/person/10371 0 2009-12-10-80ef1083-10371-0
cec2b8421657e03286a53cf18017150b3e8c5149 Name of donor: 1) Consolidated Contractors Company Overseas visits 80ef1083 2009-12-10 uk.org.publicwhip/member/1944 Tim Loughton uk.org.publicwhip/person/10371 1 2009-12-10-80ef1083-10371-0
8b0611d4155be909c7a3af56db9624769e51a93c 2) Government of Tajikistan Overseas visits 80ef1083 2009-12-10 uk.org.publicwhip/member/1944 Tim Loughton uk.org.publicwhip/person/10371 2 2009-12-10-80ef1083-10371-0
85410351606345683ddad262be69523c1e92ffaa Address of donor: 1) 11A West Halkin Street, Belgravia, London SW1X 8JL. Overseas visits 80ef1083 2009-12-10 uk.org.publicwhip/member/1944 Tim Loughton uk.org.publicwhip/person/10371 3 2009-12-10-80ef1083-10371-0
b7b12a8143065a321a605a4ed7c5796a53c5de26 2) Dushanbe, Tajikistan. Overseas visits 80ef1083 2009-12-10 uk.org.publicwhip/member/1944 Tim Loughton uk.org.publicwhip/person/10371 4 2009-12-10-80ef1083-10371-0
d4581193896f67bb30414b0a9d3fa10a05bab532 Amount of donation (or estimate of the probable value): 1) £1408.20 (flights to and from Dushanbe) Overseas visits 80ef1083 2009-12-10 uk.org.publicwhip/member/1944 Tim Loughton uk.org.publicwhip/person/10371 5 2009-12-10-80ef1083-10371-0
5e8ffaf3a24bdea55ad54231ec87278e408f5071 2) approximately £400 (for accommodation) Overseas visits 80ef1083 2009-12-10 uk.org.publicwhip/member/1944 Tim Loughton uk.org.publicwhip/person/10371 6 2009-12-10-80ef1083-10371-0
e0d1db85c0871dcc1d9da0d5095b6ddf416817fb Destination of visit: Tajikistan Overseas visits 80ef1083 2009-12-10 uk.org.publicwhip/member/1944 Tim Loughton uk.org.publicwhip/person/10371 7 2009-12-10-80ef1083-10371-0
785f6fa1cc2380f25709801bebc27836b10b1a2a Date of visit: 14-18 November 2009 Overseas visits 80ef1083 2009-12-10 uk.org.publicwhip/member/1944 Tim Loughton uk.org.publicwhip/person/10371 8 2009-12-10-80ef1083-10371-0
3cf2a47bdab07805331f68b9dfe03c9fb8b66c2b Purpose of visit: officers of the All-Party Parliamentary Group for Tajikistan met parliamentarians and established a friendship group and met agencies dealing with Afghan refugees and drug trafficking. Overseas visits 80ef1083 2009-12-10 uk.org.publicwhip/member/1944 Tim Loughton uk.org.publicwhip/person/10371 9 2009-12-10-80ef1083-10371-0
000158affe921c78c3acde028d71a4ca9a6354dd (Registered 8 December 2009) Overseas visits 80ef1083 2009-12-10 uk.org.publicwhip/member/1944 Tim Loughton uk.org.publicwhip/person/10371 10 2009-12-10-80ef1083-10371-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 88.797ms · Data source: mySociety Data