home / regmem

items

Data source: mySociety Data

68 rows where record_id = "2010-03-10-9e46def6-11115-0" sorted by sort_order

View and edit SQL

hash item category_id date member_id person_id sort_order record_id
05fec58caff664495bff39ea3d59bf65bbe18f19 In my role as Shadow Secretary for International Development I have received donations towards the running costs of my office, including travel costs, from the following: Sponsorship or financial or material support 9e46def6 2010-03-10 uk.org.publicwhip/member/1862 Andrew Mitchell uk.org.publicwhip/person/11115 0 2010-03-10-9e46def6-11115-0
1efb65d0ebb4a433f568755ce9b07187ebc53926 Brompton Capital Limited, London (company donation) Sponsorship or financial or material support 9e46def6 2010-03-10 uk.org.publicwhip/member/1862 Andrew Mitchell uk.org.publicwhip/person/11115 1 2010-03-10-9e46def6-11115-0
7a50356e4468fb7ae150507aa0cf23c652daea29 (Registered 4 March 2009) Sponsorship or financial or material support 9e46def6 2010-03-10 uk.org.publicwhip/member/1862 Andrew Mitchell uk.org.publicwhip/person/11115 2 2010-03-10-9e46def6-11115-0
988132fc331bdea18a3c66e8b5b8e2e734701648 Armajaro Holdings Limited, London (company donation) Sponsorship or financial or material support 9e46def6 2010-03-10 uk.org.publicwhip/member/1862 Andrew Mitchell uk.org.publicwhip/person/11115 3 2010-03-10-9e46def6-11115-0
16c37b68d66566cce196a3662be6c5c26ced749e (Registered 25 March 2009) Sponsorship or financial or material support 9e46def6 2010-03-10 uk.org.publicwhip/member/1862 Andrew Mitchell uk.org.publicwhip/person/11115 4 2010-03-10-9e46def6-11115-0
fc8988fbf3012ee07d9625a40bfc1273cb2a296b (Registered 8 April 2009) Sponsorship or financial or material support 9e46def6 2010-03-10 uk.org.publicwhip/member/1862 Andrew Mitchell uk.org.publicwhip/person/11115 6 2010-03-10-9e46def6-11115-0
377366a5a32ca64f10015207aa2ce4847cbc0929 Mr Stephen Allcock, of London (personal donation) Sponsorship or financial or material support 9e46def6 2010-03-10 uk.org.publicwhip/member/1862 Andrew Mitchell uk.org.publicwhip/person/11115 7 2010-03-10-9e46def6-11115-0
6f945cf8a2ab1b6cd525249f347fe1fdbf65e203 (Registered 5 June 2009) Sponsorship or financial or material support 9e46def6 2010-03-10 uk.org.publicwhip/member/1862 Andrew Mitchell uk.org.publicwhip/person/11115 8 2010-03-10-9e46def6-11115-0
a673578c4fed74722d010f8468eb0f2e788e1ce8 Mr Lennart Perlhagen, of London (personal donation) Sponsorship or financial or material support 9e46def6 2010-03-10 uk.org.publicwhip/member/1862 Andrew Mitchell uk.org.publicwhip/person/11115 9 2010-03-10-9e46def6-11115-0
7fe84ec0001fe80016b9e85be226fefccf9060c2 (Registered 17 June 2009) Sponsorship or financial or material support 9e46def6 2010-03-10 uk.org.publicwhip/member/1862 Andrew Mitchell uk.org.publicwhip/person/11115 10 2010-03-10-9e46def6-11115-0
814a314cd9da0c960225ddcefe30200957c7b82f Name of donor: Mr Doug Ellis Sponsorship or financial or material support 9e46def6 2010-03-10 uk.org.publicwhip/member/1862 Andrew Mitchell uk.org.publicwhip/person/11115 11 2010-03-10-9e46def6-11115-0
839ba8ce510faaef88939e673cfe749d1bf99df6 Address of donor: private Sponsorship or financial or material support 9e46def6 2010-03-10 uk.org.publicwhip/member/1862 Andrew Mitchell uk.org.publicwhip/person/11115 12 2010-03-10-9e46def6-11115-0
2d7001b775899ec664e2e213be8fcc182fce7b01 Amount of donation or nature and value if donation in kind: donation to my constituency association of £10,000 Sponsorship or financial or material support 9e46def6 2010-03-10 uk.org.publicwhip/member/1862 Andrew Mitchell uk.org.publicwhip/person/11115 13 2010-03-10-9e46def6-11115-0
f3ab59e154b04f1178aa0d00b584936dc7cd6922 Date of receipt: 25 June 2009 Sponsorship or financial or material support 9e46def6 2010-03-10 uk.org.publicwhip/member/1862 Andrew Mitchell uk.org.publicwhip/person/11115 14 2010-03-10-9e46def6-11115-0
162a744e5bcd87f3b840b34b8a5572f9f744cd5c Date of acceptance: 3 July 2009 Sponsorship or financial or material support 9e46def6 2010-03-10 uk.org.publicwhip/member/1862 Andrew Mitchell uk.org.publicwhip/person/11115 15 2010-03-10-9e46def6-11115-0
6b62b6ece243be206ee86369a2937f10cc60aacb (Registered 9 July 2009) Sponsorship or financial or material support 9e46def6 2010-03-10 uk.org.publicwhip/member/1862 Andrew Mitchell uk.org.publicwhip/person/11115 17 2010-03-10-9e46def6-11115-0
441c94b85d9f58be1d74f04105e130a4fbce1422 Name of donor: Mr Jerome Booth Sponsorship or financial or material support 9e46def6 2010-03-10 uk.org.publicwhip/member/1862 Andrew Mitchell uk.org.publicwhip/person/11115 18 2010-03-10-9e46def6-11115-0
de0199b3ecab2770b5ebcc290f976a8583d40b21 Address of donor: Private Sponsorship or financial or material support 9e46def6 2010-03-10 uk.org.publicwhip/member/1862 Andrew Mitchell uk.org.publicwhip/person/11115 19 2010-03-10-9e46def6-11115-0
a9dd4392181a66afc3f09548487e8cccc3529b4c Date of receipt: 3 August 2009 Sponsorship or financial or material support 9e46def6 2010-03-10 uk.org.publicwhip/member/1862 Andrew Mitchell uk.org.publicwhip/person/11115 21 2010-03-10-9e46def6-11115-0
d0f393e5a3d14d323e2f47de38a0ca5e8d87a863 Date of acceptance: 28 August 2009 Sponsorship or financial or material support 9e46def6 2010-03-10 uk.org.publicwhip/member/1862 Andrew Mitchell uk.org.publicwhip/person/11115 22 2010-03-10-9e46def6-11115-0
a680e28c8d0e61de2b1a03abc6d77242f55494aa Donor status: Individual Sponsorship or financial or material support 9e46def6 2010-03-10 uk.org.publicwhip/member/1862 Andrew Mitchell uk.org.publicwhip/person/11115 23 2010-03-10-9e46def6-11115-0
24361c8a94beb9cd5703e5869f678e0c907b1906 (Registered 28 August 2009) Sponsorship or financial or material support 9e46def6 2010-03-10 uk.org.publicwhip/member/1862 Andrew Mitchell uk.org.publicwhip/person/11115 24 2010-03-10-9e46def6-11115-0
9d7e4e24b2ea42605ff5f37d8e6815e47d9c5255 Name of donor: Lord Dennis Stevenson Sponsorship or financial or material support 9e46def6 2010-03-10 uk.org.publicwhip/member/1862 Andrew Mitchell uk.org.publicwhip/person/11115 25 2010-03-10-9e46def6-11115-0
a5d973790d49a3a7bf979ca5864dc56b9acaf685 Date of receipt: 24 September 2009 Sponsorship or financial or material support 9e46def6 2010-03-10 uk.org.publicwhip/member/1862 Andrew Mitchell uk.org.publicwhip/person/11115 28 2010-03-10-9e46def6-11115-0
cc5393c135d2dc875283d37494d69cfc8ebb9a94 Date of receipt: 12 October 2009 Sponsorship or financial or material support 9e46def6 2010-03-10 uk.org.publicwhip/member/1862 Andrew Mitchell uk.org.publicwhip/person/11115 35 2010-03-10-9e46def6-11115-0
7d4839df354ac4dd13d4882e7af209f402f279c2 Date of acceptance: 19 October 2009 Sponsorship or financial or material support 9e46def6 2010-03-10 uk.org.publicwhip/member/1862 Andrew Mitchell uk.org.publicwhip/person/11115 36 2010-03-10-9e46def6-11115-0
a874787f18c44e16ea9f26f2ffe8f6e48ba19d86 (Registered 19 October 2009) Sponsorship or financial or material support 9e46def6 2010-03-10 uk.org.publicwhip/member/1862 Andrew Mitchell uk.org.publicwhip/person/11115 38 2010-03-10-9e46def6-11115-0
c578567280d3340becbf2aa342f7d49de403ed45 Name of donor: Dominic Casserley Sponsorship or financial or material support 9e46def6 2010-03-10 uk.org.publicwhip/member/1862 Andrew Mitchell uk.org.publicwhip/person/11115 39 2010-03-10-9e46def6-11115-0
a139192481d7cd7f0c8226bcb8bbfe2781a2a114 Amount of donation or nature and value if donation in kind: £5000 Sponsorship or financial or material support 9e46def6 2010-03-10 uk.org.publicwhip/member/1862 Andrew Mitchell uk.org.publicwhip/person/11115 41 2010-03-10-9e46def6-11115-0
dfe70e570465abcad588ab17990c457884887841 Date of receipt: 17 November 2009 Sponsorship or financial or material support 9e46def6 2010-03-10 uk.org.publicwhip/member/1862 Andrew Mitchell uk.org.publicwhip/person/11115 42 2010-03-10-9e46def6-11115-0
097318b39bbaed42cc4a8cd27bfa076970446a83 Date of acceptance: 19 November 2009 Sponsorship or financial or material support 9e46def6 2010-03-10 uk.org.publicwhip/member/1862 Andrew Mitchell uk.org.publicwhip/person/11115 43 2010-03-10-9e46def6-11115-0
db0689b84fe76dca77b0bdd6f7fdd77a50ab5de0 (Registered 19 November 2009) Sponsorship or financial or material support 9e46def6 2010-03-10 uk.org.publicwhip/member/1862 Andrew Mitchell uk.org.publicwhip/person/11115 45 2010-03-10-9e46def6-11115-0
e34645bc35a4b83276bf5bdbee92c0526440646d Name of donor: Mr Lennart Perlhagen Sponsorship or financial or material support 9e46def6 2010-03-10 uk.org.publicwhip/member/1862 Andrew Mitchell uk.org.publicwhip/person/11115 46 2010-03-10-9e46def6-11115-0
c7e357dc2e378c4b8c27020abb7d9bcb411106f3 Amount of donation or nature and value if donation in kind: £2000 Sponsorship or financial or material support 9e46def6 2010-03-10 uk.org.publicwhip/member/1862 Andrew Mitchell uk.org.publicwhip/person/11115 48 2010-03-10-9e46def6-11115-0
cc543d6ab4aeb8933f7a265b5baf3607d26de572 Name of donor: Armajaro Holdings Limited Sponsorship or financial or material support 9e46def6 2010-03-10 uk.org.publicwhip/member/1862 Andrew Mitchell uk.org.publicwhip/person/11115 53 2010-03-10-9e46def6-11115-0
043edf2989e899aa24ce1471b8749840a1a11e24 Address of donor: 16 Charles Street, London W1J 5DS. Sponsorship or financial or material support 9e46def6 2010-03-10 uk.org.publicwhip/member/1862 Andrew Mitchell uk.org.publicwhip/person/11115 54 2010-03-10-9e46def6-11115-0
195d13cdbb36a7786da24689daed3351e18655f7 Amount of donation or nature and value if donation in kind: £10,000 Sponsorship or financial or material support 9e46def6 2010-03-10 uk.org.publicwhip/member/1862 Andrew Mitchell uk.org.publicwhip/person/11115 55 2010-03-10-9e46def6-11115-0
7d6b5aabc4591ec1d01a582e734659b2af069f17 Date of receipt: 26 November 2009 Sponsorship or financial or material support 9e46def6 2010-03-10 uk.org.publicwhip/member/1862 Andrew Mitchell uk.org.publicwhip/person/11115 56 2010-03-10-9e46def6-11115-0
71bca2a0ebc3849ea741fb7c26e6e383ff3f6f65 Date of acceptance: 8 December 2009 Sponsorship or financial or material support 9e46def6 2010-03-10 uk.org.publicwhip/member/1862 Andrew Mitchell uk.org.publicwhip/person/11115 57 2010-03-10-9e46def6-11115-0
184280daf8d59e676bceb286d1a3c6fc6b31689b Donor status: company, registration number 03575908 Sponsorship or financial or material support 9e46def6 2010-03-10 uk.org.publicwhip/member/1862 Andrew Mitchell uk.org.publicwhip/person/11115 58 2010-03-10-9e46def6-11115-0
7b896e82cb114de08c55335d632d2d472cafc1b8 (Registered 10 December 2009) Sponsorship or financial or material support 9e46def6 2010-03-10 uk.org.publicwhip/member/1862 Andrew Mitchell uk.org.publicwhip/person/11115 59 2010-03-10-9e46def6-11115-0
7abdff30df52f3ac17673fffec940eac716f4657 Name of donor: Mrs Helena Frost Sponsorship or financial or material support 9e46def6 2010-03-10 uk.org.publicwhip/member/1862 Andrew Mitchell uk.org.publicwhip/person/11115 60 2010-03-10-9e46def6-11115-0
c1834f160580db7b29768f1c47b4e9072e3a65ab Amount of donation or nature and value if donation in kind: £50,000 Sponsorship or financial or material support 9e46def6 2010-03-10 uk.org.publicwhip/member/1862 Andrew Mitchell uk.org.publicwhip/person/11115 62 2010-03-10-9e46def6-11115-0
03913588cbdc1208d0d9874a45ee1bcaaa2e1a73 Date of receipt: 17 December 2009 Sponsorship or financial or material support 9e46def6 2010-03-10 uk.org.publicwhip/member/1862 Andrew Mitchell uk.org.publicwhip/person/11115 63 2010-03-10-9e46def6-11115-0
c01868201a8feb414344a45dae3ba57bc36dcb11 Name of donor: Rockley Dene Homes Ltd Sponsorship or financial or material support 9e46def6 2010-03-10 uk.org.publicwhip/member/1862 Andrew Mitchell uk.org.publicwhip/person/11115 67 2010-03-10-9e46def6-11115-0
f03f5c325c1dff749d2c34f9e57d95d8ad60f48c Address of donor: 36 Railway Approach, Harrow, Middlesex HA3 5AA. Sponsorship or financial or material support 9e46def6 2010-03-10 uk.org.publicwhip/member/1862 Andrew Mitchell uk.org.publicwhip/person/11115 68 2010-03-10-9e46def6-11115-0
01ecff5f9ef60e57a87340462d4152f9d40bd297 Amount of donation or nature and value if donation in kind: £2500 Sponsorship or financial or material support 9e46def6 2010-03-10 uk.org.publicwhip/member/1862 Andrew Mitchell uk.org.publicwhip/person/11115 69 2010-03-10-9e46def6-11115-0
c2b94757411515a55453a299076cd0d73fce9f68 Date of receipt: 27 November 2009 Sponsorship or financial or material support 9e46def6 2010-03-10 uk.org.publicwhip/member/1862 Andrew Mitchell uk.org.publicwhip/person/11115 70 2010-03-10-9e46def6-11115-0
3fd08f7806532b3f9df7059721f3b5a9675893b8 Date of acceptance: 21 December 2009 Sponsorship or financial or material support 9e46def6 2010-03-10 uk.org.publicwhip/member/1862 Andrew Mitchell uk.org.publicwhip/person/11115 71 2010-03-10-9e46def6-11115-0
bc194b6c80434005fc9a0d5ea425e6690be60890 Donor status: company, registration number 02108777 Sponsorship or financial or material support 9e46def6 2010-03-10 uk.org.publicwhip/member/1862 Andrew Mitchell uk.org.publicwhip/person/11115 72 2010-03-10-9e46def6-11115-0
53fe573f0175120919a3703ca9a377820c4b45a7 (Registered 23 December 2009) Sponsorship or financial or material support 9e46def6 2010-03-10 uk.org.publicwhip/member/1862 Andrew Mitchell uk.org.publicwhip/person/11115 73 2010-03-10-9e46def6-11115-0
14519f7cf681e2facb2788d7168b57193560a8f9 Name of donor: Mr William Salomon Sponsorship or financial or material support 9e46def6 2010-03-10 uk.org.publicwhip/member/1862 Andrew Mitchell uk.org.publicwhip/person/11115 74 2010-03-10-9e46def6-11115-0
b7a825f7d380654728b8753c49f8ac533592f2fd Amount of donation or nature and value if donation in kind: £3,000 Sponsorship or financial or material support 9e46def6 2010-03-10 uk.org.publicwhip/member/1862 Andrew Mitchell uk.org.publicwhip/person/11115 76 2010-03-10-9e46def6-11115-0
6f039d7b389a727762630cc0889d999003e12ab1 Date of receipt: 29 January 2010 Sponsorship or financial or material support 9e46def6 2010-03-10 uk.org.publicwhip/member/1862 Andrew Mitchell uk.org.publicwhip/person/11115 77 2010-03-10-9e46def6-11115-0
597524245134885cd88831c0299e871675966065 Date of acceptance: 2 February 2010 Sponsorship or financial or material support 9e46def6 2010-03-10 uk.org.publicwhip/member/1862 Andrew Mitchell uk.org.publicwhip/person/11115 78 2010-03-10-9e46def6-11115-0
e8defcd5512c9e6d241cb76b6e085fd0e4fa6625 (Registered 5 February 2010) Sponsorship or financial or material support 9e46def6 2010-03-10 uk.org.publicwhip/member/1862 Andrew Mitchell uk.org.publicwhip/person/11115 80 2010-03-10-9e46def6-11115-0
bf1de8fe54941aefcd1fc044f1bbd1cc68b37b8f Name of donor: Brompton Capital Limited Sponsorship or financial or material support 9e46def6 2010-03-10 uk.org.publicwhip/member/1862 Andrew Mitchell uk.org.publicwhip/person/11115 81 2010-03-10-9e46def6-11115-0
f15151aa69d3de61c29889093be5eb2a1d2c2793 Address of donor: 35 South Street, London W1K 2XE. Sponsorship or financial or material support 9e46def6 2010-03-10 uk.org.publicwhip/member/1862 Andrew Mitchell uk.org.publicwhip/person/11115 82 2010-03-10-9e46def6-11115-0
59a095e0298581a0dc297fd3153cb0761e07f3c6 Amount of donation or nature and value if donation in kind: £5,000 Sponsorship or financial or material support 9e46def6 2010-03-10 uk.org.publicwhip/member/1862 Andrew Mitchell uk.org.publicwhip/person/11115 83 2010-03-10-9e46def6-11115-0
0000e09348b3c4d2a4c8d4262370d11ffb40b670 Date of receipt: 10 February 2010 Sponsorship or financial or material support 9e46def6 2010-03-10 uk.org.publicwhip/member/1862 Andrew Mitchell uk.org.publicwhip/person/11115 84 2010-03-10-9e46def6-11115-0
b1252abe215da92ed25cb8ddff707046338464f9 Donor status: company, registration number 03275808 Sponsorship or financial or material support 9e46def6 2010-03-10 uk.org.publicwhip/member/1862 Andrew Mitchell uk.org.publicwhip/person/11115 86 2010-03-10-9e46def6-11115-0
8aa298184427f089b19935525aeb455474f86966 Name of donor: Lennart Perlhagen Sponsorship or financial or material support 9e46def6 2010-03-10 uk.org.publicwhip/member/1862 Andrew Mitchell uk.org.publicwhip/person/11115 88 2010-03-10-9e46def6-11115-0
347058b85362b917f5b67744637c44b1d64deb5c Address of donor: private Sponsorship or financial or material support 9e46def6 2010-03-10 uk.org.publicwhip/member/1862 Andrew Mitchell uk.org.publicwhip/person/11115 89 2010-03-10-9e46def6-11115-0
6dada8893cf588df0905004daa336eed571746c6 Amount of donation or nature and value if donation in kind: £2,500 Sponsorship or financial or material support 9e46def6 2010-03-10 uk.org.publicwhip/member/1862 Andrew Mitchell uk.org.publicwhip/person/11115 90 2010-03-10-9e46def6-11115-0
31f1422ba93e476ccfa03a75b3dbc965e6261656 Date of receipt: 15 February 2010 Sponsorship or financial or material support 9e46def6 2010-03-10 uk.org.publicwhip/member/1862 Andrew Mitchell uk.org.publicwhip/person/11115 91 2010-03-10-9e46def6-11115-0
0b9b6b46958aa216dbbadf508b23854ce7bc3265 Date of acceptance: 23 February 2010 Sponsorship or financial or material support 9e46def6 2010-03-10 uk.org.publicwhip/member/1862 Andrew Mitchell uk.org.publicwhip/person/11115 92 2010-03-10-9e46def6-11115-0
2d7f819a452a701b7f6648d6b352abc96ee05d6e Donor status: individual Sponsorship or financial or material support 9e46def6 2010-03-10 uk.org.publicwhip/member/1862 Andrew Mitchell uk.org.publicwhip/person/11115 93 2010-03-10-9e46def6-11115-0
0d1f8a29af000113abdac66be59d8465bfa88e70 (Registered 24 February 2010) Sponsorship or financial or material support 9e46def6 2010-03-10 uk.org.publicwhip/member/1862 Andrew Mitchell uk.org.publicwhip/person/11115 94 2010-03-10-9e46def6-11115-0

Advanced export

JSON shape: default, array, object

CSV options:

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)
    )
Powered by Datasette · Query took 25.49ms · Data source: mySociety Data