items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
14 rows where record_id = "2011-11-29-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 |
---|---|---|---|---|---|---|---|
2d45b3da036433645eee4f366a15a9481c477417 | Name of donor: Foundation for Social Studies and Analysis (FAES) | Overseas visits 80ef1083 | 2011-11-29 | Iain Duncan Smith uk.org.publicwhip/member/40167 | Iain Duncan Smith uk.org.publicwhip/person/10180 | 0 | 2011-11-29-80ef1083-10180-0 |
1dcc9ed169af2d0e0aa7076896d4ca73227c82df | Address of donor: c/Maria de Molina, 40, 6th floor, 28006 Madrid, Spain | Overseas visits 80ef1083 | 2011-11-29 | Iain Duncan Smith uk.org.publicwhip/member/40167 | Iain Duncan Smith uk.org.publicwhip/person/10180 | 1 | 2011-11-29-80ef1083-10180-0 |
652153dc00e7ab52fbb9a87e7d666dd234414eec | 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-29 | Iain Duncan Smith uk.org.publicwhip/member/40167 | Iain Duncan Smith uk.org.publicwhip/person/10180 | 2 | 2011-11-29-80ef1083-10180-0 |
aac9a965f81752fead67509a527ced308920f9ec | Destination of visit: Madrid | Overseas visits 80ef1083 | 2011-11-29 | Iain Duncan Smith uk.org.publicwhip/member/40167 | Iain Duncan Smith uk.org.publicwhip/person/10180 | 3 | 2011-11-29-80ef1083-10180-0 |
9e04aec8680aa59267853fdb7c99dfbdc6824f79 | Date of visit: 30 June 2011 and 1 July 2011 | Overseas visits 80ef1083 | 2011-11-29 | Iain Duncan Smith uk.org.publicwhip/member/40167 | Iain Duncan Smith uk.org.publicwhip/person/10180 | 4 | 2011-11-29-80ef1083-10180-0 |
16073c7002d02951b2c3331c053dc9ba77f70364 | 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-29 | Iain Duncan Smith uk.org.publicwhip/member/40167 | Iain Duncan Smith uk.org.publicwhip/person/10180 | 5 | 2011-11-29-80ef1083-10180-0 |
17061f2906ac8c748d7214bf9b766cc160e0b958 | (Registered 14 September 2011) | Overseas visits 80ef1083 | 2011-11-29 | Iain Duncan Smith uk.org.publicwhip/member/40167 | Iain Duncan Smith uk.org.publicwhip/person/10180 | 6 | 2011-11-29-80ef1083-10180-0 |
2f31200e7203204122f3b2258d774749dc00037e | Name of donor: (1) The Menzies Centre; (2) The Maxim Institute | Overseas visits 80ef1083 | 2011-11-29 | Iain Duncan Smith uk.org.publicwhip/member/40167 | Iain Duncan Smith uk.org.publicwhip/person/10180 | 7 | 2011-11-29-80ef1083-10180-0 |
9c53c0dcc1f8063c55ab3f87459dba34dc09598d | 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-29 | Iain Duncan Smith uk.org.publicwhip/member/40167 | Iain Duncan Smith uk.org.publicwhip/person/10180 | 8 | 2011-11-29-80ef1083-10180-0 |
a2b32621d89c67edd6294f5441becefed88bfd63 | 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-29 | Iain Duncan Smith uk.org.publicwhip/member/40167 | Iain Duncan Smith uk.org.publicwhip/person/10180 | 9 | 2011-11-29-80ef1083-10180-0 |
ec736ec9c685e08e85268606eb1ca21292eaea46 | Destination of visit: Australia and New Zealand | Overseas visits 80ef1083 | 2011-11-29 | Iain Duncan Smith uk.org.publicwhip/member/40167 | Iain Duncan Smith uk.org.publicwhip/person/10180 | 10 | 2011-11-29-80ef1083-10180-0 |
04da569e2a38953e014e1b6763176d3de3a23a7b | Date of visit: 19 to 29 July 2011 | Overseas visits 80ef1083 | 2011-11-29 | Iain Duncan Smith uk.org.publicwhip/member/40167 | Iain Duncan Smith uk.org.publicwhip/person/10180 | 11 | 2011-11-29-80ef1083-10180-0 |
f85d21feab89b58bef8bb9624be294cb0f64f2a5 | 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-29 | Iain Duncan Smith uk.org.publicwhip/member/40167 | Iain Duncan Smith uk.org.publicwhip/person/10180 | 12 | 2011-11-29-80ef1083-10180-0 |
f97794f6de9bff747a860a0cbe9fb907952f9f49 | (Registered 10 October 2011 ) | Overseas visits 80ef1083 | 2011-11-29 | Iain Duncan Smith uk.org.publicwhip/member/40167 | Iain Duncan Smith uk.org.publicwhip/person/10180 | 13 | 2011-11-29-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");