items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
3,743 rows where member_id = "uk.org.publicwhip/member/40615" and person_id = "uk.org.publicwhip/person/10678" 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 |
---|---|---|---|---|---|---|---|
875d17b5a02b0da957b53e3aa0f021e01ab6252c | Fees from ComRes, 4 Millbank, London SW1P 3JA, for opinion surveys: | Remunerated employment, office, profession etc 1f359ece | 2015-03-30 | David Lammy uk.org.publicwhip/member/40615 | David Lammy uk.org.publicwhip/person/10678 | 0 | 2015-03-30-1f359ece-10678-0 |
5c055433fdb4ec479a30b4126e803d44d190384c | Fee of £75 received, March 2014. Hours: 30 mins . (Registered 10 April 2014) | Remunerated employment, office, profession etc 1f359ece | 2015-03-30 | David Lammy uk.org.publicwhip/member/40615 | David Lammy uk.org.publicwhip/person/10678 | 1 | 2015-03-30-1f359ece-10678-0 |
a66ab085767b8b2b2eaea05caa9a83cd384d5417 | Fee of £75 received May 2014. Hours: 30 mins . (Registered 10 June 2014) | Remunerated employment, office, profession etc 1f359ece | 2015-03-30 | David Lammy uk.org.publicwhip/member/40615 | David Lammy uk.org.publicwhip/person/10678 | 2 | 2015-03-30-1f359ece-10678-0 |
922d6a9522ef731c9130b5f2daa2d52a06138cc5 | Fee of £75 received June 2014. Hours: 30 mins . (Registered 10 June 2014) | Remunerated employment, office, profession etc 1f359ece | 2015-03-30 | David Lammy uk.org.publicwhip/member/40615 | David Lammy uk.org.publicwhip/person/10678 | 3 | 2015-03-30-1f359ece-10678-0 |
c4858b17399f7b88a7e75b0bffec727d84bc02f2 | Fee of £75 received September 2014. Hours: 30 mins. (Registered 3 October 2014) | Remunerated employment, office, profession etc 1f359ece | 2015-03-30 | David Lammy uk.org.publicwhip/member/40615 | David Lammy uk.org.publicwhip/person/10678 | 4 | 2015-03-30-1f359ece-10678-0 |
96f84a2352c9e86b78c3410ee704fea89a6a0fbf | Fee of £75 received November 2014. Hours: 30 mins. (Registered 2 December 2014) | Remunerated employment, office, profession etc 1f359ece | 2015-03-30 | David Lammy uk.org.publicwhip/member/40615 | David Lammy uk.org.publicwhip/person/10678 | 5 | 2015-03-30-1f359ece-10678-0 |
566b683902fb360424ea73450b67ed03a4a3d27a | Fee from YouGov, 130 Commercial Road, Portsmouth, Hants, for opinion survey: | Remunerated employment, office, profession etc 1f359ece | 2015-03-30 | David Lammy uk.org.publicwhip/member/40615 | David Lammy uk.org.publicwhip/person/10678 | 0 | 2015-03-30-1f359ece-10678-1 |
df9014592f935a2f26a375b6b3a5ead05689799e | Fee of £80 received June 2014. Hours: 30 mins. (Registered 10 June 2014) | Remunerated employment, office, profession etc 1f359ece | 2015-03-30 | David Lammy uk.org.publicwhip/member/40615 | David Lammy uk.org.publicwhip/person/10678 | 1 | 2015-03-30-1f359ece-10678-1 |
ce27132b3e9ac4d5a6323d29afc63d6abd5b20d3 | Fees from Ipsos MORI ,9-81 Borough Road, London SE1 1FY, for opinion surveys. | Remunerated employment, office, profession etc 1f359ece | 2015-03-30 | David Lammy uk.org.publicwhip/member/40615 | David Lammy uk.org.publicwhip/person/10678 | 0 | 2015-03-30-1f359ece-10678-2 |
f693bb8fb0ff1aa086de9e4ef933603ab75d4d04 | September 2014, fee of £200. Hours 1 hr. (Registered 23 September 2014) | Remunerated employment, office, profession etc 1f359ece | 2015-03-30 | David Lammy uk.org.publicwhip/member/40615 | David Lammy uk.org.publicwhip/person/10678 | 1 | 2015-03-30-1f359ece-10678-2 |
549aa4cfcb6d73c38dd9008776d55f9ece42d7f5 | Payments for articles from Guardian News and Media Limited, PO Box 68164, Kings Place, 90 York Way, London N1P 2AP: | Remunerated employment, office, profession etc 1f359ece | 2015-03-30 | David Lammy uk.org.publicwhip/member/40615 | David Lammy uk.org.publicwhip/person/10678 | 0 | 2015-03-30-1f359ece-10678-3 |
8419b077517ec6ee084c248e5419fd3661ac3254 | June 2014, fee of £90 received. Hours 2 hrs. (Registered 22 October 2014) | Remunerated employment, office, profession etc 1f359ece | 2015-03-30 | David Lammy uk.org.publicwhip/member/40615 | David Lammy uk.org.publicwhip/person/10678 | 1 | 2015-03-30-1f359ece-10678-3 |
ef01dcc4e1e128fd6bb560a20334307110a42458 | August 2014, fee of £90 received. Hours: 2 hrs. (Registered 22 October 2014) | Remunerated employment, office, profession etc 1f359ece | 2015-03-30 | David Lammy uk.org.publicwhip/member/40615 | David Lammy uk.org.publicwhip/person/10678 | 2 | 2015-03-30-1f359ece-10678-3 |
c2bd9e4da33666ba1789e5889190f3097b708c32 | Fee from Cumberlege Connections Ltd, Snells Cottage, The Green, Newick, Lewes BN8 4LA: | Remunerated employment, office, profession etc 1f359ece | 2015-03-30 | David Lammy uk.org.publicwhip/member/40615 | David Lammy uk.org.publicwhip/person/10678 | 0 | 2015-03-30-1f359ece-10678-4 |
f91f7e80e4a36ccacbd3416e9063e1d4e4c6092b | April 2014, received fee of £300 for training session. Hours: 3 hrs. (Registered 16 May 2014) | Remunerated employment, office, profession etc 1f359ece | 2015-03-30 | David Lammy uk.org.publicwhip/member/40615 | David Lammy uk.org.publicwhip/person/10678 | 1 | 2015-03-30-1f359ece-10678-4 |
a61b522f8f3028f5cb48b16597bc81e263a5e409 | Fees from BBC, PO Box 480, Manchester M14 0EL: | Remunerated employment, office, profession etc 1f359ece | 2015-03-30 | David Lammy uk.org.publicwhip/member/40615 | David Lammy uk.org.publicwhip/person/10678 | 0 | 2015-03-30-1f359ece-10678-5 |
dfa8bd67c034dae46ed32563d7a8963b0e564225 | May 2014, received fee of £150 for radio appearance. Hours: 1 hr. (Registered 27 May 2014) | Remunerated employment, office, profession etc 1f359ece | 2015-03-30 | David Lammy uk.org.publicwhip/member/40615 | David Lammy uk.org.publicwhip/person/10678 | 1 | 2015-03-30-1f359ece-10678-5 |
024c92c9aa07b85dd0f34bbf9628fbaab02e0151 | Fee of £471.36 plus travel and accommodation, from Region Syddanmark, Damhaven 12, 7100 Vejle, Denmark, for speaking engagement. Hours: 1 hr. (Registered 27 May 2014) | Remunerated employment, office, profession etc 1f359ece | 2015-03-30 | David Lammy uk.org.publicwhip/member/40615 | David Lammy uk.org.publicwhip/person/10678 | 0 | 2015-03-30-1f359ece-10678-6 |
5013c06e3656329ed9fdffe3ff2db19023b379a8 | September 2014, fee of £915 received from Delta State University, Cleveland, MS 38733, USA, for speaking at and attending a conference. The costs of travel, accommodation and hospitality, 13-18 September 2014, were met by the donor. Hours: 4 hrs. (Registered 3 October 2014) | Remunerated employment, office, profession etc 1f359ece | 2015-03-30 | David Lammy uk.org.publicwhip/member/40615 | David Lammy uk.org.publicwhip/person/10678 | 0 | 2015-03-30-1f359ece-10678-7 |
61a7bfe1da3473b4d51270b4adcf10064c94cd88 | Support in the capacity as an MP: | Sponsorships 8f616a6e | 2015-03-30 | David Lammy uk.org.publicwhip/member/40615 | David Lammy uk.org.publicwhip/person/10678 | 0 | 2015-03-30-8f616a6e-10678-0 |
7b406fd35348df90bd358bb7fe7bcd0a1d36462e | Name of donor: Toolkit Websites | Sponsorships 8f616a6e | 2015-03-30 | David Lammy uk.org.publicwhip/member/40615 | David Lammy uk.org.publicwhip/person/10678 | 0 | 2015-03-30-8f616a6e-10678-1 |
2ef5c176bd92349aff10afdff1f7866fa0714151 | Address of donor: 30 Carlton Crescent Southampton SO15 2EW | Sponsorships 8f616a6e | 2015-03-30 | David Lammy uk.org.publicwhip/member/40615 | David Lammy uk.org.publicwhip/person/10678 | 1 | 2015-03-30-8f616a6e-10678-1 |
b38060cfd382785c0a13a913b8f05661e27e57e5 | Amount of donation or nature and value if donation in kind: hosting and maintenance of my website; value £6,000 a year until 1 November 2014, and £1,200 a year thereafter | Sponsorships 8f616a6e | 2015-03-30 | David Lammy uk.org.publicwhip/member/40615 | David Lammy uk.org.publicwhip/person/10678 | 2 | 2015-03-30-8f616a6e-10678-1 |
ba12c35382334855a350c6fed290f24ecf9cc4a8 | Date of receipt: received since 7 May 2010 | Sponsorships 8f616a6e | 2015-03-30 | David Lammy uk.org.publicwhip/member/40615 | David Lammy uk.org.publicwhip/person/10678 | 3 | 2015-03-30-8f616a6e-10678-1 |
0763c3f8d5072f624fe5c93553f99b2cc2fda3f7 | Date of acceptance: received since 7 May 2010 | Sponsorships 8f616a6e | 2015-03-30 | David Lammy uk.org.publicwhip/member/40615 | David Lammy uk.org.publicwhip/person/10678 | 4 | 2015-03-30-8f616a6e-10678-1 |
9b2d6fd319bbbe93e7d95a8c53f52ed8efeafd48 | Donor status: company No 04718196 | Sponsorships 8f616a6e | 2015-03-30 | David Lammy uk.org.publicwhip/member/40615 | David Lammy uk.org.publicwhip/person/10678 | 5 | 2015-03-30-8f616a6e-10678-1 |
0a8fe0ccd3792e0570c4f10620af84d1853cb89d | (Registered 30 June 2011; updated 4 October 2012; updated 14 November 2013 and 15 December 2014) | Sponsorships 8f616a6e | 2015-03-30 | David Lammy uk.org.publicwhip/member/40615 | David Lammy uk.org.publicwhip/person/10678 | 6 | 2015-03-30-8f616a6e-10678-1 |
cb122d5a20c80ef1356d37fea4acc297d6f17d02 | Name of donor: Sir Trevor Chinn | Sponsorships 8f616a6e | 2015-03-30 | David Lammy uk.org.publicwhip/member/40615 | David Lammy uk.org.publicwhip/person/10678 | 0 | 2015-03-30-8f616a6e-10678-2 |
2cc108b4b7cb5c5a427ae0ed4268cc1822b5d38f | Address of donor: private | Sponsorships 8f616a6e | 2015-03-30 | David Lammy uk.org.publicwhip/member/40615 | David Lammy uk.org.publicwhip/person/10678 | 1 | 2015-03-30-8f616a6e-10678-2 |
caeb63b97f58d0c3d0ff950d3343fa44f05d8de4 | Amount of donation or nature and value if donation in kind: £5,000 | Sponsorships 8f616a6e | 2015-03-30 | David Lammy uk.org.publicwhip/member/40615 | David Lammy uk.org.publicwhip/person/10678 | 2 | 2015-03-30-8f616a6e-10678-2 |
a023e9f6c7b88abfe29d618fc81203c18e24286d | Date of receipt: 30 May 2014 | Sponsorships 8f616a6e | 2015-03-30 | David Lammy uk.org.publicwhip/member/40615 | David Lammy uk.org.publicwhip/person/10678 | 3 | 2015-03-30-8f616a6e-10678-2 |
285613ea4a2c28f93f70241e250f0cc48d363329 | Date of acceptance: 30 May 2014 | Sponsorships 8f616a6e | 2015-03-30 | David Lammy uk.org.publicwhip/member/40615 | David Lammy uk.org.publicwhip/person/10678 | 4 | 2015-03-30-8f616a6e-10678-2 |
9abd54b5f35615ef33386fc310717bd703897c04 | Donor status: individual | Sponsorships 8f616a6e | 2015-03-30 | David Lammy uk.org.publicwhip/member/40615 | David Lammy uk.org.publicwhip/person/10678 | 5 | 2015-03-30-8f616a6e-10678-2 |
05d42a025e29bbd38e7d173978a6f62605fe6841 | (Registered 7 July 2014) | Sponsorships 8f616a6e | 2015-03-30 | David Lammy uk.org.publicwhip/member/40615 | David Lammy uk.org.publicwhip/person/10678 | 6 | 2015-03-30-8f616a6e-10678-2 |
b8d7a628ee97a7bda7f8565a0a0726a7e48715a2 | Name of donor: Adrian Christmas | Sponsorships 8f616a6e | 2015-03-30 | David Lammy uk.org.publicwhip/member/40615 | David Lammy uk.org.publicwhip/person/10678 | 0 | 2015-03-30-8f616a6e-10678-3 |
b65a0d124f28a18bfc2f9e82d377b3e8dbbe7157 | Address of donor: private | Sponsorships 8f616a6e | 2015-03-30 | David Lammy uk.org.publicwhip/member/40615 | David Lammy uk.org.publicwhip/person/10678 | 1 | 2015-03-30-8f616a6e-10678-3 |
1ae69276376de19a7c1f11d048af22a7fe851e88 | Amount of donation or nature and value if donation in kind: £4,200 | Sponsorships 8f616a6e | 2015-03-30 | David Lammy uk.org.publicwhip/member/40615 | David Lammy uk.org.publicwhip/person/10678 | 2 | 2015-03-30-8f616a6e-10678-3 |
cf4f16d516daff92675d66b7f62388957d521ec6 | Date of receipt: 9 June 2014 | Sponsorships 8f616a6e | 2015-03-30 | David Lammy uk.org.publicwhip/member/40615 | David Lammy uk.org.publicwhip/person/10678 | 3 | 2015-03-30-8f616a6e-10678-3 |
8ae6d953583603a41cfac5cb719780e3e6558744 | Date of acceptance: 9 June 2014 | Sponsorships 8f616a6e | 2015-03-30 | David Lammy uk.org.publicwhip/member/40615 | David Lammy uk.org.publicwhip/person/10678 | 4 | 2015-03-30-8f616a6e-10678-3 |
922659702dcd226e846f3b433515be72ca3a8260 | Donor status: individual | Sponsorships 8f616a6e | 2015-03-30 | David Lammy uk.org.publicwhip/member/40615 | David Lammy uk.org.publicwhip/person/10678 | 5 | 2015-03-30-8f616a6e-10678-3 |
efbf2ab6a8ac8d717e8c367da1bcf3f7e9b5a18c | (Registered 7 July 2014) | Sponsorships 8f616a6e | 2015-03-30 | David Lammy uk.org.publicwhip/member/40615 | David Lammy uk.org.publicwhip/person/10678 | 6 | 2015-03-30-8f616a6e-10678-3 |
fbf7035b3ff621695c43b33a0409bf7b7267ab8c | Name of donor: Mary O’Rourke | Sponsorships 8f616a6e | 2015-03-30 | David Lammy uk.org.publicwhip/member/40615 | David Lammy uk.org.publicwhip/person/10678 | 0 | 2015-03-30-8f616a6e-10678-4 |
f369a4ba04bb6aca0357fc83eb2024a5afcc67ca | Address of donor: private | Sponsorships 8f616a6e | 2015-03-30 | David Lammy uk.org.publicwhip/member/40615 | David Lammy uk.org.publicwhip/person/10678 | 1 | 2015-03-30-8f616a6e-10678-4 |
4357031ff58adbf8f631b56b77deabcb6d69e6a8 | Amount of donation or nature and value if donation in kind: £2,500 | Sponsorships 8f616a6e | 2015-03-30 | David Lammy uk.org.publicwhip/member/40615 | David Lammy uk.org.publicwhip/person/10678 | 2 | 2015-03-30-8f616a6e-10678-4 |
e84ed2df9638b9c2ca470d8adfdfd52b2585a097 | Date of receipt: 3 June 2014 | Sponsorships 8f616a6e | 2015-03-30 | David Lammy uk.org.publicwhip/member/40615 | David Lammy uk.org.publicwhip/person/10678 | 3 | 2015-03-30-8f616a6e-10678-4 |
da268cd1753b46641c6656818be9346fd7c8f254 | Date of acceptance: 3 June 2014 | Sponsorships 8f616a6e | 2015-03-30 | David Lammy uk.org.publicwhip/member/40615 | David Lammy uk.org.publicwhip/person/10678 | 4 | 2015-03-30-8f616a6e-10678-4 |
7692ba39f645bd14b59cdcff78f5435aba86c12a | Donor status: individual | Sponsorships 8f616a6e | 2015-03-30 | David Lammy uk.org.publicwhip/member/40615 | David Lammy uk.org.publicwhip/person/10678 | 5 | 2015-03-30-8f616a6e-10678-4 |
8098117e69dbac892f586786ccb42b87fa6288dc | (Registered 9 July 2014) | Sponsorships 8f616a6e | 2015-03-30 | David Lammy uk.org.publicwhip/member/40615 | David Lammy uk.org.publicwhip/person/10678 | 6 | 2015-03-30-8f616a6e-10678-4 |
55eb1f3fe3e313d697a8f99f0c85d6afc516aec5 | Name of donor: Mission Media Ltd Address of Donor: 32 Shelton Street, London WC2H 9JE Amount of donation or nature and value if donation in kind: communications advice at an estimated value of £5,500 Date of receipt: 1 August 2014 Date of acceptance: 28 August 2014 Donor status: company, registration 04745677 | Sponsorships 8f616a6e | 2015-03-30 | David Lammy uk.org.publicwhip/member/40615 | David Lammy uk.org.publicwhip/person/10678 | 0 | 2015-03-30-8f616a6e-10678-5 |
f28f666dfe74a4dd94201e2fcf95ae517ba98110 | (Registered 25 September 2014) | Sponsorships 8f616a6e | 2015-03-30 | David Lammy uk.org.publicwhip/member/40615 | David Lammy uk.org.publicwhip/person/10678 | 1 | 2015-03-30-8f616a6e-10678-5 |
96df0bfce3ead7f15a5eff4d19c4dbf716681bcc | Name of donor: Key Locators Leyton Ltd Address of Donor: 423 Lea Bridge Road, Leyton, London E10 7EA Amount of donation or nature and value if donation in kind: Loan of an office; monthly value: £784 for 6 months until March 2015 in first instance, total £4,704 Date of receipt: 11 September 2014 Date of acceptance: 11 September 2014 Donor status: company, registration 05545094 | Sponsorships 8f616a6e | 2015-03-30 | David Lammy uk.org.publicwhip/member/40615 | David Lammy uk.org.publicwhip/person/10678 | 0 | 2015-03-30-8f616a6e-10678-6 |
e85f781f23d83b30ef3f994ca17cffa643913ac2 | (Registered 3 October 2014) | Sponsorships 8f616a6e | 2015-03-30 | David Lammy uk.org.publicwhip/member/40615 | David Lammy uk.org.publicwhip/person/10678 | 1 | 2015-03-30-8f616a6e-10678-6 |
2f073ae339f48f539851e5ab2bd669fcf01fbd51 | Name of donor: Mission Media Ltd Address of Donor: 32 Shelton Street, London WC2H 9JE Amount of donation or nature and value if donation in kind: communications advice at an estimated value of £5,500 Date of receipt: 30 September 2014 Date of acceptance: 30 September 2014 Donor status: company, registration 04745677 | Sponsorships 8f616a6e | 2015-03-30 | David Lammy uk.org.publicwhip/member/40615 | David Lammy uk.org.publicwhip/person/10678 | 0 | 2015-03-30-8f616a6e-10678-7 |
6ed649316a16b1c898ef89da1e31a02b7c84c4bb | (Registered 30 October 2014) | Sponsorships 8f616a6e | 2015-03-30 | David Lammy uk.org.publicwhip/member/40615 | David Lammy uk.org.publicwhip/person/10678 | 1 | 2015-03-30-8f616a6e-10678-7 |
5e27b9af73933c7ed5153d2d2241549352886f0c | Name of donor: Mission Media Ltd Address of Donor: 32 Shelton Street, London WC2H 9JE Amount of donation or nature and value if donation in kind: communications advice at an estimated value of £5,500 Date of receipt: 30 October 2014 Date of acceptance: 30 October 2014 Donor status: company, registration 04745677 | Sponsorships 8f616a6e | 2015-03-30 | David Lammy uk.org.publicwhip/member/40615 | David Lammy uk.org.publicwhip/person/10678 | 0 | 2015-03-30-8f616a6e-10678-8 |
1db002bcba68f7f61c48b34b25ff00ee87af97d5 | (Registered 2 December 2014) | Sponsorships 8f616a6e | 2015-03-30 | David Lammy uk.org.publicwhip/member/40615 | David Lammy uk.org.publicwhip/person/10678 | 1 | 2015-03-30-8f616a6e-10678-8 |
cdaeee037764d1a91f79195e10e3e9cfa6453327 | Name of donor: Fostermco Ltd | Sponsorships 8f616a6e | 2015-03-30 | David Lammy uk.org.publicwhip/member/40615 | David Lammy uk.org.publicwhip/person/10678 | 0 | 2015-03-30-8f616a6e-10678-9 |
f648ae5f0a9dee1b9daccab38b7f97ecd7ea95a9 | Address of Donor: Regina House, 124 Finchley Road, London, NW3 5JS Amount of donation or nature and value if donation in kind: £5,000 Date of receipt: 14 November 2014 Date of acceptance: 5 December 2014 Donor status: company, registration 08572386 | Sponsorships 8f616a6e | 2015-03-30 | David Lammy uk.org.publicwhip/member/40615 | David Lammy uk.org.publicwhip/person/10678 | 1 | 2015-03-30-8f616a6e-10678-9 |
f9247353b59c556aeb02304f7df25b5a4c9d9ef6 | (Registered 8 December 2014) | Sponsorships 8f616a6e | 2015-03-30 | David Lammy uk.org.publicwhip/member/40615 | David Lammy uk.org.publicwhip/person/10678 | 2 | 2015-03-30-8f616a6e-10678-9 |
95ff54e88d4d7ebd1f8522bfb0309d3d4d2ef34c | Name of donor: Mission Media Ltd Address of Donor: 32 Shelton Street, London WC2H 9JE Amount of donation or nature and value if donation in kind: communications advice at an estimated value of £5,500 Date of receipt: 30 November 2014 Date of acceptance: 30 November 2014 Donor status: company, registration 04745677 | Sponsorships 8f616a6e | 2015-03-30 | David Lammy uk.org.publicwhip/member/40615 | David Lammy uk.org.publicwhip/person/10678 | 0 | 2015-03-30-8f616a6e-10678-10 |
c1f8507ee4a99d9d98d9323cae4b024d8d8bfbfd | (Registered 29 January 2015) | Sponsorships 8f616a6e | 2015-03-30 | David Lammy uk.org.publicwhip/member/40615 | David Lammy uk.org.publicwhip/person/10678 | 1 | 2015-03-30-8f616a6e-10678-10 |
a6089b3856211d88c16eadb46dd5faa0c50d539b | Name of donor: Mission Media Ltd Address of Donor: 32 Shelton Street, London WC2H 9JE Amount of donation or nature and value if donation in kind: communications advice at an estimated value of £5,500 Date of receipt: 30 December 2014 Date of acceptance: 30 December 2014 Donor status: company, registration 04745677 | Sponsorships 8f616a6e | 2015-03-30 | David Lammy uk.org.publicwhip/member/40615 | David Lammy uk.org.publicwhip/person/10678 | 0 | 2015-03-30-8f616a6e-10678-11 |
2e1c5011e168d031f2c4adefcbeede5fde5ae9dd | (Registered 29 January 2015) | Sponsorships 8f616a6e | 2015-03-30 | David Lammy uk.org.publicwhip/member/40615 | David Lammy uk.org.publicwhip/person/10678 | 1 | 2015-03-30-8f616a6e-10678-11 |
04ca60b55c90f70d89ef769a6e699e0de6224c0a | Name of donor: Sir Trevor Chinn | Sponsorships 8f616a6e | 2015-03-30 | David Lammy uk.org.publicwhip/member/40615 | David Lammy uk.org.publicwhip/person/10678 | 0 | 2015-03-30-8f616a6e-10678-12 |
ec30a09047328f4b1d9d8126d976c40d8e476849 | Address of donor: private | Sponsorships 8f616a6e | 2015-03-30 | David Lammy uk.org.publicwhip/member/40615 | David Lammy uk.org.publicwhip/person/10678 | 1 | 2015-03-30-8f616a6e-10678-12 |
9adbfd6321a64e5c05234aeefeef686e9eb66ebe | Amount of donation or nature and value if donation in kind: £5,000 | Sponsorships 8f616a6e | 2015-03-30 | David Lammy uk.org.publicwhip/member/40615 | David Lammy uk.org.publicwhip/person/10678 | 2 | 2015-03-30-8f616a6e-10678-12 |
c4ad2109059c3a192f9eb42bccb403b6613ca7b0 | Date of receipt: 27 September 2014 | Sponsorships 8f616a6e | 2015-03-30 | David Lammy uk.org.publicwhip/member/40615 | David Lammy uk.org.publicwhip/person/10678 | 3 | 2015-03-30-8f616a6e-10678-12 |
44131a4a7193302fb232420e6e81458161b64201 | Date of acceptance: 27 September 2014 | Sponsorships 8f616a6e | 2015-03-30 | David Lammy uk.org.publicwhip/member/40615 | David Lammy uk.org.publicwhip/person/10678 | 4 | 2015-03-30-8f616a6e-10678-12 |
a4fcc26288ced73cd4e21f20586d95f70a0e420b | Donor status: individual | Sponsorships 8f616a6e | 2015-03-30 | David Lammy uk.org.publicwhip/member/40615 | David Lammy uk.org.publicwhip/person/10678 | 5 | 2015-03-30-8f616a6e-10678-12 |
3104b5ae74c6d7f55dfaccc9a59c27dfa0a83127 | (Registered 19 February 2015) | Sponsorships 8f616a6e | 2015-03-30 | David Lammy uk.org.publicwhip/member/40615 | David Lammy uk.org.publicwhip/person/10678 | 6 | 2015-03-30-8f616a6e-10678-12 |
184d4c9ebacd19f2ff02dc2f3ad563bc13f4bea4 | Name of donor: Adrian Christmas | Sponsorships 8f616a6e | 2015-03-30 | David Lammy uk.org.publicwhip/member/40615 | David Lammy uk.org.publicwhip/person/10678 | 0 | 2015-03-30-8f616a6e-10678-13 |
20eb5b0084fbdd72179632dd3ba754cd1123b5d4 | Address of donor: private | Sponsorships 8f616a6e | 2015-03-30 | David Lammy uk.org.publicwhip/member/40615 | David Lammy uk.org.publicwhip/person/10678 | 1 | 2015-03-30-8f616a6e-10678-13 |
51fad3a57b6efe51f66db69a8cacdc5ed7849d1a | Amount of donation or nature and value if donation in kind: £2,500 | Sponsorships 8f616a6e | 2015-03-30 | David Lammy uk.org.publicwhip/member/40615 | David Lammy uk.org.publicwhip/person/10678 | 2 | 2015-03-30-8f616a6e-10678-13 |
36a68d734e5e6880bbec584addce74d125170203 | Date of receipt: 22 October 2014 | Sponsorships 8f616a6e | 2015-03-30 | David Lammy uk.org.publicwhip/member/40615 | David Lammy uk.org.publicwhip/person/10678 | 3 | 2015-03-30-8f616a6e-10678-13 |
bf7a617572c012968ef5795c2eb1f29d80b19966 | Date of acceptance: 22 October 2014 | Sponsorships 8f616a6e | 2015-03-30 | David Lammy uk.org.publicwhip/member/40615 | David Lammy uk.org.publicwhip/person/10678 | 4 | 2015-03-30-8f616a6e-10678-13 |
797f8b9f6aeaadfb46a368259e2fd048801ab8dc | Donor status: individual | Sponsorships 8f616a6e | 2015-03-30 | David Lammy uk.org.publicwhip/member/40615 | David Lammy uk.org.publicwhip/person/10678 | 5 | 2015-03-30-8f616a6e-10678-13 |
d01ccbc82a3b6501e9600b811f808ae7fe304451 | (Registered 19 February 2015) | Sponsorships 8f616a6e | 2015-03-30 | David Lammy uk.org.publicwhip/member/40615 | David Lammy uk.org.publicwhip/person/10678 | 6 | 2015-03-30-8f616a6e-10678-13 |
e6d1e633e28f7845d4af06cca0da02dfa0f7aa5f | Name of donor: Sir Trevor Chinn | Sponsorships 8f616a6e | 2015-03-30 | David Lammy uk.org.publicwhip/member/40615 | David Lammy uk.org.publicwhip/person/10678 | 0 | 2015-03-30-8f616a6e-10678-14 |
aebf2b3672daa5426b7bebd6506bfd041d7af38b | Address of donor: private | Sponsorships 8f616a6e | 2015-03-30 | David Lammy uk.org.publicwhip/member/40615 | David Lammy uk.org.publicwhip/person/10678 | 1 | 2015-03-30-8f616a6e-10678-14 |
278a6270bcf95cffad9f773510e48dbac61a541e | Amount of donation or nature and value if donation in kind: £5,000 | Sponsorships 8f616a6e | 2015-03-30 | David Lammy uk.org.publicwhip/member/40615 | David Lammy uk.org.publicwhip/person/10678 | 2 | 2015-03-30-8f616a6e-10678-14 |
2db473bd65cf45befa9912144cf87c8af7669248 | Date of receipt: 22 December 2014 | Sponsorships 8f616a6e | 2015-03-30 | David Lammy uk.org.publicwhip/member/40615 | David Lammy uk.org.publicwhip/person/10678 | 3 | 2015-03-30-8f616a6e-10678-14 |
f75541c2746ff61f4ec5568a99b14df3ec047bd1 | Date of acceptance: 22 December 2014 | Sponsorships 8f616a6e | 2015-03-30 | David Lammy uk.org.publicwhip/member/40615 | David Lammy uk.org.publicwhip/person/10678 | 4 | 2015-03-30-8f616a6e-10678-14 |
60ee9c04a51a104e44e029e75dc014dfd2216888 | Donor status: individual | Sponsorships 8f616a6e | 2015-03-30 | David Lammy uk.org.publicwhip/member/40615 | David Lammy uk.org.publicwhip/person/10678 | 5 | 2015-03-30-8f616a6e-10678-14 |
1fb160d78116daf39194996efc1a3e140153ab81 | (Registered 19 February 2015) | Sponsorships 8f616a6e | 2015-03-30 | David Lammy uk.org.publicwhip/member/40615 | David Lammy uk.org.publicwhip/person/10678 | 6 | 2015-03-30-8f616a6e-10678-14 |
fba0d53cae9edc88f03bc80043d47b9b069ab947 | Name of donor: Richard Greer | Sponsorships 8f616a6e | 2015-03-30 | David Lammy uk.org.publicwhip/member/40615 | David Lammy uk.org.publicwhip/person/10678 | 0 | 2015-03-30-8f616a6e-10678-15 |
0b1061c7cdb82a2243c6904d07e20b3ceaf86bc9 | Address of donor: private | Sponsorships 8f616a6e | 2015-03-30 | David Lammy uk.org.publicwhip/member/40615 | David Lammy uk.org.publicwhip/person/10678 | 1 | 2015-03-30-8f616a6e-10678-15 |
fe00516b47fa44fa3d0a1eda790959bd7cbef57b | Amount of donation or nature and value if donation in kind: £10,000 | Sponsorships 8f616a6e | 2015-03-30 | David Lammy uk.org.publicwhip/member/40615 | David Lammy uk.org.publicwhip/person/10678 | 2 | 2015-03-30-8f616a6e-10678-15 |
766575e505f910483cbdec0c98867afdfe36a038 | Date of receipt: 23 January 2015 | Sponsorships 8f616a6e | 2015-03-30 | David Lammy uk.org.publicwhip/member/40615 | David Lammy uk.org.publicwhip/person/10678 | 3 | 2015-03-30-8f616a6e-10678-15 |
77101a0b4708da6cec8feb27285462f74185bd16 | Date of acceptance: 29 January 2015 | Sponsorships 8f616a6e | 2015-03-30 | David Lammy uk.org.publicwhip/member/40615 | David Lammy uk.org.publicwhip/person/10678 | 4 | 2015-03-30-8f616a6e-10678-15 |
f1a6c97e3827b64e30160c28fa682a68d3608a43 | Donor status: individual | Sponsorships 8f616a6e | 2015-03-30 | David Lammy uk.org.publicwhip/member/40615 | David Lammy uk.org.publicwhip/person/10678 | 5 | 2015-03-30-8f616a6e-10678-15 |
6ec7cdef4501d78cbbe710d383b5ef4bcd48880b | (Registered 19 February 2015) | Sponsorships 8f616a6e | 2015-03-30 | David Lammy uk.org.publicwhip/member/40615 | David Lammy uk.org.publicwhip/person/10678 | 6 | 2015-03-30-8f616a6e-10678-15 |
a665121b40719263c6e19d75bf023fb4ccd028d6 | Name of donor: Mission Media Ltd Address of Donor: 32 Shelton Street, London WC2H 9JE Amount of donation or nature and value if donation in kind: communications advice at an estimated value of £5,500 Date of receipt: 31 January 2015 Date of acceptance: 31 January 2015 Donor status: company, registration 04745677 | Sponsorships 8f616a6e | 2015-03-30 | David Lammy uk.org.publicwhip/member/40615 | David Lammy uk.org.publicwhip/person/10678 | 0 | 2015-03-30-8f616a6e-10678-16 |
a57119bb53908da915a083dc2c49569d756f748d | (Registered 19 February 2015) | Sponsorships 8f616a6e | 2015-03-30 | David Lammy uk.org.publicwhip/member/40615 | David Lammy uk.org.publicwhip/person/10678 | 1 | 2015-03-30-8f616a6e-10678-16 |
1782172dd0840caff2f68913d61fb902517a2a59 | Name of donor: Jonathan Goodman | Sponsorships 8f616a6e | 2015-03-30 | David Lammy uk.org.publicwhip/member/40615 | David Lammy uk.org.publicwhip/person/10678 | 0 | 2015-03-30-8f616a6e-10678-17 |
f55f634bcf6f5e5ccd261aefa33e2cd88361f83d | Address of donor: private | Sponsorships 8f616a6e | 2015-03-30 | David Lammy uk.org.publicwhip/member/40615 | David Lammy uk.org.publicwhip/person/10678 | 1 | 2015-03-30-8f616a6e-10678-17 |
958f0b07c91c96af77f39dca4072b57bf355d0fb | Amount of donation or nature and value if donation in kind: £10,000 | Sponsorships 8f616a6e | 2015-03-30 | David Lammy uk.org.publicwhip/member/40615 | David Lammy uk.org.publicwhip/person/10678 | 2 | 2015-03-30-8f616a6e-10678-17 |
d63921c8d12e02dfd0066ff897b5f7da9b086719 | Date of receipt: 20 February 2015 | Sponsorships 8f616a6e | 2015-03-30 | David Lammy uk.org.publicwhip/member/40615 | David Lammy uk.org.publicwhip/person/10678 | 3 | 2015-03-30-8f616a6e-10678-17 |
8a1bd051d9fbf39434d8a2a94b1e6f4e2cfcecb5 | Date of acceptance: 20 February 2015 | Sponsorships 8f616a6e | 2015-03-30 | David Lammy uk.org.publicwhip/member/40615 | David Lammy uk.org.publicwhip/person/10678 | 4 | 2015-03-30-8f616a6e-10678-17 |
d6a3a368f4179df02202f10d293c5848ae8bb285 | Donor status: individual | Sponsorships 8f616a6e | 2015-03-30 | David Lammy uk.org.publicwhip/member/40615 | David Lammy uk.org.publicwhip/person/10678 | 5 | 2015-03-30-8f616a6e-10678-17 |
72c05e9e28cac1b14863edc2a06338df6730ccce | (Registered 10 March 2015) | Sponsorships 8f616a6e | 2015-03-30 | David Lammy uk.org.publicwhip/member/40615 | David Lammy uk.org.publicwhip/person/10678 | 6 | 2015-03-30-8f616a6e-10678-17 |
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");