items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
14 rows where record_id = "2012-04-16-80ef1083-10062-0" sorted by member_id
This data as json, CSV (advanced)
date (date) 1 ✖
- 2012-04-16 14
hash | item | category_id | date | member_id ▼ | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
b242e71fd0c7b4b10045dcd35e468b9bfaa94eae | Name of donor: The European Azerbaijan society | Overseas visits 80ef1083 | 2012-04-16 | Graham Brady uk.org.publicwhip/member/40041 | Graham Brady uk.org.publicwhip/person/10062 | 0 | 2012-04-16-80ef1083-10062-0 |
107e59b9338ccd04bfc00f8015c6b53c90a8dbbe | Address of donor: 2 Queen Anne’s Gate, London SW1H 9AA | Overseas visits 80ef1083 | 2012-04-16 | Graham Brady uk.org.publicwhip/member/40041 | Graham Brady uk.org.publicwhip/person/10062 | 1 | 2012-04-16-80ef1083-10062-0 |
b63624bfe60d5f7a41d2a445475d907d5bc9b49e | Amount of donation (or estimate of the probable value): travel and accommodation estimated at £3,600 | Overseas visits 80ef1083 | 2012-04-16 | Graham Brady uk.org.publicwhip/member/40041 | Graham Brady uk.org.publicwhip/person/10062 | 2 | 2012-04-16-80ef1083-10062-0 |
b0b0d2a37d0d05e4b749f7c463f061d394538ae6 | Destination of visit: Azerbaijan | Overseas visits 80ef1083 | 2012-04-16 | Graham Brady uk.org.publicwhip/member/40041 | Graham Brady uk.org.publicwhip/person/10062 | 3 | 2012-04-16-80ef1083-10062-0 |
b350a21b50efbe065f3c0fb269e2410e91d206d9 | Date of visit: 22 -27 July 2011 | Overseas visits 80ef1083 | 2012-04-16 | Graham Brady uk.org.publicwhip/member/40041 | Graham Brady uk.org.publicwhip/person/10062 | 4 | 2012-04-16-80ef1083-10062-0 |
9cd82cf3ca961bad315a50748b07cce442dd13f9 | 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-04-16 | Graham Brady uk.org.publicwhip/member/40041 | Graham Brady uk.org.publicwhip/person/10062 | 5 | 2012-04-16-80ef1083-10062-0 |
6cd000473bc8a0bafa16082cc7a332ce41f4b250 | (Registered 26 August 2011) | Overseas visits 80ef1083 | 2012-04-16 | Graham Brady uk.org.publicwhip/member/40041 | Graham Brady uk.org.publicwhip/person/10062 | 6 | 2012-04-16-80ef1083-10062-0 |
050b172a7b4bd55201ac97bb7ae0bb35e5b9cadf | Name of donor: Cayman Islands Government | Overseas visits 80ef1083 | 2012-04-16 | Graham Brady uk.org.publicwhip/member/40041 | Graham Brady uk.org.publicwhip/person/10062 | 7 | 2012-04-16-80ef1083-10062-0 |
26eabc0ff1cfe4729d74009ed2ca1822597e4c1b | Address of donor: Government Administration Building, Grand Cayman, Cayman Islands | Overseas visits 80ef1083 | 2012-04-16 | Graham Brady uk.org.publicwhip/member/40041 | Graham Brady uk.org.publicwhip/person/10062 | 8 | 2012-04-16-80ef1083-10062-0 |
003a21f53e100e7676f2e5df1a5372687dd5bd23 | Amount of donation (or estimate of the probable value): £8,600 | Overseas visits 80ef1083 | 2012-04-16 | Graham Brady uk.org.publicwhip/member/40041 | Graham Brady uk.org.publicwhip/person/10062 | 9 | 2012-04-16-80ef1083-10062-0 |
7063a555b5e5b20c04cd851072d3a828482d6504 | Destination of visit: Grand Cayman | Overseas visits 80ef1083 | 2012-04-16 | Graham Brady uk.org.publicwhip/member/40041 | Graham Brady uk.org.publicwhip/person/10062 | 10 | 2012-04-16-80ef1083-10062-0 |
721686e97b9a835b9712471b9a7c76b0dc544912 | Date of visit: 30 March to 6 April 2012 | Overseas visits 80ef1083 | 2012-04-16 | Graham Brady uk.org.publicwhip/member/40041 | Graham Brady uk.org.publicwhip/person/10062 | 11 | 2012-04-16-80ef1083-10062-0 |
916404328eb4ea6920e0522072ff3e245dbe6623 | 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-04-16 | Graham Brady uk.org.publicwhip/member/40041 | Graham Brady uk.org.publicwhip/person/10062 | 12 | 2012-04-16-80ef1083-10062-0 |
22f2ce0ff5d8d0f316f191ce213184944835dfaf | (Registered 16 April 2012) | Overseas visits 80ef1083 | 2012-04-16 | Graham Brady uk.org.publicwhip/member/40041 | Graham Brady uk.org.publicwhip/person/10062 | 13 | 2012-04-16-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");