items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
1,777 rows where member_id = "uk.org.publicwhip/member/40610" sorted by date descending
This data as json, CSV (advanced)
Suggested facets: category_id, date (date)
hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
12dc5fad979cf18f0d6f0d4b72b3b2b616a176da | Payment of £1,500 received on 7 April 2014 from Hat Trick Productions Ltd, 33 Oval Road, London NW1 7EA, for appearance as a panellist on BBC1 ‘Have I Got News For You’. Hours: 4 hrs. Payment donated to charity. (Registered 16 April 2014) | Remunerated employment, office, profession etc 1f359ece | 2015-03-30 | Sadiq Khan uk.org.publicwhip/member/40610 | Sadiq Khan uk.org.publicwhip/person/11878 | 0 | 2015-03-30-1f359ece-11878-0 |
e69fcea41667d1acc22186961523d9d16ad3fcc3 | Donations to my constituency party or association, which have been or will be reported by my party to the Electoral Commission: | Sponsorships 8f616a6e | 2015-03-30 | Sadiq Khan uk.org.publicwhip/member/40610 | Sadiq Khan uk.org.publicwhip/person/11878 | 0 | 2015-03-30-8f616a6e-11878-0 |
159bde492585357408f7dc02bf5fd59bc6343df2 | Name of donor: Unite the Union | Sponsorships 8f616a6e | 2015-03-30 | Sadiq Khan uk.org.publicwhip/member/40610 | Sadiq Khan uk.org.publicwhip/person/11878 | 0 | 2015-03-30-8f616a6e-11878-1 |
79d48280de33eee47167c590410273a3ecc3e9ab | Address of donor: 128 Theobalds Road, London WC1X 8TN | Sponsorships 8f616a6e | 2015-03-30 | Sadiq Khan uk.org.publicwhip/member/40610 | Sadiq Khan uk.org.publicwhip/person/11878 | 1 | 2015-03-30-8f616a6e-11878-1 |
56700cbb6357d9401e0e825d3a9f01f0a868c8fc | Amount of donation or nature and value if donation in kind: £3,000 | Sponsorships 8f616a6e | 2015-03-30 | Sadiq Khan uk.org.publicwhip/member/40610 | Sadiq Khan uk.org.publicwhip/person/11878 | 2 | 2015-03-30-8f616a6e-11878-1 |
389821563fb1cae0b23124f604586e973d20764b | Donor status: trade union | Sponsorships 8f616a6e | 2015-03-30 | Sadiq Khan uk.org.publicwhip/member/40610 | Sadiq Khan uk.org.publicwhip/person/11878 | 3 | 2015-03-30-8f616a6e-11878-1 |
a8bb5c65034c282ee4926c8e6d38123a7677de5e | (Registered 10 April 2014) | Sponsorships 8f616a6e | 2015-03-30 | Sadiq Khan uk.org.publicwhip/member/40610 | Sadiq Khan uk.org.publicwhip/person/11878 | 4 | 2015-03-30-8f616a6e-11878-1 |
faf3bbe71383aa362e93d3b880bddd6fce8714a7 | Name of donor: GMB (London) | Sponsorships 8f616a6e | 2015-03-30 | Sadiq Khan uk.org.publicwhip/member/40610 | Sadiq Khan uk.org.publicwhip/person/11878 | 0 | 2015-03-30-8f616a6e-11878-2 |
ac184996d96e87aacea97eff746f98479e3149ce | Address of donor: Thorne House, 152 Brent Street, London NW4 2DP | Sponsorships 8f616a6e | 2015-03-30 | Sadiq Khan uk.org.publicwhip/member/40610 | Sadiq Khan uk.org.publicwhip/person/11878 | 1 | 2015-03-30-8f616a6e-11878-2 |
8902570327987870b3fee12df41f60c75642175c | Amount of donation or nature and value if donation in kind: £7,500 | Sponsorships 8f616a6e | 2015-03-30 | Sadiq Khan uk.org.publicwhip/member/40610 | Sadiq Khan uk.org.publicwhip/person/11878 | 2 | 2015-03-30-8f616a6e-11878-2 |
c7b9f79ba9a4aa7db660c859d5577bcb91ca229f | Donor status: trade union | Sponsorships 8f616a6e | 2015-03-30 | Sadiq Khan uk.org.publicwhip/member/40610 | Sadiq Khan uk.org.publicwhip/person/11878 | 3 | 2015-03-30-8f616a6e-11878-2 |
daca9a0e5c61855dd83523da580f17b3dcc4424a | (Registered 11 November 2014) | Sponsorships 8f616a6e | 2015-03-30 | Sadiq Khan uk.org.publicwhip/member/40610 | Sadiq Khan uk.org.publicwhip/person/11878 | 4 | 2015-03-30-8f616a6e-11878-2 |
9fcbede08aae05ba1b3b83a93f5992c17bfaddc4 | Name of donor: GMB (Southern) | Sponsorships 8f616a6e | 2015-03-30 | Sadiq Khan uk.org.publicwhip/member/40610 | Sadiq Khan uk.org.publicwhip/person/11878 | 0 | 2015-03-30-8f616a6e-11878-3 |
8ee128fff0b073b60429d2c064fae55cebf3a124 | Address of donor: Cooper House, 205 Hook Road, Chessington KT9 1EA | Sponsorships 8f616a6e | 2015-03-30 | Sadiq Khan uk.org.publicwhip/member/40610 | Sadiq Khan uk.org.publicwhip/person/11878 | 1 | 2015-03-30-8f616a6e-11878-3 |
01afadebae123538112c73a23c3ff4d3f1507cb4 | Amount of donation or nature and value if donation in kind: £7,500 | Sponsorships 8f616a6e | 2015-03-30 | Sadiq Khan uk.org.publicwhip/member/40610 | Sadiq Khan uk.org.publicwhip/person/11878 | 2 | 2015-03-30-8f616a6e-11878-3 |
048067578a78a766705eb0dea31702ad9e08b428 | Donor status: trade union | Sponsorships 8f616a6e | 2015-03-30 | Sadiq Khan uk.org.publicwhip/member/40610 | Sadiq Khan uk.org.publicwhip/person/11878 | 3 | 2015-03-30-8f616a6e-11878-3 |
ac028152c6372053ac133af78327a21a138495f8 | (Registered 11 November 2014) | Sponsorships 8f616a6e | 2015-03-30 | Sadiq Khan uk.org.publicwhip/member/40610 | Sadiq Khan uk.org.publicwhip/person/11878 | 4 | 2015-03-30-8f616a6e-11878-3 |
5a72f71936246f7cc09e536e8e1102aff06ea29f | Name of donor: Henley Homes | Sponsorships 8f616a6e | 2015-03-30 | Sadiq Khan uk.org.publicwhip/member/40610 | Sadiq Khan uk.org.publicwhip/person/11878 | 0 | 2015-03-30-8f616a6e-11878-4 |
924a1b03bb9d83ae802cdf4b955115ee6ee4bfe9 | Address of donor: 103 Union Street, London SE1 0LA | Sponsorships 8f616a6e | 2015-03-30 | Sadiq Khan uk.org.publicwhip/member/40610 | Sadiq Khan uk.org.publicwhip/person/11878 | 1 | 2015-03-30-8f616a6e-11878-4 |
d3ed77fc34cd2299a55f18d3f1d654e57de3e1c2 | Amount of donation or nature and value if donation in kind: £5,000 | Sponsorships 8f616a6e | 2015-03-30 | Sadiq Khan uk.org.publicwhip/member/40610 | Sadiq Khan uk.org.publicwhip/person/11878 | 2 | 2015-03-30-8f616a6e-11878-4 |
6914f56453f9d1b3c5b6c2e6460c885d7ac315f7 | Donor status: company, registration 04529006 | Sponsorships 8f616a6e | 2015-03-30 | Sadiq Khan uk.org.publicwhip/member/40610 | Sadiq Khan uk.org.publicwhip/person/11878 | 3 | 2015-03-30-8f616a6e-11878-4 |
1d636392afdea4598d13a2997fc68466ade289f9 | (Registered 20 January 2015) | Sponsorships 8f616a6e | 2015-03-30 | Sadiq Khan uk.org.publicwhip/member/40610 | Sadiq Khan uk.org.publicwhip/person/11878 | 4 | 2015-03-30-8f616a6e-11878-4 |
371171b49b142fa47b68599cc2e1fd2c5ef115fd | Name of donor: Grosvenor UK Ltd | Sponsorships 8f616a6e | 2015-03-30 | Sadiq Khan uk.org.publicwhip/member/40610 | Sadiq Khan uk.org.publicwhip/person/11878 | 0 | 2015-03-30-8f616a6e-11878-5 |
04eedb197140eb651346ad519d2636507e2b2cf6 | Address of donor: 7th Floor Metropolitan House, 3 Darkes Lane, Potters Bar EN6 1AG | Sponsorships 8f616a6e | 2015-03-30 | Sadiq Khan uk.org.publicwhip/member/40610 | Sadiq Khan uk.org.publicwhip/person/11878 | 1 | 2015-03-30-8f616a6e-11878-5 |
2e219be44e5e06547e37f5f6a81edda540cadb7d | Amount of donation or nature and value if donation in kind: £5,000 | Sponsorships 8f616a6e | 2015-03-30 | Sadiq Khan uk.org.publicwhip/member/40610 | Sadiq Khan uk.org.publicwhip/person/11878 | 2 | 2015-03-30-8f616a6e-11878-5 |
eda9ad90eaa8f6c2553d654e34f3c0e883781e1b | Donor status: company, registration 05632040 | Sponsorships 8f616a6e | 2015-03-30 | Sadiq Khan uk.org.publicwhip/member/40610 | Sadiq Khan uk.org.publicwhip/person/11878 | 3 | 2015-03-30-8f616a6e-11878-5 |
ca8a0abb80ed739c42feec27914751e7788128ab | (Registered 20 January 2015) | Sponsorships 8f616a6e | 2015-03-30 | Sadiq Khan uk.org.publicwhip/member/40610 | Sadiq Khan uk.org.publicwhip/person/11878 | 4 | 2015-03-30-8f616a6e-11878-5 |
827c826517749783a1e96754831eac06200eb33e | Name of donor: Mohammed Patel | Sponsorships 8f616a6e | 2015-03-30 | Sadiq Khan uk.org.publicwhip/member/40610 | Sadiq Khan uk.org.publicwhip/person/11878 | 0 | 2015-03-30-8f616a6e-11878-6 |
f0bd150bea1ef48847ca3c23a59ec592d3352179 | Address of donor: private | Sponsorships 8f616a6e | 2015-03-30 | Sadiq Khan uk.org.publicwhip/member/40610 | Sadiq Khan uk.org.publicwhip/person/11878 | 1 | 2015-03-30-8f616a6e-11878-6 |
e417c7b2368e353adc56ff47223755a91377361d | Amount of donation or nature and value if donation in kind: £2,500 | Sponsorships 8f616a6e | 2015-03-30 | Sadiq Khan uk.org.publicwhip/member/40610 | Sadiq Khan uk.org.publicwhip/person/11878 | 2 | 2015-03-30-8f616a6e-11878-6 |
6d57b6aade64c0a96260229d6dc77a34523c765a | Donor status: individual | Sponsorships 8f616a6e | 2015-03-30 | Sadiq Khan uk.org.publicwhip/member/40610 | Sadiq Khan uk.org.publicwhip/person/11878 | 3 | 2015-03-30-8f616a6e-11878-6 |
6ff09e98ee3e7bc592a4a7a414e1cb2b5b0884c8 | (Registered 21 January 2015) | Sponsorships 8f616a6e | 2015-03-30 | Sadiq Khan uk.org.publicwhip/member/40610 | Sadiq Khan uk.org.publicwhip/person/11878 | 4 | 2015-03-30-8f616a6e-11878-6 |
de9f9a4a586b31f9c004f913844831e0b8e37345 | Name of donor: Winners Property Company Ltd | Sponsorships 8f616a6e | 2015-03-30 | Sadiq Khan uk.org.publicwhip/member/40610 | Sadiq Khan uk.org.publicwhip/person/11878 | 0 | 2015-03-30-8f616a6e-11878-7 |
db7c737d4c68a8cad8b4361aa315a83080314dda | Address of donor: Suite 6, Richmond House, Heath Road, Hale WA14 2XP | Sponsorships 8f616a6e | 2015-03-30 | Sadiq Khan uk.org.publicwhip/member/40610 | Sadiq Khan uk.org.publicwhip/person/11878 | 1 | 2015-03-30-8f616a6e-11878-7 |
8cad228e44cedf66393514760cbaaba66167913d | Amount of donation or nature and value if donation in kind: £5,000 | Sponsorships 8f616a6e | 2015-03-30 | Sadiq Khan uk.org.publicwhip/member/40610 | Sadiq Khan uk.org.publicwhip/person/11878 | 2 | 2015-03-30-8f616a6e-11878-7 |
b0f00a95b9417f412ab6d7ea5293dd46d68efd58 | Donor status: company, registration 03079647 | Sponsorships 8f616a6e | 2015-03-30 | Sadiq Khan uk.org.publicwhip/member/40610 | Sadiq Khan uk.org.publicwhip/person/11878 | 3 | 2015-03-30-8f616a6e-11878-7 |
d23f00f474ab212014335a0740d7fa1e2d679a38 | (Registered 9 March 2015) | Sponsorships 8f616a6e | 2015-03-30 | Sadiq Khan uk.org.publicwhip/member/40610 | Sadiq Khan uk.org.publicwhip/person/11878 | 4 | 2015-03-30-8f616a6e-11878-7 |
3654194d7199ef9d82c574d6aa52b281dbfca458 | Name of donor: BM Creative Management Ltd | Sponsorships 8f616a6e | 2015-03-30 | Sadiq Khan uk.org.publicwhip/member/40610 | Sadiq Khan uk.org.publicwhip/person/11878 | 0 | 2015-03-30-8f616a6e-11878-8 |
17e1d72a41131351d8fc09560e946ddf0e65cd27 | Address of donor: Aldwych House, 81 Aldwych, London WC2B 4HN | Sponsorships 8f616a6e | 2015-03-30 | Sadiq Khan uk.org.publicwhip/member/40610 | Sadiq Khan uk.org.publicwhip/person/11878 | 1 | 2015-03-30-8f616a6e-11878-8 |
78f70996130df0112c37716d0f33c3abbb576823 | Amount of donation or nature and value if donation in kind: £2,000 | Sponsorships 8f616a6e | 2015-03-30 | Sadiq Khan uk.org.publicwhip/member/40610 | Sadiq Khan uk.org.publicwhip/person/11878 | 2 | 2015-03-30-8f616a6e-11878-8 |
1add35e9a554aa73dee6f9b343bbd4bbfb1c7789 | Donor status: company, registration 05635995 | Sponsorships 8f616a6e | 2015-03-30 | Sadiq Khan uk.org.publicwhip/member/40610 | Sadiq Khan uk.org.publicwhip/person/11878 | 3 | 2015-03-30-8f616a6e-11878-8 |
d8b27307ce5df5e979edee75760a9dd2968ba55b | (Registered 9 March 2015) | Sponsorships 8f616a6e | 2015-03-30 | Sadiq Khan uk.org.publicwhip/member/40610 | Sadiq Khan uk.org.publicwhip/person/11878 | 4 | 2015-03-30-8f616a6e-11878-8 |
f229313d322c69c3026d0ac52d653ac0710c7d2f | Support in the capacity as an MP: | Sponsorships 8f616a6e | 2015-03-30 | Sadiq Khan uk.org.publicwhip/member/40610 | Sadiq Khan uk.org.publicwhip/person/11878 | 0 | 2015-03-30-8f616a6e-11878-9 |
bf6e788b91130a121026b4758c864304b6049fa6 | Name of donor: Transport Salaried Staff Association | Sponsorships 8f616a6e | 2015-03-30 | Sadiq Khan uk.org.publicwhip/member/40610 | Sadiq Khan uk.org.publicwhip/person/11878 | 0 | 2015-03-30-8f616a6e-11878-10 |
65609e29dc2cf6fb3b4653a6f0ad6c98c2079ca3 | Address of donor: Walkden House, 10 Melton Street, London NW1 2EJ | Sponsorships 8f616a6e | 2015-03-30 | Sadiq Khan uk.org.publicwhip/member/40610 | Sadiq Khan uk.org.publicwhip/person/11878 | 1 | 2015-03-30-8f616a6e-11878-10 |
87e4952d0cc9f1ac26ea6a0cfc2409de07676075 | Amount of donation or nature and value if donation in kind: The services of a research assistant to support me in my capacity as Shadow Minister for London, for 1 day a week between 17 March 2014 and 16 March 2015, estimated value £6,000. | Sponsorships 8f616a6e | 2015-03-30 | Sadiq Khan uk.org.publicwhip/member/40610 | Sadiq Khan uk.org.publicwhip/person/11878 | 2 | 2015-03-30-8f616a6e-11878-10 |
03b93f1c73d6d299b329e2af7f6c9465320ae3b6 | Date of receipt: 17 March 2014 | Sponsorships 8f616a6e | 2015-03-30 | Sadiq Khan uk.org.publicwhip/member/40610 | Sadiq Khan uk.org.publicwhip/person/11878 | 3 | 2015-03-30-8f616a6e-11878-10 |
31a9fba034cea8ec7193f5ad248b770df5c07668 | Date of acceptance: 17 March 2014 | Sponsorships 8f616a6e | 2015-03-30 | Sadiq Khan uk.org.publicwhip/member/40610 | Sadiq Khan uk.org.publicwhip/person/11878 | 4 | 2015-03-30-8f616a6e-11878-10 |
ccf7c1725e7d20c7689fe996b1d9b960914e7561 | Donor status: trade union | Sponsorships 8f616a6e | 2015-03-30 | Sadiq Khan uk.org.publicwhip/member/40610 | Sadiq Khan uk.org.publicwhip/person/11878 | 5 | 2015-03-30-8f616a6e-11878-10 |
0e7e25a5c1ae759ac4126f405b2b94c5bef9fce3 | (Registered 16 April 2014) | Sponsorships 8f616a6e | 2015-03-30 | Sadiq Khan uk.org.publicwhip/member/40610 | Sadiq Khan uk.org.publicwhip/person/11878 | 6 | 2015-03-30-8f616a6e-11878-10 |
2495ff87d05e78b87d4abcf4a9e52c77c64d3667 | Name of donor: DCD Properties Ltd | Sponsorships 8f616a6e | 2015-03-30 | Sadiq Khan uk.org.publicwhip/member/40610 | Sadiq Khan uk.org.publicwhip/person/11878 | 0 | 2015-03-30-8f616a6e-11878-11 |
037e4d13c60fb9d310fbfd6f40e70fa848e29778 | Address of donor: 90 Long Acre, London WC2E 9RA | Sponsorships 8f616a6e | 2015-03-30 | Sadiq Khan uk.org.publicwhip/member/40610 | Sadiq Khan uk.org.publicwhip/person/11878 | 1 | 2015-03-30-8f616a6e-11878-11 |
f67100c141993bf9d40340a2c34fbffb3ba3ac15 | Amount of donation or nature and value if donation in kind: £5,000 | Sponsorships 8f616a6e | 2015-03-30 | Sadiq Khan uk.org.publicwhip/member/40610 | Sadiq Khan uk.org.publicwhip/person/11878 | 2 | 2015-03-30-8f616a6e-11878-11 |
c70f1881cd6cc5956289071326a20db948cf8311 | Date of receipt: 5 December 2014 | Sponsorships 8f616a6e | 2015-03-30 | Sadiq Khan uk.org.publicwhip/member/40610 | Sadiq Khan uk.org.publicwhip/person/11878 | 3 | 2015-03-30-8f616a6e-11878-11 |
56c22f1c6a2f40a559774c6794438392cb4b37a1 | Date of acceptance: 5 December 2014 | Sponsorships 8f616a6e | 2015-03-30 | Sadiq Khan uk.org.publicwhip/member/40610 | Sadiq Khan uk.org.publicwhip/person/11878 | 4 | 2015-03-30-8f616a6e-11878-11 |
a58a641f0386af695eff522434a4b04420b1a82f | Donor status: company, registration 03092306 | Sponsorships 8f616a6e | 2015-03-30 | Sadiq Khan uk.org.publicwhip/member/40610 | Sadiq Khan uk.org.publicwhip/person/11878 | 5 | 2015-03-30-8f616a6e-11878-11 |
9ce848bf08ba3815b701210632c56e8855091c40 | (Registered 20 January 2015) | Sponsorships 8f616a6e | 2015-03-30 | Sadiq Khan uk.org.publicwhip/member/40610 | Sadiq Khan uk.org.publicwhip/person/11878 | 6 | 2015-03-30-8f616a6e-11878-11 |
138a60125f97c2a03e5b3b64037afeb2fb9ee868 | Name of donor: Lord Gulam Noon | Sponsorships 8f616a6e | 2015-03-30 | Sadiq Khan uk.org.publicwhip/member/40610 | Sadiq Khan uk.org.publicwhip/person/11878 | 0 | 2015-03-30-8f616a6e-11878-12 |
2c92016fc26f9a447c9252a6bed6dcc63a794d5f | Address of donor: private | Sponsorships 8f616a6e | 2015-03-30 | Sadiq Khan uk.org.publicwhip/member/40610 | Sadiq Khan uk.org.publicwhip/person/11878 | 1 | 2015-03-30-8f616a6e-11878-12 |
834d2d466340fe8dfaae1385b6bf1d21dd1fcd80 | Amount of donation or nature and value if donation in kind: £5,000 | Sponsorships 8f616a6e | 2015-03-30 | Sadiq Khan uk.org.publicwhip/member/40610 | Sadiq Khan uk.org.publicwhip/person/11878 | 2 | 2015-03-30-8f616a6e-11878-12 |
0707ab10466c437871fad79cf0c743012ab2d5f4 | Date of receipt: 5 December 2014 | Sponsorships 8f616a6e | 2015-03-30 | Sadiq Khan uk.org.publicwhip/member/40610 | Sadiq Khan uk.org.publicwhip/person/11878 | 3 | 2015-03-30-8f616a6e-11878-12 |
11fcec9ca716008b3c4acd73e624a31e600eda18 | Date of acceptance: 5 December 2014 | Sponsorships 8f616a6e | 2015-03-30 | Sadiq Khan uk.org.publicwhip/member/40610 | Sadiq Khan uk.org.publicwhip/person/11878 | 4 | 2015-03-30-8f616a6e-11878-12 |
5739d45a6d8ec0225ade1babe198770fe70bc9ce | Donor status: individual | Sponsorships 8f616a6e | 2015-03-30 | Sadiq Khan uk.org.publicwhip/member/40610 | Sadiq Khan uk.org.publicwhip/person/11878 | 5 | 2015-03-30-8f616a6e-11878-12 |
8cf602ce2d62a12b4a48160f5d146bae0eef77fd | (Registered 21 January 2015) | Sponsorships 8f616a6e | 2015-03-30 | Sadiq Khan uk.org.publicwhip/member/40610 | Sadiq Khan uk.org.publicwhip/person/11878 | 6 | 2015-03-30-8f616a6e-11878-12 |
1c84510f8464afcbe914bf2b8e4a5659f285c03f | Payment of £1,500 received on 7 April 2014 from Hat Trick Productions Ltd, 33 Oval Road, London NW1 7EA, for appearance as a panellist on BBC1 ‘Have I Got News For You’. Hours: 4 hrs. Payment donated to charity. (Registered 16 April 2014) | Remunerated employment, office, profession etc 1f359ece | 2015-03-09 | Sadiq Khan uk.org.publicwhip/member/40610 | Sadiq Khan uk.org.publicwhip/person/11878 | 0 | 2015-03-09-1f359ece-11878-0 |
0053eb645594aefa01a5df9ec287bc5484324e44 | Donations to my constituency party or association, which have been or will be reported by my party to the Electoral Commission: | Sponsorships 8f616a6e | 2015-03-09 | Sadiq Khan uk.org.publicwhip/member/40610 | Sadiq Khan uk.org.publicwhip/person/11878 | 0 | 2015-03-09-8f616a6e-11878-0 |
efdb8f775ddaa55a7807fd9de2de525f8125856a | Name of donor: Unite the Union | Sponsorships 8f616a6e | 2015-03-09 | Sadiq Khan uk.org.publicwhip/member/40610 | Sadiq Khan uk.org.publicwhip/person/11878 | 0 | 2015-03-09-8f616a6e-11878-1 |
a098039e97e9440026da1bc1005404241ac3070f | Address of donor: 128 Theobalds Road, London WC1X 8TN | Sponsorships 8f616a6e | 2015-03-09 | Sadiq Khan uk.org.publicwhip/member/40610 | Sadiq Khan uk.org.publicwhip/person/11878 | 1 | 2015-03-09-8f616a6e-11878-1 |
2db3d7f556a23ec991ca61a8ae26529f8197a03d | Amount of donation or nature and value if donation in kind: £3,000 | Sponsorships 8f616a6e | 2015-03-09 | Sadiq Khan uk.org.publicwhip/member/40610 | Sadiq Khan uk.org.publicwhip/person/11878 | 2 | 2015-03-09-8f616a6e-11878-1 |
092b02a59edd016b7f1d2b33b55aee5283011a9d | Donor status: trade union | Sponsorships 8f616a6e | 2015-03-09 | Sadiq Khan uk.org.publicwhip/member/40610 | Sadiq Khan uk.org.publicwhip/person/11878 | 3 | 2015-03-09-8f616a6e-11878-1 |
48c31070d753055cebad6eb64bcb8ddfbbec5fc0 | (Registered 10 April 2014) | Sponsorships 8f616a6e | 2015-03-09 | Sadiq Khan uk.org.publicwhip/member/40610 | Sadiq Khan uk.org.publicwhip/person/11878 | 4 | 2015-03-09-8f616a6e-11878-1 |
0b23a29c66dc7ae5f37c2294d8e07507d467b010 | Name of donor: GMB (London) | Sponsorships 8f616a6e | 2015-03-09 | Sadiq Khan uk.org.publicwhip/member/40610 | Sadiq Khan uk.org.publicwhip/person/11878 | 0 | 2015-03-09-8f616a6e-11878-2 |
a138e6b72cf600dfc0609e0bb9990e1b0460b566 | Address of donor: Thorne House, 152 Brent Street, London NW4 2DP | Sponsorships 8f616a6e | 2015-03-09 | Sadiq Khan uk.org.publicwhip/member/40610 | Sadiq Khan uk.org.publicwhip/person/11878 | 1 | 2015-03-09-8f616a6e-11878-2 |
e0159438adf449c328cfafb879ed25debf9c601d | Amount of donation or nature and value if donation in kind: £7,500 | Sponsorships 8f616a6e | 2015-03-09 | Sadiq Khan uk.org.publicwhip/member/40610 | Sadiq Khan uk.org.publicwhip/person/11878 | 2 | 2015-03-09-8f616a6e-11878-2 |
fe01376fb4e387797a81c003e74a36f7610cc641 | Donor status: trade union | Sponsorships 8f616a6e | 2015-03-09 | Sadiq Khan uk.org.publicwhip/member/40610 | Sadiq Khan uk.org.publicwhip/person/11878 | 3 | 2015-03-09-8f616a6e-11878-2 |
095fff350bec50ee98bb13f6c2bac0bcbf597eed | (Registered 11 November 2014) | Sponsorships 8f616a6e | 2015-03-09 | Sadiq Khan uk.org.publicwhip/member/40610 | Sadiq Khan uk.org.publicwhip/person/11878 | 4 | 2015-03-09-8f616a6e-11878-2 |
5845304886158fec5b88e8595b056d7085368bd6 | Name of donor: GMB (Southern) | Sponsorships 8f616a6e | 2015-03-09 | Sadiq Khan uk.org.publicwhip/member/40610 | Sadiq Khan uk.org.publicwhip/person/11878 | 0 | 2015-03-09-8f616a6e-11878-3 |
18d30bfed7f98413cb92676c142fc5ff51147b1b | Address of donor: Cooper House, 205 Hook Road, Chessington KT9 1EA | Sponsorships 8f616a6e | 2015-03-09 | Sadiq Khan uk.org.publicwhip/member/40610 | Sadiq Khan uk.org.publicwhip/person/11878 | 1 | 2015-03-09-8f616a6e-11878-3 |
8d9632c2ed227f220d2de796c59e2dafef0e58b8 | Amount of donation or nature and value if donation in kind: £7,500 | Sponsorships 8f616a6e | 2015-03-09 | Sadiq Khan uk.org.publicwhip/member/40610 | Sadiq Khan uk.org.publicwhip/person/11878 | 2 | 2015-03-09-8f616a6e-11878-3 |
4067d215317013c9078885ca4c83fe02586b481f | Donor status: trade union | Sponsorships 8f616a6e | 2015-03-09 | Sadiq Khan uk.org.publicwhip/member/40610 | Sadiq Khan uk.org.publicwhip/person/11878 | 3 | 2015-03-09-8f616a6e-11878-3 |
5256493bb78adcf72406119adce2fc32b93f8784 | (Registered 11 November 2014) | Sponsorships 8f616a6e | 2015-03-09 | Sadiq Khan uk.org.publicwhip/member/40610 | Sadiq Khan uk.org.publicwhip/person/11878 | 4 | 2015-03-09-8f616a6e-11878-3 |
f44bc0872263f641864c5b7384f2802a21532a5b | Name of donor: Henley Homes | Sponsorships 8f616a6e | 2015-03-09 | Sadiq Khan uk.org.publicwhip/member/40610 | Sadiq Khan uk.org.publicwhip/person/11878 | 0 | 2015-03-09-8f616a6e-11878-4 |
a9c6f875524fe9429903b658f53b9ec7bf9a0424 | Address of donor: 103 Union Street, London SE1 0LA | Sponsorships 8f616a6e | 2015-03-09 | Sadiq Khan uk.org.publicwhip/member/40610 | Sadiq Khan uk.org.publicwhip/person/11878 | 1 | 2015-03-09-8f616a6e-11878-4 |
c0c32b62e8021eee624892a2a8a88b0c61ece498 | Amount of donation or nature and value if donation in kind: £5,000 | Sponsorships 8f616a6e | 2015-03-09 | Sadiq Khan uk.org.publicwhip/member/40610 | Sadiq Khan uk.org.publicwhip/person/11878 | 2 | 2015-03-09-8f616a6e-11878-4 |
b9c64783ca369f7e0945bf686f44203443c47d19 | Donor status: company, registration 04529006 | Sponsorships 8f616a6e | 2015-03-09 | Sadiq Khan uk.org.publicwhip/member/40610 | Sadiq Khan uk.org.publicwhip/person/11878 | 3 | 2015-03-09-8f616a6e-11878-4 |
122067306e288e6b7877f05f7e29cc6a90d47ce4 | (Registered 20 January 2015) | Sponsorships 8f616a6e | 2015-03-09 | Sadiq Khan uk.org.publicwhip/member/40610 | Sadiq Khan uk.org.publicwhip/person/11878 | 4 | 2015-03-09-8f616a6e-11878-4 |
a81997bdcc616e483db0ef4c840b35694b6c3604 | Name of donor: Grosvenor UK Ltd | Sponsorships 8f616a6e | 2015-03-09 | Sadiq Khan uk.org.publicwhip/member/40610 | Sadiq Khan uk.org.publicwhip/person/11878 | 0 | 2015-03-09-8f616a6e-11878-5 |
49b142d830e4e1e997ab1c56956dd799f8028af3 | Address of donor: 7th Floor Metropolitan House, 3 Darkes Lane, Potters Bar EN6 1AG | Sponsorships 8f616a6e | 2015-03-09 | Sadiq Khan uk.org.publicwhip/member/40610 | Sadiq Khan uk.org.publicwhip/person/11878 | 1 | 2015-03-09-8f616a6e-11878-5 |
1a1f9b8659ca9d13fbfa8b0cff9e06fb8e5f2c87 | Amount of donation or nature and value if donation in kind: £5,000 | Sponsorships 8f616a6e | 2015-03-09 | Sadiq Khan uk.org.publicwhip/member/40610 | Sadiq Khan uk.org.publicwhip/person/11878 | 2 | 2015-03-09-8f616a6e-11878-5 |
8cded672506d0f1fbabc4bec0f8b5cc240d27b5e | Donor status: company, registration 05632040 | Sponsorships 8f616a6e | 2015-03-09 | Sadiq Khan uk.org.publicwhip/member/40610 | Sadiq Khan uk.org.publicwhip/person/11878 | 3 | 2015-03-09-8f616a6e-11878-5 |
b8688c2408587a63ad3d87d03ca4c12165da5f62 | (Registered 20 January 2015) | Sponsorships 8f616a6e | 2015-03-09 | Sadiq Khan uk.org.publicwhip/member/40610 | Sadiq Khan uk.org.publicwhip/person/11878 | 4 | 2015-03-09-8f616a6e-11878-5 |
7d403cf0be56bf28718ee562d4a1219b734e7a9c | Name of donor: Mohammed Patel | Sponsorships 8f616a6e | 2015-03-09 | Sadiq Khan uk.org.publicwhip/member/40610 | Sadiq Khan uk.org.publicwhip/person/11878 | 0 | 2015-03-09-8f616a6e-11878-6 |
3654a9d5ecfe1722ce571fdcaee7ec374464c425 | Address of donor: private | Sponsorships 8f616a6e | 2015-03-09 | Sadiq Khan uk.org.publicwhip/member/40610 | Sadiq Khan uk.org.publicwhip/person/11878 | 1 | 2015-03-09-8f616a6e-11878-6 |
c10cc24b19bb0c193991cb5905c00045011f65c3 | Amount of donation or nature and value if donation in kind: £2,500 | Sponsorships 8f616a6e | 2015-03-09 | Sadiq Khan uk.org.publicwhip/member/40610 | Sadiq Khan uk.org.publicwhip/person/11878 | 2 | 2015-03-09-8f616a6e-11878-6 |
f227b4d7c82830f15305a30f225beb5ca48e7327 | Donor status: individual | Sponsorships 8f616a6e | 2015-03-09 | Sadiq Khan uk.org.publicwhip/member/40610 | Sadiq Khan uk.org.publicwhip/person/11878 | 3 | 2015-03-09-8f616a6e-11878-6 |
632cdf52a3453ef5b5500a028e38748b0a62e302 | (Registered 21 January 2015) | Sponsorships 8f616a6e | 2015-03-09 | Sadiq Khan uk.org.publicwhip/member/40610 | Sadiq Khan uk.org.publicwhip/person/11878 | 4 | 2015-03-09-8f616a6e-11878-6 |
f58d48457a5a56af24b2ad74bcb8d74984271018 | Name of donor: Winners Property Company Ltd | Sponsorships 8f616a6e | 2015-03-09 | Sadiq Khan uk.org.publicwhip/member/40610 | Sadiq Khan uk.org.publicwhip/person/11878 | 0 | 2015-03-09-8f616a6e-11878-7 |
1d9bfb5d6bfaf130a96e122226d19a7676efe792 | Address of donor: Suite 6, Richmond House, Heath Road, Hale WA14 2XP | Sponsorships 8f616a6e | 2015-03-09 | Sadiq Khan uk.org.publicwhip/member/40610 | Sadiq Khan uk.org.publicwhip/person/11878 | 1 | 2015-03-09-8f616a6e-11878-7 |
8e0fc58a2e0777f83e59faad48368bea191b3784 | Amount of donation or nature and value if donation in kind: £5,000 | Sponsorships 8f616a6e | 2015-03-09 | Sadiq Khan uk.org.publicwhip/member/40610 | Sadiq Khan uk.org.publicwhip/person/11878 | 2 | 2015-03-09-8f616a6e-11878-7 |
877b2f061764c6de00efeaf76a76980c5bcb91b0 | Donor status: company, registration 03079647 | Sponsorships 8f616a6e | 2015-03-09 | Sadiq Khan uk.org.publicwhip/member/40610 | Sadiq Khan uk.org.publicwhip/person/11878 | 3 | 2015-03-09-8f616a6e-11878-7 |
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");