home / regmem

items

Data source: mySociety Data

31 rows where record_id = "2012-09-03-80ef1083-11599-0" sorted by sort_order

View and edit SQL

hash item category_id date member_id person_id sort_order record_id
2ae916527ae7a6746fd6c29fa93394f92488a947 Address of donor: 83 Victoria Street, London SW1H OHW Overseas visits 80ef1083 2012-09-03 uk.org.publicwhip/member/40284 Adam Holloway uk.org.publicwhip/person/11599 1 2012-09-03-80ef1083-11599-0
b4fb1ebabaaa2f2af351eb37ec7b5d3737d494bc Amount of donation (or estimate of the probable value): cars, flights, accommodation and communications; approximate value £2,000 Overseas visits 80ef1083 2012-09-03 uk.org.publicwhip/member/40284 Adam Holloway uk.org.publicwhip/person/11599 2 2012-09-03-80ef1083-11599-0
1aebea720fef472b04cccf7290c4e8957d94390d Destination of visit:  Tripoli, Libya Overseas visits 80ef1083 2012-09-03 uk.org.publicwhip/member/40284 Adam Holloway uk.org.publicwhip/person/11599 3 2012-09-03-80ef1083-11599-0
cf1263b398fa545a79cd05d0f7403f519cac49d1 Date of visit: 30 August-5 September 2011 Overseas visits 80ef1083 2012-09-03 uk.org.publicwhip/member/40284 Adam Holloway uk.org.publicwhip/person/11599 4 2012-09-03-80ef1083-11599-0
3addd761c1b7898934fac0d0d6f28d058ae7ac91 Purpose of visit: to look at the situation in the immediate aftermath of the collapse of the regime. Overseas visits 80ef1083 2012-09-03 uk.org.publicwhip/member/40284 Adam Holloway uk.org.publicwhip/person/11599 5 2012-09-03-80ef1083-11599-0
06cf11373138cfa16ffa4c4e0204e8c9e2b2ebaf (Registered 16 April 2012) Overseas visits 80ef1083 2012-09-03 uk.org.publicwhip/member/40284 Adam Holloway uk.org.publicwhip/person/11599 6 2012-09-03-80ef1083-11599-0
14f3b58a32e54e6dc6a3dc367c981154857693a4 Name of donor: Overseas visits 80ef1083 2012-09-03 uk.org.publicwhip/member/40284 Adam Holloway uk.org.publicwhip/person/11599 7 2012-09-03-80ef1083-11599-0
8ddcc0c3838a3d761582568afe63bf2dcd036a4e 1) Government of Japan Overseas visits 80ef1083 2012-09-03 uk.org.publicwhip/member/40284 Adam Holloway uk.org.publicwhip/person/11599 8 2012-09-03-80ef1083-11599-0
238d186f852e322a1e16b5635a3c7ed455bc7892 2) All Party Parliamentary Group on Japan Overseas visits 80ef1083 2012-09-03 uk.org.publicwhip/member/40284 Adam Holloway uk.org.publicwhip/person/11599 9 2012-09-03-80ef1083-11599-0
92ffe2d870ec94f4435febea1c3a9fb391e55438 Address of donor: Overseas visits 80ef1083 2012-09-03 uk.org.publicwhip/member/40284 Adam Holloway uk.org.publicwhip/person/11599 10 2012-09-03-80ef1083-11599-0
983846e174e8e48e8cf2d840ece688294e06739e 1) Embassy of Japan, 101-104 Piccadilly, London; Overseas visits 80ef1083 2012-09-03 uk.org.publicwhip/member/40284 Adam Holloway uk.org.publicwhip/person/11599 11 2012-09-03-80ef1083-11599-0
8af695bfbffce614eb8f9e82a81138ff9904debd Amount of donation (or estimate of the probable value): Overseas visits 80ef1083 2012-09-03 uk.org.publicwhip/member/40284 Adam Holloway uk.org.publicwhip/person/11599 12 2012-09-03-80ef1083-11599-0
831a484980a5b47dbc443b410394b3e39506b51a 1) all internal costs, estimated at £2,500 Overseas visits 80ef1083 2012-09-03 uk.org.publicwhip/member/40284 Adam Holloway uk.org.publicwhip/person/11599 13 2012-09-03-80ef1083-11599-0
9bc479015f5b25cebbb49feed39f8dfec86a8888 2) flights to and from Japan, estimated at £2,000 Overseas visits 80ef1083 2012-09-03 uk.org.publicwhip/member/40284 Adam Holloway uk.org.publicwhip/person/11599 14 2012-09-03-80ef1083-11599-0
664e01ce7f1b932fdd20a06a48ff502fd14dbc28 Destination of visit: Japan Overseas visits 80ef1083 2012-09-03 uk.org.publicwhip/member/40284 Adam Holloway uk.org.publicwhip/person/11599 15 2012-09-03-80ef1083-11599-0
fe7038d05281387a9f7c637bf01fb2135f181913 Date of visit: 17-24 March 2012 Overseas visits 80ef1083 2012-09-03 uk.org.publicwhip/member/40284 Adam Holloway uk.org.publicwhip/person/11599 16 2012-09-03-80ef1083-11599-0
55233a321fa84e0ce01f4847a8608f8e46263958 Purpose of visit: to promote relations between parliamentarians in Westminster and the Diet, to promote trade and to look at the tsunami affected area. Overseas visits 80ef1083 2012-09-03 uk.org.publicwhip/member/40284 Adam Holloway uk.org.publicwhip/person/11599 17 2012-09-03-80ef1083-11599-0
a2764a9c7f42bdd1faa6d43e1d0c9f1677e06b53 (Registered 11 April 2012) Overseas visits 80ef1083 2012-09-03 uk.org.publicwhip/member/40284 Adam Holloway uk.org.publicwhip/person/11599 18 2012-09-03-80ef1083-11599-0
45c2b1afa6ddc4df365ee5070a344c20a4b3f5ec Name of donor: Kurdish Democratic Party Overseas visits 80ef1083 2012-09-03 uk.org.publicwhip/member/40284 Adam Holloway uk.org.publicwhip/person/11599 19 2012-09-03-80ef1083-11599-0
ba272a160fe6a44dafaeae8d1cd1547ddbd152fa Address of donor: Erbil, Kurdish Autonomous Region, Iraq Overseas visits 80ef1083 2012-09-03 uk.org.publicwhip/member/40284 Adam Holloway uk.org.publicwhip/person/11599 20 2012-09-03-80ef1083-11599-0
66deef3725a713646e43a30a3e9a3ac09f85aebc Amount of donation (or estimate of the probable value): flights and accommodation worth approximately £2,500 Overseas visits 80ef1083 2012-09-03 uk.org.publicwhip/member/40284 Adam Holloway uk.org.publicwhip/person/11599 21 2012-09-03-80ef1083-11599-0
0003f5a834079471bf6a5b04182b65509b69a46c Destination of visit: Northern Iraq Overseas visits 80ef1083 2012-09-03 uk.org.publicwhip/member/40284 Adam Holloway uk.org.publicwhip/person/11599 22 2012-09-03-80ef1083-11599-0
72a9f701e257412b05fe74b2b1b8c0e8a83f0d20 Date of visit: 11 to 13 June 2012 Overseas visits 80ef1083 2012-09-03 uk.org.publicwhip/member/40284 Adam Holloway uk.org.publicwhip/person/11599 23 2012-09-03-80ef1083-11599-0
8dddc8311d280e1ceb387f0802433cfdbb73bec0 Purpose of visit: to view progress since the 2003 invasion of Iraq. Overseas visits 80ef1083 2012-09-03 uk.org.publicwhip/member/40284 Adam Holloway uk.org.publicwhip/person/11599 24 2012-09-03-80ef1083-11599-0
eb3f40a9dc790cca9924847f4effb4a76c518255 Name of donor: Conservative Middle East Council Overseas visits 80ef1083 2012-09-03 uk.org.publicwhip/member/40284 Adam Holloway uk.org.publicwhip/person/11599 26 2012-09-03-80ef1083-11599-0
7349014bcba2211815ec4eda934ee7c0afe6cdb1 Address of donor: 55 Tufton St, London SW1P 3QL Overseas visits 80ef1083 2012-09-03 uk.org.publicwhip/member/40284 Adam Holloway uk.org.publicwhip/person/11599 27 2012-09-03-80ef1083-11599-0
a13aa01fb6cbffefd74e54b879e0095414e8df65 Amount of donation (or estimate of the probable value): flights, accommodation, vehicles and services of interpreters worth approximately £1,000 in total Overseas visits 80ef1083 2012-09-03 uk.org.publicwhip/member/40284 Adam Holloway uk.org.publicwhip/person/11599 28 2012-09-03-80ef1083-11599-0
6cfdfb9475a140321922cf197f929f788a0b7c08 Destination of visit: Lebanon Overseas visits 80ef1083 2012-09-03 uk.org.publicwhip/member/40284 Adam Holloway uk.org.publicwhip/person/11599 29 2012-09-03-80ef1083-11599-0
b98aff6ea5abe85ec2d5f1251ea49dff3b7b97e7 Date of visit: 18 -23 April 2012 Overseas visits 80ef1083 2012-09-03 uk.org.publicwhip/member/40284 Adam Holloway uk.org.publicwhip/person/11599 30 2012-09-03-80ef1083-11599-0
03c2c42e418f19ea12cc2c7fc6b6ea9812c54c04 Purpose of visit: to look at fallout from civil war in Syria and to visit border area Overseas visits 80ef1083 2012-09-03 uk.org.publicwhip/member/40284 Adam Holloway uk.org.publicwhip/person/11599 31 2012-09-03-80ef1083-11599-0
a81634cfb100ccf9deabad41d03b95cb88daf642 (Registered 21 August 2012) Overseas visits 80ef1083 2012-09-03 uk.org.publicwhip/member/40284 Adam Holloway uk.org.publicwhip/person/11599 32 2012-09-03-80ef1083-11599-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.077ms · Data source: mySociety Data