items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
22 rows where category_id = 84642823, member_id = "uk.org.publicwhip/member/1438" and person_id = "uk.org.publicwhip/person/10082" sorted by date descending
This data as json, CSV (advanced)
Suggested facets: date (date)
hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
d2b16d9d70c93fe284b9f2efdf7210cbc786054b | In the course of a non-registrable CPA visit to Botswana, my wife and I were upgraded by Virgin Atlantic on 14 and 21 April 2007. (Registered 25 April 2007) | Gifts, benefits and hospitality (UK) 84642823 | 2008-06-16 | John Butterfill uk.org.publicwhip/member/1438 | John Butterfill uk.org.publicwhip/person/10082 | 0 | 2008-06-16-84642823-10082-0 |
86f8d2fb6cedeef667206b31d0a9380ccea2be15 | In the course of a non-registrable CPA visit to Botswana, my wife and I were upgraded by Virgin Atlantic on 14 and 21 April 2007. (Registered 25 April 2007) | Gifts, benefits and hospitality (UK) 84642823 | 2008-04-23 | John Butterfill uk.org.publicwhip/member/1438 | John Butterfill uk.org.publicwhip/person/10082 | 0 | 2008-04-23-84642823-10082-0 |
a379cfa822e04d9d946326d78484002b5c0f4281 | In the course of a non-registrable CPA visit to Botswana, my wife and I were upgraded by Virgin Atlantic on 14 and 21 April 2007. (Registered 25 April 2007) | Gifts, benefits and hospitality (UK) 84642823 | 2008-03-25 | John Butterfill uk.org.publicwhip/member/1438 | John Butterfill uk.org.publicwhip/person/10082 | 0 | 2008-03-25-84642823-10082-0 |
dcbead4426c50003747f20de77c5ee524d00b87a | In the course of a non-registrable CPA visit to Botswana, my wife and I were upgraded by Virgin Atlantic on 14 and 21 April 2007. (Registered 25 April 2007) | Gifts, benefits and hospitality (UK) 84642823 | 2008-03-11 | John Butterfill uk.org.publicwhip/member/1438 | John Butterfill uk.org.publicwhip/person/10082 | 0 | 2008-03-11-84642823-10082-0 |
51a325b0aafaa9265c23750295d79295c0d57915 | In the course of a non-registrable CPA visit to Botswana, my wife and I were upgraded by Virgin Atlantic on 14 and 21 April 2007. (Registered 25 April 2007) | Gifts, benefits and hospitality (UK) 84642823 | 2008-02-26 | John Butterfill uk.org.publicwhip/member/1438 | John Butterfill uk.org.publicwhip/person/10082 | 0 | 2008-02-26-84642823-10082-0 |
22133964945c60c30fc21750bd87a4a6c4787a3b | In the course of a non-registrable CPA visit to Botswana, my wife and I were upgraded by Virgin Atlantic on 14 and 21 April 2007. (Registered 25 April 2007) | Gifts, benefits and hospitality (UK) 84642823 | 2008-02-05 | John Butterfill uk.org.publicwhip/member/1438 | John Butterfill uk.org.publicwhip/person/10082 | 0 | 2008-02-05-84642823-10082-0 |
325c27d587393b8931a09e83fe8e4e437346a3e6 | In the course of a non-registrable CPA visit to Botswana, my wife and I were upgraded by Virgin Atlantic on 14 and 21 April 2007. (Registered 25 April 2007) | Gifts, benefits and hospitality (UK) 84642823 | 2008-01-22 | John Butterfill uk.org.publicwhip/member/1438 | John Butterfill uk.org.publicwhip/person/10082 | 0 | 2008-01-22-84642823-10082-0 |
bf92ea7a8c83665c5c1430bec7b7c43f53135898 | In the course of a non-registrable CPA visit to Botswana, my wife and I were upgraded by Virgin Atlantic on 14 and 21 April 2007. (Registered 25 April 2007) | Gifts, benefits and hospitality (UK) 84642823 | 2008-01-09 | John Butterfill uk.org.publicwhip/member/1438 | John Butterfill uk.org.publicwhip/person/10082 | 0 | 2008-01-09-84642823-10082-0 |
dd12459fed58a1e8ab03a8095063ce41db1634f2 | In the course of a non-registrable CPA visit to Botswana, my wife and I were upgraded by Virgin Atlantic on 14 and 21 April 2007. (Registered 25 April 2007) | Gifts, benefits and hospitality (UK) 84642823 | 2007-12-18 | John Butterfill uk.org.publicwhip/member/1438 | John Butterfill uk.org.publicwhip/person/10082 | 0 | 2007-12-18-84642823-10082-0 |
10a0306247551546b2ef3476c1f77f371befaa84 | In the course of a non-registrable CPA visit to Botswana, my wife and I were upgraded by Virgin Atlantic on 14 and 21 April 2007. (Registered 25 April 2007) | Gifts, benefits and hospitality (UK) 84642823 | 2007-12-04 | John Butterfill uk.org.publicwhip/member/1438 | John Butterfill uk.org.publicwhip/person/10082 | 0 | 2007-12-04-84642823-10082-0 |
5d1a83faf6efd26a3be36c07e4720adbb080ff8e | In the course of a non-registrable CPA visit to Botswana, my wife and I were upgraded by Virgin Atlantic on 14 and 21 April 2007. (Registered 25 April 2007) | Gifts, benefits and hospitality (UK) 84642823 | 2007-11-20 | John Butterfill uk.org.publicwhip/member/1438 | John Butterfill uk.org.publicwhip/person/10082 | 0 | 2007-11-20-84642823-10082-0 |
3b84d8f94b7c153c94ce782174c664e186854235 | In the course of a non-registrable CPA visit to Botswana, my wife and I were upgraded by Virgin Atlantic on 14 and 21 April 2007. (Registered 25 April 2007) | Gifts, benefits and hospitality (UK) 84642823 | 2007-11-06 | John Butterfill uk.org.publicwhip/member/1438 | John Butterfill uk.org.publicwhip/person/10082 | 0 | 2007-11-06-84642823-10082-0 |
3b7ef27a12fc416040ec4b9024539e32b3664493 | In the course of a non-registrable CPA visit to Botswana, my wife and I were upgraded by Virgin Atlantic on 14 and 21 April 2007. (Registered 25 April 2007) | Gifts, benefits and hospitality (UK) 84642823 | 2007-10-23 | John Butterfill uk.org.publicwhip/member/1438 | John Butterfill uk.org.publicwhip/person/10082 | 0 | 2007-10-23-84642823-10082-0 |
383a8915c013c67a8bb6424cd0a37bac76a2cb65 | In the course of a non-registrable CPA visit to Botswana, my wife and I were upgraded by Virgin Atlantic on 14 and 21 April 2007. (Registered 25 April 2007) | Gifts, benefits and hospitality (UK) 84642823 | 2007-10-09 | John Butterfill uk.org.publicwhip/member/1438 | John Butterfill uk.org.publicwhip/person/10082 | 0 | 2007-10-09-84642823-10082-0 |
a1cd143c64aae88f777e58e5f23de9800ad1c2dd | In the course of a non-registrable CPA visit to Botswana, my wife and I were upgraded by Virgin Atlantic on 14 and 21 April 2007. (Registered 25 April 2007) | Gifts, benefits and hospitality (UK) 84642823 | 2007-08-28 | John Butterfill uk.org.publicwhip/member/1438 | John Butterfill uk.org.publicwhip/person/10082 | 0 | 2007-08-28-84642823-10082-0 |
ff9a24558d538f1cecdb8649dd0db4c682f80524 | In the course of a non-registrable CPA visit to Botswana, my wife and I were upgraded by Virgin Atlantic on 14 and 21 April 2007. (Registered 25 April 2007) | Gifts, benefits and hospitality (UK) 84642823 | 2007-07-30 | John Butterfill uk.org.publicwhip/member/1438 | John Butterfill uk.org.publicwhip/person/10082 | 0 | 2007-07-30-84642823-10082-0 |
90222f9dd635be2add0126498ddf01b36ff85394 | In the course of a non-registrable CPA visit to Botswana, my wife and I were upgraded by Virgin Atlantic on 14 and 21 April 2007. (Registered 25 April 2007) | Gifts, benefits and hospitality (UK) 84642823 | 2007-07-17 | John Butterfill uk.org.publicwhip/member/1438 | John Butterfill uk.org.publicwhip/person/10082 | 0 | 2007-07-17-84642823-10082-0 |
3a6cb54c6a7130b55a834e130a094e4459e138f5 | In the course of a non-registrable CPA visit to Botswana, my wife and I were upgraded by Virgin Atlantic on 14 and 21 April 2007. (Registered 25 April 2007) | Gifts, benefits and hospitality (UK) 84642823 | 2007-07-03 | John Butterfill uk.org.publicwhip/member/1438 | John Butterfill uk.org.publicwhip/person/10082 | 0 | 2007-07-03-84642823-10082-0 |
6e365ae02cfe6246fcda73f4d23b94aac3df46a3 | In the course of a non-registrable CPA visit to Botswana, my wife and I were upgraded by Virgin Atlantic on 14 and 21 April 2007. (Registered 25 April 2007) | Gifts, benefits and hospitality (UK) 84642823 | 2007-06-19 | John Butterfill uk.org.publicwhip/member/1438 | John Butterfill uk.org.publicwhip/person/10082 | 0 | 2007-06-19-84642823-10082-0 |
41b3a8f78c78925aae68d190554a6a344d383740 | In the course of a non-registrable CPA visit to Botswana, my wife and I were upgraded by Virgin Atlantic on 14 and 21 April 2007. (Registered 25 April 2007) | Gifts, benefits and hospitality (UK) 84642823 | 2007-06-05 | John Butterfill uk.org.publicwhip/member/1438 | John Butterfill uk.org.publicwhip/person/10082 | 0 | 2007-06-05-84642823-10082-0 |
a7562607e8f220f0497d5acdd35a83cd2b29279e | In the course of a non-registrable CPA visit to Botswana, my wife and I were upgraded by Virgin Atlantic on 14 and 21 April 2007. (Registered 25 April 2007) | Gifts, benefits and hospitality (UK) 84642823 | 2007-05-15 | John Butterfill uk.org.publicwhip/member/1438 | John Butterfill uk.org.publicwhip/person/10082 | 0 | 2007-05-15-84642823-10082-0 |
329e5cf7ce86dff6cdf973f67925a3955b7352f8 | In the course of a non-registrable CPA visit to Botswana, my wife and I were upgraded by Virgin Atlantic on 14 and 21 April 2007. (Registered 25 April 2007) | Gifts, benefits and hospitality (UK) 84642823 | 2007-05-01 | John Butterfill uk.org.publicwhip/member/1438 | John Butterfill uk.org.publicwhip/person/10082 | 0 | 2007-05-01-84642823-10082-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");