items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
14 rows where record_id = "2011-11-29-80ef1083-10074-0" sorted by category_id
This data as json, CSV (advanced)
Suggested facets: date (date)
hash | item | category_id ▼ | date | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
c895dc94abafef47ccb6ae8ea7962a13fecf280b | Name of donor: Cadbury/Kraft | Overseas visits 80ef1083 | 2011-11-29 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 0 | 2011-11-29-80ef1083-10074-0 |
bea061f512fe118609dd135c0b1e3da3924f5d63 | Address of donor: Kraft UK, St George’s House, Bayshill Road, Cheltenham GL50 3AE | Overseas visits 80ef1083 | 2011-11-29 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 1 | 2011-11-29-80ef1083-10074-0 |
7871d2f6eb5b86811a90929d193b5dddb4d2b167 | Amount of donation (or estimate of the probable value): return business class flight Heathrow-Ghana, 2 nights hotel in Accra, ground transportation, meals and hospitality; total value £4,175 | Overseas visits 80ef1083 | 2011-11-29 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 2 | 2011-11-29-80ef1083-10074-0 |
f1585dedcb92f62616d17bbea3e0611935d2bde3 | Destination of visit: Ghana | Overseas visits 80ef1083 | 2011-11-29 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 3 | 2011-11-29-80ef1083-10074-0 |
6584a61abe1753a8fdd44ba05b7ce59e117f9395 | Date of visit: 29-31 August 2010 | Overseas visits 80ef1083 | 2011-11-29 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 4 | 2011-11-29-80ef1083-10074-0 |
b853e2a83faae1d8d4f96da5ec58b758b562feb4 | Purpose of visit: to visit cocoa production sites and Fairtrade villages | Overseas visits 80ef1083 | 2011-11-29 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 5 | 2011-11-29-80ef1083-10074-0 |
f575fdd5bbb8c80d6deacaf661b86a34f192f075 | (Registered 23 September 2010) | Overseas visits 80ef1083 | 2011-11-29 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 6 | 2011-11-29-80ef1083-10074-0 |
04d2d6a7114ee06d73254d6a185084e7d7549604 | Name of donor: Indian Government | Overseas visits 80ef1083 | 2011-11-29 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 7 | 2011-11-29-80ef1083-10074-0 |
a74e6f960c35bf06c6eb1501c814a12a5113df54 | Address of donor: Public Diplomacy Division, Ministry of External Affairs, Government of India, New Delhi, India | Overseas visits 80ef1083 | 2011-11-29 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 8 | 2011-11-29-80ef1083-10074-0 |
36f2094a42028f5a7ec43f333b99cf4e24a2d7e4 | Amount of donation (or estimate of the probable value): air fare £2,321.31, hotels £755.69 and food and hospitality; total value £3,327 | Overseas visits 80ef1083 | 2011-11-29 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 9 | 2011-11-29-80ef1083-10074-0 |
77ebdc99146fb0e034116d06f16378227022b3ae | Destination of visit: Delhi and Thiruvahindrapuram, India | Overseas visits 80ef1083 | 2011-11-29 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 10 | 2011-11-29-80ef1083-10074-0 |
f23f66de1cc02f31a4d65fee584acd466c8587b3 | Date of visit: 25 September-2 October 2010 | Overseas visits 80ef1083 | 2011-11-29 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 11 | 2011-11-29-80ef1083-10074-0 |
6140c2c947b2a4a3c2638561a09348e6229660d5 | Purpose of visit: to improve UK/India relationship | Overseas visits 80ef1083 | 2011-11-29 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 12 | 2011-11-29-80ef1083-10074-0 |
d5414d31d9de9a65404a3441ba4cfba4782e788d | (Registered 27 October 2010) | Overseas visits 80ef1083 | 2011-11-29 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 13 | 2011-11-29-80ef1083-10074-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");