items

Data source: mySociety Data · About: simonw/register-of-members-interests

34 rows where member_id = "uk.org.publicwhip/member/1039" sorted by date descending

View and edit SQL

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
f6f2bdb01c6824dbaeb61745218443a4388b2273 Barrister at Law. Remunerated employment, office, profession etc 1f359ece 2005-04-11 Edward Leigh uk.org.publicwhip/member/1039 Edward Leigh uk.org.publicwhip/person/10352 0 2005-04-11-1f359ece-10352-0
7af12538d5b6db9a393302d4192a94969f101602 Parliamentary consultant to Pinnacle Insurance PLC. (£10,001-£15,000) Remunerated employment, office, profession etc 1f359ece 2005-04-11 Edward Leigh uk.org.publicwhip/member/1039 Edward Leigh uk.org.publicwhip/person/10352 1 2005-04-11-1f359ece-10352-0
6e33039173e2be49b1f0c2c6d5f54070b7a0afa5 Since May 1997, occasional briefing and visits to the House in connection with particular legislation by Mr Simon Calvert, Deputy Director of the Christian Institute. Sponsorship or financial or material support 9e46def6 2005-04-11 Edward Leigh uk.org.publicwhip/member/1039 Edward Leigh uk.org.publicwhip/person/10352 0 2005-04-11-9e46def6-10352-0
3d5d08086674c55c7a9700f780b9d6fa0a06c780 Barrister at Law. Remunerated employment, office, profession etc.. 12405e8c 2005-01-28 Edward Leigh uk.org.publicwhip/member/1039 Edward Leigh uk.org.publicwhip/person/10352 0 2005-01-28-12405e8c-10352-0
362dc63258b41b085e56e40446d2ec48fd1f5f70 Parliamentary consultant to Pinnacle Insurance PLC. (£10,001-£15,000) Remunerated employment, office, profession etc.. 12405e8c 2005-01-28 Edward Leigh uk.org.publicwhip/member/1039 Edward Leigh uk.org.publicwhip/person/10352 1 2005-01-28-12405e8c-10352-0
0f42abd1de48c8b5d78fab81bdb342313505398c Since May 1997, occasional briefing and visits to the House in connection with particular legislation by Mr Simon Calvert, Deputy Director of the Christian Institute. Sponsorship or financial or material support 9e46def6 2005-01-28 Edward Leigh uk.org.publicwhip/member/1039 Edward Leigh uk.org.publicwhip/person/10352 0 2005-01-28-9e46def6-10352-0
2aa034f7ea08a4cc3eae28c0597a3b5376623e4b Barrister at Law. Remunerated employment, office, profession etc 1f359ece 2004-12-03 Edward Leigh uk.org.publicwhip/member/1039 Edward Leigh uk.org.publicwhip/person/10352 0 2004-12-03-1f359ece-10352-0
67ec52f4d3f50df8add5ff6aab14542d1a4b0b7c Parliamentary consultant to Pinnacle Insurance PLC. (£10,001-£15,000) Remunerated employment, office, profession etc 1f359ece 2004-12-03 Edward Leigh uk.org.publicwhip/member/1039 Edward Leigh uk.org.publicwhip/person/10352 1 2004-12-03-1f359ece-10352-0
fac6d682d80233157a9572889bfeb35fd1248467 Since May 1997, occasional briefing and visits to the House in connection with particular legislation by Mr Simon Calvert, Deputy Director of the Christian Institute. Sponsorship or financial or material support 9e46def6 2004-12-03 Edward Leigh uk.org.publicwhip/member/1039 Edward Leigh uk.org.publicwhip/person/10352 0 2004-12-03-9e46def6-10352-0
88c14dbe01d080703cb192381e7b76f202ecd944 Barrister at Law. Remunerated employment, office, profession etc 1f359ece 2004-10-22 Edward Leigh uk.org.publicwhip/member/1039 Edward Leigh uk.org.publicwhip/person/10352 0 2004-10-22-1f359ece-10352-0
4f05e55066ece3a0f5449cb94e9a812616a61ae2 Parliamentary consultant to Pinnacle Insurance PLC. (£10,001-£15,000) Remunerated employment, office, profession etc 1f359ece 2004-10-22 Edward Leigh uk.org.publicwhip/member/1039 Edward Leigh uk.org.publicwhip/person/10352 1 2004-10-22-1f359ece-10352-0
11ec81d766def8ea9b415d5c3d7def8e0194b8ed Since May 1997, occasional briefing and visits to the House in connection with particular legislation by Mr Simon Calvert, Deputy Director of the Christian Institute. Sponsorship or financial or material support 9e46def6 2004-10-22 Edward Leigh uk.org.publicwhip/member/1039 Edward Leigh uk.org.publicwhip/person/10352 0 2004-10-22-9e46def6-10352-0
98d4025b8568e468574d3e8241c78a390ed0d2b2 Barrister at Law. Remunerated employment, office, profession etc 1f359ece 2004-09-08 Edward Leigh uk.org.publicwhip/member/1039 Edward Leigh uk.org.publicwhip/person/10352 0 2004-09-08-1f359ece-10352-0
6669ecbc35ad76dfd140ec7d8f58474accc0d5fe Parliamentary consultant to Pinnacle Insurance PLC. (£10,001-£15,000) Remunerated employment, office, profession etc 1f359ece 2004-09-08 Edward Leigh uk.org.publicwhip/member/1039 Edward Leigh uk.org.publicwhip/person/10352 1 2004-09-08-1f359ece-10352-0
f18bed7b9712aa6d6e56e3cda81c3e0d2719ba93 Since May 1997, occasional briefing and visits to the House in connection with particular legislation by Mr Simon Calvert, Deputy Director of the Christian Institute. Sponsorship or financial or material support 9e46def6 2004-09-08 Edward Leigh uk.org.publicwhip/member/1039 Edward Leigh uk.org.publicwhip/person/10352 0 2004-09-08-9e46def6-10352-0
84998f970a9a91afda6d28b0b0ca67d452620f4a Barrister at Law. Remunerated employment, office, profession etc 1f359ece 2004-07-16 Edward Leigh uk.org.publicwhip/member/1039 Edward Leigh uk.org.publicwhip/person/10352 0 2004-07-16-1f359ece-10352-0
db0784d93e7dc3dde177fb4f09070a71b2383416 Parliamentary consultant to Pinnacle Insurance PLC. (£10,001-£15,000) Remunerated employment, office, profession etc 1f359ece 2004-07-16 Edward Leigh uk.org.publicwhip/member/1039 Edward Leigh uk.org.publicwhip/person/10352 1 2004-07-16-1f359ece-10352-0
4374af9232577e84e699e78bdac42bd4aa69bd12 Since May 1997, occasional briefing and visits to the House in connection with particular legislation by Mr Simon Calvert, Deputy Director of the Christian Institute. Sponsorship or financial or material support 9e46def6 2004-07-16 Edward Leigh uk.org.publicwhip/member/1039 Edward Leigh uk.org.publicwhip/person/10352 0 2004-07-16-9e46def6-10352-0
3bc22baf305903d196c36bc69ec6590bec5eeb37 Barrister at Law. Remunerated employment, office, profession etc 1f359ece 2004-05-21 Edward Leigh uk.org.publicwhip/member/1039 Edward Leigh uk.org.publicwhip/person/10352 0 2004-05-21-1f359ece-10352-0
8fdedfba88c06a138be18bad1752a6e2889dc7a5 Parliamentary consultant to Pinnacle Insurance PLC. (£10,001-£15,000) Remunerated employment, office, profession etc 1f359ece 2004-05-21 Edward Leigh uk.org.publicwhip/member/1039 Edward Leigh uk.org.publicwhip/person/10352 1 2004-05-21-1f359ece-10352-0
01ea8ad26c65f81ca49dd6591ce6915ff72fb1ba Since May 1997, occasional briefing and visits to the House in connection with particular legislation by Mr Simon Calvert, Deputy Director of the Christian Institute. Sponsorship or financial or material support 9e46def6 2004-05-21 Edward Leigh uk.org.publicwhip/member/1039 Edward Leigh uk.org.publicwhip/person/10352 0 2004-05-21-9e46def6-10352-0
9056b9c7e55bbc1d92089ae3cf1a3f79d765e133 Barrister at Law. Remunerated employment, office, profession etc 1f359ece 2004-01-31 Edward Leigh uk.org.publicwhip/member/1039 Edward Leigh uk.org.publicwhip/person/10352 0 2004-01-31-1f359ece-10352-0
6b7d500a58f110d9d243dd15be9612a6f7d538a3 Parliamentary consultant to Pinnacle Insurance PLC. (£10,001-£15,000) Remunerated employment, office, profession etc 1f359ece 2004-01-31 Edward Leigh uk.org.publicwhip/member/1039 Edward Leigh uk.org.publicwhip/person/10352 1 2004-01-31-1f359ece-10352-0
eec0cd1f323cbbc6292c3885b3e72ee048ea6f5a Since May 1997, occasional briefing and visits to the House in connection with particular legislation by Mr Simon Calvert, Deputy Director of the Christian Institute. Sponsorship or financial or material support 9e46def6 2004-01-31 Edward Leigh uk.org.publicwhip/member/1039 Edward Leigh uk.org.publicwhip/person/10352 0 2004-01-31-9e46def6-10352-0
8adc149c0a4871bdd6e2baea049ef441fe38fe86 Barrister at Law. Remunerated employment, office, profession etc 1f359ece 2003-12-04 Edward Leigh uk.org.publicwhip/member/1039 Edward Leigh uk.org.publicwhip/person/10352 0 2003-12-04-1f359ece-10352-0
4d6eab8e9cdb96afdee19959a43231a0a2afcb92 Parliamentary consultant to Pinnacle Insurance PLC. (£10,001-£15,000) Remunerated employment, office, profession etc 1f359ece 2003-12-04 Edward Leigh uk.org.publicwhip/member/1039 Edward Leigh uk.org.publicwhip/person/10352 1 2003-12-04-1f359ece-10352-0
f0e8ea59f76abb190775a7f48a23b68838e0c328 Since May 1997, occasional briefing and visits to the House in connection with particular legislation by Mr Simon Calvert, Deputy Director of the Christian Institute. Sponsorship or financial or material support 9e46def6 2003-12-04 Edward Leigh uk.org.publicwhip/member/1039 Edward Leigh uk.org.publicwhip/person/10352 0 2003-12-04-9e46def6-10352-0
8cb061d694a76bc0e78803da0cc7653e55e5b124 Barrister at Law. Remunerated employment, office, profession etc 1f359ece 2002-11-26 Edward Leigh uk.org.publicwhip/member/1039 Edward Leigh uk.org.publicwhip/person/10352 0 2002-11-26-1f359ece-10352-0
5a4799460f19d1b82aa8aeff246351d1c62f2fab Parliamentary consultant to Pinnacle Insurance PLC. (£10,001-£15,000) Remunerated employment, office, profession etc 1f359ece 2002-11-26 Edward Leigh uk.org.publicwhip/member/1039 Edward Leigh uk.org.publicwhip/person/10352 1 2002-11-26-1f359ece-10352-0
19583375c10ca27ca7851e30991d10d8481d905f Since May 1997, occasional briefing and visits to the House in connection with particular legislation by Mr Simon Calvert, Deputy Director of the Christian Institute. Sponsorship or financial or material support 9e46def6 2002-11-26 Edward Leigh uk.org.publicwhip/member/1039 Edward Leigh uk.org.publicwhip/person/10352 0 2002-11-26-9e46def6-10352-0
33e561da8644e5b5eaa6635651be4d9f18876e69 Barrister at Law. Remunerated employment, office, profession etc 1f359ece 2002-05-14 Edward Leigh uk.org.publicwhip/member/1039 Edward Leigh uk.org.publicwhip/person/10352 0 2002-05-14-1f359ece-10352-0
a673f04270e0736a6971d8f7a12a73fa4aa9eb9b Parliamentary consultant to Pinnacle Insurance PLC. (£10,001-£15,000) Remunerated employment, office, profession etc 1f359ece 2002-05-14 Edward Leigh uk.org.publicwhip/member/1039 Edward Leigh uk.org.publicwhip/person/10352 1 2002-05-14-1f359ece-10352-0
a8ff04948f242015753eb4270c17a8cb6819b564 Since May 1997, occasional briefing and visits to the House in connection with particular legislation by Mr Simon Calvert, Deputy Director of the Christian Institute. Sponsorship or financial or material support 9e46def6 2002-05-14 Edward Leigh uk.org.publicwhip/member/1039 Edward Leigh uk.org.publicwhip/person/10352 0 2002-05-14-9e46def6-10352-0
c2ddbfb83a5cdbc231a5f1cdc27a5ebc9519facb A joint donation of £5,000 was made by Mr. Lincoln Fraser and Mr. David Willerton, local businessmen, to the Gainsborough Conservative Association Fighting Fund, administered by the Association, out of which my election campaign expenses were paid. (Registered 15 October 2001) Sponsorship or financial or material support 9e46def6 2002-05-14 Edward Leigh uk.org.publicwhip/member/1039 Edward Leigh uk.org.publicwhip/person/10352 1 2002-05-14-9e46def6-10352-0

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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");
Powered by Datasette · Query took 20.294ms · Data source: mySociety Data · About: simonw/register-of-members-interests