items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
7 rows where record_id = "2015-03-30-80ef1083-11531-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 |
---|---|---|---|---|---|---|---|
fb98426d4be6486588de2f0efd621b221482eb06 | Name of donor: Government of the Hong Kong Special Administrative Region | Overseas visits 80ef1083 | 2015-03-30 | Andrew Gwynne uk.org.publicwhip/member/40200 | Andrew Gwynne uk.org.publicwhip/person/11531 | 0 | 2015-03-30-80ef1083-11531-0 |
76c5b7cdc67f083493d79b609f6582e6f52a15aa | Address of donor: C/O Hong Kong Economic & Trade Office, 6 Grafton Street, London W1S 4EQ | Overseas visits 80ef1083 | 2015-03-30 | Andrew Gwynne uk.org.publicwhip/member/40200 | Andrew Gwynne uk.org.publicwhip/person/11531 | 1 | 2015-03-30-80ef1083-11531-0 |
6c6653ff698415d00a1f19def2036812ffbeb089 | Destination of visit: Hong Kong | Overseas visits 80ef1083 | 2015-03-30 | Andrew Gwynne uk.org.publicwhip/member/40200 | Andrew Gwynne uk.org.publicwhip/person/11531 | 2 | 2015-03-30-80ef1083-11531-0 |
abb8c41a665a988e3f32a102e0a65ce67d3e3ed1 | Date of visit: 25-31 May 2014 | Overseas visits 80ef1083 | 2015-03-30 | Andrew Gwynne uk.org.publicwhip/member/40200 | Andrew Gwynne uk.org.publicwhip/person/11531 | 3 | 2015-03-30-80ef1083-11531-0 |
8c1a57f276624b06496af43d1462fdb4dac2e2f7 | Amount of donation (or estimate of the probable value): flights, in-country transport, accommodation and meals with a total value of £10,586.36. | Overseas visits 80ef1083 | 2015-03-30 | Andrew Gwynne uk.org.publicwhip/member/40200 | Andrew Gwynne uk.org.publicwhip/person/11531 | 4 | 2015-03-30-80ef1083-11531-0 |
d30b42fc3870310b2c0251cb1db15e7ec71951a9 | Purpose of visit: All Party Parliamentary China Group delegation visit to understand more about the political and economic environment in Hong Kong and the progress towards universal suffrage and to engage with and support bids by British business. | Overseas visits 80ef1083 | 2015-03-30 | Andrew Gwynne uk.org.publicwhip/member/40200 | Andrew Gwynne uk.org.publicwhip/person/11531 | 5 | 2015-03-30-80ef1083-11531-0 |
006d2879230c51032a757eb401d8ba62d2eda281 | (Registered 25 June 2014, updated 30 June 2014) | Overseas visits 80ef1083 | 2015-03-30 | Andrew Gwynne uk.org.publicwhip/member/40200 | Andrew Gwynne uk.org.publicwhip/person/11531 | 6 | 2015-03-30-80ef1083-11531-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");