Data source: mySociety Data · About: simonw/register-of-members-interests-datasette

56 rows where category_id = "7c43f5eb" sorted by date descending

View and edit SQL

Suggested facets: item, date, sort_order, record_id, date (date)

hash item category_id date ▲ member_id person_id sort_order record_id
ccdabc0ed5662ea5b3c58981935bf2df9b9d48fb Name of donor: Akfen Holding  Overseas visits     7c43f5eb 2015-03-30 Jack Straw uk.org.publicwhip/member/40090 Jack Straw uk.org.publicwhip/person/10574 0 2015-03-30-7c43f5eb-10574-0
b9b1cfe3f07c37a16b963e3970d064fdbd58fe9b Address of donor: Koza Sok No: 22 GOP, Ankara, Turkey. Overseas visits     7c43f5eb 2015-03-30 Jack Straw uk.org.publicwhip/member/40090 Jack Straw uk.org.publicwhip/person/10574 1 2015-03-30-7c43f5eb-10574-0
52fd14f642235b40672f6a8c587ef49e3f1f17aa 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     7c43f5eb 2015-03-30 Jack Straw uk.org.publicwhip/member/40090 Jack Straw uk.org.publicwhip/person/10574 2 2015-03-30-7c43f5eb-10574-0
61cef7803204627877797c50191cfa8af0a5cdd4 Destination of visit: Ankara, Turkey Overseas visits     7c43f5eb 2015-03-30 Jack Straw uk.org.publicwhip/member/40090 Jack Straw uk.org.publicwhip/person/10574 3 2015-03-30-7c43f5eb-10574-0
61076e01b1066299d70a73ac28d6e7c2a65c019d Date of visit: 22 March 2014 Overseas visits     7c43f5eb 2015-03-30 Jack Straw uk.org.publicwhip/member/40090 Jack Straw uk.org.publicwhip/person/10574 4 2015-03-30-7c43f5eb-10574-0
0ca234582b5386fdf89d35c636437eacf6a0056b Purpose of visit: to meet a senior member of the Turkish government Overseas visits     7c43f5eb 2015-03-30 Jack Straw uk.org.publicwhip/member/40090 Jack Straw uk.org.publicwhip/person/10574 5 2015-03-30-7c43f5eb-10574-0
2cb477f64db0ab60fc82c38bd91e3bcf9d4397cc (Registered 28 April 2014) Overseas visits     7c43f5eb 2015-03-30 Jack Straw uk.org.publicwhip/member/40090 Jack Straw uk.org.publicwhip/person/10574 6 2015-03-30-7c43f5eb-10574-0
1e4ad9c84c0fa61a355254aeefa6b3e79d2f38c6 Name of donor: Akfen Holding  Overseas visits     7c43f5eb 2015-03-09 Jack Straw uk.org.publicwhip/member/40090 Jack Straw uk.org.publicwhip/person/10574 0 2015-03-09-7c43f5eb-10574-0
a4a4a1f531fa74e6391f6b935f8fe07a4eb51dc6 Address of donor: Koza Sok No: 22 GOP, Ankara, Turkey. Overseas visits     7c43f5eb 2015-03-09 Jack Straw uk.org.publicwhip/member/40090 Jack Straw uk.org.publicwhip/person/10574 1 2015-03-09-7c43f5eb-10574-0
c08f7146cef6cb3f5fe338f51172e6894f525bdc 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     7c43f5eb 2015-03-09 Jack Straw uk.org.publicwhip/member/40090 Jack Straw uk.org.publicwhip/person/10574 2 2015-03-09-7c43f5eb-10574-0
38ab1d1524d25166619272d23699d23632de9878 Destination of visit: Ankara, Turkey Overseas visits     7c43f5eb 2015-03-09 Jack Straw uk.org.publicwhip/member/40090 Jack Straw uk.org.publicwhip/person/10574 3 2015-03-09-7c43f5eb-10574-0
bba497aaf4d4eded7921299e3c0e574b24f28850 Date of visit: 22 March 2014 Overseas visits     7c43f5eb 2015-03-09 Jack Straw uk.org.publicwhip/member/40090 Jack Straw uk.org.publicwhip/person/10574 4 2015-03-09-7c43f5eb-10574-0
efbf3a3cd912c59dbc52280f985c691f0003348d Purpose of visit: to meet a senior member of the Turkish government Overseas visits     7c43f5eb 2015-03-09 Jack Straw uk.org.publicwhip/member/40090 Jack Straw uk.org.publicwhip/person/10574 5 2015-03-09-7c43f5eb-10574-0
e69792f50fb5faad0f8b193a2ab5da834200c531 (Registered 28 April 2014) Overseas visits     7c43f5eb 2015-03-09 Jack Straw uk.org.publicwhip/member/40090 Jack Straw uk.org.publicwhip/person/10574 6 2015-03-09-7c43f5eb-10574-0
2f9bfa75b8fb92e857707043f988ffd60b456af3 Name of donor: Akfen Holding  Overseas visits     7c43f5eb 2015-02-23 Jack Straw uk.org.publicwhip/member/40090 Jack Straw uk.org.publicwhip/person/10574 0 2015-02-23-7c43f5eb-10574-0
7296b7cd3115200f5b4dbe42f4f8f38b5e29f6af Address of donor: Koza Sok No: 22 GOP, Ankara, Turkey. Overseas visits     7c43f5eb 2015-02-23 Jack Straw uk.org.publicwhip/member/40090 Jack Straw uk.org.publicwhip/person/10574 1 2015-02-23-7c43f5eb-10574-0
3bdbe43ae0682a378699a19e6aac471900a1c2c7 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     7c43f5eb 2015-02-23 Jack Straw uk.org.publicwhip/member/40090 Jack Straw uk.org.publicwhip/person/10574 2 2015-02-23-7c43f5eb-10574-0
210fcb8bc4262b075ed0fa57691d5f71701be412 Destination of visit: Ankara, Turkey Overseas visits     7c43f5eb 2015-02-23 Jack Straw uk.org.publicwhip/member/40090 Jack Straw uk.org.publicwhip/person/10574 3 2015-02-23-7c43f5eb-10574-0
20145a333c69643716c1df2c3a40c9c3ac1fc367 Date of visit: 22 March 2014 Overseas visits     7c43f5eb 2015-02-23 Jack Straw uk.org.publicwhip/member/40090 Jack Straw uk.org.publicwhip/person/10574 4 2015-02-23-7c43f5eb-10574-0
82819911f126f070482be3dcbad7128178ef2be4 Purpose of visit: to meet a senior member of the Turkish government Overseas visits     7c43f5eb 2015-02-23 Jack Straw uk.org.publicwhip/member/40090 Jack Straw uk.org.publicwhip/person/10574 5 2015-02-23-7c43f5eb-10574-0
979d66241fc2555911bdda070c672ed2895c44cd (Registered 28 April 2014) Overseas visits     7c43f5eb 2015-02-23 Jack Straw uk.org.publicwhip/member/40090 Jack Straw uk.org.publicwhip/person/10574 6 2015-02-23-7c43f5eb-10574-0
6921f2d46436e7726738c5a4b2cc9880c50dc652 Name of donor: Akfen Holding  Overseas visits     7c43f5eb 2015-02-09 Jack Straw uk.org.publicwhip/member/40090 Jack Straw uk.org.publicwhip/person/10574 0 2015-02-09-7c43f5eb-10574-0
5eb34a4fc3b33619a8158d199379a4054dd91a04 Address of donor: Koza Sok No: 22 GOP, Ankara, Turkey. Overseas visits     7c43f5eb 2015-02-09 Jack Straw uk.org.publicwhip/member/40090 Jack Straw uk.org.publicwhip/person/10574 1 2015-02-09-7c43f5eb-10574-0
96274778901c1f9e1b54ec563f3c5602e46d1201 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     7c43f5eb 2015-02-09 Jack Straw uk.org.publicwhip/member/40090 Jack Straw uk.org.publicwhip/person/10574 2 2015-02-09-7c43f5eb-10574-0
0886bfe026c58516cac928f156f3232e666b51ae Destination of visit: Ankara, Turkey Overseas visits     7c43f5eb 2015-02-09 Jack Straw uk.org.publicwhip/member/40090 Jack Straw uk.org.publicwhip/person/10574 3 2015-02-09-7c43f5eb-10574-0
4997bf9e2031ed0b895ce6ba80ea50cd7d099d4c Date of visit: 22 March 2014 Overseas visits     7c43f5eb 2015-02-09 Jack Straw uk.org.publicwhip/member/40090 Jack Straw uk.org.publicwhip/person/10574 4 2015-02-09-7c43f5eb-10574-0
4610a543d25d6a0f6ee89894e4441dfea644a30f Purpose of visit: to meet a senior member of the Turkish government Overseas visits     7c43f5eb 2015-02-09 Jack Straw uk.org.publicwhip/member/40090 Jack Straw uk.org.publicwhip/person/10574 5 2015-02-09-7c43f5eb-10574-0
c03dad34bcf1d6f5c7eaffeb4b46e37ed4208c81 (Registered 28 April 2014) Overseas visits     7c43f5eb 2015-02-09 Jack Straw uk.org.publicwhip/member/40090 Jack Straw uk.org.publicwhip/person/10574 6 2015-02-09-7c43f5eb-10574-0
642c8edace686e78c3143801e244647ef38812a9 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     7c43f5eb 2015-01-26 Jack Straw uk.org.publicwhip/member/40090 Jack Straw uk.org.publicwhip/person/10574 0 2015-01-26-7c43f5eb-10574-0
6c84d9e35cc57f21d3d23b7639d009d8c138de07 Address of donor: (1) Targetfollow Group Ltd, Riverside House, 11/12 Riverside Road, Norwich NR1 1SQ; (2) Baherestan Square, Tehran, Iran Overseas visits     7c43f5eb 2015-01-26 Jack Straw uk.org.publicwhip/member/40090 Jack Straw uk.org.publicwhip/person/10574 1 2015-01-26-7c43f5eb-10574-0
2444a44af654969a203b6f077195ab5924852fdb 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     7c43f5eb 2015-01-26 Jack Straw uk.org.publicwhip/member/40090 Jack Straw uk.org.publicwhip/person/10574 2 2015-01-26-7c43f5eb-10574-0
eb90253fb74346ee8daa688dc901170b1ffa3baa Destination of visit: Tehran, Iran Overseas visits     7c43f5eb 2015-01-26 Jack Straw uk.org.publicwhip/member/40090 Jack Straw uk.org.publicwhip/person/10574 3 2015-01-26-7c43f5eb-10574-0
63d2518c0cf91c93acd88f421ad3a2f5a29b4600 Date of visit: 6-10 January 2014 Overseas visits     7c43f5eb 2015-01-26 Jack Straw uk.org.publicwhip/member/40090 Jack Straw uk.org.publicwhip/person/10574 4 2015-01-26-7c43f5eb-10574-0
2b6251581bb8d3fd6453e9f4892945010990dab5 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     7c43f5eb 2015-01-26 Jack Straw uk.org.publicwhip/member/40090 Jack Straw uk.org.publicwhip/person/10574 5 2015-01-26-7c43f5eb-10574-0
e59b360c4fdda5affa471a610bb5d50df6d82c81 (Registered 19 January 2014) Overseas visits     7c43f5eb 2015-01-26 Jack Straw uk.org.publicwhip/member/40090 Jack Straw uk.org.publicwhip/person/10574 6 2015-01-26-7c43f5eb-10574-0
bfcc09bbc7d0e0a2a2d21daeb7c8f90d3bed1c49 Name of donor: Akfen Holding  Overseas visits     7c43f5eb 2015-01-26 Jack Straw uk.org.publicwhip/member/40090 Jack Straw uk.org.publicwhip/person/10574 0 2015-01-26-7c43f5eb-10574-1
fd24496d5fda7c8f56d5288c576a826fdf4c4638 Address of donor: Koza Sok No: 22 GOP, Ankara, Turkey. Overseas visits     7c43f5eb 2015-01-26 Jack Straw uk.org.publicwhip/member/40090 Jack Straw uk.org.publicwhip/person/10574 1 2015-01-26-7c43f5eb-10574-1
664403e65eb49a2ec3fe1642bae22694f0e91f1f 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     7c43f5eb 2015-01-26 Jack Straw uk.org.publicwhip/member/40090 Jack Straw uk.org.publicwhip/person/10574 2 2015-01-26-7c43f5eb-10574-1
195bbfbbb02b049115b6dc815e0d29eea179ecd9 Destination of visit: Ankara, Turkey Overseas visits     7c43f5eb 2015-01-26 Jack Straw uk.org.publicwhip/member/40090 Jack Straw uk.org.publicwhip/person/10574 3 2015-01-26-7c43f5eb-10574-1
693fcfa4dcf0d8dada49059dc806d04da4a927cd Date of visit: 22 March 2014 Overseas visits     7c43f5eb 2015-01-26 Jack Straw uk.org.publicwhip/member/40090 Jack Straw uk.org.publicwhip/person/10574 4 2015-01-26-7c43f5eb-10574-1
9c39e23621c042d498939d4d02d52049cf5466f3 Purpose of visit: to meet a senior member of the Turkish government Overseas visits     7c43f5eb 2015-01-26 Jack Straw uk.org.publicwhip/member/40090 Jack Straw uk.org.publicwhip/person/10574 5 2015-01-26-7c43f5eb-10574-1
075f8f35fde20f6a9d348315196f7aaa9845363b (Registered 28 April 2014) Overseas visits     7c43f5eb 2015-01-26 Jack Straw uk.org.publicwhip/member/40090 Jack Straw uk.org.publicwhip/person/10574 6 2015-01-26-7c43f5eb-10574-1
25c1f74a772532d52206ca7fe242e4a79ce9debe 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     7c43f5eb 2015-01-06 Jack Straw uk.org.publicwhip/member/40090 Jack Straw uk.org.publicwhip/person/10574 0 2015-01-06-7c43f5eb-10574-0
1ccf5319d35a0a140959afd340cc73729e531534 Address of donor: (1) Targetfollow Group Ltd, Riverside House, 11/12 Riverside Road, Norwich NR1 1SQ; (2) Baherestan Square, Tehran, Iran Overseas visits     7c43f5eb 2015-01-06 Jack Straw uk.org.publicwhip/member/40090 Jack Straw uk.org.publicwhip/person/10574 1 2015-01-06-7c43f5eb-10574-0
bf2201322dbb522ce4b1a20ee6e280fd75a1bb8a 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     7c43f5eb 2015-01-06 Jack Straw uk.org.publicwhip/member/40090 Jack Straw uk.org.publicwhip/person/10574 2 2015-01-06-7c43f5eb-10574-0
5de4741bab0b2dbad6e5a0bcefa28a993b210935 Destination of visit: Tehran, Iran Overseas visits     7c43f5eb 2015-01-06 Jack Straw uk.org.publicwhip/member/40090 Jack Straw uk.org.publicwhip/person/10574 3 2015-01-06-7c43f5eb-10574-0
b2a74c7fd9ae81d56f89452bad8e3b21f068b46d Date of visit: 6-10 January 2014 Overseas visits     7c43f5eb 2015-01-06 Jack Straw uk.org.publicwhip/member/40090 Jack Straw uk.org.publicwhip/person/10574 4 2015-01-06-7c43f5eb-10574-0
2dc12943a133f3b2af02d9a7236275107153d8de 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     7c43f5eb 2015-01-06 Jack Straw uk.org.publicwhip/member/40090 Jack Straw uk.org.publicwhip/person/10574 5 2015-01-06-7c43f5eb-10574-0
20aa07716d460b698af7075ac627681feef6bf4d (Registered 19 January 2014) Overseas visits     7c43f5eb 2015-01-06 Jack Straw uk.org.publicwhip/member/40090 Jack Straw uk.org.publicwhip/person/10574 6 2015-01-06-7c43f5eb-10574-0
9a97e69f3b6a30298bcedde45f9bfa60701b877f Name of donor: Akfen Holding  Overseas visits     7c43f5eb 2015-01-06 Jack Straw uk.org.publicwhip/member/40090 Jack Straw uk.org.publicwhip/person/10574 7 2015-01-06-7c43f5eb-10574-0
edec110d20446855802f254f96bdd8d4ea42811b Address of donor: Koza Sok No: 22 GOP, Ankara, Turkey. Overseas visits     7c43f5eb 2015-01-06 Jack Straw uk.org.publicwhip/member/40090 Jack Straw uk.org.publicwhip/person/10574 8 2015-01-06-7c43f5eb-10574-0
a0aaf16e46815b122f3ed4f53624951810f0dec0 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     7c43f5eb 2015-01-06 Jack Straw uk.org.publicwhip/member/40090 Jack Straw uk.org.publicwhip/person/10574 9 2015-01-06-7c43f5eb-10574-0
d11d2f415905a6ff968b3fe66ba4b8aec04aad65 Destination of visit: Ankara, Turkey Overseas visits     7c43f5eb 2015-01-06 Jack Straw uk.org.publicwhip/member/40090 Jack Straw uk.org.publicwhip/person/10574 10 2015-01-06-7c43f5eb-10574-0
1742d550501317e476e08483d3e7d0cfcd7fcfea Date of visit: 22 March 2014 Overseas visits     7c43f5eb 2015-01-06 Jack Straw uk.org.publicwhip/member/40090 Jack Straw uk.org.publicwhip/person/10574 11 2015-01-06-7c43f5eb-10574-0
3daf665e4694f9e69b6ffafef47887e401cfcb4f Purpose of visit: to meet a senior member of the Turkish government Overseas visits     7c43f5eb 2015-01-06 Jack Straw uk.org.publicwhip/member/40090 Jack Straw uk.org.publicwhip/person/10574 12 2015-01-06-7c43f5eb-10574-0
d9020bb161ca1cc10224336d546c75964ea3c03e (Registered 28 April 2014) Overseas visits     7c43f5eb 2015-01-06 Jack Straw uk.org.publicwhip/member/40090 Jack Straw uk.org.publicwhip/person/10574 13 2015-01-06-7c43f5eb-10574-0

Advanced export

JSON shape: default, array, newline-delimited, 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)
    );
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");