items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
4 rows where record_id = "2014-06-16-1f359ece-10088-0" sorted by date descending
This data as json, CSV (advanced)
Suggested facets: date (date)
hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
2952289cae9e7dd6ecfecc2f75ffa391065e9a0e | Queen’s Counsel. (Resumed practice at the Bar with effect from 1 January 2008.) Payments are made through Faculty Services Ltd, Advocates Library, Parliament House, Edinburgh EH1 1RF, and the payment figure is subject to deductions to reflect overheads due to the Faculty of Advocates. | Remunerated employment, office, profession etc 1f359ece | 2014-06-16 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 0 | 2014-06-16-1f359ece-10088-0 |
7feb71bac573300733fa97de6a7f4f30b5b2324f | Payments received from BBC for appearances on ‘Any Questions’. Address: BBC Contributor Payments, PO Box 480, Manchester M14 0EL: | Remunerated employment, office, profession etc 1f359ece | 2014-06-16 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 1 | 2014-06-16-1f359ece-10088-0 |
83d79cf27bb5a62ce2f62ff4985ca72685a5816a | Payment of £150 received on 30 September 2013 for appearance on 20 September 2013. Hours: 5 hrs. (Registered 14 October 2013) | Remunerated employment, office, profession etc 1f359ece | 2014-06-16 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 2 | 2014-06-16-1f359ece-10088-0 |
a6ea17bd88c5df6164253993cbec80904b266c95 | Payment of £150 received on 23 May 2014 for appearance on 16 May 2014. Hours: 5 hrs. (Registered 5 June 2014) | Remunerated employment, office, profession etc 1f359ece | 2014-06-16 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 3 | 2014-06-16-1f359ece-10088-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");