items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
28 rows where record_id = "2014-04-28-80ef1083-11362-0" sorted by sort_order
This data as json, CSV (advanced)
Suggested facets: date (date)
hash | item | category_id | date | member_id | person_id | sort_order ▼ | record_id |
---|---|---|---|---|---|---|---|
4e6b06356510edb82b2f2e4ccada9781e2ef2efc | Name of donor: (1) Barclays Plc; (2) Prudential Plc; (3) UK-ASEAN Business Council | Overseas visits 80ef1083 | 2014-04-28 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 0 | 2014-04-28-80ef1083-11362-0 |
0eeba4cf4207cb409be749ee349e6016cd3dcfbb | Address of donor: (1) 1 Churchill Place, London E14 5HP; (2) Laurence Pountney Hill, London EC4R 0HH; (3) 1 Victoria Street, London SW1H 0ET | Overseas visits 80ef1083 | 2014-04-28 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 1 | 2014-04-28-80ef1083-11362-0 |
678dd60cee8a39368050d41a82258165e4096582 | Amount of donation (or estimate of the probable value): (1) £3,048.32 towards travel and accommodation; (2) £3,048.32 towards travel and accommodation; (3) £304.84 towards travel and accommodation | Overseas visits 80ef1083 | 2014-04-28 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 2 | 2014-04-28-80ef1083-11362-0 |
de5580a70348736426c6aa25e7da25d58f18db5c | Destination of visit: Singapore and Indonesia | Overseas visits 80ef1083 | 2014-04-28 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 3 | 2014-04-28-80ef1083-11362-0 |
614ec3ccf2672fc5ad16108504c2ca11ae8def82 | Date of visit: 9-15 March 2013 | Overseas visits 80ef1083 | 2014-04-28 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 4 | 2014-04-28-80ef1083-11362-0 |
310dcbdfe9a12415eec7d1d167a80379fe4d4b38 | Purpose of visit: All-Party Parliamentary Group for Trade and Investment visit to Singapore and Indonesia to promote trade and specifically British exports in the education, infrastructure and architecture sectors. | Overseas visits 80ef1083 | 2014-04-28 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 5 | 2014-04-28-80ef1083-11362-0 |
2f020e4645367f71766f82eff1b446473f45b042 | (Registered 15 April 2013) | Overseas visits 80ef1083 | 2014-04-28 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 6 | 2014-04-28-80ef1083-11362-0 |
1ef674f762aea4c14657fbc22fa3df465ff346e1 | Name of donor: Embassy of Japan in the UK | Overseas visits 80ef1083 | 2014-04-28 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 7 | 2014-04-28-80ef1083-11362-0 |
b3e1e733689dfd5990b1d8705bdbe07190508884 | Address of donor: 101-104 Piccadilly, London W1J 7JT | Overseas visits 80ef1083 | 2014-04-28 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 8 | 2014-04-28-80ef1083-11362-0 |
198b7ca2a821f4feeccf72ffbdc9e8b6f2ffb696 | Amount of donation (or estimate of the probable value): flights, £3,302 (including tax); accommodation in Tokyo and Okura, £1,095; train fares, £223 | Overseas visits 80ef1083 | 2014-04-28 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 9 | 2014-04-28-80ef1083-11362-0 |
bbaf75dd7384aefc0b3d0ca3f9b23075212cb25d | Destination of visit: Japan (Tokyo, Nagoya and Kyoto) | Overseas visits 80ef1083 | 2014-04-28 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 10 | 2014-04-28-80ef1083-11362-0 |
bcd88164b66dd8f836c5ccd16b065d3ab590bd41 | Date of visit: 26-31 March 2013 | Overseas visits 80ef1083 | 2014-04-28 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 11 | 2014-04-28-80ef1083-11362-0 |
c30c67b2a4b2b17447a44de6bbea742fc9f0439e | Purpose of visit: to meet senior figures in the new government, private sector and academia in capacity as Shadow Minister for Competitiveness and Enterprise. | Overseas visits 80ef1083 | 2014-04-28 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 12 | 2014-04-28-80ef1083-11362-0 |
1a76dc75835343d06f1648c53cfdad4559d60514 | (Registered 24 April 2013) | Overseas visits 80ef1083 | 2014-04-28 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 13 | 2014-04-28-80ef1083-11362-0 |
3cc7a43a48f265d063f45fe99a7523a2c09331c9 | Name of donor: Inmarsat | Overseas visits 80ef1083 | 2014-04-28 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 14 | 2014-04-28-80ef1083-11362-0 |
00261cce61c2bc4f82c2970ab3ebe5ef21680e6e | Address of donor: 99 City Road, London EC1Y 1AX | Overseas visits 80ef1083 | 2014-04-28 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 15 | 2014-04-28-80ef1083-11362-0 |
56859f172a015809ede707698d53fb72bfe51b8b | Amount of donation (or estimate of the probable value): Flights, £5,693 (including tax); accommodation, £362; total £6,055 | Overseas visits 80ef1083 | 2014-04-28 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 16 | 2014-04-28-80ef1083-11362-0 |
b801aa8341aef2f4896a6d93ef7d67d4b4e434eb | Destination of visit: Cayenne, French Guiana | Overseas visits 80ef1083 | 2014-04-28 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 17 | 2014-04-28-80ef1083-11362-0 |
43f6078e4fa3a0aae238dc35d6eb6568dba50cb2 | Date of visit: 24-26 July 2013 | Overseas visits 80ef1083 | 2014-04-28 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 18 | 2014-04-28-80ef1083-11362-0 |
cb23a378352e0427200ce0c9d4a69dcfbbb3ade2 | Purpose of visit: to view launch of Alphasat satellite in capacity as Shadow Minister for Competitiveness and Enterprise. | Overseas visits 80ef1083 | 2014-04-28 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 19 | 2014-04-28-80ef1083-11362-0 |
0bafa6c859546caa390b399f54b1713eeff43c86 | (Registered 20 August 2013) | Overseas visits 80ef1083 | 2014-04-28 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 20 | 2014-04-28-80ef1083-11362-0 |
6e9250641d26cf80f52eafa7c51801f895dc3520 | Name of donor: North East Process Industry Cluster (NEPIC) | Overseas visits 80ef1083 | 2014-04-28 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 21 | 2014-04-28-80ef1083-11362-0 |
36ee487904e10ff0db503cfb11a17d6bc9581c97 | Address of donor: Room H224, The Wilton Centre, Wilton, Redcar TS10 4RF | Overseas visits 80ef1083 | 2014-04-28 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 22 | 2014-04-28-80ef1083-11362-0 |
67966b179dd909690f64094e0d89ddc276dfbfa0 | Amount of donation (or estimate of the probable value): £3,391 paid direct by NEPIC, towards travel and accommodation | Overseas visits 80ef1083 | 2014-04-28 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 23 | 2014-04-28-80ef1083-11362-0 |
83e3c60f2a81c1372cfcec86df6336c7070033c2 | Destination of visit: Mumbai and Bangalore, India | Overseas visits 80ef1083 | 2014-04-28 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 24 | 2014-04-28-80ef1083-11362-0 |
7a5eb57c4b902cee3f8f7551acd26639b97f541f | Date of visit: 1-9 March 2014 | Overseas visits 80ef1083 | 2014-04-28 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 25 | 2014-04-28-80ef1083-11362-0 |
ecde80eebb07067cf08f54564fb9da57d43d6953 | Purpose of visit: process industry trade mission | Overseas visits 80ef1083 | 2014-04-28 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 26 | 2014-04-28-80ef1083-11362-0 |
352f19bf3f705e69117789a15086ae2011a40b09 | (Registered 28 March 2014) | Overseas visits 80ef1083 | 2014-04-28 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 27 | 2014-04-28-80ef1083-11362-0 |
Advanced export
JSON shape: default, array, newline-delimited, object
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) ); CREATE INDEX items_date ON items("date"); CREATE INDEX items_category_id ON items("category_id"); CREATE INDEX items_member_id ON items("member_id"); CREATE INDEX items_person_id ON items("person_id"); CREATE INDEX items_record_id ON items("record_id");