items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
8 rows where record_id = "2007-01-09-ead1ca87-10050-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 |
---|---|---|---|---|---|---|---|
1adfb97935b903231ffd64687094e5ace9995c31 | HADAW Productions and Investments Ltd, to which is payable income from: | Remunerated directorships ead1ca87 | 2007-01-09 | David Blunkett uk.org.publicwhip/member/1810 | David Blunkett uk.org.publicwhip/person/10050 | 0 | 2007-01-09-ead1ca87-10050-0 |
1bb39819f5b10f69de57dc91234fbf3914622093 | A contract with Bloomsbury for the rights to my forthcoming journals. Signature payment due (£95,001-£100,000). Further payment £60,001-£65,000) (Registered 12 October 2006) | Remunerated directorships ead1ca87 | 2007-01-09 | David Blunkett uk.org.publicwhip/member/1810 | David Blunkett uk.org.publicwhip/person/10050 | 1 | 2007-01-09-ead1ca87-10050-0 |
7938475c081e463efc6a6ae659d393548eafa16f | Making available to, and granting rights relating to, the Blunkett Tapes - Juniper Productions for Channel 4. (£10,001-£15,000) | Remunerated directorships ead1ca87 | 2007-01-09 | David Blunkett uk.org.publicwhip/member/1810 | David Blunkett uk.org.publicwhip/person/10050 | 2 | 2007-01-09-ead1ca87-10050-0 |
cb3a744066d7a734dd911ef50fca3271ce1cddf3 | Advising and taking part in the Blunkett Tapes for Juniper Productions for Channel 4. (£10,001-£15,000) | Remunerated directorships ead1ca87 | 2007-01-09 | David Blunkett uk.org.publicwhip/member/1810 | David Blunkett uk.org.publicwhip/person/10050 | 3 | 2007-01-09-ead1ca87-10050-0 |
c03a2f6f302b7a6a688465352822dd9060e24d46 | Guardian and Daily Mail joint serialisation of Blunkett Tapes. (£100,001-£105,000) | Remunerated directorships ead1ca87 | 2007-01-09 | David Blunkett uk.org.publicwhip/member/1810 | David Blunkett uk.org.publicwhip/person/10050 | 4 | 2007-01-09-ead1ca87-10050-0 |
19a4cc32b8f29999ef7bacbc795fc90d29675085 | October 2006, fee for BBC Radio 4 Book of the Week recording. (Up to £5,000) (Registered 2 November 2006) | Remunerated directorships ead1ca87 | 2007-01-09 | David Blunkett uk.org.publicwhip/member/1810 | David Blunkett uk.org.publicwhip/person/10050 | 5 | 2007-01-09-ead1ca87-10050-0 |
73766d94f07b79b7b1a70c4a90d00c0d29859271 | Further payment from Bloomsbury. (£80,001-£85,000) (Registered 30 November 2006) | Remunerated directorships ead1ca87 | 2007-01-09 | David Blunkett uk.org.publicwhip/member/1810 | David Blunkett uk.org.publicwhip/person/10050 | 6 | 2007-01-09-ead1ca87-10050-0 |
64825252ec47d66f96b61e56e7f462fac597d8b2 | I have not yet drawn down any income from this directorship. | Remunerated directorships ead1ca87 | 2007-01-09 | David Blunkett uk.org.publicwhip/member/1810 | David Blunkett uk.org.publicwhip/person/10050 | 7 | 2007-01-09-ead1ca87-10050-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");