items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
4 rows where member_id = "uk.org.publicwhip/member/1065" sorted by member_id
This data as json, CSV (advanced)
Suggested facets: date (date)
item 3 ✖
- I won a raffle prize of one month's use of a Land Rover provided by Clean Fleet Alliance who had sponsored a draw for MPs at the Labour Party Conference in October 2002. (Registered 9 January 2003) 2
- February 2002, two tickets to attend Brit Awards from BPI Ltd. (Registered 1 August 2002) 1
- February 2001, two tickets to attend Brit Awards from BPI Ltd. (Registered 29 October 2001) 1
hash | item | category_id | date | member_id ▼ | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
0c12172227b306d41af99935af2495735502bc1b | February 2001, two tickets to attend Brit Awards from BPI Ltd. (Registered 29 October 2001) | Gifts, benefits and hospitality (UK) 84642823 | 2002-05-14 | Siobhain McDonagh uk.org.publicwhip/member/1065 | Siobhain McDonagh uk.org.publicwhip/person/10381 | 0 | 2002-05-14-84642823-10381-0 |
8d31a43520161dc8848820c82a5eb1452b4adaaa | February 2002, two tickets to attend Brit Awards from BPI Ltd. (Registered 1 August 2002) | Gifts, benefits and hospitality (UK) 84642823 | 2002-11-26 | Siobhain McDonagh uk.org.publicwhip/member/1065 | Siobhain McDonagh uk.org.publicwhip/person/10381 | 0 | 2002-11-26-84642823-10381-0 |
7e56928709782ea875284556b194ef853ae2696f | I won a raffle prize of one month's use of a Land Rover provided by Clean Fleet Alliance who had sponsored a draw for MPs at the Labour Party Conference in October 2002. (Registered 9 January 2003) | Gifts, benefits and hospitality (UK) 84642823 | 2003-12-04 | Siobhain McDonagh uk.org.publicwhip/member/1065 | Siobhain McDonagh uk.org.publicwhip/person/10381 | 0 | 2003-12-04-84642823-10381-0 |
864bda916593cebf1fd003b38164a0cb30ccb9a4 | I won a raffle prize of one month's use of a Land Rover provided by Clean Fleet Alliance who had sponsored a draw for MPs at the Labour Party Conference in October 2002. (Registered 9 January 2003) | Gifts, benefits and hospitality (UK) 84642823 | 2004-01-31 | Siobhain McDonagh uk.org.publicwhip/member/1065 | Siobhain McDonagh uk.org.publicwhip/person/10381 | 0 | 2004-01-31-84642823-10381-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");