items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
14 rows where record_id = "2012-07-09-80ef1083-10062-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 |
---|---|---|---|---|---|---|---|
2cc0214a5793d54d943ceb96ab9820092a0160cb | Name of donor: The European Azerbaijan society | Overseas visits 80ef1083 | 2012-07-09 | Graham Brady uk.org.publicwhip/member/40041 | Graham Brady uk.org.publicwhip/person/10062 | 0 | 2012-07-09-80ef1083-10062-0 |
3731b63a1f7d972642a637abe63056bd0eb4ccb5 | Address of donor: 2 Queen Anne’s Gate, London SW1H 9AA | Overseas visits 80ef1083 | 2012-07-09 | Graham Brady uk.org.publicwhip/member/40041 | Graham Brady uk.org.publicwhip/person/10062 | 1 | 2012-07-09-80ef1083-10062-0 |
652395f2a479852223536c6dd85e9e87fe600b7d | Amount of donation (or estimate of the probable value): travel and accommodation estimated at £3,600 | Overseas visits 80ef1083 | 2012-07-09 | Graham Brady uk.org.publicwhip/member/40041 | Graham Brady uk.org.publicwhip/person/10062 | 2 | 2012-07-09-80ef1083-10062-0 |
0474c57e2a7933631f5b1a16739fc09feccd3213 | Destination of visit: Azerbaijan | Overseas visits 80ef1083 | 2012-07-09 | Graham Brady uk.org.publicwhip/member/40041 | Graham Brady uk.org.publicwhip/person/10062 | 3 | 2012-07-09-80ef1083-10062-0 |
f18f5e1e96fe49695d165daf1abdc1352a946520 | Date of visit: 22 -27 July 2011 | Overseas visits 80ef1083 | 2012-07-09 | Graham Brady uk.org.publicwhip/member/40041 | Graham Brady uk.org.publicwhip/person/10062 | 4 | 2012-07-09-80ef1083-10062-0 |
5d496412cb4e741fd4cbe3dd9b2947bb509d3147 | Purpose of visit: to meet senior Azerbaijani political and business figures and, British diplomats, and to visit some of the regions and IDP camp | Overseas visits 80ef1083 | 2012-07-09 | Graham Brady uk.org.publicwhip/member/40041 | Graham Brady uk.org.publicwhip/person/10062 | 5 | 2012-07-09-80ef1083-10062-0 |
02078ae0be11a26de8f708e98d883fdd676d2649 | (Registered 26 August 2011) | Overseas visits 80ef1083 | 2012-07-09 | Graham Brady uk.org.publicwhip/member/40041 | Graham Brady uk.org.publicwhip/person/10062 | 6 | 2012-07-09-80ef1083-10062-0 |
ee5e78c0d9608da3ec9a24a1360e38dc1e58f688 | Name of donor: Cayman Islands Government | Overseas visits 80ef1083 | 2012-07-09 | Graham Brady uk.org.publicwhip/member/40041 | Graham Brady uk.org.publicwhip/person/10062 | 7 | 2012-07-09-80ef1083-10062-0 |
90f8821375ee203431040cfda9c53f3c21d4c707 | Address of donor: Government Administration Building, Grand Cayman, Cayman Islands | Overseas visits 80ef1083 | 2012-07-09 | Graham Brady uk.org.publicwhip/member/40041 | Graham Brady uk.org.publicwhip/person/10062 | 8 | 2012-07-09-80ef1083-10062-0 |
188d2b35112a65f5b12a6e9ea46c450b44df566c | Amount of donation (or estimate of the probable value): £8,600 | Overseas visits 80ef1083 | 2012-07-09 | Graham Brady uk.org.publicwhip/member/40041 | Graham Brady uk.org.publicwhip/person/10062 | 9 | 2012-07-09-80ef1083-10062-0 |
516ecbc5ca28e2f219c611d4483308807d9f925b | Destination of visit: Grand Cayman | Overseas visits 80ef1083 | 2012-07-09 | Graham Brady uk.org.publicwhip/member/40041 | Graham Brady uk.org.publicwhip/person/10062 | 10 | 2012-07-09-80ef1083-10062-0 |
b9ce88f69c843e17add461d8e4046f31be02767d | Date of visit: 30 March to 6 April 2012 | Overseas visits 80ef1083 | 2012-07-09 | Graham Brady uk.org.publicwhip/member/40041 | Graham Brady uk.org.publicwhip/person/10062 | 11 | 2012-07-09-80ef1083-10062-0 |
94a3257fb46047d237082277f4aed8a7e012ad2b | 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-07-09 | Graham Brady uk.org.publicwhip/member/40041 | Graham Brady uk.org.publicwhip/person/10062 | 12 | 2012-07-09-80ef1083-10062-0 |
e72c8ee7ed5c363ad5a3f4e3590b8a1ee6e99246 | (Registered 16 April 2012) | Overseas visits 80ef1083 | 2012-07-09 | Graham Brady uk.org.publicwhip/member/40041 | Graham Brady uk.org.publicwhip/person/10062 | 13 | 2012-07-09-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");