items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
8 rows where record_id = "2007-02-27-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 |
---|---|---|---|---|---|---|---|
46f7e0dc72e30dbb93c064e820b8bc5e252efac6 | HADAW Productions and Investments Ltd, to which is payable income from: | Remunerated directorships ead1ca87 | 2007-02-27 | David Blunkett uk.org.publicwhip/member/1810 | David Blunkett uk.org.publicwhip/person/10050 | 0 | 2007-02-27-ead1ca87-10050-0 |
474476e295fb968a517f152be9424560df04b555 | 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-02-27 | David Blunkett uk.org.publicwhip/member/1810 | David Blunkett uk.org.publicwhip/person/10050 | 1 | 2007-02-27-ead1ca87-10050-0 |
804e6bc8357237b5e12ed4ae052129c63378ce36 | Making available to, and granting rights relating to, the Blunkett Tapes - Juniper Productions for Channel 4. (£10,001-£15,000) | Remunerated directorships ead1ca87 | 2007-02-27 | David Blunkett uk.org.publicwhip/member/1810 | David Blunkett uk.org.publicwhip/person/10050 | 2 | 2007-02-27-ead1ca87-10050-0 |
169e5343dda4e91963408fbfe8656382d54d36b0 | Advising and taking part in the Blunkett Tapes for Juniper Productions for Channel 4. (£10,001-£15,000) | Remunerated directorships ead1ca87 | 2007-02-27 | David Blunkett uk.org.publicwhip/member/1810 | David Blunkett uk.org.publicwhip/person/10050 | 3 | 2007-02-27-ead1ca87-10050-0 |
d61af976b02e21945c417598e7b88def9dd1270f | Guardian and Daily Mail joint serialisation of Blunkett Tapes. (£100,001-£105,000) | Remunerated directorships ead1ca87 | 2007-02-27 | David Blunkett uk.org.publicwhip/member/1810 | David Blunkett uk.org.publicwhip/person/10050 | 4 | 2007-02-27-ead1ca87-10050-0 |
2b2979906f6a7f6547eaa83d560337fe3c7f26d6 | October 2006, fee for BBC Radio 4 Book of the Week recording. (Up to £5,000) (Registered 2 November 2006) | Remunerated directorships ead1ca87 | 2007-02-27 | David Blunkett uk.org.publicwhip/member/1810 | David Blunkett uk.org.publicwhip/person/10050 | 5 | 2007-02-27-ead1ca87-10050-0 |
058dbb532bdf9ad0bf53c3988a170f106131f16b | Further payment from Bloomsbury. (£80,001-£85,000) (Registered 30 November 2006) | Remunerated directorships ead1ca87 | 2007-02-27 | David Blunkett uk.org.publicwhip/member/1810 | David Blunkett uk.org.publicwhip/person/10050 | 6 | 2007-02-27-ead1ca87-10050-0 |
da33f161f4c72bf24e9cfb83c246e627832de577 | I have not yet drawn down any income from this directorship. | Remunerated directorships ead1ca87 | 2007-02-27 | David Blunkett uk.org.publicwhip/member/1810 | David Blunkett uk.org.publicwhip/person/10050 | 7 | 2007-02-27-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");