items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
16 rows where person_id = "uk.org.publicwhip/person/10451" and sort_order = 5 sorted by date descending
This data as json, CSV (advanced)
Suggested facets: item, date (date)
hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
39a9d5d1631450e1d56728569c9330691e52b4a1 | Fee from Dan Films for an option on the TV rights for 'A Very British Coup'. (Actual £1,750) (Up to £5,000) (Registered 18 May 2009) | Remunerated employment, office, profession, etc. f3967f4d | 2010-04-12 | Chris Mullin uk.org.publicwhip/member/1856 | Chris Mullin uk.org.publicwhip/person/10451 | 5 | 2010-04-12-f3967f4d-10451-0 |
c3499377a57cd6283f5401a7eb89afd967a177e6 | Fee from Dan Films for an option on the TV rights for 'A Very British Coup'. (Actual £1,750) (Up to £5,000) (Registered 18 May 2009) | Remunerated employment, office, profession, etc. f3967f4d | 2010-03-24 | Chris Mullin uk.org.publicwhip/member/1856 | Chris Mullin uk.org.publicwhip/person/10451 | 5 | 2010-03-24-f3967f4d-10451-0 |
429df9ab26ce58ca3dab2d4c624239059ef820b7 | Fee from Dan Films for an option on the TV rights for 'A Very British Coup'. (Actual £1,750) (Up to £5,000) (Registered 18 May 2009) | Remunerated employment, office, profession, etc. f3967f4d | 2010-03-10 | Chris Mullin uk.org.publicwhip/member/1856 | Chris Mullin uk.org.publicwhip/person/10451 | 5 | 2010-03-10-f3967f4d-10451-0 |
47223e8c567de8d8adaf8e4908bd3e24faef6abf | Fee from Dan Films for an option on the TV rights for 'A Very British Coup'. (Actual £1,750) (Up to £5,000) (Registered 18 May 2009) | Remunerated employment, office, profession, etc. f3967f4d | 2010-02-24 | Chris Mullin uk.org.publicwhip/member/1856 | Chris Mullin uk.org.publicwhip/person/10451 | 5 | 2010-02-24-f3967f4d-10451-0 |
752c4dceaa58cf5e351e5e5b432e6737c91c1f3e | Fee from Dan Films for an option on the TV rights for 'A Very British Coup'. (Actual £1,750) (Up to £5,000) (Registered 18 May 2009) | Remunerated employment, office, profession, etc. f3967f4d | 2010-02-03 | Chris Mullin uk.org.publicwhip/member/1856 | Chris Mullin uk.org.publicwhip/person/10451 | 5 | 2010-02-03-f3967f4d-10451-0 |
6268f8ce56b5749936d19cfa3a58224032cdd37b | Fee from Profile Books, an advance on a new edition of 'A Very British Coup'. (Actual £1,000) (Up to £5,000) (Registered 18 May 2009) | Remunerated employment, office, profession, etc. f3967f4d | 2010-01-06 | Chris Mullin uk.org.publicwhip/member/1856 | Chris Mullin uk.org.publicwhip/person/10451 | 5 | 2010-01-06-f3967f4d-10451-0 |
940edb7bf8d6ffd9f45132d71438c095fdb3dca1 | Fee from Profile Books, an advance on a new edition of 'A Very British Coup'. (Actual £1,000) (Up to £5,000) (Registered 18 May 2009) | Remunerated employment, office, profession, etc. f3967f4d | 2009-12-10 | Chris Mullin uk.org.publicwhip/member/1856 | Chris Mullin uk.org.publicwhip/person/10451 | 5 | 2009-12-10-f3967f4d-10451-0 |
8dae62033bf3fa83edfa02fd40aac1a122349195 | Fee from Profile Books, an advance on a new edition of 'A Very British Coup'. (Actual £1,000) (Up to £5,000) (Registered 18 May 2009) | Remunerated employment, office, profession, etc. f3967f4d | 2009-11-25 | Chris Mullin uk.org.publicwhip/member/1856 | Chris Mullin uk.org.publicwhip/person/10451 | 5 | 2009-11-25-f3967f4d-10451-0 |
d6ece6ba92fe60921ffdfa2cddd71ae9bf460d3e | Fee from Profile Books, an advance on a new edition of 'A Very British Coup'. (Actual £1,000) (Up to £5,000) (Registered 18 May 2009) | Remunerated employment, office, profession, etc. f3967f4d | 2009-11-11 | Chris Mullin uk.org.publicwhip/member/1856 | Chris Mullin uk.org.publicwhip/person/10451 | 5 | 2009-11-11-f3967f4d-10451-0 |
eda575dd497e180940c2a639da4bf9c6a9a7f95a | Fee from Profile Books, an advance on a new edition of 'A Very British Coup'. (Actual £1,000) (Up to £5,000) (Registered 18 May 2009) | Remunerated employment, office, profession, etc. f3967f4d | 2009-10-28 | Chris Mullin uk.org.publicwhip/member/1856 | Chris Mullin uk.org.publicwhip/person/10451 | 5 | 2009-10-28-f3967f4d-10451-0 |
5fd19d0b877d9a6aa4e15cfe731a26e0f380317c | Fee from Profile Books, an advance on a new edition of 'A Very British Coup'. (Actual £1,000) (Up to £5,000) (Registered 18 May 2009) | Remunerated employment, office, profession, etc. f3967f4d | 2009-10-14 | Chris Mullin uk.org.publicwhip/member/1856 | Chris Mullin uk.org.publicwhip/person/10451 | 5 | 2009-10-14-f3967f4d-10451-0 |
d4742d7b26b0a902a117cc579b63bd5b4ddd2651 | Fee from Profile Books, an advance on a new edition of 'A Very British Coup'. (Actual £1,000) (Up to £5,000) (Registered 18 May 2009) | Remunerated employment, office, profession, etc. f3967f4d | 2009-09-02 | Chris Mullin uk.org.publicwhip/member/1856 | Chris Mullin uk.org.publicwhip/person/10451 | 5 | 2009-09-02-f3967f4d-10451-0 |
7241b60e676158a07e554f9a29b4a0a83119de51 | Fee from Profile Books, an advance on a new edition of 'A Very British Coup'. (Actual £1,000) (Up to £5,000) (Registered 18 May 2009) | Remunerated employment, office, profession, etc. f3967f4d | 2009-07-21 | Chris Mullin uk.org.publicwhip/member/1856 | Chris Mullin uk.org.publicwhip/person/10451 | 5 | 2009-07-21-f3967f4d-10451-0 |
6164730851dbf657d5e24b8c21667d29d61757b4 | Payment from BBC Radio 4 for the serialisation of 'A View from the Foothills'. (Actual £2,100) (Up to £5,000) (Registered 22 May 2009) | Remunerated employment, office, profession, etc. f3967f4d | 2009-07-08 | Chris Mullin uk.org.publicwhip/member/1856 | Chris Mullin uk.org.publicwhip/person/10451 | 5 | 2009-07-08-f3967f4d-10451-0 |
993c5494638c3463a0cfd74d0e4b7795da9249e3 | Payment from BBC Radio 4 for the serialisation of 'A View from the Foothills'. (Actual £2,100) (Up to £5,000) (Registered 22 May 2009) | Remunerated employment, office, profession, etc. f3967f4d | 2009-06-24 | Chris Mullin uk.org.publicwhip/member/1856 | Chris Mullin uk.org.publicwhip/person/10451 | 5 | 2009-06-24-f3967f4d-10451-0 |
30ed4f1a1a0300190ba4e9709930eeb2e4220c9d | Payment from BBC Radio 4 for the serialisation of 'A View from the Foothills'. (Actual £2,100) (Up to £5,000) (Registered 22 May 2009) | Remunerated employment, office, profession, etc. f3967f4d | 2009-06-10 | Chris Mullin uk.org.publicwhip/member/1856 | Chris Mullin uk.org.publicwhip/person/10451 | 5 | 2009-06-10-f3967f4d-10451-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");