items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
12 rows where record_id = "2011-10-17-80ef1083-24849-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 |
---|---|---|---|---|---|---|---|
b0298dcb5df6bc9ecaa3c5a44689e37229920fd2 | Name of donor: (1) All-Party Parliamentary China Group (APPCG) | Overseas visits 80ef1083 | 2011-10-17 | Dan Byles uk.org.publicwhip/member/40449 | Dan Byles uk.org.publicwhip/person/24849 | 0 | 2011-10-17-80ef1083-24849-0 |
6b772c95ef08582ee074f8a81f9f12cc07a9e047 | (2) National People’s Congress of China | Overseas visits 80ef1083 | 2011-10-17 | Dan Byles uk.org.publicwhip/member/40449 | Dan Byles uk.org.publicwhip/person/24849 | 1 | 2011-10-17-80ef1083-24849-0 |
46ebdf59d8be3dfb1389f12ef583e4eda054e36c | Address of donor: | Overseas visits 80ef1083 | 2011-10-17 | Dan Byles uk.org.publicwhip/member/40449 | Dan Byles uk.org.publicwhip/person/24849 | 2 | 2011-10-17-80ef1083-24849-0 |
0c358b5c4f3d7b4d3296d838a4a3217ed80c07bc | (1) c/o Great Britain China Centre, 15 Belgrave Square, London SW1X 8PS | Overseas visits 80ef1083 | 2011-10-17 | Dan Byles uk.org.publicwhip/member/40449 | Dan Byles uk.org.publicwhip/person/24849 | 3 | 2011-10-17-80ef1083-24849-0 |
4ee8d124e96adfff614906920ed30b68a2dc5319 | (2) 23 Xi Jiao Min Xiang, Beijing 10085, P.R. China | Overseas visits 80ef1083 | 2011-10-17 | Dan Byles uk.org.publicwhip/member/40449 | Dan Byles uk.org.publicwhip/person/24849 | 4 | 2011-10-17-80ef1083-24849-0 |
63e934386df99e070818e3b4b41d7ed7c5f4dc7e | Amount of donation (or estimate of the probable value): | Overseas visits 80ef1083 | 2011-10-17 | Dan Byles uk.org.publicwhip/member/40449 | Dan Byles uk.org.publicwhip/person/24849 | 5 | 2011-10-17-80ef1083-24849-0 |
c1c5fb082444d0ae69d43aed0f9b0ae6f0fc8ae3 | Return flights to China paid for by the APPCG from funds previously registered; total cost £2421.47 | Overseas visits 80ef1083 | 2011-10-17 | Dan Byles uk.org.publicwhip/member/40449 | Dan Byles uk.org.publicwhip/person/24849 | 6 | 2011-10-17-80ef1083-24849-0 |
47346d2648b0c51a9dbbc28b2653607b0a4084b7 | Internal travel and hospitality (including meals) paid for by National People’s Congress; approx value £500 | Overseas visits 80ef1083 | 2011-10-17 | Dan Byles uk.org.publicwhip/member/40449 | Dan Byles uk.org.publicwhip/person/24849 | 7 | 2011-10-17-80ef1083-24849-0 |
8ca6fbb7fd9b47a8208e927f55bb70b7d86d2cd4 | Destination of visit: shanghai and Beijing | Overseas visits 80ef1083 | 2011-10-17 | Dan Byles uk.org.publicwhip/member/40449 | Dan Byles uk.org.publicwhip/person/24849 | 8 | 2011-10-17-80ef1083-24849-0 |
4f950400156ee7f272b12a403708f8bc3f48f65d | Date of visit: 9-16 October 2010 | Overseas visits 80ef1083 | 2011-10-17 | Dan Byles uk.org.publicwhip/member/40449 | Dan Byles uk.org.publicwhip/person/24849 | 9 | 2011-10-17-80ef1083-24849-0 |
005701a44f9131bc391e1170abc7099a190b0182 | Purpose of visit: to consolidate links between the UK Parliament and National People’s Congress, and update knowledge and awareness of China’s political, social and economic development. | Overseas visits 80ef1083 | 2011-10-17 | Dan Byles uk.org.publicwhip/member/40449 | Dan Byles uk.org.publicwhip/person/24849 | 10 | 2011-10-17-80ef1083-24849-0 |
c635a21d49a3dfad3cf472d0fc7177d8d4342b93 | (Registered 28 October 2010) | Overseas visits 80ef1083 | 2011-10-17 | Dan Byles uk.org.publicwhip/member/40449 | Dan Byles uk.org.publicwhip/person/24849 | 11 | 2011-10-17-80ef1083-24849-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");