items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
13 rows where person_id = "uk.org.publicwhip/person/10451" and sort_order = 8 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 |
---|---|---|---|---|---|---|---|
d13a0eb42d576ba6dfbf086d9d5a319860caefaa | £900 for writing an article. (Registered 9 June 2009) | Remunerated employment, office, profession, etc. f3967f4d | 2010-04-12 | Chris Mullin uk.org.publicwhip/member/1856 | Chris Mullin uk.org.publicwhip/person/10451 | 8 | 2010-04-12-f3967f4d-10451-0 |
cd924ade875ba8d47b900120565e513ec0429cba | £900 for writing an article. (Registered 9 June 2009) | Remunerated employment, office, profession, etc. f3967f4d | 2010-03-24 | Chris Mullin uk.org.publicwhip/member/1856 | Chris Mullin uk.org.publicwhip/person/10451 | 8 | 2010-03-24-f3967f4d-10451-0 |
86d737ab341d53d417667131f7ea1e1d00d662b9 | £900 for writing an article. (Registered 9 June 2009) | Remunerated employment, office, profession, etc. f3967f4d | 2010-03-10 | Chris Mullin uk.org.publicwhip/member/1856 | Chris Mullin uk.org.publicwhip/person/10451 | 8 | 2010-03-10-f3967f4d-10451-0 |
d67c0c754b33a69a66dec51b903f718b0922e9b0 | £900 for writing an article. (Registered 9 June 2009) | Remunerated employment, office, profession, etc. f3967f4d | 2010-02-24 | Chris Mullin uk.org.publicwhip/member/1856 | Chris Mullin uk.org.publicwhip/person/10451 | 8 | 2010-02-24-f3967f4d-10451-0 |
0b02c5ae227a2a322e7d0e0fbfd4a8aac1babe5f | £900 for writing an article. (Registered 9 June 2009) | Remunerated employment, office, profession, etc. f3967f4d | 2010-02-03 | Chris Mullin uk.org.publicwhip/member/1856 | Chris Mullin uk.org.publicwhip/person/10451 | 8 | 2010-02-03-f3967f4d-10451-0 |
65a4d89e4c1e1c76a98f5af4ff9e3301c64fc66d | £900 for writing an article. (Registered 9 June 2009) | Remunerated employment, office, profession, etc. f3967f4d | 2010-01-06 | Chris Mullin uk.org.publicwhip/member/1856 | Chris Mullin uk.org.publicwhip/person/10451 | 8 | 2010-01-06-f3967f4d-10451-0 |
cc083058c669bf8395d8d586d1506b21ec770971 | £900 for writing an article. (Registered 9 June 2009) | Remunerated employment, office, profession, etc. f3967f4d | 2009-12-10 | Chris Mullin uk.org.publicwhip/member/1856 | Chris Mullin uk.org.publicwhip/person/10451 | 8 | 2009-12-10-f3967f4d-10451-0 |
92ad26f3ec176b7d85f2c23835426332845c4007 | £900 for writing an article. (Registered 9 June 2009) | Remunerated employment, office, profession, etc. f3967f4d | 2009-11-25 | Chris Mullin uk.org.publicwhip/member/1856 | Chris Mullin uk.org.publicwhip/person/10451 | 8 | 2009-11-25-f3967f4d-10451-0 |
9581ad23f10c8f5071c0567718ff7e140bbedf90 | £900 for writing an article. (Registered 9 June 2009) | Remunerated employment, office, profession, etc. f3967f4d | 2009-11-11 | Chris Mullin uk.org.publicwhip/member/1856 | Chris Mullin uk.org.publicwhip/person/10451 | 8 | 2009-11-11-f3967f4d-10451-0 |
ccdb6f539414f065a7857082bdc0d3afb03a37ed | £900 for writing an article. (Registered 9 June 2009) | Remunerated employment, office, profession, etc. f3967f4d | 2009-10-28 | Chris Mullin uk.org.publicwhip/member/1856 | Chris Mullin uk.org.publicwhip/person/10451 | 8 | 2009-10-28-f3967f4d-10451-0 |
5f48c8586a22d80040503cd1d8b3ac475604f45b | £900 for writing an article. (Registered 9 June 2009) | Remunerated employment, office, profession, etc. f3967f4d | 2009-10-14 | Chris Mullin uk.org.publicwhip/member/1856 | Chris Mullin uk.org.publicwhip/person/10451 | 8 | 2009-10-14-f3967f4d-10451-0 |
e124cb764e3d5ba268b450a14e803232aceb4567 | £900 for writing an article. (Registered 9 June 2009) | Remunerated employment, office, profession, etc. f3967f4d | 2009-09-02 | Chris Mullin uk.org.publicwhip/member/1856 | Chris Mullin uk.org.publicwhip/person/10451 | 8 | 2009-09-02-f3967f4d-10451-0 |
682722f8b7605dfe5259c39025fe52571eef43b5 | Payment for an article in the London Review of Books. (Actual £900) (Up to £5,000) (Registered 22 June 2009) | Remunerated employment, office, profession, etc. f3967f4d | 2009-07-21 | Chris Mullin uk.org.publicwhip/member/1856 | Chris Mullin uk.org.publicwhip/person/10451 | 8 | 2009-07-21-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");