items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
14 rows where record_id = "2012-06-11-80ef1083-10076-0" sorted by sort_order descending
This data as json, CSV (advanced)
date (date) 1 ✖
- 2012-06-11 14
hash | item | category_id | date | member_id | person_id | sort_order ▲ | record_id |
---|---|---|---|---|---|---|---|
7fbe118749c2ffd47ae736324b740ff70af518de | (Registered 3 May 2012) | Overseas visits 80ef1083 | 2012-06-11 | Richard Burden uk.org.publicwhip/member/40085 | Richard Burden uk.org.publicwhip/person/10076 | 13 | 2012-06-11-80ef1083-10076-0 |
cca4c125e6d10a2156f54bbd1a7fcca1639afbf0 | Purpose of visit: All-Party Parliamentary Jordan Group Delegation | Overseas visits 80ef1083 | 2012-06-11 | Richard Burden uk.org.publicwhip/member/40085 | Richard Burden uk.org.publicwhip/person/10076 | 12 | 2012-06-11-80ef1083-10076-0 |
bc7870bae8a384ba5a5806a308dbe9ede007c913 | Date of visit: 8 – 14 April 2012 | Overseas visits 80ef1083 | 2012-06-11 | Richard Burden uk.org.publicwhip/member/40085 | Richard Burden uk.org.publicwhip/person/10076 | 11 | 2012-06-11-80ef1083-10076-0 |
dd5a77e8017f660a48be7ca076854af05e25cca2 | Destination of visit: Jordan | Overseas visits 80ef1083 | 2012-06-11 | Richard Burden uk.org.publicwhip/member/40085 | Richard Burden uk.org.publicwhip/person/10076 | 10 | 2012-06-11-80ef1083-10076-0 |
e10239c41602ce1c60398474d6149a1156cee97c | Amount of donation: £2,029.45, to cover travel costs, accommodation, subsistence and internal tours | Overseas visits 80ef1083 | 2012-06-11 | Richard Burden uk.org.publicwhip/member/40085 | Richard Burden uk.org.publicwhip/person/10076 | 9 | 2012-06-11-80ef1083-10076-0 |
03227cc9f5f14cb5416f296cbff67952f5372998 | Address of donor: Al Umah Street, Amman, Jordan | Overseas visits 80ef1083 | 2012-06-11 | Richard Burden uk.org.publicwhip/member/40085 | Richard Burden uk.org.publicwhip/person/10076 | 8 | 2012-06-11-80ef1083-10076-0 |
129e421ee57827b4f718f8c8c4d9f08b0afefc8b | Name of donor: Jordanian House of Representatives | Overseas visits 80ef1083 | 2012-06-11 | Richard Burden uk.org.publicwhip/member/40085 | Richard Burden uk.org.publicwhip/person/10076 | 7 | 2012-06-11-80ef1083-10076-0 |
083b44ecf43c5fdee27be97bccb28a533ab1a9ab | (Registered 21 March 2012) | Overseas visits 80ef1083 | 2012-06-11 | Richard Burden uk.org.publicwhip/member/40085 | Richard Burden uk.org.publicwhip/person/10076 | 6 | 2012-06-11-80ef1083-10076-0 |
1ac1d8c09ffcbd3d51f3463383d4bb24973e3ebc | Purpose of visit: delegation to Gaza and Egypt with the Britain Palestine All-Party Parliamentary Group | Overseas visits 80ef1083 | 2012-06-11 | Richard Burden uk.org.publicwhip/member/40085 | Richard Burden uk.org.publicwhip/person/10076 | 5 | 2012-06-11-80ef1083-10076-0 |
d3a7cabcb48f53885ee1498a8ac2e170a5e57e4f | Date of visit: 8-12 March 2012 | Overseas visits 80ef1083 | 2012-06-11 | Richard Burden uk.org.publicwhip/member/40085 | Richard Burden uk.org.publicwhip/person/10076 | 4 | 2012-06-11-80ef1083-10076-0 |
1741498d7c6d093e7331402e2537541e683ff245 | Destination of visit: Gaza and Egypt | Overseas visits 80ef1083 | 2012-06-11 | Richard Burden uk.org.publicwhip/member/40085 | Richard Burden uk.org.publicwhip/person/10076 | 3 | 2012-06-11-80ef1083-10076-0 |
b2c7fd7ffd602ff1531b74878350ce38fc06ed50 | Amount of donation (or estimate of the probable value): travel costs, accommodation and subsistence; value £2,000 | Overseas visits 80ef1083 | 2012-06-11 | Richard Burden uk.org.publicwhip/member/40085 | Richard Burden uk.org.publicwhip/person/10076 | 2 | 2012-06-11-80ef1083-10076-0 |
001c82b50696b22ce0f3b16317c8773d77e5714f | Address of donor: School of Oriental and African Studies, Thornhaugh Street, Russell Square, London WC1H 0XG | Overseas visits 80ef1083 | 2012-06-11 | Richard Burden uk.org.publicwhip/member/40085 | Richard Burden uk.org.publicwhip/person/10076 | 1 | 2012-06-11-80ef1083-10076-0 |
21b079e005fe907827a0b9c32fbaadc5a71d6276 | Name of donor: Sir Joseph Hotung Programme | Overseas visits 80ef1083 | 2012-06-11 | Richard Burden uk.org.publicwhip/member/40085 | Richard Burden uk.org.publicwhip/person/10076 | 0 | 2012-06-11-80ef1083-10076-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");