items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
12 rows where record_id = "2011-06-06-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 |
---|---|---|---|---|---|---|---|
12bad90ebb708c6fe96335b8d3ee1df9c642f0ce | Name of donor: (1) All-Party Parliamentary China Group (APPCG) | Overseas visits 80ef1083 | 2011-06-06 | Dan Byles uk.org.publicwhip/member/40449 | Dan Byles uk.org.publicwhip/person/24849 | 0 | 2011-06-06-80ef1083-24849-0 |
7de9681a83cf0c4b246a4e1581518d8765632ed2 | (2) National People’s Congress of China | Overseas visits 80ef1083 | 2011-06-06 | Dan Byles uk.org.publicwhip/member/40449 | Dan Byles uk.org.publicwhip/person/24849 | 1 | 2011-06-06-80ef1083-24849-0 |
91611b5955c3ffcc37be4b28d171faa6fcc474bb | Address of donor: | Overseas visits 80ef1083 | 2011-06-06 | Dan Byles uk.org.publicwhip/member/40449 | Dan Byles uk.org.publicwhip/person/24849 | 2 | 2011-06-06-80ef1083-24849-0 |
af350aee1e8440e4094ca7eb265027492d36524c | (1) c/o Great Britain China Centre, 15 Belgrave Square, London SW1X 8PS | Overseas visits 80ef1083 | 2011-06-06 | Dan Byles uk.org.publicwhip/member/40449 | Dan Byles uk.org.publicwhip/person/24849 | 3 | 2011-06-06-80ef1083-24849-0 |
f9d826cb5a46df9eeb6b43e9ae374dc3d7613766 | (2) 23 Xi Jiao Min Xiang, Beijing 10085, P.R. China | Overseas visits 80ef1083 | 2011-06-06 | Dan Byles uk.org.publicwhip/member/40449 | Dan Byles uk.org.publicwhip/person/24849 | 4 | 2011-06-06-80ef1083-24849-0 |
128c0a8b5598162d3059e7cd42fd37e5d7a1ab63 | Amount of donation (or estimate of the probable value): | Overseas visits 80ef1083 | 2011-06-06 | Dan Byles uk.org.publicwhip/member/40449 | Dan Byles uk.org.publicwhip/person/24849 | 5 | 2011-06-06-80ef1083-24849-0 |
689ca510096fc41310f0ba6cfe7d714a0d6798c9 | Return flights to China paid for by the APPCG from funds previously registered; total cost £2421.47 | Overseas visits 80ef1083 | 2011-06-06 | Dan Byles uk.org.publicwhip/member/40449 | Dan Byles uk.org.publicwhip/person/24849 | 6 | 2011-06-06-80ef1083-24849-0 |
34f86d4d4e5222bd4c25c2fd5eaa8773ac9190e3 | Internal travel and hospitality (including meals) paid for by National People’s Congress; approx value £500 | Overseas visits 80ef1083 | 2011-06-06 | Dan Byles uk.org.publicwhip/member/40449 | Dan Byles uk.org.publicwhip/person/24849 | 7 | 2011-06-06-80ef1083-24849-0 |
734098fa2ae8d406e6372d164515865ddc6618b5 | Destination of visit: shanghai and Beijing | Overseas visits 80ef1083 | 2011-06-06 | Dan Byles uk.org.publicwhip/member/40449 | Dan Byles uk.org.publicwhip/person/24849 | 8 | 2011-06-06-80ef1083-24849-0 |
d7dc2cf4ffd9146ed3886a8906fa98e33ebf5e02 | Date of visit: 9-16 October 2010 | Overseas visits 80ef1083 | 2011-06-06 | Dan Byles uk.org.publicwhip/member/40449 | Dan Byles uk.org.publicwhip/person/24849 | 9 | 2011-06-06-80ef1083-24849-0 |
c4c1d9159385e72288d9c8b0f697ee900f1232ea | 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-06-06 | Dan Byles uk.org.publicwhip/member/40449 | Dan Byles uk.org.publicwhip/person/24849 | 10 | 2011-06-06-80ef1083-24849-0 |
c4347a99abdf40ec037fb4b3e9f43c207663dfd3 | (Registered 28 October 2010) | Overseas visits 80ef1083 | 2011-06-06 | Dan Byles uk.org.publicwhip/member/40449 | Dan Byles uk.org.publicwhip/person/24849 | 11 | 2011-06-06-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");