items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
2 rows where record_id = "2005-01-28-a41b9847-10047-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 |
|---|---|---|---|---|---|---|---|
| ac9ade445dd4a8c6d737496d8f0dff3236c4715f | July/August 2004, accompanied by my family I spent 18 nights as a guest at a private villa in Barbados. I have made a charitable donation to a charity chosen by Sir Cliff Richard, the owner of the villa, in lieu of the cost for this accommodation. I paid for all other expenses, including flights. (Registered 17 August 2004) | Overseas benefits and gifts a41b9847 | 2005-01-28 | Tony Blair uk.org.publicwhip/member/736 | Tony Blair uk.org.publicwhip/person/10047 | 0 | 2005-01-28-a41b9847-10047-0 |
| bfdb48838a0e98888e1eb483c18146228b7a3767 | 16 August 2004, while on holiday in Tuscany, I visited Prime Minister Berlusconi in Sardinia for talks. The Italian Government provided the travel arrangements for the visit and accommodation for an overnight stay which included my wife who accompanied me. (Registered 17 August 2004) | Overseas benefits and gifts a41b9847 | 2005-01-28 | Tony Blair uk.org.publicwhip/member/736 | Tony Blair uk.org.publicwhip/person/10047 | 1 | 2005-01-28-a41b9847-10047-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");