items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
8 rows where record_id = "2012-04-30-80ef1083-10431-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 |
---|---|---|---|---|---|---|---|
8d1767867b859265641feae39017d7ec52694821 | Name of donor: Nominet, the .uk Domain Registry | Overseas visits 80ef1083 | 2012-04-30 | Alun Michael uk.org.publicwhip/member/40147 | Alun Michael uk.org.publicwhip/person/10431 | 0 | 2012-04-30-80ef1083-10431-0 |
bf64beee36ce55cc3bca35135ecfcd782379dab9 | Address of donor: Minerva House, Edmund Halley Road, Oxford Science Park, Oxford, OX4 | Overseas visits 80ef1083 | 2012-04-30 | Alun Michael uk.org.publicwhip/member/40147 | Alun Michael uk.org.publicwhip/person/10431 | 1 | 2012-04-30-80ef1083-10431-0 |
608cf2bbefd1e5d4503adbd485f9699e9dfabb66 | 4DQ. | Overseas visits 80ef1083 | 2012-04-30 | Alun Michael uk.org.publicwhip/member/40147 | Alun Michael uk.org.publicwhip/person/10431 | 2 | 2012-04-30-80ef1083-10431-0 |
ba528b6bf903a591db3350ba4a8375f6c07f0281 | Amount of donation (or estimate of the probable value): flights, hotel and incidental costs; | Overseas visits 80ef1083 | 2012-04-30 | Alun Michael uk.org.publicwhip/member/40147 | Alun Michael uk.org.publicwhip/person/10431 | 3 | 2012-04-30-80ef1083-10431-0 |
5c92c9d7942fa2b9d4888cf86cceec3246fb4b63 | total value £3,300 | Overseas visits 80ef1083 | 2012-04-30 | Alun Michael uk.org.publicwhip/member/40147 | Alun Michael uk.org.publicwhip/person/10431 | 4 | 2012-04-30-80ef1083-10431-0 |
92671b85eada29fc610864039a08a84d98f7fda0 | Destination of visit: Nairobi, Kenya | Overseas visits 80ef1083 | 2012-04-30 | Alun Michael uk.org.publicwhip/member/40147 | Alun Michael uk.org.publicwhip/person/10431 | 5 | 2012-04-30-80ef1083-10431-0 |
2ff6456422a6225e6e6d1fe9834761b69393f981 | Dates of visit: 25-30 September 2011 | Overseas visits 80ef1083 | 2012-04-30 | Alun Michael uk.org.publicwhip/member/40147 | Alun Michael uk.org.publicwhip/person/10431 | 6 | 2012-04-30-80ef1083-10431-0 |
2ccb81b136c32f026d4df54881faa93cdac53d5a | Purpose of visit: to attend the annual United Nations Internet Governance Forum (IGF) as part of a parliamentary delegation. This relates to my work as an MP and specifically as Chair of the Parliamentary Internet & Communications Technology Forum (PICTFOR) and Chair of the UK IGF and other IT-related Parliamentary activities (Registered 12 October 2011) | Overseas visits 80ef1083 | 2012-04-30 | Alun Michael uk.org.publicwhip/member/40147 | Alun Michael uk.org.publicwhip/person/10431 | 7 | 2012-04-30-80ef1083-10431-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");