items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
14 rows where record_id = "2012-12-19-80ef1083-10062-0" sorted by record_id
This data as json, CSV (advanced)
date (date) 1 ✖
- 2012-12-19 14
hash | item | category_id | date | member_id | person_id | sort_order | record_id ▼ |
---|---|---|---|---|---|---|---|
651c6825c90d6ae346260cecd877fb349b14b5d5 | Name of donor: Cayman Islands Government | Overseas visits 80ef1083 | 2012-12-19 | Graham Brady uk.org.publicwhip/member/40041 | Graham Brady uk.org.publicwhip/person/10062 | 0 | 2012-12-19-80ef1083-10062-0 |
001f1efceb747c9ed8200b239c0da116d175cc9e | Address of donor: Government Administration Building, Grand Cayman, Cayman Islands | Overseas visits 80ef1083 | 2012-12-19 | Graham Brady uk.org.publicwhip/member/40041 | Graham Brady uk.org.publicwhip/person/10062 | 1 | 2012-12-19-80ef1083-10062-0 |
518004a3ec806d60601e666dc9bdc65faaeeaf8c | Amount of donation (or estimate of the probable value): £8,600 | Overseas visits 80ef1083 | 2012-12-19 | Graham Brady uk.org.publicwhip/member/40041 | Graham Brady uk.org.publicwhip/person/10062 | 2 | 2012-12-19-80ef1083-10062-0 |
0fada67346e6ad383eb592b9385026a9f6b71c78 | Destination of visit: Grand Cayman | Overseas visits 80ef1083 | 2012-12-19 | Graham Brady uk.org.publicwhip/member/40041 | Graham Brady uk.org.publicwhip/person/10062 | 3 | 2012-12-19-80ef1083-10062-0 |
6c77242783ac677f29dc35450b841ab84ca0d8cb | Date of visit: 30 March to 6 April 2012 | Overseas visits 80ef1083 | 2012-12-19 | Graham Brady uk.org.publicwhip/member/40041 | Graham Brady uk.org.publicwhip/person/10062 | 4 | 2012-12-19-80ef1083-10062-0 |
11a2a095c78686b037563343fcd6aa23a87293dd | Purpose of visit: to attend a great number of events and meetings and participate in a very wide ranging number of topics with the government and other interested parties. | Overseas visits 80ef1083 | 2012-12-19 | Graham Brady uk.org.publicwhip/member/40041 | Graham Brady uk.org.publicwhip/person/10062 | 5 | 2012-12-19-80ef1083-10062-0 |
97c9f562b45df729d432077ab8b917ae6287985d | (Registered 16 April 2012) | Overseas visits 80ef1083 | 2012-12-19 | Graham Brady uk.org.publicwhip/member/40041 | Graham Brady uk.org.publicwhip/person/10062 | 6 | 2012-12-19-80ef1083-10062-0 |
6fcd917e571e8612238c4c5f61579c6da1863ae6 | Name of donor: Government of Republic of China (Taiwan) | Overseas visits 80ef1083 | 2012-12-19 | Graham Brady uk.org.publicwhip/member/40041 | Graham Brady uk.org.publicwhip/person/10062 | 7 | 2012-12-19-80ef1083-10062-0 |
40f0341c61dfe52610b29e22f4347742afa95ef3 | Address of donor: Taipei Representative Office in the UK, 50 Grosvenor Gardens, London SW1 | Overseas visits 80ef1083 | 2012-12-19 | Graham Brady uk.org.publicwhip/member/40041 | Graham Brady uk.org.publicwhip/person/10062 | 8 | 2012-12-19-80ef1083-10062-0 |
7f32edf8d70714cc66d2329c7651a2d06a3f84a2 | Amount of donation (or estimate of the probable value): £3,300 | Overseas visits 80ef1083 | 2012-12-19 | Graham Brady uk.org.publicwhip/member/40041 | Graham Brady uk.org.publicwhip/person/10062 | 9 | 2012-12-19-80ef1083-10062-0 |
cd987bb0d2a390c46f128963deb182d321c11907 | Destination of visit: Taiwan | Overseas visits 80ef1083 | 2012-12-19 | Graham Brady uk.org.publicwhip/member/40041 | Graham Brady uk.org.publicwhip/person/10062 | 10 | 2012-12-19-80ef1083-10062-0 |
6854dcc46acdedd31c4d7d3e21dd6d899d75c910 | Date of visit: 23-29 September 2012 | Overseas visits 80ef1083 | 2012-12-19 | Graham Brady uk.org.publicwhip/member/40041 | Graham Brady uk.org.publicwhip/person/10062 | 11 | 2012-12-19-80ef1083-10062-0 |
0c9d6507d658252163509068a4c5472f85261162 | Purpose of visit: to meet the President and senior Members of the Government and Opposition to discuss issues affecting Taiwan and the UK | Overseas visits 80ef1083 | 2012-12-19 | Graham Brady uk.org.publicwhip/member/40041 | Graham Brady uk.org.publicwhip/person/10062 | 12 | 2012-12-19-80ef1083-10062-0 |
b06e6837c9aa03f91124c1fb116b6bfde16c3bf9 | (Registered 25 October 2012) | Overseas visits 80ef1083 | 2012-12-19 | Graham Brady uk.org.publicwhip/member/40041 | Graham Brady uk.org.publicwhip/person/10062 | 13 | 2012-12-19-80ef1083-10062-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");