items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
35 rows where record_id = "2014-10-27-b30ee7b9-10574-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 |
---|---|---|---|---|---|---|---|
5958ea2b73b411664fc1b00f1d61030137ff2ce1 | Name of donor: Anna Lindh Foundation, | Overseas visits b30ee7b9 | 2014-10-27 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 0 | 2014-10-27-b30ee7b9-10574-0 |
56b3e36edce8a534a63bde2975a00282eb212ec0 | Address of donor: Stiftelsen Anna Lindhs Minnesfond, Lilla Nygatan 14, Box 2170, 103 14 Stockholm | Overseas visits b30ee7b9 | 2014-10-27 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 1 | 2014-10-27-b30ee7b9-10574-0 |
6bf040a4e6c886a92d224e1a715c64d336fb30e2 | Amount of donation (or estimate of the probable value): Return flights (Business Class) between Heathrow and Stockholm 10 and 12 September 2013, value £761.50 | Overseas visits b30ee7b9 | 2014-10-27 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 2 | 2014-10-27-b30ee7b9-10574-0 |
551e68c1a1b2e6a6dd59d96e9047b9005d823668 | Destination of visit: Stockholm | Overseas visits b30ee7b9 | 2014-10-27 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 3 | 2014-10-27-b30ee7b9-10574-0 |
01e99bb48b9877a6a9be57137c9025489575b188 | Date of visit: 10-12 September 2013 | Overseas visits b30ee7b9 | 2014-10-27 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 4 | 2014-10-27-b30ee7b9-10574-0 |
82b6f26659335c2cd21c851bdce98ba639e36fd7 | Purpose of visit: to attend the tenth anniversary commemoration for Anna Lindh, former Foreign Minister of Sweden, murdered on 11th September 2003. | Overseas visits b30ee7b9 | 2014-10-27 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 5 | 2014-10-27-b30ee7b9-10574-0 |
2335af62f91f14dcc0c0e42129b5299c77afc5d2 | (Registered 8 October 2013) | Overseas visits b30ee7b9 | 2014-10-27 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 6 | 2014-10-27-b30ee7b9-10574-0 |
71f0139f190947825680db09719355c6a8167043 | Name of donor: British-Turkish Tatlidil | Overseas visits b30ee7b9 | 2014-10-27 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 8 | 2014-10-27-b30ee7b9-10574-0 |
df1d8838d8d3409c040fafc47f31910f108aea13 | Address of donor: Green Man House, Cowlinge, Newmarket, Suffolk CB8 9QA | Overseas visits b30ee7b9 | 2014-10-27 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 9 | 2014-10-27-b30ee7b9-10574-0 |
689b4c0d423d7600f22d1ae9025288d7c68edded | Amount of donation (or estimate of the probable value): flights with a value of £1,182.95 plus taxis costing £89 and hotel accommodation costing £120.50; total £1,392. | Overseas visits b30ee7b9 | 2014-10-27 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 10 | 2014-10-27-b30ee7b9-10574-0 |
2d107b7b67d91677ad5a316185989b9aa8da4687 | Destination of visit: Istanbul, Turkey | Overseas visits b30ee7b9 | 2014-10-27 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 11 | 2014-10-27-b30ee7b9-10574-0 |
0a2dae3108ab4f764d8517ee01e872d6cd20088b | Date of visit: 2-3 October 2013 | Overseas visits b30ee7b9 | 2014-10-27 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 12 | 2014-10-27-b30ee7b9-10574-0 |
6cf0016d109ede67b95e66437b19c8199cd3456d | Purpose of visit: to participate in a meeting in my capacity as British Co-Chair of the British Turkish Forum (the 'Tatlidil') | Overseas visits b30ee7b9 | 2014-10-27 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 13 | 2014-10-27-b30ee7b9-10574-0 |
7394a1279f9b824e79e34628026ba511d07b91d7 | (Registered 31 October 2013) | Overseas visits b30ee7b9 | 2014-10-27 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 14 | 2014-10-27-b30ee7b9-10574-0 |
b242921aea817150125b517545f415603b35a1f4 | Name of donor: Medical Aid for Palestinians | Overseas visits b30ee7b9 | 2014-10-27 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 16 | 2014-10-27-b30ee7b9-10574-0 |
19eb8d0adb6024484db395a22f25fa7c800b6012 | Address of donor: 33a Islington Park Street, London N1 1QB Amount of donation (or estimate of the probable value): travel costs, accommodation and subsistence with a value of £1,175 | Overseas visits b30ee7b9 | 2014-10-27 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 17 | 2014-10-27-b30ee7b9-10574-0 |
573ab222134cb69dd51347cb9b9aa7c907430b66 | Destination of visit: West Bank and Israel | Overseas visits b30ee7b9 | 2014-10-27 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 18 | 2014-10-27-b30ee7b9-10574-0 |
cd675e3280d34dc3f8845ddde386a4ebdbc8ed19 | Date of visit: 9-13 December 2013 | Overseas visits b30ee7b9 | 2014-10-27 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 19 | 2014-10-27-b30ee7b9-10574-0 |
a4e7ff9f68817154d286996f59d3721401b1162c | Purpose of visit: Fact-finding delegation organised by Council for Arab-British Understanding | Overseas visits b30ee7b9 | 2014-10-27 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 20 | 2014-10-27-b30ee7b9-10574-0 |
888e3dfe71a85e9af2d3dd5ced2af06dc445f018 | (Registered 17 December 2013) | Overseas visits b30ee7b9 | 2014-10-27 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 21 | 2014-10-27-b30ee7b9-10574-0 |
32cb0a7789a37d150304c26bd8e5dd3f1d21e9e3 | Overseas visits b30ee7b9 | 2014-10-27 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 22 | 2014-10-27-b30ee7b9-10574-0 | |
054206b32349ea49c6281dee4ea7218c5ade32d7 | Name of donor: (1) Ardeshir Nagashineh, Chairman of Targetfollow PLC; (2) the Majlis , the Parliament of the Islamic Republic of Iran (Iran-United Kingdom Parliamentary Friendship Group) | Overseas visits b30ee7b9 | 2014-10-27 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 23 | 2014-10-27-b30ee7b9-10574-0 |
3762b54947030b72eee6f90a9ab33eb118532331 | Address of donor: (1) Targetfollow Group Ltd, Riverside House, 11/12 Riverside Road, Norwich NR1 1SQ; (2) Baherestan Square, Tehran, Iran | Overseas visits b30ee7b9 | 2014-10-27 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 24 | 2014-10-27-b30ee7b9-10574-0 |
9675ddc716c507aa2a2cf87b9f40c02c623c32e4 | Amount of donation (or estimate of the probable value): (1) £373.84, being the balance of the return flights from London to Tehran (via Frankfurt), Business Class, 6 and 10 January 2014. Total cost £1,623.84 – the remainder being met by a non-registrable source; (2) 4 nights hotel accommodation in Tehran at estimated cost of £392.84, plus meals and transport for 4 days at estimated cost of £300. | Overseas visits b30ee7b9 | 2014-10-27 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 25 | 2014-10-27-b30ee7b9-10574-0 |
e17b145807fa5a5e1cf9ee287018d1868a6559d6 | Destination of visit: Tehran, Iran | Overseas visits b30ee7b9 | 2014-10-27 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 26 | 2014-10-27-b30ee7b9-10574-0 |
10348da1651664139849fdb90e3bbd27f4bcd628 | Date of visit: 6-10 January 2014 | Overseas visits b30ee7b9 | 2014-10-27 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 27 | 2014-10-27-b30ee7b9-10574-0 |
dc2a4574433d1a570d4f152de66c7acd4d3adb89 | Purpose of visit: visit by the All-Party Parliamentary Group on Iran at the invitation of the Iran-UK Parliamentary Friendship Group of the Iranian Parliament. | Overseas visits b30ee7b9 | 2014-10-27 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 28 | 2014-10-27-b30ee7b9-10574-0 |
abb7bcb36d89f312eb7c0d52988be67f5ed92fda | (Registered 19 January 2014) | Overseas visits b30ee7b9 | 2014-10-27 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 29 | 2014-10-27-b30ee7b9-10574-0 |
ca428f382aafbfdfb1c5661386c66778be752214 | Name of donor: Akfen Holding | Overseas visits b30ee7b9 | 2014-10-27 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 30 | 2014-10-27-b30ee7b9-10574-0 |
7f9c884683cef462347b70044666fba234357fcd | Address of donor: Koza Sok No: 22 GOP, Ankara, Turkey. | Overseas visits b30ee7b9 | 2014-10-27 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 31 | 2014-10-27-b30ee7b9-10574-0 |
ad13cde9b50dcfeff0e6615ab4fe8b9538a2d0b3 | Amount of donation (or estimate of the probable value): flights from Bursa to Ankara and back to Istanbul, with a value of £6,753.30 | Overseas visits b30ee7b9 | 2014-10-27 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 32 | 2014-10-27-b30ee7b9-10574-0 |
684e798dcb90b685ca16a53dcc49c2a0962d11d0 | Destination of visit: Ankara, Turkey | Overseas visits b30ee7b9 | 2014-10-27 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 33 | 2014-10-27-b30ee7b9-10574-0 |
e49af0c1f64da7ca40f2fac1e6a426d0fd74399c | Date of visit: 22 March 2014 | Overseas visits b30ee7b9 | 2014-10-27 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 34 | 2014-10-27-b30ee7b9-10574-0 |
06f1e92c482e6d30cca104c13c1be4df863bc322 | Purpose of visit: to meet a senior member of the Turkish government | Overseas visits b30ee7b9 | 2014-10-27 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 35 | 2014-10-27-b30ee7b9-10574-0 |
dc4273ca843cd36278acead3da98c0c182bd7c0b | (Registered 28 April 2014) | Overseas visits b30ee7b9 | 2014-10-27 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 36 | 2014-10-27-b30ee7b9-10574-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");