items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
14 rows where record_id = "2011-06-20-80ef1083-11455-0" sorted by sort_order
This data as json, CSV (advanced)
Suggested facets: date (date)
hash | item | category_id | date | member_id | person_id | sort_order ▼ | record_id |
---|---|---|---|---|---|---|---|
41a8b2b8a4172fbf3dca315bcbcf18e0db9edcdf | Name of donor: All-Party Parliamentary Group on Agriculture and Food for Development | Overseas visits 80ef1083 | 2011-06-20 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 0 | 2011-06-20-80ef1083-11455-0 |
9dea660b602c1116fc61522628b578140998b561 | Address of donor: House of Commons | Overseas visits 80ef1083 | 2011-06-20 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 1 | 2011-06-20-80ef1083-11455-0 |
f4517bf9e2aa580cbc82611135ac6458e09b44d5 | Amount of donation (or estimate of the probable value): £1,690.02 | Overseas visits 80ef1083 | 2011-06-20 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 2 | 2011-06-20-80ef1083-11455-0 |
f332cb11aa46f8a493fa2f4eba8b86d94e548216 | Destination of visit: Kenya | Overseas visits 80ef1083 | 2011-06-20 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 3 | 2011-06-20-80ef1083-11455-0 |
01fa87496c25c0234f84ab61ce8f734c2b5abd96 | Date of visit: 12-18 September 2010 | Overseas visits 80ef1083 | 2011-06-20 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 4 | 2011-06-20-80ef1083-11455-0 |
b08f4566a01621ab8bf0b4018748cb2bc11de3c9 | Purpose of visit: to examine a number of issues related to food security and nutrition in Eastern Africa. | Overseas visits 80ef1083 | 2011-06-20 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 5 | 2011-06-20-80ef1083-11455-0 |
7ac3cb923335b73a80889ce115b988cc92f65db6 | (Registered 20 September 2010) | Overseas visits 80ef1083 | 2011-06-20 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 6 | 2011-06-20-80ef1083-11455-0 |
f79add82e2bdcac607ca1f5c17a0da042231e9da | Name of donor: Kurdistan Parliament – Iraq (KPI) | Overseas visits 80ef1083 | 2011-06-20 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 7 | 2011-06-20-80ef1083-11455-0 |
6eaa747c5b8363e5d38858b3d7d2931ed4bca95a | Address of donor: Erbil, Iraq | Overseas visits 80ef1083 | 2011-06-20 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 8 | 2011-06-20-80ef1083-11455-0 |
7bc282ab0a51b094cd4c236c3406501dd71e07ae | Amount of donation (or estimate of the probable value): £684 donation to costs of visit | Overseas visits 80ef1083 | 2011-06-20 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 9 | 2011-06-20-80ef1083-11455-0 |
bca04980169f90c0d7372223bde9dc39b6ef16f4 | Destination of visit: Kurdistan | Overseas visits 80ef1083 | 2011-06-20 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 10 | 2011-06-20-80ef1083-11455-0 |
721f3a5504c21d49465ef6022dc8b68f7141ed03 | Date of visit: 19-24 February 2011 | Overseas visits 80ef1083 | 2011-06-20 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 11 | 2011-06-20-80ef1083-11455-0 |
e2c6b527ce430414369aa5c15970f763799ab767 | Purpose of visit: to deliver the first workshop in the new programme ‘Support to the Kurdistan Parliament – Iraq’ for current members of the KPI, focusing on the roles and responsibilities of MPs with respect to the relationship between the government and the opposition. | Overseas visits 80ef1083 | 2011-06-20 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 12 | 2011-06-20-80ef1083-11455-0 |
0cf6370f04b38b6988f224a1ffca7e6c22b6523d | (Registered 11 April 2011) | Overseas visits 80ef1083 | 2011-06-20 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 13 | 2011-06-20-80ef1083-11455-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");