items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
12 rows where record_id = "2017-10-23-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 |
---|---|---|---|---|---|---|---|
f685e1e8cd04cd31300eb689329ad72503295d28 | 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-10-23 | Jess Phillips uk.org.publicwhip/person/25364 | 0 | 2017-10-23-10057ffd-25364-1 | |
1a0f49729e01f948172a32a5adfc0e94dc924779 | 16 December 2016, received £1,500. Hours: 5 hrs. (Registered 04 January 2017) | Employment and earnings 10057ffd | 2017-10-23 | Jess Phillips uk.org.publicwhip/person/25364 | 1 | 2017-10-23-10057ffd-25364-1 | |
1ac2fd547717ebc4894e13edbde907973d000e4f | 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-10-23 | Jess Phillips uk.org.publicwhip/person/25364 | 2 | 2017-10-23-10057ffd-25364-1 | |
725f12077b02e1e1f5bcdc83175cee0c65e7e8a3 | 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-10-23 | Jess Phillips uk.org.publicwhip/person/25364 | 3 | 2017-10-23-10057ffd-25364-1 | |
997c81c5777d416114b66996e3065283c4dc436f | 10 November 2016, received £25,625 advance for a book. Hours: no additional hours. (Registered 07 December 2016) | Employment and earnings 10057ffd | 2017-10-23 | Jess Phillips uk.org.publicwhip/person/25364 | 4 | 2017-10-23-10057ffd-25364-1 | |
9c2b236b1cbb1a6f7ff724f4cbd6f5ec75bd30dc | 10 April 2017, received £25,625 advance payment for a book. Hours: no additional hours. (Registered 14 June 2017) | Employment and earnings 10057ffd | 2017-10-23 | Jess Phillips uk.org.publicwhip/person/25364 | 5 | 2017-10-23-10057ffd-25364-1 | |
a18a7851f5d973c6490094bdea028dfca52b3cc0 | 10 February 2017, received £250 from the New Statesman, 7 Carmelite Street, Blackfriars, London EC4Y 0BS, for an article. Hours: 2 hrs. (Registered 20 February 2017) | Employment and earnings 10057ffd | 2017-10-23 | Jess Phillips uk.org.publicwhip/person/25364 | 6 | 2017-10-23-10057ffd-25364-1 | |
385d023a2f8ae1d0068a67a6f3c60bdc26cd07d0 | 22 February 2017, received £500 from News UK & Ireland Ltd, 1 London Bridge Street, London SE1 9GF, for writing an article. Hours: 1.5 hrs. (Registered 16 March 2017) | Employment and earnings 10057ffd | 2017-10-23 | Jess Phillips uk.org.publicwhip/person/25364 | 7 | 2017-10-23-10057ffd-25364-1 | |
a5d9530c11b0b578986555e7ad7179dbad0cef66 | 7 September 2017, received £400 from the Observer, Kings Place, 90 York Way, London N1 9GU, for writing an article. Hours: 2 hrs. (Registered 13 September 2017) | Employment and earnings 10057ffd | 2017-10-23 | Jess Phillips uk.org.publicwhip/person/25364 | 8 | 2017-10-23-10057ffd-25364-1 | |
6ab05b7e95e656bd3c46adede1951ffde1b41120 | Payments received from Dods, 11th floor, The Shard, 32 London Bridge Street, London SE1 9SG, as Deputy Editor of the House Magazine: | Employment and earnings 10057ffd | 2017-10-23 | Jess Phillips uk.org.publicwhip/person/25364 | 9 | 2017-10-23-10057ffd-25364-1 | |
c3c3841af538bf9acca52cac8468ac479d4354b1 | 8 September 2017, received £615. Hours: 6 hrs. (Registered 19 October 2017) | Employment and earnings 10057ffd | 2017-10-23 | Jess Phillips uk.org.publicwhip/person/25364 | 10 | 2017-10-23-10057ffd-25364-1 | |
139e642543dcc2b4b5af40c5a5319b5e7f1b8798 | Until further notice I will receive a quarterly payment of £2,000. Hours: 2 hrs per month. (Registered 19 October 2017) | Employment and earnings 10057ffd | 2017-10-23 | Jess Phillips uk.org.publicwhip/person/25364 | 11 | 2017-10-23-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");