items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
20 rows where item = "1-2 December 2007, to Madrid, for speaking engagement at a meeting of Le Cercle. Travel and one night's hotel accommodation for me and a member of my staff provided by the organisers. (Registered 12 June 2008)" and person_id = "uk.org.publicwhip/person/10031" sorted by sort_order
This data as json, CSV (advanced)
Suggested facets: date (date)
hash | item | category_id | date | member_id | person_id | sort_order ▼ | record_id |
---|---|---|---|---|---|---|---|
046d5365937283f2c068123a9c444bd09c68c155 | 1-2 December 2007, to Madrid, for speaking engagement at a meeting of Le Cercle. Travel and one night's hotel accommodation for me and a member of my staff provided by the organisers. (Registered 12 June 2008) | Overseas visits 80ef1083 | 2008-06-16 | Margaret Beckett uk.org.publicwhip/member/1533 | Margaret Beckett uk.org.publicwhip/person/10031 | 1 | 2008-06-16-80ef1083-10031-0 |
3a9d50c6f4c7f2a00e74b806a1e1df88ec86ac41 | 1-2 December 2007, to Madrid, for speaking engagement at a meeting of Le Cercle. Travel and one night's hotel accommodation for me and a member of my staff provided by the organisers. (Registered 12 June 2008) | Overseas visits 80ef1083 | 2008-07-08 | Margaret Beckett uk.org.publicwhip/member/1533 | Margaret Beckett uk.org.publicwhip/person/10031 | 1 | 2008-07-08-80ef1083-10031-0 |
bfed4c258e429f974e524b833fc59a8761c85b3b | 1-2 December 2007, to Madrid, for speaking engagement at a meeting of Le Cercle. Travel and one night's hotel accommodation for me and a member of my staff provided by the organisers. (Registered 12 June 2008) | Overseas visits 80ef1083 | 2008-07-22 | Margaret Beckett uk.org.publicwhip/member/1533 | Margaret Beckett uk.org.publicwhip/person/10031 | 1 | 2008-07-22-80ef1083-10031-0 |
9cdaeda4f0032accb07e05e855a09ecf9e2896ff | 1-2 December 2007, to Madrid, for speaking engagement at a meeting of Le Cercle. Travel and one night's hotel accommodation for me and a member of my staff provided by the organisers. (Registered 12 June 2008) | Overseas visits 80ef1083 | 2008-09-03 | Margaret Beckett uk.org.publicwhip/member/1533 | Margaret Beckett uk.org.publicwhip/person/10031 | 1 | 2008-09-03-80ef1083-10031-0 |
69d07eb28b495fee03778815cba2fb744cb90a28 | 1-2 December 2007, to Madrid, for speaking engagement at a meeting of Le Cercle. Travel and one night's hotel accommodation for me and a member of my staff provided by the organisers. (Registered 12 June 2008) | Overseas visits 80ef1083 | 2008-10-08 | Margaret Beckett uk.org.publicwhip/member/1533 | Margaret Beckett uk.org.publicwhip/person/10031 | 1 | 2008-10-08-80ef1083-10031-0 |
e11a1c769c17e913d2305f85c5c4224257a2e108 | 1-2 December 2007, to Madrid, for speaking engagement at a meeting of Le Cercle. Travel and one night's hotel accommodation for me and a member of my staff provided by the organisers. (Registered 12 June 2008) | Overseas visits 80ef1083 | 2008-10-22 | Margaret Beckett uk.org.publicwhip/member/1533 | Margaret Beckett uk.org.publicwhip/person/10031 | 1 | 2008-10-22-80ef1083-10031-0 |
7a0096a5445457de795901c49a573e2dbe97eeba | 1-2 December 2007, to Madrid, for speaking engagement at a meeting of Le Cercle. Travel and one night's hotel accommodation for me and a member of my staff provided by the organisers. (Registered 12 June 2008) | Overseas visits 80ef1083 | 2008-11-05 | Margaret Beckett uk.org.publicwhip/member/1533 | Margaret Beckett uk.org.publicwhip/person/10031 | 1 | 2008-11-05-80ef1083-10031-0 |
8669b2b7250b440962480c77a995afa1a5286c48 | 1-2 December 2007, to Madrid, for speaking engagement at a meeting of Le Cercle. Travel and one night's hotel accommodation for me and a member of my staff provided by the organisers. (Registered 12 June 2008) | Overseas visits 80ef1083 | 2008-11-19 | Margaret Beckett uk.org.publicwhip/member/1533 | Margaret Beckett uk.org.publicwhip/person/10031 | 1 | 2008-11-19-80ef1083-10031-0 |
724c37d63fa0f6a3395625a507bcab781627fa04 | 1-2 December 2007, to Madrid, for speaking engagement at a meeting of Le Cercle. Travel and one night's hotel accommodation for me and a member of my staff provided by the organisers. (Registered 12 June 2008) | Overseas visits 80ef1083 | 2008-12-03 | Margaret Beckett uk.org.publicwhip/member/1533 | Margaret Beckett uk.org.publicwhip/person/10031 | 1 | 2008-12-03-80ef1083-10031-0 |
624f2af8ab5a4787dacabb476777bd14e539a66e | 1-2 December 2007, to Madrid, for speaking engagement at a meeting of Le Cercle. Travel and one night's hotel accommodation for me and a member of my staff provided by the organisers. (Registered 12 June 2008) | Overseas visits 80ef1083 | 2008-12-17 | Margaret Beckett uk.org.publicwhip/member/1533 | Margaret Beckett uk.org.publicwhip/person/10031 | 1 | 2008-12-17-80ef1083-10031-0 |
bfb7c86413bf61a0288aa18b87d366f742812630 | 1-2 December 2007, to Madrid, for speaking engagement at a meeting of Le Cercle. Travel and one night's hotel accommodation for me and a member of my staff provided by the organisers. (Registered 12 June 2008) | Overseas visits 80ef1083 | 2009-01-14 | Margaret Beckett uk.org.publicwhip/member/1533 | Margaret Beckett uk.org.publicwhip/person/10031 | 1 | 2009-01-14-80ef1083-10031-0 |
00bea3a445ef8ff48d8e99cd6170aad9548ba339 | 1-2 December 2007, to Madrid, for speaking engagement at a meeting of Le Cercle. Travel and one night's hotel accommodation for me and a member of my staff provided by the organisers. (Registered 12 June 2008) | Overseas visits 80ef1083 | 2009-01-28 | Margaret Beckett uk.org.publicwhip/member/1533 | Margaret Beckett uk.org.publicwhip/person/10031 | 1 | 2009-01-28-80ef1083-10031-0 |
30ac65f6f39100acbbcb55493349de2b423b3f7b | 1-2 December 2007, to Madrid, for speaking engagement at a meeting of Le Cercle. Travel and one night's hotel accommodation for me and a member of my staff provided by the organisers. (Registered 12 June 2008) | Overseas visits 80ef1083 | 2009-02-11 | Margaret Beckett uk.org.publicwhip/member/1533 | Margaret Beckett uk.org.publicwhip/person/10031 | 1 | 2009-02-11-80ef1083-10031-0 |
e6808e633c52412892bc00808e2148dff28f4924 | 1-2 December 2007, to Madrid, for speaking engagement at a meeting of Le Cercle. Travel and one night's hotel accommodation for me and a member of my staff provided by the organisers. (Registered 12 June 2008) | Overseas visits 80ef1083 | 2009-02-25 | Margaret Beckett uk.org.publicwhip/member/1533 | Margaret Beckett uk.org.publicwhip/person/10031 | 1 | 2009-02-25-80ef1083-10031-0 |
3af8b4ea37509e05e03b3dadf13fd5ee2c132363 | 1-2 December 2007, to Madrid, for speaking engagement at a meeting of Le Cercle. Travel and one night's hotel accommodation for me and a member of my staff provided by the organisers. (Registered 12 June 2008) | Overseas visits 80ef1083 | 2009-03-11 | Margaret Beckett uk.org.publicwhip/member/1533 | Margaret Beckett uk.org.publicwhip/person/10031 | 1 | 2009-03-11-80ef1083-10031-0 |
4a170ace0bf4c22f59a0fadb605ea8117a08f644 | 1-2 December 2007, to Madrid, for speaking engagement at a meeting of Le Cercle. Travel and one night's hotel accommodation for me and a member of my staff provided by the organisers. (Registered 12 June 2008) | Overseas visits 80ef1083 | 2009-03-25 | Margaret Beckett uk.org.publicwhip/member/1533 | Margaret Beckett uk.org.publicwhip/person/10031 | 1 | 2009-03-25-80ef1083-10031-0 |
530a81f30e3d7c41ddc100ea161fd7a0a75ef63e | 1-2 December 2007, to Madrid, for speaking engagement at a meeting of Le Cercle. Travel and one night's hotel accommodation for me and a member of my staff provided by the organisers. (Registered 12 June 2008) | Overseas visits 80ef1083 | 2009-04-22 | Margaret Beckett uk.org.publicwhip/member/1533 | Margaret Beckett uk.org.publicwhip/person/10031 | 1 | 2009-04-22-80ef1083-10031-0 |
c2a89f86a981881339aa255da3406d7c70c7b2cd | 1-2 December 2007, to Madrid, for speaking engagement at a meeting of Le Cercle. Travel and one night's hotel accommodation for me and a member of my staff provided by the organisers. (Registered 12 June 2008) | Overseas visits 80ef1083 | 2009-05-06 | Margaret Beckett uk.org.publicwhip/member/1533 | Margaret Beckett uk.org.publicwhip/person/10031 | 1 | 2009-05-06-80ef1083-10031-0 |
1aed9378321fea3f24d1833e95ef779eed5ebcf0 | 1-2 December 2007, to Madrid, for speaking engagement at a meeting of Le Cercle. Travel and one night's hotel accommodation for me and a member of my staff provided by the organisers. (Registered 12 June 2008) | Overseas visits 80ef1083 | 2009-05-20 | Margaret Beckett uk.org.publicwhip/member/1533 | Margaret Beckett uk.org.publicwhip/person/10031 | 1 | 2009-05-20-80ef1083-10031-0 |
14f983479b07ea50b5a33ef83eef2d03a441146e | 1-2 December 2007, to Madrid, for speaking engagement at a meeting of Le Cercle. Travel and one night's hotel accommodation for me and a member of my staff provided by the organisers. (Registered 12 June 2008) | Overseas visits 80ef1083 | 2009-06-10 | Margaret Beckett uk.org.publicwhip/member/1533 | Margaret Beckett uk.org.publicwhip/person/10031 | 1 | 2009-06-10-80ef1083-10031-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");