items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
13 rows where record_id = "2015-03-09-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 |
---|---|---|---|---|---|---|---|
e6cf177e76e91a09659efdf8662006908ec6ad33 | Somerset Capital Management LLP (partner), 146 Buckingham Palace Road, London SW1W 9TR; investment management | Directorships 1aeb07b2 | 2015-03-09 | Jacob Rees-Mogg uk.org.publicwhip/member/40441 | Jacob Rees-Mogg uk.org.publicwhip/person/24926 | 0 | 2015-03-09-1aeb07b2-24926-0 |
4784f1746b13a56f3dce1c5cb706c051e7b6a364 | Received £9,092.89. Hours: 35 hrs in February 2014 . (Registered 14 March 2014) | Directorships 1aeb07b2 | 2015-03-09 | Jacob Rees-Mogg uk.org.publicwhip/member/40441 | Jacob Rees-Mogg uk.org.publicwhip/person/24926 | 1 | 2015-03-09-1aeb07b2-24926-0 |
ec008429589a2419e9d91e124ae7e17e6e074efe | Received £9,148.19. Hours: 35 hrs in March 2014 . (Registered 14 April 2014) | Directorships 1aeb07b2 | 2015-03-09 | Jacob Rees-Mogg uk.org.publicwhip/member/40441 | Jacob Rees-Mogg uk.org.publicwhip/person/24926 | 2 | 2015-03-09-1aeb07b2-24926-0 |
1c10f11729bc40b92ba7d0cff02accc35faf7275 | Received £9,095.82. Hours: 35 hours in April 2014. (Registered 9 May 2014) | Directorships 1aeb07b2 | 2015-03-09 | Jacob Rees-Mogg uk.org.publicwhip/member/40441 | Jacob Rees-Mogg uk.org.publicwhip/person/24926 | 3 | 2015-03-09-1aeb07b2-24926-0 |
648aed0bc944f10e49bc3557028d1dabe33e8597 | Received £9,095.93. Hours: 35 hrs in May 2014. (Registered 6 June 2014) | Directorships 1aeb07b2 | 2015-03-09 | Jacob Rees-Mogg uk.org.publicwhip/member/40441 | Jacob Rees-Mogg uk.org.publicwhip/person/24926 | 4 | 2015-03-09-1aeb07b2-24926-0 |
c71ca820e3c29e2398805cab3ee02534839a5f75 | Received £9,095.14. Hours: 35 hrs in June 2014. (Registered 14 July 2014) | Directorships 1aeb07b2 | 2015-03-09 | Jacob Rees-Mogg uk.org.publicwhip/member/40441 | Jacob Rees-Mogg uk.org.publicwhip/person/24926 | 5 | 2015-03-09-1aeb07b2-24926-0 |
312eca30765862dddd876a7f5575c765c204d02e | Received £9,335.23. Hours: 35 hrs in July 2014. (Registered 12 August 2014) | Directorships 1aeb07b2 | 2015-03-09 | Jacob Rees-Mogg uk.org.publicwhip/member/40441 | Jacob Rees-Mogg uk.org.publicwhip/person/24926 | 6 | 2015-03-09-1aeb07b2-24926-0 |
9ad7a667e6a14e22d77521f9f14850317bcb16a8 | Received £9,332.76. Hours: 35 hrs in August 2014. (Registered 12 September 2014) | Directorships 1aeb07b2 | 2015-03-09 | Jacob Rees-Mogg uk.org.publicwhip/member/40441 | Jacob Rees-Mogg uk.org.publicwhip/person/24926 | 7 | 2015-03-09-1aeb07b2-24926-0 |
8bd76d659d04af07a9f5ef36161d882fbaac8c23 | Received £9,334.33. Hours: 35 hrs in September 2014. (Registered 13 October 2014) | Directorships 1aeb07b2 | 2015-03-09 | Jacob Rees-Mogg uk.org.publicwhip/member/40441 | Jacob Rees-Mogg uk.org.publicwhip/person/24926 | 8 | 2015-03-09-1aeb07b2-24926-0 |
2786eee1b6d64f70443bad1d56b924c2b51dfbc0 | Received £9,347.32. Hours: 35 hrs in October 2014. (Registered 3 November 2014) | Directorships 1aeb07b2 | 2015-03-09 | Jacob Rees-Mogg uk.org.publicwhip/member/40441 | Jacob Rees-Mogg uk.org.publicwhip/person/24926 | 9 | 2015-03-09-1aeb07b2-24926-0 |
fe7394a1fe15e35ddd581bccf322712e7678ecf3 | Received £9,451.53. Hours: 35 hrs in November 2014. (Registered 15 December 2014) | Directorships 1aeb07b2 | 2015-03-09 | Jacob Rees-Mogg uk.org.publicwhip/member/40441 | Jacob Rees-Mogg uk.org.publicwhip/person/24926 | 10 | 2015-03-09-1aeb07b2-24926-0 |
1b479a778641ed00dc9cbc1329701fa1eddf6602 | Received £13,500.11. Hours: 35 hrs in December 2014. (Registered 5 January 2015) | Directorships 1aeb07b2 | 2015-03-09 | Jacob Rees-Mogg uk.org.publicwhip/member/40441 | Jacob Rees-Mogg uk.org.publicwhip/person/24926 | 11 | 2015-03-09-1aeb07b2-24926-0 |
692a4b6b5dfa754d0932d2aeb83cb64e226214fb | Received £9,351.50. Hours: 35 hrs in January 2015. (Registered 5 February 2015) | Directorships 1aeb07b2 | 2015-03-09 | Jacob Rees-Mogg uk.org.publicwhip/member/40441 | Jacob Rees-Mogg uk.org.publicwhip/person/24926 | 12 | 2015-03-09-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");