items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
30 rows where record_id = "2014-01-20-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 |
---|---|---|---|---|---|---|---|
ffa6e37ee70f1ae092ac9b178e2d78448c2cd385 | Name of donor: | Overseas visits 80ef1083 | 2014-01-20 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 0 | 2014-01-20-80ef1083-11362-0 |
436326c64939cac50a75a01ee30263b81d02603b | 16) Barclays Plc | Overseas visits 80ef1083 | 2014-01-20 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 1 | 2014-01-20-80ef1083-11362-0 |
6cfb8ee137ac8b967df05cc93f266f4d2eee2448 | 17) Prudential Plc | Overseas visits 80ef1083 | 2014-01-20 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 2 | 2014-01-20-80ef1083-11362-0 |
02d8033a5798258b3ab56249e52381de0fb043cf | 18) UK-ASEAN Business Council | Overseas visits 80ef1083 | 2014-01-20 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 3 | 2014-01-20-80ef1083-11362-0 |
5097b987cec9ddcfa296f7359e5cd6a933d03228 | Address of donor: | Overseas visits 80ef1083 | 2014-01-20 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 4 | 2014-01-20-80ef1083-11362-0 |
defcf2d248c4b4747d9e20a27ebed572c6b36d20 | 16) 1 Churchill Place, London E14 5HP | Overseas visits 80ef1083 | 2014-01-20 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 5 | 2014-01-20-80ef1083-11362-0 |
ea87b3585c44f97bbc18cf6154b025054ad568e4 | 17) Laurence Pountney Hill, London EC4R 0HH | Overseas visits 80ef1083 | 2014-01-20 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 6 | 2014-01-20-80ef1083-11362-0 |
a937522610d99bdfb1048eaeba107cf0b45d9095 | 18) 1 Victoria Street, London SW1H 0ET | Overseas visits 80ef1083 | 2014-01-20 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 7 | 2014-01-20-80ef1083-11362-0 |
4ff648e22e1ef634a8ea40a5923bed451d4ce210 | Amount of donation (or estimate of the probable value): | Overseas visits 80ef1083 | 2014-01-20 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 8 | 2014-01-20-80ef1083-11362-0 |
02aa97efd855d4d29850d1567315b5ff0cc777ad | 16) £3,048.32 towards travel and accommodation | Overseas visits 80ef1083 | 2014-01-20 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 9 | 2014-01-20-80ef1083-11362-0 |
332973a04f917a1cfb76486565e2c598c0362283 | 17) £3,048.32 towards travel and accommodation | Overseas visits 80ef1083 | 2014-01-20 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 10 | 2014-01-20-80ef1083-11362-0 |
ac541b43abdb71e0c7376a61f58245344a1c2c42 | 18) £304.84 towards travel and accommodation | Overseas visits 80ef1083 | 2014-01-20 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 11 | 2014-01-20-80ef1083-11362-0 |
ae2c54e4ea93afe4da6e4ae34845df30c07f920b | Destination of visit: Singapore and Indonesia | Overseas visits 80ef1083 | 2014-01-20 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 12 | 2014-01-20-80ef1083-11362-0 |
5b9b5ce699ddb055df8418a0acff56e03ae4c00b | Date of visit: 9-15 March 2013 | Overseas visits 80ef1083 | 2014-01-20 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 13 | 2014-01-20-80ef1083-11362-0 |
beb76d0f6f0ebebddbc65c477ac933d3cdc77095 | 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-01-20 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 14 | 2014-01-20-80ef1083-11362-0 |
372df66b337e85722003867d8f34dc6d3aa12e88 | (Registered 15 April 2013) | Overseas visits 80ef1083 | 2014-01-20 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 15 | 2014-01-20-80ef1083-11362-0 |
49db3a44d0ad4770919f45c87b949e61fe3876a9 | Name of donor: Embassy of Japan in the UK | Overseas visits 80ef1083 | 2014-01-20 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 16 | 2014-01-20-80ef1083-11362-0 |
d8ee3b3133b2b3426a9fa343f1271c0696dcea4f | Address of donor: 101-104 Piccadilly, London W1J 7JT | Overseas visits 80ef1083 | 2014-01-20 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 17 | 2014-01-20-80ef1083-11362-0 |
de1c5affdefd586f34b0ec69f8b330bfedb5b8ca | 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-01-20 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 18 | 2014-01-20-80ef1083-11362-0 |
20e57886d0fab1d0b04ed0a4579d2a95c16b2c9d | Destination of visit: Japan (Tokyo, Nagoya and Kyoto) | Overseas visits 80ef1083 | 2014-01-20 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 19 | 2014-01-20-80ef1083-11362-0 |
eb28e4fd6bd75321b3a24f968d1bc46f289dffa2 | Date of visit: 26-31 March 2013 | Overseas visits 80ef1083 | 2014-01-20 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 20 | 2014-01-20-80ef1083-11362-0 |
0602e4258f1f3856b79014be8355b999a5e69936 | 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-01-20 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 21 | 2014-01-20-80ef1083-11362-0 |
392da60d478a230777c40c3ec64ba6c2902dfe3b | (Registered 24 April 2013) | Overseas visits 80ef1083 | 2014-01-20 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 22 | 2014-01-20-80ef1083-11362-0 |
bf41d1a5748c2fed86a0bc02f88cb14a8482ce02 | Name of donor: Inmarsat | Overseas visits 80ef1083 | 2014-01-20 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 23 | 2014-01-20-80ef1083-11362-0 |
518a5eaccaedb1404b218963ef75af2580f7212f | Address of donor: 99 City Road, London EC1Y 1AX | Overseas visits 80ef1083 | 2014-01-20 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 24 | 2014-01-20-80ef1083-11362-0 |
9a8f21d3b63710f59d8a9590a520e32db14fa37e | Amount of donation (or estimate of the probable value): Flights, £5,693 (including tax); accommodation, £362; total £6,055 | Overseas visits 80ef1083 | 2014-01-20 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 25 | 2014-01-20-80ef1083-11362-0 |
5acfb3e0160a22067fc5094fa7f01b14ab409c3f | Destination of visit: Cayenne, French Guiana | Overseas visits 80ef1083 | 2014-01-20 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 26 | 2014-01-20-80ef1083-11362-0 |
0a4da44b743221ecd7d3c6b902f4c41664515a4d | Date of visit: 24-26 July 2013 | Overseas visits 80ef1083 | 2014-01-20 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 27 | 2014-01-20-80ef1083-11362-0 |
d163dc38b562aa7921a272b8bfe9fe8a3558b621 | Purpose of visit: to view launch of Alphasat satellite in capacity as Shadow Minister for Competitiveness and Enterprise. | Overseas visits 80ef1083 | 2014-01-20 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 28 | 2014-01-20-80ef1083-11362-0 |
57f5be336103948ea80926b740f7bc03500005db | (Registered 20 August 2013) | Overseas visits 80ef1083 | 2014-01-20 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 29 | 2014-01-20-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");