items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
12 rows where record_id = "2011-12-13-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 |
---|---|---|---|---|---|---|---|
58c50175db69ee8a77d2cb736aed59ca197f067a | Name of donor: (1) All-Party Parliamentary China Group (APPCG) | Overseas visits 80ef1083 | 2011-12-13 | Dan Byles uk.org.publicwhip/member/40449 | Dan Byles uk.org.publicwhip/person/24849 | 0 | 2011-12-13-80ef1083-24849-0 |
02e47e190f0c0fb03c356099bedf63aeb1944e22 | (2) National People’s Congress of China | Overseas visits 80ef1083 | 2011-12-13 | Dan Byles uk.org.publicwhip/member/40449 | Dan Byles uk.org.publicwhip/person/24849 | 1 | 2011-12-13-80ef1083-24849-0 |
645b9249b51ee5b989159d529748e87ccb62adaf | Address of donor: | Overseas visits 80ef1083 | 2011-12-13 | Dan Byles uk.org.publicwhip/member/40449 | Dan Byles uk.org.publicwhip/person/24849 | 2 | 2011-12-13-80ef1083-24849-0 |
c656af18ec3ec262468b71e7974dfa24c5ecfadd | (1) c/o Great Britain China Centre, 15 Belgrave Square, London SW1X 8PS | Overseas visits 80ef1083 | 2011-12-13 | Dan Byles uk.org.publicwhip/member/40449 | Dan Byles uk.org.publicwhip/person/24849 | 3 | 2011-12-13-80ef1083-24849-0 |
f9e1d343525b5de0585f8b3943f47911cf3b6eb4 | (2) 23 Xi Jiao Min Xiang, Beijing 10085, P.R. China | Overseas visits 80ef1083 | 2011-12-13 | Dan Byles uk.org.publicwhip/member/40449 | Dan Byles uk.org.publicwhip/person/24849 | 4 | 2011-12-13-80ef1083-24849-0 |
c48cea7a356637e9292a31010ea8cafd56e428c2 | Amount of donation (or estimate of the probable value): | Overseas visits 80ef1083 | 2011-12-13 | Dan Byles uk.org.publicwhip/member/40449 | Dan Byles uk.org.publicwhip/person/24849 | 5 | 2011-12-13-80ef1083-24849-0 |
37487685b417dfc623af384ca368eca56ea11e00 | Return flights to China paid for by the APPCG from funds previously registered; total cost £2421.47 | Overseas visits 80ef1083 | 2011-12-13 | Dan Byles uk.org.publicwhip/member/40449 | Dan Byles uk.org.publicwhip/person/24849 | 6 | 2011-12-13-80ef1083-24849-0 |
2e3f6a8d4e5b16d9926fd895d7c5d0696594a693 | Internal travel and hospitality (including meals) paid for by National People’s Congress; approx value £500 | Overseas visits 80ef1083 | 2011-12-13 | Dan Byles uk.org.publicwhip/member/40449 | Dan Byles uk.org.publicwhip/person/24849 | 7 | 2011-12-13-80ef1083-24849-0 |
4d5b868b2fc1dae6c58186695d072d91fdc22a39 | Destination of visit: shanghai and Beijing | Overseas visits 80ef1083 | 2011-12-13 | Dan Byles uk.org.publicwhip/member/40449 | Dan Byles uk.org.publicwhip/person/24849 | 8 | 2011-12-13-80ef1083-24849-0 |
6c824ad54d3cfadc18007aac71aeda93e06f16e2 | Date of visit: 9-16 October 2010 | Overseas visits 80ef1083 | 2011-12-13 | Dan Byles uk.org.publicwhip/member/40449 | Dan Byles uk.org.publicwhip/person/24849 | 9 | 2011-12-13-80ef1083-24849-0 |
0fa64923e38af444e76798f37ded17885693a141 | 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-12-13 | Dan Byles uk.org.publicwhip/member/40449 | Dan Byles uk.org.publicwhip/person/24849 | 10 | 2011-12-13-80ef1083-24849-0 |
549e73d6142a526f042699eb5459b4645c72f373 | (Registered 28 October 2010) | Overseas visits 80ef1083 | 2011-12-13 | Dan Byles uk.org.publicwhip/member/40449 | Dan Byles uk.org.publicwhip/person/24849 | 11 | 2011-12-13-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");