items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
10 rows where record_id = "2017-04-10-10057ffd-10180-1" 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 |
---|---|---|---|---|---|---|---|
3dd24810362e17b25dd71b59be33a249b57cae44 | Payments for articles in the Sun Newspaper, 1 London Bridge Street, London SE1 9GF: | Employment and earnings 10057ffd | 2017-04-10 | Iain Duncan Smith uk.org.publicwhip/person/10180 | 0 | 2017-04-10-10057ffd-10180-1 | |
27175cbae810e17ef838ee08e7a0eb2c36a16301 | 28 September 2016, received £700. Hours: 2 hrs. (Registered 24 November 2016) | Employment and earnings 10057ffd | 2017-04-10 | Iain Duncan Smith uk.org.publicwhip/person/10180 | 1 | 2017-04-10-10057ffd-10180-1 | |
1146c2194bc7edc742a8a0297eaa51c455e82d2a | 9 November 2016, received £250. Hours: 1 hr. (Registered 24 November 2016) | Employment and earnings 10057ffd | 2017-04-10 | Iain Duncan Smith uk.org.publicwhip/person/10180 | 2 | 2017-04-10-10057ffd-10180-1 | |
7eb2c9fc269ac492d9db8fb9a143786120bf470d | 30 November 2016, received £500. Hours: 2 hrs. (Registered 23 December 2016) | Employment and earnings 10057ffd | 2017-04-10 | Iain Duncan Smith uk.org.publicwhip/person/10180 | 3 | 2017-04-10-10057ffd-10180-1 | |
041d2eafa4af47839e59a62f89bf4705eb5978a4 | 21 December 2016, received £500. Hours: 2 hrs. (Registered 23 December 2016) | Employment and earnings 10057ffd | 2017-04-10 | Iain Duncan Smith uk.org.publicwhip/person/10180 | 4 | 2017-04-10-10057ffd-10180-1 | |
a6f91b218809fa5a2281ffb2c828f902fa24ac8f | Payment for speaking engagement received via London Speaker Bureau (London), 235 Kensington High Street, Kensington W8 6SF: | Employment and earnings 10057ffd | 2017-04-10 | Iain Duncan Smith uk.org.publicwhip/person/10180 | 5 | 2017-04-10-10057ffd-10180-1 | |
079fd8a7d5b66a299d36ae404c5580e86733b92f | 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-04-10 | Iain Duncan Smith uk.org.publicwhip/person/10180 | 6 | 2017-04-10-10057ffd-10180-1 | |
aaa3dd47321248d530b9f15954ab469b1417a403 | Payment for speaking engagement received via Champions (Loughborough), Barrington House, Leake Road Costock, Loughborough LE12 6XA: | Employment and earnings 10057ffd | 2017-04-10 | Iain Duncan Smith uk.org.publicwhip/person/10180 | 7 | 2017-04-10-10057ffd-10180-1 | |
554f356ede6339634be7ab48998d71f1d58557d1 | 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-04-10 | Iain Duncan Smith uk.org.publicwhip/person/10180 | 8 | 2017-04-10-10057ffd-10180-1 | |
fca9c42df5b752cf26a85f7b91d5840fc46edf2d | 25 January 2017, received £750 from The Daily Mail, 2 Derry Street, London W8 5TT, for an article. Hours: 2 hrs. (Registered 22 February 2017) | Employment and earnings 10057ffd | 2017-04-10 | Iain Duncan Smith uk.org.publicwhip/person/10180 | 9 | 2017-04-10-10057ffd-10180-1 |
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");