home / regmem

Menu
  • GraphQL API

items

Table actions
  • GraphQL API for items

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

13 rows where member_id = "uk.org.publicwhip/member/1006" sorted by date descending

✎ View and edit SQL

This data as json, CSV (advanced)

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

hash item category_id date ▲ member_id person_id sort_order record_id
b2147d789ff1df8e037c1212f693f5a1fba45a9a 26 June-2 July 2004, to Botswana at the invitation of the Botswana Government as part of an all-party visit to investigate issues of interest to the UK in Botswana. All travel, accommodation and subsistence was paid for by the Botswana Government. (Registered 6 July 2004) Overseas visits 80ef1083 2005-04-11 Nigel Jones uk.org.publicwhip/member/1006 Nigel Jones uk.org.publicwhip/person/10325 0 2005-04-11-80ef1083-10325-0
4aa86e3587d7e8e75b8da1d180f6a2909ade4583 26 June-2 July 2004, to Botswana at the invitation of the Botswana Government as part of an all-party visit to investigate issues of interest to the UK in Botswana. All travel, accommodation and subsistence was paid for by the Botswana Government. (Registered 6 July 2004) Overseas visits 80ef1083 2005-01-28 Nigel Jones uk.org.publicwhip/member/1006 Nigel Jones uk.org.publicwhip/person/10325 0 2005-01-28-80ef1083-10325-0
a569cbc9ed4fa5f3fc9c3fa6ec24785d3bcfd632 22-29 November 2003, to Botswana at the invitation of the Government of Botswana on an All-Party Parliamentary Botswana Group visit to investigate issues of interest of the UK in Botswana. All travel, accommodation and subsistence was paid for by the Government of Botswana. (Registered 14 December 2003) Overseas visits 80ef1083 2004-12-03 Nigel Jones uk.org.publicwhip/member/1006 Nigel Jones uk.org.publicwhip/person/10325 0 2004-12-03-80ef1083-10325-0
1bcfac9a36c01c7a8a1b5ac990f92df712fc8ab1 26 June-2 July 2004, to Botswana at the invitation of the Botswana Government as part of an all-party visit to investigate issues of interest to the UK in Botswana. All travel, accommodation and subsistence was paid for by the Botswana Government. (Registered 6 July 2004) Overseas visits 80ef1083 2004-12-03 Nigel Jones uk.org.publicwhip/member/1006 Nigel Jones uk.org.publicwhip/person/10325 1 2004-12-03-80ef1083-10325-0
3fac9cff29e1ac2a4bf10b1f374f9d44a7ef369e 22-29 November 2003, to Botswana at the invitation of the Government of Botswana on an All-Party Parliamentary Botswana Group visit to investigate issues of interest of the UK in Botswana. All travel, accommodation and subsistence was paid for by the Government of Botswana. (Registered 14 December 2003) Overseas visits 80ef1083 2004-10-22 Nigel Jones uk.org.publicwhip/member/1006 Nigel Jones uk.org.publicwhip/person/10325 0 2004-10-22-80ef1083-10325-0
d65159bbfe9a5433bade24281343cb881d97d2ab 26 June-2 July 2004, to Botswana at the invitation of the Botswana Government as part of an all-party visit to investigate issues of interest to the UK in Botswana. All travel, accommodation and subsistence was paid for by the Botswana Government. (Registered 6 July 2004) Overseas visits 80ef1083 2004-10-22 Nigel Jones uk.org.publicwhip/member/1006 Nigel Jones uk.org.publicwhip/person/10325 1 2004-10-22-80ef1083-10325-0
205db889697ace5e51a0febceb3516e7b8d88491 22-29 November 2003, to Botswana at the invitation of the Government of Botswana on an All-Party Parliamentary Botswana Group visit to investigate issues of interest of the UK in Botswana. All travel, accommodation and subsistence was paid for by the Government of Botswana. (Registered 14 December 2003) Overseas visits 80ef1083 2004-09-08 Nigel Jones uk.org.publicwhip/member/1006 Nigel Jones uk.org.publicwhip/person/10325 0 2004-09-08-80ef1083-10325-0
6c923fdfb451467700c9ccba1d230415799bac97 26 June-2 July 2004, to Botswana at the invitation of the Botswana Government as part of an all-party visit to investigate issues of interest to the UK in Botswana. All travel, accommodation and subsistence was paid for by the Botswana Government. (Registered 6 July 2004) Overseas visits 80ef1083 2004-09-08 Nigel Jones uk.org.publicwhip/member/1006 Nigel Jones uk.org.publicwhip/person/10325 1 2004-09-08-80ef1083-10325-0
011836897a0499347e511f4ffacb56d8013fd4f5 22-29 November 2003, to Botswana at the invitation of the Government of Botswana on an All-Party Parliamentary Botswana Group visit to investigate issues of interest of the UK in Botswana. All travel, accommodation and subsistence was paid for by the Government of Botswana. (Registered 14 December 2003) Overseas visits 80ef1083 2004-07-16 Nigel Jones uk.org.publicwhip/member/1006 Nigel Jones uk.org.publicwhip/person/10325 0 2004-07-16-80ef1083-10325-0
994dd1ce96be50559a5b838b689d193ceadb2fdb 26 June-2 July 2004, to Botswana at the invitation of the Botswana Government as part of an all-party visit to investigate issues of interest to the UK in Botswana. All travel, accommodation and subsistence was paid for by the Botswana Government. (Registered 6 July 2004) Overseas visits 80ef1083 2004-07-16 Nigel Jones uk.org.publicwhip/member/1006 Nigel Jones uk.org.publicwhip/person/10325 1 2004-07-16-80ef1083-10325-0
fb014db580d13e217b3114e8bd8ca92f6113f7a0 22-29 November 2003, to Botswana at the invitation of the Government of Botswana on an All-Party Parliamentary Botswana Group visit to investigate issues of interest of the UK in Botswana. All travel, accommodation and subsistence was paid for by the Government of Botswana. (Registered 14 December 2003) Overseas visits 80ef1083 2004-05-21 Nigel Jones uk.org.publicwhip/member/1006 Nigel Jones uk.org.publicwhip/person/10325 0 2004-05-21-80ef1083-10325-0
5b9d30270ac5b2ef414ac951fa4c1481cf6f2d9c 22-29 November 2003, to Botswana at the invitation of the Government of Botswana on an All-Party Parliamentary Botswana Group visit to investigate issues of interest of the UK in Botswana. All travel, accommodation and subsistence was paid for by the Government of Botswana. (Registered 14 December 2003) Overseas visits 80ef1083 2004-01-31 Nigel Jones uk.org.publicwhip/member/1006 Nigel Jones uk.org.publicwhip/person/10325 0 2004-01-31-80ef1083-10325-0
357c15c280863fa4bf739f6757857b409e95978d 1-6 September 2002, to Botswana at the invitation of the Botswana Chamber of Commerce as part of an all party visit to investigate issues of interest of the UK in Botswana. All travel, accommodation and subsistence was paid for by the Botswana Chamber of Commerce. (Registered 30 September 2002) Overseas visits 80ef1083 2002-11-26 Nigel Jones uk.org.publicwhip/member/1006 Nigel Jones uk.org.publicwhip/person/10325 0 2002-11-26-80ef1083-10325-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");
Powered by Datasette · Queries took 17.99ms · Data source: mySociety Data · About: simonw/register-of-members-interests-datasette