items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
33 rows where record_id = "2010-03-10-80ef1083-10657-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 |
---|---|---|---|---|---|---|---|
414e9dcfa165c4f7ad5991cb44120be6a0ba1fdd | Name of donor: 1) Chinese Government | Overseas visits 80ef1083 | 2010-03-10 | Derek Wyatt uk.org.publicwhip/member/1819 | Derek Wyatt uk.org.publicwhip/person/10657 | 0 | 2010-03-10-80ef1083-10657-0 |
44199007425b7f27c54890bc1b07c633dbd2226a | 2) All-Party Parliamentary China Group | Overseas visits 80ef1083 | 2010-03-10 | Derek Wyatt uk.org.publicwhip/member/1819 | Derek Wyatt uk.org.publicwhip/person/10657 | 1 | 2010-03-10-80ef1083-10657-0 |
a733613e0770118a5edb3f264e45ec49db93f5e0 | Address of donor: 1) c/o China Embassy, 49-51 Portland Place, London | Overseas visits 80ef1083 | 2010-03-10 | Derek Wyatt uk.org.publicwhip/member/1819 | Derek Wyatt uk.org.publicwhip/person/10657 | 2 | 2010-03-10-80ef1083-10657-0 |
bf5e2679edf67a21e68d4341c62ea6392e80fa2e | 2) House of Commons | Overseas visits 80ef1083 | 2010-03-10 | Derek Wyatt uk.org.publicwhip/member/1819 | Derek Wyatt uk.org.publicwhip/person/10657 | 3 | 2010-03-10-80ef1083-10657-0 |
613fec915b120c4a7a2e9711ba4f63f619bdfd77 | Amount of donation (or estimate of the probable value): | Overseas visits 80ef1083 | 2010-03-10 | Derek Wyatt uk.org.publicwhip/member/1819 | Derek Wyatt uk.org.publicwhip/person/10657 | 4 | 2010-03-10-80ef1083-10657-0 |
696ef50b751024fa9af592c1112aff334bdfed57 | 1) hospitality; £1,166 | Overseas visits 80ef1083 | 2010-03-10 | Derek Wyatt uk.org.publicwhip/member/1819 | Derek Wyatt uk.org.publicwhip/person/10657 | 5 | 2010-03-10-80ef1083-10657-0 |
99aebea8646fc1c9a9f9776d75a6630defca5bc0 | 2) air ticket; £770 (from donations previously registered) | Overseas visits 80ef1083 | 2010-03-10 | Derek Wyatt uk.org.publicwhip/member/1819 | Derek Wyatt uk.org.publicwhip/person/10657 | 6 | 2010-03-10-80ef1083-10657-0 |
f46c1e72c4832f488f76f9a8325767f1ef1dfd63 | Destination of visit: Lhasa,Tibet | Overseas visits 80ef1083 | 2010-03-10 | Derek Wyatt uk.org.publicwhip/member/1819 | Derek Wyatt uk.org.publicwhip/person/10657 | 7 | 2010-03-10-80ef1083-10657-0 |
1b7c7c790d6b0ceff83b267ac816bce5549345f3 | Date of visit: 10-19 September 2009 | Overseas visits 80ef1083 | 2010-03-10 | Derek Wyatt uk.org.publicwhip/member/1819 | Derek Wyatt uk.org.publicwhip/person/10657 | 8 | 2010-03-10-80ef1083-10657-0 |
92900a58e97152d5536014c46b5fd782a35f3ce6 | Purpose of visit: to consider the question of Tibet | Overseas visits 80ef1083 | 2010-03-10 | Derek Wyatt uk.org.publicwhip/member/1819 | Derek Wyatt uk.org.publicwhip/person/10657 | 9 | 2010-03-10-80ef1083-10657-0 |
062f13a57426f92baff8227e2e71f6c7e8fd658b | Name of donor: Qatar Financial Centre Authority | Overseas visits 80ef1083 | 2010-03-10 | Derek Wyatt uk.org.publicwhip/member/1819 | Derek Wyatt uk.org.publicwhip/person/10657 | 10 | 2010-03-10-80ef1083-10657-0 |
04bc9f7d61c6a328f3a5f35d8641810c93614002 | Address of donor: PO Box 23245, Doha, Qatar. | Overseas visits 80ef1083 | 2010-03-10 | Derek Wyatt uk.org.publicwhip/member/1819 | Derek Wyatt uk.org.publicwhip/person/10657 | 11 | 2010-03-10-80ef1083-10657-0 |
6aaabd9388c6bdef87ff7afb8394a9609a6c2e62 | Amount of donation (or estimate of the probable value): £3208.59 | Overseas visits 80ef1083 | 2010-03-10 | Derek Wyatt uk.org.publicwhip/member/1819 | Derek Wyatt uk.org.publicwhip/person/10657 | 12 | 2010-03-10-80ef1083-10657-0 |
9d6976046fa3a6068e9f9d659817db5e373f5acf | Destination of visit: Doha, Qatar. | Overseas visits 80ef1083 | 2010-03-10 | Derek Wyatt uk.org.publicwhip/member/1819 | Derek Wyatt uk.org.publicwhip/person/10657 | 13 | 2010-03-10-80ef1083-10657-0 |
369ff3415cb8ffb288c58aa9f9b1e4e3f17cb795 | Date of visit: 29 September to 2 October 2009 | Overseas visits 80ef1083 | 2010-03-10 | Derek Wyatt uk.org.publicwhip/member/1819 | Derek Wyatt uk.org.publicwhip/person/10657 | 14 | 2010-03-10-80ef1083-10657-0 |
a00c66d779b4b0b51d2016e03a32bd5c7cd90e44 | Purpose of visit: to attend FT Rethinking the Future of Finance Conference | Overseas visits 80ef1083 | 2010-03-10 | Derek Wyatt uk.org.publicwhip/member/1819 | Derek Wyatt uk.org.publicwhip/person/10657 | 15 | 2010-03-10-80ef1083-10657-0 |
eb1b7cc8cbcafdebab9c01148bc0a81a1d326eb7 | (Registered 20 October 2009) | Overseas visits 80ef1083 | 2010-03-10 | Derek Wyatt uk.org.publicwhip/member/1819 | Derek Wyatt uk.org.publicwhip/person/10657 | 16 | 2010-03-10-80ef1083-10657-0 |
1fd7979c6cedcf0d41a3c285ad5078ffd297ada3 | Name of donor: Nominet | Overseas visits 80ef1083 | 2010-03-10 | Derek Wyatt uk.org.publicwhip/member/1819 | Derek Wyatt uk.org.publicwhip/person/10657 | 17 | 2010-03-10-80ef1083-10657-0 |
66a22636ab3d7e28e54a477e75c6e591264148e2 | Address of donor: Minerva House, Edmund Halley Road, Oxford Science Park, Oxford, OX4 4DQ. | Overseas visits 80ef1083 | 2010-03-10 | Derek Wyatt uk.org.publicwhip/member/1819 | Derek Wyatt uk.org.publicwhip/person/10657 | 18 | 2010-03-10-80ef1083-10657-0 |
be64885215cd8e42d345bfa79dd56a0242ce84e2 | Amount of donation (or estimate of the probable value): £1203: this includes travel, accommodation, food and incidental expenses. | Overseas visits 80ef1083 | 2010-03-10 | Derek Wyatt uk.org.publicwhip/member/1819 | Derek Wyatt uk.org.publicwhip/person/10657 | 19 | 2010-03-10-80ef1083-10657-0 |
18030ef36edea6e457df5737269f451b611145fa | Destination of visit: Sharm el-Sheikh, Egypt | Overseas visits 80ef1083 | 2010-03-10 | Derek Wyatt uk.org.publicwhip/member/1819 | Derek Wyatt uk.org.publicwhip/person/10657 | 20 | 2010-03-10-80ef1083-10657-0 |
d2a353bfee40b1052bd8dc61b7c8437dcb3063f3 | Date of visit: 14-19 November 2009 | Overseas visits 80ef1083 | 2010-03-10 | Derek Wyatt uk.org.publicwhip/member/1819 | Derek Wyatt uk.org.publicwhip/person/10657 | 21 | 2010-03-10-80ef1083-10657-0 |
59a746174ad2ad6a5673c041bf76472aca086b44 | Purpose of visit: to attend the United Nations Internet Governance Forum | Overseas visits 80ef1083 | 2010-03-10 | Derek Wyatt uk.org.publicwhip/member/1819 | Derek Wyatt uk.org.publicwhip/person/10657 | 22 | 2010-03-10-80ef1083-10657-0 |
471390991c867e10745c03a9d61866498a4e0a9b | Name of donor: (1) Columbia University | Overseas visits 80ef1083 | 2010-03-10 | Derek Wyatt uk.org.publicwhip/member/1819 | Derek Wyatt uk.org.publicwhip/person/10657 | 24 | 2010-03-10-80ef1083-10657-0 |
814ee983b9e76b56d0a49c8d04e4fc2c7eabb6c8 | (2) All-Party Parliamentary Group on Communications | Overseas visits 80ef1083 | 2010-03-10 | Derek Wyatt uk.org.publicwhip/member/1819 | Derek Wyatt uk.org.publicwhip/person/10657 | 25 | 2010-03-10-80ef1083-10657-0 |
9e5ba50ab2079cc39bcfd6130d68ece8917827d3 | Address of donor: (1) 2960 Broadway, New York, NY 10027-6902, USA. | Overseas visits 80ef1083 | 2010-03-10 | Derek Wyatt uk.org.publicwhip/member/1819 | Derek Wyatt uk.org.publicwhip/person/10657 | 26 | 2010-03-10-80ef1083-10657-0 |
f5524e166e8f0b25b5676eddae4ed6eb1a26cf67 | (2) House of Commons, London SW1A 0AA. | Overseas visits 80ef1083 | 2010-03-10 | Derek Wyatt uk.org.publicwhip/member/1819 | Derek Wyatt uk.org.publicwhip/person/10657 | 27 | 2010-03-10-80ef1083-10657-0 |
a0477ad7d649228f3af5723fec5f9e0858cecd11 | Amount of donation (or estimate of the probable value): (1) £605 economy ticket | Overseas visits 80ef1083 | 2010-03-10 | Derek Wyatt uk.org.publicwhip/member/1819 | Derek Wyatt uk.org.publicwhip/person/10657 | 28 | 2010-03-10-80ef1083-10657-0 |
0c0cd60171624dc84467e39ac0d7eaafae03df16 | (2) £672 (hotel and meals) | Overseas visits 80ef1083 | 2010-03-10 | Derek Wyatt uk.org.publicwhip/member/1819 | Derek Wyatt uk.org.publicwhip/person/10657 | 29 | 2010-03-10-80ef1083-10657-0 |
aa8e351d9729e12afb540b39a91534ff9fd6827b | Destination of visit: New York, USA. | Overseas visits 80ef1083 | 2010-03-10 | Derek Wyatt uk.org.publicwhip/member/1819 | Derek Wyatt uk.org.publicwhip/person/10657 | 30 | 2010-03-10-80ef1083-10657-0 |
5da2130fb691b69f9bb77c303c2ea489dc58b625 | Date of visit: 22-25 October 2009 | Overseas visits 80ef1083 | 2010-03-10 | Derek Wyatt uk.org.publicwhip/member/1819 | Derek Wyatt uk.org.publicwhip/person/10657 | 31 | 2010-03-10-80ef1083-10657-0 |
d18daf8a4dd6ee531832520432a017963e9dce0d | Purpose of visit: to speak at CITI's Annual State of Telecom Conference | Overseas visits 80ef1083 | 2010-03-10 | Derek Wyatt uk.org.publicwhip/member/1819 | Derek Wyatt uk.org.publicwhip/person/10657 | 32 | 2010-03-10-80ef1083-10657-0 |
cdbce192b09dbc68588c72acdedc16b281a04d58 | (Registered 17 December 2009) | Overseas visits 80ef1083 | 2010-03-10 | Derek Wyatt uk.org.publicwhip/member/1819 | Derek Wyatt uk.org.publicwhip/person/10657 | 33 | 2010-03-10-80ef1083-10657-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");