items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
13 rows where record_id = "2014-06-16-80ef1083-10106-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 |
---|---|---|---|---|---|---|---|
d3099248df635866718650bbbcb213c2dec7a922 | Amount of donation (or estimate of the probable value): flights, accommodation etc; total value £1,200 | Overseas visits 80ef1083 | 2014-06-16 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 3 | 2014-06-16-80ef1083-10106-0 |
865a777a22c1e67e2035695e6a33cdacf82140ce | Destination of visit: Israel | Overseas visits 80ef1083 | 2014-06-16 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 4 | 2014-06-16-80ef1083-10106-0 |
754584a7a2ae4a7416528b7b173b7c581d08503a | Date of visit: 10-13 March 2014 | Overseas visits 80ef1083 | 2014-06-16 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 5 | 2014-06-16-80ef1083-10106-0 |
cf290a25dc42679cec4bc0101493dfdda537722f | Purpose of visit: political delegation to Israel | Overseas visits 80ef1083 | 2014-06-16 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 6 | 2014-06-16-80ef1083-10106-0 |
637eed26d02203e0d58b0200a5249f176c934d95 | (Registered 19 March 2014) | Overseas visits 80ef1083 | 2014-06-16 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 7 | 2014-06-16-80ef1083-10106-0 |
ff7d26976a3e59ed6f199587d09627a0c330c343 | Name of donor: Conservative Friends of Israel | Overseas visits 80ef1083 | 2014-06-16 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 8 | 2014-06-16-80ef1083-10106-0 |
cde01ea0811b3f8242e86b939cf23b8902e178af | Address of donor: c/o Shelley Stock Hunter LLP, 7-10 Chandos St, London | Overseas visits 80ef1083 | 2014-06-16 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 9 | 2014-06-16-80ef1083-10106-0 |
0e2c72c034fc3652b1c04d28bf7f0c6cec382ee6 | W1G 9DG | Overseas visits 80ef1083 | 2014-06-16 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 10 | 2014-06-16-80ef1083-10106-0 |
7695add9c37ecc1cdc91b0e0df12f130fd9a2535 | Amount of donation (or estimate of the probable value): £2,000 | Overseas visits 80ef1083 | 2014-06-16 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 11 | 2014-06-16-80ef1083-10106-0 |
dc809aa09f77aed714b58d6176fc19aeac2afee3 | Destination of visit: Israel and the West Bank | Overseas visits 80ef1083 | 2014-06-16 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 12 | 2014-06-16-80ef1083-10106-0 |
8d64d1b6430a04d50687dae01cb80077749a3f57 | Date of visit: 16-21 February 2014 | Overseas visits 80ef1083 | 2014-06-16 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 13 | 2014-06-16-80ef1083-10106-0 |
7737876fb833e6fcf6eaa12e369627362ed1abf8 | Purpose of visit: fact finding political delegation | Overseas visits 80ef1083 | 2014-06-16 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 14 | 2014-06-16-80ef1083-10106-0 |
dc1ee465423b0178abaeec1e6036ad6038475c5d | (Registered 21 March 2014) | Overseas visits 80ef1083 | 2014-06-16 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 15 | 2014-06-16-80ef1083-10106-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");