items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
15 rows where category_id = 84642823 and person_id = "uk.org.publicwhip/person/10068" sorted by date descending
This data as json, CSV (advanced)
Suggested facets: item, date, member_id, sort_order, record_id, date (date)
hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
2e880383176507a64c42822a3f4c3bbddb3cc5d4 | On accompanying visits to Washington DC/New York and Sydney in September, my wife and baby were upgraded by Virgin Atlantic Airways. (Registered 1 November 2005) | Gifts, benefits and hospitality (UK) 84642823 | 2006-09-19 | Gordon Brown uk.org.publicwhip/member/1997 | Gordon Brown uk.org.publicwhip/person/10068 | 0 | 2006-09-19-84642823-10068-0 |
59247bdc044ada3f3dcd23a43ae485fad7e39c77 | On accompanying visits to Washington DC/New York and Sydney in September, my wife and baby were upgraded by Virgin Atlantic Airways. (Registered 1 November 2005) | Gifts, benefits and hospitality (UK) 84642823 | 2006-07-25 | Gordon Brown uk.org.publicwhip/member/1997 | Gordon Brown uk.org.publicwhip/person/10068 | 0 | 2006-07-25-84642823-10068-0 |
a40a50b2a8f57e17fd78bcde44a127f80aa55ed3 | On accompanying visits to Washington DC/New York and Sydney in September, my wife and baby were upgraded by Virgin Atlantic Airways. (Registered 1 November 2005) | Gifts, benefits and hospitality (UK) 84642823 | 2006-06-21 | Gordon Brown uk.org.publicwhip/member/1997 | Gordon Brown uk.org.publicwhip/person/10068 | 0 | 2006-06-21-84642823-10068-0 |
5678ee5e94816a6e8f142be6e875259ee24cf699 | On accompanying visits to Washington DC/New York and Sydney in September, my wife and baby were upgraded by Virgin Atlantic Airways. (Registered 1 November 2005) | Gifts, benefits and hospitality (UK) 84642823 | 2006-05-12 | Gordon Brown uk.org.publicwhip/member/1997 | Gordon Brown uk.org.publicwhip/person/10068 | 0 | 2006-05-12-84642823-10068-0 |
d7402542e454797c0211bc349d1e17243ae1d7f0 | On accompanying visits to Washington DC/New York and Sydney in September, my wife and baby were upgraded by Virgin Atlantic Airways. (Registered 1 November 2005) | Gifts, benefits and hospitality (UK) 84642823 | 2006-03-24 | Gordon Brown uk.org.publicwhip/member/1997 | Gordon Brown uk.org.publicwhip/person/10068 | 0 | 2006-03-24-84642823-10068-0 |
8928fada77b005d8435951e4750a5dc5de9b97cf | On accompanying visits to Washington DC/New York and Sydney in September, my wife and baby were upgraded by Virgin Atlantic Airways. (Registered 1 November 2005) | Gifts, benefits and hospitality (UK) 84642823 | 2006-02-14 | Gordon Brown uk.org.publicwhip/member/1997 | Gordon Brown uk.org.publicwhip/person/10068 | 0 | 2006-02-14-84642823-10068-0 |
c4aa6e93d4c359629ab6cc79dbb3fa94e2d1929d | On accompanying visits to Washington DC/New York and Sydney in September, my wife and baby were upgraded by Virgin Atlantic Airways. (Registered 1 November 2005) | Gifts, benefits and hospitality (UK) 84642823 | 2006-02-13 | Gordon Brown uk.org.publicwhip/member/1997 | Gordon Brown uk.org.publicwhip/person/10068 | 0 | 2006-02-13-84642823-10068-0 |
bf9229ac86750d9cb9b444fba2a6b2cdf02a1f5a | On accompanying visits to Washington DC in April and December 2004, my wife and baby were upgraded by Virgin Atlantic Airways. (Registered 10 January 2005) | Gifts, benefits and hospitality (UK) 84642823 | 2005-12-14 | Gordon Brown uk.org.publicwhip/member/1997 | Gordon Brown uk.org.publicwhip/person/10068 | 0 | 2005-12-14-84642823-10068-0 |
d10f8e4dd5b88ec040cd45d46d5f04bf661beb39 | On accompanying visits to Washington DC/New York and Sydney in September, my wife and baby were upgraded by Virgin Atlantic Airways. (Registered 1 November 2005) | Gifts, benefits and hospitality (UK) 84642823 | 2005-12-14 | Gordon Brown uk.org.publicwhip/member/1997 | Gordon Brown uk.org.publicwhip/person/10068 | 1 | 2005-12-14-84642823-10068-0 |
95cda808205f97b6471ec0ae88c9395994da0f06 | On accompanying visits to Washington DC in April and December 2004, my wife and baby were upgraded by Virgin Atlantic Airways. (Registered 10 January 2005) | Gifts, benefits and hospitality (UK) 84642823 | 2005-11-01 | Gordon Brown uk.org.publicwhip/member/1997 | Gordon Brown uk.org.publicwhip/person/10068 | 0 | 2005-11-01-84642823-10068-0 |
a159c41786da6e39f861561f66216367100780c4 | On accompanying visits to Washington DC/New York and Sydney in September, my wife and baby were upgraded by Virgin Atlantic Airways. (Registered 1 November 2005) | Gifts, benefits and hospitality (UK) 84642823 | 2005-11-01 | Gordon Brown uk.org.publicwhip/member/1997 | Gordon Brown uk.org.publicwhip/person/10068 | 1 | 2005-11-01-84642823-10068-0 |
3ae7c65855c262df1f4b0b392d48167fade23c10 | On accompanying visits to Washington DC in April and December 2004, my wife and baby were upgraded by Virgin Atlantic Airways. (Registered 10 January 2005) | Gifts, benefits and hospitality (UK) 84642823 | 2005-04-11 | Gordon Brown uk.org.publicwhip/member/755 | Gordon Brown uk.org.publicwhip/person/10068 | 0 | 2005-04-11-84642823-10068-0 |
31c59aace30dc369b6fae4dc8a91068014df4035 | On accompanying visits to Washington DC in April and December 2004, my wife and baby were upgraded by Virgin Atlantic Airways. (Registered 10 January 2005) | Gifts, benefits and hospitality (UK) 84642823 | 2005-01-28 | Gordon Brown uk.org.publicwhip/member/755 | Gordon Brown uk.org.publicwhip/person/10068 | 0 | 2005-01-28-84642823-10068-0 |
4e92cfdc26b33b10784c3bbce131b192f4f34b76 | March 1999, I attended the Five Nations rugby match at Murrayfield at the invitation of Scottish Television. (Registered 18 March 1999) | Gifts, benefits and hospitality (UK) 84642823 | 2000-11-10 | Gordon Brown uk.org.publicwhip/member/68 | Gordon Brown uk.org.publicwhip/person/10068 | 0 | 2000-11-10-84642823-10068-0 |
eb84d55d80899709651c0be9cbd2c9cde614c843 | November 1999, I attended two Scotland England football matches at the invitation of the English FA and Scottish Television. (Registered 5 January 2000) | Gifts, benefits and hospitality (UK) 84642823 | 2000-11-10 | Gordon Brown uk.org.publicwhip/member/68 | Gordon Brown uk.org.publicwhip/person/10068 | 1 | 2000-11-10-84642823-10068-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");