items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
854 rows where member_id = "uk.org.publicwhip/member/40280" sorted by record_id
This data as json, CSV (advanced)
Suggested facets: category_id, sort_order, date (date)
hash | item | category_id | date | member_id | person_id | sort_order | record_id ▼ |
---|---|---|---|---|---|---|---|
78e5bee91339f3b860019f1fe26e2c4d84b58eca | Donation of £60 made direct to charity on my behalf by Ipsos MORI for completing a survey. Address: Ipsos MORI, 79-81 Borough Road, London SE1 1FY. Hours: 30 mins. (Registered 24 November 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-09-06 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 0 | 2010-09-06-1f359ece-10074-0 |
bfd2459b7552edf4c4e26ab6dbfb32656d50e26c | Donations to the constituency party or association, which have been or will be reported by the party to the Electoral Commission: | Sponsorships 8f616a6e | 2010-09-06 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 0 | 2010-09-06-8f616a6e-10074-0 |
a8252fc6c3f3e90644db0b1f43fbb3db0883643c | Name of donor: Mackie’s of Scotland | Sponsorships 8f616a6e | 2010-09-06 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 1 | 2010-09-06-8f616a6e-10074-0 |
2d70a1db5251f8ab58b002a99d4bbb75a5295695 | Address of donor: Westertown, Rothienorman, Aberdeenshire AB51 8US | Sponsorships 8f616a6e | 2010-09-06 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 2 | 2010-09-06-8f616a6e-10074-0 |
74db119b08027996169b10c756bc684fdae9e2de | Amount of donation or nature and value if donation in kind: £2,000 donation to my constituency party | Sponsorships 8f616a6e | 2010-09-06 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 3 | 2010-09-06-8f616a6e-10074-0 |
4e5a0e71ef4c9084fac9133674321e8893c41228 | Name of donor: Deveron Homes | Sponsorships 8f616a6e | 2010-09-06 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 6 | 2010-09-06-8f616a6e-10074-0 |
f85ab11133dff7e58f6d8512d92da218bfa2a18f | Address of donor: 7 Deveron Road, Huntly | Sponsorships 8f616a6e | 2010-09-06 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 7 | 2010-09-06-8f616a6e-10074-0 |
45b8a1cd7d0ab18bbc8cd23690aab730c5202c50 | Amount of donation or nature and value if donation in kind: £2,000 donation to my constituency party | Sponsorships 8f616a6e | 2010-09-06 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 8 | 2010-09-06-8f616a6e-10074-0 |
64e84a3af357cff8fca7ea0bc40ed4b601e57268 | Donor status: company | Sponsorships 8f616a6e | 2010-09-06 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 9 | 2010-09-06-8f616a6e-10074-0 |
a70d4443a3181ec3bab84e83f6aace27cde07f49 | Name of donor: William Alexander Dean | Sponsorships 8f616a6e | 2010-09-06 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 11 | 2010-09-06-8f616a6e-10074-0 |
2136bd133c11c7d87a059752a6f3a214d72b82c5 | Address of donor: private | Sponsorships 8f616a6e | 2010-09-06 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 12 | 2010-09-06-8f616a6e-10074-0 |
cf564148333a63cbb40653eb5e24a6917dbeadf7 | Amount of donation or nature and value if donation in kind: £2,000. | Sponsorships 8f616a6e | 2010-09-06 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 13 | 2010-09-06-8f616a6e-10074-0 |
819029899efdf7ffb517cfdec3aca3d68cc4b68c | Donor status: individual | Sponsorships 8f616a6e | 2010-09-06 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 14 | 2010-09-06-8f616a6e-10074-0 |
210b638b31b546d34ef0f7d986f6b4ebfcb3cfb7 | (Registered 28 May 2010) | Sponsorships 8f616a6e | 2010-09-06 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 15 | 2010-09-06-8f616a6e-10074-0 |
d60497b1fc28a36b180cb6ebf95004167a98a49b | Donation of £60 made direct to charity on my behalf by Ipsos MORI for completing a survey. Address: Ipsos MORI, 79-81 Borough Road, London SE1 1FY. Hours: 30 mins. (Registered 24 November 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-10-25 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 0 | 2010-10-25-1f359ece-10074-0 |
26c5fc532c674f010949b33eb165dcec6f13b3a2 | Donations to the constituency party or association, which have been or will be reported by the party to the Electoral Commission: | Sponsorships 8f616a6e | 2010-10-25 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 0 | 2010-10-25-8f616a6e-10074-0 |
002e8efa555f4e380215022b293b1ac3ae195a55 | Name of donor: Mackie’s of Scotland | Sponsorships 8f616a6e | 2010-10-25 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 1 | 2010-10-25-8f616a6e-10074-0 |
d5fa040832cd2b862d08d5ff719bace22f4235e0 | Address of donor: Westertown, Rothienorman, Aberdeenshire AB51 8US | Sponsorships 8f616a6e | 2010-10-25 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 2 | 2010-10-25-8f616a6e-10074-0 |
b65e8470b5aca1c03df0b7e4fcfd72752eadb8c1 | Amount of donation or nature and value if donation in kind: £2,000 donation to my constituency party | Sponsorships 8f616a6e | 2010-10-25 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 3 | 2010-10-25-8f616a6e-10074-0 |
f903c59f0b9f2c8b5cdbe502b384d4b3dd21b863 | Name of donor: Deveron Homes | Sponsorships 8f616a6e | 2010-10-25 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 6 | 2010-10-25-8f616a6e-10074-0 |
8a392b7dadd465c43e45a77ccf17df4ecdcaa9c7 | Address of donor: 7 Deveron Road, Huntly | Sponsorships 8f616a6e | 2010-10-25 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 7 | 2010-10-25-8f616a6e-10074-0 |
2478e7215ee45fa3f5bd45a5081176c11765e460 | Amount of donation or nature and value if donation in kind: £2,000 donation to my constituency party | Sponsorships 8f616a6e | 2010-10-25 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 8 | 2010-10-25-8f616a6e-10074-0 |
5f19c4117bf9dc17fe6a6cbceb1b25a1f4633f5e | Donor status: company | Sponsorships 8f616a6e | 2010-10-25 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 9 | 2010-10-25-8f616a6e-10074-0 |
3dbe023f1b9bac6adebb7330782c25a303226c16 | Name of donor: William Alexander Dean | Sponsorships 8f616a6e | 2010-10-25 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 11 | 2010-10-25-8f616a6e-10074-0 |
b844a21327ede844069128afec0d3aa1a463a7a2 | Address of donor: private | Sponsorships 8f616a6e | 2010-10-25 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 12 | 2010-10-25-8f616a6e-10074-0 |
216cd3c8352714c0eb001b2e729c4ed0c8f8fa51 | Amount of donation or nature and value if donation in kind: £2,000. | Sponsorships 8f616a6e | 2010-10-25 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 13 | 2010-10-25-8f616a6e-10074-0 |
8b84326740d1158928537cfd48468daff65790e5 | Donor status: individual | Sponsorships 8f616a6e | 2010-10-25 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 14 | 2010-10-25-8f616a6e-10074-0 |
b04de074bf077bb18804b2f5767224e3bc7d3e43 | (Registered 28 May 2010) | Sponsorships 8f616a6e | 2010-10-25 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 15 | 2010-10-25-8f616a6e-10074-0 |
89328b46f4f573ccc29ae1ff1e8e28d8a09cfa04 | Donation of £60 made direct to charity on my behalf by Ipsos MORI for completing a survey. Address: Ipsos MORI, 79-81 Borough Road, London SE1 1FY. Hours: 30 mins. (Registered 24 November 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-11-08 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 0 | 2010-11-08-1f359ece-10074-0 |
329eaf754db090bff28a43c4b62f3019907920b0 | Name of donor: Cadbury/Kraft | Overseas visits 80ef1083 | 2010-11-08 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 0 | 2010-11-08-80ef1083-10074-0 |
a7a44b86070d5fcd6db9d52fe61cbc93993d1c3a | Address of donor: | Overseas visits 80ef1083 | 2010-11-08 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 1 | 2010-11-08-80ef1083-10074-0 |
6dcf8443a5021e7c521878f38b313883dde90083 | Amount of donation (or estimate of the probable value): return business class flight Heathrow-Ghana, 2 nights hotel in Accra, ground transportation, meals and hospitality; total value £4,175 | Overseas visits 80ef1083 | 2010-11-08 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 2 | 2010-11-08-80ef1083-10074-0 |
e7ad7bbcba550092caf58033ffe7a76e5851d39b | Destination of visit: Ghana | Overseas visits 80ef1083 | 2010-11-08 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 3 | 2010-11-08-80ef1083-10074-0 |
f68dd0b17c1009081330fc6eeed8f9cca04e3b61 | Date of visit: 29-31 August 2010 | Overseas visits 80ef1083 | 2010-11-08 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 4 | 2010-11-08-80ef1083-10074-0 |
a0674e6b72852e0c9b9fe071d24cca7ec21c1b5c | Purpose of visit: | Overseas visits 80ef1083 | 2010-11-08 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 5 | 2010-11-08-80ef1083-10074-0 |
6ebdda7ba05b3b808d06ca65d8106b7869af2c65 | (Registered 23 September 2010) | Overseas visits 80ef1083 | 2010-11-08 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 6 | 2010-11-08-80ef1083-10074-0 |
492e5caeb1db108b679e6b488abe95e5a1d6056d | Donations to the constituency party or association, which have been or will be reported by the party to the Electoral Commission: | Sponsorships 8f616a6e | 2010-11-08 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 0 | 2010-11-08-8f616a6e-10074-0 |
8b6400d886720465a8c0b4b318fd66fa2b8ea361 | Name of donor: Mackie’s of Scotland | Sponsorships 8f616a6e | 2010-11-08 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 1 | 2010-11-08-8f616a6e-10074-0 |
d5c305b545b172b0cf70fbe626a0845e10fd2df5 | Address of donor: Westertown, Rothienorman, Aberdeenshire AB51 8US | Sponsorships 8f616a6e | 2010-11-08 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 2 | 2010-11-08-8f616a6e-10074-0 |
1f66c657d10e5c966668a6df5d4a6559a439c077 | Amount of donation or nature and value if donation in kind: £2,000 donation to my constituency party | Sponsorships 8f616a6e | 2010-11-08 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 3 | 2010-11-08-8f616a6e-10074-0 |
187aaa279cffa308b1671d314b168d5c15c311aa | Name of donor: Deveron Homes | Sponsorships 8f616a6e | 2010-11-08 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 6 | 2010-11-08-8f616a6e-10074-0 |
90039db00d897d933aba5ef7d85a9bdb2bbdbf43 | Address of donor: 7 Deveron Road, Huntly | Sponsorships 8f616a6e | 2010-11-08 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 7 | 2010-11-08-8f616a6e-10074-0 |
32dc0c2d41a0afa9e51912d0b7e42b54c02ea0a5 | Amount of donation or nature and value if donation in kind: £2,000 donation to my constituency party | Sponsorships 8f616a6e | 2010-11-08 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 8 | 2010-11-08-8f616a6e-10074-0 |
ced9d42323cf21fb12af16f2372f253ee95cbb8f | Donor status: company | Sponsorships 8f616a6e | 2010-11-08 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 9 | 2010-11-08-8f616a6e-10074-0 |
9983a7b0308dd90625bbe43c0a11a98bd291c89b | Name of donor: William Alexander Dean | Sponsorships 8f616a6e | 2010-11-08 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 11 | 2010-11-08-8f616a6e-10074-0 |
b4a7853f1881fea0f069176bb82388ce6ab1c04e | Address of donor: private | Sponsorships 8f616a6e | 2010-11-08 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 12 | 2010-11-08-8f616a6e-10074-0 |
99eede06d68c5e9f227e89a796d44301ae35fb1b | Amount of donation or nature and value if donation in kind: £2,000. | Sponsorships 8f616a6e | 2010-11-08 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 13 | 2010-11-08-8f616a6e-10074-0 |
dc6fb7aa3f21ffd525767ec7fa4a350adf7cfb01 | Donor status: individual | Sponsorships 8f616a6e | 2010-11-08 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 14 | 2010-11-08-8f616a6e-10074-0 |
edd805140bc2e01cfba580819ddd60630f228af3 | (Registered 28 May 2010) | Sponsorships 8f616a6e | 2010-11-08 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 15 | 2010-11-08-8f616a6e-10074-0 |
859fc312b3fa18d54751cae3a27a9be0d13351c1 | Donation of £60 made direct to charity on my behalf by Ipsos MORI for completing a survey. Address: Ipsos MORI, 79-81 Borough Road, London SE1 1FY. Hours: 30 mins. (Registered 24 November 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-11-22 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 0 | 2010-11-22-1f359ece-10074-0 |
7887bf7ef8499db443de075c63939609951b4546 | Name of donor: Cadbury/Kraft | Overseas visits 80ef1083 | 2010-11-22 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 0 | 2010-11-22-80ef1083-10074-0 |
51ccd29c4fe59d89236f2aa0a9570a1cb3eb0476 | Address of donor: | Overseas visits 80ef1083 | 2010-11-22 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 1 | 2010-11-22-80ef1083-10074-0 |
f71c0c1632b33a853f76a2e1bdf20ec419ae6103 | Amount of donation (or estimate of the probable value): return business class flight Heathrow-Ghana, 2 nights hotel in Accra, ground transportation, meals and hospitality; total value £4,175 | Overseas visits 80ef1083 | 2010-11-22 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 2 | 2010-11-22-80ef1083-10074-0 |
f72b1cad63fe4d1203c6938b10438d516d6afaa5 | Destination of visit: Ghana | Overseas visits 80ef1083 | 2010-11-22 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 3 | 2010-11-22-80ef1083-10074-0 |
c2943cecaaa19f2d3ab1fc7f66d49349712f1241 | Date of visit: 29-31 August 2010 | Overseas visits 80ef1083 | 2010-11-22 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 4 | 2010-11-22-80ef1083-10074-0 |
75a7b6d6168e137d1708f1ae3f56af8030c410e2 | Purpose of visit: | Overseas visits 80ef1083 | 2010-11-22 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 5 | 2010-11-22-80ef1083-10074-0 |
70d82d9376969ca4e62bee4819247c482bdb23f9 | (Registered 23 September 2010) | Overseas visits 80ef1083 | 2010-11-22 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 6 | 2010-11-22-80ef1083-10074-0 |
f847a517d7537d915502a72dc6a5b4cf52aca131 | Donations to the constituency party or association, which have been or will be reported by the party to the Electoral Commission: | Sponsorships 8f616a6e | 2010-11-22 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 0 | 2010-11-22-8f616a6e-10074-0 |
343ae12929474cc0a0c01c4057cf7bcacd5c83d5 | Name of donor: Mackie’s of Scotland | Sponsorships 8f616a6e | 2010-11-22 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 1 | 2010-11-22-8f616a6e-10074-0 |
8443b16e14460bb5869fdc69b12b24efa1064d9b | Address of donor: Westertown, Rothienorman, Aberdeenshire AB51 8US | Sponsorships 8f616a6e | 2010-11-22 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 2 | 2010-11-22-8f616a6e-10074-0 |
baa27ecc2324cb3f5b55e0a1ddbd44a67a2f5780 | Amount of donation or nature and value if donation in kind: £2,000 donation to my constituency party | Sponsorships 8f616a6e | 2010-11-22 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 3 | 2010-11-22-8f616a6e-10074-0 |
3a9b1a2166cbcf249c45a02b0f2395b9eeb60791 | Name of donor: Deveron Homes | Sponsorships 8f616a6e | 2010-11-22 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 6 | 2010-11-22-8f616a6e-10074-0 |
09ac7be04377ae29a83529243edb5876f230b866 | Address of donor: 7 Deveron Road, Huntly | Sponsorships 8f616a6e | 2010-11-22 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 7 | 2010-11-22-8f616a6e-10074-0 |
e776ad6c319fcd3778f3be212fea57f215cbf971 | Amount of donation or nature and value if donation in kind: £2,000 donation to my constituency party | Sponsorships 8f616a6e | 2010-11-22 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 8 | 2010-11-22-8f616a6e-10074-0 |
fe8e78cd6bd4112405447eb2e5ba8ff3ff150908 | Donor status: company | Sponsorships 8f616a6e | 2010-11-22 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 9 | 2010-11-22-8f616a6e-10074-0 |
73b2f70c6b18e28184852888ac34bb9c2eae6ba2 | Name of donor: William Alexander Dean | Sponsorships 8f616a6e | 2010-11-22 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 11 | 2010-11-22-8f616a6e-10074-0 |
6e88811651015c6627a98dce9911738fb7982049 | Address of donor: private | Sponsorships 8f616a6e | 2010-11-22 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 12 | 2010-11-22-8f616a6e-10074-0 |
002c247ae10863d127ce6d0e9c716f666d94d5ba | Amount of donation or nature and value if donation in kind: £2,000. | Sponsorships 8f616a6e | 2010-11-22 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 13 | 2010-11-22-8f616a6e-10074-0 |
3ce265320ca658f0e67faf6c3ebf642308eb8ba1 | Donor status: individual | Sponsorships 8f616a6e | 2010-11-22 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 14 | 2010-11-22-8f616a6e-10074-0 |
07001819cd1d8590af0c401d35a9879a57f2f9d5 | (Registered 28 May 2010) | Sponsorships 8f616a6e | 2010-11-22 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 15 | 2010-11-22-8f616a6e-10074-0 |
d8c6ba687cc4fc1863f84627017eaba2aee78f1a | Donation of £60 made direct to charity on my behalf by Ipsos MORI for completing a survey. Address: Ipsos MORI, 79-81 Borough Road, London SE1 1FY. Hours: 30 mins. (Registered 24 November 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-12-06 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 0 | 2010-12-06-1f359ece-10074-0 |
104c605bb1a77d7a494090209bad941e2dbd76f3 | Name of donor: Cadbury/Kraft | Overseas visits 80ef1083 | 2010-12-06 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 0 | 2010-12-06-80ef1083-10074-0 |
126078fa94a0fa7096db5df2f0e084bd2ec69dfb | Address of donor: | Overseas visits 80ef1083 | 2010-12-06 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 1 | 2010-12-06-80ef1083-10074-0 |
b6854fc5632f1eef85c3e9dbb197d563801764cf | Amount of donation (or estimate of the probable value): return business class flight Heathrow-Ghana, 2 nights hotel in Accra, ground transportation, meals and hospitality; total value £4,175 | Overseas visits 80ef1083 | 2010-12-06 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 2 | 2010-12-06-80ef1083-10074-0 |
ff55dc57acdc0651289c23f51cf8dab86bbe3b3c | Destination of visit: Ghana | Overseas visits 80ef1083 | 2010-12-06 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 3 | 2010-12-06-80ef1083-10074-0 |
1ff4fb5760341f50bb77655468c59ea13cd5c826 | Date of visit: 29-31 August 2010 | Overseas visits 80ef1083 | 2010-12-06 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 4 | 2010-12-06-80ef1083-10074-0 |
4f35e89059567808861f4de44b75d98cd66a3f2a | Purpose of visit: | Overseas visits 80ef1083 | 2010-12-06 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 5 | 2010-12-06-80ef1083-10074-0 |
42a8d7c82188909ba9c6f12a75108b9761f35f2e | (Registered 23 September 2010) | Overseas visits 80ef1083 | 2010-12-06 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 6 | 2010-12-06-80ef1083-10074-0 |
9cc7d2b9b405b783d6cb0372f794fe5f75ed7e12 | Donations to the constituency party or association, which have been or will be reported by the party to the Electoral Commission: | Sponsorships 8f616a6e | 2010-12-06 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 0 | 2010-12-06-8f616a6e-10074-0 |
0f73239dee4ae34545eab2921158f82b1a22a218 | Name of donor: Mackie’s of Scotland | Sponsorships 8f616a6e | 2010-12-06 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 1 | 2010-12-06-8f616a6e-10074-0 |
af3d6d8bc510457d3e82a78338644be67ca1f3bd | Address of donor: Westertown, Rothienorman, Aberdeenshire AB51 8US | Sponsorships 8f616a6e | 2010-12-06 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 2 | 2010-12-06-8f616a6e-10074-0 |
e2c876d81b582a533552b2fa7f78beae6c8a49e6 | Amount of donation or nature and value if donation in kind: £2,000 donation to my constituency party | Sponsorships 8f616a6e | 2010-12-06 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 3 | 2010-12-06-8f616a6e-10074-0 |
91578b95ca9c4a07f53edad7fd4fb1ca483a98d4 | Name of donor: Deveron Homes | Sponsorships 8f616a6e | 2010-12-06 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 6 | 2010-12-06-8f616a6e-10074-0 |
ba42e75f82f6541cdac9bd184eb3130021ee2d23 | Address of donor: 7 Deveron Road, Huntly | Sponsorships 8f616a6e | 2010-12-06 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 7 | 2010-12-06-8f616a6e-10074-0 |
6734b843529d570e125cffd5d6a72dc473631d4f | Amount of donation or nature and value if donation in kind: £2,000 donation to my constituency party | Sponsorships 8f616a6e | 2010-12-06 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 8 | 2010-12-06-8f616a6e-10074-0 |
3c6ce7980e7224dcac073683fdd89b80679c993c | Donor status: company | Sponsorships 8f616a6e | 2010-12-06 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 9 | 2010-12-06-8f616a6e-10074-0 |
1deb76bd0a1b2e2c976cf5a54beaf6e25fce467a | Name of donor: William Alexander Dean | Sponsorships 8f616a6e | 2010-12-06 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 11 | 2010-12-06-8f616a6e-10074-0 |
60bfdfb49e957206b499b8487b736f1b87c46355 | Address of donor: private | Sponsorships 8f616a6e | 2010-12-06 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 12 | 2010-12-06-8f616a6e-10074-0 |
320550a92d13b2d4defa7449bdb78967c2407da2 | Amount of donation or nature and value if donation in kind: £2,000. | Sponsorships 8f616a6e | 2010-12-06 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 13 | 2010-12-06-8f616a6e-10074-0 |
432ecbf501bae5cd23f646c8c240f0e8fb2a878e | Donor status: individual | Sponsorships 8f616a6e | 2010-12-06 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 14 | 2010-12-06-8f616a6e-10074-0 |
5ad9258a66c6384c01389d0b383099d09c3a3066 | (Registered 28 May 2010) | Sponsorships 8f616a6e | 2010-12-06 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 15 | 2010-12-06-8f616a6e-10074-0 |
eea61cdd429bd709da618ddc3b2413b6c5a18f61 | Donation of £60 made direct to charity on my behalf by Ipsos MORI for completing a survey. Address: Ipsos MORI, 79-81 Borough Road, London SE1 1FY. Hours: 30 mins. (Registered 24 November 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-12-20 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 0 | 2010-12-20-1f359ece-10074-0 |
adbaa4477bb5c1569b72ea779cd9f9066f08815c | Name of donor: Cadbury/Kraft | Overseas visits 80ef1083 | 2010-12-20 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 0 | 2010-12-20-80ef1083-10074-0 |
c6671c18aaf900acdcfae5bb3a04e4503e06491b | Address of donor: | Overseas visits 80ef1083 | 2010-12-20 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 1 | 2010-12-20-80ef1083-10074-0 |
bca63b72f2a1d298ce26a5cd6ef70159ba7080d9 | Amount of donation (or estimate of the probable value): return business class flight Heathrow-Ghana, 2 nights hotel in Accra, ground transportation, meals and hospitality; total value £4,175 | Overseas visits 80ef1083 | 2010-12-20 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 2 | 2010-12-20-80ef1083-10074-0 |
e491e0fa5a0eff8a6781805bb4d35fae6aafc0b7 | Destination of visit: Ghana | Overseas visits 80ef1083 | 2010-12-20 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 3 | 2010-12-20-80ef1083-10074-0 |
b3d08e2618beda3920fe75d9042fd08743a38a82 | Date of visit: 29-31 August 2010 | Overseas visits 80ef1083 | 2010-12-20 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 4 | 2010-12-20-80ef1083-10074-0 |
78e722fe8b1f2b9016fe036fd7aa0d33b41de89c | Purpose of visit: | Overseas visits 80ef1083 | 2010-12-20 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 5 | 2010-12-20-80ef1083-10074-0 |
f08c39e97648de60ed9b8c5f426fc4cf0d6dd174 | (Registered 23 September 2010) | Overseas visits 80ef1083 | 2010-12-20 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 6 | 2010-12-20-80ef1083-10074-0 |
397c291f05a427a029eafa37a30a02e66b756405 | Donations to the constituency party or association, which have been or will be reported by the party to the Electoral Commission: | Sponsorships 8f616a6e | 2010-12-20 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 0 | 2010-12-20-8f616a6e-10074-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");