items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
14 rows where record_id = "2014-03-21-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 |
---|---|---|---|---|---|---|---|
17ab870f203e908b3fdfce2ee6daf45d37aeb15b | Name of donor: Israel Ministry of Foreign Affairs and Israeli Embassy London | Overseas visits decaa699 | 2014-03-21 | John Mann uk.org.publicwhip/member/40061 | John Mann uk.org.publicwhip/person/11093 | 0 | 2014-03-21-decaa699-11093-0 |
b1f64a3a620aadeaee27b97477b1ba613e6c01a0 | Address of donor: 9 Yitzhak Rabin Blvd, Kiryat Ben-Gurion, Jerusalem 91035 | Overseas visits decaa699 | 2014-03-21 | John Mann uk.org.publicwhip/member/40061 | John Mann uk.org.publicwhip/person/11093 | 1 | 2014-03-21-decaa699-11093-0 |
6ec52358ecafec5879c9d9df067d6b73973bf973 | 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-03-21 | John Mann uk.org.publicwhip/member/40061 | John Mann uk.org.publicwhip/person/11093 | 2 | 2014-03-21-decaa699-11093-0 |
183d578e8953ff2a242df2d454bf351256f8b09f | Destination of visit: Jerusalem | Overseas visits decaa699 | 2014-03-21 | John Mann uk.org.publicwhip/member/40061 | John Mann uk.org.publicwhip/person/11093 | 3 | 2014-03-21-decaa699-11093-0 |
a5cde48cdb09780cb8cb19b383ef0e89906998b7 | Date of visit: 28 – 31 May 2013 | Overseas visits decaa699 | 2014-03-21 | John Mann uk.org.publicwhip/member/40061 | John Mann uk.org.publicwhip/person/11093 | 4 | 2014-03-21-decaa699-11093-0 |
70887d412d672926b7382f24b382d76511ebc626 | 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-03-21 | John Mann uk.org.publicwhip/member/40061 | John Mann uk.org.publicwhip/person/11093 | 5 | 2014-03-21-decaa699-11093-0 |
f408ae7d3fe8ec4aa20a8780ea6904f6d6f32dd5 | (Registered 4 July 2013) | Overseas visits decaa699 | 2014-03-21 | John Mann uk.org.publicwhip/member/40061 | John Mann uk.org.publicwhip/person/11093 | 6 | 2014-03-21-decaa699-11093-0 |
e8edb1249c2b8960ae07cebcac10adb6bcc74086 | Name of donor: European Parliamentary Forum on Population and Development | Overseas visits decaa699 | 2014-03-21 | John Mann uk.org.publicwhip/member/40061 | John Mann uk.org.publicwhip/person/11093 | 7 | 2014-03-21-decaa699-11093-0 |
0c2c2a8d4a298127b1b6653dbbee9fff5c8ea468 | Address of donor: Rue Montoyer 23, 1000 Brussels, Belgium | Overseas visits decaa699 | 2014-03-21 | John Mann uk.org.publicwhip/member/40061 | John Mann uk.org.publicwhip/person/11093 | 8 | 2014-03-21-decaa699-11093-0 |
cbf575c9d10047314869c772b2e47f40504db6b0 | 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-03-21 | John Mann uk.org.publicwhip/member/40061 | John Mann uk.org.publicwhip/person/11093 | 9 | 2014-03-21-decaa699-11093-0 |
f108235e7c21ac741b0384621b36c932196a8611 | Destination of visit: Myanmar (Burma) | Overseas visits decaa699 | 2014-03-21 | John Mann uk.org.publicwhip/member/40061 | John Mann uk.org.publicwhip/person/11093 | 10 | 2014-03-21-decaa699-11093-0 |
dc7468b5396a0b2f071c70de0eabdb47230d9624 | Date of visit: 17-25 July 2013 | Overseas visits decaa699 | 2014-03-21 | John Mann uk.org.publicwhip/member/40061 | John Mann uk.org.publicwhip/person/11093 | 11 | 2014-03-21-decaa699-11093-0 |
8a003941f3eef089264325055c73e88fae58f237 | 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-03-21 | John Mann uk.org.publicwhip/member/40061 | John Mann uk.org.publicwhip/person/11093 | 12 | 2014-03-21-decaa699-11093-0 |
59a8cf6f6a520f3124641203fcc6b4e6d23ee459 | (Registered 20 August 2013) | Overseas visits decaa699 | 2014-03-21 | John Mann uk.org.publicwhip/member/40061 | John Mann uk.org.publicwhip/person/11093 | 13 | 2014-03-21-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");