items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
17 rows where category_id = 84642823 and person_id = "uk.org.publicwhip/person/10085" sorted by date descending
This data as json, CSV (advanced)
Suggested facets: date (date)
member_id 1 ✖
hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
4c1ada3322f77a6bbc02b5268679077576738bb2 | 20 October 2007, I attended the Rugby World Cup Final in Paris as a guest of Betfair, who paid for my travel and accommodation costs. (Registered 6 March 2008) | Gifts, benefits and hospitality (UK) 84642823 | 2009-02-25 | Richard Caborn uk.org.publicwhip/member/1811 | Richard Caborn uk.org.publicwhip/person/10085 | 0 | 2009-02-25-84642823-10085-0 |
beb3870a74c2861fe30114ea45fc20735683bd50 | 20 October 2007, I attended the Rugby World Cup Final in Paris as a guest of Betfair, who paid for my travel and accommodation costs. (Registered 6 March 2008) | Gifts, benefits and hospitality (UK) 84642823 | 2009-02-11 | Richard Caborn uk.org.publicwhip/member/1811 | Richard Caborn uk.org.publicwhip/person/10085 | 0 | 2009-02-11-84642823-10085-0 |
6f2c32f679f08daf9374d0ba8b767165ad659640 | 20 October 2007, I attended the Rugby World Cup Final in Paris as a guest of Betfair, who paid for my travel and accommodation costs. (Registered 6 March 2008) | Gifts, benefits and hospitality (UK) 84642823 | 2009-01-28 | Richard Caborn uk.org.publicwhip/member/1811 | Richard Caborn uk.org.publicwhip/person/10085 | 0 | 2009-01-28-84642823-10085-0 |
d9bb388ed6430081b490338ff3d782bbcd8ce566 | 20 October 2007, I attended the Rugby World Cup Final in Paris as a guest of Betfair, who paid for my travel and accommodation costs. (Registered 6 March 2008) | Gifts, benefits and hospitality (UK) 84642823 | 2009-01-14 | Richard Caborn uk.org.publicwhip/member/1811 | Richard Caborn uk.org.publicwhip/person/10085 | 0 | 2009-01-14-84642823-10085-0 |
691b9abe1711a7f6c41320b97685f0925318f1fc | 20 October 2007, I attended the Rugby World Cup Final in Paris as a guest of Betfair, who paid for my travel and accommodation costs. (Registered 6 March 2008) | Gifts, benefits and hospitality (UK) 84642823 | 2008-12-17 | Richard Caborn uk.org.publicwhip/member/1811 | Richard Caborn uk.org.publicwhip/person/10085 | 0 | 2008-12-17-84642823-10085-0 |
936f8a44785be863bed365a47b64b91812f8581a | 20 October 2007, I attended the Rugby World Cup Final in Paris as a guest of Betfair, who paid for my travel and accommodation costs. (Registered 6 March 2008) | Gifts, benefits and hospitality (UK) 84642823 | 2008-12-03 | Richard Caborn uk.org.publicwhip/member/1811 | Richard Caborn uk.org.publicwhip/person/10085 | 0 | 2008-12-03-84642823-10085-0 |
e942367d23b04ef5c2ad231611446caa12cb3cc1 | 20 October 2007, I attended the Rugby World Cup Final in Paris as a guest of Betfair, who paid for my travel and accommodation costs. (Registered 6 March 2008) | Gifts, benefits and hospitality (UK) 84642823 | 2008-11-19 | Richard Caborn uk.org.publicwhip/member/1811 | Richard Caborn uk.org.publicwhip/person/10085 | 0 | 2008-11-19-84642823-10085-0 |
2315960eefb2c935e99436c5cb789fcbe316c686 | 20 October 2007, I attended the Rugby World Cup Final in Paris as a guest of Betfair, who paid for my travel and accommodation costs. (Registered 6 March 2008) | Gifts, benefits and hospitality (UK) 84642823 | 2008-11-05 | Richard Caborn uk.org.publicwhip/member/1811 | Richard Caborn uk.org.publicwhip/person/10085 | 0 | 2008-11-05-84642823-10085-0 |
cb5c8032d430cf35d9b98822b1a7047efa01a231 | 20 October 2007, I attended the Rugby World Cup Final in Paris as a guest of Betfair, who paid for my travel and accommodation costs. (Registered 6 March 2008) | Gifts, benefits and hospitality (UK) 84642823 | 2008-10-22 | Richard Caborn uk.org.publicwhip/member/1811 | Richard Caborn uk.org.publicwhip/person/10085 | 0 | 2008-10-22-84642823-10085-0 |
3fee95315593010fc96d40394bd57c13457bd1fc | 20 October 2007, I attended the Rugby World Cup Final in Paris as a guest of Betfair, who paid for my travel and accommodation costs. (Registered 6 March 2008) | Gifts, benefits and hospitality (UK) 84642823 | 2008-10-08 | Richard Caborn uk.org.publicwhip/member/1811 | Richard Caborn uk.org.publicwhip/person/10085 | 0 | 2008-10-08-84642823-10085-0 |
689beced1f50b06af6f1fc38dd6fe0743b68210b | 20 October 2007, I attended the Rugby World Cup Final in Paris as a guest of Betfair, who paid for my travel and accommodation costs. (Registered 6 March 2008) | Gifts, benefits and hospitality (UK) 84642823 | 2008-09-03 | Richard Caborn uk.org.publicwhip/member/1811 | Richard Caborn uk.org.publicwhip/person/10085 | 0 | 2008-09-03-84642823-10085-0 |
7e6b6580ec510a82328b84c3b67d935cad53d9ea | 20 October 2007, I attended the Rugby World Cup Final in Paris as a guest of Betfair, who paid for my travel and accommodation costs. (Registered 6 March 2008) | Gifts, benefits and hospitality (UK) 84642823 | 2008-07-22 | Richard Caborn uk.org.publicwhip/member/1811 | Richard Caborn uk.org.publicwhip/person/10085 | 0 | 2008-07-22-84642823-10085-0 |
12536237bf963494cc53f30c7a38de3b4dd7d2e4 | 20 October 2007, I attended the Rugby World Cup Final in Paris as a guest of Betfair, who paid for my travel and accommodation costs. (Registered 6 March 2008) | Gifts, benefits and hospitality (UK) 84642823 | 2008-07-08 | Richard Caborn uk.org.publicwhip/member/1811 | Richard Caborn uk.org.publicwhip/person/10085 | 0 | 2008-07-08-84642823-10085-0 |
1c9fa31adf52872c53f1f540428983dd1f233e84 | 20 October 2007, I attended the Rugby World Cup Final in Paris as a guest of Betfair, who paid for my travel and accommodation costs. (Registered 6 March 2008) | Gifts, benefits and hospitality (UK) 84642823 | 2008-06-16 | Richard Caborn uk.org.publicwhip/member/1811 | Richard Caborn uk.org.publicwhip/person/10085 | 0 | 2008-06-16-84642823-10085-0 |
f03a35d4ca24d26a8717bea274a0fa88f55b4331 | 20 October 2007, I attended the Rugby World Cup Final in Paris as a guest of Betfair, who paid for my travel and accommodation costs. (Registered 6 March 2008) | Gifts, benefits and hospitality (UK) 84642823 | 2008-04-23 | Richard Caborn uk.org.publicwhip/member/1811 | Richard Caborn uk.org.publicwhip/person/10085 | 0 | 2008-04-23-84642823-10085-0 |
25d6d16f4a809ac93c1ab47cfb91f4a359e303d3 | 20 October 2007, I attended the Rugby World Cup Final in Paris as a guest of Betfair, who paid for my travel and accommodation costs. (Registered 6 March 2008) | Gifts, benefits and hospitality (UK) 84642823 | 2008-03-25 | Richard Caborn uk.org.publicwhip/member/1811 | Richard Caborn uk.org.publicwhip/person/10085 | 0 | 2008-03-25-84642823-10085-0 |
9cf0845bbf9002e206b896cdafab2b69dff5ed41 | 20 October 2007, I attended the Rugby World Cup Final in Paris as a guest of Betfair, who paid for my travel and accommodation costs. (Registered 6 March 2008) | Gifts, benefits and hospitality (UK) 84642823 | 2008-03-11 | Richard Caborn uk.org.publicwhip/member/1811 | Richard Caborn uk.org.publicwhip/person/10085 | 0 | 2008-03-11-84642823-10085-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");