items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
13 rows where record_id = "2017-02-20-10057ffd-10180-0" sorted by sort_order descending
This data as json, CSV (advanced)
date (date) 1 ✖
- 2017-02-20 13
hash | item | category_id | date | member_id | person_id | sort_order ▲ | record_id |
---|---|---|---|---|---|---|---|
e3b0ace4225deaa2aee0c10daa100f2bfde19eaa | 16 December 2016, received £5,000 from Leicester Tigers Rugby Club, Aylestone Road, Leicester LE2 7TR. Hours: 4 hrs. (Registered 23 December 2016) | Employment and earnings 10057ffd | 2017-02-20 | Iain Duncan Smith uk.org.publicwhip/person/10180 | 12 | 2017-02-20-10057ffd-10180-0 | |
344ac65c2c8fee69308ca3408ba9967adad36cca | Payment for speaking engagement received via Champions (Loughborough), Barrington House, Leake Road Costock, Loughborough LE12 6XA: | Employment and earnings 10057ffd | 2017-02-20 | Iain Duncan Smith uk.org.publicwhip/person/10180 | 11 | 2017-02-20-10057ffd-10180-0 | |
82be7505555c41ccec428675bdeb52a08a7027ab | 15 December 2016, received £6,280 from 2Plan Wealth Management Ltd., Bridgewater Place, Water Lane, Leeds, LS11 5BZ. Hours: 5 hrs. (Registered 23 December 2016) | Employment and earnings 10057ffd | 2017-02-20 | Iain Duncan Smith uk.org.publicwhip/person/10180 | 10 | 2017-02-20-10057ffd-10180-0 | |
6fc04c9482f68396f2225423665aee1a968e8f4c | Payment for speaking engagement received via London Speaker Bureau (London), 235 Kensington High Street, Kensington W8 6SF: | Employment and earnings 10057ffd | 2017-02-20 | Iain Duncan Smith uk.org.publicwhip/person/10180 | 9 | 2017-02-20-10057ffd-10180-0 | |
3e0955ba41df04c1b9cc62f3497723cd4a7f0c64 | 21 December 2016, received £500. Hours: 2 hrs. (Registered 23 December 2016) | Employment and earnings 10057ffd | 2017-02-20 | Iain Duncan Smith uk.org.publicwhip/person/10180 | 8 | 2017-02-20-10057ffd-10180-0 | |
5238c7f8a10a3f47433151e602ac2276dcb9220f | 30 November 2016, received £500. Hours: 2 hrs. (Registered 23 December 2016) | Employment and earnings 10057ffd | 2017-02-20 | Iain Duncan Smith uk.org.publicwhip/person/10180 | 7 | 2017-02-20-10057ffd-10180-0 | |
bebb41aeeaabdb1ee100376f77258f825336ffcc | 9 November 2016, received £250. Hours: 1 hr. (Registered 24 November 2016) | Employment and earnings 10057ffd | 2017-02-20 | Iain Duncan Smith uk.org.publicwhip/person/10180 | 6 | 2017-02-20-10057ffd-10180-0 | |
328bfa220bb34b118359e6d347ada8acfdbd9419 | 28 September 2016, received £700. Hours: 2 hrs. (Registered 24 November 2016) | Employment and earnings 10057ffd | 2017-02-20 | Iain Duncan Smith uk.org.publicwhip/person/10180 | 5 | 2017-02-20-10057ffd-10180-0 | |
0352291127b341e6765b080d9666dd039f34b868 | Payments for articles in the Sun Newspaper, 1 London Bridge Street, London SE1 9GF: | Employment and earnings 10057ffd | 2017-02-20 | Iain Duncan Smith uk.org.publicwhip/person/10180 | 4 | 2017-02-20-10057ffd-10180-0 | |
628bb02edd9e2731f2b876d2b43c1224e928548e | 15 June 2016, received £1,000 received from YouGov, 50 Featherstone Street, London EC1Y 8RT, for a speaking engagement. Hours: 4 hrs. (Registered 24 November 2016) | Employment and earnings 10057ffd | 2017-02-20 | Iain Duncan Smith uk.org.publicwhip/person/10180 | 3 | 2017-02-20-10057ffd-10180-0 | |
44086b55544afa333d07f89df1f92637dc30efc7 | 31 October 2016, received £2,500 from Scottish Widows Bank, PO BOX 12757, 67 Morrison Street, Edinburgh EH3 8YJ. Hours: 5 hrs. (Registered 24 November 2016) | Employment and earnings 10057ffd | 2017-02-20 | Iain Duncan Smith uk.org.publicwhip/person/10180 | 2 | 2017-02-20-10057ffd-10180-0 | |
a02b2c9fd9e0badec376f4233d7480175649e016 | 31 October 2016, received £2,000 from Target Jobs, GTI Media Ltd, The Foundation Building, Howbery Park, Benson Lane, Wallingford, Oxfordshire OX10 8BA. Hours: 4 hrs. (Registered 24 November 2016) | Employment and earnings 10057ffd | 2017-02-20 | Iain Duncan Smith uk.org.publicwhip/person/10180 | 1 | 2017-02-20-10057ffd-10180-0 | |
d10b925de759b407fd438db0e6996b082b632c41 | Payments for speaking engagement received via Speakers Corner (London) Ltd, Unit 31, Highbury Studios, 10 Hornsey Street, London N7 8EL: | Employment and earnings 10057ffd | 2017-02-20 | Iain Duncan Smith uk.org.publicwhip/person/10180 | 0 | 2017-02-20-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");