items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
15 rows where item = "26-30 November 2005, to Ghana, as a member of a cross-party group investigating trade related issues, financed by Christian Aid. (Registered 20 January 2006)" and person_id = "uk.org.publicwhip/person/10043" sorted by member_id
This data as json, CSV (advanced)
Suggested facets: date (date)
hash | item | category_id | date | member_id ▼ | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
04e3ef7e733843293cbec625dc8cbd92cb3a4757 | 26-30 November 2005, to Ghana, as a member of a cross-party group investigating trade related issues, financed by Christian Aid. (Registered 20 January 2006) | Overseas visits 80ef1083 | 2006-02-13 | Roger Berry uk.org.publicwhip/member/1663 | Roger Berry uk.org.publicwhip/person/10043 | 0 | 2006-02-13-80ef1083-10043-0 |
4a3c0ffa97a9330776ee4eb6bcc04f3b05254f15 | 26-30 November 2005, to Ghana, as a member of a cross-party group investigating trade related issues, financed by Christian Aid. (Registered 20 January 2006) | Overseas visits 80ef1083 | 2006-02-14 | Roger Berry uk.org.publicwhip/member/1663 | Roger Berry uk.org.publicwhip/person/10043 | 0 | 2006-02-14-80ef1083-10043-0 |
fe45825295148167bbf9c779e7765a531c8af7a3 | 26-30 November 2005, to Ghana, as a member of a cross-party group investigating trade related issues, financed by Christian Aid. (Registered 20 January 2006) | Overseas visits 80ef1083 | 2006-03-24 | Roger Berry uk.org.publicwhip/member/1663 | Roger Berry uk.org.publicwhip/person/10043 | 0 | 2006-03-24-80ef1083-10043-0 |
da636cdad8dad6e1c4d2877a73d96cce32392e8e | 26-30 November 2005, to Ghana, as a member of a cross-party group investigating trade related issues, financed by Christian Aid. (Registered 20 January 2006) | Overseas visits 80ef1083 | 2006-05-12 | Roger Berry uk.org.publicwhip/member/1663 | Roger Berry uk.org.publicwhip/person/10043 | 0 | 2006-05-12-80ef1083-10043-0 |
4c7f2b5a62c84685864c5d239da7a98905b13ef0 | 26-30 November 2005, to Ghana, as a member of a cross-party group investigating trade related issues, financed by Christian Aid. (Registered 20 January 2006) | Overseas visits 80ef1083 | 2006-06-21 | Roger Berry uk.org.publicwhip/member/1663 | Roger Berry uk.org.publicwhip/person/10043 | 0 | 2006-06-21-80ef1083-10043-0 |
8fb3f83c9de1943ecd13fded092663dc2c9bc7cb | 26-30 November 2005, to Ghana, as a member of a cross-party group investigating trade related issues, financed by Christian Aid. (Registered 20 January 2006) | Overseas visits 80ef1083 | 2006-07-25 | Roger Berry uk.org.publicwhip/member/1663 | Roger Berry uk.org.publicwhip/person/10043 | 0 | 2006-07-25-80ef1083-10043-0 |
6b459197e0feaf7e80d6b183c074cca163a35973 | 26-30 November 2005, to Ghana, as a member of a cross-party group investigating trade related issues, financed by Christian Aid. (Registered 20 January 2006) | Overseas visits 80ef1083 | 2006-09-19 | Roger Berry uk.org.publicwhip/member/1663 | Roger Berry uk.org.publicwhip/person/10043 | 0 | 2006-09-19-80ef1083-10043-0 |
befb8a276fd0480374b7400663b341fd97ac2763 | 26-30 November 2005, to Ghana, as a member of a cross-party group investigating trade related issues, financed by Christian Aid. (Registered 20 January 2006) | Overseas visits 80ef1083 | 2006-11-27 | Roger Berry uk.org.publicwhip/member/1663 | Roger Berry uk.org.publicwhip/person/10043 | 0 | 2006-11-27-80ef1083-10043-0 |
f261de4959d10ea149cd5eb1d4cdd7631c1ef095 | 26-30 November 2005, to Ghana, as a member of a cross-party group investigating trade related issues, financed by Christian Aid. (Registered 20 January 2006) | Overseas visits 80ef1083 | 2006-12-11 | Roger Berry uk.org.publicwhip/member/1663 | Roger Berry uk.org.publicwhip/person/10043 | 0 | 2006-12-11-80ef1083-10043-0 |
a961b376534129209a1b974ad46f42ef6c1d3cb4 | 26-30 November 2005, to Ghana, as a member of a cross-party group investigating trade related issues, financed by Christian Aid. (Registered 20 January 2006) | Overseas visits 80ef1083 | 2007-01-09 | Roger Berry uk.org.publicwhip/member/1663 | Roger Berry uk.org.publicwhip/person/10043 | 0 | 2007-01-09-80ef1083-10043-0 |
5af0a424e14ddeef179d8a095950d1bd042644b0 | 26-30 November 2005, to Ghana, as a member of a cross-party group investigating trade related issues, financed by Christian Aid. (Registered 20 January 2006) | Overseas visits 80ef1083 | 2007-01-23 | Roger Berry uk.org.publicwhip/member/1663 | Roger Berry uk.org.publicwhip/person/10043 | 0 | 2007-01-23-80ef1083-10043-0 |
ccc5369f8a72515e2cc777c4fb65f2c5fb988efd | 26-30 November 2005, to Ghana, as a member of a cross-party group investigating trade related issues, financed by Christian Aid. (Registered 20 January 2006) | Overseas visits 80ef1083 | 2007-02-06 | Roger Berry uk.org.publicwhip/member/1663 | Roger Berry uk.org.publicwhip/person/10043 | 0 | 2007-02-06-80ef1083-10043-0 |
5280c8183bdfe4b20bdb5bb57d8696f6ac59349e | 26-30 November 2005, to Ghana, as a member of a cross-party group investigating trade related issues, financed by Christian Aid. (Registered 20 January 2006) | Overseas visits 80ef1083 | 2007-02-27 | Roger Berry uk.org.publicwhip/member/1663 | Roger Berry uk.org.publicwhip/person/10043 | 0 | 2007-02-27-80ef1083-10043-0 |
b9266c2a7888e4cd0b0521f0734b0596a7afa968 | 26-30 November 2005, to Ghana, as a member of a cross-party group investigating trade related issues, financed by Christian Aid. (Registered 20 January 2006) | Overseas visits 80ef1083 | 2007-03-13 | Roger Berry uk.org.publicwhip/member/1663 | Roger Berry uk.org.publicwhip/person/10043 | 0 | 2007-03-13-80ef1083-10043-0 |
7bd949ebf51881619f8cdecbe62b053deeb524ec | 26-30 November 2005, to Ghana, as a member of a cross-party group investigating trade related issues, financed by Christian Aid. (Registered 20 January 2006) | Overseas visits 80ef1083 | 2007-03-26 | Roger Berry uk.org.publicwhip/member/1663 | Roger Berry uk.org.publicwhip/person/10043 | 0 | 2007-03-26-80ef1083-10043-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");