items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
36 rows where person_id = "uk.org.publicwhip/person/10550" sorted by date descending
This data as json, CSV (advanced)
Suggested facets: item, member_id, sort_order, date (date)
hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
c1db103f247c4746f52d84cee5026ab6468b9192 | 6-13 September 2008, to Taiwan, paid for by the Taiwanese Authority. (Registered 6 October 2008) | Overseas visits 80ef1083 | 2010-02-03 | John Smith uk.org.publicwhip/member/1895 | John Smith uk.org.publicwhip/person/10550 | 0 | 2010-02-03-80ef1083-10550-0 |
ca26ef3ab454d631f24c6c43f69ba5435a5ee261 | 6-13 September 2008, to Taiwan, paid for by the Taiwanese Authority. (Registered 6 October 2008) | Overseas visits 80ef1083 | 2010-01-06 | John Smith uk.org.publicwhip/member/1895 | John Smith uk.org.publicwhip/person/10550 | 0 | 2010-01-06-80ef1083-10550-0 |
e956b3978a56cb3af628773b195b5d5e85360b1f | 6-13 September 2008, to Taiwan, paid for by the Taiwanese Authority. (Registered 6 October 2008) | Overseas visits 80ef1083 | 2009-12-10 | John Smith uk.org.publicwhip/member/1895 | John Smith uk.org.publicwhip/person/10550 | 0 | 2009-12-10-80ef1083-10550-0 |
d3fc50a180d48d6926840256a600e4d8263b583f | 6-13 September 2008, to Taiwan, paid for by the Taiwanese Authority. (Registered 6 October 2008) | Overseas visits 80ef1083 | 2009-11-25 | John Smith uk.org.publicwhip/member/1895 | John Smith uk.org.publicwhip/person/10550 | 0 | 2009-11-25-80ef1083-10550-0 |
e6ef0873279331ab1272916469a0eaf798cc10ae | 6-13 September 2008, to Taiwan, paid for by the Taiwanese Authority. (Registered 6 October 2008) | Overseas visits 80ef1083 | 2009-11-11 | John Smith uk.org.publicwhip/member/1895 | John Smith uk.org.publicwhip/person/10550 | 0 | 2009-11-11-80ef1083-10550-0 |
b49b2de05652db89085ea1f1d7802602b309132a | 6-13 September 2008, to Taiwan, paid for by the Taiwanese Authority. (Registered 6 October 2008) | Overseas visits 80ef1083 | 2009-10-28 | John Smith uk.org.publicwhip/member/1895 | John Smith uk.org.publicwhip/person/10550 | 0 | 2009-10-28-80ef1083-10550-0 |
75e77e76179a890aedb87d6e89a4e018e8f62a36 | 6-13 September 2008, to Taiwan, paid for by the Taiwanese Authority. (Registered 6 October 2008) | Overseas visits 80ef1083 | 2009-10-14 | John Smith uk.org.publicwhip/member/1895 | John Smith uk.org.publicwhip/person/10550 | 0 | 2009-10-14-80ef1083-10550-0 |
c003022d7691cb95691a6f5332f1ddd78095aa03 | 6-13 September 2008, to Taiwan, paid for by the Taiwanese Authority. (Registered 6 October 2008) | Overseas visits 80ef1083 | 2009-09-02 | John Smith uk.org.publicwhip/member/1895 | John Smith uk.org.publicwhip/person/10550 | 0 | 2009-09-02-80ef1083-10550-0 |
326291e85ba6f5029a1ad272484e13c8920c6a3c | 6-13 September 2008, to Taiwan, paid for by the Taiwanese Authority. (Registered 6 October 2008) | Overseas visits 80ef1083 | 2009-07-21 | John Smith uk.org.publicwhip/member/1895 | John Smith uk.org.publicwhip/person/10550 | 0 | 2009-07-21-80ef1083-10550-0 |
eab60332119b1a109623ef3dd9cc9fd5b49ca47b | 6-13 September 2008, to Taiwan, paid for by the Taiwanese Authority. (Registered 6 October 2008) | Overseas visits 80ef1083 | 2009-07-08 | John Smith uk.org.publicwhip/member/1895 | John Smith uk.org.publicwhip/person/10550 | 0 | 2009-07-08-80ef1083-10550-0 |
81707631b0a42b2b4e81568145760e332828e89c | 6-13 September 2008, to Taiwan, paid for by the Taiwanese Authority. (Registered 6 October 2008) | Overseas visits 80ef1083 | 2009-06-24 | John Smith uk.org.publicwhip/member/1895 | John Smith uk.org.publicwhip/person/10550 | 0 | 2009-06-24-80ef1083-10550-0 |
45e0f571dd828a5c260ca9299ebbaecada2060ed | 6-13 September 2008, to Taiwan, paid for by the Taiwanese Authority. (Registered 6 October 2008) | Overseas visits 80ef1083 | 2009-06-10 | John Smith uk.org.publicwhip/member/1895 | John Smith uk.org.publicwhip/person/10550 | 0 | 2009-06-10-80ef1083-10550-0 |
bfa3adb782a1bd8ed3d8edefed1bba6c0ce0bbc7 | 6-13 September 2008, to Taiwan, paid for by the Taiwanese Authority. (Registered 6 October 2008) | Overseas visits 80ef1083 | 2009-05-20 | John Smith uk.org.publicwhip/member/1895 | John Smith uk.org.publicwhip/person/10550 | 0 | 2009-05-20-80ef1083-10550-0 |
d4388b46feaa06be8c9cd7820551f4a1e8769e85 | 6-13 September 2008, to Taiwan, paid for by the Taiwanese Authority. (Registered 6 October 2008) | Overseas visits 80ef1083 | 2009-05-06 | John Smith uk.org.publicwhip/member/1895 | John Smith uk.org.publicwhip/person/10550 | 0 | 2009-05-06-80ef1083-10550-0 |
fb60b3b03f20651f4fcb460a41444026e4a44fff | 6-13 September 2008, to Taiwan, paid for by the Taiwanese Authority. (Registered 6 October 2008) | Overseas visits 80ef1083 | 2009-04-22 | John Smith uk.org.publicwhip/member/1895 | John Smith uk.org.publicwhip/person/10550 | 0 | 2009-04-22-80ef1083-10550-0 |
e8c23290c6dfe70bf6684f692da1dfdb2ff79684 | 6-13 September 2008, to Taiwan, paid for by the Taiwanese Authority. (Registered 6 October 2008) | Overseas visits 80ef1083 | 2009-03-25 | John Smith uk.org.publicwhip/member/1895 | John Smith uk.org.publicwhip/person/10550 | 0 | 2009-03-25-80ef1083-10550-0 |
13fdd37b970109e523d2ed25a814c4f07c5a1456 | 6-13 September 2008, to Taiwan, paid for by the Taiwanese Authority. (Registered 6 October 2008) | Overseas visits 80ef1083 | 2009-03-11 | John Smith uk.org.publicwhip/member/1895 | John Smith uk.org.publicwhip/person/10550 | 0 | 2009-03-11-80ef1083-10550-0 |
30ee7928ad965b5385cac5f1c40796d59cbec9fe | 6-13 September 2008, to Taiwan, paid for by the Taiwanese Authority. (Registered 6 October 2008) | Overseas visits 80ef1083 | 2009-02-25 | John Smith uk.org.publicwhip/member/1895 | John Smith uk.org.publicwhip/person/10550 | 0 | 2009-02-25-80ef1083-10550-0 |
b469dc8eed6233628159d13dbf8649e688caeb19 | 6-13 September 2008, to Taiwan, paid for by the Taiwanese Authority. (Registered 6 October 2008) | Overseas visits 80ef1083 | 2009-02-11 | John Smith uk.org.publicwhip/member/1895 | John Smith uk.org.publicwhip/person/10550 | 0 | 2009-02-11-80ef1083-10550-0 |
106034cbbed46d0ee3b9206bbf6b5b10ff8c2560 | 6-13 September 2008, to Taiwan, paid for by the Taiwanese Authority. (Registered 6 October 2008) | Overseas visits 80ef1083 | 2009-01-28 | John Smith uk.org.publicwhip/member/1895 | John Smith uk.org.publicwhip/person/10550 | 0 | 2009-01-28-80ef1083-10550-0 |
85b5f71722c0aea1c91a219e7f5fbbf0b12f8a7a | 6-13 September 2008, to Taiwan, paid for by the Taiwanese Authority. (Registered 6 October 2008) | Overseas visits 80ef1083 | 2009-01-14 | John Smith uk.org.publicwhip/member/1895 | John Smith uk.org.publicwhip/person/10550 | 0 | 2009-01-14-80ef1083-10550-0 |
fed45e11cf5da645fab60851d006696f198376e6 | 6-13 September 2008, to Taiwan, paid for by the Taiwanese Authority. (Registered 6 October 2008) | Overseas visits 80ef1083 | 2008-12-17 | John Smith uk.org.publicwhip/member/1895 | John Smith uk.org.publicwhip/person/10550 | 0 | 2008-12-17-80ef1083-10550-0 |
55246efa3c72dbe79b6b76f41694d299c5320f9d | 6-13 September 2008, to Taiwan, paid for by the Taiwanese Authority. (Registered 6 October 2008) | Overseas visits 80ef1083 | 2008-12-03 | John Smith uk.org.publicwhip/member/1895 | John Smith uk.org.publicwhip/person/10550 | 0 | 2008-12-03-80ef1083-10550-0 |
dfada0c57644a4e3f24e562b4fc829c1e63c35c8 | 6-13 September 2008, to Taiwan, paid for by the Taiwanese Authority. (Registered 6 October 2008) | Overseas visits 80ef1083 | 2008-11-19 | John Smith uk.org.publicwhip/member/1895 | John Smith uk.org.publicwhip/person/10550 | 0 | 2008-11-19-80ef1083-10550-0 |
cdffc71120822557764e761cb43cc5cd67a1d28e | 6-13 September 2008, to Taiwan, paid for by the Taiwanese Authority. (Registered 6 October 2008) | Overseas visits 80ef1083 | 2008-11-05 | John Smith uk.org.publicwhip/member/1895 | John Smith uk.org.publicwhip/person/10550 | 0 | 2008-11-05-80ef1083-10550-0 |
e929c89402b40723d0312b57d73c6e2efb14afd7 | 6-13 September 2008, to Taiwan, paid for by the Taiwanese Authority. (Registered 6 October 2008) | Overseas visits 80ef1083 | 2008-10-22 | John Smith uk.org.publicwhip/member/1895 | John Smith uk.org.publicwhip/person/10550 | 0 | 2008-10-22-80ef1083-10550-0 |
2ca2be64fd8bc4e20084f9fb29c1ab8a25549d23 | 9-13 August 2004, to Washington DC with parliamentary delegation. Travel and accommodation paid for by the UK Defence Forum. (Registered 30 November 2004) | Overseas visits 80ef1083 | 2005-12-14 | John Smith uk.org.publicwhip/member/1895 | John Smith uk.org.publicwhip/person/10550 | 0 | 2005-12-14-80ef1083-10550-0 |
01625547cf0b2533f752985a3a654da6b41c7a94 | 20-23 February 2004, to Qatar with parliamentary delegation. Travel and accommodation paid for by the Government of Qatar. (Registered 30 November 2004) | Overseas visits 80ef1083 | 2005-12-14 | John Smith uk.org.publicwhip/member/1895 | John Smith uk.org.publicwhip/person/10550 | 1 | 2005-12-14-80ef1083-10550-0 |
15d7011d84a9cd900c9ec3ccbb8d26e3794ec629 | 9-13 August 2004, to Washington DC with parliamentary delegation. Travel and accommodation paid for by the UK Defence Forum. (Registered 30 November 2004) | Overseas visits 80ef1083 | 2005-11-01 | John Smith uk.org.publicwhip/member/1895 | John Smith uk.org.publicwhip/person/10550 | 0 | 2005-11-01-80ef1083-10550-0 |
23c74518fa32a256df6e39d9ac660acf1a2870f4 | 20-23 February 2004, to Qatar with parliamentary delegation. Travel and accommodation paid for by the Government of Qatar. (Registered 30 November 2004) | Overseas visits 80ef1083 | 2005-11-01 | John Smith uk.org.publicwhip/member/1895 | John Smith uk.org.publicwhip/person/10550 | 1 | 2005-11-01-80ef1083-10550-0 |
8e48d345526fea28b9797feb52ae7eb94da7dda2 | 9-13 August 2004, to Washington DC with parliamentary delegation. Travel and accommodation paid for by the UK Defence Forum. (Registered 30 November 2004) | Overseas visits 80ef1083 | 2005-04-11 | John Smith uk.org.publicwhip/member/1235 | John Smith uk.org.publicwhip/person/10550 | 0 | 2005-04-11-80ef1083-10550-0 |
507c59a112ccf87757c5c3e7d925a0bce737c408 | 20-23 February 2004, to Qatar with parliamentary delegation. Travel and accommodation paid for by the Government of Qatar. (Registered 30 November 2004) | Overseas visits 80ef1083 | 2005-04-11 | John Smith uk.org.publicwhip/member/1235 | John Smith uk.org.publicwhip/person/10550 | 1 | 2005-04-11-80ef1083-10550-0 |
8f654a80e05dd81215f406052fc6792ce53524e2 | 9-13 August 2004, to Washington DC with parliamentary delegation. Travel and accommodation paid for by the UK Defence Forum. (Registered 30 November 2004) | Overseas visits 80ef1083 | 2005-01-28 | John Smith uk.org.publicwhip/member/1235 | John Smith uk.org.publicwhip/person/10550 | 0 | 2005-01-28-80ef1083-10550-0 |
1e8c22a0b453258c9fa71fe42a3f7dfe5e4875cc | 20-23 February 2004, to Qatar with parliamentary delegation. Travel and accommodation paid for by the Government of Qatar. (Registered 30 November 2004) | Overseas visits 80ef1083 | 2005-01-28 | John Smith uk.org.publicwhip/member/1235 | John Smith uk.org.publicwhip/person/10550 | 1 | 2005-01-28-80ef1083-10550-0 |
48e38f79ae732c8ec243fd685341287dc1d6f1b2 | 9-13 August 2004, to Washington DC with parliamentary delegation. Travel and accommodation paid for by the UK Defence Forum. (Registered 30 November 2004) | Overseas visits 80ef1083 | 2004-12-03 | John Smith uk.org.publicwhip/member/1235 | John Smith uk.org.publicwhip/person/10550 | 0 | 2004-12-03-80ef1083-10550-0 |
ce469b683d35305020cbd5a1658ba16e5bac894b | 20-23 February 2004, to Qatar with parliamentary delegation. Travel and accommodation paid for by the Government of Qatar. (Registered 30 November 2004) | Overseas visits 80ef1083 | 2004-12-03 | John Smith uk.org.publicwhip/member/1235 | John Smith uk.org.publicwhip/person/10550 | 1 | 2004-12-03-80ef1083-10550-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");