items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
14 rows where record_id = "2014-04-07-decaa699-11093-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 |
---|---|---|---|---|---|---|---|
bdd0c33ef4c3d5d96c39aa5edab09660b29c5539 | Name of donor: Israel Ministry of Foreign Affairs and Israeli Embassy London | Overseas visits decaa699 | 2014-04-07 | John Mann uk.org.publicwhip/member/40061 | John Mann uk.org.publicwhip/person/11093 | 0 | 2014-04-07-decaa699-11093-0 |
a5bedaec2c8a58c980ec655f067697cf51ceed99 | Address of donor: 9 Yitzhak Rabin Blvd, Kiryat Ben-Gurion, Jerusalem 91035 | Overseas visits decaa699 | 2014-04-07 | John Mann uk.org.publicwhip/member/40061 | John Mann uk.org.publicwhip/person/11093 | 1 | 2014-04-07-decaa699-11093-0 |
c8e4b347efac71343d4a705f2d06b30ba3e7b95a | Amount of donation (or estimate of the probable value): return flight to Tel Aviv and accommodation in Jerusalem, with a total value of £852.56 | Overseas visits decaa699 | 2014-04-07 | John Mann uk.org.publicwhip/member/40061 | John Mann uk.org.publicwhip/person/11093 | 2 | 2014-04-07-decaa699-11093-0 |
68d997d81b80f1d3e2176f44bb35ad6cb495d924 | Destination of visit: Jerusalem | Overseas visits decaa699 | 2014-04-07 | John Mann uk.org.publicwhip/member/40061 | John Mann uk.org.publicwhip/person/11093 | 3 | 2014-04-07-decaa699-11093-0 |
eec9dfed73c4664d037247ca012b3db8557eca67 | Date of visit: 28 – 31 May 2013 | Overseas visits decaa699 | 2014-04-07 | John Mann uk.org.publicwhip/member/40061 | John Mann uk.org.publicwhip/person/11093 | 4 | 2014-04-07-decaa699-11093-0 |
2468e230566a3b363f3ceb89b535076c321309b2 | Purpose of visit: Attendance and speaker at the Global Forum on Combating Antisemitism, organised by the Ministry of Foreign Affairs, Israel. | Overseas visits decaa699 | 2014-04-07 | John Mann uk.org.publicwhip/member/40061 | John Mann uk.org.publicwhip/person/11093 | 5 | 2014-04-07-decaa699-11093-0 |
71fdf8f94991b3c4b7b0e2a86336a09f6b247802 | (Registered 4 July 2013) | Overseas visits decaa699 | 2014-04-07 | John Mann uk.org.publicwhip/member/40061 | John Mann uk.org.publicwhip/person/11093 | 6 | 2014-04-07-decaa699-11093-0 |
698cd25ea9ae23ce47aaba1f6023cb91b969aaf7 | Name of donor: European Parliamentary Forum on Population and Development | Overseas visits decaa699 | 2014-04-07 | John Mann uk.org.publicwhip/member/40061 | John Mann uk.org.publicwhip/person/11093 | 7 | 2014-04-07-decaa699-11093-0 |
00f9e8a0b53e8a0613a9c69160d61aee718d06cd | Address of donor: Rue Montoyer 23, 1000 Brussels, Belgium | Overseas visits decaa699 | 2014-04-07 | John Mann uk.org.publicwhip/member/40061 | John Mann uk.org.publicwhip/person/11093 | 8 | 2014-04-07-decaa699-11093-0 |
46896980225ef4ad06b5d7be0f8fe2148c47e2fe | Amount of donation (or estimate of the probable value): flights, internal travel and accommodation with an approximate value of £2,303.04 | Overseas visits decaa699 | 2014-04-07 | John Mann uk.org.publicwhip/member/40061 | John Mann uk.org.publicwhip/person/11093 | 9 | 2014-04-07-decaa699-11093-0 |
a98c754f3ccb627ec624cb5a7ebcbc4b51508639 | Destination of visit: Myanmar (Burma) | Overseas visits decaa699 | 2014-04-07 | John Mann uk.org.publicwhip/member/40061 | John Mann uk.org.publicwhip/person/11093 | 10 | 2014-04-07-decaa699-11093-0 |
2ba9af2e881e66e50a2b23b96aa5da9778cf6ca3 | Date of visit: 17-25 July 2013 | Overseas visits decaa699 | 2014-04-07 | John Mann uk.org.publicwhip/member/40061 | John Mann uk.org.publicwhip/person/11093 | 11 | 2014-04-07-decaa699-11093-0 |
2f32f0cef2b9c3ea2bc3ba94698779bd3c45d3d5 | Purpose of visit: visit organised by All Party Parliamentary Group on Population, Development and Reproductive Health, to build awareness of sexual and reproductive health and rights/maternal health/family planning issues, with a specific focus on programmes in fragile states. | Overseas visits decaa699 | 2014-04-07 | John Mann uk.org.publicwhip/member/40061 | John Mann uk.org.publicwhip/person/11093 | 12 | 2014-04-07-decaa699-11093-0 |
dc4e10a6b06843010c36d6ea036b45b9144f288b | (Registered 20 August 2013) | Overseas visits decaa699 | 2014-04-07 | John Mann uk.org.publicwhip/member/40061 | John Mann uk.org.publicwhip/person/11093 | 13 | 2014-04-07-decaa699-11093-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");