items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
30 rows where record_id = "2013-12-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 |
---|---|---|---|---|---|---|---|
b364d80c3393e938f703e96a4b102956c6f26b78 | Name of donor: | Overseas visits 80ef1083 | 2013-12-09 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 0 | 2013-12-09-80ef1083-11362-0 |
5874f930aa334e4edb0d7f550394a99d383f1e59 | 16) Barclays Plc | Overseas visits 80ef1083 | 2013-12-09 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 1 | 2013-12-09-80ef1083-11362-0 |
5062062ddc1ae664e4f9c70a9f7e25eb411b47b4 | 17) Prudential Plc | Overseas visits 80ef1083 | 2013-12-09 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 2 | 2013-12-09-80ef1083-11362-0 |
e829edbd871843de34ba7594b99985bc399716df | 18) UK-ASEAN Business Council | Overseas visits 80ef1083 | 2013-12-09 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 3 | 2013-12-09-80ef1083-11362-0 |
4c3c46c41b27fec327d66b22d423573927092313 | Address of donor: | Overseas visits 80ef1083 | 2013-12-09 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 4 | 2013-12-09-80ef1083-11362-0 |
38b3cce83d6f3db408f5bb8d50a926a82d34af55 | 16) 1 Churchill Place, London E14 5HP | Overseas visits 80ef1083 | 2013-12-09 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 5 | 2013-12-09-80ef1083-11362-0 |
7f649d52361b554f2bfe28cce2312675cd123bec | 17) Laurence Pountney Hill, London EC4R 0HH | Overseas visits 80ef1083 | 2013-12-09 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 6 | 2013-12-09-80ef1083-11362-0 |
afcc69c7586c4e12d6fa681281ccf69420af7138 | 18) 1 Victoria Street, London SW1H 0ET | Overseas visits 80ef1083 | 2013-12-09 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 7 | 2013-12-09-80ef1083-11362-0 |
2f8803bc7864f9feb3e70723c8134ee83bc6dfb3 | Amount of donation (or estimate of the probable value): | Overseas visits 80ef1083 | 2013-12-09 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 8 | 2013-12-09-80ef1083-11362-0 |
b5c110407075b50c0350de2905b9bb3cc79fde57 | 16) £3,048.32 towards travel and accommodation | Overseas visits 80ef1083 | 2013-12-09 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 9 | 2013-12-09-80ef1083-11362-0 |
36d55dff88e31acaf604c96c0ccf430084ac6afb | 17) £3,048.32 towards travel and accommodation | Overseas visits 80ef1083 | 2013-12-09 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 10 | 2013-12-09-80ef1083-11362-0 |
0d38ef1891cff8d897dff38fa1fb1fa52bdad958 | 18) £304.84 towards travel and accommodation | Overseas visits 80ef1083 | 2013-12-09 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 11 | 2013-12-09-80ef1083-11362-0 |
66fd2e95da542ec586936cd42f4f5629f97f1cf8 | Destination of visit: Singapore and Indonesia | Overseas visits 80ef1083 | 2013-12-09 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 12 | 2013-12-09-80ef1083-11362-0 |
48d82e897d4455304aa93dda9c3dca1096c4105b | Date of visit: 9-15 March 2013 | Overseas visits 80ef1083 | 2013-12-09 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 13 | 2013-12-09-80ef1083-11362-0 |
dc49a29b4e4f1e066c0775e13973e817d566dc9c | 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-12-09 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 14 | 2013-12-09-80ef1083-11362-0 |
3bdf5912cfa0a9e5ea30f80f568e68132e41b95a | (Registered 15 April 2013) | Overseas visits 80ef1083 | 2013-12-09 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 15 | 2013-12-09-80ef1083-11362-0 |
6fa81ca3c789bce54261fdfbec0dea7a00f65f1c | Name of donor: Embassy of Japan in the UK | Overseas visits 80ef1083 | 2013-12-09 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 16 | 2013-12-09-80ef1083-11362-0 |
c2da1c118c1884f31f077bdcef4f6a6c8c29a974 | Address of donor: 101-104 Piccadilly, London W1J 7JT | Overseas visits 80ef1083 | 2013-12-09 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 17 | 2013-12-09-80ef1083-11362-0 |
552e73570dbb0cef433ab501fd4b5e402eb16363 | 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-12-09 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 18 | 2013-12-09-80ef1083-11362-0 |
5e2cd19fe91f9c234a6fc42407a6c50c1fc85d0c | Destination of visit: Japan (Tokyo, Nagoya and Kyoto) | Overseas visits 80ef1083 | 2013-12-09 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 19 | 2013-12-09-80ef1083-11362-0 |
b9cb2f4192b70e96a9b25f0a0dcb32136d3be2f4 | Date of visit: 26-31 March 2013 | Overseas visits 80ef1083 | 2013-12-09 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 20 | 2013-12-09-80ef1083-11362-0 |
450e0c4f3e5b7649e63e58d2738eb4c78f232cd6 | 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-12-09 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 21 | 2013-12-09-80ef1083-11362-0 |
f07dd53096bc6766d8991c0be0c3f7b9cb49e75e | (Registered 24 April 2013) | Overseas visits 80ef1083 | 2013-12-09 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 22 | 2013-12-09-80ef1083-11362-0 |
703f9eef1e200ccae8459a2c8d3fb9d832956c27 | Name of donor: Inmarsat | Overseas visits 80ef1083 | 2013-12-09 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 23 | 2013-12-09-80ef1083-11362-0 |
63df404d76560e3651193fdd2af62c0a119632b5 | Address of donor: 99 City Road, London EC1Y 1AX | Overseas visits 80ef1083 | 2013-12-09 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 24 | 2013-12-09-80ef1083-11362-0 |
6ee30e26ef09110bdef98fa675b5d8cb84d17947 | Amount of donation (or estimate of the probable value): Flights, £5,693 (including tax); accommodation, £362; total £6,055 | Overseas visits 80ef1083 | 2013-12-09 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 25 | 2013-12-09-80ef1083-11362-0 |
4d8873010b06912faa638421d28ce7c28a48bdd7 | Destination of visit: Cayenne, French Guiana | Overseas visits 80ef1083 | 2013-12-09 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 26 | 2013-12-09-80ef1083-11362-0 |
5d406e6093354e3242e5a3f007a090aa65ec816c | Date of visit: 24-26 July 2013 | Overseas visits 80ef1083 | 2013-12-09 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 27 | 2013-12-09-80ef1083-11362-0 |
7400c52c50e188959e632452cef2f63946554ba9 | Purpose of visit: to view launch of Alphasat satellite in capacity as Shadow Minister for Competitiveness and Enterprise. | Overseas visits 80ef1083 | 2013-12-09 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 28 | 2013-12-09-80ef1083-11362-0 |
59fa3837c57e1a648ed8e3d4d280e4a833a667a5 | (Registered 20 August 2013) | Overseas visits 80ef1083 | 2013-12-09 | Iain Wright uk.org.publicwhip/member/40302 | Iain Wright uk.org.publicwhip/person/11362 | 29 | 2013-12-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");