items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
13 rows where record_id = "2013-02-25-80ef1083-10034-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 |
---|---|---|---|---|---|---|---|
dbf5de347700bcb3a712e567c04cd5f3c189d3a1 | Name of donor: | Overseas visits 80ef1083 | 2013-02-25 | Alan Beith uk.org.publicwhip/member/40073 | Alan Beith uk.org.publicwhip/person/10034 | 0 | 2013-02-25-80ef1083-10034-0 |
43fcef34da689f4f65e9e3b075328727f93e5049 | 1) Liberal Democrat Friends of Israel | Overseas visits 80ef1083 | 2013-02-25 | Alan Beith uk.org.publicwhip/member/40073 | Alan Beith uk.org.publicwhip/person/10034 | 1 | 2013-02-25-80ef1083-10034-0 |
2883c525769c75937efe1803b4c792aeaccac50e | 2) Government of Israel | Overseas visits 80ef1083 | 2013-02-25 | Alan Beith uk.org.publicwhip/member/40073 | Alan Beith uk.org.publicwhip/person/10034 | 2 | 2013-02-25-80ef1083-10034-0 |
9a8bf078dc2e589e4515ffaddd6238ec4927214f | Address of donor: | Overseas visits 80ef1083 | 2013-02-25 | Alan Beith uk.org.publicwhip/member/40073 | Alan Beith uk.org.publicwhip/person/10034 | 3 | 2013-02-25-80ef1083-10034-0 |
aef4906d24ff06a1866e6ad48a1ed43591c358f3 | 1) PO Box 57769, London NW11 1GF | Overseas visits 80ef1083 | 2013-02-25 | Alan Beith uk.org.publicwhip/member/40073 | Alan Beith uk.org.publicwhip/person/10034 | 4 | 2013-02-25-80ef1083-10034-0 |
56a3e4c3b928fac6274e6ec4abaf0ba9dc401dfc | 2) c/o Embassy of Israel, 2 Palace Green, London W8 4QB | Overseas visits 80ef1083 | 2013-02-25 | Alan Beith uk.org.publicwhip/member/40073 | Alan Beith uk.org.publicwhip/person/10034 | 5 | 2013-02-25-80ef1083-10034-0 |
a6c2980c5de59307f83d56dfbada68b165775245 | Amount of donation (or estimate of the probable value): | Overseas visits 80ef1083 | 2013-02-25 | Alan Beith uk.org.publicwhip/member/40073 | Alan Beith uk.org.publicwhip/person/10034 | 6 | 2013-02-25-80ef1083-10034-0 |
ae111d0300284096aca95b3560be658dad4566db | 1) £900; accommodation and food | Overseas visits 80ef1083 | 2013-02-25 | Alan Beith uk.org.publicwhip/member/40073 | Alan Beith uk.org.publicwhip/person/10034 | 7 | 2013-02-25-80ef1083-10034-0 |
6b0923f61fa68f330910136124a20c3b41c1e9be | 2) £450; flights | Overseas visits 80ef1083 | 2013-02-25 | Alan Beith uk.org.publicwhip/member/40073 | Alan Beith uk.org.publicwhip/person/10034 | 8 | 2013-02-25-80ef1083-10034-0 |
25f10994c9330e055e6ca49630907b8c66e48844 | Destination of visit: Israel and the West Bank | Overseas visits 80ef1083 | 2013-02-25 | Alan Beith uk.org.publicwhip/member/40073 | Alan Beith uk.org.publicwhip/person/10034 | 9 | 2013-02-25-80ef1083-10034-0 |
844a51e82e44dfedad67203fd3ecae9de1efc117 | Date of visit: 6-12 June 2012 | Overseas visits 80ef1083 | 2013-02-25 | Alan Beith uk.org.publicwhip/member/40073 | Alan Beith uk.org.publicwhip/person/10034 | 10 | 2013-02-25-80ef1083-10034-0 |
c5db726b3e03ba406d91233ec85e6436725ed5ae | Purpose of visit: briefings on current political and security situation in Israel and the West Bank. | Overseas visits 80ef1083 | 2013-02-25 | Alan Beith uk.org.publicwhip/member/40073 | Alan Beith uk.org.publicwhip/person/10034 | 11 | 2013-02-25-80ef1083-10034-0 |
675b3a5e12a7f12ad95523644a2df3d6df4047cd | (Registered 20 June 2012) | Overseas visits 80ef1083 | 2013-02-25 | Alan Beith uk.org.publicwhip/member/40073 | Alan Beith uk.org.publicwhip/person/10034 | 12 | 2013-02-25-80ef1083-10034-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");