items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
15 rows where record_id = "2018-01-22-10057ffd-10632-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 |
---|---|---|---|---|---|---|---|
b799f2c674ca3173fed4d36aa6c20d49464faae6 | Payments received from AlphaSights Ltd, Thames Court, 1 Queenhithe, London EC4V 3DX, for advice on state of UK media industry and regulatory issues: | Employment and earnings 10057ffd | 2018-01-22 | John Whittingdale uk.org.publicwhip/person/10632 | 0 | 2018-01-22-10057ffd-10632-0 | |
64c6cc8d637dcee23d3e6bac2a86483ce48b9824 | 4 January 2017, received £500. Hours: 1 hr. (Registered 31 January 2017) | Employment and earnings 10057ffd | 2018-01-22 | John Whittingdale uk.org.publicwhip/person/10632 | 1 | 2018-01-22-10057ffd-10632-0 | |
a146e27a6db56138c1f1ec36912603f9c2990a21 | 17 January 2017, received £500. Hours: 1 hr. (Registered 31 January 2017) | Employment and earnings 10057ffd | 2018-01-22 | John Whittingdale uk.org.publicwhip/person/10632 | 2 | 2018-01-22-10057ffd-10632-0 | |
daa9b0347ced64b6f8ef6755f1e9e166d04bd5c4 | 18 January 2017, received £850. Hours: 2 hrs. (Registered 31 January 2017) | Employment and earnings 10057ffd | 2018-01-22 | John Whittingdale uk.org.publicwhip/person/10632 | 3 | 2018-01-22-10057ffd-10632-0 | |
6edecaef6b716a9469d52b53a6375a042d328fb0 | 13 June 2017, received £375. Hours: 30 mins. (Registered 04 July 2017) | Employment and earnings 10057ffd | 2018-01-22 | John Whittingdale uk.org.publicwhip/person/10632 | 4 | 2018-01-22-10057ffd-10632-0 | |
f7b8a56c8bf8b4fecb1d36428c152e2d4748ef12 | 16 June 2017, received £1,000. Hours: 1.5 hrs. (Registered 04 July 2017) | Employment and earnings 10057ffd | 2018-01-22 | John Whittingdale uk.org.publicwhip/person/10632 | 5 | 2018-01-22-10057ffd-10632-0 | |
4bb3c7a71f56961ed205e9486fe338e1f1523ea2 | 26 June 2017, received £420. Hours: 45 mins. (Registered 04 July 2017) | Employment and earnings 10057ffd | 2018-01-22 | John Whittingdale uk.org.publicwhip/person/10632 | 6 | 2018-01-22-10057ffd-10632-0 | |
a197f3807764bb4dc92ea720d06c614f8338b365 | 3 August 2017, received £420. Hours: 45 mins. (Registered 11 October 2017) | Employment and earnings 10057ffd | 2018-01-22 | John Whittingdale uk.org.publicwhip/person/10632 | 7 | 2018-01-22-10057ffd-10632-0 | |
fea6a1ebb12d785cf97f5cac6ce76fa09b6e97c1 | 31 August 2017, received £375. Hours: 40 mins. (Registered 11 October 2017) | Employment and earnings 10057ffd | 2018-01-22 | John Whittingdale uk.org.publicwhip/person/10632 | 8 | 2018-01-22-10057ffd-10632-0 | |
b2962592c6e6cbf8725d5b93b0a73801e129c153 | 28 September 2017, received £550. Hours: 1 hr. (Registered 11 October 2017) | Employment and earnings 10057ffd | 2018-01-22 | John Whittingdale uk.org.publicwhip/person/10632 | 9 | 2018-01-22-10057ffd-10632-0 | |
5f7006a2d710f66897060b521a8ec203ced8e384 | 5 April 2017, received £3,000 from Association of British Bookmakers, Warwick House, 25 Buckingham Palace Road, London SW1W 0PP, for giving a speech to Annual General Meeting on 21 March 2017. Hours: 2 hrs. (Registered 19 April 2017) | Employment and earnings 10057ffd | 2018-01-22 | John Whittingdale uk.org.publicwhip/person/10632 | 10 | 2018-01-22-10057ffd-10632-0 | |
9ef24576eba757c0cc5e7c2c493e35023d1a538b | From 22 April 2017 until further notice, member of an advisory board providing advice on media policy issues and regulatory developments to South West News Service, Media Centre, Emma Chris Way, Filton, Bristol BS34 7JU, for which I receive £1,000 a month. I consulted ACoBA about this appointment. First payment received 1 May 2017. Hours: 6 hrs a month. (Registered 04 July 2017) | Employment and earnings 10057ffd | 2018-01-22 | John Whittingdale uk.org.publicwhip/person/10632 | 11 | 2018-01-22-10057ffd-10632-0 | |
01cd6890d955b505c3cb47e0b36c575ca9b1578f | 1 April 2017 until further notice, providing advice on regulatory issues and policy development to Authors Licensing and Collecting Society, Barnard's Inn, 86 Fetter Land, London EC4A 1EN, for which I receive £1,500 a quarter. I consulted ACoBA about this appointment. First payment received 30 June 2017. Hours: 12 hrs a quarter. (Registered 04 July 2017) | Employment and earnings 10057ffd | 2018-01-22 | John Whittingdale uk.org.publicwhip/person/10632 | 12 | 2018-01-22-10057ffd-10632-0 | |
9c78bdc01aa7429b9c0806bafa53bba8023fd2b7 | 18 September 2017, received payment of £564 from Guidepoint Global, 730 Third Ave, New York, NY 10017, for advice on state of UK Media and industry and regulatory issues. Hours: 1 hr. (Registered 11 October 2017) | Employment and earnings 10057ffd | 2018-01-22 | John Whittingdale uk.org.publicwhip/person/10632 | 13 | 2018-01-22-10057ffd-10632-0 | |
5c1f713131564c994a1f21a689fd043702e98179 | From 16 August 2017 until further notice, adviser to the Federation of International Polo, Miraflores 1556, 11500 Montevideo, Uruguay, for which I receive £3,000 a quarter. I consulted ACoBA about this appointment. First payment received: 4 September 2017. Hours: 6 hours a month. (Registered 11 October 2017) | Employment and earnings 10057ffd | 2018-01-22 | John Whittingdale uk.org.publicwhip/person/10632 | 14 | 2018-01-22-10057ffd-10632-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");