items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
22 rows where item = "Name of donor: Kingdom of Bahrain Ministry of Foreign Affairs Address of donor: PO Box 547, Manama, Bahrain Estimate of the probable value (or amount of any donation): Flights, transport, food and accommodation with a value of £2,909 Destination of visit: Bahrain Dates of visit: 13-15 October 2017 Purpose of visit: to visit the new Royal Navy Base HMS Juffair, meet with HRH Crown Prince Salman, senior government officials and business leaders and the British diplomatic team in order to support and understand the British-Bahrain bilateral relationship. (Registered 03 November 2017)" and person_id = "uk.org.publicwhip/person/25628" sorted by date descending
This data as json, CSV (advanced)
Suggested facets: sort_order, date (date)
hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
3f8ebaa535bfc7e5ff67085e53c650ca7c1e8372 | Name of donor: Kingdom of Bahrain Ministry of Foreign Affairs Address of donor: PO Box 547, Manama, Bahrain Estimate of the probable value (or amount of any donation): Flights, transport, food and accommodation with a value of £2,909 Destination of visit: Bahrain Dates of visit: 13-15 October 2017 Purpose of visit: to visit the new Royal Navy Base HMS Juffair, meet with HRH Crown Prince Salman, senior government officials and business leaders and the British diplomatic team in order to support and understand the British-Bahrain bilateral relationship. (Registered 03 November 2017) | Visits outside the UK 891eb863 | 2018-11-19 | Leo Docherty uk.org.publicwhip/person/25628 | 0 | 2018-11-19-891eb863-25628-0 | |
964a5c6fdd4d60a2bbc4efe6b133983ced932d07 | Name of donor: Kingdom of Bahrain Ministry of Foreign Affairs Address of donor: PO Box 547, Manama, Bahrain Estimate of the probable value (or amount of any donation): Flights, transport, food and accommodation with a value of £2,909 Destination of visit: Bahrain Dates of visit: 13-15 October 2017 Purpose of visit: to visit the new Royal Navy Base HMS Juffair, meet with HRH Crown Prince Salman, senior government officials and business leaders and the British diplomatic team in order to support and understand the British-Bahrain bilateral relationship. (Registered 03 November 2017) | Visits outside the UK 891eb863 | 2018-10-29 | Leo Docherty uk.org.publicwhip/person/25628 | 1 | 2018-10-29-891eb863-25628-0 | |
2c699f46245852c94efa416b2ea6edde42abc0cb | Name of donor: Kingdom of Bahrain Ministry of Foreign Affairs Address of donor: PO Box 547, Manama, Bahrain Estimate of the probable value (or amount of any donation): Flights, transport, food and accommodation with a value of £2,909 Destination of visit: Bahrain Dates of visit: 13-15 October 2017 Purpose of visit: to visit the new Royal Navy Base HMS Juffair, meet with HRH Crown Prince Salman, senior government officials and business leaders and the British diplomatic team in order to support and understand the British-Bahrain bilateral relationship. (Registered 03 November 2017) | Visits outside the UK 891eb863 | 2018-10-15 | Leo Docherty uk.org.publicwhip/person/25628 | 1 | 2018-10-15-891eb863-25628-0 | |
9b5aac7f02b757097329842dff6be7130beb14c5 | Name of donor: Kingdom of Bahrain Ministry of Foreign Affairs Address of donor: PO Box 547, Manama, Bahrain Estimate of the probable value (or amount of any donation): Flights, transport, food and accommodation with a value of £2,909 Destination of visit: Bahrain Dates of visit: 13-15 October 2017 Purpose of visit: to visit the new Royal Navy Base HMS Juffair, meet with HRH Crown Prince Salman, senior government officials and business leaders and the British diplomatic team in order to support and understand the British-Bahrain bilateral relationship. (Registered 03 November 2017) | Visits outside the UK 891eb863 | 2018-10-01 | Leo Docherty uk.org.publicwhip/person/25628 | 1 | 2018-10-01-891eb863-25628-0 | |
0d44f6e63b27d1c1530aaae407ea41352533af24 | Name of donor: Kingdom of Bahrain Ministry of Foreign Affairs Address of donor: PO Box 547, Manama, Bahrain Estimate of the probable value (or amount of any donation): Flights, transport, food and accommodation with a value of £2,909 Destination of visit: Bahrain Dates of visit: 13-15 October 2017 Purpose of visit: to visit the new Royal Navy Base HMS Juffair, meet with HRH Crown Prince Salman, senior government officials and business leaders and the British diplomatic team in order to support and understand the British-Bahrain bilateral relationship. (Registered 03 November 2017) | Visits outside the UK 891eb863 | 2018-09-10 | Leo Docherty uk.org.publicwhip/person/25628 | 2 | 2018-09-10-891eb863-25628-0 | |
b848d7b925e94b5ed9e65b0b0df754b6338882e5 | Name of donor: Kingdom of Bahrain Ministry of Foreign Affairs Address of donor: PO Box 547, Manama, Bahrain Estimate of the probable value (or amount of any donation): Flights, transport, food and accommodation with a value of £2,909 Destination of visit: Bahrain Dates of visit: 13-15 October 2017 Purpose of visit: to visit the new Royal Navy Base HMS Juffair, meet with HRH Crown Prince Salman, senior government officials and business leaders and the British diplomatic team in order to support and understand the British-Bahrain bilateral relationship. (Registered 03 November 2017) | Visits outside the UK 891eb863 | 2018-08-13 | Leo Docherty uk.org.publicwhip/person/25628 | 2 | 2018-08-13-891eb863-25628-0 | |
4c800f1abeedf4fd6e85a112287cf543f71f6238 | Name of donor: Kingdom of Bahrain Ministry of Foreign Affairs Address of donor: PO Box 547, Manama, Bahrain Estimate of the probable value (or amount of any donation): Flights, transport, food and accommodation with a value of £2,909 Destination of visit: Bahrain Dates of visit: 13-15 October 2017 Purpose of visit: to visit the new Royal Navy Base HMS Juffair, meet with HRH Crown Prince Salman, senior government officials and business leaders and the British diplomatic team in order to support and understand the British-Bahrain bilateral relationship. (Registered 03 November 2017) | Visits outside the UK 891eb863 | 2018-07-16 | Leo Docherty uk.org.publicwhip/person/25628 | 2 | 2018-07-16-891eb863-25628-0 | |
41f17b37966a46b617220514227c3e13b03dce47 | Name of donor: Kingdom of Bahrain Ministry of Foreign Affairs Address of donor: PO Box 547, Manama, Bahrain Estimate of the probable value (or amount of any donation): Flights, transport, food and accommodation with a value of £2,909 Destination of visit: Bahrain Dates of visit: 13-15 October 2017 Purpose of visit: to visit the new Royal Navy Base HMS Juffair, meet with HRH Crown Prince Salman, senior government officials and business leaders and the British diplomatic team in order to support and understand the British-Bahrain bilateral relationship. (Registered 03 November 2017) | Visits outside the UK 891eb863 | 2018-07-02 | Leo Docherty uk.org.publicwhip/person/25628 | 2 | 2018-07-02-891eb863-25628-0 | |
17cb55423b5c1258b8dec5605d3f89486593c3a6 | Name of donor: Kingdom of Bahrain Ministry of Foreign Affairs Address of donor: PO Box 547, Manama, Bahrain Estimate of the probable value (or amount of any donation): Flights, transport, food and accommodation with a value of £2,909 Destination of visit: Bahrain Dates of visit: 13-15 October 2017 Purpose of visit: to visit the new Royal Navy Base HMS Juffair, meet with HRH Crown Prince Salman, senior government officials and business leaders and the British diplomatic team in order to support and understand the British-Bahrain bilateral relationship. (Registered 03 November 2017) | Visits outside the UK 891eb863 | 2018-06-18 | Leo Docherty uk.org.publicwhip/person/25628 | 2 | 2018-06-18-891eb863-25628-0 | |
bd6df431f50217db7854de4fca3c82569b3bf434 | Name of donor: Kingdom of Bahrain Ministry of Foreign Affairs Address of donor: PO Box 547, Manama, Bahrain Estimate of the probable value (or amount of any donation): Flights, transport, food and accommodation with a value of £2,909 Destination of visit: Bahrain Dates of visit: 13-15 October 2017 Purpose of visit: to visit the new Royal Navy Base HMS Juffair, meet with HRH Crown Prince Salman, senior government officials and business leaders and the British diplomatic team in order to support and understand the British-Bahrain bilateral relationship. (Registered 03 November 2017) | Visits outside the UK 891eb863 | 2018-06-04 | Leo Docherty uk.org.publicwhip/person/25628 | 2 | 2018-06-04-891eb863-25628-0 | |
680e882e17e8a50952926a8a4d1d33dd3aef26c4 | Name of donor: Kingdom of Bahrain Ministry of Foreign Affairs Address of donor: PO Box 547, Manama, Bahrain Estimate of the probable value (or amount of any donation): Flights, transport, food and accommodation with a value of £2,909 Destination of visit: Bahrain Dates of visit: 13-15 October 2017 Purpose of visit: to visit the new Royal Navy Base HMS Juffair, meet with HRH Crown Prince Salman, senior government officials and business leaders and the British diplomatic team in order to support and understand the British-Bahrain bilateral relationship. (Registered 03 November 2017) | Visits outside the UK 891eb863 | 2018-05-14 | Leo Docherty uk.org.publicwhip/person/25628 | 2 | 2018-05-14-891eb863-25628-0 | |
c86a953fb1ecbf1ac642e38b08ae4d856ea4462f | Name of donor: Kingdom of Bahrain Ministry of Foreign Affairs Address of donor: PO Box 547, Manama, Bahrain Estimate of the probable value (or amount of any donation): Flights, transport, food and accommodation with a value of £2,909 Destination of visit: Bahrain Dates of visit: 13-15 October 2017 Purpose of visit: to visit the new Royal Navy Base HMS Juffair, meet with HRH Crown Prince Salman, senior government officials and business leaders and the British diplomatic team in order to support and understand the British-Bahrain bilateral relationship. (Registered 03 November 2017) | Visits outside the UK 891eb863 | 2018-04-30 | Leo Docherty uk.org.publicwhip/person/25628 | 2 | 2018-04-30-891eb863-25628-0 | |
cdcd0dd4a2759a98c7f12dcfe93815e9d7250287 | Name of donor: Kingdom of Bahrain Ministry of Foreign Affairs Address of donor: PO Box 547, Manama, Bahrain Estimate of the probable value (or amount of any donation): Flights, transport, food and accommodation with a value of £2,909 Destination of visit: Bahrain Dates of visit: 13-15 October 2017 Purpose of visit: to visit the new Royal Navy Base HMS Juffair, meet with HRH Crown Prince Salman, senior government officials and business leaders and the British diplomatic team in order to support and understand the British-Bahrain bilateral relationship. (Registered 03 November 2017) | Visits outside the UK 891eb863 | 2018-04-16 | Leo Docherty uk.org.publicwhip/person/25628 | 2 | 2018-04-16-891eb863-25628-0 | |
4bc782ef97644cd48f34bad429aab4ef6a41e491 | Name of donor: Kingdom of Bahrain Ministry of Foreign Affairs Address of donor: PO Box 547, Manama, Bahrain Estimate of the probable value (or amount of any donation): Flights, transport, food and accommodation with a value of £2,909 Destination of visit: Bahrain Dates of visit: 13-15 October 2017 Purpose of visit: to visit the new Royal Navy Base HMS Juffair, meet with HRH Crown Prince Salman, senior government officials and business leaders and the British diplomatic team in order to support and understand the British-Bahrain bilateral relationship. (Registered 03 November 2017) | Visits outside the UK 891eb863 | 2018-03-19 | Leo Docherty uk.org.publicwhip/person/25628 | 2 | 2018-03-19-891eb863-25628-0 | |
6f5342b0a31474130620120cc40161d486648d39 | Name of donor: Kingdom of Bahrain Ministry of Foreign Affairs Address of donor: PO Box 547, Manama, Bahrain Estimate of the probable value (or amount of any donation): Flights, transport, food and accommodation with a value of £2,909 Destination of visit: Bahrain Dates of visit: 13-15 October 2017 Purpose of visit: to visit the new Royal Navy Base HMS Juffair, meet with HRH Crown Prince Salman, senior government officials and business leaders and the British diplomatic team in order to support and understand the British-Bahrain bilateral relationship. (Registered 03 November 2017) | Visits outside the UK 891eb863 | 2018-03-05 | Leo Docherty uk.org.publicwhip/person/25628 | 2 | 2018-03-05-891eb863-25628-0 | |
5fd4b92db6da64a962337cc0b760a5610d975ac8 | Name of donor: Kingdom of Bahrain Ministry of Foreign Affairs Address of donor: PO Box 547, Manama, Bahrain Estimate of the probable value (or amount of any donation): Flights, transport, food and accommodation with a value of £2,909 Destination of visit: Bahrain Dates of visit: 13-15 October 2017 Purpose of visit: to visit the new Royal Navy Base HMS Juffair, meet with HRH Crown Prince Salman, senior government officials and business leaders and the British diplomatic team in order to support and understand the British-Bahrain bilateral relationship. (Registered 03 November 2017) | Visits outside the UK 891eb863 | 2018-02-19 | Leo Docherty uk.org.publicwhip/person/25628 | 2 | 2018-02-19-891eb863-25628-0 | |
5c1f838fe1438704056d187d3857da64c009d15b | Name of donor: Kingdom of Bahrain Ministry of Foreign Affairs Address of donor: PO Box 547, Manama, Bahrain Estimate of the probable value (or amount of any donation): Flights, transport, food and accommodation with a value of £2,909 Destination of visit: Bahrain Dates of visit: 13-15 October 2017 Purpose of visit: to visit the new Royal Navy Base HMS Juffair, meet with HRH Crown Prince Salman, senior government officials and business leaders and the British diplomatic team in order to support and understand the British-Bahrain bilateral relationship. (Registered 03 November 2017) | Visits outside the UK 891eb863 | 2018-02-05 | Leo Docherty uk.org.publicwhip/person/25628 | 2 | 2018-02-05-891eb863-25628-0 | |
0cff8695e10deeecf7695277b64780a6209c469c | Name of donor: Kingdom of Bahrain Ministry of Foreign Affairs Address of donor: PO Box 547, Manama, Bahrain Estimate of the probable value (or amount of any donation): Flights, transport, food and accommodation with a value of £2,909 Destination of visit: Bahrain Dates of visit: 13-15 October 2017 Purpose of visit: to visit the new Royal Navy Base HMS Juffair, meet with HRH Crown Prince Salman, senior government officials and business leaders and the British diplomatic team in order to support and understand the British-Bahrain bilateral relationship. (Registered 03 November 2017) | Visits outside the UK 891eb863 | 2018-01-22 | Leo Docherty uk.org.publicwhip/person/25628 | 2 | 2018-01-22-891eb863-25628-0 | |
8e40c72753fab5b7b8fbc0c5f6aaf709ee5f9f64 | Name of donor: Kingdom of Bahrain Ministry of Foreign Affairs Address of donor: PO Box 547, Manama, Bahrain Estimate of the probable value (or amount of any donation): Flights, transport, food and accommodation with a value of £2,909 Destination of visit: Bahrain Dates of visit: 13-15 October 2017 Purpose of visit: to visit the new Royal Navy Base HMS Juffair, meet with HRH Crown Prince Salman, senior government officials and business leaders and the British diplomatic team in order to support and understand the British-Bahrain bilateral relationship. (Registered 03 November 2017) | Visits outside the UK 891eb863 | 2018-01-08 | Leo Docherty uk.org.publicwhip/person/25628 | 2 | 2018-01-08-891eb863-25628-0 | |
9cdd3c445bc8075a560a813d30f80ff153c62424 | Name of donor: Kingdom of Bahrain Ministry of Foreign Affairs Address of donor: PO Box 547, Manama, Bahrain Estimate of the probable value (or amount of any donation): Flights, transport, food and accommodation with a value of £2,909 Destination of visit: Bahrain Dates of visit: 13-15 October 2017 Purpose of visit: to visit the new Royal Navy Base HMS Juffair, meet with HRH Crown Prince Salman, senior government officials and business leaders and the British diplomatic team in order to support and understand the British-Bahrain bilateral relationship. (Registered 03 November 2017) | Visits outside the UK 891eb863 | 2017-12-11 | Leo Docherty uk.org.publicwhip/person/25628 | 2 | 2017-12-11-891eb863-25628-0 | |
cb54c86b65d7dea319186f79884d32fd31077d55 | Name of donor: Kingdom of Bahrain Ministry of Foreign Affairs Address of donor: PO Box 547, Manama, Bahrain Estimate of the probable value (or amount of any donation): Flights, transport, food and accommodation with a value of £2,909 Destination of visit: Bahrain Dates of visit: 13-15 October 2017 Purpose of visit: to visit the new Royal Navy Base HMS Juffair, meet with HRH Crown Prince Salman, senior government officials and business leaders and the British diplomatic team in order to support and understand the British-Bahrain bilateral relationship. (Registered 03 November 2017) | Visits outside the UK 891eb863 | 2017-11-27 | Leo Docherty uk.org.publicwhip/person/25628 | 2 | 2017-11-27-891eb863-25628-0 | |
4df0b4357f44840ae7a93d7de27959ded595815a | Name of donor: Kingdom of Bahrain Ministry of Foreign Affairs Address of donor: PO Box 547, Manama, Bahrain Estimate of the probable value (or amount of any donation): Flights, transport, food and accommodation with a value of £2,909 Destination of visit: Bahrain Dates of visit: 13-15 October 2017 Purpose of visit: to visit the new Royal Navy Base HMS Juffair, meet with HRH Crown Prince Salman, senior government officials and business leaders and the British diplomatic team in order to support and understand the British-Bahrain bilateral relationship. (Registered 03 November 2017) | Visits outside the UK 891eb863 | 2017-11-13 | Leo Docherty uk.org.publicwhip/person/25628 | 2 | 2017-11-13-891eb863-25628-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");