items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
489 rows where person_id = "uk.org.publicwhip/person/10079" sorted by member_id
This data as json, CSV (advanced)
Suggested facets: category_id, member_id, sort_order
date (date) >30 ✖
- 2009-11-11 10
- 2009-11-25 10
- 2009-12-10 10
- 2010-01-06 10
- 2010-02-03 10
- 2010-02-24 9
- 2010-03-10 9
- 2010-03-24 9
- 2010-04-12 9
- 2010-09-06 7
- 2010-10-25 7
- 2010-11-08 7
- 2014-11-10 7
- 2014-11-24 7
- 2014-12-08 7
- 2015-01-06 7
- 2015-01-26 7
- 2015-02-09 7
- 2015-02-23 7
- 2015-03-09 7
- 2015-03-30 7
- 2015-06-08 6
- 2005-01-28 5
- 2005-04-11 5
- 2007-03-13 5
- 2007-03-26 5
- 2007-11-06 5
- 2007-11-20 5
- 2007-12-04 5
- 2007-12-18 5
- …
hash | item | category_id | date | member_id ▼ | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
5024a2a645caf600b36468a1aebca8e70474662d | Payments from ComRes, 4 Millbank, London SW1P 3JA, for completing Parliamentary Panel Surveys: | Employment and earnings 10057ffd | 2015-06-08 | Simon Burns uk.org.publicwhip/person/10079 | 0 | 2015-06-08-10057ffd-10079-0 | |
a56e1c3960a54e39cff286166330f43351157a9a | 9 June 2014, received payment of £75. Hours: 30 mins. (Registered 09 June 2014) | Employment and earnings 10057ffd | 2015-06-08 | Simon Burns uk.org.publicwhip/person/10079 | 1 | 2015-06-08-10057ffd-10079-0 | |
3bc34db1818a65fa7833d8682682b9bbf3fab664 | 4 August 2014, received payment of £75. Hours: 30 mins. (Registered 04 August 2014) | Employment and earnings 10057ffd | 2015-06-08 | Simon Burns uk.org.publicwhip/person/10079 | 2 | 2015-06-08-10057ffd-10079-0 | |
73f638b95244a192ebb4cb2a261874da0ce58693 | Payments from YouGov plc, 50 Featherstone Street, London, EC1Y 8RT for completing surveys: | Employment and earnings 10057ffd | 2015-06-08 | Simon Burns uk.org.publicwhip/person/10079 | 3 | 2015-06-08-10057ffd-10079-0 | |
2058469e1aca2f90eb4a106d1a86d8eeed9ab089 | 9 June 2014, received payment of £80. Hours: 40 mins. (Registered 09 June 2014) | Employment and earnings 10057ffd | 2015-06-08 | Simon Burns uk.org.publicwhip/person/10079 | 4 | 2015-06-08-10057ffd-10079-0 | |
9113ff496fea81775c527a7916aaf1e04006435d | Name of donor: Government of Taiwan Address of donor: Taipei Representative Office, 50 Grosvenor Gardens, London SW1W 0EB Amount of donation (or estimate of the probable value): flights, accommodation and hospitality at an approximate value of £3,640 Destination of visit: Taiwan Date of visit: 20-26 October 2014 Purpose of visit: to learn more about High Speed Rail and relations between Taiwan and the People’s Republic of China. (Registered 29 October 2014) | Visits outside the UK 891eb863 | 2015-06-08 | Simon Burns uk.org.publicwhip/person/10079 | 0 | 2015-06-08-891eb863-10079-0 | |
6f520de7ab43e638c93718e151124befe1b0245b | Payments from ComRes, 4 Millbank, London SW1P 3JA, for completing Parliamentary Panel Surveys: | Employment and earnings 10057ffd | 2015-07-13 | Simon Burns uk.org.publicwhip/person/10079 | 0 | 2015-07-13-10057ffd-10079-0 | |
3324bbbe570a7494723ab93ca3f18e1de1dd0ac0 | 4 August 2014, received payment of £75. Hours: 30 mins. (Registered 04 August 2014) | Employment and earnings 10057ffd | 2015-07-13 | Simon Burns uk.org.publicwhip/person/10079 | 1 | 2015-07-13-10057ffd-10079-0 | |
97bae81c9cacfda9d51da0f64e561f717d402ec4 | Name of donor: Government of Taiwan Address of donor: Taipei Representative Office, 50 Grosvenor Gardens, London SW1W 0EB Amount of donation (or estimate of the probable value): flights, accommodation and hospitality at an approximate value of £3,640 Destination of visit: Taiwan Date of visit: 20-26 October 2014 Purpose of visit: to learn more about High Speed Rail and relations between Taiwan and the People’s Republic of China. (Registered 29 October 2014) | Visits outside the UK 891eb863 | 2015-07-13 | Simon Burns uk.org.publicwhip/person/10079 | 0 | 2015-07-13-891eb863-10079-0 | |
284aa4d4cf37da6bcb955bb44cbfd472321caee9 | Name of donor: Government of Taiwan Address of donor: Taipei Representative Office, 50 Grosvenor Gardens, London SW1W 0EB Amount of donation (or estimate of the probable value): flights, accommodation and hospitality at an approximate value of £3,640 Destination of visit: Taiwan Date of visit: 20-26 October 2014 Purpose of visit: to learn more about High Speed Rail and relations between Taiwan and the People’s Republic of China. (Registered 29 October 2014) | Visits outside the UK 891eb863 | 2015-08-10 | Simon Burns uk.org.publicwhip/person/10079 | 0 | 2015-08-10-891eb863-10079-0 | |
aff70a31827d4fc1bb9bc6070e378a85f0c90f5e | Name of donor: Government of Taiwan Address of donor: Taipei Representative Office, 50 Grosvenor Gardens, London SW1W 0EB Amount of donation (or estimate of the probable value): flights, accommodation and hospitality at an approximate value of £3,640 Destination of visit: Taiwan Date of visit: 20-26 October 2014 Purpose of visit: to learn more about High Speed Rail and relations between Taiwan and the People’s Republic of China. (Registered 29 October 2014) | Visits outside the UK 891eb863 | 2015-09-07 | Simon Burns uk.org.publicwhip/person/10079 | 0 | 2015-09-07-891eb863-10079-0 | |
fc7ccf9bdad725adc642d19abceb963575e006d3 | Name of donor: Government of Taiwan Address of donor: Taipei Representative Office, 50 Grosvenor Gardens, London SW1W 0EB Amount of donation (or estimate of the probable value): flights, accommodation and hospitality at an approximate value of £3,640 Destination of visit: Taiwan Date of visit: 20-26 October 2014 Purpose of visit: to learn more about High Speed Rail and relations between Taiwan and the People’s Republic of China. (Registered 29 October 2014) | Visits outside the UK 891eb863 | 2015-09-28 | Simon Burns uk.org.publicwhip/person/10079 | 0 | 2015-09-28-891eb863-10079-0 | |
9ee010230ef98cc21710fda548d94954896c263e | Name of donor: Government of Taiwan Address of donor: Taipei Representative Office, 50 Grosvenor Gardens, London SW1W 0EB Amount of donation (or estimate of the probable value): flights, accommodation and hospitality at an approximate value of £3,640 Destination of visit: Taiwan Date of visit: 20-26 October 2014 Purpose of visit: to learn more about High Speed Rail and relations between Taiwan and the People’s Republic of China. (Registered 29 October 2014) | Visits outside the UK 891eb863 | 2015-10-12 | Simon Burns uk.org.publicwhip/person/10079 | 0 | 2015-10-12-891eb863-10079-0 | |
2860cbfe14f7d904ab430c225e6240da6ac43770 | Name of donor: Government of Taiwan Address of donor: Taipei Representative Office, 50 Grosvenor Gardens, London SW1W 0EB Amount of donation (or estimate of the probable value): flights, accommodation and hospitality at an approximate value of £3,640 Destination of visit: Taiwan Date of visit: 20-26 October 2014 Purpose of visit: to learn more about High Speed Rail and relations between Taiwan and the People’s Republic of China. (Registered 29 October 2014) | Visits outside the UK 891eb863 | 2015-10-26 | Simon Burns uk.org.publicwhip/person/10079 | 0 | 2015-10-26-891eb863-10079-0 | |
de3e930b6d0af15fd84f011d3d5a572b738cde1d | 3 January 2017, received £600 from Associated Newspapers Limited of Northcliffe House, 2 Derry Street, London, W8 5TT for an article for the Mail on Sunday. Hours: 2 hrs. (Registered 09 January 2017) | Employment and earnings 10057ffd | 2017-01-09 | Simon Burns uk.org.publicwhip/person/10079 | 0 | 2017-01-09-10057ffd-10079-0 | |
98365de2a5018cc0d2a638aebc456b76a868f845 | 3 January 2017, received £600 from Associated Newspapers Limited of Northcliffe House, 2 Derry Street, London, W8 5TT for an article for the Mail on Sunday. Hours: 2 hrs. (Registered 09 January 2017) | Employment and earnings 10057ffd | 2017-01-23 | Simon Burns uk.org.publicwhip/person/10079 | 0 | 2017-01-23-10057ffd-10079-0 | |
7510184a4bf6ec554b909e059c7b4c1ff3e5b4d5 | 3 January 2017, received £600 from Associated Newspapers Limited of Northcliffe House, 2 Derry Street, London, W8 5TT for an article for the Mail on Sunday. Hours: 2 hrs. (Registered 09 January 2017) | Employment and earnings 10057ffd | 2017-02-06 | Simon Burns uk.org.publicwhip/person/10079 | 0 | 2017-02-06-10057ffd-10079-0 | |
ea918cb8e6ac679352a7e39cdcfeb3a4198ef36a | 3 January 2017, received £600 from Associated Newspapers Limited of Northcliffe House, 2 Derry Street, London, W8 5TT for an article for the Mail on Sunday. Hours: 2 hrs. (Registered 09 January 2017) | Employment and earnings 10057ffd | 2017-02-20 | Simon Burns uk.org.publicwhip/person/10079 | 0 | 2017-02-20-10057ffd-10079-0 | |
d2976754b78fd28014da974640400d97d1236520 | 3 January 2017, received £600 from Associated Newspapers Limited of Northcliffe House, 2 Derry Street, London, W8 5TT for an article for the Mail on Sunday. Hours: 2 hrs. (Registered 09 January 2017) | Employment and earnings 10057ffd | 2017-03-06 | Simon Burns uk.org.publicwhip/person/10079 | 0 | 2017-03-06-10057ffd-10079-0 | |
36f2d6840068559635b3eacd0346b24e41c5096a | Payments from Associated Newspapers Limited of Northcliffe House, 2 Derry Street, London, W8 5TT: | Employment and earnings 10057ffd | 2017-03-20 | Simon Burns uk.org.publicwhip/person/10079 | 0 | 2017-03-20-10057ffd-10079-0 | |
d46b16387a03ea1158e4fe420f4870b11646e604 | 3 January 2017, received £600 for an article for the Mail on Sunday. Hours: 2 hrs. (Registered 09 January 2017) | Employment and earnings 10057ffd | 2017-03-20 | Simon Burns uk.org.publicwhip/person/10079 | 1 | 2017-03-20-10057ffd-10079-0 | |
3db2f727a4524df382b949f0a771e9fcfac9069f | 6 March 2017, received £550 for an article for the Mail on Sunday. Hours: 2 hrs. (Registered 09 March 2017) | Employment and earnings 10057ffd | 2017-03-20 | Simon Burns uk.org.publicwhip/person/10079 | 2 | 2017-03-20-10057ffd-10079-0 | |
e5f5f20ad7239e6076234633b1650b9def013ee6 | Payments from Associated Newspapers Limited of Northcliffe House, 2 Derry Street, London, W8 5TT: | Employment and earnings 10057ffd | 2017-04-10 | Simon Burns uk.org.publicwhip/person/10079 | 0 | 2017-04-10-10057ffd-10079-0 | |
4fdc7b9c4dfffcedb631ad9cce703ab18fd63fce | 3 January 2017, received £600 for an article for the Mail on Sunday. Hours: 2 hrs. (Registered 09 January 2017) | Employment and earnings 10057ffd | 2017-04-10 | Simon Burns uk.org.publicwhip/person/10079 | 1 | 2017-04-10-10057ffd-10079-0 | |
f6e2b8815fed4a0fd720f89e94c334fc8d5df840 | 6 March 2017, received £550 for an article for the Mail on Sunday. Hours: 2 hrs. (Registered 09 March 2017) | Employment and earnings 10057ffd | 2017-04-10 | Simon Burns uk.org.publicwhip/person/10079 | 2 | 2017-04-10-10057ffd-10079-0 | |
49056d3adf02f8b53b2ce5cfcb6bddc63a07ba7b | Payments from Associated Newspapers Limited of Northcliffe House, 2 Derry Street, London, W8 5TT: | Employment and earnings 10057ffd | 2017-05-02 | Simon Burns uk.org.publicwhip/person/10079 | 0 | 2017-05-02-10057ffd-10079-0 | |
59b38d48887338e41eecdea7e06d486e69876a0a | 3 January 2017, received £600 for an article for the Mail on Sunday. Hours: 2 hrs. (Registered 09 January 2017) | Employment and earnings 10057ffd | 2017-05-02 | Simon Burns uk.org.publicwhip/person/10079 | 1 | 2017-05-02-10057ffd-10079-0 | |
2e844d1828542fdf7f6c2be0845d5261e96d164a | 6 March 2017, received £550 for an article for the Mail on Sunday. Hours: 2 hrs. (Registered 09 March 2017) | Employment and earnings 10057ffd | 2017-05-02 | Simon Burns uk.org.publicwhip/person/10079 | 2 | 2017-05-02-10057ffd-10079-0 | |
206e840a1d450ff765417d0e1b72acb675732521 | Name of donor: The Government of Taiwan Address of donor: Taipei Representative Office, 50 Grosvenor Gardens, London SW1W 0EB Estimate of the probable value (or amount of any donation): Flights, accommodation and hospitality to the value of £5,010 Destination of visit: Taiwan Dates of visit: 8–15 April 2017 Purpose of visit: British-Taiwanese APPG visit to assess relations between the UK and Taiwan and the current relationship between Taiwan and the People’s Republic of China. (Registered 18 April 2017) | Visits outside the UK 891eb863 | 2017-05-02 | Simon Burns uk.org.publicwhip/person/10079 | 0 | 2017-05-02-891eb863-10079-0 | |
513b47059604d5dcaae7a7f1a4f729ab9d11300a | Fees from House Magazine for speeches to their "Westminster Explained" seminars. (Up to £5,000) | Remunerated employment, office, profession etc 1f359ece | 2005-11-01 | Simon Burns uk.org.publicwhip/member/1493 | Simon Burns uk.org.publicwhip/person/10079 | 0 | 2005-11-01-1f359ece-10079-0 |
b011a846d7f3f664cea60ed939e6937ab23bd248 | 3-7 January 2005, to Jordan, to meet the King, Government ministers and Members of Parliament to discuss Middle East peace process. Flight and accommodation paid for by the Jordanian Government. (Registered 8 January 2005) | Overseas visits 80ef1083 | 2005-11-01 | Simon Burns uk.org.publicwhip/member/1493 | Simon Burns uk.org.publicwhip/person/10079 | 0 | 2005-11-01-80ef1083-10079-0 |
ab2bfd8e91d8b10c07d58df135e5acc14239be61 | Fees from House Magazine for speeches to their "Westminster Explained" seminars. (Up to £5,000) | Remunerated employment, office, profession etc 1f359ece | 2005-12-14 | Simon Burns uk.org.publicwhip/member/1493 | Simon Burns uk.org.publicwhip/person/10079 | 0 | 2005-12-14-1f359ece-10079-0 |
b7bac579d2d6fded97a8513aa85325163a29a0cc | 3-7 January 2005, to Jordan, to meet the King, Government ministers and Members of Parliament to discuss Middle East peace process. Flight and accommodation paid for by the Jordanian Government. (Registered 8 January 2005) | Overseas visits 80ef1083 | 2005-12-14 | Simon Burns uk.org.publicwhip/member/1493 | Simon Burns uk.org.publicwhip/person/10079 | 0 | 2005-12-14-80ef1083-10079-0 |
3a33293d6faaefb1cea7c56ac67e568916c8fd15 | 24-29 November 2005, to United Arab Emirates as guest of the Government of UAE, who met the costs of flights and accommodation. (Registered 30 November 2005) | Overseas visits 80ef1083 | 2005-12-14 | Simon Burns uk.org.publicwhip/member/1493 | Simon Burns uk.org.publicwhip/person/10079 | 1 | 2005-12-14-80ef1083-10079-0 |
7b319a41514b7423b921594b97fbbd2f9a918362 | Fees from House Magazine for speeches to their "Westminster Explained" seminars. (Up to £5,000) | Remunerated employment, office, profession etc 1f359ece | 2006-02-13 | Simon Burns uk.org.publicwhip/member/1493 | Simon Burns uk.org.publicwhip/person/10079 | 0 | 2006-02-13-1f359ece-10079-0 |
045056dac385c4188e37e7aa95b9908b7d13b700 | 24-29 November 2005, to United Arab Emirates as guest of the Government of UAE, who met the costs of flights and accommodation. (Registered 30 November 2005) | Overseas visits 80ef1083 | 2006-02-13 | Simon Burns uk.org.publicwhip/member/1493 | Simon Burns uk.org.publicwhip/person/10079 | 0 | 2006-02-13-80ef1083-10079-0 |
d8d23e457c3fab90e3196a111887c36c994887fe | 1-9 January 2006, to India as the guest of the Confederation of Indian Industry, who paid for my flights and accommodation. (Registered 17 January 2006) | Overseas visits 80ef1083 | 2006-02-13 | Simon Burns uk.org.publicwhip/member/1493 | Simon Burns uk.org.publicwhip/person/10079 | 1 | 2006-02-13-80ef1083-10079-0 |
7498c723353711a0ba74f77ed2450f8cf344f470 | Fees from House Magazine for speeches to their "Westminster Explained" seminars. (Up to £5,000) | Remunerated employment, office, profession etc 1f359ece | 2006-02-14 | Simon Burns uk.org.publicwhip/member/1493 | Simon Burns uk.org.publicwhip/person/10079 | 0 | 2006-02-14-1f359ece-10079-0 |
f5684161fcd0a674c0b90123a1c898e5aa4a3adf | 24-29 November 2005, to United Arab Emirates as guest of the Government of UAE, who met the costs of flights and accommodation. (Registered 30 November 2005) | Overseas visits 80ef1083 | 2006-02-14 | Simon Burns uk.org.publicwhip/member/1493 | Simon Burns uk.org.publicwhip/person/10079 | 0 | 2006-02-14-80ef1083-10079-0 |
75240db0e4f255147c55240659ffe474d3de89f1 | 1-9 January 2006, to India as the guest of the Confederation of Indian Industry, who paid for my flights and accommodation. (Registered 17 January 2006) | Overseas visits 80ef1083 | 2006-02-14 | Simon Burns uk.org.publicwhip/member/1493 | Simon Burns uk.org.publicwhip/person/10079 | 1 | 2006-02-14-80ef1083-10079-0 |
07feea255dd70fd37ee9d019e2cf363e376259c7 | Fees from House Magazine for speeches to their "Westminster Explained" seminars. (Up to £5,000) | Remunerated employment, office, profession etc 1f359ece | 2006-03-24 | Simon Burns uk.org.publicwhip/member/1493 | Simon Burns uk.org.publicwhip/person/10079 | 0 | 2006-03-24-1f359ece-10079-0 |
340dd77a074c78defb3bdca02bd49a071f46b245 | 24-29 November 2005, to United Arab Emirates as guest of the Government of UAE, who met the costs of flights and accommodation. (Registered 30 November 2005) | Overseas visits 80ef1083 | 2006-03-24 | Simon Burns uk.org.publicwhip/member/1493 | Simon Burns uk.org.publicwhip/person/10079 | 0 | 2006-03-24-80ef1083-10079-0 |
c192a117d377bafc95c571242ad37dcd92f72d2d | 1-9 January 2006, to India as the guest of the Confederation of Indian Industry, who paid for my flights and accommodation. (Registered 17 January 2006) | Overseas visits 80ef1083 | 2006-03-24 | Simon Burns uk.org.publicwhip/member/1493 | Simon Burns uk.org.publicwhip/person/10079 | 1 | 2006-03-24-80ef1083-10079-0 |
875e92fae83364a3c353539caec6986357c21b32 | Fees from House Magazine for speeches to their "Westminster Explained" seminars. (Up to £5,000) | Remunerated employment, office, profession etc 1f359ece | 2006-05-12 | Simon Burns uk.org.publicwhip/member/1493 | Simon Burns uk.org.publicwhip/person/10079 | 0 | 2006-05-12-1f359ece-10079-0 |
25a2fabbee40e3d8c49d53c4ea0ef491fa32260c | 24-29 November 2005, to United Arab Emirates as guest of the Government of UAE, who met the costs of flights and accommodation. (Registered 30 November 2005) | Overseas visits 80ef1083 | 2006-05-12 | Simon Burns uk.org.publicwhip/member/1493 | Simon Burns uk.org.publicwhip/person/10079 | 0 | 2006-05-12-80ef1083-10079-0 |
5b87821ad68834489844daf4e4ab3bfd4b8ecc2f | 1-9 January 2006, to India as the guest of the Confederation of Indian Industry, who paid for my flights and accommodation. (Registered 17 January 2006) | Overseas visits 80ef1083 | 2006-05-12 | Simon Burns uk.org.publicwhip/member/1493 | Simon Burns uk.org.publicwhip/person/10079 | 1 | 2006-05-12-80ef1083-10079-0 |
786a59fce43aa09e67927fa73aad677d9a8a8500 | 11-15 April 2006, to Qatar, to attend the 6 th Conference on Democracy, Security and Trade. Flights and accommodation paid for by the Government of Qatar. (Registered 18 April 2006) | Overseas visits 80ef1083 | 2006-05-12 | Simon Burns uk.org.publicwhip/member/1493 | Simon Burns uk.org.publicwhip/person/10079 | 2 | 2006-05-12-80ef1083-10079-0 |
bf4a737c41a3afb6eaa84e3a5b90e60d9a45c71f | Fees from House Magazine for speeches to their "Westminster Explained" seminars. (Up to £5,000) | Remunerated employment, office, profession etc 1f359ece | 2006-06-21 | Simon Burns uk.org.publicwhip/member/1493 | Simon Burns uk.org.publicwhip/person/10079 | 0 | 2006-06-21-1f359ece-10079-0 |
d1a0c606d1a8e0cd3bbf8579b834c8e484a0a888 | 24-29 November 2005, to United Arab Emirates as guest of the Government of UAE, who met the costs of flights and accommodation. (Registered 30 November 2005) | Overseas visits 80ef1083 | 2006-06-21 | Simon Burns uk.org.publicwhip/member/1493 | Simon Burns uk.org.publicwhip/person/10079 | 0 | 2006-06-21-80ef1083-10079-0 |
8196d85f2c1b8e3c43783092ee91f7442da98d08 | 1-9 January 2006, to India as the guest of the Confederation of Indian Industry, who paid for my flights and accommodation. (Registered 17 January 2006) | Overseas visits 80ef1083 | 2006-06-21 | Simon Burns uk.org.publicwhip/member/1493 | Simon Burns uk.org.publicwhip/person/10079 | 1 | 2006-06-21-80ef1083-10079-0 |
4c6e65bec80915a37bc4edfe07bf975389279066 | 11-15 April 2006, to Qatar, to attend the 6 th Conference on Democracy, Security and Trade. Flights and accommodation paid for by the Government of Qatar. (Registered 18 April 2006) | Overseas visits 80ef1083 | 2006-06-21 | Simon Burns uk.org.publicwhip/member/1493 | Simon Burns uk.org.publicwhip/person/10079 | 2 | 2006-06-21-80ef1083-10079-0 |
b8566b2dab9624ffbfe75b77eb1e24c5abc99d63 | 24-29 November 2005, to United Arab Emirates as guest of the Government of UAE, who met the costs of flights and accommodation. (Registered 30 November 2005) | Overseas visits 80ef1083 | 2006-07-25 | Simon Burns uk.org.publicwhip/member/1493 | Simon Burns uk.org.publicwhip/person/10079 | 0 | 2006-07-25-80ef1083-10079-0 |
7c6f1dfc879691ac507a57680aabc7b2d6983bd1 | 1-9 January 2006, to India as the guest of the Confederation of Indian Industry, who paid for my flights and accommodation. (Registered 17 January 2006) | Overseas visits 80ef1083 | 2006-07-25 | Simon Burns uk.org.publicwhip/member/1493 | Simon Burns uk.org.publicwhip/person/10079 | 1 | 2006-07-25-80ef1083-10079-0 |
cb645fae8b02420c1254c9d0c9da12064fad3ddd | 11-15 April 2006, to Qatar, to attend the 6 th Conference on Democracy, Security and Trade. Flights and accommodation paid for by the Government of Qatar. (Registered 18 April 2006) | Overseas visits 80ef1083 | 2006-07-25 | Simon Burns uk.org.publicwhip/member/1493 | Simon Burns uk.org.publicwhip/person/10079 | 2 | 2006-07-25-80ef1083-10079-0 |
3141bffcc6003a2eae206fdc4dbc376af462dd75 | 24-29 November 2005, to United Arab Emirates as guest of the Government of UAE, who met the costs of flights and accommodation. (Registered 30 November 2005) | Overseas visits 80ef1083 | 2006-09-19 | Simon Burns uk.org.publicwhip/member/1493 | Simon Burns uk.org.publicwhip/person/10079 | 0 | 2006-09-19-80ef1083-10079-0 |
39d4236858fd7f8175f94b82a6545c457aa2a595 | 1-9 January 2006, to India as the guest of the Confederation of Indian Industry, who paid for my flights and accommodation. (Registered 17 January 2006) | Overseas visits 80ef1083 | 2006-09-19 | Simon Burns uk.org.publicwhip/member/1493 | Simon Burns uk.org.publicwhip/person/10079 | 1 | 2006-09-19-80ef1083-10079-0 |
8023c4d38334ed6014d6e7d6ee62701afe0f7459 | 11-15 April 2006, to Qatar, to attend the 6 th Conference on Democracy, Security and Trade. Flights and accommodation paid for by the Government of Qatar. (Registered 18 April 2006) | Overseas visits 80ef1083 | 2006-09-19 | Simon Burns uk.org.publicwhip/member/1493 | Simon Burns uk.org.publicwhip/person/10079 | 2 | 2006-09-19-80ef1083-10079-0 |
761eb48cf7fffa3e79c18923a6d378149f10922a | 24-29 November 2005, to United Arab Emirates as guest of the Government of UAE, who met the costs of flights and accommodation. (Registered 30 November 2005) | Overseas visits 80ef1083 | 2006-11-06 | Simon Burns uk.org.publicwhip/member/1493 | Simon Burns uk.org.publicwhip/person/10079 | 0 | 2006-11-06-80ef1083-10079-0 |
afd3be72062cf70d2a903b8eb6c1f1faeb114b15 | 1-9 January 2006, to India as the guest of the Confederation of Indian Industry, who paid for my flights and accommodation. (Registered 17 January 2006) | Overseas visits 80ef1083 | 2006-11-06 | Simon Burns uk.org.publicwhip/member/1493 | Simon Burns uk.org.publicwhip/person/10079 | 1 | 2006-11-06-80ef1083-10079-0 |
5a3ab9b383e1ba47e238aaa761742c5454f541d2 | 11-15 April 2006, to Qatar, to attend the 6th Conference on Democracy, Security and Trade. Flights and accommodation paid for by the Government of Qatar. (Registered 18 April 2006) | Overseas visits 80ef1083 | 2006-11-06 | Simon Burns uk.org.publicwhip/member/1493 | Simon Burns uk.org.publicwhip/person/10079 | 2 | 2006-11-06-80ef1083-10079-0 |
8a4435e1c55ac29ad827a7fc0b080145afb2bcef | 16-22 September 2006, to Hong Kong, to study how the agreement following handover to China is working. Flights and accommodation paid for by the Hong Kong Government. (Registered 22 September2006) | Overseas visits 80ef1083 | 2006-11-06 | Simon Burns uk.org.publicwhip/member/1493 | Simon Burns uk.org.publicwhip/person/10079 | 3 | 2006-11-06-80ef1083-10079-0 |
93d0cdb4ada00385c67df652106ed9b75395baf8 | 24-29 November 2005, to United Arab Emirates as guest of the Government of UAE, who met the costs of flights and accommodation. (Registered 30 November 2005) | Overseas visits 80ef1083 | 2006-11-27 | Simon Burns uk.org.publicwhip/member/1493 | Simon Burns uk.org.publicwhip/person/10079 | 0 | 2006-11-27-80ef1083-10079-0 |
5323680f941a11e52204827de52741abe1e9cea7 | 1-9 January 2006, to India as the guest of the Confederation of Indian Industry, who paid for my flights and accommodation. (Registered 17 January 2006) | Overseas visits 80ef1083 | 2006-11-27 | Simon Burns uk.org.publicwhip/member/1493 | Simon Burns uk.org.publicwhip/person/10079 | 1 | 2006-11-27-80ef1083-10079-0 |
95e3c8302d6859107fbdec10ac358e9a6cf884c8 | 11-15 April 2006, to Qatar, to attend the 6 th Conference on Democracy, Security and Trade. Flights and accommodation paid for by the Government of Qatar. (Registered 18 April 2006) | Overseas visits 80ef1083 | 2006-11-27 | Simon Burns uk.org.publicwhip/member/1493 | Simon Burns uk.org.publicwhip/person/10079 | 2 | 2006-11-27-80ef1083-10079-0 |
56a5460f66b7661dd105efb2a27165c3f3abe353 | 16-22 September 2006, to Hong Kong, to study how the agreement following handover to China is working. Flights and accommodation paid for by the Hong Kong Government. (Registered 22 September2006) | Overseas visits 80ef1083 | 2006-11-27 | Simon Burns uk.org.publicwhip/member/1493 | Simon Burns uk.org.publicwhip/person/10079 | 3 | 2006-11-27-80ef1083-10079-0 |
5605ec54eb5c3469cf7006da74dc60913c724e26 | 24-29 November 2005, to United Arab Emirates as guest of the Government of UAE, who met the costs of flights and accommodation. (Registered 30 November 2005) | Overseas visits 80ef1083 | 2006-12-11 | Simon Burns uk.org.publicwhip/member/1493 | Simon Burns uk.org.publicwhip/person/10079 | 0 | 2006-12-11-80ef1083-10079-0 |
e3e39d95f64ea383f65363284b30cf61e464e68f | 1-9 January 2006, to India as the guest of the Confederation of Indian Industry, who paid for my flights and accommodation. (Registered 17 January 2006) | Overseas visits 80ef1083 | 2006-12-11 | Simon Burns uk.org.publicwhip/member/1493 | Simon Burns uk.org.publicwhip/person/10079 | 1 | 2006-12-11-80ef1083-10079-0 |
49933df16a75fea92fa796ccd16ad09be69e6250 | 11-15 April 2006, to Qatar, to attend the 6 th Conference on Democracy, Security and Trade. Flights and accommodation paid for by the Government of Qatar. (Registered 18 April 2006) | Overseas visits 80ef1083 | 2006-12-11 | Simon Burns uk.org.publicwhip/member/1493 | Simon Burns uk.org.publicwhip/person/10079 | 2 | 2006-12-11-80ef1083-10079-0 |
e3fe795dba8656486b0a07f6efbc51d9b757431a | 16-22 September 2006, to Hong Kong, to study how the agreement following handover to China is working. Flights and accommodation paid for by the Hong Kong Government. (Registered 22 September2006) | Overseas visits 80ef1083 | 2006-12-11 | Simon Burns uk.org.publicwhip/member/1493 | Simon Burns uk.org.publicwhip/person/10079 | 3 | 2006-12-11-80ef1083-10079-0 |
43f72405aa44955dd685b5219bf463083ade7cca | 24-29 November 2005, to United Arab Emirates as guest of the Government of UAE, who met the costs of flights and accommodation. (Registered 30 November 2005) | Overseas visits 80ef1083 | 2007-01-09 | Simon Burns uk.org.publicwhip/member/1493 | Simon Burns uk.org.publicwhip/person/10079 | 0 | 2007-01-09-80ef1083-10079-0 |
bff07c81a132778ca277d78bc2714b061a452fef | 1-9 January 2006, to India as the guest of the Confederation of Indian Industry, who paid for my flights and accommodation. (Registered 17 January 2006) | Overseas visits 80ef1083 | 2007-01-09 | Simon Burns uk.org.publicwhip/member/1493 | Simon Burns uk.org.publicwhip/person/10079 | 1 | 2007-01-09-80ef1083-10079-0 |
b879c52be71464660c9292da49ea1c98611b3794 | 11-15 April 2006, to Qatar, to attend the 6 th Conference on Democracy, Security and Trade. Flights and accommodation paid for by the Government of Qatar. (Registered 18 April 2006) | Overseas visits 80ef1083 | 2007-01-09 | Simon Burns uk.org.publicwhip/member/1493 | Simon Burns uk.org.publicwhip/person/10079 | 2 | 2007-01-09-80ef1083-10079-0 |
cdf50959e018bd68a4de2c0f033b588d57a0e518 | 16-22 September 2006, to Hong Kong, to study how the agreement following handover to China is working. Flights and accommodation paid for by the Hong Kong Government. (Registered 22 September2006) | Overseas visits 80ef1083 | 2007-01-09 | Simon Burns uk.org.publicwhip/member/1493 | Simon Burns uk.org.publicwhip/person/10079 | 3 | 2007-01-09-80ef1083-10079-0 |
bb928f498b994df0a67813a4917be096009ff3f5 | 24-29 November 2005, to United Arab Emirates as guest of the Government of UAE, who met the costs of flights and accommodation. (Registered 30 November 2005) | Overseas visits 80ef1083 | 2007-01-23 | Simon Burns uk.org.publicwhip/member/1493 | Simon Burns uk.org.publicwhip/person/10079 | 0 | 2007-01-23-80ef1083-10079-0 |
89e3df46833ae3ecf5be199e3c2f1dc64c51777e | 1-9 January 2006, to India as the guest of the Confederation of Indian Industry, who paid for my flights and accommodation. (Registered 17 January 2006) | Overseas visits 80ef1083 | 2007-01-23 | Simon Burns uk.org.publicwhip/member/1493 | Simon Burns uk.org.publicwhip/person/10079 | 1 | 2007-01-23-80ef1083-10079-0 |
da12dc1ada6e0f66e28f3dada50058142938f5b4 | 11-15 April 2006, to Qatar, to attend the 6 th Conference on Democracy, Security and Trade. Flights and accommodation paid for by the Government of Qatar. (Registered 18 April 2006) | Overseas visits 80ef1083 | 2007-01-23 | Simon Burns uk.org.publicwhip/member/1493 | Simon Burns uk.org.publicwhip/person/10079 | 2 | 2007-01-23-80ef1083-10079-0 |
b85f98b99d598823e8495cd82c1b6cd371b70e67 | 16-22 September 2006, to Hong Kong, to study how the agreement following handover to China is working. Flights and accommodation paid for by the Hong Kong Government. (Registered 22 September2006) | Overseas visits 80ef1083 | 2007-01-23 | Simon Burns uk.org.publicwhip/member/1493 | Simon Burns uk.org.publicwhip/person/10079 | 3 | 2007-01-23-80ef1083-10079-0 |
a7e0cac2ce6348aedc65620e2b6507fe14c0388f | 24-29 November 2005, to United Arab Emirates as guest of the Government of UAE, who met the costs of flights and accommodation. (Registered 30 November 2005) | Overseas visits 80ef1083 | 2007-02-06 | Simon Burns uk.org.publicwhip/member/1493 | Simon Burns uk.org.publicwhip/person/10079 | 0 | 2007-02-06-80ef1083-10079-0 |
2a713c63a1fbed0bfca01d63198a0decc5720b45 | 1-9 January 2006, to India as the guest of the Confederation of Indian Industry, who paid for my flights and accommodation. (Registered 17 January 2006) | Overseas visits 80ef1083 | 2007-02-06 | Simon Burns uk.org.publicwhip/member/1493 | Simon Burns uk.org.publicwhip/person/10079 | 1 | 2007-02-06-80ef1083-10079-0 |
714400d27d4078899d64ec4a7a05256f7578c441 | 11-15 April 2006, to Qatar, to attend the 6 th Conference on Democracy, Security and Trade. Flights and accommodation paid for by the Government of Qatar. (Registered 18 April 2006) | Overseas visits 80ef1083 | 2007-02-06 | Simon Burns uk.org.publicwhip/member/1493 | Simon Burns uk.org.publicwhip/person/10079 | 2 | 2007-02-06-80ef1083-10079-0 |
aafed59b469b72c4ed0062d5dd8d73e5ffd3ec3d | 16-22 September 2006, to Hong Kong, to study how the agreement following handover to China is working. Flights and accommodation paid for by the Hong Kong Government. (Registered 22 September2006) | Overseas visits 80ef1083 | 2007-02-06 | Simon Burns uk.org.publicwhip/member/1493 | Simon Burns uk.org.publicwhip/person/10079 | 3 | 2007-02-06-80ef1083-10079-0 |
540e5352363567139e4f704a65bad99c8809ceb5 | 24-29 November 2005, to United Arab Emirates as guest of the Government of UAE, who met the costs of flights and accommodation. (Registered 30 November 2005) | Overseas visits 80ef1083 | 2007-02-27 | Simon Burns uk.org.publicwhip/member/1493 | Simon Burns uk.org.publicwhip/person/10079 | 0 | 2007-02-27-80ef1083-10079-0 |
486d75c5b8b1892bc4ca72055731cbc7d7a001f9 | 1-9 January 2006, to India as the guest of the Confederation of Indian Industry, who paid for my flights and accommodation. (Registered 17 January 2006) | Overseas visits 80ef1083 | 2007-02-27 | Simon Burns uk.org.publicwhip/member/1493 | Simon Burns uk.org.publicwhip/person/10079 | 1 | 2007-02-27-80ef1083-10079-0 |
72eb04215912eb6e92b73dd6ce4285ae2e2c50eb | 11-15 April 2006, to Qatar, to attend the 6 th Conference on Democracy, Security and Trade. Flights and accommodation paid for by the Government of Qatar. (Registered 18 April 2006) | Overseas visits 80ef1083 | 2007-02-27 | Simon Burns uk.org.publicwhip/member/1493 | Simon Burns uk.org.publicwhip/person/10079 | 2 | 2007-02-27-80ef1083-10079-0 |
46c9c945afa4514315621177e18d20d427947749 | 16-22 September 2006, to Hong Kong, to study how the agreement following handover to China is working. Flights and accommodation paid for by the Hong Kong Government. (Registered 22 September2006) | Overseas visits 80ef1083 | 2007-02-27 | Simon Burns uk.org.publicwhip/member/1493 | Simon Burns uk.org.publicwhip/person/10079 | 3 | 2007-02-27-80ef1083-10079-0 |
db122839bc6aeb40457b81e24225358f59e20551 | 24-29 November 2005, to United Arab Emirates as guest of the Government of UAE, who met the costs of flights and accommodation. (Registered 30 November 2005) | Overseas visits 80ef1083 | 2007-03-13 | Simon Burns uk.org.publicwhip/member/1493 | Simon Burns uk.org.publicwhip/person/10079 | 0 | 2007-03-13-80ef1083-10079-0 |
0aa542058facc2ddec3f48931c95e1f73b76e96d | 1-9 January 2006, to India as the guest of the Confederation of Indian Industry, who paid for my flights and accommodation. (Registered 17 January 2006) | Overseas visits 80ef1083 | 2007-03-13 | Simon Burns uk.org.publicwhip/member/1493 | Simon Burns uk.org.publicwhip/person/10079 | 1 | 2007-03-13-80ef1083-10079-0 |
0cb6c7005b9387bc72c41f1a04b54197d3b23655 | 11-15 April 2006, to Qatar, to attend the 6 th Conference on Democracy, Security and Trade. Flights and accommodation paid for by the Government of Qatar. (Registered 18 April 2006) | Overseas visits 80ef1083 | 2007-03-13 | Simon Burns uk.org.publicwhip/member/1493 | Simon Burns uk.org.publicwhip/person/10079 | 2 | 2007-03-13-80ef1083-10079-0 |
f6ef67f88d7c6da9c007b62729ff1979b5c67d21 | 16-22 September 2006, to Hong Kong, to study how the agreement following handover to China is working. Flights and accommodation paid for by the Hong Kong Government. (Registered 22 September2006) | Overseas visits 80ef1083 | 2007-03-13 | Simon Burns uk.org.publicwhip/member/1493 | Simon Burns uk.org.publicwhip/person/10079 | 3 | 2007-03-13-80ef1083-10079-0 |
ce748278f19670b1027c52da35eca16ec1bd9702 | 7-11 February 2007, to India, to visit outsourced operations in Bangalore and the UK Consular Entry Clearance Section in Mumbai. All travel and accommodation costs met by Norwich Union. (Registered 16 February 2007) | Overseas visits 80ef1083 | 2007-03-13 | Simon Burns uk.org.publicwhip/member/1493 | Simon Burns uk.org.publicwhip/person/10079 | 4 | 2007-03-13-80ef1083-10079-0 |
cf82570f1137790e801cb77a0ddc836c13a360dd | 24-29 November 2005, to United Arab Emirates as guest of the Government of UAE, who met the costs of flights and accommodation. (Registered 30 November 2005) | Overseas visits 80ef1083 | 2007-03-26 | Simon Burns uk.org.publicwhip/member/1493 | Simon Burns uk.org.publicwhip/person/10079 | 0 | 2007-03-26-80ef1083-10079-0 |
67e2d5aa589f26f6615fc4053671a4b3a8d90b91 | 1-9 January 2006, to India as the guest of the Confederation of Indian Industry, who paid for my flights and accommodation. (Registered 17 January 2006) | Overseas visits 80ef1083 | 2007-03-26 | Simon Burns uk.org.publicwhip/member/1493 | Simon Burns uk.org.publicwhip/person/10079 | 1 | 2007-03-26-80ef1083-10079-0 |
dcdbea3e2ddb0aa8607f9dc956264cf987ddcc7f | 11-15 April 2006, to Qatar, to attend the 6 th Conference on Democracy, Security and Trade. Flights and accommodation paid for by the Government of Qatar. (Registered 18 April 2006) | Overseas visits 80ef1083 | 2007-03-26 | Simon Burns uk.org.publicwhip/member/1493 | Simon Burns uk.org.publicwhip/person/10079 | 2 | 2007-03-26-80ef1083-10079-0 |
bd011bc467047704dbe211ee36a36048df7e555a | 16-22 September 2006, to Hong Kong, to study how the agreement following handover to China is working. Flights and accommodation paid for by the Hong Kong Government. (Registered 22 September2006) | Overseas visits 80ef1083 | 2007-03-26 | Simon Burns uk.org.publicwhip/member/1493 | Simon Burns uk.org.publicwhip/person/10079 | 3 | 2007-03-26-80ef1083-10079-0 |
521cc95186abbda49ca3f942ea6e0ba324266625 | 7-11 February 2007, to India, to visit outsourced operations in Bangalore and the UK Consular Entry Clearance Section in Mumbai. All travel and accommodation costs met by Norwich Union. (Registered 16 February 2007) | Overseas visits 80ef1083 | 2007-03-26 | Simon Burns uk.org.publicwhip/member/1493 | Simon Burns uk.org.publicwhip/person/10079 | 4 | 2007-03-26-80ef1083-10079-0 |
51aaf12a480b2ebee67e163c70ef4599a3034ba2 | 16-22 September 2006, to Hong Kong, to study how the agreement following handover to China is working. Flights and accommodation paid for by the Hong Kong Government. (Registered 22 September2006) | Overseas visits 80ef1083 | 2007-05-01 | Simon Burns uk.org.publicwhip/member/1493 | Simon Burns uk.org.publicwhip/person/10079 | 0 | 2007-05-01-80ef1083-10079-0 |
c0c5978cd335912220da2d526f7c4dd65f346522 | 7-11 February 2007, to India, to visit outsourced operations in Bangalore and the UK Consular Entry Clearance Section in Mumbai. All travel and accommodation costs met by Norwich Union. (Registered 16 February 2007) | Overseas visits 80ef1083 | 2007-05-01 | Simon Burns uk.org.publicwhip/member/1493 | Simon Burns uk.org.publicwhip/person/10079 | 1 | 2007-05-01-80ef1083-10079-0 |
b5d10dd6842eda25d041d2d738a72d4713c9a438 | 13-16 April 2007, to Dubai, UAE, to give a speech at the World Forum. Economy flight and hotel accommodation paid for by the World Forum. (Registered 16 April 2007) | Overseas visits 80ef1083 | 2007-05-01 | Simon Burns uk.org.publicwhip/member/1493 | Simon Burns uk.org.publicwhip/person/10079 | 2 | 2007-05-01-80ef1083-10079-0 |
2c29fa6ec00d36ab382a5a687e941ae47166cbbd | 22-25 April 2007, to Qatar to attend the 7 th Conference on Democracy, Security and Trade. Flights and accommodation paid for by the Government of Qatar. (Registered 26 April 2007) | Overseas visits 80ef1083 | 2007-05-01 | Simon Burns uk.org.publicwhip/member/1493 | Simon Burns uk.org.publicwhip/person/10079 | 3 | 2007-05-01-80ef1083-10079-0 |
d92ad205d74be8e02f8ea5f71baef2fd44693f5f | 16-22 September 2006, to Hong Kong, to study how the agreement following handover to China is working. Flights and accommodation paid for by the Hong Kong Government. (Registered 22 September2006) | Overseas visits 80ef1083 | 2007-05-15 | Simon Burns uk.org.publicwhip/member/1493 | Simon Burns uk.org.publicwhip/person/10079 | 0 | 2007-05-15-80ef1083-10079-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");