items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
29 rows where record_id = "2023-10-16-10057ffd-10678-0" sorted by sort_order
This data as json, CSV (advanced)
Suggested facets: date (date)
hash | item | category_id | date | member_id | person_id | sort_order ▼ | record_id |
---|---|---|---|---|---|---|---|
6bba41b2ffdb1b65b060cfb2ec4685be15ca6914 | Payments received via the Speaking Office, Unit 31 Highbury Studios, 10 Hornsey Street, London N7 8EL, for speaking engagements. (Updated 15 April 2021) | Employment and earnings 10057ffd | 2023-10-16 | David Lammy uk.org.publicwhip/person/10678 | 0 | 2023-10-16-10057ffd-10678-0 | |
55d26fc155392e236cc7b0c51d1705c7a289bd29 | 6 October 2022, received £1,200 from MRA Search Ltd, 1-3 College Hill, London EC4R 2RA, as the third instalment for speaking at an event as part of diversity and training for staff on 22 June 2022. Hours: no additional hours. (Registered 14 October 2022) | Employment and earnings 10057ffd | 2023-10-16 | David Lammy uk.org.publicwhip/person/10678 | 1 | 2023-10-16-10057ffd-10678-0 | |
741f37f41e7bb19e2a87eb0f6bb195cabaa6b916 | 16 November 2022, received £4,845 from Champions UK, Barrington House, Leake Road, Costock, Loughborough LE12 6XA, for a speech on 13 October 2022 to Lion Trust Asset Management, 2 Savoy Court, London WC2R 0EZ, for their Black History Month event. Hours 3.5 hrs including preparation. (Registered 16 November 2022; updated 22 December 2022) | Employment and earnings 10057ffd | 2023-10-16 | David Lammy uk.org.publicwhip/person/10678 | 2 | 2023-10-16-10057ffd-10678-0 | |
92651ad23d6d4ef02ba7357820881d4e2ac4885a | 30 November 2022, received £3,384.25 from NRDC, 1152 15th Street, NW Washington, DC 20005-6166, USA, for a speech on 4 November 2022. Hours: 4.5 hrs including preparation. (Registered 15 December 2022) | Employment and earnings 10057ffd | 2023-10-16 | David Lammy uk.org.publicwhip/person/10678 | 3 | 2023-10-16-10057ffd-10678-0 | |
b7bab3b573a14eaa5fdba67793267f45bdf59966 | 30 November 2022, received £1,020 from Roundhouse, Chalk Farm Road, London NW1 8EH, for a speech on 13 October 2022. Hours 3.5 hours including preparation. (Registered 15 December 2022) | Employment and earnings 10057ffd | 2023-10-16 | David Lammy uk.org.publicwhip/person/10678 | 4 | 2023-10-16-10057ffd-10678-0 | |
7cb02c60f8ad110d907fa618f379dd717e0c508b | 30 November 2022, received £3,570 from Champions UK, Barrington House, Leake Road, Costock, Loughborough LE12 6XA, for a speech for Premier Foods, Premier House, Griffiths Way, St Albans, Hertfordshire AL1 2RE on 3 October 2022. Hours: 4 hrs including preparation. (Registered 15 December 2022) | Employment and earnings 10057ffd | 2023-10-16 | David Lammy uk.org.publicwhip/person/10678 | 5 | 2023-10-16-10057ffd-10678-0 | |
32c553e3a363344c9bad65d696c1230767c84534 | 30 November 2022, received £3,570 from Champions UK, Barrington House, Leake Road, Costock, Loughborough LE12 6XA, for a speech for Hausfeld LLP, 12 Gough Square, London EC4A 3DW, on 3 November 2022. Hours: 4 hrs including preparation. (Registered 22 December 2022) | Employment and earnings 10057ffd | 2023-10-16 | David Lammy uk.org.publicwhip/person/10678 | 6 | 2023-10-16-10057ffd-10678-0 | |
fff58dc7721f69df022b35b07c3a80b85e73712b | 30 November 2022, received £5,712 from Champions UK, Barrington House, Leake Road, Costock, Loughborough LE12 6XA, for a speech for Osborne Clarke LLP, One London Wall, London EC2Y 5EB, on 13 October 2022. Hours: 4 hrs including preparation. (Registered 22 December 2022) | Employment and earnings 10057ffd | 2023-10-16 | David Lammy uk.org.publicwhip/person/10678 | 7 | 2023-10-16-10057ffd-10678-0 | |
277d6b7fa2f28a80e5d8ba51608e3f9bc1803c5d | 15 December 2022, received £5,100 from Champions UK, Barrington House, Leake Road, Costock, Loughborough, Leicestershire LE12 6XA, for a speech for the Office Agents Society, Woolgate Exchange, 25 Basinghall Street, London EC2V 5HA, on 8 November 2022. Hours: 4 hours including preparation. (Registered 22 December 2022) | Employment and earnings 10057ffd | 2023-10-16 | David Lammy uk.org.publicwhip/person/10678 | 8 | 2023-10-16-10057ffd-10678-0 | |
628ec6f64b4c7bece4e26b04dbfc09a470a390e4 | 4 January 2023, received £5,100 from Revlon International Corporation, Greater London House, Hampstead Road, London NW1 7QX, for a speech on 17 November 2022 for their Black History Month event. Hours: 4 hrs including preparation. (Registered 09 January 2023) | Employment and earnings 10057ffd | 2023-10-16 | David Lammy uk.org.publicwhip/person/10678 | 9 | 2023-10-16-10057ffd-10678-0 | |
974e6f0ae35d71cdb5b1d44db33ccbbf6c243693 | 1 February 2023, received payment of £2,040 from Equiida Ltd, 20 Red Lion Street, London WC1R 4PQ, as second 50% instalment for speaking at their event on 19 January 2023 (rescheduled from 27 October 2022). Hours: 4 hrs including preparation. (Registered 01 February 2023) | Employment and earnings 10057ffd | 2023-10-16 | David Lammy uk.org.publicwhip/person/10678 | 10 | 2023-10-16-10057ffd-10678-0 | |
35b4b93987cb10bb4fededf00473d6af4e7c7905 | 17 March 2023, received £5,100 from Simmons & Simmons, CityPoint, 1 Ropemaker St, London EC2Y 9SS, for a speaking engagement on 2 March 2023. Hours: 5 hrs including preparation. (Registered 21 March 2023) | Employment and earnings 10057ffd | 2023-10-16 | David Lammy uk.org.publicwhip/person/10678 | 11 | 2023-10-16-10057ffd-10678-0 | |
253cf2ea2248ea9755a5e5cd037ec6cbe155a5a0 | Payments from Global Radio, 30 Leicester Square, London WC2H 7LA: | Employment and earnings 10057ffd | 2023-10-16 | David Lammy uk.org.publicwhip/person/10678 | 12 | 2023-10-16-10057ffd-10678-0 | |
ae25c0db9550f9f0b4c9b8ee6d19c6bd78d71832 | 29 September 2022, received £2,572.50 via Independent Talent Group, 40 Whitfield Street, Bloomsbury, London W1T 2RH, for presenting shows on LBC on 13, 20 and 21 August 2022. Hours: 13.5 hrs in total including preparation time (4.5 hrs per show). (Registered 14 October 2022) | Employment and earnings 10057ffd | 2023-10-16 | David Lammy uk.org.publicwhip/person/10678 | 13 | 2023-10-16-10057ffd-10678-0 | |
21946b052e87ba1548ae87efc9650895b3fa53c6 | 25 October 2022, received £3,780 via Independent Talent Group, 40 Whitfield Street, Bloomsbury, London W1T 2RH, for presenting shows on LBC radio on 3, 11, 18 and 25 September 2022. Hours: 18 hours in total including preparation time (4.5 hours per show). (Registered 27 October 2022) | Employment and earnings 10057ffd | 2023-10-16 | David Lammy uk.org.publicwhip/person/10678 | 14 | 2023-10-16-10057ffd-10678-0 | |
5dbeab5d360b22b733e22073425606af565b4d81 | 25 November 2022, received £4,987.50 via Independent Talent Group, 40 Whitfield Street, Bloomsbury, London W1T 2RH, for presenting five shows on LBC on 2, 9, 16, 23 and 30 October 2022. Hours: 22.5 hrs in total including preparation time (4.5 hrs per show). (Registered 29 November 2022) | Employment and earnings 10057ffd | 2023-10-16 | David Lammy uk.org.publicwhip/person/10678 | 15 | 2023-10-16-10057ffd-10678-0 | |
b52b191d98fe46924697bd8e81f4fe5ac0d26500 | 4 January 2023, received £4,882.50 via Independent Talent Group, 40 Whitfield Street, Bloomsbury, London W1T 2RH, for presenting shows on LBC on 5, 6, 12, 13, 20 and 27 November 2022. Hours: 27 hrs in total including preparation time (4.5 hrs per show). (Registered 09 January 2023) | Employment and earnings 10057ffd | 2023-10-16 | David Lammy uk.org.publicwhip/person/10678 | 16 | 2023-10-16-10057ffd-10678-0 | |
a3a979e8f810e72541aef985cfd58790ae0e0d3c | 27 January 2023, received £1,530 via Independent Talent Group, 40 Whitfield Street, Bloomsbury, London W1T 2RH, for presenting shows on LBC on 4 and 11 December 2022. Hours: 9 hrs in total including preparation time (4.5 hrs per show). (Registered 31 January 2023) | Employment and earnings 10057ffd | 2023-10-16 | David Lammy uk.org.publicwhip/person/10678 | 17 | 2023-10-16-10057ffd-10678-0 | |
b192cb2ed7694ab75564b3fec1538189ff40f5b1 | 28 February 2023, received £360 payment of VAT via Independent Talent Group, 40 Whitfield Street, Bloomsbury, London W1T 2RH, for presenting shows on LBC on 4 and 11 December 2022. Hours: 9 hrs in total including preparation time (4.5 hrs per show). (Registered 28 February 2023) | Employment and earnings 10057ffd | 2023-10-16 | David Lammy uk.org.publicwhip/person/10678 | 18 | 2023-10-16-10057ffd-10678-0 | |
b04b69808f78de03037f00e63cb44ad718105a0b | 28 February 2023, received £4,935 via Independent Talent Group, 40 Whitfield Street, Bloomsbury, London W1T 2RH, for presenting shows on LBC on 2, 8, 15, 22 and 29 January 2023. Hours: 22.5 hrs in total including preparation time (4.5 hrs per show). (Registered 28 February 2023) | Employment and earnings 10057ffd | 2023-10-16 | David Lammy uk.org.publicwhip/person/10678 | 19 | 2023-10-16-10057ffd-10678-0 | |
5807646418cdeeac9471caeca5c1dbb485cc1ea8 | 24 March 2023, received £8,400 via Independent Talent Group, 40 Whitfield Street, Bloomsbury, London W1T 2RH, for presenting shows on LBC on 5, 12, 13, 14, 15, 16, 19 and 26 February 2023. Hours: 36 hrs in total including preparation time (4.5 hrs per show). (Registered 28 March 2023) | Employment and earnings 10057ffd | 2023-10-16 | David Lammy uk.org.publicwhip/person/10678 | 20 | 2023-10-16-10057ffd-10678-0 | |
b1b59602e72c2e951e81c6f0b6b2c316a1095843 | 27 April 2023, received £3,780 via Independent Talent Group, 40 Whitfield Street, Bloomsbury, London W1T 2RH, for presenting shows on LBC on 5, 12, 19 and 26 March 2023. Hours: 18 hrs in total including preparation time (4.5 hrs per show). (Registered 27 April 2023) | Employment and earnings 10057ffd | 2023-10-16 | David Lammy uk.org.publicwhip/person/10678 | 21 | 2023-10-16-10057ffd-10678-0 | |
ded0cdf3024c1273488e7c465d14644939f9eb14 | 26 May 2023, received £2,835 via Independent Talent Group, 40 Whitfield Street, Bloomsbury, London W1T 2RH, for presenting shows on LBC on 9, 16 and 30 April 2023. Hours: 13.5 hrs in total including preparation time (4.5 hrs per show). (Registered 01 June 2023) | Employment and earnings 10057ffd | 2023-10-16 | David Lammy uk.org.publicwhip/person/10678 | 22 | 2023-10-16-10057ffd-10678-0 | |
1d675e0db22cc00c369e5b824760416c5fb2a47e | 27 June 2023, received £8,400 via Independent Talent Group, 40 Whitfield Street, London W1T 2RH, for presenting shows on LBC on 1, 7, 8, 14, 21, 28 and 29 May 2023. Hours: 31.5 hrs in total including preparation (4.5 hrs per show). (Registered 03 July 2023) | Employment and earnings 10057ffd | 2023-10-16 | David Lammy uk.org.publicwhip/person/10678 | 23 | 2023-10-16-10057ffd-10678-0 | |
832f6efce069cad5f5f9c300b885f97ec7af8557 | 25 July 2023, received £4,935 via Independent Talent Group, 40 Whitfield Street, Bloomsbury, London W1T 2RH, for presenting seven shows on LBC on 4, 10, 11, 18 and 25 June 2023. Hours: 22.5 hrs in total including preparation time (4.5 hrs per show). (Registered 03 August 2023) | Employment and earnings 10057ffd | 2023-10-16 | David Lammy uk.org.publicwhip/person/10678 | 24 | 2023-10-16-10057ffd-10678-0 | |
f880f40ff77156b5caabd7d8750d726e196ab719 | 25 August 2023, received £9,555 via Independent Talent Group, 40 Whitfield Street, Bloomsbury, London W1T 2RH, for presenting nine shows on LBC on 2, 9, 16, 24, 25, 26, 27, 28, and 30 July 2023. Hours: 40.5 hrs in total including preparation time (4.5 hrs per show). (Registered 04 September 2023) | Employment and earnings 10057ffd | 2023-10-16 | David Lammy uk.org.publicwhip/person/10678 | 25 | 2023-10-16-10057ffd-10678-0 | |
97e551025c451511a8401c9920318a6d8a87fa7c | 26 September 2023, received £945 via Independent Talent Group, 40 Whitfield Street, Bloomsbury, London W1T 2RH, for presenting a show on LBC on 13 August 2023. Hours: 4.5 hrs in total including preparation time. (Registered 03 October 2023) | Employment and earnings 10057ffd | 2023-10-16 | David Lammy uk.org.publicwhip/person/10678 | 26 | 2023-10-16-10057ffd-10678-0 | |
773acb993bcc23d3bae254b6e62b2e1fa6f7e743 | 8 November 2022, received £1,000 speaking fee from Hampton School, Hanworth Rd, Hampton TW12 3HD, for a Q&A session with students on 4 November 2022. Hours: 2.5 hrs including preparation. Fee donated to a local charity. (Registered 23 November 2022) | Employment and earnings 10057ffd | 2023-10-16 | David Lammy uk.org.publicwhip/person/10678 | 27 | 2023-10-16-10057ffd-10678-0 | |
0d9a6dfd73d9b110a21ebb0e851898f4c174e73f | 23 May 2023, received £350 from the BBC, 2nd floor, Zone C, 1 Television Centre, 101 Wood Lane, London W12 7FA, as an appearance fee for Coronation coverage. Hours: 2 hrs. This fee will be donated to charity. (Registered 19 June 2023) | Employment and earnings 10057ffd | 2023-10-16 | David Lammy uk.org.publicwhip/person/10678 | 28 | 2023-10-16-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");