items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
5 rows where person_id = "uk.org.publicwhip/person/10124" sorted by date descending
This data as json, CSV (advanced)
Suggested facets: item, category_id, date, member_id, date (date)
| hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
|---|---|---|---|---|---|---|---|
| 4c01a30435d9da163bdcb3743a39d56752c034f6 | £1,000 donation from MSF trade union to Hammersmith and Fulham Constituency Labour Party for General Election expenses. (Registered 9 October 2001) | Sponsorship or financial or material support 9e46def6 | 2002-05-14 | Iain Coleman uk.org.publicwhip/member/811 | Iain Coleman uk.org.publicwhip/person/10124 | 0 | 2002-05-14-9e46def6-10124-0 |
| ec9763d748d9016ce84c2c0cb166a11d73c177ec | Financial support towards the administrative and other costs of the Iain Coleman In Touch with Business Project, a business liaison project run in my constituency, principally from Barclays Bank PLC, Coca-Cola Great Britain and Seagram UK Ltd. | Sponsorship or financial or material support 9e46def6 | 2001-05-14 | Iain Coleman uk.org.publicwhip/member/124 | Iain Coleman uk.org.publicwhip/person/10124 | 0 | 2001-05-14-9e46def6-10124-0 |
| 99ce80452650d0053be21f746f4e2ee44a4c257c | 9 April 2000, three tickets and hospitality at the FA Cup semi-final provided by McDonald's. (Registered 10 April 2000) | Gifts, benefits and hospitality (UK) 84642823 | 2001-05-14 | Iain Coleman uk.org.publicwhip/member/124 | Iain Coleman uk.org.publicwhip/person/10124 | 0 | 2001-05-14-84642823-10124-0 |
| ace33a5fbd37b3186fdf9c92a3106ff749e6b7ae | Financial support towards the administrative and other costs of the Iain Coleman In Touch with Business Project, a business liaison project run in my constituency, principally from Barclays Bank PLC, Coca-Cola Great Britain and Seagram UK Ltd. | Sponsorship or financial or material support 9e46def6 | 2000-11-10 | Iain Coleman uk.org.publicwhip/member/124 | Iain Coleman uk.org.publicwhip/person/10124 | 0 | 2000-11-10-9e46def6-10124-0 |
| 191ea8d68dd3cb8bee7f85cf685301b2966f5785 | 9 April 2000, three tickets and hospitality at the FA Cup semi-final provided by McDonald's. (Registered 10 April 2000) | Gifts, benefits and hospitality (UK) 84642823 | 2000-11-10 | Iain Coleman uk.org.publicwhip/member/124 | Iain Coleman uk.org.publicwhip/person/10124 | 0 | 2000-11-10-84642823-10124-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");