items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
16 rows where "date" is on date 2013-09-30 and person_id = "uk.org.publicwhip/person/11668" sorted by date descending
This data as json, CSV (advanced)
Suggested facets: category_id, sort_order, record_id, date (date)
hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
e4e4cfbec16c885f770dae059579cbe46e84c138 | From 18 February 2013, assistance with public affairs advice provided to Xcite Energy Resources Ltd (a North Sea oil exploration company), 1 Farnham Road, Guildford, GU2 4RG. The agreed remuneration is £30,000 a year and the expected time commitment is 15 hours a month. (£25,001 to £30,000) | Remunerated employment, office, profession etc 1f359ece | 2013-09-30 | Ben Wallace uk.org.publicwhip/member/40677 | Ben Wallace uk.org.publicwhip/person/11668 | 0 | 2013-09-30-1f359ece-11668-0 |
f3cffcc7e0df7237dbf74b18162a077946685a99 | Received £2,500 for attending meetings and advising on business opportunities. Hours: 15 hrs. (Registered 19 March 2013) | Remunerated employment, office, profession etc 1f359ece | 2013-09-30 | Ben Wallace uk.org.publicwhip/member/40677 | Ben Wallace uk.org.publicwhip/person/11668 | 1 | 2013-09-30-1f359ece-11668-0 |
0b78061fbbb72ca9e8e8d3093d7ef59be192e2cc | Received £2,500 for attending meetings and advising on business opportunities. Hours: 15 hrs. (Registered 17 April 2013) | Remunerated employment, office, profession etc 1f359ece | 2013-09-30 | Ben Wallace uk.org.publicwhip/member/40677 | Ben Wallace uk.org.publicwhip/person/11668 | 2 | 2013-09-30-1f359ece-11668-0 |
80d733761dd1d0dece7278890ac7b28cbb49745a | Received £2,500 for attending meetings and advising on business opportunities. Hours: 15 hrs. (Registered 15 May 2013) | Remunerated employment, office, profession etc 1f359ece | 2013-09-30 | Ben Wallace uk.org.publicwhip/member/40677 | Ben Wallace uk.org.publicwhip/person/11668 | 3 | 2013-09-30-1f359ece-11668-0 |
3d511ad12124166a7ee6058a779c907b5f753a97 | Received £2,500 for attending meetings and advising on business opportunities. Hours: 15 hrs. (July 2013) (Registered 19 August 2013) | Remunerated employment, office, profession etc 1f359ece | 2013-09-30 | Ben Wallace uk.org.publicwhip/member/40677 | Ben Wallace uk.org.publicwhip/person/11668 | 4 | 2013-09-30-1f359ece-11668-0 |
7ead79f11693ffd5fa092bbd44ee8e0c7511459f | Received £2,500 for attending meetings and advising on business opportunities. Hours: 15 hrs. (August 2013) (Registered 19 August 2013) | Remunerated employment, office, profession etc 1f359ece | 2013-09-30 | Ben Wallace uk.org.publicwhip/member/40677 | Ben Wallace uk.org.publicwhip/person/11668 | 5 | 2013-09-30-1f359ece-11668-0 |
83f1c89147f9b5a6b724721ea1cd266f55d3b035 | Received £2,500 for attending meetings and advising on business opportunities. Hours: 15 hrs. (September 2013) (Registered 2 September 2013) | Remunerated employment, office, profession etc 1f359ece | 2013-09-30 | Ben Wallace uk.org.publicwhip/member/40677 | Ben Wallace uk.org.publicwhip/person/11668 | 6 | 2013-09-30-1f359ece-11668-0 |
20eed84106a623f01cdf79427685e3d05621db6d | Name of donor: Government of the United Arab Emirates | Overseas visits 80ef1083 | 2013-09-30 | Ben Wallace uk.org.publicwhip/member/40677 | Ben Wallace uk.org.publicwhip/person/11668 | 0 | 2013-09-30-80ef1083-11668-0 |
6e7fa14e5855021d6533b7443e2e9f97f3ffac64 | Address of donor: PO Box 31966, Abu Dhabi, UAE | Overseas visits 80ef1083 | 2013-09-30 | Ben Wallace uk.org.publicwhip/member/40677 | Ben Wallace uk.org.publicwhip/person/11668 | 1 | 2013-09-30-80ef1083-11668-0 |
1ad56b2397f719f748afe0ab18d31996d9d0e733 | Amount of donation (or estimate of the probable value): Travel and accommodation with a value of £3,500 | Overseas visits 80ef1083 | 2013-09-30 | Ben Wallace uk.org.publicwhip/member/40677 | Ben Wallace uk.org.publicwhip/person/11668 | 2 | 2013-09-30-80ef1083-11668-0 |
af2ed4471ab7562b14f518279a53b19955390847 | Destination of visit: United Arab Emirates | Overseas visits 80ef1083 | 2013-09-30 | Ben Wallace uk.org.publicwhip/member/40677 | Ben Wallace uk.org.publicwhip/person/11668 | 3 | 2013-09-30-80ef1083-11668-0 |
e818a009e9abfdd34d849e2141277c3f7ec178bf | Date of visit: 23-26 March 2013 | Overseas visits 80ef1083 | 2013-09-30 | Ben Wallace uk.org.publicwhip/member/40677 | Ben Wallace uk.org.publicwhip/person/11668 | 4 | 2013-09-30-80ef1083-11668-0 |
4b2fdb7e6b14d479bb1eb358e3cafc1d993efb2e | Purpose of visit: To meet Government Ministers, Members of the Federal National Council and senior business figures together with British diplomats in order to build on the bilateral relationship and promote trade and investment ties. | Overseas visits 80ef1083 | 2013-09-30 | Ben Wallace uk.org.publicwhip/member/40677 | Ben Wallace uk.org.publicwhip/person/11668 | 5 | 2013-09-30-80ef1083-11668-0 |
f9b0c32216fe1a6d98cc4739345351fff4ab74ec | (Registered 24 April 2013) | Overseas visits 80ef1083 | 2013-09-30 | Ben Wallace uk.org.publicwhip/member/40677 | Ben Wallace uk.org.publicwhip/person/11668 | 6 | 2013-09-30-80ef1083-11668-0 |
f0aa477efbb2fa1c4d36ba5c8d6374b9f2a545a4 | Flat in south west London, from which rental income is received. | Land and Property 4f1e6359 | 2013-09-30 | Ben Wallace uk.org.publicwhip/member/40677 | Ben Wallace uk.org.publicwhip/person/11668 | 0 | 2013-09-30-4f1e6359-11668-0 |
ff01277aa224111822e12017902154eb93214446 | Member of Public Policy Committee of the RAC Foundation, 89-91 Pall Mall, London SW1Y 5HS; unremunerated. (Registered 12 June 2013) | Miscellaneous 5f2cbd10 | 2013-09-30 | Ben Wallace uk.org.publicwhip/member/40677 | Ben Wallace uk.org.publicwhip/person/11668 | 0 | 2013-09-30-5f2cbd10-11668-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");