items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
8 rows where record_id = "2001-05-14-0a4a155f-10134-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 |
---|---|---|---|---|---|---|---|
536bf797d064582fd79dd0c886946666c50a75eb | Journalism and other writing, broadcasting and lecturing. | Remunerated employment, office, profession etc. 0a4a155f | 2001-05-14 | Patrick Cormack uk.org.publicwhip/member/134 | Patrick Cormack uk.org.publicwhip/person/10134 | 0 | 2001-05-14-0a4a155f-10134-0 |
f802b90d4a86596162988e1c80a105d6973df9a2 | Quarterly article for First Magazine, entitled Parliamentary Round-up. (£1-£1,000) | Remunerated employment, office, profession etc. 0a4a155f | 2001-05-14 | Patrick Cormack uk.org.publicwhip/member/134 | Patrick Cormack uk.org.publicwhip/person/10134 | 1 | 2001-05-14-0a4a155f-10134-0 |
471d5553d4590b93633788416e0170f77acf9996 | President (International Affairs) of First Magazine. | Remunerated employment, office, profession etc. 0a4a155f | 2001-05-14 | Patrick Cormack uk.org.publicwhip/member/134 | Patrick Cormack uk.org.publicwhip/person/10134 | 2 | 2001-05-14-0a4a155f-10134-0 |
e4fc538de639c75a93203e14183eb25729691177 | Programme adviser to the Catholic University of America. (The fee includes the cost of secretarial assistance.) (£1,001-£5,000) | Remunerated employment, office, profession etc. 0a4a155f | 2001-05-14 | Patrick Cormack uk.org.publicwhip/member/134 | Patrick Cormack uk.org.publicwhip/person/10134 | 3 | 2001-05-14-0a4a155f-10134-0 |
8de3c88b131e0cf370c30252ba3c83107b089d9e | Editor of the House Magazine. (£15,001-£20,000) | Remunerated employment, office, profession etc. 0a4a155f | 2001-05-14 | Patrick Cormack uk.org.publicwhip/member/134 | Patrick Cormack uk.org.publicwhip/person/10134 | 4 | 2001-05-14-0a4a155f-10134-0 |
d0159b20809cafe97f901ee0cf454e70fa01441b | Adviser to the publisher of the House Magazine on his other publications, including the Church of England Newspaper. | Remunerated employment, office, profession etc. 0a4a155f | 2001-05-14 | Patrick Cormack uk.org.publicwhip/member/134 | Patrick Cormack uk.org.publicwhip/person/10134 | 5 | 2001-05-14-0a4a155f-10134-0 |
74d1778dd1a8b0e87cc2f8742ba591607a9bcf92 | Public affairs and parliamentary adviser to Machinery Users' Association. (£5,001-£10,000) | Remunerated employment, office, profession etc. 0a4a155f | 2001-05-14 | Patrick Cormack uk.org.publicwhip/member/134 | Patrick Cormack uk.org.publicwhip/person/10134 | 6 | 2001-05-14-0a4a155f-10134-0 |
5a27f86963a00b077b1028651cf82c55454cebc5 | Heritage adviser to Linford-Bridgeman Ltd.; conservation and restoration company. | Remunerated employment, office, profession etc. 0a4a155f | 2001-05-14 | Patrick Cormack uk.org.publicwhip/member/134 | Patrick Cormack uk.org.publicwhip/person/10134 | 7 | 2001-05-14-0a4a155f-10134-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");