items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
8 rows where member_id = "uk.org.publicwhip/member/1073" and sort_order = 1 sorted by date descending
This data as json, CSV (advanced)
Suggested facets: item, category_id, date, date (date)
hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
f2fbb954aade185bbdbb4da02ec7922ed2280ff7 | 26 November 2004, guest of Network Rail at the Railway Ball. (Registered 19 January 2005) | Gifts, benefits and hospitality (UK) 84642823 | 2005-04-11 | Anne McIntosh uk.org.publicwhip/member/1073 | Anne McIntosh uk.org.publicwhip/person/10389 | 1 | 2005-04-11-84642823-10389-0 |
b4cd194dc34692f4d87a78d18cdb0b29b7aad945 | 26 November 2004, guest of Network Rail at the Railway Ball. (Registered 19 January 2005) | Gifts, benefits and hospitality (UK) 84642823 | 2005-01-28 | Anne McIntosh uk.org.publicwhip/member/1073 | Anne McIntosh uk.org.publicwhip/person/10389 | 1 | 2005-01-28-84642823-10389-0 |
62628e20b0cfa68c0616119d638b72e5c9609ec3 | 6 June 2003, attended Yorkshire International Business Convention at the Harrogate Showground as a guest of Yorkshire Forward. (Registered 5 June 2003) | Gifts, benefits and hospitality (UK) 84642823 | 2004-05-21 | Anne McIntosh uk.org.publicwhip/member/1073 | Anne McIntosh uk.org.publicwhip/person/10389 | 1 | 2004-05-21-84642823-10389-0 |
9c5fbab58100c01ae5ab085ae1658d638d4eed13 | 6 June 2003, attended Yorkshire International Business Convention at the Harrogate Showground as a guest of Yorkshire Forward. (Registered 5 June 2003) | Gifts, benefits and hospitality (UK) 84642823 | 2004-01-31 | Anne McIntosh uk.org.publicwhip/member/1073 | Anne McIntosh uk.org.publicwhip/person/10389 | 1 | 2004-01-31-84642823-10389-0 |
5a8a2f74c8b4498068fc1898b983286d791ee503 | 6 June 2003, attended Yorkshire International Business Convention at the Harrogate Showground as a guest of Yorkshire Forward. (Registered 5 June 2003) | Gifts, benefits and hospitality (UK) 84642823 | 2003-12-04 | Anne McIntosh uk.org.publicwhip/member/1073 | Anne McIntosh uk.org.publicwhip/person/10389 | 1 | 2003-12-04-84642823-10389-0 |
2063f4d654253f3ce4a140c158176916abddac89 | 12 October 2002, my husband and I attended York Races as guests of Coral Racing Ltd. (Registered 14 October 2002) | Gifts, benefits and hospitality (UK) 84642823 | 2002-11-26 | Anne McIntosh uk.org.publicwhip/member/1073 | Anne McIntosh uk.org.publicwhip/person/10389 | 1 | 2002-11-26-84642823-10389-0 |
266c4211cceb4aaa93d9f3ffb3fc7d85020c044c | Occasional fees for TV appearances. | Remunerated employment, office, profession etc 1f359ece | 2002-05-14 | Anne McIntosh uk.org.publicwhip/member/1073 | Anne McIntosh uk.org.publicwhip/person/10389 | 1 | 2002-05-14-1f359ece-10389-0 |
6d450200d723642622b8eae9bf8db81ea3ed1c9f | 8 June 2001, I was the guest of Transco at the Yorkshire International Business Convention at Harewood House, Leeds. (Registered 25 July 2001) | Gifts, benefits and hospitality (UK) 84642823 | 2002-05-14 | Anne McIntosh uk.org.publicwhip/member/1073 | Anne McIntosh uk.org.publicwhip/person/10389 | 1 | 2002-05-14-84642823-10389-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");