items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
18 rows where item = "1-7 September 2007, to Venezuela for fact-finding visit. Accommodation paid for by the Government of Venezuela. (I paid for my flights.) (Registered 9 October 2007)" and person_id = "uk.org.publicwhip/person/10077" 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 |
---|---|---|---|---|---|---|---|
f13303a85964c58bbb8a26e4e8dd0bc3d6bade36 | 1-7 September 2007, to Venezuela for fact-finding visit. Accommodation paid for by the Government of Venezuela. (I paid for my flights.) (Registered 9 October 2007) | Overseas visits 80ef1083 | 2008-10-08 | Colin Burgon uk.org.publicwhip/member/1570 | Colin Burgon uk.org.publicwhip/person/10077 | 1 | 2008-10-08-80ef1083-10077-0 |
27af9bcbd19012e82f64b23030f1cd6042c18414 | 1-7 September 2007, to Venezuela for fact-finding visit. Accommodation paid for by the Government of Venezuela. (I paid for my flights.) (Registered 9 October 2007) | Overseas visits 80ef1083 | 2008-09-03 | Colin Burgon uk.org.publicwhip/member/1570 | Colin Burgon uk.org.publicwhip/person/10077 | 1 | 2008-09-03-80ef1083-10077-0 |
2b353e067d9be85b9f8f219c9069d771fe3c31e6 | 1-7 September 2007, to Venezuela for fact-finding visit. Accommodation paid for by the Government of Venezuela. (I paid for my flights.) (Registered 9 October 2007) | Overseas visits 80ef1083 | 2008-07-22 | Colin Burgon uk.org.publicwhip/member/1570 | Colin Burgon uk.org.publicwhip/person/10077 | 1 | 2008-07-22-80ef1083-10077-0 |
437253d0d9e88031ae1f1c7d2349dc5f7eaac96c | 1-7 September 2007, to Venezuela for fact-finding visit. Accommodation paid for by the Government of Venezuela. (I paid for my flights.) (Registered 9 October 2007) | Overseas visits 80ef1083 | 2008-07-08 | Colin Burgon uk.org.publicwhip/member/1570 | Colin Burgon uk.org.publicwhip/person/10077 | 1 | 2008-07-08-80ef1083-10077-0 |
f279e5118aff35bc1e3bcca1e04efacae3417f04 | 1-7 September 2007, to Venezuela for fact-finding visit. Accommodation paid for by the Government of Venezuela. (I paid for my flights.) (Registered 9 October 2007) | Overseas visits 80ef1083 | 2008-06-16 | Colin Burgon uk.org.publicwhip/member/1570 | Colin Burgon uk.org.publicwhip/person/10077 | 1 | 2008-06-16-80ef1083-10077-0 |
b7fe4aeb7e60627ec5b6e4c2b34c35eb41eb0372 | 1-7 September 2007, to Venezuela for fact-finding visit. Accommodation paid for by the Government of Venezuela. (I paid for my flights.) (Registered 9 October 2007) | Overseas visits 80ef1083 | 2008-04-23 | Colin Burgon uk.org.publicwhip/member/1570 | Colin Burgon uk.org.publicwhip/person/10077 | 1 | 2008-04-23-80ef1083-10077-0 |
423ce0c64d488ec9d305042719082b01154ed612 | 1-7 September 2007, to Venezuela for fact-finding visit. Accommodation paid for by the Government of Venezuela. (I paid for my flights.) (Registered 9 October 2007) | Overseas visits 80ef1083 | 2008-03-25 | Colin Burgon uk.org.publicwhip/member/1570 | Colin Burgon uk.org.publicwhip/person/10077 | 1 | 2008-03-25-80ef1083-10077-0 |
28ff23122eaa8ade5da83db4f404075f681484e6 | 1-7 September 2007, to Venezuela for fact-finding visit. Accommodation paid for by the Government of Venezuela. (I paid for my flights.) (Registered 9 October 2007) | Overseas visits 80ef1083 | 2008-03-11 | Colin Burgon uk.org.publicwhip/member/1570 | Colin Burgon uk.org.publicwhip/person/10077 | 1 | 2008-03-11-80ef1083-10077-0 |
0a18003def1281c526e8726c220433afe3edd646 | 1-7 September 2007, to Venezuela for fact-finding visit. Accommodation paid for by the Government of Venezuela. (I paid for my flights.) (Registered 9 October 2007) | Overseas visits 80ef1083 | 2008-02-26 | Colin Burgon uk.org.publicwhip/member/1570 | Colin Burgon uk.org.publicwhip/person/10077 | 1 | 2008-02-26-80ef1083-10077-0 |
906a22be9a3d817183ca6a52942a6ef15d4e1e3c | 1-7 September 2007, to Venezuela for fact-finding visit. Accommodation paid for by the Government of Venezuela. (I paid for my flights.) (Registered 9 October 2007) | Overseas visits 80ef1083 | 2008-02-05 | Colin Burgon uk.org.publicwhip/member/1570 | Colin Burgon uk.org.publicwhip/person/10077 | 1 | 2008-02-05-80ef1083-10077-0 |
e19c3e25dc1c0568098c46ad4fdd33b681d5b389 | 1-7 September 2007, to Venezuela for fact-finding visit. Accommodation paid for by the Government of Venezuela. (I paid for my flights.) (Registered 9 October 2007) | Overseas visits 80ef1083 | 2008-01-22 | Colin Burgon uk.org.publicwhip/member/1570 | Colin Burgon uk.org.publicwhip/person/10077 | 1 | 2008-01-22-80ef1083-10077-0 |
768bab13fa0519d5f9131ba7e25e1a724fc4a10b | 1-7 September 2007, to Venezuela for fact-finding visit. Accommodation paid for by the Government of Venezuela. (I paid for my flights.) (Registered 9 October 2007) | Overseas visits 80ef1083 | 2008-01-09 | Colin Burgon uk.org.publicwhip/member/1570 | Colin Burgon uk.org.publicwhip/person/10077 | 1 | 2008-01-09-80ef1083-10077-0 |
f87c7f45ed1e2d57354fab2721209e26356d536b | 1-7 September 2007, to Venezuela for fact-finding visit. Accommodation paid for by the Government of Venezuela. (I paid for my flights.) (Registered 9 October 2007) | Overseas visits 80ef1083 | 2007-12-18 | Colin Burgon uk.org.publicwhip/member/1570 | Colin Burgon uk.org.publicwhip/person/10077 | 1 | 2007-12-18-80ef1083-10077-0 |
8c511577b43103122fdc3c0cc8055af72fade26e | 1-7 September 2007, to Venezuela for fact-finding visit. Accommodation paid for by the Government of Venezuela. (I paid for my flights.) (Registered 9 October 2007) | Overseas visits 80ef1083 | 2007-12-04 | Colin Burgon uk.org.publicwhip/member/1570 | Colin Burgon uk.org.publicwhip/person/10077 | 1 | 2007-12-04-80ef1083-10077-0 |
d272d01d60bf6d7a1c8e91c09d994894231e1129 | 1-7 September 2007, to Venezuela for fact-finding visit. Accommodation paid for by the Government of Venezuela. (I paid for my flights.) (Registered 9 October 2007) | Overseas visits 80ef1083 | 2007-11-20 | Colin Burgon uk.org.publicwhip/member/1570 | Colin Burgon uk.org.publicwhip/person/10077 | 1 | 2007-11-20-80ef1083-10077-0 |
9e3e8b00396f65bf9ad78beccf363307933dc4d3 | 1-7 September 2007, to Venezuela for fact-finding visit. Accommodation paid for by the Government of Venezuela. (I paid for my flights.) (Registered 9 October 2007) | Overseas visits 80ef1083 | 2007-11-06 | Colin Burgon uk.org.publicwhip/member/1570 | Colin Burgon uk.org.publicwhip/person/10077 | 1 | 2007-11-06-80ef1083-10077-0 |
e136484dd93648b2e6c4ec492bd63a05a6b092ce | 1-7 September 2007, to Venezuela for fact-finding visit. Accommodation paid for by the Government of Venezuela. (I paid for my flights.) (Registered 9 October 2007) | Overseas visits 80ef1083 | 2007-10-23 | Colin Burgon uk.org.publicwhip/member/1570 | Colin Burgon uk.org.publicwhip/person/10077 | 1 | 2007-10-23-80ef1083-10077-0 |
bf7b4b00ed446725a5a20f880520710bbb0b9ccb | 1-7 September 2007, to Venezuela for fact-finding visit. Accommodation paid for by the Government of Venezuela. (I paid for my flights.) (Registered 9 October 2007) | Overseas visits 80ef1083 | 2007-10-09 | Colin Burgon uk.org.publicwhip/member/1570 | Colin Burgon uk.org.publicwhip/person/10077 | 1 | 2007-10-09-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");