items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
14 rows where record_id = "2012-07-30-80ef1083-10180-0" sorted by person_id
This data as json, CSV (advanced)
date (date) 1 ✖
- 2012-07-30 14
hash | item | category_id | date | member_id | person_id ▼ | sort_order | record_id |
---|---|---|---|---|---|---|---|
18ac04d76c4e01f7cdac0f2985a789657b0def0c | Name of donor: Foundation for Social Studies and Analysis (FAES) | Overseas visits 80ef1083 | 2012-07-30 | Iain Duncan Smith uk.org.publicwhip/member/40167 | Iain Duncan Smith uk.org.publicwhip/person/10180 | 0 | 2012-07-30-80ef1083-10180-0 |
0782d2f940ddbfc03d01b46f8ef2261445550756 | Address of donor: c/Maria de Molina, 40, 6th floor, 28006 Madrid, Spain | Overseas visits 80ef1083 | 2012-07-30 | Iain Duncan Smith uk.org.publicwhip/member/40167 | Iain Duncan Smith uk.org.publicwhip/person/10180 | 1 | 2012-07-30-80ef1083-10180-0 |
7731b9ca8e96556c53b32021828168931ac46ff9 | 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-07-30 | Iain Duncan Smith uk.org.publicwhip/member/40167 | Iain Duncan Smith uk.org.publicwhip/person/10180 | 2 | 2012-07-30-80ef1083-10180-0 |
cf1df0c51ac1c1fdc35cc199b0820bb38522abe4 | Destination of visit: Madrid | Overseas visits 80ef1083 | 2012-07-30 | Iain Duncan Smith uk.org.publicwhip/member/40167 | Iain Duncan Smith uk.org.publicwhip/person/10180 | 3 | 2012-07-30-80ef1083-10180-0 |
5629b6632dc7d67bf90d0defc45e43384cd8f92d | Date of visit: 30 June 2011 and 1 July 2011 | Overseas visits 80ef1083 | 2012-07-30 | Iain Duncan Smith uk.org.publicwhip/member/40167 | Iain Duncan Smith uk.org.publicwhip/person/10180 | 4 | 2012-07-30-80ef1083-10180-0 |
f376dba02ca173816c9e198b1323dc8cacb40960 | 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-07-30 | Iain Duncan Smith uk.org.publicwhip/member/40167 | Iain Duncan Smith uk.org.publicwhip/person/10180 | 5 | 2012-07-30-80ef1083-10180-0 |
4bbe16aae4a0c612da1313bd1fa9e4bbba46485d | (Registered 14 September 2011) | Overseas visits 80ef1083 | 2012-07-30 | Iain Duncan Smith uk.org.publicwhip/member/40167 | Iain Duncan Smith uk.org.publicwhip/person/10180 | 6 | 2012-07-30-80ef1083-10180-0 |
36845e4bbbf90dcdb190e2fa6e3b87a83c270150 | Name of donor: (1) The Menzies Centre; (2) The Maxim Institute | Overseas visits 80ef1083 | 2012-07-30 | Iain Duncan Smith uk.org.publicwhip/member/40167 | Iain Duncan Smith uk.org.publicwhip/person/10180 | 7 | 2012-07-30-80ef1083-10180-0 |
59232a05a6ece91b2a96b45116b8a5e5cabf7a39 | Address of donor (1) PO Box 6091, Kingston, ACT 2604, New Zealand; (2) 29 Cape Horn Road, Hillsborough, Auckland, Australia | Overseas visits 80ef1083 | 2012-07-30 | Iain Duncan Smith uk.org.publicwhip/member/40167 | Iain Duncan Smith uk.org.publicwhip/person/10180 | 8 | 2012-07-30-80ef1083-10180-0 |
c31572e1d120cf130acdb1e5d223c8b150c67309 | 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-07-30 | Iain Duncan Smith uk.org.publicwhip/member/40167 | Iain Duncan Smith uk.org.publicwhip/person/10180 | 9 | 2012-07-30-80ef1083-10180-0 |
e0220ebc02f58808bb17d11bcf23e5a0e4d6e635 | Destination of visit: Australia and New Zealand | Overseas visits 80ef1083 | 2012-07-30 | Iain Duncan Smith uk.org.publicwhip/member/40167 | Iain Duncan Smith uk.org.publicwhip/person/10180 | 10 | 2012-07-30-80ef1083-10180-0 |
5c0e538d4485e755002d6f38b75fe8f8da6d7b25 | Date of visit: 19 to 29 July 2011 | Overseas visits 80ef1083 | 2012-07-30 | Iain Duncan Smith uk.org.publicwhip/member/40167 | Iain Duncan Smith uk.org.publicwhip/person/10180 | 11 | 2012-07-30-80ef1083-10180-0 |
87df7fbe1279c9190352f19d3f28d1310940683e | 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-07-30 | Iain Duncan Smith uk.org.publicwhip/member/40167 | Iain Duncan Smith uk.org.publicwhip/person/10180 | 12 | 2012-07-30-80ef1083-10180-0 |
995a567007fc55a04a6bc1bd9c2638dca2864885 | (Registered 10 October 2011 ) | Overseas visits 80ef1083 | 2012-07-30 | Iain Duncan Smith uk.org.publicwhip/member/40167 | Iain Duncan Smith uk.org.publicwhip/person/10180 | 13 | 2012-07-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");