items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
30 rows where record_id = "2013-09-09-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 |
---|---|---|---|---|---|---|---|
ff937be0befc372c81bcec6b6ef2411cb72311d5 | Name of donor: | Overseas visits 80ef1083 | 2013-09-09 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 0 | 2013-09-09-80ef1083-11362-0 |
b70befdff970ebcd08741f4de4879516b2993eb3 | 16) Barclays Plc | Overseas visits 80ef1083 | 2013-09-09 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 1 | 2013-09-09-80ef1083-11362-0 |
3dd0c1efe5f54e8f647accbed80b5cdffc358dfe | 17) Prudential Plc | Overseas visits 80ef1083 | 2013-09-09 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 2 | 2013-09-09-80ef1083-11362-0 |
bee69e6f5135818938a452b6f16cc46247efe365 | 18) UK-ASEAN Business Council | Overseas visits 80ef1083 | 2013-09-09 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 3 | 2013-09-09-80ef1083-11362-0 |
18357ceb946bfdf08656a39d0019ed6ef34c5559 | Address of donor: | Overseas visits 80ef1083 | 2013-09-09 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 4 | 2013-09-09-80ef1083-11362-0 |
0863380f17cd1a6353cf5f606b48d22656cd7eda | 16) 1 Churchill Place, London E14 5HP | Overseas visits 80ef1083 | 2013-09-09 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 5 | 2013-09-09-80ef1083-11362-0 |
12845869b5df207e6e27e59d370474731192a005 | 17) Laurence Pountney Hill, London EC4R 0HH | Overseas visits 80ef1083 | 2013-09-09 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 6 | 2013-09-09-80ef1083-11362-0 |
3693d5529dd307eb204bde43c2520bb618d7daad | 18) 1 Victoria Street, London SW1H 0ET | Overseas visits 80ef1083 | 2013-09-09 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 7 | 2013-09-09-80ef1083-11362-0 |
f8773f8a669ba3005e6aad65c472fef7c6f45bfc | Amount of donation (or estimate of the probable value): | Overseas visits 80ef1083 | 2013-09-09 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 8 | 2013-09-09-80ef1083-11362-0 |
2e1214350fd040be861cab4a12ab8902431351a9 | 16) £3,048.32 towards travel and accommodation | Overseas visits 80ef1083 | 2013-09-09 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 9 | 2013-09-09-80ef1083-11362-0 |
95c29b47d790cc6d875e18ae3aacdfbd1df90865 | 17) £3,048.32 towards travel and accommodation | Overseas visits 80ef1083 | 2013-09-09 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 10 | 2013-09-09-80ef1083-11362-0 |
6a2a4aa49121a1972686504611efcba67d78e468 | 18) £304.84 towards travel and accommodation | Overseas visits 80ef1083 | 2013-09-09 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 11 | 2013-09-09-80ef1083-11362-0 |
d325b303b265331982877ec63421944bbfaa272a | Destination of visit: Singapore and Indonesia | Overseas visits 80ef1083 | 2013-09-09 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 12 | 2013-09-09-80ef1083-11362-0 |
a0f3b59f3fbdfdcf47d98b6cfe18e26da37e7cc1 | Date of visit: 9-15 March 2013 | Overseas visits 80ef1083 | 2013-09-09 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 13 | 2013-09-09-80ef1083-11362-0 |
e39ac80ada220e7c43c4838a751a0186c51ca3d2 | 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 | 2013-09-09 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 14 | 2013-09-09-80ef1083-11362-0 |
3f44b65e27b778da89167abcbe69eaf378f21a93 | (Registered 15 April 2013) | Overseas visits 80ef1083 | 2013-09-09 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 15 | 2013-09-09-80ef1083-11362-0 |
30262ce8af5237b1141589d201a2e2b7d595804c | Name of donor: Embassy of Japan in the UK | Overseas visits 80ef1083 | 2013-09-09 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 16 | 2013-09-09-80ef1083-11362-0 |
94170c7754e1c65b9f83d8c44ac8a14f2767903f | Address of donor: 101-104 Piccadilly, London W1J 7JT | Overseas visits 80ef1083 | 2013-09-09 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 17 | 2013-09-09-80ef1083-11362-0 |
8bd58e8e45b544e826cec660f58ed229c38848ad | 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 | 2013-09-09 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 18 | 2013-09-09-80ef1083-11362-0 |
f2797193ff16040fe81715b7a8c509b59813b005 | Destination of visit: Japan (Tokyo, Nagoya and Kyoto) | Overseas visits 80ef1083 | 2013-09-09 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 19 | 2013-09-09-80ef1083-11362-0 |
5cfca8df071dd38ee31125e3b435e1716d4667c1 | Date of visit: 26-31 March 2013 | Overseas visits 80ef1083 | 2013-09-09 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 20 | 2013-09-09-80ef1083-11362-0 |
53ceb62094992713edf8f36d54014403a6e569e2 | 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 | 2013-09-09 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 21 | 2013-09-09-80ef1083-11362-0 |
95daedd4951f31572afce72e654b1a362e4a05c8 | (Registered 24 April 2013) | Overseas visits 80ef1083 | 2013-09-09 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 22 | 2013-09-09-80ef1083-11362-0 |
775e3f280304c82b2d521f56b631023485e98ab1 | Name of donor: Inmarsat | Overseas visits 80ef1083 | 2013-09-09 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 23 | 2013-09-09-80ef1083-11362-0 |
1da507c3c2941a7941ac3a751e4d1d6648c6fd5f | Address of donor: 99 City Road, London EC1Y 1AX | Overseas visits 80ef1083 | 2013-09-09 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 24 | 2013-09-09-80ef1083-11362-0 |
084ccb31c1f4ef3fd8cff9c323bfccd54f76e5eb | Amount of donation (or estimate of the probable value): Flights, £5,693 (including tax); accommodation, £362; total £6,055 | Overseas visits 80ef1083 | 2013-09-09 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 25 | 2013-09-09-80ef1083-11362-0 |
a0dadfd89ad7e43d85c2a128dca811f30632cb4c | Destination of visit: Cayenne, French Guiana | Overseas visits 80ef1083 | 2013-09-09 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 26 | 2013-09-09-80ef1083-11362-0 |
8b7ee7c7c8979ef85993133e8b401a16393ae8c6 | Date of visit: 24-26 July 2013 | Overseas visits 80ef1083 | 2013-09-09 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 27 | 2013-09-09-80ef1083-11362-0 |
2acc87b13c311132af87683a9975bdedd320ed6e | Purpose of visit: to view launch of Alphasat satellite in capacity as Shadow Minister for Competitiveness and Enterprise. | Overseas visits 80ef1083 | 2013-09-09 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 28 | 2013-09-09-80ef1083-11362-0 |
24b1d7ec5f72ec5eb0b84867322b053d545a3483 | (Registered 20 August 2013) | Overseas visits 80ef1083 | 2013-09-09 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 29 | 2013-09-09-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");