items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
15 rows where record_id = "2015-03-30-1f359ece-10499-0" sorted by date descending
This data as json, CSV (advanced)
Suggested facets: date (date)
hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
0801a76a8d38c03fcd30b7fe7c0bb2aab3f76f10 | Visiting Professorship to Middlesex University Business School, lecturing on financial subjects related to my previous career. Address: The Burroughs, London, NW4 4BT. | Remunerated employment, office, profession etc 1f359ece | 2015-03-30 | John Redwood uk.org.publicwhip/member/40667 | John Redwood uk.org.publicwhip/person/10499 | 0 | 2015-03-30-1f359ece-10499-0 |
4796bd11bcfcc3507d0cf60ae3b029813ef51d21 | Received £915 gross for February 2014. Hours: 12 hrs. (Registered 1 May 2014) | Remunerated employment, office, profession etc 1f359ece | 2015-03-30 | John Redwood uk.org.publicwhip/member/40667 | John Redwood uk.org.publicwhip/person/10499 | 1 | 2015-03-30-1f359ece-10499-0 |
4a2a5060386a4edb08edf6ea9602b6e229e19373 | Received £915 gross for March 2014. Hours: 12 hrs. (Registered 1 May 2014) | Remunerated employment, office, profession etc 1f359ece | 2015-03-30 | John Redwood uk.org.publicwhip/member/40667 | John Redwood uk.org.publicwhip/person/10499 | 2 | 2015-03-30-1f359ece-10499-0 |
2f3809d3e64dabc847e1d80dd2923c7de430ed6b | Received £915 gross for April 2014. Hours: 12 hrs. (Registered 8 May 2014) | Remunerated employment, office, profession etc 1f359ece | 2015-03-30 | John Redwood uk.org.publicwhip/member/40667 | John Redwood uk.org.publicwhip/person/10499 | 3 | 2015-03-30-1f359ece-10499-0 |
69dc3a98b588aacad70f76aa79936b1b096b0934 | Received £915 gross for May 2014. Hours: 11 hrs. (Registered 6 June 2014) | Remunerated employment, office, profession etc 1f359ece | 2015-03-30 | John Redwood uk.org.publicwhip/member/40667 | John Redwood uk.org.publicwhip/person/10499 | 4 | 2015-03-30-1f359ece-10499-0 |
a66579629a5a4246b39fd14014c49f31c86d744e | Received £915 gross for June 2014. Hours: 11 hrs. (Registered 1 July 2014) | Remunerated employment, office, profession etc 1f359ece | 2015-03-30 | John Redwood uk.org.publicwhip/member/40667 | John Redwood uk.org.publicwhip/person/10499 | 5 | 2015-03-30-1f359ece-10499-0 |
2c70b1a9abf276ac6320d565f564f12cff767599 | Received £973 gross for July 2014. Hours: 12 hrs. (Registered 4 August 2014) | Remunerated employment, office, profession etc 1f359ece | 2015-03-30 | John Redwood uk.org.publicwhip/member/40667 | John Redwood uk.org.publicwhip/person/10499 | 6 | 2015-03-30-1f359ece-10499-0 |
f6550714f8001eba7504b39a88551c889e1939c7 | Received £973 gross for August 2014. Hours: 12 hrs. (Registered 1 September 2014) | Remunerated employment, office, profession etc 1f359ece | 2015-03-30 | John Redwood uk.org.publicwhip/member/40667 | John Redwood uk.org.publicwhip/person/10499 | 7 | 2015-03-30-1f359ece-10499-0 |
16dff6e67d8ab50a26162e66891fa78f9d92d57f | Received £973 gross for September 2014. Hours: 12 hrs. (Registered 28 October 2014) | Remunerated employment, office, profession etc 1f359ece | 2015-03-30 | John Redwood uk.org.publicwhip/member/40667 | John Redwood uk.org.publicwhip/person/10499 | 8 | 2015-03-30-1f359ece-10499-0 |
e04e10a38c66d669910023d971b9e4bbfecc1f85 | Received £973 gross for October 2014. Hours: 13 hrs. (Registered 3 November 2014) | Remunerated employment, office, profession etc 1f359ece | 2015-03-30 | John Redwood uk.org.publicwhip/member/40667 | John Redwood uk.org.publicwhip/person/10499 | 9 | 2015-03-30-1f359ece-10499-0 |
586055d7ef0df06c6830c90308bb0cc1976ac17a | Received £973 gross for November 2014. Hours: 13 hrs. (Registered 4 December 2014) | Remunerated employment, office, profession etc 1f359ece | 2015-03-30 | John Redwood uk.org.publicwhip/member/40667 | John Redwood uk.org.publicwhip/person/10499 | 10 | 2015-03-30-1f359ece-10499-0 |
ebe8a831574146a506c85205fc02a5f347013a53 | Received £973 gross for December 2014. Hours: 14 hrs. (Registered 6 January 2015) | Remunerated employment, office, profession etc 1f359ece | 2015-03-30 | John Redwood uk.org.publicwhip/member/40667 | John Redwood uk.org.publicwhip/person/10499 | 11 | 2015-03-30-1f359ece-10499-0 |
b761e75a5362bd27ca2bf98e05d3476949dc8d20 | Received £973 gross for January 2015. Hours: 12 hrs. (Registered 4 February 2015) | Remunerated employment, office, profession etc 1f359ece | 2015-03-30 | John Redwood uk.org.publicwhip/member/40667 | John Redwood uk.org.publicwhip/person/10499 | 12 | 2015-03-30-1f359ece-10499-0 |
166715c459ca65e7e4b53b2df9829b454771e815 | Received £973 gross for February 2015. Hours: 12 hrs. (Registered 2 March 2015) | Remunerated employment, office, profession etc 1f359ece | 2015-03-30 | John Redwood uk.org.publicwhip/member/40667 | John Redwood uk.org.publicwhip/person/10499 | 13 | 2015-03-30-1f359ece-10499-0 |
da0b03556e1627fcf5bec2d654c1bc260e0fb2a6 | Received £973 gross for March 2015. Hours: 14 hrs. (Registered 30 March 2015) | Remunerated employment, office, profession etc 1f359ece | 2015-03-30 | John Redwood uk.org.publicwhip/member/40667 | John Redwood uk.org.publicwhip/person/10499 | 14 | 2015-03-30-1f359ece-10499-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");