home / regmem

items

Data source: mySociety Data

20 rows where record_id = "2014-08-26-80ef1083-11057-0" sorted by sort_order

View and edit SQL

hash item category_id date member_id person_id sort_order record_id
8b94acb2eaf3e4085b61a5ef72202f01352f05f7 Name of donor: UAE Government Overseas visits 80ef1083 2014-08-26 uk.org.publicwhip/member/40675 Ian Lucas uk.org.publicwhip/person/11057 0 2014-08-26-80ef1083-11057-0
c07d2fac9c3f85fcaf47f1b03a06e4cc99d98e77 Address of donor: PO Box 31966, Abu Dhabi, UAE Overseas visits 80ef1083 2014-08-26 uk.org.publicwhip/member/40675 Ian Lucas uk.org.publicwhip/person/11057 1 2014-08-26-80ef1083-11057-0
e8dc33f517e76d2ce318004a461cef92b90fa8d0 Amount of donation: £3,500 Overseas visits 80ef1083 2014-08-26 uk.org.publicwhip/member/40675 Ian Lucas uk.org.publicwhip/person/11057 2 2014-08-26-80ef1083-11057-0
aa509d9196d30a5ebf7e4a27de273ea4ac7ac318 Destination of visit: Dubai and Abu Dhabi Overseas visits 80ef1083 2014-08-26 uk.org.publicwhip/member/40675 Ian Lucas uk.org.publicwhip/person/11057 3 2014-08-26-80ef1083-11057-0
2c2891fed13261ac4339c3d382c13d3493c47832 Date of visit: 16-19 November 2013 Overseas visits 80ef1083 2014-08-26 uk.org.publicwhip/member/40675 Ian Lucas uk.org.publicwhip/person/11057 4 2014-08-26-80ef1083-11057-0
625d5ae2b0e6652270b9fd6216d75dd01cf4237f Purpose of visit: As Shadow Middle East Minister, to meet with UAE Government ministers, Members of the Federal National Council, Emirates Association for Human Rights, and senior business figures, together with UK Diplomats (Registered 25 November 2013) Overseas visits 80ef1083 2014-08-26 uk.org.publicwhip/member/40675 Ian Lucas uk.org.publicwhip/person/11057 5 2014-08-26-80ef1083-11057-0
bface12c458055cf1044f246c95e514820cf8572 Name of donor: Information International Overseas visits 80ef1083 2014-08-26 uk.org.publicwhip/member/40675 Ian Lucas uk.org.publicwhip/person/11057 6 2014-08-26-80ef1083-11057-0
9c9d7283e821c70d30a3880b3f7bca67cb2640ae Address of donor: Al-Borj (An-Nahar) Bldg, 4th Floor, Martyrs Square, Beirut, Zip Code: 11-4353, Lebanon Overseas visits 80ef1083 2014-08-26 uk.org.publicwhip/member/40675 Ian Lucas uk.org.publicwhip/person/11057 7 2014-08-26-80ef1083-11057-0
f999c89a975f7c179db5c78c6a7141dad917906f Amount of donation (or estimate of the probable value): travel costs, accommodation and subsistence with a value of £1,700 Overseas visits 80ef1083 2014-08-26 uk.org.publicwhip/member/40675 Ian Lucas uk.org.publicwhip/person/11057 8 2014-08-26-80ef1083-11057-0
0004f3e01df29bfeb32a725eae7ad0b111be588c Destination of visit: Lebanon Overseas visits 80ef1083 2014-08-26 uk.org.publicwhip/member/40675 Ian Lucas uk.org.publicwhip/person/11057 9 2014-08-26-80ef1083-11057-0
fd79f174525d2914e7bb0ca9b4296383f91e7b5f Date of visit: 26-29 January 2014 Overseas visits 80ef1083 2014-08-26 uk.org.publicwhip/member/40675 Ian Lucas uk.org.publicwhip/person/11057 10 2014-08-26-80ef1083-11057-0
99f23b77918f0ffaa56c2096322db76fc9253f63 Purpose of visit: Fact-finding delegation organised by the Council for Arab British Understanding, in my capacity as Shadow Middle East Minister Overseas visits 80ef1083 2014-08-26 uk.org.publicwhip/member/40675 Ian Lucas uk.org.publicwhip/person/11057 11 2014-08-26-80ef1083-11057-0
660730681031ce909995e05891c3a52d669e7ee3 (Registered 17 February 2014) Overseas visits 80ef1083 2014-08-26 uk.org.publicwhip/member/40675 Ian Lucas uk.org.publicwhip/person/11057 12 2014-08-26-80ef1083-11057-0
1e169d9cfe916b1f8c2be0cbe8e1c5d090abef9b Name of donor: British University in Egypt Overseas visits 80ef1083 2014-08-26 uk.org.publicwhip/member/40675 Ian Lucas uk.org.publicwhip/person/11057 13 2014-08-26-80ef1083-11057-0
a8b3f84035711bca15c932a7e4fe46c6915199cb Address of donor: El Sherouk City, Suez Desert Road, Cairo 11837; P.O. Box 43 Overseas visits 80ef1083 2014-08-26 uk.org.publicwhip/member/40675 Ian Lucas uk.org.publicwhip/person/11057 14 2014-08-26-80ef1083-11057-0
45e22a69dd3e9e2d6ee21e3f338510d08476ed8a Amount of donation (or estimate of the probable value): £3,300 Overseas visits 80ef1083 2014-08-26 uk.org.publicwhip/member/40675 Ian Lucas uk.org.publicwhip/person/11057 15 2014-08-26-80ef1083-11057-0
edb435029367a1776c0ebb2c714da10acfe4f708 Destination of visit: Cairo, Egypt Overseas visits 80ef1083 2014-08-26 uk.org.publicwhip/member/40675 Ian Lucas uk.org.publicwhip/person/11057 16 2014-08-26-80ef1083-11057-0
83550da793f140da0ace1879f42d6cd01ef960e7 Date of visit: 13-16 June 2014 Overseas visits 80ef1083 2014-08-26 uk.org.publicwhip/member/40675 Ian Lucas uk.org.publicwhip/person/11057 17 2014-08-26-80ef1083-11057-0
60e0a1652e598c331a77c03e9c1b4cc784e19bb7 Purpose of visit: to meet the new President, meet government ministers, religious leaders, British Council, IPU and representatives of civil society in Egypt and discuss developments taking place in the run up to parliamentary elections, in my capacity of Shadow Minister for Africa and Middle East Overseas visits 80ef1083 2014-08-26 uk.org.publicwhip/member/40675 Ian Lucas uk.org.publicwhip/person/11057 18 2014-08-26-80ef1083-11057-0
91bc0b1b74bd1d05390a1fdb75e58d323aecc720 (Registered 4 July 2014) Overseas visits 80ef1083 2014-08-26 uk.org.publicwhip/member/40675 Ian Lucas uk.org.publicwhip/person/11057 19 2014-08-26-80ef1083-11057-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 17.512ms · Data source: mySociety Data