items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
13 rows where record_id = "2014-04-07-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 |
---|---|---|---|---|---|---|---|
4d0f374c650c259f8118a78f1c7cb9a81a460933 | Amount of donation (or estimate of the probable value): flights, accommodation etc; total value £1,200 | Overseas visits 80ef1083 | 2014-04-07 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 3 | 2014-04-07-80ef1083-10106-0 |
c5a21a6bec371608dc925d849eed3ac21678b546 | Destination of visit: Israel | Overseas visits 80ef1083 | 2014-04-07 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 4 | 2014-04-07-80ef1083-10106-0 |
6b0e72017eb71a820804a93c1a4aa29d38b5efae | Date of visit: 10-13 March 2014 | Overseas visits 80ef1083 | 2014-04-07 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 5 | 2014-04-07-80ef1083-10106-0 |
37c2e94d69fe30d0993308a49477c77d675e0d79 | Purpose of visit: political delegation to Israel | Overseas visits 80ef1083 | 2014-04-07 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 6 | 2014-04-07-80ef1083-10106-0 |
dc94b8c643dbfe57cd127422c36e973e7d99d3c0 | (Registered 19 March 2014) | Overseas visits 80ef1083 | 2014-04-07 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 7 | 2014-04-07-80ef1083-10106-0 |
ef7c6f243cee22fd7962689c98d34f2c5b210540 | Name of donor: Conservative Friends of Israel | Overseas visits 80ef1083 | 2014-04-07 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 8 | 2014-04-07-80ef1083-10106-0 |
ee432c49a9c85b088b6cf0253b5cfbdf29d0bbda | Address of donor: c/o Shelley Stock Hunter LLP, 7-10 Chandos St, London | Overseas visits 80ef1083 | 2014-04-07 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 9 | 2014-04-07-80ef1083-10106-0 |
0b0d9fe348a743e5fc6675f61ebe19964a71c2ce | W1G 9DG | Overseas visits 80ef1083 | 2014-04-07 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 10 | 2014-04-07-80ef1083-10106-0 |
34da3b8b5be6c9604cdd2c7640b4c0f8be0f8c3a | Amount of donation (or estimate of the probable value): £2,000 | Overseas visits 80ef1083 | 2014-04-07 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 11 | 2014-04-07-80ef1083-10106-0 |
6798bc6146789a901ec9aa589196b0f3273122fc | Destination of visit: Israel and the West Bank | Overseas visits 80ef1083 | 2014-04-07 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 12 | 2014-04-07-80ef1083-10106-0 |
f9dc1918816ef6f68854ed669266c0f899552142 | Date of visit: 16-21 February 2014 | Overseas visits 80ef1083 | 2014-04-07 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 13 | 2014-04-07-80ef1083-10106-0 |
d0ddb93ee46b8e3bc2b641bbd450c2fbef0a4d6e | Purpose of visit: fact finding political delegation | Overseas visits 80ef1083 | 2014-04-07 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 14 | 2014-04-07-80ef1083-10106-0 |
ed1620dcd2b70fad9016c2b6600e26ac25783410 | (Registered 21 March 2014) | Overseas visits 80ef1083 | 2014-04-07 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 15 | 2014-04-07-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");