home / regmem

items

Data source: mySociety Data

21 rows where record_id = "2012-07-09-80ef1083-24947-0" sorted by sort_order

View and edit SQL

hash item category_id date member_id person_id sort_order record_id
67f3ed81209d330da60f64faac54cb206dcf26d7 Name of donor: Overseas visits 80ef1083 2012-07-09 uk.org.publicwhip/member/40404 Iain Stewart uk.org.publicwhip/person/24947 0 2012-07-09-80ef1083-24947-0
59b8f77c90e9d64c7fcf0ab4b647aa3175954502 5) Virgin Atlantic Airways Ltd Overseas visits 80ef1083 2012-07-09 uk.org.publicwhip/member/40404 Iain Stewart uk.org.publicwhip/person/24947 1 2012-07-09-80ef1083-24947-0
89564e92baa416806d49b00ca14ee85747fc71e1 6) Free the Children Overseas visits 80ef1083 2012-07-09 uk.org.publicwhip/member/40404 Iain Stewart uk.org.publicwhip/person/24947 2 2012-07-09-80ef1083-24947-0
6f09f9e6ec96c7f72347451076c40103ee843ef0 Address of donor: Overseas visits 80ef1083 2012-07-09 uk.org.publicwhip/member/40404 Iain Stewart uk.org.publicwhip/person/24947 3 2012-07-09-80ef1083-24947-0
2e4a281821a04545eea1c18fcbbcf7247c0b11e8 7) The Office (SE2), Manor Royal, Crawley RH10 9NU Overseas visits 80ef1083 2012-07-09 uk.org.publicwhip/member/40404 Iain Stewart uk.org.publicwhip/person/24947 4 2012-07-09-80ef1083-24947-0
0005d1757d131ddae36d4db3ba34042f7c6c473a 8) 75 Westminster Bridge Road, London SE1 7HS Overseas visits 80ef1083 2012-07-09 uk.org.publicwhip/member/40404 Iain Stewart uk.org.publicwhip/person/24947 5 2012-07-09-80ef1083-24947-0
b91d319e1ab30fe6e221e64b21bb639ea9336dcc Amount of donation (or estimate of the probable value): Overseas visits 80ef1083 2012-07-09 uk.org.publicwhip/member/40404 Iain Stewart uk.org.publicwhip/person/24947 6 2012-07-09-80ef1083-24947-0
57e465a075fe3cb05c8e32d6fc63f29ff9a3010d 7) Virgin Atlantic paid for return flights London to Nairobi, UK transfers and accommodation and food; value £2,599.32 Overseas visits 80ef1083 2012-07-09 uk.org.publicwhip/member/40404 Iain Stewart uk.org.publicwhip/person/24947 7 2012-07-09-80ef1083-24947-0
a45652e2d3c47b22acf6ed10270bd4e9b89af150 8) Free the Children paid for internal return flight Nairobi to Bogani; value £333.18. Overseas visits 80ef1083 2012-07-09 uk.org.publicwhip/member/40404 Iain Stewart uk.org.publicwhip/person/24947 8 2012-07-09-80ef1083-24947-0
0bf9130dcef1f554ebb4ae16396105c13358dfab Total cost of trip; £2,958.73 Overseas visits 80ef1083 2012-07-09 uk.org.publicwhip/member/40404 Iain Stewart uk.org.publicwhip/person/24947 9 2012-07-09-80ef1083-24947-0
f9c3dca3a85c22c06621ad3ab7496ea9092d8993 Destination of visit: Kenya Overseas visits 80ef1083 2012-07-09 uk.org.publicwhip/member/40404 Iain Stewart uk.org.publicwhip/person/24947 10 2012-07-09-80ef1083-24947-0
717c8a9f4792d17775728cc05be73d284060c4be Date of visit: 31 August-3 September 2011 Overseas visits 80ef1083 2012-07-09 uk.org.publicwhip/member/40404 Iain Stewart uk.org.publicwhip/person/24947 11 2012-07-09-80ef1083-24947-0
6b72a13a350f66ac2b5503db3c8cc4a005e91d9f Purpose of visit: to participate in the overseas aid programmes operated in Kenya by Virgin Atlantic in association with Free the Children. Overseas visits 80ef1083 2012-07-09 uk.org.publicwhip/member/40404 Iain Stewart uk.org.publicwhip/person/24947 12 2012-07-09-80ef1083-24947-0
f9a9afd3f54b0efb2b2f385d3a022b403b54ffcd (Registered 30 September 2011) Overseas visits 80ef1083 2012-07-09 uk.org.publicwhip/member/40404 Iain Stewart uk.org.publicwhip/person/24947 13 2012-07-09-80ef1083-24947-0
ac60f6a3eeec0f790c17809e1fa7a17259c9b36f Name of donor: Presence Switzerland, Embassy of Switzerland in the United Kingdom Overseas visits 80ef1083 2012-07-09 uk.org.publicwhip/member/40404 Iain Stewart uk.org.publicwhip/person/24947 14 2012-07-09-80ef1083-24947-0
6d444aa128e257f257d22045a268255ff2db5fd6 Address of donor: 16-18 Montagu Place, London W1H 2BQ Overseas visits 80ef1083 2012-07-09 uk.org.publicwhip/member/40404 Iain Stewart uk.org.publicwhip/person/24947 15 2012-07-09-80ef1083-24947-0
e569b55175f2b3687ee1c0a24875d2730ebc6a09 Amount of donation (or estimate of the probable value): travel, accommodation and food costs; total value approximately £1,530 Overseas visits 80ef1083 2012-07-09 uk.org.publicwhip/member/40404 Iain Stewart uk.org.publicwhip/person/24947 16 2012-07-09-80ef1083-24947-0
24623eba7fc0a1860d7aca69519e2fabf376c0e8 Destination of visit: Berne, Switzerland Overseas visits 80ef1083 2012-07-09 uk.org.publicwhip/member/40404 Iain Stewart uk.org.publicwhip/person/24947 17 2012-07-09-80ef1083-24947-0
ba460b814b0f44bf4a9b753e74b56fd719fa74db Date of visit: 13-17 September 2011 Overseas visits 80ef1083 2012-07-09 uk.org.publicwhip/member/40404 Iain Stewart uk.org.publicwhip/person/24947 18 2012-07-09-80ef1083-24947-0
e6abc690225cbef3b2a8797c13b47aeb62412cdc Purpose of visit: to participate in a rail transport study tour and workshop Overseas visits 80ef1083 2012-07-09 uk.org.publicwhip/member/40404 Iain Stewart uk.org.publicwhip/person/24947 19 2012-07-09-80ef1083-24947-0
fb8fb5dee6761e7eb21e42440885dfb8d5e00383 (Registered 12 October 2011) Overseas visits 80ef1083 2012-07-09 uk.org.publicwhip/member/40404 Iain Stewart uk.org.publicwhip/person/24947 20 2012-07-09-80ef1083-24947-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.551ms · Data source: mySociety Data