items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
5 rows where record_id = "2013-08-27-1f359ece-24773-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 |
---|---|---|---|---|---|---|---|
90bc507565d46d9b3becfdaaa4a6676e65f4d6d7 | Payment of £2,000 from Redburn Partners LLP, 75 King William Street, London EC4N 7BE, for speaking at the Redburn Banking Recovery Conference. Hours: 2 hrs. (Registered 20 August 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-08-27 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 0 | 2013-08-27-1f359ece-24773-0 |
c210cd4aad449493689a87e34f0b64d89c287d2a | Payment of £250 from Daily Mail, Northcliffe House, 2 Derry Street, London W8 5TT, for an article. Address of payer: A&N Media Finance Service, PO Box 6795, St George Street, Leicester LE1 1ZP. Hours: 2 hrs. (Registered 21 August 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-08-27 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 1 | 2013-08-27-1f359ece-24773-0 |
1d71c972eee4d5c2227bd706ee7c0da1d4578fb0 | Payments from Biteback Publishing, 3 Albert Embankment, London SE1 7SP for royalties from sales of book (which I co-authored): | Remunerated employment, office, profession etc 1f359ece | 2013-08-27 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 2 | 2013-08-27-1f359ece-24773-0 |
0674ceac5e2aeaaeaf68b95b321a73538bb2dd39 | Payment of £2,761.39 received for sales of book during the period 1 August 2011 to 28 September 2012. Hours: impossible to estimate accurately. (Registered 28 September 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-08-27 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 3 | 2013-08-27-1f359ece-24773-0 |
3ad3600d396dcdc6043f637b11a8875973ff344a | Payment of £409 received for sales of book during the period 29 September 2012 to 31 May 2013. Hours: impossible to estimate accurately. (Registered 28 June 2013) | Remunerated employment, office, profession etc 1f359ece | 2013-08-27 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 4 | 2013-08-27-1f359ece-24773-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");