items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
21 rows where record_id = "2014-09-22-80ef1083-10048-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 |
---|---|---|---|---|---|---|---|
7ebfe5d3c5bce4b8d580f897ad94d83661b01a3c | Name of donor: Ergotep | Overseas visits 80ef1083 | 2014-09-22 | Hazel Blears uk.org.publicwhip/member/40517 | Hazel Blears uk.org.publicwhip/person/10048 | 0 | 2014-09-22-80ef1083-10048-0 |
f05f46ca2fd92b112ce862f17e3dd31242fa3c48 | Address of donor: 539, 44 Proseč u Skutče, 119 Czech Republic | Overseas visits 80ef1083 | 2014-09-22 | Hazel Blears uk.org.publicwhip/member/40517 | Hazel Blears uk.org.publicwhip/person/10048 | 1 | 2014-09-22-80ef1083-10048-0 |
0c19a93c9b1b30a7cd681eb9e75c7a215a2e72e6 | Amount of donation (or estimate of the probable value): £2,638.78 | Overseas visits 80ef1083 | 2014-09-22 | Hazel Blears uk.org.publicwhip/member/40517 | Hazel Blears uk.org.publicwhip/person/10048 | 2 | 2014-09-22-80ef1083-10048-0 |
6a8060c7e1c8ae271c08836db97f8d87cc34254d | Destination of visit: Prague | Overseas visits 80ef1083 | 2014-09-22 | Hazel Blears uk.org.publicwhip/member/40517 | Hazel Blears uk.org.publicwhip/person/10048 | 3 | 2014-09-22-80ef1083-10048-0 |
b34545fb96b55b9fe92fe05310515e7fb298f7f0 | Date of visit: 10-13 October 2013 | Overseas visits 80ef1083 | 2014-09-22 | Hazel Blears uk.org.publicwhip/member/40517 | Hazel Blears uk.org.publicwhip/person/10048 | 4 | 2014-09-22-80ef1083-10048-0 |
5cdd585d886820f6270d04402a42a2a84c64f384 | Purpose of visit: To make keynote speech at international forum on social enterprise | Overseas visits 80ef1083 | 2014-09-22 | Hazel Blears uk.org.publicwhip/member/40517 | Hazel Blears uk.org.publicwhip/person/10048 | 5 | 2014-09-22-80ef1083-10048-0 |
91efa49f47d892cc256113103928218e86845e20 | (Registered 30 October 2013) | Overseas visits 80ef1083 | 2014-09-22 | Hazel Blears uk.org.publicwhip/member/40517 | Hazel Blears uk.org.publicwhip/person/10048 | 6 | 2014-09-22-80ef1083-10048-0 |
e28ed6a33089f2ad92e5cb322d86c4d3834bb889 | Name of donor: Parliament of Bahrain (National Assembly & Shura Council) | Overseas visits 80ef1083 | 2014-09-22 | Hazel Blears uk.org.publicwhip/member/40517 | Hazel Blears uk.org.publicwhip/person/10048 | 7 | 2014-09-22-80ef1083-10048-0 |
80b3e3b3055d6e1103f830438ed2be7934cc17bd | Address of donor: Shaikh Daij Avenue, Manama, Bahrain | Overseas visits 80ef1083 | 2014-09-22 | Hazel Blears uk.org.publicwhip/member/40517 | Hazel Blears uk.org.publicwhip/person/10048 | 8 | 2014-09-22-80ef1083-10048-0 |
3009ec6e9e3518291c9f13c17d63b4247a4cabb1 | Amount of donation (or estimate of the probable value): flights £4,630, accommodation £797, total £5,427 | Overseas visits 80ef1083 | 2014-09-22 | Hazel Blears uk.org.publicwhip/member/40517 | Hazel Blears uk.org.publicwhip/person/10048 | 9 | 2014-09-22-80ef1083-10048-0 |
8834207e7d4cdd6b05d0293c69517907dfeb28ac | Destination of visit: Bahrain | Overseas visits 80ef1083 | 2014-09-22 | Hazel Blears uk.org.publicwhip/member/40517 | Hazel Blears uk.org.publicwhip/person/10048 | 10 | 2014-09-22-80ef1083-10048-0 |
843be4c595d5234da5dd9208158c30080eca7b2d | Date of visit: 12-16 April 2014 | Overseas visits 80ef1083 | 2014-09-22 | Hazel Blears uk.org.publicwhip/member/40517 | Hazel Blears uk.org.publicwhip/person/10048 | 11 | 2014-09-22-80ef1083-10048-0 |
6204729fd25c294dd799bf90600a869c9a50c8cf | Purpose of visit: to discuss governance, security and human rights issues and promote UK-Bahraini relations. | Overseas visits 80ef1083 | 2014-09-22 | Hazel Blears uk.org.publicwhip/member/40517 | Hazel Blears uk.org.publicwhip/person/10048 | 12 | 2014-09-22-80ef1083-10048-0 |
a1372fc50acd1a40dd0bb19a0a1fb0f9d16dcf53 | (Registered 27 May 2014) | Overseas visits 80ef1083 | 2014-09-22 | Hazel Blears uk.org.publicwhip/member/40517 | Hazel Blears uk.org.publicwhip/person/10048 | 13 | 2014-09-22-80ef1083-10048-0 |
3aab119fb7d8c9038bc5860ee6ac31358d81ac6b | Name of donor: University of Salford | Overseas visits 80ef1083 | 2014-09-22 | Hazel Blears uk.org.publicwhip/member/40517 | Hazel Blears uk.org.publicwhip/person/10048 | 14 | 2014-09-22-80ef1083-10048-0 |
2c6176b301b59ec8d9456f1d6def7695c9cc7b00 | Address of donor: Faraday House, Salford M5 4WT | Overseas visits 80ef1083 | 2014-09-22 | Hazel Blears uk.org.publicwhip/member/40517 | Hazel Blears uk.org.publicwhip/person/10048 | 15 | 2014-09-22-80ef1083-10048-0 |
ce1f1e7fdf8740ccd8c81ee8eabdc6e1bb1f5c94 | Amount of donation (or estimate of the probable value): Flight costing £335.49 and hotel costing £330; £665.49 in total | Overseas visits 80ef1083 | 2014-09-22 | Hazel Blears uk.org.publicwhip/member/40517 | Hazel Blears uk.org.publicwhip/person/10048 | 16 | 2014-09-22-80ef1083-10048-0 |
d9d5374f1a8c52154650f649e54a3f544b10cc9f | Destination of visit: Isle of Man | Overseas visits 80ef1083 | 2014-09-22 | Hazel Blears uk.org.publicwhip/member/40517 | Hazel Blears uk.org.publicwhip/person/10048 | 17 | 2014-09-22-80ef1083-10048-0 |
902867dad592e123d31029bb9641f7ab580ab9f1 | Date of visit: 10-11 April 2014 | Overseas visits 80ef1083 | 2014-09-22 | Hazel Blears uk.org.publicwhip/member/40517 | Hazel Blears uk.org.publicwhip/person/10048 | 18 | 2014-09-22-80ef1083-10048-0 |
6b7978cd6da3a0e125d1d7e0f85dec9631801ec1 | Purpose of visit: In support of promotion of work of University of Salford | Overseas visits 80ef1083 | 2014-09-22 | Hazel Blears uk.org.publicwhip/member/40517 | Hazel Blears uk.org.publicwhip/person/10048 | 19 | 2014-09-22-80ef1083-10048-0 |
ff771fb6321fd9e68a5cf6a5d6750f7b66ba10a9 | (Registered 9 June 2014) | Overseas visits 80ef1083 | 2014-09-22 | Hazel Blears uk.org.publicwhip/member/40517 | Hazel Blears uk.org.publicwhip/person/10048 | 20 | 2014-09-22-80ef1083-10048-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");