items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
12 rows where member_id = "uk.org.publicwhip/member/695" and person_id = "uk.org.publicwhip/person/10008" sorted by member_id
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 |
---|---|---|---|---|---|---|---|
c652455364dcfbdbddd0eed4863ef92a6dda5bde | Occasional fees for writing and lecturing. | Remunerated employment, office, profession etc 1f359ece | 2002-05-14 | Graham Allen uk.org.publicwhip/member/695 | Graham Allen uk.org.publicwhip/person/10008 | 0 | 2002-05-14-1f359ece-10008-0 |
760570d7d004df8d17ea7e6e60d70160c03dcd81 | 26 June-16 July 2001, to Australia, representing the British and Irish Parliamentary Rugby Union team against the Australian Parliament. Over 70% of the tour expenses were funded by contributions from the players and the balance from sponsorship and advertising generated on behalf of the Club/Parliamentary Lions. The sponsors and advertisers were: Arlington Lodge, Ashurst Morris Crisp, Bell Design, GEM Construction, Glaxosmithkline, HIFX Ltd., Irish Independent News & Media, Japan Airlines, ntl, Rickitt Grant & Partners, Rickitt Mitchell, Rolls Royce, R Smith, Sweet Chariot, Toyota, Waterford Crystal. (Registered 25 August 2001) | Overseas visits 80ef1083 | 2002-05-14 | Graham Allen uk.org.publicwhip/member/695 | Graham Allen uk.org.publicwhip/person/10008 | 0 | 2002-05-14-80ef1083-10008-0 |
c7739440af3902dcedc4a95948402fc3381048b2 | 27-28 October 2001, to Spain, to participate in the Madrid Conference on Democratic Transition. Honorarium, travel and hotel expenses paid by the Gorbachev Foundation. (Registered 20 November 2001) | Overseas visits 80ef1083 | 2002-05-14 | Graham Allen uk.org.publicwhip/member/695 | Graham Allen uk.org.publicwhip/person/10008 | 1 | 2002-05-14-80ef1083-10008-0 |
ca4246b48ecfa19f7b11902543980bc204ec05ca | 18-22 February 2002, to North Carolina for a family holiday during which I gave several lectures at local universities, who met my transport and accommodation costs and paid a small honorarium. (Registered 28 February 2002) | Overseas visits 80ef1083 | 2002-05-14 | Graham Allen uk.org.publicwhip/member/695 | Graham Allen uk.org.publicwhip/person/10008 | 2 | 2002-05-14-80ef1083-10008-0 |
fc2ea214783ce22bf9cbc7c41925803f595ec666 | I hold shares in Nottingham Forest FC. | Miscellaneous and unremunerated interests 265f2269 | 2002-05-14 | Graham Allen uk.org.publicwhip/member/695 | Graham Allen uk.org.publicwhip/person/10008 | 0 | 2002-05-14-265f2269-10008-0 |
2c3f0d8c41b2b2b22276be091c22d1665b92f3de | 18-22 February 2002, to North Carolina for a family holiday during which I gave several lectures at local universities, who met my transport and accommodation costs and paid a small honorarium. (Registered 28 February 2002) | Overseas visits 80ef1083 | 2002-11-26 | Graham Allen uk.org.publicwhip/member/695 | Graham Allen uk.org.publicwhip/person/10008 | 0 | 2002-11-26-80ef1083-10008-0 |
e96f8a4968efa694bc7003451ae914da65f51080 | 25 September-12 October 2003, visit to Australia with the All-Party Parliamentary Group for Commons and Lords Rugby Union Football Club to participate in Third Parliamentary World Cup Tournament. Members contributed to the cost of flights and hotels. Financial support was secured from Halewood International, the Australian Hotels Association, Canberra Tourism, Aus Trade, Acumen Alliance, AMP and Eurest Supply Services. Rugby kit was provided by Nike. (Registered 12 November 2003) | Overseas visits 80ef1083 | 2003-12-04 | Graham Allen uk.org.publicwhip/member/695 | Graham Allen uk.org.publicwhip/person/10008 | 0 | 2003-12-04-80ef1083-10008-0 |
f6897eda82b96e018d1db961ee39ed7c70a9e462 | 25 September-12 October 2003, visit to Australia with the All-Party Parliamentary Group for Commons and Lords Rugby Union Football Club to participate in Third Parliamentary World Cup Tournament. Members contributed to the cost of flights and hotels. Financial support was secured from Halewood International, the Australian Hotels Association, Canberra Tourism, Aus Trade, Acumen Alliance, AMP and Eurest Supply Services. Rugby kit was provided by Nike. (Registered 12 November 2003) | Overseas visits 80ef1083 | 2004-01-31 | Graham Allen uk.org.publicwhip/member/695 | Graham Allen uk.org.publicwhip/person/10008 | 0 | 2004-01-31-80ef1083-10008-0 |
6005ab78b1e69ab9240285b1401dc38e4d7e9625 | 25 September-12 October 2003, visit to Australia with the All-Party Parliamentary Group for Commons and Lords Rugby Union Football Club to participate in Third Parliamentary World Cup Tournament. Members contributed to the cost of flights and hotels. Financial support was secured from Halewood International, the Australian Hotels Association, Canberra Tourism, Aus Trade, Acumen Alliance, AMP and Eurest Supply Services. Rugby kit was provided by Nike. (Registered 12 November 2003) | Overseas visits 80ef1083 | 2004-05-21 | Graham Allen uk.org.publicwhip/member/695 | Graham Allen uk.org.publicwhip/person/10008 | 0 | 2004-05-21-80ef1083-10008-0 |
2005fce01cf6a35a9073417997c96521ee0ebbc3 | 25 September-12 October 2003, visit to Australia with the All-Party Parliamentary Group for Commons and Lords Rugby Union Football Club to participate in Third Parliamentary World Cup Tournament. Members contributed to the cost of flights and hotels. Financial support was secured from Halewood International, the Australian Hotels Association, Canberra Tourism, Aus Trade, Acumen Alliance, AMP and Eurest Supply Services. Rugby kit was provided by Nike. (Registered 12 November 2003) | Overseas visits 80ef1083 | 2004-07-16 | Graham Allen uk.org.publicwhip/member/695 | Graham Allen uk.org.publicwhip/person/10008 | 0 | 2004-07-16-80ef1083-10008-0 |
5af2c0be977364e468727e72f79e7d98e42c315b | 25 September-12 October 2003, visit to Australia with the All-Party Parliamentary Group for Commons and Lords Rugby Union Football Club to participate in Third Parliamentary World Cup Tournament. Members contributed to the cost of flights and hotels. Financial support was secured from Halewood International, the Australian Hotels Association, Canberra Tourism, Aus Trade, Acumen Alliance, AMP and Eurest Supply Services. Rugby kit was provided by Nike. (Registered 12 November 2003) | Overseas visits 80ef1083 | 2004-09-08 | Graham Allen uk.org.publicwhip/member/695 | Graham Allen uk.org.publicwhip/person/10008 | 0 | 2004-09-08-80ef1083-10008-0 |
f5317bfbb220c4fbde493ae5090127a6dc7585e5 | 25 September-12 October 2003, visit to Australia with the All-Party Parliamentary Group for Commons and Lords Rugby Union Football Club to participate in Third Parliamentary World Cup Tournament. Members contributed to the cost of flights and hotels. Financial support was secured from Halewood International, the Australian Hotels Association, Canberra Tourism, Aus Trade, Acumen Alliance, AMP and Eurest Supply Services. Rugby kit was provided by Nike. (Registered 12 November 2003) | Overseas visits 80ef1083 | 2004-10-22 | Graham Allen uk.org.publicwhip/member/695 | Graham Allen uk.org.publicwhip/person/10008 | 0 | 2004-10-22-80ef1083-10008-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");