Data source: mySociety Data · About: simonw/register-of-members-interests
This data as json, CSV (advanced)
Suggested facets: category_id, date, sort_order, record_id, date (date)
| hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
|---|---|---|---|---|---|---|---|
| fd9c2592372468530e4a3662e34d5694031dc87c | May 2004, to Kuwait, as Chairman of the All-Party Parliamentary Kuwait Group, accommodation and fares paid by the Kuwaiti Government. (Registered 14 January 2005) | Overseas visits 80ef1083 | 2005-04-11 | Khalid Mahmood uk.org.publicwhip/member/1087 | Khalid Mahmood uk.org.publicwhip/person/11087 | 0 | 2005-04-11-80ef1083-11087-0 |
| f40c67d30aeacad37991409b660d1848a2ffa1eb | 7-11 May 2004, to Kuwait, as Chairman of the All-Party Parliamentary Kuwait Group, accommodation and fares paid by the Kuwaiti Government. (Registered 14 January 2005) | Overseas visits 80ef1083 | 2005-01-28 | Khalid Mahmood uk.org.publicwhip/member/1087 | Khalid Mahmood uk.org.publicwhip/person/11087 | 0 | 2005-01-28-80ef1083-11087-0 |
| e0522117646cfa5375b5d32fc22a82f3cffbada1 | 14-17 January 2002, to Egypt and Saudi Arabia with Muslim Parliamentary delegation, sponsored by FCO. One internal flight in Saudi Arabia and hospitality in Saudi Arabia paid for by Saudi Arabian Government. (Registered 25 March 2002) | Overseas visits 80ef1083 | 2002-11-26 | Khalid Mahmood uk.org.publicwhip/member/1087 | Khalid Mahmood uk.org.publicwhip/person/11087 | 0 | 2002-11-26-80ef1083-11087-0 |
| 19e243623e5f75e9206276ad22edc264d6c968ed | 31 March-5 April 2002, to Egypt, accompanied by partner, on study tour with All-Party Egypt Group. Flights and hospitality paid for by Egyptian Government. (Registered 15 June 2002) | Overseas visits 80ef1083 | 2002-11-26 | Khalid Mahmood uk.org.publicwhip/member/1087 | Khalid Mahmood uk.org.publicwhip/person/11087 | 1 | 2002-11-26-80ef1083-11087-0 |
| 4f2c9beb9f9cf34ead0686ac8a5d92b4398dd5a0 | 8-15 May 2002, to Kuwait, with Muslim Parliamentary delegation at request of Kuwaiti Information Centre. Flights and hospitality paid for by Kuwaiti Government. (Registered 5 August 2002) | Overseas visits 80ef1083 | 2002-11-26 | Khalid Mahmood uk.org.publicwhip/member/1087 | Khalid Mahmood uk.org.publicwhip/person/11087 | 2 | 2002-11-26-80ef1083-11087-0 |
| fbe9ba01a22cc8b14ff5998951fb657c6d5d944d | Occasional fees for opinion polls (sent direct to a local charity). | Remunerated employment, office, profession etc 1f359ece | 2002-05-14 | Khalid Mahmood uk.org.publicwhip/member/1087 | Khalid Mahmood uk.org.publicwhip/person/11087 | 0 | 2002-05-14-1f359ece-11087-0 |
| df9ce045b0061cc81217799910a3117906932511 | 12-17 January 2002, to Egypt and Saudi Arabia with Muslim Parliamentary delegation, sponsored by FCO. One internal flight in Saudi Arabia and hospitality in Saudi Arabia paid for by Saudi Arabian Government. (Registered 25 March 2002) | Overseas visits 80ef1083 | 2002-05-14 | Khalid Mahmood uk.org.publicwhip/member/1087 | Khalid Mahmood uk.org.publicwhip/person/11087 | 0 | 2002-05-14-80ef1083-11087-0 |
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");