items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
3,823 rows where person_id = "uk.org.publicwhip/person/10259" sorted by record_id
This data as json, CSV (advanced)
Suggested facets: category_id, member_id, date (date)
hash | item | category_id | date | member_id | person_id | sort_order | record_id ▼ |
---|---|---|---|---|---|---|---|
b18ce24defdceb1d0f1ba8bbebc561965ee52c9e | Occasional fees for speaking engagements. | Remunerated employment, office, profession etc 1f359ece | 2002-05-14 | David Hanson uk.org.publicwhip/member/938 | David Hanson uk.org.publicwhip/person/10259 | 0 | 2002-05-14-1f359ece-10259-0 |
453fa7deda729313f97b3c6e7abe4db94499898d | Support in the capacity as an MP: | Sponsorships 8f616a6e | 2010-11-22 | David Hanson uk.org.publicwhip/member/40199 | David Hanson uk.org.publicwhip/person/10259 | 0 | 2010-11-22-8f616a6e-10259-0 |
0317a8d4d8a73c0a03b2d96593621d4f47a46ed0 | Name of donor: PricewaterhouseCoopers | Sponsorships 8f616a6e | 2010-11-22 | David Hanson uk.org.publicwhip/member/40199 | David Hanson uk.org.publicwhip/person/10259 | 1 | 2010-11-22-8f616a6e-10259-0 |
eece299838f7c60f8a1f415b40423309ade108d2 | Address of donor: 1 Embankment Place, London WC1N 6RH | Sponsorships 8f616a6e | 2010-11-22 | David Hanson uk.org.publicwhip/member/40199 | David Hanson uk.org.publicwhip/person/10259 | 2 | 2010-11-22-8f616a6e-10259-0 |
34809305530529d3e13c0ca8b31e7ec6be3f5b4c | Amount of donation or nature and value if donation in kind: ad hoc advice provided to the frontbench Treasury team during the passage of the Finance (No.2) Bill to the value of £11,000 | Sponsorships 8f616a6e | 2010-11-22 | David Hanson uk.org.publicwhip/member/40199 | David Hanson uk.org.publicwhip/person/10259 | 3 | 2010-11-22-8f616a6e-10259-0 |
cc643653db31c191599d2040107e217a910f3794 | Date of receipt: October/November 2010 | Sponsorships 8f616a6e | 2010-11-22 | David Hanson uk.org.publicwhip/member/40199 | David Hanson uk.org.publicwhip/person/10259 | 4 | 2010-11-22-8f616a6e-10259-0 |
a8e7403d9da1264aac344ac43354e7f3d1ab3343 | Date of acceptance: October 2010 | Sponsorships 8f616a6e | 2010-11-22 | David Hanson uk.org.publicwhip/member/40199 | David Hanson uk.org.publicwhip/person/10259 | 5 | 2010-11-22-8f616a6e-10259-0 |
53b502f0a92f48317e6be3a5069b1cdef8c5e1da | Donor status: limited liability partnership | Sponsorships 8f616a6e | 2010-11-22 | David Hanson uk.org.publicwhip/member/40199 | David Hanson uk.org.publicwhip/person/10259 | 6 | 2010-11-22-8f616a6e-10259-0 |
ef9c5fb91c46f0d1956af52db1db7d57cd026319 | (Registered 8 November 2010) | Sponsorships 8f616a6e | 2010-11-22 | David Hanson uk.org.publicwhip/member/40199 | David Hanson uk.org.publicwhip/person/10259 | 7 | 2010-11-22-8f616a6e-10259-0 |
370ae1d0a59edde6da8dfc982577901fb4fb3009 | Support in the capacity as an MP: | Sponsorships 8f616a6e | 2010-12-06 | David Hanson uk.org.publicwhip/member/40199 | David Hanson uk.org.publicwhip/person/10259 | 0 | 2010-12-06-8f616a6e-10259-0 |
e320d3100fe167233c6b2ecb34e8090fb0024c13 | Name of donor: PricewaterhouseCoopers | Sponsorships 8f616a6e | 2010-12-06 | David Hanson uk.org.publicwhip/member/40199 | David Hanson uk.org.publicwhip/person/10259 | 1 | 2010-12-06-8f616a6e-10259-0 |
8259fafd2cba3f7a3fb393ab9be868745a52a6bb | Address of donor: 1 Embankment Place, London WC1N 6RH | Sponsorships 8f616a6e | 2010-12-06 | David Hanson uk.org.publicwhip/member/40199 | David Hanson uk.org.publicwhip/person/10259 | 2 | 2010-12-06-8f616a6e-10259-0 |
448a18845202b9c6e5cb92e584e4139c28afc846 | Amount of donation or nature and value if donation in kind: ad hoc advice provided to the frontbench Treasury team during the passage of the Finance (No.2) Bill to the value of £11,000 | Sponsorships 8f616a6e | 2010-12-06 | David Hanson uk.org.publicwhip/member/40199 | David Hanson uk.org.publicwhip/person/10259 | 3 | 2010-12-06-8f616a6e-10259-0 |
3cf3bebc0d5e83cb4ec542a8536a1b5d63f0f9b3 | Date of receipt: October/November 2010 | Sponsorships 8f616a6e | 2010-12-06 | David Hanson uk.org.publicwhip/member/40199 | David Hanson uk.org.publicwhip/person/10259 | 4 | 2010-12-06-8f616a6e-10259-0 |
d3c0583379e14b3f704133cddedf7da100324e8e | Date of acceptance: October 2010 | Sponsorships 8f616a6e | 2010-12-06 | David Hanson uk.org.publicwhip/member/40199 | David Hanson uk.org.publicwhip/person/10259 | 5 | 2010-12-06-8f616a6e-10259-0 |
07a913a3f09e9c52e1152834bce5943dee398de5 | Donor status: limited liability partnership | Sponsorships 8f616a6e | 2010-12-06 | David Hanson uk.org.publicwhip/member/40199 | David Hanson uk.org.publicwhip/person/10259 | 6 | 2010-12-06-8f616a6e-10259-0 |
748fa529c322e9bd35027cdbaa94790960738817 | (Registered 8 November 2010) | Sponsorships 8f616a6e | 2010-12-06 | David Hanson uk.org.publicwhip/member/40199 | David Hanson uk.org.publicwhip/person/10259 | 7 | 2010-12-06-8f616a6e-10259-0 |
e0d8295c59d2ce45a6d6e302675276736c13add6 | Support in the capacity as an MP: | Sponsorships 8f616a6e | 2010-12-20 | David Hanson uk.org.publicwhip/member/40199 | David Hanson uk.org.publicwhip/person/10259 | 0 | 2010-12-20-8f616a6e-10259-0 |
fbba43021ddc2c93aa27160e3c513372cd21a6d5 | Name of donor: PricewaterhouseCoopers | Sponsorships 8f616a6e | 2010-12-20 | David Hanson uk.org.publicwhip/member/40199 | David Hanson uk.org.publicwhip/person/10259 | 1 | 2010-12-20-8f616a6e-10259-0 |
f79824de1dcc26abf08d8e662d135694410302c0 | Address of donor: 1 Embankment Place, London WC1N 6RH | Sponsorships 8f616a6e | 2010-12-20 | David Hanson uk.org.publicwhip/member/40199 | David Hanson uk.org.publicwhip/person/10259 | 2 | 2010-12-20-8f616a6e-10259-0 |
95708f453f9e270b841a67f0368ef4dbb01d9117 | Amount of donation or nature and value if donation in kind: ad hoc advice provided to the frontbench Treasury team during the passage of the Finance (No.2) Bill to the value of £11,000 | Sponsorships 8f616a6e | 2010-12-20 | David Hanson uk.org.publicwhip/member/40199 | David Hanson uk.org.publicwhip/person/10259 | 3 | 2010-12-20-8f616a6e-10259-0 |
deddb306af93fab73ce493046449d3321215e7f7 | Date of receipt: October/November 2010 | Sponsorships 8f616a6e | 2010-12-20 | David Hanson uk.org.publicwhip/member/40199 | David Hanson uk.org.publicwhip/person/10259 | 4 | 2010-12-20-8f616a6e-10259-0 |
d43a4e821d5af3334f982ce066a5ae9e6f09b8e9 | Date of acceptance: October 2010 | Sponsorships 8f616a6e | 2010-12-20 | David Hanson uk.org.publicwhip/member/40199 | David Hanson uk.org.publicwhip/person/10259 | 5 | 2010-12-20-8f616a6e-10259-0 |
070b9302170edb7985b6785d08aefbb22f81abb4 | Donor status: limited liability partnership | Sponsorships 8f616a6e | 2010-12-20 | David Hanson uk.org.publicwhip/member/40199 | David Hanson uk.org.publicwhip/person/10259 | 6 | 2010-12-20-8f616a6e-10259-0 |
48bd4d6ef230f7436a9ddd72dc256bb4c6ba8fdc | (Registered 8 November 2010) | Sponsorships 8f616a6e | 2010-12-20 | David Hanson uk.org.publicwhip/member/40199 | David Hanson uk.org.publicwhip/person/10259 | 7 | 2010-12-20-8f616a6e-10259-0 |
17cb5895b2a9ae4567495576b055c3fe4ff5e21f | Support in the capacity as an MP: | Sponsorships 8f616a6e | 2011-01-10 | David Hanson uk.org.publicwhip/member/40199 | David Hanson uk.org.publicwhip/person/10259 | 0 | 2011-01-10-8f616a6e-10259-0 |
fa13c17b7355d29f3bf54167cfa6be396add5d55 | Name of donor: PricewaterhouseCoopers | Sponsorships 8f616a6e | 2011-01-10 | David Hanson uk.org.publicwhip/member/40199 | David Hanson uk.org.publicwhip/person/10259 | 1 | 2011-01-10-8f616a6e-10259-0 |
bdcd86a865dc4e914c7d028901504f68680a8994 | Address of donor: 1 Embankment Place, London WC1N 6RH | Sponsorships 8f616a6e | 2011-01-10 | David Hanson uk.org.publicwhip/member/40199 | David Hanson uk.org.publicwhip/person/10259 | 2 | 2011-01-10-8f616a6e-10259-0 |
dd17455e1bac2f1fa761351661752d17bbbc0db3 | Amount of donation or nature and value if donation in kind: ad hoc advice provided to the frontbench Treasury team during the passage of the Finance (No.2) Bill to the value of £11,000 | Sponsorships 8f616a6e | 2011-01-10 | David Hanson uk.org.publicwhip/member/40199 | David Hanson uk.org.publicwhip/person/10259 | 3 | 2011-01-10-8f616a6e-10259-0 |
c44d6cf8c59499622a40b416fe3fb7e939b0cdfd | Date of receipt: October/November 2010 | Sponsorships 8f616a6e | 2011-01-10 | David Hanson uk.org.publicwhip/member/40199 | David Hanson uk.org.publicwhip/person/10259 | 4 | 2011-01-10-8f616a6e-10259-0 |
bb61904d88ba509ba84fc6f1fc50fa77d06803ff | Date of acceptance: October 2010 | Sponsorships 8f616a6e | 2011-01-10 | David Hanson uk.org.publicwhip/member/40199 | David Hanson uk.org.publicwhip/person/10259 | 5 | 2011-01-10-8f616a6e-10259-0 |
c35828dc42c5f0db81b54d30962ea7b09be916ee | Donor status: limited liability partnership | Sponsorships 8f616a6e | 2011-01-10 | David Hanson uk.org.publicwhip/member/40199 | David Hanson uk.org.publicwhip/person/10259 | 6 | 2011-01-10-8f616a6e-10259-0 |
222fe6ac7e5a6e189202a92b5b447260e4096f3e | (Registered 8 November 2010) | Sponsorships 8f616a6e | 2011-01-10 | David Hanson uk.org.publicwhip/member/40199 | David Hanson uk.org.publicwhip/person/10259 | 7 | 2011-01-10-8f616a6e-10259-0 |
5adb5ba09cca17935bb07b8ce01ab3905e84f0f0 | Support in the capacity as an MP: | Sponsorships 8f616a6e | 2011-01-24 | David Hanson uk.org.publicwhip/member/40199 | David Hanson uk.org.publicwhip/person/10259 | 0 | 2011-01-24-8f616a6e-10259-0 |
2d3c05054ed65a794080517a59235d8a3d2f62d4 | Name of donor: PricewaterhouseCoopers | Sponsorships 8f616a6e | 2011-01-24 | David Hanson uk.org.publicwhip/member/40199 | David Hanson uk.org.publicwhip/person/10259 | 1 | 2011-01-24-8f616a6e-10259-0 |
49be7ebe3bebf7fd16d1fa7807a144006548ac86 | Address of donor: 1 Embankment Place, London WC1N 6RH | Sponsorships 8f616a6e | 2011-01-24 | David Hanson uk.org.publicwhip/member/40199 | David Hanson uk.org.publicwhip/person/10259 | 2 | 2011-01-24-8f616a6e-10259-0 |
15d94ebcad8fad9fd2bf0a644f650aeb86e7ece4 | Amount of donation or nature and value if donation in kind: ad hoc advice provided to the frontbench Treasury team during the passage of the Finance (No.2) Bill to the value of £11,000 | Sponsorships 8f616a6e | 2011-01-24 | David Hanson uk.org.publicwhip/member/40199 | David Hanson uk.org.publicwhip/person/10259 | 3 | 2011-01-24-8f616a6e-10259-0 |
6891f6c303fa1d5a7e799c7ce630c25c804d93ca | Date of receipt: October/November 2010 | Sponsorships 8f616a6e | 2011-01-24 | David Hanson uk.org.publicwhip/member/40199 | David Hanson uk.org.publicwhip/person/10259 | 4 | 2011-01-24-8f616a6e-10259-0 |
443e845ea48f1f35d5844a05a94ad0f695d73b99 | Date of acceptance: October 2010 | Sponsorships 8f616a6e | 2011-01-24 | David Hanson uk.org.publicwhip/member/40199 | David Hanson uk.org.publicwhip/person/10259 | 5 | 2011-01-24-8f616a6e-10259-0 |
a072675eb6818cbbd688faf3afc875f47e14d7e2 | Donor status: limited liability partnership | Sponsorships 8f616a6e | 2011-01-24 | David Hanson uk.org.publicwhip/member/40199 | David Hanson uk.org.publicwhip/person/10259 | 6 | 2011-01-24-8f616a6e-10259-0 |
c5584b4e4c48d3575fe2fa14fc1e5d1df69e29dd | (Registered 8 November 2010) | Sponsorships 8f616a6e | 2011-01-24 | David Hanson uk.org.publicwhip/member/40199 | David Hanson uk.org.publicwhip/person/10259 | 7 | 2011-01-24-8f616a6e-10259-0 |
5bbe216e3114e4d5c357604c8daa9c54d32776ee | Payments from Populus , 10 Northburgh Street, London EC1V 0AT, for taking part in opinion research: | Remunerated employment, office, profession etc 1f359ece | 2011-02-07 | David Hanson uk.org.publicwhip/member/40199 | David Hanson uk.org.publicwhip/person/10259 | 0 | 2011-02-07-1f359ece-10259-0 |
e915ec0075ec725c52a30bd1e1af050a15463e37 | Payment of £50 from Populus Hours: 15 mins. Payment donated to charity. (Registered 12 January 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-02-07 | David Hanson uk.org.publicwhip/member/40199 | David Hanson uk.org.publicwhip/person/10259 | 1 | 2011-02-07-1f359ece-10259-0 |
5968e782a60349c5986022e209877c9dcc871774 | Payment of £75 for telephone interview. Hours: 30 mins. (Registered 3 February 2011 ) | Remunerated employment, office, profession etc 1f359ece | 2011-02-07 | David Hanson uk.org.publicwhip/member/40199 | David Hanson uk.org.publicwhip/person/10259 | 2 | 2011-02-07-1f359ece-10259-0 |
c9e6ec56af7b708487408af3e73f9a3a22fdd9da | Payments from ComRes, Four Millbank, London SW1P 3JA, for opinion surveys: | Remunerated employment, office, profession etc 1f359ece | 2011-02-07 | David Hanson uk.org.publicwhip/member/40199 | David Hanson uk.org.publicwhip/person/10259 | 3 | 2011-02-07-1f359ece-10259-0 |
a3e0a4733eafc13efdf8090519816820189aeff6 | June 2010, payment of £75. Hours: 30 mins. (Registered 3 February 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-02-07 | David Hanson uk.org.publicwhip/member/40199 | David Hanson uk.org.publicwhip/person/10259 | 4 | 2011-02-07-1f359ece-10259-0 |
35888d98df2cb6861ce3affc40fd7ad5ec80328d | September 2010, payment of £75. Hours: 1.5 hrs. (Registered 3 February 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-02-07 | David Hanson uk.org.publicwhip/member/40199 | David Hanson uk.org.publicwhip/person/10259 | 5 | 2011-02-07-1f359ece-10259-0 |
75347aa97e5aaea4eba462aa6bebc4fb8fe8d642 | October 2010, payment of £75. Hours: 1.5 hrs. (Registered 3 February 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-02-07 | David Hanson uk.org.publicwhip/member/40199 | David Hanson uk.org.publicwhip/person/10259 | 6 | 2011-02-07-1f359ece-10259-0 |
e13643f22576b1caa19ba98c96176328fcd4a3a3 | November 2010, payment of £75. Hours: 1.5 hrs. (Registered 3 February 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-02-07 | David Hanson uk.org.publicwhip/member/40199 | David Hanson uk.org.publicwhip/person/10259 | 7 | 2011-02-07-1f359ece-10259-0 |
39f1d2b5a6518b2850cfcdafa4809f5d22889515 | Payment of £150 from Ipsos MORI, 79-81Borough Road, London SE1 1FY, for survey of MPs. Hours: 1.5 hrs (Registered 28 January 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-02-07 | David Hanson uk.org.publicwhip/member/40199 | David Hanson uk.org.publicwhip/person/10259 | 8 | 2011-02-07-1f359ece-10259-0 |
277e6e02be85cec46d5dbea857ed6c813172e3b4 | Payments from Dod’s Parliamentary Communications, 21 Dartmouth St, London SW1H 9BP, for Criminal Justice Sector Knowledge Seminars: | Remunerated employment, office, profession etc 1f359ece | 2011-02-07 | David Hanson uk.org.publicwhip/member/40199 | David Hanson uk.org.publicwhip/person/10259 | 9 | 2011-02-07-1f359ece-10259-0 |
a98a69822523276d5e0bbda9219795d72fba27d3 | Payment of £150 Hours: 1.5 hrs. (Registered 3 February 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-02-07 | David Hanson uk.org.publicwhip/member/40199 | David Hanson uk.org.publicwhip/person/10259 | 10 | 2011-02-07-1f359ece-10259-0 |
a88f5bc8a430101461fb7681e20d2b3af64bc2d4 | Payment of £150 Hours: 1.5 hrs. (Registered 3 February 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-02-07 | David Hanson uk.org.publicwhip/member/40199 | David Hanson uk.org.publicwhip/person/10259 | 11 | 2011-02-07-1f359ece-10259-0 |
7d40b705470b2a43e6bb2c2e4a6e272cb90bd6cf | Support in the capacity as an MP: | Sponsorships 8f616a6e | 2011-02-07 | David Hanson uk.org.publicwhip/member/40199 | David Hanson uk.org.publicwhip/person/10259 | 0 | 2011-02-07-8f616a6e-10259-0 |
52323859689e39d1d3f685d53d3c3293e638f0f4 | Name of donor: PricewaterhouseCoopers | Sponsorships 8f616a6e | 2011-02-07 | David Hanson uk.org.publicwhip/member/40199 | David Hanson uk.org.publicwhip/person/10259 | 1 | 2011-02-07-8f616a6e-10259-0 |
203913e7ef93cfc71a54520bbbdd418e8fd4bf5a | Address of donor: 1 Embankment Place, London WC1N 6RH | Sponsorships 8f616a6e | 2011-02-07 | David Hanson uk.org.publicwhip/member/40199 | David Hanson uk.org.publicwhip/person/10259 | 2 | 2011-02-07-8f616a6e-10259-0 |
c4b065294332fe82af8da45210f256b4af16b25a | Amount of donation or nature and value if donation in kind: ad hoc advice provided to the frontbench Treasury team during the passage of the Finance (No.2) Bill to the value of £11,000 | Sponsorships 8f616a6e | 2011-02-07 | David Hanson uk.org.publicwhip/member/40199 | David Hanson uk.org.publicwhip/person/10259 | 3 | 2011-02-07-8f616a6e-10259-0 |
534fb1a6a298ef148f33ab7228e7905311e444f5 | Date of receipt: October/November 2010 | Sponsorships 8f616a6e | 2011-02-07 | David Hanson uk.org.publicwhip/member/40199 | David Hanson uk.org.publicwhip/person/10259 | 4 | 2011-02-07-8f616a6e-10259-0 |
dbee1db28daf8d53e18abbc64270d4afe6406292 | Date of acceptance: October 2010 | Sponsorships 8f616a6e | 2011-02-07 | David Hanson uk.org.publicwhip/member/40199 | David Hanson uk.org.publicwhip/person/10259 | 5 | 2011-02-07-8f616a6e-10259-0 |
910e67ab050811ec9e410ce6b8b5773572056d98 | Donor status: limited liability partnership | Sponsorships 8f616a6e | 2011-02-07 | David Hanson uk.org.publicwhip/member/40199 | David Hanson uk.org.publicwhip/person/10259 | 6 | 2011-02-07-8f616a6e-10259-0 |
c64ab6501ea2dc2323a2200cc411ae00aaf28393 | (Registered 8 November 2010) | Sponsorships 8f616a6e | 2011-02-07 | David Hanson uk.org.publicwhip/member/40199 | David Hanson uk.org.publicwhip/person/10259 | 7 | 2011-02-07-8f616a6e-10259-0 |
a012d2ec0a0029fe61aacde140863ff994d79bbf | Payments from Populus , 10 Northburgh Street, London EC1V 0AT, for taking part in opinion research: | Remunerated employment, office, profession etc 1f359ece | 2011-02-28 | David Hanson uk.org.publicwhip/member/40199 | David Hanson uk.org.publicwhip/person/10259 | 0 | 2011-02-28-1f359ece-10259-0 |
d680a9fd12ce44ac7ab57717d71c819c9d859702 | Payment of £50 from Populus Hours: 15 mins. Payment donated to charity. (Registered 12 January 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-02-28 | David Hanson uk.org.publicwhip/member/40199 | David Hanson uk.org.publicwhip/person/10259 | 1 | 2011-02-28-1f359ece-10259-0 |
30b25cf35866c7aca1bef17c634560e183a8fa8f | Payment of £75 for telephone interview. Hours: 30 mins. (Registered 3 February 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-02-28 | David Hanson uk.org.publicwhip/member/40199 | David Hanson uk.org.publicwhip/person/10259 | 2 | 2011-02-28-1f359ece-10259-0 |
3c804628247cc5a0d6a85b181949a2a28564d310 | Payments from ComRes, Four Millbank, London SW1P 3JA, for opinion surveys: | Remunerated employment, office, profession etc 1f359ece | 2011-02-28 | David Hanson uk.org.publicwhip/member/40199 | David Hanson uk.org.publicwhip/person/10259 | 3 | 2011-02-28-1f359ece-10259-0 |
c60b51d6e136995c63bb080131a0dbb0bae0b8b5 | June 2010, payment of £75. Hours: 30 mins. (Registered 3 February 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-02-28 | David Hanson uk.org.publicwhip/member/40199 | David Hanson uk.org.publicwhip/person/10259 | 4 | 2011-02-28-1f359ece-10259-0 |
63412a7f9c6ae294f5b85556bb94508bd562036c | September 2010, payment of £75. Hours: 1.5 hrs. (Registered 3 February 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-02-28 | David Hanson uk.org.publicwhip/member/40199 | David Hanson uk.org.publicwhip/person/10259 | 5 | 2011-02-28-1f359ece-10259-0 |
7de7fcdbca68d8434ad06865e6d612144d0fd27a | October 2010, payment of £75. Hours: 1.5 hrs. (Registered 3 February 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-02-28 | David Hanson uk.org.publicwhip/member/40199 | David Hanson uk.org.publicwhip/person/10259 | 6 | 2011-02-28-1f359ece-10259-0 |
422dfa127950d25544a2d84c2f13e5a827c82bc9 | November 2010, payment of £75. Hours: 1.5 hrs. (Registered 3 February 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-02-28 | David Hanson uk.org.publicwhip/member/40199 | David Hanson uk.org.publicwhip/person/10259 | 7 | 2011-02-28-1f359ece-10259-0 |
88b4f78ae003c1b1634b5bcd5aef4001217b90d6 | Payment of £150 from Ipsos MORI, 79-81Borough Road, London SE1 1FY, for survey of MPs. Hours: 1.5 hrs (Registered 28 January 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-02-28 | David Hanson uk.org.publicwhip/member/40199 | David Hanson uk.org.publicwhip/person/10259 | 8 | 2011-02-28-1f359ece-10259-0 |
1e60a7877815997150730b7b7648420681776127 | Payments from Dod’s Parliamentary Communications, 21 Dartmouth St, London SW1H 9BP, for Criminal Justice Sector Knowledge Seminars: | Remunerated employment, office, profession etc 1f359ece | 2011-02-28 | David Hanson uk.org.publicwhip/member/40199 | David Hanson uk.org.publicwhip/person/10259 | 9 | 2011-02-28-1f359ece-10259-0 |
85035a3505c54dd313482907a9a0958a789d6c4d | Payment of £150 Hours: 1.5 hrs. (Registered 3 February 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-02-28 | David Hanson uk.org.publicwhip/member/40199 | David Hanson uk.org.publicwhip/person/10259 | 10 | 2011-02-28-1f359ece-10259-0 |
c5ea6d224f53a5a9665616b53187fe2526a6fab4 | Payment of £150 Hours: 1.5 hrs. (Registered 3 February 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-02-28 | David Hanson uk.org.publicwhip/member/40199 | David Hanson uk.org.publicwhip/person/10259 | 11 | 2011-02-28-1f359ece-10259-0 |
8162cfadf4b4a53cfe32577c218f0475c870a959 | Payment of £80 from YouGov, 50 Featherstone Street, London EC1Y 8RT, for completing online survey. Hours: 30 mins. (Registered 15 February 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-02-28 | David Hanson uk.org.publicwhip/member/40199 | David Hanson uk.org.publicwhip/person/10259 | 12 | 2011-02-28-1f359ece-10259-0 |
1687aec5e555745090927effeddb2819bdc230d1 | Support in the capacity as an MP: | Sponsorships 8f616a6e | 2011-02-28 | David Hanson uk.org.publicwhip/member/40199 | David Hanson uk.org.publicwhip/person/10259 | 0 | 2011-02-28-8f616a6e-10259-0 |
60cbb5d5d4e876d06f02bfafcd12248a245130d0 | Name of donor: PricewaterhouseCoopers | Sponsorships 8f616a6e | 2011-02-28 | David Hanson uk.org.publicwhip/member/40199 | David Hanson uk.org.publicwhip/person/10259 | 1 | 2011-02-28-8f616a6e-10259-0 |
2980f245b37cfe97cba8cad91d7d5cb89e9c886f | Address of donor: 1 Embankment Place, London WC1N 6RH | Sponsorships 8f616a6e | 2011-02-28 | David Hanson uk.org.publicwhip/member/40199 | David Hanson uk.org.publicwhip/person/10259 | 2 | 2011-02-28-8f616a6e-10259-0 |
9f28aebfaf0d045c2a8557f3f798d8df3310684f | Amount of donation or nature and value if donation in kind: ad hoc advice provided to the frontbench Treasury team during the passage of the Finance (No.2) Bill to the value of £11,000 | Sponsorships 8f616a6e | 2011-02-28 | David Hanson uk.org.publicwhip/member/40199 | David Hanson uk.org.publicwhip/person/10259 | 3 | 2011-02-28-8f616a6e-10259-0 |
ef028d387545528253cb99bc633ab8a7ebdfd057 | Date of receipt: October/November 2010 | Sponsorships 8f616a6e | 2011-02-28 | David Hanson uk.org.publicwhip/member/40199 | David Hanson uk.org.publicwhip/person/10259 | 4 | 2011-02-28-8f616a6e-10259-0 |
309c43fbe55c883037b4a4556c6b95ef88ae6864 | Date of acceptance: October 2010 | Sponsorships 8f616a6e | 2011-02-28 | David Hanson uk.org.publicwhip/member/40199 | David Hanson uk.org.publicwhip/person/10259 | 5 | 2011-02-28-8f616a6e-10259-0 |
aa4156d9922b3ed17ef72d413d9863db451f6cb9 | Donor status: limited liability partnership | Sponsorships 8f616a6e | 2011-02-28 | David Hanson uk.org.publicwhip/member/40199 | David Hanson uk.org.publicwhip/person/10259 | 6 | 2011-02-28-8f616a6e-10259-0 |
1d372d095f70f56ad63ed2598fdee0f84a83d57b | (Registered 8 November 2010) | Sponsorships 8f616a6e | 2011-02-28 | David Hanson uk.org.publicwhip/member/40199 | David Hanson uk.org.publicwhip/person/10259 | 7 | 2011-02-28-8f616a6e-10259-0 |
f2586da9e8c4046aa2ac5ca693226ad095806897 | Payments from Populus , 10 Northburgh Street, London EC1V 0AT, for taking part in opinion research: | Remunerated employment, office, profession etc 1f359ece | 2011-03-14 | David Hanson uk.org.publicwhip/member/40199 | David Hanson uk.org.publicwhip/person/10259 | 0 | 2011-03-14-1f359ece-10259-0 |
bf4e30519437f4e9ca034e96a4e536b428dd2858 | Payment of £50 from Populus Hours: 15 mins. Payment donated to charity. (Registered 12 January 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-03-14 | David Hanson uk.org.publicwhip/member/40199 | David Hanson uk.org.publicwhip/person/10259 | 1 | 2011-03-14-1f359ece-10259-0 |
a9684547cb2c6557f0b11b8c90a78f69948e154c | Payment of £75 for telephone interview. Hours: 30 mins. (Registered 3 February 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-03-14 | David Hanson uk.org.publicwhip/member/40199 | David Hanson uk.org.publicwhip/person/10259 | 2 | 2011-03-14-1f359ece-10259-0 |
782a74176e23859f7aced56d1369d37382bcdaaf | Payments from ComRes, Four Millbank, London SW1P 3JA, for opinion surveys: | Remunerated employment, office, profession etc 1f359ece | 2011-03-14 | David Hanson uk.org.publicwhip/member/40199 | David Hanson uk.org.publicwhip/person/10259 | 3 | 2011-03-14-1f359ece-10259-0 |
ad6efb1553590de962120e85e7307291a4d35032 | June 2010, payment of £75. Hours: 30 mins. (Registered 3 February 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-03-14 | David Hanson uk.org.publicwhip/member/40199 | David Hanson uk.org.publicwhip/person/10259 | 4 | 2011-03-14-1f359ece-10259-0 |
332635fe5e947af574f1b302683872a1630f0cf7 | September 2010, payment of £75. Hours: 1.5 hrs. (Registered 3 February 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-03-14 | David Hanson uk.org.publicwhip/member/40199 | David Hanson uk.org.publicwhip/person/10259 | 5 | 2011-03-14-1f359ece-10259-0 |
c379ddbe3b7edc408b6938db32d0d3fd02fa587d | October 2010, payment of £75. Hours: 1.5 hrs. (Registered 3 February 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-03-14 | David Hanson uk.org.publicwhip/member/40199 | David Hanson uk.org.publicwhip/person/10259 | 6 | 2011-03-14-1f359ece-10259-0 |
15e6f682adc2d16bb9f7e6db7975d064b4e245d3 | November 2010, payment of £75. Hours: 1.5 hrs. (Registered 3 February 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-03-14 | David Hanson uk.org.publicwhip/member/40199 | David Hanson uk.org.publicwhip/person/10259 | 7 | 2011-03-14-1f359ece-10259-0 |
8f4f2f05a7f07b3f6a390dd3c305f3fc72319d67 | January 2011, payment of £75. Hours: 45 mins. (Registered 4 March 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-03-14 | David Hanson uk.org.publicwhip/member/40199 | David Hanson uk.org.publicwhip/person/10259 | 8 | 2011-03-14-1f359ece-10259-0 |
f5f922b28c4d348fdcf99dc6cdf26cb93dd8d65b | Payment of £150 from Ipsos MORI, 79-81Borough Road, London SE1 1FY, for survey of MPs. Hours: 1.5 hrs (Registered 28 January 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-03-14 | David Hanson uk.org.publicwhip/member/40199 | David Hanson uk.org.publicwhip/person/10259 | 9 | 2011-03-14-1f359ece-10259-0 |
af314cf8d4cbe7c8b4e7f0cc123c11639e97fce8 | Payments from Dod’s Parliamentary Communications, 21 Dartmouth St, London SW1H 9BP, for Criminal Justice Sector Knowledge Seminars: | Remunerated employment, office, profession etc 1f359ece | 2011-03-14 | David Hanson uk.org.publicwhip/member/40199 | David Hanson uk.org.publicwhip/person/10259 | 10 | 2011-03-14-1f359ece-10259-0 |
220a2455386aa9dedfef4f89b62f906b6c7d2b91 | Payment of £150 Hours: 1.5 hrs. (Registered 3 February 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-03-14 | David Hanson uk.org.publicwhip/member/40199 | David Hanson uk.org.publicwhip/person/10259 | 11 | 2011-03-14-1f359ece-10259-0 |
42ae99f54c0ddad7d458b9a2f0bca5af91999be6 | Payment of £150 Hours: 1.5 hrs. (Registered 3 February 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-03-14 | David Hanson uk.org.publicwhip/member/40199 | David Hanson uk.org.publicwhip/person/10259 | 12 | 2011-03-14-1f359ece-10259-0 |
d4fce52bb08c063cfeaaad1145fd904ebdae0275 | Payment of £80 from YouGov, 50 Featherstone Street, London EC1Y 8RT, for completing online survey. Hours: 30 mins. (Registered 15 February 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-03-14 | David Hanson uk.org.publicwhip/member/40199 | David Hanson uk.org.publicwhip/person/10259 | 13 | 2011-03-14-1f359ece-10259-0 |
4e88617e1d984bee32e2748474fe055e092a63fd | Support in the capacity as an MP: | Sponsorships 8f616a6e | 2011-03-14 | David Hanson uk.org.publicwhip/member/40199 | David Hanson uk.org.publicwhip/person/10259 | 0 | 2011-03-14-8f616a6e-10259-0 |
a05e8e713f5003b9de55325bc466190f7dfd945f | Name of donor: PricewaterhouseCoopers | Sponsorships 8f616a6e | 2011-03-14 | David Hanson uk.org.publicwhip/member/40199 | David Hanson uk.org.publicwhip/person/10259 | 1 | 2011-03-14-8f616a6e-10259-0 |
db7f02a8d55b3b5fba18bf2ea1ba95aaffa39222 | Address of donor: 1 Embankment Place, London WC1N 6RH | Sponsorships 8f616a6e | 2011-03-14 | David Hanson uk.org.publicwhip/member/40199 | David Hanson uk.org.publicwhip/person/10259 | 2 | 2011-03-14-8f616a6e-10259-0 |
75dc078a6c5884345143d3d6afa47cca1c374486 | Amount of donation or nature and value if donation in kind: ad hoc advice provided to the frontbench Treasury team during the passage of the Finance (No.2) Bill to the value of £11,000 | Sponsorships 8f616a6e | 2011-03-14 | David Hanson uk.org.publicwhip/member/40199 | David Hanson uk.org.publicwhip/person/10259 | 3 | 2011-03-14-8f616a6e-10259-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");