items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
21 rows where record_id = "2013-06-10-80ef1083-24822-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 |
---|---|---|---|---|---|---|---|
91e4987c01d452742764b51819c801cda2b28158 | Name of donor: State of Qatar | Overseas visits 80ef1083 | 2013-06-10 | Nadhim Zahawi uk.org.publicwhip/member/40587 | Nadhim Zahawi uk.org.publicwhip/person/24822 | 0 | 2013-06-10-80ef1083-24822-0 |
791969eb288163a7e451273b88d6588e546eb75e | Address of donor: Embassy of the State of Qatar, 1 South Audley Street, London W1K 1NB | Overseas visits 80ef1083 | 2013-06-10 | Nadhim Zahawi uk.org.publicwhip/member/40587 | Nadhim Zahawi uk.org.publicwhip/person/24822 | 1 | 2013-06-10-80ef1083-24822-0 |
01176debc46de4bc6954748f01407302cba7430a | Amount of donation (or estimate of the probable value): £4,000 for air travel and accommodation | Overseas visits 80ef1083 | 2013-06-10 | Nadhim Zahawi uk.org.publicwhip/member/40587 | Nadhim Zahawi uk.org.publicwhip/person/24822 | 2 | 2013-06-10-80ef1083-24822-0 |
49394ae2d1e7dd8b47b6240dde88660d68721ea3 | Destination of visit: Doha, Qatar | Overseas visits 80ef1083 | 2013-06-10 | Nadhim Zahawi uk.org.publicwhip/member/40587 | Nadhim Zahawi uk.org.publicwhip/person/24822 | 3 | 2013-06-10-80ef1083-24822-0 |
bba00ee71ddf82a998f6c7a4755889c0ec9859b6 | Date of visit: 19-22 May 2012 | Overseas visits 80ef1083 | 2013-06-10 | Nadhim Zahawi uk.org.publicwhip/member/40587 | Nadhim Zahawi uk.org.publicwhip/person/24822 | 4 | 2013-06-10-80ef1083-24822-0 |
5f6e3e2ac767e448ce464d37172076441f3dbad7 | Purpose of visit: to attend and speak at the 12th Doha Forum, Enriching the Middle East’s Economic Future Conference | Overseas visits 80ef1083 | 2013-06-10 | Nadhim Zahawi uk.org.publicwhip/member/40587 | Nadhim Zahawi uk.org.publicwhip/person/24822 | 5 | 2013-06-10-80ef1083-24822-0 |
5093c2635dc4da463102a3cb11c911b8dac85115 | (Registered 11 June 2012) | Overseas visits 80ef1083 | 2013-06-10 | Nadhim Zahawi uk.org.publicwhip/member/40587 | Nadhim Zahawi uk.org.publicwhip/person/24822 | 6 | 2013-06-10-80ef1083-24822-0 |
42726495eb1c345b04d9f9c08ccbbb523ed24354 | Name of donor: The AK Party, Justice and Development Party | Overseas visits 80ef1083 | 2013-06-10 | Nadhim Zahawi uk.org.publicwhip/member/40587 | Nadhim Zahawi uk.org.publicwhip/person/24822 | 7 | 2013-06-10-80ef1083-24822-0 |
5b52398d3cedd66cde17bdd89d39b29cb199ecbd | Address of donor: Sogutozu Caddesi No.6, Sogutozu, Ankara, Turkey | Overseas visits 80ef1083 | 2013-06-10 | Nadhim Zahawi uk.org.publicwhip/member/40587 | Nadhim Zahawi uk.org.publicwhip/person/24822 | 8 | 2013-06-10-80ef1083-24822-0 |
1af27286b72b1948cff702abce680a78263b2006 | Amount of donation (or estimate of the probable value): hotel for two nights; £218.30 and airport transfers and incidental costs; £120.55. The cost of my flights were met from a non-registrable source; value £625. | Overseas visits 80ef1083 | 2013-06-10 | Nadhim Zahawi uk.org.publicwhip/member/40587 | Nadhim Zahawi uk.org.publicwhip/person/24822 | 9 | 2013-06-10-80ef1083-24822-0 |
4802f86ce34ff6cac95fd0eb8c562f3a911d4921 | Destination of visit: Ankara, Turkey | Overseas visits 80ef1083 | 2013-06-10 | Nadhim Zahawi uk.org.publicwhip/member/40587 | Nadhim Zahawi uk.org.publicwhip/person/24822 | 10 | 2013-06-10-80ef1083-24822-0 |
a176c94f54649b1093a063508547ade260af7b54 | Date of visit: 29 September-1 October 2012 | Overseas visits 80ef1083 | 2013-06-10 | Nadhim Zahawi uk.org.publicwhip/member/40587 | Nadhim Zahawi uk.org.publicwhip/person/24822 | 11 | 2013-06-10-80ef1083-24822-0 |
8912684a42839ce123a97aa20d3a54d01a2b7445 | Purpose of visit: to attend AK Party Congress | Overseas visits 80ef1083 | 2013-06-10 | Nadhim Zahawi uk.org.publicwhip/member/40587 | Nadhim Zahawi uk.org.publicwhip/person/24822 | 12 | 2013-06-10-80ef1083-24822-0 |
4fcca6ad02158f453f46be2360f669cd57228d39 | (Registered 29 October 2012) | Overseas visits 80ef1083 | 2013-06-10 | Nadhim Zahawi uk.org.publicwhip/member/40587 | Nadhim Zahawi uk.org.publicwhip/person/24822 | 13 | 2013-06-10-80ef1083-24822-0 |
bbe6044325bdd1e1a26932c5aec42ac2a11e1989 | Name of donor: Majlis As Shura, Shura Council of the Kingdom of Saudi Arabia | Overseas visits 80ef1083 | 2013-06-10 | Nadhim Zahawi uk.org.publicwhip/member/40587 | Nadhim Zahawi uk.org.publicwhip/person/24822 | 14 | 2013-06-10-80ef1083-24822-0 |
82716b5669ae6fca61425b728fea55c182633e4e | Address of donor: c/o Embassy of Saudi Arabia, 30 Charles Street, London W1J 5DZ | Overseas visits 80ef1083 | 2013-06-10 | Nadhim Zahawi uk.org.publicwhip/member/40587 | Nadhim Zahawi uk.org.publicwhip/person/24822 | 15 | 2013-06-10-80ef1083-24822-0 |
c020af00ba5d222fcbe1ba5e9af58902f459cbfc | Amount of donation (or estimate of the probable value): flights, food, transport and accommodation; total value £5,749.19 | Overseas visits 80ef1083 | 2013-06-10 | Nadhim Zahawi uk.org.publicwhip/member/40587 | Nadhim Zahawi uk.org.publicwhip/person/24822 | 16 | 2013-06-10-80ef1083-24822-0 |
a5fd80be9fe85b0ca6d4c67232ee5259acaa249a | Destination of visit: Riyadh, Saudi Arabia | Overseas visits 80ef1083 | 2013-06-10 | Nadhim Zahawi uk.org.publicwhip/member/40587 | Nadhim Zahawi uk.org.publicwhip/person/24822 | 17 | 2013-06-10-80ef1083-24822-0 |
21472fc2028393c3d804ab366db21f98aed0dded | Date of visit: 10-14 March 2013 | Overseas visits 80ef1083 | 2013-06-10 | Nadhim Zahawi uk.org.publicwhip/member/40587 | Nadhim Zahawi uk.org.publicwhip/person/24822 | 18 | 2013-06-10-80ef1083-24822-0 |
b094b3497ede567f7efed070e3a9c8b4a82582e8 | Purpose of visit: parliamentary delegation to the Kingdom of Saudi Arabia co-ordinated by the Conservative Middle East Council. | Overseas visits 80ef1083 | 2013-06-10 | Nadhim Zahawi uk.org.publicwhip/member/40587 | Nadhim Zahawi uk.org.publicwhip/person/24822 | 19 | 2013-06-10-80ef1083-24822-0 |
190fa7878642a9cc152e56d345c583bc4bae743d | (Registered 25 March 2013) | Overseas visits 80ef1083 | 2013-06-10 | Nadhim Zahawi uk.org.publicwhip/member/40587 | Nadhim Zahawi uk.org.publicwhip/person/24822 | 20 | 2013-06-10-80ef1083-24822-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");