items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
7 rows where member_id = "uk.org.publicwhip/member/639" sorted by date descending
This data as json, CSV (advanced)
Suggested facets: item, category_id, date, sort_order, record_id, date (date)
hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
ff4645f6c25959ad4e5b3dfc1209d4a95b7bbd6c | Occasional broadcasting and lecturing fees and fees for articles. | Remunerated employment, office, profession, etc. f3967f4d | 2001-05-14 | Alan Williams uk.org.publicwhip/member/639 | Alan Williams uk.org.publicwhip/person/10639 | 0 | 2001-05-14-f3967f4d-10639-0 |
759dc69ab0f6575a96fb359764540b95bdc4f6ee | Lecturer at the Civil Service College. (£1-£1,000) | Remunerated employment, office, profession, etc. f3967f4d | 2001-05-14 | Alan Williams uk.org.publicwhip/member/639 | Alan Williams uk.org.publicwhip/person/10639 | 1 | 2001-05-14-f3967f4d-10639-0 |
55bbded17ad54a563836940d6c0375e4cbef2654 | I have a consultancy arrangement with The Mail on Sunday, to advise them in connection with the publication of a special supplement this will also involve the writing of an article for the newspaper. (£1,001-£5,000) | Remunerated employment, office, profession, etc. f3967f4d | 2001-05-14 | Alan Williams uk.org.publicwhip/member/639 | Alan Williams uk.org.publicwhip/person/10639 | 2 | 2001-05-14-f3967f4d-10639-0 |
9b8b236323d08448d286e8a2cf2481cb35cb9740 | 19 April 2000, I attended for one morning the British Russia Chamber of Commerce conference entitled "Russia 2000: A New Reality" at the QE II Conference Centre, at the invitation of the Russo-British Chamber of Commerce. (Registered 19 April 2000) | Gifts, benefits and hospitality (UK) 84642823 | 2001-05-14 | Alan Williams uk.org.publicwhip/member/639 | Alan Williams uk.org.publicwhip/person/10639 | 0 | 2001-05-14-84642823-10639-0 |
eff77dee8bb5957951551f4f7b09c90c7166c783 | Occasional broadcasting and lecturing fees and fees for articles. | Remunerated employment, office, profession, etc. f3967f4d | 2000-11-10 | Alan Williams uk.org.publicwhip/member/639 | Alan Williams uk.org.publicwhip/person/10639 | 0 | 2000-11-10-f3967f4d-10639-0 |
7050696c26cb7d650a0d3f7e505318d5cc7895d5 | Lecturer at the Civil Service College. (£1-£1,000) | Remunerated employment, office, profession, etc. f3967f4d | 2000-11-10 | Alan Williams uk.org.publicwhip/member/639 | Alan Williams uk.org.publicwhip/person/10639 | 1 | 2000-11-10-f3967f4d-10639-0 |
c7f81ea729846387f0652cc0c2678097779fe7d4 | 19 April 2000, I attended for one morning the British Russia Chamber of Commerce conference entitled "Russia 2000: A New Reality" at the QE II Conference Centre, at the invitation of the Russo-British Chamber of Commerce. (Registered 19 April 2000) | Gifts, benefits and hospitality (UK) 84642823 | 2000-11-10 | Alan Williams uk.org.publicwhip/member/639 | Alan Williams uk.org.publicwhip/person/10639 | 0 | 2000-11-10-84642823-10639-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");