items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
15 rows where record_id = "2017-01-09-10057ffd-25364-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 |
---|---|---|---|---|---|---|---|
1d04a54d5a3935ad4c0de4613f5580a7c4c9f04c | Payments from the BBC, New Broadcasting House, Portland Place, London W1A 1AA: | Employment and earnings 10057ffd | 2017-01-09 | Jess Phillips uk.org.publicwhip/person/25364 | 0 | 2017-01-09-10057ffd-25364-1 | |
842d5b09295b5c933d409f6aaa415105077f748d | 16 December 2015, received £350 for appearing on 'This Week'. Hours: 2 hrs. (Registered 05 January 2016) | Employment and earnings 10057ffd | 2017-01-09 | Jess Phillips uk.org.publicwhip/person/25364 | 1 | 2017-01-09-10057ffd-25364-1 | |
b8dc8248fc60e3cce331a4aa41a3609cdb02ba3e | 18 January 2016, received £350 for appearing on 'This Week'. Hours: 2 hrs. (Registered 05 February 2016) | Employment and earnings 10057ffd | 2017-01-09 | Jess Phillips uk.org.publicwhip/person/25364 | 2 | 2017-01-09-10057ffd-25364-1 | |
12816bbf8121de3ce59737c896b14262ac22fc3c | 21 March 2016, received £350 for appearing on 'This Week'. Hours: 2 hrs. (Registered 15 April 2016) | Employment and earnings 10057ffd | 2017-01-09 | Jess Phillips uk.org.publicwhip/person/25364 | 3 | 2017-01-09-10057ffd-25364-1 | |
a4692f3fc69471314471747729a13f703abf09b7 | 21 April 2016, received £150 for appearing on 'Any Questions'. Hours: 2 hrs. (Registered 03 May 2016) | Employment and earnings 10057ffd | 2017-01-09 | Jess Phillips uk.org.publicwhip/person/25364 | 4 | 2017-01-09-10057ffd-25364-1 | |
ef733eff7c8a2610bc59fc3ab6675321ec37eaad | 6 June 2016, received £350 for appearing on 'This Week'. Hours: 2 hrs. (Registered 01 July 2016) | Employment and earnings 10057ffd | 2017-01-09 | Jess Phillips uk.org.publicwhip/person/25364 | 5 | 2017-01-09-10057ffd-25364-1 | |
fed29d5ee9db418fedd97c512de547b5ff24f26d | 5 May 2016, received £150 from Truth Consulting Ltd, 65 Gresham St, London EC2V 7NQ, for a survey. Hours: 1 hr. (Registered 17 May 2016) | Employment and earnings 10057ffd | 2017-01-09 | Jess Phillips uk.org.publicwhip/person/25364 | 6 | 2017-01-09-10057ffd-25364-1 | |
0cc494288696a1694b4a58c7071628c984361c39 | Payments from Hat Trick Productions, 33 Oval Road, London, NW1 7EA, for appearing on 'Have I Got News For You': | Employment and earnings 10057ffd | 2017-01-09 | Jess Phillips uk.org.publicwhip/person/25364 | 7 | 2017-01-09-10057ffd-25364-1 | |
bfd13d5abe519e200badc104735674e3f2b362e7 | 17 June 2016, received £1,500. Hours: 5 hrs. (Registered 01 July 2016) | Employment and earnings 10057ffd | 2017-01-09 | Jess Phillips uk.org.publicwhip/person/25364 | 8 | 2017-01-09-10057ffd-25364-1 | |
54f2d31b04a97e8fadbbcf574f1da51c2a7f8e4e | 16 December 2016, received £1,500. Hours: 5 hrs. (Registered 04 January 2017) | Employment and earnings 10057ffd | 2017-01-09 | Jess Phillips uk.org.publicwhip/person/25364 | 9 | 2017-01-09-10057ffd-25364-1 | |
1742a8c719e650cc48de0ebf49857ec7ff7881e5 | 1 August 2016, received £500 from Intelligence Squared, 21 Albemarle St, London W15 4BS, for being a speaker at a debate. Hours: 1.5 hrs. (Registered 15 August 2016) | Employment and earnings 10057ffd | 2017-01-09 | Jess Phillips uk.org.publicwhip/person/25364 | 10 | 2017-01-09-10057ffd-25364-1 | |
26ae15011bc13d0c3b58d5c909546925d9348bfd | 25 August 2016, received £372.82 from the Observer, Kings Place, 90 York Way, London N1 9GU, for writing an article. Hours: 3 hrs. (Registered 06 September 2016) | Employment and earnings 10057ffd | 2017-01-09 | Jess Phillips uk.org.publicwhip/person/25364 | 11 | 2017-01-09-10057ffd-25364-1 | |
2b161bbfd68457e432be8c09a42696e5b9aed6b6 | Payments from Hutchinson, 20 Vauxhall Bridge Road London SW1V 2SA, via Tibor Jones & Associates, 2-6 Atlantic Road, London SW9 8HY: | Employment and earnings 10057ffd | 2017-01-09 | Jess Phillips uk.org.publicwhip/person/25364 | 12 | 2017-01-09-10057ffd-25364-1 | |
150fac2dd09765088b5ad022229f948db1702c96 | 6 September 2016, received £25,625 advance payment for a book. Hours: approx. 80 hrs (10 hrs per week during July and August 2016). (Registered 28 October 2016) | Employment and earnings 10057ffd | 2017-01-09 | Jess Phillips uk.org.publicwhip/person/25364 | 13 | 2017-01-09-10057ffd-25364-1 | |
348a57365e7431de2fe2117cad7b656a10e19c0d | 10 November 2016, received £25,625 advance for a book. Hours: no additional hours. (Registered 07 December 2016) | Employment and earnings 10057ffd | 2017-01-09 | Jess Phillips uk.org.publicwhip/person/25364 | 14 | 2017-01-09-10057ffd-25364-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");