items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
28 rows where record_id = "2013-06-24-80ef1083-10632-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 |
---|---|---|---|---|---|---|---|
1cda7e522c56c714083a058233aa8ed7a843c821 | Name of donor: British Ukrainian Society | Overseas visits 80ef1083 | 2013-06-24 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 0 | 2013-06-24-80ef1083-10632-0 |
715e267a34c7dd80f5a8297c60424b0e88471757 | Address of donor: 1st Floor, 25 Knightsbridge, London SW1X 7RZ | Overseas visits 80ef1083 | 2013-06-24 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 1 | 2013-06-24-80ef1083-10632-0 |
baebdf246e3be910217ca9587c55d7972b6874ff | Amount of donation (or estimate of the probable value): Flights £1,700; accommodation £820 | Overseas visits 80ef1083 | 2013-06-24 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 2 | 2013-06-24-80ef1083-10632-0 |
73ea360ac150612d2941a3cde67be90e11dc41d0 | Destination of visit: Yalta, Ukraine | Overseas visits 80ef1083 | 2013-06-24 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 3 | 2013-06-24-80ef1083-10632-0 |
97ce0e24bb51a4ef8fe21cdeff3af51b48a3ae8f | Date of visit: 13-16 September 2012 | Overseas visits 80ef1083 | 2013-06-24 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 4 | 2013-06-24-80ef1083-10632-0 |
bc083b8f8471cbc72be50f13c064ef23ed9a5f0c | Purpose of visit: to attend the Yalta European Strategy Conference in my capacity as Chairman of the British Ukraine All-Party Parliamentary Group | Overseas visits 80ef1083 | 2013-06-24 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 5 | 2013-06-24-80ef1083-10632-0 |
6d07aa854254a86f82fadc1d4e9cce95f910f67c | (Registered 30 September 2012) | Overseas visits 80ef1083 | 2013-06-24 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 6 | 2013-06-24-80ef1083-10632-0 |
bf3e37456be73d6c23fb13b6feb58417e7b40380 | Name of donor: Government of Republic of China (Taiwan) | Overseas visits 80ef1083 | 2013-06-24 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 7 | 2013-06-24-80ef1083-10632-0 |
ab0959161f95ad31871529870eabc787f5ede193 | Address of donor: Taipei Representative Office in the UK, 50 Grosvenor Gardens, London SW1 | Overseas visits 80ef1083 | 2013-06-24 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 8 | 2013-06-24-80ef1083-10632-0 |
7b7602746982a58bb8d4cae6648cd47b45205841 | Amount of donation (or estimate of the probable value): flights, £2,295; food and accommodation £1,020; total £3,315 | Overseas visits 80ef1083 | 2013-06-24 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 9 | 2013-06-24-80ef1083-10632-0 |
e91b51895fc1d89d1e6fbecfed4e4668c995d011 | Destination of visit: Taiwan | Overseas visits 80ef1083 | 2013-06-24 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 10 | 2013-06-24-80ef1083-10632-0 |
eb4952ed2e68085890b59aae033ae1bf26f1e58a | Date of visit: 23-29 September 2012 | Overseas visits 80ef1083 | 2013-06-24 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 11 | 2013-06-24-80ef1083-10632-0 |
5cb522c25dc8cc2c4c34790014402a8e7aa5f4d6 | Purpose of visit: to meet the President and senior Members of the Government and Opposition to discuss issues affecting Taiwan and the UK | Overseas visits 80ef1083 | 2013-06-24 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 12 | 2013-06-24-80ef1083-10632-0 |
ff81b5b9d06401d24d76f276561f4432b43390b6 | (Registered 24 October 2012) | Overseas visits 80ef1083 | 2013-06-24 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 13 | 2013-06-24-80ef1083-10632-0 |
b265eb191ba442d8dd84720dce67d38e2693cd07 | Name of donor: European Friends of Armenia | Overseas visits 80ef1083 | 2013-06-24 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 14 | 2013-06-24-80ef1083-10632-0 |
8ce4805d5dabbfabf6f70abc81f0d4763801242d | Address of donor: Rue de Treves 49, 1040 Brussels-Etterbeck | Overseas visits 80ef1083 | 2013-06-24 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 15 | 2013-06-24-80ef1083-10632-0 |
af19dc39da19bc7e3287708ce062d784e7918804 | Amount of donation (or estimate of the probable value): Flights: £425; Accommodation: £380; | Overseas visits 80ef1083 | 2013-06-24 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 16 | 2013-06-24-80ef1083-10632-0 |
0669b83006ed819f7ce801a68df8b02465a2908b | Destination of visit: Yerevan, Armenia | Overseas visits 80ef1083 | 2013-06-24 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 17 | 2013-06-24-80ef1083-10632-0 |
cf1d28992ba2d2f3ac524cb6200a1f65c9120f6c | Date of visit: 16-20 February 2013 | Overseas visits 80ef1083 | 2013-06-24 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 18 | 2013-06-24-80ef1083-10632-0 |
f8a056839a0ed0c2646370daf35e8d49c223fae9 | Purpose of visit: to attend meeting of Europe-Armenia Advisory Council and to observe Armenian Presidential elections | Overseas visits 80ef1083 | 2013-06-24 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 19 | 2013-06-24-80ef1083-10632-0 |
65896e927d8b6d058c531737fbb2d75bb393a0b4 | (Registered 14 March 2013) | Overseas visits 80ef1083 | 2013-06-24 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 20 | 2013-06-24-80ef1083-10632-0 |
278ad19b60c1a2642fcd514973ddfcbb2400edb5 | Name of donor: PACT (Producers Alliance for Cinema and Television) | Overseas visits 80ef1083 | 2013-06-24 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 21 | 2013-06-24-80ef1083-10632-0 |
4c5f94907fc2dd8d805d76beb673d73f88c27724 | Address of donor: 3rd Floor, Fitzrovia House, 153-157 Cleveland Street, London W1T 6QW | Overseas visits 80ef1083 | 2013-06-24 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 22 | 2013-06-24-80ef1083-10632-0 |
2053325ec971d04d0be84a0fb0224369ed56ab84 | Amount of donation (or estimate of the probable value): flights: £108; accommodation: £700 | Overseas visits 80ef1083 | 2013-06-24 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 23 | 2013-06-24-80ef1083-10632-0 |
30696119154a931a8fd2623dd2cab87de77bbc39 | Destination of visit: Cannes, France | Overseas visits 80ef1083 | 2013-06-24 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 24 | 2013-06-24-80ef1083-10632-0 |
f98c848d21b374f92bbac721fb95c7f004ae5596 | Date of visit: 7-9 April 2013 | Overseas visits 80ef1083 | 2013-06-24 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 25 | 2013-06-24-80ef1083-10632-0 |
c763293410103ca87a461dd65079b6f74fc2a10c | Purpose of visit: to attend the MIP TV international television market and to meet British TV production firms represented there. | Overseas visits 80ef1083 | 2013-06-24 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 26 | 2013-06-24-80ef1083-10632-0 |
84af44d0a293e45680a701acc5eb6e5ec71f64ca | (Registered 2 June 2013) | Overseas visits 80ef1083 | 2013-06-24 | John Whittingdale uk.org.publicwhip/member/40385 | John Whittingdale uk.org.publicwhip/person/10632 | 27 | 2013-06-24-80ef1083-10632-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");