items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
2 rows where record_id = "2003-12-04-84642823-11059-0" sorted by date descending
This data as json, CSV (advanced)
Suggested facets: date (date)
| hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
|---|---|---|---|---|---|---|---|
| dc84d317be6212c018ea2822dea9bc55f5e16e32 | 10 August 2003, as a member of the All-Party Parliamentary Football Group I took part in a Four Nations Football tournament in Cardiff. The tournament was sponsored by McDonalds Restaurant, who provided accommodation, hospitality and tickets to the Community Shield Football game. (Registered 22 September 2003) | Gifts, benefits and hospitality (UK) 84642823 | 2003-12-04 | Iain Luke uk.org.publicwhip/member/1059 | Iain Luke uk.org.publicwhip/person/11059 | 0 | 2003-12-04-84642823-11059-0 |
| 72cfec29e0d4e4b6874fa64f7044e2b149cea276 | 2-3 September 2003, as a member of the All-Party Rail Group I was accompained by my wife on the group's visit to Doncaster, Immingham, York, and Whitby, sponsored by EWS Railways, GNER, Jarvis plc, Arriva and the North Yorkshire Moors Railway, who provided transport, accommodation and hospitality. (Registered 22 September 2003) | Gifts, benefits and hospitality (UK) 84642823 | 2003-12-04 | Iain Luke uk.org.publicwhip/member/1059 | Iain Luke uk.org.publicwhip/person/11059 | 1 | 2003-12-04-84642823-11059-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");