items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
17 rows where item = "27 May-1 June 2006, to the British Virgin Islands with the British Virgin Islands All-Party Parliamentary Group. All costs of the visit were paid by the British Virgin Islands Government. (Registered 11 October 2006)" and person_id = "uk.org.publicwhip/person/10055" sorted by sort_order
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 |
---|---|---|---|---|---|---|---|
038b4b1efc48242ea0387498bcb20a1d75e6cf46 | 27 May-1 June 2006, to the British Virgin Islands with the British Virgin Islands All-Party Parliamentary Group. All costs of the visit were paid by the British Virgin Islands Government. (Registered 11 October 2006) | Overseas visits 80ef1083 | 2007-05-01 | David Borrow uk.org.publicwhip/member/1780 | David Borrow uk.org.publicwhip/person/10055 | 0 | 2007-05-01-80ef1083-10055-0 |
df1334401f5b5404bc06d344dd80959009d2d0d5 | 27 May-1 June 2006, to the British Virgin Islands with the British Virgin Islands All-Party Parliamentary Group. All costs of the visit were paid by the British Virgin Islands Government. (Registered 11 October 2006) | Overseas visits 80ef1083 | 2007-05-15 | David Borrow uk.org.publicwhip/member/1780 | David Borrow uk.org.publicwhip/person/10055 | 0 | 2007-05-15-80ef1083-10055-0 |
d8b262cf1495dd8b96a610f194c60fe7e360555b | 27 May-1 June 2006, to the British Virgin Islands with the British Virgin Islands All-Party Parliamentary Group. All costs of the visit were paid by the British Virgin Islands Government. (Registered 11 October 2006) | Overseas visits 80ef1083 | 2007-06-05 | David Borrow uk.org.publicwhip/member/1780 | David Borrow uk.org.publicwhip/person/10055 | 0 | 2007-06-05-80ef1083-10055-0 |
02585873f73244aa12017ec81f2b05d31906f2ac | 27 May-1 June 2006, to the British Virgin Islands with the British Virgin Islands All-Party Parliamentary Group. All costs of the visit were paid by the British Virgin Islands Government. (Registered 11 October 2006) | Overseas visits 80ef1083 | 2007-06-19 | David Borrow uk.org.publicwhip/member/1780 | David Borrow uk.org.publicwhip/person/10055 | 0 | 2007-06-19-80ef1083-10055-0 |
2c000a5fdd0ef8eb16d4171a5015f384962df254 | 27 May-1 June 2006, to the British Virgin Islands with the British Virgin Islands All-Party Parliamentary Group. All costs of the visit were paid by the British Virgin Islands Government. (Registered 11 October 2006) | Overseas visits 80ef1083 | 2007-07-03 | David Borrow uk.org.publicwhip/member/1780 | David Borrow uk.org.publicwhip/person/10055 | 0 | 2007-07-03-80ef1083-10055-0 |
050daff32fd281e16da3239c3b730ab0d78b1177 | 27 May-1 June 2006, to the British Virgin Islands with the British Virgin Islands All-Party Parliamentary Group. All costs of the visit were paid by the British Virgin Islands Government. (Registered 11 October 2006) | Overseas visits 80ef1083 | 2007-07-17 | David Borrow uk.org.publicwhip/member/1780 | David Borrow uk.org.publicwhip/person/10055 | 0 | 2007-07-17-80ef1083-10055-0 |
710a2eb15c211d2773b81c9651fd8ca54d33d9c6 | 27 May-1 June 2006, to the British Virgin Islands with the British Virgin Islands All-Party Parliamentary Group. All costs of the visit were paid by the British Virgin Islands Government. (Registered 11 October 2006) | Overseas visits 80ef1083 | 2007-07-30 | David Borrow uk.org.publicwhip/member/1780 | David Borrow uk.org.publicwhip/person/10055 | 0 | 2007-07-30-80ef1083-10055-0 |
397c22e23397bf217336229bd640a29a7a0d9645 | 27 May-1 June 2006, to the British Virgin Islands with the British Virgin Islands All-Party Parliamentary Group. All costs of the visit were paid by the British Virgin Islands Government. (Registered 11 October 2006) | Overseas visits 80ef1083 | 2007-08-28 | David Borrow uk.org.publicwhip/member/1780 | David Borrow uk.org.publicwhip/person/10055 | 0 | 2007-08-28-80ef1083-10055-0 |
6bcad1e8c68b9f71b3611491c37c2934bc0ee23f | 27 May-1 June 2006, to the British Virgin Islands with the British Virgin Islands All-Party Parliamentary Group. All costs of the visit were paid by the British Virgin Islands Government. (Registered 11 October 2006) | Overseas visits 80ef1083 | 2007-10-09 | David Borrow uk.org.publicwhip/member/1780 | David Borrow uk.org.publicwhip/person/10055 | 0 | 2007-10-09-80ef1083-10055-0 |
3407c360824d178aa9649df9c1045d2393d653d6 | 27 May-1 June 2006, to the British Virgin Islands with the British Virgin Islands All-Party Parliamentary Group. All costs of the visit were paid by the British Virgin Islands Government. (Registered 11 October 2006) | Overseas visits 80ef1083 | 2006-11-27 | David Borrow uk.org.publicwhip/member/1780 | David Borrow uk.org.publicwhip/person/10055 | 1 | 2006-11-27-80ef1083-10055-0 |
940cb621e0c4e7dfae68a3c9fd74033f2a04f2f1 | 27 May-1 June 2006, to the British Virgin Islands with the British Virgin Islands All-Party Parliamentary Group. All costs of the visit were paid by the British Virgin Islands Government. (Registered 11 October 2006) | Overseas visits 80ef1083 | 2006-12-11 | David Borrow uk.org.publicwhip/member/1780 | David Borrow uk.org.publicwhip/person/10055 | 1 | 2006-12-11-80ef1083-10055-0 |
38c59146e1f6db42d869acc7df622940590239ef | 27 May-1 June 2006, to the British Virgin Islands with the British Virgin Islands All-Party Parliamentary Group. All costs of the visit were paid by the British Virgin Islands Government. (Registered 11 October 2006) | Overseas visits 80ef1083 | 2007-01-09 | David Borrow uk.org.publicwhip/member/1780 | David Borrow uk.org.publicwhip/person/10055 | 1 | 2007-01-09-80ef1083-10055-0 |
97bc98d513cfa424c60efe252f19b04b829e4cbe | 27 May-1 June 2006, to the British Virgin Islands with the British Virgin Islands All-Party Parliamentary Group. All costs of the visit were paid by the British Virgin Islands Government. (Registered 11 October 2006) | Overseas visits 80ef1083 | 2007-01-23 | David Borrow uk.org.publicwhip/member/1780 | David Borrow uk.org.publicwhip/person/10055 | 1 | 2007-01-23-80ef1083-10055-0 |
941e46d6a5bbeb84041c3c5b48f15035570c3cb2 | 27 May-1 June 2006, to the British Virgin Islands with the British Virgin Islands All-Party Parliamentary Group. All costs of the visit were paid by the British Virgin Islands Government. (Registered 11 October 2006) | Overseas visits 80ef1083 | 2007-02-06 | David Borrow uk.org.publicwhip/member/1780 | David Borrow uk.org.publicwhip/person/10055 | 1 | 2007-02-06-80ef1083-10055-0 |
da11d1b8c6c727ddf7c87fa27ac209c0fb961929 | 27 May-1 June 2006, to the British Virgin Islands with the British Virgin Islands All-Party Parliamentary Group. All costs of the visit were paid by the British Virgin Islands Government. (Registered 11 October 2006) | Overseas visits 80ef1083 | 2007-02-27 | David Borrow uk.org.publicwhip/member/1780 | David Borrow uk.org.publicwhip/person/10055 | 1 | 2007-02-27-80ef1083-10055-0 |
fa5aee2a796398e1735830030444cd8860013119 | 27 May-1 June 2006, to the British Virgin Islands with the British Virgin Islands All-Party Parliamentary Group. All costs of the visit were paid by the British Virgin Islands Government. (Registered 11 October 2006) | Overseas visits 80ef1083 | 2007-03-13 | David Borrow uk.org.publicwhip/member/1780 | David Borrow uk.org.publicwhip/person/10055 | 1 | 2007-03-13-80ef1083-10055-0 |
7c842cd12f13ee0219c27b17a4bbd92ac1c91f4c | 27 May-1 June 2006, to the British Virgin Islands with the British Virgin Islands All-Party Parliamentary Group. All costs of the visit were paid by the British Virgin Islands Government. (Registered 11 October 2006) | Overseas visits 80ef1083 | 2007-03-26 | David Borrow uk.org.publicwhip/member/1780 | David Borrow uk.org.publicwhip/person/10055 | 1 | 2007-03-26-80ef1083-10055-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");