items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
28 rows where record_id = "2013-11-25-80ef1083-10357-0" sorted by date descending
This data as json, CSV (advanced)
Suggested facets: date (date)
hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
a96d6acffb100b7f8ffafcb0b8534cdde534b5ea | Name of donor: British Council | Overseas visits 80ef1083 | 2013-11-25 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 0 | 2013-11-25-80ef1083-10357-0 |
fcc545f4e7efb72433fdd2442938531da1e868b2 | Address of donor: 10 Spring Gardens, London SW1A 2BN | Overseas visits 80ef1083 | 2013-11-25 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 1 | 2013-11-25-80ef1083-10357-0 |
0b8698438545136513e7450dce9c3212e8376cc9 | Amount of donation (or estimate of the probable value): costs of visit for me and a member of my staff; total £867.66 | Overseas visits 80ef1083 | 2013-11-25 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 2 | 2013-11-25-80ef1083-10357-0 |
ed91058319aae4f3a8cd221717e1609b7bdfc16f | Destination of visit: Hammamet, Tunisia | Overseas visits 80ef1083 | 2013-11-25 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 3 | 2013-11-25-80ef1083-10357-0 |
7a217e1629fd1ffeac99d6bcaa6704a39de26e9f | Date of visit: 15-18 November 2012 | Overseas visits 80ef1083 | 2013-11-25 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 4 | 2013-11-25-80ef1083-10357-0 |
a04fe2ce0f06a2df52d07fba85b31ac7d7801cde | Purpose of visit: to attend the Hammamet Conference | Overseas visits 80ef1083 | 2013-11-25 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 5 | 2013-11-25-80ef1083-10357-0 |
2c17bd32f16096d6a731ff30362c9c8ce2d7224d | (Registered 6 December 2012) | Overseas visits 80ef1083 | 2013-11-25 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 6 | 2013-11-25-80ef1083-10357-0 |
d79e0c98fa96675f4a99a58b07f390c25b52bc14 | Name of donor: Burma Campaign UK | Overseas visits 80ef1083 | 2013-11-25 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 7 | 2013-11-25-80ef1083-10357-0 |
f0cff893bab60a71e85b0e66cf200f8f91d07e6a | Address of donor: 28 Charles Square, London N1 6HT | Overseas visits 80ef1083 | 2013-11-25 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 8 | 2013-11-25-80ef1083-10357-0 |
cd0da3b4ff6c422acd4d6e0c73f0d2424ced8d14 | Amount of donation (or estimate of the probable value): flights, accommodation food and other costs for me and a member of my staff, with a total value of £3,637 | Overseas visits 80ef1083 | 2013-11-25 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 9 | 2013-11-25-80ef1083-10357-0 |
ac0daeeb6f54970b50aa78e92280542c18eaa8c6 | Destination of visit: Rangoon, Burma and Mae Sot, Thailand | Overseas visits 80ef1083 | 2013-11-25 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 10 | 2013-11-25-80ef1083-10357-0 |
031668868da5589ce8bce0b988518f8abcf44456 | Date of visit: 24 November-2 December 2012 | Overseas visits 80ef1083 | 2013-11-25 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 11 | 2013-11-25-80ef1083-10357-0 |
2c392b06005c9e194423e2e90b5859c2707d5c16 | Purpose of visit: to meet political leaders, civil society organizations and refugees in Burma and the Thai-Burma border. | Overseas visits 80ef1083 | 2013-11-25 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 12 | 2013-11-25-80ef1083-10357-0 |
d6ecd5eb5feec4dbeb9a8fadca279ee395b55a9d | (Registered 7 January 2013) | Overseas visits 80ef1083 | 2013-11-25 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 13 | 2013-11-25-80ef1083-10357-0 |
d3f125d8b1c5790bb33bd7785eab764ecb246fdf | Name of donor: World Vision UK | Overseas visits 80ef1083 | 2013-11-25 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 14 | 2013-11-25-80ef1083-10357-0 |
7687c7afbbd701273b0c3c38cd74e040f3cf89e3 | Address of donor: Opal Drive, Fox Milne, Milton Keynes, MK15 0ZR | Overseas visits 80ef1083 | 2013-11-25 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 15 | 2013-11-25-80ef1083-10357-0 |
7346f20846ae305a5862d8635d940dbc743e0dc3 | Amount of donation (or estimate of the probable value): accommodation, food, transport and entry cards for myself and one member of staff, with a total value of £ 847.68 | Overseas visits 80ef1083 | 2013-11-25 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 16 | 2013-11-25-80ef1083-10357-0 |
8c0f7cb970b46949544997cfbc6502d2f96e8fe9 | Destination of visit: Gisenyi, Rwanda; and Goma, Eastern DRC | Overseas visits 80ef1083 | 2013-11-25 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 17 | 2013-11-25-80ef1083-10357-0 |
151361f595c6c06faae472bb99de2b515379db04 | Date of visit: 22-23 January 2013 | Overseas visits 80ef1083 | 2013-11-25 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 18 | 2013-11-25-80ef1083-10357-0 |
2a6380653bb7ccba1540b549e6b88c51f3f7c36d | Purpose of visit: Visits to projects | Overseas visits 80ef1083 | 2013-11-25 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 19 | 2013-11-25-80ef1083-10357-0 |
b41589b1ef004463e9b1b9f03f7ec4a6925806d4 | (Registered 4 April 2013 ) | Overseas visits 80ef1083 | 2013-11-25 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 20 | 2013-11-25-80ef1083-10357-0 |
46099f7fbd218ccde6ade6d20ae152a15406b1a4 | Name of donor: Labour Friends of Israel | Overseas visits 80ef1083 | 2013-11-25 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 21 | 2013-11-25-80ef1083-10357-0 |
9ac9f0827881dce365b32e68427974afc0a47c76 | Address of donor: BM LFI, London W1N 3XX | Overseas visits 80ef1083 | 2013-11-25 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 22 | 2013-11-25-80ef1083-10357-0 |
cae4dec753961f8f0be2356165fe71a9cc0c3802 | Amount of donation (or estimate of the probable value): costs of visit; £2,900 | Overseas visits 80ef1083 | 2013-11-25 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 23 | 2013-11-25-80ef1083-10357-0 |
9d74765d39f55e91f8b615cc53932cc3144ec0f3 | Destination of visit: Israel and the Palestinian Territories | Overseas visits 80ef1083 | 2013-11-25 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 24 | 2013-11-25-80ef1083-10357-0 |
7be482aa40d2a4ea4f4872c4967ff1c3a9391d1a | Date of visit: 19-24 May 2013 | Overseas visits 80ef1083 | 2013-11-25 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 25 | 2013-11-25-80ef1083-10357-0 |
eee1135ff4cf6b76bd8017b8693aeb02802990df | Purpose of visit: fact-finding visit to Israel and the Palestinian Territories | Overseas visits 80ef1083 | 2013-11-25 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 26 | 2013-11-25-80ef1083-10357-0 |
f0ffc9fa3df2380ccffabf269c6e4e44d80813c1 | (Registered 6 June 2013) | Overseas visits 80ef1083 | 2013-11-25 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 27 | 2013-11-25-80ef1083-10357-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");