items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
20 rows where record_id = "2012-12-19-80ef1083-11719-0" sorted by date descending
This data as json, CSV (advanced)
Suggested facets: date (date)
hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
a9efe0a45c8ebef15d3af1753be7647bf0794753 | Name of donor: | Overseas visits 80ef1083 | 2012-12-19 | David Davies uk.org.publicwhip/member/40407 | David Davies uk.org.publicwhip/person/11719 | 0 | 2012-12-19-80ef1083-11719-0 |
48d6b258b076b896c3d6e6d28203cdf7d71a4e9d | 1. All Party Parliamentary China Group, sponsored by GKN plc, City of London, London Export Corporation (LEC), John Swire & Sons, GlaxoSmithKline, Astra Zeneca, Arup, University of Cambridge Local Examinations Syndicate, HSBC. | Overseas visits 80ef1083 | 2012-12-19 | David Davies uk.org.publicwhip/member/40407 | David Davies uk.org.publicwhip/person/11719 | 1 | 2012-12-19-80ef1083-11719-0 |
4d3155f1bab85882a4ba8bc57bd6649d4e563a86 | 2. Virgin Atlantic | Overseas visits 80ef1083 | 2012-12-19 | David Davies uk.org.publicwhip/member/40407 | David Davies uk.org.publicwhip/person/11719 | 2 | 2012-12-19-80ef1083-11719-0 |
bf3921ffc20879ad5d90d099725a2529046cdfd8 | Address of donor: | Overseas visits 80ef1083 | 2012-12-19 | David Davies uk.org.publicwhip/member/40407 | David Davies uk.org.publicwhip/person/11719 | 3 | 2012-12-19-80ef1083-11719-0 |
0013fcf4882eb937f09b1df762005fe4b8fd3cda | 1. c/o Great Britain China Centre, 15 Belgrave Square, London SW1X 8PS | Overseas visits 80ef1083 | 2012-12-19 | David Davies uk.org.publicwhip/member/40407 | David Davies uk.org.publicwhip/person/11719 | 4 | 2012-12-19-80ef1083-11719-0 |
2fe45c560a3eb2a20fffc60c95361244123b472b | 2. Customer Relations, PO Box 747, Dunstable LU6 9AH | Overseas visits 80ef1083 | 2012-12-19 | David Davies uk.org.publicwhip/member/40407 | David Davies uk.org.publicwhip/person/11719 | 5 | 2012-12-19-80ef1083-11719-0 |
4e8faf8492f2968af54bf5279e7f757bf5201151 | Amount of donation (or estimate of the probable value): | Overseas visits 80ef1083 | 2012-12-19 | David Davies uk.org.publicwhip/member/40407 | David Davies uk.org.publicwhip/person/11719 | 6 | 2012-12-19-80ef1083-11719-0 |
d018a8e2e3bbcaed4f7a22712d4e6d8359b9ca05 | 1. £2,199.98, return flights to China, internal travel in China, accommodation and meals. I also received some meals and hospitality provided locally. | Overseas visits 80ef1083 | 2012-12-19 | David Davies uk.org.publicwhip/member/40407 | David Davies uk.org.publicwhip/person/11719 | 7 | 2012-12-19-80ef1083-11719-0 |
1ba35f645c9b080f7a7b1111d0355db431094d0e | 2. £1,500, flight upgrade on outward journey | Overseas visits 80ef1083 | 2012-12-19 | David Davies uk.org.publicwhip/member/40407 | David Davies uk.org.publicwhip/person/11719 | 8 | 2012-12-19-80ef1083-11719-0 |
6d51c26c23af144446eab3eecd8cd5b5149d48f5 | Destination of visit: China; Shanghai, Beijing and Chengdu | Overseas visits 80ef1083 | 2012-12-19 | David Davies uk.org.publicwhip/member/40407 | David Davies uk.org.publicwhip/person/11719 | 9 | 2012-12-19-80ef1083-11719-0 |
718d37b228397320ef94bafd25d0be393c5d6b80 | Date of visit: 16-22 December 2011 | Overseas visits 80ef1083 | 2012-12-19 | David Davies uk.org.publicwhip/member/40407 | David Davies uk.org.publicwhip/person/11719 | 10 | 2012-12-19-80ef1083-11719-0 |
df5aeb69b0bd6da70d0e6b0078527dabbfc980ac | Purpose of visit: to maintain and strengthen relations between Parliament and the National People’s Congress of China; to learn about and support British businesses operating in China; and to deepen the knowledge and understanding of parliamentarians of China. | Overseas visits 80ef1083 | 2012-12-19 | David Davies uk.org.publicwhip/member/40407 | David Davies uk.org.publicwhip/person/11719 | 11 | 2012-12-19-80ef1083-11719-0 |
d28cf5c306f912caea75c864fc688c4a223c7fad | (Registered 4 January 2012) | Overseas visits 80ef1083 | 2012-12-19 | David Davies uk.org.publicwhip/member/40407 | David Davies uk.org.publicwhip/person/11719 | 12 | 2012-12-19-80ef1083-11719-0 |
36e75071c9f82e55f6b84a6535f89a30cdb743ee | Name of donor: Sir Joseph Hotung Programme | Overseas visits 80ef1083 | 2012-12-19 | David Davies uk.org.publicwhip/member/40407 | David Davies uk.org.publicwhip/person/11719 | 13 | 2012-12-19-80ef1083-11719-0 |
8205d30a3da1b2bf7e164c29f6fbe67233219fcc | Address of donor: School of Oriental and African Studies, Thornhaugh Street, Russell Square, London WC1H 0XG | Overseas visits 80ef1083 | 2012-12-19 | David Davies uk.org.publicwhip/member/40407 | David Davies uk.org.publicwhip/person/11719 | 14 | 2012-12-19-80ef1083-11719-0 |
2d359bf0eb6b9810b02ead5b20ca7ee120114ea8 | Amount of donation (or estimate of the probable value): £1,002.94, covering travel costs, accommodation and subsistence | Overseas visits 80ef1083 | 2012-12-19 | David Davies uk.org.publicwhip/member/40407 | David Davies uk.org.publicwhip/person/11719 | 15 | 2012-12-19-80ef1083-11719-0 |
6c0e9ce61ea9a479d813ae751593a9508ab96c05 | Destination of visit: West Bank and Israel | Overseas visits 80ef1083 | 2012-12-19 | David Davies uk.org.publicwhip/member/40407 | David Davies uk.org.publicwhip/person/11719 | 16 | 2012-12-19-80ef1083-11719-0 |
ef2c937af974fc50d68af776e067922218274040 | Date of visit: 7-11 June 2012 | Overseas visits 80ef1083 | 2012-12-19 | David Davies uk.org.publicwhip/member/40407 | David Davies uk.org.publicwhip/person/11719 | 17 | 2012-12-19-80ef1083-11719-0 |
2c5ebe969771c355b2f5b4ca7772a2985114e9ed | Purpose of visit: Britain-Palestine All-Party Parliamentary Group delegation | Overseas visits 80ef1083 | 2012-12-19 | David Davies uk.org.publicwhip/member/40407 | David Davies uk.org.publicwhip/person/11719 | 18 | 2012-12-19-80ef1083-11719-0 |
fdb4ed5e57ca14dbd8293a4e94280ad73f1bfec4 | (Registered 14 June 2012) | Overseas visits 80ef1083 | 2012-12-19 | David Davies uk.org.publicwhip/member/40407 | David Davies uk.org.publicwhip/person/11719 | 19 | 2012-12-19-80ef1083-11719-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");