items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
10 rows where record_id = "2008-04-23-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 |
---|---|---|---|---|---|---|---|
7a74c2a39876bf3cd7bf19a731a414d6395725c5 | HADAW Productions and Investments Ltd, to which is payable income from: | Remunerated directorships ead1ca87 | 2008-04-23 | David Blunkett uk.org.publicwhip/member/1810 | David Blunkett uk.org.publicwhip/person/10050 | 0 | 2008-04-23-ead1ca87-10050-0 |
48914aeb3c254358c5f3e0c09eac572d6c44cb96 | Making available to, and granting rights relating to, the Blunkett Tapes - Juniper Productions for Channel 4. (£10,001-£15,000) | Remunerated directorships ead1ca87 | 2008-04-23 | David Blunkett uk.org.publicwhip/member/1810 | David Blunkett uk.org.publicwhip/person/10050 | 1 | 2008-04-23-ead1ca87-10050-0 |
e545548aa2ec32ad3ee90b32ed42ceece74ddced | Advising and taking part in the Blunkett Tapes for Juniper Productions for Channel 4. (£10,001-£15,000) | Remunerated directorships ead1ca87 | 2008-04-23 | David Blunkett uk.org.publicwhip/member/1810 | David Blunkett uk.org.publicwhip/person/10050 | 2 | 2008-04-23-ead1ca87-10050-0 |
a20166efe2b69bff46c3dc44d078810c8c218b72 | Guardian and Daily Mail joint serialisation of Blunkett Tapes. (£100,001-£105,000) | Remunerated directorships ead1ca87 | 2008-04-23 | David Blunkett uk.org.publicwhip/member/1810 | David Blunkett uk.org.publicwhip/person/10050 | 3 | 2008-04-23-ead1ca87-10050-0 |
2da5337bda863bdb543ec65c613009c145c59ad6 | April 2007, preparing for presentation for Channel 5 programme for 'Big Ideas That Changed the World' series. (Up to £5,000) (Registered 24 April 2007) | Remunerated directorships ead1ca87 | 2008-04-23 | David Blunkett uk.org.publicwhip/member/1810 | David Blunkett uk.org.publicwhip/person/10050 | 4 | 2008-04-23-ead1ca87-10050-0 |
0289eb0b32c61c247598394b7e49553fd8686ad2 | Chair of Commission on School Transport - First Group Ltd (phased payments £20,001-£25,000) | Remunerated directorships ead1ca87 | 2008-04-23 | David Blunkett uk.org.publicwhip/member/1810 | David Blunkett uk.org.publicwhip/person/10050 | 5 | 2008-04-23-ead1ca87-10050-0 |
c9a2d3f3dd7a0a2c3773a01d77da9f1d120ab944 | Chair of Advisory Board which will recommend the distribution of funds to charities involved in protecting children (primarily in relation to the internet), funded by Crisp Thinking Ltd, an internet software security provider. Advice also provided to Crisp Thinking on extending protection for children. (£25,001-£30,000) | Remunerated directorships ead1ca87 | 2008-04-23 | David Blunkett uk.org.publicwhip/member/1810 | David Blunkett uk.org.publicwhip/person/10050 | 6 | 2008-04-23-ead1ca87-10050-0 |
f5405059faae6a6762ae8dba31a73d78f91cdd53 | Payment from Bloomsbury Publishing for revised edition of "The Blunkett Tapes". (£55,001-£60,000) (Registered 2 April 2008) | Remunerated directorships ead1ca87 | 2008-04-23 | David Blunkett uk.org.publicwhip/member/1810 | David Blunkett uk.org.publicwhip/person/10050 | 7 | 2008-04-23-ead1ca87-10050-0 |
7ca4727d6bcba57c7b7e38ce72bc8b3f003e81ca | Payment from Shine North Productions for Channel 5 production on young offenders. (Amount tba) (Registered 2 April 2008) | Remunerated directorships ead1ca87 | 2008-04-23 | David Blunkett uk.org.publicwhip/member/1810 | David Blunkett uk.org.publicwhip/person/10050 | 8 | 2008-04-23-ead1ca87-10050-0 |
0dce972fd871d03ee183a1c17ad32dfcd96a7ad8 | I have not yet drawn down any income from this directorship. | Remunerated directorships ead1ca87 | 2008-04-23 | David Blunkett uk.org.publicwhip/member/1810 | David Blunkett uk.org.publicwhip/person/10050 | 9 | 2008-04-23-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");