home / regmem

items

Data source: mySociety Data

30 rows where person_id = "uk.org.publicwhip/person/10006"

View and edit SQL

Suggested facets: item, category_id, date, member_id, sort_order, record_id

hash item category_id date member_id person_id sort_order record_id
0bdd5b1d8745690d0e860e177661d498cb63dc23 Donation to my fighting fund from Mr Timothy Stone, of Essex (personal donation). (Registered 7 June 2005) Sponsorship or financial or material support 9e46def6 2006-03-24 uk.org.publicwhip/member/1857 Peter Ainsworth uk.org.publicwhip/person/10006 0 2006-03-24-9e46def6-10006-0
187deddf4b388d7b9dc3e0cc053db53c75bb876a Donations made to Conservative Central Office by Mr Peter Hall, a businessman, help to provide staff who support me in my capacity as Shadow Secretary of State for Environment, Food and Rural Affairs. (Registered 11 February 2008) Sponsorship or financial or material support 9e46def6 2008-09-03 uk.org.publicwhip/member/1857 Peter Ainsworth uk.org.publicwhip/person/10006 0 2008-09-03-9e46def6-10006-0
2b4909f9f625338d6afbd1f797ae3f5eb4f39fdd As Shadow Secretary of State for Culture, Media and Sport, I have received frequent invitations to attend cultural and sporting events; the value of the hospitality I receive on some of these occasions may exceed £250. Gifts, benefits and hospitality (UK) 84642823 2002-05-14 uk.org.publicwhip/member/692 Peter Ainsworth uk.org.publicwhip/person/10006 0 2002-05-14-84642823-10006-0
3b2946c0bb0ffaac64b25e403fd83fabd764b50e In my capacity as Shadow Secretary of State for Culture, Media and Sport, I receive frequent invitations to attend cultural and sporting events; the value of the hospitality I receive on some of these occasions may exceed £235. Gifts, benefits and hospitality (UK) 84642823 2001-05-14 uk.org.publicwhip/member/6 Peter Ainsworth uk.org.publicwhip/person/10006 0 2001-05-14-84642823-10006-0
3c6a42725fe676388a4ce55a5bd17781928ec1e9 Donations made to Conservative Central Office by Mr Peter Hall, a businessman, help to provide staff who support me in my capacity as Shadow Secretary of State for Environment, Food and Rural Affairs. (Registered 11 February 2008) Sponsorship or financial or material support 9e46def6 2008-10-22 uk.org.publicwhip/member/1857 Peter Ainsworth uk.org.publicwhip/person/10006 0 2008-10-22-9e46def6-10006-0
449c4f2806a2753a0344a72376bfc04c731204b5 Donations made to Conservative Central Office by Mr Peter Hall, a businessman, help to provide staff who support me in my capacity as Shadow Secretary of State for Environment, Food and Rural Affairs. (Registered 11 February 2008) Sponsorship or financial or material support 9e46def6 2008-07-08 uk.org.publicwhip/member/1857 Peter Ainsworth uk.org.publicwhip/person/10006 0 2008-07-08-9e46def6-10006-0
44ea4011c9e28323c3bfc25c6a970a6f99490be5 Donations made to Conservative Central Office by Mr Peter Hall, a businessman, help to provide staff who support me in my capacity as Shadow Secretary of State for Environment, Food and Rural Affairs. (Registered 11 February 2008) Sponsorship or financial or material support 9e46def6 2008-11-19 uk.org.publicwhip/member/1857 Peter Ainsworth uk.org.publicwhip/person/10006 0 2008-11-19-9e46def6-10006-0
45d072dbc67e108a419295bc841f400727abe728 Donations made to Conservative Central Office by Mr Peter Hall, a businessman, help to provide staff who support me in my capacity as Shadow Secretary of State for Environment, Food and Rural Affairs. (Registered 11 February 2008) Sponsorship or financial or material support 9e46def6 2009-01-14 uk.org.publicwhip/member/1857 Peter Ainsworth uk.org.publicwhip/person/10006 0 2009-01-14-9e46def6-10006-0
46a5255e9e9e34c4825e0507595e25011b2510aa Donations made to Conservative Central Office by Mr Peter Hall, a businessman, help to provide staff who support me in my capacity as Shadow Secretary of State for Environment, Food and Rural Affairs. (Registered 11 February 2008) Sponsorship or financial or material support 9e46def6 2008-12-03 uk.org.publicwhip/member/1857 Peter Ainsworth uk.org.publicwhip/person/10006 0 2008-12-03-9e46def6-10006-0
490c25a42a32053beef25451003d142c4f539e99 Donations made to Conservative Central Office by Mr Peter Hall, a businessman, help to provide staff who support me in my capacity as Shadow Secretary of State for Environment, Food and Rural Affairs. (Registered 11 February 2008) Sponsorship or financial or material support 9e46def6 2008-04-23 uk.org.publicwhip/member/1857 Peter Ainsworth uk.org.publicwhip/person/10006 0 2008-04-23-9e46def6-10006-0
522b2b10ff99ac06c0c16560c94df6ee9f28df78 In my capacity as Shadow Secretary of State for Culture, Media and Sport, I receive frequent invitations to attend cultural and sporting events; the value of the hospitality I receive on some of these occasions may exceed £235. Gifts, benefits and hospitality (UK) 84642823 2000-11-10 uk.org.publicwhip/member/6 Peter Ainsworth uk.org.publicwhip/person/10006 0 2000-11-10-84642823-10006-0
5385b5a0af941808463efd3a68d3b5e4c701ebf4 Donations made to Conservative Central Office by Mr Peter Hall, a businessman, help to provide staff who support me in my capacity as Shadow Secretary of State for Environment, Food and Rural Affairs. (Registered 11 February 2008) Sponsorship or financial or material support 9e46def6 2008-02-26 uk.org.publicwhip/member/1857 Peter Ainsworth uk.org.publicwhip/person/10006 0 2008-02-26-9e46def6-10006-0
5eea0d3073a4df6f4674a919808eb55a6bb60158 Donation to my fighting fund from Mr Timothy Stone, of Essex (personal donation). (Registered 7 June 2005) Sponsorship or financial or material support 9e46def6 2005-11-01 uk.org.publicwhip/member/1857 Peter Ainsworth uk.org.publicwhip/person/10006 0 2005-11-01-9e46def6-10006-0
7610db3e9c5dc708ae621e344456a47a6258a547 Donation to my fighting fund from Mr Timothy Stone, of Essex (personal donation). (Registered 7 June 2005) Sponsorship or financial or material support 9e46def6 2006-02-13 uk.org.publicwhip/member/1857 Peter Ainsworth uk.org.publicwhip/person/10006 0 2006-02-13-9e46def6-10006-0
7a66dfccae7a19568cb3fea3b9be59d851f3b5c9 Donations made to Conservative Central Office by Mr Peter Hall, a businessman, help to provide staff who support me in my capacity as Shadow Secretary of State for Environment, Food and Rural Affairs. (Registered 11 February 2008) Sponsorship or financial or material support 9e46def6 2009-02-11 uk.org.publicwhip/member/1857 Peter Ainsworth uk.org.publicwhip/person/10006 0 2009-02-11-9e46def6-10006-0
7c6bda42232b5c8fb215101407d3da15dc41ee33 Donation to my fighting fund from Mr Timothy Stone, of Essex (personal donation). (Registered 7 June 2005) Sponsorship or financial or material support 9e46def6 2006-05-12 uk.org.publicwhip/member/1857 Peter Ainsworth uk.org.publicwhip/person/10006 0 2006-05-12-9e46def6-10006-0
84f6b95530d556450c294493f0e1fa1880702bbd 31 December 1999, my wife, three children and I were guests of the New Millennium Experience Company at the Millennium Dome. (Registered 17 February 2000) Gifts, benefits and hospitality (UK) 84642823 2000-11-10 uk.org.publicwhip/member/6 Peter Ainsworth uk.org.publicwhip/person/10006 1 2000-11-10-84642823-10006-0
87a2511bc947fc706a71eac9fec67c783a445b2c Donations made to Conservative Central Office by Mr Peter Hall, a businessman, help to provide staff who support me in my capacity as Shadow Secretary of State for Environment, Food and Rural Affairs. (Registered 11 February 2008) Sponsorship or financial or material support 9e46def6 2008-12-17 uk.org.publicwhip/member/1857 Peter Ainsworth uk.org.publicwhip/person/10006 0 2008-12-17-9e46def6-10006-0
95d652dc04ce1e6776526a91b0966df7124b7332 I have received, unsolicited, classical CD's from the Peter Moores Foundation whose aggregate retail value may exceed the threshold for registration. (Registered 10 November 2000) Gifts, benefits and hospitality (UK) 84642823 2001-05-14 uk.org.publicwhip/member/6 Peter Ainsworth uk.org.publicwhip/person/10006 2 2001-05-14-84642823-10006-0
977dc20680c44ae1a366314fca6f693065c2e704 Donations made to Conservative Central Office by Mr Peter Hall, a businessman, help to provide staff who support me in my capacity as Shadow Secretary of State for Environment, Food and Rural Affairs. (Registered 11 February 2008) Sponsorship or financial or material support 9e46def6 2008-03-25 uk.org.publicwhip/member/1857 Peter Ainsworth uk.org.publicwhip/person/10006 0 2008-03-25-9e46def6-10006-0
a1eaa69c395d499c4fb340d11ec448c4aa34db66 Donations made to Conservative Central Office by Mr Peter Hall, a businessman, help to provide staff who support me in my capacity as Shadow Secretary of State for Environment, Food and Rural Affairs. (Registered 11 February 2008) Sponsorship or financial or material support 9e46def6 2008-11-05 uk.org.publicwhip/member/1857 Peter Ainsworth uk.org.publicwhip/person/10006 0 2008-11-05-9e46def6-10006-0
b2cff7f43f47a4bc0baf88c3b0fc668e7e65828d Donations made to Conservative Central Office by Mr Peter Hall, a businessman, help to provide staff who support me in my capacity as Shadow Secretary of State for Environment, Food and Rural Affairs. (Registered 11 February 2008) Sponsorship or financial or material support 9e46def6 2008-06-16 uk.org.publicwhip/member/1857 Peter Ainsworth uk.org.publicwhip/person/10006 0 2008-06-16-9e46def6-10006-0
be54a723e54c929d84d516e419c8a676ca6f70d2 Donations made to Conservative Central Office by Mr Peter Hall, a businessman, help to provide staff who support me in my capacity as Shadow Secretary of State for Environment, Food and Rural Affairs. (Registered 11 February 2008) Sponsorship or financial or material support 9e46def6 2008-03-11 uk.org.publicwhip/member/1857 Peter Ainsworth uk.org.publicwhip/person/10006 0 2008-03-11-9e46def6-10006-0
c23080221f488a27159d85498b9df8a79f03c8e2 Donations made to Conservative Central Office by Mr Peter Hall, a businessman, help to provide staff who support me in my capacity as Shadow Secretary of State for Environment, Food and Rural Affairs. (Registered 11 February 2008) Sponsorship or financial or material support 9e46def6 2009-01-28 uk.org.publicwhip/member/1857 Peter Ainsworth uk.org.publicwhip/person/10006 0 2009-01-28-9e46def6-10006-0
c99f2c2ce47faa49676fb3328d5739360db19f60 31 December 1999, my wife, three children and I were guests of the New Millennium Experience Company at the Millennium Dome. (Registered 17 February 2000) Gifts, benefits and hospitality (UK) 84642823 2001-05-14 uk.org.publicwhip/member/6 Peter Ainsworth uk.org.publicwhip/person/10006 1 2001-05-14-84642823-10006-0
cc80c1eb5de3de9fc131f84e15886296f979b975 Donation to my fighting fund from Mr Timothy Stone, of Essex (personal donation). (Registered 7 June 2005) Sponsorship or financial or material support 9e46def6 2005-12-14 uk.org.publicwhip/member/1857 Peter Ainsworth uk.org.publicwhip/person/10006 0 2005-12-14-9e46def6-10006-0
ce4a631d33a9cc8a30c2bea0736a6fdb71e75f5f Donation to my fighting fund from Mr Timothy Stone, of Essex (personal donation). (Registered 7 June 2005) Sponsorship or financial or material support 9e46def6 2006-02-14 uk.org.publicwhip/member/1857 Peter Ainsworth uk.org.publicwhip/person/10006 0 2006-02-14-9e46def6-10006-0
d09812fcc79164f91b33097e6176ff56a5b420b2 12-13 October 2000, to Dublin, sponsored by the British Tourist Authority, who paid hotel and travel costs. (Registered 10 November 2000) Overseas visits 80ef1083 2001-05-14 uk.org.publicwhip/member/6 Peter Ainsworth uk.org.publicwhip/person/10006 0 2001-05-14-80ef1083-10006-0
dabc676baeb333a6d8a654acf63b432b3b2bda82 Donations made to Conservative Central Office by Mr Peter Hall, a businessman, help to provide staff who support me in my capacity as Shadow Secretary of State for Environment, Food and Rural Affairs. (Registered 11 February 2008) Sponsorship or financial or material support 9e46def6 2008-10-08 uk.org.publicwhip/member/1857 Peter Ainsworth uk.org.publicwhip/person/10006 0 2008-10-08-9e46def6-10006-0
ff00f29449bfaeada44bf9c0133c1f902adbecb4 Donations made to Conservative Central Office by Mr Peter Hall, a businessman, help to provide staff who support me in my capacity as Shadow Secretary of State for Environment, Food and Rural Affairs. (Registered 11 February 2008) Sponsorship or financial or material support 9e46def6 2008-07-22 uk.org.publicwhip/member/1857 Peter Ainsworth uk.org.publicwhip/person/10006 0 2008-07-22-9e46def6-10006-0

Advanced export

JSON shape: default, array, 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)
    )
Powered by Datasette · Query took 8.802ms · Data source: mySociety Data