items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
11,193 rows where person_id = "uk.org.publicwhip/person/10678" sorted by category_id
This data as json, CSV (advanced)
Suggested facets: category_id, member_id, date (date)
hash | item | category_id ▼ | date | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
867394306becc61cc751bab5171cffd22001ea15 | Fees from ComRes, 4 Millbank, London SW1P 3JA, for opinion surveys: | Employment and earnings 10057ffd | 2015-06-08 | David Lammy uk.org.publicwhip/person/10678 | 0 | 2015-06-08-10057ffd-10678-0 | |
c166d0cfef14ebeb45065676389045a7f545b096 | Fee of £75 received May 2014. Hours: 30 mins. (Registered 10 June 2014) | Employment and earnings 10057ffd | 2015-06-08 | David Lammy uk.org.publicwhip/person/10678 | 1 | 2015-06-08-10057ffd-10678-0 | |
06a7e94666ca274789c8aaae28edaedf97fc2640 | Fee of £75 received June 2014. Hours: 30 mins. (Registered 10 June 2014) | Employment and earnings 10057ffd | 2015-06-08 | David Lammy uk.org.publicwhip/person/10678 | 2 | 2015-06-08-10057ffd-10678-0 | |
5dc5d1d7f330e9b19a5258f904ef62d4cc676ea1 | Fee of £75 received September 2014. Hours: 30 mins. (Registered 03 October 2014) | Employment and earnings 10057ffd | 2015-06-08 | David Lammy uk.org.publicwhip/person/10678 | 3 | 2015-06-08-10057ffd-10678-0 | |
7c3c866bc9de5909ae3bf18174b97b927aa7cbf8 | Fee of £75 received November 2014. Hours: 30 mins. (Registered 02 December 2014) | Employment and earnings 10057ffd | 2015-06-08 | David Lammy uk.org.publicwhip/person/10678 | 4 | 2015-06-08-10057ffd-10678-0 | |
2806427347df4c6778af51e5bbd53ee8e8684f0e | Fee of £75 received, March 2015. Hours: 30 mins. (Registered 26 May 2015) | Employment and earnings 10057ffd | 2015-06-08 | David Lammy uk.org.publicwhip/person/10678 | 5 | 2015-06-08-10057ffd-10678-0 | |
362069827335dc704a467491f57d71343feabc6c | Fee of £75 received April 2015. Hours: 30 mins (Registered 26 May 2015) | Employment and earnings 10057ffd | 2015-06-08 | David Lammy uk.org.publicwhip/person/10678 | 6 | 2015-06-08-10057ffd-10678-0 | |
0cd50e09ea30feaba77c0de404682746f6d67e75 | Fee from YouGov, 130 Commercial Road, Portsmouth, Hants, for opinion surveys: | Employment and earnings 10057ffd | 2015-06-08 | David Lammy uk.org.publicwhip/person/10678 | 7 | 2015-06-08-10057ffd-10678-0 | |
203888ad6fb46f45df5585f158deaad37340a355 | Fee of £80 received June 2014. Hours: 30 mins. (Registered 10 June 2014) | Employment and earnings 10057ffd | 2015-06-08 | David Lammy uk.org.publicwhip/person/10678 | 8 | 2015-06-08-10057ffd-10678-0 | |
cc84bf8f8b4f377fc75102017fa5c012ef035395 | Fees from Ipsos MORI ,9-81 Borough Road, London SE1 1FY, for opinion surveys: | Employment and earnings 10057ffd | 2015-06-08 | David Lammy uk.org.publicwhip/person/10678 | 9 | 2015-06-08-10057ffd-10678-0 | |
67dc3e5b469fe95d3f4d1b766210c6c9527cc11e | September 2014, fee of £200. Hours 1 hr. (Registered 23 September 2014) | Employment and earnings 10057ffd | 2015-06-08 | David Lammy uk.org.publicwhip/person/10678 | 10 | 2015-06-08-10057ffd-10678-0 | |
7c674a8a68a40420f8aa814d825e14e4893f2523 | Payments for articles from Guardian News and Media Limited, PO Box 68164, Kings Place, 90 York Way, London N1P 2AP: | Employment and earnings 10057ffd | 2015-06-08 | David Lammy uk.org.publicwhip/person/10678 | 11 | 2015-06-08-10057ffd-10678-0 | |
495acd35db2f9aeaf6fcbc4f56a59d45b4f88c31 | June 2014, fee of £90 received. Hours 2 hrs. (Registered 22 October 2014) | Employment and earnings 10057ffd | 2015-06-08 | David Lammy uk.org.publicwhip/person/10678 | 12 | 2015-06-08-10057ffd-10678-0 | |
600c26fdfffe5b88636a2cafecc3892b49f31f8a | August 2014, fee of £90 received. Hours: 2 hrs. (Registered 22 October 2014) | Employment and earnings 10057ffd | 2015-06-08 | David Lammy uk.org.publicwhip/person/10678 | 13 | 2015-06-08-10057ffd-10678-0 | |
6653dad08652517040edef562401d81e514f2300 | 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 03 October 2014) | Employment and earnings 10057ffd | 2015-06-08 | David Lammy uk.org.publicwhip/person/10678 | 14 | 2015-06-08-10057ffd-10678-0 | |
c9202338ea25c1c3f1637ed09dee813e01408cc0 | Fees from BBC, PO Box 480, Manchester M14 0EL: | Employment and earnings 10057ffd | 2015-06-08 | David Lammy uk.org.publicwhip/person/10678 | 15 | 2015-06-08-10057ffd-10678-0 | |
cdca6401969e7b0431cedb3f530879b5068d05a7 | 11 May 2015, received fee of £500 for TV appearance. Hours: 2 hrs. (Registered 01 June 2015) | Employment and earnings 10057ffd | 2015-06-08 | David Lammy uk.org.publicwhip/person/10678 | 16 | 2015-06-08-10057ffd-10678-0 | |
8eda2ebc9dcdc48a939c0d8bb70817f288ad9b84 | Fees from ComRes, 4 Millbank, London SW1P 3JA, for opinion surveys: | Employment and earnings 10057ffd | 2015-07-13 | David Lammy uk.org.publicwhip/person/10678 | 0 | 2015-07-13-10057ffd-10678-0 | |
29bd6a0412cf3a70e0698fae9118cf99f62e9887 | Fee of £75 received September 2014. Hours: 30 mins. (Registered 03 October 2014) | Employment and earnings 10057ffd | 2015-07-13 | David Lammy uk.org.publicwhip/person/10678 | 1 | 2015-07-13-10057ffd-10678-0 | |
821de763aff4309ac3e3f8e710c17a1bad00e40e | Fee of £75 received November 2014. Hours: 30 mins. (Registered 02 December 2014) | Employment and earnings 10057ffd | 2015-07-13 | David Lammy uk.org.publicwhip/person/10678 | 2 | 2015-07-13-10057ffd-10678-0 | |
b13d05f99803a96b1f5359ba5dbb4a04543b2347 | Fee of £75 received, March 2015. Hours: 30 mins. (Registered 26 May 2015) | Employment and earnings 10057ffd | 2015-07-13 | David Lammy uk.org.publicwhip/person/10678 | 3 | 2015-07-13-10057ffd-10678-0 | |
80b1c66e927394d68754057488faf5344d52cdf2 | Fee of £75 received April 2015. Hours: 30 mins (Registered 26 May 2015) | Employment and earnings 10057ffd | 2015-07-13 | David Lammy uk.org.publicwhip/person/10678 | 4 | 2015-07-13-10057ffd-10678-0 | |
0c7b9e336802f2df0eceb77859a4b6748c5afe53 | Fees from Ipsos MORI ,9-81 Borough Road, London SE1 1FY, for opinion surveys: | Employment and earnings 10057ffd | 2015-07-13 | David Lammy uk.org.publicwhip/person/10678 | 5 | 2015-07-13-10057ffd-10678-0 | |
14de0099c9094f9c84f03bf42702c9558e7b53b4 | September 2014, fee of £200. Hours 1 hr. (Registered 23 September 2014) | Employment and earnings 10057ffd | 2015-07-13 | David Lammy uk.org.publicwhip/person/10678 | 6 | 2015-07-13-10057ffd-10678-0 | |
3becc581e00ebf1832e1ed509109bad320d7fbc1 | Payments for articles from Guardian News and Media Limited, PO Box 68164, Kings Place, 90 York Way, London N1P 2AP: | Employment and earnings 10057ffd | 2015-07-13 | David Lammy uk.org.publicwhip/person/10678 | 7 | 2015-07-13-10057ffd-10678-0 | |
454d862401c171647e2adec5adc3b3c281e97359 | June 2014, fee of £90 received. Hours 2 hrs. (Registered 22 October 2014) | Employment and earnings 10057ffd | 2015-07-13 | David Lammy uk.org.publicwhip/person/10678 | 8 | 2015-07-13-10057ffd-10678-0 | |
bee072cf97c56d3bcfa9b1be6910959aeacc5a7e | August 2014, fee of £90 received. Hours: 2 hrs. (Registered 22 October 2014) | Employment and earnings 10057ffd | 2015-07-13 | David Lammy uk.org.publicwhip/person/10678 | 9 | 2015-07-13-10057ffd-10678-0 | |
a8a59cac16a6b438828f8303584fab609be2d2ef | 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 03 October 2014) | Employment and earnings 10057ffd | 2015-07-13 | David Lammy uk.org.publicwhip/person/10678 | 10 | 2015-07-13-10057ffd-10678-0 | |
1e3e92c939cb58fefd6d1f71be009d84ce1dd07b | Fees from BBC, PO Box 480, Manchester M14 0EL: | Employment and earnings 10057ffd | 2015-07-13 | David Lammy uk.org.publicwhip/person/10678 | 11 | 2015-07-13-10057ffd-10678-0 | |
91b80f5bde9fdf88daeab553805726b7f76e913d | 11 May 2015, received fee of £500 for TV appearance. Hours: 2 hrs. (Registered 01 June 2015) | Employment and earnings 10057ffd | 2015-07-13 | David Lammy uk.org.publicwhip/person/10678 | 12 | 2015-07-13-10057ffd-10678-0 | |
58a2d5e2ce9dc064d38d64067b4df2c8b3a2dac9 | Fees from Ipsos MORI ,9-81 Borough Road, London SE1 1FY, for opinion surveys: | Employment and earnings 10057ffd | 2015-08-10 | David Lammy uk.org.publicwhip/person/10678 | 0 | 2015-08-10-10057ffd-10678-0 | |
6c0f5f6f65c47a7263a2936786d6dc516650f1a7 | September 2014, fee of £200. Hours 1 hr. (Registered 23 September 2014) | Employment and earnings 10057ffd | 2015-08-10 | David Lammy uk.org.publicwhip/person/10678 | 1 | 2015-08-10-10057ffd-10678-0 | |
2800966ce5dfaba29156b314cc0f2da7d57752de | Payments for articles from Guardian News and Media Limited, PO Box 68164, Kings Place, 90 York Way, London N1P 2AP: | Employment and earnings 10057ffd | 2015-08-10 | David Lammy uk.org.publicwhip/person/10678 | 2 | 2015-08-10-10057ffd-10678-0 | |
f1cadc915b7662e2f830f4b8bd4b7dc8e1b790da | June 2014, fee of £90 received. Hours 2 hrs. (Registered 22 October 2014) | Employment and earnings 10057ffd | 2015-08-10 | David Lammy uk.org.publicwhip/person/10678 | 3 | 2015-08-10-10057ffd-10678-0 | |
d208794278c4aed2f1de6e28535f91bfe2368420 | August 2014, fee of £90 received. Hours: 2 hrs. (Registered 22 October 2014) | Employment and earnings 10057ffd | 2015-08-10 | David Lammy uk.org.publicwhip/person/10678 | 4 | 2015-08-10-10057ffd-10678-0 | |
3629e39125916769d71b6ffb567c3b9ac7e56ce6 | 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 03 October 2014) | Employment and earnings 10057ffd | 2015-08-10 | David Lammy uk.org.publicwhip/person/10678 | 5 | 2015-08-10-10057ffd-10678-0 | |
072fda8bf84623b6dc4424155d8c8142f97a2631 | Fees from BBC, PO Box 480, Manchester M14 0EL: | Employment and earnings 10057ffd | 2015-08-10 | David Lammy uk.org.publicwhip/person/10678 | 6 | 2015-08-10-10057ffd-10678-0 | |
9e2015572b4e2b893808022a975af05799effa17 | 11 May 2015, received fee of £500 for TV appearance. Hours: 2 hrs. (Registered 01 June 2015) | Employment and earnings 10057ffd | 2015-08-10 | David Lammy uk.org.publicwhip/person/10678 | 7 | 2015-08-10-10057ffd-10678-0 | |
53422f142b61bc3ab43030cdcf0681f863d0a499 | Fees from Ipsos MORI ,9-81 Borough Road, London SE1 1FY, for opinion surveys: | Employment and earnings 10057ffd | 2015-09-07 | David Lammy uk.org.publicwhip/person/10678 | 0 | 2015-09-07-10057ffd-10678-0 | |
d3476d85c59ee1ad8f09fce3b74a4f66a861dac7 | September 2014, fee of £200. Hours 1 hr. (Registered 23 September 2014) | Employment and earnings 10057ffd | 2015-09-07 | David Lammy uk.org.publicwhip/person/10678 | 1 | 2015-09-07-10057ffd-10678-0 | |
79f28aab3a936fae2884727f465fd2d2d20ec2f9 | Payments for articles from Guardian News and Media Limited, PO Box 68164, Kings Place, 90 York Way, London N1P 2AP: | Employment and earnings 10057ffd | 2015-09-07 | David Lammy uk.org.publicwhip/person/10678 | 2 | 2015-09-07-10057ffd-10678-0 | |
b088bff9da77c3e0c6412ddc9a56bbc69ae66ecf | June 2014, fee of £90 received. Hours 2 hrs. (Registered 22 October 2014) | Employment and earnings 10057ffd | 2015-09-07 | David Lammy uk.org.publicwhip/person/10678 | 3 | 2015-09-07-10057ffd-10678-0 | |
020e65525b4ba1457bbf8e084b949cb6d0734f62 | August 2014, fee of £90 received. Hours: 2 hrs. (Registered 22 October 2014) | Employment and earnings 10057ffd | 2015-09-07 | David Lammy uk.org.publicwhip/person/10678 | 4 | 2015-09-07-10057ffd-10678-0 | |
f45bee75951c836f6bd04b3995b5075d351958d4 | 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 03 October 2014) | Employment and earnings 10057ffd | 2015-09-07 | David Lammy uk.org.publicwhip/person/10678 | 5 | 2015-09-07-10057ffd-10678-0 | |
0a4b0919c105fbe73d0c16838b58c2a72139fa4f | Fees from BBC, PO Box 480, Manchester M14 0EL: | Employment and earnings 10057ffd | 2015-09-07 | David Lammy uk.org.publicwhip/person/10678 | 6 | 2015-09-07-10057ffd-10678-0 | |
6da42280dafe64c207e4fe9d37c2c94eacecec0a | 11 May 2015, received fee of £500 for TV appearance. Hours: 2 hrs. (Registered 01 June 2015) | Employment and earnings 10057ffd | 2015-09-07 | David Lammy uk.org.publicwhip/person/10678 | 7 | 2015-09-07-10057ffd-10678-0 | |
d59c1fd7e259d076fd9e1b3239c8264b8a15dce9 | 18 June 2015, received fee of £500 for TV appearance. Hours: 2 hrs. (Registered 14 August 2015) | Employment and earnings 10057ffd | 2015-09-07 | David Lammy uk.org.publicwhip/person/10678 | 8 | 2015-09-07-10057ffd-10678-0 | |
3b7072d0ad7aab67df4316451153644c9979ecb7 | Fees from Ipsos MORI ,9-81 Borough Road, London SE1 1FY, for opinion surveys: | Employment and earnings 10057ffd | 2015-09-28 | David Lammy uk.org.publicwhip/person/10678 | 0 | 2015-09-28-10057ffd-10678-0 | |
7b13340e4d14f562aff423720b9d5ccbff2c28e3 | September 2014, fee of £200. Hours 1 hr. (Registered 23 September 2014) | Employment and earnings 10057ffd | 2015-09-28 | David Lammy uk.org.publicwhip/person/10678 | 1 | 2015-09-28-10057ffd-10678-0 | |
d86f5a91103eebabbe70b36cf9d826f1accd7044 | Payments for articles from Guardian News and Media Limited, PO Box 68164, Kings Place, 90 York Way, London N1P 2AP: | Employment and earnings 10057ffd | 2015-09-28 | David Lammy uk.org.publicwhip/person/10678 | 2 | 2015-09-28-10057ffd-10678-0 | |
5978958069811c6bb833eb472f8dbd7a2037bb58 | June 2014, fee of £90 received. Hours 2 hrs. (Registered 22 October 2014) | Employment and earnings 10057ffd | 2015-09-28 | David Lammy uk.org.publicwhip/person/10678 | 3 | 2015-09-28-10057ffd-10678-0 | |
38234ffa67f826e287342094c9d83562d61f45ec | August 2014, fee of £90 received. Hours: 2 hrs. (Registered 22 October 2014) | Employment and earnings 10057ffd | 2015-09-28 | David Lammy uk.org.publicwhip/person/10678 | 4 | 2015-09-28-10057ffd-10678-0 | |
c0c3296738db1674669cac39dfdba714dd67c8d8 | 27 August 2015, fee of £90 received. Hours 2 hrs. (Registered 28 September 2015) | Employment and earnings 10057ffd | 2015-09-28 | David Lammy uk.org.publicwhip/person/10678 | 5 | 2015-09-28-10057ffd-10678-0 | |
f4810c957ef37bfd93a6b986a9751c2b12a0c5f5 | 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 03 October 2014) | Employment and earnings 10057ffd | 2015-09-28 | David Lammy uk.org.publicwhip/person/10678 | 6 | 2015-09-28-10057ffd-10678-0 | |
950acf82eefd78dcf126387f4fa265cea3079f55 | Fees from BBC, PO Box 480, Manchester M14 0EL: | Employment and earnings 10057ffd | 2015-09-28 | David Lammy uk.org.publicwhip/person/10678 | 7 | 2015-09-28-10057ffd-10678-0 | |
e3cc0d7dce10fbcda7e7cf41a81d658cf9d47fa2 | 11 May 2015, received fee of £500 for TV appearance. Hours: 2 hrs. (Registered 01 June 2015) | Employment and earnings 10057ffd | 2015-09-28 | David Lammy uk.org.publicwhip/person/10678 | 8 | 2015-09-28-10057ffd-10678-0 | |
7deb2670bf2054165b48ac0b02de38d3e0b7af42 | 18 June 2015, received fee of £500 for TV appearance. Hours: 2 hrs. (Registered 14 August 2015) | Employment and earnings 10057ffd | 2015-09-28 | David Lammy uk.org.publicwhip/person/10678 | 9 | 2015-09-28-10057ffd-10678-0 | |
7cb99fceca7ad336aee886e03fbd89e50cb376e6 | Payments for articles from Guardian News and Media Limited, PO Box 68164, Kings Place, 90 York Way, London N1P 2AP: | Employment and earnings 10057ffd | 2015-10-12 | David Lammy uk.org.publicwhip/person/10678 | 0 | 2015-10-12-10057ffd-10678-0 | |
ec41b10b75f44cee3edae4b27ad9763d53bacebd | June 2014, fee of £90 received. Hours 2 hrs. (Registered 22 October 2014) | Employment and earnings 10057ffd | 2015-10-12 | David Lammy uk.org.publicwhip/person/10678 | 1 | 2015-10-12-10057ffd-10678-0 | |
8f8d86e0aea26730614e2020285c01719e905fd0 | August 2014, fee of £90 received. Hours: 2 hrs. (Registered 22 October 2014) | Employment and earnings 10057ffd | 2015-10-12 | David Lammy uk.org.publicwhip/person/10678 | 2 | 2015-10-12-10057ffd-10678-0 | |
3ea02a9771e397761c471352b9c16699a4ff0073 | 27 August 2015, fee of £90 received. Hours 2 hrs. (Registered 28 September 2015) | Employment and earnings 10057ffd | 2015-10-12 | David Lammy uk.org.publicwhip/person/10678 | 3 | 2015-10-12-10057ffd-10678-0 | |
2e7b2e37d0d35821f08e19f43b50ab3dfc777b3c | 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 03 October 2014) | Employment and earnings 10057ffd | 2015-10-12 | David Lammy uk.org.publicwhip/person/10678 | 4 | 2015-10-12-10057ffd-10678-0 | |
5da652f3683f52b046362d57968503e2dfb16c05 | Fees from BBC, PO Box 480, Manchester M14 0EL: | Employment and earnings 10057ffd | 2015-10-12 | David Lammy uk.org.publicwhip/person/10678 | 5 | 2015-10-12-10057ffd-10678-0 | |
9d6833b9f76a978e731a955cea0870bc8854eac7 | 11 May 2015, received fee of £500 for TV appearance. Hours: 2 hrs. (Registered 01 June 2015) | Employment and earnings 10057ffd | 2015-10-12 | David Lammy uk.org.publicwhip/person/10678 | 6 | 2015-10-12-10057ffd-10678-0 | |
a0bc3cc2576a1a111ddf2ee6586845c326adcc7e | 18 June 2015, received fee of £500 for TV appearance. Hours: 2 hrs. (Registered 14 August 2015) | Employment and earnings 10057ffd | 2015-10-12 | David Lammy uk.org.publicwhip/person/10678 | 7 | 2015-10-12-10057ffd-10678-0 | |
ffb566cfa1e75bd4a73669c523fb03f589e87d85 | Payments for articles from Guardian News and Media Limited, PO Box 68164, Kings Place, 90 York Way, London N1P 2AP: | Employment and earnings 10057ffd | 2015-10-26 | David Lammy uk.org.publicwhip/person/10678 | 0 | 2015-10-26-10057ffd-10678-0 | |
4286518a96ab438812f001c436a804f68a784ad6 | June 2014, fee of £90 received. Hours 2 hrs. (Registered 22 October 2014) | Employment and earnings 10057ffd | 2015-10-26 | David Lammy uk.org.publicwhip/person/10678 | 1 | 2015-10-26-10057ffd-10678-0 | |
92e899c42c191b0ca47c750e1276cc98d9728476 | August 2014, fee of £90 received. Hours: 2 hrs. (Registered 22 October 2014) | Employment and earnings 10057ffd | 2015-10-26 | David Lammy uk.org.publicwhip/person/10678 | 2 | 2015-10-26-10057ffd-10678-0 | |
4de62a824aed99c5031af95a19b2ab337f59ffc1 | 27 August 2015, fee of £90 received. Hours 2 hrs. (Registered 28 September 2015) | Employment and earnings 10057ffd | 2015-10-26 | David Lammy uk.org.publicwhip/person/10678 | 3 | 2015-10-26-10057ffd-10678-0 | |
30d03eeb0635ec664f6e47949770008a7d487e96 | 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 03 October 2014) | Employment and earnings 10057ffd | 2015-10-26 | David Lammy uk.org.publicwhip/person/10678 | 4 | 2015-10-26-10057ffd-10678-0 | |
06d03c01729a280e2fcd83d08c3f5effa01dadbd | Fees from BBC, PO Box 480, Manchester M14 0EL: | Employment and earnings 10057ffd | 2015-10-26 | David Lammy uk.org.publicwhip/person/10678 | 0 | 2015-10-26-10057ffd-10678-1 | |
76a8d39853f6a3b0222000cca95dee4cb2dc9c42 | 11 May 2015, received fee of £500 for TV appearance. Hours: 2 hrs. (Registered 01 June 2015) | Employment and earnings 10057ffd | 2015-10-26 | David Lammy uk.org.publicwhip/person/10678 | 1 | 2015-10-26-10057ffd-10678-1 | |
b40bd1da1fedbe0c05b464c215e2c08945364021 | 18 June 2015, received fee of £500 for TV appearance. Hours: 2 hrs. (Registered 14 August 2015) | Employment and earnings 10057ffd | 2015-10-26 | David Lammy uk.org.publicwhip/person/10678 | 2 | 2015-10-26-10057ffd-10678-1 | |
e4d5558f6ad809cd80310d2889799116a34fa409 | Payments for articles from Guardian News and Media Limited, PO Box 68164, Kings Place, 90 York Way, London N1P 2AP: | Employment and earnings 10057ffd | 2015-11-09 | David Lammy uk.org.publicwhip/person/10678 | 0 | 2015-11-09-10057ffd-10678-0 | |
dfd75e2f948a238304462eb80c1847fe6d82470c | 27 August 2015, fee of £90 received. Hours 2 hrs. (Registered 28 September 2015) | Employment and earnings 10057ffd | 2015-11-09 | David Lammy uk.org.publicwhip/person/10678 | 1 | 2015-11-09-10057ffd-10678-0 | |
af9fec8aa34c7c883089bd30b70ae0fe5b85c52e | Fees from BBC, PO Box 480, Manchester M14 0EL: | Employment and earnings 10057ffd | 2015-11-09 | David Lammy uk.org.publicwhip/person/10678 | 2 | 2015-11-09-10057ffd-10678-0 | |
bbb2bd31afaaed11a336486e89665b85ef866227 | 11 May 2015, received fee of £500 for TV appearance. Hours: 2 hrs. (Registered 01 June 2015) | Employment and earnings 10057ffd | 2015-11-09 | David Lammy uk.org.publicwhip/person/10678 | 3 | 2015-11-09-10057ffd-10678-0 | |
d9ef027e0d5f5412c9c25b9d8c2899f8c2cce890 | 18 June 2015, received fee of £500 for TV appearance. Hours: 2 hrs. (Registered 14 August 2015) | Employment and earnings 10057ffd | 2015-11-09 | David Lammy uk.org.publicwhip/person/10678 | 4 | 2015-11-09-10057ffd-10678-0 | |
f3fa77989b70bfa49705b4a5e59d2c289fa3d497 | Payments for articles from Guardian News and Media Limited, PO Box 68164, Kings Place, 90 York Way, London N1P 2AP: | Employment and earnings 10057ffd | 2015-11-30 | David Lammy uk.org.publicwhip/person/10678 | 0 | 2015-11-30-10057ffd-10678-0 | |
6e3b3fd6863467594568ea11e78b47fc49ef67d3 | 27 August 2015, fee of £90 received. Hours 2 hrs. (Registered 28 September 2015) | Employment and earnings 10057ffd | 2015-11-30 | David Lammy uk.org.publicwhip/person/10678 | 1 | 2015-11-30-10057ffd-10678-0 | |
5c11b284bb2a1d6d874f4fa54cf888f853ecd9ec | Fees from BBC, PO Box 480, Manchester M14 0EL: | Employment and earnings 10057ffd | 2015-11-30 | David Lammy uk.org.publicwhip/person/10678 | 2 | 2015-11-30-10057ffd-10678-0 | |
ad6cbf9e1088cce64d880b26f9e966f919cd1b93 | 11 May 2015, received fee of £500 for TV appearance. Hours: 2 hrs. (Registered 01 June 2015) | Employment and earnings 10057ffd | 2015-11-30 | David Lammy uk.org.publicwhip/person/10678 | 3 | 2015-11-30-10057ffd-10678-0 | |
121373090c92d15bfd834533149a1bf0a515ee14 | 18 June 2015, received fee of £500 for TV appearance. Hours: 2 hrs. (Registered 14 August 2015) | Employment and earnings 10057ffd | 2015-11-30 | David Lammy uk.org.publicwhip/person/10678 | 4 | 2015-11-30-10057ffd-10678-0 | |
e756a83b1d392ac4fe9c118eae20b9ac02322437 | Payments for articles from Guardian News and Media Limited, PO Box 68164, Kings Place, 90 York Way, London N1P 2AP: | Employment and earnings 10057ffd | 2015-12-14 | David Lammy uk.org.publicwhip/person/10678 | 0 | 2015-12-14-10057ffd-10678-0 | |
5dd993d444cc9c231ec1e4c51dac95a1b730e10d | 27 August 2015, fee of £90 received. Hours 2 hrs. (Registered 28 September 2015) | Employment and earnings 10057ffd | 2015-12-14 | David Lammy uk.org.publicwhip/person/10678 | 1 | 2015-12-14-10057ffd-10678-0 | |
37f522a96b4ccdc72944fed1936f0f4bb472063c | Fees from BBC, PO Box 480, Manchester M14 0EL: | Employment and earnings 10057ffd | 2015-12-14 | David Lammy uk.org.publicwhip/person/10678 | 2 | 2015-12-14-10057ffd-10678-0 | |
8354fb60255a94e89d322f61660ba572db639ed4 | 11 May 2015, received fee of £500 for TV appearance. Hours: 2 hrs. (Registered 01 June 2015) | Employment and earnings 10057ffd | 2015-12-14 | David Lammy uk.org.publicwhip/person/10678 | 3 | 2015-12-14-10057ffd-10678-0 | |
4f74976a43c354a45bc15a578f354528f30dd8f9 | 18 June 2015, received fee of £500 for TV appearance. Hours: 2 hrs. (Registered 14 August 2015) | Employment and earnings 10057ffd | 2015-12-14 | David Lammy uk.org.publicwhip/person/10678 | 4 | 2015-12-14-10057ffd-10678-0 | |
bab24d98a1bb449ab3486e596e6ee5d1c55e9ef6 | Payments for articles from Guardian News and Media Limited, PO Box 68164, Kings Place, 90 York Way, London N1P 2AP: | Employment and earnings 10057ffd | 2016-01-11 | David Lammy uk.org.publicwhip/person/10678 | 0 | 2016-01-11-10057ffd-10678-0 | |
75b9806e8899be5c46b056d8334bd5aca73f4fd4 | 27 August 2015, fee of £90 received. Hours 2 hrs. (Registered 28 September 2015) | Employment and earnings 10057ffd | 2016-01-11 | David Lammy uk.org.publicwhip/person/10678 | 1 | 2016-01-11-10057ffd-10678-0 | |
023076b27d3a40a093016fa6957ee8ce0dc13364 | Fees from BBC, PO Box 480, Manchester M14 0EL: | Employment and earnings 10057ffd | 2016-01-11 | David Lammy uk.org.publicwhip/person/10678 | 2 | 2016-01-11-10057ffd-10678-0 | |
6860780dd5abb411bf8c92f430997364fd5a8a39 | 11 May 2015, received fee of £500 for TV appearance. Hours: 2 hrs. (Registered 01 June 2015) | Employment and earnings 10057ffd | 2016-01-11 | David Lammy uk.org.publicwhip/person/10678 | 3 | 2016-01-11-10057ffd-10678-0 | |
c4dc6e247ff59023607eef85082e504f44efa991 | 18 June 2015, received fee of £500 for TV appearance. Hours: 2 hrs. (Registered 14 August 2015) | Employment and earnings 10057ffd | 2016-01-11 | David Lammy uk.org.publicwhip/person/10678 | 4 | 2016-01-11-10057ffd-10678-0 | |
b79bd826f459db13a1f055663258113d636a6759 | 10 December 2015, received fee of £500 for TV appearance. Hours: 2 hrs. (Registered 15 December 2015) | Employment and earnings 10057ffd | 2016-01-11 | David Lammy uk.org.publicwhip/person/10678 | 5 | 2016-01-11-10057ffd-10678-0 | |
5521d8c0413fa7c3084869539596ca300e448858 | 1 December 2015, received fee of £1,000 from Studio Sixty Billion, 16 Shorts Gardens, London WC2H 9AU, for appearance on a TV panel show. Hours 2 hrs. (Registered 07 January 2016) | Employment and earnings 10057ffd | 2016-01-11 | David Lammy uk.org.publicwhip/person/10678 | 6 | 2016-01-11-10057ffd-10678-0 | |
7631aed6f50b0463c9a8be5aa1a7f8da547eef44 | Payments for articles from Guardian News and Media Limited, PO Box 68164, Kings Place, 90 York Way, London N1P 2AP: | Employment and earnings 10057ffd | 2016-01-25 | David Lammy uk.org.publicwhip/person/10678 | 0 | 2016-01-25-10057ffd-10678-0 | |
1d93ce693cff950ea4ce6b3fee1701a37d492732 | 27 August 2015, fee of £90 received. Hours 2 hrs. (Registered 28 September 2015) | Employment and earnings 10057ffd | 2016-01-25 | David Lammy uk.org.publicwhip/person/10678 | 1 | 2016-01-25-10057ffd-10678-0 | |
f6ce52d0635799429957871f04a80cda6ebb3ad6 | Fees from BBC, PO Box 480, Manchester M14 0EL: | Employment and earnings 10057ffd | 2016-01-25 | David Lammy uk.org.publicwhip/person/10678 | 2 | 2016-01-25-10057ffd-10678-0 | |
fd07f0efd602d873dce15901861e21b4225f219b | 11 May 2015, received fee of £500 for TV appearance. Hours: 2 hrs. (Registered 01 June 2015) | Employment and earnings 10057ffd | 2016-01-25 | David Lammy uk.org.publicwhip/person/10678 | 3 | 2016-01-25-10057ffd-10678-0 | |
cb5cf5dc478a15cba7990ea0031afdda3ceaa3da | 18 June 2015, received fee of £500 for TV appearance. Hours: 2 hrs. (Registered 14 August 2015) | Employment and earnings 10057ffd | 2016-01-25 | David Lammy uk.org.publicwhip/person/10678 | 4 | 2016-01-25-10057ffd-10678-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");