items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
11 rows where member_id = "uk.org.publicwhip/member/998" sorted by date descending
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 |
---|---|---|---|---|---|---|---|
12a81e169cdcebf79cba274a3344cd78997ab8e1 | 9 February 2005, my wife and I attended the Brit Awards as guests of Phonographic Performance Ltd. (Registered 7 March 2005) | Gifts, benefits and hospitality (UK) 84642823 | 2005-04-11 | Alan Johnson uk.org.publicwhip/member/998 | Alan Johnson uk.org.publicwhip/person/10314 | 0 | 2005-04-11-84642823-10314-0 |
d28a9bd69ba7c8fdde6e50eec3a38d96a1266f2b | 17 February 2004, my wife and I attended the Brit Awards as guests of Phonographic Performance Ltd. (Registered 5 March 2004) | Gifts, benefits and hospitality (UK) 84642823 | 2005-01-28 | Alan Johnson uk.org.publicwhip/member/998 | Alan Johnson uk.org.publicwhip/person/10314 | 0 | 2005-01-28-84642823-10314-0 |
f21207365c8a2a3680489db7d16ebcc196fa72da | 17 February 2004, my wife and I attended the Brit Awards as guests of Phonographic Performance Ltd. (Registered 5 March 2004) | Gifts, benefits and hospitality (UK) 84642823 | 2004-12-03 | Alan Johnson uk.org.publicwhip/member/998 | Alan Johnson uk.org.publicwhip/person/10314 | 0 | 2004-12-03-84642823-10314-0 |
9603e780af2e9cea6c29757b4890f81cdb5a2025 | 17 February 2004, my wife and I attended the Brit Awards as guests of Phonographic Performance Ltd. (Registered 5 March 2004) | Gifts, benefits and hospitality (UK) 84642823 | 2004-10-22 | Alan Johnson uk.org.publicwhip/member/998 | Alan Johnson uk.org.publicwhip/person/10314 | 0 | 2004-10-22-84642823-10314-0 |
3d3a54a7e1b83e3d4f0ef97a1e2ca86347a6bc08 | 17 February 2004, my wife and I attended the Brit Awards as guests of Phonographic Performance Ltd. (Registered 5 March 2004) | Gifts, benefits and hospitality (UK) 84642823 | 2004-09-08 | Alan Johnson uk.org.publicwhip/member/998 | Alan Johnson uk.org.publicwhip/person/10314 | 0 | 2004-09-08-84642823-10314-0 |
b764dd7698d421e8f9ed81798e3ff19dd163f3fe | 17 February 2004, my wife and I attended the Brit Awards as guests of Phonographic Performance Ltd. (Registered 5 March 2004) | Gifts, benefits and hospitality (UK) 84642823 | 2004-07-16 | Alan Johnson uk.org.publicwhip/member/998 | Alan Johnson uk.org.publicwhip/person/10314 | 0 | 2004-07-16-84642823-10314-0 |
1a2c46c8405bdea9f608e9c346e1df3ac0fdb9b1 | 17 February 2004, my wife and I attended the Brit Awards as guests of Phonographic Performance Ltd. (Registered 5 March 2004) | Gifts, benefits and hospitality (UK) 84642823 | 2004-05-21 | Alan Johnson uk.org.publicwhip/member/998 | Alan Johnson uk.org.publicwhip/person/10314 | 0 | 2004-05-21-84642823-10314-0 |
e28b23022bbff89bfc15a99861b1c8bd5b7892a6 | Gifts of a framed painting of the fishing docks, an inscribed watch and a Parker penset presented to me by the British Fishermen's Association representing ex-distant-water trawlermen in Hull. (Registered 25 November 2002) | Gifts, benefits and hospitality (UK) 84642823 | 2003-12-04 | Alan Johnson uk.org.publicwhip/member/998 | Alan Johnson uk.org.publicwhip/person/10314 | 0 | 2003-12-04-84642823-10314-0 |
56bb4e095bc5a6563f60e7302c40b42224308cfc | 20 February 2002, my wife and I attended the Brit Awards as guests of the British Phonographic Institute. (Registered 7 March 2002) | Gifts, benefits and hospitality (UK) 84642823 | 2002-11-26 | Alan Johnson uk.org.publicwhip/member/998 | Alan Johnson uk.org.publicwhip/person/10314 | 0 | 2002-11-26-84642823-10314-0 |
00e9be86a9e010a5c707e11abfb09928b95cb0bd | Gift of a framed painting of the fishing docks, an inscribed watch and a Parker pen set presented to me by the British Fisherman's Association representing ex-distant-trawlermen in Hull. (Registered 25 November 2002) | Gifts, benefits and hospitality (UK) 84642823 | 2002-11-26 | Alan Johnson uk.org.publicwhip/member/998 | Alan Johnson uk.org.publicwhip/person/10314 | 1 | 2002-11-26-84642823-10314-0 |
90e63de1e1a172cdb489116ef7b94ba9fd8ba4fa | 20 February 2002, my wife and I attended the Brit Awards as guests of the British Phonographic Institute. (Registered 7 March 2002) | Gifts, benefits and hospitality (UK) 84642823 | 2002-05-14 | Alan Johnson uk.org.publicwhip/member/998 | Alan Johnson uk.org.publicwhip/person/10314 | 0 | 2002-05-14-84642823-10314-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");