items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
21 rows where record_id = "2014-09-22-80ef1083-10009-0" sorted by date descending
This data as json, CSV (advanced)
Suggested facets: date (date)
hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
550128af04b07e1b98484db90e20e95715034ad9 | Name of donor: Ministry of Foreign Affairs (Saudi Arabia) | Overseas visits 80ef1083 | 2014-09-22 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 0 | 2014-09-22-80ef1083-10009-0 |
4119cf42129db9e0813bbcb30a0ec42462dd7430 | Address of donor: c/o Royal Embassy of Saudi Arabia, 30-32 Charles St, London W1J 5DZ | Overseas visits 80ef1083 | 2014-09-22 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 1 | 2014-09-22-80ef1083-10009-0 |
59fada22598a52ba28db1d1b4c0f5ca0e5a3b989 | Amount of donation (or estimate of the probable value): £5,292 | Overseas visits 80ef1083 | 2014-09-22 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 2 | 2014-09-22-80ef1083-10009-0 |
942b7268d27bcb8383ce33b0ebe5499433a6edc8 | Destination of visit: Riyadh, Saudi Arabia | Overseas visits 80ef1083 | 2014-09-22 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 3 | 2014-09-22-80ef1083-10009-0 |
3a411a7b9fca357e68eeb729f1353e12477fde22 | Date of visit: 16-20 February 2014 | Overseas visits 80ef1083 | 2014-09-22 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 4 | 2014-09-22-80ef1083-10009-0 |
2645ec9f5a8093030cf9b5d7b71d13ab88edb2a2 | Purpose of visit: all party parliamentary delegation at the invitation of the Shura Council, to meet the Deputy Speaker , Foreign Affairs Committee, Second Deputy Premier, government ministers and Governor of the Saudi Arabia Monetary Authority. Also to visit King Saud University to discuss collaboration with UK universities on de-radicalisation. | Overseas visits 80ef1083 | 2014-09-22 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 5 | 2014-09-22-80ef1083-10009-0 |
5f69b8a79c0897b6b5921e67222868561b9a31b2 | (Registered 12 March 2014) | Overseas visits 80ef1083 | 2014-09-22 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 6 | 2014-09-22-80ef1083-10009-0 |
84925e89962aa91a787d3736923a3d63d6983f57 | Name of donor: The European Azerbaijan Society | Overseas visits 80ef1083 | 2014-09-22 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 7 | 2014-09-22-80ef1083-10009-0 |
2a28dcc88384e17c2910116c4e5066ad7808cb91 | Address of donor (the address of individuals will not be published): 15 Queen Anne’s Gate, London SW1H 9BU | Overseas visits 80ef1083 | 2014-09-22 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 8 | 2014-09-22-80ef1083-10009-0 |
4397c7d6e09d32481049fa7b37e0f20822d8d196 | Amount of donation (or estimate of the probable value): £1,943 for flights and £600 for 5 nights at a hotel; total £2,543 | Overseas visits 80ef1083 | 2014-09-22 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 9 | 2014-09-22-80ef1083-10009-0 |
e3b89e165765f621adafe7b13a88348df35ae358 | Destination of visit: Baku, Shaki and Gabala, Azerbaijan | Overseas visits 80ef1083 | 2014-09-22 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 10 | 2014-09-22-80ef1083-10009-0 |
bc6dba29cbfabdee1a6f3dd31c577a8d91ccc474 | Date of visit: 26 May – 31 May 2014 | Overseas visits 80ef1083 | 2014-09-22 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 11 | 2014-09-22-80ef1083-10009-0 |
38b95000d1d1c276ae6cab326d2945445161e421 | Purpose of visit: to meet with political and parliamentary figures including the President of the Republic, ministers, the British Ambassador, local public service centres, representatives of international organisations, human rights groups and IDP/Refugee camp of displaced people from the conflict in Nagorno-Karabakh | Overseas visits 80ef1083 | 2014-09-22 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 12 | 2014-09-22-80ef1083-10009-0 |
e665edad78ea03ced5dc9d4f4549e4d7a08579ca | (Registered 13 June 2014) | Overseas visits 80ef1083 | 2014-09-22 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 13 | 2014-09-22-80ef1083-10009-0 |
1f3c822b4b595f2302dd62c24ced175e6a23adaa | Name of donor: British University in Egypt | Overseas visits 80ef1083 | 2014-09-22 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 14 | 2014-09-22-80ef1083-10009-0 |
ae4b6d7e161378823cb14a757796685ab3dd5057 | Address of donor: El Sherouk City, Suez Desert Road, Cairo 11837 - P.O. Box 43 | Overseas visits 80ef1083 | 2014-09-22 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 15 | 2014-09-22-80ef1083-10009-0 |
eb6bf080c36883a03bbf554cc11ba56c8aa952ff | Amount of donation (or estimate of the probable value): £3,300 | Overseas visits 80ef1083 | 2014-09-22 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 16 | 2014-09-22-80ef1083-10009-0 |
fa07cf872f11a46d1e286c5585d0b94fe0b28533 | Destination of visit: Cairo, Egypt | Overseas visits 80ef1083 | 2014-09-22 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 17 | 2014-09-22-80ef1083-10009-0 |
37d6ad681cc964d81f0a04b22b4852c367b1112e | Date of visit: 13-16 June 2014 | Overseas visits 80ef1083 | 2014-09-22 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 18 | 2014-09-22-80ef1083-10009-0 |
9c27120ac91bdc435d3a062233fdf55f5a4154e9 | Purpose of visit: to meet the new President, government ministers, religious leaders, British Council, IPU and representatives of civil society and discuss developments in the run up to parliamentary elections. | Overseas visits 80ef1083 | 2014-09-22 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 19 | 2014-09-22-80ef1083-10009-0 |
3fb2b1b0b8c6ee4ac3bbe36a0e2de661c9fd10c4 | (Registered 10 July 2014) | Overseas visits 80ef1083 | 2014-09-22 | David Amess uk.org.publicwhip/member/40565 | Sir David Amess uk.org.publicwhip/person/10009 | 20 | 2014-09-22-80ef1083-10009-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");