items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
7 rows where record_id = "2014-02-24-80ef1083-24872-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 |
---|---|---|---|---|---|---|---|
cfd349528c323e8834b60ab10ba537607c7f56c3 | Name of donor: Government of the United Arab Emirates | Overseas visits 80ef1083 | 2014-02-24 | Ian Murray uk.org.publicwhip/member/40240 | Ian Murray uk.org.publicwhip/person/24872 | 0 | 2014-02-24-80ef1083-24872-0 |
47b5a06bfbbaff18c505dcc848f47f518333850d | Address of donor: PO Box 31966, Abu Dhabi, UAE | Overseas visits 80ef1083 | 2014-02-24 | Ian Murray uk.org.publicwhip/member/40240 | Ian Murray uk.org.publicwhip/person/24872 | 1 | 2014-02-24-80ef1083-24872-0 |
5833def6697eae08b8f9d776f1a5a2d8390f5724 | Amount of donation (or estimate of the probable value): Travel and accommodation with a value of £3,500 | Overseas visits 80ef1083 | 2014-02-24 | Ian Murray uk.org.publicwhip/member/40240 | Ian Murray uk.org.publicwhip/person/24872 | 2 | 2014-02-24-80ef1083-24872-0 |
2f4d35a50e2ced445abfa29d3ecee40f01bef91e | Destination of visit: United Arab Emirates | Overseas visits 80ef1083 | 2014-02-24 | Ian Murray uk.org.publicwhip/member/40240 | Ian Murray uk.org.publicwhip/person/24872 | 3 | 2014-02-24-80ef1083-24872-0 |
4c2375fe615ca2932501893fe0cce73027d5dddd | Date of visit: 23-26 March 2013 | Overseas visits 80ef1083 | 2014-02-24 | Ian Murray uk.org.publicwhip/member/40240 | Ian Murray uk.org.publicwhip/person/24872 | 4 | 2014-02-24-80ef1083-24872-0 |
f76d8f6eda86a024b7b5afec522b7cb6917f3cae | Purpose of visit: Visit of the UAE All-Party Group, to meet Government Ministers, Members of the Federal National Council and senior business figures together with British diplomats in order to build on the bilateral relationship and promote trade and investment ties. | Overseas visits 80ef1083 | 2014-02-24 | Ian Murray uk.org.publicwhip/member/40240 | Ian Murray uk.org.publicwhip/person/24872 | 5 | 2014-02-24-80ef1083-24872-0 |
0833d7a51047a10e9cb14c72042c64fce342ef54 | (Registered 11 April 2013) | Overseas visits 80ef1083 | 2014-02-24 | Ian Murray uk.org.publicwhip/member/40240 | Ian Murray uk.org.publicwhip/person/24872 | 6 | 2014-02-24-80ef1083-24872-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");