items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
15 rows where record_id = "2018-01-08-10057ffd-25364-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 |
---|---|---|---|---|---|---|---|
5d9f1ae59cfd619a1144d48db11a721859cd9842 | Payments from the BBC, New Broadcasting House, Portland Place, London W1A 1AA: | Employment and earnings 10057ffd | 2018-01-08 | Jess Phillips uk.org.publicwhip/person/25364 | 0 | 2018-01-08-10057ffd-25364-0 | |
d7c06d574c3d8ce94e744ced9ef54a2c72e7da18 | 26 January 2017, received £350 for appearing on 'This Week'. Hours: 2 hrs. (Registered 20 February 2017) | Employment and earnings 10057ffd | 2018-01-08 | Jess Phillips uk.org.publicwhip/person/25364 | 1 | 2018-01-08-10057ffd-25364-0 | |
0b3bebaac971af042ba86a5a6cb35d945fc631d0 | Payments from Hat Trick Productions, 33 Oval Road, London, NW1 7EA, for appearing on 'Have I Got News For You': | Employment and earnings 10057ffd | 2018-01-08 | Jess Phillips uk.org.publicwhip/person/25364 | 2 | 2018-01-08-10057ffd-25364-0 | |
a6744e32f8f2c0deaac3cc9b17449ea820b6b9ea | 16 December 2016, received £1,500. Hours: 5 hrs. (Registered 04 January 2017) | Employment and earnings 10057ffd | 2018-01-08 | Jess Phillips uk.org.publicwhip/person/25364 | 3 | 2018-01-08-10057ffd-25364-0 | |
2e6105384f8b1c1ba044050c9682ccfa4f220e1d | 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 | 2018-01-08 | Jess Phillips uk.org.publicwhip/person/25364 | 4 | 2018-01-08-10057ffd-25364-0 | |
22573e7c7f0a1893faf520cc04f406146bbce2cc | 10 April 2017, received £25,625 advance payment for a book. Hours: no additional hours. (Registered 14 June 2017) | Employment and earnings 10057ffd | 2018-01-08 | Jess Phillips uk.org.publicwhip/person/25364 | 5 | 2018-01-08-10057ffd-25364-0 | |
15df19780ed6d8844d19feb8501bb16f43c6a5ff | 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 | 2018-01-08 | Jess Phillips uk.org.publicwhip/person/25364 | 6 | 2018-01-08-10057ffd-25364-0 | |
94aebd1be89511708811d20960635d140579da6a | 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 | 2018-01-08 | Jess Phillips uk.org.publicwhip/person/25364 | 7 | 2018-01-08-10057ffd-25364-0 | |
5ff42ff8c46e71192ce1f03b143513f009677ffd | Payments received from the Observer, Kings Place, 90 York Way, London N1 9GU: | Employment and earnings 10057ffd | 2018-01-08 | Jess Phillips uk.org.publicwhip/person/25364 | 8 | 2018-01-08-10057ffd-25364-0 | |
435cd1b82c63a3d114d7ceb84c101b9cf4e49de1 | 7 September 2017, received £400 for writing an article. Hours: 2 hrs. (Registered 13 September 2017) | Employment and earnings 10057ffd | 2018-01-08 | Jess Phillips uk.org.publicwhip/person/25364 | 9 | 2018-01-08-10057ffd-25364-0 | |
51255fa40508b2beca1f7855595282892a18a11c | 16 November 2017, received £370.64 for writing an article. Hours: 2 hrs. (Registered 05 December 2017) | Employment and earnings 10057ffd | 2018-01-08 | Jess Phillips uk.org.publicwhip/person/25364 | 10 | 2018-01-08-10057ffd-25364-0 | |
8cb9e557cdbbdd661dad678d279468d5184d933c | 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 | 2018-01-08 | Jess Phillips uk.org.publicwhip/person/25364 | 11 | 2018-01-08-10057ffd-25364-0 | |
748b7eada3d778d274617e7698272b1e6ec5d0d8 | 8 September 2017, received £615. Hours: 6 hrs. (Registered 19 October 2017) | Employment and earnings 10057ffd | 2018-01-08 | Jess Phillips uk.org.publicwhip/person/25364 | 12 | 2018-01-08-10057ffd-25364-0 | |
a11c2ea8d09dec74cf0b2c5982d584c375b61e9c | 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 | 2018-01-08 | Jess Phillips uk.org.publicwhip/person/25364 | 13 | 2018-01-08-10057ffd-25364-0 | |
993a108dc7a7a9885e4dde4c73212912fc9c466c | 21 September 2017, received £100 from the Guardian, Kings Place, 90 York Way, London N1 9GU, for writing an article. Hours: 1 hr. (Registered 05 December 2017) | Employment and earnings 10057ffd | 2018-01-08 | Jess Phillips uk.org.publicwhip/person/25364 | 14 | 2018-01-08-10057ffd-25364-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");