items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
16 rows where record_id = "2013-04-22-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 |
---|---|---|---|---|---|---|---|
20c09a3aaea06b892a2394e48b642636553a3c6f | Name of donor: | Overseas visits 80ef1083 | 2013-04-22 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 0 | 2013-04-22-80ef1083-11362-0 |
190fae8f5f9bddd4111d952b506ed339b691d308 | 16) Barclays Plc | Overseas visits 80ef1083 | 2013-04-22 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 1 | 2013-04-22-80ef1083-11362-0 |
81a5e6968afd33fb603126b5b4d54c9a691177d8 | 17) Prudential Plc | Overseas visits 80ef1083 | 2013-04-22 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 2 | 2013-04-22-80ef1083-11362-0 |
4b77c0d6e2c19fb05f12336cf4765b6240e61f05 | 18) UK-ASEAN Business Council | Overseas visits 80ef1083 | 2013-04-22 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 3 | 2013-04-22-80ef1083-11362-0 |
07593f097e9a97a7ab3ac10ddc44cb289108b21e | Address of donor: | Overseas visits 80ef1083 | 2013-04-22 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 4 | 2013-04-22-80ef1083-11362-0 |
ec34b0106aca7071e4abbcf5ad5a60eb6f3a8a60 | 16) 1 Churchill Place, London E14 5HP | Overseas visits 80ef1083 | 2013-04-22 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 5 | 2013-04-22-80ef1083-11362-0 |
60947d82eec413610d7d7b772b176daaf423f241 | 17) Laurence Pountney Hill, London EC4R 0HH | Overseas visits 80ef1083 | 2013-04-22 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 6 | 2013-04-22-80ef1083-11362-0 |
8bdefc16db274ab0e6963d7ab6e1cae247f6d91c | 18) 1 Victoria Street, London SW1H 0ET | Overseas visits 80ef1083 | 2013-04-22 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 7 | 2013-04-22-80ef1083-11362-0 |
a63da60d5d418fca0fee5daacb6064a20f013a4c | Amount of donation (or estimate of the probable value): | Overseas visits 80ef1083 | 2013-04-22 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 8 | 2013-04-22-80ef1083-11362-0 |
962914900e22c8c591e55b101a66ec2668587b37 | 16) £3,048.32 towards travel and accommodation | Overseas visits 80ef1083 | 2013-04-22 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 9 | 2013-04-22-80ef1083-11362-0 |
73a2b1a919621efcdaec2f04519e244cc960f9e4 | 17) £3,048.32 towards travel and accommodation | Overseas visits 80ef1083 | 2013-04-22 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 10 | 2013-04-22-80ef1083-11362-0 |
8df7a8f025e53199df8350d36018ad34240dd2cc | 18) £304.84 towards travel and accommodation | Overseas visits 80ef1083 | 2013-04-22 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 11 | 2013-04-22-80ef1083-11362-0 |
6b2adecfbb56d3d044d746098e8e82e3c8e1ed9f | Destination of visit: Singapore and Indonesia | Overseas visits 80ef1083 | 2013-04-22 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 12 | 2013-04-22-80ef1083-11362-0 |
15932a381a838cf0f5df8d187b0544e9661a72f7 | Date of visit: 9-15 March 2013 | Overseas visits 80ef1083 | 2013-04-22 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 13 | 2013-04-22-80ef1083-11362-0 |
8d2f563d108179b4fbca20f8e6286eea2226825c | 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-04-22 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 14 | 2013-04-22-80ef1083-11362-0 |
c474610a76c029a9239e38449e8777355062bb1c | (Registered 15 April 2013) | Overseas visits 80ef1083 | 2013-04-22 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 15 | 2013-04-22-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");