items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
14 rows where record_id = "2012-04-16-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 |
---|---|---|---|---|---|---|---|
1e04148b3b47d1aa6195f0777b8f7916e27d8094 | Name of donor: Kurdistan Parliament – Iraq (KPI) | Overseas visits 80ef1083 | 2012-04-16 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 0 | 2012-04-16-80ef1083-11455-0 |
00d3e5929e0e7dd13e66129651a0da246cac5e86 | Address of donor: Erbil, Iraq | Overseas visits 80ef1083 | 2012-04-16 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 1 | 2012-04-16-80ef1083-11455-0 |
1b68486dd8222e5c37d1996148f679dad253554d | Amount of donation (or estimate of the probable value): £684 donation to costs of visit | Overseas visits 80ef1083 | 2012-04-16 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 2 | 2012-04-16-80ef1083-11455-0 |
c0704763f5e20f093f1e51d4cd9820a424bdb110 | Destination of visit: Kurdistan | Overseas visits 80ef1083 | 2012-04-16 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 3 | 2012-04-16-80ef1083-11455-0 |
dab58d23fe5e899ae80d9e37cbe01d1452412974 | Date of visit: 19-24 February 2011 | Overseas visits 80ef1083 | 2012-04-16 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 4 | 2012-04-16-80ef1083-11455-0 |
984ed432d3c23c550635e156d8c902c61906833b | 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 | 2012-04-16 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 5 | 2012-04-16-80ef1083-11455-0 |
7d012dcbc6c8dea6c838def910fcad93b666f394 | (Registered 11 April 2011) | Overseas visits 80ef1083 | 2012-04-16 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 6 | 2012-04-16-80ef1083-11455-0 |
e694cc99647c962e09308f5e1c7e47b13bcbad2b | Name of donor: All Party Parliamentary China Group, sponsored by GKN plc, City of London, London Export Corporation (LEC), John Swire & Sons, GlaxoSmithKline, Astra Zeneca, Arup, University of Cambridge Local Examinations Syndicate, HSBC. | Overseas visits 80ef1083 | 2012-04-16 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 7 | 2012-04-16-80ef1083-11455-0 |
549f1310932de4a3c4dc933291c273a42cad11fd | Address of donor: c/o Great Britain China Centre, 15 Belgrave Square, London SW1X 8PS | Overseas visits 80ef1083 | 2012-04-16 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 8 | 2012-04-16-80ef1083-11455-0 |
cb506dd09383e2b8b434d61de6181cea8bc57987 | Amount of donation (or estimate of the probable value): £2,349.98; return flights to China, internal travel in China, accommodation and meals. I also received some meals and hospitality provided locally. | Overseas visits 80ef1083 | 2012-04-16 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 9 | 2012-04-16-80ef1083-11455-0 |
cf434c172b31c453a1707c03affe4a9fac988f2d | Destination of visit: China; Shanghai, Beijing and Chengdu | Overseas visits 80ef1083 | 2012-04-16 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 10 | 2012-04-16-80ef1083-11455-0 |
d74655c73c58acfe54c3a2aa19717f412d6ff8ce | Date of visit: 16-23 December 2011 | Overseas visits 80ef1083 | 2012-04-16 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 11 | 2012-04-16-80ef1083-11455-0 |
910b5206d7c042e3ec125a9904345c268e9ba2e1 | Purpose of visit: to maintain and strengthen relations between Parliament and the National People’s Congress of China; to learn about and support British businesses operating in China; and to deepen the knowledge and understanding of parliamentarians of China. | Overseas visits 80ef1083 | 2012-04-16 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 12 | 2012-04-16-80ef1083-11455-0 |
5adbb7c27de7a2c741d11039d4fe06bb32bebcdb | (Registered 4 January 2012) | Overseas visits 80ef1083 | 2012-04-16 | Kerry McCarthy uk.org.publicwhip/member/40122 | Kerry McCarthy uk.org.publicwhip/person/11455 | 13 | 2012-04-16-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");