items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
18 rows where item = "10-14 January 2008, to Venezuela on a fact-finding visit, attending a conference of the PSUV, meetings with government representatives, parliamentarians and others. Transport, accommodation and hospitality provided by the Venezuelan Government. (Registered 26 February 2008)" and person_id = "uk.org.publicwhip/person/10077" sorted by sort_order
This data as json, CSV (advanced)
Suggested facets: sort_order, date (date)
hash | item | category_id | date | member_id | person_id | sort_order ▼ | record_id |
---|---|---|---|---|---|---|---|
1e116952c240dcd2b0619e0ced9fa621509a19b6 | 10-14 January 2008, to Venezuela on a fact-finding visit, attending a conference of the PSUV, meetings with government representatives, parliamentarians and others. Transport, accommodation and hospitality provided by the Venezuelan Government. (Registered 26 February 2008) | Overseas visits 80ef1083 | 2008-10-22 | Colin Burgon uk.org.publicwhip/member/1570 | Colin Burgon uk.org.publicwhip/person/10077 | 0 | 2008-10-22-80ef1083-10077-0 |
2dba2294b2188658ccb612bab4e2c2a74255f1c9 | 10-14 January 2008, to Venezuela on a fact-finding visit, attending a conference of the PSUV, meetings with government representatives, parliamentarians and others. Transport, accommodation and hospitality provided by the Venezuelan Government. (Registered 26 February 2008) | Overseas visits 80ef1083 | 2008-11-05 | Colin Burgon uk.org.publicwhip/member/1570 | Colin Burgon uk.org.publicwhip/person/10077 | 0 | 2008-11-05-80ef1083-10077-0 |
16e6d579ab8a83d2748500c0a1d08acd97b9d800 | 10-14 January 2008, to Venezuela on a fact-finding visit, attending a conference of the PSUV, meetings with government representatives, parliamentarians and others. Transport, accommodation and hospitality provided by the Venezuelan Government. (Registered 26 February 2008) | Overseas visits 80ef1083 | 2008-11-19 | Colin Burgon uk.org.publicwhip/member/1570 | Colin Burgon uk.org.publicwhip/person/10077 | 0 | 2008-11-19-80ef1083-10077-0 |
77b0008d03abef5f9d679d7e1343560c373e6c11 | 10-14 January 2008, to Venezuela on a fact-finding visit, attending a conference of the PSUV, meetings with government representatives, parliamentarians and others. Transport, accommodation and hospitality provided by the Venezuelan Government. (Registered 26 February 2008) | Overseas visits 80ef1083 | 2008-12-03 | Colin Burgon uk.org.publicwhip/member/1570 | Colin Burgon uk.org.publicwhip/person/10077 | 0 | 2008-12-03-80ef1083-10077-0 |
859628ca00666b0677988170e5987683c9a676a3 | 10-14 January 2008, to Venezuela on a fact-finding visit, attending a conference of the PSUV, meetings with government representatives, parliamentarians and others. Transport, accommodation and hospitality provided by the Venezuelan Government. (Registered 26 February 2008) | Overseas visits 80ef1083 | 2008-12-17 | Colin Burgon uk.org.publicwhip/member/1570 | Colin Burgon uk.org.publicwhip/person/10077 | 0 | 2008-12-17-80ef1083-10077-0 |
236c8f7b15520d33da95525d41bbdcfa0df60664 | 10-14 January 2008, to Venezuela on a fact-finding visit, attending a conference of the PSUV, meetings with government representatives, parliamentarians and others. Transport, accommodation and hospitality provided by the Venezuelan Government. (Registered 26 February 2008) | Overseas visits 80ef1083 | 2009-01-14 | Colin Burgon uk.org.publicwhip/member/1570 | Colin Burgon uk.org.publicwhip/person/10077 | 0 | 2009-01-14-80ef1083-10077-0 |
c3e85ebc4a300596eabab76aed05969c0d39e893 | 10-14 January 2008, to Venezuela on a fact-finding visit, attending a conference of the PSUV, meetings with government representatives, parliamentarians and others. Transport, accommodation and hospitality provided by the Venezuelan Government. (Registered 26 February 2008) | Overseas visits 80ef1083 | 2009-01-28 | Colin Burgon uk.org.publicwhip/member/1570 | Colin Burgon uk.org.publicwhip/person/10077 | 0 | 2009-01-28-80ef1083-10077-0 |
e99b7c8f85d9b35636b929890a5bfebe813c9cfc | 10-14 January 2008, to Venezuela on a fact-finding visit, attending a conference of the PSUV, meetings with government representatives, parliamentarians and others. Transport, accommodation and hospitality provided by the Venezuelan Government. (Registered 26 February 2008) | Overseas visits 80ef1083 | 2009-02-11 | Colin Burgon uk.org.publicwhip/member/1570 | Colin Burgon uk.org.publicwhip/person/10077 | 0 | 2009-02-11-80ef1083-10077-0 |
134bf2ea657c99f0bc2dda708680fead76e8ea90 | 10-14 January 2008, to Venezuela on a fact-finding visit, attending a conference of the PSUV, meetings with government representatives, parliamentarians and others. Transport, accommodation and hospitality provided by the Venezuelan Government. (Registered 26 February 2008) | Overseas visits 80ef1083 | 2009-02-25 | Colin Burgon uk.org.publicwhip/member/1570 | Colin Burgon uk.org.publicwhip/person/10077 | 0 | 2009-02-25-80ef1083-10077-0 |
0323fd412bc6a545f8ff7d3ac1e41f9a18d7937e | 10-14 January 2008, to Venezuela on a fact-finding visit, attending a conference of the PSUV, meetings with government representatives, parliamentarians and others. Transport, accommodation and hospitality provided by the Venezuelan Government. (Registered 26 February 2008) | Overseas visits 80ef1083 | 2008-02-26 | Colin Burgon uk.org.publicwhip/member/1570 | Colin Burgon uk.org.publicwhip/person/10077 | 2 | 2008-02-26-80ef1083-10077-0 |
f2e83103f0156476a9bd9ec0217fde60e6f35a8d | 10-14 January 2008, to Venezuela on a fact-finding visit, attending a conference of the PSUV, meetings with government representatives, parliamentarians and others. Transport, accommodation and hospitality provided by the Venezuelan Government. (Registered 26 February 2008) | Overseas visits 80ef1083 | 2008-03-11 | Colin Burgon uk.org.publicwhip/member/1570 | Colin Burgon uk.org.publicwhip/person/10077 | 2 | 2008-03-11-80ef1083-10077-0 |
b2647048dba5a4bf6b7a2d0726c524ae3f66c9a4 | 10-14 January 2008, to Venezuela on a fact-finding visit, attending a conference of the PSUV, meetings with government representatives, parliamentarians and others. Transport, accommodation and hospitality provided by the Venezuelan Government. (Registered 26 February 2008) | Overseas visits 80ef1083 | 2008-03-25 | Colin Burgon uk.org.publicwhip/member/1570 | Colin Burgon uk.org.publicwhip/person/10077 | 2 | 2008-03-25-80ef1083-10077-0 |
ba499fd68305e5ec7b96b18d953d745829a95203 | 10-14 January 2008, to Venezuela on a fact-finding visit, attending a conference of the PSUV, meetings with government representatives, parliamentarians and others. Transport, accommodation and hospitality provided by the Venezuelan Government. (Registered 26 February 2008) | Overseas visits 80ef1083 | 2008-04-23 | Colin Burgon uk.org.publicwhip/member/1570 | Colin Burgon uk.org.publicwhip/person/10077 | 2 | 2008-04-23-80ef1083-10077-0 |
d2a798c097b25d21ea302fc8c6f45456aeb2cb57 | 10-14 January 2008, to Venezuela on a fact-finding visit, attending a conference of the PSUV, meetings with government representatives, parliamentarians and others. Transport, accommodation and hospitality provided by the Venezuelan Government. (Registered 26 February 2008) | Overseas visits 80ef1083 | 2008-06-16 | Colin Burgon uk.org.publicwhip/member/1570 | Colin Burgon uk.org.publicwhip/person/10077 | 2 | 2008-06-16-80ef1083-10077-0 |
5d1fc203ef3cf12e585d7ee05fb026719f171c3a | 10-14 January 2008, to Venezuela on a fact-finding visit, attending a conference of the PSUV, meetings with government representatives, parliamentarians and others. Transport, accommodation and hospitality provided by the Venezuelan Government. (Registered 26 February 2008) | Overseas visits 80ef1083 | 2008-07-08 | Colin Burgon uk.org.publicwhip/member/1570 | Colin Burgon uk.org.publicwhip/person/10077 | 2 | 2008-07-08-80ef1083-10077-0 |
d7d65e72ffad84e94514736908b501aba7c02abc | 10-14 January 2008, to Venezuela on a fact-finding visit, attending a conference of the PSUV, meetings with government representatives, parliamentarians and others. Transport, accommodation and hospitality provided by the Venezuelan Government. (Registered 26 February 2008) | Overseas visits 80ef1083 | 2008-07-22 | Colin Burgon uk.org.publicwhip/member/1570 | Colin Burgon uk.org.publicwhip/person/10077 | 2 | 2008-07-22-80ef1083-10077-0 |
9685272a95e9ac97765e748f8b8460c5f2eb5fc5 | 10-14 January 2008, to Venezuela on a fact-finding visit, attending a conference of the PSUV, meetings with government representatives, parliamentarians and others. Transport, accommodation and hospitality provided by the Venezuelan Government. (Registered 26 February 2008) | Overseas visits 80ef1083 | 2008-09-03 | Colin Burgon uk.org.publicwhip/member/1570 | Colin Burgon uk.org.publicwhip/person/10077 | 2 | 2008-09-03-80ef1083-10077-0 |
65ef93da09123053121a816e39ec6a0dd2d55ec5 | 10-14 January 2008, to Venezuela on a fact-finding visit, attending a conference of the PSUV, meetings with government representatives, parliamentarians and others. Transport, accommodation and hospitality provided by the Venezuelan Government. (Registered 26 February 2008) | Overseas visits 80ef1083 | 2008-10-08 | Colin Burgon uk.org.publicwhip/member/1570 | Colin Burgon uk.org.publicwhip/person/10077 | 2 | 2008-10-08-80ef1083-10077-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");