items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
14 rows where record_id = "2011-11-16-80ef1083-10180-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 |
---|---|---|---|---|---|---|---|
b372f18ac060eb9e89a248f9e4a8bfa6c433fd9f | Name of donor: Foundation for Social Studies and Analysis (FAES) | Overseas visits 80ef1083 | 2011-11-16 | Iain Duncan Smith uk.org.publicwhip/member/40167 | Iain Duncan Smith uk.org.publicwhip/person/10180 | 0 | 2011-11-16-80ef1083-10180-0 |
e9f0437b53fc821205779e952191818dcafa1a79 | Address of donor: c/Maria de Molina, 40, 6th floor, 28006 Madrid, Spain | Overseas visits 80ef1083 | 2011-11-16 | Iain Duncan Smith uk.org.publicwhip/member/40167 | Iain Duncan Smith uk.org.publicwhip/person/10180 | 1 | 2011-11-16-80ef1083-10180-0 |
978fa0bd4208ba35bc1e88b5c31619eb5dfcfabb | Amount of donation (or estimate of the probable value): Return flight to Madrid, accommodation for one night in Madrid and car, costing £1,055 | Overseas visits 80ef1083 | 2011-11-16 | Iain Duncan Smith uk.org.publicwhip/member/40167 | Iain Duncan Smith uk.org.publicwhip/person/10180 | 2 | 2011-11-16-80ef1083-10180-0 |
2e4b40bdd6b89f9e8dcdb8e7b15c744a9e5ca6ea | Destination of visit: Madrid | Overseas visits 80ef1083 | 2011-11-16 | Iain Duncan Smith uk.org.publicwhip/member/40167 | Iain Duncan Smith uk.org.publicwhip/person/10180 | 3 | 2011-11-16-80ef1083-10180-0 |
3cb0f416a9a5feb5eb3c68707d72457d90672225 | Date of visit: 30 June 2011 and 1 July 2011 | Overseas visits 80ef1083 | 2011-11-16 | Iain Duncan Smith uk.org.publicwhip/member/40167 | Iain Duncan Smith uk.org.publicwhip/person/10180 | 4 | 2011-11-16-80ef1083-10180-0 |
f43f5400e3a8f44301352b1ff06786ef30d1cbf5 | Purpose of visit: to give a keynote speech, at the invitation of the Spanish government, at the opening of the international section of the FAES campus. | Overseas visits 80ef1083 | 2011-11-16 | Iain Duncan Smith uk.org.publicwhip/member/40167 | Iain Duncan Smith uk.org.publicwhip/person/10180 | 5 | 2011-11-16-80ef1083-10180-0 |
f9a5e5d75d39868f884a981fffc6fdbd5019b4b2 | (Registered 14 September 2011) | Overseas visits 80ef1083 | 2011-11-16 | Iain Duncan Smith uk.org.publicwhip/member/40167 | Iain Duncan Smith uk.org.publicwhip/person/10180 | 6 | 2011-11-16-80ef1083-10180-0 |
2a11c90b138e9aa22f9066e9ce56c46a3447720f | Name of donor: (1) The Menzies Centre; (2) The Maxim Institute | Overseas visits 80ef1083 | 2011-11-16 | Iain Duncan Smith uk.org.publicwhip/member/40167 | Iain Duncan Smith uk.org.publicwhip/person/10180 | 7 | 2011-11-16-80ef1083-10180-0 |
cd629d7d44d72217c51bdc4da652e6501ac1b18e | Address of donor (1) PO Box 6091, Kingston, ACT 2604, New Zealand; (2) 29 Cape Horn Road, Hillsborough, Auckland, Australia | Overseas visits 80ef1083 | 2011-11-16 | Iain Duncan Smith uk.org.publicwhip/member/40167 | Iain Duncan Smith uk.org.publicwhip/person/10180 | 8 | 2011-11-16-80ef1083-10180-0 |
bfba61d87e0f43c401f127c330d333659cf6fd4d | Amount of donation (or estimate of the probable value): (1) accommodation, food and car hire valued at £947.77 in total; (2) Return flights from London to New Zealand to Australia and accommodation valued at £3491.70 in total | Overseas visits 80ef1083 | 2011-11-16 | Iain Duncan Smith uk.org.publicwhip/member/40167 | Iain Duncan Smith uk.org.publicwhip/person/10180 | 9 | 2011-11-16-80ef1083-10180-0 |
06b1e32e444b229c51a1d4842fdf7c366332d70c | Destination of visit: Australia and New Zealand | Overseas visits 80ef1083 | 2011-11-16 | Iain Duncan Smith uk.org.publicwhip/member/40167 | Iain Duncan Smith uk.org.publicwhip/person/10180 | 10 | 2011-11-16-80ef1083-10180-0 |
32d42e2e910a7ae087cce489a33fb9bd64ad670b | Date of visit: 19 to 29 July 2011 | Overseas visits 80ef1083 | 2011-11-16 | Iain Duncan Smith uk.org.publicwhip/member/40167 | Iain Duncan Smith uk.org.publicwhip/person/10180 | 11 | 2011-11-16-80ef1083-10180-0 |
8f307afbeeff9a7564a18dc9f5f25ae85cd32e51 | Purpose of visit: I was invited by the Liberal Party of Australia to give the John Howard Lecture and in New Zealand to look at its welfare programme | Overseas visits 80ef1083 | 2011-11-16 | Iain Duncan Smith uk.org.publicwhip/member/40167 | Iain Duncan Smith uk.org.publicwhip/person/10180 | 12 | 2011-11-16-80ef1083-10180-0 |
3f5a3350ae91ddf208833592111a61d835ce9339 | (Registered 10 October 2011 ) | Overseas visits 80ef1083 | 2011-11-16 | Iain Duncan Smith uk.org.publicwhip/member/40167 | Iain Duncan Smith uk.org.publicwhip/person/10180 | 13 | 2011-11-16-80ef1083-10180-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");