items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
20 rows where item = "15-17 May 2008, to Guernsey at the invitation of the States of Guernsey, to play a football match with accommodation and hospitality provided by the States of Guernsey and a contribution to the air fare provided by our club sponsors National Grid. (Registered 12 June 2008)" and person_id = "uk.org.publicwhip/person/10329" sorted by date descending
This data as json, CSV (advanced)
Suggested facets: sort_order, date (date)
hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
0bf66d27890f0892d97c7fcb7ab87d0fe7177e68 | 15-17 May 2008, to Guernsey at the invitation of the States of Guernsey, to play a football match with accommodation and hospitality provided by the States of Guernsey and a contribution to the air fare provided by our club sponsors National Grid. (Registered 12 June 2008) | Overseas visits 80ef1083 | 2009-06-10 | Alan Keen uk.org.publicwhip/member/1584 | Alan Keen uk.org.publicwhip/person/10329 | 0 | 2009-06-10-80ef1083-10329-0 |
49a08dab53a37925fa8fd8c27a1541137c3d9bd7 | 15-17 May 2008, to Guernsey at the invitation of the States of Guernsey, to play a football match with accommodation and hospitality provided by the States of Guernsey and a contribution to the air fare provided by our club sponsors National Grid. (Registered 12 June 2008) | Overseas visits 80ef1083 | 2009-05-20 | Alan Keen uk.org.publicwhip/member/1584 | Alan Keen uk.org.publicwhip/person/10329 | 0 | 2009-05-20-80ef1083-10329-0 |
f43544429765c3ef8a67c110d61b6ac75fcfc19a | 15-17 May 2008, to Guernsey at the invitation of the States of Guernsey, to play a football match with accommodation and hospitality provided by the States of Guernsey and a contribution to the air fare provided by our club sponsors National Grid. (Registered 12 June 2008) | Overseas visits 80ef1083 | 2009-05-06 | Alan Keen uk.org.publicwhip/member/1584 | Alan Keen uk.org.publicwhip/person/10329 | 0 | 2009-05-06-80ef1083-10329-0 |
fd245c4ecb35ba8a5427c0e4f87ac67855e1e8bd | 15-17 May 2008, to Guernsey at the invitation of the States of Guernsey, to play a football match with accommodation and hospitality provided by the States of Guernsey and a contribution to the air fare provided by our club sponsors National Grid. (Registered 12 June 2008) | Overseas visits 80ef1083 | 2009-04-22 | Alan Keen uk.org.publicwhip/member/1584 | Alan Keen uk.org.publicwhip/person/10329 | 0 | 2009-04-22-80ef1083-10329-0 |
a62df13172a1861669443defb2a89ce17d24a837 | 15-17 May 2008, to Guernsey at the invitation of the States of Guernsey, to play a football match with accommodation and hospitality provided by the States of Guernsey and a contribution to the air fare provided by our club sponsors National Grid. (Registered 12 June 2008) | Overseas visits 80ef1083 | 2009-03-25 | Alan Keen uk.org.publicwhip/member/1584 | Alan Keen uk.org.publicwhip/person/10329 | 0 | 2009-03-25-80ef1083-10329-0 |
c716d3f1d7f7865682516bcc9159bdb36523ef51 | 15-17 May 2008, to Guernsey at the invitation of the States of Guernsey, to play a football match with accommodation and hospitality provided by the States of Guernsey and a contribution to the air fare provided by our club sponsors National Grid. (Registered 12 June 2008) | Overseas visits 80ef1083 | 2009-03-11 | Alan Keen uk.org.publicwhip/member/1584 | Alan Keen uk.org.publicwhip/person/10329 | 0 | 2009-03-11-80ef1083-10329-0 |
ce17563cc4f6ee153ff0bc43a7290942c0ee6eae | 15-17 May 2008, to Guernsey at the invitation of the States of Guernsey, to play a football match with accommodation and hospitality provided by the States of Guernsey and a contribution to the air fare provided by our club sponsors National Grid. (Registered 12 June 2008) | Overseas visits 80ef1083 | 2009-02-25 | Alan Keen uk.org.publicwhip/member/1584 | Alan Keen uk.org.publicwhip/person/10329 | 0 | 2009-02-25-80ef1083-10329-0 |
b3ffa3298d06e3d59b32ca783a6f198a3d0e9b97 | 15-17 May 2008, to Guernsey at the invitation of the States of Guernsey, to play a football match with accommodation and hospitality provided by the States of Guernsey and a contribution to the air fare provided by our club sponsors National Grid. (Registered 12 June 2008) | Overseas visits 80ef1083 | 2009-02-11 | Alan Keen uk.org.publicwhip/member/1584 | Alan Keen uk.org.publicwhip/person/10329 | 0 | 2009-02-11-80ef1083-10329-0 |
8dff3f1f107f18c6ca3c9c19274f5b12806ee89e | 15-17 May 2008, to Guernsey at the invitation of the States of Guernsey, to play a football match with accommodation and hospitality provided by the States of Guernsey and a contribution to the air fare provided by our club sponsors National Grid. (Registered 12 June 2008) | Overseas visits 80ef1083 | 2009-01-28 | Alan Keen uk.org.publicwhip/member/1584 | Alan Keen uk.org.publicwhip/person/10329 | 0 | 2009-01-28-80ef1083-10329-0 |
60b86cc44c092e7c90a539ce02a5ef2b83119829 | 15-17 May 2008, to Guernsey at the invitation of the States of Guernsey, to play a football match with accommodation and hospitality provided by the States of Guernsey and a contribution to the air fare provided by our club sponsors National Grid. (Registered 12 June 2008) | Overseas visits 80ef1083 | 2009-01-14 | Alan Keen uk.org.publicwhip/member/1584 | Alan Keen uk.org.publicwhip/person/10329 | 0 | 2009-01-14-80ef1083-10329-0 |
c2c94f8768a11ed6bc939b91bcb5506890e654d3 | 15-17 May 2008, to Guernsey at the invitation of the States of Guernsey, to play a football match with accommodation and hospitality provided by the States of Guernsey and a contribution to the air fare provided by our club sponsors National Grid. (Registered 12 June 2008) | Overseas visits 80ef1083 | 2008-12-17 | Alan Keen uk.org.publicwhip/member/1584 | Alan Keen uk.org.publicwhip/person/10329 | 0 | 2008-12-17-80ef1083-10329-0 |
f85c09cba74446a87d436e6d1e5669bbec104b55 | 15-17 May 2008, to Guernsey at the invitation of the States of Guernsey, to play a football match with accommodation and hospitality provided by the States of Guernsey and a contribution to the air fare provided by our club sponsors National Grid. (Registered 12 June 2008) | Overseas visits 80ef1083 | 2008-12-03 | Alan Keen uk.org.publicwhip/member/1584 | Alan Keen uk.org.publicwhip/person/10329 | 0 | 2008-12-03-80ef1083-10329-0 |
05c7a35dc598c5ad8ad8b33795c8c508c6beb1dd | 15-17 May 2008, to Guernsey at the invitation of the States of Guernsey, to play a football match with accommodation and hospitality provided by the States of Guernsey and a contribution to the air fare provided by our club sponsors National Grid. (Registered 12 June 2008) | Overseas visits 80ef1083 | 2008-11-19 | Alan Keen uk.org.publicwhip/member/1584 | Alan Keen uk.org.publicwhip/person/10329 | 0 | 2008-11-19-80ef1083-10329-0 |
6c6c70a3260d0a14d2d819ed8ef20d4040306068 | 15-17 May 2008, to Guernsey at the invitation of the States of Guernsey, to play a football match with accommodation and hospitality provided by the States of Guernsey and a contribution to the air fare provided by our club sponsors National Grid. (Registered 12 June 2008) | Overseas visits 80ef1083 | 2008-11-05 | Alan Keen uk.org.publicwhip/member/1584 | Alan Keen uk.org.publicwhip/person/10329 | 0 | 2008-11-05-80ef1083-10329-0 |
ea42e4fd551be598c5d207f00488cb311758db2a | 15-17 May 2008, to Guernsey at the invitation of the States of Guernsey, to play a football match with accommodation and hospitality provided by the States of Guernsey and a contribution to the air fare provided by our club sponsors National Grid. (Registered 12 June 2008) | Overseas visits 80ef1083 | 2008-10-22 | Alan Keen uk.org.publicwhip/member/1584 | Alan Keen uk.org.publicwhip/person/10329 | 0 | 2008-10-22-80ef1083-10329-0 |
7849247c742929d30bea41cc098666b98289f780 | 15-17 May 2008, to Guernsey at the invitation of the States of Guernsey, to play a football match with accommodation and hospitality provided by the States of Guernsey and a contribution to the air fare provided by our club sponsors National Grid. (Registered 12 June 2008) | Overseas visits 80ef1083 | 2008-10-08 | Alan Keen uk.org.publicwhip/member/1584 | Alan Keen uk.org.publicwhip/person/10329 | 0 | 2008-10-08-80ef1083-10329-0 |
8f69ef39d95352be94ca748bce2fe0ecf1da9a9b | 15-17 May 2008, to Guernsey at the invitation of the States of Guernsey, to play a football match with accommodation and hospitality provided by the States of Guernsey and a contribution to the air fare provided by our club sponsors National Grid. (Registered 12 June 2008) | Overseas visits 80ef1083 | 2008-09-03 | Alan Keen uk.org.publicwhip/member/1584 | Alan Keen uk.org.publicwhip/person/10329 | 0 | 2008-09-03-80ef1083-10329-0 |
b1241d6e2b9afaaa8b7d7caaa4f08950449ced1a | 15-17 May 2008, to Guernsey at the invitation of the States of Guernsey, to play a football match with accommodation and hospitality provided by the States of Guernsey and a contribution to the air fare provided by our club sponsors National Grid. (Registered 12 June 2008) | Overseas visits 80ef1083 | 2008-07-22 | Alan Keen uk.org.publicwhip/member/1584 | Alan Keen uk.org.publicwhip/person/10329 | 0 | 2008-07-22-80ef1083-10329-0 |
0dda95a85201890dd4640d6dc3381a665a1e386e | 15-17 May 2008, to Guernsey at the invitation of the States of Guernsey, to play a football match with accommodation and hospitality provided by the States of Guernsey and a contribution to the air fare provided by our club sponsors National Grid. (Registered 12 June 2008) | Overseas visits 80ef1083 | 2008-07-08 | Alan Keen uk.org.publicwhip/member/1584 | Alan Keen uk.org.publicwhip/person/10329 | 0 | 2008-07-08-80ef1083-10329-0 |
4f6c4cb763246adbe1d5431176756313f52c868f | 15-17 May 2008, to Guernsey at the invitation of the States of Guernsey, to play a football match with accommodation and hospitality provided by the States of Guernsey and a contribution to the air fare provided by our club sponsors National Grid. (Registered 12 June 2008) | Overseas visits 80ef1083 | 2008-06-16 | Alan Keen uk.org.publicwhip/member/1584 | Alan Keen uk.org.publicwhip/person/10329 | 1 | 2008-06-16-80ef1083-10329-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");