items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
28 rows where record_id = "2017-01-09-10057ffd-24850-0" sorted by date descending
This data as json, CSV (advanced)
Suggested facets: date (date)
hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
99b8e6a78e651d8b847ff5ffa3030c01f8ad1bd2 | Payments from Penguin Books Ltd. 80 Strand, London, WC2R 0RL; made through Capel and Land, literary agents, 29 Wardour Street, London W1D 6PS (Updated 28 July 2014): | Employment and earnings 10057ffd | 2017-01-09 | Tristram Hunt uk.org.publicwhip/person/24850 | 0 | 2017-01-09-10057ffd-24850-0 | |
fdca73fa283414ad1d8813e967779b48d84d303f | 7 April 2016, received payment of £248.80 (book royalties). Hours: 0 hrs. (Registered 26 April 2016) | Employment and earnings 10057ffd | 2017-01-09 | Tristram Hunt uk.org.publicwhip/person/24850 | 1 | 2017-01-09-10057ffd-24850-0 | |
f8eef2f5c51aa5249dac4d0a01b69c2f7f2cb691 | 8 June 2016, received advance payment of £12,300. Hours: 0 hrs to date. (Registered 07 July 2016) | Employment and earnings 10057ffd | 2017-01-09 | Tristram Hunt uk.org.publicwhip/person/24850 | 2 | 2017-01-09-10057ffd-24850-0 | |
d09f0bef2a8d394e45213704c6a287c7341592ac | Salary as lecturer at Queen Mary, University of London, Mile End Road, London E1 4NS. Payment of £1,082.86 gross per month, until further notice. Hours: 16 hrs per month. (Updated 24 July 2015) | Employment and earnings 10057ffd | 2017-01-09 | Tristram Hunt uk.org.publicwhip/person/24850 | 3 | 2017-01-09-10057ffd-24850-0 | |
a2ae2afd88f519a6ac3160be90a1e95a167f4bd8 | Payments from News UK, 1 London Bridge Street, London SE1 9GF: | Employment and earnings 10057ffd | 2017-01-09 | Tristram Hunt uk.org.publicwhip/person/24850 | 4 | 2017-01-09-10057ffd-24850-0 | |
b57c8706570a4fcc63f568e839049eeb0e71d7c6 | 31 March 2016, received payment of £400 for an article (Sunday Times). Hours: 2 hrs. (Registered 26 April 2016) | Employment and earnings 10057ffd | 2017-01-09 | Tristram Hunt uk.org.publicwhip/person/24850 | 5 | 2017-01-09-10057ffd-24850-0 | |
e8605af73a59547bb776100ec49480d7cc01d96c | 15 June 2016, received payment of £350 for an article (Sunday Times). Hours: 2 hrs. (Registered 07 July 2016) | Employment and earnings 10057ffd | 2017-01-09 | Tristram Hunt uk.org.publicwhip/person/24850 | 6 | 2017-01-09-10057ffd-24850-0 | |
61e37213f14a6ca6b07d0018ba7b5f70186003f5 | 15 August 2016, received payment of £850 for two articles (Times and Sunday Times). Hours: 4 hrs. (Registered 28 September 2016) | Employment and earnings 10057ffd | 2017-01-09 | Tristram Hunt uk.org.publicwhip/person/24850 | 7 | 2017-01-09-10057ffd-24850-0 | |
f2198073f5f05021945d1acfa456cc0163d01de6 | Payments for articles from Telegraph Media Group Ltd, 111 Buckingham Palace Road, London SW1W 0DT: | Employment and earnings 10057ffd | 2017-01-09 | Tristram Hunt uk.org.publicwhip/person/24850 | 8 | 2017-01-09-10057ffd-24850-0 | |
b5bda13494486a637eacf4f40f9d4fb2f4e0a6b3 | 15 January 2016, received payment of £324 for one article. Hours: 2 hrs. (Registered 25 January 2016) | Employment and earnings 10057ffd | 2017-01-09 | Tristram Hunt uk.org.publicwhip/person/24850 | 9 | 2017-01-09-10057ffd-24850-0 | |
2c0b91416e7abb9c1e4bc0d89112c04edf0088f9 | Payments for articles from Trinity Mirror Group, One Canada Square, Canary Wharf, London, E14 5AP: | Employment and earnings 10057ffd | 2017-01-09 | Tristram Hunt uk.org.publicwhip/person/24850 | 10 | 2017-01-09-10057ffd-24850-0 | |
c19799e192f4b63f6d26adff443bbd11846ca2af | 23 December 2015, received payment of £700 for two articles. Hours: 3 hrs. (Registered 25 January 2016) | Employment and earnings 10057ffd | 2017-01-09 | Tristram Hunt uk.org.publicwhip/person/24850 | 11 | 2017-01-09-10057ffd-24850-0 | |
0f93fe5f4b66af9472279c0dd9834af98c961edd | Payments from Random House Group Ltd, 20 Vauxhall Bridge Rd, London SW1V 2SA; made through Capel & Land, literary agents, 29 Wardour Street, London W1D 6PS: | Employment and earnings 10057ffd | 2017-01-09 | Tristram Hunt uk.org.publicwhip/person/24850 | 12 | 2017-01-09-10057ffd-24850-0 | |
49ae54d3a4c7f63314a4ab5f7f9617daae94efeb | 14 January 2016, received payment of £656 for introduction to book. Hours: 6 hrs. (Registered 25 January 2016) | Employment and earnings 10057ffd | 2017-01-09 | Tristram Hunt uk.org.publicwhip/person/24850 | 13 | 2017-01-09-10057ffd-24850-0 | |
f5dfe0c9352c879edee2bbf198428b7dfe2eb2da | Payment for article for Financial Times, Number One Southwark Bridge, London SE1 9HL: | Employment and earnings 10057ffd | 2017-01-09 | Tristram Hunt uk.org.publicwhip/person/24850 | 14 | 2017-01-09-10057ffd-24850-0 | |
9b0b78f3b64bbf9aa1348c5a6de359c09e006a5b | 8 April 2016, received payment of £400. Hours: 2 hrs. (Registered 26 April 2016) | Employment and earnings 10057ffd | 2017-01-09 | Tristram Hunt uk.org.publicwhip/person/24850 | 15 | 2017-01-09-10057ffd-24850-0 | |
a6ef2d60bf58a359cbffe041f51be6cf4e84ef30 | 8 June 2016, received payment of £150 for an article. Hours: 1.5 hrs. (Registered 07 July 2016) | Employment and earnings 10057ffd | 2017-01-09 | Tristram Hunt uk.org.publicwhip/person/24850 | 16 | 2017-01-09-10057ffd-24850-0 | |
f676bcee38244920719a8600468b72e975fbf891 | Payment for article for The Spectator, 22 Old Queen Street, London SW1H 9HP: | Employment and earnings 10057ffd | 2017-01-09 | Tristram Hunt uk.org.publicwhip/person/24850 | 17 | 2017-01-09-10057ffd-24850-0 | |
679d17e36d87316124d33c2b35db70701b6acdf5 | 31 March 2016, received payment of £250. Hours: 1.5 hrs. (Registered 26 April 2016) | Employment and earnings 10057ffd | 2017-01-09 | Tristram Hunt uk.org.publicwhip/person/24850 | 18 | 2017-01-09-10057ffd-24850-0 | |
d64698852c9660b684ccbf39b911adb81e378e6e | Payment for article for Prospect Magazine, 2 Queen Anne’s Gate, London, SW1H 9AA: | Employment and earnings 10057ffd | 2017-01-09 | Tristram Hunt uk.org.publicwhip/person/24850 | 19 | 2017-01-09-10057ffd-24850-0 | |
5e075667e643e9c029b90a4588a7a4bee1e72639 | 23 March 2016, received payment of £500. Hours: 3 hrs. (Registered 26 April 2016) | Employment and earnings 10057ffd | 2017-01-09 | Tristram Hunt uk.org.publicwhip/person/24850 | 20 | 2017-01-09-10057ffd-24850-0 | |
3e2481849034ed01742f8be04e4a8cb09c887eb7 | Payments from No.126, Jinhua St., Taipei City 10642, Taiwan; made through Capel and Land, literary agents, 29 Wardour Street, London W1D 6PS: | Employment and earnings 10057ffd | 2017-01-09 | Tristram Hunt uk.org.publicwhip/person/24850 | 21 | 2017-01-09-10057ffd-24850-0 | |
65963e8d581423728ac844c19860cb0bef073b70 | 31 May 2016, received payment of £832.60 for foreign publishing rights for book. Hours: 0 hrs. (Registered 07 July 2016) | Employment and earnings 10057ffd | 2017-01-09 | Tristram Hunt uk.org.publicwhip/person/24850 | 22 | 2017-01-09-10057ffd-24850-0 | |
8cd4a149f47eff14ec4c7aa6bc346f7257b817cc | Payments from Guardian News Media Ltd, Kings Place, 90 York Way, London, N1P 2AP: | Employment and earnings 10057ffd | 2017-01-09 | Tristram Hunt uk.org.publicwhip/person/24850 | 23 | 2017-01-09-10057ffd-24850-0 | |
b7c24eafa3bb6ccf967e4468ecba75657b895b87 | 3 June 2016, received payment of £246 through Capel and Land, literary agents, 29 Wardour Street, London W1D 6PS, for a reprint. Hours: 0 hrs. (Registered 07 July 2016) | Employment and earnings 10057ffd | 2017-01-09 | Tristram Hunt uk.org.publicwhip/person/24850 | 24 | 2017-01-09-10057ffd-24850-0 | |
6a49ebfb92615466f09c03ad7035b2eeb5b4b464 | 4 June 2016, received payment of £434.95 for an article. Hours: 2 hrs. (Registered 07 July 2016) | Employment and earnings 10057ffd | 2017-01-09 | Tristram Hunt uk.org.publicwhip/person/24850 | 25 | 2017-01-09-10057ffd-24850-0 | |
8780285bae52ab7116b2d5f3dc6e637b4abd6a48 | Payments from Henry Holt & Co publishers (Palgrave Macmillian), Flatiron Building, 175 5th Ave, New York City, NY 10010, USA; made through Capel and Land, literary agents, 29 Wardour Street, London W1D 6PS: | Employment and earnings 10057ffd | 2017-01-09 | Tristram Hunt uk.org.publicwhip/person/24850 | 26 | 2017-01-09-10057ffd-24850-0 | |
ffeed406f79678ebccb0c659c6add07af9b3ae7f | 25 August 2016, received payment of £7,564.64 for foreign publishing rights for book. Hours: 0 hrs. (Registered 28 September 2016) | Employment and earnings 10057ffd | 2017-01-09 | Tristram Hunt uk.org.publicwhip/person/24850 | 27 | 2017-01-09-10057ffd-24850-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");