items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
16 rows where record_id = "2017-05-02-10057ffd-25364-0" sorted by category_id descending
This data as json, CSV (advanced)
Suggested facets: date (date)
hash | item | category_id ▲ | date | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
34c7ec75e8d1b476839442a966dcadea81b8a651 | As a City Councillor, I receive an allowance of £1,355.58 a month from Birmingham City Council, Victoria Square, Birmingham B1 1BB, until 5 May 2016 (final payment 25 April 2016). Hours: expected to be 3 days a week. (Registered 7 June 2015; updated 15 April 2016) | Employment and earnings 10057ffd | 2017-05-02 | Jess Phillips uk.org.publicwhip/person/25364 | 0 | 2017-05-02-10057ffd-25364-0 | |
da01737ec5e9d063afe842585f582d19d30b11c3 | Payments from the BBC, New Broadcasting House, Portland Place, London W1A 1AA: | Employment and earnings 10057ffd | 2017-05-02 | Jess Phillips uk.org.publicwhip/person/25364 | 1 | 2017-05-02-10057ffd-25364-0 | |
4f639b9199dedd37c1dc9051b085e14d67f23e86 | 21 April 2016, received £150 for appearing on 'Any Questions'. Hours: 2 hrs. (Registered 03 May 2016) | Employment and earnings 10057ffd | 2017-05-02 | Jess Phillips uk.org.publicwhip/person/25364 | 2 | 2017-05-02-10057ffd-25364-0 | |
5d352f0de24fb71fe7c52f19714e08086727e8fc | 6 June 2016, received £350 for appearing on 'This Week'. Hours: 2 hrs. (Registered 01 July 2016) | Employment and earnings 10057ffd | 2017-05-02 | Jess Phillips uk.org.publicwhip/person/25364 | 3 | 2017-05-02-10057ffd-25364-0 | |
c62af162aa85522406e4334245306bf1fe86aedb | 26 January 2017, received £350 for appearing on 'This Week'. Hours: 2 hrs. (Registered 20 February 2017) | Employment and earnings 10057ffd | 2017-05-02 | Jess Phillips uk.org.publicwhip/person/25364 | 4 | 2017-05-02-10057ffd-25364-0 | |
feaa4f11cb4c72916f555122daf49cb30f1a9e4a | 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-05-02 | Jess Phillips uk.org.publicwhip/person/25364 | 5 | 2017-05-02-10057ffd-25364-0 | |
077b37503cb9630712958a398621bad1e527c056 | 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-05-02 | Jess Phillips uk.org.publicwhip/person/25364 | 6 | 2017-05-02-10057ffd-25364-0 | |
d712f38cf5bbdc9823a9bb97559ead97e6d228db | 17 June 2016, received £1,500. Hours: 5 hrs. (Registered 01 July 2016) | Employment and earnings 10057ffd | 2017-05-02 | Jess Phillips uk.org.publicwhip/person/25364 | 7 | 2017-05-02-10057ffd-25364-0 | |
6ba91f8ac7ef3c5d1b5e63ec8800eba282d820cf | 16 December 2016, received £1,500. Hours: 5 hrs. (Registered 04 January 2017) | Employment and earnings 10057ffd | 2017-05-02 | Jess Phillips uk.org.publicwhip/person/25364 | 8 | 2017-05-02-10057ffd-25364-0 | |
804155e273737a7491e3380929b71b4c1d8a9fa1 | 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-05-02 | Jess Phillips uk.org.publicwhip/person/25364 | 9 | 2017-05-02-10057ffd-25364-0 | |
30e8e628367504efc2a01dd6333a5f0e35a7c471 | 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-05-02 | Jess Phillips uk.org.publicwhip/person/25364 | 10 | 2017-05-02-10057ffd-25364-0 | |
6ea19293372a98193154b53d0d20a3d6dadc6361 | 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-05-02 | Jess Phillips uk.org.publicwhip/person/25364 | 11 | 2017-05-02-10057ffd-25364-0 | |
7639e8073d45e2399dfae130b2368a0a6738bd94 | 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-05-02 | Jess Phillips uk.org.publicwhip/person/25364 | 12 | 2017-05-02-10057ffd-25364-0 | |
70184c2ddf4766fff1e7cff2e109cc9d8957e83c | 10 November 2016, received £25,625 advance for a book. Hours: no additional hours. (Registered 07 December 2016) | Employment and earnings 10057ffd | 2017-05-02 | Jess Phillips uk.org.publicwhip/person/25364 | 13 | 2017-05-02-10057ffd-25364-0 | |
a34a630a1f04953a16a10a1b75ede80554a23b82 | 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-05-02 | Jess Phillips uk.org.publicwhip/person/25364 | 14 | 2017-05-02-10057ffd-25364-0 | |
2cda9efe120ccd347eefb9d2ce87da67c75dbd68 | 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-05-02 | Jess Phillips uk.org.publicwhip/person/25364 | 15 | 2017-05-02-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");