items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
14 rows where record_id = "2012-04-30-80ef1083-10180-0" sorted by record_id
This data as json, CSV (advanced)
Suggested facets: date (date)
hash | item | category_id | date | member_id | person_id | sort_order | record_id ▼ |
---|---|---|---|---|---|---|---|
daf3299a439489b6c6cf580e63db0e5f90520aa0 | Name of donor: Foundation for Social Studies and Analysis (FAES) | Overseas visits 80ef1083 | 2012-04-30 | Iain Duncan Smith uk.org.publicwhip/member/40167 | Iain Duncan Smith uk.org.publicwhip/person/10180 | 0 | 2012-04-30-80ef1083-10180-0 |
3d397675b547f0e42d9b98f94354ac5e29e0b6c1 | Address of donor: c/Maria de Molina, 40, 6th floor, 28006 Madrid, Spain | Overseas visits 80ef1083 | 2012-04-30 | Iain Duncan Smith uk.org.publicwhip/member/40167 | Iain Duncan Smith uk.org.publicwhip/person/10180 | 1 | 2012-04-30-80ef1083-10180-0 |
afdbb7c01213fdc9f6b8f6d6a446340ffa25978e | 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 | 2012-04-30 | Iain Duncan Smith uk.org.publicwhip/member/40167 | Iain Duncan Smith uk.org.publicwhip/person/10180 | 2 | 2012-04-30-80ef1083-10180-0 |
3b75fbed9ac697dacc80c8cef9dfda62aef7a8ff | Destination of visit: Madrid | Overseas visits 80ef1083 | 2012-04-30 | Iain Duncan Smith uk.org.publicwhip/member/40167 | Iain Duncan Smith uk.org.publicwhip/person/10180 | 3 | 2012-04-30-80ef1083-10180-0 |
7afca86679ab33b080acf798263234efef49c81e | Date of visit: 30 June 2011 and 1 July 2011 | Overseas visits 80ef1083 | 2012-04-30 | Iain Duncan Smith uk.org.publicwhip/member/40167 | Iain Duncan Smith uk.org.publicwhip/person/10180 | 4 | 2012-04-30-80ef1083-10180-0 |
0297fc272941c1f9a853de7d9a0c0e91abf06b48 | 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 | 2012-04-30 | Iain Duncan Smith uk.org.publicwhip/member/40167 | Iain Duncan Smith uk.org.publicwhip/person/10180 | 5 | 2012-04-30-80ef1083-10180-0 |
67bededddd6e7707510539900f2607dfeb8ada8c | (Registered 14 September 2011) | Overseas visits 80ef1083 | 2012-04-30 | Iain Duncan Smith uk.org.publicwhip/member/40167 | Iain Duncan Smith uk.org.publicwhip/person/10180 | 6 | 2012-04-30-80ef1083-10180-0 |
6a8ca876462de1c73399ba9578f61e1b1b0d961c | Name of donor: (1) The Menzies Centre; (2) The Maxim Institute | Overseas visits 80ef1083 | 2012-04-30 | Iain Duncan Smith uk.org.publicwhip/member/40167 | Iain Duncan Smith uk.org.publicwhip/person/10180 | 7 | 2012-04-30-80ef1083-10180-0 |
9743d44a2f79a11b0aefe5fb2f7155b33f8a1be5 | Address of donor (1) PO Box 6091, Kingston, ACT 2604, New Zealand; (2) 29 Cape Horn Road, Hillsborough, Auckland, Australia | Overseas visits 80ef1083 | 2012-04-30 | Iain Duncan Smith uk.org.publicwhip/member/40167 | Iain Duncan Smith uk.org.publicwhip/person/10180 | 8 | 2012-04-30-80ef1083-10180-0 |
caeb0d6e2e15857e79dff7c848d9ff4cfc1c6f49 | 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 | 2012-04-30 | Iain Duncan Smith uk.org.publicwhip/member/40167 | Iain Duncan Smith uk.org.publicwhip/person/10180 | 9 | 2012-04-30-80ef1083-10180-0 |
e8c9ce3491566bafee94d0fc52469b7892e29669 | Destination of visit: Australia and New Zealand | Overseas visits 80ef1083 | 2012-04-30 | Iain Duncan Smith uk.org.publicwhip/member/40167 | Iain Duncan Smith uk.org.publicwhip/person/10180 | 10 | 2012-04-30-80ef1083-10180-0 |
eecc360483579646a64b5920c4a316fa0c1bb92f | Date of visit: 19 to 29 July 2011 | Overseas visits 80ef1083 | 2012-04-30 | Iain Duncan Smith uk.org.publicwhip/member/40167 | Iain Duncan Smith uk.org.publicwhip/person/10180 | 11 | 2012-04-30-80ef1083-10180-0 |
4a96073fd3890364b8b0326bba7cf3ac44e39ced | 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 | 2012-04-30 | Iain Duncan Smith uk.org.publicwhip/member/40167 | Iain Duncan Smith uk.org.publicwhip/person/10180 | 12 | 2012-04-30-80ef1083-10180-0 |
1f71257dcfb526bb6dd6d5a339f99990e0d90e00 | (Registered 10 October 2011 ) | Overseas visits 80ef1083 | 2012-04-30 | Iain Duncan Smith uk.org.publicwhip/member/40167 | Iain Duncan Smith uk.org.publicwhip/person/10180 | 13 | 2012-04-30-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");