items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
14 rows where record_id = "2013-04-08-80ef1083-25150-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 |
---|---|---|---|---|---|---|---|
184d30f016e7995b98114a709b97e448b5441e5b | Name of donor: Sir Joseph Hotung Programme | Overseas visits 80ef1083 | 2013-04-08 | Seema Malhotra uk.org.publicwhip/member/40689 | Seema Malhotra uk.org.publicwhip/person/25150 | 0 | 2013-04-08-80ef1083-25150-0 |
1df7efa36b2a75c1cd51ba3fb03b5ec91ab47f17 | Address of donor: School of Oriental and African Studies, Thornhaugh Street, Russell Square, London WC1H OXG | Overseas visits 80ef1083 | 2013-04-08 | Seema Malhotra uk.org.publicwhip/member/40689 | Seema Malhotra uk.org.publicwhip/person/25150 | 1 | 2013-04-08-80ef1083-25150-0 |
056ade1ce84a8261fdec7ac91f54c578e8162be2 | Amount of donation (or estimate of the probable value): flights, internal travel, food and four nights’ accommodation with a total value of £1,200 | Overseas visits 80ef1083 | 2013-04-08 | Seema Malhotra uk.org.publicwhip/member/40689 | Seema Malhotra uk.org.publicwhip/person/25150 | 2 | 2013-04-08-80ef1083-25150-0 |
0005900db8f1d6048d5a3889910b399a18cbfb6e | Destination of visit: Israel and Palestinian territories. | Overseas visits 80ef1083 | 2013-04-08 | Seema Malhotra uk.org.publicwhip/member/40689 | Seema Malhotra uk.org.publicwhip/person/25150 | 3 | 2013-04-08-80ef1083-25150-0 |
d331d7503e255a87d7aacf3e0bca09127d9a4f86 | Date of visit: 17-21 September 2012 | Overseas visits 80ef1083 | 2013-04-08 | Seema Malhotra uk.org.publicwhip/member/40689 | Seema Malhotra uk.org.publicwhip/person/25150 | 4 | 2013-04-08-80ef1083-25150-0 |
246b3f46a102839c30546f6ca59dd823f2f1379e | Purpose of visit: Delegation to the West Bank with Council for Arab-British Understanding | Overseas visits 80ef1083 | 2013-04-08 | Seema Malhotra uk.org.publicwhip/member/40689 | Seema Malhotra uk.org.publicwhip/person/25150 | 5 | 2013-04-08-80ef1083-25150-0 |
2ac6541315d7704c66a47acf6d2781d3077965da | (Registered 12 October 2012) | Overseas visits 80ef1083 | 2013-04-08 | Seema Malhotra uk.org.publicwhip/member/40689 | Seema Malhotra uk.org.publicwhip/person/25150 | 6 | 2013-04-08-80ef1083-25150-0 |
91ff331c12fe23bcbb33ddbaceabcbd927066794 | Name of donor: Deutscher Sparkassen-und Giroverband (German Savings Banks Association) | Overseas visits 80ef1083 | 2013-04-08 | Seema Malhotra uk.org.publicwhip/member/40689 | Seema Malhotra uk.org.publicwhip/person/25150 | 7 | 2013-04-08-80ef1083-25150-0 |
3f5838c7714734b5e82f5468d8d8095e929c0005 | Address of donor: Charlottenstr. 47, 10117 Berlin, Germany | Overseas visits 80ef1083 | 2013-04-08 | Seema Malhotra uk.org.publicwhip/member/40689 | Seema Malhotra uk.org.publicwhip/person/25150 | 8 | 2013-04-08-80ef1083-25150-0 |
bfc478b979eb850af8d00242b263110d178b0a61 | Amount of donation (or estimate of the probable value): flights and hotel accommodation; total value £365 | Overseas visits 80ef1083 | 2013-04-08 | Seema Malhotra uk.org.publicwhip/member/40689 | Seema Malhotra uk.org.publicwhip/person/25150 | 9 | 2013-04-08-80ef1083-25150-0 |
e80f60d9e985d54747fcea0726f697a389852258 | Destination of visit: Germany | Overseas visits 80ef1083 | 2013-04-08 | Seema Malhotra uk.org.publicwhip/member/40689 | Seema Malhotra uk.org.publicwhip/person/25150 | 10 | 2013-04-08-80ef1083-25150-0 |
bcf5c36d3af5312199b3bb2a031ba4da78e00620 | Date of visit: 29-30 November 2012 | Overseas visits 80ef1083 | 2013-04-08 | Seema Malhotra uk.org.publicwhip/member/40689 | Seema Malhotra uk.org.publicwhip/person/25150 | 11 | 2013-04-08-80ef1083-25150-0 |
fd33452eb8a5381254656d0891ec294edd55f00e | Purpose of visit: policy fact-finding visit | Overseas visits 80ef1083 | 2013-04-08 | Seema Malhotra uk.org.publicwhip/member/40689 | Seema Malhotra uk.org.publicwhip/person/25150 | 12 | 2013-04-08-80ef1083-25150-0 |
a44038c2990cbd48d7a5944a1c712aafd526e70c | (Registered 19 December 2012) | Overseas visits 80ef1083 | 2013-04-08 | Seema Malhotra uk.org.publicwhip/member/40689 | Seema Malhotra uk.org.publicwhip/person/25150 | 13 | 2013-04-08-80ef1083-25150-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");