items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
35 rows where record_id = "2014-10-13-b30ee7b9-10574-0" sorted by date descending
This data as json, CSV (advanced)
Suggested facets: date (date)
hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
fcf9a8ed3db9c093610322a5f739de6a1a7d8c62 | Name of donor: Anna Lindh Foundation, | Overseas visits b30ee7b9 | 2014-10-13 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 0 | 2014-10-13-b30ee7b9-10574-0 |
210b8d3fffeb6033263a2e6e09a909eb6b98ae04 | Address of donor: Stiftelsen Anna Lindhs Minnesfond, Lilla Nygatan 14, Box 2170, 103 14 Stockholm | Overseas visits b30ee7b9 | 2014-10-13 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 1 | 2014-10-13-b30ee7b9-10574-0 |
e481e11d08664350ae0465a505e8c5f70228fd13 | 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-13 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 2 | 2014-10-13-b30ee7b9-10574-0 |
1d575afd3ae3d4b6508466fa7845129aa371c848 | Destination of visit: Stockholm | Overseas visits b30ee7b9 | 2014-10-13 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 3 | 2014-10-13-b30ee7b9-10574-0 |
2de0c6dfb19ce08a8f98c8a501aa78d2aa8ba6ab | Date of visit: 10-12 September 2013 | Overseas visits b30ee7b9 | 2014-10-13 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 4 | 2014-10-13-b30ee7b9-10574-0 |
fa242c0a90cb068784b4af728ffd3347f1a34126 | 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-13 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 5 | 2014-10-13-b30ee7b9-10574-0 |
33b07771143166cb8f7d51977e32d9f543c69994 | (Registered 8 October 2013) | Overseas visits b30ee7b9 | 2014-10-13 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 6 | 2014-10-13-b30ee7b9-10574-0 |
559b45697d35282e7cabce383cb00061ae1dbc04 | Name of donor: British-Turkish Tatlidil | Overseas visits b30ee7b9 | 2014-10-13 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 8 | 2014-10-13-b30ee7b9-10574-0 |
232ddddf319a2f23f2b718bd6b6f231ce88f6c48 | Address of donor: Green Man House, Cowlinge, Newmarket, Suffolk CB8 9QA | Overseas visits b30ee7b9 | 2014-10-13 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 9 | 2014-10-13-b30ee7b9-10574-0 |
33aa01ebb37d1b4aa3d0b9cb7c69d8df6d67d1d9 | 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-13 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 10 | 2014-10-13-b30ee7b9-10574-0 |
5690806d390ffe22ae95806a89d1400b1b0573bb | Destination of visit: Istanbul, Turkey | Overseas visits b30ee7b9 | 2014-10-13 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 11 | 2014-10-13-b30ee7b9-10574-0 |
a19fbb9fbfa352ab0f77fc067f2f39ac6736749d | Date of visit: 2-3 October 2013 | Overseas visits b30ee7b9 | 2014-10-13 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 12 | 2014-10-13-b30ee7b9-10574-0 |
241cf197f7da4006c95cc47cbafd29dec77872e5 | 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-13 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 13 | 2014-10-13-b30ee7b9-10574-0 |
96e6c1bb1839622460ea02178503d7cb441580c9 | (Registered 31 October 2013) | Overseas visits b30ee7b9 | 2014-10-13 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 14 | 2014-10-13-b30ee7b9-10574-0 |
4f0eeb315e55627b5b85d81979785bc26168c8de | Name of donor: Medical Aid for Palestinians | Overseas visits b30ee7b9 | 2014-10-13 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 16 | 2014-10-13-b30ee7b9-10574-0 |
336a98167e615440d2c5de299676895570e84758 | 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-13 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 17 | 2014-10-13-b30ee7b9-10574-0 |
34d2f4d0a5d4b86437ae986b2abd5fc8c5011fc5 | Destination of visit: West Bank and Israel | Overseas visits b30ee7b9 | 2014-10-13 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 18 | 2014-10-13-b30ee7b9-10574-0 |
6871c6ebb2f02a6af0725c83e7979c20d33681b6 | Date of visit: 9-13 December 2013 | Overseas visits b30ee7b9 | 2014-10-13 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 19 | 2014-10-13-b30ee7b9-10574-0 |
3dfb28695365d31fd1d2e7ec118420fde1a72d13 | Purpose of visit: Fact-finding delegation organised by Council for Arab-British Understanding | Overseas visits b30ee7b9 | 2014-10-13 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 20 | 2014-10-13-b30ee7b9-10574-0 |
893a0b2495f3695c507f2563fec35f07cd70d6f8 | (Registered 17 December 2013) | Overseas visits b30ee7b9 | 2014-10-13 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 21 | 2014-10-13-b30ee7b9-10574-0 |
c10b713f076aaca052b6193436d007de3fbf67ba | Overseas visits b30ee7b9 | 2014-10-13 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 22 | 2014-10-13-b30ee7b9-10574-0 | |
72fc18caa032d747d2f83ba3ec6620c734bdee50 | 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-13 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 23 | 2014-10-13-b30ee7b9-10574-0 |
e5ee108b3354ed4f00e1a21bc5aef8e2055e76a3 | 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-13 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 24 | 2014-10-13-b30ee7b9-10574-0 |
a845ed7da9c00db4dabf58071348c648b8121b48 | 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-13 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 25 | 2014-10-13-b30ee7b9-10574-0 |
2991caf5dbdee548c11b2a1a455e845d03309cd7 | Destination of visit: Tehran, Iran | Overseas visits b30ee7b9 | 2014-10-13 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 26 | 2014-10-13-b30ee7b9-10574-0 |
2543ae8f9f4348720f86d4eee27574b800392cf7 | Date of visit: 6-10 January 2014 | Overseas visits b30ee7b9 | 2014-10-13 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 27 | 2014-10-13-b30ee7b9-10574-0 |
d48d53ea12538a1f682224479257686817c4a89c | 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-13 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 28 | 2014-10-13-b30ee7b9-10574-0 |
76ab4118b838cde37cf2141ac21a97ee66eb5083 | (Registered 19 January 2014) | Overseas visits b30ee7b9 | 2014-10-13 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 29 | 2014-10-13-b30ee7b9-10574-0 |
77cd2969715997044f97c05c63bc6596019a8dc3 | Name of donor: Akfen Holding | Overseas visits b30ee7b9 | 2014-10-13 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 30 | 2014-10-13-b30ee7b9-10574-0 |
0bab849639072043fdbd58cb2255ce444040b2e0 | Address of donor: Koza Sok No: 22 GOP, Ankara, Turkey. | Overseas visits b30ee7b9 | 2014-10-13 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 31 | 2014-10-13-b30ee7b9-10574-0 |
7476ac7bdf8dfaa6a5c1d4f817a5fc36de9b1f9c | 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-13 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 32 | 2014-10-13-b30ee7b9-10574-0 |
bc0da3bad1deb132171751008c2482bb5817d3d4 | Destination of visit: Ankara, Turkey | Overseas visits b30ee7b9 | 2014-10-13 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 33 | 2014-10-13-b30ee7b9-10574-0 |
3cedcfb2be2285243b3d74b3b7a71c2d7a4e306f | Date of visit: 22 March 2014 | Overseas visits b30ee7b9 | 2014-10-13 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 34 | 2014-10-13-b30ee7b9-10574-0 |
99cf9cd1c90d8ade6e82a7837381b6ce72074ef5 | Purpose of visit: to meet a senior member of the Turkish government | Overseas visits b30ee7b9 | 2014-10-13 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 35 | 2014-10-13-b30ee7b9-10574-0 |
a5ba78529d67faba83f53e59743f97fb1603736d | (Registered 28 April 2014) | Overseas visits b30ee7b9 | 2014-10-13 | Jack Straw uk.org.publicwhip/member/40090 | Jack Straw uk.org.publicwhip/person/10574 | 36 | 2014-10-13-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");