items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
21 rows where record_id = "2013-04-08-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 |
---|---|---|---|---|---|---|---|
54bd7b0e50af8c3e5dd95a921566dc47fedcbe20 | Name of donor: Government of the United Arab Emirates | Overseas visits 80ef1083 | 2013-04-08 | Mark Lancaster uk.org.publicwhip/member/40403 | Mark Lancaster uk.org.publicwhip/person/11715 | 0 | 2013-04-08-80ef1083-11715-0 |
fc8b7e8209201c7194c150eb62512c201fa3420f | Address of donor: PO Box 31966, Abu Dhabi, United Arab Emirates | Overseas visits 80ef1083 | 2013-04-08 | Mark Lancaster uk.org.publicwhip/member/40403 | Mark Lancaster uk.org.publicwhip/person/11715 | 1 | 2013-04-08-80ef1083-11715-0 |
64a9341e20d44b22b0c7551fe3bcedeb3bebb9ec | Amount of donation (or estimate of the probable value): cost of travel and accommodation; £3,500 | Overseas visits 80ef1083 | 2013-04-08 | Mark Lancaster uk.org.publicwhip/member/40403 | Mark Lancaster uk.org.publicwhip/person/11715 | 2 | 2013-04-08-80ef1083-11715-0 |
57bbbbbd3f5d6e3d2c414d97730300281e8b6a18 | Destination of visit: United Arab Emirates | Overseas visits 80ef1083 | 2013-04-08 | Mark Lancaster uk.org.publicwhip/member/40403 | Mark Lancaster uk.org.publicwhip/person/11715 | 3 | 2013-04-08-80ef1083-11715-0 |
b545945e973e102b8a47d1ba3136595be5a571e7 | Date of visit: 30 March-4 April 2012 | Overseas visits 80ef1083 | 2013-04-08 | Mark Lancaster uk.org.publicwhip/member/40403 | Mark Lancaster uk.org.publicwhip/person/11715 | 4 | 2013-04-08-80ef1083-11715-0 |
366f8e1a14fdc47d6fecc10f7203fe304bd419a1 | 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 | 2013-04-08 | Mark Lancaster uk.org.publicwhip/member/40403 | Mark Lancaster uk.org.publicwhip/person/11715 | 5 | 2013-04-08-80ef1083-11715-0 |
a12fe2e8c8c3570ddddbf81808f5b19000ee7216 | (Registered 22 April 2012) | Overseas visits 80ef1083 | 2013-04-08 | Mark Lancaster uk.org.publicwhip/member/40403 | Mark Lancaster uk.org.publicwhip/person/11715 | 6 | 2013-04-08-80ef1083-11715-0 |
9b696131d391b0295a6a2dbe3901740addf2389a | Name of donor: The Global Legislators Organisation (GLOBE) and World Summit of Legislators | Overseas visits 80ef1083 | 2013-04-08 | Mark Lancaster uk.org.publicwhip/member/40403 | Mark Lancaster uk.org.publicwhip/person/11715 | 7 | 2013-04-08-80ef1083-11715-0 |
6ce35edf16767a5638cbd08401323cdf24896c90 | Address of donor: 11 Dartmouth Street, London SW1H 9BN | Overseas visits 80ef1083 | 2013-04-08 | Mark Lancaster uk.org.publicwhip/member/40403 | Mark Lancaster uk.org.publicwhip/person/11715 | 8 | 2013-04-08-80ef1083-11715-0 |
0c98bd95877419675ed6fae59569bc5e33e94d75 | Amount of donation (or estimate of the probable value): cost of travel and accommodation; £3,900 | Overseas visits 80ef1083 | 2013-04-08 | Mark Lancaster uk.org.publicwhip/member/40403 | Mark Lancaster uk.org.publicwhip/person/11715 | 9 | 2013-04-08-80ef1083-11715-0 |
b423c140b217aaa337992f2aea002883b7d3cf15 | Destination of visit: Rio de Janeiro, Brazil | Overseas visits 80ef1083 | 2013-04-08 | Mark Lancaster uk.org.publicwhip/member/40403 | Mark Lancaster uk.org.publicwhip/person/11715 | 10 | 2013-04-08-80ef1083-11715-0 |
4a855ac70f0f3925bbf1032630b2768ea93ee41f | Date of visit: 14-18 June 2012 | Overseas visits 80ef1083 | 2013-04-08 | Mark Lancaster uk.org.publicwhip/member/40403 | Mark Lancaster uk.org.publicwhip/person/11715 | 11 | 2013-04-08-80ef1083-11715-0 |
c76924c00ae6d761e311b19a1fd1bff6ecec0923 | 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 | 2013-04-08 | Mark Lancaster uk.org.publicwhip/member/40403 | Mark Lancaster uk.org.publicwhip/person/11715 | 12 | 2013-04-08-80ef1083-11715-0 |
a8cfedd909fe00fa42ede43abe9fece838d127a6 | (Registered 3 July 2012) | Overseas visits 80ef1083 | 2013-04-08 | Mark Lancaster uk.org.publicwhip/member/40403 | Mark Lancaster uk.org.publicwhip/person/11715 | 13 | 2013-04-08-80ef1083-11715-0 |
08a376997e4d15e373393a60a784b539e9743ad5 | Name of donor: Falkland Islands Government | Overseas visits 80ef1083 | 2013-04-08 | Mark Lancaster uk.org.publicwhip/member/40403 | Mark Lancaster uk.org.publicwhip/person/11715 | 14 | 2013-04-08-80ef1083-11715-0 |
30e099450c40822714005e9cde778a6472a4a5ce | Address of donor: The Secretariat, Falkland Islands Government, Stanley, Falkland Islands | Overseas visits 80ef1083 | 2013-04-08 | Mark Lancaster uk.org.publicwhip/member/40403 | Mark Lancaster uk.org.publicwhip/person/11715 | 15 | 2013-04-08-80ef1083-11715-0 |
ff42b8218ed4d8d8d14fb1937ff63f331633b2a3 | Amount of donation (or estimate of the probable value): Flights and accommodation with a value of £3,666.35 | Overseas visits 80ef1083 | 2013-04-08 | Mark Lancaster uk.org.publicwhip/member/40403 | Mark Lancaster uk.org.publicwhip/person/11715 | 16 | 2013-04-08-80ef1083-11715-0 |
5b129548d610bedd6b810ff0590ee87a5394f4c9 | Destination of visit: Falkland Islands | Overseas visits 80ef1083 | 2013-04-08 | Mark Lancaster uk.org.publicwhip/member/40403 | Mark Lancaster uk.org.publicwhip/person/11715 | 17 | 2013-04-08-80ef1083-11715-0 |
896ed63f1e989fa5a9574a9f1fec981370185ff6 | Date of visit: 7-14 November 2012 | Overseas visits 80ef1083 | 2013-04-08 | Mark Lancaster uk.org.publicwhip/member/40403 | Mark Lancaster uk.org.publicwhip/person/11715 | 18 | 2013-04-08-80ef1083-11715-0 |
d3adc5445e1648984a589b2e075a09efa26e61a6 | Purpose of visit: visit at the invitation of the Falkland Islands Government to represent the Conservative Party at Remembrance Sunday. | Overseas visits 80ef1083 | 2013-04-08 | Mark Lancaster uk.org.publicwhip/member/40403 | Mark Lancaster uk.org.publicwhip/person/11715 | 19 | 2013-04-08-80ef1083-11715-0 |
25bf9366abb0d802812521292eed724d9d388ae0 | (Registered 10 December 2012) | Overseas visits 80ef1083 | 2013-04-08 | Mark Lancaster uk.org.publicwhip/member/40403 | Mark Lancaster uk.org.publicwhip/person/11715 | 20 | 2013-04-08-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");