items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
18 rows where person_id = "uk.org.publicwhip/person/10106" and sort_order = 15 sorted by date
This data as json, CSV (advanced)
Suggested facets: item, date (date)
hash | item | category_id | date ▼ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
995316ef0fae05004b1bd6420dc4ca53a1855157 | (Registered 21 March 2014) | Overseas visits 80ef1083 | 2014-03-21 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 15 | 2014-03-21-80ef1083-10106-0 |
5267ed9d6c512bed8ae79918867d7f60c8e54e3b | (Registered 21 March 2014) | Overseas visits 80ef1083 | 2014-03-24 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 15 | 2014-03-24-80ef1083-10106-0 |
ed1620dcd2b70fad9016c2b6600e26ac25783410 | (Registered 21 March 2014) | Overseas visits 80ef1083 | 2014-04-07 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 15 | 2014-04-07-80ef1083-10106-0 |
93d94b535ec61d01bcbf2977bb4bd524e18211ca | (Registered 21 March 2014) | Overseas visits 80ef1083 | 2014-04-28 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 15 | 2014-04-28-80ef1083-10106-0 |
d3310506a92d4beccd39f7c6c0e0fb54881b7b34 | (Registered 21 March 2014) | Overseas visits 80ef1083 | 2014-05-12 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 15 | 2014-05-12-80ef1083-10106-0 |
65b6ac52a50a2939f903d0ba09e7fed1aff39013 | (Registered 21 March 2014) | Overseas visits 80ef1083 | 2014-06-02 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 15 | 2014-06-02-80ef1083-10106-0 |
dc1ee465423b0178abaeec1e6036ad6038475c5d | (Registered 21 March 2014) | Overseas visits 80ef1083 | 2014-06-16 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 15 | 2014-06-16-80ef1083-10106-0 |
83d65101a03389e4177ceb5b7e73f6070445fb79 | (Registered 21 March 2014) | Overseas visits 80ef1083 | 2014-06-30 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 15 | 2014-06-30-80ef1083-10106-0 |
b571c308b832206bccfbda64580d1f5696dbe60c | (Registered 21 March 2014) | Overseas visits 80ef1083 | 2014-07-14 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 15 | 2014-07-14-80ef1083-10106-0 |
2dbaf8c10bcdd85cb6184fdb173e34b2e26f56eb | (Registered 21 March 2014) | Overseas visits 80ef1083 | 2014-07-28 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 15 | 2014-07-28-80ef1083-10106-0 |
42d95898ff42fef584637ad5833fbe49acb4cf09 | (Registered 21 March 2014) | Overseas visits 80ef1083 | 2014-08-26 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 15 | 2014-08-26-80ef1083-10106-0 |
8458614ef0f8ae0449d493d0b07390497539119b | (Registered 21 March 2014) | Overseas visits 80ef1083 | 2014-09-22 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 15 | 2014-09-22-80ef1083-10106-0 |
944dae492002b3dbd5b5fa585054263dce8ac454 | (Registered 21 March 2014) | Overseas visits 80ef1083 | 2014-10-13 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 15 | 2014-10-13-80ef1083-10106-0 |
ef40f9f7f4cd46223dd157afc633da0426e679d2 | (Registered 21 March 2014) | Overseas visits 80ef1083 | 2014-10-27 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 15 | 2014-10-27-80ef1083-10106-0 |
79f24b73833555ca4554341ecd468fcbbd6ab34e | (Registered 21 March 2014) | Overseas visits 80ef1083 | 2014-11-10 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 15 | 2014-11-10-80ef1083-10106-0 |
dfd6ed1b1ea9ffac9d0aaa42af2a8acefb68d7d3 | (Registered 21 March 2014) | Overseas visits 80ef1083 | 2014-11-24 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 15 | 2014-11-24-80ef1083-10106-0 |
337c5cee702f9784b2c3221e7d7cf33f74691bbc | (Registered 21 March 2014) | Overseas visits 80ef1083 | 2014-12-08 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 15 | 2014-12-08-80ef1083-10106-0 |
93132907acd553bf6c4056afc26002164a40a27c | (Registered 21 March 2014) | Overseas visits 80ef1083 | 2015-01-06 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 15 | 2015-01-06-80ef1083-10106-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");