items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
30 rows where record_id = "2014-02-24-80ef1083-11362-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 |
---|---|---|---|---|---|---|---|
3791524e7334136bc22e6a6eeef91d723bb2ae2c | Name of donor: | Overseas visits 80ef1083 | 2014-02-24 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 0 | 2014-02-24-80ef1083-11362-0 |
b362f3a35aa18fd6af8611d94c49dd6ee00ebdac | 16) Barclays Plc | Overseas visits 80ef1083 | 2014-02-24 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 1 | 2014-02-24-80ef1083-11362-0 |
c70dc2e6cb53aa044c535946a65da403829505c8 | 17) Prudential Plc | Overseas visits 80ef1083 | 2014-02-24 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 2 | 2014-02-24-80ef1083-11362-0 |
a7be3b3a60f8fef905cb1769b5dc880140604c87 | 18) UK-ASEAN Business Council | Overseas visits 80ef1083 | 2014-02-24 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 3 | 2014-02-24-80ef1083-11362-0 |
e7db219b4051d9c323afbfcf112ffbfba2aec236 | Address of donor: | Overseas visits 80ef1083 | 2014-02-24 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 4 | 2014-02-24-80ef1083-11362-0 |
e035b59cff313154be17edbfba9a7d58b7d2a987 | 16) 1 Churchill Place, London E14 5HP | Overseas visits 80ef1083 | 2014-02-24 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 5 | 2014-02-24-80ef1083-11362-0 |
f0f16d8b72b349cdfcc3875bfd062296804b8e36 | 17) Laurence Pountney Hill, London EC4R 0HH | Overseas visits 80ef1083 | 2014-02-24 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 6 | 2014-02-24-80ef1083-11362-0 |
338b9d486d0dd417a6fa89df870a5e388878f62b | 18) 1 Victoria Street, London SW1H 0ET | Overseas visits 80ef1083 | 2014-02-24 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 7 | 2014-02-24-80ef1083-11362-0 |
5e9c448e6e91326e3815e84d53e6b18377facfd1 | Amount of donation (or estimate of the probable value): | Overseas visits 80ef1083 | 2014-02-24 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 8 | 2014-02-24-80ef1083-11362-0 |
bbc2bfaaea9ce093a728ea08c6bc1ffa9d12ddc9 | 16) £3,048.32 towards travel and accommodation | Overseas visits 80ef1083 | 2014-02-24 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 9 | 2014-02-24-80ef1083-11362-0 |
98d28f834273536eba1fbdad80cabd27fe9f1bf4 | 17) £3,048.32 towards travel and accommodation | Overseas visits 80ef1083 | 2014-02-24 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 10 | 2014-02-24-80ef1083-11362-0 |
1328ebe85a7fc19b436c9ea79712d6c2aaec2f8d | 18) £304.84 towards travel and accommodation | Overseas visits 80ef1083 | 2014-02-24 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 11 | 2014-02-24-80ef1083-11362-0 |
c920678415d090b658664d8bed10f094acd5a7ee | Destination of visit: Singapore and Indonesia | Overseas visits 80ef1083 | 2014-02-24 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 12 | 2014-02-24-80ef1083-11362-0 |
d083d62ffc135ee0fc79d9ffb704486140d26a04 | Date of visit: 9-15 March 2013 | Overseas visits 80ef1083 | 2014-02-24 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 13 | 2014-02-24-80ef1083-11362-0 |
c9fa8ad4c3d00628526b608279e621f8b20eab45 | Purpose of visit: All-Party Parliamentary Group for Trade and Investment visit to Singapore and Indonesia to promote trade and specifically British exports in the education, infrastructure and architecture sectors. | Overseas visits 80ef1083 | 2014-02-24 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 14 | 2014-02-24-80ef1083-11362-0 |
49571a700b962cfb9c79ef73a3f6488c2539e786 | (Registered 15 April 2013) | Overseas visits 80ef1083 | 2014-02-24 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 15 | 2014-02-24-80ef1083-11362-0 |
cc6dc65c688c88b673249b4379e9f7c5a16d5391 | Name of donor: Embassy of Japan in the UK | Overseas visits 80ef1083 | 2014-02-24 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 16 | 2014-02-24-80ef1083-11362-0 |
00c3d8fd7c2a71c1f9faae3947f5974eb98bcf30 | Address of donor: 101-104 Piccadilly, London W1J 7JT | Overseas visits 80ef1083 | 2014-02-24 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 17 | 2014-02-24-80ef1083-11362-0 |
8c44dcb9fe6aa63c7efdc01ee9bdc363a5fbb8bc | Amount of donation (or estimate of the probable value): flights, £3,302 (including tax); accommodation in Tokyo and Okura, £1,095; train fares, £223 | Overseas visits 80ef1083 | 2014-02-24 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 18 | 2014-02-24-80ef1083-11362-0 |
4d27890afb377e3f2760373abb6be47bc00a92f2 | Destination of visit: Japan (Tokyo, Nagoya and Kyoto) | Overseas visits 80ef1083 | 2014-02-24 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 19 | 2014-02-24-80ef1083-11362-0 |
51c55d5b3fadc5d06924e35bbe1b8f7afb5c4058 | Date of visit: 26-31 March 2013 | Overseas visits 80ef1083 | 2014-02-24 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 20 | 2014-02-24-80ef1083-11362-0 |
ccc8905e6eb822fa46747c75c53d3d82a1f43d5d | Purpose of visit: to meet senior figures in the new government, private sector and academia in capacity as Shadow Minister for Competitiveness and Enterprise. | Overseas visits 80ef1083 | 2014-02-24 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 21 | 2014-02-24-80ef1083-11362-0 |
f5f5c443d6361f01829311967610bc2e3afd9c87 | (Registered 24 April 2013) | Overseas visits 80ef1083 | 2014-02-24 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 22 | 2014-02-24-80ef1083-11362-0 |
fda1543cb1ea1dd0984dd07d5f1f8fa864e2a4bf | Name of donor: Inmarsat | Overseas visits 80ef1083 | 2014-02-24 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 23 | 2014-02-24-80ef1083-11362-0 |
118a795f70d26e3bbcd1b7527dfecd33b34bfe2a | Address of donor: 99 City Road, London EC1Y 1AX | Overseas visits 80ef1083 | 2014-02-24 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 24 | 2014-02-24-80ef1083-11362-0 |
0c0b1baf3737e9cab5bf0642975ce053ab36f704 | Amount of donation (or estimate of the probable value): Flights, £5,693 (including tax); accommodation, £362; total £6,055 | Overseas visits 80ef1083 | 2014-02-24 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 25 | 2014-02-24-80ef1083-11362-0 |
f54654ac40b0225ab96d526268135e99b3d11a2c | Destination of visit: Cayenne, French Guiana | Overseas visits 80ef1083 | 2014-02-24 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 26 | 2014-02-24-80ef1083-11362-0 |
1b82f71c766707e8f2af171a720d074ed146ff72 | Date of visit: 24-26 July 2013 | Overseas visits 80ef1083 | 2014-02-24 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 27 | 2014-02-24-80ef1083-11362-0 |
7179573bc89ed7a4c911961b2a57cae2b11ddb70 | Purpose of visit: to view launch of Alphasat satellite in capacity as Shadow Minister for Competitiveness and Enterprise. | Overseas visits 80ef1083 | 2014-02-24 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 28 | 2014-02-24-80ef1083-11362-0 |
30fa4e754faa703bc96420b8e0a7a6c3c1056a11 | (Registered 20 August 2013) | Overseas visits 80ef1083 | 2014-02-24 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 29 | 2014-02-24-80ef1083-11362-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");