items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
9 rows where record_id = "2002-05-14-0a4a155f-10134-0" sorted by sort_order
This data as json, CSV (advanced)
date (date) 1 ✖
hash | item | category_id | date | member_id | person_id | sort_order ▼ | record_id |
---|---|---|---|---|---|---|---|
f73fbd41f14fd02854a094ea369229b870780b6e | Journalism and other writing, broadcasting and lecturing. | Remunerated employment, office, profession etc. 0a4a155f | 2002-05-14 | Patrick Cormack uk.org.publicwhip/member/820 | Patrick Cormack uk.org.publicwhip/person/10134 | 0 | 2002-05-14-0a4a155f-10134-0 |
72ed6b67ee83aa9ea8759be0eab833256c9b13bb | Quarterly article for First Magazine, entitled Parliamentary Round-up. (£1-£1,000) | Remunerated employment, office, profession etc. 0a4a155f | 2002-05-14 | Patrick Cormack uk.org.publicwhip/member/820 | Patrick Cormack uk.org.publicwhip/person/10134 | 1 | 2002-05-14-0a4a155f-10134-0 |
ada90044ec73dd74b2a4c09c4dd0c77ab0e74298 | President (International Affairs) of First Magazine. | Remunerated employment, office, profession etc. 0a4a155f | 2002-05-14 | Patrick Cormack uk.org.publicwhip/member/820 | Patrick Cormack uk.org.publicwhip/person/10134 | 2 | 2002-05-14-0a4a155f-10134-0 |
4708f0e0bdb99a6314dad58dff9a4c105d9c470b | 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 | 2002-05-14 | Patrick Cormack uk.org.publicwhip/member/820 | Patrick Cormack uk.org.publicwhip/person/10134 | 3 | 2002-05-14-0a4a155f-10134-0 |
06820f03d31dc77e5267d04a709e077b50e36faa | Editor of the House Magazine. (£15,001-£20,000) | Remunerated employment, office, profession etc. 0a4a155f | 2002-05-14 | Patrick Cormack uk.org.publicwhip/member/820 | Patrick Cormack uk.org.publicwhip/person/10134 | 4 | 2002-05-14-0a4a155f-10134-0 |
ebb187fa94dffc931a963396ee13ad8205ffea0c | Adviser to the publisher of the House Magazine on his other publications, including the Church of England Newspaper. | Remunerated employment, office, profession etc. 0a4a155f | 2002-05-14 | Patrick Cormack uk.org.publicwhip/member/820 | Patrick Cormack uk.org.publicwhip/person/10134 | 5 | 2002-05-14-0a4a155f-10134-0 |
f04c7401f615d58bc0ce42b1bc5f583f095d5973 | Public affairs and parliamentary adviser to Machinery Users' Association. (£5,001-£10,000) | Remunerated employment, office, profession etc. 0a4a155f | 2002-05-14 | Patrick Cormack uk.org.publicwhip/member/820 | Patrick Cormack uk.org.publicwhip/person/10134 | 6 | 2002-05-14-0a4a155f-10134-0 |
dd2c1326b8b1de119408748047ac196eedb6f68d | Heritage adviser to Linford-Bridgeman Ltd.; conservation and restoration company. | Remunerated employment, office, profession etc. 0a4a155f | 2002-05-14 | Patrick Cormack uk.org.publicwhip/member/820 | Patrick Cormack uk.org.publicwhip/person/10134 | 7 | 2002-05-14-0a4a155f-10134-0 |
45a15dddcca0bff3238e9d3c8cc9936dfd712837 | Regular participant in "Parliamentary Questions" BBC radio programme. I receive a fee of £225 for each appearance. (£1,001-£5,000) | Remunerated employment, office, profession etc. 0a4a155f | 2002-05-14 | Patrick Cormack uk.org.publicwhip/member/820 | Patrick Cormack uk.org.publicwhip/person/10134 | 8 | 2002-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");