items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
2 rows where record_id = "2000-11-10-80ef1083-10494-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 |
|---|---|---|---|---|---|---|---|
| b6e6fbdd116eb13e042f37d7ade3f1a1e8ca7fde | 25-29 June 1999, to Jerusalem, West Bank and Gaza with the Labour Middle East Council, to meet with Members of the Palestine Assembly, Israeli Foreign Affairs Department, UN Refugee Organisations and British Consular officials, to assist understanding of developing British Middle Eastern policy and practice following the Israeli General Election. Cost of air travel and accommodation was met by Mr A. Qattan on behalf of MIFTAH, a Palestinian organisation for the promotion of global dialogue and democracy. (Registered 30 July 1999) | Overseas visits 80ef1083 | 2000-11-10 | Lawrie Quinn uk.org.publicwhip/member/494 | Lawrie Quinn uk.org.publicwhip/person/10494 | 0 | 2000-11-10-80ef1083-10494-0 |
| f58445e4da2f43e8c0a6a3a62d9d55dbe434e69d | 9-13 April 2000, to Brazil with the British-Brazilian All-Party Group, travel and accommodation aid for by BG International. (Registered 8 June 2000 | Overseas visits 80ef1083 | 2000-11-10 | Lawrie Quinn uk.org.publicwhip/member/494 | Lawrie Quinn uk.org.publicwhip/person/10494 | 1 | 2000-11-10-80ef1083-10494-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");