items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
2 rows where record_id = "2002-11-26-80ef1083-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 |
|---|---|---|---|---|---|---|---|
| dc7410c3aaa171ed65b1eba565969413911afe14 | December 2001/January 2002, accompanied by my family I spent six nights as a guest of the Egyptian Government at two private Government villas at the New Tower Hotel in Sharm-el-Sheikh, Egypt. The Egyptian Government also provided my family and me with a return flight from Cairo to Sharm-el-Sheikh. I have made charitable donations to a charity chosen by the Egyptian Government equating to the cost to the Egyptians for this accommodation and travel. (Registered 14 January 2002) | Overseas visits 80ef1083 | 2002-11-26 | Tony Blair uk.org.publicwhip/member/736 | Tony Blair uk.org.publicwhip/person/10047 | 0 | 2002-11-26-80ef1083-10047-0 |
| a1714142380a7e3bee13b37554e4f391787f005c | October 2002, my wife and a family group stayed for a week at Government House, Bermuda, following a conference she was asked by the Bermudian Government to address in her professional capacity. The Bermudian Government paid her airfare: all the other expenses of the group were met by her, including payment for their accommodation at the standard rate fixed by the Bermudian Government. (Registered 31 October 2002) | Overseas visits 80ef1083 | 2002-11-26 | Tony Blair uk.org.publicwhip/member/736 | Tony Blair uk.org.publicwhip/person/10047 | 1 | 2002-11-26-80ef1083-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");