items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
8 rows where record_id = "2015-02-23-80ef1083-10106-1" sorted by record_id
This data as json, CSV (advanced)
date (date) 1 ✖
hash | item | category_id | date | member_id | person_id | sort_order | record_id ▼ |
---|---|---|---|---|---|---|---|
f6f339eedd16891eb5544c18e0a240eafe75a922 | Name of donor: Conservative Friends of Israel | Overseas visits 80ef1083 | 2015-02-23 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 0 | 2015-02-23-80ef1083-10106-1 |
a7eff748e8e867304024bb84783f361e278b760f | Address of donor: c/o Shelley Stock Hunter LLP, 7-10 Chandos St, London | Overseas visits 80ef1083 | 2015-02-23 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 1 | 2015-02-23-80ef1083-10106-1 |
0e1abf86bb65276d7ddb0838c860fda82b760b87 | W1G 9DG | Overseas visits 80ef1083 | 2015-02-23 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 2 | 2015-02-23-80ef1083-10106-1 |
7825b8ab232357d05981c7c7dd2cff924662b1a0 | Amount of donation (or estimate of the probable value): £2,000 | Overseas visits 80ef1083 | 2015-02-23 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 3 | 2015-02-23-80ef1083-10106-1 |
8133212b14377ddcc26f2a1625f37207e63ebb83 | Destination of visit: Israel and the West Bank | Overseas visits 80ef1083 | 2015-02-23 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 4 | 2015-02-23-80ef1083-10106-1 |
c048c4650f0b341002739c44bcb0feeead96f3a8 | Date of visit: 16-21 February 2014 | Overseas visits 80ef1083 | 2015-02-23 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 5 | 2015-02-23-80ef1083-10106-1 |
6c329d2e061324621c04b0b104f4cd2f6691e695 | Purpose of visit: fact finding political delegation | Overseas visits 80ef1083 | 2015-02-23 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 6 | 2015-02-23-80ef1083-10106-1 |
2d9b5651dadd533de7679d2193bf7f44ee59d0c3 | (Registered 21 March 2014) | Overseas visits 80ef1083 | 2015-02-23 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 7 | 2015-02-23-80ef1083-10106-1 |
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");