items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
13 rows where record_id = "2015-02-23-1aeb07b2-24926-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 |
---|---|---|---|---|---|---|---|
4eeeb21882224e2683c9da9a4310f4a1f5228534 | Somerset Capital Management LLP (partner), 146 Buckingham Palace Road, London SW1W 9TR; investment management | Directorships 1aeb07b2 | 2015-02-23 | Jacob Rees-Mogg uk.org.publicwhip/member/40441 | Jacob Rees-Mogg uk.org.publicwhip/person/24926 | 0 | 2015-02-23-1aeb07b2-24926-0 |
64cf77591594323873128590b9104cdde3afb193 | Received £9,092.89. Hours: 35 hrs in February 2014 . (Registered 14 March 2014) | Directorships 1aeb07b2 | 2015-02-23 | Jacob Rees-Mogg uk.org.publicwhip/member/40441 | Jacob Rees-Mogg uk.org.publicwhip/person/24926 | 1 | 2015-02-23-1aeb07b2-24926-0 |
b68d9567b4a2526f888e01cb390b15fb9d0badc7 | Received £9,148.19. Hours: 35 hrs in March 2014 . (Registered 14 April 2014) | Directorships 1aeb07b2 | 2015-02-23 | Jacob Rees-Mogg uk.org.publicwhip/member/40441 | Jacob Rees-Mogg uk.org.publicwhip/person/24926 | 2 | 2015-02-23-1aeb07b2-24926-0 |
9d6ab359c28eac5d1c0a8d476261bbe4a7eb29be | Received £9,095.82. Hours: 35 hours in April 2014. (Registered 9 May 2014) | Directorships 1aeb07b2 | 2015-02-23 | Jacob Rees-Mogg uk.org.publicwhip/member/40441 | Jacob Rees-Mogg uk.org.publicwhip/person/24926 | 3 | 2015-02-23-1aeb07b2-24926-0 |
19165baa312b83ee42b4b238f659d7793c8fb397 | Received £9,095.93. Hours: 35 hrs in May 2014. (Registered 6 June 2014) | Directorships 1aeb07b2 | 2015-02-23 | Jacob Rees-Mogg uk.org.publicwhip/member/40441 | Jacob Rees-Mogg uk.org.publicwhip/person/24926 | 4 | 2015-02-23-1aeb07b2-24926-0 |
c4f944badd61beac2c1568841808684fc57e9989 | Received £9,095.14. Hours: 35 hrs in June 2014. (Registered 14 July 2014) | Directorships 1aeb07b2 | 2015-02-23 | Jacob Rees-Mogg uk.org.publicwhip/member/40441 | Jacob Rees-Mogg uk.org.publicwhip/person/24926 | 5 | 2015-02-23-1aeb07b2-24926-0 |
c96b89094a1d820556b5b7f0e6be8040975fb324 | Received £9,335.23. Hours: 35 hrs in July 2014. (Registered 12 August 2014) | Directorships 1aeb07b2 | 2015-02-23 | Jacob Rees-Mogg uk.org.publicwhip/member/40441 | Jacob Rees-Mogg uk.org.publicwhip/person/24926 | 6 | 2015-02-23-1aeb07b2-24926-0 |
37578732a2dbbe22031b71729f5151435268869e | Received £9,332.76. Hours: 35 hrs in August 2014. (Registered 12 September 2014) | Directorships 1aeb07b2 | 2015-02-23 | Jacob Rees-Mogg uk.org.publicwhip/member/40441 | Jacob Rees-Mogg uk.org.publicwhip/person/24926 | 7 | 2015-02-23-1aeb07b2-24926-0 |
dd248a595a1f66849e78c2e28e61bc839f539455 | Received £9,334.33. Hours: 35 hrs in September 2014. (Registered 13 October 2014) | Directorships 1aeb07b2 | 2015-02-23 | Jacob Rees-Mogg uk.org.publicwhip/member/40441 | Jacob Rees-Mogg uk.org.publicwhip/person/24926 | 8 | 2015-02-23-1aeb07b2-24926-0 |
d825a4870d0edfdeacc2ca7d704ed14a6a9ad924 | Received £9,347.32. Hours: 35 hrs in October 2014. (Registered 3 November 2014) | Directorships 1aeb07b2 | 2015-02-23 | Jacob Rees-Mogg uk.org.publicwhip/member/40441 | Jacob Rees-Mogg uk.org.publicwhip/person/24926 | 9 | 2015-02-23-1aeb07b2-24926-0 |
504ff4591726c615d742d4a651a516db1273f2a2 | Received £9,451.53. Hours: 35 hrs in November 2014. (Registered 15 December 2014) | Directorships 1aeb07b2 | 2015-02-23 | Jacob Rees-Mogg uk.org.publicwhip/member/40441 | Jacob Rees-Mogg uk.org.publicwhip/person/24926 | 10 | 2015-02-23-1aeb07b2-24926-0 |
4d7e6ad1f71a2989de846e5a5ab2a29b0f7d602b | Received £13,500.11. Hours: 35 hrs in December 2014. (Registered 5 January 2015) | Directorships 1aeb07b2 | 2015-02-23 | Jacob Rees-Mogg uk.org.publicwhip/member/40441 | Jacob Rees-Mogg uk.org.publicwhip/person/24926 | 11 | 2015-02-23-1aeb07b2-24926-0 |
da785482c48f4ad101a24f7675a39c8880a6b2dd | Received £9,351.50. Hours: 35 hrs in January 2015. (Registered 5 February 2015) | Directorships 1aeb07b2 | 2015-02-23 | Jacob Rees-Mogg uk.org.publicwhip/member/40441 | Jacob Rees-Mogg uk.org.publicwhip/person/24926 | 12 | 2015-02-23-1aeb07b2-24926-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");