items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
9 rows where record_id = "2009-07-08-1f359ece-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 |
---|---|---|---|---|---|---|---|
86138543d9e04b4d746aeb379352d076cc5a2f0b | Contract for twelve feature articles for The Sun newspaper. (£45,001-£50,000) (to July 2009) | Remunerated employment, office, profession etc 1f359ece | 2009-07-08 | David Blunkett uk.org.publicwhip/member/1810 | David Blunkett uk.org.publicwhip/person/10050 | 0 | 2009-07-08-1f359ece-10050-0 |
ea54e5f40a86e9a4808f0699b1ac68482cc23d3f | 25 June 2008, panellist for Insurance Times 'Question Time' - Flooding event. (Up to £5,000) Fee donated to charity. (Registered 25 June 2008) | Remunerated employment, office, profession etc 1f359ece | 2009-07-08 | David Blunkett uk.org.publicwhip/member/1810 | David Blunkett uk.org.publicwhip/person/10050 | 1 | 2009-07-08-1f359ece-10050-0 |
0405b90004914139886c21f1a07c502c1bb1a52c | 6 October 2008, article for News of the World Sport. (Up to £5,000) (Registered 3 November 2008) | Remunerated employment, office, profession etc 1f359ece | 2009-07-08 | David Blunkett uk.org.publicwhip/member/1810 | David Blunkett uk.org.publicwhip/person/10050 | 2 | 2009-07-08-1f359ece-10050-0 |
105dc121fedecc39762d66d216be49ef1b6d8c4e | 16 October 2008, speaking engagement to UK Oracle User Group. (£5,001-£10,000) (Registered 3 November 2008) | Remunerated employment, office, profession etc 1f359ece | 2009-07-08 | David Blunkett uk.org.publicwhip/member/1810 | David Blunkett uk.org.publicwhip/person/10050 | 3 | 2009-07-08-1f359ece-10050-0 |
900e07f331e03025093411a0e04a1a966d71d7df | 5 November 2008, speaking engagement for Essex Independent Care Association. (Up to £5,000) (Registered 1 December 2008) | Remunerated employment, office, profession etc 1f359ece | 2009-07-08 | David Blunkett uk.org.publicwhip/member/1810 | David Blunkett uk.org.publicwhip/person/10050 | 4 | 2009-07-08-1f359ece-10050-0 |
0b99bba3843524f6e6e56b3aadf7a6e5171243a4 | Times Newspaper occasional advice column. (Up to £5,000) | Remunerated employment, office, profession etc 1f359ece | 2009-07-08 | David Blunkett uk.org.publicwhip/member/1810 | David Blunkett uk.org.publicwhip/person/10050 | 5 | 2009-07-08-1f359ece-10050-0 |
ae4673d8fd9c706c6ce6cd1b42f41b0aa7fa5466 | May 2009, speaking engagement to the National Information Security Conference. (Up to £5,000) (Registered 9 June 2009) | Remunerated employment, office, profession etc 1f359ece | 2009-07-08 | David Blunkett uk.org.publicwhip/member/1810 | David Blunkett uk.org.publicwhip/person/10050 | 6 | 2009-07-08-1f359ece-10050-0 |
029ecb3d348c8d92653423af25b150d9de854e4e | June 2009, speaking engagement for The London Speaker Bureau. (Up to £5,000) (Registered 9 June 2009) | Remunerated employment, office, profession etc 1f359ece | 2009-07-08 | David Blunkett uk.org.publicwhip/member/1810 | David Blunkett uk.org.publicwhip/person/10050 | 7 | 2009-07-08-1f359ece-10050-0 |
142b75e68d10e6b577d2fc00184b6d9b21d32596 | 28 June 2009, article for Sunday Times. (Up to £5,000) (Registered 30 June 2009) | Remunerated employment, office, profession etc 1f359ece | 2009-07-08 | David Blunkett uk.org.publicwhip/member/1810 | David Blunkett uk.org.publicwhip/person/10050 | 8 | 2009-07-08-1f359ece-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");