home / regmem

items

Data source: mySociety Data

17 rows where record_id = "2011-07-19-80ef1083-24770-0" sorted by sort_order

View and edit SQL

hash item category_id date member_id person_id sort_order record_id
899b08c7b115a55b511be60d97eb27a56237bed9 Amount of donation (or estimate of the probable value): flights, hotel, transport and food to an approximate value of £1,500. Overseas visits 80ef1083 2011-07-19 uk.org.publicwhip/member/40567 Kwasi Kwarteng uk.org.publicwhip/person/24770 2 2011-07-19-80ef1083-24770-0
36abb451fd74f10a422eaf4a25088bfe321f7cab Destination of visit: Gaza and Egypt Overseas visits 80ef1083 2011-07-19 uk.org.publicwhip/member/40567 Kwasi Kwarteng uk.org.publicwhip/person/24770 3 2011-07-19-80ef1083-24770-0
0000f428222bbd00034d83e8f47569fe936fa009 Date of visit: 29 October-1 November 2010 Overseas visits 80ef1083 2011-07-19 uk.org.publicwhip/member/40567 Kwasi Kwarteng uk.org.publicwhip/person/24770 4 2011-07-19-80ef1083-24770-0
19396df0a30e3e02785b59b167ef1b4855e191c6 Purpose of visit: study visit to see the United Nations Relief and Works Agency in Gaza and a meeting with the British Ambassador in Cairo Overseas visits 80ef1083 2011-07-19 uk.org.publicwhip/member/40567 Kwasi Kwarteng uk.org.publicwhip/person/24770 5 2011-07-19-80ef1083-24770-0
66b23d716e3cbb8a810a35aa467efcf72cb7b44a (Registered 4 November 2010) Overseas visits 80ef1083 2011-07-19 uk.org.publicwhip/member/40567 Kwasi Kwarteng uk.org.publicwhip/person/24770 6 2011-07-19-80ef1083-24770-0
3e207906215f9f3bfc83185877eb71a926a3ac21 Name of donor: Conservative Middle East Council Overseas visits 80ef1083 2011-07-19 uk.org.publicwhip/member/40567 Kwasi Kwarteng uk.org.publicwhip/person/24770 7 2011-07-19-80ef1083-24770-0
367570a6a425ef90441ae1497b8a0ddb55c0a87a Amount of donation (or estimate of the probable value): flights, hotel, transport and food to an approximate value of £1,100 Overseas visits 80ef1083 2011-07-19 uk.org.publicwhip/member/40567 Kwasi Kwarteng uk.org.publicwhip/person/24770 9 2011-07-19-80ef1083-24770-0
ad0f1344a1dd56ecf150cafc13a5b5c698892ac9 Destination of visit: Israel and the occupied Palestinian territories Overseas visits 80ef1083 2011-07-19 uk.org.publicwhip/member/40567 Kwasi Kwarteng uk.org.publicwhip/person/24770 10 2011-07-19-80ef1083-24770-0
c28a1a46314ca8c74dad51ae884ba560965c60d5 Date of visit: 3-7 February 2011 Overseas visits 80ef1083 2011-07-19 uk.org.publicwhip/member/40567 Kwasi Kwarteng uk.org.publicwhip/person/24770 11 2011-07-19-80ef1083-24770-0
91d882f781ec46fc741c32f872ff13c9fd022c09 Purpose of visit: study visit to meet the Prime Minister of the Palestinian National Assembly and Deputy Foreign Minister of Israel. (Registered 15 February 2011) Overseas visits 80ef1083 2011-07-19 uk.org.publicwhip/member/40567 Kwasi Kwarteng uk.org.publicwhip/person/24770 12 2011-07-19-80ef1083-24770-0
f072c3b9236e61c6cc5a4fa3f9c87c8a76d35fae Name of donor: Conservative Middle East Council Overseas visits 80ef1083 2011-07-19 uk.org.publicwhip/member/40567 Kwasi Kwarteng uk.org.publicwhip/person/24770 13 2011-07-19-80ef1083-24770-0
ce1034f570966b7694921a6a46c648b035396d5a Address of donor: 83 Victoria Street, London SW1H 0HW Overseas visits 80ef1083 2011-07-19 uk.org.publicwhip/member/40567 Kwasi Kwarteng uk.org.publicwhip/person/24770 14 2011-07-19-80ef1083-24770-0
98f7f371f5c52ad84f4f4c94ada5233bf62b788f Amount of donation (or estimate of the probable value): flights, hotel, transport and food to an approximate value of £995 Overseas visits 80ef1083 2011-07-19 uk.org.publicwhip/member/40567 Kwasi Kwarteng uk.org.publicwhip/person/24770 15 2011-07-19-80ef1083-24770-0
5761c98079c603348732b776b51741fa364edd95 Destination of visit: Egypt Overseas visits 80ef1083 2011-07-19 uk.org.publicwhip/member/40567 Kwasi Kwarteng uk.org.publicwhip/person/24770 16 2011-07-19-80ef1083-24770-0
7021d3dc010635f15c4ba7f44af06df17cad8f29 Date of visit: 17-21 March 2011 Overseas visits 80ef1083 2011-07-19 uk.org.publicwhip/member/40567 Kwasi Kwarteng uk.org.publicwhip/person/24770 17 2011-07-19-80ef1083-24770-0
3a5f3cff9dad1665805e1ce0fe6246fae804f8de Purpose of visit: study visit to meet with student activists, business leaders and opinion formers Overseas visits 80ef1083 2011-07-19 uk.org.publicwhip/member/40567 Kwasi Kwarteng uk.org.publicwhip/person/24770 18 2011-07-19-80ef1083-24770-0
b610a1d6d52bdac01e250032a4d4c8bbacd7459d (Registered 23 March 2011) Overseas visits 80ef1083 2011-07-19 uk.org.publicwhip/member/40567 Kwasi Kwarteng uk.org.publicwhip/person/24770 19 2011-07-19-80ef1083-24770-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 5.338ms · Data source: mySociety Data