items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
35 rows where record_id = "2018-02-19-10057ffd-10180-0" sorted by category_id
This data as json, CSV (advanced)
date (date) 1 ✖
- 2018-02-19 35
hash | item | category_id ▼ | date | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
ab063824ee8b6db2fe27f8f287a6b6527ec5f788 | Payments for articles in the Sun Newspaper, 1 London Bridge Street, London SE1 9GF: | Employment and earnings 10057ffd | 2018-02-19 | Iain Duncan Smith uk.org.publicwhip/person/10180 | 0 | 2018-02-19-10057ffd-10180-0 | |
07d83354eb132f51e59300b773408e7f6caee247 | 29 March 2017, received £500. Hours: 2 hrs. (Registered 19 April 2017) | Employment and earnings 10057ffd | 2018-02-19 | Iain Duncan Smith uk.org.publicwhip/person/10180 | 1 | 2018-02-19-10057ffd-10180-0 | |
b06bd150e6123903e863fc7afb0be682b1f76cf7 | 25 January 2017, received £750 for an article. Hours: 2 hrs. (Registered 21 April 2017) | Employment and earnings 10057ffd | 2018-02-19 | Iain Duncan Smith uk.org.publicwhip/person/10180 | 2 | 2018-02-19-10057ffd-10180-0 | |
66b40e4ba0d0551f1c3331720ee16aa3465a7ef9 | 1 November 2017, received £500. Hours: 2 hrs. (Registered 24 November 2017) | Employment and earnings 10057ffd | 2018-02-19 | Iain Duncan Smith uk.org.publicwhip/person/10180 | 3 | 2018-02-19-10057ffd-10180-0 | |
199aa53c031f028b8e4024bbb99090d4f1b14e19 | 17 January 2018, received £400 for an article. Hours: 4 hrs. (Registered 18 January 2018) | Employment and earnings 10057ffd | 2018-02-19 | Iain Duncan Smith uk.org.publicwhip/person/10180 | 4 | 2018-02-19-10057ffd-10180-0 | |
6a3022da948da216c91b280b810146e39366c82e | Payment for speaking engagements received via London Speaker Bureau (London), 235 Kensington High Street, Kensington W8 6SF: | Employment and earnings 10057ffd | 2018-02-19 | Iain Duncan Smith uk.org.publicwhip/person/10180 | 5 | 2018-02-19-10057ffd-10180-0 | |
6b03720ae4f7dc03a6755472f2ec69d3f9a3248c | 25 April 2017, received £4,000 from Mallow Street, 125 Old Broad Street, 26th Floor, London EC2N 1AR. Hours: 3 hrs. (Registered 16 June 2017) | Employment and earnings 10057ffd | 2018-02-19 | Iain Duncan Smith uk.org.publicwhip/person/10180 | 6 | 2018-02-19-10057ffd-10180-0 | |
16fa2ee0dd9c791fc0e21393eb11a61d0cd28e65 | 25 May 2017, received £4,000 plus expenses from Retail Week, 33 Kingsway, London WC2B 6UF, for a speech delivered on 10 May 2017. Hours: 4 hrs. (Registered 16 June 2017) | Employment and earnings 10057ffd | 2018-02-19 | Iain Duncan Smith uk.org.publicwhip/person/10180 | 7 | 2018-02-19-10057ffd-10180-0 | |
e4d7900e30d6d81b9eb12636c3b493a220dd5fc8 | 25 April 2017, received £4,000 from Mallowstreet, Austin Friars House, 2-6 Austin Friars, London EC2N 2HD, for a speaking engagement on 28 March 2017. Hours: 4 hrs. (Registered 28 July 2017) | Employment and earnings 10057ffd | 2018-02-19 | Iain Duncan Smith uk.org.publicwhip/person/10180 | 8 | 2018-02-19-10057ffd-10180-0 | |
9af60e704c07fd1eb1c2df57be236b7c7ea94060 | 29 June 2017, received £4,000 from the National Landlord Investment Show, 27 Stafford Road, Croydon CR0 4NG, for a speaking engagement on 15 June 2017. Hours: 4 hrs. (Registered 28 July 2017) | Employment and earnings 10057ffd | 2018-02-19 | Iain Duncan Smith uk.org.publicwhip/person/10180 | 9 | 2018-02-19-10057ffd-10180-0 | |
f7922d66d5ad1a29a93774d15d4f6993c319eaef | 18 September 2017, received £4,000 from Aktar Group, 160 City Road, London EC1V 2NX. Hours: 2 hrs. (Registered 10 October 2017) | Employment and earnings 10057ffd | 2018-02-19 | Iain Duncan Smith uk.org.publicwhip/person/10180 | 10 | 2018-02-19-10057ffd-10180-0 | |
30dc1199de99e87cfc80cc95eadd754a1c9363b7 | 29 November 2017, received £4,000 from the National Landlord Investment Show, 27 Stafford Road, Croydon CR0 4NG, for a speaking engagement on 7 November 2017. Hours: 4 hrs. (Registered 05 February 2018) | Employment and earnings 10057ffd | 2018-02-19 | Iain Duncan Smith uk.org.publicwhip/person/10180 | 11 | 2018-02-19-10057ffd-10180-0 | |
ccbbc47323bde7f3975b434cba6379b2a4fa080d | Payment for speaking engagement received via Champions (Loughborough), Barrington House, Leake Road Costock, Loughborough LE12 6XA: | Employment and earnings 10057ffd | 2018-02-19 | Iain Duncan Smith uk.org.publicwhip/person/10180 | 12 | 2018-02-19-10057ffd-10180-0 | |
4cc58209a2ff831fa4fd2eb4273531ee1193f3b0 | 24 February 2017, received £4,000 from Fisher Energy Plc, 16 North Mills, Leicester LE3 5DL, for a speaking engagement on 19 January 2017. Hours: 4 hrs. (Registered 21 April 2017; updated 05 September 2017) | Employment and earnings 10057ffd | 2018-02-19 | Iain Duncan Smith uk.org.publicwhip/person/10180 | 13 | 2018-02-19-10057ffd-10180-0 | |
6b421ae8165c0dd2c2ee1d9ab6739bab5ccdfcc8 | 11 August 2017, received £4,000 plus travel expenses from Oxygen Finance, 42-44 Waterloo Street, Birmingham B2 5QB, for a speaking engagement on 5 July 2017. Hours: 2 hrs. (Registered 04 September 2017) | Employment and earnings 10057ffd | 2018-02-19 | Iain Duncan Smith uk.org.publicwhip/person/10180 | 14 | 2018-02-19-10057ffd-10180-0 | |
2ba4123be89583cb7475d5f8e89e940063aa3581 | Payments for articles in The Daily Mail, 2 Derry Street, London W8 5TT: | Employment and earnings 10057ffd | 2018-02-19 | Iain Duncan Smith uk.org.publicwhip/person/10180 | 15 | 2018-02-19-10057ffd-10180-0 | |
aa2844e4e2656eaef096b5cf33dbf904dea9df8e | 25 January 2017, received £750 for an article. Hours: 2 hrs. (Registered 22 February 2017) | Employment and earnings 10057ffd | 2018-02-19 | Iain Duncan Smith uk.org.publicwhip/person/10180 | 16 | 2018-02-19-10057ffd-10180-0 | |
89ca3280155623804da278fc467d398ca811e7e2 | 18 January 2017, received £1,600 for two articles (£800 each). Hours: 4 hrs in total. (Registered 21 April 2017) | Employment and earnings 10057ffd | 2018-02-19 | Iain Duncan Smith uk.org.publicwhip/person/10180 | 17 | 2018-02-19-10057ffd-10180-0 | |
0072504b59aefcf99623e252b64a79bf78d803d2 | 6 July 2017, received £900 for an article. Hours: 4 hrs. (Registered 12 July 2017) | Employment and earnings 10057ffd | 2018-02-19 | Iain Duncan Smith uk.org.publicwhip/person/10180 | 18 | 2018-02-19-10057ffd-10180-0 | |
7ee36270247344a456efb8cf1da42071664d4007 | Payment of £700 expected for an article written on 20 October 2017. Hours: 4 hrs. (Registered 24 November 2017) | Employment and earnings 10057ffd | 2018-02-19 | Iain Duncan Smith uk.org.publicwhip/person/10180 | 19 | 2018-02-19-10057ffd-10180-0 | |
9b2260c7a340863dc75f91357e7e7d369e834931 | Payments for articles in the Daily Telegraph and Sunday Telegraph, 111 Buckingham Palace Rd, London SW1W 0DT: | Employment and earnings 10057ffd | 2018-02-19 | Iain Duncan Smith uk.org.publicwhip/person/10180 | 20 | 2018-02-19-10057ffd-10180-0 | |
e016433efaa2b153ba25678b17e2f12d8e2c9721 | 10 June 2017, received £100 for an article. Hours: 4 hrs. (Registered 12 July 2017) | Employment and earnings 10057ffd | 2018-02-19 | Iain Duncan Smith uk.org.publicwhip/person/10180 | 21 | 2018-02-19-10057ffd-10180-0 | |
43b001fba84582969f1a5bef72f580ca099125b9 | 14 June 2017, received £250 for an article. Hours: 4 hrs. (Registered 12 July 2017) | Employment and earnings 10057ffd | 2018-02-19 | Iain Duncan Smith uk.org.publicwhip/person/10180 | 22 | 2018-02-19-10057ffd-10180-0 | |
7d44d72778adaafdadef5d68c8a4acecbd3f5062 | 18 June 2017, received £270 for an article. Hours: 4 hrs. (Registered 12 July 2017) | Employment and earnings 10057ffd | 2018-02-19 | Iain Duncan Smith uk.org.publicwhip/person/10180 | 23 | 2018-02-19-10057ffd-10180-0 | |
10280ab182c396f754fe76b70276fe20d9a00ec5 | 15 December 2017, received £270 for an article. Hours: 4 hrs. (Registered 08 January 2018) | Employment and earnings 10057ffd | 2018-02-19 | Iain Duncan Smith uk.org.publicwhip/person/10180 | 24 | 2018-02-19-10057ffd-10180-0 | |
ffa2cb20250504ef6f13518db7a1912d31d2e1d1 | 22 December 2017, received £250 for an article. Hours: 4 hrs. (Registered 16 January 2018) | Employment and earnings 10057ffd | 2018-02-19 | Iain Duncan Smith uk.org.publicwhip/person/10180 | 25 | 2018-02-19-10057ffd-10180-0 | |
33588d89b56982282008f5bccdfa240e638f4a49 | 26 January 2018, received £225 for an article published on 3 December 2017. Hours: 4 hrs. (Registered 29 January 2018) | Employment and earnings 10057ffd | 2018-02-19 | Iain Duncan Smith uk.org.publicwhip/person/10180 | 26 | 2018-02-19-10057ffd-10180-0 | |
91d4d73d7304015a1aeaa3d7858e3ffb6e0ccf08 | 5 February 2018, received £250 for an article published on 23 January 2018. Hours: 4 hrs. (Registered 05 February 2018) | Employment and earnings 10057ffd | 2018-02-19 | Iain Duncan Smith uk.org.publicwhip/person/10180 | 27 | 2018-02-19-10057ffd-10180-0 | |
40dd96133b9c2ce8e6a7d06e0cf948dd7faf3609 | 12 July 2017, received £2,500 from the BBC, Broadcasting House, Portland Place, London W1A 1AA, for presenting the Jeremy Vine Show on Radio 2 between 26 and 30 June 2017 (inclusive). Hours: 30 hrs. (Registered 04 August 2017) | Employment and earnings 10057ffd | 2018-02-19 | Iain Duncan Smith uk.org.publicwhip/person/10180 | 28 | 2018-02-19-10057ffd-10180-0 | |
8c5b6a475201bd3b9b39302bc62070d0b923796a | Payments for speaking engagements received via London Authorities (London), 200 Aldersgate, London EC1A 4HD: | Employment and earnings 10057ffd | 2018-02-19 | Iain Duncan Smith uk.org.publicwhip/person/10180 | 29 | 2018-02-19-10057ffd-10180-0 | |
e7f7327f4e19e91d2fce456d21bd8d590550836d | 14 November 2017, received £5,020 from Propertydrum Ltd, PO Box 234, Uckfield TN22 9AH. Hours: 4 hrs. (Registered 24 November 2017) | Employment and earnings 10057ffd | 2018-02-19 | Iain Duncan Smith uk.org.publicwhip/person/10180 | 30 | 2018-02-19-10057ffd-10180-0 | |
3e8b978f510a36521bb295d2d08c3bc7c2f0b8f6 | 9 November 2017, received £3,500 from the National Landlord Investment Association, 27 Stafford Road, Croydon CR0 4NG, for magazine articles. Hours: 8 hrs in total. (Registered 27 November 2017) | Employment and earnings 10057ffd | 2018-02-19 | Iain Duncan Smith uk.org.publicwhip/person/10180 | 31 | 2018-02-19-10057ffd-10180-0 | |
23825d612c2c6fd34699dc43aea2aa8b05e20fbd | Payments for speaking engagements received via Speaker's Corner (London) Ltd, Unit 31, Highbury Studios, 10 Hornsey St, London N7 8EL: | Employment and earnings 10057ffd | 2018-02-19 | Iain Duncan Smith uk.org.publicwhip/person/10180 | 32 | 2018-02-19-10057ffd-10180-0 | |
19761d550653332a9f9bbd3b86a396e4d2eb70fe | 30 November 2017, received £4,750 from Insurance Insider, 3rd Floor, 41 Eastcheap, London EC3M 1DT for speaking engagement at the London Market Conference in Bishopsgate on 2 November 2017. Hours: 4 hrs. (Registered 05 February 2018) | Employment and earnings 10057ffd | 2018-02-19 | Iain Duncan Smith uk.org.publicwhip/person/10180 | 33 | 2018-02-19-10057ffd-10180-0 | |
79456a8c8a11a5c5c4905f1a9b79323eb9ee26d4 | 1 December 2017, received £4,500 from Coventry and Warwickshire Chamber of Commerce, Chamber House, Innovation Village, Cheetah Rd, Coventry CV2 1TL, for speaking engagement at the Coventry and Warwickshire Chamber of Commerce annual Business and Economic Conference on 3 November 2017. Hours: 4 hrs. (Registered 05 February 2018) | Employment and earnings 10057ffd | 2018-02-19 | Iain Duncan Smith uk.org.publicwhip/person/10180 | 34 | 2018-02-19-10057ffd-10180-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");