items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
14 rows where record_id = "2012-11-19-80ef1083-11715-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 |
---|---|---|---|---|---|---|---|
5c47515d989680e9d8e0eecd97be6896dec500af | Name of donor: Government of the United Arab Emirates | Overseas visits 80ef1083 | 2012-11-19 | Mark Lancaster uk.org.publicwhip/member/40403 | Mark Lancaster uk.org.publicwhip/person/11715 | 0 | 2012-11-19-80ef1083-11715-0 |
8bf3311cb92aeb3da1ce7fe6c45a42b30e9c2e16 | Address of donor: PO Box 31966, Abu Dhabi, United Arab Emirates | Overseas visits 80ef1083 | 2012-11-19 | Mark Lancaster uk.org.publicwhip/member/40403 | Mark Lancaster uk.org.publicwhip/person/11715 | 1 | 2012-11-19-80ef1083-11715-0 |
486a20498e95acfe20f762235ad4039ea09066b0 | Amount of donation (or estimate of the probable value): cost of travel and accommodation; £3,500 | Overseas visits 80ef1083 | 2012-11-19 | Mark Lancaster uk.org.publicwhip/member/40403 | Mark Lancaster uk.org.publicwhip/person/11715 | 2 | 2012-11-19-80ef1083-11715-0 |
567cee265cd450f6f708dfaa7a4cfddffb3f67e9 | Destination of visit: United Arab Emirates | Overseas visits 80ef1083 | 2012-11-19 | Mark Lancaster uk.org.publicwhip/member/40403 | Mark Lancaster uk.org.publicwhip/person/11715 | 3 | 2012-11-19-80ef1083-11715-0 |
cfc6c33a90438fe9be69a3baf7167b2338b67f07 | Date of visit: 30 March-4 April 2012 | Overseas visits 80ef1083 | 2012-11-19 | Mark Lancaster uk.org.publicwhip/member/40403 | Mark Lancaster uk.org.publicwhip/person/11715 | 4 | 2012-11-19-80ef1083-11715-0 |
f2ab215542795dc4046e533d41b56ce835d4a841 | Purpose of visit: to meet with Government Ministers, Members of the Federal National Council and senior business figures in order to build on the bilateral relationship and promote trade and investment ties. | Overseas visits 80ef1083 | 2012-11-19 | Mark Lancaster uk.org.publicwhip/member/40403 | Mark Lancaster uk.org.publicwhip/person/11715 | 5 | 2012-11-19-80ef1083-11715-0 |
cceb4838f0383d742c0f6dfcc203b179f6ee85d7 | (Registered 22 April 2012) | Overseas visits 80ef1083 | 2012-11-19 | Mark Lancaster uk.org.publicwhip/member/40403 | Mark Lancaster uk.org.publicwhip/person/11715 | 6 | 2012-11-19-80ef1083-11715-0 |
af921d5fd6fc797bfb8eaf8019a15a8d6cb80f1b | Name of donor: The Global Legislators Organisation (GLOBE) and World Summit of Legislators | Overseas visits 80ef1083 | 2012-11-19 | Mark Lancaster uk.org.publicwhip/member/40403 | Mark Lancaster uk.org.publicwhip/person/11715 | 7 | 2012-11-19-80ef1083-11715-0 |
1933ef03af87d12f3298c88530dfcad7af1b09a7 | Address of donor: 11 Dartmouth Street, London SW1H 9BN | Overseas visits 80ef1083 | 2012-11-19 | Mark Lancaster uk.org.publicwhip/member/40403 | Mark Lancaster uk.org.publicwhip/person/11715 | 8 | 2012-11-19-80ef1083-11715-0 |
c9971b0d59db227bd4d76d1a6e3362cb5e769f3f | Amount of donation (or estimate of the probable value): cost of travel and accommodation; £3,900 | Overseas visits 80ef1083 | 2012-11-19 | Mark Lancaster uk.org.publicwhip/member/40403 | Mark Lancaster uk.org.publicwhip/person/11715 | 9 | 2012-11-19-80ef1083-11715-0 |
09c6874fa0e1d8d5d7d88a47d17f17a8d7721c5b | Destination of visit: Rio de Janeiro, Brazil | Overseas visits 80ef1083 | 2012-11-19 | Mark Lancaster uk.org.publicwhip/member/40403 | Mark Lancaster uk.org.publicwhip/person/11715 | 10 | 2012-11-19-80ef1083-11715-0 |
7ce4a5ec3c2e269a2818ab3748ce66b15f7c73c3 | Date of visit: 14-18 June 2012 | Overseas visits 80ef1083 | 2012-11-19 | Mark Lancaster uk.org.publicwhip/member/40403 | Mark Lancaster uk.org.publicwhip/person/11715 | 11 | 2012-11-19-80ef1083-11715-0 |
05e8338023415045b76e1ccbec6751e82042a4ac | Purpose of visit: to attend the first Summit of Legislators hosted by the Senate and Congress of Brazil and GLOBE International ahead of the Rio+20 conference. | Overseas visits 80ef1083 | 2012-11-19 | Mark Lancaster uk.org.publicwhip/member/40403 | Mark Lancaster uk.org.publicwhip/person/11715 | 12 | 2012-11-19-80ef1083-11715-0 |
17afd01bfe445bc17c027856e2f14b3274784c9b | (Registered 3 July 2012) | Overseas visits 80ef1083 | 2012-11-19 | Mark Lancaster uk.org.publicwhip/member/40403 | Mark Lancaster uk.org.publicwhip/person/11715 | 13 | 2012-11-19-80ef1083-11715-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");