items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
10 rows where record_id = "2015-03-30-80ef1083-10552-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 |
---|---|---|---|---|---|---|---|
e806dbeeae1f50d3d6794d9ece5537bfdedc9bcf | Name of donor: Government of the Hong Kong Special Administrative Region | Overseas visits 80ef1083 | 2015-03-30 | Robert Smith uk.org.publicwhip/member/40645 | Robert Smith uk.org.publicwhip/person/10552 | 0 | 2015-03-30-80ef1083-10552-0 |
4e5f10343ae020eeeb39e379b41e3f9a86a42d54 | Address of donor: C/O Hong Kong Economic & Trade Office, 6 Grafton Street, London W1S 4EQ | Overseas visits 80ef1083 | 2015-03-30 | Robert Smith uk.org.publicwhip/member/40645 | Robert Smith uk.org.publicwhip/person/10552 | 1 | 2015-03-30-80ef1083-10552-0 |
57faebe9c82dd1a2d9cf25ffc022fa156b599183 | Destination of visit: Hong Kong | Overseas visits 80ef1083 | 2015-03-30 | Robert Smith uk.org.publicwhip/member/40645 | Robert Smith uk.org.publicwhip/person/10552 | 2 | 2015-03-30-80ef1083-10552-0 |
d50f4838fcac83217692d265727273356d16e284 | Date of visit: 23-31 May 2014 | Overseas visits 80ef1083 | 2015-03-30 | Robert Smith uk.org.publicwhip/member/40645 | Robert Smith uk.org.publicwhip/person/10552 | 3 | 2015-03-30-80ef1083-10552-0 |
a9d569fb91666a21f6df5bc0150e8a9abb0a8a09 | Amount of donation (or estimate of the probable value): flights, in-country transport, accommodation, meals, wi-fi access and laundry with a total value of £10,621.32 | Overseas visits 80ef1083 | 2015-03-30 | Robert Smith uk.org.publicwhip/member/40645 | Robert Smith uk.org.publicwhip/person/10552 | 4 | 2015-03-30-80ef1083-10552-0 |
f721f0ba05e82bf1dad397b7ce9d197e6d69a3bd | 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 | Robert Smith uk.org.publicwhip/member/40645 | Robert Smith uk.org.publicwhip/person/10552 | 5 | 2015-03-30-80ef1083-10552-0 |
a0e6cdcd7a54e4940bda4bc1f692b82ac4181464 | (Registered 25 June 2014; updated 30 June 2014) | Overseas visits 80ef1083 | 2015-03-30 | Robert Smith uk.org.publicwhip/member/40645 | Robert Smith uk.org.publicwhip/person/10552 | 6 | 2015-03-30-80ef1083-10552-0 |
e2f81a05e5411bc5840dcb7a96b6a5301166ae03 | 8. Land and Property | Overseas visits 80ef1083 | 2015-03-30 | Robert Smith uk.org.publicwhip/member/40645 | Robert Smith uk.org.publicwhip/person/10552 | 7 | 2015-03-30-80ef1083-10552-0 |
c50a005c6f3f58c919a428614a28dd7486b66943 | Farm and cottages in Aberdeenshire, from which rental income is received. | Overseas visits 80ef1083 | 2015-03-30 | Robert Smith uk.org.publicwhip/member/40645 | Robert Smith uk.org.publicwhip/person/10552 | 8 | 2015-03-30-80ef1083-10552-0 |
d0392ce3303361034b7e656e046e4ccbab14e874 | Flat in Glasgow, from which rental income is received. | Overseas visits 80ef1083 | 2015-03-30 | Robert Smith uk.org.publicwhip/member/40645 | Robert Smith uk.org.publicwhip/person/10552 | 9 | 2015-03-30-80ef1083-10552-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");