items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
6 rows where record_id = "2013-04-08-80ef1083-24849-0" sorted by hash
This data as json, CSV (advanced)
Suggested facets: date (date)
hash ▼ | item | category_id | date | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
0b0d909e21167ee8cc8b6ea7ca2a202641fab50d | Amount of donation (or estimate of the probable value): £3,500 | Overseas visits 80ef1083 | 2013-04-08 | Dan Byles uk.org.publicwhip/member/40449 | Dan Byles uk.org.publicwhip/person/24849 | 2 | 2013-04-08-80ef1083-24849-0 |
30eb1959f1f1fc02f7be2d93ad0f85d8972f5624 | Date of visit: 23-28 November 2012 | Overseas visits 80ef1083 | 2013-04-08 | Dan Byles uk.org.publicwhip/member/40449 | Dan Byles uk.org.publicwhip/person/24849 | 4 | 2013-04-08-80ef1083-24849-0 |
5b492b65aa6a5eb13f32690f316267e296c4f0da | Destination of visit: Abu Dhabi and Dubai, UAE | Overseas visits 80ef1083 | 2013-04-08 | Dan Byles uk.org.publicwhip/member/40449 | Dan Byles uk.org.publicwhip/person/24849 | 3 | 2013-04-08-80ef1083-24849-0 |
a4fb556190211dc87b30ead34f2267382e877089 | Name of donor: Government of the United Arab Emirates | Overseas visits 80ef1083 | 2013-04-08 | Dan Byles uk.org.publicwhip/member/40449 | Dan Byles uk.org.publicwhip/person/24849 | 0 | 2013-04-08-80ef1083-24849-0 |
a7261bade32cd3d746fd65cbe595b97a2d3c7ab7 | Purpose of visit: To meet with Government ministers, Members of the Federal National council, UK diplomats and armed forces personnel and senior UK and Emirati business figures with the aim of strengthening and promoting relations with the UAE. (Registered 10 December 2012 ) | Overseas visits 80ef1083 | 2013-04-08 | Dan Byles uk.org.publicwhip/member/40449 | Dan Byles uk.org.publicwhip/person/24849 | 5 | 2013-04-08-80ef1083-24849-0 |
e02870b5363566de9228af62ff1092bc20325073 | Address of donor: c/o Embassy of the UAE, 30 Princes Gate, London SW7 1PT | Overseas visits 80ef1083 | 2013-04-08 | Dan Byles uk.org.publicwhip/member/40449 | Dan Byles uk.org.publicwhip/person/24849 | 1 | 2013-04-08-80ef1083-24849-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");