items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
20 rows where member_id = "uk.org.publicwhip/member/293" 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 |
---|---|---|---|---|---|---|---|
1514d24507f77c6d8797eae7bd94c6cf43ea6dbc | Parliamentary adviser to the Consumer Credit Association of the United Kingdom, which is the trade association representing the majority of businesses in the home credit industry. (£5,001-£10,000) | Remunerated employment, office, profession etc 1f359ece | 2001-05-14 | Gerald Howarth uk.org.publicwhip/member/293 | Gerald Howarth uk.org.publicwhip/person/10293 | 0 | 2001-05-14-1f359ece-10293-0 |
b630553e174029f99becdd5060d87f8c9edb8e66 | Occasional broadcasting fees. | Remunerated employment, office, profession etc 1f359ece | 2001-05-14 | Gerald Howarth uk.org.publicwhip/member/293 | Gerald Howarth uk.org.publicwhip/person/10293 | 1 | 2001-05-14-1f359ece-10293-0 |
b2f135f2f11fda53133227baeb5867157ae19414 | Member of the Political Opinion Panel of BPRI (Business Planning and Research International). | Remunerated employment, office, profession etc 1f359ece | 2001-05-14 | Gerald Howarth uk.org.publicwhip/member/293 | Gerald Howarth uk.org.publicwhip/person/10293 | 2 | 2001-05-14-1f359ece-10293-0 |
e14cff851b6122ecf57283c9ef03dfbad90adef1 | Member of Harris Parliamentary Panel. | Remunerated employment, office, profession etc 1f359ece | 2001-05-14 | Gerald Howarth uk.org.publicwhip/member/293 | Gerald Howarth uk.org.publicwhip/person/10293 | 3 | 2001-05-14-1f359ece-10293-0 |
85a4623e7bfdc250addd5f9c1c03ae8db658fb88 | Fees received from Cityforum, conference organisers, for assistance in organising conferences. | Remunerated employment, office, profession etc 1f359ece | 2001-05-14 | Gerald Howarth uk.org.publicwhip/member/293 | Gerald Howarth uk.org.publicwhip/person/10293 | 4 | 2001-05-14-1f359ece-10293-0 |
ec953f0cb162ba98bacb87504f720b826ff00307 | Consultant to Pacific Investments Ltd., advising on business development. | Remunerated employment, office, profession etc 1f359ece | 2001-05-14 | Gerald Howarth uk.org.publicwhip/member/293 | Gerald Howarth uk.org.publicwhip/person/10293 | 5 | 2001-05-14-1f359ece-10293-0 |
743d040a809e6cec621920760e1478045a553747 | Consultant to Euro Security Systems Ltd.; advising on new business. | Remunerated employment, office, profession etc 1f359ece | 2001-05-14 | Gerald Howarth uk.org.publicwhip/member/293 | Gerald Howarth uk.org.publicwhip/person/10293 | 6 | 2001-05-14-1f359ece-10293-0 |
a536c2fe884b8628c3cda1bf0ccc8d1240cfdf3b | Transfer by Mr Ed Lemco, a US citizen and former constituent, of his entitlement to 50 flying hours with European Flyers at Blackbushe Airport in my constituency. (Registered 3 March 2000) | Gifts, benefits and hospitality (UK) 84642823 | 2001-05-14 | Gerald Howarth uk.org.publicwhip/member/293 | Gerald Howarth uk.org.publicwhip/person/10293 | 0 | 2001-05-14-84642823-10293-0 |
9a361989998262757661919ff75ef1217e962e06 | 22 June 2000, my wife and I attended Ladies Day at Royal Ascot as guests of Imperial Tobacco. (Registered 10 July 2000) | Gifts, benefits and hospitality (UK) 84642823 | 2001-05-14 | Gerald Howarth uk.org.publicwhip/member/293 | Gerald Howarth uk.org.publicwhip/person/10293 | 1 | 2001-05-14-84642823-10293-0 |
7b229a07cce0b84cf3ab4cd826a7b1af0b6d9f60 | March 2001, gift of a telephone from Nokia Research when I opened their building in my constituency. (Registered 5 April 2001) | Gifts, benefits and hospitality (UK) 84642823 | 2001-05-14 | Gerald Howarth uk.org.publicwhip/member/293 | Gerald Howarth uk.org.publicwhip/person/10293 | 2 | 2001-05-14-84642823-10293-0 |
6d2f5c132408009c051ee837f12165979a26c237 | Parliamentary adviser to the Consumer Credit Association of the United Kingdom, which is the trade association representing the majority of businesses in the home credit industry. (£5,001-£10,000) | Remunerated employment, office, profession etc 1f359ece | 2000-11-10 | Gerald Howarth uk.org.publicwhip/member/293 | Gerald Howarth uk.org.publicwhip/person/10293 | 0 | 2000-11-10-1f359ece-10293-0 |
bd8454cf0a9fbf7728794c837c3c52d6f60da980 | Consultant on aviation matters to AON Group; insurance brokers. | Remunerated employment, office, profession etc 1f359ece | 2000-11-10 | Gerald Howarth uk.org.publicwhip/member/293 | Gerald Howarth uk.org.publicwhip/person/10293 | 1 | 2000-11-10-1f359ece-10293-0 |
63bf9ca2e1fcb4809e9452ec5937d9200095a042 | Occasional broadcasting fees. | Remunerated employment, office, profession etc 1f359ece | 2000-11-10 | Gerald Howarth uk.org.publicwhip/member/293 | Gerald Howarth uk.org.publicwhip/person/10293 | 2 | 2000-11-10-1f359ece-10293-0 |
a97186265e4443104d22677d376b549d0aa39846 | Member of the Political Opinion Panel of BPRI (Business Planning and Research International). | Remunerated employment, office, profession etc 1f359ece | 2000-11-10 | Gerald Howarth uk.org.publicwhip/member/293 | Gerald Howarth uk.org.publicwhip/person/10293 | 3 | 2000-11-10-1f359ece-10293-0 |
ba7f47b664841156b27fea0e8594916dbeef6389 | Member of Harris Parliamentary Panel. | Remunerated employment, office, profession etc 1f359ece | 2000-11-10 | Gerald Howarth uk.org.publicwhip/member/293 | Gerald Howarth uk.org.publicwhip/person/10293 | 4 | 2000-11-10-1f359ece-10293-0 |
a7ac993e4f717e81c35190b1605ae5459365cc7b | Fees received from Cityforum, conference organisers, for assistance in organising conferences. | Remunerated employment, office, profession etc 1f359ece | 2000-11-10 | Gerald Howarth uk.org.publicwhip/member/293 | Gerald Howarth uk.org.publicwhip/person/10293 | 5 | 2000-11-10-1f359ece-10293-0 |
7ffa13f77773fff43558ccd4636e0cb71d5a4898 | Consultant to Pacific Investments Ltd., advising on business development. | Remunerated employment, office, profession etc 1f359ece | 2000-11-10 | Gerald Howarth uk.org.publicwhip/member/293 | Gerald Howarth uk.org.publicwhip/person/10293 | 6 | 2000-11-10-1f359ece-10293-0 |
15d935832a891c33782bd6811b87eea52bc81513 | 5 November 1999, I participated in the Lords v Commons clay pigeon shoot at Highclere Castle, sponsored by Imperial Tobacco. (Registered 2 December 1999) | Gifts, benefits and hospitality (UK) 84642823 | 2000-11-10 | Gerald Howarth uk.org.publicwhip/member/293 | Gerald Howarth uk.org.publicwhip/person/10293 | 0 | 2000-11-10-84642823-10293-0 |
665db46ef41df4abb67770bf25f25d726047b247 | Transfer by Mr Ed Lemco, a US citizen and former constituent, of his entitlement to 50 flying hours with European Flyers at Blackbushe Airport in my constituency. (Registered 3 March 2000) | Gifts, benefits and hospitality (UK) 84642823 | 2000-11-10 | Gerald Howarth uk.org.publicwhip/member/293 | Gerald Howarth uk.org.publicwhip/person/10293 | 1 | 2000-11-10-84642823-10293-0 |
a61ca02f1482e5aae91b98bf3401b92e0339eace | 22 June 2000, my wife and I attended Ladies Day at Royal Ascot as guests of Imperial Tobacco. (Registered 10 July 2000) | Gifts, benefits and hospitality (UK) 84642823 | 2000-11-10 | Gerald Howarth uk.org.publicwhip/member/293 | Gerald Howarth uk.org.publicwhip/person/10293 | 2 | 2000-11-10-84642823-10293-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");