items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
13 rows where member_id = "uk.org.publicwhip/member/1318" sorted by date descending
This data as json, CSV (advanced)
Suggested facets: item, category_id, date, sort_order, record_id, date (date)
| hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
|---|---|---|---|---|---|---|---|
| 9c4e8e7b3ea7a5fb746f155efbf9c03e2f0e1330 | One day of shooting with Cubitt Consulting. (Registered 22 November 2004) | Gifts, benefits and hospitality (UK) 84642823 | 2005-04-11 | Bill Wiggin uk.org.publicwhip/member/1318 | Bill Wiggin uk.org.publicwhip/person/11318 | 0 | 2005-04-11-84642823-11318-0 |
| 87f8bd7cef198d6ee5a5b8501c64c79a6e3a2e32 | One day of shooting with Cubitt Consulting. (Registered 22 November 2004) | Gifts, benefits and hospitality (UK) 84642823 | 2005-01-28 | Bill Wiggin uk.org.publicwhip/member/1318 | Bill Wiggin uk.org.publicwhip/person/11318 | 0 | 2005-01-28-84642823-11318-0 |
| c5002135c7e5cf942d69e2ddf547e6b9a1e14d7d | One day of shooting with Cubitt Consulting. (Registered 22 November 2004) | Gifts, benefits and hospitality (UK) 84642823 | 2004-12-03 | Bill Wiggin uk.org.publicwhip/member/1318 | Bill Wiggin uk.org.publicwhip/person/11318 | 0 | 2004-12-03-84642823-11318-0 |
| 201af6c5be4dd71eb78b06f6b5dd10cdb2f9eb47 | Provision of advice on parliamentary affairs to Commerzbank. (Up to £5,000) | Remunerated employment, office, profession etc 1f359ece | 2003-12-04 | Bill Wiggin uk.org.publicwhip/member/1318 | Bill Wiggin uk.org.publicwhip/person/11318 | 0 | 2003-12-04-1f359ece-11318-0 |
| b85b69368a54231a50e36e593e825a9fcad56577 | Provision of advice on parliamentary affairs to Commerzbank. (Up to £5,000) | Remunerated employment, office, profession etc 1f359ece | 2002-11-26 | Bill Wiggin uk.org.publicwhip/member/1318 | Bill Wiggin uk.org.publicwhip/person/11318 | 0 | 2002-11-26-1f359ece-11318-0 |
| 9d742a19a23ed5d240ed3d073b3c874b1773eeac | 5 June 2002, gift of four Brecon Buff geese from Ms. Sally Whittall. (Registered 13 June 2002) | Gifts, benefits and hospitality (UK) 84642823 | 2002-11-26 | Bill Wiggin uk.org.publicwhip/member/1318 | Bill Wiggin uk.org.publicwhip/person/11318 | 0 | 2002-11-26-84642823-11318-0 |
| 25ca68feef5fa917a47d73a7e1899cb63c83b6b3 | 1-4 February 2002, to Kuwait as guest of Kuwait Information Office. (Registered 14 May 2002) | Overseas visits 80ef1083 | 2002-11-26 | Bill Wiggin uk.org.publicwhip/member/1318 | Bill Wiggin uk.org.publicwhip/person/11318 | 0 | 2002-11-26-80ef1083-11318-0 |
| e25fa07307fb0e7d4df58b0daf98f0371fa2d962 | Gift of a watch from Dr. Khaled Al Torra. (Registered 14 May 2002) | Overseas benefits and gifts a41b9847 | 2002-11-26 | Bill Wiggin uk.org.publicwhip/member/1318 | Bill Wiggin uk.org.publicwhip/person/11318 | 0 | 2002-11-26-a41b9847-11318-0 |
| 5e7d69278b3cf95e53f2b27a8da5cea3938ded0b | Provision of advice on parliamentary affairs to Commerzbank. (£1,001-£5,000) | Remunerated employment, office, profession etc 1f359ece | 2002-05-14 | Bill Wiggin uk.org.publicwhip/member/1318 | Bill Wiggin uk.org.publicwhip/person/11318 | 0 | 2002-05-14-1f359ece-11318-0 |
| c00c3bcc0f15063a7bf79ca8b5c4b277df001600 | Member of Harris Parliamentary Panel. (£1-£1,000) | Remunerated employment, office, profession etc 1f359ece | 2002-05-14 | Bill Wiggin uk.org.publicwhip/member/1318 | Bill Wiggin uk.org.publicwhip/person/11318 | 1 | 2002-05-14-1f359ece-11318-0 |
| 7b1700aee010893bde8215691760720b48c9fcd3 | 1-4 February 2002, to Kuwait as guest of Kuwait Information Office. (Registered 14 May 2002) | Overseas visits 80ef1083 | 2002-05-14 | Bill Wiggin uk.org.publicwhip/member/1318 | Bill Wiggin uk.org.publicwhip/person/11318 | 0 | 2002-05-14-80ef1083-11318-0 |
| d4faafd87ab2157cb158e0e693ade830f2433eb0 | Gift of a watch from the Kuwait Information Office. (Registered 14 May 2002) | Overseas benefits and gifts a41b9847 | 2002-05-14 | Bill Wiggin uk.org.publicwhip/member/1318 | Bill Wiggin uk.org.publicwhip/person/11318 | 0 | 2002-05-14-a41b9847-11318-0 |
| 65276091d0d39c25c66e2763d3638b746bea1ca7 | My wife owns a flat in London SW10, which is currently for sale. | Land and Property 4f1e6359 | 2002-05-14 | Bill Wiggin uk.org.publicwhip/member/1318 | Bill Wiggin uk.org.publicwhip/person/11318 | 0 | 2002-05-14-4f1e6359-11318-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");